GET https://sl.raduga.red/

Query Metrics

44 Database Queries
8 Different statements
171.46 ms Query time
1 Invalid entities
0 Managed entities

Grouped Statements

Show all queries

Time Count Info
90.33 ms
(52.68%)
1
SELECT *, ST_AsEWKT(coordinates) AS coordinates FROM vacancy_read WHERE status = ? ORDER BY created_at DESC LIMIT 5
Parameters:
[
  "public"
]
32.57 ms
(19.00%)
5
SELECT * FROM company_view WHERE id = ?
Parameters:
[
  "019d5364-2179-73eb-a978-c26d17484b89"
]
28.12 ms
(16.40%)
5
SELECT *, ST_AsEWKT(coordinates) AS coordinates FROM vacancy_read WHERE id = ? ORDER BY created_at DESC LIMIT 1
Parameters:
[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#2809
    __toString(): "019d5367-e342-70e2-b367-8a51c0fb7764"
  }
]
10.47 ms
(6.11%)
5
SELECT COUNT(id) FROM vacancy_read WHERE id = ?
Parameters:
[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#2809
    __toString(): "019d5367-e342-70e2-b367-8a51c0fb7764"
  }
]
4.25 ms
(2.48%)
1
SELECT COUNT(id) FROM vacancy_read WHERE status = ?
Parameters:
[
  "public"
]
2.17 ms
(1.26%)
11
"COMMIT"
Parameters:
[]
1.90 ms
(1.11%)
11
"START TRANSACTION"
Parameters:
[]
1.65 ms
(0.96%)
5
SELECT id
FROM vacancy_publication
WHERE vacancy_id = ?
ORDER BY published_at DESC
OFFSET 0 LIMIT 1
Parameters:
[
  "019d5367-e342-70e2-b367-8a51c0fb7764"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects

Entities Mapping

Class Mapping errors
Sl\Chat\Write\Chat\Chat
  • The field Sl\Chat\Write\Chat\Chat#members is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Sl\Chat\Write\Chat\ChatMember#chat does not contain the required 'inversedBy: "members"' attribute.
Sl\Chat\Write\Chat\ChatMember No errors.
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken No errors.
Sl\ItOps\JWT\Refresh\RefreshToken No errors.