| Query | Error | Affected | Num. rows | Took (ms) | Actions |
|---|
| SHOW FULL COLUMNS FROM `aros` | | 7 | 7 | 0 | |
| SHOW FULL COLUMNS FROM `acos` | | 7 | 7 | 0 | |
| SHOW FULL COLUMNS FROM `aros_acos` | | 7 | 7 | 0 | |
| SHOW FULL COLUMNS FROM `contents` | | 12 | 12 | 0 | |
| SHOW FULL COLUMNS FROM `i18n` | | 6 | 6 | 0 | |
| SHOW FULL COLUMNS FROM `configurations` | | 3 | 3 | 0 | |
| SELECT `Configuration`.*, `I18n__value`.`content`, `Configuration`.`id` FROM `configurations` AS `Configuration` LEFT JOIN `i18n` AS `I18n__value` ON (`Configuration`.`id` = `I18n__value`.`foreign_key` AND `I18n__value`.`model` = 'Configuration' AND `I18n__value`.`field` = 'value') WHERE `I18n__value`.`locale` = 'cat' | | 15 | 15 | 0 | |
| SELECT `Values`.`id`, `Values`.`locale`, `Values`.`model`, `Values`.`foreign_key`, `Values`.`field`, `Values`.`content` FROM `i18n` AS `Values` WHERE `model` = 'Configuration' AND `field` = 'value' AND `Values`.`foreign_key` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 15, 11, 12, 13, 14) | | 55 | 55 | 0 | |
| SHOW FULL COLUMNS FROM `sections` | | 13 | 13 | 0 | |
| SELECT `Section`.*, `ParentSection`.*, `I18n__title`.`content`, `Section`.`id` FROM `sections` AS `Section` LEFT JOIN `i18n` AS `I18n__title` ON (`Section`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Section' AND `I18n__title`.`field` = 'title') LEFT JOIN `sections` AS `ParentSection` ON (`Section`.`parent_id` = `ParentSection`.`id`) WHERE `Section`.`parent_id` IS NULL AND `I18n__title`.`locale` = 'cat' ORDER BY `Section`.`sort` ASC | | 3 | 3 | 0 | |
| SELECT `Section`.*, `ParentSection`.*, `I18n__title`.`content`, `Section`.`id` FROM `sections` AS `Section` LEFT JOIN `i18n` AS `I18n__title` ON (`Section`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Section' AND `I18n__title`.`field` = 'title') LEFT JOIN `sections` AS `ParentSection` ON (`Section`.`parent_id` = `ParentSection`.`id`) WHERE `Section`.`id` = 21 AND `I18n__title`.`locale` = 'cat' LIMIT 1 | | 1 | 1 | 0 | |
| SELECT `Section`.*, `ParentSection`.*, `I18n__title`.`content`, `Section`.`id` FROM `sections` AS `Section` LEFT JOIN `i18n` AS `I18n__title` ON (`Section`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Section' AND `I18n__title`.`field` = 'title') LEFT JOIN `sections` AS `ParentSection` ON (`Section`.`parent_id` = `ParentSection`.`id`) WHERE `Section`.`parent_id` = 13 AND `I18n__title`.`locale` = 'cat' ORDER BY `Section`.`sort` ASC | | 6 | 6 | 0 | |
| SELECT `Section`.`lft`, `Section`.`rght` FROM `sections` AS `Section` WHERE `Section`.`id` = 21 LIMIT 1 | | 1 | 1 | 0 | |
| SELECT `Section`.*, `I18n__title`.`content` FROM `sections` AS `Section` LEFT JOIN `i18n` AS `I18n__title` ON (`Section`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Section' AND `I18n__title`.`field` = 'title') WHERE 1 = 1 AND `Section`.`lft` <= 18 AND `Section`.`rght` >= 19 AND `I18n__title`.`locale` = 'cat' ORDER BY `Section`.`lft` asc | | 2 | 2 | 1 | maybe slow |
| SHOW FULL COLUMNS FROM `content_files` | | 8 | 8 | 0 | |
| SHOW FULL COLUMNS FROM `content_links` | | 5 | 5 | 0 | |
| SELECT `Content`.*, `Section`.*, `I18n__title`.`content`, `I18n__text`.`content`, `Content`.`id` FROM `contents` AS `Content` LEFT JOIN `i18n` AS `I18n__title` ON (`Content`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Content' AND `I18n__title`.`field` = 'title') LEFT JOIN `i18n` AS `I18n__text` ON (`Content`.`id` = `I18n__text`.`foreign_key` AND `I18n__text`.`model` = 'Content' AND `I18n__text`.`field` = 'text') LEFT JOIN `sections` AS `Section` ON (`Content`.`section_id` = `Section`.`id`) WHERE `section_id` = 21 AND `I18n__title`.`locale` = 'cat' AND `I18n__text`.`locale` = 'cat' | | 1 | 1 | 1 | |
| SELECT `ContentFile`.`id`, `ContentFile`.`content_id`, `ContentFile`.`filename`, `ContentFile`.`dir`, `ContentFile`.`mimetype`, `ContentFile`.`filesize`, `ContentFile`.`created`, `ContentFile`.`modified` FROM `content_files` AS `ContentFile` WHERE `ContentFile`.`content_id` = (9) | | 0 | 0 | 0 | |
| SELECT `ContentLink`.`id`, `ContentLink`.`content_id`, `ContentLink`.`link`, `ContentLink`.`created`, `ContentLink`.`modified` FROM `content_links` AS `ContentLink` WHERE `ContentLink`.`content_id` = (9) | | 0 | 0 | 0 | |
| SELECT `Titles`.`id`, `Titles`.`locale`, `Titles`.`model`, `Titles`.`foreign_key`, `Titles`.`field`, `Titles`.`content` FROM `i18n` AS `Titles` WHERE `model` = 'Content' AND `field` = 'title' AND `Titles`.`foreign_key` = (9) | | 3 | 3 | 0 | |
| SELECT `Texts`.`id`, `Texts`.`locale`, `Texts`.`model`, `Texts`.`foreign_key`, `Texts`.`field`, `Texts`.`content` FROM `i18n` AS `Texts` WHERE `model` = 'Content' AND `field` = 'text' AND `Texts`.`foreign_key` = (9) | | 3 | 3 | 0 | |
| SELECT `Configuration`.*, `I18n__value`.`content`, `Configuration`.`id` FROM `configurations` AS `Configuration` LEFT JOIN `i18n` AS `I18n__value` ON (`Configuration`.`id` = `I18n__value`.`foreign_key` AND `I18n__value`.`model` = 'Configuration' AND `I18n__value`.`field` = 'value') WHERE `I18n__value`.`locale` = 'cat' | | 15 | 15 | 0 | |
| SELECT `Values`.`id`, `Values`.`locale`, `Values`.`model`, `Values`.`foreign_key`, `Values`.`field`, `Values`.`content` FROM `i18n` AS `Values` WHERE `model` = 'Configuration' AND `field` = 'value' AND `Values`.`foreign_key` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 15, 11, 12, 13, 14) | | 55 | 55 | 0 | |
| SELECT `Section`.*, `ParentSection`.*, `I18n__title`.`content`, `Section`.`id` FROM `sections` AS `Section` LEFT JOIN `i18n` AS `I18n__title` ON (`Section`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Section' AND `I18n__title`.`field` = 'title') LEFT JOIN `sections` AS `ParentSection` ON (`Section`.`parent_id` = `ParentSection`.`id`) WHERE `Section`.`parent_id` IS NULL AND `I18n__title`.`locale` = 'cat' ORDER BY `Section`.`sort` ASC | | 3 | 3 | 0 | |
| SELECT `Section`.*, `I18n__title`.`content` FROM `sections` AS `Section` LEFT JOIN `i18n` AS `I18n__title` ON (`Section`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Section' AND `I18n__title`.`field` = 'title') WHERE `Section`.`parent_id` = 12 AND `I18n__title`.`locale` = 'cat' ORDER BY `Section`.`sort` ASC | | 2 | 2 | 0 | |
| SELECT `Configuration`.*, `I18n__value`.`content`, `Configuration`.`id` FROM `configurations` AS `Configuration` LEFT JOIN `i18n` AS `I18n__value` ON (`Configuration`.`id` = `I18n__value`.`foreign_key` AND `I18n__value`.`model` = 'Configuration' AND `I18n__value`.`field` = 'value') WHERE `I18n__value`.`locale` = 'cat' | | 15 | 15 | 0 | |
| SELECT `Values`.`id`, `Values`.`locale`, `Values`.`model`, `Values`.`foreign_key`, `Values`.`field`, `Values`.`content` FROM `i18n` AS `Values` WHERE `model` = 'Configuration' AND `field` = 'value' AND `Values`.`foreign_key` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 15, 11, 12, 13, 14) | | 55 | 55 | 0 | |
| SELECT `Section`.*, `ParentSection`.*, `I18n__title`.`content`, `Section`.`id` FROM `sections` AS `Section` LEFT JOIN `i18n` AS `I18n__title` ON (`Section`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Section' AND `I18n__title`.`field` = 'title') LEFT JOIN `sections` AS `ParentSection` ON (`Section`.`parent_id` = `ParentSection`.`id`) WHERE `Section`.`parent_id` IS NULL AND `I18n__title`.`locale` = 'cat' ORDER BY `Section`.`sort` ASC | | 3 | 3 | 0 | |
| SELECT `Section`.*, `I18n__title`.`content` FROM `sections` AS `Section` LEFT JOIN `i18n` AS `I18n__title` ON (`Section`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Section' AND `I18n__title`.`field` = 'title') WHERE `Section`.`parent_id` = 13 AND `I18n__title`.`locale` = 'cat' ORDER BY `Section`.`sort` ASC | | 6 | 6 | 0 | |
