Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

1 Different statements

1.40 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	0.86 ms	SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.name AS name_3, t0.type AS type_4, t0.string_value AS string_value_5, t0.text_value AS text_value_6, t0.boolean_value AS boolean_value_7, t0.organization_specific AS organization_specific_8, t0.state AS state_9, t0.created AS created_10, t0.updated AS updated_11, t0.file_value_id AS file_value_id_12, t0.configurablelist_id AS configurablelist_id_13, t0.listitem_value_id AS listitem_value_id_14, t0.organization_value_id AS organization_value_id_15, t0.authorizationtype_id AS authorizationtype_id_16, t0.organization_id AS organization_id_17, t0.created_by AS created_by_18, t0.updated_by AS updated_by_19 FROM setting t0 WHERE t0.identifier = ? AND t0.organization_id IS NULL LIMIT 1 Parameters: [`"Kernel.LoginWithFacebook"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.name AS name_3, t0.type AS type_4, t0.string_value AS string_value_5, t0.text_value AS text_value_6, t0.boolean_value AS boolean_value_7, t0.organization_specific AS organization_specific_8, t0.state AS state_9, t0.created AS created_10, t0.updated AS updated_11, t0.file_value_id AS file_value_id_12, t0.configurablelist_id AS configurablelist_id_13, t0.listitem_value_id AS listitem_value_id_14, t0.organization_value_id AS organization_value_id_15, t0.authorizationtype_id AS authorizationtype_id_16, t0.organization_id AS organization_id_17, t0.created_by AS created_by_18, t0.updated_by AS updated_by_19 FROM setting t0 WHERE t0.identifier = ? AND t0.organization_id IS NULL LIMIT 1 SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.name AS name_3, t0.type AS type_4, t0.string_value AS string_value_5, t0.text_value AS text_value_6, t0.boolean_value AS boolean_value_7, t0.organization_specific AS organization_specific_8, t0.state AS state_9, t0.created AS created_10, t0.updated AS updated_11, t0.file_value_id AS file_value_id_12, t0.configurablelist_id AS configurablelist_id_13, t0.listitem_value_id AS listitem_value_id_14, t0.organization_value_id AS organization_value_id_15, t0.authorizationtype_id AS authorizationtype_id_16, t0.organization_id AS organization_id_17, t0.created_by AS created_by_18, t0.updated_by AS updated_by_19 FROM setting t0 WHERE t0.identifier = 'Kernel.LoginWithFacebook' AND t0.organization_id IS NULL LIMIT 1;
2	0.54 ms	SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.name AS name_3, t0.type AS type_4, t0.string_value AS string_value_5, t0.text_value AS text_value_6, t0.boolean_value AS boolean_value_7, t0.organization_specific AS organization_specific_8, t0.state AS state_9, t0.created AS created_10, t0.updated AS updated_11, t0.file_value_id AS file_value_id_12, t0.configurablelist_id AS configurablelist_id_13, t0.listitem_value_id AS listitem_value_id_14, t0.organization_value_id AS organization_value_id_15, t0.authorizationtype_id AS authorizationtype_id_16, t0.organization_id AS organization_id_17, t0.created_by AS created_by_18, t0.updated_by AS updated_by_19 FROM setting t0 WHERE t0.identifier = ? AND t0.organization_id IS NULL LIMIT 1 Parameters: [`"Kernel.LoginWithOffice365"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.name AS name_3, t0.type AS type_4, t0.string_value AS string_value_5, t0.text_value AS text_value_6, t0.boolean_value AS boolean_value_7, t0.organization_specific AS organization_specific_8, t0.state AS state_9, t0.created AS created_10, t0.updated AS updated_11, t0.file_value_id AS file_value_id_12, t0.configurablelist_id AS configurablelist_id_13, t0.listitem_value_id AS listitem_value_id_14, t0.organization_value_id AS organization_value_id_15, t0.authorizationtype_id AS authorizationtype_id_16, t0.organization_id AS organization_id_17, t0.created_by AS created_by_18, t0.updated_by AS updated_by_19 FROM setting t0 WHERE t0.identifier = ? AND t0.organization_id IS NULL LIMIT 1 SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.name AS name_3, t0.type AS type_4, t0.string_value AS string_value_5, t0.text_value AS text_value_6, t0.boolean_value AS boolean_value_7, t0.organization_specific AS organization_specific_8, t0.state AS state_9, t0.created AS created_10, t0.updated AS updated_11, t0.file_value_id AS file_value_id_12, t0.configurablelist_id AS configurablelist_id_13, t0.listitem_value_id AS listitem_value_id_14, t0.organization_value_id AS organization_value_id_15, t0.authorizationtype_id AS authorizationtype_id_16, t0.organization_id AS organization_id_17, t0.created_by AS created_by_18, t0.updated_by AS updated_by_19 FROM setting t0 WHERE t0.identifier = 'Kernel.LoginWithOffice365' AND t0.organization_id IS NULL LIMIT 1;

#▲

Time

Info

0.86 ms

SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.name AS name_3, t0.type AS type_4, t0.string_value AS string_value_5, t0.text_value AS text_value_6, t0.boolean_value AS boolean_value_7, t0.organization_specific AS organization_specific_8, t0.state AS state_9, t0.created AS created_10, t0.updated AS updated_11, t0.file_value_id AS file_value_id_12, t0.configurablelist_id AS configurablelist_id_13, t0.listitem_value_id AS listitem_value_id_14, t0.organization_value_id AS organization_value_id_15, t0.authorizationtype_id AS authorizationtype_id_16, t0.organization_id AS organization_id_17, t0.created_by AS created_by_18, t0.updated_by AS updated_by_19 FROM setting t0 WHERE t0.identifier = ? AND t0.organization_id IS NULL LIMIT 1

Parameters:

[
  "Kernel.LoginWithFacebook"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.identifier AS identifier_2,
  t0.name AS name_3,
  t0.type AS type_4,
  t0.string_value AS string_value_5,
  t0.text_value AS text_value_6,
  t0.boolean_value AS boolean_value_7,
  t0.organization_specific AS organization_specific_8,
  t0.state AS state_9,
  t0.created AS created_10,
  t0.updated AS updated_11,
  t0.file_value_id AS file_value_id_12,
  t0.configurablelist_id AS configurablelist_id_13,
  t0.listitem_value_id AS listitem_value_id_14,
  t0.organization_value_id AS organization_value_id_15,
  t0.authorizationtype_id AS authorizationtype_id_16,
  t0.organization_id AS organization_id_17,
  t0.created_by AS created_by_18,
  t0.updated_by AS updated_by_19
FROM
  setting t0
WHERE
  t0.identifier = ?
  AND t0.organization_id IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.name AS name_3, t0.type AS type_4, t0.string_value AS string_value_5, t0.text_value AS text_value_6, t0.boolean_value AS boolean_value_7, t0.organization_specific AS organization_specific_8, t0.state AS state_9, t0.created AS created_10, t0.updated AS updated_11, t0.file_value_id AS file_value_id_12, t0.configurablelist_id AS configurablelist_id_13, t0.listitem_value_id AS listitem_value_id_14, t0.organization_value_id AS organization_value_id_15, t0.authorizationtype_id AS authorizationtype_id_16, t0.organization_id AS organization_id_17, t0.created_by AS created_by_18, t0.updated_by AS updated_by_19 FROM setting t0 WHERE t0.identifier = 'Kernel.LoginWithFacebook' AND t0.organization_id IS NULL LIMIT 1;

0.54 ms

SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.name AS name_3, t0.type AS type_4, t0.string_value AS string_value_5, t0.text_value AS text_value_6, t0.boolean_value AS boolean_value_7, t0.organization_specific AS organization_specific_8, t0.state AS state_9, t0.created AS created_10, t0.updated AS updated_11, t0.file_value_id AS file_value_id_12, t0.configurablelist_id AS configurablelist_id_13, t0.listitem_value_id AS listitem_value_id_14, t0.organization_value_id AS organization_value_id_15, t0.authorizationtype_id AS authorizationtype_id_16, t0.organization_id AS organization_id_17, t0.created_by AS created_by_18, t0.updated_by AS updated_by_19 FROM setting t0 WHERE t0.identifier = ? AND t0.organization_id IS NULL LIMIT 1

Parameters:

[
  "Kernel.LoginWithOffice365"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.identifier AS identifier_2,
  t0.name AS name_3,
  t0.type AS type_4,
  t0.string_value AS string_value_5,
  t0.text_value AS text_value_6,
  t0.boolean_value AS boolean_value_7,
  t0.organization_specific AS organization_specific_8,
  t0.state AS state_9,
  t0.created AS created_10,
  t0.updated AS updated_11,
  t0.file_value_id AS file_value_id_12,
  t0.configurablelist_id AS configurablelist_id_13,
  t0.listitem_value_id AS listitem_value_id_14,
  t0.organization_value_id AS organization_value_id_15,
  t0.authorizationtype_id AS authorizationtype_id_16,
  t0.organization_id AS organization_id_17,
  t0.created_by AS created_by_18,
  t0.updated_by AS updated_by_19
FROM
  setting t0
WHERE
  t0.identifier = ?
  AND t0.organization_id IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.name AS name_3, t0.type AS type_4, t0.string_value AS string_value_5, t0.text_value AS text_value_6, t0.boolean_value AS boolean_value_7, t0.organization_specific AS organization_specific_8, t0.state AS state_9, t0.created AS created_10, t0.updated AS updated_11, t0.file_value_id AS file_value_id_12, t0.configurablelist_id AS configurablelist_id_13, t0.listitem_value_id AS listitem_value_id_14, t0.organization_value_id AS organization_value_id_15, t0.authorizationtype_id AS authorizationtype_id_16, t0.organization_id AS organization_id_17, t0.created_by AS created_by_18, t0.updated_by AS updated_by_19 FROM setting t0 WHERE t0.identifier = 'Kernel.LoginWithOffice365' AND t0.organization_id IS NULL LIMIT 1;

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.

Entities Mapping

Class	Mapping errors
App\Entity\Kernel\Setting	No errors.
App\Entity\Kernel\KernelFile	No errors.
App\Entity\Kernel\ConfigurableList	No errors.
App\Entity\Kernel\ListItem	No errors.
App\Entity\Kernel\Organization	No errors.
App\Entity\Kernel\User	No errors.

Symfony Profiler

https://connect.vanmaercke.kreonta.com/en/login

Configuration Settings

Theme