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 (0xB237F42A648E4255B960278E39342EE8,0x73840C8CFC564159967DEB180650A529,0x3EF0608509B24DDDAEF72EB5A54FD10A,0xC74932701CEB43FE938F871FAF0FA982,0xCA8F2E8A93784E2F944A95473CE193C9,0x6DFD403AF22549CCA9E7A39685A99EBC,0xF5F6538C31724305B00564D369E94145,0xA8E290432EF64923B65DF0CF4F1DDE9C,0x91290572EBB242BF88089FF70192DD78,0xA6836F77F8E24514927B7DBA96FF7D06,0x5FE4EBADCE6D469488261C619EE0F2E1,0xE29B7FCC07344BEB9F0576BC9F8259FE,0x00F584E6FFF7438B83E4280E99F63D11,0x4B5E532A61A340B897723A63C8CA9416,0x237CA5E7BE7D4C5EB398C5E24CBB2CA7,0xD12DF7A48F73463689A9A127D81DAE27,0x1F5468B0A42A4F4F87A1CD6AAC6FC55E,0xA7DAF3D173904A2BB2E84DE7FAF6AE6D,0xD70DA57444F94ADC8654378455AF6D97,0x9AD3F78C21F2488DA8A8AA6AA016F2EE,0x33607AED2DC64A3CBCCA3D0041434B8A,0xDB1C8D8501554D059D9029C61837A73B,0x4B07999A143644D8BC419F8C5DEFF9AB,0xF0928CEC040B4259B32635B3CB8205E0,0x5E18967D0FCA489EBB31815970AE835F,0x0A1E738496104A2A9DFF73FD080CD0F5,0x828F47EBD38747D7A67ADB5D9300B9AE,0xBF578B285CAD45B6892699AA8AF59552,0x96D0AD782F494BB8BD1C2C7944F260B5,0x15A1C1FED620433A9481EF2C531B1DCE,0x613153A0253C48D18BE516B0D23660F4,0xDB0C831AA5D540A8B531036B447C0992,0x83CCD72659CC4EF59F51CC24C1293803,0x75892B537FB0447589659E62EA408CEA,0x0DC60CCA130A48AEB246C17934A67BC9,0xAEF5253E580543FAAAFE79F74BA64E9D,0xC670D4A42762469693D4C9E93725F5B0,0x28FB96EEEB3E47A3B28976E933DD2B89,0xFED6A89EC86A43BCB2ED7C910BC6E539,0x9A9029A0DF7248508AB78E7C642700F4,0x8DC51C00E86144468A6C55315DFED2F2,0x500D664872CD4555B9F25E0064F71EBB,0xA46B751726C6424684761FEE2588C17F,0x44A4E32DBB2F4A558A0F781C7D1F0ADC,0x554CB6675CC4493C8E415F666D1DF1B2,0x9896C498ED774CFABCFB448734F8C19C,0xA801E4A3F61F4CA19C87A423E2DD0A24,0x3A28B73F1A414CB284BC903674964EBB,0xD5E6C4B2E07A4757A40CF296BCB8B621,0x01BC3308D32A4D6A8B82F862A237CD2B,0xED09B04C3DCD4C11A51A5D5D91DE1F63,0x8FAB257F725D49F0901A0B99077160C5,0x52B47DE1B85642FEBF47148001B6FA4C,0xEA67160008CD40EFA4FF2CA8107DF205,0x837413466E8847FBA63EC64A51994950,0x15B31C8FC01249A1822AEA19B755320C,0xA2EF6AD9F97E4D18A38481BD170A3EE7,0xFD10B25C62744C62A60B8A1AA243E2A1,0xA939CF8F266C456DBD20C17C5E1BF940,0xA013FF37F73342C8B8E8FEFC78120F3D,0xC69E44D1CA604A42881D760496E692A7,0xF1D6D806936245A0A52F8B6168B80AB9,0xB9BC1F3674B54CED96082CFB4548D184,0xC2CD6B33F9C54028883EC41D3331C0CC,0xF02D65BAE9084F5F9FDEDB0D16177233,0xBBDEC9F82629418FB4973723819D24FF,0x5D0EC27A15B34DEB97231CDAD7FFC2A6,0xC6BE979E8E07425C92A6A70EE00D715C,0x9521792A98AB40628DB678AA9DD2B589,0xEC0B96CEE07C48C5941BFEB6C2EF4635,0x0E14C0CD5F6D4F0E94EC6A1A941E9887,0xBE8A0D16BA9C4BFFAC723659DEAE1D0B,0x70D1ABB0A5244366B10723F16C8221FC,0x318573DC0C29450CAD8613B7EE72277B,0x04104B201E9942CCA9D30B5A3E4C8D46,0x7BE8D144E72747E690FB5BDB39B006E0,0x4EF48A1F0D554E61B0FF0136E4229A64,0x8B42C403218C47AB9F14D3B131C678BE,0x1A3266240E9049EFA1E23B97125B0595,0x4896C83213BD4EA4AADD632919044AA9,0xBE631DD10F8547149CBCAE08BBAD4BCA);

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

SELECT 1 as `exists`, `id` FROM `customer` WHERE `id` IN (0xB2C752DF9DBB490FB0ED32513EA92C64,0x6455358FA7624BC3AE12CA463E984042,0x0ED3B0E67D4F4B10838898A3A5AE4E32,0x9189C22A07C142B3852A1C11D08758F2,0x637121F982244BD8B7DD91016A5086F0,0x8EE4B9852C9845DB847AEE83B83CEE54,0x7F612B0986C64144978B57537C34BC74,0xE3288ADA76A64CDE9CAF760180D20EC1,0xD19A451DC0104A1480DD4465AA4771E9,0x2792B69594D34C498700BF7F166B4105,0x7EA622ABCBD3475A825E9304055C8A96,0x5E1A142202B24F41B15D84B0C0885F8B,0x8A20E82C41C2470FA1F4604771EB4E05,0x064E186BEADB40D2A5F4E0B656A8D2B3,0x1C7172C32BBD43DAA40B9D5C3ECA1A2F,0x2768A08BD15C44E7ABD8FE548F92EF31,0x29B05243ABF14E3C88B0E0B8C88CCD54,0x692F1172A2644DE98C7A3646F5624EAD,0x377561D6E0464AF5A13B7C09B0249143,0x007E0B88409244068591F322064CD57C,0x1136914BF87346368D114824738A2983,0x015D29C06CB4442988BC70F180D98A24,0x6692536A426C47BEAF9BB5DBEEE3DF73,0xAACCF85F7EDC4AC887B6F4E70EAE7F39,0x1A87DE29BFB24B41A4F7E1925223FBEF,0x65B9B68C3BB94FA797A9DABCC49AA783,0x567DBB42DE9A4FBC8AACBC9D6468FE70,0x8658A533CCF44B81B0887154A7F3D798,0x49EAE4AC1BF1400586BA0AF227D2E79E,0x120CB0D268554A0F9AF1A67B96C3E1BA,0x5852DDB0C09B41FB92754B5E55CD8885,0x2BE1C26C15D54259A391E1D4C8926AD2,0xC9D46F29567542A0B327015538418939,0xAA156D533B614E489B58E3F710B77432,0x8AEF5C20F8BE400081B6DB8E2B8D9BC4,0x8D7B7C955DD142609907267259BE42BD,0x1A1BCD48CCAA4ED48900601DA1865BBD,0x5488B34DC14A46F0B4CED5727FC6FC39,0xB0B8A3D9D7E74B06AFAFF55AA87301D9,0x294E6F981E184CC59B0B2CE4DA4A4DB6,0xC7AC126EF7FD48A2921D6FA1ECB26A30,0xAB22F0227D334E279F9FEE681607F8F3,0xD09E69569D244D09B208B2E751130AEC,0x965FF5F5D2E1436695D9D91BB3873786,0xF92BAEF0101843E296F8B5D8E2F162BC,0x8CC74F9223B646DC843EB3100599B3C4,0x32A139EDFF1948E1BFCEF5E505FEA17E,0x99D8FE0B96B346F1A8F0C69BAC1B4786,0x00096EF55E604074A9D957499DBBCCFA,0x967404F2559E494AA81A5BB2D7ECF41D,0x40C9A8A079C446D9B09640C9BEE477A4);

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;