Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.created_at AS created_at_3,
  t0.modified_at AS modified_at_4,
  t0.published_at AS published_at_5,
  t0.seo_title AS seo_title_6,
  t0.seo_description AS seo_description_7,
  t0.short_description AS short_description_8,
  t0.is_published AS is_published_9,
  t0.slug AS slug_10,
  t0.path AS path_11,
  t0.position AS position_12,
  t0.redirect AS redirect_13,
  t0.is_deleted AS is_deleted_14,
  t0.robots AS robots_15,
  t0.redirect_code AS redirect_code_16,
  t0.is_home AS is_home_17,
  t0.settings AS settings_18,
  t0.image_name AS image_name_19,
  t0.updated_at AS updated_at_20,
  t0.parent_id AS parent_id_21,
  t0.owner_id AS owner_id_22,
  t23.id AS id_24,
  t23.title AS title_25,
  t23.title_short AS title_short_26,
  t23.slug AS slug_27,
  t23.description AS description_28,
  t23.price AS price_29,
  t23.is_calculated AS is_calculated_30,
  t23.min_size_x AS min_size_x_31,
  t23.min_size_y AS min_size_y_32,
  t23.max_size_x AS max_size_x_33,
  t23.max_size_y AS max_size_y_34,
  t23.formula AS formula_35,
  t23.stock AS stock_36,
  t23.sku AS sku_37,
  t23.processing_fee AS processing_fee_38,
  t23.position AS position_39,
  t23.is_published AS is_published_40,
  t23.is_deleted AS is_deleted_41,
  t23.image_name AS image_name_42,
  t23.updated_at AS updated_at_43,
  t23.shipping_info AS shipping_info_44,
  t23.shipping_duration AS shipping_duration_45,
  t23.has_individual_sizes AS has_individual_sizes_46,
  t23.short_description AS short_description_47,
  t23.editor_override_type AS editor_override_type_48,
  t23.editor_override_config AS editor_override_config_49,
  t23.owner_id AS owner_id_50,
  t23.page_id AS page_id_51
FROM
  page t0
  LEFT JOIN shop_product t23 ON t23.page_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.created_at AS created_at_3, t0.modified_at AS modified_at_4, t0.published_at AS published_at_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.short_description AS short_description_8, t0.is_published AS is_published_9, t0.slug AS slug_10, t0.path AS path_11, t0.position AS position_12, t0.redirect AS redirect_13, t0.is_deleted AS is_deleted_14, t0.robots AS robots_15, t0.redirect_code AS redirect_code_16, t0.is_home AS is_home_17, t0.settings AS settings_18, t0.image_name AS image_name_19, t0.updated_at AS updated_at_20, t0.parent_id AS parent_id_21, t0.owner_id AS owner_id_22, t23.id AS id_24, t23.title AS title_25, t23.title_short AS title_short_26, t23.slug AS slug_27, t23.description AS description_28, t23.price AS price_29, t23.is_calculated AS is_calculated_30, t23.min_size_x AS min_size_x_31, t23.min_size_y AS min_size_y_32, t23.max_size_x AS max_size_x_33, t23.max_size_y AS max_size_y_34, t23.formula AS formula_35, t23.stock AS stock_36, t23.sku AS sku_37, t23.processing_fee AS processing_fee_38, t23.position AS position_39, t23.is_published AS is_published_40, t23.is_deleted AS is_deleted_41, t23.image_name AS image_name_42, t23.updated_at AS updated_at_43, t23.shipping_info AS shipping_info_44, t23.shipping_duration AS shipping_duration_45, t23.has_individual_sizes AS has_individual_sizes_46, t23.short_description AS short_description_47, t23.editor_override_type AS editor_override_type_48, t23.editor_override_config AS editor_override_config_49, t23.owner_id AS owner_id_50, t23.page_id AS page_id_51 FROM page t0 LEFT JOIN shop_product t23 ON t23.page_id = t0.id WHERE t0.id = 158;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.custom_link AS custom_link_3,
  t0.position AS position_4,
  t0.target AS target_5,
  t0.is_visible AS is_visible_6,
  t0.link_type AS link_type_7,
  t0.page_id AS page_id_8,
  t0.parent_id AS parent_id_9
FROM
  navigation_item t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.custom_link AS custom_link_3, t0.position AS position_4, t0.target AS target_5, t0.is_visible AS is_visible_6, t0.link_type AS link_type_7, t0.page_id AS page_id_8, t0.parent_id AS parent_id_9 FROM navigation_item t0 WHERE t0.parent_id = 14 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.title_short AS title_short_3,
  t0.slug AS slug_4,
  t0.description AS description_5,
  t0.price AS price_6,
  t0.is_calculated AS is_calculated_7,
  t0.min_size_x AS min_size_x_8,
  t0.min_size_y AS min_size_y_9,
  t0.max_size_x AS max_size_x_10,
  t0.max_size_y AS max_size_y_11,
  t0.formula AS formula_12,
  t0.stock AS stock_13,
  t0.sku AS sku_14,
  t0.processing_fee AS processing_fee_15,
  t0.position AS position_16,
  t0.is_published AS is_published_17,
  t0.is_deleted AS is_deleted_18,
  t0.image_name AS image_name_19,
  t0.updated_at AS updated_at_20,
  t0.shipping_info AS shipping_info_21,
  t0.shipping_duration AS shipping_duration_22,
  t0.has_individual_sizes AS has_individual_sizes_23,
  t0.short_description AS short_description_24,
  t0.editor_override_type AS editor_override_type_25,
  t0.editor_override_config AS editor_override_config_26,
  t0.owner_id AS owner_id_27,
  t0.page_id AS page_id_28
FROM
  shop_product t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.title_short AS title_short_3, t0.slug AS slug_4, t0.description AS description_5, t0.price AS price_6, t0.is_calculated AS is_calculated_7, t0.min_size_x AS min_size_x_8, t0.min_size_y AS min_size_y_9, t0.max_size_x AS max_size_x_10, t0.max_size_y AS max_size_y_11, t0.formula AS formula_12, t0.stock AS stock_13, t0.sku AS sku_14, t0.processing_fee AS processing_fee_15, t0.position AS position_16, t0.is_published AS is_published_17, t0.is_deleted AS is_deleted_18, t0.image_name AS image_name_19, t0.updated_at AS updated_at_20, t0.shipping_info AS shipping_info_21, t0.shipping_duration AS shipping_duration_22, t0.has_individual_sizes AS has_individual_sizes_23, t0.short_description AS short_description_24, t0.editor_override_type AS editor_override_type_25, t0.editor_override_config AS editor_override_config_26, t0.owner_id AS owner_id_27, t0.page_id AS page_id_28 FROM shop_product t0 WHERE t0.slug = 'fotomappe-game-on' LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.title AS title_1,
  s0_.title_short AS title_short_2,
  s0_.slug AS slug_3,
  s0_.description AS description_4,
  s0_.price AS price_5,
  s0_.is_calculated AS is_calculated_6,
  s0_.min_size_x AS min_size_x_7,
  s0_.min_size_y AS min_size_y_8,
  s0_.max_size_x AS max_size_x_9,
  s0_.max_size_y AS max_size_y_10,
  s0_.formula AS formula_11,
  s0_.stock AS stock_12,
  s0_.sku AS sku_13,
  s0_.processing_fee AS processing_fee_14,
  s0_.position AS position_15,
  s0_.is_published AS is_published_16,
  s0_.is_deleted AS is_deleted_17,
  s0_.image_name AS image_name_18,
  s0_.updated_at AS updated_at_19,
  s0_.shipping_info AS shipping_info_20,
  s0_.shipping_duration AS shipping_duration_21,
  s0_.has_individual_sizes AS has_individual_sizes_22,
  s0_.short_description AS short_description_23,
  s0_.editor_override_type AS editor_override_type_24,
  s0_.editor_override_config AS editor_override_config_25,
  s0_.owner_id AS owner_id_26,
  s0_.page_id AS page_id_27
FROM
  shop_product s0_
  INNER JOIN shop_category_product s2_ ON s0_.id = s2_.product_id
  INNER JOIN shop_category s1_ ON s1_.id = s2_.category_id
WHERE
  s1_.id IN (?)
  AND s0_.id <> ?
  AND s0_.is_published = ?
  AND s0_.is_deleted = ?
  AND s0_.is_calculated = ?
GROUP BY
  s0_.id
ORDER BY
  s0_.id DESC
LIMIT
  4

SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.title_short AS title_short_2, s0_.slug AS slug_3, s0_.description AS description_4, s0_.price AS price_5, s0_.is_calculated AS is_calculated_6, s0_.min_size_x AS min_size_x_7, s0_.min_size_y AS min_size_y_8, s0_.max_size_x AS max_size_x_9, s0_.max_size_y AS max_size_y_10, s0_.formula AS formula_11, s0_.stock AS stock_12, s0_.sku AS sku_13, s0_.processing_fee AS processing_fee_14, s0_.position AS position_15, s0_.is_published AS is_published_16, s0_.is_deleted AS is_deleted_17, s0_.image_name AS image_name_18, s0_.updated_at AS updated_at_19, s0_.shipping_info AS shipping_info_20, s0_.shipping_duration AS shipping_duration_21, s0_.has_individual_sizes AS has_individual_sizes_22, s0_.short_description AS short_description_23, s0_.editor_override_type AS editor_override_type_24, s0_.editor_override_config AS editor_override_config_25, s0_.owner_id AS owner_id_26, s0_.page_id AS page_id_27 FROM shop_product s0_ INNER JOIN shop_category_product s2_ ON s0_.id = s2_.product_id INNER JOIN shop_category s1_ ON s1_.id = s2_.category_id WHERE s1_.id IN (48) AND s0_.id <> 310 AND s0_.is_published = 1 AND s0_.is_deleted = 0 AND s0_.is_calculated = 0 GROUP BY s0_.id ORDER BY s0_.id DESC LIMIT 4;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.created_at AS created_at_5,
  t0.modified_at AS modified_at_6,
  t0.position AS position_7,
  t0.is_deleted AS is_deleted_8,
  t0.is_configurable AS is_configurable_9,
  t0.is_published AS is_published_10,
  t0.custom_link AS custom_link_11,
  t0.image_name AS image_name_12,
  t0.updated_at AS updated_at_13,
  t0.editor_type AS editor_type_14,
  t0.editor_config AS editor_config_15,
  t0.show_in_editor AS show_in_editor_16,
  t0.parent_id AS parent_id_17
FROM
  shop_category t0
  INNER JOIN shop_category_product ON t0.id = shop_category_product.category_id
WHERE
  shop_category_product.product_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.modified_at AS modified_at_6, t0.position AS position_7, t0.is_deleted AS is_deleted_8, t0.is_configurable AS is_configurable_9, t0.is_published AS is_published_10, t0.custom_link AS custom_link_11, t0.image_name AS image_name_12, t0.updated_at AS updated_at_13, t0.editor_type AS editor_type_14, t0.editor_config AS editor_config_15, t0.show_in_editor AS show_in_editor_16, t0.parent_id AS parent_id_17 FROM shop_category t0 INNER JOIN shop_category_product ON t0.id = shop_category_product.category_id WHERE shop_category_product.product_id = 310;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.price AS price_3,
  t0.price_special AS price_special_4,
  t0.formula AS formula_5,
  t0.is_crop AS is_crop_6,
  t0.is_rounded AS is_rounded_7,
  t0.is_default AS is_default_8,
  t0.sku AS sku_9,
  t0.position AS position_10,
  t0.is_published AS is_published_11,
  t0.created_at AS created_at_12,
  t0.is_formula AS is_formula_13,
  t0.is_featured AS is_featured_14,
  t0.image_name AS image_name_15,
  t0.updated_at AS updated_at_16,
  t0.variant_group_id AS variant_group_id_17,
  t0.product_id AS product_id_18,
  t0.size_id AS size_id_19
FROM
  shop_variant t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.price AS price_3, t0.price_special AS price_special_4, t0.formula AS formula_5, t0.is_crop AS is_crop_6, t0.is_rounded AS is_rounded_7, t0.is_default AS is_default_8, t0.sku AS sku_9, t0.position AS position_10, t0.is_published AS is_published_11, t0.created_at AS created_at_12, t0.is_formula AS is_formula_13, t0.is_featured AS is_featured_14, t0.image_name AS image_name_15, t0.updated_at AS updated_at_16, t0.variant_group_id AS variant_group_id_17, t0.product_id AS product_id_18, t0.size_id AS size_id_19 FROM shop_variant t0 WHERE t0.product_id = 310;

SELECT
  t0.file_path AS file_path_1,
  t0.uploaded_at AS uploaded_at_2,
  t0.id AS id_3
FROM
  picture_source t0
  INNER JOIN shop_product_gallery ON t0.id = shop_product_gallery.media_object_id
WHERE
  shop_product_gallery.product_id = ?

SELECT t0.file_path AS file_path_1, t0.uploaded_at AS uploaded_at_2, t0.id AS id_3 FROM picture_source t0 INNER JOIN shop_product_gallery ON t0.id = shop_product_gallery.media_object_id WHERE shop_product_gallery.product_id = 310;

SELECT
  f0_.id AS id_0,
  f0_.headline AS headline_1,
  f0_.position AS position_2,
  f0_.is_published AS is_published_3,
  f1_.id AS id_4,
  f1_.label AS label_5,
  f1_.url AS url_6,
  f1_.position AS position_7,
  f1_.is_published AS is_published_8,
  f1_.column_id AS column_id_9,
  f1_.page_id AS page_id_10
FROM
  footer_column f0_
  LEFT JOIN footer_link f1_ ON f0_.id = f1_.column_id
WHERE
  f0_.is_published = ?
  AND (
    f1_.id IS NULL
    OR f1_.is_published = ?
  )
ORDER BY
  f0_.position ASC,
  f0_.id ASC,
  f1_.position ASC,
  f1_.id ASC

SELECT f0_.id AS id_0, f0_.headline AS headline_1, f0_.position AS position_2, f0_.is_published AS is_published_3, f1_.id AS id_4, f1_.label AS label_5, f1_.url AS url_6, f1_.position AS position_7, f1_.is_published AS is_published_8, f1_.column_id AS column_id_9, f1_.page_id AS page_id_10 FROM footer_column f0_ LEFT JOIN footer_link f1_ ON f0_.id = f1_.column_id WHERE f0_.is_published = 1 AND (f1_.id IS NULL OR f1_.is_published = 1) ORDER BY f0_.position ASC, f0_.id ASC, f1_.position ASC, f1_.id ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.custom_link AS custom_link_3,
  t0.position AS position_4,
  t0.target AS target_5,
  t0.is_visible AS is_visible_6,
  t0.link_type AS link_type_7,
  t0.page_id AS page_id_8,
  t0.parent_id AS parent_id_9
FROM
  navigation_item t0
WHERE
  t0.parent_id IS NULL
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.custom_link AS custom_link_3, t0.position AS position_4, t0.target AS target_5, t0.is_visible AS is_visible_6, t0.link_type AS link_type_7, t0.page_id AS page_id_8, t0.parent_id AS parent_id_9 FROM navigation_item t0 WHERE t0.parent_id IS NULL ORDER BY t0.position ASC;