Symfony Profiler

BaksDev\Core\Doctrine\DBAL\Delay\DBALDelayMessage {#3413
  -namespace: "products-product"
  -key: "7c768182db35514f0af1d88986b579bea84bccac"
  -sql: """
    SELECT COUNT(*) FROM product INNER JOIN product_categories_product product_event_category ON product_event_category.event = product.event AND product_event_category.category IN (:category) LEFT JOIN product_trans product_trans ON product_trans.event = product.event AND product_trans.local = :local LEFT JOIN product_description product_desc ON product_desc.event = product.event AND product_desc.device = :device AND product_desc.local = :local LEFT JOIN product_info product_info ON product_info.product = product.id INNER JOIN product_active product_active ON \n
                        product_active.event = product.event AND \n
                        product_active.active IS TRUE AND\n
                        (product_active.active_to IS NULL OR product_active.active_to > NOW())\n
                     LEFT JOIN product_price product_price ON product_price.event = product.event AND product_price.price > 0 LEFT JOIN product_offer product_offer ON product_offer.event = product.event LEFT JOIN product_photo product_photo ON product_photo.event = product.event AND product_photo.root = true INNER JOIN users_profile project_profile ON \n
                            project_profile.id = :project_profile LEFT JOIN product_category category ON category.id = product_event_category.category LEFT JOIN product_category_info category_info ON category_info.event = category.event AND category_info.active IS TRUE LEFT JOIN product_category_trans category_trans ON category_trans.event = category.event AND category_trans.local = :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\n
                              (\n
                                category_section_field.card = TRUE OR\n
                                category_section_field.photo = TRUE OR\n
                                category_section_field.name = TRUE\n
                              )\n
                           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 = :local LEFT JOIN product_property product_property ON product_property.event = product.event AND product_property.field = category_section_field.const LEFT JOIN product_category_offers category_offer ON category_offer.id = product_offer.category_offer LEFT JOIN product_offer_price product_offer_price ON product_offer_price.offer = product_offer.id AND product_offer_price.price > 0 LEFT JOIN product_offer_quantity product_offer_quantity ON product_offer_quantity.offer = product_offer.id LEFT JOIN product_variation product_variation ON product_variation.offer = product_offer.id LEFT JOIN product_offer_images product_offer_images ON product_offer_images.offer = product_offer.id AND product_offer_images.root = true LEFT JOIN product_variation_images product_variation_image ON product_variation_image.variation = product_variation.id AND product_variation_image.root = true LEFT JOIN product_category_variation category_variation ON category_variation.id = product_variation.category_variation LEFT JOIN product_modification product_modification ON product_modification.variation = product_variation.id LEFT JOIN product_invariable product_invariable ON \n
                                product_invariable.product = product.id\n
                                AND\n
                                    CASE \n
                                        WHEN product_offer.const IS NOT NULL THEN product_invariable.offer = product_offer.const\n
                                        ELSE product_invariable.offer IS NULL\n
                                    END\n
                                AND \n
                                    CASE\n
                                        WHEN product_variation.const IS NOT NULL THEN product_invariable.variation = product_variation.const\n
                                        ELSE product_invariable.variation IS NULL\n
                                    END\n
                                AND\n
                                    CASE\n
                                        WHEN product_modification.const IS NOT NULL THEN product_invariable.modification = product_modification.const\n
                                        ELSE product_invariable.modification IS NULL\n
                                    END\n
                             LEFT JOIN product_variation_price product_variation_price ON product_variation_price.variation = product_variation.id AND product_variation_price.price > 0 LEFT JOIN product_variation_quantity product_variation_quantity ON product_variation_quantity.variation = product_variation.id LEFT JOIN product_category_modification category_modification ON category_modification.id = product_modification.category_modification LEFT JOIN product_modification_price product_modification_price ON product_modification_price.modification = product_modification.id AND product_modification_price.price > 0 LEFT JOIN product_modification_quantity product_modification_quantity ON product_modification_quantity.modification = product_modification.id LEFT JOIN product_modification_images product_modification_image ON product_modification_image.modification = product_modification.id AND product_modification_image.root = true LEFT JOIN user_profile_discount project_profile_discount ON \n
                            project_profile_discount.event = project_profile.event WHERE \n
                COALESCE(\n
                    NULLIF(product_modification_price.price, 0),\n
                    NULLIF(product_variation_price.price, 0),\n
                    NULLIF(product_offer_price.price, 0),\n
                    NULLIF(product_price.price, 0),\n
                    0\n
                ) <> 0
    """
  -params: [
    "local" => BaksDev\Core\Type\Locale\Locale {#2622
      -locale: BaksDev\Core\Type\Locale\Locales\Ru {#3290}
    }
    "category" => [
      BaksDev\Products\Category\Type\Id\CategoryProductUid {#2605
        -value: Symfony\Component\Uid\Uuid {#2606
          #uid: "01876af0-ddfc-70c3-ab25-5f85f55a9907"
          toBase58: "1Bx91SVS73qLwtQPZrRNZ4"
          toBase32: "01GXNF1QFWE31TP9AZGQTNN687"
        }
        -options: null
        -attr: null
        -params: null
      }
    ]
    "device" => "pc"
    "project_profile" => BaksDev\Users\Profile\UserProfile\Type\Id\UserProfileUid {#3161
      -value: Symfony\Component\Uid\Uuid {#3377
        #uid: "019469c3-700f-76a9-9b34-ccde7b4e6f49"
        toBase58: "1CKE4X15fkdvPLTXYWzoYt"
        toBase32: "01JHMW6W0FETMSPD6CVSXMWVT9"
      }
      -attr: null
      -option: null
      -property: null
      -characteristic: null
      -params: null
      -decode: null
    }
  ]
  -types: [
    "local" => "locale"
    "category" => Doctrine\DBAL\ArrayParameterType {#1890
      +name: "STRING"
    }
    "device" => Doctrine\DBAL\ParameterType {#1463
      +name: "STRING"
    }
    "project_profile" => "user_profile"
  ]
}

Symfony\Component\Messenger\Stamp\DelayStamp {#3422
  -delay: 8581
}

Symfony\Component\Messenger\Stamp\TransportNamesStamp {#3423
  -transportNames: [
    "async-low"
  ]
}

Symfony\Component\Messenger\Stamp\DelayStamp {#3422
  -delay: 8581
}

Symfony\Component\Messenger\Stamp\TransportNamesStamp {#3423
  -transportNames: [
    "async-low"
  ]
}

Symfony\Component\Messenger\Stamp\BusNameStamp {#3430
  -busName: "messenger.bus.default"
}

Symfony\Component\Messenger\Stamp\SentStamp {#3470
  -senderClass: "Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineTransport"
  -senderAlias: "async-low"
}

Symfony\Component\Messenger\Stamp\TransportMessageIdStamp {#3484
  -id: "144419"
}