SHOW FULL COLUMNS FROM `tp_wx_user` [ RunTime:0.000880s ]
SELECT * FROM `tp_wx_user` WHERE ( w_token = "xkopzw1490691329" ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000287s ]
SHOW FULL COLUMNS FROM `tp_search_word` [ RunTime:0.000530s ]
UPDATE `tp_search_word` SET `search_num` = `search_num` + 1 WHERE `keywords` = '美的' [ RunTime:0.003685s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.001039s ]
SELECT COUNT(*) AS think_count FROM `tp_goods` WHERE ( `goods_name` LIKE '%美的%' OR `keywords` LIKE '%美的%' ) AND `is_on_sale` = 1 [ RunTime:0.241746s ]
SELECT * FROM `tp_search_word` WHERE `keywords` = '美的' LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tp_search_word` SET `goods_num` = 3306 WHERE `id` = 9 [ RunTime:0.002351s ]
SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000647s ]
SELECT * FROM `tp_goods_category` WHERE `name` LIKE '%美的%' LIMIT 1 [ RunTime:0.000189s ]
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.283816s ]
SELECT * FROM `tp_goods_category` WHERE `id` IN (380,789,592,595,594,605,606,608,659,609,611,612,615,617,619,672,624,641,642,372,607,588,634,635,345,647,618,382,381,379,603,621,636,723,640,589,593,788,591,343,614,658,784,0,598,375,726,770,373,346,620,855,771,344,764,796,596,798,797,374,376,799,377,780,610,597,803,755,853,852,768,783,704,639,856,613,715,698) [ RunTime:0.000536s ]
SELECT `goods_id` FROM `tp_goods` WHERE ( shop_price >= 0 and shop_price <= 1800 ) [ RunTime:0.289589s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (334,338,351,357,363,383,384,414,416,435,459,479,482,486,488,491,494,510,511,515,516,522,523,535,541,569,590,603,605,606,608,612,624,626,644,651,653,656,689,690,702,753,965,967,1059,1066,1068,1070,1073,1117,1684,1685,1795,1828,2036,2037,2064,2084,2121,2123,2131,2269,2327,2351,2558,2682,2837,2988,3025,3048,3065,3085,3102,3155,3169,3234,3282,3290,3302,3304,3330,3331,3342,3355,3356,3415,3417,3426,3428,3433,3436,3437,3441,3450,3494,3657,3662,3780,3792,3798,3815,3818,3856,3864,3868,3897,3909,3913,3930,3958,3959,3973,4420,4425,4457,4465,4467,4487,4653,4669,4697,4698,4719,4733,4792,4793,4795,4837,5096,5097,5275,5415,5421,5434,5445,5448,5454,5468,5469,5470,5520,5525,5529,5547,5549,5551,5556,5563,5792,5962,5963,5966,5978,5979,5983,6031,6032,6041,6263,6387,6643,6648,6652,6798,6807,6808,6813,6814,6816,6825,6826,6827,6834,6842,7178,7491,7597,7615,7620,7622,7624,7628,7635,7637,7640,7642,7649,7707,7714,8034,8244,8258,8262,8264,8269,8379,8662,13825,13970,14120,14121,14122,14135,14586,14588,14599,14601,14603,14604,14607,15740,16583,16710,17704,17852,18095,18411,18553,18554,19419,19434,19438,20884,21137,21381,21382,21388,21963,21964,21965,21975,22033,22040,22432,22435,22436,22440,22443,22447,22448,22456,22461,22465,22487,22662,23062,23213,23375,23407,23549,23551,24021,24190,24197,24201,24331,24343,24344,24347,24348,24350,24355,24356,24357,24358,24366,24373,24722,24743,24752,24755,24756,24757,24758,24892,25366,25694,26029,26041,26053,26055,26057,26175,26176,26357,26361,26367,28505,28775,28864,28866,28867,29231,29493,29495,29516,29517,29527,30035,30203,30292,30384,30385,30861,30862,30905,31128,31164,31198,31392,31393,31394,31837,32095,32364,32378,32567,33486,33501,33507,33757,33758,33779,33802,33917,34024,34157,34376,34380,34551,34658,34659,34997,35401,35526,35527,35590,36042,36050,36054,36196,36226,36243,36295,36297,36298,36299,36300,36301,36365,36366,36592,36593,36643,36716,36717,36868,36892,37055,37637,37739,37740,37743,38112,38186,38187,38188,38192,38199,38560,38561,38945,39387,39394,39406,39791,39799,39812,40136,40152,40156,40169,40172,40185,40216,40219,40221,40222,40227,40240,40251,40268,40501,40502,40893,40917,40925,40974,42898,43212,43236,43312,43318,43319,43323,43325,43326,43327,43660,43663,43665,44874,45352,45673,45760,45871,45961,45967,45968,46348,46350,46351,46389,46630,46637,46680,46681,46734,46747,46749,46927,46972,47053,47187,47333,48395,54037,54040,54041,54043,56206,56269,56272,56565,56566,57099,57869,57872,57904,58185,58188,58234,58249,58258,58259,58267,58334,58493,58494,58604,58605,58728,58944,59426,59428,59482,60696,60697,61002,62015,62027,62028,62174,62175,62176,62177,62451,62935,62943,62945,62947,64167,64169,64192,64194,64597,64611,64612,65322,65515,65516,65950,65951,65955,68394,68546,69768,69771,69772,69779,72318,72319,72858,72863,72877,72878,72879,72883,72890,72891,73616,73636,73643,75314,75683,75684,75694,76566,76881,76883,76884,76885,77743,78770,78981,79195,79214,79237,79241,79300,79629,79632,79633,79644,80265,80614,80615,80631,80635,80636,80638,80640,80641,80644,80685,81016,81100,83912,83914,83917,83920,83926,83927,83928,83929,83937,85799,85873,85888,85890,86873,86933,86939,86945,87284,87477,87479,87482,87489,87572,87573,87574,87576,88343,88344,88810,89160,89451,89565,89566,89810,90261,90262,90263,91071,91415,91653,92303,92339,92351,92352,92355,93392,93579,93821,94520,94522,94619,95464,95466,95584,95696,96298,96397,96484,96581,97188,97189,97579,97614,97777,97779,97785,97788,98033,98250,98252,98388,98569,98689,98757,99016,99017,99109,99110,99111,99666,99793,100499,100614,100615,100802,100806,100888,100914,101412,101413,101414,101415,101416,101418,101420,101421,101424,101428,101431,101911,101919,101923,103137,103140,103366,103369,103400,103401,103402,103404,103406,103407,103472,103522,104017,104019,104020,104359,104362,104773,104777,105769,105970,106203,106273,106517,106676,106679,106803,106820,106825,106826,106911,107025,107413,107557,107586,107618,107890,107973,108028,108086,108100,108108,108220,108230,108231,108482,108570,108572,108573,108574,108575,108576,108577,108578,108579,108584,108585,108587,108588,108589,108590,108597,108598,108599,108605,108654,108664,108875,108876,108882,108884,109160,109261,109262,109423,109425,109506,109652,109885,109886,110259,110263,110264,110344,110395,110396,110397,110398,110410,110411,110590,110591,110848,111054,111203,111206,111543,111914,111937,111986,111987,112253,112261,112262,112264,112265,112268,112441,112561,112562,112563,112599,112600,112640,112641,112696,113136,113196,113253,113460,113469,113695,113736,113769,113845,113985,113994,114033,114034,114063,114073,114074,114075,114241,114243,114286,114342,114592,114598,114745,114818,114821,114880,114884,115302,115310,115314,115373,115380,115386,115561,115562,115563,115977,116275,116450,116929,116939,116951,116952,116954,116955,117240,117443,117444,117740,117746,117921,117953,118479,118838,118939,119283,119293,119294,119300,119301,119303,119304,119344,119465,119683,119685,119686,119798,119806,119807,119808,120001,120002,120581,120583,120584,120587,120592,120594,120595,120597,120935,121821,122037,122040,122053,122164,122166,122167,122446,122460,122487,122496,123462,123699,123889,123893,123904,124053,124343,125111,125351,125397,125433,125434,125757,125826,125835,126232,126233,126239,126262,126436,126586,127001,127002,127082,127176,127264,127278,127292,127293,128409,129220,129252,129263,129384,129424,129490,129586,129587,129624,130089,130847,130853,130921,130922,130936,130937,130944,130945,130963,130964,131137,131138,131281,131432,131465,131566,131715,131718,131719,131909,132194,132199,132282,132398,132573,132930,133519,133571,133803,134419,134639,134710,134755,134758,134763,134764,134912,134913,134960,135008,135009,135638,135639,135662,135663,135892,135909,135973,135975,135981,136078,136090,136192,136193,136245,136265,136408,136412,136495,137216,137217,137221,137229,137233,137249,137253,137297,137369,138048,138051,138147,138148,138238,138239,138461,138698,138774,139104,139109,139380,139480,139487,139559,139560,139626,139627,139646,139652,139654,139656,139657,139685,139686,139687,139788,139789,139865,140284,140292,140295,140301,140303,140308,140641,140809,141473,141772,142272,142308,142646,142871,142972,143104,143105,143168,143210,143550,143551,143561,143568,143678,143762,143838,143839,144016,144031,144032,144081,144099,144100,144104,144210,144341,144342,144343,144348,144469,144517,144546,144594,145071,145139,145141,145154,145161,145340,145606,145675,145676,145678,145679,145696,145700,145713,145714,145715,145716,145722,145723,146087,146118,146195,146314,146374,146375,146383,146560,146917,147226,147230,147232,147334,147335,147336,147366,147374,147390,147396,147399,147422,147524,147661,147663,147665,147666,147668,147707,148003,148004,148014,148226,149686,150262,150542,151199,151300,151506,151507,151782,151785,151786,151789,152287,152631,153218,153355,153646,154004,154015,154060,154375,154865,155264,155265,155307,155561,155562,155698,155699,155777,155800,155933,155935,156022,156065,156069,156154,156458,156815,156816,156905,157269,157520,157540,157558,157618,158139,158163,158405,158588,159201,159234,159343,159587,159675,160063,160121,160499,160500,160502,160503,160506,160509,160510,160515,160516,160518,160519,160530,160615,160631,160640,160666,160667,160668,160694,160695,160696,160698,160705,161620,161622,161863,161884,161972,161973,161974,162319,162323,162403,162524,162525,162526,163211,163222,163241,163253,163255,163275,163280,164119,164120,164324,164421,164477,164505,164528,164547,164548,164551,164559,164573,164629,164852,164885,164890,164910,164923,164924,164925,164926,164930,164931,164932,164933,164934,164935,164946,164977,165072,165226,165742,166037,166249,166415,166418,166420,166421,166423,166424,166471,166472,166473,166740,166894,166904,166905,166907,166908,166919,166944,166945,167056,167900,167985,168096,168174,168177,168178,168182,168185,168186,168187,168188,168189,168190,168195,168200,168201,168204,168206,168207,168211,168223,168456,168458,168464,168468,168470,168472,168491,168517,168561,168569,168612,168713,168714,168716,168717,168719,168720,168722,168810,168840,168871,168872,169046,169145,169146,169205,169312,169313,169315,169318,169346,169351,169372,169373,169441,170149,170228,170695,170703,170745,170872,170914,170915,170986,171064,171113,171139,171140,171142,171166,171168,171169,171170,171342,171350,171359,171371,171377,171378,171381,171444,171611,171785,171786,171890,171981,171982,172332,172410,172411,172628,172740,172741,172954,172955,172956,173671,173672,173713,173965,173966,174087,174102,174103,174104,174105,174334,174336,174384,174387,174388,174389,174390,174392,174393,174394,174395,174397,174450,174463,174464,174467,174468,174469,174470,174471,174477,174645,174646,174666,174667,174705,174892,174950,175109,175111,175112,175113,175114,175115,175116,175117,175121,175275,175276,175658,175661,175858,175982,175989,175992,175998,176301,176305,176306,176308,176311,176312,176313,176426,176510,176521,176548,176559,176589,176651,176744,177123,177141,177189,177201,177390,177802,177803,177817,178079,178090,178687,178688,178812,178825,178826,178827,178828,178857,178953,178957,178958,178974,179014,179015,179019,179020,179021,179140,179196,179197,179274,179305,179312,179313,179330,179359,179371,179374,179850,179853,179877,179959,179960,179961,179962,179963,179964,179965,179966,179968,180027,180151,180172,180390,180603,180729,180730,180735,180736,180737,180743,180751,180754,180759,180822,180823,180825,180826,181101,181108,181109,181110,181113,181431,181432,181433,181485,181486,181565,181703,181846,181887,181987,182077,182238,182239,182380,182447,182448,182449,182526,182555,182557,182578,182744,182752,182826,182996,183382,183391,183627,183642,183695,184239,184541,184574,184654,184847,184885,184890,184902,184959,184960,185080,185331,185333,186045,186109,186132,186147,186159,186161,186273,186719,186856,186857,186858,186859,186860,186861,186862,186863,186871,186872,186873,186943,186949,186951,186952,186959,186960,186961,186964,186965,186966,186967,186968,186986,187038,187044,187046,187047,187051,187052,187054,187055,187056,187058,187061,187062,187063,187064,187071,187072,187073,187075,187076,187079,187080,187082,187085,187086,187087,187107,187112,187115,187119,187126,187127,187130,187131,187134,187135,187137,187140,187141,187142,187212,187213,187215,187216,187218,187225,187227,187228,187229,187232,187236,187237,187238,187239,187240,187242,187243,187250,187252,187258,187259,187262,187266,187270,187271,187273,187274,187278,187279,187282,187306,187483,187487,187488,187489,187491,187493,187494,187498,187499,187504,187505,187508,187510,187512,187513,187514,187516,187517,187518,187519,187590,187594,187595,187596,187598,187599,187600,187601,187605,187606,187611,187612,187615,187617,187619,187620,187621,187623,187624,187625,187626,187627,187699,187700,187701,187704,187705,187708,187709,187710,187711,187712,187713,187714,187715,187716,187717,187718,187719,187720,187723,187726,187727,187728,187730,187738,187764,187767,187772,187775,188249,188250,189746,189990,190973,191073,191337,191338,191416,191489,191527,191528,191529,191530,191531,191532,191533,191535,191536,191537,191538,191540,191639,191662,191663,191766,191791,191900,191901,191907,191944,191945,191946,191996,192153,192169,192206,192209,192272,192281,192314,192315,192378,192447,192464,192835,192879,192946,193061,193562,193687,194732,194733,194734,194867,195208,195222,195271,195272,195323,195334,196397,196398,196399,196571,196572,196640,197180,197336,197756,197832,197834,197853,197854,197856,197857,197858,198030,198031,198032,198033,198034,198036,198040,198054,198135,198159,198169,198244,198439,198443,198463,198719,198720,198723,198754,198756,198819,198820,198829,198993,199121,199122,199419,200046,200257,200275,200280,200286,200294,200301,200302,200303,200316,200318,200328,200329,200395,200453,200465,200592,200696,200703,200729,200841,200970,200977,200986,200989,200993,200994,200996,200997,201000,201005,201007,201008,201009,201016,201019,201020,201021,201023,201024,201025,201028,201029,201060,201121,201122,201481,201591,201592,201594,201619,201670,201714,201726,201794,201803,201804,201888,202029,202125,202213,202685,202686,203023,203024,203177,203212,203223,203224,203539,203556,203557,203558,203563,203594,203595,203596,203597,203618,203659,203660,203850,203852,203854,203858,203861,203862,203863,203869,203982,204040,204046,204065,204070,204076,204083,204084,204088,204089,204094,204096,204098,204099,204100,204101,204102,204103,204114,204118,204119,204120,204123,204127,204137,204220,204258,204259,204262,204263,204264,204323,204506,204664,204727,204728,204909,205257,206113,206229,206574,206578,206579,206580,206582,206636,206734,206826,207334,207337,207338,207340,208194,208201,208204,208511,208710,208713,208923,208929,208976,209065,209066,209236,209270,209271,209274,209275,209349,209400,209402,209404,209408,209717,210180,210186,210205,210206,210210,210377,210386,210757,210861,210908,210952,210963,211612,211932,212583,212951,213230,213253,213258,213389,213390,213423,213434,213435,213436,213806,213935,214698,215199,215200,215541,215557,215562,215865,215889,216102,216279,216540,216633,216674,216749,216758,216759,216761,216762,216764,216765,216766,216767,216769,216770,216771,216772,216773,216779,216780,216782,216783,216784,216787,216788,216789,216795,216796,216797,216801,216805,216808,216809,216814,216815,216818,216970,216971,217023,217025,217026,217133,217164,217331,217341,217558,217559,217634,217654,217866,217886,217982,218209,218320,218321,218332,218339,218381,219281,219282,219283,219528,219923,219924,219925,219926,219927,219990,220108,220206,221213,221248,221693,221695,222179,222569,222570,222575,222615,222616,223151,223171,223693,224133,224207,224208,224209,224212,224219,224430,224583,224586,224590,224675,224713,224794,224795,224796,224837,224845,224856,225097,225198,225251,225389,225391,225427,225747,225962,226141,226144,226256,226474,226856,226857,226858,226859,226860,226877,228992,228993,229382,229384,229765,229795,230762,231393,231405,231582,231583,231587,231612,231622,231628,231635,231700,231758,232048,232341,232369,232438,232724,233380,233383,233810,233830,234403,234405,234406,234480,234481,234522,234527,234530,234556,234567,234573,234607,234614,234726,234729,234730,234764,234766,234768,234769,235112,235240,235438,235440,235469,235470,235471,235472,235473,235474,235475,235476,235481,235482,235485,235491,235512,235531,235536,235540,235542,235564,235570,235573,235585,235586,235590,235612,235617,235620,235624,235630,235631,235641,235649,235666,235682,235689,235703,235709,235710,235713,235714,235716,235717,235718,235720,235728,235731,235733,235735,235736,235739,235744,235745,235751,235760,235762,235766,235768,235788,235799,235804,235814,235816,235817,235819,235821,235842,235846,235856,235858,235903,235925,235932,235987,235990,235993,235994,236058,236060,236203,236209,236212,236213,236216,236220,236226,236229,236260,236261,236262,236263,236264,236266,236267,236268,236269,236270,236271,236272,236273,236274,236275,236280,236281,236285,236293,236309,236345,236346,236350,236352,236360,236363,236378,236383,236384,236398,236400,236401,236402,236403,236414,236431,236437,236483,236484,236489,236493,236508,236526,236532,236546,236549,236569,236572,236593,236598,236610,236612,236619,236620,236621,236622,236634,236640,236643,236645,236659,236662,236663,236736,236841,236843,236856,236861,236867,236911,236976,237007,237008,237065,237066,237071,237364,237365,237376,237449,237451,237475,237556,237569,237575,237619,237620,237625,237626,237629,237635,237761,237763,237764,237765,237766,237767,237769,237772,237972,237974,237975,237979,238073,238076,238078,238079,238080,238201,238202,238204,238228,238285,238291,238323,239250,239251,239252,239664,239831,239833,239834,239835,239836,239837,239838,239840,239841,239842,239843,239844,239847,239848,239849,239850,239851,239852,239870,239905,239923,239925,239926,239940,239978,239986,239990,239992,239993,239996,239997,239998,239999,240000,240001,240043,240154,240198,240200,240207,240208,240313,240315,240400,240457,240458,240472,240515,240609,240610,240611,240612,240831,240832,240833,240834,240837,240838,240839,240842,240846,240913,240950,241018,241019,241111,241112,241120,241121,241123,241124,241126,241131,241132,241133,241174,241175,241176,241177,241178,241179,241180,241259,241260,241261,241262,241329,241378,241796,241797,241798,241799,241800,241801,241802,241803,241898,242040,242081,242278,242279,242292,242293,242365,242444,242549,242550,242553,242554,242555,242905,242956,242957,242958,242959,242960,242971,242974,242994,242995,242997,242998,242999,243000,243002,243004,243005,243006,243008,243028,243030,243031,243032,243033,243043,243045,243047,243048,243050,243052,243053,243054,243056,243058,243061,243063,243064,243066,243068,243127,243128,243130,243155,243156,243178,243185,243189,243193,243323,243325,243328,243330,243445,243457,243458,243468,243471,243473,243475,243493,243496,243497,243503,243507,243508,243510,243511,243513,243515,243516,243517,243518,243520,243521,243523,243527,243529,243530,243531,243532,243533,243535,243547,243549,243723,243724,243725,243726,243727,243728,243729,243731,243732,243733,243734,243735,243736,243744,243780,243785,243838,243843,244013,244014,244241,244272,244273,244277,244278,244281,244282,244283,244286,244321,244322,244323,244324,244325,244327,244328,244329,244330,244382,244384,244406,244429,244488,244498,244501,244505,244506,244507,244508,244509,244510,244511,244512,244513,245068,245274,245304,245485,245637,245660,245763,245764,245949,245951,245963,245977,245980,245990,246010,246085,246100,246133,246278,246294,246460,246514,246515,246561,246565,246566,246567,246571,246572,246573,246576,246577,246582,246711,246817,246826,246977,246978,246980,246981,246982,247109,247247,247249,247250,247251,247252,247254,247255,247256,247257,247258,247259,247269,247271,247273,247308,247383,247385,247386,247388,247390,247391,247393,247395,247396,247397,247399,247400,247401,247403,247404,247407,247419,247421,247440,247442,247443,247445,247446,247447,247449,247450,247452,247453,247454,247456,247457,247459,247460,247461,247462,247464,247469,247470,247471,247472,247473,247474,247475,247477,247478,247479,247480,247481,247482,247484,247490,247491,247492,247493,247494,247496,247497,247498,247523,247524,247525,247526,247527,247528,247529,247530,247531,247532,247533,247534,247536,247537,247538,247539,247540,247541,247542,247543,247544,247574,247622,247623,247624,247625,247626,247627,247628,247629,247630,247633,247646,247647,247648,247649,247650,247662,247894,247895,247896,248110,248111,248234,248371,248372,248636,248878,248909,248910,248911,248912,249135,249392,250157,250158,250159,250160,250161,250162,250163,250165,250166,250167,250168,250169,250170,250171,250172,250173,250174,250175,250176,250178,250179,250180,250428,250553,250554,250856,250944,250945,250949,250950,250951,250952,250953,250954,250957,251022,251164,251171,251172,251280,251359,251612,251618,251640,251642,251675,251676,251677,251791,251902,251954,252167,252170,252681,252682,252683,252684,252695,252830,252831,252832,252833,252947,253030,253121,253582,253604,253775,253776,253802,253858,253865,253935,253936,253937,253938,253957,253964,254031,254535,254657,254658,254660,254933,255020,255043,255062,255122,255203,255312,255313,255316,255318,255319,255322,255324,255329,255330,255331,255333,255334,255335,255337,255338,255339,255340,255341,255342,255343,255344,255345,255346,255348,255349,255351,255352,255353,255354,255355,255357,255358,255359,255360,255361,255362,255364,255367,255368,255369,255372,255373,255378,255379,255380,255381,255382,255383,255384,255385,255386,255387,255388,255389,255390,255391,255392,255393,255394,255395,255396,255398,255399,255400,255401,255402,255403,255404,255405,255406,255407,255408,255409,255410,255411,255412,255413,255414,255415,255416,255417,255418,255419,255420,255421,255422,255423,255424,255425,255426,255427,255428,255429,255430,255431,255432,255433,255434,255435,255436,255437,255438,255439,255440,255441,255442,255443,255444,255445,255446,255447,255448,255449,255450,255451,255452,255453,255454,255455,255456,255457,255458,255459,255460,255461,255462,255469,255471,255473,255474,255475,255476,255478,255479,255480,255481,255482,255484,255485,255486,255487,255488,255489,255490,255494,255496,255497,255499,255501,255502,255503,255504,255505,255506,255509,255510,255511,255519,255521,255522,255523,255524,255525,255526,255527,255529,255530,255531,255532,255542,255543,255545,255549,255551,255552,255557,255626,255627,255628,255629,255630,255631,255632,255633,255634,255635,255636,255637,255638,255639,255640,255641,255642,255643,255644,255646,255647,255648,255649,255650,255651,255652,255653,255654,255798,255799,255800,255801,255802,255803,255804,255810,255812,255814,256338,256339,256392,256400,256401,256402,256403,256718,256719,256789,257160,257182,257465,257466,257470,257471,257474,257475,257476,257477,257478,257480,257481,257482,257483,257484,257485,257486,257487,257488,257489,257490,257493,257494,257496,257497,257498,257499,257500,257501,257503,257504,257505,257506,257507,257508,257510,257671,257672,257764,257921,257972,258062,258063,258064,258066,258085,258464,258465,258466,258467,258468,258469,258470,258471,258472,258473,258474,258475,258485,258487,258492,258493,258495,258497,258500,258501,258502,258503,258504,258543,258777,259184,259271,259334,259350,259508,259515,259610,259611,259612,259614,259616,259618,259619,259622,259623,259624,259625,259626,259629,259697,259698,259833,259834,259835,259836,260487,260625,260667,260670,260734,260953,260954,260955,261206,261207,261400,261401,261486,261595,261641,262144,262145,262147,262159,262530,262642,262663,262683,262684,262685,262686,262687,262688,262689,262690) AND `brand_id` > 0 [ RunTime:0.058790s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.001074s ]
SELECT * FROM `tp_brand` WHERE `id` IN (43,63,50,52,75,42,18,252,51,237,224,207,262,126,187,139,22,65,76,230,236,27) LIMIT 30 [ RunTime:0.000295s ]
SELECT * FROM `tp_goods` WHERE `is_on_sale` = 1 AND `goods_id` IN (334,338,351,357,363,383,384,414,416,435,459,479,482,486,488,491,494,510,511,515,516,522,523,535,541,569,590,603,605,606,608,612,624,626,644,651,653,656,689,690,702,753,965,967,1059,1066,1068,1070,1073,1117,1684,1685,1795,1828,2036,2037,2064,2084,2121,2123,2131,2269,2327,2351,2558,2682,2837,2988,3025,3048,3065,3085,3102,3155,3169,3234,3282,3290,3302,3304,3330,3331,3342,3355,3356,3415,3417,3426,3428,3433,3436,3437,3441,3450,3494,3657,3662,3780,3792,3798,3815,3818,3856,3864,3868,3897,3909,3913,3930,3958,3959,3973,4420,4425,4457,4465,4467,4487,4653,4669,4697,4698,4719,4733,4792,4793,4795,4837,5096,5097,5275,5415,5421,5434,5445,5448,5454,5468,5469,5470,5520,5525,5529,5547,5549,5551,5556,5563,5792,5962,5963,5966,5978,5979,5983,6031,6032,6041,6263,6387,6643,6648,6652,6798,6807,6808,6813,6814,6816,6825,6826,6827,6834,6842,7178,7491,7597,7615,7620,7622,7624,7628,7635,7637,7640,7642,7649,7707,7714,8034,8244,8258,8262,8264,8269,8379,8662,13825,13970,14120,14121,14122,14135,14586,14588,14599,14601,14603,14604,14607,15740,16583,16710,17704,17852,18095,18411,18553,18554,19419,19434,19438,20884,21137,21381,21382,21388,21963,21964,21965,21975,22033,22040,22432,22435,22436,22440,22443,22447,22448,22456,22461,22465,22487,22662,23062,23213,23375,23407,23549,23551,24021,24190,24197,24201,24331,24343,24344,24347,24348,24350,24355,24356,24357,24358,24366,24373,24722,24743,24752,24755,24756,24757,24758,24892,25366,25694,26029,26041,26053,26055,26057,26175,26176,26357,26361,26367,28505,28775,28864,28866,28867,29231,29493,29495,29516,29517,29527,30035,30203,30292,30384,30385,30861,30862,30905,31128,31164,31198,31392,31393,31394,31837,32095,32364,32378,32567,33486,33501,33507,33757,33758,33779,33802,33917,34024,34157,34376,34380,34551,34658,34659,34997,35401,35526,35527,35590,36042,36050,36054,36196,36226,36243,36295,36297,36298,36299,36300,36301,36365,36366,36592,36593,36643,36716,36717,36868,36892,37055,37637,37739,37740,37743,38112,38186,38187,38188,38192,38199,38560,38561,38945,39387,39394,39406,39791,39799,39812,40136,40152,40156,40169,40172,40185,40216,40219,40221,40222,40227,40240,40251,40268,40501,40502,40893,40917,40925,40974,42898,43212,43236,43312,43318,43319,43323,43325,43326,43327,43660,43663,43665,44874,45352,45673,45760,45871,45961,45967,45968,46348,46350,46351,46389,46630,46637,46680,46681,46734,46747,46749,46927,46972,47053,47187,47333,48395,54037,54040,54041,54043,56206,56269,56272,56565,56566,57099,57869,57872,57904,58185,58188,58234,58249,58258,58259,58267,58334,58493,58494,58604,58605,58728,58944,59426,59428,59482,60696,60697,61002,62015,62027,62028,62174,62175,62176,62177,62451,62935,62943,62945,62947,64167,64169,64192,64194,64597,64611,64612,65322,65515,65516,65950,65951,65955,68394,68546,69768,69771,69772,69779,72318,72319,72858,72863,72877,72878,72879,72883,72890,72891,73616,73636,73643,75314,75683,75684,75694,76566,76881,76883,76884,76885,77743,78770,78981,79195,79214,79237,79241,79300,79629,79632,79633,79644,80265,80614,80615,80631,80635,80636,80638,80640,80641,80644,80685,81016,81100,83912,83914,83917,83920,83926,83927,83928,83929,83937,85799,85873,85888,85890,86873,86933,86939,86945,87284,87477,87479,87482,87489,87572,87573,87574,87576,88343,88344,88810,89160,89451,89565,89566,89810,90261,90262,90263,91071,91415,91653,92303,92339,92351,92352,92355,93392,93579,93821,94520,94522,94619,95464,95466,95584,95696,96298,96397,96484,96581,97188,97189,97579,97614,97777,97779,97785,97788,98033,98250,98252,98388,98569,98689,98757,99016,99017,99109,99110,99111,99666,99793,100499,100614,100615,100802,100806,100888,100914,101412,101413,101414,101415,101416,101418,101420,101421,101424,101428,101431,101911,101919,101923,103137,103140,103366,103369,103400,103401,103402,103404,103406,103407,103472,103522,104017,104019,104020,104359,104362,104773,104777,105769,105970,106203,106273,106517,106676,106679,106803,106820,106825,106826,106911,107025,107413,107557,107586,107618,107890,107973,108028,108086,108100,108108,108220,108230,108231,108482,108570,108572,108573,108574,108575,108576,108577,108578,108579,108584,108585,108587,108588,108589,108590,108597,108598,108599,108605,108654,108664,108875,108876,108882,108884,109160,109261,109262,109423,109425,109506,109652,109885,109886,110259,110263,110264,110344,110395,110396,110397,110398,110410,110411,110590,110591,110848,111054,111203,111206,111543,111914,111937,111986,111987,112253,112261,112262,112264,112265,112268,112441,112561,112562,112563,112599,112600,112640,112641,112696,113136,113196,113253,113460,113469,113695,113736,113769,113845,113985,113994,114033,114034,114063,114073,114074,114075,114241,114243,114286,114342,114592,114598,114745,114818,114821,114880,114884,115302,115310,115314,115373,115380,115386,115561,115562,115563,115977,116275,116450,116929,116939,116951,116952,116954,116955,117240,117443,117444,117740,117746,117921,117953,118479,118838,118939,119283,119293,119294,119300,119301,119303,119304,119344,119465,119683,119685,119686,119798,119806,119807,119808,120001,120002,120581,120583,120584,120587,120592,120594,120595,120597,120935,121821,122037,122040,122053,122164,122166,122167,122446,122460,122487,122496,123462,123699,123889,123893,123904,124053,124343,125111,125351,125397,125433,125434,125757,125826,125835,126232,126233,126239,126262,126436,126586,127001,127002,127082,127176,127264,127278,127292,127293,128409,129220,129252,129263,129384,129424,129490,129586,129587,129624,130089,130847,130853,130921,130922,130936,130937,130944,130945,130963,130964,131137,131138,131281,131432,131465,131566,131715,131718,131719,131909,132194,132199,132282,132398,132573,132930,133519,133571,133803,134419,134639,134710,134755,134758,134763,134764,134912,134913,134960,135008,135009,135638,135639,135662,135663,135892,135909,135973,135975,135981,136078,136090,136192,136193,136245,136265,136408,136412,136495,137216,137217,137221,137229,137233,137249,137253,137297,137369,138048,138051,138147,138148,138238,138239,138461,138698,138774,139104,139109,139380,139480,139487,139559,139560,139626,139627,139646,139652,139654,139656,139657,139685,139686,139687,139788,139789,139865,140284,140292,140295,140301,140303,140308,140641,140809,141473,141772,142272,142308,142646,142871,142972,143104,143105,143168,143210,143550,143551,143561,143568,143678,143762,143838,143839,144016,144031,144032,144081,144099,144100,144104,144210,144341,144342,144343,144348,144469,144517,144546,144594,145071,145139,145141,145154,145161,145340,145606,145675,145676,145678,145679,145696,145700,145713,145714,145715,145716,145722,145723,146087,146118,146195,146314,146374,146375,146383,146560,146917,147226,147230,147232,147334,147335,147336,147366,147374,147390,147396,147399,147422,147524,147661,147663,147665,147666,147668,147707,148003,148004,148014,148226,149686,150262,150542,151199,151300,151506,151507,151782,151785,151786,151789,152287,152631,153218,153355,153646,154004,154015,154060,154375,154865,155264,155265,155307,155561,155562,155698,155699,155777,155800,155933,155935,156022,156065,156069,156154,156458,156815,156816,156905,157269,157520,157540,157558,157618,158139,158163,158405,158588,159201,159234,159343,159587,159675,160063,160121,160499,160500,160502,160503,160506,160509,160510,160515,160516,160518,160519,160530,160615,160631,160640,160666,160667,160668,160694,160695,160696,160698,160705,161620,161622,161863,161884,161972,161973,161974,162319,162323,162403,162524,162525,162526,163211,163222,163241,163253,163255,163275,163280,164119,164120,164324,164421,164477,164505,164528,164547,164548,164551,164559,164573,164629,164852,164885,164890,164910,164923,164924,164925,164926,164930,164931,164932,164933,164934,164935,164946,164977,165072,165226,165742,166037,166249,166415,166418,166420,166421,166423,166424,166471,166472,166473,166740,166894,166904,166905,166907,166908,166919,166944,166945,167056,167900,167985,168096,168174,168177,168178,168182,168185,168186,168187,168188,168189,168190,168195,168200,168201,168204,168206,168207,168211,168223,168456,168458,168464,168468,168470,168472,168491,168517,168561,168569,168612,168713,168714,168716,168717,168719,168720,168722,168810,168840,168871,168872,169046,169145,169146,169205,169312,169313,169315,169318,169346,169351,169372,169373,169441,170149,170228,170695,170703,170745,170872,170914,170915,170986,171064,171113,171139,171140,171142,171166,171168,171169,171170,171342,171350,171359,171371,171377,171378,171381,171444,171611,171785,171786,171890,171981,171982,172332,172410,172411,172628,172740,172741,172954,172955,172956,173671,173672,173713,173965,173966,174087,174102,174103,174104,174105,174334,174336,174384,174387,174388,174389,174390,174392,174393,174394,174395,174397,174450,174463,174464,174467,174468,174469,174470,174471,174477,174645,174646,174666,174667,174705,174892,174950,175109,175111,175112,175113,175114,175115,175116,175117,175121,175275,175276,175658,175661,175858,175982,175989,175992,175998,176301,176305,176306,176308,176311,176312,176313,176426,176510,176521,176548,176559,176589,176651,176744,177123,177141,177189,177201,177390,177802,177803,177817,178079,178090,178687,178688,178812,178825,178826,178827,178828,178857,178953,178957,178958,178974,179014,179015,179019,179020,179021,179140,179196,179197,179274,179305,179312,179313,179330,179359,179371,179374,179850,179853,179877,179959,179960,179961,179962,179963,179964,179965,179966,179968,180027,180151,180172,180390,180603,180729,180730,180735,180736,180737,180743,180751,180754,180759,180822,180823,180825,180826,181101,181108,181109,181110,181113,181431,181432,181433,181485,181486,181565,181703,181846,181887,181987,182077,182238,182239,182380,182447,182448,182449,182526,182555,182557,182578,182744,182752,182826,182996,183382,183391,183627,183642,183695,184239,184541,184574,184654,184847,184885,184890,184902,184959,184960,185080,185331,185333,186045,186109,186132,186147,186159,186161,186273,186719,186856,186857,186858,186859,186860,186861,186862,186863,186871,186872,186873,186943,186949,186951,186952,186959,186960,186961,186964,186965,186966,186967,186968,186986,187038,187044,187046,187047,187051,187052,187054,187055,187056,187058,187061,187062,187063,187064,187071,187072,187073,187075,187076,187079,187080,187082,187085,187086,187087,187107,187112,187115,187119,187126,187127,187130,187131,187134,187135,187137,187140,187141,187142,187212,187213,187215,187216,187218,187225,187227,187228,187229,187232,187236,187237,187238,187239,187240,187242,187243,187250,187252,187258,187259,187262,187266,187270,187271,187273,187274,187278,187279,187282,187306,187483,187487,187488,187489,187491,187493,187494,187498,187499,187504,187505,187508,187510,187512,187513,187514,187516,187517,187518,187519,187590,187594,187595,187596,187598,187599,187600,187601,187605,187606,187611,187612,187615,187617,187619,187620,187621,187623,187624,187625,187626,187627,187699,187700,187701,187704,187705,187708,187709,187710,187711,187712,187713,187714,187715,187716,187717,187718,187719,187720,187723,187726,187727,187728,187730,187738,187764,187767,187772,187775,188249,188250,189746,189990,190973,191073,191337,191338,191416,191489,191527,191528,191529,191530,191531,191532,191533,191535,191536,191537,191538,191540,191639,191662,191663,191766,191791,191900,191901,191907,191944,191945,191946,191996,192153,192169,192206,192209,192272,192281,192314,192315,192378,192447,192464,192835,192879,192946,193061,193562,193687,194732,194733,194734,194867,195208,195222,195271,195272,195323,195334,196397,196398,196399,196571,196572,196640,197180,197336,197756,197832,197834,197853,197854,197856,197857,197858,198030,198031,198032,198033,198034,198036,198040,198054,198135,198159,198169,198244,198439,198443,198463,198719,198720,198723,198754,198756,198819,198820,198829,198993,199121,199122,199419,200046,200257,200275,200280,200286,200294,200301,200302,200303,200316,200318,200328,200329,200395,200453,200465,200592,200696,200703,200729,200841,200970,200977,200986,200989,200993,200994,200996,200997,201000,201005,201007,201008,201009,201016,201019,201020,201021,201023,201024,201025,201028,201029,201060,201121,201122,201481,201591,201592,201594,201619,201670,201714,201726,201794,201803,201804,201888,202029,202125,202213,202685,202686,203023,203024,203177,203212,203223,203224,203539,203556,203557,203558,203563,203594,203595,203596,203597,203618,203659,203660,203850,203852,203854,203858,203861,203862,203863,203869,203982,204040,204046,204065,204070,204076,204083,204084,204088,204089,204094,204096,204098,204099,204100,204101,204102,204103,204114,204118,204119,204120,204123,204127,204137,204220,204258,204259,204262,204263,204264,204323,204506,204664,204727,204728,204909,205257,206113,206229,206574,206578,206579,206580,206582,206636,206734,206826,207334,207337,207338,207340,208194,208201,208204,208511,208710,208713,208923,208929,208976,209065,209066,209236,209270,209271,209274,209275,209349,209400,209402,209404,209408,209717,210180,210186,210205,210206,210210,210377,210386,210757,210861,210908,210952,210963,211612,211932,212583,212951,213230,213253,213258,213389,213390,213423,213434,213435,213436,213806,213935,214698,215199,215200,215541,215557,215562,215865,215889,216102,216279,216540,216633,216674,216749,216758,216759,216761,216762,216764,216765,216766,216767,216769,216770,216771,216772,216773,216779,216780,216782,216783,216784,216787,216788,216789,216795,216796,216797,216801,216805,216808,216809,216814,216815,216818,216970,216971,217023,217025,217026,217133,217164,217331,217341,217558,217559,217634,217654,217866,217886,217982,218209,218320,218321,218332,218339,218381,219281,219282,219283,219528,219923,219924,219925,219926,219927,219990,220108,220206,221213,221248,221693,221695,222179,222569,222570,222575,222615,222616,223151,223171,223693,224133,224207,224208,224209,224212,224219,224430,224583,224586,224590,224675,224713,224794,224795,224796,224837,224845,224856,225097,225198,225251,225389,225391,225427,225747,225962,226141,226144,226256,226474,226856,226857,226858,226859,226860,226877,228992,228993,229382,229384,229765,229795,230762,231393,231405,231582,231583,231587,231612,231622,231628,231635,231700,231758,232048,232341,232369,232438,232724,233380,233383,233810,233830,234403,234405,234406,234480,234481,234522,234527,234530,234556,234567,234573,234607,234614,234726,234729,234730,234764,234766,234768,234769,235112,235240,235438,235440,235469,235470,235471,235472,235473,235474,235475,235476,235481,235482,235485,235491,235512,235531,235536,235540,235542,235564,235570,235573,235585,235586,235590,235612,235617,235620,235624,235630,235631,235641,235649,235666,235682,235689,235703,235709,235710,235713,235714,235716,235717,235718,235720,235728,235731,235733,235735,235736,235739,235744,235745,235751,235760,235762,235766,235768,235788,235799,235804,235814,235816,235817,235819,235821,235842,235846,235856,235858,235903,235925,235932,235987,235990,235993,235994,236058,236060,236203,236209,236212,236213,236216,236220,236226,236229,236260,236261,236262,236263,236264,236266,236267,236268,236269,236270,236271,236272,236273,236274,236275,236280,236281,236285,236293,236309,236345,236346,236350,236352,236360,236363,236378,236383,236384,236398,236400,236401,236402,236403,236414,236431,236437,236483,236484,236489,236493,236508,236526,236532,236546,236549,236569,236572,236593,236598,236610,236612,236619,236620,236621,236622,236634,236640,236643,236645,236659,236662,236663,236736,236841,236843,236856,236861,236867,236911,236976,237007,237008,237065,237066,237071,237364,237365,237376,237449,237451,237475,237556,237569,237575,237619,237620,237625,237626,237629,237635,237761,237763,237764,237765,237766,237767,237769,237772,237972,237974,237975,237979,238073,238076,238078,238079,238080,238201,238202,238204,238228,238285,238291,238323,239250,239251,239252,239664,239831,239833,239834,239835,239836,239837,239838,239840,239841,239842,239843,239844,239847,239848,239849,239850,239851,239852,239870,239905,239923,239925,239926,239940,239978,239986,239990,239992,239993,239996,239997,239998,239999,240000,240001,240043,240154,240198,240200,240207,240208,240313,240315,240400,240457,240458,240472,240515,240609,240610,240611,240612,240831,240832,240833,240834,240837,240838,240839,240842,240846,240913,240950,241018,241019,241111,241112,241120,241121,241123,241124,241126,241131,241132,241133,241174,241175,241176,241177,241178,241179,241180,241259,241260,241261,241262,241329,241378,241796,241797,241798,241799,241800,241801,241802,241803,241898,242040,242081,242278,242279,242292,242293,242365,242444,242549,242550,242553,242554,242555,242905,242956,242957,242958,242959,242960,242971,242974,242994,242995,242997,242998,242999,243000,243002,243004,243005,243006,243008,243028,243030,243031,243032,243033,243043,243045,243047,243048,243050,243052,243053,243054,243056,243058,243061,243063,243064,243066,243068,243127,243128,243130,243155,243156,243178,243185,243189,243193,243323,243325,243328,243330,243445,243457,243458,243468,243471,243473,243475,243493,243496,243497,243503,243507,243508,243510,243511,243513,243515,243516,243517,243518,243520,243521,243523,243527,243529,243530,243531,243532,243533,243535,243547,243549,243723,243724,243725,243726,243727,243728,243729,243731,243732,243733,243734,243735,243736,243744,243780,243785,243838,243843,244013,244014,244241,244272,244273,244277,244278,244281,244282,244283,244286,244321,244322,244323,244324,244325,244327,244328,244329,244330,244382,244384,244406,244429,244488,244498,244501,244505,244506,244507,244508,244509,244510,244511,244512,244513,245068,245274,245304,245485,245637,245660,245763,245764,245949,245951,245963,245977,245980,245990,246010,246085,246100,246133,246278,246294,246460,246514,246515,246561,246565,246566,246567,246571,246572,246573,246576,246577,246582,246711,246817,246826,246977,246978,246980,246981,246982,247109,247247,247249,247250,247251,247252,247254,247255,247256,247257,247258,247259,247269,247271,247273,247308,247383,247385,247386,247388,247390,247391,247393,247395,247396,247397,247399,247400,247401,247403,247404,247407,247419,247421,247440,247442,247443,247445,247446,247447,247449,247450,247452,247453,247454,247456,247457,247459,247460,247461,247462,247464,247469,247470,247471,247472,247473,247474,247475,247477,247478,247479,247480,247481,247482,247484,247490,247491,247492,247493,247494,247496,247497,247498,247523,247524,247525,247526,247527,247528,247529,247530,247531,247532,247533,247534,247536,247537,247538,247539,247540,247541,247542,247543,247544,247574,247622,247623,247624,247625,247626,247627,247628,247629,247630,247633,247646,247647,247648,247649,247650,247662,247894,247895,247896,248110,248111,248234,248371,248372,248636,248878,248909,248910,248911,248912,249135,249392,250157,250158,250159,250160,250161,250162,250163,250165,250166,250167,250168,250169,250170,250171,250172,250173,250174,250175,250176,250178,250179,250180,250428,250553,250554,250856,250944,250945,250949,250950,250951,250952,250953,250954,250957,251022,251164,251171,251172,251280,251359,251612,251618,251640,251642,251675,251676,251677,251791,251902,251954,252167,252170,252681,252682,252683,252684,252695,252830,252831,252832,252833,252947,253030,253121,253582,253604,253775,253776,253802,253858,253865,253935,253936,253937,253938,253957,253964,254031,254535,254657,254658,254660,254933,255020,255043,255062,255122,255203,255312,255313,255316,255318,255319,255322,255324,255329,255330,255331,255333,255334,255335,255337,255338,255339,255340,255341,255342,255343,255344,255345,255346,255348,255349,255351,255352,255353,255354,255355,255357,255358,255359,255360,255361,255362,255364,255367,255368,255369,255372,255373,255378,255379,255380,255381,255382,255383,255384,255385,255386,255387,255388,255389,255390,255391,255392,255393,255394,255395,255396,255398,255399,255400,255401,255402,255403,255404,255405,255406,255407,255408,255409,255410,255411,255412,255413,255414,255415,255416,255417,255418,255419,255420,255421,255422,255423,255424,255425,255426,255427,255428,255429,255430,255431,255432,255433,255434,255435,255436,255437,255438,255439,255440,255441,255442,255443,255444,255445,255446,255447,255448,255449,255450,255451,255452,255453,255454,255455,255456,255457,255458,255459,255460,255461,255462,255469,255471,255473,255474,255475,255476,255478,255479,255480,255481,255482,255484,255485,255486,255487,255488,255489,255490,255494,255496,255497,255499,255501,255502,255503,255504,255505,255506,255509,255510,255511,255519,255521,255522,255523,255524,255525,255526,255527,255529,255530,255531,255532,255542,255543,255545,255549,255551,255552,255557,255626,255627,255628,255629,255630,255631,255632,255633,255634,255635,255636,255637,255638,255639,255640,255641,255642,255643,255644,255646,255647,255648,255649,255650,255651,255652,255653,255654,255798,255799,255800,255801,255802,255803,255804,255810,255812,255814,256338,256339,256392,256400,256401,256402,256403,256718,256719,256789,257160,257182,257465,257466,257470,257471,257474,257475,257476,257477,257478,257480,257481,257482,257483,257484,257485,257486,257487,257488,257489,257490,257493,257494,257496,257497,257498,257499,257500,257501,257503,257504,257505,257506,257507,257508,257510,257671,257672,257764,257921,257972,258062,258063,258064,258066,258085,258464,258465,258466,258467,258468,258469,258470,258471,258472,258473,258474,258475,258485,258487,258492,258493,258495,258497,258500,258501,258502,258503,258504,258543,258777,259184,259271,259334,259350,259508,259515,259610,259611,259612,259614,259616,259618,259619,259622,259623,259624,259625,259626,259629,259697,259698,259833,259834,259835,259836,260487,260625,260667,260670,260734,260953,260954,260955,261206,261207,261400,261401,261486,261595,261641,262144,262145,262147,262159,262530,262642,262663,262683,262684,262685,262686,262687,262688,262689,262690) ORDER BY `sort` ASC LIMIT 2520,20 [ RunTime:0.069544s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000819s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (147668,216788,224212,235476,243156,247252,182996,255444,7637,144341,216789,24021,235733,40917,187605,254933,255445,125397,257493,3798) [ RunTime:0.000468s ]
SHOW FULL COLUMNS FROM `tp_ad_position` [ RunTime:0.000504s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000157s ]
SHOW FULL COLUMNS FROM `tp_ad` [ RunTime:0.000530s ]
SELECT * FROM `tp_ad` WHERE ( pid=101 and enabled = 1 and start_time < 1780768800 and end_time > 1780768800 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000172s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000155s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1780768800 and end_time > 1780768800 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000167s ]
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 < 1780768800 and end_time > 1780768800 ) 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.000138s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1780768800 and end_time > 1780768800 ) 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.000143s ]
SELECT * FROM `tp_ad` WHERE ( pid=103 and enabled = 1 and start_time < 1780768800 and end_time > 1780768800 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000148s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000121s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1780768800 and end_time > 1780768800 ) 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.000148s ]
SELECT * FROM `tp_ad` WHERE ( pid=104 and enabled = 1 and start_time < 1780768800 and end_time > 1780768800 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000142s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000136s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1780768800 and end_time > 1780768800 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000143s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000143s ]
SELECT * FROM `tp_ad` WHERE ( pid=105 and enabled = 1 and start_time < 1780768800 and end_time > 1780768800 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000148s ]
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 < 1780768800 and end_time > 1780768800 ) 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.000147s ]
SELECT * FROM `tp_ad` WHERE ( pid=106 and enabled = 1 and start_time < 1780768800 and end_time > 1780768800 ) 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.000129s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1780768800 and end_time > 1780768800 ) 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.000168s ]
SELECT * FROM `tp_ad` WHERE ( pid=107 and enabled = 1 and start_time < 1780768800 and end_time > 1780768800 ) 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.000137s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1780768800 and end_time > 1780768800 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000148s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000149s ]
SELECT * FROM `tp_ad` WHERE ( pid=108 and enabled = 1 and start_time < 1780768800 and end_time > 1780768800 ) 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.000138s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1780768800 and end_time > 1780768800 ) 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.000148s ]
SELECT * FROM `tp_ad` WHERE ( pid=109 and enabled = 1 and start_time < 1780768800 and end_time > 1780768800 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000149s ]
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 < 1780768800 and end_time > 1780768800 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000158s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000133s ]
SELECT * FROM `tp_ad` WHERE ( pid=110 and enabled = 1 and start_time < 1780768800 and end_time > 1780768800 ) 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.000146s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1780768800 and end_time > 1780768800 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000146s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000143s ]
SELECT * FROM `tp_ad` WHERE ( pid=111 and enabled = 1 and start_time < 1780768800 and end_time > 1780768800 ) 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.000205s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1780768800 and end_time > 1780768800 ) 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.000141s ]
SELECT * FROM `tp_ad` WHERE ( pid=112 and enabled = 1 and start_time < 1780768800 and end_time > 1780768800 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000140s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000128s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1780768800 and end_time > 1780768800 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000217s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000178s ]
SELECT * FROM `tp_ad` WHERE ( pid=113 and enabled = 1 and start_time < 1780768800 and end_time > 1780768800 ) 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.000147s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1780768800 and end_time > 1780768800 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000181s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000165s ]
SELECT * FROM `tp_ad` WHERE ( pid=114 and enabled = 1 and start_time < 1780768800 and end_time > 1780768800 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000187s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000163s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1780768800 and end_time > 1780768800 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000174s ]
SELECT * FROM `tp_navigation` where is_show = 1 and position = 'top' ORDER BY `sort` DESC [ RunTime:0.000191s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 351 LIMIT 1 [ RunTime:0.000295s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 357 LIMIT 1 [ RunTime:0.000250s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 363 LIMIT 1 [ RunTime:0.000237s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 383 LIMIT 1 [ RunTime:0.000264s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 384 LIMIT 1 [ RunTime:0.000237s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 147668 LIMIT 1 [ RunTime:0.000712s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 216788 LIMIT 1 [ RunTime:0.000400s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 224212 LIMIT 1 [ RunTime:0.000265s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 235476 LIMIT 1 [ RunTime:0.000231s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 243156 LIMIT 1 [ RunTime:0.000332s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 247252 LIMIT 1 [ RunTime:0.000393s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 182996 LIMIT 1 [ RunTime:0.000276s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 255444 LIMIT 1 [ RunTime:0.000419s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 7637 LIMIT 1 [ RunTime:0.000389s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 144341 LIMIT 1 [ RunTime:0.000283s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 216789 LIMIT 1 [ RunTime:0.000264s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 24021 LIMIT 1 [ RunTime:0.000217s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 235733 LIMIT 1 [ RunTime:0.000290s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 40917 LIMIT 1 [ RunTime:0.000267s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 187605 LIMIT 1 [ RunTime:0.000263s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 254933 LIMIT 1 [ RunTime:0.000342s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 255445 LIMIT 1 [ RunTime:0.000241s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 125397 LIMIT 1 [ RunTime:0.000346s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 257493 LIMIT 1 [ RunTime:0.000329s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 3798 LIMIT 1 [ RunTime:0.000241s ]
select * from `tp_slogan` [ RunTime:0.000162s ]
select * from `tp_article` where cat_id = 1 and is_open=1 limit 5 [ RunTime:0.000170s ]
select * from `tp_article` where cat_id = 2 and is_open=1 limit 5 [ RunTime:0.000210s ]
select * from `tp_article` where cat_id = 3 and is_open=1 limit 5 [ RunTime:0.000165s ]
select * from `tp_article` where cat_id = 4 and is_open=1 limit 5 [ RunTime:0.000161s ]
select * from `tp_article` where cat_id = 5 and is_open=1 limit 5 [ RunTime:0.000173s ]
