Query Metrics
7
Database Queries
5
Different statements
12.92 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.57 ms |
SELECT t0.id AS id_1, t0.hostname AS hostname_2, t0.display_title AS display_title_3, t0.default_language_code AS default_language_code_4, t0.language_code AS language_code_5, t0.site_type AS site_type_6, t0.date_format AS date_format_7, t0.enabled AS enabled_8, t0.drupal_ids AS drupal_ids_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM press_sites_domains t0 WHERE t0.hostname = ? AND t0.enabled = ?
Parameters:
[ "he-proxied.dev.nordiskfilm.com" 1 ] |
2 | 3.41 ms |
SELECT t0.id AS id_1, t0.hostname AS hostname_2, t0.display_title AS display_title_3, t0.default_language_code AS default_language_code_4, t0.language_code AS language_code_5, t0.site_type AS site_type_6, t0.date_format AS date_format_7, t0.enabled AS enabled_8, t0.drupal_ids AS drupal_ids_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM press_sites_domains t0 WHERE t0.hostname = ? AND t0.enabled = ?
Parameters:
[ "he-proxied.dev.nordiskfilm.com" 1 ] |
3 | 1.49 ms |
SELECT t0.id AS id_1, t0.admin_title AS admin_title_2, t0.region AS region_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM press_sites_pages t0 WHERE t0.id = ?
Parameters:
[
1
]
|
4 | 1.50 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.language_code AS language_code_5, t0.page_id AS page_id_6 FROM press_sites_pages_localization t0 WHERE t0.page_id = ?
Parameters:
[
1
]
|
5 | 1.51 ms |
SELECT t0.id AS id_1, t0.hostname AS hostname_2, t0.display_title AS display_title_3, t0.default_language_code AS default_language_code_4, t0.language_code AS language_code_5, t0.site_type AS site_type_6, t0.date_format AS date_format_7, t0.enabled AS enabled_8, t0.drupal_ids AS drupal_ids_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM press_sites_domains t0 INNER JOIN press_sites_pages_domains ON t0.id = press_sites_pages_domains.domain_id WHERE press_sites_pages_domains.page_id = ?
Parameters:
[
1
]
|
6 | 1.78 ms |
SELECT p0_.id AS id_0, p1_.title AS title_1, p1_.slug AS slug_2, p1_.content AS content_3, p1_.language_code AS language_code_4 FROM press_sites_pages p0_ INNER JOIN press_sites_pages_localization p1_ ON p0_.id = p1_.page_id INNER JOIN press_sites_pages_domains p3_ ON p0_.id = p3_.page_id INNER JOIN press_sites_domains p2_ ON p2_.id = p3_.domain_id WHERE p2_.id = ? AND p0_.region = ? AND p1_.language_code = ? AND p1_.slug IS NOT NULL
Parameters:
[ 4 "header" "sv" ] |
7 | 1.65 ms |
SELECT p0_.id AS id_0, p1_.title AS title_1, p1_.slug AS slug_2, p1_.content AS content_3, p1_.language_code AS language_code_4 FROM press_sites_pages p0_ INNER JOIN press_sites_pages_localization p1_ ON p0_.id = p1_.page_id INNER JOIN press_sites_pages_domains p3_ ON p0_.id = p3_.page_id INNER JOIN press_sites_domains p2_ ON p2_.id = p3_.domain_id WHERE p2_.id = ? AND p0_.region = ? AND p1_.language_code = ? AND p1_.slug IS NOT NULL
Parameters:
[ 4 "footer" "sv" ] |
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\PressSite\DomainManager | No errors. |
Sonata\ClassificationBundle\Entity\BaseCategory | No errors. |
App\Entity\SonataClassificationCategory | No errors. |
App\Entity\PressSite\PageManager | No errors. |
App\Entity\PressSite\PageManagerLocalization | No errors. |