Symfony Profiler

[
  "route" => "user_todolist_list"
  "route_parameters" => [
    "_route" => "user_todolist_list"
    "_controller" => "App\Controller\User\UserToDoListController::list"
  ]
  "request_uri" => "https://software.dualmoto.it/utente/mansionario/"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 3
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Http\Authenticator\Token\PostAuthenticationToken"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "localhost"
    "port" => 3306
    "user" => "dualmoto_user"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "dualmoto_db"
    "serverVersion" => "11.8.8-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.surname AS surname_4, t0.password AS password_5, t0.role AS role_6, t0.one_time_code AS one_time_code_7, t0.expiration_one_time_code AS expiration_one_time_code_8, t0.is_active AS is_active_9, t0.is_account_activation AS is_account_activation_10, t0.is_email_notification_active AS is_email_notification_active_11, t0.theme AS theme_12, t0.directory_path AS directory_path_13, t14.id AS id_15, t14.avatar AS avatar_16, t14.user_id AS user_id_17, t18.id AS id_19, t18.is_terms_accepted AS is_terms_accepted_20, t18.datetime_last_update AS datetime_last_update_21, t18.user_id AS user_id_22 FROM dm_user t0 LEFT JOIN dm_user_profile t14 ON t14.user_id = t0.id LEFT JOIN dm_user_privacy t18 ON t18.user_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => "3"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#880
      +name: "STRING"
    }
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "rporrati@rpgmultimedia.it"
]

[
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3, t0.permission_id AS permission_id_4 FROM dm_join_table_user_permission t0 WHERE t0.user_id = ?"
  "params" => [
    1 => "3"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#880
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#880
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#880
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#880
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#880
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#880
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#880
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?"
  "params" => [
    1 => 7
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#880
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?"
  "params" => [
    1 => 8
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#880
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?"
  "params" => [
    1 => 9
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#880
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?"
  "params" => [
    1 => 10
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#880
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?"
  "params" => [
    1 => 11
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#880
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?"
  "params" => [
    1 => 12
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#880
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?"
  "params" => [
    1 => 13
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#880
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?"
  "params" => [
    1 => 14
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#880
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?"
  "params" => [
    1 => 15
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#880
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?"
  "params" => [
    1 => 16
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#880
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?"
  "params" => [
    1 => 17
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#880
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?"
  "params" => [
    1 => 18
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#880
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?"
  "params" => [
    1 => 19
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#880
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?"
  "params" => [
    1 => 21
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#880
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?"
  "params" => [
    1 => 22
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#880
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?"
  "params" => [
    1 => 23
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#880
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?"
  "params" => [
    1 => 24
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#880
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM dm_permission t0 WHERE t0.id = ?"
  "params" => [
    1 => 25
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#880
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT count(DISTINCT d0_.id) AS sclr_0 FROM dm_to_do_list d0_"
]

[
  "sql" => "SELECT DISTINCT d0_.id AS id_0, d0_.name AS name_1 FROM dm_to_do_list d0_ ORDER BY d0_.name ASC LIMIT 25"
]

[
  "sql" => "SELECT d0_.name AS name_0, d0_.cadence AS cadence_1, d0_.start_date AS start_date_2, d0_.end_date AS end_date_3, d0_.last_date_execution AS last_date_execution_4, d0_.id AS id_5, d0_.is_active AS is_active_6 FROM dm_to_do_list d0_ WHERE d0_.id IN (?, ?) ORDER BY d0_.name ASC"
  "params" => [
    1 => 2
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#882
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#882}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.surname AS surname_4, t0.password AS password_5, t0.role AS role_6, t0.one_time_code AS one_time_code_7, t0.expiration_one_time_code AS expiration_one_time_code_8, t0.is_active AS is_active_9, t0.is_account_activation AS is_account_activation_10, t0.is_email_notification_active AS is_email_notification_active_11, t0.theme AS theme_12, t0.directory_path AS directory_path_13, t14.id AS id_15, t14.avatar AS avatar_16, t14.user_id AS user_id_17, t18.id AS id_19, t18.is_terms_accepted AS is_terms_accepted_20, t18.datetime_last_update AS datetime_last_update_21, t18.user_id AS user_id_22 FROM dm_user t0 LEFT JOIN dm_user_profile t14 ON t14.user_id = t0.id LEFT JOIN dm_user_privacy t18 ON t18.user_id = t0.id WHERE t0.role = ? ORDER BY t0.surname ASC"
  "params" => [
    1 => "ROLE_USER"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#880
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.to_do_list_id AS to_do_list_id_3 FROM dm_join_table_user_to_do_list t0 WHERE t0.to_do_list_id = ?"
  "params" => [
    1 => "2"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#880
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.id AS id_2, t0.is_active AS is_active_3 FROM dm_item t0 INNER JOIN dm_to_do_list_item ON t0.id = dm_to_do_list_item.item_id WHERE dm_to_do_list_item.to_do_list_id = ? ORDER BY t0.name ASC"
  "params" => [
    1 => "2"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#880
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.to_do_list_id AS to_do_list_id_3 FROM dm_join_table_user_to_do_list t0 WHERE t0.to_do_list_id = ?"
  "params" => [
    1 => "1"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#880
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.id AS id_2, t0.is_active AS is_active_3 FROM dm_item t0 INNER JOIN dm_to_do_list_item ON t0.id = dm_to_do_list_item.item_id WHERE dm_to_do_list_item.to_do_list_id = ? ORDER BY t0.name ASC"
  "params" => [
    1 => "1"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#880
      +name: "STRING"
    }
  ]
]

[
  "key" => "_security_main"
]