SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000704s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 965 LIMIT 1 [ RunTime:0.000235s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 957 ORDER BY `sort_order` DESC LIMIT 1 [ RunTime:0.000212s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000411s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 965 [ RunTime:0.000181s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.000902s ]
SELECT `goods_id` FROM `tp_goods` WHERE `is_on_sale` = 1 AND `exchange_integral` = 0 AND `cat_id` = 965 [ RunTime:0.000628s ]
SELECT `zs_price` FROM `tp_goods` WHERE `goods_id` IN (30972,30973,30974,30976,30978,35234,37049,37196,37724,37725,38270,38626,39387,39595,39935,40982,42382,42489,42538,42773,43285,44174,44742,44778,45453,45509,45591,45710,46182,46403,46405,46946,47069,47072,47106,48930,49382,49665,49894,50375,50429,50750,50898,51131,51132,51162,53310,54194,54769,55041,55523,55549,56028,56164,56298,57564,58478,59012,59028,59491,60145,60153,60155,60156,60369,60751,60752,63914,64132,65242,65275,65850,65974,66007,66330,68102,68995,69072,69231,69232,69233) [ RunTime:0.000802s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (30972,30973,30974,30976,30978,35234,37049,37196,37724,37725,38270,38626,39387,39595,39935,40982,42382,42489,42538,42773,43285,44174,44742,44778,45453,45509,45591,45710,46182,46403,46405,46946,47069,47072,47106,48930,49382,49665,49894,50375,50429,50750,50898,51131,51132,51162,53310,54194,54769,55041,55523,55549,56028,56164,56298,57564,58478,59012,59028,59491,60145,60153,60155,60156,60369,60751,60752,63914,64132,65242,65275,65850,65974,66007,66330,68102,68995,69072,69231,69232,69233) AND `brand_id` > 0 [ RunTime:0.000929s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.000602s ]
SELECT * FROM `tp_brand` WHERE `id` IN (4435,4495,4449,4515,4446,4444,4434,6661,5931,7215) GROUP BY `name` LIMIT 30 [ RunTime:0.001604s ]
select group_concat(`key` separator '_') as `key` from tp_spec_goods_price where goods_id in(30972,30973,30974,30976,30978,35234,37049,37196,37724,37725,38270,38626,39387,39595,39935,40982,42382,42489,42538,42773,43285,44174,44742,44778,45453,45509,45591,45710,46182,46403,46405,46946,47069,47072,47106,48930,49382,49665,49894,50375,50429,50750,50898,51131,51132,51162,53310,54194,54769,55041,55523,55549,56028,56164,56298,57564,58478,59012,59028,59491,60145,60153,60155,60156,60369,60751,60752,63914,64132,65242,65275,65850,65974,66007,66330,68102,68995,69072,69231,69232,69233) [ RunTime:0.000308s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.000529s ]
SELECT * FROM `tp_goods_attr` WHERE `goods_id` IN (30972,30973,30974,30976,30978,35234,37049,37196,37724,37725,38270,38626,39387,39595,39935,40982,42382,42489,42538,42773,43285,44174,44742,44778,45453,45509,45591,45710,46182,46403,46405,46946,47069,47072,47106,48930,49382,49665,49894,50375,50429,50750,50898,51131,51132,51162,53310,54194,54769,55041,55523,55549,56028,56164,56298,57564,58478,59012,59028,59491,60145,60153,60155,60156,60369,60751,60752,63914,64132,65242,65275,65850,65974,66007,66330,68102,68995,69072,69231,69232,69233) AND `attr_value` <> '' [ RunTime:0.000931s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.000565s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.000189s ]
SELECT * FROM `tp_goods` WHERE `goods_id` IN (30972,30973,30974,30976,30978,35234,37049,37196,37724,37725,38270,38626,39387,39595,39935,40982,42382,42489,42538,42773,43285,44174,44742,44778,45453,45509,45591,45710,46182,46403,46405,46946,47069,47072,47106,48930,49382,49665,49894,50375,50429,50750,50898,51131,51132,51162,53310,54194,54769,55041,55523,55549,56028,56164,56298,57564,58478,59012,59028,59491,60145,60153,60155,60156,60369,60751,60752,63914,64132,65242,65275,65850,65974,66007,66330,68102,68995,69072,69231,69232,69233) ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.001267s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000544s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (30976,49665,55041,30978,47106,68102,42773,43285,40982,45591) [ RunTime:0.001305s ]
SHOW FULL COLUMNS FROM `tp_goods_label` [ RunTime:0.000751s ]
SELECT `label_id`,`label_name` FROM `tp_goods_label` [ RunTime:0.000268s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.000372s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30976 LIMIT 1 [ RunTime:0.000414s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 49665 LIMIT 1 [ RunTime:0.000417s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 55041 LIMIT 1 [ RunTime:0.001017s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30978 LIMIT 1 [ RunTime:0.000386s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 47106 LIMIT 1 [ RunTime:0.000453s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 68102 LIMIT 1 [ RunTime:0.000364s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 42773 LIMIT 1 [ RunTime:0.000234s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 43285 LIMIT 1 [ RunTime:0.000235s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 40982 LIMIT 1 [ RunTime:0.000227s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 45591 LIMIT 1 [ RunTime:0.000214s ]