SHOW FULL COLUMNS FROM `cms_home_links` [ RunTime:0.000891s ]
SELECT * FROM `cms_home_links` ORDER BY `sort` DESC [ RunTime:0.000188s ]
SHOW FULL COLUMNS FROM `cms_admin_information` [ RunTime:0.000776s ]
SELECT * FROM `cms_admin_information` WHERE ( `id` = 1414 ) AND `cms_admin_information`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000209s ]
SHOW FULL COLUMNS FROM `cms_home_member` [ RunTime:0.000789s ]
SELECT * FROM `cms_home_member` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000179s ]
SHOW FULL COLUMNS FROM `cms_home_attention` [ RunTime:0.000682s ]
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.000125s ]
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.000207s ]
SHOW FULL COLUMNS FROM `cms_home_like` [ RunTime:0.000672s ]
SELECT * FROM `cms_home_like` WHERE `information_id` = 1414 AND `comment_id` = 9 AND `delete_time` IS NULL [ RunTime:0.000144s ]
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.000175s ]
SHOW FULL COLUMNS FROM `cms_home_comment` [ RunTime:0.000656s ]
SELECT COUNT(*) AS think_count FROM `cms_home_comment` WHERE `reply_id` = 0 AND `information_id` = 1414 LIMIT 1 [ RunTime:0.000156s ]
UPDATE `cms_admin_information` SET `pv` = `pv` + 1 WHERE ( `id` = 1414 ) AND `cms_admin_information`.`delete_time` IS NULL [ RunTime:0.001738s ]
SHOW FULL COLUMNS FROM `cms_home_collection` [ RunTime:0.000676s ]
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.000164s ]
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.000217s ]
SELECT * FROM `cms_admin_information` WHERE ( `id` = 1415 ) AND `cms_admin_information`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000181s ]
SELECT * FROM `cms_admin_information` WHERE ( `id` = 1413 ) AND `cms_admin_information`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000168s ]
SHOW FULL COLUMNS FROM `cms_admin_classify` [ RunTime:0.000669s ]
SELECT * FROM `cms_admin_classify` WHERE ( type != 2 ) ORDER BY `sort` DESC [ RunTime:0.000193s ]