SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.001119s ]
SELECT `goods_id` FROM `tp_goods` WHERE `is_on_sale` = 1 AND `goods_name` LIKE '%打印机%' [ RunTime:0.049622s ]
SELECT `zs_price` FROM `tp_goods` WHERE `goods_id` IN (31662,31667,31671,31673,31676,31678,31714,31715,31725,31992,32001,32004,32005,32006,32015,32201,32935,32956,32961,32972,32982,32985,33010,33012,33023,33024,33034,33039,33040,33043,33047,33048,33056,33079,33082,33111,33114,33115,33123,33125,33131,33149,33151,34059,34063,34064,34065,34067,34068,34071,34072,34074,34573,34638,34639,34679,34680,34725,34840,34844,34845,34846,34863,34864,34865,34867,34868,34873,34874,34877,34881,34916,34917,34918,34919,34920,34921,34934,34938,34939,34940,34941,34942,34943,34944,34945,34946,34947,34948,34949,34950,34951,34952,34953,34954,34955,35071,35085,35086,35087,35088,35089,35090,35091,35093,35111,35113,35114,35233,35275,35837,35839,35844,35845,35846,35859,35862,35863,35878,35880,35884,35887,35888,35891,35894,35895,35898,35901,35902,35907,35908,35910,36039,36068,36069,36116,36119,36210,36222,36261,36262,36264,36267,36268,36269,36270,36273,36274,36276,36279,36280,36282,36320,36357,36375,36379,36389,36390,36391,36395,36396,36397,36398,36400,36402,36403,36407,36418,36419,36420,36421,36422,36423,36425,36426,36428,36451,36452,36453,36454,36455,36456,36459,36468,36469,36485,36486,36487,36491,36498,36499,36500,36501,36516,36557,36571,36629,36630,36634,36681,36796,36806,36853,36854,36855,36859,36866,36870,36871,36911,37038,37039,37040,37041,37042,37043,37044,37072,37079,37080,37082,37092,37097,37161,37183,37212,37213,37240,37285,37337,37455,37457,37460,37484,37488,37600,37605,37672,37685,37708,37712,37714,37735,37741,37742,37743,37774,37778,37785,37819,37820,37830,38044,38063,38067,38095,38118,38119,38120,38121,38189,38209,38211,38231,38234,38245,38249,38260,38261,38262,38264,38266,38267,38268,38269,38273,38279,38288,38297,38301,38302,38303,38304,38305,38306,38313,38314,38316,38323,38335,38377,38391,38462,38513,38515,38516,38523,38572,38612,38635,38649,38651,38654,38726,38790,38800,38806,38810,38812,38822,38839,38844,38850,38923,38941,38943,38954,38969,38984,38986,38987,38988,38995,39057,39059,39065,39080,39107,39127,39149,39159,39161,39238,39368,39388,39398,39399,39427,39439,39485,39489,39560,39562,39563,39638,39639,39640,39641,39701,39702,39713,39736,39742,39855,39937,39939,39961,39986,40114,40148,40155,40156,40171,40173,40176,40180,40195,40223,40309,40310,40311,40312,40317,40318,40319,40355,40392,40394,40427,40428,40436,40441,40461,40499,40505,40506,40509,40510,40511,40512,40513,40539,40545,40559,40585,40586,40587,40589,40595,40596,40606,40610,40611,40637,40668,40671,40679,40698,40712,40714,40730,40731,40743,40744,40747,40752,40753,40754,40756,40758,40763,40769,40771,40772,40773,40774,40775,40777,40778,40779,40780,40781,40782,40783,40784,40804,40805,40806,40855,40856,40859,40861,40865,40869,40884,40914,40915,40919,41087,41088,41095,41098,41107,41151,41218,41220,41221,41232,41258,41297,41309,41313,41322,41333,41372,41380,41385,41402,41423,41436,41437,41477,41479,41515,41546,41829,41891,41964,41981,42015,42035,42081,42114,42187,42199,42255,42266,42287,42308,42345,42346,42347,42362,42367,42368,42410,42412,42430,42490,42491,42497,42597,42616,42621,42632,42638,42641,42671,42740,42782,42799,42825,42831,42833,42842,42843,42844,42848,42854,42857,42858,42859,42860,42861,42867,42868,42869,42873,42884,42893,42899,42905,42965,43000,43006,43073,43091,43092,43132,43137,43188,43258,43259,43260,43286,43288,43290,43320,43381,43396,43430,43431,43504,43527,43656,43735,43736,43755,43936,43940,43984,44051,44052,44104,44153,44154,44160,44196,44227,44228,44230,44231,44232,44233,44267,44272,44275,44287,44302,44313,44328,44346,44361,44370,44394,44397,44402,44404,44510,44511,44512,44513,44553,44562,44589,44594,44596,44598,44599,44617,44655,44659,44676,44677,44719,44771,44793,44806,44809,44840,44842,44843,44962,45009,45010,45011,45012,45075,45094,45225,45226,45261,45280,45281,45332,45337,45371,45497,45534,45583,45588,45590,45635,45636,45637,45646,45647,45652,45658,45659,45661,45662,45665,45667,45669,45672,45677,45678,45685,45687,45689,45695,45697,45698,45705,45706,45707,45708,45753,45760,45771,45776,45781,45919,45966,45967,45968,45983,45994,45997,46031,46034,46035,46065,46103,46240,46296,46297,46307,46331,46370,46375,46389,46525,46526,46607,46623,46671,46683,46698,46703,46745,46763,46775,46780,46785,46789,46807,46817,46818,46821,46822,46823,46826,46838,46983,46985,46994,46995,46996,46997,47047,47056,47057,47058,47059,47062,47104,47143,47172,47173,47174,47175,47192,47193,47202,47246,47247,47249,47255,47264,47265,47266,47267,47269,47283,47287,47290,47291,47292,47293,47298,47299,47306,47307,47308,47316,47335,47427,47510,47573,47575,47677,47715,47799,47842,47845,47852,47901,47905,47912,47917,47920,47930,47936,47940,47942,47946,47962,48000,48001,48157,48159,48160,48162,48170,48228,48358,48405,48428,48434,48438,48439,48440,48441,48470,48513,48594,48651,48665,48673,48681,48692,48693,48694,48695,48710,48728,48730,48731,48751,48803,48837,48838,48839,48860,48894,48895,48943,49027,49030,49031,49034,49087,49117,49127,49128,49142,49146,49147,49148,49150,49151,49176,49188,49190,49191,49301,49338,49339,49340,49353,49385,49386,49387,49388,49389,49390,49492,49493,49494,49495,49496,49497,49504,49507,49508,49509,49510,49527,49528,49529,49530,49531,49532,49536,49540,49541,49544,49545,49580,49581,49632,49641,49642,49643,49644,49683,49701,49702,49748,49793,49794,49839,49865,49922,49927,49951,50054,50144,50145,50146,50207,50208,50209,50211,50212,50213,50214,50215,50216,50217,50366,50374,50389,50475,50496,50501,50507,50596,50602,50733,50766,50769,50770,50773,50777,50813,50818,50847,50871,50872,50893,50894,50895,50896,50897,50903,50916,50927,51034,51037,51061,51066,51106,51176,51177,51184,51189,51192,51221,51226,51227,51248,51249,51250,51251,51252,51253,51278,51280,51297,51304,51359,51361,51416,51417,51419,51483,51545,51547,51548,51549,51550,51627,51630,51637,51702,51705,51712,51713,51714,51715,51725,51736,51745,51747,51748,51749,51750,51751,51827,51834,51841,51844,51869,51871,51914,51916,51926,52040,52041,52048,52049,52063,52107,52140,52141,52142,52149,52161,52168,52170,52172,52173,52175,52224,52225,52234,52236,52249,52250,52251,52252,52253,52262,52269,52276,52286,52307,52402,52483,52523,52542,52553,52715,52770,52771,52772,52773,52792,52815,52946,53038,53046,53062,53072,53073,53078,53081,53082,53083,53090,53091,53135,53136,53202,53203,53267,53272,53290,53320,53322,53324,53326,53355,53404,53405,53408,53601,53615,53622,53640,53751,53764,53781,53826,53869,53886,53888,53895,53923,53924,53925,53926,53962,53963,53971,53972,53973,53974,53975,53979,53988,54002,54010,54012,54027,54064,54221,54250,54258,54270,54271,54272,54306,54307,54308,54309,54310,54318,54411,54414,54461,54462,54468,54470,54477,54547,54564,54566,54568,54602,54604,54606,54687,54688,54689,54719,54764,54776,54778,54797,54808,54818,54834,54845,54886,54888,54892,54894,54902,54920,54924,54928,54929,54930,54931,54932,54933,54937,54954,55009,55029,55033,55034,55035,55045,55138,55142,55143,55146,55161,55409,55412,55534,55535,55536,55623,55624,55633,55689,55707,55719,55721,55730,55807,55816,55857,55882,55892,55894,55897,56012,56013,56029,56039,56044,56053,56079,56085,56088,56109,56129,56171,56172,56173,56179,56180,56194,56210,56224,56237,56267,56295,56296,56297,56356,56388,56396,56482,56542,56571,56572,56580,56624,56686,56687,56688,56689,56708,56718,56719,56720,56729,56743,56750,56756,56824,56825,56827,56960,57046,57048,57073,57124,57125,57127,57128,57140,57141,57142,57143,57150,57155,57157,57161,57175,57176,57177,57178,57179,57198,57206,57211,57212,57213,57214,57268,57289,57290,57421,57461,57467,57495,57499,57518,57577,57588,57590,57593,57609,57619,57632,57634,57635,57642,57695,57723,57780,57794,57795,57809,57810,57822,57824,57843,57845,57895,57960,57961,57987,57991,58017,58018,58041,58044,58137,58167,58168,58240,58330,58385,58458,58459,58460,58594,58827,58831,58832,58897,58898,58903,58941,58964,59048,59187,59221,59246,59250,59251,59256,59277,59362,59370,59411,59417,59425,59447,59449,59450,59458,59459,59484,59495,59503,59664,59685,59699,59700,59711,59712,59745,59790,59875,59877,59881,59882,59899,59900,59902,59903,59970,59976,60012,60083,60084,60086,60154,60187,60188,60189,60197,60199,60203,60205,60206,60207,60258,60263,60289,60307,60314,60364,60396,60433,60522,60523,60632,60657,60713,60732,60763,60786,60812,60813,60881,61070,61078,61081,61099,61132,61155,61156,61157,61158,61320,61321,61326,61360,61369,61393,61435,61464,61465,61518,61537,61538,61539,61611,61754,61840,61858,61911,61998,62007,62068,62153,62161,62172,62173,62174,62176,62236,62238,62282,62284,62302,62304,62346,62350,62355,62356,62374,62388,62389,62423,62463,62498,62615,62621,62632,62633,62640,62647,62880,62916,62917,62918,62920,63057,63072,63073,63074,63079,63088,63103,63136,63174,63217,63218,63219,63307,63350,63653,63919,63938,64020,64022,64043,64046,64049,64143,64159,64160,64161,64162,64179,64250,64258,64316,64361,64362,64443,64466,64467,64561,64607,64612,64634,64691,64693,64695,64696,64703,64810,64855,64856,64865,65078,65168,65267,65286,65317,65318,65335,65351,65372,65428,65429,65470,65484,65505,65561,65597,65599,65600,65601,65847,65866,65896,65898,65926,65932,66021,66126,66132,66252,66267,66293,66326,66418,66543,66544,66545,66550,66553,66565,66613,66639,66685,66697,66698,66746,66752,66767,66907,66914,66930,66943,66948,66984,66985,67237,67244,67247,67271,67288,67334,67336,67443,67477,67499,67556,67734,67735,67790,67876,67887,67932,67934,67935,67962,67989,68008,68009,68010,68029,68030,68033,68037,68038,68039,68043,68045,68104,68166,68221,68266,68300,68301,68345,68381,68526,68542,68616,68728,68895,68914,68915,68928,68929,68930,68974,69033,69065,69116,69272,69273,69275,69276,69277,69282,69283,69313,69360,69374,69375,69446,69501,69509) [ RunTime:0.021497s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (31662,31667,31671,31673,31676,31678,31714,31715,31725,31992,32001,32004,32005,32006,32015,32201,32935,32956,32961,32972,32982,32985,33010,33012,33023,33024,33034,33039,33040,33043,33047,33048,33056,33079,33082,33111,33114,33115,33123,33125,33131,33149,33151,34059,34063,34064,34065,34067,34068,34071,34072,34074,34573,34638,34639,34679,34680,34725,34840,34844,34845,34846,34863,34864,34865,34867,34868,34873,34874,34877,34881,34916,34917,34918,34919,34920,34921,34934,34938,34939,34940,34941,34942,34943,34944,34945,34946,34947,34948,34949,34950,34951,34952,34953,34954,34955,35071,35085,35086,35087,35088,35089,35090,35091,35093,35111,35113,35114,35233,35275,35837,35839,35844,35845,35846,35859,35862,35863,35878,35880,35884,35887,35888,35891,35894,35895,35898,35901,35902,35907,35908,35910,36039,36068,36069,36116,36119,36210,36222,36261,36262,36264,36267,36268,36269,36270,36273,36274,36276,36279,36280,36282,36320,36357,36375,36379,36389,36390,36391,36395,36396,36397,36398,36400,36402,36403,36407,36418,36419,36420,36421,36422,36423,36425,36426,36428,36451,36452,36453,36454,36455,36456,36459,36468,36469,36485,36486,36487,36491,36498,36499,36500,36501,36516,36557,36571,36629,36630,36634,36681,36796,36806,36853,36854,36855,36859,36866,36870,36871,36911,37038,37039,37040,37041,37042,37043,37044,37072,37079,37080,37082,37092,37097,37161,37183,37212,37213,37240,37285,37337,37455,37457,37460,37484,37488,37600,37605,37672,37685,37708,37712,37714,37735,37741,37742,37743,37774,37778,37785,37819,37820,37830,38044,38063,38067,38095,38118,38119,38120,38121,38189,38209,38211,38231,38234,38245,38249,38260,38261,38262,38264,38266,38267,38268,38269,38273,38279,38288,38297,38301,38302,38303,38304,38305,38306,38313,38314,38316,38323,38335,38377,38391,38462,38513,38515,38516,38523,38572,38612,38635,38649,38651,38654,38726,38790,38800,38806,38810,38812,38822,38839,38844,38850,38923,38941,38943,38954,38969,38984,38986,38987,38988,38995,39057,39059,39065,39080,39107,39127,39149,39159,39161,39238,39368,39388,39398,39399,39427,39439,39485,39489,39560,39562,39563,39638,39639,39640,39641,39701,39702,39713,39736,39742,39855,39937,39939,39961,39986,40114,40148,40155,40156,40171,40173,40176,40180,40195,40223,40309,40310,40311,40312,40317,40318,40319,40355,40392,40394,40427,40428,40436,40441,40461,40499,40505,40506,40509,40510,40511,40512,40513,40539,40545,40559,40585,40586,40587,40589,40595,40596,40606,40610,40611,40637,40668,40671,40679,40698,40712,40714,40730,40731,40743,40744,40747,40752,40753,40754,40756,40758,40763,40769,40771,40772,40773,40774,40775,40777,40778,40779,40780,40781,40782,40783,40784,40804,40805,40806,40855,40856,40859,40861,40865,40869,40884,40914,40915,40919,41087,41088,41095,41098,41107,41151,41218,41220,41221,41232,41258,41297,41309,41313,41322,41333,41372,41380,41385,41402,41423,41436,41437,41477,41479,41515,41546,41829,41891,41964,41981,42015,42035,42081,42114,42187,42199,42255,42266,42287,42308,42345,42346,42347,42362,42367,42368,42410,42412,42430,42490,42491,42497,42597,42616,42621,42632,42638,42641,42671,42740,42782,42799,42825,42831,42833,42842,42843,42844,42848,42854,42857,42858,42859,42860,42861,42867,42868,42869,42873,42884,42893,42899,42905,42965,43000,43006,43073,43091,43092,43132,43137,43188,43258,43259,43260,43286,43288,43290,43320,43381,43396,43430,43431,43504,43527,43656,43735,43736,43755,43936,43940,43984,44051,44052,44104,44153,44154,44160,44196,44227,44228,44230,44231,44232,44233,44267,44272,44275,44287,44302,44313,44328,44346,44361,44370,44394,44397,44402,44404,44510,44511,44512,44513,44553,44562,44589,44594,44596,44598,44599,44617,44655,44659,44676,44677,44719,44771,44793,44806,44809,44840,44842,44843,44962,45009,45010,45011,45012,45075,45094,45225,45226,45261,45280,45281,45332,45337,45371,45497,45534,45583,45588,45590,45635,45636,45637,45646,45647,45652,45658,45659,45661,45662,45665,45667,45669,45672,45677,45678,45685,45687,45689,45695,45697,45698,45705,45706,45707,45708,45753,45760,45771,45776,45781,45919,45966,45967,45968,45983,45994,45997,46031,46034,46035,46065,46103,46240,46296,46297,46307,46331,46370,46375,46389,46525,46526,46607,46623,46671,46683,46698,46703,46745,46763,46775,46780,46785,46789,46807,46817,46818,46821,46822,46823,46826,46838,46983,46985,46994,46995,46996,46997,47047,47056,47057,47058,47059,47062,47104,47143,47172,47173,47174,47175,47192,47193,47202,47246,47247,47249,47255,47264,47265,47266,47267,47269,47283,47287,47290,47291,47292,47293,47298,47299,47306,47307,47308,47316,47335,47427,47510,47573,47575,47677,47715,47799,47842,47845,47852,47901,47905,47912,47917,47920,47930,47936,47940,47942,47946,47962,48000,48001,48157,48159,48160,48162,48170,48228,48358,48405,48428,48434,48438,48439,48440,48441,48470,48513,48594,48651,48665,48673,48681,48692,48693,48694,48695,48710,48728,48730,48731,48751,48803,48837,48838,48839,48860,48894,48895,48943,49027,49030,49031,49034,49087,49117,49127,49128,49142,49146,49147,49148,49150,49151,49176,49188,49190,49191,49301,49338,49339,49340,49353,49385,49386,49387,49388,49389,49390,49492,49493,49494,49495,49496,49497,49504,49507,49508,49509,49510,49527,49528,49529,49530,49531,49532,49536,49540,49541,49544,49545,49580,49581,49632,49641,49642,49643,49644,49683,49701,49702,49748,49793,49794,49839,49865,49922,49927,49951,50054,50144,50145,50146,50207,50208,50209,50211,50212,50213,50214,50215,50216,50217,50366,50374,50389,50475,50496,50501,50507,50596,50602,50733,50766,50769,50770,50773,50777,50813,50818,50847,50871,50872,50893,50894,50895,50896,50897,50903,50916,50927,51034,51037,51061,51066,51106,51176,51177,51184,51189,51192,51221,51226,51227,51248,51249,51250,51251,51252,51253,51278,51280,51297,51304,51359,51361,51416,51417,51419,51483,51545,51547,51548,51549,51550,51627,51630,51637,51702,51705,51712,51713,51714,51715,51725,51736,51745,51747,51748,51749,51750,51751,51827,51834,51841,51844,51869,51871,51914,51916,51926,52040,52041,52048,52049,52063,52107,52140,52141,52142,52149,52161,52168,52170,52172,52173,52175,52224,52225,52234,52236,52249,52250,52251,52252,52253,52262,52269,52276,52286,52307,52402,52483,52523,52542,52553,52715,52770,52771,52772,52773,52792,52815,52946,53038,53046,53062,53072,53073,53078,53081,53082,53083,53090,53091,53135,53136,53202,53203,53267,53272,53290,53320,53322,53324,53326,53355,53404,53405,53408,53601,53615,53622,53640,53751,53764,53781,53826,53869,53886,53888,53895,53923,53924,53925,53926,53962,53963,53971,53972,53973,53974,53975,53979,53988,54002,54010,54012,54027,54064,54221,54250,54258,54270,54271,54272,54306,54307,54308,54309,54310,54318,54411,54414,54461,54462,54468,54470,54477,54547,54564,54566,54568,54602,54604,54606,54687,54688,54689,54719,54764,54776,54778,54797,54808,54818,54834,54845,54886,54888,54892,54894,54902,54920,54924,54928,54929,54930,54931,54932,54933,54937,54954,55009,55029,55033,55034,55035,55045,55138,55142,55143,55146,55161,55409,55412,55534,55535,55536,55623,55624,55633,55689,55707,55719,55721,55730,55807,55816,55857,55882,55892,55894,55897,56012,56013,56029,56039,56044,56053,56079,56085,56088,56109,56129,56171,56172,56173,56179,56180,56194,56210,56224,56237,56267,56295,56296,56297,56356,56388,56396,56482,56542,56571,56572,56580,56624,56686,56687,56688,56689,56708,56718,56719,56720,56729,56743,56750,56756,56824,56825,56827,56960,57046,57048,57073,57124,57125,57127,57128,57140,57141,57142,57143,57150,57155,57157,57161,57175,57176,57177,57178,57179,57198,57206,57211,57212,57213,57214,57268,57289,57290,57421,57461,57467,57495,57499,57518,57577,57588,57590,57593,57609,57619,57632,57634,57635,57642,57695,57723,57780,57794,57795,57809,57810,57822,57824,57843,57845,57895,57960,57961,57987,57991,58017,58018,58041,58044,58137,58167,58168,58240,58330,58385,58458,58459,58460,58594,58827,58831,58832,58897,58898,58903,58941,58964,59048,59187,59221,59246,59250,59251,59256,59277,59362,59370,59411,59417,59425,59447,59449,59450,59458,59459,59484,59495,59503,59664,59685,59699,59700,59711,59712,59745,59790,59875,59877,59881,59882,59899,59900,59902,59903,59970,59976,60012,60083,60084,60086,60154,60187,60188,60189,60197,60199,60203,60205,60206,60207,60258,60263,60289,60307,60314,60364,60396,60433,60522,60523,60632,60657,60713,60732,60763,60786,60812,60813,60881,61070,61078,61081,61099,61132,61155,61156,61157,61158,61320,61321,61326,61360,61369,61393,61435,61464,61465,61518,61537,61538,61539,61611,61754,61840,61858,61911,61998,62007,62068,62153,62161,62172,62173,62174,62176,62236,62238,62282,62284,62302,62304,62346,62350,62355,62356,62374,62388,62389,62423,62463,62498,62615,62621,62632,62633,62640,62647,62880,62916,62917,62918,62920,63057,63072,63073,63074,63079,63088,63103,63136,63174,63217,63218,63219,63307,63350,63653,63919,63938,64020,64022,64043,64046,64049,64143,64159,64160,64161,64162,64179,64250,64258,64316,64361,64362,64443,64466,64467,64561,64607,64612,64634,64691,64693,64695,64696,64703,64810,64855,64856,64865,65078,65168,65267,65286,65317,65318,65335,65351,65372,65428,65429,65470,65484,65505,65561,65597,65599,65600,65601,65847,65866,65896,65898,65926,65932,66021,66126,66132,66252,66267,66293,66326,66418,66543,66544,66545,66550,66553,66565,66613,66639,66685,66697,66698,66746,66752,66767,66907,66914,66930,66943,66948,66984,66985,67237,67244,67247,67271,67288,67334,67336,67443,67477,67499,67556,67734,67735,67790,67876,67887,67932,67934,67935,67962,67989,68008,68009,68010,68029,68030,68033,68037,68038,68039,68043,68045,68104,68166,68221,68266,68300,68301,68345,68381,68526,68542,68616,68728,68895,68914,68915,68928,68929,68930,68974,69033,69065,69116,69272,69273,69275,69276,69277,69282,69283,69313,69360,69374,69375,69446,69501,69509) AND `brand_id` > 0 [ RunTime:0.023866s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.000942s ]
SELECT * FROM `tp_brand` WHERE `id` IN (4548,4765,4447,4986,5003,6435,6428,6437,6434,4591,4606,4560,5012,4445,4618,6369,6377,5349,5106,5069,4614,4619,4555,6371,6372,4564,4557,4455,4929,4912,5228,4554,4604,4483,5472,4553,5533,4454,4721,4545,4910,5585,5275,5279,5293,4559,4728,5311,5136,4438,4435,5168,6515,5646,4550,5659,4948,5148,4561,4462,5290,5700,6401,6400,6321,4437,5817,4814,5898,5912,6399,5981,4558,5946,6011,4804,4556,6266,6058,6394,6062,6080,6367,6403,6397,6191,6193,4439,4997,5044,6219,5038,6243,4916,4441,6533,6535,5699,4450,7101,6625,4719,4479,6748,5097,7139,5493,4905,5500,7165,4840,4643,4768,5294,4615,6957,6634,7592,4796,6529,4482,5845,7007,5745,7013,6222,6732,5030,7044,7028,5000,7738,5582,5979,7046,4935,4772,7753,4463,5864,7791,6817,7039,7669,7847,7075,4599,7856,7241,4515,5405,5853,5848,6340,6777,6140,5353,7969,6169,4626,4834,4993,5258,5245,8020,8005,5057,8007,5771,7130,5393,6621,4588,4938,5401,5041,5670,7751,5266,7182) GROUP BY `name` LIMIT 30 [ RunTime:0.005624s ]
SELECT `goods_id`,`goods_name`,`sales_sum`,`virtual_sales_sum`,`shop_price`,`bespeak_template_id`,`label_id` FROM `tp_goods` WHERE `goods_id` IN (31662,31667,31671,31673,31676,31678,31714,31715,31725,31992,32001,32004,32005,32006,32015,32201,32935,32956,32961,32972,32982,32985,33010,33012,33023,33024,33034,33039,33040,33043,33047,33048,33056,33079,33082,33111,33114,33115,33123,33125,33131,33149,33151,34059,34063,34064,34065,34067,34068,34071,34072,34074,34573,34638,34639,34679,34680,34725,34840,34844,34845,34846,34863,34864,34865,34867,34868,34873,34874,34877,34881,34916,34917,34918,34919,34920,34921,34934,34938,34939,34940,34941,34942,34943,34944,34945,34946,34947,34948,34949,34950,34951,34952,34953,34954,34955,35071,35085,35086,35087,35088,35089,35090,35091,35093,35111,35113,35114,35233,35275,35837,35839,35844,35845,35846,35859,35862,35863,35878,35880,35884,35887,35888,35891,35894,35895,35898,35901,35902,35907,35908,35910,36039,36068,36069,36116,36119,36210,36222,36261,36262,36264,36267,36268,36269,36270,36273,36274,36276,36279,36280,36282,36320,36357,36375,36379,36389,36390,36391,36395,36396,36397,36398,36400,36402,36403,36407,36418,36419,36420,36421,36422,36423,36425,36426,36428,36451,36452,36453,36454,36455,36456,36459,36468,36469,36485,36486,36487,36491,36498,36499,36500,36501,36516,36557,36571,36629,36630,36634,36681,36796,36806,36853,36854,36855,36859,36866,36870,36871,36911,37038,37039,37040,37041,37042,37043,37044,37072,37079,37080,37082,37092,37097,37161,37183,37212,37213,37240,37285,37337,37455,37457,37460,37484,37488,37600,37605,37672,37685,37708,37712,37714,37735,37741,37742,37743,37774,37778,37785,37819,37820,37830,38044,38063,38067,38095,38118,38119,38120,38121,38189,38209,38211,38231,38234,38245,38249,38260,38261,38262,38264,38266,38267,38268,38269,38273,38279,38288,38297,38301,38302,38303,38304,38305,38306,38313,38314,38316,38323,38335,38377,38391,38462,38513,38515,38516,38523,38572,38612,38635,38649,38651,38654,38726,38790,38800,38806,38810,38812,38822,38839,38844,38850,38923,38941,38943,38954,38969,38984,38986,38987,38988,38995,39057,39059,39065,39080,39107,39127,39149,39159,39161,39238,39368,39388,39398,39399,39427,39439,39485,39489,39560,39562,39563,39638,39639,39640,39641,39701,39702,39713,39736,39742,39855,39937,39939,39961,39986,40114,40148,40155,40156,40171,40173,40176,40180,40195,40223,40309,40310,40311,40312,40317,40318,40319,40355,40392,40394,40427,40428,40436,40441,40461,40499,40505,40506,40509,40510,40511,40512,40513,40539,40545,40559,40585,40586,40587,40589,40595,40596,40606,40610,40611,40637,40668,40671,40679,40698,40712,40714,40730,40731,40743,40744,40747,40752,40753,40754,40756,40758,40763,40769,40771,40772,40773,40774,40775,40777,40778,40779,40780,40781,40782,40783,40784,40804,40805,40806,40855,40856,40859,40861,40865,40869,40884,40914,40915,40919,41087,41088,41095,41098,41107,41151,41218,41220,41221,41232,41258,41297,41309,41313,41322,41333,41372,41380,41385,41402,41423,41436,41437,41477,41479,41515,41546,41829,41891,41964,41981,42015,42035,42081,42114,42187,42199,42255,42266,42287,42308,42345,42346,42347,42362,42367,42368,42410,42412,42430,42490,42491,42497,42597,42616,42621,42632,42638,42641,42671,42740,42782,42799,42825,42831,42833,42842,42843,42844,42848,42854,42857,42858,42859,42860,42861,42867,42868,42869,42873,42884,42893,42899,42905,42965,43000,43006,43073,43091,43092,43132,43137,43188,43258,43259,43260,43286,43288,43290,43320,43381,43396,43430,43431,43504,43527,43656,43735,43736,43755,43936,43940,43984,44051,44052,44104,44153,44154,44160,44196,44227,44228,44230,44231,44232,44233,44267,44272,44275,44287,44302,44313,44328,44346,44361,44370,44394,44397,44402,44404,44510,44511,44512,44513,44553,44562,44589,44594,44596,44598,44599,44617,44655,44659,44676,44677,44719,44771,44793,44806,44809,44840,44842,44843,44962,45009,45010,45011,45012,45075,45094,45225,45226,45261,45280,45281,45332,45337,45371,45497,45534,45583,45588,45590,45635,45636,45637,45646,45647,45652,45658,45659,45661,45662,45665,45667,45669,45672,45677,45678,45685,45687,45689,45695,45697,45698,45705,45706,45707,45708,45753,45760,45771,45776,45781,45919,45966,45967,45968,45983,45994,45997,46031,46034,46035,46065,46103,46240,46296,46297,46307,46331,46370,46375,46389,46525,46526,46607,46623,46671,46683,46698,46703,46745,46763,46775,46780,46785,46789,46807,46817,46818,46821,46822,46823,46826,46838,46983,46985,46994,46995,46996,46997,47047,47056,47057,47058,47059,47062,47104,47143,47172,47173,47174,47175,47192,47193,47202,47246,47247,47249,47255,47264,47265,47266,47267,47269,47283,47287,47290,47291,47292,47293,47298,47299,47306,47307,47308,47316,47335,47427,47510,47573,47575,47677,47715,47799,47842,47845,47852,47901,47905,47912,47917,47920,47930,47936,47940,47942,47946,47962,48000,48001,48157,48159,48160,48162,48170,48228,48358,48405,48428,48434,48438,48439,48440,48441,48470,48513,48594,48651,48665,48673,48681,48692,48693,48694,48695,48710,48728,48730,48731,48751,48803,48837,48838,48839,48860,48894,48895,48943,49027,49030,49031,49034,49087,49117,49127,49128,49142,49146,49147,49148,49150,49151,49176,49188,49190,49191,49301,49338,49339,49340,49353,49385,49386,49387,49388,49389,49390,49492,49493,49494,49495,49496,49497,49504,49507,49508,49509,49510,49527,49528,49529,49530,49531,49532,49536,49540,49541,49544,49545,49580,49581,49632,49641,49642,49643,49644,49683,49701,49702,49748,49793,49794,49839,49865,49922,49927,49951,50054,50144,50145,50146,50207,50208,50209,50211,50212,50213,50214,50215,50216,50217,50366,50374,50389,50475,50496,50501,50507,50596,50602,50733,50766,50769,50770,50773,50777,50813,50818,50847,50871,50872,50893,50894,50895,50896,50897,50903,50916,50927,51034,51037,51061,51066,51106,51176,51177,51184,51189,51192,51221,51226,51227,51248,51249,51250,51251,51252,51253,51278,51280,51297,51304,51359,51361,51416,51417,51419,51483,51545,51547,51548,51549,51550,51627,51630,51637,51702,51705,51712,51713,51714,51715,51725,51736,51745,51747,51748,51749,51750,51751,51827,51834,51841,51844,51869,51871,51914,51916,51926,52040,52041,52048,52049,52063,52107,52140,52141,52142,52149,52161,52168,52170,52172,52173,52175,52224,52225,52234,52236,52249,52250,52251,52252,52253,52262,52269,52276,52286,52307,52402,52483,52523,52542,52553,52715,52770,52771,52772,52773,52792,52815,52946,53038,53046,53062,53072,53073,53078,53081,53082,53083,53090,53091,53135,53136,53202,53203,53267,53272,53290,53320,53322,53324,53326,53355,53404,53405,53408,53601,53615,53622,53640,53751,53764,53781,53826,53869,53886,53888,53895,53923,53924,53925,53926,53962,53963,53971,53972,53973,53974,53975,53979,53988,54002,54010,54012,54027,54064,54221,54250,54258,54270,54271,54272,54306,54307,54308,54309,54310,54318,54411,54414,54461,54462,54468,54470,54477,54547,54564,54566,54568,54602,54604,54606,54687,54688,54689,54719,54764,54776,54778,54797,54808,54818,54834,54845,54886,54888,54892,54894,54902,54920,54924,54928,54929,54930,54931,54932,54933,54937,54954,55009,55029,55033,55034,55035,55045,55138,55142,55143,55146,55161,55409,55412,55534,55535,55536,55623,55624,55633,55689,55707,55719,55721,55730,55807,55816,55857,55882,55892,55894,55897,56012,56013,56029,56039,56044,56053,56079,56085,56088,56109,56129,56171,56172,56173,56179,56180,56194,56210,56224,56237,56267,56295,56296,56297,56356,56388,56396,56482,56542,56571,56572,56580,56624,56686,56687,56688,56689,56708,56718,56719,56720,56729,56743,56750,56756,56824,56825,56827,56960,57046,57048,57073,57124,57125,57127,57128,57140,57141,57142,57143,57150,57155,57157,57161,57175,57176,57177,57178,57179,57198,57206,57211,57212,57213,57214,57268,57289,57290,57421,57461,57467,57495,57499,57518,57577,57588,57590,57593,57609,57619,57632,57634,57635,57642,57695,57723,57780,57794,57795,57809,57810,57822,57824,57843,57845,57895,57960,57961,57987,57991,58017,58018,58041,58044,58137,58167,58168,58240,58330,58385,58458,58459,58460,58594,58827,58831,58832,58897,58898,58903,58941,58964,59048,59187,59221,59246,59250,59251,59256,59277,59362,59370,59411,59417,59425,59447,59449,59450,59458,59459,59484,59495,59503,59664,59685,59699,59700,59711,59712,59745,59790,59875,59877,59881,59882,59899,59900,59902,59903,59970,59976,60012,60083,60084,60086,60154,60187,60188,60189,60197,60199,60203,60205,60206,60207,60258,60263,60289,60307,60314,60364,60396,60433,60522,60523,60632,60657,60713,60732,60763,60786,60812,60813,60881,61070,61078,61081,61099,61132,61155,61156,61157,61158,61320,61321,61326,61360,61369,61393,61435,61464,61465,61518,61537,61538,61539,61611,61754,61840,61858,61911,61998,62007,62068,62153,62161,62172,62173,62174,62176,62236,62238,62282,62284,62302,62304,62346,62350,62355,62356,62374,62388,62389,62423,62463,62498,62615,62621,62632,62633,62640,62647,62880,62916,62917,62918,62920,63057,63072,63073,63074,63079,63088,63103,63136,63174,63217,63218,63219,63307,63350,63653,63919,63938,64020,64022,64043,64046,64049,64143,64159,64160,64161,64162,64179,64250,64258,64316,64361,64362,64443,64466,64467,64561,64607,64612,64634,64691,64693,64695,64696,64703,64810,64855,64856,64865,65078,65168,65267,65286,65317,65318,65335,65351,65372,65428,65429,65470,65484,65505,65561,65597,65599,65600,65601,65847,65866,65896,65898,65926,65932,66021,66126,66132,66252,66267,66293,66326,66418,66543,66544,66545,66550,66553,66565,66613,66639,66685,66697,66698,66746,66752,66767,66907,66914,66930,66943,66948,66984,66985,67237,67244,67247,67271,67288,67334,67336,67443,67477,67499,67556,67734,67735,67790,67876,67887,67932,67934,67935,67962,67989,68008,68009,68010,68029,68030,68033,68037,68038,68039,68043,68045,68104,68166,68221,68266,68300,68301,68345,68381,68526,68542,68616,68728,68895,68914,68915,68928,68929,68930,68974,69033,69065,69116,69272,69273,69275,69276,69277,69282,69283,69313,69360,69374,69375,69446,69501,69509) ORDER BY `sort` DESC LIMIT 0,12 [ RunTime:0.021224s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.001735s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (69509,69501,69446,69375,69374,69360,69313,69283,69282,69277,69276,69275) [ RunTime:0.001055s ]
SHOW FULL COLUMNS FROM `tp_goods_label` [ RunTime:0.001438s ]
SELECT `label_id`,`label_name` FROM `tp_goods_label` [ RunTime:0.000790s ]
SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.001128s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.000876s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 69509 LIMIT 1 [ RunTime:0.011642s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 69501 LIMIT 1 [ RunTime:0.004569s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 69446 LIMIT 1 [ RunTime:0.001602s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 69375 LIMIT 1 [ RunTime:0.005386s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 69374 LIMIT 1 [ RunTime:0.002586s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 69360 LIMIT 1 [ RunTime:0.004266s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 69313 LIMIT 1 [ RunTime:0.007459s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 69283 LIMIT 1 [ RunTime:0.007550s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 69282 LIMIT 1 [ RunTime:0.003671s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 69277 LIMIT 1 [ RunTime:0.007536s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 69276 LIMIT 1 [ RunTime:0.005703s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 69275 LIMIT 1 [ RunTime:0.006288s ]
