Symfony Profiler

Query Metrics

7 Database Queries

6 Different statements

2.33 ms Query time

0 Invalid entities

4 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.71 ms
(30.50%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->commit (line 1454)
2	Doctrine\ORM\UnitOfWork->commit (line 432)
3	Doctrine\ORM\EntityManager->flush (line 268)
4	App\Controller\Admin\ServicePageCrudController->duplicate (line 459)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

0.50 ms
(21.58%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.meta_description AS meta_description_4, t0.content_json AS content_json_5, t0.page_heading AS page_heading_6, t0.short_description AS short_description_7, t0.hero_feature_lines AS hero_feature_lines_8, t0.hero_image AS hero_image_9, t0.what_shows_title AS what_shows_title_10, t0.what_shows_cards AS what_shows_cards_11, t0.process_title AS process_title_12, t0.process_description AS process_description_13, t0.process_steps AS process_steps_14, t0.process_slides AS process_slides_15, t0.contact_form_image AS contact_form_image_16, t0.catalog_image AS catalog_image_17, t0.checkup_preview_image AS checkup_preview_image_18, t0.catalog_price AS catalog_price_19, t0.catalog_features AS catalog_features_20, t0.is_published AS is_published_21, t0.sort_order AS sort_order_22, t0.category_id AS category_id_23 FROM service_page t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "checkup-sportivniy-man-copy-2-copy"
]

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.meta_description AS meta_description_4,
  t0.content_json AS content_json_5,
  t0.page_heading AS page_heading_6,
  t0.short_description AS short_description_7,
  t0.hero_feature_lines AS hero_feature_lines_8,
  t0.hero_image AS hero_image_9,
  t0.what_shows_title AS what_shows_title_10,
  t0.what_shows_cards AS what_shows_cards_11,
  t0.process_title AS process_title_12,
  t0.process_description AS process_description_13,
  t0.process_steps AS process_steps_14,
  t0.process_slides AS process_slides_15,
  t0.contact_form_image AS contact_form_image_16,
  t0.catalog_image AS catalog_image_17,
  t0.checkup_preview_image AS checkup_preview_image_18,
  t0.catalog_price AS catalog_price_19,
  t0.catalog_features AS catalog_features_20,
  t0.is_published AS is_published_21,
  t0.sort_order AS sort_order_22,
  t0.category_id AS category_id_23
FROM
  service_page t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.meta_description AS meta_description_4, t0.content_json AS content_json_5, t0.page_heading AS page_heading_6, t0.short_description AS short_description_7, t0.hero_feature_lines AS hero_feature_lines_8, t0.hero_image AS hero_image_9, t0.what_shows_title AS what_shows_title_10, t0.what_shows_cards AS what_shows_cards_11, t0.process_title AS process_title_12, t0.process_description AS process_description_13, t0.process_steps AS process_steps_14, t0.process_slides AS process_slides_15, t0.contact_form_image AS contact_form_image_16, t0.catalog_image AS catalog_image_17, t0.checkup_preview_image AS checkup_preview_image_18, t0.catalog_price AS catalog_price_19, t0.catalog_features AS catalog_features_20, t0.is_published AS is_published_21, t0.sort_order AS sort_order_22, t0.category_id AS category_id_23 FROM service_page t0 WHERE t0.slug = 'checkup-sportivniy-man-copy-2-copy' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\Admin\ServicePageCrudController->generateUniqueSlug (line 535)
5	App\Controller\Admin\ServicePageCrudController->createDuplicateServicePage (line 476)
6	App\Controller\Admin\ServicePageCrudController->duplicate (line 456)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.41 ms
(17.72%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.meta_description AS meta_description_4, t0.content_json AS content_json_5, t0.page_heading AS page_heading_6, t0.short_description AS short_description_7, t0.hero_feature_lines AS hero_feature_lines_8, t0.hero_image AS hero_image_9, t0.what_shows_title AS what_shows_title_10, t0.what_shows_cards AS what_shows_cards_11, t0.process_title AS process_title_12, t0.process_description AS process_description_13, t0.process_steps AS process_steps_14, t0.process_slides AS process_slides_15, t0.contact_form_image AS contact_form_image_16, t0.catalog_image AS catalog_image_17, t0.checkup_preview_image AS checkup_preview_image_18, t0.catalog_price AS catalog_price_19, t0.catalog_features AS catalog_features_20, t0.is_published AS is_published_21, t0.sort_order AS sort_order_22, t0.category_id AS category_id_23 FROM service_page t0 WHERE t0.id = ?

Parameters:

[
  1788
]

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.meta_description AS meta_description_4,
  t0.content_json AS content_json_5,
  t0.page_heading AS page_heading_6,
  t0.short_description AS short_description_7,
  t0.hero_feature_lines AS hero_feature_lines_8,
  t0.hero_image AS hero_image_9,
  t0.what_shows_title AS what_shows_title_10,
  t0.what_shows_cards AS what_shows_cards_11,
  t0.process_title AS process_title_12,
  t0.process_description AS process_description_13,
  t0.process_steps AS process_steps_14,
  t0.process_slides AS process_slides_15,
  t0.contact_form_image AS contact_form_image_16,
  t0.catalog_image AS catalog_image_17,
  t0.checkup_preview_image AS checkup_preview_image_18,
  t0.catalog_price AS catalog_price_19,
  t0.catalog_features AS catalog_features_20,
  t0.is_published AS is_published_21,
  t0.sort_order AS sort_order_22,
  t0.category_id AS category_id_23
FROM
  service_page t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.meta_description AS meta_description_4, t0.content_json AS content_json_5, t0.page_heading AS page_heading_6, t0.short_description AS short_description_7, t0.hero_feature_lines AS hero_feature_lines_8, t0.hero_image AS hero_image_9, t0.what_shows_title AS what_shows_title_10, t0.what_shows_cards AS what_shows_cards_11, t0.process_title AS process_title_12, t0.process_description AS process_description_13, t0.process_steps AS process_steps_14, t0.process_slides AS process_slides_15, t0.contact_form_image AS contact_form_image_16, t0.catalog_image AS catalog_image_17, t0.checkup_preview_image AS checkup_preview_image_18, t0.catalog_price AS catalog_price_19, t0.catalog_features AS catalog_features_20, t0.is_published AS is_published_21, t0.sort_order AS sort_order_22, t0.category_id AS category_id_23 FROM service_page t0 WHERE t0.id = 1788;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	App\Controller\Admin\ServicePageCrudController->duplicate (line 443)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.31 ms
(13.47%)

INSERT INTO service_page (title, slug, meta_description, content_json, page_heading, short_description, hero_feature_lines, hero_image, what_shows_title, what_shows_cards, process_title, process_description, process_steps, process_slides, contact_form_image, catalog_image, checkup_preview_image, catalog_price, catalog_features, is_published, sort_order, category_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "Чек-ап «Спортивный», мужской (Копия)"
  "checkup-sportivniy-man-copy-2-copy-2"
  null
  """
    {\n
        "heading": "",\n
        "description": "",\n
        "features": [],\n
        "hero_image": "",\n
        "what_shows_title": "",\n
        "what_shows": [],\n
        "go_cabinet": [],\n
        "doctors": {\n
            "title": "",\n
            "subtitle": "",\n
            "list": [],\n
            "type": 1\n
        },\n
        "contact_form": true,\n
        "hero_type": 1,\n
        "program": {\n
            "title": "",\n
            "description": "",\n
            "cards": []\n
        },\n
        "title": "Чек-ап «Спортивный», мужской",\n
        "meta_description": "Чек-ап «Спортивный», мужской"\n
    }
    """
  "Чек-ап «Спортивный», мужской"
  null
  "[]"
  null
  null
  "[]"
  null
  null
  "[]"
  "[]"
  null
  null
  null
  null
  "[]"
  1
  100
  8
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO service_page (
  title, slug, meta_description, content_json,
  page_heading, short_description,
  hero_feature_lines, hero_image,
  what_shows_title, what_shows_cards,
  process_title, process_description,
  process_steps, process_slides, contact_form_image,
  catalog_image, checkup_preview_image,
  catalog_price, catalog_features,
  is_published, sort_order, category_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?
  )

INSERT INTO service_page (title, slug, meta_description, content_json, page_heading, short_description, hero_feature_lines, hero_image, what_shows_title, what_shows_cards, process_title, process_description, process_steps, process_slides, contact_form_image, catalog_image, checkup_preview_image, catalog_price, catalog_features, is_published, sort_order, category_id) VALUES ('Чек-ап «Спортивный», мужской (Копия)', 'checkup-sportivniy-man-copy-2-copy-2', NULL, '{
    \"heading\": \"\",
    \"description\": \"\",
    \"features\": [],
    \"hero_image\": \"\",
    \"what_shows_title\": \"\",
    \"what_shows\": [],
    \"go_cabinet\": [],
    \"doctors\": {
        \"title\": \"\",
        \"subtitle\": \"\",
        \"list\": [],
        \"type\": 1
    },
    \"contact_form\": true,
    \"hero_type\": 1,
    \"program\": {
        \"title\": \"\",
        \"description\": \"\",
        \"cards\": []
    },
    \"title\": \"Чек-ап «Спортивный», мужской\",
    \"meta_description\": \"Чек-ап «Спортивный», мужской\"
}', 'Чек-ап «Спортивный», мужской', NULL, '[]', NULL, NULL, '[]', NULL, NULL, '[]', '[]', NULL, NULL, NULL, NULL, '[]', 1, 100, 8);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 249)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 255)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1059)
4	Doctrine\ORM\UnitOfWork->commit (line 402)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Controller\Admin\ServicePageCrudController->duplicate (line 459)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.28 ms
(12.10%)

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.slug AS slug_3, t0.photo AS photo_4, t0.list_photo AS list_photo_5, t0.list_description AS list_description_6, t0.short_description AS short_description_7, t0.left_description AS left_description_8, t0.right_description AS right_description_9, t0.years_experience AS years_experience_10 FROM doctor t0 INNER JOIN service_page_doctor ON t0.id = service_page_doctor.doctor_id WHERE service_page_doctor.service_page_id = ?

Parameters:

[
  1788
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.full_name AS full_name_2,
  t0.slug AS slug_3,
  t0.photo AS photo_4,
  t0.list_photo AS list_photo_5,
  t0.list_description AS list_description_6,
  t0.short_description AS short_description_7,
  t0.left_description AS left_description_8,
  t0.right_description AS right_description_9,
  t0.years_experience AS years_experience_10
FROM
  doctor t0
  INNER JOIN service_page_doctor ON t0.id = service_page_doctor.doctor_id
WHERE
  service_page_doctor.service_page_id = ?

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.slug AS slug_3, t0.photo AS photo_4, t0.list_photo AS list_photo_5, t0.list_description AS list_description_6, t0.short_description AS short_description_7, t0.left_description AS left_description_8, t0.right_description AS right_description_9, t0.years_experience AS years_experience_10 FROM doctor t0 INNER JOIN service_page_doctor ON t0.id = service_page_doctor.doctor_id WHERE service_page_doctor.service_page_id = 1788;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1085)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1014)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2726)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	App\Controller\Admin\ServicePageCrudController->createDuplicateServicePage (line 504)
8	App\Controller\Admin\ServicePageCrudController->duplicate (line 456)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

0.11 ms
(4.63%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 381)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Controller\Admin\ServicePageCrudController->duplicate (line 459)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 182)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 29)
9	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\ServicePage	3
App\Entity\ServiceCategory	1

Entities Mapping

Class	Mapping errors
App\Entity\ServicePage	No errors.
App\Entity\ServiceCategory	No errors.
App\Entity\Doctor	No errors.

Symfony Profiler

GET https://hormonelife.ru/apanel?crudAction=duplicate&crudControllerFqcn=App%5CController%5CAdmin%5CServicePageCrudController&entityId=1788

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping