Performance Profiling

Total processing time: 173 ms; Peak memory: 4,111 MB. Show Profiling Timeline

Total 21 éléments.

Time	Duration	Category	Info

09:05:44.977	5,5 ms	luya\base\BaseBootstrap::bootstrap	LUYA Boostrap process profiling
09:05:45.002	3,7 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 (`item`.`lang_id`='2') AND (`nav`.`is_offline`=FALSE) AND (`nav`.`is_draft`=FALSE)) AND ((`publish_from` IS NULL) OR (`publish_from` <= 1775459144)) AND ((`publish_till` IS NULL) OR (`publish_till` >= 1775459144)) ORDER BY `container`, `parent_nav_id`, `nav`.`sort_index`
09:05:45.014	2,2 ms	yii\db\Command::query	SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.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'
09:05:45.049	2,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`=3) AND (`placeholder_var`='content') AND (`prev_id`=0) AND (`is_hidden`=0) ORDER BY `sort_index`
09:05:44.994	2,0 ms	yii\db\Connection::open	Opening DB connection: mysql:host=jolliotpmntest.mysql.db;dbname=jolliotpmntest
09:05:45.026	1,9 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `cms_nav_item_page`
09:05:45.043	1,8 ms	yii\db\Command::query	SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.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'
09:05:45.011	1,8 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `cms_nav_item`
09:05:45.019	1,6 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `cms_nav`
09:05:45.041	1,5 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `cms_layout`
09:05:44.996	1,5 ms	yii\db\Command::query	SELECT `short_code`, `id` FROM `admin_lang`
09:05:45.063	1,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`
09:05:45.021	1,4 ms	yii\db\Command::query	SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.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'
09:05:45.028	1,3 ms	yii\db\Command::query	SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.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'
09:05:45.092	1,2 ms	yii\db\Command::query	SELECT `id`, `identifier`, `name` FROM `admin_storage_filter` ORDER BY `name`
09:05:45.061	1,2 ms	yii\db\Command::query	SELECT `id`, `file_id`, `filter_id`, `resolution_width`, `resolution_height` FROM `admin_storage_image`
09:05:45.023	1,1 ms	yii\db\Command::query	SELECT * FROM `cms_nav_property` WHERE `nav_id`=1
09:05:45.033	1,0 ms	yii\db\Command::query	SELECT * FROM `cms_layout` WHERE `id`=1
09:05:45.030	0,7 ms	yii\db\Command::query	SELECT * FROM `cms_nav_item_page` WHERE `id`=3
09:05:45.010	0,6 ms	yii\db\Command::query	SELECT * FROM `cms_nav_item` WHERE `id`=3
09:05:45.019	0,5 ms	yii\db\Command::query	SELECT * FROM `cms_nav` WHERE `id`=1