SHOW FULL COLUMNS FROM `db_visit_48` [ RunTime:0.001441s ]
INSERT INTO `db_visit_48` SET `visit_type` = 'website' , `ip` = '18.232.59.38' , `visit_time` = 1656529048 [ RunTime:0.003728s ]
SELECT `ip` FROM `db_visit_48` WHERE `visit_time` IN (between,1656518400) GROUP BY `ip` [ RunTime:0.000294s ]
SELECT COUNT(*) AS think_count FROM `db_visit_48` WHERE `visit_time` IN (between,1656518400) [ RunTime:0.000360s ]
SELECT COUNT(*) AS think_count FROM `db_visit_48` WHERE `visit_time` IN (between,1656518400) AND `visit_type` = 'search' [ RunTime:0.000376s ]
SELECT COUNT(*) AS think_count FROM `db_visit_48` WHERE `visit_time` IN (between,1656518400) AND `visit_type` = 'website' [ RunTime:0.000336s ]
SELECT COUNT(*) AS think_count FROM `db_visit_48` WHERE `visit_time` IN (between,1656518400) AND `visit_type` = 'link' [ RunTime:0.000282s ]
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.000284s ]
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.000293s ]
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.000376s ]
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.000361s ]
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.000319s ]
SHOW FULL COLUMNS FROM `db_visit` [ RunTime:0.001650s ]
SELECT `id` FROM `db_visit` WHERE `daytime` = 1656518400 LIMIT 1 [ RunTime:0.000656s ]
SHOW FULL COLUMNS FROM `db_cat` [ RunTime:0.002610s ]
SELECT * FROM `db_cat` WHERE `catid` = 60 LIMIT 1 [ RunTime:0.000522s ]
SHOW FULL COLUMNS FROM `db_cat_data` [ RunTime:0.001213s ]
SELECT * FROM `db_cat_data` WHERE `catid` = 60 LIMIT 1 [ RunTime:0.000592s ]
SHOW FULL COLUMNS FROM `db_cms_pictures` [ RunTime:0.002639s ]
SELECT * FROM `db_cms_pictures` WHERE `id` = 416 LIMIT 1 [ RunTime:0.001304s ]
SHOW FULL COLUMNS FROM `db_cms_pictures_data` [ RunTime:0.001540s ]
SELECT * FROM `db_cms_pictures_data` WHERE `id` = 416 LIMIT 1 [ RunTime:0.000475s ]
SELECT * FROM `db_cms_pictures` WHERE `id` BETWEEN 406 AND 415 ORDER BY `id` ASC [ RunTime:0.001061s ]
SELECT * FROM `db_cms_pictures` WHERE `id` BETWEEN 417 AND 426 ORDER BY `id` ASC [ RunTime:0.001001s ]
SHOW FULL COLUMNS FROM `db_cms_picturesclass` [ RunTime:0.001773s ]
SELECT * FROM `db_cms_picturesclass` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000698s ]
SELECT * FROM `db_cms_picturesclass` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000578s ]
SELECT * FROM `db_cms_picturesclass` WHERE `id` = 67 LIMIT 1 [ RunTime:0.000741s ]
UPDATE `db_cms_pictures` SET `views` = `views` + 1 WHERE `id` = 416 [ RunTime:0.001415s ]
SELECT `title`,`id`,`catid` FROM `db_cms_pictures` WHERE `catid` = 60 AND `id` <> 416 AND `newstime` >= 1648092038 ORDER BY `newstime` ASC,`id` ASC LIMIT 1 [ RunTime:0.006222s ]
SELECT `titleurl`,`link` FROM `db_cms_pictures` WHERE `id` = 410 LIMIT 1 [ RunTime:0.000711s ]
SELECT `title`,`id`,`catid` FROM `db_cms_pictures` WHERE `catid` = 60 AND `id` <> 416 AND `newstime` <= 1648092038 ORDER BY `newstime` DESC,`id` DESC LIMIT 1 [ RunTime:0.005824s ]
SELECT `titleurl`,`link` FROM `db_cms_pictures` WHERE `id` = 421 LIMIT 1 [ RunTime:0.000715s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 53 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000592s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 54 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.001438s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 56 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.001307s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 57 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.001308s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 64 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000474s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 65 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000397s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 66 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000457s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 67 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000372s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 68 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000355s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 55 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000363s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 58 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000352s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 59 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000428s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 69 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000384s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 70 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000477s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 71 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000393s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 72 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.001907s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 61 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.001574s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 73 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.001440s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 74 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000455s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 75 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000447s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 76 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000379s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 77 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000413s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 92 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000388s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 62 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000386s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 78 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000411s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 79 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000397s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 80 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000317s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 81 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000427s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 82 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000308s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 91 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000676s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 63 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000735s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 83 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000837s ]
SHOW FULL COLUMNS FROM `db_cms_questions` [ RunTime:0.001866s ]
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.003041s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 53 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000601s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 54 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000599s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 56 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000545s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 57 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000471s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 64 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000531s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 65 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.001495s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 66 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.001767s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 67 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.001029s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 68 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.001312s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 55 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000473s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 58 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000430s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 59 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000453s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 69 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000453s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 70 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000637s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 71 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000559s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 72 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000535s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 61 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000557s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 73 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000461s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 74 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000615s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 75 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000542s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 76 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000596s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 77 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000451s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 92 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000409s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 62 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000368s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 78 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000411s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 79 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000427s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 80 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000384s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 81 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000520s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 82 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000838s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 91 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000652s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 63 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000844s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 83 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000769s ]
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.004522s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 60 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000659s ]
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.009652s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 60 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.001102s ]
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.008534s ]
SHOW FULL COLUMNS FROM `phome_ecms_news` [ RunTime:0.002476s ]
SELECT * FROM `phome_ecms_news` WHERE `title` LIKE '%茶叶%' OR `title` LIKE '%黄色%' OR `title` LIKE '%扁平化设计%' ORDER BY `id` DESC LIMIT 20 [ RunTime:0.122924s ]
SELECT * FROM `phome_ecms_news` ORDER BY `id` DESC LIMIT 20 [ RunTime:0.000946s ]
SHOW FULL COLUMNS FROM `phome_enewsclass` [ RunTime:0.002278s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 9 LIMIT 1 [ RunTime:0.000881s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 9 LIMIT 1 [ RunTime:0.000602s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000806s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000714s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000592s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000627s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000601s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000615s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000616s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000722s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000614s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000822s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000768s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000827s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 18 LIMIT 1 [ RunTime:0.001058s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 67 LIMIT 1 [ RunTime:0.000700s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 71 LIMIT 1 [ RunTime:0.000764s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 69 LIMIT 1 [ RunTime:0.000898s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 71 LIMIT 1 [ RunTime:0.000847s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 72 LIMIT 1 [ RunTime:0.001454s ]
SHOW FULL COLUMNS FROM `db_cms_picture_juhe` [ RunTime:0.001950s ]
SELECT * FROM `db_cms_picture_juhe` WHERE `id` <> 0 AND `title` LIKE '%茶叶%' LIMIT 20 [ RunTime:0.001358s ]
SELECT * FROM `db_cms_picture_juhe` WHERE `id` <> 0 AND `title` LIKE '%黄色%' LIMIT 20 [ RunTime:0.000698s ]
SELECT * FROM `db_cms_picture_juhe` WHERE `id` <> 0 AND `title` LIKE '%扁平化设计%' LIMIT 20 [ RunTime:0.000599s ]
SELECT * FROM `db_cms_picture_juhe` WHERE `id` <> 0 ORDER BY `id` DESC LIMIT 20 [ RunTime:0.000766s ]
SHOW FULL COLUMNS FROM `db_cms_question_juhe` [ RunTime:0.002204s ]
SELECT * FROM `db_cms_question_juhe` WHERE `id` <> 0 AND `title` LIKE '%茶叶%' LIMIT 20 [ RunTime:0.001248s ]
SELECT * FROM `db_cms_question_juhe` WHERE `id` <> 0 AND `title` LIKE '%黄色%' LIMIT 20 [ RunTime:0.000794s ]
SELECT * FROM `db_cms_question_juhe` WHERE `id` <> 0 AND `title` LIKE '%扁平化设计%' LIMIT 20 [ RunTime:0.000756s ]
SELECT * FROM `db_cms_question_juhe` WHERE `id` <> 0 ORDER BY `id` DESC LIMIT 20 [ RunTime:0.000662s ]
56
