GET https://new.escort.vc/r/publication

Query Metrics

109 Database Queries
6 Different statements
53.36 ms Query time
0 Invalid entities
1097 Managed entities

Grouped Statements

Show all queries

Time Count Info
45.51 ms
(85.30%)
97
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
]
2.77 ms
(5.19%)
1
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_.visible = 1 AND p0_.type = ? ORDER BY p0_.tstamp DESC, p0_.id DESC
Parameters:
[
  "%r%"
  "article"
]
1.86 ms
(3.48%)
8
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
]
1.66 ms
(3.11%)
1
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 ? AND p0_.type = ? AND p0_.visible = 1 AND p0_.intname = ?
Parameters:
[
  "%r%"
  "page"
  "publication"
]
1.27 ms
(2.38%)
1
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:
[
  "%r%"
  "page"
]
0.29 ms
(0.55%)
1
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:
[]

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 912
App\Entity\Page 97
App\Entity\Translation\FilterpageTranslation 80
App\Entity\Filterpage 8