| 1 | SELECT `Setting`.`key`, `Setting`.`value` FROM `simulatorcentrumsk2`.`settings` AS `Setting` WHERE 1 = 1 | | 70 | 70 | 5 |
| 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 | 59 |
| 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 | 6 |
| 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 | 2 |
| 5 | SELECT `Menu`.`id`, `Menu`.`title`, `Menu`.`status`, `Menu`.`created`, `Menu`.`modified` FROM `simulatorcentrumsk2`.`menus` AS `Menu` WHERE `Menu`.`status` != 3 | | 3 | 3 | 5 |
| 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 | 5 |
| 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 | 6 |
| 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 | 6 |
| 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 | 4 |
| 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 07:59:13' LIMIT 4 | | 0 | 0 | 9 |
| 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 | 8 |
| 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 | 22 |
| 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 | 10 |
| 14 | SELECT `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`, (`I18n__title`.`content`) AS `Experience__i18n_title`, (`I18n__tile_content`.`content`) AS `Experience__i18n_tile_content`, (`I18n__duration`.`content`) AS `Experience__i18n_duration`, (`I18n__price`.`content`) AS `Experience__i18n_price`, (`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`, (`I18n__meta_description`.`content`) AS `Experience__i18n_meta_description`, (`I18n__meta_keywords`.`content`) AS `Experience__i18n_meta_keywords`, `Gallery`.`id`, `Gallery`.`status`, `Gallery`.`visible`, `Gallery`.`created`, `Gallery`.`modified`, `Simulator`.`id`, `Simulator`.`title`, `Simulator`.`enabled`, `Simulator`.`created`, `Simulator`.`modified`, `Experienceprice`.`experience_id`, `Experienceprice`.`minprice`, `Experienceprice`.`maxprice` FROM `simulatorcentrumsk2`.`experiences` AS `Experience` LEFT JOIN `simulatorcentrumsk2`.`galleries` AS `Gallery` ON (`Experience`.`gallery_id` = `Gallery`.`id`) LEFT JOIN `simulatorcentrumsk2`.`simulators` AS `Simulator` ON (`Experience`.`simulator_id` = `Simulator`.`id`) LEFT JOIN `simulatorcentrumsk2`.`experienceprices` AS `Experienceprice` ON (`Experienceprice`.`experience_id` = `Experience`.`id`) 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') INNER JOIN `simulatorcentrumsk2`.`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 `simulatorcentrumsk2`.`i18n` AS `I18n__duration` ON (`Experience`.`id` = `I18n__duration`.`foreign_key` AND `I18n__duration`.`model` = 'Experience' AND `I18n__duration`.`field` = 'duration' AND `I18n__duration`.`locale` = 'slk') INNER JOIN `simulatorcentrumsk2`.`i18n` AS `I18n__price` ON (`Experience`.`id` = `I18n__price`.`foreign_key` AND `I18n__price`.`model` = 'Experience' AND `I18n__price`.`field` = 'price' AND `I18n__price`.`locale` = 'slk') INNER JOIN `simulatorcentrumsk2`.`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 `simulatorcentrumsk2`.`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 `simulatorcentrumsk2`.`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 `simulatorcentrumsk2`.`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 `simulatorcentrumsk2`.`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') INNER JOIN `simulatorcentrumsk2`.`i18n` AS `I18n__meta_description` ON (`Experience`.`id` = `I18n__meta_description`.`foreign_key` AND `I18n__meta_description`.`model` = 'Experience' AND `I18n__meta_description`.`field` = 'meta_description' AND `I18n__meta_description`.`locale` = 'slk') INNER JOIN `simulatorcentrumsk2`.`i18n` AS `I18n__meta_keywords` ON (`Experience`.`id` = `I18n__meta_keywords`.`foreign_key` AND `I18n__meta_keywords`.`model` = 'Experience' AND `I18n__meta_keywords`.`field` = 'meta_keywords' AND `I18n__meta_keywords`.`locale` = 'slk') WHERE `Experience`.`id` = 25 AND `Experience`.`status` = 1 LIMIT 1 | | 1 | 1 | 24 |
| 15 | 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` FROM `simulatorcentrumsk2`.`experiencevariants` AS `Experiencevariant` WHERE `Experiencevariant`.`experience_id` = (25) | | 1 | 1 | 2 |
| 16 | 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` = 24 LIMIT 1 | | 1 | 1 | 2 |
| 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 `simulatorcentrumsk2`.`pictures` AS `Picture` WHERE `Picture`.`gallery_id` = (24) ORDER BY `Picture`.`sort` asc | | 8 | 8 | 5 |
| 18 | SELECT `Simulator`.`id`, `Simulator`.`title` FROM `simulatorcentrumsk2`.`simulators` AS `Simulator` WHERE 1 = 1 | | 3 | 3 | 1 |
| 19 | SELECT `Experiencevariant`.`id`, `Experiencevariant`.`price`, `Experiencevariant`.`baseprice`, `Experiencevariant`.`status`, `Experiencevariant`.`bookable`, `Experiencevariant`.`buyable`, `Experiencevariant`.`showinpricelist`, (`I18n__title`.`content`) AS `Experiencevariant__i18n_title`, (`I18n__duration`.`content`) AS `Experiencevariant__i18n_duration`, (`I18n__content`.`content`) AS `Experiencevariant__i18n_content` 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`.`experience_id` = 25 AND `Experiencevariant`.`status` != 3 | | 1 | 1 | 13 |
| 20 | 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` = 16 AND `ExperiencevariantsUser`.`user_id` = `User`.`id`) | | 13 | 13 | 2 |
| 21 | SELECT `Discount`.`id`, `Discount`.`title`, `Discount`.`discounttype`, `Discount`.`amount`, `Discount`.`startdate`, `Discount`.`enddate`, `Discount`.`status`, `Discount`.`created`, `Discount`.`modified` FROM `simulatorcentrumsk2`.`discounts` AS `Discount` INNER JOIN `simulatorcentrumsk2`.`discounts_experiencevariants` AS `DiscountsExperiencevariant` ON (`DiscountsExperiencevariant`.`experiencevariant_id` = (16) AND `DiscountsExperiencevariant`.`discount_id` = `Discount`.`id`) WHERE `Discount`.`startdate` <= '2025-06-19 07:59:13' AND `Discount`.`enddate` >= '2025-06-19 07:59:13' AND `Discount`.`status` = 1 GROUP BY `Discount`.`id` | | 0 | 0 | 5 |
| 22 | SELECT `Paymentmethod`.`id`, (`I18n__title`.`content`) AS `Paymentmethod__i18n_title` FROM `simulatorcentrumsk2`.`paymentmethods` AS `Paymentmethod` INNER JOIN `simulatorcentrumsk2`.`i18n` AS `I18n__title` ON (`Paymentmethod`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Paymentmethod' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'slk') WHERE `Paymentmethod`.`status` = 1 AND `Paymentmethod`.`showinbooking` = '1' | | 10 | 10 | 6 |
| 23 | SELECT `Openinghour`.`id`, `Openinghour`.`ohtype_id`, `Openinghour`.`weekday`, `Openinghour`.`startdate`, `Openinghour`.`enddate`, `Openinghour`.`ohs`, `Openinghour`.`ohe`, `Openinghour`.`created`, `Openinghour`.`modified` FROM `simulatorcentrumsk2`.`openinghours` AS `Openinghour` WHERE `Openinghour`.`ohtype_id` = 1 | | 7 | 7 | 5 |
| 24 | SELECT `Openinghour`.`id`, `Openinghour`.`ohtype_id`, `Openinghour`.`weekday`, `Openinghour`.`startdate`, `Openinghour`.`enddate`, `Openinghour`.`ohs`, `Openinghour`.`ohe`, `Openinghour`.`created`, `Openinghour`.`modified` FROM `simulatorcentrumsk2`.`openinghours` AS `Openinghour` WHERE `Openinghour`.`ohtype_id` = 2 AND `Openinghour`.`enddate` >= '2025-06-19' | | 0 | 0 | 1 |
| 25 | SELECT `Openinghour`.`id`, `Openinghour`.`ohtype_id`, `Openinghour`.`weekday`, `Openinghour`.`startdate`, `Openinghour`.`enddate`, `Openinghour`.`ohs`, `Openinghour`.`ohe`, `Openinghour`.`created`, `Openinghour`.`modified` FROM `simulatorcentrumsk2`.`openinghours` AS `Openinghour` WHERE `Openinghour`.`ohtype_id` = 3 AND `Openinghour`.`enddate` >= '2025-06-19' | | 0 | 0 | 1 |
| 26 | SELECT `Experiencevariant`.`id`, (`I18n__title`.`content`) AS `Experiencevariant__i18n_title` FROM `simulatorcentrumsk2`.`experiencevariants` AS `Experiencevariant` 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') WHERE `Experiencevariant`.`experience_id` = 25 AND `Experiencevariant`.`status` != 3 | | 1 | 1 | 5 |
| 27 | 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`.`experiencevariant_id` = (16) AND `Booking`.`starttime` >= '2025-06-19 07:59:13' | | 0 | 0 | 4 |
