GET https://xkodev.dot11.cz/organizace/hlaspacientu.cz

Query Metrics

11 Database Queries
5 Different statements
2.73 ms Query time
0 Invalid entities
33 Managed entities

Queries

Group similar statements

# Time Info
1 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_approved AS is_approved_3, t0.updated_at AS updated_at_4, t0.fonticon AS fonticon_5, t0.poradi AS poradi_6, t0.approved_by_id AS approved_by_id_7, t0.icon_id AS icon_id_8 FROM category_company t0 WHERE t0.is_approved = ? ORDER BY t0.poradi ASC
Parameters:
[
  1
]
2 0.47 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.updated_at AS updated_at_2, c0_.headquarter AS headquarter_3, c0_.ico AS ico_4, c0_.dic AS dic_5, c0_.bank_no AS bank_no_6, c0_.correspondece AS correspondece_7, c0_.approved AS approved_8, c0_.latitude AS latitude_9, c0_.longitude AS longitude_10, c0_.nationwide AS nationwide_11, c0_.slug AS slug_12, c0_.changes_md_sum AS changes_md_sum_13, c0_.approved_by_id AS approved_by_id_14, c0_.owner_id AS owner_id_15, c0_.logo_id AS logo_id_16 FROM company c0_ LEFT JOIN category_company_company c2_ ON c0_.id = c2_.company_id LEFT JOIN category_company c1_ ON c1_.id = c2_.category_company_id WHERE c1_.id = ? AND c0_.approved = 1 ORDER BY c0_.name ASC
Parameters:
[
  0
]
3 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.general_partner AS general_partner_3, t0.web_url AS web_url_4, t0.poradi AS poradi_5, t0.logo_id AS logo_id_6 FROM partners t0 ORDER BY t0.poradi ASC
Parameters:
[]
4 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.active AS active_4, t0.poradi AS poradi_5 FROM main_menu_items t0 WHERE t0.active = ? ORDER BY t0.poradi ASC
Parameters:
[
  1
]
5 0.21 ms
SELECT t0.id AS id_1, t0.file AS file_2, t0.updated_at AS updated_at_3 FROM uploaded t0 WHERE t0.id = ?
Parameters:
[
  473
]
6 0.14 ms
SELECT t0.id AS id_1, t0.file AS file_2, t0.updated_at AS updated_at_3 FROM uploaded t0 WHERE t0.id = ?
Parameters:
[
  369
]
7 0.18 ms
SELECT t0.id AS id_1, t0.file AS file_2, t0.updated_at AS updated_at_3 FROM uploaded t0 WHERE t0.id = ?
Parameters:
[
  370
]
8 0.21 ms
SELECT t0.id AS id_1, t0.file AS file_2, t0.updated_at AS updated_at_3 FROM uploaded t0 WHERE t0.id = ?
Parameters:
[
  371
]
9 0.21 ms
SELECT t0.id AS id_1, t0.file AS file_2, t0.updated_at AS updated_at_3 FROM uploaded t0 WHERE t0.id = ?
Parameters:
[
  372
]
10 0.21 ms
SELECT t0.id AS id_1, t0.file AS file_2, t0.updated_at AS updated_at_3 FROM uploaded t0 WHERE t0.id = ?
Parameters:
[
  373
]
11 0.22 ms
SELECT t0.id AS id_1, t0.file AS file_2, t0.updated_at AS updated_at_3 FROM uploaded t0 WHERE t0.id = ?
Parameters:
[
  374
]

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\CategoryCompany 10
App\Entity\Uploaded 8
App\Entity\Partners 7
App\Entity\MainMenuItems 6
App\Entity\User 2

Entities Mapping

Class Mapping errors
App\Entity\CategoryCompany No errors.
App\Entity\User No errors.
App\Entity\Uploaded No errors.
App\Entity\Company No errors.
App\Entity\Partners No errors.
App\Entity\MainMenuItems No errors.