| 1 | SHOW FULL COLUMNS FROM `med_pages` | | 19 | 19 | 10 |
| 2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_unicode_ci'; | | 1 | 1 | 2 |
| 3 | SHOW FULL COLUMNS FROM `med_pages_translations` | | 6 | 6 | 3 |
| 4 | SELECT `Page`.`id` FROM `med_pages` AS `Page` WHERE 1 = 1 ORDER BY `lft` DESC | | 36 | 36 | 0 |
| 5 | SELECT `PageI18n`.`content` FROM `med_pages_translations` AS `PageI18n` WHERE `model` = 'Page' AND foreign_key IN (66, 40, 6, 30, 29, 5, 28, 27, 60, 26, 24, 53, 4, 39, 23, 22, 50, 21, 19, 18, 17, 16, 15, 14, 3, 13, 12, 11, 38, 37, 10, 9, 8, 7, 2, 1) AND `field` = 'path' | | 48 | 48 | 4 |
| 6 | SHOW FULL COLUMNS FROM `med_settings` | | 13 | 13 | 3 |
| 7 | SELECT `Setting`.`name`, `Setting`.`description`, `Setting`.`setting`, `Setting`.`value`, `Setting`.`vars` FROM `med_settings` AS `Setting` WHERE `category` = 'plugin' AND `status_id` = 1 ORDER BY `id` ASC | | 8 | 8 | 0 |
| 8 | SHOW FULL COLUMNS FROM `med_languages` | | 10 | 10 | 3 |
| 9 | SELECT `Language`.`native`, `Language`.`code`, `Language`.`locale`, `Language`.`fallback` FROM `med_languages` AS `Language` WHERE 1 = 1 ORDER BY `weight` ASC | | 2 | 2 | 0 |
| 10 | SET OPTION SQL_BIG_SELECTS=1 | | 0 | | 0 |
| 11 | SELECT `Setting`.`name`, `Setting`.`description`, `Setting`.`category`, `Setting`.`setting`, `Setting`.`value`, `Setting`.`vars` FROM `med_settings` AS `Setting` WHERE `status_id` = 1 AND NOT (`category` = 'plugin') ORDER BY `id` ASC | | 5 | 5 | 0 |
| 12 | SELECT `Language`.`native`, `Language`.`code`, `Language`.`locale`, `Language`.`fallback` FROM `med_languages` AS `Language` WHERE 1 = 1 ORDER BY `weight` ASC | | 2 | 2 | 0 |
| 13 | SHOW FULL COLUMNS FROM `med_events` | | 32 | 32 | 4 |
| 14 | SHOW FULL COLUMNS FROM `med_events_to_categories` | | 3 | 3 | 1 |
| 15 | SHOW FULL COLUMNS FROM `med_events_to_genres` | | 3 | 3 | 1 |
| 16 | SHOW FULL COLUMNS FROM `med_events_to_locations` | | 3 | 3 | 1 |
| 17 | SHOW FULL COLUMNS FROM `med_events_to_options` | | 3 | 3 | 1 |
| 18 | SHOW FULL COLUMNS FROM `med_events_to_makers` | | 3 | 3 | 1 |
| 19 | SHOW FULL COLUMNS FROM `med_events_to_relations` | | 3 | 3 | 1 |
| 20 | SHOW FULL COLUMNS FROM `med_events_translations` | | 6 | 6 | 2 |
| 21 | SHOW FULL COLUMNS FROM `med_tags` | | 7 | 7 | 5 |
| 22 | SHOW FULL COLUMNS FROM `med_tagged` | | 8 | 8 | 3 |
| 23 | SELECT `EventCategory`.`id`, `I18n__slug`.`content` FROM `med_events` AS `EventCategory` LEFT JOIN `med_events_translations` AS `I18n__slug` ON (`EventCategory`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'EventCategory' AND `I18n__slug`.`field` = 'slug') WHERE `I18n__slug`.`content` IN ('volwassenen', 'jeugd', 'familie') AND `EventCategory`.`type` = 'EventCategory' AND `I18n__slug`.`locale` = 'dut' | | 3 | 3 | 0 |
| 24 | SELECT `EventProgram`.`id`, `EventProgram`.`parent_id`, `EventProgram`.`date_start` FROM `med_events` AS `EventProgram` LEFT JOIN `med_events_to_categories` AS `EventsToCategories` ON (`EventsToCategories`.`event_id` = `EventProgram`.`id` AND `EventsToCategories`.`category_id` IN (1, 2, 3)) WHERE ((`EventProgram`.`date_start` >= '2012-02-04 20:37:52') AND (`EventProgram`.`status_id` = 1)) AND `EventsToCategories`.`category_id` IN (1, 2, 3) AND `EventProgram`.`type` = 'EventProgram' ORDER BY `EventProgram`.`date_start` ASC LIMIT 1 | | 1 | 1 | 25 |
| 25 | SELECT `EventCategory`.`id`, `EventsToCategories`.`id`, `EventsToCategories`.`category_id`, `EventsToCategories`.`event_id` FROM `med_events` AS `EventCategory` JOIN `med_events_to_categories` AS `EventsToCategories` ON (`EventsToCategories`.`event_id` = 1337 AND `EventsToCategories`.`category_id` = `EventCategory`.`id`) | | 1 | 1 | 0 |