GET https://ftpjkblog.ondravotava.cz/api/autocomplete/work-position

Query Metrics

41 Database Queries
3 Different statements
10.96 ms Query time
0 Invalid entities
575 Managed entities

Queries

Group similar statements

# Time Info
1 1.00 ms
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.profesia_id AS profesia_id_2, w0_.work_industry_id AS work_industry_id_3 FROM work_position w0_ WHERE w0_.name LIKE ?
Parameters:
[
  "%%"
]
2 0.63 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.profesia_id AS profesia_id_3 FROM work_industry t0 WHERE t0.id = ?
Parameters:
[
  1
]
3 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.profesia_id AS profesia_id_3 FROM work_industry t0 WHERE t0.id = ?
Parameters:
[
  2
]
4 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.profesia_id AS profesia_id_3 FROM work_industry t0 WHERE t0.id = ?
Parameters:
[
  3
]
5 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.profesia_id AS profesia_id_3 FROM work_industry t0 WHERE t0.id = ?
Parameters:
[
  4
]
6 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.profesia_id AS profesia_id_3 FROM work_industry t0 WHERE t0.id = ?
Parameters:
[
  5
]
7 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.profesia_id AS profesia_id_3 FROM work_industry t0 WHERE t0.id = ?
Parameters:
[
  6
]
8 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.profesia_id AS profesia_id_3 FROM work_industry t0 WHERE t0.id = ?
Parameters:
[
  7
]
9 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.profesia_id AS profesia_id_3 FROM work_industry t0 WHERE t0.id = ?
Parameters:
[
  8
]
10 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.profesia_id AS profesia_id_3 FROM work_industry t0 WHERE t0.id = ?
Parameters:
[
  9
]
11 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.profesia_id AS profesia_id_3 FROM work_industry t0 WHERE t0.id = ?
Parameters:
[
  10
]
12 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.profesia_id AS profesia_id_3 FROM work_industry t0 WHERE t0.id = ?
Parameters:
[
  11
]
13 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.profesia_id AS profesia_id_3 FROM work_industry t0 WHERE t0.id = ?
Parameters:
[
  12
]
14 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.profesia_id AS profesia_id_3 FROM work_industry t0 WHERE t0.id = ?
Parameters:
[
  13
]
15 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.profesia_id AS profesia_id_3 FROM work_industry t0 WHERE t0.id = ?
Parameters:
[
  14
]
16 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.profesia_id AS profesia_id_3 FROM work_industry t0 WHERE t0.id = ?
Parameters:
[
  15
]
17 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.profesia_id AS profesia_id_3 FROM work_industry t0 WHERE t0.id = ?
Parameters:
[
  16
]
18 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.profesia_id AS profesia_id_3 FROM work_industry t0 WHERE t0.id = ?
Parameters:
[
  17
]
19 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.profesia_id AS profesia_id_3 FROM work_industry t0 WHERE t0.id = ?
Parameters:
[
  18
]
20 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.profesia_id AS profesia_id_3 FROM work_industry t0 WHERE t0.id = ?
Parameters:
[
  19
]
21 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.profesia_id AS profesia_id_3 FROM work_industry t0 WHERE t0.id = ?
Parameters:
[
  20
]
22 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.profesia_id AS profesia_id_3 FROM work_industry t0 WHERE t0.id = ?
Parameters:
[
  21
]
23 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.profesia_id AS profesia_id_3 FROM work_industry t0 WHERE t0.id = ?
Parameters:
[
  22
]
24 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.profesia_id AS profesia_id_3 FROM work_industry t0 WHERE t0.id = ?
Parameters:
[
  23
]
25 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.profesia_id AS profesia_id_3 FROM work_industry t0 WHERE t0.id = ?
Parameters:
[
  24
]
26 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.profesia_id AS profesia_id_3 FROM work_industry t0 WHERE t0.id = ?
Parameters:
[
  25
]
27 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.profesia_id AS profesia_id_3 FROM work_industry t0 WHERE t0.id = ?
Parameters:
[
  26
]
28 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.profesia_id AS profesia_id_3 FROM work_industry t0 WHERE t0.id = ?
Parameters:
[
  27
]
29 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.profesia_id AS profesia_id_3 FROM work_industry t0 WHERE t0.id = ?
Parameters:
[
  28
]
30 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.profesia_id AS profesia_id_3 FROM work_industry t0 WHERE t0.id = ?
Parameters:
[
  29
]
31 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.profesia_id AS profesia_id_3 FROM work_industry t0 WHERE t0.id = ?
Parameters:
[
  30
]
32 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.profesia_id AS profesia_id_3 FROM work_industry t0 WHERE t0.id = ?
Parameters:
[
  31
]
33 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.profesia_id AS profesia_id_3 FROM work_industry t0 WHERE t0.id = ?
Parameters:
[
  32
]
34 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.profesia_id AS profesia_id_3 FROM work_industry t0 WHERE t0.id = ?
Parameters:
[
  33
]
35 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.profesia_id AS profesia_id_3 FROM work_industry t0 WHERE t0.id = ?
Parameters:
[
  34
]
36 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.profesia_id AS profesia_id_3 FROM work_industry t0 WHERE t0.id = ?
Parameters:
[
  35
]
37 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.profesia_id AS profesia_id_3 FROM work_industry t0 WHERE t0.id = ?
Parameters:
[
  36
]
38 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.profesia_id AS profesia_id_3 FROM work_industry t0 WHERE t0.id = ?
Parameters:
[
  37
]
39 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.profesia_id AS profesia_id_3 FROM work_industry t0 WHERE t0.id = ?
Parameters:
[
  38
]
40 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.profesia_id AS profesia_id_3 FROM work_industry t0 WHERE t0.id = ?
Parameters:
[
  39
]
41 0.33 ms
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.profesia_id AS profesia_id_2 FROM work_industry w0_ WHERE w0_.name LIKE ?
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
App\Entity\WorkPosition 536
App\Entity\WorkIndustry 39

Entities Mapping

Class Mapping errors
App\Entity\WorkPosition No errors.
App\Entity\WorkIndustry No errors.
App\Entity\JobOffer No errors.