SHOW FULL COLUMNS FROM `db_visit_48` [ RunTime:0.001735s ]
INSERT INTO `db_visit_48` SET `visit_type` = 'website' , `ip` = '18.232.59.38' , `visit_time` = 1656534362 [ RunTime:0.004138s ]
SELECT `ip` FROM `db_visit_48` WHERE `visit_time` IN (between,1656518400) GROUP BY `ip` [ RunTime:0.000406s ]
SELECT COUNT(*) AS think_count FROM `db_visit_48` WHERE `visit_time` IN (between,1656518400) [ RunTime:0.000349s ]
SELECT COUNT(*) AS think_count FROM `db_visit_48` WHERE `visit_time` IN (between,1656518400) AND `visit_type` = 'search' [ RunTime:0.000291s ]
SELECT COUNT(*) AS think_count FROM `db_visit_48` WHERE `visit_time` IN (between,1656518400) AND `visit_type` = 'website' [ RunTime:0.000269s ]
SELECT COUNT(*) AS think_count FROM `db_visit_48` WHERE `visit_time` IN (between,1656518400) AND `visit_type` = 'link' [ RunTime:0.000289s ]
SELECT COUNT(*) AS think_count FROM `db_visit_48` WHERE `visit_time` IN (between,1656518400) AND `visit_type` = 'search' AND `search_engine` = 'baidu' [ RunTime:0.000274s ]
SELECT COUNT(*) AS think_count FROM `db_visit_48` WHERE `visit_time` IN (between,1656518400) AND `visit_type` = 'search' AND `search_engine` = 'google' [ RunTime:0.000264s ]
SELECT COUNT(*) AS think_count FROM `db_visit_48` WHERE `visit_time` IN (between,1656518400) AND `visit_type` = 'search' AND `search_engine` = 'sogou' [ RunTime:0.000314s ]
SELECT COUNT(*) AS think_count FROM `db_visit_48` WHERE `visit_time` IN (between,1656518400) AND `visit_type` = 'search' AND `search_engine` = '360' [ RunTime:0.000397s ]
SELECT COUNT(*) AS think_count FROM `db_visit_48` WHERE `visit_time` IN (between,1656518400) AND `visit_type` = 'search' AND `search_engine` = 'bing' [ RunTime:0.000330s ]
SHOW FULL COLUMNS FROM `db_visit` [ RunTime:0.002014s ]
SELECT `id` FROM `db_visit` WHERE `daytime` = 1656518400 LIMIT 1 [ RunTime:0.001626s ]
SHOW FULL COLUMNS FROM `db_cat` [ RunTime:0.002092s ]
SELECT * FROM `db_cat` WHERE `catid` = 60 LIMIT 1 [ RunTime:0.001007s ]
SHOW FULL COLUMNS FROM `db_cat_data` [ RunTime:0.001400s ]
SELECT * FROM `db_cat_data` WHERE `catid` = 60 LIMIT 1 [ RunTime:0.000874s ]
SHOW FULL COLUMNS FROM `db_cms_pictures` [ RunTime:0.002218s ]
SELECT * FROM `db_cms_pictures` WHERE `id` = 955 LIMIT 1 [ RunTime:0.001364s ]
SHOW FULL COLUMNS FROM `db_cms_pictures_data` [ RunTime:0.002985s ]
SELECT * FROM `db_cms_pictures_data` WHERE `id` = 955 LIMIT 1 [ RunTime:0.001339s ]
SELECT * FROM `db_cms_pictures` WHERE `id` BETWEEN 945 AND 954 ORDER BY `id` ASC [ RunTime:0.001683s ]
SELECT * FROM `db_cms_pictures` WHERE `id` BETWEEN 956 AND 965 ORDER BY `id` ASC [ RunTime:0.001034s ]
SHOW FULL COLUMNS FROM `db_cms_picturesclass` [ RunTime:0.001400s ]
SELECT * FROM `db_cms_picturesclass` WHERE `id` = 11 LIMIT 1 [ RunTime:0.000947s ]
SELECT * FROM `db_cms_picturesclass` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000635s ]
SELECT * FROM `db_cms_picturesclass` WHERE `id` = 67 LIMIT 1 [ RunTime:0.000738s ]
UPDATE `db_cms_pictures` SET `views` = `views` + 1 WHERE `id` = 955 [ RunTime:0.000857s ]
SELECT `title`,`id`,`catid` FROM `db_cms_pictures` WHERE `catid` = 60 AND `id` <> 955 AND `newstime` >= 1648448236 ORDER BY `newstime` ASC,`id` ASC LIMIT 1 [ RunTime:0.008208s ]
SELECT `titleurl`,`link` FROM `db_cms_pictures` WHERE `id` = 953 LIMIT 1 [ RunTime:0.000794s ]
SELECT `title`,`id`,`catid` FROM `db_cms_pictures` WHERE `catid` = 60 AND `id` <> 955 AND `newstime` <= 1648448236 ORDER BY `newstime` DESC,`id` DESC LIMIT 1 [ RunTime:0.006563s ]
SELECT `titleurl`,`link` FROM `db_cms_pictures` WHERE `id` = 958 LIMIT 1 [ RunTime:0.000683s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 53 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000627s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 54 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000426s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 56 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000698s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 57 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000669s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 64 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000537s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 65 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000595s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 66 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000550s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 67 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000420s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 68 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000598s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 55 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000554s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 58 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000527s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 59 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000467s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 69 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000378s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 70 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000427s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 71 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000471s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 72 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000409s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 61 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000469s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 73 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000506s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 74 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000406s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 75 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000602s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 76 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000689s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 77 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000479s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 92 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000355s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 62 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000348s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 78 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000454s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 79 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000350s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 80 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000388s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 81 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000382s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 82 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000349s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 91 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000428s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 63 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000477s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 83 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000440s ]
SHOW FULL COLUMNS FROM `db_cms_questions` [ RunTime:0.001789s ]
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.004207s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 53 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000522s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 54 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000390s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 56 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000410s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 57 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000442s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 64 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000467s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 65 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000553s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 66 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000491s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 67 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000389s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 68 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000395s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 55 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000377s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 58 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000533s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 59 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000410s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 69 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000393s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 70 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000399s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 71 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000386s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 72 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000360s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 61 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000383s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 73 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000402s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 74 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000377s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 75 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000334s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 76 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000356s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 77 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000372s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 92 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000419s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 62 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000382s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 78 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000453s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 79 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000368s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 80 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000360s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 81 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000432s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 82 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000419s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 91 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000408s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 63 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000451s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 83 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000409s ]
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.002838s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 60 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000543s ]
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.005452s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 60 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000473s ]
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.005491s ]
SHOW FULL COLUMNS FROM `phome_ecms_news` [ RunTime:0.001810s ]
SELECT * FROM `phome_ecms_news` WHERE `title` LIKE '%茶叶%' OR `title` LIKE '%绿色%' OR `title` LIKE '%扁平化设计%' ORDER BY `id` DESC LIMIT 20 [ RunTime:0.110808s ]
SELECT * FROM `phome_ecms_news` ORDER BY `id` DESC LIMIT 15 [ RunTime:0.001410s ]
SHOW FULL COLUMNS FROM `phome_enewsclass` [ RunTime:0.001688s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 49 LIMIT 1 [ RunTime:0.000875s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 49 LIMIT 1 [ RunTime:0.000826s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 50 LIMIT 1 [ RunTime:0.000805s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 45 LIMIT 1 [ RunTime:0.000748s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 45 LIMIT 1 [ RunTime:0.000722s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 9 LIMIT 1 [ RunTime:0.000835s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 9 LIMIT 1 [ RunTime:0.000697s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000620s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000644s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000631s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000711s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000611s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000663s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000566s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000764s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000609s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000623s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000552s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000518s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 18 LIMIT 1 [ RunTime:0.000593s ]
SHOW FULL COLUMNS FROM `db_cms_picture_juhe` [ RunTime:0.001174s ]
SELECT * FROM `db_cms_picture_juhe` WHERE `id` <> 0 AND `title` LIKE '%茶叶%' LIMIT 20 [ RunTime:0.001239s ]
SELECT * FROM `db_cms_picture_juhe` WHERE `id` <> 0 AND `title` LIKE '%绿色%' LIMIT 20 [ RunTime:0.000630s ]
SELECT * FROM `db_cms_picture_juhe` WHERE `id` <> 0 AND `title` LIKE '%扁平化设计%' LIMIT 20 [ RunTime:0.000583s ]
SELECT * FROM `db_cms_picture_juhe` WHERE `id` <> 0 ORDER BY `id` DESC LIMIT 20 [ RunTime:0.000453s ]
SHOW FULL COLUMNS FROM `db_cms_question_juhe` [ RunTime:0.001376s ]
SELECT * FROM `db_cms_question_juhe` WHERE `id` <> 0 AND `title` LIKE '%茶叶%' LIMIT 20 [ RunTime:0.000748s ]
SELECT * FROM `db_cms_question_juhe` WHERE `id` <> 0 AND `title` LIKE '%绿色%' LIMIT 20 [ RunTime:0.000737s ]
SELECT * FROM `db_cms_question_juhe` WHERE `id` <> 0 AND `title` LIKE '%扁平化设计%' LIMIT 20 [ RunTime:0.000504s ]
SELECT * FROM `db_cms_question_juhe` WHERE `id` <> 0 ORDER BY `id` DESC LIMIT 20 [ RunTime:0.000568s ]