Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

2.59 ms Query time

0 Invalid entities

7 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.85 ms
(32.73%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.google AS google_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.legal_name AS legal_name_7, t0.sex AS sex_8, t0.account_type AS account_type_9, t0.nin AS nin_10, t0.status AS status_11, t0.is_suspended AS is_suspended_12, t0.roles AS roles_13, t0.balance AS balance_14, t0.is_subscribed AS is_subscribed_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.language_id AS language_id_18, t19.id AS id_20, t19.phone_number AS phone_number_21, t19.status AS status_22, t19.code AS code_23, t19.ip_address AS ip_address_24, t19.created_at AS created_at_25, t19.updated_at AS updated_at_26, t19.tenant_id AS tenant_id_27 FROM ax_tenant t0 LEFT JOIN ax_tenant_phone t19 ON t19.tenant_id = t0.id WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.google AS google_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.legal_name AS legal_name_7,
  t0.sex AS sex_8,
  t0.account_type AS account_type_9,
  t0.nin AS nin_10,
  t0.status AS status_11,
  t0.is_suspended AS is_suspended_12,
  t0.roles AS roles_13,
  t0.balance AS balance_14,
  t0.is_subscribed AS is_subscribed_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.language_id AS language_id_18,
  t19.id AS id_20,
  t19.phone_number AS phone_number_21,
  t19.status AS status_22,
  t19.code AS code_23,
  t19.ip_address AS ip_address_24,
  t19.created_at AS created_at_25,
  t19.updated_at AS updated_at_26,
  t19.tenant_id AS tenant_id_27
FROM
  ax_tenant t0
  LEFT JOIN ax_tenant_phone t19 ON t19.tenant_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.google AS google_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.legal_name AS legal_name_7, t0.sex AS sex_8, t0.account_type AS account_type_9, t0.nin AS nin_10, t0.status AS status_11, t0.is_suspended AS is_suspended_12, t0.roles AS roles_13, t0.balance AS balance_14, t0.is_subscribed AS is_subscribed_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.language_id AS language_id_18, t19.id AS id_20, t19.phone_number AS phone_number_21, t19.status AS status_22, t19.code AS code_23, t19.ip_address AS ip_address_24, t19.created_at AS created_at_25, t19.updated_at AS updated_at_26, t19.tenant_id AS tenant_id_27 FROM ax_tenant t0 LEFT JOIN ax_tenant_phone t19 ON t19.tenant_id = t0.id WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	Twig\Extension\CoreExtension::getAttribute (line 1794)
5	__TwigTemplate_6b80a6dc8ab6f94ecc2dc153b8c956a3::block_main (line 323)
6	Twig\Template->yieldBlock (line 456)
7	__TwigTemplate_61433065f3b2e50e0fc235b628ea20cf->doDisplay (line 178)
8	Twig\Template->yield (line 411)
9	__TwigTemplate_6b80a6dc8ab6f94ecc2dc153b8c956a3->doDisplay (line 59)
10	Twig\Template->yield (line 411)
11	Twig\Template->display (line 366)
12	Twig\Template->render (line 381)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 472)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 477)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 281)
18	App\Controller\Landlord\LandlordInvoiceController->list (line 75)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
21	Symfony\Component\HttpKernel\Kernel->handle (line 143)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
23	require_once (line 32)
24	require_once (line 5)

0.71 ms
(27.22%)

SELECT DISTINCT a0_.id AS id_0, a0_.created_at AS created_at_1 FROM ax_invoice a0_ INNER JOIN ax_contract a1_ ON a0_.contract_id = a1_.id WHERE a1_.landlord_id = ? ORDER BY a0_.created_at DESC LIMIT 10

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT a0_.id AS id_0,
  a0_.created_at AS created_at_1
FROM
  ax_invoice a0_
  INNER JOIN ax_contract a1_ ON a0_.contract_id = a1_.id
WHERE
  a1_.landlord_id = ?
ORDER BY
  a0_.created_at DESC
LIMIT
  10

SELECT DISTINCT a0_.id AS id_0, a0_.created_at AS created_at_1 FROM ax_invoice a0_ INNER JOIN ax_contract a1_ ON a0_.contract_id = a1_.id WHERE a1_.landlord_id = 1 ORDER BY a0_.created_at DESC LIMIT 10;

#	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	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	App\Pagination\Paginator->paginate (line 56)
8	App\Repository\InvoiceRepository->findAllByLandlord (line 58)
9	App\Controller\Landlord\LandlordInvoiceController->list (line 73)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
12	Symfony\Component\HttpKernel\Kernel->handle (line 143)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
14	require_once (line 32)
15	require_once (line 5)

0.46 ms
(17.85%)

SELECT a0_.id AS id_0, a0_.invoice_number AS invoice_number_1, a0_.status AS status_2, a0_.due_date AS due_date_3, a0_.paid_at AS paid_at_4, a0_.period_start AS period_start_5, a0_.period_end AS period_end_6, a0_.total_amount AS total_amount_7, a0_.notes AS notes_8, a0_.created_at AS created_at_9, a0_.updated_at AS updated_at_10, a0_.contract_id AS contract_id_11, a0_.currency_id AS currency_id_12 FROM ax_invoice a0_ INNER JOIN ax_contract a1_ ON a0_.contract_id = a1_.id WHERE a1_.landlord_id = ? AND a0_.id IN (?, ?) ORDER BY a0_.created_at DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.invoice_number AS invoice_number_1,
  a0_.status AS status_2,
  a0_.due_date AS due_date_3,
  a0_.paid_at AS paid_at_4,
  a0_.period_start AS period_start_5,
  a0_.period_end AS period_end_6,
  a0_.total_amount AS total_amount_7,
  a0_.notes AS notes_8,
  a0_.created_at AS created_at_9,
  a0_.updated_at AS updated_at_10,
  a0_.contract_id AS contract_id_11,
  a0_.currency_id AS currency_id_12
FROM
  ax_invoice a0_
  INNER JOIN ax_contract a1_ ON a0_.contract_id = a1_.id
WHERE
  a1_.landlord_id = ?
  AND a0_.id IN (?, ?)
ORDER BY
  a0_.created_at DESC

SELECT a0_.id AS id_0, a0_.invoice_number AS invoice_number_1, a0_.status AS status_2, a0_.due_date AS due_date_3, a0_.paid_at AS paid_at_4, a0_.period_start AS period_start_5, a0_.period_end AS period_end_6, a0_.total_amount AS total_amount_7, a0_.notes AS notes_8, a0_.created_at AS created_at_9, a0_.updated_at AS updated_at_10, a0_.contract_id AS contract_id_11, a0_.currency_id AS currency_id_12 FROM ax_invoice a0_ INNER JOIN ax_contract a1_ ON a0_.contract_id = a1_.id WHERE a1_.landlord_id = 1 AND a0_.id IN (2, 1) ORDER BY a0_.created_at DESC;

#	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	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
7	App\Pagination\Paginator->paginate (line 56)
8	App\Repository\InvoiceRepository->findAllByLandlord (line 58)
9	App\Controller\Landlord\LandlordInvoiceController->list (line 73)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
12	Symfony\Component\HttpKernel\Kernel->handle (line 143)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
14	require_once (line 32)
15	require_once (line 5)

0.21 ms
(8.28%)

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.org AS org_4, t0.street AS street_5, t0.city AS city_6, t0.district AS district_7, t0.postal_code AS postal_code_8, t0.country AS country_9, t0.phone_number AS phone_number_10, t0.email AS email_11, t0.bank_account AS bank_account_12, t0.bank_name AS bank_name_13, t0.ic_serial_number AS ic_serial_number_14, t0.authority AS authority_15, t0.ic_issue_date AS ic_issue_date_16, t0.ic_expiration_date AS ic_expiration_date_17, t0.birth_date AS birth_date_18, t0.number AS number_19, t0.signature_date AS signature_date_20, t0.start_date AS start_date_21, t0.termination_date AS termination_date_22, t0.registration_number AS registration_number_23, t0.notes AS notes_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26, t0.landlord_id AS landlord_id_27, t0.tenant_id AS tenant_id_28 FROM ax_contract t0 WHERE t0.id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.org AS org_4,
  t0.street AS street_5,
  t0.city AS city_6,
  t0.district AS district_7,
  t0.postal_code AS postal_code_8,
  t0.country AS country_9,
  t0.phone_number AS phone_number_10,
  t0.email AS email_11,
  t0.bank_account AS bank_account_12,
  t0.bank_name AS bank_name_13,
  t0.ic_serial_number AS ic_serial_number_14,
  t0.authority AS authority_15,
  t0.ic_issue_date AS ic_issue_date_16,
  t0.ic_expiration_date AS ic_expiration_date_17,
  t0.birth_date AS birth_date_18,
  t0.number AS number_19,
  t0.signature_date AS signature_date_20,
  t0.start_date AS start_date_21,
  t0.termination_date AS termination_date_22,
  t0.registration_number AS registration_number_23,
  t0.notes AS notes_24,
  t0.created_at AS created_at_25,
  t0.updated_at AS updated_at_26,
  t0.landlord_id AS landlord_id_27,
  t0.tenant_id AS tenant_id_28
FROM
  ax_contract t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.org AS org_4, t0.street AS street_5, t0.city AS city_6, t0.district AS district_7, t0.postal_code AS postal_code_8, t0.country AS country_9, t0.phone_number AS phone_number_10, t0.email AS email_11, t0.bank_account AS bank_account_12, t0.bank_name AS bank_name_13, t0.ic_serial_number AS ic_serial_number_14, t0.authority AS authority_15, t0.ic_issue_date AS ic_issue_date_16, t0.ic_expiration_date AS ic_expiration_date_17, t0.birth_date AS birth_date_18, t0.number AS number_19, t0.signature_date AS signature_date_20, t0.start_date AS start_date_21, t0.termination_date AS termination_date_22, t0.registration_number AS registration_number_23, t0.notes AS notes_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26, t0.landlord_id AS landlord_id_27, t0.tenant_id AS tenant_id_28 FROM ax_contract t0 WHERE t0.id = 4;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	Twig\Extension\CoreExtension::getAttribute (line 1794)
5	__TwigTemplate_6b80a6dc8ab6f94ecc2dc153b8c956a3::block_main (line 323)
6	Twig\Template->yieldBlock (line 456)
7	__TwigTemplate_61433065f3b2e50e0fc235b628ea20cf->doDisplay (line 178)
8	Twig\Template->yield (line 411)
9	__TwigTemplate_6b80a6dc8ab6f94ecc2dc153b8c956a3->doDisplay (line 59)
10	Twig\Template->yield (line 411)
11	Twig\Template->display (line 366)
12	Twig\Template->render (line 381)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 472)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 477)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 281)
18	App\Controller\Landlord\LandlordInvoiceController->list (line 75)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
21	Symfony\Component\HttpKernel\Kernel->handle (line 143)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
23	require_once (line 32)
24	require_once (line 5)

0.19 ms
(7.36%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.google AS google_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.legal_name AS legal_name_7, t0.sex AS sex_8, t0.account_type AS account_type_9, t0.nin AS nin_10, t0.status AS status_11, t0.is_suspended AS is_suspended_12, t0.roles AS roles_13, t0.balance AS balance_14, t0.is_subscribed AS is_subscribed_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.language_id AS language_id_18, t19.id AS id_20, t19.phone_number AS phone_number_21, t19.status AS status_22, t19.code AS code_23, t19.ip_address AS ip_address_24, t19.created_at AS created_at_25, t19.updated_at AS updated_at_26, t19.landlord_id AS landlord_id_27 FROM ax_landlord t0 LEFT JOIN ax_landlord_phone t19 ON t19.landlord_id = t0.id WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.google AS google_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.legal_name AS legal_name_7,
  t0.sex AS sex_8,
  t0.account_type AS account_type_9,
  t0.nin AS nin_10,
  t0.status AS status_11,
  t0.is_suspended AS is_suspended_12,
  t0.roles AS roles_13,
  t0.balance AS balance_14,
  t0.is_subscribed AS is_subscribed_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.language_id AS language_id_18,
  t19.id AS id_20,
  t19.phone_number AS phone_number_21,
  t19.status AS status_22,
  t19.code AS code_23,
  t19.ip_address AS ip_address_24,
  t19.created_at AS created_at_25,
  t19.updated_at AS updated_at_26,
  t19.landlord_id AS landlord_id_27
FROM
  ax_landlord t0
  LEFT JOIN ax_landlord_phone t19 ON t19.landlord_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.google AS google_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.legal_name AS legal_name_7, t0.sex AS sex_8, t0.account_type AS account_type_9, t0.nin AS nin_10, t0.status AS status_11, t0.is_suspended AS is_suspended_12, t0.roles AS roles_13, t0.balance AS balance_14, t0.is_subscribed AS is_subscribed_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.language_id AS language_id_18, t19.id AS id_20, t19.phone_number AS phone_number_21, t19.status AS status_22, t19.code AS code_23, t19.ip_address AS ip_address_24, t19.created_at AS created_at_25, t19.updated_at AS updated_at_26, t19.landlord_id AS landlord_id_27 FROM ax_landlord t0 LEFT JOIN ax_landlord_phone t19 ON t19.landlord_id = t0.id WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->find (line 66)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 97)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 227)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 132)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 64)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 162)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
19	Symfony\Component\HttpKernel\Kernel->handle (line 143)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
21	require_once (line 32)
22	require_once (line 5)

0.17 ms
(6.55%)

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM ax_invoice a0_ INNER JOIN ax_contract a1_ ON a0_.contract_id = a1_.id WHERE a1_.landlord_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT a0_.id) AS sclr_0
FROM
  ax_invoice a0_
  INNER JOIN ax_contract a1_ ON a0_.contract_id = a1_.id
WHERE
  a1_.landlord_id = ?

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM ax_invoice a0_ INNER JOIN ax_contract a1_ ON a0_.contract_id = a1_.id WHERE a1_.landlord_id = 1;

#	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	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	App\Pagination\Paginator->paginate (line 57)
8	App\Repository\InvoiceRepository->findAllByLandlord (line 58)
9	App\Controller\Landlord\LandlordInvoiceController->list (line 73)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
12	Symfony\Component\HttpKernel\Kernel->handle (line 143)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
14	require_once (line 32)
15	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\Invoice	2
App\Entity\Landlord	1
App\Entity\Language	1
App\Entity\Contract	1
App\Entity\Currency	1
App\Entity\Tenant	1

Entities Mapping

Class	Mapping errors
App\Entity\Landlord	No errors.
App\Entity\Language	No errors.
App\Entity\LandlordPhone	No errors.
App\Entity\Property	No errors.
App\Entity\Contract	No errors.
App\Entity\Invoice	No errors.
App\Entity\Currency	No errors.
App\Entity\Tenant	No errors.
App\Entity\TenantPhone	No errors.

GET https://rent.n46.net/en/landlord/invoices/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping