Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

466.49 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

458.07 ms
(98.19%)

SELECT review.event AS review_event, review_modify.mod_date as update, review_product.value AS review_product, product_trans.name AS product_name, 
            JSON_AGG 
                (DISTINCT
                    CASE
                        WHEN product_photo.ext IS NOT NULL THEN
                            JSONB_BUILD_OBJECT
                            (
                                'product_img_root', product_photo.root,
                                'product_img', CONCAT ( '/upload/product_photo' , '/', product_photo.name),
                                'product_img_ext', product_photo.ext,
                                'product_img_cdn', product_photo.cdn
                            )
                        ELSE NULL
                END)
            AS product_images, category_info.url AS category_url, product_info.url as product_url, review_status.value AS review_status, review_text.value AS review_text, review_user.value AS review_user, review_rating.value AS review_rating_value, profile_personal.username as profile_username, review_name.value AS review_name, review_average_counter.value AS count FROM product_review review INNER JOIN product_review_event review_event ON review.event = review_event.id INNER JOIN product_review_modify review_modify ON review_modify.event = review_event.id INNER JOIN product_review_product review_product ON review_product.event = review_event.id INNER JOIN product_review_status review_status ON review_status.event = review_event.id AND review_status.value = ? INNER JOIN product_review_text review_text ON review_text.event = review_event.id INNER JOIN product_review_user review_user ON review_user.event = review_event.id LEFT JOIN product_review_rating review_rating ON review_rating.event = review_event.id LEFT JOIN product_review_name review_name ON review_name.event = review_event.id INNER JOIN product product ON product.id = review_product.value INNER JOIN product_review_average review_average ON review_average.product = review_product.value INNER JOIN product_event product_event ON product_event.id = product.event INNER JOIN product_trans product_trans ON product_trans.event = product_event.id LEFT JOIN product_photo product_photo ON product_photo.event = product_event.id AND product_photo.root = TRUE LEFT JOIN product_categories_product product_category ON product_category.event = product_event.id LEFT JOIN product_category category ON category.id = product_category.category LEFT JOIN product_info product_info ON product_info.product = product.id LEFT JOIN product_category_info category_info ON category_info.event = category.event INNER JOIN product_review_average_counter review_average_counter ON review_average_counter.product = review_average.product INNER JOIN users_profile_info profile_info ON profile_info.usr = review_user.value AND profile_info.active = true LEFT JOIN users_profile profile ON profile.id = profile_info.profile LEFT JOIN users_profile_personal profile_personal ON profile_personal.event = profile.event GROUP BY review.event, review_modify.mod_date, review_product.value, product_trans.name, category_info.url, product_info.url, review_status.value, review_text.value, review_user.value, review_rating.value, profile_personal.username, review_name.value, review_average_counter.value, review.id ORDER BY review.id DESC LIMIT 3

Parameters:

[
  "active"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  review.event AS review_event,
  review_modify.mod_date as
update
  ,
  review_product.value AS review_product,
  product_trans.name AS product_name,
  JSON_AGG (
    DISTINCT CASE WHEN product_photo.ext IS NOT NULL THEN
      JSONB_BUILD_OBJECT (
        'product_img_root',
        product_photo.root,
        'product_img',
        CONCAT (
          '/upload/product_photo', '/', product_photo.name
        ),
        'product_img_ext',
        product_photo.ext,
        'product_img_cdn',
        product_photo.cdn
      )
    ELSE
      NULL
    END
  ) AS product_images,
  category_info.url AS category_url,
  product_info.url as product_url,
  review_status.value AS review_status,
  review_text.value AS review_text,
  review_user.value AS review_user,
  review_rating.value AS review_rating_value,
  profile_personal.username as profile_username,
  review_name.value AS review_name,
  review_average_counter.value AS count
FROM
  product_review review
  INNER JOIN product_review_event review_event ON review.event = review_event.id
  INNER JOIN product_review_modify review_modify ON review_modify.event = review_event.id
  INNER JOIN product_review_product review_product ON review_product.event = review_event.id
  INNER JOIN product_review_status review_status ON review_status.event = review_event.id
  AND review_status.value = ?
  INNER JOIN product_review_text review_text ON review_text.event = review_event.id
  INNER JOIN product_review_user review_user ON review_user.event = review_event.id
  LEFT JOIN product_review_rating review_rating ON review_rating.event = review_event.id
  LEFT JOIN product_review_name review_name ON review_name.event = review_event.id
  INNER JOIN product product ON product.id = review_product.value
  INNER JOIN product_review_average review_average ON review_average.product = review_product.value
  INNER JOIN product_event product_event ON product_event.id = product.event
  INNER JOIN product_trans product_trans ON product_trans.event = product_event.id
  LEFT JOIN product_photo product_photo ON product_photo.event = product_event.id
  AND product_photo.root = TRUE
  LEFT JOIN product_categories_product product_category ON product_category.event = product_event.id
  LEFT JOIN product_category category ON category.id = product_category.category
  LEFT JOIN product_info product_info ON product_info.product = product.id
  LEFT JOIN product_category_info category_info ON category_info.event = category.event
  INNER JOIN product_review_average_counter review_average_counter ON review_average_counter.product = review_average.product
  INNER JOIN users_profile_info profile_info ON profile_info.usr = review_user.value
  AND profile_info.active = true
  LEFT JOIN users_profile profile ON profile.id = profile_info.profile
  LEFT JOIN users_profile_personal profile_personal ON profile_personal.event = profile.event
GROUP BY
  review.event,
  review_modify.mod_date,
  review_product.value,
  product_trans.name,
  category_info.url,
  product_info.url,
  review_status.value,
  review_text.value,
  review_user.value,
  review_rating.value,
  profile_personal.username,
  review_name.value,
  review_average_counter.value,
  review.id
ORDER BY
  review.id DESC
LIMIT
  3

SELECT review.event AS review_event, review_modify.mod_date as update, review_product.value AS review_product, product_trans.name AS product_name, 
            JSON_AGG 
                (DISTINCT
                    CASE
                        WHEN product_photo.ext IS NOT NULL THEN
                            JSONB_BUILD_OBJECT
                            (
                                'product_img_root', product_photo.root,
                                'product_img', CONCAT ( '/upload/product_photo' , '/', product_photo.name),
                                'product_img_ext', product_photo.ext,
                                'product_img_cdn', product_photo.cdn
                            )
                        ELSE NULL
                END)
            AS product_images, category_info.url AS category_url, product_info.url as product_url, review_status.value AS review_status, review_text.value AS review_text, review_user.value AS review_user, review_rating.value AS review_rating_value, profile_personal.username as profile_username, review_name.value AS review_name, review_average_counter.value AS count FROM product_review review INNER JOIN product_review_event review_event ON review.event = review_event.id INNER JOIN product_review_modify review_modify ON review_modify.event = review_event.id INNER JOIN product_review_product review_product ON review_product.event = review_event.id INNER JOIN product_review_status review_status ON review_status.event = review_event.id AND review_status.value = 'active' INNER JOIN product_review_text review_text ON review_text.event = review_event.id INNER JOIN product_review_user review_user ON review_user.event = review_event.id LEFT JOIN product_review_rating review_rating ON review_rating.event = review_event.id LEFT JOIN product_review_name review_name ON review_name.event = review_event.id INNER JOIN product product ON product.id = review_product.value INNER JOIN product_review_average review_average ON review_average.product = review_product.value INNER JOIN product_event product_event ON product_event.id = product.event INNER JOIN product_trans product_trans ON product_trans.event = product_event.id LEFT JOIN product_photo product_photo ON product_photo.event = product_event.id AND product_photo.root = TRUE LEFT JOIN product_categories_product product_category ON product_category.event = product_event.id LEFT JOIN product_category category ON category.id = product_category.category LEFT JOIN product_info product_info ON product_info.product = product.id LEFT JOIN product_category_info category_info ON category_info.event = category.event INNER JOIN product_review_average_counter review_average_counter ON review_average_counter.product = review_average.product INNER JOIN users_profile_info profile_info ON profile_info.usr = review_user.value AND profile_info.active = true LEFT JOIN users_profile profile ON profile.id = profile_info.profile LEFT JOIN users_profile_personal profile_personal ON profile_personal.event = profile.event GROUP BY review.event, review_modify.mod_date, review_product.value, product_trans.name, category_info.url, product_info.url, review_status.value, review_text.value, review_user.value, review_rating.value, profile_personal.username, review_name.value, review_average_counter.value, review.id ORDER BY review.id DESC LIMIT 3;

#	File/Call
1	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 323)
2	BaksDev\Core\Doctrine\DBALQueryBuilder->executeDBALQuery (line 252)
3	BaksDev\Core\Doctrine\DBALQueryBuilder->fetchAllHydrate (line 337)
4	__TwigTemplate_fd901901ee22689ccd57ed43ab195667->doDisplay (line 71)
5	Twig\Template->yield (line 402)
6	Twig\Template->display (line 358)
7	Twig\Template->render (line 373)
8	Twig\TemplateWrapper->render (line 51)
9	Twig\Environment->render (line 333)
10	BaksDev\Products\Review\Twig\ReviewsWidgetExtension->reviews (line 59)
11	__TwigTemplate_b65d37427587253fc16180abc02b8145->doDisplay (line 73)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Extension\CoreExtension->include (line 1518)
17	__TwigTemplate_4ff3d0a801dd933357eb6b4f1325ae31::doDisplay (line 133)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Extension\CoreExtension->include (line 1518)
23	__TwigTemplate_a5ec5aa78f21db01dd95a726071285b7::block_content (line 128)
24	Twig\Template->yieldBlock (line 446)
25	__TwigTemplate_0b0ef2b8c55deba14181325372aaec4e->doDisplay (line 141)
26	Twig\Template->yield (line 402)
27	__TwigTemplate_a5ec5aa78f21db01dd95a726071285b7->doDisplay (line 55)
28	Twig\Template->yield (line 402)
29	Twig\Template->display (line 358)
30	Twig\Template->render (line 373)
31	Twig\TemplateWrapper->render (line 51)
32	Twig\Environment->render (line 333)
33	BaksDev\Core\Controller\AbstractController->render (line 359)
34	Core\Controller\HomepageController->index (line 49)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
37	Symfony\Component\HttpKernel\Kernel->handle (line 182)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
39	require_once (line 29)
40	require_once (line 5)

8.42 ms
(1.81%)

SELECT poster.id, poster.event AS event, event.title AS poster_title, event.sort AS poster_sort, event.start AS poster_start, event.ended AS poster_end, JSON_AGG(
                    DISTINCT JSONB_BUILD_OBJECT(
                        'texts', poster_text.text,
                        'positions', poster_text.position,
                        'css', poster_text.css
                    )
                ) AS poster_text, CONCAT ('/upload/poster_image' , '/', poster_image.name) AS poster_image_name, poster_image.ext AS poster_image_ext, poster_image.cdn AS poster_image_cdn FROM poster LEFT JOIN poster_profile project_profile ON project_profile.event = poster.event INNER JOIN poster_event event ON 
                    event.id = poster.event AND
                    event.device = ? AND
                    
                    DATE(event.start) <= CURRENT_DATE AND
                    (event.ended IS NULL OR DATE(event.ended) >= CURRENT_DATE)
                  LEFT JOIN poster_text poster_text ON poster_text.event = poster.event LEFT JOIN poster_image poster_image ON poster_image.event = poster.event WHERE (project_profile.value IS NULL OR project_profile.value = ?) GROUP BY poster.id, poster.event, event.title, event.sort, event.start, event.ended, poster_image.name, poster_image.ext, poster_image.cdn ORDER BY event.sort ASC

Parameters:

[
  "pc"
  "019469c3-700f-76a9-9b34-ccde7b4e6f49"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  poster.id,
  poster.event AS event,
  event.title AS poster_title,
  event.sort AS poster_sort,
  event.start AS poster_start,
  event.ended AS poster_end,
  JSON_AGG(
    DISTINCT JSONB_BUILD_OBJECT(
      'texts', poster_text.text, 'positions',
      poster_text.position, 'css', poster_text.css
    )
  ) AS poster_text,
  CONCAT (
    '/upload/poster_image', '/', poster_image.name
  ) AS poster_image_name,
  poster_image.ext AS poster_image_ext,
  poster_image.cdn AS poster_image_cdn
FROM
  poster
  LEFT JOIN poster_profile project_profile ON project_profile.event = poster.event
  INNER JOIN poster_event event ON event.id = poster.event
  AND event.device = ?
  AND DATE(event.start) <= CURRENT_DATE
  AND (
    event.ended IS NULL
    OR DATE(event.ended) >= CURRENT_DATE
  )
  LEFT JOIN poster_text poster_text ON poster_text.event = poster.event
  LEFT JOIN poster_image poster_image ON poster_image.event = poster.event
WHERE
  (
    project_profile.value IS NULL
    OR project_profile.value = ?
  )
GROUP BY
  poster.id,
  poster.event,
  event.title,
  event.sort,
  event.start,
  event.ended,
  poster_image.name,
  poster_image.ext,
  poster_image.cdn
ORDER BY
  event.sort ASC

SELECT poster.id, poster.event AS event, event.title AS poster_title, event.sort AS poster_sort, event.start AS poster_start, event.ended AS poster_end, JSON_AGG(
                    DISTINCT JSONB_BUILD_OBJECT(
                        'texts', poster_text.text,
                        'positions', poster_text.position,
                        'css', poster_text.css
                    )
                ) AS poster_text, CONCAT ('/upload/poster_image' , '/', poster_image.name) AS poster_image_name, poster_image.ext AS poster_image_ext, poster_image.cdn AS poster_image_cdn FROM poster LEFT JOIN poster_profile project_profile ON project_profile.event = poster.event INNER JOIN poster_event event ON 
                    event.id = poster.event AND
                    event.device = 'pc' AND
                    
                    DATE(event.start) <= CURRENT_DATE AND
                    (event.ended IS NULL OR DATE(event.ended) >= CURRENT_DATE)
                  LEFT JOIN poster_text poster_text ON poster_text.event = poster.event LEFT JOIN poster_image poster_image ON poster_image.event = poster.event WHERE (project_profile.value IS NULL OR project_profile.value = '019469c3-700f-76a9-9b34-ccde7b4e6f49') GROUP BY poster.id, poster.event, event.title, event.sort, event.start, event.ended, poster_image.name, poster_image.ext, poster_image.cdn ORDER BY event.sort ASC;

#	File/Call
1	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 323)
2	BaksDev\Core\Doctrine\DBALQueryBuilder->executeDBALQuery (line 252)
3	BaksDev\Core\Doctrine\DBALQueryBuilder->fetchAllHydrate (line 337)
4	Generator->valid (line 162)
5	BaksDev\Posters\Repository\AllPostersUserProfile\AllPostersUserProfileRepository->findAll (line 162)
6	Core\Controller\HomepageController->index (line 47)
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)

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

Entities Mapping

No loaded entities.

Symfony Profiler

GET https://all.white-sign.baks.dev/

Configuration Settings

Theme

Page Width