3 |
0.79 ms |
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);
array:8 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 918)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 206)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 410)"
3 => "Shopware\Storefront\Framework\Routing\RequestTransformer::fetchDomains (line 286)"
4 => "Shopware\Storefront\Framework\Routing\RequestTransformer::findSalesChannel (line 152)"
5 => "Shopware\Storefront\Framework\Routing\RequestTransformer::transform (line 143)"
6 => "Shopware\Core\HttpKernel::doHandle (line 80)"
7 => "Shopware\Core\HttpKernel::handle (line 83)"
]
|
7 |
1.40 ms |
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)
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);
array:17 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 918)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 206)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 303)"
3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetch (line 150)"
4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 105)"
5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::read (line 130)"
6 => "Shopware\Core\Framework\DataAbstractionLayer\Cache\CachedEntityReader::loadResultByIds (line 55)"
7 => "Shopware\Core\Framework\DataAbstractionLayer\Cache\CachedEntityReader::read (line 36)"
8 => "Shopware\Core\Profiling\Entity\EntityReaderProfiler::read (line 239)"
9 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::read (line 100)"
10 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 72)"
11 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\Common\RepositoryIterator::fetch (line 295)"
12 => "Shopware\Core\System\SystemConfig\SystemConfigService::load (line 62)"
13 => "Shopware\Core\System\SystemConfig\SystemConfigService::get (line 33)"
14 => "Shopware\Core\Framework\Routing\CanonicalRedirectService::getRedirect (line 147)"
15 => "Shopware\Core\HttpKernel::doHandle (line 80)"
16 => "Shopware\Core\HttpKernel::handle (line 83)"
]
|