GET https://www.dev.ecocert.com/fr-TN/certification/agriculture-biologique-chili-law-20-089

Query Metrics

7 Database Queries
2 Different statements
54.72 ms Query time
0 Invalid entities
5886 Managed entities

Queries

Group similar statements

# Time Info
1 3.01 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"
  "TN"
]
2 2.98 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"
  "TN"
]
3 2.52 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 3.22 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 10.06 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:
[
  39
]
6 15.76 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 17.16 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 5879
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.