GET https://yekaproduction.yt/client/demande/mariage/601/voir

Query Metrics

7 Database Queries
7 Different statements
34.04 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 10.08 ms
SELECT t0.id AS id_1, t0.status AS status_2, t0.creation_datetime AS creation_datetime_3, t0.signature AS signature_4, t0.signature_datetime AS signature_datetime_5, t0.relationship AS relationship_6, t0.event_location AS event_location_7, t0.event_datetime AS event_datetime_8, t0.bride_last_name AS bride_last_name_9, t0.bride_first_name AS bride_first_name_10, t0.bride_phone_number AS bride_phone_number_11, t0.groom_last_name AS groom_last_name_12, t0.groom_first_name AS groom_first_name_13, t0.groom_phone_number AS groom_phone_number_14, t0.rhythm_style_and_cadence AS rhythm_style_and_cadence_15, t0.favorite_music_from_zily AS favorite_music_from_zily_16, t0.stories AS stories_17, t0.expectations AS expectations_18, t0.message_to_be_conveyed AS message_to_be_conveyed_19, t0.delivery_datetime AS delivery_datetime_20, t0.imported AS imported_21, t0.ebp_code AS ebp_code_22, t0.comment AS comment_23, t0.paid_amount AS paid_amount_24, t0.paid_at AS paid_at_25, t0.customer_id AS customer_id_26, t0.beatmaker_id AS beatmaker_id_27, t0.bank_configuration_id AS bank_configuration_id_28 FROM wedding_song t0 WHERE t0.id = ?
Parameters:
[
  "601"
]
2 1.95 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.phone_number AS phone_number_7, t0.civility AS civility_8, t0.address AS address_9, t0.village AS village_10, t0.postal_code AS postal_code_11, t0.active AS active_12, t0.reset_token AS reset_token_13, t0.reset_token_date_time AS reset_token_date_time_14, t0.imported AS imported_15 FROM customer t0 WHERE t0.id = ?
Parameters:
[
  1363
]
3 11.69 ms
SELECT t0.id AS id_1, t0.base_price AS base_price_2, t0.additional_price AS additional_price_3 FROM pricing_configuration t0
Parameters:
[]
4 0.81 ms
SELECT w0_.id AS id_0, w0_.first_name AS first_name_1, w0_.relationship AS relationship_2, w0_.bride_or_groom AS bride_or_groom_3, w0_.position AS position_4, w0_.song_id AS song_id_5 FROM wedding_person w0_ WHERE w0_.song_id = ? ORDER BY w0_.position ASC
Parameters:
[
  601
]
5 1.53 ms
SELECT s0_.id AS id_0, s0_.song_type AS song_type_1, s0_.song_id AS song_id_2, s0_.old_status AS old_status_3, s0_.new_status AS new_status_4, s0_.changed_at AS changed_at_5, s0_.actor_type AS actor_type_6, s0_.actor_identifier AS actor_identifier_7, s0_.note AS note_8 FROM song_status_history s0_ WHERE s0_.song_type = ? AND s0_.song_id = ? ORDER BY s0_.changed_at DESC
Parameters:
[
  "wedding"
  601
]
6 7.31 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.paid_at AS paid_at_3, t0.payment_method AS payment_method_4, t0.note AS note_5, t0.created_at AS created_at_6, t0.birthday_song_id AS birthday_song_id_7, t0.wedding_song_id AS wedding_song_id_8, t0.bank_configuration_id AS bank_configuration_id_9 FROM payment t0 WHERE t0.wedding_song_id = ?
Parameters:
[
  601
]
7 0.67 ms
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.relationship AS relationship_3, t0.bride_or_groom AS bride_or_groom_4, t0.position AS position_5, t0.song_id AS song_id_6 FROM wedding_person t0 WHERE t0.song_id = ?
Parameters:
[
  601
]

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