SHOW FULL COLUMNS FROM `db_visit_48` [ RunTime:0.001236s ]
INSERT INTO `db_visit_48` SET `visit_type` = 'website' , `ip` = '44.192.114.32' , `visit_time` = 1656665340 [ RunTime:0.004469s ]
SELECT `ip` FROM `db_visit_48` WHERE `visit_time` IN (between,1656604800) GROUP BY `ip` [ RunTime:0.000344s ]
SELECT COUNT(*) AS think_count FROM `db_visit_48` WHERE `visit_time` IN (between,1656604800) [ RunTime:0.000341s ]
SELECT COUNT(*) AS think_count FROM `db_visit_48` WHERE `visit_time` IN (between,1656604800) AND `visit_type` = 'search' [ RunTime:0.000257s ]
SELECT COUNT(*) AS think_count FROM `db_visit_48` WHERE `visit_time` IN (between,1656604800) AND `visit_type` = 'website' [ RunTime:0.000257s ]
SELECT COUNT(*) AS think_count FROM `db_visit_48` WHERE `visit_time` IN (between,1656604800) AND `visit_type` = 'link' [ RunTime:0.000258s ]
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.000280s ]
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.000243s ]
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.000236s ]
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.000248s ]
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.000190s ]
SHOW FULL COLUMNS FROM `db_visit` [ RunTime:0.001284s ]
SELECT `id` FROM `db_visit` WHERE `daytime` = 1656604800 LIMIT 1 [ RunTime:0.000375s ]
SHOW FULL COLUMNS FROM `db_cat` [ RunTime:0.002062s ]
SELECT * FROM `db_cat` WHERE `catid` = 60 LIMIT 1 [ RunTime:0.000795s ]
SHOW FULL COLUMNS FROM `db_cat_data` [ RunTime:0.001455s ]
SELECT * FROM `db_cat_data` WHERE `catid` = 60 LIMIT 1 [ RunTime:0.000548s ]
SHOW FULL COLUMNS FROM `db_cms_pictures` [ RunTime:0.001329s ]
SELECT * FROM `db_cms_pictures` WHERE `id` = 412 LIMIT 1 [ RunTime:0.000890s ]
SHOW FULL COLUMNS FROM `db_cms_pictures_data` [ RunTime:0.001002s ]
SELECT * FROM `db_cms_pictures_data` WHERE `id` = 412 LIMIT 1 [ RunTime:0.000599s ]
SELECT * FROM `db_cms_pictures` WHERE `id` BETWEEN 402 AND 411 ORDER BY `id` ASC [ RunTime:0.000933s ]
SELECT * FROM `db_cms_pictures` WHERE `id` BETWEEN 413 AND 422 ORDER BY `id` ASC [ RunTime:0.000996s ]
SHOW FULL COLUMNS FROM `db_cms_picturesclass` [ RunTime:0.001361s ]
SELECT * FROM `db_cms_picturesclass` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000666s ]
SELECT * FROM `db_cms_picturesclass` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000530s ]
SELECT * FROM `db_cms_picturesclass` WHERE `id` = 67 LIMIT 1 [ RunTime:0.000571s ]
UPDATE `db_cms_pictures` SET `views` = `views` + 1 WHERE `id` = 412 [ RunTime:0.001115s ]
SELECT `title`,`id`,`catid` FROM `db_cms_pictures` WHERE `catid` = 60 AND `id` <> 412 AND `newstime` >= 1648092038 ORDER BY `newstime` ASC,`id` ASC LIMIT 1 [ RunTime:0.005399s ]
SELECT `titleurl`,`link` FROM `db_cms_pictures` WHERE `id` = 410 LIMIT 1 [ RunTime:0.000685s ]
SELECT `title`,`id`,`catid` FROM `db_cms_pictures` WHERE `catid` = 60 AND `id` <> 412 AND `newstime` <= 1648092038 ORDER BY `newstime` DESC,`id` DESC LIMIT 1 [ RunTime:0.005404s ]
SELECT `titleurl`,`link` FROM `db_cms_pictures` WHERE `id` = 421 LIMIT 1 [ RunTime:0.000898s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 53 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000685s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 54 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000550s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 56 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000488s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 57 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000401s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 64 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000407s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 65 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000337s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 66 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000381s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 67 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000476s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 68 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000363s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 55 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000371s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 58 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000560s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 59 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000527s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 69 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000481s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 70 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000527s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 71 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000368s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 72 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000459s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 61 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000402s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 73 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000580s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 74 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000453s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 75 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000469s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 76 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000390s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 77 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000375s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 92 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000333s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 62 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000422s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 78 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000352s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 79 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000362s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 80 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000369s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 81 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000377s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 82 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000382s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 91 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000345s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 63 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000404s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 83 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000403s ]
SHOW FULL COLUMNS FROM `db_cms_questions` [ RunTime:0.001716s ]
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.004391s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 53 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000702s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 54 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000509s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 56 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000473s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 57 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000519s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 64 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000452s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 65 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000804s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 66 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000458s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 67 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000478s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 68 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000512s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 55 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000412s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 58 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000478s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 59 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000611s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 69 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000571s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 70 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000969s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 71 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000711s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 72 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000857s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 61 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000540s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 73 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000721s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 74 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000490s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 75 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000640s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 76 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000623s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 77 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000599s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 92 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000523s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 62 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000549s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 78 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000503s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 79 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000491s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 80 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000472s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 81 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000482s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 82 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000420s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 91 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000349s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 63 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000401s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 83 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000423s ]
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.003305s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 60 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000529s ]
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.006573s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 60 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000766s ]
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.007281s ]
SHOW FULL COLUMNS FROM `phome_ecms_news` [ RunTime:0.001639s ]
SELECT * FROM `phome_ecms_news` WHERE `title` LIKE '%茶叶%' OR `title` LIKE '%黄色%' OR `title` LIKE '%扁平化设计%' ORDER BY `id` DESC LIMIT 20 [ RunTime:0.122076s ]
SELECT * FROM `phome_ecms_news` ORDER BY `id` DESC LIMIT 20 [ RunTime:0.000758s ]
SHOW FULL COLUMNS FROM `phome_enewsclass` [ RunTime:0.002149s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 9 LIMIT 1 [ RunTime:0.000788s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 9 LIMIT 1 [ RunTime:0.000689s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000653s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000566s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000737s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000706s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000626s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000603s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000683s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000658s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000659s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000597s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000714s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000636s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 18 LIMIT 1 [ RunTime:0.000692s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 67 LIMIT 1 [ RunTime:0.000624s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 71 LIMIT 1 [ RunTime:0.000577s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 69 LIMIT 1 [ RunTime:0.000669s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 71 LIMIT 1 [ RunTime:0.000615s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 72 LIMIT 1 [ RunTime:0.000756s ]
SHOW FULL COLUMNS FROM `db_cms_picture_juhe` [ RunTime:0.001549s ]
SELECT * FROM `db_cms_picture_juhe` WHERE `id` <> 0 AND `title` LIKE '%茶叶%' LIMIT 20 [ RunTime:0.001010s ]
SELECT * FROM `db_cms_picture_juhe` WHERE `id` <> 0 AND `title` LIKE '%黄色%' LIMIT 20 [ RunTime:0.000788s ]
SELECT * FROM `db_cms_picture_juhe` WHERE `id` <> 0 AND `title` LIKE '%扁平化设计%' LIMIT 20 [ RunTime:0.000560s ]
SELECT * FROM `db_cms_picture_juhe` WHERE `id` <> 0 ORDER BY `id` DESC LIMIT 20 [ RunTime:0.000547s ]
SHOW FULL COLUMNS FROM `db_cms_question_juhe` [ RunTime:0.001321s ]
SELECT * FROM `db_cms_question_juhe` WHERE `id` <> 0 AND `title` LIKE '%茶叶%' LIMIT 20 [ RunTime:0.000920s ]
SELECT * FROM `db_cms_question_juhe` WHERE `id` <> 0 AND `title` LIKE '%黄色%' LIMIT 20 [ RunTime:0.000858s ]
SELECT * FROM `db_cms_question_juhe` WHERE `id` <> 0 AND `title` LIKE '%扁平化设计%' LIMIT 20 [ RunTime:0.000494s ]
SELECT * FROM `db_cms_question_juhe` WHERE `id` <> 0 ORDER BY `id` DESC LIMIT 20 [ RunTime:0.000493s ]
57
