Symfony Profiler

Query Metrics

22 Database Queries

5 Different statements

32.60 ms Query time

0 Invalid entities

26 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

18.91 ms
(58.02%)

SELECT b0_.id AS id_0, b0_.title_public AS title_public_1, b0_.description_public AS description_public_2, b0_.text_public AS text_public_3, b0_.created_at AS created_at_4, b0_.updated_at AS updated_at_5, b0_.published_at AS published_at_6, b0_.like_count AS like_count_7, b0_.dislike_count AS dislike_count_8, b0_.view_count AS view_count_9, b0_.photo AS photo_10, b0_.photo_alt AS photo_alt_11, b0_.photo_title AS photo_title_12, b0_.category AS category_13, b0_.slug AS slug_14, b0_.title_meta AS title_meta_15, b0_.description_meta AS description_meta_16, b0_.show_in_category AS show_in_category_17, b0_.show_in_widget AS show_in_widget_18, b0_.sitemap_inclusion AS sitemap_inclusion_19, b0_.sitemap_priority AS sitemap_priority_20, b0_.sitemap_frequency AS sitemap_frequency_21, b0_.admin AS admin_22, b0_.author_id AS author_id_23 FROM blog b0_ INNER JOIN blog_blog_tags b2_ ON b0_.id = b2_.blog_id INNER JOIN blog_tags b1_ ON b1_.id = b2_.blog_tag_id WHERE b1_.slug = ? AND b0_.published_at IS NOT NULL ORDER BY b0_.published_at DESC LIMIT 11

Parameters:

[
  "adaptation"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.title_public AS title_public_1,
  b0_.description_public AS description_public_2,
  b0_.text_public AS text_public_3,
  b0_.created_at AS created_at_4,
  b0_.updated_at AS updated_at_5,
  b0_.published_at AS published_at_6,
  b0_.like_count AS like_count_7,
  b0_.dislike_count AS dislike_count_8,
  b0_.view_count AS view_count_9,
  b0_.photo AS photo_10,
  b0_.photo_alt AS photo_alt_11,
  b0_.photo_title AS photo_title_12,
  b0_.category AS category_13,
  b0_.slug AS slug_14,
  b0_.title_meta AS title_meta_15,
  b0_.description_meta AS description_meta_16,
  b0_.show_in_category AS show_in_category_17,
  b0_.show_in_widget AS show_in_widget_18,
  b0_.sitemap_inclusion AS sitemap_inclusion_19,
  b0_.sitemap_priority AS sitemap_priority_20,
  b0_.sitemap_frequency AS sitemap_frequency_21,
  b0_.admin AS admin_22,
  b0_.author_id AS author_id_23
FROM
  blog b0_
  INNER JOIN blog_blog_tags b2_ ON b0_.id = b2_.blog_id
  INNER JOIN blog_tags b1_ ON b1_.id = b2_.blog_tag_id
WHERE
  b1_.slug = ?
  AND b0_.published_at IS NOT NULL
ORDER BY
  b0_.published_at DESC
LIMIT
  11

SELECT b0_.id AS id_0, b0_.title_public AS title_public_1, b0_.description_public AS description_public_2, b0_.text_public AS text_public_3, b0_.created_at AS created_at_4, b0_.updated_at AS updated_at_5, b0_.published_at AS published_at_6, b0_.like_count AS like_count_7, b0_.dislike_count AS dislike_count_8, b0_.view_count AS view_count_9, b0_.photo AS photo_10, b0_.photo_alt AS photo_alt_11, b0_.photo_title AS photo_title_12, b0_.category AS category_13, b0_.slug AS slug_14, b0_.title_meta AS title_meta_15, b0_.description_meta AS description_meta_16, b0_.show_in_category AS show_in_category_17, b0_.show_in_widget AS show_in_widget_18, b0_.sitemap_inclusion AS sitemap_inclusion_19, b0_.sitemap_priority AS sitemap_priority_20, b0_.sitemap_frequency AS sitemap_frequency_21, b0_.admin AS admin_22, b0_.author_id AS author_id_23 FROM blog b0_ INNER JOIN blog_blog_tags b2_ ON b0_.id = b2_.blog_id INNER JOIN blog_tags b1_ ON b1_.id = b2_.blog_tag_id WHERE b1_.slug = 'adaptation' AND b0_.published_at IS NOT NULL ORDER BY b0_.published_at DESC LIMIT 11;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getResult (line 906)
6	App\Domain\Blog\Repository\DoctrineBlogRepository->findByFilter (line 61)
7	App\Domain\Blog\Service\BlogManager->getBlogsByTag (line 178)
8	App\Controller\Api\V1\Blog\BlogController->listByTag (line 464)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 208)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

5.30 ms
(16.27%)

SELECT t0.id AS id_1, t0.tag AS tag_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.published_at AS published_at_6, t0.sitemap_inclusion AS sitemap_inclusion_7, t0.sitemap_priority AS sitemap_priority_8, t0.sitemap_frequency AS sitemap_frequency_9, t0.admin AS admin_10 FROM blog_tags t0 INNER JOIN blog_blog_tags ON t0.id = blog_blog_tags.blog_tag_id WHERE blog_blog_tags.blog_id = ?

Parameters:

[
  "1f17e8e0-55be-6406-9852-bd10d7b534fc"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.tag AS tag_2,
  t0.slug AS slug_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.published_at AS published_at_6,
  t0.sitemap_inclusion AS sitemap_inclusion_7,
  t0.sitemap_priority AS sitemap_priority_8,
  t0.sitemap_frequency AS sitemap_frequency_9,
  t0.admin AS admin_10
FROM
  blog_tags t0
  INNER JOIN blog_blog_tags ON t0.id = blog_blog_tags.blog_tag_id
WHERE
  blog_blog_tags.blog_id = ?

SELECT t0.id AS id_1, t0.tag AS tag_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.published_at AS published_at_6, t0.sitemap_inclusion AS sitemap_inclusion_7, t0.sitemap_priority AS sitemap_priority_8, t0.sitemap_frequency AS sitemap_frequency_9, t0.admin AS admin_10 FROM blog_tags t0 INNER JOIN blog_blog_tags ON t0.id = blog_blog_tags.blog_tag_id WHERE blog_blog_tags.blog_id = '1f17e8e0-55be-6406-9852-bd10d7b534fc';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1143)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1065)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 3322)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 706)
5	Doctrine\ORM\PersistentCollection->initialize (line 218)
6	Doctrine\Common\Collections\AbstractLazyCollection->map (line 259)
7	App\Domain\Blog\Dto\BlogResponseDto->fromBlog (line 79)
8	App\Domain\Blog\Service\BlogManager::getBlogsByTag (line 182)
9	App\Controller\Api\V1\Blog\BlogController->listByTag (line 464)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 208)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

3.82 ms
(11.72%)

SELECT t0.id AS id_1, t0.tag AS tag_2, t0.name AS name_3, t0.position AS position_4, t0.blog_id AS blog_id_5 FROM blog_anchors t0 WHERE t0.blog_id = ?

Parameters:

[
  "1f17e8e0-55be-6406-9852-bd10d7b534fc"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.tag AS tag_2,
  t0.name AS name_3,
  t0.position AS position_4,
  t0.blog_id AS blog_id_5
FROM
  blog_anchors t0
WHERE
  t0.blog_id = ?

SELECT t0.id AS id_1, t0.tag AS tag_2, t0.name AS name_3, t0.position AS position_4, t0.blog_id AS blog_id_5 FROM blog_anchors t0 WHERE t0.blog_id = '1f17e8e0-55be-6406-9852-bd10d7b534fc';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1956)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1897)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 3318)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 706)
5	Doctrine\ORM\PersistentCollection->initialize (line 218)
6	Doctrine\Common\Collections\AbstractLazyCollection->map (line 259)
7	App\Domain\Blog\Dto\BlogResponseDto->fromBlog (line 82)
8	App\Domain\Blog\Service\BlogManager::getBlogsByTag (line 182)
9	App\Controller\Api\V1\Blog\BlogController->listByTag (line 464)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 208)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

3.10 ms
(9.52%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.photo AS photo_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.published_at AS published_at_6, t0.admin AS admin_7 FROM blog_authors t0 WHERE t0.id = ?

Parameters:

[
  "1f17c226-52c2-6850-bfc4-6defc0369c78"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.photo AS photo_3,
  t0.position AS position_4,
  t0.created_at AS created_at_5,
  t0.published_at AS published_at_6,
  t0.admin AS admin_7
FROM
  blog_authors t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.photo AS photo_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.published_at AS published_at_6, t0.admin AS admin_7 FROM blog_authors t0 WHERE t0.id = '1f17c226-52c2-6850-bfc4-6defc0369c78';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 369)
4	Proxies\__CG__\App\Domain\Blog\BlogAuthor::Doctrine\ORM\Proxy\{closure} (line 479)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\App\Domain\Blog\BlogAuthor->__get (line 184)
7	App\Domain\Blog\BlogAuthor->getName (line 114)
8	App\Domain\Blog\Dto\BlogAuthorResponseDto->fromBlogAuthor (line 24)
9	App\Domain\Blog\Dto\BlogResponseDto::fromBlog (line 68)
10	App\Domain\Blog\Service\BlogManager::getBlogsByTag (line 182)
11	App\Controller\Api\V1\Blog\BlogController->listByTag (line 464)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 208)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 29)
17	require_once (line 5)

1.46 ms
(4.48%)

SELECT COUNT(b0_.id) AS sclr_0 FROM blog b0_ INNER JOIN blog_blog_tags b2_ ON b0_.id = b2_.blog_id INNER JOIN blog_tags b1_ ON b1_.id = b2_.blog_tag_id WHERE b1_.slug = ? AND b0_.published_at IS NOT NULL

Parameters:

[
  "adaptation"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(b0_.id) AS sclr_0
FROM
  blog b0_
  INNER JOIN blog_blog_tags b2_ ON b0_.id = b2_.blog_id
  INNER JOIN blog_tags b1_ ON b1_.id = b2_.blog_tag_id
WHERE
  b1_.slug = ?
  AND b0_.published_at IS NOT NULL

SELECT COUNT(b0_.id) AS sclr_0 FROM blog b0_ INNER JOIN blog_blog_tags b2_ ON b0_.id = b2_.blog_id INNER JOIN blog_tags b1_ ON b1_.id = b2_.blog_tag_id WHERE b1_.slug = 'adaptation' AND b0_.published_at IS NOT NULL;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 996)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 1025)
7	App\Domain\Blog\Repository\DoctrineBlogRepository->countByFilter (line 74)
8	App\Domain\Blog\Service\BlogManager->getBlogsByTag (line 186)
9	App\Controller\Api\V1\Blog\BlogController->listByTag (line 464)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 208)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	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\Domain\Blog\Blog	8
App\Domain\Blog\BlogTag	7
App\Domain\Blog\BlogAnchor	6
App\Domain\Blog\BlogAuthor	4
App\Domain\Admin\Admin	1

Entities Mapping

Class	Mapping errors
App\Domain\Company\Company	No errors.
App\Domain\Vacancy\Vacancy	No errors.
App\Domain\Resume\Resume	No errors.
App\Domain\Admin\Admin	No errors.
App\Domain\User\User	No errors.
App\Domain\Payer\Payer	No errors.
App\Domain\Payer\JuridicalPayer	No errors.
App\Domain\Order\Position	No errors.
App\Domain\Order\VacancyQuotaPosition	No errors.
App\Domain\Order\Order	No errors.
App\Domain\VacancyImport\VacancyImportHistory	No errors.
App\Domain\VacancyImport\VacancyImport	No errors.
App\Domain\Blog\BlogAnchor	No errors.
App\Domain\Blog\BlogAuthorLog	No errors.
App\Domain\Blog\BlogAuthor	No errors.
App\Domain\Blog\BlogTag	No errors.
App\Domain\Blog\BlogTagLog	No errors.
App\Domain\Blog\Blog	No errors.
App\Domain\Blog\BlogLog	No errors.
App\Domain\AdminAccess\SectionAccess	No errors.
App\Domain\Applicant\Applicant	No errors.
App\Domain\Category\Category	No errors.
App\Domain\City\Metadata	No errors.
App\Domain\City\City	No errors.
App\Domain\City\Region	No errors.
App\Domain\Specialization\Specialization	No errors.
App\Domain\Citizenship\Citizenship	No errors.
App\Domain\EducationInstitution\EducationInstitution	No errors.
App\Domain\Skill\Skill	No errors.
App\Domain\User\ConfirmRequest	No errors.
App\Domain\User\ResetPasswordRequest	No errors.
App\Domain\Company\CompanyAcl	No errors.
App\Domain\PersonalAccount\PersonalAccount\History	No errors.
App\Domain\PersonalAccount\PersonalAccount	No errors.
App\Domain\Employer\EmployerLimit	No errors.
App\Domain\Employer\Employer	No errors.
App\Domain\VacancyQuota\VacancyQuota	No errors.
App\Domain\Language\Language	No errors.
App\Domain\Resume\ResumeSchedule	No errors.
App\Domain\Resume\PreviousJob	No errors.
App\Domain\Resume\Comment	No errors.
App\Domain\Resume\ResumeView	No errors.
App\Domain\Resume\LanguageKnowledge	No errors.
App\Domain\Resume\ResumeEmployment	No errors.
App\Domain\Resume\Course	No errors.
App\Domain\Resume\Education	No errors.
App\Domain\Act\Act	No errors.
App\Domain\Bill\Bill	No errors.
App\Domain\Cart\CartBuyOrder	No errors.
App\Domain\Cart\Cart	No errors.
App\Domain\VacancyResumeRequest\Event\VacancyResumeRequestEvent	No errors.
App\Domain\VacancyResumeRequest\Event\VacancyResumeRequestEditEvent	No errors.
App\Domain\VacancyResumeRequest\VacancyResumeRequest	No errors.
App\Domain\VacancyResumeRequest\Event\VacancyResumeRequestCreateEvent	No errors.
App\Domain\Feedback\Feedback	No errors.
App\Domain\Statistic\VacancySnapshot	No errors.
App\Domain\Statistic\VacancySnapshotArchive	No errors.
App\Domain\News\News	No errors.
App\Domain\PromoCode\PromoCode	No errors.
App\Domain\PromoCode\PromoCodeUsageHistory	No errors.
App\Domain\Moderation\Moderation	No errors.
App\Domain\Moderation\ResumeModeration	No errors.
App\Domain\Moderation\VacancyModeration	No errors.
App\Domain\Moderation\FeedbackModeration	No errors.
App\Domain\Notification\Site\Settings	No errors.
App\Domain\Notification\Site\Notification	No errors.
App\Domain\AuthProviders\UserAuthProviders	No errors.
App\Domain\Contract\Contract	No errors.
App\Domain\Vacancy\Event\History	No errors.
App\Domain\Vacancy\Event\Publication	No errors.
App\Domain\Vacancy\Event\View	No errors.
App\Domain\Vacancy\Event\Favorite	No errors.
App\Domain\Vacancy\Event\ViewPhone	No errors.

Symfony Profiler

GET https://raberu2.itservice18.ru/api/v1/blog/tag/adaptation?limit=11&offset=0

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping