(pdo): SELECT il.lang_code AS hash_key, il.* FROM i18n_languages il ORDER BY il.lang_code

### Query: 1 NORMAL Start time: 8.0E-5 ### Query run time: 0.0013

(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 NORMAL Start time: 0.00446 ### Query run time: 0.00109

(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=>'12') ]

### Query: 3 NORMAL Start time: 0.00584 ### Query run time: 0.00061

(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 NORMAL Start time: 0.00775 ### Query run time: 0.00037

(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=>'399') (1=>'-1') (2=>'-1') ]

### Query: 5 NORMAL Start time: 0.00814 ### Query run time: 0.00081

(pdo): SELECT pref_name, pref_value FROM liberty_content_prefs WHERE content_id=? [ (0=>'399') ]

### Query: 6 NORMAL Start time: 0.00896 ### Query run time: 0.00037

### Query: 7 NORMAL Start time: 0.00935 ### 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=>'399') (1=>'-1') (2=>'0') ]

### Query: 8 NORMAL Start time: 0.00955 ### Query run time: 0.00059

(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=>'399') ]

### Query: 9 NORMAL Start time: 0.0102 ### Query run time: 0.00031

(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=>'399') (1=>'0') (2=>'-1') ]

### Query: 10 NORMAL Start time: 0.01053 ### Query run time: 0.00053

(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=>'399') (1=>'0') (2=>'-1') ]

### Query: 11 NORMAL Start time: 0.01107 ### Query run time: 0.0004

(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 FIRST 1 count(*) as comment_count FROM liberty_comments lcom INNER JOIN liberty_content lc ON (lcom.content_id = lc.content_id) WHERE lcom.root_id =? [ (0=>'399') ]

### Query: 12 NORMAL Start time: 0.01214 ### Query run time: 0.00042

### Query: 13 NORMAL Start time: 0.01257 ### Query run time: 0.00021

(pdo): SELECT FIRST 5 SKIP 0 lcom.comment_id, lcom.parent_id, lcom.root_id, lcom.thread_forward_sequence, lcom.thread_reverse_sequence, lcom.anon_name, 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.user_id = 0 ) AND ( purm.role_id=lcrm.role_id ) WHERE lcom.root_id =? AND (lcrm.content_id IS null OR lcrm.role_id IN(? ) OR purm.user_id = ? ) order by thread_reverse_sequence ASC [ (0=>'399') (1=>'-1') (2=>'0') ]

### Query: 14 NORMAL Start time: 0.01279 ### Query run time: 0.00046

### Query: 15 NORMAL Start time: 0.01329 ### Query run time: 0.00018

### Query: 16 NORMAL Start time: 0.01348 ### Query run time: 0.00017

### Query: 17 NORMAL Start time: 0.01367 ### Query run time: 0.00018

### Query: 18 NORMAL Start time: 0.01387 ### Query run time: 0.00018

(pdo): SELECT FIRST 9 SKIP 0 fgim.*, lc.user_id, lct.*, ufm.favorite_content_id AS is_favorite FROM fisheye_gallery_image_map fgim INNER JOIN liberty_content lc ON ( lc.content_id=fgim.item_content_id ) INNER JOIN liberty_content_types lct ON ( lct.content_type_guid=lc.content_type_guid ) 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 users_favorites_map ufm ON ( ufm.favorite_content_id=lc.content_id AND lc.user_id=ufm.user_id ) WHERE fgim.gallery_content_id = ? AND (lcrm.content_id IS null OR lcrm.role_id IN(? ) OR purm.user_id = ? ) ORDER BY fgim.item_position , fgim.item_content_id [ (0=>'399') (1=>'-1') (2=>'0') ]

### Query: 19 NORMAL Start time: 0.01408 ### Query run time: 0.00096

(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$%'

### Query: 20 NORMAL Start time: 0.01629 ### Query run time: 0.00019

### Query: 21 NORMAL Start time: 0.01649 ### Query run time: 0.00022

(pdo): SELECT pref_name, pref_value FROM liberty_content_prefs WHERE content_id=? [ (0=>'177') ]

### Query: 22 NORMAL Start time: 0.01673 ### Query run time: 0.00019

### Query: 23 NORMAL Start time: 0.01694 ### Query run time: 0.00018

### Query: 24 NORMAL Start time: 0.01713 ### Query run time: 0.00034

/tmp/04/adodb_04cff7a3a9f130f9de3b36316b919457.cache cache failure: Timeout 0 (this is a notice and not an error)

(pdo): SELECT fgim.item_content_id, lc.content_type_guid FROM fisheye_gallery_image_map fgim INNER JOIN liberty_content lc ON ( fgim.item_content_id=lc.content_id ) WHERE fgim.gallery_content_id = ? ORDER BY rand() [ (0=>'177') ]

### Query: 25 NORMAL Start time: 0.01749 ### 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$%'

### Query: 26 NORMAL Start time: 0.01949 ### Query run time: 0.00018

(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=>'224') (1=>'-1') (2=>'-1') ]

### Query: 27 NORMAL Start time: 0.01969 ### Query run time: 0.00076

(pdo): SELECT pref_name, pref_value FROM liberty_content_prefs WHERE content_id=? [ (0=>'224') ]

### Query: 28 NORMAL Start time: 0.02046 ### Query run time: 0.00017

(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=>'224') ]

### Query: 29 NORMAL Start time: 0.02065 ### Query run time: 0.00046

(pdo): SELECT * FROM liberty_attachments la WHERE la.content_id=? ORDER BY la.pos ASC, la.attachment_id ASC [ (0=>'224') ]

### Query: 30 NORMAL Start time: 0.02112 ### Query run time: 0.00028

(pdo): SELECT * FROM liberty_attachments la LEFT OUTER JOIN liberty_files lf ON( la.foreign_id = lf.file_id ) WHERE la.attachment_id=? [ (0=>'224') ]

### Query: 31 NORMAL Start time: 0.02142 ### Query run time: 0.0004

(pdo): SELECT lmtitle.meta_title, lmd.meta_value FROM liberty_attachment_meta_data lmd INNER JOIN liberty_meta_types lmtype ON( lmd.meta_type_id = lmtype.meta_type_id ) INNER JOIN liberty_meta_titles lmtitle ON( lmd.meta_title_id = lmtitle.meta_title_id ) WHERE lmd.attachment_id = ? AND lmtype.meta_type = ? [ (0=>'224') (1=>'exif') ]

### Query: 32 NORMAL Start time: 0.0219 ### Query run time: 0.00054

(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$%'

### Query: 33 NORMAL Start time: 0.02436 ### Query run time: 0.00019

### Query: 34 NORMAL Start time: 0.02456 ### Query run time: 0.00023

(pdo): SELECT pref_name, pref_value FROM liberty_content_prefs WHERE content_id=? [ (0=>'369') ]

### Query: 35 NORMAL Start time: 0.02481 ### Query run time: 0.00019

### Query: 36 NORMAL Start time: 0.02501 ### Query run time: 0.00018

### Query: 37 NORMAL Start time: 0.0252 ### Query run time: 0.00029

/tmp/c0/adodb_c06669d68eec587d21dd2caf6d58a8a1.cache cache failure: Timeout 0 (this is a notice and not an error)

### Query: 38 NORMAL Start time: 0.02551 ### Query run time: 0.00042

(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$%'

### Query: 39 NORMAL Start time: 0.0272 ### Query run time: 0.00019

### Query: 40 NORMAL Start time: 0.02741 ### Query run time: 0.00024

(pdo): SELECT pref_name, pref_value FROM liberty_content_prefs WHERE content_id=? [ (0=>'386') ]

### Query: 41 NORMAL Start time: 0.02766 ### Query run time: 0.00017

### Query: 42 NORMAL Start time: 0.02784 ### 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=>'386') ]

### Query: 43 NORMAL Start time: 0.028 ### Query run time: 0.00019

(pdo): SELECT * FROM liberty_attachments la LEFT OUTER JOIN liberty_files lf ON( la.foreign_id = lf.file_id ) WHERE la.attachment_id=? [ (0=>'386') ]

### Query: 44 NORMAL Start time: 0.0282 ### Query run time: 0.00017

### Query: 45 NORMAL Start time: 0.02844 ### 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 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=>'399') ]

### Query: 46 NORMAL Start time: 0.02931 ### Query run time: 0.00051

(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=>'23') (1=>'399') ]

### Query: 47 NORMAL Start time: 0.02982 ### Query run time: 0.00053

(pdo): SELECT tl.* FROM themes_layouts tl WHERE tl.layout=? ORDER BY pos ASC [ (0=>'fisheye') ]

### Query: 48 NORMAL Start time: 0.03042 ### Query run time: 0.00039

(pdo): SELECT tl.* FROM themes_layouts tl WHERE tl.layout=? ORDER BY pos ASC [ (0=>'kernel') ]

### Query: 49 NORMAL Start time: 0.03083 ### Query run time: 0.00022

Bartholomews Gallery - 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 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: 50 NORMAL Start time: 0.03347 ### Query run time: 0.00054

(pdo): SELECT pref_name, pref_value FROM liberty_content_prefs WHERE content_id=? [ (0=>'1') ]

### Query: 51 NORMAL Start time: 0.03404 ### Query run time: 0.00016

### Query: 52 NORMAL Start time: 0.03421 ### 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 NORMAL Start time: 0.03437 ### Query run time: 0.00016

### Query: 54 NORMAL Start time: 0.03459 ### Query run time: 0.00026

### Query: 55 NORMAL Start time: 0.03485 ### 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$%'

### Query: 56 NORMAL Start time: 0.03631 ### 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: 57 NORMAL Start time: 0.03652 ### 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$%'

### Query: 58 NORMAL Start time: 0.03851 ### Query run time: 0.00019

### Query: 59 NORMAL Start time: 0.03871 ### Query run time: 0.00022

### Query: 60 NORMAL Start time: 0.03895 ### Query run time: 0.00025

### Query: 61 NORMAL Start time: 0.0392 ### 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$%'

### Query: 62 NORMAL Start time: 0.04063 ### Query run time: 0.00019

### Query: 63 NORMAL Start time: 0.04083 ### Query run time: 0.0002

### Query: 64 NORMAL Start time: 0.04105 ### Query run time: 0.00024

### Query: 65 NORMAL Start time: 0.0413 ### 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$%'

### Query: 66 NORMAL Start time: 0.04274 ### 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: 67 NORMAL Start time: 0.04296 ### Query run time: 0.00101

(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$%'

### Query: 68 NORMAL Start time: 0.04525 ### Query run time: 0.0002

### Query: 69 NORMAL Start time: 0.04546 ### 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: 70 NORMAL Start time: 0.04565 ### Query run time: 0.00043

### Query: 71 NORMAL Start time: 0.0461 ### 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: 72 NORMAL Start time: 0.04627 ### Query run time: 0.00016

### Query: 73 NORMAL Start time: 0.04645 ### Query run time: 0.00024

### Query: 74 NORMAL Start time: 0.0467 ### 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$%'

### Query: 75 NORMAL Start time: 0.04938 ### Query run time: 0.00019

### Query: 76 NORMAL Start time: 0.04958 ### Query run time: 0.00021

(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: 77 NORMAL Start time: 0.05048 ### Query run time: 0.00063

(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$%'

### Query: 78 NORMAL Start time: 0.05176 ### Query run time: 0.00019

(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: 79 NORMAL Start time: 0.05196 ### Query run time: 0.00097

### Query: 80 NORMAL Start time: 0.05296 ### Query run time: 0.00025

### Query: 81 NORMAL Start time: 0.05322 ### 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$%'

### Query: 82 NORMAL Start time: 0.05467 ### Query run time: 0.0002

(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: 83 NORMAL Start time: 0.05488 ### Query run time: 0.00079

(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$%'

### Query: 84 NORMAL Start time: 0.05697 ### 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: 85 NORMAL Start time: 0.05717 ### 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$%'

### Query: 122 NORMAL Start time: 0.08046 ### 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: 123 NORMAL Start time: 0.08067 ### 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: 124 NORMAL Start time: 0.08115 ### Query run time: 0.00066

(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=>'1780845138') (2=>'1780845138') ]

### Query: 125 NORMAL Start time: 0.08183 ### Query run time: 0.00046

### Query: 126 NORMAL Start time: 0.08234 ### Query run time: 0.0002

### Query: 127 NORMAL Start time: 0.08258 ### 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$%'

### Query: 134 NORMAL Start time: 0.08603 ### 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: 135 NORMAL Start time: 0.08625 ### Query run time: 0.05296

(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$%'

### Query: 136 NORMAL Start time: 0.14007 ### Query run time: 0.00022

### Query: 137 NORMAL Start time: 0.14032 ### Query run time: 0.05186

(pdo): SELECT fg.gallery_id AS gid, fg.content_id AS cid, lc.title AS gtitle FROM fisheye_gallery fg INNER JOIN liberty_content lc ON (lc.content_id=fg.content_id) INNER JOIN fisheye_gallery_image_map fgim ON (fgim.gallery_content_id=fg.content_id) WHERE fgim.item_content_id=? [ (0=>'399') ]

### Query: 138 NORMAL Start time: 0.19275 ### Query run time: 0.00053

### Query: 139 NORMAL Start time: 0.19329 ### 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$%'

[ (0=>'399') ]

### Query: 140 NORMAL Start time: 0.19426 ### Query run time: 0.00019

Mapping Material
Bartholomews

### Query: 141 NORMAL Start time: 0.19456 ### Query run time: 0.00018

### Query: 142 NORMAL Start time: 0.19487 ### Query run time: 0.00018

### Query: 143 NORMAL Start time: 0.19507 ### Query run time: 0.00017

### Query: 144 NORMAL Start time: 0.19525 ### Query run time: 0.00016

Bartholomews

John Bartholomew Sr. (1805 – April 9, 1861) founded John Bartholomew and Sons in 1828. The John Bartholomew firm produced thousands of maps and rose to become one of the largest and most prolific cartography firms in Scotland.

Bartholomews Covers

Bartholomews Reduced Survey

(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$%'

### Query: 86 NORMAL Start time: 0.05931 ### Query run time: 0.00025

(pdo): SELECT pref_name, pref_value FROM liberty_content_prefs WHERE content_id=? [ (0=>'1') ]

### Query: 87 NORMAL Start time: 0.05958 ### Query run time: 0.00015

### Query: 88 NORMAL Start time: 0.05974 ### 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: 89 NORMAL Start time: 0.05991 ### Query run time: 0.00016

### Query: 90 NORMAL Start time: 0.06011 ### Query run time: 0.00025

### Query: 91 NORMAL Start time: 0.06037 ### 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$%'

### Query: 92 NORMAL Start time: 0.06182 ### Query run time: 0.0002

### Query: 93 NORMAL Start time: 0.06203 ### 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$%'

### Query: 94 NORMAL Start time: 0.06352 ### Query run time: 0.00019

### Query: 95 NORMAL Start time: 0.06372 ### Query run time: 0.00021

### Query: 96 NORMAL Start time: 0.06395 ### Query run time: 0.00024

### Query: 97 NORMAL Start time: 0.0642 ### 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$%'

### Query: 98 NORMAL Start time: 0.06563 ### Query run time: 0.00019

### Query: 99 NORMAL Start time: 0.06583 ### Query run time: 0.0002

### Query: 100 NORMAL Start time: 0.06605 ### Query run time: 0.00024

### Query: 101 NORMAL Start time: 0.0663 ### 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$%'

### Query: 102 NORMAL Start time: 0.06777 ### Query run time: 0.0002

### Query: 103 NORMAL Start time: 0.06799 ### Query run time: 0.00024

(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$%'

### Query: 104 NORMAL Start time: 0.0695 ### Query run time: 0.00019

### Query: 105 NORMAL Start time: 0.06969 ### Query run time: 0.00018

### Query: 106 NORMAL Start time: 0.06988 ### Query run time: 0.0002

### Query: 107 NORMAL Start time: 0.07009 ### Query run time: 0.00015

(pdo): SELECT * FROM liberty_attachments la WHERE la.content_id=? ORDER BY la.pos ASC, la.attachment_id ASC [ (0=>'1') ]

### Query: 108 NORMAL Start time: 0.07026 ### Query run time: 0.00016

### Query: 109 NORMAL Start time: 0.07044 ### Query run time: 0.00024

### Query: 110 NORMAL Start time: 0.07068 ### 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$%'

### Query: 111 NORMAL Start time: 0.07334 ### Query run time: 0.00019

### Query: 112 NORMAL Start time: 0.07354 ### Query run time: 0.00021

(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$%'

### Query: 113 NORMAL Start time: 0.07441 ### 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$%'

### Query: 114 NORMAL Start time: 0.07521 ### Query run time: 0.00017

### Query: 115 NORMAL Start time: 0.0754 ### Query run time: 0.00023

### Query: 116 NORMAL Start time: 0.07564 ### Query run time: 0.00025

### Query: 117 NORMAL Start time: 0.0759 ### 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$%'

### Query: 118 NORMAL Start time: 0.07736 ### Query run time: 0.00019

### Query: 119 NORMAL Start time: 0.07756 ### Query run time: 0.00024

(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$%'

### Query: 120 NORMAL Start time: 0.07907 ### Query run time: 0.00019

### Query: 121 NORMAL Start time: 0.07927 ### 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$%'

### Query: 128 NORMAL Start time: 0.08353 ### Query run time: 0.00019

### Query: 129 NORMAL Start time: 0.08374 ### Query run time: 0.0002

### Query: 130 NORMAL Start time: 0.08396 ### Query run time: 0.0003

### Query: 131 NORMAL Start time: 0.08427 ### Query run time: 0.00017

### Query: 132 NORMAL Start time: 0.0845 ### Query run time: 0.00018

### Query: 133 NORMAL Start time: 0.08472 ### Query run time: 0.00019

Top Visited Blogs