Query Metrics
18
Database Queries
14
Different statements
4.75 ms
Query time
3
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.26 ms |
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 WHERE t0.id = ?
Parameters:
[
"21"
]
|
2 | 0.32 ms |
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:
[
21
]
|
3 | 0.27 ms |
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:
[] |
4 | 0.84 ms |
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:
[
21
]
|
5 | 0.38 ms |
SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.image_produits_principale AS image_produits_principale_2, p0_.stock AS stock_3, p0_.price_ttc AS price_ttc_4, p0_.price_ht AS price_ht_5, p0_.tax_rate AS tax_rate_6, p0_.ref AS ref_7, p0_.is_selection AS is_selection_8, p0_.price_product_ttc AS price_product_ttc_9, p0_.price_product_ht AS price_product_ht_10, p0_.tax_rate_product_ht AS tax_rate_product_ht_11, p0_.price_service_ttc AS price_service_ttc_12, p0_.price_service_ht AS price_service_ht_13, p0_.tax_rate_service_ttc AS tax_rate_service_ttc_14, p0_.is_coup_coeur AS is_coup_coeur_15, p0_.template_pdf AS template_pdf_16, p0_.finition_id AS finition_id_17, p0_.produit_parent_id AS produit_parent_id_18 FROM produit p0_ WHERE p0_.produit_parent_id = ? OR p0_.id = ? ORDER BY p0_.finition_id ASC
Parameters:
[ "21" "21" ] |
6 | 0.22 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.age AS age_3, t0.descriptions AS descriptions_4, t0.note AS note_5, t0.image AS image_6, t0.produit_id AS produit_id_7 FROM avis_client t0 WHERE t0.produit_id = ?
Parameters:
[
21
]
|
7 | 0.23 ms |
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:
[
21
]
|
8 | 0.27 ms |
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:
[
21
]
|
9 | 0.28 ms |
SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.tax_rate AS tax_rate_4 FROM `option` t0 INNER JOIN produit_option ON t0.id = produit_option.option_id WHERE produit_option.produit_id = ?
Parameters:
[
21
]
|
10 | 0.22 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM option_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
1
]
|
11 | 0.20 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM option_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
2
]
|
12 | 0.14 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM option_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
3
]
|
13 | 0.18 ms |
SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.tax_rate AS tax_rate_4 FROM garantie t0 INNER JOIN produit_garantie ON t0.id = produit_garantie.garantie_id WHERE produit_garantie.produit_id = ?
Parameters:
[
21
]
|
14 | 0.18 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM garantie_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
5
]
|
15 | 0.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM garantie_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
6
]
|
16 | 0.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM garantie_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
7
]
|
17 | 0.20 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.price_ht AS price_ht_3, t0.price_ttc AS price_ttc_4, t0.tax_rate AS tax_rate_5, t0.descriptions AS descriptions_6 FROM finition t0 WHERE t0.id = ?
Parameters:
[
2
]
|
18 | 0.25 ms |
SELECT t0.id AS id_1, t0.pompe_pression_whirlpool AS pompe_pression_whirlpool_2, t0.pompe_filtration_whirlpool AS pompe_filtration_whirlpool_3, t0.puissance_rechauffeur AS puissance_rechauffeur_4, t0.isolation_thermo_iso14000 AS isolation_thermo_iso14000_5, t0.commande_adistance AS commande_adistance_6, t0.pompes_aair AS pompes_aair_7, t0.wifi AS wifi_8, t0.bluetooth AS bluetooth_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM produit_related_version_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
17
]
|
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\Produit\Produit |
|
App\Entity\Produit\Finition | No errors. |
App\Entity\Produit\ImageProduit | No errors. |
App\Entity\Categorie | 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 |
|
App\Entity\ProduitCarrier | No errors. |
App\Entity\Order\OrderLine | No errors. |
App\Entity\Produit\ProduitTranslation | No errors. |
App\Entity\ProduitRelatedVersionTranslation | No errors. |
App\Entity\Order\OrderLineOption | No errors. |
App\Entity\Produit\OptionTranslation | No errors. |
App\Entity\Order\OrderLineGarantie | No errors. |
App\Entity\Produit\GarantieTranslation | No errors. |
App\Entity\Order\OrderLineFinition |
|