Symfony Profiler

Query Metrics

8 Database Queries

4 Different statements

1.48 ms Query time

1 Invalid entities

7 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.55 ms
(37.11%)

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.rate AS rate_3, a0_.datein AS datein_4, a0_.priceexpected AS priceexpected_5, a0_.offline AS offline_6, a0_.online AS online_7, a0_.section AS section_8, a0_.invoice AS invoice_9, a0_.receipt_sent AS receipt_sent_10, a0_.dateout AS dateout_11, a0_.pricerealized AS pricerealized_12, a0_.returned AS returned_13, s1_.id AS id_14, s1_.prename AS prename_15, s1_.name AS name_16, s1_.street AS street_17, s1_.country AS country_18, s1_.zip AS zip_19, s1_.city AS city_20, s1_.email AS email_21, s1_.rate AS rate_22, s1_.iban AS iban_23, a0_.supplier_id AS supplier_id_24, a0_.bon_id AS bon_id_25 FROM articles a0_ LEFT JOIN suppliers s1_ ON a0_.supplier_id = s1_.id WHERE a0_.returned IS NULL AND a0_.invoice IS NULL ORDER BY a0_.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.description AS description_2,
  a0_.rate AS rate_3,
  a0_.datein AS datein_4,
  a0_.priceexpected AS priceexpected_5,
  a0_.offline AS offline_6,
  a0_.online AS online_7,
  a0_.section AS section_8,
  a0_.invoice AS invoice_9,
  a0_.receipt_sent AS receipt_sent_10,
  a0_.dateout AS dateout_11,
  a0_.pricerealized AS pricerealized_12,
  a0_.returned AS returned_13,
  s1_.id AS id_14,
  s1_.prename AS prename_15,
  s1_.name AS name_16,
  s1_.street AS street_17,
  s1_.country AS country_18,
  s1_.zip AS zip_19,
  s1_.city AS city_20,
  s1_.email AS email_21,
  s1_.rate AS rate_22,
  s1_.iban AS iban_23,
  a0_.supplier_id AS supplier_id_24,
  a0_.bon_id AS bon_id_25
FROM
  articles a0_
  LEFT JOIN suppliers s1_ ON a0_.supplier_id = s1_.id
WHERE
  a0_.returned IS NULL
  AND a0_.invoice IS NULL
ORDER BY
  a0_.name ASC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.rate AS rate_3, a0_.datein AS datein_4, a0_.priceexpected AS priceexpected_5, a0_.offline AS offline_6, a0_.online AS online_7, a0_.section AS section_8, a0_.invoice AS invoice_9, a0_.receipt_sent AS receipt_sent_10, a0_.dateout AS dateout_11, a0_.pricerealized AS pricerealized_12, a0_.returned AS returned_13, s1_.id AS id_14, s1_.prename AS prename_15, s1_.name AS name_16, s1_.street AS street_17, s1_.country AS country_18, s1_.zip AS zip_19, s1_.city AS city_20, s1_.email AS email_21, s1_.rate AS rate_22, s1_.iban AS iban_23, a0_.supplier_id AS supplier_id_24, a0_.bon_id AS bon_id_25 FROM articles a0_ LEFT JOIN suppliers s1_ ON a0_.supplier_id = s1_.id WHERE a0_.returned IS NULL AND a0_.invoice IS NULL ORDER BY a0_.name ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\ArticlesRepository->findActiveArticles (line 189)
7	App\Controller\CollectController->inventoryCompare (line 223)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.50 ms
(33.58%)

SELECT t0.id AS id_1, t0.amountnet AS amountnet_2, t0.billsid_id AS billsid_id_3, t0.articleid_id AS articleid_id_4 FROM billpositions t0 WHERE t0.articleid_id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.amountnet AS amountnet_2,
  t0.billsid_id AS billsid_id_3,
  t0.articleid_id AS articleid_id_4
FROM
  billpositions t0
WHERE
  t0.articleid_id = ?

SELECT t0.id AS id_1, t0.amountnet AS amountnet_2, t0.billsid_id AS billsid_id_3, t0.articleid_id AS articleid_id_4 FROM billpositions t0 WHERE t0.articleid_id = 4;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 837)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2458)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 495)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
9	Doctrine\ORM\AbstractQuery->execute (line 886)
10	Doctrine\ORM\AbstractQuery->getResult (line 688)
11	App\Repository\ArticlesRepository->findActiveArticles (line 189)
12	App\Controller\CollectController->inventoryCompare (line 223)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 193)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 32)
18	require_once (line 5)

0.27 ms
(18.14%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.totp_secret AS totp_secret_5, t0.nonce AS nonce_6, t0.timestamp AS timestamp_7 FROM `user` t0 WHERE t0.email = ? LIMIT 1

Parameters:

[
  "owagner@ad-libitum.info"
]

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.totp_secret AS totp_secret_5,
  t0.nonce AS nonce_6,
  t0.timestamp AS timestamp_7
FROM
  `user` t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.totp_secret AS totp_secret_5, t0.nonce AS nonce_6, t0.timestamp AS timestamp_7 FROM `user` t0 WHERE t0.email = 'owagner@ad-libitum.info' 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	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 57)
5	Symfony\Component\Security\Http\RememberMe\AbstractRememberMeHandler->consumeRememberMeCookie (line 60)
6	Symfony\Component\Security\Http\RememberMe\SignatureRememberMeHandler->consumeRememberMeCookie (line 64)
7	Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator->Symfony\Component\Security\Http\Authenticator\{closure} (line 105)
8	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 97)
9	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 56)
10	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 40)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 189)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
17	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
18	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
19	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
20	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
21	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
22	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
23	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
24	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
25	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
26	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
27	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 193)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 32)
33	require_once (line 5)

0.16 ms
(11.17%)

SELECT i0_.article_id AS article_id_0 FROM inventory i0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  i0_.article_id AS article_id_0
FROM
  inventory i0_

SELECT i0_.article_id AS article_id_0 FROM inventory i0_;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	App\Repository\InventoryRepository->findAllArticleIds (line 27)
7	App\Controller\CollectController->inventoryCompare (line 225)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	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\Articles	5
App\Entity\User	1
App\Entity\Suppliers	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Supplierbills	The association App\Entity\Supplierbills#articles refers to the owning side field App\Entity\Articles#paid which does not exist.
App\Entity\Bills	No errors.
App\Entity\Articles	No errors.
App\Entity\Suppliers	No errors.
App\Entity\Billpositions	No errors.
App\Entity\Inventory	No errors.

Symfony Profiler

GET https://2hand.ad-libitum.info/inventory/compare

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping