SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.001522s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1067 LIMIT 1 [ RunTime:0.001494s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1065 ORDER BY `sort_order` DESC LIMIT 1 [ RunTime:0.001183s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000678s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 1067 [ RunTime:0.000256s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.001031s ]
SELECT `goods_id` FROM `tp_goods` WHERE `is_on_sale` = 1 AND `exchange_integral` = 0 AND `cat_id` = 1067 [ RunTime:0.002318s ]
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.001509s ]
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.000706s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.000642s ]
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.000336s ]
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.000277s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.000593s ]
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.000748s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.000620s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.000245s ]
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.001353s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.004028s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (61704,40459,44559,51472,44316,63262,57130,57131,57132,46125) [ RunTime:0.001351s ]
SHOW FULL COLUMNS FROM `tp_goods_label` [ RunTime:0.000550s ]
SELECT `label_id`,`label_name` FROM `tp_goods_label` [ RunTime:0.000204s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.000312s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 61704 LIMIT 1 [ RunTime:0.000496s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 40459 LIMIT 1 [ RunTime:0.000305s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 44559 LIMIT 1 [ RunTime:0.000309s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 51472 LIMIT 1 [ RunTime:0.000326s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 44316 LIMIT 1 [ RunTime:0.000281s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 63262 LIMIT 1 [ RunTime:0.000309s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 57130 LIMIT 1 [ RunTime:0.000284s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 57131 LIMIT 1 [ RunTime:0.000372s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 57132 LIMIT 1 [ RunTime:0.000332s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 46125 LIMIT 1 [ RunTime:0.000812s ]
