SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000568s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1707 LIMIT 1 [ RunTime:0.000228s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000432s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.000712s ]
SELECT `goods_id` FROM `tp_goods` WHERE `is_on_sale` = 1 AND `exchange_integral` = 0 AND `cat_id` IN (1707,1708,1709) [ RunTime:0.000755s ]
SELECT `zs_price` FROM `tp_goods` WHERE `goods_id` IN (36840,37170,37171,37172,37442,37443,37444,37447,37561,37588,37597,37598,37660,38340,38585,38586,38647,39186,39193,39486,39997,40032,40288,40517,40578,40592,40593,40710,40815,40827,40844,40860,40991,41006,41032,41084,41185,41326,41445,41522,42443,47132,48079,49355,57932,57933,59519,59527,59636,61327,37173,37174,37175,37176,37177,37178,37179,37201,37202,37441,37445,37446,37458,37587,37589,37590,37591,37592,37594,37595,37596,37765,38289,38847,39999,40813,40814,40831,40832,40833,40838,40973,40988,41005,41007,41009,41010,41011,41041,41533,51019,60998,61579,61580,61581,61582,61583,61584,61585,61586,61587,61588,61667,61668,61670,61671,61672,61673,61674,61675,61676,61677,61678,61734,61735,61736,61737,61738,61739,61740,61741,61742,61743,61744,61745,61746,61747,61748,61771,61772,61773,61774,61775,61776,61777,61778,61779,61780,61781,61782,61783,61784,61785,61786,61787,61788,61789,61790,61791,61792,61793,61794,61795,61796,61797,61798,61799,61807,61808,61809,61810,61811,61812,61813,61814,61815,61816,61817,61818,61819,61820,61821,61822,61823,61824,61825,63848,69382) [ RunTime:0.001239s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (36840,37170,37171,37172,37442,37443,37444,37447,37561,37588,37597,37598,37660,38340,38585,38586,38647,39186,39193,39486,39997,40032,40288,40517,40578,40592,40593,40710,40815,40827,40844,40860,40991,41006,41032,41084,41185,41326,41445,41522,42443,47132,48079,49355,57932,57933,59519,59527,59636,61327,37173,37174,37175,37176,37177,37178,37179,37201,37202,37441,37445,37446,37458,37587,37589,37590,37591,37592,37594,37595,37596,37765,38289,38847,39999,40813,40814,40831,40832,40833,40838,40973,40988,41005,41007,41009,41010,41011,41041,41533,51019,60998,61579,61580,61581,61582,61583,61584,61585,61586,61587,61588,61667,61668,61670,61671,61672,61673,61674,61675,61676,61677,61678,61734,61735,61736,61737,61738,61739,61740,61741,61742,61743,61744,61745,61746,61747,61748,61771,61772,61773,61774,61775,61776,61777,61778,61779,61780,61781,61782,61783,61784,61785,61786,61787,61788,61789,61790,61791,61792,61793,61794,61795,61796,61797,61798,61799,61807,61808,61809,61810,61811,61812,61813,61814,61815,61816,61817,61818,61819,61820,61821,61822,61823,61824,61825,63848,69382) AND `brand_id` > 0 [ RunTime:0.001216s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.000493s ]
SELECT * FROM `tp_brand` WHERE `id` IN (4862,5158,5181,5512,5185,5194,5192,5196,5197,4924,5206,5226,5291,6394,4450,5178,5091,5128,5664,5677,4821,5947,6031,5284,5709,5710,5726,5733,5743,6266,5787,5934,7139,5233,6911,5523,5450,7867,7936,5759,7942,7866) GROUP BY `name` LIMIT 30 [ RunTime:0.000914s ]
select group_concat(`key` separator '_') as `key` from tp_spec_goods_price where goods_id in(36840,37170,37171,37172,37442,37443,37444,37447,37561,37588,37597,37598,37660,38340,38585,38586,38647,39186,39193,39486,39997,40032,40288,40517,40578,40592,40593,40710,40815,40827,40844,40860,40991,41006,41032,41084,41185,41326,41445,41522,42443,47132,48079,49355,57932,57933,59519,59527,59636,61327,37173,37174,37175,37176,37177,37178,37179,37201,37202,37441,37445,37446,37458,37587,37589,37590,37591,37592,37594,37595,37596,37765,38289,38847,39999,40813,40814,40831,40832,40833,40838,40973,40988,41005,41007,41009,41010,41011,41041,41533,51019,60998,61579,61580,61581,61582,61583,61584,61585,61586,61587,61588,61667,61668,61670,61671,61672,61673,61674,61675,61676,61677,61678,61734,61735,61736,61737,61738,61739,61740,61741,61742,61743,61744,61745,61746,61747,61748,61771,61772,61773,61774,61775,61776,61777,61778,61779,61780,61781,61782,61783,61784,61785,61786,61787,61788,61789,61790,61791,61792,61793,61794,61795,61796,61797,61798,61799,61807,61808,61809,61810,61811,61812,61813,61814,61815,61816,61817,61818,61819,61820,61821,61822,61823,61824,61825,63848,69382) [ RunTime:0.000332s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.000500s ]
SELECT * FROM `tp_goods_attr` WHERE `goods_id` IN (36840,37170,37171,37172,37442,37443,37444,37447,37561,37588,37597,37598,37660,38340,38585,38586,38647,39186,39193,39486,39997,40032,40288,40517,40578,40592,40593,40710,40815,40827,40844,40860,40991,41006,41032,41084,41185,41326,41445,41522,42443,47132,48079,49355,57932,57933,59519,59527,59636,61327,37173,37174,37175,37176,37177,37178,37179,37201,37202,37441,37445,37446,37458,37587,37589,37590,37591,37592,37594,37595,37596,37765,38289,38847,39999,40813,40814,40831,40832,40833,40838,40973,40988,41005,41007,41009,41010,41011,41041,41533,51019,60998,61579,61580,61581,61582,61583,61584,61585,61586,61587,61588,61667,61668,61670,61671,61672,61673,61674,61675,61676,61677,61678,61734,61735,61736,61737,61738,61739,61740,61741,61742,61743,61744,61745,61746,61747,61748,61771,61772,61773,61774,61775,61776,61777,61778,61779,61780,61781,61782,61783,61784,61785,61786,61787,61788,61789,61790,61791,61792,61793,61794,61795,61796,61797,61798,61799,61807,61808,61809,61810,61811,61812,61813,61814,61815,61816,61817,61818,61819,61820,61821,61822,61823,61824,61825,63848,69382) AND `attr_value` <> '' [ RunTime:0.001313s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.000432s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.000164s ]
SELECT * FROM `tp_goods` WHERE `goods_id` IN (36840,37170,37171,37172,37442,37443,37444,37447,37561,37588,37597,37598,37660,38340,38585,38586,38647,39186,39193,39486,39997,40032,40288,40517,40578,40592,40593,40710,40815,40827,40844,40860,40991,41006,41032,41084,41185,41326,41445,41522,42443,47132,48079,49355,57932,57933,59519,59527,59636,61327,37173,37174,37175,37176,37177,37178,37179,37201,37202,37441,37445,37446,37458,37587,37589,37590,37591,37592,37594,37595,37596,37765,38289,38847,39999,40813,40814,40831,40832,40833,40838,40973,40988,41005,41007,41009,41010,41011,41041,41533,51019,60998,61579,61580,61581,61582,61583,61584,61585,61586,61587,61588,61667,61668,61670,61671,61672,61673,61674,61675,61676,61677,61678,61734,61735,61736,61737,61738,61739,61740,61741,61742,61743,61744,61745,61746,61747,61748,61771,61772,61773,61774,61775,61776,61777,61778,61779,61780,61781,61782,61783,61784,61785,61786,61787,61788,61789,61790,61791,61792,61793,61794,61795,61796,61797,61798,61799,61807,61808,61809,61810,61811,61812,61813,61814,61815,61816,61817,61818,61819,61820,61821,61822,61823,61824,61825,63848,69382) ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.001387s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000414s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (69382,40710,40973,39186,39193,37660,40988,47132,40991,61734) [ RunTime:0.000470s ]
SHOW FULL COLUMNS FROM `tp_goods_label` [ RunTime:0.000419s ]
SELECT `label_id`,`label_name` FROM `tp_goods_label` [ RunTime:0.000135s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.000206s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 69382 LIMIT 1 [ RunTime:0.000263s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 40710 LIMIT 1 [ RunTime:0.000213s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 40973 LIMIT 1 [ RunTime:0.000228s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 39186 LIMIT 1 [ RunTime:0.000212s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 39193 LIMIT 1 [ RunTime:0.000211s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 37660 LIMIT 1 [ RunTime:0.000230s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 40988 LIMIT 1 [ RunTime:0.000211s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 47132 LIMIT 1 [ RunTime:0.000225s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 40991 LIMIT 1 [ RunTime:0.000211s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 61734 LIMIT 1 [ RunTime:0.000226s ]
