Query Metrics
25
Database Queries
7
Different statements
35.16 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 15.34 ms |
SELECT t0.id AS id_1, t0.passwordChangedAt AS passwordChangedAt_2, t0.username AS username_3, t0.username_canonical AS username_canonical_4, t0.email AS email_5, t0.email_canonical AS email_canonical_6, t0.enabled AS enabled_7, t0.salt AS salt_8, t0.password AS password_9, t0.last_login AS last_login_10, t0.confirmation_token AS confirmation_token_11, t0.password_requested_at AS password_requested_at_12, t0.locked AS locked_13, t0.expired AS expired_14, t0.expires_at AS expires_at_15, t0.roles AS roles_16, t0.credentials_expired AS credentials_expired_17, t0.credentials_expire_at AS credentials_expire_at_18, t0.nom AS nom_19, t0.idsup AS idsup_20, t0.equipe AS equipe_21, t0.prenom AS prenom_22, t0.poste AS poste_23, t0.service AS service_24, t0.tel AS tel_25, t0.zone AS zone_26, t0.locale AS locale_27, t0.supH_id AS supH_id_28, t0.images_id AS images_id_29, t0.reviewtec_id AS reviewtec_id_30, t0.approb_id AS approb_id_31 FROM mstopeuser t0 WHERE t0.id = ?
Parameters:
[
9
]
|
| 2 | 1.76 ms |
SELECT t0.id AS id_1, t0.type_article AS type_article_2, t0.designation AS designation_3, t0.description AS description_4, t0.code_article AS code_article_5, t0.asset AS asset_6, t0.stockable AS stockable_7, t0.unite AS unite_8, t0.prix AS prix_9, t0.date_creer AS date_creer_10, t0.date_modif AS date_modif_11, t0.prix_ht AS prix_ht_12, t0.taxe AS taxe_13, t0.min_stock AS min_stock_14, t0.max_stock AS max_stock_15, t0.stock_securite AS stock_securite_16, t0.type_mrp AS type_mrp_17, t0.supplier_lead_time AS supplier_lead_time_18, t0.procurement_lead_time AS procurement_lead_time_19, t0.monthly_consumption AS monthly_consumption_20, t0.categorycatalogue_id AS categorycatalogue_id_21, t0.sous_category_catalogue_id AS sous_category_catalogue_id_22, t0.asset_code_famille_id AS asset_code_famille_id_23, t0.asset_code_category_id AS asset_code_category_id_24, t0.image_id AS image_id_25, t0.user_id AS user_id_26 FROM Catalogue t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 3 | 2.76 ms |
SELECT t0.id AS id_1, t0.entity_type AS entity_type_2, t0.entity_id AS entity_id_3, t0.key_name AS key_name_4, t0.locale AS locale_5, t0.content AS content_6, t0.domain AS domain_7 FROM translation t0 WHERE t0.entity_type = ? AND t0.entity_id = ? AND t0.key_name = ? AND t0.locale = ? LIMIT 1
Parameters:
[ "Catalogue" 1 "designation" "en" ] |
| 4 | 0.92 ms |
SELECT t0.id AS id_1, t0.delai_grace_peremption_jours AS delai_grace_peremption_jours_2, t0.libelle AS libelle_3, t0.code AS code_4, t0.codComp AS codComp_5 FROM CategoryCatalogue t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 5 | 0.63 ms |
SELECT c0_.id AS id_0, c0_.delai_grace_peremption_jours AS delai_grace_peremption_jours_1, c0_.libelle AS libelle_2, c0_.code AS code_3, c0_.codComp AS codComp_4 FROM CategoryCatalogue c0_
Parameters:
[] |
| 6 | 1.04 ms |
SELECT t0.id AS id_1, t0.entity_type AS entity_type_2, t0.entity_id AS entity_id_3, t0.key_name AS key_name_4, t0.locale AS locale_5, t0.content AS content_6, t0.domain AS domain_7 FROM translation t0 WHERE t0.entity_type = ? AND t0.entity_id = ? AND t0.key_name = ? AND t0.locale = ? LIMIT 1
Parameters:
[ "CategoryCatalogue" 1 "libelle" "en" ] |
| 7 | 0.53 ms |
SELECT t0.id AS id_1, t0.entity_type AS entity_type_2, t0.entity_id AS entity_id_3, t0.key_name AS key_name_4, t0.locale AS locale_5, t0.content AS content_6, t0.domain AS domain_7 FROM translation t0 WHERE t0.entity_type = ? AND t0.entity_id = ? AND t0.key_name = ? AND t0.locale = ? LIMIT 1
Parameters:
[ "CategoryCatalogue" 2 "libelle" "en" ] |
| 8 | 0.44 ms |
SELECT t0.id AS id_1, t0.entity_type AS entity_type_2, t0.entity_id AS entity_id_3, t0.key_name AS key_name_4, t0.locale AS locale_5, t0.content AS content_6, t0.domain AS domain_7 FROM translation t0 WHERE t0.entity_type = ? AND t0.entity_id = ? AND t0.key_name = ? AND t0.locale = ? LIMIT 1
Parameters:
[ "CategoryCatalogue" 3 "libelle" "en" ] |
| 9 | 0.53 ms |
SELECT t0.id AS id_1, t0.entity_type AS entity_type_2, t0.entity_id AS entity_id_3, t0.key_name AS key_name_4, t0.locale AS locale_5, t0.content AS content_6, t0.domain AS domain_7 FROM translation t0 WHERE t0.entity_type = ? AND t0.entity_id = ? AND t0.key_name = ? AND t0.locale = ? LIMIT 1
Parameters:
[ "CategoryCatalogue" 4 "libelle" "en" ] |
| 10 | 1.29 ms |
SELECT t0.id AS id_1, t0.entity_type AS entity_type_2, t0.entity_id AS entity_id_3, t0.key_name AS key_name_4, t0.locale AS locale_5, t0.content AS content_6, t0.domain AS domain_7 FROM translation t0 WHERE t0.entity_type = ? AND t0.entity_id = ? AND t0.key_name = ? AND t0.locale = ? LIMIT 1
Parameters:
[ "CategoryCatalogue" 5 "libelle" "en" ] |
| 11 | 0.50 ms |
SELECT t0.id AS id_1, t0.entity_type AS entity_type_2, t0.entity_id AS entity_id_3, t0.key_name AS key_name_4, t0.locale AS locale_5, t0.content AS content_6, t0.domain AS domain_7 FROM translation t0 WHERE t0.entity_type = ? AND t0.entity_id = ? AND t0.key_name = ? AND t0.locale = ? LIMIT 1
Parameters:
[ "CategoryCatalogue" 6 "libelle" "en" ] |
| 12 | 0.45 ms |
SELECT t0.id AS id_1, t0.entity_type AS entity_type_2, t0.entity_id AS entity_id_3, t0.key_name AS key_name_4, t0.locale AS locale_5, t0.content AS content_6, t0.domain AS domain_7 FROM translation t0 WHERE t0.entity_type = ? AND t0.entity_id = ? AND t0.key_name = ? AND t0.locale = ? LIMIT 1
Parameters:
[ "CategoryCatalogue" 7 "libelle" "en" ] |
| 13 | 0.89 ms |
SELECT t0.id AS id_1, t0.entity_type AS entity_type_2, t0.entity_id AS entity_id_3, t0.key_name AS key_name_4, t0.locale AS locale_5, t0.content AS content_6, t0.domain AS domain_7 FROM translation t0 WHERE t0.entity_type = ? AND t0.entity_id = ? AND t0.key_name = ? AND t0.locale = ? LIMIT 1
Parameters:
[ "CategoryCatalogue" 8 "libelle" "en" ] |
| 14 | 0.46 ms |
SELECT t0.id AS id_1, t0.entity_type AS entity_type_2, t0.entity_id AS entity_id_3, t0.key_name AS key_name_4, t0.locale AS locale_5, t0.content AS content_6, t0.domain AS domain_7 FROM translation t0 WHERE t0.entity_type = ? AND t0.entity_id = ? AND t0.key_name = ? AND t0.locale = ? LIMIT 1
Parameters:
[ "CategoryCatalogue" 9 "libelle" "en" ] |
| 15 | 0.51 ms |
SELECT t0.id AS id_1, t0.entity_type AS entity_type_2, t0.entity_id AS entity_id_3, t0.key_name AS key_name_4, t0.locale AS locale_5, t0.content AS content_6, t0.domain AS domain_7 FROM translation t0 WHERE t0.entity_type = ? AND t0.entity_id = ? AND t0.key_name = ? AND t0.locale = ? LIMIT 1
Parameters:
[ "CategoryCatalogue" 10 "libelle" "en" ] |
| 16 | 0.55 ms |
SELECT t0.id AS id_1, t0.entity_type AS entity_type_2, t0.entity_id AS entity_id_3, t0.key_name AS key_name_4, t0.locale AS locale_5, t0.content AS content_6, t0.domain AS domain_7 FROM translation t0 WHERE t0.entity_type = ? AND t0.entity_id = ? AND t0.key_name = ? AND t0.locale = ? LIMIT 1
Parameters:
[ "CategoryCatalogue" 11 "libelle" "en" ] |
| 17 | 0.89 ms |
SELECT t0.id AS id_1, t0.entity_type AS entity_type_2, t0.entity_id AS entity_id_3, t0.key_name AS key_name_4, t0.locale AS locale_5, t0.content AS content_6, t0.domain AS domain_7 FROM translation t0 WHERE t0.entity_type = ? AND t0.entity_id = ? AND t0.key_name = ? AND t0.locale = ? LIMIT 1
Parameters:
[ "CategoryCatalogue" 12 "libelle" "en" ] |
| 18 | 0.84 ms |
SELECT t0.id AS id_1, t0.entity_type AS entity_type_2, t0.entity_id AS entity_id_3, t0.key_name AS key_name_4, t0.locale AS locale_5, t0.content AS content_6, t0.domain AS domain_7 FROM translation t0 WHERE t0.entity_type = ? AND t0.entity_id = ? AND t0.key_name = ? AND t0.locale = ? LIMIT 1
Parameters:
[ "CategoryCatalogue" 13 "libelle" "en" ] |
| 19 | 0.46 ms |
SELECT t0.id AS id_1, t0.entity_type AS entity_type_2, t0.entity_id AS entity_id_3, t0.key_name AS key_name_4, t0.locale AS locale_5, t0.content AS content_6, t0.domain AS domain_7 FROM translation t0 WHERE t0.entity_type = ? AND t0.entity_id = ? AND t0.key_name = ? AND t0.locale = ? LIMIT 1
Parameters:
[ "CategoryCatalogue" 14 "libelle" "en" ] |
| 20 | 0.51 ms |
SELECT t0.id AS id_1, t0.entity_type AS entity_type_2, t0.entity_id AS entity_id_3, t0.key_name AS key_name_4, t0.locale AS locale_5, t0.content AS content_6, t0.domain AS domain_7 FROM translation t0 WHERE t0.entity_type = ? AND t0.entity_id = ? AND t0.key_name = ? AND t0.locale = ? LIMIT 1
Parameters:
[ "CategoryCatalogue" 15 "libelle" "en" ] |
| 21 | 0.98 ms |
SELECT t0.id AS id_1, t0.entity_type AS entity_type_2, t0.entity_id AS entity_id_3, t0.key_name AS key_name_4, t0.locale AS locale_5, t0.content AS content_6, t0.domain AS domain_7 FROM translation t0 WHERE t0.entity_type = ? AND t0.entity_id = ? AND t0.key_name = ? AND t0.locale = ? LIMIT 1
Parameters:
[ "CategoryCatalogue" 16 "libelle" "en" ] |
| 22 | 1.08 ms |
SELECT t0.id AS id_1, t0.entity_type AS entity_type_2, t0.entity_id AS entity_id_3, t0.key_name AS key_name_4, t0.locale AS locale_5, t0.content AS content_6, t0.domain AS domain_7 FROM translation t0 WHERE t0.entity_type = ? AND t0.entity_id = ? AND t0.key_name = ? AND t0.locale = ? LIMIT 1
Parameters:
[ "CategoryCatalogue" 17 "libelle" "en" ] |
| 23 | 0.80 ms |
SELECT t0.id AS id_1, t0.entity_type AS entity_type_2, t0.entity_id AS entity_id_3, t0.key_name AS key_name_4, t0.locale AS locale_5, t0.content AS content_6, t0.domain AS domain_7 FROM translation t0 WHERE t0.entity_type = ? AND t0.entity_id = ? AND t0.key_name = ? AND t0.locale = ? LIMIT 1
Parameters:
[ "CategoryCatalogue" 18 "libelle" "en" ] |
| 24 | 0.67 ms |
SELECT f0_.id AS id_0, f0_.libele AS libele_1, f0_.nomequip AS nomequip_2 FROM famille_j f0_
Parameters:
[] |
| 25 | 0.34 ms |
SELECT c0_.id AS id_0, c0_.duree_amortissement AS duree_amortissement_1, c0_.methode_amortissement AS methode_amortissement_2, c0_.libele AS libele_3, c0_.nomequip AS nomequip_4, c0_.famille_id AS famille_id_5 FROM category_j c0_ WHERE 1 = 0 ORDER BY c0_.libele ASC
Parameters:
[] |
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\User | No errors. |
| App\Entity\SupH | No errors. |
| App\Entity\ImageS | No errors. |
| App\Entity\ReviewTec | No errors. |
| App\Entity\Approb | No errors. |
| App\Entity\Catalogue | No errors. |
| App\Entity\CategoryCatalogue |
|
| App\Entity\SousCategoryCatalogue | No errors. |
| App\Entity\FamilleJ | No errors. |
| App\Entity\CategoryJ | No errors. |
| App\Entity\Image | No errors. |
| App\Entity\Translation | No errors. |
| App\Entity\CategoryCatalogueLignePlan | No errors. |
| App\Entity\CategorieMarche | No errors. |