Symfony Profiler

SELECT
  s0_.origin_id AS origin_id_0
FROM
  statut_commande_site s0_
WHERE
  s0_.display = 1
  AND s0_.site_id = ?

SELECT s0_.origin_id AS origin_id_0 FROM statut_commande_site s0_ WHERE s0_.display = 1 AND s0_.site_id = 1;

SELECT
  s0_.origin_id AS origin_id_0
FROM
  statut_commande_site s0_
WHERE
  s0_.origin_id = 3
  AND s0_.site_id = ?

SELECT s0_.origin_id AS origin_id_0 FROM statut_commande_site s0_ WHERE s0_.origin_id = 3 AND s0_.site_id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.em AS em_3,
  t0.prefix_database AS prefix_database_4,
  t0.url_site AS url_site_5,
  t0.admin AS admin_6,
  t0.is_package_required AS is_package_required_7,
  t0.type AS type_8,
  t0.api_url AS api_url_9,
  t0.is_cut_machine AS is_cut_machine_10,
  t0.societe_id AS societe_id_11,
  t12.id AS id_13,
  t12.client_account AS client_account_14,
  t12.entry_codes AS entry_codes_15,
  t12.sell_accounts AS sell_accounts_16,
  t12.tax_accounts AS tax_accounts_17,
  t12.transport_accounts AS transport_accounts_18,
  t12.third_party_accounts AS third_party_accounts_19,
  t12.site_id AS site_id_20,
  t12.marketplace_id AS marketplace_id_21
FROM
  site t0
  LEFT JOIN entry_configuration t12 ON t12.site_id = t0.id
WHERE
  t0.societe_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.em AS em_3, t0.prefix_database AS prefix_database_4, t0.url_site AS url_site_5, t0.admin AS admin_6, t0.is_package_required AS is_package_required_7, t0.type AS type_8, t0.api_url AS api_url_9, t0.is_cut_machine AS is_cut_machine_10, t0.societe_id AS societe_id_11, t12.id AS id_13, t12.client_account AS client_account_14, t12.entry_codes AS entry_codes_15, t12.sell_accounts AS sell_accounts_16, t12.tax_accounts AS tax_accounts_17, t12.transport_accounts AS transport_accounts_18, t12.third_party_accounts AS third_party_accounts_19, t12.site_id AS site_id_20, t12.marketplace_id AS marketplace_id_21 FROM site t0 LEFT JOIN entry_configuration t12 ON t12.site_id = t0.id WHERE t0.societe_id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.adresse1 AS adresse1_3,
  t0.adresse2 AS adresse2_4,
  t0.code_postal AS code_postal_5,
  t0.ville AS ville_6,
  t0.pays AS pays_7,
  t0.fn AS fn_8,
  t0.ln AS ln_9,
  t0.mail AS mail_10,
  t0.tel AS tel_11,
  t0.email_litige AS email_litige_12,
  t0.compte_tnt AS compte_tnt_13,
  t0.siret AS siret_14,
  t0.invoice_mail AS invoice_mail_15,
  t0.supplier_order_mail AS supplier_order_mail_16
FROM
  societe t0
  INNER JOIN user_societe ON t0.id = user_societe.societe_id
WHERE
  user_societe.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.adresse1 AS adresse1_3, t0.adresse2 AS adresse2_4, t0.code_postal AS code_postal_5, t0.ville AS ville_6, t0.pays AS pays_7, t0.fn AS fn_8, t0.ln AS ln_9, t0.mail AS mail_10, t0.tel AS tel_11, t0.email_litige AS email_litige_12, t0.compte_tnt AS compte_tnt_13, t0.siret AS siret_14, t0.invoice_mail AS invoice_mail_15, t0.supplier_order_mail AS supplier_order_mail_16 FROM societe t0 INNER JOIN user_societe ON t0.id = user_societe.societe_id WHERE user_societe.user_id = 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.notification_allowed AS notification_allowed_6,
  t0.receive_mail AS receive_mail_7,
  t0.changelog_read AS changelog_read_8,
  t0.slack_id AS slack_id_9,
  t0.default_societe_id AS default_societe_id_10
FROM
  `user` t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.notification_allowed AS notification_allowed_6, t0.receive_mail AS receive_mail_7, t0.changelog_read AS changelog_read_8, t0.slack_id AS slack_id_9, t0.default_societe_id AS default_societe_id_10 FROM `user` t0 WHERE t0.email = 'robin@agence-colibri.com' LIMIT 1;

SELECT
  od.id_order,
  od.product_id,
  IFNULL(od.product_attribute_id, 0) as product_attribute_id,
  od.product_reference,
  od.product_quantity,
  od.product_name as full_name,
  o.reference,
  o.date_upd,
  p.cache_is_pack,
  s.name as fournisseur,
  pl.name,
  p.active,
  sa.reserved_quantity,
  sa.quantity,
  osl.name as state,
  (
    SELECT
      GROUP_CONCAT(DISTINCT al.name SEPARATOR ' | ') as attribute_name
    FROM
      cp_attribute_lang al
      LEFT JOIN cp_product_attribute pa ON p.id_product = pa.id_product
      LEFT JOIN cp_product_attribute_combination pac ON (
        pac.id_product_attribute = od.product_attribute_id
      )
      LEFT JOIN cp_attribute a ON pac.id_attribute = a.id_attribute
    WHERE
      al.id_attribute = a.id_attribute
      AND al.id_lang = 1
  ) as attribute_name,
  DATE_FORMAT(o.date_upd, '%H:%i:%s') as time
FROM
  cp_order_detail od
  LEFT JOIN cp_orders o ON od.id_order = o.id_order
  LEFT JOIN cp_order_state_lang osl ON o.current_state = osl.id_order_state
  LEFT JOIN cp_product p ON od.product_id = p.id_product
  LEFT JOIN cp_product_lang pl ON p.id_product = pl.id_product
  LEFT JOIN cp_stock_available sa ON (
    od.product_attribute_id = sa.id_product_attribute
    AND p.id_product = sa.id_product
  )
  LEFT JOIN cp_supplier s ON p.id_supplier = s.id_supplier
WHERE
  o.current_state IN (3, 3)
  AND sa.reserved_quantity > 0
GROUP BY
  od.id_order,
  od.product_id,
  od.product_attribute_id
ORDER by
  o.id_order ASC

SELECT
            od.id_order,
            od.product_id,
            IFNULL(od.product_attribute_id, 0) as product_attribute_id,
            od.product_reference,
            od.product_quantity,
            od.product_name as full_name,
            o.reference,
            o.date_upd,
            p.cache_is_pack,
            s.name as fournisseur,
            pl.name,
            p.active,
            sa.reserved_quantity,
            sa.quantity,
            osl.name as state,
            (
                SELECT  GROUP_CONCAT(DISTINCT al.name SEPARATOR  ' | ') as attribute_name
                FROM cp_attribute_lang al
                LEFT JOIN cp_product_attribute pa ON p.id_product = pa.id_product
                LEFT JOIN cp_product_attribute_combination pac ON (pac.id_product_attribute = od.product_attribute_id)
                LEFT JOIN cp_attribute a ON pac.id_attribute = a.id_attribute
                WHERE al.id_attribute = a.id_attribute
                AND al.id_lang = 1
            ) as attribute_name,
            DATE_FORMAT(o.date_upd, '%H:%i:%s') as time
            FROM cp_order_detail od
            LEFT JOIN cp_orders o ON od.id_order = o.id_order
            LEFT JOIN cp_order_state_lang osl ON o.current_state = osl.id_order_state
            LEFT JOIN cp_product p ON od.product_id = p.id_product
            LEFT JOIN cp_product_lang pl ON p.id_product = pl.id_product
            LEFT JOIN cp_stock_available sa ON (od.product_attribute_id = sa.id_product_attribute AND p.id_product = sa.id_product)
            LEFT JOIN cp_supplier s ON p.id_supplier = s.id_supplier
            WHERE o.current_state IN (3,3) AND sa.reserved_quantity > 0 GROUP BY od.id_order, od.product_id, od.product_attribute_id  ORDER by o.id_order ASC;

SELECT
  od.id_order,
  od.product_id,
  IFNULL(od.product_attribute_id, 0) as product_attribute_id,
  od.product_reference,
  od.product_quantity,
  od.product_name as full_name,
  o.reference,
  o.date_upd,
  p.cache_is_pack,
  s.name as fournisseur,
  pl.name,
  p.active,
  sa.reserved_quantity,
  sa.quantity,
  osl.name as state,
  (
    SELECT
      GROUP_CONCAT(DISTINCT al.name SEPARATOR ' | ') as attribute_name
    FROM
      sg2_attribute_lang al
      LEFT JOIN sg2_product_attribute pa ON p.id_product = pa.id_product
      LEFT JOIN sg2_product_attribute_combination pac ON (
        pac.id_product_attribute = od.product_attribute_id
      )
      LEFT JOIN sg2_attribute a ON pac.id_attribute = a.id_attribute
    WHERE
      al.id_attribute = a.id_attribute
      AND al.id_lang = 1
  ) as attribute_name,
  DATE_FORMAT(o.date_upd, '%H:%i:%s') as time
FROM
  sg2_order_detail od
  LEFT JOIN sg2_orders o ON od.id_order = o.id_order
  LEFT JOIN sg2_order_state_lang osl ON o.current_state = osl.id_order_state
  LEFT JOIN sg2_product p ON od.product_id = p.id_product
  LEFT JOIN sg2_product_lang pl ON p.id_product = pl.id_product
  LEFT JOIN sg2_stock_available sa ON (
    od.product_attribute_id = sa.id_product_attribute
    AND p.id_product = sa.id_product
  )
  LEFT JOIN sg2_supplier s ON p.id_supplier = s.id_supplier
WHERE
  o.current_state IN (3)
  AND sa.reserved_quantity > 0
GROUP BY
  od.id_order,
  od.product_id,
  od.product_attribute_id
ORDER by
  o.id_order ASC

SELECT
            od.id_order,
            od.product_id,
            IFNULL(od.product_attribute_id, 0) as product_attribute_id,
            od.product_reference,
            od.product_quantity,
            od.product_name as full_name,
            o.reference,
            o.date_upd,
            p.cache_is_pack,
            s.name as fournisseur,
            pl.name,
            p.active,
            sa.reserved_quantity,
            sa.quantity,
            osl.name as state,
            (
                SELECT  GROUP_CONCAT(DISTINCT al.name SEPARATOR  ' | ') as attribute_name
                FROM sg2_attribute_lang al
                LEFT JOIN sg2_product_attribute pa ON p.id_product = pa.id_product
                LEFT JOIN sg2_product_attribute_combination pac ON (pac.id_product_attribute = od.product_attribute_id)
                LEFT JOIN sg2_attribute a ON pac.id_attribute = a.id_attribute
                WHERE al.id_attribute = a.id_attribute
                AND al.id_lang = 1
            ) as attribute_name,
            DATE_FORMAT(o.date_upd, '%H:%i:%s') as time
            FROM sg2_order_detail od
            LEFT JOIN sg2_orders o ON od.id_order = o.id_order
            LEFT JOIN sg2_order_state_lang osl ON o.current_state = osl.id_order_state
            LEFT JOIN sg2_product p ON od.product_id = p.id_product
            LEFT JOIN sg2_product_lang pl ON p.id_product = pl.id_product
            LEFT JOIN sg2_stock_available sa ON (od.product_attribute_id = sa.id_product_attribute AND p.id_product = sa.id_product)
            LEFT JOIN sg2_supplier s ON p.id_supplier = s.id_supplier
            WHERE o.current_state IN (3) AND sa.reserved_quantity > 0 GROUP BY od.id_order, od.product_id, od.product_attribute_id  ORDER by o.id_order ASC;

SELECT
  od.id_order,
  od.product_id,
  IFNULL(od.product_attribute_id, 0) as product_attribute_id,
  od.product_reference,
  od.product_quantity,
  od.product_name as full_name,
  o.reference,
  o.date_upd,
  p.cache_is_pack,
  s.name as fournisseur,
  pl.name,
  p.active,
  sa.reserved_quantity,
  sa.quantity,
  osl.name as state,
  (
    SELECT
      GROUP_CONCAT(DISTINCT al.name SEPARATOR ' | ') as attribute_name
    FROM
      ps_attribute_lang al
      LEFT JOIN ps_product_attribute pa ON p.id_product = pa.id_product
      LEFT JOIN ps_product_attribute_combination pac ON (
        pac.id_product_attribute = od.product_attribute_id
      )
      LEFT JOIN ps_attribute a ON pac.id_attribute = a.id_attribute
    WHERE
      al.id_attribute = a.id_attribute
      AND al.id_lang = 1
  ) as attribute_name,
  DATE_FORMAT(o.date_upd, '%H:%i:%s') as time
FROM
  ps_order_detail od
  LEFT JOIN ps_orders o ON od.id_order = o.id_order
  LEFT JOIN ps_order_state_lang osl ON o.current_state = osl.id_order_state
  LEFT JOIN ps_product p ON od.product_id = p.id_product
  LEFT JOIN ps_product_lang pl ON p.id_product = pl.id_product
  LEFT JOIN ps_stock_available sa ON (
    od.product_attribute_id = sa.id_product_attribute
    AND p.id_product = sa.id_product
  )
  LEFT JOIN ps_supplier s ON p.id_supplier = s.id_supplier
WHERE
  o.current_state IN (3)
  AND sa.reserved_quantity > 0
GROUP BY
  od.id_order,
  od.product_id,
  od.product_attribute_id
ORDER by
  o.id_order ASC

SELECT
            od.id_order,
            od.product_id,
            IFNULL(od.product_attribute_id, 0) as product_attribute_id,
            od.product_reference,
            od.product_quantity,
            od.product_name as full_name,
            o.reference,
            o.date_upd,
            p.cache_is_pack,
            s.name as fournisseur,
            pl.name,
            p.active,
            sa.reserved_quantity,
            sa.quantity,
            osl.name as state,
            (
                SELECT  GROUP_CONCAT(DISTINCT al.name SEPARATOR  ' | ') as attribute_name
                FROM ps_attribute_lang al
                LEFT JOIN ps_product_attribute pa ON p.id_product = pa.id_product
                LEFT JOIN ps_product_attribute_combination pac ON (pac.id_product_attribute = od.product_attribute_id)
                LEFT JOIN ps_attribute a ON pac.id_attribute = a.id_attribute
                WHERE al.id_attribute = a.id_attribute
                AND al.id_lang = 1
            ) as attribute_name,
            DATE_FORMAT(o.date_upd, '%H:%i:%s') as time
            FROM ps_order_detail od
            LEFT JOIN ps_orders o ON od.id_order = o.id_order
            LEFT JOIN ps_order_state_lang osl ON o.current_state = osl.id_order_state
            LEFT JOIN ps_product p ON od.product_id = p.id_product
            LEFT JOIN ps_product_lang pl ON p.id_product = pl.id_product
            LEFT JOIN ps_stock_available sa ON (od.product_attribute_id = sa.id_product_attribute AND p.id_product = sa.id_product)
            LEFT JOIN ps_supplier s ON p.id_supplier = s.id_supplier
            WHERE o.current_state IN (3) AND sa.reserved_quantity > 0 GROUP BY od.id_order, od.product_id, od.product_attribute_id  ORDER by o.id_order ASC;

SELECT
  od.id_order,
  od.product_id,
  IFNULL(od.product_attribute_id, 0) as product_attribute_id,
  od.product_reference,
  od.product_quantity,
  od.product_name as full_name,
  o.reference,
  o.date_upd,
  p.cache_is_pack,
  s.name as fournisseur,
  pl.name,
  p.active,
  sa.reserved_quantity,
  sa.quantity,
  osl.name as state,
  (
    SELECT
      GROUP_CONCAT(DISTINCT al.name SEPARATOR ' | ') as attribute_name
    FROM
      mod273_attribute_lang al
      LEFT JOIN mod273_product_attribute pa ON p.id_product = pa.id_product
      LEFT JOIN mod273_product_attribute_combination pac ON (
        pac.id_product_attribute = od.product_attribute_id
      )
      LEFT JOIN mod273_attribute a ON pac.id_attribute = a.id_attribute
    WHERE
      al.id_attribute = a.id_attribute
      AND al.id_lang = 1
  ) as attribute_name,
  DATE_FORMAT(o.date_upd, '%H:%i:%s') as time
FROM
  mod273_order_detail od
  LEFT JOIN mod273_orders o ON od.id_order = o.id_order
  LEFT JOIN mod273_order_state_lang osl ON o.current_state = osl.id_order_state
  LEFT JOIN mod273_product p ON od.product_id = p.id_product
  LEFT JOIN mod273_product_lang pl ON p.id_product = pl.id_product
  LEFT JOIN mod273_stock_available sa ON (
    od.product_attribute_id = sa.id_product_attribute
    AND p.id_product = sa.id_product
  )
  LEFT JOIN mod273_supplier s ON p.id_supplier = s.id_supplier
WHERE
  o.current_state IN (3)
  AND sa.reserved_quantity > 0
GROUP BY
  od.id_order,
  od.product_id,
  od.product_attribute_id
ORDER by
  o.id_order ASC

SELECT
            od.id_order,
            od.product_id,
            IFNULL(od.product_attribute_id, 0) as product_attribute_id,
            od.product_reference,
            od.product_quantity,
            od.product_name as full_name,
            o.reference,
            o.date_upd,
            p.cache_is_pack,
            s.name as fournisseur,
            pl.name,
            p.active,
            sa.reserved_quantity,
            sa.quantity,
            osl.name as state,
            (
                SELECT  GROUP_CONCAT(DISTINCT al.name SEPARATOR  ' | ') as attribute_name
                FROM mod273_attribute_lang al
                LEFT JOIN mod273_product_attribute pa ON p.id_product = pa.id_product
                LEFT JOIN mod273_product_attribute_combination pac ON (pac.id_product_attribute = od.product_attribute_id)
                LEFT JOIN mod273_attribute a ON pac.id_attribute = a.id_attribute
                WHERE al.id_attribute = a.id_attribute
                AND al.id_lang = 1
            ) as attribute_name,
            DATE_FORMAT(o.date_upd, '%H:%i:%s') as time
            FROM mod273_order_detail od
            LEFT JOIN mod273_orders o ON od.id_order = o.id_order
            LEFT JOIN mod273_order_state_lang osl ON o.current_state = osl.id_order_state
            LEFT JOIN mod273_product p ON od.product_id = p.id_product
            LEFT JOIN mod273_product_lang pl ON p.id_product = pl.id_product
            LEFT JOIN mod273_stock_available sa ON (od.product_attribute_id = sa.id_product_attribute AND p.id_product = sa.id_product)
            LEFT JOIN mod273_supplier s ON p.id_supplier = s.id_supplier
            WHERE o.current_state IN (3) AND sa.reserved_quantity > 0 GROUP BY od.id_order, od.product_id, od.product_attribute_id  ORDER by o.id_order ASC;

SELECT
  od.id_order,
  od.product_id,
  IFNULL(od.product_attribute_id, 0) as product_attribute_id,
  od.product_reference,
  od.product_quantity,
  od.product_name as full_name,
  o.reference,
  o.date_upd,
  p.cache_is_pack,
  s.name as fournisseur,
  pl.name,
  p.active,
  sa.reserved_quantity,
  sa.quantity,
  osl.name as state,
  (
    SELECT
      GROUP_CONCAT(DISTINCT al.name SEPARATOR ' | ') as attribute_name
    FROM
      mod658_attribute_lang al
      LEFT JOIN mod658_product_attribute pa ON p.id_product = pa.id_product
      LEFT JOIN mod658_product_attribute_combination pac ON (
        pac.id_product_attribute = od.product_attribute_id
      )
      LEFT JOIN mod658_attribute a ON pac.id_attribute = a.id_attribute
    WHERE
      al.id_attribute = a.id_attribute
      AND al.id_lang = 1
  ) as attribute_name,
  DATE_FORMAT(o.date_upd, '%H:%i:%s') as time
FROM
  mod658_order_detail od
  LEFT JOIN mod658_orders o ON od.id_order = o.id_order
  LEFT JOIN mod658_order_state_lang osl ON o.current_state = osl.id_order_state
  LEFT JOIN mod658_product p ON od.product_id = p.id_product
  LEFT JOIN mod658_product_lang pl ON p.id_product = pl.id_product
  LEFT JOIN mod658_stock_available sa ON (
    od.product_attribute_id = sa.id_product_attribute
    AND p.id_product = sa.id_product
  )
  LEFT JOIN mod658_supplier s ON p.id_supplier = s.id_supplier
WHERE
  o.current_state IN (3)
  AND sa.reserved_quantity > 0
GROUP BY
  od.id_order,
  od.product_id,
  od.product_attribute_id
ORDER by
  o.id_order ASC

SELECT
            od.id_order,
            od.product_id,
            IFNULL(od.product_attribute_id, 0) as product_attribute_id,
            od.product_reference,
            od.product_quantity,
            od.product_name as full_name,
            o.reference,
            o.date_upd,
            p.cache_is_pack,
            s.name as fournisseur,
            pl.name,
            p.active,
            sa.reserved_quantity,
            sa.quantity,
            osl.name as state,
            (
                SELECT  GROUP_CONCAT(DISTINCT al.name SEPARATOR  ' | ') as attribute_name
                FROM mod658_attribute_lang al
                LEFT JOIN mod658_product_attribute pa ON p.id_product = pa.id_product
                LEFT JOIN mod658_product_attribute_combination pac ON (pac.id_product_attribute = od.product_attribute_id)
                LEFT JOIN mod658_attribute a ON pac.id_attribute = a.id_attribute
                WHERE al.id_attribute = a.id_attribute
                AND al.id_lang = 1
            ) as attribute_name,
            DATE_FORMAT(o.date_upd, '%H:%i:%s') as time
            FROM mod658_order_detail od
            LEFT JOIN mod658_orders o ON od.id_order = o.id_order
            LEFT JOIN mod658_order_state_lang osl ON o.current_state = osl.id_order_state
            LEFT JOIN mod658_product p ON od.product_id = p.id_product
            LEFT JOIN mod658_product_lang pl ON p.id_product = pl.id_product
            LEFT JOIN mod658_stock_available sa ON (od.product_attribute_id = sa.id_product_attribute AND p.id_product = sa.id_product)
            LEFT JOIN mod658_supplier s ON p.id_supplier = s.id_supplier
            WHERE o.current_state IN (3) AND sa.reserved_quantity > 0 GROUP BY od.id_order, od.product_id, od.product_attribute_id  ORDER by o.id_order ASC;

SELECT
  od.id_order,
  od.product_id,
  IFNULL(od.product_attribute_id, 0) as product_attribute_id,
  od.product_reference,
  od.product_quantity,
  od.product_name as full_name,
  o.reference,
  o.date_upd,
  p.cache_is_pack,
  s.name as fournisseur,
  pl.name,
  p.active,
  sa.reserved_quantity,
  sa.quantity,
  osl.name as state,
  (
    SELECT
      GROUP_CONCAT(DISTINCT al.name SEPARATOR ' | ') as attribute_name
    FROM
      ps_attribute_lang al
      LEFT JOIN ps_product_attribute pa ON p.id_product = pa.id_product
      LEFT JOIN ps_product_attribute_combination pac ON (
        pac.id_product_attribute = od.product_attribute_id
      )
      LEFT JOIN ps_attribute a ON pac.id_attribute = a.id_attribute
    WHERE
      al.id_attribute = a.id_attribute
      AND al.id_lang = 1
  ) as attribute_name,
  DATE_FORMAT(o.date_upd, '%H:%i:%s') as time
FROM
  ps_order_detail od
  LEFT JOIN ps_orders o ON od.id_order = o.id_order
  LEFT JOIN ps_order_state_lang osl ON o.current_state = osl.id_order_state
  LEFT JOIN ps_product p ON od.product_id = p.id_product
  LEFT JOIN ps_product_lang pl ON p.id_product = pl.id_product
  LEFT JOIN ps_stock_available sa ON (
    od.product_attribute_id = sa.id_product_attribute
    AND p.id_product = sa.id_product
  )
  LEFT JOIN ps_supplier s ON p.id_supplier = s.id_supplier
WHERE
  o.current_state IN (3)
  AND sa.reserved_quantity > 0
GROUP BY
  od.id_order,
  od.product_id,
  od.product_attribute_id
ORDER by
  o.id_order ASC

SELECT
            od.id_order,
            od.product_id,
            IFNULL(od.product_attribute_id, 0) as product_attribute_id,
            od.product_reference,
            od.product_quantity,
            od.product_name as full_name,
            o.reference,
            o.date_upd,
            p.cache_is_pack,
            s.name as fournisseur,
            pl.name,
            p.active,
            sa.reserved_quantity,
            sa.quantity,
            osl.name as state,
            (
                SELECT  GROUP_CONCAT(DISTINCT al.name SEPARATOR  ' | ') as attribute_name
                FROM ps_attribute_lang al
                LEFT JOIN ps_product_attribute pa ON p.id_product = pa.id_product
                LEFT JOIN ps_product_attribute_combination pac ON (pac.id_product_attribute = od.product_attribute_id)
                LEFT JOIN ps_attribute a ON pac.id_attribute = a.id_attribute
                WHERE al.id_attribute = a.id_attribute
                AND al.id_lang = 1
            ) as attribute_name,
            DATE_FORMAT(o.date_upd, '%H:%i:%s') as time
            FROM ps_order_detail od
            LEFT JOIN ps_orders o ON od.id_order = o.id_order
            LEFT JOIN ps_order_state_lang osl ON o.current_state = osl.id_order_state
            LEFT JOIN ps_product p ON od.product_id = p.id_product
            LEFT JOIN ps_product_lang pl ON p.id_product = pl.id_product
            LEFT JOIN ps_stock_available sa ON (od.product_attribute_id = sa.id_product_attribute AND p.id_product = sa.id_product)
            LEFT JOIN ps_supplier s ON p.id_supplier = s.id_supplier
            WHERE o.current_state IN (3) AND sa.reserved_quantity > 0 GROUP BY od.id_order, od.product_id, od.product_attribute_id  ORDER by o.id_order ASC;

SELECT
  od.id_order,
  od.product_id,
  IFNULL(od.product_attribute_id, 0) as product_attribute_id,
  od.product_reference,
  od.product_quantity,
  od.product_name as full_name,
  o.reference,
  o.date_upd,
  p.cache_is_pack,
  s.name as fournisseur,
  pl.name,
  p.active,
  sa.reserved_quantity,
  sa.quantity,
  osl.name as state,
  (
    SELECT
      GROUP_CONCAT(DISTINCT al.name SEPARATOR ' | ') as attribute_name
    FROM
      ps_attribute_lang al
      LEFT JOIN ps_product_attribute pa ON p.id_product = pa.id_product
      LEFT JOIN ps_product_attribute_combination pac ON (
        pac.id_product_attribute = od.product_attribute_id
      )
      LEFT JOIN ps_attribute a ON pac.id_attribute = a.id_attribute
    WHERE
      al.id_attribute = a.id_attribute
      AND al.id_lang = 1
  ) as attribute_name,
  DATE_FORMAT(o.date_upd, '%H:%i:%s') as time
FROM
  ps_order_detail od
  LEFT JOIN ps_orders o ON od.id_order = o.id_order
  LEFT JOIN ps_order_state_lang osl ON o.current_state = osl.id_order_state
  LEFT JOIN ps_product p ON od.product_id = p.id_product
  LEFT JOIN ps_product_lang pl ON p.id_product = pl.id_product
  LEFT JOIN ps_stock_available sa ON (
    od.product_attribute_id = sa.id_product_attribute
    AND p.id_product = sa.id_product
  )
  LEFT JOIN ps_supplier s ON p.id_supplier = s.id_supplier
WHERE
  o.current_state IN (3)
  AND sa.reserved_quantity > 0
GROUP BY
  od.id_order,
  od.product_id,
  od.product_attribute_id
ORDER by
  o.id_order ASC

SELECT
            od.id_order,
            od.product_id,
            IFNULL(od.product_attribute_id, 0) as product_attribute_id,
            od.product_reference,
            od.product_quantity,
            od.product_name as full_name,
            o.reference,
            o.date_upd,
            p.cache_is_pack,
            s.name as fournisseur,
            pl.name,
            p.active,
            sa.reserved_quantity,
            sa.quantity,
            osl.name as state,
            (
                SELECT  GROUP_CONCAT(DISTINCT al.name SEPARATOR  ' | ') as attribute_name
                FROM ps_attribute_lang al
                LEFT JOIN ps_product_attribute pa ON p.id_product = pa.id_product
                LEFT JOIN ps_product_attribute_combination pac ON (pac.id_product_attribute = od.product_attribute_id)
                LEFT JOIN ps_attribute a ON pac.id_attribute = a.id_attribute
                WHERE al.id_attribute = a.id_attribute
                AND al.id_lang = 1
            ) as attribute_name,
            DATE_FORMAT(o.date_upd, '%H:%i:%s') as time
            FROM ps_order_detail od
            LEFT JOIN ps_orders o ON od.id_order = o.id_order
            LEFT JOIN ps_order_state_lang osl ON o.current_state = osl.id_order_state
            LEFT JOIN ps_product p ON od.product_id = p.id_product
            LEFT JOIN ps_product_lang pl ON p.id_product = pl.id_product
            LEFT JOIN ps_stock_available sa ON (od.product_attribute_id = sa.id_product_attribute AND p.id_product = sa.id_product)
            LEFT JOIN ps_supplier s ON p.id_supplier = s.id_supplier
            WHERE o.current_state IN (3) AND sa.reserved_quantity > 0 GROUP BY od.id_order, od.product_id, od.product_attribute_id  ORDER by o.id_order ASC;