https://dev.spa.biz/spas/tous-les-spas

Query Metrics

65 Database Queries
7 Different statements
56.00 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
20.66 ms
(36.90%)
13
SELECT t0.id AS id_1, t0.dimensions AS dimensions_2, t0.conditionnement AS conditionnement_3, t0.nbr_rechauffeur AS nbr_rechauffeur_4, t0.led_chroma_peripherique AS led_chroma_peripherique_5, t0.colonne_eau_lumineuse AS colonne_eau_lumineuse_6, t0.cascade_led AS cascade_led_7, t0.aromatherapie AS aromatherapie_8, t0.skimmer AS skimmer_9, t0.ozonateur AS ozonateur_10, t0.systeme_antigel AS systeme_antigel_11, t0.volts AS volts_12, t0.chassis_inox_indestructible AS chassis_inox_indestructible_13, t0.socle_isolation_thermique AS socle_isolation_thermique_14, t0.nuage_led_sole AS nuage_led_sole_15, t0.system_appui_tete AS system_appui_tete_16, t0.jet_air AS jet_air_17, t0.places_assis AS places_assis_18, t0.places_allonge AS places_allonge_19, t0.enceinte AS enceinte_20, t0.volume AS volume_21, t0.poids AS poids_22, t0.capacite_spa AS capacite_spa_23, t0.jets_therapie AS jets_therapie_24, t0.jets_air AS jets_air_25, t0.jets_eau AS jets_eau_26, t0.jets_massage_cervical AS jets_massage_cervical_27, t0.turbo_jets_mollets AS turbo_jets_mollets_28, t0.appuis_tete AS appuis_tete_29, t0.radio AS radio_30, t0.leds_chromoterapie_perifs AS leds_chromoterapie_perifs_31, t0.gros_spot_leds AS gros_spot_leds_32, t0.cascade_leds AS cascade_leds_33, t0.spot_arc_en_ciel AS spot_arc_en_ciel_34, t0.acrylique_aristech_usa AS acrylique_aristech_usa_35, t0.triple_isolation AS triple_isolation_36, t0.puissance_pompe_aeau AS puissance_pompe_aeau_37, t0.tablette AS tablette_38, t0.fontaine_eau_lumineuse AS fontaine_eau_lumineuse_39, t0.gamme AS gamme_40, t0.finition_buses AS finition_buses_41, t0.enceinte_avec_leds AS enceinte_avec_leds_42, t0.enceinte_sans_leds AS enceinte_sans_leds_43, t0.cascade_non_leds AS cascade_non_leds_44, t0.chassis_acier_galvanise AS chassis_acier_galvanise_45, t0.prix_public_conseille AS prix_public_conseille_46, t0.aff_dimensions AS aff_dimensions_47, t0.aff_conditionnement AS aff_conditionnement_48, t0.aff_nbr_rechauffeur AS aff_nbr_rechauffeur_49, t0.aff_led_chroma_peripherique AS aff_led_chroma_peripherique_50, t0.aff_colonne_eau_lumineuse AS aff_colonne_eau_lumineuse_51, t0.aff_cascade_led AS aff_cascade_led_52, t0.aff_aromatherapie AS aff_aromatherapie_53, t0.aff_skimmer AS aff_skimmer_54, t0.aff_ozonateur AS aff_ozonateur_55, t0.aff_systeme_antigel AS aff_systeme_antigel_56, t0.aff_volts AS aff_volts_57, t0.aff_chassis_inox_indestructible AS aff_chassis_inox_indestructible_58, t0.aff_socle_isolation_thermique AS aff_socle_isolation_thermique_59, t0.aff_nuage_led_sole AS aff_nuage_led_sole_60, t0.aff_system_appui_tete AS aff_system_appui_tete_61, t0.aff_jet_air AS aff_jet_air_62, t0.aff_places_assis AS aff_places_assis_63, t0.aff_places_allonge AS aff_places_allonge_64, t0.aff_volume AS aff_volume_65, t0.aff_poids AS aff_poids_66, t0.aff_capacite_spa AS aff_capacite_spa_67, t0.aff_jets_therapie AS aff_jets_therapie_68, t0.aff_jets_air AS aff_jets_air_69, t0.aff_jets_eau AS aff_jets_eau_70, t0.aff_jets_massage_cervical AS aff_jets_massage_cervical_71, t0.aff_turbo_jets_mollets AS aff_turbo_jets_mollets_72, t0.aff_appuis_tete AS aff_appuis_tete_73, t0.aff_radio AS aff_radio_74, t0.aff_bluetooth AS aff_bluetooth_75, t0.aff_wifi AS aff_wifi_76, t0.aff_leds_chromoterapie_perifs AS aff_leds_chromoterapie_perifs_77, t0.aff_gros_spot_leds AS aff_gros_spot_leds_78, t0.aff_cascade_leds AS aff_cascade_leds_79, t0.aff_spot_arc_en_ciel AS aff_spot_arc_en_ciel_80, t0.aff_pompes_aair AS aff_pompes_aair_81, t0.aff_acrylique_aristech_usa AS aff_acrylique_aristech_usa_82, t0.aff_triple_isolation AS aff_triple_isolation_83, t0.aff_puissance_pompe_aeau AS aff_puissance_pompe_aeau_84, t0.aff_tablette AS aff_tablette_85, t0.aff_fontaine_eau_lumineuse AS aff_fontaine_eau_lumineuse_86, t0.aff_gamme AS aff_gamme_87, t0.aff_finition_buses AS aff_finition_buses_88, t0.aff_enceinte_avec_leds AS aff_enceinte_avec_leds_89, t0.aff_enceinte_sans_leds AS aff_enceinte_sans_leds_90, t0.aff_cascade_non_leds AS aff_cascade_non_leds_91, t0.aff_chassis_acier_galvanise AS aff_chassis_acier_galvanise_92, t0.aff_prix_public_conseille AS aff_prix_public_conseille_93, t0.aff_garantie AS aff_garantie_94, t0.aff_puissance_pompes_aair AS aff_puissance_pompes_aair_95, t0.aff_pompe_pression_whirlpool AS aff_pompe_pression_whirlpool_96, t0.aff_pompe_filtration_whirlpool AS aff_pompe_filtration_whirlpool_97, t0.aff_puissance_rechauffeur AS aff_puissance_rechauffeur_98, t0.aff_isolation_thermo_iso14000 AS aff_isolation_thermo_iso14000_99, t0.aff_commande_adistance AS aff_commande_adistance_100, t0.angle_leds AS angle_leds_101, t0.aff_angle_leds AS aff_angle_leds_102, t0.place_semi_allonges AS place_semi_allonges_103, t0.place_levitation AS place_levitation_104, t0.aff_place_semi_allonges AS aff_place_semi_allonges_105, t0.aff_place_levitation AS aff_place_levitation_106, t0.produit_id AS produit_id_107, t0.finition_id AS finition_id_108 FROM produit_related_version t0 WHERE t0.produit_id = ?
Parameters:
[
  10
]
9.03 ms
(16.13%)
13
SELECT t0.id AS id_1, t0.name AS name_2, t0.descriptions AS descriptions_3, t0.image AS image_4, t0.name_fr AS name_fr_5, t0.descriptions_fr AS descriptions_fr_6, t0.name_es AS name_es_7, t0.descriptions_es AS descriptions_es_8, t0.sous_categorie_id AS sous_categorie_id_9 FROM categorie t0 INNER JOIN produit_categorie ON t0.id = produit_categorie.categorie_id WHERE produit_categorie.produit_id = ?
Parameters:
[
  10
]
8.24 ms
(14.71%)
13
SELECT t0.id AS id_1, t0.image AS image_2, t0.produit_image_id AS produit_image_id_3, t0.color_id AS color_id_4 FROM image_produit t0 WHERE t0.produit_image_id = ?
Parameters:
[
  10
]
8.20 ms
(14.64%)
13
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM produit_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  10
]
7.25 ms
(12.95%)
9
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.image_produits_principale AS image_produits_principale_3, t0.stock AS stock_4, t0.price_ttc AS price_ttc_5, t0.price_ht AS price_ht_6, t0.tax_rate AS tax_rate_7, t0.ref AS ref_8, t0.is_selection AS is_selection_9, t0.price_product_ttc AS price_product_ttc_10, t0.price_product_ht AS price_product_ht_11, t0.tax_rate_product_ht AS tax_rate_product_ht_12, t0.price_service_ttc AS price_service_ttc_13, t0.price_service_ht AS price_service_ht_14, t0.tax_rate_service_ttc AS tax_rate_service_ttc_15, t0.is_coup_coeur AS is_coup_coeur_16, t0.template_pdf AS template_pdf_17, t0.finition_id AS finition_id_18, t0.produit_parent_id AS produit_parent_id_19 FROM produit t0 INNER JOIN produit_categorie ON t0.id = produit_categorie.produit_id WHERE produit_categorie.categorie_id = ?
Parameters:
[
  11
]
2.27 ms
(4.04%)
3
SELECT t0.id AS id_1, t0.name AS name_2, t0.descriptions AS descriptions_3, t0.image AS image_4, t0.name_fr AS name_fr_5, t0.descriptions_fr AS descriptions_fr_6, t0.name_es AS name_es_7, t0.descriptions_es AS descriptions_es_8, t0.sous_categorie_id AS sous_categorie_id_9 FROM categorie t0 WHERE t0.sous_categorie_id = ?
Parameters:
[
  2
]
0.35 ms
(0.63%)
1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.descriptions AS descriptions_2, c0_.image AS image_3, c0_.name_fr AS name_fr_4, c0_.descriptions_fr AS descriptions_fr_5, c0_.name_es AS name_es_6, c0_.descriptions_es AS descriptions_es_7, c0_.sous_categorie_id AS sous_categorie_id_8 FROM categorie c0_ WHERE c0_.sous_categorie_id IS NULL ORDER BY c0_.id 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\Categorie No errors.
App\Entity\Produit\Produit
  • The field App\Entity\Produit\Produit#orderLinesProduit is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Order\OrderLine#produit does not contain the required 'inversedBy="orderLinesProduit"' attribute.
App\Entity\Produit\Finition No errors.
App\Entity\Produit\ImageProduit No errors.
App\Entity\ProduitRelatedVersion No errors.
App\Entity\Produit\Garantie No errors.
App\Entity\Produit\Option No errors.
App\Entity\AvisClient No errors.
App\Entity\Produit\Couleur
  • The mappings App\Entity\Produit\Couleur#produits and App\Entity\Produit\Produit#colors are inconsistent with each other.
App\Entity\ProduitCarrier No errors.
App\Entity\Order\OrderLine No errors.
App\Entity\Produit\ProduitTranslation No errors.
App\Entity\ProduitRelatedVersionTranslation No errors.