Symfony Profiler

Query Metrics

15 Database Queries

10 Different statements

1049.58 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

748.31 ms
(71.30%)

SELECT product.id AS product_id, product.event AS product_event, product_trans.name AS product_name, product_info.url AS product_url, product_info.sort AS product_sort, product_active.active as product_active, product_active.active_from as product_active_from, product_active.active_to as product_active_to, category_offer.card AS category_offer_card , category_offer.reference AS product_offer_reference, category_variation.card AS category_variation_card, category_variation.reference as product_variation_reference, category_modification.card AS category_modification_card , category_modification.reference as product_modification_reference, JSON_AGG( DISTINCT product_invariable.id) AS invariable, 
                CASE
    
                    WHEN product_modification_image.name IS NOT NULL THEN
                        CONCAT ( '/upload/product_modification_images' , '/', product_modification_image.name)
                    WHEN product_variation_image.name IS NOT NULL THEN
                        CONCAT ( '/upload/product_variation_images' , '/', product_variation_image.name)
                    WHEN product_offer_images.name IS NOT NULL THEN
                        CONCAT ( '/upload/product_offer_images' , '/', product_offer_images.name)
                    WHEN product_photo.name IS NOT NULL THEN
                        CONCAT ( '/upload/product_photo' , '/', product_photo.name)
                    ELSE NULL
                   
                END AS product_image
            , 
            COALESCE(
                product_modification_image.ext,
                product_variation_image.ext,
                product_offer_images.ext,
                product_photo.ext
            ) AS product_image_ext, 
            COALESCE(
                product_modification_image.cdn,
                product_variation_image.cdn,
                product_offer_images.cdn,
                product_photo.cdn
            ) AS product_image_cdn, category_info.url AS category_url, category_trans.name AS category_name, 
            COALESCE(
                NULLIF(MIN(product_modification_price.price), 0),
                NULLIF(MIN(product_variation_price.price), 0),
                NULLIF(MIN(product_offer_price.price), 0),
                NULLIF(MIN(product_price.price), 0),
                0
            ) AS product_price
		, 
            CASE

			   WHEN MIN(product_modification_price.price) IS NOT NULL
			   THEN product_modification_price.currency

			   WHEN MIN(product_variation_price.price) IS NOT NULL
			   THEN product_variation_price.currency

			   WHEN MIN(product_offer_price.price) IS NOT NULL
			   THEN product_offer_price.currency

			   WHEN MIN(product_price.price) IS NOT NULL
			   THEN product_price.currency

			   ELSE NULL

			END AS product_currency
		, project_profile_discount.value AS project_discount FROM product INNER JOIN product_categories_product product_event_category ON product_event_category.event = product.event AND product_event_category.category IN (?) LEFT JOIN product_trans product_trans ON product_trans.event = product.event AND product_trans.local = ? LEFT JOIN product_info product_info ON product_info.product = product.id LEFT JOIN product_active product_active ON product_active.event = product.event LEFT JOIN product_price product_price ON product_price.event = product.event AND product_price.price > 0 LEFT JOIN product_offer product_offer ON product_offer.event = product.event INNER JOIN users_profile project_profile ON 
                        project_profile.id = ? LEFT JOIN product_category category ON category.id = product_event_category.category LEFT JOIN product_category_info category_info ON category_info.event = category.event AND category_info.active IS TRUE LEFT JOIN product_category_trans category_trans ON category_trans.event = category.event AND category_trans.local = ? LEFT JOIN product_category_offers category_offer ON category_offer.id = product_offer.category_offer LEFT JOIN product_offer_price product_offer_price ON product_offer_price.offer = product_offer.id AND product_offer_price.price > 0 LEFT JOIN product_offer_quantity product_offer_quantity ON product_offer_quantity.offer = product_offer.id LEFT JOIN product_variation product_variation ON product_variation.offer = product_offer.id LEFT JOIN product_variation_images product_variation_image ON 
                product_variation_image.variation = product_variation.id AND
                product_variation_image.root = true
			 LEFT JOIN product_offer_images product_offer_images ON 
			product_variation_image.name IS NULL AND
			product_offer_images.offer = product_offer.id AND
			product_offer_images.root = true
			 LEFT JOIN product_photo product_photo ON 
                product_offer_images.name IS NULL AND
                product_photo.event = product.event AND
                product_photo.root = true
			 LEFT JOIN product_category_variation category_variation ON category_variation.id = product_variation.category_variation LEFT JOIN product_modification product_modification ON product_modification.variation = product_variation.id LEFT JOIN product_invariable product_invariable ON 
                                    product_invariable.product = product.id
                                    AND
                                        CASE
                                            WHEN product_offer.const IS NOT NULL THEN product_invariable.offer = product_offer.const
                                            ELSE product_invariable.offer IS NULL
                                        END
                                    AND
                                        CASE
                                            WHEN product_variation.const IS NOT NULL THEN product_invariable.variation = product_variation.const
                                            ELSE product_invariable.variation IS NULL
                                        END
                                    AND
                                        CASE
                                            WHEN product_modification.const IS NOT NULL THEN product_invariable.modification = product_modification.const
                                            ELSE product_invariable.modification IS NULL
                                        END
                                 LEFT JOIN product_variation_price product_variation_price ON product_variation_price.variation = product_variation.id AND product_variation_price.price > 0 LEFT JOIN product_variation_quantity product_variation_quantity ON product_variation_quantity.variation = product_variation.id LEFT JOIN product_category_modification category_modification ON category_modification.id = product_modification.category_modification LEFT JOIN product_modification_price product_modification_price ON product_modification_price.modification = product_modification.id AND product_modification_price.price > 0 LEFT JOIN product_modification_quantity product_modification_quantity ON product_modification_quantity.modification = product_modification.id LEFT JOIN product_modification_images product_modification_image ON 
                product_modification_image.modification = product_modification.id AND
                product_modification_image.root = true
			 LEFT JOIN user_profile_discount project_profile_discount ON 
                        project_profile_discount.event = project_profile.event WHERE (COALESCE(
                NULLIF(product_modification_price.price, 0),
                NULLIF(product_variation_price.price, 0),
                NULLIF(product_offer_price.price, 0),
                NULLIF(product_price.price, 0),
                0
            ) > 0) AND (
            CASE
                WHEN product_modification_quantity.quantity IS NOT NULL THEN (product_modification_quantity.quantity - product_modification_quantity.reserve)
                WHEN product_variation_quantity.quantity IS NOT NULL THEN (product_variation_quantity.quantity - product_variation_quantity.reserve)
                WHEN product_offer_quantity.quantity IS NOT NULL THEN (product_offer_quantity.quantity - product_offer_quantity.reserve)
                WHEN product_price.quantity  IS NOT NULL THEN (product_price.quantity - product_price.reserve)
                ELSE 0
            END > 0
        ) GROUP BY product_price.currency, product_offer_price.currency, product_variation_price.currency, product_modification_price.currency, product.id, product.event, product_trans.name, product_info.url, product_info.sort, product_active.active, product_active.active_from, product_active.active_to, category_offer.card, category_offer.reference, category_variation.card, category_variation.reference, category_modification.card, category_modification.reference, product_modification_image.name, product_variation_image.name, product_offer_images.name, product_photo.name, product_modification_image.ext, product_variation_image.ext, product_offer_images.ext, product_photo.ext, product_modification_image.cdn, product_variation_image.cdn, product_offer_images.cdn, product_photo.cdn, category_info.url, category_trans.name, project_profile_discount.value ORDER BY product_info.sort DESC, SUM(product_modification_quantity.reserve) DESC, SUM(product_variation_quantity.reserve) DESC, SUM(product_offer_quantity.reserve) DESC, SUM(product_price.reserve) DESC, SUM(product_modification_quantity.quantity) DESC, SUM(product_variation_quantity.quantity) DESC, SUM(product_offer_quantity.quantity) DESC, SUM(product_price.quantity) DESC LIMIT 6

Parameters:

[
  BaksDev\Products\Category\Type\Id\CategoryProductUid {#949
    __toString(): "01876af0-ddfc-70c3-ab25-5f85f55a9907"
  }
  "ru"
  "01982ecf-0a6a-79e5-967b-4992d1b836bb"
  "ru"
]

View formatted query View runnable query View query backtrace

SELECT
  product.id AS product_id,
  product.event AS product_event,
  product_trans.name AS product_name,
  product_info.url AS product_url,
  product_info.sort AS product_sort,
  product_active.active as product_active,
  product_active.active_from as product_active_from,
  product_active.active_to as product_active_to,
  category_offer.card AS category_offer_card,
  category_offer.reference AS product_offer_reference,
  category_variation.card AS category_variation_card,
  category_variation.reference as product_variation_reference,
  category_modification.card AS category_modification_card,
  category_modification.reference as product_modification_reference,
  JSON_AGG(DISTINCT product_invariable.id) AS invariable,
  CASE WHEN product_modification_image.name IS NOT NULL THEN
    CONCAT (
      '/upload/product_modification_images',
      '/', product_modification_image.name
    )
  WHEN product_variation_image.name IS NOT NULL THEN
    CONCAT (
      '/upload/product_variation_images',
      '/', product_variation_image.name
    )
  WHEN product_offer_images.name IS NOT NULL THEN
    CONCAT (
      '/upload/product_offer_images',
      '/', product_offer_images.name
    )
  WHEN product_photo.name IS NOT NULL THEN
    CONCAT (
      '/upload/product_photo', '/', product_photo.name
    )
  ELSE
    NULL
  END AS product_image,
  COALESCE(
    product_modification_image.ext,
    product_variation_image.ext, product_offer_images.ext,
    product_photo.ext
  ) AS product_image_ext,
  COALESCE(
    product_modification_image.cdn,
    product_variation_image.cdn, product_offer_images.cdn,
    product_photo.cdn
  ) AS product_image_cdn,
  category_info.url AS category_url,
  category_trans.name AS category_name,
  COALESCE(
    NULLIF(
      MIN(
        product_modification_price.price
      ),
      0
    ),
    NULLIF(
      MIN(product_variation_price.price),
      0
    ),
    NULLIF(
      MIN(product_offer_price.price),
      0
    ),
    NULLIF(
      MIN(product_price.price),
      0
    ),
    0
  ) AS product_price,
  CASE WHEN MIN(
    product_modification_price.price
  ) IS NOT NULL THEN
    product_modification_price.currency
  WHEN MIN(product_variation_price.price) IS NOT NULL THEN
    product_variation_price.currency
  WHEN MIN(product_offer_price.price) IS NOT NULL THEN
    product_offer_price.currency
  WHEN MIN(product_price.price) IS NOT NULL THEN
    product_price.currency
  ELSE
    NULL
  END AS product_currency,
  project_profile_discount.value AS project_discount
FROM
  product
  INNER JOIN product_categories_product product_event_category ON product_event_category.event = product.event
  AND product_event_category.category IN (?)
  LEFT JOIN product_trans product_trans ON product_trans.event = product.event
  AND product_trans.local = ?
  LEFT JOIN product_info product_info ON product_info.product = product.id
  LEFT JOIN product_active product_active ON product_active.event = product.event
  LEFT JOIN product_price product_price ON product_price.event = product.event
  AND product_price.price > 0
  LEFT JOIN product_offer product_offer ON product_offer.event = product.event
  INNER JOIN users_profile project_profile ON project_profile.id = ?
  LEFT JOIN product_category category ON category.id = product_event_category.category
  LEFT JOIN product_category_info category_info ON category_info.event = category.event
  AND category_info.active IS TRUE
  LEFT JOIN product_category_trans category_trans ON category_trans.event = category.event
  AND category_trans.local = ?
  LEFT JOIN product_category_offers category_offer ON category_offer.id = product_offer.category_offer
  LEFT JOIN product_offer_price product_offer_price ON product_offer_price.offer = product_offer.id
  AND product_offer_price.price > 0
  LEFT JOIN product_offer_quantity product_offer_quantity ON product_offer_quantity.offer = product_offer.id
  LEFT JOIN product_variation product_variation ON product_variation.offer = product_offer.id
  LEFT JOIN product_variation_images product_variation_image ON product_variation_image.variation = product_variation.id
  AND product_variation_image.root = true
  LEFT JOIN product_offer_images product_offer_images ON product_variation_image.name IS NULL
  AND product_offer_images.offer = product_offer.id
  AND product_offer_images.root = true
  LEFT JOIN product_photo product_photo ON product_offer_images.name IS NULL
  AND product_photo.event = product.event
  AND product_photo.root = true
  LEFT JOIN product_category_variation category_variation ON category_variation.id = product_variation.category_variation
  LEFT JOIN product_modification product_modification ON product_modification.variation = product_variation.id
  LEFT JOIN product_invariable product_invariable ON product_invariable.product = product.id
  AND CASE WHEN product_offer.const IS NOT NULL THEN
    product_invariable.offer = product_offer.const
  ELSE
    product_invariable.offer IS NULL
  END
  AND CASE WHEN product_variation.const IS NOT NULL THEN
    product_invariable.variation = product_variation.const
  ELSE
    product_invariable.variation IS NULL
  END
  AND CASE WHEN product_modification.const IS NOT NULL THEN
    product_invariable.modification = product_modification.const
  ELSE
    product_invariable.modification IS NULL
  END
  LEFT JOIN product_variation_price product_variation_price ON product_variation_price.variation = product_variation.id
  AND product_variation_price.price > 0
  LEFT JOIN product_variation_quantity product_variation_quantity ON product_variation_quantity.variation = product_variation.id
  LEFT JOIN product_category_modification category_modification ON category_modification.id = product_modification.category_modification
  LEFT JOIN product_modification_price product_modification_price ON product_modification_price.modification = product_modification.id
  AND product_modification_price.price > 0
  LEFT JOIN product_modification_quantity product_modification_quantity ON product_modification_quantity.modification = product_modification.id
  LEFT JOIN product_modification_images product_modification_image ON product_modification_image.modification = product_modification.id
  AND product_modification_image.root = true
  LEFT JOIN user_profile_discount project_profile_discount ON project_profile_discount.event = project_profile.event
WHERE
  (
    COALESCE(
      NULLIF(
        product_modification_price.price,
        0
      ),
      NULLIF(
        product_variation_price.price, 0
      ),
      NULLIF(product_offer_price.price, 0),
      NULLIF(product_price.price, 0),
      0
    ) > 0
  )
  AND (
    CASE WHEN product_modification_quantity.quantity IS NOT NULL THEN
      (
        product_modification_quantity.quantity - product_modification_quantity.reserve
      )
    WHEN product_variation_quantity.quantity IS NOT NULL THEN
      (
        product_variation_quantity.quantity - product_variation_quantity.reserve
      )
    WHEN product_offer_quantity.quantity IS NOT NULL THEN
      (
        product_offer_quantity.quantity - product_offer_quantity.reserve
      )
    WHEN product_price.quantity IS NOT NULL THEN
      (
        product_price.quantity - product_price.reserve
      )
    ELSE
      0
    END > 0
  )
GROUP BY
  product_price.currency,
  product_offer_price.currency,
  product_variation_price.currency,
  product_modification_price.currency,
  product.id,
  product.event,
  product_trans.name,
  product_info.url,
  product_info.sort,
  product_active.active,
  product_active.active_from,
  product_active.active_to,
  category_offer.card,
  category_offer.reference,
  category_variation.card,
  category_variation.reference,
  category_modification.card,
  category_modification.reference,
  product_modification_image.name,
  product_variation_image.name,
  product_offer_images.name,
  product_photo.name,
  product_modification_image.ext,
  product_variation_image.ext,
  product_offer_images.ext,
  product_photo.ext,
  product_modification_image.cdn,
  product_variation_image.cdn,
  product_offer_images.cdn,
  product_photo.cdn,
  category_info.url,
  category_trans.name,
  project_profile_discount.value
ORDER BY
  product_info.sort DESC,
  SUM(
    product_modification_quantity.reserve
  ) DESC,
  SUM(
    product_variation_quantity.reserve
  ) DESC,
  SUM(product_offer_quantity.reserve) DESC,
  SUM(product_price.reserve) DESC,
  SUM(
    product_modification_quantity.quantity
  ) DESC,
  SUM(
    product_variation_quantity.quantity
  ) DESC,
  SUM(
    product_offer_quantity.quantity
  ) DESC,
  SUM(product_price.quantity) DESC
LIMIT
  6

SELECT product.id AS product_id, product.event AS product_event, product_trans.name AS product_name, product_info.url AS product_url, product_info.sort AS product_sort, product_active.active as product_active, product_active.active_from as product_active_from, product_active.active_to as product_active_to, category_offer.card AS category_offer_card , category_offer.reference AS product_offer_reference, category_variation.card AS category_variation_card, category_variation.reference as product_variation_reference, category_modification.card AS category_modification_card , category_modification.reference as product_modification_reference, JSON_AGG( DISTINCT product_invariable.id) AS invariable, 
                CASE
    
                    WHEN product_modification_image.name IS NOT NULL THEN
                        CONCAT ( '/upload/product_modification_images' , '/', product_modification_image.name)
                    WHEN product_variation_image.name IS NOT NULL THEN
                        CONCAT ( '/upload/product_variation_images' , '/', product_variation_image.name)
                    WHEN product_offer_images.name IS NOT NULL THEN
                        CONCAT ( '/upload/product_offer_images' , '/', product_offer_images.name)
                    WHEN product_photo.name IS NOT NULL THEN
                        CONCAT ( '/upload/product_photo' , '/', product_photo.name)
                    ELSE NULL
                   
                END AS product_image
            , 
            COALESCE(
                product_modification_image.ext,
                product_variation_image.ext,
                product_offer_images.ext,
                product_photo.ext
            ) AS product_image_ext, 
            COALESCE(
                product_modification_image.cdn,
                product_variation_image.cdn,
                product_offer_images.cdn,
                product_photo.cdn
            ) AS product_image_cdn, category_info.url AS category_url, category_trans.name AS category_name, 
            COALESCE(
                NULLIF(MIN(product_modification_price.price), 0),
                NULLIF(MIN(product_variation_price.price), 0),
                NULLIF(MIN(product_offer_price.price), 0),
                NULLIF(MIN(product_price.price), 0),
                0
            ) AS product_price
		, 
            CASE

			   WHEN MIN(product_modification_price.price) IS NOT NULL
			   THEN product_modification_price.currency

			   WHEN MIN(product_variation_price.price) IS NOT NULL
			   THEN product_variation_price.currency

			   WHEN MIN(product_offer_price.price) IS NOT NULL
			   THEN product_offer_price.currency

			   WHEN MIN(product_price.price) IS NOT NULL
			   THEN product_price.currency

			   ELSE NULL

			END AS product_currency
		, project_profile_discount.value AS project_discount FROM product INNER JOIN product_categories_product product_event_category ON product_event_category.event = product.event AND product_event_category.category IN ('01876af0-ddfc-70c3-ab25-5f85f55a9907') LEFT JOIN product_trans product_trans ON product_trans.event = product.event AND product_trans.local = 'ru' LEFT JOIN product_info product_info ON product_info.product = product.id LEFT JOIN product_active product_active ON product_active.event = product.event LEFT JOIN product_price product_price ON product_price.event = product.event AND product_price.price > 0 LEFT JOIN product_offer product_offer ON product_offer.event = product.event INNER JOIN users_profile project_profile ON 
                        project_profile.id = '01982ecf-0a6a-79e5-967b-4992d1b836bb' LEFT JOIN product_category category ON category.id = product_event_category.category LEFT JOIN product_category_info category_info ON category_info.event = category.event AND category_info.active IS TRUE LEFT JOIN product_category_trans category_trans ON category_trans.event = category.event AND category_trans.local = 'ru' LEFT JOIN product_category_offers category_offer ON category_offer.id = product_offer.category_offer LEFT JOIN product_offer_price product_offer_price ON product_offer_price.offer = product_offer.id AND product_offer_price.price > 0 LEFT JOIN product_offer_quantity product_offer_quantity ON product_offer_quantity.offer = product_offer.id LEFT JOIN product_variation product_variation ON product_variation.offer = product_offer.id LEFT JOIN product_variation_images product_variation_image ON 
                product_variation_image.variation = product_variation.id AND
                product_variation_image.root = true
			 LEFT JOIN product_offer_images product_offer_images ON 
			product_variation_image.name IS NULL AND
			product_offer_images.offer = product_offer.id AND
			product_offer_images.root = true
			 LEFT JOIN product_photo product_photo ON 
                product_offer_images.name IS NULL AND
                product_photo.event = product.event AND
                product_photo.root = true
			 LEFT JOIN product_category_variation category_variation ON category_variation.id = product_variation.category_variation LEFT JOIN product_modification product_modification ON product_modification.variation = product_variation.id LEFT JOIN product_invariable product_invariable ON 
                                    product_invariable.product = product.id
                                    AND
                                        CASE
                                            WHEN product_offer.const IS NOT NULL THEN product_invariable.offer = product_offer.const
                                            ELSE product_invariable.offer IS NULL
                                        END
                                    AND
                                        CASE
                                            WHEN product_variation.const IS NOT NULL THEN product_invariable.variation = product_variation.const
                                            ELSE product_invariable.variation IS NULL
                                        END
                                    AND
                                        CASE
                                            WHEN product_modification.const IS NOT NULL THEN product_invariable.modification = product_modification.const
                                            ELSE product_invariable.modification IS NULL
                                        END
                                 LEFT JOIN product_variation_price product_variation_price ON product_variation_price.variation = product_variation.id AND product_variation_price.price > 0 LEFT JOIN product_variation_quantity product_variation_quantity ON product_variation_quantity.variation = product_variation.id LEFT JOIN product_category_modification category_modification ON category_modification.id = product_modification.category_modification LEFT JOIN product_modification_price product_modification_price ON product_modification_price.modification = product_modification.id AND product_modification_price.price > 0 LEFT JOIN product_modification_quantity product_modification_quantity ON product_modification_quantity.modification = product_modification.id LEFT JOIN product_modification_images product_modification_image ON 
                product_modification_image.modification = product_modification.id AND
                product_modification_image.root = true
			 LEFT JOIN user_profile_discount project_profile_discount ON 
                        project_profile_discount.event = project_profile.event WHERE (COALESCE(
                NULLIF(product_modification_price.price, 0),
                NULLIF(product_variation_price.price, 0),
                NULLIF(product_offer_price.price, 0),
                NULLIF(product_price.price, 0),
                0
            ) > 0) AND (
            CASE
                WHEN product_modification_quantity.quantity IS NOT NULL THEN (product_modification_quantity.quantity - product_modification_quantity.reserve)
                WHEN product_variation_quantity.quantity IS NOT NULL THEN (product_variation_quantity.quantity - product_variation_quantity.reserve)
                WHEN product_offer_quantity.quantity IS NOT NULL THEN (product_offer_quantity.quantity - product_offer_quantity.reserve)
                WHEN product_price.quantity  IS NOT NULL THEN (product_price.quantity - product_price.reserve)
                ELSE 0
            END > 0
        ) GROUP BY product_price.currency, product_offer_price.currency, product_variation_price.currency, product_modification_price.currency, product.id, product.event, product_trans.name, product_info.url, product_info.sort, product_active.active, product_active.active_from, product_active.active_to, category_offer.card, category_offer.reference, category_variation.card, category_variation.reference, category_modification.card, category_modification.reference, product_modification_image.name, product_variation_image.name, product_offer_images.name, product_photo.name, product_modification_image.ext, product_variation_image.ext, product_offer_images.ext, product_photo.ext, product_modification_image.cdn, product_variation_image.cdn, product_offer_images.cdn, product_photo.cdn, category_info.url, category_trans.name, project_profile_discount.value ORDER BY product_info.sort DESC, SUM(product_modification_quantity.reserve) DESC, SUM(product_variation_quantity.reserve) DESC, SUM(product_offer_quantity.reserve) DESC, SUM(product_price.reserve) DESC, SUM(product_modification_quantity.quantity) DESC, SUM(product_variation_quantity.quantity) DESC, SUM(product_offer_quantity.quantity) DESC, SUM(product_price.quantity) DESC LIMIT 6;

#	File/Call
1	Doctrine\DBAL\Connection->executeCacheQuery (line 851)
2	BaksDev\Core\Doctrine\DBALQueryBuilder->executeCacheQuery (line 479)
3	BaksDev\Core\Doctrine\DBALQueryBuilder->executeDBALQuery (line 253)
4	BaksDev\Core\Doctrine\DBALQueryBuilder->fetchAllHydrate (line 341)
5	Generator->valid (line 922)
6	BaksDev\Products\Product\Repository\Cards\ModelsByCategory\ModelsByCategoryRepository->findAll (line 922)
7	BaksDev\Products\Category\Repository\MenuPublicCategory\MenuPublicCategoryRepository->findAll (line 148)
8	BaksDev\Products\Category\Listeners\Event\PublicCatalogMenuListener->onKernelController (line 54)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 193)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 29)
18	require_once (line 5)

276.76 ms
(26.37%)

SELECT product.id AS product_id, product.event AS product_event, product_trans.name AS product_name, product_info.url as product_url, product_offer.id as product_offer_uid, product_offer.value as product_offer_value, product_offer.postfix as product_offer_postfix, category_offer.reference as product_offer_reference, product_offer_variation.id as product_variation_uid, product_offer_variation.value as product_variation_value, product_offer_variation.postfix as product_variation_postfix, category_offer_variation.reference as product_variation_reference, product_offer_modification.id as product_modification_uid, product_offer_modification.value as product_modification_value, product_offer_modification.postfix as product_modification_postfix, category_offer_modification.reference as product_modification_reference, 
			CASE
			   WHEN product_offer_modification.article IS NOT NULL 
			   THEN product_offer_modification.article
			   
			   WHEN product_offer_variation.article IS NOT NULL 
			   THEN product_offer_variation.article
			   
			   WHEN product_offer.article IS NOT NULL 
			   THEN product_offer.article
			   
			   WHEN product_info.article IS NOT NULL 
			   THEN product_info.article
			   
			   ELSE NULL
			END AS product_article
		, 
            JSON_AGG
                    (DISTINCT
        				CASE
                            WHEN product_offer_images.ext IS NOT NULL
                            THEN JSONB_BUILD_OBJECT
                                (
                                    'img_root', product_offer_images.root,
                                    'img', CONCAT ( '/upload/product_offer_images' , '/', product_offer_images.name),
                                    'img_ext', product_offer_images.ext,
                                    'img_cdn', product_offer_images.cdn
                                )
        
                            WHEN product_offer_variation_image.ext IS NOT NULL
                            THEN JSONB_BUILD_OBJECT
                                (
                                    'img_root', product_offer_variation_image.root,
                                    'img', CONCAT ( '/upload/product_variation_images' , '/', product_offer_variation_image.name),
                                    'img_ext', product_offer_variation_image.ext,
                                    'img_cdn', product_offer_variation_image.cdn
                                )
        
                            WHEN product_offer_modification_image.ext IS NOT NULL
                            THEN JSONB_BUILD_OBJECT
                                (
                                    'img_root', product_offer_modification_image.root,
                                    'img', CONCAT ( '/upload/product_modification_images' , '/', product_offer_modification_image.name),
                                    'img_ext', product_offer_modification_image.ext,
                                    'img_cdn', product_offer_modification_image.cdn
                                )
        
                            WHEN product_photo.ext IS NOT NULL
                            THEN JSONB_BUILD_OBJECT
                                (
                                    'img_root', product_photo.root,
                                    'img', CONCAT ( '/upload/product_photo' , '/', product_photo.name),
                                    'img_ext', product_photo.ext,
                                    'img_cdn', product_photo.cdn
                                )
                            ELSE NULL
                        END
                    )
                    AS product_images, 
			COALESCE(
                NULLIF(product_modification_price.price, 0), 
                NULLIF(product_variation_price.price, 0), 
                NULLIF(product_offer_price.price, 0), 
                NULLIF(product_price.price, 0),
                0
            ) AS product_price
		, 
			COALESCE(
                NULLIF(product_modification_price.old, 0),
                NULLIF(product_variation_price.old, 0),
                NULLIF(product_offer_price.old, 0),
                NULLIF(product_price.old, 0),
                0
            ) AS product_old_price
		, 
			CASE
			   WHEN COALESCE(product_modification_price.price, 0) != 0 
			   THEN product_modification_price.currency
			   
			   WHEN COALESCE(product_variation_price.price, 0) != 0 
			   THEN product_variation_price.currency
			   
			   WHEN COALESCE(product_offer_price.price, 0) != 0 
			   THEN product_offer_price.currency
			   
			   WHEN COALESCE(product_price.price, 0) != 0 
			   THEN product_price.currency
			   
			   ELSE NULL
			END AS product_currency, category_info.url AS category_url, category_trans.name AS category_name, JSON_AGG
		( DISTINCT
			
				JSONB_BUILD_OBJECT
				(
					'field_sort', category_section_field.sort,
					'field_name', category_section_field.name,
					'field_card', category_section_field.card,
					'field_photo', category_section_field.photo,
					'field_type', category_section_field.type,
					'field_trans', category_section_field_trans.name,
					'field_value', product_property.value
				)
		)
			AS category_section_field, product_invariable.id AS product_invariable_id, project_profile_discount.value AS project_discount FROM product INNER JOIN product_event product_event ON product_event.id = product.event LEFT JOIN product_categories_product product_event_category ON 
                product_event_category.event = product.event AND 
                product_event_category.root = true INNER JOIN product_active product_active ON product_active.event = product.event LEFT JOIN product_offer product_offer ON product_offer.event = product.event   INNER JOIN users_profile project_profile ON 
                        project_profile.id = ? LEFT JOIN product_trans product_trans ON product_trans.event = product_event.id AND product_trans.local = ? LEFT JOIN product_price product_price ON product_price.event = product_event.id LEFT JOIN product_info product_info ON product_info.product = product.id LEFT JOIN product_category category ON category.id = product_event_category.category LEFT JOIN product_category_info category_info ON category_info.event = category.event LEFT JOIN product_category_trans category_trans ON category_trans.event = category.event AND category_trans.local = ? LEFT JOIN product_category_section category_section ON category_section.event = category.event LEFT JOIN product_category_section_field category_section_field ON category_section_field.section = category_section.id AND (category_section_field.card = TRUE OR category_section_field.photo = TRUE OR category_section_field.name = TRUE ) LEFT JOIN product_category_section_field_trans category_section_field_trans ON category_section_field_trans.field = category_section_field.id AND category_section_field_trans.local = ? LEFT JOIN product_property product_property ON product_property.event = product.event AND product_property.field = category_section_field.const LEFT JOIN product_offer_price product_offer_price ON product_offer_price.offer = product_offer.id LEFT JOIN product_offer_quantity product_offer_quantity ON product_offer_quantity.offer = product_offer.id LEFT JOIN product_category_offers category_offer ON category_offer.id = product_offer.category_offer LEFT JOIN product_variation product_offer_variation ON product_offer_variation.offer = product_offer.id   LEFT JOIN product_variation_images product_offer_variation_image ON product_offer_variation_image.variation = product_offer_variation.id AND product_offer_variation_image.root = true LEFT JOIN product_offer_images product_offer_images ON product_offer_variation_image.name IS NULL AND product_offer_images.offer = product_offer.id AND product_offer_images.root = true LEFT JOIN product_photo product_photo ON product_offer_images.name IS NULL AND product_photo.event = product_event.id AND product_photo.root = true LEFT JOIN product_category_variation category_offer_variation ON category_offer_variation.id = product_offer_variation.category_variation LEFT JOIN product_variation_price product_variation_price ON product_variation_price.variation = product_offer_variation.id LEFT JOIN product_variation_quantity product_variation_quantity ON product_variation_quantity.variation = product_offer_variation.id LEFT JOIN product_modification product_offer_modification ON product_offer_modification.variation = product_offer_variation.id   LEFT JOIN product_modification_price product_modification_price ON product_modification_price.modification = product_offer_modification.id LEFT JOIN product_modification_quantity product_modification_quantity ON product_modification_quantity.modification = product_offer_modification.id LEFT JOIN product_category_modification category_offer_modification ON category_offer_modification.id = product_offer_modification.category_modification LEFT JOIN product_modification_images product_offer_modification_image ON product_offer_modification_image.modification = product_offer_modification.id AND product_offer_modification_image.root = true LEFT JOIN product_invariable product_invariable ON 
                    product_invariable.product = product.id AND 
                    (
                        (product_offer.const IS NOT NULL AND product_invariable.offer = product_offer.const) OR 
                        (product_offer.const IS NULL AND product_invariable.offer IS NULL)
                    )
                    AND
                    (
                        (product_offer_variation.const IS NOT NULL AND product_invariable.variation = product_offer_variation.const) OR 
                        (product_offer_variation.const IS NULL AND product_invariable.variation IS NULL)
                    )
                   AND
                   (
                        (product_offer_modification.const IS NOT NULL AND product_invariable.modification = product_offer_modification.const) OR 
                        (product_offer_modification.const IS NULL AND product_invariable.modification IS NULL)
                   )
             LEFT JOIN user_profile_discount project_profile_discount ON 
                        project_profile_discount.event = project_profile.event WHERE (
            CASE
                WHEN product_modification_quantity.quantity IS NOT NULL THEN (product_modification_quantity.quantity - product_modification_quantity.reserve)
                WHEN product_variation_quantity.quantity IS NOT NULL THEN (product_variation_quantity.quantity - product_variation_quantity.reserve)
                WHEN product_offer_quantity.quantity IS NOT NULL THEN (product_offer_quantity.quantity - product_offer_quantity.reserve)
                WHEN product_price.quantity  IS NOT NULL THEN (product_price.quantity - product_price.reserve)
                ELSE 0
            END > 0
        ) AND (
 			CASE
			   WHEN product_modification_price.price IS NOT NULL AND (product_modification_price.old > product_modification_price.price) THEN product_modification_price.price
			   WHEN product_variation_price.price  IS NOT NULL AND (product_variation_price.old > product_variation_price.price) THEN product_variation_price.price
			   WHEN product_offer_price.price IS NOT NULL AND (product_offer_price.old > product_offer_price.price) THEN product_offer_price.price
			   WHEN product_price.price IS NOT NULL AND (product_price.old > product_price.price) THEN product_price.price
			   ELSE 0
			END > 0
 		) GROUP BY product_price.price, product_price.currency, product_price.quantity, product_price.reserve, product_info.article, product_info.sort, product_offer_price.price, product_offer_price.currency, product_offer_quantity.quantity, product_offer_quantity.reserve, product_variation_price.price, product_variation_price.currency, product_variation_quantity.quantity, product_variation_quantity.reserve, product_modification_price.price, product_modification_price.currency, product_modification_quantity.quantity, product_modification_quantity.reserve, product.id, product.event, product_trans.name, product_info.url, product_offer.id, product_offer.value, product_offer.postfix, category_offer.reference, product_offer_variation.id, product_offer_variation.value, product_offer_variation.postfix, category_offer_variation.reference, product_offer_modification.id, product_offer_modification.value, product_offer_modification.postfix, category_offer_modification.reference, product_offer_modification.article, product_offer_variation.article, product_offer.article, product_info.article, product_modification_price.price, product_variation_price.price, product_offer_price.price, product_price.price, product_modification_price.old, product_variation_price.old, product_offer_price.old, product_price.old, product_modification_price.currency, product_variation_price.currency, product_offer_price.currency, product_price.currency, category_info.url, category_trans.name, product_invariable.id, project_profile_discount.value ORDER BY product_info.sort DESC, product_modification_quantity.reserve DESC, product_variation_quantity.reserve DESC, product_offer_quantity.reserve DESC, product_price.reserve DESC LIMIT 16

Parameters:

[
  "01982ecf-0a6a-79e5-967b-4992d1b836bb"
  "ru"
  "ru"
  "ru"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  product.id AS product_id,
  product.event AS product_event,
  product_trans.name AS product_name,
  product_info.url as product_url,
  product_offer.id as product_offer_uid,
  product_offer.value as product_offer_value,
  product_offer.postfix as product_offer_postfix,
  category_offer.reference as product_offer_reference,
  product_offer_variation.id as product_variation_uid,
  product_offer_variation.value as product_variation_value,
  product_offer_variation.postfix as product_variation_postfix,
  category_offer_variation.reference as product_variation_reference,
  product_offer_modification.id as product_modification_uid,
  product_offer_modification.value as product_modification_value,
  product_offer_modification.postfix as product_modification_postfix,
  category_offer_modification.reference as product_modification_reference,
  CASE WHEN product_offer_modification.article IS NOT NULL THEN
    product_offer_modification.article
  WHEN product_offer_variation.article IS NOT NULL THEN
    product_offer_variation.article
  WHEN product_offer.article IS NOT NULL THEN
    product_offer.article
  WHEN product_info.article IS NOT NULL THEN
    product_info.article
  ELSE
    NULL
  END AS product_article,
  JSON_AGG (
    DISTINCT CASE WHEN product_offer_images.ext IS NOT NULL THEN
      JSONB_BUILD_OBJECT (
        'img_root',
        product_offer_images.root,
        'img',
        CONCAT (
          '/upload/product_offer_images',
          '/', product_offer_images.name
        ),
        'img_ext',
        product_offer_images.ext,
        'img_cdn',
        product_offer_images.cdn
      )
    WHEN product_offer_variation_image.ext IS NOT NULL THEN
      JSONB_BUILD_OBJECT (
        'img_root',
        product_offer_variation_image.root,
        'img',
        CONCAT (
          '/upload/product_variation_images',
          '/', product_offer_variation_image.name
        ),
        'img_ext',
        product_offer_variation_image.ext,
        'img_cdn',
        product_offer_variation_image.cdn
      )
    WHEN product_offer_modification_image.ext IS NOT NULL THEN
      JSONB_BUILD_OBJECT (
        'img_root',
        product_offer_modification_image.root,
        'img',
        CONCAT (
          '/upload/product_modification_images',
          '/', product_offer_modification_image.name
        ),
        'img_ext',
        product_offer_modification_image.ext,
        'img_cdn',
        product_offer_modification_image.cdn
      )
    WHEN product_photo.ext IS NOT NULL THEN
      JSONB_BUILD_OBJECT (
        'img_root',
        product_photo.root,
        'img',
        CONCAT (
          '/upload/product_photo', '/', product_photo.name
        ),
        'img_ext',
        product_photo.ext,
        'img_cdn',
        product_photo.cdn
      )
    ELSE
      NULL
    END
  ) AS product_images,
  COALESCE(
    NULLIF(
      product_modification_price.price,
      0
    ),
    NULLIF(
      product_variation_price.price, 0
    ),
    NULLIF(product_offer_price.price, 0),
    NULLIF(product_price.price, 0),
    0
  ) AS product_price,
  COALESCE(
    NULLIF(
      product_modification_price.old,
      0
    ),
    NULLIF(product_variation_price.old, 0),
    NULLIF(product_offer_price.old, 0),
    NULLIF(product_price.old, 0),
    0
  ) AS product_old_price,
  CASE WHEN COALESCE(
    product_modification_price.price,
    0
  ) != 0 THEN
    product_modification_price.currency
  WHEN COALESCE(
    product_variation_price.price, 0
  ) != 0 THEN
    product_variation_price.currency
  WHEN COALESCE(product_offer_price.price, 0) != 0 THEN
    product_offer_price.currency
  WHEN COALESCE(product_price.price, 0) != 0 THEN
    product_price.currency
  ELSE
    NULL
  END AS product_currency,
  category_info.url AS category_url,
  category_trans.name AS category_name,
  JSON_AGG (
    DISTINCT JSONB_BUILD_OBJECT (
      'field_sort', category_section_field.sort,
      'field_name', category_section_field.name,
      'field_card', category_section_field.card,
      'field_photo', category_section_field.photo,
      'field_type', category_section_field.type,
      'field_trans', category_section_field_trans.name,
      'field_value', product_property.value
    )
  ) AS category_section_field,
  product_invariable.id AS product_invariable_id,
  project_profile_discount.value AS project_discount
FROM
  product
  INNER JOIN product_event product_event ON product_event.id = product.event
  LEFT JOIN product_categories_product product_event_category ON product_event_category.event = product.event
  AND product_event_category.root = true
  INNER JOIN product_active product_active ON product_active.event = product.event
  LEFT JOIN product_offer product_offer ON product_offer.event = product.event
  INNER JOIN users_profile project_profile ON project_profile.id = ?
  LEFT JOIN product_trans product_trans ON product_trans.event = product_event.id
  AND product_trans.local = ?
  LEFT JOIN product_price product_price ON product_price.event = product_event.id
  LEFT JOIN product_info product_info ON product_info.product = product.id
  LEFT JOIN product_category category ON category.id = product_event_category.category
  LEFT JOIN product_category_info category_info ON category_info.event = category.event
  LEFT JOIN product_category_trans category_trans ON category_trans.event = category.event
  AND category_trans.local = ?
  LEFT JOIN product_category_section category_section ON category_section.event = category.event
  LEFT JOIN product_category_section_field category_section_field ON category_section_field.section = category_section.id
  AND (
    category_section_field.card = TRUE
    OR category_section_field.photo = TRUE
    OR category_section_field.name = TRUE
  )
  LEFT JOIN product_category_section_field_trans category_section_field_trans ON category_section_field_trans.field = category_section_field.id
  AND category_section_field_trans.local = ?
  LEFT JOIN product_property product_property ON product_property.event = product.event
  AND product_property.field = category_section_field.const
  LEFT JOIN product_offer_price product_offer_price ON product_offer_price.offer = product_offer.id
  LEFT JOIN product_offer_quantity product_offer_quantity ON product_offer_quantity.offer = product_offer.id
  LEFT JOIN product_category_offers category_offer ON category_offer.id = product_offer.category_offer
  LEFT JOIN product_variation product_offer_variation ON product_offer_variation.offer = product_offer.id
  LEFT JOIN product_variation_images product_offer_variation_image ON product_offer_variation_image.variation = product_offer_variation.id
  AND product_offer_variation_image.root = true
  LEFT JOIN product_offer_images product_offer_images ON product_offer_variation_image.name IS NULL
  AND product_offer_images.offer = product_offer.id
  AND product_offer_images.root = true
  LEFT JOIN product_photo product_photo ON product_offer_images.name IS NULL
  AND product_photo.event = product_event.id
  AND product_photo.root = true
  LEFT JOIN product_category_variation category_offer_variation ON category_offer_variation.id = product_offer_variation.category_variation
  LEFT JOIN product_variation_price product_variation_price ON product_variation_price.variation = product_offer_variation.id
  LEFT JOIN product_variation_quantity product_variation_quantity ON product_variation_quantity.variation = product_offer_variation.id
  LEFT JOIN product_modification product_offer_modification ON product_offer_modification.variation = product_offer_variation.id
  LEFT JOIN product_modification_price product_modification_price ON product_modification_price.modification = product_offer_modification.id
  LEFT JOIN product_modification_quantity product_modification_quantity ON product_modification_quantity.modification = product_offer_modification.id
  LEFT JOIN product_category_modification category_offer_modification ON category_offer_modification.id = product_offer_modification.category_modification
  LEFT JOIN product_modification_images product_offer_modification_image ON product_offer_modification_image.modification = product_offer_modification.id
  AND product_offer_modification_image.root = true
  LEFT JOIN product_invariable product_invariable ON product_invariable.product = product.id
  AND (
    (
      product_offer.const IS NOT NULL
      AND product_invariable.offer = product_offer.const
    )
    OR (
      product_offer.const IS NULL
      AND product_invariable.offer IS NULL
    )
  )
  AND (
    (
      product_offer_variation.const IS NOT NULL
      AND product_invariable.variation = product_offer_variation.const
    )
    OR (
      product_offer_variation.const IS NULL
      AND product_invariable.variation IS NULL
    )
  )
  AND (
    (
      product_offer_modification.const IS NOT NULL
      AND product_invariable.modification = product_offer_modification.const
    )
    OR (
      product_offer_modification.const IS NULL
      AND product_invariable.modification IS NULL
    )
  )
  LEFT JOIN user_profile_discount project_profile_discount ON project_profile_discount.event = project_profile.event
WHERE
  (
    CASE WHEN product_modification_quantity.quantity IS NOT NULL THEN
      (
        product_modification_quantity.quantity - product_modification_quantity.reserve
      )
    WHEN product_variation_quantity.quantity IS NOT NULL THEN
      (
        product_variation_quantity.quantity - product_variation_quantity.reserve
      )
    WHEN product_offer_quantity.quantity IS NOT NULL THEN
      (
        product_offer_quantity.quantity - product_offer_quantity.reserve
      )
    WHEN product_price.quantity IS NOT NULL THEN
      (
        product_price.quantity - product_price.reserve
      )
    ELSE
      0
    END > 0
  )
  AND (
    CASE WHEN product_modification_price.price IS NOT NULL
    AND (
      product_modification_price.old > product_modification_price.price
    ) THEN
      product_modification_price.price
    WHEN product_variation_price.price IS NOT NULL
    AND (
      product_variation_price.old > product_variation_price.price
    ) THEN
      product_variation_price.price
    WHEN product_offer_price.price IS NOT NULL
    AND (
      product_offer_price.old > product_offer_price.price
    ) THEN
      product_offer_price.price
    WHEN product_price.price IS NOT NULL
    AND (
      product_price.old > product_price.price
    ) THEN
      product_price.price
    ELSE
      0
    END > 0
  )
GROUP BY
  product_price.price,
  product_price.currency,
  product_price.quantity,
  product_price.reserve,
  product_info.article,
  product_info.sort,
  product_offer_price.price,
  product_offer_price.currency,
  product_offer_quantity.quantity,
  product_offer_quantity.reserve,
  product_variation_price.price,
  product_variation_price.currency,
  product_variation_quantity.quantity,
  product_variation_quantity.reserve,
  product_modification_price.price,
  product_modification_price.currency,
  product_modification_quantity.quantity,
  product_modification_quantity.reserve,
  product.id,
  product.event,
  product_trans.name,
  product_info.url,
  product_offer.id,
  product_offer.value,
  product_offer.postfix,
  category_offer.reference,
  product_offer_variation.id,
  product_offer_variation.value,
  product_offer_variation.postfix,
  category_offer_variation.reference,
  product_offer_modification.id,
  product_offer_modification.value,
  product_offer_modification.postfix,
  category_offer_modification.reference,
  product_offer_modification.article,
  product_offer_variation.article,
  product_offer.article,
  product_info.article,
  product_modification_price.price,
  product_variation_price.price,
  product_offer_price.price,
  product_price.price,
  product_modification_price.old,
  product_variation_price.old,
  product_offer_price.old,
  product_price.old,
  product_modification_price.currency,
  product_variation_price.currency,
  product_offer_price.currency,
  product_price.currency,
  category_info.url,
  category_trans.name,
  product_invariable.id,
  project_profile_discount.value
ORDER BY
  product_info.sort DESC,
  product_modification_quantity.reserve DESC,
  product_variation_quantity.reserve DESC,
  product_offer_quantity.reserve DESC,
  product_price.reserve DESC
LIMIT
  16

SELECT product.id AS product_id, product.event AS product_event, product_trans.name AS product_name, product_info.url as product_url, product_offer.id as product_offer_uid, product_offer.value as product_offer_value, product_offer.postfix as product_offer_postfix, category_offer.reference as product_offer_reference, product_offer_variation.id as product_variation_uid, product_offer_variation.value as product_variation_value, product_offer_variation.postfix as product_variation_postfix, category_offer_variation.reference as product_variation_reference, product_offer_modification.id as product_modification_uid, product_offer_modification.value as product_modification_value, product_offer_modification.postfix as product_modification_postfix, category_offer_modification.reference as product_modification_reference, 
			CASE
			   WHEN product_offer_modification.article IS NOT NULL 
			   THEN product_offer_modification.article
			   
			   WHEN product_offer_variation.article IS NOT NULL 
			   THEN product_offer_variation.article
			   
			   WHEN product_offer.article IS NOT NULL 
			   THEN product_offer.article
			   
			   WHEN product_info.article IS NOT NULL 
			   THEN product_info.article
			   
			   ELSE NULL
			END AS product_article
		, 
            JSON_AGG
                    (DISTINCT
        				CASE
                            WHEN product_offer_images.ext IS NOT NULL
                            THEN JSONB_BUILD_OBJECT
                                (
                                    'img_root', product_offer_images.root,
                                    'img', CONCAT ( '/upload/product_offer_images' , '/', product_offer_images.name),
                                    'img_ext', product_offer_images.ext,
                                    'img_cdn', product_offer_images.cdn
                                )
        
                            WHEN product_offer_variation_image.ext IS NOT NULL
                            THEN JSONB_BUILD_OBJECT
                                (
                                    'img_root', product_offer_variation_image.root,
                                    'img', CONCAT ( '/upload/product_variation_images' , '/', product_offer_variation_image.name),
                                    'img_ext', product_offer_variation_image.ext,
                                    'img_cdn', product_offer_variation_image.cdn
                                )
        
                            WHEN product_offer_modification_image.ext IS NOT NULL
                            THEN JSONB_BUILD_OBJECT
                                (
                                    'img_root', product_offer_modification_image.root,
                                    'img', CONCAT ( '/upload/product_modification_images' , '/', product_offer_modification_image.name),
                                    'img_ext', product_offer_modification_image.ext,
                                    'img_cdn', product_offer_modification_image.cdn
                                )
        
                            WHEN product_photo.ext IS NOT NULL
                            THEN JSONB_BUILD_OBJECT
                                (
                                    'img_root', product_photo.root,
                                    'img', CONCAT ( '/upload/product_photo' , '/', product_photo.name),
                                    'img_ext', product_photo.ext,
                                    'img_cdn', product_photo.cdn
                                )
                            ELSE NULL
                        END
                    )
                    AS product_images, 
			COALESCE(
                NULLIF(product_modification_price.price, 0), 
                NULLIF(product_variation_price.price, 0), 
                NULLIF(product_offer_price.price, 0), 
                NULLIF(product_price.price, 0),
                0
            ) AS product_price
		, 
			COALESCE(
                NULLIF(product_modification_price.old, 0),
                NULLIF(product_variation_price.old, 0),
                NULLIF(product_offer_price.old, 0),
                NULLIF(product_price.old, 0),
                0
            ) AS product_old_price
		, 
			CASE
			   WHEN COALESCE(product_modification_price.price, 0) != 0 
			   THEN product_modification_price.currency
			   
			   WHEN COALESCE(product_variation_price.price, 0) != 0 
			   THEN product_variation_price.currency
			   
			   WHEN COALESCE(product_offer_price.price, 0) != 0 
			   THEN product_offer_price.currency
			   
			   WHEN COALESCE(product_price.price, 0) != 0 
			   THEN product_price.currency
			   
			   ELSE NULL
			END AS product_currency, category_info.url AS category_url, category_trans.name AS category_name, JSON_AGG
		( DISTINCT
			
				JSONB_BUILD_OBJECT
				(
					'field_sort', category_section_field.sort,
					'field_name', category_section_field.name,
					'field_card', category_section_field.card,
					'field_photo', category_section_field.photo,
					'field_type', category_section_field.type,
					'field_trans', category_section_field_trans.name,
					'field_value', product_property.value
				)
		)
			AS category_section_field, product_invariable.id AS product_invariable_id, project_profile_discount.value AS project_discount FROM product INNER JOIN product_event product_event ON product_event.id = product.event LEFT JOIN product_categories_product product_event_category ON 
                product_event_category.event = product.event AND 
                product_event_category.root = true INNER JOIN product_active product_active ON product_active.event = product.event LEFT JOIN product_offer product_offer ON product_offer.event = product.event   INNER JOIN users_profile project_profile ON 
                        project_profile.id = '01982ecf-0a6a-79e5-967b-4992d1b836bb' LEFT JOIN product_trans product_trans ON product_trans.event = product_event.id AND product_trans.local = 'ru' LEFT JOIN product_price product_price ON product_price.event = product_event.id LEFT JOIN product_info product_info ON product_info.product = product.id LEFT JOIN product_category category ON category.id = product_event_category.category LEFT JOIN product_category_info category_info ON category_info.event = category.event LEFT JOIN product_category_trans category_trans ON category_trans.event = category.event AND category_trans.local = 'ru' LEFT JOIN product_category_section category_section ON category_section.event = category.event LEFT JOIN product_category_section_field category_section_field ON category_section_field.section = category_section.id AND (category_section_field.card = TRUE OR category_section_field.photo = TRUE OR category_section_field.name = TRUE ) LEFT JOIN product_category_section_field_trans category_section_field_trans ON category_section_field_trans.field = category_section_field.id AND category_section_field_trans.local = 'ru' LEFT JOIN product_property product_property ON product_property.event = product.event AND product_property.field = category_section_field.const LEFT JOIN product_offer_price product_offer_price ON product_offer_price.offer = product_offer.id LEFT JOIN product_offer_quantity product_offer_quantity ON product_offer_quantity.offer = product_offer.id LEFT JOIN product_category_offers category_offer ON category_offer.id = product_offer.category_offer LEFT JOIN product_variation product_offer_variation ON product_offer_variation.offer = product_offer.id   LEFT JOIN product_variation_images product_offer_variation_image ON product_offer_variation_image.variation = product_offer_variation.id AND product_offer_variation_image.root = true LEFT JOIN product_offer_images product_offer_images ON product_offer_variation_image.name IS NULL AND product_offer_images.offer = product_offer.id AND product_offer_images.root = true LEFT JOIN product_photo product_photo ON product_offer_images.name IS NULL AND product_photo.event = product_event.id AND product_photo.root = true LEFT JOIN product_category_variation category_offer_variation ON category_offer_variation.id = product_offer_variation.category_variation LEFT JOIN product_variation_price product_variation_price ON product_variation_price.variation = product_offer_variation.id LEFT JOIN product_variation_quantity product_variation_quantity ON product_variation_quantity.variation = product_offer_variation.id LEFT JOIN product_modification product_offer_modification ON product_offer_modification.variation = product_offer_variation.id   LEFT JOIN product_modification_price product_modification_price ON product_modification_price.modification = product_offer_modification.id LEFT JOIN product_modification_quantity product_modification_quantity ON product_modification_quantity.modification = product_offer_modification.id LEFT JOIN product_category_modification category_offer_modification ON category_offer_modification.id = product_offer_modification.category_modification LEFT JOIN product_modification_images product_offer_modification_image ON product_offer_modification_image.modification = product_offer_modification.id AND product_offer_modification_image.root = true LEFT JOIN product_invariable product_invariable ON 
                    product_invariable.product = product.id AND 
                    (
                        (product_offer.const IS NOT NULL AND product_invariable.offer = product_offer.const) OR 
                        (product_offer.const IS NULL AND product_invariable.offer IS NULL)
                    )
                    AND
                    (
                        (product_offer_variation.const IS NOT NULL AND product_invariable.variation = product_offer_variation.const) OR 
                        (product_offer_variation.const IS NULL AND product_invariable.variation IS NULL)
                    )
                   AND
                   (
                        (product_offer_modification.const IS NOT NULL AND product_invariable.modification = product_offer_modification.const) OR 
                        (product_offer_modification.const IS NULL AND product_invariable.modification IS NULL)
                   )
             LEFT JOIN user_profile_discount project_profile_discount ON 
                        project_profile_discount.event = project_profile.event WHERE (
            CASE
                WHEN product_modification_quantity.quantity IS NOT NULL THEN (product_modification_quantity.quantity - product_modification_quantity.reserve)
                WHEN product_variation_quantity.quantity IS NOT NULL THEN (product_variation_quantity.quantity - product_variation_quantity.reserve)
                WHEN product_offer_quantity.quantity IS NOT NULL THEN (product_offer_quantity.quantity - product_offer_quantity.reserve)
                WHEN product_price.quantity  IS NOT NULL THEN (product_price.quantity - product_price.reserve)
                ELSE 0
            END > 0
        ) AND (
 			CASE
			   WHEN product_modification_price.price IS NOT NULL AND (product_modification_price.old > product_modification_price.price) THEN product_modification_price.price
			   WHEN product_variation_price.price  IS NOT NULL AND (product_variation_price.old > product_variation_price.price) THEN product_variation_price.price
			   WHEN product_offer_price.price IS NOT NULL AND (product_offer_price.old > product_offer_price.price) THEN product_offer_price.price
			   WHEN product_price.price IS NOT NULL AND (product_price.old > product_price.price) THEN product_price.price
			   ELSE 0
			END > 0
 		) GROUP BY product_price.price, product_price.currency, product_price.quantity, product_price.reserve, product_info.article, product_info.sort, product_offer_price.price, product_offer_price.currency, product_offer_quantity.quantity, product_offer_quantity.reserve, product_variation_price.price, product_variation_price.currency, product_variation_quantity.quantity, product_variation_quantity.reserve, product_modification_price.price, product_modification_price.currency, product_modification_quantity.quantity, product_modification_quantity.reserve, product.id, product.event, product_trans.name, product_info.url, product_offer.id, product_offer.value, product_offer.postfix, category_offer.reference, product_offer_variation.id, product_offer_variation.value, product_offer_variation.postfix, category_offer_variation.reference, product_offer_modification.id, product_offer_modification.value, product_offer_modification.postfix, category_offer_modification.reference, product_offer_modification.article, product_offer_variation.article, product_offer.article, product_info.article, product_modification_price.price, product_variation_price.price, product_offer_price.price, product_price.price, product_modification_price.old, product_variation_price.old, product_offer_price.old, product_price.old, product_modification_price.currency, product_variation_price.currency, product_offer_price.currency, product_price.currency, category_info.url, category_trans.name, product_invariable.id, project_profile_discount.value ORDER BY product_info.sort DESC, product_modification_quantity.reserve DESC, product_variation_quantity.reserve DESC, product_offer_quantity.reserve DESC, product_price.reserve DESC LIMIT 16;

#	File/Call
1	Doctrine\DBAL\Connection->executeCacheQuery (line 851)
2	BaksDev\Core\Doctrine\DBALQueryBuilder->executeCacheQuery (line 479)
3	BaksDev\Core\Doctrine\DBALQueryBuilder->executeDBALQuery (line 253)
4	BaksDev\Core\Doctrine\DBALQueryBuilder->fetchAllHydrate (line 341)
5	Generator->valid (line 160)
6	BaksDev\Products\Product\Repository\Cards\ProductPromo\ProductPromoRepository->findAll (line 160)
7	BaksDev\Products\Product\Repository\Cards\ProductPromo\ProductPromoRepository->toArray (line 134)
8	Products\Product\Controller\User\PromoController->index (line 64)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

9.52 ms
(0.91%)

SELECT category.id, category.event AS event, category_event.sort AS category_sort, category_event.parent AS category_parent, category_info.url AS category_url, category_cover.ext AS category_cover_ext, category_cover.cdn AS category_cover_cdn, 
			CASE
			 WHEN category_cover.name IS NOT NULL THEN
					CONCAT ( '/upload/product_category_cover' , '/', category_cover.name)
			   		ELSE NULL
			END AS category_cover_dir
		, category_trans.name AS category_name, category_trans.description AS category_description, JSON_AGG
		( DISTINCT
			
				JSONB_BUILD_OBJECT
				(
					'0', parent_category_event.sort,
					
					'parent_category_url', parent_category_info.url,
					'parent_category_counter', parent_category_info.counter,
					
					'parent_category_cover_name', 
					CASE 
					    WHEN parent_category_cover.name IS NOT NULL 
					    THEN CONCAT ( '/upload/product_category_cover' , '/', parent_category_cover.name)
					    ELSE NULL
					END,
					
					'parent_category_cover_ext', parent_category_cover.ext,
					'parent_category_cover_cdn', parent_category_cover.cdn,
		
					'parent_category_event', parent_category_event.id,
					'parent_category_name', parent_category_trans.name
				)
		)
			AS parent_category FROM product_category category INNER JOIN product_category_event category_event ON category_event.id = category.event AND category_event.parent IS NULL LEFT JOIN product_category_event parent_category_event ON parent_category_event.parent = category.id INNER JOIN product_category_info category_info ON category_info.event = category.event AND category_info.active IS TRUE LEFT JOIN product_category_cover category_cover ON category_cover.event = category_event.id LEFT JOIN product_category_trans category_trans ON category_trans.event = category_event.id AND category_trans.local = ? LEFT JOIN product_category_info parent_category_info ON parent_category_info.event = parent_category_event.id LEFT JOIN product_category_cover parent_category_cover ON parent_category_cover.event = parent_category_event.id LEFT JOIN product_category_trans parent_category_trans ON parent_category_trans.event = parent_category_event.id  AND parent_category_trans.local = ? GROUP BY category.id, category.event, category_event.sort, category_event.parent, category_info.url, category_cover.ext, category_cover.cdn, category_cover.name, category_trans.name, category_trans.description ORDER BY category_event.sort ASC

Parameters:

[
  "ru"
  "ru"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  category.id,
  category.event AS event,
  category_event.sort AS category_sort,
  category_event.parent AS category_parent,
  category_info.url AS category_url,
  category_cover.ext AS category_cover_ext,
  category_cover.cdn AS category_cover_cdn,
  CASE WHEN category_cover.name IS NOT NULL THEN
    CONCAT (
      '/upload/product_category_cover',
      '/', category_cover.name
    )
  ELSE
    NULL
  END AS category_cover_dir,
  category_trans.name AS category_name,
  category_trans.description AS category_description,
  JSON_AGG (
    DISTINCT JSONB_BUILD_OBJECT (
      '0',
      parent_category_event.sort,
      'parent_category_url',
      parent_category_info.url,
      'parent_category_counter',
      parent_category_info.counter,
      'parent_category_cover_name',
      CASE WHEN parent_category_cover.name IS NOT NULL THEN
        CONCAT (
          '/upload/product_category_cover',
          '/', parent_category_cover.name
        )
      ELSE
        NULL
      END,
      'parent_category_cover_ext',
      parent_category_cover.ext,
      'parent_category_cover_cdn',
      parent_category_cover.cdn,
      'parent_category_event',
      parent_category_event.id,
      'parent_category_name',
      parent_category_trans.name
    )
  ) AS parent_category
FROM
  product_category category
  INNER JOIN product_category_event category_event ON category_event.id = category.event
  AND category_event.parent IS NULL
  LEFT JOIN product_category_event parent_category_event ON parent_category_event.parent = category.id
  INNER JOIN product_category_info category_info ON category_info.event = category.event
  AND category_info.active IS TRUE
  LEFT JOIN product_category_cover category_cover ON category_cover.event = category_event.id
  LEFT JOIN product_category_trans category_trans ON category_trans.event = category_event.id
  AND category_trans.local = ?
  LEFT JOIN product_category_info parent_category_info ON parent_category_info.event = parent_category_event.id
  LEFT JOIN product_category_cover parent_category_cover ON parent_category_cover.event = parent_category_event.id
  LEFT JOIN product_category_trans parent_category_trans ON parent_category_trans.event = parent_category_event.id
  AND parent_category_trans.local = ?
GROUP BY
  category.id,
  category.event,
  category_event.sort,
  category_event.parent,
  category_info.url,
  category_cover.ext,
  category_cover.cdn,
  category_cover.name,
  category_trans.name,
  category_trans.description
ORDER BY
  category_event.sort ASC

SELECT category.id, category.event AS event, category_event.sort AS category_sort, category_event.parent AS category_parent, category_info.url AS category_url, category_cover.ext AS category_cover_ext, category_cover.cdn AS category_cover_cdn, 
			CASE
			 WHEN category_cover.name IS NOT NULL THEN
					CONCAT ( '/upload/product_category_cover' , '/', category_cover.name)
			   		ELSE NULL
			END AS category_cover_dir
		, category_trans.name AS category_name, category_trans.description AS category_description, JSON_AGG
		( DISTINCT
			
				JSONB_BUILD_OBJECT
				(
					'0', parent_category_event.sort,
					
					'parent_category_url', parent_category_info.url,
					'parent_category_counter', parent_category_info.counter,
					
					'parent_category_cover_name', 
					CASE 
					    WHEN parent_category_cover.name IS NOT NULL 
					    THEN CONCAT ( '/upload/product_category_cover' , '/', parent_category_cover.name)
					    ELSE NULL
					END,
					
					'parent_category_cover_ext', parent_category_cover.ext,
					'parent_category_cover_cdn', parent_category_cover.cdn,
		
					'parent_category_event', parent_category_event.id,
					'parent_category_name', parent_category_trans.name
				)
		)
			AS parent_category FROM product_category category INNER JOIN product_category_event category_event ON category_event.id = category.event AND category_event.parent IS NULL LEFT JOIN product_category_event parent_category_event ON parent_category_event.parent = category.id INNER JOIN product_category_info category_info ON category_info.event = category.event AND category_info.active IS TRUE LEFT JOIN product_category_cover category_cover ON category_cover.event = category_event.id LEFT JOIN product_category_trans category_trans ON category_trans.event = category_event.id AND category_trans.local = 'ru' LEFT JOIN product_category_info parent_category_info ON parent_category_info.event = parent_category_event.id LEFT JOIN product_category_cover parent_category_cover ON parent_category_cover.event = parent_category_event.id LEFT JOIN product_category_trans parent_category_trans ON parent_category_trans.event = parent_category_event.id  AND parent_category_trans.local = 'ru' GROUP BY category.id, category.event, category_event.sort, category_event.parent, category_info.url, category_cover.ext, category_cover.cdn, category_cover.name, category_trans.name, category_trans.description ORDER BY category_event.sort ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeCacheQuery (line 851)
2	BaksDev\Core\Doctrine\DBALQueryBuilder->executeCacheQuery (line 479)
3	BaksDev\Core\Doctrine\DBALQueryBuilder->executeDBALQuery (line 253)
4	BaksDev\Core\Doctrine\DBALQueryBuilder->fetchAllAssociativeIndexed (line 371)
5	BaksDev\Products\Category\Repository\AllCategoryByMenu\AllCategoryByMenuRepository->findAll (line 189)
6	BaksDev\Products\Category\Listeners\Event\CatalogMenuListener->onKernelController (line 59)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

4.87 ms
(0.46%)

SELECT profile_personal.username AS title, NULL AS keywords, profile_personal.location AS description, user_profile_region.value AS region FROM users_profile profile LEFT JOIN users_profile_personal profile_personal ON profile_personal.event = profile.event LEFT JOIN user_profile_region user_profile_region ON user_profile_region.event = profile.event WHERE profile.id = ?

Parameters:

[
  "01982ecf-0a6a-79e5-967b-4992d1b836bb"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  profile_personal.username AS title,
  NULL AS keywords,
  profile_personal.location AS description,
  user_profile_region.value AS region
FROM
  users_profile profile
  LEFT JOIN users_profile_personal profile_personal ON profile_personal.event = profile.event
  LEFT JOIN user_profile_region user_profile_region ON user_profile_region.event = profile.event
WHERE
  profile.id = ?

SELECT profile_personal.username AS title, NULL AS keywords, profile_personal.location AS description, user_profile_region.value AS region FROM users_profile profile LEFT JOIN users_profile_personal profile_personal ON profile_personal.event = profile.event LEFT JOIN user_profile_region user_profile_region ON user_profile_region.event = profile.event WHERE profile.id = '01982ecf-0a6a-79e5-967b-4992d1b836bb';

#	File/Call
1	Doctrine\DBAL\Connection->executeCacheQuery (line 851)
2	BaksDev\Core\Doctrine\DBALQueryBuilder->executeCacheQuery (line 479)
3	BaksDev\Core\Doctrine\DBALQueryBuilder->executeDBALQuery (line 253)
4	BaksDev\Core\Doctrine\DBALQueryBuilder->fetchAssociative (line 364)
5	BaksDev\Settings\Main\Repository\SettingsMain\SettingsMainRepository->getSettingsMainAssociative (line 98)
6	BaksDev\Settings\Main\Listeners\Event\SettingsHeadersListeners->onKernelRequest (line 55)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

3.85 ms
(0.37%)

WITH RECURSIVE recursive_table AS (SELECT category.id, category.event, category_event.sort, category_event.parent, category_info.url AS category_url, category_trans.name AS category_name, CONCAT ('/upload/product_category_cover' , '/', category_cover.name) AS category_cover_image, category_cover.cdn AS category_cover_cdn, category_cover.ext AS category_cover_ext, category_event.id::varchar AS groups, 1 AS level FROM product_category category INNER JOIN product_category_event category_event ON category_event.id = category.event LEFT JOIN product_category_trans category_trans ON category_trans.event = category.event AND category_trans.local = ? LEFT JOIN product_category_cover category_cover ON category_cover.event = category.event INNER JOIN product_category_info category_info ON 
                    category_info.event = category.event AND 
                    category_info.active IS TRUE WHERE category_event.parent IS NULL UNION SELECT category.id, category.event, category_event.sort, category_event.parent, category_info.url AS category_url, category_trans.name AS category_name, CONCAT ('/upload/product_category_cover' , '/', category_cover.name) AS category_cover_image, category_cover.cdn AS category_cover_cdn, category_cover.ext AS category_cover_ext,  CONCAT(groups, ':',  category_event.id::varchar) AS groups , level+1 AS level FROM product_category category INNER JOIN product_category_event category_event ON category_event.id = category.event LEFT JOIN product_category_trans category_trans ON category_trans.event = category.event AND category_trans.local = ? LEFT JOIN product_category_cover category_cover ON category_cover.event = category.event INNER JOIN product_category_info category_info ON 
                    category_info.event = category.event AND 
                    category_info.active IS TRUE INNER JOIN recursive_table  ON recursive_table.id = category_event.parent) SELECT * FROM recursive_table ORDER BY 
                    recursive_table.groups,
                    recursive_table.sort

Parameters:

[
  "ru"
  "ru"
]

View formatted query View runnable query Explain query View query backtrace

WITH
  RECURSIVE recursive_table AS (
    SELECT
      category.id,
      category.event,
      category_event.sort,
      category_event.parent,
      category_info.url AS category_url,
      category_trans.name AS category_name,
      CONCAT (
        '/upload/product_category_cover',
        '/', category_cover.name
      ) AS category_cover_image,
      category_cover.cdn AS category_cover_cdn,
      category_cover.ext AS category_cover_ext,
      category_event.id :: varchar AS
    groups
      ,
      1 AS level
    FROM
      product_category category
      INNER JOIN product_category_event category_event ON category_event.id = category.event
      LEFT JOIN product_category_trans category_trans ON category_trans.event = category.event
      AND category_trans.local = ?
      LEFT JOIN product_category_cover category_cover ON category_cover.event = category.event
      INNER JOIN product_category_info category_info ON category_info.event = category.event
      AND category_info.active IS TRUE
    WHERE
      category_event.parent IS NULL
    UNION
    SELECT
      category.id,
      category.event,
      category_event.sort,
      category_event.parent,
      category_info.url AS category_url,
      category_trans.name AS category_name,
      CONCAT (
        '/upload/product_category_cover',
        '/', category_cover.name
      ) AS category_cover_image,
      category_cover.cdn AS category_cover_cdn,
      category_cover.ext AS category_cover_ext,
      CONCAT(
        groups
          ,
          ':',
          category_event.id :: varchar
      ) AS
    groups
      ,
      level + 1 AS level
    FROM
      product_category category
      INNER JOIN product_category_event category_event ON category_event.id = category.event
      LEFT JOIN product_category_trans category_trans ON category_trans.event = category.event
      AND category_trans.local = ?
      LEFT JOIN product_category_cover category_cover ON category_cover.event = category.event
      INNER JOIN product_category_info category_info ON category_info.event = category.event
      AND category_info.active IS TRUE
      INNER JOIN recursive_table ON recursive_table.id = category_event.parent
  )
SELECT
  *
FROM
  recursive_table
ORDER BY
  recursive_table.groups,
  recursive_table.sort

WITH RECURSIVE recursive_table AS (SELECT category.id, category.event, category_event.sort, category_event.parent, category_info.url AS category_url, category_trans.name AS category_name, CONCAT ('/upload/product_category_cover' , '/', category_cover.name) AS category_cover_image, category_cover.cdn AS category_cover_cdn, category_cover.ext AS category_cover_ext, category_event.id::varchar AS groups, 1 AS level FROM product_category category INNER JOIN product_category_event category_event ON category_event.id = category.event LEFT JOIN product_category_trans category_trans ON category_trans.event = category.event AND category_trans.local = 'ru' LEFT JOIN product_category_cover category_cover ON category_cover.event = category.event INNER JOIN product_category_info category_info ON 
                    category_info.event = category.event AND 
                    category_info.active IS TRUE WHERE category_event.parent IS NULL UNION SELECT category.id, category.event, category_event.sort, category_event.parent, category_info.url AS category_url, category_trans.name AS category_name, CONCAT ('/upload/product_category_cover' , '/', category_cover.name) AS category_cover_image, category_cover.cdn AS category_cover_cdn, category_cover.ext AS category_cover_ext,  CONCAT(groups, ':',  category_event.id::varchar) AS groups , level+1 AS level FROM product_category category INNER JOIN product_category_event category_event ON category_event.id = category.event LEFT JOIN product_category_trans category_trans ON category_trans.event = category.event AND category_trans.local = 'ru' LEFT JOIN product_category_cover category_cover ON category_cover.event = category.event INNER JOIN product_category_info category_info ON 
                    category_info.event = category.event AND 
                    category_info.active IS TRUE INNER JOIN recursive_table  ON recursive_table.id = category_event.parent) SELECT * FROM recursive_table ORDER BY 
                    recursive_table.groups,
                    recursive_table.sort     
        ;

#	File/Call
1	Doctrine\DBAL\Connection->executeCacheQuery (line 851)
2	BaksDev\Core\Doctrine\DBALQueryBuilder->executeCacheQuery (line 479)
3	BaksDev\Core\Doctrine\DBALQueryBuilder->findAllRecursive (line 621)
4	BaksDev\Products\Category\Repository\MenuPublicCategory\MenuPublicCategoryRepository->findAll (line 120)
5	BaksDev\Products\Category\Listeners\Event\PublicCatalogMenuListener->onKernelController (line 54)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

2.18 ms
(0.21%)

SELECT NULL AS icon, NULL AS title, profile_value.value AS phone FROM users_profile profile LEFT JOIN users_profile_value profile_value ON profile_value.event = profile.event INNER JOIN type_users_profile_section_field type_section_field ON 
                        type_section_field.id = profile_value.field AND
                        type_section_field.type = ?
                     WHERE profile.id = ?

Parameters:

[
  "phone_field"
  "01982ecf-0a6a-79e5-967b-4992d1b836bb"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  NULL AS icon,
  NULL AS title,
  profile_value.value AS phone
FROM
  users_profile profile
  LEFT JOIN users_profile_value profile_value ON profile_value.event = profile.event
  INNER JOIN type_users_profile_section_field type_section_field ON type_section_field.id = profile_value.field
  AND type_section_field.type = ?
WHERE
  profile.id = ?

SELECT NULL AS icon, NULL AS title, profile_value.value AS phone FROM users_profile profile LEFT JOIN users_profile_value profile_value ON profile_value.event = profile.event INNER JOIN type_users_profile_section_field type_section_field ON 
                        type_section_field.id = profile_value.field AND
                        type_section_field.type = 'phone_field'
                     WHERE profile.id = '01982ecf-0a6a-79e5-967b-4992d1b836bb';

#	File/Call
1	Doctrine\DBAL\Connection->executeCacheQuery (line 851)
2	BaksDev\Core\Doctrine\DBALQueryBuilder->executeCacheQuery (line 479)
3	BaksDev\Core\Doctrine\DBALQueryBuilder->executeDBALQuery (line 253)
4	BaksDev\Core\Doctrine\DBALQueryBuilder->fetchAllAssociative (line 315)
5	BaksDev\Settings\Main\Repository\SettingsMain\SettingsMainRepository->getPhone (line 183)
6	BaksDev\Settings\Main\Listeners\Event\SettingsHeadersListeners->onKernelRequest (line 62)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

1.73 ms
(0.16%)

INSERT INTO messenger_core (body, headers, queue_name, created_at, available_at) VALUES(?, ?, ?, ?, ?) RETURNING id

Parameters:

[
  "O:36:\"Symfony\\Component\\Messenger\\Envelope\":2:{s:44:\"\0Symfony\\Component\\Messenger\\Envelope\0stamps\";a:2:{s:53:\"Symfony\\Component\\Messenger\\Stamp\\TransportNamesStamp\";a:1:{i:0;O:53:\"Symfony\\Component\\Messenger\\Stamp\\TransportNamesStamp\":1:{s:69:\"\0Symfony\\Component\\Messenger\\Stamp\\TransportNamesStamp\0transportNames\";a:1:{i:0;s:9:\"async-low\";}}}s:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\";a:1:{i:0;O:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\":1:{s:55:\"\0Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\0busName\";s:21:\"messenger.bus.default\";}}}s:45:\"\0Symfony\\Component\\Messenger\\Envelope\0message\";O:54:\"BaksDev\\Core\\Doctrine\\DBAL\\Cache\\DBALCacheResetMessage\":2:{s:65:\"\0BaksDev\\Core\\Doctrine\\DBAL\\Cache\\DBALCacheResetMessage\0namespace\";s:16:\"products-product\";s:59:\"\0BaksDev\\Core\\Doctrine\\DBAL\\Cache\\DBALCacheResetMessage\0key\";s:40:\"249d29f1922cb56fea09dbfb49b355dfd083bce5\";}}"
  "[]"
  "low"
  "2026-02-21 14:19:52"
  "2026-02-21 14:19:52"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO messenger_core (
  body, headers, queue_name, created_at,
  available_at
)
VALUES
  (?, ?, ?, ?, ?) RETURNING id

INSERT INTO messenger_core (body, headers, queue_name, created_at, available_at) VALUES('O:36:\\\"Symfony\\\\Component\\\\Messenger\\\\Envelope\\\":2:{s:44:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0stamps\\\";a:2:{s:53:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\TransportNamesStamp\\\";a:1:{i:0;O:53:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\TransportNamesStamp\\\":1:{s:69:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\TransportNamesStamp\\0transportNames\\\";a:1:{i:0;s:9:\\\"async-low\\\";}}}s:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\";a:1:{i:0;O:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\":1:{s:55:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\0busName\\\";s:21:\\\"messenger.bus.default\\\";}}}s:45:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0message\\\";O:54:\\\"BaksDev\\\\Core\\\\Doctrine\\\\DBAL\\\\Cache\\\\DBALCacheResetMessage\\\":2:{s:65:\\\"\\0BaksDev\\\\Core\\\\Doctrine\\\\DBAL\\\\Cache\\\\DBALCacheResetMessage\\0namespace\\\";s:16:\\\"products-product\\\";s:59:\\\"\\0BaksDev\\\\Core\\\\Doctrine\\\\DBAL\\\\Cache\\\\DBALCacheResetMessage\\0key\\\";s:40:\\\"249d29f1922cb56fea09dbfb49b355dfd083bce5\\\";}}', '[]', 'low', '2026-02-21 14:19:52', '2026-02-21 14:19:52') RETURNING id;

#	File/Call
1	Doctrine\DBAL\Connection->fetchFirstColumn (line 670)
2	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->executeInsert (line 461)
3	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->send (line 145)
4	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineSender->send (line 46)
5	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineTransport->send (line 76)
6	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 65)
7	BaksDev\Core\Messenger\MessageHandleMiddleware->handle (line 96)
8	Symfony\Component\Messenger\Middleware\DeduplicateMiddleware->handle (line 28)
9	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
10	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
11	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
12	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 35)
13	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 36)
14	Symfony\Component\Messenger\MessageBus->dispatch (line 69)
15	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 42)
16	BaksDev\Core\Messenger\MessageDispatch->dispatch (line 122)
17	BaksDev\Core\Doctrine\DBALQueryBuilder->executeDBALQuery (line 247)
18	BaksDev\Core\Doctrine\DBALQueryBuilder->fetchAllHydrate (line 341)
19	Generator->valid (line 160)
20	BaksDev\Products\Product\Repository\Cards\ProductPromo\ProductPromoRepository->findAll (line 160)
21	BaksDev\Products\Product\Repository\Cards\ProductPromo\ProductPromoRepository->toArray (line 134)
22	Products\Product\Controller\User\PromoController->index (line 64)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

1.57 ms
(0.15%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->executeInsert (line 482)
2	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->send (line 145)
3	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineSender->send (line 46)
4	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineTransport->send (line 76)
5	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 65)
6	BaksDev\Core\Messenger\MessageHandleMiddleware->handle (line 96)
7	Symfony\Component\Messenger\Middleware\DeduplicateMiddleware->handle (line 28)
8	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
9	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
10	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
11	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 35)
12	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 36)
13	Symfony\Component\Messenger\MessageBus->dispatch (line 69)
14	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 42)
15	BaksDev\Core\Messenger\MessageDispatch->dispatch (line 122)
16	BaksDev\Core\Doctrine\DBALQueryBuilder->executeDBALQuery (line 247)
17	BaksDev\Core\Doctrine\DBALQueryBuilder->fetchAllHydrate (line 341)
18	Generator->valid (line 160)
19	BaksDev\Products\Product\Repository\Cards\ProductPromo\ProductPromoRepository->findAll (line 160)
20	BaksDev\Products\Product\Repository\Cards\ProductPromo\ProductPromoRepository->toArray (line 134)
21	Products\Product\Controller\User\PromoController->index (line 64)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 193)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	require_once (line 5)

0.41 ms
(0.04%)

SELECT pg_notify(?, ?)

Parameters:

[
  "messenger_core"
  "low"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  pg_notify(?, ?)

SELECT pg_notify('messenger_core', 'low');

#	File/Call
1	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->executeInsert (line 465)
2	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->send (line 145)
3	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineSender->send (line 46)
4	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineTransport->send (line 76)
5	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 65)
6	BaksDev\Core\Messenger\MessageHandleMiddleware->handle (line 96)
7	Symfony\Component\Messenger\Middleware\DeduplicateMiddleware->handle (line 28)
8	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
9	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
10	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
11	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 35)
12	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 36)
13	Symfony\Component\Messenger\MessageBus->dispatch (line 69)
14	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 42)
15	BaksDev\Core\Messenger\MessageDispatch->dispatch (line 122)
16	BaksDev\Core\Doctrine\DBALQueryBuilder->executeDBALQuery (line 247)
17	BaksDev\Core\Doctrine\DBALQueryBuilder->fetchAllHydrate (line 341)
18	Generator->valid (line 160)
19	BaksDev\Products\Product\Repository\Cards\ProductPromo\ProductPromoRepository->findAll (line 160)
20	BaksDev\Products\Product\Repository\Cards\ProductPromo\ProductPromoRepository->toArray (line 134)
21	Products\Product\Controller\User\PromoController->index (line 64)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 193)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	require_once (line 5)

0.37 ms
(0.04%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->executeInsert (line 457)
2	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->send (line 145)
3	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineSender->send (line 46)
4	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineTransport->send (line 76)
5	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 65)
6	BaksDev\Core\Messenger\MessageHandleMiddleware->handle (line 96)
7	Symfony\Component\Messenger\Middleware\DeduplicateMiddleware->handle (line 28)
8	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
9	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
10	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
11	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 35)
12	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 36)
13	Symfony\Component\Messenger\MessageBus->dispatch (line 69)
14	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 42)
15	BaksDev\Core\Messenger\MessageDispatch->dispatch (line 122)
16	BaksDev\Core\Doctrine\DBALQueryBuilder->executeDBALQuery (line 247)
17	BaksDev\Core\Doctrine\DBALQueryBuilder->fetchAllHydrate (line 341)
18	Generator->valid (line 160)
19	BaksDev\Products\Product\Repository\Cards\ProductPromo\ProductPromoRepository->findAll (line 160)
20	BaksDev\Products\Product\Repository\Cards\ProductPromo\ProductPromoRepository->toArray (line 134)
21	Products\Product\Controller\User\PromoController->index (line 64)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 193)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	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://dvz.all.baks.dev/promo

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping