Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 23
• Events
• Routing
• Cache
• Translation 9
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Debug
• Emails
• Serializer
• Feature flags
• Vite
• Configuration

Query Metrics

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

SELECT *, ST_AsEWKT(coordinates) AS coordinates FROM vacancy_read WHERE status = ? ORDER BY created_at DESC LIMIT 5

[
  "public"
]

SELECT
  *,
  ST_AsEWKT(coordinates) AS coordinates
FROM
  vacancy_read
WHERE
  status = ?
ORDER BY
  created_at DESC
LIMIT
  5

SELECT *, ST_AsEWKT(coordinates) AS coordinates FROM vacancy_read WHERE status = 'public' ORDER BY created_at DESC LIMIT 5;

SELECT COUNT(id) FROM vacancy_read WHERE status = ?

[
  "public"
]

SELECT
  COUNT(id)
FROM
  vacancy_read
WHERE
  status = ?

SELECT COUNT(id) FROM vacancy_read WHERE status = 'public';

SELECT id
FROM vacancy_publication
WHERE vacancy_id = ?
ORDER BY published_at DESC
OFFSET 0 LIMIT 1

[
  "019d5367-e342-70e2-b367-8a51c0fb7764"
]

SELECT
  id
FROM
  vacancy_publication
WHERE
  vacancy_id = ?
ORDER BY
  published_at DESC
OFFSET
  0
LIMIT
  1

SELECT id
FROM vacancy_publication
WHERE vacancy_id = '019d5367-e342-70e2-b367-8a51c0fb7764'
ORDER BY published_at DESC
OFFSET 0 LIMIT 1;

SELECT id
FROM vacancy_publication
WHERE vacancy_id = ?
ORDER BY published_at DESC
OFFSET 0 LIMIT 1

[
  "019c09b3-d267-70e9-8ba1-066a008e7a39"
]

SELECT
  id
FROM
  vacancy_publication
WHERE
  vacancy_id = ?
ORDER BY
  published_at DESC
OFFSET
  0
LIMIT
  1

SELECT id
FROM vacancy_publication
WHERE vacancy_id = '019c09b3-d267-70e9-8ba1-066a008e7a39'
ORDER BY published_at DESC
OFFSET 0 LIMIT 1;

SELECT id
FROM vacancy_publication
WHERE vacancy_id = ?
ORDER BY published_at DESC
OFFSET 0 LIMIT 1

[
  "019b313a-1cd0-73ca-acc0-5e0abf856736"
]

SELECT
  id
FROM
  vacancy_publication
WHERE
  vacancy_id = ?
ORDER BY
  published_at DESC
OFFSET
  0
LIMIT
  1

SELECT id
FROM vacancy_publication
WHERE vacancy_id = '019b313a-1cd0-73ca-acc0-5e0abf856736'
ORDER BY published_at DESC
OFFSET 0 LIMIT 1;

SELECT id
FROM vacancy_publication
WHERE vacancy_id = ?
ORDER BY published_at DESC
OFFSET 0 LIMIT 1

[
  "019afdb6-2e5c-703c-98ee-c8afccfb4ac5"
]

SELECT
  id
FROM
  vacancy_publication
WHERE
  vacancy_id = ?
ORDER BY
  published_at DESC
OFFSET
  0
LIMIT
  1

SELECT id
FROM vacancy_publication
WHERE vacancy_id = '019afdb6-2e5c-703c-98ee-c8afccfb4ac5'
ORDER BY published_at DESC
OFFSET 0 LIMIT 1;

SELECT id
FROM vacancy_publication
WHERE vacancy_id = ?
ORDER BY published_at DESC
OFFSET 0 LIMIT 1

[
  "019afd78-9fb5-70e8-a765-33ffccb2157b"
]

SELECT
  id
FROM
  vacancy_publication
WHERE
  vacancy_id = ?
ORDER BY
  published_at DESC
OFFSET
  0
LIMIT
  1

SELECT id
FROM vacancy_publication
WHERE vacancy_id = '019afd78-9fb5-70e8-a765-33ffccb2157b'
ORDER BY published_at DESC
OFFSET 0 LIMIT 1;

"COMMIT"

[]

"COMMIT"

"COMMIT";

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

SELECT *, ST_AsEWKT(coordinates) AS coordinates FROM vacancy_read WHERE id = ? ORDER BY created_at DESC LIMIT 1

[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#6014
    __toString(): "019d5367-e342-70e2-b367-8a51c0fb7764"
  }
]

SELECT
  *,
  ST_AsEWKT(coordinates) AS coordinates
FROM
  vacancy_read
WHERE
  id = ?
ORDER BY
  created_at DESC
LIMIT
  1

SELECT *, ST_AsEWKT(coordinates) AS coordinates FROM vacancy_read WHERE id = '019d5367-e342-70e2-b367-8a51c0fb7764' ORDER BY created_at DESC LIMIT 1;

"COMMIT"

[]

"COMMIT"

"COMMIT";

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

SELECT * FROM company_view WHERE id = ?

[
  "019d5364-2179-73eb-a978-c26d17484b89"
]

SELECT
  *
FROM
  company_view
WHERE
  id = ?

SELECT * FROM company_view WHERE id = '019d5364-2179-73eb-a978-c26d17484b89';

"COMMIT"

[]

"COMMIT"

"COMMIT";

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

SELECT *, ST_AsEWKT(coordinates) AS coordinates FROM vacancy_read WHERE id = ? ORDER BY created_at DESC LIMIT 1

[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#15046
    __toString(): "019c09b3-d267-70e9-8ba1-066a008e7a39"
  }
]

SELECT
  *,
  ST_AsEWKT(coordinates) AS coordinates
FROM
  vacancy_read
WHERE
  id = ?
ORDER BY
  created_at DESC
LIMIT
  1

SELECT *, ST_AsEWKT(coordinates) AS coordinates FROM vacancy_read WHERE id = '019c09b3-d267-70e9-8ba1-066a008e7a39' ORDER BY created_at DESC LIMIT 1;

"COMMIT"

[]

"COMMIT"

"COMMIT";

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

SELECT * FROM company_view WHERE id = ?

[
  "019928bf-6c98-7335-9538-a583751b6f76"
]

SELECT
  *
FROM
  company_view
WHERE
  id = ?

SELECT * FROM company_view WHERE id = '019928bf-6c98-7335-9538-a583751b6f76';

"COMMIT"

[]

"COMMIT"

"COMMIT";

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";