Symfony Profiler

SELECT
  1 as `exists`
FROM
  `product_configurator_setting`
WHERE
  (`id` = ?)
  AND (`version_id` = ?)

SELECT 1 as `exists` FROM `product_configurator_setting` WHERE (`id` = 0x873CB7E6DC9EE7113CE2D6E5A8355B28) AND (`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425);

"COMMIT"

"COMMIT";

UPDATE
  `product_configurator_setting`
SET
  `version_id` = ?,
  `product_id` = ?,
  `product_version_id` = ?,
  `property_group_option_id` = ?,
  `updated_at` = ?
WHERE
  id = ?
  AND version_id = ?

UPDATE `product_configurator_setting` SET `version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425, `product_id` = 0x0000000CB77E7E7E7E7E7E7E7E7E0002, `product_version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425, `property_group_option_id` = 0xBD1DECC396D2CD1E843B06D66D2A1142, `updated_at` = '2026-05-16 03:52:44.663' WHERE id = 0x873CB7E6DC9EE7113CE2D6E5A8355B28 AND version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

UPDATE
  `product` as `product`,
  `product` as parent
SET
  `product`.`unit` = IFNULL(
    `product`.`unit_id`, parent.`unit_id`
  )
WHERE
  `product`.parent_id = parent.id
  AND `product`.parent_id IS NOT NULL
  AND `product`.id IN (?)
  AND `product`.version_id = parent.version_id
  AND `product`.version_id = ?

UPDATE `product` as `product`, `product` as parent
                    SET `product`.`unit` = IFNULL(`product`.`unit_id`, parent.`unit_id`)
                    WHERE `product`.parent_id = parent.id
                    AND `product`.parent_id IS NOT NULL
                    AND `product`.id IN (0x0000000CB77E7E7E7E7E7E7E7E7E0002)AND `product`.version_id = parent.version_id
                         AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

UPDATE
  `product`
SET
  `prices` = IFNULL(
    (
      SELECT
        `product_price`.`product_id`
      FROM
        `product_price`
      WHERE
        `product_price`.`product_id` = `product`.id
        AND `product_price`.`product_version_id` = `product`.version_id
      LIMIT
        1
    ), IFNULL(
      `product`.parent_id, `product`.id
    )
  )
WHERE
  `product`.id IN (?)
  AND `product`.version_id = ?

UPDATE `product` SET `prices` = IFNULL(
                        (
                            SELECT `product_price`.`product_id`
                            FROM   `product_price`
                            WHERE  `product_price`.`product_id`         = `product`.id
                            AND `product_price`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (0x0000000CB77E7E7E7E7E7E7E7E7E0002)
                     AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

UPDATE
  `product`
SET
  `media` = IFNULL(
    (
      SELECT
        `product_media`.`product_id`
      FROM
        `product_media`
      WHERE
        `product_media`.`product_id` = `product`.id
        AND `product_media`.`product_version_id` = `product`.version_id
      LIMIT
        1
    ), IFNULL(
      `product`.parent_id, `product`.id
    )
  )
WHERE
  `product`.id IN (?)
  AND `product`.version_id = ?

UPDATE `product` SET `media` = IFNULL(
                        (
                            SELECT `product_media`.`product_id`
                            FROM   `product_media`
                            WHERE  `product_media`.`product_id`         = `product`.id
                            AND `product_media`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (0x0000000CB77E7E7E7E7E7E7E7E7E0002)
                     AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

SELECT
  1 as `exists`,
  `id`,
  `version_id`
FROM
  `product_configurator_setting`
WHERE
  (
    `id` IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?
    )
  )
  AND (version_id = ?)

SELECT 1 as `exists`, `id`, `version_id` FROM `product_configurator_setting` WHERE (`id` IN (0x873CB7E6DC9EE7113CE2D6E5A8355B28,0x653C5113B0A78D1BFDA553EBC50502F2,0xA1DBB2AE37CC99C36F30C9A54059E05F,0x99296398317CD626DF3C0902B5EB9EDD,0x3110BEAC63C387EE395F4D2E13731BFB,0x5C66346E7CC6DDDDC05F3DC35C8865EC,0xA8CE434CAD1286052E7A4D9A390F691F,0xBAE057CDB40DFC6517EA4047E2CF9749,0x04FD1CE5262FEE18907D882DC48412C6,0xDB7B89A2ACFF4AA6D5A0626E0A3BBF5D,0x7D1F0908AD2B78A96C17313ADBCCE1C9,0x483EEE3086FE4DDBBE5F1B51EB58B8E8,0x2118340FF49A5C8CDBE74487F8E0DC97,0xAFEA7699FE6181850965C2DF71D00898,0x1C80D4DB444043821E28F8028F0CFA0F,0x2BA47FC3E24B599E4BE1A80DBB918DA1,0x5B6B594410938882FFDC0A56F67E4222,0x99434B011694ADAA02ECF285935A2788,0xB162C7B35069F9F73013F12C994C24B6,0xDBC2D189B4F98ABC6171F3B3C08BF6D1)) AND (version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425);

UPDATE
  `product`
SET
  `crossSellings` = IFNULL(
    (
      SELECT
        `product_cross_selling`.`product_id`
      FROM
        `product_cross_selling`
      WHERE
        `product_cross_selling`.`product_id` = `product`.id
        AND `product_cross_selling`.`product_version_id` = `product`.version_id
      LIMIT
        1
    ), IFNULL(
      `product`.parent_id, `product`.id
    )
  )
WHERE
  `product`.id IN (?)
  AND `product`.version_id = ?

UPDATE `product` SET `crossSellings` = IFNULL(
                        (
                            SELECT `product_cross_selling`.`product_id`
                            FROM   `product_cross_selling`
                            WHERE  `product_cross_selling`.`product_id`         = `product`.id
                            AND `product_cross_selling`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (0x0000000CB77E7E7E7E7E7E7E7E7E0002)
                     AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

UPDATE
  `product`
SET
  `categories` = IFNULL(
    (
      SELECT
        `product_category`.`product_id`
      FROM
        `product_category`
      WHERE
        `product_category`.`product_id` = `product`.id
        AND `product_category`.`product_version_id` = `product`.version_id
      LIMIT
        1
    ), IFNULL(
      `product`.parent_id, `product`.id
    )
  )
WHERE
  `product`.id IN (?)
  AND `product`.version_id = ?

UPDATE `product` SET `categories` = IFNULL(
                        (
                            SELECT `product_category`.`product_id`
                            FROM   `product_category`
                            WHERE  `product_category`.`product_id`         = `product`.id
                            AND `product_category`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (0x0000000CB77E7E7E7E7E7E7E7E7E0002)
                     AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

UPDATE
  `product` as `product`,
  `product` as parent
SET
  `product`.`manufacturer` = IFNULL(
    `product`.`product_manufacturer_id`,
    parent.`product_manufacturer_id`
  )
WHERE
  `product`.parent_id = parent.id
  AND `product`.parent_id IS NOT NULL
  AND `product`.id IN (?)
  AND `product`.version_id = parent.version_id
  AND `product`.version_id = ?

UPDATE `product` as `product`, `product` as parent
                    SET `product`.`manufacturer` = IFNULL(`product`.`product_manufacturer_id`, parent.`product_manufacturer_id`)
                    WHERE `product`.parent_id = parent.id
                    AND `product`.parent_id IS NOT NULL
                    AND `product`.id IN (0x0000000CB77E7E7E7E7E7E7E7E7E0002)AND `product`.version_id = parent.version_id
                         AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

UPDATE
  `product`
SET
  `warehouses` = IFNULL(
    (
      SELECT
        `product_warehouse`.`product_id`
      FROM
        `product_warehouse`
      WHERE
        `product_warehouse`.`product_id` = `product`.id
        AND `product_warehouse`.`product_version_id` = `product`.version_id
      LIMIT
        1
    ), IFNULL(
      `product`.parent_id, `product`.id
    )
  )
WHERE
  `product`.id IN (?)
  AND `product`.version_id = ?

UPDATE `product` SET `warehouses` = IFNULL(
                        (
                            SELECT `product_warehouse`.`product_id`
                            FROM   `product_warehouse`
                            WHERE  `product_warehouse`.`product_id`         = `product`.id
                            AND `product_warehouse`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (0x0000000CB77E7E7E7E7E7E7E7E7E0002)
                     AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

UPDATE
  `product`
SET
  `customFieldSets` = IFNULL(
    (
      SELECT
        `product_custom_field_set`.`product_id`
      FROM
        `product_custom_field_set`
      WHERE
        `product_custom_field_set`.`product_id` = `product`.id
        AND `product_custom_field_set`.`product_version_id` = `product`.version_id
      LIMIT
        1
    ), IFNULL(
      `product`.parent_id, `product`.id
    )
  )
WHERE
  `product`.id IN (?)
  AND `product`.version_id = ?

UPDATE `product` SET `customFieldSets` = IFNULL(
                        (
                            SELECT `product_custom_field_set`.`product_id`
                            FROM   `product_custom_field_set`
                            WHERE  `product_custom_field_set`.`product_id`         = `product`.id
                            AND `product_custom_field_set`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (0x0000000CB77E7E7E7E7E7E7E7E7E0002)
                     AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

# dbal-plugin-loader
SELECT
  `name`,
  `base_class` AS baseClass,
  IF(
    `active` = 1
    AND `installed_at` IS NOT NULL,
    1,
    0
  ) AS active,
  `path`,
  `version`,
  `autoload`,
  `managed_by_composer` AS managedByComposer,
  composer_name as composerName
FROM
  `plugin`
ORDER BY
  `installed_at`;

# dbal-plugin-loader
        SELECT
               `name`,
               `base_class` AS baseClass,
               IF(`active` = 1 AND `installed_at` IS NOT NULL, 1, 0) AS active,
               `path`,
               `version`,
               `autoload`,
               `managed_by_composer` AS managedByComposer,
               composer_name as composerName
        FROM `plugin`
        ORDER BY `installed_at`;;

UPDATE
  `product`
SET
  `properties` = IFNULL(
    (
      SELECT
        `product_property`.`product_id`
      FROM
        `product_property`
      WHERE
        `product_property`.`product_id` = `product`.id
        AND `product_property`.`product_version_id` = `product`.version_id
      LIMIT
        1
    ), IFNULL(
      `product`.parent_id, `product`.id
    )
  )
WHERE
  `product`.id IN (?)
  AND `product`.version_id = ?

UPDATE `product` SET `properties` = IFNULL(
                        (
                            SELECT `product_property`.`product_id`
                            FROM   `product_property`
                            WHERE  `product_property`.`product_id`         = `product`.id
                            AND `product_property`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (0x0000000CB77E7E7E7E7E7E7E7E7E0002)
                     AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

UPDATE
  `product`
SET
  `visibilities` = IFNULL(
    (
      SELECT
        `product_visibility`.`product_id`
      FROM
        `product_visibility`
      WHERE
        `product_visibility`.`product_id` = `product`.id
        AND `product_visibility`.`product_version_id` = `product`.version_id
      LIMIT
        1
    ), IFNULL(
      `product`.parent_id, `product`.id
    )
  )
WHERE
  `product`.id IN (?)
  AND `product`.version_id = ?

UPDATE `product` SET `visibilities` = IFNULL(
                        (
                            SELECT `product_visibility`.`product_id`
                            FROM   `product_visibility`
                            WHERE  `product_visibility`.`product_id`         = `product`.id
                            AND `product_visibility`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (0x0000000CB77E7E7E7E7E7E7E7E7E0002)
                     AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

UPDATE
  `product`
SET
  `customPrice` = IFNULL(
    (
      SELECT
        `custom_price`.`product_id`
      FROM
        `custom_price`
      WHERE
        `custom_price`.`product_id` = `product`.id
        AND `custom_price`.`product_version_id` = `product`.version_id
      LIMIT
        1
    ), IFNULL(
      `product`.parent_id, `product`.id
    )
  )
WHERE
  `product`.id IN (?)
  AND `product`.version_id = ?

UPDATE `product` SET `customPrice` = IFNULL(
                        (
                            SELECT `custom_price`.`product_id`
                            FROM   `custom_price`
                            WHERE  `custom_price`.`product_id`         = `product`.id
                            AND `custom_price`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (0x0000000CB77E7E7E7E7E7E7E7E7E0002)
                     AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

UPDATE
  `product`
SET
  `translations` = IFNULL(
    (
      SELECT
        `product_translation`.`product_id`
      FROM
        `product_translation`
      WHERE
        `product_translation`.`product_id` = `product`.id
        AND `product_translation`.`product_version_id` = `product`.version_id
      LIMIT
        1
    ), IFNULL(
      `product`.parent_id, `product`.id
    )
  )
WHERE
  `product`.id IN (?)
  AND `product`.version_id = ?

UPDATE `product` SET `translations` = IFNULL(
                        (
                            SELECT `product_translation`.`product_id`
                            FROM   `product_translation`
                            WHERE  `product_translation`.`product_id`         = `product`.id
                            AND `product_translation`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (0x0000000CB77E7E7E7E7E7E7E7E7E0002)
                     AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

UPDATE
  `product` AS `product`
SET
  `product`.`cover` = `product`.`product_media_id`
WHERE
  `product`.parent_id IS NULL
  AND `product`.id IN (?)
  AND `product`.version_id = ?

UPDATE `product` AS `product`
                    SET `product`.`cover` = `product`.`product_media_id`
                    WHERE `product`.parent_id IS NULL
                    AND `product`.id IN (0x0000000CB77E7E7E7E7E7E7E7E7E0002)AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

UPDATE
  `product` AS `product`
SET
  `product`.`featureSet` = `product`.`product_feature_set_id`
WHERE
  `product`.parent_id IS NULL
  AND `product`.id IN (?)
  AND `product`.version_id = ?

UPDATE `product` AS `product`
                    SET `product`.`featureSet` = `product`.`product_feature_set_id`
                    WHERE `product`.parent_id IS NULL
                    AND `product`.id IN (0x0000000CB77E7E7E7E7E7E7E7E7E0002)AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

UPDATE
  `product`
SET
  `subscriptionPlans` = IFNULL(
    (
      SELECT
        `subscription_plan_product_mapping`.`product_id`
      FROM
        `subscription_plan_product_mapping`
      WHERE
        `subscription_plan_product_mapping`.`product_id` = `product`.id
        AND `subscription_plan_product_mapping`.`product_version_id` = `product`.version_id
      LIMIT
        1
    ), IFNULL(
      `product`.parent_id, `product`.id
    )
  )
WHERE
  `product`.id IN (?)
  AND `product`.version_id = ?

UPDATE `product` SET `subscriptionPlans` = IFNULL(
                        (
                            SELECT `subscription_plan_product_mapping`.`product_id`
                            FROM   `subscription_plan_product_mapping`
                            WHERE  `subscription_plan_product_mapping`.`product_id`         = `product`.id
                            AND `subscription_plan_product_mapping`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (0x0000000CB77E7E7E7E7E7E7E7E7E0002)
                     AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

UPDATE
  `product` AS `product`
SET
  `product`.`manufacturer` = `product`.`product_manufacturer_id`
WHERE
  `product`.parent_id IS NULL
  AND `product`.id IN (?)
  AND `product`.version_id = ?

UPDATE `product` AS `product`
                    SET `product`.`manufacturer` = `product`.`product_manufacturer_id`
                    WHERE `product`.parent_id IS NULL
                    AND `product`.id IN (0x0000000CB77E7E7E7E7E7E7E7E7E0002)AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

UPDATE
  `product`
SET
  `tags` = IFNULL(
    (
      SELECT
        `product_tag`.`product_id`
      FROM
        `product_tag`
      WHERE
        `product_tag`.`product_id` = `product`.id
        AND `product_tag`.`product_version_id` = `product`.version_id
      LIMIT
        1
    ), IFNULL(
      `product`.parent_id, `product`.id
    )
  )
WHERE
  `product`.id IN (?)
  AND `product`.version_id = ?

UPDATE `product` SET `tags` = IFNULL(
                        (
                            SELECT `product_tag`.`product_id`
                            FROM   `product_tag`
                            WHERE  `product_tag`.`product_id`         = `product`.id
                            AND `product_tag`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (0x0000000CB77E7E7E7E7E7E7E7E7E0002)
                     AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;