(pdo): SELECT il.lang_code AS hash_key, il.* FROM i18n_languages il ORDER BY il.lang_code
### Query: 1 NORMALStart time: 7.0E-5### Query run time: 0.00109
(pdo): select lower(rdb$relation_name) from rdb$relations where rdb$relation_name not like 'RDB$%' and rdb$relation_name not like 'MON$%' and rdb$relation_name not like 'SEC$%' (pdo): select lower(rdb$relation_name) from rdb$relations where rdb$relation_name not like 'RDB$%' and rdb$relation_name not like 'MON$%' and rdb$relation_name not like 'SEC$%' (pdo): select lower(rdb$relation_name) from rdb$relations where rdb$relation_name not like 'RDB$%' and rdb$relation_name not like 'MON$%' and rdb$relation_name not like 'SEC$%' (pdo): SELECT up.perm_name AS hash_key, up.perm_name, up.perm_desc, up.perm_level, up.package FROM users_permissions up INNER JOIN users_role_permissions urp ON ( urp.perm_name=up.perm_name ) INNER JOIN users_roles ur ON ( ur.role_id=urp.role_id ) LEFT OUTER JOIN users_roles_map urm ON ( urm.role_id=urp.role_id AND urm.user_id = ? ) WHERE ur.role_id= -1 OR urm.role_id=ur.role_id [ (0=>null) ]
### Query: 2 NORMALStart time: 0.00408### Query run time: 0.00108
(pdo): select lower(rdb$relation_name) from rdb$relations where rdb$relation_name not like 'RDB$%' and rdb$relation_name not like 'MON$%' and rdb$relation_name not like 'SEC$%' (pdo): SELECT page_id, wp.content_id, lcds.data AS summary, lc.last_modified, lc.title FROM wiki_pages wp INNER JOIN liberty_content lc ON (lc.content_id=wp.content_id) LEFT OUTER JOIN liberty_content_data lcds ON (lc.content_id = lcds.content_id AND lcds.data_type='summary') WHERE UPPER(lc.title) = ? [ (0=>'WELCOME') ]
### Query: 3 NORMALStart time: 0.00605### Query run time: 0.00114
(pdo): SELECT page_id, wp.content_id, lcds.data AS summary, lc.last_modified, lc.title FROM wiki_pages wp INNER JOIN liberty_content lc ON (lc.content_id=wp.content_id) LEFT OUTER JOIN liberty_content_data lcds ON (lc.content_id = lcds.content_id AND lcds.data_type='summary') WHERE UPPER(lc.title) = ? [ (0=>'MEETING MANAGEMENT SYSTEM') ]
### Query: 4 NORMALStart time: 0.00721### Query run time: 0.00049
ADOConnection.CacheExecute(3600, SELECT FIRST 1 content_type_guid FROM liberty_content WHERE content_id=?, Array[1]) % line 286, file: adodb-pdo_firebird.inc.php
ADODB_pdo_firebird.selectLimit(SELECT FIRST 1 content_type_guid FROM liberty_content WHERE content_id=?, 1, -1, Array[1], 3600) % line 282, file: adodb-pdo.inc.php
ADODB_pdo.SelectLimit(SELECT content_type_guid FROM liberty_content WHERE content_id=?, 1, -1, Array[1], 3600) % line 2459, file: adodb.inc.php
ADOConnection.CacheSelectLimit(3600, SELECT content_type_guid FROM liberty_content WHERE content_id=?, 1, -1, Array[1]) % line 260, file: BitDbAdodb.php
Bitweaver\BitDbAdodb.query(SELECT content_type_guid FROM liberty_content WHERE content_id=?, Array[1], 1, -1, 3600) % line 415, file: BitDbAdodb.php
Bitweaver\BitDbAdodb.getOne(SELECT `content_type_guid` FROM `liberty_content` WHERE `content_id`=?, Array[1], null, null, 3600) % line 93, file: LibertyBase.php
Bitweaver\Liberty\LibertyBase.getLibertyObject(10) % line 63, file: lookup_page_inc.php
include(/srv/website/_bw5/wiki/includes/lookup_page_inc.php) % line 47, file: index.php
/tmp/ae/adodb_ae89142ced04e7ff83451ef513fae381.cache reloaded, ttl=2349 [ SELECT FIRST 1 content_type_guid FROM liberty_content WHERE content_id=? ]
### Query: 5 NORMALStart time: 0.00772### Query run time: 9.0E-5
(pdo): select lower(rdb$relation_name) from rdb$relations where rdb$relation_name not like 'RDB$%' and rdb$relation_name not like 'MON$%' and rdb$relation_name not like 'SEC$%' (pdo): select lower(rdb$relation_name) from rdb$relations where rdb$relation_name not like 'RDB$%' and rdb$relation_name not like 'MON$%' and rdb$relation_name not like 'SEC$%' (pdo): SELECT ur.role_id, ur.role_name, ur.user_id as role_owner_user_id FROM users_roles_map urm INNER JOIN users_roles ur ON (ur.role_id=urm.role_id) WHERE urm.user_id=? OR urm.role_id=-1 [ (0=>'-1') ]
### Query: 6 NORMALStart time: 0.00914### Query run time: 0.0004
(pdo): SELECT wp.*, lc.*, lcds.data AS summary, uue.login AS modifier_user, uue.real_name AS modifier_real_name, uuc.login AS creator_user, uuc.real_name AS creator_real_name FROM wiki_pages wp INNER JOIN liberty_content lc ON (lc.content_id = wp.content_id) LEFT JOIN liberty_content_role_map lcrm ON ( lc.content_id=lcrm.content_id ) LEFT OUTER JOIN users_roles_map purm ON ( purm.role_id=lcrm.role_id ) LEFT OUTER JOIN liberty_content_data lcds ON (lc.content_id = lcds.content_id AND lcds.data_type='summary') LEFT JOIN users_users uue ON (uue.user_id = lc.modifier_user_id) LEFT JOIN users_users uuc ON (uuc.user_id = lc.user_id) WHERE wp.content_id=? AND (lcrm.content_id IS null OR lcrm.role_id IN(? ) OR purm.user_id=?) [ (0=>'10') (1=>'-1') (2=>'-1') ]
### Query: 7 NORMALStart time: 0.00955### Query run time: 0.00098
(pdo): SELECT pref_name, pref_value FROM liberty_content_prefs WHERE content_id=? [ (0=>'10') ]
### Query: 8 NORMALStart time: 0.01055### Query run time: 0.00035
(pdo): SELECT page_id, lc.content_id, lc.last_modified, lc.title, lcds.data AS summary FROM liberty_content_links lcl INNER JOIN liberty_content lc ON( lcl.to_content_id=lc.content_id ) INNER JOIN wiki_pages wp ON( wp.content_id=lc.content_id ) LEFT OUTER JOIN liberty_content_data lcds ON (lc.content_id = lcds.content_id AND lcds.data_type='summary') WHERE lcl.from_content_id=? ORDER BY lc.title [ (0=>'10') ]
### Query: 9 NORMALStart time: 0.01096### Query run time: 0.00053
(pdo): SELECT ls.*, lc.title, tcr.title AS root_title FROM liberty_content lc, liberty_structures ls INNER JOIN liberty_structures tsr ON( tsr.structure_id=ls.root_structure_id ) INNER JOIN liberty_content tcr ON( tsr.content_id=tcr.content_id ) WHERE lc.content_id=ls.content_id AND ls.content_id=? [ (0=>'10') ]
### Query: 10 NORMALStart time: 0.01154### Query run time: 0.00054
(pdo): SELECT lc.content_id, lcrm.role_id as is_protected FROM liberty_content lc LEFT JOIN liberty_content_role_map lcrm ON ( lc.content_id=lcrm.content_id ) LEFT OUTER JOIN users_roles_map urm ON ( urm.user_id=0 ) AND ( urm.role_id=lcrm.role_id ) WHERE lc.content_id = ? [ (0=>'10') ]
### Query: 11 NORMALStart time: 0.01212### Query run time: 0.00034
(pdo): SELECT urp.perm_name as hash_key, 1 as role_perm, urp.perm_name, urp.perm_value, urp.role_id FROM users_roles_map urm LEFT JOIN users_role_permissions urp ON(urm.role_id=urp.role_id) LEFT JOIN liberty_content_permissions lcp ON(lcp.role_id=urm.role_id AND lcp.content_id=? AND urp.perm_name=lcp.perm_name) WHERE (urm.user_id=? OR urm.user_id=?) AND lcp.perm_name IS null [ (0=>'10') (1=>'0') (2=>'-1') ]
### Query: 12 NORMALStart time: 0.01247### Query run time: 0.00054
(pdo): SELECT lcp.perm_name AS hash_key, lcp.* FROM liberty_content_permissions lcp INNER JOIN users_roles_map urm ON(lcp.role_id=urm.role_id) LEFT JOIN users_role_permissions urp ON(urm.role_id=urp.role_id AND urp.role_id!=lcp.role_id AND urp.perm_name=lcp.perm_name) WHERE lcp.content_id=? AND (urm.user_id=? OR urm.user_id=?) AND lcp.is_revoked IS null [ (0=>'10') (1=>'0') (2=>'-1') ]
### Query: 13 NORMALStart time: 0.01301### Query run time: 0.00042
(pdo): SELECT lc.content_id, lcrm.role_id as is_protected FROM liberty_content lc LEFT JOIN liberty_content_role_map lcrm ON ( lc.content_id=lcrm.content_id ) LEFT OUTER JOIN users_roles_map urm ON ( urm.user_id=0 ) AND ( urm.role_id=lcrm.role_id ) WHERE lc.content_id = ? [ (0=>'10') ]
### Query: 14 NORMALStart time: 0.01345### Query run time: 0.00019
(pdo): SELECT lc.content_id, lcrm.role_id as is_protected FROM liberty_content lc LEFT JOIN liberty_content_role_map lcrm ON ( lc.content_id=lcrm.content_id ) LEFT OUTER JOIN users_roles_map urm ON ( urm.user_id=0 ) AND ( urm.role_id=lcrm.role_id ) WHERE lc.content_id = ? [ (0=>'10') ]
### Query: 15 NORMALStart time: 0.01365### Query run time: 0.00018
(pdo): SELECT lc.content_id, lcrm.role_id as is_protected FROM liberty_content lc LEFT JOIN liberty_content_role_map lcrm ON ( lc.content_id=lcrm.content_id ) LEFT OUTER JOIN users_roles_map urm ON ( urm.user_id=0 ) AND ( urm.role_id=lcrm.role_id ) WHERE lc.content_id = ? [ (0=>'10') ]
### Query: 16 NORMALStart time: 0.01385### Query run time: 0.00018
(pdo): SELECT lc.content_id, lcrm.role_id as is_protected FROM liberty_content lc LEFT JOIN liberty_content_role_map lcrm ON ( lc.content_id=lcrm.content_id ) LEFT OUTER JOIN users_roles_map urm ON ( urm.user_id=0 ) AND ( urm.role_id=lcrm.role_id ) WHERE lc.content_id = ? [ (0=>'10') ]
### Query: 17 NORMALStart time: 0.01405### Query run time: 0.0002
(pdo): SELECT content_id, title, to_title, url FROM ( SELECT lc.content_id, lc.title, lcl.to_title, 'wiki/' || lc.title AS url FROM liberty_content_links lcl INNER JOIN liberty_content lc ON (lcl.from_content_id = lc.content_id) LEFT JOIN wiki_pages wp ON (lcl.from_content_id = wp.content_id) WHERE lc.content_type_guid = 'bitpage' UNION ALL SELECT lc.content_id, COALESCE( lc.title, CAST ( DATEADD( SECOND, bl.publish_date, timestamp '1/1/1970 00:00:00' ) AS DATE ) ) AS TITLE, lcb.to_title, 'blogs/post/' || BL.post_id AS url FROM liberty_content_links lcb INNER JOIN liberty_content lc ON (lcb.from_content_id = lc.content_id) LEFT JOIN blog_posts bl ON (lcb.from_content_id = bl.content_id) WHERE lc.content_type_guid = 'bitblogpost' ) WHERE to_title = ? ORDER BY title [ (0=>'Meeting Management System') ]
### Query: 18 NORMALStart time: 0.01425### Query run time: 0.0007
(pdo): SELECT UPPER(alias_title) FROM liberty_aliases lal INNER JOIN liberty_content lc ON(lal.content_id=lc.content_id) WHERE lal.content_id=? [ (0=>'10') ]
### Query: 19 NORMALStart time: 0.01497### Query run time: 0.00039
(pdo): SELECT tl.* FROM themes_layouts tl WHERE tl.layout=? ORDER BY pos ASC [ (0=>'wiki') ]
### Query: 20 NORMALStart time: 0.01542### Query run time: 0.0004
(pdo): SELECT tl.* FROM themes_layouts tl WHERE tl.layout=? ORDER BY pos ASC [ (0=>'kernel') ]
### Query: 21 NORMALStart time: 0.01583### Query run time: 0.00022
Meeting Management System - LSCES Main Site(pdo): select lower(rdb$relation_name) from rdb$relations where rdb$relation_name not like 'RDB$%' and rdb$relation_name not like 'MON$%' and rdb$relation_name not like 'SEC$%' (pdo): select lower(rdb$relation_name) from rdb$relations where rdb$relation_name not like 'RDB$%' and rdb$relation_name not like 'MON$%' and rdb$relation_name not like 'SEC$%' (pdo): SELECT uu.*, lf_ava.file_name AS avatar_file_name, la_ava.attachment_id AS avatar_attachment_id, lf_ava.mime_type AS avatar_mime_type, lf_por.file_name AS portrait_file_name, ta_por.attachment_id AS portrait_attachment_id, lf_por.mime_type AS portrait_mime_type, lf_logo.file_name AS logo_file_name, ta_logo.attachment_id AS logo_attachment_id, lf_logo.mime_type AS logo_mime_type , uu.user_id AS uu_user_id FROM users_users uu LEFT OUTER JOIN liberty_attachments la_ava ON ( uu.avatar_attachment_id=la_ava.attachment_id ) LEFT OUTER JOIN liberty_files lf_ava ON ( lf_ava.file_id=la_ava.foreign_id ) LEFT OUTER JOIN liberty_attachments ta_por ON ( uu.portrait_attachment_id=ta_por.attachment_id ) LEFT OUTER JOIN liberty_files lf_por ON ( lf_por.file_id=ta_por.foreign_id ) LEFT OUTER JOIN liberty_attachments ta_logo ON ( uu.logo_attachment_id=ta_logo.attachment_id ) LEFT OUTER JOIN liberty_files lf_logo ON ( lf_logo.file_id=ta_logo.foreign_id ) WHERE uu.content_id=? [ (0=>'1') ]
### Query: 22 NORMALStart time: 0.01813### Query run time: 0.00075
(pdo): SELECT pref_name, pref_value FROM liberty_content_prefs WHERE content_id=? [ (0=>'1') ]
### Query: 23 NORMALStart time: 0.0189### Query run time: 0.00016
(pdo): SELECT lap.attachment_id, lap.pref_name, lap.pref_value FROM liberty_attachment_prefs lap INNER JOIN liberty_attachments la ON (la.attachment_id = lap.attachment_id) WHERE la.content_id = ? [ (0=>'1') ]
### Query: 24 NORMALStart time: 0.01908### Query run time: 0.00037
(pdo): SELECT * FROM liberty_attachments la WHERE la.content_id=? ORDER BY la.pos ASC, la.attachment_id ASC [ (0=>'1') ]
### Query: 25 NORMALStart time: 0.01946### Query run time: 0.00029
(pdo): SELECT urp.perm_name as hash_key, 1 as role_perm, urp.perm_name, urp.perm_value, urp.role_id FROM users_roles_map urm LEFT JOIN users_role_permissions urp ON(urm.role_id=urp.role_id) LEFT JOIN liberty_content_permissions lcp ON(lcp.role_id=urm.role_id AND lcp.content_id=? AND urp.perm_name=lcp.perm_name) WHERE (urm.user_id=? OR urm.user_id=?) AND lcp.perm_name IS null [ (0=>'1') (1=>'0') (2=>'-1') ]
### Query: 26 NORMALStart time: 0.0198### Query run time: 0.00027
(pdo): SELECT lcp.perm_name AS hash_key, lcp.* FROM liberty_content_permissions lcp INNER JOIN users_roles_map urm ON(lcp.role_id=urm.role_id) LEFT JOIN users_role_permissions urp ON(urm.role_id=urp.role_id AND urp.role_id!=lcp.role_id AND urp.perm_name=lcp.perm_name) WHERE lcp.content_id=? AND (urm.user_id=? OR urm.user_id=?) AND lcp.is_revoked IS null [ (0=>'1') (1=>'0') (2=>'-1') ]
### Query: 27 NORMALStart time: 0.02007### Query run time: 0.0002
(pdo): select lower(rdb$relation_name) from rdb$relations where rdb$relation_name not like 'RDB$%' and rdb$relation_name not like 'MON$%' and rdb$relation_name not like 'SEC$%' (pdo): select lower(rdb$relation_name) from rdb$relations where rdb$relation_name not like 'RDB$%' and rdb$relation_name not like 'MON$%' and rdb$relation_name not like 'SEC$%' (pdo): SELECT ur.role_id, ur.role_name, ur.user_id as role_owner_user_id FROM users_roles_map urm INNER JOIN users_roles ur ON (ur.role_id=urm.role_id) WHERE urm.user_id=? OR urm.role_id=-1 [ (0=>'-1') ]
### Query: 28 NORMALStart time: 0.02157### Query run time: 0.00021
(pdo): SELECT wp.*, lc.*, lcds.data AS summary, uue.login AS modifier_user, uue.real_name AS modifier_real_name, uuc.login AS creator_user, uuc.real_name AS creator_real_name FROM wiki_pages wp INNER JOIN liberty_content lc ON (lc.content_id = wp.content_id) LEFT JOIN liberty_content_role_map lcrm ON ( lc.content_id=lcrm.content_id ) LEFT OUTER JOIN users_roles_map purm ON ( purm.role_id=lcrm.role_id ) LEFT OUTER JOIN liberty_content_data lcds ON (lc.content_id = lcds.content_id AND lcds.data_type='summary') LEFT JOIN users_users uue ON (uue.user_id = lc.modifier_user_id) LEFT JOIN users_users uuc ON (uuc.user_id = lc.user_id) WHERE wp.content_id=? AND (lcrm.content_id IS null OR lcrm.role_id IN(? ) OR purm.user_id=?) [ (0=>'1') (1=>'-1') (2=>'-1') ]
### Query: 29 NORMALStart time: 0.02179### Query run time: 0.00023
(pdo): select lower(rdb$relation_name) from rdb$relations where rdb$relation_name not like 'RDB$%' and rdb$relation_name not like 'MON$%' and rdb$relation_name not like 'SEC$%' (pdo): select lower(rdb$relation_name) from rdb$relations where rdb$relation_name not like 'RDB$%' and rdb$relation_name not like 'MON$%' and rdb$relation_name not like 'SEC$%' (pdo): SELECT ur.role_id, ur.role_name, ur.user_id as role_owner_user_id FROM users_roles_map urm INNER JOIN users_roles ur ON (ur.role_id=urm.role_id) WHERE urm.user_id=? OR urm.role_id=-1 [ (0=>'-1') ]
### Query: 30 NORMALStart time: 0.02334### Query run time: 0.00021
(pdo): SELECT fi.*, lc.* , uue.login AS modifier_user, uue.real_name AS modifier_real_name , uuc.login AS creator_user, uuc.real_name AS creator_real_name, ufm.favorite_content_id AS is_favorite , lch.hits FROM fisheye_image fi INNER JOIN liberty_content lc ON (lc.content_id = fi.content_id) LEFT JOIN users_users uue ON (uue.user_id = lc.modifier_user_id) LEFT JOIN users_users uuc ON (uuc.user_id = lc.user_id) LEFT JOIN users_favorites_map ufm ON (ufm.favorite_content_id=lc.content_id AND ufm.user_id=uuc.user_id) LEFT OUTER JOIN liberty_content_hits lch ON ( lch.content_id = lc.content_id ) LEFT JOIN liberty_content_role_map lcrm ON ( lc.content_id=lcrm.content_id ) LEFT OUTER JOIN users_roles_map purm ON ( purm.role_id=lcrm.role_id ) WHERE fi.content_id = ? AND (lcrm.content_id IS null OR lcrm.role_id IN(? ) OR purm.user_id=?) [ (0=>'1') (1=>'-1') (2=>'-1') ]
### Query: 31 NORMALStart time: 0.02356### Query run time: 0.00083
(pdo): SELECT urp.perm_name as hash_key, 1 as role_perm, urp.perm_name, urp.perm_value, urp.role_id FROM users_roles_map urm LEFT JOIN users_role_permissions urp ON(urm.role_id=urp.role_id) LEFT JOIN liberty_content_permissions lcp ON(lcp.role_id=urm.role_id AND lcp.content_id=? AND urp.perm_name=lcp.perm_name) WHERE (urm.user_id=? OR urm.user_id=?) AND lcp.perm_name IS null [ (0=>'1') (1=>'0') (2=>'-1') ]
### Query: 32 NORMALStart time: 0.02442### Query run time: 0.00027
(pdo): SELECT lcp.perm_name AS hash_key, lcp.* FROM liberty_content_permissions lcp INNER JOIN users_roles_map urm ON(lcp.role_id=urm.role_id) LEFT JOIN users_role_permissions urp ON(urm.role_id=urp.role_id AND urp.role_id!=lcp.role_id AND urp.perm_name=lcp.perm_name) WHERE lcp.content_id=? AND (urm.user_id=? OR urm.user_id=?) AND lcp.is_revoked IS null [ (0=>'1') (1=>'0') (2=>'-1') ]
### Query: 33 NORMALStart time: 0.02469### Query run time: 0.00019
(pdo): select lower(rdb$relation_name) from rdb$relations where rdb$relation_name not like 'RDB$%' and rdb$relation_name not like 'MON$%' and rdb$relation_name not like 'SEC$%' (pdo): select lower(rdb$relation_name) from rdb$relations where rdb$relation_name not like 'RDB$%' and rdb$relation_name not like 'MON$%' and rdb$relation_name not like 'SEC$%' (pdo): SELECT ur.role_id, ur.role_name, ur.user_id as role_owner_user_id FROM users_roles_map urm INNER JOIN users_roles ur ON (ur.role_id=urm.role_id) WHERE urm.user_id=? OR urm.role_id=-1 [ (0=>'-1') ]
### Query: 34 NORMALStart time: 0.02621### Query run time: 0.00021
(pdo): SELECT fg.*, lc.* , uue.login AS modifier_user, uue.real_name AS modifier_real_name , uuc.login AS creator_user, uuc.real_name AS creator_real_name FROM fisheye_gallery fg INNER JOIN liberty_content lc ON (fg.content_id = lc.content_id) LEFT JOIN liberty_content_role_map lcrm ON ( lc.content_id=lcrm.content_id ) LEFT OUTER JOIN users_roles_map purm ON ( purm.role_id=lcrm.role_id ) LEFT JOIN users_users uue ON (uue.user_id = lc.modifier_user_id) LEFT JOIN users_users uuc ON (uuc.user_id = lc.user_id) WHERE fg.content_id = ? AND (lcrm.content_id IS null OR lcrm.role_id IN(? ) OR purm.user_id=?) [ (0=>'1') (1=>'-1') (2=>'-1') ]
### Query: 35 NORMALStart time: 0.02642### Query run time: 0.00062
(pdo): SELECT urp.perm_name as hash_key, 1 as role_perm, urp.perm_name, urp.perm_value, urp.role_id FROM users_roles_map urm LEFT JOIN users_role_permissions urp ON(urm.role_id=urp.role_id) LEFT JOIN liberty_content_permissions lcp ON(lcp.role_id=urm.role_id AND lcp.content_id=? AND urp.perm_name=lcp.perm_name) WHERE (urm.user_id=? OR urm.user_id=?) AND lcp.perm_name IS null [ (0=>'1') (1=>'0') (2=>'-1') ]
### Query: 36 NORMALStart time: 0.02707### Query run time: 0.00027
(pdo): SELECT lcp.perm_name AS hash_key, lcp.* FROM liberty_content_permissions lcp INNER JOIN users_roles_map urm ON(lcp.role_id=urm.role_id) LEFT JOIN users_role_permissions urp ON(urm.role_id=urp.role_id AND urp.role_id!=lcp.role_id AND urp.perm_name=lcp.perm_name) WHERE lcp.content_id=? AND (urm.user_id=? OR urm.user_id=?) AND lcp.is_revoked IS null [ (0=>'1') (1=>'0') (2=>'-1') ]
### Query: 37 NORMALStart time: 0.02734### Query run time: 0.00019
(pdo): select lower(rdb$relation_name) from rdb$relations where rdb$relation_name not like 'RDB$%' and rdb$relation_name not like 'MON$%' and rdb$relation_name not like 'SEC$%' (pdo): select lower(rdb$relation_name) from rdb$relations where rdb$relation_name not like 'RDB$%' and rdb$relation_name not like 'MON$%' and rdb$relation_name not like 'SEC$%' (pdo): SELECT ur.role_id, ur.role_name, ur.user_id as role_owner_user_id FROM users_roles_map urm INNER JOIN users_roles ur ON (ur.role_id=urm.role_id) WHERE urm.user_id=? OR urm.role_id=-1 [ (0=>'-1') ]
### Query: 38 NORMALStart time: 0.02885### Query run time: 0.00021
(pdo): SELECT a.*, lc.*, atype.*, atopic.*, lch.hits, uue.login AS modifier_user, uue.real_name AS modifier_real_name, uuc.login AS creator_user, uuc.real_name AS creator_real_name , la.attachment_id AS primary_attachment_id, lf.file_name AS image_attachment_path FROM articles a LEFT OUTER JOIN article_types atype ON( atype.article_type_id = a.article_type_id ) LEFT OUTER JOIN article_topics atopic ON( atopic.topic_id = a.topic_id ) INNER JOIN liberty_content lc ON( lc.content_id = a.content_id ) LEFT OUTER JOIN liberty_content_hits lch ON( lch.content_id = lc.content_id ) LEFT OUTER JOIN users_users uue ON( uue.user_id = lc.modifier_user_id ) LEFT OUTER JOIN users_users uuc ON( uuc.user_id = lc.user_id ) LEFT OUTER JOIN liberty_attachments la ON( la.content_id = lc.content_id AND la.is_primary = 'y' ) LEFT OUTER JOIN liberty_files lf ON( lf.file_id = la.foreign_id ) LEFT JOIN liberty_content_role_map lcrm ON ( lc.content_id=lcrm.content_id ) LEFT OUTER JOIN users_roles_map purm ON ( purm.role_id=lcrm.role_id ) WHERE a.content_id=? AND (lcrm.content_id IS null OR lcrm.role_id IN(? ) OR purm.user_id=?) [ (0=>'1') (1=>'-1') (2=>'-1') ]
### Query: 39 NORMALStart time: 0.02907### Query run time: 0.00103
(pdo): select lower(rdb$relation_name) from rdb$relations where rdb$relation_name not like 'RDB$%' and rdb$relation_name not like 'MON$%' and rdb$relation_name not like 'SEC$%' (pdo): select lower(rdb$relation_name) from rdb$relations where rdb$relation_name not like 'RDB$%' and rdb$relation_name not like 'MON$%' and rdb$relation_name not like 'SEC$%' (pdo): SELECT ur.role_id, ur.role_name, ur.user_id as role_owner_user_id FROM users_roles_map urm INNER JOIN users_roles ur ON (ur.role_id=urm.role_id) WHERE urm.user_id=? OR urm.role_id=-1 [ (0=>'-1') ]
### Query: 40 NORMALStart time: 0.03143### Query run time: 0.00021
(pdo): SELECT lc.content_id, lcrm.role_id as is_protected FROM liberty_content lc LEFT JOIN liberty_content_role_map lcrm ON ( lc.content_id=lcrm.content_id ) LEFT OUTER JOIN users_roles_map urm ON ( urm.user_id=0 ) AND ( urm.role_id=lcrm.role_id ) WHERE lc.content_id = ? [ (0=>'1') ]
### Query: 41 NORMALStart time: 0.03165### Query run time: 0.00019
(pdo): SELECT lcom.*, lc.*, uu.email, uu.real_name, uu.login FROM liberty_comments lcom LEFT OUTER JOIN liberty_content lc ON (lcom.content_id = lc.content_id) LEFT OUTER JOIN users_users uu ON (lc.user_id = uu.user_id) LEFT JOIN liberty_content_role_map lcrm ON ( lc.content_id=lcrm.content_id ) LEFT OUTER JOIN users_roles_map purm ON ( purm.role_id=lcrm.role_id ) WHERE lc.content_id = ? AND (lcrm.content_id IS null OR lcrm.role_id IN(? ) OR purm.user_id=?) [ (0=>'1') (1=>'-1') (2=>'-1') ]
### Query: 42 NORMALStart time: 0.03185### Query run time: 0.00059
(pdo): SELECT lap.attachment_id, lap.pref_name, lap.pref_value FROM liberty_attachment_prefs lap INNER JOIN liberty_attachments la ON (la.attachment_id = lap.attachment_id) WHERE la.content_id = ? [ (0=>'1') ]
### Query: 43 NORMALStart time: 0.03246### Query run time: 0.00018
(pdo): SELECT * FROM liberty_attachments la WHERE la.content_id=? ORDER BY la.pos ASC, la.attachment_id ASC [ (0=>'1') ]
### Query: 44 NORMALStart time: 0.03265### Query run time: 0.00018
(pdo): SELECT urp.perm_name as hash_key, 1 as role_perm, urp.perm_name, urp.perm_value, urp.role_id FROM users_roles_map urm LEFT JOIN users_role_permissions urp ON(urm.role_id=urp.role_id) LEFT JOIN liberty_content_permissions lcp ON(lcp.role_id=urm.role_id AND lcp.content_id=? AND urp.perm_name=lcp.perm_name) WHERE (urm.user_id=? OR urm.user_id=?) AND lcp.perm_name IS null [ (0=>'1') (1=>'0') (2=>'-1') ]
### Query: 45 NORMALStart time: 0.03285### Query run time: 0.00026
(pdo): SELECT lcp.perm_name AS hash_key, lcp.* FROM liberty_content_permissions lcp INNER JOIN users_roles_map urm ON(lcp.role_id=urm.role_id) LEFT JOIN users_role_permissions urp ON(urm.role_id=urp.role_id AND urp.role_id!=lcp.role_id AND urp.perm_name=lcp.perm_name) WHERE lcp.content_id=? AND (urm.user_id=? OR urm.user_id=?) AND lcp.is_revoked IS null [ (0=>'1') (1=>'0') (2=>'-1') ]
### Query: 46 NORMALStart time: 0.03311### Query run time: 0.0002
(pdo): select lower(rdb$relation_name) from rdb$relations where rdb$relation_name not like 'RDB$%' and rdb$relation_name not like 'MON$%' and rdb$relation_name not like 'SEC$%' (pdo): select lower(rdb$relation_name) from rdb$relations where rdb$relation_name not like 'RDB$%' and rdb$relation_name not like 'MON$%' and rdb$relation_name not like 'SEC$%' (pdo): select lower(rdb$relation_name) from rdb$relations where rdb$relation_name not like 'RDB$%' and rdb$relation_name not like 'MON$%' and rdb$relation_name not like 'SEC$%' (pdo): select lower(rdb$relation_name) from rdb$relations where rdb$relation_name not like 'RDB$%' and rdb$relation_name not like 'MON$%' and rdb$relation_name not like 'SEC$%' (pdo): SELECT ur.role_id, ur.role_name, ur.user_id as role_owner_user_id FROM users_roles_map urm INNER JOIN users_roles ur ON (ur.role_id=urm.role_id) WHERE urm.user_id=? OR urm.role_id=-1 [ (0=>'-1') ]
### Query: 47 NORMALStart time: 0.03587### Query run time: 0.0002
(pdo): SELECT wp.*, lc.*, lcds.data AS summary, uue.login AS modifier_user, uue.real_name AS modifier_real_name, uuc.login AS creator_user, uuc.real_name AS creator_real_name FROM wiki_pages wp INNER JOIN liberty_content lc ON (lc.content_id = wp.content_id) LEFT JOIN liberty_content_role_map lcrm ON ( lc.content_id=lcrm.content_id ) LEFT OUTER JOIN users_roles_map purm ON ( purm.role_id=lcrm.role_id ) LEFT OUTER JOIN liberty_content_data lcds ON (lc.content_id = lcds.content_id AND lcds.data_type='summary') LEFT JOIN users_users uue ON (uue.user_id = lc.modifier_user_id) LEFT JOIN users_users uuc ON (uuc.user_id = lc.user_id) WHERE wp.content_id=? AND (lcrm.content_id IS null OR lcrm.role_id IN(? ) OR purm.user_id=?) [ (0=>'1') (1=>'-1') (2=>'-1') ]
### Query: 48 NORMALStart time: 0.03608### Query run time: 0.00023
(pdo): select lower(rdb$relation_name) from rdb$relations where rdb$relation_name not like 'RDB$%' and rdb$relation_name not like 'MON$%' and rdb$relation_name not like 'SEC$%' (pdo): SELECT r.item, r.cross_ref_title FROM liberty_xref_item r JOIN liberty_xref_group t ON t.x_group = r.x_group AND t.content_type_guid = r.content_type_guid LEFT OUTER JOIN users_roles_map purm ON ( purm.user_id=0 ) AND ( purm.role_id=r.role_id ) WHERE r.content_type_guid = 'contact' AND t.sort_order = 0 AND (r.role_id IN(? ) OR purm.user_id=?) ORDER BY r.item [ (0=>'-1') (1=>null) ]
### Query: 49 NORMALStart time: 0.03702### Query run time: 0.00064
(pdo): select lower(rdb$relation_name) from rdb$relations where rdb$relation_name not like 'RDB$%' and rdb$relation_name not like 'MON$%' and rdb$relation_name not like 'SEC$%' (pdo): SELECT r.item, r.cross_ref_title FROM liberty_xref_item r JOIN liberty_xref_group t ON t.x_group = r.x_group AND t.content_type_guid = r.content_type_guid LEFT OUTER JOIN users_roles_map purm ON ( purm.user_id=0 ) AND ( purm.role_id=r.role_id ) WHERE r.content_type_guid = 'contact' AND t.sort_order = 0 AND (r.role_id IN(? ) OR purm.user_id=?) ORDER BY r.item [ (0=>'-1') (1=>null) ]
### Query: 50 NORMALStart time: 0.03838### Query run time: 0.0002
(pdo): select con.*, lc.*, ap.*, xhA.xkey_ext AS house, img.xkey AS client_gallery, x00.xkey_ext as name, lc.title as organisation, xhL.xkey as x_coordinate, xhL.xkey_ext as y_coordinate, uue.login AS modifier_user, uue.real_name AS modifier_real_name, uuc.login AS creator_user, uuc.real_name AS creator_real_name FROM contact con LEFT JOIN liberty_content lc ON lc.content_id = con.content_id LEFT JOIN users_users uue ON (uue.user_id = lc.modifier_user_id) LEFT JOIN users_users uuc ON (uuc.user_id = lc.user_id) LEFT JOIN liberty_xref img ON img.content_id = con.content_id AND img.item = 'IMG' LEFT JOIN liberty_xref x00 ON x00.content_id = con.content_id AND x00.item = '$00' LEFT JOIN liberty_xref xhA ON xhA.content_id = con.content_id AND xhA.item = '#S' AND ( xhA.end_date IS NULL OR xhA.end_date > CURRENT_TIMESTAMP ) LEFT JOIN liberty_xref xhL ON xhL.content_id = con.content_id AND xhL.item = '#L' AND ( xhL.end_date IS NULL OR xhL.end_date > CURRENT_TIMESTAMP ) LEFT JOIN address_postcode ap ON ap.postcode = xhA.xkey WHERE con.content_id=? [ (0=>'1') ]
### Query: 51 NORMALStart time: 0.03861### Query run time: 0.00107
(pdo): SELECT urp.perm_name as hash_key, 1 as role_perm, urp.perm_name, urp.perm_value, urp.role_id FROM users_roles_map urm LEFT JOIN users_role_permissions urp ON(urm.role_id=urp.role_id) LEFT JOIN liberty_content_permissions lcp ON(lcp.role_id=urm.role_id AND lcp.content_id=? AND urp.perm_name=lcp.perm_name) WHERE (urm.user_id=? OR urm.user_id=?) AND lcp.perm_name IS null [ (0=>'1') (1=>'0') (2=>'-1') ]
### Query: 52 NORMALStart time: 0.03971### Query run time: 0.00028
(pdo): SELECT lcp.perm_name AS hash_key, lcp.* FROM liberty_content_permissions lcp INNER JOIN users_roles_map urm ON(lcp.role_id=urm.role_id) LEFT JOIN users_role_permissions urp ON(urm.role_id=urp.role_id AND urp.role_id!=lcp.role_id AND urp.perm_name=lcp.perm_name) WHERE lcp.content_id=? AND (urm.user_id=? OR urm.user_id=?) AND lcp.is_revoked IS null [ (0=>'1') (1=>'0') (2=>'-1') ]
### Query: 53 NORMALStart time: 0.03999### Query run time: 0.00019
(pdo): select lower(rdb$relation_name) from rdb$relations where rdb$relation_name not like 'RDB$%' and rdb$relation_name not like 'MON$%' and rdb$relation_name not like 'SEC$%' (pdo): select lower(rdb$relation_name) from rdb$relations where rdb$relation_name not like 'RDB$%' and rdb$relation_name not like 'MON$%' and rdb$relation_name not like 'SEC$%' (pdo): SELECT ur.role_id, ur.role_name, ur.user_id as role_owner_user_id FROM users_roles_map urm INNER JOIN users_roles ur ON (ur.role_id=urm.role_id) WHERE urm.user_id=? OR urm.role_id=-1 [ (0=>'-1') ]
### Query: 54 NORMALStart time: 0.04151### Query run time: 0.00021
(pdo): SELECT b.*, lc.*, lch.hits, uu.login, uu.login, uu.user_id, uu.real_name, lfa.file_name as avatar_file_name, lfa.mime_type AS avatar_mime_type, laa.attachment_id AS avatar_attachment_id, lfp.file_name AS image_file_name, lfp.mime_type AS image_mime_type, lap.attachment_id AS image_attachment_id FROM blogs b INNER JOIN liberty_content lc ON (lc.content_id = b.content_id) INNER JOIN users_users uu ON (uu.user_id = lc.user_id) LEFT JOIN liberty_content_role_map lcrm ON ( lc.content_id=lcrm.content_id ) LEFT OUTER JOIN users_roles_map purm ON ( purm.role_id=lcrm.role_id ) LEFT OUTER JOIN liberty_content_hits lch ON (lc.content_id = lch.content_id) LEFT OUTER JOIN liberty_attachments laa ON (uu.user_id = laa.user_id AND laa.attachment_id = uu.avatar_attachment_id) LEFT OUTER JOIN liberty_files lfa ON lfa.file_id = laa.foreign_id LEFT OUTER JOIN liberty_attachments lap ON lap.content_id = lc.content_id AND lap.is_primary = 'y' LEFT OUTER JOIN liberty_files lfp ON lfp.file_id = lap.foreign_id WHERE b.content_id= ? AND (lcrm.content_id IS null OR lcrm.role_id IN(? ) OR purm.user_id=?) [ (0=>'1') (1=>'-1') (2=>'-1') ]
### Query: 55 NORMALStart time: 0.04174### Query run time: 0.00081
(pdo): select lower(rdb$relation_name) from rdb$relations where rdb$relation_name not like 'RDB$%' and rdb$relation_name not like 'MON$%' and rdb$relation_name not like 'SEC$%' (pdo): select lower(rdb$relation_name) from rdb$relations where rdb$relation_name not like 'RDB$%' and rdb$relation_name not like 'MON$%' and rdb$relation_name not like 'SEC$%' (pdo): SELECT ur.role_id, ur.role_name, ur.user_id as role_owner_user_id FROM users_roles_map urm INNER JOIN users_roles ur ON (ur.role_id=urm.role_id) WHERE urm.user_id=? OR urm.role_id=-1 [ (0=>'-1') ]
### Query: 56 NORMALStart time: 0.04392### Query run time: 0.00021
(pdo): SELECT bp.*, lc.*, lcds.data AS summary, lch.hits, uu.login, uu.real_name, lfa.file_name as avatar_file_name, lfa.mime_type AS avatar_mime_type, laa.attachment_id AS avatar_attachment_id, lfp.file_name AS image_file_name, lfp.mime_type AS image_mime_type, lap.attachment_id AS image_attachment_id FROM blog_posts bp INNER JOIN liberty_content lc ON (lc.content_id = bp.content_id) INNER JOIN users_users uu ON( uu.user_id = lc.user_id ) LEFT OUTER JOIN liberty_content_data lcds ON (lc.content_id = lcds.content_id AND lcds.data_type='summary') LEFT OUTER JOIN liberty_content_hits lch ON( lch.content_id = lc.content_id ) LEFT OUTER JOIN liberty_attachments laa ON (uu.user_id = laa.user_id AND uu.avatar_attachment_id=laa.attachment_id) LEFT OUTER JOIN liberty_files lfa ON (lfa.file_id = laa.foreign_id) LEFT OUTER JOIN liberty_attachments lap ON( lap.content_id = lc.content_id AND lap.is_primary = 'y' ) LEFT OUTER JOIN liberty_files lfp ON( lfp.file_id = lap.foreign_id ) LEFT JOIN liberty_content_role_map lcrm ON ( lc.content_id=lcrm.content_id ) LEFT OUTER JOIN users_roles_map purm ON ( purm.role_id=lcrm.role_id ) WHERE bp.content_id=? AND (lcrm.content_id IS null OR lcrm.role_id IN(? ) OR purm.user_id=?) [ (0=>'1') (1=>'-1') (2=>'-1') ]
### Query: 57 NORMALStart time: 0.04415### Query run time: 0.0007
(pdo): select lower(rdb$relation_name) from rdb$relations where rdb$relation_name not like 'RDB$%' and rdb$relation_name not like 'MON$%' and rdb$relation_name not like 'SEC$%' (pdo): SELECT ur.role_id, ur.role_name, ur.user_id as role_owner_user_id FROM users_roles_map urm INNER JOIN users_roles ur ON (ur.role_id=urm.role_id) WHERE urm.user_id=? OR urm.role_id=-1 [ (0=>'0') ]
### Query: 94 NORMALStart time: 0.06711### Query run time: 0.0002
(pdo): SELECT FIRST 1 COUNT(b.blog_id) FROM blogs b INNER JOIN liberty_content lc ON (lc.content_id = b.content_id) INNER JOIN users_users uu ON (uu.user_id = lc.user_id) LEFT JOIN liberty_content_role_map lcrm ON ( lc.content_id=lcrm.content_id ) LEFT OUTER JOIN users_roles_map purm ON ( purm.user_id = 0 ) AND ( purm.role_id=lcrm.role_id ) WHERE (lcrm.content_id IS null OR lcrm.role_id IN(? ) OR purm.user_id = ? ) [ (0=>'-1') (1=>'0') ]
### Query: 95 NORMALStart time: 0.06733### Query run time: 0.00045
(pdo): SELECT FIRST 10 SKIP 0 b.content_id AS hash_key, b.blog_id, b.is_public, b.max_posts, b.activity, b.use_find, b.use_title, b.add_date, b.add_poster, b.allow_comments, uu.login, uu.real_name, lc.*, lch.hits FROM blogs b INNER JOIN liberty_content lc ON (lc.content_id = b.content_id) INNER JOIN users_users uu ON (uu.user_id = lc.user_id) LEFT JOIN liberty_content_role_map lcrm ON ( lc.content_id=lcrm.content_id ) LEFT OUTER JOIN users_roles_map purm ON ( purm.user_id = 0 ) AND ( purm.role_id=lcrm.role_id ) LEFT OUTER JOIN liberty_content_hits lch ON (lc.content_id = lch.content_id) WHERE (lcrm.content_id IS null OR lcrm.role_id IN(? ) OR purm.user_id = ? ) order by lch.hits DESC [ (0=>'-1') (1=>'0') ]
### Query: 96 NORMALStart time: 0.0678### Query run time: 0.00067
(pdo): SELECT FIRST 1 COUNT(*) FROM blogs_posts_map bpm INNER JOIN blog_posts bp ON (bpm.post_content_id=bp.content_id) WHERE bpm.blog_content_id = ? AND ((bp.publish_date IS null AND bp.expire_date IS null) OR (bp.publish_date <= ? AND ((bp.expire_date IS null) OR ( bp.expire_date <= bp.publish_date ) OR ( bp.expire_date > ? )))) [ (0=>'1729') (1=>'1780845122') (2=>'1780845122') ]
### Query: 97 NORMALStart time: 0.06849### Query run time: 0.00044
(pdo): SELECT FIRST 1 COUNT(*) FROM blogs_posts_map bpm INNER JOIN blog_posts bp ON (bpm.post_content_id=bp.content_id) WHERE bpm.blog_content_id = ? AND ((bp.publish_date IS null AND bp.expire_date IS null) OR (bp.publish_date <= ? AND ((bp.expire_date IS null) OR ( bp.expire_date <= bp.publish_date ) OR ( bp.expire_date > ? )))) [ (0=>'2074') (1=>'1780845122') (2=>'1780845122') ]
### Query: 98 NORMALStart time: 0.06899### Query run time: 0.0002
(pdo): SELECT FIRST 1 COUNT(*) FROM blogs_posts_map bpm INNER JOIN blog_posts bp ON (bpm.post_content_id=bp.content_id) WHERE bpm.blog_content_id = ? AND ((bp.publish_date IS null AND bp.expire_date IS null) OR (bp.publish_date <= ? AND ((bp.expire_date IS null) OR ( bp.expire_date <= bp.publish_date ) OR ( bp.expire_date > ? )))) [ (0=>'2038') (1=>'1780845122') (2=>'1780845122') ]
### Query: 99 NORMALStart time: 0.06924### Query run time: 0.00019
(pdo): select lower(rdb$relation_name) from rdb$relations where rdb$relation_name not like 'RDB$%' and rdb$relation_name not like 'MON$%' and rdb$relation_name not like 'SEC$%' (pdo): SELECT ur.role_id, ur.role_name, ur.user_id as role_owner_user_id FROM users_roles_map urm INNER JOIN users_roles ur ON (ur.role_id=urm.role_id) WHERE urm.user_id=? OR urm.role_id=-1 [ (0=>'0') ]
### Query: 106 NORMALStart time: 0.07266### Query run time: 0.0002
(pdo): SELECT FIRST 5 SKIP 0 fi.image_id AS hash_key, fi.*, lf.*, la.attachment_id, lc.*, fg.gallery_id, uu.login, uu.real_name FROM fisheye_image fi INNER JOIN liberty_attachments la ON(la.content_id=fi.content_id) INNER JOIN liberty_files lf ON(la.foreign_id=lf.file_id) INNER JOIN liberty_content lc ON(fi.content_id = lc.content_id) INNER JOIN users_users uu ON(uu.user_id = lc.user_id) LEFT JOIN liberty_content_role_map lcrm ON ( lc.content_id=lcrm.content_id ) LEFT OUTER JOIN users_roles_map purm ON ( purm.user_id = 0 ) AND ( purm.role_id=lcrm.role_id ) LEFT OUTER JOIN fisheye_gallery_image_map tfgim2 ON(tfgim2.item_content_id=lc.content_id) LEFT OUTER JOIN fisheye_gallery fg ON(fg.content_id=tfgim2.gallery_content_id) WHERE fg.gallery_id = ? AND (lcrm.content_id IS null OR lcrm.role_id IN(? ) OR purm.user_id = ? ) ORDER BY rand() [ (0=>'94') (1=>'-1') (2=>'0') ]
### Query: 107 NORMALStart time: 0.07288### Query run time: 0.05321
(pdo): select lower(rdb$relation_name) from rdb$relations where rdb$relation_name not like 'RDB$%' and rdb$relation_name not like 'MON$%' and rdb$relation_name not like 'SEC$%' (pdo): SELECT ur.role_id, ur.role_name, ur.user_id as role_owner_user_id FROM users_roles_map urm INNER JOIN users_roles ur ON (ur.role_id=urm.role_id) WHERE urm.user_id=? OR urm.role_id=-1 [ (0=>'0') ]
### Query: 108 NORMALStart time: 0.12696### Query run time: 0.00024
(pdo): SELECT FIRST 5 SKIP 0 fi.image_id AS hash_key, fi.*, lf.*, la.attachment_id, lc.*, fg.gallery_id, uu.login, uu.real_name FROM fisheye_image fi INNER JOIN liberty_attachments la ON(la.content_id=fi.content_id) INNER JOIN liberty_files lf ON(la.foreign_id=lf.file_id) INNER JOIN liberty_content lc ON(fi.content_id = lc.content_id) INNER JOIN users_users uu ON(uu.user_id = lc.user_id) LEFT JOIN liberty_content_role_map lcrm ON ( lc.content_id=lcrm.content_id ) LEFT OUTER JOIN users_roles_map purm ON ( purm.user_id = 0 ) AND ( purm.role_id=lcrm.role_id ) LEFT OUTER JOIN fisheye_gallery_image_map tfgim2 ON(tfgim2.item_content_id=lc.content_id) LEFT OUTER JOIN fisheye_gallery fg ON(fg.content_id=tfgim2.gallery_content_id) WHERE fg.gallery_id = ? AND (lcrm.content_id IS null OR lcrm.role_id IN(? ) OR purm.user_id = ? ) ORDER BY rand() [ (0=>'94') (1=>'-1') (2=>'0') ]
### Query: 109 NORMALStart time: 0.12721### Query run time: 0.05344
(pdo): SELECT lc.content_id, lcrm.role_id as is_protected FROM liberty_content lc LEFT JOIN liberty_content_role_map lcrm ON ( lc.content_id=lcrm.content_id ) LEFT OUTER JOIN users_roles_map urm ON ( urm.user_id=0 ) AND ( urm.role_id=lcrm.role_id ) WHERE lc.content_id = ? [ (0=>'10') ]
### Query: 110 NORMALStart time: 0.18125### Query run time: 0.00028
(pdo): SELECT lc.content_id, lcrm.role_id as is_protected FROM liberty_content lc LEFT JOIN liberty_content_role_map lcrm ON ( lc.content_id=lcrm.content_id ) LEFT OUTER JOIN users_roles_map urm ON ( urm.user_id=0 ) AND ( urm.role_id=lcrm.role_id ) WHERE lc.content_id = ? [ (0=>'10') ]
### Query: 111 NORMALStart time: 0.18156### Query run time: 0.00026
(pdo): SELECT lc.content_id, lcrm.role_id as is_protected FROM liberty_content lc LEFT JOIN liberty_content_role_map lcrm ON ( lc.content_id=lcrm.content_id ) LEFT OUTER JOIN users_roles_map urm ON ( urm.user_id=0 ) AND ( urm.role_id=lcrm.role_id ) WHERE lc.content_id = ? [ (0=>'10') ]
### Query: 112 NORMALStart time: 0.18185### Query run time: 0.00021
ADOConnection.CacheExecute(600, SELECT uu.* FROM users_users uu LEFT OUTER JOIN liberty_content lc ON (lc.content_id=uu.content_id) WHERE uu.user_id = ?, Array[1]) % line 2382, file: adodb.inc.php
ADOConnection.CacheGetRow(600, SELECT uu.* FROM users_users uu LEFT OUTER JOIN liberty_content lc ON (lc.content_id=uu.content_id) WHERE uu.user_id = ?, Array[1]) % line 402, file: BitDbAdodb.php
Bitweaver\BitDbAdodb.getRow(SELECT uu.* FROM users_users uu LEFT OUTER JOIN liberty_content lc ON (lc.content_id=uu.content_id) WHERE uu.user_id = ?, Array[1], 600) % line 1692, file: RoleUser.php
Bitweaver\Users\RoleUser.getUserInfo(Array[1]) % line 54, file: function.displayname.php
Bitweaver\Plugins\smarty_function_displayname(Array[3], Object:Smarty\Template) % line 18, file: BCPluginWrapper.php
Smarty\FunctionHandler\BCPluginWrapper.handle(Array[3], Object:Smarty\Template) % line 36, file: 114f008558f7d3da9e957ba783fdc6443f2c23cc_0.bitpackage_wikipage_date_bar.tpl.php
content_6a21a627420637_48866431(Object:Smarty\Template) % line 111, file: GeneratedPhpFile.php
Smarty\Template\GeneratedPhpFile.getRenderedTemplateCode(Object:Smarty\Template, content_6a21a627420637_48866431) % line 110, file: Compiled.php
Smarty\Template\Compiled.render(Object:Smarty\Template) % line 180, file: Template.php
Smarty\Template.render() % line 287, file: Template.php
Smarty\Template.renderSubTemplate(bitpackage:wiki/page_date_bar.tpl, null, null, 0, 3600, Array[0], 0, .) % line 36, file: e34dca29718a70e5f43045b726ea3945246eee74_0.bitpackage_wikipage_header.tpl.php
content_6a21a62741c775_70441579(Object:Smarty\Template) % line 111, file: GeneratedPhpFile.php
Smarty\Template\GeneratedPhpFile.getRenderedTemplateCode(Object:Smarty\Template, content_6a21a62741c775_70441579) % line 110, file: Compiled.php
Smarty\Template\Compiled.render(Object:Smarty\Template) % line 180, file: Template.php
Smarty\Template.render() % line 287, file: Template.php
Smarty\Template.renderSubTemplate(bitpackage:wiki/page_header.tpl, null, null, 0, 3600, Array[0], 0, .) % line 51, file: 604fe87611baf828859aef64505207f456820349_0.bitpackage_wikishow_page.tpl.php
content_6a21a6273fdc78_85350705(Object:Smarty\Template) % line 111, file: GeneratedPhpFile.php
Smarty\Template\GeneratedPhpFile.getRenderedTemplateCode(Object:Smarty\Template, content_6a21a6273fdc78_85350705) % line 110, file: Compiled.php
Smarty\Template\Compiled.render(Object:Smarty\Template) % line 180, file: Template.php
Smarty\Template.render() % line 287, file: Template.php
Smarty\Template.renderSubTemplate(bitpackage:wiki/show_page.tpl, null, null, 0, 3600, Array[0], 0, .) % line 109, file: 4b8a6e5c2e6b61f199d185a946231d1c80c90760_0.bitpackage_kernelhtml.tpl.php
content_6a21a5a19d59e7_06792299(Object:Smarty\Template) % line 111, file: GeneratedPhpFile.php
Smarty\Template\GeneratedPhpFile.getRenderedTemplateCode(Object:Smarty\Template, content_6a21a5a19d59e7_06792299) % line 110, file: Compiled.php
Smarty\Template\Compiled.render(Object:Smarty\Template) % line 180, file: Template.php
Smarty\Template.render(false, 0) % line 655, file: Template.php
Smarty\Template._execute(0) % line 589, file: Template.php
Smarty\Template.fetch() % line 2117, file: Smarty.php
Smarty\Smarty.fetch(bitpackage:kernel/html.tpl, null, null) % line 97, file: BitSmarty.php
Bitweaver\Themes\BitSmarty.fetch(bitpackage:kernel/html.tpl) % line 587, file: BitSystem.php
Bitweaver\BitSystem.display(bitpackage:wiki/show_page.tpl, Meeting Management System, Array[1]) % line 168, file: display_bitpage_inc.php
include(/srv/website/_bw5/wiki/includes/display_bitpage_inc.php) % line 51, file: index.php
/tmp/3a/adodb_3a9009413fd7476be235f2249b2e633c.cache reloaded, ttl=221 [ SELECT uu.* FROM users_users uu LEFT OUTER JOIN liberty_content lc ON (lc.content_id=uu.content_id) WHERE uu.user_id = ? ]
### Query: 113 NORMALStart time: 0.18238### Query run time: 0.00013
ADOConnection.CacheExecute(86400, SELECT FIRST 1 pref_value FROM liberty_content_prefs lcp INNER JOIN users_users uu ON (lcp.content_id=uu.content_id) WHERE uu.l, Array[1]) % line 286, file: adodb-pdo_firebird.inc.php
ADODB_pdo_firebird.selectLimit(SELECT FIRST 1 pref_value FROM liberty_content_prefs lcp INNER JOIN users_users uu ON (lcp.content_id=uu.content_id) WHERE uu.l, 1, -1, Array[1], 86400) % line 282, file: adodb-pdo.inc.php
ADODB_pdo.SelectLimit(SELECT pref_value FROM liberty_content_prefs lcp INNER JOIN users_users uu ON (lcp.content_id=uu.content_id) WHERE uu.login=? AN, 1, -1, Array[1], 86400) % line 2459, file: adodb.inc.php
ADOConnection.CacheSelectLimit(86400, SELECT pref_value FROM liberty_content_prefs lcp INNER JOIN users_users uu ON (lcp.content_id=uu.content_id) WHERE uu.login=? AN, 1, -1, Array[1]) % line 260, file: BitDbAdodb.php
Bitweaver\BitDbAdodb.query(SELECT pref_value FROM liberty_content_prefs lcp INNER JOIN users_users uu ON (lcp.content_id=uu.content_id) WHERE uu.login=? AN, Array[1], 1, -1, 86400) % line 415, file: BitDbAdodb.php
Bitweaver\BitDbAdodb.getOne(SELECT pref_value FROM liberty_content_prefs lcp INNER JOIN users_users uu ON (lcp.content_id=uu.content_id) WHERE uu.login=? AN, Array[1], 1, null, 86400) % line 2472, file: RoleUser.php
Bitweaver\Users\RoleUser.getDisplayNameFromHash(Array[19], true) % line 58, file: function.displayname.php
Bitweaver\Plugins\smarty_function_displayname(Array[3], Object:Smarty\Template) % line 18, file: BCPluginWrapper.php
Smarty\FunctionHandler\BCPluginWrapper.handle(Array[3], Object:Smarty\Template) % line 36, file: 114f008558f7d3da9e957ba783fdc6443f2c23cc_0.bitpackage_wikipage_date_bar.tpl.php
content_6a21a627420637_48866431(Object:Smarty\Template) % line 111, file: GeneratedPhpFile.php
Smarty\Template\GeneratedPhpFile.getRenderedTemplateCode(Object:Smarty\Template, content_6a21a627420637_48866431) % line 110, file: Compiled.php
Smarty\Template\Compiled.render(Object:Smarty\Template) % line 180, file: Template.php
Smarty\Template.render() % line 287, file: Template.php
Smarty\Template.renderSubTemplate(bitpackage:wiki/page_date_bar.tpl, null, null, 0, 3600, Array[0], 0, .) % line 36, file: e34dca29718a70e5f43045b726ea3945246eee74_0.bitpackage_wikipage_header.tpl.php
content_6a21a62741c775_70441579(Object:Smarty\Template) % line 111, file: GeneratedPhpFile.php
Smarty\Template\GeneratedPhpFile.getRenderedTemplateCode(Object:Smarty\Template, content_6a21a62741c775_70441579) % line 110, file: Compiled.php
Smarty\Template\Compiled.render(Object:Smarty\Template) % line 180, file: Template.php
Smarty\Template.render() % line 287, file: Template.php
Smarty\Template.renderSubTemplate(bitpackage:wiki/page_header.tpl, null, null, 0, 3600, Array[0], 0, .) % line 51, file: 604fe87611baf828859aef64505207f456820349_0.bitpackage_wikishow_page.tpl.php
content_6a21a6273fdc78_85350705(Object:Smarty\Template) % line 111, file: GeneratedPhpFile.php
Smarty\Template\GeneratedPhpFile.getRenderedTemplateCode(Object:Smarty\Template, content_6a21a6273fdc78_85350705) % line 110, file: Compiled.php
Smarty\Template\Compiled.render(Object:Smarty\Template) % line 180, file: Template.php
Smarty\Template.render() % line 287, file: Template.php
Smarty\Template.renderSubTemplate(bitpackage:wiki/show_page.tpl, null, null, 0, 3600, Array[0], 0, .) % line 109, file: 4b8a6e5c2e6b61f199d185a946231d1c80c90760_0.bitpackage_kernelhtml.tpl.php
content_6a21a5a19d59e7_06792299(Object:Smarty\Template) % line 111, file: GeneratedPhpFile.php
Smarty\Template\GeneratedPhpFile.getRenderedTemplateCode(Object:Smarty\Template, content_6a21a5a19d59e7_06792299) % line 110, file: Compiled.php
Smarty\Template\Compiled.render(Object:Smarty\Template) % line 180, file: Template.php
Smarty\Template.render(false, 0) % line 655, file: Template.php
Smarty\Template._execute(0) % line 589, file: Template.php
Smarty\Template.fetch() % line 2117, file: Smarty.php
Smarty\Smarty.fetch(bitpackage:kernel/html.tpl, null, null) % line 97, file: BitSmarty.php
Bitweaver\Themes\BitSmarty.fetch(bitpackage:kernel/html.tpl) % line 587, file: BitSystem.php
Bitweaver\BitSystem.display(bitpackage:wiki/show_page.tpl, Meeting Management System, Array[1]) % line 168, file: display_bitpage_inc.php
include(/srv/website/_bw5/wiki/includes/display_bitpage_inc.php) % line 51, file: index.php
/tmp/08/adodb_0809b0d7963ee71aab329a49129da91c.cache reloaded, ttl=60010 [ SELECT FIRST 1 pref_value FROM liberty_content_prefs lcp INNER JOIN users_users uu ON (lcp.content_id=uu.content_id) WHERE uu.login=? AND pref_name='users_information' ]
### Query: 114 NORMALStart time: 0.18252### Query run time: 0.00011
The Meeting Management System provides for room booking management of a small to medium size
meeting location. The main purpose of the system is to provide information displays or people
arriving at the venue, but has evolved over the years to provide a multi-user system for booking
and charging for usage of rooms. Hard copy printout of the meeting diary can be produced, along
with an on-line web based access for users prior to their arrival. Developed originally for
locations such as Education Centers and Conference Facilities, the system can easily be expanded
to cover any room management requirements.
The system provides a front end to the Display Management System, which can be used to carry
meeting diary and other information around a site.