SHOW FULL COLUMNS FROM `db_cat` [ RunTime:0.003564s ]
SELECT * FROM `db_cat` WHERE `catid` = 60 LIMIT 1 [ RunTime:0.000903s ]
SHOW FULL COLUMNS FROM `db_cat_data` [ RunTime:0.003382s ]
SELECT * FROM `db_cat_data` WHERE `catid` = 60 LIMIT 1 [ RunTime:0.000592s ]
SHOW FULL COLUMNS FROM `db_cms_pictures` [ RunTime:0.002508s ]
SELECT * FROM `db_cms_pictures` WHERE `id` = 1485 LIMIT 1 [ RunTime:0.001074s ]
SHOW FULL COLUMNS FROM `db_cms_pictures_data` [ RunTime:0.001465s ]
SELECT * FROM `db_cms_pictures_data` WHERE `id` = 1485 LIMIT 1 [ RunTime:0.000814s ]
SELECT * FROM `db_cms_pictures` WHERE `id` BETWEEN 1475 AND 1484 ORDER BY `id` ASC [ RunTime:0.001086s ]
SELECT * FROM `db_cms_pictures` WHERE `id` BETWEEN 1486 AND 1495 ORDER BY `id` ASC [ RunTime:0.001029s ]
SHOW FULL COLUMNS FROM `db_cms_picturesclass` [ RunTime:0.002002s ]
SELECT * FROM `db_cms_picturesclass` WHERE `id` = 11 LIMIT 1 [ RunTime:0.000726s ]
SELECT * FROM `db_cms_picturesclass` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000648s ]
SELECT * FROM `db_cms_picturesclass` WHERE `id` = 21 LIMIT 1 [ RunTime:0.000812s ]
UPDATE `db_cms_pictures` SET `views` = `views` + 1 WHERE `id` = 1485 [ RunTime:0.002367s ]
SELECT `title`,`id`,`catid` FROM `db_cms_pictures` WHERE `catid` = 60 AND `id` <> 1485 AND `newstime` >= 1648715100 ORDER BY `newstime` ASC,`id` ASC LIMIT 1 [ RunTime:0.004196s ]
SELECT `titleurl`,`link` FROM `db_cms_pictures` WHERE `id` = 1484 LIMIT 1 [ RunTime:0.000656s ]
SELECT `title`,`id`,`catid` FROM `db_cms_pictures` WHERE `catid` = 60 AND `id` <> 1485 AND `newstime` <= 1648715100 ORDER BY `newstime` DESC,`id` DESC LIMIT 1 [ RunTime:0.003551s ]
SELECT `titleurl`,`link` FROM `db_cms_pictures` WHERE `id` = 1486 LIMIT 1 [ RunTime:0.000711s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 53 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000717s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 54 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000639s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 56 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000624s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 57 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000509s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 64 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000470s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 65 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000594s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 66 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000543s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 67 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000513s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 68 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000508s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 55 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000576s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 58 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000635s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 59 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000595s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 69 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000511s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 70 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000657s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 71 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000547s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 72 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000679s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 61 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000585s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 73 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000661s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 74 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000595s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 75 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000570s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 76 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000533s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 77 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000530s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 92 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000594s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 62 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000658s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 78 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000429s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 79 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000445s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 80 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000479s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 81 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000406s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 82 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000510s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 91 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000464s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 63 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000420s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 83 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000478s ]
SHOW FULL COLUMNS FROM `db_cms_questions` [ RunTime:0.002609s ]
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.005852s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 53 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000515s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 54 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000450s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 56 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000480s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 57 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000414s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 64 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000433s ]
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.000666s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 67 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000413s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 68 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000398s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 55 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000402s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 58 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000613s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 59 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000454s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 69 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000763s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 70 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000449s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 71 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000670s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 72 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000484s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 61 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000800s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 73 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000649s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 74 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000557s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 75 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000411s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 76 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000873s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 77 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000489s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 92 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000475s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 62 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000416s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 78 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000452s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 79 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000475s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 80 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000453s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 81 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000451s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 82 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000479s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 91 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000454s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 63 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000507s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 83 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000437s ]
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.004347s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 60 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000569s ]
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.004090s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 60 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000503s ]
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.004370s ]
SHOW FULL COLUMNS FROM `phome_ecms_news` [ RunTime:0.002924s ]
SELECT * FROM `phome_ecms_news` WHERE `title` LIKE '%农业%' OR `title` LIKE '%绿色%' OR `title` LIKE '%扁平化设计%' ORDER BY `id` DESC LIMIT 20 [ RunTime:0.159203s ]
SELECT * FROM `phome_ecms_news` ORDER BY `id` DESC LIMIT 8 [ RunTime:0.001501s ]
SHOW FULL COLUMNS FROM `db_cms_picture_juhe` [ RunTime:0.002479s ]
SELECT * FROM `db_cms_picture_juhe` WHERE `id` <> 0 AND `title` LIKE '%农业%' LIMIT 20 [ RunTime:0.001202s ]
SELECT * FROM `db_cms_picture_juhe` WHERE `id` <> 0 AND `title` LIKE '%绿色%' LIMIT 20 [ RunTime:0.000947s ]
SELECT * FROM `db_cms_picture_juhe` WHERE `id` <> 0 AND `title` LIKE '%扁平化设计%' LIMIT 20 [ RunTime:0.000816s ]
SELECT * FROM `db_cms_picture_juhe` WHERE `id` <> 0 ORDER BY `id` DESC LIMIT 20 [ RunTime:0.000755s ]
SHOW FULL COLUMNS FROM `db_cms_question_juhe` [ RunTime:0.002215s ]
SELECT * FROM `db_cms_question_juhe` WHERE `id` <> 0 AND `title` LIKE '%农业%' LIMIT 20 [ RunTime:0.001063s ]
SELECT * FROM `db_cms_question_juhe` WHERE `id` <> 0 AND `title` LIKE '%绿色%' LIMIT 20 [ RunTime:0.000653s ]
SELECT * FROM `db_cms_question_juhe` WHERE `id` <> 0 AND `title` LIKE '%扁平化设计%' LIMIT 20 [ RunTime:0.000600s ]
SELECT * FROM `db_cms_question_juhe` WHERE `id` <> 0 ORDER BY `id` DESC LIMIT 20 [ RunTime:0.000499s ]
113
