POST http://royal-palace.com/backoffrp/resa_refresh

Query Metrics

4 Database Queries
4 Different statements
4.89 ms Query time
0 Invalid entities
100 Managed entities

Queries

Group similar statements

# Time Info
1 1.21 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.password AS password_4, t0.forgot AS forgot_5, t0.roles AS roles_6, t0.infos AS infos_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.logged_at AS logged_at_10, t0.deleted AS deleted_11, t0.email_recap AS email_recap_12 FROM framework_user t0 WHERE t0.id = ?
Parameters:
[
  3
]
2 2.54 ms
SELECT t0.id AS id_1, t0.gen_id AS gen_id_2, t0.base_id AS base_id_3, t0.old_id AS old_id_4, t0.token AS token_5, t0.infos AS infos_6, t0.cart AS cart_7, t0.result AS result_8, t0.status AS status_9, t0.state AS state_10, t0.payment_type AS payment_type_11, t0.amount AS amount_12, t0.amount_show AS amount_show_13, t0.options AS options_14, t0.transfered AS transfered_15, t0.mailed AS mailed_16, t0.mailed_pay AS mailed_pay_17, t0.mailed_count AS mailed_count_18, t0.exported AS exported_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.venue_title AS venue_title_22, t0.email_content AS email_content_23, t0.lang AS lang_24, t0.is_flash AS is_flash_25, t0.action AS action_26, t0.alerting AS alerting_27, t0.venue_id AS venue_id_28, t29.id AS id_30, t29.title AS title_31, t29.slug AS slug_32, t29.description AS description_33, t29.thumbnail AS thumbnail_34, t29.start AS start_35, t29.end AS end_36, t29.season AS season_37, t29.force_day AS force_day_38, t29.deleted AS deleted_39, t29.created_at AS created_at_40, t29.updated_at AS updated_at_41, t29.is_full AS is_full_42, t29.concert_id AS concert_id_43, t29.venue_type_id AS venue_type_id_44, t0.user_id AS user_id_45, t46.id AS id_47, t46.username AS username_48, t46.email AS email_49, t46.password AS password_50, t46.forgot AS forgot_51, t46.roles AS roles_52, t46.infos AS infos_53, t46.created_at AS created_at_54, t46.updated_at AS updated_at_55, t46.logged_at AS logged_at_56, t46.deleted AS deleted_57, t46.email_recap AS email_recap_58 FROM framework_booking t0 LEFT JOIN framework_venue t29 ON t0.venue_id = t29.id LEFT JOIN framework_user t46 ON t0.user_id = t46.id WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "64549"
  "64548"
  "64547"
  "64546"
  "64545"
  "64544"
  "64543"
  "64542"
  "64541"
  "64540"
  "64539"
  "64538"
  "64536"
  "64535"
  "64534"
  "64533"
  "64532"
  "64531"
  "64529"
  "64528"
  "64527"
  "64526"
  "64524"
  "64523"
  "64521"
  "64520"
  "64519"
  "64518"
  "64516"
  "64509"
  "64507"
  "64506"
  "64502"
  "64499"
  "64460"
  "64289"
]
3 0.71 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.title AS title_3, t0.description AS description_4, t0.thumbnail AS thumbnail_5, t0.season AS season_6, t0.position AS position_7, t0.food AS food_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM framework_venue_type t0 WHERE t0.id IN (?, ?, ?, ?, ?)
Parameters:
[
  32
  35
  36
  38
  34
]
4 0.43 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.thumbnail AS thumbnail_4, t0.infos AS infos_5, t0.start AS start_6, t0.end AS end_7, t0.published AS published_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM framework_concert t0 WHERE t0.id IN (?)
Parameters:
[
  18
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Framework\AppBundle\Entity\Booking 36
App\Framework\AppBundle\Entity\User 33
App\Framework\AppBundle\Entity\Venue 25
App\Framework\AppBundle\Entity\VenueType 5
App\Framework\AppBundle\Entity\Concert 1