1.88 ms (36.27%)
1
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 ;
Copy
0.94 ms (18.20%)
1
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 (? )) AND (sales_channel . active )
Parameters :
[
"8a243080f92e4c719546314b577cf82b "
]
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 );
Copy
0.64 ms (12.41%)
1
SELECT id , path_info pathInfo , is_canonical isCanonical , sales_channel_id salesChannelId FROM seo_url WHERE (language_id = ? ) AND ((sales_channel_id = ? OR sales_channel_id IS NULL )) AND ((seo_path_info = ? OR seo_path_info = ? ))
Parameters :
[
b"\x02 0¨(çñA —O®8ͬÞÛ "
b">{k'Ô\x1E O‡!¼GnÏMj "
"Caparol-Capacryl-Haftprimer-2-5L-weiss-Grundierung-Haftvermittler "
"Caparol-Capacryl-Haftprimer-2-5L-weiss-Grundierung-Haftvermittler/ "
]
SELECT id , path_info pathInfo , is_canonical isCanonical , sales_channel_id salesChannelId FROM seo_url WHERE (language_id = 0x0230A828E7F14120974FAE38CDACDEDB ) AND ((sales_channel_id = 0x3E7B6B27D41E4F87AD21BC476ECF4D6A OR sales_channel_id IS NULL )) AND ((seo_path_info = 'Caparol-Capacryl-Haftprimer-2-5L-weiss-Grundierung-Haftvermittler' OR seo_path_info = 'Caparol-Capacryl-Haftprimer-2-5L-weiss-Grundierung-Haftvermittler/' ));
Copy
0.47 ms (9.03%)
1
SELECT `scop_platform_redirecter_redirect` . `id` FROM `scop_platform_redirecter_redirect` WHERE ((`scop_platform_redirecter_redirect` . `sourceURL` IN (? , ? , ? , ? , ? , ? , ? )) AND `scop_platform_redirecter_redirect` . `enabled` = ? AND (`scop_platform_redirecter_redirect` . `salesChannelId` = ? OR `scop_platform_redirecter_redirect` . `salesChannelId` < = > ? )) LIMIT 1
Parameters :
[
"//Caparol-Capacryl-Haftprimer-2-5L-weiss-Grundierung-Haftvermittler "
"/Caparol-Capacryl-Haftprimer-2-5L-weiss-Grundierung-Haftvermittler "
"https://farbklecks24.dev.shopware.data-blue.de/Caparol-Capacryl-Haftprimer-2-5L-weiss-Grundierung-Haftvermittler "
"https://farbklecks24.dev.shopware.data-blue.de//Caparol-Capacryl-Haftprimer-2-5L-weiss-Grundierung-Haftvermittler "
"/Caparol-Capacryl-Haftprimer-2-5L-weiss-Grundierung-Haftvermittler "
"//Caparol-Capacryl-Haftprimer-2-5L-weiss-Grundierung-Haftvermittler "
"Caparol-Capacryl-Haftprimer-2-5L-weiss-Grundierung-Haftvermittler "
true
b">{k'Ô\x1E O‡!¼GnÏMj "
null
]
SELECT `scop_platform_redirecter_redirect` . `id` FROM `scop_platform_redirecter_redirect` WHERE ((`scop_platform_redirecter_redirect` . `sourceURL` IN ('//Caparol-Capacryl-Haftprimer-2-5L-weiss-Grundierung-Haftvermittler' , '/Caparol-Capacryl-Haftprimer-2-5L-weiss-Grundierung-Haftvermittler' , 'https://farbklecks24.dev.shopware.data-blue.de/Caparol-Capacryl-Haftprimer-2-5L-weiss-Grundierung-Haftvermittler' , 'https://farbklecks24.dev.shopware.data-blue.de//Caparol-Capacryl-Haftprimer-2-5L-weiss-Grundierung-Haftvermittler' , '/Caparol-Capacryl-Haftprimer-2-5L-weiss-Grundierung-Haftvermittler' , '//Caparol-Capacryl-Haftprimer-2-5L-weiss-Grundierung-Haftvermittler' , 'Caparol-Capacryl-Haftprimer-2-5L-weiss-Grundierung-Haftvermittler' )) AND `scop_platform_redirecter_redirect` . `enabled` = 1 AND (`scop_platform_redirecter_redirect` . `salesChannelId` = 0x3E7B6B27D41E4F87AD21BC476ECF4D6A OR `scop_platform_redirecter_redirect` . `salesChannelId` < = > NULL )) LIMIT 1 ;
Copy
0.40 ms (7.73%)
1
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` ; ;
Copy
0.34 ms (6.49%)
1
SELECT `key` , `value` FROM `app_config`
SELECT `key` , `value` FROM `app_config` ;
Copy
0.31 ms (5.93%)
1
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 ;
;
Copy
0.20 ms (3.94%)
1
SELECT `name` , `path` , `author` , `self_managed`
FROM `app`
WHERE `active` = 1
SELECT `name` , `path` , `author` , `self_managed`
FROM `app`
WHERE `active` = 1
;
Copy