https://eventos.keoscx.com/ar/venue/hotel-aimarawa-san-antero-golfo-de-morrosquill

Query Metrics

52 Database Queries
16 Different statements
4.33 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.49 ms
(34.35%)
19
SELECT t0.label AS label_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.id AS id_4, t0.translatable_id AS translatable_id_5 FROM eventic_menu_element_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
0.67 ms
(15.39%)
8
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.id AS id_4, t0.translatable_id AS translatable_id_5 FROM eventic_category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  19
]
0.50 ms
(11.50%)
7
SELECT e0_.id AS id_0 FROM eventic_menu e0_ INNER JOIN eventic_menu_translation e1_ ON e0_.id = e1_.translatable_id WHERE e1_.slug = ?
Parameters:
[
  "header-menu"
]
0.31 ms
(7.16%)
4
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.link AS link_3, t0.custom_link AS custom_link_4, t0.position AS position_5, t0.menu_id AS menu_id_6 FROM eventic_menu_element t0 WHERE t0.menu_id = ? ORDER BY t0.position ASC
Parameters:
[
  1
]
0.23 ms
(5.20%)
3
SELECT t0.name AS name_1, t0.header AS header_2, t0.slug AS slug_3, t0.locale AS locale_4, t0.id AS id_5, t0.translatable_id AS translatable_id_6 FROM eventic_menu_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  2
]
0.22 ms
(5.12%)
1
SELECT e0_.id AS id_0, e0_.seatedguests AS seatedguests_1, e0_.standingguests AS standingguests_2, e0_.neighborhoods AS neighborhoods_3, e0_.foodbeverage AS foodbeverage_4, e0_.pricing AS pricing_5, e0_.availibility AS availibility_6, e0_.hidden AS hidden_7, e0_.showmap AS showmap_8, e0_.quoteform AS quoteform_9, e0_.street AS street_10, e0_.street2 AS street2_11, e0_.city AS city_12, e0_.state AS state_13, e0_.postalcode AS postalcode_14, e0_.lat AS lat_15, e0_.lng AS lng_16, e0_.listedondirectory AS listedondirectory_17, e0_.contactemail AS contactemail_18, e0_.created_at AS created_at_19, e0_.updated_at AS updated_at_20, e0_.deleted_at AS deleted_at_21, e0_.organizer_id AS organizer_id_22, e0_.type_id AS type_id_23, e0_.country_id AS country_id_24 FROM eventic_venue e0_ INNER JOIN eventic_venue_translation e1_ ON e0_.id = e1_.translatable_id WHERE (e0_.hidden = ? AND e0_.listedondirectory = ? AND e1_.slug = ?) AND (e0_.deleted_at IS NULL) ORDER BY e0_.created_at DESC
Parameters:
[
  0
  1
  "hotel-aimarawa-san-antero-golfo-de-morrosquill"
]
0.13 ms
(3.02%)
1
SELECT t0.name AS name_1, t0.description AS description_2, t0.slug AS slug_3, t0.locale AS locale_4, t0.id AS id_5, t0.translatable_id AS translatable_id_6 FROM eventic_venue_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  18
]
0.13 ms
(2.93%)
1
SELECT DISTINCT e0_.id AS id_0, e0_.icon AS icon_1, e0_.image_name AS image_name_2, e0_.image_size AS image_size_3, e0_.image_mime_type AS image_mime_type_4, e0_.image_original_name AS image_original_name_5, e0_.image_dimensions AS image_dimensions_6, e0_.hidden AS hidden_7, e0_.featured AS featured_8, e0_.featuredorder AS featuredorder_9, e0_.created_at AS created_at_10, e0_.updated_at AS updated_at_11, e0_.deleted_at AS deleted_at_12 FROM eventic_category e0_ INNER JOIN eventic_category_translation e1_ ON e0_.id = e1_.translatable_id WHERE (e0_.hidden = ? AND e0_.featured = ?) AND (e0_.deleted_at IS NULL) ORDER BY e1_.name ASC LIMIT 4
Parameters:
[
  0
  1
]
0.11 ms
(2.45%)
1
SELECT t0.id AS id_1, t0.logo_name AS logo_name_2, t0.logo_size AS logo_size_3, t0.logo_mime_type AS logo_mime_type_4, t0.logo_original_name AS logo_original_name_5, t0.logo_dimensions AS logo_dimensions_6, t0.favicon_name AS favicon_name_7, t0.favicon_size AS favicon_size_8, t0.favicon_mime_type AS favicon_mime_type_9, t0.favicon_original_name AS favicon_original_name_10, t0.favicon_dimensions AS favicon_dimensions_11, t0.og_image_name AS og_image_name_12, t0.og_image_size AS og_image_size_13, t0.og_image_mime_type AS og_image_mime_type_14, t0.og_image_original_name AS og_image_original_name_15, t0.og_image_dimensions AS og_image_dimensions_16, t0.updated_at AS updated_at_17 FROM eventic_app_layout_setting t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.10 ms
(2.38%)
1
SELECT DISTINCT e0_.id AS id_0, e0_.icon AS icon_1, e0_.image_name AS image_name_2, e0_.image_size AS image_size_3, e0_.image_mime_type AS image_mime_type_4, e0_.image_original_name AS image_original_name_5, e0_.image_dimensions AS image_dimensions_6, e0_.hidden AS hidden_7, e0_.featured AS featured_8, e0_.featuredorder AS featuredorder_9, e0_.created_at AS created_at_10, e0_.updated_at AS updated_at_11, e0_.deleted_at AS deleted_at_12 FROM eventic_category e0_ INNER JOIN eventic_category_translation e1_ ON e0_.id = e1_.translatable_id WHERE (e0_.hidden = ? AND e0_.featured = ?) AND (e0_.deleted_at IS NULL) ORDER BY e1_.name ASC LIMIT 9
Parameters:
[
  0
  1
]
0.09 ms
(2.05%)
1
SELECT t0.id AS id_1, t0.code AS code_2, t0.hidden AS hidden_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6 FROM eventic_country t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  148
]
0.08 ms
(1.76%)
1
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.image_mime_type AS image_mime_type_4, t0.image_original_name AS image_original_name_5, t0.image_dimensions AS image_dimensions_6, t0.position AS position_7, t0.updated_at AS updated_at_8, t0.venue_id AS venue_id_9 FROM eventic_venue_image t0 WHERE t0.venue_id = ?
Parameters:
[
  18
]
0.07 ms
(1.73%)
1
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.id AS id_4, t0.translatable_id AS translatable_id_5 FROM eventic_venue_type_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
0.07 ms
(1.68%)
1
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.id AS id_4, t0.translatable_id AS translatable_id_5 FROM eventic_country_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  148
]
0.07 ms
(1.66%)
1
SELECT t0.id AS id_1, t0.hidden AS hidden_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5 FROM eventic_venue_type t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  1
]
0.07 ms
(1.61%)
1
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.hidden AS hidden_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6 FROM eventic_amenity t0 INNER JOIN eventic_venue_amenity ON t0.id = eventic_venue_amenity.Amenity_Id WHERE eventic_venue_amenity.Venue_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  18
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Venue No errors.
App\Entity\VenueTranslation No errors.
App\Entity\Organizer No errors.
App\Entity\VenueType No errors.
App\Entity\Country No errors.
App\Entity\EventDate No errors.
App\Entity\VenueImage No errors.
App\Entity\Amenity No errors.
App\Entity\AppLayoutSettings No errors.
App\Entity\Menu No errors.
App\Entity\MenuTranslation No errors.
App\Entity\MenuElement No errors.
App\Entity\MenuElementTranslation No errors.
App\Entity\Category No errors.
App\Entity\CategoryTranslation No errors.
App\Entity\Event No errors.
App\Entity\VenueTypeTranslation No errors.
App\Entity\CountryTranslation No errors.