SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.005064s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1067 LIMIT 1 [ RunTime:0.003302s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1065 ORDER BY `sort_order` DESC LIMIT 1 [ RunTime:0.009237s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.003015s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 1067 [ RunTime:0.006519s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.005537s ]
SELECT `goods_id` FROM `tp_goods` WHERE `is_on_sale` = 1 AND `exchange_integral` = 0 AND `cat_id` = 1067 [ RunTime:0.018540s ]
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.003653s ]
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.005891s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.003144s ]
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.003840s ]
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.004483s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.004270s ]
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.004369s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.003340s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.004500s ]
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.005557s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.004055s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (61704,40459,44559,51472,44316,63262,57130,57131,57132,46125) [ RunTime:0.021500s ]
SHOW FULL COLUMNS FROM `tp_goods_label` [ RunTime:0.010549s ]
SELECT `label_id`,`label_name` FROM `tp_goods_label` [ RunTime:0.005595s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.008990s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 61704 LIMIT 1 [ RunTime:0.015896s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 40459 LIMIT 1 [ RunTime:0.007752s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 44559 LIMIT 1 [ RunTime:0.008649s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 51472 LIMIT 1 [ RunTime:0.008346s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 44316 LIMIT 1 [ RunTime:0.005133s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 63262 LIMIT 1 [ RunTime:0.005592s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 57130 LIMIT 1 [ RunTime:0.004563s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 57131 LIMIT 1 [ RunTime:0.003622s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 57132 LIMIT 1 [ RunTime:0.002280s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 46125 LIMIT 1 [ RunTime:0.003524s ]
