SHOW FULL COLUMNS FROM `db_cat` [ RunTime:0.001825s ]
SELECT * FROM `db_cat` WHERE `catid` = 60 LIMIT 1 [ RunTime:0.000719s ]
SHOW FULL COLUMNS FROM `db_cat_data` [ RunTime:0.001142s ]
SELECT * FROM `db_cat_data` WHERE `catid` = 60 LIMIT 1 [ RunTime:0.000439s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 60 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000480s ]
SHOW FULL COLUMNS FROM `db_cms_picturesclass` [ RunTime:0.001360s ]
SELECT * FROM `db_cms_picturesclass` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000504s ]
SELECT * FROM `db_cms_picturesclass` WHERE `id` = 50 LIMIT 1 [ RunTime:0.000503s ]
SHOW FULL COLUMNS FROM `db_cms_pictures` [ RunTime:0.001315s ]
SELECT COUNT(*) AS think_count FROM `db_cms_pictures` WHERE `catid` = 60 AND `style` = '5' AND `type` = '50' [ RunTime:0.003680s ]
SELECT COUNT(*) AS think_count FROM `db_cms_pictures` WHERE `catid` = 60 AND `style` = '5' AND `type` = '50' [ RunTime:0.000628s ]
SELECT `id`,`catid`,`modelid`,`link`,`titleurl`,`pagetitle`,`keywords`,`description`,`pubid`,`sort`,`userid`,`username`,`addtime`,`editortime`,`is_good`,`is_top`,`views`,`goods`,`comments`,`title`,`idnumber`,`thumb`,`picture`,`case_url`,`style`,`color`,`type`,`newstime` FROM `db_cms_pictures` WHERE `catid` = 60 AND `style` = '5' AND `type` = '50' ORDER BY `sort` ASC,`is_top` DESC,`is_good` DESC,`newstime` DESC,`id` DESC LIMIT 0,48 [ RunTime:0.003686s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 87 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000604s ]
SELECT * FROM `db_cms_picturesclass` WHERE `catid` = 87 ORDER BY `newstime` ASC [ RunTime:0.000589s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 88 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000634s ]
SELECT * FROM `db_cms_picturesclass` WHERE `catid` = 88 ORDER BY `newstime` ASC [ RunTime:0.000552s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 89 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000526s ]
SELECT * FROM `db_cms_picturesclass` WHERE `catid` = 89 ORDER BY `newstime` ASC [ RunTime:0.000626s ]
SHOW FULL COLUMNS FROM `phome_ecms_news` [ RunTime:0.001631s ]
SELECT * FROM `phome_ecms_news` WHERE `title` LIKE '%酒店%' OR `title` LIKE '%古典风格%' ORDER BY `id` DESC LIMIT 20 [ RunTime:0.122279s ]
SELECT * FROM `phome_ecms_news` ORDER BY `id` DESC LIMIT 18 [ RunTime:0.001777s ]
SHOW FULL COLUMNS FROM `db_cms_picture_juhe` [ RunTime:0.001561s ]
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.001056s ]
SHOW FULL COLUMNS FROM `db_cms_question_juhe` [ RunTime:0.001494s ]
SELECT * FROM `db_cms_question_juhe` WHERE `id` <> 0 AND `title` LIKE '%酒店%' LIMIT 20 [ RunTime:0.000572s ]
SELECT * FROM `db_cms_question_juhe` WHERE `id` <> 0 AND `title` LIKE '%%' LIMIT 20 [ RunTime:0.000540s ]
SELECT * FROM `db_cms_question_juhe` WHERE `id` NOT IN (0,1,7,8) AND `title` LIKE '%古典风格%' LIMIT 17 [ RunTime:0.000760s ]
SELECT * FROM `db_cms_question_juhe` WHERE `id` NOT IN (0,1,7,8) ORDER BY `id` DESC LIMIT 17 [ RunTime:0.000521s ]
