Performance Profiling

Total processing time: 3,470 ms; Peak memory: 11.212 MB. Show Profiling Timeline

Total 33 items.

Time	Duration	Category	Info

16:10:10.739	1154.1 ms	yii\db\Command::query	SELECT `movies`.* FROM `movies` LEFT JOIN `movies_watchprovider_association` ON `movies`.`id` = `movies_watchprovider_association`.`movies_id` LEFT JOIN `movies_watchprovider` ON `movies_watchprovider_association`.`movies_watchprovider_id` = `movies_watchprovider`.`id` WHERE (`disabled`='NO') AND (`movies_watchprovider`.`slug`='player') ORDER BY `popularity` DESC LIMIT 12
16:10:11.941	1145.3 ms	yii\db\Command::query	SELECT `movies`.* FROM `movies` LEFT JOIN `movies_watchprovider_association` ON `movies`.`id` = `movies_watchprovider_association`.`movies_id` LEFT JOIN `movies_watchprovider` ON `movies_watchprovider_association`.`movies_watchprovider_id` = `movies_watchprovider`.`id` WHERE (`disabled`='NO') AND (`movies_watchprovider`.`slug`='player') ORDER BY `release_date` DESC LIMIT 12
16:10:09.765	933.6 ms	yii\db\Command::query	SELECT `movies`.* FROM `movies` LEFT JOIN `movies_watchprovider_association` ON `movies`.`id` = `movies_watchprovider_association`.`movies_id` LEFT JOIN `movies_watchprovider` ON `movies_watchprovider_association`.`movies_watchprovider_id` = `movies_watchprovider`.`id` WHERE (`disabled`='NO') AND (`vote_count` > 200) AND (`movies_watchprovider`.`slug`='player') ORDER BY `vote_average` DESC LIMIT 12
16:10:11.900	35.5 ms	yii\db\Command::query	SELECT `tvseries`.* FROM `tvseries` LEFT JOIN `tvseries_watchprovider_association` ON `tvseries`.`id` = `tvseries_watchprovider_association`.`tvseries_id` LEFT JOIN `tvseries_watchprovider` ON `tvseries_watchprovider_association`.`tvseries_watchprovider_id` = `tvseries_watchprovider`.`id` WHERE (`disabled`='NO') AND (`tvseries_watchprovider`.`slug`='player') ORDER BY `popularity` DESC LIMIT 12
16:10:10.705	29.2 ms	yii\db\Command::query	SELECT `tvseries`.* FROM `tvseries` LEFT JOIN `tvseries_watchprovider_association` ON `tvseries`.`id` = `tvseries_watchprovider_association`.`tvseries_id` LEFT JOIN `tvseries_watchprovider` ON `tvseries_watchprovider_association`.`tvseries_watchprovider_id` = `tvseries_watchprovider`.`id` WHERE (`disabled`='NO') AND (`vote_count` > 200) AND (`tvseries_watchprovider`.`slug`='player') ORDER BY `vote_average` DESC LIMIT 12
16:10:13.093	26.3 ms	yii\db\Command::query	SELECT `tvseries`.* FROM `tvseries` LEFT JOIN `tvseries_watchprovider_association` ON `tvseries`.`id` = `tvseries_watchprovider_association`.`tvseries_id` LEFT JOIN `tvseries_watchprovider` ON `tvseries_watchprovider_association`.`tvseries_watchprovider_id` = `tvseries_watchprovider`.`id` WHERE (`disabled`='NO') AND (`tvseries_watchprovider`.`slug`='player') ORDER BY `first_air_date` DESC LIMIT 12
16:10:11.895	2.1 ms	yii\db\Command::query	SELECT * FROM `movies_watchprovider_association` WHERE `movies_id` IN (950, 5, 686, 14, 8, 2, 35, 38, 9527, 29, 434)
16:10:13.088	1.9 ms	yii\db\Command::query	SELECT * FROM `movies_watchprovider_association` WHERE `movies_id` IN (686, 950, 1085, 146, 2, 140, 9527, 119, 5, 8, 35)
16:10:09.761	1.7 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `tvseries_watchprovider`
16:10:10.702	1.3 ms	yii\db\Command::query	SELECT * FROM `movies_watchprovider_association` WHERE `movies_id` IN (473, 659, 350, 548, 638, 2126, 200, 35, 488)
16:10:13.170	1.2 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `movies_genre`
16:10:10.698	1.1 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `movies`
16:10:13.174	0.9 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `tvseries_genre`
16:10:10.735	0.9 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `tvseries`
16:10:11.938	0.8 ms	yii\db\Command::query	SELECT * FROM `tvseries_watchprovider_association` WHERE `tvseries_id` IN (977, 689, 2300, 878, 443, 2261, 2660, 3107, 2174, 392, 989, 2330)
16:10:09.756	0.8 ms	yii\db\Connection::open	Opening DB connection: mysql:host=localhost;dbname=dev_vod
16:10:09.757	0.7 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `movies_watchprovider`
16:10:13.090	0.6 ms	yii\db\Command::query	SELECT * FROM `movies_watchprovider` WHERE `id` IN ('3', '5', '10', '14', '36', '29', '12', '1')
16:10:11.898	0.5 ms	yii\db\Command::query	SELECT * FROM `movies_watchprovider` WHERE `id` IN ('3', '5', '10', '14', '36', '29', '1', '12', '6', '9')
16:10:13.171	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` = 'movies_genre' AND `kcu`.`TABLE_NAME` = 'movies_genre'
16:10:11.939	0.4 ms	yii\db\Command::query	SELECT * FROM `tvseries_watchprovider` WHERE `id` IN ('4', '6', '10', '19', '1', '12', '2', '17', '23')
16:10:13.175	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` = 'tvseries_genre' AND `kcu`.`TABLE_NAME` = 'tvseries_genre'
16:10:10.737	0.4 ms	yii\db\Command::query	SELECT * FROM `tvseries_watchprovider_association` WHERE `tvseries_id` IN (878, 2300, 2159, 1439, 689, 989, 158, 1475, 1916, 977, 2174, 2261)
16:10:10.700	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` = 'movies' AND `kcu`.`TABLE_NAME` = 'movies'
16:10:10.736	0.3 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` = 'tvseries' AND `kcu`.`TABLE_NAME` = 'tvseries'
16:10:13.120	0.3 ms	yii\db\Command::query	SELECT * FROM `tvseries_watchprovider_association` WHERE `tvseries_id` IN (2147, 2441, 878, 989, 1463, 863, 1916, 1925, 1664, 689, 1922, 1964)
16:10:09.758	0.3 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` = 'movies_watchprovider' AND `kcu`.`TABLE_NAME` = 'movies_watchprovider'
16:10:10.703	0.3 ms	yii\db\Command::query	SELECT * FROM `movies_watchprovider` WHERE `id` IN ('3', '5', '10', '12', '14', '36', '9', '18', '29', '6', '2', '8')
16:10:09.763	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` = 'tvseries_watchprovider' AND `kcu`.`TABLE_NAME` = 'tvseries_watchprovider'
16:10:10.738	0.2 ms	yii\db\Command::query	SELECT * FROM `tvseries_watchprovider` WHERE `id` IN ('10', '12', '17', '23', '19', '1', '2', '6', '4')
16:10:09.760	0.2 ms	yii\db\Command::query	SELECT * FROM `movies_watchprovider` WHERE `slug`='player'
16:10:09.763	0.2 ms	yii\db\Command::query	SELECT * FROM `tvseries_watchprovider` WHERE `slug`='player'
16:10:13.120	0.1 ms	yii\db\Command::query	SELECT * FROM `tvseries_watchprovider` WHERE `id` IN ('10', '19', '1', '6', '12', '23')