Symfony Profiler

SELECT
  count(DISTINCT o0_.id) AS sclr_0
FROM
  offer o0_
  LEFT JOIN product_format p1_ ON o0_.format_id = p1_.id
  LEFT JOIN product_packaging p2_ ON o0_.packaging_id = p2_.id
  LEFT JOIN entity e3_ ON o0_.entity_id = e3_.id
  LEFT JOIN offer_favourite o4_ ON (o4_.offer_id = o0_.id)
  LEFT JOIN product p5_ ON o0_.product_id = p5_.id
  LEFT JOIN entity e6_ ON p5_.entity_id = e6_.id
  LEFT JOIN product_vintage p7_ ON p5_.id = p7_.product_id
  AND (
    p7_.product_id = p5_.id
    AND p7_.year = o0_.vintage
  )
WHERE
  (
    (
      (
        e3_.id <> e6_.id
        OR (
          e3_.id = e6_.id
          AND o0_.price <> 0
        )
      )
      OR (
        (
          o0_.price = 0
          AND o0_.qty <> 0
        )
        OR (
          o0_.price = 0
          AND o0_.unoficial_qty <> 0
        )
        OR (
          o0_.price = 0
          AND o0_.unoficial_price <> 0
        )
      )
    )
  )
  AND e3_.ignore_import = ?
  AND p5_.uuid = ?
  AND o0_.vintage = ?
  AND e3_.status = ?
  AND o0_.status = 1
  AND o0_.qty > 0

SELECT count(DISTINCT o0_.id) AS sclr_0 FROM offer o0_ LEFT JOIN product_format p1_ ON o0_.format_id = p1_.id LEFT JOIN product_packaging p2_ ON o0_.packaging_id = p2_.id LEFT JOIN entity e3_ ON o0_.entity_id = e3_.id LEFT JOIN offer_favourite o4_ ON (o4_.offer_id = o0_.id) LEFT JOIN product p5_ ON o0_.product_id = p5_.id LEFT JOIN entity e6_ ON p5_.entity_id = e6_.id LEFT JOIN product_vintage p7_ ON p5_.id = p7_.product_id AND (p7_.product_id = p5_.id AND p7_.year = o0_.vintage) WHERE (((e3_.id <> e6_.id OR (e3_.id = e6_.id AND o0_.price <> 0)) OR ((o0_.price = 0 AND o0_.qty <> 0) OR (o0_.price = 0 AND o0_.unoficial_qty <> 0) OR (o0_.price = 0 AND o0_.unoficial_price <> 0)))) AND e3_.ignore_import = 0 AND p5_.uuid = '82c982bd-7bd5-467f-91d8-63c2c7840d76' AND o0_.vintage = 1989 AND e3_.status = 1 AND o0_.status = 1 AND o0_.qty > 0;

SELECT
  DISTINCT o0_.id AS id_0,
  o0_.last_update AS last_update_1
FROM
  offer o0_
  LEFT JOIN product_format p1_ ON o0_.format_id = p1_.id
  LEFT JOIN product_packaging p2_ ON o0_.packaging_id = p2_.id
  LEFT JOIN entity e3_ ON o0_.entity_id = e3_.id
  LEFT JOIN offer_favourite o4_ ON (o4_.offer_id = o0_.id)
  LEFT JOIN product p5_ ON o0_.product_id = p5_.id
  LEFT JOIN entity e6_ ON p5_.entity_id = e6_.id
  LEFT JOIN product_vintage p7_ ON p5_.id = p7_.product_id
  AND (
    p7_.product_id = p5_.id
    AND p7_.year = o0_.vintage
  )
WHERE
  (
    (
      (
        e3_.id <> e6_.id
        OR (
          e3_.id = e6_.id
          AND o0_.price <> 0
        )
      )
      OR (
        (
          o0_.price = 0
          AND o0_.qty <> 0
        )
        OR (
          o0_.price = 0
          AND o0_.unoficial_qty <> 0
        )
        OR (
          o0_.price = 0
          AND o0_.unoficial_price <> 0
        )
      )
    )
  )
  AND e3_.ignore_import = ?
  AND p5_.uuid = ?
  AND o0_.vintage = ?
  AND e3_.status = ?
  AND o0_.status = 1
  AND o0_.qty > 0
ORDER BY
  CASE WHEN (
    o0_.format_id = 3
    AND o0_.format_filled = 1
  ) THEN
    0
  ELSE
    1
  END ASC,
  CASE WHEN e3_.id = e6_.id THEN
    0
  ELSE
    1
  END ASC,
  CASE WHEN (
    CASE WHEN o0_.price <= COALESCE(o0_.unoficial_price, o0_.price) THEN
      o0_.price
    ELSE
      COALESCE(o0_.unoficial_price, o0_.price)
    END = 0
  ) THEN
    1
  ELSE
    0
  END ASC,
  CASE WHEN o0_.price <= COALESCE(o0_.unoficial_price, o0_.price) THEN
    o0_.price
  ELSE
    COALESCE(o0_.unoficial_price, o0_.price)
  END ASC,
  o0_.last_update DESC
LIMIT
  50

SELECT DISTINCT o0_.id AS id_0, o0_.last_update AS last_update_1 FROM offer o0_ LEFT JOIN product_format p1_ ON o0_.format_id = p1_.id LEFT JOIN product_packaging p2_ ON o0_.packaging_id = p2_.id LEFT JOIN entity e3_ ON o0_.entity_id = e3_.id LEFT JOIN offer_favourite o4_ ON (o4_.offer_id = o0_.id) LEFT JOIN product p5_ ON o0_.product_id = p5_.id LEFT JOIN entity e6_ ON p5_.entity_id = e6_.id LEFT JOIN product_vintage p7_ ON p5_.id = p7_.product_id AND (p7_.product_id = p5_.id AND p7_.year = o0_.vintage) WHERE (((e3_.id <> e6_.id OR (e3_.id = e6_.id AND o0_.price <> 0)) OR ((o0_.price = 0 AND o0_.qty <> 0) OR (o0_.price = 0 AND o0_.unoficial_qty <> 0) OR (o0_.price = 0 AND o0_.unoficial_price <> 0)))) AND e3_.ignore_import = 0 AND p5_.uuid = '82c982bd-7bd5-467f-91d8-63c2c7840d76' AND o0_.vintage = 1989 AND e3_.status = 1 AND o0_.status = 1 AND o0_.qty > 0 ORDER BY CASE WHEN (o0_.format_id = 3 AND o0_.format_filled = 1) THEN 0 ELSE 1 END ASC, CASE WHEN e3_.id = e6_.id THEN 0 ELSE 1 END ASC, CASE WHEN (CASE WHEN o0_.price <= COALESCE(o0_.unoficial_price, o0_.price) THEN o0_.price ELSE COALESCE(o0_.unoficial_price, o0_.price) END = 0) THEN 1 ELSE 0 END ASC, CASE WHEN o0_.price <= COALESCE(o0_.unoficial_price, o0_.price) THEN o0_.price ELSE COALESCE(o0_.unoficial_price, o0_.price) END ASC, o0_.last_update DESC LIMIT 50;

SELECT
  o0_.id AS id_0,
  e1_.id AS id_1,
  CASE WHEN e1_.display_name IS NOT NULL
  AND e1_.display_name <> '' THEN
    e1_.display_name
  ELSE
    e1_.name
  END AS sclr_2,
  CASE WHEN o0_.import_process_id = 1 THEN
    'manual'
  ELSE
    'import'
  END AS sclr_3,
  CASE WHEN o2_.id IS NOT NULL THEN
    1
  ELSE
    0
  END AS sclr_4,
  e1_.code AS code_5,
  o0_.id AS id_6,
  o0_.uuid AS uuid_7,
  o0_.type AS type_8,
  o0_.vintage AS vintage_9,
  o0_.packaging_flat AS packaging_flat_10,
  o0_.packaging_value AS packaging_value_11,
  o0_.is_flat AS is_flat_12,
  o0_.format_filled AS format_filled_13,
  o0_.type AS type_14,
  p3_.uuid AS uuid_15,
  p3_.name AS name_16,
  p3_.display_name AS display_name_17,
  p3_.code AS code_18,
  e4_.id AS id_19,
  o0_.category AS category_20,
  p5_.name AS name_21,
  p5_.code AS code_22,
  p6_.name AS name_23,
  o0_.qty AS qty_24,
  o0_.price AS price_25,
  o0_.last_update AS last_update_26,
  o0_.unoficial_qty AS unoficial_qty_27,
  o0_.unoficial_price AS unoficial_price_28,
  o0_.unoficial_update AS unoficial_update_29,
  o0_.status AS status_30,
  o0_.created_by_name AS created_by_name_31,
  o0_.comment AS comment_32,
  o0_.status AS status_33,
  e1_.provisioning AS provisioning_34,
  p7_.price AS price_35,
  p7_.recommended_price AS recommended_price_36,
  e1_.offer_type AS offer_type_37
FROM
  offer o0_
  LEFT JOIN product_format p5_ ON o0_.format_id = p5_.id
  LEFT JOIN product_packaging p6_ ON o0_.packaging_id = p6_.id
  LEFT JOIN entity e1_ ON o0_.entity_id = e1_.id
  LEFT JOIN offer_favourite o2_ ON (o2_.offer_id = o0_.id)
  LEFT JOIN product p3_ ON o0_.product_id = p3_.id
  LEFT JOIN entity e4_ ON p3_.entity_id = e4_.id
  LEFT JOIN product_vintage p7_ ON p3_.id = p7_.product_id
  AND (
    p7_.product_id = p3_.id
    AND p7_.year = o0_.vintage
  )
WHERE
  (
    (
      (
        e1_.id <> e4_.id
        OR (
          e1_.id = e4_.id
          AND o0_.price <> 0
        )
      )
      OR (
        (
          o0_.price = 0
          AND o0_.qty <> 0
        )
        OR (
          o0_.price = 0
          AND o0_.unoficial_qty <> 0
        )
        OR (
          o0_.price = 0
          AND o0_.unoficial_price <> 0
        )
      )
    )
  )
  AND e1_.ignore_import = ?
  AND p3_.uuid = ?
  AND o0_.vintage = ?
  AND e1_.status = ?
  AND o0_.status = 1
  AND o0_.qty > 0
  AND o0_.id IN (?, ?, ?, ?, ?)
ORDER BY
  CASE WHEN (
    o0_.format_id = 3
    AND o0_.format_filled = 1
  ) THEN
    0
  ELSE
    1
  END ASC,
  CASE WHEN e1_.id = e4_.id THEN
    0
  ELSE
    1
  END ASC,
  CASE WHEN (
    CASE WHEN o0_.price <= COALESCE(o0_.unoficial_price, o0_.price) THEN
      o0_.price
    ELSE
      COALESCE(o0_.unoficial_price, o0_.price)
    END = 0
  ) THEN
    1
  ELSE
    0
  END ASC,
  CASE WHEN o0_.price <= COALESCE(o0_.unoficial_price, o0_.price) THEN
    o0_.price
  ELSE
    COALESCE(o0_.unoficial_price, o0_.price)
  END ASC,
  o0_.last_update DESC

SELECT o0_.id AS id_0, e1_.id AS id_1, CASE WHEN e1_.display_name IS NOT NULL AND e1_.display_name <> '' THEN e1_.display_name ELSE e1_.name END AS sclr_2, CASE WHEN o0_.import_process_id = 1 THEN 'manual' ELSE 'import' END AS sclr_3, CASE WHEN o2_.id IS NOT NULL THEN 1 ELSE 0 END AS sclr_4, e1_.code AS code_5, o0_.id AS id_6, o0_.uuid AS uuid_7, o0_.type AS type_8, o0_.vintage AS vintage_9, o0_.packaging_flat AS packaging_flat_10, o0_.packaging_value AS packaging_value_11, o0_.is_flat AS is_flat_12, o0_.format_filled AS format_filled_13, o0_.type AS type_14, p3_.uuid AS uuid_15, p3_.name AS name_16, p3_.display_name AS display_name_17, p3_.code AS code_18, e4_.id AS id_19, o0_.category AS category_20, p5_.name AS name_21, p5_.code AS code_22, p6_.name AS name_23, o0_.qty AS qty_24, o0_.price AS price_25, o0_.last_update AS last_update_26, o0_.unoficial_qty AS unoficial_qty_27, o0_.unoficial_price AS unoficial_price_28, o0_.unoficial_update AS unoficial_update_29, o0_.status AS status_30, o0_.created_by_name AS created_by_name_31, o0_.comment AS comment_32, o0_.status AS status_33, e1_.provisioning AS provisioning_34, p7_.price AS price_35, p7_.recommended_price AS recommended_price_36, e1_.offer_type AS offer_type_37 FROM offer o0_ LEFT JOIN product_format p5_ ON o0_.format_id = p5_.id LEFT JOIN product_packaging p6_ ON o0_.packaging_id = p6_.id LEFT JOIN entity e1_ ON o0_.entity_id = e1_.id LEFT JOIN offer_favourite o2_ ON (o2_.offer_id = o0_.id) LEFT JOIN product p3_ ON o0_.product_id = p3_.id LEFT JOIN entity e4_ ON p3_.entity_id = e4_.id LEFT JOIN product_vintage p7_ ON p3_.id = p7_.product_id AND (p7_.product_id = p3_.id AND p7_.year = o0_.vintage) WHERE (((e1_.id <> e4_.id OR (e1_.id = e4_.id AND o0_.price <> 0)) OR ((o0_.price = 0 AND o0_.qty <> 0) OR (o0_.price = 0 AND o0_.unoficial_qty <> 0) OR (o0_.price = 0 AND o0_.unoficial_price <> 0)))) AND e1_.ignore_import = 0 AND p3_.uuid = '82c982bd-7bd5-467f-91d8-63c2c7840d76' AND o0_.vintage = 1989 AND e1_.status = 1 AND o0_.status = 1 AND o0_.qty > 0 AND o0_.id IN (254052, 32739, 208261, 237346, 223853) ORDER BY CASE WHEN (o0_.format_id = 3 AND o0_.format_filled = 1) THEN 0 ELSE 1 END ASC, CASE WHEN e1_.id = e4_.id THEN 0 ELSE 1 END ASC, CASE WHEN (CASE WHEN o0_.price <= COALESCE(o0_.unoficial_price, o0_.price) THEN o0_.price ELSE COALESCE(o0_.unoficial_price, o0_.price) END = 0) THEN 1 ELSE 0 END ASC, CASE WHEN o0_.price <= COALESCE(o0_.unoficial_price, o0_.price) THEN o0_.price ELSE COALESCE(o0_.unoficial_price, o0_.price) END ASC, o0_.last_update DESC;

"COMMIT"

"COMMIT";

SELECT
  t0.email AS email_1,
  t0.roles AS roles_2,
  t0.password AS password_3,
  t0.need_password_update AS need_password_update_4,
  t0.tryout AS tryout_5,
  t0.firstname AS firstname_6,
  t0.lastname AS lastname_7,
  t0.phone AS phone_8,
  t0.mobile AS mobile_9,
  t0.image AS image_10,
  t0.theme AS theme_11,
  t0.status AS status_12,
  t0.last_login AS last_login_13,
  t0.last_activity AS last_activity_14,
  t0.note AS note_15,
  t0.acl AS acl_16,
  t0.widgets AS widgets_17,
  t0.preferences AS preferences_18,
  t0.notification AS notification_19,
  t0.id AS id_20,
  t0.uuid AS uuid_21,
  t0.company_id AS company_id_22
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.need_password_update AS need_password_update_4, t0.tryout AS tryout_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.phone AS phone_8, t0.mobile AS mobile_9, t0.image AS image_10, t0.theme AS theme_11, t0.status AS status_12, t0.last_login AS last_login_13, t0.last_activity AS last_activity_14, t0.note AS note_15, t0.acl AS acl_16, t0.widgets AS widgets_17, t0.preferences AS preferences_18, t0.notification AS notification_19, t0.id AS id_20, t0.uuid AS uuid_21, t0.company_id AS company_id_22 FROM user t0 WHERE t0.id = 16;

SELECT
  *
FROM
  offer_history oh
WHERE
  oh.offer_id IN (?, ?, ?, ?, ?)

SELECT * 
            FROM offer_history oh
            WHERE oh.offer_id IN (254052, 32739, 208261, 237346, 223853);

SELECT
  t0.code AS code_1,
  t0.display_name AS display_name_2,
  t0.lwin AS lwin_3,
  t0.site AS site_4,
  t0.seller_price_qty AS seller_price_qty_5,
  t0.price AS price_6,
  t0.merged_uuids AS merged_uuids_7,
  t0.has_lwin_suggests AS has_lwin_suggests_8,
  t0.from_import AS from_import_9,
  t0.bundle AS bundle_10,
  t0.id AS id_11,
  t0.uuid AS uuid_12,
  t0.name AS name_13,
  t0.status AS status_14,
  t0.country_id AS country_id_15,
  t0.region_id AS region_id_16,
  t0.sub_region_id AS sub_region_id_17,
  t0.color_id AS color_id_18,
  t0.type_id AS type_id_19,
  t0.sub_type_id AS sub_type_id_20,
  t0.entity_id AS entity_id_21,
  t0.classification_id AS classification_id_22,
  t0.line_id AS line_id_23,
  t0.producer_id AS producer_id_24
FROM
  product t0
WHERE
  t0.id = ?

SELECT t0.code AS code_1, t0.display_name AS display_name_2, t0.lwin AS lwin_3, t0.site AS site_4, t0.seller_price_qty AS seller_price_qty_5, t0.price AS price_6, t0.merged_uuids AS merged_uuids_7, t0.has_lwin_suggests AS has_lwin_suggests_8, t0.from_import AS from_import_9, t0.bundle AS bundle_10, t0.id AS id_11, t0.uuid AS uuid_12, t0.name AS name_13, t0.status AS status_14, t0.country_id AS country_id_15, t0.region_id AS region_id_16, t0.sub_region_id AS sub_region_id_17, t0.color_id AS color_id_18, t0.type_id AS type_id_19, t0.sub_type_id AS sub_type_id_20, t0.entity_id AS entity_id_21, t0.classification_id AS classification_id_22, t0.line_id AS line_id_23, t0.producer_id AS producer_id_24 FROM product t0 WHERE t0.id = 96;

UPDATE
  user
SET
  last_activity = ?
WHERE
  id = ?

UPDATE user SET last_activity = '2025-07-07 12:45:38' WHERE id = 16;

"START TRANSACTION"

"START TRANSACTION";