Symfony Profiler

Query Metrics

12 Database Queries

1 Different statements

2.50 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.50 ms
(100.00%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.doli_token AS doli_token_7, t0.username AS username_8, t0.dolibarr_user_id AS dolibarr_user_id_9, t0.is_employee AS is_employee_10, t11.id AS id_12, t11.doli_id AS doli_id_13, t11.title AS title_14, t11.ref AS ref_15, t11.status AS status_16, t11.category AS category_17, t11.project_id AS project_id_18, t11.user_id AS user_id_19, t0.contact_id AS contact_id_20 FROM admin_user t0 LEFT JOIN warehouse t11 ON t11.user_id = t0.id WHERE t0.username = ? LIMIT 1

Parameters:

[
  "api"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6,
  t0.doli_token AS doli_token_7,
  t0.username AS username_8,
  t0.dolibarr_user_id AS dolibarr_user_id_9,
  t0.is_employee AS is_employee_10,
  t11.id AS id_12,
  t11.doli_id AS doli_id_13,
  t11.title AS title_14,
  t11.ref AS ref_15,
  t11.status AS status_16,
  t11.category AS category_17,
  t11.project_id AS project_id_18,
  t11.user_id AS user_id_19,
  t0.contact_id AS contact_id_20
FROM
  admin_user t0
  LEFT JOIN warehouse t11 ON t11.user_id = t0.id
WHERE
  t0.username = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.doli_token AS doli_token_7, t0.username AS username_8, t0.dolibarr_user_id AS dolibarr_user_id_9, t0.is_employee AS is_employee_10, t11.id AS id_12, t11.doli_id AS doli_id_13, t11.title AS title_14, t11.ref AS ref_15, t11.status AS status_16, t11.category AS category_17, t11.project_id AS project_id_18, t11.user_id AS user_id_19, t0.contact_id AS contact_id_20 FROM admin_user t0 LEFT JOIN warehouse t11 ON t11.user_id = t0.id WHERE t0.username = 'api' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 26)
4	App\Model\ReadWrite\Contact->__construct (line 25)
5	ContainerYWhxAPx\getContactService::do (line 558)
6	ContainerYWhxAPx\App_KernelDevDebugContainer->load (line 25)
7	ContainerYWhxAPx\getServiceObjectService::do (line 558)
8	ContainerYWhxAPx\App_KernelDevDebugContainer->load (line 25)
9	ContainerYWhxAPx\getServiceOrderService::do (line 558)
10	ContainerYWhxAPx\App_KernelDevDebugContainer->load (line 25)
11	ContainerYWhxAPx\getAdminLoginControllerService::do (line 558)
12	ContainerYWhxAPx\App_KernelDevDebugContainer->load (line 220)
13	Symfony\Component\DependencyInjection\Container::make (line 202)
14	Symfony\Component\DependencyInjection\Container->get (line 40)
15	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 25)
16	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 128)
17	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 96)
18	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 36)
19	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 161)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	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.

Entities Mapping

Class	Mapping errors
App\Entity\AdminUser	No errors.
App\Entity\Warehouse	No errors.
App\Entity\Project	No errors.
App\Entity\Contact	No errors.
App\Entity\Order	No errors.
App\Entity\ServiceOrder	No errors.
App\Entity\Proposal	No errors.
App\Entity\TimeTracking	No errors.
App\Entity\ErpEvents	The referenced column name 'dolibarr_user_id' has to be a primary key column on the target entity class 'App\Entity\AdminUser'. The referenced column name 'doli_id' has to be a primary key column on the target entity class 'App\Entity\Project'. The referenced column name 'doli_id' has to be a primary key column on the target entity class 'App\Entity\Contact'.

Symfony Profiler

GET http://167.235.168.184:18059/login

Configuration Settings

Theme