SHOW FULL COLUMNS FROM `tp_wx_user` [ RunTime:0.001199s ]
SELECT * FROM `tp_wx_user` WHERE ( w_token = "xkopzw1490691329" ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000390s ]
SHOW FULL COLUMNS FROM `tp_search_word` [ RunTime:0.000782s ]
UPDATE `tp_search_word` SET `search_num` = `search_num` + 1 WHERE `keywords` = '美的' [ RunTime:0.002394s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.001120s ]
SELECT COUNT(*) AS think_count FROM `tp_goods` WHERE ( `goods_name` LIKE '%美的%' OR `keywords` LIKE '%美的%' ) AND `is_on_sale` = 1 [ RunTime:0.150362s ]
SELECT * FROM `tp_search_word` WHERE `keywords` = '美的' LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tp_search_word` SET `goods_num` = 2851 WHERE `id` = 9 [ RunTime:0.002412s ]
SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000776s ]
SELECT * FROM `tp_goods_category` WHERE `name` LIKE '%美的%' LIMIT 1 [ RunTime:0.000284s ]
SELECT `goods_id`,`cat_id` FROM `tp_goods` WHERE ( `goods_name` LIKE '%美的%' OR `keywords` LIKE '%美的%' ) AND `is_on_sale` = 1 AND `is_virtual` <> 2 [ RunTime:0.211254s ]
SELECT * FROM `tp_goods_category` WHERE `id` IN (380,789,592,593,595,594,605,379,606,608,659,609,611,612,615,617,618,619,623,624,641,640,642,373,639,374,607,345,588,634,635,382,647,381,343,372,672,696,697,603,636,621,596,712,597,610,591,589,788,614,784,0,598,346,770,344,704,620,783,376,377,613,764,600,796,768,798,375,797,771,673,799,852,651,759,780,803,725,731,726) [ RunTime:0.000515s ]
SELECT `goods_id` FROM `tp_goods` WHERE ( shop_price >= 0 and shop_price <= 1470 ) [ RunTime:0.166257s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (335,338,351,355,357,363,383,384,414,416,430,435,438,458,459,479,482,486,488,490,491,494,510,511,513,514,515,516,522,523,524,535,539,541,554,569,590,598,603,605,606,608,612,624,626,644,651,656,662,689,690,700,714,735,753,791,792,794,796,797,804,805,817,965,966,967,1059,1066,1068,1069,1070,1071,1072,1073,1117,1176,1286,1657,1682,1684,1685,1795,1796,1828,2036,2037,2064,2084,2131,2269,2274,2291,2333,2335,2351,2356,2413,2414,2512,2558,2559,2682,2834,2837,2951,2988,2994,2995,3025,3044,3048,3056,3059,3065,3071,3085,3102,3118,3124,3126,3140,3152,3155,3223,3227,3230,3234,3235,3246,3247,3248,3275,3278,3279,3290,3294,3302,3304,3330,3331,3340,3342,3347,3355,3356,3379,3380,3383,3399,3417,3426,3428,3431,3433,3436,3437,3441,3443,3450,3456,3494,3495,3503,3505,3529,3540,3556,3558,3579,3616,3617,3662,3696,3764,3780,3788,3793,3798,3815,3818,3821,3855,3856,3864,3892,3897,3904,3909,3913,3958,3959,3973,3986,4420,4426,4457,4653,4661,4669,4698,4707,4733,4792,4793,4795,4837,5096,5097,5102,5123,5125,5163,5165,5166,5204,5205,5208,5275,5415,5419,5420,5421,5428,5434,5440,5443,5448,5454,5468,5469,5470,5494,5503,5520,5525,5530,5547,5554,5803,5959,5963,5975,5979,5981,5983,5987,6000,6013,6030,6031,6056,6078,6159,6212,6245,6387,6441,6629,6638,6658,6665,6797,6807,6808,6813,6816,6824,6825,6826,6827,6834,6842,7178,7179,7497,7597,7604,7615,7620,7622,7624,7635,7637,7640,7649,7650,7651,8028,8033,8046,8244,8245,8246,8252,8258,8262,8264,8269,8662,10646,10649,11064,13824,13825,13891,13970,14120,14122,14170,14567,14628,15703,15708,15709,15740,15979,15992,16528,16530,16533,17670,17704,17852,18095,18411,18412,18553,18554,19169,19230,19311,19312,19416,19419,20678,20679,21320,21325,21326,21381,21383,21384,21385,21387,21425,21479,21963,21964,21969,22033,22040,22432,22436,22437,22438,22439,22440,22442,22443,22447,22448,22456,22457,22459,22461,22464,22465,22466,22478,22490,22501,22662,23062,23375,23407,23549,23550,23551,24021,24189,24190,24193,24194,24331,24343,24347,24348,24350,24351,24353,24355,24356,24357,24358,24366,24368,24369,24373,24456,24722,24743,24752,24755,24756,24757,24758,24892,25060,25359,25362,25366,25408,25617,26029,26041,26175,26176,26361,26367,26849,27498,27834,27846,28088,28459,28460,28505,28542,28546,28775,28864,28865,28866,28867,29057,29159,29493,29495,29516,29517,29527,30035,30070,30292,30384,30385,30435,30436,30731,30861,30862,30905,31067,31128,31142,31147,31157,31164,31198,31392,31393,31394,31943,32095,32256,32289,32565,32566,32567,32568,32604,32607,32920,33249,33257,33259,33354,33372,33481,33486,33501,33507,33520,33757,33758,33779,33802,33917,34022,34024,34075,34157,34376,34380,34520,34551,34658,34659,34807,34958,34997,35047,35400,35526,35527,35541,35577,35578,35579,35580,35581,35582,35583,35584,35585,35586,35587,35588,35590,35710,35902,36042,36054,36067,36135,36136,36140,36185,36196,36243,36256,36294,36295,36296,36297,36298,36299,36300,36301,36365,36366,36591,36592,36593,36643,36714,36716,36717,36868,36892,37022,37055,37637,37740,37743,37939,37941,37942,38112,38186,38187,38188,38192,38197,38198,38199,38561,38669,38853,38930,38944,38945,39301,39384,39387,39391,39393,39394,39396,39613,39614,39618,39658,39791,39797,39798,39800,39802,39805,39808,39811,39812,40136,40148,40152,40153,40169,40172,40174,40216,40219,40221,40222,40227,40228,40240,40242,40251,40258,40268,40501,40502,40893,40917,40923,40925,40928,40974,41240,41358,41420,42895,42898,42902,42905,43041,43212,43221,43236,43238,43251,43260,43315,43318,43319,43323,43325,43326,43327,43659,43663,43665,43722,44055,44300,44754,44755,44756,44757,44870,44874,44888,44987,44992,45672,45673,45760,45776,45777,45778,45871,45961,45967,45968,46348,46350,46351,46389,46404,46630,46637,46680,46681,46747,46749,46927,46972,47053,47187,47333,48395,54038,54041,54042,56163,56196,56200,56206,56207,56269,56272,56565,56566,56567,57099,57117,57872,57904,57938,57994,58185,58188,58193,58213,58238,58242,58249,58258,58267,58272,58279,58305,58393,58493,58494,58604,58605,58724,58728,58944,59426,59428,60634,60635,60696,60697,60878,61002,61030,61031,61132,62015,62027,62028,62101,62102,62173,62174,62175,62176,62177,62420,62942,62943,62944,62945,62947,63130,63131,64169,64185,64192,64194,64196,64597,64598,64606,64611,65321,65322,65518,65912,65950,65951,65955,65957,68394,69768,69771,69772,69788,72324,72856,72858,72863,72869,72871,73616,75314,75529,75635,75658,75682,75683,75684,75694,75707,76566,76881,76883,76884,76885,76903,78050,78080,78084,78153,78570,79195,79214,79217,79222,79224,79230,79233,79237,79239,79629,79632,79633,79635,79643,79644,79959,80197,80265,80594,80614,80615,80617,80618,80620,80621,80622,80623,80624,80631,80635,80636,80638,80640,80641,80644,80685,80701,80702,80726,81016,81100,82990,83914,83926,83927,83931,85456,85799,85800,85801,85829,85870,85873,85878,85879,85885,85888,85889,85890,85893,86060,86873,86897,86934,86938,86939,86944,86945,87003,87265,87269,87280,87284,87474,87476,87477,87478,87482,87487,87488,87489,87572,87573,87574,87576,87577,87578,88005,88283,88284,88343,88344,88807,88808,88810,88811,88832,88833,88834,88867,89451,89558,89565,89566,90260,90261,90262,90263,91071,91091,91413,91415,91571,91573,92138,92285,92288,92294,92301,92302,92303,92339,92351,92352,92355,93819,94172,94520,94522,94528,94619,94729,95464,95466,96470,96484,96489,96814,97145,97188,97189,97470,97471,97579,97779,97785,97788,98250,98388,98567,98569,98757,99016,99017,99109,99110,99111,99359,99695,99696,99793,99846,100509,100582,100588,100610,100614,100615,100698,100802,100803,100806,100857,100858,100914,101412,101413,101414,101415,101416,101418,101420,101427,101431,101444,101687,101911,102724,103137,103140,103141,103366,103369,103371,103372,103382,103383,103472,103769,103964,103965,103968,103969,103970,103971,103979,103980,103981,104017,104350,104356,104359,104362,104773,104775,104777,105688,105710,105769,105966,105970,106203,106273,106517,106561,106679,106803,106820,106825,106826,106911,107025,107413,107584,107586,107618,107889,107890,107942,107944,107973,108028,108101,108108,108220,108233,108332,108333,108375,108482,108489,108490,108497,108499,108500,108501,108502,108570,108571,108572,108573,108574,108575,108576,108577,108578,108579,108584,108585,108586,108587,108588,108589,108590,108597,108598,108599,108602,108603,108604,108605,108609,108610,108611,108612,108613,108654,108664,108698,108873,108875,108876,108884,108888,108940,109159,109160,109252,109256,109258,109259,109260,109261,109262,109313,109423,109540,109604,109652,109680,109684,109859,109884,109885,109886,110263,110264,110265,110267,110344,110395,110398,110410,110411,110412,110500,110512,110513,110590,110591,110634,110791,110792,110793,110848,111052,111054,111084,111085,111086,111103,111207,111543,111723,111816,111914,111939,111940,111986,111987,112253,112261,112262,112264,112265,112268,112322,112440,112441,112442,112446,112447,112563,112599,112600,112640,112641,112695,112906,113110,113115,113116,113196,113253,113460,113695,113736,113769,113845,113985,113994,114016,114034,114063,114073,114241,114242,114342,114598,114745,114818,114821,114880,114884,114985,115215,115216,115217,115218,115302,115304,115305,115306,115307,115308,115310,115311,115313,115314,115372,115373,115374,115376,115377,115378,115380,115385,115386,115561,115562,115563,115726,115977,116275,116450,116719,116929,116939,116951,116952,116954,116955,117240,117321,117740,117921,117930,117953,118250,118479,118838,118939,119202,119241,119288,119293,119294,119300,119301,119304,119305,119310,119344,119467,119503,119556,119683,119685,119686,119687,119785,119798,119806,119807,119808,120001,120014,120553,120555,120557,120558,120559,120583,120584,120587,120593,120595,120596,120597,120935,121821,121912,121914,121934,122135,122156,122164,122166,122176,122184,122186,122460,122486,122487,122489,123031,123432,123462,123622,123678,123679,123680,123686,123699,123704,123826,123888,123964,124343,125096,125111,125155,125189,125272,125397,125433,125434,125470,126144,126232,126233,126239,126262,126263,126268,126436,126586,126648,127091,127092,127265,127290,127292,128473,129220,129252,129263,129421,129423,129424,129432,129433,129436,129453,129586,129587,129624,130089,130847,130853,130921,130922,130927,130930,130936,130944,130945,130957,130963,130964,131137,131138,131281,131419,131428,131465,131547,131548,131715,131718,131719,131859,131860,131909,132121,132194,132199,132282,132398,132573,132928,132930,132932,133047,133304,133464,133465,133466,133519,133550,133571,133776,134403,134419,134432,134518,134651,134710,134759,134761,134762,134763,134764,134766,134913,134960,135008,135009,135396,135638,135639,135661,135662,135663,135782,135785,135786,135788,135892,135909,135967,135969,135970,135971,135974,135975,135976,135977,135978,135979,135981,135982,136078,136090,136245,136265,136386,136408,136409,136427,137216,137217,137221,137223,137229,137233,137249,137297,137369,138034,138048,138238,138239,138461,138698,138699,138774,138791,139104,139109,139110,139202,139203,139204,139205,139206,139207,139380,139470,139473,139480,139550,139560,139626,139627,139646,139648,139650,139652,139654,139655,139656,139657,139661,139667,139685,139688,139788,139789,139865,139868,139869,139876,139877,140252,140278,140284,140292,140295,140301,140308,140316,140641,140809,141098,141473,141772,142272,142308,142646,142741,142754,142755,142854,142871,142972,143104,143105,143106,143107,143168,143210,143561,143568,143678,143762,143837,144016,144017,144018,144020,144030,144031,144032,144099,144100,144104,144210,144211,144213,144341,144342,144517,144979,144980,145071,145138,145153,145154,145161,145162,145340,145547,145606,145675,145676,145678,145679,145696,145713,145714,145715,145716,145717,145721,145722,145723,146087,146118,146136,146137,146146,146193,146314,146383,146560,147226,147230,147231,147232,147291,147328,147334,147335,147336,147337,147374,147390,147396,147422,147658,147659,147661,147664,147666,147684,148003,148014,148257,148258,149188,150262,150267,151197,151298,151300,151506,151507,151673,151675,151681,151682,151683,151685,151688,151691,151695,151696,151697,151698,151699,151782,151785,151786,151789,152146,152148,152151,152152,152153,152154,152631,152986,153218,153288,153289,153348,153999,154002,154060,154074,154075,154308,154375,154865,155093,155264,155265,155307,155308,155579,155584,155629,155630,155698,155699,155777,155824,155874,155933,155936,155944,156022,156063,156064,156066,156154,156280,156458,156459,156838,156880,156883,156891,156905,156945,157269,157540,157555,157569,157585,157613,157618,158139,158159,158161,158162,158163,158404,158542,158543,158588,158730,158769,158794,158802,158976,158985,159200,159201,159343,159344,159674,159675,160053,160054,160063,160121,160253,160255,160256,160258,160259,160260,160261,160262,160263,160265,160266,160267,160291,160292,160295,160300,160301,160303,160304,160305,160306,160307,160308,160310,160316,160317,160318,160319,160322,160323,160326,160328,160329,160330,160331,160333,160334,160335,160337,160349,160350,160351,160352,160357,160427,160502,160503,160506,160507,160508,160530,160615,160623,160666,160667,160698,160700,161863,161884,161959,161974,162025,162026,162028,162029,162134,162135,162319,162323,162333,162348,162384,162524,162525,162526,163178,163211,163241,163257,163275,163280,163303,163987,164324,164421,164423,164477,164505,164506,164528,164540,164883,164885,164888,164889,164890,164891,164892,164893,164895,164896,164898,164899,164900,164901,164902,164903,164905,164907,164908,164909,164910,164911,164912,164914,164915,164916,164917,164919,164920,164921,164922,164923,164924,164925,164926,164927,164928,164929,164930,164931,164932,164933,164934,164935,164946,164947,164948,164977,165742,166037,166101,166245,166415,166416,166417,166418,166419,166420,166421,166423,166424,166473,166474,166740,166894,166938,166939,166940,166941,166942,166943,166944,166945,166946,166947,166949,166950,166951,166952,166953,166954,166955,166956,166957,166958,166959,166961,166962,166964,166965,166966,166969,166970,166971,166972,166973,166974,167056,167350,167732,167900,168096,168174,168175,168176,168177,168178,168179,168181,168182,168185,168186,168187,168188,168189,168190,168191,168192,168193,168194,168195,168196,168198,168200,168201,168202,168204,168205,168206,168207,168209,168211,168212,168214,168223,168456,168457,168458,168464,168465,168466,168467,168468,168470,168472,168479,168480,168482,168483,168484,168485,168486,168487,168488,168489,168490,168491,168492,168493,168494,168495,168496,168497,168517,168561,168569,168607,168612,168713,168714,168715,168716,168717,168718,168719,168720,168721,168722,168723,168725,168810,168840,168871,168873,168904,168907,168950,169013,169205,169313,169345,169346,169347,169372,169373,170175,170228,170239,170240,170241,170242,170243,170244,170245,170246,170247,170248,170250,170251,170252,170256,170257,170258,170259,170272,170273,170274,170275,170276,170277,170278,170279,170280,170281,170282,170283,170285,170286,170287,170288,170289,170290,170291,170292,170295,170296,170297,170299,170301,170302,170303,170304,170310,170320,170321,170322,170323,170324,170325,170326,170327,170328,170329,170330,170331,170332,170333,170334,170335,170336,170340,170341,170342,170343,170344,170345,170346,170347,170355,170696,170745,170872,170905,170915,170986,170991,171008,171016,171019,171020,171022,171024,171038,171039,171040,171054,171058,171064,171168,171293,171310,171350,171358,171371,171377,171378,171379,171380,171381,171530,171603,171785,171786,171787,171859,171862,171981,171982,172062,172063,172332,172472,172740,172741,172956,173477,173482,173490,173497,173626,173672,173713,173965,173966,173967,174084,174176,174314,174336,174384,174385,174386,174387,174388,174389,174390,174391,174392,174393,174394,174395,174396,174397,174444,174450,174463,174464,174465,174466,174467,174468,174469,174470,174471,174477,174483,174550,174551,174552,174645,174646,174666,174667,174705,174892,174950,175108,175111,175112,175113,175114,175116,175117,175119,175121,175275,175582,175658,175661,175663,175858,175867,176301,176307,176311,176426,176521,176559,176589,176593,176594,176603,176608,176651,176654,176663,176673,176677,176859,176860,176861,176862,176863,176864,176865,176866,176867,176868,176872,176873,176874,176875,176876,176877,176878,176879,176880,176881,176882,176883,176884,176885,176886,176887,176888,176889,176890,176891,176931,176935,176936,176937,176938,176939,176940,176941,176942,176943,176944,176945,176946,176947,176948,176949,176950,176951,176952,176953,176955,176956,176957,176958,176959,176960,176961,176962,176963,176964,176965,176966,176967,176968,176969,176970,176971,176972,176973,176974,176975,176977,176992,176993,176994,176995,176997,176999,177000,177001,177002,177003,177004,177030,177031,177032,177033,177034,177035,177036,177037,177038,177039,177040,177041,177044,177045,177065,177066,177067,177068,177069,177082,177083,177085,177086,177087,177088,177089,177090,177091,177092,177093,177094,177095,177096,177097,177098,177099,177100,177101,177102,177103,177104,177106,177107,177123,177126,177128,177130,177131,177177,177178,177179,177188,177189,177201,177203,177204,177205,177390,177611,177789,177802,177803,177817,178338,178339,178341,178625,178626,178628,178690,178829,178830,178832,178845,178857,178973,179014,179015,179018,179019,179020,179021,179147,179150,179196,179197,179204,179275,179312,179313,179549,179550,179848,179850,179853,179960,179962,179966,180069,180075,180151,180167,180172,180289,180291,180448,180451,180453,180454,180455,180457,180458,180459,180462,180466,180467,180468,180470,180498,180499,180532,180534,180535,180537,180538,180555,180644,180738,180756,180757,180822,180823,180824,180825,180826,180907,181092,181094,181099,181100,181101,181105,181106,181107,181108,181109,181110,181112,181113,181431,181432,181433,181565,182379,182436,182437,182438,182439,182440,182441,182442,182443,182444,182515,182526,182555,182557,182578,182744,182780,183124,183627,183642,183695,183790,183793,183794,183795,183833,184448,184451,184452,185003,185004,185012,186037,186039,186106,186108,186112,186113,186114,186115,186116,186117,186131,186132,186141,186142,186273) AND `brand_id` > 0 [ RunTime:0.045618s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.001032s ]
SELECT * FROM `tp_brand` WHERE `id` IN (43,63,50,52,75,42,18,230,22,51,49,84,207,189,115,93,224,27,262,236,126,307,139,65,76) LIMIT 30 [ RunTime:0.000270s ]
SELECT * FROM `tp_goods` WHERE `is_on_sale` = 1 AND `goods_id` IN (335,338,351,355,357,363,383,384,414,416,430,435,438,458,459,479,482,486,488,490,491,494,510,511,513,514,515,516,522,523,524,535,539,541,554,569,590,598,603,605,606,608,612,624,626,644,651,656,662,689,690,700,714,735,753,791,792,794,796,797,804,805,817,965,966,967,1059,1066,1068,1069,1070,1071,1072,1073,1117,1176,1286,1657,1682,1684,1685,1795,1796,1828,2036,2037,2064,2084,2131,2269,2274,2291,2333,2335,2351,2356,2413,2414,2512,2558,2559,2682,2834,2837,2951,2988,2994,2995,3025,3044,3048,3056,3059,3065,3071,3085,3102,3118,3124,3126,3140,3152,3155,3223,3227,3230,3234,3235,3246,3247,3248,3275,3278,3279,3290,3294,3302,3304,3330,3331,3340,3342,3347,3355,3356,3379,3380,3383,3399,3417,3426,3428,3431,3433,3436,3437,3441,3443,3450,3456,3494,3495,3503,3505,3529,3540,3556,3558,3579,3616,3617,3662,3696,3764,3780,3788,3793,3798,3815,3818,3821,3855,3856,3864,3892,3897,3904,3909,3913,3958,3959,3973,3986,4420,4426,4457,4653,4661,4669,4698,4707,4733,4792,4793,4795,4837,5096,5097,5102,5123,5125,5163,5165,5166,5204,5205,5208,5275,5415,5419,5420,5421,5428,5434,5440,5443,5448,5454,5468,5469,5470,5494,5503,5520,5525,5530,5547,5554,5803,5959,5963,5975,5979,5981,5983,5987,6000,6013,6030,6031,6056,6078,6159,6212,6245,6387,6441,6629,6638,6658,6665,6797,6807,6808,6813,6816,6824,6825,6826,6827,6834,6842,7178,7179,7497,7597,7604,7615,7620,7622,7624,7635,7637,7640,7649,7650,7651,8028,8033,8046,8244,8245,8246,8252,8258,8262,8264,8269,8662,10646,10649,11064,13824,13825,13891,13970,14120,14122,14170,14567,14628,15703,15708,15709,15740,15979,15992,16528,16530,16533,17670,17704,17852,18095,18411,18412,18553,18554,19169,19230,19311,19312,19416,19419,20678,20679,21320,21325,21326,21381,21383,21384,21385,21387,21425,21479,21963,21964,21969,22033,22040,22432,22436,22437,22438,22439,22440,22442,22443,22447,22448,22456,22457,22459,22461,22464,22465,22466,22478,22490,22501,22662,23062,23375,23407,23549,23550,23551,24021,24189,24190,24193,24194,24331,24343,24347,24348,24350,24351,24353,24355,24356,24357,24358,24366,24368,24369,24373,24456,24722,24743,24752,24755,24756,24757,24758,24892,25060,25359,25362,25366,25408,25617,26029,26041,26175,26176,26361,26367,26849,27498,27834,27846,28088,28459,28460,28505,28542,28546,28775,28864,28865,28866,28867,29057,29159,29493,29495,29516,29517,29527,30035,30070,30292,30384,30385,30435,30436,30731,30861,30862,30905,31067,31128,31142,31147,31157,31164,31198,31392,31393,31394,31943,32095,32256,32289,32565,32566,32567,32568,32604,32607,32920,33249,33257,33259,33354,33372,33481,33486,33501,33507,33520,33757,33758,33779,33802,33917,34022,34024,34075,34157,34376,34380,34520,34551,34658,34659,34807,34958,34997,35047,35400,35526,35527,35541,35577,35578,35579,35580,35581,35582,35583,35584,35585,35586,35587,35588,35590,35710,35902,36042,36054,36067,36135,36136,36140,36185,36196,36243,36256,36294,36295,36296,36297,36298,36299,36300,36301,36365,36366,36591,36592,36593,36643,36714,36716,36717,36868,36892,37022,37055,37637,37740,37743,37939,37941,37942,38112,38186,38187,38188,38192,38197,38198,38199,38561,38669,38853,38930,38944,38945,39301,39384,39387,39391,39393,39394,39396,39613,39614,39618,39658,39791,39797,39798,39800,39802,39805,39808,39811,39812,40136,40148,40152,40153,40169,40172,40174,40216,40219,40221,40222,40227,40228,40240,40242,40251,40258,40268,40501,40502,40893,40917,40923,40925,40928,40974,41240,41358,41420,42895,42898,42902,42905,43041,43212,43221,43236,43238,43251,43260,43315,43318,43319,43323,43325,43326,43327,43659,43663,43665,43722,44055,44300,44754,44755,44756,44757,44870,44874,44888,44987,44992,45672,45673,45760,45776,45777,45778,45871,45961,45967,45968,46348,46350,46351,46389,46404,46630,46637,46680,46681,46747,46749,46927,46972,47053,47187,47333,48395,54038,54041,54042,56163,56196,56200,56206,56207,56269,56272,56565,56566,56567,57099,57117,57872,57904,57938,57994,58185,58188,58193,58213,58238,58242,58249,58258,58267,58272,58279,58305,58393,58493,58494,58604,58605,58724,58728,58944,59426,59428,60634,60635,60696,60697,60878,61002,61030,61031,61132,62015,62027,62028,62101,62102,62173,62174,62175,62176,62177,62420,62942,62943,62944,62945,62947,63130,63131,64169,64185,64192,64194,64196,64597,64598,64606,64611,65321,65322,65518,65912,65950,65951,65955,65957,68394,69768,69771,69772,69788,72324,72856,72858,72863,72869,72871,73616,75314,75529,75635,75658,75682,75683,75684,75694,75707,76566,76881,76883,76884,76885,76903,78050,78080,78084,78153,78570,79195,79214,79217,79222,79224,79230,79233,79237,79239,79629,79632,79633,79635,79643,79644,79959,80197,80265,80594,80614,80615,80617,80618,80620,80621,80622,80623,80624,80631,80635,80636,80638,80640,80641,80644,80685,80701,80702,80726,81016,81100,82990,83914,83926,83927,83931,85456,85799,85800,85801,85829,85870,85873,85878,85879,85885,85888,85889,85890,85893,86060,86873,86897,86934,86938,86939,86944,86945,87003,87265,87269,87280,87284,87474,87476,87477,87478,87482,87487,87488,87489,87572,87573,87574,87576,87577,87578,88005,88283,88284,88343,88344,88807,88808,88810,88811,88832,88833,88834,88867,89451,89558,89565,89566,90260,90261,90262,90263,91071,91091,91413,91415,91571,91573,92138,92285,92288,92294,92301,92302,92303,92339,92351,92352,92355,93819,94172,94520,94522,94528,94619,94729,95464,95466,96470,96484,96489,96814,97145,97188,97189,97470,97471,97579,97779,97785,97788,98250,98388,98567,98569,98757,99016,99017,99109,99110,99111,99359,99695,99696,99793,99846,100509,100582,100588,100610,100614,100615,100698,100802,100803,100806,100857,100858,100914,101412,101413,101414,101415,101416,101418,101420,101427,101431,101444,101687,101911,102724,103137,103140,103141,103366,103369,103371,103372,103382,103383,103472,103769,103964,103965,103968,103969,103970,103971,103979,103980,103981,104017,104350,104356,104359,104362,104773,104775,104777,105688,105710,105769,105966,105970,106203,106273,106517,106561,106679,106803,106820,106825,106826,106911,107025,107413,107584,107586,107618,107889,107890,107942,107944,107973,108028,108101,108108,108220,108233,108332,108333,108375,108482,108489,108490,108497,108499,108500,108501,108502,108570,108571,108572,108573,108574,108575,108576,108577,108578,108579,108584,108585,108586,108587,108588,108589,108590,108597,108598,108599,108602,108603,108604,108605,108609,108610,108611,108612,108613,108654,108664,108698,108873,108875,108876,108884,108888,108940,109159,109160,109252,109256,109258,109259,109260,109261,109262,109313,109423,109540,109604,109652,109680,109684,109859,109884,109885,109886,110263,110264,110265,110267,110344,110395,110398,110410,110411,110412,110500,110512,110513,110590,110591,110634,110791,110792,110793,110848,111052,111054,111084,111085,111086,111103,111207,111543,111723,111816,111914,111939,111940,111986,111987,112253,112261,112262,112264,112265,112268,112322,112440,112441,112442,112446,112447,112563,112599,112600,112640,112641,112695,112906,113110,113115,113116,113196,113253,113460,113695,113736,113769,113845,113985,113994,114016,114034,114063,114073,114241,114242,114342,114598,114745,114818,114821,114880,114884,114985,115215,115216,115217,115218,115302,115304,115305,115306,115307,115308,115310,115311,115313,115314,115372,115373,115374,115376,115377,115378,115380,115385,115386,115561,115562,115563,115726,115977,116275,116450,116719,116929,116939,116951,116952,116954,116955,117240,117321,117740,117921,117930,117953,118250,118479,118838,118939,119202,119241,119288,119293,119294,119300,119301,119304,119305,119310,119344,119467,119503,119556,119683,119685,119686,119687,119785,119798,119806,119807,119808,120001,120014,120553,120555,120557,120558,120559,120583,120584,120587,120593,120595,120596,120597,120935,121821,121912,121914,121934,122135,122156,122164,122166,122176,122184,122186,122460,122486,122487,122489,123031,123432,123462,123622,123678,123679,123680,123686,123699,123704,123826,123888,123964,124343,125096,125111,125155,125189,125272,125397,125433,125434,125470,126144,126232,126233,126239,126262,126263,126268,126436,126586,126648,127091,127092,127265,127290,127292,128473,129220,129252,129263,129421,129423,129424,129432,129433,129436,129453,129586,129587,129624,130089,130847,130853,130921,130922,130927,130930,130936,130944,130945,130957,130963,130964,131137,131138,131281,131419,131428,131465,131547,131548,131715,131718,131719,131859,131860,131909,132121,132194,132199,132282,132398,132573,132928,132930,132932,133047,133304,133464,133465,133466,133519,133550,133571,133776,134403,134419,134432,134518,134651,134710,134759,134761,134762,134763,134764,134766,134913,134960,135008,135009,135396,135638,135639,135661,135662,135663,135782,135785,135786,135788,135892,135909,135967,135969,135970,135971,135974,135975,135976,135977,135978,135979,135981,135982,136078,136090,136245,136265,136386,136408,136409,136427,137216,137217,137221,137223,137229,137233,137249,137297,137369,138034,138048,138238,138239,138461,138698,138699,138774,138791,139104,139109,139110,139202,139203,139204,139205,139206,139207,139380,139470,139473,139480,139550,139560,139626,139627,139646,139648,139650,139652,139654,139655,139656,139657,139661,139667,139685,139688,139788,139789,139865,139868,139869,139876,139877,140252,140278,140284,140292,140295,140301,140308,140316,140641,140809,141098,141473,141772,142272,142308,142646,142741,142754,142755,142854,142871,142972,143104,143105,143106,143107,143168,143210,143561,143568,143678,143762,143837,144016,144017,144018,144020,144030,144031,144032,144099,144100,144104,144210,144211,144213,144341,144342,144517,144979,144980,145071,145138,145153,145154,145161,145162,145340,145547,145606,145675,145676,145678,145679,145696,145713,145714,145715,145716,145717,145721,145722,145723,146087,146118,146136,146137,146146,146193,146314,146383,146560,147226,147230,147231,147232,147291,147328,147334,147335,147336,147337,147374,147390,147396,147422,147658,147659,147661,147664,147666,147684,148003,148014,148257,148258,149188,150262,150267,151197,151298,151300,151506,151507,151673,151675,151681,151682,151683,151685,151688,151691,151695,151696,151697,151698,151699,151782,151785,151786,151789,152146,152148,152151,152152,152153,152154,152631,152986,153218,153288,153289,153348,153999,154002,154060,154074,154075,154308,154375,154865,155093,155264,155265,155307,155308,155579,155584,155629,155630,155698,155699,155777,155824,155874,155933,155936,155944,156022,156063,156064,156066,156154,156280,156458,156459,156838,156880,156883,156891,156905,156945,157269,157540,157555,157569,157585,157613,157618,158139,158159,158161,158162,158163,158404,158542,158543,158588,158730,158769,158794,158802,158976,158985,159200,159201,159343,159344,159674,159675,160053,160054,160063,160121,160253,160255,160256,160258,160259,160260,160261,160262,160263,160265,160266,160267,160291,160292,160295,160300,160301,160303,160304,160305,160306,160307,160308,160310,160316,160317,160318,160319,160322,160323,160326,160328,160329,160330,160331,160333,160334,160335,160337,160349,160350,160351,160352,160357,160427,160502,160503,160506,160507,160508,160530,160615,160623,160666,160667,160698,160700,161863,161884,161959,161974,162025,162026,162028,162029,162134,162135,162319,162323,162333,162348,162384,162524,162525,162526,163178,163211,163241,163257,163275,163280,163303,163987,164324,164421,164423,164477,164505,164506,164528,164540,164883,164885,164888,164889,164890,164891,164892,164893,164895,164896,164898,164899,164900,164901,164902,164903,164905,164907,164908,164909,164910,164911,164912,164914,164915,164916,164917,164919,164920,164921,164922,164923,164924,164925,164926,164927,164928,164929,164930,164931,164932,164933,164934,164935,164946,164947,164948,164977,165742,166037,166101,166245,166415,166416,166417,166418,166419,166420,166421,166423,166424,166473,166474,166740,166894,166938,166939,166940,166941,166942,166943,166944,166945,166946,166947,166949,166950,166951,166952,166953,166954,166955,166956,166957,166958,166959,166961,166962,166964,166965,166966,166969,166970,166971,166972,166973,166974,167056,167350,167732,167900,168096,168174,168175,168176,168177,168178,168179,168181,168182,168185,168186,168187,168188,168189,168190,168191,168192,168193,168194,168195,168196,168198,168200,168201,168202,168204,168205,168206,168207,168209,168211,168212,168214,168223,168456,168457,168458,168464,168465,168466,168467,168468,168470,168472,168479,168480,168482,168483,168484,168485,168486,168487,168488,168489,168490,168491,168492,168493,168494,168495,168496,168497,168517,168561,168569,168607,168612,168713,168714,168715,168716,168717,168718,168719,168720,168721,168722,168723,168725,168810,168840,168871,168873,168904,168907,168950,169013,169205,169313,169345,169346,169347,169372,169373,170175,170228,170239,170240,170241,170242,170243,170244,170245,170246,170247,170248,170250,170251,170252,170256,170257,170258,170259,170272,170273,170274,170275,170276,170277,170278,170279,170280,170281,170282,170283,170285,170286,170287,170288,170289,170290,170291,170292,170295,170296,170297,170299,170301,170302,170303,170304,170310,170320,170321,170322,170323,170324,170325,170326,170327,170328,170329,170330,170331,170332,170333,170334,170335,170336,170340,170341,170342,170343,170344,170345,170346,170347,170355,170696,170745,170872,170905,170915,170986,170991,171008,171016,171019,171020,171022,171024,171038,171039,171040,171054,171058,171064,171168,171293,171310,171350,171358,171371,171377,171378,171379,171380,171381,171530,171603,171785,171786,171787,171859,171862,171981,171982,172062,172063,172332,172472,172740,172741,172956,173477,173482,173490,173497,173626,173672,173713,173965,173966,173967,174084,174176,174314,174336,174384,174385,174386,174387,174388,174389,174390,174391,174392,174393,174394,174395,174396,174397,174444,174450,174463,174464,174465,174466,174467,174468,174469,174470,174471,174477,174483,174550,174551,174552,174645,174646,174666,174667,174705,174892,174950,175108,175111,175112,175113,175114,175116,175117,175119,175121,175275,175582,175658,175661,175663,175858,175867,176301,176307,176311,176426,176521,176559,176589,176593,176594,176603,176608,176651,176654,176663,176673,176677,176859,176860,176861,176862,176863,176864,176865,176866,176867,176868,176872,176873,176874,176875,176876,176877,176878,176879,176880,176881,176882,176883,176884,176885,176886,176887,176888,176889,176890,176891,176931,176935,176936,176937,176938,176939,176940,176941,176942,176943,176944,176945,176946,176947,176948,176949,176950,176951,176952,176953,176955,176956,176957,176958,176959,176960,176961,176962,176963,176964,176965,176966,176967,176968,176969,176970,176971,176972,176973,176974,176975,176977,176992,176993,176994,176995,176997,176999,177000,177001,177002,177003,177004,177030,177031,177032,177033,177034,177035,177036,177037,177038,177039,177040,177041,177044,177045,177065,177066,177067,177068,177069,177082,177083,177085,177086,177087,177088,177089,177090,177091,177092,177093,177094,177095,177096,177097,177098,177099,177100,177101,177102,177103,177104,177106,177107,177123,177126,177128,177130,177131,177177,177178,177179,177188,177189,177201,177203,177204,177205,177390,177611,177789,177802,177803,177817,178338,178339,178341,178625,178626,178628,178690,178829,178830,178832,178845,178857,178973,179014,179015,179018,179019,179020,179021,179147,179150,179196,179197,179204,179275,179312,179313,179549,179550,179848,179850,179853,179960,179962,179966,180069,180075,180151,180167,180172,180289,180291,180448,180451,180453,180454,180455,180457,180458,180459,180462,180466,180467,180468,180470,180498,180499,180532,180534,180535,180537,180538,180555,180644,180738,180756,180757,180822,180823,180824,180825,180826,180907,181092,181094,181099,181100,181101,181105,181106,181107,181108,181109,181110,181112,181113,181431,181432,181433,181565,182379,182436,182437,182438,182439,182440,182441,182442,182443,182444,182515,182526,182555,182557,182578,182744,182780,183124,183627,183642,183695,183790,183793,183794,183795,183833,184448,184451,184452,185003,185004,185012,186037,186039,186106,186108,186112,186113,186114,186115,186116,186117,186131,186132,186141,186142,186273) ORDER BY `sales_sum` ASC LIMIT 0,20 [ RunTime:0.032499s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.001044s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (351,383,414,416,438,458,479,486,491,511,514,522,524,689,1071,2413,2414,2995,3044,3059) [ RunTime:0.000359s ]
SHOW FULL COLUMNS FROM `tp_ad_position` [ RunTime:0.000668s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000197s ]
SHOW FULL COLUMNS FROM `tp_ad` [ RunTime:0.000607s ]
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.000198s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000153s ]
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.000157s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000170s ]
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.000161s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000138s ]
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.000167s ]
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.000152s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000133s ]
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.000130s ]
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.000147s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000135s ]
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.000204s ]
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.000147s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000135s ]
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.000154s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000152s ]
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.000144s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000125s ]
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.000149s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000160s ]
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.000146s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000154s ]
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.000162s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000150s ]
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.000161s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000142s ]
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 * FROM `tp_navigation` where is_show = 1 and position = 'top' ORDER BY `sort` DESC [ RunTime:0.000154s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 335 LIMIT 1 [ RunTime:0.000188s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 351 LIMIT 1 [ RunTime:0.000184s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 355 LIMIT 1 [ RunTime:0.000180s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 357 LIMIT 1 [ RunTime:0.000151s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 363 LIMIT 1 [ RunTime:0.000141s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 351 LIMIT 1 [ RunTime:0.000155s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 383 LIMIT 1 [ RunTime:0.000254s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 414 LIMIT 1 [ RunTime:0.000210s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 416 LIMIT 1 [ RunTime:0.000200s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 438 LIMIT 1 [ RunTime:0.000193s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 458 LIMIT 1 [ RunTime:0.000254s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 479 LIMIT 1 [ RunTime:0.000213s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 486 LIMIT 1 [ RunTime:0.000438s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 491 LIMIT 1 [ RunTime:0.000301s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 511 LIMIT 1 [ RunTime:0.000211s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 514 LIMIT 1 [ RunTime:0.000298s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 522 LIMIT 1 [ RunTime:0.000230s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 524 LIMIT 1 [ RunTime:0.000214s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 689 LIMIT 1 [ RunTime:0.000230s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 1071 LIMIT 1 [ RunTime:0.000230s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 2413 LIMIT 1 [ RunTime:0.000327s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 2414 LIMIT 1 [ RunTime:0.000230s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 2995 LIMIT 1 [ RunTime:0.000216s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 3044 LIMIT 1 [ RunTime:0.000243s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 3059 LIMIT 1 [ RunTime:0.000219s ]
select * from `tp_slogan` [ RunTime:0.000171s ]
select * from `tp_article` where cat_id = 1 and is_open=1 limit 5 [ RunTime:0.000183s ]
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.000171s ]
select * from `tp_article` where cat_id = 4 and is_open=1 limit 5 [ RunTime:0.000178s ]
select * from `tp_article` where cat_id = 5 and is_open=1 limit 5 [ RunTime:0.000153s ]
