Masters

#	Name	Last modified
1	Percorso executive in Finanza Quantitativa (ID 1720)	17/11/2021 16:19
2	Percorso Executive in Financial Risk Management (in italiano)	18/10/2021 21:06
3	Percorso Executive in Enterprise Risk Management (in italiano)	18/10/2021 21:06
4	Percorso Executive in Energy Management (in italiano) (ID 2342)	25/11/2022 18:12
5	Percorso Executive in Digital Lean Six Sigma (in italiano) (ID 2341)	25/11/2022 18:12
6	Percorso Executive in Design Thinking for Business	25/11/2022 18:12
7	Percorso executive in Data Science and Business Analytics (ID 2337)	25/11/2022 18:11
8	Percorso Executive in Corporate Entrepreneurship flex	08/03/2022 12:51
9	Percorso Executive in Sales Strategy, Management & Innovation (ID 2292)	25/11/2022 18:11
10	Pecorso Executive in Data Driven Business Transformation (ID 2215)	21/10/2022 11:09
11	Pecorso Executive Digital Lobbying & Public Affairs Management (ID 2223)	21/10/2022 11:05
12	Online certification program in Artificial Intelligence for Professionals	25/11/2022 18:11
13	Online Certification Program for Global Business Services (GBS) professionals	25/11/2022 18:11
14	Online Certification Program for Fintech Professionals	25/11/2022 18:11
15	Online Certification Program for Cybersecurity Professionals	25/11/2022 17:57
16	Online Certification Program for Business Transformation Leaders	25/11/2022 18:10
17	MSPME - Master in Strategic Project Management	24/10/2017 19:46
18	MSCPM - Master Supply Chain and Purchasing Management - Extended Spring	10/05/2018 16:48
19	MSCPM - Master Supply Chain and Purchasing Management - Extended Fall	10/05/2018 16:48
20	MSCPM - Master Supply Chain and Purchasing Management - Core Spring	10/05/2018 16:47

(default) 7 queries took 0 ms
Nr	Query	Affected	Num. rows
1	SELECT `MastersSchool`.`id`, `MastersSchool`.`school_id`, `MastersSchool`.`master_id` FROM `applyformasters`.`masters_schools` AS `MastersSchool` WHERE `MastersSchool`.`school_id` IS NULL	0	0
2	SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `applyformasters`.`aros` AS `Aro` INNER JOIN `applyformasters`.`aros` AS `Aro0` ON (`Aro0`.`alias` = 'Anonymous') WHERE `Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght` ORDER BY `Aro`.`lft` DESC	1	1
3	SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `applyformasters`.`acos` AS `Aco` INNER JOIN `applyformasters`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'Masters::index') WHERE `Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght` ORDER BY `Aco`.`lft` DESC	3	3
4	SELECT `Permission`.`id`, `Permission`.`aro_id`, `Permission`.`aco_id`, `Permission`.`_create`, `Permission`.`_read`, `Permission`.`_update`, `Permission`.`_delete`, `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias`, `Aro`.`lft`, `Aro`.`rght`, `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght` FROM `applyformasters`.`aros_acos` AS `Permission` LEFT JOIN `applyformasters`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `applyformasters`.`acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` = 2 AND `Permission`.`aco_id` IN (145, 141, 1) ORDER BY `Aco`.`lft` desc	1	1
5	SELECT `Master`.`id`, `Master`.`ranking_id`, `Master`.`name`, `Master`.`international`, `Master`.`executive`, `Master`.`description`, `Master`.`application_fee`, `Master`.`first_installment`, `Master`.`ecommerce_temporary_url`, `Master`.`masterscol`, `Master`.`id_program_crm`, `Master`.`professional_experiences_net_salary_mandatory`, `Master`.`language`, `Master`.`emba`, `Master`.`created_by`, `Master`.`modified_by`, `Master`.`confirmed_by`, `Master`.`welcome_on_board_sender`, `Master`.`welcome_on_board_subject`, `Master`.`welcome_on_board_message`, `Master`.`welcome_on_board_recipients`, `Master`.`documents_for_admission_email_sender`, `Master`.`documents_for_admission_email_recipients`, `Master`.`documents_for_admission_email_subject`, `Master`.`documents_for_admission_email_body`, `Master`.`created`, `Master`.`modified`, `Master`.`master_ranking_id`, `Master`.`show_questions_form`, `Master`.`company_logo`, `Master`.`show_correspondence_address_form` FROM `applyformasters`.`masters` AS `Master` WHERE 1 = 1 ORDER BY `Master`.`name` desc LIMIT 20, 20	20	20
6	SELECT `Intake`.`name`, `Intake`.`year`, `Intake`.`master_id` FROM `applyformasters`.`intakes` AS `Intake` WHERE `opened` = 1 AND `Intake`.`master_id` IN (54, 48, 37, 36, 38, 124, 69, 105, 120, 101, 100, 112, 87, 89, 75, 97, 21, 19, 17, 18)	0	0
7	SELECT COUNT(*) AS `count` FROM `applyformasters`.`masters` AS `Master` WHERE 1 = 1	1	1

(default) 7 queries took 0 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `MastersSchool`.`id`, `MastersSchool`.`school_id`, `MastersSchool`.`master_id` FROM `applyformasters`.`masters_schools` AS `MastersSchool` WHERE `MastersSchool`.`school_id` IS NULL

SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `applyformasters`.`aros` AS `Aro` INNER JOIN `applyformasters`.`aros` AS `Aro0` ON (`Aro0`.`alias` = 'Anonymous') WHERE `Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght` ORDER BY `Aro`.`lft` DESC

SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `applyformasters`.`acos` AS `Aco` INNER JOIN `applyformasters`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'Masters::index') WHERE `Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght` ORDER BY `Aco`.`lft` DESC

SELECT `Permission`.`id`, `Permission`.`aro_id`, `Permission`.`aco_id`, `Permission`.`_create`, `Permission`.`_read`, `Permission`.`_update`, `Permission`.`_delete`, `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias`, `Aro`.`lft`, `Aro`.`rght`, `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght` FROM `applyformasters`.`aros_acos` AS `Permission` LEFT JOIN `applyformasters`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `applyformasters`.`acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` = 2 AND `Permission`.`aco_id` IN (145, 141, 1) ORDER BY `Aco`.`lft` desc

SELECT `Master`.`id`, `Master`.`ranking_id`, `Master`.`name`, `Master`.`international`, `Master`.`executive`, `Master`.`description`, `Master`.`application_fee`, `Master`.`first_installment`, `Master`.`ecommerce_temporary_url`, `Master`.`masterscol`, `Master`.`id_program_crm`, `Master`.`professional_experiences_net_salary_mandatory`, `Master`.`language`, `Master`.`emba`, `Master`.`created_by`, `Master`.`modified_by`, `Master`.`confirmed_by`, `Master`.`welcome_on_board_sender`, `Master`.`welcome_on_board_subject`, `Master`.`welcome_on_board_message`, `Master`.`welcome_on_board_recipients`, `Master`.`documents_for_admission_email_sender`, `Master`.`documents_for_admission_email_recipients`, `Master`.`documents_for_admission_email_subject`, `Master`.`documents_for_admission_email_body`, `Master`.`created`, `Master`.`modified`, `Master`.`master_ranking_id`, `Master`.`show_questions_form`, `Master`.`company_logo`, `Master`.`show_correspondence_address_form` FROM `applyformasters`.`masters` AS `Master` WHERE 1 = 1 ORDER BY `Master`.`name` desc LIMIT 20, 20

SELECT `Intake`.`name`, `Intake`.`year`, `Intake`.`master_id` FROM `applyformasters`.`intakes` AS `Intake` WHERE `opened` = 1 AND `Intake`.`master_id` IN (54, 48, 37, 36, 38, 124, 69, 105, 120, 101, 100, 112, 87, 89, 75, 97, 21, 19, 17, 18)

SELECT COUNT(*) AS `count` FROM `applyformasters`.`masters` AS `Master` WHERE 1 = 1