Symfony Profiler

Query Metrics

8 Database Queries

5 Different statements

21.44 ms Query time

0 Invalid entities

11 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

6.70 ms
(31.27%)

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.description AS description_4, t0.default_locale AS default_locale_5, t0.locales AS locales_6, t0.disk AS disk_7, t0.public_api AS public_api_8, t0.storage_strategy AS storage_strategy_9, t0.settings AS settings_10, t0.jwt_access_ttl AS jwt_access_ttl_11, t0.jwt_refresh_ttl AS jwt_refresh_ttl_12, t0.preview_url AS preview_url_13, t0.preview_mode AS preview_mode_14, t0.preview_enabled AS preview_enabled_15 FROM project t0 WHERE t0.uuid = ? LIMIT 1

Parameters:

[
  b"ùœ°8f\x11DÓ±ÇFÏbÁâ2"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.default_locale AS default_locale_5,
  t0.locales AS locales_6,
  t0.disk AS disk_7,
  t0.public_api AS public_api_8,
  t0.storage_strategy AS storage_strategy_9,
  t0.settings AS settings_10,
  t0.jwt_access_ttl AS jwt_access_ttl_11,
  t0.jwt_refresh_ttl AS jwt_refresh_ttl_12,
  t0.preview_url AS preview_url_13,
  t0.preview_mode AS preview_mode_14,
  t0.preview_enabled AS preview_enabled_15
FROM
  project t0
WHERE
  t0.uuid = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.description AS description_4, t0.default_locale AS default_locale_5, t0.locales AS locales_6, t0.disk AS disk_7, t0.public_api AS public_api_8, t0.storage_strategy AS storage_strategy_9, t0.settings AS settings_10, t0.jwt_access_ttl AS jwt_access_ttl_11, t0.jwt_refresh_ttl AS jwt_refresh_ttl_12, t0.preview_url AS preview_url_13, t0.preview_mode AS preview_mode_14, t0.preview_enabled AS preview_enabled_15 FROM project t0 WHERE t0.uuid = 0xF99CB038661144D3B1C746CF62C1E232 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\Api\ContentController->resolvePublicProject (line 535)
5	App\Controller\Api\ContentController->show (line 127)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 191)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
10	require_once (line 32)
11	require_once (line 5)

5.52 ms
(25.75%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.type AS type_4, t0.options AS options_5, t0.validation_rules AS validation_rules_6, t0.`order` AS order_7, t0.is_required AS is_required_8, t0.deleted_at AS deleted_at_9, t0.collection_id AS collection_id_10 FROM field t0 WHERE t0.id = ?

Parameters:

[
  1
]

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.type AS type_4,
  t0.options AS options_5,
  t0.validation_rules AS validation_rules_6,
  t0.`order` AS order_7,
  t0.is_required AS is_required_8,
  t0.deleted_at AS deleted_at_9,
  t0.collection_id AS collection_id_10
FROM
  field t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.type AS type_4, t0.options AS options_5, t0.validation_rules AS validation_rules_6, t0.`order` AS order_7, t0.is_required AS is_required_8, t0.deleted_at AS deleted_at_9, t0.collection_id AS collection_id_10 FROM field t0 WHERE t0.id = 1;

#	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->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	App\Entity\Field::$slug::get (line 24)
5	App\Service\EavDataFormatterService->formatEntry (line 50)
6	App\Controller\Api\ContentController->show (line 142)
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 34)
11	require_once (line 32)
12	require_once (line 5)

5.30 ms
(24.69%)

SELECT t0.id AS id_1, t0.field_type AS field_type_2, t0.text_value AS text_value_3, t0.number_value AS number_value_4, t0.boolean_value AS boolean_value_5, t0.date_value AS date_value_6, t0.datetime_value AS datetime_value_7, t0.json_value AS json_value_8, t0.content_entry_id AS content_entry_id_9, t0.field_id AS field_id_10 FROM content_field_value t0 WHERE t0.content_entry_id = ?

Parameters:

[
  394
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.field_type AS field_type_2,
  t0.text_value AS text_value_3,
  t0.number_value AS number_value_4,
  t0.boolean_value AS boolean_value_5,
  t0.date_value AS date_value_6,
  t0.datetime_value AS datetime_value_7,
  t0.json_value AS json_value_8,
  t0.content_entry_id AS content_entry_id_9,
  t0.field_id AS field_id_10
FROM
  content_field_value t0
WHERE
  t0.content_entry_id = ?

SELECT t0.id AS id_1, t0.field_type AS field_type_2, t0.text_value AS text_value_3, t0.number_value AS number_value_4, t0.boolean_value AS boolean_value_5, t0.date_value AS date_value_6, t0.datetime_value AS datetime_value_7, t0.json_value AS json_value_8, t0.content_entry_id AS content_entry_id_9, t0.field_id AS field_id_10 FROM content_field_value t0 WHERE t0.content_entry_id = 394;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Service\EavDataFormatterService->formatEntry (line 49)
8	App\Controller\Api\ContentController->show (line 142)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 191)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
13	require_once (line 32)
14	require_once (line 5)

3.25 ms
(15.15%)

SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.name AS name_2, c0_.slug AS slug_3, c0_.description AS description_4, c0_.is_singleton AS is_singleton_5, c0_.`order` AS order_6, c0_.deleted_at AS deleted_at_7, c0_.settings AS settings_8, c0_.project_id AS project_id_9 FROM `collection` c0_ WHERE c0_.project_id = ? AND c0_.slug = ? AND c0_.deleted_at IS NULL

Parameters:

[
  1
  "config"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.uuid AS uuid_1,
  c0_.name AS name_2,
  c0_.slug AS slug_3,
  c0_.description AS description_4,
  c0_.is_singleton AS is_singleton_5,
  c0_.`order` AS order_6,
  c0_.deleted_at AS deleted_at_7,
  c0_.settings AS settings_8,
  c0_.project_id AS project_id_9
FROM
  `collection` c0_
WHERE
  c0_.project_id = ?
  AND c0_.slug = ?
  AND c0_.deleted_at IS NULL

SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.name AS name_2, c0_.slug AS slug_3, c0_.description AS description_4, c0_.is_singleton AS is_singleton_5, c0_.`order` AS order_6, c0_.deleted_at AS deleted_at_7, c0_.settings AS settings_8, c0_.project_id AS project_id_9 FROM `collection` c0_ WHERE c0_.project_id = 1 AND c0_.slug = 'config' AND c0_.deleted_at IS NULL;

#	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\Repository\CollectionRepository->findOneByProjectAndSlug (line 41)
7	App\Controller\Api\ContentController->show (line 132)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 191)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 5)

0.67 ms
(3.14%)

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.locale AS locale_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.published_at AS published_at_8, t0.scheduled_at AS scheduled_at_9, t0.meta_title AS meta_title_10, t0.meta_description AS meta_description_11, t0.slug AS slug_12, t0.canonical_url AS canonical_url_13, t0.og_image AS og_image_14, t0.seo_score AS seo_score_15, t0.seo_scored_at AS seo_scored_at_16, t0.project_id AS project_id_17, t0.collection_id AS collection_id_18, t0.created_by_id AS created_by_id_19, t0.updated_by_id AS updated_by_id_20, t0.assigned_to_id AS assigned_to_id_21 FROM content_entry t0 WHERE t0.uuid = ? AND t0.collection_id = ? AND t0.deleted_at IS NULL LIMIT 1

Parameters:

[
  b"X\x19÷ÍH‰C’Ùñäµ”ô/"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.locale AS locale_3,
  t0.status AS status_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.deleted_at AS deleted_at_7,
  t0.published_at AS published_at_8,
  t0.scheduled_at AS scheduled_at_9,
  t0.meta_title AS meta_title_10,
  t0.meta_description AS meta_description_11,
  t0.slug AS slug_12,
  t0.canonical_url AS canonical_url_13,
  t0.og_image AS og_image_14,
  t0.seo_score AS seo_score_15,
  t0.seo_scored_at AS seo_scored_at_16,
  t0.project_id AS project_id_17,
  t0.collection_id AS collection_id_18,
  t0.created_by_id AS created_by_id_19,
  t0.updated_by_id AS updated_by_id_20,
  t0.assigned_to_id AS assigned_to_id_21
FROM
  content_entry t0
WHERE
  t0.uuid = ?
  AND t0.collection_id = ?
  AND t0.deleted_at IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.locale AS locale_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.published_at AS published_at_8, t0.scheduled_at AS scheduled_at_9, t0.meta_title AS meta_title_10, t0.meta_description AS meta_description_11, t0.slug AS slug_12, t0.canonical_url AS canonical_url_13, t0.og_image AS og_image_14, t0.seo_score AS seo_score_15, t0.seo_scored_at AS seo_scored_at_16, t0.project_id AS project_id_17, t0.collection_id AS collection_id_18, t0.created_by_id AS created_by_id_19, t0.updated_by_id AS updated_by_id_20, t0.assigned_to_id AS assigned_to_id_21 FROM content_entry t0 WHERE t0.uuid = 0x5819F7CD488943928FD9F1E4B594F42F AND t0.collection_id = 1 AND t0.deleted_at 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\Api\ContentController->show (line 137)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 191)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
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\ContentFieldValue	4
App\Entity\Field	4
App\Entity\Project	1
App\Entity\Collection	1
App\Entity\ContentEntry	1

Entities Mapping

Class	Mapping errors
App\Entity\Project	No errors.
App\Entity\ProjectStorageProfile	No errors.
App\Entity\StorageRule	No errors.
App\Entity\Collection	No errors.
App\Entity\ProjectMember	No errors.
App\Entity\ContentEntry	No errors.
App\Entity\Field	No errors.
App\Entity\User	No errors.
App\Entity\ContentFieldValue	No errors.
App\Entity\ContentMediaRelation	No errors.
App\Entity\ContentRelationFieldRelation	No errors.

Symfony Profiler

GET https://api.jambostack.site/api/f99cb038-6611-44d3-b1c7-46cf62c1e232/config/5819f7cd-4889-4392-8fd9-f1e4b594f42f

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping