Query Metrics
43
Database Queries
10
Different statements
11.58 ms
Query time
0
Invalid entities
7
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.80 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:
[ "%ru%" "page" ] |
| 2 | 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:
[
13
]
|
| 3 | 0.11 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.11 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.11 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.12 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.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:
[
19
]
|
| 8 | 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:
[
20
]
|
| 9 | 0.10 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.11 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.11 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.27 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.22 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.21 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.22 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.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 filterpage_translation t0 WHERE t0.object_id = ?
Parameters:
[
5
]
|
| 17 | 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:
[
4
]
|
| 18 | 0.30 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.30 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.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 filterpage_translation t0 WHERE t0.object_id = ?
Parameters:
[
1
]
|
| 21 | 0.33 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:
[ "%ru%" "article" ] |
| 22 | 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:
[
42
]
|
| 23 | 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 ke_page_translation t0 WHERE t0.object_id = ?
Parameters:
[
39
]
|
| 24 | 0.12 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.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:
[
35
]
|
| 26 | 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:
[
34
]
|
| 27 | 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:
[
32
]
|
| 28 | 0.30 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_.topmenu = 1 ORDER BY k0_.prior DESC
Parameters:
[ "%ru%" "page" ] |
| 29 | 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:
[
13
]
|
| 30 | 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 ke_page_translation t0 WHERE t0.object_id = ?
Parameters:
[
28
]
|
| 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 ke_page_translation t0 WHERE t0.object_id = ?
Parameters:
[
24
]
|
| 32 | 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:
[
26
]
|
| 33 | 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:
[
18
]
|
| 34 | 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:
[
19
]
|
| 35 | 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 ke_page_translation t0 WHERE t0.object_id = ?
Parameters:
[
21
]
|
| 36 | 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 ke_page_translation t0 WHERE t0.object_id = ?
Parameters:
[
25
]
|
| 37 | 0.33 ms |
SELECT k0_.id AS id_0, k0_.girl AS girl_1, k0_.intname AS intname_2, k0_.name AS name_3, k0_.video AS video_4, k0_.cont AS cont_5, k0_.prior AS prior_6, k0_.title AS title_7, k0_.h1 AS h1_8, k0_.kw AS kw_9, k0_.descr AS descr_10, k0_.visible AS visible_11, k0_.hidden AS hidden_12 FROM ke_video k0_ WHERE k0_.girl IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY k0_.prior DESC, k0_.id DESC
Parameters:
[ 1063 963 871 957 1127 716 1043 965 568 866 1053 1122 1146 1135 1129 976 629 605 746 622 1045 1150 1155 1157 1078 1014 1119 863 893 1140 864 968 1109 1158 1121 1100 977 1070 1029 693 1020 1094 1112 1133 1117 1149 826 1156 1138 1154 1126 1036 1046 1151 ] |
| 38 | 0.30 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_video_translation t0 WHERE t0.object_id = ?
Parameters:
[
42
]
|
| 39 | 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_video_translation t0 WHERE t0.object_id = ?
Parameters:
[
32
]
|
| 40 | 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_video_translation t0 WHERE t0.object_id = ?
Parameters:
[
22
]
|
| 41 | 0.34 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 ? AND k0_.type = ? AND k0_.visible = 1 AND k0_.intname = ?
Parameters:
[ "%ru%" "page" "allmodels" ] |
| 42 | 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:
[
17
]
|
| 43 | 1.01 ms |
SELECT k0_.id AS id_0, k0_.lang AS lang_1, k0_.par AS par_2, k0_.type AS type_3, k0_.user AS user_4, k0_.author AS author_5, k0_.tstamp AS tstamp_6, k0_.cont AS cont_7, k0_.visible AS visible_8, k0_.confirmed AS confirmed_9, k0_.rating AS rating_10, k0_.meeting AS meeting_11, k0_.phone AS phone_12, k0_.email AS email_13, k0_.ip AS ip_14 FROM ke_comment k0_ WHERE k0_.visible = 1 AND k0_.type = ? AND k0_.par = ? AND k0_.lang = ?
Parameters:
[ "girl" 976 "ru" ] |
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 | 6 |
| App\Entity\Page | 1 |
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. |
| App\Entity\Sett | No errors. |