SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000729s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1049 LIMIT 1 [ RunTime:0.000291s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1031 ORDER BY `sort_order` DESC LIMIT 1 [ RunTime:0.000317s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000593s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 1049 [ RunTime:0.000237s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.001027s ]
SELECT `goods_id` FROM `tp_goods` WHERE `is_on_sale` = 1 AND `exchange_integral` = 0 AND `cat_id` = 1049 [ RunTime:0.000833s ]
SELECT `zs_price` FROM `tp_goods` WHERE `goods_id` IN (31160,31615,31618,31621,31625,31631,31635,31650,31666,31672,31675,31677,31680,31682,31684,32081,32082,35098,35162,35163,35164,35166,35167,35168,35169,35170,35171,35172,35173,35174,35175,35406,35431,36206,37030,37113,37241,37242,39019,39259,41134,42592,42749,42756,42761,44143,44425,44887,44935,45440,46734,48235,49381,51230,51235,51622,52594,52837,52838,52839,52850,52851,52852,52853,52854,52855,52856,52857,52858,54835,55497,55630,57066,57068,57355,59913,62088,63447,63674,68059) [ RunTime:0.001518s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (31160,31615,31618,31621,31625,31631,31635,31650,31666,31672,31675,31677,31680,31682,31684,32081,32082,35098,35162,35163,35164,35166,35167,35168,35169,35170,35171,35172,35173,35174,35175,35406,35431,36206,37030,37113,37241,37242,39019,39259,41134,42592,42749,42756,42761,44143,44425,44887,44935,45440,46734,48235,49381,51230,51235,51622,52594,52837,52838,52839,52850,52851,52852,52853,52854,52855,52856,52857,52858,54835,55497,55630,57066,57068,57355,59913,62088,63447,63674,68059) AND `brand_id` > 0 [ RunTime:0.003648s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.001334s ]
SELECT * FROM `tp_brand` WHERE `id` IN (4749,4611,4668,4754,4658,4833,4650,4570,4589,4657,4505,4654,4585,4673,4582,4631) GROUP BY `name` LIMIT 30 [ RunTime:0.001695s ]
select group_concat(`key` separator '_') as `key` from tp_spec_goods_price where goods_id in(31160,31615,31618,31621,31625,31631,31635,31650,31666,31672,31675,31677,31680,31682,31684,32081,32082,35098,35162,35163,35164,35166,35167,35168,35169,35170,35171,35172,35173,35174,35175,35406,35431,36206,37030,37113,37241,37242,39019,39259,41134,42592,42749,42756,42761,44143,44425,44887,44935,45440,46734,48235,49381,51230,51235,51622,52594,52837,52838,52839,52850,52851,52852,52853,52854,52855,52856,52857,52858,54835,55497,55630,57066,57068,57355,59913,62088,63447,63674,68059) [ RunTime:0.000935s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.001017s ]
SELECT * FROM `tp_goods_attr` WHERE `goods_id` IN (31160,31615,31618,31621,31625,31631,31635,31650,31666,31672,31675,31677,31680,31682,31684,32081,32082,35098,35162,35163,35164,35166,35167,35168,35169,35170,35171,35172,35173,35174,35175,35406,35431,36206,37030,37113,37241,37242,39019,39259,41134,42592,42749,42756,42761,44143,44425,44887,44935,45440,46734,48235,49381,51230,51235,51622,52594,52837,52838,52839,52850,52851,52852,52853,52854,52855,52856,52857,52858,54835,55497,55630,57066,57068,57355,59913,62088,63447,63674,68059) AND `attr_value` <> '' [ RunTime:0.002382s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.001126s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.000942s ]
SELECT * FROM `tp_goods` WHERE `goods_id` IN (31160,31615,31618,31621,31625,31631,31635,31650,31666,31672,31675,31677,31680,31682,31684,32081,32082,35098,35162,35163,35164,35166,35167,35168,35169,35170,35171,35172,35173,35174,35175,35406,35431,36206,37030,37113,37241,37242,39019,39259,41134,42592,42749,42756,42761,44143,44425,44887,44935,45440,46734,48235,49381,51230,51235,51622,52594,52837,52838,52839,52850,52851,52852,52853,52854,52855,52856,52857,52858,54835,55497,55630,57066,57068,57355,59913,62088,63447,63674,68059) ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.003198s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000864s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (42756,42761,59913,57355,35098,51230,51235,54835,35406,55630) [ RunTime:0.001348s ]
SHOW FULL COLUMNS FROM `tp_goods_label` [ RunTime:0.001019s ]
SELECT `label_id`,`label_name` FROM `tp_goods_label` [ RunTime:0.005467s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.001012s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 42756 LIMIT 1 [ RunTime:0.001008s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 42761 LIMIT 1 [ RunTime:0.001621s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 59913 LIMIT 1 [ RunTime:0.001019s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 57355 LIMIT 1 [ RunTime:0.000984s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 35098 LIMIT 1 [ RunTime:0.003347s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 51230 LIMIT 1 [ RunTime:0.003192s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 51235 LIMIT 1 [ RunTime:0.000352s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 54835 LIMIT 1 [ RunTime:0.000286s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 35406 LIMIT 1 [ RunTime:0.000296s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 55630 LIMIT 1 [ RunTime:0.000347s ]
