SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000444s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1091 LIMIT 1 [ RunTime:0.000156s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000363s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 1091 [ RunTime:0.000145s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.000556s ]
SELECT `goods_id` FROM `tp_goods` WHERE `is_on_sale` = 1 AND `exchange_integral` = 0 AND `cat_id` IN (1091,1092,1093,1389,1391,1392,1394,1395,1397,1398,1400,1401,1402,1404,1405,1407,1408,1410,1411,1413,1414,1650,1722,1744,1822,1825,1905,1959,1960,2091) [ RunTime:0.001292s ]
SELECT `zs_price` FROM `tp_goods` WHERE `goods_id` IN (33626,33745,33754,33777,33782,34742,35436,35507,36243,37297,37298,37305,37306,37311,37493,37494,38188,42228,42981,43005,44912,44913,44915,44966,45245,45356,47063,48502,49546,51578,51583,56154,57955,58927,60836,65369,66344,67470,67977,68583,33598,34523,35589,37307,42240,42954,44986,47064,49378,49802,60837,33606,35615,35616,44916,44980,44982,44984,44985,51579,51582,66345,33655,35585,36244,37308,38919,42241,42982,44974,44975,44983,51580,51581,53590,66346,33531,33533,33562,33569,33572,33582,33601,33605,35600,35603,35619,35620,35621,36242,36245,37310,37312,37313,37314,37315,37495,37496,37501,37502,37503,37505,37506,37507,37509,37510,37512,37517,37518,37519,37537,37545,37546,37549,37550,37552,37553,38330,39294,42245,44961,44988,44989,44993,44994,44995,44996,44997,44999,45000,45001,45002,45003,45004,45005,45006,45007,45008,45013,45014,45015,45016,45017,45018,45019,45021,45023,45024,45025,45042,45048,45049,45050,45057,45062,45064,45082,45083,45084,47079,49704,51218,51219,51220,53593,54748,54755,54756,56890,60846,60847,66347,66348,66350,66351,66375,66376,66377,67738,35595,35604,38918,39293,42239,44931,44987,53591,58926,42242,42985,45081,45087,48501,48546,50376,51231,54747,55453,65900,66354,66355,66356,66357,66358,66359,66360,66361,66362,66363,66381,67997,33622,35596,37309,42987,45063,49368,60835,35614,53173,53174,53175,53177,53178,53183,66371,66372,66373,68134,53172,53180,53185,46968,38117,39956,39957,39971,42579,43138,43242,43620,43714,45411,46581,46589,46797,47333,48548,48549,48685,48947,49568,53182,53189,53200,55100,57370,58221,58222,59114,59116,59367,62140,63931,39973,58925,38912,42984,44181,68833,37513,37514,37515,37516,49714,54749,65901,66364,66365,66366,66367,66368,66369,66370,67998,68007,38123,38131,38751,38758,38931,38934,38935,38942,39292,39295,39296,39297,39298,39299,39945,39947,39954,39955,41169,42253,42741,42986,42990,43245,46187,47322,48184,48185,48403,48421,48422,48423,48424,48425,48426,48427,48429,48547,48550,48554,48555,48795,53179,53184,53186,56741,58924,60347,60840,60841,60842,60848,60849,63357,63358,63359,66378,66379,66380,66656,66657,66658,66659,66660,66661,66663,66664,66665,66666,66667,66668,66669,67072,67981,67982,67984,67985,67987,67992,67995,67999,68001,68132,68133,68584,68585,68677,68678,68679,68680,68681,68682,68683,68684,68685,68686,68687,68688,68778,38921,38936,39290,39291,47378,49369,52181,52182,52212,52213,53697,66374,67667,67668,67669,67670,41082,42254,42251,42252,44965,45020,45022,49712,54753,54754,66349,67996,69419) [ RunTime:0.002272s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (33626,33745,33754,33777,33782,34742,35436,35507,36243,37297,37298,37305,37306,37311,37493,37494,38188,42228,42981,43005,44912,44913,44915,44966,45245,45356,47063,48502,49546,51578,51583,56154,57955,58927,60836,65369,66344,67470,67977,68583,33598,34523,35589,37307,42240,42954,44986,47064,49378,49802,60837,33606,35615,35616,44916,44980,44982,44984,44985,51579,51582,66345,33655,35585,36244,37308,38919,42241,42982,44974,44975,44983,51580,51581,53590,66346,33531,33533,33562,33569,33572,33582,33601,33605,35600,35603,35619,35620,35621,36242,36245,37310,37312,37313,37314,37315,37495,37496,37501,37502,37503,37505,37506,37507,37509,37510,37512,37517,37518,37519,37537,37545,37546,37549,37550,37552,37553,38330,39294,42245,44961,44988,44989,44993,44994,44995,44996,44997,44999,45000,45001,45002,45003,45004,45005,45006,45007,45008,45013,45014,45015,45016,45017,45018,45019,45021,45023,45024,45025,45042,45048,45049,45050,45057,45062,45064,45082,45083,45084,47079,49704,51218,51219,51220,53593,54748,54755,54756,56890,60846,60847,66347,66348,66350,66351,66375,66376,66377,67738,35595,35604,38918,39293,42239,44931,44987,53591,58926,42242,42985,45081,45087,48501,48546,50376,51231,54747,55453,65900,66354,66355,66356,66357,66358,66359,66360,66361,66362,66363,66381,67997,33622,35596,37309,42987,45063,49368,60835,35614,53173,53174,53175,53177,53178,53183,66371,66372,66373,68134,53172,53180,53185,46968,38117,39956,39957,39971,42579,43138,43242,43620,43714,45411,46581,46589,46797,47333,48548,48549,48685,48947,49568,53182,53189,53200,55100,57370,58221,58222,59114,59116,59367,62140,63931,39973,58925,38912,42984,44181,68833,37513,37514,37515,37516,49714,54749,65901,66364,66365,66366,66367,66368,66369,66370,67998,68007,38123,38131,38751,38758,38931,38934,38935,38942,39292,39295,39296,39297,39298,39299,39945,39947,39954,39955,41169,42253,42741,42986,42990,43245,46187,47322,48184,48185,48403,48421,48422,48423,48424,48425,48426,48427,48429,48547,48550,48554,48555,48795,53179,53184,53186,56741,58924,60347,60840,60841,60842,60848,60849,63357,63358,63359,66378,66379,66380,66656,66657,66658,66659,66660,66661,66663,66664,66665,66666,66667,66668,66669,67072,67981,67982,67984,67985,67987,67992,67995,67999,68001,68132,68133,68584,68585,68677,68678,68679,68680,68681,68682,68683,68684,68685,68686,68687,68688,68778,38921,38936,39290,39291,47378,49369,52181,52182,52212,52213,53697,66374,67667,67668,67669,67670,41082,42254,42251,42252,44965,45020,45022,49712,54753,54754,66349,67996,69419) AND `brand_id` > 0 [ RunTime:0.002219s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.000407s ]
SELECT * FROM `tp_brand` WHERE `id` IN (4722,4730,5126,4731,5239,5629,5259,5252,5339,5413,5416,5417,4450,5806,5496,5261,5253,4781,6578,6029,6030,6085,6266,4505,6470,6488,7414,6629,4729,6692,4560,6326,7321,7139,6826,6854,4959,5285,6925,7530,7531,7191,6661,7553,7771,6041,5802,7838,7851,4827,8021,4826,8125,8124) GROUP BY `name` LIMIT 30 [ RunTime:0.000965s ]
select group_concat(`key` separator '_') as `key` from tp_spec_goods_price where goods_id in(33626,33745,33754,33777,33782,34742,35436,35507,36243,37297,37298,37305,37306,37311,37493,37494,38188,42228,42981,43005,44912,44913,44915,44966,45245,45356,47063,48502,49546,51578,51583,56154,57955,58927,60836,65369,66344,67470,67977,68583,33598,34523,35589,37307,42240,42954,44986,47064,49378,49802,60837,33606,35615,35616,44916,44980,44982,44984,44985,51579,51582,66345,33655,35585,36244,37308,38919,42241,42982,44974,44975,44983,51580,51581,53590,66346,33531,33533,33562,33569,33572,33582,33601,33605,35600,35603,35619,35620,35621,36242,36245,37310,37312,37313,37314,37315,37495,37496,37501,37502,37503,37505,37506,37507,37509,37510,37512,37517,37518,37519,37537,37545,37546,37549,37550,37552,37553,38330,39294,42245,44961,44988,44989,44993,44994,44995,44996,44997,44999,45000,45001,45002,45003,45004,45005,45006,45007,45008,45013,45014,45015,45016,45017,45018,45019,45021,45023,45024,45025,45042,45048,45049,45050,45057,45062,45064,45082,45083,45084,47079,49704,51218,51219,51220,53593,54748,54755,54756,56890,60846,60847,66347,66348,66350,66351,66375,66376,66377,67738,35595,35604,38918,39293,42239,44931,44987,53591,58926,42242,42985,45081,45087,48501,48546,50376,51231,54747,55453,65900,66354,66355,66356,66357,66358,66359,66360,66361,66362,66363,66381,67997,33622,35596,37309,42987,45063,49368,60835,35614,53173,53174,53175,53177,53178,53183,66371,66372,66373,68134,53172,53180,53185,46968,38117,39956,39957,39971,42579,43138,43242,43620,43714,45411,46581,46589,46797,47333,48548,48549,48685,48947,49568,53182,53189,53200,55100,57370,58221,58222,59114,59116,59367,62140,63931,39973,58925,38912,42984,44181,68833,37513,37514,37515,37516,49714,54749,65901,66364,66365,66366,66367,66368,66369,66370,67998,68007,38123,38131,38751,38758,38931,38934,38935,38942,39292,39295,39296,39297,39298,39299,39945,39947,39954,39955,41169,42253,42741,42986,42990,43245,46187,47322,48184,48185,48403,48421,48422,48423,48424,48425,48426,48427,48429,48547,48550,48554,48555,48795,53179,53184,53186,56741,58924,60347,60840,60841,60842,60848,60849,63357,63358,63359,66378,66379,66380,66656,66657,66658,66659,66660,66661,66663,66664,66665,66666,66667,66668,66669,67072,67981,67982,67984,67985,67987,67992,67995,67999,68001,68132,68133,68584,68585,68677,68678,68679,68680,68681,68682,68683,68684,68685,68686,68687,68688,68778,38921,38936,39290,39291,47378,49369,52181,52182,52212,52213,53697,66374,67667,67668,67669,67670,41082,42254,42251,42252,44965,45020,45022,49712,54753,54754,66349,67996,69419) [ RunTime:0.000386s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.000356s ]
SELECT * FROM `tp_goods_attr` WHERE `goods_id` IN (33626,33745,33754,33777,33782,34742,35436,35507,36243,37297,37298,37305,37306,37311,37493,37494,38188,42228,42981,43005,44912,44913,44915,44966,45245,45356,47063,48502,49546,51578,51583,56154,57955,58927,60836,65369,66344,67470,67977,68583,33598,34523,35589,37307,42240,42954,44986,47064,49378,49802,60837,33606,35615,35616,44916,44980,44982,44984,44985,51579,51582,66345,33655,35585,36244,37308,38919,42241,42982,44974,44975,44983,51580,51581,53590,66346,33531,33533,33562,33569,33572,33582,33601,33605,35600,35603,35619,35620,35621,36242,36245,37310,37312,37313,37314,37315,37495,37496,37501,37502,37503,37505,37506,37507,37509,37510,37512,37517,37518,37519,37537,37545,37546,37549,37550,37552,37553,38330,39294,42245,44961,44988,44989,44993,44994,44995,44996,44997,44999,45000,45001,45002,45003,45004,45005,45006,45007,45008,45013,45014,45015,45016,45017,45018,45019,45021,45023,45024,45025,45042,45048,45049,45050,45057,45062,45064,45082,45083,45084,47079,49704,51218,51219,51220,53593,54748,54755,54756,56890,60846,60847,66347,66348,66350,66351,66375,66376,66377,67738,35595,35604,38918,39293,42239,44931,44987,53591,58926,42242,42985,45081,45087,48501,48546,50376,51231,54747,55453,65900,66354,66355,66356,66357,66358,66359,66360,66361,66362,66363,66381,67997,33622,35596,37309,42987,45063,49368,60835,35614,53173,53174,53175,53177,53178,53183,66371,66372,66373,68134,53172,53180,53185,46968,38117,39956,39957,39971,42579,43138,43242,43620,43714,45411,46581,46589,46797,47333,48548,48549,48685,48947,49568,53182,53189,53200,55100,57370,58221,58222,59114,59116,59367,62140,63931,39973,58925,38912,42984,44181,68833,37513,37514,37515,37516,49714,54749,65901,66364,66365,66366,66367,66368,66369,66370,67998,68007,38123,38131,38751,38758,38931,38934,38935,38942,39292,39295,39296,39297,39298,39299,39945,39947,39954,39955,41169,42253,42741,42986,42990,43245,46187,47322,48184,48185,48403,48421,48422,48423,48424,48425,48426,48427,48429,48547,48550,48554,48555,48795,53179,53184,53186,56741,58924,60347,60840,60841,60842,60848,60849,63357,63358,63359,66378,66379,66380,66656,66657,66658,66659,66660,66661,66663,66664,66665,66666,66667,66668,66669,67072,67981,67982,67984,67985,67987,67992,67995,67999,68001,68132,68133,68584,68585,68677,68678,68679,68680,68681,68682,68683,68684,68685,68686,68687,68688,68778,38921,38936,39290,39291,47378,49369,52181,52182,52212,52213,53697,66374,67667,67668,67669,67670,41082,42254,42251,42252,44965,45020,45022,49712,54753,54754,66349,67996,69419) AND `attr_value` <> '' [ RunTime:0.002381s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.000389s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.000125s ]
SELECT * FROM `tp_goods` WHERE `goods_id` IN (33626,33745,33754,33777,33782,34742,35436,35507,36243,37297,37298,37305,37306,37311,37493,37494,38188,42228,42981,43005,44912,44913,44915,44966,45245,45356,47063,48502,49546,51578,51583,56154,57955,58927,60836,65369,66344,67470,67977,68583,33598,34523,35589,37307,42240,42954,44986,47064,49378,49802,60837,33606,35615,35616,44916,44980,44982,44984,44985,51579,51582,66345,33655,35585,36244,37308,38919,42241,42982,44974,44975,44983,51580,51581,53590,66346,33531,33533,33562,33569,33572,33582,33601,33605,35600,35603,35619,35620,35621,36242,36245,37310,37312,37313,37314,37315,37495,37496,37501,37502,37503,37505,37506,37507,37509,37510,37512,37517,37518,37519,37537,37545,37546,37549,37550,37552,37553,38330,39294,42245,44961,44988,44989,44993,44994,44995,44996,44997,44999,45000,45001,45002,45003,45004,45005,45006,45007,45008,45013,45014,45015,45016,45017,45018,45019,45021,45023,45024,45025,45042,45048,45049,45050,45057,45062,45064,45082,45083,45084,47079,49704,51218,51219,51220,53593,54748,54755,54756,56890,60846,60847,66347,66348,66350,66351,66375,66376,66377,67738,35595,35604,38918,39293,42239,44931,44987,53591,58926,42242,42985,45081,45087,48501,48546,50376,51231,54747,55453,65900,66354,66355,66356,66357,66358,66359,66360,66361,66362,66363,66381,67997,33622,35596,37309,42987,45063,49368,60835,35614,53173,53174,53175,53177,53178,53183,66371,66372,66373,68134,53172,53180,53185,46968,38117,39956,39957,39971,42579,43138,43242,43620,43714,45411,46581,46589,46797,47333,48548,48549,48685,48947,49568,53182,53189,53200,55100,57370,58221,58222,59114,59116,59367,62140,63931,39973,58925,38912,42984,44181,68833,37513,37514,37515,37516,49714,54749,65901,66364,66365,66366,66367,66368,66369,66370,67998,68007,38123,38131,38751,38758,38931,38934,38935,38942,39292,39295,39296,39297,39298,39299,39945,39947,39954,39955,41169,42253,42741,42986,42990,43245,46187,47322,48184,48185,48403,48421,48422,48423,48424,48425,48426,48427,48429,48547,48550,48554,48555,48795,53179,53184,53186,56741,58924,60347,60840,60841,60842,60848,60849,63357,63358,63359,66378,66379,66380,66656,66657,66658,66659,66660,66661,66663,66664,66665,66666,66667,66668,66669,67072,67981,67982,67984,67985,67987,67992,67995,67999,68001,68132,68133,68584,68585,68677,68678,68679,68680,68681,68682,68683,68684,68685,68686,68687,68688,68778,38921,38936,39290,39291,47378,49369,52181,52182,52212,52213,53697,66374,67667,67668,67669,67670,41082,42254,42251,42252,44965,45020,45022,49712,54753,54754,66349,67996,69419) ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.006537s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000384s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (33531,33533,33562,33569,33572,33582,33598,33601,33605,33606) [ RunTime:0.000739s ]
SHOW FULL COLUMNS FROM `tp_goods_label` [ RunTime:0.000366s ]
SELECT `label_id`,`label_name` FROM `tp_goods_label` [ RunTime:0.000108s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.000159s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33531 LIMIT 1 [ RunTime:0.000191s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33533 LIMIT 1 [ RunTime:0.000225s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33562 LIMIT 1 [ RunTime:0.000161s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33569 LIMIT 1 [ RunTime:0.000419s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33572 LIMIT 1 [ RunTime:0.000195s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33582 LIMIT 1 [ RunTime:0.000178s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33598 LIMIT 1 [ RunTime:0.000158s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33601 LIMIT 1 [ RunTime:0.000168s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33605 LIMIT 1 [ RunTime:0.000141s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33606 LIMIT 1 [ RunTime:0.000145s ]
