GET https://manager.dreammusicevent.com/workspace/calendar/quickview/2261/event

Query Metrics

15 Database Queries
13 Different statements
10.22 ms Query time
2 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.39 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.permissions AS permissions_4, t0.password AS password_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.is_calendar_delete AS is_calendar_delete_8, t0.is_alerts AS is_alerts_9, t0.topbar_shortcuts AS topbar_shortcuts_10 FROM user t0 WHERE t0.id = ?
Parameters:
[
  2
]
2 0.42 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4, t0.description AS description_5, t0.place AS place_6, t0.color AS color_7, t0.lat AS lat_8, t0.lng AS lng_9, t0.is_recurrent AS is_recurrent_10, t0.recurrent_type AS recurrent_type_11, t0.stop_reccurent_at AS stop_reccurent_at_12, t0.file AS file_13, t0.team_arrival_at AS team_arrival_at_14, t0.customer_id AS customer_id_15, t0.information_sheet_id AS information_sheet_id_16, t17.id AS id_18, t17.cocktail_entrance AS cocktail_entrance_19, t17.cocktail_music AS cocktail_music_20, t17.entrance_type AS entrance_type_21, t17.entrance_placement AS entrance_placement_22, t17.entrance_music AS entrance_music_23, t17.open_bal_type AS open_bal_type_24, t17.open_bal_value AS open_bal_value_25, t17.champagne_type AS champagne_type_26, t17.champagne_music AS champagne_music_27, t17.blacklist AS blacklist_28, t17.bestlist AS bestlist_29, t17.is_complete AS is_complete_30, t17.cocktail_note AS cocktail_note_31, t17.note AS note_32, t17.entrance_note AS entrance_note_33, t17.open_bar_note AS open_bar_note_34, t17.champagne_note AS champagne_note_35, t17.cocktail_music_file AS cocktail_music_file_36, t17.champagne_music_file AS champagne_music_file_37, t17.cocktail_bouquet AS cocktail_bouquet_38, t17.cocktail_bouquet_music AS cocktail_bouquet_music_39, t17.cocktail_bouquet_music_file AS cocktail_bouquet_music_file_40, t17.cocktail_bouquet_note AS cocktail_bouquet_note_41, t17.customer_id AS customer_id_42, t17.event_id AS event_id_43, t17.quote_id AS quote_id_44, t0.author_id AS author_id_45 FROM event t0 LEFT JOIN wedding t17 ON t17.event_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
  "2261"
]
3 0.41 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.event_id AS event_id_3, t0.provider_id AS provider_id_4 FROM notification_provider t0 WHERE t0.event_id = ?
Parameters:
[
  2261
]
4 0.41 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.presta_type AS presta_type_3, t0.compta_id AS compta_id_4, t0.created_at AS created_at_5, t0.discount_money AS discount_money_6, t0.discount_percent AS discount_percent_7, t0.tva_rate AS tva_rate_8, t0.state AS state_9, t0.zone_title AS zone_title_10, t0.zone_price AS zone_price_11, t0.rythme AS rythme_12, t0.is_check_presta AS is_check_presta_13, t0.sent_at AS sent_at_14, t0.customer_id AS customer_id_15, t0.context_id AS context_id_16, t0.information_sheet_id AS information_sheet_id_17, t0.event_id AS event_id_18, t19.id AS id_20, t19.cocktail_entrance AS cocktail_entrance_21, t19.cocktail_music AS cocktail_music_22, t19.entrance_type AS entrance_type_23, t19.entrance_placement AS entrance_placement_24, t19.entrance_music AS entrance_music_25, t19.open_bal_type AS open_bal_type_26, t19.open_bal_value AS open_bal_value_27, t19.champagne_type AS champagne_type_28, t19.champagne_music AS champagne_music_29, t19.blacklist AS blacklist_30, t19.bestlist AS bestlist_31, t19.is_complete AS is_complete_32, t19.cocktail_note AS cocktail_note_33, t19.note AS note_34, t19.entrance_note AS entrance_note_35, t19.open_bar_note AS open_bar_note_36, t19.champagne_note AS champagne_note_37, t19.cocktail_music_file AS cocktail_music_file_38, t19.champagne_music_file AS champagne_music_file_39, t19.cocktail_bouquet AS cocktail_bouquet_40, t19.cocktail_bouquet_music AS cocktail_bouquet_music_41, t19.cocktail_bouquet_music_file AS cocktail_bouquet_music_file_42, t19.cocktail_bouquet_note AS cocktail_bouquet_note_43, t19.customer_id AS customer_id_44, t19.event_id AS event_id_45, t19.quote_id AS quote_id_46 FROM quote t0 LEFT JOIN wedding t19 ON t19.quote_id = t0.id WHERE t0.event_id = ?
Parameters:
[
  2261
]
5 1.57 ms
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.start_at AS start_at_2, e0_.end_at AS end_at_3, e0_.description AS description_4, e0_.place AS place_5, e0_.color AS color_6, e0_.lat AS lat_7, e0_.lng AS lng_8, e0_.is_recurrent AS is_recurrent_9, e0_.recurrent_type AS recurrent_type_10, e0_.stop_reccurent_at AS stop_reccurent_at_11, e0_.file AS file_12, e0_.team_arrival_at AS team_arrival_at_13, e0_.customer_id AS customer_id_14, e0_.information_sheet_id AS information_sheet_id_15, e0_.author_id AS author_id_16 FROM event e0_ LEFT JOIN wedding w1_ ON e0_.id = w1_.event_id WHERE (w1_.id IS NULL OR w1_.is_complete = 0 OR w1_.is_complete IS NULL) AND e0_.color = ? AND (e0_.start_at >= ? AND e0_.start_at <= ?)
Parameters:
[
  "Mariage"
  "2026-10-04 19:24:41"
  "2026-11-03 19:24:41"
]
6 1.75 ms
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.start_at AS start_at_2, e0_.end_at AS end_at_3, e0_.description AS description_4, e0_.place AS place_5, e0_.color AS color_6, e0_.lat AS lat_7, e0_.lng AS lng_8, e0_.is_recurrent AS is_recurrent_9, e0_.recurrent_type AS recurrent_type_10, e0_.stop_reccurent_at AS stop_reccurent_at_11, e0_.file AS file_12, e0_.team_arrival_at AS team_arrival_at_13, e0_.customer_id AS customer_id_14, e0_.information_sheet_id AS information_sheet_id_15, e0_.author_id AS author_id_16 FROM event e0_ LEFT JOIN wedding w1_ ON e0_.id = w1_.event_id WHERE (w1_.id IS NULL OR w1_.is_complete = 0 OR w1_.is_complete IS NULL) AND e0_.color = ? AND (e0_.start_at >= ? AND e0_.start_at <= ?)
Parameters:
[
  "Event Privé (Anniversaire/Baptême)"
  "2026-10-04 19:24:41"
  "2026-10-19 19:24:41"
]
7 0.28 ms
SELECT t0.id AS id_1, t0.cocktail_entrance AS cocktail_entrance_2, t0.cocktail_music AS cocktail_music_3, t0.entrance_type AS entrance_type_4, t0.entrance_placement AS entrance_placement_5, t0.entrance_music AS entrance_music_6, t0.open_bal_type AS open_bal_type_7, t0.open_bal_value AS open_bal_value_8, t0.champagne_type AS champagne_type_9, t0.champagne_music AS champagne_music_10, t0.blacklist AS blacklist_11, t0.bestlist AS bestlist_12, t0.is_complete AS is_complete_13, t0.cocktail_note AS cocktail_note_14, t0.note AS note_15, t0.entrance_note AS entrance_note_16, t0.open_bar_note AS open_bar_note_17, t0.champagne_note AS champagne_note_18, t0.cocktail_music_file AS cocktail_music_file_19, t0.champagne_music_file AS champagne_music_file_20, t0.cocktail_bouquet AS cocktail_bouquet_21, t0.cocktail_bouquet_music AS cocktail_bouquet_music_22, t0.cocktail_bouquet_music_file AS cocktail_bouquet_music_file_23, t0.cocktail_bouquet_note AS cocktail_bouquet_note_24, t0.customer_id AS customer_id_25, t0.event_id AS event_id_26, t0.quote_id AS quote_id_27 FROM wedding t0 WHERE t0.event_id = ?
Parameters:
[
  1528
]
8 0.93 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.presta_type AS presta_type_3, t0.compta_id AS compta_id_4, t0.created_at AS created_at_5, t0.discount_money AS discount_money_6, t0.discount_percent AS discount_percent_7, t0.tva_rate AS tva_rate_8, t0.state AS state_9, t0.zone_title AS zone_title_10, t0.zone_price AS zone_price_11, t0.rythme AS rythme_12, t0.is_check_presta AS is_check_presta_13, t0.sent_at AS sent_at_14, t0.customer_id AS customer_id_15, t0.context_id AS context_id_16, t0.information_sheet_id AS information_sheet_id_17, t0.event_id AS event_id_18, t19.id AS id_20, t19.cocktail_entrance AS cocktail_entrance_21, t19.cocktail_music AS cocktail_music_22, t19.entrance_type AS entrance_type_23, t19.entrance_placement AS entrance_placement_24, t19.entrance_music AS entrance_music_25, t19.open_bal_type AS open_bal_type_26, t19.open_bal_value AS open_bal_value_27, t19.champagne_type AS champagne_type_28, t19.champagne_music AS champagne_music_29, t19.blacklist AS blacklist_30, t19.bestlist AS bestlist_31, t19.is_complete AS is_complete_32, t19.cocktail_note AS cocktail_note_33, t19.note AS note_34, t19.entrance_note AS entrance_note_35, t19.open_bar_note AS open_bar_note_36, t19.champagne_note AS champagne_note_37, t19.cocktail_music_file AS cocktail_music_file_38, t19.champagne_music_file AS champagne_music_file_39, t19.cocktail_bouquet AS cocktail_bouquet_40, t19.cocktail_bouquet_music AS cocktail_bouquet_music_41, t19.cocktail_bouquet_music_file AS cocktail_bouquet_music_file_42, t19.cocktail_bouquet_note AS cocktail_bouquet_note_43, t19.customer_id AS customer_id_44, t19.event_id AS event_id_45, t19.quote_id AS quote_id_46 FROM quote t0 LEFT JOIN wedding t19 ON t19.quote_id = t0.id WHERE t0.is_check_presta = ?
Parameters:
[
  1
]
9 2.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.tva_rate AS tva_rate_3, t0.header_information AS header_information_4, t0.footer_information AS footer_information_5, t0.logo AS logo_6, t0.color AS color_7, t0.base AS base_8, t0.cgv AS cgv_9, t0.welcome AS welcome_10, t0.mail_send_invoice AS mail_send_invoice_11, t0.mail_send_quote AS mail_send_quote_12, t0.mail_send_wedding AS mail_send_wedding_13, t0.company AS company_14, t0.iban AS iban_15, t0.bic AS bic_16 FROM context t0
Parameters:
[]
10 0.29 ms
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.address AS address_4, t0.postal AS postal_5, t0.city AS city_6, t0.country AS country_7, t0.phone AS phone_8, t0.email AS email_9, t0.company AS company_10, t0.is_pro AS is_pro_11, t0.duo_identity AS duo_identity_12, t0.note AS note_13, t0.job AS job_14, t0.age AS age_15, t0.origin AS origin_16, t0.source AS source_17, t0.public_token AS public_token_18, t0.context_id AS context_id_19 FROM customer t0 WHERE t0.id = ?
Parameters:
[
  5
]
11 0.23 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.permissions AS permissions_4, t0.password AS password_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.is_calendar_delete AS is_calendar_delete_8, t0.is_alerts AS is_alerts_9, t0.topbar_shortcuts AS topbar_shortcuts_10 FROM user t0 WHERE t0.id = ?
Parameters:
[
  3
]
12 0.48 ms
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.company AS company_4, t0.address AS address_5, t0.postal AS postal_6, t0.city AS city_7, t0.country AS country_8, t0.phone AS phone_9, t0.email AS email_10, t0.type AS type_11, t0.note AS note_12, t0.file AS file_13, t0.is_commission AS is_commission_14, t0.context_id AS context_id_15 FROM provider t0 INNER JOIN event_provider ON t0.id = event_provider.provider_id WHERE event_provider.event_id = ?
Parameters:
[
  2261
]
13 0.25 ms
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.phone AS phone_5, t0.job AS job_6, t0.age AS age_7, t0.origin AS origin_8, t0.customer_id AS customer_id_9 FROM customer_contact t0 WHERE t0.customer_id = ?
Parameters:
[
  5
]
14 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.compta_id AS compta_id_4, t0.state AS state_5, t0.paid_at AS paid_at_6, t0.sent_at AS sent_at_7, t0.tva_rate AS tva_rate_8, t0.presta_type AS presta_type_9, t0.is_credit_invoice AS is_credit_invoice_10, t0.compta_id_credit_invoice AS compta_id_credit_invoice_11, t0.credit_invoice_created_at AS credit_invoice_created_at_12, t0.payment_mode AS payment_mode_13, t0.payment_mode_number AS payment_mode_number_14, t0.reference AS reference_15, t0.notification_email AS notification_email_16, t0.discount_money AS discount_money_17, t0.discount_percent AS discount_percent_18, t0.customer_id AS customer_id_19, t0.quote_id AS quote_id_20, t0.context_id AS context_id_21, t0.event_id AS event_id_22 FROM invoice t0 WHERE t0.event_id = ?
Parameters:
[
  2261
]
15 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.file AS file_3, t0.customer_id AS customer_id_4 FROM file t0 WHERE t0.customer_id = ?
Parameters:
[
  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.

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Event No errors.
App\Entity\Customer No errors.
App\Entity\InformationSheet No errors.
App\Entity\Wedding
  • The mappings App\Entity\Wedding#weddingCocktailSurprises and App\Entity\WeddingCocktailSurprise#wedding are inconsistent with each other.
  • The mappings App\Entity\Wedding#weddingEntranceSurprises and App\Entity\WeddingEntranceSurprise#wedding are inconsistent with each other.
  • The mappings App\Entity\Wedding#openBalSurprises and App\Entity\OpenBalSurprise#wedding are inconsistent with each other.
  • The mappings App\Entity\Wedding#weddingChampagneSurprises and App\Entity\WeddingChampagneSurprise#wedding are inconsistent with each other.
App\Entity\Quote No errors.
App\Entity\EventFile No errors.
App\Entity\Invoice No errors.
App\Entity\Provider No errors.
App\Entity\NotificationProvider No errors.
App\Entity\Context No errors.
App\Entity\QuoteLine No errors.
App\Entity\CostLine No errors.
App\Entity\QuoteMaterial
  • The association App\Entity\QuoteMaterial#event refers to the inverse side field App\Entity\Event#quoteMaterials which does not exist.
App\Entity\WeddingMusic No errors.
App\Entity\WeddingGenre No errors.
App\Entity\WeddingDeroulement No errors.
App\Entity\WeddingDeroulementSurprise No errors.
App\Entity\WeddingCocktail No errors.
App\Entity\WeddingCocktailSurprise No errors.
App\Entity\WeddingEntranceSurprise No errors.
App\Entity\OpenBalSurprise No errors.
App\Entity\WeddingChampagneSurprise No errors.
App\Entity\WeddingEntrance No errors.
App\Entity\WeddingOpenBal No errors.
App\Entity\File No errors.
App\Entity\CustomerContact No errors.