SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000518s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 977 LIMIT 1 [ RunTime:0.000198s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 960 ORDER BY `sort_order` DESC LIMIT 1 [ RunTime:0.000163s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000339s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 977 [ RunTime:0.000145s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.000542s ]
SELECT `goods_id` FROM `tp_goods` WHERE `is_on_sale` = 1 AND `exchange_integral` = 0 AND `cat_id` = 977 [ RunTime:0.000440s ]
SELECT `zs_price` FROM `tp_goods` WHERE `goods_id` IN (31997,32004,32007,34845,34878,35078,36068,36375,36392,36393,36394,36413,36414,36415,36416,36455,36456,37713,38297,38298,38300,38303,38304,38923,39105,39107,39159,39444,40195,40698,41232,41257,42199,42367,42430,42782,43290,45647,45684,45685,45697,47575,48000,48161,48170,48651,49701,49927,50497,51176,51637,52542,53988,54258,55857,55893,57386,57643,58385,59370,59685,60713,60786,60789,61335,62007,65372,67237,67244,67245,68105) [ RunTime:0.001037s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (31997,32004,32007,34845,34878,35078,36068,36375,36392,36393,36394,36413,36414,36415,36416,36455,36456,37713,38297,38298,38300,38303,38304,38923,39105,39107,39159,39444,40195,40698,41232,41257,42199,42367,42430,42782,43290,45647,45684,45685,45697,47575,48000,48161,48170,48651,49701,49927,50497,51176,51637,52542,53988,54258,55857,55893,57386,57643,58385,59370,59685,60713,60786,60789,61335,62007,65372,67237,67244,67245,68105) AND `brand_id` > 0 [ RunTime:0.000513s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.000395s ]
SELECT * FROM `tp_brand` WHERE `id` IN (4447,4483,4548,4545,4834,4441,4560) GROUP BY `name` LIMIT 30 [ RunTime:0.000412s ]
select group_concat(`key` separator '_') as `key` from tp_spec_goods_price where goods_id in(31997,32004,32007,34845,34878,35078,36068,36375,36392,36393,36394,36413,36414,36415,36416,36455,36456,37713,38297,38298,38300,38303,38304,38923,39105,39107,39159,39444,40195,40698,41232,41257,42199,42367,42430,42782,43290,45647,45684,45685,45697,47575,48000,48161,48170,48651,49701,49927,50497,51176,51637,52542,53988,54258,55857,55893,57386,57643,58385,59370,59685,60713,60786,60789,61335,62007,65372,67237,67244,67245,68105) [ RunTime:0.000232s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.000320s ]
SELECT * FROM `tp_goods_attr` WHERE `goods_id` IN (31997,32004,32007,34845,34878,35078,36068,36375,36392,36393,36394,36413,36414,36415,36416,36455,36456,37713,38297,38298,38300,38303,38304,38923,39105,39107,39159,39444,40195,40698,41232,41257,42199,42367,42430,42782,43290,45647,45684,45685,45697,47575,48000,48161,48170,48651,49701,49927,50497,51176,51637,52542,53988,54258,55857,55893,57386,57643,58385,59370,59685,60713,60786,60789,61335,62007,65372,67237,67244,67245,68105) AND `attr_value` <> '' [ RunTime:0.001468s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.000356s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.000135s ]
SELECT * FROM `tp_goods` WHERE `goods_id` IN (31997,32004,32007,34845,34878,35078,36068,36375,36392,36393,36394,36413,36414,36415,36416,36455,36456,37713,38297,38298,38300,38303,38304,38923,39105,39107,39159,39444,40195,40698,41232,41257,42199,42367,42430,42782,43290,45647,45684,45685,45697,47575,48000,48161,48170,48651,49701,49927,50497,51176,51637,52542,53988,54258,55857,55893,57386,57643,58385,59370,59685,60713,60786,60789,61335,62007,65372,67237,67244,67245,68105) ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.000909s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000337s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (40195,32004,35078,32007,49927,68105,38923,48651,41232,58385) [ RunTime:0.000934s ]
SHOW FULL COLUMNS FROM `tp_goods_label` [ RunTime:0.000341s ]
SELECT `label_id`,`label_name` FROM `tp_goods_label` [ RunTime:0.000106s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.000163s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 40195 LIMIT 1 [ RunTime:0.000266s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32004 LIMIT 1 [ RunTime:0.000630s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 35078 LIMIT 1 [ RunTime:0.000242s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32007 LIMIT 1 [ RunTime:0.000148s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 49927 LIMIT 1 [ RunTime:0.000151s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 68105 LIMIT 1 [ RunTime:0.000147s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 38923 LIMIT 1 [ RunTime:0.000157s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 48651 LIMIT 1 [ RunTime:0.000156s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 41232 LIMIT 1 [ RunTime:0.000153s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 58385 LIMIT 1 [ RunTime:0.000257s ]
