GET https://test2.conrego.ngrok.app/

Query Metrics

56 Database Queries
16 Different statements
39.15 ms Query time
1 Invalid entities
30 Managed entities

Queries

Group similar statements

# Time Info
1 0.68 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "language_settings"
]
2 3.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "event_settings"
]
3 0.73 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "event_settings"
]
4 0.72 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "language_settings"
]
5 0.80 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM setting_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  6
]
6 0.62 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM setting_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  6
]
7 0.55 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.code AS code_2, c0_.enabled AS enabled_3 FROM currency c0_ WHERE c0_.enabled = 1
Parameters:
[]
8 0.50 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.code AS code_2, c0_.enabled AS enabled_3 FROM currency c0_ WHERE c0_.enabled = 1
Parameters:
[]
9 0.42 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.code AS code_2, c0_.enabled AS enabled_3 FROM currency c0_ WHERE c0_.enabled = 1
Parameters:
[]
10 0.40 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.code AS code_2, c0_.enabled AS enabled_3 FROM currency c0_ WHERE c0_.enabled = 1
Parameters:
[]
11 0.54 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "AnalyticalPlatforms"
]
12 0.40 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "group_registration"
]
13 0.67 ms
SELECT t0.id AS id_1, t0.order_number AS order_number_2, t0.registration_limit AS registration_limit_3, t0.hidden AS hidden_4, t0.password AS password_5, t0.show_for_languages AS show_for_languages_6, t0.hash AS hash_7, t0.template_id AS template_id_8 FROM ticket t0 WHERE t0.id = ?
Parameters:
[
  4
]
14 0.58 ms
SELECT t0.id AS id_1, t0.order_number AS order_number_2, t0.registration_limit AS registration_limit_3, t0.hidden AS hidden_4, t0.password AS password_5, t0.show_for_languages AS show_for_languages_6, t0.hash AS hash_7, t0.template_id AS template_id_8 FROM ticket t0 WHERE t0.id = ?
Parameters:
[
  1
]
15 0.54 ms
SELECT t0.id AS id_1, t0.order_number AS order_number_2, t0.registration_limit AS registration_limit_3, t0.hidden AS hidden_4, t0.password AS password_5, t0.show_for_languages AS show_for_languages_6, t0.hash AS hash_7, t0.template_id AS template_id_8 FROM ticket t0 WHERE t0.id = ?
Parameters:
[
  2
]
16 0.95 ms
SELECT t0.id AS id_1, t0.order_number AS order_number_2, t0.type AS type_3, t0.registration_limit AS registration_limit_4, t0.visible AS visible_5, t0.required AS required_6, t0.width AS width_7 FROM registration_form_agenda t0 WHERE t0.id = ?
Parameters:
[
  4
]
17 0.80 ms
SELECT t0.id AS id_1, t0.order_number AS order_number_2, t0.type AS type_3, t0.registration_limit AS registration_limit_4, t0.visible AS visible_5, t0.required AS required_6, t0.width AS width_7 FROM registration_form_agenda t0 WHERE t0.id = ?
Parameters:
[
  5
]
18 0.79 ms
SELECT t0.id AS id_1, t0.order_number AS order_number_2, t0.type AS type_3, t0.registration_limit AS registration_limit_4, t0.visible AS visible_5, t0.required AS required_6, t0.width AS width_7 FROM registration_form_agenda t0 WHERE t0.id = ?
Parameters:
[
  7
]
19 0.61 ms
SELECT t0.id AS id_1, t0.order_number AS order_number_2, t0.type AS type_3, t0.registration_limit AS registration_limit_4, t0.visible AS visible_5, t0.required AS required_6, t0.width AS width_7 FROM registration_form_agenda t0 WHERE t0.id = ?
Parameters:
[
  6
]
20 0.49 ms
SELECT t0.id AS id_1, t0.order_number AS order_number_2, t0.type AS type_3, t0.registration_limit AS registration_limit_4, t0.visible AS visible_5, t0.required AS required_6, t0.width AS width_7 FROM registration_form_agenda t0 WHERE t0.id = ?
Parameters:
[
  8
]
21 0.60 ms
SELECT t0.id AS id_1, t0.order_number AS order_number_2, t0.type AS type_3, t0.registration_limit AS registration_limit_4, t0.visible AS visible_5, t0.required AS required_6, t0.width AS width_7 FROM registration_form_agenda t0 WHERE t0.id = ?
Parameters:
[
  9
]
22 0.50 ms
SELECT t0.id AS id_1, t0.order_number AS order_number_2, t0.type AS type_3, t0.registration_limit AS registration_limit_4, t0.visible AS visible_5, t0.required AS required_6, t0.width AS width_7 FROM registration_form_agenda t0 WHERE t0.id = ?
Parameters:
[
  10
]
23 0.43 ms
SELECT t0.id AS id_1, t0.order_number AS order_number_2, t0.registration_limit AS registration_limit_3, t0.hidden AS hidden_4, t0.password AS password_5, t0.show_for_languages AS show_for_languages_6, t0.hash AS hash_7, t0.template_id AS template_id_8 FROM ticket t0 WHERE t0.id = ?
Parameters:
[
  "3"
]
24 0.72 ms
SELECT t0.id AS id_1, t0.redirect AS redirect_2, t0.parent_id AS parent_id_3, t0.list_order AS list_order_4, t0.is_homepage AS is_homepage_5, t0.is_visible AS is_visible_6, t0.has_banner AS has_banner_7, t0.has_regform AS has_regform_8, t0.is_in_menu AS is_in_menu_9, t0.url AS url_10, t0.title AS title_11, t0.content AS content_12, t0.main_css AS main_css_13, t0.section_css AS section_css_14, t0.locale AS locale_15 FROM page t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
  "/"
]
25 0.52 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.code AS code_2, c0_.enabled AS enabled_3 FROM currency c0_ WHERE c0_.enabled = 1
Parameters:
[]
26 0.51 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "BrandingSettings"
]
27 0.67 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "cookies_settings"
]
28 0.75 ms
SELECT a0_.id AS id_0, a0_.type AS type_1, a0_.content AS content_2, a0_.add_date AS add_date_3 FROM additional_frontend_code a0_ WHERE a0_.type = ? ORDER BY a0_.add_date DESC LIMIT 1
Parameters:
[
  "header"
]
29 0.53 ms
SELECT a0_.id AS id_0, a0_.type AS type_1, a0_.content AS content_2, a0_.add_date AS add_date_3 FROM additional_frontend_code a0_ WHERE a0_.type = ? ORDER BY a0_.add_date DESC LIMIT 1
Parameters:
[
  "footer"
]
30 0.75 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.page_id AS page_id_3, t0.block_id AS block_id_4 FROM page_block t0 WHERE t0.page_id = ? ORDER BY t0.position ASC
Parameters:
[
  1
]
31 0.50 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.is_active AS is_active_4, t0.settings AS settings_5, t0.items AS items_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM content_block t0 WHERE t0.id = ?
Parameters:
[
  1
]
32 0.40 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.is_active AS is_active_4, t0.settings AS settings_5, t0.items AS items_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM content_block t0 WHERE t0.id = ?
Parameters:
[
  2
]
33 0.51 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM content_block_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
34 0.50 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM content_block_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  2
]
35 0.76 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.code AS code_2, c0_.enabled AS enabled_3 FROM currency c0_ WHERE c0_.enabled = 1
Parameters:
[]
36 0.80 ms
SELECT count(r0_.id) AS sclr_0 FROM registration r0_ WHERE r0_.ticket_id = ? AND r0_.status IN (?, ?, ?, ?)
Parameters:
[
  1
  "completed"
  "paid"
  "not_paid"
  "accepted"
]
37 0.75 ms
SELECT count(r0_.id) AS sclr_0 FROM registration r0_ WHERE r0_.ticket_id = ? AND r0_.status IN (?, ?, ?, ?)
Parameters:
[
  2
  "completed"
  "paid"
  "not_paid"
  "accepted"
]
38 0.68 ms
SELECT count(r0_.id) AS sclr_0 FROM registration r0_ WHERE r0_.ticket_id = ? AND r0_.status IN (?, ?, ?, ?)
Parameters:
[
  3
  "completed"
  "paid"
  "not_paid"
  "accepted"
]
39 0.76 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.language AS language_3, t0.value AS value_4 FROM translation t0 WHERE t0.name = ? AND t0.language = ? LIMIT 1
Parameters:
[
  "group_registration_select_single"
  "pl"
]
40 0.48 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.language AS language_3, t0.value AS value_4 FROM translation t0 WHERE t0.name = ? AND t0.language = ? LIMIT 1
Parameters:
[
  "group_registration_select_single_desc"
  "pl"
]
41 0.55 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.language AS language_3, t0.value AS value_4 FROM translation t0 WHERE t0.name = ? AND t0.language = ? LIMIT 1
Parameters:
[
  "ticketChoose"
  "pl"
]
42 0.45 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.language AS language_3, t0.value AS value_4 FROM translation t0 WHERE t0.name = ? AND t0.language = ? LIMIT 1
Parameters:
[
  "select"
  "pl"
]
43 0.61 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM ticket_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
44 0.63 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM ticket_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  2
]
45 0.51 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.language AS language_3, t0.value AS value_4 FROM translation t0 WHERE t0.name = ? AND t0.language = ? LIMIT 1
Parameters:
[
  "ticketPassword"
  "pl"
]
46 0.45 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.language AS language_3, t0.value AS value_4 FROM translation t0 WHERE t0.name = ? AND t0.language = ? LIMIT 1
Parameters:
[
  "beginReg"
  "pl"
]
47 0.76 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.language AS language_3, t0.value AS value_4 FROM translation t0 WHERE t0.name = ? AND t0.language = ? LIMIT 1
Parameters:
[
  "group_registration_select_group"
  "pl"
]
48 4.00 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.language AS language_3, t0.value AS value_4 FROM translation t0 WHERE t0.name = ? AND t0.language = ? LIMIT 1
Parameters:
[
  "group_registration_select_group_desc"
  "pl"
]
49 0.57 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM ticket_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  3
]
50 0.52 ms
SELECT t0.id AS id_1, t0.redirect AS redirect_2, t0.parent_id AS parent_id_3, t0.list_order AS list_order_4, t0.is_homepage AS is_homepage_5, t0.is_visible AS is_visible_6, t0.has_banner AS has_banner_7, t0.has_regform AS has_regform_8, t0.is_in_menu AS is_in_menu_9, t0.url AS url_10, t0.title AS title_11, t0.content AS content_12, t0.main_css AS main_css_13, t0.section_css AS section_css_14, t0.locale AS locale_15 FROM page t0 WHERE t0.is_homepage = ?
Parameters:
[
  1
]
51 0.47 ms
SELECT t0.id AS id_1, t0.redirect AS redirect_2, t0.parent_id AS parent_id_3, t0.list_order AS list_order_4, t0.is_homepage AS is_homepage_5, t0.is_visible AS is_visible_6, t0.has_banner AS has_banner_7, t0.has_regform AS has_regform_8, t0.is_in_menu AS is_in_menu_9, t0.url AS url_10, t0.title AS title_11, t0.content AS content_12, t0.main_css AS main_css_13, t0.section_css AS section_css_14, t0.locale AS locale_15 FROM page t0 WHERE t0.locale = ? ORDER BY t0.list_order ASC
Parameters:
[
  "pl"
]
52 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "social_media"
]
53 0.51 ms
SELECT t0.id AS id_1, t0.original_name AS original_name_2, t0.filename AS filename_3, t0.type AS type_4, t0.size AS size_5, t0.mime_type AS mime_type_6, t0.add_date AS add_date_7, t0.protected AS protected_8, t0.ready AS ready_9, t0.temporary AS temporary_10 FROM file t0 WHERE t0.id = ?
Parameters:
[
  24
]
54 0.61 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.language AS language_3, t0.value AS value_4 FROM translation t0 WHERE t0.name = ? AND t0.language = ? LIMIT 1
Parameters:
[
  "cookies_text"
  "pl"
]
55 0.49 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.language AS language_3, t0.value AS value_4 FROM translation t0 WHERE t0.name = ? AND t0.language = ? LIMIT 1
Parameters:
[
  "cookies_accept"
  "pl"
]
56 0.57 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.language AS language_3, t0.value AS value_4 FROM translation t0 WHERE t0.name = ? AND t0.language = ? LIMIT 1
Parameters:
[
  "cookies_accept_required"
  "pl"
]

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\Core\Doctrine\Entity\RegistrationForm\RegistrationFormAgenda 7
App\Core\Doctrine\Entity\Setting\Setting 4
App\Core\Doctrine\Entity\Ticket\Ticket 4
App\Core\Doctrine\Entity\Ticket\TicketTranslation 3
App\Core\Doctrine\Entity\TicketTemplate\TicketTemplate 2
App\Core\Doctrine\Entity\Page\PageBlock 2
App\Core\Doctrine\Entity\ContentBlock\ContentBlock 2
App\Core\Doctrine\Entity\ContentBlock\ContentBlockTranslation 2
App\Core\Doctrine\Entity\Setting\SettingTranslation 1
App\Core\Doctrine\Entity\Payment\Currency 1
App\Core\Doctrine\Entity\Page\Page 1
App\Core\Doctrine\Entity\File\File 1