POST http://portail.groupementacp.fr/cabinet/evenements/inscription/27/edit

Query Metrics

30 Database Queries
16 Different statements
17.32 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
5.14 ms
(29.69%)
6
"COMMIT"
Parameters:
[]
1.27 ms
(7.36%)
2
SELECT t0.id AS id_1, t0.lastname AS lastname_2, t0.firstname AS firstname_3, t0.job AS job_4, t0.email AS email_5, t0.phone AS phone_6, t0.present AS present_7, t0.deleted_at AS deleted_at_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.event_broker_id AS event_broker_id_11, t0.deleted_by_id AS deleted_by_id_12, t0.created_by_id AS created_by_id_13, t0.updated_by_id AS updated_by_id_14 FROM event_broker_guest t0 WHERE t0.event_broker_id = ?
Parameters:
[
  27
]
1.24 ms
(7.16%)
2
UPDATE event_broker SET updated_at = ? WHERE id = ?
Parameters:
[
  "2025-09-23 19:08:07"
  27
]
1.16 ms
(6.68%)
6
"START TRANSACTION"
Parameters:
[]
1.04 ms
(5.99%)
2
SELECT t0.id AS id_1, t0.selected AS selected_2, t0.event_option_proposal_id AS event_option_proposal_id_3, t0.event_broker_option_id AS event_broker_option_id_4 FROM event_broker_option_proposal t0 WHERE t0.event_broker_option_id = ?
Parameters:
[
  27
]
0.97 ms
(5.57%)
2
DELETE FROM event_broker_option_proposal WHERE id = ?
Parameters:
[
  49
]
0.87 ms
(5.05%)
1
SELECT t1.id AS id_2, t1.gender AS gender_3, t1.email AS email_4, t1.roles AS roles_5, t1.password AS password_6, t1.last_logged_at AS last_logged_at_7, t1.firstname AS firstname_8, t1.lastname AS lastname_9, t1.active AS active_10, t1.phone AS phone_11, t1.deleted_at AS deleted_at_12, t1.created_at AS created_at_13, t1.updated_at AS updated_at_14, t0.is_visible AS is_visible_15, t1.image_id AS image_id_16, t1.address_id AS address_id_17, t0.cabinet_id AS cabinet_id_18, t1.type FROM user_broker t0 INNER JOIN user t1 ON t0.id = t1.id WHERE t1.id = ?
Parameters:
[
  40
]
0.84 ms
(4.86%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.visible AS visible_4, t0.start_at AS start_at_5, t0.end_at AS end_at_6, t0.registration AS registration_7, t0.end_subscription_at AS end_subscription_at_8, t0.meet_link AS meet_link_9, t0.max_brokers AS max_brokers_10, t0.max_guests AS max_guests_11, t0.available_place AS available_place_12, t0.duration AS duration_13, t0.theme AS theme_14, t0.deleted_at AS deleted_at_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.category_id AS category_id_18, t0.address_id AS address_id_19, t0.event_group_id AS event_group_id_20, t0.deleted_by_id AS deleted_by_id_21, t0.created_by_id AS created_by_id_22, t0.updated_by_id AS updated_by_id_23 FROM event t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.83 ms
(4.80%)
1
SELECT t0.id AS id_4, t0.gender AS gender_5, t0.email AS email_6, t0.roles AS roles_7, t0.password AS password_8, t0.last_logged_at AS last_logged_at_9, t0.firstname AS firstname_10, t0.lastname AS lastname_11, t0.active AS active_12, t0.phone AS phone_13, t0.deleted_at AS deleted_at_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.image_id AS image_id_17, t0.address_id AS address_id_18, t0.type, t3.is_visible AS is_visible_19, t3.cabinet_id AS cabinet_id_20 FROM user t0 LEFT JOIN user_administrator t1 ON t0.id = t1.id LEFT JOIN user_member t2 ON t0.id = t2.id LEFT JOIN user_broker t3 ON t0.id = t3.id WHERE t0.id = ?
Parameters:
[
  230
]
0.78 ms
(4.51%)
1
SELECT t0.id AS id_1, t0.selected AS selected_2, t0.value AS value_3, t0.event_option_id AS event_option_id_4, t0.event_broker_id AS event_broker_id_5 FROM event_broker_option t0 WHERE t0.event_broker_id = ?
Parameters:
[
  27
]
0.75 ms
(4.34%)
1
SELECT t0.id AS id_1, t0.participate AS participate_2, t0.present AS present_3, t0.comment AS comment_4, t0.deleted_at AS deleted_at_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.event_id AS event_id_8, t0.broker_id AS broker_id_9, t0.deleted_by_id AS deleted_by_id_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12 FROM event_broker t0 WHERE t0.id = ?
Parameters:
[
  "27"
]
0.57 ms
(3.29%)
1
DELETE FROM event_broker_option WHERE id = ?
Parameters:
[
  27
]
0.51 ms
(2.93%)
1
INSERT INTO event_broker_option (selected, value, event_option_id, event_broker_id) VALUES (?, ?, ?, ?)
Parameters:
[
  null
  null
  1
  27
]
0.49 ms
(2.81%)
1
INSERT INTO event_broker_option_proposal (selected, event_option_proposal_id, event_broker_option_id) VALUES (?, ?, ?)
Parameters:
[
  1
  1
  112
]
0.45 ms
(2.62%)
1
SELECT t0.id AS id_1, t0.selected AS selected_2, t0.value AS value_3, t0.event_option_id AS event_option_id_4, t0.event_broker_id AS event_broker_id_5 FROM event_broker_option t0 WHERE t0.event_broker_id = ? AND t0.event_option_id = ? LIMIT 1
Parameters:
[
  27
  1
]
0.41 ms
(2.34%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.price AS price_4, t0.max_brokers AS max_brokers_5, t0.event_id AS event_id_6 FROM event_option t0 WHERE t0.id = ?
Parameters:
[
  1
]

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\User\Broker No errors.
App\Entity\Image No errors.
App\Entity\Address No errors.
App\Entity\Cabinet No errors.
App\Entity\Settings\Notification No errors.
App\Entity\Settings\NotificationType No errors.
App\Entity\Question\Question No errors.
App\Entity\Event\EventBroker No errors.
App\Entity\Event\Event
  • The mappings App\Entity\Event\Event#category and App\Entity\Event\EventCategory#events are inconsistent with each other.
App\Entity\Event\EventBrokerOption No errors.
App\Entity\Event\EventBrokerGuest No errors.
App\Entity\Event\EventCategory
  • The association App\Entity\Event\EventCategory#events refers to the owning side field App\Entity\Event\Event#categoy which does not exist.
App\Entity\Event\EventGroup No errors.
Vich\UploaderBundle\Entity\File No errors.
App\Entity\Document\Document No errors.
App\Entity\Event\EventOption No errors.
App\Entity\Event\EventPost No errors.
App\Entity\User\Administrator No errors.
App\Entity\User\Member No errors.
App\Entity\Event\EventBrokerOptionProposal No errors.
App\Entity\Event\EventOptionProposal No errors.