Symfony Profiler

[
  "route" => "frontend_category_products_list"
  "route_parameters" => [
    "_route" => "frontend_category_products_list"
    "_controller" => "Fotoboom\Apps\Http\Controller\Frontend\Category\CategoryProductsListController"
    "slug" => "objetivos"
  ]
  "request_uri" => "https://fotoboom-dev-env.pixelarus.com/categoria/objetivos?page=3"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 1
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\IsSignatureValidAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "ContainerQrQHg0h\RequestPayloadValueResolverGhostE866cfe::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "fotoboom-db-user"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "fotoboom-dev-env-db-1"
    "serverVersion" => "10.5.28-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 WHERE t0.slug = ? LIMIT 1"
  "params" => [
    1 => "objetivos"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 WHERE t0.parent_category_id = ?"
  "params" => [
    1 => "bc7c8b41-4ab9-431a-8bd1-02287baae2d9"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 WHERE t0.parent_category_id = ?"
  "params" => [
    1 => "0709b595-d1f1-4d84-848a-467421e0b9d8"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 WHERE t0.parent_category_id = ?"
  "params" => [
    1 => "17b4781d-f123-4b65-9b7b-576df8253c52"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 WHERE t0.parent_category_id = ?"
  "params" => [
    1 => "222c127e-d842-4734-8d75-54062d7366b9"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 WHERE t0.parent_category_id = ?"
  "params" => [
    1 => "4eaefc8f-6d0a-4b8a-b798-aea3cdaad159"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 WHERE t0.parent_category_id = ?"
  "params" => [
    1 => "6eb664db-a89c-4465-93f0-a3b006b79f5e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 WHERE t0.parent_category_id = ?"
  "params" => [
    1 => "7e9ebc60-a0b6-4f9e-a2df-e11e8e09033a"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 WHERE t0.parent_category_id = ?"
  "params" => [
    1 => "7f8d97ff-7124-4dda-9ead-905dc5cfd9cd"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 WHERE t0.parent_category_id = ?"
  "params" => [
    1 => "9cf0b93e-a2eb-4a90-94b6-0200f55311bb"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 WHERE t0.parent_category_id = ?"
  "params" => [
    1 => "c660fa3f-a741-42cb-badf-5ca3ffb23682"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 WHERE t0.parent_category_id = ?"
  "params" => [
    1 => "f6774865-109d-4306-ab60-34a4746f6fd6"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT p0_.slug AS slug_0, p0_.name AS name_1, p0_.description AS description_2, p0_.description_short AS description_short_3, p0_.supplier_reference AS supplier_reference_4, p0_.manufacturer_reference AS manufacturer_reference_5, p0_.ean AS ean_6, p0_.position AS position_7, p0_.status AS status_8, p0_.tax_type AS tax_type_9, p0_.showcase AS showcase_10, p0_.on_offer AS on_offer_11, p0_.new AS new_12, p0_.kit AS kit_13, p0_.show_only_in_pack AS show_only_in_pack_14, p0_.price_buy AS price_buy_15, p0_.price_sell AS price_sell_16, p0_.price_offer AS price_offer_17, p0_.soa AS soa_18, p0_.stock AS stock_19, p0_.stock_supplier AS stock_supplier_20, p0_.min AS min_21, p0_.max AS max_22, p0_.period AS period_23, p0_.internal_comments AS internal_comments_24, p0_.created_at AS created_at_25, p0_.updated_at AS updated_at_26, p0_.last_activation_at AS last_activation_at_27, p0_.product_specs AS product_specs_28, p0_.cron_export_status AS cron_export_status_29, p0_.id AS id_30, CASE WHEN p0_.price_offer IS NOT NULL THEN p0_.price_offer ELSE p0_.price_sell END AS sclr_31, p0_.brand_id AS brand_id_32, p0_.created_by_user AS created_by_user_33, p0_.updated_by_user AS updated_by_user_34, p0_.last_activation_by_user AS last_activation_by_user_35 FROM products p0_ LEFT JOIN products_rel_categories p2_ ON p0_.id = p2_.product_id LEFT JOIN products_categories p1_ ON p1_.id = p2_.category_id INNER JOIN products_brands p3_ ON p0_.brand_id = p3_.id WHERE p0_.show_only_in_pack = ? AND p1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p3_.enabled = ? AND p0_.status = ? ORDER BY p3_.name ASC, sclr_31 DESC LIMIT 20 OFFSET 40"
  "params" => [
    1 => 0
    2 => "bc7c8b41-4ab9-431a-8bd1-02287baae2d9"
    3 => "0709b595-d1f1-4d84-848a-467421e0b9d8"
    4 => "17b4781d-f123-4b65-9b7b-576df8253c52"
    5 => "222c127e-d842-4734-8d75-54062d7366b9"
    6 => "4eaefc8f-6d0a-4b8a-b798-aea3cdaad159"
    7 => "6eb664db-a89c-4465-93f0-a3b006b79f5e"
    8 => "7e9ebc60-a0b6-4f9e-a2df-e11e8e09033a"
    9 => "7f8d97ff-7124-4dda-9ead-905dc5cfd9cd"
    10 => "9cf0b93e-a2eb-4a90-94b6-0200f55311bb"
    11 => "c660fa3f-a741-42cb-badf-5ca3ffb23682"
    12 => "f6774865-109d-4306-ab60-34a4746f6fd6"
    13 => 1
    14 => 1
  ]
  "types" => [
    1 => 5
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 5
    14 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?"
  "params" => [
    1 => 210
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?"
  "params" => [
    1 => 157
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?"
  "params" => [
    1 => 193
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?"
  "params" => [
    1 => 160
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?"
  "params" => [
    1 => 221
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?"
  "params" => [
    1 => 181
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?"
  "params" => [
    1 => 208
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?"
  "params" => [
    1 => 202
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?"
  "params" => [
    1 => 154
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?"
  "params" => [
    1 => 186
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?"
  "params" => [
    1 => 203
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?"
  "params" => [
    1 => 168
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?"
  "params" => [
    1 => 161
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?"
  "params" => [
    1 => 169
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?"
  "params" => [
    1 => 177
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?"
  "params" => [
    1 => 175
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?"
  "params" => [
    1 => 176
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?"
  "params" => [
    1 => 213
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?"
  "params" => [
    1 => 377
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.feature_id AS feature_id_8 FROM products_feature_values t0 INNER JOIN products_rel_feature_values ON t0.id = products_rel_feature_values.feature_value_id WHERE products_rel_feature_values.product_id = ?"
  "params" => [
    1 => 166
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT count(1) AS sclr_0 FROM products p0_ LEFT JOIN products_rel_categories p2_ ON p0_.id = p2_.product_id LEFT JOIN products_categories p1_ ON p1_.id = p2_.category_id INNER JOIN products_brands p3_ ON p0_.brand_id = p3_.id WHERE p0_.show_only_in_pack = ? AND p1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p3_.enabled = ? AND p0_.status = ?"
  "params" => [
    1 => 0
    2 => "bc7c8b41-4ab9-431a-8bd1-02287baae2d9"
    3 => "0709b595-d1f1-4d84-848a-467421e0b9d8"
    4 => "17b4781d-f123-4b65-9b7b-576df8253c52"
    5 => "222c127e-d842-4734-8d75-54062d7366b9"
    6 => "4eaefc8f-6d0a-4b8a-b798-aea3cdaad159"
    7 => "6eb664db-a89c-4465-93f0-a3b006b79f5e"
    8 => "7e9ebc60-a0b6-4f9e-a2df-e11e8e09033a"
    9 => "7f8d97ff-7124-4dda-9ead-905dc5cfd9cd"
    10 => "9cf0b93e-a2eb-4a90-94b6-0200f55311bb"
    11 => "c660fa3f-a741-42cb-badf-5ca3ffb23682"
    12 => "f6774865-109d-4306-ab60-34a4746f6fd6"
    13 => 1
    14 => 1
  ]
  "types" => [
    1 => 5
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 5
    14 => 1
  ]
]

[
  "sql" => "SELECT p0_.slug AS slug_0, p0_.name AS name_1 FROM products p1_ LEFT JOIN products_rel_categories p3_ ON p1_.id = p3_.product_id LEFT JOIN products_categories p2_ ON p2_.id = p3_.category_id INNER JOIN products_brands p4_ ON p1_.brand_id = p4_.id INNER JOIN products_brands p0_ ON p1_.brand_id = p0_.id WHERE p1_.show_only_in_pack = ? AND p2_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p4_.enabled = ? AND p1_.status = ? GROUP BY p0_.id ORDER BY p0_.name ASC"
  "params" => [
    1 => 0
    2 => "bc7c8b41-4ab9-431a-8bd1-02287baae2d9"
    3 => "0709b595-d1f1-4d84-848a-467421e0b9d8"
    4 => "17b4781d-f123-4b65-9b7b-576df8253c52"
    5 => "222c127e-d842-4734-8d75-54062d7366b9"
    6 => "4eaefc8f-6d0a-4b8a-b798-aea3cdaad159"
    7 => "6eb664db-a89c-4465-93f0-a3b006b79f5e"
    8 => "7e9ebc60-a0b6-4f9e-a2df-e11e8e09033a"
    9 => "7f8d97ff-7124-4dda-9ead-905dc5cfd9cd"
    10 => "9cf0b93e-a2eb-4a90-94b6-0200f55311bb"
    11 => "c660fa3f-a741-42cb-badf-5ca3ffb23682"
    12 => "f6774865-109d-4306-ab60-34a4746f6fd6"
    13 => 1
    14 => 1
  ]
  "types" => [
    1 => 5
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 5
    14 => 1
  ]
]

[
  "sql" => "SELECT p0_.slug AS slug_0, p0_.name AS name_1, p0_.slug AS slug_2 FROM products p1_ LEFT JOIN products_rel_categories p2_ ON p1_.id = p2_.product_id LEFT JOIN products_categories p0_ ON p0_.id = p2_.category_id INNER JOIN products_brands p3_ ON p1_.brand_id = p3_.id INNER JOIN products_brands p4_ ON p1_.brand_id = p4_.id WHERE p1_.show_only_in_pack = ? AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p3_.enabled = ? AND p1_.status = ? GROUP BY p0_.id ORDER BY p0_.name ASC"
  "params" => [
    1 => 0
    2 => "bc7c8b41-4ab9-431a-8bd1-02287baae2d9"
    3 => "0709b595-d1f1-4d84-848a-467421e0b9d8"
    4 => "17b4781d-f123-4b65-9b7b-576df8253c52"
    5 => "222c127e-d842-4734-8d75-54062d7366b9"
    6 => "4eaefc8f-6d0a-4b8a-b798-aea3cdaad159"
    7 => "6eb664db-a89c-4465-93f0-a3b006b79f5e"
    8 => "7e9ebc60-a0b6-4f9e-a2df-e11e8e09033a"
    9 => "7f8d97ff-7124-4dda-9ead-905dc5cfd9cd"
    10 => "9cf0b93e-a2eb-4a90-94b6-0200f55311bb"
    11 => "c660fa3f-a741-42cb-badf-5ca3ffb23682"
    12 => "f6774865-109d-4306-ab60-34a4746f6fd6"
    13 => 1
    14 => 1
  ]
  "types" => [
    1 => 5
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 5
    14 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p1_.id AS id_1, p1_.name AS name_2, p0_.name AS name_3, p1_.slug AS slug_4, p0_.slug AS slug_5, p0_.position AS position_6 FROM products p2_ LEFT JOIN products_rel_categories p4_ ON p2_.id = p4_.product_id LEFT JOIN products_categories p3_ ON p3_.id = p4_.category_id INNER JOIN products_brands p5_ ON p2_.brand_id = p5_.id INNER JOIN products_brands p6_ ON p2_.brand_id = p6_.id INNER JOIN products_rel_feature_values p7_ ON p2_.id = p7_.product_id INNER JOIN products_feature_values p0_ ON p0_.id = p7_.feature_value_id INNER JOIN products_features p1_ ON p0_.feature_id = p1_.id INNER JOIN products_categories_rel_products_features p8_ ON p1_.id = p8_.feature_id AND (p8_.feature_id = p1_.id AND p8_.category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) WHERE p2_.show_only_in_pack = ? AND p3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p5_.enabled = ? AND p2_.status = ? GROUP BY p0_.id, p1_.id, p1_.name, p0_.name, p1_.slug, p0_.slug, p0_.position, p8_.position ORDER BY p3_.name ASC, p8_.position ASC, p0_.position ASC"
  "params" => [
    1 => "bc7c8b41-4ab9-431a-8bd1-02287baae2d9"
    2 => "0709b595-d1f1-4d84-848a-467421e0b9d8"
    3 => "17b4781d-f123-4b65-9b7b-576df8253c52"
    4 => "222c127e-d842-4734-8d75-54062d7366b9"
    5 => "4eaefc8f-6d0a-4b8a-b798-aea3cdaad159"
    6 => "6eb664db-a89c-4465-93f0-a3b006b79f5e"
    7 => "7e9ebc60-a0b6-4f9e-a2df-e11e8e09033a"
    8 => "7f8d97ff-7124-4dda-9ead-905dc5cfd9cd"
    9 => "9cf0b93e-a2eb-4a90-94b6-0200f55311bb"
    10 => "c660fa3f-a741-42cb-badf-5ca3ffb23682"
    11 => "f6774865-109d-4306-ab60-34a4746f6fd6"
    12 => 0
    13 => "bc7c8b41-4ab9-431a-8bd1-02287baae2d9"
    14 => "0709b595-d1f1-4d84-848a-467421e0b9d8"
    15 => "17b4781d-f123-4b65-9b7b-576df8253c52"
    16 => "222c127e-d842-4734-8d75-54062d7366b9"
    17 => "4eaefc8f-6d0a-4b8a-b798-aea3cdaad159"
    18 => "6eb664db-a89c-4465-93f0-a3b006b79f5e"
    19 => "7e9ebc60-a0b6-4f9e-a2df-e11e8e09033a"
    20 => "7f8d97ff-7124-4dda-9ead-905dc5cfd9cd"
    21 => "9cf0b93e-a2eb-4a90-94b6-0200f55311bb"
    22 => "c660fa3f-a741-42cb-badf-5ca3ffb23682"
    23 => "f6774865-109d-4306-ab60-34a4746f6fd6"
    24 => 1
    25 => 1
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 5
    13 => 2
    14 => 2
    15 => 2
    16 => 2
    17 => 2
    18 => 2
    19 => 2
    20 => 2
    21 => 2
    22 => 2
    23 => 2
    24 => 5
    25 => 1
  ]
]

[
  "sql" => "SELECT b0_.name AS name_0, b0_.link_to AS link_to_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.updated_at AS updated_at_4, b0_.id AS id_5 FROM banners b0_ INNER JOIN banner_location_position b1_ ON b0_.id = b1_.banner_id WHERE b0_.status = ? AND b1_.location = ? AND b1_.category_id = ? ORDER BY b1_.position ASC LIMIT 30"
  "params" => [
    1 => 2
    2 => 2
    3 => "bc7c8b41-4ab9-431a-8bd1-02287baae2d9"
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 2
  ]
]

[
  "sql" => "SELECT count(1) AS sclr_0 FROM banners b0_ INNER JOIN banner_location_position b1_ ON b0_.id = b1_.banner_id WHERE b0_.status = ? AND b1_.location = ? AND b1_.category_id = ?"
  "params" => [
    1 => 2
    2 => 2
    3 => "bc7c8b41-4ab9-431a-8bd1-02287baae2d9"
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 2
  ]
]

[
  "sql" => "SELECT b0_.name AS name_0, b0_.link_to AS link_to_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.updated_at AS updated_at_4, b0_.id AS id_5 FROM banners b0_ INNER JOIN banner_location_position b1_ ON b0_.id = b1_.banner_id WHERE b0_.status = ? AND b1_.location = ? ORDER BY b1_.position ASC LIMIT 30"
  "params" => [
    1 => 2
    2 => 3
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT count(1) AS sclr_0 FROM banners b0_ INNER JOIN banner_location_position b1_ ON b0_.id = b1_.banner_id WHERE b0_.status = ? AND b1_.location = ?"
  "params" => [
    1 => 2
    2 => 3
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 INNER JOIN products_rel_categories ON t0.id = products_rel_categories.category_id WHERE products_rel_categories.product_id = ?"
  "params" => [
    1 => 210
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.slug AS slug_2, t0.enabled AS enabled_3, t0.multiple AS multiple_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7 FROM products_features t0 WHERE t0.id = ?"
  "params" => [
    1 => "71d2e133-0f1c-446a-907f-0f527de3810c"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.slug AS slug_2, t0.enabled AS enabled_3, t0.multiple AS multiple_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7 FROM products_features t0 WHERE t0.id = ?"
  "params" => [
    1 => "e9f56900-27d4-420e-b033-a5e589e36920"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.slug AS slug_2, t0.enabled AS enabled_3, t0.multiple AS multiple_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7 FROM products_features t0 WHERE t0.id = ?"
  "params" => [
    1 => "010a7895-bc05-4e50-a146-ebc7734898bb"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.slug AS slug_2, t0.enabled AS enabled_3, t0.multiple AS multiple_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7 FROM products_features t0 WHERE t0.id = ?"
  "params" => [
    1 => "058967c9-41d5-4c57-bda3-226bfee10641"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.slug AS slug_2, t0.enabled AS enabled_3, t0.multiple AS multiple_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7 FROM products_features t0 WHERE t0.id = ?"
  "params" => [
    1 => "528a0fc9-efd6-4022-858a-dd9ef451125c"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.position AS position_1, t0.is_main AS is_main_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.product_id AS product_id_6, t0.media_id AS media_id_7 FROM products_medias t0 WHERE t0.product_id = ?"
  "params" => [
    1 => 210
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.slug AS slug_2, t0.enabled AS enabled_3, t0.number_id AS number_id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7 FROM products_brands t0 WHERE t0.id = ?"
  "params" => [
    1 => "fb1de7e0-7c13-403b-b871-b1c5286d53a8"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.position AS position_1, t0.is_main AS is_main_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.brand_id AS brand_id_6, t0.media_id AS media_id_7 FROM brands_medias t0 WHERE t0.brand_id = ?"
  "params" => [
    1 => "fb1de7e0-7c13-403b-b871-b1c5286d53a8"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 INNER JOIN products_rel_categories ON t0.id = products_rel_categories.category_id WHERE products_rel_categories.product_id = ?"
  "params" => [
    1 => 157
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.position AS position_1, t0.is_main AS is_main_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.product_id AS product_id_6, t0.media_id AS media_id_7 FROM products_medias t0 WHERE t0.product_id = ?"
  "params" => [
    1 => 157
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 INNER JOIN products_rel_categories ON t0.id = products_rel_categories.category_id WHERE products_rel_categories.product_id = ?"
  "params" => [
    1 => 193
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.position AS position_1, t0.is_main AS is_main_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.product_id AS product_id_6, t0.media_id AS media_id_7 FROM products_medias t0 WHERE t0.product_id = ?"
  "params" => [
    1 => 193
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 INNER JOIN products_rel_categories ON t0.id = products_rel_categories.category_id WHERE products_rel_categories.product_id = ?"
  "params" => [
    1 => 160
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.position AS position_1, t0.is_main AS is_main_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.product_id AS product_id_6, t0.media_id AS media_id_7 FROM products_medias t0 WHERE t0.product_id = ?"
  "params" => [
    1 => 160
  ]
  "types" => [
    1 => 1
  ]
]