Public Pastes
SHARE
TWEET

Untitled

a guest Oct 12th, 2011 269 Never
  1. Reading mysql slow query log from /var/log/mysql/mysql-slow.log
  2. Count: 1  Time=44.87s (44s)  Lock=0.00s (0s)  Rows=85.0 (85), rick[rick]@[192.168.180.68]
  3.   SELECT author_id, topic_id FROM posts WHERE  queued=N  AND author_id=N AND topic_id IN(N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N)
  4.  
  5. Count: 3  Time=26.89s (80s)  Lock=0.00s (0s)  Rows=200.0 (600), rick[rick]@[192.168.180.68]
  6.   SELECT p.pid, p.queued,t.approved, t.forum_id FROM posts p  LEFT JOIN topics t ON ( p.topic_id=t.tid )   WHERE t.forum_id IN (N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N) AND  p.queued=N  AND  t.approved=N  AND MATCH( p.post ) AGAINST( 'S' IN BOOLEAN MODE ) AND t.state != 'S' ORDER BY post_date desc LIMIT N,N
  7.  
  8. Count: 1  Time=25.60s (25s)  Lock=0.00s (0s)  Rows=605.0 (605), rick[rick]@[192.168.180.68]
  9.   SELECT author_id, topic_id FROM posts WHERE  queued=N  AND author_id=N AND topic_id IN(N,N,N,N,N,N,N,N,N,N,N,N,N)
  10.  
  11. Count: 3  Time=22.47s (67s)  Lock=0.29s (0s)  Rows=149.7 (449), rick[rick]@[192.168.180.68]
  12.   SELECT p.pid, p.queued,t.approved, t.forum_id FROM posts p  LEFT JOIN topics t ON ( p.topic_id=t.tid )   WHERE t.forum_id=N AND  p.queued=N  AND  t.approved=N  AND MATCH( p.post ) AGAINST( 'S' IN BOOLEAN MODE ) AND t.state != 'S' ORDER BY post_date desc LIMIT N,N
  13.  
  14. Count: 7  Time=19.42s (135s)  Lock=0.00s (0s)  Rows=200.0 (1400), rick[rick]@[192.168.180.68]
  15.   SELECT p.pid, p.queued,t.approved, t.forum_id FROM posts p  LEFT JOIN topics t ON ( p.topic_id=t.tid )   WHERE t.forum_id IN (N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N) AND  p.queued=N  AND  t.approved=N  AND MATCH( p.post ) AGAINST( 'S' IN BOOLEAN MODE ) AND t.state != 'S' ORDER BY post_date desc LIMIT N,N
  16.  
  17. Count: 59  Time=19.14s (1129s)  Lock=0.23s (13s)  Rows=204.2 (12050), rick[rick]@[192.168.180.68]
  18.   SELECT author_id, topic_id FROM posts WHERE  queued=N  AND author_id=N AND post_date > N AND topic_id IN(N,N,N,N,N,N,N,N,N,N,N,N,N,N,N)
  19.  
  20. Count: 1  Time=18.64s (18s)  Lock=0.05s (0s)  Rows=32.0 (32), rick[rick]@[192.168.180.68]
  21.   SELECT p.pid as id, p.post_date, p.topic_id,t.title, t.posts, t.views FROM posts p  LEFT JOIN topics t ON ( t.tid=p.topic_id )   WHERE t.forum_id IN (N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N) AND t.tid=N AND  p.queued=N  AND  t.approved=N  AND MATCH( p.post ) AGAINST( 'S' IN BOOLEAN MODE ) AND t.state != 'S' ORDER BY post_date desc LIMIT N,N
  22.  
  23. Count: 394  Time=17.72s (6982s)  Lock=0.06s (24s)  Rows=978.2 (385397), rick[rick]@[192.168.180.68]
  24.   SELECT author_id, topic_id FROM posts WHERE  queued=N  AND author_id=N AND post_date > N AND topic_id IN(N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N)
  25.  
  26. Count: 4  Time=17.72s (70s)  Lock=0.00s (0s)  Rows=1.0 (4), rick[rick]@[192.168.180.68]
  27.   SELECT COUNT(p.author_id) as f_posts,t.forum_id FROM posts p  LEFT JOIN topics t ON ( t.tid=p.topic_id )   WHERE p.author_id=N AND t.forum_id IN (N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N)  GROUP BY t.forum_id ORDER BY f_posts DESC LIMIT N,N
  28.  
  29. Count: 64  Time=17.66s (1129s)  Lock=0.00s (0s)  Rows=646.7 (41387), rick[rick]@[192.168.180.68]
  30.   SELECT author_id, topic_id FROM posts WHERE  queued=N  AND author_id=N AND topic_id IN(N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N)
  31.  
  32. Count: 6  Time=16.26s (97s)  Lock=0.00s (0s)  Rows=757.0 (4542), rick[rick]@[192.168.180.68]
  33.   SELECT author_id, topic_id FROM posts WHERE  queued=N  AND author_id=N AND topic_id IN(N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N)
  34.  
  35. Count: 1  Time=16.14s (16s)  Lock=0.00s (0s)  Rows=429.0 (429), rick[rick]@[192.168.180.68]
  36.   SELECT author_id, topic_id FROM posts WHERE  queued=N  AND author_id=N AND topic_id IN(N,N,N)
  37.  
  38. Count: 2  Time=15.96s (31s)  Lock=0.00s (0s)  Rows=200.0 (400), rick[rick]@[192.168.180.68]
  39.   SELECT p.pid, p.queued,t.approved, t.forum_id FROM posts p  LEFT JOIN topics t ON ( p.topic_id=t.tid )   WHERE t.forum_id IN (N,N,N,N,N) AND  p.queued=N  AND  t.approved=N  AND MATCH( p.post ) AGAINST( 'S' IN BOOLEAN MODE ) AND t.state != 'S' ORDER BY post_date desc LIMIT N,N
  40.  
  41. Count: 1  Time=15.73s (15s)  Lock=0.00s (0s)  Rows=182.0 (182), rick[rick]@[192.168.180.68]
  42.   SELECT pid FROM posts WHERE topic_id IN (N,,{repeated 183 times}N) AND new_topic=N
  43.  
  44. Count: 2  Time=15.43s (30s)  Lock=0.00s (0s)  Rows=1.0 (2), rick[rick]@[192.168.180.68]
  45.   SELECT COUNT(p.author_id) as f_posts,t.forum_id FROM posts p  LEFT JOIN topics t ON ( t.tid=p.topic_id )   WHERE p.author_id=N AND t.forum_id IN (N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N)  GROUP BY t.forum_id ORDER BY f_posts DESC LIMIT N,N
  46.  
  47. Count: 1  Time=14.89s (14s)  Lock=0.00s (0s)  Rows=768.0 (768), rick[rick]@[192.168.180.68]
  48.   SELECT author_id, topic_id FROM posts WHERE  queued=N  AND author_id=N AND topic_id IN(N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N)
  49.  
  50. Count: 2  Time=12.62s (25s)  Lock=0.00s (0s)  Rows=1.0 (2), rick[rick]@[192.168.180.68]
  51.   SELECT COUNT(*) as attachments FROM posts p  LEFT JOIN attachments a ON ( a.attach_rel_id=p.pid AND a.attach_rel_module='S' )   WHERE a.attach_id IS NOT NULL AND p.topic_id=N AND  p.queued=N
  52.  
  53. Count: 1  Time=12.60s (12s)  Lock=0.00s (0s)  Rows=178.0 (178), rick[rick]@[192.168.180.68]
  54.   SELECT author_id, topic_id FROM posts WHERE  queued=N  AND author_id=N AND topic_id IN(N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N)
  55.  
  56. Count: 1  Time=12.52s (12s)  Lock=0.00s (0s)  Rows=24306.0 (24306), rick[rick]@[192.168.180.68]
  57.   SELECT post, post_htmlstate FROM posts WHERE topic_id='S'
  58.  
  59. Count: 1  Time=11.88s (11s)  Lock=0.00s (0s)  Rows=199.0 (199), rick[rick]@[192.168.180.68]
  60.   SELECT pid FROM posts WHERE topic_id IN (N,,{repeated 199 times}N) AND new_topic=N
  61.  
  62. Count: 1  Time=11.84s (11s)  Lock=0.00s (0s)  Rows=441.0 (441), rick[rick]@[192.168.180.68]
  63.   SELECT author_id, topic_id FROM posts WHERE  queued=N  AND author_id=N AND topic_id IN(N,N,N,N,N,N,N,N,N,N,N,N)
  64.  
  65. Count: 1  Time=11.54s (11s)  Lock=0.00s (0s)  Rows=0.0 (0), rick[rick]@[192.168.180.68]
  66.   INSERT INTO posts (`author_id`,`use_sig`,`use_emo`,`ip_address`,`post_date`,`post`,`author_name`,`topic_id`,`queued`,`post_htmlstate`,`post_bwoptions`,`post_key`) VALUES(N,N,N,'S',N,'S','S',N,N,N,N,'S')
  67.  
  68. Count: 1  Time=11.07s (11s)  Lock=0.00s (0s)  Rows=298.0 (298), rick[rick]@[192.168.180.68]
  69.   SELECT author_id, topic_id FROM posts WHERE  queued=N  AND author_id=N AND post_date > N AND topic_id IN(N,N,N,N,N,N,N)
  70.  
  71. Count: 23  Time=5.49s (126s)  Lock=0.00s (0s)  Rows=1.0 (23), rick[rick]@[192.168.180.68]
  72.   SELECT count(*) as cnt FROM attachments a  LEFT JOIN posts p ON ( p.pid=a.attach_rel_id )   WHERE a.attach_rel_module='S' AND p.topic_id=N
  73.  
  74. Count: 2  Time=3.11s (6s)  Lock=0.00s (0s)  Rows=0.0 (0), debian-sys-maint[debian-sys-maint]@localhost
  75.   select count(*) into @discard from `information_schema`.`PARTITIONS`
  76.  
  77. Count: 2  Time=3.00s (5s)  Lock=0.00s (0s)  Rows=489.0 (978), debian-sys-maint[debian-sys-maint]@localhost
  78.   select concat('S',
  79.   TABLE_SCHEMA, 'S', TABLE_NAME, 'S')
  80.   from information_schema.TABLES where ENGINE='S'
  81.  
  82. Count: 4  Time=1.15s (4s)  Lock=0.00s (0s)  Rows=15.0 (60), rick[rick]@[192.168.180.68]
  83.   SELECT s.*,m.*,pp.* FROM member_status_updates s  LEFT JOIN members m ON ( m.member_id=s.status_author_id )
  84.   LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id )   ORDER BY s.status_date desc LIMIT N,N
  85.  
  86. Count: 2  Time=0.38s (0s)  Lock=0.00s (0s)  Rows=18.0 (36), rick[rick]@[192.168.180.68]
  87.   SELECT  m.member_id FROM members m  LEFT JOIN pfields_content p ON ( p.member_id=m.member_id )
  88.   LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id )   WHERE m.members_l_display_name !='S' AND m.members_l_display_name  IS NOT NULL  AND m.member_group_id NOT IN(N,N) ORDER BY m.joined desc LIMIT N,N
  89.  
  90. Count: 6  Time=0.35s (2s)  Lock=0.00s (0s)  Rows=1.0 (6), rick[rick]@[192.168.180.68]
  91.   SELECT COUNT( * ) as cnt FROM members m  LEFT JOIN pfields_content p ON ( p.member_id=m.member_id )
  92.   LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id )   WHERE m.members_l_display_name !='S' AND m.members_l_display_name  IS NOT NULL  AND m.member_group_id NOT IN(N,N)
  93.  
  94. Count: 2  Time=0.29s (0s)  Lock=0.00s (0s)  Rows=27.0 (54), rick[rick]@[192.168.180.68]
  95.   SELECT * FROM banfilters
  96.  
  97. Count: 1  Time=0.24s (0s)  Lock=0.00s (0s)  Rows=4.0 (4), rick[rick]@[192.168.180.68]
  98.   SELECT * FROM subscription_currency
  99.  
  100. Count: 2  Time=0.23s (0s)  Lock=0.00s (0s)  Rows=0.0 (0), debian-sys-maint[debian-sys-maint]@localhost
  101.   select count(*) into @discard from `information_schema`.`COLUMNS`
  102.  
  103. Count: 2  Time=0.23s (0s)  Lock=0.00s (0s)  Rows=5.5 (11), rick[rick]@[192.168.180.68]
  104.   SELECT p.pid, p.topic_id,a.* FROM posts p  LEFT JOIN attachments a ON ( a.attach_rel_id=p.pid AND a.attach_rel_module='S' )   WHERE a.attach_id IS NOT NULL AND p.topic_id=N AND  p.queued=N  ORDER BY p.pid ASC, a.attach_id ASC LIMIT N,N
  105.  
  106. Count: 1  Time=0.21s (0s)  Lock=0.00s (0s)  Rows=1.0 (1), rick[rick]@[192.168.180.68]
  107.   SELECT SUM(posts) as replies FROM topics WHERE  approved=N
  108.  
  109. Count: 3  Time=0.18s (0s)  Lock=0.00s (0s)  Rows=10.0 (30), rick[rick]@[192.168.180.68]
  110.   SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE N=N  AND ( wp_term_relationships.term_taxonomy_id IN (N,N,N,N,N,N,N) ) AND wp_posts.post_type = 'S' AND (wp_posts.post_status = 'S') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT N, N
  111.  
  112. Count: 2  Time=0.17s (0s)  Lock=0.00s (0s)  Rows=1.0 (2), rick[rick]@[192.168.180.68]
  113.   SELECT app_key FROM conv_apps WHERE login=N
  114.  
  115. Count: 11  Time=0.17s (1s)  Lock=0.00s (0s)  Rows=1.0 (11), rick[rick]@[192.168.180.68]
  116.   SELECT mem.*, mem.title as member_title, reps.*, rcl.my_class, MAX(star.points) as points, rep.*, grop.g_is_supmod as iscop, s.id as session_id, pf.*, ((rep.num_reports * stat.points_per_report)+FLOOR(((N-rep.date_created)/N)/ CASE WHEN stat.minutes_to_apoint > N THEN stat.minutes_to_apoint ELSE N END )) as built_points FROM rc_reports reps LEFT JOIN members mem ON (mem.member_id=reps.report_by) LEFT JOIN profile_portal pf ON (mem.member_id=pf.pp_member_id) LEFT JOIN rc_reports_index rep ON (rep.id=reps.rid) LEFT JOIN groups grop ON (grop.g_id=mem.member_group_id) LEFT JOIN sessions s ON (s.member_id=mem.member_id) LEFT JOIN rc_status stat ON (stat.status=rep.status) LEFT JOIN rc_status_sev star ON (((rep.num_reports * stat.points_per_report)+FLOOR(((N-rep.date_created)/N)/ CASE WHEN stat.minutes_to_apoint > N THEN stat.minutes_to_apoint ELSE N END ))>=star.points AND star.status=rep.status) LEFT JOIN rc_classes rcl ON (rcl.com_id=rep.rc_class) WHERE rcl.com_id IN(N,N,N,N) AND reps.rid= N GROUP BY reps.id ORDER BY reps.date_reported ASC
  117.  
  118. Count: 7  Time=0.14s (0s)  Lock=0.00s (0s)  Rows=4.6 (32), rick[rick]@[192.168.180.68]
  119.   SELECT views_member_id, COUNT(*) as profile_views FROM profile_portal_views GROUP BY views_member_id
  120.  
  121. Count: 10  Time=0.12s (1s)  Lock=0.03s (0s)  Rows=2.4 (24), rick[rick]@[192.168.180.68]
  122.   SELECT rep.*, rcl.my_class, rcl.extra_data, mem.members_display_name as n_updated_by, mem.members_seo_name as n_updated_seoname, mem.member_group_id, MAX(star.points) as points, ((rep.num_reports * stat.points_per_report)+FLOOR(((N-rep.date_created)/N)/ CASE WHEN stat.minutes_to_apoint > N THEN stat.minutes_to_apoint ELSE N END )) as built_points FROM rc_reports_index rep LEFT JOIN members mem ON (mem.member_id=rep.updated_by) LEFT JOIN rc_status stat ON (stat.status=rep.status) LEFT JOIN rc_status_sev star ON (((rep.num_reports * stat.points_per_report)+FLOOR(((N-rep.date_created)/N)/ CASE WHEN stat.minutes_to_apoint > N THEN stat.minutes_to_apoint ELSE N END ))>=star.points AND star.status=rep.status) LEFT JOIN rc_classes rcl ON (rcl.com_id=rep.rc_class) WHERE rcl.com_id IN(N,N,N,N) AND stat.is_active=N GROUP BY rep.id ORDER BY rep.date_updated DESC, stat.rorder ASC, built_points DESC LIMIT N, N
  123.  
  124. Count: 15  Time=0.09s (1s)  Lock=0.00s (0s)  Rows=190.2 (2853), rick[rick]@[192.168.180.68]
  125.   SELECT option_name, option_value FROM wp_options WHERE autoload = 'S'
  126.  
  127. Count: 1  Time=0.07s (0s)  Lock=0.00s (0s)  Rows=1.0 (1), rick[rick]@[192.168.180.68]
  128.   SELECT MAX(ref_id) as ref_id FROM exp_referrers WHERE site_id = 'S'
  129.  
  130. Count: 4  Time=0.07s (0s)  Lock=0.00s (0s)  Rows=1.0 (4), rick[rick]@[192.168.180.68]
  131.   SELECT count(*) as cnt FROM member_status_updates s  LEFT JOIN members m ON ( m.member_id=s.status_author_id )
  132.   LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id )
  133.  
  134. Count: 2  Time=0.07s (0s)  Lock=0.00s (0s)  Rows=2.0 (4), rick[rick]@[192.168.180.68]
  135.   SELECT status, is_new, is_complete FROM rc_status WHERE is_new=N OR is_complete=N
  136.  
  137. Count: 11  Time=0.06s (0s)  Lock=0.00s (0s)  Rows=2.6 (29), rick[rick]@[192.168.180.68]
  138.   SELECT c.*,m.*,pc.*,pp.*,rep_index.rep_rating as has_given_rep,rep_cache.rep_points, rep_like_cache FROM rc_comments c  LEFT JOIN members m ON ( m.member_id=c.comment_by )
  139.   LEFT JOIN pfields_content pc ON ( pc.member_id=m.member_id )
  140.   LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id )
  141.   LEFT JOIN reputation_index rep_index ON ( rep_index.app='S' AND
  142.   rep_index.type='S' AND
  143.   rep_index.type_id=c.id AND
  144.   rep_index.member_id=N )
  145.   LEFT JOIN reputation_cache rep_cache ON ( rep_cache.app='S' AND rep_cache.type='S' AND rep_cache.type_id=c.id )   WHERE c.rid=N AND c.approved=N ORDER BY comment_date asc LIMIT N,N
  146.  
  147. Count: 1  Time=0.06s (0s)  Lock=0.00s (0s)  Rows=5.0 (5), rick[rick]@[192.168.180.68]
  148.   SELECT * FROM subscriptions ORDER BY sub_cost
  149.  
  150. Count: 43  Time=0.06s (2s)  Lock=0.00s (0s)  Rows=0.9 (38), rick[rick]@[192.168.180.68]
  151.   SELECT *,sub_title FROM subscription_trans t,subscriptions p WHERE t.subtrans_member_id=N AND t.subtrans_state IN ('S', 'S') AND p.sub_id=t.subtrans_sub_id
  152.  
  153. Count: 1  Time=0.04s (0s)  Lock=0.00s (0s)  Rows=15.0 (15), rick[rick]@[192.168.180.68]
  154.   SELECT friends_member_id FROM profile_friends WHERE friends_friend_id=N
  155.  
  156. Count: 8  Time=0.04s (0s)  Lock=0.00s (0s)  Rows=1.0 (8), rick[rick]@[192.168.180.68]
  157.   SELECT COUNT(*) as reports FROM rc_reports_index rep  LEFT JOIN rc_classes rcl ON ( rcl.com_id=rep.rc_class )
  158.   LEFT JOIN rc_status stat ON ( stat.status=rep.status )   WHERE rcl.com_id IN(N,N,N,N) AND stat.is_active=N
  159.  
  160. Count: 6  Time=0.04s (0s)  Lock=0.00s (0s)  Rows=10.0 (60), rick[rick]@[192.168.180.68]
  161.   SELECT log_id, log_data_app, log_data_type, log_data_primary_id FROM core_share_links_log ORDER BY log_date DESC LIMIT N,N
  162.  
  163. Count: 20  Time=0.03s (0s)  Lock=0.00s (0s)  Rows=7.2 (144), rick[rick]@[192.168.180.68]
  164.   SELECT * FROM mail_queue ORDER BY mail_id ASC LIMIT N,N
  165.  
  166. Count: 6  Time=0.03s (0s)  Lock=0.00s (0s)  Rows=0.0 (0), rick[rick]@[192.168.180.68]
  167.   DELETE FROM core_share_links_caches WHERE cache_key IN ('S', 'S', 'S')
  168.  
  169. Count: 3  Time=0.03s (0s)  Lock=0.00s (0s)  Rows=74.0 (222), rick[rick]@[192.168.180.68]
  170.   SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (N,N,N,N,N,N,N,N,N,N)
  171.  
  172. Count: 1  Time=0.03s (0s)  Lock=0.00s (0s)  Rows=115.0 (115), rick[rick]@[192.168.180.68]
  173.   SELECT typed, image FROM emoticons WHERE emo_set='S'
  174.  
  175. Count: 1  Time=0.03s (0s)  Lock=0.00s (0s)  Rows=1.0 (1), rick[rick]@[192.168.180.68]
  176.   SELECT COUNT(*) as cnt, MIN(date_updated) AS lastItem FROM rc_reports_index WHERE id NOT IN(N,N,N,N,N,N,N,N,N,N,N) AND date_updated > N
  177.  
  178. Count: 3  Time=0.03s (0s)  Lock=0.00s (0s)  Rows=7.0 (21), rick[rick]@[192.168.180.68]
  179.   SELECT  DISTINCT(t.entry_id),  t.entry_id, t.weblog_id, t.forum_topic_id, t.author_id, t.ip_address, t.title, t.url_title, t.status, t.dst_enabled, t.view_count_one, t.view_count_two, t.view_count_three, t.view_count_four, t.allow_comments, t.comment_expiration_date, t.allow_trackbacks, t.sticky, t.entry_date, t.year, t.month, t.day, t.edit_date, t.expiration_date, t.recent_comment_date, t.comment_total, t.trackback_total, t.sent_trackbacks, t.recent_trackback_date, t.site_id as entry_site_id,
  180.   w.blog_title, w.blog_name, w.blog_url, w.comment_url, w.tb_return_url, w.comment_moderate, w.weblog_html_formatting, w.weblog_allow_img_urls, w.weblog_auto_link_urls, w.enable_trackbacks, w.trackback_use_url_title, w.trackback_field, w.trackback_use_captcha, w.trackback_system_enabled,
  181.   m.username, m.email, m.url, m.screen_name, m.location, m.occupation, m.interests, m.aol_im, m.yahoo_im, m.msn_im, m.icq, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.group_id, m.member_id, m.bday_d, m.bday_m, m.bday_y, m.bio,
  182.   md.*,
  183.   wd.*
  184.   FROM exp_weblog_titles                AS t
  185.   LEFT JOIN exp_weblogs                 AS w  ON t.weblog_id = w.weblog_id
  186.   LEFT JOIN exp_weblog_data     AS wd ON t.entry_id = wd.entry_id
  187.   LEFT JOIN exp_members         AS m  ON m.member_id = t.author_id
  188.   LEFT JOIN exp_member_data     AS md ON md.member_id = m.member_id WHERE t.entry_id IN (N,N,N,N,N,N,N) ORDER BY t.sticky desc, t.entry_date desc
  189.  
  190. Count: 640  Time=0.03s (18s)  Lock=0.00s (0s)  Rows=29.6 (18912), rick[rick]@[192.168.180.68]
  191.   SELECT * FROM core_like WHERE ((like_lookup_id='S' )  OR like_id='S') AND like_visible=N ORDER BY like_added DESC LIMIT N,N
  192.  
  193. Count: 2  Time=0.03s (0s)  Lock=0.00s (0s)  Rows=12.0 (24), rick[rick]@[192.168.180.68]
  194.   SELECT c.cat_name, c.cat_url_title, c.cat_id, c.cat_image, c.cat_description, c.parent_id,
  195.   p.cat_id, p.entry_id, c.group_id , cg.field_html_formatting, fd.*
  196.   FROM  (exp_categories AS c, exp_category_posts AS p)
  197.   LEFT JOIN exp_category_field_data AS fd ON fd.cat_id = c.cat_id
  198.   LEFT JOIN exp_category_groups AS cg ON cg.group_id = c.group_id
  199.   WHERE c.cat_id = p.cat_id
  200.   AND           p.entry_id IN ('S','S','S','S','S','S','S','S','S','S') ORDER BY c.group_id, c.parent_id, c.cat_order
  201.  
  202. Count: 2  Time=0.03s (0s)  Lock=0.00s (0s)  Rows=1.0 (2), rick[rick]@[192.168.180.68]
  203.   SELECT COUNT(*) as total FROM rc_reports WHERE rid='S'
  204.  
  205. Count: 7  Time=0.03s (0s)  Lock=0.00s (0s)  Rows=2.4 (17), rick[rick]@[192.168.180.68]
  206.   SELECT rep.id, rep.title, rep.num_reports, rep.exdat1, rep.exdat2, rep.exdat3,stat.is_active, stat.is_new,rcl.com_id, rcl.com_id, rcl.my_class, rcl.extra_data FROM rc_reports_index rep  LEFT JOIN rc_status stat ON ( stat.status=rep.status )
  207.   LEFT JOIN rc_classes rcl ON ( rcl.com_id=rep.rc_class )   WHERE rcl.com_id IN(N,N,N,N) AND (stat.is_active=N OR stat.is_new=N) AND rcl.onoff=N ORDER BY stat.is_new ASC
  208.  
  209. Count: 13  Time=0.02s (0s)  Lock=0.00s (0s)  Rows=4.0 (52), rick[rick]@[192.168.180.68]
  210.   SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE N=N  AND wp_posts.ID NOT IN (N) AND ( wp_term_relationships.term_taxonomy_id IN (N,N) ) AND wp_posts.post_type = 'S' AND (wp_posts.post_status = 'S') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT N, N
  211.  
  212. Count: 4  Time=0.02s (0s)  Lock=0.00s (0s)  Rows=10.0 (40), rick[rick]@[192.168.180.68]
  213.   SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE N=N  AND ( wp_term_relationships.term_taxonomy_id IN (N,N,N,N,N,N,N,N) ) AND wp_posts.post_type = 'S' AND (wp_posts.post_status = 'S') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT N, N
  214.  
  215. Count: 11  Time=0.02s (0s)  Lock=0.00s (0s)  Rows=4.0 (44), rick[rick]@[192.168.180.68]
  216.   SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE N=N  AND wp_posts.ID NOT IN (N) AND ( wp_term_relationships.term_taxonomy_id IN (N,N,N) ) AND wp_posts.post_type = 'S' AND (wp_posts.post_status = 'S') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT N, N
  217.  
  218. Count: 1  Time=0.02s (0s)  Lock=0.00s (0s)  Rows=1.0 (1), rick[rick]@[192.168.180.68]
  219.   SELECT st.subtrans_member_id,m.member_id, m.name, m.members_display_name, m.email, m.sub_end FROM subscription_trans st  LEFT JOIN members m ON ( m.member_id=st.subtrans_member_id )   WHERE st.subtrans_state='S' AND st.subtrans_end_date >= N AND st.subtrans_end_date <= N
  220.  
  221. Count: 1  Time=0.02s (0s)  Lock=0.00s (0s)  Rows=1.0 (1), rick[rick]@[192.168.180.68]
  222.   SELECT st.subtrans_sub_id, st.subtrans_member_id,s.sub_title,se.subextra_recurring FROM subscription_trans st  LEFT JOIN subscriptions s ON ( s.sub_id=st.subtrans_sub_id )
  223.   LEFT JOIN subscription_extra se ON ( se.subextra_sub_id=s.sub_id )   WHERE st.subtrans_member_id IN (N) AND st.subtrans_state='S'
  224.  
  225. Count: 2  Time=0.01s (0s)  Lock=0.00s (0s)  Rows=0.0 (0), debian-sys-maint[debian-sys-maint]@localhost
  226.   select count(*) into @discard from `information_schema`.`TRIGGERS`
  227.  
  228. Count: 5  Time=0.01s (0s)  Lock=0.00s (0s)  Rows=23.0 (115), rick[rick]@[192.168.180.68]
  229.   SELECT m.member_id as real_member_id, m.members_display_name as name, m.language, m.members_disable_pm, m.email, m.member_group_id,noti.*,moderator.member_id, moderator.group_id FROM members m  LEFT JOIN rc_modpref noti ON ( m.member_id=noti.mem_id )
  230.   LEFT JOIN moderators moderator ON ( moderator.member_id=m.member_id OR moderator.group_id=m.member_group_id )
  231.   LEFT JOIN groups g ON ( g.g_id=m.member_group_id )   WHERE (m.member_group_id IN(N,N) ) AND (g.g_is_supmod=N OR g.g_access_cp=N OR moderator.forum_id LIKE 'S')
  232.  
  233. Count: 6  Time=0.01s (0s)  Lock=0.00s (0s)  Rows=1.0 (6), rick[rick]@[192.168.180.68]
  234.   SELECT COUNT(*) as count, log_data_app, log_data_type, log_data_primary_id FROM core_share_links_log GROUP BY log_data_app, log_data_type, log_data_primary_id ORDER BY count DESC LIMIT N,N
  235.  
  236. Count: 2  Time=0.01s (0s)  Lock=0.00s (0s)  Rows=7.0 (14), rick[rick]@[192.168.180.68]
  237.   SELECT  t.entry_id, t.weblog_id, t.forum_topic_id, t.author_id, t.ip_address, t.title, t.url_title, t.status, t.dst_enabled, t.view_count_one, t.view_count_two, t.view_count_three, t.view_count_four, t.allow_comments, t.comment_expiration_date, t.allow_trackbacks, t.sticky, t.entry_date, t.year, t.month, t.day, t.edit_date, t.expiration_date, t.recent_comment_date, t.comment_total, t.trackback_total, t.sent_trackbacks, t.recent_trackback_date, t.site_id as entry_site_id,
  238.   w.blog_title, w.blog_name, w.blog_url, w.comment_url, w.tb_return_url, w.comment_moderate, w.weblog_html_formatting, w.weblog_allow_img_urls, w.weblog_auto_link_urls, w.enable_trackbacks, w.trackback_use_url_title, w.trackback_field, w.trackback_use_captcha, w.trackback_system_enabled,
  239.   m.username, m.email, m.url, m.screen_name, m.location, m.occupation, m.interests, m.aol_im, m.yahoo_im, m.msn_im, m.icq, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.group_id, m.member_id, m.bday_d, m.bday_m, m.bday_y, m.bio,
  240.   md.*,
  241.   wd.*
  242.   FROM exp_weblog_titles                AS t
  243.   LEFT JOIN exp_weblogs                 AS w  ON t.weblog_id = w.weblog_id
  244.   LEFT JOIN exp_weblog_data     AS wd ON t.entry_id = wd.entry_id
  245.   LEFT JOIN exp_members         AS m  ON m.member_id = t.author_id
  246.   LEFT JOIN exp_member_data     AS md ON md.member_id = m.member_id WHERE t.entry_id IN (N,N,N,N,N,N,N) ORDER BY t.sticky desc, t.entry_date desc
  247.  
  248. Count: 5  Time=0.01s (0s)  Lock=0.00s (0s)  Rows=1666.0 (8330), rick[rick]@[192.168.180.68]
  249.   SELECT views_tid, COUNT(*) as topicviews FROM topic_views GROUP BY views_tid
  250.  
  251. Count: 2  Time=0.01s (0s)  Lock=0.00s (0s)  Rows=2.0 (4), rick[rick]@[192.168.180.68]
  252.   SELECT * FROM login_methods WHERE login_enabled=N
  253.  
  254. Count: 1  Time=0.01s (0s)  Lock=0.00s (0s)  Rows=1.0 (1), rick[rick]@[192.168.180.68]
  255.   SELECT * FROM subscription_extra WHERE subextra_sub_id=N AND subextra_method_id=N
  256.  
  257. Count: 1  Time=0.01s (0s)  Lock=0.00s (0s)  Rows=1.0 (1), rick[rick]@[192.168.180.68]
  258.   SELECT s.*,m.*,pp.* FROM member_status_updates s  LEFT JOIN members m ON ( m.member_id=s.status_author_id )
  259.   LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id )   WHERE s.status_approved=N ORDER BY s.status_date desc LIMIT N,N
  260.  
  261. Count: 1121  Time=0.01s (10s)  Lock=0.00s (0s)  Rows=35.0 (39235), rick[rick]@[192.168.180.68]
  262.   SELECT * FROM cache_store WHERE cs_key IN ( 'S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S','S' )
  263.  
  264. Count: 1  Time=0.01s (0s)  Lock=0.00s (0s)  Rows=1.0 (1), rick[rick]@[192.168.180.68]
  265.   SELECT * FROM subscription_methods WHERE submethod_active=N
  266.  
  267. Count: 2  Time=0.01s (0s)  Lock=0.00s (0s)  Rows=11.0 (22), rick[rick]@[192.168.180.68]
  268.   SELECT module_version, module_name FROM exp_modules
  269.  
  270. Count: 2  Time=0.01s (0s)  Lock=0.00s (0s)  Rows=12.5 (25), rick[rick]@[192.168.180.68]
  271.   SELECT SQL_CALC_FOUND_ROWS * FROM sessions WHERE running_time > N AND login_type != N ORDER BY running_time desc LIMIT N,N
  272.  
  273. Count: 1  Time=0.01s (0s)  Lock=0.00s (0s)  Rows=1.0 (1), rick[rick]@[192.168.180.68]
  274.   SELECT COUNT(*) as cnt, MIN(date_updated) AS lastItem FROM rc_reports_index WHERE id NOT IN(N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N) AND date_updated > N
  275.  
  276. Count: 2  Time=0.01s (0s)  Lock=0.00s (0s)  Rows=15.0 (30), rick[rick]@[192.168.180.68]
  277.   SELECT field_id, field_type, field_name, exp_weblog_fields.site_id
  278.   FROM exp_weblog_fields, exp_weblogs
  279.   WHERE exp_weblogs.field_group = exp_weblog_fields.group_id AND exp_weblogs.is_user_blog = 'S'
  280.  
  281. Count: 5  Time=0.01s (0s)  Lock=0.01s (0s)  Rows=12.2 (61), rick[rick]@[192.168.180.68]
  282.   SELECT c.cat_name, c.cat_url_title, c.cat_id, c.cat_image, c.cat_description, c.parent_id,
  283.   p.cat_id, p.entry_id, c.group_id , cg.field_html_formatting, fd.*
  284.   FROM  (exp_categories AS c, exp_category_posts AS p)
  285.   LEFT JOIN exp_category_field_data AS fd ON fd.cat_id = c.cat_id
  286.   LEFT JOIN exp_category_groups AS cg ON cg.group_id = c.group_id
  287.   WHERE c.cat_id = p.cat_id
  288.   AND           p.entry_id IN ('S','S','S','S','S','S','S') ORDER BY c.group_id, c.parent_id, c.cat_order
  289.  
  290. Count: 14  Time=0.01s (0s)  Lock=0.00s (0s)  Rows=1.3 (18), rick[rick]@[192.168.180.68]
  291.   SELECT tg.* FROM core_tags tg WHERE tg.tag_meta_parent_id IN (N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N) AND tg.tag_meta_app='S' AND tg.tag_meta_area='S' AND tg.tag_text IN ('S') ORDER BY tg.tag_id desc
  292.  
  293. Count: 2  Time=0.01s (0s)  Lock=0.00s (0s)  Rows=0.0 (0), debian-sys-maint[debian-sys-maint]@localhost
  294.   select count(*) into @discard from `information_schema`.`VIEWS`
  295.  
  296. Count: 1  Time=0.01s (0s)  Lock=0.00s (0s)  Rows=10.0 (10), rick[rick]@[192.168.180.68]
  297.   SELECT id, title, description, app FROM faq ORDER BY position ASC
  298.  
  299. Count: 2  Time=0.01s (0s)  Lock=0.00s (0s)  Rows=10.0 (20), rick[rick]@[192.168.180.68]
  300.   SELECT  t.entry_id, t.weblog_id, t.forum_topic_id, t.author_id, t.ip_address, t.title, t.url_title, t.status, t.dst_enabled, t.view_count_one, t.view_count_two, t.view_count_three, t.view_count_four, t.allow_comments, t.comment_expiration_date, t.allow_trackbacks, t.sticky, t.entry_date, t.year, t.month, t.day, t.edit_date, t.expiration_date, t.recent_comment_date, t.comment_total, t.trackback_total, t.sent_trackbacks, t.recent_trackback_date, t.site_id as entry_site_id,
  301.   w.blog_title, w.blog_name, w.blog_url, w.comment_url, w.tb_return_url, w.comment_moderate, w.weblog_html_formatting, w.weblog_allow_img_urls, w.weblog_auto_link_urls, w.enable_trackbacks, w.trackback_use_url_title, w.trackback_field, w.trackback_use_captcha, w.trackback_system_enabled,
  302.   m.username, m.email, m.url, m.screen_name, m.location, m.occupation, m.interests, m.aol_im, m.yahoo_im, m.msn_im, m.icq, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.group_id, m.member_id, m.bday_d, m.bday_m, m.bday_y, m.bio,
  303.   md.*,
  304.   wd.*
  305.   FROM exp_weblog_titles                AS t
  306.   LEFT JOIN exp_weblogs                 AS w  ON t.weblog_id = w.weblog_id
  307.   LEFT JOIN exp_weblog_data     AS wd ON t.entry_id = wd.entry_id
  308.   LEFT JOIN exp_members         AS m  ON m.member_id = t.author_id
  309.   LEFT JOIN exp_member_data     AS md ON md.member_id = m.member_id WHERE t.entry_id IN (N,N,N,N,N,N,N,N,N,N) ORDER BY t.sticky desc, t.entry_date desc
  310.  
  311. Count: 158  Time=0.01s (0s)  Lock=0.00s (0s)  Rows=0.0 (0), rick[rick]@[192.168.180.68]
  312.   SELECT n.*,m.ips_mobile_token FROM mobile_notifications n  LEFT JOIN members m ON ( n.member_id=m.member_id )   WHERE n.notify_sent=N ORDER BY n.notify_date ASC LIMIT N,N
  313.  
  314. Count: 198  Time=0.01s (1s)  Lock=0.00s (0s)  Rows=4.0 (792), rick[rick]@[192.168.180.68]
  315.   SELECT * FROM rss_export
  316.  
  317. Count: 1  Time=0.01s (0s)  Lock=0.00s (0s)  Rows=378.0 (378), rick[rick]@[192.168.180.68]
  318.   SELECT id, member_id, running_time FROM sessions
  319.  
  320. Count: 3  Time=0.01s (0s)  Lock=0.00s (0s)  Rows=11.0 (33), rick[rick]@[192.168.180.68]
  321.   SELECT stat.status, stat.title, stat.is_new, stat.is_complete,star.img, star.width, star.height, star.points, star.is_png FROM rc_status stat  LEFT JOIN rc_status_sev star ON ( stat.status=star.status )   ORDER BY stat.rorder ASC, star.points ASC
  322.  
  323. Count: 12  Time=0.01s (0s)  Lock=0.00s (0s)  Rows=1.0 (12), rick[rick]@[192.168.180.68]
  324.   SELECT COUNT(*) AS count
  325.   FROM exp_referrers
  326.   WHERE site_id = 'S'
  327.   AND (ref_from = 'S' OR ref_ip = 'S')
  328.   AND ref_date > 'S'
  329.  
  330. Count: 21991  Time=0.01s (118s)  Lock=0.00s (34s)  Rows=0.0 (0), rick[rick]@[192.168.180.68]
  331.   DELETE FROM sessions WHERE (ip_address='S') OR running_time < N
  332.  
  333. Count: 3258  Time=0.01s (17s)  Lock=0.00s (0s)  Rows=0.0 (0), rick[rick]@[192.168.180.68]
  334.   DELETE FROM sessions WHERE (id='S' OR ip_address='S') OR running_time < N
  335.  
  336. Count: 11882  Time=0.01s (61s)  Lock=0.00s (57s)  Rows=0.0 (0), rick[rick]@[192.168.180.68]
  337.   DELETE FROM sessions WHERE (ip_address='S' OR id='S') OR running_time < N
  338.  
  339. Count: 5732  Time=0.00s (27s)  Lock=0.00s (1s)  Rows=156.7 (898337), rick[rick]@[192.168.180.68]
  340.   SELECT id, member_id, member_name, seo_name, login_type, running_time, member_group, uagent_type FROM sessions WHERE running_time > N
  341.  
  342. Count: 103  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=0.0 (0), rick[rick]@[192.168.180.68]
  343.   DELETE FROM sessions WHERE (ip_address='S' AND id != 'S') OR running_time < N
  344.  
  345. Count: 446  Time=0.00s (1s)  Lock=0.00s (1s)  Rows=1.0 (446), rick[rick]@[192.168.180.68]
  346.   SELECT * FROM question_and_answer ORDER BY RAND() LIMIT N
  347.  
  348. Count: 177  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=0.0 (0), rick[rick]@[192.168.180.68]
  349.   DELETE FROM exp_security_hashes WHERE date < UNIX_TIMESTAMP()-N
  350.  
  351. Count: 653  Time=0.00s (2s)  Lock=0.00s (0s)  Rows=84.0 (54852), rick[rick]@[192.168.180.68]
  352.   SELECT f.*,p.* FROM forums f  LEFT JOIN permission_index p ON ( p.perm_type='S' AND p.app='S' AND p.perm_type_id=f.id )
  353.  
  354. Count: 2  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=1.0 (2), rick[rick]@[192.168.180.68]
  355.   SELECT action_id, class, method FROM exp_actions WHERE (class= 'S' AND method = 'S')
  356.  
  357. Count: 3  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=1.0 (3), rick[rick]@[192.168.180.68]
  358.   SELECT count(*) as total FROM rc_comments WHERE rid=N
  359.  
  360. Count: 1  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=1.0 (1), rick[rick]@[192.168.180.68]
  361.   SELECT COUNT(*) as cnt, MIN(date_updated) AS lastItem FROM rc_reports_index WHERE id NOT IN(N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N) AND date_updated > N
  362.  
  363. Count: 1  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=1.0 (1), rick[rick]@[192.168.180.68]
  364.   SELECT COUNT(*) as cnt, MIN(date_updated) AS lastItem FROM rc_reports_index WHERE id NOT IN(N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N) AND date_updated > N
  365.  
  366. Count: 1  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=1.0 (1), rick[rick]@[192.168.180.68]
  367.   SELECT COUNT(*) as cnt, MIN(date_updated) AS lastItem FROM rc_reports_index WHERE id NOT IN(N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N) AND date_updated > N
  368.  
  369. Count: 2  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=1.0 (2), rick[rick]@[192.168.180.68]
  370.   SELECT COUNT(*) as cnt, MIN(date_updated) AS lastItem FROM rc_reports_index WHERE id NOT IN(N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N) AND date_updated > N
  371.  
  372. Count: 1  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=1.0 (1), rick[rick]@[192.168.180.68]
  373.   SELECT COUNT(*) as cnt, MIN(date_updated) AS lastItem FROM rc_reports_index WHERE id NOT IN(N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N) AND date_updated > N
  374.  
  375. Count: 1  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=1.0 (1), rick[rick]@[192.168.180.68]
  376.   SELECT COUNT(*) as cnt, MIN(date_updated) AS lastItem FROM rc_reports_index WHERE id NOT IN(N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N) AND date_updated > N
  377.  
  378. Count: 1  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=1.0 (1), rick[rick]@[192.168.180.68]
  379.   SELECT COUNT(*) as cnt, MIN(date_updated) AS lastItem FROM rc_reports_index WHERE id NOT IN(N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N) AND date_updated > N
  380.  
  381. Count: 6  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=10.0 (60), rick[rick]@[192.168.180.68]
  382.   SELECT COUNT(*) as count, log_share_key FROM core_share_links_log GROUP BY log_share_key ORDER BY count DESC LIMIT N,N
  383.  
  384. Count: 1  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=1.0 (1), rick[rick]@[192.168.180.68]
  385.   SELECT COUNT(*) as cnt, MIN(date_updated) AS lastItem FROM rc_reports_index WHERE id NOT IN(N,N,N,N,N,N,N,N,N,N,N,N) AND date_updated > N
  386.  
  387. Count: 2  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=0.0 (0), rick[rick]@[192.168.180.68]
  388.   SELECT * FROM subscription_trans WHERE subtrans_state NOT IN ('S') AND subtrans_member_id=N
  389.  
  390. Count: 1  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=1.0 (1), rick[rick]@[192.168.180.68]
  391.   SELECT * FROM subscription_trans WHERE (subtrans_state='S' or subtrans_state='S') AND subtrans_end_date < N
  392.  
  393. Count: 1374  Time=0.00s (1s)  Lock=0.00s (1s)  Rows=0.0 (0), rick[rick]@[192.168.180.68]
  394.   DELETE FROM sessions WHERE (member_id=N) OR running_time < N
  395.  
  396. Count: 1  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=0.0 (0), rick[rick]@[192.168.180.68]
  397.   SELECT * FROM subscription_trans WHERE subtrans_trxid='S'
  398.  
  399. Count: 1  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=0.0 (0), rick[rick]@[192.168.180.68]
  400.   DELETE FROM subscription_trans WHERE subtrans_state='S' AND subtrans_member_id=N
  401.  
  402. Count: 2  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=2.0 (4), rick[rick]@[192.168.180.68]
  403.   SELECT action_id, class, method FROM exp_actions WHERE (class= 'S' AND method = 'S') OR (class= 'S' AND method = 'S')
  404.  
  405. Count: 2  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=0.0 (0), debian-sys-maint[debian-sys-maint]@localhost
  406.   select count(*) into @discard from `information_schema`.`PLUGINS`
  407.  
  408. Count: 4  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=4.0 (16), rick[rick]@[192.168.180.68]
  409.   SELECT a.*,m.member_id, m.name, m.members_display_name, m.members_seo_name FROM announcements a  LEFT JOIN members m ON ( m.member_id=a.announce_member_id )   ORDER BY a.announce_end DESC
  410.  
  411. Count: 1  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=5.0 (5), rick[rick]@[192.168.180.68]
  412.   SELECT s.*,ss.* FROM subscription_methods s  LEFT JOIN subscription_extra ss ON ( ss.subextra_method_id=s.submethod_id )   WHERE submethod_name='S'
  413.  
  414. Count: 204  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=4.0 (816), rick[rick]@[192.168.180.68]
  415.   SELECT rss_export_title, rss_export_id FROM rss_export WHERE rss_export_enabled=N
  416.  
  417. Count: 1454  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=0.9 (1253), rick[rick]@[192.168.180.68]
  418.   SELECT *
  419.   FROM cmq_session
  420.   WHERE userid = N
  421.   AND host = 'S'
  422.   AND idhash = 'S'
  423.   LIMIT N
  424.  
  425. Count: 2  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=0.0 (0), debian-sys-maint[debian-sys-maint]@localhost
  426.   select count(*) into @discard from `information_schema`.`PROCESSLIST`
  427.  
  428. Count: 2  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=3.0 (6), rick[rick]@[192.168.180.68]
  429.   SELECT status, is_new, is_complete FROM rc_status WHERE is_new=N OR is_complete=N OR is_active=N
  430.  
  431. Count: 2  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=1.0 (2), debian-sys-maint[debian-sys-maint]@localhost
  432.   SELECT count(*) FROM mysql.user WHERE user='S' and password='S'
  433.  
  434. Count: 1  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=1.0 (1), rick[rick]@[192.168.180.68]
  435.   SELECT comment_approved, COUNT( * ) AS num_comments FROM wp_comments  GROUP BY comment_approved
  436.  
  437. Count: 2  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=1.0 (2), rick[rick]@[192.168.180.68]
  438.   SELECT weblog_id FROM exp_weblogs WHERE  blog_name = 'S'
  439.  
  440. Count: 2  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=0.0 (0), debian-sys-maint[debian-sys-maint]@localhost
  441.   select count(*) into @discard from `information_schema`.`ROUTINES`
  442.  
  443. Count: 2  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=0.0 (0), debian-sys-maint[debian-sys-maint]@localhost
  444.   select count(*) into @discard from `information_schema`.`EVENTS`
  445.  
  446. Count: 14  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=0.0 (0), rick[rick]@[192.168.180.68]
  447.   DELETE FROM exp_sessions WHERE last_activity < N
  448.  
  449. Count: 14  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=0.0 (0), rick[rick]@[192.168.180.68]
  450.   DELETE FROM cache_simple WHERE cache_time < N
  451.  
  452. Count: 14  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=0.0 (0), rick[rick]@[192.168.180.68]
  453.   DELETE FROM core_incoming_email_log WHERE log_time < N
  454.  
RAW Paste Data
Top