1120.45 ms (99.77%)
1
"COMMIT"
0.60 ms (0.05%)
1
SELECT u0_ . id AS id_0 , u0_ . email AS email_1 , u0_ . username AS username_2 , u0_ . roles AS roles_3 , u0_ . password AS password_4 , u0_ . last_name AS last_name_5 , u0_ . first_name AS first_name_6 , u0_ . street AS street_7 , u0_ . house_number AS house_number_8 , u0_ . box_number AS box_number_9 , u0_ . postal_code AS postal_code_10 , u0_ . city AS city_11 , u0_ . country AS country_12 , u0_ . phone_number AS phone_number_13 , u0_ . locale AS locale_14 , u0_ . is_verified AS is_verified_15 , u0_ . is_approved AS is_approved_16 , u0_ . is_active AS is_active_17 , u0_ . is_first_super_admin AS is_first_super_admin_18 , u0_ . email_verified_at AS email_verified_at_19 , u0_ . approved_at AS approved_at_20 , u0_ . created_at AS created_at_21 , u0_ . last_login_at AS last_login_at_22 , u0_ . birth_date AS birth_date_23 , u0_ . profile_photo AS profile_photo_24 , u0_ . latitude AS latitude_25 , u0_ . longitude AS longitude_26 FROM `user` u0_ WHERE u0_ . roles LIKE ? ORDER BY u0_ . last_name ASC
Parameters :
[
"%ROLE_SUPER_ADMIN% "
]
SELECT u0_ . id AS id_0 , u0_ . email AS email_1 , u0_ . username AS username_2 , u0_ . roles AS roles_3 , u0_ . password AS password_4 , u0_ . last_name AS last_name_5 , u0_ . first_name AS first_name_6 , u0_ . street AS street_7 , u0_ . house_number AS house_number_8 , u0_ . box_number AS box_number_9 , u0_ . postal_code AS postal_code_10 , u0_ . city AS city_11 , u0_ . country AS country_12 , u0_ . phone_number AS phone_number_13 , u0_ . locale AS locale_14 , u0_ . is_verified AS is_verified_15 , u0_ . is_approved AS is_approved_16 , u0_ . is_active AS is_active_17 , u0_ . is_first_super_admin AS is_first_super_admin_18 , u0_ . email_verified_at AS email_verified_at_19 , u0_ . approved_at AS approved_at_20 , u0_ . created_at AS created_at_21 , u0_ . last_login_at AS last_login_at_22 , u0_ . birth_date AS birth_date_23 , u0_ . profile_photo AS profile_photo_24 , u0_ . latitude AS latitude_25 , u0_ . longitude AS longitude_26 FROM `user` u0_ WHERE u0_ . roles LIKE '%ROLE_SUPER_ADMIN%' ORDER BY u0_ . last_name ASC ;
Copy
0.43 ms (0.04%)
1
SELECT t0 . id AS id_1 , t0 . md5 AS md5_2 , t0 . sha1 AS sha1_3 , t0 . sha224 AS sha224_4 , t0 . sha256 AS sha256_5 , t0 . sha384 AS sha384_6 , t0 . sha512 AS sha512_7 , t0 . sha3 AS sha3_8 , t0 . bcrypt AS bcrypt_9 , t0 . scrypt AS scrypt_10 , t0 . argon2 AS argon2_11 , t0 . argon2i AS argon2i_12 , t0 . argon2d AS argon2d_13 , t0 . argon2id AS argon2id_14 , t0 . pbkdf2 AS pbkdf2_15 , t0 . whirlpool AS whirlpool_16 , t0 . ntlm AS ntlm_17 , t0 . blowfish AS blowfish_18 , t0 . crypt AS crypt_19 , t0 . created_at AS created_at_20 , t0 . updated_at AS updated_at_21 , t0 . user_id AS user_id_22 FROM hash_storage t0 WHERE t0 . user_id = ?
SELECT t0 . id AS id_1 , t0 . md5 AS md5_2 , t0 . sha1 AS sha1_3 , t0 . sha224 AS sha224_4 , t0 . sha256 AS sha256_5 , t0 . sha384 AS sha384_6 , t0 . sha512 AS sha512_7 , t0 . sha3 AS sha3_8 , t0 . bcrypt AS bcrypt_9 , t0 . scrypt AS scrypt_10 , t0 . argon2 AS argon2_11 , t0 . argon2i AS argon2i_12 , t0 . argon2d AS argon2d_13 , t0 . argon2id AS argon2id_14 , t0 . pbkdf2 AS pbkdf2_15 , t0 . whirlpool AS whirlpool_16 , t0 . ntlm AS ntlm_17 , t0 . blowfish AS blowfish_18 , t0 . crypt AS crypt_19 , t0 . created_at AS created_at_20 , t0 . updated_at AS updated_at_21 , t0 . user_id AS user_id_22 FROM hash_storage t0 WHERE t0 . user_id = 1 ;
Copy
0.41 ms (0.04%)
1
INSERT INTO audit_log (action , details , ip_address , user_agent , created_at , type , device_brand , device_model , os_name , os_version , browser_name , browser_version , user_id ) VALUES (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
"http_error_404 "
"""
404: Not Found\n
\n
URL: /robots.txt\n
Method: GET\n
\n
Exception: Symfony\Component\HttpKernel\Exception\NotFoundHttpException\n
Message: No route found for "GET https://server.dmqode.be/robots.txt"\n
File: /var/www/server/user-management-system/vendor/symfony/http-kernel/EventListener/RouterListener.php (line 149)\n
\n
Request Headers:\n
host: server.dmqode.be\n
accept: */*\n
user-agent: Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com)\n
accept-charset: utf-8;q=0.7,iso-8859-1;q=0.2,*;q=0.1\n
x-php-ob-level: 1\n
\n
Full User-Agent: Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com)
"""
"216.244.66.247 "
"Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com) "
"2026-02-12 05:20:33 "
"error "
"Spider "
"Desktop "
"Unknown "
"Unknown "
"DotBot "
"1.2 "
1
]
INSERT INTO audit_log (action , details , ip_address , user_agent , created_at , type , device_brand , device_model , os_name , os_version , browser_name , browser_version , user_id ) VALUES ('http_error_404' , '404: Not Found
URL: /robots.txt
Method: GET
Exception: Symfony\\Component\\HttpKernel\\Exception\\NotFoundHttpException
Message: No route found for \"GET https://server.dmqode.be/robots.txt\"
File: /var/www/server/user-management-system/vendor/symfony/http-kernel/EventListener/RouterListener.php (line 149)
Request Headers:
host: server.dmqode.be
accept: */*
user-agent: Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com)
accept-charset: utf-8;q=0.7,iso-8859-1;q=0.2,*;q=0.1
x-php-ob-level: 1
Full User-Agent: Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com)' , '216.244.66.247' , 'Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com)' , '2026-02-12 05:20:33' , 'error' , 'Spider' , 'Desktop' , 'Unknown' , 'Unknown' , 'DotBot' , '1.2' , 1 );
Copy
0.36 ms (0.03%)
1
UPDATE `user` SET latitude = ? , longitude = ? WHERE id = ?
Parameters :
[
50.8661601
4.3977835
1
]
UPDATE `user` SET latitude = 50.8661601 , longitude = 4.3977835 WHERE id = 1 ;
Copy
0.21 ms (0.02%)
1
SELECT t0 . id AS id_1 , t0 . necessary_cookies AS necessary_cookies_2 , t0 . preference_cookies AS preference_cookies_3 , t0 . statistics_cookies AS statistics_cookies_4 , t0 . marketing_cookies AS marketing_cookies_5 , t0 . geolocation_enabled AS geolocation_enabled_6 , t0 . geolocation_enabled_at AS geolocation_enabled_at_7 , t0 . terms_accepted AS terms_accepted_8 , t0 . terms_accepted_at AS terms_accepted_at_9 , t0 . cookie_preferences_updated_at AS cookie_preferences_updated_at_10 , t0 . created_at AS created_at_11 , t0 . user_id AS user_id_12 FROM `user_consent` t0 WHERE t0 . user_id = ?
SELECT t0 . id AS id_1 , t0 . necessary_cookies AS necessary_cookies_2 , t0 . preference_cookies AS preference_cookies_3 , t0 . statistics_cookies AS statistics_cookies_4 , t0 . marketing_cookies AS marketing_cookies_5 , t0 . geolocation_enabled AS geolocation_enabled_6 , t0 . geolocation_enabled_at AS geolocation_enabled_at_7 , t0 . terms_accepted AS terms_accepted_8 , t0 . terms_accepted_at AS terms_accepted_at_9 , t0 . cookie_preferences_updated_at AS cookie_preferences_updated_at_10 , t0 . created_at AS created_at_11 , t0 . user_id AS user_id_12 FROM `user_consent` t0 WHERE t0 . user_id = 1 ;
Copy
0.21 ms (0.02%)
1
"START TRANSACTION"
"START TRANSACTION" ;
Copy
0.17 ms (0.02%)
1
RELEASE SAVEPOINT DOCTRINE_2
RELEASE SAVEPOINT DOCTRINE_2 ;
Copy
0.12 ms (0.01%)
1
SAVEPOINT DOCTRINE_2
SAVEPOINT DOCTRINE_2 ;
Copy