SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000844s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1065 LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.004024s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 1065 [ RunTime:0.000235s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.000977s ]
SELECT `goods_id` FROM `tp_goods` WHERE `is_on_sale` = 1 AND `exchange_integral` = 0 AND `cat_id` IN (1065,1067,1068) [ RunTime:0.000540s ]
SELECT `zs_price` FROM `tp_goods` WHERE `goods_id` IN (31344,31347,33233,33237,33240,39327,39603,40191,40413,40459,41305,42901,43222,44316,44559,45289,46125,46402,49599,51289,51472,51845,53737,54125,57130,57131,57132,57582,61353,61704,61753,62180,62358,63262,63803,64464,64684) [ RunTime:0.000593s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (31344,31347,33233,33237,33240,39327,39603,40191,40413,40459,41305,42901,43222,44316,44559,45289,46125,46402,49599,51289,51472,51845,53737,54125,57130,57131,57132,57582,61353,61704,61753,62180,62358,63262,63803,64464,64684) AND `brand_id` > 0 [ RunTime:0.001327s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.001438s ]
SELECT * FROM `tp_brand` WHERE `id` IN (4753,4478,4560,4487,5660,6266,6926,5918,4936,6135,4791,4874) GROUP BY `name` LIMIT 30 [ RunTime:0.001230s ]
select group_concat(`key` separator '_') as `key` from tp_spec_goods_price where goods_id in(31344,31347,33233,33237,33240,39327,39603,40191,40413,40459,41305,42901,43222,44316,44559,45289,46125,46402,49599,51289,51472,51845,53737,54125,57130,57131,57132,57582,61353,61704,61753,62180,62358,63262,63803,64464,64684) [ RunTime:0.000871s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.000553s ]
SELECT * FROM `tp_goods_attr` WHERE `goods_id` IN (31344,31347,33233,33237,33240,39327,39603,40191,40413,40459,41305,42901,43222,44316,44559,45289,46125,46402,49599,51289,51472,51845,53737,54125,57130,57131,57132,57582,61353,61704,61753,62180,62358,63262,63803,64464,64684) AND `attr_value` <> '' [ RunTime:0.000336s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.000529s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.000215s ]
SELECT * FROM `tp_goods` WHERE `goods_id` IN (31344,31347,33233,33237,33240,39327,39603,40191,40413,40459,41305,42901,43222,44316,44559,45289,46125,46402,49599,51289,51472,51845,53737,54125,57130,57131,57132,57582,61353,61704,61753,62180,62358,63262,63803,64464,64684) ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.000678s ]
SHOW FULL COLUMNS FROM `tp_goods_label` [ RunTime:0.001809s ]
SELECT `label_id`,`label_name` FROM `tp_goods_label` [ RunTime:0.000200s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.000298s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 61704 LIMIT 1 [ RunTime:0.000378s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 40459 LIMIT 1 [ RunTime:0.001182s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 44559 LIMIT 1 [ RunTime:0.000496s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 51472 LIMIT 1 [ RunTime:0.000433s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 44316 LIMIT 1 [ RunTime:0.000287s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 63262 LIMIT 1 [ RunTime:0.000437s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 57130 LIMIT 1 [ RunTime:0.000360s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 57131 LIMIT 1 [ RunTime:0.000501s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 57132 LIMIT 1 [ RunTime:0.000283s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 46125 LIMIT 1 [ RunTime:0.000282s ]
