SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000454s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1148 LIMIT 1 [ RunTime:0.000172s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1139 ORDER BY `sort_order` DESC LIMIT 1 [ RunTime:0.000220s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000408s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 1148 [ RunTime:0.000183s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.000690s ]
SELECT `goods_id` FROM `tp_goods` WHERE `is_on_sale` = 1 AND `exchange_integral` = 0 AND `cat_id` = 1148 [ RunTime:0.000458s ]
SELECT `zs_price` FROM `tp_goods` WHERE `goods_id` IN (32918,32920,32931,32958,32965,33008,34922,35115,36641,37205,38226,39745,39748,39751,39753,40128,40135,40136,40289,40819,40903,40932,41033,41036,41173,41186,41446,42291,42471,43219,43473,43779,43947,44090,44140,46485,47986,49434,54070,54242,55162,55210,55991,56252,56497,56523,57023,58976,59026,59520,59521,59522,59526,59647,59648,59652,59668,60964,61904,61971,61974,63923,63929,64682,64729,65827,66014,67853,69464) [ RunTime:0.000701s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (32918,32920,32931,32958,32965,33008,34922,35115,36641,37205,38226,39745,39748,39751,39753,40128,40135,40136,40289,40819,40903,40932,41033,41036,41173,41186,41446,42291,42471,43219,43473,43779,43947,44090,44140,46485,47986,49434,54070,54242,55162,55210,55991,56252,56497,56523,57023,58976,59026,59520,59521,59522,59526,59647,59648,59652,59668,60964,61904,61971,61974,63923,63929,64682,64729,65827,66014,67853,69464) AND `brand_id` > 0 [ RunTime:0.000594s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.000397s ]
SELECT * FROM `tp_brand` WHERE `id` IN (4880,4879,5058,4862,4560,5155,5283,5583,5585,5605,5606,5607,4714,6062,5717,5742,5284,6031,5942,6056,6266,6109,6161,7461,5359,4882,6300,5233,5828,7868,4450,5883,8022,5385,5654) GROUP BY `name` LIMIT 30 [ RunTime:0.000666s ]
select group_concat(`key` separator '_') as `key` from tp_spec_goods_price where goods_id in(32918,32920,32931,32958,32965,33008,34922,35115,36641,37205,38226,39745,39748,39751,39753,40128,40135,40136,40289,40819,40903,40932,41033,41036,41173,41186,41446,42291,42471,43219,43473,43779,43947,44090,44140,46485,47986,49434,54070,54242,55162,55210,55991,56252,56497,56523,57023,58976,59026,59520,59521,59522,59526,59647,59648,59652,59668,60964,61904,61971,61974,63923,63929,64682,64729,65827,66014,67853,69464) [ RunTime:0.000248s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.000335s ]
SELECT * FROM `tp_goods_attr` WHERE `goods_id` IN (32918,32920,32931,32958,32965,33008,34922,35115,36641,37205,38226,39745,39748,39751,39753,40128,40135,40136,40289,40819,40903,40932,41033,41036,41173,41186,41446,42291,42471,43219,43473,43779,43947,44090,44140,46485,47986,49434,54070,54242,55162,55210,55991,56252,56497,56523,57023,58976,59026,59520,59521,59522,59526,59647,59648,59652,59668,60964,61904,61971,61974,63923,63929,64682,64729,65827,66014,67853,69464) AND `attr_value` <> '' [ RunTime:0.000517s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.000375s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.000128s ]
SELECT * FROM `tp_goods` WHERE `goods_id` IN (32918,32920,32931,32958,32965,33008,34922,35115,36641,37205,38226,39745,39748,39751,39753,40128,40135,40136,40289,40819,40903,40932,41033,41036,41173,41186,41446,42291,42471,43219,43473,43779,43947,44090,44140,46485,47986,49434,54070,54242,55162,55210,55991,56252,56497,56523,57023,58976,59026,59520,59521,59522,59526,59647,59648,59652,59668,60964,61904,61971,61974,63923,63929,64682,64729,65827,66014,67853,69464) ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.000850s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000346s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (59648,43779,59652,67853,61971,59668,61974,49434,36641,65827) [ RunTime:0.000359s ]
SHOW FULL COLUMNS FROM `tp_goods_label` [ RunTime:0.000360s ]
SELECT `label_id`,`label_name` FROM `tp_goods_label` [ RunTime:0.000101s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.000149s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 59648 LIMIT 1 [ RunTime:0.000275s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 43779 LIMIT 1 [ RunTime:0.000590s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 59652 LIMIT 1 [ RunTime:0.000181s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 67853 LIMIT 1 [ RunTime:0.000148s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 61971 LIMIT 1 [ RunTime:0.000139s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 59668 LIMIT 1 [ RunTime:0.000141s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 61974 LIMIT 1 [ RunTime:0.000158s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 49434 LIMIT 1 [ RunTime:0.000157s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 36641 LIMIT 1 [ RunTime:0.000144s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 65827 LIMIT 1 [ RunTime:0.000327s ]
