| 1 | SELECT `Content`.`id`, `Content`.`parent_id`, `Content`.`name`, `Content`.`title`, `Content`.`type`, `Content`.`link_path`, `Content`.`link_target` FROM `contents` AS `Content` WHERE `Content`.`hidden` = 0 AND ((((`Content`.`active` = 1) AND (`Content`.`type` = 'document') AND (((`Content`.`expiration_date` >= '2012-02-05') OR (`Content`.`expiration_date` IS NULL))))) OR (`Content`.`type` != 'document')) ORDER BY `Content`.`sort` asc | | 12 | 12 | 1 |
| 2 | SELECT `Setting`.`id`, `Setting`.`title`, `Setting`.`keywords`, `Setting`.`description`, `Setting`.`google`, `Setting`.`facebook_pages` FROM `settings` AS `Setting` WHERE `Setting`.`id` = 1 LIMIT 1 | | 1 | 1 | 0 |
| 3 | SELECT `Content`.`id`, `Content`.`user_id`, `Content`.`parent_id`, `Content`.`attribute_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`name`, `Content`.`title`, `Content`.`type`, `Content`.`text`, `Content`.`link_path`, `Content`.`link_target`, `Content`.`active`, `Content`.`seo_keywords`, `Content`.`seo_description`, `Content`.`publish_date`, `Content`.`expiration_date`, `Content`.`attribute_count`, `Content`.`created`, `Content`.`modified`, `Content`.`sort`, `Content`.`hidden`, `CreatedBy`.`id`, `CreatedBy`.`first_name`, `CreatedBy`.`last_name`, `CreatedBy`.`role_id`, `Parent`.`id`, `Parent`.`user_id`, `Parent`.`parent_id`, `Parent`.`attribute_id`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`name`, `Parent`.`title`, `Parent`.`type`, `Parent`.`text`, `Parent`.`link_path`, `Parent`.`link_target`, `Parent`.`active`, `Parent`.`seo_keywords`, `Parent`.`seo_description`, `Parent`.`publish_date`, `Parent`.`expiration_date`, `Parent`.`attribute_count`, `Parent`.`created`, `Parent`.`modified`, `Parent`.`sort`, `Parent`.`hidden`, `AlbumCover`.`id`, `AlbumCover`.`content_id`, `AlbumCover`.`event_id`, `AlbumCover`.`inquiry_id`, `AlbumCover`.`job_id`, `AlbumCover`.`multimedia_id`, `AlbumCover`.`news_id`, `AlbumCover`.`user_id`, `AlbumCover`.`name`, `AlbumCover`.`type`, `AlbumCover`.`path`, `AlbumCover`.`caption`, `AlbumCover`.`created`, `AlbumCover`.`modified` FROM `contents` AS `Content` LEFT JOIN `users` AS `CreatedBy` ON (`Content`.`user_id` = `CreatedBy`.`id`) LEFT JOIN `contents` AS `Parent` ON (`Content`.`parent_id` = `Parent`.`id`) LEFT JOIN `attributes` AS `AlbumCover` ON (`Content`.`attribute_id` = `AlbumCover`.`id`) WHERE `Content`.`name` = 'Events' LIMIT 1 | | 1 | 1 | 0 |
| 4 | SELECT `Attribute`.`id`, `Attribute`.`content_id`, `Attribute`.`event_id`, `Attribute`.`inquiry_id`, `Attribute`.`job_id`, `Attribute`.`multimedia_id`, `Attribute`.`news_id`, `Attribute`.`user_id`, `Attribute`.`name`, `Attribute`.`type`, `Attribute`.`path`, `Attribute`.`caption`, `Attribute`.`created`, `Attribute`.`modified` FROM `attributes` AS `Attribute` WHERE `Attribute`.`content_id` = (8) ORDER BY `Attribute`.`id` DESC | | 0 | 0 | 0 |
| 5 | SELECT `Category`.`id`, `Category`.`module_id`, `Category`.`name`, `Category`.`hex`, `Category`.`font`, `Category`.`created`, `Category`.`modified`, `CategoriesContent`.`id`, `CategoriesContent`.`category_id`, `CategoriesContent`.`content_id` FROM `categories` AS `Category` JOIN `categories_contents` AS `CategoriesContent` ON (`CategoriesContent`.`content_id` = 8 AND `CategoriesContent`.`category_id` = `Category`.`id`) | | 0 | 0 | 0 |
| 6 | SELECT `Content`.`lft`, `Content`.`rght` FROM `contents` AS `Content` WHERE `Content`.`id` = 8 LIMIT 1 | | 1 | 1 | 1 |
| 7 | SELECT `Content`.`id`, `Content`.`user_id`, `Content`.`parent_id`, `Content`.`attribute_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`name`, `Content`.`title`, `Content`.`type`, `Content`.`text`, `Content`.`link_path`, `Content`.`link_target`, `Content`.`active`, `Content`.`seo_keywords`, `Content`.`seo_description`, `Content`.`publish_date`, `Content`.`expiration_date`, `Content`.`attribute_count`, `Content`.`created`, `Content`.`modified`, `Content`.`sort`, `Content`.`hidden` FROM `contents` AS `Content` WHERE 1 = 1 AND `Content`.`lft` <= 23 AND `Content`.`rght` >= 24 ORDER BY `Content`.`lft` asc | | 1 | 1 | 1 |