Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

4.89 ms Query time

9 Invalid entities

5 Managed entities

Queries

Group similar statements

#▲

Time

Info

4.89 ms

SELECT t0.id AS id_1, t0.article_code AS article_code_2, t0.name AS name_3, t0.slug AS slug_4, t0.description AS description_5, t0.weight AS weight_6, t0.illustration AS illustration_7, t0.price_unitaire AS price_unitaire_8, t0.price_palette AS price_palette_9, t0.stock AS stock_10, t0.is_homepage AS is_homepage_11, t0.tva AS tva_12, t0.in_home AS in_home_13, t0.numbre_unite_palette AS numbre_unite_palette_14, t0.in_paint AS in_paint_15, t0.in_labo AS in_labo_16, t0.pvc AS pvc_17, t0.category_id AS category_id_18, t0.grain_id AS grain_id_19, t0.con_mastic_id AS con_mastic_id_20, t0.con_appret_id AS con_appret_id_21, t0.con_vernis_id AS con_vernis_id_22, t0.rapidite_id AS rapidite_id_23, t0.malette_id AS malette_id_24, t0.couleur_all_id AS couleur_all_id_25, t0.filter_dimension_cale_id AS filter_dimension_cale_id_26, t0.dimension_double_face_id AS dimension_double_face_id_27, t0.buse_id AS buse_id_28, t0.product_parent_id AS product_parent_id_29, t0.con_antigravillon_id AS con_antigravillon_id_30, t0.con_degraissant_id AS con_degraissant_id_31, t0.capacite_aspirateur_id AS capacite_aspirateur_id_32, t0.con_polish_id AS con_polish_id_33, t0.con_savon_id AS con_savon_id_34, t0.con_diluant_id AS con_diluant_id_35, t0.con_gobelet_id AS con_gobelet_id_36, t0.con_bidon_plastique_id AS con_bidon_plastique_id_37, t0.con_durcisseur_id AS con_durcisseur_id_38, t0.dimansion_filtre_cabine_id AS dimansion_filtre_cabine_id_39, t0.diametre_zikzak_id AS diametre_zikzak_id_40, t0.diametre_agrafes_id AS diametre_agrafes_id_41, t0.dimension_chariot_kraft_id AS dimension_chariot_kraft_id_42, t0.dimension_papier_cale_id AS dimension_papier_cale_id_43, t0.filtre_cone_id AS filtre_cone_id_44, t0.dimension_micro_bruch_id AS dimension_micro_bruch_id_45, t0.pinceau_dimension_id AS pinceau_dimension_id_46, t0.regle_dosage_id AS regle_dosage_id_47, t0.dimension_kraft_id AS dimension_kraft_id_48, t0.dimension_tireau_id AS dimension_tireau_id_49, t0.taille_fine_tape_id AS taille_fine_tape_id_50, t0.effet_id AS effet_id_51, t0.aspirateur_id AS aspirateur_id_52, t0.ponceuse_id AS ponceuse_id_53, t0.type_pistole_id AS type_pistole_id_54, t0.sol_plafond_id AS sol_plafond_id_55, t0.acier_alu_id AS acier_alu_id_56, t0.taille_id AS taille_id_57, t0.dimension_all_id AS dimension_all_id_58, t0.matiere_id AS matiere_id_59, t0.masquage_id AS masquage_id_60, t0.nettoyage_id AS nettoyage_id_61, t0.durcisseur_id AS durcisseur_id_62, t0.accessoire_aspirateur_id AS accessoire_aspirateur_id_63, t0.vitrage_id AS vitrage_id_64, t0.type_raccord_id AS type_raccord_id_65, t0.type_materiel_id AS type_materiel_id_66, t0.materiel_id AS materiel_id_67, t0.colle_joint_id AS colle_joint_id_68, t0.adhesif_id AS adhesif_id_69, t0.type_ponceuse_id AS type_ponceuse_id_70, t0.type_mastic_id AS type_mastic_id_71, t0.type_diluant_id AS type_diluant_id_72, t0.accessoire_id AS accessoire_id_73, t0.accessoire_polisseuse_id AS accessoire_polisseuse_id_74, t0.debosseleur_marteau_id AS debosseleur_marteau_id_75, t0.equerre_tirage_griffe_id AS equerre_tirage_griffe_id_76, t0.chaine_raccord_id AS chaine_raccord_id_77, t0.barre_debosslage_id AS barre_debosslage_id_78, t0.masse_magnetique_chario_id AS masse_magnetique_chario_id_79, t80.id AS id_81, t80.code AS code_82, t80.produit_id AS produit_id_83 FROM product t0 LEFT JOIN code_barre t80 ON t80.produit_id = t0.id WHERE t0.id = ? LIMIT 1

Parameters:

[
  "157"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.article_code AS article_code_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.description AS description_5,
  t0.weight AS weight_6,
  t0.illustration AS illustration_7,
  t0.price_unitaire AS price_unitaire_8,
  t0.price_palette AS price_palette_9,
  t0.stock AS stock_10,
  t0.is_homepage AS is_homepage_11,
  t0.tva AS tva_12,
  t0.in_home AS in_home_13,
  t0.numbre_unite_palette AS numbre_unite_palette_14,
  t0.in_paint AS in_paint_15,
  t0.in_labo AS in_labo_16,
  t0.pvc AS pvc_17,
  t0.category_id AS category_id_18,
  t0.grain_id AS grain_id_19,
  t0.con_mastic_id AS con_mastic_id_20,
  t0.con_appret_id AS con_appret_id_21,
  t0.con_vernis_id AS con_vernis_id_22,
  t0.rapidite_id AS rapidite_id_23,
  t0.malette_id AS malette_id_24,
  t0.couleur_all_id AS couleur_all_id_25,
  t0.filter_dimension_cale_id AS filter_dimension_cale_id_26,
  t0.dimension_double_face_id AS dimension_double_face_id_27,
  t0.buse_id AS buse_id_28,
  t0.product_parent_id AS product_parent_id_29,
  t0.con_antigravillon_id AS con_antigravillon_id_30,
  t0.con_degraissant_id AS con_degraissant_id_31,
  t0.capacite_aspirateur_id AS capacite_aspirateur_id_32,
  t0.con_polish_id AS con_polish_id_33,
  t0.con_savon_id AS con_savon_id_34,
  t0.con_diluant_id AS con_diluant_id_35,
  t0.con_gobelet_id AS con_gobelet_id_36,
  t0.con_bidon_plastique_id AS con_bidon_plastique_id_37,
  t0.con_durcisseur_id AS con_durcisseur_id_38,
  t0.dimansion_filtre_cabine_id AS dimansion_filtre_cabine_id_39,
  t0.diametre_zikzak_id AS diametre_zikzak_id_40,
  t0.diametre_agrafes_id AS diametre_agrafes_id_41,
  t0.dimension_chariot_kraft_id AS dimension_chariot_kraft_id_42,
  t0.dimension_papier_cale_id AS dimension_papier_cale_id_43,
  t0.filtre_cone_id AS filtre_cone_id_44,
  t0.dimension_micro_bruch_id AS dimension_micro_bruch_id_45,
  t0.pinceau_dimension_id AS pinceau_dimension_id_46,
  t0.regle_dosage_id AS regle_dosage_id_47,
  t0.dimension_kraft_id AS dimension_kraft_id_48,
  t0.dimension_tireau_id AS dimension_tireau_id_49,
  t0.taille_fine_tape_id AS taille_fine_tape_id_50,
  t0.effet_id AS effet_id_51,
  t0.aspirateur_id AS aspirateur_id_52,
  t0.ponceuse_id AS ponceuse_id_53,
  t0.type_pistole_id AS type_pistole_id_54,
  t0.sol_plafond_id AS sol_plafond_id_55,
  t0.acier_alu_id AS acier_alu_id_56,
  t0.taille_id AS taille_id_57,
  t0.dimension_all_id AS dimension_all_id_58,
  t0.matiere_id AS matiere_id_59,
  t0.masquage_id AS masquage_id_60,
  t0.nettoyage_id AS nettoyage_id_61,
  t0.durcisseur_id AS durcisseur_id_62,
  t0.accessoire_aspirateur_id AS accessoire_aspirateur_id_63,
  t0.vitrage_id AS vitrage_id_64,
  t0.type_raccord_id AS type_raccord_id_65,
  t0.type_materiel_id AS type_materiel_id_66,
  t0.materiel_id AS materiel_id_67,
  t0.colle_joint_id AS colle_joint_id_68,
  t0.adhesif_id AS adhesif_id_69,
  t0.type_ponceuse_id AS type_ponceuse_id_70,
  t0.type_mastic_id AS type_mastic_id_71,
  t0.type_diluant_id AS type_diluant_id_72,
  t0.accessoire_id AS accessoire_id_73,
  t0.accessoire_polisseuse_id AS accessoire_polisseuse_id_74,
  t0.debosseleur_marteau_id AS debosseleur_marteau_id_75,
  t0.equerre_tirage_griffe_id AS equerre_tirage_griffe_id_76,
  t0.chaine_raccord_id AS chaine_raccord_id_77,
  t0.barre_debosslage_id AS barre_debosslage_id_78,
  t0.masse_magnetique_chario_id AS masse_magnetique_chario_id_79,
  t80.id AS id_81,
  t80.code AS code_82,
  t80.produit_id AS produit_id_83
FROM
  product t0
  LEFT JOIN code_barre t80 ON t80.produit_id = t0.id
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.article_code AS article_code_2, t0.name AS name_3, t0.slug AS slug_4, t0.description AS description_5, t0.weight AS weight_6, t0.illustration AS illustration_7, t0.price_unitaire AS price_unitaire_8, t0.price_palette AS price_palette_9, t0.stock AS stock_10, t0.is_homepage AS is_homepage_11, t0.tva AS tva_12, t0.in_home AS in_home_13, t0.numbre_unite_palette AS numbre_unite_palette_14, t0.in_paint AS in_paint_15, t0.in_labo AS in_labo_16, t0.pvc AS pvc_17, t0.category_id AS category_id_18, t0.grain_id AS grain_id_19, t0.con_mastic_id AS con_mastic_id_20, t0.con_appret_id AS con_appret_id_21, t0.con_vernis_id AS con_vernis_id_22, t0.rapidite_id AS rapidite_id_23, t0.malette_id AS malette_id_24, t0.couleur_all_id AS couleur_all_id_25, t0.filter_dimension_cale_id AS filter_dimension_cale_id_26, t0.dimension_double_face_id AS dimension_double_face_id_27, t0.buse_id AS buse_id_28, t0.product_parent_id AS product_parent_id_29, t0.con_antigravillon_id AS con_antigravillon_id_30, t0.con_degraissant_id AS con_degraissant_id_31, t0.capacite_aspirateur_id AS capacite_aspirateur_id_32, t0.con_polish_id AS con_polish_id_33, t0.con_savon_id AS con_savon_id_34, t0.con_diluant_id AS con_diluant_id_35, t0.con_gobelet_id AS con_gobelet_id_36, t0.con_bidon_plastique_id AS con_bidon_plastique_id_37, t0.con_durcisseur_id AS con_durcisseur_id_38, t0.dimansion_filtre_cabine_id AS dimansion_filtre_cabine_id_39, t0.diametre_zikzak_id AS diametre_zikzak_id_40, t0.diametre_agrafes_id AS diametre_agrafes_id_41, t0.dimension_chariot_kraft_id AS dimension_chariot_kraft_id_42, t0.dimension_papier_cale_id AS dimension_papier_cale_id_43, t0.filtre_cone_id AS filtre_cone_id_44, t0.dimension_micro_bruch_id AS dimension_micro_bruch_id_45, t0.pinceau_dimension_id AS pinceau_dimension_id_46, t0.regle_dosage_id AS regle_dosage_id_47, t0.dimension_kraft_id AS dimension_kraft_id_48, t0.dimension_tireau_id AS dimension_tireau_id_49, t0.taille_fine_tape_id AS taille_fine_tape_id_50, t0.effet_id AS effet_id_51, t0.aspirateur_id AS aspirateur_id_52, t0.ponceuse_id AS ponceuse_id_53, t0.type_pistole_id AS type_pistole_id_54, t0.sol_plafond_id AS sol_plafond_id_55, t0.acier_alu_id AS acier_alu_id_56, t0.taille_id AS taille_id_57, t0.dimension_all_id AS dimension_all_id_58, t0.matiere_id AS matiere_id_59, t0.masquage_id AS masquage_id_60, t0.nettoyage_id AS nettoyage_id_61, t0.durcisseur_id AS durcisseur_id_62, t0.accessoire_aspirateur_id AS accessoire_aspirateur_id_63, t0.vitrage_id AS vitrage_id_64, t0.type_raccord_id AS type_raccord_id_65, t0.type_materiel_id AS type_materiel_id_66, t0.materiel_id AS materiel_id_67, t0.colle_joint_id AS colle_joint_id_68, t0.adhesif_id AS adhesif_id_69, t0.type_ponceuse_id AS type_ponceuse_id_70, t0.type_mastic_id AS type_mastic_id_71, t0.type_diluant_id AS type_diluant_id_72, t0.accessoire_id AS accessoire_id_73, t0.accessoire_polisseuse_id AS accessoire_polisseuse_id_74, t0.debosseleur_marteau_id AS debosseleur_marteau_id_75, t0.equerre_tirage_griffe_id AS equerre_tirage_griffe_id_76, t0.chaine_raccord_id AS chaine_raccord_id_77, t0.barre_debosslage_id AS barre_debosslage_id_78, t0.masse_magnetique_chario_id AS masse_magnetique_chario_id_79, t80.id AS id_81, t80.code AS code_82, t80.produit_id AS produit_id_83 FROM product t0 LEFT JOIN code_barre t80 ON t80.produit_id = t0.id WHERE t0.id = '157' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 211)
5	App\Controller\CartController->addProduct (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

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\Product	1
App\Entity\Category	1
App\Entity\Grain	1
App\Entity\ProductParent	1
App\Entity\CodeBarre	1

Entities Mapping

Class	Mapping errors
App\Entity\Product	No errors.
App\Entity\Category	No errors.
App\Entity\Grain	No errors.
App\Entity\ConMastic	No errors.
App\Entity\ConAppret	No errors.
App\Entity\ConVernis	No errors.
App\Entity\Rapidite	No errors.
App\Entity\Malette	No errors.
App\Entity\CouleurAll	No errors.
App\Entity\FilterDimensionCale	No errors.
App\Entity\DimensionDoubleFace	No errors.
App\Entity\Buse	No errors.
App\Entity\ProductParent	No errors.
App\Entity\ConAntigravillon	No errors.
App\Entity\ConDegraissant	No errors.
App\Entity\CapaciteAspirateur	No errors.
App\Entity\ConPolish	No errors.
App\Entity\ConSavon	No errors.
App\Entity\ConDiluant	No errors.
App\Entity\ConGobelet	No errors.
App\Entity\ConBidonPlastique	No errors.
App\Entity\ConDurcisseur	No errors.
App\Entity\DimansionFiltreCabine	No errors.
App\Entity\DiametreZikzak	No errors.
App\Entity\DiametreAgrafes	No errors.
App\Entity\DimensionChariotKraft	No errors.
App\Entity\DimensionPapierCale	No errors.
App\Entity\FiltreCone	No errors.
App\Entity\DimensionMicroBruch	No errors.
App\Entity\PinceauDimension	No errors.
App\Entity\RegleDosage	No errors.
App\Entity\DimensionKraft	No errors.
App\Entity\DimensionTireau	No errors.
App\Entity\TailleFineTape	No errors.
App\Entity\Effet	No errors.
App\Entity\Aspirateur	No errors.
App\Entity\Ponceuse	No errors.
App\Entity\TypePistole	No errors.
App\Entity\SolPlafond	No errors.
App\Entity\AcierAlu	No errors.
App\Entity\Taille	No errors.
App\Entity\DimensionAll	No errors.
App\Entity\Matiere	No errors.
App\Entity\Masquage	No errors.
App\Entity\Nettoyage	No errors.
App\Entity\Durcisseur	No errors.
App\Entity\AccessoireAspirateur	No errors.
App\Entity\Vitrage	No errors.
App\Entity\TypeRaccord	No errors.
App\Entity\TypeMateriel	No errors.
App\Entity\Materiel	No errors.
App\Entity\ColleJoint	No errors.
App\Entity\Adhesif	No errors.
App\Entity\TypePonceuse	No errors.
App\Entity\TypeMastic	No errors.
App\Entity\TypeDiluant	No errors.
App\Entity\Accessoire	No errors.
App\Entity\AccessoirePolisseuse	No errors.
App\Entity\DebosseleurMarteau	No errors.
App\Entity\EquerreTirageGriffe	No errors.
App\Entity\ChaineRaccord	No errors.
App\Entity\BarreDebosslage	No errors.
App\Entity\MasseMagnetiqueChario	No errors.
App\Entity\CodeBarre	No errors.
App\Entity\Promotions	No errors.
App\Entity\Image	No errors.
App\Entity\TechniqueProduct	No errors.
App\Entity\Panier	No errors.
App\Entity\QtyCarton	No errors.
App\Entity\Filters	No errors.
App\Entity\Brand	No errors.
App\Entity\User	No errors.
App\Entity\Catalogue	No errors.
App\Entity\Address	No errors.
App\Entity\Order	No errors.
App\Entity\TemporaryOrder	No errors.
App\Entity\Contrat	No errors.
App\Entity\Header	No errors.
App\Entity\AddressItem	No errors.
App\Entity\ComposantsVernis	The association App\Entity\ComposantsVernis#product refers to the owning side field App\Entity\Product#composantsVernis which does not exist.
App\Entity\RalAcrylique	The association App\Entity\RalAcrylique#product refers to the owning side field App\Entity\Product#ralAcrylique which does not exist.
App\Entity\Carrier	No errors.
App\Entity\MagasinPlafond	The association App\Entity\MagasinPlafond#name refers to the owning side field App\Entity\User#magasinPlafond which does not exist.
App\Entity\TypeVernis	The association App\Entity\TypeVernis#product refers to the owning side field App\Entity\Product#typeVernis which does not exist.
App\Entity\FinitionVernis	The association App\Entity\FinitionVernis#product refers to the owning side field App\Entity\Product#finitionVernis which does not exist.
App\Entity\Sol	No errors.
App\Entity\TagsColissimo	No errors.
App\Entity\Bd	No errors.
App\Entity\Annexe	No errors.
App\Entity\OrderDetail	No errors.
App\Entity\ComposantsAppret	The association App\Entity\ComposantsAppret#product refers to the owning side field App\Entity\Product#composantsAppret which does not exist.
App\Entity\DiametreAbrasif	The association App\Entity\DiametreAbrasif#product refers to the owning side field App\Entity\Product#diametreAbrasif which does not exist.
App\Entity\CouleurAppret	The association App\Entity\CouleurAppret#product refers to the owning side field App\Entity\Product#couleurAppret which does not exist.
App\Entity\Water	No errors.
App\Entity\ResetPasswordRequest	No errors.
App\Entity\OrbitalOuAleatoire	The association App\Entity\OrbitalOuAleatoire#product refers to the owning side field App\Entity\Product#orbitalOuAleatoire which does not exist.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://www.peintureautoexpert-pro.com/cartProduct/addProduct/157

Configuration Settings

Theme

Page Width