object(Zend_Db_Table_Select)#376 (7) { ["_info":protected]=> array(10) { ["schema"]=> NULL ["name"]=> string(20) "engine4_album_photos" ["cols"]=> array(24) { [0]=> string(8) "photo_id" [1]=> string(8) "album_id" [2]=> string(5) "title" [3]=> string(11) "description" [4]=> string(13) "creation_date" [5]=> string(13) "modified_date" [6]=> string(5) "order" [7]=> string(10) "owner_type" [8]=> string(8) "owner_id" [9]=> string(7) "file_id" [10]=> string(10) "view_count" [11]=> string(13) "comment_count" [12]=> string(10) "like_count" [13]=> string(10) "skip_photo" [14]=> string(10) "photo_hide" [15]=> string(6) "rating" [16]=> string(15) "seao_locationid" [17]=> string(8) "location" [18]=> string(10) "date_taken" [19]=> string(8) "featured" [20]=> string(9) "parent_id" [21]=> string(11) "parent_type" [22]=> string(8) "approved" [23]=> string(8) "resubmit" } ["primary"]=> array(1) { [1]=> string(8) "photo_id" } ["metadata"]=> array(24) { ["photo_id"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(8) "photo_id" ["COLUMN_POSITION"]=> int(1) ["DATA_TYPE"]=> string(12) "int unsigned" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(1) ["IDENTITY"]=> bool(true) } ["album_id"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(8) "album_id" ["COLUMN_POSITION"]=> int(2) ["DATA_TYPE"]=> string(12) "int unsigned" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["title"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(5) "title" ["COLUMN_POSITION"]=> int(3) ["DATA_TYPE"]=> string(7) "varchar" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(3) "128" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["description"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(11) "description" ["COLUMN_POSITION"]=> int(4) ["DATA_TYPE"]=> string(8) "longtext" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["creation_date"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(13) "creation_date" ["COLUMN_POSITION"]=> int(5) ["DATA_TYPE"]=> string(8) "datetime" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["modified_date"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(13) "modified_date" ["COLUMN_POSITION"]=> int(6) ["DATA_TYPE"]=> string(8) "datetime" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["order"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(5) "order" ["COLUMN_POSITION"]=> int(7) ["DATA_TYPE"]=> string(12) "int unsigned" ["DEFAULT"]=> string(1) "0" ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["owner_type"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(10) "owner_type" ["COLUMN_POSITION"]=> int(8) ["DATA_TYPE"]=> string(7) "varchar" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(2) "64" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["owner_id"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(8) "owner_id" ["COLUMN_POSITION"]=> int(9) ["DATA_TYPE"]=> string(12) "int unsigned" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["file_id"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(7) "file_id" ["COLUMN_POSITION"]=> int(10) ["DATA_TYPE"]=> string(12) "int unsigned" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["view_count"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(10) "view_count" ["COLUMN_POSITION"]=> int(11) ["DATA_TYPE"]=> string(12) "int unsigned" ["DEFAULT"]=> string(1) "0" ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["comment_count"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(13) "comment_count" ["COLUMN_POSITION"]=> int(12) ["DATA_TYPE"]=> string(12) "int unsigned" ["DEFAULT"]=> string(1) "0" ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["like_count"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(10) "like_count" ["COLUMN_POSITION"]=> int(13) ["DATA_TYPE"]=> string(12) "int unsigned" ["DEFAULT"]=> string(1) "0" ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["skip_photo"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(10) "skip_photo" ["COLUMN_POSITION"]=> int(14) ["DATA_TYPE"]=> string(7) "tinyint" ["DEFAULT"]=> string(1) "0" ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["photo_hide"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(10) "photo_hide" ["COLUMN_POSITION"]=> int(15) ["DATA_TYPE"]=> string(7) "tinyint" ["DEFAULT"]=> string(1) "0" ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["rating"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(6) "rating" ["COLUMN_POSITION"]=> int(16) ["DATA_TYPE"]=> string(5) "float" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["seao_locationid"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(15) "seao_locationid" ["COLUMN_POSITION"]=> int(17) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["location"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(8) "location" ["COLUMN_POSITION"]=> int(18) ["DATA_TYPE"]=> string(7) "varchar" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(3) "264" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["date_taken"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(10) "date_taken" ["COLUMN_POSITION"]=> int(19) ["DATA_TYPE"]=> string(8) "datetime" ["DEFAULT"]=> string(19) "0000-00-00 00:00:00" ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["featured"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(8) "featured" ["COLUMN_POSITION"]=> int(20) ["DATA_TYPE"]=> string(7) "tinyint" ["DEFAULT"]=> string(1) "0" ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["parent_id"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(9) "parent_id" ["COLUMN_POSITION"]=> int(21) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> string(1) "0" ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["parent_type"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(11) "parent_type" ["COLUMN_POSITION"]=> int(22) ["DATA_TYPE"]=> string(7) "varchar" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(2) "64" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["approved"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(8) "approved" ["COLUMN_POSITION"]=> int(23) ["DATA_TYPE"]=> string(7) "tinyint" ["DEFAULT"]=> string(1) "1" ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["resubmit"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(8) "resubmit" ["COLUMN_POSITION"]=> int(24) ["DATA_TYPE"]=> string(7) "tinyint" ["DEFAULT"]=> string(1) "0" ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } } ["rowClass"]=> string(17) "Album_Model_Photo" ["rowsetClass"]=> string(22) "Engine_Db_Table_Rowset" ["referenceMap"]=> array(0) { } ["dependentTables"]=> array(0) { } ["sequence"]=> bool(true) } ["_integrityCheck":protected]=> bool(false) ["_table":protected]=> object(Album_Model_DbTable_Photos)#400 (22) { ["_rowClass":protected]=> string(17) "Album_Model_Photo" ["_temporyPath":protected]=> string(30) "/public/temporary/album_photos" ["_itemType":protected]=> NULL ["_localItemCache":protected]=> array(0) { } ["_excludedLevels"]=> array(3) { [0]=> int(1) [1]=> int(2) [2]=> int(3) } ["_rowsetClass":protected]=> string(22) "Engine_Db_Table_Rowset" ["_definition":protected]=> NULL ["_definitionConfigName":protected]=> NULL ["_db":protected]=> object(Zend_Db_Adapter_Mysqli)#9 (12) { ["_numericDataTypes":protected]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt":protected]=> object(Zend_Db_Statement_Mysqli)#402 (12) { ["_keys":protected]=> array(1) { [0]=> string(6) "tag_id" } ["_values":protected]=> array(1) { [0]=> &NULL } ["_meta":protected]=> object(mysqli_result)#388 (5) { ["current_field"]=> int(0) ["field_count"]=> int(1) ["lengths"]=> NULL ["num_rows"]=> int(0) ["type"]=> int(1) } ["_stmt":protected]=> object(mysqli_stmt)#398 (10) { ["affected_rows"]=> int(-1) ["insert_id"]=> int(0) ["num_rows"]=> int(0) ["param_count"]=> int(0) ["field_count"]=> int(1) ["errno"]=> int(0) ["error"]=> string(0) "" ["error_list"]=> array(0) { } ["sqlstate"]=> string(5) "00000" ["id"]=> int(29) } ["_adapter":protected]=> *RECURSION* ["_fetchMode":protected]=> int(2) ["_attribute":protected]=> array(0) { } ["_bindColumn":protected]=> array(0) { } ["_bindParam":protected]=> array(0) { } ["_sqlSplit":protected]=> array(1) { [0]=> string(30) "SELECT . FROM WHERE (text = )" } ["_sqlParam":protected]=> array(1) { [0]=> string(30) "SELECT . FROM WHERE (text = )" } ["_queryId":protected]=> int(28) } ["_defaultStmtClass":protected]=> string(24) "Zend_Db_Statement_Mysqli" ["_config":protected]=> array(9) { ["host"]=> string(9) "localhost" ["username"]=> string(14) "truxgone_admin" ["password"]=> string(9) "Zuko12ang" ["dbname"]=> string(15) "truxgone_social" ["charset"]=> string(7) "utf8mb4" ["port"]=> NULL ["persistent"]=> bool(false) ["options"]=> array(3) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) ["fetchMode"]=> int(2) } ["driver_options"]=> array(0) { } } ["_fetchMode":protected]=> int(2) ["_profiler":protected]=> object(Zend_Db_Profiler_Firebug)#11 (8) { ["_label":protected]=> string(24) "Zend_Db_Profiler_Firebug" ["_label_template":protected]=> string(44) "%label% (%totalCount% @ %totalDuration% sec)" ["_message":protected]=> object(Zend_Wildfire_Plugin_FirePhp_TableMessage)#12 (9) { ["_header":protected]=> array(3) { [0]=> string(4) "Time" [1]=> string(5) "Event" [2]=> string(10) "Parameters" } ["_rows":protected]=> array(29) { [0]=> array(3) { [0]=> string(7) "0.00011" [1]=> string(23) "SET time_zone = '+0:00'" [2]=> NULL } [1]=> array(3) { [0]=> string(6) "7.0E-5" [1]=> string(17) "SET SQL_MODE = ''" [2]=> NULL } [2]=> array(3) { [0]=> string(7) "0.00035" [1]=> string(103) "SELECT `engine4_core_settings`.`value` FROM `engine4_core_settings` WHERE (`name` = 'core.log.adapter')" [2]=> NULL } [3]=> array(3) { [0]=> string(7) "0.00117" [1]=> string(99) "SELECT `engine4_core_settings`.`name`, `engine4_core_settings`.`value` FROM `engine4_core_settings`" [2]=> NULL } [4]=> array(3) { [0]=> string(7) "0.00042" [1]=> string(86) "SELECT `engine4_core_modules`.`name` FROM `engine4_core_modules` WHERE (enabled = '1')" [2]=> NULL } [5]=> array(3) { [0]=> string(7) "0.00018" [1]=> string(115) "SELECT `engine4_core_routes`.`name`, `engine4_core_routes`.`config` FROM `engine4_core_routes` ORDER BY `order` ASC" [2]=> NULL } [6]=> array(3) { [0]=> string(7) "0.00024" [1]=> string(84) "SELECT `engine4_core_themes`.* FROM `engine4_core_themes` WHERE (active = 1) LIMIT 1" [2]=> NULL } [7]=> array(3) { [0]=> string(7) "0.00018" [1]=> string(109) "SELECT `engine4_core_settings`.`value` FROM `engine4_core_settings` WHERE (`name` = 'core.translate.adapter')" [2]=> NULL } [8]=> array(3) { [0]=> string(7) "0.00027" [1]=> string(136) "SELECT `engine4_core_session`.* FROM `engine4_core_session` WHERE (((`engine4_core_session`.`id` = '1f4a49b5d052566c19a7ac0ccb157f1f')))" [2]=> NULL } [9]=> array(3) { [0]=> string(7) "0.00031" [1]=> string(144) "UPDATE `engine4_user_online` SET `active` = ? WHERE (user_id = 0) AND (ip = UNHEX('12dadae6')) AND (active > DATE_SUB(NOW(),INTERVAL 20 MINUTE))" [2]=> array(1) { [1]=> string(19) "2024-05-03 10:38:04" } } [10]=> array(3) { [0]=> string(7) "0.00187" [1]=> string(121) "INSERT IGNORE INTO `engine4_user_online` (`user_id`, `ip`, `active`) VALUES (0, UNHEX('12dadae6'), '2024-05-03 10:38:04')" [2]=> NULL } [11]=> array(3) { [0]=> string(7) "0.00038" [1]=> string(92) "SELECT `engine4_core_languages`.`enabled` FROM `engine4_core_languages` WHERE (code ='auto')" [2]=> NULL } [12]=> array(3) { [0]=> string(7) "0.00021" [1]=> string(72) "SELECT `engine4_core_bannedwords`.`word` FROM `engine4_core_bannedwords`" [2]=> NULL } [13]=> array(3) { [0]=> string(7) "0.00022" [1]=> string(63) "SELECT `engine4_core_bannedips`.* FROM `engine4_core_bannedips`" [2]=> NULL } [14]=> array(3) { [0]=> string(7) "0.00227" [1]=> string(119) "UPDATE `engine4_core_statistics` SET `value` = value + 1 WHERE (type = 'core.views') AND (date = '2024-05-03 10:00:00')" [2]=> NULL } [15]=> array(3) { [0]=> string(7) "0.00036" [1]=> string(135) "SELECT `engine4_core_pages`.* FROM `engine4_core_pages` WHERE (name = 'core_hashtag_index') OR (page_id = 'core_hashtag_index') LIMIT 1" [2]=> NULL } [16]=> array(3) { [0]=> string(7) "0.00029" [1]=> string(135) "SELECT `engine4_core_pages`.* FROM `engine4_core_pages` WHERE (name = 'core_hashtag_index') OR (page_id = 'core_hashtag_index') LIMIT 1" [2]=> NULL } [17]=> array(3) { [0]=> string(7) "0.00032" [1]=> string(100) "SELECT `engine4_core_content`.* FROM `engine4_core_content` WHERE (page_id = 9) ORDER BY `order` ASC" [2]=> NULL } [18]=> array(3) { [0]=> string(7) "0.15457" [1]=> string(247) "SELECT `engine4_core_tags`.*, count(*) AS `tagmap_count` FROM `engine4_core_tags` INNER JOIN `engine4_core_tagmaps` ON engine4_core_tags.tag_id=engine4_core_tagmaps.tag_id GROUP BY `tag_id` ORDER BY `tag_count` desc, `modified_date` desc LIMIT 10" [2]=> NULL } [19]=> array(3) { [0]=> string(7) "0.00029" [1]=> string(107) "SELECT `engine4_authorization_levels`.* FROM `engine4_authorization_levels` WHERE (type = 'public') LIMIT 1" [2]=> NULL } [20]=> array(3) { [0]=> string(7) "0.00022" [1]=> string(155) "SELECT `engine4_authorization_permissions`.* FROM `engine4_authorization_permissions` WHERE (level_id = 5) AND (type = 'user') AND (name = 'block') LIMIT 1" [2]=> NULL } [21]=> array(3) { [0]=> string(7) "0.00026" [1]=> string(155) "SELECT `engine4_authorization_permissions`.* FROM `engine4_authorization_permissions` WHERE (level_id = 5) AND (type = 'user') AND (name = 'block') LIMIT 1" [2]=> NULL } [22]=> array(3) { [0]=> string(7) "0.00017" [1]=> string(161) "SELECT `engine4_authorization_permissions`.* FROM `engine4_authorization_permissions` WHERE (level_id = 5) AND (type = 'core_link') AND (name = 'create') LIMIT 1" [2]=> NULL } [23]=> array(3) { [0]=> string(7) "0.00017" [1]=> string(166) "SELECT `engine4_authorization_permissions`.* FROM `engine4_authorization_permissions` WHERE (level_id = 5) AND (type = 'music_playlist') AND (name = 'create') LIMIT 1" [2]=> NULL } [24]=> array(3) { [0]=> string(7) "0.00017" [1]=> string(157) "SELECT `engine4_authorization_permissions`.* FROM `engine4_authorization_permissions` WHERE (level_id = 5) AND (type = 'video') AND (name = 'create') LIMIT 1" [2]=> NULL } [25]=> array(3) { [0]=> string(6) "0.0003" [1]=> string(155) "SELECT `engine4_authorization_permissions`.* FROM `engine4_authorization_permissions` WHERE (level_id = 5) AND (type = 'album') AND (name = 'view') LIMIT 1" [2]=> NULL } [26]=> array(3) { [0]=> string(7) "0.00054" [1]=> string(307) "SELECT `engine4_core_content`.`content_id`, `engine4_core_pages`.* FROM `engine4_core_content` LEFT JOIN `engine4_core_pages` ON engine4_core_pages.page_id = engine4_core_content.page_id WHERE (engine4_core_pages.name = 'core_hashtag_index') AND (engine4_core_content.name = 'album.hashtag-search-results')" [2]=> NULL } [27]=> array(3) { [0]=> string(6) "0.1506" [1]=> string(161) "SELECT `engine4_album_albums`.`album_id` FROM `engine4_album_albums` WHERE (view_privacy = 'everyone') AND (search = 1) AND (networks IS NULL || networks = "" )" [2]=> NULL } [28]=> array(3) { [0]=> string(7) "0.00041" [1]=> string(97) "SELECT `engine4_core_tags`.`tag_id` FROM `engine4_core_tags` WHERE (text = 'cartoons_on_sonyliv')" [2]=> NULL } } ["_style":protected]=> string(5) "TABLE" ["_label":protected]=> string(43) "Zend_Db_Profiler_Firebug (29 @ 0.31694 sec)" ["_message":protected]=> NULL ["_buffered":protected]=> bool(true) ["_destroy":protected]=> bool(false) ["_ruid":protected]=> string(32) "298345b5759226b87380cbe437bac2e5" ["_options":protected]=> array(2) { ["traceOffset"]=> NULL ["includeLineNumbers"]=> bool(false) } } ["_totalElapsedTime":protected]=> float(0.3169372081756591796875) ["_queryProfiles":protected]=> array(29) { [0]=> object(Zend_Db_Profiler_Query)#20 (5) { ["_query":protected]=> string(23) "SET time_zone = '+0:00'" ["_queryType":protected]=> int(2) ["_startedMicrotime":protected]=> float(1714732684.5897428989410400390625) ["_endedMicrotime":protected]=> float(1714732684.589848041534423828125) ["_boundParams":protected]=> array(0) { } } [1]=> object(Zend_Db_Profiler_Query)#22 (5) { ["_query":protected]=> string(17) "SET SQL_MODE = ''" ["_queryType":protected]=> int(2) ["_startedMicrotime":protected]=> float(1714732684.589992046356201171875) ["_endedMicrotime":protected]=> float(1714732684.5900669097900390625) ["_boundParams":protected]=> array(0) { } } [2]=> object(Zend_Db_Profiler_Query)#34 (5) { ["_query":protected]=> string(103) "SELECT `engine4_core_settings`.`value` FROM `engine4_core_settings` WHERE (`name` = 'core.log.adapter')" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732684.59294795989990234375) ["_endedMicrotime":protected]=> float(1714732684.59329509735107421875) ["_boundParams":protected]=> array(0) { } } [3]=> object(Zend_Db_Profiler_Query)#38 (5) { ["_query":protected]=> string(99) "SELECT `engine4_core_settings`.`name`, `engine4_core_settings`.`value` FROM `engine4_core_settings`" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732684.59578609466552734375) ["_endedMicrotime":protected]=> float(1714732684.5969541072845458984375) ["_boundParams":protected]=> array(0) { } } [4]=> object(Zend_Db_Profiler_Query)#47 (5) { ["_query":protected]=> string(86) "SELECT `engine4_core_modules`.`name` FROM `engine4_core_modules` WHERE (enabled = '1')" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732684.6057679653167724609375) ["_endedMicrotime":protected]=> float(1714732684.6061840057373046875) ["_boundParams":protected]=> array(0) { } } [5]=> object(Zend_Db_Profiler_Query)#87 (5) { ["_query":protected]=> string(115) "SELECT `engine4_core_routes`.`name`, `engine4_core_routes`.`config` FROM `engine4_core_routes` ORDER BY `order` ASC" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732684.611896038055419921875) ["_endedMicrotime":protected]=> float(1714732684.6120789051055908203125) ["_boundParams":protected]=> array(0) { } } [6]=> object(Zend_Db_Profiler_Query)#130 (5) { ["_query":protected]=> string(84) "SELECT `engine4_core_themes`.* FROM `engine4_core_themes` WHERE (active = 1) LIMIT 1" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732684.61444091796875) ["_endedMicrotime":protected]=> float(1714732684.61468410491943359375) ["_boundParams":protected]=> array(0) { } } [7]=> object(Zend_Db_Profiler_Query)#153 (5) { ["_query":protected]=> string(109) "SELECT `engine4_core_settings`.`value` FROM `engine4_core_settings` WHERE (`name` = 'core.translate.adapter')" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732684.6155579090118408203125) ["_endedMicrotime":protected]=> float(1714732684.6157360076904296875) ["_boundParams":protected]=> array(0) { } } [8]=> object(Zend_Db_Profiler_Query)#221 (5) { ["_query":protected]=> string(136) "SELECT `engine4_core_session`.* FROM `engine4_core_session` WHERE (((`engine4_core_session`.`id` = '1f4a49b5d052566c19a7ac0ccb157f1f')))" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732684.7884089946746826171875) ["_endedMicrotime":protected]=> float(1714732684.7886810302734375) ["_boundParams":protected]=> array(0) { } } [9]=> object(Zend_Db_Profiler_Query)#228 (5) { ["_query":protected]=> string(144) "UPDATE `engine4_user_online` SET `active` = ? WHERE (user_id = 0) AND (ip = UNHEX('12dadae6')) AND (active > DATE_SUB(NOW(),INTERVAL 20 MINUTE))" ["_queryType":protected]=> int(8) ["_startedMicrotime":protected]=> float(1714732684.7934930324554443359375) ["_endedMicrotime":protected]=> float(1714732684.7938079833984375) ["_boundParams":protected]=> array(1) { [1]=> string(19) "2024-05-03 10:38:04" } } [10]=> object(Zend_Db_Profiler_Query)#152 (5) { ["_query":protected]=> string(121) "INSERT IGNORE INTO `engine4_user_online` (`user_id`, `ip`, `active`) VALUES (0, UNHEX('12dadae6'), '2024-05-03 10:38:04')" ["_queryType":protected]=> int(4) ["_startedMicrotime":protected]=> float(1714732684.795423030853271484375) ["_endedMicrotime":protected]=> float(1714732684.797297000885009765625) ["_boundParams":protected]=> array(0) { } } [11]=> object(Zend_Db_Profiler_Query)#233 (5) { ["_query":protected]=> string(92) "SELECT `engine4_core_languages`.`enabled` FROM `engine4_core_languages` WHERE (code ='auto')" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732684.8021199703216552734375) ["_endedMicrotime":protected]=> float(1714732684.80249500274658203125) ["_boundParams":protected]=> array(0) { } } [12]=> object(Zend_Db_Profiler_Query)#234 (5) { ["_query":protected]=> string(72) "SELECT `engine4_core_bannedwords`.`word` FROM `engine4_core_bannedwords`" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732684.8151199817657470703125) ["_endedMicrotime":protected]=> float(1714732684.815332889556884765625) ["_boundParams":protected]=> array(0) { } } [13]=> object(Zend_Db_Profiler_Query)#240 (5) { ["_query":protected]=> string(63) "SELECT `engine4_core_bannedips`.* FROM `engine4_core_bannedips`" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732684.8156850337982177734375) ["_endedMicrotime":protected]=> float(1714732684.8159029483795166015625) ["_boundParams":protected]=> array(0) { } } [14]=> object(Zend_Db_Profiler_Query)#258 (5) { ["_query":protected]=> string(119) "UPDATE `engine4_core_statistics` SET `value` = value + 1 WHERE (type = 'core.views') AND (date = '2024-05-03 10:00:00')" ["_queryType":protected]=> int(8) ["_startedMicrotime":protected]=> float(1714732684.817390918731689453125) ["_endedMicrotime":protected]=> float(1714732684.8196620941162109375) ["_boundParams":protected]=> array(0) { } } [15]=> object(Zend_Db_Profiler_Query)#262 (5) { ["_query":protected]=> string(135) "SELECT `engine4_core_pages`.* FROM `engine4_core_pages` WHERE (name = 'core_hashtag_index') OR (page_id = 'core_hashtag_index') LIMIT 1" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732684.8219950199127197265625) ["_endedMicrotime":protected]=> float(1714732684.8223590850830078125) ["_boundParams":protected]=> array(0) { } } [16]=> object(Zend_Db_Profiler_Query)#260 (5) { ["_query":protected]=> string(135) "SELECT `engine4_core_pages`.* FROM `engine4_core_pages` WHERE (name = 'core_hashtag_index') OR (page_id = 'core_hashtag_index') LIMIT 1" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732684.82277393341064453125) ["_endedMicrotime":protected]=> float(1714732684.8230659961700439453125) ["_boundParams":protected]=> array(0) { } } [17]=> object(Zend_Db_Profiler_Query)#266 (5) { ["_query":protected]=> string(100) "SELECT `engine4_core_content`.* FROM `engine4_core_content` WHERE (page_id = 9) ORDER BY `order` ASC" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732684.8247759342193603515625) ["_endedMicrotime":protected]=> float(1714732684.82510089874267578125) ["_boundParams":protected]=> array(0) { } } [18]=> object(Zend_Db_Profiler_Query)#349 (5) { ["_query":protected]=> string(247) "SELECT `engine4_core_tags`.*, count(*) AS `tagmap_count` FROM `engine4_core_tags` INNER JOIN `engine4_core_tagmaps` ON engine4_core_tags.tag_id=engine4_core_tagmaps.tag_id GROUP BY `tag_id` ORDER BY `tag_count` desc, `modified_date` desc LIMIT 10" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732684.834392070770263671875) ["_endedMicrotime":protected]=> float(1714732684.98896503448486328125) ["_boundParams":protected]=> array(0) { } } [19]=> object(Zend_Db_Profiler_Query)#366 (5) { ["_query":protected]=> string(107) "SELECT `engine4_authorization_levels`.* FROM `engine4_authorization_levels` WHERE (type = 'public') LIMIT 1" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732684.992610931396484375) ["_endedMicrotime":protected]=> float(1714732684.9929029941558837890625) ["_boundParams":protected]=> array(0) { } } [20]=> object(Zend_Db_Profiler_Query)#367 (5) { ["_query":protected]=> string(155) "SELECT `engine4_authorization_permissions`.* FROM `engine4_authorization_permissions` WHERE (level_id = 5) AND (type = 'user') AND (name = 'block') LIMIT 1" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732684.99452304840087890625) ["_endedMicrotime":protected]=> float(1714732684.9947459697723388671875) ["_boundParams":protected]=> array(0) { } } [21]=> object(Zend_Db_Profiler_Query)#372 (5) { ["_query":protected]=> string(155) "SELECT `engine4_authorization_permissions`.* FROM `engine4_authorization_permissions` WHERE (level_id = 5) AND (type = 'user') AND (name = 'block') LIMIT 1" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732684.995276927947998046875) ["_endedMicrotime":protected]=> float(1714732684.9955360889434814453125) ["_boundParams":protected]=> array(0) { } } [22]=> object(Zend_Db_Profiler_Query)#276 (5) { ["_query":protected]=> string(161) "SELECT `engine4_authorization_permissions`.* FROM `engine4_authorization_permissions` WHERE (level_id = 5) AND (type = 'core_link') AND (name = 'create') LIMIT 1" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732684.9960010051727294921875) ["_endedMicrotime":protected]=> float(1714732684.9961750507354736328125) ["_boundParams":protected]=> array(0) { } } [23]=> object(Zend_Db_Profiler_Query)#348 (5) { ["_query":protected]=> string(166) "SELECT `engine4_authorization_permissions`.* FROM `engine4_authorization_permissions` WHERE (level_id = 5) AND (type = 'music_playlist') AND (name = 'create') LIMIT 1" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732684.996550083160400390625) ["_endedMicrotime":protected]=> float(1714732684.9967229366302490234375) ["_boundParams":protected]=> array(0) { } } [24]=> object(Zend_Db_Profiler_Query)#365 (5) { ["_query":protected]=> string(157) "SELECT `engine4_authorization_permissions`.* FROM `engine4_authorization_permissions` WHERE (level_id = 5) AND (type = 'video') AND (name = 'create') LIMIT 1" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732684.9970829486846923828125) ["_endedMicrotime":protected]=> float(1714732684.997252941131591796875) ["_boundParams":protected]=> array(0) { } } [25]=> object(Zend_Db_Profiler_Query)#390 (5) { ["_query":protected]=> string(155) "SELECT `engine4_authorization_permissions`.* FROM `engine4_authorization_permissions` WHERE (level_id = 5) AND (type = 'album') AND (name = 'view') LIMIT 1" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732684.9989490509033203125) ["_endedMicrotime":protected]=> float(1714732684.9992458820343017578125) ["_boundParams":protected]=> array(0) { } } [26]=> object(Zend_Db_Profiler_Query)#393 (5) { ["_query":protected]=> string(307) "SELECT `engine4_core_content`.`content_id`, `engine4_core_pages`.* FROM `engine4_core_content` LEFT JOIN `engine4_core_pages` ON engine4_core_pages.page_id = engine4_core_content.page_id WHERE (engine4_core_pages.name = 'core_hashtag_index') AND (engine4_core_content.name = 'album.hashtag-search-results')" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732684.999969959259033203125) ["_endedMicrotime":protected]=> float(1714732685.000504970550537109375) ["_boundParams":protected]=> array(0) { } } [27]=> object(Zend_Db_Profiler_Query)#401 (5) { ["_query":protected]=> string(161) "SELECT `engine4_album_albums`.`album_id` FROM `engine4_album_albums` WHERE (view_privacy = 'everyone') AND (search = 1) AND (networks IS NULL || networks = "" )" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732685.0059680938720703125) ["_endedMicrotime":protected]=> float(1714732685.156569957733154296875) ["_boundParams":protected]=> array(0) { } } [28]=> object(Zend_Db_Profiler_Query)#397 (5) { ["_query":protected]=> string(97) "SELECT `engine4_core_tags`.`tag_id` FROM `engine4_core_tags` WHERE (text = 'cartoons_on_sonyliv')" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732685.157146930694580078125) ["_endedMicrotime":protected]=> float(1714732685.1575520038604736328125) ["_boundParams":protected]=> array(0) { } } } ["_enabled":protected]=> bool(true) ["_filterElapsedSecs":protected]=> NULL ["_filterTypes":protected]=> NULL } ["_defaultProfilerClass":protected]=> string(16) "Zend_Db_Profiler" ["_connection":protected]=> object(mysqli)#10 (18) { ["affected_rows"]=> int(24) ["client_info"]=> string(14) "mysqlnd 8.0.30" ["client_version"]=> int(80030) ["connect_errno"]=> int(0) ["connect_error"]=> NULL ["errno"]=> int(0) ["error"]=> string(0) "" ["error_list"]=> array(0) { } ["field_count"]=> int(6) ["host_info"]=> string(25) "Localhost via UNIX socket" ["info"]=> NULL ["insert_id"]=> int(0) ["server_info"]=> string(6) "8.0.37" ["server_version"]=> int(80037) ["sqlstate"]=> string(5) "00000" ["protocol_version"]=> int(10) ["thread_id"]=> int(397600) ["warning_count"]=> int(0) } ["_caseFolding":protected]=> int(0) ["_autoQuoteIdentifiers":protected]=> bool(true) ["_allowSerialization":protected]=> bool(true) ["_autoReconnectOnUnserialize":protected]=> bool(false) } ["_schema":protected]=> NULL ["_name":protected]=> string(20) "engine4_album_photos" ["_cols":protected]=> array(24) { [0]=> string(8) "photo_id" [1]=> string(8) "album_id" [2]=> string(5) "title" [3]=> string(11) "description" [4]=> string(13) "creation_date" [5]=> string(13) "modified_date" [6]=> string(5) "order" [7]=> string(10) "owner_type" [8]=> string(8) "owner_id" [9]=> string(7) "file_id" [10]=> string(10) "view_count" [11]=> string(13) "comment_count" [12]=> string(10) "like_count" [13]=> string(10) "skip_photo" [14]=> string(10) "photo_hide" [15]=> string(6) "rating" [16]=> string(15) "seao_locationid" [17]=> string(8) "location" [18]=> string(10) "date_taken" [19]=> string(8) "featured" [20]=> string(9) "parent_id" [21]=> string(11) "parent_type" [22]=> string(8) "approved" [23]=> string(8) "resubmit" } ["_primary":protected]=> array(1) { [1]=> string(8) "photo_id" } ["_identity":protected]=> int(1) ["_sequence":protected]=> bool(true) ["_metadata":protected]=> array(24) { ["photo_id"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(8) "photo_id" ["COLUMN_POSITION"]=> int(1) ["DATA_TYPE"]=> string(12) "int unsigned" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(true) ["PRIMARY_POSITION"]=> int(1) ["IDENTITY"]=> bool(true) } ["album_id"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(8) "album_id" ["COLUMN_POSITION"]=> int(2) ["DATA_TYPE"]=> string(12) "int unsigned" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["title"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(5) "title" ["COLUMN_POSITION"]=> int(3) ["DATA_TYPE"]=> string(7) "varchar" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(3) "128" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["description"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(11) "description" ["COLUMN_POSITION"]=> int(4) ["DATA_TYPE"]=> string(8) "longtext" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["creation_date"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(13) "creation_date" ["COLUMN_POSITION"]=> int(5) ["DATA_TYPE"]=> string(8) "datetime" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["modified_date"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(13) "modified_date" ["COLUMN_POSITION"]=> int(6) ["DATA_TYPE"]=> string(8) "datetime" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["order"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(5) "order" ["COLUMN_POSITION"]=> int(7) ["DATA_TYPE"]=> string(12) "int unsigned" ["DEFAULT"]=> string(1) "0" ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["owner_type"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(10) "owner_type" ["COLUMN_POSITION"]=> int(8) ["DATA_TYPE"]=> string(7) "varchar" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(2) "64" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["owner_id"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(8) "owner_id" ["COLUMN_POSITION"]=> int(9) ["DATA_TYPE"]=> string(12) "int unsigned" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["file_id"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(7) "file_id" ["COLUMN_POSITION"]=> int(10) ["DATA_TYPE"]=> string(12) "int unsigned" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["view_count"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(10) "view_count" ["COLUMN_POSITION"]=> int(11) ["DATA_TYPE"]=> string(12) "int unsigned" ["DEFAULT"]=> string(1) "0" ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["comment_count"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(13) "comment_count" ["COLUMN_POSITION"]=> int(12) ["DATA_TYPE"]=> string(12) "int unsigned" ["DEFAULT"]=> string(1) "0" ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["like_count"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(10) "like_count" ["COLUMN_POSITION"]=> int(13) ["DATA_TYPE"]=> string(12) "int unsigned" ["DEFAULT"]=> string(1) "0" ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> bool(true) ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["skip_photo"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(10) "skip_photo" ["COLUMN_POSITION"]=> int(14) ["DATA_TYPE"]=> string(7) "tinyint" ["DEFAULT"]=> string(1) "0" ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["photo_hide"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(10) "photo_hide" ["COLUMN_POSITION"]=> int(15) ["DATA_TYPE"]=> string(7) "tinyint" ["DEFAULT"]=> string(1) "0" ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["rating"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(6) "rating" ["COLUMN_POSITION"]=> int(16) ["DATA_TYPE"]=> string(5) "float" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["seao_locationid"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(15) "seao_locationid" ["COLUMN_POSITION"]=> int(17) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["location"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(8) "location" ["COLUMN_POSITION"]=> int(18) ["DATA_TYPE"]=> string(7) "varchar" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(false) ["LENGTH"]=> string(3) "264" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["date_taken"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(10) "date_taken" ["COLUMN_POSITION"]=> int(19) ["DATA_TYPE"]=> string(8) "datetime" ["DEFAULT"]=> string(19) "0000-00-00 00:00:00" ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["featured"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(8) "featured" ["COLUMN_POSITION"]=> int(20) ["DATA_TYPE"]=> string(7) "tinyint" ["DEFAULT"]=> string(1) "0" ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["parent_id"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(9) "parent_id" ["COLUMN_POSITION"]=> int(21) ["DATA_TYPE"]=> string(3) "int" ["DEFAULT"]=> string(1) "0" ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["parent_type"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(11) "parent_type" ["COLUMN_POSITION"]=> int(22) ["DATA_TYPE"]=> string(7) "varchar" ["DEFAULT"]=> NULL ["NULLABLE"]=> bool(true) ["LENGTH"]=> string(2) "64" ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["approved"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(8) "approved" ["COLUMN_POSITION"]=> int(23) ["DATA_TYPE"]=> string(7) "tinyint" ["DEFAULT"]=> string(1) "1" ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } ["resubmit"]=> array(14) { ["SCHEMA_NAME"]=> NULL ["TABLE_NAME"]=> string(20) "engine4_album_photos" ["COLUMN_NAME"]=> string(8) "resubmit" ["COLUMN_POSITION"]=> int(24) ["DATA_TYPE"]=> string(7) "tinyint" ["DEFAULT"]=> string(1) "0" ["NULLABLE"]=> bool(false) ["LENGTH"]=> NULL ["SCALE"]=> NULL ["PRECISION"]=> NULL ["UNSIGNED"]=> NULL ["PRIMARY"]=> bool(false) ["PRIMARY_POSITION"]=> NULL ["IDENTITY"]=> bool(false) } } ["_metadataCache":protected]=> object(Zend_Cache_Core)#26 (6) { ["_backend":protected]=> object(Zend_Cache_Backend_File)#24 (3) { ["_options":protected]=> array(9) { ["cache_dir"]=> string(44) "/home/truxgonet/public_html/temporary/cache/" ["file_locking"]=> bool(true) ["read_control"]=> bool(true) ["read_control_type"]=> string(5) "crc32" ["hashed_directory_level"]=> int(0) ["hashed_directory_perm"]=> int(448) ["file_name_prefix"]=> string(10) "zend_cache" ["cache_file_perm"]=> int(384) ["metadatas_array_max_size"]=> int(100) } ["_metadatasArray":protected]=> array(0) { } ["_directives":protected]=> array(3) { ["lifetime"]=> string(3) "300" ["logging"]=> bool(false) ["logger"]=> NULL } } ["_options":protected]=> array(9) { ["write_control"]=> bool(true) ["caching"]=> bool(false) ["cache_id_prefix"]=> string(19) "Engine4_1105509142_" ["automatic_serialization"]=> bool(true) ["automatic_cleaning_factor"]=> int(10) ["lifetime"]=> string(3) "300" ["logging"]=> bool(false) ["logger"]=> NULL ["ignore_user_abort"]=> bool(false) } ["_specificOptions":protected]=> array(0) { } ["_lastId":"Zend_Cache_Core":private]=> NULL ["_extendedBackend":protected]=> bool(true) ["_backendCapabilities":protected]=> array(6) { ["automatic_cleaning"]=> bool(true) ["tags"]=> bool(true) ["expired_read"]=> bool(true) ["priority"]=> bool(false) ["infinite_lifetime"]=> bool(true) ["get_list"]=> bool(true) } } ["_metadataCacheInClass":protected]=> bool(true) ["_referenceMap":protected]=> array(0) { } ["_dependentTables":protected]=> array(0) { } ["_defaultSource":protected]=> string(11) "defaultNone" ["_defaultValues":protected]=> array(0) { } } ["_bind":protected]=> array(0) { } ["_adapter":protected]=> object(Zend_Db_Adapter_Mysqli)#9 (12) { ["_numericDataTypes":protected]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt":protected]=> object(Zend_Db_Statement_Mysqli)#402 (12) { ["_keys":protected]=> array(1) { [0]=> string(6) "tag_id" } ["_values":protected]=> array(1) { [0]=> &NULL } ["_meta":protected]=> object(mysqli_result)#388 (5) { ["current_field"]=> int(0) ["field_count"]=> int(1) ["lengths"]=> NULL ["num_rows"]=> int(0) ["type"]=> int(1) } ["_stmt":protected]=> object(mysqli_stmt)#398 (10) { ["affected_rows"]=> int(-1) ["insert_id"]=> int(0) ["num_rows"]=> int(0) ["param_count"]=> int(0) ["field_count"]=> int(1) ["errno"]=> int(0) ["error"]=> string(0) "" ["error_list"]=> array(0) { } ["sqlstate"]=> string(5) "00000" ["id"]=> int(29) } ["_adapter":protected]=> *RECURSION* ["_fetchMode":protected]=> int(2) ["_attribute":protected]=> array(0) { } ["_bindColumn":protected]=> array(0) { } ["_bindParam":protected]=> array(0) { } ["_sqlSplit":protected]=> array(1) { [0]=> string(30) "SELECT . FROM WHERE (text = )" } ["_sqlParam":protected]=> array(1) { [0]=> string(30) "SELECT . FROM WHERE (text = )" } ["_queryId":protected]=> int(28) } ["_defaultStmtClass":protected]=> string(24) "Zend_Db_Statement_Mysqli" ["_config":protected]=> array(9) { ["host"]=> string(9) "localhost" ["username"]=> string(14) "truxgone_admin" ["password"]=> string(9) "Zuko12ang" ["dbname"]=> string(15) "truxgone_social" ["charset"]=> string(7) "utf8mb4" ["port"]=> NULL ["persistent"]=> bool(false) ["options"]=> array(3) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) ["fetchMode"]=> int(2) } ["driver_options"]=> array(0) { } } ["_fetchMode":protected]=> int(2) ["_profiler":protected]=> object(Zend_Db_Profiler_Firebug)#11 (8) { ["_label":protected]=> string(24) "Zend_Db_Profiler_Firebug" ["_label_template":protected]=> string(44) "%label% (%totalCount% @ %totalDuration% sec)" ["_message":protected]=> object(Zend_Wildfire_Plugin_FirePhp_TableMessage)#12 (9) { ["_header":protected]=> array(3) { [0]=> string(4) "Time" [1]=> string(5) "Event" [2]=> string(10) "Parameters" } ["_rows":protected]=> array(29) { [0]=> array(3) { [0]=> string(7) "0.00011" [1]=> string(23) "SET time_zone = '+0:00'" [2]=> NULL } [1]=> array(3) { [0]=> string(6) "7.0E-5" [1]=> string(17) "SET SQL_MODE = ''" [2]=> NULL } [2]=> array(3) { [0]=> string(7) "0.00035" [1]=> string(103) "SELECT `engine4_core_settings`.`value` FROM `engine4_core_settings` WHERE (`name` = 'core.log.adapter')" [2]=> NULL } [3]=> array(3) { [0]=> string(7) "0.00117" [1]=> string(99) "SELECT `engine4_core_settings`.`name`, `engine4_core_settings`.`value` FROM `engine4_core_settings`" [2]=> NULL } [4]=> array(3) { [0]=> string(7) "0.00042" [1]=> string(86) "SELECT `engine4_core_modules`.`name` FROM `engine4_core_modules` WHERE (enabled = '1')" [2]=> NULL } [5]=> array(3) { [0]=> string(7) "0.00018" [1]=> string(115) "SELECT `engine4_core_routes`.`name`, `engine4_core_routes`.`config` FROM `engine4_core_routes` ORDER BY `order` ASC" [2]=> NULL } [6]=> array(3) { [0]=> string(7) "0.00024" [1]=> string(84) "SELECT `engine4_core_themes`.* FROM `engine4_core_themes` WHERE (active = 1) LIMIT 1" [2]=> NULL } [7]=> array(3) { [0]=> string(7) "0.00018" [1]=> string(109) "SELECT `engine4_core_settings`.`value` FROM `engine4_core_settings` WHERE (`name` = 'core.translate.adapter')" [2]=> NULL } [8]=> array(3) { [0]=> string(7) "0.00027" [1]=> string(136) "SELECT `engine4_core_session`.* FROM `engine4_core_session` WHERE (((`engine4_core_session`.`id` = '1f4a49b5d052566c19a7ac0ccb157f1f')))" [2]=> NULL } [9]=> array(3) { [0]=> string(7) "0.00031" [1]=> string(144) "UPDATE `engine4_user_online` SET `active` = ? WHERE (user_id = 0) AND (ip = UNHEX('12dadae6')) AND (active > DATE_SUB(NOW(),INTERVAL 20 MINUTE))" [2]=> array(1) { [1]=> string(19) "2024-05-03 10:38:04" } } [10]=> array(3) { [0]=> string(7) "0.00187" [1]=> string(121) "INSERT IGNORE INTO `engine4_user_online` (`user_id`, `ip`, `active`) VALUES (0, UNHEX('12dadae6'), '2024-05-03 10:38:04')" [2]=> NULL } [11]=> array(3) { [0]=> string(7) "0.00038" [1]=> string(92) "SELECT `engine4_core_languages`.`enabled` FROM `engine4_core_languages` WHERE (code ='auto')" [2]=> NULL } [12]=> array(3) { [0]=> string(7) "0.00021" [1]=> string(72) "SELECT `engine4_core_bannedwords`.`word` FROM `engine4_core_bannedwords`" [2]=> NULL } [13]=> array(3) { [0]=> string(7) "0.00022" [1]=> string(63) "SELECT `engine4_core_bannedips`.* FROM `engine4_core_bannedips`" [2]=> NULL } [14]=> array(3) { [0]=> string(7) "0.00227" [1]=> string(119) "UPDATE `engine4_core_statistics` SET `value` = value + 1 WHERE (type = 'core.views') AND (date = '2024-05-03 10:00:00')" [2]=> NULL } [15]=> array(3) { [0]=> string(7) "0.00036" [1]=> string(135) "SELECT `engine4_core_pages`.* FROM `engine4_core_pages` WHERE (name = 'core_hashtag_index') OR (page_id = 'core_hashtag_index') LIMIT 1" [2]=> NULL } [16]=> array(3) { [0]=> string(7) "0.00029" [1]=> string(135) "SELECT `engine4_core_pages`.* FROM `engine4_core_pages` WHERE (name = 'core_hashtag_index') OR (page_id = 'core_hashtag_index') LIMIT 1" [2]=> NULL } [17]=> array(3) { [0]=> string(7) "0.00032" [1]=> string(100) "SELECT `engine4_core_content`.* FROM `engine4_core_content` WHERE (page_id = 9) ORDER BY `order` ASC" [2]=> NULL } [18]=> array(3) { [0]=> string(7) "0.15457" [1]=> string(247) "SELECT `engine4_core_tags`.*, count(*) AS `tagmap_count` FROM `engine4_core_tags` INNER JOIN `engine4_core_tagmaps` ON engine4_core_tags.tag_id=engine4_core_tagmaps.tag_id GROUP BY `tag_id` ORDER BY `tag_count` desc, `modified_date` desc LIMIT 10" [2]=> NULL } [19]=> array(3) { [0]=> string(7) "0.00029" [1]=> string(107) "SELECT `engine4_authorization_levels`.* FROM `engine4_authorization_levels` WHERE (type = 'public') LIMIT 1" [2]=> NULL } [20]=> array(3) { [0]=> string(7) "0.00022" [1]=> string(155) "SELECT `engine4_authorization_permissions`.* FROM `engine4_authorization_permissions` WHERE (level_id = 5) AND (type = 'user') AND (name = 'block') LIMIT 1" [2]=> NULL } [21]=> array(3) { [0]=> string(7) "0.00026" [1]=> string(155) "SELECT `engine4_authorization_permissions`.* FROM `engine4_authorization_permissions` WHERE (level_id = 5) AND (type = 'user') AND (name = 'block') LIMIT 1" [2]=> NULL } [22]=> array(3) { [0]=> string(7) "0.00017" [1]=> string(161) "SELECT `engine4_authorization_permissions`.* FROM `engine4_authorization_permissions` WHERE (level_id = 5) AND (type = 'core_link') AND (name = 'create') LIMIT 1" [2]=> NULL } [23]=> array(3) { [0]=> string(7) "0.00017" [1]=> string(166) "SELECT `engine4_authorization_permissions`.* FROM `engine4_authorization_permissions` WHERE (level_id = 5) AND (type = 'music_playlist') AND (name = 'create') LIMIT 1" [2]=> NULL } [24]=> array(3) { [0]=> string(7) "0.00017" [1]=> string(157) "SELECT `engine4_authorization_permissions`.* FROM `engine4_authorization_permissions` WHERE (level_id = 5) AND (type = 'video') AND (name = 'create') LIMIT 1" [2]=> NULL } [25]=> array(3) { [0]=> string(6) "0.0003" [1]=> string(155) "SELECT `engine4_authorization_permissions`.* FROM `engine4_authorization_permissions` WHERE (level_id = 5) AND (type = 'album') AND (name = 'view') LIMIT 1" [2]=> NULL } [26]=> array(3) { [0]=> string(7) "0.00054" [1]=> string(307) "SELECT `engine4_core_content`.`content_id`, `engine4_core_pages`.* FROM `engine4_core_content` LEFT JOIN `engine4_core_pages` ON engine4_core_pages.page_id = engine4_core_content.page_id WHERE (engine4_core_pages.name = 'core_hashtag_index') AND (engine4_core_content.name = 'album.hashtag-search-results')" [2]=> NULL } [27]=> array(3) { [0]=> string(6) "0.1506" [1]=> string(161) "SELECT `engine4_album_albums`.`album_id` FROM `engine4_album_albums` WHERE (view_privacy = 'everyone') AND (search = 1) AND (networks IS NULL || networks = "" )" [2]=> NULL } [28]=> array(3) { [0]=> string(7) "0.00041" [1]=> string(97) "SELECT `engine4_core_tags`.`tag_id` FROM `engine4_core_tags` WHERE (text = 'cartoons_on_sonyliv')" [2]=> NULL } } ["_style":protected]=> string(5) "TABLE" ["_label":protected]=> string(43) "Zend_Db_Profiler_Firebug (29 @ 0.31694 sec)" ["_message":protected]=> NULL ["_buffered":protected]=> bool(true) ["_destroy":protected]=> bool(false) ["_ruid":protected]=> string(32) "298345b5759226b87380cbe437bac2e5" ["_options":protected]=> array(2) { ["traceOffset"]=> NULL ["includeLineNumbers"]=> bool(false) } } ["_totalElapsedTime":protected]=> float(0.3169372081756591796875) ["_queryProfiles":protected]=> array(29) { [0]=> object(Zend_Db_Profiler_Query)#20 (5) { ["_query":protected]=> string(23) "SET time_zone = '+0:00'" ["_queryType":protected]=> int(2) ["_startedMicrotime":protected]=> float(1714732684.5897428989410400390625) ["_endedMicrotime":protected]=> float(1714732684.589848041534423828125) ["_boundParams":protected]=> array(0) { } } [1]=> object(Zend_Db_Profiler_Query)#22 (5) { ["_query":protected]=> string(17) "SET SQL_MODE = ''" ["_queryType":protected]=> int(2) ["_startedMicrotime":protected]=> float(1714732684.589992046356201171875) ["_endedMicrotime":protected]=> float(1714732684.5900669097900390625) ["_boundParams":protected]=> array(0) { } } [2]=> object(Zend_Db_Profiler_Query)#34 (5) { ["_query":protected]=> string(103) "SELECT `engine4_core_settings`.`value` FROM `engine4_core_settings` WHERE (`name` = 'core.log.adapter')" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732684.59294795989990234375) ["_endedMicrotime":protected]=> float(1714732684.59329509735107421875) ["_boundParams":protected]=> array(0) { } } [3]=> object(Zend_Db_Profiler_Query)#38 (5) { ["_query":protected]=> string(99) "SELECT `engine4_core_settings`.`name`, `engine4_core_settings`.`value` FROM `engine4_core_settings`" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732684.59578609466552734375) ["_endedMicrotime":protected]=> float(1714732684.5969541072845458984375) ["_boundParams":protected]=> array(0) { } } [4]=> object(Zend_Db_Profiler_Query)#47 (5) { ["_query":protected]=> string(86) "SELECT `engine4_core_modules`.`name` FROM `engine4_core_modules` WHERE (enabled = '1')" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732684.6057679653167724609375) ["_endedMicrotime":protected]=> float(1714732684.6061840057373046875) ["_boundParams":protected]=> array(0) { } } [5]=> object(Zend_Db_Profiler_Query)#87 (5) { ["_query":protected]=> string(115) "SELECT `engine4_core_routes`.`name`, `engine4_core_routes`.`config` FROM `engine4_core_routes` ORDER BY `order` ASC" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732684.611896038055419921875) ["_endedMicrotime":protected]=> float(1714732684.6120789051055908203125) ["_boundParams":protected]=> array(0) { } } [6]=> object(Zend_Db_Profiler_Query)#130 (5) { ["_query":protected]=> string(84) "SELECT `engine4_core_themes`.* FROM `engine4_core_themes` WHERE (active = 1) LIMIT 1" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732684.61444091796875) ["_endedMicrotime":protected]=> float(1714732684.61468410491943359375) ["_boundParams":protected]=> array(0) { } } [7]=> object(Zend_Db_Profiler_Query)#153 (5) { ["_query":protected]=> string(109) "SELECT `engine4_core_settings`.`value` FROM `engine4_core_settings` WHERE (`name` = 'core.translate.adapter')" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732684.6155579090118408203125) ["_endedMicrotime":protected]=> float(1714732684.6157360076904296875) ["_boundParams":protected]=> array(0) { } } [8]=> object(Zend_Db_Profiler_Query)#221 (5) { ["_query":protected]=> string(136) "SELECT `engine4_core_session`.* FROM `engine4_core_session` WHERE (((`engine4_core_session`.`id` = '1f4a49b5d052566c19a7ac0ccb157f1f')))" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732684.7884089946746826171875) ["_endedMicrotime":protected]=> float(1714732684.7886810302734375) ["_boundParams":protected]=> array(0) { } } [9]=> object(Zend_Db_Profiler_Query)#228 (5) { ["_query":protected]=> string(144) "UPDATE `engine4_user_online` SET `active` = ? WHERE (user_id = 0) AND (ip = UNHEX('12dadae6')) AND (active > DATE_SUB(NOW(),INTERVAL 20 MINUTE))" ["_queryType":protected]=> int(8) ["_startedMicrotime":protected]=> float(1714732684.7934930324554443359375) ["_endedMicrotime":protected]=> float(1714732684.7938079833984375) ["_boundParams":protected]=> array(1) { [1]=> string(19) "2024-05-03 10:38:04" } } [10]=> object(Zend_Db_Profiler_Query)#152 (5) { ["_query":protected]=> string(121) "INSERT IGNORE INTO `engine4_user_online` (`user_id`, `ip`, `active`) VALUES (0, UNHEX('12dadae6'), '2024-05-03 10:38:04')" ["_queryType":protected]=> int(4) ["_startedMicrotime":protected]=> float(1714732684.795423030853271484375) ["_endedMicrotime":protected]=> float(1714732684.797297000885009765625) ["_boundParams":protected]=> array(0) { } } [11]=> object(Zend_Db_Profiler_Query)#233 (5) { ["_query":protected]=> string(92) "SELECT `engine4_core_languages`.`enabled` FROM `engine4_core_languages` WHERE (code ='auto')" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732684.8021199703216552734375) ["_endedMicrotime":protected]=> float(1714732684.80249500274658203125) ["_boundParams":protected]=> array(0) { } } [12]=> object(Zend_Db_Profiler_Query)#234 (5) { ["_query":protected]=> string(72) "SELECT `engine4_core_bannedwords`.`word` FROM `engine4_core_bannedwords`" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732684.8151199817657470703125) ["_endedMicrotime":protected]=> float(1714732684.815332889556884765625) ["_boundParams":protected]=> array(0) { } } [13]=> object(Zend_Db_Profiler_Query)#240 (5) { ["_query":protected]=> string(63) "SELECT `engine4_core_bannedips`.* FROM `engine4_core_bannedips`" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732684.8156850337982177734375) ["_endedMicrotime":protected]=> float(1714732684.8159029483795166015625) ["_boundParams":protected]=> array(0) { } } [14]=> object(Zend_Db_Profiler_Query)#258 (5) { ["_query":protected]=> string(119) "UPDATE `engine4_core_statistics` SET `value` = value + 1 WHERE (type = 'core.views') AND (date = '2024-05-03 10:00:00')" ["_queryType":protected]=> int(8) ["_startedMicrotime":protected]=> float(1714732684.817390918731689453125) ["_endedMicrotime":protected]=> float(1714732684.8196620941162109375) ["_boundParams":protected]=> array(0) { } } [15]=> object(Zend_Db_Profiler_Query)#262 (5) { ["_query":protected]=> string(135) "SELECT `engine4_core_pages`.* FROM `engine4_core_pages` WHERE (name = 'core_hashtag_index') OR (page_id = 'core_hashtag_index') LIMIT 1" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732684.8219950199127197265625) ["_endedMicrotime":protected]=> float(1714732684.8223590850830078125) ["_boundParams":protected]=> array(0) { } } [16]=> object(Zend_Db_Profiler_Query)#260 (5) { ["_query":protected]=> string(135) "SELECT `engine4_core_pages`.* FROM `engine4_core_pages` WHERE (name = 'core_hashtag_index') OR (page_id = 'core_hashtag_index') LIMIT 1" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732684.82277393341064453125) ["_endedMicrotime":protected]=> float(1714732684.8230659961700439453125) ["_boundParams":protected]=> array(0) { } } [17]=> object(Zend_Db_Profiler_Query)#266 (5) { ["_query":protected]=> string(100) "SELECT `engine4_core_content`.* FROM `engine4_core_content` WHERE (page_id = 9) ORDER BY `order` ASC" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732684.8247759342193603515625) ["_endedMicrotime":protected]=> float(1714732684.82510089874267578125) ["_boundParams":protected]=> array(0) { } } [18]=> object(Zend_Db_Profiler_Query)#349 (5) { ["_query":protected]=> string(247) "SELECT `engine4_core_tags`.*, count(*) AS `tagmap_count` FROM `engine4_core_tags` INNER JOIN `engine4_core_tagmaps` ON engine4_core_tags.tag_id=engine4_core_tagmaps.tag_id GROUP BY `tag_id` ORDER BY `tag_count` desc, `modified_date` desc LIMIT 10" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732684.834392070770263671875) ["_endedMicrotime":protected]=> float(1714732684.98896503448486328125) ["_boundParams":protected]=> array(0) { } } [19]=> object(Zend_Db_Profiler_Query)#366 (5) { ["_query":protected]=> string(107) "SELECT `engine4_authorization_levels`.* FROM `engine4_authorization_levels` WHERE (type = 'public') LIMIT 1" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732684.992610931396484375) ["_endedMicrotime":protected]=> float(1714732684.9929029941558837890625) ["_boundParams":protected]=> array(0) { } } [20]=> object(Zend_Db_Profiler_Query)#367 (5) { ["_query":protected]=> string(155) "SELECT `engine4_authorization_permissions`.* FROM `engine4_authorization_permissions` WHERE (level_id = 5) AND (type = 'user') AND (name = 'block') LIMIT 1" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732684.99452304840087890625) ["_endedMicrotime":protected]=> float(1714732684.9947459697723388671875) ["_boundParams":protected]=> array(0) { } } [21]=> object(Zend_Db_Profiler_Query)#372 (5) { ["_query":protected]=> string(155) "SELECT `engine4_authorization_permissions`.* FROM `engine4_authorization_permissions` WHERE (level_id = 5) AND (type = 'user') AND (name = 'block') LIMIT 1" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732684.995276927947998046875) ["_endedMicrotime":protected]=> float(1714732684.9955360889434814453125) ["_boundParams":protected]=> array(0) { } } [22]=> object(Zend_Db_Profiler_Query)#276 (5) { ["_query":protected]=> string(161) "SELECT `engine4_authorization_permissions`.* FROM `engine4_authorization_permissions` WHERE (level_id = 5) AND (type = 'core_link') AND (name = 'create') LIMIT 1" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732684.9960010051727294921875) ["_endedMicrotime":protected]=> float(1714732684.9961750507354736328125) ["_boundParams":protected]=> array(0) { } } [23]=> object(Zend_Db_Profiler_Query)#348 (5) { ["_query":protected]=> string(166) "SELECT `engine4_authorization_permissions`.* FROM `engine4_authorization_permissions` WHERE (level_id = 5) AND (type = 'music_playlist') AND (name = 'create') LIMIT 1" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732684.996550083160400390625) ["_endedMicrotime":protected]=> float(1714732684.9967229366302490234375) ["_boundParams":protected]=> array(0) { } } [24]=> object(Zend_Db_Profiler_Query)#365 (5) { ["_query":protected]=> string(157) "SELECT `engine4_authorization_permissions`.* FROM `engine4_authorization_permissions` WHERE (level_id = 5) AND (type = 'video') AND (name = 'create') LIMIT 1" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732684.9970829486846923828125) ["_endedMicrotime":protected]=> float(1714732684.997252941131591796875) ["_boundParams":protected]=> array(0) { } } [25]=> object(Zend_Db_Profiler_Query)#390 (5) { ["_query":protected]=> string(155) "SELECT `engine4_authorization_permissions`.* FROM `engine4_authorization_permissions` WHERE (level_id = 5) AND (type = 'album') AND (name = 'view') LIMIT 1" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732684.9989490509033203125) ["_endedMicrotime":protected]=> float(1714732684.9992458820343017578125) ["_boundParams":protected]=> array(0) { } } [26]=> object(Zend_Db_Profiler_Query)#393 (5) { ["_query":protected]=> string(307) "SELECT `engine4_core_content`.`content_id`, `engine4_core_pages`.* FROM `engine4_core_content` LEFT JOIN `engine4_core_pages` ON engine4_core_pages.page_id = engine4_core_content.page_id WHERE (engine4_core_pages.name = 'core_hashtag_index') AND (engine4_core_content.name = 'album.hashtag-search-results')" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732684.999969959259033203125) ["_endedMicrotime":protected]=> float(1714732685.000504970550537109375) ["_boundParams":protected]=> array(0) { } } [27]=> object(Zend_Db_Profiler_Query)#401 (5) { ["_query":protected]=> string(161) "SELECT `engine4_album_albums`.`album_id` FROM `engine4_album_albums` WHERE (view_privacy = 'everyone') AND (search = 1) AND (networks IS NULL || networks = "" )" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732685.0059680938720703125) ["_endedMicrotime":protected]=> float(1714732685.156569957733154296875) ["_boundParams":protected]=> array(0) { } } [28]=> object(Zend_Db_Profiler_Query)#397 (5) { ["_query":protected]=> string(97) "SELECT `engine4_core_tags`.`tag_id` FROM `engine4_core_tags` WHERE (text = 'cartoons_on_sonyliv')" ["_queryType":protected]=> int(32) ["_startedMicrotime":protected]=> float(1714732685.157146930694580078125) ["_endedMicrotime":protected]=> float(1714732685.1575520038604736328125) ["_boundParams":protected]=> array(0) { } } } ["_enabled":protected]=> bool(true) ["_filterElapsedSecs":protected]=> NULL ["_filterTypes":protected]=> NULL } ["_defaultProfilerClass":protected]=> string(16) "Zend_Db_Profiler" ["_connection":protected]=> object(mysqli)#10 (18) { ["affected_rows"]=> int(24) ["client_info"]=> string(14) "mysqlnd 8.0.30" ["client_version"]=> int(80030) ["connect_errno"]=> int(0) ["connect_error"]=> NULL ["errno"]=> int(0) ["error"]=> string(0) "" ["error_list"]=> array(0) { } ["field_count"]=> int(6) ["host_info"]=> string(25) "Localhost via UNIX socket" ["info"]=> NULL ["insert_id"]=> int(0) ["server_info"]=> string(6) "8.0.37" ["server_version"]=> int(80037) ["sqlstate"]=> string(5) "00000" ["protocol_version"]=> int(10) ["thread_id"]=> int(397600) ["warning_count"]=> int(0) } ["_caseFolding":protected]=> int(0) ["_autoQuoteIdentifiers":protected]=> bool(true) ["_allowSerialization":protected]=> bool(true) ["_autoReconnectOnUnserialize":protected]=> bool(false) } ["_parts":protected]=> array(11) { ["distinct"]=> bool(false) ["columns"]=> array(1) { [0]=> array(3) { [0]=> string(20) "engine4_album_photos" [1]=> object(Zend_Db_Expr)#404 (1) { ["_expression":protected]=> string(38) "COUNT(1) AS `zend_paginator_row_count`" } [2]=> NULL } } ["union"]=> array(0) { } ["from"]=> array(2) { ["engine4_album_photos"]=> array(4) { ["joinType"]=> string(10) "inner join" ["schema"]=> NULL ["tableName"]=> string(20) "engine4_album_photos" ["joinCondition"]=> NULL } ["engine4_album_albums"]=> array(4) { ["joinType"]=> string(9) "left join" ["schema"]=> NULL ["tableName"]=> string(20) "engine4_album_albums" ["joinCondition"]=> string(61) "engine4_album_albums.album_id = engine4_album_photos.album_id" } } ["where"]=> array(2) { [0]=> string(171) "(SELECT COUNT(*) > 0 FROM `engine4_album_albums` WHERE (engine4_album_albums.album_id = engine4_album_photos.album_id) AND (type NOT IN ('group','event') OR type IS NULL))" [1]=> string(38) "AND (engine4_album_albums.approved =1)" } ["group"]=> array(0) { } ["having"]=> array(0) { } ["order"]=> array(0) { } ["limitcount"]=> NULL ["limitoffset"]=> NULL ["forupdate"]=> bool(false) } ["_tableCols":protected]=> array(0) { } }