SHOW FULL COLUMNS FROM `tp_wx_user` [ RunTime:0.000922s ]
SELECT * FROM `tp_wx_user` WHERE ( w_token = "xkopzw1490691329" ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000278s ]
SHOW FULL COLUMNS FROM `tp_search_word` [ RunTime:0.000552s ]
UPDATE `tp_search_word` SET `search_num` = `search_num` + 1 WHERE `keywords` = '美的' [ RunTime:0.003146s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.001171s ]
SELECT COUNT(*) AS think_count FROM `tp_goods` WHERE ( `goods_name` LIKE '%美的%' OR `keywords` LIKE '%美的%' ) AND `is_on_sale` = 1 [ RunTime:0.000259s ]
SELECT * FROM `tp_search_word` WHERE `keywords` = '美的' LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tp_search_word` SET `goods_num` = 2851 WHERE `id` = 9 [ RunTime:0.002575s ]
SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000663s ]
SELECT * FROM `tp_goods_category` WHERE `name` LIKE '%美的%' LIMIT 1 [ RunTime:0.000243s ]
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.000679s ]
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.000539s ]
SELECT `goods_id` FROM `tp_goods` WHERE `brand_id` = 75 [ RunTime:0.001062s ]
SELECT `goods_id` FROM `tp_goods` WHERE ( shop_price >= 0 and shop_price <= 1470 ) [ RunTime:0.178420s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.002763s ]
SELECT `id`,`name` FROM `tp_brand` [ RunTime:0.000216s ]
SELECT * FROM `tp_goods` WHERE `is_on_sale` = 1 AND `goods_id` IN (626,644,651,656,662,689,690,1684,1685,1795,1796,3302,3304,3821,3864,3959,5803,6638,6807,6813,6816,8245,8246,18411,18412,19311,19312,19416,19419,22436,22437,22438,22439,22456,22501,23375,24722,24752,24755,24756,24757,24758,26361,28459,28460,31198,31392,31393,31394,32256,32607,33501,34376,34380,34658,34659,38192,38197,38198,38199,40923,43315,43318,43319,43323,43326,43327,43659,46348,46630,46747,46749,56200,56269,57904,59426,62027,62028,62173,62174,62175,62176,62177,65950,65951,69772,75694,80265,80614,80615,80617,80618,80622,80623,80624,80631,80635,80636,80644,86934,87265,87488,87489,87572,87573,87574,87576,87577,87578,88807,88808,88810,88811,89565,89566,91091,92339,97145,97188,98757,99016,99017,99109,99110,99111,99695,99696,101911,104017,104773,105688,106820,106825,106826,107025,108873,108875,108876,108940,109159,109160,109652,110263,110267,112441,112563,112599,112600,113196,113769,115304,115305,115306,115307,115308,115310,115311,115313,115314,116450,119241,119294,119300,119301,119304,119798,121912,121914,122164,123462,123686,126232,126233,126648,130853,130921,130922,130936,130944,130945,134759,134761,135967,135969,135970,135975,135976,135977,135978,135982,138034,138239,138698,138699,139380,139560,139654,139655,139656,139657,139667,139868,139869,141473,141772,142646,142741,143168,143678,143837,145138,146314,147658,147659,151673,151675,151681,151682,151695,151696,151697,151698,151699,152151,152152,152154,155824,159343,160063,160253,160255,160256,160258,160259,160260,160261,160262,160265,160266,160267,160615,164885,164888,164889,164907,164908,164909,164910,164912,164914,164915,164916,164917,164919,164920,164921,164922,164924,164946,164948,166938,166939,166940,166959,166961,166962,166964,166965,166966,166969,166970,166971,166972,166973,166974,169313,170745,172332,177030,177031,177032,177033,177034,177035,177036,177037,177038,177039,177040,177041,177044,177045,177082,177083,177085,177086,177088,177089,177090,177091,177092,177093,177094,177095,177096,177097,177098,177099,177100,177101,177102,177103,177106,177107,177130,177131,179312,179549,179550,180289,180756,180757,180822,180823,180824,180825,180826,181099,181100,181105,181106,181107,181109,181110,181431,181432,181433,182379) ORDER BY `sort` ASC LIMIT 0,20 [ RunTime:0.003313s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000598s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (160256,32256,160258,160259,1796,80644,160260,119300,160261,119301,160262,119304,160265,160266,160267,46348,107025,87572,180756,87573) [ RunTime:0.000380s ]
SHOW FULL COLUMNS FROM `tp_ad_position` [ RunTime:0.000536s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000155s ]
SHOW FULL COLUMNS FROM `tp_ad` [ RunTime:0.000534s ]
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.000170s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000146s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000150s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000193s ]
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.000170s ]
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.000144s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000182s ]
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.000164s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000134s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000195s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000155s ]
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.000151s ]
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.000145s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000131s ]
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.000157s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000124s ]
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.000135s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000177s ]
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.000119s ]
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.000135s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000147s ]
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.000153s ]
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.000149s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000140s ]
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.000176s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000130s ]
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.000137s ]
SELECT * FROM `tp_navigation` where is_show = 1 and position = 'top' ORDER BY `sort` DESC [ RunTime:0.000143s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 335 LIMIT 1 [ RunTime:0.000246s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 351 LIMIT 1 [ RunTime:0.000206s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 355 LIMIT 1 [ RunTime:0.000188s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 357 LIMIT 1 [ RunTime:0.000189s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 363 LIMIT 1 [ RunTime:0.000193s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 160256 LIMIT 1 [ RunTime:0.000186s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32256 LIMIT 1 [ RunTime:0.000177s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 160258 LIMIT 1 [ RunTime:0.000170s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 160259 LIMIT 1 [ RunTime:0.000173s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 1796 LIMIT 1 [ RunTime:0.000185s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 80644 LIMIT 1 [ RunTime:0.000174s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 160260 LIMIT 1 [ RunTime:0.000530s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 119300 LIMIT 1 [ RunTime:0.000351s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 160261 LIMIT 1 [ RunTime:0.000199s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 119301 LIMIT 1 [ RunTime:0.000417s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 160262 LIMIT 1 [ RunTime:0.000197s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 119304 LIMIT 1 [ RunTime:0.000192s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 160265 LIMIT 1 [ RunTime:0.000273s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 160266 LIMIT 1 [ RunTime:0.000187s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 160267 LIMIT 1 [ RunTime:0.000233s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 46348 LIMIT 1 [ RunTime:0.000309s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 87572 LIMIT 1 [ RunTime:0.000212s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 180756 LIMIT 1 [ RunTime:0.000178s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 87573 LIMIT 1 [ RunTime:0.000256s ]
select * from `tp_slogan` [ RunTime:0.000143s ]
select * from `tp_article` where cat_id = 1 and is_open=1 limit 5 [ RunTime:0.000141s ]
select * from `tp_article` where cat_id = 2 and is_open=1 limit 5 [ RunTime:0.000141s ]
select * from `tp_article` where cat_id = 3 and is_open=1 limit 5 [ RunTime:0.000127s ]
select * from `tp_article` where cat_id = 4 and is_open=1 limit 5 [ RunTime:0.000139s ]
select * from `tp_article` where cat_id = 5 and is_open=1 limit 5 [ RunTime:0.000149s ]
