Query Metrics
8
Database Queries
6
Different statements
22.01 ms
Query time
0
Invalid entities
31
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 11.85 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 | 1.44 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.93 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 | 1.67 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.96 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 10
Parameters:
[
2563
]
|
| 6 | 2.07 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 77 76 75 74 73 72 71 70 69 67 ] |
| 7 | 0.98 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 | 1.11 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\Destination | 10 |
| Uniski\ResourceBundle\Entity\Image | 5 |
| Uniski\ConfigBundle\Entity\Configuration | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| Uniski\ResourceBundle\Entity\Hotel | No errors. |
| Uniski\ConfigBundle\Entity\Category | No errors. |
| Uniski\ResourceBundle\Entity\ValueObject\SkiStation | No errors. |
| Uniski\ResourceBundle\Entity\ValueObject\GeoLocation | No errors. |
| Uniski\ResourceBundle\Entity\Destination | No errors. |
| Uniski\ResourceBundle\Entity\Image | No errors. |
| Uniski\ResourceBundle\Entity\Product | No errors. |
| Uniski\ConfigBundle\Entity\Configuration | No errors. |