Symfony Profiler

Query Metrics

9 Database Queries

5 Different statements

8.12 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.61 ms
(56.82%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.short_description AS short_description_4, t0.long_description AS long_description_5, t0.cat_order AS cat_order_6, t0.h1 AS h1_7, t0.h2 AS h2_8, t0.h3 AS h3_9, t0.h4 AS h4_10, t0.active AS active_11, t0.lang AS lang_12, t0.yes AS yes_13 FROM industry t0 WHERE t0.slug = ? AND t0.active = ? AND t0.lang = ? LIMIT 1

Parameters:

[
  "feste"
  1
  "de"
]

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.short_description AS short_description_4,
  t0.long_description AS long_description_5,
  t0.cat_order AS cat_order_6,
  t0.h1 AS h1_7,
  t0.h2 AS h2_8,
  t0.h3 AS h3_9,
  t0.h4 AS h4_10,
  t0.active AS active_11,
  t0.lang AS lang_12,
  t0.yes AS yes_13
FROM
  industry t0
WHERE
  t0.slug = ?
  AND t0.active = ?
  AND t0.lang = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.short_description AS short_description_4, t0.long_description AS long_description_5, t0.cat_order AS cat_order_6, t0.h1 AS h1_7, t0.h2 AS h2_8, t0.h3 AS h3_9, t0.h4 AS h4_10, t0.active AS active_11, t0.lang AS lang_12, t0.yes AS yes_13 FROM industry t0 WHERE t0.slug = 'feste' AND t0.active = 1 AND t0.lang = 'de' 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 121)
4	App\Controller\RentalsController->rentalTypePage (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)

1.36 ms
(16.70%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.short_description AS short_description_4, t0.long_description AS long_description_5, t0.cat_order AS cat_order_6, t0.h1 AS h1_7, t0.h2 AS h2_8, t0.h3 AS h3_9, t0.h4 AS h4_10, t0.active AS active_11, t0.lang AS lang_12, t0.yes AS yes_13 FROM industry t0 INNER JOIN page_industry ON t0.id = page_industry.industry_id WHERE page_industry.page_id = ?

Parameters:

[
  85
]

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.short_description AS short_description_4,
  t0.long_description AS long_description_5,
  t0.cat_order AS cat_order_6,
  t0.h1 AS h1_7,
  t0.h2 AS h2_8,
  t0.h3 AS h3_9,
  t0.h4 AS h4_10,
  t0.active AS active_11,
  t0.lang AS lang_12,
  t0.yes AS yes_13
FROM
  industry t0
  INNER JOIN page_industry ON t0.id = page_industry.industry_id
WHERE
  page_industry.page_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.short_description AS short_description_4, t0.long_description AS long_description_5, t0.cat_order AS cat_order_6, t0.h1 AS h1_7, t0.h2 AS h2_8, t0.h3 AS h3_9, t0.h4 AS h4_10, t0.active AS active_11, t0.lang AS lang_12, t0.yes AS yes_13 FROM industry t0 INNER JOIN page_industry ON t0.id = page_industry.industry_id WHERE page_industry.page_id = 85;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1117)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1039)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3305)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 136)
8	__TwigTemplate_1eeb402786edd641d17108473d738340->block_body (line 437)
9	Twig\Template->yieldBlock (line 131)
10	__TwigTemplate_0133d9dc7b0bedb851c8c27b49658086->doDisplay (line 393)
11	Twig\Template->yield (line 54)
12	__TwigTemplate_1eeb402786edd641d17108473d738340->doDisplay (line 393)
13	Twig\Template->yield (line 349)
14	Twig\Template->display (line 364)
15	Twig\Template->render (line 35)
16	Twig\TemplateWrapper->render (line 306)
17	Twig\Environment->render (line 448)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 130)
21	App\Controller\RentalsController->rentalTypePage (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

1.12 ms
(13.75%)

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"
  "de"
]

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 = 'de' 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_1eeb402786edd641d17108473d738340->block_body (line 437)
15	Twig\Template->yieldBlock (line 131)
16	__TwigTemplate_0133d9dc7b0bedb851c8c27b49658086->doDisplay (line 393)
17	Twig\Template->yield (line 54)
18	__TwigTemplate_1eeb402786edd641d17108473d738340->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 130)
27	App\Controller\RentalsController->rentalTypePage (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)

0.55 ms
(6.71%)

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 = ?

Parameters:

[
  1
  "7"
  "de"
]

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 = ?

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 = '7' AND t0.lang = 'de';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 969)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 125)
4	App\Controller\RentalsController->rentalTypePage (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.49 ms
(6.03%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.short_description AS short_description_4, t0.long_description AS long_description_5, t0.cat_order AS cat_order_6, t0.h1 AS h1_7, t0.h2 AS h2_8, t0.h3 AS h3_9, t0.h4 AS h4_10, t0.active AS active_11, t0.lang AS lang_12, t0.yes AS yes_13 FROM industry t0 WHERE t0.active = ? AND t0.lang = ?

Parameters:

[
  1
  "de"
]

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.short_description AS short_description_4,
  t0.long_description AS long_description_5,
  t0.cat_order AS cat_order_6,
  t0.h1 AS h1_7,
  t0.h2 AS h2_8,
  t0.h3 AS h3_9,
  t0.h4 AS h4_10,
  t0.active AS active_11,
  t0.lang AS lang_12,
  t0.yes AS yes_13
FROM
  industry t0
WHERE
  t0.active = ?
  AND t0.lang = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.short_description AS short_description_4, t0.long_description AS long_description_5, t0.cat_order AS cat_order_6, t0.h1 AS h1_7, t0.h2 AS h2_8, t0.h3 AS h3_9, t0.h4 AS h4_10, t0.active AS active_11, t0.lang AS lang_12, t0.yes AS yes_13 FROM industry t0 WHERE t0.active = 1 AND t0.lang = 'de';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 969)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 124)
4	App\Controller\RentalsController->rentalTypePage (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)

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\Industry	No 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\Specs	No errors.
App\Entity\Contact	No errors.
App\Entity\Article	No errors.
App\Entity\Product	No errors.
App\Entity\Gallery	No errors.
App\Entity\Country	No errors.
App\Entity\Paragraph	No errors.
App\Entity\Tag	No errors.
App\Entity\OrderItem	No errors.

Symfony Profiler

GET https://www.app.screenz.eu/de/rental_type/feste/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping