Symfony Profiler

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

Query Metrics

SELECT t0.role AS role_1, t0.email AS email_2, t0.password AS password_3, t0.id AS id_4, t0.version AS version_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.operator_id AS operator_id_8 FROM employees t0 WHERE t0.email = ? LIMIT 1

[
  "milena@fokus.waw.pl"
]

SELECT
  t0.role AS role_1,
  t0.email AS email_2,
  t0.password AS password_3,
  t0.id AS id_4,
  t0.version AS version_5,
  t0.first_name AS first_name_6,
  t0.last_name AS last_name_7,
  t0.operator_id AS operator_id_8
FROM
  employees t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.role AS role_1, t0.email AS email_2, t0.password AS password_3, t0.id AS id_4, t0.version AS version_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.operator_id AS operator_id_8 FROM employees t0 WHERE t0.email = 'milena@fokus.waw.pl' LIMIT 1;

SELECT t0.code AS code_1, t0.position AS position_2, t0.id AS id_3, t0.version AS version_4, t0.name AS name_5, t0.text_color AS text_color_6, t0.text_background_color AS text_background_color_7, t0.operator_id AS operator_id_8, t0.discriminator FROM dictionaries t0 WHERE t0.id = ? AND t0.discriminator IN ('offer_status')

[
  1
]

SELECT
  t0.code AS code_1,
  t0.position AS position_2,
  t0.id AS id_3,
  t0.version AS version_4,
  t0.name AS name_5,
  t0.text_color AS text_color_6,
  t0.text_background_color AS text_background_color_7,
  t0.operator_id AS operator_id_8,
  t0.discriminator
FROM
  dictionaries t0
WHERE
  t0.id = ?
  AND t0.discriminator IN ('offer_status')

SELECT t0.code AS code_1, t0.position AS position_2, t0.id AS id_3, t0.version AS version_4, t0.name AS name_5, t0.text_color AS text_color_6, t0.text_background_color AS text_background_color_7, t0.operator_id AS operator_id_8, t0.discriminator FROM dictionaries t0 WHERE t0.id = 1 AND t0.discriminator IN ('offer_status');

SELECT t0.registration_timestamp AS registration_timestamp_1, t0.id AS id_2, t0.version AS version_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.notes AS notes_6, t0.email AS email_7, t0.phone AS phone_8, t0.organization_id AS organization_id_9, t0.operator_id AS operator_id_10 FROM clients t0 WHERE t0.id = ?

[
  9609
]

SELECT
  t0.registration_timestamp AS registration_timestamp_1,
  t0.id AS id_2,
  t0.version AS version_3,
  t0.first_name AS first_name_4,
  t0.last_name AS last_name_5,
  t0.notes AS notes_6,
  t0.email AS email_7,
  t0.phone AS phone_8,
  t0.organization_id AS organization_id_9,
  t0.operator_id AS operator_id_10
FROM
  clients t0
WHERE
  t0.id = ?

SELECT t0.registration_timestamp AS registration_timestamp_1, t0.id AS id_2, t0.version AS version_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.notes AS notes_6, t0.email AS email_7, t0.phone AS phone_8, t0.organization_id AS organization_id_9, t0.operator_id AS operator_id_10 FROM clients t0 WHERE t0.id = 9609;

SELECT t0.name AS name_1, t0.short_name AS short_name_2, t0.tin AS tin_3, t0.id AS id_4, t0.version AS version_5, t0.notes AS notes_6, t0.email AS email_7, t0.phone AS phone_8, t0.address_line AS address_line_9, t0.address_postal_code AS address_postal_code_10, t0.address_city AS address_city_11, t0.address_country_code AS address_country_code_12, t0.address_google_place AS address_google_place_13, t0.operator_id AS operator_id_14 FROM organizations t0 WHERE t0.id = ?

[
  2054
]

SELECT
  t0.name AS name_1,
  t0.short_name AS short_name_2,
  t0.tin AS tin_3,
  t0.id AS id_4,
  t0.version AS version_5,
  t0.notes AS notes_6,
  t0.email AS email_7,
  t0.phone AS phone_8,
  t0.address_line AS address_line_9,
  t0.address_postal_code AS address_postal_code_10,
  t0.address_city AS address_city_11,
  t0.address_country_code AS address_country_code_12,
  t0.address_google_place AS address_google_place_13,
  t0.operator_id AS operator_id_14
FROM
  organizations t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.short_name AS short_name_2, t0.tin AS tin_3, t0.id AS id_4, t0.version AS version_5, t0.notes AS notes_6, t0.email AS email_7, t0.phone AS phone_8, t0.address_line AS address_line_9, t0.address_postal_code AS address_postal_code_10, t0.address_city AS address_city_11, t0.address_country_code AS address_country_code_12, t0.address_google_place AS address_google_place_13, t0.operator_id AS operator_id_14 FROM organizations t0 WHERE t0.id = 2054;

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO offers (name, version, status_id, operator_id, creation_timestamp) VALUES (?, ?, ?, ?, CURRENT_TIMESTAMP) RETURNING "name" AS "name", "version" AS "version", "status_id" AS "status", "operator_id" AS "operator", "creation_timestamp" AS "creationTimestamp", "id" AS "id"

[
  "Kraków z Wieliczką lub Bochnią"
  1
  1
  1
]

INSERT INTO offers (
  name, version, status_id, operator_id,
  creation_timestamp
)
VALUES
  (?, ?, ?, ?, CURRENT_TIMESTAMP) RETURNING "name" AS "name",
  "version" AS "version",
  "status_id" AS "status",
  "operator_id" AS "operator",
  "creation_timestamp" AS "creationTimestamp",
  "id" AS "id"

INSERT INTO offers (name, version, status_id, operator_id, creation_timestamp) VALUES ('Kraków z Wieliczką lub Bochnią', 1, 1, 1, CURRENT_TIMESTAMP) RETURNING "name" AS "name", "version" AS "version", "status_id" AS "status", "operator_id" AS "operator", "creation_timestamp" AS "creationTimestamp", "id" AS "id";

SAVEPOINT DOCTRINE_2

[]

SAVEPOINT DOCTRINE_2

SAVEPOINT DOCTRINE_2;

UPDATE offers SET inquiry = ?, supervisor_id = ?, client_id = ?, organization_id = ?, creator_id = ?, version = version + 1 WHERE id = ? AND version = ?

[
  "<p>Kraków z Wieliczką lub Kraków z Bochnią 2 dni, nocleg we Wielczce lub w Bochni, dla ok 60 uczniów&nbsp; klas 5, chętnie podziemnia Sukiennice w programie, termin 22-23 lub 23-24.06&nbsp; tuż przed zakończeniem roku szkolnego</p>"
  8
  9609
  2054
  8
  730
  1
]

UPDATE
  offers
SET
  inquiry = ?,
  supervisor_id = ?,
  client_id = ?,
  organization_id = ?,
  creator_id = ?,
  version = version + 1
WHERE
  id = ?
  AND version = ?

UPDATE offers SET inquiry = '<p>Kraków z Wieliczką lub Kraków z Bochnią 2 dni, nocleg we Wielczce lub w Bochni, dla ok 60 uczniów&nbsp; klas 5, chętnie podziemnia Sukiennice w programie, termin 22-23 lub 23-24.06&nbsp; tuż przed zakończeniem roku szkolnego</p>', supervisor_id = 8, client_id = 9609, organization_id = 2054, creator_id = 8, version = version + 1 WHERE id = 730 AND version = 1;

SELECT version FROM offers WHERE id = ?

[
  730
]

SELECT
  version
FROM
  offers
WHERE
  id = ?

SELECT version FROM offers WHERE id = 730;

RELEASE SAVEPOINT DOCTRINE_2

[]

RELEASE SAVEPOINT DOCTRINE_2

RELEASE SAVEPOINT DOCTRINE_2;

"COMMIT"

[]

"COMMIT"

"COMMIT";