Symfony Profiler

Query Metrics

4 Database Queries

3 Different statements

87.19 ms Query time

1 Invalid entities

Queries

Group similar statements

#▲

Time

Info

73.41 ms

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_.extract_slider AS extract_slider_18, p0_.order_home AS order_home_19, p0_.order_category AS order_category_20, p0_.order_menu AS order_menu_21, p0_.order_slider AS order_slider_22, p0_.locked AS locked_23, p0_.hidden AS hidden_24, p0_.price AS price_25, p0_.locale AS locale_26, p0_.author AS author_27, p0_.author_link AS author_link_28, p0_.author_title AS author_title_29, p0_.tt AS tt_30, p0_.json_data AS json_data_31, p0_.keywords AS keywords_32, p0_.page_category_id AS page_category_id_33, p0_.label_id AS label_id_34, p0_.created_by_id AS created_by_id_35 FROM page p0_ INNER JOIN page_category p1_ ON p0_.page_category_id = p1_.id WHERE p1_.slug = ? AND p0_.is_active = 1 AND p0_.locale = ? ORDER BY p0_.published DESC

Parameters:

[
  "novosti"
  "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_.extract_slider AS extract_slider_18,
  p0_.order_home AS order_home_19,
  p0_.order_category AS order_category_20,
  p0_.order_menu AS order_menu_21,
  p0_.order_slider AS order_slider_22,
  p0_.locked AS locked_23,
  p0_.hidden AS hidden_24,
  p0_.price AS price_25,
  p0_.locale AS locale_26,
  p0_.author AS author_27,
  p0_.author_link AS author_link_28,
  p0_.author_title AS author_title_29,
  p0_.tt AS tt_30,
  p0_.json_data AS json_data_31,
  p0_.keywords AS keywords_32,
  p0_.page_category_id AS page_category_id_33,
  p0_.label_id AS label_id_34,
  p0_.created_by_id AS created_by_id_35
FROM
  page p0_
  INNER JOIN page_category p1_ ON p0_.page_category_id = p1_.id
WHERE
  p1_.slug = ?
  AND p0_.is_active = 1
  AND p0_.locale = ?
ORDER BY
  p0_.published DESC

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_.extract_slider AS extract_slider_18, p0_.order_home AS order_home_19, p0_.order_category AS order_category_20, p0_.order_menu AS order_menu_21, p0_.order_slider AS order_slider_22, p0_.locked AS locked_23, p0_.hidden AS hidden_24, p0_.price AS price_25, p0_.locale AS locale_26, p0_.author AS author_27, p0_.author_link AS author_link_28, p0_.author_title AS author_title_29, p0_.tt AS tt_30, p0_.json_data AS json_data_31, p0_.keywords AS keywords_32, p0_.page_category_id AS page_category_id_33, p0_.label_id AS label_id_34, p0_.created_by_id AS created_by_id_35 FROM page p0_ INNER JOIN page_category p1_ ON p0_.page_category_id = p1_.id WHERE p1_.slug = 'novosti' AND p0_.is_active = 1 AND p0_.locale = 'hr' ORDER BY p0_.published DESC;

#	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 405)
7	App\Controller\web\ScreenzController->findPages (line 221)
8	App\Controller\web\ScreenzController->newsPage (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)

11.92 ms

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_.extract_slider AS extract_slider_18, p0_.order_home AS order_home_19, p0_.order_category AS order_category_20, p0_.order_menu AS order_menu_21, p0_.order_slider AS order_slider_22, p0_.locked AS locked_23, p0_.hidden AS hidden_24, p0_.price AS price_25, p0_.locale AS locale_26, p0_.author AS author_27, p0_.author_link AS author_link_28, p0_.author_title AS author_title_29, p0_.tt AS tt_30, p0_.json_data AS json_data_31, p0_.keywords AS keywords_32, p0_.page_category_id AS page_category_id_33, p0_.label_id AS label_id_34, p0_.created_by_id AS created_by_id_35 FROM page p0_ INNER JOIN page_category p1_ ON p0_.page_category_id = p1_.id WHERE p1_.slug = ? AND p0_.is_active = 1 AND p0_.locale = ? ORDER BY p0_.published DESC LIMIT 4

Parameters:

[
  "blog"
  "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_.extract_slider AS extract_slider_18,
  p0_.order_home AS order_home_19,
  p0_.order_category AS order_category_20,
  p0_.order_menu AS order_menu_21,
  p0_.order_slider AS order_slider_22,
  p0_.locked AS locked_23,
  p0_.hidden AS hidden_24,
  p0_.price AS price_25,
  p0_.locale AS locale_26,
  p0_.author AS author_27,
  p0_.author_link AS author_link_28,
  p0_.author_title AS author_title_29,
  p0_.tt AS tt_30,
  p0_.json_data AS json_data_31,
  p0_.keywords AS keywords_32,
  p0_.page_category_id AS page_category_id_33,
  p0_.label_id AS label_id_34,
  p0_.created_by_id AS created_by_id_35
FROM
  page p0_
  INNER JOIN page_category p1_ ON p0_.page_category_id = p1_.id
WHERE
  p1_.slug = ?
  AND p0_.is_active = 1
  AND p0_.locale = ?
ORDER BY
  p0_.published DESC
LIMIT
  4

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_.extract_slider AS extract_slider_18, p0_.order_home AS order_home_19, p0_.order_category AS order_category_20, p0_.order_menu AS order_menu_21, p0_.order_slider AS order_slider_22, p0_.locked AS locked_23, p0_.hidden AS hidden_24, p0_.price AS price_25, p0_.locale AS locale_26, p0_.author AS author_27, p0_.author_link AS author_link_28, p0_.author_title AS author_title_29, p0_.tt AS tt_30, p0_.json_data AS json_data_31, p0_.keywords AS keywords_32, p0_.page_category_id AS page_category_id_33, p0_.label_id AS label_id_34, p0_.created_by_id AS created_by_id_35 FROM page p0_ INNER JOIN page_category p1_ ON p0_.page_category_id = p1_.id WHERE p1_.slug = 'blog' AND p0_.is_active = 1 AND p0_.locale = 'hr' ORDER BY p0_.published DESC LIMIT 4;

#	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 405)
7	App\Controller\web\ScreenzController->findPages (line 222)
8	App\Controller\web\ScreenzController->newsPage (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.92 ms

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 94)
19	__TwigTemplate_ba2873a3edf7de502d8a350db9d16d3c->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 49)
24	__TwigTemplate_ba2873a3edf7de502d8a350db9d16d3c->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 224)
33	App\Controller\web\ScreenzController->newsPage (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)

0.94 ms

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 83)
8	App\Controller\web\ScreenzController->footerCategory (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 82)
16	__TwigTemplate_09aa6ffa198febd95e550342cbfe8471->doDisplay (line 394)
17	Twig\Template->displayWithErrorHandling (line 367)
18	Twig\Template->display (line 217)
19	__TwigTemplate_ba2873a3edf7de502d8a350db9d16d3c->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 49)
24	__TwigTemplate_ba2873a3edf7de502d8a350db9d16d3c->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 224)
33	App\Controller\web\ScreenzController->newsPage (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)

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	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\Label	No errors.
App\Entity\User	No errors.
App\Entity\Document	No errors.
App\Entity\Image	No errors.
App\Entity\Paragraph	No errors.
App\Entity\Item	No errors.
App\Entity\Embedding	No errors.
App\Entity\Product	No errors.
App\Entity\ProductCategory	No errors.
App\Entity\NjuskaloCategory	No errors.
App\Entity\Inventory	No errors.
App\Entity\Workbook	No errors.
App\Entity\Tag	No errors.
App\Entity\OrderItem	No errors.
App\Entity\Modul	No errors.
App\Entity\Vehicle	No errors.
App\Entity\ChatConversation	No errors.
App\Entity\ChatMessage	No errors.
App\Entity\UserLabel	No errors.
App\Entity\Client	No errors.
App\Entity\Project	No errors.
App\Entity\DocumentStatus	No errors.
App\Entity\Lead	No errors.
App\Entity\Service	No errors.
App\Entity\DocumentEmbeddings	No errors.
App\Entity\ProductTemp	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/novosti/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping