Masters

#	Nome	Ultima modifica
1	Be The Change-Digital Transformation Intensive Path (OLD)	05/05/2023 13:25
2	Be The Change-Digital Transformation Intensive Path (Leonardo Velivoli)	19/06/2023 15:32
3	SUM- Master in Management dell' Università e della Ricerca	31/03/2023 16:11
4	Corso di perfezionamento in Editoria	24/01/2023 15:25
5	Executive Master in Marketing & Sales Management (in Italian)	12/01/2023 11:50
6	CDP Academy \| Corporate MBA - Poste Italiane	31/03/2022 10:09
7	Executive Master in Management Pubblico- EMMP (ID 2303)	13/12/2022 17:13
8	Master per il governo delle infrastrutture strategiche: programmazione, finanziamento e gestione – MAGIS 1 (ID 2309)	13/12/2022 17:14
9	Master in Intelligenza Artificiale per la Pubblica Amministrazione – MIAP 1 (ID 2308)	13/12/2022 17:13
10	Percorso Executive in Design Thinking for Business	25/11/2022 18:12
11	Percorso Executive in Innovation Management (ID 2210)	25/11/2022 18:12
12	MIDIC - Master in Innovazione e Digitalizzazione delle Istituzioni Culturali (ID 2310)	12/07/2022 17:21
13	Executive Program in Digital Health & Innovation	26/07/2022 16:04
14	Percorso Executive in Sales Strategy, Management & Innovation (ID 2292)	25/11/2022 18:11
15	CDP Academy \| Corporate MBA	28/03/2022 18:57
16	Percorso Executive in Smart Mobility	16/09/2022 08:58
17	Test_Master EMBA eng	27/06/2022 12:04
18	Master in People Management and HR Strategy (ID 2219)	18/07/2022 12:08
19	Cultural Management (ID 2217)	24/01/2023 15:26
20	Executive Master in Innovazione Organizzativa e Digitale nelle strutture Universitarie in Medicina (EMIODUM) (ID 2221)	13/12/2022 17:10

(default) 7 queries took 1 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `MastersSchool`.`id`, `MastersSchool`.`school_id`, `MastersSchool`.`master_id` FROM `applyformasters`.`masters_schools` AS `MastersSchool` WHERE `MastersSchool`.`school_id` IS NULL	0	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	0
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	0
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	0
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`.`id` DESC LIMIT 20	20	20	1
6	SELECT `Intake`.`name`, `Intake`.`year`, `Intake`.`master_id` FROM `applyformasters`.`intakes` AS `Intake` WHERE `opened` = 1 AND `Intake`.`master_id` IN (133, 132, 131, 130, 129, 128, 127, 126, 125, 124, 123, 122, 121, 120, 119, 118, 117, 116, 115, 114)	0	0	0
7	SELECT COUNT(*) AS `count` FROM `applyformasters`.`masters` AS `Master` WHERE 1 = 1	1	1	0

(default) 7 queries took 1 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`.`id` DESC LIMIT 20

SELECT `Intake`.`name`, `Intake`.`year`, `Intake`.`master_id` FROM `applyformasters`.`intakes` AS `Intake` WHERE `opened` = 1 AND `Intake`.`master_id` IN (133, 132, 131, 130, 129, 128, 127, 126, 125, 124, 123, 122, 121, 120, 119, 118, 117, 116, 115, 114)

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