Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

4.57 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

2.52 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.domaine_id AS domaine_id_6, t0.site_id AS site_id_7, t0.user_id AS user_id_8 FROM sub_domain t0 WHERE t0.name = ? AND t0.site_id IS NULL LIMIT 1

Parameters:

[
  "artemis-gestion.fr"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.deleted_at AS deleted_at_5,
  t0.domaine_id AS domaine_id_6,
  t0.site_id AS site_id_7,
  t0.user_id AS user_id_8
FROM
  sub_domain t0
WHERE
  t0.name = ?
  AND t0.site_id IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.domaine_id AS domaine_id_6, t0.site_id AS site_id_7, t0.user_id AS user_id_8 FROM sub_domain t0 WHERE t0.name = 'artemis-gestion.fr' AND t0.site_id IS NULL 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\ServiceEntityRepository->findOneBy (line 86)
4	App\Controller\Security\CaddyCheckController->__invoke (line 36)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
7	Symfony\Component\HttpKernel\Kernel->handle (line 143)
8	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner->{closure:Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run():51} (line 62)
9	frankenphp_handle_request (line 72)
10	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run (line 72)
11	require_once (line 32)
12	require_once (line 6)

0.38 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.domaine_id AS domaine_id_6, t0.site_id AS site_id_7, t0.user_id AS user_id_8 FROM sub_domain t0 WHERE t0.name = ? LIMIT 1

Parameters:

[
  "artemis-gestion.fr"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.deleted_at AS deleted_at_5,
  t0.domaine_id AS domaine_id_6,
  t0.site_id AS site_id_7,
  t0.user_id AS user_id_8
FROM
  sub_domain t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.domaine_id AS domaine_id_6, t0.site_id AS site_id_7, t0.user_id AS user_id_8 FROM sub_domain t0 WHERE t0.name = 'artemis-gestion.fr' 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\ServiceEntityRepository->findOneBy (line 86)
4	App\Controller\Security\CaddyCheckController->__invoke (line 38)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
7	Symfony\Component\HttpKernel\Kernel->handle (line 143)
8	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner->{closure:Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run():51} (line 62)
9	frankenphp_handle_request (line 72)
10	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run (line 72)
11	require_once (line 32)
12	require_once (line 6)

1.22 ms

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.created_at AS created_at_2, s0_.updated_at AS updated_at_3, s0_.deleted_at AS deleted_at_4, s0_.domaine_id AS domaine_id_5, s0_.site_id AS site_id_6, s0_.user_id AS user_id_7 FROM sub_domain s0_ INNER JOIN domaine d1_ ON s0_.domaine_id = d1_.id WHERE s0_.name = ? AND d1_.url = ?

Parameters:

[
  "artemis-gestion"
  "fr"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.created_at AS created_at_2,
  s0_.updated_at AS updated_at_3,
  s0_.deleted_at AS deleted_at_4,
  s0_.domaine_id AS domaine_id_5,
  s0_.site_id AS site_id_6,
  s0_.user_id AS user_id_7
FROM
  sub_domain s0_
  INNER JOIN domaine d1_ ON s0_.domaine_id = d1_.id
WHERE
  s0_.name = ?
  AND d1_.url = ?

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.created_at AS created_at_2, s0_.updated_at AS updated_at_3, s0_.deleted_at AS deleted_at_4, s0_.domaine_id AS domaine_id_5, s0_.site_id AS site_id_6, s0_.user_id AS user_id_7 FROM sub_domain s0_ INNER JOIN domaine d1_ ON s0_.domaine_id = d1_.id WHERE s0_.name = 'artemis-gestion' AND d1_.url = 'fr';

#	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->getOneOrNullResult (line 737)
6	App\Controller\Security\CaddyCheckController->__invoke (line 57)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
9	Symfony\Component\HttpKernel\Kernel->handle (line 143)
10	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner->{closure:Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run():51} (line 62)
11	frankenphp_handle_request (line 72)
12	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run (line 72)
13	require_once (line 32)
14	require_once (line 6)

0.44 ms

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.created_at AS created_at_2, s0_.updated_at AS updated_at_3, s0_.deleted_at AS deleted_at_4, s0_.domaine_id AS domaine_id_5, s0_.site_id AS site_id_6, s0_.user_id AS user_id_7 FROM sub_domain s0_ INNER JOIN domaine d1_ ON s0_.domaine_id = d1_.id WHERE s0_.name IS NULL AND d1_.url = ?

Parameters:

[
  "artemis-gestion.fr"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.created_at AS created_at_2,
  s0_.updated_at AS updated_at_3,
  s0_.deleted_at AS deleted_at_4,
  s0_.domaine_id AS domaine_id_5,
  s0_.site_id AS site_id_6,
  s0_.user_id AS user_id_7
FROM
  sub_domain s0_
  INNER JOIN domaine d1_ ON s0_.domaine_id = d1_.id
WHERE
  s0_.name IS NULL
  AND d1_.url = ?

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.created_at AS created_at_2, s0_.updated_at AS updated_at_3, s0_.deleted_at AS deleted_at_4, s0_.domaine_id AS domaine_id_5, s0_.site_id AS site_id_6, s0_.user_id AS user_id_7 FROM sub_domain s0_ INNER JOIN domaine d1_ ON s0_.domaine_id = d1_.id WHERE s0_.name IS NULL AND d1_.url = 'artemis-gestion.fr';

#	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->getOneOrNullResult (line 737)
6	App\Controller\Security\CaddyCheckController->__invoke (line 71)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
9	Symfony\Component\HttpKernel\Kernel->handle (line 143)
10	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner->{closure:Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run():51} (line 62)
11	frankenphp_handle_request (line 72)
12	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run (line 72)
13	require_once (line 32)
14	require_once (line 6)

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

Entities Mapping

Class	Mapping errors
App\Entity\Domaine	No errors.
App\Entity\UserInformation	No errors.
App\Entity\User	No errors.
App\Entity\EntrepriseUserInfo	No errors.
App\Entity\AutreUserInfo	No errors.
App\Entity\SubDomain	No errors.
App\Entity\Site	No errors.
App\Entity\PricingPlan	No errors.
App\Entity\AvisUtilisateurs	No errors.
App\Entity\Ticket	No errors.
App\Entity\NewsletterLog	No errors.
App\Entity\AppointmentType	No errors.
App\Entity\Employee	No errors.
App\Entity\Appointment	No errors.
App\Entity\Page	No errors.
App\Entity\NewsletterSubscription	No errors.
App\Entity\Newsletter	No errors.
App\Entity\SiteCategory	No errors.
App\Entity\PlanFeature	No errors.
App\Entity\PromoCode	No errors.
App\Entity\TicketReply	No errors.
App\Entity\UserPurchasedService	No errors.
App\Entity\PageBloc	No errors.
App\Entity\ResetPasswordRequest	No errors.
App\Entity\FieldOption	No errors.
App\Entity\Commande	No errors.
App\Entity\Field	No errors.
App\Entity\BoutiqueServiceItem	No errors.
App\Entity\CategorieJuridique	No errors.
App\Entity\PageBlocValue	No errors.
App\Entity\PaymentLog	No errors.
App\Entity\Absence	No errors.
App\Entity\Bloc	No errors.
App\Entity\Contact	No errors.
App\Entity\CommandeItem	No errors.
App\Entity\Tag	No errors.
App\Entity\Functionality	No errors.
App\Entity\CommandeFeature	No errors.
App\Entity\BoutiqueServiceCategory	No errors.
App\Entity\WorkingHour	No errors.
App\Entity\BlocSyncLog	No errors.
Zhortein\SeoTrackingBundle\Entity\PageCall	No errors.
Zhortein\SeoTrackingBundle\Entity\PageCallHit	No errors.
Vich\UploaderBundle\Entity\File	No errors.

GET http://localhost/.well-known/caddy-check-domain?domain=artemis-gestion.fr

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping