GET https://sl.raduga.red/company/019928bf-6c98-7335-9538-a583751b6f76

Query Metrics

34 Database Queries
10 Different statements
83.31 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

# Time Info
1 0.12 ms
"START TRANSACTION"
Parameters:
[]
2 13.15 ms
SELECT * FROM company_view WHERE id = ?
Parameters:
[
  "019928bf-6c98-7335-9538-a583751b6f76"
]
3 0.16 ms
"COMMIT"
Parameters:
[]
4 0.10 ms
"START TRANSACTION"
Parameters:
[]
5 6.20 ms
SELECT COUNT(f.id) FROM company_feedback_read f WHERE f.company_id = ?
Parameters:
[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#3061
    __toString(): "019928bf-6c98-7335-9538-a583751b6f76"
  }
]
6 0.15 ms
"COMMIT"
Parameters:
[]
7 0.10 ms
"START TRANSACTION"
Parameters:
[]
8 6.18 ms
SELECT * FROM company_feedback_read f WHERE f.company_id = ? ORDER BY f.created_at DESC LIMIT 3
Parameters:
[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#3061
    __toString(): "019928bf-6c98-7335-9538-a583751b6f76"
  }
]
9 0.54 ms
"COMMIT"
Parameters:
[]
10 0.13 ms
"START TRANSACTION"
Parameters:
[]
11 33.49 ms
SELECT *, ST_AsEWKT(coordinates) AS coordinates FROM vacancy_read WHERE (status = ?) AND (company_id = ?) ORDER BY created_at DESC LIMIT 10
Parameters:
[
  "public"
  "019928bf-6c98-7335-9538-a583751b6f76"
]
12 0.23 ms
"COMMIT"
Parameters:
[]
13 0.12 ms
"START TRANSACTION"
Parameters:
[]
14 2.11 ms
SELECT COUNT(id) FROM vacancy_read WHERE (status = ?) AND (company_id = ?)
Parameters:
[
  "public"
  "019928bf-6c98-7335-9538-a583751b6f76"
]
15 0.22 ms
"COMMIT"
Parameters:
[]
16 0.12 ms
"START TRANSACTION"
Parameters:
[]
17 1.39 ms
SELECT COUNT(d.id) FROM deal_read d WHERE d.company_id = ?
Parameters:
[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#3061
    __toString(): "019928bf-6c98-7335-9538-a583751b6f76"
  }
]
18 0.15 ms
"COMMIT"
Parameters:
[]
19 0.11 ms
"START TRANSACTION"
Parameters:
[]
20 6.26 ms
SELECT *, ST_AsEWKT(coordinates) AS coordinates FROM vacancy_read WHERE id = ? ORDER BY created_at DESC LIMIT 1
Parameters:
[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#6335
    __toString(): "019928c8-ea8d-7021-844b-124d52ea793b"
  }
]
21 1.62 ms
SELECT COUNT(id) FROM vacancy_read WHERE id = ?
Parameters:
[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#6335
    __toString(): "019928c8-ea8d-7021-844b-124d52ea793b"
  }
]
22 0.20 ms
"COMMIT"
Parameters:
[]
23 0.12 ms
"START TRANSACTION"
Parameters:
[]
24 3.56 ms
SELECT * FROM company_view WHERE id = ?
Parameters:
[
  "019928bf-6c98-7335-9538-a583751b6f76"
]
25 0.19 ms
"COMMIT"
Parameters:
[]
26 0.14 ms
"START TRANSACTION"
Parameters:
[]
27 3.10 ms
SELECT * FROM company_view WHERE id = ?
Parameters:
[
  "019928bf-6c98-7335-9538-a583751b6f76"
]
28 0.13 ms
"COMMIT"
Parameters:
[]
29 0.10 ms
"START TRANSACTION"
Parameters:
[]
30 1.62 ms
SELECT COUNT(id) FROM vacancy_read WHERE (status = ?) AND (company_id = ?)
Parameters:
[
  "public"
  "019928bf-6c98-7335-9538-a583751b6f76"
]
31 0.11 ms
"COMMIT"
Parameters:
[]
32 0.09 ms
"START TRANSACTION"
Parameters:
[]
33 1.20 ms
SELECT COUNT(d.id) FROM deal_read d WHERE d.company_id = ?
Parameters:
[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#4240
    __toString(): "019928bf-6c98-7335-9538-a583751b6f76"
  }
]
34 0.10 ms
"COMMIT"
Parameters:
[]

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

No loaded entities.