GET https://my-technima.preprod-16h33.fr/policy/1

Query Metrics

5 Database Queries
5 Different statements
37.50 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 8.24 ms
SELECT t0.id AS id_1, t0.is_general_terms AS is_general_terms_2 FROM policy t0 WHERE t0.id = ?
Parameters:
[
  "1"
]
2 17.84 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.icu AS icu_3, t0.date_add AS date_add_4, t0.date_upd AS date_upd_5, t0.main AS main_6, t0.is_interface AS is_interface_7, t8.id AS id_9, t8.email AS email_10, t8.roles AS roles_11, t8.password AS password_12, t8.date_add AS date_add_13, t8.date_upd AS date_upd_14, t8.firstname AS firstname_15, t8.lastname AS lastname_16, t8.color AS color_17, t8.available_to AS available_to_18, t8.auth_code AS auth_code_19, t8.mdd_brand_requested AS mdd_brand_requested_20, t8.interface_lang_id AS interface_lang_id_21, t8.lang_in_charge_id AS lang_in_charge_id_22 FROM lang t0 LEFT JOIN user t8 ON t8.lang_in_charge_id = t0.id WHERE t0.is_interface = ? LIMIT 1
Parameters:
[
  1
]
3 5.51 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.progression AS progression_4, t0.policy_id AS policy_id_5, t0.lang_id AS lang_id_6 FROM policy_lang t0 WHERE t0.policy_id = ? AND t0.lang_id = ?
Parameters:
[
  1
  1
]
4 5.58 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.icu AS icu_3, t0.date_add AS date_add_4, t0.date_upd AS date_upd_5, t0.main AS main_6, t0.is_interface AS is_interface_7, t8.id AS id_9, t8.email AS email_10, t8.roles AS roles_11, t8.password AS password_12, t8.date_add AS date_add_13, t8.date_upd AS date_upd_14, t8.firstname AS firstname_15, t8.lastname AS lastname_16, t8.color AS color_17, t8.available_to AS available_to_18, t8.auth_code AS auth_code_19, t8.mdd_brand_requested AS mdd_brand_requested_20, t8.interface_lang_id AS interface_lang_id_21, t8.lang_in_charge_id AS lang_in_charge_id_22 FROM lang t0 LEFT JOIN user t8 ON t8.lang_in_charge_id = t0.id WHERE t0.icu = ?
Parameters:
[
  "fr"
]
5 0.34 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.progression AS progression_4, t0.policy_id AS policy_id_5, t0.lang_id AS lang_id_6 FROM policy_lang t0 WHERE t0.policy_id = ? AND t0.lang_id IN (?)
Parameters:
[
  1
  2
]

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\Policy No errors.
App\Entity\PolicyLang No errors.
App\Entity\Lang No errors.
App\Entity\User No errors.
App\Entity\Site No errors.
App\Entity\FeatureLang No errors.
App\Entity\FeatureValueLang No errors.
App\Entity\ProductLang No errors.
App\Entity\ProductWebToPrintLang No errors.
App\Entity\AttributeLang No errors.
App\Entity\AttributeValueLang No errors.
App\Entity\AdvantageLang No errors.
App\Entity\File No errors.
App\Entity\Brand No errors.
App\Entity\MddBrand
  • The field App\Entity\MddBrand#products is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Product#mddBrand does not contain the required 'inversedBy="products"' attribute.