GET https://dev.gloster.hu/esettanulmanyok

Query Metrics

54 Database Queries
17 Different statements
29.33 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
6.41 ms
(21.86%)
10
SELECT t0.id AS id_1, t0.created_by AS created_by_2, t0.updated_by AS updated_by_3, t0.deleted_at AS deleted_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.locale AS locale_7, t0.title AS title_8, t0.slug AS slug_9, t0.is_active AS is_active_10, t0.image AS image_11, t0.lead AS lead_12, t0.translatable_id AS translatable_id_13 FROM case_study_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  b"\x01ì,`X6t╬╣░"ì|═ÿÿ"
]
4.24 ms
(14.46%)
9
SELECT t0.id AS id_1, t0.created_by AS created_by_2, t0.updated_by AS updated_by_3, t0.deleted_at AS deleted_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.meta_id AS meta_id_7 FROM company_partner t0 WHERE t0.id = ?
Parameters:
[
  b"\x01ì+±"ItÞé\x1AJÌðkØó"
]
3.73 ms
(12.71%)
9
SELECT t0.id AS id_1, t0.created_by AS created_by_2, t0.updated_by AS updated_by_3, t0.deleted_at AS deleted_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.locale AS locale_7, t0.title AS title_8, t0.slug AS slug_9, t0.is_active AS is_active_10, t0.is_highlighted AS is_highlighted_11, t0.image AS image_12, t0.translatable_id AS translatable_id_13 FROM company_partner_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  b"\x01ì+±"ItÞé\x1AJÌðkØó"
]
2.60 ms
(8.85%)
4
SELECT t0.id AS id_1, t0.created_by AS created_by_2, t0.updated_by AS updated_by_3, t0.deleted_at AS deleted_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.locale AS locale_7, t0.title AS title_8, t0.slug AS slug_9, t0.is_active AS is_active_10, t0.content AS content_11, t0.image AS image_12, t0.acronym AS acronym_13, t0.lead AS lead_14, t0.translatable_id AS translatable_id_15 FROM service_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  b"\x01ì+ÏÜ"~Ìïeík1X┌¾"
]
2.17 ms
(7.40%)
3
SELECT t0.remote_url AS remote_url_1, t0.id AS id_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.deleted_at AS deleted_at_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.locale AS locale_8, t0.title AS title_9, t0.slug AS slug_10, t0.is_active AS is_active_11, t0.content AS content_12, t0.image AS image_13, t0.translatable_id AS translatable_id_14 FROM industry_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  b"\x01Œÿ‹\x1DfsF•\x12ÇÓ1p-!"
]
1.89 ms
(6.45%)
4
SELECT t0.id AS id_1, t0.created_by AS created_by_2, t0.updated_by AS updated_by_3, t0.deleted_at AS deleted_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.meta_id AS meta_id_7 FROM service t0 WHERE t0.id = ?
Parameters:
[
  b"\x01ì+ÏÜ"~Ìïeík1X┌¾"
]
1.84 ms
(6.27%)
1
SELECT c0_.id AS id_0, c0_.created_by AS created_by_1, c0_.updated_by AS updated_by_2, c0_.deleted_at AS deleted_at_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, c0_.partner_id AS partner_id_6, c0_.service_id AS service_id_7, c0_.meta_id AS meta_id_8 FROM case_study c0_ LEFT JOIN case_study_translation c1_ ON c0_.id = c1_.translatable_id WHERE c1_.locale = ? AND c1_.is_active = 1 AND c1_.deleted_at IS NULL
Parameters:
[
  "hu"
]
1.41 ms
(4.79%)
3
SELECT t0.subtitle AS subtitle_1, t0.is_inverse AS is_inverse_2, t0.is_section AS is_section_3, t0.is_collapsed AS is_collapsed_4, t0.is_localized AS is_localized_5, t0.content_secondary AS content_secondary_6, t0.hash AS hash_7, t0.id AS id_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.deleted_at AS deleted_at_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.locale AS locale_14, t0.title AS title_15, t0.slug AS slug_16, t0.is_active AS is_active_17, t0.content AS content_18, t0.lead AS lead_19, t0.navigation_url AS navigation_url_20, t0.navigation_title AS navigation_title_21, t0.media AS media_22, t0.media_collection AS media_collection_23, t0.translatable_id AS translatable_id_24 FROM common_layout_block_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  b"\x01î¸|+òzÿ╣^\x0FfØ*8ú"
]
0.91 ms
(3.10%)
2
SELECT t0.value AS value_1, t0.file AS file_2, t0.id AS id_3, t0.created_by AS created_by_4, t0.updated_by AS updated_by_5, t0.deleted_at AS deleted_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.locale AS locale_9, t0.translatable_id AS translatable_id_10 FROM system_application_config_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  b"\x01ìB\x1F°e}\x17º:\x1Fð§oZ╬"
]
0.79 ms
(2.71%)
2
SELECT t0.code AS code_1, t0.id AS id_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.deleted_at AS deleted_at_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.meta_id AS meta_id_8 FROM system_application t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "default"
]
0.76 ms
(2.59%)
1
SELECT t0.code AS code_1, t0.route_name AS route_name_2, t0.id AS id_3, t0.created_by AS created_by_4, t0.updated_by AS updated_by_5, t0.deleted_at AS deleted_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.meta_id AS meta_id_9 FROM system_page t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "case_study_list"
]
0.56 ms
(1.92%)
1
SELECT t0.id AS id_1, t0.created_by AS created_by_2, t0.updated_by AS updated_by_3, t0.deleted_at AS deleted_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.color AS color_7, t0.leader_id AS leader_id_8, t0.meta_id AS meta_id_9 FROM industry t0
Parameters:
[]
0.55 ms
(1.86%)
1
SELECT t0.config_key AS config_key_1, t0.id AS id_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.deleted_at AS deleted_at_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.application_id AS application_id_8 FROM system_application_config t0 WHERE t0.application_id = ?
Parameters:
[
  b"\x01Œô”ŒäqY³fgçÍÙoÎ"
]
0.38 ms
(1.31%)
1
SELECT t0.template AS template_1, t0.id AS id_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.deleted_at AS deleted_at_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.position AS position_8, t0.slider_id AS slider_id_9, t0.team_id AS team_id_10 FROM common_layout_block t0 INNER JOIN system_page_to_block ON t0.id = system_page_to_block.block_id WHERE system_page_to_block.page_id = ? ORDER BY t0.position ASC
Parameters:
[
  b"\x01î¸xrCr¸ûI¤\x1Fa85Ø"
]
0.38 ms
(1.29%)
1
SELECT t0.id AS id_1, t0.created_by AS created_by_2, t0.updated_by AS updated_by_3, t0.deleted_at AS deleted_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM common_meta t0 WHERE t0.id = ?
Parameters:
[
  b"\x01’lÓ!ƒtF’Íïc“á­G"
]
0.37 ms
(1.28%)
1
SELECT t0.id AS id_1, t0.created_by AS created_by_2, t0.updated_by AS updated_by_3, t0.deleted_at AS deleted_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.locale AS locale_7, t0.title AS title_8, t0.slug AS slug_9, t0.is_active AS is_active_10, t0.content AS content_11, t0.translatable_id AS translatable_id_12 FROM system_page_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  b"\x01î¸xrCr¸ûI¤\x1Fa85Ø"
]
0.33 ms
(1.14%)
1
SELECT t0.site_name AS site_name_1, t0.description AS description_2, t0.keywords AS keywords_3, t0.image AS image_4, t0.id AS id_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.deleted_at AS deleted_at_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.locale AS locale_11, t0.title AS title_12, t0.slug AS slug_13, t0.translatable_id AS translatable_id_14 FROM common_meta_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  b"\x01’lÓ!ƒtF’Íïc“á­G"
]

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.

Entities Mapping

Class Mapping errors
App\Entity\Shared\AbstractEntity No errors.
App\Entity\Shared\AbstractTranslatableEntity No errors.
App\Entity\System\Page\Page No errors.
App\Entity\Common\Meta\Meta No errors.
App\Entity\Common\Layout\Block No errors.
App\Entity\Shared\AbstractTranslationEntity No errors.
App\Entity\System\Page\PageTranslation No errors.
App\Entity\Common\Layout\Slider\Slider No errors.
App\Entity\Company\Team\Team No errors.
App\Entity\Common\Layout\BlockTranslation No errors.
App\Entity\CaseStudy\CaseStudy No errors.
App\Entity\CaseStudy\CaseStudyTranslation No errors.
App\Entity\Company\Partner\Partner No errors.
App\Entity\Service\Service No errors.
App\Entity\Technology\Technology No errors.
App\Entity\System\Application\Application No errors.
App\Entity\System\Application\Config No errors.
App\Entity\System\Application\ApplicationTranslation No errors.
App\Entity\Common\Meta\MetaTranslation No errors.
App\Entity\System\Application\ConfigTranslation No errors.
App\Entity\Common\Layout\Slider\Slide No errors.
App\Entity\Common\Layout\Slider\SliderTranslation No errors.
App\Entity\Industry\Industry No errors.
App\Entity\Company\Team\TeamTranslation No errors.
App\Entity\Company\Partner\PartnerTranslation No errors.
App\Entity\Service\ServiceTranslation No errors.
App\Entity\Technology\TechnologyTranslation No errors.
App\Entity\Industry\IndustryTranslation No errors.
App\Entity\Investor\Announcement\Announcement No errors.
App\Entity\Common\Layout\Slider\SlideTranslation No errors.