Query Metrics
5
Database Queries
4
Different statements
5.84 ms
Query time
2
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 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-02-07 00:03:43" "2026-03-09 00:03:43" ] |
| 2 | 1.49 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-02-07 00:03:43" "2026-02-22 00:03:43" ] |
| 3 | 0.35 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:
[
2004
]
|
| 4 | 0.96 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.customer_id AS customer_id_14, t0.context_id AS context_id_15, t0.information_sheet_id AS information_sheet_id_16, t0.event_id AS event_id_17, t18.id AS id_19, t18.cocktail_entrance AS cocktail_entrance_20, t18.cocktail_music AS cocktail_music_21, t18.entrance_type AS entrance_type_22, t18.entrance_placement AS entrance_placement_23, t18.entrance_music AS entrance_music_24, t18.open_bal_type AS open_bal_type_25, t18.open_bal_value AS open_bal_value_26, t18.champagne_type AS champagne_type_27, t18.champagne_music AS champagne_music_28, t18.blacklist AS blacklist_29, t18.bestlist AS bestlist_30, t18.is_complete AS is_complete_31, t18.cocktail_note AS cocktail_note_32, t18.note AS note_33, t18.entrance_note AS entrance_note_34, t18.open_bar_note AS open_bar_note_35, t18.champagne_note AS champagne_note_36, t18.cocktail_music_file AS cocktail_music_file_37, t18.champagne_music_file AS champagne_music_file_38, t18.cocktail_bouquet AS cocktail_bouquet_39, t18.cocktail_bouquet_music AS cocktail_bouquet_music_40, t18.cocktail_bouquet_music_file AS cocktail_bouquet_music_file_41, t18.cocktail_bouquet_note AS cocktail_bouquet_note_42, t18.customer_id AS customer_id_43, t18.event_id AS event_id_44, t18.quote_id AS quote_id_45 FROM quote t0 LEFT JOIN wedding t18 ON t18.quote_id = t0.id WHERE t0.is_check_presta = ?
Parameters:
[
1
]
|
| 5 | 1.46 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:
[] |
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\Event | No errors. |
| App\Entity\Wedding |
|
| App\Entity\Customer | No errors. |
| App\Entity\InformationSheet | No errors. |
| App\Entity\User | No errors. |
| App\Entity\EventFile | No errors. |
| App\Entity\Invoice | No errors. |
| App\Entity\Quote | No errors. |
| 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\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 |
|