| 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 | 2 |
| 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:02:33' LIMIT 4 | | 0 | 0 | 4 |
| 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 | 2 |
| 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 `Document`.`id`, `Document`.`documentfolder_id`, `Document`.`original_filename`, `Document`.`saved_filename`, `Document`.`filesize`, `Document`.`description`, `Document`.`ext`, `Document`.`sort`, `Document`.`times_downloaded`, `Document`.`created`, `Documentfolder`.`id`, `Documentfolder`.`title`, `Documentfolder`.`description`, `Documentfolder`.`parent_id`, `Documentfolder`.`lft`, `Documentfolder`.`rght` FROM `simulatorcentrumsk2`.`documents` AS `Document` LEFT JOIN `simulatorcentrumsk2`.`documentfolders` AS `Documentfolder` ON (`Document`.`documentfolder_id` = `Documentfolder`.`id`) WHERE `Document`.`documentfolder_id` = 2 | | 4 | 4 | 2 |