SHOW FULL COLUMNS FROM `tp_wx_user` [ RunTime:0.000938s ]
SELECT * FROM `tp_wx_user` WHERE ( w_token = "xkopzw1490691329" ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000306s ]
SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000594s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 378 LIMIT 1 [ RunTime:0.000204s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000187s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.001120s ]
SELECT `shop_price` FROM `tp_goods` WHERE `goods_id` IN (14559,35932,115368,120788,179826,179827,179836,179884,179885,179886,179887,179890,179935,179942,179943,179944,179953,179954,179955,179956,179957,179958,430,871,936,1082,1103,1343,2373,2376,2377,2512,2558,2623,2678,3388,4138,4457,4514,4516,4556,4816,4821,5054,5131,5174,5337,6149,6151,6152,6162,6493,6766,7026,7073,7074,7118,7908,13917,14162,16402,20928,20930,20954,21229,21728,22278,22528,26130,26375,26458,27897,30561,31893,32069,34150,36123,36311,36714,37022,37032,37033,44869,45961,47135,47333,54042,59851,59954,62190,62942,63130,63131,65144,65889,68375,76735,78641,79467,79469,80225,83462,85455,86058,86677,90919,91100,97471,97702,99568,99744,103469,104423,106869,106870,106883,106884,106885,107889,108113,110398,110692,110694,110695,111084,113971,114728,114884,114886,115386,115387,119566,121900,121901,129845,129846,131450,131451,131465,131477,131479,131480,133504,134419,135713,136079,136265,136408,139625,139789,142306,142307,143197,143479,143651,143818,145040,145056,145659,145662,146595,146760,146894,150832,154060,154845,155699,158550,159355,162348,166139,168818,170251,170264,170276,170280,170282,170331,170333,171898,174152,176886,176887,176888,176889,178774,180088,180498,180501,180514,180517,180524,180555,180558,180880,183792,184262,335,872,873,1117,1297,1298,1299,2274,2460,2585,2626,2627,2780,2903,3267,4137,4265,4596,4770,4792,4820,4930,5004,5101,5125,5144,5331,5460,5468,6166,6492,6495,6583,6625,6821,7027,7029,7191,7627,7835,7857,7954,8206,8244,13341,13421,13793,13916,14177,14304,14311,14554,14557,17701,18581,20886,20941,20945,20947,20953,21013,21326,21387,21783,21785,21793,22280,22946,23718,24576,24669,24808,24809,25284,25403,25507,25617,25716,25833,25936,26029,26136,26139,26630,27887,27888,27894,28088,28241,28243,29852,30024,30201,30552,30633,31016,31114,31376,31377,32070,32072,32074,32262,32286,32540,32565,32908,33000,33319,33334,34100,34834,35835,35840,36108,36318,36885,38770,38820,39613,43070,43074,43427,44901,45927,46888,46889,47177,56512,56522,56567,58728,60706,61139,61140,63128,65698,66564,66831,67130,68593,68594,72901,75658,75677,78639,78942,79195,79224,79237,79523,79526,79790,79798,80737,80830,80836,81100,83095,83938,85826,86073,86075,86076,86082,86083,86084,86097,86100,86497,86529,86531,86676,86873,86965,87003,87283,87468,87787,89449,89454,90260,90948,92138,94729,96292,97731,97862,101420,102724,104392,104393,106245,106874,106890,106891,106892,106893,106894,107598,108035,110173,110654,110829,111085,111086,113055,114016,114042,114366,114497,114746,115242,115597,115814,116630,116809,117445,117447,118199,118244,119668,119988,121048,122386,122387,123827,126132,127937,127938,127944,128179,130274,130514,130813,131452,131453,131455,131456,131472,131473,131475,131483,131484,131485,131496,131499,131505,132028,132072,132626,132779,134651,134913,135788,135987,136080,136409,136529,136530,138715,138942,139864,139875,140105,140330,140769,141187,141567,141812,142266,142463,144102,144772,145053,145059,145255,145676,145696,145698,146118,146888,149238,149241,149717,152807,154074,154478,157200,157201,157202,157269,157348,157847,159372,160722,162000,162526,164797,164810,166245,166485,169191,170053,170247,170248,170250,170252,170272,170290,170326,170330,170335,170340,170355,171530,173736,173777,176895,176896,176897,176898,176899,176901,176915,176924,176929,177203,178832,179846,179847,179966,180445,180492,180493,180495,180510,180522,180525,180541,180545,180548,180553,180559,180562,180563,180566,183437,183438,183793,183833,184261,2098,2269,2404,2979,2994,3065,3385,3409,4005,4139,4256,4374,4399,4519,4523,4605,5077,5252,5260,5295,5335,6000,6134,6767,6768,6769,7693,7694,10646,13959,16308,18274,18579,18580,20958,20959,21325,21798,21799,23719,23884,25504,26041,26378,26594,27895,28466,30437,30790,31000,31019,32706,32820,34097,34152,34835,35228,36476,37201,37453,38780,38853,44908,46657,46884,46886,47176,47187,57955,59191,59192,59577,61020,61021,61136,62420,62525,62943,65697,73616,79135,79214,79506,79846,79852,79926,80210,80827,83461,83846,86079,89728,91213,94749,96714,97732,97864,97869,98315,98772,100509,100582,101361,104382,105679,105787,106867,106868,106875,106882,106919,106921,107902,107912,111532,112204,112322,113058,115367,117232,117233,118719,119605,120796,121057,122574,127481,129385,129593,130291,130292,130294,131188,131476,131478,132978,135712,136534,139688,143650,143653,145061,145238,145663,145692,145703,145706,145725,145789,146887,149718,151044,152352,154375,154844,156278,158794,159201,159351,159352,162134,170277,170323,170342,170343,170347,176882,176883,176884,176885,176890,176891,177205,180101,180102,180103,180450,180452,180477,180479,180499,180513,180518,180556,180560,180564,180565,182994,183796,183881,184264,184265,184266,888,890,941,946,947,1176,2084,2397,2625,2673,2779,2984,3269,4222,4251,4252,4257,4263,4524,4603,4630,4631,4724,4733,4759,4760,4767,4793,4819,5108,5124,5141,5148,5167,5206,5219,5302,5333,5470,5726,6054,6059,6102,6115,6122,6133,6135,6146,6153,6161,6163,6205,6397,6491,6494,6626,6628,6822,7025,7095,7120,7121,7122,7799,7800,7915,8228,10642,11093,13900,14170,14312,14556,14561,14649,16020,16476,18010,18275,18706,18821,19083,19300,19301,20943,20944,20946,20951,20955,21298,21781,21784,22234,22662,23027,24189,24190,24569,24810,24892,24982,25017,25019,25232,25279,25280,25402,25724,26129,26314,26367,26377,26593,26629,26708,26860,27892,28076,28170,28237,28242,28416,28421,28854,29159,29463,29515,30023,30199,30560,30857,31058,31384,32065,32073,32119,32257,32439,32599,32708,32813,32814,32815,32816,32818,32888,32909,32942,32994,33318,33320,33342,33348,33520,33768,34103,34516,34944,35901,35925,35934,36064,36066,36086,36196,36319,36497,36498,36555,36682,36685,36707,36715,36780,36886,36951,36953,37119,37969,38211,38884,39614,39908,40495,40496,40880,40974,41201,41420,42938,42939,42943,42944,43026,43072,43073,43077,43418,43419,43420,44781,44782,44839,44870,44873,44874,44900,45641,45760,45761,45967,46782,46805,46885,46887,46894,46972,47054,47183,47298,47655,48409,54038,55231,56163,56551,56553,56554,56564,57984,59796,60410,61002,61764,62463,62945,62947,62973,62975,64485,65711,65712,65939,67129,68200,68534,69565,70708,70709,72681,72897,72905,72913,73193,73622,73625,73764,73860,74078,74404,75314,75563,75710,75752,76490,76512,76883,76885,76914,76916,78050,78084,78510,78640,79112,79125,79174,79217,79222,79230,79233,79239,79510,79521,79528,79530,79535,79537,79539,79543,79544,79547,79550,79558,79560,79561,79618,79848,79850,79927,79967,80197,80735,80740,80838,80844,80905,81072,84585,84586,84850,85115,85188,85422,85799,85923,85924,86008,86077,86078,86085,86087,86088,86089,86103,86107,86108,86109,86532,86678,86682,86889,86890,86959,86994,87599,87677,88367,88960,89448,89450,89456,89468,89562,89563,91094,91202,91214,91415,91729,92064,93974,94003,94172,94405,94783,96549,97705,97865,98318,98711,98912,99294,99846,99879,100254,101197,101216,101412,101413,101415,101419,103137,103138,103915,104380,104395,104397,106203,106679,106758,106802,106866,106871,106896,106898,106998,106999,107008,107011,107162,107232,107817,108115,108649,109116,109684,109865,109872,110591,111001,111002,111535,111536,111768,111914,112180,113032,113057,113830,113887,113970,113974,113986,113987,113988,113994,114015,114054,114119,114251,114344,114367,114368,114371,114372,114373,114375,114398,114424,114425,114434,114437,114619,114700,114716,115385,115388,115391,115759,115795,115797,115803,115805,115806,115807,115808,115977,116512,116629,116635,116811,116815,116854,116886,116924,116925,116926,116996,117004,117012,117250,117838,118410,118993,119113,119309,119310,119557,119564,119606,119921,120583,121039,121040,121056,121532,121533,121928,122078,122582,122584,125721,127945,129284,129420,129492,129592,130533,131185,131454,131457,131458,131459,131463,131474,131495,131498,131500,131501,131502,131503,131512,131966,132282,132625,132694,132695,132788,133786,134641,134642,135008,135662,135785,136001,136040,136207,136211,136614,136920,137343,138048,138875,138949,139044,139829,140817,142308,142549,142561,142620,142672,142818,143210,144341,144514,144520,144523,144525,145005,145590,145665,145668,145670,145672,145673,145674,145678,145690,145691,145694,145708,146066,146193,146891,147326,149239,149247,149255,149256,151300,152533,154075,154506,154590,154729,155283,156044,156282,157089,157345,157667,158554,160447,160448,161587,162039,162385,162525,163315,166801,167091,169048,170240,170241,170244,170245,170246,170255,170256,170257,170258,170259,170260,170263,170273,170274,170279,170281,170283,170285,170324,170325,170327,170328,170334,170753,170798,170974,173482,173490,175872,176426,176700,176892,176893,176894,176900,176902,176903,176905,176910,176913,176914,176916,176917,176919,176920,176922,176928,176930,177123,177204,177326,178829,179797,179845,180096,180439,180444,180476,180489,180491,180494,180496,180500,180504,180505,180506,180507,180508,180509,180511,180520,180521,180523,180528,180530,180540,180542,180544,180547,180550,180551,180557,180561,180902,181175,181176,181312,181528,182993,183790,183794,183939,877,878,965,966,967,1179,1183,1185,1286,1489,1618,1682,1698,2103,2344,2356,2358,2462,2574,2622,2658,2674,2841,2844,2982,3056,3071,3383,3399,3556,3986,4313,4364,4370,4420,4426,4795,4812,4837,4977,5107,5113,5118,5123,5130,5168,5208,5329,5410,6030,6031,6078,6754,6770,6771,7125,7126,7127,7128,7132,7133,7690,7797,8163,16362,21381,21383,21385,24931,25009,28920,29847,32047,32566,32567,32568,33779,34467,35218,35219,35220,35900,36091,36093,36094,36438,36452,36453,36454,36465,36467,36472,36874,36876,38854,38855,38880,38881,38882,40059,40061,40062,40500,43041,46025,46303,47053,47206,47207,48403,54041,56226,56227,56229,56565,56566,58727,60518,60707,60708,64192,64194,64196,65877,75635,75755,79452,79457,79462,85701,85800,85801,87984,88832,88833,88834,90261,90262,90263,91571,91573,92255,96367,96373,98767,98784,98792,98795,98796,98808,99454,99456,100588,101427,103845,104784,105793,108925,108927,108928,108932,109679,110693,111911,112640,112641,112949,112950,112951,113183,113576,113695,114754,115402,116719,126436,126603,129336,129401,129680,133464,133465,133466,134707,136245,145019,145027,145699,145702,145705,145713,145715,145716,147698,155698,158404,161935,166473,166474,168247,170289,170295,170296,170299,170303,170304,170310,170341,170344,170345,171425,173650,173651,176859,176861,176862,176863,176864,176865,176866,176867,176868,176869,176870,176871,176872,176873,176874,176875,176876,176877,176878,176879,176880,177126,179226,180447,180451,180453,180454,180455,180457,180458,180459,180462,180466,180467,180468,180470,180471,180472,180473,180474,180475,180478,180480,180481,180483,180484,180485,180487,180534,180535,180536,180537,180538,181532,183791,939,942,943,1293,1410,2562,2566,2991,3272,4253,4254,4255,4259,4260,4262,4561,4569,4577,4588,4590,4706,4755,4762,4935,5102,5176,5299,5300,5301,5304,5469,5725,13861,14046,18578,19797,20950,21423,21788,23739,24006,24568,24812,25401,25404,25618,25749,28238,28240,29435,29462,29574,29775,29776,30632,31007,31484,32363,32584,34101,34102,35229,36314,36684,36687,36775,36779,38775,38897,39815,40065,40542,43122,45968,46053,54044,66826,73627,77223,78932,79464,79532,79542,79548,79557,80847,88447,89729,94004,94005,97621,97703,97704,97734,98971,100698,101196,104418,106476,107084,107890,108116,112906,114593,115743,115792,115794,115796,116508,116509,116513,119989,127941,127942,128787,129285,129843,130548,130898,130904,133429,134242,135396,135733,135786,136917,136924,136958,136966,137329,140107,142536,142542,142653,142785,143483,144342,146274,151235,152989,153218,154579,155849,156460,158971,160613,160751,166093,166369,167757,169338,170253,170275,170292,173497,176520,176907,176923,180099,180546,180552,181314,184263,184268,2036,2037,2847,5070,16310,21384,22804,23895,25606,36473,36716,36717,39606,39608,39610,44842,55291,60510,65878,79456,85065,87676,96705,98766,98773,99547,101429,101430,101431,103140,103847,104785,107274,116146,119112,129403,130272,145714,145717,145718,145721,145722,145723,159350,170301,170302,170321,170322,176860,176881,178973,180446,180448,180456,180460,180461,180463,180464,180465,180469,180531,180532,338,2677,4772,6621,20633,31645,32066,32817,36310,36316,45949,47134,48406,54046,61137,61766,62490,62526,62944,63556,68595,70733,72928,76884,78080,79509,79522,80685,80726,84584,85921,86007,86080,86081,86533,86721,86885,86919,87236,87691,89451,89455,89668,89716,89719,91099,91204,94744,96752,97460,97470,97733,97866,97874,98759,100442,101362,101414,101416,101418,103136,103141,104098,106887,106895,106900,107030,107818,107819,109680,109868,110395,111003,112200,112205,112496,112659,112849,113122,113123,113851,113984,114008,114258,114262,114263,114369,114370,114374,114376,114377,114598,114745,115392,115804,115809,116424,116510,116511,116514,116559,116853,116885,116923,117006,117740,118797,118838,119434,119556,119683,120584,121782,122318,127946,127947,129252,130273,131170,131186,131464,131466,131482,131497,131715,132194,132997,133304,133787,133788,135009,135010,135663,136002,136617,136797,136940,136964,138514,140103,142203,142540,145593,145664,145675,145679,145693,147422,147423,149860,150220,152534,153601,154578,154846,155301,156917,158551,158557,158601,158726,162384,164440,170239,170242,170243,170254,170278,170286,170287,170288,170291,170320,170329,170332,170336,176904,176906,176909,176911,176912,176918,176921,176925,176926,176927,178773,178830,179275,179787,180442,180443,180486,180490,180502,180503,180512,180526,180543,180549,180554,180738,181174,181496,181915,183795,183903,184267,186141) [ RunTime:0.017629s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (14559,35932,115368,120788,179826,179827,179836,179884,179885,179886,179887,179890,179935,179942,179943,179944,179953,179954,179955,179956,179957,179958,430,871,936,1082,1103,1343,2373,2376,2377,2512,2558,2623,2678,3388,4138,4457,4514,4516,4556,4816,4821,5054,5131,5174,5337,6149,6151,6152,6162,6493,6766,7026,7073,7074,7118,7908,13917,14162,16402,20928,20930,20954,21229,21728,22278,22528,26130,26375,26458,27897,30561,31893,32069,34150,36123,36311,36714,37022,37032,37033,44869,45961,47135,47333,54042,59851,59954,62190,62942,63130,63131,65144,65889,68375,76735,78641,79467,79469,80225,83462,85455,86058,86677,90919,91100,97471,97702,99568,99744,103469,104423,106869,106870,106883,106884,106885,107889,108113,110398,110692,110694,110695,111084,113971,114728,114884,114886,115386,115387,119566,121900,121901,129845,129846,131450,131451,131465,131477,131479,131480,133504,134419,135713,136079,136265,136408,139625,139789,142306,142307,143197,143479,143651,143818,145040,145056,145659,145662,146595,146760,146894,150832,154060,154845,155699,158550,159355,162348,166139,168818,170251,170264,170276,170280,170282,170331,170333,171898,174152,176886,176887,176888,176889,178774,180088,180498,180501,180514,180517,180524,180555,180558,180880,183792,184262,335,872,873,1117,1297,1298,1299,2274,2460,2585,2626,2627,2780,2903,3267,4137,4265,4596,4770,4792,4820,4930,5004,5101,5125,5144,5331,5460,5468,6166,6492,6495,6583,6625,6821,7027,7029,7191,7627,7835,7857,7954,8206,8244,13341,13421,13793,13916,14177,14304,14311,14554,14557,17701,18581,20886,20941,20945,20947,20953,21013,21326,21387,21783,21785,21793,22280,22946,23718,24576,24669,24808,24809,25284,25403,25507,25617,25716,25833,25936,26029,26136,26139,26630,27887,27888,27894,28088,28241,28243,29852,30024,30201,30552,30633,31016,31114,31376,31377,32070,32072,32074,32262,32286,32540,32565,32908,33000,33319,33334,34100,34834,35835,35840,36108,36318,36885,38770,38820,39613,43070,43074,43427,44901,45927,46888,46889,47177,56512,56522,56567,58728,60706,61139,61140,63128,65698,66564,66831,67130,68593,68594,72901,75658,75677,78639,78942,79195,79224,79237,79523,79526,79790,79798,80737,80830,80836,81100,83095,83938,85826,86073,86075,86076,86082,86083,86084,86097,86100,86497,86529,86531,86676,86873,86965,87003,87283,87468,87787,89449,89454,90260,90948,92138,94729,96292,97731,97862,101420,102724,104392,104393,106245,106874,106890,106891,106892,106893,106894,107598,108035,110173,110654,110829,111085,111086,113055,114016,114042,114366,114497,114746,115242,115597,115814,116630,116809,117445,117447,118199,118244,119668,119988,121048,122386,122387,123827,126132,127937,127938,127944,128179,130274,130514,130813,131452,131453,131455,131456,131472,131473,131475,131483,131484,131485,131496,131499,131505,132028,132072,132626,132779,134651,134913,135788,135987,136080,136409,136529,136530,138715,138942,139864,139875,140105,140330,140769,141187,141567,141812,142266,142463,144102,144772,145053,145059,145255,145676,145696,145698,146118,146888,149238,149241,149717,152807,154074,154478,157200,157201,157202,157269,157348,157847,159372,160722,162000,162526,164797,164810,166245,166485,169191,170053,170247,170248,170250,170252,170272,170290,170326,170330,170335,170340,170355,171530,173736,173777,176895,176896,176897,176898,176899,176901,176915,176924,176929,177203,178832,179846,179847,179966,180445,180492,180493,180495,180510,180522,180525,180541,180545,180548,180553,180559,180562,180563,180566,183437,183438,183793,183833,184261,2098,2269,2404,2979,2994,3065,3385,3409,4005,4139,4256,4374,4399,4519,4523,4605,5077,5252,5260,5295,5335,6000,6134,6767,6768,6769,7693,7694,10646,13959,16308,18274,18579,18580,20958,20959,21325,21798,21799,23719,23884,25504,26041,26378,26594,27895,28466,30437,30790,31000,31019,32706,32820,34097,34152,34835,35228,36476,37201,37453,38780,38853,44908,46657,46884,46886,47176,47187,57955,59191,59192,59577,61020,61021,61136,62420,62525,62943,65697,73616,79135,79214,79506,79846,79852,79926,80210,80827,83461,83846,86079,89728,91213,94749,96714,97732,97864,97869,98315,98772,100509,100582,101361,104382,105679,105787,106867,106868,106875,106882,106919,106921,107902,107912,111532,112204,112322,113058,115367,117232,117233,118719,119605,120796,121057,122574,127481,129385,129593,130291,130292,130294,131188,131476,131478,132978,135712,136534,139688,143650,143653,145061,145238,145663,145692,145703,145706,145725,145789,146887,149718,151044,152352,154375,154844,156278,158794,159201,159351,159352,162134,170277,170323,170342,170343,170347,176882,176883,176884,176885,176890,176891,177205,180101,180102,180103,180450,180452,180477,180479,180499,180513,180518,180556,180560,180564,180565,182994,183796,183881,184264,184265,184266,888,890,941,946,947,1176,2084,2397,2625,2673,2779,2984,3269,4222,4251,4252,4257,4263,4524,4603,4630,4631,4724,4733,4759,4760,4767,4793,4819,5108,5124,5141,5148,5167,5206,5219,5302,5333,5470,5726,6054,6059,6102,6115,6122,6133,6135,6146,6153,6161,6163,6205,6397,6491,6494,6626,6628,6822,7025,7095,7120,7121,7122,7799,7800,7915,8228,10642,11093,13900,14170,14312,14556,14561,14649,16020,16476,18010,18275,18706,18821,19083,19300,19301,20943,20944,20946,20951,20955,21298,21781,21784,22234,22662,23027,24189,24190,24569,24810,24892,24982,25017,25019,25232,25279,25280,25402,25724,26129,26314,26367,26377,26593,26629,26708,26860,27892,28076,28170,28237,28242,28416,28421,28854,29159,29463,29515,30023,30199,30560,30857,31058,31384,32065,32073,32119,32257,32439,32599,32708,32813,32814,32815,32816,32818,32888,32909,32942,32994,33318,33320,33342,33348,33520,33768,34103,34516,34944,35901,35925,35934,36064,36066,36086,36196,36319,36497,36498,36555,36682,36685,36707,36715,36780,36886,36951,36953,37119,37969,38211,38884,39614,39908,40495,40496,40880,40974,41201,41420,42938,42939,42943,42944,43026,43072,43073,43077,43418,43419,43420,44781,44782,44839,44870,44873,44874,44900,45641,45760,45761,45967,46782,46805,46885,46887,46894,46972,47054,47183,47298,47655,48409,54038,55231,56163,56551,56553,56554,56564,57984,59796,60410,61002,61764,62463,62945,62947,62973,62975,64485,65711,65712,65939,67129,68200,68534,69565,70708,70709,72681,72897,72905,72913,73193,73622,73625,73764,73860,74078,74404,75314,75563,75710,75752,76490,76512,76883,76885,76914,76916,78050,78084,78510,78640,79112,79125,79174,79217,79222,79230,79233,79239,79510,79521,79528,79530,79535,79537,79539,79543,79544,79547,79550,79558,79560,79561,79618,79848,79850,79927,79967,80197,80735,80740,80838,80844,80905,81072,84585,84586,84850,85115,85188,85422,85799,85923,85924,86008,86077,86078,86085,86087,86088,86089,86103,86107,86108,86109,86532,86678,86682,86889,86890,86959,86994,87599,87677,88367,88960,89448,89450,89456,89468,89562,89563,91094,91202,91214,91415,91729,92064,93974,94003,94172,94405,94783,96549,97705,97865,98318,98711,98912,99294,99846,99879,100254,101197,101216,101412,101413,101415,101419,103137,103138,103915,104380,104395,104397,106203,106679,106758,106802,106866,106871,106896,106898,106998,106999,107008,107011,107162,107232,107817,108115,108649,109116,109684,109865,109872,110591,111001,111002,111535,111536,111768,111914,112180,113032,113057,113830,113887,113970,113974,113986,113987,113988,113994,114015,114054,114119,114251,114344,114367,114368,114371,114372,114373,114375,114398,114424,114425,114434,114437,114619,114700,114716,115385,115388,115391,115759,115795,115797,115803,115805,115806,115807,115808,115977,116512,116629,116635,116811,116815,116854,116886,116924,116925,116926,116996,117004,117012,117250,117838,118410,118993,119113,119309,119310,119557,119564,119606,119921,120583,121039,121040,121056,121532,121533,121928,122078,122582,122584,125721,127945,129284,129420,129492,129592,130533,131185,131454,131457,131458,131459,131463,131474,131495,131498,131500,131501,131502,131503,131512,131966,132282,132625,132694,132695,132788,133786,134641,134642,135008,135662,135785,136001,136040,136207,136211,136614,136920,137343,138048,138875,138949,139044,139829,140817,142308,142549,142561,142620,142672,142818,143210,144341,144514,144520,144523,144525,145005,145590,145665,145668,145670,145672,145673,145674,145678,145690,145691,145694,145708,146066,146193,146891,147326,149239,149247,149255,149256,151300,152533,154075,154506,154590,154729,155283,156044,156282,157089,157345,157667,158554,160447,160448,161587,162039,162385,162525,163315,166801,167091,169048,170240,170241,170244,170245,170246,170255,170256,170257,170258,170259,170260,170263,170273,170274,170279,170281,170283,170285,170324,170325,170327,170328,170334,170753,170798,170974,173482,173490,175872,176426,176700,176892,176893,176894,176900,176902,176903,176905,176910,176913,176914,176916,176917,176919,176920,176922,176928,176930,177123,177204,177326,178829,179797,179845,180096,180439,180444,180476,180489,180491,180494,180496,180500,180504,180505,180506,180507,180508,180509,180511,180520,180521,180523,180528,180530,180540,180542,180544,180547,180550,180551,180557,180561,180902,181175,181176,181312,181528,182993,183790,183794,183939,877,878,965,966,967,1179,1183,1185,1286,1489,1618,1682,1698,2103,2344,2356,2358,2462,2574,2622,2658,2674,2841,2844,2982,3056,3071,3383,3399,3556,3986,4313,4364,4370,4420,4426,4795,4812,4837,4977,5107,5113,5118,5123,5130,5168,5208,5329,5410,6030,6031,6078,6754,6770,6771,7125,7126,7127,7128,7132,7133,7690,7797,8163,16362,21381,21383,21385,24931,25009,28920,29847,32047,32566,32567,32568,33779,34467,35218,35219,35220,35900,36091,36093,36094,36438,36452,36453,36454,36465,36467,36472,36874,36876,38854,38855,38880,38881,38882,40059,40061,40062,40500,43041,46025,46303,47053,47206,47207,48403,54041,56226,56227,56229,56565,56566,58727,60518,60707,60708,64192,64194,64196,65877,75635,75755,79452,79457,79462,85701,85800,85801,87984,88832,88833,88834,90261,90262,90263,91571,91573,92255,96367,96373,98767,98784,98792,98795,98796,98808,99454,99456,100588,101427,103845,104784,105793,108925,108927,108928,108932,109679,110693,111911,112640,112641,112949,112950,112951,113183,113576,113695,114754,115402,116719,126436,126603,129336,129401,129680,133464,133465,133466,134707,136245,145019,145027,145699,145702,145705,145713,145715,145716,147698,155698,158404,161935,166473,166474,168247,170289,170295,170296,170299,170303,170304,170310,170341,170344,170345,171425,173650,173651,176859,176861,176862,176863,176864,176865,176866,176867,176868,176869,176870,176871,176872,176873,176874,176875,176876,176877,176878,176879,176880,177126,179226,180447,180451,180453,180454,180455,180457,180458,180459,180462,180466,180467,180468,180470,180471,180472,180473,180474,180475,180478,180480,180481,180483,180484,180485,180487,180534,180535,180536,180537,180538,181532,183791,939,942,943,1293,1410,2562,2566,2991,3272,4253,4254,4255,4259,4260,4262,4561,4569,4577,4588,4590,4706,4755,4762,4935,5102,5176,5299,5300,5301,5304,5469,5725,13861,14046,18578,19797,20950,21423,21788,23739,24006,24568,24812,25401,25404,25618,25749,28238,28240,29435,29462,29574,29775,29776,30632,31007,31484,32363,32584,34101,34102,35229,36314,36684,36687,36775,36779,38775,38897,39815,40065,40542,43122,45968,46053,54044,66826,73627,77223,78932,79464,79532,79542,79548,79557,80847,88447,89729,94004,94005,97621,97703,97704,97734,98971,100698,101196,104418,106476,107084,107890,108116,112906,114593,115743,115792,115794,115796,116508,116509,116513,119989,127941,127942,128787,129285,129843,130548,130898,130904,133429,134242,135396,135733,135786,136917,136924,136958,136966,137329,140107,142536,142542,142653,142785,143483,144342,146274,151235,152989,153218,154579,155849,156460,158971,160613,160751,166093,166369,167757,169338,170253,170275,170292,173497,176520,176907,176923,180099,180546,180552,181314,184263,184268,2036,2037,2847,5070,16310,21384,22804,23895,25606,36473,36716,36717,39606,39608,39610,44842,55291,60510,65878,79456,85065,87676,96705,98766,98773,99547,101429,101430,101431,103140,103847,104785,107274,116146,119112,129403,130272,145714,145717,145718,145721,145722,145723,159350,170301,170302,170321,170322,176860,176881,178973,180446,180448,180456,180460,180461,180463,180464,180465,180469,180531,180532,338,2677,4772,6621,20633,31645,32066,32817,36310,36316,45949,47134,48406,54046,61137,61766,62490,62526,62944,63556,68595,70733,72928,76884,78080,79509,79522,80685,80726,84584,85921,86007,86080,86081,86533,86721,86885,86919,87236,87691,89451,89455,89668,89716,89719,91099,91204,94744,96752,97460,97470,97733,97866,97874,98759,100442,101362,101414,101416,101418,103136,103141,104098,106887,106895,106900,107030,107818,107819,109680,109868,110395,111003,112200,112205,112496,112659,112849,113122,113123,113851,113984,114008,114258,114262,114263,114369,114370,114374,114376,114377,114598,114745,115392,115804,115809,116424,116510,116511,116514,116559,116853,116885,116923,117006,117740,118797,118838,119434,119556,119683,120584,121782,122318,127946,127947,129252,130273,131170,131186,131464,131466,131482,131497,131715,132194,132997,133304,133787,133788,135009,135010,135663,136002,136617,136797,136940,136964,138514,140103,142203,142540,145593,145664,145675,145679,145693,147422,147423,149860,150220,152534,153601,154578,154846,155301,156917,158551,158557,158601,158726,162384,164440,170239,170242,170243,170254,170278,170286,170287,170288,170291,170320,170329,170332,170336,176904,176906,176909,176911,176912,176918,176921,176925,176926,176927,178773,178830,179275,179787,180442,180443,180486,180490,180502,180503,180512,180526,180543,180549,180554,180738,181174,181496,181915,183795,183903,184267,186141) AND `brand_id` > 0 [ RunTime:0.029181s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.000917s ]
SELECT * FROM `tp_brand` WHERE `id` IN (43,24,25,149,27,35,61,46,33,145,125,163,143,34,44,40,68,45,126,269,255,245,146,115,63,174,93,124,187,95,330,188) LIMIT 30 [ RunTime:0.000325s ]
select group_concat(`key` separator '_') as `key` from tp_spec_goods_price where goods_id in(14559,35932,115368,120788,179826,179827,179836,179884,179885,179886,179887,179890,179935,179942,179943,179944,179953,179954,179955,179956,179957,179958,430,871,936,1082,1103,1343,2373,2376,2377,2512,2558,2623,2678,3388,4138,4457,4514,4516,4556,4816,4821,5054,5131,5174,5337,6149,6151,6152,6162,6493,6766,7026,7073,7074,7118,7908,13917,14162,16402,20928,20930,20954,21229,21728,22278,22528,26130,26375,26458,27897,30561,31893,32069,34150,36123,36311,36714,37022,37032,37033,44869,45961,47135,47333,54042,59851,59954,62190,62942,63130,63131,65144,65889,68375,76735,78641,79467,79469,80225,83462,85455,86058,86677,90919,91100,97471,97702,99568,99744,103469,104423,106869,106870,106883,106884,106885,107889,108113,110398,110692,110694,110695,111084,113971,114728,114884,114886,115386,115387,119566,121900,121901,129845,129846,131450,131451,131465,131477,131479,131480,133504,134419,135713,136079,136265,136408,139625,139789,142306,142307,143197,143479,143651,143818,145040,145056,145659,145662,146595,146760,146894,150832,154060,154845,155699,158550,159355,162348,166139,168818,170251,170264,170276,170280,170282,170331,170333,171898,174152,176886,176887,176888,176889,178774,180088,180498,180501,180514,180517,180524,180555,180558,180880,183792,184262,335,872,873,1117,1297,1298,1299,2274,2460,2585,2626,2627,2780,2903,3267,4137,4265,4596,4770,4792,4820,4930,5004,5101,5125,5144,5331,5460,5468,6166,6492,6495,6583,6625,6821,7027,7029,7191,7627,7835,7857,7954,8206,8244,13341,13421,13793,13916,14177,14304,14311,14554,14557,17701,18581,20886,20941,20945,20947,20953,21013,21326,21387,21783,21785,21793,22280,22946,23718,24576,24669,24808,24809,25284,25403,25507,25617,25716,25833,25936,26029,26136,26139,26630,27887,27888,27894,28088,28241,28243,29852,30024,30201,30552,30633,31016,31114,31376,31377,32070,32072,32074,32262,32286,32540,32565,32908,33000,33319,33334,34100,34834,35835,35840,36108,36318,36885,38770,38820,39613,43070,43074,43427,44901,45927,46888,46889,47177,56512,56522,56567,58728,60706,61139,61140,63128,65698,66564,66831,67130,68593,68594,72901,75658,75677,78639,78942,79195,79224,79237,79523,79526,79790,79798,80737,80830,80836,81100,83095,83938,85826,86073,86075,86076,86082,86083,86084,86097,86100,86497,86529,86531,86676,86873,86965,87003,87283,87468,87787,89449,89454,90260,90948,92138,94729,96292,97731,97862,101420,102724,104392,104393,106245,106874,106890,106891,106892,106893,106894,107598,108035,110173,110654,110829,111085,111086,113055,114016,114042,114366,114497,114746,115242,115597,115814,116630,116809,117445,117447,118199,118244,119668,119988,121048,122386,122387,123827,126132,127937,127938,127944,128179,130274,130514,130813,131452,131453,131455,131456,131472,131473,131475,131483,131484,131485,131496,131499,131505,132028,132072,132626,132779,134651,134913,135788,135987,136080,136409,136529,136530,138715,138942,139864,139875,140105,140330,140769,141187,141567,141812,142266,142463,144102,144772,145053,145059,145255,145676,145696,145698,146118,146888,149238,149241,149717,152807,154074,154478,157200,157201,157202,157269,157348,157847,159372,160722,162000,162526,164797,164810,166245,166485,169191,170053,170247,170248,170250,170252,170272,170290,170326,170330,170335,170340,170355,171530,173736,173777,176895,176896,176897,176898,176899,176901,176915,176924,176929,177203,178832,179846,179847,179966,180445,180492,180493,180495,180510,180522,180525,180541,180545,180548,180553,180559,180562,180563,180566,183437,183438,183793,183833,184261,2098,2269,2404,2979,2994,3065,3385,3409,4005,4139,4256,4374,4399,4519,4523,4605,5077,5252,5260,5295,5335,6000,6134,6767,6768,6769,7693,7694,10646,13959,16308,18274,18579,18580,20958,20959,21325,21798,21799,23719,23884,25504,26041,26378,26594,27895,28466,30437,30790,31000,31019,32706,32820,34097,34152,34835,35228,36476,37201,37453,38780,38853,44908,46657,46884,46886,47176,47187,57955,59191,59192,59577,61020,61021,61136,62420,62525,62943,65697,73616,79135,79214,79506,79846,79852,79926,80210,80827,83461,83846,86079,89728,91213,94749,96714,97732,97864,97869,98315,98772,100509,100582,101361,104382,105679,105787,106867,106868,106875,106882,106919,106921,107902,107912,111532,112204,112322,113058,115367,117232,117233,118719,119605,120796,121057,122574,127481,129385,129593,130291,130292,130294,131188,131476,131478,132978,135712,136534,139688,143650,143653,145061,145238,145663,145692,145703,145706,145725,145789,146887,149718,151044,152352,154375,154844,156278,158794,159201,159351,159352,162134,170277,170323,170342,170343,170347,176882,176883,176884,176885,176890,176891,177205,180101,180102,180103,180450,180452,180477,180479,180499,180513,180518,180556,180560,180564,180565,182994,183796,183881,184264,184265,184266,888,890,941,946,947,1176,2084,2397,2625,2673,2779,2984,3269,4222,4251,4252,4257,4263,4524,4603,4630,4631,4724,4733,4759,4760,4767,4793,4819,5108,5124,5141,5148,5167,5206,5219,5302,5333,5470,5726,6054,6059,6102,6115,6122,6133,6135,6146,6153,6161,6163,6205,6397,6491,6494,6626,6628,6822,7025,7095,7120,7121,7122,7799,7800,7915,8228,10642,11093,13900,14170,14312,14556,14561,14649,16020,16476,18010,18275,18706,18821,19083,19300,19301,20943,20944,20946,20951,20955,21298,21781,21784,22234,22662,23027,24189,24190,24569,24810,24892,24982,25017,25019,25232,25279,25280,25402,25724,26129,26314,26367,26377,26593,26629,26708,26860,27892,28076,28170,28237,28242,28416,28421,28854,29159,29463,29515,30023,30199,30560,30857,31058,31384,32065,32073,32119,32257,32439,32599,32708,32813,32814,32815,32816,32818,32888,32909,32942,32994,33318,33320,33342,33348,33520,33768,34103,34516,34944,35901,35925,35934,36064,36066,36086,36196,36319,36497,36498,36555,36682,36685,36707,36715,36780,36886,36951,36953,37119,37969,38211,38884,39614,39908,40495,40496,40880,40974,41201,41420,42938,42939,42943,42944,43026,43072,43073,43077,43418,43419,43420,44781,44782,44839,44870,44873,44874,44900,45641,45760,45761,45967,46782,46805,46885,46887,46894,46972,47054,47183,47298,47655,48409,54038,55231,56163,56551,56553,56554,56564,57984,59796,60410,61002,61764,62463,62945,62947,62973,62975,64485,65711,65712,65939,67129,68200,68534,69565,70708,70709,72681,72897,72905,72913,73193,73622,73625,73764,73860,74078,74404,75314,75563,75710,75752,76490,76512,76883,76885,76914,76916,78050,78084,78510,78640,79112,79125,79174,79217,79222,79230,79233,79239,79510,79521,79528,79530,79535,79537,79539,79543,79544,79547,79550,79558,79560,79561,79618,79848,79850,79927,79967,80197,80735,80740,80838,80844,80905,81072,84585,84586,84850,85115,85188,85422,85799,85923,85924,86008,86077,86078,86085,86087,86088,86089,86103,86107,86108,86109,86532,86678,86682,86889,86890,86959,86994,87599,87677,88367,88960,89448,89450,89456,89468,89562,89563,91094,91202,91214,91415,91729,92064,93974,94003,94172,94405,94783,96549,97705,97865,98318,98711,98912,99294,99846,99879,100254,101197,101216,101412,101413,101415,101419,103137,103138,103915,104380,104395,104397,106203,106679,106758,106802,106866,106871,106896,106898,106998,106999,107008,107011,107162,107232,107817,108115,108649,109116,109684,109865,109872,110591,111001,111002,111535,111536,111768,111914,112180,113032,113057,113830,113887,113970,113974,113986,113987,113988,113994,114015,114054,114119,114251,114344,114367,114368,114371,114372,114373,114375,114398,114424,114425,114434,114437,114619,114700,114716,115385,115388,115391,115759,115795,115797,115803,115805,115806,115807,115808,115977,116512,116629,116635,116811,116815,116854,116886,116924,116925,116926,116996,117004,117012,117250,117838,118410,118993,119113,119309,119310,119557,119564,119606,119921,120583,121039,121040,121056,121532,121533,121928,122078,122582,122584,125721,127945,129284,129420,129492,129592,130533,131185,131454,131457,131458,131459,131463,131474,131495,131498,131500,131501,131502,131503,131512,131966,132282,132625,132694,132695,132788,133786,134641,134642,135008,135662,135785,136001,136040,136207,136211,136614,136920,137343,138048,138875,138949,139044,139829,140817,142308,142549,142561,142620,142672,142818,143210,144341,144514,144520,144523,144525,145005,145590,145665,145668,145670,145672,145673,145674,145678,145690,145691,145694,145708,146066,146193,146891,147326,149239,149247,149255,149256,151300,152533,154075,154506,154590,154729,155283,156044,156282,157089,157345,157667,158554,160447,160448,161587,162039,162385,162525,163315,166801,167091,169048,170240,170241,170244,170245,170246,170255,170256,170257,170258,170259,170260,170263,170273,170274,170279,170281,170283,170285,170324,170325,170327,170328,170334,170753,170798,170974,173482,173490,175872,176426,176700,176892,176893,176894,176900,176902,176903,176905,176910,176913,176914,176916,176917,176919,176920,176922,176928,176930,177123,177204,177326,178829,179797,179845,180096,180439,180444,180476,180489,180491,180494,180496,180500,180504,180505,180506,180507,180508,180509,180511,180520,180521,180523,180528,180530,180540,180542,180544,180547,180550,180551,180557,180561,180902,181175,181176,181312,181528,182993,183790,183794,183939,877,878,965,966,967,1179,1183,1185,1286,1489,1618,1682,1698,2103,2344,2356,2358,2462,2574,2622,2658,2674,2841,2844,2982,3056,3071,3383,3399,3556,3986,4313,4364,4370,4420,4426,4795,4812,4837,4977,5107,5113,5118,5123,5130,5168,5208,5329,5410,6030,6031,6078,6754,6770,6771,7125,7126,7127,7128,7132,7133,7690,7797,8163,16362,21381,21383,21385,24931,25009,28920,29847,32047,32566,32567,32568,33779,34467,35218,35219,35220,35900,36091,36093,36094,36438,36452,36453,36454,36465,36467,36472,36874,36876,38854,38855,38880,38881,38882,40059,40061,40062,40500,43041,46025,46303,47053,47206,47207,48403,54041,56226,56227,56229,56565,56566,58727,60518,60707,60708,64192,64194,64196,65877,75635,75755,79452,79457,79462,85701,85800,85801,87984,88832,88833,88834,90261,90262,90263,91571,91573,92255,96367,96373,98767,98784,98792,98795,98796,98808,99454,99456,100588,101427,103845,104784,105793,108925,108927,108928,108932,109679,110693,111911,112640,112641,112949,112950,112951,113183,113576,113695,114754,115402,116719,126436,126603,129336,129401,129680,133464,133465,133466,134707,136245,145019,145027,145699,145702,145705,145713,145715,145716,147698,155698,158404,161935,166473,166474,168247,170289,170295,170296,170299,170303,170304,170310,170341,170344,170345,171425,173650,173651,176859,176861,176862,176863,176864,176865,176866,176867,176868,176869,176870,176871,176872,176873,176874,176875,176876,176877,176878,176879,176880,177126,179226,180447,180451,180453,180454,180455,180457,180458,180459,180462,180466,180467,180468,180470,180471,180472,180473,180474,180475,180478,180480,180481,180483,180484,180485,180487,180534,180535,180536,180537,180538,181532,183791,939,942,943,1293,1410,2562,2566,2991,3272,4253,4254,4255,4259,4260,4262,4561,4569,4577,4588,4590,4706,4755,4762,4935,5102,5176,5299,5300,5301,5304,5469,5725,13861,14046,18578,19797,20950,21423,21788,23739,24006,24568,24812,25401,25404,25618,25749,28238,28240,29435,29462,29574,29775,29776,30632,31007,31484,32363,32584,34101,34102,35229,36314,36684,36687,36775,36779,38775,38897,39815,40065,40542,43122,45968,46053,54044,66826,73627,77223,78932,79464,79532,79542,79548,79557,80847,88447,89729,94004,94005,97621,97703,97704,97734,98971,100698,101196,104418,106476,107084,107890,108116,112906,114593,115743,115792,115794,115796,116508,116509,116513,119989,127941,127942,128787,129285,129843,130548,130898,130904,133429,134242,135396,135733,135786,136917,136924,136958,136966,137329,140107,142536,142542,142653,142785,143483,144342,146274,151235,152989,153218,154579,155849,156460,158971,160613,160751,166093,166369,167757,169338,170253,170275,170292,173497,176520,176907,176923,180099,180546,180552,181314,184263,184268,2036,2037,2847,5070,16310,21384,22804,23895,25606,36473,36716,36717,39606,39608,39610,44842,55291,60510,65878,79456,85065,87676,96705,98766,98773,99547,101429,101430,101431,103140,103847,104785,107274,116146,119112,129403,130272,145714,145717,145718,145721,145722,145723,159350,170301,170302,170321,170322,176860,176881,178973,180446,180448,180456,180460,180461,180463,180464,180465,180469,180531,180532,338,2677,4772,6621,20633,31645,32066,32817,36310,36316,45949,47134,48406,54046,61137,61766,62490,62526,62944,63556,68595,70733,72928,76884,78080,79509,79522,80685,80726,84584,85921,86007,86080,86081,86533,86721,86885,86919,87236,87691,89451,89455,89668,89716,89719,91099,91204,94744,96752,97460,97470,97733,97866,97874,98759,100442,101362,101414,101416,101418,103136,103141,104098,106887,106895,106900,107030,107818,107819,109680,109868,110395,111003,112200,112205,112496,112659,112849,113122,113123,113851,113984,114008,114258,114262,114263,114369,114370,114374,114376,114377,114598,114745,115392,115804,115809,116424,116510,116511,116514,116559,116853,116885,116923,117006,117740,118797,118838,119434,119556,119683,120584,121782,122318,127946,127947,129252,130273,131170,131186,131464,131466,131482,131497,131715,132194,132997,133304,133787,133788,135009,135010,135663,136002,136617,136797,136940,136964,138514,140103,142203,142540,145593,145664,145675,145679,145693,147422,147423,149860,150220,152534,153601,154578,154846,155301,156917,158551,158557,158601,158726,162384,164440,170239,170242,170243,170254,170278,170286,170287,170288,170291,170320,170329,170332,170336,176904,176906,176909,176911,176912,176918,176921,176925,176926,176927,178773,178830,179275,179787,180442,180443,180486,180490,180502,180503,180512,180526,180543,180549,180554,180738,181174,181496,181915,183795,183903,184267,186141) [ RunTime:0.001099s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.000552s ]
SELECT * FROM `tp_goods_attr` WHERE `goods_id` IN (14559,35932,115368,120788,179826,179827,179836,179884,179885,179886,179887,179890,179935,179942,179943,179944,179953,179954,179955,179956,179957,179958,430,871,936,1082,1103,1343,2373,2376,2377,2512,2558,2623,2678,3388,4138,4457,4514,4516,4556,4816,4821,5054,5131,5174,5337,6149,6151,6152,6162,6493,6766,7026,7073,7074,7118,7908,13917,14162,16402,20928,20930,20954,21229,21728,22278,22528,26130,26375,26458,27897,30561,31893,32069,34150,36123,36311,36714,37022,37032,37033,44869,45961,47135,47333,54042,59851,59954,62190,62942,63130,63131,65144,65889,68375,76735,78641,79467,79469,80225,83462,85455,86058,86677,90919,91100,97471,97702,99568,99744,103469,104423,106869,106870,106883,106884,106885,107889,108113,110398,110692,110694,110695,111084,113971,114728,114884,114886,115386,115387,119566,121900,121901,129845,129846,131450,131451,131465,131477,131479,131480,133504,134419,135713,136079,136265,136408,139625,139789,142306,142307,143197,143479,143651,143818,145040,145056,145659,145662,146595,146760,146894,150832,154060,154845,155699,158550,159355,162348,166139,168818,170251,170264,170276,170280,170282,170331,170333,171898,174152,176886,176887,176888,176889,178774,180088,180498,180501,180514,180517,180524,180555,180558,180880,183792,184262,335,872,873,1117,1297,1298,1299,2274,2460,2585,2626,2627,2780,2903,3267,4137,4265,4596,4770,4792,4820,4930,5004,5101,5125,5144,5331,5460,5468,6166,6492,6495,6583,6625,6821,7027,7029,7191,7627,7835,7857,7954,8206,8244,13341,13421,13793,13916,14177,14304,14311,14554,14557,17701,18581,20886,20941,20945,20947,20953,21013,21326,21387,21783,21785,21793,22280,22946,23718,24576,24669,24808,24809,25284,25403,25507,25617,25716,25833,25936,26029,26136,26139,26630,27887,27888,27894,28088,28241,28243,29852,30024,30201,30552,30633,31016,31114,31376,31377,32070,32072,32074,32262,32286,32540,32565,32908,33000,33319,33334,34100,34834,35835,35840,36108,36318,36885,38770,38820,39613,43070,43074,43427,44901,45927,46888,46889,47177,56512,56522,56567,58728,60706,61139,61140,63128,65698,66564,66831,67130,68593,68594,72901,75658,75677,78639,78942,79195,79224,79237,79523,79526,79790,79798,80737,80830,80836,81100,83095,83938,85826,86073,86075,86076,86082,86083,86084,86097,86100,86497,86529,86531,86676,86873,86965,87003,87283,87468,87787,89449,89454,90260,90948,92138,94729,96292,97731,97862,101420,102724,104392,104393,106245,106874,106890,106891,106892,106893,106894,107598,108035,110173,110654,110829,111085,111086,113055,114016,114042,114366,114497,114746,115242,115597,115814,116630,116809,117445,117447,118199,118244,119668,119988,121048,122386,122387,123827,126132,127937,127938,127944,128179,130274,130514,130813,131452,131453,131455,131456,131472,131473,131475,131483,131484,131485,131496,131499,131505,132028,132072,132626,132779,134651,134913,135788,135987,136080,136409,136529,136530,138715,138942,139864,139875,140105,140330,140769,141187,141567,141812,142266,142463,144102,144772,145053,145059,145255,145676,145696,145698,146118,146888,149238,149241,149717,152807,154074,154478,157200,157201,157202,157269,157348,157847,159372,160722,162000,162526,164797,164810,166245,166485,169191,170053,170247,170248,170250,170252,170272,170290,170326,170330,170335,170340,170355,171530,173736,173777,176895,176896,176897,176898,176899,176901,176915,176924,176929,177203,178832,179846,179847,179966,180445,180492,180493,180495,180510,180522,180525,180541,180545,180548,180553,180559,180562,180563,180566,183437,183438,183793,183833,184261,2098,2269,2404,2979,2994,3065,3385,3409,4005,4139,4256,4374,4399,4519,4523,4605,5077,5252,5260,5295,5335,6000,6134,6767,6768,6769,7693,7694,10646,13959,16308,18274,18579,18580,20958,20959,21325,21798,21799,23719,23884,25504,26041,26378,26594,27895,28466,30437,30790,31000,31019,32706,32820,34097,34152,34835,35228,36476,37201,37453,38780,38853,44908,46657,46884,46886,47176,47187,57955,59191,59192,59577,61020,61021,61136,62420,62525,62943,65697,73616,79135,79214,79506,79846,79852,79926,80210,80827,83461,83846,86079,89728,91213,94749,96714,97732,97864,97869,98315,98772,100509,100582,101361,104382,105679,105787,106867,106868,106875,106882,106919,106921,107902,107912,111532,112204,112322,113058,115367,117232,117233,118719,119605,120796,121057,122574,127481,129385,129593,130291,130292,130294,131188,131476,131478,132978,135712,136534,139688,143650,143653,145061,145238,145663,145692,145703,145706,145725,145789,146887,149718,151044,152352,154375,154844,156278,158794,159201,159351,159352,162134,170277,170323,170342,170343,170347,176882,176883,176884,176885,176890,176891,177205,180101,180102,180103,180450,180452,180477,180479,180499,180513,180518,180556,180560,180564,180565,182994,183796,183881,184264,184265,184266,888,890,941,946,947,1176,2084,2397,2625,2673,2779,2984,3269,4222,4251,4252,4257,4263,4524,4603,4630,4631,4724,4733,4759,4760,4767,4793,4819,5108,5124,5141,5148,5167,5206,5219,5302,5333,5470,5726,6054,6059,6102,6115,6122,6133,6135,6146,6153,6161,6163,6205,6397,6491,6494,6626,6628,6822,7025,7095,7120,7121,7122,7799,7800,7915,8228,10642,11093,13900,14170,14312,14556,14561,14649,16020,16476,18010,18275,18706,18821,19083,19300,19301,20943,20944,20946,20951,20955,21298,21781,21784,22234,22662,23027,24189,24190,24569,24810,24892,24982,25017,25019,25232,25279,25280,25402,25724,26129,26314,26367,26377,26593,26629,26708,26860,27892,28076,28170,28237,28242,28416,28421,28854,29159,29463,29515,30023,30199,30560,30857,31058,31384,32065,32073,32119,32257,32439,32599,32708,32813,32814,32815,32816,32818,32888,32909,32942,32994,33318,33320,33342,33348,33520,33768,34103,34516,34944,35901,35925,35934,36064,36066,36086,36196,36319,36497,36498,36555,36682,36685,36707,36715,36780,36886,36951,36953,37119,37969,38211,38884,39614,39908,40495,40496,40880,40974,41201,41420,42938,42939,42943,42944,43026,43072,43073,43077,43418,43419,43420,44781,44782,44839,44870,44873,44874,44900,45641,45760,45761,45967,46782,46805,46885,46887,46894,46972,47054,47183,47298,47655,48409,54038,55231,56163,56551,56553,56554,56564,57984,59796,60410,61002,61764,62463,62945,62947,62973,62975,64485,65711,65712,65939,67129,68200,68534,69565,70708,70709,72681,72897,72905,72913,73193,73622,73625,73764,73860,74078,74404,75314,75563,75710,75752,76490,76512,76883,76885,76914,76916,78050,78084,78510,78640,79112,79125,79174,79217,79222,79230,79233,79239,79510,79521,79528,79530,79535,79537,79539,79543,79544,79547,79550,79558,79560,79561,79618,79848,79850,79927,79967,80197,80735,80740,80838,80844,80905,81072,84585,84586,84850,85115,85188,85422,85799,85923,85924,86008,86077,86078,86085,86087,86088,86089,86103,86107,86108,86109,86532,86678,86682,86889,86890,86959,86994,87599,87677,88367,88960,89448,89450,89456,89468,89562,89563,91094,91202,91214,91415,91729,92064,93974,94003,94172,94405,94783,96549,97705,97865,98318,98711,98912,99294,99846,99879,100254,101197,101216,101412,101413,101415,101419,103137,103138,103915,104380,104395,104397,106203,106679,106758,106802,106866,106871,106896,106898,106998,106999,107008,107011,107162,107232,107817,108115,108649,109116,109684,109865,109872,110591,111001,111002,111535,111536,111768,111914,112180,113032,113057,113830,113887,113970,113974,113986,113987,113988,113994,114015,114054,114119,114251,114344,114367,114368,114371,114372,114373,114375,114398,114424,114425,114434,114437,114619,114700,114716,115385,115388,115391,115759,115795,115797,115803,115805,115806,115807,115808,115977,116512,116629,116635,116811,116815,116854,116886,116924,116925,116926,116996,117004,117012,117250,117838,118410,118993,119113,119309,119310,119557,119564,119606,119921,120583,121039,121040,121056,121532,121533,121928,122078,122582,122584,125721,127945,129284,129420,129492,129592,130533,131185,131454,131457,131458,131459,131463,131474,131495,131498,131500,131501,131502,131503,131512,131966,132282,132625,132694,132695,132788,133786,134641,134642,135008,135662,135785,136001,136040,136207,136211,136614,136920,137343,138048,138875,138949,139044,139829,140817,142308,142549,142561,142620,142672,142818,143210,144341,144514,144520,144523,144525,145005,145590,145665,145668,145670,145672,145673,145674,145678,145690,145691,145694,145708,146066,146193,146891,147326,149239,149247,149255,149256,151300,152533,154075,154506,154590,154729,155283,156044,156282,157089,157345,157667,158554,160447,160448,161587,162039,162385,162525,163315,166801,167091,169048,170240,170241,170244,170245,170246,170255,170256,170257,170258,170259,170260,170263,170273,170274,170279,170281,170283,170285,170324,170325,170327,170328,170334,170753,170798,170974,173482,173490,175872,176426,176700,176892,176893,176894,176900,176902,176903,176905,176910,176913,176914,176916,176917,176919,176920,176922,176928,176930,177123,177204,177326,178829,179797,179845,180096,180439,180444,180476,180489,180491,180494,180496,180500,180504,180505,180506,180507,180508,180509,180511,180520,180521,180523,180528,180530,180540,180542,180544,180547,180550,180551,180557,180561,180902,181175,181176,181312,181528,182993,183790,183794,183939,877,878,965,966,967,1179,1183,1185,1286,1489,1618,1682,1698,2103,2344,2356,2358,2462,2574,2622,2658,2674,2841,2844,2982,3056,3071,3383,3399,3556,3986,4313,4364,4370,4420,4426,4795,4812,4837,4977,5107,5113,5118,5123,5130,5168,5208,5329,5410,6030,6031,6078,6754,6770,6771,7125,7126,7127,7128,7132,7133,7690,7797,8163,16362,21381,21383,21385,24931,25009,28920,29847,32047,32566,32567,32568,33779,34467,35218,35219,35220,35900,36091,36093,36094,36438,36452,36453,36454,36465,36467,36472,36874,36876,38854,38855,38880,38881,38882,40059,40061,40062,40500,43041,46025,46303,47053,47206,47207,48403,54041,56226,56227,56229,56565,56566,58727,60518,60707,60708,64192,64194,64196,65877,75635,75755,79452,79457,79462,85701,85800,85801,87984,88832,88833,88834,90261,90262,90263,91571,91573,92255,96367,96373,98767,98784,98792,98795,98796,98808,99454,99456,100588,101427,103845,104784,105793,108925,108927,108928,108932,109679,110693,111911,112640,112641,112949,112950,112951,113183,113576,113695,114754,115402,116719,126436,126603,129336,129401,129680,133464,133465,133466,134707,136245,145019,145027,145699,145702,145705,145713,145715,145716,147698,155698,158404,161935,166473,166474,168247,170289,170295,170296,170299,170303,170304,170310,170341,170344,170345,171425,173650,173651,176859,176861,176862,176863,176864,176865,176866,176867,176868,176869,176870,176871,176872,176873,176874,176875,176876,176877,176878,176879,176880,177126,179226,180447,180451,180453,180454,180455,180457,180458,180459,180462,180466,180467,180468,180470,180471,180472,180473,180474,180475,180478,180480,180481,180483,180484,180485,180487,180534,180535,180536,180537,180538,181532,183791,939,942,943,1293,1410,2562,2566,2991,3272,4253,4254,4255,4259,4260,4262,4561,4569,4577,4588,4590,4706,4755,4762,4935,5102,5176,5299,5300,5301,5304,5469,5725,13861,14046,18578,19797,20950,21423,21788,23739,24006,24568,24812,25401,25404,25618,25749,28238,28240,29435,29462,29574,29775,29776,30632,31007,31484,32363,32584,34101,34102,35229,36314,36684,36687,36775,36779,38775,38897,39815,40065,40542,43122,45968,46053,54044,66826,73627,77223,78932,79464,79532,79542,79548,79557,80847,88447,89729,94004,94005,97621,97703,97704,97734,98971,100698,101196,104418,106476,107084,107890,108116,112906,114593,115743,115792,115794,115796,116508,116509,116513,119989,127941,127942,128787,129285,129843,130548,130898,130904,133429,134242,135396,135733,135786,136917,136924,136958,136966,137329,140107,142536,142542,142653,142785,143483,144342,146274,151235,152989,153218,154579,155849,156460,158971,160613,160751,166093,166369,167757,169338,170253,170275,170292,173497,176520,176907,176923,180099,180546,180552,181314,184263,184268,2036,2037,2847,5070,16310,21384,22804,23895,25606,36473,36716,36717,39606,39608,39610,44842,55291,60510,65878,79456,85065,87676,96705,98766,98773,99547,101429,101430,101431,103140,103847,104785,107274,116146,119112,129403,130272,145714,145717,145718,145721,145722,145723,159350,170301,170302,170321,170322,176860,176881,178973,180446,180448,180456,180460,180461,180463,180464,180465,180469,180531,180532,338,2677,4772,6621,20633,31645,32066,32817,36310,36316,45949,47134,48406,54046,61137,61766,62490,62526,62944,63556,68595,70733,72928,76884,78080,79509,79522,80685,80726,84584,85921,86007,86080,86081,86533,86721,86885,86919,87236,87691,89451,89455,89668,89716,89719,91099,91204,94744,96752,97460,97470,97733,97866,97874,98759,100442,101362,101414,101416,101418,103136,103141,104098,106887,106895,106900,107030,107818,107819,109680,109868,110395,111003,112200,112205,112496,112659,112849,113122,113123,113851,113984,114008,114258,114262,114263,114369,114370,114374,114376,114377,114598,114745,115392,115804,115809,116424,116510,116511,116514,116559,116853,116885,116923,117006,117740,118797,118838,119434,119556,119683,120584,121782,122318,127946,127947,129252,130273,131170,131186,131464,131466,131482,131497,131715,132194,132997,133304,133787,133788,135009,135010,135663,136002,136617,136797,136940,136964,138514,140103,142203,142540,145593,145664,145675,145679,145693,147422,147423,149860,150220,152534,153601,154578,154846,155301,156917,158551,158557,158601,158726,162384,164440,170239,170242,170243,170254,170278,170286,170287,170288,170291,170320,170329,170332,170336,176904,176906,176909,176911,176912,176918,176921,176925,176926,176927,178773,178830,179275,179787,180442,180443,180486,180490,180502,180503,180512,180526,180543,180549,180554,180738,181174,181496,181915,183795,183903,184267,186141) AND `attr_value` <> '' [ RunTime:0.025650s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.000811s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.000174s ]
SELECT * FROM `tp_goods` WHERE `goods_id` IN (14559,35932,115368,120788,179826,179827,179836,179884,179885,179886,179887,179890,179935,179942,179943,179944,179953,179954,179955,179956,179957,179958,430,871,936,1082,1103,1343,2373,2376,2377,2512,2558,2623,2678,3388,4138,4457,4514,4516,4556,4816,4821,5054,5131,5174,5337,6149,6151,6152,6162,6493,6766,7026,7073,7074,7118,7908,13917,14162,16402,20928,20930,20954,21229,21728,22278,22528,26130,26375,26458,27897,30561,31893,32069,34150,36123,36311,36714,37022,37032,37033,44869,45961,47135,47333,54042,59851,59954,62190,62942,63130,63131,65144,65889,68375,76735,78641,79467,79469,80225,83462,85455,86058,86677,90919,91100,97471,97702,99568,99744,103469,104423,106869,106870,106883,106884,106885,107889,108113,110398,110692,110694,110695,111084,113971,114728,114884,114886,115386,115387,119566,121900,121901,129845,129846,131450,131451,131465,131477,131479,131480,133504,134419,135713,136079,136265,136408,139625,139789,142306,142307,143197,143479,143651,143818,145040,145056,145659,145662,146595,146760,146894,150832,154060,154845,155699,158550,159355,162348,166139,168818,170251,170264,170276,170280,170282,170331,170333,171898,174152,176886,176887,176888,176889,178774,180088,180498,180501,180514,180517,180524,180555,180558,180880,183792,184262,335,872,873,1117,1297,1298,1299,2274,2460,2585,2626,2627,2780,2903,3267,4137,4265,4596,4770,4792,4820,4930,5004,5101,5125,5144,5331,5460,5468,6166,6492,6495,6583,6625,6821,7027,7029,7191,7627,7835,7857,7954,8206,8244,13341,13421,13793,13916,14177,14304,14311,14554,14557,17701,18581,20886,20941,20945,20947,20953,21013,21326,21387,21783,21785,21793,22280,22946,23718,24576,24669,24808,24809,25284,25403,25507,25617,25716,25833,25936,26029,26136,26139,26630,27887,27888,27894,28088,28241,28243,29852,30024,30201,30552,30633,31016,31114,31376,31377,32070,32072,32074,32262,32286,32540,32565,32908,33000,33319,33334,34100,34834,35835,35840,36108,36318,36885,38770,38820,39613,43070,43074,43427,44901,45927,46888,46889,47177,56512,56522,56567,58728,60706,61139,61140,63128,65698,66564,66831,67130,68593,68594,72901,75658,75677,78639,78942,79195,79224,79237,79523,79526,79790,79798,80737,80830,80836,81100,83095,83938,85826,86073,86075,86076,86082,86083,86084,86097,86100,86497,86529,86531,86676,86873,86965,87003,87283,87468,87787,89449,89454,90260,90948,92138,94729,96292,97731,97862,101420,102724,104392,104393,106245,106874,106890,106891,106892,106893,106894,107598,108035,110173,110654,110829,111085,111086,113055,114016,114042,114366,114497,114746,115242,115597,115814,116630,116809,117445,117447,118199,118244,119668,119988,121048,122386,122387,123827,126132,127937,127938,127944,128179,130274,130514,130813,131452,131453,131455,131456,131472,131473,131475,131483,131484,131485,131496,131499,131505,132028,132072,132626,132779,134651,134913,135788,135987,136080,136409,136529,136530,138715,138942,139864,139875,140105,140330,140769,141187,141567,141812,142266,142463,144102,144772,145053,145059,145255,145676,145696,145698,146118,146888,149238,149241,149717,152807,154074,154478,157200,157201,157202,157269,157348,157847,159372,160722,162000,162526,164797,164810,166245,166485,169191,170053,170247,170248,170250,170252,170272,170290,170326,170330,170335,170340,170355,171530,173736,173777,176895,176896,176897,176898,176899,176901,176915,176924,176929,177203,178832,179846,179847,179966,180445,180492,180493,180495,180510,180522,180525,180541,180545,180548,180553,180559,180562,180563,180566,183437,183438,183793,183833,184261,2098,2269,2404,2979,2994,3065,3385,3409,4005,4139,4256,4374,4399,4519,4523,4605,5077,5252,5260,5295,5335,6000,6134,6767,6768,6769,7693,7694,10646,13959,16308,18274,18579,18580,20958,20959,21325,21798,21799,23719,23884,25504,26041,26378,26594,27895,28466,30437,30790,31000,31019,32706,32820,34097,34152,34835,35228,36476,37201,37453,38780,38853,44908,46657,46884,46886,47176,47187,57955,59191,59192,59577,61020,61021,61136,62420,62525,62943,65697,73616,79135,79214,79506,79846,79852,79926,80210,80827,83461,83846,86079,89728,91213,94749,96714,97732,97864,97869,98315,98772,100509,100582,101361,104382,105679,105787,106867,106868,106875,106882,106919,106921,107902,107912,111532,112204,112322,113058,115367,117232,117233,118719,119605,120796,121057,122574,127481,129385,129593,130291,130292,130294,131188,131476,131478,132978,135712,136534,139688,143650,143653,145061,145238,145663,145692,145703,145706,145725,145789,146887,149718,151044,152352,154375,154844,156278,158794,159201,159351,159352,162134,170277,170323,170342,170343,170347,176882,176883,176884,176885,176890,176891,177205,180101,180102,180103,180450,180452,180477,180479,180499,180513,180518,180556,180560,180564,180565,182994,183796,183881,184264,184265,184266,888,890,941,946,947,1176,2084,2397,2625,2673,2779,2984,3269,4222,4251,4252,4257,4263,4524,4603,4630,4631,4724,4733,4759,4760,4767,4793,4819,5108,5124,5141,5148,5167,5206,5219,5302,5333,5470,5726,6054,6059,6102,6115,6122,6133,6135,6146,6153,6161,6163,6205,6397,6491,6494,6626,6628,6822,7025,7095,7120,7121,7122,7799,7800,7915,8228,10642,11093,13900,14170,14312,14556,14561,14649,16020,16476,18010,18275,18706,18821,19083,19300,19301,20943,20944,20946,20951,20955,21298,21781,21784,22234,22662,23027,24189,24190,24569,24810,24892,24982,25017,25019,25232,25279,25280,25402,25724,26129,26314,26367,26377,26593,26629,26708,26860,27892,28076,28170,28237,28242,28416,28421,28854,29159,29463,29515,30023,30199,30560,30857,31058,31384,32065,32073,32119,32257,32439,32599,32708,32813,32814,32815,32816,32818,32888,32909,32942,32994,33318,33320,33342,33348,33520,33768,34103,34516,34944,35901,35925,35934,36064,36066,36086,36196,36319,36497,36498,36555,36682,36685,36707,36715,36780,36886,36951,36953,37119,37969,38211,38884,39614,39908,40495,40496,40880,40974,41201,41420,42938,42939,42943,42944,43026,43072,43073,43077,43418,43419,43420,44781,44782,44839,44870,44873,44874,44900,45641,45760,45761,45967,46782,46805,46885,46887,46894,46972,47054,47183,47298,47655,48409,54038,55231,56163,56551,56553,56554,56564,57984,59796,60410,61002,61764,62463,62945,62947,62973,62975,64485,65711,65712,65939,67129,68200,68534,69565,70708,70709,72681,72897,72905,72913,73193,73622,73625,73764,73860,74078,74404,75314,75563,75710,75752,76490,76512,76883,76885,76914,76916,78050,78084,78510,78640,79112,79125,79174,79217,79222,79230,79233,79239,79510,79521,79528,79530,79535,79537,79539,79543,79544,79547,79550,79558,79560,79561,79618,79848,79850,79927,79967,80197,80735,80740,80838,80844,80905,81072,84585,84586,84850,85115,85188,85422,85799,85923,85924,86008,86077,86078,86085,86087,86088,86089,86103,86107,86108,86109,86532,86678,86682,86889,86890,86959,86994,87599,87677,88367,88960,89448,89450,89456,89468,89562,89563,91094,91202,91214,91415,91729,92064,93974,94003,94172,94405,94783,96549,97705,97865,98318,98711,98912,99294,99846,99879,100254,101197,101216,101412,101413,101415,101419,103137,103138,103915,104380,104395,104397,106203,106679,106758,106802,106866,106871,106896,106898,106998,106999,107008,107011,107162,107232,107817,108115,108649,109116,109684,109865,109872,110591,111001,111002,111535,111536,111768,111914,112180,113032,113057,113830,113887,113970,113974,113986,113987,113988,113994,114015,114054,114119,114251,114344,114367,114368,114371,114372,114373,114375,114398,114424,114425,114434,114437,114619,114700,114716,115385,115388,115391,115759,115795,115797,115803,115805,115806,115807,115808,115977,116512,116629,116635,116811,116815,116854,116886,116924,116925,116926,116996,117004,117012,117250,117838,118410,118993,119113,119309,119310,119557,119564,119606,119921,120583,121039,121040,121056,121532,121533,121928,122078,122582,122584,125721,127945,129284,129420,129492,129592,130533,131185,131454,131457,131458,131459,131463,131474,131495,131498,131500,131501,131502,131503,131512,131966,132282,132625,132694,132695,132788,133786,134641,134642,135008,135662,135785,136001,136040,136207,136211,136614,136920,137343,138048,138875,138949,139044,139829,140817,142308,142549,142561,142620,142672,142818,143210,144341,144514,144520,144523,144525,145005,145590,145665,145668,145670,145672,145673,145674,145678,145690,145691,145694,145708,146066,146193,146891,147326,149239,149247,149255,149256,151300,152533,154075,154506,154590,154729,155283,156044,156282,157089,157345,157667,158554,160447,160448,161587,162039,162385,162525,163315,166801,167091,169048,170240,170241,170244,170245,170246,170255,170256,170257,170258,170259,170260,170263,170273,170274,170279,170281,170283,170285,170324,170325,170327,170328,170334,170753,170798,170974,173482,173490,175872,176426,176700,176892,176893,176894,176900,176902,176903,176905,176910,176913,176914,176916,176917,176919,176920,176922,176928,176930,177123,177204,177326,178829,179797,179845,180096,180439,180444,180476,180489,180491,180494,180496,180500,180504,180505,180506,180507,180508,180509,180511,180520,180521,180523,180528,180530,180540,180542,180544,180547,180550,180551,180557,180561,180902,181175,181176,181312,181528,182993,183790,183794,183939,877,878,965,966,967,1179,1183,1185,1286,1489,1618,1682,1698,2103,2344,2356,2358,2462,2574,2622,2658,2674,2841,2844,2982,3056,3071,3383,3399,3556,3986,4313,4364,4370,4420,4426,4795,4812,4837,4977,5107,5113,5118,5123,5130,5168,5208,5329,5410,6030,6031,6078,6754,6770,6771,7125,7126,7127,7128,7132,7133,7690,7797,8163,16362,21381,21383,21385,24931,25009,28920,29847,32047,32566,32567,32568,33779,34467,35218,35219,35220,35900,36091,36093,36094,36438,36452,36453,36454,36465,36467,36472,36874,36876,38854,38855,38880,38881,38882,40059,40061,40062,40500,43041,46025,46303,47053,47206,47207,48403,54041,56226,56227,56229,56565,56566,58727,60518,60707,60708,64192,64194,64196,65877,75635,75755,79452,79457,79462,85701,85800,85801,87984,88832,88833,88834,90261,90262,90263,91571,91573,92255,96367,96373,98767,98784,98792,98795,98796,98808,99454,99456,100588,101427,103845,104784,105793,108925,108927,108928,108932,109679,110693,111911,112640,112641,112949,112950,112951,113183,113576,113695,114754,115402,116719,126436,126603,129336,129401,129680,133464,133465,133466,134707,136245,145019,145027,145699,145702,145705,145713,145715,145716,147698,155698,158404,161935,166473,166474,168247,170289,170295,170296,170299,170303,170304,170310,170341,170344,170345,171425,173650,173651,176859,176861,176862,176863,176864,176865,176866,176867,176868,176869,176870,176871,176872,176873,176874,176875,176876,176877,176878,176879,176880,177126,179226,180447,180451,180453,180454,180455,180457,180458,180459,180462,180466,180467,180468,180470,180471,180472,180473,180474,180475,180478,180480,180481,180483,180484,180485,180487,180534,180535,180536,180537,180538,181532,183791,939,942,943,1293,1410,2562,2566,2991,3272,4253,4254,4255,4259,4260,4262,4561,4569,4577,4588,4590,4706,4755,4762,4935,5102,5176,5299,5300,5301,5304,5469,5725,13861,14046,18578,19797,20950,21423,21788,23739,24006,24568,24812,25401,25404,25618,25749,28238,28240,29435,29462,29574,29775,29776,30632,31007,31484,32363,32584,34101,34102,35229,36314,36684,36687,36775,36779,38775,38897,39815,40065,40542,43122,45968,46053,54044,66826,73627,77223,78932,79464,79532,79542,79548,79557,80847,88447,89729,94004,94005,97621,97703,97704,97734,98971,100698,101196,104418,106476,107084,107890,108116,112906,114593,115743,115792,115794,115796,116508,116509,116513,119989,127941,127942,128787,129285,129843,130548,130898,130904,133429,134242,135396,135733,135786,136917,136924,136958,136966,137329,140107,142536,142542,142653,142785,143483,144342,146274,151235,152989,153218,154579,155849,156460,158971,160613,160751,166093,166369,167757,169338,170253,170275,170292,173497,176520,176907,176923,180099,180546,180552,181314,184263,184268,2036,2037,2847,5070,16310,21384,22804,23895,25606,36473,36716,36717,39606,39608,39610,44842,55291,60510,65878,79456,85065,87676,96705,98766,98773,99547,101429,101430,101431,103140,103847,104785,107274,116146,119112,129403,130272,145714,145717,145718,145721,145722,145723,159350,170301,170302,170321,170322,176860,176881,178973,180446,180448,180456,180460,180461,180463,180464,180465,180469,180531,180532,338,2677,4772,6621,20633,31645,32066,32817,36310,36316,45949,47134,48406,54046,61137,61766,62490,62526,62944,63556,68595,70733,72928,76884,78080,79509,79522,80685,80726,84584,85921,86007,86080,86081,86533,86721,86885,86919,87236,87691,89451,89455,89668,89716,89719,91099,91204,94744,96752,97460,97470,97733,97866,97874,98759,100442,101362,101414,101416,101418,103136,103141,104098,106887,106895,106900,107030,107818,107819,109680,109868,110395,111003,112200,112205,112496,112659,112849,113122,113123,113851,113984,114008,114258,114262,114263,114369,114370,114374,114376,114377,114598,114745,115392,115804,115809,116424,116510,116511,116514,116559,116853,116885,116923,117006,117740,118797,118838,119434,119556,119683,120584,121782,122318,127946,127947,129252,130273,131170,131186,131464,131466,131482,131497,131715,132194,132997,133304,133787,133788,135009,135010,135663,136002,136617,136797,136940,136964,138514,140103,142203,142540,145593,145664,145675,145679,145693,147422,147423,149860,150220,152534,153601,154578,154846,155301,156917,158551,158557,158601,158726,162384,164440,170239,170242,170243,170254,170278,170286,170287,170288,170291,170320,170329,170332,170336,176904,176906,176909,176911,176912,176918,176921,176925,176926,176927,178773,178830,179275,179787,180442,180443,180486,180490,180502,180503,180512,180526,180543,180549,180554,180738,181174,181496,181915,183795,183903,184267,186141) ORDER BY `sort` ASC LIMIT 1300,20 [ RunTime:0.031752s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000900s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (126132,5301,86965,91573,119989,68534,5302,79798,145590,16310,28854,39606,181174,121782,7095,32439,106679,181175,118199,131512) [ RunTime:0.000377s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.000193s ]
SHOW FULL COLUMNS FROM `tp_ad_position` [ RunTime:0.000582s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000183s ]
SHOW FULL COLUMNS FROM `tp_ad` [ RunTime:0.000556s ]
SELECT * FROM `tp_ad` WHERE ( pid=101 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000176s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000146s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000159s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000158s ]
SELECT * FROM `tp_ad` WHERE ( pid=102 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000160s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000134s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000142s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000224s ]
SELECT * FROM `tp_ad` WHERE ( pid=103 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000217s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000173s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000161s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000161s ]
SELECT * FROM `tp_ad` WHERE ( pid=104 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000150s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000134s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000144s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000149s ]
SELECT * FROM `tp_ad` WHERE ( pid=105 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000143s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000137s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000139s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000149s ]
SELECT * FROM `tp_ad` WHERE ( pid=106 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000156s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000129s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000147s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000165s ]
SELECT * FROM `tp_ad` WHERE ( pid=107 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000169s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000141s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000151s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000159s ]
SELECT * FROM `tp_ad` WHERE ( pid=108 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000164s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000143s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000152s ]
SELECT * FROM `tp_navigation` where is_show = 1 and position = 'top' ORDER BY `sort` DESC [ RunTime:0.000165s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 590 LIMIT 1 [ RunTime:0.000174s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 1072 LIMIT 1 [ RunTime:0.000139s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 8138 LIMIT 1 [ RunTime:0.000138s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 17704 LIMIT 1 [ RunTime:0.000136s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 79502 LIMIT 1 [ RunTime:0.000132s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 126132 LIMIT 1 [ RunTime:0.000263s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 5301 LIMIT 1 [ RunTime:0.000210s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 86965 LIMIT 1 [ RunTime:0.000268s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 91573 LIMIT 1 [ RunTime:0.000203s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 119989 LIMIT 1 [ RunTime:0.000194s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 68534 LIMIT 1 [ RunTime:0.000199s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 5302 LIMIT 1 [ RunTime:0.000190s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 79798 LIMIT 1 [ RunTime:0.000183s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 145590 LIMIT 1 [ RunTime:0.000186s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 16310 LIMIT 1 [ RunTime:0.000191s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 28854 LIMIT 1 [ RunTime:0.000191s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 39606 LIMIT 1 [ RunTime:0.000178s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 181174 LIMIT 1 [ RunTime:0.000188s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 121782 LIMIT 1 [ RunTime:0.000184s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 7095 LIMIT 1 [ RunTime:0.000250s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32439 LIMIT 1 [ RunTime:0.000262s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 106679 LIMIT 1 [ RunTime:0.000377s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 181175 LIMIT 1 [ RunTime:0.000220s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 118199 LIMIT 1 [ RunTime:0.000215s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 131512 LIMIT 1 [ RunTime:0.000324s ]
select * from `tp_slogan` [ RunTime:0.000144s ]
select * from `tp_article` where cat_id = 1 and is_open=1 limit 5 [ RunTime:0.000184s ]
select * from `tp_article` where cat_id = 2 and is_open=1 limit 5 [ RunTime:0.000164s ]
select * from `tp_article` where cat_id = 3 and is_open=1 limit 5 [ RunTime:0.000161s ]
select * from `tp_article` where cat_id = 4 and is_open=1 limit 5 [ RunTime:0.000174s ]
select * from `tp_article` where cat_id = 5 and is_open=1 limit 5 [ RunTime:0.000160s ]
