Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 19
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine 3
• Debug
• Messages
• Emails
• Notifications
• EasyAdmin
• JMS Serializer 0 + 0
• Configuration

Query Metrics

SELECT o0_.id AS id_0, o0_.name AS name_1, o0_.name_hash AS name_hash_2, o0_.user_name AS user_name_3, o0_.user_name_hash AS user_name_hash_4, o0_.password AS password_5, o0_.token AS token_6, o0_.api_type AS api_type_7, o0_.base_url AS base_url_8, o0_.api_key AS api_key_9, o0_.status AS status_10, o0_.channel AS channel_11, o0_.short_name AS short_name_12 FROM outside_system o0_ WHERE o0_.user_name_hash = ?

[
  "0df29046a9d59c5039e39d69a53a3ae3daafba896e13724d6edeaf842ab88d095f5d9bfc9b3d77252e7934637e374c83710e15766f3512703f1531685471cd95"
]

SELECT
  o0_.id AS id_0,
  o0_.name AS name_1,
  o0_.name_hash AS name_hash_2,
  o0_.user_name AS user_name_3,
  o0_.user_name_hash AS user_name_hash_4,
  o0_.password AS password_5,
  o0_.token AS token_6,
  o0_.api_type AS api_type_7,
  o0_.base_url AS base_url_8,
  o0_.api_key AS api_key_9,
  o0_.status AS status_10,
  o0_.channel AS channel_11,
  o0_.short_name AS short_name_12
FROM
  outside_system o0_
WHERE
  o0_.user_name_hash = ?

SELECT o0_.id AS id_0, o0_.name AS name_1, o0_.name_hash AS name_hash_2, o0_.user_name AS user_name_3, o0_.user_name_hash AS user_name_hash_4, o0_.password AS password_5, o0_.token AS token_6, o0_.api_type AS api_type_7, o0_.base_url AS base_url_8, o0_.api_key AS api_key_9, o0_.status AS status_10, o0_.channel AS channel_11, o0_.short_name AS short_name_12 FROM outside_system o0_ WHERE o0_.user_name_hash = '0df29046a9d59c5039e39d69a53a3ae3daafba896e13724d6edeaf842ab88d095f5d9bfc9b3d77252e7934637e374c83710e15766f3512703f1531685471cd95';

SELECT u0_.user_mob_device_id AS user_mob_device_id_0, u0_.user_mob_device_uuid AS user_mob_device_uuid_1, u0_.user_mob_device_push_notif_id AS user_mob_device_push_notif_id_2, u0_.user_mob_device_created_at AS user_mob_device_created_at_3, u0_.user_mob_device_refreshed_at AS user_mob_device_refreshed_at_4, u0_.user_mob_device_default_lang AS user_mob_device_default_lang_5, u0_.user_mob_device_sec_token AS user_mob_device_sec_token_6, u0_.user_mob_device_sec_token_hash AS user_mob_device_sec_token_hash_7, u0_.user_mob_device_app_version AS user_mob_device_app_version_8, u0_.user_mob_device_app_code AS user_mob_device_app_code_9, u0_.user_mob_device_app_build AS user_mob_device_app_build_10, u0_.user_mob_device_model AS user_mob_device_model_11, u0_.user_mob_device_os AS user_mob_device_os_12, u0_.user_mob_device_ip AS user_mob_device_ip_13, u0_.user_mob_device_session_counter AS user_mob_device_session_counter_14, u0_.user_mob_device_help_token AS user_mob_device_help_token_15, u0_.is_emulated AS is_emulated_16, u0_.user_mob_device_user_id AS user_mob_device_user_id_17 FROM user_mob_device u0_ WHERE u0_.user_mob_device_uuid = ? AND (u0_.user_mob_device_sec_token_hash = ? OR 1 = 0)

[
  "e59d2f42159214ec"
  "9cc6e4603bfebd60f56705b6c818e9579238709baf62a28d8331f265f4e6eee410cd8a1df3ec6775a58dbaa4d64103a99155c726c7c9fec36f0c987b97b50f6d"
]

SELECT
  u0_.user_mob_device_id AS user_mob_device_id_0,
  u0_.user_mob_device_uuid AS user_mob_device_uuid_1,
  u0_.user_mob_device_push_notif_id AS user_mob_device_push_notif_id_2,
  u0_.user_mob_device_created_at AS user_mob_device_created_at_3,
  u0_.user_mob_device_refreshed_at AS user_mob_device_refreshed_at_4,
  u0_.user_mob_device_default_lang AS user_mob_device_default_lang_5,
  u0_.user_mob_device_sec_token AS user_mob_device_sec_token_6,
  u0_.user_mob_device_sec_token_hash AS user_mob_device_sec_token_hash_7,
  u0_.user_mob_device_app_version AS user_mob_device_app_version_8,
  u0_.user_mob_device_app_code AS user_mob_device_app_code_9,
  u0_.user_mob_device_app_build AS user_mob_device_app_build_10,
  u0_.user_mob_device_model AS user_mob_device_model_11,
  u0_.user_mob_device_os AS user_mob_device_os_12,
  u0_.user_mob_device_ip AS user_mob_device_ip_13,
  u0_.user_mob_device_session_counter AS user_mob_device_session_counter_14,
  u0_.user_mob_device_help_token AS user_mob_device_help_token_15,
  u0_.is_emulated AS is_emulated_16,
  u0_.user_mob_device_user_id AS user_mob_device_user_id_17
FROM
  user_mob_device u0_
WHERE
  u0_.user_mob_device_uuid = ?
  AND (
    u0_.user_mob_device_sec_token_hash = ?
    OR 1 = 0
  )

SELECT u0_.user_mob_device_id AS user_mob_device_id_0, u0_.user_mob_device_uuid AS user_mob_device_uuid_1, u0_.user_mob_device_push_notif_id AS user_mob_device_push_notif_id_2, u0_.user_mob_device_created_at AS user_mob_device_created_at_3, u0_.user_mob_device_refreshed_at AS user_mob_device_refreshed_at_4, u0_.user_mob_device_default_lang AS user_mob_device_default_lang_5, u0_.user_mob_device_sec_token AS user_mob_device_sec_token_6, u0_.user_mob_device_sec_token_hash AS user_mob_device_sec_token_hash_7, u0_.user_mob_device_app_version AS user_mob_device_app_version_8, u0_.user_mob_device_app_code AS user_mob_device_app_code_9, u0_.user_mob_device_app_build AS user_mob_device_app_build_10, u0_.user_mob_device_model AS user_mob_device_model_11, u0_.user_mob_device_os AS user_mob_device_os_12, u0_.user_mob_device_ip AS user_mob_device_ip_13, u0_.user_mob_device_session_counter AS user_mob_device_session_counter_14, u0_.user_mob_device_help_token AS user_mob_device_help_token_15, u0_.is_emulated AS is_emulated_16, u0_.user_mob_device_user_id AS user_mob_device_user_id_17 FROM user_mob_device u0_ WHERE u0_.user_mob_device_uuid = 'e59d2f42159214ec' AND (u0_.user_mob_device_sec_token_hash = '9cc6e4603bfebd60f56705b6c818e9579238709baf62a28d8331f265f4e6eee410cd8a1df3ec6775a58dbaa4d64103a99155c726c7c9fec36f0c987b97b50f6d' OR 1 = 0);

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

UPDATE outside_system SET name = ?, user_name = ? WHERE id = ?

[
  "def502005f94fd0eb60f3a5126e770dcf4697aa7bc84ef4ca25b7afb4ff7c947fd52385cfde805101e2d8730c4645573a6f61db0c60d8d2c240f5e7b17f6f0f88fd68ccc75b8d4d59c02857e60a593ec44d6a6761c3e1d53f9a39d8899ab4c7505fd7aaa78"
  "def5020011b0de81a654d3579664228554ab90af23c9772e4ddfb38ca06921c4a52f865535d8cc638e869e81f54b50e832f81c3725691cecf59fba7f06ad6e5c9fa4b9e8ddf5ed997423553225c08c87509f030e22d90e32e5d28ff3"
  1
]

UPDATE
  outside_system
SET
  name = ?,
  user_name = ?
WHERE
  id = ?

UPDATE outside_system SET name = 'def502005f94fd0eb60f3a5126e770dcf4697aa7bc84ef4ca25b7afb4ff7c947fd52385cfde805101e2d8730c4645573a6f61db0c60d8d2c240f5e7b17f6f0f88fd68ccc75b8d4d59c02857e60a593ec44d6a6761c3e1d53f9a39d8899ab4c7505fd7aaa78', user_name = 'def5020011b0de81a654d3579664228554ab90af23c9772e4ddfb38ca06921c4a52f865535d8cc638e869e81f54b50e832f81c3725691cecf59fba7f06ad6e5c9fa4b9e8ddf5ed997423553225c08c87509f030e22d90e32e5d28ff3' WHERE id = 1;

UPDATE user_mob_device SET user_mob_device_sec_token = ? WHERE user_mob_device_id = ?

[
  "def50200905acff51931c2167cef269b64c2d0d6872bc45cc203688cac46baeef50a011fd96a0b8b15074ad322a80bfc9e0c5ebbc068b6a465ee71daf693a77b7990225cd079c82ced53bc209ebabe9a308d07c8da56739ff9febab404aea9f5cac5a437add124b70298ef21cceb1756163dd8fa6dd723d8fbd4392fc594d692e0ec50627889fe72ef778ad8dd8b99c0bd139aac5968b75b8cf5345ba5c8c1d0f22cfca31683416db82e845c740464b3f1a636fadb37f4f93f1848a717b15485e0a5fb395e7dc0c2d2122d66bf97dca058eb1024"
  102
]

UPDATE
  user_mob_device
SET
  user_mob_device_sec_token = ?
WHERE
  user_mob_device_id = ?

UPDATE user_mob_device SET user_mob_device_sec_token = 'def50200905acff51931c2167cef269b64c2d0d6872bc45cc203688cac46baeef50a011fd96a0b8b15074ad322a80bfc9e0c5ebbc068b6a465ee71daf693a77b7990225cd079c82ced53bc209ebabe9a308d07c8da56739ff9febab404aea9f5cac5a437add124b70298ef21cceb1756163dd8fa6dd723d8fbd4392fc594d692e0ec50627889fe72ef778ad8dd8b99c0bd139aac5968b75b8cf5345ba5c8c1d0f22cfca31683416db82e845c740464b3f1a636fadb37f4f93f1848a717b15485e0a5fb395e7dc0c2d2122d66bf97dca058eb1024' WHERE user_mob_device_id = 102;

"COMMIT"

[]

"COMMIT"

"COMMIT";