SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.003398s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 974 LIMIT 1 [ RunTime:0.003371s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 959 ORDER BY `sort_order` DESC LIMIT 1 [ RunTime:0.004848s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.008914s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 974 [ RunTime:0.005769s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.006458s ]
SELECT `goods_id` FROM `tp_goods` WHERE `is_on_sale` = 1 AND `exchange_integral` = 0 AND `cat_id` = 974 [ RunTime:0.005574s ]
SELECT `zs_price` FROM `tp_goods` WHERE `goods_id` IN (32509,32511,32513,32529,32530,32531,32535,32538,32541,32542,32544,32545,36183,36345,37277,38141,39043,39044,39348,39351,39352,39360,40046,40103,42787,42788,45235,45366,46104,46335,46909,47075,47577,47584,47661,47717,49384,50251,50408,52551,52808,53941,54812,54813,54814,54815,56765,57252,57506,58370,59909,60783,61079,61297,61577,62294,62663,62664,65049,65849,66650,67330) [ RunTime:0.006127s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (32509,32511,32513,32529,32530,32531,32535,32538,32541,32542,32544,32545,36183,36345,37277,38141,39043,39044,39348,39351,39352,39360,40046,40103,42787,42788,45235,45366,46104,46335,46909,47075,47577,47584,47661,47717,49384,50251,50408,52551,52808,53941,54812,54813,54814,54815,56765,57252,57506,58370,59909,60783,61079,61297,61577,62294,62663,62664,65049,65849,66650,67330) AND `brand_id` > 0 [ RunTime:0.009752s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.010623s ]
SELECT * FROM `tp_brand` WHERE `id` IN (4853,4854,4826,5103,4902,4517,5902,4911,4454,7004,7066,5236,5051,6634,5275,5057,8083) GROUP BY `name` LIMIT 30 [ RunTime:0.003939s ]
select group_concat(`key` separator '_') as `key` from tp_spec_goods_price where goods_id in(32509,32511,32513,32529,32530,32531,32535,32538,32541,32542,32544,32545,36183,36345,37277,38141,39043,39044,39348,39351,39352,39360,40046,40103,42787,42788,45235,45366,46104,46335,46909,47075,47577,47584,47661,47717,49384,50251,50408,52551,52808,53941,54812,54813,54814,54815,56765,57252,57506,58370,59909,60783,61079,61297,61577,62294,62663,62664,65049,65849,66650,67330) [ RunTime:0.007811s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.004621s ]
SELECT * FROM `tp_goods_attr` WHERE `goods_id` IN (32509,32511,32513,32529,32530,32531,32535,32538,32541,32542,32544,32545,36183,36345,37277,38141,39043,39044,39348,39351,39352,39360,40046,40103,42787,42788,45235,45366,46104,46335,46909,47075,47577,47584,47661,47717,49384,50251,50408,52551,52808,53941,54812,54813,54814,54815,56765,57252,57506,58370,59909,60783,61079,61297,61577,62294,62663,62664,65049,65849,66650,67330) AND `attr_value` <> '' [ RunTime:0.004186s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.005241s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.003568s ]
SELECT * FROM `tp_goods` WHERE `goods_id` IN (32509,32511,32513,32529,32530,32531,32535,32538,32541,32542,32544,32545,36183,36345,37277,38141,39043,39044,39348,39351,39352,39360,40046,40103,42787,42788,45235,45366,46104,46335,46909,47075,47577,47584,47661,47717,49384,50251,50408,52551,52808,53941,54812,54813,54814,54815,56765,57252,57506,58370,59909,60783,61079,61297,61577,62294,62663,62664,65049,65849,66650,67330) ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.006640s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.002788s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (32513,67330,58370,59909,32529,32530,32531,32535,46104,65049) [ RunTime:0.013620s ]
SHOW FULL COLUMNS FROM `tp_goods_label` [ RunTime:0.003649s ]
SELECT `label_id`,`label_name` FROM `tp_goods_label` [ RunTime:0.005560s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.007403s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32513 LIMIT 1 [ RunTime:0.008429s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 67330 LIMIT 1 [ RunTime:0.009885s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 58370 LIMIT 1 [ RunTime:0.007706s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 59909 LIMIT 1 [ RunTime:0.010437s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32529 LIMIT 1 [ RunTime:0.008199s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32530 LIMIT 1 [ RunTime:0.007803s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32531 LIMIT 1 [ RunTime:0.010272s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32535 LIMIT 1 [ RunTime:0.008551s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 46104 LIMIT 1 [ RunTime:0.009214s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 65049 LIMIT 1 [ RunTime:0.007388s ]
