SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000717s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1147 LIMIT 1 [ RunTime:0.000280s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1139 ORDER BY `sort_order` DESC LIMIT 1 [ RunTime:0.000287s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000588s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 1147 [ RunTime:0.000338s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.000955s ]
SELECT `goods_id` FROM `tp_goods` WHERE `is_on_sale` = 1 AND `exchange_integral` = 0 AND `cat_id` = 1147 [ RunTime:0.000950s ]
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) [ RunTime:0.001737s ]
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) AND `brand_id` > 0 [ RunTime:0.002046s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.000488s ]
SELECT * FROM `tp_brand` WHERE `id` IN (4900,4952,4901,5162,5219,5494,4875,5772,6266,5883,6308,5359,7139,5531,7224,5478,5287,5960,5908,5961,5142,6285,5283,6024,6693) GROUP BY `name` LIMIT 30 [ RunTime:0.001603s ]
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) [ RunTime:0.000293s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.000398s ]
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) AND `attr_value` <> '' [ RunTime:0.001275s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.000484s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.000161s ]
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) ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.001333s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.002467s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (63233,60674,64771,59140,60676,58373,55303,55304,60168,60169) [ RunTime:0.000602s ]
SHOW FULL COLUMNS FROM `tp_goods_label` [ RunTime:0.000552s ]
SELECT `label_id`,`label_name` FROM `tp_goods_label` [ RunTime:0.000220s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.000320s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 63233 LIMIT 1 [ RunTime:0.000347s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 60674 LIMIT 1 [ RunTime:0.000372s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 64771 LIMIT 1 [ RunTime:0.000308s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 59140 LIMIT 1 [ RunTime:0.000302s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 60676 LIMIT 1 [ RunTime:0.000344s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 58373 LIMIT 1 [ RunTime:0.000311s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 55303 LIMIT 1 [ RunTime:0.000314s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 55304 LIMIT 1 [ RunTime:0.000374s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 60168 LIMIT 1 [ RunTime:0.000303s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 60169 LIMIT 1 [ RunTime:0.000318s ]
