POST https://manager.dreammusicevent.com/workspace/equipement/stockavailable

Query Metrics

17 Database Queries
7 Different statements
5.75 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 0.35 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 FROM user t0 WHERE t0.id = ?
Parameters:
[
  3
]
2 0.43 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:
[
  "1074"
]
3 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.reference AS reference_3, t0.description AS description_4, t0.association AS association_5, t0.localisation AS localisation_6, t0.quantity AS quantity_7, t0.type_id AS type_id_8 FROM material t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "23"
]
4 1.16 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_ WHERE e0_.start_at BETWEEN ? AND ?
Parameters:
[
  "2026-06-19 10:56:00"
  "2026-06-21 10:56:00"
]
5 0.23 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:
[
  1488
]
6 0.23 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:
[
  2010
]
7 0.20 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:
[
  2117
]
8 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:
[
  2162
]
9 0.37 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.event_id = ?
Parameters:
[
  1074
]
10 0.24 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.material_id AS material_id_3, t0.material_pack_id AS material_pack_id_4, t0.quote_id AS quote_id_5, t0.event_id AS event_id_6 FROM quote_material t0 WHERE t0.quote_id = ?
Parameters:
[
  302
]
11 0.38 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.event_id = ?
Parameters:
[
  1488
]
12 0.18 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.material_id AS material_id_3, t0.material_pack_id AS material_pack_id_4, t0.quote_id AS quote_id_5, t0.event_id AS event_id_6 FROM quote_material t0 WHERE t0.quote_id = ?
Parameters:
[
  413
]
13 0.36 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.event_id = ?
Parameters:
[
  2010
]
14 0.22 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.material_id AS material_id_3, t0.material_pack_id AS material_pack_id_4, t0.quote_id AS quote_id_5, t0.event_id AS event_id_6 FROM quote_material t0 WHERE t0.quote_id = ?
Parameters:
[
  645
]
15 0.38 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.event_id = ?
Parameters:
[
  2117
]
16 0.19 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.material_id AS material_id_3, t0.material_pack_id AS material_pack_id_4, t0.quote_id AS quote_id_5, t0.event_id AS event_id_6 FROM quote_material t0 WHERE t0.quote_id = ?
Parameters:
[
  686
]
17 0.29 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.event_id = ?
Parameters:
[
  2162
]

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\Material
  • The association App\Entity\Material#type refers to the inverse side field App\Entity\Option#materials which does not exist.
  • The association App\Entity\Material#materialPacks refers to the owning side field App\Entity\MaterialPack#materials which does not exist.
App\Entity\Option No errors.
App\Entity\MaterialPack No errors.
App\Entity\MaterialPackLine 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.