SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000597s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1042 LIMIT 1 [ RunTime:0.000236s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1031 ORDER BY `sort_order` DESC LIMIT 1 [ RunTime:0.000224s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000370s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 1042 [ RunTime:0.000183s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.000731s ]
SELECT `goods_id` FROM `tp_goods` WHERE `is_on_sale` = 1 AND `exchange_integral` = 0 AND `cat_id` = 1042 [ RunTime:0.001209s ]
SELECT `zs_price` FROM `tp_goods` WHERE `goods_id` IN (32067,32374,32381,32386,32397,32401,32406,32412,32420,32443,32482,32493,32503,32519,32526,32537,32539,32543,32558,32575,32580,32585,32593,32594,32599,32604,32606,32617,32627,32639,32675,32689,32709,32712,32717,32736,32747,32772,32799,32806,34118,34788,34811,34812,34813,34816,34817,34818,34819,34820,34821,34822,34823,34824,34825,34834,34894,35074,35204,36050,36151,36165,36241,36471,36559,36569,36676,36879,37068,37252,37253,37260,37262,37425,37426,37489,37623,37629,37631,37640,37641,37642,37644,37670,37775,38230,38252,38254,38325,38374,38375,38712,39119,39260,39442,39630,40076,40131,40132,40133,40137,40138,40139,40141,40144,40209,40242,40449,40484,40514,40515,40573,40674,40807,40809,40852,40853,40995,41037,41110,41194,41428,41635,42064,42065,42087,42089,42205,42206,42211,42212,42292,42371,42540,42743,43019,43144,43145,43146,43176,43297,43298,43306,43307,43421,43505,43809,43910,43911,43920,43921,44028,44161,44166,44167,44244,44389,44390,44413,44414,44427,44758,44759,44760,44937,44948,45118,45119,45120,45121,45122,45124,45126,45127,45129,45130,45131,45132,45134,45137,45138,45139,45229,45321,45322,45352,45425,45426,45489,45490,45492,45493,45494,45495,45496,45515,45516,45517,45518,45519,45520,45598,45615,46149,46773,46774,46894,46895,46896,47490,47571,47572,47841,47958,47959,47960,48099,48100,48109,48121,48122,48123,48124,48125,48126,48230,48232,48334,48335,49130,49359,49416,49588,49631,49695,49696,49738,49804,49961,50322,50323,50328,50331,50332,50335,51068,51069,51070,51107,51128,51506,51507,51634,51782,51783,52603,52604,52605,52606,52607,52608,52609,52762,52763,52764,52787,52970,52971,52972,52973,52986,52987,52988,52989,52990,52991,53060,53156,53222,53224,53226,53227,53229,53234,53421,53439,53440,53441,53863,53870,54230,54300,54314,54441,54486,54653,54751,54752,54765,55349,55525,55526,55561,55675,55679,55703,55922,55923,55936,55939,55940,55941,55942,55943,55944,56097,56099,56248,56461,56462,56463,57764,57877,57878,57965,58326,58358,58600,58601,59134,59135,59372,59373,59921,60678,60708,60930,60931,61094,61534,61535,61594,61608,62372,62493,62614,63156,63157,63158,63159,63160,63161,63162,63163,63164,63165,63166,63167,63168,63321,63322,63409,63574,63688,63722,63943,64034,64147,64171,64172,64175,64191,64368,64678,64679,64874,64875,65163,65164,65165,65239,65556,65558,65685,65686,65687,65688,65689,65690,65691,65692,65696,65697,65698,65699,65700,65701,65702,65733,65734,65853,65912,66121,66284,66287,66288,66289,66308,66498,66499,66501,66731,66732,67294,67295,67296,67366,67367,67368,67495,67496,67907,67948,68130,68131,68535,68640,68730,68731,69212,69351,69352,69353) [ RunTime:0.002739s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (32067,32374,32381,32386,32397,32401,32406,32412,32420,32443,32482,32493,32503,32519,32526,32537,32539,32543,32558,32575,32580,32585,32593,32594,32599,32604,32606,32617,32627,32639,32675,32689,32709,32712,32717,32736,32747,32772,32799,32806,34118,34788,34811,34812,34813,34816,34817,34818,34819,34820,34821,34822,34823,34824,34825,34834,34894,35074,35204,36050,36151,36165,36241,36471,36559,36569,36676,36879,37068,37252,37253,37260,37262,37425,37426,37489,37623,37629,37631,37640,37641,37642,37644,37670,37775,38230,38252,38254,38325,38374,38375,38712,39119,39260,39442,39630,40076,40131,40132,40133,40137,40138,40139,40141,40144,40209,40242,40449,40484,40514,40515,40573,40674,40807,40809,40852,40853,40995,41037,41110,41194,41428,41635,42064,42065,42087,42089,42205,42206,42211,42212,42292,42371,42540,42743,43019,43144,43145,43146,43176,43297,43298,43306,43307,43421,43505,43809,43910,43911,43920,43921,44028,44161,44166,44167,44244,44389,44390,44413,44414,44427,44758,44759,44760,44937,44948,45118,45119,45120,45121,45122,45124,45126,45127,45129,45130,45131,45132,45134,45137,45138,45139,45229,45321,45322,45352,45425,45426,45489,45490,45492,45493,45494,45495,45496,45515,45516,45517,45518,45519,45520,45598,45615,46149,46773,46774,46894,46895,46896,47490,47571,47572,47841,47958,47959,47960,48099,48100,48109,48121,48122,48123,48124,48125,48126,48230,48232,48334,48335,49130,49359,49416,49588,49631,49695,49696,49738,49804,49961,50322,50323,50328,50331,50332,50335,51068,51069,51070,51107,51128,51506,51507,51634,51782,51783,52603,52604,52605,52606,52607,52608,52609,52762,52763,52764,52787,52970,52971,52972,52973,52986,52987,52988,52989,52990,52991,53060,53156,53222,53224,53226,53227,53229,53234,53421,53439,53440,53441,53863,53870,54230,54300,54314,54441,54486,54653,54751,54752,54765,55349,55525,55526,55561,55675,55679,55703,55922,55923,55936,55939,55940,55941,55942,55943,55944,56097,56099,56248,56461,56462,56463,57764,57877,57878,57965,58326,58358,58600,58601,59134,59135,59372,59373,59921,60678,60708,60930,60931,61094,61534,61535,61594,61608,62372,62493,62614,63156,63157,63158,63159,63160,63161,63162,63163,63164,63165,63166,63167,63168,63321,63322,63409,63574,63688,63722,63943,64034,64147,64171,64172,64175,64191,64368,64678,64679,64874,64875,65163,65164,65165,65239,65556,65558,65685,65686,65687,65688,65689,65690,65691,65692,65696,65697,65698,65699,65700,65701,65702,65733,65734,65853,65912,66121,66284,66287,66288,66289,66308,66498,66499,66501,66731,66732,67294,67295,67296,67366,67367,67368,67495,67496,67907,67948,68130,68131,68535,68640,68730,68731,69212,69351,69352,69353) AND `brand_id` > 0 [ RunTime:0.002400s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.000503s ]
SELECT * FROM `tp_brand` WHERE `id` IN (4657,4630,4505,4610,4585,4605,4603,4675,6411,5955,4672,7603,7604,7605,6661,4544,7139,4666,8048,4678,7527,4887) GROUP BY `name` LIMIT 30 [ RunTime:0.000639s ]
select group_concat(`key` separator '_') as `key` from tp_spec_goods_price where goods_id in(32067,32374,32381,32386,32397,32401,32406,32412,32420,32443,32482,32493,32503,32519,32526,32537,32539,32543,32558,32575,32580,32585,32593,32594,32599,32604,32606,32617,32627,32639,32675,32689,32709,32712,32717,32736,32747,32772,32799,32806,34118,34788,34811,34812,34813,34816,34817,34818,34819,34820,34821,34822,34823,34824,34825,34834,34894,35074,35204,36050,36151,36165,36241,36471,36559,36569,36676,36879,37068,37252,37253,37260,37262,37425,37426,37489,37623,37629,37631,37640,37641,37642,37644,37670,37775,38230,38252,38254,38325,38374,38375,38712,39119,39260,39442,39630,40076,40131,40132,40133,40137,40138,40139,40141,40144,40209,40242,40449,40484,40514,40515,40573,40674,40807,40809,40852,40853,40995,41037,41110,41194,41428,41635,42064,42065,42087,42089,42205,42206,42211,42212,42292,42371,42540,42743,43019,43144,43145,43146,43176,43297,43298,43306,43307,43421,43505,43809,43910,43911,43920,43921,44028,44161,44166,44167,44244,44389,44390,44413,44414,44427,44758,44759,44760,44937,44948,45118,45119,45120,45121,45122,45124,45126,45127,45129,45130,45131,45132,45134,45137,45138,45139,45229,45321,45322,45352,45425,45426,45489,45490,45492,45493,45494,45495,45496,45515,45516,45517,45518,45519,45520,45598,45615,46149,46773,46774,46894,46895,46896,47490,47571,47572,47841,47958,47959,47960,48099,48100,48109,48121,48122,48123,48124,48125,48126,48230,48232,48334,48335,49130,49359,49416,49588,49631,49695,49696,49738,49804,49961,50322,50323,50328,50331,50332,50335,51068,51069,51070,51107,51128,51506,51507,51634,51782,51783,52603,52604,52605,52606,52607,52608,52609,52762,52763,52764,52787,52970,52971,52972,52973,52986,52987,52988,52989,52990,52991,53060,53156,53222,53224,53226,53227,53229,53234,53421,53439,53440,53441,53863,53870,54230,54300,54314,54441,54486,54653,54751,54752,54765,55349,55525,55526,55561,55675,55679,55703,55922,55923,55936,55939,55940,55941,55942,55943,55944,56097,56099,56248,56461,56462,56463,57764,57877,57878,57965,58326,58358,58600,58601,59134,59135,59372,59373,59921,60678,60708,60930,60931,61094,61534,61535,61594,61608,62372,62493,62614,63156,63157,63158,63159,63160,63161,63162,63163,63164,63165,63166,63167,63168,63321,63322,63409,63574,63688,63722,63943,64034,64147,64171,64172,64175,64191,64368,64678,64679,64874,64875,65163,65164,65165,65239,65556,65558,65685,65686,65687,65688,65689,65690,65691,65692,65696,65697,65698,65699,65700,65701,65702,65733,65734,65853,65912,66121,66284,66287,66288,66289,66308,66498,66499,66501,66731,66732,67294,67295,67296,67366,67367,67368,67495,67496,67907,67948,68130,68131,68535,68640,68730,68731,69212,69351,69352,69353) [ RunTime:0.000462s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.000409s ]
SELECT * FROM `tp_goods_attr` WHERE `goods_id` IN (32067,32374,32381,32386,32397,32401,32406,32412,32420,32443,32482,32493,32503,32519,32526,32537,32539,32543,32558,32575,32580,32585,32593,32594,32599,32604,32606,32617,32627,32639,32675,32689,32709,32712,32717,32736,32747,32772,32799,32806,34118,34788,34811,34812,34813,34816,34817,34818,34819,34820,34821,34822,34823,34824,34825,34834,34894,35074,35204,36050,36151,36165,36241,36471,36559,36569,36676,36879,37068,37252,37253,37260,37262,37425,37426,37489,37623,37629,37631,37640,37641,37642,37644,37670,37775,38230,38252,38254,38325,38374,38375,38712,39119,39260,39442,39630,40076,40131,40132,40133,40137,40138,40139,40141,40144,40209,40242,40449,40484,40514,40515,40573,40674,40807,40809,40852,40853,40995,41037,41110,41194,41428,41635,42064,42065,42087,42089,42205,42206,42211,42212,42292,42371,42540,42743,43019,43144,43145,43146,43176,43297,43298,43306,43307,43421,43505,43809,43910,43911,43920,43921,44028,44161,44166,44167,44244,44389,44390,44413,44414,44427,44758,44759,44760,44937,44948,45118,45119,45120,45121,45122,45124,45126,45127,45129,45130,45131,45132,45134,45137,45138,45139,45229,45321,45322,45352,45425,45426,45489,45490,45492,45493,45494,45495,45496,45515,45516,45517,45518,45519,45520,45598,45615,46149,46773,46774,46894,46895,46896,47490,47571,47572,47841,47958,47959,47960,48099,48100,48109,48121,48122,48123,48124,48125,48126,48230,48232,48334,48335,49130,49359,49416,49588,49631,49695,49696,49738,49804,49961,50322,50323,50328,50331,50332,50335,51068,51069,51070,51107,51128,51506,51507,51634,51782,51783,52603,52604,52605,52606,52607,52608,52609,52762,52763,52764,52787,52970,52971,52972,52973,52986,52987,52988,52989,52990,52991,53060,53156,53222,53224,53226,53227,53229,53234,53421,53439,53440,53441,53863,53870,54230,54300,54314,54441,54486,54653,54751,54752,54765,55349,55525,55526,55561,55675,55679,55703,55922,55923,55936,55939,55940,55941,55942,55943,55944,56097,56099,56248,56461,56462,56463,57764,57877,57878,57965,58326,58358,58600,58601,59134,59135,59372,59373,59921,60678,60708,60930,60931,61094,61534,61535,61594,61608,62372,62493,62614,63156,63157,63158,63159,63160,63161,63162,63163,63164,63165,63166,63167,63168,63321,63322,63409,63574,63688,63722,63943,64034,64147,64171,64172,64175,64191,64368,64678,64679,64874,64875,65163,65164,65165,65239,65556,65558,65685,65686,65687,65688,65689,65690,65691,65692,65696,65697,65698,65699,65700,65701,65702,65733,65734,65853,65912,66121,66284,66287,66288,66289,66308,66498,66499,66501,66731,66732,67294,67295,67296,67366,67367,67368,67495,67496,67907,67948,68130,68131,68535,68640,68730,68731,69212,69351,69352,69353) AND `attr_value` <> '' [ RunTime:0.005137s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.000471s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.000160s ]
SELECT * FROM `tp_goods` WHERE `goods_id` IN (32067,32374,32381,32386,32397,32401,32406,32412,32420,32443,32482,32493,32503,32519,32526,32537,32539,32543,32558,32575,32580,32585,32593,32594,32599,32604,32606,32617,32627,32639,32675,32689,32709,32712,32717,32736,32747,32772,32799,32806,34118,34788,34811,34812,34813,34816,34817,34818,34819,34820,34821,34822,34823,34824,34825,34834,34894,35074,35204,36050,36151,36165,36241,36471,36559,36569,36676,36879,37068,37252,37253,37260,37262,37425,37426,37489,37623,37629,37631,37640,37641,37642,37644,37670,37775,38230,38252,38254,38325,38374,38375,38712,39119,39260,39442,39630,40076,40131,40132,40133,40137,40138,40139,40141,40144,40209,40242,40449,40484,40514,40515,40573,40674,40807,40809,40852,40853,40995,41037,41110,41194,41428,41635,42064,42065,42087,42089,42205,42206,42211,42212,42292,42371,42540,42743,43019,43144,43145,43146,43176,43297,43298,43306,43307,43421,43505,43809,43910,43911,43920,43921,44028,44161,44166,44167,44244,44389,44390,44413,44414,44427,44758,44759,44760,44937,44948,45118,45119,45120,45121,45122,45124,45126,45127,45129,45130,45131,45132,45134,45137,45138,45139,45229,45321,45322,45352,45425,45426,45489,45490,45492,45493,45494,45495,45496,45515,45516,45517,45518,45519,45520,45598,45615,46149,46773,46774,46894,46895,46896,47490,47571,47572,47841,47958,47959,47960,48099,48100,48109,48121,48122,48123,48124,48125,48126,48230,48232,48334,48335,49130,49359,49416,49588,49631,49695,49696,49738,49804,49961,50322,50323,50328,50331,50332,50335,51068,51069,51070,51107,51128,51506,51507,51634,51782,51783,52603,52604,52605,52606,52607,52608,52609,52762,52763,52764,52787,52970,52971,52972,52973,52986,52987,52988,52989,52990,52991,53060,53156,53222,53224,53226,53227,53229,53234,53421,53439,53440,53441,53863,53870,54230,54300,54314,54441,54486,54653,54751,54752,54765,55349,55525,55526,55561,55675,55679,55703,55922,55923,55936,55939,55940,55941,55942,55943,55944,56097,56099,56248,56461,56462,56463,57764,57877,57878,57965,58326,58358,58600,58601,59134,59135,59372,59373,59921,60678,60708,60930,60931,61094,61534,61535,61594,61608,62372,62493,62614,63156,63157,63158,63159,63160,63161,63162,63163,63164,63165,63166,63167,63168,63321,63322,63409,63574,63688,63722,63943,64034,64147,64171,64172,64175,64191,64368,64678,64679,64874,64875,65163,65164,65165,65239,65556,65558,65685,65686,65687,65688,65689,65690,65691,65692,65696,65697,65698,65699,65700,65701,65702,65733,65734,65853,65912,66121,66284,66287,66288,66289,66308,66498,66499,66501,66731,66732,67294,67295,67296,67366,67367,67368,67495,67496,67907,67948,68130,68131,68535,68640,68730,68731,69212,69351,69352,69353) ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.004826s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000494s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (32067,32374,32381,32386,32397,32401,32406,32412,32420,32443) [ RunTime:0.000552s ]
SHOW FULL COLUMNS FROM `tp_goods_label` [ RunTime:0.000509s ]
SELECT `label_id`,`label_name` FROM `tp_goods_label` [ RunTime:0.000144s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.000201s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32067 LIMIT 1 [ RunTime:0.000241s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32374 LIMIT 1 [ RunTime:0.000213s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32381 LIMIT 1 [ RunTime:0.000217s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32386 LIMIT 1 [ RunTime:0.000211s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32397 LIMIT 1 [ RunTime:0.000222s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32401 LIMIT 1 [ RunTime:0.000212s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32406 LIMIT 1 [ RunTime:0.000222s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32412 LIMIT 1 [ RunTime:0.000232s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32420 LIMIT 1 [ RunTime:0.000197s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32443 LIMIT 1 [ RunTime:0.000160s ]
