SHOW FULL COLUMNS FROM `tp_wx_user` [ RunTime:0.000874s ]
SELECT * FROM `tp_wx_user` WHERE ( w_token = "xkopzw1490691329" ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000398s ]
SHOW FULL COLUMNS FROM `tp_search_word` [ RunTime:0.000573s ]
UPDATE `tp_search_word` SET `search_num` = `search_num` + 1 WHERE `keywords` = '美的' [ RunTime:0.002716s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.000981s ]
SELECT COUNT(*) AS think_count FROM `tp_goods` WHERE ( `goods_name` LIKE '%美的%' OR `keywords` LIKE '%美的%' ) AND `is_on_sale` = 1 [ RunTime:0.242696s ]
SELECT * FROM `tp_search_word` WHERE `keywords` = '美的' LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tp_search_word` SET `goods_num` = 3306 WHERE `id` = 9 [ RunTime:0.002324s ]
SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000652s ]
SELECT * FROM `tp_goods_category` WHERE `name` LIKE '%美的%' LIMIT 1 [ RunTime:0.000183s ]
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.254358s ]
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.000482s ]
SELECT `goods_id` FROM `tp_goods` WHERE `brand_id` = 63 [ RunTime:0.000783s ]
SELECT `goods_id` FROM `tp_goods` WHERE ( shop_price >= 0 and shop_price <= 2686 ) [ RunTime:0.271285s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.004042s ]
SELECT `id`,`name` FROM `tp_brand` [ RunTime:0.000230s ]
SELECT * FROM `tp_goods` WHERE `is_on_sale` = 1 AND `goods_id` IN (351,357,603,605,606,608,612,624,1073,3025,3282,3290,3415,3657,3792,3958,3973,4653,4669,5556,5563,5963,5966,6652,6842,7628,7635,7637,7640,7642,8264,16710,17852,21963,21964,21965,21975,22033,22440,22447,24373,26053,26175,26176,29231,29527,30905,35590,36226,39406,39812,40185,40227,43663,46637,46734,57872,64167,64169,64611,65322,94520,94522,97785,97788,100888,100914,103400,103401,103402,103404,104777,112268,114065,114066,114067,114068,114069,114070,114072,114880,120001,120594,120595,120597,121821,125757,125826,129490,131137,137216,137221,139646,139865,142972,143839,145161,151785,155933,156069,159234,160503,160530,162323,164324,164932,166919,168186,170228,170695,171064,171371,175117,176559,179305,180151,180759,181846,182578,187058,187107,187212,187215,187216,187225,187236,187237,187240,187242,187250,187258,187271,187278,187498,187508,187510,187513,187517,187519,187605,187615,187617,187620,187624,187626,187627,193562,193687,195208,200303,201804,202685,203177,203858,203861,203862,203863,204083,204084,204103,204323,206113,206579,206580,206582,206636,206734,208929,210205,216633,216758,216759,216761,216762,216764,216765,216766,216767,216769,216770,216771,216772,216780,216782,216783,216784,216788,216789,216795,216797,216801,216805,216809,217025,217026,217654,219528,222615,222616,225747,231622,233383,236058,238228,238285,242905,244501,246561,247247,247251,247254,247256,247259,247269,247271,247475,247479,247527,247533,247534,247538,250944,251359,251618,252167,253776,255203,255372,255373,255633,255640,255648,255649,257488) ORDER BY `sort` ASC LIMIT 0,20 [ RunTime:0.002761s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000523s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (137216,159234,137221,35590,166919,252167,145161,175117,57872,22033,160530,120594,162323,120595,244501,120597,180759,100888,236058,193562) [ RunTime:0.000190s ]
SHOW FULL COLUMNS FROM `tp_ad_position` [ RunTime:0.000502s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000181s ]
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.000189s ]
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 < 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.000157s ]
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.000236s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000217s ]
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.000183s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000193s ]
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.000197s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000183s ]
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.000203s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000204s ]
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.000226s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000185s ]
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.000195s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000195s ]
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.000204s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000186s ]
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.000209s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000198s ]
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.000204s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000188s ]
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.000190s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000210s ]
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.000198s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000184s ]
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.000192s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000210s ]
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.000219s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000180s ]
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.000234s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000200s ]
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.000202s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000182s ]
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.000208s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000204s ]
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.000213s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000180s ]
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.000196s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000193s ]
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.000210s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000178s ]
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.000195s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000198s ]
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.000202s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000187s ]
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.000202s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000199s ]
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.000220s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000183s ]
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.000201s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000206s ]
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.000212s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000186s ]
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.000193s ]
SELECT * FROM `tp_navigation` where is_show = 1 and position = 'top' ORDER BY `sort` DESC [ RunTime:0.000182s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 351 LIMIT 1 [ RunTime:0.000212s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 357 LIMIT 1 [ RunTime:0.000172s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 363 LIMIT 1 [ RunTime:0.000179s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 383 LIMIT 1 [ RunTime:0.000169s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 384 LIMIT 1 [ RunTime:0.000175s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 137216 LIMIT 1 [ RunTime:0.000283s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 159234 LIMIT 1 [ RunTime:0.000255s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 137221 LIMIT 1 [ RunTime:0.000231s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 35590 LIMIT 1 [ RunTime:0.000239s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 166919 LIMIT 1 [ RunTime:0.000439s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 252167 LIMIT 1 [ RunTime:0.000279s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 145161 LIMIT 1 [ RunTime:0.000244s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 175117 LIMIT 1 [ RunTime:0.000229s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 57872 LIMIT 1 [ RunTime:0.000247s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 22033 LIMIT 1 [ RunTime:0.000214s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 160530 LIMIT 1 [ RunTime:0.000235s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 120594 LIMIT 1 [ RunTime:0.000224s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 162323 LIMIT 1 [ RunTime:0.000232s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 120595 LIMIT 1 [ RunTime:0.000224s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 244501 LIMIT 1 [ RunTime:0.000215s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 120597 LIMIT 1 [ RunTime:0.000237s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 180759 LIMIT 1 [ RunTime:0.000261s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 100888 LIMIT 1 [ RunTime:0.000243s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 236058 LIMIT 1 [ RunTime:0.000219s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 193562 LIMIT 1 [ RunTime:0.000225s ]
select * from `tp_slogan` [ RunTime:0.000161s ]
select * from `tp_article` where cat_id = 1 and is_open=1 limit 5 [ RunTime:0.000191s ]
select * from `tp_article` where cat_id = 2 and is_open=1 limit 5 [ RunTime:0.000189s ]
select * from `tp_article` where cat_id = 3 and is_open=1 limit 5 [ RunTime:0.000184s ]
select * from `tp_article` where cat_id = 4 and is_open=1 limit 5 [ RunTime:0.000175s ]
select * from `tp_article` where cat_id = 5 and is_open=1 limit 5 [ RunTime:0.000185s ]
