SHOW FULL COLUMNS FROM `cms_home_links` [ RunTime:0.001047s ]
SELECT * FROM `cms_home_links` ORDER BY `sort` DESC [ RunTime:0.000255s ]
SHOW FULL COLUMNS FROM `cms_admin_information` [ RunTime:0.001104s ]
SELECT * FROM `cms_admin_information` WHERE ( `id` = 1414 ) AND `cms_admin_information`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000281s ]
SHOW FULL COLUMNS FROM `cms_home_member` [ RunTime:0.001120s ]
SELECT * FROM `cms_home_member` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000276s ]
SHOW FULL COLUMNS FROM `cms_home_attention` [ RunTime:0.001039s ]
SELECT * FROM `cms_home_attention` WHERE `member_id` IS NULL AND `type` = 1 AND `content_id` = 1414 AND `delete_time` IS NULL LIMIT 1 [ RunTime:0.000193s ]
SELECT
t1.*,
t2.name,
t2.head_portrait,
t2.`level`
FROM
cms_home_comment AS t1
LEFT JOIN cms_home_member AS t2 ON (
t1.member_id = t2.id) where t1.reply_id = 0 and t1.information_id = 1414 [ RunTime:0.000287s ]
SHOW FULL COLUMNS FROM `cms_home_like` [ RunTime:0.000975s ]
SELECT * FROM `cms_home_like` WHERE `information_id` = 1414 AND `comment_id` = 9 AND `delete_time` IS NULL [ RunTime:0.000230s ]
SELECT
t1.*,
t2.name,
t2.head_portrait,
t2.`level`
FROM
cms_home_comment AS t1
LEFT JOIN cms_home_member AS t2 ON (
t1.member_id = t2.id) where t1.reply_id = 9 and t1.information_id = 1414 [ RunTime:0.000249s ]
SHOW FULL COLUMNS FROM `cms_home_comment` [ RunTime:0.000970s ]
SELECT COUNT(*) AS think_count FROM `cms_home_comment` WHERE `reply_id` = 0 AND `information_id` = 1414 LIMIT 1 [ RunTime:0.000219s ]
UPDATE `cms_admin_information` SET `pv` = `pv` + 1 WHERE ( `id` = 1414 ) AND `cms_admin_information`.`delete_time` IS NULL [ RunTime:0.002100s ]
SHOW FULL COLUMNS FROM `cms_home_collection` [ RunTime:0.001014s ]
SELECT COUNT(*) AS think_count FROM `cms_home_collection` WHERE `type` = 1 AND `content_id` = 1414 AND `delete_time` IS NULL LIMIT 1 [ RunTime:0.000232s ]
SELECT
t1.*,
t2.name,
t2.head_portrait,
t2.`level`
FROM
cms_home_comment AS t1
LEFT JOIN cms_home_member AS t2 ON (
t1.member_id = t2.id) where t1.reply_id = 0 [ RunTime:0.000338s ]
SELECT * FROM `cms_admin_information` WHERE ( `id` = 1415 ) AND `cms_admin_information`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000302s ]
SELECT * FROM `cms_admin_information` WHERE ( `id` = 1413 ) AND `cms_admin_information`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000269s ]
SHOW FULL COLUMNS FROM `cms_admin_classify` [ RunTime:0.000993s ]
SELECT * FROM `cms_admin_classify` WHERE ( type != 2 ) ORDER BY `sort` DESC [ RunTime:0.000284s ]