Query Metrics

9 Database Queries
9 Different statements
1.32 ms Query time
1 Invalid entities
19 Managed entities

Queries

Group similar statements

# Time Info
1 0.20 ms
SELECT t0.id AS id_1, t0.num_article_erp AS num_article_erp_2, t0.reference AS reference_3, t0.titre_web AS titre_web_4, t0.description_web AS description_web_5, t0.meta_titre AS meta_titre_6, t0.meta_mots_cles AS meta_mots_cles_7, t0.meta_description AS meta_description_8, t0.reference_oem AS reference_oem_9, t0.ref_marked AS ref_marked_10, t0.prix_vente AS prix_vente_11, t0.prix_achat AS prix_achat_12, t0.unite AS unite_13, t0.notes AS notes_14, t0.stock AS stock_15, t0.nombre_dans_lot AS nombre_dans_lot_16, t0.publie AS publie_17, t0.date_creation AS date_creation_18, t0.date_synchronisation AS date_synchronisation_19, t0.en_stock AS en_stock_20, t0.slug AS slug_21, t0.marque_id AS marque_id_22 FROM article t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "20260212142245816967-mat-partie-male-partie-femelle-l-386m-mermatmalfemtf38-701"
]
2 0.19 ms
SELECT t0.id AS id_1, t0.id_machine_categorie_erp AS id_machine_categorie_erp_2, t0.nom AS nom_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM machine_categorie t0 WHERE t0.parent_id IS NULL ORDER BY t0.nom ASC
Parameters:
[]
3 0.13 ms
SELECT t0.id AS id_1, t0.id_erp AS id_erp_2, t0.nom_fichier AS nom_fichier_3, t0.photo_par_defaut AS photo_par_defaut_4, t0.nom_fichier_card AS nom_fichier_card_5, t0.article_id AS article_id_6 FROM article_photo t0 WHERE t0.article_id = ? ORDER BY t0.photo_par_defaut DESC
Parameters:
[
  8002
]
4 0.12 ms
SELECT t0.id AS id_1, t0.id_marque_erp AS id_marque_erp_2, t0.nom AS nom_3, t0.code AS code_4 FROM marque t0 WHERE t0.id = ?
Parameters:
[
  128
]
5 0.13 ms
SELECT t0.id AS id_1, t0.famille_article_defaut AS famille_article_defaut_2, t0.article_id AS article_id_3, t0.groupe_famille_id AS groupe_famille_id_4, t0.machine_categorie_id AS machine_categorie_id_5 FROM groupe_famille_article_article t0 WHERE t0.article_id = ?
Parameters:
[
  8002
]
6 0.11 ms
SELECT t0.id AS id_1, t0.id_machine_categorie_erp AS id_machine_categorie_erp_2, t0.nom AS nom_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM machine_categorie t0 WHERE t0.id = ?
Parameters:
[
  42
]
7 0.14 ms
SELECT t0.id AS id_1, t0.id_application_erp AS id_application_erp_2, t0.article_id AS article_id_3, t0.modele_id AS modele_id_4 FROM article_application t0 WHERE t0.article_id = ?
Parameters:
[
  8002
]
8 0.19 ms
SELECT t0.id AS id_1, t0.num_modele_erp AS num_modele_erp_2, t0.nom AS nom_3, t0.date_ajout AS date_ajout_4, t0.marque_vehicule_id AS marque_vehicule_id_5, t0.machine_categorie_id AS machine_categorie_id_6 FROM modele t0 WHERE t0.id = ?
Parameters:
[
  4730
]
9 0.11 ms
SELECT t0.id AS id_1, t0.num_marque_vehicule_erp AS num_marque_vehicule_erp_2, t0.nom AS nom_3, t0.debut_num_serie AS debut_num_serie_4 FROM marque_vehicule t0 WHERE t0.id = ?
Parameters:
[
  78
]

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\MachineCategorie 12
App\Entity\Article 1
App\Entity\Marque 1
App\Entity\GroupeFamilleArticleArticle 1
App\Entity\GroupeFamilleArticle 1
App\Entity\ArticleApplication 1
App\Entity\Modele 1
App\Entity\MarqueVehicule 1

Entities Mapping

Class Mapping errors
App\Entity\Article
  • The field App\Entity\Article#groupeFamilleArticleArticles is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\GroupeFamilleArticleArticle#article does not contain the required 'inversedBy="groupeFamilleArticleArticles"' attribute.
  • The field App\Entity\Article#articleApplications is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ArticleApplication#article does not contain the required 'inversedBy="articleApplications"' attribute.
App\Entity\Marque No errors.
App\Entity\ArticlePhoto No errors.
App\Entity\GroupeFamilleArticleArticle No errors.
App\Entity\ArticleApplication No errors.
App\Entity\MachineCategorie No errors.
App\Entity\GroupeFamilleArticle No errors.
App\Entity\Modele No errors.
App\Entity\MarqueVehicule No errors.