HomeRestauranteRAFFY Bar & Gelato THE MALL Sofia

RAFFY Bar & Gelato THE MALL Sofia

Sofia

Rezervare

Adresa:ниво 2, The Mall, бул. „Цариградско шосе“ 115 з , 1784 София

Phone:089 556 9147

Links Website | Facebook | Instagram |

Servicii:Wi Fi, Parcare, Plata Prin Card, Aer Condiționat, Meniu de Prânz, Promotii / Evenimente

Număr de locuri:140

Categorie Pret:

Tip de bucătărie:Națională a Bulgariei, European, Italian, Steakhouse, Sushi

Cluburi in apropiere

Hoteluri în apropiere

A se vedea o hartă

Numărul de comentarii: 126085

Galleries (4)

RAFFY Bar & Gelato THE MALL (2)

Интериор (2)

RAFFY THE MALL (13)

Fresh (5)

Information

Bine ati venit la RAFFY Bar & Gelato THE MALL Sofia, care este situat la ниво 2, The Mall, бул. „Цариградско шосе“ 115 з , 1784 София. Restaurantul are o capacitate de 140 locuri și este unul dintre restaurantele din oraș Sofia, care oferă următoarele tipuri de bucătărie: Națională a Bulgariei, European, Italian, Steakhouse, Sushi, servicii: Wi Fi, Parcare, Plata Prin Card, Aer Condiționat, Meniu de Prânz, Promotii / Evenimente.

De contact din telefon și rezervări cu с RAFFY Bar & Gelato THE MALL Sofia: 089 556 9147.

Wine list

Video (0)

Mesaje

History
+
Request History
4 previous requests available
====
Session
+
Session
- Config
  userAgent388974426ec470e5a836a102366c10b0
  time1791977161
  countdown10
  languagerom
====
Request
+
Request

Cake Params
- plugin(null)
- controllerentities
- actionview
- named(empty)
- pass
  05356
- languagerom
- slugsofia-restaurants-raffy-bar-gelato-the-mall-sofia-restorant-rafi-the-mall
- id5356
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

Cookie
- 0(empty)
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: 211 ms
Total Queries: 364 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` = 'rom') WHERE 1 = 1	2109	2109	31
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` = 'rom') 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` = 'rom') 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` = 'rom') 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` = 'rom') 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` = 'rom') 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` = 'rom') 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` = 'rom') 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` = 'rom') 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` = 'rom') 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` = 5356 LIMIT 1	1	1	14	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` = (5356)	4	4	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` = (5356)	1	1	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` = (5356)	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` = (5356)	1	1	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` = (5356)	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` = (5356)	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` = (5356)	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` = (5356)	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` = (5356)	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` = (5356)	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` = (5356)	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` = (5356)	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` = (5356)	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` = 5356 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` = 'rom') 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` = 'rom') 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` = 'rom') 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` = 'rom') 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` = 'rom') WHERE `Entity`.`subscription_level` != 0 AND `Entity`.`active` = '1' ORDER BY `Entity`.`vip` DESC, `Entity`.`top` DESC, `Entity`.`name` ASC	546	546	41	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` = 'rom') 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` = 'rom') 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` = 'rom') 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	0
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` = 'rom') 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 14.96 MB

Message	Memory use
Component initialization	1.67 MB
Controller action start	2.65 MB
Controller render start	4.53 MB
Component initialization #2	5.06 MB
Controller action start #2	5.09 MB
Controller render start #2	6.39 MB
Component initialization #3	6.79 MB
Controller action start #3	6.89 MB
Component initialization #4	7.15 MB
Controller action start #4	7.19 MB
Component initialization #5	7.74 MB
Controller action start #5	7.77 MB
Component initialization #6	7.81 MB
Controller action start #6	7.84 MB
Component initialization #7	8.02 MB
Controller action start #7	8.05 MB
View render complete	8.04 MB

Timers

Total Request Time: 662 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	9.67
Event: Controller.initialize	8.30
Event: Controller.startup	1.31
Controller action	171.47
Event: Controller.beforeRender	17.99
» Processing toolbar data	17.66
Rendering View	292.33
» Event: View.beforeRender	0.05
» Rendering APP/View/Entities/view.ctp	184.70
» » Rendering APP/View/Elements/Reservations/add_short.ctp	179.51
» » » Event: Controller.initialize #2	0.16
» » » Event: Controller.startup #2	0.70
» » » Controller action #2	142.46
» » » Event: Controller.beforeRender #2	26.57
» » » » Processing toolbar data #2	26.30
Rendering View #2	0.00
» » » » Event: View.beforeRender #2	0.05
» » » Rendering APP/View/Reservations/add_short.ctp #2	6.89
» » » » » Rendering APP/View/Elements/errors.ctp	0.34
» » » » Event: View.afterRender	0.03
» » » » Event: Controller.shutdown	0.06
» » Event: View.afterRender #2	0.03
» » Event: View.beforeLayout	0.02
» » Rendering APP/View/Layouts/default.ctp	106.83
» » » Rendering APP/View/Elements/ad.ctp	0.16
» » » Rendering APP/View/Elements/ad.ctp #2	0.15
» » » Rendering APP/View/Elements/Menus/list_by_type.ctp	100.18
» » » » Event: Controller.initialize #3	1.26
» » » » Event: Controller.startup #3	0.53
Controller action #3	0.00
» » » » » Event: Controller.shutdown #2	0.04
» » » » » Rendering APP/View/Elements/Entities/search.ctp	84.55
» » » » » » Event: Controller.initialize #4	0.60
» » » » » » Event: Controller.startup #4	0.55
Controller action #4	0.00
» » » » » » » Event: Controller.shutdown #3	0.06
» » » » » » » Rendering APP/View/Elements/Entities/services.ctp	6.14
» » » » » » » » Event: Controller.initialize #5	0.55
» » » » » » » » Event: Controller.startup #5	0.43
Controller action #5	0.00
» » » » » » » » » Event: Controller.shutdown #4	0.06
» » » » » » » Rendering APP/View/Elements/Cities/short_list.ctp	6.51
» » » » » » » » Event: Controller.initialize #6	0.51
» » » » » » » » Event: Controller.startup #6	0.45
Controller action #6	0.00
» » » » » » » » » Event: Controller.shutdown #5	0.05
» » » » » » » Rendering APP/View/Elements/Menus/list_by_type.ctp #2	4.86
» » » » » » » » Event: Controller.initialize #7	0.46
» » » » » » » » Event: Controller.startup #7	0.44
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
- metaDescriptionBine ati venit la RAFFY Bar & Gelato THE MALL 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.
- winelists(empty)
- menus(empty)
- galleries
 0
 0
 Image
 id29270
 parent_id3744
 parent_modelGallery
 image_url/img/entities/5356/1600267800_1200_1-raffy the mall logo.jpg
 thumb_url/img/entities/5356/thumbnails/1600267800_thumbnail_1-raffy the mall logo.jpg
 created2020-09-16 17:50:01
 modified2020-09-16 17:50:01
 user_id(null)
 Gallery
 id3744
 titleRAFFY Bar & Gelato THE MALL
 entity_id5356
 image_url/img/entities/5356/1600267786_1200_1-raffy the mall 2.jpg
 thumb_url/img/entities/5356/thumbnails/1600267787_thumbnail_1-raffy the mall 2.jpg
 created2020-09-16
 modified2020-09-16 17:49:47
 user_id(null)
 image_count1
 type(null)
 active1
 ImageCaption
 id2122
 captionRAFFY Bar & Gelato THE MALL
 created2020-09-16 17:50:01
 modified2020-09-16 17:50:01
 user_id(null)
 image_id29270
 1
 0
 Image
 id29271
 parent_id3745
 parent_modelGallery
 image_url/img/entities/5356/1600267835_1200_1-raffy the mall 22.jpg
 thumb_url/img/entities/5356/thumbnails/1600267835_thumbnail_1-raffy the mall 22.jpg
 created2020-09-16 17:50:35
 modified2020-09-16 17:50:35
 user_id(null)
 Gallery
 id3745
 titleИнтериор
 entity_id5356
 image_url/img/entities/5356/1600267822_1200_1-raffy the mall 1.jpg
 thumb_url/img/entities/5356/thumbnails/1600267822_thumbnail_1-raffy the mall 1.jpg
 created2020-09-16
 modified2020-09-16 17:50:22
 user_id(null)
 image_count1
 type(null)
 active1
 ImageCaption
 id2123
 captionRAFFY Bar & Gelato THE MALL
 created2020-09-16 17:50:35
 modified2020-09-16 17:50:35
 user_id(null)
 image_id29271
 2
 0
 Image
 id29422
 parent_id3766
 parent_modelGallery
 image_url/img/entities/5356/120133516_374071970664537_4884432404974147975_n.jpg
 thumb_url/img/entities/5356/thumbnails/1600885080_thumbnail_120133516_374071970664537_4884432404974147975_n.jpg
 created2020-09-23 21:18:01
 modified2020-09-23 21:18:01
 user_id(null)
 Gallery
 id3766
 titleRAFFY THE MALL
 entity_id5356
 image_url/img/entities/5356/1.jpg
 thumb_url/img/entities/5356/thumbnails/1600885061_thumbnail_1.jpg
 created2020-09-23
 modified2020-09-23 21:17:43
 user_id(null)
 image_count12
 type(null)
 active1
 ImageCaption
 id2142
 captionRAFFY THE MALL
 created2020-09-23 21:18:01
 modified2020-09-23 21:18:01
 user_id(null)
 image_id29422
 1
 Image
 id29411
 parent_id3766
 parent_modelGallery
 image_url/img/entities/5356/119981432_374071487331252_847314078351941201_n.jpg
 thumb_url/img/entities/5356/thumbnails/1600885078_thumbnail_119981432_374071487331252_847314078351941201_n.jpg
 created2020-09-23 21:18:01
 modified2020-09-23 21:18:01
 user_id(null)
 Gallery
 id3766
 titleRAFFY THE MALL
 entity_id5356
 image_url/img/entities/5356/1.jpg
 thumb_url/img/entities/5356/thumbnails/1600885061_thumbnail_1.jpg
 created2020-09-23
 modified2020-09-23 21:17:43
 user_id(null)
 image_count12
 type(null)
 active1
 ImageCaption
 id(null)
 caption(null)
 created(null)
 modified(null)
 user_id(null)
 image_id(null)
 2
 Image
 id29412
 parent_id3766
 parent_modelGallery
 image_url/img/entities/5356/120009991_374071497331251_7437851360369270985_n.jpg
 thumb_url/img/entities/5356/thumbnails/1600885078_thumbnail_120009991_374071497331251_7437851360369270985_n.jpg
 created2020-09-23 21:18:01
 modified2020-09-23 21:18:01
 user_id(null)
 Gallery
 id3766
 titleRAFFY THE MALL
 entity_id5356
 image_url/img/entities/5356/1.jpg
 thumb_url/img/entities/5356/thumbnails/1600885061_thumbnail_1.jpg
 created2020-09-23
 modified2020-09-23 21:17:43
 user_id(null)
 image_count12
 type(null)
 active1
 ImageCaption
 id(null)
 caption(null)
 created(null)
 modified(null)
 user_id(null)
 image_id(null)
 3
 Image
 id29413
 parent_id3766
 parent_modelGallery
 image_url/img/entities/5356/120013539_374071353997932_6140812698771719113_n.jpg
 thumb_url/img/entities/5356/thumbnails/1600885079_thumbnail_120013539_374071353997932_6140812698771719113_n.jpg
 created2020-09-23 21:18:01
 modified2020-09-23 21:18:01
 user_id(null)
 Gallery
 id3766
 titleRAFFY THE MALL
 entity_id5356
 image_url/img/entities/5356/1.jpg
 thumb_url/img/entities/5356/thumbnails/1600885061_thumbnail_1.jpg
 created2020-09-23
 modified2020-09-23 21:17:43
 user_id(null)
 image_count12
 type(null)
 active1
 ImageCaption
 id(null)
 caption(null)
 created(null)
 modified(null)
 user_id(null)
 image_id(null)
 4
 Image
 id29414
 parent_id3766
 parent_modelGallery
 image_url/img/entities/5356/120013545_374071550664579_5000635517455822517_n.jpg
 thumb_url/img/entities/5356/thumbnails/1600885079_thumbnail_120013545_374071550664579_5000635517455822517_n.jpg
 created2020-09-23 21:18:01
 modified2020-09-23 21:18:01
 user_id(null)
 Gallery
 id3766
 titleRAFFY THE MALL
 entity_id5356
 image_url/img/entities/5356/1.jpg
 thumb_url/img/entities/5356/thumbnails/1600885061_thumbnail_1.jpg
 created2020-09-23
 modified2020-09-23 21:17:43
 user_id(null)
 image_count12
 type(null)
 active1
 ImageCaption
 id(null)
 caption(null)
 created(null)
 modified(null)
 user_id(null)
 image_id(null)
 5
 Image
 id29415
 parent_id3766
 parent_modelGallery
 image_url/img/entities/5356/120025039_374071427331258_1307992157039625053_n.jpg
 thumb_url/img/entities/5356/thumbnails/1600885079_thumbnail_120025039_374071427331258_1307992157039625053_n.jpg
 created2020-09-23 21:18:01
 modified2020-09-23 21:18:01
 user_id(null)
 Gallery
 id3766
 titleRAFFY THE MALL
 entity_id5356
 image_url/img/entities/5356/1.jpg
 thumb_url/img/entities/5356/thumbnails/1600885061_thumbnail_1.jpg
 created2020-09-23
 modified2020-09-23 21:17:43
 user_id(null)
 image_count12
 type(null)
 active1
 ImageCaption
 id(null)
 caption(null)
 created(null)
 modified(null)
 user_id(null)
 image_id(null)
 6
 Image
 id29416
 parent_id3766
 parent_modelGallery
 image_url/img/entities/5356/120033767_374072020664532_3363792557056061621_n.jpg
 thumb_url/img/entities/5356/thumbnails/1600885079_thumbnail_120033767_374072020664532_3363792557056061621_n.jpg
 created2020-09-23 21:18:01
 modified2020-09-23 21:18:01
 user_id(null)
 Gallery
 id3766
 titleRAFFY THE MALL
 entity_id5356
 image_url/img/entities/5356/1.jpg
 thumb_url/img/entities/5356/thumbnails/1600885061_thumbnail_1.jpg
 created2020-09-23
 modified2020-09-23 21:17:43
 user_id(null)
 image_count12
 type(null)
 active1
 ImageCaption
 id(null)
 caption(null)
 created(null)
 modified(null)
 user_id(null)
 image_id(null)
 7
 Image
 id29417
 parent_id3766
 parent_modelGallery
 image_url/img/entities/5356/120034784_374071737331227_5627526711051555012_n.jpg
 thumb_url/img/entities/5356/thumbnails/1600885080_thumbnail_120034784_374071737331227_5627526711051555012_n.jpg
 created2020-09-23 21:18:01
 modified2020-09-23 21:18:01
 user_id(null)
 Gallery
 id3766
 titleRAFFY THE MALL
 entity_id5356
 image_url/img/entities/5356/1.jpg
 thumb_url/img/entities/5356/thumbnails/1600885061_thumbnail_1.jpg
 created2020-09-23
 modified2020-09-23 21:17:43
 user_id(null)
 image_count12
 type(null)
 active1
 ImageCaption
 id(null)
 caption(null)
 created(null)
 modified(null)
 user_id(null)
 image_id(null)
 8
 Image
 id29418
 parent_id3766
 parent_modelGallery
 image_url/img/entities/5356/120043037_374072090664525_7915591241053611162_n.jpg
 thumb_url/img/entities/5356/thumbnails/1600885080_thumbnail_120043037_374072090664525_7915591241053611162_n.jpg
 created2020-09-23 21:18:01
 modified2020-09-23 21:18:01
 user_id(null)
 Gallery
 id3766
 titleRAFFY THE MALL
 entity_id5356
 image_url/img/entities/5356/1.jpg
 thumb_url/img/entities/5356/thumbnails/1600885061_thumbnail_1.jpg
 created2020-09-23
 modified2020-09-23 21:17:43
 user_id(null)
 image_count12
 type(null)
 active1
 ImageCaption
 id(null)
 caption(null)
 created(null)
 modified(null)
 user_id(null)
 image_id(null)
 9
 Image
 id29419
 parent_id3766
 parent_modelGallery
 image_url/img/entities/5356/120087024_374071963997871_6212625102875677607_n.jpg
 thumb_url/img/entities/5356/thumbnails/1600885080_thumbnail_120087024_374071963997871_6212625102875677607_n.jpg
 created2020-09-23 21:18:01
 modified2020-09-23 21:18:01
 user_id(null)
 Gallery
 id3766
 titleRAFFY THE MALL
 entity_id5356
 image_url/img/entities/5356/1.jpg
 thumb_url/img/entities/5356/thumbnails/1600885061_thumbnail_1.jpg
 created2020-09-23
 modified2020-09-23 21:17:43
 user_id(null)
 image_count12
 type(null)
 active1
 ImageCaption
 id(null)
 caption(null)
 created(null)
 modified(null)
 user_id(null)
 image_id(null)
 10
 Image
 id29420
 parent_id3766
 parent_modelGallery
 image_url/img/entities/5356/120115434_374072027331198_5520487930465813864_n.jpg
 thumb_url/img/entities/5356/thumbnails/1600885080_thumbnail_120115434_374072027331198_5520487930465813864_n.jpg
 created2020-09-23 21:18:01
 modified2020-09-23 21:18:01
 user_id(null)
 Gallery
 id3766
 titleRAFFY THE MALL
 entity_id5356
 image_url/img/entities/5356/1.jpg
 thumb_url/img/entities/5356/thumbnails/1600885061_thumbnail_1.jpg
 created2020-09-23
 modified2020-09-23 21:17:43
 user_id(null)
 image_count12
 type(null)
 active1
 ImageCaption
 id(null)
 caption(null)
 created(null)
 modified(null)
 user_id(null)
 image_id(null)
 11
 Image
 id29421
 parent_id3766
 parent_modelGallery
 image_url/img/entities/5356/120122101_374071420664592_3988515574911057935_n.jpg
 thumb_url/img/entities/5356/thumbnails/1600885080_thumbnail_120122101_374071420664592_3988515574911057935_n.jpg
 created2020-09-23 21:18:01
 modified2020-09-23 21:18:01
 user_id(null)
 Gallery
 id3766
 titleRAFFY THE MALL
 entity_id5356
 image_url/img/entities/5356/1.jpg
 thumb_url/img/entities/5356/thumbnails/1600885061_thumbnail_1.jpg
 created2020-09-23
 modified2020-09-23 21:17:43
 user_id(null)
 image_count12
 type(null)
 active1
 ImageCaption
 id(null)
 caption(null)
 created(null)
 modified(null)
 user_id(null)
 image_id(null)
 3
 0
 Image
 id38852
 parent_id5133
 parent_modelGallery
 image_url/img/entities/5356/1696934921_1200_387768644_814589884004734_2885466714412027607_n.jpg
 thumb_url/img/entities/5356/thumbnails/1696934921_thumbnail_387768644_814589884004734_2885466714412027607_n.jpg
 created2023-10-10 13:48:45
 modified2023-10-10 13:48:45
 user_id(null)
 Gallery
 id5133
 titleFresh
 entity_id5356
 image_url/img/entities/5356/1696934907_1200_1.jpeg
 thumb_url/img/entities/5356/thumbnails/1696934907_thumbnail_1.jpeg
 created2023-10-10
 modified2023-10-10 13:48:28
 user_id(null)
 image_count4
 type(null)
 active1
 ImageCaption
 id(null)
 caption(null)
 created(null)
 modified(null)
 user_id(null)
 image_id(null)
 1
 Image
 id38853
 parent_id5133
 parent_modelGallery
 image_url/img/entities/5356/387780519_814593937337662_5412361787122813545_n.jpg
 thumb_url/img/entities/5356/thumbnails/1696934922_thumbnail_387780519_814593937337662_5412361787122813545_n.jpg
 created2023-10-10 13:48:45
 modified2023-10-10 13:48:45
 user_id(null)
 Gallery
 id5133
 titleFresh
 entity_id5356
 image_url/img/entities/5356/1696934907_1200_1.jpeg
 thumb_url/img/entities/5356/thumbnails/1696934907_thumbnail_1.jpeg
 created2023-10-10
 modified2023-10-10 13:48:28
 user_id(null)
 image_count4
 type(null)
 active1
 ImageCaption
 id(null)
 caption(null)
 created(null)
 modified(null)
 user_id(null)
 image_id(null)
 2
 Image
 id38854
 parent_id5133
 parent_modelGallery
 image_url/img/entities/5356/1696934923_1200_387826674_814589827338073_5476374736170205055_n.jpg
 thumb_url/img/entities/5356/thumbnails/1696934923_thumbnail_387826674_814589827338073_5476374736170205055_n.jpg
 created2023-10-10 13:48:45
 modified2023-10-10 13:48:45
 user_id(null)
 Gallery
 id5133
 titleFresh
 entity_id5356
 image_url/img/entities/5356/1696934907_1200_1.jpeg
 thumb_url/img/entities/5356/thumbnails/1696934907_thumbnail_1.jpeg
 created2023-10-10
 modified2023-10-10 13:48:28
 user_id(null)
 image_count4
 type(null)
 active1
 ImageCaption
 id(null)
 caption(null)
 created(null)
 modified(null)
 user_id(null)
 image_id(null)
 3
 Image
 id38855
 parent_id5133
 parent_modelGallery
 image_url/img/entities/5356/1696934924_1200_387871844_814589850671404_7489758752067908338_n.jpg
 thumb_url/img/entities/5356/thumbnails/1696934924_thumbnail_387871844_814589850671404_7489758752067908338_n.jpg
 created2023-10-10 13:48:45
 modified2023-10-10 13:48:45
 user_id(null)
 Gallery
 id5133
 titleFresh
 entity_id5356
 image_url/img/entities/5356/1696934907_1200_1.jpeg
 thumb_url/img/entities/5356/thumbnails/1696934907_thumbnail_1.jpeg
 created2023-10-10
 modified2023-10-10 13:48:28
 user_id(null)
 image_count4
 type(null)
 active1
 ImageCaption
 id(null)
 caption(null)
 created(null)
 modified(null)
 user_id(null)
 image_id(null)
- accommodation_types
 0
 AccommodationType
 id13
 nameNațională a Bulgariei
 created0000-00-00 00:00:00
 modified2013-07-30 21:26:15
 user_id1
 slugMehana-Bylgarska-kuhnya
 description_id(null)
 localerom
 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
 id22
 nameEuropean
 created0000-00-00 00:00:00
 modified2013-07-30 21:39:29
 user_id1
 slugEvropeiiski-Evropeiiska-kuhnya
 description_id(null)
 localerom
 Description
 id(null)
 text(null)
 type(null)
 created(null)
 modified(null)
 nameTranslation
 0
 id1497
 localebul
 modelAccommodationType
 foreign_key22
 fieldname
 contentЕвропейска
 1
 id1603
 localedeu
 modelAccommodationType
 foreign_key22
 fieldname
 contentEuropaeische
 2
 id1550
 localeeng
 modelAccommodationType
 foreign_key22
 fieldname
 contentEuropean
 3
 id1709
 localerom
 modelAccommodationType
 foreign_key22
 fieldname
 contentEuropean
 4
 id1656
 localerus
 modelAccommodationType
 foreign_key22
 fieldname
 contentЕвропейская
 2
 AccommodationType
 id27
 nameItalian
 created0000-00-00 00:00:00
 modified2013-07-30 21:59:01
 user_id1
 slugItalianski-Italianska-kuhnya
 description_id(null)
 localerom
 Description
 id(null)
 text(null)
 type(null)
 created(null)
 modified(null)
 nameTranslation
 0
 id1502
 localebul
 modelAccommodationType
 foreign_key27
 fieldname
 contentИталианска
 1
 id1608
 localedeu
 modelAccommodationType
 foreign_key27
 fieldname
 contentItalienische
 2
 id1555
 localeeng
 modelAccommodationType
 foreign_key27
 fieldname
 contentItalian
 3
 id1714
 localerom
 modelAccommodationType
 foreign_key27
 fieldname
 contentItalian
 4
 id1661
 localerus
 modelAccommodationType
 foreign_key27
 fieldname
 contentИтальянская
 3
 AccommodationType
 id40
 nameSteakhouse
 created0000-00-00 00:00:00
 modified2013-07-30 21:38:20
 user_id1
 slugStek-Stekove
 description_id(null)
 localerom
 Description
 id(null)
 text(null)
 type(null)
 created(null)
 modified(null)
 nameTranslation
 0
 id1515
 localebul
 modelAccommodationType
 foreign_key40
 fieldname
 contentСтек Специалитети
 1
 id1621
 localedeu
 modelAccommodationType
 foreign_key40
 fieldname
 contentSteaksspezialitaeten
 2
 id1568
 localeeng
 modelAccommodationType
 foreign_key40
 fieldname
 contentSteakhouse
 3
 id1727
 localerom
 modelAccommodationType
 foreign_key40
 fieldname
 contentSteakhouse
 4
 id1674
 localerus
 modelAccommodationType
 foreign_key40
 fieldname
 contentБифштексная
 4
 AccommodationType
 id41
 nameSushi
 created0000-00-00 00:00:00
 modified2013-07-30 21:37:01
 user_id1
 slugSushi-Sushi-kuhnya
 description_id(null)
 localerom
 Description
 id(null)
 text(null)
 type(null)
 created(null)
 modified(null)
 nameTranslation
 0
 id1516
 localebul
 modelAccommodationType
 foreign_key41
 fieldname
 contentСуши
 1
 id1622
 localedeu
 modelAccommodationType
 foreign_key41
 fieldname
 contentSushi
 2
 id1569
 localeeng
 modelAccommodationType
 foreign_key41
 fieldname
 contentSushi
 3
 id1728
 localerom
 modelAccommodationType
 foreign_key41
 fieldname
 contentSushi
 4
 id1675
 localerus
 modelAccommodationType
 foreign_key41
 fieldname
 contentСуши
- promotions
 0
 Promotion
 id778
 entity_id5356
 active1
 titleОбявяваме Raffy Маратона за открит!
 image_url/img/entities/5356/1-raffy maraton.jpeg
 thumb_url/img/entities/5356/thumbnails/1641539726_thumbnail_1-raffy maraton.jpeg
 summaryтомбола за награда – ваучер за консумация на стойност 500 лв
 bodyОбявяваме Raffy Маратона за открит! Събери 5 касови бележки от 5-те Raffy-та в София и ни ги изпрати в лично съобщение, за да те включим в томбола за награда – ваучер за консумация на стойност 500 лв. в любимото ти Raffy. Условията са прости, сумата на касовия бон да бъде не по-малкa от 15 лв. Така или иначе постоянно си в Raffy, участвай в маратона. Ще изтеглим победителя на 6-ти февруари 2022. Успех! -Raffy Bar & Gelato - ул. Ангел Кънчев №11, тел. за резервации: 089 5515 045 -Raffy Bar & Gelato - бул. Витоша №18, тел. за резервации: 089 551 5041 -Raffy Bar & Gelato - ул. Шипка № 9, тел. за резервации: 0897 847 154 -Raffy The Mall - бул. Цариградско шосе 115 з, ет.2, тел. за резервации: 089 556 9147 -Raffy Terrasse - бул. Витоша №18, ет.2, тел. за резервации: 0892 218 588
 priority0
 created2022-01-07 09:15:26
 modified2022-01-07 09:15:27
 user_id(null)
 slugobjavjavame-raffy-maratona-za-otkrit
 page_titleОбявяваме Raffy Маратона за открит!
 meta_descriptionтомбола за награда – ваучер за консумация на стойност 500 лв
 createdDate2022-01-07
 localerom
 Entity
 id5356
 nameRestaurant Bar & Gelato RAFFY THE MALL София
 category3
 slugsofia-restaurants-raffy-bar-gelato-the-mall-sofia-restorant-rafi-the-mall
 rab_vreme(null)
 active1
 accommodation_typeБългарска;Европейска;Италианска;Стек Специалитети;Суши
 type(null)
 addressниво 2, The Mall, бул. „Цариградско шосе“ 115 з , 1784 София
 city_id0
 latitude42.6601
 longitude23.3811
 phone089 556 9147
 phone_manager
 skype
 websitehttp://raffy.bg
 fbhttps://www.facebook.com/raffythemall/
 email[email protected]
 unit_price2
 servicesWi Fi; Паркинг; Безкасово плащане; Климатик; Обедно меню; Промоции
 beds140
 info
 price_list
 visits6086
 header_img/img/entities/5356/1-raffy the mall header.jpg
 thumb_img/img/entities/5356/1600267726_200_1-raffy the mall logo 215.jpg
 vip0
 vip_position100
 vip_title
 vip_text
 vip_img(null)
 top0
 top_position100
 top_text
 created2020-09-16 17:48:46
 modified2020-09-23 09:44:12
 user_id(null)
 subscription_level2
 tick_base0
 tick_step(null)
 tick_interval(null)
 active_promotion_count1
 gallery_count4
 video_count0
 _category(null)
 restaurant_menu(null)
 restaurant_winelist(null)
 page_titleRAFFY Bar & Gelato THE MALL София
 meta_descriptionЗаповядайте в RAFFY Bar & Gelato THE MALL София - контакти, снимки, цени, меню, мнения, промоции. Разгледайте и останалите ни предложения за ресторанти, заведения, барове, механи, кръчми, бирарии и пицарии в София.
 reservations1
 enable_comments1
 website_eng(null)
 website_deu(null)
 website_rus(null)
 website_rom(null)
 tripadvisor
 foursquarehttps://www.instagram.com/raffybargelato/
 delivery1
 delivery2
 delivery3
 delivery4
 delivery5
 delivery1_name
 delivery2_name
 delivery3_name
 delivery4_name
 delivery5_name
 reservation_link
 reservation_link_eng(null)
 reservation_link_deu(null)
 reservation_link_rus(null)
 reservation_link_rom(null)
 hits126086
 Image(empty)
 titleTranslation
 0
 id126888
 localebul
 modelPromotion
 foreign_key778
 fieldtitle
 contentОбявяваме Raffy Маратона за открит!
 1
 id126893
 localeeng
 modelPromotion
 foreign_key778
 fieldtitle
 contentОбявяваме Raffy Маратона за открит!
 2
 id126898
 localedeu
 modelPromotion
 foreign_key778
 fieldtitle
 contentОбявяваме Raffy Маратона за открит!
 3
 id126903
 localerus
 modelPromotion
 foreign_key778
 fieldtitle
 contentОбявяваме Raffy Маратона за открит!
 4
 id126908
 localerom
 modelPromotion
 foreign_key778
 fieldtitle
 contentОбявяваме Raffy Маратона за открит!
 summaryTranslation
 0
 id126889
 localebul
 modelPromotion
 foreign_key778
 fieldsummary
 contentтомбола за награда – ваучер за консумация на стойност 500 лв
 1
 id126894
 localeeng
 modelPromotion
 foreign_key778
 fieldsummary
 contentтомбола за награда – ваучер за консумация на стойност 500 лв
 2
 id126899
 localedeu
 modelPromotion
 foreign_key778
 fieldsummary
 contentтомбола за награда – ваучер за консумация на стойност 500 лв
 3
 id126904
 localerus
 modelPromotion
 foreign_key778
 fieldsummary
 contentтомбола за награда – ваучер за консумация на стойност 500 лв
 4
 id126909
 localerom
 modelPromotion
 foreign_key778
 fieldsummary
 contentтомбола за награда – ваучер за консумация на стойност 500 лв
 bodyTranslation
 0
 id126890
 localebul
 modelPromotion
 foreign_key778
 fieldbody
 contentОбявяваме Raffy Маратона за открит! Събери 5 касови бележки от 5-те Raffy-та в София и ни ги изпрати в лично съобщение, за да те включим в томбола за награда – ваучер за консумация на стойност 500 лв. в любимото ти Raffy. Условията са прости, сумата на касовия бон да бъде не по-малкa от 15 лв. Така или иначе постоянно си в Raffy, участвай в маратона. Ще изтеглим победителя на 6-ти февруари 2022. Успех! -Raffy Bar & Gelato - ул. Ангел Кънчев №11, тел. за резервации: 089 5515 045 -Raffy Bar & Gelato - бул. Витоша №18, тел. за резервации: 089 551 5041 -Raffy Bar & Gelato - ул. Шипка № 9, тел. за резервации: 0897 847 154 -Raffy The Mall - бул. Цариградско шосе 115 з, ет.2, тел. за резервации: 089 556 9147 -Raffy Terrasse - бул. Витоша №18, ет.2, тел. за резервации: 0892 218 588
 1
 id126895
 localeeng
 modelPromotion
 foreign_key778
 fieldbody
 contentОбявяваме Raffy Маратона за открит! Събери 5 касови бележки от 5-те Raffy-та в София и ни ги изпрати в лично съобщение, за да те включим в томбола за награда – ваучер за консумация на стойност 500 лв. в любимото ти Raffy. Условията са прости, сумата на касовия бон да бъде не по-малкa от 15 лв. Така или иначе постоянно си в Raffy, участвай в маратона. Ще изтеглим победителя на 6-ти февруари 2022. Успех! -Raffy Bar & Gelato - ул. Ангел Кънчев №11, тел. за резервации: 089 5515 045 -Raffy Bar & Gelato - бул. Витоша №18, тел. за резервации: 089 551 5041 -Raffy Bar & Gelato - ул. Шипка № 9, тел. за резервации: 0897 847 154 -Raffy The Mall - бул. Цариградско шосе 115 з, ет.2, тел. за резервации: 089 556 9147 -Raffy Terrasse - бул. Витоша №18, ет.2, тел. за резервации: 0892 218 588
 2
 id126900
 localedeu
 modelPromotion
 foreign_key778
 fieldbody
 contentОбявяваме Raffy Маратона за открит! Събери 5 касови бележки от 5-те Raffy-та в София и ни ги изпрати в лично съобщение, за да те включим в томбола за награда – ваучер за консумация на стойност 500 лв. в любимото ти Raffy. Условията са прости, сумата на касовия бон да бъде не по-малкa от 15 лв. Така или иначе постоянно си в Raffy, участвай в маратона. Ще изтеглим победителя на 6-ти февруари 2022. Успех! -Raffy Bar & Gelato - ул. Ангел Кънчев №11, тел. за резервации: 089 5515 045 -Raffy Bar & Gelato - бул. Витоша №18, тел. за резервации: 089 551 5041 -Raffy Bar & Gelato - ул. Шипка № 9, тел. за резервации: 0897 847 154 -Raffy The Mall - бул. Цариградско шосе 115 з, ет.2, тел. за резервации: 089 556 9147 -Raffy Terrasse - бул. Витоша №18, ет.2, тел. за резервации: 0892 218 588
 3
 id126905
 localerus
 modelPromotion
 foreign_key778
 fieldbody
 contentОбявяваме Raffy Маратона за открит! Събери 5 касови бележки от 5-те Raffy-та в София и ни ги изпрати в лично съобщение, за да те включим в томбола за награда – ваучер за консумация на стойност 500 лв. в любимото ти Raffy. Условията са прости, сумата на касовия бон да бъде не по-малкa от 15 лв. Така или иначе постоянно си в Raffy, участвай в маратона. Ще изтеглим победителя на 6-ти февруари 2022. Успех! -Raffy Bar & Gelato - ул. Ангел Кънчев №11, тел. за резервации: 089 5515 045 -Raffy Bar & Gelato - бул. Витоша №18, тел. за резервации: 089 551 5041 -Raffy Bar & Gelato - ул. Шипка № 9, тел. за резервации: 0897 847 154 -Raffy The Mall - бул. Цариградско шосе 115 з, ет.2, тел. за резервации: 089 556 9147 -Raffy Terrasse - бул. Витоша №18, ет.2, тел. за резервации: 0892 218 588
 4
 id126910
 localerom
 modelPromotion
 foreign_key778
 fieldbody
 contentОбявяваме Raffy Маратона за открит! Събери 5 касови бележки от 5-те Raffy-та в София и ни ги изпрати в лично съобщение, за да те включим в томбола за награда – ваучер за консумация на стойност 500 лв. в любимото ти Raffy. Условията са прости, сумата на касовия бон да бъде не по-малкa от 15 лв. Така или иначе постоянно си в Raffy, участвай в маратона. Ще изтеглим победителя на 6-ти февруари 2022. Успех! -Raffy Bar & Gelato - ул. Ангел Кънчев №11, тел. за резервации: 089 5515 045 -Raffy Bar & Gelato - бул. Витоша №18, тел. за резервации: 089 551 5041 -Raffy Bar & Gelato - ул. Шипка № 9, тел. за резервации: 0897 847 154 -Raffy The Mall - бул. Цариградско шосе 115 з, ет.2, тел. за резервации: 089 556 9147 -Raffy Terrasse - бул. Витоша №18, ет.2, тел. за резервации: 0892 218 588
 page_titleTranslation
 0
 id126891
 localebul
 modelPromotion
 foreign_key778
 fieldpage_title
 contentОбявяваме Raffy Маратона за открит!
 1
 id126896
 localeeng
 modelPromotion
 foreign_key778
 fieldpage_title
 contentОбявяваме Raffy Маратона за открит!
 2
 id126901
 localedeu
 modelPromotion
 foreign_key778
 fieldpage_title
 contentОбявяваме Raffy Маратона за открит!
 3
 id126906
 localerus
 modelPromotion
 foreign_key778
 fieldpage_title
 contentОбявяваме Raffy Маратона за открит!
 4
 id126911
 localerom
 modelPromotion
 foreign_key778
 fieldpage_title
 contentОбявяваме Raffy Маратона за открит!
 meta_descriptionTranslation
 0
 id126892
 localebul
 modelPromotion
 foreign_key778
 fieldmeta_description
 contentтомбола за награда – ваучер за консумация на стойност 500 лв
 1
 id126897
 localeeng
 modelPromotion
 foreign_key778
 fieldmeta_description
 contentтомбола за награда – ваучер за консумация на стойност 500 лв
 2
 id126902
 localedeu
 modelPromotion
 foreign_key778
 fieldmeta_description
 contentтомбола за награда – ваучер за консумация на стойност 500 лв
 3
 id126907
 localerus
 modelPromotion
 foreign_key778
 fieldmeta_description
 contentтомбола за награда – ваучер за консумация на стойност 500 лв
 4
 id126912
 localerom
 modelPromotion
 foreign_key778
 fieldmeta_description
 contentтомбола за награда – ваучер за консумация на стойност 500 лв
- services
 0
 Service
 id1
 nameWi Fi
 created0000-00-00 00:00:00
 modified0000-00-00 00:00:00
 user_id1
 slugWiFi
 localerom
 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
 nameParcare
 created0000-00-00 00:00:00
 modified0000-00-00 00:00:00
 user_id1
 slugParking
 localerom
 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
 namePlata Prin Card
 created0000-00-00 00:00:00
 modified0000-00-00 00:00:00
 user_id1
 slugBezkasovo-Plashtane
 localerom
 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
 nameAer Condiționat
 created0000-00-00 00:00:00
 modified0000-00-00 00:00:00
 user_id1
 slugKlimatik
 localerom
 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
 id14
 nameMeniu de Prânz
 created0000-00-00 00:00:00
 modified0000-00-00 00:00:00
 user_id1
 slugObedno-menu
 localerom
 nameTranslation
 0
 id1754
 localebul
 modelService
 foreign_key14
 fieldname
 contentОбедно меню
 1
 id1800
 localedeu
 modelService
 foreign_key14
 fieldname
 contentMittagstisch
 2
 id1777
 localeeng
 modelService
 foreign_key14
 fieldname
 contentLunch menu
 3
 id1846
 localerom
 modelService
 foreign_key14
 fieldname
 contentMeniu de Prânz
 4
 id1823
 localerus
 modelService
 foreign_key14
 fieldname
 contentОбеденное меню
 5
 Service
 id22
 namePromotii / Evenimente
 created0000-00-00 00:00:00
 modified0000-00-00 00:00:00
 user_id1
 slugPromocii
 localerom
 nameTranslation
 0
 id1762
 localebul
 modelService
 foreign_key22
 fieldname
 contentПромоции
 1
 id1808
 localedeu
 modelService
 foreign_key22
 fieldname
 contentAktionen / Veranstaltungen
 2
 id1785
 localeeng
 modelService
 foreign_key22
 fieldname
 contentPromotions/ Events
 3
 id1854
 localerom
 modelService
 foreign_key22
 fieldname
 contentPromotii / Evenimente
 4
 id1831
 localerus
 modelService
 foreign_key22
 fieldname
 contentАкции / События
- ref/
- entity
 Entity
 id5356
 nameRAFFY Bar & Gelato THE MALL Sofia
 category3
 slugsofia-restaurants-raffy-bar-gelato-the-mall-sofia-restorant-rafi-the-mall
 rab_vreme(null)
 active1
 accommodation_typeБългарска;Европейска;Италианска;Стек Специалитети;Суши
 type(null)
 addressниво 2, The Mall, бул. „Цариградско шосе“ 115 з , 1784 София
 city_id0
 latitude42.6601
 longitude23.3811
 phone089 556 9147
 phone_manager
 skype
 websitehttp://raffy.bg
 fbhttps://www.facebook.com/raffythemall/
 email[email protected]
 unit_price2
 servicesWi Fi; Паркинг; Безкасово плащане; Климатик; Обедно меню; Промоции
 beds140
 info
 price_list
 visits6085
 header_img/img/entities/5356/1-raffy the mall header.jpg
 thumb_img/img/entities/5356/1600267726_200_1-raffy the mall logo 215.jpg
 vip0
 vip_position100
 vip_title
 vip_text
 vip_img(null)
 top0
 top_position100
 top_text
 created2020-09-16 17:48:46
 modified2020-09-23 09:44:12
 user_id(null)
 subscription_level2
 tick_base0
 tick_step(null)
 tick_interval(null)
 active_promotion_count1
 gallery_count4
 video_count0
 _category(null)
 restaurant_menu(null)
 restaurant_winelist(null)
 page_titleRAFFY Bar & Gelato THE MALL Sofia
 meta_description
 reservations1
 enable_comments1
 website_eng(null)
 website_deu(null)
 website_rus(null)
 website_rom(null)
 tripadvisor
 foursquarehttps://www.instagram.com/raffybargelato/
 delivery1
 delivery2
 delivery3
 delivery4
 delivery5
 delivery1_name
 delivery2_name
 delivery3_name
 delivery4_name
 delivery5_name
 reservation_link
 reservation_link_eng(null)
 reservation_link_deu(null)
 reservation_link_rus(null)
 reservation_link_rom(null)
 hits126085
 localerom
 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
 id3744
 titleRAFFY Bar & Gelato THE MALL
 entity_id5356
 image_url/img/entities/5356/1600267786_1200_1-raffy the mall 2.jpg
 thumb_url/img/entities/5356/thumbnails/1600267787_thumbnail_1-raffy the mall 2.jpg
 created2020-09-16
 modified2020-09-16 17:49:47
 user_id(null)
 image_count1
 type(null)
 active1
 1
 id3745
 titleИнтериор
 entity_id5356
 image_url/img/entities/5356/1600267822_1200_1-raffy the mall 1.jpg
 thumb_url/img/entities/5356/thumbnails/1600267822_thumbnail_1-raffy the mall 1.jpg
 created2020-09-16
 modified2020-09-16 17:50:22
 user_id(null)
 image_count1
 type(null)
 active1
 2
 id3766
 titleRAFFY THE MALL
 entity_id5356
 image_url/img/entities/5356/1.jpg
 thumb_url/img/entities/5356/thumbnails/1600885061_thumbnail_1.jpg
 created2020-09-23
 modified2020-09-23 21:17:43
 user_id(null)
 image_count12
 type(null)
 active1
 3
 id5133
 titleFresh
 entity_id5356
 image_url/img/entities/5356/1696934907_1200_1.jpeg
 thumb_url/img/entities/5356/thumbnails/1696934907_thumbnail_1.jpeg
 created2023-10-10
 modified2023-10-10 13:48:28
 user_id(null)
 image_count4
 type(null)
 active1
 Promotion
 0
 id778
 entity_id5356
 active1
 titleОбявяваме Raffy Маратона за открит!
 image_url/img/entities/5356/1-raffy maraton.jpeg
 thumb_url/img/entities/5356/thumbnails/1641539726_thumbnail_1-raffy maraton.jpeg
 summaryтомбола за награда – ваучер за консумация на стойност 500 лв
 bodyОбявяваме Raffy Маратона за открит! Събери 5 касови бележки от 5-те Raffy-та в София и ни ги изпрати в лично съобщение, за да те включим в томбола за награда – ваучер за консумация на стойност 500 лв. в любимото ти Raffy. Условията са прости, сумата на касовия бон да бъде не по-малкa от 15 лв. Така или иначе постоянно си в Raffy, участвай в маратона. Ще изтеглим победителя на 6-ти февруари 2022. Успех! -Raffy Bar & Gelato - ул. Ангел Кънчев №11, тел. за резервации: 089 5515 045 -Raffy Bar & Gelato - бул. Витоша №18, тел. за резервации: 089 551 5041 -Raffy Bar & Gelato - ул. Шипка № 9, тел. за резервации: 0897 847 154 -Raffy The Mall - бул. Цариградско шосе 115 з, ет.2, тел. за резервации: 089 556 9147 -Raffy Terrasse - бул. Витоша №18, ет.2, тел. за резервации: 0892 218 588
 priority0
 created2022-01-07 09:15:26
 modified2022-01-07 09:15:27
 user_id(null)
 slugobjavjavame-raffy-maratona-za-otkrit
 page_titleОбявяваме Raffy Маратона за открит!
 meta_descriptionтомбола за награда – ваучер за консумация на стойност 500 лв
 createdDate2022-01-07
 Video(empty)
 TickTask
 0
 id406
 entity_id5356
 ticks0
 step1
 interval11
 from_date2020-09-23 09:44:00
 to_date2040-02-02 01:00:00
 max_ticks120000
 modified2020-09-23 09:44:47
 from2020-09-23 09:44:47
 to2026-10-14 10:26:01
 delta120000
 total120000
 nameTranslation
 0
 id118009
 localebul
 modelEntity
 foreign_key5356
 fieldname
 contentRestaurant Bar & Gelato RAFFY THE MALL София
 1
 id118027
 localedeu
 modelEntity
 foreign_key5356
 fieldname
 contentRAFFY Bar & Gelato THE MALL Sofia
 2
 id118018
 localeeng
 modelEntity
 foreign_key5356
 fieldname
 contentRAFFY Bar & Gelato THE MALL Sofia
 3
 id118045
 localerom
 modelEntity
 foreign_key5356
 fieldname
 contentRAFFY Bar & Gelato THE MALL Sofia
 4
 id118036
 localerus
 modelEntity
 foreign_key5356
 fieldname
 contentRAFFY Bar & Gelato THE MALL София
 addressTranslation
 0
 id118010
 localebul
 modelEntity
 foreign_key5356
 fieldaddress
 contentниво 2, The Mall, бул. „Цариградско шосе“ 115 з , 1784 София
 1
 id118029
 localedeu
 modelEntity
 foreign_key5356
 fieldaddress
 contentниво 2, The Mall, бул. „Цариградско шосе“ 115 з , 1784 София
 2
 id118020
 localeeng
 modelEntity
 foreign_key5356
 fieldaddress
 contentниво 2, The Mall, бул. „Цариградско шосе“ 115 з , 1784 София
 3
 id118047
 localerom
 modelEntity
 foreign_key5356
 fieldaddress
 contentниво 2, The Mall, бул. „Цариградско шосе“ 115 з , 1784 София
 4
 id118038
 localerus
 modelEntity
 foreign_key5356
 fieldaddress
 contentниво 2, The Mall, бул. „Цариградско шосе“ 115 з , 1784 София
 infoTranslation
 0
 id118011
 localebul
 modelEntity
 foreign_key5356
 fieldinfo
 content
 1
 id118030
 localedeu
 modelEntity
 foreign_key5356
 fieldinfo
 content
 2
 id118021
 localeeng
 modelEntity
 foreign_key5356
 fieldinfo
 content
 3
 id118048
 localerom
 modelEntity
 foreign_key5356
 fieldinfo
 content
 4
 id118039
 localerus
 modelEntity
 foreign_key5356
 fieldinfo
 content
 price_listTranslation
 0
 id118012
 localebul
 modelEntity
 foreign_key5356
 fieldprice_list
 content
 1
 id118031
 localedeu
 modelEntity
 foreign_key5356
 fieldprice_list
 content
 2
 id118022
 localeeng
 modelEntity
 foreign_key5356
 fieldprice_list
 content
 3
 id118049
 localerom
 modelEntity
 foreign_key5356
 fieldprice_list
 content
 4
 id118040
 localerus
 modelEntity
 foreign_key5356
 fieldprice_list
 content
 vip_titleTranslation
 0
 id118013
 localebul
 modelEntity
 foreign_key5356
 fieldvip_title
 content
 1
 id118032
 localedeu
 modelEntity
 foreign_key5356
 fieldvip_title
 content
 2
 id118023
 localeeng
 modelEntity
 foreign_key5356
 fieldvip_title
 content
 3
 id118050
 localerom
 modelEntity
 foreign_key5356
 fieldvip_title
 content
 4
 id118041
 localerus
 modelEntity
 foreign_key5356
 fieldvip_title
 content
 vip_textTranslation
 0
 id118014
 localebul
 modelEntity
 foreign_key5356
 fieldvip_text
 content
 1
 id118033
 localedeu
 modelEntity
 foreign_key5356
 fieldvip_text
 content
 2
 id118024
 localeeng
 modelEntity
 foreign_key5356
 fieldvip_text
 content
 3
 id118051
 localerom
 modelEntity
 foreign_key5356
 fieldvip_text
 content
 4
 id118042
 localerus
 modelEntity
 foreign_key5356
 fieldvip_text
 content
 top_textTranslation
 0
 id118015
 localebul
 modelEntity
 foreign_key5356
 fieldtop_text
 content
 1
 id118034
 localedeu
 modelEntity
 foreign_key5356
 fieldtop_text
 content
 2
 id118025
 localeeng
 modelEntity
 foreign_key5356
 fieldtop_text
 content
 3
 id118052
 localerom
 modelEntity
 foreign_key5356
 fieldtop_text
 content
 4
 id118043
 localerus
 modelEntity
 foreign_key5356
 fieldtop_text
 content
 page_titleTranslation
 0
 id118016
 localebul
 modelEntity
 foreign_key5356
 fieldpage_title
 contentRAFFY Bar & Gelato THE MALL София
 1
 id118028
 localedeu
 modelEntity
 foreign_key5356
 fieldpage_title
 contentRAFFY Bar & Gelato THE MALL Sofia
 2
 id118019
 localeeng
 modelEntity
 foreign_key5356
 fieldpage_title
 contentRAFFY Bar & Gelato THE MALL Sofia
 3
 id118046
 localerom
 modelEntity
 foreign_key5356
 fieldpage_title
 contentRAFFY Bar & Gelato THE MALL Sofia
 4
 id118037
 localerus
 modelEntity
 foreign_key5356
 fieldpage_title
 contentRAFFY Bar & Gelato THE MALL София
 meta_descriptionTranslation
 0
 id118017
 localebul
 modelEntity
 foreign_key5356
 fieldmeta_description
 contentЗаповядайте в RAFFY Bar & Gelato THE MALL София - контакти, снимки, цени, меню, мнения, промоции. Разгледайте и останалите ни предложения за ресторанти, заведения, барове, механи, кръчми, бирарии и пицарии в София.
 1
 id118035
 localedeu
 modelEntity
 foreign_key5356
 fieldmeta_description
 content
 2
 id118026
 localeeng
 modelEntity
 foreign_key5356
 fieldmeta_description
 content
 3
 id118053
 localerom
 modelEntity
 foreign_key5356
 fieldmeta_description
 content
 4
 id118044
 localerus
 modelEntity
 foreign_key5356
 fieldmeta_description
 content
 Region
 0
 id96
 nameПолигона
 position96
 city_id0
 user_id1
 created0000-00-00 00:00:00
 modified0000-00-00 00:00:00
 EntitiesRegion
 id894
 entity_id5356
 region_id96
 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	/rom/restoranti/sofia-restaurants-raffy-bar-gelato-the-mall-sofia-restorant-rafi-the-mall-5356
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/app/webroot/rom/restoranti/sofia-restaurants-raffy-bar-gelato-the-mall-sofia-restorant-rafi-the-mall-5356
Remote Port	52030
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.103
Server Port	443
Server Addr	195.191.148.105
Server Name	live.restaurant.bg
Server Software	Apache
Server Signature
Http Cf Visitor	{"scheme":"https"}
Http Cf Ipcountry	US
Http Cf Connecting Ip	216.73.216.103
Http Cdn Loop	cloudflare; loops=1
Http Cf Ray	a4a4da78fb76b179-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.103, 216.73.216.103
Http Host	live.restaurant.bg
Ssl Tls Sni	live.restaurant.bg
Https	on
Sh Company Origin	superhosting.bg
Unique Id	as8uiQsrVZOAKPzA9QVfFQAAAIA
Redirect Status	200
Redirect Ssl Tls Sni	live.restaurant.bg
Redirect Https	on
Redirect Sh Company Origin	superhosting.bg
Redirect Unique Id	as8uiQsrVZOAKPzA9QVfFQAAAIA
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	as8uiQsrVZOAKPzA9QVfFQAAAIA
Fcgi Role	RESPONDER
Php Self	/app/webroot/index.php
Request Time Float	1791962761.2
Request Time	1791962761
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

RAFFY Bar & Gelato THE MALL Sofia

Rezervare

Galleries (4)

Information

Menu

Wine list

Promoții (1)

Обявяваме Raffy Маратона за открит!

Video (0)

Mesaje

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 211 ms Total Queries: 364 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 211 ms
Total Queries: 364 queries