SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000653s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1105 LIMIT 1 [ RunTime:0.000841s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1097 ORDER BY `sort_order` DESC LIMIT 1 [ RunTime:0.000656s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000572s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 1105 [ RunTime:0.000414s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.000829s ]
SELECT `goods_id` FROM `tp_goods` WHERE `is_on_sale` = 1 AND `exchange_integral` = 0 AND `cat_id` = 1105 [ RunTime:0.000428s ]
SELECT `zs_price` FROM `tp_goods` WHERE `goods_id` IN (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.000581s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (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.000614s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.000583s ]
SELECT * FROM `tp_brand` WHERE `id` IN (4755,6326,5351,6330,6329,5959,6040,6328,6502,5328,5009,4450,7165,7139,5221,6466,5377,6236,4986,6065) GROUP BY `name` LIMIT 30 [ RunTime:0.000671s ]
select group_concat(`key` separator '_') as `key` from tp_spec_goods_price where goods_id in(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.000254s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.000399s ]
SELECT * FROM `tp_goods_attr` WHERE `goods_id` IN (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.000632s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.000562s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.000161s ]
SELECT * FROM `tp_goods` WHERE `goods_id` IN (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.000853s ]
SHOW FULL COLUMNS FROM `tp_goods_label` [ RunTime:0.000427s ]
SELECT `label_id`,`label_name` FROM `tp_goods_label` [ RunTime:0.000137s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.000200s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 50432 LIMIT 1 [ RunTime:0.000251s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 60928 LIMIT 1 [ RunTime:0.000211s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 66819 LIMIT 1 [ RunTime:0.000206s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 47363 LIMIT 1 [ RunTime:0.000248s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 63244 LIMIT 1 [ RunTime:0.000213s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 47122 LIMIT 1 [ RunTime:0.000237s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 57874 LIMIT 1 [ RunTime:0.000223s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 66070 LIMIT 1 [ RunTime:0.000210s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 58654 LIMIT 1 [ RunTime:0.000311s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 58147 LIMIT 1 [ RunTime:0.000206s ]
