Performance Profiling

Total processing time: 88 ms; Peak memory: 12,500 MB. Show Profiling Timeline

Razem 48 rekordów.

Time	Duration	Category	Info

06:07:52.870	18,6 ms	luya\base\BaseBootstrap::bootstrap	LUYA Boostrap process profiling
06:07:52.928	1,3 ms	yii\db\Command::query	SELECT COUNT(*) FROM `konkurs_praca` WHERE ((`id_edycja`=26) AND (`dubel`=0)) AND (aktywna = 1 or (aktywna = 0 and zaakceptowano is null)) AND ((`imie` LIKE '%2026%') OR (`nazwisko` LIKE '%2026%'))
06:07:52.895	0,6 ms	yii\db\Command::query	SELECT `item`.`id`, `item`.`nav_id`, `item`.`title`, `item`.`description`, `item`.`keywords`, `item`.`image_id`, `item`.`is_url_strict_parsing_disabled`, `item`.`alias`, `item`.`title_tag`, `item`.`timestamp_create`, `item`.`timestamp_update`, `item`.`create_user_id`, `item`.`update_user_id`, `nav`.`is_home`, `nav`.`parent_nav_id`, `nav`.`sort_index`, `nav`.`is_hidden`, `item`.`nav_item_type`, `item`.`nav_item_type_id`, `nav_container`.`alias` AS `container` FROM `cms_nav_item` `item` LEFT JOIN `cms_nav` `nav` ON nav.id=item.nav_id LEFT JOIN `cms_nav_container` `nav_container` ON nav_container.id=nav.nav_container_id WHERE (`nav`.`is_deleted`=FALSE) AND (`nav_container`.`website_id`=1) AND (`item`.`lang_id`=1) AND (`nav`.`is_offline`=FALSE) AND (`nav`.`is_draft`=FALSE) ORDER BY `container`, `parent_nav_id`, `nav`.`sort_index`
06:07:52.902	0,3 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `cms_nav_item`
06:07:52.920	0,3 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `konkurs_edycja`
06:07:52.925	0,3 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `konkurs_praca`
06:07:52.886	0,3 ms	yii\db\Connection::open	→Opening DB connection: mysql:host=localhost;dbname=galeriaplakatu2
06:07:52.923	0,3 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `konkurs_jury`
06:07:52.904	0,3 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `cms_nav`
06:07:52.906	0,3 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `cms_nav_item_page`
06:07:52.909	0,3 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `cms_layout`
06:07:52.912	0,3 ms	yii\db\Command::query	SELECT `t1`.`id`, `t1`.`block_id`, `t1`.`json_config_values`, `t1`.`json_config_cfg_values`, `t1`.`variation`, `t2`.`class` FROM `cms_nav_item_page_block_item` `t1` INNER JOIN `cms_block` `t2` ON t2.id=t1.block_id WHERE (`nav_item_page_id`=20) AND (`placeholder_var`='content') AND (`prev_id`=0) AND (`is_hidden`=0) ORDER BY `sort_index`
06:07:52.935	0,2 ms	yii\db\Command::query	SELECT `t1`.`id`, `t1`.`block_id`, `t1`.`json_config_values`, `t1`.`json_config_cfg_values`, `t1`.`variation`, `t2`.`class` FROM `cms_nav_item_page_block_item` `t1` INNER JOIN `cms_block` `t2` ON t2.id=t1.block_id WHERE (`nav_item_page_id`=20) AND (`placeholder_var`='footer') AND (`prev_id`=0) AND (`is_hidden`=0) ORDER BY `sort_index`
06:07:52.916	0,2 ms	yii\db\Command::query	SELECT * FROM `konkurs_edycja` WHERE `aktywna`=1 ORDER BY `numer` DESC
06:07:52.902	0,2 ms	yii\db\Command::query	SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'cms_nav_item' AND `kcu`.`TABLE_NAME` = 'cms_nav_item'
06:07:52.888	0,2 ms	yii\db\Command::query	→SELECT * FROM `cms_website` WHERE (`cms_website`.`is_deleted`=FALSE) AND (`is_active`=TRUE)
06:07:52.905	0,2 ms	yii\db\Command::query	SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'cms_nav' AND `kcu`.`TABLE_NAME` = 'cms_nav'
06:07:52.925	0,2 ms	yii\db\Command::query	SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'konkurs_praca' AND `kcu`.`TABLE_NAME` = 'konkurs_praca'
06:07:52.909	0,2 ms	yii\db\Command::query	SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'cms_layout' AND `kcu`.`TABLE_NAME` = 'cms_layout'
06:07:52.907	0,1 ms	yii\db\Command::query	SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'cms_nav_item_page' AND `kcu`.`TABLE_NAME` = 'cms_nav_item_page'
06:07:52.920	0,1 ms	yii\db\Command::query	SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'konkurs_edycja' AND `kcu`.`TABLE_NAME` = 'konkurs_edycja'
06:07:52.923	0,1 ms	yii\db\Command::query	SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'konkurs_jury' AND `kcu`.`TABLE_NAME` = 'konkurs_jury'
06:07:52.923	0,1 ms	yii\db\Command::query	SELECT `konkurs_jury`.* FROM `konkurs_jury` LEFT JOIN `konkurs_edycja_jury` ON `konkurs_jury`.id=konkurs_edycja_jury.id_jury WHERE `konkurs_edycja_jury`.`id_edycja`=26
06:07:52.901	0,1 ms	yii\db\Command::query	SELECT * FROM `cms_nav_item` WHERE `id`=28
06:07:52.900	0,1 ms	yii\db\Command::query	SELECT * FROM `admin_lang` WHERE `is_deleted`=FALSE ORDER BY `is_default` DESC
06:07:52.904	0,1 ms	yii\db\Command::query	SELECT * FROM `cms_nav` WHERE `id`=26
06:07:52.900	0,1 ms	yii\db\Command::query	SELECT `is_cacheable` FROM `cms_nav_item` WHERE (`nav_id`=26) AND (`lang_id`=1)
06:07:52.895	0,1 ms	yii\db\Command::query	SELECT `short_code`, `id` FROM `admin_lang`
06:07:52.936	0,1 ms	yii\db\Command::query	SELECT * FROM `cms_nav` WHERE `id`=16
06:07:52.893	0,1 ms	yii\db\Command::query	SELECT `value`, `name` FROM `admin_config`
06:07:52.907	0,1 ms	yii\db\Command::query	SELECT * FROM `cms_layout` WHERE `id`=1
06:07:52.898	0,1 ms	yii\db\Command::query	SELECT `id`, `type`, `value`, `target` FROM `cms_nav_item_redirect`
06:07:52.941	0,1 ms	yii\db\Command::query	SELECT * FROM `cms_nav` WHERE `id`=26
06:07:52.907	0,1 ms	yii\db\Command::query	SELECT * FROM `cms_nav_item_page` WHERE `id`=20
06:07:52.939	0,1 ms	yii\db\Command::query	SELECT * FROM `cms_nav` WHERE `id`=36
06:07:52.888	0,1 ms	yii\db\Command::query	→SELECT `base_path` FROM `cms_theme` WHERE `is_default`=1
06:07:52.905	0,1 ms	yii\db\Command::query	SELECT * FROM `cms_nav_property` WHERE `nav_id`=26
06:07:52.937	0,1 ms	yii\db\Command::query	SELECT * FROM `cms_nav` WHERE `id`=29
06:07:52.938	0,1 ms	yii\db\Command::query	SELECT * FROM `cms_nav` WHERE `id`=37
06:07:52.937	0,1 ms	yii\db\Command::query	SELECT * FROM `cms_nav` WHERE `id`=13
06:07:52.938	0,1 ms	yii\db\Command::query	SELECT * FROM `cms_nav_property` WHERE `nav_id`=15
06:07:52.938	0,1 ms	yii\db\Command::query	SELECT * FROM `cms_nav` WHERE `id`=15
06:07:52.937	0,1 ms	yii\db\Command::query	SELECT * FROM `cms_nav_property` WHERE `nav_id`=16
06:07:52.938	0,1 ms	yii\db\Command::query	SELECT * FROM `cms_nav_property` WHERE `nav_id`=37
06:07:52.941	0,1 ms	yii\db\Command::query	SELECT * FROM `cms_nav_property` WHERE `nav_id`=26
06:07:52.939	0,1 ms	yii\db\Command::query	SELECT * FROM `cms_nav_property` WHERE `nav_id`=36
06:07:52.937	0,1 ms	yii\db\Command::query	SELECT * FROM `cms_nav_property` WHERE `nav_id`=13
06:07:52.938	0,1 ms	yii\db\Command::query	SELECT * FROM `cms_nav_property` WHERE `nav_id`=29