1 | SELECT `Setting`.`key`, `Setting`.`value` FROM `2sqepkn8`.`settings` AS `Setting` WHERE 1 = 1 | | 30 | 30 | 2 |
2 | SELECT `Page`.`id`, (`I18n__title`.`content`) AS `Page__i18n_title`, (`I18n__menutitle`.`content`) AS `Page__i18n_menutitle` FROM `2sqepkn8`.`pages` AS `Page` LEFT JOIN `2sqepkn8`.`categories` AS `Category` ON (`Page`.`category_id` = `Category`.`id`) LEFT JOIN `2sqepkn8`.`galleries` AS `Gallery` ON (`Page`.`gallery_id` = `Gallery`.`id`) INNER JOIN `2sqepkn8`.`i18n` AS `I18n__title` ON (`Page`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Page' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__menutitle` ON (`Page`.`id` = `I18n__menutitle`.`foreign_key` AND `I18n__menutitle`.`model` = 'Page' AND `I18n__menutitle`.`field` = 'menutitle' AND `I18n__menutitle`.`locale` = 'slk') WHERE `Page`.`showinmenu` = '1' AND `Page`.`status` = 1 ORDER BY `Page`.`menusort` asc | | 25 | 25 | 5 |
3 | SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`status`, `Category`.`menuicon`, `Category`.`lft`, `Category`.`rght`, `Category`.`created`, `Category`.`modified`, (`I18n__title`.`content`) AS `Category__i18n_title` FROM `2sqepkn8`.`categories` AS `Category` INNER JOIN `2sqepkn8`.`i18n` AS `I18n__title` ON (`Category`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Category' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'slk') WHERE `Category`.`status` != 3 | | 10 | 10 | 1 |
4 | SELECT `Page`.`id`, `Page`.`title`, `Page`.`menutitle`, `Page`.`menusort`, `Page`.`menuicon`, `Page`.`category_id` FROM `2sqepkn8`.`pages` AS `Page` WHERE `Page`.`showinmenu` = '1' AND `Page`.`status` != 3 AND `Page`.`category_id` IN (1, 8, 9, 10, 11, 12, 13, 14, 15, 16) | | 26 | 26 | 1 |
5 | SELECT `Menu`.`id`, `Menu`.`title`, `Menu`.`status`, `Menu`.`created`, `Menu`.`modified` FROM `2sqepkn8`.`menus` AS `Menu` WHERE `Menu`.`status` != 3 | | 2 | 2 | 1 |
6 | SELECT `Menuitem`.`id`, `Menuitem`.`menu_id`, `Menuitem`.`sort`, `Menuitem`.`created`, `Menuitem`.`modified` FROM `2sqepkn8`.`menuitems` AS `Menuitem` WHERE `Menuitem`.`menu_id` IN (1, 3) ORDER BY `Menuitem`.`sort` asc | | 14 | 14 | 1 |
7 | SELECT `Menuitem`.`id`, `Menuitem`.`menu_id`, `Menuitem`.`sort`, `Menuitem`.`created`, `Menuitem`.`modified`, (`I18n__title`.`content`) AS `Menuitem__i18n_title`, (`I18n__href`.`content`) AS `Menuitem__i18n_href`, `Menu`.`id`, `Menu`.`title`, `Menu`.`status`, `Menu`.`created`, `Menu`.`modified` FROM `2sqepkn8`.`menuitems` AS `Menuitem` LEFT JOIN `2sqepkn8`.`menus` AS `Menu` ON (`Menuitem`.`menu_id` = `Menu`.`id`) INNER JOIN `2sqepkn8`.`i18n` AS `I18n__title` ON (`Menuitem`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Menuitem' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__href` ON (`Menuitem`.`id` = `I18n__href`.`foreign_key` AND `I18n__href`.`model` = 'Menuitem' AND `I18n__href`.`field` = 'href' AND `I18n__href`.`locale` = 'slk') WHERE `Menuitem`.`menu_id` = 1 ORDER BY `Menuitem`.`sort` asc | | 9 | 9 | 5 |
8 | SELECT `Menuitem`.`id`, `Menuitem`.`menu_id`, `Menuitem`.`sort`, `Menuitem`.`created`, `Menuitem`.`modified`, (`I18n__title`.`content`) AS `Menuitem__i18n_title`, (`I18n__href`.`content`) AS `Menuitem__i18n_href`, `Menu`.`id`, `Menu`.`title`, `Menu`.`status`, `Menu`.`created`, `Menu`.`modified` FROM `2sqepkn8`.`menuitems` AS `Menuitem` LEFT JOIN `2sqepkn8`.`menus` AS `Menu` ON (`Menuitem`.`menu_id` = `Menu`.`id`) INNER JOIN `2sqepkn8`.`i18n` AS `I18n__title` ON (`Menuitem`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Menuitem' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__href` ON (`Menuitem`.`id` = `I18n__href`.`foreign_key` AND `I18n__href`.`model` = 'Menuitem' AND `I18n__href`.`field` = 'href' AND `I18n__href`.`locale` = 'slk') WHERE `Menuitem`.`menu_id` = 3 ORDER BY `Menuitem`.`sort` asc | | 0 | 0 | 1 |
9 | SELECT `Page`.`id`, `Page`.`category_id`, `Page`.`title`, `Page`.`showinmenu`, `Page`.`menutitle`, `Page`.`content_top`, `Page`.`content_top_more`, `Page`.`content`, `Page`.`content_additional`, `Page`.`content_add_bg`, `Page`.`content_add_color`, `Page`.`content_add_class`, `Page`.`menusort`, `Page`.`status`, `Page`.`menuicon`, `Page`.`gallery_id`, `Page`.`imgname`, `Page`.`created`, `Page`.`modified`, (`I18n__title`.`content`) AS `Page__i18n_title`, (`I18n__menutitle`.`content`) AS `Page__i18n_menutitle`, (`I18n__content_top`.`content`) AS `Page__i18n_content_top`, (`I18n__content_top_more`.`content`) AS `Page__i18n_content_top_more`, (`I18n__content`.`content`) AS `Page__i18n_content`, (`I18n__content_additional`.`content`) AS `Page__i18n_content_additional`, `Category`.`id`, `Category`.`parent_id`, `Category`.`status`, `Category`.`menuicon`, `Category`.`lft`, `Category`.`rght`, `Category`.`created`, `Category`.`modified`, `Gallery`.`id`, `Gallery`.`status`, `Gallery`.`visible`, `Gallery`.`created`, `Gallery`.`modified` FROM `2sqepkn8`.`pages` AS `Page` LEFT JOIN `2sqepkn8`.`categories` AS `Category` ON (`Page`.`category_id` = `Category`.`id`) LEFT JOIN `2sqepkn8`.`galleries` AS `Gallery` ON (`Page`.`gallery_id` = `Gallery`.`id`) INNER JOIN `2sqepkn8`.`i18n` AS `I18n__title` ON (`Page`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Page' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__menutitle` ON (`Page`.`id` = `I18n__menutitle`.`foreign_key` AND `I18n__menutitle`.`model` = 'Page' AND `I18n__menutitle`.`field` = 'menutitle' AND `I18n__menutitle`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content_top` ON (`Page`.`id` = `I18n__content_top`.`foreign_key` AND `I18n__content_top`.`model` = 'Page' AND `I18n__content_top`.`field` = 'content_top' AND `I18n__content_top`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content_top_more` ON (`Page`.`id` = `I18n__content_top_more`.`foreign_key` AND `I18n__content_top_more`.`model` = 'Page' AND `I18n__content_top_more`.`field` = 'content_top_more' AND `I18n__content_top_more`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content` ON (`Page`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'Page' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content_additional` ON (`Page`.`id` = `I18n__content_additional`.`foreign_key` AND `I18n__content_additional`.`model` = 'Page' AND `I18n__content_additional`.`field` = 'content_additional' AND `I18n__content_additional`.`locale` = 'slk') WHERE `Page`.`id` IN (66, 67, 68) | | 3 | 3 | 24 |
10 | SELECT `Post`.`id`, `Post`.`title`, `Post`.`content`, `Post`.`status`, `Post`.`created`, `Post`.`modified`, (`I18n__title`.`content`) AS `Post__i18n_title`, (`I18n__content`.`content`) AS `Post__i18n_content` FROM `2sqepkn8`.`posts` AS `Post` INNER JOIN `2sqepkn8`.`i18n` AS `I18n__title` ON (`Post`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Post' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content` ON (`Post`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'Post' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'slk') WHERE 1 = 1 ORDER BY `Post`.`modified` desc LIMIT 3 | | 2 | 2 | 2 |
11 | SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`status`, `Category`.`menuicon`, `Category`.`lft`, `Category`.`rght`, `Category`.`created`, `Category`.`modified`, (`I18n__title`.`content`) AS `Category__i18n_title` FROM `2sqepkn8`.`categories` AS `Category` INNER JOIN `2sqepkn8`.`i18n` AS `I18n__title` ON (`Category`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Category' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'slk') WHERE `Category`.`id` IN (2, 3) | | 0 | 0 | 1 |
12 | SELECT `Slider`.`id`, `Slider`.`title`, `Slider`.`status`, `Slider`.`created`, `Slider`.`modified` FROM `2sqepkn8`.`sliders` AS `Slider` WHERE `Slider`.`id` = 1 LIMIT 1 | | 1 | 1 | 0 |
13 | SELECT `Slide`.`id`, `Slide`.`slider_id`, `Slide`.`sort`, `Slide`.`title`, `Slide`.`content`, `Slide`.`imgext`, `Slide`.`created`, `Slide`.`modified` FROM `2sqepkn8`.`slides` AS `Slide` WHERE `Slide`.`slider_id` = (1) ORDER BY `Slide`.`sort` asc | | 1 | 1 | 0 |
14 | SELECT `Experience`.`id`, `Experience`.`difficulty_id`, `Experience`.`duration`, `Experience`.`price`, `Experience`.`imgname`, `Experience`.`gallery_id`, `Experience`.`status`, `Experience`.`display`, `Experience`.`created`, `Experience`.`modified`, (`I18n__title`.`content`) AS `Experience__i18n_title`, (`I18n__tile_content`.`content`) AS `Experience__i18n_tile_content`, (`I18n__btncontent`.`content`) AS `Experience__i18n_btncontent`, (`I18n__content_top`.`content`) AS `Experience__i18n_content_top`, (`I18n__content_top_more`.`content`) AS `Experience__i18n_content_top_more`, (`I18n__content`.`content`) AS `Experience__i18n_content`, (`I18n__skills_needed`.`content`) AS `Experience__i18n_skills_needed`, `Gallery`.`id`, `Gallery`.`status`, `Gallery`.`visible`, `Gallery`.`created`, `Gallery`.`modified`, `Difficulty`.`id`, `Difficulty`.`title` FROM `2sqepkn8`.`experiences` AS `Experience` LEFT JOIN `2sqepkn8`.`galleries` AS `Gallery` ON (`Experience`.`gallery_id` = `Gallery`.`id`) LEFT JOIN `2sqepkn8`.`difficulties` AS `Difficulty` ON (`Experience`.`difficulty_id` = `Difficulty`.`id`) INNER JOIN `2sqepkn8`.`i18n` AS `I18n__title` ON (`Experience`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Experience' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__tile_content` ON (`Experience`.`id` = `I18n__tile_content`.`foreign_key` AND `I18n__tile_content`.`model` = 'Experience' AND `I18n__tile_content`.`field` = 'tile_content' AND `I18n__tile_content`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__btncontent` ON (`Experience`.`id` = `I18n__btncontent`.`foreign_key` AND `I18n__btncontent`.`model` = 'Experience' AND `I18n__btncontent`.`field` = 'btncontent' AND `I18n__btncontent`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content_top` ON (`Experience`.`id` = `I18n__content_top`.`foreign_key` AND `I18n__content_top`.`model` = 'Experience' AND `I18n__content_top`.`field` = 'content_top' AND `I18n__content_top`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content_top_more` ON (`Experience`.`id` = `I18n__content_top_more`.`foreign_key` AND `I18n__content_top_more`.`model` = 'Experience' AND `I18n__content_top_more`.`field` = 'content_top_more' AND `I18n__content_top_more`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content` ON (`Experience`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'Experience' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__skills_needed` ON (`Experience`.`id` = `I18n__skills_needed`.`foreign_key` AND `I18n__skills_needed`.`model` = 'Experience' AND `I18n__skills_needed`.`field` = 'skills_needed' AND `I18n__skills_needed`.`locale` = 'slk') WHERE `Experience`.`status` = 1 AND `Experience`.`display` = '1' ORDER BY rand() ASC LIMIT 1 | | 1 | 1 | 406 |
15 | SELECT `Page`.`id`, `Page`.`category_id`, `Page`.`title`, `Page`.`showinmenu`, `Page`.`menutitle`, `Page`.`content_top`, `Page`.`content_top_more`, `Page`.`content`, `Page`.`content_additional`, `Page`.`content_add_bg`, `Page`.`content_add_color`, `Page`.`content_add_class`, `Page`.`menusort`, `Page`.`status`, `Page`.`menuicon`, `Page`.`gallery_id`, `Page`.`imgname`, `Page`.`created`, `Page`.`modified`, (`I18n__title`.`content`) AS `Page__i18n_title`, (`I18n__menutitle`.`content`) AS `Page__i18n_menutitle`, (`I18n__content_top`.`content`) AS `Page__i18n_content_top`, (`I18n__content_top_more`.`content`) AS `Page__i18n_content_top_more`, (`I18n__content`.`content`) AS `Page__i18n_content`, (`I18n__content_additional`.`content`) AS `Page__i18n_content_additional`, `Category`.`id`, `Category`.`parent_id`, `Category`.`status`, `Category`.`menuicon`, `Category`.`lft`, `Category`.`rght`, `Category`.`created`, `Category`.`modified`, `Gallery`.`id`, `Gallery`.`status`, `Gallery`.`visible`, `Gallery`.`created`, `Gallery`.`modified` FROM `2sqepkn8`.`pages` AS `Page` LEFT JOIN `2sqepkn8`.`categories` AS `Category` ON (`Page`.`category_id` = `Category`.`id`) LEFT JOIN `2sqepkn8`.`galleries` AS `Gallery` ON (`Page`.`gallery_id` = `Gallery`.`id`) INNER JOIN `2sqepkn8`.`i18n` AS `I18n__title` ON (`Page`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Page' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__menutitle` ON (`Page`.`id` = `I18n__menutitle`.`foreign_key` AND `I18n__menutitle`.`model` = 'Page' AND `I18n__menutitle`.`field` = 'menutitle' AND `I18n__menutitle`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content_top` ON (`Page`.`id` = `I18n__content_top`.`foreign_key` AND `I18n__content_top`.`model` = 'Page' AND `I18n__content_top`.`field` = 'content_top' AND `I18n__content_top`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content_top_more` ON (`Page`.`id` = `I18n__content_top_more`.`foreign_key` AND `I18n__content_top_more`.`model` = 'Page' AND `I18n__content_top_more`.`field` = 'content_top_more' AND `I18n__content_top_more`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content` ON (`Page`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'Page' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content_additional` ON (`Page`.`id` = `I18n__content_additional`.`foreign_key` AND `I18n__content_additional`.`model` = 'Page' AND `I18n__content_additional`.`field` = 'content_additional' AND `I18n__content_additional`.`locale` = 'slk') WHERE `Page`.`status` = 1 AND `Page`.`category_id` = 9 ORDER BY rand() ASC LIMIT 1 | | 0 | 0 | 15 |
16 | SELECT `Gallery`.`id` FROM `2sqepkn8`.`galleries` AS `Gallery` WHERE `Gallery`.`status` = 1 AND `Gallery`.`visible` = 1 | | 11 | 11 | 0 |
17 | SELECT `Picture`.`id`, `Picture`.`gallery_id`, `Picture`.`title`, `Picture`.`saved_filename`, `Picture`.`original_filename`, `Picture`.`video_url`, `Picture`.`filesize`, `Picture`.`sort`, `Picture`.`created`, `Picture`.`modified` FROM `2sqepkn8`.`pictures` AS `Picture` WHERE `Picture`.`gallery_id` IN (22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32) ORDER BY rand() ASC LIMIT 3 | | 3 | 3 | 11 |
18 | SELECT `Post`.`id`, `Post`.`title`, `Post`.`content`, `Post`.`status`, `Post`.`created`, `Post`.`modified`, (`I18n__title`.`content`) AS `Post__i18n_title`, (`I18n__content`.`content`) AS `Post__i18n_content` FROM `2sqepkn8`.`posts` AS `Post` INNER JOIN `2sqepkn8`.`i18n` AS `I18n__title` ON (`Post`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Post' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content` ON (`Post`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'Post' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'slk') WHERE `Post`.`status` = 1 ORDER BY `Post`.`modified` desc LIMIT 3 | | 0 | 0 | 2 |
19 | SELECT `Experience`.`id`, `Experience`.`difficulty_id`, `Experience`.`duration`, `Experience`.`price`, `Experience`.`imgname`, `Experience`.`gallery_id`, `Experience`.`status`, `Experience`.`display`, `Experience`.`created`, `Experience`.`modified`, (`I18n__title`.`content`) AS `Experience__i18n_title`, (`I18n__tile_content`.`content`) AS `Experience__i18n_tile_content`, (`I18n__btncontent`.`content`) AS `Experience__i18n_btncontent`, (`I18n__content_top`.`content`) AS `Experience__i18n_content_top`, (`I18n__content_top_more`.`content`) AS `Experience__i18n_content_top_more`, (`I18n__content`.`content`) AS `Experience__i18n_content`, (`I18n__skills_needed`.`content`) AS `Experience__i18n_skills_needed`, `Gallery`.`id`, `Gallery`.`status`, `Gallery`.`visible`, `Gallery`.`created`, `Gallery`.`modified`, `Difficulty`.`id`, `Difficulty`.`title` FROM `2sqepkn8`.`experiences` AS `Experience` LEFT JOIN `2sqepkn8`.`galleries` AS `Gallery` ON (`Experience`.`gallery_id` = `Gallery`.`id`) LEFT JOIN `2sqepkn8`.`difficulties` AS `Difficulty` ON (`Experience`.`difficulty_id` = `Difficulty`.`id`) INNER JOIN `2sqepkn8`.`i18n` AS `I18n__title` ON (`Experience`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Experience' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__tile_content` ON (`Experience`.`id` = `I18n__tile_content`.`foreign_key` AND `I18n__tile_content`.`model` = 'Experience' AND `I18n__tile_content`.`field` = 'tile_content' AND `I18n__tile_content`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__btncontent` ON (`Experience`.`id` = `I18n__btncontent`.`foreign_key` AND `I18n__btncontent`.`model` = 'Experience' AND `I18n__btncontent`.`field` = 'btncontent' AND `I18n__btncontent`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content_top` ON (`Experience`.`id` = `I18n__content_top`.`foreign_key` AND `I18n__content_top`.`model` = 'Experience' AND `I18n__content_top`.`field` = 'content_top' AND `I18n__content_top`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content_top_more` ON (`Experience`.`id` = `I18n__content_top_more`.`foreign_key` AND `I18n__content_top_more`.`model` = 'Experience' AND `I18n__content_top_more`.`field` = 'content_top_more' AND `I18n__content_top_more`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content` ON (`Experience`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'Experience' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__skills_needed` ON (`Experience`.`id` = `I18n__skills_needed`.`foreign_key` AND `I18n__skills_needed`.`model` = 'Experience' AND `I18n__skills_needed`.`field` = 'skills_needed' AND `I18n__skills_needed`.`locale` = 'slk') WHERE `Experience`.`status` = 1 AND `Experience`.`id` = 12 LIMIT 1 | | 1 | 1 | 5 |
20 | SELECT `Page`.`id`, `Page`.`category_id`, `Page`.`title`, `Page`.`showinmenu`, `Page`.`menutitle`, `Page`.`content_top`, `Page`.`content_top_more`, `Page`.`content`, `Page`.`content_additional`, `Page`.`content_add_bg`, `Page`.`content_add_color`, `Page`.`content_add_class`, `Page`.`menusort`, `Page`.`status`, `Page`.`menuicon`, `Page`.`gallery_id`, `Page`.`imgname`, `Page`.`created`, `Page`.`modified`, (`I18n__title`.`content`) AS `Page__i18n_title`, (`I18n__menutitle`.`content`) AS `Page__i18n_menutitle`, (`I18n__content_top`.`content`) AS `Page__i18n_content_top`, (`I18n__content_top_more`.`content`) AS `Page__i18n_content_top_more`, (`I18n__content`.`content`) AS `Page__i18n_content`, (`I18n__content_additional`.`content`) AS `Page__i18n_content_additional`, `Category`.`id`, `Category`.`parent_id`, `Category`.`status`, `Category`.`menuicon`, `Category`.`lft`, `Category`.`rght`, `Category`.`created`, `Category`.`modified`, `Gallery`.`id`, `Gallery`.`status`, `Gallery`.`visible`, `Gallery`.`created`, `Gallery`.`modified` FROM `2sqepkn8`.`pages` AS `Page` LEFT JOIN `2sqepkn8`.`categories` AS `Category` ON (`Page`.`category_id` = `Category`.`id`) LEFT JOIN `2sqepkn8`.`galleries` AS `Gallery` ON (`Page`.`gallery_id` = `Gallery`.`id`) INNER JOIN `2sqepkn8`.`i18n` AS `I18n__title` ON (`Page`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Page' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__menutitle` ON (`Page`.`id` = `I18n__menutitle`.`foreign_key` AND `I18n__menutitle`.`model` = 'Page' AND `I18n__menutitle`.`field` = 'menutitle' AND `I18n__menutitle`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content_top` ON (`Page`.`id` = `I18n__content_top`.`foreign_key` AND `I18n__content_top`.`model` = 'Page' AND `I18n__content_top`.`field` = 'content_top' AND `I18n__content_top`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content_top_more` ON (`Page`.`id` = `I18n__content_top_more`.`foreign_key` AND `I18n__content_top_more`.`model` = 'Page' AND `I18n__content_top_more`.`field` = 'content_top_more' AND `I18n__content_top_more`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content` ON (`Page`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'Page' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'slk') INNER JOIN `2sqepkn8`.`i18n` AS `I18n__content_additional` ON (`Page`.`id` = `I18n__content_additional`.`foreign_key` AND `I18n__content_additional`.`model` = 'Page' AND `I18n__content_additional`.`field` = 'content_additional' AND `I18n__content_additional`.`locale` = 'slk') WHERE `Page`.`id` = 19 LIMIT 1 | | 1 | 1 | 2 |