Symfony Profiler

[
  "route" => "capteurs_pesage"
  "route_parameters" => [
    "_route" => "capteurs_pesage"
    "_controller" => "App\Controller\ProduitsController::capteurs_pesage"
    "_locale" => "fr"
  ]
  "request_uri" => "http://sensy.adevo-host.net/fr/capteurs-de-pesage"
  "method" => "GET"
]

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

[
  "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\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.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

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

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController"
]

[
  "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" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "sensy"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "sensy"
    "serverVersion" => "mariadb-10.11.6"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => """
    SELECT * FROM pre2398_category_lang l\n
                    INNER JOIN pre2398_category c ON l.id_category = c.id_category  \n
                    WHERE l.link_rewrite = 'capteurs-de-pesage' AND l.id_lang = '1'
    """
  "params" => []
  "types" => []
]

[
  "sql" => """
    \n
                SELECT \n
                    p.id_product AS id_product,\n
                    p.id_category_default AS category_default,\n
                    p.reference AS reference,\n
                    l.link_rewrite AS link_rewrite,\n
                    l.name AS name,\n
                    l.description_short AS description,\n
                    i1.id_image AS id_image1,\n
                    i2.id_image AS id_image2,\n
                    il1.legend AS legend1,\n
                    il2.legend AS legend2,\n
                    a.file_name AS file_name,\n
    \n
                    -- Sub-query for suppliers\n
                    (SELECT GROUP_CONCAT(DISTINCT s.name ORDER BY s.name)\n
                        FROM pre2398_supplier s\n
                        INNER JOIN pre2398_product_supplier ps ON s.id_supplier = ps.id_supplier\n
                        WHERE ps.id_product = p.id_product\n
                    ) AS suppliers,\n
    \n
                    (SELECT GROUP_CONCAT(DISTINCT s.id_supplier ORDER BY s.id_supplier)\n
                        FROM pre2398_supplier s\n
                        INNER JOIN pre2398_product_supplier ps ON s.id_supplier = ps.id_supplier\n
                        WHERE ps.id_product = p.id_product\n
                    ) AS id_suppliers,\n
    \n
                    -- Sub-query for attribute cap\n
                    (SELECT GROUP_CONCAT(DISTINCT pattrl4.id_attribute ORDER BY pattrl4.id_attribute)\n
                        FROM pre2398_layered_product_attribute lpa4\n
                        INNER JOIN pre2398_attribute_lang pattrl4 ON pattrl4.id_attribute = lpa4.id_attribute\n
                        WHERE lpa4.id_product = p.id_product\n
                        AND lpa4.id_attribute_group = 4\n
                        AND pattrl4.id_lang = :id_lang\n
                    ) AS id_attr_cap,\n
    \n
                    (SELECT GROUP_CONCAT(DISTINCT pattrl4.name ORDER BY pattrl4.name)\n
                    FROM pre2398_layered_product_attribute lpa4\n
                    INNER JOIN pre2398_attribute_lang pattrl4 ON pattrl4.id_attribute = lpa4.id_attribute\n
                    WHERE lpa4.id_product = p.id_product\n
                    AND lpa4.id_attribute_group = 4\n
                    AND pattrl4.id_lang = :id_lang\n
                    ) AS attr_cap,\n
    \n
                    -- Sub-query for attribute prec\n
                    (SELECT GROUP_CONCAT(DISTINCT pattrl5.id_attribute ORDER BY pattrl5.id_attribute)\n
                    FROM pre2398_layered_product_attribute lpa5\n
                    INNER JOIN pre2398_attribute_lang pattrl5 ON pattrl5.id_attribute = lpa5.id_attribute\n
                    WHERE lpa5.id_product = p.id_product\n
                    AND lpa5.id_attribute_group = 5\n
                    AND pattrl5.id_lang = :id_lang\n
                    ) AS id_attr_prec,\n
    \n
                    (SELECT GROUP_CONCAT(DISTINCT pattrl5.name ORDER BY pattrl5.name)\n
                    FROM pre2398_layered_product_attribute lpa5\n
                    INNER JOIN pre2398_attribute_lang pattrl5 ON pattrl5.id_attribute = lpa5.id_attribute\n
                    WHERE lpa5.id_product = p.id_product\n
                    AND lpa5.id_attribute_group = 5\n
                    AND pattrl5.id_lang = :id_lang\n
                    ) AS attr_prec,\n
    \n
                    -- Sub-query for features\n
                    (SELECT GROUP_CONCAT(DISTINCT fp.id_feature_value ORDER BY fp.id_feature_value)\n
                    FROM pre2398_feature_product fp\n
                    WHERE fp.id_product = p.id_product\n
                    ) AS id_feat\n
    \n
                FROM pre2398_product p\n
                INNER JOIN pre2398_category_product cp ON cp.id_product = p.id_product AND cp.id_category = :category\n
                LEFT JOIN pre2398_product_lang l ON p.id_product = l.id_product AND l.id_lang = :id_lang\n
                LEFT JOIN pre2398_image i1 ON p.id_product = i1.id_product AND i1.position = 1\n
                LEFT JOIN pre2398_image i2 ON p.id_product = i2.id_product AND i2.position = 2\n
                LEFT JOIN pre2398_image_lang il1 ON il1.id_image = i1.id_image AND il1.id_lang = :id_lang\n
                LEFT JOIN pre2398_image_lang il2 ON il2.id_image = i2.id_image AND il2.id_lang = :id_lang\n
                LEFT JOIN pre2398_product_attachment pa ON pa.id_product = p.id_product\n
                LEFT JOIN pre2398_attachment a ON a.id_attachment = pa.id_attachment AND a.file_name LIKE :file_name\n
    \n
                WHERE a.category = 'Datasheets'\n
                GROUP BY p.id_product\n
                ORDER BY p.id_product
    """
  "params" => [
    "category" => 13
    "id_lang" => 1
    "file_name" => "%fr%"
  ]
  "types" => [
    "category" => 2
    "id_lang" => 2
    "file_name" => 2
  ]
]

[
  "sql" => """
    SELECT DISTINCT \n
                al.name as name,\n
                lpa.id_attribute as id_attribute,\n
                lpa.id_attribute_group as id_attribute_group,\n
                COUNT(p.id_product) as product_count\n
            FROM pre2398_product p\n
            INNER JOIN pre2398_category_product cp ON cp.id_product = p.id_product AND cp.id_category = '13' AND p.active = 1\n
            INNER JOIN pre2398_layered_product_attribute lpa ON lpa.id_product = p.id_product\n
            INNER JOIN pre2398_attribute_lang al ON al.id_attribute = lpa.id_attribute AND al.id_lang = '1'\n
            INNER JOIN pre2398_attribute a ON a.id_attribute = lpa.id_attribute\n
            WHERE al.id_lang = '1'\n
            GROUP BY lpa.id_attribute \n
            ORDER BY a.position
    """
  "params" => []
  "types" => []
]

[
  "sql" => """
    SELECT DISTINCT \n
                fvl.value AS value,\n
                fp.id_feature_value AS id_feature,\n
                COUNT(p.id_product) AS product_count\n
            FROM pre2398_product p\n
            INNER JOIN pre2398_category_product cp ON cp.id_product = p.id_product AND cp.id_category = '13'\n
            INNER JOIN pre2398_feature_product fp ON fp.id_product = p.id_product\n
            INNER JOIN pre2398_feature_value_lang fvl ON fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = '1'\n
            INNER JOIN pre2398_feature f ON f.id_feature = fp.id_feature AND f.position = 0\n
            WHERE fvl.id_lang = '1'\n
            GROUP BY fp.id_feature_value\n
            ORDER BY fvl.value
    """
  "params" => []
  "types" => []
]

[
  "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" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::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\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]