(pdo): SELECT il.lang_code AS hash_key, il.* FROM i18n_languages il ORDER BY il.lang_code
### Query: 1 NORMALStart time: 6.0E-5### Query run time: 0.00095
(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.00385### Query run time: 0.00123
(pdo): SELECT lc.content_id, lc.content_type_guid FROM fisheye_image fi INNER JOIN liberty_content lc ON(lc.content_id=fi.content_id) WHERE image_id=? [ (0=>'188') ]
### Query: 3 NORMALStart time: 0.00536### Query run time: 0.00074
(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: 4 NORMALStart time: 0.00743### Query run time: 0.00037
(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=>'188') (1=>'-1') (2=>'-1') ]
### Query: 5 NORMALStart time: 0.00782### Query run time: 0.00098
(pdo): SELECT pref_name, pref_value FROM liberty_content_prefs WHERE content_id=? [ (0=>'188') ]
### Query: 6 NORMALStart time: 0.00881### Query run time: 0.00033
(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=>'188') ]
### Query: 7 NORMALStart time: 0.00916### Query run time: 0.00047
(pdo): SELECT * FROM liberty_attachments la WHERE la.content_id=? ORDER BY la.pos ASC, la.attachment_id ASC [ (0=>'188') ]
### Query: 8 NORMALStart time: 0.00965### Query run time: 0.00029
(pdo): SELECT * FROM liberty_attachments la LEFT OUTER JOIN liberty_files lf ON( la.foreign_id = lf.file_id ) WHERE la.attachment_id=? [ (0=>'188') ]
### Query: 9 NORMALStart time: 0.00995### Query run time: 0.0004
### Query: 10 NORMALStart time: 0.01042### Query run time: 0.00055
(pdo): SELECT fg.gallery_id AS hash_key, fg.*, lc.title FROM fisheye_gallery fg, liberty_content lc, fisheye_gallery_image_map fgim WHERE fgim.item_content_id = ? AND fgim.gallery_content_id=fg.content_id AND fg.content_id=lc.content_id [ (0=>'188') ]
### Query: 11 NORMALStart time: 0.01101### Query run time: 0.00066
(pdo): WITH TREE AS ( SELECT fgim.item_content_id AS gallery_content_id, LAG( fgim.item_content_id) OVER (ORDER BY fgim.item_position) AS PREVIOUS, LEAD( fgim.item_content_id ) OVER (ORDER BY fgim.item_position) AS NEXT FROM fisheye_gallery_image_map fgim WHERE fgim.gallery_content_id = ? order by fgim.item_position ) SELECT pr.PREVIOUS, prec.content_type_guid AS PRE_T, pr.NEXT, posc.content_type_guid AS NEXT_T FROM TREE pr LEFT JOIN liberty_content prec ON prec.content_id = pr.PREVIOUS LEFT JOIN liberty_content posc ON posc.content_id = pr.NEXT WHERE pr.gallery_content_id = ? [ (0=>'177') (1=>'188') ]
### Query: 12 NORMALStart time: 0.01168### Query run time: 0.00059
(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 lc.content_id, lc.content_type_guid FROM fisheye_gallery fg INNER JOIN liberty_content lc ON(lc.content_id=fg.content_id) WHERE gallery_id=? [ (0=>'8') ]
### Query: 13 NORMALStart time: 0.01291### Query run time: 0.00031
(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: 14 NORMALStart time: 0.01449### Query run time: 0.00019
(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=>'177') (1=>'-1') (2=>'-1') ]
### Query: 15 NORMALStart time: 0.01469### Query run time: 0.00053
(pdo): SELECT pref_name, pref_value FROM liberty_content_prefs WHERE content_id=? [ (0=>'177') ]
### Query: 16 NORMALStart time: 0.01523### Query run time: 0.00018
(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: 17 NORMALStart time: 0.01543### Query run time: 0.00019
(pdo): SELECT COUNT(*) AS "count" FROM fisheye_gallery_image_map fgim INNER JOIN liberty_content lc ON ( lc.content_id=fgim.item_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.user_id = 0 ) AND ( purm.role_id=lcrm.role_id ) WHERE gallery_content_id = ? AND (lcrm.content_id IS null OR lcrm.role_id IN(? ) OR purm.user_id = ? ) [ (0=>'177') (1=>'-1') (2=>'0') ]
### Query: 18 NORMALStart time: 0.01563### Query run time: 0.00052
(pdo): SELECT fgim.*, fi.image_id, lf.file_name, lf.user_id, lf.mime_type, la.attachment_id FROM fisheye_gallery_image_map fgim INNER JOIN fisheye_image fi ON ( fi.content_id=fgim.item_content_id ) INNER JOIN liberty_attachments la ON ( fi.content_id=la.content_id ) INNER JOIN liberty_files lf ON ( lf.file_id=la.foreign_id ) WHERE fgim.gallery_content_id = ? ORDER BY fgim.item_position, fi.content_id [ (0=>'177') ]
### Query: 19 NORMALStart time: 0.01618### Query run time: 0.00075
(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 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=>'188') ]
### Query: 20 NORMALStart time: 0.01811### Query run time: 0.00032
(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=>'188') (1=>'0') (2=>'-1') ]
### Query: 21 NORMALStart time: 0.01844### 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=>'188') (1=>'0') (2=>'-1') ]
### Query: 22 NORMALStart time: 0.01899### Query run time: 0.0004
(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=>'188') ]
### Query: 23 NORMALStart time: 0.01941### 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=>'188') ]
### Query: 24 NORMALStart time: 0.01961### Query run time: 0.00017
(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=>'188') ]
### Query: 25 NORMALStart time: 0.0198### Query run time: 0.00017
(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=>'188') ]
### Query: 26 NORMALStart time: 0.01999### Query run time: 0.00017
(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=>'188') ]
### Query: 27 NORMALStart time: 0.02017### Query run time: 0.00016
(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=>'188') ]
### Query: 28 NORMALStart time: 0.02034### Query run time: 0.00016
(pdo): SELECT tl.* FROM themes_layouts tl WHERE tl.layout=? ORDER BY pos ASC [ (0=>'fisheye') ]
### Query: 29 NORMALStart time: 0.02057### Query run time: 0.00038
(pdo): SELECT tl.* FROM themes_layouts tl WHERE tl.layout=? ORDER BY pos ASC [ (0=>'kernel') ]
### Query: 30 NORMALStart time: 0.02097### Query run time: 0.00022
1936ClothBack - 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: 31 NORMALStart time: 0.02338### Query run time: 0.00054
(pdo): SELECT pref_name, pref_value FROM liberty_content_prefs WHERE content_id=? [ (0=>'1') ]
### Query: 32 NORMALStart time: 0.02394### 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: 33 NORMALStart time: 0.02412### Query run time: 0.00016
(pdo): SELECT * FROM liberty_attachments la WHERE la.content_id=? ORDER BY la.pos ASC, la.attachment_id ASC [ (0=>'1') ]
### Query: 34 NORMALStart time: 0.02429### Query run time: 0.00016
(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: 35 NORMALStart time: 0.0245### 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: 36 NORMALStart time: 0.02476### Query run time: 0.00018
(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: 37 NORMALStart time: 0.02625### 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: 38 NORMALStart time: 0.02646### Query run time: 0.00072
(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: 39 NORMALStart time: 0.02848### Query run time: 0.00019
(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: 40 NORMALStart time: 0.02868### Query run time: 0.00021
(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: 41 NORMALStart time: 0.02892### 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: 42 NORMALStart time: 0.02918### Query run time: 0.00017
(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: 43 NORMALStart time: 0.03062### Query run time: 0.00019
(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: 44 NORMALStart time: 0.03082### Query run time: 0.00021
(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.03105### 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: 46 NORMALStart time: 0.03134### 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: 47 NORMALStart time: 0.03282### Query run time: 0.0002
(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: 48 NORMALStart time: 0.03304### Query run time: 0.00099
(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: 49 NORMALStart time: 0.03531### Query run time: 0.0002
(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: 50 NORMALStart time: 0.03552### Query run time: 0.00018
(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: 51 NORMALStart time: 0.0357### Query run time: 0.00055
(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: 52 NORMALStart time: 0.03627### Query run time: 0.00016
(pdo): SELECT * FROM liberty_attachments la WHERE la.content_id=? ORDER BY la.pos ASC, la.attachment_id ASC [ (0=>'1') ]
### Query: 53 NORMALStart time: 0.03644### Query run time: 0.00016
(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: 54 NORMALStart time: 0.03662### Query run time: 0.00024
(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: 55 NORMALStart time: 0.03687### 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 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.03954### Query run time: 0.00019
(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: 57 NORMALStart time: 0.03974### Query run time: 0.00022
(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: 58 NORMALStart time: 0.04076### Query run time: 0.00071
(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: 59 NORMALStart time: 0.04213### Query run time: 0.00018
(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: 60 NORMALStart time: 0.04232### Query run time: 0.00106
(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: 61 NORMALStart time: 0.04341### Query run time: 0.00025
(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: 62 NORMALStart time: 0.04367### Query run time: 0.00018
(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: 63 NORMALStart time: 0.04515### Query run time: 0.00019
(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: 64 NORMALStart time: 0.04535### Query run time: 0.00088
(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: 65 NORMALStart time: 0.04762### Query run time: 0.0002
(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: 66 NORMALStart time: 0.04783### Query run time: 0.00087
(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: 103 NORMALStart time: 0.07133### Query run time: 0.00019
(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: 104 NORMALStart time: 0.07155### Query run time: 0.00047
(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: 105 NORMALStart time: 0.07203### 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=>'1780838942') (2=>'1780838942') ]
### Query: 106 NORMALStart time: 0.07272### Query run time: 0.00047
(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=>'1780838942') (2=>'1780838942') ]
### Query: 107 NORMALStart time: 0.07327### 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=>'1780838942') (2=>'1780838942') ]
### Query: 108 NORMALStart time: 0.07351### Query run time: 0.00018
(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: 115 NORMALStart time: 0.07691### Query run time: 0.00021
(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: 116 NORMALStart time: 0.07714### Query run time: 0.05307
(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: 117 NORMALStart time: 0.13101### Query run time: 0.00023
(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: 118 NORMALStart time: 0.13126### Query run time: 0.05197
(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=>'188') ]
### Query: 124 NORMALStart time: 0.18612### Query run time: 0.00018
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[1], Object:Smarty\Template) % line 18, file: BCPluginWrapper.php
Smarty\FunctionHandler\BCPluginWrapper.handle(Array[1], Object:Smarty\Template) % line 34, file: 17074808f080904f4131e1bd57ab1eaa7901ac05_0.bitpackage_libertymime_meta_inc.tpl.php
content_6a2433525c6908_53242281(Object:Smarty\Template) % line 111, file: GeneratedPhpFile.php
Smarty\Template\GeneratedPhpFile.getRenderedTemplateCode(Object:Smarty\Template, content_6a2433525c6908_53242281) % 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:liberty/mime_meta_inc.tpl, null, null, 0, 3600, Array[0], 0, .) % line 84, file: fa31ff05e95eaf26e51c4a930b837634450b4d03_0.bitpackage_libertymimedefaultview.tpl.php
content_6a2433525bf3a4_96158369(Object:Smarty\Template) % line 111, file: GeneratedPhpFile.php
Smarty\Template\GeneratedPhpFile.getRenderedTemplateCode(Object:Smarty\Template, content_6a2433525bf3a4_96158369) % 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:liberty/mime/default/view.tpl, null, null, 0, 3600, Array[0], 0, .) % line 32, file: f33103dbebc524328df3893e6a02716fbabb3116_0.bitpackage_libertymimeimageview.tpl.php
content_6a2434416aeeb6_67035042(Object:Smarty\Template) % line 111, file: GeneratedPhpFile.php
Smarty\Template\GeneratedPhpFile.getRenderedTemplateCode(Object:Smarty\Template, content_6a2434416aeeb6_67035042) % 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:liberty/mime/image/view.tpl, null, null, 0, 3600, Array[1], 0, .) % line 77, file: 497ff8c549014cb195e6ea9cfb2046d337f666f6_0.bitpackage_fisheyeview_image.tpl.php
content_6a242e16145414_35905329(Object:Smarty\Template) % line 111, file: GeneratedPhpFile.php
Smarty\Template\GeneratedPhpFile.getRenderedTemplateCode(Object:Smarty\Template, content_6a242e16145414_35905329) % 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:fisheye/view_image.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:fisheye/view_image.tpl, null, Array[1]) % line 26, file: display_fisheye_image_inc.php
require_once(/srv/website/_bw5/fisheye/includes/display_fisheye_image_inc.php) % line 60, file: view_image.php
/tmp/fb/adodb_fbf8c5c1c591a3353f6ab012b62c824f.cache reloaded, ttl=531 [ SELECT uu.* FROM users_users uu LEFT OUTER JOIN liberty_content lc ON (lc.content_id=uu.content_id) WHERE uu.user_id = ? ]
### Query: 125 NORMALStart time: 0.18657### 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[1], Object:Smarty\Template) % line 18, file: BCPluginWrapper.php
Smarty\FunctionHandler\BCPluginWrapper.handle(Array[1], Object:Smarty\Template) % line 34, file: 17074808f080904f4131e1bd57ab1eaa7901ac05_0.bitpackage_libertymime_meta_inc.tpl.php
content_6a2433525c6908_53242281(Object:Smarty\Template) % line 111, file: GeneratedPhpFile.php
Smarty\Template\GeneratedPhpFile.getRenderedTemplateCode(Object:Smarty\Template, content_6a2433525c6908_53242281) % 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:liberty/mime_meta_inc.tpl, null, null, 0, 3600, Array[0], 0, .) % line 84, file: fa31ff05e95eaf26e51c4a930b837634450b4d03_0.bitpackage_libertymimedefaultview.tpl.php
content_6a2433525bf3a4_96158369(Object:Smarty\Template) % line 111, file: GeneratedPhpFile.php
Smarty\Template\GeneratedPhpFile.getRenderedTemplateCode(Object:Smarty\Template, content_6a2433525bf3a4_96158369) % 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:liberty/mime/default/view.tpl, null, null, 0, 3600, Array[0], 0, .) % line 32, file: f33103dbebc524328df3893e6a02716fbabb3116_0.bitpackage_libertymimeimageview.tpl.php
content_6a2434416aeeb6_67035042(Object:Smarty\Template) % line 111, file: GeneratedPhpFile.php
Smarty\Template\GeneratedPhpFile.getRenderedTemplateCode(Object:Smarty\Template, content_6a2434416aeeb6_67035042) % 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:liberty/mime/image/view.tpl, null, null, 0, 3600, Array[1], 0, .) % line 77, file: 497ff8c549014cb195e6ea9cfb2046d337f666f6_0.bitpackage_fisheyeview_image.tpl.php
content_6a242e16145414_35905329(Object:Smarty\Template) % line 111, file: GeneratedPhpFile.php
Smarty\Template\GeneratedPhpFile.getRenderedTemplateCode(Object:Smarty\Template, content_6a242e16145414_35905329) % 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:fisheye/view_image.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:fisheye/view_image.tpl, null, Array[1]) % line 26, file: display_fisheye_image_inc.php
require_once(/srv/website/_bw5/fisheye/includes/display_fisheye_image_inc.php) % line 60, file: view_image.php
/tmp/08/adodb_0876f6597113066d0dcf71a356363792.cache reloaded, ttl=66162 [ 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: 126 NORMALStart time: 0.18672### Query run time: 0.00011
