| 1 | SELECT `Setting`.`key`, `Setting`.`value` FROM `simulatorcentrumsk2`.`settings` AS `Setting` WHERE 1 = 1 | | 70 | 70 | 1 |
| 2 | SELECT `Page`.`id`, (`I18n__title`.`content`) AS `Page__i18n_title`, (`I18n__menutitle`.`content`) AS `Page__i18n_menutitle` FROM `simulatorcentrumsk2`.`pages` AS `Page` LEFT JOIN `simulatorcentrumsk2`.`categories` AS `Category` ON (`Page`.`category_id` = `Category`.`id`) LEFT JOIN `simulatorcentrumsk2`.`galleries` AS `Gallery` ON (`Page`.`gallery_id` = `Gallery`.`id`) INNER JOIN `simulatorcentrumsk2`.`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 `simulatorcentrumsk2`.`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 | | 36 | 36 | 1 |
| 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 `simulatorcentrumsk2`.`categories` AS `Category` INNER JOIN `simulatorcentrumsk2`.`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 | | 3 | 3 | 1 |
| 4 | SELECT `Page`.`id`, `Page`.`title`, `Page`.`menutitle`, `Page`.`menusort`, `Page`.`menuicon`, `Page`.`category_id` FROM `simulatorcentrumsk2`.`pages` AS `Page` WHERE `Page`.`showinmenu` = '1' AND `Page`.`status` != 3 AND `Page`.`category_id` IN (1, 8, 9) | | 37 | 37 | 1 |
| 5 | SELECT `Menu`.`id`, `Menu`.`title`, `Menu`.`status`, `Menu`.`created`, `Menu`.`modified` FROM `simulatorcentrumsk2`.`menus` AS `Menu` WHERE `Menu`.`status` != 3 | | 3 | 3 | 1 |
| 6 | SELECT `Menuitem`.`id`, `Menuitem`.`menu_id`, `Menuitem`.`parent_id`, `Menuitem`.`sort`, `Menuitem`.`lft`, `Menuitem`.`rght`, `Menuitem`.`created`, `Menuitem`.`modified` FROM `simulatorcentrumsk2`.`menuitems` AS `Menuitem` WHERE `Menuitem`.`menu_id` IN (1, 3, 4) ORDER BY `Menuitem`.`sort` asc | | 35 | 35 | 1 |
| 7 | SELECT `Menuitem`.`id`, `Menuitem`.`menu_id`, `Menuitem`.`parent_id`, `Menuitem`.`sort`, `Menuitem`.`lft`, `Menuitem`.`rght`, `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 `simulatorcentrumsk2`.`menuitems` AS `Menuitem` LEFT JOIN `simulatorcentrumsk2`.`menus` AS `Menu` ON (`Menuitem`.`menu_id` = `Menu`.`id`) INNER JOIN `simulatorcentrumsk2`.`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 `simulatorcentrumsk2`.`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 | | 21 | 21 | 1 |
| 8 | SELECT `Menuitem`.`id`, `Menuitem`.`menu_id`, `Menuitem`.`parent_id`, `Menuitem`.`sort`, `Menuitem`.`lft`, `Menuitem`.`rght`, `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 `simulatorcentrumsk2`.`menuitems` AS `Menuitem` LEFT JOIN `simulatorcentrumsk2`.`menus` AS `Menu` ON (`Menuitem`.`menu_id` = `Menu`.`id`) INNER JOIN `simulatorcentrumsk2`.`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 `simulatorcentrumsk2`.`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 | | 13 | 13 | 1 |
| 9 | SELECT `Menuitem`.`id`, `Menuitem`.`menu_id`, `Menuitem`.`parent_id`, `Menuitem`.`sort`, `Menuitem`.`lft`, `Menuitem`.`rght`, `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 `simulatorcentrumsk2`.`menuitems` AS `Menuitem` LEFT JOIN `simulatorcentrumsk2`.`menus` AS `Menu` ON (`Menuitem`.`menu_id` = `Menu`.`id`) INNER JOIN `simulatorcentrumsk2`.`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 `simulatorcentrumsk2`.`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` = 4 ORDER BY `Menuitem`.`sort` asc | | 1 | 1 | 1 |
| 10 | SELECT `Booking`.`id`, `Booking`.`experiencevariant_id`, `Booking`.`simulator_id`, `Booking`.`starttime`, `Booking`.`endtime`, `Booking`.`instructor1_id`, `Booking`.`instructor2_id`, `Booking`.`atc_id`, `Booking`.`customer_id`, `Booking`.`voucherno`, `Booking`.`paymentmethod_id`, `Booking`.`notes`, `Booking`.`created`, `Booking`.`modified`, `Booking`.`eventtype_id`, `Booking`.`lastminuteofferprice`, `Booking`.`lastminutelockeduntil`, `Booking`.`lastminutelockuuid`, `Booking`.`removeafter`, `Booking`.`customernotes`, `Customer`.`id`, `Customer`.`name`, `Customer`.`phone`, `Customer`.`email`, `Customer`.`age`, `Customer`.`created`, `Customer`.`modified`, `Experiencevariant`.`id`, `Experiencevariant`.`experience_id`, `Experiencevariant`.`durationmins`, `Experiencevariant`.`buffermins`, `Experiencevariant`.`bufferposition`, `Experiencevariant`.`instructorsrequired`, `Experiencevariant`.`atcsrequired`, `Experiencevariant`.`price`, `Experiencevariant`.`baseprice`, `Experiencevariant`.`bestseller`, `Experiencevariant`.`status`, `Experiencevariant`.`bookable`, `Experiencevariant`.`soldout`, `Experiencevariant`.`buyable`, `Experiencevariant`.`showinpricelist`, `Experiencevariant`.`acceptedpaymentmethods`, `Experiencevariant`.`created`, `Experiencevariant`.`modified` FROM `simulatorcentrumsk2`.`bookings` AS `Booking` LEFT JOIN `simulatorcentrumsk2`.`customers` AS `Customer` ON (`Booking`.`customer_id` = `Customer`.`id`) LEFT JOIN `simulatorcentrumsk2`.`experiencevariants` AS `Experiencevariant` ON (`Booking`.`experiencevariant_id` = `Experiencevariant`.`id`) WHERE `Booking`.`eventtype_id` = 4 AND `Booking`.`starttime` >= '2025-06-19 08:33:27' LIMIT 4 | | 0 | 0 | 3 |
| 11 | SELECT `Experience`.`id`, (`I18n__title`.`content`) AS `Experience__i18n_title` FROM `simulatorcentrumsk2`.`experiences` AS `Experience` INNER JOIN `simulatorcentrumsk2`.`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') WHERE `Experience`.`status` = 1 | | 17 | 17 | 1 |
| 12 | SELECT `Experiencevariant`.`id`, `Experiencevariant`.`experience_id`, `Experiencevariant`.`durationmins`, `Experiencevariant`.`buffermins`, `Experiencevariant`.`bufferposition`, `Experiencevariant`.`instructorsrequired`, `Experiencevariant`.`atcsrequired`, `Experiencevariant`.`price`, `Experiencevariant`.`baseprice`, `Experiencevariant`.`bestseller`, `Experiencevariant`.`status`, `Experiencevariant`.`bookable`, `Experiencevariant`.`soldout`, `Experiencevariant`.`buyable`, `Experiencevariant`.`showinpricelist`, `Experiencevariant`.`acceptedpaymentmethods`, `Experiencevariant`.`created`, `Experiencevariant`.`modified`, (`I18n__title`.`content`) AS `Experiencevariant__i18n_title`, (`I18n__duration`.`content`) AS `Experiencevariant__i18n_duration`, (`I18n__content`.`content`) AS `Experiencevariant__i18n_content`, `Experience`.`id`, `Experience`.`simulator_id`, `Experience`.`difficulty_id`, `Experience`.`duration`, `Experience`.`price`, `Experience`.`imgname`, `Experience`.`gallery_id`, `Experience`.`status`, `Experience`.`display`, `Experience`.`forpilots`, `Experience`.`sellable`, `Experience`.`displayvariantsindetail`, `Experience`.`created`, `Experience`.`modified` FROM `simulatorcentrumsk2`.`experiencevariants` AS `Experiencevariant` LEFT JOIN `simulatorcentrumsk2`.`experiences` AS `Experience` ON (`Experiencevariant`.`experience_id` = `Experience`.`id`) INNER JOIN `simulatorcentrumsk2`.`i18n` AS `I18n__title` ON (`Experiencevariant`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Experiencevariant' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'slk') INNER JOIN `simulatorcentrumsk2`.`i18n` AS `I18n__duration` ON (`Experiencevariant`.`id` = `I18n__duration`.`foreign_key` AND `I18n__duration`.`model` = 'Experiencevariant' AND `I18n__duration`.`field` = 'duration' AND `I18n__duration`.`locale` = 'slk') INNER JOIN `simulatorcentrumsk2`.`i18n` AS `I18n__content` ON (`Experiencevariant`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'Experiencevariant' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'slk') WHERE `Experiencevariant`.`status` = 1 | | 20 | 20 | 1 |
| 13 | SELECT `User`.`id`, `User`.`username`, `User`.`email`, `User`.`password`, `User`.`isadmin`, `User`.`superadmin`, `User`.`instructor`, `User`.`atc`, `User`.`showinteam`, `User`.`displayname`, `User`.`profilepicture`, `User`.`displayemail`, `User`.`sort`, `User`.`created`, `User`.`modified`, `ExperiencevariantsUser`.`id`, `ExperiencevariantsUser`.`experiencevariant_id`, `ExperiencevariantsUser`.`user_id`, `ExperiencevariantsUser`.`created`, `ExperiencevariantsUser`.`modified` FROM `simulatorcentrumsk2`.`users` AS `User` JOIN `simulatorcentrumsk2`.`experiencevariants_users` AS `ExperiencevariantsUser` ON (`ExperiencevariantsUser`.`experiencevariant_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 14, 15, 16, 17, 18, 29, 30, 31) AND `ExperiencevariantsUser`.`user_id` = `User`.`id`) | | 222 | 222 | 2 |
| 14 | 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`, (`I18n__meta_description`.`content`) AS `Page__i18n_meta_description`, (`I18n__meta_keywords`.`content`) AS `Page__i18n_meta_keywords`, `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 `simulatorcentrumsk2`.`pages` AS `Page` LEFT JOIN `simulatorcentrumsk2`.`categories` AS `Category` ON (`Page`.`category_id` = `Category`.`id`) LEFT JOIN `simulatorcentrumsk2`.`galleries` AS `Gallery` ON (`Page`.`gallery_id` = `Gallery`.`id`) INNER JOIN `simulatorcentrumsk2`.`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 `simulatorcentrumsk2`.`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 `simulatorcentrumsk2`.`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 `simulatorcentrumsk2`.`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 `simulatorcentrumsk2`.`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 `simulatorcentrumsk2`.`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') INNER JOIN `simulatorcentrumsk2`.`i18n` AS `I18n__meta_description` ON (`Page`.`id` = `I18n__meta_description`.`foreign_key` AND `I18n__meta_description`.`model` = 'Page' AND `I18n__meta_description`.`field` = 'meta_description' AND `I18n__meta_description`.`locale` = 'slk') INNER JOIN `simulatorcentrumsk2`.`i18n` AS `I18n__meta_keywords` ON (`Page`.`id` = `I18n__meta_keywords`.`foreign_key` AND `I18n__meta_keywords`.`model` = 'Page' AND `I18n__meta_keywords`.`field` = 'meta_keywords' AND `I18n__meta_keywords`.`locale` = 'slk') WHERE `Page`.`id` = 58 AND `Page`.`status` = 1 LIMIT 1 | | 1 | 1 | 10 |
| 15 | SELECT `Gallery`.`id`, `Gallery`.`status`, `Gallery`.`visible`, `Gallery`.`created`, `Gallery`.`modified`, (`I18n__title`.`content`) AS `Gallery__i18n_title` FROM `simulatorcentrumsk2`.`galleries` AS `Gallery` INNER JOIN `simulatorcentrumsk2`.`i18n` AS `I18n__title` ON (`Gallery`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Gallery' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'slk') WHERE `Gallery`.`id` IS NULL LIMIT 1 | | 0 | 0 | 1 |
