SHOW FULL COLUMNS FROM `db_visit_48` [ RunTime:0.003102s ]
INSERT INTO `db_visit_48` SET `visit_type` = 'website' , `ip` = '44.192.114.32' , `visit_time` = 1656660445 [ RunTime:0.004522s ]
SELECT `ip` FROM `db_visit_48` WHERE `visit_time` IN (between,1656604800) GROUP BY `ip` [ RunTime:0.000414s ]
SELECT COUNT(*) AS think_count FROM `db_visit_48` WHERE `visit_time` IN (between,1656604800) [ RunTime:0.000386s ]
SELECT COUNT(*) AS think_count FROM `db_visit_48` WHERE `visit_time` IN (between,1656604800) AND `visit_type` = 'search' [ RunTime:0.000308s ]
SELECT COUNT(*) AS think_count FROM `db_visit_48` WHERE `visit_time` IN (between,1656604800) AND `visit_type` = 'website' [ RunTime:0.000465s ]
SELECT COUNT(*) AS think_count FROM `db_visit_48` WHERE `visit_time` IN (between,1656604800) AND `visit_type` = 'link' [ RunTime:0.000392s ]
SELECT COUNT(*) AS think_count FROM `db_visit_48` WHERE `visit_time` IN (between,1656604800) AND `visit_type` = 'search' AND `search_engine` = 'baidu' [ RunTime:0.000300s ]
SELECT COUNT(*) AS think_count FROM `db_visit_48` WHERE `visit_time` IN (between,1656604800) AND `visit_type` = 'search' AND `search_engine` = 'google' [ RunTime:0.000652s ]
SELECT COUNT(*) AS think_count FROM `db_visit_48` WHERE `visit_time` IN (between,1656604800) AND `visit_type` = 'search' AND `search_engine` = 'sogou' [ RunTime:0.000394s ]
SELECT COUNT(*) AS think_count FROM `db_visit_48` WHERE `visit_time` IN (between,1656604800) AND `visit_type` = 'search' AND `search_engine` = '360' [ RunTime:0.000327s ]
SELECT COUNT(*) AS think_count FROM `db_visit_48` WHERE `visit_time` IN (between,1656604800) AND `visit_type` = 'search' AND `search_engine` = 'bing' [ RunTime:0.000477s ]
SHOW FULL COLUMNS FROM `db_visit` [ RunTime:0.001735s ]
SELECT `id` FROM `db_visit` WHERE `daytime` = 1656604800 LIMIT 1 [ RunTime:0.000634s ]
SHOW FULL COLUMNS FROM `db_cat` [ RunTime:0.001642s ]
SELECT * FROM `db_cat` WHERE `catid` = 60 LIMIT 1 [ RunTime:0.000795s ]
SHOW FULL COLUMNS FROM `db_cat_data` [ RunTime:0.001314s ]
SELECT * FROM `db_cat_data` WHERE `catid` = 60 LIMIT 1 [ RunTime:0.000645s ]
SHOW FULL COLUMNS FROM `db_cms_pictures` [ RunTime:0.001668s ]
SELECT * FROM `db_cms_pictures` WHERE `id` = 410 LIMIT 1 [ RunTime:0.001142s ]
SHOW FULL COLUMNS FROM `db_cms_pictures_data` [ RunTime:0.001494s ]
SELECT * FROM `db_cms_pictures_data` WHERE `id` = 410 LIMIT 1 [ RunTime:0.000782s ]
SELECT * FROM `db_cms_pictures` WHERE `id` BETWEEN 400 AND 409 ORDER BY `id` ASC [ RunTime:0.001066s ]
SELECT * FROM `db_cms_pictures` WHERE `id` BETWEEN 411 AND 420 ORDER BY `id` ASC [ RunTime:0.001185s ]
SHOW FULL COLUMNS FROM `db_cms_picturesclass` [ RunTime:0.001682s ]
SELECT * FROM `db_cms_picturesclass` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000657s ]
SELECT * FROM `db_cms_picturesclass` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000622s ]
SELECT * FROM `db_cms_picturesclass` WHERE `id` = 67 LIMIT 1 [ RunTime:0.000764s ]
UPDATE `db_cms_pictures` SET `views` = `views` + 1 WHERE `id` = 410 [ RunTime:0.001184s ]
SELECT `title`,`id`,`catid` FROM `db_cms_pictures` WHERE `catid` = 60 AND `id` <> 410 AND `newstime` >= 1648092038 ORDER BY `newstime` ASC,`id` ASC LIMIT 1 [ RunTime:0.006060s ]
SELECT `titleurl`,`link` FROM `db_cms_pictures` WHERE `id` = 411 LIMIT 1 [ RunTime:0.000822s ]
SELECT `title`,`id`,`catid` FROM `db_cms_pictures` WHERE `catid` = 60 AND `id` <> 410 AND `newstime` <= 1648092038 ORDER BY `newstime` DESC,`id` DESC LIMIT 1 [ RunTime:0.005307s ]
SELECT `titleurl`,`link` FROM `db_cms_pictures` WHERE `id` = 421 LIMIT 1 [ RunTime:0.000784s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 53 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000743s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 54 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000525s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 56 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000443s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 57 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000578s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 64 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000596s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 65 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000409s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 66 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000444s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 67 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000435s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 68 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000455s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 55 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000388s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 58 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000462s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 59 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000521s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 69 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000895s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 70 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000453s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 71 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000513s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 72 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000519s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 61 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000716s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 73 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000594s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 74 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000526s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 75 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000723s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 76 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000767s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 77 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000713s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 92 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000768s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 62 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000564s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 78 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000528s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 79 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000459s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 80 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000504s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 81 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000393s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 82 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000430s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 91 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000371s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 63 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000464s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 83 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000507s ]
SHOW FULL COLUMNS FROM `db_cms_questions` [ RunTime:0.002865s ]
SELECT * FROM `db_cms_questions` WHERE `catid` IN (53,54,56,57,64,65,66,67,68,55,58,59,69,70,71,72,61,73,74,75,76,77,92,62,78,79,80,81,82,91,63,83) AND `title` LIKE '%茶叶%' ORDER BY `sort` ASC,`is_top` DESC,`is_good` DESC,`newstime` DESC [ RunTime:0.004259s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 53 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000551s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 54 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000454s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 56 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000479s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 57 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000412s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 64 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000399s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 65 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000465s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 66 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000495s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 67 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000524s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 68 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000560s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 55 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000453s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 58 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000472s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 59 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000653s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 69 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000517s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 70 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000531s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 71 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000506s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 72 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000680s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 61 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000538s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 73 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000459s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 74 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000536s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 75 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000592s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 76 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000503s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 77 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000887s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 92 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000558s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 62 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000502s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 78 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000423s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 79 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000525s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 80 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000483s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 81 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000700s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 82 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000576s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 91 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000493s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 63 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000441s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 83 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000497s ]
SELECT * FROM `db_cms_questions` WHERE `catid` IN (53,54,56,57,64,65,66,67,68,55,58,59,69,70,71,72,61,73,74,75,76,77,92,62,78,79,80,81,82,91,63,83) AND `title` LIKE '%茶类网站%' ORDER BY `sort` ASC,`is_top` DESC,`is_good` DESC,`newstime` DESC [ RunTime:0.004018s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 60 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000757s ]
SELECT * FROM `db_cms_pictures` WHERE `catid` = 60 AND `title` LIKE '%茶叶%' ORDER BY `sort` ASC,`is_top` DESC,`is_good` DESC,`newstime` DESC [ RunTime:0.009946s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 60 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000849s ]
SELECT * FROM `db_cms_pictures` WHERE `catid` = 60 AND `title` LIKE '%茶类网站%' ORDER BY `sort` ASC,`is_top` DESC,`is_good` DESC,`newstime` DESC [ RunTime:0.007061s ]
SHOW FULL COLUMNS FROM `phome_ecms_news` [ RunTime:0.002279s ]
SELECT * FROM `phome_ecms_news` WHERE `title` LIKE '%茶叶%' OR `title` LIKE '%黄色%' OR `title` LIKE '%扁平化设计%' ORDER BY `id` DESC LIMIT 20 [ RunTime:0.131467s ]
SELECT * FROM `phome_ecms_news` ORDER BY `id` DESC LIMIT 20 [ RunTime:0.000899s ]
SHOW FULL COLUMNS FROM `phome_enewsclass` [ RunTime:0.002461s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 9 LIMIT 1 [ RunTime:0.001300s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 9 LIMIT 1 [ RunTime:0.000690s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000641s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000938s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000867s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000820s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000903s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000760s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000715s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000990s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000711s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000677s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000918s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000899s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 18 LIMIT 1 [ RunTime:0.000938s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 67 LIMIT 1 [ RunTime:0.000938s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 71 LIMIT 1 [ RunTime:0.000977s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 69 LIMIT 1 [ RunTime:0.001007s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 71 LIMIT 1 [ RunTime:0.000782s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 72 LIMIT 1 [ RunTime:0.000691s ]
SHOW FULL COLUMNS FROM `db_cms_picture_juhe` [ RunTime:0.002019s ]
SELECT * FROM `db_cms_picture_juhe` WHERE `id` <> 0 AND `title` LIKE '%茶叶%' LIMIT 20 [ RunTime:0.000840s ]
SELECT * FROM `db_cms_picture_juhe` WHERE `id` <> 0 AND `title` LIKE '%黄色%' LIMIT 20 [ RunTime:0.000564s ]
SELECT * FROM `db_cms_picture_juhe` WHERE `id` <> 0 AND `title` LIKE '%扁平化设计%' LIMIT 20 [ RunTime:0.000564s ]
SELECT * FROM `db_cms_picture_juhe` WHERE `id` <> 0 ORDER BY `id` DESC LIMIT 20 [ RunTime:0.000645s ]
SHOW FULL COLUMNS FROM `db_cms_question_juhe` [ RunTime:0.002099s ]
SELECT * FROM `db_cms_question_juhe` WHERE `id` <> 0 AND `title` LIKE '%茶叶%' LIMIT 20 [ RunTime:0.000772s ]
SELECT * FROM `db_cms_question_juhe` WHERE `id` <> 0 AND `title` LIKE '%黄色%' LIMIT 20 [ RunTime:0.000646s ]
SELECT * FROM `db_cms_question_juhe` WHERE `id` <> 0 AND `title` LIKE '%扁平化设计%' LIMIT 20 [ RunTime:0.000492s ]
SELECT * FROM `db_cms_question_juhe` WHERE `id` <> 0 ORDER BY `id` DESC LIMIT 20 [ RunTime:0.000448s ]
57
