SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.012341s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1097 LIMIT 1 [ RunTime:0.004241s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.003313s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 1097 [ RunTime:0.004140s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.006348s ]
SELECT `goods_id` FROM `tp_goods` WHERE `is_on_sale` = 1 AND `exchange_integral` = 0 AND `cat_id` IN (1097,1105) [ RunTime:0.005350s ]
SELECT `zs_price` FROM `tp_goods` WHERE `goods_id` IN (39288,31452,31470,33995,36158,36159,40073,40074,42401,42576,43047,43053,45053,45532,46156,47122,47222,47223,47363,48762,48996,49832,50432,50583,50639,52268,52321,54090,55346,55643,55952,55976,56481,56697,56698,56703,56739,57539,57874,58147,58442,58654,59233,59234,59889,60906,60907,60928,63244,64045,65707,65887,66070,66106,66391,66392,66451,66452,66674,66795,66819,67702,68284,69482) [ RunTime:0.006459s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (39288,31452,31470,33995,36158,36159,40073,40074,42401,42576,43047,43053,45053,45532,46156,47122,47222,47223,47363,48762,48996,49832,50432,50583,50639,52268,52321,54090,55346,55643,55952,55976,56481,56697,56698,56703,56739,57539,57874,58147,58442,58654,59233,59234,59889,60906,60907,60928,63244,64045,65707,65887,66070,66106,66391,66392,66451,66452,66674,66795,66819,67702,68284,69482) AND `brand_id` > 0 [ RunTime:0.004066s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.005670s ]
SELECT * FROM `tp_brand` WHERE `id` IN (4755,6326,5351,6330,4450,6329,5959,6040,6328,6502,5328,5009,7165,7139,5221,6466,5377,6236,4986,6065) GROUP BY `name` LIMIT 30 [ RunTime:0.005958s ]
select group_concat(`key` separator '_') as `key` from tp_spec_goods_price where goods_id in(39288,31452,31470,33995,36158,36159,40073,40074,42401,42576,43047,43053,45053,45532,46156,47122,47222,47223,47363,48762,48996,49832,50432,50583,50639,52268,52321,54090,55346,55643,55952,55976,56481,56697,56698,56703,56739,57539,57874,58147,58442,58654,59233,59234,59889,60906,60907,60928,63244,64045,65707,65887,66070,66106,66391,66392,66451,66452,66674,66795,66819,67702,68284,69482) [ RunTime:0.005662s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.006014s ]
SELECT * FROM `tp_goods_attr` WHERE `goods_id` IN (39288,31452,31470,33995,36158,36159,40073,40074,42401,42576,43047,43053,45053,45532,46156,47122,47222,47223,47363,48762,48996,49832,50432,50583,50639,52268,52321,54090,55346,55643,55952,55976,56481,56697,56698,56703,56739,57539,57874,58147,58442,58654,59233,59234,59889,60906,60907,60928,63244,64045,65707,65887,66070,66106,66391,66392,66451,66452,66674,66795,66819,67702,68284,69482) AND `attr_value` <> '' [ RunTime:0.006004s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.005499s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.005606s ]
SELECT * FROM `tp_goods` WHERE `goods_id` IN (39288,31452,31470,33995,36158,36159,40073,40074,42401,42576,43047,43053,45053,45532,46156,47122,47222,47223,47363,48762,48996,49832,50432,50583,50639,52268,52321,54090,55346,55643,55952,55976,56481,56697,56698,56703,56739,57539,57874,58147,58442,58654,59233,59234,59889,60906,60907,60928,63244,64045,65707,65887,66070,66106,66391,66392,66451,66452,66674,66795,66819,67702,68284,69482) ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.004586s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.006229s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (50432,60928,66819,47363,63244,47122,57874,66070,58654,58147) [ RunTime:0.005871s ]
SHOW FULL COLUMNS FROM `tp_goods_label` [ RunTime:0.005840s ]
SELECT `label_id`,`label_name` FROM `tp_goods_label` [ RunTime:0.005344s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.002236s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 50432 LIMIT 1 [ RunTime:0.005427s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 60928 LIMIT 1 [ RunTime:0.005534s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 66819 LIMIT 1 [ RunTime:0.002547s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 47363 LIMIT 1 [ RunTime:0.002555s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 63244 LIMIT 1 [ RunTime:0.004588s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 47122 LIMIT 1 [ RunTime:0.004812s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 57874 LIMIT 1 [ RunTime:0.005378s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 66070 LIMIT 1 [ RunTime:0.003831s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 58654 LIMIT 1 [ RunTime:0.004293s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 58147 LIMIT 1 [ RunTime:0.003741s ]
