Symfony Profiler

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

Log Messages

"app_login"

[
  "route" => "app_login"
  "route_parameters" => [
    "_route" => "app_login"
    "_controller" => "App\Controller\SecurityController::login"
  ]
  "request_uri" => "https://flashcard.raphael-salique.me/login"
  "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"
]

[
  "driver" => "pdo_sqlite"
  "idle_connection_ttl" => 600
  "host" => "localhost"
  "port" => null
  "user" => "root"
  "password" => null
  "driverOptions" => []
  "defaultTableOptions" => []
  "path" => "/home/raphaelsalique/Public/flashcard/var/data.db"
  "charset" => "utf8"
]

[
  "params" => [
    "driver" => "pdo_sqlite"
    "idle_connection_ttl" => 600
    "host" => "localhost"
    "port" => null
    "user" => "root"
    "password" => null
    "driverOptions" => []
    "defaultTableOptions" => []
    "path" => "/home/raphaelsalique/Public/flashcard/var/data.db"
    "charset" => "utf8"
  ]
]

"SELECT 'main'"

[
  "sql" => "SELECT 'main'"
]

"""
SELECT name AS table_name\n
FROM sqlite_master\n
WHERE type = 'table'\n
  AND name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence')\n
UNION ALL\n
SELECT name\n
FROM sqlite_temp_master\n
WHERE type = 'table'\n
ORDER BY name
"""

[
  "sql" => """
    SELECT name AS table_name\n
    FROM sqlite_master\n
    WHERE type = 'table'\n
      AND name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence')\n
    UNION ALL\n
    SELECT name\n
    FROM sqlite_temp_master\n
    WHERE type = 'table'\n
    ORDER BY name
    """
]

"SELECT 'main'"

[
  "sql" => "SELECT 'main'"
]

"""
SELECT name AS table_name\n
FROM sqlite_master\n
WHERE type = 'table'\n
  AND name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence')\n
UNION ALL\n
SELECT name\n
FROM sqlite_temp_master\n
WHERE type = 'table'\n
ORDER BY name
"""

[
  "sql" => """
    SELECT name AS table_name\n
    FROM sqlite_master\n
    WHERE type = 'table'\n
      AND name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence')\n
    UNION ALL\n
    SELECT name\n
    FROM sqlite_temp_master\n
    WHERE type = 'table'\n
    ORDER BY name
    """
]

"""
SELECT t.name,\n
       c.name,\n
       c.type,\n
       c."notnull",\n
       c.dflt_value\n
FROM sqlite_master t\n
         JOIN pragma_table_info(t.name) c\n
WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = ?\n
ORDER BY t.name,\n
         c.cid
"""

[
  1 => "doctrine_migration_versions"
]

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

[
  "sql" => """
    SELECT t.name,\n
           c.name,\n
           c.type,\n
           c."notnull",\n
           c.dflt_value\n
    FROM sqlite_master t\n
             JOIN pragma_table_info(t.name) c\n
    WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = ?\n
    ORDER BY t.name,\n
             c.cid
    """
  "params" => [
    1 => "doctrine_migration_versions"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#869
      +name: "STRING"
    }
  ]
]

"""
SELECT sql\n
FROM sqlite_master\n
WHERE type = 'table'\n
  AND name = ?
"""

[
  1 => "doctrine_migration_versions"
]

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

[
  "sql" => """
    SELECT sql\n
    FROM sqlite_master\n
    WHERE type = 'table'\n
      AND name = ?
    """
  "params" => [
    1 => "doctrine_migration_versions"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#869
      +name: "STRING"
    }
  ]
]

"""
SELECT sql\n
FROM sqlite_master\n
WHERE type = 'table'\n
  AND name = ?
"""

[
  1 => "doctrine_migration_versions"
]

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

[
  "sql" => """
    SELECT sql\n
    FROM sqlite_master\n
    WHERE type = 'table'\n
      AND name = ?
    """
  "params" => [
    1 => "doctrine_migration_versions"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#869
      +name: "STRING"
    }
  ]
]

"""
    SELECT t.name,\n
           c.name\n
    FROM sqlite_master t\n
             JOIN pragma_table_info(t.name) c\n
    WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = ?\n
      AND c.pk > 0\n
    ORDER BY t.name,\n
             c.pk
"""

[
  1 => "doctrine_migration_versions"
]

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

[
  "sql" => """
        SELECT t.name,\n
               c.name\n
        FROM sqlite_master t\n
                 JOIN pragma_table_info(t.name) c\n
        WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = ?\n
          AND c.pk > 0\n
        ORDER BY t.name,\n
                 c.pk
    """
  "params" => [
    1 => "doctrine_migration_versions"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#869
      +name: "STRING"
    }
  ]
]

"""
SELECT t.name,\n
       i.name,\n
       i."unique",\n
       c.name\n
FROM sqlite_master t\n
         JOIN pragma_index_list(t.name) i\n
         JOIN pragma_index_info(i.name) c\n
WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = ?\n
  AND i.name NOT LIKE 'sqlite_%'\n
ORDER BY t.name,\n
         i.name,\n
         c.seqno
"""

[
  1 => "doctrine_migration_versions"
]

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

[
  "sql" => """
    SELECT t.name,\n
           i.name,\n
           i."unique",\n
           c.name\n
    FROM sqlite_master t\n
             JOIN pragma_index_list(t.name) i\n
             JOIN pragma_index_info(i.name) c\n
    WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = ?\n
      AND i.name NOT LIKE 'sqlite_%'\n
    ORDER BY t.name,\n
             i.name,\n
             c.seqno
    """
  "params" => [
    1 => "doctrine_migration_versions"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#869
      +name: "STRING"
    }
  ]
]

"""
            SELECT t.name,\n
                   c.id,\n
                   c."table",\n
                   c.on_update,\n
                   c.on_delete,\n
                   c."from",\n
                   c."to"\n
            FROM sqlite_master t\n
                     JOIN pragma_foreign_key_list(t.name) c\n
            WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = ?\n
            ORDER BY t.name,\n
                     c.id DESC,\n
                     c.seq
"""

[
  1 => "doctrine_migration_versions"
]

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

[
  "sql" => """
                SELECT t.name,\n
                       c.id,\n
                       c."table",\n
                       c.on_update,\n
                       c.on_delete,\n
                       c."from",\n
                       c."to"\n
                FROM sqlite_master t\n
                         JOIN pragma_foreign_key_list(t.name) c\n
                WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = ?\n
                ORDER BY t.name,\n
                         c.id DESC,\n
                         c.seq
    """
  "params" => [
    1 => "doctrine_migration_versions"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#869
      +name: "STRING"
    }
  ]
]

"SELECT * FROM doctrine_migration_versions"

[
  "sql" => "SELECT * FROM doctrine_migration_versions"
]

"SELECT 'main'"

[
  "sql" => "SELECT 'main'"
]