Query Metrics
27
Database Queries
5
Different statements
6.41 ms
Query time
0
Invalid entities
200
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.88 ms |
SELECT k0_.id AS id_0, k0_.old_id AS old_id_1, k0_.type AS type_2, k0_.page AS page_3, k0_.girl AS girl_4, k0_.intname AS intname_5, k0_.mainpage AS mainpage_6, k0_.name AS name_7, k0_.href AS href_8, k0_.short AS short_9, k0_.cont AS cont_10, k0_.cont2 AS cont2_11, k0_.prior AS prior_12, k0_.visible AS visible_13, k0_.autosub AS autosub_14, k0_.title AS title_15, k0_.h1 AS h1_16, k0_.h3 AS h3_17, k0_.kw AS kw_18, k0_.descr AS descr_19, k0_.tstamp AS tstamp_20, k0_.rating AS rating_21, k0_.noindex AS noindex_22, k0_.footmenu AS footmenu_23, k0_.video AS video_24, k0_.showon AS showon_25, k0_.topmenu AS topmenu_26, k0_.topmenu2 AS topmenu2_27, k0_.spec AS spec_28 FROM ke_page k0_ WHERE (k0_.showon LIKE ? OR k0_.showon = '') AND k0_.type = ? AND k0_.visible = 1 AND k0_.page = 0 AND k0_.footmenu = 1 ORDER BY k0_.prior DESC
Parameters:
[ "%r%" "page" ] |
| 2 | 0.18 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM ke_page_translation t0 WHERE t0.object_id = ?
Parameters:
[
13
]
|
| 3 | 0.25 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM ke_page_translation t0 WHERE t0.object_id = ?
Parameters:
[
28
]
|
| 4 | 0.15 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM ke_page_translation t0 WHERE t0.object_id = ?
Parameters:
[
24
]
|
| 5 | 0.13 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM ke_page_translation t0 WHERE t0.object_id = ?
Parameters:
[
26
]
|
| 6 | 0.14 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM ke_page_translation t0 WHERE t0.object_id = ?
Parameters:
[
18
]
|
| 7 | 0.14 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM ke_page_translation t0 WHERE t0.object_id = ?
Parameters:
[
19
]
|
| 8 | 0.16 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM ke_page_translation t0 WHERE t0.object_id = ?
Parameters:
[
20
]
|
| 9 | 0.14 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM ke_page_translation t0 WHERE t0.object_id = ?
Parameters:
[
14
]
|
| 10 | 0.20 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM ke_page_translation t0 WHERE t0.object_id = ?
Parameters:
[
21
]
|
| 11 | 0.16 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM ke_page_translation t0 WHERE t0.object_id = ?
Parameters:
[
25
]
|
| 12 | 0.33 ms |
SELECT f0_.id AS id_0, f0_.intname AS intname_1, f0_.name AS name_2, f0_.cont AS cont_3, f0_.visible AS visible_4, f0_.title AS title_5, f0_.h1 AS h1_6, f0_.kw AS kw_7, f0_.descr AS descr_8 FROM filterpage f0_ WHERE f0_.visible = 1 ORDER BY f0_.id DESC LIMIT 8
Parameters:
[] |
| 13 | 0.16 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM filterpage_translation t0 WHERE t0.object_id = ?
Parameters:
[
8
]
|
| 14 | 0.17 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM filterpage_translation t0 WHERE t0.object_id = ?
Parameters:
[
7
]
|
| 15 | 0.18 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM filterpage_translation t0 WHERE t0.object_id = ?
Parameters:
[
6
]
|
| 16 | 0.26 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM filterpage_translation t0 WHERE t0.object_id = ?
Parameters:
[
5
]
|
| 17 | 0.17 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM filterpage_translation t0 WHERE t0.object_id = ?
Parameters:
[
4
]
|
| 18 | 0.19 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM filterpage_translation t0 WHERE t0.object_id = ?
Parameters:
[
3
]
|
| 19 | 0.16 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM filterpage_translation t0 WHERE t0.object_id = ?
Parameters:
[
2
]
|
| 20 | 0.20 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM filterpage_translation t0 WHERE t0.object_id = ?
Parameters:
[
1
]
|
| 21 | 0.24 ms |
SELECT k0_.id AS id_0, k0_.old_id AS old_id_1, k0_.type AS type_2, k0_.page AS page_3, k0_.girl AS girl_4, k0_.intname AS intname_5, k0_.mainpage AS mainpage_6, k0_.name AS name_7, k0_.href AS href_8, k0_.short AS short_9, k0_.cont AS cont_10, k0_.cont2 AS cont2_11, k0_.prior AS prior_12, k0_.visible AS visible_13, k0_.autosub AS autosub_14, k0_.title AS title_15, k0_.h1 AS h1_16, k0_.h3 AS h3_17, k0_.kw AS kw_18, k0_.descr AS descr_19, k0_.tstamp AS tstamp_20, k0_.rating AS rating_21, k0_.noindex AS noindex_22, k0_.footmenu AS footmenu_23, k0_.video AS video_24, k0_.showon AS showon_25, k0_.topmenu AS topmenu_26, k0_.topmenu2 AS topmenu2_27, k0_.spec AS spec_28 FROM ke_page k0_ WHERE (k0_.showon LIKE ? OR k0_.showon = '') AND k0_.visible = 1 AND k0_.type = ? ORDER BY k0_.tstamp DESC, k0_.id DESC LIMIT 6
Parameters:
[ "%r%" "article" ] |
| 22 | 0.36 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM ke_page_translation t0 WHERE t0.object_id = ?
Parameters:
[
42
]
|
| 23 | 0.26 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM ke_page_translation t0 WHERE t0.object_id = ?
Parameters:
[
39
]
|
| 24 | 0.38 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM ke_page_translation t0 WHERE t0.object_id = ?
Parameters:
[
37
]
|
| 25 | 0.29 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM ke_page_translation t0 WHERE t0.object_id = ?
Parameters:
[
35
]
|
| 26 | 0.23 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM ke_page_translation t0 WHERE t0.object_id = ?
Parameters:
[
34
]
|
| 27 | 0.31 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM ke_page_translation t0 WHERE t0.object_id = ?
Parameters:
[
32
]
|
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\Translation\PageTranslation | 96 |
| App\Entity\Translation\FilterpageTranslation | 80 |
| App\Entity\Page | 16 |
| App\Entity\Filterpage | 8 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Block | No errors. |
| Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation | No errors. |
| App\Entity\Translation\BlockTranslation | No errors. |
| App\Entity\Comment | No errors. |
| App\Entity\Event | No errors. |
| App\Entity\Translation\EventTranslation | No errors. |
| App\Entity\Page | No errors. |
| App\Entity\Translation\PageTranslation | No errors. |
| App\Entity\Video | No errors. |
| App\Entity\Translation\VideoTranslation | No errors. |
| App\Entity\Filterpage | No errors. |
| App\Entity\Translation\FilterpageTranslation | No errors. |