SHOW FULL COLUMNS FROM `tp_wx_user` [ RunTime:0.001261s ]
SELECT * FROM `tp_wx_user` WHERE ( w_token = "xkopzw1490691329" ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000333s ]
SHOW FULL COLUMNS FROM `tp_search_word` [ RunTime:0.000696s ]
UPDATE `tp_search_word` SET `search_num` = `search_num` + 1 WHERE `keywords` = '冰箱' [ RunTime:0.002473s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.001656s ]
SELECT COUNT(*) AS think_count FROM `tp_goods` WHERE ( `goods_name` LIKE '%冰箱%' OR `keywords` LIKE '%冰箱%' ) AND `is_on_sale` = 1 [ RunTime:0.188173s ]
SELECT * FROM `tp_search_word` WHERE `keywords` = '冰箱' LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tp_search_word` SET `goods_num` = 2587 WHERE `id` = 10 [ RunTime:0.002802s ]
SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000661s ]
SELECT * FROM `tp_goods_category` WHERE `name` LIKE '%冰箱%' LIMIT 1 [ RunTime:0.000218s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000174s ]
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 (378,379,380,381,382,588,589,645,647,789,853) and is_virtual <> 2 and is_on_sale =1 ) [ RunTime:0.183439s ]
SELECT * FROM `tp_goods_category` WHERE `id` IN (380,789,379,588,382,589,381,647,0,378,617,853) [ RunTime:0.000370s ]
SELECT `goods_id` FROM `tp_goods` WHERE `brand_id` = 33 [ RunTime:0.000959s ]
SELECT `goods_id` FROM `tp_goods` WHERE ( shop_price >= 0 and shop_price <= 1360 ) [ RunTime:0.192377s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.003248s ]
SELECT `id`,`name` FROM `tp_brand` [ RunTime:0.000292s ]
SELECT * FROM `tp_goods` WHERE `is_on_sale` = 1 AND `goods_id` IN (2373,2376,2377,2397,2404,2566,2903,2904,2984,4313,4357,4364,4370,4374,4515,4516,4519,4523,4524,4525,4543,4556,4561,4577,4587,4602,4630,4631,4724,4755,4758,4759,4762,5070,5141,5144,5146,5176,5295,6161,6397,7835,7908,7915,13793,13959,14311,14312,14554,14556,14557,14559,16020,16362,18010,18274,18275,18821,19083,19301,19796,20886,20941,20943,20944,20946,20947,20950,20951,20953,20954,20955,20958,20959,23027,23739,24931,25017,25019,25400,25401,25402,25403,25404,25749,25833,26314,26458,26593,26594,26630,28416,28418,28421,28854,28920,29462,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,36110,36111,36316,36319,36687,36951,36953,37032,37033,38884,40059,40061,40062,40065,43026,43122,44781,44782,44839,44842,44908,45761,46053,46782,46825,46884,46885,46887,46888,46894,47183,47206,47207,48403,48409,56229,56512,56520,58727,61020,61137,61139,61140,61764,61766,62973,62975,64485,65144,65877,65878,65939,66564,66826,67129,67130,68593,68594,68595,68596,69565,70733,73764,74404,75710,76512,76914,76916,78510,78642,79112,79456,79462,79467,79469,79470,79471,79507,79509,79510,79514,79519,79521,79522,79523,79526,79528,79532,79542,79545,79548,79551,79557,79558,79560,79845,79848,79850,79926,80814,80825,80830,80838,80844,80845,81059,81060,81072,83095,85188,85826,85921,86007,86008,86079,86080,86081,86082,86083,86084,86085,86086,86087,86088,86089,86093,86100,86102,86103,86107,86108,86109,86110,86497,86529,86531,86532,86533,86676,86677,86678,86682,86885,86959,86994,87344,87468,87676,87677,88960,90919,93974,94003,94004,94005,94744,94749,94783,96367,96373,96549,96705,97460,97702,97703,97704,97705,97731,97732,97733,97734,97862,97869,98766,98767,98768,98769,98770,98771,98772,98773,98785,98788,98793,98794,98795,98796,99054,99294,99454,99456,99547,99568,99744,100240,100442,103845,103847,103859,104784,104785,106875,106884,107030,107274,108928,110611,110829,112200,112659,113572,113830,113851,114437,114886,115367,115387,115743,116809,116811,116812,117006,117012,118199,118244,118410,118719,119434,119921,120788,121039,121040,121782,121928,122572,123827,126603,127968,128787,129592,130274,131188,131476,131477,131478,131479,131512,132625,132626,132694,132767,133429,133504,134656,134745,135010,135196,135733,135987,136207,136797,136940,136964,136965,136966,138514,138715,138875,139625,139864,140102,140103,140330,141187,141812,142203,142306,142307,142540,142541,142556,142653,142672,143197,143448,143606,143650,143651,143653,143818,144102,144514,144936,145019,145027,145051,145058,146050,146595,146760,146887,146888,146894,147698,150218,150220,150225,151044,152807,152989,154506,154577,154578,154579,154590,154729,154843,154846,155283,155301,156044,156278,156279,156282,157089,158550,158551,158556,158557,160447,161587,162039,162040,162466,164754,165756,165757,165760,165762,166801,167757,168506,168818,170753,170798,170892,171898,172876,174276,174739,176652,177724,178849,178911,179797,179800,179884,179957,179958,180088,180439,180902,181376,181404,181405,181549,182763,182764,186282,186307,186308,187814,187836,187866,189909,189914,189918,190425,190517,191950,192014,192036,192037,192040,192045,192051,192052,195329,196790,198874,200770,200923,201115,201291,202084,202740) ORDER BY `sort` ASC LIMIT 540,20 [ RunTime:0.006722s ]
SHOW FULL COLUMNS FROM `tp_ad_position` [ RunTime:0.000745s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000256s ]
SHOW FULL COLUMNS FROM `tp_ad` [ RunTime:0.000679s ]
SELECT * FROM `tp_ad` WHERE ( pid=101 and enabled = 1 and start_time < 1753034400 and end_time > 1753034400 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000262s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000224s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1753034400 and end_time > 1753034400 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000243s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000235s ]
SELECT * FROM `tp_ad` WHERE ( pid=102 and enabled = 1 and start_time < 1753034400 and end_time > 1753034400 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000236s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000230s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1753034400 and end_time > 1753034400 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000246s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000240s ]
SELECT * FROM `tp_ad` WHERE ( pid=103 and enabled = 1 and start_time < 1753034400 and end_time > 1753034400 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000234s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000225s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1753034400 and end_time > 1753034400 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000241s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000227s ]
SELECT * FROM `tp_ad` WHERE ( pid=104 and enabled = 1 and start_time < 1753034400 and end_time > 1753034400 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000234s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000217s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1753034400 and end_time > 1753034400 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000292s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000186s ]
SELECT * FROM `tp_ad` WHERE ( pid=105 and enabled = 1 and start_time < 1753034400 and end_time > 1753034400 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000194s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000171s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1753034400 and end_time > 1753034400 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000181s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000206s ]
SELECT * FROM `tp_ad` WHERE ( pid=106 and enabled = 1 and start_time < 1753034400 and end_time > 1753034400 ) 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.000155s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1753034400 and end_time > 1753034400 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000169s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000176s ]
SELECT * FROM `tp_ad` WHERE ( pid=107 and enabled = 1 and start_time < 1753034400 and end_time > 1753034400 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000184s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000171s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1753034400 and end_time > 1753034400 ) 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.000206s ]
SELECT * FROM `tp_ad` WHERE ( pid=108 and enabled = 1 and start_time < 1753034400 and end_time > 1753034400 ) 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.000164s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1753034400 and end_time > 1753034400 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000196s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000189s ]
SELECT * FROM `tp_ad` WHERE ( pid=109 and enabled = 1 and start_time < 1753034400 and end_time > 1753034400 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000188s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000168s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1753034400 and end_time > 1753034400 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000179s ]
SELECT * FROM `tp_navigation` where is_show = 1 and position = 'top' ORDER BY `sort` DESC [ RunTime:0.000174s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 351 LIMIT 1 [ RunTime:0.000293s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 355 LIMIT 1 [ RunTime:0.000296s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 363 LIMIT 1 [ RunTime:0.000276s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 383 LIMIT 1 [ RunTime:0.000284s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 400 LIMIT 1 [ RunTime:0.000304s ]
select * from `tp_slogan` [ RunTime:0.000173s ]
select * from `tp_article` where cat_id = 1 and is_open=1 limit 5 [ RunTime:0.000187s ]
select * from `tp_article` where cat_id = 2 and is_open=1 limit 5 [ RunTime:0.000189s ]
select * from `tp_article` where cat_id = 3 and is_open=1 limit 5 [ RunTime:0.000201s ]
select * from `tp_article` where cat_id = 4 and is_open=1 limit 5 [ RunTime:0.000224s ]
select * from `tp_article` where cat_id = 5 and is_open=1 limit 5 [ RunTime:0.000189s ]