SELECT c.*,cs.name column_sort_name FROM zl_column c LEFT JOIN zl_column_sort cs on cs.id = c.column_sort_id WHERE c.id = '349' AND c.status = 1 AND c.is_public = 1 LIMIT 1 [ RunTime:0.0007s ]
SHOW COLUMNS FROM `zl_column_sort` [ RunTime:0.0005s ]
SELECT `id`,`name`,`path` FROM `zl_column_sort` WHERE `id` = 4 LIMIT 1 [ RunTime:0.0003s ]
SHOW COLUMNS FROM `zl_column_collect` [ RunTime:0.0005s ]
UPDATE `zl_column` SET `click_num`=click_num+1 WHERE `id` = 349 [ RunTime:0.0357s ]
SHOW COLUMNS FROM `zl_member` [ RunTime:0.0007s ]
SHOW COLUMNS FROM `zl_member_subscribe` [ RunTime:0.0007s ]
SHOW COLUMNS FROM `zl_column` [ RunTime:0.0006s ]
SHOW COLUMNS FROM `zl_column_article` [ RunTime:0.0006s ]
SELECT * FROM `zl_member` WHERE `id` = 3757 LIMIT 1 [ RunTime:0.0005s ]
SELECT COUNT(*) AS tp_count FROM `zl_column` WHERE `member_id` = 3757 AND `is_public` = 1 AND `status` = 1 LIMIT 1 [ RunTime:0.0008s ]
SELECT COUNT(*) AS tp_count FROM `zl_member_subscribe` WHERE `subscribe_member_id` = 3757 LIMIT 1 [ RunTime:0.3027s ]
SELECT SUM(click_num) AS tp_sum FROM `zl_column` WHERE `member_id` = 3757 AND `status` = 1 AND `is_public` = 1 LIMIT 1 [ RunTime:0.0009s ]
SELECT COUNT(*) AS tp_count FROM zl_column_article ca WHERE `column_id` = 349 AND ca.status = 1 AND ca.is_publish = 1 LIMIT 1 [ RunTime:0.0005s ]
SELECT ca.*,c.head_img,c.short_intro FROM zl_column_article ca LEFT JOIN zl_column c on c.id = ca.column_id WHERE `column_id` = '349' AND ca.status = 1 AND ca.is_publish = 1 ORDER BY ca.id asc LIMIT 0,10 [ RunTime:0.0006s ]
SELECT * FROM `zl_column` WHERE `member_id` = 3757 AND `is_public` = 1 AND `status` = 1 AND `id` NOT IN ('349') LIMIT 5 [ RunTime:0.0009s ]
SELECT c.*,m.nick_name,m.head_img member_head_img FROM zl_column c LEFT JOIN zl_member m on m.id = c.member_id WHERE c.column_sort_id = '4' AND c.status = 1 AND c.member_id NOT IN ('3757') ORDER BY rand() LIMIT 5 [ RunTime:0.0013s ]