GET https://ww.w.martinus-haren.de/?p=8

Query Metrics

13 Database Queries
12 Different statements
2.92 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.72 ms
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.content AS content_3, p0_.image AS image_4, p0_.description AS description_5, p0_.parish AS parish_6, p0_.video AS video_7, p0_.vis AS vis_8, p0_.start_at AS start_at_9, p0_.highli AS highli_10 FROM posts p0_ WHERE p0_.start_at >= ? AND p0_.vis LIKE ? AND p0_.highli LIKE ? ORDER BY p0_.start_at ASC
Parameters:
[
  "2024-12-23 15:55:15"
  1
  "%0%"
]
2 0.35 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.content AS content_3, p0_.image AS image_4, p0_.description AS description_5, p0_.parish AS parish_6, p0_.video AS video_7, p0_.vis AS vis_8, p0_.start_at AS start_at_9, p0_.highli AS highli_10 FROM posts p0_ WHERE p0_.start_at >= ? AND p0_.vis LIKE ? AND p0_.highli LIKE ? ORDER BY p0_.start_at ASC) dctrn_result) dctrn_table
Parameters:
[
  "2024-12-23 15:55:15"
  1
  "%0%"
]
3 0.31 ms
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.content AS content_3, p0_.image AS image_4, p0_.description AS description_5, p0_.parish AS parish_6, p0_.video AS video_7, p0_.vis AS vis_8, p0_.start_at AS start_at_9, p0_.highli AS highli_10 FROM posts p0_ WHERE p0_.start_at >= ? AND p0_.vis LIKE ? AND p0_.highli LIKE ? ORDER BY p0_.start_at ASC LIMIT 3 OFFSET 4
Parameters:
[
  "2024-12-23 15:55:15"
  1
  "%0%"
]
4 0.12 ms
SELECT w0_.id AS id_0, w0_.sort AS sort_1, w0_.title AS title_2, w0_.content AS content_3, w0_.file AS file_4, w0_.slug AS slug_5 FROM wtw w0_ ORDER BY w0_.sort ASC
Parameters:
[]
5 0.23 ms
SELECT d0_.id AS id_0, d0_.date AS date_1, d0_.title AS title_2, d0_.description AS description_3, d0_.place AS place_4, d0_.file AS file_5, d0_.slug AS slug_6 FROM dates d0_ WHERE d0_.date >= ? ORDER BY d0_.date ASC LIMIT 5
Parameters:
[
  "2024-12-23 15:55:15"
]
6 0.19 ms
SELECT d0_.id AS id_0, d0_.date AS date_1, d0_.title AS title_2, d0_.description AS description_3, d0_.place AS place_4, d0_.file AS file_5, d0_.slug AS slug_6 FROM dates d0_ WHERE d0_.date >= ? ORDER BY d0_.date ASC LIMIT 1
Parameters:
[
  "2024-12-23 15:55:15"
]
7 0.07 ms
SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.content AS content_2, l0_.file AS file_3 FROM laden l0_ ORDER BY l0_.id DESC LIMIT 1
Parameters:
[]
8 0.08 ms
SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.description AS description_2, g0_.image AS image_3, g0_.video AS video_4, g0_.date AS date_5 FROM galary g0_ ORDER BY g0_.date DESC LIMIT 10
Parameters:
[]
9 0.07 ms
SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.description AS description_2, g0_.image AS image_3, g0_.video AS video_4, g0_.date AS date_5 FROM galary g0_ ORDER BY g0_.date DESC LIMIT 3
Parameters:
[]
10 0.07 ms
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.content AS content_3, p0_.image AS image_4, p0_.description AS description_5, p0_.parish AS parish_6, p0_.video AS video_7, p0_.vis AS vis_8, p0_.start_at AS start_at_9, p0_.highli AS highli_10 FROM posts p0_ WHERE p0_.vis LIKE ? AND p0_.highli LIKE ? LIMIT 2
Parameters:
[
  "%1%"
  "%1%"
]
11 0.11 ms
SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.content AS content_2, j0_.image AS image_3, j0_.create_at AS create_at_4, j0_.updated_at AS updated_at_5, j0_.sectioon AS sectioon_6, j0_.pdf AS pdf_7 FROM jobs j0_ ORDER BY j0_.create_at DESC LIMIT 2
Parameters:
[]
12 0.14 ms
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.content AS content_3, p0_.image AS image_4, p0_.description AS description_5, p0_.parish AS parish_6, p0_.video AS video_7, p0_.vis AS vis_8, p0_.start_at AS start_at_9, p0_.highli AS highli_10 FROM posts p0_ WHERE p0_.start_at >= ? AND p0_.vis LIKE ? AND p0_.highli LIKE ? ORDER BY p0_.start_at ASC
Parameters:
[
  "2024-12-23 15:55:15"
  1
  "%0%"
]
13 0.45 ms
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, start_at_9 FROM (SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.content AS content_3, p0_.image AS image_4, p0_.description AS description_5, p0_.parish AS parish_6, p0_.video AS video_7, p0_.vis AS vis_8, p0_.start_at AS start_at_9, p0_.highli AS highli_10 FROM posts p0_ WHERE p0_.start_at >= ? AND p0_.vis LIKE ? AND p0_.highli LIKE ?) dctrn_result_inner ORDER BY start_at_9 ASC) dctrn_result LIMIT 7 OFFSET 49
Parameters:
[
  "2024-12-23 15:55:15"
  1
  "%0%"
]

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.

Entities Mapping

Class Mapping errors
App\Entity\Posts No errors.
App\Entity\Wtw No errors.
App\Entity\Dates No errors.
App\Entity\Laden No errors.
App\Entity\Galary No errors.
App\Entity\Jobs No errors.