Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.company_name AS company_name_3,
  t0.address AS address_4,
  t0.address2 AS address2_5,
  t0.postcode AS postcode_6,
  t0.city AS city_7,
  t0.phone AS phone_8,
  t0.email AS email_9,
  t0.website AS website_10,
  t0.vat_number AS vat_number_11,
  t0.siren AS siren_12,
  t0.siret AS siret_13,
  t0.ape AS ape_14,
  t0.is_franchise AS is_franchise_15,
  t0.position AS position_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.deleted_at AS deleted_at_19,
  t0.is_default AS is_default_20,
  t0.currency_id AS currency_id_21,
  t0.country_id AS country_id_22,
  t0.country_state_id AS country_state_id_23,
  t0.created_by_id AS created_by_id_24,
  t0.updated_by_id AS updated_by_id_25,
  t0.deleted_by_id AS deleted_by_id_26
FROM
  context t0
WHERE
  t0.is_default = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.email AS email_9, t0.website AS website_10, t0.vat_number AS vat_number_11, t0.siren AS siren_12, t0.siret AS siret_13, t0.ape AS ape_14, t0.is_franchise AS is_franchise_15, t0.position AS position_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.is_default AS is_default_20, t0.currency_id AS currency_id_21, t0.country_id AS country_id_22, t0.country_state_id AS country_state_id_23, t0.created_by_id AS created_by_id_24, t0.updated_by_id AS updated_by_id_25, t0.deleted_by_id AS deleted_by_id_26 FROM context t0 WHERE t0.is_default = 1 AND ((t0.deleted_at IS NULL)) LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.context_id AS context_id_6,
  t0.created_by_id AS created_by_id_7,
  t0.updated_by_id AS updated_by_id_8
FROM
  configuration t0
WHERE
  t0.name = ?
  AND t0.context_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = 'supplier_order_state_for_supplier_waiting_in_the_product_view' AND t0.context_id = 0x1EC8351D48E264068FE96FE6D01BAFC6 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.context_id AS context_id_6,
  t0.created_by_id AS created_by_id_7,
  t0.updated_by_id AS updated_by_id_8
FROM
  configuration t0
WHERE
  t0.name = ?
  AND t0.context_id IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = 'supplier_order_state_for_supplier_waiting_in_the_product_view' AND t0.context_id IS NULL LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.company_name AS company_name_3,
  t0.address AS address_4,
  t0.address2 AS address2_5,
  t0.postcode AS postcode_6,
  t0.city AS city_7,
  t0.phone AS phone_8,
  t0.email AS email_9,
  t0.website AS website_10,
  t0.vat_number AS vat_number_11,
  t0.siren AS siren_12,
  t0.siret AS siret_13,
  t0.ape AS ape_14,
  t0.is_franchise AS is_franchise_15,
  t0.position AS position_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.deleted_at AS deleted_at_19,
  t0.is_default AS is_default_20,
  t0.currency_id AS currency_id_21,
  t0.country_id AS country_id_22,
  t0.country_state_id AS country_state_id_23,
  t0.created_by_id AS created_by_id_24,
  t0.updated_by_id AS updated_by_id_25,
  t0.deleted_by_id AS deleted_by_id_26
FROM
  context t0
WHERE
  t0.is_default = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.email AS email_9, t0.website AS website_10, t0.vat_number AS vat_number_11, t0.siren AS siren_12, t0.siret AS siret_13, t0.ape AS ape_14, t0.is_franchise AS is_franchise_15, t0.position AS position_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.is_default AS is_default_20, t0.currency_id AS currency_id_21, t0.country_id AS country_id_22, t0.country_state_id AS country_state_id_23, t0.created_by_id AS created_by_id_24, t0.updated_by_id AS updated_by_id_25, t0.deleted_by_id AS deleted_by_id_26 FROM context t0 WHERE t0.is_default = 1 AND ((t0.deleted_at IS NULL)) LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.context_id AS context_id_6,
  t0.created_by_id AS created_by_id_7,
  t0.updated_by_id AS updated_by_id_8
FROM
  configuration t0
WHERE
  t0.name = ?
  AND t0.context_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = 'supplier_order_state_for_supplier_waiting_in_the_product_view' AND t0.context_id = 0x1EC8351D48E264068FE96FE6D01BAFC6 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.context_id AS context_id_6,
  t0.created_by_id AS created_by_id_7,
  t0.updated_by_id AS updated_by_id_8
FROM
  configuration t0
WHERE
  t0.name = ?
  AND t0.context_id IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = 'supplier_order_state_for_supplier_waiting_in_the_product_view' AND t0.context_id IS NULL LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.company_name AS company_name_3,
  t0.address AS address_4,
  t0.address2 AS address2_5,
  t0.postcode AS postcode_6,
  t0.city AS city_7,
  t0.phone AS phone_8,
  t0.email AS email_9,
  t0.website AS website_10,
  t0.vat_number AS vat_number_11,
  t0.siren AS siren_12,
  t0.siret AS siret_13,
  t0.ape AS ape_14,
  t0.is_franchise AS is_franchise_15,
  t0.position AS position_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.deleted_at AS deleted_at_19,
  t0.is_default AS is_default_20,
  t0.currency_id AS currency_id_21,
  t0.country_id AS country_id_22,
  t0.country_state_id AS country_state_id_23,
  t0.created_by_id AS created_by_id_24,
  t0.updated_by_id AS updated_by_id_25,
  t0.deleted_by_id AS deleted_by_id_26
FROM
  context t0
WHERE
  t0.is_default = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.email AS email_9, t0.website AS website_10, t0.vat_number AS vat_number_11, t0.siren AS siren_12, t0.siret AS siret_13, t0.ape AS ape_14, t0.is_franchise AS is_franchise_15, t0.position AS position_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.is_default AS is_default_20, t0.currency_id AS currency_id_21, t0.country_id AS country_id_22, t0.country_state_id AS country_state_id_23, t0.created_by_id AS created_by_id_24, t0.updated_by_id AS updated_by_id_25, t0.deleted_by_id AS deleted_by_id_26 FROM context t0 WHERE t0.is_default = 1 AND ((t0.deleted_at IS NULL)) LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.context_id AS context_id_6,
  t0.created_by_id AS created_by_id_7,
  t0.updated_by_id AS updated_by_id_8
FROM
  configuration t0
WHERE
  t0.name = ?
  AND t0.context_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = 'sales_bundle__shared_sales' AND t0.context_id = 0x1EC8351D48E264068FE96FE6D01BAFC6 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.context_id AS context_id_6,
  t0.created_by_id AS created_by_id_7,
  t0.updated_by_id AS updated_by_id_8
FROM
  configuration t0
WHERE
  t0.name = ?
  AND t0.context_id IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = 'sales_bundle__shared_sales' AND t0.context_id IS NULL LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.company_name AS company_name_3,
  t0.address AS address_4,
  t0.address2 AS address2_5,
  t0.postcode AS postcode_6,
  t0.city AS city_7,
  t0.phone AS phone_8,
  t0.email AS email_9,
  t0.website AS website_10,
  t0.vat_number AS vat_number_11,
  t0.siren AS siren_12,
  t0.siret AS siret_13,
  t0.ape AS ape_14,
  t0.is_franchise AS is_franchise_15,
  t0.position AS position_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.deleted_at AS deleted_at_19,
  t0.is_default AS is_default_20,
  t0.currency_id AS currency_id_21,
  t0.country_id AS country_id_22,
  t0.country_state_id AS country_state_id_23,
  t0.created_by_id AS created_by_id_24,
  t0.updated_by_id AS updated_by_id_25,
  t0.deleted_by_id AS deleted_by_id_26
FROM
  context t0
WHERE
  t0.is_default = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.email AS email_9, t0.website AS website_10, t0.vat_number AS vat_number_11, t0.siren AS siren_12, t0.siret AS siret_13, t0.ape AS ape_14, t0.is_franchise AS is_franchise_15, t0.position AS position_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.is_default AS is_default_20, t0.currency_id AS currency_id_21, t0.country_id AS country_id_22, t0.country_state_id AS country_state_id_23, t0.created_by_id AS created_by_id_24, t0.updated_by_id AS updated_by_id_25, t0.deleted_by_id AS deleted_by_id_26 FROM context t0 WHERE t0.is_default = 1 AND ((t0.deleted_at IS NULL)) LIMIT 1;

SELECT
  e0_.id AS id_0,
  e0_.name AS name_1,
  e0_.reference AS reference_2,
  e0_.address AS address_3,
  e0_.address2 AS address2_4,
  e0_.postcode AS postcode_5,
  e0_.city AS city_6,
  e0_.phone AS phone_7,
  e0_.email AS email_8,
  e0_.created_at AS created_at_9,
  e0_.updated_at AS updated_at_10,
  e0_.deleted_at AS deleted_at_11,
  e0_.country_id AS country_id_12,
  e0_.context_id AS context_id_13,
  e0_.created_by_id AS created_by_id_14,
  e0_.updated_by_id AS updated_by_id_15,
  e0_.deleted_by_id AS deleted_by_id_16
FROM
  establishment e0_
WHERE
  (e0_.deleted_at IS NULL)

SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.reference AS reference_2, e0_.address AS address_3, e0_.address2 AS address2_4, e0_.postcode AS postcode_5, e0_.city AS city_6, e0_.phone AS phone_7, e0_.email AS email_8, e0_.created_at AS created_at_9, e0_.updated_at AS updated_at_10, e0_.deleted_at AS deleted_at_11, e0_.country_id AS country_id_12, e0_.context_id AS context_id_13, e0_.created_by_id AS created_by_id_14, e0_.updated_by_id AS updated_by_id_15, e0_.deleted_by_id AS deleted_by_id_16 FROM establishment e0_ WHERE (e0_.deleted_at IS NULL);

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.company_name AS company_name_3,
  t0.address AS address_4,
  t0.address2 AS address2_5,
  t0.postcode AS postcode_6,
  t0.city AS city_7,
  t0.phone AS phone_8,
  t0.email AS email_9,
  t0.website AS website_10,
  t0.vat_number AS vat_number_11,
  t0.siren AS siren_12,
  t0.siret AS siret_13,
  t0.ape AS ape_14,
  t0.is_franchise AS is_franchise_15,
  t0.position AS position_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.deleted_at AS deleted_at_19,
  t0.is_default AS is_default_20,
  t0.currency_id AS currency_id_21,
  t0.country_id AS country_id_22,
  t0.country_state_id AS country_state_id_23,
  t0.created_by_id AS created_by_id_24,
  t0.updated_by_id AS updated_by_id_25,
  t0.deleted_by_id AS deleted_by_id_26
FROM
  context t0
WHERE
  t0.is_default = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.email AS email_9, t0.website AS website_10, t0.vat_number AS vat_number_11, t0.siren AS siren_12, t0.siret AS siret_13, t0.ape AS ape_14, t0.is_franchise AS is_franchise_15, t0.position AS position_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.is_default AS is_default_20, t0.currency_id AS currency_id_21, t0.country_id AS country_id_22, t0.country_state_id AS country_state_id_23, t0.created_by_id AS created_by_id_24, t0.updated_by_id AS updated_by_id_25, t0.deleted_by_id AS deleted_by_id_26 FROM context t0 WHERE t0.is_default = 1 AND ((t0.deleted_at IS NULL)) LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.context_id AS context_id_6,
  t0.created_by_id AS created_by_id_7,
  t0.updated_by_id AS updated_by_id_8
FROM
  configuration t0
WHERE
  t0.name = ?
  AND t0.context_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = 'prestashop_connector_bundle__shop_url' AND t0.context_id = 0x1EC8351D48E264068FE96FE6D01BAFC6 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.company_name AS company_name_3,
  t0.address AS address_4,
  t0.address2 AS address2_5,
  t0.postcode AS postcode_6,
  t0.city AS city_7,
  t0.phone AS phone_8,
  t0.email AS email_9,
  t0.website AS website_10,
  t0.vat_number AS vat_number_11,
  t0.siren AS siren_12,
  t0.siret AS siret_13,
  t0.ape AS ape_14,
  t0.is_franchise AS is_franchise_15,
  t0.position AS position_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.deleted_at AS deleted_at_19,
  t0.is_default AS is_default_20,
  t0.currency_id AS currency_id_21,
  t0.country_id AS country_id_22,
  t0.country_state_id AS country_state_id_23,
  t0.created_by_id AS created_by_id_24,
  t0.updated_by_id AS updated_by_id_25,
  t0.deleted_by_id AS deleted_by_id_26
FROM
  context t0
WHERE
  t0.is_default = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.email AS email_9, t0.website AS website_10, t0.vat_number AS vat_number_11, t0.siren AS siren_12, t0.siret AS siret_13, t0.ape AS ape_14, t0.is_franchise AS is_franchise_15, t0.position AS position_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.is_default AS is_default_20, t0.currency_id AS currency_id_21, t0.country_id AS country_id_22, t0.country_state_id AS country_state_id_23, t0.created_by_id AS created_by_id_24, t0.updated_by_id AS updated_by_id_25, t0.deleted_by_id AS deleted_by_id_26 FROM context t0 WHERE t0.is_default = 1 AND ((t0.deleted_at IS NULL)) LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.context_id AS context_id_6,
  t0.created_by_id AS created_by_id_7,
  t0.updated_by_id AS updated_by_id_8
FROM
  configuration t0
WHERE
  t0.name = ?
  AND t0.context_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = 'prestashop_connector_bundle__api_key' AND t0.context_id = 0x1EC8351D48E264068FE96FE6D01BAFC6 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.email AS email_4,
  t0.mobile_phone AS mobile_phone_5,
  t0.password AS password_6,
  t0.token AS token_7,
  t0.token_validity AS token_validity_8,
  t0.login_name AS login_name_9,
  t0.api_pin AS api_pin_10,
  t0.api_token AS api_token_11,
  t0.api_token_validity AS api_token_validity_12,
  t0.config AS config_13,
  t0.email_signature AS email_signature_14,
  t0.note AS note_15,
  t0.is_solo AS is_solo_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.deleted_at AS deleted_at_19,
  t0.is_active AS is_active_20,
  t0.profile_id AS profile_id_21,
  t0.language_id AS language_id_22,
  t0.created_by_id AS created_by_id_23,
  t0.updated_by_id AS updated_by_id_24,
  t0.deleted_by_id AS deleted_by_id_25
FROM
  user t0
WHERE
  t0.email = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.mobile_phone AS mobile_phone_5, t0.password AS password_6, t0.token AS token_7, t0.token_validity AS token_validity_8, t0.login_name AS login_name_9, t0.api_pin AS api_pin_10, t0.api_token AS api_token_11, t0.api_token_validity AS api_token_validity_12, t0.config AS config_13, t0.email_signature AS email_signature_14, t0.note AS note_15, t0.is_solo AS is_solo_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.is_active AS is_active_20, t0.profile_id AS profile_id_21, t0.language_id AS language_id_22, t0.created_by_id AS created_by_id_23, t0.updated_by_id AS updated_by_id_24, t0.deleted_by_id AS deleted_by_id_25 FROM user t0 WHERE t0.email = 'contact@scaledev.fr' AND ((t0.deleted_at IS NULL)) LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.roles AS roles_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6
FROM
  profile t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6 FROM profile t0 WHERE t0.id = 0x1EC8351D41C6648881B66FE6D01BAFC6;

SELECT
  p0_.id AS id_0,
  p0_.value AS value_1,
  p0_.created_at AS created_at_2,
  p0_.updated_at AS updated_at_3,
  p0_.deleted_at AS deleted_at_4,
  p0_.is_default AS is_default_5,
  p0_.product_id AS product_id_6,
  p0_.declination_id AS declination_id_7,
  p0_.created_by_id AS created_by_id_8,
  p0_.updated_by_id AS updated_by_id_9,
  p0_.deleted_by_id AS deleted_by_id_10
FROM
  products_bundle__ean13 p0_
  LEFT JOIN products_bundle__product p1_ ON p0_.product_id = p1_.id
  AND (p1_.deleted_at IS NULL)
  LEFT JOIN products_bundle__product_context p2_ ON p1_.id = p2_.product_id
  AND (p2_.deleted_at IS NULL)
  LEFT JOIN products_bundle__declination p3_ ON p0_.declination_id = p3_.id
  AND (p3_.deleted_at IS NULL)
  LEFT JOIN products_bundle__declination_context p4_ ON p3_.id = p4_.declination_id
  AND (p4_.deleted_at IS NULL)
WHERE
  (
    p0_.value = ?
    AND (
      p2_.context_id = ?
      OR p4_.context_id = ?
    )
  )
  AND (p0_.deleted_at IS NULL)
LIMIT
  1

SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.deleted_at AS deleted_at_4, p0_.is_default AS is_default_5, p0_.product_id AS product_id_6, p0_.declination_id AS declination_id_7, p0_.created_by_id AS created_by_id_8, p0_.updated_by_id AS updated_by_id_9, p0_.deleted_by_id AS deleted_by_id_10 FROM products_bundle__ean13 p0_ LEFT JOIN products_bundle__product p1_ ON p0_.product_id = p1_.id AND (p1_.deleted_at IS NULL) LEFT JOIN products_bundle__product_context p2_ ON p1_.id = p2_.product_id AND (p2_.deleted_at IS NULL) LEFT JOIN products_bundle__declination p3_ ON p0_.declination_id = p3_.id AND (p3_.deleted_at IS NULL) LEFT JOIN products_bundle__declination_context p4_ ON p3_.id = p4_.declination_id AND (p4_.deleted_at IS NULL) WHERE (p0_.value = 'piscine' AND (p2_.context_id = 0x1EC8351D48E264068FE96FE6D01BAFC6 OR p4_.context_id = 0x1EC8351D48E264068FE96FE6D01BAFC6)) AND (p0_.deleted_at IS NULL) LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.wholesale_price AS wholesale_price_3,
  t0.sell_price AS sell_price_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.deleted_at AS deleted_at_7,
  t0.is_active AS is_active_8,
  t0.is_default AS is_default_9,
  t0.declination_id AS declination_id_10,
  t0.context_id AS context_id_11,
  t0.created_by_id AS created_by_id_12,
  t0.updated_by_id AS updated_by_id_13,
  t0.deleted_by_id AS deleted_by_id_14
FROM
  products_bundle__declination_context t0
WHERE
  t0.context_id = ?
  AND t0.reference = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.wholesale_price AS wholesale_price_3, t0.sell_price AS sell_price_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.is_active AS is_active_8, t0.is_default AS is_default_9, t0.declination_id AS declination_id_10, t0.context_id AS context_id_11, t0.created_by_id AS created_by_id_12, t0.updated_by_id AS updated_by_id_13, t0.deleted_by_id AS deleted_by_id_14 FROM products_bundle__declination_context t0 WHERE t0.context_id = 0x1EC8351D48E264068FE96FE6D01BAFC6 AND t0.reference = 'piscine' AND ((t0.deleted_at IS NULL)) LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.meta_tag_name AS meta_tag_name_3,
  t0.description AS description_4,
  t0.meta_tag_description AS meta_tag_description_5,
  t0.summary AS summary_6,
  t0.source AS source_7,
  t0.reference AS reference_8,
  t0.eco_part_amount AS eco_part_amount_9,
  t0.changeable_tax_rule AS changeable_tax_rule_10,
  t0.available_for_order AS available_for_order_11,
  t0.wholesale_price AS wholesale_price_12,
  t0.sell_price AS sell_price_13,
  t0.link_rewrite AS link_rewrite_14,
  t0.quantity_min AS quantity_min_15,
  t0.visibility AS visibility_16,
  t0.redirect_type AS redirect_type_17,
  t0.out_of_stock AS out_of_stock_18,
  t0.created_at AS created_at_19,
  t0.updated_at AS updated_at_20,
  t0.deleted_at AS deleted_at_21,
  t0.is_active AS is_active_22,
  t0.product_id AS product_id_23,
  t0.context_id AS context_id_24,
  t0.eco_part_id AS eco_part_id_25,
  t0.tax_rule_id AS tax_rule_id_26,
  t0.currency_id AS currency_id_27,
  t0.product_redirect_id AS product_redirect_id_28,
  t0.created_by_id AS created_by_id_29,
  t0.updated_by_id AS updated_by_id_30,
  t0.deleted_by_id AS deleted_by_id_31,
  t0.category_redirect_id AS category_redirect_id_32
FROM
  products_bundle__product_context t0
WHERE
  t0.context_id = ?
  AND t0.reference = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.meta_tag_name AS meta_tag_name_3, t0.description AS description_4, t0.meta_tag_description AS meta_tag_description_5, t0.summary AS summary_6, t0.source AS source_7, t0.reference AS reference_8, t0.eco_part_amount AS eco_part_amount_9, t0.changeable_tax_rule AS changeable_tax_rule_10, t0.available_for_order AS available_for_order_11, t0.wholesale_price AS wholesale_price_12, t0.sell_price AS sell_price_13, t0.link_rewrite AS link_rewrite_14, t0.quantity_min AS quantity_min_15, t0.visibility AS visibility_16, t0.redirect_type AS redirect_type_17, t0.out_of_stock AS out_of_stock_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.deleted_at AS deleted_at_21, t0.is_active AS is_active_22, t0.product_id AS product_id_23, t0.context_id AS context_id_24, t0.eco_part_id AS eco_part_id_25, t0.tax_rule_id AS tax_rule_id_26, t0.currency_id AS currency_id_27, t0.product_redirect_id AS product_redirect_id_28, t0.created_by_id AS created_by_id_29, t0.updated_by_id AS updated_by_id_30, t0.deleted_by_id AS deleted_by_id_31, t0.category_redirect_id AS category_redirect_id_32 FROM products_bundle__product_context t0 WHERE t0.context_id = 0x1EC8351D48E264068FE96FE6D01BAFC6 AND t0.reference = 'piscine' AND ((t0.deleted_at IS NULL)) LIMIT 1;