Symfony Profiler

# 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`;;

SELECT
  `key`,
  `value`
FROM
  `app_config`

SELECT `key`, `value` FROM `app_config`;

SELECT
  custom_entity.name,
  custom_entity.fields,
  custom_entity.flags
FROM
  custom_entity
  LEFT JOIN app ON app.id = custom_entity.app_id
WHERE
  (
    custom_entity.app_id IS NULL
    OR app.active = 1
  )
  AND custom_entity.deleted_at IS NULL;

SELECT custom_entity.name, custom_entity.fields, custom_entity.flags
                FROM custom_entity
                    LEFT JOIN app ON app.id = custom_entity.app_id
                WHERE (custom_entity.app_id IS NULL OR app.active = 1) AND custom_entity.deleted_at IS NULL;
            ;

SELECT
  item_rounding
FROM
  currency
WHERE
  id = ?

SELECT item_rounding FROM currency WHERE id = 0xB7D2554B0CE847CD82F3AC9BD1C0DFCA;

SELECT
  id
FROM
  integration
WHERE
  access_key = ?

SELECT id FROM integration WHERE access_key = 'SWIAAVYYDXPOT09WCLDDBZFNQW';

SELECT
  `acl_role`.`privileges`
FROM
  `acl_role`
  INNER JOIN `app` ON `app`.`acl_role_id` = `acl_role`.`id`
WHERE
  `app`.`integration_id` = ?

SELECT `acl_role`.`privileges`
            FROM `acl_role`
            INNER JOIN `app` ON `app`.`acl_role_id` = `acl_role`.`id`
            WHERE `app`.`integration_id` = 0x019BDBDBFF687DD18D259AB3D06F57CC
        ;

SELECT
  admin
FROM
  `integration`
WHERE
  id = ?

SELECT admin FROM `integration` WHERE id = 0x019BDBDBFF687DD18D259AB3D06F57CC;

SELECT
  role.privileges
FROM
  integration_role mapping
  INNER JOIN acl_role role ON mapping.acl_role_id = role.id
WHERE
  mapping.integration_id = ?

SELECT role.privileges FROM integration_role mapping INNER JOIN acl_role role ON mapping.acl_role_id = role.id WHERE mapping.integration_id = 0x019BDBDBFF687DD18D259AB3D06F57CC;

SELECT
  `media`.`id` as `media.id`,
  `media`.`user_id` as `media.userId`,
  `media`.`media_folder_id` as `media.mediaFolderId`,
  `media`.`mime_type` as `media.mimeType`,
  `media`.`file_extension` as `media.fileExtension`,
  `media`.`uploaded_at` as `media.uploadedAt`,
  `media`.`file_name` as `media.fileName`,
  `media`.`file_size` as `media.fileSize`,
  `media`.`media_type` as `media.mediaTypeRaw`,
  `media`.`meta_data` as `media.metaData`,
  `media`.`config` as `media.config`,
  `media`.`path` as `media.path`,
  `media`.`private` as `media.private`,
  `media`.`thumbnails_ro` as `media.thumbnailsRo`,
  `media`.`file_hash` as `media.fileHash`,
  `media`.`created_at` as `media.createdAt`,
  `media`.`updated_at` as `media.updatedAt`,
  `media.mediaFolder`.`id` as `media.mediaFolder.id`,
  `media.mediaFolder`.`use_parent_configuration` as `media.mediaFolder.useParentConfiguration`,
  `media.mediaFolder`.`media_folder_configuration_id` as `media.mediaFolder.configurationId`,
  `media.mediaFolder`.`default_folder_id` as `media.mediaFolder.defaultFolderId`,
  `media.mediaFolder`.`parent_id` as `media.mediaFolder.parentId`,
  `media.mediaFolder`.`child_count` as `media.mediaFolder.childCount`,
  `media.mediaFolder`.`path` as `media.mediaFolder.path`,
  `media.mediaFolder`.`name` as `media.mediaFolder.name`,
  `media.mediaFolder`.`custom_fields` as `media.mediaFolder.customFields`,
  `media.mediaFolder`.`created_at` as `media.mediaFolder.createdAt`,
  `media.mediaFolder`.`updated_at` as `media.mediaFolder.updatedAt`,
  `media.translation.title`,
  `media.translation.title` as `media.title`,
  `media.translation.alt`,
  `media.translation.alt` as `media.alt`,
  `media.translation.customFields`,
  `media.translation.customFields` as `media.customFields`
FROM
  `media`
  LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id`
  LEFT JOIN (
    SELECT
      `media.translation`.`media_id`,
      `media.translation`.`alt` as `media.translation.alt`,
      `media.translation`.`title` as `media.translation.title`,
      `media.translation`.`custom_fields` as `media.translation.customFields`
    FROM
      `media_translation` `media.translation`
    WHERE
      `media.translation`.`language_id` = ?
  ) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id`
WHERE
  `media`.`id` IN (?)

SELECT `media`.`id` as `media.id`, `media`.`user_id` as `media.userId`, `media`.`media_folder_id` as `media.mediaFolderId`, `media`.`mime_type` as `media.mimeType`, `media`.`file_extension` as `media.fileExtension`, `media`.`uploaded_at` as `media.uploadedAt`, `media`.`file_name` as `media.fileName`, `media`.`file_size` as `media.fileSize`, `media`.`media_type` as `media.mediaTypeRaw`, `media`.`meta_data` as `media.metaData`, `media`.`config` as `media.config`, `media`.`path` as `media.path`, `media`.`private` as `media.private`, `media`.`thumbnails_ro` as `media.thumbnailsRo`, `media`.`file_hash` as `media.fileHash`, `media`.`created_at` as `media.createdAt`, `media`.`updated_at` as `media.updatedAt`, `media.mediaFolder`.`id` as `media.mediaFolder.id`, `media.mediaFolder`.`use_parent_configuration` as `media.mediaFolder.useParentConfiguration`, `media.mediaFolder`.`media_folder_configuration_id` as `media.mediaFolder.configurationId`, `media.mediaFolder`.`default_folder_id` as `media.mediaFolder.defaultFolderId`, `media.mediaFolder`.`parent_id` as `media.mediaFolder.parentId`, `media.mediaFolder`.`child_count` as `media.mediaFolder.childCount`, `media.mediaFolder`.`path` as `media.mediaFolder.path`, `media.mediaFolder`.`name` as `media.mediaFolder.name`, `media.mediaFolder`.`custom_fields` as `media.mediaFolder.customFields`, `media.mediaFolder`.`created_at` as `media.mediaFolder.createdAt`, `media.mediaFolder`.`updated_at` as `media.mediaFolder.updatedAt`, `media.translation.title`, `media.translation.title` as `media.title`, `media.translation.alt`, `media.translation.alt` as `media.alt`, `media.translation.customFields`, `media.translation.customFields` as `media.customFields` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id` LEFT JOIN (SELECT `media.translation`.`media_id`, `media.translation`.`alt` as `media.translation.alt`, `media.translation`.`title` as `media.translation.title`, `media.translation`.`custom_fields` as `media.translation.customFields` FROM `media_translation` `media.translation` WHERE `media.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id` WHERE `media`.`id` IN (0x752622DF2D0DE34536B4FEA267F14283);

SELECT
  `name`,
  `type`
FROM
  `custom_field`
WHERE
  `active` = 1

SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1;

SELECT
  `media`.`id` as `media.id`,
  `media`.`user_id` as `media.userId`,
  `media`.`media_folder_id` as `media.mediaFolderId`,
  `media`.`mime_type` as `media.mimeType`,
  `media`.`file_extension` as `media.fileExtension`,
  `media`.`uploaded_at` as `media.uploadedAt`,
  `media`.`file_name` as `media.fileName`,
  `media`.`file_size` as `media.fileSize`,
  `media`.`media_type` as `media.mediaTypeRaw`,
  `media`.`meta_data` as `media.metaData`,
  `media`.`config` as `media.config`,
  `media`.`path` as `media.path`,
  `media`.`private` as `media.private`,
  `media`.`thumbnails_ro` as `media.thumbnailsRo`,
  `media`.`file_hash` as `media.fileHash`,
  `media`.`created_at` as `media.createdAt`,
  `media`.`updated_at` as `media.updatedAt`,
  `media.translation.title`,
  `media.translation.title` as `media.title`,
  `media.translation.alt`,
  `media.translation.alt` as `media.alt`,
  `media.translation.customFields`,
  `media.translation.customFields` as `media.customFields`
FROM
  `media`
  LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id`
  LEFT JOIN (
    SELECT
      `media.translation`.`media_id`,
      `media.translation`.`alt` as `media.translation.alt`,
      `media.translation`.`title` as `media.translation.title`,
      `media.translation`.`custom_fields` as `media.translation.customFields`
    FROM
      `media_translation` `media.translation`
    WHERE
      `media.translation`.`language_id` = ?
  ) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id`
  LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id`
WHERE
  (
    (
      `media`.`file_name` = ?
      AND `media`.`file_extension` = ?
      AND NOT (`media`.`id` <=> ?)
    )
    AND (
      `media`.`private` = ?
      OR (
        `media`.`private` = ?
        AND `media.mediaFolder.defaultFolder`.`entity` = ?
      )
    )
  )

SELECT `media`.`id` as `media.id`, `media`.`user_id` as `media.userId`, `media`.`media_folder_id` as `media.mediaFolderId`, `media`.`mime_type` as `media.mimeType`, `media`.`file_extension` as `media.fileExtension`, `media`.`uploaded_at` as `media.uploadedAt`, `media`.`file_name` as `media.fileName`, `media`.`file_size` as `media.fileSize`, `media`.`media_type` as `media.mediaTypeRaw`, `media`.`meta_data` as `media.metaData`, `media`.`config` as `media.config`, `media`.`path` as `media.path`, `media`.`private` as `media.private`, `media`.`thumbnails_ro` as `media.thumbnailsRo`, `media`.`file_hash` as `media.fileHash`, `media`.`created_at` as `media.createdAt`, `media`.`updated_at` as `media.updatedAt`, `media.translation.title`, `media.translation.title` as `media.title`, `media.translation.alt`, `media.translation.alt` as `media.alt`, `media.translation.customFields`, `media.translation.customFields` as `media.customFields` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id` LEFT JOIN (SELECT `media.translation`.`media_id`, `media.translation`.`alt` as `media.translation.alt`, `media.translation`.`title` as `media.translation.title`, `media.translation`.`custom_fields` as `media.translation.customFields` FROM `media_translation` `media.translation` WHERE `media.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id` WHERE ((`media`.`file_name` = '4662920_1' AND `media`.`file_extension` = 'jpg' AND NOT (`media`.`id` <=> 0x752622DF2D0DE34536B4FEA267F14283)) AND (`media`.`private` = 0 OR (`media`.`private` = 1 AND `media.mediaFolder.defaultFolder`.`entity` = 'product_download')));

SELECT
  LOWER(
    HEX(`media_id`)
  )
FROM
  `media_thumbnail`
WHERE
  `id` = ?

SELECT LOWER(HEX(`media_id`)) FROM `media_thumbnail` WHERE `id` = 0x019E20048EC2714D8E761242B271F190;

SELECT
  LOWER(
    HEX(`media_id`)
  )
FROM
  `media_thumbnail`
WHERE
  `id` = ?

SELECT LOWER(HEX(`media_id`)) FROM `media_thumbnail` WHERE `id` = 0x019E20048EC2714D8E761242B33C73A3;

SELECT
  LOWER(
    HEX(`media_id`)
  )
FROM
  `media_thumbnail`
WHERE
  `id` = ?

SELECT LOWER(HEX(`media_id`)) FROM `media_thumbnail` WHERE `id` = 0x019E20048EC2714D8E761242B3F9D48E;

SELECT
  LOWER(
    HEX(`media_id`)
  )
FROM
  `media_thumbnail`
WHERE
  `id` = ?

SELECT LOWER(HEX(`media_id`)) FROM `media_thumbnail` WHERE `id` = 0x019E20048EC2714D8E761242B3FB2A3A;

SELECT
  1 as `exists`,
  `id`
FROM
  `media_thumbnail`
WHERE
  `id` IN (?, ?, ?, ?)

SELECT 1 as `exists`, `id` FROM `media_thumbnail` WHERE `id` IN (0x019E20048EC2714D8E761242B271F190,0x019E20048EC2714D8E761242B33C73A3,0x019E20048EC2714D8E761242B3F9D48E,0x019E20048EC2714D8E761242B3FB2A3A);

"START TRANSACTION"

"START TRANSACTION";

SELECT
  `media_thumbnail`.`id` as `media_thumbnail.id`,
  `media_thumbnail`.`media_id` as `media_thumbnail.mediaId`,
  `media_thumbnail`.`media_thumbnail_size_id` as `media_thumbnail.mediaThumbnailSizeId`,
  `media_thumbnail`.`width` as `media_thumbnail.width`,
  `media_thumbnail`.`height` as `media_thumbnail.height`,
  `media_thumbnail`.`path` as `media_thumbnail.path`,
  `media_thumbnail`.`custom_fields` as `media_thumbnail.customFields`,
  `media_thumbnail`.`created_at` as `media_thumbnail.createdAt`,
  `media_thumbnail`.`updated_at` as `media_thumbnail.updatedAt`,
  `media_thumbnail.media`.`id` as `media_thumbnail.media.id`,
  `media_thumbnail.media`.`user_id` as `media_thumbnail.media.userId`,
  `media_thumbnail.media`.`media_folder_id` as `media_thumbnail.media.mediaFolderId`,
  `media_thumbnail.media`.`mime_type` as `media_thumbnail.media.mimeType`,
  `media_thumbnail.media`.`file_extension` as `media_thumbnail.media.fileExtension`,
  `media_thumbnail.media`.`uploaded_at` as `media_thumbnail.media.uploadedAt`,
  `media_thumbnail.media`.`file_name` as `media_thumbnail.media.fileName`,
  `media_thumbnail.media`.`file_size` as `media_thumbnail.media.fileSize`,
  `media_thumbnail.media`.`media_type` as `media_thumbnail.media.mediaTypeRaw`,
  `media_thumbnail.media`.`meta_data` as `media_thumbnail.media.metaData`,
  `media_thumbnail.media`.`config` as `media_thumbnail.media.config`,
  `media_thumbnail.media`.`path` as `media_thumbnail.media.path`,
  `media_thumbnail.media`.`private` as `media_thumbnail.media.private`,
  `media_thumbnail.media`.`thumbnails_ro` as `media_thumbnail.media.thumbnailsRo`,
  `media_thumbnail.media`.`file_hash` as `media_thumbnail.media.fileHash`,
  `media_thumbnail.media`.`created_at` as `media_thumbnail.media.createdAt`,
  `media_thumbnail.media`.`updated_at` as `media_thumbnail.media.updatedAt`,
  `media_thumbnail.media.translation.title`,
  `media_thumbnail.media.translation.title` as `media_thumbnail.media.title`,
  `media_thumbnail.media.translation.alt`,
  `media_thumbnail.media.translation.alt` as `media_thumbnail.media.alt`,
  `media_thumbnail.media.translation.customFields`,
  `media_thumbnail.media.translation.customFields` as `media_thumbnail.media.customFields`
FROM
  `media_thumbnail`
  LEFT JOIN `media` `media_thumbnail.media` ON `media_thumbnail`.`media_id` = `media_thumbnail.media`.`id`
  LEFT JOIN (
    SELECT
      `media_thumbnail.media.translation`.`media_id`,
      `media_thumbnail.media.translation`.`alt` as `media_thumbnail.media.translation.alt`,
      `media_thumbnail.media.translation`.`title` as `media_thumbnail.media.translation.title`,
      `media_thumbnail.media.translation`.`custom_fields` as `media_thumbnail.media.translation.customFields`
    FROM
      `media_translation` `media_thumbnail.media.translation`
    WHERE
      `media_thumbnail.media.translation`.`language_id` = ?
  ) `media_thumbnail.media.media_translation` ON `media_thumbnail.media.media_translation`.`media_id` = `media_thumbnail.media`.`id`
WHERE
  (
    (
      `media_thumbnail`.`id` IN (?, ?, ?, ?)
    )
  )

SELECT `media_thumbnail`.`id` as `media_thumbnail.id`, `media_thumbnail`.`media_id` as `media_thumbnail.mediaId`, `media_thumbnail`.`media_thumbnail_size_id` as `media_thumbnail.mediaThumbnailSizeId`, `media_thumbnail`.`width` as `media_thumbnail.width`, `media_thumbnail`.`height` as `media_thumbnail.height`, `media_thumbnail`.`path` as `media_thumbnail.path`, `media_thumbnail`.`custom_fields` as `media_thumbnail.customFields`, `media_thumbnail`.`created_at` as `media_thumbnail.createdAt`, `media_thumbnail`.`updated_at` as `media_thumbnail.updatedAt`, `media_thumbnail.media`.`id` as `media_thumbnail.media.id`, `media_thumbnail.media`.`user_id` as `media_thumbnail.media.userId`, `media_thumbnail.media`.`media_folder_id` as `media_thumbnail.media.mediaFolderId`, `media_thumbnail.media`.`mime_type` as `media_thumbnail.media.mimeType`, `media_thumbnail.media`.`file_extension` as `media_thumbnail.media.fileExtension`, `media_thumbnail.media`.`uploaded_at` as `media_thumbnail.media.uploadedAt`, `media_thumbnail.media`.`file_name` as `media_thumbnail.media.fileName`, `media_thumbnail.media`.`file_size` as `media_thumbnail.media.fileSize`, `media_thumbnail.media`.`media_type` as `media_thumbnail.media.mediaTypeRaw`, `media_thumbnail.media`.`meta_data` as `media_thumbnail.media.metaData`, `media_thumbnail.media`.`config` as `media_thumbnail.media.config`, `media_thumbnail.media`.`path` as `media_thumbnail.media.path`, `media_thumbnail.media`.`private` as `media_thumbnail.media.private`, `media_thumbnail.media`.`thumbnails_ro` as `media_thumbnail.media.thumbnailsRo`, `media_thumbnail.media`.`file_hash` as `media_thumbnail.media.fileHash`, `media_thumbnail.media`.`created_at` as `media_thumbnail.media.createdAt`, `media_thumbnail.media`.`updated_at` as `media_thumbnail.media.updatedAt`, `media_thumbnail.media.translation.title`, `media_thumbnail.media.translation.title` as `media_thumbnail.media.title`, `media_thumbnail.media.translation.alt`, `media_thumbnail.media.translation.alt` as `media_thumbnail.media.alt`, `media_thumbnail.media.translation.customFields`, `media_thumbnail.media.translation.customFields` as `media_thumbnail.media.customFields` FROM `media_thumbnail` LEFT JOIN `media` `media_thumbnail.media` ON `media_thumbnail`.`media_id` = `media_thumbnail.media`.`id` LEFT JOIN (SELECT `media_thumbnail.media.translation`.`media_id`, `media_thumbnail.media.translation`.`alt` as `media_thumbnail.media.translation.alt`, `media_thumbnail.media.translation`.`title` as `media_thumbnail.media.translation.title`, `media_thumbnail.media.translation`.`custom_fields` as `media_thumbnail.media.translation.customFields` FROM `media_translation` `media_thumbnail.media.translation` WHERE `media_thumbnail.media.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `media_thumbnail.media.media_translation` ON `media_thumbnail.media.media_translation`.`media_id` = `media_thumbnail.media`.`id` WHERE ((`media_thumbnail`.`id` IN (0x019E20048EC2714D8E761242B271F190, 0x019E20048EC2714D8E761242B33C73A3, 0x019E20048EC2714D8E761242B3F9D48E, 0x019E20048EC2714D8E761242B3FB2A3A)));

DELETE FROM
  `media_thumbnail`
WHERE
  id = ?

DELETE FROM `media_thumbnail` WHERE id = 0x019E20048EC2714D8E761242B271F190;

DELETE FROM
  `media_thumbnail`
WHERE
  id = ?

DELETE FROM `media_thumbnail` WHERE id = 0x019E20048EC2714D8E761242B33C73A3;

DELETE FROM
  `media_thumbnail`
WHERE
  id = ?

DELETE FROM `media_thumbnail` WHERE id = 0x019E20048EC2714D8E761242B3F9D48E;

DELETE FROM
  `media_thumbnail`
WHERE
  id = ?

DELETE FROM `media_thumbnail` WHERE id = 0x019E20048EC2714D8E761242B3FB2A3A;

SAVEPOINT DOCTRINE_2

SAVEPOINT DOCTRINE_2;

INSERT INTO usage_data_entity_deletion (
  id, entity_name, entity_ids, deleted_at
)
VALUES
  (
    :id, :entity_name, :entity_ids, :deleted_at
  )

INSERT INTO usage_data_entity_deletion (id, entity_name, entity_ids, deleted_at) VALUES(:id, :entity_name, :entity_ids, :deleted_at);

INSERT INTO usage_data_entity_deletion (
  id, entity_name, entity_ids, deleted_at
)
VALUES
  (
    :id, :entity_name, :entity_ids, :deleted_at
  )

INSERT INTO usage_data_entity_deletion (id, entity_name, entity_ids, deleted_at) VALUES(:id, :entity_name, :entity_ids, :deleted_at);