| 1 | SHOW FULL COLUMNS FROM `contents` | | 12 | 12 | 2 |
| 2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci'; | | 1 | 1 | 1 |
| 3 | SHOW FULL COLUMNS FROM `content_types` | | 2 | 2 | 2 |
| 4 | SHOW FULL COLUMNS FROM `i18n` | | 6 | 6 | 2 |
| 5 | SHOW FULL COLUMNS FROM `blocks` | | 7 | 7 | 1 |
| 6 | SHOW FULL COLUMNS FROM `content_blocks` | | 2 | 2 | 2 |
| 7 | SHOW FULL COLUMNS FROM `tags` | | 5 | 5 | 1 |
| 8 | SHOW FULL COLUMNS FROM `tag_types` | | 2 | 2 | 2 |
| 9 | SHOW FULL COLUMNS FROM `paintings` | | 7 | 7 | 3 |
| 10 | SHOW FULL COLUMNS FROM `painting_tags` | | 2 | 2 | 6 |
| 11 | SELECT `Content`.*, `ContentType`.*, `I18n__title`.`content`, `I18n__body`.`content`, `I18n__metatags`.`content`, `I18n__keywords`.`content`, `I18n__navigate_url`.`content`, `I18n__menu_text`.`content` FROM `contents` AS `Content` INNER JOIN `i18n` AS `I18n__title` ON (`Content`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Content' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'eng') INNER JOIN `i18n` AS `I18n__body` ON (`Content`.`id` = `I18n__body`.`foreign_key` AND `I18n__body`.`model` = 'Content' AND `I18n__body`.`field` = 'body' AND `I18n__body`.`locale` = 'eng') INNER JOIN `i18n` AS `I18n__metatags` ON (`Content`.`id` = `I18n__metatags`.`foreign_key` AND `I18n__metatags`.`model` = 'Content' AND `I18n__metatags`.`field` = 'metatags' AND `I18n__metatags`.`locale` = 'eng') INNER JOIN `i18n` AS `I18n__keywords` ON (`Content`.`id` = `I18n__keywords`.`foreign_key` AND `I18n__keywords`.`model` = 'Content' AND `I18n__keywords`.`field` = 'keywords' AND `I18n__keywords`.`locale` = 'eng') INNER JOIN `i18n` AS `I18n__navigate_url` ON (`Content`.`id` = `I18n__navigate_url`.`foreign_key` AND `I18n__navigate_url`.`model` = 'Content' AND `I18n__navigate_url`.`field` = 'navigate_url' AND `I18n__navigate_url`.`locale` = 'eng') INNER JOIN `i18n` AS `I18n__menu_text` ON (`Content`.`id` = `I18n__menu_text`.`foreign_key` AND `I18n__menu_text`.`model` = 'Content' AND `I18n__menu_text`.`field` = 'menu_text' AND `I18n__menu_text`.`locale` = 'eng') LEFT JOIN `content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) WHERE `I18n__navigate_url`.`content` = 'biography' AND `Content`.`published` = 1 LIMIT 1 | | 1 | 1 | 4 |
| 12 | SELECT `Content`.`id`, `I18n__title`.`content`, `I18n__navigate_url`.`content`, `I18n__menu_text`.`content` FROM `contents` AS `Content` INNER JOIN `i18n` AS `I18n__title` ON (`Content`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Content' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'eng') INNER JOIN `i18n` AS `I18n__navigate_url` ON (`Content`.`id` = `I18n__navigate_url`.`foreign_key` AND `I18n__navigate_url`.`model` = 'Content' AND `I18n__navigate_url`.`field` = 'navigate_url' AND `I18n__navigate_url`.`locale` = 'eng') INNER JOIN `i18n` AS `I18n__menu_text` ON (`Content`.`id` = `I18n__menu_text`.`foreign_key` AND `I18n__menu_text`.`model` = 'Content' AND `I18n__menu_text`.`field` = 'menu_text' AND `I18n__menu_text`.`locale` = 'eng') LEFT JOIN `content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) WHERE `Content`.`published` = 1 AND `Content`.`in_menu` = 1 ORDER BY `Content`.`order` ASC | | 5 | 5 | 2 |
| 13 | SELECT
Block.id,
Block.name,
Block.published,
Block.order,
Block.conten_location,
I18n__title.content,
I18n__body.content,
Content.id,
content_blocks.content_id,
content_blocks.block_id
FROM blocks AS Block
Left Join content_blocks On ( content_blocks.block_id = Block.id)
Left Join contents AS Content ON(content_blocks.content_id = Content.id)
INNER JOIN i18n AS I18n__title ON (Block.id = I18n__title.foreign_key AND I18n__title.model = 'Block' AND I18n__title.field = 'title' AND I18n__title.locale = 'eng')
INNER JOIN i18n AS I18n__body ON (Block.id = I18n__body.foreign_key AND I18n__body.model = 'Block' AND I18n__body.field = 'body' AND I18n__body.locale = 'eng')
WHERE Content.id=4
ORDER BY Block.order
| | 3 | 3 | 2 |
