Restaurant MERCURE Sofia

Sofia

Buchung

Adresse:бул. България 83

Telefon:+359 2 818 96 18

Dienste:Wi Fi, Parkplatz, Zahlung mit Kreditkarte, Klimaanlage, Zugänglich für Menschen mit Behinderungen, Besondere Anlässe, Firmenfeiern, Private Feiern

Sitze:96

Preis Kategorie:

Art der Küche:Bulgarische, Internationale

Clubs in der Naehe

Hotels in der Nähe

Siehe Karte

Gesehen: 102546

Galleries (3)

Restaurant MERCURE (7)

Great Food ! (1)

Information

Willkommen im Restaurant MERCURE Sofia mit Adresse бул. България 83. Das Restaurant hat eine Kapazität von 96 Sitze und ist eines der Restaurants in Sofia, das die folgenden Arten von Küchen anbietet : Bulgarische, Internationale, und die folgenden Dienstleistungen und Extras: Wi Fi, Parkplatz, Zahlung mit Kreditkarte, Klimaanlage, Zugänglich für Menschen mit Behinderungen.

Das Restaurant eignet sich hervorragend für die Organisation von Sonderveranstaltungen wie z.B.: besondere Anlässe - Geburtstagsfeiern, Hochzeiten und Kinderpartys oder Kindergeburtstage, Firmenfeiern, private Partys usw.

Telefonnummer für Kontakte und Reservierungen unter Restaurant MERCURE Sofia: +359 2 818 96 18.

Wine list

Laden Sie die Weinkarte hier: Wine list

Video (0)

Kommentare

History
+
Request History
4 previous requests available
====
Session
+
Session
- Config
  userAgent388974426ec470e5a836a102366c10b0
  time1792078831
  countdown10
  languagedeu
====
Request
+
Request

Cake Params
- plugin(null)
- controllerentities
- actionview
- named(empty)
- pass
  04651
- languagedeu
- slugsofia-restaurants-restoranti-sofia-restaurant-mercure-at-hotel-mercure-sofia-city-restorant-mercure-hotel-merkiur-sofia-siti
- id4651
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

Cookie
- languagerom
Current Route
- keys
  0language
  1slug
  2id
- options
  id[0-9]+
  slug[a-zA-Z-\.а-яА-Я0-9]*
  languagebul|eng|rus|rom|deu
  pass
  0id
- defaults
  controllerentities
  actionview
  plugin(null)
- template/:language/restoranti/:slug-:id
====

Sqllog

Sql Logs

default

Total Time: 143 ms
Total Queries: 356 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT `Entity`.`id`, (`I18n__name`.`content`) AS `Entity__i18n_name` FROM `rest4rfa_restaurantnew`.`entities` AS `Entity` INNER JOIN `rest4rfa_restaurantnew`.`i18n` AS `I18n__name` ON (`Entity`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Entity' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'deu') WHERE 1 = 1	2109	2109	32
SELECT `Entity`.`id`, `Entity`.`name`, `Entity`.`category`, `Entity`.`slug`, `Entity`.`rab_vreme`, `Entity`.`active`, `Entity`.`accommodation_type`, `Entity`.`type`, `Entity`.`address`, `Entity`.`city_id`, `Entity`.`latitude`, `Entity`.`longitude`, `Entity`.`phone`, `Entity`.`phone_manager`, `Entity`.`skype`, `Entity`.`website`, `Entity`.`fb`, `Entity`.`email`, `Entity`.`unit_price`, `Entity`.`services`, `Entity`.`beds`, `Entity`.`info`, `Entity`.`price_list`, `Entity`.`visits`, `Entity`.`header_img`, `Entity`.`thumb_img`, `Entity`.`vip`, `Entity`.`vip_position`, `Entity`.`vip_title`, `Entity`.`vip_text`, `Entity`.`vip_img`, `Entity`.`top`, `Entity`.`top_position`, `Entity`.`top_text`, `Entity`.`created`, `Entity`.`modified`, `Entity`.`user_id`, `Entity`.`subscription_level`, `Entity`.`tick_base`, `Entity`.`tick_step`, `Entity`.`tick_interval`, `Entity`.`active_promotion_count`, `Entity`.`gallery_count`, `Entity`.`video_count`, `Entity`.`_category`, `Entity`.`restaurant_menu`, `Entity`.`restaurant_winelist`, `Entity`.`page_title`, `Entity`.`meta_description`, `Entity`.`reservations`, `Entity`.`enable_comments`, `Entity`.`website_eng`, `Entity`.`website_deu`, `Entity`.`website_rus`, `Entity`.`website_rom`, `Entity`.`tripadvisor`, `Entity`.`foursquare`, `Entity`.`delivery1`, `Entity`.`delivery2`, `Entity`.`delivery3`, `Entity`.`delivery4`, `Entity`.`delivery5`, `Entity`.`delivery1_name`, `Entity`.`delivery2_name`, `Entity`.`delivery3_name`, `Entity`.`delivery4_name`, `Entity`.`delivery5_name`, `Entity`.`reservation_link`, `Entity`.`reservation_link_eng`, `Entity`.`reservation_link_deu`, `Entity`.`reservation_link_rus`, `Entity`.`reservation_link_rom`, (IFNULL((SELECT SUM( LEAST( `TickTask`.`ticks` + CEIL(TIMESTAMPDIFF(SECOND, LEAST(GREATEST(`TickTask`.`from_date`, `TickTask`.`modified`), IFNULL(`TickTask`.`to_date`, NOW())), GREATEST(LEAST(IFNULL(`TickTask`.`to_date`, NOW()), NOW()), `TickTask`.`from_date`)) * `TickTask`.`step` / 60 / `TickTask`.`interval`), IFNULL(`TickTask`.`max_ticks`, 1000000001) )) FROM `rest4rfa_restaurantnew`.`tick_tasks` AS TickTask WHERE `TickTask`.`entity_id` = `Entity`.`id` GROUP BY `TickTask`.`entity_id` ), 0) + IFNULL(`Entity`.`visits`, 0)) AS `Entity__hits`, (`I18n__nameTranslation`.`content`) AS `Entity__i18n_nameTranslation`, (`I18n__addressTranslation`.`content`) AS `Entity__i18n_addressTranslation`, (`I18n__infoTranslation`.`content`) AS `Entity__i18n_infoTranslation`, (`I18n__price_listTranslation`.`content`) AS `Entity__i18n_price_listTranslation`, (`I18n__vip_titleTranslation`.`content`) AS `Entity__i18n_vip_titleTranslation`, (`I18n__vip_textTranslation`.`content`) AS `Entity__i18n_vip_textTranslation`, (`I18n__top_textTranslation`.`content`) AS `Entity__i18n_top_textTranslation`, (`I18n__page_titleTranslation`.`content`) AS `Entity__i18n_page_titleTranslation`, (`I18n__meta_descriptionTranslation`.`content`) AS `Entity__i18n_meta_descriptionTranslation`, `City`.`id`, `City`.`name`, `City`.`main`, `City`.`position`, `City`.`created`, `City`.`modified`, `City`.`user_id`, `City`.`slug`, `City`.`description_id`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`active`, `User`.`role`, `User`.`entity_id`, `User`.`created`, `User`.`modified`, `User`.`user_id` FROM `rest4rfa_restaurantnew`.`entities` AS `Entity` INNER JOIN `rest4rfa_restaurantnew`.`i18n` AS `I18n__nameTranslation` ON (`Entity`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Entity' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'deu') INNER JOIN `rest4rfa_restaurantnew`.`i18n` AS `I18n__addressTranslation` ON (`Entity`.`id` = `I18n__addressTranslation`.`foreign_key` AND `I18n__addressTranslation`.`model` = 'Entity' AND `I18n__addressTranslation`.`field` = 'address' AND `I18n__addressTranslation`.`locale` = 'deu') INNER JOIN `rest4rfa_restaurantnew`.`i18n` AS `I18n__infoTranslation` ON (`Entity`.`id` = `I18n__infoTranslation`.`foreign_key` AND `I18n__infoTranslation`.`model` = 'Entity' AND `I18n__infoTranslation`.`field` = 'info' AND `I18n__infoTranslation`.`locale` = 'deu') INNER JOIN `rest4rfa_restaurantnew`.`i18n` AS `I18n__price_listTranslation` ON (`Entity`.`id` = `I18n__price_listTranslation`.`foreign_key` AND `I18n__price_listTranslation`.`model` = 'Entity' AND `I18n__price_listTranslation`.`field` = 'price_list' AND `I18n__price_listTranslation`.`locale` = 'deu') INNER JOIN `rest4rfa_restaurantnew`.`i18n` AS `I18n__vip_titleTranslation` ON (`Entity`.`id` = `I18n__vip_titleTranslation`.`foreign_key` AND `I18n__vip_titleTranslation`.`model` = 'Entity' AND `I18n__vip_titleTranslation`.`field` = 'vip_title' AND `I18n__vip_titleTranslation`.`locale` = 'deu') INNER JOIN `rest4rfa_restaurantnew`.`i18n` AS `I18n__vip_textTranslation` ON (`Entity`.`id` = `I18n__vip_textTranslation`.`foreign_key` AND `I18n__vip_textTranslation`.`model` = 'Entity' AND `I18n__vip_textTranslation`.`field` = 'vip_text' AND `I18n__vip_textTranslation`.`locale` = 'deu') INNER JOIN `rest4rfa_restaurantnew`.`i18n` AS `I18n__top_textTranslation` ON (`Entity`.`id` = `I18n__top_textTranslation`.`foreign_key` AND `I18n__top_textTranslation`.`model` = 'Entity' AND `I18n__top_textTranslation`.`field` = 'top_text' AND `I18n__top_textTranslation`.`locale` = 'deu') INNER JOIN `rest4rfa_restaurantnew`.`i18n` AS `I18n__page_titleTranslation` ON (`Entity`.`id` = `I18n__page_titleTranslation`.`foreign_key` AND `I18n__page_titleTranslation`.`model` = 'Entity' AND `I18n__page_titleTranslation`.`field` = 'page_title' AND `I18n__page_titleTranslation`.`locale` = 'deu') INNER JOIN `rest4rfa_restaurantnew`.`i18n` AS `I18n__meta_descriptionTranslation` ON (`Entity`.`id` = `I18n__meta_descriptionTranslation`.`foreign_key` AND `I18n__meta_descriptionTranslation`.`model` = 'Entity' AND `I18n__meta_descriptionTranslation`.`field` = 'meta_description' AND `I18n__meta_descriptionTranslation`.`locale` = 'deu') LEFT JOIN `rest4rfa_restaurantnew`.`cities` AS `City` ON (`Entity`.`city_id` = `City`.`id`) LEFT JOIN `rest4rfa_restaurantnew`.`users` AS `User` ON (`User`.`entity_id` = `Entity`.`id`) WHERE `Entity`.`id` = 4651 LIMIT 1	1	1	8	maybe slow
SELECT `Gallery`.`id`, `Gallery`.`title`, `Gallery`.`entity_id`, `Gallery`.`image_url`, `Gallery`.`thumb_url`, `Gallery`.`created`, `Gallery`.`modified`, `Gallery`.`user_id`, `Gallery`.`image_count`, `Gallery`.`type`, `Gallery`.`active` FROM `rest4rfa_restaurantnew`.`galleries` AS `Gallery` WHERE `Gallery`.`entity_id` = (4651)	3	3	0
SELECT `Promotion`.`id`, `Promotion`.`entity_id`, `Promotion`.`active`, `Promotion`.`title`, `Promotion`.`image_url`, `Promotion`.`thumb_url`, `Promotion`.`summary`, `Promotion`.`body`, `Promotion`.`priority`, `Promotion`.`created`, `Promotion`.`modified`, `Promotion`.`user_id`, `Promotion`.`slug`, `Promotion`.`page_title`, `Promotion`.`meta_description`, (DATE(`Promotion`.`created`)) AS `Promotion__createdDate` FROM `rest4rfa_restaurantnew`.`promotions` AS `Promotion` WHERE `Promotion`.`active` = '1' AND `Promotion`.`entity_id` = (4651)	0	0	0
SELECT `Video`.`id`, `Video`.`entity_id`, `Video`.`video_url`, `Video`.`created`, `Video`.`modified`, `Video`.`user_id` FROM `rest4rfa_restaurantnew`.`videos` AS `Video` WHERE `Video`.`entity_id` = (4651)	0	0	0
SELECT `TickTask`.`id`, `TickTask`.`entity_id`, `TickTask`.`ticks`, `TickTask`.`step`, `TickTask`.`interval`, `TickTask`.`from_date`, `TickTask`.`to_date`, `TickTask`.`max_ticks`, `TickTask`.`modified`, (LEAST(GREATEST(`TickTask`.`from_date`, `TickTask`.`modified`), IFNULL(`TickTask`.`to_date`, NOW()))) AS `TickTask__from`, (GREATEST(LEAST(IFNULL(`TickTask`.`to_date`, NOW()), NOW()), `TickTask`.`from_date`)) AS `TickTask__to`, ( LEAST( `TickTask`.`ticks` + CEIL(TIMESTAMPDIFF(SECOND, LEAST(GREATEST(`TickTask`.`from_date`, `TickTask`.`modified`), IFNULL(`TickTask`.`to_date`, NOW())), GREATEST(LEAST(IFNULL(`TickTask`.`to_date`, NOW()), NOW()), `TickTask`.`from_date`)) * `TickTask`.`step` / 60 / `TickTask`.`interval`), IFNULL(`TickTask`.`max_ticks`, 1000000000) ) - `TickTask`.`ticks`) AS `TickTask__delta`, ( LEAST( `TickTask`.`ticks` + CEIL(TIMESTAMPDIFF(SECOND, LEAST(GREATEST(`TickTask`.`from_date`, `TickTask`.`modified`), IFNULL(`TickTask`.`to_date`, NOW())), GREATEST(LEAST(IFNULL(`TickTask`.`to_date`, NOW()), NOW()), `TickTask`.`from_date`)) * `TickTask`.`step` / 60 / `TickTask`.`interval`), IFNULL(`TickTask`.`max_ticks`, 1000000001) )) AS `TickTask__total` FROM `rest4rfa_restaurantnew`.`tick_tasks` AS `TickTask` WHERE `TickTask`.`entity_id` = (4651)	2	2	0
SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `rest4rfa_restaurantnew`.`i18n` AS `nameTranslation` WHERE `model` = 'Entity' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (4651)	5	5	0
SELECT `addressTranslation`.`id`, `addressTranslation`.`locale`, `addressTranslation`.`model`, `addressTranslation`.`foreign_key`, `addressTranslation`.`field`, `addressTranslation`.`content` FROM `rest4rfa_restaurantnew`.`i18n` AS `addressTranslation` WHERE `model` = 'Entity' AND `field` = 'address' AND `addressTranslation`.`foreign_key` = (4651)	5	5	0
SELECT `infoTranslation`.`id`, `infoTranslation`.`locale`, `infoTranslation`.`model`, `infoTranslation`.`foreign_key`, `infoTranslation`.`field`, `infoTranslation`.`content` FROM `rest4rfa_restaurantnew`.`i18n` AS `infoTranslation` WHERE `model` = 'Entity' AND `field` = 'info' AND `infoTranslation`.`foreign_key` = (4651)	5	5	0
SELECT `price_listTranslation`.`id`, `price_listTranslation`.`locale`, `price_listTranslation`.`model`, `price_listTranslation`.`foreign_key`, `price_listTranslation`.`field`, `price_listTranslation`.`content` FROM `rest4rfa_restaurantnew`.`i18n` AS `price_listTranslation` WHERE `model` = 'Entity' AND `field` = 'price_list' AND `price_listTranslation`.`foreign_key` = (4651)	5	5	0
SELECT `vip_titleTranslation`.`id`, `vip_titleTranslation`.`locale`, `vip_titleTranslation`.`model`, `vip_titleTranslation`.`foreign_key`, `vip_titleTranslation`.`field`, `vip_titleTranslation`.`content` FROM `rest4rfa_restaurantnew`.`i18n` AS `vip_titleTranslation` WHERE `model` = 'Entity' AND `field` = 'vip_title' AND `vip_titleTranslation`.`foreign_key` = (4651)	5	5	0
SELECT `vip_textTranslation`.`id`, `vip_textTranslation`.`locale`, `vip_textTranslation`.`model`, `vip_textTranslation`.`foreign_key`, `vip_textTranslation`.`field`, `vip_textTranslation`.`content` FROM `rest4rfa_restaurantnew`.`i18n` AS `vip_textTranslation` WHERE `model` = 'Entity' AND `field` = 'vip_text' AND `vip_textTranslation`.`foreign_key` = (4651)	5	5	0
SELECT `top_textTranslation`.`id`, `top_textTranslation`.`locale`, `top_textTranslation`.`model`, `top_textTranslation`.`foreign_key`, `top_textTranslation`.`field`, `top_textTranslation`.`content` FROM `rest4rfa_restaurantnew`.`i18n` AS `top_textTranslation` WHERE `model` = 'Entity' AND `field` = 'top_text' AND `top_textTranslation`.`foreign_key` = (4651)	5	5	0
SELECT `page_titleTranslation`.`id`, `page_titleTranslation`.`locale`, `page_titleTranslation`.`model`, `page_titleTranslation`.`foreign_key`, `page_titleTranslation`.`field`, `page_titleTranslation`.`content` FROM `rest4rfa_restaurantnew`.`i18n` AS `page_titleTranslation` WHERE `model` = 'Entity' AND `field` = 'page_title' AND `page_titleTranslation`.`foreign_key` = (4651)	5	5	0
SELECT `meta_descriptionTranslation`.`id`, `meta_descriptionTranslation`.`locale`, `meta_descriptionTranslation`.`model`, `meta_descriptionTranslation`.`foreign_key`, `meta_descriptionTranslation`.`field`, `meta_descriptionTranslation`.`content` FROM `rest4rfa_restaurantnew`.`i18n` AS `meta_descriptionTranslation` WHERE `model` = 'Entity' AND `field` = 'meta_description' AND `meta_descriptionTranslation`.`foreign_key` = (4651)	5	5	0
SELECT `Region`.`id`, `Region`.`name`, `Region`.`position`, `Region`.`city_id`, `Region`.`user_id`, `Region`.`created`, `Region`.`modified`, `EntitiesRegion`.`id`, `EntitiesRegion`.`entity_id`, `EntitiesRegion`.`region_id`, `EntitiesRegion`.`created`, `EntitiesRegion`.`modified` FROM `rest4rfa_restaurantnew`.`regions` AS `Region` JOIN `rest4rfa_restaurantnew`.`entities_regions` AS `EntitiesRegion` ON (`EntitiesRegion`.`entity_id` = 4651 AND `EntitiesRegion`.`region_id` = `Region`.`id`)	1	1	0
SELECT `Setting`.`id`, `Setting`.`setting_name`, `Setting`.`description`, `Setting`.`category`, `Setting`.`setting`, `Setting`.`setting_value`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`user_id` FROM `rest4rfa_restaurantnew`.`settings` AS `Setting` WHERE 1 = 1	4	4	0
SELECT `Menu`.`id`, `Menu`.`menu_type`, `Menu`.`parent_id`, `Menu`.`title`, `Menu`.`url`, `Menu`.`controller`, `Menu`.`item_action`, `Menu`.`item_id`, `Menu`.`item_position`, `Menu`.`created`, `Menu`.`modified`, `Menu`.`user_id`, (`I18n__titleTranslation`.`content`) AS `Menu__i18n_titleTranslation` FROM `rest4rfa_restaurantnew`.`menus` AS `Menu` INNER JOIN `rest4rfa_restaurantnew`.`i18n` AS `I18n__titleTranslation` ON (`Menu`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Menu' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'deu') WHERE `Menu`.`menu_type` = 'main' ORDER BY `Menu`.`item_position` ASC	11	11	0
SELECT `titleTranslation`.`id`, `titleTranslation`.`locale`, `titleTranslation`.`model`, `titleTranslation`.`foreign_key`, `titleTranslation`.`field`, `titleTranslation`.`content` FROM `rest4rfa_restaurantnew`.`i18n` AS `titleTranslation` WHERE `model` = 'Menu' AND `field` = 'title' AND `titleTranslation`.`foreign_key` IN (1, 9, 2, 10, 11, 4, 12, 5, 6, 7, 8)	55	55	0
SELECT `Setting`.`id`, `Setting`.`setting_name`, `Setting`.`description`, `Setting`.`category`, `Setting`.`setting`, `Setting`.`setting_value`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`user_id` FROM `rest4rfa_restaurantnew`.`settings` AS `Setting` WHERE 1 = 1	4	4	0
SELECT `AccommodationType`.`id`, (`I18n__name`.`content`) AS `AccommodationType__i18n_name` FROM `rest4rfa_restaurantnew`.`accommodation_types` AS `AccommodationType` INNER JOIN `rest4rfa_restaurantnew`.`i18n` AS `I18n__name` ON (`AccommodationType`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'AccommodationType' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'deu') WHERE 1 = 1 ORDER BY `AccommodationType`.`name` ASC	56	56	0
SELECT `Type`.`id`, (`I18n__name`.`content`) AS `Type__i18n_name` FROM `rest4rfa_restaurantnew`.`types` AS `Type` INNER JOIN `rest4rfa_restaurantnew`.`i18n` AS `I18n__name` ON (`Type`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Type' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'deu') WHERE 1 = 1	0	0	0
SELECT `City`.`id`, (`I18n__name`.`content`) AS `City__i18n_name` FROM `rest4rfa_restaurantnew`.`cities` AS `City` INNER JOIN `rest4rfa_restaurantnew`.`i18n` AS `I18n__name` ON (`City`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'City' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'deu') WHERE 1 = 1 ORDER BY `City`.`position` DESC, `City`.`name` ASC	296	296	0
SELECT `Entity`.`id`, (`I18n__name`.`content`) AS `Entity__i18n_name` FROM `rest4rfa_restaurantnew`.`entities` AS `Entity` INNER JOIN `rest4rfa_restaurantnew`.`i18n` AS `I18n__name` ON (`Entity`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Entity' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'deu') WHERE `Entity`.`subscription_level` != 0 AND `Entity`.`active` = '1' ORDER BY `Entity`.`vip` DESC, `Entity`.`top` DESC, `Entity`.`name` ASC	546	546	40	maybe slow
SELECT `Region`.`id`, (`I18n__name`.`content`) AS `Region__i18n_name` FROM `rest4rfa_restaurantnew`.`regions` AS `Region` INNER JOIN `rest4rfa_restaurantnew`.`i18n` AS `I18n__name` ON (`Region`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Region' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'deu') WHERE 1 = 1 ORDER BY `Region`.`position` ASC, `Region`.`name` ASC	193	193	0
SELECT `Setting`.`id`, `Setting`.`setting_name`, `Setting`.`description`, `Setting`.`category`, `Setting`.`setting`, `Setting`.`setting_value`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`user_id` FROM `rest4rfa_restaurantnew`.`settings` AS `Setting` WHERE 1 = 1	4	4	0
SELECT `Service`.`id`, (`I18n__name`.`content`) AS `Service__i18n_name` FROM `rest4rfa_restaurantnew`.`services` AS `Service` INNER JOIN `rest4rfa_restaurantnew`.`i18n` AS `I18n__name` ON (`Service`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Service' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'deu') WHERE `Service`.`id` IN (2, 7, 3, 5, 9)	5	5	0
SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `rest4rfa_restaurantnew`.`i18n` AS `nameTranslation` WHERE `model` = 'Service' AND `field` = 'name' AND `nameTranslation`.`foreign_key` IN (2, 3, 5, 7, 9)	25	25	0
SELECT `Setting`.`id`, `Setting`.`setting_name`, `Setting`.`description`, `Setting`.`category`, `Setting`.`setting`, `Setting`.`setting_value`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`user_id` FROM `rest4rfa_restaurantnew`.`settings` AS `Setting` WHERE 1 = 1	4	4	0
SELECT `City`.`id`, `City`.`name`, `City`.`main`, `City`.`position`, `City`.`created`, `City`.`modified`, `City`.`user_id`, `City`.`slug`, `City`.`description_id`, (`I18n__name`.`content`) AS `City__i18n_name`, `Description`.`id`, `Description`.`text`, `Description`.`type`, `Description`.`created`, `Description`.`modified` FROM `rest4rfa_restaurantnew`.`cities` AS `City` INNER JOIN `rest4rfa_restaurantnew`.`i18n` AS `I18n__name` ON (`City`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'City' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'deu') LEFT JOIN `rest4rfa_restaurantnew`.`descriptions` AS `Description` ON (`City`.`description_id` = `Description`.`id`) WHERE `City`.`main` = '1' ORDER BY `City`.`id` ASC	15	15	0
SELECT `Region`.`id`, `Region`.`name`, `Region`.`position`, `Region`.`city_id`, `Region`.`user_id`, `Region`.`created`, `Region`.`modified` FROM `rest4rfa_restaurantnew`.`regions` AS `Region` WHERE `Region`.`city_id` IN (1, 2, 3, 4, 6, 12, 23, 37, 106, 163, 177, 211, 224, 227)	0	0	1	maybe slow
SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `rest4rfa_restaurantnew`.`i18n` AS `nameTranslation` WHERE `model` = 'City' AND `field` = 'name' AND `nameTranslation`.`foreign_key` IN (1, 2, 3, 4, 6, 12, 23, 37, 106, 163, 177, 211, 224, 227)	70	70	0
SELECT `Setting`.`id`, `Setting`.`setting_name`, `Setting`.`description`, `Setting`.`category`, `Setting`.`setting`, `Setting`.`setting_value`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`user_id` FROM `rest4rfa_restaurantnew`.`settings` AS `Setting` WHERE 1 = 1	4	4	0
SELECT `Menu`.`id`, `Menu`.`menu_type`, `Menu`.`parent_id`, `Menu`.`title`, `Menu`.`url`, `Menu`.`controller`, `Menu`.`item_action`, `Menu`.`item_id`, `Menu`.`item_position`, `Menu`.`created`, `Menu`.`modified`, `Menu`.`user_id`, (`I18n__titleTranslation`.`content`) AS `Menu__i18n_titleTranslation` FROM `rest4rfa_restaurantnew`.`menus` AS `Menu` INNER JOIN `rest4rfa_restaurantnew`.`i18n` AS `I18n__titleTranslation` ON (`Menu`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Menu' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'deu') WHERE `Menu`.`menu_type` = 'footer' ORDER BY `Menu`.`item_position` ASC	8	8	0
SELECT `titleTranslation`.`id`, `titleTranslation`.`locale`, `titleTranslation`.`model`, `titleTranslation`.`foreign_key`, `titleTranslation`.`field`, `titleTranslation`.`content` FROM `rest4rfa_restaurantnew`.`i18n` AS `titleTranslation` WHERE `model` = 'Menu' AND `field` = 'title' AND `titleTranslation`.`foreign_key` IN (13, 14, 15, 16, 17, 18, 19, 20)	40	40	0

Query Explain:

Click an "Explain" link above, to see the query explanation.

====

Timer

Memory

Peak Memory Use 15.73 MB

Message	Memory use
Component initialization	1.67 MB
Controller action start	2.90 MB
Controller render start	4.38 MB
Component initialization #2	4.95 MB
Controller action start #2	4.98 MB
Controller render start #2	6.30 MB
Component initialization #3	6.69 MB
Controller action start #3	6.78 MB
Component initialization #4	7.04 MB
Controller action start #4	7.08 MB
Component initialization #5	7.62 MB
Controller action start #5	7.66 MB
Component initialization #6	7.70 MB
Controller action start #6	7.73 MB
Component initialization #7	7.91 MB
Controller action start #7	7.94 MB
View render complete	7.94 MB

Timers

Total Request Time: 600 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	8.51
Event: Controller.initialize	5.00
Event: Controller.startup	1.07
Controller action	97.99
Event: Controller.beforeRender	36.80
» Processing toolbar data	36.52
Rendering View	311.22
» Event: View.beforeRender	0.06
» Rendering APP/View/Entities/view.ctp	206.00
» » Rendering APP/View/Elements/Reservations/add_short.ctp	198.74
» » » Event: Controller.initialize #2	0.13
» » » Event: Controller.startup #2	0.42
» » » Controller action #2	160.04
» » » Event: Controller.beforeRender #2	30.06
» » » » Processing toolbar data #2	29.73
Rendering View #2	0.00
» » » » Event: View.beforeRender #2	0.06
» » » Rendering APP/View/Reservations/add_short.ctp #2	5.06
» » » » » Rendering APP/View/Elements/errors.ctp	0.34
» » » » Event: View.afterRender	0.04
» » » » Event: Controller.shutdown	0.06
» » Event: View.afterRender #2	0.05
» » Event: View.beforeLayout	0.04
» » Rendering APP/View/Layouts/default.ctp	104.22
» » » Rendering APP/View/Elements/ad.ctp	0.21
» » » Rendering APP/View/Elements/ad.ctp #2	0.20
» » » Rendering APP/View/Elements/Menus/list_by_type.ctp	95.73
» » » » Event: Controller.initialize #3	1.51
» » » » Event: Controller.startup #3	0.80
Controller action #3	0.00
» » » » » Event: Controller.shutdown #2	0.04
» » » » » Rendering APP/View/Elements/Entities/search.ctp	78.35
» » » » » » Event: Controller.initialize #4	0.56
» » » » » » Event: Controller.startup #4	0.50
Controller action #4	0.00
» » » » » » » Event: Controller.shutdown #3	0.06
» » » » » » » Rendering APP/View/Elements/Entities/services.ctp	4.72
» » » » » » » » Event: Controller.initialize #5	0.52
» » » » » » » » Event: Controller.startup #5	0.43
Controller action #5	0.00
» » » » » » » » » Event: Controller.shutdown #4	0.03
» » » » » » » Rendering APP/View/Elements/Cities/short_list.ctp	6.76
» » » » » » » » Event: Controller.initialize #6	0.55
» » » » » » » » Event: Controller.startup #6	0.41
Controller action #6	0.00
» » » » » » » » » Event: Controller.shutdown #5	0.04
» » » » » » » Rendering APP/View/Elements/Menus/list_by_type.ctp #2	5.78
» » » » » » » » Event: Controller.initialize #7	0.66
» » » » » » » » Event: Controller.startup #7	0.53
Controller action #7	0.00
» » » » » » » » » Event: Controller.shutdown #6	0.04
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- metaDescriptionWillkommen im Restaurant MERCURE Sofia Hotel MERCURE Sofia City - Kontaktdaten, Menü, Preise, Galerie mit Bildern und Promotionen. Suche nach einem anderen Restaurant, Pub, Pizza, Bistro oder Bar & Dinner Ort in Sofia.
- winelists(empty)
- menus(empty)
- galleries
 1
 0
 Image
 id50851
 parent_id6630
 parent_modelGallery
 image_url/img/entities/4651/1769674441_1200_2 int.jpg
 thumb_url/img/entities/4651/thumbnails/1769674441_thumbnail_2 int.jpg
 created2026-01-29 10:14:02
 modified2026-01-29 10:14:02
 user_id(null)
 Gallery
 id6630
 titleRestaurant MERCURE
 entity_id4651
 image_url/img/entities/4651/1769674419_1200_o int.jpg
 thumb_url/img/entities/4651/thumbnails/1769674419_thumbnail_o int.jpg
 created2026-01-29
 modified2026-01-29 10:13:40
 user_id(null)
 image_count6
 type(null)
 active1
 ImageCaption
 id(null)
 caption(null)
 created(null)
 modified(null)
 user_id(null)
 image_id(null)
 1
 Image
 id50852
 parent_id6630
 parent_modelGallery
 image_url/img/entities/4651/1769674450_1200_3 int.jpg
 thumb_url/img/entities/4651/thumbnails/1769674451_thumbnail_3 int.jpg
 created2026-01-29 10:14:11
 modified2026-01-29 10:14:11
 user_id(null)
 Gallery
 id6630
 titleRestaurant MERCURE
 entity_id4651
 image_url/img/entities/4651/1769674419_1200_o int.jpg
 thumb_url/img/entities/4651/thumbnails/1769674419_thumbnail_o int.jpg
 created2026-01-29
 modified2026-01-29 10:13:40
 user_id(null)
 image_count6
 type(null)
 active1
 ImageCaption
 id(null)
 caption(null)
 created(null)
 modified(null)
 user_id(null)
 image_id(null)
 2
 Image
 id50853
 parent_id6630
 parent_modelGallery
 image_url/img/entities/4651/1769674458_1200_4 int.jpg
 thumb_url/img/entities/4651/thumbnails/1769674459_thumbnail_4 int.jpg
 created2026-01-29 10:14:19
 modified2026-01-29 10:14:19
 user_id(null)
 Gallery
 id6630
 titleRestaurant MERCURE
 entity_id4651
 image_url/img/entities/4651/1769674419_1200_o int.jpg
 thumb_url/img/entities/4651/thumbnails/1769674419_thumbnail_o int.jpg
 created2026-01-29
 modified2026-01-29 10:13:40
 user_id(null)
 image_count6
 type(null)
 active1
 ImageCaption
 id(null)
 caption(null)
 created(null)
 modified(null)
 user_id(null)
 image_id(null)
 3
 Image
 id50854
 parent_id6630
 parent_modelGallery
 image_url/img/entities/4651/1769674467_1200_5 int.jpg
 thumb_url/img/entities/4651/thumbnails/1769674468_thumbnail_5 int.jpg
 created2026-01-29 10:14:28
 modified2026-01-29 10:14:28
 user_id(null)
 Gallery
 id6630
 titleRestaurant MERCURE
 entity_id4651
 image_url/img/entities/4651/1769674419_1200_o int.jpg
 thumb_url/img/entities/4651/thumbnails/1769674419_thumbnail_o int.jpg
 created2026-01-29
 modified2026-01-29 10:13:40
 user_id(null)
 image_count6
 type(null)
 active1
 ImageCaption
 id(null)
 caption(null)
 created(null)
 modified(null)
 user_id(null)
 image_id(null)
 4
 Image
 id50855
 parent_id6630
 parent_modelGallery
 image_url/img/entities/4651/1769674476_1200_6 int.jpg
 thumb_url/img/entities/4651/thumbnails/1769674476_thumbnail_6 int.jpg
 created2026-01-29 10:14:37
 modified2026-01-29 10:14:37
 user_id(null)
 Gallery
 id6630
 titleRestaurant MERCURE
 entity_id4651
 image_url/img/entities/4651/1769674419_1200_o int.jpg
 thumb_url/img/entities/4651/thumbnails/1769674419_thumbnail_o int.jpg
 created2026-01-29
 modified2026-01-29 10:13:40
 user_id(null)
 image_count6
 type(null)
 active1
 ImageCaption
 id(null)
 caption(null)
 created(null)
 modified(null)
 user_id(null)
 image_id(null)
 5
 Image
 id50856
 parent_id6630
 parent_modelGallery
 image_url/img/entities/4651/1769674484_1200_7 int.jpg
 thumb_url/img/entities/4651/thumbnails/1769674484_thumbnail_7 int.jpg
 created2026-01-29 10:14:45
 modified2026-01-29 10:14:45
 user_id(null)
 Gallery
 id6630
 titleRestaurant MERCURE
 entity_id4651
 image_url/img/entities/4651/1769674419_1200_o int.jpg
 thumb_url/img/entities/4651/thumbnails/1769674419_thumbnail_o int.jpg
 created2026-01-29
 modified2026-01-29 10:13:40
 user_id(null)
 image_count6
 type(null)
 active1
 ImageCaption
 id(null)
 caption(null)
 created(null)
 modified(null)
 user_id(null)
 image_id(null)
 2(empty)
- accommodation_types
 0
 AccommodationType
 id13
 nameBulgarische
 created0000-00-00 00:00:00
 modified2013-07-30 21:26:15
 user_id1
 slugMehana-Bylgarska-kuhnya
 description_id(null)
 localedeu
 Description
 id(null)
 text(null)
 type(null)
 created(null)
 modified(null)
 nameTranslation
 0
 id1488
 localebul
 modelAccommodationType
 foreign_key13
 fieldname
 contentБългарска
 1
 id1594
 localedeu
 modelAccommodationType
 foreign_key13
 fieldname
 contentBulgarische
 2
 id1541
 localeeng
 modelAccommodationType
 foreign_key13
 fieldname
 contentBulgarian
 3
 id1700
 localerom
 modelAccommodationType
 foreign_key13
 fieldname
 contentNațională a Bulgariei
 4
 id1647
 localerus
 modelAccommodationType
 foreign_key13
 fieldname
 contentБолгарская
 1
 AccommodationType
 id32
 nameInternationale
 created0000-00-00 00:00:00
 modified2013-07-30 21:54:11
 user_id1
 slugInternacionalen-Internacionalna-kuhnya
 description_id(null)
 localedeu
 Description
 id(null)
 text(null)
 type(null)
 created(null)
 modified(null)
 nameTranslation
 0
 id1507
 localebul
 modelAccommodationType
 foreign_key32
 fieldname
 contentМеждународна
 1
 id1613
 localedeu
 modelAccommodationType
 foreign_key32
 fieldname
 contentInternationale
 2
 id1560
 localeeng
 modelAccommodationType
 foreign_key32
 fieldname
 contentInternational
 3
 id1719
 localerom
 modelAccommodationType
 foreign_key32
 fieldname
 contentInternational
 4
 id1666
 localerus
 modelAccommodationType
 foreign_key32
 fieldname
 contentИнтернациональная
- promotions(empty)
- services
 0
 Service
 id1
 nameWi Fi
 created0000-00-00 00:00:00
 modified0000-00-00 00:00:00
 user_id1
 slugWiFi
 localedeu
 nameTranslation
 0
 id1741
 localebul
 modelService
 foreign_key1
 fieldname
 contentWi Fi
 1
 id1787
 localedeu
 modelService
 foreign_key1
 fieldname
 contentWi Fi
 2
 id1764
 localeeng
 modelService
 foreign_key1
 fieldname
 contentWi Fi
 3
 id1833
 localerom
 modelService
 foreign_key1
 fieldname
 contentWi Fi
 4
 id1810
 localerus
 modelService
 foreign_key1
 fieldname
 contentWi Fi
 1
 Service
 id2
 nameParkplatz
 created0000-00-00 00:00:00
 modified0000-00-00 00:00:00
 user_id1
 slugParking
 localedeu
 nameTranslation
 0
 id1742
 localebul
 modelService
 foreign_key2
 fieldname
 contentПаркинг
 1
 id1788
 localedeu
 modelService
 foreign_key2
 fieldname
 contentParkplatz
 2
 id1765
 localeeng
 modelService
 foreign_key2
 fieldname
 contentParking
 3
 id1834
 localerom
 modelService
 foreign_key2
 fieldname
 contentParcare
 4
 id1811
 localerus
 modelService
 foreign_key2
 fieldname
 contentПарковка
 2
 Service
 id3
 nameZahlung mit Kreditkarte
 created0000-00-00 00:00:00
 modified0000-00-00 00:00:00
 user_id1
 slugBezkasovo-Plashtane
 localedeu
 nameTranslation
 0
 id1743
 localebul
 modelService
 foreign_key3
 fieldname
 contentБезкасово плащане
 1
 id1789
 localedeu
 modelService
 foreign_key3
 fieldname
 contentZahlung mit Kreditkarte
 2
 id1766
 localeeng
 modelService
 foreign_key3
 fieldname
 contentCard payment
 3
 id1835
 localerom
 modelService
 foreign_key3
 fieldname
 contentPlata Prin Card
 4
 id1812
 localerus
 modelService
 foreign_key3
 fieldname
 contentKарты Oплаты
 3
 Service
 id4
 nameKlimaanlage
 created0000-00-00 00:00:00
 modified0000-00-00 00:00:00
 user_id1
 slugKlimatik
 localedeu
 nameTranslation
 0
 id1744
 localebul
 modelService
 foreign_key4
 fieldname
 contentКлиматик
 1
 id1790
 localedeu
 modelService
 foreign_key4
 fieldname
 contentKlimaanlage
 2
 id1767
 localeeng
 modelService
 foreign_key4
 fieldname
 contentAir Conditioning
 3
 id1836
 localerom
 modelService
 foreign_key4
 fieldname
 contentAer Condiționat
 4
 id1813
 localerus
 modelService
 foreign_key4
 fieldname
 contentKондиционер
 4
 Service
 id8
 nameZugänglich für Menschen mit Behinderungen
 created0000-00-00 00:00:00
 modified0000-00-00 00:00:00
 user_id1
 slugDostap-za-hora-s-uvrejdania
 localedeu
 nameTranslation
 0
 id1748
 localebul
 modelService
 foreign_key8
 fieldname
 contentДостъп за хора с увреждания
 1
 id1794
 localedeu
 modelService
 foreign_key8
 fieldname
 contentZugänglich für Menschen mit Behinderungen
 2
 id1771
 localeeng
 modelService
 foreign_key8
 fieldname
 contentAccessible for people with disabilities
 3
 id1840
 localerom
 modelService
 foreign_key8
 fieldname
 contentAccesibil pentru Persoanele cu Handicap
 4
 id1817
 localerus
 modelService
 foreign_key8
 fieldname
 contentДоступными для людей с ограниченными возможностями
 5
 Service
 id18
 nameBesondere Anlässe
 created0000-00-00 00:00:00
 modified2014-04-05 15:10:45
 user_id1
 slugSvatbi-Kryshtene-Rojdeni-dni
 localedeu
 nameTranslation
 0
 id1758
 localebul
 modelService
 foreign_key18
 fieldname
 contentСпециални събития - сватби, кръщенета, рождени дни
 1
 id1804
 localedeu
 modelService
 foreign_key18
 fieldname
 contentBesondere Anlässe
 2
 id1781
 localeeng
 modelService
 foreign_key18
 fieldname
 contentSpecial occasions - birthday party, wedding, etc.
 3
 id1850
 localerom
 modelService
 foreign_key18
 fieldname
 contentOcazii Speciale
 4
 id1827
 localerus
 modelService
 foreign_key18
 fieldname
 contentДля особых поводов
 6
 Service
 id20
 nameFirmenfeiern
 created0000-00-00 00:00:00
 modified0000-00-00 00:00:00
 user_id1
 slugFirmeno-parti
 localedeu
 nameTranslation
 0
 id1760
 localebul
 modelService
 foreign_key20
 fieldname
 contentФирмени партита
 1
 id1806
 localedeu
 modelService
 foreign_key20
 fieldname
 contentFirmenfeiern
 2
 id1783
 localeeng
 modelService
 foreign_key20
 fieldname
 contentCompany parties
 3
 id1852
 localerom
 modelService
 foreign_key20
 fieldname
 contentPetreceri de Firma
 4
 id1829
 localerus
 modelService
 foreign_key20
 fieldname
 contentФирменные вечеринки
 7
 Service
 id21
 namePrivate Feiern
 created0000-00-00 00:00:00
 modified0000-00-00 00:00:00
 user_id1
 slugChastno-parti
 localedeu
 nameTranslation
 0
 id1761
 localebul
 modelService
 foreign_key21
 fieldname
 contentЧастни партита
 1
 id1807
 localedeu
 modelService
 foreign_key21
 fieldname
 contentPrivate Feiern
 2
 id1784
 localeeng
 modelService
 foreign_key21
 fieldname
 contentPrivate parties
 3
 id1853
 localerom
 modelService
 foreign_key21
 fieldname
 contentPetreceri Private
 4
 id1830
 localerus
 modelService
 foreign_key21
 fieldname
 contentЧастные вечеринки
- ref/
- entity
 Entity
 id4651
 nameRestaurant MERCURE Sofia
 category4
 slugsofia-restaurants-restoranti-sofia-restaurant-mercure-at-hotel-mercure-sofia-city-restorant-mercure-hotel-merkiur-sofia-siti
 rab_vreme(null)
 active1
 accommodation_typeБългарска;Международна
 type(null)
 addressбул. България 83
 city_id0
 latitude42.66
 longitude23.2864
 phone+359 2 818 96 18
 phone_manager+359 2 818 96 18
 skype
 websitehttps://festahotels.com/bg/hotel-mercure-sofia-city/zavedeniya/restorant-mercure
 fbhttps://www.facebook.com/festahotels/
 email[email protected]
 unit_price3
 servicesWi Fi; Паркинг; Безкасово плащане; Климатик; Достъп за хора с увреждания; Специални събития - сватби, кръщенета, рождени дни; Фирмени партита; Частни партита
 beds96
 info
 price_list
 visits9358
 header_img/img/entities/4651/1769673862_1200_1-84_Mercure Sofia City Restaurant 2.jpg
 thumb_img/img/entities/4651/1769673870_800_1-84_Mercure Sofia City Restaurant 2.jpg
 vip0
 vip_position100
 vip_title
 vip_text
 vip_img(null)
 top0
 top_position100
 top_text
 created2014-02-04 10:27:03
 modified2026-01-29 10:29:09
 user_id0
 subscription_level2
 tick_base0
 tick_step(null)
 tick_interval(null)
 active_promotion_count0
 gallery_count3
 video_count0
 _category(null)
 restaurant_menu(null)
 restaurant_winelist/img/entities/4651/attachments/1-wine list mercure sofia.pdf
 page_titleRestaurant MERCURE Sofia
 meta_descriptionWillkommen im Restaurant MERCURE Sofia Hotel MERCURE Sofia City - Kontaktdaten, Menü, Preise, Galerie mit Bildern und Promotionen. Suche nach einem anderen Restaurant, Pub, Pizza, Bistro oder Bar & Dinner Ort in Sofia.
 reservations1
 enable_comments1
 website_eng
 website_deu
 website_rus
 website_rom
 tripadvisor
 foursquare
 delivery1
 delivery2
 delivery3
 delivery4
 delivery5
 delivery1_name
 delivery2_name
 delivery3_name
 delivery4_name
 delivery5_name
 reservation_link
 reservation_link_eng
 reservation_link_deu
 reservation_link_rus
 reservation_link_rom
 hits102546
 localedeu
 City
 id0
 nameSofia
 main1
 position20
 created0000-00-00 00:00:00
 modified0000-00-00 00:00:00
 user_id1
 slugSofia
 description_id1
 User
 id(null)
 username(null)
 password(null)
 email(null)
 active(null)
 role(null)
 entity_id(null)
 created(null)
 modified(null)
 user_id(null)
 Gallery
 0
 id5780
 titleRestaurant FESTA Sofia
 entity_id4651
 image_url/img/entities/4651/1731577330_1200_4.1_Restaurant(1).jpg
 thumb_url/img/entities/4651/thumbnails/1731577330_thumbnail_4.1_Restaurant(1).jpg
 created2024-11-14
 modified2026-01-29 10:13:28
 user_id(null)
 image_count2
 type(null)
 active0
 1
 id6630
 titleRestaurant MERCURE
 entity_id4651
 image_url/img/entities/4651/1769674419_1200_o int.jpg
 thumb_url/img/entities/4651/thumbnails/1769674419_thumbnail_o int.jpg
 created2026-01-29
 modified2026-01-29 10:13:40
 user_id(null)
 image_count6
 type(null)
 active1
 2
 id6631
 titleGreat Food !
 entity_id4651
 image_url/img/entities/4651/1769674500_1200_1 f.jpg
 thumb_url/img/entities/4651/thumbnails/1769674501_thumbnail_1 f.jpg
 created2026-01-29
 modified2026-01-29 10:15:02
 user_id(null)
 image_count0
 type(null)
 active1
 Promotion(empty)
 Video(empty)
 TickTask
 0
 id1
 entity_id4651
 ticks0
 step1
 interval15
 from_date2014-02-04 13:04:00
 to_date2014-02-20 13:03:00
 max_ticks10000
 modified2014-02-04 13:04:37
 from2014-02-04 13:04:37
 to2014-02-20 13:03:00
 delta1536
 total1536
 1
 id681
 entity_id4651
 ticks0
 step1
 interval11
 from_date2024-11-14 11:58:00
 to_date(null)
 max_ticks150000
 modified2024-11-14 11:58:41
 from2024-11-14 11:58:41
 to2026-10-15 14:40:31
 delta91652
 total91652
 nameTranslation
 0
 id58694
 localebul
 modelEntity
 foreign_key4651
 fieldname
 contentRestaurant MERCURE Sofia Ресторант МЕРКЮР София
 1
 id58712
 localedeu
 modelEntity
 foreign_key4651
 fieldname
 contentRestaurant MERCURE Sofia
 2
 id58703
 localeeng
 modelEntity
 foreign_key4651
 fieldname
 contentRestaurant MERCURE Sofia
 3
 id58730
 localerom
 modelEntity
 foreign_key4651
 fieldname
 contentRestaurant MERCURE Sofia
 4
 id58721
 localerus
 modelEntity
 foreign_key4651
 fieldname
 contentRestaurant MERCURE Sofia
 addressTranslation
 0
 id58695
 localebul
 modelEntity
 foreign_key4651
 fieldaddress
 contentбул. България 83 A, хотел Меркюр София Сити, гр.София
 1
 id58713
 localedeu
 modelEntity
 foreign_key4651
 fieldaddress
 contentбул. България 83
 2
 id58704
 localeeng
 modelEntity
 foreign_key4651
 fieldaddress
 contentбул. България 83
 3
 id58731
 localerom
 modelEntity
 foreign_key4651
 fieldaddress
 contentбул. България 83
 4
 id58722
 localerus
 modelEntity
 foreign_key4651
 fieldaddress
 contentбул. България 83
 infoTranslation
 0
 id58696
 localebul
 modelEntity
 foreign_key4651
 fieldinfo
 contentPесторант MERCURE в Mercure Sofia City предлага селекция от местни и международни ястия, поднесени в стилна и уютна атмосфера. Вдъхновен от философията Discover Local, ресторантът комбинира автентични български вкусове с модерни кулинарни техники, създавайки баланс между традиция и иновация. Разположен на мецанин етажа, Pесторант MERCURE разполага с 96 седящи места, ВИП зала, самостоятелен бар и бюфет зона, осигурявайки перфектни условия за всякакви поводи – от спокойни закуски до елегантни вечери. Закуската в Pесторант MERCURE се сервира на блок маса и включва пресни сезонни продукти и регионални специалитети, сред които баница, качамак, кисело мляко с мед и домашна лютеница. През останалата част от деня, а-ла-карт менюто представя прецизно подбрани ястия, вдъхновени от българската и световната кухня. Внимателно селектираната винена листа на Pесторант MERCURE предлага първокласни български и международни вина, които допълват кулинарното преживяване с изискана хармония от вкусове. Независимо дали търсите спокойна закуска, бизнес обяд или романтична вечеря, Pесторант MERCURE на Mercure Sofia City предлага перфектната комбинация от стил, комфорт и безупречно обслужване. Работно време: 07:00 ч. – 23:00 ч.; 96 места; Зона за непушачи Климатик Достъп за инвалидни колички Препоръчва се резервация Плащане в брой Кредитна карта Информация за вино и други напитки Apéritif Коктейл Винотека Налично вино на чаша Безалкохолни напитки Дижестиви Настаняване на храна Детско меню
 1
 id58714
 localedeu
 modelEntity
 foreign_key4651
 fieldinfo
 content
 2
 id58705
 localeeng
 modelEntity
 foreign_key4651
 fieldinfo
 contentRestaurant “Festa” can be defined with discreet and exquisite atmosphere and can accommodate up to 120 people. Our other restaurant terrace – “Festa Garden” offers a spectacular view of the Vitosha Mountain. 
 3
 id58732
 localerom
 modelEntity
 foreign_key4651
 fieldinfo
 content
 4
 id58723
 localerus
 modelEntity
 foreign_key4651
 fieldinfo
 content
 price_listTranslation
 0
 id58697
 localebul
 modelEntity
 foreign_key4651
 fieldprice_list
 content
 1
 id58715
 localedeu
 modelEntity
 foreign_key4651
 fieldprice_list
 content
 2
 id58706
 localeeng
 modelEntity
 foreign_key4651
 fieldprice_list
 content
 3
 id58733
 localerom
 modelEntity
 foreign_key4651
 fieldprice_list
 content
 4
 id58724
 localerus
 modelEntity
 foreign_key4651
 fieldprice_list
 content
 vip_titleTranslation
 0
 id58698
 localebul
 modelEntity
 foreign_key4651
 fieldvip_title
 content
 1
 id58716
 localedeu
 modelEntity
 foreign_key4651
 fieldvip_title
 content
 2
 id58707
 localeeng
 modelEntity
 foreign_key4651
 fieldvip_title
 content
 3
 id58734
 localerom
 modelEntity
 foreign_key4651
 fieldvip_title
 content
 4
 id58725
 localerus
 modelEntity
 foreign_key4651
 fieldvip_title
 content
 vip_textTranslation
 0
 id58699
 localebul
 modelEntity
 foreign_key4651
 fieldvip_text
 content
 1
 id58717
 localedeu
 modelEntity
 foreign_key4651
 fieldvip_text
 content
 2
 id58708
 localeeng
 modelEntity
 foreign_key4651
 fieldvip_text
 content
 3
 id58735
 localerom
 modelEntity
 foreign_key4651
 fieldvip_text
 content
 4
 id58726
 localerus
 modelEntity
 foreign_key4651
 fieldvip_text
 content
 top_textTranslation
 0
 id58700
 localebul
 modelEntity
 foreign_key4651
 fieldtop_text
 content
 1
 id58718
 localedeu
 modelEntity
 foreign_key4651
 fieldtop_text
 content
 2
 id58709
 localeeng
 modelEntity
 foreign_key4651
 fieldtop_text
 content
 3
 id58736
 localerom
 modelEntity
 foreign_key4651
 fieldtop_text
 content
 4
 id58727
 localerus
 modelEntity
 foreign_key4651
 fieldtop_text
 content
 page_titleTranslation
 0
 id58701
 localebul
 modelEntity
 foreign_key4651
 fieldpage_title
 contentRestaurant MERCURE Hotel MERCURE Sofia City Ресторант МЕРКЮР Хотел МЕРКЮР София Сити
 1
 id58719
 localedeu
 modelEntity
 foreign_key4651
 fieldpage_title
 contentRestaurant MERCURE Sofia
 2
 id58710
 localeeng
 modelEntity
 foreign_key4651
 fieldpage_title
 contentRestaurant MERCURE Sofia
 3
 id58737
 localerom
 modelEntity
 foreign_key4651
 fieldpage_title
 contentRestaurant MERCURE Sofia
 4
 id58728
 localerus
 modelEntity
 foreign_key4651
 fieldpage_title
 contentRestaurant MERCURE Sofia
 meta_descriptionTranslation
 0
 id58702
 localebul
 modelEntity
 foreign_key4651
 fieldmeta_description
 contentRestaurant MERCURE Hotel MERCURE Sofia City Ресторант МЕРКЮР Хотел МЕРКЮР София Сити - контакти, снимки, цени, меню, мнения, промоции. Разгледайте и останалите ни предложения за ресторанти, заведения, барове, механи, кръчми, бирарии и пицарии в София.
 1
 id58720
 localedeu
 modelEntity
 foreign_key4651
 fieldmeta_description
 contentWillkommen im Restaurant MERCURE Sofia Hotel MERCURE Sofia City - Kontaktdaten, Menü, Preise, Galerie mit Bildern und Promotionen. Suche nach einem anderen Restaurant, Pub, Pizza, Bistro oder Bar & Dinner Ort in Sofia.
 2
 id58711
 localeeng
 modelEntity
 foreign_key4651
 fieldmeta_description
 contentRestaurant MERCURE Sofia - contact details, menu, prices, gallery with pictures and promotions. Search for another restaurant, pub, bar & dinner, pizza, beer place, club or tavern in Sofia.
 3
 id58738
 localerom
 modelEntity
 foreign_key4651
 fieldmeta_description
 contentBine ati venit la Restaurant MERCURE Sofia - Verifica detaliile de contact restaurant, meniu, preturile, galerie cu imagini și promoții. Alegeți un restaurant, bar, taverna, club, bar și cina, pizza sau loc de bere în catalogul în Sofia.
 4
 id58729
 localerus
 modelEntity
 foreign_key4651
 fieldmeta_description
 contentДобро пожаловать в Restaurant MERCURE Sofia - контактные данные, меню, цены, галерея с фотографиями и акциях. Поиск другой ресторан, паб, пиццерия, таверна, бистро или бар в София.
 Region
 0
 id67
 nameМанастирски ливади
 position67
 city_id0
 user_id1
 created0000-00-00 00:00:00
 modified0000-00-00 00:00:00
 EntitiesRegion
 id3563
 entity_id4651
 region_id67
 created0000-00-00 00:00:00
 modified0000-00-00 00:00:00
- $request->data(empty)
- $this->validationErrors
 Setting(empty)
 Entity(empty)
 I18nModel(empty)
 TickTask(empty)
 City(empty)
 User(empty)
 Gallery(empty)
 Promotion(empty)
 Video(empty)
 nameTranslation(empty)
 addressTranslation(empty)
 infoTranslation(empty)
 price_listTranslation(empty)
 vip_titleTranslation(empty)
 vip_textTranslation(empty)
 top_textTranslation(empty)
 page_titleTranslation(empty)
 meta_descriptionTranslation(empty)
 Region(empty)
 EntitiesRegion(empty)
 Service(empty)
 Image(empty)
 titleTranslation(empty)
 summaryTranslation(empty)
 bodyTranslation(empty)
 AccommodationType(empty)
 Description(empty)
 ImageCaption(empty)
- Loaded Helpers
 0Html
 1Form
 2Logger
 3Number
 4SimpleGraph
 5DebugTimer
 6Toolbar
 7Entity
 8Session
 9HtmlToolbar
====

Environment

App Constants

No application environment available.

CakePHP Constants

Constant	Value
APP	/home/rest4rfa/public_html/live/app/
APP_DIR	app
APPLIBS	/home/rest4rfa/public_html/live/app/Lib/
CACHE	/home/rest4rfa/public_html/live/app/tmp/cache/
CAKE	/home/rest4rfa/public_html/live/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/home/rest4rfa/public_html/live/lib
CORE_PATH	/home/rest4rfa/public_html/live/lib/
CAKE_VERSION	2.3.2
CSS	/home/rest4rfa/public_html/live/app/webroot/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	https://live.restaurant.bg
IMAGES	/home/rest4rfa/public_html/live/app/webroot/img/
IMAGES_URL	img/
JS	/home/rest4rfa/public_html/live/app/webroot/js/
JS_URL	js/
LOGS	/home/rest4rfa/public_html/live/app/tmp/logs/
ROOT	/home/rest4rfa/public_html/live
TESTS	/home/rest4rfa/public_html/live/app/Test/
TMP	/home/rest4rfa/public_html/live/app/tmp/
VENDORS	/home/rest4rfa/public_html/live/vendors/
WEBROOT_DIR	webroot
WWW_ROOT	/home/rest4rfa/public_html/live/app/webroot/

PHP Environment

Environment Variable	Value
Php Version	5.6.40
Tz	Europe/Sofia
Pwd	/home/rest4rfa
Shlvl	0
Path	/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin
Script Name	/app/webroot/index.php
Request Uri	/deu/restoranti/sofia-restaurants-restoranti-sofia-restaurant-mercure-at-hotel-mercure-sofia-city-restorant-mercure-hotel-merkiur-sofia-siti-4651
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/app/webroot/deu/restoranti/sofia-restaurants-restoranti-sofia-restaurant-mercure-at-hotel-mercure-sofia-city-restorant-mercure-hotel-merkiur-sofia-siti-4651
Remote Port	35666
Script Filename	/home/rest4rfa/public_html/live/app/webroot/index.php
Server Admin	[email protected]
Context Document Root	/home/rest4rfa/public_html/live
Context Prefix
Request Scheme	https
Document Root	/home/rest4rfa/public_html/live
Remote Addr	216.73.216.134
Server Port	443
Server Addr	195.191.148.105
Server Name	live.restaurant.bg
Server Software	Apache
Server Signature
Http Cookie	CAKEPHP=c5dfc08db759e34693910bc4cd3e2141; CakeCookie[language]=rom
Http Cf Visitor	{"scheme":"https"}
Http Cf Ipcountry	US
Http Cf Connecting Ip	216.73.216.134
Http Cdn Loop	cloudflare; loops=1
Http Cf Ray	a4ae8cab1d314af4-CMH
Http Accept	/
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])
Http Accept Encoding	gzip, br
Http Connection	close
Http X Sh L7 Proxied	1
Http X Forwarded Proto	https
Http X Forwarded For	216.73.216.134, 216.73.216.134
Http Host	live.restaurant.bg
Ssl Tls Sni	live.restaurant.bg
Https	on
Sh Company Origin	superhosting.bg
Unique Id	atC7rzERl-I63MTRb8kUtgAABIs
Redirect Status	200
Redirect Ssl Tls Sni	live.restaurant.bg
Redirect Https	on
Redirect Sh Company Origin	superhosting.bg
Redirect Unique Id	atC7rzERl-I63MTRb8kUtgAABIs
Redirect Redirect Status	200
Redirect Redirect Ssl Tls Sni	live.restaurant.bg
Redirect Redirect Https	on
Redirect Redirect Sh Company Origin	superhosting.bg
Redirect Redirect Unique Id	atC7rzERl-I63MTRb8kUtgAABIs
Fcgi Role	RESPONDER
Php Self	/app/webroot/index.php
Request Time Float	1792064431.94
Request Time	1792064431
Argc	0

====

Include
+
Included Files

Include Paths
- 0/home/rest4rfa/public_html/live/lib
- 2/usr/lib/php
- 3/usr/local/lib/php
- 4-> /home/rest4rfa/public_html/live/lib/Cake/
Included Files
- core
  Behavior
  0CORE/Model/BehaviorCollection.php
  1CORE/Model/Behavior/TranslateBehavior.php
  2CORE/Model/ModelBehavior.php
  Cache
  0CORE/Cache/Cache.php
  1CORE/Cache/Engine/FileEngine.php
  2CORE/Cache/CacheEngine.php
  3CORE/Routing/Filter/CacheDispatcher.php
  Component
  0CORE/Controller/ComponentCollection.php
  1CORE/Controller/Component.php
  2CORE/Controller/Component/SessionComponent.php
  3CORE/Controller/Component/CookieComponent.php
  4CORE/Controller/Component/AuthComponent.php
  5CORE/Controller/Component/RequestHandlerComponent.php
  6CORE/Controller/Component/PaginatorComponent.php
  7CORE/Controller/Component/EmailComponent.php
  Config
  0CORE/Core/Configure.php
  1CORE/Config/routes.php
  2CORE/Config/config.php
  Controller
  0CORE/Controller/Controller.php
  Datasource
  0CORE/Model/Datasource/CakeSession.php
  1CORE/Model/Datasource/Database/Mysql.php
  2CORE/Model/Datasource/DboSource.php
  3CORE/Model/Datasource/DataSource.php
  Error
  0CORE/Error/exceptions.php
  1CORE/Error/ErrorHandler.php
  I18n
  0CORE/I18n/I18n.php
  1CORE/I18n/L10n.php
  Log
  0CORE/Log/CakeLog.php
  1CORE/Log/LogEngineCollection.php
  2CORE/Log/Engine/FileLog.php
  3CORE/Log/Engine/BaseLog.php
  4CORE/Log/CakeLogInterface.php
  Model
  0CORE/Model/Model.php
  1CORE/Model/ConnectionManager.php
  2CORE/Model/I18nModel.php
  Network
  0CORE/Network/CakeRequest.php
  1CORE/Network/CakeResponse.php
  Other
  0CORE/bootstrap.php
  1CORE/basics.php
  2CORE/Core/App.php
  3CORE/Event/CakeEventListener.php
  4CORE/Event/CakeEvent.php
  5CORE/Event/CakeEventManager.php
  6CORE/Core/Object.php
  Plugin
  0CORE/Core/CakePlugin.php
  1CORE/Routing/Route/PluginShortRoute.php
  Routing
  0CORE/Routing/Dispatcher.php
  1CORE/Routing/Filter/AssetDispatcher.php
  2CORE/Routing/DispatcherFilter.php
  3CORE/Routing/Router.php
  4CORE/Routing/Route/CakeRoute.php
  Utility
  0CORE/Utility/Hash.php
  1CORE/Utility/Inflector.php
  2CORE/Utility/ObjectCollection.php
  3CORE/Utility/Debugger.php
  4CORE/Utility/String.php
  5CORE/Utility/ClassRegistry.php
  View
  0CORE/View/HelperCollection.php
- app
  Behavior
  0APP/Model/Behavior/CaptchaBehavior.php
  Component
  0APP/Controller/Component/ImageUploaderComponent.php
  1APP/Controller/Component/FileUploaderComponent.php
  Config
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/routes.php
  3APP/Config/database.php
  4APP/Config/Env/database.liverest.php
  Controller
  0APP/Controller/EntitiesController.php
  1APP/Controller/AppController.php
  Model
  0APP/Model/Setting.php
  1APP/Model/AppModel.php
  2APP/Model/Entity.php
  3APP/Model/TickTask.php
  4APP/Model/City.php
  5APP/Model/User.php
  6APP/Model/Gallery.php
  7APP/Model/Promotion.php
  8APP/Model/Video.php
  9APP/Model/Region.php
  10APP/Model/Service.php
  11APP/Model/Image.php
  12APP/Model/AccommodationType.php
  13APP/Model/Description.php
  14APP/Model/ImageCaption.php
  Other
  0APP/webroot/index.php
  1APP/Vendor/recaptcha/recaptchalib.php
- plugins
  Comments
  Config
  0Comments/Config/routes.php
  DebugKit
  Component
  0DebugKit/Controller/Component/ToolbarComponent.php
  Plugin
  0DebugKit/Lib/DebugMemory.php
  1DebugKit/Lib/Panel/HistoryPanel.php
  2DebugKit/Lib/DebugPanel.php
  3DebugKit/Lib/Panel/SessionPanel.php
  4DebugKit/Lib/Panel/RequestPanel.php
  5DebugKit/Lib/Panel/SqlLogPanel.php
  6DebugKit/Lib/Panel/TimerPanel.php
  7DebugKit/Lib/Panel/LogPanel.php
  8DebugKit/Lib/Log/Engine/DebugKitLogListener.php
  9DebugKit/Lib/Panel/VariablesPanel.php
  10DebugKit/Lib/Panel/EnvironmentPanel.php
  11DebugKit/Lib/Panel/IncludePanel.php
  12DebugKit/Lib/DebugTimer.php
  Legacy
  Config
  0Legacy/Config/routes.php
  Logger
  Component
  0Logger/Controller/Component/LoggerComponent.php
====

Find restaurants in most major cities and resorts

Restaurant MERCURE Sofia

Buchung

Galleries (3)

Information

Menu

Wine list

Sonderangebote (0)

Video (0)

Kommentare

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 143 ms Total Queries: 356 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 143 ms
Total Queries: 356 queries