Redirect 302 redirect from GET @n/a (7b7042)

GET https://www.bricklocator.com/nl-NL/

Query Metrics

53 Database Queries
12 Different statements
6.70 ms Query time
0 Invalid entities
210 Managed entities

Queries

Group similar statements

# Time Info
1 0.18 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:
[
  "nl-NL"
]
2 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
Parameters:
[]
3 0.14 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:
[
  "nl-NL"
]
4 1.11 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:
[
  2
  2
]
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.11 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.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:
[
  2
]
8 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:
[
  2
]
9 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:
[
  3
]
10 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:
[
  3
]
11 0.07 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.06 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.07 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.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:
[
  5
]
15 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:
[
  6
]
16 0.06 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.07 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.06 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.07 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.06 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.07 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.06 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.39 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:
[
  2
]
24 0.19 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:
[
  "nl-NL"
]
25 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:
[
  2
]
26 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:
[
  "nl-NL"
]
27 0.12 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:
[
  2
]
28 0.09 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:
[
  "nl-NL"
]
30 0.10 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.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:
[
  1
  2
]
32 0.10 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
  2
]
33 0.09 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
  2
]
34 0.09 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
  2
]
35 0.20 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.19 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.14 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.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:
[
  3
]
40 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:
[
  3
]
41 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:
[
  4
]
42 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:
[
  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.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:
[
  7
]
48 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:
[
  7
]
49 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:
[
  8
]
50 0.09 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.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:
[
  9
]
52 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:
[
  9
]
53 0.10 ms
SELECT t0.id AS id_1, t0.internal_name AS internal_name_2, t0.published_at AS published_at_3, t0.featured_image AS featured_image_4, t0.product_ids AS product_ids_5, t0.product_id AS product_id_6 FROM blog_article t0 WHERE t0.id = ?
Parameters:
[
  1
]

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\Thema 4
App\Entity\ThemaTranslation 4
App\Entity\ContentPage 4
App\Entity\ContentPageTranslation 4
App\Entity\BlogArticleTranslation 1
App\Entity\BlogArticle 1
App\Entity\Retailer 1