(pdo): SELECT il.lang_code AS hash_key, il.* FROM i18n_languages il ORDER BY il.lang_code
### Query: 1 NORMAL
Start time: 9.0E-5
### Query run time: 0.00107
(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 NORMAL
Start time: 0.00426
### Query run time: 0.00109
(pdo): SELECT * FROM liberty_attachments la WHERE la.attachment_id=? [ (0=>'188') ]
### Query: 3 NORMAL
Start time: 0.00563
### Query run time: 0.00048
(pdo): SELECT pref_name, pref_value FROM liberty_attachment_prefs WHERE attachment_id = ? [ (0=>'188') ]
### Query: 4 NORMAL
Start time: 0.00612
### Query run time: 0.00033
(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: 5 NORMAL
Start time: 0.00646
### Query run time: 0.00044
(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=>'188') (1=>'exif') ]
### Query: 6 NORMAL
Start time: 0.00698
### Query run time: 0.00058
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(188) % line 28, file: download_file.php
/tmp/77/adodb_7718e923c1f8d87940ee9f19e8891bb7.cache reloaded, ttl=2215 [ SELECT FIRST 1 content_type_guid FROM liberty_content WHERE content_id=? ]
### Query: 7 NORMAL
Start time: 0.00761
### Query run time: 0.0001
(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: 8 NORMAL
Start time: 0.00921
### Query run time: 0.0004
(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: 9 NORMAL
Start time: 0.00963
### Query run time: 0.00131
(pdo): SELECT pref_name, pref_value FROM liberty_content_prefs WHERE content_id=? [ (0=>'188') ]
### Query: 10 NORMAL
Start time: 0.01096
### Query run time: 0.00034
(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: 11 NORMAL
Start time: 0.01131
### Query run time: 0.00029
(pdo): SELECT * FROM liberty_attachments la WHERE la.content_id=? ORDER BY la.pos ASC, la.attachment_id ASC [ (0=>'188') ]
### Query: 12 NORMAL
Start time: 0.01162
### Query run time: 0.0003
(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: 13 NORMAL
Start time: 0.01193
### Query run time: 0.00017
(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=>'188') (1=>'exif') ]
### Query: 14 NORMAL
Start time: 0.01216
### 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: 15 NORMAL
Start time: 0.0124
### 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=>'188') (1=>'0') (2=>'-1') ]
### Query: 16 NORMAL
Start time: 0.01274
### 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: 17 NORMAL
Start time: 0.01329
### Query run time: 0.00043
(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: 18 NORMAL
Start time: 0.01373
### Query run time: 0.00018
(pdo): SELECT * FROM liberty_attachments la WHERE la.attachment_id=? [ (0=>'188') ]
### Query: 19 NORMAL
Start time: 0.01394
### Query run time: 0.0002
(pdo): SELECT pref_name, pref_value FROM liberty_attachment_prefs WHERE attachment_id = ? [ (0=>'188') ]
### Query: 20 NORMAL
Start time: 0.01415
### Query run time: 0.00015
(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: 21 NORMAL
Start time: 0.0143
### Query run time: 0.00018
(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=>'188') (1=>'exif') ]
### Query: 22 NORMAL
Start time: 0.01455
### Query run time: 0.00019
(pdo): SELECT FIRST 1 attachment_id FROM liberty_attachments WHERE attachment_id = ? AND hits IS null [ (0=>'188') ]
### Query: 23 NORMAL
Start time: 0.01476
### Query run time: 0.00024
(pdo): UPDATE liberty_attachments SET hits = hits+1 WHERE attachment_id = ? [ (0=>'188') ]
### Query: 24 NORMAL
Start time: 0.01502
### Query run time: 0.00051