SHOW FULL COLUMNS FROM `tp_wx_user` [ RunTime:0.001253s ]
SELECT * FROM `tp_wx_user` WHERE ( w_token = "xkopzw1490691329" ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000307s ]
SHOW FULL COLUMNS FROM `tp_search_word` [ RunTime:0.000950s ]
UPDATE `tp_search_word` SET `search_num` = `search_num` + 1 WHERE `keywords` = '' [ RunTime:0.002575s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.001441s ]
SELECT COUNT(*) AS think_count FROM `tp_goods` WHERE ( `goods_name` LIKE '%%' OR `keywords` LIKE '%%' ) AND `is_on_sale` = 1 [ RunTime:0.000229s ]
SELECT * FROM `tp_search_word` WHERE `keywords` = '' LIMIT 1 [ RunTime:0.000273s ]
UPDATE `tp_search_word` SET `goods_num` = 33630 WHERE `id` = 7 [ RunTime:0.002102s ]
SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.001134s ]
SELECT * FROM `tp_goods_category` WHERE `name` LIKE '%%' LIMIT 1 [ RunTime:0.000256s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000252s ]
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.009742s ]
SELECT * FROM `tp_goods_category` WHERE `id` IN (380,789,594,605,379,606,608,659,609,611,612,615,617,619,621,672,624,641,640,642,372,639,54,607,343,0,588,628,589,382,374,345,634,376,635,636,377,373,620,788,647,618,381,591,375,344,700,603,597,595,723,592,660,651,671,712,715,784,644,614,658,770,598,726,783,805,796,346,771,795,780,797,668,378,764,826,610,855,596,798,755,799,590,749,760,756,627,754,593,616,803,802,704,853,852,774,820,613,691,348,699,645,838) [ RunTime:0.017453s ]
SELECT `goods_id` FROM `tp_goods` WHERE `brand_id` = 24 [ RunTime:0.000373s ]
SELECT `goods_id` FROM `tp_goods` WHERE ( shop_price >= 0 and shop_price <= 2180 ) [ RunTime:0.202623s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.003838s ]
SELECT `id`,`name` FROM `tp_brand` [ RunTime:0.000242s ]
SELECT * FROM `tp_goods` WHERE `is_on_sale` = 1 AND `goods_id` IN (871,877,1082,1293,1343,3269,3272,4812,4819,5113,5118,5124,5167,5302,5410,6122,6134,6149,6151,6152,7122,7125,7129,7133,14649,18580,24809,24810,24812,25724,28466,32257,32818,34152,35925,36066,36094,36707,43418,43419,43420,46303,47655,56564,60707,60708,63556,73193,75755,79127,79129,79134,79135,79164,79165,79967,83497,84511,84912,84915,84927,85058,85205,85422,85455,86059,86077,86078,87694,87697,89450,89562,89563,89668,90204,91094,91563,91729,91820,98976,106868,106869,106870,108035,110692,110693,111911,112496,112849,112949,112950,112951,113055,113122,113123,113584,114728,116923,116924,116925,116926,118797,119112,122387,122578,122584,125707,129386,129387,129403,131185,131186,131450,131451,131452,131453,133786,133787,133788,134236,136001,136002,138405,138942,139780,139875,140105,140106,140107,142622,142644,142818,142819,145590,146891,147326,149238,149239,149241,149255,149256,149717,149718,150832,152352,153601,157847,158726,160751,162000,164173,164797,166369,166485,169191,170196,170935,173736,173767,175872,176653,179847,180099,180103,181312,181313,181314,181522,181786,183513,186196,186197,186198,189088,189090,189091,189092,189093,189094,189095,189097,189099,189100,189101,189102,189105,189106,189107,189108,189109,189110,189111,189114,189115,189116,189117,189119,189121,189342,189343,189344,189345,189346,189347,189348,189349,189350,189351,189352,189353,189354,189355,189356,189357,189359,189360,189361,189362,189367,189369,189372,189624,189626,189629,189993,189996,189998,190251,190254,190255,190256,190257,190258,190259,190260,190262,190263,190264,190265,190266,190267,190269,190270,190271,190272,190273,190274,190275,190276,190278,190279,190280,190281,190282,190283,190284,190285,190286,190287,190288,190289,190290,190291,190292,190293,190294,190300,190302,190307,190312,190313,190315,190316,190318,190319,190321,190324,190326,190327,190328,190329,190330,190331,190338,190340,190341,190342,190343,190344,190345,190347,190348,190349,190350,190352,190354,190355,190356,190359,190363,190366,190367,190369,190370,190371,190372,190373,190374,190376,190377,190380,190382,190386,190387,190390,190391,190392,190393,190394,190395,190398,190399,190400,190401,190402,190403,190404,190405,190406,190407,190408,190410,190411,190412,190413,190414,190415,190416,190417,190418,190419,190420,190421,190422,190423,190424,190426,190427,190428,190429,190430,190431,190433,190434,190435,190436,190437,190439,190440,190442,190443,190650,190652,190654,190655,190658,190659,190660,191721,191796,191797,192861,193095,193097,193101,194918,198021,198392,198667,198671,199327,199750,199799,200892,201412,201761,201837,202031,202858,203214,203215,203625,203723,204016,204024,204025,204026,204027,204028,204802,206432,207508,207509,207510,207511,207516,208935,208957,210080,210756,210804,216273,217148,218200,218255,219496,220459) ORDER BY `sort` ASC LIMIT 320,20 [ RunTime:0.005347s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000931s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (146891,190411,4812,190412,190413,203214,190414,203215,85455,190415,162000,190416,216273,190417,122578,190418,190419,170196,190420,149717) [ RunTime:0.000376s ]
SHOW FULL COLUMNS FROM `tp_ad_position` [ RunTime:0.001163s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000171s ]
SHOW FULL COLUMNS FROM `tp_ad` [ RunTime:0.000941s ]
SELECT * FROM `tp_ad` WHERE ( pid=101 and enabled = 1 and start_time < 1761847200 and end_time > 1761847200 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000196s ]
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 < 1761847200 and end_time > 1761847200 ) 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.000179s ]
SELECT * FROM `tp_ad` WHERE ( pid=102 and enabled = 1 and start_time < 1761847200 and end_time > 1761847200 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000172s ]
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 < 1761847200 and end_time > 1761847200 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000186s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000161s ]
SELECT * FROM `tp_ad` WHERE ( pid=103 and enabled = 1 and start_time < 1761847200 and end_time > 1761847200 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000168s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000147s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1761847200 and end_time > 1761847200 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000168s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000168s ]
SELECT * FROM `tp_ad` WHERE ( pid=104 and enabled = 1 and start_time < 1761847200 and end_time > 1761847200 ) 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.000157s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1761847200 and end_time > 1761847200 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000185s ]
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 < 1761847200 and end_time > 1761847200 ) 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.000128s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1761847200 and end_time > 1761847200 ) 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.000172s ]
SELECT * FROM `tp_ad` WHERE ( pid=106 and enabled = 1 and start_time < 1761847200 and end_time > 1761847200 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000223s ]
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 < 1761847200 and end_time > 1761847200 ) 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.000175s ]
SELECT * FROM `tp_ad` WHERE ( pid=107 and enabled = 1 and start_time < 1761847200 and end_time > 1761847200 ) 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.000155s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1761847200 and end_time > 1761847200 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000182s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000159s ]
SELECT * FROM `tp_ad` WHERE ( pid=108 and enabled = 1 and start_time < 1761847200 and end_time > 1761847200 ) 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.000160s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1761847200 and end_time > 1761847200 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000166s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000171s ]
SELECT * FROM `tp_ad` WHERE ( pid=109 and enabled = 1 and start_time < 1761847200 and end_time > 1761847200 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000187s ]
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 < 1761847200 and end_time > 1761847200 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000166s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000162s ]
SELECT * FROM `tp_ad` WHERE ( pid=110 and enabled = 1 and start_time < 1761847200 and end_time > 1761847200 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000182s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000164s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1761847200 and end_time > 1761847200 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000175s ]
SELECT * FROM `tp_navigation` where is_show = 1 and position = 'top' ORDER BY `sort` DESC [ RunTime:0.000176s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 363 LIMIT 1 [ RunTime:0.000194s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 383 LIMIT 1 [ RunTime:0.000154s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 400 LIMIT 1 [ RunTime:0.000151s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 416 LIMIT 1 [ RunTime:0.000151s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 430 LIMIT 1 [ RunTime:0.000151s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 146891 LIMIT 1 [ RunTime:0.000283s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 190411 LIMIT 1 [ RunTime:0.000228s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 4812 LIMIT 1 [ RunTime:0.000226s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 190412 LIMIT 1 [ RunTime:0.000312s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 190413 LIMIT 1 [ RunTime:0.000208s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 203214 LIMIT 1 [ RunTime:0.000223s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 190414 LIMIT 1 [ RunTime:0.000262s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 203215 LIMIT 1 [ RunTime:0.000364s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 85455 LIMIT 1 [ RunTime:0.000212s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 190415 LIMIT 1 [ RunTime:0.000232s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 162000 LIMIT 1 [ RunTime:0.000221s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 190416 LIMIT 1 [ RunTime:0.000212s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 216273 LIMIT 1 [ RunTime:0.000225s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 190417 LIMIT 1 [ RunTime:0.000210s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 122578 LIMIT 1 [ RunTime:0.000218s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 190418 LIMIT 1 [ RunTime:0.000222s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 190419 LIMIT 1 [ RunTime:0.000224s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 170196 LIMIT 1 [ RunTime:0.000227s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 190420 LIMIT 1 [ RunTime:0.000261s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 149717 LIMIT 1 [ RunTime:0.000235s ]
select * from `tp_slogan` [ RunTime:0.000146s ]
select * from `tp_article` where cat_id = 1 and is_open=1 limit 5 [ RunTime:0.000184s ]
select * from `tp_article` where cat_id = 2 and is_open=1 limit 5 [ RunTime:0.000167s ]
select * from `tp_article` where cat_id = 3 and is_open=1 limit 5 [ RunTime:0.000160s ]
select * from `tp_article` where cat_id = 4 and is_open=1 limit 5 [ RunTime:0.000172s ]
select * from `tp_article` where cat_id = 5 and is_open=1 limit 5 [ RunTime:0.000171s ]
