Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• E-mails
• Notifications
• Serializer
• Configuration

Query Metrics

Grouped Statements

Show all queries

SELECT s0_.offer_type AS offer_type_0, s0_.id AS id_1, s0_.status AS status_2, s0_.search AS search_3, s0_.location AS location_4, s0_.distance AS distance_5, s0_.working_time AS working_time_6, s0_.working_experience AS working_experience_7, s0_.contract_type AS contract_type_8, s0_.new_jobs AS new_jobs_9, s0_.hits AS hits_10, s0_.unread AS unread_11, s0_.start_date AS start_date_12, s0_.end_date AS end_date_13, s0_.updated_at AS updated_at_14, s0_.created_at AS created_at_15, s0_.edited_by AS edited_by_16, s0_.created_by AS created_by_17 FROM search s0_ WHERE s0_.status = ? ORDER BY s0_.created_at DESC LIMIT 10

[
  "live"
]

SELECT
  s0_.offer_type AS offer_type_0,
  s0_.id AS id_1,
  s0_.status AS status_2,
  s0_.search AS search_3,
  s0_.location AS location_4,
  s0_.distance AS distance_5,
  s0_.working_time AS working_time_6,
  s0_.working_experience AS working_experience_7,
  s0_.contract_type AS contract_type_8,
  s0_.new_jobs AS new_jobs_9,
  s0_.hits AS hits_10,
  s0_.unread AS unread_11,
  s0_.start_date AS start_date_12,
  s0_.end_date AS end_date_13,
  s0_.updated_at AS updated_at_14,
  s0_.created_at AS created_at_15,
  s0_.edited_by AS edited_by_16,
  s0_.created_by AS created_by_17
FROM
  search s0_
WHERE
  s0_.status = ?
ORDER BY
  s0_.created_at DESC
LIMIT
  10

SELECT s0_.offer_type AS offer_type_0, s0_.id AS id_1, s0_.status AS status_2, s0_.search AS search_3, s0_.location AS location_4, s0_.distance AS distance_5, s0_.working_time AS working_time_6, s0_.working_experience AS working_experience_7, s0_.contract_type AS contract_type_8, s0_.new_jobs AS new_jobs_9, s0_.hits AS hits_10, s0_.unread AS unread_11, s0_.start_date AS start_date_12, s0_.end_date AS end_date_13, s0_.updated_at AS updated_at_14, s0_.created_at AS created_at_15, s0_.edited_by AS edited_by_16, s0_.created_by AS created_by_17 FROM search s0_ WHERE s0_.status = 'live' ORDER BY s0_.created_at DESC LIMIT 10;

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.image AS image_7, t0.last_login AS last_login_8, t0.updated_at AS updated_at_9, t0.created_at AS created_at_10 FROM `user` t0 WHERE t0.id = ?

[
  43
]

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.image AS image_7,
  t0.last_login AS last_login_8,
  t0.updated_at AS updated_at_9,
  t0.created_at AS created_at_10
FROM
  `user` t0
WHERE
  t0.id = ?

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.image AS image_7, t0.last_login AS last_login_8, t0.updated_at AS updated_at_9, t0.created_at AS created_at_10 FROM `user` t0 WHERE t0.id = 43;

Database Connections

Entity Managers

Second Level Cache

Entities Mapping