SHOW FULL COLUMNS FROM `tp_wx_user` [ RunTime:0.000947s ]
SELECT * FROM `tp_wx_user` WHERE ( w_token = "xkopzw1490691329" ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000267s ]
SHOW FULL COLUMNS FROM `tp_search_word` [ RunTime:0.000555s ]
UPDATE `tp_search_word` SET `search_num` = `search_num` + 1 WHERE `keywords` = '' [ RunTime:0.002685s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.001021s ]
SELECT COUNT(*) AS think_count FROM `tp_goods` WHERE ( `goods_name` LIKE '%%' OR `keywords` LIKE '%%' ) AND `is_on_sale` = 1 [ RunTime:0.000205s ]
SELECT * FROM `tp_search_word` WHERE `keywords` = '' LIMIT 1 [ RunTime:0.000246s ]
UPDATE `tp_search_word` SET `goods_num` = 23712 WHERE `id` = 7 [ RunTime:0.001829s ]
SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000590s ]
SELECT * FROM `tp_goods_category` WHERE `name` LIKE '%%' LIMIT 1 [ RunTime:0.000173s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000155s ]
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.003672s ]
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.001089s ]
SELECT `goods_id` FROM `tp_goods` WHERE `brand_id` = 33 [ RunTime:0.000868s ]
SELECT `goods_id` FROM `tp_goods` WHERE ( shop_price >= 0 and shop_price <= 1980 ) [ RunTime:0.163935s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.002963s ]
SELECT `id`,`name` FROM `tp_brand` [ RunTime:0.000272s ]
SELECT * FROM `tp_goods` WHERE `is_on_sale` = 1 AND `goods_id` IN (2373,2376,2377,2397,2404,2566,2903,2984,4313,4364,4370,4374,4514,4516,4519,4523,4524,4556,4561,4577,4630,4631,4724,4755,4759,4762,5070,5141,5144,5176,5295,6161,6397,7835,7908,7915,13793,13959,14311,14312,14554,14556,14557,14559,16020,16362,18010,18274,18275,18821,19083,19300,19301,19796,20886,20928,20930,20941,20943,20944,20945,20946,20947,20950,20951,20953,20954,20955,20958,20959,23027,23739,24931,25017,25019,25401,25402,25403,25404,25606,25749,25833,26314,26458,26593,26594,26629,26630,28076,28416,28421,28854,28920,29462,29463,30023,30024,30199,30201,30437,30790,30857,31114,32047,32286,32439,32706,32708,32813,32908,32909,32994,33768,34467,34516,35218,35219,35220,35228,35229,35835,35900,35901,36086,36108,36319,36687,36951,36953,37032,37033,38884,39815,40059,40061,40062,40065,43026,43122,44781,44782,44839,44842,44869,44908,45761,46053,46782,46884,46885,46887,46888,46894,47183,47206,47207,48403,48409,56226,56227,56229,56512,56522,58727,59796,61020,61021,61136,61137,61139,61140,61764,61766,62973,62975,64485,65144,65877,65878,65939,66564,66826,67129,67130,68593,68594,68595,69565,70733,73764,74404,75710,76512,76914,76916,78510,78639,78640,78641,79112,79452,79456,79457,79462,79464,79467,79469,79506,79509,79510,79521,79522,79523,79526,79528,79530,79532,79535,79537,79539,79542,79543,79544,79547,79548,79550,79557,79558,79560,79561,79618,79846,79848,79850,79852,79926,80735,80737,80740,80827,80830,80836,80838,80844,80847,81072,83095,83677,85065,85188,85826,85921,86007,86008,86079,86080,86081,86082,86083,86084,86085,86088,86089,86097,86100,86103,86108,86109,86497,86529,86531,86532,86533,86676,86677,86678,86682,86885,86919,86959,86994,87468,87599,87676,87677,88960,89728,90919,93974,94003,94004,94005,94744,94749,94783,96373,96549,96705,97460,97702,97703,97704,97705,97731,97732,97733,97734,97862,97864,97865,97866,97869,98766,98767,98772,98773,98795,98796,98808,99294,99454,99456,99547,99568,99744,100442,103845,103847,104784,104785,106245,106875,106883,106884,106890,107030,107274,108928,110829,111003,112180,112200,112205,112659,113830,113851,114437,114746,114886,115367,115387,115743,116146,116809,116811,117006,117012,118199,118244,118410,118719,119557,119921,120788,121039,121040,121782,121928,123827,126603,128787,129592,130274,131188,131476,131477,131478,131479,131480,131483,131512,132625,132626,132694,133429,133504,134242,135010,135733,135987,136079,136080,136207,136797,136964,136966,137343,138514,138715,138875,139625,139864,140103,140330,141187,141812,142203,142306,142307,142540,142542,142549,142561,142653,142672,143197,143650,143651,143653,143818,144102,144514,145019,145027,145053,145056,146595,146760,146887,146888,146894,147698,150220,151044,152807,152989,154506,154578,154579,154590,154729,154844,154845,154846,155283,155301,156044,156278,157089,158550,158551,158554,158557,161587,162039,163315,164810,166801,167757,168818,170753,170798,171898,178773,179797,179884,179957,179958,180088,180439,180902,181176,183939) ORDER BY `sort` ASC LIMIT 360,20 [ RunTime:0.006100s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000779s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (7908,38884,118244,46053,64485,144102,14311,152807,14312,33768,25833,16362,7915,98795,79852,110829,99568,68594,147698,68595) [ RunTime:0.000225s ]
SHOW FULL COLUMNS FROM `tp_ad_position` [ RunTime:0.000611s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000196s ]
SHOW FULL COLUMNS FROM `tp_ad` [ RunTime:0.000576s ]
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.000189s ]
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 < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000206s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000177s ]
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.000154s ]
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 < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000165s ]
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 < 1746381600 and end_time > 1746381600 ) 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.000139s ]
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.000152s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000148s ]
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.000219s ]
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 < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000175s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000139s ]
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.000163s ]
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 < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000165s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000142s ]
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.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 < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000156s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000182s ]
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.000162s ]
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.000193s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000153s ]
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.000160s ]
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.000174s ]
SELECT * FROM `tp_navigation` where is_show = 1 and position = 'top' ORDER BY `sort` DESC [ RunTime:0.000160s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 335 LIMIT 1 [ RunTime:0.000176s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 351 LIMIT 1 [ RunTime:0.000145s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 355 LIMIT 1 [ RunTime:0.000145s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 357 LIMIT 1 [ RunTime:0.000137s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 363 LIMIT 1 [ RunTime:0.000133s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 7908 LIMIT 1 [ RunTime:0.000231s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 38884 LIMIT 1 [ RunTime:0.000184s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 118244 LIMIT 1 [ RunTime:0.000190s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 46053 LIMIT 1 [ RunTime:0.000194s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 64485 LIMIT 1 [ RunTime:0.000182s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 144102 LIMIT 1 [ RunTime:0.000216s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 14311 LIMIT 1 [ RunTime:0.000209s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 152807 LIMIT 1 [ RunTime:0.000316s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 14312 LIMIT 1 [ RunTime:0.000277s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33768 LIMIT 1 [ RunTime:0.000299s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 25833 LIMIT 1 [ RunTime:0.000357s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 16362 LIMIT 1 [ RunTime:0.000223s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 7915 LIMIT 1 [ RunTime:0.000193s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 98795 LIMIT 1 [ RunTime:0.000246s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 79852 LIMIT 1 [ RunTime:0.000198s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 110829 LIMIT 1 [ RunTime:0.000215s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 99568 LIMIT 1 [ RunTime:0.000185s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 68594 LIMIT 1 [ RunTime:0.000249s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 147698 LIMIT 1 [ RunTime:0.000199s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 68595 LIMIT 1 [ RunTime:0.000183s ]
select * from `tp_slogan` [ RunTime:0.000171s ]
select * from `tp_article` where cat_id = 1 and is_open=1 limit 5 [ RunTime:0.000167s ]
select * from `tp_article` where cat_id = 2 and is_open=1 limit 5 [ RunTime:0.000141s ]
select * from `tp_article` where cat_id = 3 and is_open=1 limit 5 [ RunTime:0.000154s ]
select * from `tp_article` where cat_id = 4 and is_open=1 limit 5 [ RunTime:0.000151s ]
select * from `tp_article` where cat_id = 5 and is_open=1 limit 5 [ RunTime:0.000138s ]
