Symfony Profiler

Query Metrics

12 Database Queries

8 Different statements

1.09 ms Query time

0 Invalid entities

0 Managed entities

Queries


SELECT 'main'
SELECT name AS table_name
FROM sqlite_master
WHERE type = 'table'
  AND name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence')
UNION ALL
SELECT name
FROM sqlite_temp_master
WHERE type = 'table'
ORDER BY name
SELECT 'main'
SELECT name AS table_name
FROM sqlite_master
WHERE type = 'table'
  AND name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence')
UNION ALL
SELECT name
FROM sqlite_temp_master
WHERE type = 'table'
ORDER BY name
SELECT t.name,
       c.name,
       c.type,
       c."notnull",
       c.dflt_value
FROM sqlite_master t
         JOIN pragma_table_info(t.name) c
WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = ?
ORDER BY t.name,
         c.cid
SELECT sql
FROM sqlite_master
WHERE type = 'table'
  AND name = ?
SELECT sql
FROM sqlite_master
WHERE type = 'table'
  AND name = ?
SELECT t.name,
           c.name
    FROM sqlite_master t
             JOIN pragma_table_info(t.name) c
    WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = ?
      AND c.pk > 0
    ORDER BY t.name,
             c.pk
SELECT t.name,
       i.name,
       i."unique",
       c.name
FROM sqlite_master t
         JOIN pragma_index_list(t.name) i
         JOIN pragma_index_info(i.name) c
WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = ?
  AND i.name NOT LIKE 'sqlite_%'
ORDER BY t.name,
         i.name,
         c.seqno
SELECT t.name,
                   c.id,
                   c."table",
                   c.on_update,
                   c.on_delete,
                   c."from",
                   c."to"
            FROM sqlite_master t
                     JOIN pragma_foreign_key_list(t.name) c
            WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = ?
            ORDER BY t.name,
                     c.id DESC,
                     c.seq
SELECT * FROM doctrine_migration_versions
SELECT 'main'

#▲	Time	Info
1	0.08 ms	SELECT 'main' Parameters: [] View formatted query View runnable query Explain query SELECT 'main' SELECT 'main';
2	0.16 ms	SELECT name AS table_name FROM sqlite_master WHERE type = 'table' AND name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') UNION ALL SELECT name FROM sqlite_temp_master WHERE type = 'table' ORDER BY name Parameters: [] View formatted query View runnable query Explain query SELECT name AS table_name FROM sqlite_master WHERE type = 'table' AND name NOT IN ( 'geometry_columns', 'spatial_ref_sys', 'sqlite_sequence' ) UNION ALL SELECT name FROM sqlite_temp_master WHERE type = 'table' ORDER BY name SELECT name AS table_name FROM sqlite_master WHERE type = 'table' AND name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') UNION ALL SELECT name FROM sqlite_temp_master WHERE type = 'table' ORDER BY name;
3	0.07 ms	SELECT 'main' Parameters: [] View formatted query View runnable query Explain query SELECT 'main' SELECT 'main';
4	0.09 ms	SELECT name AS table_name FROM sqlite_master WHERE type = 'table' AND name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') UNION ALL SELECT name FROM sqlite_temp_master WHERE type = 'table' ORDER BY name Parameters: [] View formatted query View runnable query Explain query SELECT name AS table_name FROM sqlite_master WHERE type = 'table' AND name NOT IN ( 'geometry_columns', 'spatial_ref_sys', 'sqlite_sequence' ) UNION ALL SELECT name FROM sqlite_temp_master WHERE type = 'table' ORDER BY name SELECT name AS table_name FROM sqlite_master WHERE type = 'table' AND name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') UNION ALL SELECT name FROM sqlite_temp_master WHERE type = 'table' ORDER BY name;
5	0.10 ms	SELECT t.name, c.name, c.type, c."notnull", c.dflt_value FROM sqlite_master t JOIN pragma_table_info(t.name) c WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = ? ORDER BY t.name, c.cid Parameters: [`"doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT t.name, c.name, c.type, c."notnull", c.dflt_value FROM sqlite_master t JOIN pragma_table_info(t.name) c WHERE t.type = 'table' AND t.name NOT IN ( 'geometry_columns', 'spatial_ref_sys', 'sqlite_sequence' ) AND t.name = ? ORDER BY t.name, c.cid SELECT t.name, c.name, c.type, c."notnull", c.dflt_value FROM sqlite_master t JOIN pragma_table_info(t.name) c WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = 'doctrine_migration_versions' ORDER BY t.name, c.cid;
6	0.07 ms	SELECT sql FROM sqlite_master WHERE type = 'table' AND name = ? Parameters: [`"doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT sql FROM sqlite_master WHERE type = 'table' AND name = ? SELECT sql FROM sqlite_master WHERE type = 'table' AND name = 'doctrine_migration_versions';
7	0.08 ms	SELECT sql FROM sqlite_master WHERE type = 'table' AND name = ? Parameters: [`"doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT sql FROM sqlite_master WHERE type = 'table' AND name = ? SELECT sql FROM sqlite_master WHERE type = 'table' AND name = 'doctrine_migration_versions';
8	0.11 ms	SELECT t.name, c.name FROM sqlite_master t JOIN pragma_table_info(t.name) c WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = ? AND c.pk > 0 ORDER BY t.name, c.pk Parameters: [`"doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT t.name, c.name FROM sqlite_master t JOIN pragma_table_info(t.name) c WHERE t.type = 'table' AND t.name NOT IN ( 'geometry_columns', 'spatial_ref_sys', 'sqlite_sequence' ) AND t.name = ? AND c.pk > 0 ORDER BY t.name, c.pk SELECT t.name, c.name FROM sqlite_master t JOIN pragma_table_info(t.name) c WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = 'doctrine_migration_versions' AND c.pk > 0 ORDER BY t.name, c.pk;
9	0.10 ms	SELECT t.name, i.name, i."unique", c.name FROM sqlite_master t JOIN pragma_index_list(t.name) i JOIN pragma_index_info(i.name) c WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = ? AND i.name NOT LIKE 'sqlite_%' ORDER BY t.name, i.name, c.seqno Parameters: [`"doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT t.name, i.name, i."unique", c.name FROM sqlite_master t JOIN pragma_index_list(t.name) i JOIN pragma_index_info(i.name) c WHERE t.type = 'table' AND t.name NOT IN ( 'geometry_columns', 'spatial_ref_sys', 'sqlite_sequence' ) AND t.name = ? AND i.name NOT LIKE 'sqlite_%' ORDER BY t.name, i.name, c.seqno SELECT t.name, i.name, i."unique", c.name FROM sqlite_master t JOIN pragma_index_list(t.name) i JOIN pragma_index_info(i.name) c WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = 'doctrine_migration_versions' AND i.name NOT LIKE 'sqlite_%' ORDER BY t.name, i.name, c.seqno;
10	0.10 ms	SELECT t.name, c.id, c."table", c.on_update, c.on_delete, c."from", c."to" FROM sqlite_master t JOIN pragma_foreign_key_list(t.name) c WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = ? ORDER BY t.name, c.id DESC, c.seq Parameters: [`"doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT t.name, c.id, c."table", c.on_update, c.on_delete, c."from", c."to" FROM sqlite_master t JOIN pragma_foreign_key_list(t.name) c WHERE t.type = 'table' AND t.name NOT IN ( 'geometry_columns', 'spatial_ref_sys', 'sqlite_sequence' ) AND t.name = ? ORDER BY t.name, c.id DESC, c.seq SELECT t.name, c.id, c."table", c.on_update, c.on_delete, c."from", c."to" FROM sqlite_master t JOIN pragma_foreign_key_list(t.name) c WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = 'doctrine_migration_versions' ORDER BY t.name, c.id DESC, c.seq;
11	0.08 ms	SELECT * FROM doctrine_migration_versions Parameters: [] View formatted query View runnable query Explain query SELECT * FROM doctrine_migration_versions SELECT * FROM doctrine_migration_versions;
12	0.07 ms	SELECT 'main' Parameters: [] View formatted query View runnable query Explain query SELECT 'main' SELECT 'main';

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects

Entities Mapping

No loaded entities.

Symfony Profiler

GET https://flashcard.raphael-salique.me/robots.txt

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping