SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000466s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1065 LIMIT 1 [ RunTime:0.000216s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000416s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 1065 [ RunTime:0.000181s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.000668s ]
SELECT `goods_id` FROM `tp_goods` WHERE `is_on_sale` = 1 AND `exchange_integral` = 0 AND `cat_id` IN (1065,1067,1068) [ RunTime:0.000427s ]
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.000278s ]
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.000279s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.000458s ]
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.000244s ]
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.000183s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.000414s ]
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.000266s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.000422s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.000154s ]
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.000452s ]
SHOW FULL COLUMNS FROM `tp_goods_label` [ RunTime:0.000459s ]
SELECT `label_id`,`label_name` FROM `tp_goods_label` [ RunTime:0.000146s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.000216s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 61704 LIMIT 1 [ RunTime:0.000172s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 40459 LIMIT 1 [ RunTime:0.000155s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 44559 LIMIT 1 [ RunTime:0.000151s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 51472 LIMIT 1 [ RunTime:0.000151s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 44316 LIMIT 1 [ RunTime:0.000150s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 63262 LIMIT 1 [ RunTime:0.000152s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 57130 LIMIT 1 [ RunTime:0.000150s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 57131 LIMIT 1 [ RunTime:0.000166s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 57132 LIMIT 1 [ RunTime:0.000159s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 46125 LIMIT 1 [ RunTime:0.000171s ]
