SHOW FULL COLUMNS FROM `tp_wx_user` [ RunTime:0.000933s ]
SELECT * FROM `tp_wx_user` WHERE ( w_token = "xkopzw1490691329" ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000295s ]
SHOW FULL COLUMNS FROM `tp_search_word` [ RunTime:0.000575s ]
UPDATE `tp_search_word` SET `search_num` = `search_num` + 1 WHERE `keywords` = '洗衣机' [ RunTime:0.002199s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.001028s ]
SELECT COUNT(*) AS think_count FROM `tp_goods` WHERE ( `goods_name` LIKE '%洗衣机%' OR `keywords` LIKE '%洗衣机%' ) AND `is_on_sale` = 1 [ RunTime:0.150865s ]
SELECT * FROM `tp_search_word` WHERE `keywords` = '洗衣机' LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tp_search_word` SET `goods_num` = 1420 WHERE `id` = 8 [ RunTime:0.007090s ]
SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000661s ]
SELECT * FROM `tp_goods_category` WHERE `name` LIKE '%洗衣机%' LIMIT 1 [ RunTime:0.000185s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000170s ]
SELECT `goods_id`,`cat_id` FROM `tp_goods` WHERE ( `goods_name` LIKE '%洗衣机%' OR `keywords` LIKE '%洗衣机%' ) AND `is_on_sale` = 1 AND `is_virtual` <> 2 OR ( cat_id in (54,372,373,374,375,376,377,639,651,780) and is_virtual <> 2 and is_on_sale =1 ) [ RunTime:0.162735s ]
SELECT * FROM `tp_goods_category` WHERE `id` IN (373,639,374,377,372,375,376,651,0,382,780,588,628,796,378,54) [ RunTime:0.000365s ]
SELECT `goods_id` FROM `tp_goods` WHERE ( shop_price >= 0 and shop_price <= 4820 ) [ RunTime:0.175203s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (700,714,735,1107,1153,1163,1292,1657,1699,2193,2324,2333,2335,2387,2392,2406,2423,2429,2430,2432,2443,2456,2477,2544,2810,2863,2887,2888,2931,2998,3451,4035,4036,4192,4198,4213,4230,4231,4281,4284,4289,4296,4309,4315,4316,4319,4320,4322,4328,4329,4336,4339,4341,4342,4348,4349,4350,4353,4386,4779,4890,4902,4920,4950,5047,5048,5178,5180,5182,5183,5185,5187,5189,5197,5216,5218,5259,5288,5294,5340,5341,5348,5350,5355,5356,5357,5359,5362,5369,5376,5380,5383,5395,5396,5397,5402,5405,5407,5510,5719,5765,5863,5994,6027,6028,6035,6159,6167,6168,6186,6212,6223,6480,6483,6484,6485,6487,6488,6489,6977,7040,7041,7080,7084,7288,7435,7450,7503,7696,7834,7969,7971,8033,8035,8214,10904,11064,13657,13795,13798,13841,13919,13923,13924,13958,14208,14211,14215,14222,14224,14225,14226,14227,14296,14299,14306,14308,14541,14546,14650,14651,16320,16324,16325,16469,16473,16584,16659,16695,18021,18095,18242,18396,18397,19358,20252,20254,21371,21479,21690,22227,22229,22235,22237,22803,22948,22950,22951,22955,23879,23901,23902,24002,24024,24031,24076,24456,24491,24497,24498,24666,24777,24779,24780,24781,24783,24995,24996,24997,24998,24999,25000,25002,25060,25671,25692,25693,26967,27203,27447,27448,27681,27682,27683,27684,27899,27900,28121,28168,28390,28854,28982,29134,29135,29589,29626,29698,29724,29773,29807,29851,29991,30070,30197,30198,30553,30555,30584,30902,30918,30919,30925,30928,30961,31078,31116,31319,31444,31445,31446,31613,31816,31912,31921,32379,32380,32545,32552,32571,32710,32714,32736,32784,32785,32786,32787,32821,32822,32844,32851,32856,32857,32859,32877,32878,32911,32913,32958,32990,33063,33102,33103,33279,33280,33281,33282,33328,33524,33763,33801,33813,33881,33907,33908,34022,34112,34547,34574,34590,34591,34820,34822,34824,34888,34992,34993,35114,35222,35223,35226,35227,35541,35743,35833,35896,35900,35902,35905,36185,36266,36696,36713,36810,36855,36856,36890,37186,37187,37190,37445,37446,37565,37566,37569,37690,37752,37976,38027,38134,38472,38614,38656,38711,38715,38719,38720,38725,38726,38728,38729,38804,38893,39381,39384,39437,39617,39618,39660,39661,39906,40056,40057,40312,40498,40567,40811,40829,41087,41088,41201,41205,41287,41333,41370,42660,42958,43091,43284,43285,44754,44755,44756,44758,44884,44885,44903,44985,44987,44990,44992,45556,45584,45588,45621,45685,45686,46074,46349,46828,46878,46879,46880,46942,47150,47153,47156,47175,47195,47701,47755,55225,55273,55375,56532,58061,58077,58211,58729,58731,58732,59168,59169,59189,59190,59400,59402,60160,60412,60693,60860,60861,61008,61141,61142,61143,61146,61437,61804,62186,62486,62487,62488,62509,62511,62514,62740,62741,63104,63106,63620,65505,65707,65714,65831,65872,65875,65912,66572,66949,66955,66956,68189,68197,68420,68526,68527,69761,69788,70592,70593,70629,70630,70730,70731,72324,72657,72659,72660,73100,73105,73106,73110,74111,74112,74807,75093,75104,75192,75565,75566,75760,76455,76456,76881,77218,77318,77761,77766,77768,77769,77770,77771,77773,77775,77778,77779,77784,77787,77790,77791,77792,77794,77797,77806,77814,77816,77820,77841,78141,78143,78147,78150,78152,78153,78570,78914,78924,78997,79000,79002,79004,79005,79023,79024,79025,79026,79035,79036,79037,79045,79053,79069,79245,79501,79502,79555,79593,79807,79822,79824,79858,79859,79860,79949,79959,79970,80594,80691,80696,80697,80701,80702,80713,80722,80777,80791,80794,80796,80807,80876,80877,80879,80894,80896,80953,80972,80982,80986,80987,80994,81002,81030,81055,81056,81093,81094,82973,82974,83508,83758,83759,83766,83767,83838,84447,85125,85678,85829,85893,86036,86038,86523,86524,86640,86947,86960,87006,87280,87400,87401,87512,87559,87630,87665,87672,88113,88283,88284,88369,88394,88448,88449,88450,88873,88943,89038,89039,89131,89499,89500,89501,89502,89547,89549,89550,89607,89608,90257,91466,91670,91812,91813,91814,91815,91816,91868,92106,93623,94220,94407,94619,94748,95419,95420,95423,96319,96331,96470,96484,96485,96489,96505,96524,96590,96721,96722,96814,97342,97706,97707,98081,98128,98146,98147,98156,98160,98307,98309,98977,98978,99031,99032,99033,99050,99290,99301,99302,99359,99367,99408,99475,99528,99531,99534,99535,99833,100714,100715,100716,100717,100719,100724,100727,100728,100781,100783,100786,101237,101238,101239,101966,103326,103540,103550,103758,103887,104005,104006,104007,104153,104475,104477,104699,104700,105678,105771,105772,105927,105928,105929,105966,105970,105988,106015,106027,106110,106111,106244,106423,106455,106456,106457,106458,106652,106796,106832,106903,106904,106905,106906,107014,107020,107071,107137,107138,107139,107140,107141,107142,107144,107145,107146,107148,107150,107169,107172,107249,107252,107255,107268,107307,107342,107434,107549,107552,107646,107942,107944,107977,108000,108091,108137,108209,108210,108211,108332,108333,108456,108526,108694,108698,108758,108829,108839,108848,108851,109112,109496,109500,109520,109687,109757,109758,109930,109932,110200,110201,110238,110256,110331,110344,110352,110354,110356,110358,110365,110412,110443,110500,110505,110506,110507,110508,110512,110513,110584,110585,110697,110698,110699,110879,111028,111146,111147,111163,111207,111394,111406,111407,111770,111813,111814,111915,111917,111918,111919,111920,111922,111986,111987,111990,112430,112498,112511,112513,112693,112694,112702,113013,113015,113124,113128,113129,113139,113140,113193,113194,113250,113251,113252,113304,113391,113395,113402,113403,113404,113700,113737,113975,113983,114184,114336,114338,114341,114342,114348,114421,114422,114507,114668,114697,114699,114724,114738,114739,114741,114747,114748,114755,114757,114762,114763,114776,114777,114778,114781,114861,114865,114866,115215,115216,115217,115218,115219,115223,115225,115226,115227,115228,115229,115231,115234,115236,115261,115372,115373,115374,115378,115380,115424,115551,115552,115554,115555,115669,115764,115791,115816,115934,115935,115976,116040,116041,116049,116052,116156,116179,116188,116275,116285,116378,116494,116594,116728,116785,116817,116818,116857,117285,117446,117448,117449,117450,117464,117471,117545,117736,117924,117930,117932,117933,118044,118412,118413,118591,118756,118759,118761,118995,119002,119037,119413,119414,119449,119454,119455,119795,119797,119935,120016,120017,120018,120020,120689,120743,120788,121007,121036,121605,121607,121608,121614,121618,121776,121893,121945,122136,122142,122143,122144,122145,122173,122326,122381,122401,123031,123036,123813,123826,123828,123830,123831,123832,123833,123834,125303,125304,125314,125357,125359,126070,126269,126273,126274,126275,126328,126434,126471,126472,126549,126550,126651,126791,127389,127409,127512,127513,127514,127515,128061,128396,128413,128414,128416,128418,128463,128473,128613,128758,129393,129432,129433,129434,129436,129446,129447,129453,129623,129677,129742,129787,130178,130540,130733,130783,130927,130960,131065,131071,131072,131076,131180,131183,131281,131371,131372,131374,131375,131546,131547,131548,132018,132036,132046,132047,132048,132121,132233,132286,132288,132289,132666,132667,132668,132687,132702,132773,132774,133079,133080,133081,133086,133105,133106,133180,133337,133508,133512,133550,133562,133683,133685,133686,133749,133771,133772,133921,133929,133930,133931,133932,134241,134243,134245,134403,134926,134971,134972,134974,135253,135629,135630,135631,135632,135633,135634,135726,135734,135735,135736,135740,135744,135782,135917,135920,135924,135925,135926,135927,136085,136208,136210,136406,136422,136524,136528,136609,136784,136788,136789,136794,137039,137344,137345,137346,137383,137384,137388,137412,137416,137690,138169,138170,138763,138791,138876,138879,139144,139410,139531,139532,139533,139534,139542,139553,139554,139555,139834,139835,139836,139837,139838,139839,139840,140377,140572,140772,141250,141251,141254,141350,141352,141354,141568,141569,141680,141751,141774,141807,141822,142286,142451,142595,142602,142603,142604,142611,142754,142755,142756,142813,142814,142846,142847,142848,143104,143105,143106,143511,143735,143736,143737,143832,143850,143851,144052,144088,144298,144299,144300,144301,144513,144794,144795,144947,144962,144979,144980,145088,145230,145231,145239,145320,145321,145325,145326,145327,145328,145366,145367,146062,146093,146094,146141,146144,146383,146744,146758,146759,146896,147048,147226,147256,147257,147258,147328,147334,147335,147336,147337,147339,147341,147342,147343,147346,147349,147355,147360,147362,147363,147365,147428,147581,147582,147709,147732,148002,148003,148009,148029,148030,148111,148112,148200,148257,148258,148318,149079,149081,149130,149131,149132,149141,149142,149143,149393,149829,150238,150271,150308,151315,151458,151459,151506,151507,151521,151522,151595,151777,151789,152142,152146,152148,152528,152630,152779,152792,152793,152986,153262,153299,153345,153397,153559,153562,153581,153802,153908,153997,154064,154126,154386,154486,154714,154837,155261,155264,155265,155266,155295,155296,156280,156300,156302,156303,156945,157205,157788,157813,158335,158563,158566,158795,158797,158801,159107,159360,159363,159365,159367,159371,159379,159589,159590,160066,160089,160097,160129,160133,160233,160370,160371,160413,161835,161839,161840,162199,162460,163314,164812,164813,164814,165742,166465,166770,166771,166797,167192,167812,167813,167908,167909,167910,167975,168009,168010,168110,168111,168416,168525,168871,168873,168991,168992,169224,169225,169226,169345,169346,169347,169372,169373,169396,169397,169398,170205,170728,170795,170915,170985,170991,171140,171141,171143,171144,171145,171237,171390,171880,172064,172472,173672,173739,174061,174084,174250,174251,174252,174253,175669,175857,176432,176516,176518,176699,176720,176741,177248,177319,177387,177635,177977,178340,178501,178502,178504,178505,178513,178514,178515,178524,178526,178527,178528,178531,178532,178533,178535,178536,178539,178544,178545,178546,178547,178548,178552,178553,178554,178557,178558,178559,178561,178562,178563,178566,178567,178569,178570,178573,178575,178576,178577,178578,178579,178580,178582,178583,178584,178587,178588,178589,178590,178591,178592,178593,178594,178595,178596,178597,178598,178599,178600,178601,178603,178604,178605,178606,178609,178611,178612,178613,178614,178618,178619,178621,178624,178625,178626,178627,178628,178630,178633,178634,178635,178636,178639,178640,178642,178643,178644,178645,178646,178647,178648,178649,178650,178651,178652,178653,178655,178658,178659,178660,178661,178662,178663,178664,178665,178666,178667,178668,178669,178675,178676,178779,178780,179214,179242,179246,179249,179255,179258,179620,179850,180086,180127,180159,180163,180164,180165,180636,180637,180892,181024,181091,181092,181093,181094,181095,181171,181281,181290,181294,181297,181299,181300,181301,181302,181303,181304,181306,181534,181535,181536,181539,181540,181541,181543,181752,181872,181912,182250,182567,182577,182695,183871,184953,184954,184955,184962,185352) AND `brand_id` > 0 [ RunTime:0.015573s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.000918s ]
SELECT * FROM `tp_brand` WHERE `id` IN (42,47,29,68,225,49,95,229,67,25,272,70,73,172,144,157,33,337,260,115,255,23,291,187,123) LIMIT 30 [ RunTime:0.000221s ]
SELECT * FROM `tp_goods` WHERE `is_on_sale` = 1 AND `goods_id` IN (700,714,735,1107,1153,1163,1292,1657,1699,2193,2324,2333,2335,2387,2392,2406,2423,2429,2430,2432,2443,2456,2477,2544,2810,2863,2887,2888,2931,2998,3451,4035,4036,4192,4198,4213,4230,4231,4281,4284,4289,4296,4309,4315,4316,4319,4320,4322,4328,4329,4336,4339,4341,4342,4348,4349,4350,4353,4386,4779,4890,4902,4920,4950,5047,5048,5178,5180,5182,5183,5185,5187,5189,5197,5216,5218,5259,5288,5294,5340,5341,5348,5350,5355,5356,5357,5359,5362,5369,5376,5380,5383,5395,5396,5397,5402,5405,5407,5510,5719,5765,5863,5994,6027,6028,6035,6159,6167,6168,6186,6212,6223,6480,6483,6484,6485,6487,6488,6489,6977,7040,7041,7080,7084,7288,7435,7450,7503,7696,7834,7969,7971,8033,8035,8214,10904,11064,13657,13795,13798,13841,13919,13923,13924,13958,14208,14211,14215,14222,14224,14225,14226,14227,14296,14299,14306,14308,14541,14546,14650,14651,16320,16324,16325,16469,16473,16584,16659,16695,18021,18095,18242,18396,18397,19358,20252,20254,21371,21479,21690,22227,22229,22235,22237,22803,22948,22950,22951,22955,23879,23901,23902,24002,24024,24031,24076,24456,24491,24497,24498,24666,24777,24779,24780,24781,24783,24995,24996,24997,24998,24999,25000,25002,25060,25671,25692,25693,26967,27203,27447,27448,27681,27682,27683,27684,27899,27900,28121,28168,28390,28854,28982,29134,29135,29589,29626,29698,29724,29773,29807,29851,29991,30070,30197,30198,30553,30555,30584,30902,30918,30919,30925,30928,30961,31078,31116,31319,31444,31445,31446,31613,31816,31912,31921,32379,32380,32545,32552,32571,32710,32714,32736,32784,32785,32786,32787,32821,32822,32844,32851,32856,32857,32859,32877,32878,32911,32913,32958,32990,33063,33102,33103,33279,33280,33281,33282,33328,33524,33763,33801,33813,33881,33907,33908,34022,34112,34547,34574,34590,34591,34820,34822,34824,34888,34992,34993,35114,35222,35223,35226,35227,35541,35743,35833,35896,35900,35902,35905,36185,36266,36696,36713,36810,36855,36856,36890,37186,37187,37190,37445,37446,37565,37566,37569,37690,37752,37976,38027,38134,38472,38614,38656,38711,38715,38719,38720,38725,38726,38728,38729,38804,38893,39381,39384,39437,39617,39618,39660,39661,39906,40056,40057,40312,40498,40567,40811,40829,41087,41088,41201,41205,41287,41333,41370,42660,42958,43091,43284,43285,44754,44755,44756,44758,44884,44885,44903,44985,44987,44990,44992,45556,45584,45588,45621,45685,45686,46074,46349,46828,46878,46879,46880,46942,47150,47153,47156,47175,47195,47701,47755,55225,55273,55375,56532,58061,58077,58211,58729,58731,58732,59168,59169,59189,59190,59400,59402,60160,60412,60693,60860,60861,61008,61141,61142,61143,61146,61437,61804,62186,62486,62487,62488,62509,62511,62514,62740,62741,63104,63106,63620,65505,65707,65714,65831,65872,65875,65912,66572,66949,66955,66956,68189,68197,68420,68526,68527,69761,69788,70592,70593,70629,70630,70730,70731,72324,72657,72659,72660,73100,73105,73106,73110,74111,74112,74807,75093,75104,75192,75565,75566,75760,76455,76456,76881,77218,77318,77761,77766,77768,77769,77770,77771,77773,77775,77778,77779,77784,77787,77790,77791,77792,77794,77797,77806,77814,77816,77820,77841,78141,78143,78147,78150,78152,78153,78570,78914,78924,78997,79000,79002,79004,79005,79023,79024,79025,79026,79035,79036,79037,79045,79053,79069,79245,79501,79502,79555,79593,79807,79822,79824,79858,79859,79860,79949,79959,79970,80594,80691,80696,80697,80701,80702,80713,80722,80777,80791,80794,80796,80807,80876,80877,80879,80894,80896,80953,80972,80982,80986,80987,80994,81002,81030,81055,81056,81093,81094,82973,82974,83508,83758,83759,83766,83767,83838,84447,85125,85678,85829,85893,86036,86038,86523,86524,86640,86947,86960,87006,87280,87400,87401,87512,87559,87630,87665,87672,88113,88283,88284,88369,88394,88448,88449,88450,88873,88943,89038,89039,89131,89499,89500,89501,89502,89547,89549,89550,89607,89608,90257,91466,91670,91812,91813,91814,91815,91816,91868,92106,93623,94220,94407,94619,94748,95419,95420,95423,96319,96331,96470,96484,96485,96489,96505,96524,96590,96721,96722,96814,97342,97706,97707,98081,98128,98146,98147,98156,98160,98307,98309,98977,98978,99031,99032,99033,99050,99290,99301,99302,99359,99367,99408,99475,99528,99531,99534,99535,99833,100714,100715,100716,100717,100719,100724,100727,100728,100781,100783,100786,101237,101238,101239,101966,103326,103540,103550,103758,103887,104005,104006,104007,104153,104475,104477,104699,104700,105678,105771,105772,105927,105928,105929,105966,105970,105988,106015,106027,106110,106111,106244,106423,106455,106456,106457,106458,106652,106796,106832,106903,106904,106905,106906,107014,107020,107071,107137,107138,107139,107140,107141,107142,107144,107145,107146,107148,107150,107169,107172,107249,107252,107255,107268,107307,107342,107434,107549,107552,107646,107942,107944,107977,108000,108091,108137,108209,108210,108211,108332,108333,108456,108526,108694,108698,108758,108829,108839,108848,108851,109112,109496,109500,109520,109687,109757,109758,109930,109932,110200,110201,110238,110256,110331,110344,110352,110354,110356,110358,110365,110412,110443,110500,110505,110506,110507,110508,110512,110513,110584,110585,110697,110698,110699,110879,111028,111146,111147,111163,111207,111394,111406,111407,111770,111813,111814,111915,111917,111918,111919,111920,111922,111986,111987,111990,112430,112498,112511,112513,112693,112694,112702,113013,113015,113124,113128,113129,113139,113140,113193,113194,113250,113251,113252,113304,113391,113395,113402,113403,113404,113700,113737,113975,113983,114184,114336,114338,114341,114342,114348,114421,114422,114507,114668,114697,114699,114724,114738,114739,114741,114747,114748,114755,114757,114762,114763,114776,114777,114778,114781,114861,114865,114866,115215,115216,115217,115218,115219,115223,115225,115226,115227,115228,115229,115231,115234,115236,115261,115372,115373,115374,115378,115380,115424,115551,115552,115554,115555,115669,115764,115791,115816,115934,115935,115976,116040,116041,116049,116052,116156,116179,116188,116275,116285,116378,116494,116594,116728,116785,116817,116818,116857,117285,117446,117448,117449,117450,117464,117471,117545,117736,117924,117930,117932,117933,118044,118412,118413,118591,118756,118759,118761,118995,119002,119037,119413,119414,119449,119454,119455,119795,119797,119935,120016,120017,120018,120020,120689,120743,120788,121007,121036,121605,121607,121608,121614,121618,121776,121893,121945,122136,122142,122143,122144,122145,122173,122326,122381,122401,123031,123036,123813,123826,123828,123830,123831,123832,123833,123834,125303,125304,125314,125357,125359,126070,126269,126273,126274,126275,126328,126434,126471,126472,126549,126550,126651,126791,127389,127409,127512,127513,127514,127515,128061,128396,128413,128414,128416,128418,128463,128473,128613,128758,129393,129432,129433,129434,129436,129446,129447,129453,129623,129677,129742,129787,130178,130540,130733,130783,130927,130960,131065,131071,131072,131076,131180,131183,131281,131371,131372,131374,131375,131546,131547,131548,132018,132036,132046,132047,132048,132121,132233,132286,132288,132289,132666,132667,132668,132687,132702,132773,132774,133079,133080,133081,133086,133105,133106,133180,133337,133508,133512,133550,133562,133683,133685,133686,133749,133771,133772,133921,133929,133930,133931,133932,134241,134243,134245,134403,134926,134971,134972,134974,135253,135629,135630,135631,135632,135633,135634,135726,135734,135735,135736,135740,135744,135782,135917,135920,135924,135925,135926,135927,136085,136208,136210,136406,136422,136524,136528,136609,136784,136788,136789,136794,137039,137344,137345,137346,137383,137384,137388,137412,137416,137690,138169,138170,138763,138791,138876,138879,139144,139410,139531,139532,139533,139534,139542,139553,139554,139555,139834,139835,139836,139837,139838,139839,139840,140377,140572,140772,141250,141251,141254,141350,141352,141354,141568,141569,141680,141751,141774,141807,141822,142286,142451,142595,142602,142603,142604,142611,142754,142755,142756,142813,142814,142846,142847,142848,143104,143105,143106,143511,143735,143736,143737,143832,143850,143851,144052,144088,144298,144299,144300,144301,144513,144794,144795,144947,144962,144979,144980,145088,145230,145231,145239,145320,145321,145325,145326,145327,145328,145366,145367,146062,146093,146094,146141,146144,146383,146744,146758,146759,146896,147048,147226,147256,147257,147258,147328,147334,147335,147336,147337,147339,147341,147342,147343,147346,147349,147355,147360,147362,147363,147365,147428,147581,147582,147709,147732,148002,148003,148009,148029,148030,148111,148112,148200,148257,148258,148318,149079,149081,149130,149131,149132,149141,149142,149143,149393,149829,150238,150271,150308,151315,151458,151459,151506,151507,151521,151522,151595,151777,151789,152142,152146,152148,152528,152630,152779,152792,152793,152986,153262,153299,153345,153397,153559,153562,153581,153802,153908,153997,154064,154126,154386,154486,154714,154837,155261,155264,155265,155266,155295,155296,156280,156300,156302,156303,156945,157205,157788,157813,158335,158563,158566,158795,158797,158801,159107,159360,159363,159365,159367,159371,159379,159589,159590,160066,160089,160097,160129,160133,160233,160370,160371,160413,161835,161839,161840,162199,162460,163314,164812,164813,164814,165742,166465,166770,166771,166797,167192,167812,167813,167908,167909,167910,167975,168009,168010,168110,168111,168416,168525,168871,168873,168991,168992,169224,169225,169226,169345,169346,169347,169372,169373,169396,169397,169398,170205,170728,170795,170915,170985,170991,171140,171141,171143,171144,171145,171237,171390,171880,172064,172472,173672,173739,174061,174084,174250,174251,174252,174253,175669,175857,176432,176516,176518,176699,176720,176741,177248,177319,177387,177635,177977,178340,178501,178502,178504,178505,178513,178514,178515,178524,178526,178527,178528,178531,178532,178533,178535,178536,178539,178544,178545,178546,178547,178548,178552,178553,178554,178557,178558,178559,178561,178562,178563,178566,178567,178569,178570,178573,178575,178576,178577,178578,178579,178580,178582,178583,178584,178587,178588,178589,178590,178591,178592,178593,178594,178595,178596,178597,178598,178599,178600,178601,178603,178604,178605,178606,178609,178611,178612,178613,178614,178618,178619,178621,178624,178625,178626,178627,178628,178630,178633,178634,178635,178636,178639,178640,178642,178643,178644,178645,178646,178647,178648,178649,178650,178651,178652,178653,178655,178658,178659,178660,178661,178662,178663,178664,178665,178666,178667,178668,178669,178675,178676,178779,178780,179214,179242,179246,179249,179255,179258,179620,179850,180086,180127,180159,180163,180164,180165,180636,180637,180892,181024,181091,181092,181093,181094,181095,181171,181281,181290,181294,181297,181299,181300,181301,181302,181303,181304,181306,181534,181535,181536,181539,181540,181541,181543,181752,181872,181912,182250,182567,182577,182695,183871,184953,184954,184955,184962,185352) ORDER BY `sort` ASC LIMIT 940,20 [ RunTime:0.020892s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000770s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (79005,89501,160413,169373,178589,180637,127389,128413,19358,89502,110238,178590,119454,128414,81055,155295,35743,178591,180127,119455) [ RunTime:0.000327s ]
SHOW FULL COLUMNS FROM `tp_ad_position` [ RunTime:0.000628s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000154s ]
SHOW FULL COLUMNS FROM `tp_ad` [ RunTime:0.000626s ]
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.000171s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000144s ]
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.000166s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000158s ]
SELECT * FROM `tp_ad` WHERE ( pid=102 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000165s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000156s ]
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.000182s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000171s ]
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.000182s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000143s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000162s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000152s ]
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.000166s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000144s ]
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.000189s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000177s ]
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.000182s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000144s ]
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.000163s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000165s ]
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.000171s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000145s ]
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.000174s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000156s ]
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.000164s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000198s ]
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.000174s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000158s ]
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.000177s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000144s ]
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.000176s ]
SELECT * FROM `tp_navigation` where is_show = 1 and position = 'top' ORDER BY `sort` DESC [ RunTime:0.000172s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 335 LIMIT 1 [ RunTime:0.000166s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 351 LIMIT 1 [ RunTime:0.000280s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 355 LIMIT 1 [ RunTime:0.000166s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 357 LIMIT 1 [ RunTime:0.000162s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 363 LIMIT 1 [ RunTime:0.000150s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 79005 LIMIT 1 [ RunTime:0.000246s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 89501 LIMIT 1 [ RunTime:0.000217s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 160413 LIMIT 1 [ RunTime:0.000320s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 169373 LIMIT 1 [ RunTime:0.000213s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 178589 LIMIT 1 [ RunTime:0.000229s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 180637 LIMIT 1 [ RunTime:0.000223s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 127389 LIMIT 1 [ RunTime:0.000209s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 128413 LIMIT 1 [ RunTime:0.000235s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 19358 LIMIT 1 [ RunTime:0.000213s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 89502 LIMIT 1 [ RunTime:0.000222s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 110238 LIMIT 1 [ RunTime:0.000219s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 178590 LIMIT 1 [ RunTime:0.000233s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 119454 LIMIT 1 [ RunTime:0.000229s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 128414 LIMIT 1 [ RunTime:0.000206s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 81055 LIMIT 1 [ RunTime:0.000222s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 155295 LIMIT 1 [ RunTime:0.000225s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 35743 LIMIT 1 [ RunTime:0.000261s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 178591 LIMIT 1 [ RunTime:0.000300s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 180127 LIMIT 1 [ RunTime:0.000427s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 119455 LIMIT 1 [ RunTime:0.000277s ]
select * from `tp_slogan` [ RunTime:0.000156s ]
select * from `tp_article` where cat_id = 1 and is_open=1 limit 5 [ RunTime:0.000279s ]
select * from `tp_article` where cat_id = 2 and is_open=1 limit 5 [ RunTime:0.000250s ]
select * from `tp_article` where cat_id = 3 and is_open=1 limit 5 [ RunTime:0.000256s ]
select * from `tp_article` where cat_id = 4 and is_open=1 limit 5 [ RunTime:0.000235s ]
select * from `tp_article` where cat_id = 5 and is_open=1 limit 5 [ RunTime:0.000234s ]
