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

Query Metrics

35 Database Queries
10 Different statements
8.46 ms Query time
0 Invalid entities
56 Managed entities

Queries

Group similar statements

# Time Info
1 0.33 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.66 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:
[
  8
]
3 0.24 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.25 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.26 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:
[
  1372
]
6 0.25 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 INNER JOIN category_company_company ON t0.id = category_company_company.category_company_id WHERE category_company_company.company_id = ?
Parameters:
[
  305
]
7 0.26 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.phone AS phone_3, t0.street AS street_4, t0.city AS city_5, t0.zip AS zip_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8, t0.website AS website_9, t0.facebook AS facebook_10, t0.instagram AS instagram_11, t0.twitter AS twitter_12, t0.linkedin AS linkedin_13, t0.youtube AS youtube_14, t0.vimeo AS vimeo_15, t0.branch_name AS branch_name_16, t0.company_id AS company_id_17 FROM contacts t0 WHERE t0.company_id = ?
Parameters:
[
  305
]
8 0.24 ms
SELECT t0.id AS id_1, t0.perex AS perex_2, t0.content AS content_3, t0.youtube_video AS youtube_video_4, t0.vimeo_video AS vimeo_video_5, t0.embed_code AS embed_code_6 FROM event_content t0 INNER JOIN company_event_content ON t0.id = company_event_content.event_content_id WHERE company_event_content.company_id = ?
Parameters:
[
  305
]
9 0.24 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.approved_by_id AS approved_by_id_6, t0.icon_id AS icon_id_7 FROM tags_company t0 INNER JOIN tags_company_company ON t0.id = tags_company_company.tags_company_id WHERE tags_company_company.company_id = ?
Parameters:
[
  305
]
10 0.69 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.active_from AS active_from_3, t0.active_to AS active_to_4, t0.destination_url AS destination_url_5, t0.priority AS priority_6, t0.approved AS approved_7, t0.company_id AS company_id_8, t0.user_id AS user_id_9 FROM banners t0 WHERE t0.company_id = ?
Parameters:
[
  305
]
11 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:
[
  588
]
12 0.24 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 INNER JOIN category_company_company ON t0.id = category_company_company.category_company_id WHERE category_company_company.company_id = ?
Parameters:
[
  223
]
13 0.27 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.phone AS phone_3, t0.street AS street_4, t0.city AS city_5, t0.zip AS zip_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8, t0.website AS website_9, t0.facebook AS facebook_10, t0.instagram AS instagram_11, t0.twitter AS twitter_12, t0.linkedin AS linkedin_13, t0.youtube AS youtube_14, t0.vimeo AS vimeo_15, t0.branch_name AS branch_name_16, t0.company_id AS company_id_17 FROM contacts t0 WHERE t0.company_id = ?
Parameters:
[
  223
]
14 0.23 ms
SELECT t0.id AS id_1, t0.perex AS perex_2, t0.content AS content_3, t0.youtube_video AS youtube_video_4, t0.vimeo_video AS vimeo_video_5, t0.embed_code AS embed_code_6 FROM event_content t0 INNER JOIN company_event_content ON t0.id = company_event_content.event_content_id WHERE company_event_content.company_id = ?
Parameters:
[
  223
]
15 0.21 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.approved_by_id AS approved_by_id_6, t0.icon_id AS icon_id_7 FROM tags_company t0 INNER JOIN tags_company_company ON t0.id = tags_company_company.tags_company_id WHERE tags_company_company.company_id = ?
Parameters:
[
  223
]
16 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.active_from AS active_from_3, t0.active_to AS active_to_4, t0.destination_url AS destination_url_5, t0.priority AS priority_6, t0.approved AS approved_7, t0.company_id AS company_id_8, t0.user_id AS user_id_9 FROM banners t0 WHERE t0.company_id = ?
Parameters:
[
  223
]
17 0.19 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:
[
  100
]
18 0.23 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 INNER JOIN category_company_company ON t0.id = category_company_company.category_company_id WHERE category_company_company.company_id = ?
Parameters:
[
  77
]
19 0.22 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.phone AS phone_3, t0.street AS street_4, t0.city AS city_5, t0.zip AS zip_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8, t0.website AS website_9, t0.facebook AS facebook_10, t0.instagram AS instagram_11, t0.twitter AS twitter_12, t0.linkedin AS linkedin_13, t0.youtube AS youtube_14, t0.vimeo AS vimeo_15, t0.branch_name AS branch_name_16, t0.company_id AS company_id_17 FROM contacts t0 WHERE t0.company_id = ?
Parameters:
[
  77
]
20 0.24 ms
SELECT t0.id AS id_1, t0.perex AS perex_2, t0.content AS content_3, t0.youtube_video AS youtube_video_4, t0.vimeo_video AS vimeo_video_5, t0.embed_code AS embed_code_6 FROM event_content t0 INNER JOIN company_event_content ON t0.id = company_event_content.event_content_id WHERE company_event_content.company_id = ?
Parameters:
[
  77
]
21 0.23 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.approved_by_id AS approved_by_id_6, t0.icon_id AS icon_id_7 FROM tags_company t0 INNER JOIN tags_company_company ON t0.id = tags_company_company.tags_company_id WHERE tags_company_company.company_id = ?
Parameters:
[
  77
]
22 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.active_from AS active_from_3, t0.active_to AS active_to_4, t0.destination_url AS destination_url_5, t0.priority AS priority_6, t0.approved AS approved_7, t0.company_id AS company_id_8, t0.user_id AS user_id_9 FROM banners t0 WHERE t0.company_id = ?
Parameters:
[
  77
]
23 0.19 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:
[
  214
]
24 0.22 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 INNER JOIN category_company_company ON t0.id = category_company_company.category_company_id WHERE category_company_company.company_id = ?
Parameters:
[
  115
]
25 0.20 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.phone AS phone_3, t0.street AS street_4, t0.city AS city_5, t0.zip AS zip_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8, t0.website AS website_9, t0.facebook AS facebook_10, t0.instagram AS instagram_11, t0.twitter AS twitter_12, t0.linkedin AS linkedin_13, t0.youtube AS youtube_14, t0.vimeo AS vimeo_15, t0.branch_name AS branch_name_16, t0.company_id AS company_id_17 FROM contacts t0 WHERE t0.company_id = ?
Parameters:
[
  115
]
26 0.23 ms
SELECT t0.id AS id_1, t0.perex AS perex_2, t0.content AS content_3, t0.youtube_video AS youtube_video_4, t0.vimeo_video AS vimeo_video_5, t0.embed_code AS embed_code_6 FROM event_content t0 INNER JOIN company_event_content ON t0.id = company_event_content.event_content_id WHERE company_event_content.company_id = ?
Parameters:
[
  115
]
27 0.27 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.approved_by_id AS approved_by_id_6, t0.icon_id AS icon_id_7 FROM tags_company t0 INNER JOIN tags_company_company ON t0.id = tags_company_company.tags_company_id WHERE tags_company_company.company_id = ?
Parameters:
[
  115
]
28 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.active_from AS active_from_3, t0.active_to AS active_to_4, t0.destination_url AS destination_url_5, t0.priority AS priority_6, t0.approved AS approved_7, t0.company_id AS company_id_8, t0.user_id AS user_id_9 FROM banners t0 WHERE t0.company_id = ?
Parameters:
[
  115
]
29 0.16 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
]
30 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
]
31 0.16 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
]
32 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:
[
  371
]
33 0.16 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
]
34 0.16 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
]
35 0.16 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\Uploaded 12
App\Entity\CategoryCompany 10
App\Entity\Partners 7
App\Entity\MainMenuItems 6
App\Entity\Contacts 5
App\Entity\TagsCompany 5
App\Entity\Company 4
App\Entity\EventContent 4
App\Entity\User 3

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\Events No errors.
App\Entity\Banners No errors.
App\Entity\Contacts No errors.
App\Entity\TagsCompany No errors.
App\Entity\EventContent No errors.
App\Entity\Partners No errors.
App\Entity\MainMenuItems No errors.