GET https://xkodev.dot11.cz/clanek/Vernisaz-Pod-vasimi-kridly-v-Mikulove-126

Query Metrics

47 Database Queries
12 Different statements
11.20 ms Query time
0 Invalid entities
69 Managed entities

Queries

Group similar statements

# Time Info
1 0.47 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.slug = ? LIMIT 1
Parameters:
[
  "Vernisaz-Pod-vasimi-kridly-v-Mikulove-126"
]
2 0.59 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.approved = ? AND t0.type_id = ? ORDER BY t0.date_from DESC LIMIT 10
Parameters:
[
  1
  2
]
3 0.38 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.24 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.46 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:
[
  126
]
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 WHERE t0.id = ?
Parameters:
[
  1405
]
7 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.approved AS approved_3, t0.fonticon AS fonticon_4, t0.poradi AS poradi_5, t0.approved_by_id AS approved_by_id_6, t0.hero_article_id AS hero_article_id_7, t0.type_id AS type_id_8 FROM event_catagories t0 INNER JOIN events_event_catagories ON t0.id = events_event_catagories.event_catagories_id WHERE events_event_catagories.events_id = ?
Parameters:
[
  126
]
8 0.34 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.id = ?
Parameters:
[
  90
]
9 0.28 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:
[
  145
]
10 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 INNER JOIN events_contacts ON t0.id = events_contacts.contacts_id WHERE events_contacts.events_id = ?
Parameters:
[
  126
]
11 0.29 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:
[
  279
]
12 0.29 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:
[
  126
]
13 0.23 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:
[
  498
]
14 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:
[
  1465
]
15 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 events_event_content ON t0.id = events_event_content.event_content_id WHERE events_event_content.events_id = ?
Parameters:
[
  137
]
16 0.22 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:
[
  137
]
17 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:
[
  1481
]
18 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 events_event_content ON t0.id = events_event_content.event_content_id WHERE events_event_content.events_id = ?
Parameters:
[
  139
]
19 0.20 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:
[
  139
]
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:
[
  1457
]
21 0.20 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:
[
  136
]
22 0.22 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:
[
  136
]
23 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:
[
  1437
]
24 0.26 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:
[
  128
]
25 0.22 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:
[
  128
]
26 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:
[
  1458
]
27 0.25 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:
[
  135
]
28 0.22 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:
[
  135
]
29 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:
[
  1381
]
30 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 events_event_content ON t0.id = events_event_content.event_content_id WHERE events_event_content.events_id = ?
Parameters:
[
  122
]
31 0.22 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:
[
  122
]
32 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:
[
  1387
]
33 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 events_event_content ON t0.id = events_event_content.event_content_id WHERE events_event_content.events_id = ?
Parameters:
[
  121
]
34 0.19 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:
[
  121
]
35 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:
[
  1166
]
36 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 events_event_content ON t0.id = events_event_content.event_content_id WHERE events_event_content.events_id = ?
Parameters:
[
  89
]
37 0.22 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:
[
  89
]
38 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:
[
  1403
]
39 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 events_event_content ON t0.id = events_event_content.event_content_id WHERE events_event_content.events_id = ?
Parameters:
[
  127
]
40 0.22 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:
[
  127
]
41 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:
[
  473
]
42 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:
[
  369
]
43 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
]
44 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
]
45 0.15 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
]
46 0.15 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
]
47 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:
[
  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 19
App\Entity\EventContent 11
App\Entity\Events 10
App\Entity\User 7
App\Entity\Partners 7
App\Entity\MainMenuItems 6
App\Entity\Company 5
App\Entity\EventCatagories 3
App\Entity\EventType 1

Entities Mapping