SHOW FULL COLUMNS FROM `tp_wx_user` [ RunTime:0.000963s ]
SELECT * FROM `tp_wx_user` WHERE ( w_token = "xkopzw1490691329" ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000323s ]
SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000671s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 616 LIMIT 1 [ RunTime:0.000191s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000208s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 616 [ RunTime:0.000208s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.001073s ]
SELECT `goods_id` FROM `tp_goods` WHERE ( shop_price >= 0 and shop_price <= 1800 ) [ RunTime:0.192278s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (539,541,3780,5518,6680,14455,14509,16169,16170,18329,20968,22959,23348,25961,28045,33507,35649,36868,40497,43336,43663,46438,46680,46681,46927,47713,56207,61363,62692,65955,69768,78290,79668,80013,80921,85703,86939,87342,87482,91784,92320,92355,95744,95782,97779,98112,98250,100425,108780,109024,110941,110942,112425,122124,125293,128567,129322,134532,137103,139104,150142,151786,152341,164934,174336,187491,187598,188017,194781,198157,2064,2343,2594,2951,3607,4619,4624,4625,4626,6665,7090,7236,7502,8043,8130,8131,8132,8133,8134,8262,8284,13869,13929,13930,14254,14410,14431,14432,14433,14472,14473,14481,15775,15783,15979,16161,16359,16471,18282,20961,20962,20965,21405,21425,21713,21718,21721,22457,22461,22466,22598,24018,24019,24718,25296,25952,25953,25955,25958,25959,25960,28900,32794,32884,33143,33144,33963,34157,38914,38915,39528,39529,40721,41090,41116,41135,41161,41250,41340,43086,43538,43907,44335,44510,44518,45896,47599,53358,55275,60696,60697,61530,62117,63253,63610,69740,74641,74643,75243,75244,75245,78815,78816,79697,80051,80053,80054,80055,80073,80640,80641,85074,85076,85078,85952,85953,86250,86488,86489,86610,87474,87478,87479,89685,90320,92351,92352,93700,94760,95740,96285,96750,104465,105710,106156,106273,110866,111937,111938,111939,111940,112229,113110,113409,114600,115302,115303,115356,115358,115917,116470,116631,116634,117089,119262,120769,121652,122130,125700,126853,129324,132994,135979,136492,137938,139017,140295,145153,145207,145932,153002,156104,156994,172131,178292,179118,180719,180804,180805,180806,180810,180811,180812,180831,180832,180833,180870,180871,180904,180935,180945,181426,181427,181428,181429,181435,181436,181437,181448,181953,181954,181955,181956,181958,181959,181960,181961,181962,181963,181964,181965,181966,181967,181968,181969,181970,181971,181972,181973,181974,181975,181976,181977,182021,182022,182023,182024,182028,182029,182030,182031,182032,182033,182034,182036,183418,183800,183801,183884,184097,187980,187982,187984,187986,188255,192529,197342,199153,202542,568,569,847,1221,1239,1252,1261,2910,3220,3815,3818,4531,4552,4647,4678,4707,5589,5611,5936,6629,6668,6671,6798,7089,7235,7244,7718,7728,7772,8258,8269,8374,8414,13845,13850,13871,14253,14359,14366,14396,14457,14465,14469,15769,15771,15772,16174,16948,16952,16955,17222,17596,17989,18328,18690,18888,18893,18896,20446,20814,20970,20979,21057,21059,22478,22588,22846,22847,22962,25304,25354,25942,25943,25944,25945,25946,25947,25949,27412,28148,28363,28886,28909,29525,30446,30787,30895,32763,32775,33375,33451,33452,33615,33724,33961,33962,34130,34439,34649,34650,35132,35162,35197,35645,36044,37214,39647,40114,40622,40913,41240,43325,44360,44512,44867,45037,45041,45701,46066,46159,46441,46869,47345,47346,55274,61345,61433,62015,62050,62101,62102,62112,63541,66833,69564,69965,73610,73636,73643,74638,75242,75282,75292,76466,76553,77253,77254,77256,78274,78292,78498,78811,78814,79612,79680,80003,80004,80041,80042,80638,80799,84490,84557,85070,85071,85438,85439,85926,85927,85986,86158,88170,88867,88891,89032,89442,89443,89681,89682,89684,92005,92007,92008,92273,92321,94048,94352,94664,96022,96025,96080,97579,97697,97698,98252,98574,99395,99675,100802,103308,103369,103958,104635,105741,106030,107413,108283,108882,108884,109037,109397,110285,110869,110922,112186,112417,112758,113217,114445,114564,115241,115405,116206,116753,117804,117953,118008,118844,119005,119293,119620,119621,120057,121041,121918,121973,122537,123657,123675,123872,125256,125257,125283,126712,126844,126845,127489,128190,128563,128783,129220,129263,130847,131789,131859,131860,134558,134762,134763,136192,136193,136542,136713,136751,137091,137124,137905,138071,138072,138779,138780,139923,140301,140303,140308,140641,141103,141267,141277,141279,141477,141797,141798,141799,142476,143264,143430,143574,144092,144114,144115,144202,144326,145933,145947,145998,147063,147653,147960,147961,149187,151322,151349,151805,152954,153410,153966,154739,155307,155777,162479,163049,163211,164540,164667,168023,170378,175662,176580,177189,178944,180054,180177,180178,180179,180802,180808,180827,180828,180866,180930,181096,181422,181423,181424,181425,181987,182063,182448,182891,182947,183797,183802,183803,183849,184094,184192,184256,184952,185119,187172,187972,187973,189296,194410,194411,194620,194621,194622,194877,196754,196755,197170,197409,197422,197863,198019,198206,198919,199628,200255,200305,201888,201955,201998,1254,4639,5606,5906,6047,13854,14364,14372,14386,14389,14411,15912,16167,16757,16933,16962,16974,17029,17444,17446,18646,18647,18670,18671,18672,18677,18678,20447,21154,21715,22401,24404,24578,24743,24837,25266,28057,28307,28312,30069,30156,31025,31322,31431,31435,32745,33404,33405,33474,33967,33979,34128,34129,34281,34283,34296,34373,35121,35608,37098,38183,40032,40048,40513,40609,40612,40912,41155,43809,45043,45047,45375,45376,45378,45379,45380,46464,47347,47348,56350,59666,59830,60875,60876,60877,61358,61432,61742,62644,62647,63238,63542,63543,63544,65317,68425,70702,72282,74083,74084,74140,74621,74633,75234,75281,75305,75306,76508,76601,76849,77255,77261,78809,78810,78812,79669,79670,79671,79684,79685,79695,79755,79758,80022,80026,80030,80064,80071,80359,80800,84535,84539,85075,85085,85086,85441,85998,86002,86613,86616,86980,87929,88211,89030,89031,89444,90319,90330,90454,90476,90486,90488,90505,92030,92074,92242,93666,94333,94343,94351,94680,95551,95737,95747,95759,95988,95989,95990,95991,95992,95996,95998,96029,96779,97131,97132,97422,98042,98575,98615,98756,99310,99680,100910,103426,103959,104339,104725,104728,106913,108768,110905,110909,110910,112339,112514,113077,113295,113296,114223,114880,115404,115406,115407,117505,117506,117823,118632,118635,119837,120536,120537,120766,121969,126876,129398,129399,129959,130763,130764,130943,132964,133124,133379,134124,134766,136143,136719,136735,136738,136759,137112,137928,137929,138070,138472,138778,138781,139018,139523,140093,141563,142477,142507,143427,143598,144203,144284,144286,144288,144289,144290,144292,144293,144294,144295,144324,145251,145971,146025,147216,147221,147810,149359,152928,153416,153518,153962,154593,155757,155767,155920,161660,163811,171491,172137,173004,180716,181418,183558,187371,187407,193523,193628,196363,197175,197815,198174,198469,199088,201809,202042,202043,202045,3494,5928,5983,6554,7064,7093,7247,7385,7729,7914,7921,8147,15670,15677,15779,15785,15899,15900,16984,19155,20027,22894,24441,24820,25269,25312,25642,28744,30032,30158,31335,32398,33257,33532,33535,33536,33539,33942,34075,34274,34428,34807,35912,35914,35919,36858,37097,39327,39430,41080,41081,41162,42674,43097,44230,46354,46834,47178,47597,48396,48399,59162,59163,59235,61151,61446,62183,62185,65135,70615,70616,73761,75247,75249,75265,75266,75268,75684,76566,77270,85879,86916,86917,88324,88326,88455,88456,89170,89318,94023,95733,95734,95736,95757,95758,95761,95762,95765,96500,96853,97123,97189,104719,104723,104724,108674,108803,109033,109540,109549,110492,110497,110952,110954,110955,110961,112447,113115,115431,115560,115670,116160,116881,117040,117092,117347,117368,117837,119477,119572,119637,120776,121586,122433,123495,123498,124979,126868,129323,131857,132984,132987,133345,133347,133774,136090,136701,136704,137070,137077,137171,141468,141552,143258,143443,143444,144210,144211,145340,145915,145919,147722,148027,149093,149188,149192,149368,149831,149832,153690,159599,162475,166489,170994,171795,174705,178310,178311,179019,179401,180173,181177,186943,186949,186951,186952,186955,186956,186957,186959,186960,186961,187038,187044,187046,187047,187050,187051,187052,187054,187055,187056,187063,187066,187068,187071,187073,187075,187076,187079,187082,187083,187086,187087,187088,187089,187092,187096,187097,187121,187123,187126,187128,187130,187131,187134,187137,187138,187141,187142,187143,187144,187147,187151,187152,187168,187174,187401,187413,187487,187488,187493,187594,187595,187600,187655,187764,187767,187950,187951,187953,187954,187956,187958,187959,187960,187961,187964,187977,188002,188003,188007,188011,188012,188014,188015,188016,188018,188019,188022,188027,188028,188029,188032,188033,188038,188118,188259,188260,188261,188262,188263,188265,188270,189389,189738,191766,193000,193206,194771,197180,197202,197203,197251,197252,197336,198033,198040,198054,198167,198819,199405,199997,200017,200275,200316,200317,200911,200976,200978,200986,200988,200989,200994,200996,200997,200999,201000,201016,201019,201020,201021,201023,201024,201025,201028,201029,201591,201594,201595,201670,201726,1099,1249,3417,3426,3428,3433,3436,3437,3441,3529,4559,4560,4563,4568,4571,4614,4615,4616,5590,5959,5975,5978,5979,7042,7044,7289,7913,8060,8061,8152,8173,11082,13326,13329,14384,14498,15748,15777,16930,16931,16969,18553,18909,21727,25267,25315,27417,33802,34249,34438,34551,34997,36643,36784,37637,40431,42878,48395,76857,78216,78220,78263,78264,87343,91043,91071,108032,110948,120935,126857,126858,126859,126890,128565,129235,129624,136760,137062,137066,142304,144517,145606,149372,151804,152919,153007,164852,168472,187420,187483,187484,187590,187591,187989,187998,188105,188157,189392,189665,189739,194193,197710,200046,590,5888,8328,19305,22443,22448,24106,24107,24108,24110,25317,25318,25321,25359,25758,27378,28162,33372,34039,35068,35072,35075,35076,35078,35079,35093,35098,35179,35186,36531,37639,39435,39436,40096,43632,45790,46786,47202,60589,61482,61501,62035,75375,78253,83679,85852,94706,95719,96134,97232,97349,97355,97513,98359,99292,100803,103325,103901,104350,111655,111679,112617,113370,113705,115497,116390,126079,126084,126085,133519,135638,135639,137636,140196,140617,142532,143572,143573,149014,151782,154912,155413,156022,156458,157003,157518,159194,159647,159654,164341,169434,180937,180938,180939,181086,181447,187207,187213,187218,187219,187221,187225,187228,187229,187232,187247,187250,187253,187258,187259,187260,187262,187267,187273,187274,187276,187277,187278,187279,187284,187285,187299,187304,187306,187308,187336,187337,187338,187339,187342,187345,187772,188047,194184,194195,194290,195272,196641,198993,200234,200292,200297,200977,201794,7501,7990,7993,8010,8012,8013,8014,8279,15739,15740,15745,16998,20442,20505,21033,21034,24242,28497,28498,29493,29495,29496,29520,30035,33964,38056,43387,43494,43636,43637,43722,44537,46811,46814,47432,61706,61707,61708,61709,61710,61711,61712,63112,67072,69376,85951,90896,90897,91765,91785,91786,91787,94406,94773,94777,95741,110054,110056,110672,115175,117087,117944,126849,132930,133993,154563,157193,171501,175264,177246,180936,187489,187596,196948,198154,17002,22895,200970,6559,7597,7613,7766,14347,14385,16168,16928,24662,27418,28051,28080,33032,33616,34254,34272,34352,35646,36592,38098,38101,40094,40541,43510,44275,46389,46572,56272,68394,74080,76468,79667,85123,86225,87391,89168,89432,94350,95738,95739,108028,110055,110945,110946,113460,113729,114791,115297,115571,116754,118939,128566,129368,131834,132081,132985,136761,137063,139820,145595,145879,152921,164477,168096,175113,175114,187064,187119,187481,187588,187997,188106,189394,189395,189555,199610,33807,85888,112435,113845,114073,114074,114075,117287,120123,187238,187239,187270,187341,188046) AND `brand_id` > 0 [ RunTime:0.027435s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.000970s ]
SELECT * FROM `tp_brand` WHERE `id` IN (52,154,57,65,174,116,51,231,230,176,178,177,190,189,619,199,621,618,115,279,267,248,207,289,213,84,285,243,139,217,276,127,61,192,304,186,281,307,140,72,162,286,236,63,342,294,349) LIMIT 30 [ RunTime:0.000310s ]
select group_concat(`key` separator '_') as `key` from tp_spec_goods_price where goods_id in(539,541,3780,5518,6680,14455,14509,16169,16170,18329,20968,22959,23348,25961,28045,33507,35649,36868,40497,43336,43663,46438,46680,46681,46927,47713,56207,61363,62692,65955,69768,78290,79668,80013,80921,85703,86939,87342,87482,91784,92320,92355,95744,95782,97779,98112,98250,100425,108780,109024,110941,110942,112425,122124,125293,128567,129322,134532,137103,139104,150142,151786,152341,164934,174336,187491,187598,188017,194781,198157,2064,2343,2594,2951,3607,4619,4624,4625,4626,6665,7090,7236,7502,8043,8130,8131,8132,8133,8134,8262,8284,13869,13929,13930,14254,14410,14431,14432,14433,14472,14473,14481,15775,15783,15979,16161,16359,16471,18282,20961,20962,20965,21405,21425,21713,21718,21721,22457,22461,22466,22598,24018,24019,24718,25296,25952,25953,25955,25958,25959,25960,28900,32794,32884,33143,33144,33963,34157,38914,38915,39528,39529,40721,41090,41116,41135,41161,41250,41340,43086,43538,43907,44335,44510,44518,45896,47599,53358,55275,60696,60697,61530,62117,63253,63610,69740,74641,74643,75243,75244,75245,78815,78816,79697,80051,80053,80054,80055,80073,80640,80641,85074,85076,85078,85952,85953,86250,86488,86489,86610,87474,87478,87479,89685,90320,92351,92352,93700,94760,95740,96285,96750,104465,105710,106156,106273,110866,111937,111938,111939,111940,112229,113110,113409,114600,115302,115303,115356,115358,115917,116470,116631,116634,117089,119262,120769,121652,122130,125700,126853,129324,132994,135979,136492,137938,139017,140295,145153,145207,145932,153002,156104,156994,172131,178292,179118,180719,180804,180805,180806,180810,180811,180812,180831,180832,180833,180870,180871,180904,180935,180945,181426,181427,181428,181429,181435,181436,181437,181448,181953,181954,181955,181956,181958,181959,181960,181961,181962,181963,181964,181965,181966,181967,181968,181969,181970,181971,181972,181973,181974,181975,181976,181977,182021,182022,182023,182024,182028,182029,182030,182031,182032,182033,182034,182036,183418,183800,183801,183884,184097,187980,187982,187984,187986,188255,192529,197342,199153,202542,568,569,847,1221,1239,1252,1261,2910,3220,3815,3818,4531,4552,4647,4678,4707,5589,5611,5936,6629,6668,6671,6798,7089,7235,7244,7718,7728,7772,8258,8269,8374,8414,13845,13850,13871,14253,14359,14366,14396,14457,14465,14469,15769,15771,15772,16174,16948,16952,16955,17222,17596,17989,18328,18690,18888,18893,18896,20446,20814,20970,20979,21057,21059,22478,22588,22846,22847,22962,25304,25354,25942,25943,25944,25945,25946,25947,25949,27412,28148,28363,28886,28909,29525,30446,30787,30895,32763,32775,33375,33451,33452,33615,33724,33961,33962,34130,34439,34649,34650,35132,35162,35197,35645,36044,37214,39647,40114,40622,40913,41240,43325,44360,44512,44867,45037,45041,45701,46066,46159,46441,46869,47345,47346,55274,61345,61433,62015,62050,62101,62102,62112,63541,66833,69564,69965,73610,73636,73643,74638,75242,75282,75292,76466,76553,77253,77254,77256,78274,78292,78498,78811,78814,79612,79680,80003,80004,80041,80042,80638,80799,84490,84557,85070,85071,85438,85439,85926,85927,85986,86158,88170,88867,88891,89032,89442,89443,89681,89682,89684,92005,92007,92008,92273,92321,94048,94352,94664,96022,96025,96080,97579,97697,97698,98252,98574,99395,99675,100802,103308,103369,103958,104635,105741,106030,107413,108283,108882,108884,109037,109397,110285,110869,110922,112186,112417,112758,113217,114445,114564,115241,115405,116206,116753,117804,117953,118008,118844,119005,119293,119620,119621,120057,121041,121918,121973,122537,123657,123675,123872,125256,125257,125283,126712,126844,126845,127489,128190,128563,128783,129220,129263,130847,131789,131859,131860,134558,134762,134763,136192,136193,136542,136713,136751,137091,137124,137905,138071,138072,138779,138780,139923,140301,140303,140308,140641,141103,141267,141277,141279,141477,141797,141798,141799,142476,143264,143430,143574,144092,144114,144115,144202,144326,145933,145947,145998,147063,147653,147960,147961,149187,151322,151349,151805,152954,153410,153966,154739,155307,155777,162479,163049,163211,164540,164667,168023,170378,175662,176580,177189,178944,180054,180177,180178,180179,180802,180808,180827,180828,180866,180930,181096,181422,181423,181424,181425,181987,182063,182448,182891,182947,183797,183802,183803,183849,184094,184192,184256,184952,185119,187172,187972,187973,189296,194410,194411,194620,194621,194622,194877,196754,196755,197170,197409,197422,197863,198019,198206,198919,199628,200255,200305,201888,201955,201998,1254,4639,5606,5906,6047,13854,14364,14372,14386,14389,14411,15912,16167,16757,16933,16962,16974,17029,17444,17446,18646,18647,18670,18671,18672,18677,18678,20447,21154,21715,22401,24404,24578,24743,24837,25266,28057,28307,28312,30069,30156,31025,31322,31431,31435,32745,33404,33405,33474,33967,33979,34128,34129,34281,34283,34296,34373,35121,35608,37098,38183,40032,40048,40513,40609,40612,40912,41155,43809,45043,45047,45375,45376,45378,45379,45380,46464,47347,47348,56350,59666,59830,60875,60876,60877,61358,61432,61742,62644,62647,63238,63542,63543,63544,65317,68425,70702,72282,74083,74084,74140,74621,74633,75234,75281,75305,75306,76508,76601,76849,77255,77261,78809,78810,78812,79669,79670,79671,79684,79685,79695,79755,79758,80022,80026,80030,80064,80071,80359,80800,84535,84539,85075,85085,85086,85441,85998,86002,86613,86616,86980,87929,88211,89030,89031,89444,90319,90330,90454,90476,90486,90488,90505,92030,92074,92242,93666,94333,94343,94351,94680,95551,95737,95747,95759,95988,95989,95990,95991,95992,95996,95998,96029,96779,97131,97132,97422,98042,98575,98615,98756,99310,99680,100910,103426,103959,104339,104725,104728,106913,108768,110905,110909,110910,112339,112514,113077,113295,113296,114223,114880,115404,115406,115407,117505,117506,117823,118632,118635,119837,120536,120537,120766,121969,126876,129398,129399,129959,130763,130764,130943,132964,133124,133379,134124,134766,136143,136719,136735,136738,136759,137112,137928,137929,138070,138472,138778,138781,139018,139523,140093,141563,142477,142507,143427,143598,144203,144284,144286,144288,144289,144290,144292,144293,144294,144295,144324,145251,145971,146025,147216,147221,147810,149359,152928,153416,153518,153962,154593,155757,155767,155920,161660,163811,171491,172137,173004,180716,181418,183558,187371,187407,193523,193628,196363,197175,197815,198174,198469,199088,201809,202042,202043,202045,3494,5928,5983,6554,7064,7093,7247,7385,7729,7914,7921,8147,15670,15677,15779,15785,15899,15900,16984,19155,20027,22894,24441,24820,25269,25312,25642,28744,30032,30158,31335,32398,33257,33532,33535,33536,33539,33942,34075,34274,34428,34807,35912,35914,35919,36858,37097,39327,39430,41080,41081,41162,42674,43097,44230,46354,46834,47178,47597,48396,48399,59162,59163,59235,61151,61446,62183,62185,65135,70615,70616,73761,75247,75249,75265,75266,75268,75684,76566,77270,85879,86916,86917,88324,88326,88455,88456,89170,89318,94023,95733,95734,95736,95757,95758,95761,95762,95765,96500,96853,97123,97189,104719,104723,104724,108674,108803,109033,109540,109549,110492,110497,110952,110954,110955,110961,112447,113115,115431,115560,115670,116160,116881,117040,117092,117347,117368,117837,119477,119572,119637,120776,121586,122433,123495,123498,124979,126868,129323,131857,132984,132987,133345,133347,133774,136090,136701,136704,137070,137077,137171,141468,141552,143258,143443,143444,144210,144211,145340,145915,145919,147722,148027,149093,149188,149192,149368,149831,149832,153690,159599,162475,166489,170994,171795,174705,178310,178311,179019,179401,180173,181177,186943,186949,186951,186952,186955,186956,186957,186959,186960,186961,187038,187044,187046,187047,187050,187051,187052,187054,187055,187056,187063,187066,187068,187071,187073,187075,187076,187079,187082,187083,187086,187087,187088,187089,187092,187096,187097,187121,187123,187126,187128,187130,187131,187134,187137,187138,187141,187142,187143,187144,187147,187151,187152,187168,187174,187401,187413,187487,187488,187493,187594,187595,187600,187655,187764,187767,187950,187951,187953,187954,187956,187958,187959,187960,187961,187964,187977,188002,188003,188007,188011,188012,188014,188015,188016,188018,188019,188022,188027,188028,188029,188032,188033,188038,188118,188259,188260,188261,188262,188263,188265,188270,189389,189738,191766,193000,193206,194771,197180,197202,197203,197251,197252,197336,198033,198040,198054,198167,198819,199405,199997,200017,200275,200316,200317,200911,200976,200978,200986,200988,200989,200994,200996,200997,200999,201000,201016,201019,201020,201021,201023,201024,201025,201028,201029,201591,201594,201595,201670,201726,1099,1249,3417,3426,3428,3433,3436,3437,3441,3529,4559,4560,4563,4568,4571,4614,4615,4616,5590,5959,5975,5978,5979,7042,7044,7289,7913,8060,8061,8152,8173,11082,13326,13329,14384,14498,15748,15777,16930,16931,16969,18553,18909,21727,25267,25315,27417,33802,34249,34438,34551,34997,36643,36784,37637,40431,42878,48395,76857,78216,78220,78263,78264,87343,91043,91071,108032,110948,120935,126857,126858,126859,126890,128565,129235,129624,136760,137062,137066,142304,144517,145606,149372,151804,152919,153007,164852,168472,187420,187483,187484,187590,187591,187989,187998,188105,188157,189392,189665,189739,194193,197710,200046,590,5888,8328,19305,22443,22448,24106,24107,24108,24110,25317,25318,25321,25359,25758,27378,28162,33372,34039,35068,35072,35075,35076,35078,35079,35093,35098,35179,35186,36531,37639,39435,39436,40096,43632,45790,46786,47202,60589,61482,61501,62035,75375,78253,83679,85852,94706,95719,96134,97232,97349,97355,97513,98359,99292,100803,103325,103901,104350,111655,111679,112617,113370,113705,115497,116390,126079,126084,126085,133519,135638,135639,137636,140196,140617,142532,143572,143573,149014,151782,154912,155413,156022,156458,157003,157518,159194,159647,159654,164341,169434,180937,180938,180939,181086,181447,187207,187213,187218,187219,187221,187225,187228,187229,187232,187247,187250,187253,187258,187259,187260,187262,187267,187273,187274,187276,187277,187278,187279,187284,187285,187299,187304,187306,187308,187336,187337,187338,187339,187342,187345,187772,188047,194184,194195,194290,195272,196641,198993,200234,200292,200297,200977,201794,7501,7990,7993,8010,8012,8013,8014,8279,15739,15740,15745,16998,20442,20505,21033,21034,24242,28497,28498,29493,29495,29496,29520,30035,33964,38056,43387,43494,43636,43637,43722,44537,46811,46814,47432,61706,61707,61708,61709,61710,61711,61712,63112,67072,69376,85951,90896,90897,91765,91785,91786,91787,94406,94773,94777,95741,110054,110056,110672,115175,117087,117944,126849,132930,133993,154563,157193,171501,175264,177246,180936,187489,187596,196948,198154,17002,22895,200970,6559,7597,7613,7766,14347,14385,16168,16928,24662,27418,28051,28080,33032,33616,34254,34272,34352,35646,36592,38098,38101,40094,40541,43510,44275,46389,46572,56272,68394,74080,76468,79667,85123,86225,87391,89168,89432,94350,95738,95739,108028,110055,110945,110946,113460,113729,114791,115297,115571,116754,118939,128566,129368,131834,132081,132985,136761,137063,139820,145595,145879,152921,164477,168096,175113,175114,187064,187119,187481,187588,187997,188106,189394,189395,189555,199610,33807,85888,112435,113845,114073,114074,114075,117287,120123,187238,187239,187270,187341,188046) [ RunTime:0.000841s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.000523s ]
SELECT * FROM `tp_goods_attr` WHERE `goods_id` IN (539,541,3780,5518,6680,14455,14509,16169,16170,18329,20968,22959,23348,25961,28045,33507,35649,36868,40497,43336,43663,46438,46680,46681,46927,47713,56207,61363,62692,65955,69768,78290,79668,80013,80921,85703,86939,87342,87482,91784,92320,92355,95744,95782,97779,98112,98250,100425,108780,109024,110941,110942,112425,122124,125293,128567,129322,134532,137103,139104,150142,151786,152341,164934,174336,187491,187598,188017,194781,198157,2064,2343,2594,2951,3607,4619,4624,4625,4626,6665,7090,7236,7502,8043,8130,8131,8132,8133,8134,8262,8284,13869,13929,13930,14254,14410,14431,14432,14433,14472,14473,14481,15775,15783,15979,16161,16359,16471,18282,20961,20962,20965,21405,21425,21713,21718,21721,22457,22461,22466,22598,24018,24019,24718,25296,25952,25953,25955,25958,25959,25960,28900,32794,32884,33143,33144,33963,34157,38914,38915,39528,39529,40721,41090,41116,41135,41161,41250,41340,43086,43538,43907,44335,44510,44518,45896,47599,53358,55275,60696,60697,61530,62117,63253,63610,69740,74641,74643,75243,75244,75245,78815,78816,79697,80051,80053,80054,80055,80073,80640,80641,85074,85076,85078,85952,85953,86250,86488,86489,86610,87474,87478,87479,89685,90320,92351,92352,93700,94760,95740,96285,96750,104465,105710,106156,106273,110866,111937,111938,111939,111940,112229,113110,113409,114600,115302,115303,115356,115358,115917,116470,116631,116634,117089,119262,120769,121652,122130,125700,126853,129324,132994,135979,136492,137938,139017,140295,145153,145207,145932,153002,156104,156994,172131,178292,179118,180719,180804,180805,180806,180810,180811,180812,180831,180832,180833,180870,180871,180904,180935,180945,181426,181427,181428,181429,181435,181436,181437,181448,181953,181954,181955,181956,181958,181959,181960,181961,181962,181963,181964,181965,181966,181967,181968,181969,181970,181971,181972,181973,181974,181975,181976,181977,182021,182022,182023,182024,182028,182029,182030,182031,182032,182033,182034,182036,183418,183800,183801,183884,184097,187980,187982,187984,187986,188255,192529,197342,199153,202542,568,569,847,1221,1239,1252,1261,2910,3220,3815,3818,4531,4552,4647,4678,4707,5589,5611,5936,6629,6668,6671,6798,7089,7235,7244,7718,7728,7772,8258,8269,8374,8414,13845,13850,13871,14253,14359,14366,14396,14457,14465,14469,15769,15771,15772,16174,16948,16952,16955,17222,17596,17989,18328,18690,18888,18893,18896,20446,20814,20970,20979,21057,21059,22478,22588,22846,22847,22962,25304,25354,25942,25943,25944,25945,25946,25947,25949,27412,28148,28363,28886,28909,29525,30446,30787,30895,32763,32775,33375,33451,33452,33615,33724,33961,33962,34130,34439,34649,34650,35132,35162,35197,35645,36044,37214,39647,40114,40622,40913,41240,43325,44360,44512,44867,45037,45041,45701,46066,46159,46441,46869,47345,47346,55274,61345,61433,62015,62050,62101,62102,62112,63541,66833,69564,69965,73610,73636,73643,74638,75242,75282,75292,76466,76553,77253,77254,77256,78274,78292,78498,78811,78814,79612,79680,80003,80004,80041,80042,80638,80799,84490,84557,85070,85071,85438,85439,85926,85927,85986,86158,88170,88867,88891,89032,89442,89443,89681,89682,89684,92005,92007,92008,92273,92321,94048,94352,94664,96022,96025,96080,97579,97697,97698,98252,98574,99395,99675,100802,103308,103369,103958,104635,105741,106030,107413,108283,108882,108884,109037,109397,110285,110869,110922,112186,112417,112758,113217,114445,114564,115241,115405,116206,116753,117804,117953,118008,118844,119005,119293,119620,119621,120057,121041,121918,121973,122537,123657,123675,123872,125256,125257,125283,126712,126844,126845,127489,128190,128563,128783,129220,129263,130847,131789,131859,131860,134558,134762,134763,136192,136193,136542,136713,136751,137091,137124,137905,138071,138072,138779,138780,139923,140301,140303,140308,140641,141103,141267,141277,141279,141477,141797,141798,141799,142476,143264,143430,143574,144092,144114,144115,144202,144326,145933,145947,145998,147063,147653,147960,147961,149187,151322,151349,151805,152954,153410,153966,154739,155307,155777,162479,163049,163211,164540,164667,168023,170378,175662,176580,177189,178944,180054,180177,180178,180179,180802,180808,180827,180828,180866,180930,181096,181422,181423,181424,181425,181987,182063,182448,182891,182947,183797,183802,183803,183849,184094,184192,184256,184952,185119,187172,187972,187973,189296,194410,194411,194620,194621,194622,194877,196754,196755,197170,197409,197422,197863,198019,198206,198919,199628,200255,200305,201888,201955,201998,1254,4639,5606,5906,6047,13854,14364,14372,14386,14389,14411,15912,16167,16757,16933,16962,16974,17029,17444,17446,18646,18647,18670,18671,18672,18677,18678,20447,21154,21715,22401,24404,24578,24743,24837,25266,28057,28307,28312,30069,30156,31025,31322,31431,31435,32745,33404,33405,33474,33967,33979,34128,34129,34281,34283,34296,34373,35121,35608,37098,38183,40032,40048,40513,40609,40612,40912,41155,43809,45043,45047,45375,45376,45378,45379,45380,46464,47347,47348,56350,59666,59830,60875,60876,60877,61358,61432,61742,62644,62647,63238,63542,63543,63544,65317,68425,70702,72282,74083,74084,74140,74621,74633,75234,75281,75305,75306,76508,76601,76849,77255,77261,78809,78810,78812,79669,79670,79671,79684,79685,79695,79755,79758,80022,80026,80030,80064,80071,80359,80800,84535,84539,85075,85085,85086,85441,85998,86002,86613,86616,86980,87929,88211,89030,89031,89444,90319,90330,90454,90476,90486,90488,90505,92030,92074,92242,93666,94333,94343,94351,94680,95551,95737,95747,95759,95988,95989,95990,95991,95992,95996,95998,96029,96779,97131,97132,97422,98042,98575,98615,98756,99310,99680,100910,103426,103959,104339,104725,104728,106913,108768,110905,110909,110910,112339,112514,113077,113295,113296,114223,114880,115404,115406,115407,117505,117506,117823,118632,118635,119837,120536,120537,120766,121969,126876,129398,129399,129959,130763,130764,130943,132964,133124,133379,134124,134766,136143,136719,136735,136738,136759,137112,137928,137929,138070,138472,138778,138781,139018,139523,140093,141563,142477,142507,143427,143598,144203,144284,144286,144288,144289,144290,144292,144293,144294,144295,144324,145251,145971,146025,147216,147221,147810,149359,152928,153416,153518,153962,154593,155757,155767,155920,161660,163811,171491,172137,173004,180716,181418,183558,187371,187407,193523,193628,196363,197175,197815,198174,198469,199088,201809,202042,202043,202045,3494,5928,5983,6554,7064,7093,7247,7385,7729,7914,7921,8147,15670,15677,15779,15785,15899,15900,16984,19155,20027,22894,24441,24820,25269,25312,25642,28744,30032,30158,31335,32398,33257,33532,33535,33536,33539,33942,34075,34274,34428,34807,35912,35914,35919,36858,37097,39327,39430,41080,41081,41162,42674,43097,44230,46354,46834,47178,47597,48396,48399,59162,59163,59235,61151,61446,62183,62185,65135,70615,70616,73761,75247,75249,75265,75266,75268,75684,76566,77270,85879,86916,86917,88324,88326,88455,88456,89170,89318,94023,95733,95734,95736,95757,95758,95761,95762,95765,96500,96853,97123,97189,104719,104723,104724,108674,108803,109033,109540,109549,110492,110497,110952,110954,110955,110961,112447,113115,115431,115560,115670,116160,116881,117040,117092,117347,117368,117837,119477,119572,119637,120776,121586,122433,123495,123498,124979,126868,129323,131857,132984,132987,133345,133347,133774,136090,136701,136704,137070,137077,137171,141468,141552,143258,143443,143444,144210,144211,145340,145915,145919,147722,148027,149093,149188,149192,149368,149831,149832,153690,159599,162475,166489,170994,171795,174705,178310,178311,179019,179401,180173,181177,186943,186949,186951,186952,186955,186956,186957,186959,186960,186961,187038,187044,187046,187047,187050,187051,187052,187054,187055,187056,187063,187066,187068,187071,187073,187075,187076,187079,187082,187083,187086,187087,187088,187089,187092,187096,187097,187121,187123,187126,187128,187130,187131,187134,187137,187138,187141,187142,187143,187144,187147,187151,187152,187168,187174,187401,187413,187487,187488,187493,187594,187595,187600,187655,187764,187767,187950,187951,187953,187954,187956,187958,187959,187960,187961,187964,187977,188002,188003,188007,188011,188012,188014,188015,188016,188018,188019,188022,188027,188028,188029,188032,188033,188038,188118,188259,188260,188261,188262,188263,188265,188270,189389,189738,191766,193000,193206,194771,197180,197202,197203,197251,197252,197336,198033,198040,198054,198167,198819,199405,199997,200017,200275,200316,200317,200911,200976,200978,200986,200988,200989,200994,200996,200997,200999,201000,201016,201019,201020,201021,201023,201024,201025,201028,201029,201591,201594,201595,201670,201726,1099,1249,3417,3426,3428,3433,3436,3437,3441,3529,4559,4560,4563,4568,4571,4614,4615,4616,5590,5959,5975,5978,5979,7042,7044,7289,7913,8060,8061,8152,8173,11082,13326,13329,14384,14498,15748,15777,16930,16931,16969,18553,18909,21727,25267,25315,27417,33802,34249,34438,34551,34997,36643,36784,37637,40431,42878,48395,76857,78216,78220,78263,78264,87343,91043,91071,108032,110948,120935,126857,126858,126859,126890,128565,129235,129624,136760,137062,137066,142304,144517,145606,149372,151804,152919,153007,164852,168472,187420,187483,187484,187590,187591,187989,187998,188105,188157,189392,189665,189739,194193,197710,200046,590,5888,8328,19305,22443,22448,24106,24107,24108,24110,25317,25318,25321,25359,25758,27378,28162,33372,34039,35068,35072,35075,35076,35078,35079,35093,35098,35179,35186,36531,37639,39435,39436,40096,43632,45790,46786,47202,60589,61482,61501,62035,75375,78253,83679,85852,94706,95719,96134,97232,97349,97355,97513,98359,99292,100803,103325,103901,104350,111655,111679,112617,113370,113705,115497,116390,126079,126084,126085,133519,135638,135639,137636,140196,140617,142532,143572,143573,149014,151782,154912,155413,156022,156458,157003,157518,159194,159647,159654,164341,169434,180937,180938,180939,181086,181447,187207,187213,187218,187219,187221,187225,187228,187229,187232,187247,187250,187253,187258,187259,187260,187262,187267,187273,187274,187276,187277,187278,187279,187284,187285,187299,187304,187306,187308,187336,187337,187338,187339,187342,187345,187772,188047,194184,194195,194290,195272,196641,198993,200234,200292,200297,200977,201794,7501,7990,7993,8010,8012,8013,8014,8279,15739,15740,15745,16998,20442,20505,21033,21034,24242,28497,28498,29493,29495,29496,29520,30035,33964,38056,43387,43494,43636,43637,43722,44537,46811,46814,47432,61706,61707,61708,61709,61710,61711,61712,63112,67072,69376,85951,90896,90897,91765,91785,91786,91787,94406,94773,94777,95741,110054,110056,110672,115175,117087,117944,126849,132930,133993,154563,157193,171501,175264,177246,180936,187489,187596,196948,198154,17002,22895,200970,6559,7597,7613,7766,14347,14385,16168,16928,24662,27418,28051,28080,33032,33616,34254,34272,34352,35646,36592,38098,38101,40094,40541,43510,44275,46389,46572,56272,68394,74080,76468,79667,85123,86225,87391,89168,89432,94350,95738,95739,108028,110055,110945,110946,113460,113729,114791,115297,115571,116754,118939,128566,129368,131834,132081,132985,136761,137063,139820,145595,145879,152921,164477,168096,175113,175114,187064,187119,187481,187588,187997,188106,189394,189395,189555,199610,33807,85888,112435,113845,114073,114074,114075,117287,120123,187238,187239,187270,187341,188046) AND `attr_value` <> '' [ RunTime:0.011967s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.000727s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.000168s ]
SELECT * FROM `tp_goods` WHERE `goods_id` IN (539,541,3780,5518,6680,14455,14509,16169,16170,18329,20968,22959,23348,25961,28045,33507,35649,36868,40497,43336,43663,46438,46680,46681,46927,47713,56207,61363,62692,65955,69768,78290,79668,80013,80921,85703,86939,87342,87482,91784,92320,92355,95744,95782,97779,98112,98250,100425,108780,109024,110941,110942,112425,122124,125293,128567,129322,134532,137103,139104,150142,151786,152341,164934,174336,187491,187598,188017,194781,198157,2064,2343,2594,2951,3607,4619,4624,4625,4626,6665,7090,7236,7502,8043,8130,8131,8132,8133,8134,8262,8284,13869,13929,13930,14254,14410,14431,14432,14433,14472,14473,14481,15775,15783,15979,16161,16359,16471,18282,20961,20962,20965,21405,21425,21713,21718,21721,22457,22461,22466,22598,24018,24019,24718,25296,25952,25953,25955,25958,25959,25960,28900,32794,32884,33143,33144,33963,34157,38914,38915,39528,39529,40721,41090,41116,41135,41161,41250,41340,43086,43538,43907,44335,44510,44518,45896,47599,53358,55275,60696,60697,61530,62117,63253,63610,69740,74641,74643,75243,75244,75245,78815,78816,79697,80051,80053,80054,80055,80073,80640,80641,85074,85076,85078,85952,85953,86250,86488,86489,86610,87474,87478,87479,89685,90320,92351,92352,93700,94760,95740,96285,96750,104465,105710,106156,106273,110866,111937,111938,111939,111940,112229,113110,113409,114600,115302,115303,115356,115358,115917,116470,116631,116634,117089,119262,120769,121652,122130,125700,126853,129324,132994,135979,136492,137938,139017,140295,145153,145207,145932,153002,156104,156994,172131,178292,179118,180719,180804,180805,180806,180810,180811,180812,180831,180832,180833,180870,180871,180904,180935,180945,181426,181427,181428,181429,181435,181436,181437,181448,181953,181954,181955,181956,181958,181959,181960,181961,181962,181963,181964,181965,181966,181967,181968,181969,181970,181971,181972,181973,181974,181975,181976,181977,182021,182022,182023,182024,182028,182029,182030,182031,182032,182033,182034,182036,183418,183800,183801,183884,184097,187980,187982,187984,187986,188255,192529,197342,199153,202542,568,569,847,1221,1239,1252,1261,2910,3220,3815,3818,4531,4552,4647,4678,4707,5589,5611,5936,6629,6668,6671,6798,7089,7235,7244,7718,7728,7772,8258,8269,8374,8414,13845,13850,13871,14253,14359,14366,14396,14457,14465,14469,15769,15771,15772,16174,16948,16952,16955,17222,17596,17989,18328,18690,18888,18893,18896,20446,20814,20970,20979,21057,21059,22478,22588,22846,22847,22962,25304,25354,25942,25943,25944,25945,25946,25947,25949,27412,28148,28363,28886,28909,29525,30446,30787,30895,32763,32775,33375,33451,33452,33615,33724,33961,33962,34130,34439,34649,34650,35132,35162,35197,35645,36044,37214,39647,40114,40622,40913,41240,43325,44360,44512,44867,45037,45041,45701,46066,46159,46441,46869,47345,47346,55274,61345,61433,62015,62050,62101,62102,62112,63541,66833,69564,69965,73610,73636,73643,74638,75242,75282,75292,76466,76553,77253,77254,77256,78274,78292,78498,78811,78814,79612,79680,80003,80004,80041,80042,80638,80799,84490,84557,85070,85071,85438,85439,85926,85927,85986,86158,88170,88867,88891,89032,89442,89443,89681,89682,89684,92005,92007,92008,92273,92321,94048,94352,94664,96022,96025,96080,97579,97697,97698,98252,98574,99395,99675,100802,103308,103369,103958,104635,105741,106030,107413,108283,108882,108884,109037,109397,110285,110869,110922,112186,112417,112758,113217,114445,114564,115241,115405,116206,116753,117804,117953,118008,118844,119005,119293,119620,119621,120057,121041,121918,121973,122537,123657,123675,123872,125256,125257,125283,126712,126844,126845,127489,128190,128563,128783,129220,129263,130847,131789,131859,131860,134558,134762,134763,136192,136193,136542,136713,136751,137091,137124,137905,138071,138072,138779,138780,139923,140301,140303,140308,140641,141103,141267,141277,141279,141477,141797,141798,141799,142476,143264,143430,143574,144092,144114,144115,144202,144326,145933,145947,145998,147063,147653,147960,147961,149187,151322,151349,151805,152954,153410,153966,154739,155307,155777,162479,163049,163211,164540,164667,168023,170378,175662,176580,177189,178944,180054,180177,180178,180179,180802,180808,180827,180828,180866,180930,181096,181422,181423,181424,181425,181987,182063,182448,182891,182947,183797,183802,183803,183849,184094,184192,184256,184952,185119,187172,187972,187973,189296,194410,194411,194620,194621,194622,194877,196754,196755,197170,197409,197422,197863,198019,198206,198919,199628,200255,200305,201888,201955,201998,1254,4639,5606,5906,6047,13854,14364,14372,14386,14389,14411,15912,16167,16757,16933,16962,16974,17029,17444,17446,18646,18647,18670,18671,18672,18677,18678,20447,21154,21715,22401,24404,24578,24743,24837,25266,28057,28307,28312,30069,30156,31025,31322,31431,31435,32745,33404,33405,33474,33967,33979,34128,34129,34281,34283,34296,34373,35121,35608,37098,38183,40032,40048,40513,40609,40612,40912,41155,43809,45043,45047,45375,45376,45378,45379,45380,46464,47347,47348,56350,59666,59830,60875,60876,60877,61358,61432,61742,62644,62647,63238,63542,63543,63544,65317,68425,70702,72282,74083,74084,74140,74621,74633,75234,75281,75305,75306,76508,76601,76849,77255,77261,78809,78810,78812,79669,79670,79671,79684,79685,79695,79755,79758,80022,80026,80030,80064,80071,80359,80800,84535,84539,85075,85085,85086,85441,85998,86002,86613,86616,86980,87929,88211,89030,89031,89444,90319,90330,90454,90476,90486,90488,90505,92030,92074,92242,93666,94333,94343,94351,94680,95551,95737,95747,95759,95988,95989,95990,95991,95992,95996,95998,96029,96779,97131,97132,97422,98042,98575,98615,98756,99310,99680,100910,103426,103959,104339,104725,104728,106913,108768,110905,110909,110910,112339,112514,113077,113295,113296,114223,114880,115404,115406,115407,117505,117506,117823,118632,118635,119837,120536,120537,120766,121969,126876,129398,129399,129959,130763,130764,130943,132964,133124,133379,134124,134766,136143,136719,136735,136738,136759,137112,137928,137929,138070,138472,138778,138781,139018,139523,140093,141563,142477,142507,143427,143598,144203,144284,144286,144288,144289,144290,144292,144293,144294,144295,144324,145251,145971,146025,147216,147221,147810,149359,152928,153416,153518,153962,154593,155757,155767,155920,161660,163811,171491,172137,173004,180716,181418,183558,187371,187407,193523,193628,196363,197175,197815,198174,198469,199088,201809,202042,202043,202045,3494,5928,5983,6554,7064,7093,7247,7385,7729,7914,7921,8147,15670,15677,15779,15785,15899,15900,16984,19155,20027,22894,24441,24820,25269,25312,25642,28744,30032,30158,31335,32398,33257,33532,33535,33536,33539,33942,34075,34274,34428,34807,35912,35914,35919,36858,37097,39327,39430,41080,41081,41162,42674,43097,44230,46354,46834,47178,47597,48396,48399,59162,59163,59235,61151,61446,62183,62185,65135,70615,70616,73761,75247,75249,75265,75266,75268,75684,76566,77270,85879,86916,86917,88324,88326,88455,88456,89170,89318,94023,95733,95734,95736,95757,95758,95761,95762,95765,96500,96853,97123,97189,104719,104723,104724,108674,108803,109033,109540,109549,110492,110497,110952,110954,110955,110961,112447,113115,115431,115560,115670,116160,116881,117040,117092,117347,117368,117837,119477,119572,119637,120776,121586,122433,123495,123498,124979,126868,129323,131857,132984,132987,133345,133347,133774,136090,136701,136704,137070,137077,137171,141468,141552,143258,143443,143444,144210,144211,145340,145915,145919,147722,148027,149093,149188,149192,149368,149831,149832,153690,159599,162475,166489,170994,171795,174705,178310,178311,179019,179401,180173,181177,186943,186949,186951,186952,186955,186956,186957,186959,186960,186961,187038,187044,187046,187047,187050,187051,187052,187054,187055,187056,187063,187066,187068,187071,187073,187075,187076,187079,187082,187083,187086,187087,187088,187089,187092,187096,187097,187121,187123,187126,187128,187130,187131,187134,187137,187138,187141,187142,187143,187144,187147,187151,187152,187168,187174,187401,187413,187487,187488,187493,187594,187595,187600,187655,187764,187767,187950,187951,187953,187954,187956,187958,187959,187960,187961,187964,187977,188002,188003,188007,188011,188012,188014,188015,188016,188018,188019,188022,188027,188028,188029,188032,188033,188038,188118,188259,188260,188261,188262,188263,188265,188270,189389,189738,191766,193000,193206,194771,197180,197202,197203,197251,197252,197336,198033,198040,198054,198167,198819,199405,199997,200017,200275,200316,200317,200911,200976,200978,200986,200988,200989,200994,200996,200997,200999,201000,201016,201019,201020,201021,201023,201024,201025,201028,201029,201591,201594,201595,201670,201726,1099,1249,3417,3426,3428,3433,3436,3437,3441,3529,4559,4560,4563,4568,4571,4614,4615,4616,5590,5959,5975,5978,5979,7042,7044,7289,7913,8060,8061,8152,8173,11082,13326,13329,14384,14498,15748,15777,16930,16931,16969,18553,18909,21727,25267,25315,27417,33802,34249,34438,34551,34997,36643,36784,37637,40431,42878,48395,76857,78216,78220,78263,78264,87343,91043,91071,108032,110948,120935,126857,126858,126859,126890,128565,129235,129624,136760,137062,137066,142304,144517,145606,149372,151804,152919,153007,164852,168472,187420,187483,187484,187590,187591,187989,187998,188105,188157,189392,189665,189739,194193,197710,200046,590,5888,8328,19305,22443,22448,24106,24107,24108,24110,25317,25318,25321,25359,25758,27378,28162,33372,34039,35068,35072,35075,35076,35078,35079,35093,35098,35179,35186,36531,37639,39435,39436,40096,43632,45790,46786,47202,60589,61482,61501,62035,75375,78253,83679,85852,94706,95719,96134,97232,97349,97355,97513,98359,99292,100803,103325,103901,104350,111655,111679,112617,113370,113705,115497,116390,126079,126084,126085,133519,135638,135639,137636,140196,140617,142532,143572,143573,149014,151782,154912,155413,156022,156458,157003,157518,159194,159647,159654,164341,169434,180937,180938,180939,181086,181447,187207,187213,187218,187219,187221,187225,187228,187229,187232,187247,187250,187253,187258,187259,187260,187262,187267,187273,187274,187276,187277,187278,187279,187284,187285,187299,187304,187306,187308,187336,187337,187338,187339,187342,187345,187772,188047,194184,194195,194290,195272,196641,198993,200234,200292,200297,200977,201794,7501,7990,7993,8010,8012,8013,8014,8279,15739,15740,15745,16998,20442,20505,21033,21034,24242,28497,28498,29493,29495,29496,29520,30035,33964,38056,43387,43494,43636,43637,43722,44537,46811,46814,47432,61706,61707,61708,61709,61710,61711,61712,63112,67072,69376,85951,90896,90897,91765,91785,91786,91787,94406,94773,94777,95741,110054,110056,110672,115175,117087,117944,126849,132930,133993,154563,157193,171501,175264,177246,180936,187489,187596,196948,198154,17002,22895,200970,6559,7597,7613,7766,14347,14385,16168,16928,24662,27418,28051,28080,33032,33616,34254,34272,34352,35646,36592,38098,38101,40094,40541,43510,44275,46389,46572,56272,68394,74080,76468,79667,85123,86225,87391,89168,89432,94350,95738,95739,108028,110055,110945,110946,113460,113729,114791,115297,115571,116754,118939,128566,129368,131834,132081,132985,136761,137063,139820,145595,145879,152921,164477,168096,175113,175114,187064,187119,187481,187588,187997,188106,189394,189395,189555,199610,33807,85888,112435,113845,114073,114074,114075,117287,120123,187238,187239,187270,187341,188046) ORDER BY `sort` ASC LIMIT 680,20 [ RunTime:0.024039s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000809s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (74080,14432,152928,25952,94048,99680,40032,180832,187232,187488,140641,14433,25953,110945,47713,115297,180833,117089,187489,147810) [ RunTime:0.000368s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.000170s ]
SHOW FULL COLUMNS FROM `tp_ad_position` [ RunTime:0.000513s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000169s ]
SHOW FULL COLUMNS FROM `tp_ad` [ RunTime:0.000490s ]
SELECT * FROM `tp_ad` WHERE ( pid=101 and enabled = 1 and start_time < 1753034400 and end_time > 1753034400 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000178s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000142s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1753034400 and end_time > 1753034400 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000158s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000141s ]
SELECT * FROM `tp_ad` WHERE ( pid=102 and enabled = 1 and start_time < 1753034400 and end_time > 1753034400 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000140s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000127s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1753034400 and end_time > 1753034400 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000139s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000159s ]
SELECT * FROM `tp_ad` WHERE ( pid=103 and enabled = 1 and start_time < 1753034400 and end_time > 1753034400 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000150s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000132s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1753034400 and end_time > 1753034400 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000144s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000144s ]
SELECT * FROM `tp_ad` WHERE ( pid=104 and enabled = 1 and start_time < 1753034400 and end_time > 1753034400 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000138s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000119s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1753034400 and end_time > 1753034400 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000139s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000127s ]
SELECT * FROM `tp_ad` WHERE ( pid=105 and enabled = 1 and start_time < 1753034400 and end_time > 1753034400 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000132s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000141s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1753034400 and end_time > 1753034400 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000135s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000138s ]
SELECT * FROM `tp_ad` WHERE ( pid=106 and enabled = 1 and start_time < 1753034400 and end_time > 1753034400 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000160s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000128s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1753034400 and end_time > 1753034400 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000137s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000147s ]
SELECT * FROM `tp_ad` WHERE ( pid=107 and enabled = 1 and start_time < 1753034400 and end_time > 1753034400 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000142s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000126s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1753034400 and end_time > 1753034400 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000136s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000162s ]
SELECT * FROM `tp_ad` WHERE ( pid=108 and enabled = 1 and start_time < 1753034400 and end_time > 1753034400 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000155s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000148s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1753034400 and end_time > 1753034400 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000164s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000146s ]
SELECT * FROM `tp_ad` WHERE ( pid=109 and enabled = 1 and start_time < 1753034400 and end_time > 1753034400 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000201s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000151s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1753034400 and end_time > 1753034400 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000151s ]
SELECT * FROM `tp_navigation` where is_show = 1 and position = 'top' ORDER BY `sort` DESC [ RunTime:0.000156s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 590 LIMIT 1 [ RunTime:0.000261s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 1072 LIMIT 1 [ RunTime:0.000196s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 2910 LIMIT 1 [ RunTime:0.000226s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 8138 LIMIT 1 [ RunTime:0.000189s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 17704 LIMIT 1 [ RunTime:0.000208s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 74080 LIMIT 1 [ RunTime:0.000258s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 14432 LIMIT 1 [ RunTime:0.000255s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 152928 LIMIT 1 [ RunTime:0.000205s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 25952 LIMIT 1 [ RunTime:0.000188s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 94048 LIMIT 1 [ RunTime:0.000193s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 99680 LIMIT 1 [ RunTime:0.000195s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 40032 LIMIT 1 [ RunTime:0.000202s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 180832 LIMIT 1 [ RunTime:0.000179s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 187232 LIMIT 1 [ RunTime:0.000173s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 187488 LIMIT 1 [ RunTime:0.000185s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 140641 LIMIT 1 [ RunTime:0.000268s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 14433 LIMIT 1 [ RunTime:0.000215s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 25953 LIMIT 1 [ RunTime:0.000187s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 110945 LIMIT 1 [ RunTime:0.000194s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 47713 LIMIT 1 [ RunTime:0.000232s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 115297 LIMIT 1 [ RunTime:0.000234s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 180833 LIMIT 1 [ RunTime:0.000244s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 117089 LIMIT 1 [ RunTime:0.000182s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 187489 LIMIT 1 [ RunTime:0.000184s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 147810 LIMIT 1 [ RunTime:0.000186s ]
select * from `tp_slogan` [ RunTime:0.000130s ]
select * from `tp_article` where cat_id = 1 and is_open=1 limit 5 [ RunTime:0.000159s ]
select * from `tp_article` where cat_id = 2 and is_open=1 limit 5 [ RunTime:0.000143s ]
select * from `tp_article` where cat_id = 3 and is_open=1 limit 5 [ RunTime:0.000133s ]
select * from `tp_article` where cat_id = 4 and is_open=1 limit 5 [ RunTime:0.000131s ]
select * from `tp_article` where cat_id = 5 and is_open=1 limit 5 [ RunTime:0.000151s ]
