SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000468s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1031 LIMIT 1 [ RunTime:0.000182s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000397s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 1031 [ RunTime:0.000137s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.000538s ]
SELECT `goods_id` FROM `tp_goods` WHERE `is_on_sale` = 1 AND `exchange_integral` = 0 AND `cat_id` IN (1031,1037,1038,1039,1040,1041,1042,1043,1044,1045,1046,1047,1048,1049,1050,1051,1052,1053,1054,1055,1056,1057,1058) [ RunTime:0.003487s ]
SELECT `zs_price` FROM `tp_goods` WHERE `goods_id` IN (31170,31175,31420,31421,31423,31616,31619,31627,31633,31637,31643,31649,31652,31657,31664,31687,31701,31801,31808,31809,31810,31976,32589,35004,35005,35006,35007,35008,35009,35011,35012,35013,35014,35015,35016,35017,35018,35019,35021,35022,35023,35024,35025,35026,35028,35029,35101,35102,37120,37369,39355,39978,42750,43128,43391,44315,46939,48237,50550,51810,51923,52835,52836,52840,52841,52842,52994,53016,53878,54197,54417,55378,55576,55851,56031,56103,56717,57194,57197,57436,57566,57697,57867,58307,58315,58364,58366,59198,61287,62205,63251,63675,63677,63735,64238,64629,65005,66124,66334,67381,68111,68884,68981,69013,31019,31025,31030,31042,31046,31050,31060,31083,31183,31188,31192,31198,31821,31825,31828,31836,31839,31841,31845,31849,31853,31855,31860,31876,31881,31886,31888,31893,31898,31978,31979,31980,33705,33741,35134,35135,37301,37715,37716,44675,45472,49616,53458,55013,55063,55884,56984,58488,63086,63676,66078,66333,68019,31358,31361,31370,31371,31374,33184,33191,33194,33199,33203,33222,34140,36677,37069,37269,40293,40294,42717,43533,43836,43865,43868,43869,43870,44035,44094,45340,46531,51391,53418,53419,53420,53483,53700,53757,53758,53759,53856,53906,53910,53921,53936,53937,53945,53946,53947,53949,53950,53954,53957,53959,53965,54024,54025,54026,54029,54032,54038,54040,54042,54153,54160,54162,54198,54327,55241,55365,56197,56283,56508,57378,58143,58784,64312,64570,64571,64572,64573,64574,64578,64579,64581,64582,64583,64584,64585,64588,64589,64590,64591,64592,64595,64611,64780,64794,65045,65048,65614,65683,66058,66111,66313,66505,67031,67275,67568,67611,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,31241,31246,31262,31266,31271,33924,47498,51151,51168,51169,51170,51241,53608,55173,55211,55212,55933,55946,56853,60146,65502,65838,67118,31281,31285,31315,31324,31333,31587,31981,31982,34978,34979,34980,36044,42995,45027,49841,49901,51501,55665,60236,65695,31220,35812,48211,48480,49499,50990,59873,61208,69395,31224,31227,31230,31234,31239,40724,59625,59626,62078,69459,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,31872,31880,31883,31889,31895,50232,53491,59036,59280,60705,61707,66033,66034,66964,63252,32065,32637,32644,32649,32669,32674,32680,32681,32692,32714,32716,32719,32722,32726,32728,32731,32733,32746,32749,32760,32761,32765,32770,32776,32787,32796,32798,32801,32805,32817,32821,32831,32836,32837,32840,32847,32851,32853,32854,32857,32859,32861,32862,32863,32864,32866,32869,32871,32875,32877,32879,32889,32894,32900,32903,32908,32910,32915,32917,32921,32923,32924,32926,32927,32929,32934,32937,32942,32944,32948,32954,32959,32963,32973,32978,32986,32992,32993,32999,33002,33018,33035,33036,33050,33052,33055,33059,33063,33077,33081,33084,33086,33088,33097,33098,33099,33102,33103,33105,33107,33109,33113,33117,33118,33122,33129,33135,33138,33146,33147,33150,33153,33155,33157,33160,33163,33165,33169,33176,33180,33183,33188,33198,33201,33223,33227,33230,33234,33238,33242,33246,33249,33253,33256,33258,33268,33274,33276,33277,33971,33973,33974,33975,33976,33980,33982,33983,33984,33988,33990,33991,33992,33993,33994,34695,34697,34698,34699,34700,34701,34702,34711,34712,34713,34714,34715,34716,34717,34718,34720,34721,34722,34723,34729,34732,34733,34749,34750,34751,34752,34753,34754,34756,34758,34759,34760,34761,34764,34767,34769,34770,34771,34772,34773,34774,34776,34777,34778,34779,34782,34789,34790,34791,34792,34793,34794,34795,34796,35508,35660,35661,35665,35672,35673,35680,35681,35684,35689,35690,35695,35696,35697,35698,35701,36040,37717,39020,39130,44188,44929,32054,32550,32553,32557,32587,32967,33611,33642,33643,33647,33649,33656,33732,33747,33775,33783,33785,33929,33930,33931,33934,33935,33937,33939,33959,33960,33964,33966,33967,34780,34781,34797,34798,34799,34800,34801,34802,34803,34804,35435,35480,35482,35495,35505,35509,35512,35513,35515,35528,35540,35737,35740,35747,35748,35749,35752,35753,35754,37718,38619,39131,41974,44296,45043,45076,45086,36029,36030,36031,36032,36033,36034,36756,36799,37689,37719,38201,39220,39235,40561,41234,41518,41519,41520,41521,41523,41524,41525,41526,41527,41528,41529,41893,42042,42472,42473,42654,42655,42656,42657,42658,42659,42660,42661,42664,42665,42667,42668,42669,42999,43022,43218,43291,43498,43499,43739,43803,44756,44757,44889,44950,45526,47482,47722,47839,48242,48317,48319,48320,48325,48328,48329,48330,48331,48332,48336,48337,48338,48340,48341,48342,48343,48344,48345,48351,48383,48384,48385,48387,48388,48389,48390,48391,48392,48393,48394,49391,51244,52046,54143,54890,55508,55866,56815,56816,56817,56818,56819,57101,57879,59956,60358,60949,61631,64462,64463,64487,65183,65353,66918,68479,68980,69359,69456,32342,32344,32367,34999,35000,36043,36067,36886,37415,37702,37703,37704,38886,38899,39261,40215,41373,41378,41427,42818,44926,44932,45441,46722,47851,49264,49265,49314,49900,50726,51236,53395,54415,54664,54665,54744,55527,55528,55920,56055,58055,58056,58467,58482,58549,59430,61600,61990,62820,63449,64863,65423,67473,68950,32577,32583,32602,32603,32605,32624,32629,33263,33287,33305,33307,33312,33315,33319,33322,33326,33329,33338,33360,33369,33375,33377,33380,33392,33405,33412,33419,33427,33428,33436,33438,33446,33449,33456,33481,33494,33497,33499,33501,33502,33511,33512,33518,33523,33529,33547,33575,33577,33581,33600,33603,33604,33607,33940,33942,33943,33947,33948,33949,33951,33953,34055,34056,34057,34075,34681,34682,34683,34684,34685,34688,34689,34690,34691,34692,35474,35546,35559,35562,35564,35567,35568,35570,35574,35579,35605,37099,37699,38776,39431,41117,42593,42907,42908) [ RunTime:0.009983s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (31170,31175,31420,31421,31423,31616,31619,31627,31633,31637,31643,31649,31652,31657,31664,31687,31701,31801,31808,31809,31810,31976,32589,35004,35005,35006,35007,35008,35009,35011,35012,35013,35014,35015,35016,35017,35018,35019,35021,35022,35023,35024,35025,35026,35028,35029,35101,35102,37120,37369,39355,39978,42750,43128,43391,44315,46939,48237,50550,51810,51923,52835,52836,52840,52841,52842,52994,53016,53878,54197,54417,55378,55576,55851,56031,56103,56717,57194,57197,57436,57566,57697,57867,58307,58315,58364,58366,59198,61287,62205,63251,63675,63677,63735,64238,64629,65005,66124,66334,67381,68111,68884,68981,69013,31019,31025,31030,31042,31046,31050,31060,31083,31183,31188,31192,31198,31821,31825,31828,31836,31839,31841,31845,31849,31853,31855,31860,31876,31881,31886,31888,31893,31898,31978,31979,31980,33705,33741,35134,35135,37301,37715,37716,44675,45472,49616,53458,55013,55063,55884,56984,58488,63086,63676,66078,66333,68019,31358,31361,31370,31371,31374,33184,33191,33194,33199,33203,33222,34140,36677,37069,37269,40293,40294,42717,43533,43836,43865,43868,43869,43870,44035,44094,45340,46531,51391,53418,53419,53420,53483,53700,53757,53758,53759,53856,53906,53910,53921,53936,53937,53945,53946,53947,53949,53950,53954,53957,53959,53965,54024,54025,54026,54029,54032,54038,54040,54042,54153,54160,54162,54198,54327,55241,55365,56197,56283,56508,57378,58143,58784,64312,64570,64571,64572,64573,64574,64578,64579,64581,64582,64583,64584,64585,64588,64589,64590,64591,64592,64595,64611,64780,64794,65045,65048,65614,65683,66058,66111,66313,66505,67031,67275,67568,67611,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,31241,31246,31262,31266,31271,33924,47498,51151,51168,51169,51170,51241,53608,55173,55211,55212,55933,55946,56853,60146,65502,65838,67118,31281,31285,31315,31324,31333,31587,31981,31982,34978,34979,34980,36044,42995,45027,49841,49901,51501,55665,60236,65695,31220,35812,48211,48480,49499,50990,59873,61208,69395,31224,31227,31230,31234,31239,40724,59625,59626,62078,69459,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,31872,31880,31883,31889,31895,50232,53491,59036,59280,60705,61707,66033,66034,66964,63252,32065,32637,32644,32649,32669,32674,32680,32681,32692,32714,32716,32719,32722,32726,32728,32731,32733,32746,32749,32760,32761,32765,32770,32776,32787,32796,32798,32801,32805,32817,32821,32831,32836,32837,32840,32847,32851,32853,32854,32857,32859,32861,32862,32863,32864,32866,32869,32871,32875,32877,32879,32889,32894,32900,32903,32908,32910,32915,32917,32921,32923,32924,32926,32927,32929,32934,32937,32942,32944,32948,32954,32959,32963,32973,32978,32986,32992,32993,32999,33002,33018,33035,33036,33050,33052,33055,33059,33063,33077,33081,33084,33086,33088,33097,33098,33099,33102,33103,33105,33107,33109,33113,33117,33118,33122,33129,33135,33138,33146,33147,33150,33153,33155,33157,33160,33163,33165,33169,33176,33180,33183,33188,33198,33201,33223,33227,33230,33234,33238,33242,33246,33249,33253,33256,33258,33268,33274,33276,33277,33971,33973,33974,33975,33976,33980,33982,33983,33984,33988,33990,33991,33992,33993,33994,34695,34697,34698,34699,34700,34701,34702,34711,34712,34713,34714,34715,34716,34717,34718,34720,34721,34722,34723,34729,34732,34733,34749,34750,34751,34752,34753,34754,34756,34758,34759,34760,34761,34764,34767,34769,34770,34771,34772,34773,34774,34776,34777,34778,34779,34782,34789,34790,34791,34792,34793,34794,34795,34796,35508,35660,35661,35665,35672,35673,35680,35681,35684,35689,35690,35695,35696,35697,35698,35701,36040,37717,39020,39130,44188,44929,32054,32550,32553,32557,32587,32967,33611,33642,33643,33647,33649,33656,33732,33747,33775,33783,33785,33929,33930,33931,33934,33935,33937,33939,33959,33960,33964,33966,33967,34780,34781,34797,34798,34799,34800,34801,34802,34803,34804,35435,35480,35482,35495,35505,35509,35512,35513,35515,35528,35540,35737,35740,35747,35748,35749,35752,35753,35754,37718,38619,39131,41974,44296,45043,45076,45086,36029,36030,36031,36032,36033,36034,36756,36799,37689,37719,38201,39220,39235,40561,41234,41518,41519,41520,41521,41523,41524,41525,41526,41527,41528,41529,41893,42042,42472,42473,42654,42655,42656,42657,42658,42659,42660,42661,42664,42665,42667,42668,42669,42999,43022,43218,43291,43498,43499,43739,43803,44756,44757,44889,44950,45526,47482,47722,47839,48242,48317,48319,48320,48325,48328,48329,48330,48331,48332,48336,48337,48338,48340,48341,48342,48343,48344,48345,48351,48383,48384,48385,48387,48388,48389,48390,48391,48392,48393,48394,49391,51244,52046,54143,54890,55508,55866,56815,56816,56817,56818,56819,57101,57879,59956,60358,60949,61631,64462,64463,64487,65183,65353,66918,68479,68980,69359,69456,32342,32344,32367,34999,35000,36043,36067,36886,37415,37702,37703,37704,38886,38899,39261,40215,41373,41378,41427,42818,44926,44932,45441,46722,47851,49264,49265,49314,49900,50726,51236,53395,54415,54664,54665,54744,55527,55528,55920,56055,58055,58056,58467,58482,58549,59430,61600,61990,62820,63449,64863,65423,67473,68950,32577,32583,32602,32603,32605,32624,32629,33263,33287,33305,33307,33312,33315,33319,33322,33326,33329,33338,33360,33369,33375,33377,33380,33392,33405,33412,33419,33427,33428,33436,33438,33446,33449,33456,33481,33494,33497,33499,33501,33502,33511,33512,33518,33523,33529,33547,33575,33577,33581,33600,33603,33604,33607,33940,33942,33943,33947,33948,33949,33951,33953,34055,34056,34057,34075,34681,34682,34683,34684,34685,34688,34689,34690,34691,34692,35474,35546,35559,35562,35564,35567,35568,35570,35574,35579,35605,37099,37699,38776,39431,41117,42593,42907,42908) AND `brand_id` > 0 [ RunTime:0.010170s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.000647s ]
SELECT * FROM `tp_brand` WHERE `id` IN (4664,4746,4749,4659,4580,4660,4505,4585,4478,4622,4435,4698,4751,4752,4511,4754,4678,4611,4612,4668,4760,4633,4767,4768,4769,4702,6466,6460,4657,4644,4630,4610,4605,6467,6459,6469,4603,6456,6463,4670,4736,4675,6472,4651,6471,4547,6465,4665,4466,4691,6462,4609,4974,4658,6357,6492,5216,5563,5407,4833,5808,5809,5810,5811,5850,6458,6266,6411,5955,6457,5984,5985,6528,5993,4650,4570,6452,5371,6037,6055,6103,4525,6117,6058,6120,6153,6162,6455,4589,6263,6232,6453,6454,5053,6711,6734,6739,4546,5008,7139,6918,4654,4674,4673,4672,7603,7604,7605,4962,4887,7627,4784,6940,4884,6661,4544,4581,4744,7026,7725,4558,7734,7048,6681,7058,4717,4714,4885,5085,4695,7872,7166,4936,4666,5007,4582,6541,4586,4874,5918,6740,5933,8048,7548,4652,7527,7994,4969,4631,8121) GROUP BY `name` LIMIT 30 [ RunTime:0.001905s ]
select group_concat(`key` separator '_') as `key` from tp_spec_goods_price where goods_id in(31170,31175,31420,31421,31423,31616,31619,31627,31633,31637,31643,31649,31652,31657,31664,31687,31701,31801,31808,31809,31810,31976,32589,35004,35005,35006,35007,35008,35009,35011,35012,35013,35014,35015,35016,35017,35018,35019,35021,35022,35023,35024,35025,35026,35028,35029,35101,35102,37120,37369,39355,39978,42750,43128,43391,44315,46939,48237,50550,51810,51923,52835,52836,52840,52841,52842,52994,53016,53878,54197,54417,55378,55576,55851,56031,56103,56717,57194,57197,57436,57566,57697,57867,58307,58315,58364,58366,59198,61287,62205,63251,63675,63677,63735,64238,64629,65005,66124,66334,67381,68111,68884,68981,69013,31019,31025,31030,31042,31046,31050,31060,31083,31183,31188,31192,31198,31821,31825,31828,31836,31839,31841,31845,31849,31853,31855,31860,31876,31881,31886,31888,31893,31898,31978,31979,31980,33705,33741,35134,35135,37301,37715,37716,44675,45472,49616,53458,55013,55063,55884,56984,58488,63086,63676,66078,66333,68019,31358,31361,31370,31371,31374,33184,33191,33194,33199,33203,33222,34140,36677,37069,37269,40293,40294,42717,43533,43836,43865,43868,43869,43870,44035,44094,45340,46531,51391,53418,53419,53420,53483,53700,53757,53758,53759,53856,53906,53910,53921,53936,53937,53945,53946,53947,53949,53950,53954,53957,53959,53965,54024,54025,54026,54029,54032,54038,54040,54042,54153,54160,54162,54198,54327,55241,55365,56197,56283,56508,57378,58143,58784,64312,64570,64571,64572,64573,64574,64578,64579,64581,64582,64583,64584,64585,64588,64589,64590,64591,64592,64595,64611,64780,64794,65045,65048,65614,65683,66058,66111,66313,66505,67031,67275,67568,67611,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,31241,31246,31262,31266,31271,33924,47498,51151,51168,51169,51170,51241,53608,55173,55211,55212,55933,55946,56853,60146,65502,65838,67118,31281,31285,31315,31324,31333,31587,31981,31982,34978,34979,34980,36044,42995,45027,49841,49901,51501,55665,60236,65695,31220,35812,48211,48480,49499,50990,59873,61208,69395,31224,31227,31230,31234,31239,40724,59625,59626,62078,69459,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,31872,31880,31883,31889,31895,50232,53491,59036,59280,60705,61707,66033,66034,66964,63252,32065,32637,32644,32649,32669,32674,32680,32681,32692,32714,32716,32719,32722,32726,32728,32731,32733,32746,32749,32760,32761,32765,32770,32776,32787,32796,32798,32801,32805,32817,32821,32831,32836,32837,32840,32847,32851,32853,32854,32857,32859,32861,32862,32863,32864,32866,32869,32871,32875,32877,32879,32889,32894,32900,32903,32908,32910,32915,32917,32921,32923,32924,32926,32927,32929,32934,32937,32942,32944,32948,32954,32959,32963,32973,32978,32986,32992,32993,32999,33002,33018,33035,33036,33050,33052,33055,33059,33063,33077,33081,33084,33086,33088,33097,33098,33099,33102,33103,33105,33107,33109,33113,33117,33118,33122,33129,33135,33138,33146,33147,33150,33153,33155,33157,33160,33163,33165,33169,33176,33180,33183,33188,33198,33201,33223,33227,33230,33234,33238,33242,33246,33249,33253,33256,33258,33268,33274,33276,33277,33971,33973,33974,33975,33976,33980,33982,33983,33984,33988,33990,33991,33992,33993,33994,34695,34697,34698,34699,34700,34701,34702,34711,34712,34713,34714,34715,34716,34717,34718,34720,34721,34722,34723,34729,34732,34733,34749,34750,34751,34752,34753,34754,34756,34758,34759,34760,34761,34764,34767,34769,34770,34771,34772,34773,34774,34776,34777,34778,34779,34782,34789,34790,34791,34792,34793,34794,34795,34796,35508,35660,35661,35665,35672,35673,35680,35681,35684,35689,35690,35695,35696,35697,35698,35701,36040,37717,39020,39130,44188,44929,32054,32550,32553,32557,32587,32967,33611,33642,33643,33647,33649,33656,33732,33747,33775,33783,33785,33929,33930,33931,33934,33935,33937,33939,33959,33960,33964,33966,33967,34780,34781,34797,34798,34799,34800,34801,34802,34803,34804,35435,35480,35482,35495,35505,35509,35512,35513,35515,35528,35540,35737,35740,35747,35748,35749,35752,35753,35754,37718,38619,39131,41974,44296,45043,45076,45086,36029,36030,36031,36032,36033,36034,36756,36799,37689,37719,38201,39220,39235,40561,41234,41518,41519,41520,41521,41523,41524,41525,41526,41527,41528,41529,41893,42042,42472,42473,42654,42655,42656,42657,42658,42659,42660,42661,42664,42665,42667,42668,42669,42999,43022,43218,43291,43498,43499,43739,43803,44756,44757,44889,44950,45526,47482,47722,47839,48242,48317,48319,48320,48325,48328,48329,48330,48331,48332,48336,48337,48338,48340,48341,48342,48343,48344,48345,48351,48383,48384,48385,48387,48388,48389,48390,48391,48392,48393,48394,49391,51244,52046,54143,54890,55508,55866,56815,56816,56817,56818,56819,57101,57879,59956,60358,60949,61631,64462,64463,64487,65183,65353,66918,68479,68980,69359,69456,32342,32344,32367,34999,35000,36043,36067,36886,37415,37702,37703,37704,38886,38899,39261,40215,41373,41378,41427,42818,44926,44932,45441,46722,47851,49264,49265,49314,49900,50726,51236,53395,54415,54664,54665,54744,55527,55528,55920,56055,58055,58056,58467,58482,58549,59430,61600,61990,62820,63449,64863,65423,67473,68950,32577,32583,32602,32603,32605,32624,32629,33263,33287,33305,33307,33312,33315,33319,33322,33326,33329,33338,33360,33369,33375,33377,33380,33392,33405,33412,33419,33427,33428,33436,33438,33446,33449,33456,33481,33494,33497,33499,33501,33502,33511,33512,33518,33523,33529,33547,33575,33577,33581,33600,33603,33604,33607,33940,33942,33943,33947,33948,33949,33951,33953,34055,34056,34057,34075,34681,34682,34683,34684,34685,34688,34689,34690,34691,34692,35474,35546,35559,35562,35564,35567,35568,35570,35574,35579,35605,37099,37699,38776,39431,41117,42593,42907,42908) [ RunTime:0.001081s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.000452s ]
SELECT * FROM `tp_goods_attr` WHERE `goods_id` IN (31170,31175,31420,31421,31423,31616,31619,31627,31633,31637,31643,31649,31652,31657,31664,31687,31701,31801,31808,31809,31810,31976,32589,35004,35005,35006,35007,35008,35009,35011,35012,35013,35014,35015,35016,35017,35018,35019,35021,35022,35023,35024,35025,35026,35028,35029,35101,35102,37120,37369,39355,39978,42750,43128,43391,44315,46939,48237,50550,51810,51923,52835,52836,52840,52841,52842,52994,53016,53878,54197,54417,55378,55576,55851,56031,56103,56717,57194,57197,57436,57566,57697,57867,58307,58315,58364,58366,59198,61287,62205,63251,63675,63677,63735,64238,64629,65005,66124,66334,67381,68111,68884,68981,69013,31019,31025,31030,31042,31046,31050,31060,31083,31183,31188,31192,31198,31821,31825,31828,31836,31839,31841,31845,31849,31853,31855,31860,31876,31881,31886,31888,31893,31898,31978,31979,31980,33705,33741,35134,35135,37301,37715,37716,44675,45472,49616,53458,55013,55063,55884,56984,58488,63086,63676,66078,66333,68019,31358,31361,31370,31371,31374,33184,33191,33194,33199,33203,33222,34140,36677,37069,37269,40293,40294,42717,43533,43836,43865,43868,43869,43870,44035,44094,45340,46531,51391,53418,53419,53420,53483,53700,53757,53758,53759,53856,53906,53910,53921,53936,53937,53945,53946,53947,53949,53950,53954,53957,53959,53965,54024,54025,54026,54029,54032,54038,54040,54042,54153,54160,54162,54198,54327,55241,55365,56197,56283,56508,57378,58143,58784,64312,64570,64571,64572,64573,64574,64578,64579,64581,64582,64583,64584,64585,64588,64589,64590,64591,64592,64595,64611,64780,64794,65045,65048,65614,65683,66058,66111,66313,66505,67031,67275,67568,67611,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,31241,31246,31262,31266,31271,33924,47498,51151,51168,51169,51170,51241,53608,55173,55211,55212,55933,55946,56853,60146,65502,65838,67118,31281,31285,31315,31324,31333,31587,31981,31982,34978,34979,34980,36044,42995,45027,49841,49901,51501,55665,60236,65695,31220,35812,48211,48480,49499,50990,59873,61208,69395,31224,31227,31230,31234,31239,40724,59625,59626,62078,69459,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,31872,31880,31883,31889,31895,50232,53491,59036,59280,60705,61707,66033,66034,66964,63252,32065,32637,32644,32649,32669,32674,32680,32681,32692,32714,32716,32719,32722,32726,32728,32731,32733,32746,32749,32760,32761,32765,32770,32776,32787,32796,32798,32801,32805,32817,32821,32831,32836,32837,32840,32847,32851,32853,32854,32857,32859,32861,32862,32863,32864,32866,32869,32871,32875,32877,32879,32889,32894,32900,32903,32908,32910,32915,32917,32921,32923,32924,32926,32927,32929,32934,32937,32942,32944,32948,32954,32959,32963,32973,32978,32986,32992,32993,32999,33002,33018,33035,33036,33050,33052,33055,33059,33063,33077,33081,33084,33086,33088,33097,33098,33099,33102,33103,33105,33107,33109,33113,33117,33118,33122,33129,33135,33138,33146,33147,33150,33153,33155,33157,33160,33163,33165,33169,33176,33180,33183,33188,33198,33201,33223,33227,33230,33234,33238,33242,33246,33249,33253,33256,33258,33268,33274,33276,33277,33971,33973,33974,33975,33976,33980,33982,33983,33984,33988,33990,33991,33992,33993,33994,34695,34697,34698,34699,34700,34701,34702,34711,34712,34713,34714,34715,34716,34717,34718,34720,34721,34722,34723,34729,34732,34733,34749,34750,34751,34752,34753,34754,34756,34758,34759,34760,34761,34764,34767,34769,34770,34771,34772,34773,34774,34776,34777,34778,34779,34782,34789,34790,34791,34792,34793,34794,34795,34796,35508,35660,35661,35665,35672,35673,35680,35681,35684,35689,35690,35695,35696,35697,35698,35701,36040,37717,39020,39130,44188,44929,32054,32550,32553,32557,32587,32967,33611,33642,33643,33647,33649,33656,33732,33747,33775,33783,33785,33929,33930,33931,33934,33935,33937,33939,33959,33960,33964,33966,33967,34780,34781,34797,34798,34799,34800,34801,34802,34803,34804,35435,35480,35482,35495,35505,35509,35512,35513,35515,35528,35540,35737,35740,35747,35748,35749,35752,35753,35754,37718,38619,39131,41974,44296,45043,45076,45086,36029,36030,36031,36032,36033,36034,36756,36799,37689,37719,38201,39220,39235,40561,41234,41518,41519,41520,41521,41523,41524,41525,41526,41527,41528,41529,41893,42042,42472,42473,42654,42655,42656,42657,42658,42659,42660,42661,42664,42665,42667,42668,42669,42999,43022,43218,43291,43498,43499,43739,43803,44756,44757,44889,44950,45526,47482,47722,47839,48242,48317,48319,48320,48325,48328,48329,48330,48331,48332,48336,48337,48338,48340,48341,48342,48343,48344,48345,48351,48383,48384,48385,48387,48388,48389,48390,48391,48392,48393,48394,49391,51244,52046,54143,54890,55508,55866,56815,56816,56817,56818,56819,57101,57879,59956,60358,60949,61631,64462,64463,64487,65183,65353,66918,68479,68980,69359,69456,32342,32344,32367,34999,35000,36043,36067,36886,37415,37702,37703,37704,38886,38899,39261,40215,41373,41378,41427,42818,44926,44932,45441,46722,47851,49264,49265,49314,49900,50726,51236,53395,54415,54664,54665,54744,55527,55528,55920,56055,58055,58056,58467,58482,58549,59430,61600,61990,62820,63449,64863,65423,67473,68950,32577,32583,32602,32603,32605,32624,32629,33263,33287,33305,33307,33312,33315,33319,33322,33326,33329,33338,33360,33369,33375,33377,33380,33392,33405,33412,33419,33427,33428,33436,33438,33446,33449,33456,33481,33494,33497,33499,33501,33502,33511,33512,33518,33523,33529,33547,33575,33577,33581,33600,33603,33604,33607,33940,33942,33943,33947,33948,33949,33951,33953,34055,34056,34057,34075,34681,34682,34683,34684,34685,34688,34689,34690,34691,34692,35474,35546,35559,35562,35564,35567,35568,35570,35574,35579,35605,37099,37699,38776,39431,41117,42593,42907,42908) AND `attr_value` <> '' [ RunTime:0.013248s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.000602s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.000167s ]
SELECT * FROM `tp_goods` WHERE `goods_id` IN (31170,31175,31420,31421,31423,31616,31619,31627,31633,31637,31643,31649,31652,31657,31664,31687,31701,31801,31808,31809,31810,31976,32589,35004,35005,35006,35007,35008,35009,35011,35012,35013,35014,35015,35016,35017,35018,35019,35021,35022,35023,35024,35025,35026,35028,35029,35101,35102,37120,37369,39355,39978,42750,43128,43391,44315,46939,48237,50550,51810,51923,52835,52836,52840,52841,52842,52994,53016,53878,54197,54417,55378,55576,55851,56031,56103,56717,57194,57197,57436,57566,57697,57867,58307,58315,58364,58366,59198,61287,62205,63251,63675,63677,63735,64238,64629,65005,66124,66334,67381,68111,68884,68981,69013,31019,31025,31030,31042,31046,31050,31060,31083,31183,31188,31192,31198,31821,31825,31828,31836,31839,31841,31845,31849,31853,31855,31860,31876,31881,31886,31888,31893,31898,31978,31979,31980,33705,33741,35134,35135,37301,37715,37716,44675,45472,49616,53458,55013,55063,55884,56984,58488,63086,63676,66078,66333,68019,31358,31361,31370,31371,31374,33184,33191,33194,33199,33203,33222,34140,36677,37069,37269,40293,40294,42717,43533,43836,43865,43868,43869,43870,44035,44094,45340,46531,51391,53418,53419,53420,53483,53700,53757,53758,53759,53856,53906,53910,53921,53936,53937,53945,53946,53947,53949,53950,53954,53957,53959,53965,54024,54025,54026,54029,54032,54038,54040,54042,54153,54160,54162,54198,54327,55241,55365,56197,56283,56508,57378,58143,58784,64312,64570,64571,64572,64573,64574,64578,64579,64581,64582,64583,64584,64585,64588,64589,64590,64591,64592,64595,64611,64780,64794,65045,65048,65614,65683,66058,66111,66313,66505,67031,67275,67568,67611,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,31241,31246,31262,31266,31271,33924,47498,51151,51168,51169,51170,51241,53608,55173,55211,55212,55933,55946,56853,60146,65502,65838,67118,31281,31285,31315,31324,31333,31587,31981,31982,34978,34979,34980,36044,42995,45027,49841,49901,51501,55665,60236,65695,31220,35812,48211,48480,49499,50990,59873,61208,69395,31224,31227,31230,31234,31239,40724,59625,59626,62078,69459,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,31872,31880,31883,31889,31895,50232,53491,59036,59280,60705,61707,66033,66034,66964,63252,32065,32637,32644,32649,32669,32674,32680,32681,32692,32714,32716,32719,32722,32726,32728,32731,32733,32746,32749,32760,32761,32765,32770,32776,32787,32796,32798,32801,32805,32817,32821,32831,32836,32837,32840,32847,32851,32853,32854,32857,32859,32861,32862,32863,32864,32866,32869,32871,32875,32877,32879,32889,32894,32900,32903,32908,32910,32915,32917,32921,32923,32924,32926,32927,32929,32934,32937,32942,32944,32948,32954,32959,32963,32973,32978,32986,32992,32993,32999,33002,33018,33035,33036,33050,33052,33055,33059,33063,33077,33081,33084,33086,33088,33097,33098,33099,33102,33103,33105,33107,33109,33113,33117,33118,33122,33129,33135,33138,33146,33147,33150,33153,33155,33157,33160,33163,33165,33169,33176,33180,33183,33188,33198,33201,33223,33227,33230,33234,33238,33242,33246,33249,33253,33256,33258,33268,33274,33276,33277,33971,33973,33974,33975,33976,33980,33982,33983,33984,33988,33990,33991,33992,33993,33994,34695,34697,34698,34699,34700,34701,34702,34711,34712,34713,34714,34715,34716,34717,34718,34720,34721,34722,34723,34729,34732,34733,34749,34750,34751,34752,34753,34754,34756,34758,34759,34760,34761,34764,34767,34769,34770,34771,34772,34773,34774,34776,34777,34778,34779,34782,34789,34790,34791,34792,34793,34794,34795,34796,35508,35660,35661,35665,35672,35673,35680,35681,35684,35689,35690,35695,35696,35697,35698,35701,36040,37717,39020,39130,44188,44929,32054,32550,32553,32557,32587,32967,33611,33642,33643,33647,33649,33656,33732,33747,33775,33783,33785,33929,33930,33931,33934,33935,33937,33939,33959,33960,33964,33966,33967,34780,34781,34797,34798,34799,34800,34801,34802,34803,34804,35435,35480,35482,35495,35505,35509,35512,35513,35515,35528,35540,35737,35740,35747,35748,35749,35752,35753,35754,37718,38619,39131,41974,44296,45043,45076,45086,36029,36030,36031,36032,36033,36034,36756,36799,37689,37719,38201,39220,39235,40561,41234,41518,41519,41520,41521,41523,41524,41525,41526,41527,41528,41529,41893,42042,42472,42473,42654,42655,42656,42657,42658,42659,42660,42661,42664,42665,42667,42668,42669,42999,43022,43218,43291,43498,43499,43739,43803,44756,44757,44889,44950,45526,47482,47722,47839,48242,48317,48319,48320,48325,48328,48329,48330,48331,48332,48336,48337,48338,48340,48341,48342,48343,48344,48345,48351,48383,48384,48385,48387,48388,48389,48390,48391,48392,48393,48394,49391,51244,52046,54143,54890,55508,55866,56815,56816,56817,56818,56819,57101,57879,59956,60358,60949,61631,64462,64463,64487,65183,65353,66918,68479,68980,69359,69456,32342,32344,32367,34999,35000,36043,36067,36886,37415,37702,37703,37704,38886,38899,39261,40215,41373,41378,41427,42818,44926,44932,45441,46722,47851,49264,49265,49314,49900,50726,51236,53395,54415,54664,54665,54744,55527,55528,55920,56055,58055,58056,58467,58482,58549,59430,61600,61990,62820,63449,64863,65423,67473,68950,32577,32583,32602,32603,32605,32624,32629,33263,33287,33305,33307,33312,33315,33319,33322,33326,33329,33338,33360,33369,33375,33377,33380,33392,33405,33412,33419,33427,33428,33436,33438,33446,33449,33456,33481,33494,33497,33499,33501,33502,33511,33512,33518,33523,33529,33547,33575,33577,33581,33600,33603,33604,33607,33940,33942,33943,33947,33948,33949,33951,33953,34055,34056,34057,34075,34681,34682,34683,34684,34685,34688,34689,34690,34691,34692,35474,35546,35559,35562,35564,35567,35568,35570,35574,35579,35605,37099,37699,38776,39431,41117,42593,42907,42908) ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.008352s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000523s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (31019,31025,31030,31042,31046,31050,31060,31083,31160,31170) [ RunTime:0.001573s ]
SHOW FULL COLUMNS FROM `tp_goods_label` [ RunTime:0.000403s ]
SELECT `label_id`,`label_name` FROM `tp_goods_label` [ RunTime:0.000132s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.000208s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 31019 LIMIT 1 [ RunTime:0.000252s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 31025 LIMIT 1 [ RunTime:0.000172s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 31030 LIMIT 1 [ RunTime:0.000164s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 31042 LIMIT 1 [ RunTime:0.000254s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 31046 LIMIT 1 [ RunTime:0.000214s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 31050 LIMIT 1 [ RunTime:0.000879s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 31060 LIMIT 1 [ RunTime:0.000125s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 31083 LIMIT 1 [ RunTime:0.000109s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 31160 LIMIT 1 [ RunTime:0.000324s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 31170 LIMIT 1 [ RunTime:0.000160s ]
