Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6,
  t0.locale AS locale_7,
  t0.favorite_apps AS favorite_apps_8
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.locale AS locale_7, t0.favorite_apps AS favorite_apps_8 FROM user t0 WHERE t0.id = 10;

SELECT
  t0.id AS id_1,
  t0.title AS title_2
FROM
  activity t0

SELECT t0.id AS id_1, t0.title AS title_2 FROM activity t0;

SELECT
  DISTINCT r0_.country AS country_0
FROM
  retailer r0_

SELECT DISTINCT r0_.country AS country_0 FROM retailer r0_;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  `group` t0

SELECT t0.id AS id_1, t0.name AS name_2 FROM `group` t0;

SELECT
  DISTINCT SUBSTRING(
    a0_.zipcode
    FROM
      1 FOR 2
  ) AS sclr_0
FROM
  address a0_
WHERE
  a0_.zipcode IS NOT NULL
  AND a0_.zipcode <> ?
  AND CHAR_LENGTH(a0_.zipcode) >= 2
ORDER BY
  sclr_0 ASC

SELECT DISTINCT SUBSTRING(a0_.zipcode FROM 1 FOR 2) AS sclr_0 FROM address a0_ WHERE a0_.zipcode IS NOT NULL AND a0_.zipcode <> '' AND CHAR_LENGTH(a0_.zipcode) >= 2 ORDER BY sclr_0 ASC;

SELECT
  DISTINCT r0_.id AS id_0,
  r0_.name AS name_1
FROM
  retailer r0_
WHERE
  (
    (
      LOWER(
        CONCAT(r0_.name, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.address, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.zipcode, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.city, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.phone, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.email, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.siret, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.tva_number, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.type, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.commercial_zone, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.country, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.admin_comment, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.type_profile, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.reseau, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.groupe, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.imported, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.sap_code, '')
      ) LIKE ?
    )
    AND (
      LOWER(
        CONCAT(r0_.name, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.address, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.zipcode, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.city, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.phone, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.email, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.siret, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.tva_number, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.type, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.commercial_zone, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.country, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.admin_comment, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.type_profile, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.reseau, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.groupe, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.imported, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.sap_code, '')
      ) LIKE ?
    )
  )
  OR (
    r0_.id IN (
      SELECT
        a1_.retailer_id AS sclr_2
      FROM
        address a1_
      WHERE
        LOWER(a1_.street) LIKE LOWER(?)
        OR LOWER(a1_.street2) LIKE LOWER(?)
        OR LOWER(a1_.city) LIKE LOWER(?)
        OR LOWER(a1_.zipcode) LIKE LOWER(?)
    )
  )
ORDER BY
  r0_.name ASC
LIMIT
  20

SELECT DISTINCT r0_.id AS id_0, r0_.name AS name_1 FROM retailer r0_ WHERE ((LOWER(CONCAT(r0_.name, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.address, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.zipcode, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.city, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.phone, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.email, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.siret, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.tva_number, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.type, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.commercial_zone, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.country, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.admin_comment, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.type_profile, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.reseau, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.groupe, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.imported, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.sap_code, '')) LIKE '%am%') AND (LOWER(CONCAT(r0_.name, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.address, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.zipcode, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.city, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.phone, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.email, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.siret, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.tva_number, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.type, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.commercial_zone, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.country, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.admin_comment, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.type_profile, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.reseau, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.groupe, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.imported, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.sap_code, '')) LIKE '%env%')) OR (r0_.id IN (SELECT a1_.retailer_id AS sclr_2 FROM address a1_ WHERE LOWER(a1_.street) LIKE LOWER('%am env%') OR LOWER(a1_.street2) LIKE LOWER('%am env%') OR LOWER(a1_.city) LIKE LOWER('%am env%') OR LOWER(a1_.zipcode) LIKE LOWER('%am env%'))) ORDER BY r0_.name ASC LIMIT 20;

SELECT
  r0_.id AS id_0,
  r0_.name AS name_1,
  r0_.address AS address_2,
  r0_.zipcode AS zipcode_3,
  r0_.city AS city_4,
  r0_.phone AS phone_5,
  r0_.email AS email_6,
  r0_.siret AS siret_7,
  r0_.tva_number AS tva_number_8,
  r0_.created_at AS created_at_9,
  r0_.type AS type_10,
  r0_.status AS status_11,
  r0_.commercial_zone AS commercial_zone_12,
  r0_.country AS country_13,
  r0_.verify_by_bd AS verify_by_bd_14,
  r0_.verify_by_na AS verify_by_na_15,
  r0_.verify_by_rl AS verify_by_rl_16,
  r0_.admin_comment AS admin_comment_17,
  r0_.close AS close_18,
  r0_.type_profile AS type_profile_19,
  r0_.reseau AS reseau_20,
  r0_.groupe AS groupe_21,
  r0_.imported AS imported_22,
  r0_.sap_code AS sap_code_23,
  r0_.activity_id AS activity_id_24,
  r0_.rachat_matiere_id AS rachat_matiere_id_25,
  r0_.network_id AS network_id_26,
  r0_.retailer_group_id AS retailer_group_id_27
FROM
  retailer r0_
WHERE
  (
    (
      (
        LOWER(
          CONCAT(r0_.name, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.address, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.zipcode, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.city, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.phone, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.email, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.siret, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.tva_number, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.type, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.commercial_zone, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.country, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.admin_comment, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.type_profile, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.reseau, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.groupe, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.imported, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.sap_code, '')
        ) LIKE ?
      )
      AND (
        LOWER(
          CONCAT(r0_.name, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.address, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.zipcode, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.city, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.phone, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.email, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.siret, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.tva_number, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.type, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.commercial_zone, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.country, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.admin_comment, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.type_profile, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.reseau, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.groupe, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.imported, '')
        ) LIKE ?
        OR LOWER(
          CONCAT(r0_.sap_code, '')
        ) LIKE ?
      )
    )
    OR (
      r0_.id IN (
        SELECT
          a1_.retailer_id AS sclr_28
        FROM
          address a1_
        WHERE
          LOWER(a1_.street) LIKE LOWER(?)
          OR LOWER(a1_.street2) LIKE LOWER(?)
          OR LOWER(a1_.city) LIKE LOWER(?)
          OR LOWER(a1_.zipcode) LIKE LOWER(?)
      )
    )
  )
  AND r0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  r0_.name ASC

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.address AS address_2, r0_.zipcode AS zipcode_3, r0_.city AS city_4, r0_.phone AS phone_5, r0_.email AS email_6, r0_.siret AS siret_7, r0_.tva_number AS tva_number_8, r0_.created_at AS created_at_9, r0_.type AS type_10, r0_.status AS status_11, r0_.commercial_zone AS commercial_zone_12, r0_.country AS country_13, r0_.verify_by_bd AS verify_by_bd_14, r0_.verify_by_na AS verify_by_na_15, r0_.verify_by_rl AS verify_by_rl_16, r0_.admin_comment AS admin_comment_17, r0_.close AS close_18, r0_.type_profile AS type_profile_19, r0_.reseau AS reseau_20, r0_.groupe AS groupe_21, r0_.imported AS imported_22, r0_.sap_code AS sap_code_23, r0_.activity_id AS activity_id_24, r0_.rachat_matiere_id AS rachat_matiere_id_25, r0_.network_id AS network_id_26, r0_.retailer_group_id AS retailer_group_id_27 FROM retailer r0_ WHERE (((LOWER(CONCAT(r0_.name, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.address, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.zipcode, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.city, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.phone, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.email, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.siret, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.tva_number, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.type, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.commercial_zone, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.country, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.admin_comment, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.type_profile, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.reseau, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.groupe, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.imported, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.sap_code, '')) LIKE '%am%') AND (LOWER(CONCAT(r0_.name, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.address, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.zipcode, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.city, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.phone, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.email, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.siret, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.tva_number, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.type, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.commercial_zone, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.country, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.admin_comment, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.type_profile, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.reseau, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.groupe, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.imported, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.sap_code, '')) LIKE '%env%')) OR (r0_.id IN (SELECT a1_.retailer_id AS sclr_28 FROM address a1_ WHERE LOWER(a1_.street) LIKE LOWER('%am env%') OR LOWER(a1_.street2) LIKE LOWER('%am env%') OR LOWER(a1_.city) LIKE LOWER('%am env%') OR LOWER(a1_.zipcode) LIKE LOWER('%am env%')))) AND r0_.id IN (6233, 6631, 6409, 6447, 6641, 6640, 3546, 84, 107, 116) ORDER BY r0_.name ASC;

SELECT
  count(*) AS sclr_0
FROM
  retailer r0_
WHERE
  (
    (
      LOWER(
        CONCAT(r0_.name, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.address, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.zipcode, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.city, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.phone, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.email, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.siret, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.tva_number, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.type, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.commercial_zone, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.country, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.admin_comment, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.type_profile, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.reseau, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.groupe, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.imported, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.sap_code, '')
      ) LIKE ?
    )
    AND (
      LOWER(
        CONCAT(r0_.name, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.address, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.zipcode, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.city, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.phone, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.email, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.siret, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.tva_number, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.type, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.commercial_zone, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.country, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.admin_comment, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.type_profile, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.reseau, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.groupe, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.imported, '')
      ) LIKE ?
      OR LOWER(
        CONCAT(r0_.sap_code, '')
      ) LIKE ?
    )
  )
  OR (
    r0_.id IN (
      SELECT
        a1_.retailer_id AS sclr_1
      FROM
        address a1_
      WHERE
        LOWER(a1_.street) LIKE LOWER(?)
        OR LOWER(a1_.street2) LIKE LOWER(?)
        OR LOWER(a1_.city) LIKE LOWER(?)
        OR LOWER(a1_.zipcode) LIKE LOWER(?)
    )
  )

SELECT count(*) AS sclr_0 FROM retailer r0_ WHERE ((LOWER(CONCAT(r0_.name, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.address, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.zipcode, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.city, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.phone, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.email, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.siret, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.tva_number, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.type, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.commercial_zone, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.country, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.admin_comment, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.type_profile, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.reseau, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.groupe, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.imported, '')) LIKE '%am%' OR LOWER(CONCAT(r0_.sap_code, '')) LIKE '%am%') AND (LOWER(CONCAT(r0_.name, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.address, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.zipcode, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.city, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.phone, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.email, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.siret, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.tva_number, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.type, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.commercial_zone, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.country, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.admin_comment, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.type_profile, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.reseau, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.groupe, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.imported, '')) LIKE '%env%' OR LOWER(CONCAT(r0_.sap_code, '')) LIKE '%env%')) OR (r0_.id IN (SELECT a1_.retailer_id AS sclr_1 FROM address a1_ WHERE LOWER(a1_.street) LIKE LOWER('%am env%') OR LOWER(a1_.street2) LIKE LOWER('%am env%') OR LOWER(a1_.city) LIKE LOWER('%am env%') OR LOWER(a1_.zipcode) LIKE LOWER('%am env%')));

SELECT
  t0.id AS id_1,
  t0.street AS street_2,
  t0.street2 AS street2_3,
  t0.zipcode AS zipcode_4,
  t0.city AS city_5,
  t0.country AS country_6,
  t0.phone AS phone_7,
  t0.mobile AS mobile_8,
  t0.type AS type_9,
  t0.opening_hours AS opening_hours_10,
  t0.bp AS bp_11,
  t0.imported AS imported_12,
  t0.title AS title_13,
  t0.comment AS comment_14,
  t0.retailer_id AS retailer_id_15
FROM
  address t0
WHERE
  t0.retailer_id = ?

SELECT t0.id AS id_1, t0.street AS street_2, t0.street2 AS street2_3, t0.zipcode AS zipcode_4, t0.city AS city_5, t0.country AS country_6, t0.phone AS phone_7, t0.mobile AS mobile_8, t0.type AS type_9, t0.opening_hours AS opening_hours_10, t0.bp AS bp_11, t0.imported AS imported_12, t0.title AS title_13, t0.comment AS comment_14, t0.retailer_id AS retailer_id_15 FROM address t0 WHERE t0.retailer_id = 6233;

SELECT
  t0.id AS id_1,
  t0.street AS street_2,
  t0.street2 AS street2_3,
  t0.zipcode AS zipcode_4,
  t0.city AS city_5,
  t0.country AS country_6,
  t0.phone AS phone_7,
  t0.mobile AS mobile_8,
  t0.type AS type_9,
  t0.opening_hours AS opening_hours_10,
  t0.bp AS bp_11,
  t0.imported AS imported_12,
  t0.title AS title_13,
  t0.comment AS comment_14,
  t0.retailer_id AS retailer_id_15
FROM
  address t0
WHERE
  t0.retailer_id = ?

SELECT t0.id AS id_1, t0.street AS street_2, t0.street2 AS street2_3, t0.zipcode AS zipcode_4, t0.city AS city_5, t0.country AS country_6, t0.phone AS phone_7, t0.mobile AS mobile_8, t0.type AS type_9, t0.opening_hours AS opening_hours_10, t0.bp AS bp_11, t0.imported AS imported_12, t0.title AS title_13, t0.comment AS comment_14, t0.retailer_id AS retailer_id_15 FROM address t0 WHERE t0.retailer_id = 6631;

SELECT
  t0.id AS id_1,
  t0.street AS street_2,
  t0.street2 AS street2_3,
  t0.zipcode AS zipcode_4,
  t0.city AS city_5,
  t0.country AS country_6,
  t0.phone AS phone_7,
  t0.mobile AS mobile_8,
  t0.type AS type_9,
  t0.opening_hours AS opening_hours_10,
  t0.bp AS bp_11,
  t0.imported AS imported_12,
  t0.title AS title_13,
  t0.comment AS comment_14,
  t0.retailer_id AS retailer_id_15
FROM
  address t0
WHERE
  t0.retailer_id = ?

SELECT t0.id AS id_1, t0.street AS street_2, t0.street2 AS street2_3, t0.zipcode AS zipcode_4, t0.city AS city_5, t0.country AS country_6, t0.phone AS phone_7, t0.mobile AS mobile_8, t0.type AS type_9, t0.opening_hours AS opening_hours_10, t0.bp AS bp_11, t0.imported AS imported_12, t0.title AS title_13, t0.comment AS comment_14, t0.retailer_id AS retailer_id_15 FROM address t0 WHERE t0.retailer_id = 6409;

SELECT
  t0.id AS id_1,
  t0.street AS street_2,
  t0.street2 AS street2_3,
  t0.zipcode AS zipcode_4,
  t0.city AS city_5,
  t0.country AS country_6,
  t0.phone AS phone_7,
  t0.mobile AS mobile_8,
  t0.type AS type_9,
  t0.opening_hours AS opening_hours_10,
  t0.bp AS bp_11,
  t0.imported AS imported_12,
  t0.title AS title_13,
  t0.comment AS comment_14,
  t0.retailer_id AS retailer_id_15
FROM
  address t0
WHERE
  t0.retailer_id = ?

SELECT t0.id AS id_1, t0.street AS street_2, t0.street2 AS street2_3, t0.zipcode AS zipcode_4, t0.city AS city_5, t0.country AS country_6, t0.phone AS phone_7, t0.mobile AS mobile_8, t0.type AS type_9, t0.opening_hours AS opening_hours_10, t0.bp AS bp_11, t0.imported AS imported_12, t0.title AS title_13, t0.comment AS comment_14, t0.retailer_id AS retailer_id_15 FROM address t0 WHERE t0.retailer_id = 6447;