SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000735s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1105 LIMIT 1 [ RunTime:0.000886s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1097 ORDER BY `sort_order` DESC LIMIT 1 [ RunTime:0.000275s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000580s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 1105 [ RunTime:0.000255s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.001004s ]
SELECT `goods_id` FROM `tp_goods` WHERE `is_on_sale` = 1 AND `exchange_integral` = 0 AND `cat_id` = 1105 [ RunTime:0.000596s ]
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.000911s ]
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.000706s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.000548s ]
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.000315s ]
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.000272s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.000583s ]
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.000856s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.000587s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.000238s ]
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.001098s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000574s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (50432,60928,66819,47363,63244,47122,57874,66070,58654,58147) [ RunTime:0.000483s ]
SHOW FULL COLUMNS FROM `tp_goods_label` [ RunTime:0.000566s ]
SELECT `label_id`,`label_name` FROM `tp_goods_label` [ RunTime:0.000205s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.000282s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 50432 LIMIT 1 [ RunTime:0.000324s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 60928 LIMIT 1 [ RunTime:0.000282s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 66819 LIMIT 1 [ RunTime:0.000299s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 47363 LIMIT 1 [ RunTime:0.000323s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 63244 LIMIT 1 [ RunTime:0.000315s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 47122 LIMIT 1 [ RunTime:0.000282s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 57874 LIMIT 1 [ RunTime:0.000283s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 66070 LIMIT 1 [ RunTime:0.000255s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 58654 LIMIT 1 [ RunTime:0.000247s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 58147 LIMIT 1 [ RunTime:0.000317s ]
