Symfony Profiler

SELECT 
  `creation_timestamp` 
FROM 
  `migration` 
WHERE 
  `update` IS NOT NULL 
  AND `update_destructive` IS NULL

SELECT `creation_timestamp`
            FROM `migration`
            WHERE `update` IS NOT NULL AND `update_destructive` 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 
  @MIGRATION_1600890205_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1611677425_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1611758559_IS_ACTIVE = TRUE

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 @MIGRATION_1600890205_IS_ACTIVE = TRUE;SET @MIGRATION_1611677425_IS_ACTIVE = TRUE;SET @MIGRATION_1611758559_IS_ACTIVE = TRUE;

SELECT 
  CONCAT(
    TRIM(
      TRAILING '/' 
      FROM 
        domain.url
    ), 
    '/'
  ) `key`, 
  CONCAT(
    TRIM(
      TRAILING '/' 
      FROM 
        domain.url
    ), 
    '/'
  ) url, 
  LOWER(
    HEX(domain.id)
  ) id, 
  LOWER(
    HEX(sales_channel.id)
  ) salesChannelId, 
  LOWER(
    HEX(sales_channel.type_id)
  ) typeId, 
  LOWER(
    HEX(domain.snippet_set_id)
  ) snippetSetId, 
  LOWER(
    HEX(domain.currency_id)
  ) currencyId, 
  LOWER(
    HEX(domain.language_id)
  ) languageId, 
  LOWER(
    HEX(theme.id)
  ) themeId, 
  sales_channel.maintenance maintenance, 
  sales_channel.maintenance_ip_whitelist maintenanceIpWhitelist, 
  snippet_set.iso as locale, 
  theme.technical_name as themeName, 
  parentTheme.technical_name as parentThemeName 
FROM 
  sales_channel 
  INNER JOIN sales_channel_domain domain ON domain.sales_channel_id = sales_channel.id 
  LEFT JOIN theme_sales_channel theme_sales_channel ON sales_channel.id = theme_sales_channel.sales_channel_id 
  INNER JOIN snippet_set snippet_set ON snippet_set.id = domain.snippet_set_id 
  LEFT JOIN theme theme ON theme_sales_channel.theme_id = theme.id 
  LEFT JOIN theme parentTheme ON theme.parent_theme_id = parentTheme.id 
WHERE 
  (
    sales_channel.type_id = UNHEX(: typeId)
  ) 
  AND (sales_channel.active)

SELECT CONCAT(TRIM(TRAILING '/' FROM domain.url), '/') `key`, CONCAT(TRIM(TRAILING '/' FROM domain.url), '/') url, LOWER(HEX(domain.id)) id, LOWER(HEX(sales_channel.id)) salesChannelId, LOWER(HEX(sales_channel.type_id)) typeId, LOWER(HEX(domain.snippet_set_id)) snippetSetId, LOWER(HEX(domain.currency_id)) currencyId, LOWER(HEX(domain.language_id)) languageId, LOWER(HEX(theme.id)) themeId, sales_channel.maintenance maintenance, sales_channel.maintenance_ip_whitelist maintenanceIpWhitelist, snippet_set.iso as locale, theme.technical_name as themeName, parentTheme.technical_name as parentThemeName FROM sales_channel INNER JOIN sales_channel_domain domain ON domain.sales_channel_id = sales_channel.id LEFT JOIN theme_sales_channel theme_sales_channel ON sales_channel.id = theme_sales_channel.sales_channel_id INNER JOIN snippet_set snippet_set ON snippet_set.id = domain.snippet_set_id LEFT JOIN theme theme ON theme_sales_channel.theme_id = theme.id LEFT JOIN theme parentTheme ON theme.parent_theme_id = parentTheme.id WHERE (sales_channel.type_id = UNHEX('8a243080f92e4c719546314b577cf82b')) AND (sales_channel.active);

# seo-url::resolve
SELECT 
  id, 
  path_info pathInfo, 
  is_canonical isCanonical 
FROM 
  seo_url 
WHERE 
  (language_id = : language_id) 
  AND (
    (
      sales_channel_id = : sales_channel_id 
      OR sales_channel_id IS NULL
    )
  ) 
  AND (seo_path_info = : seoPath) 
ORDER BY 
  seo_path_info ASC, 
  sales_channel_id IS NULL ASC 
LIMIT 
  1

# seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND ((sales_channel_id = 0x9ACEEDFC1318441A87B2E9E9E304F659 OR sales_channel_id IS NULL)) AND (seo_path_info = 'robots.txt') ORDER BY seo_path_info ASC, sales_channel_id IS NULL ASC LIMIT 1;

SELECT 
  path_info pathInfo, 
  seo_path_info seoPathInfo 
FROM 
  seo_url 
WHERE 
  (language_id = : language_id) 
  AND (
    sales_channel_id = : sales_channel_id
  ) 
  AND (id != : id) 
  AND (path_info = : pathInfo) 
  AND (is_canonical = 1) 
LIMIT 
  1

SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (sales_channel_id = 0x9ACEEDFC1318441A87B2E9E9E304F659) AND (id != '') AND (path_info = '/robots.txt') AND (is_canonical = 1) LIMIT 1;

# system-config::load::search-ids
SELECT 
  `system_config`.`id` 
FROM 
  `system_config` 
WHERE 
  `system_config`.`sales_channel_id` IS NULL 
ORDER BY 
  `system_config`.`sales_channel_id` ASC, 
  `system_config`.`id` ASC 
LIMIT 
  500

# system-config::load::search-ids
SELECT `system_config`.`id` FROM `system_config` WHERE `system_config`.`sales_channel_id` IS NULL ORDER BY `system_config`.`sales_channel_id` ASC, `system_config`.`id` ASC LIMIT 500;

# system-config::load::read
SELECT 
  `system_config`.`id` as `system_config.id`, 
  `system_config`.`configuration_key` as `system_config.configurationKey`, 
  `system_config`.`configuration_value` as `system_config.configurationValue`, 
  `system_config`.`sales_channel_id` as `system_config.salesChannelId`, 
  `system_config`.`created_at` as `system_config.createdAt`, 
  `system_config`.`updated_at` as `system_config.updatedAt` 
FROM 
  `system_config` 
WHERE 
  `system_config`.`id` IN (: ids)

# system-config::load::read
SELECT `system_config`.`id` as `system_config.id`, `system_config`.`configuration_key` as `system_config.configurationKey`, `system_config`.`configuration_value` as `system_config.configurationValue`, `system_config`.`sales_channel_id` as `system_config.salesChannelId`, `system_config`.`created_at` as `system_config.createdAt`, `system_config`.`updated_at` as `system_config.updatedAt` FROM `system_config` WHERE `system_config`.`id` IN (0x022E0ADE3B42429487299E5262A3B353, 0x02D8E3A1A7834FAE80442248B5304F4C, 0x033AF32E8FAC4864BB87AC2C9CBB354C, 0x040311225ADE4CCBBE84C3F541980B14, 0x05EF2CF4A0F5433D8A0DA21389F11331, 0x0A60D329BB3547BA9584CDA1EF2B72F0, 0x0A76AA700F804CE3905E4BC444D40CDF, 0x0B84F02C6DCF4553848CA91C91EEE688, 0x0C2E8F642C7C42A79DAF67A8F6DF8A2A, 0x0C406F326DA340F0B626E3D756C60072, 0x0D129603A92E406999F769B9817C25A1, 0x0F6A5F45FD6047529A2865804A25A6F6, 0x109ED90589D34D4198FA5372A1FEE156, 0x10C48F2A16EB4F2F9519F053ED6F3E81, 0x11975B003FF74F2DBD64DB1AA86C021A, 0x12C00EBF50C74F4DB6BB9199392E3C48, 0x146BD44571344C70B9D9A734D74AB07C, 0x151E89CD7B864A9F89862ABCA039EBB3, 0x1538D5701EA44F209EA72C3F9F1B6826, 0x167933A001134FE7AF0367815833329A, 0x16EB58B2519347059FE4540FD6FB322E, 0x1775B5AD4BA34087A35AEEDDD8CC54C2, 0x1A480B16C0864B71A92A5FA09EB9A3B1, 0x1A498C3EA5CD453394A2B020186057D4, 0x1D24D5511B4645A8A1F5B195179CCFAC, 0x1D6B420EE6304C78A0C58A7EF81CBBCE, 0x1FB46AEEF323444AB1F6BD8D8217BE57, 0x230BEA7883E94DE7AA631A7D078073AC, 0x2593375A94144C9DB3B008DF4B7D0413, 0x2644D636B76248FF8F3DEB44193207CC, 0x2662C697D5674426880782848E1198B1, 0x26819D5C145446B2AF58AF70823AD617, 0x27012563833D469EB811A00DB362D743, 0x2798E5C5FCD64FEF8650C9989AD84CAE, 0x2AA3A3644E9E4782A9AFCCAFF8C2AE31, 0x2B2B406AF974403FA56F102AFF0734C5, 0x2C75A158FDEC4D43B50FDC2F8AA99CCD, 0x2CDEE76AB168438BA1930483EE914A9A, 0x2D9B660DA72D4517AD36D4401A89D82F, 0x2DC3F11F45574A939FB631AF591C1555, 0x2DF354D6699440CFAF78CE226B8415AA, 0x2EAE9AD38F4047C28EB4B8210B35387A, 0x2F5496ACB04C484B936F17AA234C364E, 0x2F761482C0C645BEAEDCE9A62765171D, 0x2FD4C2149F6145348FC3D31A085E7A29, 0x305A70DF223E41B0AD501476D0FA8C15, 0x318BA129618A4368863B99F031011625, 0x33578E5636254595AC37C327D02917CA, 0x335D0F15D80C407D8BC2AB58E3605AB1, 0x33F9A70A2B9B4FDB8BAA8DD2E8F1A3D0, 0x34A2F98DB7FE4E7295C409D29FC15A53, 0x35D71A27D5394F239841A35988C04AB0, 0x35F6D6BB3989499B98C79ABD41DDA4C0, 0x364A29D2E8834AEF8BC185376D128FCC, 0x36743A2B2624459EA2BAA5BDB79F1882, 0x36BBB4DB1F1F4EC58DFE43260EB43016, 0x36F67D0FAF474F05A9058EC16890FC66, 0x37800F98A162487B96815BD544AD3190, 0x3808669BBB634190AAC87D3D23603344, 0x3AFC1AA23883435DB7417AF5ECB4BC8E, 0x3BDE4DAB0C4844DF82A76A80BA438110, 0x3BF5F33CED7243A49D30B9C05623FE07, 0x3F6A41F9B3124AD0B245B7F09E8513E0, 0x400D0C4F68D74A219770DB531BE09B4D, 0x4B0252424B1B471D86B7D4C80AC71B3D, 0x4C7CD14D6C774514B96991EDB0639F60, 0x4E2CFC08AD344B43B903124618635B66, 0x4F3E0AADAB6044ACAC7B1F72A20A4FBA, 0x4FFF14F59A3444C8A7B044975BADB219, 0x52D32DF6E0E44E8D8C50F71788E5DF65, 0x538988613DF04A908DEE8899AF6663A0, 0x540CF34FE6B448DC89B59DCADB04A6EB, 0x5473BD3C5F2A4031AD6093F7A003B7E2, 0x55F7E02D31FF42F4AB150AC85ABB173F, 0x58C105274F85485F9A4F922A3D82A4CB, 0x593C5C381E214347BC69F69AC55E868E, 0x5B8DF1EE6DE242A49F43974F446E7AD1, 0x5E838E4FCF354F03B5C29A87405EE7B2, 0x61A8C4776D6E465A94C31A03E638FE46, 0x63A7DDD0846D4657B45760D81B2D68D7, 0x63C48FA5C6464F25A0D53D6124BF658E, 0x63C6EDC062044AF0B945F89704C7A490, 0x63F658D622804F36BFA41737E1515233, 0x64290C3D44884FC6A0DBB74531718FF7, 0x66DA3D063A1442E28821AC1C0912B148, 0x68DC8C532D184366B770326385437F22, 0x6BC37B64A3C34A4B8E2668EFF6BD21C2, 0x6BCE2E994FF24D6DBAC73518D1B84B3F, 0x6C46D89A6E0A4F5C8391F609BE288007, 0x6EADB64CC1DC4F6C97E6511249E90B72, 0x70BED088D8DD48EC879EFE65946B21DF, 0x71272FB2306F4272918E00F80CF4B9CE, 0x7243D0E54E3B4CC7BFA8AEACF32959E0, 0x7260C7C37A114EB9A25539BE3B4D6396, 0x737FF72B67224F629BC7C3D16E6B8A5B, 0x742E155DACD54705B4435FFA0998C6F6, 0x75664D8331464A86AA8B4CD7125F158F, 0x79341C89FD7E4C13AAACBB3FE9AD13A0, 0x7C4D1A217A414F63A8643DD0D8F734F7, 0x7D973D85824249C99748D9D8FDA210D2, 0x7E51C0C9A3A34E809248EE86B974BAE5, 0x8117CFEFE2EA42919AD6E9552266CD65, 0x828A7897852348CDA49B1E67F5C58ABA, 0x82BF63EC7EB14D64987D43FDD15F170D, 0x8428897BFA7643A991B36FD2B8E501AB, 0x860F5FEFC6694E2CBE767A72B7623D9A, 0x88F728FA80EB4786B1F570AD0F95C874, 0x892C818BDCBB4E448EC26B1D60A250AA, 0x89D17515CF8E4B41A47635DA300F3DBD, 0x8B1A4E145B714B51A579C280F88E3137, 0x8B9DA05920BA4537B96727D6FD0B731B, 0x8BB533D665C442EEAD0B96191A9C2E32, 0x8CB74BA78E4E4FA788305862A71AF43C, 0x8D499A4D5F6C4EF3B205D6077582616A, 0x8E0C54D0DC674C6F9C2CF2D674919FB0, 0x8E9CF82E10224CCEA2DF4616AABAE43E, 0x906C96978A7244BEBB4725D7E3E9B78C, 0x90E644B1B7E44B6080401946F65C5C48, 0x91C9CC07B4ED47D89AB6326F7EA10437, 0x94C8717F824849ECA430C7A2C0CFDA93, 0x96E0C06CA17D4899B6B3B98A3559410C, 0x97E113AC928042B7B9A4C88521E40E40, 0x982AF1E4AFEE4E3BAAFCE438D64D34CA, 0x988F2A3EA7234197801E199BC5E546FC, 0x9A22DCA938404B8E901BC93D4C647880, 0x9CFCEEDA209E4DB29BA7598EE149693F, 0x9DD124B3691847039A5A027C320E5D40, 0xA09D2F14F96E48B9A8E9C1DE98D12A11, 0xA1F5548078E54222A47B5FBDFC337C26, 0xA24C7ADF0BC041099C8EE6FCC74FBD02, 0xA54471AF979E44C19D9151CBD12F8A13, 0xA601A8573A84489983B90BEBE1B5309F, 0xA61E007D42FB4D179E0AF84C9D36515F, 0xA7DB20EBBA5E4840BAAC935A24F76E79, 0xA896AAC6892B47EDB8DA5AED509C7DAA, 0xAC51746AA7344660AB43218DDB81E8DF, 0xADC1A7C0C7BA4FE784AAC23EC00E12C7, 0xAFA787E9807D41DE9DF9B086B59DBB3C, 0xB025E5F598D0449CA685456D7380530A, 0xB0401A84CA234FDF84307C4709B03E7F, 0xB5072EB2DD76472994F44D78017D7E19, 0xB72E7DCBF2724CF0B5E3AECE7C7C27A7, 0xB7306D15134444969728F3A3A76FC5C1, 0xB821B35DD66C484DA41BA09B8C217E35, 0xB83608B1715747E496D2F46ED212D94F, 0xB84AAF52624E439489D72809DB97992D, 0xB8CA58F9405445F19FB523EF05A3BA58, 0xB8DBC5FB3FE4423CA9C841A3165E890E, 0xB9FAE009EC42400AAC6FD0E51F507A42, 0xBA1C4D6A2CEB435A9AD41E3F34F23329, 0xBAFA05B5CD204CB8ADF8AD4AEA229549, 0xBFFE6405EFBC4BEBB5ED719593C54B31, 0xC182A357CFD840A69B2A824003ED1C48, 0xC4ECBFD1546B4D36896356D4D8D97892, 0xC55F2E03E83649E4B12A8C1AE92DED74, 0xC579B4DFA5E84C928964EACFBCA87D59, 0xC691FF9CA34D451AB016BE471082F144, 0xC7415D2FCC1443ACAC5D80B9CDECA59A, 0xC895CA0DDC354A26A1B27B7442A8F27A, 0xCA87B6CC4863462D819D027DD9DD0845, 0xCAD35B5C81C54E05923A1391D93940E0, 0xCB8579C9D3BE483F9874C94114EC1410, 0xCD1FC4A6CD694F298F2D5D9588F5A65D, 0xCE256460F6F242CAAD740478276D08FC, 0xCE2E6E86D3BA498D911CE7FBD1CEB665, 0xCE3643AD96924B16B4397397FAB0031D, 0xCFD7926E348440F6ADB930A3E0706067, 0xD093FFCD89D9412DA89A73FB7C19ED6E, 0xD0D90A37F119473CB5CF5C9269D74760, 0xD11F7BA143A245E49A3027EDDB41AF68, 0xD16B12C6F2B44BBD97ADF1ED89FE1FC9, 0xD19AB08269924AFABA384E1B94EA11F9, 0xD2302EB3810A45978FC0A083AEA8D877, 0xD2C15F35FCCC404DA4C69F37DBB8C14A, 0xD389C0E71B2B4E849DAD9B7B1B8C1F58, 0xD46DE658B40D4114A963C753BE510B9E, 0xD5C97704C5E14AAC8405FD6D06A37EEB, 0xD5CF4A08599E413789838354817BF926, 0xD62FEE7B56F24672B780388A952CF40A, 0xD732A7B9EC584B259AC082601CA95DDC, 0xD7B2259D643749C9B772236F31694668, 0xDB21870631294A39A586A057135BBBF4, 0xDCC8BFD8DB314D54B81CE2C1BC16BE53, 0xDFA3D5D02B7141A59738A361B674A6C4, 0xE175E717D1FB4BC0804A43072E6B9FCC, 0xE5768A27106D4B7C9617697B49F898FE, 0xE5B8100F4973455EBC33130CA52C47F0, 0xE674E3BBB34942448B28064E1A590B6A, 0xEA02177D2C28458285DDA98C08217462, 0xEBF5913E6D5C4A50AA0BEF107E5450A0, 0xECCCB8AB2C2D4A6290D55D3C8A2475F4, 0xEDADCED09EE346B5B42877D3AA1857AA, 0xEE145F7431C14027B9645373C1ED760E, 0xEEF435C16689420DB54661085A3C63AF, 0xEF3F3C294A1D49A382A60FBDECBA9AD3, 0xF0D779FCE27649BFBE9EBB45ABB0BFF7, 0xF1A0534C4C614EA49F793D32C3358B5F, 0xF2A472305B98482CA95FEC56A31C3C47, 0xF3357E7847EF41A5BEA1029DE5C14B64, 0xF33A1D42F8254EDDB3E7FB093F445E77, 0xF34ABE6C3C8F45848BE0EF9AB5ACC13E, 0xF382EE502E974051AF477BE90A0AFA4E, 0xF3F9B9A60E2F4E8B9D16A79B321191B6, 0xF474BEE846C44468BED92EAC9DCAA1EE, 0xF55C2492F78F448E9E9D0043A2D351E3, 0xF82DF4547C9D462EB508E9E9DAFE485E, 0xF8FEF3854F1D4DE99EC3922AF2B25389, 0xFA61C693E7124DC698D56B7B902CF9DE, 0xFA72F9B56AA34B07A876D6EEE124349F, 0xFC5B75B723F84DAEB3521285A778BE21, 0xFC9FB789084E459E975B29639FE24D03, 0xFDDDFDDC1C524F1580A6E3043D598590, 0xFF026A810D5642E482BF6D1F77BC3BF4, 0xFFBB136F387D4F0785BAED32BCA3272C);

# system-config::load::search-ids
SELECT 
  `system_config`.`id` 
FROM 
  `system_config` 
WHERE 
  `system_config`.`sales_channel_id` IS NULL 
ORDER BY 
  `system_config`.`sales_channel_id` ASC, 
  `system_config`.`id` ASC 
LIMIT 
  500 OFFSET 500

# system-config::load::search-ids
SELECT `system_config`.`id` FROM `system_config` WHERE `system_config`.`sales_channel_id` IS NULL ORDER BY `system_config`.`sales_channel_id` ASC, `system_config`.`id` ASC LIMIT 500 OFFSET 500;

SELECT 
  LOWER(
    HEX(id)
  ) 
FROM 
  system_config 
WHERE 
  (sales_channel_id IS NULL) 
  AND (configuration_key LIKE : prefix) 
ORDER BY 
  configuration_key ASC, 
  sales_channel_id ASC

SELECT LOWER(HEX(id)) FROM system_config WHERE (sales_channel_id IS NULL) AND (configuration_key LIKE 'SwpaBackup.%') ORDER BY configuration_key ASC, sales_channel_id ASC;