Query Metrics

22 Database Queries
6 Different statements
17.63 ms Query time
0 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 2.67 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.plain_password AS plain_password_6, t0.is_active AS is_active_7, t8.id AS id_9, t8.name AS name_10, t8.email AS email_11, t8.user_id AS user_id_12 FROM symfony_user t0 LEFT JOIN person t8 ON t8.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  1
]
2 0.96 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.person_id AS person_id_3 FROM manager t0 WHERE t0.person_id = ?
Parameters:
[
  22
]
3 1.24 ms
SELECT DISTINCT s0_.id AS id_0, s0_.id AS id_1 FROM seo_type s0_ ORDER BY s0_.id DESC LIMIT 25
Parameters:
[]
4 0.82 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.title AS title_2, s0_.base_path AS base_path_3, s0_.short_title AS short_title_4 FROM seo_type s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.id DESC
Parameters:
[
  17
  16
  15
  14
  13
  12
  11
  10
  9
  8
  7
  6
  5
  4
  3
  2
  1
]
5 0.73 ms
SELECT COUNT(s0_.id) AS sclr_0 FROM seo_type s0_
Parameters:
[]
6 1.11 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.url AS url_4 FROM seo_site t0 INNER JOIN seo_type_seo_site ON t0.id = seo_type_seo_site.seo_site_id WHERE seo_type_seo_site.seo_type_id = ?
Parameters:
[
  17
]
7 0.78 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.url AS url_4 FROM seo_site t0 INNER JOIN seo_type_seo_site ON t0.id = seo_type_seo_site.seo_site_id WHERE seo_type_seo_site.seo_type_id = ?
Parameters:
[
  16
]
8 0.93 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.url AS url_4 FROM seo_site t0 INNER JOIN seo_type_seo_site ON t0.id = seo_type_seo_site.seo_site_id WHERE seo_type_seo_site.seo_type_id = ?
Parameters:
[
  15
]
9 0.61 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.url AS url_4 FROM seo_site t0 INNER JOIN seo_type_seo_site ON t0.id = seo_type_seo_site.seo_site_id WHERE seo_type_seo_site.seo_type_id = ?
Parameters:
[
  14
]
10 0.84 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.url AS url_4 FROM seo_site t0 INNER JOIN seo_type_seo_site ON t0.id = seo_type_seo_site.seo_site_id WHERE seo_type_seo_site.seo_type_id = ?
Parameters:
[
  13
]
11 0.51 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.url AS url_4 FROM seo_site t0 INNER JOIN seo_type_seo_site ON t0.id = seo_type_seo_site.seo_site_id WHERE seo_type_seo_site.seo_type_id = ?
Parameters:
[
  12
]
12 0.60 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.url AS url_4 FROM seo_site t0 INNER JOIN seo_type_seo_site ON t0.id = seo_type_seo_site.seo_site_id WHERE seo_type_seo_site.seo_type_id = ?
Parameters:
[
  11
]
13 0.50 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.url AS url_4 FROM seo_site t0 INNER JOIN seo_type_seo_site ON t0.id = seo_type_seo_site.seo_site_id WHERE seo_type_seo_site.seo_type_id = ?
Parameters:
[
  10
]
14 0.93 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.url AS url_4 FROM seo_site t0 INNER JOIN seo_type_seo_site ON t0.id = seo_type_seo_site.seo_site_id WHERE seo_type_seo_site.seo_type_id = ?
Parameters:
[
  9
]
15 0.53 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.url AS url_4 FROM seo_site t0 INNER JOIN seo_type_seo_site ON t0.id = seo_type_seo_site.seo_site_id WHERE seo_type_seo_site.seo_type_id = ?
Parameters:
[
  8
]
16 0.57 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.url AS url_4 FROM seo_site t0 INNER JOIN seo_type_seo_site ON t0.id = seo_type_seo_site.seo_site_id WHERE seo_type_seo_site.seo_type_id = ?
Parameters:
[
  7
]
17 0.52 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.url AS url_4 FROM seo_site t0 INNER JOIN seo_type_seo_site ON t0.id = seo_type_seo_site.seo_site_id WHERE seo_type_seo_site.seo_type_id = ?
Parameters:
[
  6
]
18 0.63 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.url AS url_4 FROM seo_site t0 INNER JOIN seo_type_seo_site ON t0.id = seo_type_seo_site.seo_site_id WHERE seo_type_seo_site.seo_type_id = ?
Parameters:
[
  5
]
19 0.54 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.url AS url_4 FROM seo_site t0 INNER JOIN seo_type_seo_site ON t0.id = seo_type_seo_site.seo_site_id WHERE seo_type_seo_site.seo_type_id = ?
Parameters:
[
  4
]
20 0.51 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.url AS url_4 FROM seo_site t0 INNER JOIN seo_type_seo_site ON t0.id = seo_type_seo_site.seo_site_id WHERE seo_type_seo_site.seo_type_id = ?
Parameters:
[
  3
]
21 0.58 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.url AS url_4 FROM seo_site t0 INNER JOIN seo_type_seo_site ON t0.id = seo_type_seo_site.seo_site_id WHERE seo_type_seo_site.seo_type_id = ?
Parameters:
[
  2
]
22 0.52 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.url AS url_4 FROM seo_site t0 INNER JOIN seo_type_seo_site ON t0.id = seo_type_seo_site.seo_site_id WHERE seo_type_seo_site.seo_type_id = ?
Parameters:
[
  1
]

Database Connections

Name Service
litedb doctrine.dbal.litedb_connection
default doctrine.dbal.default_connection

Entity Managers

Name Service
litedb doctrine.orm.litedb_entity_manager
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

litedb entity manager

No loaded entities.

default entity manager

Class Mapping errors
Shared\Entity\Main\User No errors.
Shared\Entity\Main\Person\Person No errors.
Shared\Entity\Main\UserRole No errors.
Shared\Entity\Main\Person\Manager No errors.
Shared\Entity\Main\Seo\SeoType No errors.
Shared\Entity\Main\Seo\SeoContent No errors.
Shared\Entity\Main\Seo\SeoSite No errors.