Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.62 ms Query time

1 Invalid entities

3 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.62 ms

SELECT t0.nom_ar AS nom_ar_1, t0.nom_fr AS nom_fr_2, t0.create_date AS create_date_3, t0.write_date AS write_date_4, t0.active AS active_5, t0.code AS code_6, t0.id AS id_7, t0.company_name AS company_name_8, t0.logo_path AS logo_path_9, t0.address1 AS address1_10, t0.address2 AS address2_11, t0.city AS city_12, t0.state AS state_13, t0.zip AS zip_14, t0.country AS country_15, t0.phone AS phone_16, t0.email AS email_17, t0.website AS website_18, t0.fiscal_identification AS fiscal_identification_19, t0.decimal_format AS decimal_format_20, t0.date_format AS date_format_21, t0.timezone AS timezone_22, t0.password_policy_description AS password_policy_description_23, t0.roles_config AS roles_config_24, t0.estimate_number_format AS estimate_number_format_25, t0.delivery_note_number_format AS delivery_note_number_format_26, t0.units_of_measure_config AS units_of_measure_config_27, t0.currencies_config AS currencies_config_28, t0.default_tax_rates_config AS default_tax_rates_config_29, t0.payment_terms_config AS payment_terms_config_30, t0.default_credit_limit AS default_credit_limit_31, t0.smtp_server AS smtp_server_32, t0.smtp_port AS smtp_port_33, t0.smtp_user AS smtp_user_34, t0.smtp_use_tls AS smtp_use_tls_35, t0.created_by_id AS created_by_id_36, t0.modified_by_id AS modified_by_id_37, t0.default_language_id AS default_language_id_38, t0.default_currency_id AS default_currency_id_39 FROM configuration t0 ORDER BY t0.id ASC LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.nom_ar AS nom_ar_1,
  t0.nom_fr AS nom_fr_2,
  t0.create_date AS create_date_3,
  t0.write_date AS write_date_4,
  t0.active AS active_5,
  t0.code AS code_6,
  t0.id AS id_7,
  t0.company_name AS company_name_8,
  t0.logo_path AS logo_path_9,
  t0.address1 AS address1_10,
  t0.address2 AS address2_11,
  t0.city AS city_12,
  t0.state AS state_13,
  t0.zip AS zip_14,
  t0.country AS country_15,
  t0.phone AS phone_16,
  t0.email AS email_17,
  t0.website AS website_18,
  t0.fiscal_identification AS fiscal_identification_19,
  t0.decimal_format AS decimal_format_20,
  t0.date_format AS date_format_21,
  t0.timezone AS timezone_22,
  t0.password_policy_description AS password_policy_description_23,
  t0.roles_config AS roles_config_24,
  t0.estimate_number_format AS estimate_number_format_25,
  t0.delivery_note_number_format AS delivery_note_number_format_26,
  t0.units_of_measure_config AS units_of_measure_config_27,
  t0.currencies_config AS currencies_config_28,
  t0.default_tax_rates_config AS default_tax_rates_config_29,
  t0.payment_terms_config AS payment_terms_config_30,
  t0.default_credit_limit AS default_credit_limit_31,
  t0.smtp_server AS smtp_server_32,
  t0.smtp_port AS smtp_port_33,
  t0.smtp_user AS smtp_user_34,
  t0.smtp_use_tls AS smtp_use_tls_35,
  t0.created_by_id AS created_by_id_36,
  t0.modified_by_id AS modified_by_id_37,
  t0.default_language_id AS default_language_id_38,
  t0.default_currency_id AS default_currency_id_39
FROM
  configuration t0
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.nom_ar AS nom_ar_1, t0.nom_fr AS nom_fr_2, t0.create_date AS create_date_3, t0.write_date AS write_date_4, t0.active AS active_5, t0.code AS code_6, t0.id AS id_7, t0.company_name AS company_name_8, t0.logo_path AS logo_path_9, t0.address1 AS address1_10, t0.address2 AS address2_11, t0.city AS city_12, t0.state AS state_13, t0.zip AS zip_14, t0.country AS country_15, t0.phone AS phone_16, t0.email AS email_17, t0.website AS website_18, t0.fiscal_identification AS fiscal_identification_19, t0.decimal_format AS decimal_format_20, t0.date_format AS date_format_21, t0.timezone AS timezone_22, t0.password_policy_description AS password_policy_description_23, t0.roles_config AS roles_config_24, t0.estimate_number_format AS estimate_number_format_25, t0.delivery_note_number_format AS delivery_note_number_format_26, t0.units_of_measure_config AS units_of_measure_config_27, t0.currencies_config AS currencies_config_28, t0.default_tax_rates_config AS default_tax_rates_config_29, t0.payment_terms_config AS payment_terms_config_30, t0.default_credit_limit AS default_credit_limit_31, t0.smtp_server AS smtp_server_32, t0.smtp_port AS smtp_port_33, t0.smtp_user AS smtp_user_34, t0.smtp_use_tls AS smtp_use_tls_35, t0.created_by_id AS created_by_id_36, t0.modified_by_id AS modified_by_id_37, t0.default_language_id AS default_language_id_38, t0.default_currency_id AS default_currency_id_39 FROM configuration t0 ORDER BY t0.id ASC LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\SecurityController->login (line 29)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

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
App\Entity\Res\ResListeDeChoix	2
App\Entity\Settings\Configuration	1

Entities Mapping

Class	Mapping errors
App\Entity\Core\EntityBase	No errors.
App\Entity\Settings\Configuration	No errors.
App\Entity\Security\AppUser	The association App\Entity\Security\AppUser#logs refers to the owning side field App\Entity\Audit\Log#userId which is not defined as association, but as field. The association App\Entity\Security\AppUser#logs refers to the owning side field App\Entity\Audit\Log#userId which does not exist.
App\Entity\Res\ResListeDeChoix	No errors.

Symfony Profiler

GET https://www.labelhub.euroscan.ma/login

Configuration Settings

Theme

Page Width