Symfony Profiler

Query Metrics

6 Database Queries

5 Different statements

6.45 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.92 ms
(45.18%)

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.short_description AS short_description_3, p0_.long_description AS long_description_4, p0_.created AS created_5, p0_.guid AS guid_6, p0_.is_active AS is_active_7, p0_.main_image AS main_image_8, p0_.icon_image AS icon_image_9, p0_.bg_image AS bg_image_10, p0_.video_url AS video_url_11, p0_.published AS published_12, p0_.color_font AS color_font_13, p0_.color_bg AS color_bg_14, p0_.extract_home AS extract_home_15, p0_.extract_category AS extract_category_16, p0_.extract_menu AS extract_menu_17, p0_.order_home AS order_home_18, p0_.order_category AS order_category_19, p0_.order_menu AS order_menu_20, p0_.price AS price_21, p0_.locked AS locked_22, p0_.hidden AS hidden_23, p0_.locale AS locale_24, p0_.extract_slider AS extract_slider_25, p0_.order_slider AS order_slider_26, p0_.stock_quantity AS stock_quantity_27, p0_.stock_note AS stock_note_28, p0_.njuskalo_id AS njuskalo_id_29, p0_.ad_title AS ad_title_30, p0_.ad_description AS ad_description_31, p0_.price_discount AS price_discount_32, p0_.width AS width_33, p0_.length AS length_34, p0_.height AS height_35, p0_.weight AS weight_36, p0_.diameter AS diameter_37, p0_.literage AS literage_38, p0_.ean AS ean_39, p0_.label_id AS label_id_40, p0_.product_category_id AS product_category_id_41, p0_.njuskalo_category_id AS njuskalo_category_id_42, p0_.inventory_id AS inventory_id_43 FROM product p0_ INNER JOIN product_category p1_ ON p0_.product_category_id = p1_.id WHERE p1_.slug = ? AND p0_.is_active = 1 AND p0_.locale = ? ORDER BY p0_.id ASC LIMIT 20

Parameters:

[
  "proizvodi"
  "hr"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.slug AS slug_2,
  p0_.short_description AS short_description_3,
  p0_.long_description AS long_description_4,
  p0_.created AS created_5,
  p0_.guid AS guid_6,
  p0_.is_active AS is_active_7,
  p0_.main_image AS main_image_8,
  p0_.icon_image AS icon_image_9,
  p0_.bg_image AS bg_image_10,
  p0_.video_url AS video_url_11,
  p0_.published AS published_12,
  p0_.color_font AS color_font_13,
  p0_.color_bg AS color_bg_14,
  p0_.extract_home AS extract_home_15,
  p0_.extract_category AS extract_category_16,
  p0_.extract_menu AS extract_menu_17,
  p0_.order_home AS order_home_18,
  p0_.order_category AS order_category_19,
  p0_.order_menu AS order_menu_20,
  p0_.price AS price_21,
  p0_.locked AS locked_22,
  p0_.hidden AS hidden_23,
  p0_.locale AS locale_24,
  p0_.extract_slider AS extract_slider_25,
  p0_.order_slider AS order_slider_26,
  p0_.stock_quantity AS stock_quantity_27,
  p0_.stock_note AS stock_note_28,
  p0_.njuskalo_id AS njuskalo_id_29,
  p0_.ad_title AS ad_title_30,
  p0_.ad_description AS ad_description_31,
  p0_.price_discount AS price_discount_32,
  p0_.width AS width_33,
  p0_.length AS length_34,
  p0_.height AS height_35,
  p0_.weight AS weight_36,
  p0_.diameter AS diameter_37,
  p0_.literage AS literage_38,
  p0_.ean AS ean_39,
  p0_.label_id AS label_id_40,
  p0_.product_category_id AS product_category_id_41,
  p0_.njuskalo_category_id AS njuskalo_category_id_42,
  p0_.inventory_id AS inventory_id_43
FROM
  product p0_
  INNER JOIN product_category p1_ ON p0_.product_category_id = p1_.id
WHERE
  p1_.slug = ?
  AND p0_.is_active = 1
  AND p0_.locale = ?
ORDER BY
  p0_.id ASC
LIMIT
  20

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.short_description AS short_description_3, p0_.long_description AS long_description_4, p0_.created AS created_5, p0_.guid AS guid_6, p0_.is_active AS is_active_7, p0_.main_image AS main_image_8, p0_.icon_image AS icon_image_9, p0_.bg_image AS bg_image_10, p0_.video_url AS video_url_11, p0_.published AS published_12, p0_.color_font AS color_font_13, p0_.color_bg AS color_bg_14, p0_.extract_home AS extract_home_15, p0_.extract_category AS extract_category_16, p0_.extract_menu AS extract_menu_17, p0_.order_home AS order_home_18, p0_.order_category AS order_category_19, p0_.order_menu AS order_menu_20, p0_.price AS price_21, p0_.locked AS locked_22, p0_.hidden AS hidden_23, p0_.locale AS locale_24, p0_.extract_slider AS extract_slider_25, p0_.order_slider AS order_slider_26, p0_.stock_quantity AS stock_quantity_27, p0_.stock_note AS stock_note_28, p0_.njuskalo_id AS njuskalo_id_29, p0_.ad_title AS ad_title_30, p0_.ad_description AS ad_description_31, p0_.price_discount AS price_discount_32, p0_.width AS width_33, p0_.length AS length_34, p0_.height AS height_35, p0_.weight AS weight_36, p0_.diameter AS diameter_37, p0_.literage AS literage_38, p0_.ean AS ean_39, p0_.label_id AS label_id_40, p0_.product_category_id AS product_category_id_41, p0_.njuskalo_category_id AS njuskalo_category_id_42, p0_.inventory_id AS inventory_id_43 FROM product p0_ INNER JOIN product_category p1_ ON p0_.product_category_id = p1_.id WHERE p1_.slug = 'proizvodi' AND p0_.is_active = 1 AND p0_.locale = 'hr' ORDER BY p0_.id ASC LIMIT 20;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 370)
7	App\Controller\web\ScreenzController->findProducts (line 74)
8	App\Controller\web\ScreenzController->menuCategory (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
11	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
12	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
13	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
14	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
15	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 67)
16	__TwigTemplate_2586baa213585b38aaedc34d396d120e->doDisplay (line 394)
17	Twig\Template->displayWithErrorHandling (line 367)
18	Twig\Template->display (line 115)
19	__TwigTemplate_f88b07c752dd348c044882f6c93c9b5a->block_body (line 171)
20	Twig\Template->displayBlock (line 116)
21	__TwigTemplate_899fd16b7306938097d65613a1957b1a->doDisplay (line 394)
22	Twig\Template->displayWithErrorHandling (line 367)
23	Twig\Template->display (line 50)
24	__TwigTemplate_f88b07c752dd348c044882f6c93c9b5a->doDisplay (line 394)
25	Twig\Template->displayWithErrorHandling (line 367)
26	Twig\Template->display (line 379)
27	Twig\Template->render (line 38)
28	Twig\TemplateWrapper->render (line 280)
29	Twig\Environment->render (line 431)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 153)
33	App\Controller\web\ScreenzController->rentalPage (line 178)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
36	Symfony\Component\HttpKernel\Kernel->handle (line 35)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
38	require_once (line 5)

1.42 ms
(21.93%)

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.short_description AS short_description_3, p0_.long_description AS long_description_4, p0_.created AS created_5, p0_.guid AS guid_6, p0_.is_active AS is_active_7, p0_.main_image AS main_image_8, p0_.icon_image AS icon_image_9, p0_.bg_image AS bg_image_10, p0_.video_url AS video_url_11, p0_.published AS published_12, p0_.color_font AS color_font_13, p0_.color_bg AS color_bg_14, p0_.extract_home AS extract_home_15, p0_.extract_category AS extract_category_16, p0_.extract_menu AS extract_menu_17, p0_.order_home AS order_home_18, p0_.order_category AS order_category_19, p0_.order_menu AS order_menu_20, p0_.price AS price_21, p0_.locked AS locked_22, p0_.hidden AS hidden_23, p0_.locale AS locale_24, p0_.extract_slider AS extract_slider_25, p0_.order_slider AS order_slider_26, p0_.stock_quantity AS stock_quantity_27, p0_.stock_note AS stock_note_28, p0_.njuskalo_id AS njuskalo_id_29, p0_.ad_title AS ad_title_30, p0_.ad_description AS ad_description_31, p0_.price_discount AS price_discount_32, p0_.width AS width_33, p0_.length AS length_34, p0_.height AS height_35, p0_.weight AS weight_36, p0_.diameter AS diameter_37, p0_.literage AS literage_38, p0_.ean AS ean_39, p0_.label_id AS label_id_40, p0_.product_category_id AS product_category_id_41, p0_.njuskalo_category_id AS njuskalo_category_id_42, p0_.inventory_id AS inventory_id_43 FROM product p0_ INNER JOIN product_category p1_ ON p0_.product_category_id = p1_.id WHERE p1_.slug = ? AND p0_.is_active = 1 AND p0_.locale = ? ORDER BY p0_.id ASC

Parameters:

[
  "najam-proizvodi"
  "hr"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.slug AS slug_2,
  p0_.short_description AS short_description_3,
  p0_.long_description AS long_description_4,
  p0_.created AS created_5,
  p0_.guid AS guid_6,
  p0_.is_active AS is_active_7,
  p0_.main_image AS main_image_8,
  p0_.icon_image AS icon_image_9,
  p0_.bg_image AS bg_image_10,
  p0_.video_url AS video_url_11,
  p0_.published AS published_12,
  p0_.color_font AS color_font_13,
  p0_.color_bg AS color_bg_14,
  p0_.extract_home AS extract_home_15,
  p0_.extract_category AS extract_category_16,
  p0_.extract_menu AS extract_menu_17,
  p0_.order_home AS order_home_18,
  p0_.order_category AS order_category_19,
  p0_.order_menu AS order_menu_20,
  p0_.price AS price_21,
  p0_.locked AS locked_22,
  p0_.hidden AS hidden_23,
  p0_.locale AS locale_24,
  p0_.extract_slider AS extract_slider_25,
  p0_.order_slider AS order_slider_26,
  p0_.stock_quantity AS stock_quantity_27,
  p0_.stock_note AS stock_note_28,
  p0_.njuskalo_id AS njuskalo_id_29,
  p0_.ad_title AS ad_title_30,
  p0_.ad_description AS ad_description_31,
  p0_.price_discount AS price_discount_32,
  p0_.width AS width_33,
  p0_.length AS length_34,
  p0_.height AS height_35,
  p0_.weight AS weight_36,
  p0_.diameter AS diameter_37,
  p0_.literage AS literage_38,
  p0_.ean AS ean_39,
  p0_.label_id AS label_id_40,
  p0_.product_category_id AS product_category_id_41,
  p0_.njuskalo_category_id AS njuskalo_category_id_42,
  p0_.inventory_id AS inventory_id_43
FROM
  product p0_
  INNER JOIN product_category p1_ ON p0_.product_category_id = p1_.id
WHERE
  p1_.slug = ?
  AND p0_.is_active = 1
  AND p0_.locale = ?
ORDER BY
  p0_.id ASC

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.short_description AS short_description_3, p0_.long_description AS long_description_4, p0_.created AS created_5, p0_.guid AS guid_6, p0_.is_active AS is_active_7, p0_.main_image AS main_image_8, p0_.icon_image AS icon_image_9, p0_.bg_image AS bg_image_10, p0_.video_url AS video_url_11, p0_.published AS published_12, p0_.color_font AS color_font_13, p0_.color_bg AS color_bg_14, p0_.extract_home AS extract_home_15, p0_.extract_category AS extract_category_16, p0_.extract_menu AS extract_menu_17, p0_.order_home AS order_home_18, p0_.order_category AS order_category_19, p0_.order_menu AS order_menu_20, p0_.price AS price_21, p0_.locked AS locked_22, p0_.hidden AS hidden_23, p0_.locale AS locale_24, p0_.extract_slider AS extract_slider_25, p0_.order_slider AS order_slider_26, p0_.stock_quantity AS stock_quantity_27, p0_.stock_note AS stock_note_28, p0_.njuskalo_id AS njuskalo_id_29, p0_.ad_title AS ad_title_30, p0_.ad_description AS ad_description_31, p0_.price_discount AS price_discount_32, p0_.width AS width_33, p0_.length AS length_34, p0_.height AS height_35, p0_.weight AS weight_36, p0_.diameter AS diameter_37, p0_.literage AS literage_38, p0_.ean AS ean_39, p0_.label_id AS label_id_40, p0_.product_category_id AS product_category_id_41, p0_.njuskalo_category_id AS njuskalo_category_id_42, p0_.inventory_id AS inventory_id_43 FROM product p0_ INNER JOIN product_category p1_ ON p0_.product_category_id = p1_.id WHERE p1_.slug = 'najam-proizvodi' AND p0_.is_active = 1 AND p0_.locale = 'hr' ORDER BY p0_.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 370)
7	App\Controller\web\ScreenzController->findProducts (line 145)
8	App\Controller\web\ScreenzController->rentalPage (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

1.07 ms
(16.61%)

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.short_description AS short_description_3, p0_.long_description AS long_description_4, p0_.created AS created_5, p0_.guid AS guid_6, p0_.is_active AS is_active_7, p0_.main_image AS main_image_8, p0_.icon_image AS icon_image_9, p0_.bg_image AS bg_image_10, p0_.video_url AS video_url_11, p0_.published AS published_12, p0_.color_font AS color_font_13, p0_.color_bg AS color_bg_14, p0_.extract_home AS extract_home_15, p0_.extract_category AS extract_category_16, p0_.extract_menu AS extract_menu_17, p0_.order_home AS order_home_18, p0_.order_category AS order_category_19, p0_.order_menu AS order_menu_20, p0_.price AS price_21, p0_.locked AS locked_22, p0_.hidden AS hidden_23, p0_.locale AS locale_24, p0_.extract_slider AS extract_slider_25, p0_.order_slider AS order_slider_26, p0_.stock_quantity AS stock_quantity_27, p0_.stock_note AS stock_note_28, p0_.njuskalo_id AS njuskalo_id_29, p0_.ad_title AS ad_title_30, p0_.ad_description AS ad_description_31, p0_.price_discount AS price_discount_32, p0_.width AS width_33, p0_.length AS length_34, p0_.height AS height_35, p0_.weight AS weight_36, p0_.diameter AS diameter_37, p0_.literage AS literage_38, p0_.ean AS ean_39, p0_.label_id AS label_id_40, p0_.product_category_id AS product_category_id_41, p0_.njuskalo_category_id AS njuskalo_category_id_42, p0_.inventory_id AS inventory_id_43 FROM product p0_ INNER JOIN product_category p1_ ON p0_.product_category_id = p1_.id WHERE p1_.slug = ? AND p0_.is_active = 1 AND p0_.slug = ? AND p0_.locale = ? LIMIT 1

Parameters:

[
  "najam-proizvodi"
  "led-iposter-wall"
  "hr"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.slug AS slug_2,
  p0_.short_description AS short_description_3,
  p0_.long_description AS long_description_4,
  p0_.created AS created_5,
  p0_.guid AS guid_6,
  p0_.is_active AS is_active_7,
  p0_.main_image AS main_image_8,
  p0_.icon_image AS icon_image_9,
  p0_.bg_image AS bg_image_10,
  p0_.video_url AS video_url_11,
  p0_.published AS published_12,
  p0_.color_font AS color_font_13,
  p0_.color_bg AS color_bg_14,
  p0_.extract_home AS extract_home_15,
  p0_.extract_category AS extract_category_16,
  p0_.extract_menu AS extract_menu_17,
  p0_.order_home AS order_home_18,
  p0_.order_category AS order_category_19,
  p0_.order_menu AS order_menu_20,
  p0_.price AS price_21,
  p0_.locked AS locked_22,
  p0_.hidden AS hidden_23,
  p0_.locale AS locale_24,
  p0_.extract_slider AS extract_slider_25,
  p0_.order_slider AS order_slider_26,
  p0_.stock_quantity AS stock_quantity_27,
  p0_.stock_note AS stock_note_28,
  p0_.njuskalo_id AS njuskalo_id_29,
  p0_.ad_title AS ad_title_30,
  p0_.ad_description AS ad_description_31,
  p0_.price_discount AS price_discount_32,
  p0_.width AS width_33,
  p0_.length AS length_34,
  p0_.height AS height_35,
  p0_.weight AS weight_36,
  p0_.diameter AS diameter_37,
  p0_.literage AS literage_38,
  p0_.ean AS ean_39,
  p0_.label_id AS label_id_40,
  p0_.product_category_id AS product_category_id_41,
  p0_.njuskalo_category_id AS njuskalo_category_id_42,
  p0_.inventory_id AS inventory_id_43
FROM
  product p0_
  INNER JOIN product_category p1_ ON p0_.product_category_id = p1_.id
WHERE
  p1_.slug = ?
  AND p0_.is_active = 1
  AND p0_.slug = ?
  AND p0_.locale = ?
LIMIT
  1

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.short_description AS short_description_3, p0_.long_description AS long_description_4, p0_.created AS created_5, p0_.guid AS guid_6, p0_.is_active AS is_active_7, p0_.main_image AS main_image_8, p0_.icon_image AS icon_image_9, p0_.bg_image AS bg_image_10, p0_.video_url AS video_url_11, p0_.published AS published_12, p0_.color_font AS color_font_13, p0_.color_bg AS color_bg_14, p0_.extract_home AS extract_home_15, p0_.extract_category AS extract_category_16, p0_.extract_menu AS extract_menu_17, p0_.order_home AS order_home_18, p0_.order_category AS order_category_19, p0_.order_menu AS order_menu_20, p0_.price AS price_21, p0_.locked AS locked_22, p0_.hidden AS hidden_23, p0_.locale AS locale_24, p0_.extract_slider AS extract_slider_25, p0_.order_slider AS order_slider_26, p0_.stock_quantity AS stock_quantity_27, p0_.stock_note AS stock_note_28, p0_.njuskalo_id AS njuskalo_id_29, p0_.ad_title AS ad_title_30, p0_.ad_description AS ad_description_31, p0_.price_discount AS price_discount_32, p0_.width AS width_33, p0_.length AS length_34, p0_.height AS height_35, p0_.weight AS weight_36, p0_.diameter AS diameter_37, p0_.literage AS literage_38, p0_.ean AS ean_39, p0_.label_id AS label_id_40, p0_.product_category_id AS product_category_id_41, p0_.njuskalo_category_id AS njuskalo_category_id_42, p0_.inventory_id AS inventory_id_43 FROM product p0_ INNER JOIN product_category p1_ ON p0_.product_category_id = p1_.id WHERE p1_.slug = 'najam-proizvodi' AND p0_.is_active = 1 AND p0_.slug = 'led-iposter-wall' AND p0_.locale = 'hr' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 386)
7	App\Controller\web\ScreenzController->findProductBySlug (line 141)
8	App\Controller\web\ScreenzController->rentalPage (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.61 ms
(9.39%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.short_description AS short_description_4, t0.long_description AS long_description_5, t0.created AS created_6, t0.guid AS guid_7, t0.is_active AS is_active_8, t0.main_image AS main_image_9, t0.icon_image AS icon_image_10, t0.bg_image AS bg_image_11, t0.video_url AS video_url_12, t0.published AS published_13, t0.color_font AS color_font_14, t0.color_bg AS color_bg_15, t0.extract_home AS extract_home_16, t0.extract_category AS extract_category_17, t0.extract_menu AS extract_menu_18, t0.order_home AS order_home_19, t0.order_category AS order_category_20, t0.order_menu AS order_menu_21, t0.price AS price_22, t0.locked AS locked_23, t0.modul_id AS modul_id_24, t0.label_id AS label_id_25, t0.client_id AS client_id_26, t0.project_id AS project_id_27, t0.workbook_id AS workbook_id_28, t0.document_status_id AS document_status_id_29, t0.product_id AS product_id_30, t0.product_category_id AS product_category_id_31, t0.lead_by_id AS lead_by_id_32, t0.page_id AS page_id_33, t0.page_category_id AS page_category_id_34, t0.service_id AS service_id_35, t0.paragraph_id AS paragraph_id_36, t0.vehicle_id AS vehicle_id_37, t0.item_id AS item_id_38 FROM image t0 WHERE t0.product_id = ? AND t0.is_active = ? ORDER BY t0.id ASC

Parameters:

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.short_description AS short_description_4,
  t0.long_description AS long_description_5,
  t0.created AS created_6,
  t0.guid AS guid_7,
  t0.is_active AS is_active_8,
  t0.main_image AS main_image_9,
  t0.icon_image AS icon_image_10,
  t0.bg_image AS bg_image_11,
  t0.video_url AS video_url_12,
  t0.published AS published_13,
  t0.color_font AS color_font_14,
  t0.color_bg AS color_bg_15,
  t0.extract_home AS extract_home_16,
  t0.extract_category AS extract_category_17,
  t0.extract_menu AS extract_menu_18,
  t0.order_home AS order_home_19,
  t0.order_category AS order_category_20,
  t0.order_menu AS order_menu_21,
  t0.price AS price_22,
  t0.locked AS locked_23,
  t0.modul_id AS modul_id_24,
  t0.label_id AS label_id_25,
  t0.client_id AS client_id_26,
  t0.project_id AS project_id_27,
  t0.workbook_id AS workbook_id_28,
  t0.document_status_id AS document_status_id_29,
  t0.product_id AS product_id_30,
  t0.product_category_id AS product_category_id_31,
  t0.lead_by_id AS lead_by_id_32,
  t0.page_id AS page_id_33,
  t0.page_category_id AS page_category_id_34,
  t0.service_id AS service_id_35,
  t0.paragraph_id AS paragraph_id_36,
  t0.vehicle_id AS vehicle_id_37,
  t0.item_id AS item_id_38
FROM
  image t0
WHERE
  t0.product_id = ?
  AND t0.is_active = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.short_description AS short_description_4, t0.long_description AS long_description_5, t0.created AS created_6, t0.guid AS guid_7, t0.is_active AS is_active_8, t0.main_image AS main_image_9, t0.icon_image AS icon_image_10, t0.bg_image AS bg_image_11, t0.video_url AS video_url_12, t0.published AS published_13, t0.color_font AS color_font_14, t0.color_bg AS color_bg_15, t0.extract_home AS extract_home_16, t0.extract_category AS extract_category_17, t0.extract_menu AS extract_menu_18, t0.order_home AS order_home_19, t0.order_category AS order_category_20, t0.order_menu AS order_menu_21, t0.price AS price_22, t0.locked AS locked_23, t0.modul_id AS modul_id_24, t0.label_id AS label_id_25, t0.client_id AS client_id_26, t0.project_id AS project_id_27, t0.workbook_id AS workbook_id_28, t0.document_status_id AS document_status_id_29, t0.product_id AS product_id_30, t0.product_category_id AS product_category_id_31, t0.lead_by_id AS lead_by_id_32, t0.page_id AS page_id_33, t0.page_category_id AS page_category_id_34, t0.service_id AS service_id_35, t0.paragraph_id AS paragraph_id_36, t0.vehicle_id AS vehicle_id_37, t0.item_id AS item_id_38 FROM image t0 WHERE t0.product_id = 34 AND t0.is_active = 1 ORDER BY t0.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 144)
5	App\Controller\web\ScreenzController->rentalPage (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.44 ms
(6.88%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.is_active AS is_active_3, t0.created AS created_4, t0.label_id AS label_id_5 FROM tag t0 INNER JOIN product_tag ON t0.id = product_tag.tag_id WHERE product_tag.product_id = ?

Parameters:

[
  34
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.is_active AS is_active_3,
  t0.created AS created_4,
  t0.label_id AS label_id_5
FROM
  tag t0
  INNER JOIN product_tag ON t0.id = product_tag.tag_id
WHERE
  product_tag.product_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.is_active AS is_active_3, t0.created AS created_4, t0.label_id AS label_id_5 FROM tag t0 INNER JOIN product_tag ON t0.id = product_tag.tag_id WHERE product_tag.product_id = 34;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1051)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 980)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2709)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 148)
9	__TwigTemplate_f88b07c752dd348c044882f6c93c9b5a->block_body (line 171)
10	Twig\Template->displayBlock (line 116)
11	__TwigTemplate_899fd16b7306938097d65613a1957b1a->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 50)
14	__TwigTemplate_f88b07c752dd348c044882f6c93c9b5a->doDisplay (line 394)
15	Twig\Template->displayWithErrorHandling (line 367)
16	Twig\Template->display (line 379)
17	Twig\Template->render (line 38)
18	Twig\TemplateWrapper->render (line 280)
19	Twig\Environment->render (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 153)
23	App\Controller\web\ScreenzController->rentalPage (line 178)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	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\Product	No errors.
App\Entity\ProductCategory	No errors.
App\Entity\Label	No errors.
App\Entity\NjuskaloCategory	No errors.
App\Entity\Inventory	No errors.
App\Entity\Image	No errors.
App\Entity\Document	No errors.
App\Entity\Workbook	No errors.
App\Entity\Tag	No errors.
App\Entity\OrderItem	No errors.
App\Entity\Embedding	No errors.
App\Entity\Modul	No errors.
App\Entity\Client	No errors.
App\Entity\Project	No errors.
App\Entity\DocumentStatus	No errors.
App\Entity\Lead	No errors.
App\Entity\Page	The association App\Entity\Page#createdBy refers to the inverse side field App\Entity\User#pages which does not exist.
App\Entity\PageCategory	No errors.
App\Entity\Service	No errors.
App\Entity\Paragraph	No errors.
App\Entity\Vehicle	No errors.
App\Entity\Item	No errors.
App\Entity\ChatConversation	No errors.
App\Entity\ChatMessage	No errors.
App\Entity\UserLabel	No errors.
App\Entity\ProductTemp	No errors.
App\Entity\DocumentEmbeddings	No errors.
App\Entity\User	No errors.
App\Entity\Phase	No errors.
App\Entity\WorkbookStatus	No errors.
App\Entity\InvoiceStatus	No errors.
App\Entity\WorkbookTask	No errors.
App\Entity\Order	No errors.
App\Entity\Country	No errors.
App\Entity\ProjectStatus	No errors.
App\Entity\WorkbookTaskExplain	No errors.

Symfony Profiler

GET https://www.dev.screenz.eu/hr/rentals/led-iposter-wall/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping