SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000487s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 977 LIMIT 1 [ RunTime:0.000208s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 960 ORDER BY `sort_order` DESC LIMIT 1 [ RunTime:0.000221s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000371s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 977 [ RunTime:0.000194s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.000649s ]
SELECT `goods_id` FROM `tp_goods` WHERE `is_on_sale` = 1 AND `exchange_integral` = 0 AND `cat_id` = 977 [ RunTime:0.000488s ]
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.000631s ]
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.000669s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.000484s ]
SELECT * FROM `tp_brand` WHERE `id` IN (4447,4483,4548,4545,4834,4441,4560) GROUP BY `name` LIMIT 30 [ RunTime:0.000462s ]
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.000190s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.000310s ]
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.000940s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.000365s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.000121s ]
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.000692s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000330s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (40195,32004,35078,32007,49927,68105,38923,48651,41232,58385) [ RunTime:0.001262s ]
SHOW FULL COLUMNS FROM `tp_goods_label` [ RunTime:0.000375s ]
SELECT `label_id`,`label_name` FROM `tp_goods_label` [ RunTime:0.000105s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.000147s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 40195 LIMIT 1 [ RunTime:0.000251s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32004 LIMIT 1 [ RunTime:0.000169s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 35078 LIMIT 1 [ RunTime:0.000416s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32007 LIMIT 1 [ RunTime:0.000184s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 49927 LIMIT 1 [ RunTime:0.000139s ]
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.000134s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 48651 LIMIT 1 [ RunTime:0.000158s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 41232 LIMIT 1 [ RunTime:0.000140s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 58385 LIMIT 1 [ RunTime:0.000135s ]
