Symfony Profiler

SELECT
  a0_.id AS id_0,
  a0_.uuid AS uuid_1,
  a0_.slug AS slug_2,
  a0_.short_description AS short_description_3,
  a0_.supplier_reference AS supplier_reference_4,
  a0_.specification AS specification_5,
  a0_.position AS position_6,
  a0_.sku AS sku_7,
  a0_.status AS status_8,
  a0_.state AS state_9,
  a0_.weight AS weight_10,
  a0_.length AS length_11,
  a0_.width AS width_12,
  a0_.height AS height_13,
  a0_.ean AS ean_14,
  a0_.reference AS reference_15,
  a0_.ean_code_id AS ean_code_id_16,
  a0_.battery_type AS battery_type_17,
  a0_.quality_score AS quality_score_18,
  a0_.quality_issues AS quality_issues_19,
  a0_.battery_weight AS battery_weight_20,
  a0_.country_of_origin AS country_of_origin_21,
  a0_.packaging AS packaging_22,
  a0_.old_packaging AS old_packaging_23,
  a0_.customs_code AS customs_code_24,
  a0_.dpp_enabled AS dpp_enabled_25,
  a0_.novelty AS novelty_26,
  a0_.novelty_start AS novelty_start_27,
  a0_.novelty_end AS novelty_end_28,
  a0_.created_at AS created_at_29,
  a0_.updated_at AS updated_at_30,
  a0_.deleted_at AS deleted_at_31,
  a0_.parent_article_id AS parent_article_id_32,
  a0_.category_id AS category_id_33,
  a0_.deleted_by_id AS deleted_by_id_34,
  a0_.created_by_id AS created_by_id_35,
  a0_.reference_resource_id AS reference_resource_id_36
FROM
  article a0_
WHERE
  a0_.ean IN (?, ?)
  AND a0_.dpp_enabled = 1
  AND a0_.deleted_at IS NULL
LIMIT
  1

SELECT a0_.id AS id_0, a0_.uuid AS uuid_1, a0_.slug AS slug_2, a0_.short_description AS short_description_3, a0_.supplier_reference AS supplier_reference_4, a0_.specification AS specification_5, a0_.position AS position_6, a0_.sku AS sku_7, a0_.status AS status_8, a0_.state AS state_9, a0_.weight AS weight_10, a0_.length AS length_11, a0_.width AS width_12, a0_.height AS height_13, a0_.ean AS ean_14, a0_.reference AS reference_15, a0_.ean_code_id AS ean_code_id_16, a0_.battery_type AS battery_type_17, a0_.quality_score AS quality_score_18, a0_.quality_issues AS quality_issues_19, a0_.battery_weight AS battery_weight_20, a0_.country_of_origin AS country_of_origin_21, a0_.packaging AS packaging_22, a0_.old_packaging AS old_packaging_23, a0_.customs_code AS customs_code_24, a0_.dpp_enabled AS dpp_enabled_25, a0_.novelty AS novelty_26, a0_.novelty_start AS novelty_start_27, a0_.novelty_end AS novelty_end_28, a0_.created_at AS created_at_29, a0_.updated_at AS updated_at_30, a0_.deleted_at AS deleted_at_31, a0_.parent_article_id AS parent_article_id_32, a0_.category_id AS category_id_33, a0_.deleted_by_id AS deleted_by_id_34, a0_.created_by_id AS created_by_id_35, a0_.reference_resource_id AS reference_resource_id_36 FROM article a0_ WHERE a0_.ean IN ('03394661033598', '3394661033598') AND a0_.dpp_enabled = 1 AND a0_.deleted_at IS NULL LIMIT 1;

SELECT
  l0_.id AS id_0,
  l0_.code AS code_1,
  l0_.name AS name_2,
  l0_.active AS active_3,
  l0_.is_default AS is_default_4,
  l0_.position AS position_5
FROM
  language l0_
  INNER JOIN language_space l2_ ON l0_.id = l2_.language_id
  INNER JOIN space s1_ ON s1_.id = l2_.space_id
WHERE
  l0_.active = 1
  AND s1_.code = ?
ORDER BY
  l0_.is_default DESC,
  l0_.position ASC

SELECT l0_.id AS id_0, l0_.code AS code_1, l0_.name AS name_2, l0_.active AS active_3, l0_.is_default AS is_default_4, l0_.position AS position_5 FROM language l0_ INNER JOIN language_space l2_ ON l0_.id = l2_.language_id INNER JOIN space s1_ ON s1_.id = l2_.space_id WHERE l0_.active = 1 AND s1_.code = 'partner' ORDER BY l0_.is_default DESC, l0_.position ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.type AS type_3,
  t0.filename AS filename_4,
  t0.original_name AS original_name_5,
  t0.original_url AS original_url_6,
  t0.mime_type AS mime_type_7,
  t0.size AS size_8,
  t0.width AS width_9,
  t0.height AS height_10,
  t0.dpi AS dpi_11,
  t0.position AS position_12,
  t0.created_at AS created_at_13,
  t0.public_enabled AS public_enabled_14,
  t0.public_uuid AS public_uuid_15
FROM
  resource t0
  INNER JOIN resource_article ON t0.id = resource_article.resource_id
WHERE
  resource_article.article_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.filename AS filename_4, t0.original_name AS original_name_5, t0.original_url AS original_url_6, t0.mime_type AS mime_type_7, t0.size AS size_8, t0.width AS width_9, t0.height AS height_10, t0.dpi AS dpi_11, t0.position AS position_12, t0.created_at AS created_at_13, t0.public_enabled AS public_enabled_14, t0.public_uuid AS public_uuid_15 FROM resource t0 INNER JOIN resource_article ON t0.id = resource_article.resource_id WHERE resource_article.article_id = 16543 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.designation AS designation_3,
  t0.long_designation AS long_designation_4,
  t0.additional_description AS additional_description_5,
  t0.other_standards AS other_standards_6,
  t0.other_info AS other_info_7,
  t0.product_reference AS product_reference_8,
  t0.department AS department_9,
  t0.product_status AS product_status_10,
  t0.ce AS ce_11,
  t0.quality_score AS quality_score_12,
  t0.quality_issues AS quality_issues_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.brand_id AS brand_id_16,
  t0.category_id AS category_id_17,
  t0.created_by_id AS created_by_id_18,
  t0.reference_resource_id AS reference_resource_id_19
FROM
  parent_article t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.designation AS designation_3, t0.long_designation AS long_designation_4, t0.additional_description AS additional_description_5, t0.other_standards AS other_standards_6, t0.other_info AS other_info_7, t0.product_reference AS product_reference_8, t0.department AS department_9, t0.product_status AS product_status_10, t0.ce AS ce_11, t0.quality_score AS quality_score_12, t0.quality_issues AS quality_issues_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.brand_id AS brand_id_16, t0.category_id AS category_id_17, t0.created_by_id AS created_by_id_18, t0.reference_resource_id AS reference_resource_id_19 FROM parent_article t0 WHERE t0.id = 5197;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.short_description AS short_description_3,
  t0.specification AS specification_4,
  t0.length_value AS length_value_5,
  t0.width_value AS width_value_6,
  t0.height_value AS height_value_7,
  t0.weight_value AS weight_value_8,
  t0.manual_fields AS manual_fields_9,
  t0.article_id AS article_id_10
FROM
  article_translation t0
WHERE
  t0.article_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.short_description AS short_description_3, t0.specification AS specification_4, t0.length_value AS length_value_5, t0.width_value AS width_value_6, t0.height_value AS height_value_7, t0.weight_value AS weight_value_8, t0.manual_fields AS manual_fields_9, t0.article_id AS article_id_10 FROM article_translation t0 WHERE t0.article_id = 16543;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.name AS name_3,
  t0.category_id AS category_id_4
FROM
  category_translation t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.category_id AS category_id_4 FROM category_translation t0 WHERE t0.category_id = 1986;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.position AS position_4,
  t0.article_id AS article_id_5
FROM
  article_attribute t0
WHERE
  t0.article_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.position AS position_4, t0.article_id AS article_id_5 FROM article_attribute t0 WHERE t0.article_id = 16543 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image_key AS image_key_4,
  t0.parent_id AS parent_id_5
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_key AS image_key_4, t0.parent_id AS parent_id_5 FROM category t0 WHERE t0.id = 1986;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.logo_filename AS logo_filename_4,
  t0.description AS description_5,
  t0.website AS website_6,
  t0.country AS country_7
FROM
  brand t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.logo_filename AS logo_filename_4, t0.description AS description_5, t0.website AS website_6, t0.country AS country_7 FROM brand t0 WHERE t0.id = 10;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.active AS active_4,
  t0.is_default AS is_default_5,
  t0.position AS position_6
FROM
  language t0
WHERE
  t0.is_default = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.active AS active_4, t0.is_default AS is_default_5, t0.position AS position_6 FROM language t0 WHERE t0.is_default = 1 LIMIT 1;