Query Metrics
18
Database Queries
9
Different statements
10.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
3.10 ms (28.52%) |
7 |
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"
]
|
|
3.09 ms (28.40%) |
2 |
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"
]
|
|
1.84 ms (16.92%) |
3 |
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" ] |
|
0.56 ms (5.11%) |
1 |
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
]
|
|
0.55 ms (5.08%) |
1 |
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"
]
|
|
0.47 ms (4.35%) |
1 |
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:
[
0
]
|
|
0.47 ms (4.31%) |
1 |
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:
[] |
|
0.42 ms (3.84%) |
1 |
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
]
|
|
0.38 ms (3.46%) |
1 |
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:
[
"/robots.txt"
]
|
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\Core\Doctrine\Entity\Setting\Setting | No errors. |
| App\Core\Doctrine\Entity\Setting\SettingTranslation | No errors. |
| App\Core\Doctrine\Entity\Ticket\Ticket | No errors. |
| App\Core\Doctrine\Entity\TicketTemplate\TicketTemplate | No errors. |
| App\Core\Doctrine\Entity\Page\Page | No errors. |
| App\Core\Doctrine\Entity\Payment\Currency | No errors. |
| App\Core\Doctrine\Entity\Setting\AdditionalFrontendCode | No errors. |
| App\Core\Doctrine\Entity\Translation\Translation | No errors. |