SHOW FULL COLUMNS FROM `db_visit_48` [ RunTime:0.001393s ]
INSERT INTO `db_visit_48` SET `visit_type` = 'website' , `ip` = '100.24.115.215' , `visit_time` = 1652893961 [ RunTime:0.002697s ]
SELECT `ip` FROM `db_visit_48` WHERE `visit_time` IN (between,1652889600) GROUP BY `ip` [ RunTime:0.000396s ]
SELECT COUNT(*) AS think_count FROM `db_visit_48` WHERE `visit_time` IN (between,1652889600) [ RunTime:0.000390s ]
SELECT COUNT(*) AS think_count FROM `db_visit_48` WHERE `visit_time` IN (between,1652889600) AND `visit_type` = 'search' [ RunTime:0.000272s ]
SELECT COUNT(*) AS think_count FROM `db_visit_48` WHERE `visit_time` IN (between,1652889600) AND `visit_type` = 'website' [ RunTime:0.000285s ]
SELECT COUNT(*) AS think_count FROM `db_visit_48` WHERE `visit_time` IN (between,1652889600) AND `visit_type` = 'link' [ RunTime:0.000284s ]
SELECT COUNT(*) AS think_count FROM `db_visit_48` WHERE `visit_time` IN (between,1652889600) AND `visit_type` = 'search' AND `search_engine` = 'baidu' [ RunTime:0.000273s ]
SELECT COUNT(*) AS think_count FROM `db_visit_48` WHERE `visit_time` IN (between,1652889600) AND `visit_type` = 'search' AND `search_engine` = 'google' [ RunTime:0.000222s ]
SELECT COUNT(*) AS think_count FROM `db_visit_48` WHERE `visit_time` IN (between,1652889600) AND `visit_type` = 'search' AND `search_engine` = 'sogou' [ RunTime:0.000269s ]
SELECT COUNT(*) AS think_count FROM `db_visit_48` WHERE `visit_time` IN (between,1652889600) AND `visit_type` = 'search' AND `search_engine` = '360' [ RunTime:0.000244s ]
SELECT COUNT(*) AS think_count FROM `db_visit_48` WHERE `visit_time` IN (between,1652889600) AND `visit_type` = 'search' AND `search_engine` = 'bing' [ RunTime:0.000234s ]
SHOW FULL COLUMNS FROM `db_visit` [ RunTime:0.001186s ]
SELECT `id` FROM `db_visit` WHERE `daytime` = 1652889600 LIMIT 1 [ RunTime:0.000531s ]
SHOW FULL COLUMNS FROM `db_cat` [ RunTime:0.001411s ]
SELECT * FROM `db_cat` WHERE `catid` = 60 LIMIT 1 [ RunTime:0.000606s ]
SHOW FULL COLUMNS FROM `db_cat_data` [ RunTime:0.000945s ]
SELECT * FROM `db_cat_data` WHERE `catid` = 60 LIMIT 1 [ RunTime:0.000459s ]
SHOW FULL COLUMNS FROM `db_cms_pictures` [ RunTime:0.001246s ]
SELECT * FROM `db_cms_pictures` WHERE `id` = 658 LIMIT 1 [ RunTime:0.000904s ]
SHOW FULL COLUMNS FROM `db_cms_pictures_data` [ RunTime:0.001152s ]
SELECT * FROM `db_cms_pictures_data` WHERE `id` = 658 LIMIT 1 [ RunTime:0.000554s ]
SELECT * FROM `db_cms_pictures` WHERE `id` BETWEEN 648 AND 657 ORDER BY `id` ASC [ RunTime:0.000886s ]
SELECT * FROM `db_cms_pictures` WHERE `id` BETWEEN 659 AND 668 ORDER BY `id` ASC [ RunTime:0.000864s ]
SHOW FULL COLUMNS FROM `db_cms_picturesclass` [ RunTime:0.001345s ]
SELECT * FROM `db_cms_picturesclass` WHERE `id` = 83 LIMIT 1 [ RunTime:0.000475s ]
SELECT * FROM `db_cms_picturesclass` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000594s ]
SELECT * FROM `db_cms_picturesclass` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000483s ]
UPDATE `db_cms_pictures` SET `views` = `views` + 1 WHERE `id` = 658 [ RunTime:0.001061s ]
SELECT `title`,`id`,`catid` FROM `db_cms_pictures` WHERE `catid` = 60 AND `id` <> 658 AND `newstime` >= 1648180069 ORDER BY `newstime` ASC,`id` ASC LIMIT 1 [ RunTime:0.004989s ]
SELECT `titleurl`,`link` FROM `db_cms_pictures` WHERE `id` = 659 LIMIT 1 [ RunTime:0.000670s ]
SELECT `title`,`id`,`catid` FROM `db_cms_pictures` WHERE `catid` = 60 AND `id` <> 658 AND `newstime` <= 1648180069 ORDER BY `newstime` DESC,`id` DESC LIMIT 1 [ RunTime:0.004630s ]
SELECT `titleurl`,`link` FROM `db_cms_pictures` WHERE `id` = 663 LIMIT 1 [ RunTime:0.000662s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 53 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000661s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 54 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000495s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 56 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000490s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 57 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000385s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 64 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000397s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 65 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000359s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 66 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000400s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 67 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000344s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 68 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000650s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 55 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000534s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 58 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000658s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 59 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000618s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 69 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000528s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 70 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000614s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 71 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000627s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 72 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000572s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 61 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000531s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 73 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000630s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 74 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000539s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 75 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000656s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 76 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000620s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 77 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000532s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 92 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000600s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 62 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000501s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 78 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000534s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 79 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000552s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 80 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000431s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 81 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000545s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 82 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000578s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 91 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000453s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 63 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000509s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 83 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000556s ]
SHOW FULL COLUMNS FROM `db_cms_questions` [ RunTime:0.001893s ]
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.002254s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 53 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000742s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 54 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000675s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 56 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000571s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 57 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000507s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 64 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000477s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 65 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000663s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 66 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000505s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 67 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000484s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 68 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000570s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 55 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000624s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 58 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000515s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 59 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000493s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 69 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000464s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 70 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000532s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 71 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000534s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 72 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000488s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 61 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000533s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 73 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000615s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 74 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000450s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 75 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000487s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 76 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000519s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 77 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000607s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 92 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000520s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 62 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000580s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 78 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000508s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 79 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000532s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 80 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000515s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 81 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000544s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 82 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000504s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 91 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000529s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 63 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000454s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 83 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000506s ]
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.001873s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 60 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000558s ]
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.005391s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 60 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000578s ]
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.004995s ]
SHOW FULL COLUMNS FROM `phome_ecms_news` [ RunTime:0.001621s ]
SELECT * FROM `phome_ecms_news` WHERE `title` LIKE '%家居、日用百货%' OR `title` LIKE '%粉色%' OR `title` LIKE '%3D风格%' ORDER BY `id` DESC LIMIT 20 [ RunTime:0.128100s ]
SELECT * FROM `phome_ecms_news` ORDER BY `id` DESC LIMIT 20 [ RunTime:0.000912s ]
SHOW FULL COLUMNS FROM `phome_enewsclass` [ RunTime:0.002264s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 9 LIMIT 1 [ RunTime:0.000846s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 9 LIMIT 1 [ RunTime:0.000683s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000687s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000677s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000582s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000582s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000589s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000605s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000585s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000579s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000555s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000577s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000556s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 51 LIMIT 1 [ RunTime:0.000630s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 18 LIMIT 1 [ RunTime:0.000724s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 67 LIMIT 1 [ RunTime:0.000726s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 71 LIMIT 1 [ RunTime:0.000994s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 69 LIMIT 1 [ RunTime:0.000674s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 71 LIMIT 1 [ RunTime:0.000700s ]
SELECT * FROM `phome_enewsclass` WHERE `classid` = 72 LIMIT 1 [ RunTime:0.000781s ]
SHOW FULL COLUMNS FROM `db_cms_picture_juhe` [ RunTime:0.002068s ]
SELECT * FROM `db_cms_picture_juhe` WHERE `id` <> 0 AND `title` LIKE '%家居、日用百货%' LIMIT 20 [ RunTime:0.000705s ]
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` NOT IN (0,24) AND `title` LIKE '%3D风格%' LIMIT 19 [ RunTime:0.000480s ]
SELECT * FROM `db_cms_picture_juhe` WHERE `id` NOT IN (0,24) ORDER BY `id` DESC LIMIT 19 [ RunTime:0.000543s ]
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.000502s ]
SELECT * FROM `db_cms_question_juhe` WHERE `id` <> 0 AND `title` LIKE '%粉色%' LIMIT 20 [ RunTime:0.000529s ]
SELECT * FROM `db_cms_question_juhe` WHERE `id` <> 0 AND `title` LIKE '%3D风格%' LIMIT 20 [ RunTime:0.000518s ]
SELECT * FROM `db_cms_question_juhe` WHERE `id` <> 0 ORDER BY `id` DESC LIMIT 20 [ RunTime:0.000470s ]
27
