GET https://xkodev.dot11.cz/clanky

Query Metrics

146 Database Queries
11 Different statements
62.20 ms Query time
0 Invalid entities
214 Managed entities

Grouped Statements

Show all queries

Time Count Info
18.40 ms
(29.58%)
42
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:
[
  138
]
16.51 ms
(26.54%)
40
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:
[
  91
]
15.95 ms
(25.64%)
47
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:
[
  1467
]
4.96 ms
(7.97%)
10
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:
[
  378
]
1.60 ms
(2.56%)
1
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.type_id = ? AND t0.approved = ? ORDER BY t0.date_from DESC
Parameters:
[
  1
  1
]
1.10 ms
(1.77%)
1
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 WHERE t0.type_id = ? AND t0.approved = ? ORDER BY t0.poradi ASC
Parameters:
[
  1
  1
]
1.03 ms
(1.65%)
1
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 INNER JOIN permanent_articles_events ON t0.id = permanent_articles_events.events_id WHERE permanent_articles_events.permanent_articles_id = ?
Parameters:
[
  1
]
0.94 ms
(1.51%)
1
SELECT t0.id AS id_1 FROM permanent_articles t0
Parameters:
[]
0.87 ms
(1.41%)
1
SELECT t0.id AS id_1, t0.name AS name_2 FROM event_type t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
0.43 ms
(0.69%)
1
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:
[]
0.42 ms
(0.68%)
1
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
]

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\EventContent 79
App\Entity\Uploaded 47
App\Entity\Events 44
App\Entity\User 11
App\Entity\Company 9
App\Entity\Partners 7
App\Entity\EventCatagories 6
App\Entity\MainMenuItems 6
App\Entity\EventTags 3
App\Entity\EventType 1
App\Entity\PermanentArticles 1

Entities Mapping

Class Mapping errors
App\Entity\EventType No errors.
App\Entity\EventCatagories No errors.
App\Entity\User No errors.
App\Entity\Events No errors.
App\Entity\EventTags No errors.
App\Entity\Banners No errors.
App\Entity\Company No errors.
App\Entity\Uploaded No errors.
App\Entity\EventContent No errors.
App\Entity\Contacts No errors.
App\Entity\PermanentArticles No errors.
App\Entity\Partners No errors.
App\Entity\MainMenuItems No errors.