| 1 |
0.85 ms |
SELECT `value` FROM app_config WHERE `key` = :key
SELECT `value` FROM app_config WHERE `key` = 'cache-id';
array:7 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1274)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 595)"
2 => "Doctrine\DBAL\Connection::fetchColumn (line 34)"
3 => "Shopware\Core\Framework\Adapter\Cache\CacheIdLoader::load (line 194)"
4 => "Shopware\Core\HttpKernel::createKernel (line 135)"
5 => "Shopware\Core\HttpKernel::doHandle (line 80)"
6 => "Shopware\Core\HttpKernel::handle (line 48)"
]
|
| 2 |
0.66 ms |
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
`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`;;
array:7 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1274)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 39)"
2 => "Shopware\Core\Framework\Plugin\KernelPluginLoader\DbalKernelPluginLoader::loadPluginInfos (line 114)"
3 => "Shopware\Core\Framework\Plugin\KernelPluginLoader\KernelPluginLoader::initializePlugins (line 142)"
4 => "Shopware\Core\Kernel::boot (line 136)"
5 => "Shopware\Core\HttpKernel::doHandle (line 80)"
6 => "Shopware\Core\HttpKernel::handle (line 48)"
]
|
| 3 |
1.57 ms |
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
;
array:6 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1274)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 314)"
2 => "Shopware\Core\Kernel::initializeDatabaseConnectionVariables (line 155)"
3 => "Shopware\Core\Kernel::boot (line 136)"
4 => "Shopware\Core\HttpKernel::doHandle (line 80)"
5 => "Shopware\Core\HttpKernel::handle (line 48)"
]
|
| 4 |
0.88 ms |
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_1536232600_IS_ACTIVE = TRUE;SET @MIGRATION_1536232610_IS_ACTIVE = TRUE;SET @MIGRATION_1536232620_IS_ACTIVE = TRUE;SET @MIGRATION_1536232630_IS_ACTIVE = TRUE;SET @MIGRATION_1536232640_IS_ACTIVE = TRUE;SET @MIGRATION_1536232650_IS_ACTIVE = TRUE;SET @MIGRATION_1536232660_IS_ACTIVE = TRUE;SET @MIGRATION_1536232670_IS_ACTIVE = TRUE;SET @MIGRATION_1536232680_IS_ACTIVE = TRUE;SET @MIGRATION_1536232690_IS_ACTIVE = TRUE;SET @MIGRATION_1536232700_IS_ACTIVE = TRUE;SET @MIGRATION_1536232710_IS_ACTIVE = TRUE;SET @MIGRATION_1536232720_IS_ACTIVE = TRUE;SET @MIGRATION_1536232730_IS_ACTIVE = TRUE;SET @MIGRATION_1536232740_IS_ACTIVE = TRUE;SET @MIGRATION_1536232750_IS_ACTIVE = TRUE;SET @MIGRATION_1536232760_IS_ACTIVE = TRUE;SET @MIGRATION_1536232770_IS_ACTIVE = TRUE;SET @MIGRATION_1536232790_IS_ACTIVE = TRUE;SET @MIGRATION_1536232800_IS_ACTIVE = TRUE;SET @MIGRATION_1536232810_IS_ACTIVE = TRUE;SET @MIGRATION_1536232820_IS_ACTIVE = TRUE;SET @MIGRATION_1536232830_IS_ACTIVE = TRUE;SET @MIGRATION_1536232840_IS_ACTIVE = TRUE;SET @MIGRATION_1536232850_IS_ACTIVE = TRUE;SET @MIGRATION_1536232860_IS_ACTIVE = TRUE;SET @MIGRATION_1536232870_IS_ACTIVE = TRUE;SET @MIGRATION_1536232880_IS_ACTIVE = TRUE;SET @MIGRATION_1536232890_IS_ACTIVE = TRUE;SET @MIGRATION_1536232900_IS_ACTIVE = TRUE;SET @MIGRATION_1536232910_IS_ACTIVE = TRUE;SET @MIGRATION_1536232920_IS_ACTIVE = TRUE;SET @MIGRATION_1536232930_IS_ACTIVE = TRUE;SET @MIGRATION_1536232940_IS_ACTIVE = TRUE;SET @MIGRATION_1536232950_IS_ACTIVE = TRUE;SET @MIGRATION_1536232960_IS_ACTIVE = TRUE;SET @MIGRATION_1536232970_IS_ACTIVE = TRUE;SET @MIGRATION_1536232980_IS_ACTIVE = TRUE;SET @MIGRATION_1536232990_IS_ACTIVE = TRUE;SET @MIGRATION_1536233000_IS_ACTIVE = TRUE;SET @MIGRATION_1536233010_IS_ACTIVE = TRUE;SET @MIGRATION_1536233020_IS_ACTIVE = TRUE;SET @MIGRATION_1536233030_IS_ACTIVE = TRUE;SET @MIGRATION_1536233040_IS_ACTIVE = TRUE;SET @MIGRATION_1536233050_IS_ACTIVE = TRUE;SET @MIGRATION_1536233060_IS_ACTIVE = TRUE;SET @MIGRATION_1536233070_IS_ACTIVE = TRUE;SET @MIGRATION_1536233080_IS_ACTIVE = TRUE;SET @MIGRATION_1536233090_IS_ACTIVE = TRUE;SET @MIGRATION_1536233100_IS_ACTIVE = TRUE;SET @MIGRATION_1536233110_IS_ACTIVE = TRUE;SET @MIGRATION_1536233120_IS_ACTIVE = TRUE;SET @MIGRATION_1536233130_IS_ACTIVE = TRUE;SET @MIGRATION_1536233140_IS_ACTIVE = TRUE;SET @MIGRATION_1536233150_IS_ACTIVE = TRUE;SET @MIGRATION_1536233160_IS_ACTIVE = TRUE;SET @MIGRATION_1536233170_IS_ACTIVE = TRUE;SET @MIGRATION_1536233180_IS_ACTIVE = TRUE;SET @MIGRATION_1536233190_IS_ACTIVE = TRUE;SET @MIGRATION_1536233200_IS_ACTIVE = TRUE;SET @MIGRATION_1536233210_IS_ACTIVE = TRUE;SET @MIGRATION_1536233220_IS_ACTIVE = TRUE;SET @MIGRATION_1536233230_IS_ACTIVE = TRUE;SET @MIGRATION_1536233240_IS_ACTIVE = TRUE;SET @MIGRATION_1536233250_IS_ACTIVE = TRUE;SET @MIGRATION_1536233260_IS_ACTIVE = TRUE;SET @MIGRATION_1536233270_IS_ACTIVE = TRUE;SET @MIGRATION_1536233280_IS_ACTIVE = TRUE;SET @MIGRATION_1536233290_IS_ACTIVE = TRUE;SET @MIGRATION_1536233300_IS_ACTIVE = TRUE;SET @MIGRATION_1536233310_IS_ACTIVE = TRUE;SET @MIGRATION_1536233320_IS_ACTIVE = TRUE;SET @MIGRATION_1536233330_IS_ACTIVE = TRUE;SET @MIGRATION_1536233340_IS_ACTIVE = TRUE;SET @MIGRATION_1536233350_IS_ACTIVE = TRUE;SET @MIGRATION_1536233360_IS_ACTIVE = TRUE;SET @MIGRATION_1536233370_IS_ACTIVE = TRUE;SET @MIGRATION_1536233380_IS_ACTIVE = TRUE;SET @MIGRATION_1536233390_IS_ACTIVE = TRUE;SET @MIGRATION_1536233400_IS_ACTIVE = TRUE;SET @MIGRATION_1536233410_IS_ACTIVE = TRUE;SET @MIGRATION_1536233420_IS_ACTIVE = TRUE;SET @MIGRATION_1536233430_IS_ACTIVE = TRUE;SET @MIGRATION_1536233440_IS_ACTIVE = TRUE;SET @MIGRATION_1536233450_IS_ACTIVE = TRUE;SET @MIGRATION_1536233460_IS_ACTIVE = TRUE;SET @MIGRATION_1536233470_IS_ACTIVE = TRUE;SET @MIGRATION_1536233480_IS_ACTIVE = TRUE;SET @MIGRATION_1536233500_IS_ACTIVE = TRUE;SET @MIGRATION_1536233510_IS_ACTIVE = TRUE;SET @MIGRATION_1536233520_IS_ACTIVE = TRUE;SET @MIGRATION_1536233530_IS_ACTIVE = TRUE;SET @MIGRATION_1536233540_IS_ACTIVE = TRUE;SET @MIGRATION_1536233550_IS_ACTIVE = TRUE;SET @MIGRATION_1536233560_IS_ACTIVE = TRUE;SET @MIGRATION_1552360944_IS_ACTIVE = TRUE;SET @MIGRATION_1554199340_IS_ACTIVE = TRUE;SET @MIGRATION_1554200141_IS_ACTIVE = TRUE;SET @MIGRATION_1554203706_IS_ACTIVE = TRUE;SET @MIGRATION_1554900301_IS_ACTIVE = TRUE;SET @MIGRATION_1556809270_IS_ACTIVE = TRUE;SET @MIGRATION_1558082916_IS_ACTIVE = TRUE;SET @MIGRATION_1558105657_IS_ACTIVE = TRUE;SET @MIGRATION_1558443337_IS_ACTIVE = TRUE;SET @MIGRATION_1558505525_IS_ACTIVE = TRUE;SET @MIGRATION_1558594334_IS_ACTIVE = TRUE;SET @MIGRATION_1558938938_IS_ACTIVE = TRUE;SET @MIGRATION_1559050088_IS_ACTIVE = TRUE;SET @MIGRATION_1559050903_IS_ACTIVE = TRUE;SET @MIGRATION_1559134989_IS_ACTIVE = TRUE;SET @MIGRATION_1559306391_IS_ACTIVE = TRUE;SET @MIGRATION_1561370284_IS_ACTIVE = TRUE;SET @MIGRATION_1561377793_IS_ACTIVE = TRUE;SET @MIGRATION_1561442979_IS_ACTIVE = TRUE;SET @MIGRATION_1561452005_IS_ACTIVE = TRUE;SET @MIGRATION_1561712450_IS_ACTIVE = TRUE;SET @MIGRATION_1562228335_IS_ACTIVE = TRUE;SET @MIGRATION_1562240231_IS_ACTIVE = TRUE;SET @MIGRATION_1562306893_IS_ACTIVE = TRUE;SET @MIGRATION_1562324772_IS_ACTIVE = TRUE;SET @MIGRATION_1562579120_IS_ACTIVE = TRUE;SET @MIGRATION_1562684474_IS_ACTIVE = TRUE;SET @MIGRATION_1562841035_IS_ACTIVE = TRUE;SET @MIGRATION_1562933907_IS_ACTIVE = TRUE;SET @MIGRATION_1563180880_IS_ACTIVE = TRUE;SET @MIGRATION_1563288227_IS_ACTIVE = TRUE;SET @MIGRATION_1563518181_IS_ACTIVE = TRUE;SET @MIGRATION_1563805586_IS_ACTIVE = TRUE;SET @MIGRATION_1563949275_IS_ACTIVE = TRUE;SET @MIGRATION_1564475053_IS_ACTIVE = TRUE;SET @MIGRATION_1565007156_IS_ACTIVE = TRUE;SET @MIGRATION_1565079228_IS_ACTIVE = TRUE;SET @MIGRATION_1565270155_IS_ACTIVE = TRUE;SET @MIGRATION_1565270366_IS_ACTIVE = TRUE;SET @MIGRATION_1565346846_IS_ACTIVE = TRUE;SET @MIGRATION_1565705280_IS_ACTIVE = TRUE;SET @MIGRATION_1566293076_IS_ACTIVE = TRUE;SET @MIGRATION_1566460168_IS_ACTIVE = TRUE;SET @MIGRATION_1566817701_IS_ACTIVE = TRUE;SET @MIGRATION_1567431050_IS_ACTIVE = TRUE;SET @MIGRATION_1568120239_IS_ACTIVE = TRUE;SET @MIGRATION_1568120302_IS_ACTIVE = TRUE;SET @MIGRATION_1568645037_IS_ACTIVE = TRUE;SET @MIGRATION_1568901713_IS_ACTIVE = TRUE;SET @MIGRATION_1569403146_IS_ACTIVE = TRUE;SET @MIGRATION_1570187167_IS_ACTIVE = TRUE;SET @MIGRATION_1570459127_IS_ACTIVE = TRUE;SET @MIGRATION_1570621541_IS_ACTIVE = TRUE;SET @MIGRATION_1570622696_IS_ACTIVE = TRUE;SET @MIGRATION_1570629862_IS_ACTIVE = TRUE;SET @MIGRATION_1570684913_IS_ACTIVE = TRUE;SET @MIGRATION_1571059598_IS_ACTIVE = TRUE;SET @MIGRATION_1571210820_IS_ACTIVE = TRUE;SET @MIGRATION_1571660203_IS_ACTIVE = TRUE;SET @MIGRATION_1571724915_IS_ACTIVE = TRUE;SET @MIGRATION_1571981437_IS_ACTIVE = TRUE;SET @MIGRATION_1571990395_IS_ACTIVE = TRUE;SET @MIGRATION_1572193798_IS_ACTIVE = TRUE;SET @MIGRATION_1572264837_IS_ACTIVE = TRUE;SET @MIGRATION_1572273565_IS_ACTIVE = TRUE;SET @MIGRATION_1572421282_IS_ACTIVE = TRUE;SET @MIGRATION_1572425108_IS_ACTIVE = TRUE;SET @MIGRATION_1572957455_IS_ACTIVE = TRUE;SET @MIGRATION_1573049297_IS_ACTIVE = TRUE;SET @MIGRATION_1573569685_IS_ACTIVE = TRUE;SET @MIGRATION_1573729158_IS_ACTIVE = TRUE;SET @MIGRATION_1574063550_IS_ACTIVE = TRUE;SET @MIGRATION_1574082635_IS_ACTIVE = TRUE;SET @MIGRATION_1574258787_IS_ACTIVE = TRUE;SET @MIGRATION_1574258788_IS_ACTIVE = TRUE;SET @MIGRATION_1574258789_IS_ACTIVE = TRUE;SET @MIGRATION_1574520220_IS_ACTIVE = TRUE;SET @MIGRATION_1574672450_IS_ACTIVE = TRUE;SET @MIGRATION_1574695657_IS_ACTIVE = TRUE;SET @MIGRATION_1574925962_IS_ACTIVE = TRUE;SET @MIGRATION_1575010262_IS_ACTIVE = TRUE;SET @MIGRATION_1575021466_IS_ACTIVE = TRUE;SET @MIGRATION_1575034234_IS_ACTIVE = TRUE;SET @MIGRATION_1575036586_IS_ACTIVE = TRUE;SET @MIGRATION_1575039284_IS_ACTIVE = TRUE;SET @MIGRATION_1575197543_IS_ACTIVE = TRUE;SET @MIGRATION_1575274700_IS_ACTIVE = TRUE;SET @MIGRATION_1575293069_IS_ACTIVE = TRUE;SET @MIGRATION_1575451283_IS_ACTIVE = TRUE;SET @MIGRATION_1575626180_IS_ACTIVE = TRUE;SET @MIGRATION_1575883959_IS_ACTIVE = TRUE;SET @MIGRATION_1576488398_IS_ACTIVE = TRUE;SET @MIGRATION_1576590301_IS_ACTIVE = TRUE;SET @MIGRATION_1578042218_IS_ACTIVE = TRUE;SET @MIGRATION_1578044453_IS_ACTIVE = TRUE;SET @MIGRATION_1578470886_IS_ACTIVE = TRUE;SET @MIGRATION_1578475268_IS_ACTIVE = TRUE;SET @MIGRATION_1578485775_IS_ACTIVE = TRUE;SET @MIGRATION_1578491480_IS_ACTIVE = TRUE;SET @MIGRATION_1578590702_IS_ACTIVE = TRUE;SET @MIGRATION_1578648299_IS_ACTIVE = TRUE;SET @MIGRATION_1578650334_IS_ACTIVE = TRUE;SET @MIGRATION_1580202210_IS_ACTIVE = TRUE;SET @MIGRATION_1580218617_IS_ACTIVE = TRUE;SET @MIGRATION_1580743279_IS_ACTIVE = TRUE;SET @MIGRATION_1580746806_IS_ACTIVE = TRUE;SET @MIGRATION_1580808849_IS_ACTIVE = TRUE;SET @MIGRATION_1580819350_IS_ACTIVE = TRUE;SET @MIGRATION_1580827023_IS_ACTIVE = TRUE;SET @MIGRATION_1582011195_IS_ACTIVE = TRUE;SET @MIGRATION_1583142266_IS_ACTIVE = TRUE;SET @MIGRATION_1583416186_IS_ACTIVE = TRUE;SET @MIGRATION_1583756864_IS_ACTIVE = TRUE;SET @MIGRATION_1583844433_IS_ACTIVE = TRUE;SET @MIGRATION_1584002637_IS_ACTIVE = TRUE;SET @MIGRATION_1584953715_IS_ACTIVE = TRUE;SET @MIGRATION_1585056571_IS_ACTIVE = TRUE;SET @MIGRATION_1585126355_IS_ACTIVE = TRUE;SET @MIGRATION_1585490020_IS_ACTIVE = TRUE;SET @MIGRATION_1585744384_IS_ACTIVE = TRUE;SET @MIGRATION_1585816139_IS_ACTIVE = TRUE;SET @MIGRATION_1586158920_IS_ACTIVE = TRUE;SET @MIGRATION_1586173614_IS_ACTIVE = TRUE;SET @MIGRATION_1586260286_IS_ACTIVE = TRUE;SET @MIGRATION_1586334003_IS_ACTIVE = TRUE;SET @MIGRATION_1587039363_IS_ACTIVE = TRUE;SET @MIGRATION_1587109484_IS_ACTIVE = TRUE;SET @MIGRATION_1587111506_IS_ACTIVE = TRUE;SET @MIGRATION_1587461582_IS_ACTIVE = TRUE;SET @MIGRATION_1588143272_IS_ACTIVE = TRUE;SET @MIGRATION_1588144801_IS_ACTIVE = TRUE;SET @MIGRATION_1588153272_IS_ACTIVE = TRUE;SET @MIGRATION_1589178550_IS_ACTIVE = TRUE;SET @MIGRATION_1589357321_IS_ACTIVE = TRUE;SET @MIGRATION_1589359936_IS_ACTIVE = TRUE;SET @MIGRATION_1589379060_IS_ACTIVE = TRUE;SET @MIGRATION_1589447332_IS_ACTIVE = TRUE;SET @MIGRATION_1589458026_IS_ACTIVE = TRUE;SET @MIGRATION_1590408550_IS_ACTIVE = TRUE;SET @MIGRATION_1590409548_IS_ACTIVE = TRUE;SET @MIGRATION_1590566018_IS_ACTIVE = TRUE;SET @MIGRATION_1590566405_IS_ACTIVE = TRUE;SET @MIGRATION_1590579986_IS_ACTIVE = TRUE;SET @MIGRATION_1590758953_IS_ACTIVE = TRUE;SET @MIGRATION_1591052278_IS_ACTIVE = TRUE;SET @MIGRATION_1591167126_IS_ACTIVE = TRUE;SET @MIGRATION_1591253089_IS_ACTIVE = TRUE;SET @MIGRATION_1591259559_IS_ACTIVE = TRUE;SET @MIGRATION_1591272594_IS_ACTIVE = TRUE;SET @MIGRATION_1591361320_IS_ACTIVE = TRUE;SET @MIGRATION_1591683158_IS_ACTIVE = TRUE;SET @MIGRATION_1591817370_IS_ACTIVE = TRUE;SET @MIGRATION_1592466717_IS_ACTIVE = TRUE;SET @MIGRATION_1592837424_IS_ACTIVE = TRUE;SET @MIGRATION_1592978289_IS_ACTIVE = TRUE;SET @MIGRATION_1593698606_IS_ACTIVE = TRUE;SET @MIGRATION_1594650256_IS_ACTIVE = TRUE;SET @MIGRATION_1594885630_IS_ACTIVE = TRUE;SET @MIGRATION_1594886106_IS_ACTIVE = TRUE;SET @MIGRATION_1594886773_IS_ACTIVE = TRUE;SET @MIGRATION_1594886895_IS_ACTIVE = TRUE;SET @MIGRATION_1594887027_IS_ACTIVE = TRUE;SET @MIGRATION_1595160327_IS_ACTIVE = TRUE;SET @MIGRATION_1595321666_IS_ACTIVE = TRUE;SET @MIGRATION_1595422169_IS_ACTIVE = TRUE;SET @MIGRATION_1595480600_IS_ACTIVE = TRUE;SET @MIGRATION_1595489705_IS_ACTIVE = TRUE;SET @MIGRATION_1595492052_IS_ACTIVE = TRUE;SET @MIGRATION_1595492053_IS_ACTIVE = TRUE;SET @MIGRATION_1595499689_IS_ACTIVE = TRUE;SET @MIGRATION_1595553089_IS_ACTIVE = TRUE;SET @MIGRATION_1595578253_IS_ACTIVE = TRUE;SET @MIGRATION_1595919251_IS_ACTIVE = TRUE;SET @MIGRATION_1596091744_IS_ACTIVE = TRUE;SET @MIGRATION_1596441551_IS_ACTIVE = TRUE;SET @MIGRATION_1597391970_IS_ACTIVE = TRUE;SET @MIGRATION_1597394241_IS_ACTIVE = TRUE;SET @MIGRATION_1597657689_IS_ACTIVE = TRUE;SET @MIGRATION_1597762808_IS_ACTIVE = TRUE;SET @MIGRATION_1597830237_IS_ACTIVE = TRUE;SET @MIGRATION_1597930227_IS_ACTIVE = TRUE;SET @MIGRATION_1598280548_IS_ACTIVE = TRUE;SET @MIGRATION_1598520424_IS_ACTIVE = TRUE;SET @MIGRATION_1598885384_IS_ACTIVE = TRUE;SET @MIGRATION_1599112309_IS_ACTIVE = TRUE;SET @MIGRATION_1599134496_IS_ACTIVE = TRUE;SET @MIGRATION_1599463278_IS_ACTIVE = TRUE;SET @MIGRATION_1599570560_IS_ACTIVE = TRUE;SET @MIGRATION_1599720163_IS_ACTIVE = TRUE;SET @MIGRATION_1599806584_IS_ACTIVE = TRUE;SET @MIGRATION_1599806595_IS_ACTIVE = TRUE;SET @MIGRATION_1599822061_IS_ACTIVE = TRUE;SET @MIGRATION_1600072779_IS_ACTIVE = TRUE;SET @MIGRATION_1600156989_IS_ACTIVE = TRUE;SET @MIGRATION_1600253602_IS_ACTIVE = TRUE;SET @MIGRATION_1600330846_IS_ACTIVE = TRUE;SET @MIGRATION_1600338271_IS_ACTIVE = TRUE;SET @MIGRATION_1600349343_IS_ACTIVE = TRUE;SET @MIGRATION_1600676671_IS_ACTIVE = TRUE;SET @MIGRATION_1600769357_IS_ACTIVE = TRUE;SET @MIGRATION_1600778848_IS_ACTIVE = TRUE;SET @MIGRATION_1601388975_IS_ACTIVE = TRUE;SET @MIGRATION_1601451838_IS_ACTIVE = TRUE;SET @MIGRATION_1601539530_IS_ACTIVE = TRUE;SET @MIGRATION_1601543829_IS_ACTIVE = TRUE;SET @MIGRATION_1601891339_IS_ACTIVE = TRUE;SET @MIGRATION_1602062376_IS_ACTIVE = TRUE;SET @MIGRATION_1602146868_IS_ACTIVE = TRUE;SET @MIGRATION_1602153572_IS_ACTIVE = TRUE;SET @MIGRATION_1602494493_IS_ACTIVE = TRUE;SET @MIGRATION_1602494495_IS_ACTIVE = TRUE;SET @MIGRATION_1602745374_IS_ACTIVE = TRUE;SET @MIGRATION_1602822727_IS_ACTIVE = TRUE;SET @MIGRATION_1603179023_IS_ACTIVE = TRUE;SET @MIGRATION_1603293043_IS_ACTIVE = TRUE;SET @MIGRATION_1603970276_IS_ACTIVE = TRUE;SET @MIGRATION_1604056363_IS_ACTIVE = TRUE;SET @MIGRATION_1604056421_IS_ACTIVE = TRUE;SET @MIGRATION_1604475913_IS_ACTIVE = TRUE;SET @MIGRATION_1604499476_IS_ACTIVE = TRUE;SET @MIGRATION_1604568928_IS_ACTIVE = TRUE;SET @MIGRATION_1604669773_IS_ACTIVE = TRUE;SET @MIGRATION_1605103533_IS_ACTIVE = TRUE;SET @MIGRATION_1605530777_IS_ACTIVE = TRUE;SET @MIGRATION_1605609309_IS_ACTIVE = TRUE;SET @MIGRATION_1605609477_IS_ACTIVE = TRUE;SET @MIGRATION_1605861407_IS_ACTIVE = TRUE;SET @MIGRATION_1606310257_IS_ACTIVE = TRUE;SET @MIGRATION_1607415095_IS_ACTIVE = TRUE;SET @MIGRATION_1607500561_IS_ACTIVE = TRUE;SET @MIGRATION_1607514878_IS_ACTIVE = TRUE;SET @MIGRATION_1607581275_IS_ACTIVE = TRUE;SET @MIGRATION_1607581276_IS_ACTIVE = TRUE;SET @MIGRATION_1608624028_IS_ACTIVE = TRUE;SET @MIGRATION_1609125144_IS_ACTIVE = TRUE;SET @MIGRATION_1609857999_IS_ACTIVE = TRUE;SET @MIGRATION_1610531188_IS_ACTIVE = TRUE;SET @MIGRATION_1610965670_IS_ACTIVE = TRUE;SET @MIGRATION_1610974673_IS_ACTIVE = TRUE;SET @MIGRATION_1611155140_IS_ACTIVE = TRUE;SET @MIGRATION_1614240671_IS_ACTIVE = TRUE;SET @MIGRATION_1552899789_IS_ACTIVE = TRUE;SET @MIGRATION_1555406153_IS_ACTIVE = TRUE;SET @MIGRATION_1563785071_IS_ACTIVE = TRUE;SET @MIGRATION_1564385954_IS_ACTIVE = TRUE;SET @MIGRATION_1564385960_IS_ACTIVE = TRUE;SET @MIGRATION_1565640170_IS_ACTIVE = TRUE;SET @MIGRATION_1565640175_IS_ACTIVE = TRUE;SET @MIGRATION_1595492054_IS_ACTIVE = TRUE;SET @MIGRATION_1604502151_IS_ACTIVE = TRUE;SET @MIGRATION_1594104496_IS_ACTIVE = TRUE;SET @MIGRATION_1604585230_IS_ACTIVE = TRUE;SET @MIGRATION_1609140710_IS_ACTIVE = TRUE;SET @MIGRATION_1610337444_IS_ACTIVE = TRUE;SET @MIGRATION_1610439375_IS_ACTIVE = TRUE;SET @MIGRATION_1610448012_IS_ACTIVE = TRUE;SET @MIGRATION_1610523204_IS_ACTIVE = TRUE;SET @MIGRATION_1610523548_IS_ACTIVE = TRUE;SET @MIGRATION_1610616655_IS_ACTIVE = TRUE;SET @MIGRATION_1610621999_IS_ACTIVE = TRUE;SET @MIGRATION_1610625925_IS_ACTIVE = TRUE;SET @MIGRATION_1610634383_IS_ACTIVE = TRUE;SET @MIGRATION_1610904608_IS_ACTIVE = TRUE;SET @MIGRATION_1611732852_IS_ACTIVE = TRUE;SET @MIGRATION_1611817467_IS_ACTIVE = TRUE;SET @MIGRATION_1612184092_IS_ACTIVE = TRUE;SET @MIGRATION_1612442685_IS_ACTIVE = TRUE;SET @MIGRATION_1612442686_IS_ACTIVE = TRUE;SET @MIGRATION_1612442786_IS_ACTIVE = TRUE;SET @MIGRATION_1612851765_IS_ACTIVE = TRUE;SET @MIGRATION_1612865237_IS_ACTIVE = TRUE;SET @MIGRATION_1612970642_IS_ACTIVE = TRUE;SET @MIGRATION_1612980753_IS_ACTIVE = TRUE;SET @MIGRATION_1613665555_IS_ACTIVE = TRUE;SET @MIGRATION_1614249488_IS_ACTIVE = TRUE;SET @MIGRATION_1614691876_IS_ACTIVE = TRUE;SET @MIGRATION_1614765170_IS_ACTIVE = TRUE;SET @MIGRATION_1614765785_IS_ACTIVE = TRUE;SET @MIGRATION_1615359964_IS_ACTIVE = TRUE;SET @MIGRATION_1615366708_IS_ACTIVE = TRUE;SET @MIGRATION_1615452749_IS_ACTIVE = TRUE;SET @MIGRATION_1615802866_IS_ACTIVE = TRUE;SET @MIGRATION_1616496610_IS_ACTIVE = TRUE;SET @MIGRATION_1617356092_IS_ACTIVE = TRUE;SET @MIGRATION_1617784658_IS_ACTIVE = TRUE;SET @MIGRATION_1617868381_IS_ACTIVE = TRUE;SET @MIGRATION_1618476427_IS_ACTIVE = TRUE;SET @MIGRATION_1618900427_IS_ACTIVE = TRUE;SET @MIGRATION_1619604605_IS_ACTIVE = TRUE;SET @MIGRATION_1619703075_IS_ACTIVE = TRUE;SET @MIGRATION_1552899789_IS_ACTIVE = TRUE;SET @MIGRATION_1555406153_IS_ACTIVE = TRUE;SET @MIGRATION_1563785071_IS_ACTIVE = TRUE;SET @MIGRATION_1564385954_IS_ACTIVE = TRUE;SET @MIGRATION_1564385960_IS_ACTIVE = TRUE;SET @MIGRATION_1565640170_IS_ACTIVE = TRUE;SET @MIGRATION_1565640175_IS_ACTIVE = TRUE;SET @MIGRATION_1595492054_IS_ACTIVE = TRUE;SET @MIGRATION_1604502151_IS_ACTIVE = TRUE;SET @MIGRATION_1605167857_IS_ACTIVE = TRUE;SET @MIGRATION_1582718994_IS_ACTIVE = TRUE;SET @MIGRATION_1586345021_IS_ACTIVE = TRUE;SET @MIGRATION_1586345049_IS_ACTIVE = TRUE;SET @MIGRATION_1586345063_IS_ACTIVE = TRUE;SET @MIGRATION_1587126585_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_1536232600_IS_ACTIVE = TRUE;SET @MIGRATION_1536232610_IS_ACTIVE = TRUE;SET @MIGRATION_1536232620_IS_ACTIVE = TRUE;SET @MIGRATION_1536232630_IS_ACTIVE = TRUE;SET @MIGRATION_1536232640_IS_ACTIVE = TRUE;SET @MIGRATION_1536232650_IS_ACTIVE = TRUE;SET @MIGRATION_1536232660_IS_ACTIVE = TRUE;SET @MIGRATION_1536232670_IS_ACTIVE = TRUE;SET @MIGRATION_1536232680_IS_ACTIVE = TRUE;SET @MIGRATION_1536232690_IS_ACTIVE = TRUE;SET @MIGRATION_1536232700_IS_ACTIVE = TRUE;SET @MIGRATION_1536232710_IS_ACTIVE = TRUE;SET @MIGRATION_1536232720_IS_ACTIVE = TRUE;SET @MIGRATION_1536232730_IS_ACTIVE = TRUE;SET @MIGRATION_1536232740_IS_ACTIVE = TRUE;SET @MIGRATION_1536232750_IS_ACTIVE = TRUE;SET @MIGRATION_1536232760_IS_ACTIVE = TRUE;SET @MIGRATION_1536232770_IS_ACTIVE = TRUE;SET @MIGRATION_1536232790_IS_ACTIVE = TRUE;SET @MIGRATION_1536232800_IS_ACTIVE = TRUE;SET @MIGRATION_1536232810_IS_ACTIVE = TRUE;SET @MIGRATION_1536232820_IS_ACTIVE = TRUE;SET @MIGRATION_1536232830_IS_ACTIVE = TRUE;SET @MIGRATION_1536232840_IS_ACTIVE = TRUE;SET @MIGRATION_1536232850_IS_ACTIVE = TRUE;SET @MIGRATION_1536232860_IS_ACTIVE = TRUE;SET @MIGRATION_1536232870_IS_ACTIVE = TRUE;SET @MIGRATION_1536232880_IS_ACTIVE = TRUE;SET @MIGRATION_1536232890_IS_ACTIVE = TRUE;SET @MIGRATION_1536232900_IS_ACTIVE = TRUE;SET @MIGRATION_1536232910_IS_ACTIVE = TRUE;SET @MIGRATION_1536232920_IS_ACTIVE = TRUE;SET @MIGRATION_1536232930_IS_ACTIVE = TRUE;SET @MIGRATION_1536232940_IS_ACTIVE = TRUE;SET @MIGRATION_1536232950_IS_ACTIVE = TRUE;SET @MIGRATION_1536232960_IS_ACTIVE = TRUE;SET @MIGRATION_1536232970_IS_ACTIVE = TRUE;SET @MIGRATION_1536232980_IS_ACTIVE = TRUE;SET @MIGRATION_1536232990_IS_ACTIVE = TRUE;SET @MIGRATION_1536233000_IS_ACTIVE = TRUE;SET @MIGRATION_1536233010_IS_ACTIVE = TRUE;SET @MIGRATION_1536233020_IS_ACTIVE = TRUE;SET @MIGRATION_1536233030_IS_ACTIVE = TRUE;SET @MIGRATION_1536233040_IS_ACTIVE = TRUE;SET @MIGRATION_1536233050_IS_ACTIVE = TRUE;SET @MIGRATION_1536233060_IS_ACTIVE = TRUE;SET @MIGRATION_1536233070_IS_ACTIVE = TRUE;SET @MIGRATION_1536233080_IS_ACTIVE = TRUE;SET @MIGRATION_1536233090_IS_ACTIVE = TRUE;SET @MIGRATION_1536233100_IS_ACTIVE = TRUE;SET @MIGRATION_1536233110_IS_ACTIVE = TRUE;SET @MIGRATION_1536233120_IS_ACTIVE = TRUE;SET @MIGRATION_1536233130_IS_ACTIVE = TRUE;SET @MIGRATION_1536233140_IS_ACTIVE = TRUE;SET @MIGRATION_1536233150_IS_ACTIVE = TRUE;SET @MIGRATION_1536233160_IS_ACTIVE = TRUE;SET @MIGRATION_1536233170_IS_ACTIVE = TRUE;SET @MIGRATION_1536233180_IS_ACTIVE = TRUE;SET @MIGRATION_1536233190_IS_ACTIVE = TRUE;SET @MIGRATION_1536233200_IS_ACTIVE = TRUE;SET @MIGRATION_1536233210_IS_ACTIVE = TRUE;SET @MIGRATION_1536233220_IS_ACTIVE = TRUE;SET @MIGRATION_1536233230_IS_ACTIVE = TRUE;SET @MIGRATION_1536233240_IS_ACTIVE = TRUE;SET @MIGRATION_1536233250_IS_ACTIVE = TRUE;SET @MIGRATION_1536233260_IS_ACTIVE = TRUE;SET @MIGRATION_1536233270_IS_ACTIVE = TRUE;SET @MIGRATION_1536233280_IS_ACTIVE = TRUE;SET @MIGRATION_1536233290_IS_ACTIVE = TRUE;SET @MIGRATION_1536233300_IS_ACTIVE = TRUE;SET @MIGRATION_1536233310_IS_ACTIVE = TRUE;SET @MIGRATION_1536233320_IS_ACTIVE = TRUE;SET @MIGRATION_1536233330_IS_ACTIVE = TRUE;SET @MIGRATION_1536233340_IS_ACTIVE = TRUE;SET @MIGRATION_1536233350_IS_ACTIVE = TRUE;SET @MIGRATION_1536233360_IS_ACTIVE = TRUE;SET @MIGRATION_1536233370_IS_ACTIVE = TRUE;SET @MIGRATION_1536233380_IS_ACTIVE = TRUE;SET @MIGRATION_1536233390_IS_ACTIVE = TRUE;SET @MIGRATION_1536233400_IS_ACTIVE = TRUE;SET @MIGRATION_1536233410_IS_ACTIVE = TRUE;SET @MIGRATION_1536233420_IS_ACTIVE = TRUE;SET @MIGRATION_1536233430_IS_ACTIVE = TRUE;SET @MIGRATION_1536233440_IS_ACTIVE = TRUE;SET @MIGRATION_1536233450_IS_ACTIVE = TRUE;SET @MIGRATION_1536233460_IS_ACTIVE = TRUE;SET @MIGRATION_1536233470_IS_ACTIVE = TRUE;SET @MIGRATION_1536233480_IS_ACTIVE = TRUE;SET @MIGRATION_1536233500_IS_ACTIVE = TRUE;SET @MIGRATION_1536233510_IS_ACTIVE = TRUE;SET @MIGRATION_1536233520_IS_ACTIVE = TRUE;SET @MIGRATION_1536233530_IS_ACTIVE = TRUE;SET @MIGRATION_1536233540_IS_ACTIVE = TRUE;SET @MIGRATION_1536233550_IS_ACTIVE = TRUE;SET @MIGRATION_1536233560_IS_ACTIVE = TRUE;SET @MIGRATION_1552360944_IS_ACTIVE = TRUE;SET @MIGRATION_1554199340_IS_ACTIVE = TRUE;SET @MIGRATION_1554200141_IS_ACTIVE = TRUE;SET @MIGRATION_1554203706_IS_ACTIVE = TRUE;SET @MIGRATION_1554900301_IS_ACTIVE = TRUE;SET @MIGRATION_1556809270_IS_ACTIVE = TRUE;SET @MIGRATION_1558082916_IS_ACTIVE = TRUE;SET @MIGRATION_1558105657_IS_ACTIVE = TRUE;SET @MIGRATION_1558443337_IS_ACTIVE = TRUE;SET @MIGRATION_1558505525_IS_ACTIVE = TRUE;SET @MIGRATION_1558594334_IS_ACTIVE = TRUE;SET @MIGRATION_1558938938_IS_ACTIVE = TRUE;SET @MIGRATION_1559050088_IS_ACTIVE = TRUE;SET @MIGRATION_1559050903_IS_ACTIVE = TRUE;SET @MIGRATION_1559134989_IS_ACTIVE = TRUE;SET @MIGRATION_1559306391_IS_ACTIVE = TRUE;SET @MIGRATION_1561370284_IS_ACTIVE = TRUE;SET @MIGRATION_1561377793_IS_ACTIVE = TRUE;SET @MIGRATION_1561442979_IS_ACTIVE = TRUE;SET @MIGRATION_1561452005_IS_ACTIVE = TRUE;SET @MIGRATION_1561712450_IS_ACTIVE = TRUE;SET @MIGRATION_1562228335_IS_ACTIVE = TRUE;SET @MIGRATION_1562240231_IS_ACTIVE = TRUE;SET @MIGRATION_1562306893_IS_ACTIVE = TRUE;SET @MIGRATION_1562324772_IS_ACTIVE = TRUE;SET @MIGRATION_1562579120_IS_ACTIVE = TRUE;SET @MIGRATION_1562684474_IS_ACTIVE = TRUE;SET @MIGRATION_1562841035_IS_ACTIVE = TRUE;SET @MIGRATION_1562933907_IS_ACTIVE = TRUE;SET @MIGRATION_1563180880_IS_ACTIVE = TRUE;SET @MIGRATION_1563288227_IS_ACTIVE = TRUE;SET @MIGRATION_1563518181_IS_ACTIVE = TRUE;SET @MIGRATION_1563805586_IS_ACTIVE = TRUE;SET @MIGRATION_1563949275_IS_ACTIVE = TRUE;SET @MIGRATION_1564475053_IS_ACTIVE = TRUE;SET @MIGRATION_1565007156_IS_ACTIVE = TRUE;SET @MIGRATION_1565079228_IS_ACTIVE = TRUE;SET @MIGRATION_1565270155_IS_ACTIVE = TRUE;SET @MIGRATION_1565270366_IS_ACTIVE = TRUE;SET @MIGRATION_1565346846_IS_ACTIVE = TRUE;SET @MIGRATION_1565705280_IS_ACTIVE = TRUE;SET @MIGRATION_1566293076_IS_ACTIVE = TRUE;SET @MIGRATION_1566460168_IS_ACTIVE = TRUE;SET @MIGRATION_1566817701_IS_ACTIVE = TRUE;SET @MIGRATION_1567431050_IS_ACTIVE = TRUE;SET @MIGRATION_1568120239_IS_ACTIVE = TRUE;SET @MIGRATION_1568120302_IS_ACTIVE = TRUE;SET @MIGRATION_1568645037_IS_ACTIVE = TRUE;SET @MIGRATION_1568901713_IS_ACTIVE = TRUE;SET @MIGRATION_1569403146_IS_ACTIVE = TRUE;SET @MIGRATION_1570187167_IS_ACTIVE = TRUE;SET @MIGRATION_1570459127_IS_ACTIVE = TRUE;SET @MIGRATION_1570621541_IS_ACTIVE = TRUE;SET @MIGRATION_1570622696_IS_ACTIVE = TRUE;SET @MIGRATION_1570629862_IS_ACTIVE = TRUE;SET @MIGRATION_1570684913_IS_ACTIVE = TRUE;SET @MIGRATION_1571059598_IS_ACTIVE = TRUE;SET @MIGRATION_1571210820_IS_ACTIVE = TRUE;SET @MIGRATION_1571660203_IS_ACTIVE = TRUE;SET @MIGRATION_1571724915_IS_ACTIVE = TRUE;SET @MIGRATION_1571981437_IS_ACTIVE = TRUE;SET @MIGRATION_1571990395_IS_ACTIVE = TRUE;SET @MIGRATION_1572193798_IS_ACTIVE = TRUE;SET @MIGRATION_1572264837_IS_ACTIVE = TRUE;SET @MIGRATION_1572273565_IS_ACTIVE = TRUE;SET @MIGRATION_1572421282_IS_ACTIVE = TRUE;SET @MIGRATION_1572425108_IS_ACTIVE = TRUE;SET @MIGRATION_1572957455_IS_ACTIVE = TRUE;SET @MIGRATION_1573049297_IS_ACTIVE = TRUE;SET @MIGRATION_1573569685_IS_ACTIVE = TRUE;SET @MIGRATION_1573729158_IS_ACTIVE = TRUE;SET @MIGRATION_1574063550_IS_ACTIVE = TRUE;SET @MIGRATION_1574082635_IS_ACTIVE = TRUE;SET @MIGRATION_1574258787_IS_ACTIVE = TRUE;SET @MIGRATION_1574258788_IS_ACTIVE = TRUE;SET @MIGRATION_1574258789_IS_ACTIVE = TRUE;SET @MIGRATION_1574520220_IS_ACTIVE = TRUE;SET @MIGRATION_1574672450_IS_ACTIVE = TRUE;SET @MIGRATION_1574695657_IS_ACTIVE = TRUE;SET @MIGRATION_1574925962_IS_ACTIVE = TRUE;SET @MIGRATION_1575010262_IS_ACTIVE = TRUE;SET @MIGRATION_1575021466_IS_ACTIVE = TRUE;SET @MIGRATION_1575034234_IS_ACTIVE = TRUE;SET @MIGRATION_1575036586_IS_ACTIVE = TRUE;SET @MIGRATION_1575039284_IS_ACTIVE = TRUE;SET @MIGRATION_1575197543_IS_ACTIVE = TRUE;SET @MIGRATION_1575274700_IS_ACTIVE = TRUE;SET @MIGRATION_1575293069_IS_ACTIVE = TRUE;SET @MIGRATION_1575451283_IS_ACTIVE = TRUE;SET @MIGRATION_1575626180_IS_ACTIVE = TRUE;SET @MIGRATION_1575883959_IS_ACTIVE = TRUE;SET @MIGRATION_1576488398_IS_ACTIVE = TRUE;SET @MIGRATION_1576590301_IS_ACTIVE = TRUE;SET @MIGRATION_1578042218_IS_ACTIVE = TRUE;SET @MIGRATION_1578044453_IS_ACTIVE = TRUE;SET @MIGRATION_1578470886_IS_ACTIVE = TRUE;SET @MIGRATION_1578475268_IS_ACTIVE = TRUE;SET @MIGRATION_1578485775_IS_ACTIVE = TRUE;SET @MIGRATION_1578491480_IS_ACTIVE = TRUE;SET @MIGRATION_1578590702_IS_ACTIVE = TRUE;SET @MIGRATION_1578648299_IS_ACTIVE = TRUE;SET @MIGRATION_1578650334_IS_ACTIVE = TRUE;SET @MIGRATION_1580202210_IS_ACTIVE = TRUE;SET @MIGRATION_1580218617_IS_ACTIVE = TRUE;SET @MIGRATION_1580743279_IS_ACTIVE = TRUE;SET @MIGRATION_1580746806_IS_ACTIVE = TRUE;SET @MIGRATION_1580808849_IS_ACTIVE = TRUE;SET @MIGRATION_1580819350_IS_ACTIVE = TRUE;SET @MIGRATION_1580827023_IS_ACTIVE = TRUE;SET @MIGRATION_1582011195_IS_ACTIVE = TRUE;SET @MIGRATION_1583142266_IS_ACTIVE = TRUE;SET @MIGRATION_1583416186_IS_ACTIVE = TRUE;SET @MIGRATION_1583756864_IS_ACTIVE = TRUE;SET @MIGRATION_1583844433_IS_ACTIVE = TRUE;SET @MIGRATION_1584002637_IS_ACTIVE = TRUE;SET @MIGRATION_1584953715_IS_ACTIVE = TRUE;SET @MIGRATION_1585056571_IS_ACTIVE = TRUE;SET @MIGRATION_1585126355_IS_ACTIVE = TRUE;SET @MIGRATION_1585490020_IS_ACTIVE = TRUE;SET @MIGRATION_1585744384_IS_ACTIVE = TRUE;SET @MIGRATION_1585816139_IS_ACTIVE = TRUE;SET @MIGRATION_1586158920_IS_ACTIVE = TRUE;SET @MIGRATION_1586173614_IS_ACTIVE = TRUE;SET @MIGRATION_1586260286_IS_ACTIVE = TRUE;SET @MIGRATION_1586334003_IS_ACTIVE = TRUE;SET @MIGRATION_1587039363_IS_ACTIVE = TRUE;SET @MIGRATION_1587109484_IS_ACTIVE = TRUE;SET @MIGRATION_1587111506_IS_ACTIVE = TRUE;SET @MIGRATION_1587461582_IS_ACTIVE = TRUE;SET @MIGRATION_1588143272_IS_ACTIVE = TRUE;SET @MIGRATION_1588144801_IS_ACTIVE = TRUE;SET @MIGRATION_1588153272_IS_ACTIVE = TRUE;SET @MIGRATION_1589178550_IS_ACTIVE = TRUE;SET @MIGRATION_1589357321_IS_ACTIVE = TRUE;SET @MIGRATION_1589359936_IS_ACTIVE = TRUE;SET @MIGRATION_1589379060_IS_ACTIVE = TRUE;SET @MIGRATION_1589447332_IS_ACTIVE = TRUE;SET @MIGRATION_1589458026_IS_ACTIVE = TRUE;SET @MIGRATION_1590408550_IS_ACTIVE = TRUE;SET @MIGRATION_1590409548_IS_ACTIVE = TRUE;SET @MIGRATION_1590566018_IS_ACTIVE = TRUE;SET @MIGRATION_1590566405_IS_ACTIVE = TRUE;SET @MIGRATION_1590579986_IS_ACTIVE = TRUE;SET @MIGRATION_1590758953_IS_ACTIVE = TRUE;SET @MIGRATION_1591052278_IS_ACTIVE = TRUE;SET @MIGRATION_1591167126_IS_ACTIVE = TRUE;SET @MIGRATION_1591253089_IS_ACTIVE = TRUE;SET @MIGRATION_1591259559_IS_ACTIVE = TRUE;SET @MIGRATION_1591272594_IS_ACTIVE = TRUE;SET @MIGRATION_1591361320_IS_ACTIVE = TRUE;SET @MIGRATION_1591683158_IS_ACTIVE = TRUE;SET @MIGRATION_1591817370_IS_ACTIVE = TRUE;SET @MIGRATION_1592466717_IS_ACTIVE = TRUE;SET @MIGRATION_1592837424_IS_ACTIVE = TRUE;SET @MIGRATION_1592978289_IS_ACTIVE = TRUE;SET @MIGRATION_1593698606_IS_ACTIVE = TRUE;SET @MIGRATION_1594650256_IS_ACTIVE = TRUE;SET @MIGRATION_1594885630_IS_ACTIVE = TRUE;SET @MIGRATION_1594886106_IS_ACTIVE = TRUE;SET @MIGRATION_1594886773_IS_ACTIVE = TRUE;SET @MIGRATION_1594886895_IS_ACTIVE = TRUE;SET @MIGRATION_1594887027_IS_ACTIVE = TRUE;SET @MIGRATION_1595160327_IS_ACTIVE = TRUE;SET @MIGRATION_1595321666_IS_ACTIVE = TRUE;SET @MIGRATION_1595422169_IS_ACTIVE = TRUE;SET @MIGRATION_1595480600_IS_ACTIVE = TRUE;SET @MIGRATION_1595489705_IS_ACTIVE = TRUE;SET @MIGRATION_1595492052_IS_ACTIVE = TRUE;SET @MIGRATION_1595492053_IS_ACTIVE = TRUE;SET @MIGRATION_1595499689_IS_ACTIVE = TRUE;SET @MIGRATION_1595553089_IS_ACTIVE = TRUE;SET @MIGRATION_1595578253_IS_ACTIVE = TRUE;SET @MIGRATION_1595919251_IS_ACTIVE = TRUE;SET @MIGRATION_1596091744_IS_ACTIVE = TRUE;SET @MIGRATION_1596441551_IS_ACTIVE = TRUE;SET @MIGRATION_1597391970_IS_ACTIVE = TRUE;SET @MIGRATION_1597394241_IS_ACTIVE = TRUE;SET @MIGRATION_1597657689_IS_ACTIVE = TRUE;SET @MIGRATION_1597762808_IS_ACTIVE = TRUE;SET @MIGRATION_1597830237_IS_ACTIVE = TRUE;SET @MIGRATION_1597930227_IS_ACTIVE = TRUE;SET @MIGRATION_1598280548_IS_ACTIVE = TRUE;SET @MIGRATION_1598520424_IS_ACTIVE = TRUE;SET @MIGRATION_1598885384_IS_ACTIVE = TRUE;SET @MIGRATION_1599112309_IS_ACTIVE = TRUE;SET @MIGRATION_1599134496_IS_ACTIVE = TRUE;SET @MIGRATION_1599463278_IS_ACTIVE = TRUE;SET @MIGRATION_1599570560_IS_ACTIVE = TRUE;SET @MIGRATION_1599720163_IS_ACTIVE = TRUE;SET @MIGRATION_1599806584_IS_ACTIVE = TRUE;SET @MIGRATION_1599806595_IS_ACTIVE = TRUE;SET @MIGRATION_1599822061_IS_ACTIVE = TRUE;SET @MIGRATION_1600072779_IS_ACTIVE = TRUE;SET @MIGRATION_1600156989_IS_ACTIVE = TRUE;SET @MIGRATION_1600253602_IS_ACTIVE = TRUE;SET @MIGRATION_1600330846_IS_ACTIVE = TRUE;SET @MIGRATION_1600338271_IS_ACTIVE = TRUE;SET @MIGRATION_1600349343_IS_ACTIVE = TRUE;SET @MIGRATION_1600676671_IS_ACTIVE = TRUE;SET @MIGRATION_1600769357_IS_ACTIVE = TRUE;SET @MIGRATION_1600778848_IS_ACTIVE = TRUE;SET @MIGRATION_1601388975_IS_ACTIVE = TRUE;SET @MIGRATION_1601451838_IS_ACTIVE = TRUE;SET @MIGRATION_1601539530_IS_ACTIVE = TRUE;SET @MIGRATION_1601543829_IS_ACTIVE = TRUE;SET @MIGRATION_1601891339_IS_ACTIVE = TRUE;SET @MIGRATION_1602062376_IS_ACTIVE = TRUE;SET @MIGRATION_1602146868_IS_ACTIVE = TRUE;SET @MIGRATION_1602153572_IS_ACTIVE = TRUE;SET @MIGRATION_1602494493_IS_ACTIVE = TRUE;SET @MIGRATION_1602494495_IS_ACTIVE = TRUE;SET @MIGRATION_1602745374_IS_ACTIVE = TRUE;SET @MIGRATION_1602822727_IS_ACTIVE = TRUE;SET @MIGRATION_1603179023_IS_ACTIVE = TRUE;SET @MIGRATION_1603293043_IS_ACTIVE = TRUE;SET @MIGRATION_1603970276_IS_ACTIVE = TRUE;SET @MIGRATION_1604056363_IS_ACTIVE = TRUE;SET @MIGRATION_1604056421_IS_ACTIVE = TRUE;SET @MIGRATION_1604475913_IS_ACTIVE = TRUE;SET @MIGRATION_1604499476_IS_ACTIVE = TRUE;SET @MIGRATION_1604568928_IS_ACTIVE = TRUE;SET @MIGRATION_1604669773_IS_ACTIVE = TRUE;SET @MIGRATION_1605103533_IS_ACTIVE = TRUE;SET @MIGRATION_1605530777_IS_ACTIVE = TRUE;SET @MIGRATION_1605609309_IS_ACTIVE = TRUE;SET @MIGRATION_1605609477_IS_ACTIVE = TRUE;SET @MIGRATION_1605861407_IS_ACTIVE = TRUE;SET @MIGRATION_1606310257_IS_ACTIVE = TRUE;SET @MIGRATION_1607415095_IS_ACTIVE = TRUE;SET @MIGRATION_1607500561_IS_ACTIVE = TRUE;SET @MIGRATION_1607514878_IS_ACTIVE = TRUE;SET @MIGRATION_1607581275_IS_ACTIVE = TRUE;SET @MIGRATION_1607581276_IS_ACTIVE = TRUE;SET @MIGRATION_1608624028_IS_ACTIVE = TRUE;SET @MIGRATION_1609125144_IS_ACTIVE = TRUE;SET @MIGRATION_1609857999_IS_ACTIVE = TRUE;SET @MIGRATION_1610531188_IS_ACTIVE = TRUE;SET @MIGRATION_1610965670_IS_ACTIVE = TRUE;SET @MIGRATION_1610974673_IS_ACTIVE = TRUE;SET @MIGRATION_1611155140_IS_ACTIVE = TRUE;SET @MIGRATION_1614240671_IS_ACTIVE = TRUE;SET @MIGRATION_1552899789_IS_ACTIVE = TRUE;SET @MIGRATION_1555406153_IS_ACTIVE = TRUE;SET @MIGRATION_1563785071_IS_ACTIVE = TRUE;SET @MIGRATION_1564385954_IS_ACTIVE = TRUE;SET @MIGRATION_1564385960_IS_ACTIVE = TRUE;SET @MIGRATION_1565640170_IS_ACTIVE = TRUE;SET @MIGRATION_1565640175_IS_ACTIVE = TRUE;SET @MIGRATION_1595492054_IS_ACTIVE = TRUE;SET @MIGRATION_1604502151_IS_ACTIVE = TRUE;SET @MIGRATION_1594104496_IS_ACTIVE = TRUE;SET @MIGRATION_1604585230_IS_ACTIVE = TRUE;SET @MIGRATION_1609140710_IS_ACTIVE = TRUE;SET @MIGRATION_1610337444_IS_ACTIVE = TRUE;SET @MIGRATION_1610439375_IS_ACTIVE = TRUE;SET @MIGRATION_1610448012_IS_ACTIVE = TRUE;SET @MIGRATION_1610523204_IS_ACTIVE = TRUE;SET @MIGRATION_1610523548_IS_ACTIVE = TRUE;SET @MIGRATION_1610616655_IS_ACTIVE = TRUE;SET @MIGRATION_1610621999_IS_ACTIVE = TRUE;SET @MIGRATION_1610625925_IS_ACTIVE = TRUE;SET @MIGRATION_1610634383_IS_ACTIVE = TRUE;SET @MIGRATION_1610904608_IS_ACTIVE = TRUE;SET @MIGRATION_1611732852_IS_ACTIVE = TRUE;SET @MIGRATION_1611817467_IS_ACTIVE = TRUE;SET @MIGRATION_1612184092_IS_ACTIVE = TRUE;SET @MIGRATION_1612442685_IS_ACTIVE = TRUE;SET @MIGRATION_1612442686_IS_ACTIVE = TRUE;SET @MIGRATION_1612442786_IS_ACTIVE = TRUE;SET @MIGRATION_1612851765_IS_ACTIVE = TRUE;SET @MIGRATION_1612865237_IS_ACTIVE = TRUE;SET @MIGRATION_1612970642_IS_ACTIVE = TRUE;SET @MIGRATION_1612980753_IS_ACTIVE = TRUE;SET @MIGRATION_1613665555_IS_ACTIVE = TRUE;SET @MIGRATION_1614249488_IS_ACTIVE = TRUE;SET @MIGRATION_1614691876_IS_ACTIVE = TRUE;SET @MIGRATION_1614765170_IS_ACTIVE = TRUE;SET @MIGRATION_1614765785_IS_ACTIVE = TRUE;SET @MIGRATION_1615359964_IS_ACTIVE = TRUE;SET @MIGRATION_1615366708_IS_ACTIVE = TRUE;SET @MIGRATION_1615452749_IS_ACTIVE = TRUE;SET @MIGRATION_1615802866_IS_ACTIVE = TRUE;SET @MIGRATION_1616496610_IS_ACTIVE = TRUE;SET @MIGRATION_1617356092_IS_ACTIVE = TRUE;SET @MIGRATION_1617784658_IS_ACTIVE = TRUE;SET @MIGRATION_1617868381_IS_ACTIVE = TRUE;SET @MIGRATION_1618476427_IS_ACTIVE = TRUE;SET @MIGRATION_1618900427_IS_ACTIVE = TRUE;SET @MIGRATION_1619604605_IS_ACTIVE = TRUE;SET @MIGRATION_1619703075_IS_ACTIVE = TRUE;SET @MIGRATION_1552899789_IS_ACTIVE = TRUE;SET @MIGRATION_1555406153_IS_ACTIVE = TRUE;SET @MIGRATION_1563785071_IS_ACTIVE = TRUE;SET @MIGRATION_1564385954_IS_ACTIVE = TRUE;SET @MIGRATION_1564385960_IS_ACTIVE = TRUE;SET @MIGRATION_1565640170_IS_ACTIVE = TRUE;SET @MIGRATION_1565640175_IS_ACTIVE = TRUE;SET @MIGRATION_1595492054_IS_ACTIVE = TRUE;SET @MIGRATION_1604502151_IS_ACTIVE = TRUE;SET @MIGRATION_1605167857_IS_ACTIVE = TRUE;SET @MIGRATION_1582718994_IS_ACTIVE = TRUE;SET @MIGRATION_1586345021_IS_ACTIVE = TRUE;SET @MIGRATION_1586345049_IS_ACTIVE = TRUE;SET @MIGRATION_1586345063_IS_ACTIVE = TRUE;SET @MIGRATION_1587126585_IS_ACTIVE = TRUE;
array:6 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1274)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 342)"
2 => "Shopware\Core\Kernel::initializeDatabaseConnectionVariables (line 155)"
3 => "Shopware\Core\Kernel::boot (line 136)"
4 => "Shopware\Core\HttpKernel::doHandle (line 80)"
5 => "Shopware\Core\HttpKernel::handle (line 48)"
]
|
| 5 |
1.00 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:9 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1274)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 210)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 58)"
3 => "Shopware\Storefront\Framework\Routing\DomainLoader::load (line 47)"
4 => "Shopware\Storefront\Framework\Routing\CachedDomainLoader::load (line 266)"
5 => "Shopware\Storefront\Framework\Routing\RequestTransformer::findSalesChannel (line 129)"
6 => "Shopware\Storefront\Framework\Routing\RequestTransformer::transform (line 143)"
7 => "Shopware\Core\HttpKernel::doHandle (line 80)"
8 => "Shopware\Core\HttpKernel::handle (line 48)"
]
|
| 6 |
0.59 ms |
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
SELECT id, path_info pathInfo, is_canonical isCanonical FROM seo_url WHERE (language_id = 0x2F113E50255F4376AF96F37B18A809A7) AND ((sales_channel_id = 0x9AA2A6369C964BB689DB1DEFBA2BC178 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;
array:10 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1274)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 210)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 46)"
3 => "Shopware\Core\Content\Seo\SeoResolver::resolve (line 53)"
4 => "Shopware\Core\Content\Seo\CachedSeoResolver::resolve (line 29)"
5 => "Shopware\Core\Content\Seo\EmptyPathInfoResolver::resolve (line 325)"
6 => "Shopware\Storefront\Framework\Routing\RequestTransformer::resolveSeoUrl (line 143)"
7 => "Shopware\Storefront\Framework\Routing\RequestTransformer::transform (line 143)"
8 => "Shopware\Core\HttpKernel::doHandle (line 80)"
9 => "Shopware\Core\HttpKernel::handle (line 48)"
]
|
| 7 |
0.42 ms |
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 = 0x2F113E50255F4376AF96F37B18A809A7) AND (sales_channel_id = 0x9AA2A6369C964BB689DB1DEFBA2BC178) AND (id != '') AND (path_info = '/robots.txt') AND (is_canonical = 1) LIMIT 1;
array:10 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1274)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 210)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 67)"
3 => "Shopware\Core\Content\Seo\SeoResolver::resolve (line 53)"
4 => "Shopware\Core\Content\Seo\CachedSeoResolver::resolve (line 29)"
5 => "Shopware\Core\Content\Seo\EmptyPathInfoResolver::resolve (line 325)"
6 => "Shopware\Storefront\Framework\Routing\RequestTransformer::resolveSeoUrl (line 143)"
7 => "Shopware\Storefront\Framework\Routing\RequestTransformer::transform (line 143)"
8 => "Shopware\Core\HttpKernel::doHandle (line 80)"
9 => "Shopware\Core\HttpKernel::handle (line 48)"
]
|
| 8 |
1.08 ms |
SELECT `system_config`.`id` FROM `system_config` WHERE (`system_config`.`sales_channel_id` <=> :param_1e4fd71fb9ba45ea851804436def74ed) ORDER BY `system_config`.`sales_channel_id` ASC, `system_config`.`id` ASC LIMIT 500
SELECT `system_config`.`id` FROM `system_config` WHERE (`system_config`.`sales_channel_id` <=> NULL) ORDER BY `system_config`.`sales_channel_id` ASC, `system_config`.`id` ASC LIMIT 500;
array:16 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1274)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 210)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 92)"
3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntitySearcher::search (line 56)"
4 => "Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher::search (line 36)"
5 => "Shopware\Core\Profiling\Entity\EntitySearcherProfiler::search (line 148)"
6 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::searchIds (line 96)"
7 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 72)"
8 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\Common\RepositoryIterator::fetch (line 67)"
9 => "Shopware\Core\System\SystemConfig\SystemConfigLoader::load (line 49)"
10 => "Shopware\Core\System\SystemConfig\CachedSystemConfigLoader::load (line 364)"
11 => "Shopware\Core\System\SystemConfig\SystemConfigService::load (line 95)"
12 => "Shopware\Core\System\SystemConfig\SystemConfigService::get (line 33)"
13 => "Shopware\Core\Framework\Routing\CanonicalRedirectService::getRedirect (line 147)"
14 => "Shopware\Core\HttpKernel::doHandle (line 80)"
15 => "Shopware\Core\HttpKernel::handle (line 48)"
]
|
| 9 |
0.98 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 (0x0399B6B236DB4B188A06C831415DF8A1, 0x04DD25AD51E04100AFFD28430D8C7702, 0x06C684F1335D41209097FEF589E68D16, 0x06CEC2DB09A24AB08ABDD49305E1AD5B, 0x0E3BFD0BDB3948568EA15187F9F3D719, 0x1727A2B184634D1F82F2C89D78D41F34, 0x1AD5F0E178C34906A23F486A3ED7A5EB, 0x1CA4B3A277F343D2A6EA766E877F4283, 0x2220964A77B94BE7AF8AF17A895866C3, 0x2671937775A5433F8A608C78FCD14490, 0x2DF3390CFEE54B01B8CBA9B831A54CEA, 0x3B95201C3D454696B52587BC40D452AF, 0x3D9EB62DD5684D699DE387367B0C4D9D, 0x4CAAAAC5C0674202A30089CD1D68BF45, 0x57159F01FF3846B2B0DFAE8475D988A5, 0x58828CD5BE49424389DB90F8819229E5, 0x5A1D97D94DF44979887B94DD536E3984, 0x5C4F0B29AB594B5294BDB6606D518ACC, 0x630871370D904CD9958E1F36E8DB5601, 0x638D2640BC4240BFAF446C9B058DD9B1, 0x646148555B5B48E2865F62E9D1B1AA91, 0x6B61D093BF274F899752835FB495EDCA, 0x6DF335CD4C334D069D5D0099A6428548, 0x6F79008B0A2E4331BB9E4B041B6AFD8F, 0x6F855CC86C2643439CE1107936B780EB, 0x707D15DC4DAF4866BFB93B981F9F9711, 0x76F02485C2114353A9C1E89089EF1267, 0x7C07771AE03249BDB49DA38D69D2FA22, 0x7C28BB57B3E641869E57CC14AB41B88A, 0x808DD6DE637A4B1F8AC7BFC762411069, 0x891A97A83D374583BEEA87342E7E75ED, 0x8B3ED767557B4E248D8E9E54F9DBA76B, 0x8FB81D7275C64B56914A68F74C46F81F, 0x918FC162274E4F8EA8670D00364F211B, 0x93090AB6E6734360B48647171EB4C8EA, 0x9B2B82B047C148688DB4BE31C25269FD, 0x9B6B7BAAB81A4832A397A22D599A76F5, 0xA20FCC46246147F5A58228ABCE19B706, 0xA744787E859541F2945327E01E18B53D, 0xA8BD84E0BE8E4AAD9BA91E60E774FB9B, 0xAA22530DE8CF43D28D7CA1873198B62B, 0xAB74B1DC08E1451EA88C933B015B15D9, 0xAD4DF0C7D5414ABFA949D9A4435F37C0, 0xB14444C2330B4487AE4048E8983DCC1F, 0xBA000C91786142AEBA118CE97C2CFDD8, 0xBF1D60F9FCFE4904983B0067DA5AEC60, 0xC1368C3042204263A3EA373D3CE01C13, 0xC3A3AE3729E0490BB6B6B9A7D4E7E5A7, 0xC911431F3F25469C923F6CB2B2741BD9, 0xCAC80E23C3ED4017BB1E2913916EDD14, 0xCE451D63189D45508D81B85A48083ED9, 0xD00632E858DC44B4BD62D5417C765523, 0xD3EF3D9CE132464FA08E49D13FB752C0, 0xDB6F778080DF4DCF815CA159C271FA0E, 0xDEA5CD0FEE894E5EA5D09B504A3C010B, 0xE1A590E1FD114A95929EB77966C52F40, 0xE7B96E18F22843739C5CD63A83B7AED1, 0xEB061D791B5E42ED88ADC73989B28086, 0xF0877E5C39AC4CDE87CDDE8A9CE5A06D, 0xF3AC281E9F4448DDA28A4BAD958B2747, 0xFC4373C5168D45E9AFF04EEB043BF935);
array:17 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1274)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 210)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 277)"
3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetch (line 124)"
4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 94)"
5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::read (line 36)"
6 => "Shopware\Core\Profiling\Entity\EntityReaderProfiler::read (line 239)"
7 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::read (line 100)"
8 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 72)"
9 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\Common\RepositoryIterator::fetch (line 67)"
10 => "Shopware\Core\System\SystemConfig\SystemConfigLoader::load (line 49)"
11 => "Shopware\Core\System\SystemConfig\CachedSystemConfigLoader::load (line 364)"
12 => "Shopware\Core\System\SystemConfig\SystemConfigService::load (line 95)"
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 48)"
]
|
| 10 |
0.75 ms |
SELECT `system_config`.`id` FROM `system_config` WHERE (`system_config`.`sales_channel_id` <=> :param_537ce3beca8b456793211f5d00cd1448) ORDER BY `system_config`.`sales_channel_id` ASC, `system_config`.`id` ASC LIMIT 500 OFFSET 500
SELECT `system_config`.`id` FROM `system_config` WHERE (`system_config`.`sales_channel_id` <=> NULL) ORDER BY `system_config`.`sales_channel_id` ASC, `system_config`.`id` ASC LIMIT 500 OFFSET 500;
array:16 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1274)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 210)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 92)"
3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntitySearcher::search (line 56)"
4 => "Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher::search (line 36)"
5 => "Shopware\Core\Profiling\Entity\EntitySearcherProfiler::search (line 148)"
6 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::searchIds (line 96)"
7 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 72)"
8 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\Common\RepositoryIterator::fetch (line 67)"
9 => "Shopware\Core\System\SystemConfig\SystemConfigLoader::load (line 49)"
10 => "Shopware\Core\System\SystemConfig\CachedSystemConfigLoader::load (line 364)"
11 => "Shopware\Core\System\SystemConfig\SystemConfigService::load (line 95)"
12 => "Shopware\Core\System\SystemConfig\SystemConfigService::get (line 33)"
13 => "Shopware\Core\Framework\Routing\CanonicalRedirectService::getRedirect (line 147)"
14 => "Shopware\Core\HttpKernel::doHandle (line 80)"
15 => "Shopware\Core\HttpKernel::handle (line 48)"
]
|
| 11 |
1.90 ms |
SELECT `plugin`.`id` as `plugin.id`, `plugin`.`base_class` as `plugin.baseClass`, `plugin`.`name` as `plugin.name`, `plugin`.`composer_name` as `plugin.composerName`, `plugin`.`autoload` as `plugin.autoload`, `plugin`.`active` as `plugin.active`, `plugin`.`managed_by_composer` as `plugin.managedByComposer`, `plugin`.`path` as `plugin.path`, `plugin`.`author` as `plugin.author`, `plugin`.`copyright` as `plugin.copyright`, `plugin`.`license` as `plugin.license`, `plugin`.`version` as `plugin.version`, `plugin`.`upgrade_version` as `plugin.upgradeVersion`, `plugin`.`installed_at` as `plugin.installedAt`, `plugin`.`upgraded_at` as `plugin.upgradedAt`, `plugin`.`icon` as `plugin.iconRaw`, `plugin`.`created_at` as `plugin.createdAt`, `plugin`.`updated_at` as `plugin.updatedAt`, `plugin.plugin_translation`.*, COALESCE(`plugin.translation.label`,`plugin.translation.label`) as `plugin.label`, COALESCE(`plugin.translation.description`,`plugin.translation.description`) as `plugin.description`, COALESCE(`plugin.translation.manufacturerLink`,`plugin.translation.manufacturerLink`) as `plugin.manufacturerLink`, COALESCE(`plugin.translation.supportLink`,`plugin.translation.supportLink`) as `plugin.supportLink`, COALESCE(`plugin.translation.changelog`,`plugin.translation.changelog`) as `plugin.changelog`, COALESCE(`plugin.translation.customFields`,`plugin.translation.customFields`) as `plugin.customFields` FROM `plugin` LEFT JOIN (SELECT `plugin.translation`.plugin_id, `plugin.translation`.label as `plugin.translation.label`, `plugin.translation`.description as `plugin.translation.description`, `plugin.translation`.manufacturer_link as `plugin.translation.manufacturerLink`, `plugin.translation`.support_link as `plugin.translation.supportLink`, `plugin.translation`.changelog as `plugin.translation.changelog`, `plugin.translation`.custom_fields as `plugin.translation.customFields`, `plugin.translation`.created_at as `plugin.translation.createdAt`, `plugin.translation`.updated_at as `plugin.translation.updatedAt`, `plugin.translation`.plugin_id as `plugin.translation.pluginId`, `plugin.translation`.language_id as `plugin.translation.languageId` FROM `plugin_translation` `plugin.translation` WHERE `plugin.translation`.language_id = :languageId) `plugin.plugin_translation` ON `plugin.plugin_translation`.`plugin_id` = `plugin`.`id` WHERE (`plugin`.`active` <=> :param_39e7cbfb6c2c49e983afe72254d07ad0)
SELECT
`plugin`.`id` as `plugin.id`,
`plugin`.`base_class` as `plugin.baseClass`,
`plugin`.`name` as `plugin.name`,
`plugin`.`composer_name` as `plugin.composerName`,
`plugin`.`autoload` as `plugin.autoload`,
`plugin`.`active` as `plugin.active`,
`plugin`.`managed_by_composer` as `plugin.managedByComposer`,
`plugin`.`path` as `plugin.path`,
`plugin`.`author` as `plugin.author`,
`plugin`.`copyright` as `plugin.copyright`,
`plugin`.`license` as `plugin.license`,
`plugin`.`version` as `plugin.version`,
`plugin`.`upgrade_version` as `plugin.upgradeVersion`,
`plugin`.`installed_at` as `plugin.installedAt`,
`plugin`.`upgraded_at` as `plugin.upgradedAt`,
`plugin`.`icon` as `plugin.iconRaw`,
`plugin`.`created_at` as `plugin.createdAt`,
`plugin`.`updated_at` as `plugin.updatedAt`,
`plugin.plugin_translation`.*,
COALESCE(
`plugin.translation.label`, `plugin.translation.label`
) as `plugin.label`,
COALESCE(
`plugin.translation.description`,
`plugin.translation.description`
) as `plugin.description`,
COALESCE(
`plugin.translation.manufacturerLink`,
`plugin.translation.manufacturerLink`
) as `plugin.manufacturerLink`,
COALESCE(
`plugin.translation.supportLink`,
`plugin.translation.supportLink`
) as `plugin.supportLink`,
COALESCE(
`plugin.translation.changelog`,
`plugin.translation.changelog`
) as `plugin.changelog`,
COALESCE(
`plugin.translation.customFields`,
`plugin.translation.customFields`
) as `plugin.customFields`
FROM
`plugin`
LEFT JOIN (
SELECT
`plugin.translation`.plugin_id,
`plugin.translation`.label as `plugin.translation.label`,
`plugin.translation`.description as `plugin.translation.description`,
`plugin.translation`.manufacturer_link as `plugin.translation.manufacturerLink`,
`plugin.translation`.support_link as `plugin.translation.supportLink`,
`plugin.translation`.changelog as `plugin.translation.changelog`,
`plugin.translation`.custom_fields as `plugin.translation.customFields`,
`plugin.translation`.created_at as `plugin.translation.createdAt`,
`plugin.translation`.updated_at as `plugin.translation.updatedAt`,
`plugin.translation`.plugin_id as `plugin.translation.pluginId`,
`plugin.translation`.language_id as `plugin.translation.languageId`
FROM
`plugin_translation` `plugin.translation`
WHERE
`plugin.translation`.language_id = : languageId
) `plugin.plugin_translation` ON `plugin.plugin_translation`.`plugin_id` = `plugin`.`id`
WHERE
(
`plugin`.`active` <=> : param_39e7cbfb6c2c49e983afe72254d07ad0
)
SELECT `plugin`.`id` as `plugin.id`, `plugin`.`base_class` as `plugin.baseClass`, `plugin`.`name` as `plugin.name`, `plugin`.`composer_name` as `plugin.composerName`, `plugin`.`autoload` as `plugin.autoload`, `plugin`.`active` as `plugin.active`, `plugin`.`managed_by_composer` as `plugin.managedByComposer`, `plugin`.`path` as `plugin.path`, `plugin`.`author` as `plugin.author`, `plugin`.`copyright` as `plugin.copyright`, `plugin`.`license` as `plugin.license`, `plugin`.`version` as `plugin.version`, `plugin`.`upgrade_version` as `plugin.upgradeVersion`, `plugin`.`installed_at` as `plugin.installedAt`, `plugin`.`upgraded_at` as `plugin.upgradedAt`, `plugin`.`icon` as `plugin.iconRaw`, `plugin`.`created_at` as `plugin.createdAt`, `plugin`.`updated_at` as `plugin.updatedAt`, `plugin.plugin_translation`.*, COALESCE(`plugin.translation.label`,`plugin.translation.label`) as `plugin.label`, COALESCE(`plugin.translation.description`,`plugin.translation.description`) as `plugin.description`, COALESCE(`plugin.translation.manufacturerLink`,`plugin.translation.manufacturerLink`) as `plugin.manufacturerLink`, COALESCE(`plugin.translation.supportLink`,`plugin.translation.supportLink`) as `plugin.supportLink`, COALESCE(`plugin.translation.changelog`,`plugin.translation.changelog`) as `plugin.changelog`, COALESCE(`plugin.translation.customFields`,`plugin.translation.customFields`) as `plugin.customFields` FROM `plugin` LEFT JOIN (SELECT `plugin.translation`.plugin_id, `plugin.translation`.label as `plugin.translation.label`, `plugin.translation`.description as `plugin.translation.description`, `plugin.translation`.manufacturer_link as `plugin.translation.manufacturerLink`, `plugin.translation`.support_link as `plugin.translation.supportLink`, `plugin.translation`.changelog as `plugin.translation.changelog`, `plugin.translation`.custom_fields as `plugin.translation.customFields`, `plugin.translation`.created_at as `plugin.translation.createdAt`, `plugin.translation`.updated_at as `plugin.translation.updatedAt`, `plugin.translation`.plugin_id as `plugin.translation.pluginId`, `plugin.translation`.language_id as `plugin.translation.languageId` FROM `plugin_translation` `plugin.translation` WHERE `plugin.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `plugin.plugin_translation` ON `plugin.plugin_translation`.`plugin_id` = `plugin`.`id` WHERE (`plugin`.`active` <=> 0);
array:19 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1274)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 210)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 277)"
3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetch (line 124)"
4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 94)"
5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::read (line 36)"
6 => "Shopware\Core\Profiling\Entity\EntityReaderProfiler::read (line 239)"
7 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::read (line 91)"
8 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 129)"
9 => "Shopware\Core\System\SystemConfig\SystemConfigLoader::getNotActivatedPlugins (line 109)"
10 => "Shopware\Core\System\SystemConfig\SystemConfigLoader::filterNotActivatedPlugins (line 84)"
11 => "Shopware\Core\System\SystemConfig\SystemConfigLoader::buildSystemConfigArray (line 71)"
12 => "Shopware\Core\System\SystemConfig\SystemConfigLoader::load (line 49)"
13 => "Shopware\Core\System\SystemConfig\CachedSystemConfigLoader::load (line 364)"
14 => "Shopware\Core\System\SystemConfig\SystemConfigService::load (line 95)"
15 => "Shopware\Core\System\SystemConfig\SystemConfigService::get (line 33)"
16 => "Shopware\Core\Framework\Routing\CanonicalRedirectService::getRedirect (line 147)"
17 => "Shopware\Core\HttpKernel::doHandle (line 80)"
18 => "Shopware\Core\HttpKernel::handle (line 48)"
]
|