HomeRestaurantsBar & Grill "OCEAN" Sozopol

Bar & Grill "OCEAN" Sozopol

Sozopol

Booking

Address:Sozopol, Sea Garden

Phone:0550-2-41-52

Services:Parking, Garden/ Terrace, Outdoor, DJ/ Singer (upon request)

Seats:120

Price category:

Cuisine:Bulgarian, European, International

Clubs nearby

Hotels nearby

Number of reviews: 10848

Galleries (0)

Information

Bar & Grill "OCEAN" Sozopol is Situated in the sea garden in Sozopol, at the sea. offers nice dishes, BBQ specialties and national Sach - dishes attractive trio plays nice music

Wine list

Video (0)

Comments

History
+
Request History
4 previous requests available
====
Session
+
Session
- Config
  userAgent388974426ec470e5a836a102366c10b0
  time1792006424
  countdown10
  languageeng
====
Request
+
Request

Cake Params
- plugin(null)
- controllerentities
- actionview
- named(empty)
- pass
  04176
- languageeng
- slugrestoranti-sozopol-bar-and-grill-ocean-okean-biraria
- id4176
- 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: 462 ms
Total Queries: 355 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	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	0
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
SELECT content from i18n WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1	1	1	1
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` = 'eng') WHERE 1 = 1	2109	2109	27
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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 4176 LIMIT 1	1	1	12	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` = (4176)	1	1	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` = (4176)	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` = (4176)	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` = (4176)	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` = 'Entity' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (4176)	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` = (4176)	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` = (4176)	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` = (4176)	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` = (4176)	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` = (4176)	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` = (4176)	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` = (4176)	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` = (4176)	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` = 4176 AND `EntitiesRegion`.`region_id` = `Region`.`id`)	0	0	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` = 'eng') WHERE `Menu`.`menu_type` = 'main' ORDER BY `Menu`.`item_position` ASC	11	11	2	maybe slow
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` = 'eng') WHERE 1 = 1 ORDER BY `AccommodationType`.`name` ASC	56	56	2
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` = 'eng') 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` = 'eng') WHERE 1 = 1 ORDER BY `City`.`position` DESC, `City`.`name` ASC	296	296	13
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` = 'eng') WHERE `Entity`.`subscription_level` != 0 AND `Entity`.`active` = '1' ORDER BY `Entity`.`vip` DESC, `Entity`.`top` DESC, `Entity`.`name` ASC	546	546	39	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` = 'eng') WHERE 1 = 1 ORDER BY `Region`.`position` ASC, `Region`.`name` ASC	193	193	11	maybe slow
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` = 'eng') WHERE `Service`.`id` IN (2, 7, 3, 5, 9)	5	5	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` = '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` = 'eng') LEFT JOIN `rest4rfa_restaurantnew`.`descriptions` AS `Description` ON (`City`.`description_id` = `Description`.`id`) WHERE `City`.`main` = '1' ORDER BY `City`.`id` ASC	15	15	10	maybe slow
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` = 'eng') WHERE `Menu`.`menu_type` = 'footer' ORDER BY `Menu`.`item_position` ASC	8	8	1	maybe slow
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 16.57 MB

Message	Memory use
Component initialization	1.65 MB
Controller action start	2.65 MB
Controller render start	4.28 MB
Component initialization #2	4.88 MB
Controller action start #2	4.91 MB
Controller render start #2	6.20 MB
Component initialization #3	6.55 MB
Controller action start #3	6.64 MB
Component initialization #4	6.90 MB
Controller action start #4	6.94 MB
Component initialization #5	7.47 MB
Controller action start #5	7.51 MB
Component initialization #6	7.56 MB
Controller action start #6	7.59 MB
Component initialization #7	7.78 MB
Controller action start #7	7.81 MB
View render complete	7.82 MB

Timers

Total Request Time: 782 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	14.80
Event: Controller.initialize	7.53
Event: Controller.startup	1.38
Controller action	87.67
Event: Controller.beforeRender	27.24
» Processing toolbar data	27.00
Rendering View	496.79
» Event: View.beforeRender	0.03
» Rendering APP/View/Entities/view.ctp	362.27
» » Rendering APP/View/Elements/Reservations/add_short.ctp	352.25
» » » Event: Controller.initialize #2	0.12
» » » Event: Controller.startup #2	0.44
» » » Controller action #2	315.67
» » » Event: Controller.beforeRender #2	28.59
» » » » Processing toolbar data #2	28.38
Rendering View #2	0.00
» » » » Event: View.beforeRender #2	0.03
» » » Rendering APP/View/Reservations/add_short.ctp #2	5.38
» » » » » Rendering APP/View/Elements/errors.ctp	0.31
» » » » Event: View.afterRender	0.03
» » » » Event: Controller.shutdown	0.04
» » Event: View.afterRender #2	0.02
» » Event: View.beforeLayout	0.02
» » Rendering APP/View/Layouts/default.ctp	133.86
» » » Rendering APP/View/Elements/ad.ctp	0.17
» » » Rendering APP/View/Elements/ad.ctp #2	0.15
» » » Rendering APP/View/Elements/Menus/list_by_type.ctp	126.09
» » » » Event: Controller.initialize #3	1.01
» » » » Event: Controller.startup #3	0.53
Controller action #3	0.00
» » » » » Event: Controller.shutdown #2	0.03
» » » » » Rendering APP/View/Elements/Entities/search.ctp	101.37
» » » » » » Event: Controller.initialize #4	0.46
» » » » » » Event: Controller.startup #4	0.46
Controller action #4	0.00
» » » » » » » Event: Controller.shutdown #3	0.06
» » » » » » » Rendering APP/View/Elements/Entities/services.ctp	5.80
» » » » » » » » 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	15.37
» » » » » » » » Event: Controller.initialize #6	0.45
» » » » » » » » Event: Controller.startup #6	0.42
Controller action #6	0.00
» » » » » » » » » Event: Controller.shutdown #5	0.04
» » » » » » » Rendering APP/View/Elements/Menus/list_by_type.ctp #2	5.91
» » » » » » » » Event: Controller.initialize #7	0.48
» » » » » » » » Event: Controller.startup #7	0.43
Controller action #7	0.00
» » » » » » » » » Event: Controller.shutdown #6	0.03
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- metaDescriptionBar & Grill "OCEAN" Sozopol is situated in the sea garden in Sozopol, at the sea. offers nice dishes, BBQ specialties and national Sach - dishes attractive trio plays nice music
- winelists(empty)
- menus(empty)
- galleries
 0
 0
 Image
 id2378
 parent_id657
 parent_modelGallery
 image_url/img/entities/4176/image4176_2.jpg
 thumb_url/img/entities/4176/image4176_2.jpg
 created2013-07-28 00:00:00
 modified2013-07-28 00:00:00
 user_id(null)
 Gallery
 id657
 titleБирария "ОКЕАН" Созопол
 entity_id4176
 image_url/img/entities/4176/image4176_1.jpg
 thumb_url/img/entities/4176/image4176_1.jpg
 created2013-07-28
 modified2013-07-28 00:00:00
 user_id(null)
 image_count5
 type(null)
 active1
 ImageCaption
 id(null)
 caption(null)
 created(null)
 modified(null)
 user_id(null)
 image_id(null)
 1
 Image
 id2379
 parent_id657
 parent_modelGallery
 image_url/img/entities/4176/image4176_3.jpg
 thumb_url/img/entities/4176/image4176_3.jpg
 created2013-07-28 00:00:00
 modified2013-07-28 00:00:00
 user_id(null)
 Gallery
 id657
 titleБирария "ОКЕАН" Созопол
 entity_id4176
 image_url/img/entities/4176/image4176_1.jpg
 thumb_url/img/entities/4176/image4176_1.jpg
 created2013-07-28
 modified2013-07-28 00:00:00
 user_id(null)
 image_count5
 type(null)
 active1
 ImageCaption
 id(null)
 caption(null)
 created(null)
 modified(null)
 user_id(null)
 image_id(null)
 2
 Image
 id2380
 parent_id657
 parent_modelGallery
 image_url/img/entities/4176/image4176_4.jpg
 thumb_url/img/entities/4176/image4176_4.jpg
 created2013-07-28 00:00:00
 modified2013-07-28 00:00:00
 user_id(null)
 Gallery
 id657
 titleБирария "ОКЕАН" Созопол
 entity_id4176
 image_url/img/entities/4176/image4176_1.jpg
 thumb_url/img/entities/4176/image4176_1.jpg
 created2013-07-28
 modified2013-07-28 00:00:00
 user_id(null)
 image_count5
 type(null)
 active1
 ImageCaption
 id(null)
 caption(null)
 created(null)
 modified(null)
 user_id(null)
 image_id(null)
 3
 Image
 id2381
 parent_id657
 parent_modelGallery
 image_url/img/entities/4176/image4176_5.jpg
 thumb_url/img/entities/4176/image4176_5.jpg
 created2013-07-28 00:00:00
 modified2013-07-28 00:00:00
 user_id(null)
 Gallery
 id657
 titleБирария "ОКЕАН" Созопол
 entity_id4176
 image_url/img/entities/4176/image4176_1.jpg
 thumb_url/img/entities/4176/image4176_1.jpg
 created2013-07-28
 modified2013-07-28 00:00:00
 user_id(null)
 image_count5
 type(null)
 active1
 ImageCaption
 id(null)
 caption(null)
 created(null)
 modified(null)
 user_id(null)
 image_id(null)
 4
 Image
 id2382
 parent_id657
 parent_modelGallery
 image_url/img/entities/4176/image4176_6.jpg
 thumb_url/img/entities/4176/image4176_6.jpg
 created2013-07-28 00:00:00
 modified2013-07-28 00:00:00
 user_id(null)
 Gallery
 id657
 titleБирария "ОКЕАН" Созопол
 entity_id4176
 image_url/img/entities/4176/image4176_1.jpg
 thumb_url/img/entities/4176/image4176_1.jpg
 created2013-07-28
 modified2013-07-28 00:00:00
 user_id(null)
 image_count5
 type(null)
 active1
 ImageCaption
 id(null)
 caption(null)
 created(null)
 modified(null)
 user_id(null)
 image_id(null)
- accommodation_types
 0
 AccommodationType
 id13
 nameBulgarian
 created0000-00-00 00:00:00
 modified2013-07-30 21:26:15
 user_id1
 slugMehana-Bylgarska-kuhnya
 description_id(null)
 localeeng
 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)
 localeeng
 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
 id32
 nameInternational
 created0000-00-00 00:00:00
 modified2013-07-30 21:54:11
 user_id1
 slugInternacionalen-Internacionalna-kuhnya
 description_id(null)
 localeeng
 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
 id2
 nameParking
 created0000-00-00 00:00:00
 modified0000-00-00 00:00:00
 user_id1
 slugParking
 localeeng
 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Парковка
 1
 Service
 id5
 nameGarden/ Terrace
 created0000-00-00 00:00:00
 modified0000-00-00 00:00:00
 user_id1
 slugGradina-Terasa
 localeeng
 nameTranslation
 0
 id1745
 localebul
 modelService
 foreign_key5
 fieldname
 contentГрадина/ тераса
 1
 id1791
 localedeu
 modelService
 foreign_key5
 fieldname
 contentGarten / Terrasse
 2
 id1768
 localeeng
 modelService
 foreign_key5
 fieldname
 contentGarden/ Terrace
 3
 id1837
 localerom
 modelService
 foreign_key5
 fieldname
 contentGrădină / Terasă
 4
 id1814
 localerus
 modelService
 foreign_key5
 fieldname
 contentСад / Терраса
 2
 Service
 id6
 nameOutdoor
 created0000-00-00 00:00:00
 modified0000-00-00 00:00:00
 user_id1
 slugNa-otkrito
 localeeng
 nameTranslation
 0
 id1746
 localebul
 modelService
 foreign_key6
 fieldname
 contentНа открито
 1
 id1792
 localedeu
 modelService
 foreign_key6
 fieldname
 contentIm Freien
 2
 id1769
 localeeng
 modelService
 foreign_key6
 fieldname
 contentOutdoor
 3
 id1838
 localerom
 modelService
 foreign_key6
 fieldname
 contentIn aer Liber
 4
 id1815
 localerus
 modelService
 foreign_key6
 fieldname
 contentНа открытом воздухе
 3
 Service
 id12
 nameDJ/ Singer (upon request)
 created0000-00-00 00:00:00
 modified2014-03-19 23:13:17
 user_id1
 slugjiva-muzika-dj
 localeeng
 nameTranslation
 0
 id1752
 localebul
 modelService
 foreign_key12
 fieldname
 contentЖива музика/ DJ
 1
 id1798
 localedeu
 modelService
 foreign_key12
 fieldname
 contentDJ / Singer (auf Anfrage)
 2
 id1775
 localeeng
 modelService
 foreign_key12
 fieldname
 contentDJ/ Singer (upon request)
 3
 id1844
 localerom
 modelService
 foreign_key12
 fieldname
 contentDJ / Singer (la cerere)
 4
 id1821
 localerus
 modelService
 foreign_key12
 fieldname
 contentDJ / Singer (по запросу)
- ref/
- entity
 Entity
 id4176
 nameBar & Grill "OCEAN" Sozopol
 category3
 slugrestoranti-sozopol-bar-and-grill-ocean-okean-biraria
 rab_vreme(null)
 active1
 accommodation_typeБългарска;Европейска;Международна
 type(null)
 addressSozopol, Sea Garden
 city_id227
 latitude(null)
 longitude(null)
 phone0550-2-41-52
 phone_manager
 skype
 website
 fb
 email[email protected]
 unit_price1
 servicesПаркинг; Градина/ тераса; На открито; Жива музика/ DJ
 beds120
 infoBar & Grill "OCEAN" Sozopol is Situated in the sea garden in Sozopol, at the sea. offers nice dishes, BBQ specialties and national Sach - dishes attractive trio plays nice music
 price_list
 visits10848
 header_img/img/entities/header.jpg
 thumb_img/img/entities/4176/image4176_thumb.jpg
 vip0
 vip_position100
 vip_title
 vip_text
 vip_img(null)
 top0
 top_position100
 top_text
 created0000-00-00 00:00:00
 modified2018-07-06 07:29:01
 user_id(null)
 subscription_level0
 tick_base0
 tick_step(null)
 tick_interval(null)
 active_promotion_count0
 gallery_count1
 video_count0
 _category(null)
 restaurant_menu(null)
 restaurant_winelist(null)
 page_titleBar & Grill "OCEAN" Sozopol
 meta_descriptionBar & Grill "OCEAN" Sozopol is situated in the sea garden in Sozopol, at the sea. offers nice dishes, BBQ specialties and national Sach - dishes attractive trio plays nice music
 reservations1
 enable_comments1
 website_eng(null)
 website_deu(null)
 website_rus(null)
 website_rom(null)
 tripadvisor
 foursquare
 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)
 hits10848
 localeeng
 City
 id227
 nameSozopol
 main1
 position0
 created0000-00-00 00:00:00
 modified0000-00-00 00:00:00
 user_id1
 slugSozopol
 description_id(null)
 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
 id657
 titleБирария "ОКЕАН" Созопол
 entity_id4176
 image_url/img/entities/4176/image4176_1.jpg
 thumb_url/img/entities/4176/image4176_1.jpg
 created2013-07-28
 modified2013-07-28 00:00:00
 user_id(null)
 image_count5
 type(null)
 active1
 Promotion(empty)
 Video(empty)
 TickTask(empty)
 nameTranslation
 0
 id2599
 localebul
 modelEntity
 foreign_key4176
 fieldname
 contentБирария "ОКЕАН" Созопол
 1
 id4617
 localedeu
 modelEntity
 foreign_key4176
 fieldname
 contentBiergarten "OKEAN"
 2
 id3608
 localeeng
 modelEntity
 foreign_key4176
 fieldname
 contentBar & Grill "OCEAN" Sozopol
 3
 id5626
 localerom
 modelEntity
 foreign_key4176
 fieldname
 contentPorterhouse "OCEAN" Sozopol
 4
 id6635
 localerus
 modelEntity
 foreign_key4176
 fieldname
 contentПивная "ОКЕАН" Созополь
 addressTranslation
 0
 id7644
 localebul
 modelEntity
 foreign_key4176
 fieldaddress
 contentСозопол, Морски парк
 1
 id9662
 localedeu
 modelEntity
 foreign_key4176
 fieldaddress
 contentSozopol, Meeresgarten
 2
 id8653
 localeeng
 modelEntity
 foreign_key4176
 fieldaddress
 contentSozopol, Sea Garden
 3
 id11680
 localerom
 modelEntity
 foreign_key4176
 fieldaddress
 contentSozopol, Sea Garden
 4
 id10671
 localerus
 modelEntity
 foreign_key4176
 fieldaddress
 contentСозопол, Морски парк
 infoTranslation
 0
 id12689
 localebul
 modelEntity
 foreign_key4176
 fieldinfo
 contentБирария "ОКЕАН" Созопол е разположена в морски парк Созопол, на брега на морето. Предлага вкусни мезета,BBQ специалитети и апетитни ястия на сач.Атрактивно музикално трио изпълнява популярна поп-музика
 1
 id14707
 localedeu
 modelEntity
 foreign_key4176
 fieldinfo
 contentIm Meeresgarten von Sozopol, bietet schmackhaftes Essen, BBQ spezialitaeten, Bulgarische Satsch Gerichte, Live Musik von Trio
 2
 id13698
 localeeng
 modelEntity
 foreign_key4176
 fieldinfo
 contentBar & Grill "OCEAN" Sozopol is Situated in the sea garden in Sozopol, at the sea. offers nice dishes, BBQ specialties and national Sach - dishes attractive trio plays nice music
 3
 id16725
 localerom
 modelEntity
 foreign_key4176
 fieldinfo
 contentSituated in the sea garden in Sozopol, at the sea. offers nice dishes, BBQ specialties and national Sach - dishes attractive trio plays nice music
 4
 id15716
 localerus
 modelEntity
 foreign_key4176
 fieldinfo
 content
 price_listTranslation
 0
 id17734
 localebul
 modelEntity
 foreign_key4176
 fieldprice_list
 content
 1
 id19752
 localedeu
 modelEntity
 foreign_key4176
 fieldprice_list
 content
 2
 id18743
 localeeng
 modelEntity
 foreign_key4176
 fieldprice_list
 content
 3
 id21770
 localerom
 modelEntity
 foreign_key4176
 fieldprice_list
 content
 4
 id20761
 localerus
 modelEntity
 foreign_key4176
 fieldprice_list
 content
 vip_titleTranslation
 0
 id32869
 localebul
 modelEntity
 foreign_key4176
 fieldvip_title
 content
 1
 id34887
 localedeu
 modelEntity
 foreign_key4176
 fieldvip_title
 content
 2
 id33878
 localeeng
 modelEntity
 foreign_key4176
 fieldvip_title
 content
 3
 id36905
 localerom
 modelEntity
 foreign_key4176
 fieldvip_title
 content
 4
 id35896
 localerus
 modelEntity
 foreign_key4176
 fieldvip_title
 content
 vip_textTranslation
 0
 id27824
 localebul
 modelEntity
 foreign_key4176
 fieldvip_text
 content
 1
 id29842
 localedeu
 modelEntity
 foreign_key4176
 fieldvip_text
 content
 2
 id28833
 localeeng
 modelEntity
 foreign_key4176
 fieldvip_text
 content
 3
 id31860
 localerom
 modelEntity
 foreign_key4176
 fieldvip_text
 content
 4
 id30851
 localerus
 modelEntity
 foreign_key4176
 fieldvip_text
 content
 top_textTranslation
 0
 id22779
 localebul
 modelEntity
 foreign_key4176
 fieldtop_text
 content
 1
 id24797
 localedeu
 modelEntity
 foreign_key4176
 fieldtop_text
 content
 2
 id23788
 localeeng
 modelEntity
 foreign_key4176
 fieldtop_text
 content
 3
 id26815
 localerom
 modelEntity
 foreign_key4176
 fieldtop_text
 content
 4
 id25806
 localerus
 modelEntity
 foreign_key4176
 fieldtop_text
 content
 page_titleTranslation
 0
 id47537
 localebul
 modelEntity
 foreign_key4176
 fieldpage_title
 contentБирария "ОКЕАН" Созопол
 1
 id49565
 localedeu
 modelEntity
 foreign_key4176
 fieldpage_title
 content(null)
 2
 id48551
 localeeng
 modelEntity
 foreign_key4176
 fieldpage_title
 contentBar & Grill "OCEAN" Sozopol
 3
 id51593
 localerom
 modelEntity
 foreign_key4176
 fieldpage_title
 contentPorterhouse "OCEAN" Sozopol
 4
 id50579
 localerus
 modelEntity
 foreign_key4176
 fieldpage_title
 contentПивная "ОКЕАН" Созополь
 meta_descriptionTranslation
 0
 id42467
 localebul
 modelEntity
 foreign_key4176
 fieldmeta_description
 contentБирария "ОКЕАН" Созопол е разположена в морски парк Созопол, на брега на морето. Предлага вкусни мезета,BBQ специалитети и апетитни ястия на сач.Атрактивно музикално трио изпълнява популярна поп-музика
 1
 id44495
 localedeu
 modelEntity
 foreign_key4176
 fieldmeta_description
 content(null)
 2
 id43481
 localeeng
 modelEntity
 foreign_key4176
 fieldmeta_description
 contentBar & Grill "OCEAN" Sozopol is situated in the sea garden in Sozopol, at the sea. offers nice dishes, BBQ specialties and national Sach - dishes attractive trio plays nice music
 3
 id46523
 localerom
 modelEntity
 foreign_key4176
 fieldmeta_description
 contentBine ati venit la Porterhouse "OCEAN" Sozopol - 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 Burgas.
 4
 id45509
 localerus
 modelEntity
 foreign_key4176
 fieldmeta_description
 contentДобро пожаловать в Пивная "ОКЕАН" Созополь- контактные данные, меню, цены, галерея с фотографиями и акциях. Поиск другой ресторан, паб, пиццерия, таверна, бистро или бар в Созопол.
 Region(empty)
- $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
 7Session
 8HtmlToolbar
====

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	/eng/restoranti/restoranti-sozopol-bar-and-grill-ocean-okean-biraria-4176
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/app/webroot/eng/restoranti/restoranti-sozopol-bar-and-grill-ocean-okean-biraria-4176
Remote Port	55518
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	a4a7a4eb5e5c3cd0-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	as-g2Ie0Iec9B5JD4wX_7AAAAEM
Redirect Status	200
Redirect Ssl Tls Sni	live.restaurant.bg
Redirect Https	on
Redirect Sh Company Origin	superhosting.bg
Redirect Unique Id	as-g2Ie0Iec9B5JD4wX_7AAAAEM
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	as-g2Ie0Iec9B5JD4wX_7AAAAEM
Fcgi Role	RESPONDER
Php Self	/app/webroot/index.php
Request Time Float	1791992024.94
Request Time	1791992024
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

Bar & Grill "OCEAN" Sozopol

Booking

Galleries (0)

Information

Menu

Wine list

Promotions (0)

Video (0)

Comments

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 462 ms Total Queries: 355 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 462 ms
Total Queries: 355 queries