https://astralpool.oneam.dev/blog/articolo/biopiscina-o-piscina-naturale-quali-sono-le-differenze

Query Metrics

16 Database Queries
7 Different statements
77.80 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 71.59 ms
SELECT t0.id AS id_1, t0.visible AS visible_2, t0.featured AS featured_3, t0.date AS date_4, t0.title AS title_5, t0.content AS content_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.cover_file_name AS cover_file_name_9, t0.cover_mime_type AS cover_mime_type_10, t0.cover_path AS cover_path_11, t0.cover_size AS cover_size_12, t0.document_file_name AS document_file_name_13, t0.document_mime_type AS document_mime_type_14, t0.document_path AS document_path_15, t0.document_size AS document_size_16, t0.slug AS slug_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19 FROM article t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "biopiscina-o-piscina-naturale-quali-sono-le-differenze"
]
2 0.47 ms
SELECT a0_.id AS id_0, a0_.visible AS visible_1, a0_.featured AS featured_2, a0_.date AS date_3, a0_.title AS title_4, a0_.content AS content_5, a0_.meta_title AS meta_title_6, a0_.meta_description AS meta_description_7, a0_.cover_file_name AS cover_file_name_8, a0_.cover_mime_type AS cover_mime_type_9, a0_.cover_path AS cover_path_10, a0_.cover_size AS cover_size_11, a0_.document_file_name AS document_file_name_12, a0_.document_mime_type AS document_mime_type_13, a0_.document_path AS document_path_14, a0_.document_size AS document_size_15, a0_.slug AS slug_16, a0_.created_at AS created_at_17, a0_.updated_at AS updated_at_18 FROM article a0_ WHERE a0_.id <> ? ORDER BY a0_.date DESC LIMIT 4
Parameters:
[
  149
]
3 0.53 ms
SELECT a0_.id AS id_0, a0_.visible AS visible_1, a0_.featured AS featured_2, a0_.date AS date_3, a0_.title AS title_4, a0_.content AS content_5, a0_.meta_title AS meta_title_6, a0_.meta_description AS meta_description_7, a0_.cover_file_name AS cover_file_name_8, a0_.cover_mime_type AS cover_mime_type_9, a0_.cover_path AS cover_path_10, a0_.cover_size AS cover_size_11, a0_.document_file_name AS document_file_name_12, a0_.document_mime_type AS document_mime_type_13, a0_.document_path AS document_path_14, a0_.document_size AS document_size_15, a0_.slug AS slug_16, a0_.created_at AS created_at_17, a0_.updated_at AS updated_at_18 FROM article a0_ WHERE a0_.visible = 1 AND a0_.id <> ? ORDER BY a0_.date DESC LIMIT 3
Parameters:
[
  149
]
4 0.30 ms
SELECT a0_.id AS id_0, a0_.visible AS visible_1, a0_.featured AS featured_2, a0_.date AS date_3, a0_.title AS title_4, a0_.content AS content_5, a0_.meta_title AS meta_title_6, a0_.meta_description AS meta_description_7, a0_.cover_file_name AS cover_file_name_8, a0_.cover_mime_type AS cover_mime_type_9, a0_.cover_path AS cover_path_10, a0_.cover_size AS cover_size_11, a0_.document_file_name AS document_file_name_12, a0_.document_mime_type AS document_mime_type_13, a0_.document_path AS document_path_14, a0_.document_size AS document_size_15, a0_.slug AS slug_16, a0_.created_at AS created_at_17, a0_.updated_at AS updated_at_18 FROM article a0_ WHERE a0_.visible = 1 AND a0_.id <> ? ORDER BY a0_.date DESC LIMIT 3
Parameters:
[
  149
]
5 0.40 ms
SELECT a0_.id AS id_0, a0_.visible AS visible_1, a0_.featured AS featured_2, a0_.date AS date_3, a0_.title AS title_4, a0_.content AS content_5, a0_.meta_title AS meta_title_6, a0_.meta_description AS meta_description_7, a0_.cover_file_name AS cover_file_name_8, a0_.cover_mime_type AS cover_mime_type_9, a0_.cover_path AS cover_path_10, a0_.cover_size AS cover_size_11, a0_.document_file_name AS document_file_name_12, a0_.document_mime_type AS document_mime_type_13, a0_.document_path AS document_path_14, a0_.document_size AS document_size_15, a0_.slug AS slug_16, a0_.created_at AS created_at_17, a0_.updated_at AS updated_at_18 FROM article a0_ WHERE a0_.visible = 1 AND a0_.id <> ? ORDER BY a0_.date DESC LIMIT 3
Parameters:
[
  149
]
6 0.33 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.call_to_action AS call_to_action_3, t0.link AS link_4, t0.type AS type_5, t0.sorting AS sorting_6, t0.headquarter_type AS headquarter_type_7, t0.blank AS blank_8 FROM footer_entry t0 WHERE t0.position = ? ORDER BY t0.sorting ASC
Parameters:
[
  "row_1"
]
7 0.26 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.call_to_action AS call_to_action_3, t0.link AS link_4, t0.type AS type_5, t0.sorting AS sorting_6, t0.headquarter_type AS headquarter_type_7, t0.blank AS blank_8 FROM footer_entry t0 WHERE t0.position = ? ORDER BY t0.sorting ASC
Parameters:
[
  "row_2"
]
8 0.21 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.call_to_action AS call_to_action_3, t0.link AS link_4, t0.type AS type_5, t0.sorting AS sorting_6, t0.headquarter_type AS headquarter_type_7, t0.blank AS blank_8 FROM footer_entry t0 WHERE t0.position = ? ORDER BY t0.sorting ASC
Parameters:
[
  "row_3"
]
9 0.19 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.call_to_action AS call_to_action_3, t0.link AS link_4, t0.type AS type_5, t0.sorting AS sorting_6, t0.headquarter_type AS headquarter_type_7, t0.blank AS blank_8 FROM footer_entry t0 WHERE t0.position = ? ORDER BY t0.sorting ASC
Parameters:
[
  "row_4"
]
10 0.22 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.call_to_action AS call_to_action_3, t0.link AS link_4, t0.type AS type_5, t0.sorting AS sorting_6, t0.headquarter_type AS headquarter_type_7, t0.blank AS blank_8 FROM footer_entry t0 WHERE t0.position = ? ORDER BY t0.sorting ASC
Parameters:
[
  "row_5"
]
11 0.25 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.call_to_action AS call_to_action_3, t0.link AS link_4, t0.type AS type_5, t0.sorting AS sorting_6, t0.headquarter_type AS headquarter_type_7, t0.blank AS blank_8 FROM footer_entry t0 WHERE t0.position = ? ORDER BY t0.sorting ASC
Parameters:
[
  "footer"
]
12 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.visible AS visible_4, t0.introduction AS introduction_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.cover_file_name AS cover_file_name_8, t0.cover_mime_type AS cover_mime_type_9, t0.cover_path AS cover_path_10, t0.cover_size AS cover_size_11, t0.menu_cover_file_name AS menu_cover_file_name_12, t0.menu_cover_mime_type AS menu_cover_mime_type_13, t0.menu_cover_path AS menu_cover_path_14, t0.menu_cover_size AS menu_cover_size_15, t0.slug AS slug_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18 FROM product t0 WHERE t0.visible = ?
Parameters:
[
  1
]
13 0.49 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.introduction AS introduction_4, t0.visible AS visible_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.cover_file_name AS cover_file_name_8, t0.cover_mime_type AS cover_mime_type_9, t0.cover_path AS cover_path_10, t0.cover_size AS cover_size_11, t0.background_file_name AS background_file_name_12, t0.background_mime_type AS background_mime_type_13, t0.background_path AS background_path_14, t0.background_size AS background_size_15, t0.slug AS slug_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18 FROM component t0 WHERE t0.visible = ?
Parameters:
[
  1
]
14 0.40 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.visible AS visible_4, t0.introduction AS introduction_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.cover_file_name AS cover_file_name_8, t0.cover_mime_type AS cover_mime_type_9, t0.cover_path AS cover_path_10, t0.cover_size AS cover_size_11, t0.menu_cover_file_name AS menu_cover_file_name_12, t0.menu_cover_mime_type AS menu_cover_mime_type_13, t0.menu_cover_path AS menu_cover_path_14, t0.menu_cover_size AS menu_cover_size_15, t0.slug AS slug_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18 FROM product t0 WHERE t0.visible = ?
Parameters:
[
  1
]
15 0.42 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.introduction AS introduction_4, t0.visible AS visible_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.cover_file_name AS cover_file_name_8, t0.cover_mime_type AS cover_mime_type_9, t0.cover_path AS cover_path_10, t0.cover_size AS cover_size_11, t0.background_file_name AS background_file_name_12, t0.background_mime_type AS background_mime_type_13, t0.background_path AS background_path_14, t0.background_size AS background_size_15, t0.slug AS slug_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18 FROM component t0 WHERE t0.visible = ?
Parameters:
[
  1
]
16 1.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.cover_file_name AS cover_file_name_3, t0.cover_mime_type AS cover_mime_type_4, t0.cover_path AS cover_path_5, t0.cover_size AS cover_size_6, t0.slug AS slug_7 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = ?
Parameters:
[
  149
]

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\Embeddable\File\CoverFile No errors.
App\Entity\Embeddable\File\DocumentFile No errors.
App\Entity\Article No errors.
App\Entity\Tag No errors.
App\Entity\Category No errors.
App\Entity\FooterEntry No errors.
App\Entity\Product No errors.
App\Entity\Page No errors.
App\Entity\Embeddable\File\RealizationImageFile No errors.
App\Entity\Product\Realization No errors.
App\Entity\Product\ProductCallToAction No errors.
App\Entity\Product\Section No errors.
App\Entity\Component No errors.
App\Entity\Component\ComponentCallToAction No errors.