Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

0.71 ms Query time

3 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
0.45 ms (63.70%)	1	SELECT t0.id AS id_1, t0.gender AS gender_2, t0.fname AS fname_3, t0.lname AS lname_4, t0.email AS email_5, t0.email_token AS email_token_6, t0.username AS username_7, t0.password AS password_8, t0.password_token AS password_token_9, t0.roles AS roles_10, t0.birthday AS birthday_11, t0.phone AS phone_12, t0.phone_token AS phone_token_13, t0.avatar AS avatar_14, t0.type AS type_15, t0.status AS status_16, t0.lang AS lang_17, t0.address1 AS address1_18, t0.address2 AS address2_19, t0.zipcode AS zipcode_20, t0.city AS city_21, t0.social_brand AS social_brand_22, t0.social_id AS social_id_23, t0.country AS country_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26, t0.last_login AS last_login_27, t0.trusted_version AS trusted_version_28, t0.is_verified AS is_verified_29, t0.description AS description_30, t0.location AS location_31, t0.is_vip AS is_vip_32, t0.is_seller AS is_seller_33, t0.company_id AS company_id_34, t0.groupe_id AS groupe_id_35, t0.team_id AS team_id_36 FROM user t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.gender AS gender_2, t0.fname AS fname_3, t0.lname AS lname_4, t0.email AS email_5, t0.email_token AS email_token_6, t0.username AS username_7, t0.password AS password_8, t0.password_token AS password_token_9, t0.roles AS roles_10, t0.birthday AS birthday_11, t0.phone AS phone_12, t0.phone_token AS phone_token_13, t0.avatar AS avatar_14, t0.type AS type_15, t0.status AS status_16, t0.lang AS lang_17, t0.address1 AS address1_18, t0.address2 AS address2_19, t0.zipcode AS zipcode_20, t0.city AS city_21, t0.social_brand AS social_brand_22, t0.social_id AS social_id_23, t0.country AS country_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26, t0.last_login AS last_login_27, t0.trusted_version AS trusted_version_28, t0.is_verified AS is_verified_29, t0.description AS description_30, t0.location AS location_31, t0.is_vip AS is_vip_32, t0.is_seller AS is_seller_33, t0.company_id AS company_id_34, t0.groupe_id AS groupe_id_35, t0.team_id AS team_id_36 FROM user t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.gender AS gender_2, t0.fname AS fname_3, t0.lname AS lname_4, t0.email AS email_5, t0.email_token AS email_token_6, t0.username AS username_7, t0.password AS password_8, t0.password_token AS password_token_9, t0.roles AS roles_10, t0.birthday AS birthday_11, t0.phone AS phone_12, t0.phone_token AS phone_token_13, t0.avatar AS avatar_14, t0.type AS type_15, t0.status AS status_16, t0.lang AS lang_17, t0.address1 AS address1_18, t0.address2 AS address2_19, t0.zipcode AS zipcode_20, t0.city AS city_21, t0.social_brand AS social_brand_22, t0.social_id AS social_id_23, t0.country AS country_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26, t0.last_login AS last_login_27, t0.trusted_version AS trusted_version_28, t0.is_verified AS is_verified_29, t0.description AS description_30, t0.location AS location_31, t0.is_vip AS is_vip_32, t0.is_seller AS is_seller_33, t0.company_id AS company_id_34, t0.groupe_id AS groupe_id_35, t0.team_id AS team_id_36 FROM user t0 WHERE t0.id = 1;
0.26 ms (36.30%)	1	SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.phone AS phone_4, t0.address AS address_5, t0.email AS email_6, t0.description AS description_7, t0.domain AS domain_8, t0.lat AS lat_9, t0.lan AS lan_10, t0.placeid AS placeid_11, t0.banner AS banner_12, t0.color AS color_13, t0.menu_redirection AS menu_redirection_14, t0.ftheme AS ftheme_15, t0.redirectiontype AS redirectiontype_16, t0.formlabel AS formlabel_17, t0.formbanner AS formbanner_18, t0.formtitle AS formtitle_19, t0.redirectionurl AS redirectionurl_20, t0.views AS views_21, t0.revendeur_id AS revendeur_id_22 FROM company t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.phone AS phone_4, t0.address AS address_5, t0.email AS email_6, t0.description AS description_7, t0.domain AS domain_8, t0.lat AS lat_9, t0.lan AS lan_10, t0.placeid AS placeid_11, t0.banner AS banner_12, t0.color AS color_13, t0.menu_redirection AS menu_redirection_14, t0.ftheme AS ftheme_15, t0.redirectiontype AS redirectiontype_16, t0.formlabel AS formlabel_17, t0.formbanner AS formbanner_18, t0.formtitle AS formtitle_19, t0.redirectionurl AS redirectionurl_20, t0.views AS views_21, t0.revendeur_id AS revendeur_id_22 FROM company t0 SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.phone AS phone_4, t0.address AS address_5, t0.email AS email_6, t0.description AS description_7, t0.domain AS domain_8, t0.lat AS lat_9, t0.lan AS lan_10, t0.placeid AS placeid_11, t0.banner AS banner_12, t0.color AS color_13, t0.menu_redirection AS menu_redirection_14, t0.ftheme AS ftheme_15, t0.redirectiontype AS redirectiontype_16, t0.formlabel AS formlabel_17, t0.formbanner AS formbanner_18, t0.formtitle AS formtitle_19, t0.redirectionurl AS redirectionurl_20, t0.views AS views_21, t0.revendeur_id AS revendeur_id_22 FROM company t0;

Time▼

Count

Info

0.45 ms
(63.70%)

SELECT t0.id AS id_1, t0.gender AS gender_2, t0.fname AS fname_3, t0.lname AS lname_4, t0.email AS email_5, t0.email_token AS email_token_6, t0.username AS username_7, t0.password AS password_8, t0.password_token AS password_token_9, t0.roles AS roles_10, t0.birthday AS birthday_11, t0.phone AS phone_12, t0.phone_token AS phone_token_13, t0.avatar AS avatar_14, t0.type AS type_15, t0.status AS status_16, t0.lang AS lang_17, t0.address1 AS address1_18, t0.address2 AS address2_19, t0.zipcode AS zipcode_20, t0.city AS city_21, t0.social_brand AS social_brand_22, t0.social_id AS social_id_23, t0.country AS country_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26, t0.last_login AS last_login_27, t0.trusted_version AS trusted_version_28, t0.is_verified AS is_verified_29, t0.description AS description_30, t0.location AS location_31, t0.is_vip AS is_vip_32, t0.is_seller AS is_seller_33, t0.company_id AS company_id_34, t0.groupe_id AS groupe_id_35, t0.team_id AS team_id_36 FROM user t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.gender AS gender_2,
  t0.fname AS fname_3,
  t0.lname AS lname_4,
  t0.email AS email_5,
  t0.email_token AS email_token_6,
  t0.username AS username_7,
  t0.password AS password_8,
  t0.password_token AS password_token_9,
  t0.roles AS roles_10,
  t0.birthday AS birthday_11,
  t0.phone AS phone_12,
  t0.phone_token AS phone_token_13,
  t0.avatar AS avatar_14,
  t0.type AS type_15,
  t0.status AS status_16,
  t0.lang AS lang_17,
  t0.address1 AS address1_18,
  t0.address2 AS address2_19,
  t0.zipcode AS zipcode_20,
  t0.city AS city_21,
  t0.social_brand AS social_brand_22,
  t0.social_id AS social_id_23,
  t0.country AS country_24,
  t0.created_at AS created_at_25,
  t0.updated_at AS updated_at_26,
  t0.last_login AS last_login_27,
  t0.trusted_version AS trusted_version_28,
  t0.is_verified AS is_verified_29,
  t0.description AS description_30,
  t0.location AS location_31,
  t0.is_vip AS is_vip_32,
  t0.is_seller AS is_seller_33,
  t0.company_id AS company_id_34,
  t0.groupe_id AS groupe_id_35,
  t0.team_id AS team_id_36
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.gender AS gender_2, t0.fname AS fname_3, t0.lname AS lname_4, t0.email AS email_5, t0.email_token AS email_token_6, t0.username AS username_7, t0.password AS password_8, t0.password_token AS password_token_9, t0.roles AS roles_10, t0.birthday AS birthday_11, t0.phone AS phone_12, t0.phone_token AS phone_token_13, t0.avatar AS avatar_14, t0.type AS type_15, t0.status AS status_16, t0.lang AS lang_17, t0.address1 AS address1_18, t0.address2 AS address2_19, t0.zipcode AS zipcode_20, t0.city AS city_21, t0.social_brand AS social_brand_22, t0.social_id AS social_id_23, t0.country AS country_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26, t0.last_login AS last_login_27, t0.trusted_version AS trusted_version_28, t0.is_verified AS is_verified_29, t0.description AS description_30, t0.location AS location_31, t0.is_vip AS is_vip_32, t0.is_seller AS is_seller_33, t0.company_id AS company_id_34, t0.groupe_id AS groupe_id_35, t0.team_id AS team_id_36 FROM user t0 WHERE t0.id = 1;

0.26 ms
(36.30%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.phone AS phone_4, t0.address AS address_5, t0.email AS email_6, t0.description AS description_7, t0.domain AS domain_8, t0.lat AS lat_9, t0.lan AS lan_10, t0.placeid AS placeid_11, t0.banner AS banner_12, t0.color AS color_13, t0.menu_redirection AS menu_redirection_14, t0.ftheme AS ftheme_15, t0.redirectiontype AS redirectiontype_16, t0.formlabel AS formlabel_17, t0.formbanner AS formbanner_18, t0.formtitle AS formtitle_19, t0.redirectionurl AS redirectionurl_20, t0.views AS views_21, t0.revendeur_id AS revendeur_id_22 FROM company t0

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.logo AS logo_3,
  t0.phone AS phone_4,
  t0.address AS address_5,
  t0.email AS email_6,
  t0.description AS description_7,
  t0.domain AS domain_8,
  t0.lat AS lat_9,
  t0.lan AS lan_10,
  t0.placeid AS placeid_11,
  t0.banner AS banner_12,
  t0.color AS color_13,
  t0.menu_redirection AS menu_redirection_14,
  t0.ftheme AS ftheme_15,
  t0.redirectiontype AS redirectiontype_16,
  t0.formlabel AS formlabel_17,
  t0.formbanner AS formbanner_18,
  t0.formtitle AS formtitle_19,
  t0.redirectionurl AS redirectionurl_20,
  t0.views AS views_21,
  t0.revendeur_id AS revendeur_id_22
FROM
  company t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.phone AS phone_4, t0.address AS address_5, t0.email AS email_6, t0.description AS description_7, t0.domain AS domain_8, t0.lat AS lat_9, t0.lan AS lan_10, t0.placeid AS placeid_11, t0.banner AS banner_12, t0.color AS color_13, t0.menu_redirection AS menu_redirection_14, t0.ftheme AS ftheme_15, t0.redirectiontype AS redirectiontype_16, t0.formlabel AS formlabel_17, t0.formbanner AS formbanner_18, t0.formtitle AS formtitle_19, t0.redirectionurl AS redirectionurl_20, t0.views AS views_21, t0.revendeur_id AS revendeur_id_22 FROM company t0;

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\User	No errors.
App\Entity\Company	No errors.
App\Entity\Groupe	No errors.
App\Entity\Team	No errors.
App\Entity\Media	No errors.
App\Entity\Tag	The mappings App\Entity\Tag#tagreads and App\Entity\Tagread#tag are inconsistent with each other.
App\Entity\Campaign	No errors.
App\Entity\Role	The association App\Entity\Role#assignees refers to the owning side field App\Entity\User#assignedRoles which does not exist.
App\Entity\Tagread	The association App\Entity\Tagread#tag refers to the inverse side field App\Entity\Tag#tagReads which does not exist. The association App\Entity\Tagread#user refers to the inverse side field App\Entity\User#tagReads which does not exist.
App\Entity\ItemCategory	No errors.
App\Entity\Menu	No errors.
App\Entity\CompanyForm	No errors.

Symfony Profiler

GET https://app.nfcretail.com/company/

Configuration Settings

Theme