1
0.15 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` ; ;
Copy
2
0.12 ms
SELECT `key` , `value` FROM `app_config`
SELECT `key` , `value` FROM `app_config` ;
Copy
3
0.08 ms
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
4
0.16 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 @@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' , '' ));
Copy
5
0.10 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 (? )) 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
6
0.07 ms
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"/»_ââšMpªXTÎ|ãâ\v "
b"¥\r ´@5\x03 F▓│\x11 ·Ôä\x14 íì "
"public/index.php "
"public/index.php/ "
]
SELECT id , path_info pathInfo , is_canonical isCanonical , sales_channel_id salesChannelId FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) AND ((sales_channel_id = 0xBE0DEF40350346B2B311FAE28414A18D OR sales_channel_id IS NULL )) AND ((seo_path_info = 'public/index.php' OR seo_path_info = 'public/index.php/' ));
Copy
7
0.06 ms
SELECT path_info pathInfo , seo_path_info seoPathInfo FROM seo_url WHERE (language_id = ? ) AND (sales_channel_id = ? ) AND (path_info = ? ) AND (is_canonical = 1 ) LIMIT 1
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"¥\r ´@5\x03 F▓│\x11 ·Ôä\x14 íì "
"/public/index.php "
]
SELECT path_info pathInfo , seo_path_info seoPathInfo FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) AND (sales_channel_id = 0xBE0DEF40350346B2B311FAE28414A18D ) AND (path_info = '/public/index.php' ) AND (is_canonical = 1 ) LIMIT 1 ;
Copy
8
0.10 ms
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
9
0.09 ms
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 :
[
"//public/index.php?s=/index/\think\app/invokefunction&function=call_user_func_array&vars[0]=md5&vars[1][]=Hello "
"/public/index.php?s=/index/\think\app/invokefunction&function=call_user_func_array&vars[0]=md5&vars[1][]=Hello "
"https://www.lerne.net/public/index.php?s=/index/\think\app/invokefunction&function=call_user_func_array&vars[0]=md5&vars[1][]=Hello "
"https://www.lerne.net//public/index.php?s=/index/\think\app/invokefunction&function=call_user_func_array&vars[0]=md5&vars[1][]=Hello "
"/public/index.php?s=/index/\think\app/invokefunction&function=call_user_func_array&vars[0]=md5&vars[1][]=Hello "
"//public/index.php?s=/index/\think\app/invokefunction&function=call_user_func_array&vars[0]=md5&vars[1][]=Hello "
"public/index.php?s=/index/\think\app/invokefunction&function=call_user_func_array&vars[0]=md5&vars[1][]=Hello "
true
b"¥\r ´@5\x03 F▓│\x11 ·Ôä\x14 íì "
null
]
SELECT `scop_platform_redirecter_redirect` . `id` FROM `scop_platform_redirecter_redirect` WHERE (`scop_platform_redirecter_redirect` . `sourceURL` IN ('//public/index.php?s=/index/\\think\\app/invokefunction&function=call_user_func_array&vars[0]=md5&vars[1][]=Hello' , '/public/index.php?s=/index/\\think\\app/invokefunction&function=call_user_func_array&vars[0]=md5&vars[1][]=Hello' , 'https://www.lerne.net/public/index.php?s=/index/\\think\\app/invokefunction&function=call_user_func_array&vars[0]=md5&vars[1][]=Hello' , 'https://www.lerne.net//public/index.php?s=/index/\\think\\app/invokefunction&function=call_user_func_array&vars[0]=md5&vars[1][]=Hello' , '/public/index.php?s=/index/\\think\\app/invokefunction&function=call_user_func_array&vars[0]=md5&vars[1][]=Hello' , '//public/index.php?s=/index/\\think\\app/invokefunction&function=call_user_func_array&vars[0]=md5&vars[1][]=Hello' , 'public/index.php?s=/index/\\think\\app/invokefunction&function=call_user_func_array&vars[0]=md5&vars[1][]=Hello' ) AND `scop_platform_redirecter_redirect` . `enabled` = 1 AND (`scop_platform_redirecter_redirect` . `salesChannelId` = 0xBE0DEF40350346B2B311FAE28414A18D OR `scop_platform_redirecter_redirect` . `salesChannelId` < = > NULL )) LIMIT 1 ;
Copy
10
0.07 ms
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` . `queryParamsHandling` IN (? , ? )) LIMIT 1
Parameters :
[
"//public/index.php "
"/public/index.php "
"https://www.lerne.net/public/index.php "
"https://www.lerne.net//public/index.php "
"/public/index.php "
"//public/index.php "
"public/index.php "
true
1
2
]
SELECT `scop_platform_redirecter_redirect` . `id` FROM `scop_platform_redirecter_redirect` WHERE (`scop_platform_redirecter_redirect` . `sourceURL` IN ('//public/index.php' , '/public/index.php' , 'https://www.lerne.net/public/index.php' , 'https://www.lerne.net//public/index.php' , '/public/index.php' , '//public/index.php' , 'public/index.php' ) AND `scop_platform_redirecter_redirect` . `enabled` = 1 AND `scop_platform_redirecter_redirect` . `queryParamsHandling` IN (1 , 2 )) LIMIT 1 ;
Copy