GET https://www.dev.ecocert.com/en-IN/article/ecobeautyscore-decoding-environmental-scores-with-ecocert-5092958

Query Metrics

5 Database Queries
2 Different statements
32.98 ms Query time
0 Invalid entities
2274 Managed entities

Queries

Group similar statements

# Time Info
1 2.63 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"
  "IN"
]
2 5.45 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"
  "IN"
]
3 3.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"
]
4 4.23 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:
[
  23
]
5 16.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:
[
  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 2269
App\Entity\CountryLanguage 2
App\Entity\Country 2
App\Entity\Language 1

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.