Symfony Profiler

Query Metrics

49 Database Queries

3 Different statements

168.75 ms Query time

0 Invalid entities

95 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

160.87 ms
(95.33%)

SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))

Parameters:

[
  "019e018e-c07d-75c1-8611-0bd6aa29bed8"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.legacy_id AS legacy_id_2,
  t0.info AS info_3,
  t0.image1_url AS image1_url_4,
  t0.image2_url AS image2_url_5,
  t0.image3_url AS image3_url_6,
  t0.seo_title AS seo_title_7,
  t0.seo_description AS seo_description_8,
  t0.seo_keywords AS seo_keywords_9,
  t0.hit_count AS hit_count_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.is_active AS is_active_13,
  t0.is_deleted AS is_deleted_14,
  t0.is_archived AS is_archived_15,
  t0.deleted_at AS deleted_at_16,
  t0.archived_at AS archived_at_17,
  t0.county_id AS county_id_18,
  t0.tenant_id AS tenant_id_19
FROM
  cms_county_information t0
WHERE
  t0.county_id = ?
  AND (
    (t0.is_deleted = false)
  )

SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = '019e018e-c07d-75c1-8611-0bd6aa29bed8' AND ((t0.is_deleted = false));

#	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 175)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
9	Doctrine\ORM\AbstractQuery->execute (line 886)
10	Doctrine\ORM\AbstractQuery->getResult (line 688)
11	App\Controller\Api\Cms\PublicCmsApiController->listCounties (line 169)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 191)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 32)
17	require_once (line 5)

4.57 ms
(2.71%)

SELECT c0_.id AS id_0, c0_.legacy_id AS legacy_id_1, c0_.code AS code_2, c0_.name AS name_3, c0_.capital AS capital_4, c0_.about AS about_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.is_active AS is_active_8, c0_.is_deleted AS is_deleted_9, c0_.is_archived AS is_archived_10, c0_.deleted_at AS deleted_at_11, c0_.archived_at AS archived_at_12, c0_.tenant_id AS tenant_id_13 FROM cms_counties c0_ WHERE (c0_.tenant_id = ? AND c0_.is_deleted = false) AND (c0_.is_deleted = false) ORDER BY c0_.name ASC

Parameters:

[
  Symfony\Component\Uid\UuidV7 {#142
    __toString(): "019dcefc-1401-7abe-81fe-e45861d11394"
  }
]

View formatted query View runnable query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.legacy_id AS legacy_id_1,
  c0_.code AS code_2,
  c0_.name AS name_3,
  c0_.capital AS capital_4,
  c0_.about AS about_5,
  c0_.created_at AS created_at_6,
  c0_.updated_at AS updated_at_7,
  c0_.is_active AS is_active_8,
  c0_.is_deleted AS is_deleted_9,
  c0_.is_archived AS is_archived_10,
  c0_.deleted_at AS deleted_at_11,
  c0_.archived_at AS archived_at_12,
  c0_.tenant_id AS tenant_id_13
FROM
  cms_counties c0_
WHERE
  (
    c0_.tenant_id = ?
    AND c0_.is_deleted = false
  )
  AND (c0_.is_deleted = false)
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.legacy_id AS legacy_id_1, c0_.code AS code_2, c0_.name AS name_3, c0_.capital AS capital_4, c0_.about AS about_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.is_active AS is_active_8, c0_.is_deleted AS is_deleted_9, c0_.is_archived AS is_archived_10, c0_.deleted_at AS deleted_at_11, c0_.archived_at AS archived_at_12, c0_.tenant_id AS tenant_id_13 FROM cms_counties c0_ WHERE (c0_.tenant_id = '019dcefc-1401-7abe-81fe-e45861d11394' AND c0_.is_deleted = false) AND (c0_.is_deleted = false) ORDER BY c0_.name ASC;

#	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\Api\Cms\PublicCmsApiController->listCounties (line 169)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 191)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

3.31 ms
(1.96%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.plan_type AS plan_type_4, t0.tenant_type AS tenant_type_5, t0.industry AS industry_6, t0.checklist_dismissed_at AS checklist_dismissed_at_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.is_active AS is_active_10, t0.is_deleted AS is_deleted_11, t0.is_archived AS is_archived_12, t0.deleted_at AS deleted_at_13, t0.archived_at AS archived_at_14 FROM tenants t0 WHERE t0.slug = ? AND ((t0.is_deleted = false)) LIMIT 1

Parameters:

[
  "datum"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.plan_type AS plan_type_4,
  t0.tenant_type AS tenant_type_5,
  t0.industry AS industry_6,
  t0.checklist_dismissed_at AS checklist_dismissed_at_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.is_active AS is_active_10,
  t0.is_deleted AS is_deleted_11,
  t0.is_archived AS is_archived_12,
  t0.deleted_at AS deleted_at_13,
  t0.archived_at AS archived_at_14
FROM
  tenants t0
WHERE
  t0.slug = ?
  AND (
    (t0.is_deleted = false)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.plan_type AS plan_type_4, t0.tenant_type AS tenant_type_5, t0.industry AS industry_6, t0.checklist_dismissed_at AS checklist_dismissed_at_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.is_active AS is_active_10, t0.is_deleted AS is_deleted_11, t0.is_archived AS is_archived_12, t0.deleted_at AS deleted_at_13, t0.archived_at AS archived_at_14 FROM tenants t0 WHERE t0.slug = 'datum' AND ((t0.is_deleted = false)) 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\Repository\TenantRepository->findBySlug (line 26)
5	App\Service\Cms\PublicSiteContext->getTenant (line 31)
6	App\Controller\Api\Cms\PublicCmsApiController->listCounties (line 163)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 191)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	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\County	47
App\Entity\CountyInformation	47
App\Entity\Tenant	1

Entities Mapping

Class	Mapping errors
App\Entity\Tenant	No errors.
App\Entity\TenantMembership	No errors.
App\Entity\County	No errors.
App\Entity\CountyInformation	No errors.
App\Entity\Article	No errors.

Symfony Profiler

GET https://docs.statskenya.co.ke/api/public/cms/counties

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping