Symfony Profiler

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

Log Messages

[
  "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#15
    +count: 40
    -severity: E_WARNING
    trace: {
      /home/axhbxiq/crm/vendor/symfony/error-handler/DebugClassLoader.php:318 {
        Symfony\Component\ErrorHandler\DebugClassLoader->loadClass(string $class): void …
        ›     // no-op
        › } elseif (\function_exists('opcache_is_script_cached') && @opcache_is_script_cached($file)) {
        ›     include $file;
      }
      /home/axhbxiq/crm/vendor/doctrine/doctrine-bundle/src/DoctrineBundle.php:136 {
        › 
        ›     $this->autoloader = Autoloader::register($dir, $namespace, $proxyGenerator);
        › }
      }
    }
  }
]

{
  /home/axhbxiq/crm/vendor/symfony/error-handler/DebugClassLoader.php:318 {
    Symfony\Component\ErrorHandler\DebugClassLoader->loadClass(string $class): void …
    ›     // no-op
    › } elseif (\function_exists('opcache_is_script_cached') && @opcache_is_script_cached($file)) {
    ›     include $file;
  }
  /home/axhbxiq/crm/vendor/doctrine/doctrine-bundle/src/DoctrineBundle.php:136 {
    › 
    ›     $this->autoloader = Autoloader::register($dir, $namespace, $proxyGenerator);
    › }
  }
}

"app_dashboard"

[
  "route" => "app_dashboard"
  "route_parameters" => [
    "_route" => "app_dashboard"
    "_controller" => "App\Controller\DealController::index"
  ]
  "request_uri" => "https://lalafleet.com/dashboard"
  "method" => "GET"
]

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

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

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

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Core\Authentication\Token\UsernamePasswordToken"
]

[
  "use_savepoints" => true
  "driver" => "pdo_mysql"
  "idle_connection_ttl" => 600
  "host" => "axhbxiqcrm.mysql.db"
  "port" => 3306
  "user" => "axhbxiqcrm"
  "password" => "<redacted>"
  "driverOptions" => []
  "defaultTableOptions" => []
  "dbname" => "axhbxiqcrm"
  "serverVersion" => "8.4"
  "charset" => "utf8mb4"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "axhbxiqcrm.mysql.db"
    "port" => 3306
    "user" => "axhbxiqcrm"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "axhbxiqcrm"
    "serverVersion" => "8.4"
    "charset" => "utf8mb4"
  ]
]

"SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.phone AS phone_5, t0.title AS title_6, t0.role AS role_7, t0.language AS language_8, t0.password_hash AS password_hash_9, t0.signature_html AS signature_html_10, t0.active AS active_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13 FROM brokers t0 WHERE t0.id = ?"

[
  1 => 1
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.phone AS phone_5, t0.title AS title_6, t0.role AS role_7, t0.language AS language_8, t0.password_hash AS password_hash_9, t0.signature_html AS signature_html_10, t0.active AS active_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13 FROM brokers t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#746
      +name: "INTEGER"
    }
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "contact@lalajet.com"
]

"SELECT d0_.id AS id_0, d0_.request_id AS request_id_1, d0_.quote_id AS quote_id_2, d0_.invoice_id AS invoice_id_3, d0_.client_id AS client_id_4, d0_.operator_id AS operator_id_5, d0_.broker_id AS broker_id_6, d0_.routing AS routing_7, d0_.departure_date AS departure_date_8, d0_.sale_amount AS sale_amount_9, d0_.cost_amount AS cost_amount_10, d0_.client_paid AS client_paid_11, d0_.client_due AS client_due_12, d0_.operator_paid AS operator_paid_13, d0_.operator_due AS operator_due_14, d0_.fdr_sent AS fdr_sent_15, d0_.status AS status_16, d0_.direct_entry AS direct_entry_17, d0_.notes AS notes_18, d0_.created_at AS created_at_19, d0_.updated_at AS updated_at_20 FROM deals d0_ ORDER BY d0_.departure_date ASC LIMIT 200"

[
  "sql" => "SELECT d0_.id AS id_0, d0_.request_id AS request_id_1, d0_.quote_id AS quote_id_2, d0_.invoice_id AS invoice_id_3, d0_.client_id AS client_id_4, d0_.operator_id AS operator_id_5, d0_.broker_id AS broker_id_6, d0_.routing AS routing_7, d0_.departure_date AS departure_date_8, d0_.sale_amount AS sale_amount_9, d0_.cost_amount AS cost_amount_10, d0_.client_paid AS client_paid_11, d0_.client_due AS client_due_12, d0_.operator_paid AS operator_paid_13, d0_.operator_due AS operator_due_14, d0_.fdr_sent AS fdr_sent_15, d0_.status AS status_16, d0_.direct_entry AS direct_entry_17, d0_.notes AS notes_18, d0_.created_at AS created_at_19, d0_.updated_at AS updated_at_20 FROM deals d0_ ORDER BY d0_.departure_date ASC LIMIT 200"
]

"SELECT t0.id AS id_1, t0.prospect_id AS prospect_id_2, t0.name AS name_3, t0.company AS company_4, t0.email AS email_5, t0.phone AS phone_6, t0.address AS address_7, t0.country AS country_8, t0.preferred_lang AS preferred_lang_9, t0.notes AS notes_10, t0.first_invoice_date AS first_invoice_date_11, t0.total_revenue AS total_revenue_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14 FROM clients t0"

[
  "sql" => "SELECT t0.id AS id_1, t0.prospect_id AS prospect_id_2, t0.name AS name_3, t0.company AS company_4, t0.email AS email_5, t0.phone AS phone_6, t0.address AS address_7, t0.country AS country_8, t0.preferred_lang AS preferred_lang_9, t0.notes AS notes_10, t0.first_invoice_date AS first_invoice_date_11, t0.total_revenue AS total_revenue_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14 FROM clients t0"
]

"SELECT t0.id AS id_1, t0.name AS name_2, t0.aoc AS aoc_3, t0.contact_name AS contact_name_4, t0.contact_phone AS contact_phone_5, t0.email_primary AS email_primary_6, t0.emails_additional AS emails_additional_7, t0.country AS country_8, t0.base_icao AS base_icao_9, t0.address AS address_10, t0.fleet_details AS fleet_details_11, t0.categories AS categories_12, t0.partnership AS partnership_13, t0.documents_status AS documents_status_14, t0.commercial_notes AS commercial_notes_15, t0.active AS active_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18 FROM operators t0"

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.aoc AS aoc_3, t0.contact_name AS contact_name_4, t0.contact_phone AS contact_phone_5, t0.email_primary AS email_primary_6, t0.emails_additional AS emails_additional_7, t0.country AS country_8, t0.base_icao AS base_icao_9, t0.address AS address_10, t0.fleet_details AS fleet_details_11, t0.categories AS categories_12, t0.partnership AS partnership_13, t0.documents_status AS documents_status_14, t0.commercial_notes AS commercial_notes_15, t0.active AS active_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18 FROM operators t0"
]

"SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.phone AS phone_5, t0.title AS title_6, t0.role AS role_7, t0.language AS language_8, t0.password_hash AS password_hash_9, t0.signature_html AS signature_html_10, t0.active AS active_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13 FROM brokers t0"

[
  "sql" => "SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.phone AS phone_5, t0.title AS title_6, t0.role AS role_7, t0.language AS language_8, t0.password_hash AS password_hash_9, t0.signature_html AS signature_html_10, t0.active AS active_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13 FROM brokers t0"
]

"SELECT COUNT(*) FROM deals WHERE status='in_progress'"

[
  "sql" => "SELECT COUNT(*) FROM deals WHERE status='in_progress'"
]

"SELECT COUNT(*) FROM deals WHERE status='completed'"

[
  "sql" => "SELECT COUNT(*) FROM deals WHERE status='completed'"
]

"SELECT COALESCE(SUM(sale_amount),0) FROM deals WHERE status IN ('in_progress','completed') AND MONTH(created_at)=MONTH(CURDATE()) AND YEAR(created_at)=YEAR(CURDATE())"

[
  "sql" => "SELECT COALESCE(SUM(sale_amount),0) FROM deals WHERE status IN ('in_progress','completed') AND MONTH(created_at)=MONTH(CURDATE()) AND YEAR(created_at)=YEAR(CURDATE())"
]

"SELECT COALESCE(SUM(sale_amount-cost_amount),0) FROM deals WHERE status IN ('in_progress','completed') AND MONTH(created_at)=MONTH(CURDATE()) AND YEAR(created_at)=YEAR(CURDATE())"

[
  "sql" => "SELECT COALESCE(SUM(sale_amount-cost_amount),0) FROM deals WHERE status IN ('in_progress','completed') AND MONTH(created_at)=MONTH(CURDATE()) AND YEAR(created_at)=YEAR(CURDATE())"
]

"SELECT currency, COALESCE(SUM(sale_amount),0) AS revenue, COALESCE(SUM(sale_amount-cost_amount),0) AS margin FROM deals WHERE status IN ('in_progress','completed') AND MONTH(created_at)=MONTH(CURDATE()) AND YEAR(created_at)=YEAR(CURDATE()) GROUP BY currency"

[
  "sql" => "SELECT currency, COALESCE(SUM(sale_amount),0) AS revenue, COALESCE(SUM(sale_amount-cost_amount),0) AS margin FROM deals WHERE status IN ('in_progress','completed') AND MONTH(created_at)=MONTH(CURDATE()) AND YEAR(created_at)=YEAR(CURDATE()) GROUP BY currency"
]

"SELECT id, name FROM operators WHERE id IN (5)"

[
  "sql" => "SELECT id, name FROM operators WHERE id IN (5)"
]

"SELECT id, invoice_number FROM invoices WHERE id IN (75,76)"

[
  "sql" => "SELECT id, invoice_number FROM invoices WHERE id IN (75,76)"
]

"SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.phone AS phone_5, t0.title AS title_6, t0.role AS role_7, t0.language AS language_8, t0.password_hash AS password_hash_9, t0.signature_html AS signature_html_10, t0.active AS active_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13 FROM brokers t0 WHERE t0.active = ? ORDER BY t0.first_name ASC"

[
  1 => 1
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.phone AS phone_5, t0.title AS title_6, t0.role AS role_7, t0.language AS language_8, t0.password_hash AS password_hash_9, t0.signature_html AS signature_html_10, t0.active AS active_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13 FROM brokers t0 WHERE t0.active = ? ORDER BY t0.first_name ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1170
      +name: "BOOLEAN"
    }
  ]
]

[
  "key" => "_security_main"
]