ZFDebug log Log variables Variables database 8 in 10 ms 4892K in 899ms

Event log for eventsController->eventAction() (events module)

830ms2601KStartup - ZFDebug construct()
0ms14KRoute
34ms1182KeventsController::eventAction
63ms1968KDispatch
899ms4796KShutdown

View variables

action => 'event'
controller => 'events'
event => Event Object()
module => 'events'
title => 'Croatia Boat Show'
years =>
0 => 2018
1 => 2017
2 => 2016
3 => 2015
4 => 2014
5 => 2013
6 => 2012
7 => 2011
8 => 2010
9 => 2009
10 => 2008
11 => 2007
12 => 2005
13 => 2004

Request parameters

action => 'event'
controller => 'events'
lang => 'cs'
module => 'events'
rewrite_url => 'croatia-boat-show-2'

Zend Registry

Zend_Controller_Plugin_ActionStack =>
Zend_Locale => Zend_Locale Object()
Zend_Translate => Zend_Translate Object()
Zend_View_Helper_Doctype => ArrayObject Object()
Zend_View_Helper_Placeholder_Registry => Zend_View_Helper_Placeholder_Registry Object()
appType => 'frontend'
config => Zend_Config_Ini Object()
configSection => 'live'
db => Tajfun_Db_Adapter_Pdo_Mysql Object()
lang => 'cs'
locale => Zend_Locale Object()
localeString => 'cs_CZ'
moduleConfig => Zend_Config_Ini Object()
routesConfig => Zend_Config_Ini Object()

Cookies

 

Database queries – Metadata cache ENABLED

0.34ms connect
1.84ms SELECT `events`.*, `entities`.*, `title_translation`.`value_varchar` AS `Xtranslated_title`, `annotation_translation`.`value_text` AS `Xtranslated_annotation`, `text_markup_translation`.`value_text` AS `Xtranslated_text_markup`, `text_translation`.`value_text` AS `Xtranslated_text` FROM `events` INNER JOIN `entities` ON `entities`.entity_id = `events`.entity_id LEFT JOIN `entities_translations` AS `title_translation` ON title_translation.entity_id = entities.entity_id and title_translation.column_key = "title" and title_translation.lang = "cs" LEFT JOIN `entities_translations` AS `annotation_translation` ON annotation_translation.entity_id = entities.entity_id and annotation_translation.column_key = "annotation" and annotation_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_markup_translation` ON text_markup_translation.entity_id = entities.entity_id and text_markup_translation.column_key = "text_markup" and text_markup_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_translation` ON text_translation.entity_id = entities.entity_id and text_translation.column_key = "text" and text_translation.lang = "cs" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (rewrite_url = 'croatia-boat-show-2') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
0.12ms select distinct year(start) as year from events order by start desc
2.33ms SELECT `documents`.*, `entities`.*, `entities_related`.`relation_id`, `entities_related`.`priority` AS `relation_priority`, `name_translation`.`value_varchar` AS `Xtranslated_name`, `description_translation`.`value_text` AS `Xtranslated_description`, `description_markup_translation`.`value_text` AS `Xtranslated_description_markup` FROM `documents` INNER JOIN `entities` ON `entities`.entity_id = `documents`.entity_id INNER JOIN `entities_related` ON entities.entity_id = entities_related.slave_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "cs" LEFT JOIN `entities_translations` AS `description_translation` ON description_translation.entity_id = entities.entity_id and description_translation.column_key = "description" and description_translation.lang = "cs" LEFT JOIN `entities_translations` AS `description_markup_translation` ON description_markup_translation.entity_id = entities.entity_id and description_markup_translation.column_key = "description_markup" and description_markup_translation.lang = "cs" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '123048') AND (relation_type = 'images') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'cs') UNION SELECT `documents`.*, `entities`.*, `entities_related`.`relation_id`, `entities_related`.`priority` AS `relation_priority`, `name_translation`.`value_varchar` AS `Xtranslated_name`, `description_translation`.`value_text` AS `Xtranslated_description`, `description_markup_translation`.`value_text` AS `Xtranslated_description_markup` FROM `documents` INNER JOIN `entities` ON `entities`.entity_id = `documents`.entity_id INNER JOIN `entities_related` ON entities.entity_id = entities_related.master_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "cs" LEFT JOIN `entities_translations` AS `description_translation` ON description_translation.entity_id = entities.entity_id and description_translation.column_key = "description" and description_translation.lang = "cs" LEFT JOIN `entities_translations` AS `description_markup_translation` ON description_markup_translation.entity_id = entities.entity_id and description_markup_translation.column_key = "description_markup" and description_markup_translation.lang = "cs" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '123048') AND (relation_type = 'images') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'cs') ORDER BY `relation_priority` ASC
0.84ms SELECT `pages`.*, `entities`.*, `title_translation`.`value_varchar` AS `Xtranslated_title`, `full_title_translation`.`value_varchar` AS `Xtranslated_full_title`, `text_markup_translation`.`value_longtext` AS `Xtranslated_text_markup`, `text_translation`.`value_longtext` AS `Xtranslated_text` FROM `pages` INNER JOIN `entities` ON `entities`.entity_id = `pages`.entity_id LEFT JOIN `entities_translations` AS `title_translation` ON title_translation.entity_id = entities.entity_id and title_translation.column_key = "title" and title_translation.lang = "cs" LEFT JOIN `entities_translations` AS `full_title_translation` ON full_title_translation.entity_id = entities.entity_id and full_title_translation.column_key = "full_title" and full_title_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_markup_translation` ON text_markup_translation.entity_id = entities.entity_id and text_markup_translation.column_key = "text_markup" and text_markup_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_translation` ON text_translation.entity_id = entities.entity_id and text_translation.column_key = "text" and text_translation.lang = "cs" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (rewrite_url = 'event') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
3.45ms SELECT `pages`.*, `entities`.*, `title_translation`.`value_varchar` AS `Xtranslated_title`, `full_title_translation`.`value_varchar` AS `Xtranslated_full_title`, `text_markup_translation`.`value_longtext` AS `Xtranslated_text_markup`, `text_translation`.`value_longtext` AS `Xtranslated_text` FROM `pages` INNER JOIN `entities` ON `entities`.entity_id = `pages`.entity_id INNER JOIN `pages_folders` ON `pages_folders`.folder_id = `pages`.folder_id LEFT JOIN `entities_translations` AS `title_translation` ON title_translation.entity_id = entities.entity_id and title_translation.column_key = "title" and title_translation.lang = "cs" LEFT JOIN `entities_translations` AS `full_title_translation` ON full_title_translation.entity_id = entities.entity_id and full_title_translation.column_key = "full_title" and full_title_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_markup_translation` ON text_markup_translation.entity_id = entities.entity_id and text_markup_translation.column_key = "text_markup" and text_markup_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_translation` ON text_translation.entity_id = entities.entity_id and text_translation.column_key = "text" and text_translation.lang = "cs" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (parent_id is null) AND (code = 'mainmenu') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 14:02:44')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 14:02:44')) AND ((publish = 1)) AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') ORDER BY `priority` ASC
0.57ms SELECT `pages`.*, `entities`.*, `title_translation`.`value_varchar` AS `Xtranslated_title`, `full_title_translation`.`value_varchar` AS `Xtranslated_full_title`, `text_markup_translation`.`value_longtext` AS `Xtranslated_text_markup`, `text_translation`.`value_longtext` AS `Xtranslated_text` FROM `pages` INNER JOIN `entities` ON `entities`.entity_id = `pages`.entity_id LEFT JOIN `entities_translations` AS `title_translation` ON title_translation.entity_id = entities.entity_id and title_translation.column_key = "title" and title_translation.lang = "cs" LEFT JOIN `entities_translations` AS `full_title_translation` ON full_title_translation.entity_id = entities.entity_id and full_title_translation.column_key = "full_title" and full_title_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_markup_translation` ON text_markup_translation.entity_id = entities.entity_id and text_markup_translation.column_key = "text_markup" and text_markup_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_translation` ON text_translation.entity_id = entities.entity_id and text_translation.column_key = "text" and text_translation.lang = "cs" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (rewrite_url = 'service') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
0.52ms SELECT `pages`.*, `entities`.*, `title_translation`.`value_varchar` AS `Xtranslated_title`, `full_title_translation`.`value_varchar` AS `Xtranslated_full_title`, `text_markup_translation`.`value_longtext` AS `Xtranslated_text_markup`, `text_translation`.`value_longtext` AS `Xtranslated_text` FROM `pages` INNER JOIN `entities` ON `entities`.entity_id = `pages`.entity_id LEFT JOIN `entities_translations` AS `title_translation` ON title_translation.entity_id = entities.entity_id and title_translation.column_key = "title" and title_translation.lang = "cs" LEFT JOIN `entities_translations` AS `full_title_translation` ON full_title_translation.entity_id = entities.entity_id and full_title_translation.column_key = "full_title" and full_title_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_markup_translation` ON text_markup_translation.entity_id = entities.entity_id and text_markup_translation.column_key = "text_markup" and text_markup_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_translation` ON text_translation.entity_id = entities.entity_id and text_translation.column_key = "text" and text_translation.lang = "cs" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (rewrite_url = 'charter') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1