Symfony Profiler

[
  "route" => "app_catalog_dismantled_vehicle_show"
  "route_parameters" => [
    "_route" => "app_catalog_dismantled_vehicle_show"
    "slug" => "ford-ford-f-150-2015-3500-gasoline"
    "_controller" => "App\Controller\Catalog\DismantledVehiclePublicController::show"
    "_locale" => "en"
    "id" => "19"
  ]
  "request_uri" => "http://88.99.167.175/en/dismantled-vehicles/19-ford-ford-f-150-2015-3500-gasoline"
  "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 d0_.id AS id_0, d0_.description AS description_1, d0_.year AS year_2, d0_.engine_volume AS engine_volume_3, d0_.drivetrain AS drivetrain_4, d0_.fuel_type AS fuel_type_5, d0_.transmission_type AS transmission_type_6, d0_.vin AS vin_7, d0_.stock_number AS stock_number_8, d0_.slug AS slug_9, d0_.address AS address_10, d0_.created_at AS created_at_11, d1_.id AS id_12, d1_.image_name AS image_name_13, d1_.sort_order AS sort_order_14, m2_.id AS id_15, m2_.name AS name_16, m2_.slug AS slug_17, m2_.ext_source AS ext_source_18, m2_.ext_id AS ext_id_19, m3_.id AS id_20, m3_.name AS name_21, m3_.slug AS slug_22, m3_.ext_id AS ext_id_23, v4_.id AS id_24, v4_.year_from AS year_from_25, v4_.year_to AS year_to_26, v4_.generation_name AS generation_name_27, a5_.id AS id_28, a5_.name AS name_29, a5_.slug AS slug_30, a5_.description AS description_31, a5_.street_address AS street_address_32, a5_.address_line2 AS address_line2_33, a5_.city AS city_34, a5_.state AS state_35, a5_.postal_code AS postal_code_36, a5_.country_code AS country_code_37, a5_.latitude AS latitude_38, a5_.longitude AS longitude_39, a5_.created_at AS created_at_40, a6_.id AS id_41, a6_.label AS label_42, a6_.phone_number AS phone_number_43, a6_.comment AS comment_44, a6_.position AS position_45, d7_.id AS id_46, d7_.label AS label_47, d7_.phone_number AS phone_number_48, d7_.comment AS comment_49, d7_.position AS position_50, d0_.owner_id AS owner_id_51, d0_.make_id AS make_id_52, d0_.model_id AS model_id_53, d0_.vehicle_range_id AS vehicle_range_id_54, d0_.auto_dismantling_id AS auto_dismantling_id_55, d1_.vehicle_id AS vehicle_id_56, m3_.make_id AS make_id_57, v4_.model_id AS model_id_58, a5_.owner_id AS owner_id_59, a6_.dismantling_id AS dismantling_id_60, d7_.vehicle_id AS vehicle_id_61 FROM dismantled_vehicles d0_ LEFT JOIN dismantled_vehicle_photos d1_ ON d0_.id = d1_.vehicle_id LEFT JOIN makes m2_ ON d0_.make_id = m2_.id LEFT JOIN models m3_ ON d0_.model_id = m3_.id LEFT JOIN vehicle_ranges v4_ ON d0_.vehicle_range_id = v4_.id LEFT JOIN auto_dismantlings a5_ ON d0_.auto_dismantling_id = a5_.id LEFT JOIN auto_dismantling_phones a6_ ON a5_.id = a6_.dismantling_id LEFT JOIN dismantled_vehicle_phones d7_ ON d0_.id = d7_.vehicle_id WHERE d0_.id = ? ORDER BY a6_.position ASC, a6_.id ASC, d7_.position ASC, d7_.id ASC"
  "params" => [
    1 => 19
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0 FROM part_listings p0_ INNER JOIN users u1_ ON p0_.owner_id = u1_.id INNER JOIN company_profiles c2_ ON u1_.id = c2_.user_id WHERE p0_.dismantled_vehicle_id = ? AND p0_.status = ? AND c2_.status = ? AND p0_.quantity > 0 ORDER BY p0_.created_at DESC LIMIT 8"
  "params" => [
    1 => 19
    2 => "active"
    3 => "active"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.short_description AS short_description_1, p0_.slug AS slug_2, p0_.full_description AS full_description_3, p0_.tags AS tags_4, p0_.catalog_number AS catalog_number_5, p0_.oem_number AS oem_number_6, p0_.article_number AS article_number_7, p0_.condition_type AS condition_type_8, p0_.price AS price_9, p0_.price_new AS price_new_10, p0_.quantity AS quantity_11, p0_.status AS status_12, p0_.created_at AS created_at_13, p1_.id AS id_14, p1_.image_name AS image_name_15, p1_.sort_order AS sort_order_16, u2_.id AS id_17, u2_.email AS email_18, u2_.roles AS roles_19, u2_.password AS password_20, u2_.is_verified AS is_verified_21, u2_.phone AS phone_22, u2_.address_line1 AS address_line1_23, u2_.address_line2 AS address_line2_24, u2_.city AS city_25, u2_.state AS state_26, u2_.postal_code AS postal_code_27, u2_.is_company AS is_company_28, c3_.id AS id_29, c3_.company_name AS company_name_30, c3_.logo_name AS logo_name_31, c3_.ein AS ein_32, c3_.status AS status_33, c3_.submitted_at AS submitted_at_34, c3_.reviewed_at AS reviewed_at_35, p4_.id AS id_36, p4_.name AS name_37, p4_.slug AS slug_38, p4_.image_name AS image_name_39, m5_.id AS id_40, m5_.name AS name_41, m5_.slug AS slug_42, m5_.ext_source AS ext_source_43, m5_.ext_id AS ext_id_44, m6_.id AS id_45, m6_.name AS name_46, m6_.slug AS slug_47, m6_.ext_id AS ext_id_48, p0_.owner_id AS owner_id_49, p0_.make_id AS make_id_50, p0_.model_id AS model_id_51, p0_.vehicle_range_id AS vehicle_range_id_52, p0_.part_category_id AS part_category_id_53, p0_.dismantled_vehicle_id AS dismantled_vehicle_id_54, p1_.listing_id AS listing_id_55, c3_.user_id AS user_id_56, p4_.parent_id AS parent_id_57, m6_.make_id AS make_id_58 FROM part_listings p0_ LEFT JOIN part_listing_images p1_ ON p0_.id = p1_.listing_id INNER JOIN users u2_ ON p0_.owner_id = u2_.id INNER JOIN company_profiles c3_ ON u2_.id = c3_.user_id LEFT JOIN part_categories p4_ ON p0_.part_category_id = p4_.id LEFT JOIN makes m5_ ON p0_.make_id = m5_.id LEFT JOIN models m6_ ON p0_.model_id = m6_.id WHERE p0_.status = ? AND c3_.status = ? AND p0_.quantity > 0 AND p0_.id IN (?)"
  "params" => [
    1 => "active"
    2 => "active"
    3 => 52
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM part_listings p0_ INNER JOIN users u1_ ON p0_.owner_id = u1_.id INNER JOIN company_profiles c2_ ON u1_.id = c2_.user_id WHERE p0_.dismantled_vehicle_id = ? AND p0_.status = ? AND c2_.status = ? AND p0_.quantity > 0"
  "params" => [
    1 => 19
    2 => "active"
    3 => "active"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT p0_.part_category_id AS sclr_0, COUNT(p0_.id) AS sclr_1 FROM part_listings p0_ INNER JOIN users u1_ ON p0_.owner_id = u1_.id INNER JOIN company_profiles c2_ ON u1_.id = c2_.user_id WHERE p0_.dismantled_vehicle_id = ? AND p0_.status = ? AND c2_.status = ? AND p0_.quantity > 0 AND p0_.part_category_id IS NOT NULL GROUP BY p0_.part_category_id"
  "params" => [
    1 => 19
    2 => "active"
    3 => "active"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_name AS image_name_4, t0.parent_id AS parent_id_5 FROM part_categories t0 ORDER BY t0.name ASC"
]

[
  "sql" => "SELECT COUNT(d0_.id) AS sclr_0 FROM dismantled_vehicles d0_ LEFT JOIN makes m1_ ON d0_.make_id = m1_.id LEFT JOIN models m2_ ON d0_.model_id = m2_.id WHERE m1_.id = ? AND m2_.id = ? AND d0_.id <> ?"
  "params" => [
    1 => 117
    2 => 1472
    3 => 19
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
  ]
]

[
  "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"
]