Symfony Profiler

Query Metrics

27 Database Queries

9 Different statements

5.98 ms Query time

0 Invalid entities

0 Managed entities

Queries


SELECT COUNT(u0_.id) AS sclr_0 FROM users u0_
SELECT 'main'
SELECT name AS table_name
FROM sqlite_master
WHERE type = 'table'
  AND name != 'sqlite_sequence'
  AND name != 'geometry_columns'
  AND name != 'spatial_ref_sys'
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 != 'sqlite_sequence'
  AND name != 'geometry_columns'
  AND name != 'spatial_ref_sys'
UNION ALL
SELECT name
FROM sqlite_temp_master
WHERE type = 'table'
ORDER BY name
SELECT 'main'
SELECT sql
  FROM (
      SELECT *
        FROM sqlite_master
   UNION ALL
      SELECT *
        FROM sqlite_temp_master
  )
WHERE type = 'table'
AND name = ?
SELECT t.name AS table_name,
                   p.*
              FROM sqlite_master t
              JOIN pragma_foreign_key_list(t.name) p
                ON p."seq" != '-1' WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = ? ORDER BY t.name, p.id DESC, p.seq
SELECT t.name AS table_name,
                   c.*
              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 (
      SELECT *
        FROM sqlite_master
   UNION ALL
      SELECT *
        FROM sqlite_temp_master
  )
WHERE type = 'table'
AND name = ?
SELECT 'main'
SELECT t.name AS table_name,
                   i.*
              FROM sqlite_master t
              JOIN pragma_index_list(t.name) i WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = ? ORDER BY t.name, i.seq
SELECT * FROM PRAGMA_TABLE_INFO (?)
SELECT * FROM migration_versions
SELECT 'main'
SELECT name AS table_name
FROM sqlite_master
WHERE type = 'table'
  AND name != 'sqlite_sequence'
  AND name != 'geometry_columns'
  AND name != 'spatial_ref_sys'
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 != 'sqlite_sequence'
  AND name != 'geometry_columns'
  AND name != 'spatial_ref_sys'
UNION ALL
SELECT name
FROM sqlite_temp_master
WHERE type = 'table'
ORDER BY name
SELECT 'main'
SELECT sql
  FROM (
      SELECT *
        FROM sqlite_master
   UNION ALL
      SELECT *
        FROM sqlite_temp_master
  )
WHERE type = 'table'
AND name = ?
SELECT t.name AS table_name,
                   p.*
              FROM sqlite_master t
              JOIN pragma_foreign_key_list(t.name) p
                ON p."seq" != '-1' WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = ? ORDER BY t.name, p.id DESC, p.seq
SELECT t.name AS table_name,
                   c.*
              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 (
      SELECT *
        FROM sqlite_master
   UNION ALL
      SELECT *
        FROM sqlite_temp_master
  )
WHERE type = 'table'
AND name = ?
SELECT 'main'
SELECT t.name AS table_name,
                   i.*
              FROM sqlite_master t
              JOIN pragma_index_list(t.name) i WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = ? ORDER BY t.name, i.seq
SELECT * FROM PRAGMA_TABLE_INFO (?)
SELECT * FROM migration_versions

#▲	Time	Info
1	2.00 ms	SELECT COUNT(u0_.id) AS sclr_0 FROM users u0_ Parameters: [] View formatted query View runnable query Explain query SELECT COUNT(u0_.id) AS sclr_0 FROM users u0_ SELECT COUNT(u0_.id) AS sclr_0 FROM users u0_;
2	0.15 ms	SELECT 'main' Parameters: [] View formatted query View runnable query Explain query SELECT 'main' SELECT 'main';
3	0.24 ms	SELECT name AS table_name FROM sqlite_master WHERE type = 'table' AND name != 'sqlite_sequence' AND name != 'geometry_columns' AND name != 'spatial_ref_sys' 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 != 'sqlite_sequence' AND name != 'geometry_columns' AND name != 'spatial_ref_sys' 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 != 'sqlite_sequence' AND name != 'geometry_columns' AND name != 'spatial_ref_sys' UNION ALL SELECT name FROM sqlite_temp_master WHERE type = 'table' ORDER BY name;
4	0.09 ms	SELECT 'main' Parameters: [] View formatted query View runnable query Explain query SELECT 'main' SELECT 'main';
5	0.20 ms	SELECT name AS table_name FROM sqlite_master WHERE type = 'table' AND name != 'sqlite_sequence' AND name != 'geometry_columns' AND name != 'spatial_ref_sys' 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 != 'sqlite_sequence' AND name != 'geometry_columns' AND name != 'spatial_ref_sys' 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 != 'sqlite_sequence' AND name != 'geometry_columns' AND name != 'spatial_ref_sys' UNION ALL SELECT name FROM sqlite_temp_master WHERE type = 'table' ORDER BY name;
6	0.12 ms	SELECT 'main' Parameters: [] View formatted query View runnable query Explain query SELECT 'main' SELECT 'main';
7	0.15 ms	SELECT sql FROM ( SELECT * FROM sqlite_master UNION ALL SELECT * FROM sqlite_temp_master ) WHERE type = 'table' AND name = ? Parameters: [`"migration_versions"`] View formatted query View runnable query Explain query SELECT sql FROM ( SELECT * FROM sqlite_master UNION ALL SELECT * FROM sqlite_temp_master ) WHERE type = 'table' AND name = ? SELECT sql FROM ( SELECT * FROM sqlite_master UNION ALL SELECT * FROM sqlite_temp_master ) WHERE type = 'table' AND name = 'migration_versions';
8	0.22 ms	SELECT t.name AS table_name, p.* FROM sqlite_master t JOIN pragma_foreign_key_list(t.name) p ON p."seq" != '-1' WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = ? ORDER BY t.name, p.id DESC, p.seq Parameters: [`"migration_versions"`] View formatted query View runnable query Explain query SELECT t.name AS table_name, p.* FROM sqlite_master t JOIN pragma_foreign_key_list(t.name) p ON p."seq" != '-1' WHERE t.type = 'table' AND t.name NOT IN ( 'geometry_columns', 'spatial_ref_sys', 'sqlite_sequence' ) AND t.name = ? ORDER BY t.name, p.id DESC, p.seq SELECT t.name AS table_name, p.* FROM sqlite_master t JOIN pragma_foreign_key_list(t.name) p ON p."seq" != '-1' WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = 'migration_versions' ORDER BY t.name, p.id DESC, p.seq;
9	0.20 ms	SELECT t.name AS table_name, c.* 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: [`"migration_versions"`] View formatted query View runnable query Explain query SELECT t.name AS table_name, c.* 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 AS table_name, c.* 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 = 'migration_versions' ORDER BY t.name, c.cid;
10	0.12 ms	SELECT sql FROM ( SELECT * FROM sqlite_master UNION ALL SELECT * FROM sqlite_temp_master ) WHERE type = 'table' AND name = ? Parameters: [`"migration_versions"`] View formatted query View runnable query Explain query SELECT sql FROM ( SELECT * FROM sqlite_master UNION ALL SELECT * FROM sqlite_temp_master ) WHERE type = 'table' AND name = ? SELECT sql FROM ( SELECT * FROM sqlite_master UNION ALL SELECT * FROM sqlite_temp_master ) WHERE type = 'table' AND name = 'migration_versions';
11	0.09 ms	SELECT 'main' Parameters: [] View formatted query View runnable query Explain query SELECT 'main' SELECT 'main';
12	0.18 ms	SELECT t.name AS table_name, i.* FROM sqlite_master t JOIN pragma_index_list(t.name) i WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = ? ORDER BY t.name, i.seq Parameters: [`"migration_versions"`] View formatted query View runnable query Explain query SELECT t.name AS table_name, i.* FROM sqlite_master t JOIN pragma_index_list(t.name) i WHERE t.type = 'table' AND t.name NOT IN ( 'geometry_columns', 'spatial_ref_sys', 'sqlite_sequence' ) AND t.name = ? ORDER BY t.name, i.seq SELECT t.name AS table_name, i.* FROM sqlite_master t JOIN pragma_index_list(t.name) i WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = 'migration_versions' ORDER BY t.name, i.seq;
13	0.12 ms	SELECT * FROM PRAGMA_TABLE_INFO (?) Parameters: [`"migration_versions"`] View formatted query View runnable query Explain query SELECT * FROM PRAGMA_TABLE_INFO (?) SELECT * FROM PRAGMA_TABLE_INFO ('migration_versions');
14	0.15 ms	SELECT * FROM migration_versions Parameters: [] View formatted query View runnable query Explain query SELECT * FROM migration_versions SELECT * FROM migration_versions;
15	0.17 ms	SELECT 'main' Parameters: [] View formatted query View runnable query Explain query SELECT 'main' SELECT 'main';
16	0.26 ms	SELECT name AS table_name FROM sqlite_master WHERE type = 'table' AND name != 'sqlite_sequence' AND name != 'geometry_columns' AND name != 'spatial_ref_sys' 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 != 'sqlite_sequence' AND name != 'geometry_columns' AND name != 'spatial_ref_sys' 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 != 'sqlite_sequence' AND name != 'geometry_columns' AND name != 'spatial_ref_sys' UNION ALL SELECT name FROM sqlite_temp_master WHERE type = 'table' ORDER BY name;
17	0.09 ms	SELECT 'main' Parameters: [] View formatted query View runnable query Explain query SELECT 'main' SELECT 'main';
18	0.19 ms	SELECT name AS table_name FROM sqlite_master WHERE type = 'table' AND name != 'sqlite_sequence' AND name != 'geometry_columns' AND name != 'spatial_ref_sys' 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 != 'sqlite_sequence' AND name != 'geometry_columns' AND name != 'spatial_ref_sys' 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 != 'sqlite_sequence' AND name != 'geometry_columns' AND name != 'spatial_ref_sys' UNION ALL SELECT name FROM sqlite_temp_master WHERE type = 'table' ORDER BY name;
19	0.11 ms	SELECT 'main' Parameters: [] View formatted query View runnable query Explain query SELECT 'main' SELECT 'main';
20	0.11 ms	SELECT sql FROM ( SELECT * FROM sqlite_master UNION ALL SELECT * FROM sqlite_temp_master ) WHERE type = 'table' AND name = ? Parameters: [`"migration_versions"`] View formatted query View runnable query Explain query SELECT sql FROM ( SELECT * FROM sqlite_master UNION ALL SELECT * FROM sqlite_temp_master ) WHERE type = 'table' AND name = ? SELECT sql FROM ( SELECT * FROM sqlite_master UNION ALL SELECT * FROM sqlite_temp_master ) WHERE type = 'table' AND name = 'migration_versions';
21	0.19 ms	SELECT t.name AS table_name, p.* FROM sqlite_master t JOIN pragma_foreign_key_list(t.name) p ON p."seq" != '-1' WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = ? ORDER BY t.name, p.id DESC, p.seq Parameters: [`"migration_versions"`] View formatted query View runnable query Explain query SELECT t.name AS table_name, p.* FROM sqlite_master t JOIN pragma_foreign_key_list(t.name) p ON p."seq" != '-1' WHERE t.type = 'table' AND t.name NOT IN ( 'geometry_columns', 'spatial_ref_sys', 'sqlite_sequence' ) AND t.name = ? ORDER BY t.name, p.id DESC, p.seq SELECT t.name AS table_name, p.* FROM sqlite_master t JOIN pragma_foreign_key_list(t.name) p ON p."seq" != '-1' WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = 'migration_versions' ORDER BY t.name, p.id DESC, p.seq;
22	0.18 ms	SELECT t.name AS table_name, c.* 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: [`"migration_versions"`] View formatted query View runnable query Explain query SELECT t.name AS table_name, c.* 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 AS table_name, c.* 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 = 'migration_versions' ORDER BY t.name, c.cid;
23	0.12 ms	SELECT sql FROM ( SELECT * FROM sqlite_master UNION ALL SELECT * FROM sqlite_temp_master ) WHERE type = 'table' AND name = ? Parameters: [`"migration_versions"`] View formatted query View runnable query Explain query SELECT sql FROM ( SELECT * FROM sqlite_master UNION ALL SELECT * FROM sqlite_temp_master ) WHERE type = 'table' AND name = ? SELECT sql FROM ( SELECT * FROM sqlite_master UNION ALL SELECT * FROM sqlite_temp_master ) WHERE type = 'table' AND name = 'migration_versions';
24	0.08 ms	SELECT 'main' Parameters: [] View formatted query View runnable query Explain query SELECT 'main' SELECT 'main';
25	0.19 ms	SELECT t.name AS table_name, i.* FROM sqlite_master t JOIN pragma_index_list(t.name) i WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = ? ORDER BY t.name, i.seq Parameters: [`"migration_versions"`] View formatted query View runnable query Explain query SELECT t.name AS table_name, i.* FROM sqlite_master t JOIN pragma_index_list(t.name) i WHERE t.type = 'table' AND t.name NOT IN ( 'geometry_columns', 'spatial_ref_sys', 'sqlite_sequence' ) AND t.name = ? ORDER BY t.name, i.seq SELECT t.name AS table_name, i.* FROM sqlite_master t JOIN pragma_index_list(t.name) i WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = 'migration_versions' ORDER BY t.name, i.seq;
26	0.13 ms	SELECT * FROM PRAGMA_TABLE_INFO (?) Parameters: [`"migration_versions"`] View formatted query View runnable query Explain query SELECT * FROM PRAGMA_TABLE_INFO (?) SELECT * FROM PRAGMA_TABLE_INFO ('migration_versions');
27	0.13 ms	SELECT * FROM migration_versions Parameters: [] View formatted query View runnable query Explain query SELECT * FROM migration_versions SELECT * FROM migration_versions;

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

Class	Mapping errors
SolidInvoice\UserBundle\Entity\User	No errors.

Symfony Profiler

GET https://billing.lisboncodelab.com/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping