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

Response
200 OK
Browse referrer URL
IP
10.102.8.33
Profiled on
Token
50274a

Query Metrics

3 Database Queries
3 Different statements
9.94 ms Query time
0 Invalid entities
55 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.44 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
]
View formatted query    View runnable query    Explain query
2 7.52 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: 
[
  "64779"
  "64778"
  "64777"
  "64776"
  "64774"
  "64773"
  "64771"
  "64768"
  "64767"
  "64765"
  "64764"
  "64763"
  "64758"
  "64755"
  "64754"
  "64753"
  "64716"
  "64374"
]
View formatted query    View runnable query    Explain query
3 0.97 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: 
[
  35
  38
  32
  36
]
View formatted query    View runnable query    Explain query

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\User 18
App\Framework\AppBundle\Entity\Booking 18
App\Framework\AppBundle\Entity\Venue 15
App\Framework\AppBundle\Entity\VenueType 4

Entities Mapping

Class Mapping errors
App\Framework\AppBundle\Entity\User No errors.
App\Framework\AppBundle\Entity\Booking No errors.
App\Framework\AppBundle\Entity\Venue No errors.
App\Framework\AppBundle\Entity\Concert No errors.
App\Framework\AppBundle\Entity\VenueType No errors.
App\Framework\AppBundle\Entity\Places No errors.