Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

4.00 ms Query time

4 Invalid entities

6 Managed entities

Queries

Group similar statements

#▲	Time	Info
1	1.19 ms	SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nom_canonique AS nom_canonique_3, t0.logo AS logo_4, t0.immage AS immage_5 FROM marque t0 WHERE t0.id = ? Parameters: [`"31"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nom_canonique AS nom_canonique_3, t0.logo AS logo_4, t0.immage AS immage_5 FROM marque t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nom_canonique AS nom_canonique_3, t0.logo AS logo_4, t0.immage AS immage_5 FROM marque t0 WHERE t0.id = '31';
2	2.81 ms	SELECT t0.nom AS nom_1, t0.nom_canonique AS nom_canonique_2, t0.montant AS montant_3, t0.reference AS reference_4, t0.descriptif AS descriptif_5, t0.gamme AS gamme_6, t0.id AS id_7, t0.vedete AS vedete_8, t0.bigblue AS bigblue_9, t0.pourcentage AS pourcentage_10, t0.nouveaute AS nouveaute_11, t0.actif AS actif_12, t0.dateajout AS dateajout_13, t0.livraison_gratuite AS livraison_gratuite_14, t0.nombre_etoile AS nombre_etoile_15, t0.id_marque AS id_marque_16, t0.id_etat AS id_etat_17, t0.commande_id AS commande_id_18 FROM article t0 WHERE t0.id_marque = ? Parameters: [`31`] View formatted query View runnable query Explain query SELECT t0.nom AS nom_1, t0.nom_canonique AS nom_canonique_2, t0.montant AS montant_3, t0.reference AS reference_4, t0.descriptif AS descriptif_5, t0.gamme AS gamme_6, t0.id AS id_7, t0.vedete AS vedete_8, t0.bigblue AS bigblue_9, t0.pourcentage AS pourcentage_10, t0.nouveaute AS nouveaute_11, t0.actif AS actif_12, t0.dateajout AS dateajout_13, t0.livraison_gratuite AS livraison_gratuite_14, t0.nombre_etoile AS nombre_etoile_15, t0.id_marque AS id_marque_16, t0.id_etat AS id_etat_17, t0.commande_id AS commande_id_18 FROM article t0 WHERE t0.id_marque = ? SELECT t0.nom AS nom_1, t0.nom_canonique AS nom_canonique_2, t0.montant AS montant_3, t0.reference AS reference_4, t0.descriptif AS descriptif_5, t0.gamme AS gamme_6, t0.id AS id_7, t0.vedete AS vedete_8, t0.bigblue AS bigblue_9, t0.pourcentage AS pourcentage_10, t0.nouveaute AS nouveaute_11, t0.actif AS actif_12, t0.dateajout AS dateajout_13, t0.livraison_gratuite AS livraison_gratuite_14, t0.nombre_etoile AS nombre_etoile_15, t0.id_marque AS id_marque_16, t0.id_etat AS id_etat_17, t0.commande_id AS commande_id_18 FROM article t0 WHERE t0.id_marque = 31;

#▲

Time

Info

1.19 ms

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nom_canonique AS nom_canonique_3, t0.logo AS logo_4, t0.immage AS immage_5 FROM marque t0 WHERE t0.id = ?

Parameters:

[
  "31"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.nom_canonique AS nom_canonique_3,
  t0.logo AS logo_4,
  t0.immage AS immage_5
FROM
  marque t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nom_canonique AS nom_canonique_3, t0.logo AS logo_4, t0.immage AS immage_5 FROM marque t0 WHERE t0.id = '31';

2.81 ms

SELECT t0.nom AS nom_1, t0.nom_canonique AS nom_canonique_2, t0.montant AS montant_3, t0.reference AS reference_4, t0.descriptif AS descriptif_5, t0.gamme AS gamme_6, t0.id AS id_7, t0.vedete AS vedete_8, t0.bigblue AS bigblue_9, t0.pourcentage AS pourcentage_10, t0.nouveaute AS nouveaute_11, t0.actif AS actif_12, t0.dateajout AS dateajout_13, t0.livraison_gratuite AS livraison_gratuite_14, t0.nombre_etoile AS nombre_etoile_15, t0.id_marque AS id_marque_16, t0.id_etat AS id_etat_17, t0.commande_id AS commande_id_18 FROM article t0 WHERE t0.id_marque = ?

Parameters:

[
  31
]

View formatted query View runnable query Explain query

SELECT
  t0.nom AS nom_1,
  t0.nom_canonique AS nom_canonique_2,
  t0.montant AS montant_3,
  t0.reference AS reference_4,
  t0.descriptif AS descriptif_5,
  t0.gamme AS gamme_6,
  t0.id AS id_7,
  t0.vedete AS vedete_8,
  t0.bigblue AS bigblue_9,
  t0.pourcentage AS pourcentage_10,
  t0.nouveaute AS nouveaute_11,
  t0.actif AS actif_12,
  t0.dateajout AS dateajout_13,
  t0.livraison_gratuite AS livraison_gratuite_14,
  t0.nombre_etoile AS nombre_etoile_15,
  t0.id_marque AS id_marque_16,
  t0.id_etat AS id_etat_17,
  t0.commande_id AS commande_id_18
FROM
  article t0
WHERE
  t0.id_marque = ?

SELECT t0.nom AS nom_1, t0.nom_canonique AS nom_canonique_2, t0.montant AS montant_3, t0.reference AS reference_4, t0.descriptif AS descriptif_5, t0.gamme AS gamme_6, t0.id AS id_7, t0.vedete AS vedete_8, t0.bigblue AS bigblue_9, t0.pourcentage AS pourcentage_10, t0.nouveaute AS nouveaute_11, t0.actif AS actif_12, t0.dateajout AS dateajout_13, t0.livraison_gratuite AS livraison_gratuite_14, t0.nombre_etoile AS nombre_etoile_15, t0.id_marque AS id_marque_16, t0.id_etat AS id_etat_17, t0.commande_id AS commande_id_18 FROM article t0 WHERE t0.id_marque = 31;

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\Article	3
App\Entity\Marque	1
App\Entity\Image	1
App\Entity\Etat	1

Entities Mapping

Class	Mapping errors
App\Entity\Marque	The mappings App\Entity\Marque#nouveautes and App\Entity\Nouveaute#marque are inconsistent with each other.
App\Entity\Image	No errors.
App\Entity\Article	The mappings App\Entity\Article#etat and App\Entity\Etat#articles are inconsistent with each other.
App\Entity\Nouveaute	The mappings App\Entity\Nouveaute#etat and App\Entity\Etat#articles are inconsistent with each other.
App\Entity\Etat	No errors.
App\Entity\Commande	No errors.
App\Entity\SousCategorie	The join columns of the many-to-many table 'sous_categorie_has_caracteristique_model' have to contain to ALL identifier columns of the source entity 'App\Entity\SousCategorie', however '' are missing.
App\Entity\Caracteristique	No errors.
App\Entity\RubriqueHasArticle	No errors.

Symfony Profiler

GET https://kondashop.com/ka/marque/31

Configuration Settings

Theme

Page Width