Query Metrics
38
Database Queries
7
Different statements
28.83 ms
Query time
0
Invalid entities
382
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 3.44 ms |
SELECT p0_.id AS id_0, p0_.old_id AS old_id_1, p0_.type AS type_2, p0_.page AS page_3, p0_.girl AS girl_4, p0_.intname AS intname_5, p0_.mainpage AS mainpage_6, p0_.name AS name_7, p0_.href AS href_8, p0_.short AS short_9, p0_.cont AS cont_10, p0_.cont2 AS cont2_11, p0_.prior AS prior_12, p0_.visible AS visible_13, p0_.autosub AS autosub_14, p0_.title AS title_15, p0_.h1 AS h1_16, p0_.h3 AS h3_17, p0_.kw AS kw_18, p0_.descr AS descr_19, p0_.tstamp AS tstamp_20, p0_.rating AS rating_21, p0_.noindex AS noindex_22, p0_.footmenu AS footmenu_23, p0_.video AS video_24, p0_.showon AS showon_25, p0_.topmenu AS topmenu_26, p0_.topmenu2 AS topmenu2_27, p0_.spec AS spec_28 FROM page p0_ WHERE (p0_.showon LIKE ? OR p0_.showon = '') AND p0_.type = ? AND p0_.visible = 1 AND p0_.page = 0 AND p0_.footmenu = 1 ORDER BY p0_.prior DESC
Parameters:
[ "%pl%" "page" ] |
| 2 | 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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
47
]
|
| 3 | 0.39 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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
222
]
|
| 4 | 0.27 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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
223
]
|
| 5 | 0.43 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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
224
]
|
| 6 | 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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
152
]
|
| 7 | 0.39 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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
207
]
|
| 8 | 0.35 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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
42
]
|
| 9 | 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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
139
]
|
| 10 | 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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
147
]
|
| 11 | 0.32 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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
45
]
|
| 12 | 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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
210
]
|
| 13 | 0.32 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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
140
]
|
| 14 | 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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
216
]
|
| 15 | 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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
217
]
|
| 16 | 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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
116
]
|
| 17 | 0.45 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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
141
]
|
| 18 | 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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
57
]
|
| 19 | 0.42 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:
[] |
| 20 | 0.66 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
]
|
| 21 | 0.28 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
]
|
| 22 | 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:
[
6
]
|
| 23 | 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 filterpage_translation t0 WHERE t0.object_id = ?
Parameters:
[
5
]
|
| 24 | 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:
[
4
]
|
| 25 | 0.63 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
]
|
| 26 | 0.43 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
]
|
| 27 | 0.46 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
]
|
| 28 | 0.40 ms |
SELECT t0.id AS id_1, t0.old_id AS old_id_2, t0.type AS type_3, t0.page AS page_4, t0.girl AS girl_5, t0.intname AS intname_6, t0.mainpage AS mainpage_7, t0.name AS name_8, t0.href AS href_9, t0.short AS short_10, t0.cont AS cont_11, t0.cont2 AS cont2_12, t0.prior AS prior_13, t0.visible AS visible_14, t0.autosub AS autosub_15, t0.title AS title_16, t0.h1 AS h1_17, t0.h3 AS h3_18, t0.kw AS kw_19, t0.descr AS descr_20, t0.tstamp AS tstamp_21, t0.rating AS rating_22, t0.noindex AS noindex_23, t0.footmenu AS footmenu_24, t0.video AS video_25, t0.showon AS showon_26, t0.topmenu AS topmenu_27, t0.topmenu2 AS topmenu2_28, t0.spec AS spec_29 FROM page t0 WHERE t0.mainpage = ? LIMIT 1
Parameters:
[
"1"
]
|
| 29 | 0.32 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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
41
]
|
| 30 | 12.71 ms |
SELECT e0_.id AS id_0, e0_.type AS type_1, e0_.girl AS girl_2, e0_.rel AS rel_3, e0_.girlintname AS girlintname_4, e0_.name AS name_5, e0_.href AS href_6, e0_.short AS short_7, e0_.cont AS cont_8, e0_.tstamp AS tstamp_9, e0_.lang AS lang_10, e0_.website AS website_11 FROM event e0_ WHERE e0_.lang LIKE ? OR e0_.lang = '' ORDER BY e0_.tstamp DESC LIMIT 8
Parameters:
[
"%pl%"
]
|
| 31 | 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 event_translation t0 WHERE t0.object_id = ?
Parameters:
[
22364
]
|
| 32 | 0.33 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 event_translation t0 WHERE t0.object_id = ?
Parameters:
[
22363
]
|
| 33 | 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 event_translation t0 WHERE t0.object_id = ?
Parameters:
[
22365
]
|
| 34 | 0.28 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 event_translation t0 WHERE t0.object_id = ?
Parameters:
[
22366
]
|
| 35 | 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 event_translation t0 WHERE t0.object_id = ?
Parameters:
[
22355
]
|
| 36 | 0.57 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 event_translation t0 WHERE t0.object_id = ?
Parameters:
[
22354
]
|
| 37 | 0.43 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 event_translation t0 WHERE t0.object_id = ?
Parameters:
[
22346
]
|
| 38 | 0.47 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 event_translation t0 WHERE t0.object_id = ?
Parameters:
[
22345
]
|
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 | 249 |
| App\Entity\Translation\FilterpageTranslation | 80 |
| App\Entity\Translation\EventTranslation | 19 |
| App\Entity\Page | 18 |
| App\Entity\Filterpage | 8 |
| App\Entity\Event | 8 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Page | No errors. |
| Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation | No errors. |
| App\Entity\Translation\PageTranslation | No errors. |
| App\Entity\Filterpage | No errors. |
| App\Entity\Translation\FilterpageTranslation | No errors. |
| App\Entity\Event | No errors. |
| App\Entity\Translation\EventTranslation | No errors. |