Query Metrics

8 Database Queries
6 Different statements
22.03 ms Query time
0 Invalid entities
37 Managed entities

Queries

Group similar statements

# Time Info
1 1.07 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.weight AS weight_2, c0_.slug AS slug_3, c0_.parent_id AS parent_id_4 FROM category c0_ INNER JOIN category c1_ ON c0_.parent_id = c1_.id WHERE c1_.name = ?
Parameters:
[
  "Tipos de destino"
]
2 0.73 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.weight AS weight_2, c0_.slug AS slug_3, c0_.parent_id AS parent_id_4 FROM category c0_ INNER JOIN category c1_ ON c0_.parent_id = c1_.id WHERE c1_.name = ?
Parameters:
[
  "Tipos de destino"
]
3 0.62 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.weight AS weight_2, c0_.slug AS slug_3, c0_.parent_id AS parent_id_4 FROM category c0_ INNER JOIN category c1_ ON c0_.parent_id = c1_.id WHERE c1_.name = ?
Parameters:
[
  "Zonas"
]
4 0.88 ms
SELECT count(DISTINCT d0_.id) AS sclr_0 FROM destination d0_ INNER JOIN category c1_ ON d0_.category_id = c1_.id WHERE c1_.id = ? AND d0_.active = 1
Parameters:
[
  2563
]
5 1.99 ms
SELECT DISTINCT d0_.id AS id_0, d0_.priority AS priority_1, d0_.id AS id_2 FROM destination d0_ INNER JOIN category c1_ ON d0_.category_id = c1_.id WHERE c1_.id = ? AND d0_.active = 1 ORDER BY d0_.priority DESC, d0_.id DESC LIMIT 10 OFFSET 30
Parameters:
[
  2563
]
6 11.09 ms
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.location AS location_2, d0_.description AS description_3, d0_.seo AS seo_4, d0_.slug AS slug_5, d0_.created AS created_6, d0_.updated AS updated_7, d0_.priority AS priority_8, d0_.active AS active_9, d0_.ski_max_height AS ski_max_height_10, d0_.ski_min_height AS ski_min_height_11, d0_.ski_kms AS ski_kms_12, d0_.ski_slopes AS ski_slopes_13, d0_.ski_greens AS ski_greens_14, d0_.ski_blues AS ski_blues_15, d0_.ski_reds AS ski_reds_16, d0_.ski_blacks AS ski_blacks_17, d0_.ski_facilities AS ski_facilities_18, d0_.ski_services AS ski_services_19, d0_.ski_forecast AS ski_forecast_20, d0_.geo_location_latitude AS geo_location_latitude_21, d0_.geo_location_longitude AS geo_location_longitude_22, d0_.main_image_id AS main_image_id_23, d0_.zone_id AS zone_id_24, d0_.category_id AS category_id_25 FROM destination d0_ INNER JOIN category c1_ ON d0_.category_id = c1_.id WHERE c1_.id = ? AND d0_.active = 1 AND d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY d0_.priority DESC, d0_.id DESC
Parameters:
[
  2563
  50
  45
  44
  35
  34
  33
  32
  30
  29
  27
]
7 2.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.config_key AS config_key_3, t0.settings AS settings_4 FROM configuration t0 WHERE t0.config_key = ? LIMIT 1
Parameters:
[
  "homepage"
]
8 3.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.path AS path_4, t0.file_type AS file_type_5 FROM image t0 WHERE t0.id = ?
Parameters:
[
  8176
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
Uniski\ConfigBundle\Entity\Category 15
Uniski\ResourceBundle\Entity\Image 11
Uniski\ResourceBundle\Entity\Destination 10
Uniski\ConfigBundle\Entity\Configuration 1