Symfony Profiler

Query Metrics

40 Database Queries

10 Different statements

2215.01 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1976.85 ms
(89.25%)

SELECT product.id AS product_id, product.event AS product_event, product_info.url AS product_url, product_trans.name AS product_name, product_active.active_from, 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
                        )
                    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 INNER JOIN product_categories_product product_event_category ON 
                product_event_category.event = product.event AND 
                product_event_category.category = ? 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_info product_info ON product_info.product = product.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_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_price.price  IS NOT NULL THEN product_modification_price.price
			   WHEN product_variation_price.price  IS NOT NULL THEN product_variation_price.price
			   WHEN product_offer_price.price IS NOT NULL THEN product_offer_price.price
			   WHEN product_price.price IS NOT NULL THEN product_price.price
			   ELSE 0
			END > 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_info.article, product_info.sort, product_price.price, product_price.currency, product_price.quantity, product_price.reserve, 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_info.url, product_trans.name, product_active.active_from, 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 4

Parameters:

[
  "01876af0-ddfc-70c3-ab25-5f85f55a9907"
  "019469c3-700f-76a9-9b34-ccde7b4e6f49"
  "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_info.url AS product_url,
  product_trans.name AS product_name,
  product_active.active_from,
  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
      )
    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
  INNER JOIN product_categories_product product_event_category ON product_event_category.event = product.event
  AND product_event_category.category = ?
  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_info product_info ON product_info.product = product.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_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_price.price IS NOT NULL THEN
      product_modification_price.price
    WHEN product_variation_price.price IS NOT NULL THEN
      product_variation_price.price
    WHEN product_offer_price.price IS NOT NULL THEN
      product_offer_price.price
    WHEN product_price.price IS NOT NULL THEN
      product_price.price
    ELSE
      0
    END > 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_info.article,
  product_info.sort,
  product_price.price,
  product_price.currency,
  product_price.quantity,
  product_price.reserve,
  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_info.url,
  product_trans.name,
  product_active.active_from,
  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
  4

SELECT product.id AS product_id, product.event AS product_event, product_info.url AS product_url, product_trans.name AS product_name, product_active.active_from, 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
                        )
                    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 INNER JOIN product_categories_product product_event_category ON 
                product_event_category.event = product.event AND 
                product_event_category.category = '01876af0-ddfc-70c3-ab25-5f85f55a9907' 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 = '019469c3-700f-76a9-9b34-ccde7b4e6f49' LEFT JOIN product_info product_info ON product_info.product = product.id 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_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_price.price  IS NOT NULL THEN product_modification_price.price
			   WHEN product_variation_price.price  IS NOT NULL THEN product_variation_price.price
			   WHEN product_offer_price.price IS NOT NULL THEN product_offer_price.price
			   WHEN product_price.price IS NOT NULL THEN product_price.price
			   ELSE 0
			END > 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_info.article, product_info.sort, product_price.price, product_price.currency, product_price.quantity, product_price.reserve, 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_info.url, product_trans.name, product_active.active_from, 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 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeCacheQuery (line 851)
2	BaksDev\Core\Doctrine\DBALQueryBuilder->executeCacheQuery (line 475)
3	BaksDev\Core\Doctrine\DBALQueryBuilder->executeDBALQuery (line 227)
4	BaksDev\Core\Doctrine\DBALQueryBuilder->fetchAllHydrate (line 337)
5	Generator->valid (line 158)
6	BaksDev\Products\Product\Repository\Cards\ProductCatalog\ProductCatalogRepository->findAll (line 158)
7	BaksDev\Products\Product\Repository\Cards\ProductCatalog\ProductCatalogRepository->toArray (line 168)
8	BaksDev\Products\Product\Controller\Public\CatalogController->index (line 144)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

184.57 ms
(8.33%)

SELECT product_trans.name AS product_name, product_info.url, product_info.sort, category_info.url AS category_url FROM product LEFT JOIN product_trans product_trans ON product_trans.event = product.event AND product_trans.local = ? LEFT JOIN product_price product_price ON product_price.event = product.event LEFT JOIN product_info product_info ON product_info.product = product.id INNER JOIN product_active product_active ON 
                    product_active.event = product.event AND 
                    product_active.active IS TRUE 
                 LEFT JOIN product_offer product_offer ON product_offer.event = product.event INNER JOIN product_categories_product product_event_category ON 
                    product_event_category.event = product.event AND 
                    product_event_category.category = ? AND 
                    product_event_category.root = true LEFT JOIN product_offer_quantity product_offer_quantity ON product_offer_quantity.offer = product_offer.id LEFT JOIN product_offer_price product_offer_price ON product_offer_price.offer = product_offer.id LEFT JOIN product_variation product_offer_variation ON product_offer_variation.id = (SELECT tmp_product_offer_variation.id FROM product_variation tmp_product_offer_variation WHERE tmp_product_offer_variation.offer = product_offer.id ORDER BY tmp_product_offer_variation.id DESC LIMIT 1) LEFT JOIN product_variation_quantity product_variation_quantity ON product_variation_quantity.variation = product_offer_variation.id LEFT JOIN product_variation_price product_variation_price ON product_variation_price.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_quantity product_modification_quantity ON product_modification_quantity.modification = product_offer_modification.id LEFT JOIN product_modification_price product_modification_price ON product_modification_price.modification = product_offer_modification.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
                 WHERE (
 			CASE
			   WHEN product_modification_price.price IS NOT NULL THEN product_modification_price.price
			   WHEN product_variation_price.price  IS NOT NULL THEN product_variation_price.price
			   WHEN product_offer_price.price IS NOT NULL THEN product_offer_price.price
			   WHEN product_price.price IS NOT NULL THEN product_price.price
			   ELSE 0
			END > 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_trans.name, product_info.url, product_info.sort, category_info.url 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 LIMIT 10

Parameters:

[
  "ru"
  "01876af0-ddfc-70c3-ab25-5f85f55a9907"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  product_trans.name AS product_name,
  product_info.url,
  product_info.sort,
  category_info.url AS category_url
FROM
  product
  LEFT JOIN product_trans product_trans ON product_trans.event = product.event
  AND product_trans.local = ?
  LEFT JOIN product_price product_price ON product_price.event = product.event
  LEFT JOIN product_info product_info ON product_info.product = product.id
  INNER JOIN product_active product_active ON product_active.event = product.event
  AND product_active.active IS TRUE
  LEFT JOIN product_offer product_offer ON product_offer.event = product.event
  INNER JOIN product_categories_product product_event_category ON product_event_category.event = product.event
  AND product_event_category.category = ?
  AND product_event_category.root = true
  LEFT JOIN product_offer_quantity product_offer_quantity ON product_offer_quantity.offer = product_offer.id
  LEFT JOIN product_offer_price product_offer_price ON product_offer_price.offer = product_offer.id
  LEFT JOIN product_variation product_offer_variation ON product_offer_variation.id = (
    SELECT
      tmp_product_offer_variation.id
    FROM
      product_variation tmp_product_offer_variation
    WHERE
      tmp_product_offer_variation.offer = product_offer.id
    ORDER BY
      tmp_product_offer_variation.id DESC
    LIMIT
      1
  ) LEFT JOIN product_variation_quantity product_variation_quantity ON product_variation_quantity.variation = product_offer_variation.id
  LEFT JOIN product_variation_price product_variation_price ON product_variation_price.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_quantity product_modification_quantity ON product_modification_quantity.modification = product_offer_modification.id
  LEFT JOIN product_modification_price product_modification_price ON product_modification_price.modification = product_offer_modification.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
WHERE
  (
    CASE WHEN product_modification_price.price IS NOT NULL THEN
      product_modification_price.price
    WHEN product_variation_price.price IS NOT NULL THEN
      product_variation_price.price
    WHEN product_offer_price.price IS NOT NULL THEN
      product_offer_price.price
    WHEN product_price.price IS NOT NULL THEN
      product_price.price
    ELSE
      0
    END > 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_trans.name,
  product_info.url,
  product_info.sort,
  category_info.url
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
LIMIT
  10

SELECT product_trans.name AS product_name, product_info.url, product_info.sort, category_info.url AS category_url FROM product LEFT JOIN product_trans product_trans ON product_trans.event = product.event AND product_trans.local = 'ru' LEFT JOIN product_price product_price ON product_price.event = product.event LEFT JOIN product_info product_info ON product_info.product = product.id INNER JOIN product_active product_active ON 
                    product_active.event = product.event AND 
                    product_active.active IS TRUE 
                 LEFT JOIN product_offer product_offer ON product_offer.event = product.event INNER JOIN product_categories_product product_event_category ON 
                    product_event_category.event = product.event AND 
                    product_event_category.category = '01876af0-ddfc-70c3-ab25-5f85f55a9907' AND 
                    product_event_category.root = true LEFT JOIN product_offer_quantity product_offer_quantity ON product_offer_quantity.offer = product_offer.id LEFT JOIN product_offer_price product_offer_price ON product_offer_price.offer = product_offer.id LEFT JOIN product_variation product_offer_variation ON product_offer_variation.id = (SELECT tmp_product_offer_variation.id FROM product_variation tmp_product_offer_variation WHERE tmp_product_offer_variation.offer = product_offer.id ORDER BY tmp_product_offer_variation.id DESC LIMIT 1) LEFT JOIN product_variation_quantity product_variation_quantity ON product_variation_quantity.variation = product_offer_variation.id LEFT JOIN product_variation_price product_variation_price ON product_variation_price.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_quantity product_modification_quantity ON product_modification_quantity.modification = product_offer_modification.id LEFT JOIN product_modification_price product_modification_price ON product_modification_price.modification = product_offer_modification.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
                 WHERE (
 			CASE
			   WHEN product_modification_price.price IS NOT NULL THEN product_modification_price.price
			   WHEN product_variation_price.price  IS NOT NULL THEN product_variation_price.price
			   WHEN product_offer_price.price IS NOT NULL THEN product_offer_price.price
			   WHEN product_price.price IS NOT NULL THEN product_price.price
			   ELSE 0
			END > 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_trans.name, product_info.url, product_info.sort, category_info.url 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 LIMIT 10;

#	File/Call
1	Doctrine\DBAL\Connection->executeCacheQuery (line 851)
2	BaksDev\Core\Doctrine\DBALQueryBuilder->executeCacheQuery (line 475)
3	BaksDev\Core\Doctrine\DBALQueryBuilder->executeDBALQuery (line 227)
4	BaksDev\Core\Doctrine\DBALQueryBuilder->fetchAllAssociative (line 311)
5	BaksDev\Products\Product\Repository\LiederCategory\ProductLiederRepository->find (line 297)
6	BaksDev\Products\Product\Controller\Public\CatalogController->index (line 150)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

12.05 ms
(0.54%)

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 475)
3	BaksDev\Core\Doctrine\DBALQueryBuilder->findAllRecursive (line 617)
4	BaksDev\Products\Category\Repository\AllCategory\AllCategoryRepository->getRecursive (line 225)
5	BaksDev\Products\Category\Repository\AllCategory\AllCategoryRepository->getOnlyChildren (line 231)
6	BaksDev\Products\Product\Controller\Public\CatalogController->index (line 129)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

7.34 ms
(0.33%)

SELECT DISTINCT 
                CASE
                    WHEN category_offers.reference = ?
                    THEN offer.value  
                         
                    WHEN category_variation.reference = ?
                    THEN variation.value  
                         
                    WHEN category_modification.reference = ?
                    THEN modification.value
                     
                    ELSE NULL 
                END AS value
		 FROM product LEFT JOIN product_offer offer ON offer.event = product.event LEFT JOIN product_variation variation ON variation.offer = offer.id LEFT JOIN product_category_offers category_offers ON category_offers.id = offer.category_offer LEFT JOIN product_modification modification ON modification.variation = variation.id LEFT JOIN product_category_variation category_variation ON category_variation.id = variation.category_variation LEFT JOIN product_category_modification category_modification ON category_modification.id = modification.category_modification WHERE 
                            (category_offers.reference = ? AND offer.value IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) OR
                            (category_variation.reference = ? AND variation.value IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) OR
                            (category_modification.reference = ? AND modification.value IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
                         ORDER BY value

Parameters:

[
  "tire_radius_field"
  "tire_radius_field"
  "tire_radius_field"
  "tire_radius_field"
  "12"
  "12C"
  "13"
  "13C"
  "14"
  "14C"
  "15"
  "15C"
  "16"
  "16C"
  "17"
  "17C"
  "18"
  "18C"
  "19"
  "19C"
  "20"
  "20C"
  "21"
  "21C"
  "22"
  "22C"
  "23"
  "23C"
  "24"
  "24C"
  "tire_radius_field"
  "12"
  "12C"
  "13"
  "13C"
  "14"
  "14C"
  "15"
  "15C"
  "16"
  "16C"
  "17"
  "17C"
  "18"
  "18C"
  "19"
  "19C"
  "20"
  "20C"
  "21"
  "21C"
  "22"
  "22C"
  "23"
  "23C"
  "24"
  "24C"
  "tire_radius_field"
  "12"
  "12C"
  "13"
  "13C"
  "14"
  "14C"
  "15"
  "15C"
  "16"
  "16C"
  "17"
  "17C"
  "18"
  "18C"
  "19"
  "19C"
  "20"
  "20C"
  "21"
  "21C"
  "22"
  "22C"
  "23"
  "23C"
  "24"
  "24C"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT CASE WHEN category_offers.reference = ? THEN
    offer.value
  WHEN category_variation.reference = ? THEN
    variation.value
  WHEN category_modification.reference = ? THEN
    modification.value
  ELSE
    NULL
  END AS value
FROM
  product
  LEFT JOIN product_offer offer ON offer.event = product.event
  LEFT JOIN product_variation variation ON variation.offer = offer.id
  LEFT JOIN product_category_offers category_offers ON category_offers.id = offer.category_offer
  LEFT JOIN product_modification modification ON modification.variation = variation.id
  LEFT JOIN product_category_variation category_variation ON category_variation.id = variation.category_variation
  LEFT JOIN product_category_modification category_modification ON category_modification.id = modification.category_modification
WHERE
  (
    category_offers.reference = ?
    AND offer.value IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
    )
  )
  OR (
    category_variation.reference = ?
    AND variation.value IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
    )
  )
  OR (
    category_modification.reference = ?
    AND modification.value IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
    )
  )
ORDER BY
  value

SELECT DISTINCT 
                CASE
                    WHEN category_offers.reference = 'tire_radius_field'
                    THEN offer.value  
                         
                    WHEN category_variation.reference = 'tire_radius_field'
                    THEN variation.value  
                         
                    WHEN category_modification.reference = 'tire_radius_field'
                    THEN modification.value
                     
                    ELSE NULL 
                END AS value
		 FROM product LEFT JOIN product_offer offer ON offer.event = product.event LEFT JOIN product_variation variation ON variation.offer = offer.id LEFT JOIN product_category_offers category_offers ON category_offers.id = offer.category_offer LEFT JOIN product_modification modification ON modification.variation = variation.id LEFT JOIN product_category_variation category_variation ON category_variation.id = variation.category_variation LEFT JOIN product_category_modification category_modification ON category_modification.id = modification.category_modification WHERE 
                            (category_offers.reference = 'tire_radius_field' AND offer.value IN ('12', '12C', '13', '13C', '14', '14C', '15', '15C', '16', '16C', '17', '17C', '18', '18C', '19', '19C', '20', '20C', '21', '21C', '22', '22C', '23', '23C', '24', '24C')) OR
                            (category_variation.reference = 'tire_radius_field' AND variation.value IN ('12', '12C', '13', '13C', '14', '14C', '15', '15C', '16', '16C', '17', '17C', '18', '18C', '19', '19C', '20', '20C', '21', '21C', '22', '22C', '23', '23C', '24', '24C')) OR
                            (category_modification.reference = 'tire_radius_field' AND modification.value IN ('12', '12C', '13', '13C', '14', '14C', '15', '15C', '16', '16C', '17', '17C', '18', '18C', '19', '19C', '20', '20C', '21', '21C', '22', '22C', '23', '23C', '24', '24C'))
                         ORDER BY value;

#	File/Call
1	Doctrine\DBAL\Connection->executeCacheQuery (line 851)
2	BaksDev\Core\Doctrine\DBALQueryBuilder->executeCacheQuery (line 475)
3	BaksDev\Core\Doctrine\DBALQueryBuilder->executeDBALQuery (line 227)
4	BaksDev\Core\Doctrine\DBALQueryBuilder->fetchAllAssociative (line 311)
5	BaksDev\Field\Tire\Radius\Repository\TireRadiusRepository->cases (line 166)
6	BaksDev\Field\Tire\Radius\Form\TireRadiusFieldFormExists->configureOptions (line 50)
7	Symfony\Component\Form\ResolvedFormType->getOptionsResolver (line 135)
8	Symfony\Component\Form\ResolvedFormType->createBuilder (line 73)
9	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->createBuilder (line 58)
10	Symfony\Component\Form\FormFactory->createNamedBuilder (line 52)
11	Symfony\Component\Form\FormFactory->createNamed (line 31)
12	Symfony\Component\Form\Form->add (line 738)
13	BaksDev\Products\Product\Forms\ProductFilter\Admin\ProductFilterForm->{closure:BaksDev\Products\Product\Forms\ProductFilter\Admin\ProductFilterForm::buildForm():77} (line 171)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\ImmutableEventDispatcher->dispatch (line 28)
17	Symfony\Component\Form\Form->setData (line 283)
18	Symfony\Component\Form\Form->initialize (line 406)
19	Symfony\Component\Form\FormBuilder->getForm (line 171)
20	Symfony\Component\Form\FormFactory->createNamed (line 31)
21	BaksDev\Products\Product\Controller\Public\CatalogController->index (line 158)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 182)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	require_once (line 5)

6.03 ms
(0.27%)

SELECT p0_.id AS sclr_0, p1_.name AS sclr_1, p0_.reference AS sclr_2 FROM product_category p2_ INNER JOIN product_category_offers p0_ ON (p0_.event = p2_.event) LEFT JOIN product_category_offers_trans p1_ ON (p1_.offer = p0_.id AND p1_.local = ?) WHERE p2_.id = ?

Parameters:

[
  "ru"
  "01876af0-ddfc-70c3-ab25-5f85f55a9907"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS sclr_0,
  p1_.name AS sclr_1,
  p0_.reference AS sclr_2
FROM
  product_category p2_
  INNER JOIN product_category_offers p0_ ON (p0_.event = p2_.event)
  LEFT JOIN product_category_offers_trans p1_ ON (
    p1_.offer = p0_.id
    AND p1_.local = ?
  )
WHERE
  p2_.id = ?

SELECT p0_.id AS sclr_0, p1_.name AS sclr_1, p0_.reference AS sclr_2 FROM product_category p2_ INNER JOIN product_category_offers p0_ ON (p0_.event = p2_.event) LEFT JOIN product_category_offers_trans p1_ ON (p1_.offer = p0_.id AND p1_.local = 'ru') WHERE p2_.id = '01876af0-ddfc-70c3-ab25-5f85f55a9907';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	BaksDev\Core\Doctrine\ORMQueryBuilder->getOneOrNullResult (line 159)
7	BaksDev\Products\Category\Repository\OfferFieldsCategoryChoice\OfferFieldsCategoryChoiceRepository->findAllCategoryProductOffers (line 99)
8	BaksDev\Products\Product\Forms\ProductFilter\Admin\ProductFilterForm->{closure:BaksDev\Products\Product\Forms\ProductFilter\Admin\ProductFilterForm::buildForm():77} (line 163)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
11	Symfony\Component\EventDispatcher\ImmutableEventDispatcher->dispatch (line 28)
12	Symfony\Component\Form\Form->setData (line 283)
13	Symfony\Component\Form\Form->initialize (line 406)
14	Symfony\Component\Form\FormBuilder->getForm (line 171)
15	Symfony\Component\Form\FormFactory->createNamed (line 31)
16	BaksDev\Products\Product\Controller\Public\CatalogController->index (line 158)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 182)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

6.03 ms
(0.27%)

SELECT category_section_field.id, category_section_field.const, category_section_field.type, category_section_field_trans.name FROM product_category category 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.filter = 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 = ? WHERE category.id = ? ORDER BY category_section.sort, category_section_field.sort

Parameters:

[
  "ru"
  "01876af0-ddfc-70c3-ab25-5f85f55a9907"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  category_section_field.id,
  category_section_field.const,
  category_section_field.type,
  category_section_field_trans.name
FROM
  product_category category
  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.filter = 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 = ?
WHERE
  category.id = ?
ORDER BY
  category_section.sort,
  category_section_field.sort

SELECT category_section_field.id, category_section_field.const, category_section_field.type, category_section_field_trans.name FROM product_category category 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.filter = 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' WHERE category.id = '01876af0-ddfc-70c3-ab25-5f85f55a9907' ORDER BY category_section.sort, category_section_field.sort;

#	File/Call
1	Doctrine\DBAL\Connection->executeCacheQuery (line 851)
2	BaksDev\Core\Doctrine\DBALQueryBuilder->executeCacheQuery (line 475)
3	BaksDev\Core\Doctrine\DBALQueryBuilder->executeDBALQuery (line 227)
4	BaksDev\Core\Doctrine\DBALQueryBuilder->fetchAllAssociative (line 311)
5	BaksDev\Products\Category\Repository\AllFilterFieldsByCategory\AllFilterFieldsByCategoryRepository->findAll (line 110)
6	BaksDev\Products\Product\Forms\ProductFilter\Admin\ProductFilterForm->{closure:BaksDev\Products\Product\Forms\ProductFilter\Admin\ProductFilterForm::buildForm():77} (line 239)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
9	Symfony\Component\EventDispatcher\ImmutableEventDispatcher->dispatch (line 28)
10	Symfony\Component\Form\Form->setData (line 283)
11	Symfony\Component\Form\Form->initialize (line 406)
12	Symfony\Component\Form\FormBuilder->getForm (line 171)
13	Symfony\Component\Form\FormFactory->createNamed (line 31)
14	BaksDev\Products\Product\Controller\Public\CatalogController->index (line 158)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 182)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 29)
20	require_once (line 5)

5.85 ms
(0.26%)

SELECT p0_.id AS sclr_0, p1_.name AS sclr_1, p0_.reference AS sclr_2 FROM product_category_variation p2_ INNER JOIN product_category_modification p0_ ON (p0_.variation = p2_.id) LEFT JOIN product_category_modification_trans p1_ ON (p1_.modification = p0_.id AND p1_.local = ?) WHERE p2_.id = ?

Parameters:

[
  "ru"
  "01876af0-ddff-727a-a933-76ca3cb68e47"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS sclr_0,
  p1_.name AS sclr_1,
  p0_.reference AS sclr_2
FROM
  product_category_variation p2_
  INNER JOIN product_category_modification p0_ ON (p0_.variation = p2_.id)
  LEFT JOIN product_category_modification_trans p1_ ON (
    p1_.modification = p0_.id
    AND p1_.local = ?
  )
WHERE
  p2_.id = ?

SELECT p0_.id AS sclr_0, p1_.name AS sclr_1, p0_.reference AS sclr_2 FROM product_category_variation p2_ INNER JOIN product_category_modification p0_ ON (p0_.variation = p2_.id) LEFT JOIN product_category_modification_trans p1_ ON (p1_.modification = p0_.id AND p1_.local = 'ru') WHERE p2_.id = '01876af0-ddff-727a-a933-76ca3cb68e47';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	BaksDev\Core\Doctrine\ORMQueryBuilder->getOneOrNullResult (line 159)
7	BaksDev\Products\Category\Repository\ModificationFieldsCategoryChoice\ModificationFieldsCategoryChoiceRepository->findAllModification (line 99)
8	BaksDev\Products\Product\Forms\ProductFilter\Admin\ProductFilterForm->{closure:BaksDev\Products\Product\Forms\ProductFilter\Admin\ProductFilterForm::buildForm():77} (line 211)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
11	Symfony\Component\EventDispatcher\ImmutableEventDispatcher->dispatch (line 28)
12	Symfony\Component\Form\Form->setData (line 283)
13	Symfony\Component\Form\Form->initialize (line 406)
14	Symfony\Component\Form\FormBuilder->getForm (line 171)
15	Symfony\Component\Form\FormFactory->createNamed (line 31)
16	BaksDev\Products\Product\Controller\Public\CatalogController->index (line 158)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 182)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

5.53 ms
(0.25%)

SELECT p0_.id AS sclr_0, p1_.name AS sclr_1, p0_.reference AS sclr_2 FROM product_category_offers p2_ INNER JOIN product_category_variation p0_ ON (p0_.offer = p2_.id) LEFT JOIN product_category_variation_trans p1_ ON (p1_.variation = p0_.id AND p1_.local = ?) WHERE p2_.id = ?

Parameters:

[
  "ru"
  "01876af0-ddff-727a-a933-76ca3c645d18"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS sclr_0,
  p1_.name AS sclr_1,
  p0_.reference AS sclr_2
FROM
  product_category_offers p2_
  INNER JOIN product_category_variation p0_ ON (p0_.offer = p2_.id)
  LEFT JOIN product_category_variation_trans p1_ ON (
    p1_.variation = p0_.id
    AND p1_.local = ?
  )
WHERE
  p2_.id = ?

SELECT p0_.id AS sclr_0, p1_.name AS sclr_1, p0_.reference AS sclr_2 FROM product_category_offers p2_ INNER JOIN product_category_variation p0_ ON (p0_.offer = p2_.id) LEFT JOIN product_category_variation_trans p1_ ON (p1_.variation = p0_.id AND p1_.local = 'ru') WHERE p2_.id = '01876af0-ddff-727a-a933-76ca3c645d18';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	BaksDev\Core\Doctrine\ORMQueryBuilder->getOneOrNullResult (line 159)
7	BaksDev\Products\Category\Repository\VariationFieldsCategoryChoice\VariationFieldsCategoryChoiceRepository->findCategoryProductVariation (line 100)
8	BaksDev\Products\Product\Forms\ProductFilter\Admin\ProductFilterForm->{closure:BaksDev\Products\Product\Forms\ProductFilter\Admin\ProductFilterForm::buildForm():77} (line 187)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
11	Symfony\Component\EventDispatcher\ImmutableEventDispatcher->dispatch (line 28)
12	Symfony\Component\Form\Form->setData (line 283)
13	Symfony\Component\Form\Form->initialize (line 406)
14	Symfony\Component\Form\FormBuilder->getForm (line 171)
15	Symfony\Component\Form\FormFactory->createNamed (line 31)
16	BaksDev\Products\Product\Controller\Public\CatalogController->index (line 158)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 182)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

5.53 ms
(0.25%)

SELECT DISTINCT 
                CASE
                    WHEN category_offers.reference = ?
                    THEN offer.value  
                         
                    WHEN category_variation.reference = ?
                    THEN variation.value  
                         
                    WHEN category_modification.reference = ?
                    THEN modification.value
                     
                    ELSE NULL 
                END AS value
		 FROM product LEFT JOIN product_offer offer ON offer.event = product.event LEFT JOIN product_variation variation ON variation.offer = offer.id LEFT JOIN product_category_offers category_offers ON category_offers.id = offer.category_offer LEFT JOIN product_modification modification ON modification.variation = variation.id LEFT JOIN product_category_variation category_variation ON category_variation.id = variation.category_variation LEFT JOIN product_category_modification category_modification ON category_modification.id = modification.category_modification WHERE 
                            (category_offers.reference = ? AND offer.value IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) OR
                            (category_variation.reference = ? AND variation.value IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) OR
                            (category_modification.reference = ? AND modification.value IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
                         ORDER BY value

Parameters:

[
  "tire_width_field"
  "tire_width_field"
  "tire_width_field"
  "tire_width_field"
  30
  31
  32
  33
  34
  35
  36
  37
  145
  155
  165
  175
  185
  195
  205
  215
  225
  235
  245
  255
  265
  275
  285
  295
  305
  315
  325
  "tire_width_field"
  30
  31
  32
  33
  34
  35
  36
  37
  145
  155
  165
  175
  185
  195
  205
  215
  225
  235
  245
  255
  265
  275
  285
  295
  305
  315
  325
  "tire_width_field"
  30
  31
  32
  33
  34
  35
  36
  37
  145
  155
  165
  175
  185
  195
  205
  215
  225
  235
  245
  255
  265
  275
  285
  295
  305
  315
  325
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT CASE WHEN category_offers.reference = ? THEN
    offer.value
  WHEN category_variation.reference = ? THEN
    variation.value
  WHEN category_modification.reference = ? THEN
    modification.value
  ELSE
    NULL
  END AS value
FROM
  product
  LEFT JOIN product_offer offer ON offer.event = product.event
  LEFT JOIN product_variation variation ON variation.offer = offer.id
  LEFT JOIN product_category_offers category_offers ON category_offers.id = offer.category_offer
  LEFT JOIN product_modification modification ON modification.variation = variation.id
  LEFT JOIN product_category_variation category_variation ON category_variation.id = variation.category_variation
  LEFT JOIN product_category_modification category_modification ON category_modification.id = modification.category_modification
WHERE
  (
    category_offers.reference = ?
    AND offer.value IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
    )
  )
  OR (
    category_variation.reference = ?
    AND variation.value IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
    )
  )
  OR (
    category_modification.reference = ?
    AND modification.value IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
    )
  )
ORDER BY
  value

SELECT DISTINCT 
                CASE
                    WHEN category_offers.reference = 'tire_width_field'
                    THEN offer.value  
                         
                    WHEN category_variation.reference = 'tire_width_field'
                    THEN variation.value  
                         
                    WHEN category_modification.reference = 'tire_width_field'
                    THEN modification.value
                     
                    ELSE NULL 
                END AS value
		 FROM product LEFT JOIN product_offer offer ON offer.event = product.event LEFT JOIN product_variation variation ON variation.offer = offer.id LEFT JOIN product_category_offers category_offers ON category_offers.id = offer.category_offer LEFT JOIN product_modification modification ON modification.variation = variation.id LEFT JOIN product_category_variation category_variation ON category_variation.id = variation.category_variation LEFT JOIN product_category_modification category_modification ON category_modification.id = modification.category_modification WHERE 
                            (category_offers.reference = 'tire_width_field' AND offer.value IN (30, 31, 32, 33, 34, 35, 36, 37, 145, 155, 165, 175, 185, 195, 205, 215, 225, 235, 245, 255, 265, 275, 285, 295, 305, 315, 325)) OR
                            (category_variation.reference = 'tire_width_field' AND variation.value IN (30, 31, 32, 33, 34, 35, 36, 37, 145, 155, 165, 175, 185, 195, 205, 215, 225, 235, 245, 255, 265, 275, 285, 295, 305, 315, 325)) OR
                            (category_modification.reference = 'tire_width_field' AND modification.value IN (30, 31, 32, 33, 34, 35, 36, 37, 145, 155, 165, 175, 185, 195, 205, 215, 225, 235, 245, 255, 265, 275, 285, 295, 305, 315, 325))
                         ORDER BY value;

#	File/Call
1	Doctrine\DBAL\Connection->executeCacheQuery (line 851)
2	BaksDev\Core\Doctrine\DBALQueryBuilder->executeCacheQuery (line 475)
3	BaksDev\Core\Doctrine\DBALQueryBuilder->executeDBALQuery (line 227)
4	BaksDev\Core\Doctrine\DBALQueryBuilder->fetchAllAssociative (line 311)
5	BaksDev\Field\Tire\Width\Repository\TireWidthRepository->cases (line 162)
6	BaksDev\Field\Tire\Width\Form\TireWidthFieldFormExists->configureOptions (line 50)
7	Symfony\Component\Form\ResolvedFormType->getOptionsResolver (line 135)
8	Symfony\Component\Form\ResolvedFormType->createBuilder (line 73)
9	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->createBuilder (line 58)
10	Symfony\Component\Form\FormFactory->createNamedBuilder (line 52)
11	Symfony\Component\Form\FormFactory->createNamed (line 31)
12	Symfony\Component\Form\Form->add (line 738)
13	BaksDev\Products\Product\Forms\ProductFilter\Admin\ProductFilterForm->{closure:BaksDev\Products\Product\Forms\ProductFilter\Admin\ProductFilterForm::buildForm():77} (line 196)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\ImmutableEventDispatcher->dispatch (line 28)
17	Symfony\Component\Form\Form->setData (line 283)
18	Symfony\Component\Form\Form->initialize (line 406)
19	Symfony\Component\Form\FormBuilder->getForm (line 171)
20	Symfony\Component\Form\FormFactory->createNamed (line 31)
21	BaksDev\Products\Product\Controller\Public\CatalogController->index (line 158)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 182)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	require_once (line 5)

5.23 ms
(0.24%)

SELECT DISTINCT 
                CASE
                    WHEN category_offers.reference = ?
                    THEN offer.value  
                         
                    WHEN category_variation.reference = ?
                    THEN variation.value  
                         
                    WHEN category_modification.reference = ?
                    THEN modification.value
                     
                    ELSE NULL 
                END AS value
		 FROM product LEFT JOIN product_offer offer ON offer.event = product.event LEFT JOIN product_variation variation ON variation.offer = offer.id LEFT JOIN product_category_offers category_offers ON category_offers.id = offer.category_offer LEFT JOIN product_modification modification ON modification.variation = variation.id LEFT JOIN product_category_variation category_variation ON category_variation.id = variation.category_variation LEFT JOIN product_category_modification category_modification ON category_modification.id = modification.category_modification WHERE 
                            (category_offers.reference = ? AND offer.value IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) OR
                            (category_variation.reference = ? AND variation.value IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) OR
                            (category_modification.reference = ? AND modification.value IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
                         ORDER BY value

Parameters:

[
  "tire_profile_field"
  "tire_profile_field"
  "tire_profile_field"
  "tire_profile_field"
  9.5
  10.5
  11.5
  12.5
  30
  35
  40
  45
  50
  55
  60
  65
  70
  75
  80
  85
  "tire_profile_field"
  9.5
  10.5
  11.5
  12.5
  30
  35
  40
  45
  50
  55
  60
  65
  70
  75
  80
  85
  "tire_profile_field"
  9.5
  10.5
  11.5
  12.5
  30
  35
  40
  45
  50
  55
  60
  65
  70
  75
  80
  85
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT CASE WHEN category_offers.reference = ? THEN
    offer.value
  WHEN category_variation.reference = ? THEN
    variation.value
  WHEN category_modification.reference = ? THEN
    modification.value
  ELSE
    NULL
  END AS value
FROM
  product
  LEFT JOIN product_offer offer ON offer.event = product.event
  LEFT JOIN product_variation variation ON variation.offer = offer.id
  LEFT JOIN product_category_offers category_offers ON category_offers.id = offer.category_offer
  LEFT JOIN product_modification modification ON modification.variation = variation.id
  LEFT JOIN product_category_variation category_variation ON category_variation.id = variation.category_variation
  LEFT JOIN product_category_modification category_modification ON category_modification.id = modification.category_modification
WHERE
  (
    category_offers.reference = ?
    AND offer.value IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
    )
  )
  OR (
    category_variation.reference = ?
    AND variation.value IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
    )
  )
  OR (
    category_modification.reference = ?
    AND modification.value IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
    )
  )
ORDER BY
  value

SELECT DISTINCT 
                CASE
                    WHEN category_offers.reference = 'tire_profile_field'
                    THEN offer.value  
                         
                    WHEN category_variation.reference = 'tire_profile_field'
                    THEN variation.value  
                         
                    WHEN category_modification.reference = 'tire_profile_field'
                    THEN modification.value
                     
                    ELSE NULL 
                END AS value
		 FROM product LEFT JOIN product_offer offer ON offer.event = product.event LEFT JOIN product_variation variation ON variation.offer = offer.id LEFT JOIN product_category_offers category_offers ON category_offers.id = offer.category_offer LEFT JOIN product_modification modification ON modification.variation = variation.id LEFT JOIN product_category_variation category_variation ON category_variation.id = variation.category_variation LEFT JOIN product_category_modification category_modification ON category_modification.id = modification.category_modification WHERE 
                            (category_offers.reference = 'tire_profile_field' AND offer.value IN (9.5, 10.5, 11.5, 12.5, 30, 35, 40, 45, 50, 55, 60, 65, 70, 75, 80, 85)) OR
                            (category_variation.reference = 'tire_profile_field' AND variation.value IN (9.5, 10.5, 11.5, 12.5, 30, 35, 40, 45, 50, 55, 60, 65, 70, 75, 80, 85)) OR
                            (category_modification.reference = 'tire_profile_field' AND modification.value IN (9.5, 10.5, 11.5, 12.5, 30, 35, 40, 45, 50, 55, 60, 65, 70, 75, 80, 85))
                         ORDER BY value;

#	File/Call
1	Doctrine\DBAL\Connection->executeCacheQuery (line 851)
2	BaksDev\Core\Doctrine\DBALQueryBuilder->executeCacheQuery (line 475)
3	BaksDev\Core\Doctrine\DBALQueryBuilder->executeDBALQuery (line 227)
4	BaksDev\Core\Doctrine\DBALQueryBuilder->fetchAllAssociative (line 311)
5	BaksDev\Field\Tire\Profile\Repository\TireProfileRepository->cases (line 164)
6	BaksDev\Field\Tire\Profile\Form\TireProfileFieldFormExists->configureOptions (line 50)
7	Symfony\Component\Form\ResolvedFormType->getOptionsResolver (line 135)
8	Symfony\Component\Form\ResolvedFormType->createBuilder (line 73)
9	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->createBuilder (line 58)
10	Symfony\Component\Form\FormFactory->createNamedBuilder (line 52)
11	Symfony\Component\Form\FormFactory->createNamed (line 31)
12	Symfony\Component\Form\Form->add (line 738)
13	BaksDev\Products\Product\Forms\ProductFilter\Admin\ProductFilterForm->{closure:BaksDev\Products\Product\Forms\ProductFilter\Admin\ProductFilterForm::buildForm():77} (line 220)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\ImmutableEventDispatcher->dispatch (line 28)
17	Symfony\Component\Form\Form->setData (line 283)
18	Symfony\Component\Form\Form->initialize (line 406)
19	Symfony\Component\Form\FormBuilder->getForm (line 171)
20	Symfony\Component\Form\FormFactory->createNamed (line 31)
21	BaksDev\Products\Product\Controller\Public\CatalogController->index (line 158)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 182)
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

Class	Mapping errors
BaksDev\Products\Category\Entity\CategoryProduct	No errors.
BaksDev\Products\Category\Entity\Offers\CategoryProductOffers	No errors.
BaksDev\Products\Category\Entity\Offers\Trans\CategoryProductOffersTrans	No errors.
BaksDev\Products\Category\Entity\Offers\Variation\CategoryProductVariation	No errors.
BaksDev\Products\Category\Entity\Offers\Variation\Trans\CategoryProductVariationTrans	No errors.
BaksDev\Products\Category\Entity\Offers\Variation\Modification\CategoryProductModification	No errors.
BaksDev\Products\Category\Entity\Offers\Variation\Modification\Trans\CategoryProductModificationTrans	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping