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

SET
  @@group_concat_max_len = CAST(
    IF(
      @@group_concat_max_len > 320000, @@group_concat_max_len,
      320000
    ) AS UNSIGNED
  );

SET
  sql_mode =(
    SELECT
      REPLACE(
        @@sql_mode, 'ONLY_FULL_GROUP_BY',
        ''
      )
  )

SET @@group_concat_max_len = CAST(IF(@@group_concat_max_len > 320000, @@group_concat_max_len, 320000) AS UNSIGNED);SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

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
  configuration_key,
  configuration_value
FROM
  system_config
WHERE
  sales_channel_id IS NULL
ORDER BY
  sales_channel_id ASC

SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC;

SELECT
  `name`,
  `path`,
  `author`,
  `self_managed`
FROM
  `app`
WHERE
  `active` = 1

SELECT `name`, `path`, `author`, `self_managed`
                FROM `app`
                WHERE `active` = 1
            ;

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 = 'SWIATW11VFPXNM5LEGD2MVZSSG';

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` = 0x8C6764C3CDB549888459D01B8268AE08
        ;

SELECT
  admin
FROM
  `integration`
WHERE
  id = ?

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

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 = 0x8C6764C3CDB549888459D01B8268AE08;

SELECT
  LOWER(
    HEX(language.id)
  ) AS array_key,
  LOWER(
    HEX(language.id)
  ) AS id,
  locale.code,
  parentLocale.code AS parentCode,
  LOWER(
    HEX(language.parent_id)
  ) parentId
FROM
  language
  LEFT JOIN locale locale ON language.translation_code_id = locale.id
  LEFT JOIN language parentLanguage ON language.parent_id = parentLanguage.id
  LEFT JOIN locale parentLocale ON parentLanguage.translation_code_id = parentLocale.id

SELECT LOWER(HEX(language.id)) AS array_key, LOWER(HEX(language.id)) AS id, locale.code, parentLocale.code AS parentCode, LOWER(HEX(language.parent_id)) parentId FROM language LEFT JOIN locale locale ON language.translation_code_id = locale.id LEFT JOIN language parentLanguage ON language.parent_id = parentLanguage.id LEFT JOIN locale parentLocale ON parentLanguage.translation_code_id = parentLocale.id;

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

SELECT 1 as `exists`, `id` FROM `customer_address` WHERE `id` IN (0xFE16EC3CC3B04B73A578490E41FCC511,0xC7B1189E40DF4B8793336DDDFFBF92D5,0x7D18930D73C6452FA812FF87980C1EE8,0x00E1E9186D464A55867550245A9BA189,0x5A9233028FBD49C39FA3DFF4E1A4A1DE,0xAA8D6B789A7E4C3FAF5D3D623E733836,0x07C095795DC042C090817A0C06797597,0x345F79CADCFC4C43BFA12677CB7E062A,0x744B4AE6376742F09CA8B696909F647C,0x18D0929C7CD64C3DB7217C845A71B8BB,0x8E6AF96420C34EEE8C9D5AF459B474C1,0x79B459161EF64095AD4D859785F64863,0x215A076EB3B140AF9480817C11EC1C1B,0x5D69802B52E34190A7C65EB366824621,0xE7931EF9F6B642CE81762876911EE7B4,0x64AD6A876CF34B4AAEC8617F62EF6EE6,0x5E6E20FABDA044F493B0BFF4A95A47D5,0x2173DB676AD54BDDBB7BBEF51BFF06C4,0x5C4EE3F0C43B4856B6891892EAABD678,0xC8B3D6C13218417387014781E0CAE53E,0xA922479C573D47C0B41679BDCFC1ABC5,0x02A7DB26E2504043882C890FE84D8736,0x575270A1930B4AE5A4B484922DB4CCA6,0xF6F08F644A594E3EACDC9F8F3F81F51B,0xD5A4D044AB7D4CFC925BF7453C586C4F,0xB7E3338A3627494C8EC5A2BB9F5ACDF8,0xB016E110616D4D94BDC637E55D6C2DCA,0x4A27F2C740934E56A7DD2D4194C8E948,0x57E2DB0F47354996B755A6C2291E37DB,0xA8C3619784C64BD3BF73CBF878E4F5D8,0x2819B904408C4D0EA1ED3E15D65320B3,0x84FF484AF2BB43729287C5A9B40D7A92,0x40551CBB193B48C68FD142950603920E,0x8DFE944DBAF749AC9158B0E4CDCB53B4,0x284ED388A5244AD19CF9B9C4EF26C58B,0xA5C2088676494409B483810BE4A1DFCC,0x19A792A0E9CB401E99FFD2218F5C4012,0xF0293A61CEDF496F9A2C91AA9C78529C,0xFCDF8CEAFD444D399AD4C92DA85B8830,0xAC68836A3E074AD09E0FCEA89D9C9799,0x835A78D4C4FF425B9467937AC64573D1,0x1D7FFEEBC67740D6AA1A96162F401609,0xED0FDB7768A94297A2F92D3395AF4F60,0x16414854DB224CD88B7F28CAE25BBC8D,0x5BC75AD8A1DB492F8759A69D3742F484,0x37F78A53310D4E149E28FDC04279E109,0x4196D8FC37484C5989944C19391526B2,0x75708A22EA064577A559A3CAC0FBCF16,0xAD680E8AC5C241F988EE011F804FD2F3,0xA14C126CB83640ECB95AB3E167B33FA2,0x8217909C6C444DC09DCAC9337EC69223,0xA6183F4516CF4C24B0C8BB1C72EC8472,0x4896DE55F82C4EA7B7CFB8BCB7D1409F,0x9C6F12F320254703816994CD830186E3,0xBDCF24E529EC41AAB1882134EB4DA8F3,0x452FAD0215484403A9AF90C3EE069F9B,0x8AF263481C3741EF89B71ECFC28FF122,0x134FF393B05A4DBEAB49B01220C900AC,0x1DEBD85B60AA4890919873A798B9C30B);

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

SELECT 1 as `exists`, `id` FROM `customer` WHERE `id` IN (0x3C758BB0ECC7442BB59D25AAB7C97FCB,0x2CBE30C480BD4413A76E29E4E4AF45ED,0x7AFC5C63AC6240F1AFEBC2C0C0DCB7BD,0x1EA32FDEFB0C4BB1BCE4FE3360EEA1C7,0x04B6908968AA4A92BAE063A6C61D047D,0x36918DD3AA454DAFADD11E0541CD89D5,0x633A1FC61EF940E3A2A9998E2F59EB90,0x63058CA28DE14325B7991AB8445C71E2,0x62EDCFD7AFE94366912765DE97FE3162,0xB37B9789E01043828DD25272348FE09A,0x78EF3C4D08C841E1AC57A52E1412B40D,0xB69EC754DD684D8A9B5BA35FAD9FFDE8,0x1265426871EC46238CC917CA83FBB47D,0x0AD3E93A5D3E474BB2D34B769074C45A,0x1555BFE3727744698B66BE1AE77676C7,0x173FF447C2174EA98615EF5C072910C5,0x3DF6BE1654CC4ABB88D1A491060EA87C,0x883E4A605ECC48F495BA33CEA1E5A91E,0x0B399FB1BC364601997B1CA2FC65AE6D,0x0F4554029FDD4A4FA91DDF4C8E3ECF5F,0x2ADAC8C1885243F284E81966DB418862,0x232133D06DE943DDB2027DEA6A873421,0x198EF70C42DE475C9F7FD34FE5161E81,0x15436358752749038792AF9DF762576A,0xA8064B6EE6944CE4935102E1AF19978C,0x1F6908DA7C67463F9758737BEE6C2792,0x85F06EE1712841CA86525B119CADA7C2,0x72534968799C4DB9B3A76CBC53363B70,0x8420907A05774DE99B1DBC56D0D3F514,0x102767DE9A6D4635B7A4D4433186685A,0x4B750F4C47454A7C8453039F9914EAEE,0x13EDB35A8F324D919F3E4DE2E1C051F3,0x866DF77E10094B7883E570886729A73F,0x3E8D04595AC54DA0A82873108973F4D9,0xBFC07CDF8FB0410BA3BF7194C501A131,0x3FCC933644B344DCA15655B7284AC044,0x6D8E8FF0EA054320A9908D9D329FB87C,0x2D88FDE176FC436BB96B8DB08066DED9,0x9005713AC1344D3FB249768573E75D6F,0xDE8F901E1E48452CBA0B71969834FCFE,0x0AA87C26552F4E35A95F73D026A454CA,0x001F1340EEAD43FCA885929587EB1A07,0xDBDB31BB2BE6401A84B94B59BF71C1D2,0x36AF21AE6F2040BBA2FF122142195C17,0x174984333A4C45CDBEECC29E914E2905,0x9921E145F7D244C4B790F842FBC84DD8,0x5F4855E625204D10BD36E72CF8E81DDB,0x5081B3629AFA4854A7ED73359557A2DF,0xA0CC58C18ECB4F4F95D4F69A6A43F732,0x3DAF3E86778B4BDC896EE886A3B0BF52,0x33CD221A596E41AE9B52BA719EEDF991);

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

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

SELECT
  LOWER(
    HEX(id)
  )
FROM
  snippet_set
WHERE
  iso = ?

SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = 'en-GB';

SELECT
  iso
FROM
  snippet_set
WHERE
  id = ?

SELECT iso FROM snippet_set WHERE id = 0x698B9A83F9784B5E8B9E27773B38BA07;

SELECT
  `base_class` AS `baseClass`,
  `author`
FROM
  `plugin`

SELECT `base_class` AS `baseClass`, `author`
                FROM `plugin`
            ;

SELECT
  translation_key,
  value
FROM
  snippet
WHERE
  snippet_set_id = ?

SELECT translation_key, value FROM snippet WHERE snippet_set_id = 0x698B9A83F9784B5E8B9E27773B38BA07;