Od 5.6.2020 znovu otvorené, za sprísnených hygienických požiadaviek. Vstup povolený len s rúškom a rukavicami.
V prípade problémov pri rezervácii nám, prosím, napíšte na info@simulatorcentrum.sk.
Odoslaním formulára v rezervačnom systéme súhlasíte so spracovaním osobných údajov podľa platnej GDPR legislatívy. Predpisy o ochrane osobných údajov Vám priznávajú práva tzv. dotknutej osoby. Vaše osobné údaje sú spracúvané prevádzkovateľom, ktorým je PT Engineering spol s r.o. so sídlom Gruzínska 18, 821 05 Bratislava. Osobné údaje získané odoslaním formulára v rezervačnom systéme nebudú použité za žiadnym iným účelom ani poskytnuté tretím stranám a nebudú zaradené do žiadnej databázy na zasielanie reklamných materiálov. Osobné údaje budeme spracúvať po dobu 12 mesiacov od udelenia súhlasu alebo až do doby jeho odvolania alebo vznesenia námietky. Po uplynutí tejto doby alebo po odvolaní súhlasu alebo vznesení námietky prestaneme osobné údaje spracúvať a vymažeme ich. Odvolanie súhlasu nemá vplyv na zákonnosť spracúvania osobných údajov založeného na súhlase pred jeho odvolaním. Odvolať súhlas na spracovanie osobných údajov môžete zaslaním e-mailu na adresu info@simulatorcentrum.sk.

1. Krok: Výber simulátora (kliknite na obrázok)

(default) 20 queries took 46 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Setting`.`key`, `Setting`.`value` FROM `simulatorcentrumsk2`.`settings` AS `Setting` WHERE 1 = 170701
2SELECT `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` asc36361
3SELECT `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` != 3331
4SELECT `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)37371
5SELECT `Menu`.`id`, `Menu`.`title`, `Menu`.`status`, `Menu`.`created`, `Menu`.`modified` FROM `simulatorcentrumsk2`.`menus` AS `Menu` WHERE `Menu`.`status` != 3331
6SELECT `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` asc35351
7SELECT `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` asc21211
8SELECT `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` asc13131
9SELECT `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` asc111
10SELECT `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:25:29' LIMIT 4004
11SELECT `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` = 117171
12SELECT `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` = 120202
13SELECT `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`) 2222222
14SELECT `Simulator`.`id`, `Simulator`.`title` FROM `simulatorcentrumsk2`.`simulators` AS `Simulator` WHERE `Simulator`.`enabled` = '1'221
15SELECT `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 AND `Experience`.`simulator_id` = 110104
16SELECT `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` != 3 AND `Experiencevariant`.`experience_id` IN (10, 11, 12, 13, 8, 15, 17, 20, 21, 26) AND `Experiencevariant`.`bookable` = '1'141417
17SELECT `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, 10, 11, 12, 13, 14, 17, 18, 29) AND `ExperiencevariantsUser`.`user_id` = `User`.`id`) 1641643
18SELECT `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'10101
19SELECT `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' AND `Paymentmethod`.`iscoupon` = '1'10101
20SELECT `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' AND `Paymentmethod`.`iscoupon` = '0'001