spec/fixtures/postgresql.log in request-log-analyzer-1.9.9 vs spec/fixtures/postgresql.log in request-log-analyzer-1.9.10
- old
+ new
@@ -1,2980 +1,29 @@
- SELECT sum(commits) AS commits,sum(adds) AS adds
- FROM stats_cvs_group
- WHERE group_id='98'
+2010-10-10 13:50:24 GMT [38626]: [1-1] LOG: 00000: database system was shut down at 2010-10-10 13:49:33 GMT
+2010-10-10 13:50:24 GMT [38626]: [2-1] LOCATION: StartupXLOG, xlog.c:4816
+2010-10-10 13:50:24 GMT [38624]: [1-1] LOG: 00000: database system is ready to accept connections
+2010-10-10 13:50:24 GMT [38624]: [2-1] LOCATION: reaper, postmaster.c:2156
+2010-10-10 13:50:24 GMT [38629]: [1-1] LOG: 00000: autovacuum launcher started
+2010-10-10 13:50:24 GMT [38629]: [2-1] LOCATION: AutoVacLauncherMain, autovacuum.c:520
+2010-10-10 13:52:04 GMT [38747]: [1-1] LOG: 00000: connection received: host=127.0.0.1 port=60020
+2010-10-10 13:52:04 GMT [38747]: [2-1] LOCATION: BackendInitialize, postmaster.c:3027
+2010-10-10 13:52:04 GMT [38747]: [3-1] LOG: 00000: connection authorized: user=root database=demonstration
+2010-10-10 13:52:04 GMT [38747]: [4-1] LOCATION: BackendInitialize, postmaster.c:3097
+2010-10-10 13:52:04 GMT [38747]: [5-1] LOG: 00000: duration: 0.329 ms statement: SHOW clients
+2010-10-10 13:52:05 GMT [38747]: [21-1] LOG: 00000: duration: 0.973 ms statement: SELECT tablename
+ FROM pg_tables
+ WHERE schemaname IN (E'"$user"',E'public')
+2010-10-10 13:52:07 GMT [38747]: [33-1] LOG: 00000: duration: 0.710 ms statement: SELECT * FROM "delayed_jobs"
+2010-10-10 13:52:08 GMT [38747]: [33-1] LOG: 00000: duration: 0.710 ms statement: SELECT * FROM "delayed_jobs"
+2010-10-10 15:00:02 GMT [38747]: [1667-1] LOG: 00000: duration: 0.024 ms statement: BEGIN
+2010-10-10 15:00:02 GMT [38747]: [1668-1] LOCATION: exec_simple_query, postgres.c:1081
+2010-10-10 15:00:02 GMT [38747]: [1669-1] LOG: 00000: duration: 0.195 ms statement: INSERT INTO "delayed_jobs" ("failed_at", "locked_by", "created_at", "handler", "updated_at", "priority", "run_at", "attempts", "locked_at", "last_error") VALUES(NULL, NULL, '2010-10-10 15:00:02.159884', E'--- !ruby/object:RuntheChooChootrain {}
-2004-05-07 11:58:22 LOG: duration: 0.084312 sec
-2004-05-07 11:58:22 LOG: query: SELECT groups.group_name,groups.unix_group_name,
- groups.type_id,users.user_name,users.realname,
- news_bytes.forum_id,news_bytes.summary,news_bytes.post_date,news_bytes.details
- FROM users,news_bytes,groups
- WHERE news_bytes.group_id='98' AND news_bytes.is_approved <> '4'
- AND users.user_id=news_bytes.submitted_by
- AND news_bytes.group_id=groups.group_id
- ORDER BY post_date DESC LIMIT 10 OFFSET 0
-2004-05-07 11:58:22 LOG: duration: 0.002680 sec
-2004-05-07 11:58:36 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 11:58:36 LOG: duration: 0.001064 sec
-2004-05-07 11:58:36 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 11:58:36 LOG: duration: 0.002612 sec
-2004-05-07 11:58:36 LOG: query:
- SELECT *
- FROM groups
- WHERE unix_group_name='monkeys'
- AND status IN ('A','H')
-
-2004-05-07 11:58:36 LOG: duration: 0.003376 sec
-2004-05-07 11:58:36 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'11','0','OTHER','0','Other','1083945516','/projects/monkeys/','0');
-2004-05-07 11:58:36 LOG: duration: 0.003521 sec
-2004-05-07 11:58:36 LOG: query: select classname from supported_languages where language_code = 'zh-cn'
-2004-05-07 11:58:36 LOG: duration: 0.001185 sec
-2004-05-07 11:58:36 LOG: query: SELECT language_id FROM supported_languages WHERE classname='SimplifiedChinese'
-2004-05-07 11:58:36 LOG: duration: 0.000657 sec
-2004-05-07 11:58:36 LOG: query: SELECT language_code FROM supported_languages WHERE language_id='23'
-2004-05-07 11:58:36 LOG: duration: 0.000391 sec
-2004-05-07 11:58:36 LOG: query: SELECT users.user_id,users.user_name,users.realname
- FROM users,user_group
- WHERE user_group.user_id=users.user_id
- AND user_group.group_id='59'
- AND user_group.admin_flags = 'A'
- AND users.status='A'
-2004-05-07 11:58:36 LOG: duration: 0.004163 sec
-2004-05-07 11:58:36 LOG: query:
- SELECT trove_cat.fullpath AS fullpath,
- trove_cat.fullpath_ids AS fullpath_ids,
- trove_cat.trove_cat_id AS trove_cat_id
- FROM trove_cat,trove_group_link
- WHERE trove_cat.trove_cat_id=trove_group_link.trove_cat_id
- AND trove_group_link.group_id='59'
- ORDER BY trove_cat.fullpath
-2004-05-07 11:58:36 LOG: duration: 0.037863 sec
-2004-05-07 11:58:36 LOG: query: SELECT percentile FROM project_weekly_metric WHERE group_id='59'
-2004-05-07 11:58:36 LOG: duration: 0.001086 sec
-2004-05-07 11:58:36 LOG: query: SELECT name
- FROM people_job,people_job_category
- WHERE people_job.category_id=people_job_category.category_id
- AND people_job.status_id=1
- AND group_id='59'
- GROUP BY name LIMIT 2 OFFSET 0
-2004-05-07 11:58:36 LOG: duration: 0.001717 sec
-2004-05-07 11:58:36 LOG: query: select count(users.user_id) from user_group, users where user_group.group_id='59' and users.user_id=user_group.user_id and users.status='A'
-2004-05-07 11:58:36 LOG: duration: 0.001380 sec
-2004-05-07 11:58:36 LOG: query: SELECT frs_package.package_id,frs_package.name AS package_name,frs_release.name AS release_name,frs_release.release_id AS release_id,frs_release.release_date AS release_date FROM frs_package,frs_release WHERE frs_package.package_id=frs_release.package_id AND frs_package.group_id='59' AND frs_release.status_id=1 ORDER BY frs_package.package_id,frs_release.release_date DESC
-2004-05-07 11:58:36 LOG: duration: 0.002534 sec
-2004-05-07 11:58:36 LOG: query: SELECT agl.*,aca.count,aca.open_count
- FROM artifact_group_list agl
- LEFT JOIN artifact_counts_agg aca USING (group_artifact_id)
- WHERE agl.group_id='59'
- AND agl.is_public=1
- ORDER BY group_artifact_id ASC
-2004-05-07 11:58:36 LOG: duration: 0.002714 sec
-2004-05-07 11:58:36 LOG: query: SELECT type, count FROM project_sums_agg WHERE group_id=59
-2004-05-07 11:58:36 LOG: duration: 0.001197 sec
-2004-05-07 11:58:36 LOG: query: SELECT * FROM project_group_list WHERE group_id='59' AND is_public=1
-2004-05-07 11:58:36 LOG: duration: 0.001217 sec
-2004-05-07 11:58:36 LOG: query:
- SELECT sum(commits) AS commits,sum(adds) AS adds
- FROM stats_cvs_group
- WHERE group_id='59'
-
-2004-05-07 11:58:36 LOG: duration: 0.083981 sec
-2004-05-07 11:58:36 LOG: query: SELECT groups.group_name,groups.unix_group_name,
- groups.type_id,users.user_name,users.realname,
- news_bytes.forum_id,news_bytes.summary,news_bytes.post_date,news_bytes.details
- FROM users,news_bytes,groups
- WHERE news_bytes.group_id='59' AND news_bytes.is_approved <> '4'
- AND users.user_id=news_bytes.submitted_by
- AND news_bytes.group_id=groups.group_id
- ORDER BY post_date DESC LIMIT 10 OFFSET 0
-2004-05-07 11:58:36 LOG: duration: 0.002657 sec
-2004-05-07 11:58:36 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 11:58:36 LOG: duration: 0.001062 sec
-2004-05-07 11:58:36 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 11:58:36 LOG: duration: 0.002613 sec
-2004-05-07 11:58:36 LOG: query:
- SELECT *
- FROM groups
- WHERE unix_group_name='iptcext'
- AND status IN ('A','H')
-
-2004-05-07 11:58:36 LOG: duration: 0.003348 sec
-2004-05-07 11:58:36 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'11','0','OTHER','0','Other','1083945516','/projects/iptcext/','0');
-2004-05-07 11:58:36 LOG: duration: 0.003764 sec
-2004-05-07 11:58:36 LOG: query: select classname from supported_languages where language_code = 'zh-cn'
-2004-05-07 11:58:36 LOG: duration: 0.001167 sec
-2004-05-07 11:58:36 LOG: query: SELECT language_id FROM supported_languages WHERE classname='SimplifiedChinese'
-2004-05-07 11:58:36 LOG: duration: 0.000662 sec
-2004-05-07 11:58:36 LOG: query: SELECT language_code FROM supported_languages WHERE language_id='23'
-2004-05-07 11:58:36 LOG: duration: 0.000396 sec
-2004-05-07 11:58:36 LOG: query: SELECT users.user_id,users.user_name,users.realname
- FROM users,user_group
- WHERE user_group.user_id=users.user_id
- AND user_group.group_id='49'
- AND user_group.admin_flags = 'A'
- AND users.status='A'
-2004-05-07 11:58:36 LOG: duration: 0.003669 sec
-2004-05-07 11:58:36 LOG: query:
- SELECT trove_cat.fullpath AS fullpath,
- trove_cat.fullpath_ids AS fullpath_ids,
- trove_cat.trove_cat_id AS trove_cat_id
- FROM trove_cat,trove_group_link
- WHERE trove_cat.trove_cat_id=trove_group_link.trove_cat_id
- AND trove_group_link.group_id='49'
- ORDER BY trove_cat.fullpath
-2004-05-07 11:58:36 LOG: duration: 0.003526 sec
-2004-05-07 11:58:36 LOG: query: SELECT percentile FROM project_weekly_metric WHERE group_id='49'
-2004-05-07 11:58:36 LOG: duration: 0.001046 sec
-2004-05-07 11:58:36 LOG: query: SELECT name
- FROM people_job,people_job_category
- WHERE people_job.category_id=people_job_category.category_id
- AND people_job.status_id=1
- AND group_id='49'
- GROUP BY name LIMIT 2 OFFSET 0
-2004-05-07 11:58:36 LOG: duration: 0.001710 sec
-2004-05-07 11:58:36 LOG: query: select count(users.user_id) from user_group, users where user_group.group_id='49' and users.user_id=user_group.user_id and users.status='A'
-2004-05-07 11:58:36 LOG: duration: 0.001340 sec
-2004-05-07 11:58:36 LOG: query: SELECT frs_package.package_id,frs_package.name AS package_name,frs_release.name AS release_name,frs_release.release_id AS release_id,frs_release.release_date AS release_date FROM frs_package,frs_release WHERE frs_package.package_id=frs_release.package_id AND frs_package.group_id='49' AND frs_release.status_id=1 ORDER BY frs_package.package_id,frs_release.release_date DESC
-2004-05-07 11:58:36 LOG: duration: 0.002427 sec
-2004-05-07 11:58:36 LOG: query:
- SELECT sum(commits) AS commits,sum(adds) AS adds
- FROM stats_cvs_group
- WHERE group_id='49'
-
-2004-05-07 11:58:37 LOG: duration: 0.084783 sec
-2004-05-07 11:58:44 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 11:58:44 LOG: duration: 0.001055 sec
-2004-05-07 11:58:44 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 11:58:44 LOG: duration: 0.002383 sec
-2004-05-07 11:58:44 LOG: query:
- SELECT *
- FROM groups
- WHERE unix_group_name='libxosd-ruby'
- AND status IN ('A','H')
-
-2004-05-07 11:58:44 LOG: duration: 0.003405 sec
-2004-05-07 11:58:44 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'11','0','OTHER','0','Other','1083945524','/projects/libxosd-ruby/','0');
-2004-05-07 11:58:44 LOG: duration: 0.003565 sec
-2004-05-07 11:58:44 LOG: query: select classname from supported_languages where language_code = 'zh-cn'
-2004-05-07 11:58:44 LOG: duration: 0.001166 sec
-2004-05-07 11:58:44 LOG: query: SELECT language_id FROM supported_languages WHERE classname='SimplifiedChinese'
-2004-05-07 11:58:44 LOG: duration: 0.000661 sec
-2004-05-07 11:58:44 LOG: query: SELECT language_code FROM supported_languages WHERE language_id='23'
-2004-05-07 11:58:44 LOG: duration: 0.000397 sec
-2004-05-07 11:58:44 LOG: query: SELECT users.user_id,users.user_name,users.realname
- FROM users,user_group
- WHERE user_group.user_id=users.user_id
- AND user_group.group_id='133'
- AND user_group.admin_flags = 'A'
- AND users.status='A'
-2004-05-07 11:58:44 LOG: duration: 0.003629 sec
-2004-05-07 11:58:44 LOG: query:
- SELECT trove_cat.fullpath AS fullpath,
- trove_cat.fullpath_ids AS fullpath_ids,
- trove_cat.trove_cat_id AS trove_cat_id
- FROM trove_cat,trove_group_link
- WHERE trove_cat.trove_cat_id=trove_group_link.trove_cat_id
- AND trove_group_link.group_id='133'
- ORDER BY trove_cat.fullpath
-2004-05-07 11:58:44 LOG: duration: 0.003373 sec
-2004-05-07 11:58:44 LOG: query: SELECT percentile FROM project_weekly_metric WHERE group_id='133'
-2004-05-07 11:58:44 LOG: duration: 0.001093 sec
-2004-05-07 11:58:44 LOG: query: SELECT name
- FROM people_job,people_job_category
- WHERE people_job.category_id=people_job_category.category_id
- AND people_job.status_id=1
- AND group_id='133'
- GROUP BY name LIMIT 2 OFFSET 0
-2004-05-07 11:58:44 LOG: duration: 0.001809 sec
-2004-05-07 11:58:44 LOG: query: select count(users.user_id) from user_group, users where user_group.group_id='133' and users.user_id=user_group.user_id and users.status='A'
-2004-05-07 11:58:44 LOG: duration: 0.001284 sec
-2004-05-07 11:58:44 LOG: query: SELECT frs_package.package_id,frs_package.name AS package_name,frs_release.name AS release_name,frs_release.release_id AS release_id,frs_release.release_date AS release_date FROM frs_package,frs_release WHERE frs_package.package_id=frs_release.package_id AND frs_package.group_id='133' AND frs_release.status_id=1 ORDER BY frs_package.package_id,frs_release.release_date DESC
-2004-05-07 11:58:44 LOG: duration: 0.002584 sec
-2004-05-07 11:58:44 LOG: query: SELECT agl.*,aca.count,aca.open_count
- FROM artifact_group_list agl
- LEFT JOIN artifact_counts_agg aca USING (group_artifact_id)
- WHERE agl.group_id='133'
- AND agl.is_public=1
- ORDER BY group_artifact_id ASC
-2004-05-07 11:58:44 LOG: duration: 0.002773 sec
-2004-05-07 11:58:44 LOG: query: SELECT type, count FROM project_sums_agg WHERE group_id=133
-2004-05-07 11:58:44 LOG: duration: 0.001184 sec
-2004-05-07 11:58:44 LOG: query: SELECT * FROM project_group_list WHERE group_id='133' AND is_public=1
-2004-05-07 11:58:44 LOG: duration: 0.001182 sec
-2004-05-07 11:58:44 LOG: query:
- SELECT sum(commits) AS commits,sum(adds) AS adds
- FROM stats_cvs_group
- WHERE group_id='133'
-
-2004-05-07 11:58:44 LOG: duration: 0.083427 sec
-2004-05-07 11:58:44 LOG: query: SELECT groups.group_name,groups.unix_group_name,
- groups.type_id,users.user_name,users.realname,
- news_bytes.forum_id,news_bytes.summary,news_bytes.post_date,news_bytes.details
- FROM users,news_bytes,groups
- WHERE news_bytes.group_id='133' AND news_bytes.is_approved <> '4'
- AND users.user_id=news_bytes.submitted_by
- AND news_bytes.group_id=groups.group_id
- ORDER BY post_date DESC LIMIT 10 OFFSET 0
-2004-05-07 11:58:44 LOG: duration: 0.002846 sec
-2004-05-07 11:58:44 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='562'
-2004-05-07 11:58:44 LOG: duration: 0.002903 sec
-2004-05-07 11:58:47 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 11:58:47 LOG: duration: 0.001033 sec
-2004-05-07 11:58:47 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 11:58:47 LOG: duration: 0.002604 sec
-2004-05-07 11:58:47 LOG: query:
- SELECT *
- FROM groups
- WHERE unix_group_name='xmldigester'
- AND status IN ('A','H')
-
-2004-05-07 11:58:47 LOG: duration: 0.003497 sec
-2004-05-07 11:58:47 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'11','0','OTHER','0','Other','1083945527','/projects/xmldigester/','0');
-2004-05-07 11:58:47 LOG: duration: 0.003247 sec
-2004-05-07 11:58:47 LOG: query: select classname from supported_languages where language_code = 'zh-cn'
-2004-05-07 11:58:47 LOG: duration: 0.001176 sec
-2004-05-07 11:58:47 LOG: query: SELECT language_id FROM supported_languages WHERE classname='SimplifiedChinese'
-2004-05-07 11:58:47 LOG: duration: 0.000659 sec
-2004-05-07 11:58:47 LOG: query: SELECT language_code FROM supported_languages WHERE language_id='23'
-2004-05-07 11:58:47 LOG: duration: 0.000405 sec
-2004-05-07 11:58:47 LOG: query: SELECT users.user_id,users.user_name,users.realname
- FROM users,user_group
- WHERE user_group.user_id=users.user_id
- AND user_group.group_id='118'
- AND user_group.admin_flags = 'A'
- AND users.status='A'
-2004-05-07 11:58:47 LOG: duration: 0.003486 sec
-2004-05-07 11:58:47 LOG: query:
- SELECT trove_cat.fullpath AS fullpath,
- trove_cat.fullpath_ids AS fullpath_ids,
- trove_cat.trove_cat_id AS trove_cat_id
- FROM trove_cat,trove_group_link
- WHERE trove_cat.trove_cat_id=trove_group_link.trove_cat_id
- AND trove_group_link.group_id='118'
- ORDER BY trove_cat.fullpath
-2004-05-07 11:58:47 LOG: duration: 0.003631 sec
-2004-05-07 11:58:47 LOG: query: SELECT percentile FROM project_weekly_metric WHERE group_id='118'
-2004-05-07 11:58:47 LOG: duration: 0.001094 sec
-2004-05-07 11:58:47 LOG: query: SELECT name
- FROM people_job,people_job_category
- WHERE people_job.category_id=people_job_category.category_id
- AND people_job.status_id=1
- AND group_id='118'
- GROUP BY name LIMIT 2 OFFSET 0
-2004-05-07 11:58:47 LOG: duration: 0.001791 sec
-2004-05-07 11:58:47 LOG: query: select count(users.user_id) from user_group, users where user_group.group_id='118' and users.user_id=user_group.user_id and users.status='A'
-2004-05-07 11:58:47 LOG: duration: 0.001390 sec
-2004-05-07 11:58:47 LOG: query: SELECT frs_package.package_id,frs_package.name AS package_name,frs_release.name AS release_name,frs_release.release_id AS release_id,frs_release.release_date AS release_date FROM frs_package,frs_release WHERE frs_package.package_id=frs_release.package_id AND frs_package.group_id='118' AND frs_release.status_id=1 ORDER BY frs_package.package_id,frs_release.release_date DESC
-2004-05-07 11:58:47 LOG: duration: 0.002552 sec
-2004-05-07 11:58:47 LOG: query: SELECT agl.*,aca.count,aca.open_count
- FROM artifact_group_list agl
- LEFT JOIN artifact_counts_agg aca USING (group_artifact_id)
- WHERE agl.group_id='118'
- AND agl.is_public=1
- ORDER BY group_artifact_id ASC
-2004-05-07 11:58:47 LOG: duration: 0.002663 sec
-2004-05-07 11:58:47 LOG: query: SELECT type, count FROM project_sums_agg WHERE group_id=118
-2004-05-07 11:58:47 LOG: duration: 0.001179 sec
-2004-05-07 11:58:47 LOG: query: SELECT * FROM project_group_list WHERE group_id='118' AND is_public=1
-2004-05-07 11:58:47 LOG: duration: 0.001212 sec
-2004-05-07 11:58:47 LOG: query:
- SELECT sum(commits) AS commits,sum(adds) AS adds
- FROM stats_cvs_group
- WHERE group_id='118'
-
-2004-05-07 11:58:47 LOG: duration: 0.084725 sec
-2004-05-07 11:58:47 LOG: query: SELECT groups.group_name,groups.unix_group_name,
- groups.type_id,users.user_name,users.realname,
- news_bytes.forum_id,news_bytes.summary,news_bytes.post_date,news_bytes.details
- FROM users,news_bytes,groups
- WHERE news_bytes.group_id='118' AND news_bytes.is_approved <> '4'
- AND users.user_id=news_bytes.submitted_by
- AND news_bytes.group_id=groups.group_id
- ORDER BY post_date DESC LIMIT 10 OFFSET 0
-2004-05-07 11:58:47 LOG: duration: 0.002930 sec
-2004-05-07 11:58:47 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='485'
-2004-05-07 11:58:47 LOG: duration: 0.003047 sec
-2004-05-07 11:58:58 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 11:58:58 LOG: duration: 0.001010 sec
-2004-05-07 11:58:58 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 11:58:58 LOG: duration: 0.002649 sec
-2004-05-07 11:58:58 LOG: query:
- SELECT *
- FROM groups
- WHERE unix_group_name='instiki'
- AND status IN ('A','H')
-
-2004-05-07 11:58:58 LOG: duration: 0.003440 sec
-2004-05-07 11:58:58 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'11','0','OTHER','0','Other','1083945538','/projects/instiki/','0');
-2004-05-07 11:58:58 LOG: duration: 0.003220 sec
-2004-05-07 11:58:58 LOG: query: select classname from supported_languages where language_code = 'zh-cn'
-2004-05-07 11:58:58 LOG: duration: 0.001155 sec
-2004-05-07 11:58:58 LOG: query: SELECT language_id FROM supported_languages WHERE classname='SimplifiedChinese'
-2004-05-07 11:58:58 LOG: duration: 0.000626 sec
-2004-05-07 11:58:58 LOG: query: SELECT language_code FROM supported_languages WHERE language_id='23'
-2004-05-07 11:58:58 LOG: duration: 0.000385 sec
-2004-05-07 11:58:58 LOG: query: SELECT users.user_id,users.user_name,users.realname
- FROM users,user_group
- WHERE user_group.user_id=users.user_id
- AND user_group.group_id='186'
- AND user_group.admin_flags = 'A'
- AND users.status='A'
-2004-05-07 11:58:58 LOG: duration: 0.003501 sec
-2004-05-07 11:58:58 LOG: query:
- SELECT trove_cat.fullpath AS fullpath,
- trove_cat.fullpath_ids AS fullpath_ids,
- trove_cat.trove_cat_id AS trove_cat_id
- FROM trove_cat,trove_group_link
- WHERE trove_cat.trove_cat_id=trove_group_link.trove_cat_id
- AND trove_group_link.group_id='186'
- ORDER BY trove_cat.fullpath
-2004-05-07 11:58:58 LOG: duration: 0.003587 sec
-2004-05-07 11:58:58 LOG: query: SELECT percentile FROM project_weekly_metric WHERE group_id='186'
-2004-05-07 11:58:58 LOG: duration: 0.001167 sec
-2004-05-07 11:58:58 LOG: query: SELECT name
- FROM people_job,people_job_category
- WHERE people_job.category_id=people_job_category.category_id
- AND people_job.status_id=1
- AND group_id='186'
- GROUP BY name LIMIT 2 OFFSET 0
-2004-05-07 11:58:58 LOG: duration: 0.001693 sec
-2004-05-07 11:58:58 LOG: query: select count(users.user_id) from user_group, users where user_group.group_id='186' and users.user_id=user_group.user_id and users.status='A'
-2004-05-07 11:58:58 LOG: duration: 0.001332 sec
-2004-05-07 11:58:58 LOG: query: SELECT frs_package.package_id,frs_package.name AS package_name,frs_release.name AS release_name,frs_release.release_id AS release_id,frs_release.release_date AS release_date FROM frs_package,frs_release WHERE frs_package.package_id=frs_release.package_id AND frs_package.group_id='186' AND frs_release.status_id=1 ORDER BY frs_package.package_id,frs_release.release_date DESC
-2004-05-07 11:58:58 LOG: duration: 0.002893 sec
-2004-05-07 11:58:58 LOG: query: SELECT agl.*,aca.count,aca.open_count
- FROM artifact_group_list agl
- LEFT JOIN artifact_counts_agg aca USING (group_artifact_id)
- WHERE agl.group_id='186'
- AND agl.is_public=1
- ORDER BY group_artifact_id ASC
-2004-05-07 11:58:58 LOG: duration: 0.002686 sec
-2004-05-07 11:58:58 LOG: query: SELECT type, count FROM project_sums_agg WHERE group_id=186
-2004-05-07 11:58:58 LOG: duration: 0.001174 sec
-2004-05-07 11:58:58 LOG: query: SELECT * FROM project_group_list WHERE group_id='186' AND is_public=1
-2004-05-07 11:58:58 LOG: duration: 0.001216 sec
-2004-05-07 11:58:58 LOG: query:
- SELECT sum(commits) AS commits,sum(adds) AS adds
- FROM stats_cvs_group
- WHERE group_id='186'
-
-2004-05-07 11:58:58 LOG: duration: 0.118019 sec
-2004-05-07 11:58:58 LOG: query: SELECT groups.group_name,groups.unix_group_name,
- groups.type_id,users.user_name,users.realname,
- news_bytes.forum_id,news_bytes.summary,news_bytes.post_date,news_bytes.details
- FROM users,news_bytes,groups
- WHERE news_bytes.group_id='186' AND news_bytes.is_approved <> '4'
- AND users.user_id=news_bytes.submitted_by
- AND news_bytes.group_id=groups.group_id
- ORDER BY post_date DESC LIMIT 10 OFFSET 0
-2004-05-07 11:58:58 LOG: duration: 0.003146 sec
-2004-05-07 11:58:58 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='1001'
-2004-05-07 11:58:58 LOG: duration: 0.003038 sec
-2004-05-07 11:58:58 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='975'
-2004-05-07 11:58:58 LOG: duration: 0.000799 sec
-2004-05-07 11:58:58 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='965'
-2004-05-07 11:58:58 LOG: duration: 0.000713 sec
-2004-05-07 11:58:58 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='922'
-2004-05-07 11:58:58 LOG: duration: 0.000727 sec
-2004-05-07 11:58:58 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='752'
-2004-05-07 11:58:58 LOG: duration: 0.000770 sec
-2004-05-07 11:58:58 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 11:58:58 LOG: duration: 0.001036 sec
-2004-05-07 11:58:58 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 11:58:58 LOG: duration: 0.002565 sec
-2004-05-07 11:58:58 LOG: query:
- SELECT *
- FROM groups
- WHERE unix_group_name='aeditor'
- AND status IN ('A','H')
-
-2004-05-07 11:58:58 LOG: duration: 0.004980 sec
-2004-05-07 11:58:58 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'11','0','OTHER','0','Other','1083945538','/projects/aeditor/','0');
-2004-05-07 11:58:58 LOG: duration: 0.003882 sec
-2004-05-07 11:58:58 LOG: query: select classname from supported_languages where language_code = 'zh-cn'
-2004-05-07 11:58:58 LOG: duration: 0.001130 sec
-2004-05-07 11:58:58 LOG: query: SELECT language_id FROM supported_languages WHERE classname='SimplifiedChinese'
-2004-05-07 11:58:58 LOG: duration: 0.000691 sec
-2004-05-07 11:58:58 LOG: query: SELECT language_code FROM supported_languages WHERE language_id='23'
-2004-05-07 11:58:58 LOG: duration: 0.000415 sec
-2004-05-07 11:58:58 LOG: query: SELECT users.user_id,users.user_name,users.realname
- FROM users,user_group
- WHERE user_group.user_id=users.user_id
- AND user_group.group_id='18'
- AND user_group.admin_flags = 'A'
- AND users.status='A'
-2004-05-07 11:58:58 LOG: duration: 0.003580 sec
-2004-05-07 11:58:58 LOG: query:
- SELECT trove_cat.fullpath AS fullpath,
- trove_cat.fullpath_ids AS fullpath_ids,
- trove_cat.trove_cat_id AS trove_cat_id
- FROM trove_cat,trove_group_link
- WHERE trove_cat.trove_cat_id=trove_group_link.trove_cat_id
- AND trove_group_link.group_id='18'
- ORDER BY trove_cat.fullpath
-2004-05-07 11:58:58 LOG: duration: 0.003556 sec
-2004-05-07 11:58:58 LOG: query: SELECT percentile FROM project_weekly_metric WHERE group_id='18'
-2004-05-07 11:58:58 LOG: duration: 0.001122 sec
-2004-05-07 11:58:58 LOG: query: SELECT name
- FROM people_job,people_job_category
- WHERE people_job.category_id=people_job_category.category_id
- AND people_job.status_id=1
- AND group_id='18'
- GROUP BY name LIMIT 2 OFFSET 0
-2004-05-07 11:58:58 LOG: duration: 0.001717 sec
-2004-05-07 11:58:58 LOG: query: select count(users.user_id) from user_group, users where user_group.group_id='18' and users.user_id=user_group.user_id and users.status='A'
-2004-05-07 11:58:58 LOG: duration: 0.001393 sec
-2004-05-07 11:58:58 LOG: query: SELECT frs_package.package_id,frs_package.name AS package_name,frs_release.name AS release_name,frs_release.release_id AS release_id,frs_release.release_date AS release_date FROM frs_package,frs_release WHERE frs_package.package_id=frs_release.package_id AND frs_package.group_id='18' AND frs_release.status_id=1 ORDER BY frs_package.package_id,frs_release.release_date DESC
-2004-05-07 11:58:58 LOG: duration: 0.003136 sec
-2004-05-07 11:58:58 LOG: query: SELECT agl.*,aca.count,aca.open_count
- FROM artifact_group_list agl
- LEFT JOIN artifact_counts_agg aca USING (group_artifact_id)
- WHERE agl.group_id='18'
- AND agl.is_public=1
- ORDER BY group_artifact_id ASC
-2004-05-07 11:58:58 LOG: duration: 0.002708 sec
-2004-05-07 11:58:58 LOG: query: SELECT type, count FROM project_sums_agg WHERE group_id=18
-2004-05-07 11:58:58 LOG: duration: 0.001379 sec
-2004-05-07 11:58:58 LOG: query:
- SELECT sum(commits) AS commits,sum(adds) AS adds
- FROM stats_cvs_group
- WHERE group_id='18'
-
-2004-05-07 11:58:58 LOG: duration: 0.092358 sec
-2004-05-07 11:58:58 LOG: query: SELECT groups.group_name,groups.unix_group_name,
- groups.type_id,users.user_name,users.realname,
- news_bytes.forum_id,news_bytes.summary,news_bytes.post_date,news_bytes.details
- FROM users,news_bytes,groups
- WHERE news_bytes.group_id='18' AND news_bytes.is_approved <> '4'
- AND users.user_id=news_bytes.submitted_by
- AND news_bytes.group_id=groups.group_id
- ORDER BY post_date DESC LIMIT 10 OFFSET 0
-2004-05-07 11:58:58 LOG: duration: 0.003686 sec
-2004-05-07 11:58:58 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='1050'
-2004-05-07 11:58:58 LOG: duration: 0.002965 sec
-2004-05-07 11:58:58 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='1010'
-2004-05-07 11:58:58 LOG: duration: 0.000746 sec
-2004-05-07 11:58:58 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='985'
-2004-05-07 11:58:58 LOG: duration: 0.000735 sec
-2004-05-07 11:58:58 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='892'
-2004-05-07 11:58:58 LOG: duration: 0.000736 sec
-2004-05-07 11:58:58 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='847'
-2004-05-07 11:58:58 LOG: duration: 0.000727 sec
-2004-05-07 11:58:58 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='843'
-2004-05-07 11:58:58 LOG: duration: 0.000712 sec
-2004-05-07 11:58:58 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='841'
-2004-05-07 11:58:58 LOG: duration: 0.000726 sec
-2004-05-07 11:58:58 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='743'
-2004-05-07 11:58:58 LOG: duration: 0.000786 sec
-2004-05-07 11:58:58 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='531'
-2004-05-07 11:58:58 LOG: duration: 0.000799 sec
-2004-05-07 11:58:58 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='524'
-2004-05-07 11:58:58 LOG: duration: 0.000735 sec
-2004-05-07 11:59:06 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 11:59:06 LOG: duration: 0.001160 sec
-2004-05-07 11:59:06 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 11:59:06 LOG: duration: 0.002702 sec
-2004-05-07 11:59:06 LOG: query:
- SELECT *
- FROM groups
- WHERE unix_group_name='qworker'
- AND status IN ('A','H')
-
-2004-05-07 11:59:06 LOG: duration: 0.003458 sec
-2004-05-07 11:59:06 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'11','0','OTHER','0','Other','1083945546','/projects/qworker/','0');
-2004-05-07 11:59:06 LOG: duration: 0.003258 sec
-2004-05-07 11:59:06 LOG: query: select classname from supported_languages where language_code = 'zh-cn'
-2004-05-07 11:59:06 LOG: duration: 0.001153 sec
-2004-05-07 11:59:06 LOG: query: SELECT language_id FROM supported_languages WHERE classname='SimplifiedChinese'
-2004-05-07 11:59:06 LOG: duration: 0.000677 sec
-2004-05-07 11:59:06 LOG: query: SELECT language_code FROM supported_languages WHERE language_id='23'
-2004-05-07 11:59:06 LOG: duration: 0.000400 sec
-2004-05-07 11:59:06 LOG: query: SELECT users.user_id,users.user_name,users.realname
- FROM users,user_group
- WHERE user_group.user_id=users.user_id
- AND user_group.group_id='195'
- AND user_group.admin_flags = 'A'
- AND users.status='A'
-2004-05-07 11:59:06 LOG: duration: 0.003621 sec
-2004-05-07 11:59:06 LOG: query:
- SELECT trove_cat.fullpath AS fullpath,
- trove_cat.fullpath_ids AS fullpath_ids,
- trove_cat.trove_cat_id AS trove_cat_id
- FROM trove_cat,trove_group_link
- WHERE trove_cat.trove_cat_id=trove_group_link.trove_cat_id
- AND trove_group_link.group_id='195'
- ORDER BY trove_cat.fullpath
-2004-05-07 11:59:06 LOG: duration: 0.003433 sec
-2004-05-07 11:59:06 LOG: query: SELECT percentile FROM project_weekly_metric WHERE group_id='195'
-2004-05-07 11:59:06 LOG: duration: 0.001119 sec
-2004-05-07 11:59:06 LOG: query: SELECT name
- FROM people_job,people_job_category
- WHERE people_job.category_id=people_job_category.category_id
- AND people_job.status_id=1
- AND group_id='195'
- GROUP BY name LIMIT 2 OFFSET 0
-2004-05-07 11:59:06 LOG: duration: 0.001752 sec
-2004-05-07 11:59:06 LOG: query: select count(users.user_id) from user_group, users where user_group.group_id='195' and users.user_id=user_group.user_id and users.status='A'
-2004-05-07 11:59:06 LOG: duration: 0.001410 sec
-2004-05-07 11:59:06 LOG: query: SELECT frs_package.package_id,frs_package.name AS package_name,frs_release.name AS release_name,frs_release.release_id AS release_id,frs_release.release_date AS release_date FROM frs_package,frs_release WHERE frs_package.package_id=frs_release.package_id AND frs_package.group_id='195' AND frs_release.status_id=1 ORDER BY frs_package.package_id,frs_release.release_date DESC
-2004-05-07 11:59:06 LOG: duration: 0.002523 sec
-2004-05-07 11:59:06 LOG: query: SELECT agl.*,aca.count,aca.open_count
- FROM artifact_group_list agl
- LEFT JOIN artifact_counts_agg aca USING (group_artifact_id)
- WHERE agl.group_id='195'
- AND agl.is_public=1
- ORDER BY group_artifact_id ASC
-2004-05-07 11:59:06 LOG: duration: 0.002651 sec
-2004-05-07 11:59:06 LOG: query: SELECT type, count FROM project_sums_agg WHERE group_id=195
-2004-05-07 11:59:06 LOG: duration: 0.001163 sec
-2004-05-07 11:59:06 LOG: query: SELECT * FROM project_group_list WHERE group_id='195' AND is_public=1
-2004-05-07 11:59:06 LOG: duration: 0.001210 sec
-2004-05-07 11:59:06 LOG: query:
- SELECT sum(commits) AS commits,sum(adds) AS adds
- FROM stats_cvs_group
- WHERE group_id='195'
-
-2004-05-07 11:59:06 LOG: duration: 0.119850 sec
-2004-05-07 11:59:06 LOG: query: SELECT groups.group_name,groups.unix_group_name,
- groups.type_id,users.user_name,users.realname,
- news_bytes.forum_id,news_bytes.summary,news_bytes.post_date,news_bytes.details
- FROM users,news_bytes,groups
- WHERE news_bytes.group_id='195' AND news_bytes.is_approved <> '4'
- AND users.user_id=news_bytes.submitted_by
- AND news_bytes.group_id=groups.group_id
- ORDER BY post_date DESC LIMIT 10 OFFSET 0
-2004-05-07 11:59:06 LOG: duration: 0.002631 sec
-2004-05-07 11:59:06 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 11:59:06 LOG: duration: 0.001031 sec
-2004-05-07 11:59:06 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 11:59:06 LOG: duration: 0.002604 sec
-2004-05-07 11:59:06 LOG: query:
- SELECT *
- FROM groups
- WHERE unix_group_name='captcha'
- AND status IN ('A','H')
-
-2004-05-07 11:59:06 LOG: duration: 0.003332 sec
-2004-05-07 11:59:06 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'11','0','OTHER','0','Other','1083945546','/projects/captcha/','0');
-2004-05-07 11:59:06 LOG: duration: 0.004125 sec
-2004-05-07 11:59:06 LOG: query: select classname from supported_languages where language_code = 'zh-cn'
-2004-05-07 11:59:06 LOG: duration: 0.001159 sec
-2004-05-07 11:59:06 LOG: query: SELECT language_id FROM supported_languages WHERE classname='SimplifiedChinese'
-2004-05-07 11:59:06 LOG: duration: 0.000650 sec
-2004-05-07 11:59:06 LOG: query: SELECT language_code FROM supported_languages WHERE language_id='23'
-2004-05-07 11:59:06 LOG: duration: 0.000395 sec
-2004-05-07 11:59:06 LOG: query: SELECT users.user_id,users.user_name,users.realname
- FROM users,user_group
- WHERE user_group.user_id=users.user_id
- AND user_group.group_id='212'
- AND user_group.admin_flags = 'A'
- AND users.status='A'
-2004-05-07 11:59:06 LOG: duration: 0.003407 sec
-2004-05-07 11:59:06 LOG: query:
- SELECT trove_cat.fullpath AS fullpath,
- trove_cat.fullpath_ids AS fullpath_ids,
- trove_cat.trove_cat_id AS trove_cat_id
- FROM trove_cat,trove_group_link
- WHERE trove_cat.trove_cat_id=trove_group_link.trove_cat_id
- AND trove_group_link.group_id='212'
- ORDER BY trove_cat.fullpath
-2004-05-07 11:59:06 LOG: duration: 0.003553 sec
-2004-05-07 11:59:06 LOG: query: SELECT percentile FROM project_weekly_metric WHERE group_id='212'
-2004-05-07 11:59:06 LOG: duration: 0.001030 sec
-2004-05-07 11:59:06 LOG: query: SELECT name
- FROM people_job,people_job_category
- WHERE people_job.category_id=people_job_category.category_id
- AND people_job.status_id=1
- AND group_id='212'
- GROUP BY name LIMIT 2 OFFSET 0
-2004-05-07 11:59:06 LOG: duration: 0.001718 sec
-2004-05-07 11:59:06 LOG: query: select count(users.user_id) from user_group, users where user_group.group_id='212' and users.user_id=user_group.user_id and users.status='A'
-2004-05-07 11:59:06 LOG: duration: 0.001384 sec
-2004-05-07 11:59:06 LOG: query: SELECT frs_package.package_id,frs_package.name AS package_name,frs_release.name AS release_name,frs_release.release_id AS release_id,frs_release.release_date AS release_date FROM frs_package,frs_release WHERE frs_package.package_id=frs_release.package_id AND frs_package.group_id='212' AND frs_release.status_id=1 ORDER BY frs_package.package_id,frs_release.release_date DESC
-2004-05-07 11:59:06 LOG: duration: 0.002485 sec
-2004-05-07 11:59:06 LOG: query: SELECT agl.*,aca.count,aca.open_count
- FROM artifact_group_list agl
- LEFT JOIN artifact_counts_agg aca USING (group_artifact_id)
- WHERE agl.group_id='212'
- AND agl.is_public=1
- ORDER BY group_artifact_id ASC
-2004-05-07 11:59:06 LOG: duration: 0.002722 sec
-2004-05-07 11:59:06 LOG: query: SELECT type, count FROM project_sums_agg WHERE group_id=212
-2004-05-07 11:59:06 LOG: duration: 0.001109 sec
-2004-05-07 11:59:06 LOG: query: SELECT * FROM project_group_list WHERE group_id='212' AND is_public=1
-2004-05-07 11:59:06 LOG: duration: 0.001173 sec
-2004-05-07 11:59:06 LOG: query:
- SELECT sum(commits) AS commits,sum(adds) AS adds
- FROM stats_cvs_group
- WHERE group_id='212'
-
-2004-05-07 11:59:06 LOG: duration: 0.083668 sec
-2004-05-07 11:59:06 LOG: query: SELECT groups.group_name,groups.unix_group_name,
- groups.type_id,users.user_name,users.realname,
- news_bytes.forum_id,news_bytes.summary,news_bytes.post_date,news_bytes.details
- FROM users,news_bytes,groups
- WHERE news_bytes.group_id='212' AND news_bytes.is_approved <> '4'
- AND users.user_id=news_bytes.submitted_by
- AND news_bytes.group_id=groups.group_id
- ORDER BY post_date DESC LIMIT 10 OFFSET 0
-2004-05-07 11:59:06 LOG: duration: 0.002620 sec
-2004-05-07 11:59:21 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 11:59:21 LOG: duration: 0.001036 sec
-2004-05-07 11:59:21 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 11:59:21 LOG: duration: 0.002670 sec
-2004-05-07 11:59:21 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'11','0','OTHER','0','Other','1083945561','/export/index.php','0');
-2004-05-07 11:59:21 LOG: duration: 0.003211 sec
-2004-05-07 11:59:21 LOG: query: select classname from supported_languages where language_code = 'zh-cn'
-2004-05-07 11:59:21 LOG: duration: 0.001773 sec
-2004-05-07 11:59:21 LOG: query: SELECT language_id FROM supported_languages WHERE classname='SimplifiedChinese'
-2004-05-07 11:59:21 LOG: duration: 0.000672 sec
-2004-05-07 11:59:21 LOG: query: SELECT language_code FROM supported_languages WHERE language_id='23'
-2004-05-07 11:59:21 LOG: duration: 0.000404 sec
-2004-05-07 11:59:51 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 11:59:51 LOG: duration: 0.000791 sec
-2004-05-07 11:59:51 LOG: query: SELECT frs_file.filename,frs_file.file_id,groups.unix_group_name,groups.group_id
- FROM frs_package,frs_release,frs_file,groups
- WHERE frs_release.release_id=frs_file.release_id
- AND groups.group_id=frs_package.group_id
- AND frs_release.package_id=frs_package.package_id
- AND frs_file.file_id='262'
-2004-05-07 11:59:51 LOG: duration: 0.006108 sec
-2004-05-07 11:59:51 LOG: query: SELECT * FROM groups WHERE group_id='30'
-2004-05-07 11:59:51 LOG: duration: 0.001106 sec
-2004-05-07 12:00:00 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:00:00 LOG: duration: 0.000791 sec
-2004-05-07 12:00:00 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:00:00 LOG: duration: 0.000767 sec
-2004-05-07 12:00:00 LOG: query: SELECT *
- FROM massmail_queue
- WHERE finished_date=0
- ORDER BY queued_date
-2004-05-07 12:00:00 LOG: duration: 0.003031 sec
-2004-05-07 12:00:01 LOG: query: SELECT users.user_name,email,mail_group_list.is_public,mail_group_list.list_name,mail_group_list.password,mail_group_list.status
- FROM mail_group_list,users
- WHERE mail_group_list.list_admin=users.user_id
-2004-05-07 12:00:01 LOG: duration: 0.009955 sec
-2004-05-07 12:00:01 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:00:01 LOG: duration: 0.000801 sec
-2004-05-07 12:00:01 LOG: query: update users set unix_status = 'A' where user_id in (select
-distinct u.user_id from users u, user_group ug WHERE
-u.user_id=ug.user_id and ug.cvs_flags='1' and u.status='A')
-2004-05-07 12:00:01 LOG: query: SELECT 1 FROM ONLY "public"."supported_languages" x WHERE "language_id" = $1 FOR UPDATE OF x
-2004-05-07 12:00:01 LOG: query: SELECT 1 FROM ONLY "public"."supported_languages" x WHERE "language_id" = $1 FOR UPDATE OF x
-2004-05-07 12:00:01 LOG: query: SELECT 1 FROM ONLY "public"."themes" x WHERE "theme_id" = $1 FOR UPDATE OF x
-2004-05-07 12:00:01 LOG: query: SELECT 1 FROM ONLY "public"."country_code" x WHERE "ccode" = $1 FOR UPDATE OF x
-2004-05-07 12:00:01 LOG: duration: 0.370524 sec
-2004-05-07 12:00:01 LOG: query: SELECT distinct users.user_name,users.unix_pw,users.user_id,users.email
- FROM users,user_group
- WHERE users.user_id=user_group.user_id
- AND user_group.cvs_flags='1'
- AND users.status='A'
- ORDER BY user_id ASC
-2004-05-07 12:00:01 LOG: duration: 0.010672 sec
-2004-05-07 12:00:05 LOG: query: select u.user_name, g.unix_group_name
- from users u, user_group ug, groups g
- where u.user_id = ug.user_id and
- ug.group_id = g.group_id and
- ug.cvs_flags = '1' and
- u.status='A' and
- g.status = 'A'
- order by u.user_name
-2004-05-07 12:00:05 LOG: duration: 0.010272 sec
-2004-05-07 12:00:09 LOG: query: SELECT user_name,user_id,authorized_keys
- FROM users
- WHERE authorized_keys != ''
- AND status='A'
-2004-05-07 12:00:09 LOG: duration: 0.078004 sec
-2004-05-07 12:00:28 LOG: query: INSERT INTO frs_dlstats_file (ip_address,file_id,month,day,user_id)
- VALUES ('221.31.184.90','262','200405','07','100')
-2004-05-07 12:00:28 LOG: duration: 0.004602 sec
-2004-05-07 12:00:34 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:00:34 LOG: duration: 0.001137 sec
-2004-05-07 12:00:34 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 12:00:34 LOG: duration: 0.003104 sec
-2004-05-07 12:00:34 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'12','0','OTHER','0','Other','1083945634','/index.php','0');
-2004-05-07 12:00:34 LOG: duration: 0.003589 sec
-2004-05-07 12:00:34 LOG: query: SELECT language_id FROM supported_languages WHERE classname='English'
-2004-05-07 12:00:34 LOG: duration: 0.002114 sec
-2004-05-07 12:00:34 LOG: query: SELECT language_code FROM supported_languages WHERE language_id='1'
-2004-05-07 12:00:34 LOG: duration: 0.000621 sec
-2004-05-07 12:00:34 LOG: query: SELECT groups.group_name,groups.unix_group_name,
- groups.type_id,users.user_name,users.realname,
- news_bytes.forum_id,news_bytes.summary,news_bytes.post_date,news_bytes.details
- FROM users,news_bytes,groups
- WHERE news_bytes.is_approved=1
- AND users.user_id=news_bytes.submitted_by
- AND news_bytes.group_id=groups.group_id
- ORDER BY post_date DESC LIMIT 10 OFFSET 0
-2004-05-07 12:00:34 LOG: duration: 0.013382 sec
-2004-05-07 12:00:34 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='1050'
-2004-05-07 12:00:34 LOG: duration: 0.002894 sec
-2004-05-07 12:00:34 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='1044'
-2004-05-07 12:00:34 LOG: duration: 0.000691 sec
-2004-05-07 12:00:34 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='1037'
-2004-05-07 12:00:34 LOG: duration: 0.000663 sec
-2004-05-07 12:00:34 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='1030'
-2004-05-07 12:00:34 LOG: duration: 0.000651 sec
-2004-05-07 12:00:34 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='1027'
-2004-05-07 12:00:34 LOG: duration: 0.000661 sec
-2004-05-07 12:00:34 LOG: query: SELECT count(*) AS count FROM groups WHERE status='A' AND is_public=1
-2004-05-07 12:00:34 LOG: duration: 0.002080 sec
-2004-05-07 12:00:34 LOG: query: SELECT count(*) AS count FROM users WHERE status='A' and user_id != 100
-2004-05-07 12:00:34 LOG: duration: 0.074694 sec
-2004-05-07 12:00:34 LOG: query:
- SELECT groups.group_id,
- groups.group_name,
- groups.unix_group_name,
- frs_dlstats_grouptotal_vw.downloads
- FROM frs_dlstats_grouptotal_vw,groups
- WHERE
- frs_dlstats_grouptotal_vw.group_id=groups.group_id AND groups.is_public='1' and groups.status='A'
- ORDER BY downloads DESC
- LIMIT 10 OFFSET 0
-2004-05-07 12:00:34 LOG: duration: 0.017606 sec
-2004-05-07 12:00:34 LOG: query: SELECT groups.group_name,groups.unix_group_name,groups.group_id,project_weekly_metric.ranking,project_weekly_metric.percentile FROM groups,project_weekly_metric WHERE groups.group_id=project_weekly_metric.group_id AND groups.is_public=1 AND groups.type_id=1 AND groups.status != 'D' ORDER BY ranking ASC LIMIT 10 OFFSET 0
-2004-05-07 12:00:34 LOG: duration: 0.004113 sec
-2004-05-07 12:00:34 LOG: query: SELECT group_id,unix_group_name,group_name,register_time FROM groups WHERE is_public=1 AND status='A' AND type_id=1 AND register_time > 0 ORDER BY register_time DESC LIMIT 10 OFFSET 0
-2004-05-07 12:00:34 LOG: duration: 0.002522 sec
-2004-05-07 12:00:44 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:00:44 LOG: duration: 0.001278 sec
-2004-05-07 12:00:44 LOG: query: SELECT frs_file.filename,frs_file.file_id,groups.unix_group_name,groups.group_id
- FROM frs_package,frs_release,frs_file,groups
- WHERE frs_release.release_id=frs_file.release_id
- AND groups.group_id=frs_package.group_id
- AND frs_release.package_id=frs_package.package_id
- AND frs_file.file_id='610'
-2004-05-07 12:00:44 LOG: duration: 0.006632 sec
-2004-05-07 12:00:44 LOG: query: SELECT * FROM groups WHERE group_id='167'
-2004-05-07 12:00:44 LOG: duration: 0.001131 sec
-2004-05-07 12:01:06 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:01:06 LOG: duration: 0.000817 sec
-2004-05-07 12:01:06 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 12:01:06 LOG: duration: 0.002161 sec
-2004-05-07 12:01:06 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'12','0','OTHER','0','Other','1083945666','/export/rss_sfnewreleases.php','0');
-2004-05-07 12:01:06 LOG: duration: 0.003217 sec
-2004-05-07 12:01:06 LOG: query: SELECT
- groups.group_id,
- groups.group_name,
- groups.unix_group_name,
- groups.type,
- news_bytes.forum_id,
- news_bytes.summary,
- news_bytes.date,
- news_bytes.details
- FROM
- news_bytes,
- groups
- WHERE
- news_bytes.group_id=groups.group_id
- ORDER BY
- date
- DESC LIMIT 30 OFFSET 0
-2004-05-07 12:01:06 ERROR: No such attribute groups.type
-2004-05-07 12:01:40 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:01:40 LOG: duration: 0.000800 sec
-2004-05-07 12:01:40 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 12:01:40 LOG: duration: 0.001900 sec
-2004-05-07 12:01:40 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'12','240','OTHER','0','Other','1083945700','/news/index.php','0');
-2004-05-07 12:01:40 LOG: duration: 0.002763 sec
-2004-05-07 12:01:40 LOG: query: SELECT * FROM groups WHERE group_id='240'
-2004-05-07 12:01:40 LOG: duration: 0.002771 sec
-2004-05-07 12:01:40 LOG: query: SELECT language_id FROM supported_languages WHERE classname='English'
-2004-05-07 12:01:40 LOG: duration: 0.001252 sec
-2004-05-07 12:01:40 LOG: query: SELECT language_code FROM supported_languages WHERE language_id='1'
-2004-05-07 12:01:40 LOG: duration: 0.000445 sec
-2004-05-07 12:01:40 LOG: query: SELECT * FROM news_bytes WHERE group_id='240' AND is_approved <> '4' ORDER BY post_date DESC LIMIT 51 OFFSET 0
-2004-05-07 12:01:40 LOG: duration: 0.002369 sec
-2004-05-07 12:02:01 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:02:01 LOG: duration: 0.000789 sec
-2004-05-07 12:02:01 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 12:02:01 LOG: duration: 0.001899 sec
-2004-05-07 12:02:01 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'12','148','OTHER','0','Other','1083945721','/export/rss_sfnews.php','0');
-2004-05-07 12:02:01 LOG: duration: 0.003165 sec
-2004-05-07 12:02:01 LOG: query: SELECT forum_id,summary,post_date,details,group_id FROM news_bytes where group_id=148 order by post_date desc LIMIT 10 OFFSET 0
-2004-05-07 12:02:01 LOG: duration: 0.002510 sec
-2004-05-07 12:02:06 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:02:06 LOG: duration: 0.000804 sec
-2004-05-07 12:02:06 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 12:02:06 LOG: duration: 0.001915 sec
-2004-05-07 12:02:06 LOG: query:
- SELECT *
- FROM groups
- WHERE unix_group_name='lolita'
- AND status IN ('A','H')
-
-2004-05-07 12:02:06 LOG: duration: 0.003181 sec
-2004-05-07 12:02:06 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'12','0','IE','6.0','Win','1083945726','/projects/lolita/','0');
-2004-05-07 12:02:06 LOG: duration: 0.003881 sec
-2004-05-07 12:02:06 LOG: query: select classname from supported_languages where language_code = 'fi'
-2004-05-07 12:02:06 LOG: duration: 0.001043 sec
-2004-05-07 12:02:06 LOG: query: select classname from supported_languages where language_id='1'
-2004-05-07 12:02:06 LOG: duration: 0.000434 sec
-2004-05-07 12:02:06 LOG: query: SELECT language_id FROM supported_languages WHERE classname='English'
-2004-05-07 12:02:06 LOG: duration: 0.000621 sec
-2004-05-07 12:02:06 LOG: query: SELECT language_code FROM supported_languages WHERE language_id='1'
-2004-05-07 12:02:06 LOG: duration: 0.000335 sec
-2004-05-07 12:02:06 LOG: query: SELECT users.user_id,users.user_name,users.realname
- FROM users,user_group
- WHERE user_group.user_id=users.user_id
- AND user_group.group_id='187'
- AND user_group.admin_flags = 'A'
- AND users.status='A'
-2004-05-07 12:02:06 LOG: duration: 0.003843 sec
-2004-05-07 12:02:06 LOG: query:
- SELECT trove_cat.fullpath AS fullpath,
- trove_cat.fullpath_ids AS fullpath_ids,
- trove_cat.trove_cat_id AS trove_cat_id
- FROM trove_cat,trove_group_link
- WHERE trove_cat.trove_cat_id=trove_group_link.trove_cat_id
- AND trove_group_link.group_id='187'
- ORDER BY trove_cat.fullpath
-2004-05-07 12:02:06 LOG: duration: 0.003411 sec
-2004-05-07 12:02:06 LOG: query: SELECT percentile FROM project_weekly_metric WHERE group_id='187'
-2004-05-07 12:02:06 LOG: duration: 0.000938 sec
-2004-05-07 12:02:06 LOG: query: SELECT name
- FROM people_job,people_job_category
- WHERE people_job.category_id=people_job_category.category_id
- AND people_job.status_id=1
- AND group_id='187'
- GROUP BY name LIMIT 2 OFFSET 0
-2004-05-07 12:02:06 LOG: duration: 0.001714 sec
-2004-05-07 12:02:06 LOG: query: select count(users.user_id) from user_group, users where user_group.group_id='187' and users.user_id=user_group.user_id and users.status='A'
-2004-05-07 12:02:06 LOG: duration: 0.001230 sec
-2004-05-07 12:02:06 LOG: query: SELECT frs_package.package_id,frs_package.name AS package_name,frs_release.name AS release_name,frs_release.release_id AS release_id,frs_release.release_date AS release_date FROM frs_package,frs_release WHERE frs_package.package_id=frs_release.package_id AND frs_package.group_id='187' AND frs_release.status_id=1 ORDER BY frs_package.package_id,frs_release.release_date DESC
-2004-05-07 12:02:06 LOG: duration: 0.002345 sec
-2004-05-07 12:02:06 LOG: query: SELECT agl.*,aca.count,aca.open_count
- FROM artifact_group_list agl
- LEFT JOIN artifact_counts_agg aca USING (group_artifact_id)
- WHERE agl.group_id='187'
- AND agl.is_public=1
- ORDER BY group_artifact_id ASC
-2004-05-07 12:02:06 LOG: duration: 0.002698 sec
-2004-05-07 12:02:06 LOG: query: SELECT type, count FROM project_sums_agg WHERE group_id=187
-2004-05-07 12:02:06 LOG: duration: 0.001180 sec
-2004-05-07 12:02:06 LOG: query: SELECT * FROM project_group_list WHERE group_id='187' AND is_public=1
-2004-05-07 12:02:06 LOG: duration: 0.001219 sec
-2004-05-07 12:02:06 LOG: query:
- SELECT sum(commits) AS commits,sum(adds) AS adds
- FROM stats_cvs_group
- WHERE group_id='187'
-
-2004-05-07 12:02:06 LOG: duration: 0.084050 sec
-2004-05-07 12:02:06 LOG: query: SELECT groups.group_name,groups.unix_group_name,
- groups.type_id,users.user_name,users.realname,
- news_bytes.forum_id,news_bytes.summary,news_bytes.post_date,news_bytes.details
- FROM users,news_bytes,groups
- WHERE news_bytes.group_id='187' AND news_bytes.is_approved <> '4'
- AND users.user_id=news_bytes.submitted_by
- AND news_bytes.group_id=groups.group_id
- ORDER BY post_date DESC LIMIT 10 OFFSET 0
-2004-05-07 12:02:06 LOG: duration: 0.002793 sec
-2004-05-07 12:02:26 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:02:26 LOG: duration: 0.001089 sec
-2004-05-07 12:02:26 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 12:02:26 LOG: duration: 0.002640 sec
-2004-05-07 12:02:26 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'12','187','IE','6.0','Win','1083945746','/forum/index.php','0');
-2004-05-07 12:02:26 LOG: duration: 0.004196 sec
-2004-05-07 12:02:26 LOG: query: select classname from supported_languages where language_code = 'fi'
-2004-05-07 12:02:26 LOG: duration: 0.001789 sec
-2004-05-07 12:02:26 LOG: query: select classname from supported_languages where language_id='1'
-2004-05-07 12:02:26 LOG: duration: 0.000518 sec
-2004-05-07 12:02:26 LOG: query: SELECT * FROM groups WHERE group_id='187'
-2004-05-07 12:02:26 LOG: duration: 0.002461 sec
-2004-05-07 12:02:26 LOG: query: SELECT language_id FROM supported_languages WHERE classname='English'
-2004-05-07 12:02:26 LOG: duration: 0.000514 sec
-2004-05-07 12:02:26 LOG: query: SELECT language_code FROM supported_languages WHERE language_id='1'
-2004-05-07 12:02:26 LOG: duration: 0.000395 sec
-2004-05-07 12:02:26 LOG: query: SELECT *
- FROM forum_group_list_vw
- WHERE group_id='187'
- AND is_public =1
- ORDER BY group_forum_id;
-2004-05-07 12:02:26 LOG: duration: 0.005504 sec
-2004-05-07 12:02:58 LOG: query: INSERT INTO frs_dlstats_file (ip_address,file_id,month,day,user_id)
- VALUES ('80.145.51.97','610','200405','07','100')
-2004-05-07 12:02:58 LOG: duration: 0.003491 sec
-2004-05-07 12:03:00 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:03:00 LOG: duration: 0.000813 sec
-2004-05-07 12:03:00 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 12:03:00 LOG: duration: 0.001889 sec
-2004-05-07 12:03:00 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'12','0','OTHER','0','Win','1083945780','/export/rss_sfnewreleases.php','0');
-2004-05-07 12:03:00 LOG: duration: 0.003597 sec
-2004-05-07 12:03:00 LOG: query: SELECT
- groups.group_id,
- groups.group_name,
- groups.unix_group_name,
- groups.type,
- news_bytes.forum_id,
- news_bytes.summary,
- news_bytes.date,
- news_bytes.details
- FROM
- news_bytes,
- groups
- WHERE
- news_bytes.group_id=groups.group_id
- ORDER BY
- date
- DESC LIMIT 30 OFFSET 0
-2004-05-07 12:03:00 ERROR: No such attribute groups.type
-2004-05-07 12:04:02 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:04:02 LOG: duration: 0.000811 sec
-2004-05-07 12:04:02 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 12:04:02 LOG: duration: 0.001861 sec
-2004-05-07 12:04:02 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'12','0','OTHER','0','Win','1083945842','/export/rss_sfnews.php','0');
-2004-05-07 12:04:02 LOG: duration: 0.002710 sec
-2004-05-07 12:04:02 LOG: query: SELECT forum_id,summary,post_date,details,group_id FROM news_bytes WHERE is_approved=1 order by post_date desc LIMIT 10 OFFSET 0
-2004-05-07 12:04:02 LOG: duration: 0.003907 sec
-2004-05-07 12:05:58 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:05:58 LOG: duration: 0.000783 sec
-2004-05-07 12:05:58 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 12:05:58 LOG: duration: 0.001842 sec
-2004-05-07 12:05:58 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'12','5','IE','6.0','Win','1083945958','/tracker/index.php','0');
-2004-05-07 12:05:59 LOG: duration: 0.195217 sec
-2004-05-07 12:05:59 LOG: query: select classname from supported_languages where language_code = 'pt-br'
-2004-05-07 12:05:59 LOG: duration: 0.001478 sec
-2004-05-07 12:05:59 LOG: query: SELECT * FROM groups WHERE group_id='5'
-2004-05-07 12:05:59 LOG: duration: 0.002342 sec
-2004-05-07 12:05:59 LOG: query: SELECT * FROM artifact_group_list_vw
- WHERE group_artifact_id='104'
- AND group_id='5'
-2004-05-07 12:05:59 LOG: duration: 0.003557 sec
-2004-05-07 12:05:59 LOG: query: SELECT * FROM artifact_vw
- WHERE artifact_id='101' AND group_artifact_id='104'
-2004-05-07 12:05:59 LOG: duration: 0.031941 sec
-2004-05-07 12:05:59 LOG: query: SELECT language_id FROM supported_languages WHERE classname='PortugueseBrazilian'
-2004-05-07 12:05:59 LOG: duration: 0.000575 sec
-2004-05-07 12:05:59 LOG: query: SELECT language_code FROM supported_languages WHERE language_id='16'
-2004-05-07 12:05:59 LOG: duration: 0.000388 sec
-2004-05-07 12:05:59 LOG: query: SELECT * FROM artifact_group_list_vw
- WHERE group_artifact_id='104'
- AND group_id='5'
-2004-05-07 12:05:59 LOG: duration: 0.000859 sec
-2004-05-07 12:05:59 LOG: query: select * FROM artifact_message_user_vw WHERE artifact_id='101' ORDER BY adddate DESC
-2004-05-07 12:05:59 LOG: duration: 0.017499 sec
-2004-05-07 12:05:59 LOG: query: select * FROM artifact_file_user_vw WHERE artifact_id='101'
-2004-05-07 12:05:59 LOG: duration: 0.001834 sec
-2004-05-07 12:05:59 LOG: query: SELECT * FROM artifact_history_user_vw WHERE artifact_id='101' ORDER BY entrydate DESC
-2004-05-07 12:05:59 LOG: duration: 0.001184 sec
-2004-05-07 12:05:59 LOG: query: select status_name from artifact_status WHERE id='1'
-2004-05-07 12:05:59 LOG: duration: 0.000533 sec
-2004-05-07 12:05:59 LOG: query: SELECT * FROM users WHERE user_id='100'
-2004-05-07 12:05:59 LOG: duration: 0.001196 sec
-2004-05-07 12:06:00 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:06:00 LOG: duration: 0.000806 sec
-2004-05-07 12:06:00 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 12:06:00 LOG: duration: 0.001875 sec
-2004-05-07 12:06:00 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'12','5','OTHER','0','Other','1083945960','/docman/index.php','0');
-2004-05-07 12:06:00 LOG: duration: 0.004098 sec
-2004-05-07 12:06:00 LOG: query: SELECT * FROM groups WHERE group_id='5'
-2004-05-07 12:06:00 LOG: duration: 0.002776 sec
-2004-05-07 12:06:00 LOG: query: SELECT *
- FROM docdata_vw
- WHERE group_id='5'
- AND stateid=1
-
- AND language_id='1'
- ORDER BY doc_group
-2004-05-07 12:06:00 LOG: duration: 0.006720 sec
-2004-05-07 12:06:00 LOG: query: SELECT language_id FROM supported_languages WHERE classname='English'
-2004-05-07 12:06:00 LOG: duration: 0.000656 sec
-2004-05-07 12:06:00 LOG: query: SELECT language_code FROM supported_languages WHERE language_id='1'
-2004-05-07 12:06:00 LOG: duration: 0.000432 sec
-2004-05-07 12:06:00 LOG: query: select dd.language_id, sl.name, count(*) as count
- from doc_groups as dg, doc_data as dd, supported_languages as sl
- where dg.doc_group = dd.doc_group
- and dg.group_id = '5'
- AND dd.stateid=1
- and sl.language_id = dd.language_id
- group by dd.language_id,sl.name
-2004-05-07 12:06:00 LOG: duration: 0.002514 sec
-2004-05-07 12:06:15 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:06:15 LOG: duration: 0.000781 sec
-2004-05-07 12:06:15 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 12:06:15 LOG: duration: 0.001864 sec
-2004-05-07 12:06:15 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'12','5','OTHER','0','Other','1083945975','/scm/index.php','0');
-2004-05-07 12:06:15 LOG: duration: 0.002618 sec
-2004-05-07 12:06:15 LOG: query: SELECT * FROM groups WHERE group_id='5'
-2004-05-07 12:06:15 LOG: duration: 0.002745 sec
-2004-05-07 12:06:15 LOG: query: SELECT language_id FROM supported_languages WHERE classname='English'
-2004-05-07 12:06:15 LOG: duration: 0.001033 sec
-2004-05-07 12:06:15 LOG: query: SELECT language_code FROM supported_languages WHERE language_id='1'
-2004-05-07 12:06:15 LOG: duration: 0.000425 sec
-2004-05-07 12:06:15 LOG: query:
- SELECT u.realname, sum(commits) as commits, sum(adds) as adds, sum(adds+commits) as combined
- FROM stats_cvs_user s, users u
- WHERE group_id='5' AND s.user_id=u.user_id AND (commits>0 OR adds >0)
- GROUP BY group_id, realname
- ORDER BY combined DESC, realname;
-
-2004-05-07 12:06:15 LOG: duration: 0.003789 sec
-2004-05-07 12:06:30 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:06:30 LOG: duration: 0.000811 sec
-2004-05-07 12:06:30 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 12:06:30 LOG: duration: 0.001877 sec
-2004-05-07 12:06:30 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'12','0','MOZILLA','5.0','Win','1083945990','/index.php','0');
-2004-05-07 12:06:30 LOG: duration: 0.002975 sec
-2004-05-07 12:06:30 LOG: query: select classname from supported_languages where language_code = 'ru'
-2004-05-07 12:06:30 LOG: duration: 0.001529 sec
-2004-05-07 12:06:30 LOG: query: SELECT language_id FROM supported_languages WHERE classname='Russian'
-2004-05-07 12:06:30 LOG: duration: 0.000621 sec
-2004-05-07 12:06:30 LOG: query: SELECT language_code FROM supported_languages WHERE language_id='17'
-2004-05-07 12:06:30 LOG: duration: 0.000427 sec
-2004-05-07 12:06:30 LOG: query: SELECT groups.group_name,groups.unix_group_name,
- groups.type_id,users.user_name,users.realname,
- news_bytes.forum_id,news_bytes.summary,news_bytes.post_date,news_bytes.details
- FROM users,news_bytes,groups
- WHERE news_bytes.is_approved=1
- AND users.user_id=news_bytes.submitted_by
- AND news_bytes.group_id=groups.group_id
- ORDER BY post_date DESC LIMIT 10 OFFSET 0
-2004-05-07 12:06:30 LOG: duration: 0.011743 sec
-2004-05-07 12:06:30 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='1050'
-2004-05-07 12:06:30 LOG: duration: 0.002415 sec
-2004-05-07 12:06:30 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='1044'
-2004-05-07 12:06:30 LOG: duration: 0.000693 sec
-2004-05-07 12:06:30 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='1037'
-2004-05-07 12:06:30 LOG: duration: 0.000642 sec
-2004-05-07 12:06:30 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='1030'
-2004-05-07 12:06:30 LOG: duration: 0.000649 sec
-2004-05-07 12:06:30 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='1027'
-2004-05-07 12:06:30 LOG: duration: 0.000675 sec
-2004-05-07 12:06:30 LOG: query: SELECT count(*) AS count FROM groups WHERE status='A' AND is_public=1
-2004-05-07 12:06:30 LOG: duration: 0.001715 sec
-2004-05-07 12:06:30 LOG: query: SELECT count(*) AS count FROM users WHERE status='A' and user_id != 100
-2004-05-07 12:06:30 LOG: duration: 0.075087 sec
-2004-05-07 12:06:30 LOG: query:
- SELECT groups.group_id,
- groups.group_name,
- groups.unix_group_name,
- frs_dlstats_grouptotal_vw.downloads
- FROM frs_dlstats_grouptotal_vw,groups
- WHERE
- frs_dlstats_grouptotal_vw.group_id=groups.group_id AND groups.is_public='1' and groups.status='A'
- ORDER BY downloads DESC
- LIMIT 10 OFFSET 0
-2004-05-07 12:06:30 LOG: duration: 0.017685 sec
-2004-05-07 12:06:30 LOG: query: SELECT groups.group_name,groups.unix_group_name,groups.group_id,project_weekly_metric.ranking,project_weekly_metric.percentile FROM groups,project_weekly_metric WHERE groups.group_id=project_weekly_metric.group_id AND groups.is_public=1 AND groups.type_id=1 AND groups.status != 'D' ORDER BY ranking ASC LIMIT 10 OFFSET 0
-2004-05-07 12:06:30 LOG: duration: 0.004203 sec
-2004-05-07 12:06:30 LOG: query: SELECT group_id,unix_group_name,group_name,register_time FROM groups WHERE is_public=1 AND status='A' AND type_id=1 AND register_time > 0 ORDER BY register_time DESC LIMIT 10 OFFSET 0
-2004-05-07 12:06:30 LOG: duration: 0.002582 sec
-2004-05-07 12:06:59 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:06:59 LOG: duration: 0.001236 sec
-2004-05-07 12:06:59 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 12:06:59 LOG: duration: 0.002584 sec
-2004-05-07 12:06:59 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'12','0','MOZILLA','5.0','Mac','1083946019','/404.php','0');
-2004-05-07 12:06:59 LOG: duration: 0.003658 sec
-2004-05-07 12:06:59 LOG: query: select classname from supported_languages where language_code = 'en-us'
-2004-05-07 12:06:59 LOG: duration: 0.001835 sec
-2004-05-07 12:06:59 LOG: query: select classname from supported_languages where language_code = 'en'
-2004-05-07 12:06:59 LOG: duration: 0.000363 sec
-2004-05-07 12:06:59 LOG: query: SELECT language_id FROM supported_languages WHERE classname='English'
-2004-05-07 12:06:59 LOG: duration: 0.000632 sec
-2004-05-07 12:06:59 LOG: query: SELECT language_code FROM supported_languages WHERE language_id='1'
-2004-05-07 12:06:59 LOG: duration: 0.000411 sec
-2004-05-07 12:07:02 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:07:02 LOG: duration: 0.000795 sec
-2004-05-07 12:07:02 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 12:07:02 LOG: duration: 0.001891 sec
-2004-05-07 12:07:02 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'12','0','IE','6.0','Win','1083946022','/index.php','0');
-2004-05-07 12:07:02 LOG: duration: 0.002765 sec
-2004-05-07 12:07:02 LOG: query: select classname from supported_languages where language_code = 'pt-br'
-2004-05-07 12:07:02 LOG: duration: 0.001469 sec
-2004-05-07 12:07:02 LOG: query: SELECT language_id FROM supported_languages WHERE classname='PortugueseBrazilian'
-2004-05-07 12:07:02 LOG: duration: 0.000616 sec
-2004-05-07 12:07:02 LOG: query: SELECT language_code FROM supported_languages WHERE language_id='16'
-2004-05-07 12:07:02 LOG: duration: 0.000435 sec
-2004-05-07 12:07:02 LOG: query: SELECT groups.group_name,groups.unix_group_name,
- groups.type_id,users.user_name,users.realname,
- news_bytes.forum_id,news_bytes.summary,news_bytes.post_date,news_bytes.details
- FROM users,news_bytes,groups
- WHERE news_bytes.is_approved=1
- AND users.user_id=news_bytes.submitted_by
- AND news_bytes.group_id=groups.group_id
- ORDER BY post_date DESC LIMIT 10 OFFSET 0
-2004-05-07 12:07:02 LOG: duration: 0.012523 sec
-2004-05-07 12:07:02 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='1050'
-2004-05-07 12:07:02 LOG: duration: 0.002943 sec
-2004-05-07 12:07:02 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='1044'
-2004-05-07 12:07:02 LOG: duration: 0.000679 sec
-2004-05-07 12:07:02 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='1037'
-2004-05-07 12:07:02 LOG: duration: 0.000656 sec
-2004-05-07 12:07:02 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='1030'
-2004-05-07 12:07:02 LOG: duration: 0.000650 sec
-2004-05-07 12:07:02 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='1027'
-2004-05-07 12:07:02 LOG: duration: 0.000661 sec
-2004-05-07 12:07:02 LOG: query: SELECT count(*) AS count FROM groups WHERE status='A' AND is_public=1
-2004-05-07 12:07:02 LOG: duration: 0.001887 sec
-2004-05-07 12:07:02 LOG: query: SELECT count(*) AS count FROM users WHERE status='A' and user_id != 100
-2004-05-07 12:07:02 LOG: duration: 0.075363 sec
-2004-05-07 12:07:02 LOG: query:
- SELECT groups.group_id,
- groups.group_name,
- groups.unix_group_name,
- frs_dlstats_grouptotal_vw.downloads
- FROM frs_dlstats_grouptotal_vw,groups
- WHERE
- frs_dlstats_grouptotal_vw.group_id=groups.group_id AND groups.is_public='1' and groups.status='A'
- ORDER BY downloads DESC
- LIMIT 10 OFFSET 0
-2004-05-07 12:07:03 LOG: duration: 0.017374 sec
-2004-05-07 12:07:03 LOG: query: SELECT groups.group_name,groups.unix_group_name,groups.group_id,project_weekly_metric.ranking,project_weekly_metric.percentile FROM groups,project_weekly_metric WHERE groups.group_id=project_weekly_metric.group_id AND groups.is_public=1 AND groups.type_id=1 AND groups.status != 'D' ORDER BY ranking ASC LIMIT 10 OFFSET 0
-2004-05-07 12:07:03 LOG: duration: 0.004156 sec
-2004-05-07 12:07:03 LOG: query: SELECT group_id,unix_group_name,group_name,register_time FROM groups WHERE is_public=1 AND status='A' AND type_id=1 AND register_time > 0 ORDER BY register_time DESC LIMIT 10 OFFSET 0
-2004-05-07 12:07:03 LOG: duration: 0.002659 sec
-2004-05-07 12:07:04 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:07:04 LOG: duration: 0.001224 sec
-2004-05-07 12:07:04 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 12:07:04 LOG: duration: 0.002643 sec
-2004-05-07 12:07:04 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'12','0','IE','6.0','Win','1083946024','/index.php','0');
-2004-05-07 12:07:04 LOG: duration: 0.006881 sec
-2004-05-07 12:07:04 LOG: query: select classname from supported_languages where language_code = 'en-ca'
-2004-05-07 12:07:04 LOG: duration: 0.001839 sec
-2004-05-07 12:07:04 LOG: query: select classname from supported_languages where language_code = 'en'
-2004-05-07 12:07:04 LOG: duration: 0.000365 sec
-2004-05-07 12:07:04 LOG: query: SELECT language_id FROM supported_languages WHERE classname='English'
-2004-05-07 12:07:04 LOG: duration: 0.000640 sec
-2004-05-07 12:07:04 LOG: query: SELECT language_code FROM supported_languages WHERE language_id='1'
-2004-05-07 12:07:04 LOG: duration: 0.000426 sec
-2004-05-07 12:07:04 LOG: query: SELECT groups.group_name,groups.unix_group_name,
- groups.type_id,users.user_name,users.realname,
- news_bytes.forum_id,news_bytes.summary,news_bytes.post_date,news_bytes.details
- FROM users,news_bytes,groups
- WHERE news_bytes.is_approved=1
- AND users.user_id=news_bytes.submitted_by
- AND news_bytes.group_id=groups.group_id
- ORDER BY post_date DESC LIMIT 10 OFFSET 0
-2004-05-07 12:07:04 LOG: duration: 0.012372 sec
-2004-05-07 12:07:04 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='1050'
-2004-05-07 12:07:04 LOG: duration: 0.002892 sec
-2004-05-07 12:07:04 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='1044'
-2004-05-07 12:07:04 LOG: duration: 0.000689 sec
-2004-05-07 12:07:04 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='1037'
-2004-05-07 12:07:04 LOG: duration: 0.000656 sec
-2004-05-07 12:07:04 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='1030'
-2004-05-07 12:07:04 LOG: duration: 0.000673 sec
-2004-05-07 12:07:04 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='1027'
-2004-05-07 12:07:04 LOG: duration: 0.000651 sec
-2004-05-07 12:07:04 LOG: query: SELECT count(*) AS count FROM groups WHERE status='A' AND is_public=1
-2004-05-07 12:07:04 LOG: duration: 0.001788 sec
-2004-05-07 12:07:04 LOG: query: SELECT count(*) AS count FROM users WHERE status='A' and user_id != 100
-2004-05-07 12:07:04 LOG: duration: 0.074975 sec
-2004-05-07 12:07:04 LOG: query:
- SELECT groups.group_id,
- groups.group_name,
- groups.unix_group_name,
- frs_dlstats_grouptotal_vw.downloads
- FROM frs_dlstats_grouptotal_vw,groups
- WHERE
- frs_dlstats_grouptotal_vw.group_id=groups.group_id AND groups.is_public='1' and groups.status='A'
- ORDER BY downloads DESC
- LIMIT 10 OFFSET 0
-2004-05-07 12:07:04 LOG: duration: 0.017538 sec
-2004-05-07 12:07:04 LOG: query: SELECT groups.group_name,groups.unix_group_name,groups.group_id,project_weekly_metric.ranking,project_weekly_metric.percentile FROM groups,project_weekly_metric WHERE groups.group_id=project_weekly_metric.group_id AND groups.is_public=1 AND groups.type_id=1 AND groups.status != 'D' ORDER BY ranking ASC LIMIT 10 OFFSET 0
-2004-05-07 12:07:04 LOG: duration: 0.004117 sec
-2004-05-07 12:07:04 LOG: query: SELECT group_id,unix_group_name,group_name,register_time FROM groups WHERE is_public=1 AND status='A' AND type_id=1 AND register_time > 0 ORDER BY register_time DESC LIMIT 10 OFFSET 0
-2004-05-07 12:07:04 LOG: duration: 0.002514 sec
-2004-05-07 12:07:19 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:07:19 LOG: duration: 0.001217 sec
-2004-05-07 12:07:19 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 12:07:19 LOG: duration: 0.002619 sec
-2004-05-07 12:07:19 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'12','148','MOZILLA','5.0','Mac','1083946039','/scm/index.php','0');
-2004-05-07 12:07:19 LOG: duration: 0.003555 sec
-2004-05-07 12:07:19 LOG: query: select classname from supported_languages where language_code = 'en-us'
-2004-05-07 12:07:19 LOG: duration: 0.001826 sec
-2004-05-07 12:07:19 LOG: query: select classname from supported_languages where language_code = 'en'
-2004-05-07 12:07:19 LOG: duration: 0.000363 sec
-2004-05-07 12:07:19 LOG: query: SELECT * FROM groups WHERE group_id='148'
-2004-05-07 12:07:19 LOG: duration: 0.002739 sec
-2004-05-07 12:07:19 LOG: query: SELECT language_id FROM supported_languages WHERE classname='English'
-2004-05-07 12:07:19 LOG: duration: 0.000520 sec
-2004-05-07 12:07:19 LOG: query: SELECT language_code FROM supported_languages WHERE language_id='1'
-2004-05-07 12:07:19 LOG: duration: 0.000330 sec
-2004-05-07 12:07:19 LOG: query:
- SELECT u.realname, sum(commits) as commits, sum(adds) as adds, sum(adds+commits) as combined
- FROM stats_cvs_user s, users u
- WHERE group_id='148' AND s.user_id=u.user_id AND (commits>0 OR adds >0)
- GROUP BY group_id, realname
- ORDER BY combined DESC, realname;
-
-2004-05-07 12:07:19 LOG: duration: 0.004092 sec
-2004-05-07 12:07:20 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:07:20 LOG: duration: 0.000809 sec
-2004-05-07 12:07:20 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 12:07:20 LOG: duration: 0.001883 sec
-2004-05-07 12:07:20 LOG: query:
- SELECT *
- FROM groups
- WHERE unix_group_name='lolita'
- AND status IN ('A','H')
-
-2004-05-07 12:07:20 LOG: duration: 0.003091 sec
-2004-05-07 12:07:20 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'12','0','IE','6.0','Win','1083946040','/projects/lolita/','0');
-2004-05-07 12:07:20 LOG: duration: 0.004082 sec
-2004-05-07 12:07:21 LOG: query: select classname from supported_languages where language_code = 'en-us'
-2004-05-07 12:07:21 LOG: duration: 0.001022 sec
-2004-05-07 12:07:21 LOG: query: select classname from supported_languages where language_code = 'en'
-2004-05-07 12:07:21 LOG: duration: 0.000343 sec
-2004-05-07 12:07:21 LOG: query: SELECT language_id FROM supported_languages WHERE classname='English'
-2004-05-07 12:07:21 LOG: duration: 0.000639 sec
-2004-05-07 12:07:21 LOG: query: SELECT language_code FROM supported_languages WHERE language_id='1'
-2004-05-07 12:07:21 LOG: duration: 0.000396 sec
-2004-05-07 12:07:21 LOG: query: SELECT users.user_id,users.user_name,users.realname
- FROM users,user_group
- WHERE user_group.user_id=users.user_id
- AND user_group.group_id='187'
- AND user_group.admin_flags = 'A'
- AND users.status='A'
-2004-05-07 12:07:21 LOG: duration: 0.003436 sec
-2004-05-07 12:07:21 LOG: query:
- SELECT trove_cat.fullpath AS fullpath,
- trove_cat.fullpath_ids AS fullpath_ids,
- trove_cat.trove_cat_id AS trove_cat_id
- FROM trove_cat,trove_group_link
- WHERE trove_cat.trove_cat_id=trove_group_link.trove_cat_id
- AND trove_group_link.group_id='187'
- ORDER BY trove_cat.fullpath
-2004-05-07 12:07:21 LOG: duration: 0.003441 sec
-2004-05-07 12:07:21 LOG: query: SELECT percentile FROM project_weekly_metric WHERE group_id='187'
-2004-05-07 12:07:21 LOG: duration: 0.000942 sec
-2004-05-07 12:07:21 LOG: query: SELECT name
- FROM people_job,people_job_category
- WHERE people_job.category_id=people_job_category.category_id
- AND people_job.status_id=1
- AND group_id='187'
- GROUP BY name LIMIT 2 OFFSET 0
-2004-05-07 12:07:21 LOG: duration: 0.001824 sec
-2004-05-07 12:07:21 LOG: query: select count(users.user_id) from user_group, users where user_group.group_id='187' and users.user_id=user_group.user_id and users.status='A'
-2004-05-07 12:07:21 LOG: duration: 0.001267 sec
-2004-05-07 12:07:21 LOG: query: SELECT frs_package.package_id,frs_package.name AS package_name,frs_release.name AS release_name,frs_release.release_id AS release_id,frs_release.release_date AS release_date FROM frs_package,frs_release WHERE frs_package.package_id=frs_release.package_id AND frs_package.group_id='187' AND frs_release.status_id=1 ORDER BY frs_package.package_id,frs_release.release_date DESC
-2004-05-07 12:07:21 LOG: duration: 0.002337 sec
-2004-05-07 12:07:21 LOG: query: SELECT agl.*,aca.count,aca.open_count
- FROM artifact_group_list agl
- LEFT JOIN artifact_counts_agg aca USING (group_artifact_id)
- WHERE agl.group_id='187'
- AND agl.is_public=1
- ORDER BY group_artifact_id ASC
-2004-05-07 12:07:21 LOG: duration: 0.002730 sec
-2004-05-07 12:07:21 LOG: query: SELECT type, count FROM project_sums_agg WHERE group_id=187
-2004-05-07 12:07:21 LOG: duration: 0.001194 sec
-2004-05-07 12:07:21 LOG: query: SELECT * FROM project_group_list WHERE group_id='187' AND is_public=1
-2004-05-07 12:07:21 LOG: duration: 0.001181 sec
-2004-05-07 12:07:21 LOG: query:
- SELECT sum(commits) AS commits,sum(adds) AS adds
- FROM stats_cvs_group
- WHERE group_id='187'
-
-2004-05-07 12:07:21 LOG: duration: 0.084259 sec
-2004-05-07 12:07:21 LOG: query: SELECT groups.group_name,groups.unix_group_name,
- groups.type_id,users.user_name,users.realname,
- news_bytes.forum_id,news_bytes.summary,news_bytes.post_date,news_bytes.details
- FROM users,news_bytes,groups
- WHERE news_bytes.group_id='187' AND news_bytes.is_approved <> '4'
- AND users.user_id=news_bytes.submitted_by
- AND news_bytes.group_id=groups.group_id
- ORDER BY post_date DESC LIMIT 10 OFFSET 0
-2004-05-07 12:07:21 LOG: duration: 0.002738 sec
-2004-05-07 12:07:29 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:07:29 LOG: duration: 0.001088 sec
-2004-05-07 12:07:29 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 12:07:29 LOG: duration: 0.002610 sec
-2004-05-07 12:07:29 LOG: query:
- SELECT *
- FROM groups
- WHERE unix_group_name='win32utils'
- AND status IN ('A','H')
-
-2004-05-07 12:07:29 LOG: duration: 0.003421 sec
-2004-05-07 12:07:29 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'12','0','IE','6.0','Win','1083946049','/projects/win32utils/','0');
-2004-05-07 12:07:29 LOG: duration: 0.003214 sec
-2004-05-07 12:07:29 LOG: query: select classname from supported_languages where language_code = 'pt-br'
-2004-05-07 12:07:29 LOG: duration: 0.001198 sec
-2004-05-07 12:07:29 LOG: query: SELECT language_id FROM supported_languages WHERE classname='PortugueseBrazilian'
-2004-05-07 12:07:29 LOG: duration: 0.000642 sec
-2004-05-07 12:07:29 LOG: query: SELECT language_code FROM supported_languages WHERE language_id='16'
-2004-05-07 12:07:29 LOG: duration: 0.000397 sec
-2004-05-07 12:07:29 LOG: query: SELECT users.user_id,users.user_name,users.realname
- FROM users,user_group
- WHERE user_group.user_id=users.user_id
- AND user_group.group_id='85'
- AND user_group.admin_flags = 'A'
- AND users.status='A'
-2004-05-07 12:07:29 LOG: duration: 0.003443 sec
-2004-05-07 12:07:29 LOG: query:
- SELECT trove_cat.fullpath AS fullpath,
- trove_cat.fullpath_ids AS fullpath_ids,
- trove_cat.trove_cat_id AS trove_cat_id
- FROM trove_cat,trove_group_link
- WHERE trove_cat.trove_cat_id=trove_group_link.trove_cat_id
- AND trove_group_link.group_id='85'
- ORDER BY trove_cat.fullpath
-2004-05-07 12:07:29 LOG: duration: 0.003824 sec
-2004-05-07 12:07:29 LOG: query: SELECT percentile FROM project_weekly_metric WHERE group_id='85'
-2004-05-07 12:07:29 LOG: duration: 0.001135 sec
-2004-05-07 12:07:29 LOG: query: SELECT name
- FROM people_job,people_job_category
- WHERE people_job.category_id=people_job_category.category_id
- AND people_job.status_id=1
- AND group_id='85'
- GROUP BY name LIMIT 2 OFFSET 0
-2004-05-07 12:07:29 LOG: duration: 0.001742 sec
-2004-05-07 12:07:29 LOG: query: select count(users.user_id) from user_group, users where user_group.group_id='85' and users.user_id=user_group.user_id and users.status='A'
-2004-05-07 12:07:29 LOG: duration: 0.001530 sec
-2004-05-07 12:07:29 LOG: query: SELECT frs_package.package_id,frs_package.name AS package_name,frs_release.name AS release_name,frs_release.release_id AS release_id,frs_release.release_date AS release_date FROM frs_package,frs_release WHERE frs_package.package_id=frs_release.package_id AND frs_package.group_id='85' AND frs_release.status_id=1 ORDER BY frs_package.package_id,frs_release.release_date DESC
-2004-05-07 12:07:29 LOG: duration: 0.003193 sec
-2004-05-07 12:07:29 LOG: query: SELECT agl.*,aca.count,aca.open_count
- FROM artifact_group_list agl
- LEFT JOIN artifact_counts_agg aca USING (group_artifact_id)
- WHERE agl.group_id='85'
- AND agl.is_public=1
- ORDER BY group_artifact_id ASC
-2004-05-07 12:07:29 LOG: duration: 0.002802 sec
-2004-05-07 12:07:29 LOG: query: SELECT type, count FROM project_sums_agg WHERE group_id=85
-2004-05-07 12:07:29 LOG: duration: 0.001419 sec
-2004-05-07 12:07:29 LOG: query: SELECT * FROM project_group_list WHERE group_id='85' AND is_public=1
-2004-05-07 12:07:29 LOG: duration: 0.001234 sec
-2004-05-07 12:07:29 LOG: query:
- SELECT sum(commits) AS commits,sum(adds) AS adds
- FROM stats_cvs_group
- WHERE group_id='85'
-
-2004-05-07 12:07:29 LOG: duration: 0.083960 sec
-2004-05-07 12:07:29 LOG: query: SELECT groups.group_name,groups.unix_group_name,
- groups.type_id,users.user_name,users.realname,
- news_bytes.forum_id,news_bytes.summary,news_bytes.post_date,news_bytes.details
- FROM users,news_bytes,groups
- WHERE news_bytes.group_id='85' AND news_bytes.is_approved <> '4'
- AND users.user_id=news_bytes.submitted_by
- AND news_bytes.group_id=groups.group_id
- ORDER BY post_date DESC LIMIT 10 OFFSET 0
-2004-05-07 12:07:29 LOG: duration: 0.003712 sec
-2004-05-07 12:07:29 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='1044'
-2004-05-07 12:07:29 LOG: duration: 0.003037 sec
-2004-05-07 12:07:29 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='1037'
-2004-05-07 12:07:29 LOG: duration: 0.000737 sec
-2004-05-07 12:07:29 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='1030'
-2004-05-07 12:07:29 LOG: duration: 0.000715 sec
-2004-05-07 12:07:29 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='1000'
-2004-05-07 12:07:29 LOG: duration: 0.000714 sec
-2004-05-07 12:07:29 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='787'
-2004-05-07 12:07:29 LOG: duration: 0.000777 sec
-2004-05-07 12:07:29 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='773'
-2004-05-07 12:07:29 LOG: duration: 0.000760 sec
-2004-05-07 12:07:29 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='736'
-2004-05-07 12:07:29 LOG: duration: 0.000774 sec
-2004-05-07 12:07:29 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='720'
-2004-05-07 12:07:29 LOG: duration: 0.000712 sec
-2004-05-07 12:07:29 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='719'
-2004-05-07 12:07:29 LOG: duration: 0.000712 sec
-2004-05-07 12:07:29 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='707'
-2004-05-07 12:07:29 LOG: duration: 0.000718 sec
-2004-05-07 12:07:31 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:07:31 LOG: duration: 0.001124 sec
-2004-05-07 12:07:31 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 12:07:31 LOG: duration: 0.002746 sec
-2004-05-07 12:07:31 LOG: query:
- SELECT *
- FROM groups
- WHERE unix_group_name='ooo4r'
- AND status IN ('A','H')
-
-2004-05-07 12:07:31 LOG: duration: 0.003470 sec
-2004-05-07 12:07:31 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'12','0','MOZILLA','5.0','Linux','1083946051','/projects/ooo4r','0');
-2004-05-07 12:07:31 LOG: duration: 0.005250 sec
-2004-05-07 12:07:31 LOG: query: select classname from supported_languages where language_code = 'en-us'
-2004-05-07 12:07:31 LOG: duration: 0.001153 sec
-2004-05-07 12:07:31 LOG: query: select classname from supported_languages where language_code = 'en'
-2004-05-07 12:07:31 LOG: duration: 0.000357 sec
-2004-05-07 12:07:31 LOG: query: SELECT language_id FROM supported_languages WHERE classname='English'
-2004-05-07 12:07:31 LOG: duration: 0.000643 sec
-2004-05-07 12:07:31 LOG: query: SELECT language_code FROM supported_languages WHERE language_id='1'
-2004-05-07 12:07:31 LOG: duration: 0.000396 sec
-2004-05-07 12:07:31 LOG: query: SELECT users.user_id,users.user_name,users.realname
- FROM users,user_group
- WHERE user_group.user_id=users.user_id
- AND user_group.group_id='136'
- AND user_group.admin_flags = 'A'
- AND users.status='A'
-2004-05-07 12:07:31 LOG: duration: 0.003595 sec
-2004-05-07 12:07:31 LOG: query:
- SELECT trove_cat.fullpath AS fullpath,
- trove_cat.fullpath_ids AS fullpath_ids,
- trove_cat.trove_cat_id AS trove_cat_id
- FROM trove_cat,trove_group_link
- WHERE trove_cat.trove_cat_id=trove_group_link.trove_cat_id
- AND trove_group_link.group_id='136'
- ORDER BY trove_cat.fullpath
-2004-05-07 12:07:31 LOG: duration: 0.003542 sec
-2004-05-07 12:07:31 LOG: query: SELECT percentile FROM project_weekly_metric WHERE group_id='136'
-2004-05-07 12:07:31 LOG: duration: 0.001178 sec
-2004-05-07 12:07:31 LOG: query: SELECT name
- FROM people_job,people_job_category
- WHERE people_job.category_id=people_job_category.category_id
- AND people_job.status_id=1
- AND group_id='136'
- GROUP BY name LIMIT 2 OFFSET 0
-2004-05-07 12:07:31 LOG: duration: 0.001708 sec
-2004-05-07 12:07:31 LOG: query: select count(users.user_id) from user_group, users where user_group.group_id='136' and users.user_id=user_group.user_id and users.status='A'
-2004-05-07 12:07:31 LOG: duration: 0.001409 sec
-2004-05-07 12:07:31 LOG: query: SELECT frs_package.package_id,frs_package.name AS package_name,frs_release.name AS release_name,frs_release.release_id AS release_id,frs_release.release_date AS release_date FROM frs_package,frs_release WHERE frs_package.package_id=frs_release.package_id AND frs_package.group_id='136' AND frs_release.status_id=1 ORDER BY frs_package.package_id,frs_release.release_date DESC
-2004-05-07 12:07:31 LOG: duration: 0.002581 sec
-2004-05-07 12:07:31 LOG: query: SELECT agl.*,aca.count,aca.open_count
- FROM artifact_group_list agl
- LEFT JOIN artifact_counts_agg aca USING (group_artifact_id)
- WHERE agl.group_id='136'
- AND agl.is_public=1
- ORDER BY group_artifact_id ASC
-2004-05-07 12:07:31 LOG: duration: 0.002700 sec
-2004-05-07 12:07:31 LOG: query: SELECT type, count FROM project_sums_agg WHERE group_id=136
-2004-05-07 12:07:31 LOG: duration: 0.001232 sec
-2004-05-07 12:07:31 LOG: query: SELECT * FROM project_group_list WHERE group_id='136' AND is_public=1
-2004-05-07 12:07:31 LOG: duration: 0.001221 sec
-2004-05-07 12:07:31 LOG: query:
- SELECT sum(commits) AS commits,sum(adds) AS adds
- FROM stats_cvs_group
- WHERE group_id='136'
-
-2004-05-07 12:07:31 LOG: duration: 0.091399 sec
-2004-05-07 12:07:31 LOG: query: SELECT groups.group_name,groups.unix_group_name,
- groups.type_id,users.user_name,users.realname,
- news_bytes.forum_id,news_bytes.summary,news_bytes.post_date,news_bytes.details
- FROM users,news_bytes,groups
- WHERE news_bytes.group_id='136' AND news_bytes.is_approved <> '4'
- AND users.user_id=news_bytes.submitted_by
- AND news_bytes.group_id=groups.group_id
- ORDER BY post_date DESC LIMIT 10 OFFSET 0
-2004-05-07 12:07:31 LOG: duration: 0.003055 sec
-2004-05-07 12:07:31 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='609'
-2004-05-07 12:07:31 LOG: duration: 0.003029 sec
-2004-05-07 12:07:31 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='604'
-2004-05-07 12:07:31 LOG: duration: 0.000739 sec
-2004-05-07 12:07:31 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='601'
-2004-05-07 12:07:31 LOG: duration: 0.000715 sec
-2004-05-07 12:07:31 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='567'
-2004-05-07 12:07:31 LOG: duration: 0.000718 sec
-2004-05-07 12:07:31 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:07:31 LOG: duration: 0.001016 sec
-2004-05-07 12:07:31 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 12:07:31 LOG: duration: 0.002596 sec
-2004-05-07 12:07:31 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'12','0','MOZILLA','5.0','Linux','1083946051','/404.php','0');
-2004-05-07 12:07:31 LOG: duration: 0.005207 sec
-2004-05-07 12:07:31 LOG: query: select classname from supported_languages where language_code = 'en-us'
-2004-05-07 12:07:31 LOG: duration: 0.001738 sec
-2004-05-07 12:07:31 LOG: query: select classname from supported_languages where language_code = 'en'
-2004-05-07 12:07:31 LOG: duration: 0.000428 sec
-2004-05-07 12:07:31 LOG: query: SELECT language_id FROM supported_languages WHERE classname='English'
-2004-05-07 12:07:31 LOG: duration: 0.000650 sec
-2004-05-07 12:07:31 LOG: query: SELECT language_code FROM supported_languages WHERE language_id='1'
-2004-05-07 12:07:31 LOG: duration: 0.000425 sec
-2004-05-07 12:07:38 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:07:38 LOG: duration: 0.000794 sec
-2004-05-07 12:07:38 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 12:07:38 LOG: duration: 0.001891 sec
-2004-05-07 12:07:38 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'12','0','MOZILLA','5.0','Mac','1083946058','/snippet/index.php','0');
-2004-05-07 12:07:38 LOG: duration: 0.003196 sec
-2004-05-07 12:07:38 LOG: query: select classname from supported_languages where language_code = 'en-us'
-2004-05-07 12:07:38 LOG: duration: 0.001511 sec
-2004-05-07 12:07:38 LOG: query: select classname from supported_languages where language_code = 'en'
-2004-05-07 12:07:38 LOG: duration: 0.000370 sec
-2004-05-07 12:07:38 LOG: query: SELECT language_id FROM supported_languages WHERE classname='English'
-2004-05-07 12:07:38 LOG: duration: 0.000603 sec
-2004-05-07 12:07:38 LOG: query: SELECT language_code FROM supported_languages WHERE language_id='1'
-2004-05-07 12:07:38 LOG: duration: 0.000439 sec
-2004-05-07 12:07:38 LOG: query: SELECT count(*) FROM snippet WHERE language=1
-2004-05-07 12:07:38 LOG: duration: 0.001729 sec
-2004-05-07 12:07:38 LOG: query: SELECT count(*) FROM snippet WHERE language=2
-2004-05-07 12:07:38 LOG: duration: 0.000402 sec
-2004-05-07 12:07:38 LOG: query: SELECT count(*) FROM snippet WHERE language=3
-2004-05-07 12:07:38 LOG: duration: 0.000363 sec
-2004-05-07 12:07:38 LOG: query: SELECT count(*) FROM snippet WHERE language=4
-2004-05-07 12:07:38 LOG: duration: 0.000348 sec
-2004-05-07 12:07:38 LOG: query: SELECT count(*) FROM snippet WHERE language=5
-2004-05-07 12:07:38 LOG: duration: 0.000347 sec
-2004-05-07 12:07:38 LOG: query: SELECT count(*) FROM snippet WHERE language=6
-2004-05-07 12:07:38 LOG: duration: 0.000360 sec
-2004-05-07 12:07:38 LOG: query: SELECT count(*) FROM snippet WHERE language=7
-2004-05-07 12:07:38 LOG: duration: 0.000345 sec
-2004-05-07 12:07:38 LOG: query: SELECT count(*) FROM snippet WHERE language=8
-2004-05-07 12:07:38 LOG: duration: 0.000343 sec
-2004-05-07 12:07:38 LOG: query: SELECT count(*) FROM snippet WHERE language=9
-2004-05-07 12:07:38 LOG: duration: 0.000347 sec
-2004-05-07 12:07:38 LOG: query: SELECT count(*) FROM snippet WHERE language=10
-2004-05-07 12:07:38 LOG: duration: 0.000354 sec
-2004-05-07 12:07:38 LOG: query: SELECT count(*) FROM snippet WHERE language=11
-2004-05-07 12:07:38 LOG: duration: 0.000347 sec
-2004-05-07 12:07:38 LOG: query: SELECT count(*) FROM snippet WHERE language=12
-2004-05-07 12:07:38 LOG: duration: 0.000347 sec
-2004-05-07 12:07:38 LOG: query: SELECT count(*) FROM snippet WHERE language=13
-2004-05-07 12:07:38 LOG: duration: 0.000361 sec
-2004-05-07 12:07:38 LOG: query: SELECT count(*) FROM snippet WHERE language=14
-2004-05-07 12:07:38 LOG: duration: 0.000350 sec
-2004-05-07 12:07:38 LOG: query: SELECT count(*) FROM snippet WHERE language=15
-2004-05-07 12:07:38 LOG: duration: 0.000351 sec
-2004-05-07 12:07:38 LOG: query: SELECT count(*) FROM snippet WHERE language=16
-2004-05-07 12:07:38 LOG: duration: 0.000343 sec
-2004-05-07 12:07:38 LOG: query: SELECT count(*) FROM snippet WHERE language=17
-2004-05-07 12:07:38 LOG: duration: 0.000364 sec
-2004-05-07 12:07:38 LOG: query: SELECT count(*) FROM snippet WHERE category=1
-2004-05-07 12:07:38 LOG: duration: 0.000404 sec
-2004-05-07 12:07:38 LOG: query: SELECT count(*) FROM snippet WHERE category=2
-2004-05-07 12:07:38 LOG: duration: 0.000353 sec
-2004-05-07 12:07:38 LOG: query: SELECT count(*) FROM snippet WHERE category=3
-2004-05-07 12:07:38 LOG: duration: 0.000373 sec
-2004-05-07 12:07:38 LOG: query: SELECT count(*) FROM snippet WHERE category=4
-2004-05-07 12:07:38 LOG: duration: 0.000394 sec
-2004-05-07 12:07:38 LOG: query: SELECT count(*) FROM snippet WHERE category=5
-2004-05-07 12:07:38 LOG: duration: 0.000349 sec
-2004-05-07 12:07:38 LOG: query: SELECT count(*) FROM snippet WHERE category=6
-2004-05-07 12:07:38 LOG: duration: 0.000366 sec
-2004-05-07 12:07:38 LOG: query: SELECT count(*) FROM snippet WHERE category=7
-2004-05-07 12:07:38 LOG: duration: 0.000792 sec
-2004-05-07 12:07:38 LOG: query: SELECT count(*) FROM snippet WHERE category=8
-2004-05-07 12:07:38 LOG: duration: 0.000361 sec
-2004-05-07 12:07:38 LOG: query: SELECT count(*) FROM snippet WHERE category=9
-2004-05-07 12:07:38 LOG: duration: 0.000365 sec
-2004-05-07 12:07:38 LOG: query: SELECT count(*) FROM snippet WHERE category=10
-2004-05-07 12:07:38 LOG: duration: 0.000351 sec
-2004-05-07 12:07:38 LOG: query: SELECT count(*) FROM snippet WHERE category=11
-2004-05-07 12:07:38 LOG: duration: 0.000345 sec
-2004-05-07 12:07:38 LOG: query: SELECT count(*) FROM snippet WHERE category=12
-2004-05-07 12:07:38 LOG: duration: 0.000378 sec
-2004-05-07 12:07:38 LOG: query: SELECT count(*) FROM snippet WHERE category=13
-2004-05-07 12:07:38 LOG: duration: 0.000351 sec
-2004-05-07 12:07:45 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:07:45 LOG: duration: 0.000792 sec
-2004-05-07 12:07:45 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 12:07:45 LOG: duration: 0.001907 sec
-2004-05-07 12:07:45 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'12','136','MOZILLA','5.0','Linux','1083946065','/frs/index.php','0');
-2004-05-07 12:07:45 LOG: duration: 0.002784 sec
-2004-05-07 12:07:45 LOG: query: select classname from supported_languages where language_code = 'en-us'
-2004-05-07 12:07:45 LOG: duration: 0.001516 sec
-2004-05-07 12:07:45 LOG: query: select classname from supported_languages where language_code = 'en'
-2004-05-07 12:07:45 LOG: duration: 0.000363 sec
-2004-05-07 12:07:45 LOG: query: SELECT *
- FROM frs_package
- WHERE group_id='136' AND status_id='1'
- ORDER BY name
-2004-05-07 12:07:45 LOG: duration: 0.002192 sec
-2004-05-07 12:07:45 LOG: query: SELECT * FROM groups WHERE group_id='136'
-2004-05-07 12:07:45 LOG: duration: 0.002162 sec
-2004-05-07 12:07:45 LOG: query: SELECT language_id FROM supported_languages WHERE classname='English'
-2004-05-07 12:07:45 LOG: duration: 0.000531 sec
-2004-05-07 12:07:45 LOG: query: SELECT language_code FROM supported_languages WHERE language_id='1'
-2004-05-07 12:07:45 LOG: duration: 0.000333 sec
-2004-05-07 12:07:45 LOG: query: SELECT * FROM frs_release
- WHERE package_id='145'
- AND status_id=1 ORDER BY release_date DESC, name ASC
-2004-05-07 12:07:45 LOG: duration: 0.001748 sec
-2004-05-07 12:07:45 LOG: query: SELECT frs_file.filename AS filename,
- frs_file.file_size AS file_size,
- frs_file.file_id AS file_id,
- frs_file.release_time AS release_time,
- frs_filetype.name AS type,
- frs_processor.name AS processor,
- frs_dlstats_filetotal_agg.downloads AS downloads
- FROM frs_filetype,frs_processor,
- frs_file LEFT JOIN frs_dlstats_filetotal_agg ON frs_dlstats_filetotal_agg.file_id=frs_file.file_id
- WHERE release_id='232'
- AND frs_filetype.type_id=frs_file.type_id
- AND frs_processor.processor_id=frs_file.processor_id
- ORDER BY filename
-2004-05-07 12:07:45 LOG: duration: 0.004231 sec
-2004-05-07 12:07:45 LOG: query: SELECT frs_file.filename AS filename,
- frs_file.file_size AS file_size,
- frs_file.file_id AS file_id,
- frs_file.release_time AS release_time,
- frs_filetype.name AS type,
- frs_processor.name AS processor,
- frs_dlstats_filetotal_agg.downloads AS downloads
- FROM frs_filetype,frs_processor,
- frs_file LEFT JOIN frs_dlstats_filetotal_agg ON frs_dlstats_filetotal_agg.file_id=frs_file.file_id
- WHERE release_id='227'
- AND frs_filetype.type_id=frs_file.type_id
- AND frs_processor.processor_id=frs_file.processor_id
- ORDER BY filename
-2004-05-07 12:07:45 LOG: duration: 0.001920 sec
-2004-05-07 12:07:52 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:07:52 LOG: duration: 0.000786 sec
-2004-05-07 12:07:52 LOG: query: SELECT frs_file.filename,frs_file.file_id,groups.unix_group_name,groups.group_id
- FROM frs_package,frs_release,frs_file,groups
- WHERE frs_release.release_id=frs_file.release_id
- AND groups.group_id=frs_package.group_id
- AND frs_release.package_id=frs_package.package_id
- AND frs_file.file_id='274'
-2004-05-07 12:07:52 LOG: duration: 0.005764 sec
-2004-05-07 12:07:52 LOG: query: SELECT * FROM groups WHERE group_id='136'
-2004-05-07 12:07:52 LOG: duration: 0.001095 sec
-2004-05-07 12:07:52 LOG: query: INSERT INTO frs_dlstats_file (ip_address,file_id,month,day,user_id)
- VALUES ('148.235.155.225','274','200405','07','100')
-2004-05-07 12:07:52 LOG: duration: 0.004247 sec
-2004-05-07 12:08:00 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:08:00 LOG: duration: 0.000799 sec
-2004-05-07 12:08:00 LOG: query: SELECT frs_file.filename,frs_file.file_id,groups.unix_group_name,groups.group_id
- FROM frs_package,frs_release,frs_file,groups
- WHERE frs_release.release_id=frs_file.release_id
- AND groups.group_id=frs_package.group_id
- AND frs_release.package_id=frs_package.package_id
- AND frs_file.file_id='274'
-2004-05-07 12:08:00 LOG: duration: 0.005490 sec
-2004-05-07 12:08:00 LOG: query: SELECT * FROM groups WHERE group_id='136'
-2004-05-07 12:08:00 LOG: duration: 0.001098 sec
-2004-05-07 12:08:06 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:08:06 LOG: duration: 0.000813 sec
-2004-05-07 12:08:06 LOG: query: SELECT frs_file.filename,frs_file.file_id,groups.unix_group_name,groups.group_id
- FROM frs_package,frs_release,frs_file,groups
- WHERE frs_release.release_id=frs_file.release_id
- AND groups.group_id=frs_package.group_id
- AND frs_release.package_id=frs_package.package_id
- AND frs_file.file_id='274'
-2004-05-07 12:08:06 LOG: duration: 0.005488 sec
-2004-05-07 12:08:06 LOG: query: SELECT * FROM groups WHERE group_id='136'
-2004-05-07 12:08:06 LOG: duration: 0.001080 sec
-2004-05-07 12:08:07 LOG: query: INSERT INTO frs_dlstats_file (ip_address,file_id,month,day,user_id)
- VALUES ('148.235.155.225','274','200405','07','100')
-2004-05-07 12:08:07 LOG: duration: 0.003720 sec
-2004-05-07 12:08:20 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:08:20 LOG: duration: 0.000797 sec
-2004-05-07 12:08:20 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 12:08:20 LOG: duration: 0.001887 sec
-2004-05-07 12:08:20 LOG: query:
- SELECT *
- FROM groups
- WHERE unix_group_name='extensions'
- AND status IN ('A','H')
-
-2004-05-07 12:08:20 LOG: duration: 0.003219 sec
-2004-05-07 12:08:20 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'12','0','IE','6.0','Win','1083946100','/projects/extensions/','0');
-2004-05-07 12:08:20 LOG: duration: 0.002794 sec
-2004-05-07 12:08:20 LOG: query: select classname from supported_languages where language_code = 'ru'
-2004-05-07 12:08:20 LOG: duration: 0.001044 sec
-2004-05-07 12:08:20 LOG: query: SELECT language_id FROM supported_languages WHERE classname='Russian'
-2004-05-07 12:08:20 LOG: duration: 0.000616 sec
-2004-05-07 12:08:20 LOG: query: SELECT language_code FROM supported_languages WHERE language_id='17'
-2004-05-07 12:08:20 LOG: duration: 0.000415 sec
-2004-05-07 12:08:20 LOG: query: SELECT users.user_id,users.user_name,users.realname
- FROM users,user_group
- WHERE user_group.user_id=users.user_id
- AND user_group.group_id='89'
- AND user_group.admin_flags = 'A'
- AND users.status='A'
-2004-05-07 12:08:20 LOG: duration: 0.003650 sec
-2004-05-07 12:08:20 LOG: query:
- SELECT trove_cat.fullpath AS fullpath,
- trove_cat.fullpath_ids AS fullpath_ids,
- trove_cat.trove_cat_id AS trove_cat_id
- FROM trove_cat,trove_group_link
- WHERE trove_cat.trove_cat_id=trove_group_link.trove_cat_id
- AND trove_group_link.group_id='89'
- ORDER BY trove_cat.fullpath
-2004-05-07 12:08:20 LOG: duration: 0.003394 sec
-2004-05-07 12:08:20 LOG: query: SELECT percentile FROM project_weekly_metric WHERE group_id='89'
-2004-05-07 12:08:20 LOG: duration: 0.001026 sec
-2004-05-07 12:08:20 LOG: query: SELECT name
- FROM people_job,people_job_category
- WHERE people_job.category_id=people_job_category.category_id
- AND people_job.status_id=1
- AND group_id='89'
- GROUP BY name LIMIT 2 OFFSET 0
-2004-05-07 12:08:20 LOG: duration: 0.001639 sec
-2004-05-07 12:08:20 LOG: query: select count(users.user_id) from user_group, users where user_group.group_id='89' and users.user_id=user_group.user_id and users.status='A'
-2004-05-07 12:08:20 LOG: duration: 0.001036 sec
-2004-05-07 12:08:20 LOG: query: SELECT frs_package.package_id,frs_package.name AS package_name,frs_release.name AS release_name,frs_release.release_id AS release_id,frs_release.release_date AS release_date FROM frs_package,frs_release WHERE frs_package.package_id=frs_release.package_id AND frs_package.group_id='89' AND frs_release.status_id=1 ORDER BY frs_package.package_id,frs_release.release_date DESC
-2004-05-07 12:08:20 LOG: duration: 0.002356 sec
-2004-05-07 12:08:20 LOG: query: SELECT agl.*,aca.count,aca.open_count
- FROM artifact_group_list agl
- LEFT JOIN artifact_counts_agg aca USING (group_artifact_id)
- WHERE agl.group_id='89'
- AND agl.is_public=1
- ORDER BY group_artifact_id ASC
-2004-05-07 12:08:20 LOG: duration: 0.002701 sec
-2004-05-07 12:08:20 LOG: query: SELECT type, count FROM project_sums_agg WHERE group_id=89
-2004-05-07 12:08:20 LOG: duration: 0.001178 sec
-2004-05-07 12:08:20 LOG: query:
- SELECT sum(commits) AS commits,sum(adds) AS adds
- FROM stats_cvs_group
- WHERE group_id='89'
-
-2004-05-07 12:08:20 LOG: duration: 0.091966 sec
-2004-05-07 12:08:20 LOG: query: SELECT groups.group_name,groups.unix_group_name,
- groups.type_id,users.user_name,users.realname,
- news_bytes.forum_id,news_bytes.summary,news_bytes.post_date,news_bytes.details
- FROM users,news_bytes,groups
- WHERE news_bytes.group_id='89' AND news_bytes.is_approved <> '4'
- AND users.user_id=news_bytes.submitted_by
- AND news_bytes.group_id=groups.group_id
- ORDER BY post_date DESC LIMIT 10 OFFSET 0
-2004-05-07 12:08:20 LOG: duration: 0.003105 sec
-2004-05-07 12:08:20 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='663'
-2004-05-07 12:08:20 LOG: duration: 0.003000 sec
-2004-05-07 12:08:20 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='384'
-2004-05-07 12:08:20 LOG: duration: 0.000843 sec
-2004-05-07 12:08:20 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='383'
-2004-05-07 12:08:20 LOG: duration: 0.000718 sec
-2004-05-07 12:08:20 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='382'
-2004-05-07 12:08:20 LOG: duration: 0.000692 sec
-2004-05-07 12:08:24 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:08:24 LOG: duration: 0.001027 sec
-2004-05-07 12:08:24 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 12:08:24 LOG: duration: 0.002599 sec
-2004-05-07 12:08:24 LOG: query:
- SELECT *
- FROM groups
- WHERE unix_group_name='korundum'
- AND status IN ('A','H')
-
-2004-05-07 12:08:24 LOG: duration: 0.003469 sec
-2004-05-07 12:08:24 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'12','0','OTHER','0','Linux','1083946104','/projects/korundum/','0');
-2004-05-07 12:08:24 LOG: duration: 0.003821 sec
-2004-05-07 12:08:24 LOG: query: SELECT language_id FROM supported_languages WHERE classname='English'
-2004-05-07 12:08:24 LOG: duration: 0.001281 sec
-2004-05-07 12:08:24 LOG: query: SELECT language_code FROM supported_languages WHERE language_id='1'
-2004-05-07 12:08:24 LOG: duration: 0.000461 sec
-2004-05-07 12:08:24 LOG: query: SELECT users.user_id,users.user_name,users.realname
- FROM users,user_group
- WHERE user_group.user_id=users.user_id
- AND user_group.group_id='181'
- AND user_group.admin_flags = 'A'
- AND users.status='A'
-2004-05-07 12:08:24 LOG: duration: 0.003569 sec
-2004-05-07 12:08:24 LOG: query:
- SELECT trove_cat.fullpath AS fullpath,
- trove_cat.fullpath_ids AS fullpath_ids,
- trove_cat.trove_cat_id AS trove_cat_id
- FROM trove_cat,trove_group_link
- WHERE trove_cat.trove_cat_id=trove_group_link.trove_cat_id
- AND trove_group_link.group_id='181'
- ORDER BY trove_cat.fullpath
-2004-05-07 12:08:24 LOG: duration: 0.003523 sec
-2004-05-07 12:08:24 LOG: query: SELECT percentile FROM project_weekly_metric WHERE group_id='181'
-2004-05-07 12:08:24 LOG: duration: 0.001125 sec
-2004-05-07 12:08:24 LOG: query: SELECT name
- FROM people_job,people_job_category
- WHERE people_job.category_id=people_job_category.category_id
- AND people_job.status_id=1
- AND group_id='181'
- GROUP BY name LIMIT 2 OFFSET 0
-2004-05-07 12:08:24 LOG: duration: 0.001749 sec
-2004-05-07 12:08:24 LOG: query: select count(users.user_id) from user_group, users where user_group.group_id='181' and users.user_id=user_group.user_id and users.status='A'
-2004-05-07 12:08:24 LOG: duration: 0.001393 sec
-2004-05-07 12:08:24 LOG: query: SELECT frs_package.package_id,frs_package.name AS package_name,frs_release.name AS release_name,frs_release.release_id AS release_id,frs_release.release_date AS release_date FROM frs_package,frs_release WHERE frs_package.package_id=frs_release.package_id AND frs_package.group_id='181' AND frs_release.status_id=1 ORDER BY frs_package.package_id,frs_release.release_date DESC
-2004-05-07 12:08:24 LOG: duration: 0.002462 sec
-2004-05-07 12:08:24 LOG: query: SELECT type, count FROM project_sums_agg WHERE group_id=181
-2004-05-07 12:08:24 LOG: duration: 0.001173 sec
-2004-05-07 12:08:24 LOG: query: SELECT groups.group_name,groups.unix_group_name,
- groups.type_id,users.user_name,users.realname,
- news_bytes.forum_id,news_bytes.summary,news_bytes.post_date,news_bytes.details
- FROM users,news_bytes,groups
- WHERE news_bytes.group_id='181' AND news_bytes.is_approved <> '4'
- AND users.user_id=news_bytes.submitted_by
- AND news_bytes.group_id=groups.group_id
- ORDER BY post_date DESC LIMIT 10 OFFSET 0
-2004-05-07 12:08:24 LOG: duration: 0.002586 sec
-2004-05-07 12:08:26 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:08:26 LOG: duration: 0.000790 sec
-2004-05-07 12:08:26 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 12:08:26 LOG: duration: 0.001893 sec
-2004-05-07 12:08:26 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'12','0','OTHER','0','Linux','1083946106','/404.php','0');
-2004-05-07 12:08:26 LOG: duration: 0.004623 sec
-2004-05-07 12:08:26 LOG: query: SELECT language_id FROM supported_languages WHERE classname='English'
-2004-05-07 12:08:26 LOG: duration: 0.001558 sec
-2004-05-07 12:08:26 LOG: query: SELECT language_code FROM supported_languages WHERE language_id='1'
-2004-05-07 12:08:26 LOG: duration: 0.000530 sec
-2004-05-07 12:08:53 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:08:53 LOG: duration: 0.000855 sec
-2004-05-07 12:08:53 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 12:08:53 LOG: duration: 0.002403 sec
-2004-05-07 12:08:53 LOG: query:
- SELECT *
- FROM groups
- WHERE unix_group_name='simplemail'
- AND status IN ('A','H')
-
-2004-05-07 12:08:53 LOG: duration: 0.003185 sec
-2004-05-07 12:08:53 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'12','0','IE','6.0','Win','1083946133','/projects/simplemail/','0');
-2004-05-07 12:08:53 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:08:53 LOG: duration: 0.000898 sec
-2004-05-07 12:08:53 LOG: query: BEGIN; SELECT usesuper FROM pg_catalog.pg_user WHERE usename = 'gforge'; COMMIT
-2004-05-07 12:08:53 LOG: duration: 0.028393 sec
-2004-05-07 12:08:53 LOG: query: SELECT language_id FROM supported_languages WHERE classname='English'
-2004-05-07 12:08:53 LOG: duration: 0.001103 sec
-2004-05-07 12:08:53 LOG: duration: 0.039607 sec
-2004-05-07 12:08:53 LOG: query: SELECT language_code FROM supported_languages WHERE language_id='1'
-2004-05-07 12:08:53 LOG: duration: 0.000592 sec
-2004-05-07 12:08:53 LOG: query: SELECT users.user_id,users.user_name,users.realname
- FROM users,user_group
- WHERE user_group.user_id=users.user_id
- AND user_group.group_id='70'
- AND user_group.admin_flags = 'A'
- AND users.status='A'
-2004-05-07 12:08:53 LOG: duration: 0.003085 sec
-2004-05-07 12:08:53 LOG: query:
- SELECT trove_cat.fullpath AS fullpath,
- trove_cat.fullpath_ids AS fullpath_ids,
- trove_cat.trove_cat_id AS trove_cat_id
- FROM trove_cat,trove_group_link
- WHERE trove_cat.trove_cat_id=trove_group_link.trove_cat_id
- AND trove_group_link.group_id='70'
- ORDER BY trove_cat.fullpath
-2004-05-07 12:08:53 LOG: duration: 0.002993 sec
-2004-05-07 12:08:53 LOG: query: SELECT percentile FROM project_weekly_metric WHERE group_id='70'
-2004-05-07 12:08:53 LOG: duration: 0.000927 sec
-2004-05-07 12:08:53 LOG: query: SELECT name
- FROM people_job,people_job_category
- WHERE people_job.category_id=people_job_category.category_id
- AND people_job.status_id=1
- AND group_id='70'
- GROUP BY name LIMIT 2 OFFSET 0
-2004-05-07 12:08:53 LOG: duration: 0.001564 sec
-2004-05-07 12:08:53 LOG: query: select count(users.user_id) from user_group, users where user_group.group_id='70' and users.user_id=user_group.user_id and users.status='A'
-2004-05-07 12:08:53 LOG: duration: 0.001051 sec
-2004-05-07 12:08:53 LOG: query: SELECT frs_package.package_id,frs_package.name AS package_name,frs_release.name AS release_name,frs_release.release_id AS release_id,frs_release.release_date AS release_date FROM frs_package,frs_release WHERE frs_package.package_id=frs_release.package_id AND frs_package.group_id='70' AND frs_release.status_id=1 ORDER BY frs_package.package_id,frs_release.release_date DESC
-2004-05-07 12:08:53 LOG: duration: 0.002329 sec
-2004-05-07 12:08:53 LOG: query: SELECT agl.*,aca.count,aca.open_count
- FROM artifact_group_list agl
- LEFT JOIN artifact_counts_agg aca USING (group_artifact_id)
- WHERE agl.group_id='70'
- AND agl.is_public=1
- ORDER BY group_artifact_id ASC
-2004-05-07 12:08:53 LOG: duration: 0.002809 sec
-2004-05-07 12:08:53 LOG: query: SELECT type, count FROM project_sums_agg WHERE group_id=70
-2004-05-07 12:08:53 LOG: duration: 0.001019 sec
-2004-05-07 12:08:53 LOG: query: SELECT * FROM project_group_list WHERE group_id='70' AND is_public=1
-2004-05-07 12:08:53 LOG: duration: 0.001224 sec
-2004-05-07 12:08:53 LOG: query:
- SELECT sum(commits) AS commits,sum(adds) AS adds
- FROM stats_cvs_group
- WHERE group_id='70'
-
-2004-05-07 12:08:53 LOG: duration: 0.084562 sec
-2004-05-07 12:08:53 LOG: query: SELECT groups.group_name,groups.unix_group_name,
- groups.type_id,users.user_name,users.realname,
- news_bytes.forum_id,news_bytes.summary,news_bytes.post_date,news_bytes.details
- FROM users,news_bytes,groups
- WHERE news_bytes.group_id='70' AND news_bytes.is_approved <> '4'
- AND users.user_id=news_bytes.submitted_by
- AND news_bytes.group_id=groups.group_id
- ORDER BY post_date DESC LIMIT 10 OFFSET 0
-2004-05-07 12:08:53 LOG: duration: 0.002980 sec
-2004-05-07 12:08:53 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='512'
-2004-05-07 12:08:53 LOG: duration: 0.003011 sec
-2004-05-07 12:08:54 LOG: query: SELECT relname FROM pg_catalog.pg_class WHERE (relkind='r' or relkind='v') and substr(relname,1,5)='grpou' and pg_catalog.pg_table_is_visible(oid)
-2004-05-07 12:08:54 LOG: duration: 0.002892 sec
-2004-05-07 12:08:55 LOG: query: SELECT relname FROM pg_catalog.pg_class WHERE (relkind='r' or relkind='v') and substr(relname,1,3)='grr' and pg_catalog.pg_table_is_visible(oid)
-2004-05-07 12:08:55 LOG: duration: 0.001469 sec
-2004-05-07 12:08:56 LOG: query: SELECT relname FROM pg_catalog.pg_class WHERE (relkind='r' or relkind='v') and substr(relname,1,2)='gr' and pg_catalog.pg_table_is_visible(oid)
-2004-05-07 12:08:56 LOG: duration: 0.001775 sec
-2004-05-07 12:08:57 LOG: query: SELECT c.oid,
- n.nspname,
- c.relname
-FROM pg_catalog.pg_class c
- LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
-WHERE pg_catalog.pg_table_is_visible(c.oid)
- AND c.relname ~ '^group$'
-ORDER BY 2, 3;
-2004-05-07 12:08:57 LOG: duration: 0.053801 sec
-2004-05-07 12:08:59 LOG: query: SELECT c.oid,
- n.nspname,
- c.relname
-FROM pg_catalog.pg_class c
- LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
-WHERE pg_catalog.pg_table_is_visible(c.oid)
- AND c.relname ~ '^groups$'
-ORDER BY 2, 3;
-2004-05-07 12:08:59 LOG: duration: 0.004144 sec
-2004-05-07 12:08:59 LOG: query: SELECT relhasindex, relkind, relchecks, reltriggers, relhasrules
-FROM pg_catalog.pg_class WHERE oid = '20275'
-2004-05-07 12:08:59 LOG: duration: 0.000935 sec
-2004-05-07 12:08:59 LOG: query: SELECT a.attname,
- pg_catalog.format_type(a.atttypid, a.atttypmod),
- a.attnotnull, a.atthasdef, a.attnum
-FROM pg_catalog.pg_attribute a
-WHERE a.attrelid = '20275' AND a.attnum > 0 AND NOT a.attisdropped
-ORDER BY a.attnum
-2004-05-07 12:08:59 LOG: duration: 0.002435 sec
-2004-05-07 12:08:59 LOG: query: SELECT substring(d.adsrc for 128) FROM pg_catalog.pg_attrdef d
-WHERE d.adrelid = '20275' AND d.adnum = 1
-2004-05-07 12:08:59 LOG: duration: 0.001720 sec
-2004-05-07 12:08:59 LOG: query: SELECT substring(d.adsrc for 128) FROM pg_catalog.pg_attrdef d
-WHERE d.adrelid = '20275' AND d.adnum = 4
-2004-05-07 12:08:59 LOG: duration: 0.000794 sec
-2004-05-07 12:08:59 LOG: query: SELECT substring(d.adsrc for 128) FROM pg_catalog.pg_attrdef d
-WHERE d.adrelid = '20275' AND d.adnum = 5
-2004-05-07 12:08:59 LOG: duration: 0.000784 sec
-2004-05-07 12:08:59 LOG: query: SELECT substring(d.adsrc for 128) FROM pg_catalog.pg_attrdef d
-WHERE d.adrelid = '20275' AND d.adnum = 6
-2004-05-07 12:08:59 LOG: duration: 0.000760 sec
-2004-05-07 12:08:59 LOG: query: SELECT substring(d.adsrc for 128) FROM pg_catalog.pg_attrdef d
-WHERE d.adrelid = '20275' AND d.adnum = 7
-2004-05-07 12:08:59 LOG: duration: 0.000706 sec
-2004-05-07 12:08:59 LOG: query: SELECT substring(d.adsrc for 128) FROM pg_catalog.pg_attrdef d
-WHERE d.adrelid = '20275' AND d.adnum = 10
-2004-05-07 12:08:59 LOG: duration: 0.000748 sec
-2004-05-07 12:08:59 LOG: query: SELECT substring(d.adsrc for 128) FROM pg_catalog.pg_attrdef d
-WHERE d.adrelid = '20275' AND d.adnum = 14
-2004-05-07 12:08:59 LOG: duration: 0.000751 sec
-2004-05-07 12:08:59 LOG: query: SELECT substring(d.adsrc for 128) FROM pg_catalog.pg_attrdef d
-WHERE d.adrelid = '20275' AND d.adnum = 17
-2004-05-07 12:08:59 LOG: duration: 0.000770 sec
-2004-05-07 12:08:59 LOG: query: SELECT substring(d.adsrc for 128) FROM pg_catalog.pg_attrdef d
-WHERE d.adrelid = '20275' AND d.adnum = 18
-2004-05-07 12:08:59 LOG: duration: 0.000755 sec
-2004-05-07 12:08:59 LOG: query: SELECT substring(d.adsrc for 128) FROM pg_catalog.pg_attrdef d
-WHERE d.adrelid = '20275' AND d.adnum = 20
-2004-05-07 12:08:59 LOG: duration: 0.000766 sec
-2004-05-07 12:08:59 LOG: query: SELECT substring(d.adsrc for 128) FROM pg_catalog.pg_attrdef d
-WHERE d.adrelid = '20275' AND d.adnum = 21
-2004-05-07 12:08:59 LOG: duration: 0.000744 sec
-2004-05-07 12:08:59 LOG: query: SELECT substring(d.adsrc for 128) FROM pg_catalog.pg_attrdef d
-WHERE d.adrelid = '20275' AND d.adnum = 22
-2004-05-07 12:08:59 LOG: duration: 0.000748 sec
-2004-05-07 12:08:59 LOG: query: SELECT substring(d.adsrc for 128) FROM pg_catalog.pg_attrdef d
-WHERE d.adrelid = '20275' AND d.adnum = 23
-2004-05-07 12:08:59 LOG: duration: 0.000749 sec
-2004-05-07 12:08:59 LOG: query: SELECT substring(d.adsrc for 128) FROM pg_catalog.pg_attrdef d
-WHERE d.adrelid = '20275' AND d.adnum = 28
-2004-05-07 12:08:59 LOG: duration: 0.000744 sec
-2004-05-07 12:08:59 LOG: query: SELECT substring(d.adsrc for 128) FROM pg_catalog.pg_attrdef d
-WHERE d.adrelid = '20275' AND d.adnum = 29
-2004-05-07 12:08:59 LOG: duration: 0.000768 sec
-2004-05-07 12:08:59 LOG: query: SELECT substring(d.adsrc for 128) FROM pg_catalog.pg_attrdef d
-WHERE d.adrelid = '20275' AND d.adnum = 33
-2004-05-07 12:08:59 LOG: duration: 0.000743 sec
-2004-05-07 12:08:59 LOG: query: SELECT substring(d.adsrc for 128) FROM pg_catalog.pg_attrdef d
-WHERE d.adrelid = '20275' AND d.adnum = 34
-2004-05-07 12:08:59 LOG: duration: 0.000806 sec
-2004-05-07 12:08:59 LOG: query: SELECT substring(d.adsrc for 128) FROM pg_catalog.pg_attrdef d
-WHERE d.adrelid = '20275' AND d.adnum = 36
-2004-05-07 12:08:59 LOG: duration: 0.000749 sec
-2004-05-07 12:08:59 LOG: query: SELECT substring(d.adsrc for 128) FROM pg_catalog.pg_attrdef d
-WHERE d.adrelid = '20275' AND d.adnum = 40
-2004-05-07 12:08:59 LOG: duration: 0.000772 sec
-2004-05-07 12:08:59 LOG: query: SELECT substring(d.adsrc for 128) FROM pg_catalog.pg_attrdef d
-WHERE d.adrelid = '20275' AND d.adnum = 41
-2004-05-07 12:08:59 LOG: duration: 0.000721 sec
-2004-05-07 12:08:59 LOG: query: SELECT substring(d.adsrc for 128) FROM pg_catalog.pg_attrdef d
-WHERE d.adrelid = '20275' AND d.adnum = 42
-2004-05-07 12:08:59 LOG: duration: 0.000724 sec
-2004-05-07 12:08:59 LOG: query: SELECT substring(d.adsrc for 128) FROM pg_catalog.pg_attrdef d
-WHERE d.adrelid = '20275' AND d.adnum = 43
-2004-05-07 12:08:59 LOG: duration: 0.000739 sec
-2004-05-07 12:08:59 LOG: query: SELECT substring(d.adsrc for 128) FROM pg_catalog.pg_attrdef d
-WHERE d.adrelid = '20275' AND d.adnum = 44
-2004-05-07 12:08:59 LOG: duration: 0.000775 sec
-2004-05-07 12:08:59 LOG: query: SELECT substring(d.adsrc for 128) FROM pg_catalog.pg_attrdef d
-WHERE d.adrelid = '20275' AND d.adnum = 45
-2004-05-07 12:08:59 LOG: duration: 0.000750 sec
-2004-05-07 12:08:59 LOG: query: SELECT c2.relname, i.indisprimary, i.indisunique, pg_catalog.pg_get_indexdef(i.indexrelid)
-FROM pg_catalog.pg_class c, pg_catalog.pg_class c2, pg_catalog.pg_index i
-WHERE c.oid = '20275' AND c.oid = i.indrelid AND i.indexrelid = c2.oid
-ORDER BY i.indisprimary DESC, i.indisunique DESC, c2.relname
-2004-05-07 12:08:59 LOG: duration: 0.002278 sec
-2004-05-07 12:08:59 LOG: query: SELECT t.tgname
-FROM pg_catalog.pg_trigger t
-WHERE t.tgrelid = '20275' and (not tgisconstraint OR NOT EXISTS (SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c ON (d.refclassid = c.tableoid AND d.refobjid = c.oid) WHERE d.classid = t.tableoid AND d.objid = t.oid AND d.deptype = 'i' AND c.contype = 'f'))
-2004-05-07 12:08:59 LOG: duration: 0.030052 sec
-2004-05-07 12:08:59 LOG: query: SELECT conname,
- pg_catalog.pg_get_constraintdef(oid) as condef
-FROM pg_catalog.pg_constraint r
-WHERE r.conrelid = '20275' AND r.contype = 'f'
-2004-05-07 12:08:59 LOG: duration: 0.000956 sec
-2004-05-07 12:09:05 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:09:05 LOG: duration: 0.000932 sec
-2004-05-07 12:09:05 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 12:09:05 LOG: duration: 0.002286 sec
-2004-05-07 12:09:05 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'12','85','IE','6.0','Win','1083946145','/frs/index.php','0');
-2004-05-07 12:09:05 LOG: duration: 0.003796 sec
-2004-05-07 12:09:05 LOG: query: select classname from supported_languages where language_code = 'pt-br'
-2004-05-07 12:09:05 LOG: duration: 0.001711 sec
-2004-05-07 12:09:05 LOG: query: SELECT *
- FROM frs_package
- WHERE group_id='85' AND status_id='1'
- ORDER BY name
-2004-05-07 12:09:05 LOG: duration: 0.002091 sec
-2004-05-07 12:09:05 LOG: query: SELECT * FROM groups WHERE group_id='85'
-2004-05-07 12:09:05 LOG: duration: 0.002133 sec
-2004-05-07 12:09:05 LOG: query: SELECT language_id FROM supported_languages WHERE classname='PortugueseBrazilian'
-2004-05-07 12:09:05 LOG: duration: 0.000520 sec
-2004-05-07 12:09:05 LOG: query: SELECT language_code FROM supported_languages WHERE language_id='16'
-2004-05-07 12:09:05 LOG: duration: 0.000357 sec
-2004-05-07 12:09:05 LOG: query: SELECT * FROM frs_release
- WHERE package_id='134'
- AND status_id=1 ORDER BY release_date DESC, name ASC
-2004-05-07 12:09:05 LOG: duration: 0.001658 sec
-2004-05-07 12:09:05 LOG: query: SELECT frs_file.filename AS filename,
- frs_file.file_size AS file_size,
- frs_file.file_id AS file_id,
- frs_file.release_time AS release_time,
- frs_filetype.name AS type,
- frs_processor.name AS processor,
- frs_dlstats_filetotal_agg.downloads AS downloads
- FROM frs_filetype,frs_processor,
- frs_file LEFT JOIN frs_dlstats_filetotal_agg ON frs_dlstats_filetotal_agg.file_id=frs_file.file_id
- WHERE release_id='177'
- AND frs_filetype.type_id=frs_file.type_id
- AND frs_processor.processor_id=frs_file.processor_id
- ORDER BY filename
-2004-05-07 12:09:05 LOG: duration: 0.004038 sec
-2004-05-07 12:09:05 LOG: query: SELECT * FROM frs_release
- WHERE package_id='117'
- AND status_id=1 ORDER BY release_date DESC, name ASC
-2004-05-07 12:09:05 LOG: duration: 0.000778 sec
-2004-05-07 12:09:05 LOG: query: SELECT frs_file.filename AS filename,
- frs_file.file_size AS file_size,
- frs_file.file_id AS file_id,
- frs_file.release_time AS release_time,
- frs_filetype.name AS type,
- frs_processor.name AS processor,
- frs_dlstats_filetotal_agg.downloads AS downloads
- FROM frs_filetype,frs_processor,
- frs_file LEFT JOIN frs_dlstats_filetotal_agg ON frs_dlstats_filetotal_agg.file_id=frs_file.file_id
- WHERE release_id='335'
- AND frs_filetype.type_id=frs_file.type_id
- AND frs_processor.processor_id=frs_file.processor_id
- ORDER BY filename
-2004-05-07 12:09:05 LOG: duration: 0.002271 sec
-2004-05-07 12:09:05 LOG: query: SELECT * FROM frs_release
- WHERE package_id='172'
- AND status_id=1 ORDER BY release_date DESC, name ASC
-2004-05-07 12:09:05 LOG: duration: 0.000712 sec
-2004-05-07 12:09:05 LOG: query: SELECT frs_file.filename AS filename,
- frs_file.file_size AS file_size,
- frs_file.file_id AS file_id,
- frs_file.release_time AS release_time,
- frs_filetype.name AS type,
- frs_processor.name AS processor,
- frs_dlstats_filetotal_agg.downloads AS downloads
- FROM frs_filetype,frs_processor,
- frs_file LEFT JOIN frs_dlstats_filetotal_agg ON frs_dlstats_filetotal_agg.file_id=frs_file.file_id
- WHERE release_id='457'
- AND frs_filetype.type_id=frs_file.type_id
- AND frs_processor.processor_id=frs_file.processor_id
- ORDER BY filename
-2004-05-07 12:09:05 LOG: duration: 0.002623 sec
-2004-05-07 12:09:05 LOG: query: SELECT frs_file.filename AS filename,
- frs_file.file_size AS file_size,
- frs_file.file_id AS file_id,
- frs_file.release_time AS release_time,
- frs_filetype.name AS type,
- frs_processor.name AS processor,
- frs_dlstats_filetotal_agg.downloads AS downloads
- FROM frs_filetype,frs_processor,
- frs_file LEFT JOIN frs_dlstats_filetotal_agg ON frs_dlstats_filetotal_agg.file_id=frs_file.file_id
- WHERE release_id='269'
- AND frs_filetype.type_id=frs_file.type_id
- AND frs_processor.processor_id=frs_file.processor_id
- ORDER BY filename
-2004-05-07 12:09:05 LOG: duration: 0.002060 sec
-2004-05-07 12:09:05 LOG: query: SELECT * FROM frs_release
- WHERE package_id='113'
- AND status_id=1 ORDER BY release_date DESC, name ASC
-2004-05-07 12:09:05 LOG: duration: 0.000747 sec
-2004-05-07 12:09:05 LOG: query: SELECT frs_file.filename AS filename,
- frs_file.file_size AS file_size,
- frs_file.file_id AS file_id,
- frs_file.release_time AS release_time,
- frs_filetype.name AS type,
- frs_processor.name AS processor,
- frs_dlstats_filetotal_agg.downloads AS downloads
- FROM frs_filetype,frs_processor,
- frs_file LEFT JOIN frs_dlstats_filetotal_agg ON frs_dlstats_filetotal_agg.file_id=frs_file.file_id
- WHERE release_id='319'
- AND frs_filetype.type_id=frs_file.type_id
- AND frs_processor.processor_id=frs_file.processor_id
- ORDER BY filename
-2004-05-07 12:09:05 LOG: duration: 0.002116 sec
-2004-05-07 12:09:05 LOG: query: SELECT frs_file.filename AS filename,
- frs_file.file_size AS file_size,
- frs_file.file_id AS file_id,
- frs_file.release_time AS release_time,
- frs_filetype.name AS type,
- frs_processor.name AS processor,
- frs_dlstats_filetotal_agg.downloads AS downloads
- FROM frs_filetype,frs_processor,
- frs_file LEFT JOIN frs_dlstats_filetotal_agg ON frs_dlstats_filetotal_agg.file_id=frs_file.file_id
- WHERE release_id='279'
- AND frs_filetype.type_id=frs_file.type_id
- AND frs_processor.processor_id=frs_file.processor_id
- ORDER BY filename
-2004-05-07 12:09:05 LOG: duration: 0.002021 sec
-2004-05-07 12:09:05 LOG: query: SELECT * FROM frs_release
- WHERE package_id='122'
- AND status_id=1 ORDER BY release_date DESC, name ASC
-2004-05-07 12:09:05 LOG: duration: 0.000703 sec
-2004-05-07 12:09:05 LOG: query: SELECT frs_file.filename AS filename,
- frs_file.file_size AS file_size,
- frs_file.file_id AS file_id,
- frs_file.release_time AS release_time,
- frs_filetype.name AS type,
- frs_processor.name AS processor,
- frs_dlstats_filetotal_agg.downloads AS downloads
- FROM frs_filetype,frs_processor,
- frs_file LEFT JOIN frs_dlstats_filetotal_agg ON frs_dlstats_filetotal_agg.file_id=frs_file.file_id
- WHERE release_id='157'
- AND frs_filetype.type_id=frs_file.type_id
- AND frs_processor.processor_id=frs_file.processor_id
- ORDER BY filename
-2004-05-07 12:09:05 LOG: duration: 0.001741 sec
-2004-05-07 12:09:05 LOG: query: SELECT * FROM frs_release
- WHERE package_id='266'
- AND status_id=1 ORDER BY release_date DESC, name ASC
-2004-05-07 12:09:05 LOG: duration: 0.000652 sec
-2004-05-07 12:09:05 LOG: query: SELECT frs_file.filename AS filename,
- frs_file.file_size AS file_size,
- frs_file.file_id AS file_id,
- frs_file.release_time AS release_time,
- frs_filetype.name AS type,
- frs_processor.name AS processor,
- frs_dlstats_filetotal_agg.downloads AS downloads
- FROM frs_filetype,frs_processor,
- frs_file LEFT JOIN frs_dlstats_filetotal_agg ON frs_dlstats_filetotal_agg.file_id=frs_file.file_id
- WHERE release_id='456'
- AND frs_filetype.type_id=frs_file.type_id
- AND frs_processor.processor_id=frs_file.processor_id
- ORDER BY filename
-2004-05-07 12:09:05 LOG: duration: 0.002535 sec
-2004-05-07 12:09:05 LOG: query: SELECT * FROM frs_release
- WHERE package_id='211'
- AND status_id=1 ORDER BY release_date DESC, name ASC
-2004-05-07 12:09:05 LOG: duration: 0.000719 sec
-2004-05-07 12:09:05 LOG: query: SELECT frs_file.filename AS filename,
- frs_file.file_size AS file_size,
- frs_file.file_id AS file_id,
- frs_file.release_time AS release_time,
- frs_filetype.name AS type,
- frs_processor.name AS processor,
- frs_dlstats_filetotal_agg.downloads AS downloads
- FROM frs_filetype,frs_processor,
- frs_file LEFT JOIN frs_dlstats_filetotal_agg ON frs_dlstats_filetotal_agg.file_id=frs_file.file_id
- WHERE release_id='344'
- AND frs_filetype.type_id=frs_file.type_id
- AND frs_processor.processor_id=frs_file.processor_id
- ORDER BY filename
-2004-05-07 12:09:05 LOG: duration: 0.002187 sec
-2004-05-07 12:09:05 LOG: query: SELECT frs_file.filename AS filename,
- frs_file.file_size AS file_size,
- frs_file.file_id AS file_id,
- frs_file.release_time AS release_time,
- frs_filetype.name AS type,
- frs_processor.name AS processor,
- frs_dlstats_filetotal_agg.downloads AS downloads
- FROM frs_filetype,frs_processor,
- frs_file LEFT JOIN frs_dlstats_filetotal_agg ON frs_dlstats_filetotal_agg.file_id=frs_file.file_id
- WHERE release_id='337'
- AND frs_filetype.type_id=frs_file.type_id
- AND frs_processor.processor_id=frs_file.processor_id
- ORDER BY filename
-2004-05-07 12:09:05 LOG: duration: 0.002152 sec
-2004-05-07 12:09:05 LOG: query: SELECT * FROM frs_release
- WHERE package_id='85'
- AND status_id=1 ORDER BY release_date DESC, name ASC
-2004-05-07 12:09:05 LOG: duration: 0.000679 sec
-2004-05-07 12:09:05 LOG: query: SELECT frs_file.filename AS filename,
- frs_file.file_size AS file_size,
- frs_file.file_id AS file_id,
- frs_file.release_time AS release_time,
- frs_filetype.name AS type,
- frs_processor.name AS processor,
- frs_dlstats_filetotal_agg.downloads AS downloads
- FROM frs_filetype,frs_processor,
- frs_file LEFT JOIN frs_dlstats_filetotal_agg ON frs_dlstats_filetotal_agg.file_id=frs_file.file_id
- WHERE release_id='464'
- AND frs_filetype.type_id=frs_file.type_id
- AND frs_processor.processor_id=frs_file.processor_id
- ORDER BY filename
-2004-05-07 12:09:05 LOG: duration: 0.002568 sec
-2004-05-07 12:09:05 LOG: query: SELECT * FROM frs_release
- WHERE package_id='138'
- AND status_id=1 ORDER BY release_date DESC, name ASC
-2004-05-07 12:09:05 LOG: duration: 0.000650 sec
-2004-05-07 12:09:05 LOG: query: SELECT frs_file.filename AS filename,
- frs_file.file_size AS file_size,
- frs_file.file_id AS file_id,
- frs_file.release_time AS release_time,
- frs_filetype.name AS type,
- frs_processor.name AS processor,
- frs_dlstats_filetotal_agg.downloads AS downloads
- FROM frs_filetype,frs_processor,
- frs_file LEFT JOIN frs_dlstats_filetotal_agg ON frs_dlstats_filetotal_agg.file_id=frs_file.file_id
- WHERE release_id='294'
- AND frs_filetype.type_id=frs_file.type_id
- AND frs_processor.processor_id=frs_file.processor_id
- ORDER BY filename
-2004-05-07 12:09:05 LOG: duration: 0.002036 sec
-2004-05-07 12:09:05 LOG: query: SELECT * FROM frs_release
- WHERE package_id='195'
- AND status_id=1 ORDER BY release_date DESC, name ASC
-2004-05-07 12:09:05 LOG: duration: 0.000652 sec
-2004-05-07 12:09:05 LOG: query: SELECT frs_file.filename AS filename,
- frs_file.file_size AS file_size,
- frs_file.file_id AS file_id,
- frs_file.release_time AS release_time,
- frs_filetype.name AS type,
- frs_processor.name AS processor,
- frs_dlstats_filetotal_agg.downloads AS downloads
- FROM frs_filetype,frs_processor,
- frs_file LEFT JOIN frs_dlstats_filetotal_agg ON frs_dlstats_filetotal_agg.file_id=frs_file.file_id
- WHERE release_id='327'
- AND frs_filetype.type_id=frs_file.type_id
- AND frs_processor.processor_id=frs_file.processor_id
- ORDER BY filename
-2004-05-07 12:09:05 LOG: duration: 0.002140 sec
-2004-05-07 12:09:05 LOG: query: SELECT * FROM frs_release
- WHERE package_id='109'
- AND status_id=1 ORDER BY release_date DESC, name ASC
-2004-05-07 12:09:05 LOG: duration: 0.000716 sec
-2004-05-07 12:09:05 LOG: query: SELECT frs_file.filename AS filename,
- frs_file.file_size AS file_size,
- frs_file.file_id AS file_id,
- frs_file.release_time AS release_time,
- frs_filetype.name AS type,
- frs_processor.name AS processor,
- frs_dlstats_filetotal_agg.downloads AS downloads
- FROM frs_filetype,frs_processor,
- frs_file LEFT JOIN frs_dlstats_filetotal_agg ON frs_dlstats_filetotal_agg.file_id=frs_file.file_id
- WHERE release_id='343'
- AND frs_filetype.type_id=frs_file.type_id
- AND frs_processor.processor_id=frs_file.processor_id
- ORDER BY filename
-2004-05-07 12:09:05 LOG: duration: 0.002186 sec
-2004-05-07 12:09:05 LOG: query: SELECT frs_file.filename AS filename,
- frs_file.file_size AS file_size,
- frs_file.file_id AS file_id,
- frs_file.release_time AS release_time,
- frs_filetype.name AS type,
- frs_processor.name AS processor,
- frs_dlstats_filetotal_agg.downloads AS downloads
- FROM frs_filetype,frs_processor,
- frs_file LEFT JOIN frs_dlstats_filetotal_agg ON frs_dlstats_filetotal_agg.file_id=frs_file.file_id
- WHERE release_id='289'
- AND frs_filetype.type_id=frs_file.type_id
- AND frs_processor.processor_id=frs_file.processor_id
- ORDER BY filename
-2004-05-07 12:09:05 LOG: duration: 0.002057 sec
-2004-05-07 12:09:05 LOG: query: SELECT * FROM frs_release
- WHERE package_id='190'
- AND status_id=1 ORDER BY release_date DESC, name ASC
-2004-05-07 12:09:05 LOG: duration: 0.000637 sec
-2004-05-07 12:09:05 LOG: query: SELECT frs_file.filename AS filename,
- frs_file.file_size AS file_size,
- frs_file.file_id AS file_id,
- frs_file.release_time AS release_time,
- frs_filetype.name AS type,
- frs_processor.name AS processor,
- frs_dlstats_filetotal_agg.downloads AS downloads
- FROM frs_filetype,frs_processor,
- frs_file LEFT JOIN frs_dlstats_filetotal_agg ON frs_dlstats_filetotal_agg.file_id=frs_file.file_id
- WHERE release_id='295'
- AND frs_filetype.type_id=frs_file.type_id
- AND frs_processor.processor_id=frs_file.processor_id
- ORDER BY filename
-2004-05-07 12:09:05 LOG: duration: 0.002044 sec
-2004-05-07 12:09:05 LOG: query: SELECT * FROM frs_release
- WHERE package_id='259'
- AND status_id=1 ORDER BY release_date DESC, name ASC
-2004-05-07 12:09:05 LOG: duration: 0.000708 sec
-2004-05-07 12:09:05 LOG: query: SELECT frs_file.filename AS filename,
- frs_file.file_size AS file_size,
- frs_file.file_id AS file_id,
- frs_file.release_time AS release_time,
- frs_filetype.name AS type,
- frs_processor.name AS processor,
- frs_dlstats_filetotal_agg.downloads AS downloads
- FROM frs_filetype,frs_processor,
- frs_file LEFT JOIN frs_dlstats_filetotal_agg ON frs_dlstats_filetotal_agg.file_id=frs_file.file_id
- WHERE release_id='429'
- AND frs_filetype.type_id=frs_file.type_id
- AND frs_processor.processor_id=frs_file.processor_id
- ORDER BY filename
-2004-05-07 12:09:05 LOG: duration: 0.002456 sec
-2004-05-07 12:09:05 LOG: query: SELECT * FROM frs_release
- WHERE package_id='268'
- AND status_id=1 ORDER BY release_date DESC, name ASC
-2004-05-07 12:09:05 LOG: duration: 0.000651 sec
-2004-05-07 12:09:05 LOG: query: SELECT frs_file.filename AS filename,
- frs_file.file_size AS file_size,
- frs_file.file_id AS file_id,
- frs_file.release_time AS release_time,
- frs_filetype.name AS type,
- frs_processor.name AS processor,
- frs_dlstats_filetotal_agg.downloads AS downloads
- FROM frs_filetype,frs_processor,
- frs_file LEFT JOIN frs_dlstats_filetotal_agg ON frs_dlstats_filetotal_agg.file_id=frs_file.file_id
- WHERE release_id='462'
- AND frs_filetype.type_id=frs_file.type_id
- AND frs_processor.processor_id=frs_file.processor_id
- ORDER BY filename
-2004-05-07 12:09:05 LOG: duration: 0.002571 sec
-2004-05-07 12:09:40 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:09:40 LOG: duration: 0.000785 sec
-2004-05-07 12:09:40 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 12:09:40 LOG: duration: 0.001868 sec
-2004-05-07 12:09:40 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'12','5','OTHER','0','Other','1083946180','/forum/index.php','0');
-2004-05-07 12:09:40 LOG: duration: 0.002414 sec
-2004-05-07 12:09:40 LOG: query: SELECT * FROM groups WHERE group_id='5'
-2004-05-07 12:09:40 LOG: duration: 0.002861 sec
-2004-05-07 12:09:40 LOG: query: SELECT language_id FROM supported_languages WHERE classname='English'
-2004-05-07 12:09:40 LOG: duration: 0.001031 sec
-2004-05-07 12:09:40 LOG: query: SELECT language_code FROM supported_languages WHERE language_id='1'
-2004-05-07 12:09:40 LOG: duration: 0.000415 sec
-2004-05-07 12:09:40 LOG: query: SELECT *
- FROM forum_group_list_vw
- WHERE group_id='5'
- AND is_public =1
- ORDER BY group_forum_id;
-2004-05-07 12:09:40 LOG: duration: 0.045931 sec
-2004-05-07 12:10:00 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:10:00 LOG: duration: 0.000802 sec
-2004-05-07 12:10:00 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 12:10:00 LOG: duration: 0.001884 sec
-2004-05-07 12:10:00 LOG: query:
- SELECT *
- FROM groups
- WHERE unix_group_name='ripper'
- AND status IN ('A','H')
-
-2004-05-07 12:10:00 LOG: duration: 0.003094 sec
-2004-05-07 12:10:00 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'12','0','MOZILLA','2.0','Other','1083946200','/projects/ripper','0');
-2004-05-07 12:10:00 LOG: duration: 0.002670 sec
-2004-05-07 12:10:00 LOG: query: SELECT language_id FROM supported_languages WHERE classname='English'
-2004-05-07 12:10:00 LOG: duration: 0.001082 sec
-2004-05-07 12:10:00 LOG: query: SELECT language_code FROM supported_languages WHERE language_id='1'
-2004-05-07 12:10:00 LOG: duration: 0.000481 sec
-2004-05-07 12:10:00 LOG: query: SELECT users.user_id,users.user_name,users.realname
- FROM users,user_group
- WHERE user_group.user_id=users.user_id
- AND user_group.group_id='145'
- AND user_group.admin_flags = 'A'
- AND users.status='A'
-2004-05-07 12:10:00 LOG: duration: 0.003712 sec
-2004-05-07 12:10:00 LOG: query:
- SELECT trove_cat.fullpath AS fullpath,
- trove_cat.fullpath_ids AS fullpath_ids,
- trove_cat.trove_cat_id AS trove_cat_id
- FROM trove_cat,trove_group_link
- WHERE trove_cat.trove_cat_id=trove_group_link.trove_cat_id
- AND trove_group_link.group_id='145'
- ORDER BY trove_cat.fullpath
-2004-05-07 12:10:00 LOG: duration: 0.003270 sec
-2004-05-07 12:10:00 LOG: query: SELECT percentile FROM project_weekly_metric WHERE group_id='145'
-2004-05-07 12:10:00 LOG: duration: 0.001060 sec
-2004-05-07 12:10:00 LOG: query: SELECT name
- FROM people_job,people_job_category
- WHERE people_job.category_id=people_job_category.category_id
- AND people_job.status_id=1
- AND group_id='145'
- GROUP BY name LIMIT 2 OFFSET 0
-2004-05-07 12:10:00 LOG: duration: 0.001684 sec
-2004-05-07 12:10:00 LOG: query: select count(users.user_id) from user_group, users where user_group.group_id='145' and users.user_id=user_group.user_id and users.status='A'
-2004-05-07 12:10:00 LOG: duration: 0.001286 sec
-2004-05-07 12:10:00 LOG: query: SELECT frs_package.package_id,frs_package.name AS package_name,frs_release.name AS release_name,frs_release.release_id AS release_id,frs_release.release_date AS release_date FROM frs_package,frs_release WHERE frs_package.package_id=frs_release.package_id AND frs_package.group_id='145' AND frs_release.status_id=1 ORDER BY frs_package.package_id,frs_release.release_date DESC
-2004-05-07 12:10:00 LOG: duration: 0.002247 sec
-2004-05-07 12:10:00 LOG: query: SELECT agl.*,aca.count,aca.open_count
- FROM artifact_group_list agl
- LEFT JOIN artifact_counts_agg aca USING (group_artifact_id)
- WHERE agl.group_id='145'
- AND agl.is_public=1
- ORDER BY group_artifact_id ASC
-2004-05-07 12:10:00 LOG: duration: 0.002633 sec
-2004-05-07 12:10:00 LOG: query: SELECT type, count FROM project_sums_agg WHERE group_id=145
-2004-05-07 12:10:00 LOG: duration: 0.001152 sec
-2004-05-07 12:10:00 LOG: query: SELECT * FROM project_group_list WHERE group_id='145' AND is_public=1
-2004-05-07 12:10:00 LOG: duration: 0.001202 sec
-2004-05-07 12:10:00 LOG: query:
- SELECT sum(commits) AS commits,sum(adds) AS adds
- FROM stats_cvs_group
- WHERE group_id='145'
-
-2004-05-07 12:10:00 LOG: duration: 0.093956 sec
-2004-05-07 12:10:00 LOG: query: SELECT groups.group_name,groups.unix_group_name,
- groups.type_id,users.user_name,users.realname,
- news_bytes.forum_id,news_bytes.summary,news_bytes.post_date,news_bytes.details
- FROM users,news_bytes,groups
- WHERE news_bytes.group_id='145' AND news_bytes.is_approved <> '4'
- AND users.user_id=news_bytes.submitted_by
- AND news_bytes.group_id=groups.group_id
- ORDER BY post_date DESC LIMIT 10 OFFSET 0
-2004-05-07 12:10:00 LOG: duration: 0.002689 sec
-2004-05-07 12:10:01 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:10:01 LOG: duration: 0.001085 sec
-2004-05-07 12:10:01 LOG: query: SELECT frs_file.filename,frs_file.file_id,groups.unix_group_name,groups.group_id
- FROM frs_package,frs_release,frs_file,groups
- WHERE frs_release.release_id=frs_file.release_id
- AND groups.group_id=frs_package.group_id
- AND frs_release.package_id=frs_package.package_id
- AND frs_file.file_id='618'
-2004-05-07 12:10:01 LOG: duration: 0.006769 sec
-2004-05-07 12:10:01 LOG: query: SELECT * FROM groups WHERE group_id='85'
-2004-05-07 12:10:01 LOG: duration: 0.001098 sec
-2004-05-07 12:10:03 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:10:03 LOG: duration: 0.000805 sec
-2004-05-07 12:10:03 LOG: query: SELECT frs_file.filename,frs_file.file_id,groups.unix_group_name,groups.group_id
- FROM frs_package,frs_release,frs_file,groups
- WHERE frs_release.release_id=frs_file.release_id
- AND groups.group_id=frs_package.group_id
- AND frs_release.package_id=frs_package.package_id
- AND frs_file.file_id='618'
-2004-05-07 12:10:03 LOG: duration: 0.005442 sec
-2004-05-07 12:10:03 LOG: query: SELECT * FROM groups WHERE group_id='85'
-2004-05-07 12:10:03 LOG: duration: 0.001100 sec
-2004-05-07 12:10:03 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:10:03 LOG: duration: 0.000785 sec
-2004-05-07 12:10:03 LOG: query: SELECT frs_file.filename,frs_file.file_id,groups.unix_group_name,groups.group_id
- FROM frs_package,frs_release,frs_file,groups
- WHERE frs_release.release_id=frs_file.release_id
- AND groups.group_id=frs_package.group_id
- AND frs_release.package_id=frs_package.package_id
- AND frs_file.file_id='618'
-2004-05-07 12:10:03 LOG: duration: 0.005529 sec
-2004-05-07 12:10:03 LOG: query: SELECT * FROM groups WHERE group_id='85'
-2004-05-07 12:10:03 LOG: duration: 0.001086 sec
-2004-05-07 12:10:04 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:10:04 LOG: duration: 0.000815 sec
-2004-05-07 12:10:04 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 12:10:04 LOG: duration: 0.002201 sec
-2004-05-07 12:10:04 LOG: query:
- SELECT *
- FROM groups
- WHERE unix_group_name='winjobscheduler'
- AND status IN ('A','H')
-
-2004-05-07 12:10:04 LOG: duration: 0.003206 sec
-2004-05-07 12:10:04 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'12','0','IE','6.0','Win','1083946204','/projects/winjobscheduler/','0');
-2004-05-07 12:10:04 LOG: duration: 0.153676 sec
-2004-05-07 12:10:04 LOG: query: select classname from supported_languages where language_code = 'en-gb'
-2004-05-07 12:10:04 LOG: duration: 0.001147 sec
-2004-05-07 12:10:04 LOG: query: select classname from supported_languages where language_code = 'en'
-2004-05-07 12:10:04 LOG: duration: 0.000358 sec
-2004-05-07 12:10:04 LOG: query: SELECT language_id FROM supported_languages WHERE classname='English'
-2004-05-07 12:10:04 LOG: duration: 0.000621 sec
-2004-05-07 12:10:04 LOG: query: SELECT language_code FROM supported_languages WHERE language_id='1'
-2004-05-07 12:10:04 LOG: duration: 0.000393 sec
-2004-05-07 12:10:04 LOG: query: SELECT users.user_id,users.user_name,users.realname
- FROM users,user_group
- WHERE user_group.user_id=users.user_id
- AND user_group.group_id='96'
- AND user_group.admin_flags = 'A'
- AND users.status='A'
-2004-05-07 12:10:04 LOG: duration: 0.003554 sec
-2004-05-07 12:10:04 LOG: query:
- SELECT trove_cat.fullpath AS fullpath,
- trove_cat.fullpath_ids AS fullpath_ids,
- trove_cat.trove_cat_id AS trove_cat_id
- FROM trove_cat,trove_group_link
- WHERE trove_cat.trove_cat_id=trove_group_link.trove_cat_id
- AND trove_group_link.group_id='96'
- ORDER BY trove_cat.fullpath
-2004-05-07 12:10:04 LOG: duration: 0.003642 sec
-2004-05-07 12:10:04 LOG: query: SELECT percentile FROM project_weekly_metric WHERE group_id='96'
-2004-05-07 12:10:04 LOG: duration: 0.001206 sec
-2004-05-07 12:10:04 LOG: query: SELECT name
- FROM people_job,people_job_category
- WHERE people_job.category_id=people_job_category.category_id
- AND people_job.status_id=1
- AND group_id='96'
- GROUP BY name LIMIT 2 OFFSET 0
-2004-05-07 12:10:04 LOG: duration: 0.001759 sec
-2004-05-07 12:10:04 LOG: query: select count(users.user_id) from user_group, users where user_group.group_id='96' and users.user_id=user_group.user_id and users.status='A'
-2004-05-07 12:10:04 LOG: duration: 0.001379 sec
-2004-05-07 12:10:04 LOG: query: SELECT frs_package.package_id,frs_package.name AS package_name,frs_release.name AS release_name,frs_release.release_id AS release_id,frs_release.release_date AS release_date FROM frs_package,frs_release WHERE frs_package.package_id=frs_release.package_id AND frs_package.group_id='96' AND frs_release.status_id=1 ORDER BY frs_package.package_id,frs_release.release_date DESC
-2004-05-07 12:10:04 LOG: duration: 0.002394 sec
-2004-05-07 12:10:04 LOG: query: SELECT agl.*,aca.count,aca.open_count
- FROM artifact_group_list agl
- LEFT JOIN artifact_counts_agg aca USING (group_artifact_id)
- WHERE agl.group_id='96'
- AND agl.is_public=1
- ORDER BY group_artifact_id ASC
-2004-05-07 12:10:04 LOG: duration: 0.002759 sec
-2004-05-07 12:10:04 LOG: query: SELECT type, count FROM project_sums_agg WHERE group_id=96
-2004-05-07 12:10:04 LOG: duration: 0.001197 sec
-2004-05-07 12:10:04 LOG: query: SELECT * FROM project_group_list WHERE group_id='96' AND is_public=1
-2004-05-07 12:10:04 LOG: duration: 0.001213 sec
-2004-05-07 12:10:04 LOG: query:
- SELECT sum(commits) AS commits,sum(adds) AS adds
- FROM stats_cvs_group
- WHERE group_id='96'
-
-2004-05-07 12:10:05 LOG: duration: 0.085162 sec
-2004-05-07 12:10:05 LOG: query: SELECT groups.group_name,groups.unix_group_name,
- groups.type_id,users.user_name,users.realname,
- news_bytes.forum_id,news_bytes.summary,news_bytes.post_date,news_bytes.details
- FROM users,news_bytes,groups
- WHERE news_bytes.group_id='96' AND news_bytes.is_approved <> '4'
- AND users.user_id=news_bytes.submitted_by
- AND news_bytes.group_id=groups.group_id
- ORDER BY post_date DESC LIMIT 10 OFFSET 0
-2004-05-07 12:10:05 LOG: duration: 0.002711 sec
-2004-05-07 12:10:11 LOG: query: INSERT INTO frs_dlstats_file (ip_address,file_id,month,day,user_id)
- VALUES ('200.164.12.32','618','200405','07','100')
-2004-05-07 12:10:11 LOG: duration: 0.005014 sec
-2004-05-07 12:10:16 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:10:16 LOG: duration: 0.001026 sec
-2004-05-07 12:10:16 LOG: query: SELECT frs_file.filename,frs_file.file_id,groups.unix_group_name,groups.group_id
- FROM frs_package,frs_release,frs_file,groups
- WHERE frs_release.release_id=frs_file.release_id
- AND groups.group_id=frs_package.group_id
- AND frs_release.package_id=frs_package.package_id
- AND frs_file.file_id='262'
-2004-05-07 12:10:16 LOG: duration: 0.006691 sec
-2004-05-07 12:10:16 LOG: query: SELECT * FROM groups WHERE group_id='30'
-2004-05-07 12:10:16 LOG: duration: 0.001101 sec
-2004-05-07 12:10:36 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:10:36 LOG: duration: 0.000811 sec
-2004-05-07 12:10:36 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 12:10:36 LOG: duration: 0.002106 sec
-2004-05-07 12:10:36 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'12','167','IE','6.0','Win','1083946236','/frs/index.php','0');
-2004-05-07 12:10:36 LOG: duration: 0.003057 sec
-2004-05-07 12:10:36 LOG: query: select classname from supported_languages where language_code = 'es'
-2004-05-07 12:10:36 LOG: duration: 0.001711 sec
-2004-05-07 12:10:36 LOG: query: SELECT *
- FROM frs_package
- WHERE group_id='167' AND status_id='1'
- ORDER BY name
-2004-05-07 12:10:36 LOG: duration: 0.002001 sec
-2004-05-07 12:10:36 LOG: query: SELECT * FROM groups WHERE group_id='167'
-2004-05-07 12:10:36 LOG: duration: 0.002164 sec
-2004-05-07 12:10:36 LOG: query: SELECT language_id FROM supported_languages WHERE classname='Spanish'
-2004-05-07 12:10:36 LOG: duration: 0.000525 sec
-2004-05-07 12:10:36 LOG: query: SELECT language_code FROM supported_languages WHERE language_id='4'
-2004-05-07 12:10:36 LOG: duration: 0.000336 sec
-2004-05-07 12:10:36 LOG: query: SELECT * FROM frs_release
- WHERE package_id='178'
- AND status_id=1 ORDER BY release_date DESC, name ASC
-2004-05-07 12:10:36 LOG: duration: 0.002189 sec
-2004-05-07 12:10:36 LOG: query: SELECT frs_file.filename AS filename,
- frs_file.file_size AS file_size,
- frs_file.file_id AS file_id,
- frs_file.release_time AS release_time,
- frs_filetype.name AS type,
- frs_processor.name AS processor,
- frs_dlstats_filetotal_agg.downloads AS downloads
- FROM frs_filetype,frs_processor,
- frs_file LEFT JOIN frs_dlstats_filetotal_agg ON frs_dlstats_filetotal_agg.file_id=frs_file.file_id
- WHERE release_id='434'
- AND frs_filetype.type_id=frs_file.type_id
- AND frs_processor.processor_id=frs_file.processor_id
- ORDER BY filename
-2004-05-07 12:10:36 LOG: duration: 0.004681 sec
-2004-05-07 12:10:36 LOG: query: SELECT frs_file.filename AS filename,
- frs_file.file_size AS file_size,
- frs_file.file_id AS file_id,
- frs_file.release_time AS release_time,
- frs_filetype.name AS type,
- frs_processor.name AS processor,
- frs_dlstats_filetotal_agg.downloads AS downloads
- FROM frs_filetype,frs_processor,
- frs_file LEFT JOIN frs_dlstats_filetotal_agg ON frs_dlstats_filetotal_agg.file_id=frs_file.file_id
- WHERE release_id='414'
- AND frs_filetype.type_id=frs_file.type_id
- AND frs_processor.processor_id=frs_file.processor_id
- ORDER BY filename
-2004-05-07 12:10:36 LOG: duration: 0.002519 sec
-2004-05-07 12:10:36 LOG: query: SELECT frs_file.filename AS filename,
- frs_file.file_size AS file_size,
- frs_file.file_id AS file_id,
- frs_file.release_time AS release_time,
- frs_filetype.name AS type,
- frs_processor.name AS processor,
- frs_dlstats_filetotal_agg.downloads AS downloads
- FROM frs_filetype,frs_processor,
- frs_file LEFT JOIN frs_dlstats_filetotal_agg ON frs_dlstats_filetotal_agg.file_id=frs_file.file_id
- WHERE release_id='413'
- AND frs_filetype.type_id=frs_file.type_id
- AND frs_processor.processor_id=frs_file.processor_id
- ORDER BY filename
-2004-05-07 12:10:36 LOG: duration: 0.002432 sec
-2004-05-07 12:10:36 LOG: query: SELECT frs_file.filename AS filename,
- frs_file.file_size AS file_size,
- frs_file.file_id AS file_id,
- frs_file.release_time AS release_time,
- frs_filetype.name AS type,
- frs_processor.name AS processor,
- frs_dlstats_filetotal_agg.downloads AS downloads
- FROM frs_filetype,frs_processor,
- frs_file LEFT JOIN frs_dlstats_filetotal_agg ON frs_dlstats_filetotal_agg.file_id=frs_file.file_id
- WHERE release_id='412'
- AND frs_filetype.type_id=frs_file.type_id
- AND frs_processor.processor_id=frs_file.processor_id
- ORDER BY filename
-2004-05-07 12:10:36 LOG: duration: 0.002434 sec
-2004-05-07 12:10:36 LOG: query: SELECT frs_file.filename AS filename,
- frs_file.file_size AS file_size,
- frs_file.file_id AS file_id,
- frs_file.release_time AS release_time,
- frs_filetype.name AS type,
- frs_processor.name AS processor,
- frs_dlstats_filetotal_agg.downloads AS downloads
- FROM frs_filetype,frs_processor,
- frs_file LEFT JOIN frs_dlstats_filetotal_agg ON frs_dlstats_filetotal_agg.file_id=frs_file.file_id
- WHERE release_id='411'
- AND frs_filetype.type_id=frs_file.type_id
- AND frs_processor.processor_id=frs_file.processor_id
- ORDER BY filename
-2004-05-07 12:10:36 LOG: duration: 0.002421 sec
-2004-05-07 12:10:36 LOG: query: SELECT frs_file.filename AS filename,
- frs_file.file_size AS file_size,
- frs_file.file_id AS file_id,
- frs_file.release_time AS release_time,
- frs_filetype.name AS type,
- frs_processor.name AS processor,
- frs_dlstats_filetotal_agg.downloads AS downloads
- FROM frs_filetype,frs_processor,
- frs_file LEFT JOIN frs_dlstats_filetotal_agg ON frs_dlstats_filetotal_agg.file_id=frs_file.file_id
- WHERE release_id='410'
- AND frs_filetype.type_id=frs_file.type_id
- AND frs_processor.processor_id=frs_file.processor_id
- ORDER BY filename
-2004-05-07 12:10:36 LOG: duration: 0.002433 sec
-2004-05-07 12:10:37 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:10:37 LOG: duration: 0.000785 sec
-2004-05-07 12:10:37 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 12:10:37 LOG: duration: 0.001885 sec
-2004-05-07 12:10:37 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'12','167','IE','6.0','Win','1083946237','/frs/index.php','0');
-2004-05-07 12:10:37 LOG: duration: 0.004505 sec
-2004-05-07 12:10:37 LOG: query: select classname from supported_languages where language_code = 'en-us'
-2004-05-07 12:10:37 LOG: duration: 0.001479 sec
-2004-05-07 12:10:37 LOG: query: select classname from supported_languages where language_code = 'en'
-2004-05-07 12:10:37 LOG: duration: 0.000365 sec
-2004-05-07 12:10:37 LOG: query: SELECT *
- FROM frs_package
- WHERE group_id='167' AND status_id='1'
- ORDER BY name
-2004-05-07 12:10:37 LOG: duration: 0.001805 sec
-2004-05-07 12:10:37 LOG: query: SELECT * FROM groups WHERE group_id='167'
-2004-05-07 12:10:37 LOG: duration: 0.002068 sec
-2004-05-07 12:10:37 LOG: query: SELECT language_id FROM supported_languages WHERE classname='English'
-2004-05-07 12:10:37 LOG: duration: 0.000525 sec
-2004-05-07 12:10:37 LOG: query: SELECT language_code FROM supported_languages WHERE language_id='1'
-2004-05-07 12:10:37 LOG: duration: 0.000380 sec
-2004-05-07 12:10:37 LOG: query: SELECT * FROM frs_release
- WHERE package_id='178'
- AND status_id=1 ORDER BY release_date DESC, name ASC
-2004-05-07 12:10:37 LOG: duration: 0.001818 sec
-2004-05-07 12:10:37 LOG: query: SELECT frs_file.filename AS filename,
- frs_file.file_size AS file_size,
- frs_file.file_id AS file_id,
- frs_file.release_time AS release_time,
- frs_filetype.name AS type,
- frs_processor.name AS processor,
- frs_dlstats_filetotal_agg.downloads AS downloads
- FROM frs_filetype,frs_processor,
- frs_file LEFT JOIN frs_dlstats_filetotal_agg ON frs_dlstats_filetotal_agg.file_id=frs_file.file_id
- WHERE release_id='434'
- AND frs_filetype.type_id=frs_file.type_id
- AND frs_processor.processor_id=frs_file.processor_id
- ORDER BY filename
-2004-05-07 12:10:37 LOG: duration: 0.004349 sec
-2004-05-07 12:10:37 LOG: query: SELECT frs_file.filename AS filename,
- frs_file.file_size AS file_size,
- frs_file.file_id AS file_id,
- frs_file.release_time AS release_time,
- frs_filetype.name AS type,
- frs_processor.name AS processor,
- frs_dlstats_filetotal_agg.downloads AS downloads
- FROM frs_filetype,frs_processor,
- frs_file LEFT JOIN frs_dlstats_filetotal_agg ON frs_dlstats_filetotal_agg.file_id=frs_file.file_id
- WHERE release_id='414'
- AND frs_filetype.type_id=frs_file.type_id
- AND frs_processor.processor_id=frs_file.processor_id
- ORDER BY filename
-2004-05-07 12:10:37 LOG: duration: 0.002472 sec
-2004-05-07 12:10:37 LOG: query: SELECT frs_file.filename AS filename,
- frs_file.file_size AS file_size,
- frs_file.file_id AS file_id,
- frs_file.release_time AS release_time,
- frs_filetype.name AS type,
- frs_processor.name AS processor,
- frs_dlstats_filetotal_agg.downloads AS downloads
- FROM frs_filetype,frs_processor,
- frs_file LEFT JOIN frs_dlstats_filetotal_agg ON frs_dlstats_filetotal_agg.file_id=frs_file.file_id
- WHERE release_id='413'
- AND frs_filetype.type_id=frs_file.type_id
- AND frs_processor.processor_id=frs_file.processor_id
- ORDER BY filename
-2004-05-07 12:10:37 LOG: duration: 0.002433 sec
-2004-05-07 12:10:37 LOG: query: SELECT frs_file.filename AS filename,
- frs_file.file_size AS file_size,
- frs_file.file_id AS file_id,
- frs_file.release_time AS release_time,
- frs_filetype.name AS type,
- frs_processor.name AS processor,
- frs_dlstats_filetotal_agg.downloads AS downloads
- FROM frs_filetype,frs_processor,
- frs_file LEFT JOIN frs_dlstats_filetotal_agg ON frs_dlstats_filetotal_agg.file_id=frs_file.file_id
- WHERE release_id='412'
- AND frs_filetype.type_id=frs_file.type_id
- AND frs_processor.processor_id=frs_file.processor_id
- ORDER BY filename
-2004-05-07 12:10:37 LOG: duration: 0.002413 sec
-2004-05-07 12:10:37 LOG: query: SELECT frs_file.filename AS filename,
- frs_file.file_size AS file_size,
- frs_file.file_id AS file_id,
- frs_file.release_time AS release_time,
- frs_filetype.name AS type,
- frs_processor.name AS processor,
- frs_dlstats_filetotal_agg.downloads AS downloads
- FROM frs_filetype,frs_processor,
- frs_file LEFT JOIN frs_dlstats_filetotal_agg ON frs_dlstats_filetotal_agg.file_id=frs_file.file_id
- WHERE release_id='411'
- AND frs_filetype.type_id=frs_file.type_id
- AND frs_processor.processor_id=frs_file.processor_id
- ORDER BY filename
-2004-05-07 12:10:37 LOG: duration: 0.002447 sec
-2004-05-07 12:10:37 LOG: query: SELECT frs_file.filename AS filename,
- frs_file.file_size AS file_size,
- frs_file.file_id AS file_id,
- frs_file.release_time AS release_time,
- frs_filetype.name AS type,
- frs_processor.name AS processor,
- frs_dlstats_filetotal_agg.downloads AS downloads
- FROM frs_filetype,frs_processor,
- frs_file LEFT JOIN frs_dlstats_filetotal_agg ON frs_dlstats_filetotal_agg.file_id=frs_file.file_id
- WHERE release_id='410'
- AND frs_filetype.type_id=frs_file.type_id
- AND frs_processor.processor_id=frs_file.processor_id
- ORDER BY filename
-2004-05-07 12:10:37 LOG: duration: 0.002482 sec
-2004-05-07 12:10:41 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:10:41 LOG: duration: 0.000818 sec
-2004-05-07 12:10:41 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 12:10:41 LOG: duration: 0.001883 sec
-2004-05-07 12:10:41 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'12','0','OTHER','0','Mac','1083946241','/export/rss_sfnews.php','0');
-2004-05-07 12:10:41 LOG: duration: 0.004441 sec
-2004-05-07 12:10:41 LOG: query: SELECT forum_id,summary,post_date,details,group_id FROM news_bytes WHERE is_approved=1 order by post_date desc LIMIT 10 OFFSET 0
-2004-05-07 12:10:41 LOG: duration: 0.003840 sec
-2004-05-07 12:10:46 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:10:46 LOG: duration: 0.000809 sec
-2004-05-07 12:10:46 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 12:10:46 LOG: duration: 0.001891 sec
-2004-05-07 12:10:46 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'12','167','IE','6.0','Win','1083946246','/frs/index.php','0');
-2004-05-07 12:10:46 LOG: duration: 0.004132 sec
-2004-05-07 12:10:46 LOG: query: select classname from supported_languages where language_code = 'en-us'
-2004-05-07 12:10:46 LOG: duration: 0.001508 sec
-2004-05-07 12:10:46 LOG: query: select classname from supported_languages where language_code = 'en'
-2004-05-07 12:10:46 LOG: duration: 0.000387 sec
-2004-05-07 12:10:46 LOG: query: SELECT *
- FROM frs_package
- WHERE group_id='167' AND status_id='1'
- ORDER BY name
-2004-05-07 12:10:46 LOG: duration: 0.001773 sec
-2004-05-07 12:10:46 LOG: query: SELECT * FROM groups WHERE group_id='167'
-2004-05-07 12:10:46 LOG: duration: 0.002056 sec
-2004-05-07 12:10:46 LOG: query: SELECT language_id FROM supported_languages WHERE classname='English'
-2004-05-07 12:10:46 LOG: duration: 0.000518 sec
-2004-05-07 12:10:46 LOG: query: SELECT language_code FROM supported_languages WHERE language_id='1'
-2004-05-07 12:10:46 LOG: duration: 0.000349 sec
-2004-05-07 12:10:46 LOG: query: SELECT * FROM frs_release
- WHERE package_id='178'
- AND status_id=1 ORDER BY release_date DESC, name ASC
-2004-05-07 12:10:46 LOG: duration: 0.001825 sec
-2004-05-07 12:10:46 LOG: query: SELECT frs_file.filename AS filename,
- frs_file.file_size AS file_size,
- frs_file.file_id AS file_id,
- frs_file.release_time AS release_time,
- frs_filetype.name AS type,
- frs_processor.name AS processor,
- frs_dlstats_filetotal_agg.downloads AS downloads
- FROM frs_filetype,frs_processor,
- frs_file LEFT JOIN frs_dlstats_filetotal_agg ON frs_dlstats_filetotal_agg.file_id=frs_file.file_id
- WHERE release_id='434'
- AND frs_filetype.type_id=frs_file.type_id
- AND frs_processor.processor_id=frs_file.processor_id
- ORDER BY filename
-2004-05-07 12:10:46 LOG: duration: 0.004333 sec
-2004-05-07 12:10:46 LOG: query: SELECT frs_file.filename AS filename,
- frs_file.file_size AS file_size,
- frs_file.file_id AS file_id,
- frs_file.release_time AS release_time,
- frs_filetype.name AS type,
- frs_processor.name AS processor,
- frs_dlstats_filetotal_agg.downloads AS downloads
- FROM frs_filetype,frs_processor,
- frs_file LEFT JOIN frs_dlstats_filetotal_agg ON frs_dlstats_filetotal_agg.file_id=frs_file.file_id
- WHERE release_id='414'
- AND frs_filetype.type_id=frs_file.type_id
- AND frs_processor.processor_id=frs_file.processor_id
- ORDER BY filename
-2004-05-07 12:10:46 LOG: duration: 0.002482 sec
-2004-05-07 12:10:46 LOG: query: SELECT frs_file.filename AS filename,
- frs_file.file_size AS file_size,
- frs_file.file_id AS file_id,
- frs_file.release_time AS release_time,
- frs_filetype.name AS type,
- frs_processor.name AS processor,
- frs_dlstats_filetotal_agg.downloads AS downloads
- FROM frs_filetype,frs_processor,
- frs_file LEFT JOIN frs_dlstats_filetotal_agg ON frs_dlstats_filetotal_agg.file_id=frs_file.file_id
- WHERE release_id='413'
- AND frs_filetype.type_id=frs_file.type_id
- AND frs_processor.processor_id=frs_file.processor_id
- ORDER BY filename
-2004-05-07 12:10:46 LOG: duration: 0.002478 sec
-2004-05-07 12:10:46 LOG: query: SELECT frs_file.filename AS filename,
- frs_file.file_size AS file_size,
- frs_file.file_id AS file_id,
- frs_file.release_time AS release_time,
- frs_filetype.name AS type,
- frs_processor.name AS processor,
- frs_dlstats_filetotal_agg.downloads AS downloads
- FROM frs_filetype,frs_processor,
- frs_file LEFT JOIN frs_dlstats_filetotal_agg ON frs_dlstats_filetotal_agg.file_id=frs_file.file_id
- WHERE release_id='412'
- AND frs_filetype.type_id=frs_file.type_id
- AND frs_processor.processor_id=frs_file.processor_id
- ORDER BY filename
-2004-05-07 12:10:46 LOG: duration: 0.002459 sec
-2004-05-07 12:10:46 LOG: query: SELECT frs_file.filename AS filename,
- frs_file.file_size AS file_size,
- frs_file.file_id AS file_id,
- frs_file.release_time AS release_time,
- frs_filetype.name AS type,
- frs_processor.name AS processor,
- frs_dlstats_filetotal_agg.downloads AS downloads
- FROM frs_filetype,frs_processor,
- frs_file LEFT JOIN frs_dlstats_filetotal_agg ON frs_dlstats_filetotal_agg.file_id=frs_file.file_id
- WHERE release_id='411'
- AND frs_filetype.type_id=frs_file.type_id
- AND frs_processor.processor_id=frs_file.processor_id
- ORDER BY filename
-2004-05-07 12:10:46 LOG: duration: 0.002432 sec
-2004-05-07 12:10:46 LOG: query: SELECT frs_file.filename AS filename,
- frs_file.file_size AS file_size,
- frs_file.file_id AS file_id,
- frs_file.release_time AS release_time,
- frs_filetype.name AS type,
- frs_processor.name AS processor,
- frs_dlstats_filetotal_agg.downloads AS downloads
- FROM frs_filetype,frs_processor,
- frs_file LEFT JOIN frs_dlstats_filetotal_agg ON frs_dlstats_filetotal_agg.file_id=frs_file.file_id
- WHERE release_id='410'
- AND frs_filetype.type_id=frs_file.type_id
- AND frs_processor.processor_id=frs_file.processor_id
- ORDER BY filename
-2004-05-07 12:10:46 LOG: duration: 0.002412 sec
-2004-05-07 12:10:51 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:10:51 LOG: duration: 0.000809 sec
-2004-05-07 12:10:51 LOG: query: SELECT frs_file.filename,frs_file.file_id,groups.unix_group_name,groups.group_id
- FROM frs_package,frs_release,frs_file,groups
- WHERE frs_release.release_id=frs_file.release_id
- AND groups.group_id=frs_package.group_id
- AND frs_release.package_id=frs_package.package_id
- AND frs_file.file_id='610'
-2004-05-07 12:10:51 LOG: duration: 0.005537 sec
-2004-05-07 12:10:51 LOG: query: SELECT * FROM groups WHERE group_id='167'
-2004-05-07 12:10:51 LOG: duration: 0.001114 sec
-2004-05-07 12:11:03 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:11:03 LOG: duration: 0.000776 sec
-2004-05-07 12:11:03 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 12:11:03 LOG: duration: 0.001886 sec
-2004-05-07 12:11:03 LOG: query: SELECT
- u.*,sl.language_id, sl.name, sl.filename, sl.classname, sl.language_code, t.dirname, t.fullname
- FROM users u,
- supported_languages sl,
- themes t
- WHERE u.language=sl.language_id
- AND u.theme_id=t.theme_id
- AND u.user_id='102'
-
-2004-05-07 12:11:03 LOG: duration: 0.005630 sec
-2004-05-07 12:11:03 LOG: query: SELECT * FROM user_group WHERE user_id='102' AND group_id='1' AND admin_flags='A'
-2004-05-07 12:11:03 LOG: duration: 0.001944 sec
-2004-05-07 12:11:03 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'12','0','MOZILLA','5.0','Linux','1083946263','/export/index.php','0');
-2004-05-07 12:11:03 LOG: duration: 0.002654 sec
-2004-05-07 12:11:03 LOG: query: SELECT classname FROM supported_languages WHERE language_id='1'
-2004-05-07 12:11:03 LOG: duration: 0.000472 sec
-2004-05-07 12:11:03 LOG: query: SELECT language_id FROM supported_languages WHERE classname='English'
-2004-05-07 12:11:03 LOG: duration: 0.000614 sec
-2004-05-07 12:11:03 LOG: query: SELECT language_code FROM supported_languages WHERE language_id='1'
-2004-05-07 12:11:03 LOG: duration: 0.000389 sec
-2004-05-07 12:11:03 LOG: query: SELECT * FROM groups WHERE group_id='1'
-2004-05-07 12:11:03 LOG: duration: 0.002024 sec
-2004-05-07 12:11:03 LOG: query: SELECT * FROM user_group
- WHERE user_id='102'
- AND group_id='1'
-2004-05-07 12:11:03 LOG: duration: 0.000552 sec
-2004-05-07 12:11:05 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:11:05 LOG: duration: 0.000794 sec
-2004-05-07 12:11:05 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 12:11:05 LOG: duration: 0.001867 sec
-2004-05-07 12:11:05 LOG: query: SELECT
- u.*,sl.language_id, sl.name, sl.filename, sl.classname, sl.language_code, t.dirname, t.fullname
- FROM users u,
- supported_languages sl,
- themes t
- WHERE u.language=sl.language_id
- AND u.theme_id=t.theme_id
- AND u.user_id='102'
-
-2004-05-07 12:11:05 LOG: duration: 0.004729 sec
-2004-05-07 12:11:05 LOG: query: SELECT * FROM user_group WHERE user_id='102' AND group_id='1' AND admin_flags='A'
-2004-05-07 12:11:06 LOG: duration: 0.001628 sec
-2004-05-07 12:11:06 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'12','0','MOZILLA','5.0','Linux','1083946266','/export/rss_sfnewreleases.php','0');
-2004-05-07 12:11:06 LOG: duration: 0.004375 sec
-2004-05-07 12:11:06 LOG: query: SELECT classname FROM supported_languages WHERE language_id='1'
-2004-05-07 12:11:06 LOG: duration: 0.000450 sec
-2004-05-07 12:11:06 LOG: query: SELECT
- groups.group_id,
- groups.group_name,
- groups.unix_group_name,
- groups.type_id,
- news_bytes.forum_id,
- news_bytes.summary,
- news_bytes.post_date,
- news_bytes.details
- FROM
- news_bytes,
- groups
- WHERE
- news_bytes.group_id=groups.group_id
- AND groups.status='A'
- AND groups.is_public = 1
- ORDER BY
- post_date
- DESC
-2004-05-07 12:11:06 LOG: duration: 0.012615 sec
-2004-05-07 12:11:06 LOG: query: begin; select getdatabaseencoding(); commit
-2004-05-07 12:11:06 LOG: duration: 0.000793 sec
-2004-05-07 12:11:06 LOG: query: SELECT plugin_id, plugin_name FROM plugins
-2004-05-07 12:11:06 LOG: duration: 0.001886 sec
-2004-05-07 12:11:06 LOG: query: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (20040507,'12','0','OTHER','0','Other','1083946266','/index.php','0');
-2004-05-07 12:11:06 LOG: duration: 0.003889 sec
-2004-05-07 12:11:06 LOG: query: SELECT language_id FROM supported_languages WHERE classname='English'
-2004-05-07 12:11:06 LOG: duration: 0.001505 sec
-2004-05-07 12:11:06 LOG: query: SELECT language_code FROM supported_languages WHERE language_id='1'
-2004-05-07 12:11:06 LOG: duration: 0.000520 sec
-2004-05-07 12:11:06 LOG: query: SELECT groups.group_name,groups.unix_group_name,
- groups.type_id,users.user_name,users.realname,
- news_bytes.forum_id,news_bytes.summary,news_bytes.post_date,news_bytes.details
- FROM users,news_bytes,groups
- WHERE news_bytes.is_approved=1
- AND users.user_id=news_bytes.submitted_by
- AND news_bytes.group_id=groups.group_id
- ORDER BY post_date DESC LIMIT 10 OFFSET 0
-2004-05-07 12:11:06 LOG: duration: 0.011179 sec
-2004-05-07 12:11:06 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='1050'
-2004-05-07 12:11:06 LOG: duration: 0.002933 sec
-2004-05-07 12:11:06 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='1044'
-2004-05-07 12:11:06 LOG: duration: 0.000658 sec
-2004-05-07 12:11:06 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='1037'
-2004-05-07 12:11:06 LOG: duration: 0.000671 sec
-2004-05-07 12:11:06 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='1030'
-2004-05-07 12:11:06 LOG: duration: 0.000644 sec
-2004-05-07 12:11:06 LOG: query: SELECT total FROM forum_group_list_vw WHERE group_forum_id='1027'
-2004-05-07 12:11:06 LOG: duration: 0.000688 sec
-2004-05-07 12:11:06 LOG: query: SELECT count(*) AS count FROM groups WHERE status='A' AND is_public=1
-2004-05-07 12:11:06 LOG: duration: 0.002325 sec
-2004-05-07 12:11:06 LOG: query: SELECT count(*) AS count FROM users WHERE status='A' and user_id != 100
-2004-05-07 12:11:06 LOG: duration: 0.074923 sec
-2004-05-07 12:11:06 LOG: query:
- SELECT groups.group_id,
- groups.group_name,
- groups.unix_group_name,
- frs_dlstats_grouptotal_vw.downloads
- FROM frs_dlstats_grouptotal_vw,groups
- WHERE
- frs_dlstats_grouptotal_vw.group_id=groups.group_id AND groups.is_public='1' and groups.status='A'
- ORDER BY downloads DESC
- LIMIT 10 OFFSET 0
-2004-05-07 12:11:06 LOG: duration: 0.017451 sec
-2004-05-07 12:11:06 LOG: query: SELECT groups.group_name,groups.unix_group_name,groups.group_id,project_weekly_metric.ranking,project_weekly_metric.percentile FROM groups,project_weekly_metric WHERE groups.group_id=project_weekly_metric.group_id AND groups.is_public=1 AND groups.type_id=1 AND groups.status != 'D' ORDER BY ranking ASC LIMIT 10 OFFSET 0
-2004-05-07 12:11:06 LOG: duration: 0.004165 sec
-2004-05-07 12:11:06 LOG: query: SELECT group_id,unix_group_name,group_name,register_time FROM groups WHERE is_public=1 AND status='A' AND type_id=1 AND register_time > 0 ORDER BY register_time DESC LIMIT 10 OFFSET 0
-2004-05-07 12:11:06 LOG: duration: 0.002575 sec
+ ', '2010-10-10 15:00:02.159884', 0, '2010-10-10 16:00:00.000000', 0, NULL, NULL) RETURNING "id"
+2010-10-10 15:00:02 GMT [38747]: [1670-1] LOCATION: exec_simple_query, postgres.c:1081
+2010-10-10 15:00:02 GMT [38747]: [1671-1] LOG: 00000: duration: 0.065 ms statement: COMMIT
+2010-10-10 15:00:02 GMT [38747]: [1672-1] LOCATION: exec_simple_query, postgres.c:1081
+2010-10-10 15:00:02 GMT [38747]: [1673-1] LOG: 00000: duration: 0.020 ms statement: BEGIN
+2010-10-10 15:00:02 GMT [38747]: [1674-1] LOCATION: exec_simple_query, postgres.c:1081
+2010-10-10 15:00:02 GMT [38747]: [1675-1] LOG: 00000: duration: 0.157 ms statement: DELETE FROM "delayed_jobs" WHERE "id" = 123456
+2010-10-10 15:00:02 GMT [38747]: [1676-1] LOCATION: exec_simple_query, postgres.c:1081
+2010-10-10 15:00:02 GMT [38747]: [1677-1] LOG: 00000: duration: 0.050 ms statement: COMMIT
\ No newline at end of file