UPDATE tag t LEFT JOIN (SELECT tag_id, SUM(type='article') wm, SUM(type='avatar') tx FROM tag_rel GROUP BY tag_id) s ON s.tag_id = t.id SET t.wm_counts = COALESCE(s.wm,0), t.tx_counts = COALESCE(s.tx,0) [ RunTime:0.695570s ]
SHOW FULL COLUMNS FROM `tag` [ RunTime:0.001389s ]
SELECT COUNT(*) AS think_count FROM `tag` WHERE `wm_counts` > 0 [ RunTime:0.000568s ]
SELECT COUNT(*) AS think_count FROM `tag` WHERE `tx_counts` > 0 [ RunTime:0.000354s ]
SELECT `id`,`name`,`code`,wm_counts AS counts FROM `tag` WHERE `wm_counts` > 0 ORDER BY `wm_counts` DESC LIMIT 500 [ RunTime:0.001059s ]
SELECT `id`,`name`,`code`,tx_counts AS counts FROM `tag` WHERE `tx_counts` > 0 ORDER BY `tx_counts` DESC LIMIT 500 [ RunTime:0.000924s ]
SHOW FULL COLUMNS FROM `article` [ RunTime:0.001116s ]
SELECT `a`.`id`,`a`.`title`,`a`.`thumb`,c.dirname AS cat_dir FROM `article` `a` LEFT JOIN `category` `c` ON `c`.`id`=`a`.`cat_id` ORDER BY `a`.`id` DESC LIMIT 10 [ RunTime:0.000271s ]
SHOW FULL COLUMNS FROM `avatar` [ RunTime:0.000960s ]
SELECT `a`.`id`,`a`.`title`,c.dirname AS cat_dir,i.path AS first_image FROM `avatar` `a` LEFT JOIN `category` `c` ON `c`.`id`=`a`.`cat_id` LEFT JOIN `avatar_image` `i` ON `i`.`avatar_id`=a.id AND i.sort = 1 ORDER BY `a`.`id` DESC LIMIT 10 [ RunTime:0.000354s ]
SELECT CONCAT(md5, ext) AS url FROM attachment_map WHERE id = '389099' [ RunTime:0.000218s ]
SELECT CONCAT(md5, ext) AS url FROM attachment_map WHERE id = '389095' [ RunTime:0.000158s ]
SELECT CONCAT(md5, ext) AS url FROM attachment_map WHERE id = '389093' [ RunTime:0.000170s ]
SELECT CONCAT(md5, ext) AS url FROM attachment_map WHERE id = '389092' [ RunTime:0.000160s ]
SELECT CONCAT(md5, ext) AS url FROM attachment_map WHERE id = '389090' [ RunTime:0.000151s ]
SELECT CONCAT(md5, ext) AS url FROM attachment_map WHERE id = '389085' [ RunTime:0.000143s ]
SELECT CONCAT(md5, ext) AS url FROM attachment_map WHERE id = '389083' [ RunTime:0.000158s ]
SELECT CONCAT(md5, ext) AS url FROM attachment_map WHERE id = '389082' [ RunTime:0.000167s ]
SELECT CONCAT(md5, ext) AS url FROM attachment_map WHERE id = '389081' [ RunTime:0.000148s ]
SELECT CONCAT(md5, ext) AS url FROM attachment_map WHERE id = '389080' [ RunTime:0.000172s ]
