Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 3
• 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 * 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(f.id) FROM company_feedback_read f WHERE f.company_id = ?

[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#1616
    __toString(): "019afd3d-8061-730a-997b-e9c9a37eb323"
  }
]

SELECT
  COUNT(f.id)
FROM
  company_feedback_read f
WHERE
  f.company_id = ?

SELECT COUNT(f.id) FROM company_feedback_read f WHERE f.company_id = '019afd3d-8061-730a-997b-e9c9a37eb323';

"COMMIT"

[]

"COMMIT"

"COMMIT";

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

SELECT * FROM company_feedback_read f WHERE f.company_id = ? ORDER BY f.created_at DESC LIMIT 3

[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#1616
    __toString(): "019afd3d-8061-730a-997b-e9c9a37eb323"
  }
]

SELECT
  *
FROM
  company_feedback_read f
WHERE
  f.company_id = ?
ORDER BY
  f.created_at DESC
LIMIT
  3

SELECT * FROM company_feedback_read f WHERE f.company_id = '019afd3d-8061-730a-997b-e9c9a37eb323' ORDER BY f.created_at DESC LIMIT 3;

"COMMIT"

[]

"COMMIT"

"COMMIT";

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

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

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

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

SELECT *, ST_AsEWKT(coordinates) AS coordinates FROM vacancy_read WHERE (status = 'public') AND (company_id = '019afd3d-8061-730a-997b-e9c9a37eb323') ORDER BY created_at DESC LIMIT 10;

"COMMIT"

[]

"COMMIT"

"COMMIT";

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

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

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

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

SELECT COUNT(id) FROM vacancy_read WHERE (status = 'public') AND (company_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.company_id = ?

[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#1616
    __toString(): "019afd3d-8061-730a-997b-e9c9a37eb323"
  }
]

SELECT
  COUNT(d.id)
FROM
  deal_read d
WHERE
  d.company_id = ?

SELECT COUNT(d.id) FROM deal_read d WHERE d.company_id = '019afd3d-8061-730a-997b-e9c9a37eb323';

"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 {#7782
    __toString(): "019afdb6-2e5c-703c-98ee-c8afccfb4ac5"
  }
]

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 = '019afdb6-2e5c-703c-98ee-c8afccfb4ac5' ORDER BY created_at DESC LIMIT 1;

SELECT COUNT(id) FROM vacancy_read WHERE id = ?

[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#7782
    __toString(): "019afdb6-2e5c-703c-98ee-c8afccfb4ac5"
  }
]

SELECT
  COUNT(id)
FROM
  vacancy_read
WHERE
  id = ?

SELECT COUNT(id) FROM vacancy_read WHERE id = '019afdb6-2e5c-703c-98ee-c8afccfb4ac5';

"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";