Symfony Profiler

Query Metrics

11 Database Queries

5 Different statements

6.74 ms Query time

1 Invalid entities

20 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.36 ms
(49.85%)

SELECT t0.id AS id_1, t0.commission_rate AS commission_rate_2, t0.partner_since AS partner_since_3, t0.is_active AS is_active_4, t0.contact_email AS contact_email_5, t0.contact_phone AS contact_phone_6, t0.contract_file AS contract_file_7, t0.contract_details AS contract_details_8, t0.business_id AS business_id_9 FROM business_partner t0 WHERE t0.business_id = ?

Parameters:

[
  13
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.commission_rate AS commission_rate_2,
  t0.partner_since AS partner_since_3,
  t0.is_active AS is_active_4,
  t0.contact_email AS contact_email_5,
  t0.contact_phone AS contact_phone_6,
  t0.contract_file AS contract_file_7,
  t0.contract_details AS contract_details_8,
  t0.business_id AS business_id_9
FROM
  business_partner t0
WHERE
  t0.business_id = ?

SELECT t0.id AS id_1, t0.commission_rate AS commission_rate_2, t0.partner_since AS partner_since_3, t0.is_active AS is_active_4, t0.contact_email AS contact_email_5, t0.contact_phone AS contact_phone_6, t0.contract_file AS contract_file_7, t0.contract_details AS contract_details_8, t0.business_id AS business_id_9 FROM business_partner t0 WHERE t0.business_id = 13;

#	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\Controller\Public\BusinessController->index (line 48)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 193)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 32)
17	require_once (line 5)

1.23 ms
(18.30%)

SELECT b0_.id AS id_0, b0_.nom_activite AS nom_activite_1, b0_.description AS description_2, b0_.adresse AS adresse_3, b0_.telephone AS telephone_4, b0_.logo AS logo_5, b0_.slug AS slug_6, b0_.is_visible AS is_visible_7, b0_.nombre_visit AS nombre_visit_8, b0_.created_at AS created_at_9, b0_.updated_at AS updated_at_10, b0_.code AS code_11, b0_.ville AS ville_12, b0_.localisation AS localisation_13, b0_.subscription_status AS subscription_status_14, b0_.grace_period_started_at AS grace_period_started_at_15, b0_.business_creer_par_id AS business_creer_par_id_16, b0_.settings_id AS settings_id_17, b0_.qr_code_id AS qr_code_id_18, b0_.type_business_id AS type_business_id_19 FROM business b0_ LEFT JOIN type_business t1_ ON b0_.type_business_id = t1_.id WHERE b0_.is_visible = ? ORDER BY b0_.created_at DESC LIMIT 6

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.nom_activite AS nom_activite_1,
  b0_.description AS description_2,
  b0_.adresse AS adresse_3,
  b0_.telephone AS telephone_4,
  b0_.logo AS logo_5,
  b0_.slug AS slug_6,
  b0_.is_visible AS is_visible_7,
  b0_.nombre_visit AS nombre_visit_8,
  b0_.created_at AS created_at_9,
  b0_.updated_at AS updated_at_10,
  b0_.code AS code_11,
  b0_.ville AS ville_12,
  b0_.localisation AS localisation_13,
  b0_.subscription_status AS subscription_status_14,
  b0_.grace_period_started_at AS grace_period_started_at_15,
  b0_.business_creer_par_id AS business_creer_par_id_16,
  b0_.settings_id AS settings_id_17,
  b0_.qr_code_id AS qr_code_id_18,
  b0_.type_business_id AS type_business_id_19
FROM
  business b0_
  LEFT JOIN type_business t1_ ON b0_.type_business_id = t1_.id
WHERE
  b0_.is_visible = ?
ORDER BY
  b0_.created_at DESC
LIMIT
  6

SELECT b0_.id AS id_0, b0_.nom_activite AS nom_activite_1, b0_.description AS description_2, b0_.adresse AS adresse_3, b0_.telephone AS telephone_4, b0_.logo AS logo_5, b0_.slug AS slug_6, b0_.is_visible AS is_visible_7, b0_.nombre_visit AS nombre_visit_8, b0_.created_at AS created_at_9, b0_.updated_at AS updated_at_10, b0_.code AS code_11, b0_.ville AS ville_12, b0_.localisation AS localisation_13, b0_.subscription_status AS subscription_status_14, b0_.grace_period_started_at AS grace_period_started_at_15, b0_.business_creer_par_id AS business_creer_par_id_16, b0_.settings_id AS settings_id_17, b0_.qr_code_id AS qr_code_id_18, b0_.type_business_id AS type_business_id_19 FROM business b0_ LEFT JOIN type_business t1_ ON b0_.type_business_id = t1_.id WHERE b0_.is_visible = 1 ORDER BY b0_.created_at DESC LIMIT 6;

#	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\Controller\Public\BusinessController->index (line 48)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

0.83 ms
(12.24%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.is_actif AS is_actif_5, t0.creer_by_admin_id AS creer_by_admin_id_6, t0.delete_by_admin_id AS delete_by_admin_id_7 FROM type_business t0 WHERE t0.id = ?

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.slug AS slug_3,
  t0.created_at AS created_at_4,
  t0.is_actif AS is_actif_5,
  t0.creer_by_admin_id AS creer_by_admin_id_6,
  t0.delete_by_admin_id AS delete_by_admin_id_7
FROM
  type_business t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.is_actif AS is_actif_5, t0.creer_by_admin_id AS creer_by_admin_id_6, t0.delete_by_admin_id AS delete_by_admin_id_7 FROM type_business t0 WHERE t0.id = 6;

#	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->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\TypeBusiness::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\TypeBusiness->__get (line 153)
7	App\Entity\TypeBusiness->getNom (line 62)
8	App\Controller\Public\BusinessController->index (line 86)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

0.68 ms
(10.07%)

SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.email_principal AS email_principal_3, t0.email_contact AS email_contact_4, t0.telephone AS telephone_5, t0.whatsapp AS whatsapp_6, t0.adresse AS adresse_7, t0.facebook AS facebook_8, t0.instagram AS instagram_9, t0.twitter AS twitter_10, t0.is_maintenance_mode AS is_maintenance_mode_11, t0.maintenance_message AS maintenance_message_12, t0.logo AS logo_13, t0.description AS description_14 FROM global_setting t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.site_name AS site_name_2,
  t0.email_principal AS email_principal_3,
  t0.email_contact AS email_contact_4,
  t0.telephone AS telephone_5,
  t0.whatsapp AS whatsapp_6,
  t0.adresse AS adresse_7,
  t0.facebook AS facebook_8,
  t0.instagram AS instagram_9,
  t0.twitter AS twitter_10,
  t0.is_maintenance_mode AS is_maintenance_mode_11,
  t0.maintenance_message AS maintenance_message_12,
  t0.logo AS logo_13,
  t0.description AS description_14
FROM
  global_setting t0
LIMIT
  1

SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.email_principal AS email_principal_3, t0.email_contact AS email_contact_4, t0.telephone AS telephone_5, t0.whatsapp AS whatsapp_6, t0.adresse AS adresse_7, t0.facebook AS facebook_8, t0.instagram AS instagram_9, t0.twitter AS twitter_10, t0.is_maintenance_mode AS is_maintenance_mode_11, t0.maintenance_message AS maintenance_message_12, t0.logo AS logo_13, t0.description AS description_14 FROM global_setting t0 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\Repository\GlobalSettingRepository->getSettings (line 26)
5	App\Service\SettingService->getSettings (line 28)
6	App\Service\SettingService->isMaintenanceMode (line 41)
7	App\EventSubscriber\MaintenanceSubscriber->onKernelRequest (line 51)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 193)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 32)
17	require_once (line 5)

0.64 ms
(9.54%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.is_actif AS is_actif_5, t0.creer_by_admin_id AS creer_by_admin_id_6, t0.delete_by_admin_id AS delete_by_admin_id_7 FROM type_business t0 WHERE t0.is_actif = ? ORDER BY t0.nom ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.slug AS slug_3,
  t0.created_at AS created_at_4,
  t0.is_actif AS is_actif_5,
  t0.creer_by_admin_id AS creer_by_admin_id_6,
  t0.delete_by_admin_id AS delete_by_admin_id_7
FROM
  type_business t0
WHERE
  t0.is_actif = ?
ORDER BY
  t0.nom ASC

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.is_actif AS is_actif_5, t0.creer_by_admin_id AS creer_by_admin_id_6, t0.delete_by_admin_id AS delete_by_admin_id_7 FROM type_business t0 WHERE t0.is_actif = 1 ORDER BY t0.nom ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\Public\BusinessController->index (line 95)
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\Business	6
App\Entity\QrCode	6
App\Entity\TypeBusiness	6
App\Entity\GlobalSetting	1
App\Entity\User	1

Entities Mapping

Class	Mapping errors
App\Entity\GlobalSetting	No errors.
App\Entity\Business	No errors.
App\Entity\TypeBusiness	The mappings App\Entity\TypeBusiness#deleteByAdmin and App\Entity\User#typeBusinesses are inconsistent with each other.
App\Entity\User	No errors.
App\Entity\BusinessSettings	No errors.
App\Entity\QrCode	No errors.
App\Entity\Subscription	No errors.
App\Entity\BusinessPartner	No errors.
App\Entity\Menu	No errors.
App\Entity\Item	No errors.
App\Entity\Visit	No errors.
App\Entity\Payment	No errors.
App\Entity\PaymentRecord	No errors.
App\Entity\Invoice	No errors.
App\Entity\ServiceOrder	No errors.
App\Entity\BusinessPhone	No errors.
App\Entity\QrCodeMedia	No errors.
App\Entity\BusinessMember	No errors.

Symfony Profiler

GET https://www.menu221.pmd-groupe.com/annuaire

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping