Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 4
• Events
• Routing
• Cache
• Translation 3
• 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 (id = ?) AND (status = ?) ORDER BY created_at DESC LIMIT 1

[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#7012
    __toString(): "019afd4a-6c33-7214-9577-4909759e3b3c"
  }
  "public"
]

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

SELECT *, ST_AsEWKT(coordinates) AS coordinates FROM vacancy_read WHERE (id = '019afd4a-6c33-7214-9577-4909759e3b3c') AND (status = 'public') ORDER BY created_at DESC LIMIT 1;

SELECT COUNT(id) FROM vacancy_read WHERE (id = ?) AND (status = ?)

[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#7012
    __toString(): "019afd4a-6c33-7214-9577-4909759e3b3c"
  }
  "public"
]

SELECT
  COUNT(id)
FROM
  vacancy_read
WHERE
  (id = ?)
  AND (status = ?)

SELECT COUNT(id) FROM vacancy_read WHERE (id = '019afd4a-6c33-7214-9577-4909759e3b3c') AND (status = 'public');

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

[
  "019afd4a-6c33-7214-9577-4909759e3b3c"
]

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 = '019afd4a-6c33-7214-9577-4909759e3b3c'
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 {#4460
    __toString(): "019afd4a-6c33-7214-9577-4909759e3b3c"
  }
]

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 = '019afd4a-6c33-7214-9577-4909759e3b3c' ORDER BY created_at DESC LIMIT 1;

"COMMIT"

[]

"COMMIT"

"COMMIT";

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

SELECT * FROM company_view WHERE id = ?

[
  "019afd3d-8061-730a-997b-e9c9a37eb323"
]

SELECT
  *
FROM
  company_view
WHERE
  id = ?

SELECT * FROM company_view WHERE id = '019afd3d-8061-730a-997b-e9c9a37eb323';

"COMMIT"

[]

"COMMIT"

"COMMIT";

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

SELECT COUNT(d.id) FROM deal_read d WHERE (d.vacancy_id = ?) AND (d.is_closed = ?)

[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#4460
    __toString(): "019afd4a-6c33-7214-9577-4909759e3b3c"
  }
  0
]

SELECT
  COUNT(d.id)
FROM
  deal_read d
WHERE
  (d.vacancy_id = ?)
  AND (d.is_closed = ?)

SELECT COUNT(d.id) FROM deal_read d WHERE (d.vacancy_id = '019afd4a-6c33-7214-9577-4909759e3b3c') AND (d.is_closed = 0);

"COMMIT"

[]

"COMMIT"

"COMMIT";

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

SELECT * FROM deal_read d WHERE (d.vacancy_id = ?) AND (d.is_closed = ?) ORDER BY d.created_at DESC LIMIT 4

[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#4460
    __toString(): "019afd4a-6c33-7214-9577-4909759e3b3c"
  }
  0
]

SELECT
  *
FROM
  deal_read d
WHERE
  (d.vacancy_id = ?)
  AND (d.is_closed = ?)
ORDER BY
  d.created_at DESC
LIMIT
  4

SELECT * FROM deal_read d WHERE (d.vacancy_id = '019afd4a-6c33-7214-9577-4909759e3b3c') AND (d.is_closed = 0) ORDER BY d.created_at DESC LIMIT 4;

"COMMIT"

[]

"COMMIT"

"COMMIT";

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

SELECT * FROM workerman_information_read WHERE id = ?

[
  "019afc87-9572-7310-8906-f04bdbaeaab9"
]

SELECT
  *
FROM
  workerman_information_read
WHERE
  id = ?

SELECT * FROM workerman_information_read WHERE id = '019afc87-9572-7310-8906-f04bdbaeaab9';

"COMMIT"

[]

"COMMIT"

"COMMIT";

SELECT job_title_id, job_title, description
FROM workerman_information_previous_job_read
WHERE workerman_id = ?

[
  "019afc87-9572-7310-8906-f04bdbaeaab9"
]

SELECT
  job_title_id,
  job_title,
  description
FROM
  workerman_information_previous_job_read
WHERE
  workerman_id = ?

SELECT job_title_id, job_title, description
FROM workerman_information_previous_job_read
WHERE workerman_id = '019afc87-9572-7310-8906-f04bdbaeaab9';