SHOW FULL COLUMNS FROM `tp_wx_user` [ RunTime:0.001422s ]
SELECT * FROM `tp_wx_user` WHERE ( w_token = "xkopzw1490691329" ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000535s ]
SHOW FULL COLUMNS FROM `tp_search_word` [ RunTime:0.000882s ]
UPDATE `tp_search_word` SET `search_num` = `search_num` + 1 WHERE `keywords` = '美的' [ RunTime:0.002530s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.001743s ]
SELECT COUNT(*) AS think_count FROM `tp_goods` WHERE ( `goods_name` LIKE '%美的%' OR `keywords` LIKE '%美的%' ) AND `is_on_sale` = 1 [ RunTime:0.000261s ]
SELECT * FROM `tp_search_word` WHERE `keywords` = '美的' LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tp_search_word` SET `goods_num` = 3306 WHERE `id` = 9 [ RunTime:0.002131s ]
SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000865s ]
SELECT * FROM `tp_goods_category` WHERE `name` LIKE '%美的%' LIMIT 1 [ RunTime:0.000236s ]
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.000656s ]
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.000483s ]
SELECT `goods_id` FROM `tp_goods` WHERE `brand_id` = 43 [ RunTime:0.000511s ]
SELECT `goods_id` FROM `tp_goods` WHERE ( shop_price >= 0 and shop_price <= 2686 ) [ RunTime:0.302112s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.003795s ]
SELECT `id`,`name` FROM `tp_brand` [ RunTime:0.000227s ]
SELECT * FROM `tp_goods` WHERE `is_on_sale` = 1 AND `goods_id` IN (334,338,965,967,1117,2036,2037,2084,2269,2558,3065,4420,4425,4457,4465,4467,4487,4733,4792,4793,4795,4837,5468,5469,5470,6031,6032,6041,8244,16583,21381,21382,21388,22662,24190,24892,26029,26041,26367,31837,32364,32378,32567,33779,36196,36716,36717,40974,44874,45760,45961,45967,45968,46972,47053,47187,47333,54041,56565,56566,58728,61002,62943,62945,62947,64192,64194,73616,75314,76883,76884,76885,79195,79214,79237,79241,80685,81100,85799,86873,89160,89451,90261,90262,90263,91415,95584,96581,98033,100499,101412,101413,101414,101415,101416,101418,101420,101421,101424,101428,101431,103137,103140,106203,106679,107890,110395,110396,110397,110398,110590,110591,111914,112640,112641,113695,113994,114592,114598,114745,114884,115386,115814,115977,117740,117746,119683,120583,120584,129252,129384,131465,131466,131472,131473,131474,131475,131566,131715,132194,132282,134419,134912,134913,135008,135009,135662,135663,136245,136265,136408,138048,138051,139789,142308,143210,144099,144100,144341,144342,144343,144348,145675,145676,145678,145679,145696,145700,145713,145714,145715,145716,145722,145723,146118,146195,147422,151199,151300,153218,154060,154375,155698,155699,157269,158405,159201,162524,162525,162526,166423,166472,166473,168612,169145,169146,174892,176311,176313,176426,176589,177123,179274,179959,179960,179961,179962,179963,179964,179965,179966,179968,180027,181887,183695,184959,184960,185080,186159,186161,192169,192209,192314,192315,192464,193061,194732,194733,194734,194867,195334,198719,198720,198723,198754,198756,201714,203023,203024,203212,203594,203595,203596,203597,204258,204259,204664,205257,206578,207337,207338,208511,208713,209717,211612,211932,212951,215541,215557,216674,217331,217982,218209,218339,222179,224430,224796,225198,225962,226144,229765,232369,235240,236226,236398,236400,236401,236402,236403,236508,236526,236549,236569,236619,236622,236634,236640,236976,237065,237066,237071,237556,237620,237625,237626,238078,239940,239999,240198,240200,240313,240315,240609,240610,240611,240612,240846,241018,241019,241259,241260,241261,242549,242550,242553,243471,243497,243503,243507,243511,243513,243516,243517,243518,243520,243521,243838,244321,244322,244323,244327,244329,244330,244382,244384,245637,245764,245949,246711,246817,247542,247627,247629,247633,248110,248111,248234,248636,249392,250157,251612,251640,251642,251675,251677,252947,253121,253858,253937,253964,254535,254657,255810,257160,258502,258503,258504,261206,261207,261641) ORDER BY `sort` ASC LIMIT 0,20 [ RunTime:0.004167s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000531s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (2558,4467,4487,21388,4793,64192,62943,33779,5468,5469,5470,4457,4465,32378,21382,64194,62945,62947,4837,334) [ RunTime:0.000203s ]
SHOW FULL COLUMNS FROM `tp_ad_position` [ RunTime:0.000500s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000167s ]
SHOW FULL COLUMNS FROM `tp_ad` [ RunTime:0.000500s ]
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.000173s ]
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 < 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.000144s ]
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.000141s ]
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 < 1780768800 and end_time > 1780768800 ) 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.000138s ]
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.000146s ]
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.000150s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000130s ]
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.000134s ]
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 < 1780768800 and end_time > 1780768800 ) 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 < 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.000119s ]
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.000133s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000128s ]
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.000138s ]
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.000140s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000150s ]
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.000148s ]
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.000155s ]
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.000167s ]
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 < 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.000155s ]
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.000153s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000155s ]
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.000167s ]
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.000158s ]
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 < 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=111 and enabled = 1 and start_time < 1780768800 and end_time > 1780768800 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000158s ]
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 < 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.000145s ]
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.000155s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000122s ]
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.000153s ]
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.000164s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000140s ]
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.000153s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000163s ]
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.000167s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000139s ]
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 * FROM `tp_navigation` where is_show = 1 and position = 'top' ORDER BY `sort` DESC [ RunTime:0.000151s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 351 LIMIT 1 [ RunTime:0.000160s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 357 LIMIT 1 [ RunTime:0.000138s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 363 LIMIT 1 [ RunTime:0.000134s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 383 LIMIT 1 [ RunTime:0.000141s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 384 LIMIT 1 [ RunTime:0.000139s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 2558 LIMIT 1 [ RunTime:0.000233s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 4467 LIMIT 1 [ RunTime:0.000200s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 4487 LIMIT 1 [ RunTime:0.000180s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 21388 LIMIT 1 [ RunTime:0.000184s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 4793 LIMIT 1 [ RunTime:0.000183s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 64192 LIMIT 1 [ RunTime:0.000542s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 62943 LIMIT 1 [ RunTime:0.000363s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33779 LIMIT 1 [ RunTime:0.000225s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 5468 LIMIT 1 [ RunTime:0.000181s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 5469 LIMIT 1 [ RunTime:0.000268s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 5470 LIMIT 1 [ RunTime:0.000190s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 4457 LIMIT 1 [ RunTime:0.000180s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 4465 LIMIT 1 [ RunTime:0.000189s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32378 LIMIT 1 [ RunTime:0.000178s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 21382 LIMIT 1 [ RunTime:0.000189s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 64194 LIMIT 1 [ RunTime:0.000196s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 62945 LIMIT 1 [ RunTime:0.000187s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 62947 LIMIT 1 [ RunTime:0.000197s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 4837 LIMIT 1 [ RunTime:0.000387s ]
select * from `tp_slogan` [ RunTime:0.000165s ]
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.000151s ]
select * from `tp_article` where cat_id = 3 and is_open=1 limit 5 [ RunTime:0.000138s ]
select * from `tp_article` where cat_id = 4 and is_open=1 limit 5 [ RunTime:0.000157s ]
select * from `tp_article` where cat_id = 5 and is_open=1 limit 5 [ RunTime:0.000160s ]
