Symfony Profiler

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "192.168.0.118"
    "port" => 3306
    "user" => "root"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "papernet"
    "serverVersion" => "5.7.34"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT COUNT(l0_.id) AS sclr_0 FROM listini l0_"
]

[
  "route" => "technology_landing_with_listino"
  "route_parameters" => [
    "_route" => "technology_landing_with_listino"
    "listino" => "it"
    "_controller" => "App\Controller\PagesController::technologiesLanding"
    "_locale" => "en"
    "technology" => "heavenly-soft"
  ]
  "request_uri" => "http://papernet.inol3.com/en-it/technologies/heavenly-soft"
  "method" => "GET"
]

[
  "sql" => "SELECT COUNT(l0_.id) AS sclr_0 FROM listini l0_"
]

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

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

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

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

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

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

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

[
  "sql" => "SELECT t0.id AS id_1, t0.type AS type_2, t0.old_url AS old_url_3, t0.new_url AS new_url_4 FROM redirects t0 WHERE t0.old_url = ? LIMIT 1"
  "params" => [
    1 => "/en-it/technologies/heavenly-soft"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.lang AS lang_2, t0.label AS label_3 FROM langs t0 WHERE t0.lang = ? LIMIT 1"
  "params" => [
    1 => "en"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.listino AS listino_2, t0.currency_id AS currency_id_3 FROM listini t0 WHERE t0.listino = ? LIMIT 1"
  "params" => [
    1 => "it"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.type AS type_2, t0.old_url AS old_url_3, t0.new_url AS new_url_4 FROM redirects t0 WHERE t0.old_url = ? LIMIT 1"
  "params" => [
    1 => "/en-it/technologies/heavenly-soft"
  ]
  "types" => [
    1 => 2
  ]
]

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

[
  "event" => "kernel.request"
  "listener" => "Symfony\UX\Turbo\Request\RequestListener::__invoke"
]

[
  "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\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest"
]

[
  "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" => "App\EventListener\SQLInjectionSanification::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\UrlListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\OldUrlRedirects::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\RequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\OldUrlRedirects::onKernelRequest"
]

[
  "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\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" => "ContainerDVl4zjK\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.product AS product_2, t0.ean13 AS ean13_3, t0.product_name AS product_name_4, t0.product_url AS product_url_5, t0.commodity_code AS commodity_code_6, t0.brand AS brand_7, t0.collection AS collection_8, t0.category AS category_9, t0.is_online AS is_online_10, t0.in_home AS in_home_11, t0.is_to_show AS is_to_show_12, t0.label AS label_13, t0.linea_id AS linea_id_14 FROM products t0 WHERE t0.product IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => "422781"
    2 => "422782"
    3 => "424712"
    4 => "424749"
    5 => "415595"
    6 => "415596"
    7 => "410051"
    8 => "410009"
    9 => "410010"
    10 => "410011"
    11 => "410012"
    12 => "410049"
    13 => "410050"
    14 => "410081"
    15 => "410083"
    16 => "410126"
    17 => "410127"
    18 => "410128"
    19 => "410170"
    20 => "410791"
    21 => "410333"
    22 => "410334"
    23 => "424505"
    24 => "410338"
    25 => "410339"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 2
    14 => 2
    15 => 2
    16 => 2
    17 => 2
    18 => 2
    19 => 2
    20 => 2
    21 => 2
    22 => 2
    23 => 2
    24 => 2
    25 => 2
  ]
]

[
  "sql" => """
    \n
                    SELECT\n
                        f.code AS feature_code,\n
                        COALESCE(\n
                            NULLIF(TRIM(pfv.value_text), ''),\n
                            NULLIF(TRIM(TRAILING '.' FROM TRIM(TRAILING '0' FROM CAST(pfv.value_number AS CHAR))), ''),\n
                            CASE\n
                                WHEN pfv.value_bool = 1 THEN 'Yes'\n
                                WHEN pfv.value_bool = 0 THEN 'No'\n
                                ELSE NULL\n
                            END,\n
                            fot.label\n
                        ) AS feature_value\n
                    FROM product_feature_value AS pfv\n
                    INNER JOIN feature AS f ON f.id = pfv.feature_id\n
                    LEFT JOIN feature_option_translation AS fot ON fot.option_id = pfv.option_id AND fot.lang_id = :lang_id\n
                    WHERE pfv.product_id = :product_id\n
                    ORDER BY pfv.feature_id ASC, pfv.option_id ASC\n
                
    """
  "params" => [
    "lang_id" => 2
    "product_id" => 25967
  ]
  "types" => []
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.video AS video_4, t0.product_id AS product_id_5, t0.lang_id AS lang_id_6 FROM products_texts t0 WHERE t0.product_id = ? AND t0.lang_id = ? LIMIT 1"
  "params" => [
    1 => 25967
    2 => 2
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => """
    \n
                    SELECT\n
                        f.code AS feature_code,\n
                        COALESCE(\n
                            NULLIF(TRIM(pfv.value_text), ''),\n
                            NULLIF(TRIM(TRAILING '.' FROM TRIM(TRAILING '0' FROM CAST(pfv.value_number AS CHAR))), ''),\n
                            CASE\n
                                WHEN pfv.value_bool = 1 THEN 'Yes'\n
                                WHEN pfv.value_bool = 0 THEN 'No'\n
                                ELSE NULL\n
                            END,\n
                            fot.label\n
                        ) AS feature_value\n
                    FROM product_feature_value AS pfv\n
                    INNER JOIN feature AS f ON f.id = pfv.feature_id\n
                    LEFT JOIN feature_option_translation AS fot ON fot.option_id = pfv.option_id AND fot.lang_id = :lang_id\n
                    WHERE pfv.product_id = :product_id\n
                    ORDER BY pfv.feature_id ASC, pfv.option_id ASC\n
                
    """
  "params" => [
    "lang_id" => 2
    "product_id" => 25872
  ]
  "types" => []
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.video AS video_4, t0.product_id AS product_id_5, t0.lang_id AS lang_id_6 FROM products_texts t0 WHERE t0.product_id = ? AND t0.lang_id = ? LIMIT 1"
  "params" => [
    1 => 25872
    2 => 2
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => """
    \n
                    SELECT\n
                        f.code AS feature_code,\n
                        COALESCE(\n
                            NULLIF(TRIM(pfv.value_text), ''),\n
                            NULLIF(TRIM(TRAILING '.' FROM TRIM(TRAILING '0' FROM CAST(pfv.value_number AS CHAR))), ''),\n
                            CASE\n
                                WHEN pfv.value_bool = 1 THEN 'Yes'\n
                                WHEN pfv.value_bool = 0 THEN 'No'\n
                                ELSE NULL\n
                            END,\n
                            fot.label\n
                        ) AS feature_value\n
                    FROM product_feature_value AS pfv\n
                    INNER JOIN feature AS f ON f.id = pfv.feature_id\n
                    LEFT JOIN feature_option_translation AS fot ON fot.option_id = pfv.option_id AND fot.lang_id = :lang_id\n
                    WHERE pfv.product_id = :product_id\n
                    ORDER BY pfv.feature_id ASC, pfv.option_id ASC\n
                
    """
  "params" => [
    "lang_id" => 2
    "product_id" => 25963
  ]
  "types" => []
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.video AS video_4, t0.product_id AS product_id_5, t0.lang_id AS lang_id_6 FROM products_texts t0 WHERE t0.product_id = ? AND t0.lang_id = ? LIMIT 1"
  "params" => [
    1 => 25963
    2 => 2
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => """
    \n
                    SELECT\n
                        f.code AS feature_code,\n
                        COALESCE(\n
                            NULLIF(TRIM(pfv.value_text), ''),\n
                            NULLIF(TRIM(TRAILING '.' FROM TRIM(TRAILING '0' FROM CAST(pfv.value_number AS CHAR))), ''),\n
                            CASE\n
                                WHEN pfv.value_bool = 1 THEN 'Yes'\n
                                WHEN pfv.value_bool = 0 THEN 'No'\n
                                ELSE NULL\n
                            END,\n
                            fot.label\n
                        ) AS feature_value\n
                    FROM product_feature_value AS pfv\n
                    INNER JOIN feature AS f ON f.id = pfv.feature_id\n
                    LEFT JOIN feature_option_translation AS fot ON fot.option_id = pfv.option_id AND fot.lang_id = :lang_id\n
                    WHERE pfv.product_id = :product_id\n
                    ORDER BY pfv.feature_id ASC, pfv.option_id ASC\n
                
    """
  "params" => [
    "lang_id" => 2
    "product_id" => 25865
  ]
  "types" => []
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.video AS video_4, t0.product_id AS product_id_5, t0.lang_id AS lang_id_6 FROM products_texts t0 WHERE t0.product_id = ? AND t0.lang_id = ? LIMIT 1"
  "params" => [
    1 => 25865
    2 => 2
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => """
    \n
                    SELECT\n
                        f.code AS feature_code,\n
                        COALESCE(\n
                            NULLIF(TRIM(pfv.value_text), ''),\n
                            NULLIF(TRIM(TRAILING '.' FROM TRIM(TRAILING '0' FROM CAST(pfv.value_number AS CHAR))), ''),\n
                            CASE\n
                                WHEN pfv.value_bool = 1 THEN 'Yes'\n
                                WHEN pfv.value_bool = 0 THEN 'No'\n
                                ELSE NULL\n
                            END,\n
                            fot.label\n
                        ) AS feature_value\n
                    FROM product_feature_value AS pfv\n
                    INNER JOIN feature AS f ON f.id = pfv.feature_id\n
                    LEFT JOIN feature_option_translation AS fot ON fot.option_id = pfv.option_id AND fot.lang_id = :lang_id\n
                    WHERE pfv.product_id = :product_id\n
                    ORDER BY pfv.feature_id ASC, pfv.option_id ASC\n
                
    """
  "params" => [
    "lang_id" => 2
    "product_id" => 25866
  ]
  "types" => []
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.video AS video_4, t0.product_id AS product_id_5, t0.lang_id AS lang_id_6 FROM products_texts t0 WHERE t0.product_id = ? AND t0.lang_id = ? LIMIT 1"
  "params" => [
    1 => 25866
    2 => 2
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => """
    \n
                    SELECT\n
                        f.code AS feature_code,\n
                        COALESCE(\n
                            NULLIF(TRIM(pfv.value_text), ''),\n
                            NULLIF(TRIM(TRAILING '.' FROM TRIM(TRAILING '0' FROM CAST(pfv.value_number AS CHAR))), ''),\n
                            CASE\n
                                WHEN pfv.value_bool = 1 THEN 'Yes'\n
                                WHEN pfv.value_bool = 0 THEN 'No'\n
                                ELSE NULL\n
                            END,\n
                            fot.label\n
                        ) AS feature_value\n
                    FROM product_feature_value AS pfv\n
                    INNER JOIN feature AS f ON f.id = pfv.feature_id\n
                    LEFT JOIN feature_option_translation AS fot ON fot.option_id = pfv.option_id AND fot.lang_id = :lang_id\n
                    WHERE pfv.product_id = :product_id\n
                    ORDER BY pfv.feature_id ASC, pfv.option_id ASC\n
                
    """
  "params" => [
    "lang_id" => 2
    "product_id" => 25867
  ]
  "types" => []
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.video AS video_4, t0.product_id AS product_id_5, t0.lang_id AS lang_id_6 FROM products_texts t0 WHERE t0.product_id = ? AND t0.lang_id = ? LIMIT 1"
  "params" => [
    1 => 25867
    2 => 2
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => """
    \n
                    SELECT\n
                        f.code AS feature_code,\n
                        COALESCE(\n
                            NULLIF(TRIM(pfv.value_text), ''),\n
                            NULLIF(TRIM(TRAILING '.' FROM TRIM(TRAILING '0' FROM CAST(pfv.value_number AS CHAR))), ''),\n
                            CASE\n
                                WHEN pfv.value_bool = 1 THEN 'Yes'\n
                                WHEN pfv.value_bool = 0 THEN 'No'\n
                                ELSE NULL\n
                            END,\n
                            fot.label\n
                        ) AS feature_value\n
                    FROM product_feature_value AS pfv\n
                    INNER JOIN feature AS f ON f.id = pfv.feature_id\n
                    LEFT JOIN feature_option_translation AS fot ON fot.option_id = pfv.option_id AND fot.lang_id = :lang_id\n
                    WHERE pfv.product_id = :product_id\n
                    ORDER BY pfv.feature_id ASC, pfv.option_id ASC\n
                
    """
  "params" => [
    "lang_id" => 2
    "product_id" => 25868
  ]
  "types" => []
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.video AS video_4, t0.product_id AS product_id_5, t0.lang_id AS lang_id_6 FROM products_texts t0 WHERE t0.product_id = ? AND t0.lang_id = ? LIMIT 1"
  "params" => [
    1 => 25868
    2 => 2
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => """
    \n
                    SELECT\n
                        f.code AS feature_code,\n
                        COALESCE(\n
                            NULLIF(TRIM(pfv.value_text), ''),\n
                            NULLIF(TRIM(TRAILING '.' FROM TRIM(TRAILING '0' FROM CAST(pfv.value_number AS CHAR))), ''),\n
                            CASE\n
                                WHEN pfv.value_bool = 1 THEN 'Yes'\n
                                WHEN pfv.value_bool = 0 THEN 'No'\n
                                ELSE NULL\n
                            END,\n
                            fot.label\n
                        ) AS feature_value\n
                    FROM product_feature_value AS pfv\n
                    INNER JOIN feature AS f ON f.id = pfv.feature_id\n
                    LEFT JOIN feature_option_translation AS fot ON fot.option_id = pfv.option_id AND fot.lang_id = :lang_id\n
                    WHERE pfv.product_id = :product_id\n
                    ORDER BY pfv.feature_id ASC, pfv.option_id ASC\n
                
    """
  "params" => [
    "lang_id" => 2
    "product_id" => 25961
  ]
  "types" => []
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.video AS video_4, t0.product_id AS product_id_5, t0.lang_id AS lang_id_6 FROM products_texts t0 WHERE t0.product_id = ? AND t0.lang_id = ? LIMIT 1"
  "params" => [
    1 => 25961
    2 => 2
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => """
    \n
                    SELECT\n
                        f.code AS feature_code,\n
                        COALESCE(\n
                            NULLIF(TRIM(pfv.value_text), ''),\n
                            NULLIF(TRIM(TRAILING '.' FROM TRIM(TRAILING '0' FROM CAST(pfv.value_number AS CHAR))), ''),\n
                            CASE\n
                                WHEN pfv.value_bool = 1 THEN 'Yes'\n
                                WHEN pfv.value_bool = 0 THEN 'No'\n
                                ELSE NULL\n
                            END,\n
                            fot.label\n
                        ) AS feature_value\n
                    FROM product_feature_value AS pfv\n
                    INNER JOIN feature AS f ON f.id = pfv.feature_id\n
                    LEFT JOIN feature_option_translation AS fot ON fot.option_id = pfv.option_id AND fot.lang_id = :lang_id\n
                    WHERE pfv.product_id = :product_id\n
                    ORDER BY pfv.feature_id ASC, pfv.option_id ASC\n
                
    """
  "params" => [
    "lang_id" => 2
    "product_id" => 25962
  ]
  "types" => []
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.video AS video_4, t0.product_id AS product_id_5, t0.lang_id AS lang_id_6 FROM products_texts t0 WHERE t0.product_id = ? AND t0.lang_id = ? LIMIT 1"
  "params" => [
    1 => 25962
    2 => 2
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => """
    \n
                    SELECT\n
                        f.code AS feature_code,\n
                        COALESCE(\n
                            NULLIF(TRIM(pfv.value_text), ''),\n
                            NULLIF(TRIM(TRAILING '.' FROM TRIM(TRAILING '0' FROM CAST(pfv.value_number AS CHAR))), ''),\n
                            CASE\n
                                WHEN pfv.value_bool = 1 THEN 'Yes'\n
                                WHEN pfv.value_bool = 0 THEN 'No'\n
                                ELSE NULL\n
                            END,\n
                            fot.label\n
                        ) AS feature_value\n
                    FROM product_feature_value AS pfv\n
                    INNER JOIN feature AS f ON f.id = pfv.feature_id\n
                    LEFT JOIN feature_option_translation AS fot ON fot.option_id = pfv.option_id AND fot.lang_id = :lang_id\n
                    WHERE pfv.product_id = :product_id\n
                    ORDER BY pfv.feature_id ASC, pfv.option_id ASC\n
                
    """
  "params" => [
    "lang_id" => 2
    "product_id" => 25932
  ]
  "types" => []
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.video AS video_4, t0.product_id AS product_id_5, t0.lang_id AS lang_id_6 FROM products_texts t0 WHERE t0.product_id = ? AND t0.lang_id = ? LIMIT 1"
  "params" => [
    1 => 25932
    2 => 2
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => """
    \n
                    SELECT\n
                        f.code AS feature_code,\n
                        COALESCE(\n
                            NULLIF(TRIM(pfv.value_text), ''),\n
                            NULLIF(TRIM(TRAILING '.' FROM TRIM(TRAILING '0' FROM CAST(pfv.value_number AS CHAR))), ''),\n
                            CASE\n
                                WHEN pfv.value_bool = 1 THEN 'Yes'\n
                                WHEN pfv.value_bool = 0 THEN 'No'\n
                                ELSE NULL\n
                            END,\n
                            fot.label\n
                        ) AS feature_value\n
                    FROM product_feature_value AS pfv\n
                    INNER JOIN feature AS f ON f.id = pfv.feature_id\n
                    LEFT JOIN feature_option_translation AS fot ON fot.option_id = pfv.option_id AND fot.lang_id = :lang_id\n
                    WHERE pfv.product_id = :product_id\n
                    ORDER BY pfv.feature_id ASC, pfv.option_id ASC\n
                
    """
  "params" => [
    "lang_id" => 2
    "product_id" => 25934
  ]
  "types" => []
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.video AS video_4, t0.product_id AS product_id_5, t0.lang_id AS lang_id_6 FROM products_texts t0 WHERE t0.product_id = ? AND t0.lang_id = ? LIMIT 1"
  "params" => [
    1 => 25934
    2 => 2
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => """
    \n
                    SELECT\n
                        f.code AS feature_code,\n
                        COALESCE(\n
                            NULLIF(TRIM(pfv.value_text), ''),\n
                            NULLIF(TRIM(TRAILING '.' FROM TRIM(TRAILING '0' FROM CAST(pfv.value_number AS CHAR))), ''),\n
                            CASE\n
                                WHEN pfv.value_bool = 1 THEN 'Yes'\n
                                WHEN pfv.value_bool = 0 THEN 'No'\n
                                ELSE NULL\n
                            END,\n
                            fot.label\n
                        ) AS feature_value\n
                    FROM product_feature_value AS pfv\n
                    INNER JOIN feature AS f ON f.id = pfv.feature_id\n
                    LEFT JOIN feature_option_translation AS fot ON fot.option_id = pfv.option_id AND fot.lang_id = :lang_id\n
                    WHERE pfv.product_id = :product_id\n
                    ORDER BY pfv.feature_id ASC, pfv.option_id ASC\n
                
    """
  "params" => [
    "lang_id" => 2
    "product_id" => 25949
  ]
  "types" => []
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.video AS video_4, t0.product_id AS product_id_5, t0.lang_id AS lang_id_6 FROM products_texts t0 WHERE t0.product_id = ? AND t0.lang_id = ? LIMIT 1"
  "params" => [
    1 => 25949
    2 => 2
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => """
    \n
                    SELECT\n
                        f.code AS feature_code,\n
                        COALESCE(\n
                            NULLIF(TRIM(pfv.value_text), ''),\n
                            NULLIF(TRIM(TRAILING '.' FROM TRIM(TRAILING '0' FROM CAST(pfv.value_number AS CHAR))), ''),\n
                            CASE\n
                                WHEN pfv.value_bool = 1 THEN 'Yes'\n
                                WHEN pfv.value_bool = 0 THEN 'No'\n
                                ELSE NULL\n
                            END,\n
                            fot.label\n
                        ) AS feature_value\n
                    FROM product_feature_value AS pfv\n
                    INNER JOIN feature AS f ON f.id = pfv.feature_id\n
                    LEFT JOIN feature_option_translation AS fot ON fot.option_id = pfv.option_id AND fot.lang_id = :lang_id\n
                    WHERE pfv.product_id = :product_id\n
                    ORDER BY pfv.feature_id ASC, pfv.option_id ASC\n
                
    """
  "params" => [
    "lang_id" => 2
    "product_id" => 25950
  ]
  "types" => []
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.video AS video_4, t0.product_id AS product_id_5, t0.lang_id AS lang_id_6 FROM products_texts t0 WHERE t0.product_id = ? AND t0.lang_id = ? LIMIT 1"
  "params" => [
    1 => 25950
    2 => 2
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => """
    \n
                    SELECT\n
                        f.code AS feature_code,\n
                        COALESCE(\n
                            NULLIF(TRIM(pfv.value_text), ''),\n
                            NULLIF(TRIM(TRAILING '.' FROM TRIM(TRAILING '0' FROM CAST(pfv.value_number AS CHAR))), ''),\n
                            CASE\n
                                WHEN pfv.value_bool = 1 THEN 'Yes'\n
                                WHEN pfv.value_bool = 0 THEN 'No'\n
                                ELSE NULL\n
                            END,\n
                            fot.label\n
                        ) AS feature_value\n
                    FROM product_feature_value AS pfv\n
                    INNER JOIN feature AS f ON f.id = pfv.feature_id\n
                    LEFT JOIN feature_option_translation AS fot ON fot.option_id = pfv.option_id AND fot.lang_id = :lang_id\n
                    WHERE pfv.product_id = :product_id\n
                    ORDER BY pfv.feature_id ASC, pfv.option_id ASC\n
                
    """
  "params" => [
    "lang_id" => 2
    "product_id" => 25951
  ]
  "types" => []
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.video AS video_4, t0.product_id AS product_id_5, t0.lang_id AS lang_id_6 FROM products_texts t0 WHERE t0.product_id = ? AND t0.lang_id = ? LIMIT 1"
  "params" => [
    1 => 25951
    2 => 2
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => """
    \n
                    SELECT\n
                        f.code AS feature_code,\n
                        COALESCE(\n
                            NULLIF(TRIM(pfv.value_text), ''),\n
                            NULLIF(TRIM(TRAILING '.' FROM TRIM(TRAILING '0' FROM CAST(pfv.value_number AS CHAR))), ''),\n
                            CASE\n
                                WHEN pfv.value_bool = 1 THEN 'Yes'\n
                                WHEN pfv.value_bool = 0 THEN 'No'\n
                                ELSE NULL\n
                            END,\n
                            fot.label\n
                        ) AS feature_value\n
                    FROM product_feature_value AS pfv\n
                    INNER JOIN feature AS f ON f.id = pfv.feature_id\n
                    LEFT JOIN feature_option_translation AS fot ON fot.option_id = pfv.option_id AND fot.lang_id = :lang_id\n
                    WHERE pfv.product_id = :product_id\n
                    ORDER BY pfv.feature_id ASC, pfv.option_id ASC\n
                
    """
  "params" => [
    "lang_id" => 2
    "product_id" => 25887
  ]
  "types" => []
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.video AS video_4, t0.product_id AS product_id_5, t0.lang_id AS lang_id_6 FROM products_texts t0 WHERE t0.product_id = ? AND t0.lang_id = ? LIMIT 1"
  "params" => [
    1 => 25887
    2 => 2
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => """
    \n
                    SELECT\n
                        f.code AS feature_code,\n
                        COALESCE(\n
                            NULLIF(TRIM(pfv.value_text), ''),\n
                            NULLIF(TRIM(TRAILING '.' FROM TRIM(TRAILING '0' FROM CAST(pfv.value_number AS CHAR))), ''),\n
                            CASE\n
                                WHEN pfv.value_bool = 1 THEN 'Yes'\n
                                WHEN pfv.value_bool = 0 THEN 'No'\n
                                ELSE NULL\n
                            END,\n
                            fot.label\n
                        ) AS feature_value\n
                    FROM product_feature_value AS pfv\n
                    INNER JOIN feature AS f ON f.id = pfv.feature_id\n
                    LEFT JOIN feature_option_translation AS fot ON fot.option_id = pfv.option_id AND fot.lang_id = :lang_id\n
                    WHERE pfv.product_id = :product_id\n
                    ORDER BY pfv.feature_id ASC, pfv.option_id ASC\n
                
    """
  "params" => [
    "lang_id" => 2
    "product_id" => 25953
  ]
  "types" => []
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.video AS video_4, t0.product_id AS product_id_5, t0.lang_id AS lang_id_6 FROM products_texts t0 WHERE t0.product_id = ? AND t0.lang_id = ? LIMIT 1"
  "params" => [
    1 => 25953
    2 => 2
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => """
    \n
                    SELECT\n
                        f.code AS feature_code,\n
                        COALESCE(\n
                            NULLIF(TRIM(pfv.value_text), ''),\n
                            NULLIF(TRIM(TRAILING '.' FROM TRIM(TRAILING '0' FROM CAST(pfv.value_number AS CHAR))), ''),\n
                            CASE\n
                                WHEN pfv.value_bool = 1 THEN 'Yes'\n
                                WHEN pfv.value_bool = 0 THEN 'No'\n
                                ELSE NULL\n
                            END,\n
                            fot.label\n
                        ) AS feature_value\n
                    FROM product_feature_value AS pfv\n
                    INNER JOIN feature AS f ON f.id = pfv.feature_id\n
                    LEFT JOIN feature_option_translation AS fot ON fot.option_id = pfv.option_id AND fot.lang_id = :lang_id\n
                    WHERE pfv.product_id = :product_id\n
                    ORDER BY pfv.feature_id ASC, pfv.option_id ASC\n
                
    """
  "params" => [
    "lang_id" => 2
    "product_id" => 25952
  ]
  "types" => []
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.video AS video_4, t0.product_id AS product_id_5, t0.lang_id AS lang_id_6 FROM products_texts t0 WHERE t0.product_id = ? AND t0.lang_id = ? LIMIT 1"
  "params" => [
    1 => 25952
    2 => 2
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => """
    \n
                    SELECT\n
                        f.code AS feature_code,\n
                        COALESCE(\n
                            NULLIF(TRIM(pfv.value_text), ''),\n
                            NULLIF(TRIM(TRAILING '.' FROM TRIM(TRAILING '0' FROM CAST(pfv.value_number AS CHAR))), ''),\n
                            CASE\n
                                WHEN pfv.value_bool = 1 THEN 'Yes'\n
                                WHEN pfv.value_bool = 0 THEN 'No'\n
                                ELSE NULL\n
                            END,\n
                            fot.label\n
                        ) AS feature_value\n
                    FROM product_feature_value AS pfv\n
                    INNER JOIN feature AS f ON f.id = pfv.feature_id\n
                    LEFT JOIN feature_option_translation AS fot ON fot.option_id = pfv.option_id AND fot.lang_id = :lang_id\n
                    WHERE pfv.product_id = :product_id\n
                    ORDER BY pfv.feature_id ASC, pfv.option_id ASC\n
                
    """
  "params" => [
    "lang_id" => 2
    "product_id" => 25935
  ]
  "types" => []
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.video AS video_4, t0.product_id AS product_id_5, t0.lang_id AS lang_id_6 FROM products_texts t0 WHERE t0.product_id = ? AND t0.lang_id = ? LIMIT 1"
  "params" => [
    1 => 25935
    2 => 2
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => """
    \n
                    SELECT\n
                        f.code AS feature_code,\n
                        COALESCE(\n
                            NULLIF(TRIM(pfv.value_text), ''),\n
                            NULLIF(TRIM(TRAILING '.' FROM TRIM(TRAILING '0' FROM CAST(pfv.value_number AS CHAR))), ''),\n
                            CASE\n
                                WHEN pfv.value_bool = 1 THEN 'Yes'\n
                                WHEN pfv.value_bool = 0 THEN 'No'\n
                                ELSE NULL\n
                            END,\n
                            fot.label\n
                        ) AS feature_value\n
                    FROM product_feature_value AS pfv\n
                    INNER JOIN feature AS f ON f.id = pfv.feature_id\n
                    LEFT JOIN feature_option_translation AS fot ON fot.option_id = pfv.option_id AND fot.lang_id = :lang_id\n
                    WHERE pfv.product_id = :product_id\n
                    ORDER BY pfv.feature_id ASC, pfv.option_id ASC\n
                
    """
  "params" => [
    "lang_id" => 2
    "product_id" => 25888
  ]
  "types" => []
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.video AS video_4, t0.product_id AS product_id_5, t0.lang_id AS lang_id_6 FROM products_texts t0 WHERE t0.product_id = ? AND t0.lang_id = ? LIMIT 1"
  "params" => [
    1 => 25888
    2 => 2
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => """
    \n
                    SELECT\n
                        f.code AS feature_code,\n
                        COALESCE(\n
                            NULLIF(TRIM(pfv.value_text), ''),\n
                            NULLIF(TRIM(TRAILING '.' FROM TRIM(TRAILING '0' FROM CAST(pfv.value_number AS CHAR))), ''),\n
                            CASE\n
                                WHEN pfv.value_bool = 1 THEN 'Yes'\n
                                WHEN pfv.value_bool = 0 THEN 'No'\n
                                ELSE NULL\n
                            END,\n
                            fot.label\n
                        ) AS feature_value\n
                    FROM product_feature_value AS pfv\n
                    INNER JOIN feature AS f ON f.id = pfv.feature_id\n
                    LEFT JOIN feature_option_translation AS fot ON fot.option_id = pfv.option_id AND fot.lang_id = :lang_id\n
                    WHERE pfv.product_id = :product_id\n
                    ORDER BY pfv.feature_id ASC, pfv.option_id ASC\n
                
    """
  "params" => [
    "lang_id" => 2
    "product_id" => 25889
  ]
  "types" => []
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.video AS video_4, t0.product_id AS product_id_5, t0.lang_id AS lang_id_6 FROM products_texts t0 WHERE t0.product_id = ? AND t0.lang_id = ? LIMIT 1"
  "params" => [
    1 => 25889
    2 => 2
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "App\EventListener\RequestListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Csrf\SameOriginCsrfTokenManager::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse"
]

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

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse"
]

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

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

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

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

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

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

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

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

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets"
]

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