Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

1.45 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.38 ms

SELECT DATABASE()

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DATABASE()

SELECT DATABASE();

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 622)
2	Doctrine\DBAL\Connection->fetchOne (line 262)
3	Doctrine\DBAL\Connection->getDatabase (line 1770)
4	Doctrine\DBAL\Schema\AbstractSchemaManager->getDatabase (line 352)
5	Doctrine\DBAL\Schema\AbstractSchemaManager->doListTableNames (line 58)
6	Doctrine\DBAL\Schema\MySQLSchemaManager->listTableNames (line 325)
7	Doctrine\DBAL\Schema\AbstractSchemaManager->tablesExist (line 215)
8	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->isInitialized (line 72)
9	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->getExecutedMigrations (line 43)
10	Doctrine\Bundle\MigrationsBundle\Collector\MigrationsCollector->collect (line 169)
11	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 108)
12	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 116)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 214)
17	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 202)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 117)
20	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 116)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 239)
25	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.92 ms

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME

Parameters:

[
  "landlord"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'landlord'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 435)
2	Doctrine\DBAL\Schema\MySQLSchemaManager->selectTableNames (line 356)
3	Doctrine\DBAL\Schema\AbstractSchemaManager->doListTableNames (line 58)
4	Doctrine\DBAL\Schema\MySQLSchemaManager->listTableNames (line 325)
5	Doctrine\DBAL\Schema\AbstractSchemaManager->tablesExist (line 215)
6	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->isInitialized (line 72)
7	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->getExecutedMigrations (line 43)
8	Doctrine\Bundle\MigrationsBundle\Collector\MigrationsCollector->collect (line 169)
9	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 108)
10	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 116)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 214)
15	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 202)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 117)
18	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 116)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 239)
23	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.15 ms

SELECT DATABASE()

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DATABASE()

SELECT DATABASE();

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 622)
2	Doctrine\DBAL\Connection->fetchOne (line 262)
3	Doctrine\DBAL\Connection->getDatabase (line 73)
4	Doctrine\Bundle\MigrationsBundle\Collector\MigrationsCollector->collect (line 169)
5	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 108)
6	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 116)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 214)
11	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 202)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 117)
14	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 116)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 239)
19	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	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\Tenat\Domain\Model\Common\Identity	No errors.
App\Tenat\Domain\Model\User	No errors.
App\Tenat\Domain\Model\Literature	No errors.
App\Tenat\Domain\Model\Deposit	No errors.
App\Tenat\Domain\Model\User\ResetPasswordRequest	No errors.
Vich\UploaderBundle\Entity\File	No errors.
App\Tenat\Domain\Model\IdentityDocument\IdentityDocument	No errors.
App\Tenat\Domain\Model\IdentityDocument\IdentityDocumentGroup	No errors.
App\Tenat\Domain\Model\Accounting\Transaction\Transaction	No errors.
App\Tenat\Domain\Model\Accounting\Transaction\JournalEntryTransaction	No errors.
App\Tenat\Domain\Model\Accounting\Transaction\RentDueEntryTransaction	No errors.
App\Tenat\Domain\Model\Accounting\Transaction\RentEntryTransaction	No errors.
App\Tenat\Domain\Model\Accounting\Transaction\ClosingEntryTransaction	No errors.
App\Tenat\Domain\Model\Accounting\Transaction\LiabilityEntryTransaction	No errors.
App\Tenat\Domain\Model\Accounting\Transaction\DepositDueEntryTransaction	No errors.
App\Tenat\Domain\Model\Accounting\Transaction\Entry\Entry	No errors.
App\Tenat\Domain\Model\Accounting\Account\Entity\EntityAccount	No errors.
App\Tenat\Domain\Model\Accounting\Account\Account	No errors.
App\Tenat\Domain\Model\Common\Approval\ApprovalStatus	No errors.
App\Tenat\Domain\Model\Guarantor	No errors.
App\Tenat\Domain\Model\Common\Location\UkAddress	No errors.
App\Tenat\Domain\Model\Property	No errors.
App\Tenat\Domain\Model\Property\EnergyPerformance\EnergyPerformanceRevision	No errors.
App\Tenat\Domain\Model\Property\Payment\PaymentInterval	No errors.
App\Tenat\Domain\Model\Property\PaymentScheduleTemplate	No errors.
App\Tenat\Domain\Model\Property\Expense	No errors.
App\Tenat\Domain\Model\Property\Information\Utilities	No errors.
App\Tenat\Domain\Model\Property\Information\CouncilTaxInformation	No errors.
App\Tenat\Domain\Model\Property\Information	No errors.
App\Tenat\Domain\Model\Property\LandRegistry\PricePaidRecord	No errors.
App\Tenat\Domain\Model\Property\Document\DocumentManager	No errors.
App\Tenat\Domain\Model\Property\Document\Document	No errors.
App\Tenat\Domain\Model\Property\Document\DocumentGroup	No errors.
App\Tenat\Domain\Model\Common\FileUpload	No errors.
App\Tenat\Domain\Model\Tenancy\TenantInvite	No errors.
App\Tenat\Domain\Model\Tenancy\Contract	No errors.
App\Tenat\Domain\Model\Tenancy\SectionNotice\History	No errors.
App\Tenat\Domain\Model\Tenancy\SectionNotice\Notice	No errors.
App\Tenat\Domain\Model\Tenancy\Contract\Revision	No errors.
App\Tenat\Domain\Model\Tenancy\PaymentSchedule	No errors.
App\Tenat\Domain\Model\Tenancy\PaymentSchedule\ScheduledPayment	No errors.
App\Tenat\Domain\Model\Tenancy\PreExistingContract	No errors.
App\Tenat\Domain\Model\Tenancy\Literature\LiteratureHistoryItem	No errors.
App\Tenat\Domain\Model\Tenancy\Agreement\AgreementIdentityDocumentGroup	No errors.
App\Tenat\Domain\Model\Tenancy\RentalPayment	No errors.
App\Tenat\Domain\Model\ViewingGuest	No errors.
App\Tenat\Domain\Model\Common\RequestMetadata	No errors.
App\Tenat\Domain\Model\Agreement	No errors.
App\Tenat\Domain\Model\Tenancy\GuarantorRequirements	No errors.
Mashbo\CoreRepository\Domain\Model\CarbonDateRange	No errors.
App\Tenat\Domain\Model\Tenancy\Deposit\DepositConfiguration	No errors.
App\Tenat\Domain\Model\Tenancy	No errors.
App\Tenat\Domain\Model\Guarantor\GuarantorInvite	No errors.
App\Tenat\Domain\Model\Payment\Gateway\Subscription	No errors.
App\Tenat\Domain\Model\Payment\Gateway\CustomerRecord	No errors.
App\Tenat\Domain\Model\Ticket	No errors.
App\Tenat\Domain\Model\Renewal\RenewalRequestTicket	No errors.
App\Tenat\Domain\Model\Viewing	No errors.
App\Tenat\Domain\Model\Gallery\PropertyPhotograph	No errors.
App\Tenat\Domain\Model\Common\Location\Coordinate	No errors.
App\Tenat\Domain\Model\Agency\Lead	No errors.
App\Tenat\Domain\Model\Agency\Agent	No errors.
App\Tenat\Domain\Model\Agency\AgentInvite	No errors.
App\Tenat\Domain\Model\PropertyManager	No errors.
App\Tenat\Domain\Model\Landlord	No errors.
App\Tenat\Domain\Model\Landlord\LandlordCompany	No errors.
App\Tenat\Domain\Model\Landlord\LandlordAgencyInvite	No errors.
App\Tenat\Domain\Model\Accounting\Report\ReportPeriod	No errors.
App\Tenat\Domain\Model\Landlord\Statement\LandlordStatement	No errors.
App\Tenat\Domain\Model\Landlord\DetachedLandlord	No errors.
App\Tenat\Domain\Model\Landlord\LandlordAgencyAssociation	No errors.
App\Tenat\Domain\Model\Landlord\LandlordIndividual	No errors.
App\Tenat\Domain\Model\Landlord\LandlordConsortium	No errors.
App\Tenat\Domain\Model\Ticket\Comment	No errors.
App\Tenat\Domain\Model\Ticket\TicketEvent	No errors.
App\Tenat\Domain\Model\Ticket\Event\TicketCommentWasMade	No errors.
App\Tenat\Domain\Model\Ticket\Event\TicketTitleWasUpdated	No errors.
App\Tenat\Domain\Model\Ticket\Event\TicketWasResolved	No errors.
App\Tenat\Domain\Model\Ticket\Event\TicketStatusWasUpdated	No errors.
App\Tenat\Domain\Model\Ticket\Event\TicketDescriptionWasUpdated	No errors.
App\Tenat\Domain\Model\Ticket\Event\TicketWasCreated	No errors.
App\Tenat\Domain\Model\Ticket\Event\TicketSubscriberWasRemoved	No errors.
App\Tenat\Domain\Model\Ticket\Event\TicketWasAssigned	No errors.
App\Tenat\Domain\Model\Ticket\Event\TicketTenancyWasUpdated	No errors.
App\Tenat\Domain\Model\Ticket\Event\TicketDueAtWasUpdated	No errors.
App\Tenat\Domain\Model\Ticket\Event\TicketSubscriberWasAdded	No errors.
App\Tenat\Domain\Model\Agency	No errors.
App\Tenat\Domain\Model\Room	No errors.
App\Tenat\Domain\Model\Tenant	No errors.
App\Tenat\Domain\Model\Location\LocalAuthority	No errors.
App\Tenat\Domain\Model\Location\Constituency	No errors.
Zenstruck\Messenger\Monitor\History\Model\ProcessedMessage	No errors.
App\Bridge\Zenstruck\MessengerMonitor\Domain\Model\ProcessedMessage	No errors.
Mashbo\CoreRepository\Domain\Model\DateRange	No errors.

Symfony Profiler

GET https://landlord.goodship.agency/robots.txt

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping