Performance Profiling

Total processing time: 184 ms; Peak memory: 16.620 MB. Show Profiling Timeline

مجموع {count, number} {count, plural, one{مُدخل} few{مُدخلات} many{مُدخل}}.

Time	Duration	Category	Info

12:20:15.052	23.1 ms	yii\db\Command::query	SELECT * FROM `incidents` WHERE (`incidents`.`status`=100) AND (`incidents`.`lang`='ua') ORDER BY `date_end` DESC LIMIT 6
12:20:15.043	7.9 ms	yii\db\Command::query	SELECT COUNT(*) FROM `incidents` WHERE (`incidents`.`status`=100) AND (`incidents`.`lang`='ua')
12:20:15.080	3.0 ms	yii\db\Command::query	SELECT * FROM `incident_geographic` WHERE `incident_id`=3037
12:20:15.090	2.9 ms	yii\db\Command::query	SELECT * FROM `incident_geographic` WHERE `incident_id`=3038
12:20:15.097	2.8 ms	yii\db\Command::query	SELECT * FROM `incident_geographic` WHERE `incident_id`=3039
12:20:15.001	2.8 ms	yii\db\Command::query	SELECT DISTINCT `incident_geographic`.`lat`, `incident_geographic`.`lng`, `incident_geographic`.`incident_id` FROM `incident_geographic` WHERE (`incident_geographic`.`lat` IS NOT NULL) AND (`incident_geographic`.`lng` IS NOT NULL)
12:20:15.105	2.4 ms	yii\db\Command::query	SELECT * FROM `incident_geographic` WHERE `incident_id`=3041
12:20:15.112	2.2 ms	yii\db\Command::query	SELECT * FROM `incident_geographic` WHERE `incident_id`=3026
12:20:15.119	2.2 ms	yii\db\Command::query	SELECT * FROM `incident_geographic` WHERE `incident_id`=3020
12:20:15.078	1.9 ms	yii\db\Command::query	SELECT * FROM `thematic_typology_id` WHERE `post_id`=3037
12:20:15.084	1.8 ms	yii\db\Command::query	SELECT * FROM `persons` WHERE (`type`=100) AND (`incident_id`=3037)
12:20:15.100	1.7 ms	yii\db\Command::query	SELECT * FROM `persons` WHERE (`type`=100) AND (`incident_id`=3039)
12:20:15.107	1.7 ms	yii\db\Command::query	SELECT * FROM `persons` WHERE (`type`=100) AND (`incident_id`=3041)
12:20:15.093	1.7 ms	yii\db\Command::query	SELECT * FROM `persons` WHERE (`type`=100) AND (`incident_id`=3038)
12:20:15.114	1.7 ms	yii\db\Command::query	SELECT * FROM `persons` WHERE (`type`=100) AND (`incident_id`=3026)
12:20:15.122	1.7 ms	yii\db\Command::query	SELECT * FROM `persons` WHERE (`type`=100) AND (`incident_id`=3020)
12:20:15.088	1.4 ms	yii\db\Command::query	SELECT * FROM `thematic_typology_id` WHERE `post_id`=3038
12:20:15.095	1.4 ms	yii\db\Command::query	SELECT * FROM `thematic_typology_id` WHERE `post_id`=3039
12:20:15.117	1.4 ms	yii\db\Command::query	SELECT * FROM `thematic_typology_id` WHERE `post_id`=3020
12:20:15.110	1.3 ms	yii\db\Command::query	SELECT * FROM `thematic_typology_id` WHERE `post_id`=3026
12:20:15.103	1.3 ms	yii\db\Command::query	SELECT * FROM `thematic_typology_id` WHERE `post_id`=3041
12:20:14.982	0.8 ms	yii\db\Connection::open	Opening DB connection: mysql:host=mysql_db;dbname=5am
12:20:14.990	0.7 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `incidents`
12:20:15.004	0.6 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `incident_geographic`
12:20:15.086	0.5 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `persons`
12:20:15.132	0.5 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `partners`
12:20:15.137	0.5 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` = 'media' AND `kcu`.`TABLE_NAME` = 'media'
12:20:15.133	0.4 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` = 'partners' AND `kcu`.`TABLE_NAME` = 'partners'
12:20:15.135	0.4 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `media`
12:20:14.991	0.4 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` = 'incidents' AND `kcu`.`TABLE_NAME` = 'incidents'
12:20:15.005	0.4 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` = 'incident_geographic' AND `kcu`.`TABLE_NAME` = 'incident_geographic'
12:20:15.086	0.4 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` = 'persons' AND `kcu`.`TABLE_NAME` = 'persons'
12:20:14.995	0.3 ms	yii\db\Command::query	SELECT COUNT(*) FROM `thematic_typology`
12:20:14.994	0.2 ms	yii\db\Command::query	SELECT COUNT(*) FROM `thematic_typology`
12:20:15.080	0.2 ms	yii\db\Command::query	SELECT * FROM `thematic_typology` WHERE (`thematic_typology`.`lang`='ua') AND (`post_id` IN (155, 158, 156, 167, 157, 145, 129))
12:20:15.097	0.2 ms	yii\db\Command::query	SELECT * FROM `thematic_typology` WHERE (`thematic_typology`.`lang`='ua') AND (`post_id` IN (155, 158, 156, 157, 145, 129))
12:20:15.118	0.2 ms	yii\db\Command::query	SELECT * FROM `thematic_typology` WHERE (`thematic_typology`.`lang`='ua') AND (`post_id` IN (136, 137, 141, 156, 167, 134, 144, 128, 145, 129, 199))
12:20:15.089	0.2 ms	yii\db\Command::query	SELECT * FROM `thematic_typology` WHERE (`thematic_typology`.`lang`='ua') AND (`post_id` IN (155, 158, 156, 157, 145, 129))
12:20:14.995	0.2 ms	yii\db\Command::query	SELECT COUNT(*) FROM `thematic_typology`
12:20:14.996	0.2 ms	yii\db\Command::query	SELECT COUNT(*) FROM `thematic_typology`
12:20:15.111	0.2 ms	yii\db\Command::query	SELECT * FROM `thematic_typology` WHERE (`thematic_typology`.`lang`='ua') AND (`post_id` IN (155, 158, 156, 167, 157, 145, 129))
12:20:15.104	0.2 ms	yii\db\Command::query	SELECT * FROM `thematic_typology` WHERE (`thematic_typology`.`lang`='ua') AND (`post_id` IN (155, 158, 156, 167, 157, 145, 129))
12:20:15.004	0.2 ms	yii\db\Command::query	SHOW CREATE TABLE `incident_geographic`
12:20:14.995	0.2 ms	yii\db\Command::query	SELECT MAX(updated_at) FROM `thematic_typology`
12:20:14.994	0.2 ms	yii\db\Command::query	SELECT MAX(updated_at) FROM `thematic_typology`
12:20:14.984	0.2 ms	yii\db\Command::query	SELECT MAX(updated_at) FROM section
12:20:15.131	0.2 ms	yii\db\Command::query	SELECT * FROM `posts` WHERE (`status`=100) AND ((`url`='about-coalition') AND (`type`='content') AND (`lang`='ua')) AND (`date` <= 1745227215)
12:20:14.991	0.2 ms	yii\db\Command::query	SHOW CREATE TABLE `incidents`
12:20:14.986	0.2 ms	yii\db\Command::query	SELECT * FROM `lang` WHERE (url = '?phpinfo=1') AND (`active`=1)
12:20:14.994	0.2 ms	yii\db\Command::query	SELECT MAX(updated_at) FROM `thematic_typology`
12:20:15.144	0.2 ms	yii\db\Command::query	SELECT * FROM `menu` WHERE (`lang`='ua') AND (`menu_type`=1) ORDER BY `num`
12:20:15.036	0.1 ms	yii\db\Command::query	SELECT MAX(updated_at) FROM settings
12:20:15.132	0.1 ms	yii\db\Command::query	SELECT * FROM `partners` WHERE (`img_id` != 0) AND (`to_home`=1) ORDER BY `num`
12:20:14.996	0.1 ms	yii\db\Command::query	SELECT MAX(updated_at) FROM `thematic_typology`
12:20:15.149	0.1 ms	yii\db\Command::query	SELECT * FROM `menu` WHERE (`lang`='ua') AND (`menu_type`=2) ORDER BY `num`
12:20:15.131	0.1 ms	yii\db\Command::query	SELECT * FROM `post_fields` WHERE `post_id`=1
12:20:15.086	0.1 ms	yii\db\Command::query	SHOW CREATE TABLE `persons`
12:20:15.133	0.1 ms	yii\db\Command::query	SHOW CREATE TABLE `partners`
12:20:15.145	0.1 ms	yii\db\Command::query	SELECT * FROM `menu` WHERE (`lang`='ua') AND (`menu_type`=1) ORDER BY `num`
12:20:15.136	0.1 ms	yii\db\Command::query	SHOW CREATE TABLE `media`
12:20:15.137	0.1 ms	yii\db\Command::query	SELECT * FROM `media` WHERE `id`=3
12:20:15.135	0.1 ms	yii\db\Command::query	SELECT * FROM `media` WHERE `id`=2
12:20:15.144	0.1 ms	yii\db\Command::query	SELECT * FROM `types` WHERE (`type`='statements') AND (`lang`='ua')
12:20:15.145	0.1 ms	yii\db\Command::query	SELECT * FROM `types` WHERE (`type`='announcements') AND (`lang`='ua')
12:20:15.149	0.1 ms	yii\db\Command::query	SELECT * FROM `types` WHERE (`type`='statements') AND (`lang`='ua')
12:20:15.126	0.1 ms	yii\db\Command::query	SELECT MAX(update_cache) FROM posts
12:20:15.144	0.1 ms	yii\db\Command::query	SELECT * FROM `types` WHERE (`type`='research') AND (`lang`='ua')
12:20:15.128	0.1 ms	yii\db\Command::query	SELECT * FROM `types` WHERE (`type`='media-about-us') AND (`lang`='ua')
12:20:15.149	0.1 ms	yii\db\Command::query	SELECT * FROM `types` WHERE (`type`='research') AND (`lang`='ua')
12:20:15.150	0.1 ms	yii\db\Command::query	SELECT * FROM `types` WHERE (`type`='announcements') AND (`lang`='ua')
12:20:15.129	0.1 ms	yii\db\Command::query	SELECT * FROM `types` WHERE (`type`='media-about-us') AND (`lang`='ua')
12:20:15.126	0.1 ms	yii\db\Command::query	SELECT update_cache FROM posts WHERE id = "174"
12:20:15.146	0.1 ms	yii\db\Command::query	SELECT * FROM `types` WHERE (`type`='statements') AND (`lang`='ua')
12:20:15.130	0.1 ms	yii\db\Command::query	SELECT * FROM `types` WHERE (`type`='statements') AND (`lang`='ua')
12:20:15.129	0.1 ms	yii\db\Command::query	SELECT * FROM `types` WHERE (`type`='media-about-us') AND (`lang`='ua')
12:20:15.130	0.1 ms	yii\db\Command::query	SELECT * FROM `types` WHERE (`type`='media-about-us') AND (`lang`='ua')
12:20:15.137	0.1 ms	yii\db\Command::query	SELECT * FROM `media` WHERE `id`=7
12:20:15.146	0.1 ms	yii\db\Command::query	SELECT * FROM `types` WHERE (`type`='research') AND (`lang`='ua')
12:20:15.147	0.1 ms	yii\db\Command::query	SELECT * FROM `types` WHERE (`type`='news') AND (`lang`='ua')
12:20:15.127	0.1 ms	yii\db\Command::query	SELECT update_cache FROM posts WHERE id = "174"
12:20:15.145	0.1 ms	yii\db\Command::query	SELECT * FROM `types` WHERE (`type`='media-about-us') AND (`lang`='ua')
12:20:15.146	0.1 ms	yii\db\Command::query	SELECT * FROM `types` WHERE (`type`='announcements') AND (`lang`='ua')
12:20:15.151	0.1 ms	yii\db\Command::query	SELECT MAX(updated_at) FROM `constants`
12:20:15.145	0.1 ms	yii\db\Command::query	SELECT * FROM `types` WHERE (`type`='news') AND (`lang`='ua')
12:20:15.147	0.1 ms	yii\db\Command::query	SELECT * FROM `types` WHERE (`type`='media-about-us') AND (`lang`='ua')
12:20:15.150	0.1 ms	yii\db\Command::query	SELECT * FROM `types` WHERE (`type`='news') AND (`lang`='ua')
12:20:15.150	0.1 ms	yii\db\Command::query	SELECT * FROM `types` WHERE (`type`='media-about-us') AND (`lang`='ua')
12:20:15.126	0.1 ms	yii\db\Command::query	SELECT update_cache FROM posts WHERE id = "174"
12:20:15.138	0.1 ms	yii\db\Command::query	SELECT * FROM `media` WHERE `id`=6
12:20:15.138	0.1 ms	yii\db\Command::query	SELECT * FROM `media` WHERE `id`=11
12:20:15.139	0.1 ms	yii\db\Command::query	SELECT * FROM `media` WHERE `id`=16
12:20:15.151	0.1 ms	yii\db\Command::query	SELECT MAX(updated_at) FROM `constants`
12:20:15.131	0.1 ms	yii\db\Command::query	SELECT MAX(update_cache) FROM `posts`
12:20:15.127	0.1 ms	yii\db\Command::query	SELECT MAX(update_cache) FROM posts
12:20:15.151	0.1 ms	yii\db\Command::query	SELECT COUNT(id) FROM `constants`
12:20:15.151	0.1 ms	yii\db\Command::query	SELECT MAX(updated_at) FROM `constants`
12:20:15.140	0.1 ms	yii\db\Command::query	SELECT * FROM `media` WHERE `id`=34
12:20:15.138	0.1 ms	yii\db\Command::query	SELECT * FROM `media` WHERE `id`=8
12:20:15.152	0.1 ms	yii\db\Command::query	SELECT MAX(updated_at) FROM `constants`
12:20:15.151	0.1 ms	yii\db\Command::query	SELECT COUNT(id) FROM `constants`
12:20:15.138	0.1 ms	yii\db\Command::query	SELECT * FROM `media` WHERE `id`=9
12:20:15.138	0.1 ms	yii\db\Command::query	SELECT * FROM `media` WHERE `id`=10
12:20:15.139	0.1 ms	yii\db\Command::query	SELECT * FROM `media` WHERE `id`=12
12:20:15.139	0.1 ms	yii\db\Command::query	SELECT * FROM `media` WHERE `id`=13
12:20:15.139	0.1 ms	yii\db\Command::query	SELECT * FROM `media` WHERE `id`=14
12:20:15.139	0.1 ms	yii\db\Command::query	SELECT * FROM `media` WHERE `id`=15
12:20:15.140	0.1 ms	yii\db\Command::query	SELECT * FROM `media` WHERE `id`=36
12:20:15.140	0.1 ms	yii\db\Command::query	SELECT * FROM `media` WHERE `id`=35
12:20:15.127	0.1 ms	yii\db\Command::query	SELECT MAX(update_cache) FROM posts
12:20:15.152	0.1 ms	yii\db\Command::query	SELECT COUNT(id) FROM `constants`
12:20:15.152	0.1 ms	yii\db\Command::query	SELECT COUNT(id) FROM `constants`
12:20:15.127	0.1 ms	yii\db\Command::query	SELECT MAX(update_cache) FROM posts
12:20:15.128	0.1 ms	yii\db\Command::query	SELECT MAX(update_cache) FROM posts