SHOW FULL COLUMNS FROM `tp_wx_user` [ RunTime:0.001265s ]
SELECT * FROM `tp_wx_user` WHERE ( w_token = "xkopzw1490691329" ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000330s ]
SHOW FULL COLUMNS FROM `tp_search_word` [ RunTime:0.000574s ]
UPDATE `tp_search_word` SET `search_num` = `search_num` + 1 WHERE `keywords` = '' [ RunTime:0.002763s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.000990s ]
SELECT COUNT(*) AS think_count FROM `tp_goods` WHERE ( `goods_name` LIKE '%%' OR `keywords` LIKE '%%' ) AND `is_on_sale` = 1 [ RunTime:0.147113s ]
SELECT * FROM `tp_search_word` WHERE `keywords` = '' LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tp_search_word` SET `goods_num` = 23712 WHERE `id` = 7 [ RunTime:0.002964s ]
SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000629s ]
SELECT * FROM `tp_goods_category` WHERE `name` LIKE '%%' LIMIT 1 [ RunTime:0.000208s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000187s ]
SELECT `goods_id`,`cat_id` FROM `tp_goods` WHERE ( `goods_name` LIKE '%%' OR `keywords` LIKE '%%' ) AND `is_on_sale` = 1 AND `is_virtual` <> 2 OR ( cat_id in (54,372,373,374,375,376,377,639,651,780) and is_virtual <> 2 and is_on_sale =1 ) [ RunTime:0.156799s ]
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,343,345,628,588,382,0,589,634,635,636,620,377,788,647,381,372,375,344,651,672,697,696,603,621,596,712,597,610,591,660,376,643,715,784,614,644,770,598,704,658,378,346,783,805,796,700,673,767,754,780,668,795,768,613,764,600,730,822,771,726,756,798,723,736,797,852,799,590,749,759,760,627,54,616,803,802,823,725,655,820,731,691,342,348,699) [ RunTime:0.000977s ]
SELECT `goods_id` FROM `tp_goods` WHERE `brand_id` = 49 [ RunTime:0.000451s ]
SELECT `goods_id` FROM `tp_goods` WHERE ( shop_price >= 0 and shop_price <= 1980 ) [ RunTime:0.162301s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.002815s ]
SELECT `id`,`name` FROM `tp_brand` [ RunTime:0.000198s ]
SELECT * FROM `tp_goods` WHERE `is_on_sale` = 1 AND `goods_id` IN (2193,2324,2443,3451,4386,4902,5407,6035,6223,7503,10904,16584,24491,25060,25671,29134,29135,29626,29724,32856,32857,32859,32911,32913,32990,33328,33801,33907,33908,36855,36856,37445,37446,37752,39381,39384,39617,39618,39660,39661,40829,43284,43285,44758,44990,46878,46879,46880,47195,58731,58732,59168,59169,61804,62509,63104,63106,70592,70593,78141,78143,78147,78150,78152,78153,79069,79858,79859,79860,79949,80713,80722,80953,81093,81094,83758,83759,83766,83767,83838,85125,86036,86038,86947,87006,87630,87672,88113,88394,88873,89038,89039,89131,90257,91868,94748,95423,96319,96505,98977,98978,99359,99408,100714,100715,100716,100717,100719,100724,100727,100728,101237,101238,101239,103326,103540,104699,104700,105927,105928,105929,106110,106455,106456,106457,106458,107552,107646,109112,109496,110256,110331,110365,110443,110505,110584,111028,111146,111147,111770,111813,111814,111915,111922,112511,112513,112693,112694,113013,113015,113140,113250,113251,113252,113402,113403,113404,114336,114341,114507,114747,114748,115223,116188,116728,117464,117924,117932,117933,118413,118756,118759,118761,118995,119002,119413,119414,121036,122136,125357,126553,126791,127409,127512,128061,128473,129434,129446,129447,130178,130540,131180,131183,131546,132018,132036,132037,132046,132047,132048,132288,132289,133086,133508,133562,133749,133771,133772,134241,134971,134972,134974,136406,136422,137416,137690,139410,139531,139532,139533,139534,141250,141251,141254,141680,141774,141807,142286,142451,142611,142756,142846,142847,142848,143735,143736,143737,143850,143851,144052,144088,144794,144795,144947,145088,145230,145231,145320,146062,146141,146144,146744,147256,147257,147258,147339,147341,147343,147346,147349,147362,147363,147428,147581,147582,147732,148002,148009,149079,150238,150271,151315,151458,151459,151521,151522,151595,151777,152528,152630,152779,153262,153299,153559,153562,153581,153802,153908,154126,155266,156302,156303,158797,158801,159107,160097,160233,161835,161839,162199,164304,166770,166771,166797,167192,168009,168010,168110,168111,168416,168525,168991,168992,169226,170205,175857,176432,176518,178573,178576,178579,178582,178583,178587,178589,178592,178618,178648,178649,178651,178663,180159,180163,180164,180165,180892,181091,181093,181095,181281,181290,181294,181306,181534,181535,181536,181539,181540,181541,181543,181872) ORDER BY `sort` ASC LIMIT 280,20 [ RunTime:0.004723s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000580s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (118756,136422,178663,118759,160233,118761,143850,143851,39660,130540,153581,39661,141807,175857,113140,36855,36856,110584,116728,96505) [ RunTime:0.000336s ]
SHOW FULL COLUMNS FROM `tp_ad_position` [ RunTime:0.000574s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000161s ]
SHOW FULL COLUMNS FROM `tp_ad` [ RunTime:0.000601s ]
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.000174s ]
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 < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000178s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000156s ]
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.000175s ]
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.000160s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000160s ]
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.000156s ]
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 < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000164s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000143s ]
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.000147s ]
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 < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000171s ]
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 < 1746381600 and end_time > 1746381600 ) 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.000137s ]
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 `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000147s ]
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.000176s ]
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.000153s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000140s ]
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.000170s ]
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 < 1746381600 and end_time > 1746381600 ) 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.000150s ]
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.000174s ]
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 < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000164s ]
SELECT * FROM `tp_navigation` where is_show = 1 and position = 'top' ORDER BY `sort` DESC [ RunTime:0.000171s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 335 LIMIT 1 [ RunTime:0.000187s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 351 LIMIT 1 [ RunTime:0.000141s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 355 LIMIT 1 [ RunTime:0.000144s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 357 LIMIT 1 [ RunTime:0.000161s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 363 LIMIT 1 [ RunTime:0.000134s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 118756 LIMIT 1 [ RunTime:0.000231s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 136422 LIMIT 1 [ RunTime:0.000196s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 178663 LIMIT 1 [ RunTime:0.000253s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 118759 LIMIT 1 [ RunTime:0.000238s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 160233 LIMIT 1 [ RunTime:0.000205s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 118761 LIMIT 1 [ RunTime:0.000219s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 143850 LIMIT 1 [ RunTime:0.000211s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 143851 LIMIT 1 [ RunTime:0.000131s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 39660 LIMIT 1 [ RunTime:0.000297s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 130540 LIMIT 1 [ RunTime:0.000187s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 153581 LIMIT 1 [ RunTime:0.000191s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 39661 LIMIT 1 [ RunTime:0.000286s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 141807 LIMIT 1 [ RunTime:0.000219s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 175857 LIMIT 1 [ RunTime:0.000211s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 36855 LIMIT 1 [ RunTime:0.000192s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 36856 LIMIT 1 [ RunTime:0.000194s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 110584 LIMIT 1 [ RunTime:0.000298s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 116728 LIMIT 1 [ RunTime:0.000190s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 96505 LIMIT 1 [ RunTime:0.000188s ]
select * from `tp_slogan` [ RunTime:0.000138s ]
select * from `tp_article` where cat_id = 1 and is_open=1 limit 5 [ RunTime:0.000270s ]
select * from `tp_article` where cat_id = 2 and is_open=1 limit 5 [ RunTime:0.000227s ]
select * from `tp_article` where cat_id = 3 and is_open=1 limit 5 [ RunTime:0.000267s ]
select * from `tp_article` where cat_id = 4 and is_open=1 limit 5 [ RunTime:0.000235s ]
select * from `tp_article` where cat_id = 5 and is_open=1 limit 5 [ RunTime:0.000226s ]
