SHOW FULL COLUMNS FROM `db_cat` [ RunTime:0.001722s ]
SELECT * FROM `db_cat` WHERE `catid` = 60 LIMIT 1 [ RunTime:0.000655s ]
SHOW FULL COLUMNS FROM `db_cat_data` [ RunTime:0.001181s ]
SELECT * FROM `db_cat_data` WHERE `catid` = 60 LIMIT 1 [ RunTime:0.000483s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 60 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000435s ]
SHOW FULL COLUMNS FROM `db_cms_picturesclass` [ RunTime:0.001383s ]
SELECT * FROM `db_cms_picturesclass` WHERE `id` = 90 LIMIT 1 [ RunTime:0.000966s ]
SHOW FULL COLUMNS FROM `db_cms_pictures` [ RunTime:0.001458s ]
SELECT COUNT(*) AS think_count FROM `db_cms_pictures` WHERE `catid` = 60 AND `type` = '90' [ RunTime:0.003623s ]
SELECT COUNT(*) AS think_count FROM `db_cms_pictures` WHERE `catid` = 60 AND `type` = '90' [ RunTime:0.000804s ]
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 `type` = '90' ORDER BY `sort` ASC,`is_top` DESC,`is_good` DESC,`newstime` DESC,`id` DESC LIMIT 0,48 [ RunTime:0.003914s ]
SELECT * FROM `db_cat` WHERE `catid` = 60 LIMIT 1 [ RunTime:0.000574s ]
SELECT * FROM `db_cat` WHERE `catid` = 60 LIMIT 1 [ RunTime:0.000580s ]
SELECT * FROM `db_cat` WHERE `catid` = 60 LIMIT 1 [ RunTime:0.000524s ]
SELECT * FROM `db_cat` WHERE `catid` = 60 LIMIT 1 [ RunTime:0.000519s ]
SELECT * FROM `db_cat` WHERE `catid` = 60 LIMIT 1 [ RunTime:0.000457s ]
SELECT * FROM `db_cat` WHERE `catid` = 60 LIMIT 1 [ RunTime:0.000514s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 87 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000559s ]
SELECT * FROM `db_cms_picturesclass` WHERE `catid` = 87 ORDER BY `newstime` ASC [ RunTime:0.000486s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 88 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000611s ]
SELECT * FROM `db_cms_picturesclass` WHERE `catid` = 88 ORDER BY `newstime` ASC [ RunTime:0.000487s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 89 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000523s ]
SELECT * FROM `db_cms_picturesclass` WHERE `catid` = 89 ORDER BY `newstime` ASC [ RunTime:0.000567s ]
SHOW FULL COLUMNS FROM `phome_ecms_news` [ RunTime:0.001525s ]
SELECT * FROM `phome_ecms_news` WHERE `title` LIKE '%海产品、生鲜%' ORDER BY `id` DESC LIMIT 20 [ RunTime:0.147987s ]
SELECT * FROM `phome_ecms_news` ORDER BY `id` DESC LIMIT 20 [ RunTime:0.000954s ]
SHOW FULL COLUMNS FROM `db_cms_picture_juhe` [ RunTime:0.001846s ]
SELECT * FROM `db_cms_picture_juhe` WHERE `id` <> 0 AND `title` LIKE '%海产品、生鲜%' LIMIT 20 [ RunTime:0.001175s ]
SELECT * FROM `db_cms_picture_juhe` WHERE `id` <> 0 AND `title` LIKE '%%' LIMIT 20 [ RunTime:0.000689s ]
SHOW FULL COLUMNS FROM `db_cms_question_juhe` [ RunTime:0.001490s ]
SELECT * FROM `db_cms_question_juhe` WHERE `id` <> 0 AND `title` LIKE '%海产品、生鲜%' LIMIT 20 [ RunTime:0.000935s ]
SELECT * FROM `db_cms_question_juhe` WHERE `id` <> 0 AND `title` LIKE '%%' LIMIT 20 [ RunTime:0.000605s ]
SELECT * FROM `db_cms_question_juhe` WHERE `id` NOT IN (0,1,7,8) AND `title` LIKE '%%' LIMIT 17 [ RunTime:0.000547s ]
SELECT * FROM `db_cms_question_juhe` WHERE `id` NOT IN (0,1,7,8) ORDER BY `id` DESC LIMIT 17 [ RunTime:0.000521s ]
49
