Symfony Profiler

[
  "route" => "app_catalog_seller_reviews"
  "route_parameters" => [
    "_route" => "app_catalog_seller_reviews"
    "_controller" => "App\Controller\Catalog\SellerCatalogController::reviews"
    "_locale" => "en"
    "id" => "1"
    "slug" => "llc-grabsters"
  ]
  "request_uri" => "http://88.99.167.175/en/catalog/sellers/1-llc-grabsters/reviews"
  "method" => "GET"
]

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

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

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

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

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

[
  "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\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.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\IsGrantedAttributeListener::onKernelControllerArguments"
]

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

[
  "event" => "kernel.controller_arguments"
  "listener" => "ContainerRNdqT80\RequestPayloadValueResolverGhost3590451::onKernelControllerArguments"
]

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

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "host" => "localhost"
    "port" => 3306
    "user" => "autoparts_user"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "autoparts"
    "serverVersion" => "8.0"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.is_verified AS is_verified_4, u0_.phone AS phone_5, u0_.address_line1 AS address_line1_6, u0_.address_line2 AS address_line2_7, u0_.city AS city_8, u0_.state AS state_9, u0_.postal_code AS postal_code_10, u0_.is_company AS is_company_11, c1_.id AS id_12, c1_.company_name AS company_name_13, c1_.logo_name AS logo_name_14, c1_.ein AS ein_15, c1_.status AS status_16, c1_.submitted_at AS submitted_at_17, c1_.reviewed_at AS reviewed_at_18, c1_.user_id AS user_id_19 FROM users u0_ INNER JOIN company_profiles c1_ ON u0_.id = c1_.user_id WHERE u0_.id = ? AND c1_.status = ?"
  "params" => [
    1 => 1
    2 => "active"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT COUNT(s0_.id) AS sclr_0 FROM seller_reviews s0_ INNER JOIN users u1_ ON s0_.seller_id = u1_.id WHERE u1_.id = ? AND s0_.status = ?"
  "params" => [
    1 => 1
    2 => "active"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.rating AS rating_1, s0_.message AS message_2, s0_.status AS status_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.reviewed_at AS reviewed_at_6, u1_.id AS id_7, u1_.email AS email_8, u1_.roles AS roles_9, u1_.password AS password_10, u1_.is_verified AS is_verified_11, u1_.phone AS phone_12, u1_.address_line1 AS address_line1_13, u1_.address_line2 AS address_line2_14, u1_.city AS city_15, u1_.state AS state_16, u1_.postal_code AS postal_code_17, u1_.is_company AS is_company_18, u2_.id AS id_19, u2_.email AS email_20, u2_.roles AS roles_21, u2_.password AS password_22, u2_.is_verified AS is_verified_23, u2_.phone AS phone_24, u2_.address_line1 AS address_line1_25, u2_.address_line2 AS address_line2_26, u2_.city AS city_27, u2_.state AS state_28, u2_.postal_code AS postal_code_29, u2_.is_company AS is_company_30, o3_.id AS id_31, o3_.order_index AS order_index_32, o3_.delivery_address AS delivery_address_33, o3_.phone AS phone_34, o3_.email AS email_35, o3_.delivery_method AS delivery_method_36, o3_.delivery_price AS delivery_price_37, o3_.subtotal AS subtotal_38, o3_.total AS total_39, o3_.status AS status_40, o3_.created_at AS created_at_41, s0_.order_id AS order_id_42, s0_.buyer_id AS buyer_id_43, s0_.seller_id AS seller_id_44, o3_.buyer_id AS buyer_id_45 FROM seller_reviews s0_ INNER JOIN users u1_ ON s0_.buyer_id = u1_.id INNER JOIN users u2_ ON s0_.seller_id = u2_.id INNER JOIN `orders` o3_ ON s0_.order_id = o3_.id WHERE u2_.id = ? AND s0_.status = ? ORDER BY s0_.created_at DESC LIMIT 20"
  "params" => [
    1 => 1
    2 => "active"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.logo_name AS logo_name_3, t0.ein AS ein_4, t0.status AS status_5, t0.submitted_at AS submitted_at_6, t0.reviewed_at AS reviewed_at_7, t0.user_id AS user_id_8 FROM company_profiles t0 WHERE t0.user_id = ?"
  "params" => [
    1 => 10
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT COALESCE(AVG(s0_.rating), 0) AS sclr_0 FROM seller_reviews s0_ INNER JOIN users u1_ ON s0_.seller_id = u1_.id WHERE u1_.id = ? AND s0_.status = ?"
  "params" => [
    1 => 1
    2 => "active"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::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\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]