Query Metrics
63
Database Queries
37
Different statements
61.37 ms
Query time
6
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
13.00 ms (21.19%) |
8 |
SELECT t0.id AS id_1, t0.url AS url_2, t0.product_id AS product_id_3 FROM photos t0 WHERE t0.product_id = ?
Parameters:
[
29
]
|
|
9.90 ms (16.13%) |
2 |
SELECT t0.id AS id_1, t0.at_date AS at_date_2, t0.date_stamp AS date_stamp_3, t0.titre AS titre_4, t0.start AS start_5, t0.end AS end_6, t0.desciption AS desciption_7, t0.all_day AS all_day_8, t0.background_color AS background_color_9, t0.border_color AS border_color_10, t0.text_color AS text_color_11, t0.company_id AS company_id_12 FROM planning_company t0 WHERE t0.company_id = ?
Parameters:
[
244
]
|
|
9.69 ms (15.79%) |
1 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.text AS text_2, p0_.price AS price_3, p0_.quantity AS quantity_4, p0_.product_slug AS product_slug_5, p0_.percent_deposit AS percent_deposit_6, p0_.deadline AS deadline_7, p0_.sizes AS sizes_8, p0_.colors AS colors_9, p0_.size_ring AS size_ring_10, p0_.nb_guest AS nb_guest_11, p0_.youtube_video AS youtube_video_12, p0_.is_activated AS is_activated_13, p0_.is_desactivated_by_admin AS is_desactivated_by_admin_14, p0_.mode_livraison AS mode_livraison_15, p0_.frais_livraison AS frais_livraison_16, p0_.weight AS weight_17, p0_.transporteurs AS transporteurs_18, p0_.code_promo AS code_promo_19, p0_.code_promo_euro AS code_promo_euro_20, p0_.template AS template_21, p0_.taxe_sejour AS taxe_sejour_22, p0_.prix_caution AS prix_caution_23, p0_.longitude AS longitude_24, p0_.latitude AS latitude_25, p0_.spring_price AS spring_price_26, p0_.summer_price AS summer_price_27, p0_.autumn_price AS autumn_price_28, p0_.winter_price AS winter_price_29, p0_.week_end_price AS week_end_price_30, p0_.city_localisation AS city_localisation_31, p0_.nb_chambre AS nb_chambre_32, p0_.night_min AS night_min_33, p0_.company_id AS company_id_34, p0_.pack_id AS pack_id_35, p0_.type_location_id AS type_location_id_36, p0_.type_prestation_id AS type_prestation_id_37, p0_.tva_id AS tva_id_38, p0_.type_hebergements_id AS type_hebergements_id_39, p0_.type_activity_id AS type_activity_id_40, p0_.caracteristique_vehicule_id AS caracteristique_vehicule_id_41, p0_.commune_id AS commune_id_42 FROM product p0_ WHERE p0_.company_id = ? AND p0_.is_activated = ? AND p0_.id <> ? ORDER BY p0_.id DESC LIMIT 3
Parameters:
[ 244 1 52 ] |
|
8.46 ms (13.79%) |
1 |
SELECT t0.id AS id_1, t0.labels AS labels_2, t0.slug_mobilier_exterieur AS slug_mobilier_exterieur_3 FROM mobilier_exterieur t0 INNER JOIN mobilier_exterieur_product ON t0.id = mobilier_exterieur_product.mobilier_exterieur_id WHERE mobilier_exterieur_product.product_id = ?
Parameters:
[
52
]
|
|
5.22 ms (8.51%) |
5 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.text AS text_2, p0_.price AS price_3, p0_.quantity AS quantity_4, p0_.product_slug AS product_slug_5, p0_.percent_deposit AS percent_deposit_6, p0_.deadline AS deadline_7, p0_.sizes AS sizes_8, p0_.colors AS colors_9, p0_.size_ring AS size_ring_10, p0_.nb_guest AS nb_guest_11, p0_.youtube_video AS youtube_video_12, p0_.is_activated AS is_activated_13, p0_.is_desactivated_by_admin AS is_desactivated_by_admin_14, p0_.mode_livraison AS mode_livraison_15, p0_.frais_livraison AS frais_livraison_16, p0_.weight AS weight_17, p0_.transporteurs AS transporteurs_18, p0_.code_promo AS code_promo_19, p0_.code_promo_euro AS code_promo_euro_20, p0_.template AS template_21, p0_.taxe_sejour AS taxe_sejour_22, p0_.prix_caution AS prix_caution_23, p0_.longitude AS longitude_24, p0_.latitude AS latitude_25, p0_.spring_price AS spring_price_26, p0_.summer_price AS summer_price_27, p0_.autumn_price AS autumn_price_28, p0_.winter_price AS winter_price_29, p0_.week_end_price AS week_end_price_30, p0_.city_localisation AS city_localisation_31, p0_.nb_chambre AS nb_chambre_32, p0_.night_min AS night_min_33, c1_.id AS id_34, c1_.siren AS siren_35, c1_.contact_name AS contact_name_36, c1_.contact_phone AS contact_phone_37, c1_.company_name AS company_name_38, c1_.fax AS fax_39, c1_.website AS website_40, c1_.contact_civility AS contact_civility_41, c1_.is_accept_condition AS is_accept_condition_42, c1_.company_slug AS company_slug_43, c1_.description AS description_44, c1_.image AS image_45, c1_.is_confirmed AS is_confirmed_46, c1_.kbis AS kbis_47, c1_.conditions_vente AS conditions_vente_48, c1_.strip_id AS strip_id_49, c1_.stripe_account AS stripe_account_50, c1_.first_name AS first_name_51, c1_.contact_birthday AS contact_birthday_52, c1_.country AS country_53, c1_.mango_id AS mango_id_54, c1_.is_valid_document AS is_valid_document_55, c1_.type AS type_56, c1_.is_editor_guide AS is_editor_guide_57, c1_.paiement_activ AS paiement_activ_58, c1_.commission_active AS commission_active_59, c1_.statu_con AS statu_con_60, c1_.etat_network AS etat_network_61, c1_.created_at AS created_at_62, c1_.is_direct_reservation_mode AS is_direct_reservation_mode_63, c1_.stripe_id AS stripe_id_64, c1_.stripe_account_id AS stripe_account_id_65, c1_.roles AS roles_66, c1_.email AS email_67, c1_.password AS password_68, c1_.adress AS adress_69, c1_.zip_code AS zip_code_70, c1_.city AS city_71, p0_.company_id AS company_id_72, p0_.pack_id AS pack_id_73, p0_.type_location_id AS type_location_id_74, p0_.type_prestation_id AS type_prestation_id_75, p0_.tva_id AS tva_id_76, p0_.type_hebergements_id AS type_hebergements_id_77, p0_.type_activity_id AS type_activity_id_78, p0_.caracteristique_vehicule_id AS caracteristique_vehicule_id_79, p0_.commune_id AS commune_id_80 FROM product p0_ LEFT JOIN company c1_ ON p0_.company_id = c1_.id WHERE p0_.company_id = ? AND c1_.is_confirmed = 1 AND c1_.is_valid_document = 1 AND p0_.is_activated = ? ORDER BY p0_.id DESC LIMIT 1
Parameters:
[ 218 1 ] |
|
3.37 ms (5.50%) |
1 |
SELECT t0.id AS id_1, t0.start_at AS start_at_2, t0.end_at AS end_at_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.is_accepted AS is_accepted_6, t0.raison_refus AS raison_refus_7, t0.payin_id AS payin_id_8, t0.nb_guests AS nb_guests_9, t0.is_received AS is_received_10, t0.tracking_code AS tracking_code_11, t0.options AS options_12, t0.promo AS promo_13, t0.address AS address_14, t0.postal_code AS postal_code_15, t0.city AS city_16, t0.color AS color_17, t0.size AS size_18, t0.qt_adulte AS qt_adulte_19, t0.qt_enfant AS qt_enfant_20, t0.qt_bebe AS qt_bebe_21, t0.total_amount AS total_amount_22, t0.group_options AS group_options_23, t0.is_modif_location AS is_modif_location_24, t0.is_ldefini_modifie AS is_ldefini_modifie_25, t0.is_lannul AS is_lannul_26, t0.is_ldefini_annul AS is_ldefini_annul_27, t0.date_sart_update AS date_sart_update_28, t0.date_end_update AS date_end_update_29, t0.hebergement_group AS hebergement_group_30, t0.taxe_sejour AS taxe_sejour_31, t0.client_id AS client_id_32, t0.product_id AS product_id_33 FROM location t0 WHERE t0.product_id = ?
Parameters:
[
52
]
|
|
1.50 ms (2.44%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.price AS price_4, t0.quantity AS quantity_5, t0.product_slug AS product_slug_6, t0.percent_deposit AS percent_deposit_7, t0.deadline AS deadline_8, t0.sizes AS sizes_9, t0.colors AS colors_10, t0.size_ring AS size_ring_11, t0.nb_guest AS nb_guest_12, t0.youtube_video AS youtube_video_13, t0.is_activated AS is_activated_14, t0.is_desactivated_by_admin AS is_desactivated_by_admin_15, t0.mode_livraison AS mode_livraison_16, t0.frais_livraison AS frais_livraison_17, t0.weight AS weight_18, t0.transporteurs AS transporteurs_19, t0.code_promo AS code_promo_20, t0.code_promo_euro AS code_promo_euro_21, t0.template AS template_22, t0.taxe_sejour AS taxe_sejour_23, t0.prix_caution AS prix_caution_24, t0.longitude AS longitude_25, t0.latitude AS latitude_26, t0.spring_price AS spring_price_27, t0.summer_price AS summer_price_28, t0.autumn_price AS autumn_price_29, t0.winter_price AS winter_price_30, t0.week_end_price AS week_end_price_31, t0.city_localisation AS city_localisation_32, t0.nb_chambre AS nb_chambre_33, t0.night_min AS night_min_34, t0.company_id AS company_id_35, t0.pack_id AS pack_id_36, t37.id AS id_38, t37.title AS title_39, t37.synthetique_message AS synthetique_message_40, t37.photo1 AS photo1_41, t37.description AS description_42, t37.photo2 AS photo2_43, t37.details AS details_44, t37.photo3 AS photo3_45, t37.product_id AS product_id_46, t0.type_location_id AS type_location_id_47, t0.type_prestation_id AS type_prestation_id_48, t0.tva_id AS tva_id_49, t0.type_hebergements_id AS type_hebergements_id_50, t0.type_activity_id AS type_activity_id_51, t0.caracteristique_vehicule_id AS caracteristique_vehicule_id_52, t0.commune_id AS commune_id_53 FROM product t0 LEFT JOIN product_description t37 ON t37.product_id = t0.id WHERE t0.id = ?
Parameters:
[
"52"
]
|
|
1.45 ms (2.36%) |
7 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.synthetique_message AS synthetique_message_3, t0.photo1 AS photo1_4, t0.description AS description_5, t0.photo2 AS photo2_6, t0.details AS details_7, t0.photo3 AS photo3_8, t0.product_id AS product_id_9 FROM product_description t0 WHERE t0.product_id = ?
Parameters:
[
53
]
|
|
0.84 ms (1.38%) |
4 |
SELECT t0.id AS id_1, t0.service_quality AS service_quality_2, t0.fiability AS fiability_3, t0.price AS price_4, t0.speed AS speed_5, t0.text AS text_6, t0.conform_description AS conform_description_7, t0.communication AS communication_8, t0.global_note AS global_note_9, t0.created_at AS created_at_10, t0.response_company AS response_company_11, t0.is_desactivated_by_admin AS is_desactivated_by_admin_12, t0.product_id AS product_id_13, t0.client_id AS client_id_14 FROM avis t0 WHERE t0.product_id = ?
Parameters:
[
52
]
|
|
0.74 ms (1.20%) |
3 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.sub_category_slug AS sub_category_slug_3, t0.is_suivi AS is_suivi_4, t0.is_clothing AS is_clothing_5, t0.is_color AS is_color_6, t0.is_nb_guest AS is_nb_guest_7, t0.image AS image_8, t0.is_clothing_ring AS is_clothing_ring_9, t0.is_service AS is_service_10, t0.is_fairepart AS is_fairepart_11, t0.is_vehicle AS is_vehicle_12 FROM sub_category t0 INNER JOIN product_sub_category ON t0.id = product_sub_category.sub_category_id WHERE product_sub_category.product_id = ?
Parameters:
[
52
]
|
|
0.72 ms (1.17%) |
3 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.numero AS numero_3 FROM department t0 INNER JOIN product_department ON t0.id = product_department.department_id WHERE product_department.product_id = ?
Parameters:
[
52
]
|
|
0.53 ms (0.87%) |
1 |
SELECT a0_.id AS id_0, a0_.service_quality AS service_quality_1, a0_.fiability AS fiability_2, a0_.price AS price_3, a0_.speed AS speed_4, a0_.text AS text_5, a0_.conform_description AS conform_description_6, a0_.communication AS communication_7, a0_.global_note AS global_note_8, a0_.created_at AS created_at_9, a0_.response_company AS response_company_10, a0_.is_desactivated_by_admin AS is_desactivated_by_admin_11, u1_.id AS id_12, u1_.civility AS civility_13, u1_.first_name AS first_name_14, u1_.last_name AS last_name_15, u1_.phone AS phone_16, u1_.wedding_date AS wedding_date_17, u1_.image AS image_18, u1_.id_stripe AS id_stripe_19, u1_.livraison_adress AS livraison_adress_20, u1_.livraison_zip_code AS livraison_zip_code_21, u1_.livraison_city AS livraison_city_22, u1_.birth_at AS birth_at_23, u1_.nationality AS nationality_24, u1_.country_residence AS country_residence_25, u1_.mango_id AS mango_id_26, u1_.is_valid AS is_valid_27, u1_.service_address AS service_address_28, u1_.service_zip_code AS service_zip_code_29, u1_.service_city AS service_city_30, u1_.statu_con AS statu_con_31, u1_.etat_network AS etat_network_32, u1_.roles AS roles_33, u1_.email AS email_34, u1_.password AS password_35, u1_.adress AS adress_36, u1_.zip_code AS zip_code_37, u1_.city AS city_38, p2_.id AS id_39, p2_.name AS name_40, p2_.text AS text_41, p2_.price AS price_42, p2_.quantity AS quantity_43, p2_.product_slug AS product_slug_44, p2_.percent_deposit AS percent_deposit_45, p2_.deadline AS deadline_46, p2_.sizes AS sizes_47, p2_.colors AS colors_48, p2_.size_ring AS size_ring_49, p2_.nb_guest AS nb_guest_50, p2_.youtube_video AS youtube_video_51, p2_.is_activated AS is_activated_52, p2_.is_desactivated_by_admin AS is_desactivated_by_admin_53, p2_.mode_livraison AS mode_livraison_54, p2_.frais_livraison AS frais_livraison_55, p2_.weight AS weight_56, p2_.transporteurs AS transporteurs_57, p2_.code_promo AS code_promo_58, p2_.code_promo_euro AS code_promo_euro_59, p2_.template AS template_60, p2_.taxe_sejour AS taxe_sejour_61, p2_.prix_caution AS prix_caution_62, p2_.longitude AS longitude_63, p2_.latitude AS latitude_64, p2_.spring_price AS spring_price_65, p2_.summer_price AS summer_price_66, p2_.autumn_price AS autumn_price_67, p2_.winter_price AS winter_price_68, p2_.week_end_price AS week_end_price_69, p2_.city_localisation AS city_localisation_70, p2_.nb_chambre AS nb_chambre_71, p2_.night_min AS night_min_72, a0_.product_id AS product_id_73, a0_.client_id AS client_id_74, p2_.company_id AS company_id_75, p2_.pack_id AS pack_id_76, p2_.type_location_id AS type_location_id_77, p2_.type_prestation_id AS type_prestation_id_78, p2_.tva_id AS tva_id_79, p2_.type_hebergements_id AS type_hebergements_id_80, p2_.type_activity_id AS type_activity_id_81, p2_.caracteristique_vehicule_id AS caracteristique_vehicule_id_82, p2_.commune_id AS commune_id_83 FROM avis a0_ LEFT JOIN user u1_ ON a0_.client_id = u1_.id LEFT JOIN product p2_ ON a0_.product_id = p2_.id WHERE p2_.id = ? AND a0_.text IS NOT NULL ORDER BY a0_.id DESC
Parameters:
[
52
]
|
|
0.45 ms (0.74%) |
1 |
SELECT l0_.id AS id_0, l0_.start_at AS start_at_1, l0_.end_at AS end_at_2, l0_.created_at AS created_at_3, l0_.updated_at AS updated_at_4, l0_.is_accepted AS is_accepted_5, l0_.raison_refus AS raison_refus_6, l0_.payin_id AS payin_id_7, l0_.nb_guests AS nb_guests_8, l0_.is_received AS is_received_9, l0_.tracking_code AS tracking_code_10, l0_.options AS options_11, l0_.promo AS promo_12, l0_.address AS address_13, l0_.postal_code AS postal_code_14, l0_.city AS city_15, l0_.color AS color_16, l0_.size AS size_17, l0_.qt_adulte AS qt_adulte_18, l0_.qt_enfant AS qt_enfant_19, l0_.qt_bebe AS qt_bebe_20, l0_.total_amount AS total_amount_21, l0_.group_options AS group_options_22, l0_.is_modif_location AS is_modif_location_23, l0_.is_ldefini_modifie AS is_ldefini_modifie_24, l0_.is_lannul AS is_lannul_25, l0_.is_ldefini_annul AS is_ldefini_annul_26, l0_.date_sart_update AS date_sart_update_27, l0_.date_end_update AS date_end_update_28, l0_.hebergement_group AS hebergement_group_29, l0_.taxe_sejour AS taxe_sejour_30, l0_.client_id AS client_id_31, l0_.product_id AS product_id_32 FROM location l0_ LEFT JOIN product p1_ ON l0_.product_id = p1_.id WHERE p1_.company_id = ? ORDER BY l0_.created_at DESC
Parameters:
[
244
]
|
|
0.44 ms (0.71%) |
1 |
SELECT t0.id AS id_1, t0.siren AS siren_2, t0.contact_name AS contact_name_3, t0.contact_phone AS contact_phone_4, t0.company_name AS company_name_5, t0.fax AS fax_6, t0.website AS website_7, t0.contact_civility AS contact_civility_8, t0.is_accept_condition AS is_accept_condition_9, t0.company_slug AS company_slug_10, t0.description AS description_11, t0.image AS image_12, t0.is_confirmed AS is_confirmed_13, t0.kbis AS kbis_14, t0.conditions_vente AS conditions_vente_15, t0.strip_id AS strip_id_16, t0.stripe_account AS stripe_account_17, t0.first_name AS first_name_18, t0.contact_birthday AS contact_birthday_19, t0.country AS country_20, t0.mango_id AS mango_id_21, t0.is_valid_document AS is_valid_document_22, t0.type AS type_23, t0.is_editor_guide AS is_editor_guide_24, t0.paiement_activ AS paiement_activ_25, t0.commission_active AS commission_active_26, t0.statu_con AS statu_con_27, t0.etat_network AS etat_network_28, t0.created_at AS created_at_29, t0.is_direct_reservation_mode AS is_direct_reservation_mode_30, t0.stripe_id AS stripe_id_31, t0.stripe_account_id AS stripe_account_id_32, t0.roles AS roles_33, t0.email AS email_34, t0.password AS password_35, t0.adress AS adress_36, t0.zip_code AS zip_code_37, t0.city AS city_38 FROM company t0 WHERE t0.is_confirmed = ? AND t0.is_valid_document = ?
Parameters:
[ 1 1 ] |
|
0.40 ms (0.66%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.sub_category_slug AS sub_category_slug_3, t0.is_suivi AS is_suivi_4, t0.is_clothing AS is_clothing_5, t0.is_color AS is_color_6, t0.is_nb_guest AS is_nb_guest_7, t0.image AS image_8, t0.is_clothing_ring AS is_clothing_ring_9, t0.is_service AS is_service_10, t0.is_fairepart AS is_fairepart_11, t0.is_vehicle AS is_vehicle_12 FROM sub_category t0 ORDER BY t0.id DESC
Parameters:
[] |
|
0.34 ms (0.56%) |
1 |
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.numero AS numero_2 FROM department d0_ LEFT JOIN product_department p2_ ON d0_.id = p2_.department_id LEFT JOIN product p1_ ON p1_.id = p2_.product_id
Parameters:
[] |
|
0.23 ms (0.37%) |
1 |
SELECT t0.id AS id_1, t0.labels AS labels_2, t0.slug_security AS slug_security_3 FROM SECURITY t0 INNER JOIN security_product ON t0.id = security_product.security_id WHERE security_product.product_id = ?
Parameters:
[
52
]
|
|
0.23 ms (0.37%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.image1 AS image1_4, t0.image2 AS image2_5, t0.colors_option AS colors_option_6, t0.format AS format_7, t0.finition AS finition_8, t0.papier AS papier_9, t0.quantite AS quantite_10, t0.etiquette AS etiquette_11, t0.ruban AS ruban_12, t0.p_qte AS p_qte_13, t0.valeur_option AS valeur_option_14, t0.qte_valeur AS qte_valeur_15, t0.prix_valeur AS prix_valeur_16, t0.image_valeur AS image_valeur_17, t0.is_multiple AS is_multiple_18, t0.product_id AS product_id_19 FROM product_option t0 WHERE t0.product_id = ?
Parameters:
[
52
]
|
|
0.22 ms (0.37%) |
1 |
SELECT t0.id AS id_1, t0.labels AS labels_2, t0.slug_equipment AS slug_equipment_3 FROM equipment t0 INNER JOIN equipment_product ON t0.id = equipment_product.equipment_id WHERE equipment_product.product_id = ?
Parameters:
[
52
]
|
|
0.22 ms (0.36%) |
1 |
SELECT t0.id AS id_1, t0.labels AS labels_2, t0.slug_salle_de_bain AS slug_salle_de_bain_3 FROM salle_de_bain t0 INNER JOIN salle_de_bain_product ON t0.id = salle_de_bain_product.salle_de_bain_id WHERE salle_de_bain_product.product_id = ?
Parameters:
[
52
]
|
|
0.22 ms (0.36%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.slug AS slug_4 FROM category t0 INNER JOIN sub_category_category ON t0.id = sub_category_category.category_id WHERE sub_category_category.sub_category_id = ?
Parameters:
[
55
]
|
|
0.22 ms (0.35%) |
1 |
SELECT t0.id AS id_1, t0.labels AS labels_2, t0.slug_type_local AS slug_type_local_3 FROM type_localisation t0 INNER JOIN type_localisation_product ON t0.id = type_localisation_product.type_localisation_id WHERE type_localisation_product.product_id = ?
Parameters:
[
52
]
|
|
0.22 ms (0.35%) |
1 |
SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.product_id AS product_id_3 FROM wish_list t0 WHERE t0.user_id IS NULL AND t0.product_id = ? LIMIT 1
Parameters:
[
52
]
|
|
0.21 ms (0.35%) |
1 |
SELECT t0.id AS id_1, t0.type_chambre AS type_chambre_2, t0.num_chambre AS num_chambre_3, t0.nombre_lits AS nombre_lits_4, t0.tarif_nuit AS tarif_nuit_5, t0.tarif_jour AS tarif_jour_6, t0.image_chambre AS image_chambre_7, t0.lit_chambre_data AS lit_chambre_data_8, t0.product_id AS product_id_9 FROM chambre t0 WHERE t0.product_id = ?
Parameters:
[
52
]
|
|
0.21 ms (0.35%) |
1 |
SELECT t0.id AS id_1, t0.labels AS labels_2, t0.slug_caracter AS slug_caracter_3 FROM caracteristic t0 INNER JOIN caracteristic_product ON t0.id = caracteristic_product.caracteristic_id WHERE caracteristic_product.product_id = ?
Parameters:
[
52
]
|
|
0.21 ms (0.35%) |
1 |
SELECT t0.id AS id_1, t0.labels AS labels_2, t0.slug_langue AS slug_langue_3 FROM langue_hote t0 INNER JOIN langue_hote_product ON t0.id = langue_hote_product.langue_hote_id WHERE langue_hote_product.product_id = ?
Parameters:
[
52
]
|
|
0.21 ms (0.34%) |
1 |
SELECT a0_.id AS id_0, a0_.start_at AS start_at_1, a0_.end_at AS end_at_2, a0_.active AS active_3, a0_.value AS value_4, a0_.created_at AS created_at_5 FROM admin_promo a0_ WHERE (? BETWEEN a0_.start_at AND a0_.end_at) AND a0_.active = ?
Parameters:
[ "2025-10-16 01:55:18" 1 ] |
|
0.21 ms (0.34%) |
1 |
SELECT t0.id AS id_1, t0.custom_date AS custom_date_2, t0.custom_price AS custom_price_3, t0.product_id AS product_id_4 FROM programming_day_price t0 WHERE t0.product_id = ?
Parameters:
[
52
]
|
|
0.20 ms (0.33%) |
1 |
SELECT t0.id AS id_1, t0.start_day AS start_day_2, t0.reduction AS reduction_3, t0.product_id AS product_id_4 FROM product_reduction t0 WHERE t0.product_id = ?
Parameters:
[
52
]
|
|
0.20 ms (0.32%) |
1 |
SELECT t0.id AS id_1, t0.labels AS labels_2, t0.slug_equipements_cuisine AS slug_equipements_cuisine_3 FROM equipements_cuisine t0 INNER JOIN equipements_cuisine_product ON t0.id = equipements_cuisine_product.equipements_cuisine_id WHERE equipements_cuisine_product.product_id = ?
Parameters:
[
52
]
|
|
0.20 ms (0.32%) |
1 |
SELECT t0.id AS id_1, t0.labels AS labels_2, t0.slug_accessoires_de_chambre AS slug_accessoires_de_chambre_3 FROM accessoires_de_chambre t0 INNER JOIN accessoires_de_chambre_product ON t0.id = accessoires_de_chambre_product.accessoires_de_chambre_id WHERE accessoires_de_chambre_product.product_id = ?
Parameters:
[
52
]
|
|
0.20 ms (0.32%) |
1 |
SELECT t0.id AS id_1, t0.start_day_not_available AS start_day_not_available_2, t0.end_day_not_available AS end_day_not_available_3, t0.raison_not_available AS raison_not_available_4, t0.product_id AS product_id_5 FROM product_agenda t0 WHERE t0.product_id = ?
Parameters:
[
52
]
|
|
0.19 ms (0.30%) |
1 |
SELECT t0.id AS id_1, t0.reduction_percentage AS reduction_percentage_2, t0.duration AS duration_3, t0.countdown AS countdown_4, t0.created_at AS created_at_5, t0.product_id AS product_id_6 FROM product_auto_reduction t0 WHERE t0.product_id = ?
Parameters:
[
52
]
|
|
0.18 ms (0.29%) |
1 |
SELECT t0.id AS id_1, t0.nbr_pers AS nbr_pers_2, t0.reduction AS reduction_3, t0.product_id AS product_id_4 FROM tarif_degressif t0 WHERE t0.product_id = ?
Parameters:
[
52
]
|
|
0.18 ms (0.29%) |
1 |
SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.end_date AS end_date_3, t0.price AS price_4, t0.product_id AS product_id_5 FROM product_period_price t0 WHERE t0.product_id = ?
Parameters:
[
52
]
|
|
0.18 ms (0.29%) |
1 |
SELECT t0.id AS id_1, t0.labels AS labels_2, t0.slug_type_hebergm AS slug_type_hebergm_3 FROM type_hebergement t0 WHERE t0.id = ?
Parameters:
[
2
]
|
|
0.17 ms (0.28%) |
1 |
SELECT t0.id AS id_1, t0.label AS label_2 FROM type_location t0 WHERE t0.id = ?
Parameters:
[
2
]
|
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\Product |
|
| App\Entity\Company |
|
| App\Entity\Pack | No errors. |
| App\Entity\ProductDescription | No errors. |
| App\Entity\TypeLocation | No errors. |
| App\Entity\TypePrestation | No errors. |
| App\Entity\Tva | No errors. |
| App\Entity\TypeHebergement | No errors. |
| App\Entity\ActivityType | No errors. |
| App\Entity\CaracteristiqueVehicule | No errors. |
| App\Entity\Commune | No errors. |
| App\Entity\Photos | No errors. |
| App\Entity\Department | No errors. |
| App\Entity\CommandProduct | No errors. |
| App\Entity\Avis | No errors. |
| App\Entity\ProductPercent | No errors. |
| App\Entity\ContactProduct | No errors. |
| App\Entity\ProductOption | No errors. |
| App\Entity\SubCategory | No errors. |
| App\Entity\AnnonceCompany | No errors. |
| App\Entity\Location |
|
| App\Entity\Reservation | No errors. |
| App\Entity\Caution | No errors. |
| App\Entity\Participant | No errors. |
| App\Entity\Chambre | No errors. |
| App\Entity\Caracteristic | No errors. |
| App\Entity\Equipment | No errors. |
| App\Entity\LangueHote | No errors. |
| App\Entity\TypeLocalisation | No errors. |
| App\Entity\Security | No errors. |
| App\Entity\ProductReduction | No errors. |
| App\Entity\ProgrammingDayPrice | No errors. |
| App\Entity\ProductAgenda | No errors. |
| App\Entity\ProductAutoReduction |
|
| App\Entity\ReseauSociaux\Publication | No errors. |
| App\Entity\PendingLocation | No errors. |
| App\Entity\PendingReservation | No errors. |
| App\Entity\ProductPeriodPrice | No errors. |
| App\Entity\TarifDegressif | No errors. |
| App\Entity\EquipementsCuisine | No errors. |
| App\Entity\SalleDeBain | No errors. |
| App\Entity\AccessoiresDeChambre | No errors. |
| App\Entity\MobilierExterieur | No errors. |
| App\Entity\Notification | No errors. |
| App\Entity\User | No errors. |
| App\Entity\AdminPromo | No errors. |
| App\Entity\PlanningCompany | No errors. |
| App\Entity\WishList | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\Annonce | No errors. |
| App\Entity\Messaging | No errors. |
| App\Entity\Payout | No errors. |
| App\Entity\Abonnement |
|
| App\Entity\ReseauSociaux\Conversation |
|
| App\Entity\ReseauSociaux\Message | No errors. |
| App\Entity\ReseauSociaux\Espace | No errors. |
| App\Entity\ReseauSociaux\Notifications | No errors. |
| App\Entity\ReseauSociaux\PostLike | No errors. |