Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception 1
• Logs 105
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• VichUploader
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.variable AS variable_2, t0.subkey AS subkey_3, t0.type AS type_4, t0.category AS category_5, t0.selected_value AS selected_value_6, t0.title AS title_7, t0.comment AS comment_8, t0.scope AS scope_9, t0.subkeytext AS subkeytext_10, t0.access_url_changeable AS access_url_changeable_11, t0.access_url_locked AS access_url_locked_12, t0.access_url AS access_url_13 FROM settings t0

[]

SELECT
  t0.id AS id_1,
  t0.variable AS variable_2,
  t0.subkey AS subkey_3,
  t0.type AS type_4,
  t0.category AS category_5,
  t0.selected_value AS selected_value_6,
  t0.title AS title_7,
  t0.comment AS comment_8,
  t0.scope AS scope_9,
  t0.subkeytext AS subkeytext_10,
  t0.access_url_changeable AS access_url_changeable_11,
  t0.access_url_locked AS access_url_locked_12,
  t0.access_url AS access_url_13
FROM
  settings t0

SELECT t0.id AS id_1, t0.variable AS variable_2, t0.subkey AS subkey_3, t0.type AS type_4, t0.category AS category_5, t0.selected_value AS selected_value_6, t0.title AS title_7, t0.comment AS comment_8, t0.scope AS scope_9, t0.subkeytext AS subkeytext_10, t0.access_url_changeable AS access_url_changeable_11, t0.access_url_locked AS access_url_locked_12, t0.access_url AS access_url_13 FROM settings t0;

SELECT t0.id AS id_1, t0.username AS username_2, t0.api_token AS api_token_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.website AS website_6, t0.biography AS biography_7, t0.locale AS locale_8, t0.password AS password_9, t0.username_canonical AS username_canonical_10, t0.timezone AS timezone_11, t0.email_canonical AS email_canonical_12, t0.email AS email_13, t0.locked AS locked_14, t0.expired AS expired_15, t0.credentials_expired AS credentials_expired_16, t0.credentials_expire_at AS credentials_expire_at_17, t0.date_of_birth AS date_of_birth_18, t0.expires_at AS expires_at_19, t0.phone AS phone_20, t0.address AS address_21, t0.salt AS salt_22, t0.gender AS gender_23, t0.last_login AS last_login_24, t0.confirmation_token AS confirmation_token_25, t0.password_requested_at AS password_requested_at_26, t0.roles AS roles_27, t0.profile_completed AS profile_completed_28, t0.auth_source AS auth_source_29, t0.status AS status_30, t0.official_code AS official_code_31, t0.picture_uri AS picture_uri_32, t0.creator_id AS creator_id_33, t0.competences AS competences_34, t0.diplomas AS diplomas_35, t0.openarea AS openarea_36, t0.teach AS teach_37, t0.productions AS productions_38, t0.registration_date AS registration_date_39, t0.expiration_date AS expiration_date_40, t0.active AS active_41, t0.openid AS openid_42, t0.theme AS theme_43, t0.hr_dept_id AS hr_dept_id_44, t0.uuid AS uuid_45, t0.created_at AS created_at_46, t0.updated_at AS updated_at_47, t0.resource_node_id AS resource_node_id_48, t49.id AS id_50, t49.user_id AS user_id_51 FROM user t0 LEFT JOIN admin t49 ON t49.user_id = t0.id WHERE t0.status = ? ORDER BY t0.registration_date ASC LIMIT 1

[
  6
]

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.api_token AS api_token_3,
  t0.firstname AS firstname_4,
  t0.lastname AS lastname_5,
  t0.website AS website_6,
  t0.biography AS biography_7,
  t0.locale AS locale_8,
  t0.password AS password_9,
  t0.username_canonical AS username_canonical_10,
  t0.timezone AS timezone_11,
  t0.email_canonical AS email_canonical_12,
  t0.email AS email_13,
  t0.locked AS locked_14,
  t0.expired AS expired_15,
  t0.credentials_expired AS credentials_expired_16,
  t0.credentials_expire_at AS credentials_expire_at_17,
  t0.date_of_birth AS date_of_birth_18,
  t0.expires_at AS expires_at_19,
  t0.phone AS phone_20,
  t0.address AS address_21,
  t0.salt AS salt_22,
  t0.gender AS gender_23,
  t0.last_login AS last_login_24,
  t0.confirmation_token AS confirmation_token_25,
  t0.password_requested_at AS password_requested_at_26,
  t0.roles AS roles_27,
  t0.profile_completed AS profile_completed_28,
  t0.auth_source AS auth_source_29,
  t0.status AS status_30,
  t0.official_code AS official_code_31,
  t0.picture_uri AS picture_uri_32,
  t0.creator_id AS creator_id_33,
  t0.competences AS competences_34,
  t0.diplomas AS diplomas_35,
  t0.openarea AS openarea_36,
  t0.teach AS teach_37,
  t0.productions AS productions_38,
  t0.registration_date AS registration_date_39,
  t0.expiration_date AS expiration_date_40,
  t0.active AS active_41,
  t0.openid AS openid_42,
  t0.theme AS theme_43,
  t0.hr_dept_id AS hr_dept_id_44,
  t0.uuid AS uuid_45,
  t0.created_at AS created_at_46,
  t0.updated_at AS updated_at_47,
  t0.resource_node_id AS resource_node_id_48,
  t49.id AS id_50,
  t49.user_id AS user_id_51
FROM
  user t0
  LEFT JOIN admin t49 ON t49.user_id = t0.id
WHERE
  t0.status = ?
ORDER BY
  t0.registration_date ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.username AS username_2, t0.api_token AS api_token_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.website AS website_6, t0.biography AS biography_7, t0.locale AS locale_8, t0.password AS password_9, t0.username_canonical AS username_canonical_10, t0.timezone AS timezone_11, t0.email_canonical AS email_canonical_12, t0.email AS email_13, t0.locked AS locked_14, t0.expired AS expired_15, t0.credentials_expired AS credentials_expired_16, t0.credentials_expire_at AS credentials_expire_at_17, t0.date_of_birth AS date_of_birth_18, t0.expires_at AS expires_at_19, t0.phone AS phone_20, t0.address AS address_21, t0.salt AS salt_22, t0.gender AS gender_23, t0.last_login AS last_login_24, t0.confirmation_token AS confirmation_token_25, t0.password_requested_at AS password_requested_at_26, t0.roles AS roles_27, t0.profile_completed AS profile_completed_28, t0.auth_source AS auth_source_29, t0.status AS status_30, t0.official_code AS official_code_31, t0.picture_uri AS picture_uri_32, t0.creator_id AS creator_id_33, t0.competences AS competences_34, t0.diplomas AS diplomas_35, t0.openarea AS openarea_36, t0.teach AS teach_37, t0.productions AS productions_38, t0.registration_date AS registration_date_39, t0.expiration_date AS expiration_date_40, t0.active AS active_41, t0.openid AS openid_42, t0.theme AS theme_43, t0.hr_dept_id AS hr_dept_id_44, t0.uuid AS uuid_45, t0.created_at AS created_at_46, t0.updated_at AS updated_at_47, t0.resource_node_id AS resource_node_id_48, t49.id AS id_50, t49.user_id AS user_id_51 FROM user t0 LEFT JOIN admin t49 ON t49.user_id = t0.id WHERE t0.status = 6 ORDER BY t0.registration_date ASC LIMIT 1;

SELECT t0.login_id AS login_id_1, t0.login_date AS login_date_2, t0.user_ip AS user_ip_3, t0.logout_date AS logout_date_4, t0.login_user_id AS login_user_id_5 FROM track_e_login t0 WHERE t0.user_ip = ? AND t0.login_user_id = ? LIMIT 1

[
  "3.133.129.110"
  2
]

SELECT
  t0.login_id AS login_id_1,
  t0.login_date AS login_date_2,
  t0.user_ip AS user_ip_3,
  t0.logout_date AS logout_date_4,
  t0.login_user_id AS login_user_id_5
FROM
  track_e_login t0
WHERE
  t0.user_ip = ?
  AND t0.login_user_id = ?
LIMIT
  1

SELECT t0.login_id AS login_id_1, t0.login_date AS login_date_2, t0.user_ip AS user_ip_3, t0.logout_date AS logout_date_4, t0.login_user_id AS login_user_id_5 FROM track_e_login t0 WHERE t0.user_ip = '3.133.129.110' AND t0.login_user_id = 2 LIMIT 1;

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO track_e_login (login_date, user_ip, logout_date, login_user_id) VALUES (?, ?, ?, ?)

[
  "2024-11-15 01:35:52"
  "3.133.129.110"
  null
  2
]

INSERT INTO track_e_login (
  login_date, user_ip, logout_date,
  login_user_id
)
VALUES
  (?, ?, ?, ?)

INSERT INTO track_e_login (login_date, user_ip, logout_date, login_user_id) VALUES ('2024-11-15 01:35:52', '3.133.129.110', NULL, 2);

"COMMIT"

[]

"COMMIT"

"COMMIT";

SELECT l0_.id AS id_0, l0_.original_name AS original_name_1, l0_.english_name AS english_name_2, l0_.isocode AS isocode_3, l0_.available AS available_4 FROM language l0_ WHERE l0_.available = 1

[]

SELECT
  l0_.id AS id_0,
  l0_.original_name AS original_name_1,
  l0_.english_name AS english_name_2,
  l0_.isocode AS isocode_3,
  l0_.available AS available_4
FROM
  language l0_
WHERE
  l0_.available = 1

SELECT l0_.id AS id_0, l0_.original_name AS original_name_1, l0_.english_name AS english_name_2, l0_.isocode AS isocode_3, l0_.available AS available_4 FROM language l0_ WHERE l0_.available = 1;