SHOW FULL COLUMNS FROM `db_cat` [ RunTime:0.001490s ]
SELECT * FROM `db_cat` WHERE `catid` = 60 LIMIT 1 [ RunTime:0.000617s ]
SHOW FULL COLUMNS FROM `db_cat_data` [ RunTime:0.000966s ]
SELECT * FROM `db_cat_data` WHERE `catid` = 60 LIMIT 1 [ RunTime:0.000431s ]
SHOW FULL COLUMNS FROM `db_cms_pictures` [ RunTime:0.001179s ]
SELECT * FROM `db_cms_pictures` WHERE `id` = 1538 LIMIT 1 [ RunTime:0.000803s ]
SHOW FULL COLUMNS FROM `db_cms_pictures_data` [ RunTime:0.000956s ]
SELECT * FROM `db_cms_pictures_data` WHERE `id` = 1538 LIMIT 1 [ RunTime:0.000696s ]
SELECT * FROM `db_cms_pictures` WHERE `id` BETWEEN 1528 AND 1537 ORDER BY `id` ASC [ RunTime:0.000832s ]
SELECT * FROM `db_cms_pictures` WHERE `id` BETWEEN 1539 AND 1548 ORDER BY `id` ASC [ RunTime:0.000825s ]
SHOW FULL COLUMNS FROM `db_cms_picturesclass` [ RunTime:0.001212s ]
SELECT * FROM `db_cms_picturesclass` WHERE `id` = 10 LIMIT 1 [ RunTime:0.000573s ]
SELECT * FROM `db_cms_picturesclass` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000561s ]
SELECT * FROM `db_cms_picturesclass` WHERE `id` = 38 LIMIT 1 [ RunTime:0.000723s ]
UPDATE `db_cms_pictures` SET `views` = `views` + 1 WHERE `id` = 1538 [ RunTime:0.001124s ]
SELECT `title`,`id`,`catid` FROM `db_cms_pictures` WHERE `catid` = 60 AND `id` <> 1538 AND `newstime` >= 1648867556 ORDER BY `newstime` ASC,`id` ASC LIMIT 1 [ RunTime:0.003852s ]
SELECT `titleurl`,`link` FROM `db_cms_pictures` WHERE `id` = 1536 LIMIT 1 [ RunTime:0.000659s ]
SELECT `title`,`id`,`catid` FROM `db_cms_pictures` WHERE `catid` = 60 AND `id` <> 1538 AND `newstime` <= 1648867556 ORDER BY `newstime` DESC,`id` DESC LIMIT 1 [ RunTime:0.003565s ]
SELECT `titleurl`,`link` FROM `db_cms_pictures` WHERE `id` = 1539 LIMIT 1 [ RunTime:0.000578s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 53 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000524s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 54 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000537s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 56 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000525s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 57 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000487s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 64 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000499s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 65 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000476s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 66 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000447s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 67 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000414s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 68 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000452s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 55 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000426s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 58 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000455s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 59 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000465s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 69 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000709s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 70 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000613s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 71 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000626s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 72 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000516s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 61 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000482s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 73 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000518s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 74 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000525s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 75 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000482s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 76 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000484s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 77 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000483s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 92 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000512s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 62 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000469s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 78 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000493s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 79 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000504s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 80 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000518s ]
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.000561s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 91 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000516s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 63 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000564s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 83 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000501s ]
SHOW FULL COLUMNS FROM `db_cms_questions` [ RunTime:0.001761s ]
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.004693s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 53 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000560s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 54 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000477s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 56 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000452s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 57 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000499s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 64 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000692s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 65 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000452s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 66 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000449s ]
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.000448s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 55 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000404s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 58 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000437s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 59 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000487s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 69 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000414s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 70 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000430s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 71 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000388s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 72 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000424s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 61 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000434s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 73 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000397s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 74 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000414s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 75 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000439s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 76 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000400s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 77 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000387s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 92 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000428s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 62 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000426s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 78 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000439s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 79 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000457s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 80 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000416s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 81 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000390s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 82 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000429s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 91 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000401s ]
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.000397s ]
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.003746s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 60 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000534s ]
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.004207s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 60 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000495s ]
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.004177s ]
SHOW FULL COLUMNS FROM `phome_ecms_news` [ RunTime:0.001644s ]
SELECT * FROM `phome_ecms_news` WHERE `title` LIKE '%能源、灯具%' OR `title` LIKE '%蓝色%' OR `title` LIKE '%扁平化设计%' ORDER BY `id` DESC LIMIT 20 [ RunTime:0.006084s ]
SHOW FULL COLUMNS FROM `db_cms_picture_juhe` [ RunTime:0.001913s ]
SELECT * FROM `db_cms_picture_juhe` WHERE `id` <> 0 AND `title` LIKE '%能源、灯具%' LIMIT 20 [ RunTime:0.000931s ]
SELECT * FROM `db_cms_picture_juhe` WHERE `id` <> 0 AND `title` LIKE '%蓝色%' LIMIT 20 [ RunTime:0.000651s ]
SELECT * FROM `db_cms_picture_juhe` WHERE `id` NOT IN (0,7,9) AND `title` LIKE '%扁平化设计%' LIMIT 18 [ RunTime:0.000518s ]
SELECT * FROM `db_cms_picture_juhe` WHERE `id` NOT IN (0,7,9) ORDER BY `id` DESC LIMIT 18 [ RunTime:0.000537s ]
SHOW FULL COLUMNS FROM `db_cms_question_juhe` [ RunTime:0.001343s ]
SELECT * FROM `db_cms_question_juhe` WHERE `id` <> 0 AND `title` LIKE '%能源、灯具%' LIMIT 20 [ RunTime:0.000895s ]
SELECT * FROM `db_cms_question_juhe` WHERE `id` <> 0 AND `title` LIKE '%蓝色%' LIMIT 20 [ RunTime:0.000549s ]
SELECT * FROM `db_cms_question_juhe` WHERE `id` <> 0 AND `title` LIKE '%扁平化设计%' LIMIT 20 [ RunTime:0.000508s ]
SELECT * FROM `db_cms_question_juhe` WHERE `id` <> 0 ORDER BY `id` DESC LIMIT 20 [ RunTime:0.000501s ]
106
