SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000607s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1139 LIMIT 1 [ RunTime:0.000195s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000381s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 1139 [ RunTime:0.000137s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.000619s ]
SELECT `goods_id` FROM `tp_goods` WHERE `is_on_sale` = 1 AND `exchange_integral` = 0 AND `cat_id` IN (1139,1147,1148,1149,1150) [ RunTime:0.001083s ]
SELECT `zs_price` FROM `tp_goods` WHERE `goods_id` IN (36216,36218,36642,36643,37256,37461,37731,38186,38352,38639,38701,38827,39003,39286,39341,39496,39497,39546,39733,39743,40072,40902,41348,41762,42342,42344,42375,42376,42462,42463,42561,42702,42822,42878,42928,43858,43914,43915,44251,44352,44353,44666,45092,45093,45428,45484,45539,45629,45773,46046,46325,46413,46488,47186,47234,47451,47578,47968,47970,47978,48503,48814,49585,49587,49613,49663,50194,50231,50379,50711,50761,50879,51149,51641,51722,51893,52086,52303,53348,53349,53350,53351,53679,53853,54264,54266,54947,54998,55193,55303,55304,55870,55872,55874,56311,56851,57013,57033,57472,57511,57966,57967,58126,58229,58373,58953,59017,59018,59019,59025,59140,59210,59230,59379,59477,59523,59584,60117,60119,60168,60169,60284,60286,60520,60674,60676,60963,61021,61100,61247,61427,61428,61560,61826,61991,61992,61993,62430,62695,62736,62737,62742,62743,62967,63233,63376,63382,63383,63388,63809,63864,64525,64699,64700,64771,65023,65184,65352,65409,65445,65705,66011,66012,66135,66174,66208,66209,66754,66762,66763,67128,67857,67858,67959,68018,68169,68334,68408,68449,69428,69429,69470,32918,32920,32931,32958,32965,33008,34922,35115,36641,37205,38226,39745,39748,39751,39753,40128,40135,40136,40289,40819,40903,40932,41033,41036,41173,41186,41446,42291,42471,43219,43473,43779,43947,44090,44140,46485,47986,49434,54070,54242,55162,55210,55991,56252,56497,56523,57023,58976,59026,59520,59521,59522,59526,59647,59648,59652,59668,60964,61904,61971,61974,63923,63929,64682,64729,65827,66014,67853,69464,32085,32102,32109,36207,37195,37274,37324,37325,38640,39372,40577,40645,40948,40990,42604,43107,43897,43945,44222,45537,47067,47096,47479,47555,47561,47758,48021,48049,48249,48251,49081,49435,50948,51775,52396,52717,53079,54080,55164,55273,55793,56268,56492,58336,58977,59020,59169,59669,60016,60434,61000,61034,61242,61545,61895,61964,61967,62738,63937,64798,64858,64928,66045,67851,68804,69066,69427) [ RunTime:0.001750s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (36216,36218,36642,36643,37256,37461,37731,38186,38352,38639,38701,38827,39003,39286,39341,39496,39497,39546,39733,39743,40072,40902,41348,41762,42342,42344,42375,42376,42462,42463,42561,42702,42822,42878,42928,43858,43914,43915,44251,44352,44353,44666,45092,45093,45428,45484,45539,45629,45773,46046,46325,46413,46488,47186,47234,47451,47578,47968,47970,47978,48503,48814,49585,49587,49613,49663,50194,50231,50379,50711,50761,50879,51149,51641,51722,51893,52086,52303,53348,53349,53350,53351,53679,53853,54264,54266,54947,54998,55193,55303,55304,55870,55872,55874,56311,56851,57013,57033,57472,57511,57966,57967,58126,58229,58373,58953,59017,59018,59019,59025,59140,59210,59230,59379,59477,59523,59584,60117,60119,60168,60169,60284,60286,60520,60674,60676,60963,61021,61100,61247,61427,61428,61560,61826,61991,61992,61993,62430,62695,62736,62737,62742,62743,62967,63233,63376,63382,63383,63388,63809,63864,64525,64699,64700,64771,65023,65184,65352,65409,65445,65705,66011,66012,66135,66174,66208,66209,66754,66762,66763,67128,67857,67858,67959,68018,68169,68334,68408,68449,69428,69429,69470,32918,32920,32931,32958,32965,33008,34922,35115,36641,37205,38226,39745,39748,39751,39753,40128,40135,40136,40289,40819,40903,40932,41033,41036,41173,41186,41446,42291,42471,43219,43473,43779,43947,44090,44140,46485,47986,49434,54070,54242,55162,55210,55991,56252,56497,56523,57023,58976,59026,59520,59521,59522,59526,59647,59648,59652,59668,60964,61904,61971,61974,63923,63929,64682,64729,65827,66014,67853,69464,32085,32102,32109,36207,37195,37274,37324,37325,38640,39372,40577,40645,40948,40990,42604,43107,43897,43945,44222,45537,47067,47096,47479,47555,47561,47758,48021,48049,48249,48251,49081,49435,50948,51775,52396,52717,53079,54080,55164,55273,55793,56268,56492,58336,58977,59020,59169,59669,60016,60434,61000,61034,61242,61545,61895,61964,61967,62738,63937,64798,64858,64928,66045,67851,68804,69066,69427) AND `brand_id` > 0 [ RunTime:0.001668s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.000452s ]
SELECT * FROM `tp_brand` WHERE `id` IN (4793,4798,4880,4879,5058,4862,4954,4900,4952,4560,4901,5153,5155,5162,5167,4795,5219,5283,5357,5494,4875,5583,5585,5605,5606,5607,4714,6062,5717,5720,5742,5284,6031,5772,6266,5942,5883,6056,6109,6161,6308,4799,5359,7139,5531,6718,7224,7461,7018,4882,5478,5287,5960,6300,6221,5137,5233,5828,7868,4450,5908,5961,5142,4830,6285,5017,8022,5286,5385,5136,6024,6693,5654) GROUP BY `name` LIMIT 30 [ RunTime:0.002734s ]
select group_concat(`key` separator '_') as `key` from tp_spec_goods_price where goods_id in(36216,36218,36642,36643,37256,37461,37731,38186,38352,38639,38701,38827,39003,39286,39341,39496,39497,39546,39733,39743,40072,40902,41348,41762,42342,42344,42375,42376,42462,42463,42561,42702,42822,42878,42928,43858,43914,43915,44251,44352,44353,44666,45092,45093,45428,45484,45539,45629,45773,46046,46325,46413,46488,47186,47234,47451,47578,47968,47970,47978,48503,48814,49585,49587,49613,49663,50194,50231,50379,50711,50761,50879,51149,51641,51722,51893,52086,52303,53348,53349,53350,53351,53679,53853,54264,54266,54947,54998,55193,55303,55304,55870,55872,55874,56311,56851,57013,57033,57472,57511,57966,57967,58126,58229,58373,58953,59017,59018,59019,59025,59140,59210,59230,59379,59477,59523,59584,60117,60119,60168,60169,60284,60286,60520,60674,60676,60963,61021,61100,61247,61427,61428,61560,61826,61991,61992,61993,62430,62695,62736,62737,62742,62743,62967,63233,63376,63382,63383,63388,63809,63864,64525,64699,64700,64771,65023,65184,65352,65409,65445,65705,66011,66012,66135,66174,66208,66209,66754,66762,66763,67128,67857,67858,67959,68018,68169,68334,68408,68449,69428,69429,69470,32918,32920,32931,32958,32965,33008,34922,35115,36641,37205,38226,39745,39748,39751,39753,40128,40135,40136,40289,40819,40903,40932,41033,41036,41173,41186,41446,42291,42471,43219,43473,43779,43947,44090,44140,46485,47986,49434,54070,54242,55162,55210,55991,56252,56497,56523,57023,58976,59026,59520,59521,59522,59526,59647,59648,59652,59668,60964,61904,61971,61974,63923,63929,64682,64729,65827,66014,67853,69464,32085,32102,32109,36207,37195,37274,37324,37325,38640,39372,40577,40645,40948,40990,42604,43107,43897,43945,44222,45537,47067,47096,47479,47555,47561,47758,48021,48049,48249,48251,49081,49435,50948,51775,52396,52717,53079,54080,55164,55273,55793,56268,56492,58336,58977,59020,59169,59669,60016,60434,61000,61034,61242,61545,61895,61964,61967,62738,63937,64798,64858,64928,66045,67851,68804,69066,69427) [ RunTime:0.000406s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.001221s ]
SELECT * FROM `tp_goods_attr` WHERE `goods_id` IN (36216,36218,36642,36643,37256,37461,37731,38186,38352,38639,38701,38827,39003,39286,39341,39496,39497,39546,39733,39743,40072,40902,41348,41762,42342,42344,42375,42376,42462,42463,42561,42702,42822,42878,42928,43858,43914,43915,44251,44352,44353,44666,45092,45093,45428,45484,45539,45629,45773,46046,46325,46413,46488,47186,47234,47451,47578,47968,47970,47978,48503,48814,49585,49587,49613,49663,50194,50231,50379,50711,50761,50879,51149,51641,51722,51893,52086,52303,53348,53349,53350,53351,53679,53853,54264,54266,54947,54998,55193,55303,55304,55870,55872,55874,56311,56851,57013,57033,57472,57511,57966,57967,58126,58229,58373,58953,59017,59018,59019,59025,59140,59210,59230,59379,59477,59523,59584,60117,60119,60168,60169,60284,60286,60520,60674,60676,60963,61021,61100,61247,61427,61428,61560,61826,61991,61992,61993,62430,62695,62736,62737,62742,62743,62967,63233,63376,63382,63383,63388,63809,63864,64525,64699,64700,64771,65023,65184,65352,65409,65445,65705,66011,66012,66135,66174,66208,66209,66754,66762,66763,67128,67857,67858,67959,68018,68169,68334,68408,68449,69428,69429,69470,32918,32920,32931,32958,32965,33008,34922,35115,36641,37205,38226,39745,39748,39751,39753,40128,40135,40136,40289,40819,40903,40932,41033,41036,41173,41186,41446,42291,42471,43219,43473,43779,43947,44090,44140,46485,47986,49434,54070,54242,55162,55210,55991,56252,56497,56523,57023,58976,59026,59520,59521,59522,59526,59647,59648,59652,59668,60964,61904,61971,61974,63923,63929,64682,64729,65827,66014,67853,69464,32085,32102,32109,36207,37195,37274,37324,37325,38640,39372,40577,40645,40948,40990,42604,43107,43897,43945,44222,45537,47067,47096,47479,47555,47561,47758,48021,48049,48249,48251,49081,49435,50948,51775,52396,52717,53079,54080,55164,55273,55793,56268,56492,58336,58977,59020,59169,59669,60016,60434,61000,61034,61242,61545,61895,61964,61967,62738,63937,64798,64858,64928,66045,67851,68804,69066,69427) AND `attr_value` <> '' [ RunTime:0.001856s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.000479s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.000175s ]
SELECT * FROM `tp_goods` WHERE `goods_id` IN (36216,36218,36642,36643,37256,37461,37731,38186,38352,38639,38701,38827,39003,39286,39341,39496,39497,39546,39733,39743,40072,40902,41348,41762,42342,42344,42375,42376,42462,42463,42561,42702,42822,42878,42928,43858,43914,43915,44251,44352,44353,44666,45092,45093,45428,45484,45539,45629,45773,46046,46325,46413,46488,47186,47234,47451,47578,47968,47970,47978,48503,48814,49585,49587,49613,49663,50194,50231,50379,50711,50761,50879,51149,51641,51722,51893,52086,52303,53348,53349,53350,53351,53679,53853,54264,54266,54947,54998,55193,55303,55304,55870,55872,55874,56311,56851,57013,57033,57472,57511,57966,57967,58126,58229,58373,58953,59017,59018,59019,59025,59140,59210,59230,59379,59477,59523,59584,60117,60119,60168,60169,60284,60286,60520,60674,60676,60963,61021,61100,61247,61427,61428,61560,61826,61991,61992,61993,62430,62695,62736,62737,62742,62743,62967,63233,63376,63382,63383,63388,63809,63864,64525,64699,64700,64771,65023,65184,65352,65409,65445,65705,66011,66012,66135,66174,66208,66209,66754,66762,66763,67128,67857,67858,67959,68018,68169,68334,68408,68449,69428,69429,69470,32918,32920,32931,32958,32965,33008,34922,35115,36641,37205,38226,39745,39748,39751,39753,40128,40135,40136,40289,40819,40903,40932,41033,41036,41173,41186,41446,42291,42471,43219,43473,43779,43947,44090,44140,46485,47986,49434,54070,54242,55162,55210,55991,56252,56497,56523,57023,58976,59026,59520,59521,59522,59526,59647,59648,59652,59668,60964,61904,61971,61974,63923,63929,64682,64729,65827,66014,67853,69464,32085,32102,32109,36207,37195,37274,37324,37325,38640,39372,40577,40645,40948,40990,42604,43107,43897,43945,44222,45537,47067,47096,47479,47555,47561,47758,48021,48049,48249,48251,49081,49435,50948,51775,52396,52717,53079,54080,55164,55273,55793,56268,56492,58336,58977,59020,59169,59669,60016,60434,61000,61034,61242,61545,61895,61964,61967,62738,63937,64798,64858,64928,66045,67851,68804,69066,69427) ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.009825s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000496s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (32085,32102,32109,32918,32920,32931,32958,32965,33008,34922) [ RunTime:0.002662s ]
SHOW FULL COLUMNS FROM `tp_goods_label` [ RunTime:0.000533s ]
SELECT `label_id`,`label_name` FROM `tp_goods_label` [ RunTime:0.000139s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.000222s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32085 LIMIT 1 [ RunTime:0.000294s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32102 LIMIT 1 [ RunTime:0.000224s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32109 LIMIT 1 [ RunTime:0.000230s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32918 LIMIT 1 [ RunTime:0.000213s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32920 LIMIT 1 [ RunTime:0.000228s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32931 LIMIT 1 [ RunTime:0.000211s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32958 LIMIT 1 [ RunTime:0.000228s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32965 LIMIT 1 [ RunTime:0.000208s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33008 LIMIT 1 [ RunTime:0.000212s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 34922 LIMIT 1 [ RunTime:0.000215s ]
