SHOW FULL COLUMNS FROM `tp_wx_user` [ RunTime:0.000912s ]
SELECT * FROM `tp_wx_user` WHERE ( w_token = "xkopzw1490691329" ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000297s ]
SHOW FULL COLUMNS FROM `tp_search_word` [ RunTime:0.000494s ]
UPDATE `tp_search_word` SET `search_num` = `search_num` + 1 WHERE `keywords` = '美的' [ RunTime:0.002478s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.001041s ]
SELECT COUNT(*) AS think_count FROM `tp_goods` WHERE ( `goods_name` LIKE '%美的%' OR `keywords` LIKE '%美的%' ) AND `is_on_sale` = 1 [ RunTime:0.271796s ]
SELECT * FROM `tp_search_word` WHERE `keywords` = '美的' LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tp_search_word` SET `goods_num` = 3306 WHERE `id` = 9 [ RunTime:0.002577s ]
SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000667s ]
SELECT * FROM `tp_goods_category` WHERE `name` LIKE '%美的%' LIMIT 1 [ RunTime:0.000203s ]
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.264456s ]
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.000511s ]
SELECT `goods_id` FROM `tp_goods` WHERE `brand_id` = 42 [ RunTime:0.000923s ]
SELECT `goods_id` FROM `tp_goods` WHERE ( shop_price >= 0 and shop_price <= 2686 ) [ RunTime:0.277977s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.003746s ]
SELECT `id`,`name` FROM `tp_brand` [ RunTime:0.000203s ]
SELECT * FROM `tp_goods` WHERE `is_on_sale` = 1 AND `goods_id` IN (702,2327,8034,18095,76881,94619,96484,99666,105970,110344,111986,111987,112696,115373,115380,116275,131281,143104,143105,143550,143551,144546,146383,147226,147334,147335,147336,147366,148003,151506,151507,151789,155264,155265,159587,164119,164120,165742,168871,168872,169346,169351,169372,169373,170914,170915,171139,171140,171142,173671,173672,177141,178812,179850,180603,182996,184239,191996,196571,196572,198159,198829,199121,199122,200328,200329,200453,201121,201122,202125,204506,206574,208710,209270,209271,210963,213434,213435,213436,214698,218320,218321,230762,235469,235470,235471,235472,235473,235474,235475,235476,236493,237007,237008,237475,237569,237575,237635,237972,239252,239990,240001,240842,243475,243547,243549,243785,244013,244272,244273,246294,247308,254933,257466) ORDER BY `sort` ASC LIMIT 0,20 [ RunTime:0.002017s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000541s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (2327,702,143104,143105,237569,200453,237575,110344,247308,198159,210963,243475,246294,164119,164120,147226,148003,244013,244272,244273) [ RunTime:0.000208s ]
SHOW FULL COLUMNS FROM `tp_ad_position` [ RunTime:0.000520s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000163s ]
SHOW FULL COLUMNS FROM `tp_ad` [ RunTime:0.000502s ]
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.000177s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000149s ]
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.000150s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000150s ]
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.000138s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000127s ]
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.000134s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000132s ]
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.000160s ]
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.000130s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000137s ]
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.000144s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000118s ]
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.000136s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000133s ]
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.000137s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000131s ]
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.000137s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000130s ]
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.000148s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000118s ]
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.000150s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000167s ]
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.000151s ]
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.000151s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000161s ]
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.000166s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000126s ]
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.000164s ]
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.000164s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000148s ]
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.000155s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000143s ]
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.000162s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000142s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1780768800 and end_time > 1780768800 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000142s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000141s ]
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.000149s ]
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 < 1780768800 and end_time > 1780768800 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000152s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000149s ]
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.000141s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000120s ]
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.000146s ]
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.000144s ]
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.000149s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000141s ]
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.000150s ]
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.000141s ]
SELECT * FROM `tp_navigation` where is_show = 1 and position = 'top' ORDER BY `sort` DESC [ RunTime:0.000152s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 351 LIMIT 1 [ RunTime:0.000181s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 357 LIMIT 1 [ RunTime:0.000203s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 363 LIMIT 1 [ RunTime:0.000157s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 383 LIMIT 1 [ RunTime:0.000145s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 384 LIMIT 1 [ RunTime:0.000130s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 2327 LIMIT 1 [ RunTime:0.000251s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 702 LIMIT 1 [ RunTime:0.000220s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 143104 LIMIT 1 [ RunTime:0.000222s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 143105 LIMIT 1 [ RunTime:0.000214s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 237569 LIMIT 1 [ RunTime:0.000246s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 200453 LIMIT 1 [ RunTime:0.000216s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 237575 LIMIT 1 [ RunTime:0.000204s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 110344 LIMIT 1 [ RunTime:0.000214s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 247308 LIMIT 1 [ RunTime:0.000209s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 198159 LIMIT 1 [ RunTime:0.000194s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 210963 LIMIT 1 [ RunTime:0.000186s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 243475 LIMIT 1 [ RunTime:0.000189s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 246294 LIMIT 1 [ RunTime:0.000263s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 164119 LIMIT 1 [ RunTime:0.000202s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 164120 LIMIT 1 [ RunTime:0.000184s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 147226 LIMIT 1 [ RunTime:0.000190s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 148003 LIMIT 1 [ RunTime:0.000186s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 244013 LIMIT 1 [ RunTime:0.000189s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 244272 LIMIT 1 [ RunTime:0.000190s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 244273 LIMIT 1 [ RunTime:0.000184s ]
select * from `tp_slogan` [ RunTime:0.000133s ]
select * from `tp_article` where cat_id = 1 and is_open=1 limit 5 [ RunTime:0.000171s ]
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.000146s ]
select * from `tp_article` where cat_id = 4 and is_open=1 limit 5 [ RunTime:0.000146s ]
select * from `tp_article` where cat_id = 5 and is_open=1 limit 5 [ RunTime:0.000136s ]
