| Query | Error | Affected | Num. rows | Took (ms) | Actions |
|---|
| SHOW FULL COLUMNS FROM `languages` | | 7 | 7 | 1 | maybe slow |
| SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_bin'; | | 1 | 1 | 0 | |
| SELECT `Language`.`id`, `Language`.`human`, `Language`.`humanshort`, `Language`.`locale`, `Language`.`language`, `Language`.`order`, `Language`.`online` FROM `languages` AS `Language` WHERE `Language`.`online` = 1 ORDER BY `Language`.`order` ASC | | 2 | 2 | 0 | |
| SHOW FULL COLUMNS FROM `menus` | | 12 | 12 | 1 | maybe slow |
| SHOW FULL COLUMNS FROM `languages_menus` | | 2 | 2 | 1 | maybe slow |
| SHOW FULL COLUMNS FROM `i18n` | | 6 | 6 | 1 | maybe slow |
| SELECT `Language`.`id`, `Language`.`human`, `Language`.`humanshort`, `Language`.`locale`, `Language`.`language`, `Language`.`order`, `Language`.`online` FROM `languages` AS `Language` WHERE `Language`.`online` = 1 ORDER BY `Language`.`order` ASC | | 2 | 2 | 0 | |
| SELECT `Language`.`id` FROM `languages` AS `Language` WHERE `Language`.`language` = 'dut' LIMIT 1 | | 1 | 1 | 0 | |
| SELECT `Menu`.`id` FROM `menus` AS `Menu` WHERE LOCATE(`Menu`.`url`,"http://eas002.preview.codedor.be/") != 0 ORDER BY `Menu`.`lft` DESC LIMIT 1 | | 1 | 1 | 0 | |
| SELECT `I18n__title`.`content`, `Menu`.`id` FROM `menus` AS `Menu` LEFT JOIN `i18n` AS `I18n__title` ON (`Menu`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Menu' AND `I18n__title`.`field` = 'title') LEFT JOIN `languages_menus` AS `LanguagesMenu` ON (`LanguagesMenu`.`menu_id` = `Menu`.`id` AND `LanguagesMenu`.`language_id` = 1) WHERE `Menu`.`id` = 1 AND `I18n__title`.`locale` = 'dut' LIMIT 1 | | 1 | 1 | 1 | |
| SELECT `title`.`id`, `title`.`locale`, `title`.`model`, `title`.`foreign_key`, `title`.`field`, `title`.`content` FROM `i18n` AS `title` WHERE `model` = 'Menu' AND `field` = 'title' AND `title`.`foreign_key` = (1) | | 2 | 2 | 1 | maybe slow |
| SELECT `description`.`id`, `description`.`locale`, `description`.`model`, `description`.`foreign_key`, `description`.`field`, `description`.`content` FROM `i18n` AS `description` WHERE `model` = 'Menu' AND `field` = 'description' AND `description`.`foreign_key` = (1) | | 2 | 2 | 1 | maybe slow |
| SELECT `keywords`.`id`, `keywords`.`locale`, `keywords`.`model`, `keywords`.`foreign_key`, `keywords`.`field`, `keywords`.`content` FROM `i18n` AS `keywords` WHERE `model` = 'Menu' AND `field` = 'keywords' AND `keywords`.`foreign_key` = (1) | | 2 | 2 | 0 | |
| SELECT `Language`.`id`, `Language`.`human`, `Language`.`humanshort`, `Language`.`locale`, `Language`.`language`, `Language`.`order`, `Language`.`online`, `LanguagesMenu`.`language_id`, `LanguagesMenu`.`menu_id` FROM `languages` AS `Language` JOIN `languages_menus` AS `LanguagesMenu` ON (`LanguagesMenu`.`menu_id` = 1 AND `LanguagesMenu`.`language_id` = `Language`.`id`) | | 1 | 1 | 0 | |
| SELECT `Language`.`id`, `Language`.`human`, `Language`.`humanshort`, `Language`.`locale`, `Language`.`language`, `Language`.`order`, `Language`.`online` FROM `languages` AS `Language` WHERE `Language`.`online` = 1 ORDER BY `Language`.`order` ASC | | 2 | 2 | 0 | |
| SELECT `Language`.`id` FROM `languages` AS `Language` WHERE `Language`.`language` = 'dut' LIMIT 1 | | 1 | 1 | 0 | |
| SELECT `Menu`.`id` FROM `menus` AS `Menu` WHERE LOCATE(`Menu`.`url`,"http://eas002.preview.codedor.be/") != 0 ORDER BY `Menu`.`lft` DESC LIMIT 1 | | 1 | 1 | 0 | |
| SELECT `Language`.`id`, `Language`.`human`, `Language`.`humanshort`, `Language`.`locale`, `Language`.`language`, `Language`.`order`, `Language`.`online` FROM `languages` AS `Language` WHERE `Language`.`online` = 1 ORDER BY `Language`.`order` ASC | | 2 | 2 | 0 | |
| SELECT `Language`.`id` FROM `languages` AS `Language` WHERE `Language`.`language` = 'dut' LIMIT 1 | | 1 | 1 | 0 | |
| SELECT `Menu`.*, `LanguagesMenu`.*, `I18n__title`.`content`, `I18n__description`.`content`, `I18n__keywords`.`content`, `Menu`.`id` FROM `menus` AS `Menu` LEFT JOIN `i18n` AS `I18n__title` ON (`Menu`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Menu' AND `I18n__title`.`field` = 'title') LEFT JOIN `i18n` AS `I18n__description` ON (`Menu`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'Menu' AND `I18n__description`.`field` = 'description') LEFT JOIN `i18n` AS `I18n__keywords` ON (`Menu`.`id` = `I18n__keywords`.`foreign_key` AND `I18n__keywords`.`model` = 'Menu' AND `I18n__keywords`.`field` = 'keywords') LEFT JOIN `languages_menus` AS `LanguagesMenu` ON (`LanguagesMenu`.`menu_id` = `Menu`.`id` AND `LanguagesMenu`.`language_id` = 1) WHERE `Menu`.`parent_id` IS NULL AND `Menu`.`metanav_only` = 0 AND `Menu`.`hidden` = 0 AND `I18n__title`.`locale` = 'dut' AND `I18n__description`.`locale` = 'dut' AND `I18n__keywords`.`locale` = 'dut' ORDER BY `Menu`.`lft` ASC | | 7 | 7 | 0 | |
| SELECT `title`.`id`, `title`.`locale`, `title`.`model`, `title`.`foreign_key`, `title`.`field`, `title`.`content` FROM `i18n` AS `title` WHERE `model` = 'Menu' AND `field` = 'title' AND `title`.`foreign_key` IN (1, 2, 10, 11, 12, 13, 3) | | 14 | 14 | 0 | |
| SELECT `description`.`id`, `description`.`locale`, `description`.`model`, `description`.`foreign_key`, `description`.`field`, `description`.`content` FROM `i18n` AS `description` WHERE `model` = 'Menu' AND `field` = 'description' AND `description`.`foreign_key` IN (1, 2, 10, 11, 12, 13, 3) | | 14 | 14 | 0 | |
| SELECT `keywords`.`id`, `keywords`.`locale`, `keywords`.`model`, `keywords`.`foreign_key`, `keywords`.`field`, `keywords`.`content` FROM `i18n` AS `keywords` WHERE `model` = 'Menu' AND `field` = 'keywords' AND `keywords`.`foreign_key` IN (1, 2, 10, 11, 12, 13, 3) | | 14 | 14 | 0 | |
| SELECT `Menu`.`url` FROM `menus` AS `Menu` WHERE `Menu`.`id` = 1 LIMIT 1 | | 1 | 1 | 0 | |
| SELECT `Menu`.`id` FROM `menus` AS `Menu` WHERE LOCATE(`Menu`.`url`,"http://eas002.preview.codedor.be/") != 0 ORDER BY `Menu`.`lft` DESC LIMIT 1 | | 1 | 1 | 0 | |
| SELECT `Menu`.`lft`, `Menu`.`rght` FROM `menus` AS `Menu` LEFT JOIN `languages_menus` AS `LanguagesMenu` ON (`LanguagesMenu`.`menu_id` = `Menu`.`id` AND `LanguagesMenu`.`language_id` = 1) WHERE `Menu`.`id` = 1 LIMIT 1 | | 1 | 1 | 0 | |
| SELECT `Menu`.`id` FROM `menus` AS `Menu` LEFT JOIN `languages_menus` AS `LanguagesMenu` ON (`LanguagesMenu`.`menu_id` = `Menu`.`id` AND `LanguagesMenu`.`language_id` = 1) WHERE 1 = 1 AND `Menu`.`lft` <= 1 AND `Menu`.`rght` >= 2 ORDER BY `Menu`.`lft` asc | | 1 | 1 | 0 | |
| SELECT `Language`.`id`, `Language`.`human`, `Language`.`humanshort`, `Language`.`locale`, `Language`.`language`, `Language`.`order`, `Language`.`online` FROM `languages` AS `Language` WHERE `Language`.`online` = 1 ORDER BY `Language`.`order` ASC | | 2 | 2 | 0 | |
| SELECT `Language`.`id` FROM `languages` AS `Language` WHERE `Language`.`language` = 'dut' LIMIT 1 | | 1 | 1 | 0 | |
| SELECT `Menu`.*, `LanguagesMenu`.*, `I18n__title`.`content`, `I18n__description`.`content`, `I18n__keywords`.`content`, `Menu`.`id` FROM `menus` AS `Menu` LEFT JOIN `i18n` AS `I18n__title` ON (`Menu`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Menu' AND `I18n__title`.`field` = 'title') LEFT JOIN `i18n` AS `I18n__description` ON (`Menu`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'Menu' AND `I18n__description`.`field` = 'description') LEFT JOIN `i18n` AS `I18n__keywords` ON (`Menu`.`id` = `I18n__keywords`.`foreign_key` AND `I18n__keywords`.`model` = 'Menu' AND `I18n__keywords`.`field` = 'keywords') LEFT JOIN `languages_menus` AS `LanguagesMenu` ON (`LanguagesMenu`.`menu_id` = `Menu`.`id` AND `LanguagesMenu`.`language_id` = 1) WHERE `Menu`.`metanav_only` = 0 AND `Menu`.`metaname` != 'home' AND `Menu`.`hidden` = 0 AND `I18n__title`.`locale` = 'dut' AND `I18n__description`.`locale` = 'dut' AND `I18n__keywords`.`locale` = 'dut' ORDER BY `Menu`.`lft` ASC | | 26 | 26 | 10 | maybe slow |
| SELECT `title`.`id`, `title`.`locale`, `title`.`model`, `title`.`foreign_key`, `title`.`field`, `title`.`content` FROM `i18n` AS `title` WHERE `model` = 'Menu' AND `field` = 'title' AND `title`.`foreign_key` IN (1, 2, 6, 7, 15, 16, 17, 8, 18, 10, 20, 21, 22, 23, 24, 25, 19, 28, 11, 26, 12, 27, 13, 3, 5, 4) | | 52 | 52 | 2 | |
| SELECT `description`.`id`, `description`.`locale`, `description`.`model`, `description`.`foreign_key`, `description`.`field`, `description`.`content` FROM `i18n` AS `description` WHERE `model` = 'Menu' AND `field` = 'description' AND `description`.`foreign_key` IN (1, 2, 6, 7, 15, 16, 17, 8, 18, 10, 20, 21, 22, 23, 24, 25, 19, 28, 11, 26, 12, 27, 13, 3, 5, 4) | | 52 | 52 | 1 | |
| SELECT `keywords`.`id`, `keywords`.`locale`, `keywords`.`model`, `keywords`.`foreign_key`, `keywords`.`field`, `keywords`.`content` FROM `i18n` AS `keywords` WHERE `model` = 'Menu' AND `field` = 'keywords' AND `keywords`.`foreign_key` IN (1, 2, 6, 7, 15, 16, 17, 8, 18, 10, 20, 21, 22, 23, 24, 25, 19, 28, 11, 26, 12, 27, 13, 3, 5, 4) | | 52 | 52 | 1 | |
| SELECT `Language`.`id`, `Language`.`human`, `Language`.`humanshort`, `Language`.`locale`, `Language`.`language`, `Language`.`order`, `Language`.`online`, `LanguagesMenu`.`language_id`, `LanguagesMenu`.`menu_id` FROM `languages` AS `Language` JOIN `languages_menus` AS `LanguagesMenu` ON (`LanguagesMenu`.`menu_id` IN (1, 2, 6, 7, 15, 16, 17, 8, 18, 10, 20, 21, 22, 23, 24, 25, 19, 28, 11, 26, 12, 27, 13, 3, 5, 4) AND `LanguagesMenu`.`language_id` = `Language`.`id`) | | 25 | 25 | 0 | |