Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.76 ms Query time

0 Invalid entities

4 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.68 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:

[
  "pepouzin2.devlogiciel.com"
]

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 = 'pepouzin2.devlogiciel.com' 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\HomeController->resolveSite (line 248)
5	App\Controller\HomeController->handleClientPage (line 235)
6	App\Controller\HomeController->page (line 207)
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.57 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 = ? OR d1_.url = ?)

Parameters:

[
  "pepouzin2"
  "devlogiciel.com"
  ".devlogiciel.com"
]

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 = ?
    OR 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 = 'pepouzin2' AND (d1_.url = 'devlogiciel.com' OR d1_.url = '.devlogiciel.com');

#	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\HomeController->resolveSite (line 264)
7	App\Controller\HomeController->handleClientPage (line 235)
8	App\Controller\HomeController->page (line 207)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
11	Symfony\Component\HttpKernel\Kernel->handle (line 143)
12	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner->{closure:Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run():51} (line 62)
13	frankenphp_handle_request (line 72)
14	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run (line 72)
15	require_once (line 32)
16	require_once (line 6)

0.52 ms

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.home_page AS home_page_4, t0.folder AS folder_5, t0.published AS published_6, t0.protected AS protected_7, t0.type_page AS type_page_8, t0.description AS description_9, t0.title_seo AS title_seo_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.deleted AS deleted_14, t0.site_id AS site_id_15 FROM page t0 WHERE t0.site_id = ? AND t0.slug = ? LIMIT 1

Parameters:

[
  6
  "robots.txt"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.home_page AS home_page_4,
  t0.folder AS folder_5,
  t0.published AS published_6,
  t0.protected AS protected_7,
  t0.type_page AS type_page_8,
  t0.description AS description_9,
  t0.title_seo AS title_seo_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.deleted_at AS deleted_at_13,
  t0.deleted AS deleted_14,
  t0.site_id AS site_id_15
FROM
  page t0
WHERE
  t0.site_id = ?
  AND t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.home_page AS home_page_4, t0.folder AS folder_5, t0.published AS published_6, t0.protected AS protected_7, t0.type_page AS type_page_8, t0.description AS description_9, t0.title_seo AS title_seo_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.deleted AS deleted_14, t0.site_id AS site_id_15 FROM page t0 WHERE t0.site_id = 6 AND t0.slug = 'robots.txt' 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\HomeController->handleClientPage (line 236)
5	App\Controller\HomeController->page (line 207)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
8	Symfony\Component\HttpKernel\Kernel->handle (line 143)
9	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner->{closure:Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run():51} (line 62)
10	frankenphp_handle_request (line 72)
11	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run (line 72)
12	require_once (line 32)
13	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
App\Entity\SubDomain	1
App\Entity\Domaine	1
App\Entity\Site	1
App\Entity\User	1

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\Page	No errors.

GET https://pepouzin2.devlogiciel.com/robots.txt

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping