GET https://www.dev.ecocert.com/fr-CA/certification/zdhc-mrsl-niveaux-2-3

Query Metrics

7 Database Queries
2 Different statements
62.43 ms Query time
0 Invalid entities
5939 Managed entities

Queries

Group similar statements

# Time Info
1 7.72 ms
SELECT c0_.id AS id_0, c0_.priority AS priority_1, c0_.language AS language_2, c0_.country AS country_3 FROM country_language c0_ WHERE c0_.language = ? AND c0_.country = ?
Parameters:
[
  "fr"
  "CA"
]
2 4.57 ms
SELECT c0_.id AS id_0, c0_.priority AS priority_1, c0_.language AS language_2, c0_.country AS country_3 FROM country_language c0_ WHERE c0_.language = ? AND c0_.country = ?
Parameters:
[
  "fr"
  "CA"
]
3 2.35 ms
SELECT c0_.id AS id_0, c0_.priority AS priority_1, c0_.language AS language_2, c0_.country AS country_3 FROM country_language c0_ WHERE c0_.language = ? AND c0_.country = ?
Parameters:
[
  "fr"
  "XX"
]
4 2.33 ms
SELECT c0_.id AS id_0, c0_.priority AS priority_1, c0_.language AS language_2, c0_.country AS country_3 FROM country_language c0_ WHERE c0_.language = ? AND c0_.country = ?
Parameters:
[
  "en"
  "XX"
]
5 12.58 ms
SELECT t0.id AS id_1, t0.alias AS alias_2, t0.text AS text_3, t0.created_by AS created_by_4, t0.created_on AS created_on_5, t0.last_modified AS last_modified_6, t0.last_modifier AS last_modifier_7, t0.markdown AS markdown_8, t0.country_language_id AS country_language_id_9 FROM content t0 WHERE t0.country_language_id = ?
Parameters:
[
  17
]
6 13.45 ms
SELECT t0.id AS id_1, t0.alias AS alias_2, t0.text AS text_3, t0.created_by AS created_by_4, t0.created_on AS created_on_5, t0.last_modified AS last_modified_6, t0.last_modifier AS last_modifier_7, t0.markdown AS markdown_8, t0.country_language_id AS country_language_id_9 FROM content t0 WHERE t0.country_language_id = ?
Parameters:
[
  10
]
7 19.43 ms
SELECT t0.id AS id_1, t0.alias AS alias_2, t0.text AS text_3, t0.created_by AS created_by_4, t0.created_on AS created_on_5, t0.last_modified AS last_modified_6, t0.last_modifier AS last_modifier_7, t0.markdown AS markdown_8, t0.country_language_id AS country_language_id_9 FROM content t0 WHERE t0.country_language_id = ?
Parameters:
[
  11
]

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
App\Entity\Content 5932
App\Entity\CountryLanguage 3
App\Entity\Language 2
App\Entity\Country 2

Entities Mapping

Class Mapping errors
App\Entity\CountryLanguage No errors.
App\Entity\Language No errors.
App\Entity\Country No errors.
App\Entity\Content No errors.