GET https://www.bricklocator.com/it-IT/

Query Metrics

52 Database Queries
11 Different statements
7.04 ms Query time
0 Invalid entities
200 Managed entities

Queries

Group similar statements

# Time Info
1 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.locale AS locale_4, t0.sorting AS sorting_5 FROM language t0 WHERE t0.locale = ? LIMIT 1
Parameters:
[
  "it-IT"
]
2 0.11 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.locale AS locale_4, t0.sorting AS sorting_5 FROM language t0
Parameters:
[]
3 0.11 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.locale AS locale_4, t0.sorting AS sorting_5 FROM language t0 WHERE t0.locale = ? LIMIT 1
Parameters:
[
  "it-IT"
]
4 0.86 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.description_short AS description_short_4, p0_.title AS title_5, p1_.id AS id_6, p1_.name AS name_7, p1_.description AS description_8, p1_.ean AS ean_9, p1_.published_at AS published_at_10, p1_.active AS active_11, p1_.mpn AS mpn_12, p1_.bol_product_id AS bol_product_id_13, p1_.total_parts AS total_parts_14, p1_.total_minifigs AS total_minifigs_15, p1_.instructions_download_url AS instructions_download_url_16, p1_.bol_url AS bol_url_17, p1_.seo_text_1 AS seo_text_1_18, p1_.seo_text_2 AS seo_text_2_19, p1_.final_seo_description_short AS final_seo_description_short_20, p1_.final_seo_title AS final_seo_title_21, p1_.final_seo_description AS final_seo_description_22, p1_.ai_processed AS ai_processed_23, p1_.ai_translated AS ai_translated_24, p1_.slug AS slug_25, p1_.lego_images_downloaded AS lego_images_downloaded_26, p1_.lego_detail_url AS lego_detail_url_27, p1_.lego_bltnummer AS lego_bltnummer_28, t2_.id AS id_29, t2_.name AS name_30, t2_.description AS description_31, t2_.slug AS slug_32, t2_.position AS position_33, t2_.image AS image_34, t3_.id AS id_35, t3_.slug AS slug_36, t3_.name AS name_37, t3_.description AS description_38, p0_.language_id AS language_id_39, p0_.product_id AS product_id_40, p1_.thema_id AS thema_id_41, t3_.thema_id AS thema_id_42, t3_.language_id AS language_id_43 FROM product_translation p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id INNER JOIN thema t2_ ON p1_.thema_id = t2_.id INNER JOIN thema_translation t3_ ON t2_.id = t3_.thema_id AND (t3_.language_id = ?) WHERE p0_.language_id = ? ORDER BY p0_.id ASC LIMIT 9
Parameters:
[
  5
  5
]
5 0.13 ms
SELECT t0.id AS id_1, t0.package_width AS package_width_2, t0.package_length AS package_length_3, t0.package_height AS package_height_4, t0.product_width AS product_width_5, t0.product_length AS product_length_6, t0.product_height AS product_height_7, t0.weight AS weight_8, t0.product_id AS product_id_9 FROM product_dimensions t0 WHERE t0.product_id = ?
Parameters:
[
  1
]
6 0.10 ms
SELECT t0.id AS id_1, t0.year AS year_2, t0.month AS month_3, t0.product_id AS product_id_4 FROM product_release_data t0 WHERE t0.product_id = ?
Parameters:
[
  1
]
7 0.13 ms
SELECT t0.id AS id_1, t0.package_width AS package_width_2, t0.package_length AS package_length_3, t0.package_height AS package_height_4, t0.product_width AS product_width_5, t0.product_length AS product_length_6, t0.product_height AS product_height_7, t0.weight AS weight_8, t0.product_id AS product_id_9 FROM product_dimensions t0 WHERE t0.product_id = ?
Parameters:
[
  2
]
8 0.10 ms
SELECT t0.id AS id_1, t0.year AS year_2, t0.month AS month_3, t0.product_id AS product_id_4 FROM product_release_data t0 WHERE t0.product_id = ?
Parameters:
[
  2
]
9 0.09 ms
SELECT t0.id AS id_1, t0.package_width AS package_width_2, t0.package_length AS package_length_3, t0.package_height AS package_height_4, t0.product_width AS product_width_5, t0.product_length AS product_length_6, t0.product_height AS product_height_7, t0.weight AS weight_8, t0.product_id AS product_id_9 FROM product_dimensions t0 WHERE t0.product_id = ?
Parameters:
[
  3
]
10 0.08 ms
SELECT t0.id AS id_1, t0.year AS year_2, t0.month AS month_3, t0.product_id AS product_id_4 FROM product_release_data t0 WHERE t0.product_id = ?
Parameters:
[
  3
]
11 0.08 ms
SELECT t0.id AS id_1, t0.package_width AS package_width_2, t0.package_length AS package_length_3, t0.package_height AS package_height_4, t0.product_width AS product_width_5, t0.product_length AS product_length_6, t0.product_height AS product_height_7, t0.weight AS weight_8, t0.product_id AS product_id_9 FROM product_dimensions t0 WHERE t0.product_id = ?
Parameters:
[
  4
]
12 0.08 ms
SELECT t0.id AS id_1, t0.year AS year_2, t0.month AS month_3, t0.product_id AS product_id_4 FROM product_release_data t0 WHERE t0.product_id = ?
Parameters:
[
  4
]
13 0.09 ms
SELECT t0.id AS id_1, t0.package_width AS package_width_2, t0.package_length AS package_length_3, t0.package_height AS package_height_4, t0.product_width AS product_width_5, t0.product_length AS product_length_6, t0.product_height AS product_height_7, t0.weight AS weight_8, t0.product_id AS product_id_9 FROM product_dimensions t0 WHERE t0.product_id = ?
Parameters:
[
  5
]
14 0.10 ms
SELECT t0.id AS id_1, t0.year AS year_2, t0.month AS month_3, t0.product_id AS product_id_4 FROM product_release_data t0 WHERE t0.product_id = ?
Parameters:
[
  5
]
15 0.09 ms
SELECT t0.id AS id_1, t0.package_width AS package_width_2, t0.package_length AS package_length_3, t0.package_height AS package_height_4, t0.product_width AS product_width_5, t0.product_length AS product_length_6, t0.product_height AS product_height_7, t0.weight AS weight_8, t0.product_id AS product_id_9 FROM product_dimensions t0 WHERE t0.product_id = ?
Parameters:
[
  6
]
16 0.08 ms
SELECT t0.id AS id_1, t0.year AS year_2, t0.month AS month_3, t0.product_id AS product_id_4 FROM product_release_data t0 WHERE t0.product_id = ?
Parameters:
[
  6
]
17 0.09 ms
SELECT t0.id AS id_1, t0.package_width AS package_width_2, t0.package_length AS package_length_3, t0.package_height AS package_height_4, t0.product_width AS product_width_5, t0.product_length AS product_length_6, t0.product_height AS product_height_7, t0.weight AS weight_8, t0.product_id AS product_id_9 FROM product_dimensions t0 WHERE t0.product_id = ?
Parameters:
[
  7
]
18 0.09 ms
SELECT t0.id AS id_1, t0.year AS year_2, t0.month AS month_3, t0.product_id AS product_id_4 FROM product_release_data t0 WHERE t0.product_id = ?
Parameters:
[
  7
]
19 0.09 ms
SELECT t0.id AS id_1, t0.package_width AS package_width_2, t0.package_length AS package_length_3, t0.package_height AS package_height_4, t0.product_width AS product_width_5, t0.product_length AS product_length_6, t0.product_height AS product_height_7, t0.weight AS weight_8, t0.product_id AS product_id_9 FROM product_dimensions t0 WHERE t0.product_id = ?
Parameters:
[
  8
]
20 0.07 ms
SELECT t0.id AS id_1, t0.year AS year_2, t0.month AS month_3, t0.product_id AS product_id_4 FROM product_release_data t0 WHERE t0.product_id = ?
Parameters:
[
  8
]
21 0.08 ms
SELECT t0.id AS id_1, t0.package_width AS package_width_2, t0.package_length AS package_length_3, t0.package_height AS package_height_4, t0.product_width AS product_width_5, t0.product_length AS product_length_6, t0.product_height AS product_height_7, t0.weight AS weight_8, t0.product_id AS product_id_9 FROM product_dimensions t0 WHERE t0.product_id = ?
Parameters:
[
  9
]
22 0.08 ms
SELECT t0.id AS id_1, t0.year AS year_2, t0.month AS month_3, t0.product_id AS product_id_4 FROM product_release_data t0 WHERE t0.product_id = ?
Parameters:
[
  9
]
23 0.38 ms
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.slug AS slug_2, b0_.meta_description AS meta_description_3, b0_.content AS content_4, b0_.short_description AS short_description_5, b0_.language_id AS language_id_6, b0_.article_id AS article_id_7 FROM blog_article_translation b0_ INNER JOIN blog_article b1_ ON b0_.article_id = b1_.id WHERE b0_.language_id = ? ORDER BY b1_.published_at DESC LIMIT 3
Parameters:
[
  5
]
24 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.locale AS locale_4, t0.sorting AS sorting_5 FROM language t0 WHERE t0.locale = ? LIMIT 1
Parameters:
[
  "it-IT"
]
25 0.21 ms
SELECT t0_.id AS id_0, t0_.slug AS slug_1, t0_.name AS name_2, t0_.description AS description_3, t0_.thema_id AS thema_id_4, t0_.language_id AS language_id_5 FROM thema_translation t0_ WHERE t0_.language_id = ? AND t0_.slug IS NOT NULL ORDER BY t0_.name ASC
Parameters:
[
  5
]
26 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.locale AS locale_4, t0.sorting AS sorting_5 FROM language t0 WHERE t0.locale = ? LIMIT 1
Parameters:
[
  "it-IT"
]
27 0.16 ms
SELECT t0_.id AS id_0, t0_.slug AS slug_1, t0_.name AS name_2, t0_.description AS description_3, t0_.thema_id AS thema_id_4, t0_.language_id AS language_id_5 FROM thema_translation t0_ WHERE t0_.language_id = ? AND t0_.slug IS NOT NULL ORDER BY t0_.name ASC
Parameters:
[
  5
]
28 0.11 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.locale AS locale_4, t0.sorting AS sorting_5 FROM language t0
Parameters:
[]
29 0.10 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.locale AS locale_4, t0.sorting AS sorting_5 FROM language t0 WHERE t0.locale = ? LIMIT 1
Parameters:
[
  "it-IT"
]
30 0.14 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM content_page t0 WHERE t0.name IN (?, ?, ?, ?)
Parameters:
[
  "algemene voorwaarden"
  "privacy"
  "contact"
  "overons"
]
31 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.text AS text_4, t0.language_id AS language_id_5, t0.content_page_id AS content_page_id_6 FROM content_page_translation t0 WHERE t0.content_page_id = ? AND t0.language_id = ? LIMIT 1
Parameters:
[
  1
  5
]
32 0.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.text AS text_4, t0.language_id AS language_id_5, t0.content_page_id AS content_page_id_6 FROM content_page_translation t0 WHERE t0.content_page_id = ? AND t0.language_id = ? LIMIT 1
Parameters:
[
  2
  5
]
33 0.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.text AS text_4, t0.language_id AS language_id_5, t0.content_page_id AS content_page_id_6 FROM content_page_translation t0 WHERE t0.content_page_id = ? AND t0.language_id = ? LIMIT 1
Parameters:
[
  3
  5
]
34 0.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.text AS text_4, t0.language_id AS language_id_5, t0.content_page_id AS content_page_id_6 FROM content_page_translation t0 WHERE t0.content_page_id = ? AND t0.language_id = ? LIMIT 1
Parameters:
[
  4
  5
]
35 0.18 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.discount_price AS discount_price_3, t0.valid_until AS valid_until_4, t0.is_visible AS is_visible_5, t0.product_id AS product_id_6, t0.retailer_id AS retailer_id_7 FROM product_price t0 WHERE t0.product_id = ?
Parameters:
[
  1
]
36 0.12 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.file AS file_3, t0.alt_text AS alt_text_4, t0.title AS title_5, t0.priority AS priority_6, t0.updated_at AS updated_at_7, t0.lego_afbeelding_id AS lego_afbeelding_id_8, t0.product_id AS product_id_9 FROM product_images t0 WHERE t0.product_id = ?
Parameters:
[
  1
]
37 0.11 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.discount_price AS discount_price_3, t0.valid_until AS valid_until_4, t0.is_visible AS is_visible_5, t0.product_id AS product_id_6, t0.retailer_id AS retailer_id_7 FROM product_price t0 WHERE t0.product_id = ?
Parameters:
[
  2
]
38 0.15 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.file AS file_3, t0.alt_text AS alt_text_4, t0.title AS title_5, t0.priority AS priority_6, t0.updated_at AS updated_at_7, t0.lego_afbeelding_id AS lego_afbeelding_id_8, t0.product_id AS product_id_9 FROM product_images t0 WHERE t0.product_id = ?
Parameters:
[
  2
]
39 0.13 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.discount_price AS discount_price_3, t0.valid_until AS valid_until_4, t0.is_visible AS is_visible_5, t0.product_id AS product_id_6, t0.retailer_id AS retailer_id_7 FROM product_price t0 WHERE t0.product_id = ?
Parameters:
[
  3
]
40 0.16 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.file AS file_3, t0.alt_text AS alt_text_4, t0.title AS title_5, t0.priority AS priority_6, t0.updated_at AS updated_at_7, t0.lego_afbeelding_id AS lego_afbeelding_id_8, t0.product_id AS product_id_9 FROM product_images t0 WHERE t0.product_id = ?
Parameters:
[
  3
]
41 0.10 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.discount_price AS discount_price_3, t0.valid_until AS valid_until_4, t0.is_visible AS is_visible_5, t0.product_id AS product_id_6, t0.retailer_id AS retailer_id_7 FROM product_price t0 WHERE t0.product_id = ?
Parameters:
[
  4
]
42 0.11 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.file AS file_3, t0.alt_text AS alt_text_4, t0.title AS title_5, t0.priority AS priority_6, t0.updated_at AS updated_at_7, t0.lego_afbeelding_id AS lego_afbeelding_id_8, t0.product_id AS product_id_9 FROM product_images t0 WHERE t0.product_id = ?
Parameters:
[
  4
]
43 0.10 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.discount_price AS discount_price_3, t0.valid_until AS valid_until_4, t0.is_visible AS is_visible_5, t0.product_id AS product_id_6, t0.retailer_id AS retailer_id_7 FROM product_price t0 WHERE t0.product_id = ?
Parameters:
[
  5
]
44 0.10 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.file AS file_3, t0.alt_text AS alt_text_4, t0.title AS title_5, t0.priority AS priority_6, t0.updated_at AS updated_at_7, t0.lego_afbeelding_id AS lego_afbeelding_id_8, t0.product_id AS product_id_9 FROM product_images t0 WHERE t0.product_id = ?
Parameters:
[
  5
]
45 0.09 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.discount_price AS discount_price_3, t0.valid_until AS valid_until_4, t0.is_visible AS is_visible_5, t0.product_id AS product_id_6, t0.retailer_id AS retailer_id_7 FROM product_price t0 WHERE t0.product_id = ?
Parameters:
[
  6
]
46 0.10 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.file AS file_3, t0.alt_text AS alt_text_4, t0.title AS title_5, t0.priority AS priority_6, t0.updated_at AS updated_at_7, t0.lego_afbeelding_id AS lego_afbeelding_id_8, t0.product_id AS product_id_9 FROM product_images t0 WHERE t0.product_id = ?
Parameters:
[
  6
]
47 0.11 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.discount_price AS discount_price_3, t0.valid_until AS valid_until_4, t0.is_visible AS is_visible_5, t0.product_id AS product_id_6, t0.retailer_id AS retailer_id_7 FROM product_price t0 WHERE t0.product_id = ?
Parameters:
[
  7
]
48 0.11 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.file AS file_3, t0.alt_text AS alt_text_4, t0.title AS title_5, t0.priority AS priority_6, t0.updated_at AS updated_at_7, t0.lego_afbeelding_id AS lego_afbeelding_id_8, t0.product_id AS product_id_9 FROM product_images t0 WHERE t0.product_id = ?
Parameters:
[
  7
]
49 0.10 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.discount_price AS discount_price_3, t0.valid_until AS valid_until_4, t0.is_visible AS is_visible_5, t0.product_id AS product_id_6, t0.retailer_id AS retailer_id_7 FROM product_price t0 WHERE t0.product_id = ?
Parameters:
[
  8
]
50 0.11 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.file AS file_3, t0.alt_text AS alt_text_4, t0.title AS title_5, t0.priority AS priority_6, t0.updated_at AS updated_at_7, t0.lego_afbeelding_id AS lego_afbeelding_id_8, t0.product_id AS product_id_9 FROM product_images t0 WHERE t0.product_id = ?
Parameters:
[
  8
]
51 0.09 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.discount_price AS discount_price_3, t0.valid_until AS valid_until_4, t0.is_visible AS is_visible_5, t0.product_id AS product_id_6, t0.retailer_id AS retailer_id_7 FROM product_price t0 WHERE t0.product_id = ?
Parameters:
[
  9
]
52 0.13 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.file AS file_3, t0.alt_text AS alt_text_4, t0.title AS title_5, t0.priority AS priority_6, t0.updated_at AS updated_at_7, t0.lego_afbeelding_id AS lego_afbeelding_id_8, t0.product_id AS product_id_9 FROM product_images t0 WHERE t0.product_id = ?
Parameters:
[
  9
]

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\ProductImages 138
App\Entity\ProductTranslation 9
App\Entity\Product 9
App\Entity\ProductDimensions 9
App\Entity\ProductReleaseData 9
App\Entity\ProductPrice 9
App\Entity\Language 8
App\Entity\ContentPage 4
App\Entity\Thema 2
App\Entity\ThemaTranslation 2
App\Entity\Retailer 1