Symfony Profiler

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

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

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

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

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

[
  "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 {#971
      +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 {#971
      +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 {#971
      +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 {#971
      +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 {#971
      +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 {#971
      +name: "STRING"
    }
  ]
]

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

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