کافه دیاموند

13:00:36.3909

[0.0031]

query: SELECT `core_session`.* FROM `core_session` WHERE `id` = :where1

params: [where1] dqtilosrru6nom7tpmlbf4css0;

13:00:36.4167

[0.0004]

query: SELECT `core_permission_rule`.* FROM `core_permission_rule` WHERE `resource` = :where1 AND `section` = :where2 AND `role` IN (:where3) LIMIT :limit

params: [where1] module-admin;[where2] front;[where3] guest;[limit] 1;

13:00:36.4178

[0.0003]

query: SELECT `core_permission_rule`.* FROM `core_permission_rule` WHERE `section` = :where1 AND `module` = :where2 AND `resource` = :where3 AND `role` IN (:where4) LIMIT :limit

params: [where1] front;[where2] guide;[where3] public;[where4] guest;[limit] 1;

13:00:36.4206

[0.0014]

query: SELECT `guide_item`.`id` AS `id`, `guide_item`.`title` AS `title`, `guide_item`.`title_long` AS `title_long`, `guide_item`.`type` AS `type`, `guide_item`.`slug` AS `slug`, `guide_item`.`category` AS `category`, `guide_item`.`business` AS `business`, `guide_item`.`item_type` AS `item_type`, `guide_item`.`status_type` AS `status_type`, `guide_item`.`text_summary` AS `text_summary`, `guide_item`.`text_description` AS `text_description`, `guide_item`.`seo_title` AS `seo_title`, `guide_item`.`seo_keywords` AS `seo_keywords`, `guide_item`.`seo_description` AS `seo_description`, `guide_item`.`status` AS `status`, `guide_item`.`time_create` AS `time_create`, `guide_item`.`time_update` AS `time_update`, `guide_item`.`time_start` AS `time_start`, `guide_item`.`time_end` AS `time_end`, `guide_item`.`uid` AS `uid`, `guide_item`.`owner` AS `owner`, `guide_item`.`package` AS `package`, `guide_item`.`hits` AS `hits`, `guide_item`.`image` AS `image`, `guide_item`.`image_wide` AS `image_wide`, `guide_item`.`path` AS `path`, `guide_item`.`main_image` AS `main_image`, `guide_item`.`additional_images` AS `additional_images`, `guide_item`.`vote` AS `vote`, `guide_item`.`rating` AS `rating`, `guide_item`.`favourite` AS `favourite`, `guide_item`.`checkin` AS `checkin`, `guide_item`.`service` AS `service`, `guide_item`.`attach` AS `attach`, `guide_item`.`attribute` AS `attribute`, `guide_item`.`review` AS `review`, `guide_item`.`recommended` AS `recommended`, `guide_item`.`map_longitude` AS `map_longitude`, `guide_item`.`map_latitude` AS `map_latitude`, `guide_item`.`map_title` AS `map_title`, `guide_item`.`map_final_longitude` AS `map_final_longitude`, `guide_item`.`map_final_latitude` AS `map_final_latitude`, `guide_item`.`map_final_title` AS `map_final_title`, `guide_item`.`itinerary` AS `itinerary`, `guide_item`.`map_zoom` AS `map_zoom`, `guide_item`.`location` AS `location`, `guide_item`.`location_level` AS `location_level`, `guide_item`.`address1` AS `address1`, `guide_item`.`address2` AS `address2`, `guide_item`.`city` AS `city`, `guide_item`.`area` AS `area`, `guide_item`.`zipcode` AS `zipcode`, `guide_item`.`phone1` AS `phone1`, `guide_item`.`website` AS `website`, `guide_item`.`email` AS `email`, `guide_item`.`difficulty` AS `difficulty`, `guide_item`.`duration` AS `duration`, `guide_item`.`elevation_start` AS `elevation_start`, `guide_item`.`elevation_end` AS `elevation_end`, `guide_item`.`loop_type` AS `loop_type`, `guide_item`.`access` AS `access`, `guide_item`.`distance` AS `distance`, `guide_item`.`map_number` AS `map_number`, `guide_item`.`related` AS `related`, `guide_item`.`map_type` AS `map_type`, `guide_item`.`booking` AS `booking`, `guide_item`.`hits_phone` AS `hits_phone`, `guide_item`.`ribbon` AS `ribbon`, `guide_item`.`incentive_calling` AS `incentive_calling`, `guide_item`.`foursquare_id` AS `foursquare_id` FROM `guide_item` WHERE `slug` = :where1

params: [where1] cafe-diamond;

13:00:36.4364

[0.0004]

query: SELECT `media_doc`.`id` AS `id`, `media_doc`.`path` AS `path`, `media_doc`.`filename` AS `filename`, `media_doc`.`attributes` AS `attributes`, `media_doc`.`mimetype` AS `mimetype`, `media_doc`.`title` AS `title`, `media_doc`.`description` AS `description`, `media_doc`.`active` AS `active`, `media_doc`.`time_created` AS `time_created`, `media_doc`.`time_updated` AS `time_updated`, `media_doc`.`time_deleted` AS `time_deleted`, `media_doc`.`appkey` AS `appkey`, `media_doc`.`uid` AS `uid`, `media_doc`.`count` AS `count`, `media_doc`.`season` AS `season`, `media_doc`.`updated_by` AS `updated_by`, `media_doc`.`license_type` AS `license_type`, `media_doc`.`copyright` AS `copyright`, `media_doc`.`geoloc_latitude` AS `geoloc_latitude`, `media_doc`.`geoloc_longitude` AS `geoloc_longitude`, `media_doc`.`cropping` AS `cropping`, `media_doc`.`featured` AS `featured` FROM `media_doc` WHERE `id` = :where1

params: [where1] 3268;

13:00:36.4386

[0.0003]

query: SELECT `media_doc`.`id` AS `id`, `media_doc`.`path` AS `path`, `media_doc`.`filename` AS `filename`, `media_doc`.`attributes` AS `attributes`, `media_doc`.`mimetype` AS `mimetype`, `media_doc`.`title` AS `title`, `media_doc`.`description` AS `description`, `media_doc`.`active` AS `active`, `media_doc`.`time_created` AS `time_created`, `media_doc`.`time_updated` AS `time_updated`, `media_doc`.`time_deleted` AS `time_deleted`, `media_doc`.`appkey` AS `appkey`, `media_doc`.`uid` AS `uid`, `media_doc`.`count` AS `count`, `media_doc`.`season` AS `season`, `media_doc`.`updated_by` AS `updated_by`, `media_doc`.`license_type` AS `license_type`, `media_doc`.`copyright` AS `copyright`, `media_doc`.`geoloc_latitude` AS `geoloc_latitude`, `media_doc`.`geoloc_longitude` AS `geoloc_longitude`, `media_doc`.`cropping` AS `cropping`, `media_doc`.`featured` AS `featured` FROM `media_doc` WHERE `id` = :where1

params: [where1] 3268;

13:00:36.4402

[0.0003]

query: SELECT `media_doc`.`id` AS `id`, `media_doc`.`path` AS `path`, `media_doc`.`filename` AS `filename`, `media_doc`.`attributes` AS `attributes`, `media_doc`.`mimetype` AS `mimetype`, `media_doc`.`title` AS `title`, `media_doc`.`description` AS `description`, `media_doc`.`active` AS `active`, `media_doc`.`time_created` AS `time_created`, `media_doc`.`time_updated` AS `time_updated`, `media_doc`.`time_deleted` AS `time_deleted`, `media_doc`.`appkey` AS `appkey`, `media_doc`.`uid` AS `uid`, `media_doc`.`count` AS `count`, `media_doc`.`season` AS `season`, `media_doc`.`updated_by` AS `updated_by`, `media_doc`.`license_type` AS `license_type`, `media_doc`.`copyright` AS `copyright`, `media_doc`.`geoloc_latitude` AS `geoloc_latitude`, `media_doc`.`geoloc_longitude` AS `geoloc_longitude`, `media_doc`.`cropping` AS `cropping`, `media_doc`.`featured` AS `featured` FROM `media_doc` WHERE `id` = :where1

params: [where1] 3268;

13:00:36.4419

[0.0003]

query: SELECT `media_doc`.`id` AS `id`, `media_doc`.`path` AS `path`, `media_doc`.`filename` AS `filename`, `media_doc`.`attributes` AS `attributes`, `media_doc`.`mimetype` AS `mimetype`, `media_doc`.`title` AS `title`, `media_doc`.`description` AS `description`, `media_doc`.`active` AS `active`, `media_doc`.`time_created` AS `time_created`, `media_doc`.`time_updated` AS `time_updated`, `media_doc`.`time_deleted` AS `time_deleted`, `media_doc`.`appkey` AS `appkey`, `media_doc`.`uid` AS `uid`, `media_doc`.`count` AS `count`, `media_doc`.`season` AS `season`, `media_doc`.`updated_by` AS `updated_by`, `media_doc`.`license_type` AS `license_type`, `media_doc`.`copyright` AS `copyright`, `media_doc`.`geoloc_latitude` AS `geoloc_latitude`, `media_doc`.`geoloc_longitude` AS `geoloc_longitude`, `media_doc`.`cropping` AS `cropping`, `media_doc`.`featured` AS `featured` FROM `media_doc` WHERE `id` = :where1

params: [where1] 3268;

13:00:36.444

[0.0003]

query: SELECT `guide_business`.`id` AS `id`, `guide_business`.`title` AS `title`, `guide_business`.`slug` AS `slug`, `guide_business`.`status` AS `status`, `guide_business`.`item_type` AS `item_type`, `guide_business`.`item_template` AS `item_template`, `guide_business`.`display_order` AS `display_order` FROM `guide_business` WHERE `id` = :where1

params: [where1] 1;

13:00:36.4452

[0.0011]

query: UPDATE `guide_item` SET `hits` = hits+ 1 WHERE `id` = :where1

params: [where1] 194;

13:00:36.4465

[0.0004]

query: UPDATE `guide_link` SET `hits` = hits+ 1 WHERE `id` = :where1

params: [where1] 194;

13:00:36.4476

[0.0019]

query: INSERT INTO `guide_statistics` (`module`, `entity`, `entity_id`, `action`, `time_create`, `ip`, `source`) VALUES (:module, :entity, :entity_id, :action, :time_create, :ip, :source)

params: [module] guide;[entity] item;[entity_id] 194;[action] hits;[time_create] 1652949036;[ip] 213.179.197.20;[source] web;

13:00:36.4498

[0.0005]

query: SELECT `guide_statistics`.* FROM `guide_statistics` WHERE `id` = :where1

params: [where1] 5343186;

13:00:36.4509

[0.0002]

query: SELECT `guide_owner`.`id` AS `id`, `guide_owner`.`uid` AS `uid`, `guide_owner`.`time_create` AS `time_create`, `guide_owner`.`status` AS `status`, `guide_owner`.`item_count` AS `item_count`, `guide_owner`.`order_inactive` AS `order_inactive`, `guide_owner`.`is_admin` AS `is_admin`, `guide_owner`.`sponsor_id` AS `sponsor_id`, `guide_owner`.`sponsor_by` AS `sponsor_by`, `guide_owner`.`sponsor_days` AS `sponsor_days` FROM `guide_owner` WHERE `id` = :where1

params: [where1] 3;

13:00:36.4533

[0.0003]

query: SELECT `core_user_account`.`identity` AS `identity`, `core_user_account`.`name` AS `name`, `core_user_account`.`email` AS `email`, `core_user_account`.`time_activated` AS `time_activated`, `core_user_account`.`id` AS `id` FROM `core_user_account` WHERE `id` IN (:where1)

params: [where1] 7;

13:00:36.4548

[0.0002]

query: SELECT `user_profile`.`first_name` AS `first_name`, `user_profile`.`last_name` AS `last_name`, `user_profile`.`phone` AS `phone`, `user_profile`.`mobile` AS `mobile`, `user_profile`.`credit` AS `credit`, `user_profile`.`address1` AS `address1`, `user_profile`.`address2` AS `address2`, `user_profile`.`country` AS `country`, `user_profile`.`state` AS `state`, `user_profile`.`city` AS `city`, `user_profile`.`zip_code` AS `zip_code`, `user_profile`.`company` AS `company`, `user_profile`.`company_id` AS `company_id`, `user_profile`.`company_vat` AS `company_vat`, `user_profile`.`uid` AS `uid` FROM `user_profile` WHERE `uid` IN (:where1)

params: [where1] 7;

13:00:36.4578

[0.0002]

query: SELECT `core_user_account`.`avatar` AS `avatar`, `core_user_account`.`id` AS `id` FROM `core_user_account` WHERE `id` IN (:where1)

params: [where1] 7;

13:00:36.4594

[0.0002]

query: SELECT `core_user_account`.`avatar` AS `avatar`, `core_user_account`.`id` AS `id` FROM `core_user_account` WHERE `id` IN (:where1)

params: [where1] 7;

13:00:36.4605

[0.0003]

query: SELECT `guide_field_position`.* FROM `guide_field_position` ORDER BY `order` ASC, `id` ASC

params:

13:00:36.4611

[0.0008]

query: SELECT `guide_field_data`.`field` AS `field`, `guide_field_data`.`data` AS `data` FROM `guide_field_data` WHERE `item` = :where1

params: [where1] 194;

13:00:36.4624

[0.0003]

query: SELECT `guide_field_business`.* FROM `guide_field_business` WHERE `business` = :where1

params: [where1] 1;

13:00:36.4639

[0.0003]

query: SELECT `guide_field`.`id` AS `id`, `guide_field`.`title` AS `title`, `guide_field`.`icon` AS `icon`, `guide_field`.`type` AS `type`, `guide_field`.`order` AS `order`, `guide_field`.`status` AS `status`, `guide_field`.`search` AS `search`, `guide_field`.`position` AS `position`, `guide_field`.`value` AS `value`, `guide_field`.`name` AS `name`, `guide_field`.`image` AS `image`, `guide_field`.`image_mobile` AS `image_mobile` FROM `guide_field` WHERE `status` = :where1 AND `id` IN (:where2, :where3, :where4, :where5, :where6, :where7, :where8, :where9, :where10, :where11, :where12, :where13, :where14, :where15, :where16, :where17, :where18, :where19, :where20, :where21, :where22, :where23, :where24, :where25, :where26, :where27, :where28, :where29, :where30, :where31, :where32, :where33, :where34, :where35, :where36, :where37, :where38, :where39, :where40, :where41, :where42, :where43, :where44, :where45, :where46, :where47, :where48, :where49, :where50, :where51, :where52, :where53, :where54) ORDER BY `order` ASC, `id` ASC

params: [where1] 1;[where2] 10;[where3] 2;[where4] 38;[where5] 47;[where6] 4;[where7] 52;[where8] 21;[where9] 28;[where10] 27;[where11] 26;[where12] 22;[where13] 53;[where14] 51;[where15] 45;[where16] 44;[where17] 42;[where18] 37;[where19] 33;[where20] 18;[where21] 17;[where22] 5;[where23] 6;[where24] 24;[where25] 23;[where26] 43;[where27] 3;[where28] 13;[where29] 39;[where30] 14;[where31] 41;[where32] 25;[where33] 15;[where34] 30;[where35] 8;[where36] 7;[where37] 32;[where38] 11;[where39] 36;[where40] 20;[where41] 31;[where42] 19;[where43] 12;[where44] 9;[where45] 29;[where46] 1;[where47] 34;[where48] 49;[where49] 48;[where50] 35;[where51] 40;[where52] 46;[where53] 55;[where54] 16;

13:00:36.4664

[0.0010]

query: SELECT `guide_attach`.`id` AS `id`, `guide_attach`.`title` AS `title`, `guide_attach`.`file` AS `file`, `guide_attach`.`path` AS `path`, `guide_attach`.`item` AS `item`, `guide_attach`.`time_create` AS `time_create`, `guide_attach`.`size` AS `size`, `guide_attach`.`type` AS `type`, `guide_attach`.`status` AS `status`, `guide_attach`.`hits` AS `hits`, `guide_attach`.`parent` AS `parent` FROM `guide_attach` WHERE `item` = :where1 AND `status` = :where2 AND `parent` = :where3 ORDER BY `time_create` ASC, `id` ASC

params: [where1] 194;[where2] 1;[where3] item;

13:00:36.4756

[0.0009]

query: SELECT `guide_item`.`id` AS `id`, `guide_item`.`title` AS `title`, `guide_item`.`title_long` AS `title_long`, `guide_item`.`type` AS `type`, `guide_item`.`slug` AS `slug`, `guide_item`.`category` AS `category`, `guide_item`.`business` AS `business`, `guide_item`.`item_type` AS `item_type`, `guide_item`.`status_type` AS `status_type`, `guide_item`.`text_summary` AS `text_summary`, `guide_item`.`text_description` AS `text_description`, `guide_item`.`seo_title` AS `seo_title`, `guide_item`.`seo_keywords` AS `seo_keywords`, `guide_item`.`seo_description` AS `seo_description`, `guide_item`.`status` AS `status`, `guide_item`.`time_create` AS `time_create`, `guide_item`.`time_update` AS `time_update`, `guide_item`.`time_start` AS `time_start`, `guide_item`.`time_end` AS `time_end`, `guide_item`.`uid` AS `uid`, `guide_item`.`owner` AS `owner`, `guide_item`.`package` AS `package`, `guide_item`.`hits` AS `hits`, `guide_item`.`image` AS `image`, `guide_item`.`image_wide` AS `image_wide`, `guide_item`.`path` AS `path`, `guide_item`.`main_image` AS `main_image`, `guide_item`.`additional_images` AS `additional_images`, `guide_item`.`vote` AS `vote`, `guide_item`.`rating` AS `rating`, `guide_item`.`favourite` AS `favourite`, `guide_item`.`checkin` AS `checkin`, `guide_item`.`service` AS `service`, `guide_item`.`attach` AS `attach`, `guide_item`.`attribute` AS `attribute`, `guide_item`.`review` AS `review`, `guide_item`.`recommended` AS `recommended`, `guide_item`.`map_longitude` AS `map_longitude`, `guide_item`.`map_latitude` AS `map_latitude`, `guide_item`.`map_title` AS `map_title`, `guide_item`.`map_final_longitude` AS `map_final_longitude`, `guide_item`.`map_final_latitude` AS `map_final_latitude`, `guide_item`.`map_final_title` AS `map_final_title`, `guide_item`.`itinerary` AS `itinerary`, `guide_item`.`map_zoom` AS `map_zoom`, `guide_item`.`location` AS `location`, `guide_item`.`location_level` AS `location_level`, `guide_item`.`address1` AS `address1`, `guide_item`.`address2` AS `address2`, `guide_item`.`city` AS `city`, `guide_item`.`area` AS `area`, `guide_item`.`zipcode` AS `zipcode`, `guide_item`.`phone1` AS `phone1`, `guide_item`.`website` AS `website`, `guide_item`.`email` AS `email`, `guide_item`.`difficulty` AS `difficulty`, `guide_item`.`duration` AS `duration`, `guide_item`.`elevation_start` AS `elevation_start`, `guide_item`.`elevation_end` AS `elevation_end`, `guide_item`.`loop_type` AS `loop_type`, `guide_item`.`access` AS `access`, `guide_item`.`distance` AS `distance`, `guide_item`.`map_number` AS `map_number`, `guide_item`.`related` AS `related`, `guide_item`.`map_type` AS `map_type`, `guide_item`.`booking` AS `booking`, `guide_item`.`hits_phone` AS `hits_phone`, `guide_item`.`ribbon` AS `ribbon`, `guide_item`.`incentive_calling` AS `incentive_calling`, `guide_item`.`foursquare_id` AS `foursquare_id` FROM `guide_item` WHERE `id` = :where1 AND `status` = :where2 LIMIT :limit

params: [where1] 317;[where2] 1;[limit] 8;

13:00:36.4788

[0.0003]

query: SELECT `media_doc`.`id` AS `id`, `media_doc`.`path` AS `path`, `media_doc`.`filename` AS `filename`, `media_doc`.`attributes` AS `attributes`, `media_doc`.`mimetype` AS `mimetype`, `media_doc`.`title` AS `title`, `media_doc`.`description` AS `description`, `media_doc`.`active` AS `active`, `media_doc`.`time_created` AS `time_created`, `media_doc`.`time_updated` AS `time_updated`, `media_doc`.`time_deleted` AS `time_deleted`, `media_doc`.`appkey` AS `appkey`, `media_doc`.`uid` AS `uid`, `media_doc`.`count` AS `count`, `media_doc`.`season` AS `season`, `media_doc`.`updated_by` AS `updated_by`, `media_doc`.`license_type` AS `license_type`, `media_doc`.`copyright` AS `copyright`, `media_doc`.`geoloc_latitude` AS `geoloc_latitude`, `media_doc`.`geoloc_longitude` AS `geoloc_longitude`, `media_doc`.`cropping` AS `cropping`, `media_doc`.`featured` AS `featured` FROM `media_doc` WHERE `id` = :where1

params: [where1] 3666;

13:00:36.4806

[0.0002]

query: SELECT `media_doc`.`id` AS `id`, `media_doc`.`path` AS `path`, `media_doc`.`filename` AS `filename`, `media_doc`.`attributes` AS `attributes`, `media_doc`.`mimetype` AS `mimetype`, `media_doc`.`title` AS `title`, `media_doc`.`description` AS `description`, `media_doc`.`active` AS `active`, `media_doc`.`time_created` AS `time_created`, `media_doc`.`time_updated` AS `time_updated`, `media_doc`.`time_deleted` AS `time_deleted`, `media_doc`.`appkey` AS `appkey`, `media_doc`.`uid` AS `uid`, `media_doc`.`count` AS `count`, `media_doc`.`season` AS `season`, `media_doc`.`updated_by` AS `updated_by`, `media_doc`.`license_type` AS `license_type`, `media_doc`.`copyright` AS `copyright`, `media_doc`.`geoloc_latitude` AS `geoloc_latitude`, `media_doc`.`geoloc_longitude` AS `geoloc_longitude`, `media_doc`.`cropping` AS `cropping`, `media_doc`.`featured` AS `featured` FROM `media_doc` WHERE `id` = :where1

params: [where1] 3666;

13:00:36.4828

[0.0002]

query: SELECT `guide_service_category`.* FROM `guide_service_category` WHERE `status` = :where1 AND `business` = :where2 ORDER BY `order` ASC, `id` ASC

params: [where1] 1;[where2] 1;

13:00:36.4842

[0.0007]

query: SELECT `guide_service`.`id` AS `id`, `guide_service`.`category` AS `category`, `guide_service`.`title` AS `title`, `guide_service`.`price` AS `price`, `guide_service`.`text_description` AS `text_description`, `guide_service`.`image` AS `image`, `guide_service`.`path` AS `path`, `guide_service`.`item` AS `item`, `guide_service`.`time_create` AS `time_create`, `guide_service`.`time_start` AS `time_start`, `guide_service`.`time_end` AS `time_end`, `guide_service`.`status` AS `status`, `guide_service`.`order` AS `order`, `guide_service`.`deal` AS `deal`, `guide_service`.`deal_price` AS `deal_price`, `guide_service`.`deal_description` AS `deal_description`, `guide_service`.`deal_time_start` AS `deal_time_start`, `guide_service`.`deal_time_end` AS `deal_time_end`, `guide_service`.`exclude_min_price` AS `exclude_min_price` FROM `guide_service` WHERE `item` = :where1 AND `status` = :where2 AND (`time_end` = :where3 OR `time_end` >= :where4) ORDER BY `order` ASC, `time_start` ASC, `price` ASC, `id` ASC

params: [where1] 194;[where2] 1;[where3] 0;[where4] 1652902200;

13:00:36.4855

[0.0002]

query: SELECT `guide_score`.* FROM `guide_score` WHERE `status` = :where1

params: [where1] 1;

13:00:36.4867

[0.0006]

query: SELECT count(DISTINCT `item`) AS `count` FROM `guide_checkin` WHERE `uid` = :where1 AND `item` = :where2

params: [where1] 0;[where2] 194;

13:00:36.4878

[0.0005]

query: SELECT `guide_checkin`.* FROM `guide_checkin` WHERE `item` = :where1 ORDER BY `id` DESC, `time_create` DESC

params: [where1] 194;

13:00:36.4895

[0.0014]

query: SELECT `core_user_account`.`identity` AS `identity`, `core_user_account`.`name` AS `name`, `core_user_account`.`email` AS `email`, `core_user_account`.`id` AS `id` FROM `core_user_account` WHERE `id` IN (:where1)

params: [where1] 3312;

13:00:36.492

[0.0004]

query: SELECT `core_user_account`.`avatar` AS `avatar`, `core_user_account`.`id` AS `id` FROM `core_user_account` WHERE `id` IN (:where1)

params: [where1] 3312;

13:00:36.4937

[0.0002]

query: SELECT `core_user_account`.`identity` AS `identity`, `core_user_account`.`name` AS `name`, `core_user_account`.`email` AS `email`, `core_user_account`.`id` AS `id` FROM `core_user_account` WHERE `id` IN (:where1)

params: [where1] 2624;

13:00:36.495

[0.0002]

query: SELECT `core_user_account`.`avatar` AS `avatar`, `core_user_account`.`id` AS `id` FROM `core_user_account` WHERE `id` IN (:where1)

params: [where1] 2624;

13:00:36.496

[0.0005]

query: SELECT `favourite_list`.* FROM `favourite_list` WHERE `uid` = :where1 AND `item` = :where2 AND `table` = :where3 AND `module` = :where4

params: [where1] 0;[where2] 194;[where3] item;[where4] guide;

13:00:36.4971

[0.0005]

query: SELECT `favourite_list`.* FROM `favourite_list` WHERE `item` = :where1 AND `table` = :where2 AND `module` = :where3 ORDER BY `id` DESC, `time_create` DESC

params: [where1] 194;[where2] item;[where3] guide;

13:00:36.4988

[0.0002]

query: SELECT `core_user_account`.`identity` AS `identity`, `core_user_account`.`name` AS `name`, `core_user_account`.`email` AS `email`, `core_user_account`.`id` AS `id` FROM `core_user_account` WHERE `id` IN (:where1)

params: [where1] 491;

13:00:36.5001

[0.0002]

query: SELECT `core_user_account`.`avatar` AS `avatar`, `core_user_account`.`id` AS `id` FROM `core_user_account` WHERE `id` IN (:where1)

params: [where1] 491;

13:00:36.5015

[0.0002]

query: SELECT `core_user_account`.`identity` AS `identity`, `core_user_account`.`name` AS `name`, `core_user_account`.`email` AS `email`, `core_user_account`.`id` AS `id` FROM `core_user_account` WHERE `id` IN (:where1)

params: [where1] 456;

13:00:36.5028

[0.0002]

query: SELECT `core_user_account`.`avatar` AS `avatar`, `core_user_account`.`id` AS `id` FROM `core_user_account` WHERE `id` IN (:where1)

params: [where1] 456;

13:00:36.5039

[0.0007]

query: SELECT `guide_review`.`id` AS `id`, `guide_review`.`uid` AS `uid`, `guide_review`.`item` AS `item`, `guide_review`.`title` AS `title`, `guide_review`.`text_description` AS `text_description`, `guide_review`.`image` AS `image`, `guide_review`.`path` AS `path`, `guide_review`.`time_create` AS `time_create`, `guide_review`.`time_visit` AS `time_visit`, `guide_review`.`status` AS `status`, `guide_review`.`point` AS `point`, `guide_review`.`count` AS `count`, `guide_review`.`admin_review` AS `admin_review` FROM `guide_review` WHERE `item` = :where1 AND `status` = :where2 ORDER BY `admin_review` DESC, `time_create` DESC, `id` DESC LIMIT :limit

params: [where1] 194;[where2] 1;[limit] 3;

13:00:36.506

[0.0011]

query: SELECT DISTINCT story AS `story` FROM `news_link` WHERE `status` = :where1 AND `type` = :where2 AND `module` = :where3 AND `controller` = :where4 AND `topic` = :where5 ORDER BY `time_publish` DESC, `id` DESC LIMIT :limit

params: [where1] 1;[where2] event;[where3] guide;[where4] item;[where5] 194;[limit] 4;

13:00:36.5079

[0.0011]

query: SELECT service.price AS `price`, `service`.`deal` AS `deal`, `service`.`deal_price` AS `deal_price`, `service`.`deal_time_start` AS `deal_time_start`, `service`.`deal_time_end` AS `deal_time_end`, `service`.`deal_description` AS `deal_description`, service.category AS `price_category`, `category`.`title` AS `title`, `item`.`id` AS `id` FROM `guide_service` AS `service` INNER JOIN `guide_service_category` AS `category` ON `category`.`id`=`service`.`category` INNER JOIN `guide_item` AS `item` ON `item`.`business`=`category`.`business` AND `service`.`item` = `item`.`id` WHERE category.main_service = 1 AND service.exclude_min_price = 0 AND (service.time_start = 0 OR service.time_start <= :where1) AND (service.time_end = 0 OR service.time_end >= :where2) AND `item`.`id` IN (:where3)

params: [where1] 1652902200;[where2] 1652902200;[where3] 194;

13:00:36.5119

[0.0002]

query: SELECT `package`.*, `package_period`.* FROM `guide_package` AS `package` INNER JOIN `guide_package_period` AS `package_period` ON `package`.`id` = `package_period`.`id_package` WHERE `package_period`.`id` = :where1

params: [where1] 1;

13:00:36.5212

[0.0003]

query: SELECT `guide_package_business`.* FROM `guide_package_business` WHERE `id_package` = :where1

params: [where1] 1;

13:00:36.5223

[0.0006]

query: SELECT `guide_discount`.`id` AS `id`, `guide_discount`.`item` AS `item`, `guide_discount`.`title` AS `title`, `guide_discount`.`text_summary` AS `text_summary`, `guide_discount`.`status` AS `status`, `guide_discount`.`uid` AS `uid`, `guide_discount`.`time_update` AS `time_update`, `guide_discount`.`sunday` AS `sunday`, `guide_discount`.`monday` AS `monday`, `guide_discount`.`tuesday` AS `tuesday`, `guide_discount`.`wednesday` AS `wednesday`, `guide_discount`.`thursday` AS `thursday`, `guide_discount`.`friday` AS `friday`, `guide_discount`.`saturday` AS `saturday`, `guide_discount`.`hour_start` AS `hour_start`, `guide_discount`.`hour_end` AS `hour_end`, `guide_discount`.`percent` AS `percent` FROM `guide_discount` WHERE `status` = :where1 AND `item` = :where2 ORDER BY `time_update` DESC, `id` DESC

params: [where1] 1;[where2] 194;

13:00:36.5281

[0.0003]

query: SELECT `media_doc`.`id` AS `id`, `media_doc`.`path` AS `path`, `media_doc`.`filename` AS `filename`, `media_doc`.`attributes` AS `attributes`, `media_doc`.`mimetype` AS `mimetype`, `media_doc`.`title` AS `title`, `media_doc`.`description` AS `description`, `media_doc`.`active` AS `active`, `media_doc`.`time_created` AS `time_created`, `media_doc`.`time_updated` AS `time_updated`, `media_doc`.`time_deleted` AS `time_deleted`, `media_doc`.`appkey` AS `appkey`, `media_doc`.`uid` AS `uid`, `media_doc`.`count` AS `count`, `media_doc`.`season` AS `season`, `media_doc`.`updated_by` AS `updated_by`, `media_doc`.`license_type` AS `license_type`, `media_doc`.`copyright` AS `copyright`, `media_doc`.`geoloc_latitude` AS `geoloc_latitude`, `media_doc`.`geoloc_longitude` AS `geoloc_longitude`, `media_doc`.`cropping` AS `cropping`, `media_doc`.`featured` AS `featured` FROM `media_doc` WHERE `id` = :where1

params: [where1] 3268;

13:00:36.5371

[0.0003]

query: SELECT `media_doc`.`id` AS `id`, `media_doc`.`path` AS `path`, `media_doc`.`filename` AS `filename`, `media_doc`.`attributes` AS `attributes`, `media_doc`.`mimetype` AS `mimetype`, `media_doc`.`title` AS `title`, `media_doc`.`description` AS `description`, `media_doc`.`active` AS `active`, `media_doc`.`time_created` AS `time_created`, `media_doc`.`time_updated` AS `time_updated`, `media_doc`.`time_deleted` AS `time_deleted`, `media_doc`.`appkey` AS `appkey`, `media_doc`.`uid` AS `uid`, `media_doc`.`count` AS `count`, `media_doc`.`season` AS `season`, `media_doc`.`updated_by` AS `updated_by`, `media_doc`.`license_type` AS `license_type`, `media_doc`.`copyright` AS `copyright`, `media_doc`.`geoloc_latitude` AS `geoloc_latitude`, `media_doc`.`geoloc_longitude` AS `geoloc_longitude`, `media_doc`.`cropping` AS `cropping`, `media_doc`.`featured` AS `featured` FROM `media_doc` WHERE `id` = :where1

params: [where1] 3268;

13:00:36.5397

[0.0003]

query: SELECT `media_doc`.`id` AS `id`, `media_doc`.`path` AS `path`, `media_doc`.`filename` AS `filename`, `media_doc`.`attributes` AS `attributes`, `media_doc`.`mimetype` AS `mimetype`, `media_doc`.`title` AS `title`, `media_doc`.`description` AS `description`, `media_doc`.`active` AS `active`, `media_doc`.`time_created` AS `time_created`, `media_doc`.`time_updated` AS `time_updated`, `media_doc`.`time_deleted` AS `time_deleted`, `media_doc`.`appkey` AS `appkey`, `media_doc`.`uid` AS `uid`, `media_doc`.`count` AS `count`, `media_doc`.`season` AS `season`, `media_doc`.`updated_by` AS `updated_by`, `media_doc`.`license_type` AS `license_type`, `media_doc`.`copyright` AS `copyright`, `media_doc`.`geoloc_latitude` AS `geoloc_latitude`, `media_doc`.`geoloc_longitude` AS `geoloc_longitude`, `media_doc`.`cropping` AS `cropping`, `media_doc`.`featured` AS `featured` FROM `media_doc` WHERE `id` = :where1

params: [where1] 3268;

13:00:36.5432

[0.0011]

query: SELECT `media_doc`.`id` AS `id`, `media_doc`.`path` AS `path`, `media_doc`.`filename` AS `filename`, `media_doc`.`attributes` AS `attributes`, `media_doc`.`mimetype` AS `mimetype`, `media_doc`.`title` AS `title`, `media_doc`.`description` AS `description`, `media_doc`.`active` AS `active`, `media_doc`.`time_created` AS `time_created`, `media_doc`.`time_updated` AS `time_updated`, `media_doc`.`time_deleted` AS `time_deleted`, `media_doc`.`appkey` AS `appkey`, `media_doc`.`uid` AS `uid`, `media_doc`.`count` AS `count`, `media_doc`.`season` AS `season`, `media_doc`.`updated_by` AS `updated_by`, `media_doc`.`license_type` AS `license_type`, `media_doc`.`copyright` AS `copyright`, `media_doc`.`geoloc_latitude` AS `geoloc_latitude`, `media_doc`.`geoloc_longitude` AS `geoloc_longitude`, `media_doc`.`cropping` AS `cropping`, `media_doc`.`featured` AS `featured` FROM `media_doc` WHERE `id` IN (:where1, :where2, :where3, :where4, :where5, :where6, :where7, :where8, :where9, :where10, :where11, :where12, :where13, :where14, :where15, :where16, :where17, :where18, :where19, :where20, :where21) ORDER BY FIELD (season, 4,1,3,2)

params: [where1] 3269;[where2] 3270;[where3] 3271;[where4] 3272;[where5] 3273;[where6] 3274;[where7] 3275;[where8] 3276;[where9] 3277;[where10] 3278;[where11] 3279;[where12] 3280;[where13] 3281;[where14] 3282;[where15] 3283;[where16] 3284;[where17] 3285;[where18] 3286;[where19] 3287;[where20] 3288;[where21] 3289;

13:00:36.6457

[0.0013]

query: SELECT `guide_item`.`id` AS `id`, `guide_item`.`title` AS `title`, `guide_item`.`title_long` AS `title_long`, `guide_item`.`type` AS `type`, `guide_item`.`slug` AS `slug`, `guide_item`.`category` AS `category`, `guide_item`.`business` AS `business`, `guide_item`.`item_type` AS `item_type`, `guide_item`.`status_type` AS `status_type`, `guide_item`.`text_summary` AS `text_summary`, `guide_item`.`text_description` AS `text_description`, `guide_item`.`seo_title` AS `seo_title`, `guide_item`.`seo_keywords` AS `seo_keywords`, `guide_item`.`seo_description` AS `seo_description`, `guide_item`.`status` AS `status`, `guide_item`.`time_create` AS `time_create`, `guide_item`.`time_update` AS `time_update`, `guide_item`.`time_start` AS `time_start`, `guide_item`.`time_end` AS `time_end`, `guide_item`.`uid` AS `uid`, `guide_item`.`owner` AS `owner`, `guide_item`.`package` AS `package`, `guide_item`.`hits` AS `hits`, `guide_item`.`image` AS `image`, `guide_item`.`image_wide` AS `image_wide`, `guide_item`.`path` AS `path`, `guide_item`.`main_image` AS `main_image`, `guide_item`.`additional_images` AS `additional_images`, `guide_item`.`vote` AS `vote`, `guide_item`.`rating` AS `rating`, `guide_item`.`favourite` AS `favourite`, `guide_item`.`checkin` AS `checkin`, `guide_item`.`service` AS `service`, `guide_item`.`attach` AS `attach`, `guide_item`.`attribute` AS `attribute`, `guide_item`.`review` AS `review`, `guide_item`.`recommended` AS `recommended`, `guide_item`.`map_longitude` AS `map_longitude`, `guide_item`.`map_latitude` AS `map_latitude`, `guide_item`.`map_title` AS `map_title`, `guide_item`.`map_final_longitude` AS `map_final_longitude`, `guide_item`.`map_final_latitude` AS `map_final_latitude`, `guide_item`.`map_final_title` AS `map_final_title`, `guide_item`.`itinerary` AS `itinerary`, `guide_item`.`map_zoom` AS `map_zoom`, `guide_item`.`location` AS `location`, `guide_item`.`location_level` AS `location_level`, `guide_item`.`address1` AS `address1`, `guide_item`.`address2` AS `address2`, `guide_item`.`city` AS `city`, `guide_item`.`area` AS `area`, `guide_item`.`zipcode` AS `zipcode`, `guide_item`.`phone1` AS `phone1`, `guide_item`.`website` AS `website`, `guide_item`.`email` AS `email`, `guide_item`.`difficulty` AS `difficulty`, `guide_item`.`duration` AS `duration`, `guide_item`.`elevation_start` AS `elevation_start`, `guide_item`.`elevation_end` AS `elevation_end`, `guide_item`.`loop_type` AS `loop_type`, `guide_item`.`access` AS `access`, `guide_item`.`distance` AS `distance`, `guide_item`.`map_number` AS `map_number`, `guide_item`.`related` AS `related`, `guide_item`.`map_type` AS `map_type`, `guide_item`.`booking` AS `booking`, `guide_item`.`hits_phone` AS `hits_phone`, `guide_item`.`ribbon` AS `ribbon`, `guide_item`.`incentive_calling` AS `incentive_calling`, `guide_item`.`foursquare_id` AS `foursquare_id` FROM `guide_item` WHERE `slug` = :where1

params: [where1] cafe-diamond;

13:00:36.6493

[0.0003]

query: SELECT `media_doc`.`id` AS `id`, `media_doc`.`path` AS `path`, `media_doc`.`filename` AS `filename`, `media_doc`.`attributes` AS `attributes`, `media_doc`.`mimetype` AS `mimetype`, `media_doc`.`title` AS `title`, `media_doc`.`description` AS `description`, `media_doc`.`active` AS `active`, `media_doc`.`time_created` AS `time_created`, `media_doc`.`time_updated` AS `time_updated`, `media_doc`.`time_deleted` AS `time_deleted`, `media_doc`.`appkey` AS `appkey`, `media_doc`.`uid` AS `uid`, `media_doc`.`count` AS `count`, `media_doc`.`season` AS `season`, `media_doc`.`updated_by` AS `updated_by`, `media_doc`.`license_type` AS `license_type`, `media_doc`.`copyright` AS `copyright`, `media_doc`.`geoloc_latitude` AS `geoloc_latitude`, `media_doc`.`geoloc_longitude` AS `geoloc_longitude`, `media_doc`.`cropping` AS `cropping`, `media_doc`.`featured` AS `featured` FROM `media_doc` WHERE `id` = :where1

params: [where1] 3268;

13:00:36.651

[0.0002]

query: SELECT `media_doc`.`id` AS `id`, `media_doc`.`path` AS `path`, `media_doc`.`filename` AS `filename`, `media_doc`.`attributes` AS `attributes`, `media_doc`.`mimetype` AS `mimetype`, `media_doc`.`title` AS `title`, `media_doc`.`description` AS `description`, `media_doc`.`active` AS `active`, `media_doc`.`time_created` AS `time_created`, `media_doc`.`time_updated` AS `time_updated`, `media_doc`.`time_deleted` AS `time_deleted`, `media_doc`.`appkey` AS `appkey`, `media_doc`.`uid` AS `uid`, `media_doc`.`count` AS `count`, `media_doc`.`season` AS `season`, `media_doc`.`updated_by` AS `updated_by`, `media_doc`.`license_type` AS `license_type`, `media_doc`.`copyright` AS `copyright`, `media_doc`.`geoloc_latitude` AS `geoloc_latitude`, `media_doc`.`geoloc_longitude` AS `geoloc_longitude`, `media_doc`.`cropping` AS `cropping`, `media_doc`.`featured` AS `featured` FROM `media_doc` WHERE `id` = :where1

params: [where1] 3268;

13:00:36.653

[0.0007]

query: SELECT `guide_location`.`id` AS `id`, `guide_location`.`level` AS `level`, `guide_location`.`parent` AS `parent`, `guide_location`.`title` AS `title`, `guide_location`.`title_long` AS `title_long`, `guide_location`.`slug` AS `slug`, `guide_location`.`image` AS `image`, `guide_location`.`image_wide` AS `image_wide`, `guide_location`.`path` AS `path`, `guide_location`.`main_image` AS `main_image`, `guide_location`.`additional_images` AS `additional_images`, `guide_location`.`text_summary` AS `text_summary`, `guide_location`.`text_description` AS `text_description`, `guide_location`.`seo_title` AS `seo_title`, `guide_location`.`seo_keywords` AS `seo_keywords`, `guide_location`.`seo_description` AS `seo_description`, `guide_location`.`status` AS `status`, `guide_location`.`time_create` AS `time_create`, `guide_location`.`time_update` AS `time_update`, `guide_location`.`map_longitude` AS `map_longitude`, `guide_location`.`map_latitude` AS `map_latitude`, `guide_location`.`map_zoom` AS `map_zoom`, `guide_location`.`population` AS `population`, `guide_location`.`surface` AS `surface`, `guide_location`.`altitude` AS `altitude`, `guide_location`.`zipcode` AS `zipcode`, `guide_location`.`website_city` AS `website_city`, `guide_location`.`website_tourist` AS `website_tourist`, `guide_location`.`display_information` AS `display_information`, `guide_location`.`attach` AS `attach`, `guide_location`.`map_type` AS `map_type`, `guide_location`.`setting` AS `setting` FROM `guide_location` WHERE `id` = :where1

params: [where1] 317;

13:00:36.6554

[0.0002]

query: SELECT `guide_location`.`id` AS `id`, `guide_location`.`level` AS `level`, `guide_location`.`parent` AS `parent`, `guide_location`.`title` AS `title`, `guide_location`.`title_long` AS `title_long`, `guide_location`.`slug` AS `slug`, `guide_location`.`image` AS `image`, `guide_location`.`image_wide` AS `image_wide`, `guide_location`.`path` AS `path`, `guide_location`.`main_image` AS `main_image`, `guide_location`.`additional_images` AS `additional_images`, `guide_location`.`text_summary` AS `text_summary`, `guide_location`.`text_description` AS `text_description`, `guide_location`.`seo_title` AS `seo_title`, `guide_location`.`seo_keywords` AS `seo_keywords`, `guide_location`.`seo_description` AS `seo_description`, `guide_location`.`status` AS `status`, `guide_location`.`time_create` AS `time_create`, `guide_location`.`time_update` AS `time_update`, `guide_location`.`map_longitude` AS `map_longitude`, `guide_location`.`map_latitude` AS `map_latitude`, `guide_location`.`map_zoom` AS `map_zoom`, `guide_location`.`population` AS `population`, `guide_location`.`surface` AS `surface`, `guide_location`.`altitude` AS `altitude`, `guide_location`.`zipcode` AS `zipcode`, `guide_location`.`website_city` AS `website_city`, `guide_location`.`website_tourist` AS `website_tourist`, `guide_location`.`display_information` AS `display_information`, `guide_location`.`attach` AS `attach`, `guide_location`.`map_type` AS `map_type`, `guide_location`.`setting` AS `setting` FROM `guide_location` WHERE `id` = :where1

params: [where1] 5;

13:00:36.6572

[0.0002]

query: SELECT `guide_location`.`id` AS `id`, `guide_location`.`level` AS `level`, `guide_location`.`parent` AS `parent`, `guide_location`.`title` AS `title`, `guide_location`.`title_long` AS `title_long`, `guide_location`.`slug` AS `slug`, `guide_location`.`image` AS `image`, `guide_location`.`image_wide` AS `image_wide`, `guide_location`.`path` AS `path`, `guide_location`.`main_image` AS `main_image`, `guide_location`.`additional_images` AS `additional_images`, `guide_location`.`text_summary` AS `text_summary`, `guide_location`.`text_description` AS `text_description`, `guide_location`.`seo_title` AS `seo_title`, `guide_location`.`seo_keywords` AS `seo_keywords`, `guide_location`.`seo_description` AS `seo_description`, `guide_location`.`status` AS `status`, `guide_location`.`time_create` AS `time_create`, `guide_location`.`time_update` AS `time_update`, `guide_location`.`map_longitude` AS `map_longitude`, `guide_location`.`map_latitude` AS `map_latitude`, `guide_location`.`map_zoom` AS `map_zoom`, `guide_location`.`population` AS `population`, `guide_location`.`surface` AS `surface`, `guide_location`.`altitude` AS `altitude`, `guide_location`.`zipcode` AS `zipcode`, `guide_location`.`website_city` AS `website_city`, `guide_location`.`website_tourist` AS `website_tourist`, `guide_location`.`display_information` AS `display_information`, `guide_location`.`attach` AS `attach`, `guide_location`.`map_type` AS `map_type`, `guide_location`.`setting` AS `setting` FROM `guide_location` WHERE `id` = :where1

params: [where1] 3;

13:00:36.659

[0.0002]

query: SELECT `guide_location`.`id` AS `id`, `guide_location`.`level` AS `level`, `guide_location`.`parent` AS `parent`, `guide_location`.`title` AS `title`, `guide_location`.`title_long` AS `title_long`, `guide_location`.`slug` AS `slug`, `guide_location`.`image` AS `image`, `guide_location`.`image_wide` AS `image_wide`, `guide_location`.`path` AS `path`, `guide_location`.`main_image` AS `main_image`, `guide_location`.`additional_images` AS `additional_images`, `guide_location`.`text_summary` AS `text_summary`, `guide_location`.`text_description` AS `text_description`, `guide_location`.`seo_title` AS `seo_title`, `guide_location`.`seo_keywords` AS `seo_keywords`, `guide_location`.`seo_description` AS `seo_description`, `guide_location`.`status` AS `status`, `guide_location`.`time_create` AS `time_create`, `guide_location`.`time_update` AS `time_update`, `guide_location`.`map_longitude` AS `map_longitude`, `guide_location`.`map_latitude` AS `map_latitude`, `guide_location`.`map_zoom` AS `map_zoom`, `guide_location`.`population` AS `population`, `guide_location`.`surface` AS `surface`, `guide_location`.`altitude` AS `altitude`, `guide_location`.`zipcode` AS `zipcode`, `guide_location`.`website_city` AS `website_city`, `guide_location`.`website_tourist` AS `website_tourist`, `guide_location`.`display_information` AS `display_information`, `guide_location`.`attach` AS `attach`, `guide_location`.`map_type` AS `map_type`, `guide_location`.`setting` AS `setting` FROM `guide_location` WHERE `id` = :where1

params: [where1] 2;

13:00:36.6608

[0.0003]

query: SELECT `guide_location`.`id` AS `id`, `guide_location`.`level` AS `level`, `guide_location`.`parent` AS `parent`, `guide_location`.`title` AS `title`, `guide_location`.`title_long` AS `title_long`, `guide_location`.`slug` AS `slug`, `guide_location`.`image` AS `image`, `guide_location`.`image_wide` AS `image_wide`, `guide_location`.`path` AS `path`, `guide_location`.`main_image` AS `main_image`, `guide_location`.`additional_images` AS `additional_images`, `guide_location`.`text_summary` AS `text_summary`, `guide_location`.`text_description` AS `text_description`, `guide_location`.`seo_title` AS `seo_title`, `guide_location`.`seo_keywords` AS `seo_keywords`, `guide_location`.`seo_description` AS `seo_description`, `guide_location`.`status` AS `status`, `guide_location`.`time_create` AS `time_create`, `guide_location`.`time_update` AS `time_update`, `guide_location`.`map_longitude` AS `map_longitude`, `guide_location`.`map_latitude` AS `map_latitude`, `guide_location`.`map_zoom` AS `map_zoom`, `guide_location`.`population` AS `population`, `guide_location`.`surface` AS `surface`, `guide_location`.`altitude` AS `altitude`, `guide_location`.`zipcode` AS `zipcode`, `guide_location`.`website_city` AS `website_city`, `guide_location`.`website_tourist` AS `website_tourist`, `guide_location`.`display_information` AS `display_information`, `guide_location`.`attach` AS `attach`, `guide_location`.`map_type` AS `map_type`, `guide_location`.`setting` AS `setting` FROM `guide_location` WHERE `id` = :where1

params: [where1] 1;

13:00:36.6633

[0.0002]

query: SELECT `core_block`.`id` AS `id`, `core_block`.`root` AS `root`, `core_block`.`name` AS `name`, `core_block`.`title` AS `title`, `core_block`.`description` AS `description`, `core_block`.`module` AS `module`, `core_block`.`template` AS `template`, `core_block`.`render` AS `render`, `core_block`.`config` AS `config`, `core_block`.`type` AS `type`, `core_block`.`content` AS `content`, `core_block`.`cache_ttl` AS `cache_ttl`, `core_block`.`cache_level` AS `cache_level`, `core_block`.`title_hidden` AS `title_hidden`, `core_block`.`body_fullsize` AS `body_fullsize`, `core_block`.`active` AS `active`, `core_block`.`cloned` AS `cloned`, `core_block`.`class` AS `class`, `core_block`.`subline` AS `subline` FROM `core_block` WHERE `name` = :where1

params: [where1] system-user-bar;

13:00:36.6662

[0.0003]

query: SELECT `core_block`.`id` AS `id`, `core_block`.`root` AS `root`, `core_block`.`name` AS `name`, `core_block`.`title` AS `title`, `core_block`.`description` AS `description`, `core_block`.`module` AS `module`, `core_block`.`template` AS `template`, `core_block`.`render` AS `render`, `core_block`.`config` AS `config`, `core_block`.`type` AS `type`, `core_block`.`content` AS `content`, `core_block`.`cache_ttl` AS `cache_ttl`, `core_block`.`cache_level` AS `cache_level`, `core_block`.`title_hidden` AS `title_hidden`, `core_block`.`body_fullsize` AS `body_fullsize`, `core_block`.`active` AS `active`, `core_block`.`cloned` AS `cloned`, `core_block`.`class` AS `class`, `core_block`.`subline` AS `subline` FROM `core_block` WHERE `name` = :where1

params: [where1] search-search;

13:00:36.6729

[0.0004]

query: SELECT `guide_item`.`id` AS `id`, `guide_item`.`title` AS `title`, `guide_item`.`title_long` AS `title_long`, `guide_item`.`type` AS `type`, `guide_item`.`slug` AS `slug`, `guide_item`.`category` AS `category`, `guide_item`.`business` AS `business`, `guide_item`.`item_type` AS `item_type`, `guide_item`.`status_type` AS `status_type`, `guide_item`.`text_summary` AS `text_summary`, `guide_item`.`text_description` AS `text_description`, `guide_item`.`seo_title` AS `seo_title`, `guide_item`.`seo_keywords` AS `seo_keywords`, `guide_item`.`seo_description` AS `seo_description`, `guide_item`.`status` AS `status`, `guide_item`.`time_create` AS `time_create`, `guide_item`.`time_update` AS `time_update`, `guide_item`.`time_start` AS `time_start`, `guide_item`.`time_end` AS `time_end`, `guide_item`.`uid` AS `uid`, `guide_item`.`owner` AS `owner`, `guide_item`.`package` AS `package`, `guide_item`.`hits` AS `hits`, `guide_item`.`image` AS `image`, `guide_item`.`image_wide` AS `image_wide`, `guide_item`.`path` AS `path`, `guide_item`.`main_image` AS `main_image`, `guide_item`.`additional_images` AS `additional_images`, `guide_item`.`vote` AS `vote`, `guide_item`.`rating` AS `rating`, `guide_item`.`favourite` AS `favourite`, `guide_item`.`checkin` AS `checkin`, `guide_item`.`service` AS `service`, `guide_item`.`attach` AS `attach`, `guide_item`.`attribute` AS `attribute`, `guide_item`.`review` AS `review`, `guide_item`.`recommended` AS `recommended`, `guide_item`.`map_longitude` AS `map_longitude`, `guide_item`.`map_latitude` AS `map_latitude`, `guide_item`.`map_title` AS `map_title`, `guide_item`.`map_final_longitude` AS `map_final_longitude`, `guide_item`.`map_final_latitude` AS `map_final_latitude`, `guide_item`.`map_final_title` AS `map_final_title`, `guide_item`.`itinerary` AS `itinerary`, `guide_item`.`map_zoom` AS `map_zoom`, `guide_item`.`location` AS `location`, `guide_item`.`location_level` AS `location_level`, `guide_item`.`address1` AS `address1`, `guide_item`.`address2` AS `address2`, `guide_item`.`city` AS `city`, `guide_item`.`area` AS `area`, `guide_item`.`zipcode` AS `zipcode`, `guide_item`.`phone1` AS `phone1`, `guide_item`.`website` AS `website`, `guide_item`.`email` AS `email`, `guide_item`.`difficulty` AS `difficulty`, `guide_item`.`duration` AS `duration`, `guide_item`.`elevation_start` AS `elevation_start`, `guide_item`.`elevation_end` AS `elevation_end`, `guide_item`.`loop_type` AS `loop_type`, `guide_item`.`access` AS `access`, `guide_item`.`distance` AS `distance`, `guide_item`.`map_number` AS `map_number`, `guide_item`.`related` AS `related`, `guide_item`.`map_type` AS `map_type`, `guide_item`.`booking` AS `booking`, `guide_item`.`hits_phone` AS `hits_phone`, `guide_item`.`ribbon` AS `ribbon`, `guide_item`.`incentive_calling` AS `incentive_calling`, `guide_item`.`foursquare_id` AS `foursquare_id` FROM `guide_item` WHERE `slug` = :where1

params: [where1] cafe-diamond;

13:00:36.6841

[0.0003]

query: SELECT `media_doc`.`id` AS `id`, `media_doc`.`path` AS `path`, `media_doc`.`filename` AS `filename`, `media_doc`.`attributes` AS `attributes`, `media_doc`.`mimetype` AS `mimetype`, `media_doc`.`title` AS `title`, `media_doc`.`description` AS `description`, `media_doc`.`active` AS `active`, `media_doc`.`time_created` AS `time_created`, `media_doc`.`time_updated` AS `time_updated`, `media_doc`.`time_deleted` AS `time_deleted`, `media_doc`.`appkey` AS `appkey`, `media_doc`.`uid` AS `uid`, `media_doc`.`count` AS `count`, `media_doc`.`season` AS `season`, `media_doc`.`updated_by` AS `updated_by`, `media_doc`.`license_type` AS `license_type`, `media_doc`.`copyright` AS `copyright`, `media_doc`.`geoloc_latitude` AS `geoloc_latitude`, `media_doc`.`geoloc_longitude` AS `geoloc_longitude`, `media_doc`.`cropping` AS `cropping`, `media_doc`.`featured` AS `featured` FROM `media_doc` WHERE `id` = :where1

params: [where1] 3268;

13:00:36.6859

[0.0002]

query: SELECT `media_doc`.`id` AS `id`, `media_doc`.`path` AS `path`, `media_doc`.`filename` AS `filename`, `media_doc`.`attributes` AS `attributes`, `media_doc`.`mimetype` AS `mimetype`, `media_doc`.`title` AS `title`, `media_doc`.`description` AS `description`, `media_doc`.`active` AS `active`, `media_doc`.`time_created` AS `time_created`, `media_doc`.`time_updated` AS `time_updated`, `media_doc`.`time_deleted` AS `time_deleted`, `media_doc`.`appkey` AS `appkey`, `media_doc`.`uid` AS `uid`, `media_doc`.`count` AS `count`, `media_doc`.`season` AS `season`, `media_doc`.`updated_by` AS `updated_by`, `media_doc`.`license_type` AS `license_type`, `media_doc`.`copyright` AS `copyright`, `media_doc`.`geoloc_latitude` AS `geoloc_latitude`, `media_doc`.`geoloc_longitude` AS `geoloc_longitude`, `media_doc`.`cropping` AS `cropping`, `media_doc`.`featured` AS `featured` FROM `media_doc` WHERE `id` = :where1

params: [where1] 3268;

13:00:36.6875

[0.0002]

query: SELECT `media_doc`.`id` AS `id`, `media_doc`.`path` AS `path`, `media_doc`.`filename` AS `filename`, `media_doc`.`attributes` AS `attributes`, `media_doc`.`mimetype` AS `mimetype`, `media_doc`.`title` AS `title`, `media_doc`.`description` AS `description`, `media_doc`.`active` AS `active`, `media_doc`.`time_created` AS `time_created`, `media_doc`.`time_updated` AS `time_updated`, `media_doc`.`time_deleted` AS `time_deleted`, `media_doc`.`appkey` AS `appkey`, `media_doc`.`uid` AS `uid`, `media_doc`.`count` AS `count`, `media_doc`.`season` AS `season`, `media_doc`.`updated_by` AS `updated_by`, `media_doc`.`license_type` AS `license_type`, `media_doc`.`copyright` AS `copyright`, `media_doc`.`geoloc_latitude` AS `geoloc_latitude`, `media_doc`.`geoloc_longitude` AS `geoloc_longitude`, `media_doc`.`cropping` AS `cropping`, `media_doc`.`featured` AS `featured` FROM `media_doc` WHERE `id` = :where1

params: [where1] 3268;

13:00:36.6891

[0.0002]

query: SELECT `media_doc`.`id` AS `id`, `media_doc`.`path` AS `path`, `media_doc`.`filename` AS `filename`, `media_doc`.`attributes` AS `attributes`, `media_doc`.`mimetype` AS `mimetype`, `media_doc`.`title` AS `title`, `media_doc`.`description` AS `description`, `media_doc`.`active` AS `active`, `media_doc`.`time_created` AS `time_created`, `media_doc`.`time_updated` AS `time_updated`, `media_doc`.`time_deleted` AS `time_deleted`, `media_doc`.`appkey` AS `appkey`, `media_doc`.`uid` AS `uid`, `media_doc`.`count` AS `count`, `media_doc`.`season` AS `season`, `media_doc`.`updated_by` AS `updated_by`, `media_doc`.`license_type` AS `license_type`, `media_doc`.`copyright` AS `copyright`, `media_doc`.`geoloc_latitude` AS `geoloc_latitude`, `media_doc`.`geoloc_longitude` AS `geoloc_longitude`, `media_doc`.`cropping` AS `cropping`, `media_doc`.`featured` AS `featured` FROM `media_doc` WHERE `id` = :where1

params: [where1] 3268;

13:00:36.6919

[0.0006]

query: SELECT `comment_root`.* FROM `comment_root` WHERE `module` = :where1 AND `type` = :where2 AND `item` = :where3

params: [where1] guide;[where2] guide;[where3] 194;

13:00:36.6929

[0.0002]

query: SELECT `core_permission_rule`.* FROM `core_permission_rule` WHERE `resource` = :where1 AND `section` = :where2 AND `role` IN (:where3) LIMIT :limit

params: [where1] module-admin;[where2] front;[where3] guest;[limit] 1;

13:00:36.7135

[0.0003]

query: SELECT `core_session`.* FROM `core_session` WHERE `id` = :where1

params: [where1] dqtilosrru6nom7tpmlbf4css0;

13:00:36.7141

[0.0007]

query: INSERT INTO `core_session` (`modified`, `data`, `id`, `lifetime`) VALUES (:modified, :data, :id, :lifetime)

params: [modified] 1652949036;[data] __ZF|a:2:{s:20:"_REQUEST_ACCESS_TIME";d:1652949036.39426898956298828125;s:6:"_VALID";a:1:{s:36:"Zend\Session\Validator\HttpUserAgent";s:40:"CCBot/2.0 (https://commoncrawl.org/faq/)";}}PI_USER|a:2:{s:5:"field";a:3:{s:2:"id";i:0;s:8:"identity";s:0:"";s:4:"name";s:10:"مهمان";}s:4:"time";i:1652949336;}hits|a:1:{i:194;b:1;}FlashMessenger|C:23:"Zend\Stdlib\ArrayObject":205:{a:4:{s:7:"storage";a:0:{}s:4:"flag";i:2;s:13:"iteratorClass";s:13:"ArrayIterator";s:19:"protectedProperties";a:4:{i:0;s:7:"storage";i:1;s:4:"flag";i:2;s:13:"iteratorClass";i:3;s:19:"protectedProperties";}}};[id] dqtilosrru6nom7tpmlbf4css0;[lifetime] 1440;

کافه یاب

کافه دیاموند

اطلاعات مکان

نقشه

ساعت کار

امکانات و اطلاعات

نحوه دسترسی

رویداد های مرتبط

مکان های نزدیک برای بازدید

کافه روژ

همه نظرها (۰)

نرم افزار تلفن همراه کافه یاب

کافه

کافی‌شاپ

شیرینی فروشی

قهوه فروشی