GET https://www.dev.ecocert.com/ro-RO/detalii-certificare/agricultur%C4%83%20durabil%C4%83-ggp

Query Metrics

7 Database Queries
3 Different statements
75.88 ms Query time
0 Invalid entities
3965 Managed entities

Queries

Group similar statements

# Time Info
1 3.41 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:
[
  "ro"
  "RO"
]
2 10.87 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:
[
  "ro"
  "RO"
]
3 6.60 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:
[
  "ro"
  "XX"
]
4 2.90 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 13.77 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:
[
  28
]
6 11.33 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 IS NULL
Parameters:
[]
7 27.00 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 3959
App\Entity\CountryLanguage 2
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.