GET https://xkodev.dot11.cz/organizace/detail/Cesky-registr-darcu-krvetvornych-bunek-101

Query Metrics

21 Database Queries
13 Different statements
5.91 ms Query time
0 Invalid entities
49 Managed entities

Queries

Group similar statements

# Time Info
1 0.49 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.updated_at AS updated_at_3, t0.headquarter AS headquarter_4, t0.ico AS ico_5, t0.dic AS dic_6, t0.bank_no AS bank_no_7, t0.correspondece AS correspondece_8, t0.approved AS approved_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.nationwide AS nationwide_12, t0.slug AS slug_13, t0.changes_md_sum AS changes_md_sum_14, t0.approved_by_id AS approved_by_id_15, t0.owner_id AS owner_id_16, t0.logo_id AS logo_id_17 FROM company t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "Cesky-registr-darcu-krvetvornych-bunek-101"
]
2 0.39 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:
[]
3 0.27 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
]
4 0.43 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:
[
  101
]
5 0.34 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:
[
  101
]
6 0.28 ms
SELECT t0.id AS id_1, t0.file AS file_2, t0.updated_at AS updated_at_3 FROM uploaded t0 INNER JOIN event_content_uploaded ON t0.id = event_content_uploaded.uploaded_id WHERE event_content_uploaded.event_content_id = ?
Parameters:
[
  101
]
7 0.24 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:
[
  172
]
8 0.31 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:
[
  101
]
9 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.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:
[
  101
]
10 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_from AS date_from_3, t0.date_to AS date_to_4, t0.email AS email_5, t0.created_at AS created_at_6, t0.udated_at AS udated_at_7, t0.supervised AS supervised_8, t0.approved AS approved_9, t0.slug AS slug_10, t0.supervisor_md_sum AS supervisor_md_sum_11, t0.changes_md_sum AS changes_md_sum_12, t0.owner_id AS owner_id_13, t0.approver_id AS approver_id_14, t0.company_id AS company_id_15, t0.updated_by_id AS updated_by_id_16, t0.type_id AS type_id_17, t0.main_image_id AS main_image_id_18 FROM events t0 WHERE t0.company_id = ?
Parameters:
[
  101
]
11 0.48 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 events_event_content ON t0.id = events_event_content.event_content_id WHERE events_event_content.events_id = ?
Parameters:
[
  11
]
12 0.32 ms
SELECT t0.id AS id_1, t0.file AS file_2, t0.updated_at AS updated_at_3 FROM uploaded t0 INNER JOIN event_content_uploaded ON t0.id = event_content_uploaded.uploaded_id WHERE event_content_uploaded.event_content_id = ?
Parameters:
[
  196
]
13 0.27 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.phone_no AS phone_no_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.is_approved AS is_approved_9, t0.reg_reasons AS reg_reasons_10, t0.updated_by_id AS updated_by_id_11, t0.approved_by_id AS approved_by_id_12, t0.uploadable_id AS uploadable_id_13 FROM user t0 WHERE t0.id = ?
Parameters:
[
  6
]
14 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.approved AS approved_3, t0.fonticon AS fonticon_4, t0.approved_by_id AS approved_by_id_5, t0.hero_article_id AS hero_article_id_6 FROM event_tags t0 INNER JOIN events_event_tags ON t0.id = events_event_tags.event_tags_id WHERE events_event_tags.events_id = ?
Parameters:
[
  11
]
15 0.17 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
]
16 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:
[
  369
]
17 0.17 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
]
18 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:
[
  371
]
19 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
]
20 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
]
21 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 14
App\Entity\TagsCompany 10
App\Entity\Partners 7
App\Entity\MainMenuItems 6
App\Entity\EventContent 4
App\Entity\User 3
App\Entity\Company 1
App\Entity\CategoryCompany 1
App\Entity\Contacts 1
App\Entity\Events 1
App\Entity\EventType 1

Entities Mapping