Query Metrics
5
Database Queries
4
Different statements
1.13 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 0.27 ms |
SELECT t0.enabled AS enabled_1, t0.name AS name_2, t0.relative_path AS relative_path_3, t0.host AS host_4, t0.enabled_from AS enabled_from_5, t0.enabled_to AS enabled_to_6, t0.is_default AS is_default_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.locale AS locale_10, t0.title AS title_11, t0.meta_keywords AS meta_keywords_12, t0.meta_description AS meta_description_13, t0.id AS id_14 FROM page__site t0 WHERE t0.host IN (?, ?) AND t0.enabled = ? ORDER BY t0.is_default DESC
Parameters:
[ "suus-backend.dev5.pl" "localhost" 1 ] |
||||||||||||||||||||
2 | 0.42 ms |
SELECT p0_.route_name AS route_name_0, p0_.page_alias AS page_alias_1, p0_.type AS type_2, p0_.position AS position_3, p0_.enabled AS enabled_4, p0_.decorate AS decorate_5, p0_.name AS name_6, p0_.url AS url_7, p0_.parent_id AS parent_id_8, p0_.content AS content_9, p0_.publication_date_start AS publication_date_start_10, p0_.publication_date_end AS publication_date_end_11, p0_.created_at AS created_at_12, p0_.updated_at AS updated_at_13, p0_.id AS id_14, p0_.site_id AS site_id_15, p0_.page_id AS page_id_16 FROM page__snapshot p0_ WHERE (p0_.publication_date_start <= ? AND (p0_.publication_date_end IS NULL OR p0_.publication_date_end >= ?)) AND p0_.enabled = 1 AND p0_.site_id = ? AND p0_.url = ? LIMIT 1
Parameters:
[ "2025-06-04 09:16:42" "2025-06-04 09:16:42" 9 "/api/get-translations" ] |
||||||||||||||||||||
3 | 0.08 ms |
SELECT p0_.route_name AS route_name_0, p0_.page_alias AS page_alias_1, p0_.type AS type_2, p0_.position AS position_3, p0_.enabled AS enabled_4, p0_.decorate AS decorate_5, p0_.name AS name_6, p0_.url AS url_7, p0_.parent_id AS parent_id_8, p0_.content AS content_9, p0_.publication_date_start AS publication_date_start_10, p0_.publication_date_end AS publication_date_end_11, p0_.created_at AS created_at_12, p0_.updated_at AS updated_at_13, p0_.id AS id_14, p0_.site_id AS site_id_15, p0_.page_id AS page_id_16 FROM page__snapshot p0_ WHERE (p0_.publication_date_start <= ? AND (p0_.publication_date_end IS NULL OR p0_.publication_date_end >= ?)) AND p0_.enabled = 1 AND p0_.site_id = ? AND p0_.url = ? LIMIT 1
Parameters:
[ "2025-06-04 09:16:42" "2025-06-04 09:16:42" 9 "/api/get-translations" ] |
||||||||||||||||||||
4 | 0.25 ms |
SELECT p0_.route_name AS route_name_0, p0_.page_alias AS page_alias_1, p0_.type AS type_2, p0_.position AS position_3, p0_.enabled AS enabled_4, p0_.decorate AS decorate_5, p0_.name AS name_6, p0_.url AS url_7, p0_.parent_id AS parent_id_8, p0_.content AS content_9, p0_.publication_date_start AS publication_date_start_10, p0_.publication_date_end AS publication_date_end_11, p0_.created_at AS created_at_12, p0_.updated_at AS updated_at_13, p0_.id AS id_14, p0_.site_id AS site_id_15, p0_.page_id AS page_id_16 FROM page__snapshot p0_ WHERE (p0_.publication_date_start <= ? AND (p0_.publication_date_end IS NULL OR p0_.publication_date_end >= ?)) AND p0_.enabled = 1 AND p0_.site_id = ? AND p0_.route_name = ? LIMIT 1
Parameters:
[ "2025-06-04 09:16:42" "2025-06-04 09:16:42" 9 "api-get-translations" ] |
||||||||||||||||||||
5 | 0.11 ms |
SELECT t0.id AS id_1, t0.tkey AS tkey_2, t0.content AS content_3, t0.site_id AS site_id_4 FROM transl_book t0 WHERE t0.site_id = ?
Parameters:
[
"1"
]
|
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 |
---|---|
Sonata\PageBundle\Entity\BaseSite | No errors. |
App\Entity\SonataPageSite | No errors. |
Sonata\PageBundle\Entity\BaseSnapshot | No errors. |
App\Entity\SonataPageSnapshot | No errors. |
Sonata\PageBundle\Entity\BasePage | No errors. |
App\Entity\SonataPagePage | No errors. |
App\Entity\TranslBook | No errors. |