Performance Profiling

Total processing time: 151 ms; Peak memory: 28,607 MB. Show Profiling Timeline

Razem 60 rekordów.

Time	Duration	Category	Info

03:14:17.223	18,0 ms	luya\base\BaseBootstrap::bootstrap	LUYA Boostrap process profiling
03:14:17.266	7,2 ms	yii\db\Command::query	SELECT `id`, `file_id`, `filter_id`, `resolution_width`, `resolution_height` FROM `admin_storage_image`
03:14:17.277	6,4 ms	yii\db\Command::query	SELECT `id`, `is_hidden`, `is_deleted`, `folder_id`, `name_original`, `name_new`, `name_new_compound`, `mime_type`, `extension`, `hash_name`, `hash_file`, `upload_timestamp`, `file_size`, `upload_user_id`, `caption` FROM `admin_storage_file`
03:14:17.348	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`
03:14:17.252	0,4 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `konkurs_edycja`
03:14:17.238	0,3 ms	yii\db\Connection::open	→Opening DB connection: mysql:host=localhost;dbname=galeriaplakatu2
03:14:17.263	0,3 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `konkurs_praca`
03:14:17.311	0,3 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `news_cat`
03:14:17.259	0,3 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `konkurs_jury`
03:14:17.315	0,3 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `news_article`
03:14:17.351	0,3 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `cms_nav`
03:14:17.329	0,3 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `admin_tag`
03:14:17.330	0,2 ms	yii\db\Command::query	SELECT `news_article`.* FROM `news_article` LEFT JOIN `admin_tag_relation` ON (`news_article`.`id` = `admin_tag_relation`.`pk_id`) AND (`table_name`='news_article') LEFT JOIN `admin_tag` ON `admin_tag_relation`.`tag_id` = `admin_tag`.`id` WHERE (`news_article`.`is_deleted`=FALSE) AND ((`is_online`=TRUE) AND (`is_archived`=FALSE)) AND (`tag_id`=4) AND (`cat_id`='47')
03:14:17.285	0,2 ms	yii\db\Command::query	SELECT * FROM `konkurs_praca` WHERE (`id_edycja`=3) AND (`miejsce` > 1) ORDER BY `nazwisko`
03:14:17.240	0,2 ms	yii\db\Command::query	→SELECT * FROM `cms_website` WHERE (`cms_website`.`is_deleted`=FALSE) AND (`is_active`=TRUE)
03:14:17.314	0,2 ms	yii\db\Command::query	SELECT * FROM `news_article` WHERE (`news_article`.`is_deleted`=FALSE) AND ((`is_online`=TRUE) AND (`is_archived`=FALSE)) AND (`cat_id`=24) ORDER BY `timestamp_create` DESC
03:14:17.253	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_edycja' AND `kcu`.`TABLE_NAME` = 'konkurs_edycja'
03:14:17.246	0,2 ms	yii\db\Command::query	SELECT * FROM `konkurs_edycja` WHERE (`numer`='20') AND (`aktywna`=1)
03:14:17.346	0,2 ms	yii\db\Command::query	SELECT `news_article`.* FROM `news_article` LEFT JOIN `admin_tag_relation` ON (`news_article`.`id` = `admin_tag_relation`.`pk_id`) AND (`table_name`='news_article') LEFT JOIN `admin_tag` ON `admin_tag_relation`.`tag_id` = `admin_tag`.`id` WHERE (`news_article`.`is_deleted`=FALSE) AND ((`is_online`=TRUE) AND (`is_archived`=FALSE)) AND (`tag_id`=4) AND (`cat_id`='50')
03:14:17.263	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'
03:14:17.334	0,2 ms	yii\db\Command::query	SELECT `news_article`.* FROM `news_article` LEFT JOIN `admin_tag_relation` ON (`news_article`.`id` = `admin_tag_relation`.`pk_id`) AND (`table_name`='news_article') LEFT JOIN `admin_tag` ON `admin_tag_relation`.`tag_id` = `admin_tag`.`id` WHERE (`news_article`.`is_deleted`=FALSE) AND ((`is_online`=TRUE) AND (`is_archived`=FALSE)) AND (`tag_id`=4) AND (`cat_id`='47')
03:14:17.323	0,2 ms	yii\db\Command::query	SELECT * FROM `news_article` WHERE (`news_article`.`is_deleted`=FALSE) AND ((`is_online`=TRUE) AND (`is_archived`=FALSE)) AND (`cat_id`=24) ORDER BY `timestamp_create` DESC
03:14:17.312	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` = 'news_cat' AND `kcu`.`TABLE_NAME` = 'news_cat'
03:14:17.262	0,2 ms	yii\db\Command::query	SELECT * FROM `konkurs_praca` WHERE (`id_edycja`=3) AND (`miejsce`=1) ORDER BY `miejsce`
03:14:17.351	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'
03:14:17.315	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` = 'news_article' AND `kcu`.`TABLE_NAME` = 'news_article'
03:14:17.332	0,2 ms	yii\db\Command::query	SELECT * FROM `admin_tag_relation` WHERE (`pk_id` IN (75, 82)) AND (`table_name`='news_article')
03:14:17.329	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` = 'admin_tag' AND `kcu`.`TABLE_NAME` = 'admin_tag'
03:14:17.259	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_jury' AND `kcu`.`TABLE_NAME` = 'konkurs_jury'
03:14:17.260	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`=3
03:14:17.335	0,1 ms	yii\db\Command::query	SELECT * FROM `admin_tag_relation` WHERE (`pk_id` IN (75, 82)) AND (`table_name`='news_article')
03:14:17.310	0,1 ms	yii\db\Command::query	SELECT * FROM `konkurs_edycja_jury` WHERE `id_edycja`=3
03:14:17.346	0,1 ms	yii\db\Command::query	SELECT * FROM `admin_tag` WHERE `name`='GP20'
03:14:17.289	0,1 ms	yii\db\Command::query	SELECT `id`, `identifier`, `name` FROM `admin_storage_filter` ORDER BY `name`
03:14:17.328	0,1 ms	yii\db\Command::query	SELECT * FROM `admin_tag` WHERE `name`='GP20'
03:14:17.323	0,1 ms	yii\db\Command::query	SELECT * FROM `news_cat` WHERE `title` LIKE '%\"20. edycja%'
03:14:17.332	0,1 ms	yii\db\Command::query	SELECT * FROM `admin_tag` WHERE `id` IN (4, 7, 11, 12, 3)
03:14:17.313	0,1 ms	yii\db\Command::query	SELECT * FROM `admin_lang` WHERE `is_deleted`=FALSE ORDER BY `is_default` DESC
03:14:17.311	0,1 ms	yii\db\Command::query	SELECT * FROM `news_cat` WHERE `title` LIKE '%\"20. edycja%'
03:14:17.245	0,1 ms	yii\db\Command::query	SELECT `value`, `name` FROM `admin_config`
03:14:17.335	0,1 ms	yii\db\Command::query	SELECT * FROM `admin_tag` WHERE `id` IN (4, 7, 11, 12, 3)
03:14:17.357	0,1 ms	yii\db\Command::query	SELECT * FROM `cms_nav` WHERE `id`=32
03:14:17.310	0,1 ms	yii\db\Command::query	SELECT * FROM `konkurs_jury` WHERE 0=1 ORDER BY SUBSTR(`imie_nazwisko`, INSTR(`imie_nazwisko`, " "))
03:14:17.349	0,1 ms	yii\db\Command::query	SELECT `id`, `type`, `value`, `target` FROM `cms_nav_item_redirect`
03:14:17.333	0,1 ms	yii\db\Command::query	SELECT * FROM `admin_tag` WHERE `name`='GP20'
03:14:17.348	0,1 ms	yii\db\Command::query	SELECT `short_code`, `id` FROM `admin_lang`
03:14:17.351	0,1 ms	yii\db\Command::query	SELECT * FROM `cms_nav` WHERE `id`=16
03:14:17.241	0,1 ms	yii\db\Command::query	→SELECT `base_path` FROM `cms_theme` WHERE `is_default`=1
03:14:17.353	0,1 ms	yii\db\Command::query	SELECT * FROM `cms_nav` WHERE `id`=37
03:14:17.353	0,1 ms	yii\db\Command::query	SELECT * FROM `cms_nav` WHERE `id`=15
03:14:17.352	0,1 ms	yii\db\Command::query	SELECT * FROM `cms_nav` WHERE `id`=13
03:14:17.352	0,1 ms	yii\db\Command::query	SELECT * FROM `cms_nav` WHERE `id`=29
03:14:17.352	0,1 ms	yii\db\Command::query	SELECT * FROM `cms_nav_property` WHERE `nav_id`=16
03:14:17.354	0,1 ms	yii\db\Command::query	SELECT * FROM `cms_nav` WHERE `id`=36
03:14:17.357	0,1 ms	yii\db\Command::query	SELECT * FROM `cms_nav_property` WHERE `nav_id`=32
03:14:17.354	0,1 ms	yii\db\Command::query	SELECT * FROM `cms_nav_property` WHERE `nav_id`=37
03:14:17.353	0,1 ms	yii\db\Command::query	SELECT * FROM `cms_nav_property` WHERE `nav_id`=15
03:14:17.352	0,1 ms	yii\db\Command::query	SELECT * FROM `cms_nav_property` WHERE `nav_id`=13
03:14:17.353	0,1 ms	yii\db\Command::query	SELECT * FROM `cms_nav_property` WHERE `nav_id`=29
03:14:17.354	0,1 ms	yii\db\Command::query	SELECT * FROM `cms_nav_property` WHERE `nav_id`=36