SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.000818s ]
SELECT `zs_price` FROM `tp_goods` WHERE `goods_id` IN (30958,30959,30960,30964,30965,30966,30967,30968,30972,30973,30974,30984,30986,30987,30988,30989,30990,30991,30993,30997,31124,31126,31127,31128,31129,31131,31132,31135,31136,31137,31344,31423,31525,31526,31643,31695,31939,31946,31961,31989,32020,32021,32022,32025,32026,32027,32028,32029,32030,32031,32032,32033,32034,32035,32036,32037,32038,32061,32131,32134,32136,32137,32151,32154,32156,32158,32160,32163,32164,32165,32173,32174,32175,32181,32191,32192,32193,32194,32195,32197,32198,32199,32202,32203,32211,32214,32219,32220,32221,32226,32227,32229,32231,32259,32295,32296,32302,32333,32452,32479,32480,32481,32485,32521,32611,32661,32662,32952,32953,32964,32970,32996,33004,33153,33165,33201,33240,33335,33337,33380,33437,33457,33460,33464,33468,33470,33471,33552,33554,33555,33560,33585,33586,33588,33590,33693,33705,33707,33715,33724,33729,33743,33757,33758,33759,33760,33896,34296,34297,34298,34299,34300,34301,34302,34307,34309,34320,34328,34330,34331,34332,34333,34334,34335,34336,34340,34341,34342,34343,34344,34345,34346,34347,34348,34373,34501,34502,34503,34504,34505,34507,34508,34509,34546,34584,34641,34642,34643,34644,34753,34771,34778,34790,34796,34832,34866,34870,34880,34883,34885,34889,34890,34891,34907,34908,34936,34971,34972,34973,34981,34982,35003,35072,35073,35079,35081,35082,35083,35084,35108,35120,35126,35127,35142,35234,35291,35292,35293,35294,35326,35389,35393,35503,35511,35611,35819,35831,35867,35869,35870,35983,35986,35987,35995,35999,36000,36008,36011,36012,36028,36066,36073,36117,36148,36154,36211,36250,36253,36255,36256,36258,36284,36319,36327,36330,36331,36480,36481,36484,36537,36556,36567,36573,36612,36624,36625,36635,36663,36670,36674,36699,36700,36709,36757,36758,36765,36787,36788,36862,36867,36868,36869,36910,36912,36913,36937,36953,36960,36978,36981,36982,36983,36987,37036,37045,37049,37060,37074,37135,37159,37162,37192,37219,37228,37263,37264,37272,37286,37289,37294,37295,37304,37330,37334,37337,37338,37343,37355,37410,37435,37436,37438,37452,37531,37532,37533,37534,37535,37536,37538,37541,37551,37554,37555,37556,37559,37560,37563,37572,37573,37575,37577,37578,37579,37581,37585,37643,37672,37695,37722,37723,37724,37725,37748,37749,37768,37773,37779,37780,37786,37787,37794,37798,37801,37821,37823,37831,37833,37834,38042,38048,38049,38056,38093,38126,38147,38166,38178,38202,38203,38206,38207,38213,38216,38217,38221,38233,38237,38238,38243,38244,38246,38253,38270,38281,38294,38295,38318,38321,38357,38362,38363,38383,38386,38390,38394,38397,38401,38409,38410,38432,38438,38512,38517,38519,38528,38542,38589,38592,38613,38616,38624,38625,38626,38627,38630,38657,38668,38672,38679,38770,38771,38774,38788,38793,38796,38799,38801,38820,38821,38826,38828,38831,38836,38858,38861,38863,38887,38895,38902,38914,38924,38992,38993,39013,39036,39041,39048,39056,39061,39062,39076,39098,39100,39101,39106,39116,39132,39134,39143,39152,39153,39157,39183,39209,39236,39240,39245,39252,39263,39268,39269,39279,39314,39322,39328,39329,39332,39354,39367,39369,39370,39371,39387,39389,39393,39406,39409,39426,39428,39432,39435,39445,39460,39462,39477,39504,39505,39508,39509,39520,39550,39568,39590,39595,39612,39613,39621,39642,39660,39689,39720,39762,39861,39917,39933,39935,39942,39974,39992,40035,40037,40058,40084,40091,40095,40097,40098,40099,40104,40108,40119,40120,40122,40142,40149,40151,40160,40165,40185,40201,40208,40222,40224,40231,40234,40255,40256,40259,40325,40373,40374,40404,40405,40406,40407,40408,40438,40439,40444,40445,40446,40456,40523,40525,40526,40549,40566,40590,40596,40597,40598,40599,40614,40615,40618,40629,40635,40638,40655,40675,40680,40700,40713,40716,40722,40824,40866,40874,40892,40894,40900,40918,40922,40941,40966,40972,40981,40982,40984,40998,41000,41012,41035,41061,41062,41066,41079,41089,41090,41092,41099,41109,41129,41162,41163,41198,41199,41245,41254,41270,41275,41276,41284,41286,41288,41295,41308,41311,41332,41334,41349,41370,41371,41381,41395,41399,41404,41412,41430,41460,41461,41463,41494,41511,41539,41556,41558,41561,41563,41580,41581,41600,41639,41749,41776,41827,41829,41861,41896,42010,42012,42013,42023,42032,42034,42068,42069,42113,42114,42115,42127,42137,42188,42230,42232,42265,42289,42290,42296,42307,42325,42329,42354,42356,42357,42361,42365,42379,42382,42406,42422,42429,42446,42448,42468,42479,42480,42485,42489,42493,42494,42502,42538,42546,42550,42587,42647,42675,42676,42704,42707,42708,42716,42736,42762,42763,42764,42765,42772,42773,42776,42780,42811,42812,42845,42848,42850,42851,42854,42862,42865,42870,42919,42920,42932,42939,42940,42941,42944,42949,42973,43004,43007,43008,43010,43045,43066,43067,43072,43074,43104,43105,43122,43123,43150,43151,43226,43232,43251,43252,43254,43255,43256,43270,43284,43285,43334,43336,43340,43344,43345,43346,43347,43366,43392,43412,43431,43432,43450,43494,43501,43502,43503,43506,43507,43565,43568,43573,43574,43600,43603,43731,43741,43766,43810,43814,43834,43872,43925,43926,43932,43938,43941,43942,43954,43962,43963,43986,43988,44003,44037,44056,44109,44114,44157,44174,44237,44265,44274,44290,44305,44308,44314,44317,44318,44319,44338,44360,44372,44396,44400,44405,44407,44423,44516,44521,44526,44550,44554,44555,44560,44571,44588,44591,44592,44604,44612,44618,44656,44658,44665,44669,44670,44684,44691,44720,44742,44777,44778,44792,44794,44807,44844,45034,45045,45047,45054,45078,45133,45149,45152,45156,45157,45221,45247,45263,45270,45272,45273,45277,45280,45288,45290,45293,45362,45378,45401,45453,45455,45456,45463,45476,45478,45481,45509,45530,45545,45591,45594,45633,45634,45638,45644,45645,45649,45680,45686,45694,45703,45711,45712,45714,45719,45728,45761,45762,45766,45779,45904,45905,45906,45907,45908,45909,45910,45943,45949,45971,45978,45982,45998,46005,46010,46011,46078,46079,46080,46081,46102,46120,46126,46182,46183,46199,46200,46228,46239,46249,46281,46287,46299,46300,46313,46321,46324,46401,46403,46405,46426,46532,46534,46535,46544,46548,46549,46550,46551,46552,46557,46596,46601,46630,46674,46701,46770,46789,46796,46805,46806,46810,46811,46832,46837,46848,46862,46914,46915,46946,47003,47008,47011,47028,47029,47043,47044,47069,47072,47099,47107,47117,47142,47155,47166,47232,47269,47271,47304,47342,47357,47422,47425,47430,47446,47447,47472,47476,47483,47489,47552,47553,47567,47590,47629,47704,47725,47744,47752,47768,47817,47843,47844,47846,47889,47898,47911,47914,47918,47921,47931,47939,47952,47991,48007,48020,48056,48120,48135,48150,48152,48154,48155,48165,48176,48182,48183,48186,48187,48229,48236,48243,48258,48263,48271,48278,48339,48380,48381,48386,48398,48400,48402,48439,48441,48442,48471,48485,48490,48507,48509,48511,48522,48531,48622,48650,48653,48662,48675,48717,48719,48731,48802,48807,48897,48901,48930,48954,48964,49006,49011,49020,49045,49067,49108,49112,49113,49118,49120,49137,49139,49140,49153,49167,49168,49171,49199,49200,49226,49227,49231,49235,49237,49240,49247,49269,49273,49298,49365,49379,49382,49397,49402,49454,49455,49459,49461,49463,49464,49471,49472,49486,49487,49496,49500,49503,49527,49528,49543,49562,49584,49597,49608,49628,49629,49645,49665,49669,49700,49716,49771,49816,49828,49831,49834,49835,49849,49853,49864,49894,49923,50107,50111,50115,50122,50125,50137,50197,50198,50199,50200,50201,50202,50203,50204,50205,50206,50312,50375,50411,50429,50493,50498,50557,50558,50597,50615,50627,50636,50681,50727,50728,50747,50748,50750,50787,50788,50816,50820,50822,50823,50835,50838,50846,50866,50898,50971,50981,50983,50996,50997,50998,50999,51000,51003,51004,51007,51131,51132,51160,51162,51182,51190,51205,51217,51239,51266,51435,51457,51513,51514,51517,51518,51529,51543,51574,51704,51742,51798,51804,51821,51828,51837,51838,51840,51869,51883,51884,51886,51890,51899,51906,51910,51930,51941,52023,52038,52069,52095,52096,52097,52098,52135,52136,52137,52151,52152,52153,52154,52159,52160,52164,52281,52291,52292,52326,52356,52417,52443,52460,52512,52533,52555,52556,52591,52596,52621,52635,52637,52663,52676,52684,52685,52689,52693,52694,52697,52706,52707,52712,52752,52768,52798,52913,52950,53078,53087,53210,53317,53319,53329,53330,53331,53380,53381,53382,53383,53401,53423,53450,53481,53496,53506,53555,53556,53569,53572,53574,53599,53607,53611,53612,53623,53626,53642,53643,53691,53823,53874,53894,53928,53931,53977,54004,54011,54018,54021,54063,54117,54118,54141,54194,54203,54231,54263,54287,54296,54324,54361,54374,54384,54386,54387,54445,54457,54528,54536,54547,54737,54769,54784,54795,54880,54881,54883,54899,54911,54922,54927,54978,54989,55017,55018,55028,55032,55037,55043,55191,55209,55227,55287,55293,55317,55318,55357,55411,55452,55523,55549,55580,55582,55634,55683,55709,55737,55741,55745,55776,55782,55784,55794,55803,55876,55889,55947,55966,55983,55988,55995,56006,56131,56198,56199,56202,56207,56228,56229,56314,56355,56357,56403,56455,56510,56569,56758,56821,56832,56833,56865,56902,56903,56909,56915,56932,57094,57116,57131,57133,57154,57175,57198,57253,57273,57412,57420,57466,57562,57564,57565,57570,57576,57579,57601,57625,57644,57650,57685,57703,57785,57801,57811,57818,57854,57855,57869,57871,57919,57928,57946,57970,57977,57980,57984,57985,57986,57992,58003,58004,58008,58014,58015,58022,58037,58038,58039,58040,58051,58073,58074,58132,58163,58220,58223,58238,58240,58266,58290,58291,58339,58345,58404,58408,58409,58430,58433,58434,58445,58461,58478,58546,58639,58642,58643,58646,58648,58649,58651,58670,58719,58741,58745,58749,58782,58837,58859,59012,59156,59159,59161,59176,59192,59203,59220,59258,59264,59282,59309,59324,59325,59327,59365,59428,59432,59492,59533,59609,59615,59719,59721,59726,59793,59794,59795,59872,59880,59954,60015,60094,60113,60118,60145,60170,60192,60194,60195,60265,60318,60362,60366,60369,60370,60445,60493,60539,60540,60541,60543,60661,60715,60718,60723,60761,60767,60809,60810,60863,60953,61093,61163,61361,61366,61375,61409,61447,61448,61489,61523,61575,61624,61749,61804,61827,61839,61846,61935,62008,62028,62036,62037,62100,62122,62138,62156,62167,62241,62242,62285,62322,62323,62324,62357,62360,62363,62365,62374,62375,62378,62380,62382,62383,62386,62387,62394,62420,62422,62465,62474,62542,62563,62625,62627,62628,62629,62632,62633,62638,62641,62646,62647,62648,62649,62660,62672,62698,62795,62849,62854,62913,62922,62971,63000,63058,63059,63088,63099,63143,63146,63148,63153,63183,63192,63205,63210,63212,63257,63263,63276,63326,63349,63390,63416,63515,63516,63570,63660,63661,63662,63664,63665,63792,63807,63905,63978,64009,64049,64132,64144,64148,64164,64166,64179,64192,64219,64247,64392,64446,64543,64552,64553,64580,64608,64614,64616,64623,64624,64625,64628,64648,64650,64652,64653,64661,64680,64718,64757,64758,64834,64851,64895,64914,64989,64996,65002,65056,65069,65101,65139,65254,65291,65308,65389,65393,65406,65527,65528,65670,65821,65850,65886,65896,65974,66003,66004,66007,66067,66073,66074,66109,66116,66133,66186,66251,66266,66270,66296,66330,66404,66419,66425,66428,66430,66436,66458,66578,66581,66637,66711,66738,66792,66899,66900,66929,66932,67032,67204,67266,67269,67278,67326,67341,67378,67457,67484,67494,67504,67590,67630,67631,67673,67723,67755,67758,67813,67815,67906,67920,67922,68004,68078,68117,68129,68371,68393,68462,68486,68518,68558,68559,68560,68562,68612,68653,68769,68843,68853,68891,68947,68948,68955,69000,69009,69035,69052,69069,69081,69090,69123,69125,69136,69142,69168,69175,69231,69281,69300,69314,69325,69347,69350,69407,69426,69502,69510,69512,69514,69609,69616) [ RunTime:0.016231s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (30958,30959,30960,30964,30965,30966,30967,30968,30972,30973,30974,30984,30986,30987,30988,30989,30990,30991,30993,30997,31124,31126,31127,31128,31129,31131,31132,31135,31136,31137,31344,31423,31525,31526,31643,31695,31939,31946,31961,31989,32020,32021,32022,32025,32026,32027,32028,32029,32030,32031,32032,32033,32034,32035,32036,32037,32038,32061,32131,32134,32136,32137,32151,32154,32156,32158,32160,32163,32164,32165,32173,32174,32175,32181,32191,32192,32193,32194,32195,32197,32198,32199,32202,32203,32211,32214,32219,32220,32221,32226,32227,32229,32231,32259,32295,32296,32302,32333,32452,32479,32480,32481,32485,32521,32611,32661,32662,32952,32953,32964,32970,32996,33004,33153,33165,33201,33240,33335,33337,33380,33437,33457,33460,33464,33468,33470,33471,33552,33554,33555,33560,33585,33586,33588,33590,33693,33705,33707,33715,33724,33729,33743,33757,33758,33759,33760,33896,34296,34297,34298,34299,34300,34301,34302,34307,34309,34320,34328,34330,34331,34332,34333,34334,34335,34336,34340,34341,34342,34343,34344,34345,34346,34347,34348,34373,34501,34502,34503,34504,34505,34507,34508,34509,34546,34584,34641,34642,34643,34644,34753,34771,34778,34790,34796,34832,34866,34870,34880,34883,34885,34889,34890,34891,34907,34908,34936,34971,34972,34973,34981,34982,35003,35072,35073,35079,35081,35082,35083,35084,35108,35120,35126,35127,35142,35234,35291,35292,35293,35294,35326,35389,35393,35503,35511,35611,35819,35831,35867,35869,35870,35983,35986,35987,35995,35999,36000,36008,36011,36012,36028,36066,36073,36117,36148,36154,36211,36250,36253,36255,36256,36258,36284,36319,36327,36330,36331,36480,36481,36484,36537,36556,36567,36573,36612,36624,36625,36635,36663,36670,36674,36699,36700,36709,36757,36758,36765,36787,36788,36862,36867,36868,36869,36910,36912,36913,36937,36953,36960,36978,36981,36982,36983,36987,37036,37045,37049,37060,37074,37135,37159,37162,37192,37219,37228,37263,37264,37272,37286,37289,37294,37295,37304,37330,37334,37337,37338,37343,37355,37410,37435,37436,37438,37452,37531,37532,37533,37534,37535,37536,37538,37541,37551,37554,37555,37556,37559,37560,37563,37572,37573,37575,37577,37578,37579,37581,37585,37643,37672,37695,37722,37723,37724,37725,37748,37749,37768,37773,37779,37780,37786,37787,37794,37798,37801,37821,37823,37831,37833,37834,38042,38048,38049,38056,38093,38126,38147,38166,38178,38202,38203,38206,38207,38213,38216,38217,38221,38233,38237,38238,38243,38244,38246,38253,38270,38281,38294,38295,38318,38321,38357,38362,38363,38383,38386,38390,38394,38397,38401,38409,38410,38432,38438,38512,38517,38519,38528,38542,38589,38592,38613,38616,38624,38625,38626,38627,38630,38657,38668,38672,38679,38770,38771,38774,38788,38793,38796,38799,38801,38820,38821,38826,38828,38831,38836,38858,38861,38863,38887,38895,38902,38914,38924,38992,38993,39013,39036,39041,39048,39056,39061,39062,39076,39098,39100,39101,39106,39116,39132,39134,39143,39152,39153,39157,39183,39209,39236,39240,39245,39252,39263,39268,39269,39279,39314,39322,39328,39329,39332,39354,39367,39369,39370,39371,39387,39389,39393,39406,39409,39426,39428,39432,39435,39445,39460,39462,39477,39504,39505,39508,39509,39520,39550,39568,39590,39595,39612,39613,39621,39642,39660,39689,39720,39762,39861,39917,39933,39935,39942,39974,39992,40035,40037,40058,40084,40091,40095,40097,40098,40099,40104,40108,40119,40120,40122,40142,40149,40151,40160,40165,40185,40201,40208,40222,40224,40231,40234,40255,40256,40259,40325,40373,40374,40404,40405,40406,40407,40408,40438,40439,40444,40445,40446,40456,40523,40525,40526,40549,40566,40590,40596,40597,40598,40599,40614,40615,40618,40629,40635,40638,40655,40675,40680,40700,40713,40716,40722,40824,40866,40874,40892,40894,40900,40918,40922,40941,40966,40972,40981,40982,40984,40998,41000,41012,41035,41061,41062,41066,41079,41089,41090,41092,41099,41109,41129,41162,41163,41198,41199,41245,41254,41270,41275,41276,41284,41286,41288,41295,41308,41311,41332,41334,41349,41370,41371,41381,41395,41399,41404,41412,41430,41460,41461,41463,41494,41511,41539,41556,41558,41561,41563,41580,41581,41600,41639,41749,41776,41827,41829,41861,41896,42010,42012,42013,42023,42032,42034,42068,42069,42113,42114,42115,42127,42137,42188,42230,42232,42265,42289,42290,42296,42307,42325,42329,42354,42356,42357,42361,42365,42379,42382,42406,42422,42429,42446,42448,42468,42479,42480,42485,42489,42493,42494,42502,42538,42546,42550,42587,42647,42675,42676,42704,42707,42708,42716,42736,42762,42763,42764,42765,42772,42773,42776,42780,42811,42812,42845,42848,42850,42851,42854,42862,42865,42870,42919,42920,42932,42939,42940,42941,42944,42949,42973,43004,43007,43008,43010,43045,43066,43067,43072,43074,43104,43105,43122,43123,43150,43151,43226,43232,43251,43252,43254,43255,43256,43270,43284,43285,43334,43336,43340,43344,43345,43346,43347,43366,43392,43412,43431,43432,43450,43494,43501,43502,43503,43506,43507,43565,43568,43573,43574,43600,43603,43731,43741,43766,43810,43814,43834,43872,43925,43926,43932,43938,43941,43942,43954,43962,43963,43986,43988,44003,44037,44056,44109,44114,44157,44174,44237,44265,44274,44290,44305,44308,44314,44317,44318,44319,44338,44360,44372,44396,44400,44405,44407,44423,44516,44521,44526,44550,44554,44555,44560,44571,44588,44591,44592,44604,44612,44618,44656,44658,44665,44669,44670,44684,44691,44720,44742,44777,44778,44792,44794,44807,44844,45034,45045,45047,45054,45078,45133,45149,45152,45156,45157,45221,45247,45263,45270,45272,45273,45277,45280,45288,45290,45293,45362,45378,45401,45453,45455,45456,45463,45476,45478,45481,45509,45530,45545,45591,45594,45633,45634,45638,45644,45645,45649,45680,45686,45694,45703,45711,45712,45714,45719,45728,45761,45762,45766,45779,45904,45905,45906,45907,45908,45909,45910,45943,45949,45971,45978,45982,45998,46005,46010,46011,46078,46079,46080,46081,46102,46120,46126,46182,46183,46199,46200,46228,46239,46249,46281,46287,46299,46300,46313,46321,46324,46401,46403,46405,46426,46532,46534,46535,46544,46548,46549,46550,46551,46552,46557,46596,46601,46630,46674,46701,46770,46789,46796,46805,46806,46810,46811,46832,46837,46848,46862,46914,46915,46946,47003,47008,47011,47028,47029,47043,47044,47069,47072,47099,47107,47117,47142,47155,47166,47232,47269,47271,47304,47342,47357,47422,47425,47430,47446,47447,47472,47476,47483,47489,47552,47553,47567,47590,47629,47704,47725,47744,47752,47768,47817,47843,47844,47846,47889,47898,47911,47914,47918,47921,47931,47939,47952,47991,48007,48020,48056,48120,48135,48150,48152,48154,48155,48165,48176,48182,48183,48186,48187,48229,48236,48243,48258,48263,48271,48278,48339,48380,48381,48386,48398,48400,48402,48439,48441,48442,48471,48485,48490,48507,48509,48511,48522,48531,48622,48650,48653,48662,48675,48717,48719,48731,48802,48807,48897,48901,48930,48954,48964,49006,49011,49020,49045,49067,49108,49112,49113,49118,49120,49137,49139,49140,49153,49167,49168,49171,49199,49200,49226,49227,49231,49235,49237,49240,49247,49269,49273,49298,49365,49379,49382,49397,49402,49454,49455,49459,49461,49463,49464,49471,49472,49486,49487,49496,49500,49503,49527,49528,49543,49562,49584,49597,49608,49628,49629,49645,49665,49669,49700,49716,49771,49816,49828,49831,49834,49835,49849,49853,49864,49894,49923,50107,50111,50115,50122,50125,50137,50197,50198,50199,50200,50201,50202,50203,50204,50205,50206,50312,50375,50411,50429,50493,50498,50557,50558,50597,50615,50627,50636,50681,50727,50728,50747,50748,50750,50787,50788,50816,50820,50822,50823,50835,50838,50846,50866,50898,50971,50981,50983,50996,50997,50998,50999,51000,51003,51004,51007,51131,51132,51160,51162,51182,51190,51205,51217,51239,51266,51435,51457,51513,51514,51517,51518,51529,51543,51574,51704,51742,51798,51804,51821,51828,51837,51838,51840,51869,51883,51884,51886,51890,51899,51906,51910,51930,51941,52023,52038,52069,52095,52096,52097,52098,52135,52136,52137,52151,52152,52153,52154,52159,52160,52164,52281,52291,52292,52326,52356,52417,52443,52460,52512,52533,52555,52556,52591,52596,52621,52635,52637,52663,52676,52684,52685,52689,52693,52694,52697,52706,52707,52712,52752,52768,52798,52913,52950,53078,53087,53210,53317,53319,53329,53330,53331,53380,53381,53382,53383,53401,53423,53450,53481,53496,53506,53555,53556,53569,53572,53574,53599,53607,53611,53612,53623,53626,53642,53643,53691,53823,53874,53894,53928,53931,53977,54004,54011,54018,54021,54063,54117,54118,54141,54194,54203,54231,54263,54287,54296,54324,54361,54374,54384,54386,54387,54445,54457,54528,54536,54547,54737,54769,54784,54795,54880,54881,54883,54899,54911,54922,54927,54978,54989,55017,55018,55028,55032,55037,55043,55191,55209,55227,55287,55293,55317,55318,55357,55411,55452,55523,55549,55580,55582,55634,55683,55709,55737,55741,55745,55776,55782,55784,55794,55803,55876,55889,55947,55966,55983,55988,55995,56006,56131,56198,56199,56202,56207,56228,56229,56314,56355,56357,56403,56455,56510,56569,56758,56821,56832,56833,56865,56902,56903,56909,56915,56932,57094,57116,57131,57133,57154,57175,57198,57253,57273,57412,57420,57466,57562,57564,57565,57570,57576,57579,57601,57625,57644,57650,57685,57703,57785,57801,57811,57818,57854,57855,57869,57871,57919,57928,57946,57970,57977,57980,57984,57985,57986,57992,58003,58004,58008,58014,58015,58022,58037,58038,58039,58040,58051,58073,58074,58132,58163,58220,58223,58238,58240,58266,58290,58291,58339,58345,58404,58408,58409,58430,58433,58434,58445,58461,58478,58546,58639,58642,58643,58646,58648,58649,58651,58670,58719,58741,58745,58749,58782,58837,58859,59012,59156,59159,59161,59176,59192,59203,59220,59258,59264,59282,59309,59324,59325,59327,59365,59428,59432,59492,59533,59609,59615,59719,59721,59726,59793,59794,59795,59872,59880,59954,60015,60094,60113,60118,60145,60170,60192,60194,60195,60265,60318,60362,60366,60369,60370,60445,60493,60539,60540,60541,60543,60661,60715,60718,60723,60761,60767,60809,60810,60863,60953,61093,61163,61361,61366,61375,61409,61447,61448,61489,61523,61575,61624,61749,61804,61827,61839,61846,61935,62008,62028,62036,62037,62100,62122,62138,62156,62167,62241,62242,62285,62322,62323,62324,62357,62360,62363,62365,62374,62375,62378,62380,62382,62383,62386,62387,62394,62420,62422,62465,62474,62542,62563,62625,62627,62628,62629,62632,62633,62638,62641,62646,62647,62648,62649,62660,62672,62698,62795,62849,62854,62913,62922,62971,63000,63058,63059,63088,63099,63143,63146,63148,63153,63183,63192,63205,63210,63212,63257,63263,63276,63326,63349,63390,63416,63515,63516,63570,63660,63661,63662,63664,63665,63792,63807,63905,63978,64009,64049,64132,64144,64148,64164,64166,64179,64192,64219,64247,64392,64446,64543,64552,64553,64580,64608,64614,64616,64623,64624,64625,64628,64648,64650,64652,64653,64661,64680,64718,64757,64758,64834,64851,64895,64914,64989,64996,65002,65056,65069,65101,65139,65254,65291,65308,65389,65393,65406,65527,65528,65670,65821,65850,65886,65896,65974,66003,66004,66007,66067,66073,66074,66109,66116,66133,66186,66251,66266,66270,66296,66330,66404,66419,66425,66428,66430,66436,66458,66578,66581,66637,66711,66738,66792,66899,66900,66929,66932,67032,67204,67266,67269,67278,67326,67341,67378,67457,67484,67494,67504,67590,67630,67631,67673,67723,67755,67758,67813,67815,67906,67920,67922,68004,68078,68117,68129,68371,68393,68462,68486,68518,68558,68559,68560,68562,68612,68653,68769,68843,68853,68891,68947,68948,68955,69000,69009,69035,69052,69069,69081,69090,69123,69125,69136,69142,69168,69175,69231,69281,69300,69314,69325,69347,69350,69407,69426,69502,69510,69512,69514,69609,69616) AND `brand_id` > 0 [ RunTime:0.015991s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.000575s ]
SELECT * FROM `tp_brand` WHERE `id` IN (4434,4435,4448,4753,4754,4625,4746,4761,4517,4439,4444,4482,4788,4478,4457,4451,4804,4805,4807,4809,4734,4986,4446,4810,4812,4455,4814,4819,4827,5057,4454,4479,6434,6436,6428,6460,4621,5018,5043,5090,4580,6336,4436,4645,4949,4484,6463,4736,4665,4463,4462,5028,6384,5065,4440,4449,5025,4995,6348,4983,4981,4980,4970,4944,4941,4940,4575,4531,6339,6349,4447,5075,4569,4619,4905,4721,5377,4495,5172,5166,5187,6350,4618,5227,4521,5111,5281,5650,4796,4476,4917,5301,5334,5380,4946,5390,4797,6343,4916,6431,4769,4443,5454,5486,4629,4513,6351,5932,4450,6352,5985,4508,5590,4523,5416,5621,5649,5483,5655,5665,5574,5695,5704,4690,5919,6031,5297,5685,5796,4490,5818,5489,5847,5866,6266,4514,4942,4515,4872,4781,6354,5885,5039,6015,4506,6576,4643,4526,6049,6059,6652,5207,4737,6842,6394,4461,6111,6114,5525,5098,6139,6203,6335,4668,6218,6223,6224,6226,5331,4477,5097,5122,4474,4516,6298,4560,5587,6361,4852,4767,6629,4738,7024,5747,4830,6578,6584,6587,5230,6151,4505,6625,6993,7139,7165,6681,5200,4727,5044,6707,7234,6317,5640,4601,6783,5041,7182,6803,6464,6829,5902,4563,6837,4460,4576,6852,6860,4534,5265,6205,6891,7215,6854,6812,4900,7482,5365,5346,4950,4512,6886,6661,6956,4931,5007,6236,6987,6921,6986,7178,7623,5091,5631,4994,6998,4520,6633,4568,5300,7008,4617,7009,6634,7682,7044,7735,6622,5455,4897,7766,6642,7654,6135,4529,5209,7834,4839,5058,5012,5440,5298,7829,7841,7337,7341,4911,7330,5467,5660,4599,6179,4868,4472,7920,5558,6466,4866,7075,7501,4627,7964,5088,4741,7279,6169,7720,6143,6753,5183,5838,5221,4510,7213,7790,7481,8023,6846,7429,6790,4798,5690,5235,5578,5307,7938,5503,4751,6800,6708,4782,6050,4735,4475,5956,8142) GROUP BY `name` LIMIT 30 [ RunTime:0.000960s ]
SELECT `goods_id`,`goods_name`,`sales_sum`,`virtual_sales_sum`,`shop_price`,`bespeak_template_id`,`label_id` FROM `tp_goods` WHERE `goods_id` IN (30958,30959,30960,30964,30965,30966,30967,30968,30972,30973,30974,30984,30986,30987,30988,30989,30990,30991,30993,30997,31124,31126,31127,31128,31129,31131,31132,31135,31136,31137,31344,31423,31525,31526,31643,31695,31939,31946,31961,31989,32020,32021,32022,32025,32026,32027,32028,32029,32030,32031,32032,32033,32034,32035,32036,32037,32038,32061,32131,32134,32136,32137,32151,32154,32156,32158,32160,32163,32164,32165,32173,32174,32175,32181,32191,32192,32193,32194,32195,32197,32198,32199,32202,32203,32211,32214,32219,32220,32221,32226,32227,32229,32231,32259,32295,32296,32302,32333,32452,32479,32480,32481,32485,32521,32611,32661,32662,32952,32953,32964,32970,32996,33004,33153,33165,33201,33240,33335,33337,33380,33437,33457,33460,33464,33468,33470,33471,33552,33554,33555,33560,33585,33586,33588,33590,33693,33705,33707,33715,33724,33729,33743,33757,33758,33759,33760,33896,34296,34297,34298,34299,34300,34301,34302,34307,34309,34320,34328,34330,34331,34332,34333,34334,34335,34336,34340,34341,34342,34343,34344,34345,34346,34347,34348,34373,34501,34502,34503,34504,34505,34507,34508,34509,34546,34584,34641,34642,34643,34644,34753,34771,34778,34790,34796,34832,34866,34870,34880,34883,34885,34889,34890,34891,34907,34908,34936,34971,34972,34973,34981,34982,35003,35072,35073,35079,35081,35082,35083,35084,35108,35120,35126,35127,35142,35234,35291,35292,35293,35294,35326,35389,35393,35503,35511,35611,35819,35831,35867,35869,35870,35983,35986,35987,35995,35999,36000,36008,36011,36012,36028,36066,36073,36117,36148,36154,36211,36250,36253,36255,36256,36258,36284,36319,36327,36330,36331,36480,36481,36484,36537,36556,36567,36573,36612,36624,36625,36635,36663,36670,36674,36699,36700,36709,36757,36758,36765,36787,36788,36862,36867,36868,36869,36910,36912,36913,36937,36953,36960,36978,36981,36982,36983,36987,37036,37045,37049,37060,37074,37135,37159,37162,37192,37219,37228,37263,37264,37272,37286,37289,37294,37295,37304,37330,37334,37337,37338,37343,37355,37410,37435,37436,37438,37452,37531,37532,37533,37534,37535,37536,37538,37541,37551,37554,37555,37556,37559,37560,37563,37572,37573,37575,37577,37578,37579,37581,37585,37643,37672,37695,37722,37723,37724,37725,37748,37749,37768,37773,37779,37780,37786,37787,37794,37798,37801,37821,37823,37831,37833,37834,38042,38048,38049,38056,38093,38126,38147,38166,38178,38202,38203,38206,38207,38213,38216,38217,38221,38233,38237,38238,38243,38244,38246,38253,38270,38281,38294,38295,38318,38321,38357,38362,38363,38383,38386,38390,38394,38397,38401,38409,38410,38432,38438,38512,38517,38519,38528,38542,38589,38592,38613,38616,38624,38625,38626,38627,38630,38657,38668,38672,38679,38770,38771,38774,38788,38793,38796,38799,38801,38820,38821,38826,38828,38831,38836,38858,38861,38863,38887,38895,38902,38914,38924,38992,38993,39013,39036,39041,39048,39056,39061,39062,39076,39098,39100,39101,39106,39116,39132,39134,39143,39152,39153,39157,39183,39209,39236,39240,39245,39252,39263,39268,39269,39279,39314,39322,39328,39329,39332,39354,39367,39369,39370,39371,39387,39389,39393,39406,39409,39426,39428,39432,39435,39445,39460,39462,39477,39504,39505,39508,39509,39520,39550,39568,39590,39595,39612,39613,39621,39642,39660,39689,39720,39762,39861,39917,39933,39935,39942,39974,39992,40035,40037,40058,40084,40091,40095,40097,40098,40099,40104,40108,40119,40120,40122,40142,40149,40151,40160,40165,40185,40201,40208,40222,40224,40231,40234,40255,40256,40259,40325,40373,40374,40404,40405,40406,40407,40408,40438,40439,40444,40445,40446,40456,40523,40525,40526,40549,40566,40590,40596,40597,40598,40599,40614,40615,40618,40629,40635,40638,40655,40675,40680,40700,40713,40716,40722,40824,40866,40874,40892,40894,40900,40918,40922,40941,40966,40972,40981,40982,40984,40998,41000,41012,41035,41061,41062,41066,41079,41089,41090,41092,41099,41109,41129,41162,41163,41198,41199,41245,41254,41270,41275,41276,41284,41286,41288,41295,41308,41311,41332,41334,41349,41370,41371,41381,41395,41399,41404,41412,41430,41460,41461,41463,41494,41511,41539,41556,41558,41561,41563,41580,41581,41600,41639,41749,41776,41827,41829,41861,41896,42010,42012,42013,42023,42032,42034,42068,42069,42113,42114,42115,42127,42137,42188,42230,42232,42265,42289,42290,42296,42307,42325,42329,42354,42356,42357,42361,42365,42379,42382,42406,42422,42429,42446,42448,42468,42479,42480,42485,42489,42493,42494,42502,42538,42546,42550,42587,42647,42675,42676,42704,42707,42708,42716,42736,42762,42763,42764,42765,42772,42773,42776,42780,42811,42812,42845,42848,42850,42851,42854,42862,42865,42870,42919,42920,42932,42939,42940,42941,42944,42949,42973,43004,43007,43008,43010,43045,43066,43067,43072,43074,43104,43105,43122,43123,43150,43151,43226,43232,43251,43252,43254,43255,43256,43270,43284,43285,43334,43336,43340,43344,43345,43346,43347,43366,43392,43412,43431,43432,43450,43494,43501,43502,43503,43506,43507,43565,43568,43573,43574,43600,43603,43731,43741,43766,43810,43814,43834,43872,43925,43926,43932,43938,43941,43942,43954,43962,43963,43986,43988,44003,44037,44056,44109,44114,44157,44174,44237,44265,44274,44290,44305,44308,44314,44317,44318,44319,44338,44360,44372,44396,44400,44405,44407,44423,44516,44521,44526,44550,44554,44555,44560,44571,44588,44591,44592,44604,44612,44618,44656,44658,44665,44669,44670,44684,44691,44720,44742,44777,44778,44792,44794,44807,44844,45034,45045,45047,45054,45078,45133,45149,45152,45156,45157,45221,45247,45263,45270,45272,45273,45277,45280,45288,45290,45293,45362,45378,45401,45453,45455,45456,45463,45476,45478,45481,45509,45530,45545,45591,45594,45633,45634,45638,45644,45645,45649,45680,45686,45694,45703,45711,45712,45714,45719,45728,45761,45762,45766,45779,45904,45905,45906,45907,45908,45909,45910,45943,45949,45971,45978,45982,45998,46005,46010,46011,46078,46079,46080,46081,46102,46120,46126,46182,46183,46199,46200,46228,46239,46249,46281,46287,46299,46300,46313,46321,46324,46401,46403,46405,46426,46532,46534,46535,46544,46548,46549,46550,46551,46552,46557,46596,46601,46630,46674,46701,46770,46789,46796,46805,46806,46810,46811,46832,46837,46848,46862,46914,46915,46946,47003,47008,47011,47028,47029,47043,47044,47069,47072,47099,47107,47117,47142,47155,47166,47232,47269,47271,47304,47342,47357,47422,47425,47430,47446,47447,47472,47476,47483,47489,47552,47553,47567,47590,47629,47704,47725,47744,47752,47768,47817,47843,47844,47846,47889,47898,47911,47914,47918,47921,47931,47939,47952,47991,48007,48020,48056,48120,48135,48150,48152,48154,48155,48165,48176,48182,48183,48186,48187,48229,48236,48243,48258,48263,48271,48278,48339,48380,48381,48386,48398,48400,48402,48439,48441,48442,48471,48485,48490,48507,48509,48511,48522,48531,48622,48650,48653,48662,48675,48717,48719,48731,48802,48807,48897,48901,48930,48954,48964,49006,49011,49020,49045,49067,49108,49112,49113,49118,49120,49137,49139,49140,49153,49167,49168,49171,49199,49200,49226,49227,49231,49235,49237,49240,49247,49269,49273,49298,49365,49379,49382,49397,49402,49454,49455,49459,49461,49463,49464,49471,49472,49486,49487,49496,49500,49503,49527,49528,49543,49562,49584,49597,49608,49628,49629,49645,49665,49669,49700,49716,49771,49816,49828,49831,49834,49835,49849,49853,49864,49894,49923,50107,50111,50115,50122,50125,50137,50197,50198,50199,50200,50201,50202,50203,50204,50205,50206,50312,50375,50411,50429,50493,50498,50557,50558,50597,50615,50627,50636,50681,50727,50728,50747,50748,50750,50787,50788,50816,50820,50822,50823,50835,50838,50846,50866,50898,50971,50981,50983,50996,50997,50998,50999,51000,51003,51004,51007,51131,51132,51160,51162,51182,51190,51205,51217,51239,51266,51435,51457,51513,51514,51517,51518,51529,51543,51574,51704,51742,51798,51804,51821,51828,51837,51838,51840,51869,51883,51884,51886,51890,51899,51906,51910,51930,51941,52023,52038,52069,52095,52096,52097,52098,52135,52136,52137,52151,52152,52153,52154,52159,52160,52164,52281,52291,52292,52326,52356,52417,52443,52460,52512,52533,52555,52556,52591,52596,52621,52635,52637,52663,52676,52684,52685,52689,52693,52694,52697,52706,52707,52712,52752,52768,52798,52913,52950,53078,53087,53210,53317,53319,53329,53330,53331,53380,53381,53382,53383,53401,53423,53450,53481,53496,53506,53555,53556,53569,53572,53574,53599,53607,53611,53612,53623,53626,53642,53643,53691,53823,53874,53894,53928,53931,53977,54004,54011,54018,54021,54063,54117,54118,54141,54194,54203,54231,54263,54287,54296,54324,54361,54374,54384,54386,54387,54445,54457,54528,54536,54547,54737,54769,54784,54795,54880,54881,54883,54899,54911,54922,54927,54978,54989,55017,55018,55028,55032,55037,55043,55191,55209,55227,55287,55293,55317,55318,55357,55411,55452,55523,55549,55580,55582,55634,55683,55709,55737,55741,55745,55776,55782,55784,55794,55803,55876,55889,55947,55966,55983,55988,55995,56006,56131,56198,56199,56202,56207,56228,56229,56314,56355,56357,56403,56455,56510,56569,56758,56821,56832,56833,56865,56902,56903,56909,56915,56932,57094,57116,57131,57133,57154,57175,57198,57253,57273,57412,57420,57466,57562,57564,57565,57570,57576,57579,57601,57625,57644,57650,57685,57703,57785,57801,57811,57818,57854,57855,57869,57871,57919,57928,57946,57970,57977,57980,57984,57985,57986,57992,58003,58004,58008,58014,58015,58022,58037,58038,58039,58040,58051,58073,58074,58132,58163,58220,58223,58238,58240,58266,58290,58291,58339,58345,58404,58408,58409,58430,58433,58434,58445,58461,58478,58546,58639,58642,58643,58646,58648,58649,58651,58670,58719,58741,58745,58749,58782,58837,58859,59012,59156,59159,59161,59176,59192,59203,59220,59258,59264,59282,59309,59324,59325,59327,59365,59428,59432,59492,59533,59609,59615,59719,59721,59726,59793,59794,59795,59872,59880,59954,60015,60094,60113,60118,60145,60170,60192,60194,60195,60265,60318,60362,60366,60369,60370,60445,60493,60539,60540,60541,60543,60661,60715,60718,60723,60761,60767,60809,60810,60863,60953,61093,61163,61361,61366,61375,61409,61447,61448,61489,61523,61575,61624,61749,61804,61827,61839,61846,61935,62008,62028,62036,62037,62100,62122,62138,62156,62167,62241,62242,62285,62322,62323,62324,62357,62360,62363,62365,62374,62375,62378,62380,62382,62383,62386,62387,62394,62420,62422,62465,62474,62542,62563,62625,62627,62628,62629,62632,62633,62638,62641,62646,62647,62648,62649,62660,62672,62698,62795,62849,62854,62913,62922,62971,63000,63058,63059,63088,63099,63143,63146,63148,63153,63183,63192,63205,63210,63212,63257,63263,63276,63326,63349,63390,63416,63515,63516,63570,63660,63661,63662,63664,63665,63792,63807,63905,63978,64009,64049,64132,64144,64148,64164,64166,64179,64192,64219,64247,64392,64446,64543,64552,64553,64580,64608,64614,64616,64623,64624,64625,64628,64648,64650,64652,64653,64661,64680,64718,64757,64758,64834,64851,64895,64914,64989,64996,65002,65056,65069,65101,65139,65254,65291,65308,65389,65393,65406,65527,65528,65670,65821,65850,65886,65896,65974,66003,66004,66007,66067,66073,66074,66109,66116,66133,66186,66251,66266,66270,66296,66330,66404,66419,66425,66428,66430,66436,66458,66578,66581,66637,66711,66738,66792,66899,66900,66929,66932,67032,67204,67266,67269,67278,67326,67341,67378,67457,67484,67494,67504,67590,67630,67631,67673,67723,67755,67758,67813,67815,67906,67920,67922,68004,68078,68117,68129,68371,68393,68462,68486,68518,68558,68559,68560,68562,68612,68653,68769,68843,68853,68891,68947,68948,68955,69000,69009,69035,69052,69069,69081,69090,69123,69125,69136,69142,69168,69175,69231,69281,69300,69314,69325,69347,69350,69407,69426,69502,69510,69512,69514,69609,69616) ORDER BY `sort` DESC LIMIT 0,12 [ RunTime:0.012804s ]
SHOW FULL COLUMNS FROM `tp_goods_label` [ RunTime:0.000548s ]
SELECT `label_id`,`label_name` FROM `tp_goods_label` [ RunTime:0.000126s ]
SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000354s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.000262s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 69616 LIMIT 1 [ RunTime:0.000208s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 69609 LIMIT 1 [ RunTime:0.000150s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 69514 LIMIT 1 [ RunTime:0.000161s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 69512 LIMIT 1 [ RunTime:0.000499s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 69510 LIMIT 1 [ RunTime:0.000217s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 69502 LIMIT 1 [ RunTime:0.000503s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 69426 LIMIT 1 [ RunTime:0.000265s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 69407 LIMIT 1 [ RunTime:0.000155s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 69350 LIMIT 1 [ RunTime:0.000145s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 69347 LIMIT 1 [ RunTime:0.000143s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 69325 LIMIT 1 [ RunTime:0.000140s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 69314 LIMIT 1 [ RunTime:0.000161s ]
