Query Metrics
11
Database Queries
7
Different statements
5.73 ms
Query time
0
Invalid entities
40
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.17 ms |
SELECT c0_.id AS id_0, c0_.old_id AS old_id_1, c0_.type AS type_2, c0_.page AS page_3, c0_.girl AS girl_4, c0_.intname AS intname_5, c0_.mainpage AS mainpage_6, c0_.name AS name_7, c0_.href AS href_8, c0_.short AS short_9, c0_.cont AS cont_10, c0_.cont2 AS cont2_11, c0_.prior AS prior_12, c0_.visible AS visible_13, c0_.autosub AS autosub_14, c0_.title AS title_15, c0_.h1 AS h1_16, c0_.h3 AS h3_17, c0_.kw AS kw_18, c0_.descr AS descr_19, c0_.tstamp AS tstamp_20, c0_.rating AS rating_21, c0_.noindex AS noindex_22, c0_.footmenu AS footmenu_23, c0_.video AS video_24, c0_.showon AS showon_25, c0_.topmenu AS topmenu_26, c0_.topmenu2 AS topmenu2_27, c0_.spec AS spec_28 FROM cary_page c0_ WHERE (c0_.showon LIKE ? OR c0_.showon = '') AND c0_.visible = 1 AND c0_.type = ? ORDER BY c0_.tstamp DESC, c0_.id DESC LIMIT 6
Parameters:
[ "%en%" "article" ] |
| 2 | 0.56 ms |
SELECT c0_.id AS id_0, c0_.old_id AS old_id_1, c0_.type AS type_2, c0_.page AS page_3, c0_.girl AS girl_4, c0_.intname AS intname_5, c0_.mainpage AS mainpage_6, c0_.name AS name_7, c0_.href AS href_8, c0_.short AS short_9, c0_.cont AS cont_10, c0_.cont2 AS cont2_11, c0_.prior AS prior_12, c0_.visible AS visible_13, c0_.autosub AS autosub_14, c0_.title AS title_15, c0_.h1 AS h1_16, c0_.h3 AS h3_17, c0_.kw AS kw_18, c0_.descr AS descr_19, c0_.tstamp AS tstamp_20, c0_.rating AS rating_21, c0_.noindex AS noindex_22, c0_.footmenu AS footmenu_23, c0_.video AS video_24, c0_.showon AS showon_25, c0_.topmenu AS topmenu_26, c0_.topmenu2 AS topmenu2_27, c0_.spec AS spec_28 FROM cary_page c0_ WHERE (c0_.showon LIKE ? OR c0_.showon = '') AND c0_.type = ? AND c0_.visible = 1 AND c0_.page = 0 AND c0_.footmenu = 1 ORDER BY c0_.prior DESC
Parameters:
[ "%en%" "page" ] |
| 3 | 0.52 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:
[] |
| 4 | 0.29 ms |
SELECT c0_.id AS id_0, c0_.old_id AS old_id_1, c0_.type AS type_2, c0_.page AS page_3, c0_.girl AS girl_4, c0_.intname AS intname_5, c0_.mainpage AS mainpage_6, c0_.name AS name_7, c0_.href AS href_8, c0_.short AS short_9, c0_.cont AS cont_10, c0_.cont2 AS cont2_11, c0_.prior AS prior_12, c0_.visible AS visible_13, c0_.autosub AS autosub_14, c0_.title AS title_15, c0_.h1 AS h1_16, c0_.h3 AS h3_17, c0_.kw AS kw_18, c0_.descr AS descr_19, c0_.tstamp AS tstamp_20, c0_.rating AS rating_21, c0_.noindex AS noindex_22, c0_.footmenu AS footmenu_23, c0_.video AS video_24, c0_.showon AS showon_25, c0_.topmenu AS topmenu_26, c0_.topmenu2 AS topmenu2_27, c0_.spec AS spec_28 FROM cary_page c0_ WHERE (c0_.showon LIKE ? OR c0_.showon = '') AND c0_.visible = 1 AND c0_.type = ? ORDER BY c0_.tstamp DESC, c0_.id DESC LIMIT 6
Parameters:
[ "%en%" "article" ] |
| 5 | 0.25 ms |
SELECT c0_.id AS id_0, c0_.old_id AS old_id_1, c0_.type AS type_2, c0_.page AS page_3, c0_.girl AS girl_4, c0_.intname AS intname_5, c0_.mainpage AS mainpage_6, c0_.name AS name_7, c0_.href AS href_8, c0_.short AS short_9, c0_.cont AS cont_10, c0_.cont2 AS cont2_11, c0_.prior AS prior_12, c0_.visible AS visible_13, c0_.autosub AS autosub_14, c0_.title AS title_15, c0_.h1 AS h1_16, c0_.h3 AS h3_17, c0_.kw AS kw_18, c0_.descr AS descr_19, c0_.tstamp AS tstamp_20, c0_.rating AS rating_21, c0_.noindex AS noindex_22, c0_.footmenu AS footmenu_23, c0_.video AS video_24, c0_.showon AS showon_25, c0_.topmenu AS topmenu_26, c0_.topmenu2 AS topmenu2_27, c0_.spec AS spec_28 FROM cary_page c0_ WHERE (c0_.showon LIKE ? OR c0_.showon = '') AND c0_.type = ? AND c0_.visible = 1 AND c0_.page = 0 AND c0_.topmenu = 1 ORDER BY c0_.prior DESC
Parameters:
[ "%en%" "page" ] |
| 6 | 0.22 ms |
SELECT c0_.id AS id_0, c0_.old_id AS old_id_1, c0_.type AS type_2, c0_.page AS page_3, c0_.girl AS girl_4, c0_.intname AS intname_5, c0_.mainpage AS mainpage_6, c0_.name AS name_7, c0_.href AS href_8, c0_.short AS short_9, c0_.cont AS cont_10, c0_.cont2 AS cont2_11, c0_.prior AS prior_12, c0_.visible AS visible_13, c0_.autosub AS autosub_14, c0_.title AS title_15, c0_.h1 AS h1_16, c0_.h3 AS h3_17, c0_.kw AS kw_18, c0_.descr AS descr_19, c0_.tstamp AS tstamp_20, c0_.rating AS rating_21, c0_.noindex AS noindex_22, c0_.footmenu AS footmenu_23, c0_.video AS video_24, c0_.showon AS showon_25, c0_.topmenu AS topmenu_26, c0_.topmenu2 AS topmenu2_27, c0_.spec AS spec_28 FROM cary_page c0_ WHERE (c0_.showon LIKE ? OR c0_.showon = '') AND c0_.type = ? AND c0_.visible = 1 AND c0_.page = 0 AND c0_.topmenu = 1 ORDER BY c0_.prior DESC
Parameters:
[ "%en%" "page" ] |
| 7 | 0.39 ms |
SELECT c0_.id AS id_0, c0_.old_id AS old_id_1, c0_.type AS type_2, c0_.page AS page_3, c0_.girl AS girl_4, c0_.intname AS intname_5, c0_.mainpage AS mainpage_6, c0_.name AS name_7, c0_.href AS href_8, c0_.short AS short_9, c0_.cont AS cont_10, c0_.cont2 AS cont2_11, c0_.prior AS prior_12, c0_.visible AS visible_13, c0_.autosub AS autosub_14, c0_.title AS title_15, c0_.h1 AS h1_16, c0_.h3 AS h3_17, c0_.kw AS kw_18, c0_.descr AS descr_19, c0_.tstamp AS tstamp_20, c0_.rating AS rating_21, c0_.noindex AS noindex_22, c0_.footmenu AS footmenu_23, c0_.video AS video_24, c0_.showon AS showon_25, c0_.topmenu AS topmenu_26, c0_.topmenu2 AS topmenu2_27, c0_.spec AS spec_28 FROM cary_page c0_ WHERE c0_.showon LIKE ? AND c0_.type = ? AND c0_.visible = 1 AND c0_.intname = ?
Parameters:
[ "%en%" "page" "health-certificates" ] |
| 8 | 0.73 ms |
SELECT s0_.id AS id_0, s0_.type AS type_1, s0_.spec AS spec_2, s0_.par AS par_3, s0_.name AS name_4, s0_.prior AS prior_5, s0_.visible AS visible_6, s0_.tstamp AS tstamp_7 FROM spravka s0_ WHERE s0_.type = ? AND s0_.par = ? ORDER BY s0_.prior DESC
Parameters:
[ "girl" 605 ] |
| 9 | 0.52 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 spravka_translation t0 WHERE t0.object_id = ?
Parameters:
[
1865
]
|
| 10 | 0.41 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 spravka_translation t0 WHERE t0.object_id = ?
Parameters:
[
1863
]
|
| 11 | 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 spravka_translation t0 WHERE t0.object_id = ?
Parameters:
[
1864
]
|
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\Page | 23 |
| App\Entity\Filterpage | 8 |
| App\Entity\Translation\SpravkaTranslation | 6 |
| App\Entity\Spravka | 3 |
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\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\Spravka | No errors. |
| App\Entity\Translation\SpravkaTranslation | No errors. |