Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• EasyAdmin
• Configuration

Log Messages

"app_catalog_listing"

[
  "route" => "app_catalog_listing"
  "route_parameters" => [
    "_route" => "app_catalog_listing"
    "_controller" => "App\Controller\CatalogController::listing"
  ]
  "request_uri" => "https://cars.monkaidev.com/catalog?featured=1"
  "method" => "GET"
]

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

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

[
  "driver" => "pdo_mysql"
  "idle_connection_ttl" => 600
  "host" => "127.0.0.1"
  "port" => 3306
  "user" => "usr_monkai"
  "password" => "<redacted>"
  "driverOptions" => []
  "defaultTableOptions" => []
  "dbname" => "carsmonkai"
  "serverVersion" => "8.0.32"
  "charset" => "utf8mb4"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "usr_monkai"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "carsmonkai"
    "serverVersion" => "8.0.32"
    "charset" => "utf8mb4"
  ]
]

"SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.address AS address_4, t0.phone AS phone_5, t0.whatsapp AS whatsapp_6, t0.instagram AS instagram_7, t0.email AS email_8, t0.primary_color AS primary_color_9, t0.banner AS banner_10, t0.privacy AS privacy_11, t0.terms AS terms_12, t0.hero_video AS hero_video_13, t0.popup_enabled AS popup_enabled_14, t0.popup_side_text AS popup_side_text_15, t0.popup_title AS popup_title_16, t0.popup_description AS popup_description_17 FROM company t0 LIMIT 1"

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.address AS address_4, t0.phone AS phone_5, t0.whatsapp AS whatsapp_6, t0.instagram AS instagram_7, t0.email AS email_8, t0.primary_color AS primary_color_9, t0.banner AS banner_10, t0.privacy AS privacy_11, t0.terms AS terms_12, t0.hero_video AS hero_video_13, t0.popup_enabled AS popup_enabled_14, t0.popup_side_text AS popup_side_text_15, t0.popup_title AS popup_title_16, t0.popup_description AS popup_description_17 FROM company t0 LIMIT 1"
]

"SELECT COUNT(v0_.id) AS sclr_0 FROM vehicle v0_ WHERE v0_.published = ? AND v0_.featured = ? ORDER BY v0_.created_at DESC"

[
  1 => 1
  2 => 1
]

[
  1 => Doctrine\DBAL\ParameterType {#1132
    +name: "BOOLEAN"
  }
  2 => Doctrine\DBAL\ParameterType {#1132}
]

[
  "sql" => "SELECT COUNT(v0_.id) AS sclr_0 FROM vehicle v0_ WHERE v0_.published = ? AND v0_.featured = ? ORDER BY v0_.created_at DESC"
  "params" => [
    1 => 1
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1132
      +name: "BOOLEAN"
    }
    2 => Doctrine\DBAL\ParameterType {#1132}
  ]
]

"SELECT v0_.id AS id_0, v0_.brand AS brand_1, v0_.model AS model_2, v0_.year AS year_3, v0_.version AS version_4, v0_.type AS type_5, v0_.price_purchase AS price_purchase_6, v0_.price_sale AS price_sale_7, v0_.consignment_price AS consignment_price_8, v0_.commission AS commission_9, v0_.status AS status_10, v0_.published AS published_11, v0_.featured AS featured_12, v0_.is_unique AS is_unique_13, v0_.stock AS stock_14, v0_.mileage AS mileage_15, v0_.vehicle_condition AS vehicle_condition_16, v0_.fuel_type AS fuel_type_17, v0_.transmission AS transmission_18, v0_.color AS color_19, v0_.description AS description_20, v0_.images AS images_21, v0_.location AS location_22, v0_.currency AS currency_23, v0_.license_plate AS license_plate_24, v0_.engine_number AS engine_number_25, v0_.chassis_number AS chassis_number_26, v0_.registration_date AS registration_date_27, v0_.slug AS slug_28, v0_.tire_type AS tire_type_29, v0_.created_at AS created_at_30, v0_.updated_at AS updated_at_31, v0_.provider_id AS provider_id_32, v0_.owner_id AS owner_id_33 FROM vehicle v0_ WHERE v0_.published = ? AND v0_.featured = ? ORDER BY v0_.created_at DESC LIMIT 9"

[
  1 => 1
  2 => 1
]

[
  1 => Doctrine\DBAL\ParameterType {#1132
    +name: "BOOLEAN"
  }
  2 => Doctrine\DBAL\ParameterType {#1132}
]

[
  "sql" => "SELECT v0_.id AS id_0, v0_.brand AS brand_1, v0_.model AS model_2, v0_.year AS year_3, v0_.version AS version_4, v0_.type AS type_5, v0_.price_purchase AS price_purchase_6, v0_.price_sale AS price_sale_7, v0_.consignment_price AS consignment_price_8, v0_.commission AS commission_9, v0_.status AS status_10, v0_.published AS published_11, v0_.featured AS featured_12, v0_.is_unique AS is_unique_13, v0_.stock AS stock_14, v0_.mileage AS mileage_15, v0_.vehicle_condition AS vehicle_condition_16, v0_.fuel_type AS fuel_type_17, v0_.transmission AS transmission_18, v0_.color AS color_19, v0_.description AS description_20, v0_.images AS images_21, v0_.location AS location_22, v0_.currency AS currency_23, v0_.license_plate AS license_plate_24, v0_.engine_number AS engine_number_25, v0_.chassis_number AS chassis_number_26, v0_.registration_date AS registration_date_27, v0_.slug AS slug_28, v0_.tire_type AS tire_type_29, v0_.created_at AS created_at_30, v0_.updated_at AS updated_at_31, v0_.provider_id AS provider_id_32, v0_.owner_id AS owner_id_33 FROM vehicle v0_ WHERE v0_.published = ? AND v0_.featured = ? ORDER BY v0_.created_at DESC LIMIT 9"
  "params" => [
    1 => 1
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1132
      +name: "BOOLEAN"
    }
    2 => Doctrine\DBAL\ParameterType {#1132}
  ]
]

"SELECT MIN(v0_.price_sale) AS sclr_0, MAX(v0_.price_sale) AS sclr_1 FROM vehicle v0_ WHERE v0_.published = ?"

[
  1 => 1
]

[
  1 => Doctrine\DBAL\ParameterType {#1132
    +name: "BOOLEAN"
  }
]

[
  "sql" => "SELECT MIN(v0_.price_sale) AS sclr_0, MAX(v0_.price_sale) AS sclr_1 FROM vehicle v0_ WHERE v0_.published = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1132
      +name: "BOOLEAN"
    }
  ]
]

"SELECT DISTINCT v0_.brand AS brand_0 FROM vehicle v0_ WHERE v0_.published = ? ORDER BY v0_.brand ASC"

[
  1 => 1
]

[
  1 => Doctrine\DBAL\ParameterType {#1132
    +name: "BOOLEAN"
  }
]

[
  "sql" => "SELECT DISTINCT v0_.brand AS brand_0 FROM vehicle v0_ WHERE v0_.published = ? ORDER BY v0_.brand ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1132
      +name: "BOOLEAN"
    }
  ]
]

"SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.address AS address_4, t0.phone AS phone_5, t0.whatsapp AS whatsapp_6, t0.instagram AS instagram_7, t0.email AS email_8, t0.primary_color AS primary_color_9, t0.banner AS banner_10, t0.privacy AS privacy_11, t0.terms AS terms_12, t0.hero_video AS hero_video_13, t0.popup_enabled AS popup_enabled_14, t0.popup_side_text AS popup_side_text_15, t0.popup_title AS popup_title_16, t0.popup_description AS popup_description_17 FROM company t0 LIMIT 1"

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.address AS address_4, t0.phone AS phone_5, t0.whatsapp AS whatsapp_6, t0.instagram AS instagram_7, t0.email AS email_8, t0.primary_color AS primary_color_9, t0.banner AS banner_10, t0.privacy AS privacy_11, t0.terms AS terms_12, t0.hero_video AS hero_video_13, t0.popup_enabled AS popup_enabled_14, t0.popup_side_text AS popup_side_text_15, t0.popup_title AS popup_title_16, t0.popup_description AS popup_description_17 FROM company t0 LIMIT 1"
]

"SELECT DISTINCT v0_.type AS type_0 FROM vehicle v0_"

[
  "sql" => "SELECT DISTINCT v0_.type AS type_0 FROM vehicle v0_"
]

"SELECT t0.id AS id_1, t0.brand AS brand_2, t0.model AS model_3, t0.year AS year_4, t0.version AS version_5, t0.type AS type_6, t0.price_purchase AS price_purchase_7, t0.price_sale AS price_sale_8, t0.consignment_price AS consignment_price_9, t0.commission AS commission_10, t0.status AS status_11, t0.published AS published_12, t0.featured AS featured_13, t0.is_unique AS is_unique_14, t0.stock AS stock_15, t0.mileage AS mileage_16, t0.vehicle_condition AS vehicle_condition_17, t0.fuel_type AS fuel_type_18, t0.transmission AS transmission_19, t0.color AS color_20, t0.description AS description_21, t0.images AS images_22, t0.location AS location_23, t0.currency AS currency_24, t0.license_plate AS license_plate_25, t0.engine_number AS engine_number_26, t0.chassis_number AS chassis_number_27, t0.registration_date AS registration_date_28, t0.slug AS slug_29, t0.tire_type AS tire_type_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.provider_id AS provider_id_33, t0.owner_id AS owner_id_34 FROM vehicle t0"

[
  "sql" => "SELECT t0.id AS id_1, t0.brand AS brand_2, t0.model AS model_3, t0.year AS year_4, t0.version AS version_5, t0.type AS type_6, t0.price_purchase AS price_purchase_7, t0.price_sale AS price_sale_8, t0.consignment_price AS consignment_price_9, t0.commission AS commission_10, t0.status AS status_11, t0.published AS published_12, t0.featured AS featured_13, t0.is_unique AS is_unique_14, t0.stock AS stock_15, t0.mileage AS mileage_16, t0.vehicle_condition AS vehicle_condition_17, t0.fuel_type AS fuel_type_18, t0.transmission AS transmission_19, t0.color AS color_20, t0.description AS description_21, t0.images AS images_22, t0.location AS location_23, t0.currency AS currency_24, t0.license_plate AS license_plate_25, t0.engine_number AS engine_number_26, t0.chassis_number AS chassis_number_27, t0.registration_date AS registration_date_28, t0.slug AS slug_29, t0.tire_type AS tire_type_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.provider_id AS provider_id_33, t0.owner_id AS owner_id_34 FROM vehicle t0"
]

"SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.installments_count AS installments_count_4, t0.initial_price AS initial_price_5, t0.subscriber_limit AS subscriber_limit_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM plan t0 WHERE t0.is_active = ? ORDER BY t0.created_at DESC"

[
  1 => 1
]

[
  1 => Doctrine\DBAL\ParameterType {#1132
    +name: "BOOLEAN"
  }
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.installments_count AS installments_count_4, t0.initial_price AS initial_price_5, t0.subscriber_limit AS subscriber_limit_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM plan t0 WHERE t0.is_active = ? ORDER BY t0.created_at DESC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1132
      +name: "BOOLEAN"
    }
  ]
]