Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

5.08 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.79 ms

SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.text AS text_4, t0.created AS created_5, t0.modified AS modified_6, t0.is_active AS is_active_7, t0.slug AS slug_8, t0.title_tag AS title_tag_9, t0.meta_description AS meta_description_10, t0.keywords AS keywords_11, t0.type AS type_12, t0.published AS published_13, t0.video AS video_14, t0.name_short AS name_short_15, t0.h1 AS h1_16, t0.h2 AS h2_17, t0.h3 AS h3_18, t0.h4 AS h4_19, t0.menu AS menu_20, t0.upload_video AS upload_video_21, t0.gallery_title AS gallery_title_22, t0.gallery_description AS gallery_description_23, t0.items_title AS items_title_24, t0.items_description AS items_description_25, t0.video_title AS video_title_26, t0.video_description AS video_description_27, t0.color AS color_28, t0.download_link AS download_link_29, t0.lang AS lang_30, t0.duplicate AS duplicate_31, t0.glb_image AS glb_image_32, t0.category_id AS category_id_33 FROM page t0 WHERE t0.slug = ? AND t0.category_id = ? AND t0.lang = ? LIMIT 1

Parameters:

[
  "led-ekran-230m2"
  "3"
  "en"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.image AS image_3,
  t0.text AS text_4,
  t0.created AS created_5,
  t0.modified AS modified_6,
  t0.is_active AS is_active_7,
  t0.slug AS slug_8,
  t0.title_tag AS title_tag_9,
  t0.meta_description AS meta_description_10,
  t0.keywords AS keywords_11,
  t0.type AS type_12,
  t0.published AS published_13,
  t0.video AS video_14,
  t0.name_short AS name_short_15,
  t0.h1 AS h1_16,
  t0.h2 AS h2_17,
  t0.h3 AS h3_18,
  t0.h4 AS h4_19,
  t0.menu AS menu_20,
  t0.upload_video AS upload_video_21,
  t0.gallery_title AS gallery_title_22,
  t0.gallery_description AS gallery_description_23,
  t0.items_title AS items_title_24,
  t0.items_description AS items_description_25,
  t0.video_title AS video_title_26,
  t0.video_description AS video_description_27,
  t0.color AS color_28,
  t0.download_link AS download_link_29,
  t0.lang AS lang_30,
  t0.duplicate AS duplicate_31,
  t0.glb_image AS glb_image_32,
  t0.category_id AS category_id_33
FROM
  page t0
WHERE
  t0.slug = ?
  AND t0.category_id = ?
  AND t0.lang = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.text AS text_4, t0.created AS created_5, t0.modified AS modified_6, t0.is_active AS is_active_7, t0.slug AS slug_8, t0.title_tag AS title_tag_9, t0.meta_description AS meta_description_10, t0.keywords AS keywords_11, t0.type AS type_12, t0.published AS published_13, t0.video AS video_14, t0.name_short AS name_short_15, t0.h1 AS h1_16, t0.h2 AS h2_17, t0.h3 AS h3_18, t0.h4 AS h4_19, t0.menu AS menu_20, t0.upload_video AS upload_video_21, t0.gallery_title AS gallery_title_22, t0.gallery_description AS gallery_description_23, t0.items_title AS items_title_24, t0.items_description AS items_description_25, t0.video_title AS video_title_26, t0.video_description AS video_description_27, t0.color AS color_28, t0.download_link AS download_link_29, t0.lang AS lang_30, t0.duplicate AS duplicate_31, t0.glb_image AS glb_image_32, t0.category_id AS category_id_33 FROM page t0 WHERE t0.slug = 'led-ekran-230m2' AND t0.category_id = '3' AND t0.lang = 'en' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 53)
4	App\Controller\NewsController->newsDetailsPage (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

3.19 ms

SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.text AS text_4, t0.created AS created_5, t0.modified AS modified_6, t0.is_active AS is_active_7, t0.slug AS slug_8, t0.title_tag AS title_tag_9, t0.meta_description AS meta_description_10, t0.keywords AS keywords_11, t0.type AS type_12, t0.published AS published_13, t0.video AS video_14, t0.name_short AS name_short_15, t0.h1 AS h1_16, t0.h2 AS h2_17, t0.h3 AS h3_18, t0.h4 AS h4_19, t0.menu AS menu_20, t0.upload_video AS upload_video_21, t0.gallery_title AS gallery_title_22, t0.gallery_description AS gallery_description_23, t0.items_title AS items_title_24, t0.items_description AS items_description_25, t0.video_title AS video_title_26, t0.video_description AS video_description_27, t0.color AS color_28, t0.download_link AS download_link_29, t0.lang AS lang_30, t0.duplicate AS duplicate_31, t0.glb_image AS glb_image_32, t0.category_id AS category_id_33 FROM page t0 WHERE t0.category_id = ? AND t0.is_active = ? AND t0.lang = ? ORDER BY t0.published DESC LIMIT 4

Parameters:

[
  "3"
  1
  "en"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.image AS image_3,
  t0.text AS text_4,
  t0.created AS created_5,
  t0.modified AS modified_6,
  t0.is_active AS is_active_7,
  t0.slug AS slug_8,
  t0.title_tag AS title_tag_9,
  t0.meta_description AS meta_description_10,
  t0.keywords AS keywords_11,
  t0.type AS type_12,
  t0.published AS published_13,
  t0.video AS video_14,
  t0.name_short AS name_short_15,
  t0.h1 AS h1_16,
  t0.h2 AS h2_17,
  t0.h3 AS h3_18,
  t0.h4 AS h4_19,
  t0.menu AS menu_20,
  t0.upload_video AS upload_video_21,
  t0.gallery_title AS gallery_title_22,
  t0.gallery_description AS gallery_description_23,
  t0.items_title AS items_title_24,
  t0.items_description AS items_description_25,
  t0.video_title AS video_title_26,
  t0.video_description AS video_description_27,
  t0.color AS color_28,
  t0.download_link AS download_link_29,
  t0.lang AS lang_30,
  t0.duplicate AS duplicate_31,
  t0.glb_image AS glb_image_32,
  t0.category_id AS category_id_33
FROM
  page t0
WHERE
  t0.category_id = ?
  AND t0.is_active = ?
  AND t0.lang = ?
ORDER BY
  t0.published DESC
LIMIT
  4

SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.text AS text_4, t0.created AS created_5, t0.modified AS modified_6, t0.is_active AS is_active_7, t0.slug AS slug_8, t0.title_tag AS title_tag_9, t0.meta_description AS meta_description_10, t0.keywords AS keywords_11, t0.type AS type_12, t0.published AS published_13, t0.video AS video_14, t0.name_short AS name_short_15, t0.h1 AS h1_16, t0.h2 AS h2_17, t0.h3 AS h3_18, t0.h4 AS h4_19, t0.menu AS menu_20, t0.upload_video AS upload_video_21, t0.gallery_title AS gallery_title_22, t0.gallery_description AS gallery_description_23, t0.items_title AS items_title_24, t0.items_description AS items_description_25, t0.video_title AS video_title_26, t0.video_description AS video_description_27, t0.color AS color_28, t0.download_link AS download_link_29, t0.lang AS lang_30, t0.duplicate AS duplicate_31, t0.glb_image AS glb_image_32, t0.category_id AS category_id_33 FROM page t0 WHERE t0.category_id = '3' AND t0.is_active = 1 AND t0.lang = 'en' ORDER BY t0.published DESC LIMIT 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 969)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 54)
4	App\Controller\NewsController->newsDetailsPage (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.47 ms

SELECT t0.id AS id_1, t0.path AS path_2, t0.active AS active_3, t0.name AS name_4, t0.type AS type_5, t0.lang AS lang_6, t0.gallery_id AS gallery_id_7, t0.page_id AS page_id_8, t0.contact_id AS contact_id_9 FROM image t0 WHERE t0.page_id = ? AND t0.active = ? ORDER BY t0.id DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.path AS path_2,
  t0.active AS active_3,
  t0.name AS name_4,
  t0.type AS type_5,
  t0.lang AS lang_6,
  t0.gallery_id AS gallery_id_7,
  t0.page_id AS page_id_8,
  t0.contact_id AS contact_id_9
FROM
  image t0
WHERE
  t0.page_id = ?
  AND t0.active = ?
ORDER BY
  t0.id DESC

SELECT t0.id AS id_1, t0.path AS path_2, t0.active AS active_3, t0.name AS name_4, t0.type AS type_5, t0.lang AS lang_6, t0.gallery_id AS gallery_id_7, t0.page_id AS page_id_8, t0.contact_id AS contact_id_9 FROM image t0 WHERE t0.page_id = 29 AND t0.active = 1 ORDER BY t0.id DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 969)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 55)
4	App\Controller\NewsController->newsDetailsPage (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.62 ms

SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.text AS text_4, t0.created AS created_5, t0.modified AS modified_6, t0.is_active AS is_active_7, t0.slug AS slug_8, t0.title_tag AS title_tag_9, t0.meta_description AS meta_description_10, t0.keywords AS keywords_11, t0.type AS type_12, t0.published AS published_13, t0.video AS video_14, t0.name_short AS name_short_15, t0.h1 AS h1_16, t0.h2 AS h2_17, t0.h3 AS h3_18, t0.h4 AS h4_19, t0.menu AS menu_20, t0.upload_video AS upload_video_21, t0.gallery_title AS gallery_title_22, t0.gallery_description AS gallery_description_23, t0.items_title AS items_title_24, t0.items_description AS items_description_25, t0.video_title AS video_title_26, t0.video_description AS video_description_27, t0.color AS color_28, t0.download_link AS download_link_29, t0.lang AS lang_30, t0.duplicate AS duplicate_31, t0.glb_image AS glb_image_32, t0.category_id AS category_id_33 FROM page t0 WHERE t0.is_active = ? AND t0.category_id = ? AND t0.lang = ? ORDER BY t0.id ASC

Parameters:

[
  1
  "6"
  "en"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.image AS image_3,
  t0.text AS text_4,
  t0.created AS created_5,
  t0.modified AS modified_6,
  t0.is_active AS is_active_7,
  t0.slug AS slug_8,
  t0.title_tag AS title_tag_9,
  t0.meta_description AS meta_description_10,
  t0.keywords AS keywords_11,
  t0.type AS type_12,
  t0.published AS published_13,
  t0.video AS video_14,
  t0.name_short AS name_short_15,
  t0.h1 AS h1_16,
  t0.h2 AS h2_17,
  t0.h3 AS h3_18,
  t0.h4 AS h4_19,
  t0.menu AS menu_20,
  t0.upload_video AS upload_video_21,
  t0.gallery_title AS gallery_title_22,
  t0.gallery_description AS gallery_description_23,
  t0.items_title AS items_title_24,
  t0.items_description AS items_description_25,
  t0.video_title AS video_title_26,
  t0.video_description AS video_description_27,
  t0.color AS color_28,
  t0.download_link AS download_link_29,
  t0.lang AS lang_30,
  t0.duplicate AS duplicate_31,
  t0.glb_image AS glb_image_32,
  t0.category_id AS category_id_33
FROM
  page t0
WHERE
  t0.is_active = ?
  AND t0.category_id = ?
  AND t0.lang = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.text AS text_4, t0.created AS created_5, t0.modified AS modified_6, t0.is_active AS is_active_7, t0.slug AS slug_8, t0.title_tag AS title_tag_9, t0.meta_description AS meta_description_10, t0.keywords AS keywords_11, t0.type AS type_12, t0.published AS published_13, t0.video AS video_14, t0.name_short AS name_short_15, t0.h1 AS h1_16, t0.h2 AS h2_17, t0.h3 AS h3_18, t0.h4 AS h4_19, t0.menu AS menu_20, t0.upload_video AS upload_video_21, t0.gallery_title AS gallery_title_22, t0.gallery_description AS gallery_description_23, t0.items_title AS items_title_24, t0.items_description AS items_description_25, t0.video_title AS video_title_26, t0.video_description AS video_description_27, t0.color AS color_28, t0.download_link AS download_link_29, t0.lang AS lang_30, t0.duplicate AS duplicate_31, t0.glb_image AS glb_image_32, t0.category_id AS category_id_33 FROM page t0 WHERE t0.is_active = 1 AND t0.category_id = '6' AND t0.lang = 'en' ORDER BY t0.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 969)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 58)
4	App\Controller\HomeController->menuCategory (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
7	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
8	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
9	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
10	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
11	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 74)
12	__TwigTemplate_1f2119c16cb0ceb13f63fb6db7ee5dd4->doDisplay (line 393)
13	Twig\Template->yield (line 105)
14	__TwigTemplate_ce023cc0e2f72d55da4c19e89becaade->block_body (line 437)
15	Twig\Template->yieldBlock (line 131)
16	__TwigTemplate_0133d9dc7b0bedb851c8c27b49658086->doDisplay (line 393)
17	Twig\Template->yield (line 54)
18	__TwigTemplate_ce023cc0e2f72d55da4c19e89becaade->doDisplay (line 393)
19	Twig\Template->yield (line 349)
20	Twig\Template->display (line 364)
21	Twig\Template->render (line 35)
22	Twig\TemplateWrapper->render (line 306)
23	Twig\Environment->render (line 448)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 62)
27	App\Controller\NewsController->newsDetailsPage (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	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.

Entities Mapping

Class	Mapping errors
App\Entity\Page	No errors.
App\Entity\Category	No errors.
App\Entity\Image	No errors.
App\Entity\PageItems	No errors.
App\Entity\Videos	No errors.
App\Entity\Industry	No errors.
App\Entity\Specs	No errors.
App\Entity\Contact	No errors.
App\Entity\Gallery	No errors.

Symfony Profiler

GET https://www.app.screenz.eu/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CHomeController%253A%253AmenuCategory

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping