Symfony Profiler

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

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

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

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

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

SELECT
  `product`.`id`,
  `product`.`product_number`,
  `product`.`auto_increment`
FROM
  `product`
  LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id`
  AND `product`.`parent_version_id` = `product.parent`.`version_id`
WHERE
  (`product`.`version_id` = ?)
  AND (
    (
      (
        IFNULL(
          `product`.`active`, `product.parent`.`active`
        ) = ?
        AND `product`.`parent_id` IN (
          ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
          ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
          ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
          ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
          ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
          ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
          ?, ?, ?, ?, ?, ?, ?, ?, ?
        )
      )
    )
  )
LIMIT
  100 OFFSET 300

SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (((IFNULL(`product`.`active`, `product.parent`.`active`) = 1 AND `product`.`parent_id` IN (0x3C9771EB8BCDC8DC34E548C9073C7D19, 0x3CC6900B8786659B1FB4FBD0FF548621, 0x3D7110C6561F8B0D0F9E975CC75C8BAA, 0x3DA2EC68FA9988F6AB8FD77B88A1544E, 0x3DA9A6DC855F014F1B688B2E2BC1380C, 0x3E5B6C9D47E28775F46CEFF98BAAD8C1, 0x3E80D4CABC277712DCF8B2583440DDEF, 0x3F80A2405B6FAE8BA8D995AED2000F62, 0x40086588F6284C16D36F6B6468B83975, 0x405B836ADED30BC221EF8C45DBE49CE4, 0x40917636736DCF9AB1A02D74A31B31F7, 0x4145E67819EBEF5124BAD9C3A13E1BB6, 0x41FF2A4126D7E8A76FECC1ACBD89F90F, 0x4218ED20404902FE947897EBEBAB866A, 0x42F09D31B4C084F35FD9832AB9396B74, 0x444857F99BC4519F2A068430202F536F, 0x45C4D1579469B39E1B9FF7CD883CC59D, 0x46B3AFEBAD752F14CA504254C31047A0, 0x47E57C59AC8CFB87B7CFB9366D256249, 0x49F4B88B0659D28E75FDD044F033A0BE, 0x4C3A95EAF3879D03B282F54991C96387, 0x4E5C7CCD0DB248FEF6EEBC4F229942BD, 0x4E7018E75152C79E2F1B65FA2863359F, 0x4EB0096AFFCB7653FE261DECBA509A95, 0x4F8E32A0FD4041D26972AB5E9694AFAA, 0x5029E799C174B1565A11E23F50EC7A0E, 0x50629A131526770E07A334B81A9C9034, 0x50B8F32E17C0EC8AAD20BF94B517E7CB, 0x534ABB9EC42FDC75CC357DED556115AF, 0x5499B0334975F6E7104A7CDEF0AF424C, 0x54D33BB3981C068D0BFF61091D84303D, 0x55179C13E0E56B23A75007B137874E5A, 0x5662528D7573486231B32825A28D6F95, 0x56B2444EC4F702630D03B98E305A38DB, 0x56EBF601EDD76550755CC773ABB033BE, 0x573993356884F2A9B00EC7EC85F58A22, 0x57D43BBB5367707697B3ABD1698B2722, 0x580FF7A038492F552CC468A00B50808A, 0x582F2E540529A7C55A7BF0C168587F3B, 0x587FD586C9D821C0635B8C07F84D5522, 0x5891C1B12B05E05CCDB1796DA319D6A9, 0x5A6E3C030E63AAF7981B4FADDE29D4B3, 0x5B98A65255EC17C563F916DED77DA073, 0x5C4351B229D1F2E9D3E11B0359ED71A8, 0x5D097EFF182262B6B1F9F67BE2025809, 0x5E2367FBE7D2475898DAD7576E114141, 0x5EDF56B23D4A29665FF9A1BE00E0D12C, 0x604212A66F86405543C27760D38E0696, 0x604D00AD289AB76BE1EDCCC49B12E3CF, 0x60EEB89487A8F01EFD86E3E5AF423568, 0x61290C7AE2D2377D00B6B6FBC146E43E, 0x6134BCF0D93F5B049F0B7020D5A05BE5, 0x61FF8A24AD8A3C6CEC6CB97F7471E4C4, 0x625D143599C861F9252E532C91F77EF3, 0x635B3BA1D284504D8BC721CFB968B2D4, 0x63F9DAE3607C144347B2593CA8E33EB8, 0x65524DC7DE06FCB0A690A465C8494A0B, 0x65E9885E28D021C6C3A9A2F3265DB6ED, 0x6652665A26C0882CAA408A52969ADE83, 0x66AB319D5AFB9CBBACB823425FA3C8E9, 0x66D171BE6F9C407E76150945E7C1B112, 0x67A514887CACECAB1E809FEF8BBF011C, 0x68271D5E8F4852E9A634BF78BA9983E8, 0x686258E78E111B63CBB380972D283649, 0x68AFD324B0939E48CED36B448E7C1FA6, 0x691BB3AD94424AE8D9A550FB84F928A3, 0x6A94C1FFD3699E8D88107AE83ADB40A3, 0x6AD6E36B57604E468C61249DEED2371E, 0x6B3CA34F94B96565D1EF26D3E799D748, 0x6C65060CB816B5D1651CBC2038469AEC, 0x6CB739B1E22D7926118AC0D6E698779F, 0x6D1BB17B1C74972C7D72CBC8E354154E, 0x6E6A069C17EFF8E5B17C374539A63052, 0x6F77F6AFBF54DDDE2AADE327B0764155, 0x70CC4938DA64A669B7C706E3D620B9E0, 0x711FBFFF60D3EBD11AE98B8AD1927823, 0x726A877D8BB62D30DD7A3E51A9171BC1, 0x7318F3E6107476A92BDE37E9606C9886, 0x733EF2F7C417C9427AE75B3D130B6365, 0x73DE27BDDB12E4B3AACCB9945D210589, 0x742808A2D37D668393D374D89DE34068, 0x748D95B56CE71835713DA129EB3DECB0, 0x750BA743CFA22CBA3C88F45DF5477758, 0x75D6C26D1632C4C1D8A6C3769E00D80F, 0x7690674AE737AF8CED4FFFFD46EF5E3C, 0x76AD11F72260F3294DFC3C44F0E65C99, 0x77058AC00EEF36578C3B146A247055D8, 0x7740185321558B42888C962B0E848790, 0x782040F0AB6FC26B6F7C54BD635BC56D, 0x787FE358940C3456E4D80C0E5CB08C8C, 0x7A921C61829605BC218071802A7E193D, 0x7CDF702F63F627A850DECEAE3B664312, 0x7D72D1C039AAC843C3563CF66BD01C69, 0x7D9E6CF35AEB528E11F19EEC7D040AA2, 0x7EAF9AC77A99B952A0A216149E6DB41E, 0x7F762192F939AD7808AD0EEC5DAB6A3E, 0x7FD87963635BCE6B558C116247B54BA8, 0x81D65A59CF41DF3AF1C3AD1B0A20BD1C, 0x82545BD39A8063FCBF84188E9B74EE6F, 0x8459DF377EBD73B2F9A9A3EB36C64FC2)))) LIMIT 100 OFFSET 300;