GET https://confident-wilson.95-216-76-58.plesk.page/

Query Metrics

39 Database Queries
8 Different statements
31.93 ms Query time
0 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 1.23 ms
SELECT c0_.id AS id_0, c0_.migration_id AS migration_id_1, c0_.name AS name_2, c0_.slug AS slug_3, c0_.description AS description_4, c0_.view_type AS view_type_5, c0_.lft AS lft_6, c0_.lvl AS lvl_7, c0_.rgt AS rgt_8, c0_.published AS published_9, c0_.show_in_menu AS show_in_menu_10, c0_.sort_index AS sort_index_11, c0_.tree_root AS tree_root_12, c0_.parent_id AS parent_id_13, c0_.image_id AS image_id_14 FROM category c0_ WHERE c0_.published = ? AND c0_.show_in_menu = ? ORDER BY c0_.tree_root ASC, c0_.lft ASC
Parameters:
[
  1
  1
]
2 0.45 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "2"
  "el"
  "App\Entity\Category"
]
3 0.32 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "3"
  "el"
  "App\Entity\Category"
]
4 0.31 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "19"
  "el"
  "App\Entity\Category"
]
5 0.29 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "28"
  "el"
  "App\Entity\Category"
]
6 0.29 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "26"
  "el"
  "App\Entity\Category"
]
7 0.29 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "14"
  "el"
  "App\Entity\Category"
]
8 0.30 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "15"
  "el"
  "App\Entity\Category"
]
9 0.27 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "32"
  "el"
  "App\Entity\Category"
]
10 0.28 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "20"
  "el"
  "App\Entity\Category"
]
11 0.25 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "45"
  "el"
  "App\Entity\Category"
]
12 0.27 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "44"
  "el"
  "App\Entity\Category"
]
13 0.25 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "43"
  "el"
  "App\Entity\Category"
]
14 0.30 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "34"
  "el"
  "App\Entity\Category"
]
15 0.24 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "18"
  "el"
  "App\Entity\Category"
]
16 0.32 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "13"
  "el"
  "App\Entity\Category"
]
17 0.29 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "27"
  "el"
  "App\Entity\Category"
]
18 0.28 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "9"
  "el"
  "App\Entity\Category"
]
19 0.24 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "17"
  "el"
  "App\Entity\Category"
]
20 0.26 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "24"
  "el"
  "App\Entity\Category"
]
21 0.24 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "25"
  "el"
  "App\Entity\Category"
]
22 0.27 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "35"
  "el"
  "App\Entity\Category"
]
23 0.25 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "36"
  "el"
  "App\Entity\Category"
]
24 0.32 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "16"
  "el"
  "App\Entity\Category"
]
25 0.25 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "33"
  "el"
  "App\Entity\Category"
]
26 0.30 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "4"
  "el"
  "App\Entity\Category"
]
27 0.25 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "7"
  "el"
  "App\Entity\Category"
]
28 0.85 ms
SELECT a0_.id AS id_0, a0_.custom_id AS custom_id_1, a0_.title AS title_2, a0_.teaser AS teaser_3, a0_.slider_title AS slider_title_4, a0_.slug AS slug_5, a0_.slider_position AS slider_position_6, a0_.summary AS summary_7, a0_.body AS body_8, a0_.created_at AS created_at_9, a0_.event_date AS event_date_10, a0_.updated_at AS updated_at_11, a0_.published AS published_12, a0_.file_name AS file_name_13, a0_.author_id AS author_id_14, a0_.image_id AS image_id_15 FROM article a0_ WHERE NOT (a0_.slider_position = ?) ORDER BY a0_.slider_position ASC
Parameters:
[
  0
]
29 2.43 ms
SELECT a0_.id AS id_0, a0_.custom_id AS custom_id_1, a0_.title AS title_2, a0_.teaser AS teaser_3, a0_.slider_title AS slider_title_4, a0_.slug AS slug_5, a0_.slider_position AS slider_position_6, a0_.summary AS summary_7, a0_.body AS body_8, a0_.created_at AS created_at_9, a0_.event_date AS event_date_10, a0_.updated_at AS updated_at_11, a0_.published AS published_12, a0_.file_name AS file_name_13, a0_.author_id AS author_id_14, a0_.image_id AS image_id_15 FROM article a0_ INNER JOIN articles_categories a2_ ON a0_.id = a2_.article_id INNER JOIN category c1_ ON c1_.id = a2_.category_id WHERE c1_.slug IN (?) ORDER BY a0_.created_at DESC LIMIT 1
Parameters:
[
  "excursion"
]
30 0.61 ms
SELECT a0_.id AS id_0, a0_.custom_id AS custom_id_1, a0_.title AS title_2, a0_.teaser AS teaser_3, a0_.slider_title AS slider_title_4, a0_.slug AS slug_5, a0_.slider_position AS slider_position_6, a0_.summary AS summary_7, a0_.body AS body_8, a0_.created_at AS created_at_9, a0_.event_date AS event_date_10, a0_.updated_at AS updated_at_11, a0_.published AS published_12, a0_.file_name AS file_name_13, a0_.author_id AS author_id_14, a0_.image_id AS image_id_15 FROM article a0_ INNER JOIN articles_categories a2_ ON a0_.id = a2_.article_id INNER JOIN category c1_ ON c1_.id = a2_.category_id WHERE c1_.slug IN (?) ORDER BY a0_.created_at DESC LIMIT 1
Parameters:
[
  "chess-parts"
]
31 0.60 ms
SELECT a0_.id AS id_0, a0_.custom_id AS custom_id_1, a0_.title AS title_2, a0_.teaser AS teaser_3, a0_.slider_title AS slider_title_4, a0_.slug AS slug_5, a0_.slider_position AS slider_position_6, a0_.summary AS summary_7, a0_.body AS body_8, a0_.created_at AS created_at_9, a0_.event_date AS event_date_10, a0_.updated_at AS updated_at_11, a0_.published AS published_12, a0_.file_name AS file_name_13, a0_.author_id AS author_id_14, a0_.image_id AS image_id_15 FROM article a0_ INNER JOIN articles_categories a2_ ON a0_.id = a2_.article_id INNER JOIN category c1_ ON c1_.id = a2_.category_id WHERE c1_.slug IN (?) ORDER BY a0_.created_at DESC LIMIT 1
Parameters:
[
  "photo"
]
32 5.98 ms
SELECT a0_.id AS id_0, a0_.custom_id AS custom_id_1, a0_.title AS title_2, a0_.teaser AS teaser_3, a0_.slider_title AS slider_title_4, a0_.slug AS slug_5, a0_.slider_position AS slider_position_6, a0_.summary AS summary_7, a0_.body AS body_8, a0_.created_at AS created_at_9, a0_.event_date AS event_date_10, a0_.updated_at AS updated_at_11, a0_.published AS published_12, a0_.file_name AS file_name_13, a0_.author_id AS author_id_14, a0_.image_id AS image_id_15 FROM article a0_ INNER JOIN articles_categories a2_ ON a0_.id = a2_.article_id INNER JOIN category c1_ ON c1_.id = a2_.category_id WHERE c1_.slug IN (?) ORDER BY a0_.created_at DESC LIMIT 1
Parameters:
[
  "climber-parts"
]
33 4.69 ms
SELECT a0_.id AS id_0, a0_.custom_id AS custom_id_1, a0_.title AS title_2, a0_.teaser AS teaser_3, a0_.slider_title AS slider_title_4, a0_.slug AS slug_5, a0_.slider_position AS slider_position_6, a0_.summary AS summary_7, a0_.body AS body_8, a0_.created_at AS created_at_9, a0_.event_date AS event_date_10, a0_.updated_at AS updated_at_11, a0_.published AS published_12, a0_.file_name AS file_name_13, a0_.author_id AS author_id_14, a0_.image_id AS image_id_15 FROM article a0_ INNER JOIN articles_categories a2_ ON a0_.id = a2_.article_id INNER JOIN category c1_ ON c1_.id = a2_.category_id WHERE c1_.slug IN (?) ORDER BY a0_.created_at DESC LIMIT 1
Parameters:
[
  "dance-part"
]
34 1.06 ms
SELECT a0_.id AS id_0, a0_.custom_id AS custom_id_1, a0_.title AS title_2, a0_.teaser AS teaser_3, a0_.slider_title AS slider_title_4, a0_.slug AS slug_5, a0_.slider_position AS slider_position_6, a0_.summary AS summary_7, a0_.body AS body_8, a0_.created_at AS created_at_9, a0_.event_date AS event_date_10, a0_.updated_at AS updated_at_11, a0_.published AS published_12, a0_.file_name AS file_name_13, a0_.author_id AS author_id_14, a0_.image_id AS image_id_15 FROM article a0_ INNER JOIN articles_categories a2_ ON a0_.id = a2_.article_id INNER JOIN category c1_ ON c1_.id = a2_.category_id WHERE c1_.slug IN (?) ORDER BY a0_.created_at DESC LIMIT 1
Parameters:
[
  "music-parts"
]
35 0.65 ms
SELECT a0_.id AS id_0, a0_.custom_id AS custom_id_1, a0_.title AS title_2, a0_.teaser AS teaser_3, a0_.slider_title AS slider_title_4, a0_.slug AS slug_5, a0_.slider_position AS slider_position_6, a0_.summary AS summary_7, a0_.body AS body_8, a0_.created_at AS created_at_9, a0_.event_date AS event_date_10, a0_.updated_at AS updated_at_11, a0_.published AS published_12, a0_.file_name AS file_name_13, a0_.author_id AS author_id_14, a0_.image_id AS image_id_15 FROM article a0_ INNER JOIN articles_categories a2_ ON a0_.id = a2_.article_id INNER JOIN category c1_ ON c1_.id = a2_.category_id WHERE c1_.slug IN (?) ORDER BY a0_.created_at DESC LIMIT 1
Parameters:
[
  "dimiourgiko-ergastiri"
]
36 3.79 ms
SELECT a0_.id AS id_0, a0_.custom_id AS custom_id_1, a0_.title AS title_2, a0_.teaser AS teaser_3, a0_.slider_title AS slider_title_4, a0_.slug AS slug_5, a0_.slider_position AS slider_position_6, a0_.summary AS summary_7, a0_.body AS body_8, a0_.created_at AS created_at_9, a0_.event_date AS event_date_10, a0_.updated_at AS updated_at_11, a0_.published AS published_12, a0_.file_name AS file_name_13, a0_.author_id AS author_id_14, a0_.image_id AS image_id_15 FROM article a0_ INNER JOIN articles_categories a2_ ON a0_.id = a2_.article_id INNER JOIN category c1_ ON c1_.id = a2_.category_id WHERE c1_.slug IN (?) ORDER BY a0_.created_at DESC LIMIT 3
Parameters:
[
  "latest-news"
]
37 0.62 ms
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.created_at AS created_at_3, a0_.file_name AS file_name_4, a1_.path AS path_5, a2_.full_name AS full_name_6, a2_.slug AS slug_7, a2_.title AS title_8, c3_.slug AS slug_9, c3_.name AS name_10 FROM article a0_ INNER JOIN author a2_ ON a0_.author_id = a2_.id INNER JOIN articles_categories a4_ ON a0_.id = a4_.article_id INNER JOIN category c3_ ON c3_.id = a4_.category_id LEFT JOIN app_file a1_ ON a0_.image_id = a1_.id WHERE c3_.slug IN (?, ?, ?, ?) AND a0_.created_at IN (SELECT MAX(a5_.created_at) AS sclr_11 FROM article a5_ INNER JOIN articles_categories a7_ ON a5_.id = a7_.article_id INNER JOIN category c6_ ON c6_.id = a7_.category_id WHERE c6_.id = c3_.id) LIMIT 4
Parameters:
[
  "rocktimegroups"
  "tobearock"
  "goldenyears"
  "greekbands"
]
38 1.11 ms
SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.title AS title_3, t0.teaser AS teaser_4, t0.slider_title AS slider_title_5, t0.slug AS slug_6, t0.slider_position AS slider_position_7, t0.summary AS summary_8, t0.body AS body_9, t0.created_at AS created_at_10, t0.event_date AS event_date_11, t0.updated_at AS updated_at_12, t0.published AS published_13, t0.file_name AS file_name_14, t0.author_id AS author_id_15, t0.image_id AS image_id_16 FROM article t0 WHERE t0.custom_id = ? LIMIT 1
Parameters:
[
  "1621880961"
]
39 0.93 ms
SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.title AS title_3, t0.teaser AS teaser_4, t0.slider_title AS slider_title_5, t0.slug AS slug_6, t0.slider_position AS slider_position_7, t0.summary AS summary_8, t0.body AS body_9, t0.created_at AS created_at_10, t0.event_date AS event_date_11, t0.updated_at AS updated_at_12, t0.published AS published_13, t0.file_name AS file_name_14, t0.author_id AS author_id_15, t0.image_id AS image_id_16 FROM article t0 ORDER BY t0.created_at DESC LIMIT 10
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection
old doctrine.dbal.old_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.