Symfony Profiler

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

Log Messages

[
  "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#1385
    +count: 2
    -severity: E_USER_DEPRECATED
    trace: {
      /var/www/vhosts/eticket.imalize.com/httpdocs/vendor/symfony/config/Definition/ArrayNode.php:236 {
        Symfony\Component\Config\Definition\ArrayNode->finalizeValue(mixed $value): mixed …
        ›     $deprecation = $child->getDeprecation($name, $this->getPath());
        ›     trigger_deprecation($deprecation['package'], $deprecation['version'], $deprecation['message']);
        › }
      }
      /var/www/vhosts/eticket.imalize.com/httpdocs/vendor/symfony/config/Definition/BaseNode.php:420 {
        › 
        › $value = $this->finalizeValue($value);
        › 
      }
    }
  }
]

{
  /var/www/vhosts/eticket.imalize.com/httpdocs/vendor/symfony/config/Definition/ArrayNode.php:236 {
    Symfony\Component\Config\Definition\ArrayNode->finalizeValue(mixed $value): mixed …
    ›     $deprecation = $child->getDeprecation($name, $this->getPath());
    ›     trigger_deprecation($deprecation['package'], $deprecation['version'], $deprecation['message']);
    › }
  }
  /var/www/vhosts/eticket.imalize.com/httpdocs/vendor/symfony/config/Definition/BaseNode.php:420 {
    › 
    › $value = $this->finalizeValue($value);
    › 
  }
}

"api_tasks_list"

[
  "route" => "api_tasks_list"
  "route_parameters" => [
    "_route" => "api_tasks_list"
    "_controller" => "App\Controller\Api\TaskController::list"
  ]
  "request_uri" => "https://eticket.imalize.com/api/tasks?limit=15&page=1"
  "method" => "GET"
]

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

[
  "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"
]

[
  "driver" => "pdo_mysql"
  "idle_connection_ttl" => 600
  "host" => "localhost"
  "port" => 3306
  "user" => "eticketdata"
  "password" => "<redacted>"
  "driverOptions" => []
  "defaultTableOptions" => []
  "dbname" => "imalize_chat"
  "serverVersion" => "10.11.11-MariaDB"
  "charset" => "utf8mb4"
]

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

"SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.organisation_imalize_id AS organisation_imalize_id_6, t0.organisation_fournisseur_id AS organisation_fournisseur_id_7 FROM `user` t0 WHERE t0.id = ?"

[
  1 => 11
]

[
  1 => Doctrine\DBAL\ParameterType {#651
    +name: "INTEGER"
  }
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.organisation_imalize_id AS organisation_imalize_id_6, t0.organisation_fournisseur_id AS organisation_fournisseur_id_7 FROM `user` t0 WHERE t0.id = ?"
  "params" => [
    1 => 11
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#651
      +name: "INTEGER"
    }
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "n.vincent@imalize.com"
]

"SELECT COUNT(DISTINCT m0_.id) AS sclr_0 FROM mail_task m0_ LEFT JOIN mail_attachment m1_ ON m0_.id = m1_.task_id WHERE m0_.exported_at IS NULL AND m0_.relevant = 1 AND (m0_.status <> ? OR m0_.status IS NULL)"

[
  1 => "termine"
]

[
  1 => Doctrine\DBAL\ParameterType {#1008
    +name: "STRING"
  }
]

[
  "sql" => "SELECT COUNT(DISTINCT m0_.id) AS sclr_0 FROM mail_task m0_ LEFT JOIN mail_attachment m1_ ON m0_.id = m1_.task_id WHERE m0_.exported_at IS NULL AND m0_.relevant = 1 AND (m0_.status <> ? OR m0_.status IS NULL)"
  "params" => [
    1 => "termine"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1008
      +name: "STRING"
    }
  ]
]

"SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, received_at_16 FROM (SELECT m0_.id AS id_0, m0_.message_id AS message_id_1, m0_.conversation_id AS conversation_id_2, m0_.subject AS subject_3, m0_.body_preview AS body_preview_4, m0_.from_email AS from_email_5, m0_.to_emails AS to_emails_6, m0_.categories AS categories_7, m0_.has_attachments AS has_attachments_8, m0_.priority AS priority_9, m0_.status AS status_10, m0_.assigned_to_id AS assigned_to_id_11, m0_.assigned_to_name AS assigned_to_name_12, m0_.assigned_to_email AS assigned_to_email_13, m0_.assigned_to_roles AS assigned_to_roles_14, m0_.assigned_at AS assigned_at_15, m0_.received_at AS received_at_16, m0_.created_at AS created_at_17, m0_.note AS note_18, m0_.relevant AS relevant_19, m0_.exported_at AS exported_at_20, m1_.id AS id_21, m1_.filename AS filename_22, m1_.mime_type AS mime_type_23, m1_.file_size AS file_size_24, m1_.storage_path AS storage_path_25 FROM mail_task m0_ LEFT JOIN mail_attachment m1_ ON m0_.id = m1_.task_id WHERE m0_.exported_at IS NULL AND m0_.relevant = 1 AND (m0_.status <> ? OR m0_.status IS NULL)) dctrn_result_inner ORDER BY received_at_16 DESC) dctrn_result LIMIT 15"

[
  1 => "termine"
]

[
  1 => Doctrine\DBAL\ParameterType {#1008
    +name: "STRING"
  }
]

[
  "sql" => "SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, received_at_16 FROM (SELECT m0_.id AS id_0, m0_.message_id AS message_id_1, m0_.conversation_id AS conversation_id_2, m0_.subject AS subject_3, m0_.body_preview AS body_preview_4, m0_.from_email AS from_email_5, m0_.to_emails AS to_emails_6, m0_.categories AS categories_7, m0_.has_attachments AS has_attachments_8, m0_.priority AS priority_9, m0_.status AS status_10, m0_.assigned_to_id AS assigned_to_id_11, m0_.assigned_to_name AS assigned_to_name_12, m0_.assigned_to_email AS assigned_to_email_13, m0_.assigned_to_roles AS assigned_to_roles_14, m0_.assigned_at AS assigned_at_15, m0_.received_at AS received_at_16, m0_.created_at AS created_at_17, m0_.note AS note_18, m0_.relevant AS relevant_19, m0_.exported_at AS exported_at_20, m1_.id AS id_21, m1_.filename AS filename_22, m1_.mime_type AS mime_type_23, m1_.file_size AS file_size_24, m1_.storage_path AS storage_path_25 FROM mail_task m0_ LEFT JOIN mail_attachment m1_ ON m0_.id = m1_.task_id WHERE m0_.exported_at IS NULL AND m0_.relevant = 1 AND (m0_.status <> ? OR m0_.status IS NULL)) dctrn_result_inner ORDER BY received_at_16 DESC) dctrn_result LIMIT 15"
  "params" => [
    1 => "termine"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1008
      +name: "STRING"
    }
  ]
]

"SELECT m0_.id AS id_0, m0_.message_id AS message_id_1, m0_.conversation_id AS conversation_id_2, m0_.subject AS subject_3, m0_.body_preview AS body_preview_4, m0_.from_email AS from_email_5, m0_.to_emails AS to_emails_6, m0_.categories AS categories_7, m0_.has_attachments AS has_attachments_8, m0_.priority AS priority_9, m0_.status AS status_10, m0_.assigned_to_id AS assigned_to_id_11, m0_.assigned_to_name AS assigned_to_name_12, m0_.assigned_to_email AS assigned_to_email_13, m0_.assigned_to_roles AS assigned_to_roles_14, m0_.assigned_at AS assigned_at_15, m0_.received_at AS received_at_16, m0_.created_at AS created_at_17, m0_.note AS note_18, m0_.relevant AS relevant_19, m0_.exported_at AS exported_at_20, m1_.id AS id_21, m1_.filename AS filename_22, m1_.mime_type AS mime_type_23, m1_.file_size AS file_size_24, m1_.storage_path AS storage_path_25, m1_.task_id AS task_id_26 FROM mail_task m0_ LEFT JOIN mail_attachment m1_ ON m0_.id = m1_.task_id WHERE m0_.exported_at IS NULL AND m0_.relevant = 1 AND (m0_.status <> ? OR m0_.status IS NULL) AND m0_.id IN (?, ?, ?, ?, ?) ORDER BY m0_.received_at DESC"

[
  1 => "termine"
  2 => 341
  3 => 340
  4 => 336
  5 => 335
  6 => 325
]

[
  1 => Doctrine\DBAL\ParameterType {#1008
    +name: "STRING"
  }
  2 => Doctrine\DBAL\ParameterType {#651
    +name: "INTEGER"
  }
  3 => Doctrine\DBAL\ParameterType {#651}
  4 => Doctrine\DBAL\ParameterType {#651}
  5 => Doctrine\DBAL\ParameterType {#651}
  6 => Doctrine\DBAL\ParameterType {#651}
]

[
  "sql" => "SELECT m0_.id AS id_0, m0_.message_id AS message_id_1, m0_.conversation_id AS conversation_id_2, m0_.subject AS subject_3, m0_.body_preview AS body_preview_4, m0_.from_email AS from_email_5, m0_.to_emails AS to_emails_6, m0_.categories AS categories_7, m0_.has_attachments AS has_attachments_8, m0_.priority AS priority_9, m0_.status AS status_10, m0_.assigned_to_id AS assigned_to_id_11, m0_.assigned_to_name AS assigned_to_name_12, m0_.assigned_to_email AS assigned_to_email_13, m0_.assigned_to_roles AS assigned_to_roles_14, m0_.assigned_at AS assigned_at_15, m0_.received_at AS received_at_16, m0_.created_at AS created_at_17, m0_.note AS note_18, m0_.relevant AS relevant_19, m0_.exported_at AS exported_at_20, m1_.id AS id_21, m1_.filename AS filename_22, m1_.mime_type AS mime_type_23, m1_.file_size AS file_size_24, m1_.storage_path AS storage_path_25, m1_.task_id AS task_id_26 FROM mail_task m0_ LEFT JOIN mail_attachment m1_ ON m0_.id = m1_.task_id WHERE m0_.exported_at IS NULL AND m0_.relevant = 1 AND (m0_.status <> ? OR m0_.status IS NULL) AND m0_.id IN (?, ?, ?, ?, ?) ORDER BY m0_.received_at DESC"
  "params" => [
    1 => "termine"
    2 => 341
    3 => 340
    4 => 336
    5 => 335
    6 => 325
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1008
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#651
      +name: "INTEGER"
    }
    3 => Doctrine\DBAL\ParameterType {#651}
    4 => Doctrine\DBAL\ParameterType {#651}
    5 => Doctrine\DBAL\ParameterType {#651}
    6 => Doctrine\DBAL\ParameterType {#651}
  ]
]

[
  "key" => "_security_main"
]