SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000552s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1097 LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000428s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 1097 [ RunTime:0.000266s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.000680s ]
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.000593s ]
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.000638s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.000833s ]
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.000685s ]
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.000263s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.000415s ]
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.000652s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.000433s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.000159s ]
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.000847s ]
SHOW FULL COLUMNS FROM `tp_goods_label` [ RunTime:0.000446s ]
SELECT `label_id`,`label_name` FROM `tp_goods_label` [ RunTime:0.000150s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.000201s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 50432 LIMIT 1 [ RunTime:0.000303s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 60928 LIMIT 1 [ RunTime:0.000594s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 66819 LIMIT 1 [ RunTime:0.000233s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 47363 LIMIT 1 [ RunTime:0.000237s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 63244 LIMIT 1 [ RunTime:0.000215s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 47122 LIMIT 1 [ RunTime:0.000231s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 57874 LIMIT 1 [ RunTime:0.000212s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 66070 LIMIT 1 [ RunTime:0.000266s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 58654 LIMIT 1 [ RunTime:0.000211s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 58147 LIMIT 1 [ RunTime:0.000218s ]
