SHOW FULL COLUMNS FROM `tp_config` [ RunTime:0.000657s ]
SELECT * FROM `tp_config` [ RunTime:0.000215s ]
SHOW FULL COLUMNS FROM `tp_wx_user` [ RunTime:0.000733s ]
SELECT * FROM `tp_wx_user` WHERE ( w_token = "xkopzw1490691329" ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000260s ]
SHOW FULL COLUMNS FROM `tp_search_word` [ RunTime:0.000499s ]
UPDATE `tp_search_word` SET `search_num` = `search_num` + 1 WHERE `keywords` = '美的' [ RunTime:0.003028s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.000983s ]
SELECT COUNT(*) AS think_count FROM `tp_goods` WHERE ( `goods_name` LIKE '%美的%' OR `keywords` LIKE '%美的%' ) AND `is_on_sale` = 1 [ RunTime:0.000213s ]
SELECT * FROM `tp_search_word` WHERE `keywords` = '美的' LIMIT 1 [ RunTime:0.000220s ]
UPDATE `tp_search_word` SET `goods_num` = 3306 WHERE `id` = 9 [ RunTime:0.002030s ]
SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000570s ]
SELECT * FROM `tp_goods_category` WHERE `name` LIKE '%美的%' LIMIT 1 [ RunTime:0.000195s ]
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.000566s ]
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.000403s ]
SELECT `goods_id` FROM `tp_goods` WHERE `brand_id` = 75 [ RunTime:0.000834s ]
SELECT `goods_id` FROM `tp_goods` WHERE ( shop_price >= 0 and shop_price <= 2686 ) [ RunTime:0.285837s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.003781s ]
SELECT `id`,`name` FROM `tp_brand` [ RunTime:0.000240s ]
SELECT * FROM `tp_goods` WHERE `is_on_sale` = 1 AND `goods_id` IN (626,644,651,653,656,689,690,1684,1685,1795,2121,2123,3302,3304,3864,3959,4719,5792,6263,6807,6813,6814,6816,8379,18411,19419,22435,22436,22456,23375,24722,24752,24755,24756,24757,24758,26361,31198,31392,31393,31394,33501,34376,34380,34658,34659,36042,38192,38199,43318,43319,43323,43326,43327,46348,46630,46747,46749,56269,57904,59426,62027,62028,62174,62175,62176,62177,65950,65951,69772,75694,80265,80614,80615,80631,80635,80636,80644,86933,87489,87572,87573,87574,87576,88810,89565,89566,92339,93392,97188,98689,98757,99016,99017,99109,99110,99111,101911,101919,101923,104017,104019,104773,106676,106820,106825,106826,107025,108875,108876,109160,109425,109506,109652,110263,110848,112441,112561,112562,112563,112599,112600,113196,113769,113990,114060,114782,114783,115224,115310,115314,116450,116637,119294,119300,119301,119303,119304,119798,122164,122166,123462,124343,126232,126233,129424,130853,130921,130922,130936,130944,130945,134639,134640,134755,134758,135975,138238,138239,138698,139380,139559,139560,139654,139656,139657,141473,141772,142646,143168,143678,145139,145141,146314,155800,156815,156816,159343,160063,160615,161972,161973,161974,164885,164910,164923,164924,164946,169046,169312,169313,169315,170149,170745,170872,171166,171786,171890,172332,172410,172411,172628,173713,175661,177802,177803,178687,178688,178825,178826,178827,178828,179312,179313,179359,180730,180735,180736,180737,180822,180823,180825,180826,181101,181109,181110,181431,181432,181433,181485,181486,182077,186147,189746,190973,191489,197853,197854,197856,197857,197858,200395,200592,203224,203556,203558,203659,204065,204088,204089,204100,204101,204114,204118,204119,204120,204220,206826,209400,209402,209404,215199,215865,216540,219281,219923,220206,224590,225389,229382,231758,233810,234480,234481,235481,235512,235531,235540,235542,235573,235585,235586,235590,235620,235630,235631,235666,235689,235703,235716,235717,235720,235731,235733,235745,235751,235760,235762,235768,235788,235799,235814,235816,235817,235819,235987,235993,236060,236841,237364,237365,237451,237761,237763,237764,237765,237766,237767,237769,237975,238201,238202,239923,239925,239926,239978,239992,239993,240043,240154,240400,240837,240838,240913,241329,242365,242956,242971,242974,242995,242997,242999,243000,243002,243045,243047,243050,243052,243053,243054,243058,243063,243066,244406,244488,247896,248910,248912,250957,252830,254658,255542,255549,255551,255552,255557,255801,255802,255812,256392,257465,257470,257471,259515) ORDER BY `sort` ASC LIMIT 0,20 [ RunTime:0.004218s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000563s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (110848,178688,180736,180737,191489,80644,119300,119301,229382,119303,244488,119304,171786,235531,235788,46348,242956,240400,107025,240913) [ RunTime:0.000203s ]
SHOW FULL COLUMNS FROM `tp_ad_position` [ RunTime:0.000511s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000158s ]
SHOW FULL COLUMNS FROM `tp_ad` [ RunTime:0.000521s ]
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.000175s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000135s ]
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.000160s ]
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.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.000140s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000125s ]
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.000134s ]
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.000131s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000129s ]
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.000189s ]
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.000152s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000164s ]
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.000163s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000160s ]
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.000170s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000150s ]
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.000189s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000181s ]
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.000191s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000164s ]
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.000155s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000150s ]
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.000162s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000154s ]
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.000165s ]
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.000187s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000175s ]
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.000169s ]
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.000149s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000161s ]
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.000160s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000135s ]
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.000147s ]
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.000142s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000123s ]
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.000143s ]
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.000151s ]
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 < 1780768800 and end_time > 1780768800 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000138s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000168s ]
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.000163s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000150s ]
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.000163s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000150s ]
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.000154s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000159s ]
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 * FROM `tp_navigation` where is_show = 1 and position = 'top' ORDER BY `sort` DESC [ RunTime:0.000147s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 351 LIMIT 1 [ RunTime:0.000170s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 357 LIMIT 1 [ RunTime:0.000153s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 363 LIMIT 1 [ RunTime:0.000159s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 383 LIMIT 1 [ RunTime:0.000133s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 384 LIMIT 1 [ RunTime:0.000150s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 110848 LIMIT 1 [ RunTime:0.000249s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 178688 LIMIT 1 [ RunTime:0.000218s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 180736 LIMIT 1 [ RunTime:0.000202s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 180737 LIMIT 1 [ RunTime:0.000191s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 191489 LIMIT 1 [ RunTime:0.000196s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 80644 LIMIT 1 [ RunTime:0.000187s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 119300 LIMIT 1 [ RunTime:0.000215s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 119301 LIMIT 1 [ RunTime:0.000182s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 229382 LIMIT 1 [ RunTime:0.000244s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 119303 LIMIT 1 [ RunTime:0.000338s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 244488 LIMIT 1 [ RunTime:0.000346s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 119304 LIMIT 1 [ RunTime:0.000336s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 171786 LIMIT 1 [ RunTime:0.000286s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 235531 LIMIT 1 [ RunTime:0.000260s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 235788 LIMIT 1 [ RunTime:0.000207s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 46348 LIMIT 1 [ RunTime:0.000231s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 242956 LIMIT 1 [ RunTime:0.000191s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 240400 LIMIT 1 [ RunTime:0.000188s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 240913 LIMIT 1 [ RunTime:0.000205s ]
select * from `tp_slogan` [ RunTime:0.000163s ]
select * from `tp_article` where cat_id = 1 and is_open=1 limit 5 [ RunTime:0.000150s ]
select * from `tp_article` where cat_id = 2 and is_open=1 limit 5 [ RunTime:0.000155s ]
select * from `tp_article` where cat_id = 3 and is_open=1 limit 5 [ RunTime:0.000137s ]
select * from `tp_article` where cat_id = 4 and is_open=1 limit 5 [ RunTime:0.000132s ]
select * from `tp_article` where cat_id = 5 and is_open=1 limit 5 [ RunTime:0.000133s ]
