Symfony Profiler

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

Log Messages

[
  "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#1495
    +count: 2
    -severity: E_USER_DEPRECATED
    trace: {
      /home/glqhjmb/www/vendor/symfony/config/Definition/ArrayNode.php:236 {
        Symfony\Component\Config\Definition\ArrayNode->finalizeValue(mixed $value): mixed …
        ›     $deprecation = $child->getDeprecation($name, $this->getPath());
        ›     trigger_deprecation($deprecation['package'], $deprecation['version'], $deprecation['message']);
        › }
      }
      /home/glqhjmb/www/vendor/symfony/config/Definition/BaseNode.php:420 {
        › 
        › $value = $this->finalizeValue($value);
        › 
      }
    }
  }
]

{
  /home/glqhjmb/www/vendor/symfony/config/Definition/ArrayNode.php:236 {
    Symfony\Component\Config\Definition\ArrayNode->finalizeValue(mixed $value): mixed …
    ›     $deprecation = $child->getDeprecation($name, $this->getPath());
    ›     trigger_deprecation($deprecation['package'], $deprecation['version'], $deprecation['message']);
    › }
  }
  /home/glqhjmb/www/vendor/symfony/config/Definition/BaseNode.php:420 {
    › 
    › $value = $this->finalizeValue($value);
    › 
  }
}

[
  "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#118
    +count: 36
    -severity: E_WARNING
    trace: {
      /home/glqhjmb/www/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/glqhjmb/www/vendor/symfony/debug-bundle/DebugBundle.php:35 {
        › // will buffer it, and release it at the end of the script.
        › VarDumper::setHandler(function ($var, ?string $label = null) use ($container) {
        ›     $dumper = $container->get('data_collector.dump');
      }
    }
  }
]

{
  /home/glqhjmb/www/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/glqhjmb/www/vendor/symfony/debug-bundle/DebugBundle.php:35 {
    › // will buffer it, and release it at the end of the script.
    › VarDumper::setHandler(function ($var, ?string $label = null) use ($container) {
    ›     $dumper = $container->get('data_collector.dump');
  }
}

"app_subservice_show"

[
  "route" => "app_subservice_show"
  "route_parameters" => [
    "_route" => "app_subservice_show"
    "_controller" => "App\Controller\ActivityDetailController::show"
    "_locale" => "ar"
    "serviceSlug" => "طلاء"
    "subSlug" => "تغطية-الأرضيات"
  ]
  "request_uri" => "https://expertcomposite.com/ar/%D8%AE%D8%AF%D9%85%D8%A7%D8%AA/%D8%B7%D9%84%D8%A7%D8%A1/%D8%AA%D8%BA%D8%B7%D9%8A%D8%A9-%D8%A7%D9%84%D8%A3%D8%B1%D8%B6%D9%8A%D8%A7%D8%AA"
  "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"
]

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

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

"SELECT a0_.id AS id_0, a0_.locale AS locale_1, a0_.name AS name_2, a0_.description AS description_3, a0_.slug AS slug_4, a1_.id AS id_5, s2_.id AS id_6, s2_.image AS image_7, s3_.id AS id_8, s3_.locale AS locale_9, s3_.name AS name_10, s3_.slug AS slug_11, a0_.activity_id AS activity_id_12, a1_.service_id AS service_id_13, s3_.service_id AS service_id_14 FROM activity_translation a0_ INNER JOIN activity a1_ ON a0_.activity_id = a1_.id INNER JOIN service s2_ ON a1_.service_id = s2_.id INNER JOIN service_translation s3_ ON s2_.id = s3_.service_id WHERE a0_.slug = ? AND a0_.locale = ? AND s3_.slug = ? AND s3_.locale = ?"

[
  1 => "تغطية-الأرضيات"
  2 => "ar"
  3 => "طلاء"
  4 => "ar"
]

[
  1 => Doctrine\DBAL\ParameterType {#863
    +name: "STRING"
  }
  2 => Doctrine\DBAL\ParameterType {#863}
  3 => Doctrine\DBAL\ParameterType {#863}
  4 => Doctrine\DBAL\ParameterType {#863}
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.locale AS locale_1, a0_.name AS name_2, a0_.description AS description_3, a0_.slug AS slug_4, a1_.id AS id_5, s2_.id AS id_6, s2_.image AS image_7, s3_.id AS id_8, s3_.locale AS locale_9, s3_.name AS name_10, s3_.slug AS slug_11, a0_.activity_id AS activity_id_12, a1_.service_id AS service_id_13, s3_.service_id AS service_id_14 FROM activity_translation a0_ INNER JOIN activity a1_ ON a0_.activity_id = a1_.id INNER JOIN service s2_ ON a1_.service_id = s2_.id INNER JOIN service_translation s3_ ON s2_.id = s3_.service_id WHERE a0_.slug = ? AND a0_.locale = ? AND s3_.slug = ? AND s3_.locale = ?"
  "params" => [
    1 => "تغطية-الأرضيات"
    2 => "ar"
    3 => "طلاء"
    4 => "ar"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#863
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#863}
    3 => Doctrine\DBAL\ParameterType {#863}
    4 => Doctrine\DBAL\ParameterType {#863}
  ]
]

"SELECT a0_.id AS id_0, a0_.service_id AS service_id_1 FROM activity a0_ INNER JOIN activity_translation a1_ ON a0_.id = a1_.activity_id WHERE a1_.slug = ? AND a1_.locale = ?"

[
  1 => "تغطية-الأرضيات"
  2 => "ar"
]

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

[
  "sql" => "SELECT a0_.id AS id_0, a0_.service_id AS service_id_1 FROM activity a0_ INNER JOIN activity_translation a1_ ON a0_.id = a1_.activity_id WHERE a1_.slug = ? AND a1_.locale = ?"
  "params" => [
    1 => "تغطية-الأرضيات"
    2 => "ar"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#863
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#863}
  ]
]

"SELECT s0_.id AS id_0, s0_.image AS image_1, s1_.id AS id_2, s1_.locale AS locale_3, s1_.name AS name_4, s1_.slug AS slug_5, s2_.id AS id_6, s2_.locale AS locale_7, s2_.name AS name_8, s2_.slug AS slug_9, s1_.service_id AS service_id_10, s2_.service_id AS service_id_11 FROM service s0_ INNER JOIN service_translation s1_ ON s0_.id = s1_.service_id LEFT JOIN service_translation s2_ ON s0_.id = s2_.service_id WHERE s1_.slug = ? AND s1_.locale = ?"

[
  1 => "طلاء"
  2 => "ar"
]

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

[
  "sql" => "SELECT s0_.id AS id_0, s0_.image AS image_1, s1_.id AS id_2, s1_.locale AS locale_3, s1_.name AS name_4, s1_.slug AS slug_5, s2_.id AS id_6, s2_.locale AS locale_7, s2_.name AS name_8, s2_.slug AS slug_9, s1_.service_id AS service_id_10, s2_.service_id AS service_id_11 FROM service s0_ INNER JOIN service_translation s1_ ON s0_.id = s1_.service_id LEFT JOIN service_translation s2_ ON s0_.id = s2_.service_id WHERE s1_.slug = ? AND s1_.locale = ?"
  "params" => [
    1 => "طلاء"
    2 => "ar"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#863
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#863}
  ]
]

"SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.description AS description_4, t0.slug AS slug_5, t0.activity_id AS activity_id_6 FROM activity_translation t0 WHERE t0.activity_id = ?"

[
  1 => 1
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.description AS description_4, t0.slug AS slug_5, t0.activity_id AS activity_id_6 FROM activity_translation t0 WHERE t0.activity_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#956
      +name: "INTEGER"
    }
  ]
]

"SELECT t0.id AS id_1, t0.image AS image_2 FROM service t0"

[
  "sql" => "SELECT t0.id AS id_1, t0.image AS image_2 FROM service t0"
]

"SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.facebook AS facebook_4, t0.twitter AS twitter_5, t0.instagram AS instagram_6, t0.youtube AS youtube_7, t0.telephone AS telephone_8, t0.addr_fr AS addr_fr_9, t0.addr_en AS addr_en_10, t0.addr_ar AS addr_ar_11, t0.whatsapp AS whatsapp_12, t0.maps AS maps_13, t0.linkedin AS linkedin_14, t0.tiktok AS tiktok_15, t0.website AS website_16, t0.tax_number AS tax_number_17 FROM company_info t0 LIMIT 1"

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.facebook AS facebook_4, t0.twitter AS twitter_5, t0.instagram AS instagram_6, t0.youtube AS youtube_7, t0.telephone AS telephone_8, t0.addr_fr AS addr_fr_9, t0.addr_en AS addr_en_10, t0.addr_ar AS addr_ar_11, t0.whatsapp AS whatsapp_12, t0.maps AS maps_13, t0.linkedin AS linkedin_14, t0.tiktok AS tiktok_15, t0.website AS website_16, t0.tax_number AS tax_number_17 FROM company_info t0 LIMIT 1"
]

"SELECT COUNT(a0_.id) AS sclr_0, s1_.id AS id_1, s1_.image AS image_2, s2_.id AS id_3, s2_.locale AS locale_4, s2_.name AS name_5, s2_.slug AS slug_6, s2_.service_id AS service_id_7 FROM service s1_ INNER JOIN service_translation s2_ ON s1_.id = s2_.service_id LEFT JOIN activity a0_ ON s1_.id = a0_.service_id WHERE s2_.locale = ? GROUP BY s1_.id, s2_.id ORDER BY s1_.id ASC"

[
  1 => "ar"
]

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

[
  "sql" => "SELECT COUNT(a0_.id) AS sclr_0, s1_.id AS id_1, s1_.image AS image_2, s2_.id AS id_3, s2_.locale AS locale_4, s2_.name AS name_5, s2_.slug AS slug_6, s2_.service_id AS service_id_7 FROM service s1_ INNER JOIN service_translation s2_ ON s1_.id = s2_.service_id LEFT JOIN activity a0_ ON s1_.id = a0_.service_id WHERE s2_.locale = ? GROUP BY s1_.id, s2_.id ORDER BY s1_.id ASC"
  "params" => [
    1 => "ar"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#863
      +name: "STRING"
    }
  ]
]

"SELECT a0_.id AS id_0, a1_.id AS id_1, a1_.locale AS locale_2, a1_.name AS name_3, a1_.description AS description_4, a1_.slug AS slug_5, a0_.service_id AS service_id_6, a1_.activity_id AS activity_id_7 FROM activity a0_ INNER JOIN service s2_ ON a0_.service_id = s2_.id INNER JOIN activity_translation a1_ ON a0_.id = a1_.activity_id WHERE a0_.service_id = ? AND a0_.id <> ? AND a1_.locale = ?"

[
  1 => 1
  2 => 1
  3 => "ar"
]

[
  1 => Doctrine\DBAL\ParameterType {#956
    +name: "INTEGER"
  }
  2 => Doctrine\DBAL\ParameterType {#956}
  3 => Doctrine\DBAL\ParameterType {#863
    +name: "STRING"
  }
]

[
  "sql" => "SELECT a0_.id AS id_0, a1_.id AS id_1, a1_.locale AS locale_2, a1_.name AS name_3, a1_.description AS description_4, a1_.slug AS slug_5, a0_.service_id AS service_id_6, a1_.activity_id AS activity_id_7 FROM activity a0_ INNER JOIN service s2_ ON a0_.service_id = s2_.id INNER JOIN activity_translation a1_ ON a0_.id = a1_.activity_id WHERE a0_.service_id = ? AND a0_.id <> ? AND a1_.locale = ?"
  "params" => [
    1 => 1
    2 => 1
    3 => "ar"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#956
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#956}
    3 => Doctrine\DBAL\ParameterType {#863
      +name: "STRING"
    }
  ]
]

"SELECT s0_.id AS id_0, s0_.image AS image_1, c1_.id AS id_2, c1_.image AS image_3, c2_.id AS id_4, c2_.locale AS locale_5, c2_.name AS name_6, c2_.slug AS slug_7, c2_.description AS description_8, c2_.category_id AS category_id_9 FROM section s0_ LEFT JOIN section_category s3_ ON s0_.id = s3_.section_id LEFT JOIN category c1_ ON c1_.id = s3_.category_id LEFT JOIN category_translation c2_ ON c1_.id = c2_.category_id AND (c2_.locale = ?)"

[
  1 => "ar"
]

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

[
  "sql" => "SELECT s0_.id AS id_0, s0_.image AS image_1, c1_.id AS id_2, c1_.image AS image_3, c2_.id AS id_4, c2_.locale AS locale_5, c2_.name AS name_6, c2_.slug AS slug_7, c2_.description AS description_8, c2_.category_id AS category_id_9 FROM section s0_ LEFT JOIN section_category s3_ ON s0_.id = s3_.section_id LEFT JOIN category c1_ ON c1_.id = s3_.category_id LEFT JOIN category_translation c2_ ON c1_.id = c2_.category_id AND (c2_.locale = ?)"
  "params" => [
    1 => "ar"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#863
      +name: "STRING"
    }
  ]
]

"SELECT t0.id AS id_1, t0.filename AS filename_2, t0.activity_id AS activity_id_3 FROM activity_image t0 WHERE t0.activity_id = ?"

[
  1 => 1
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.filename AS filename_2, t0.activity_id AS activity_id_3 FROM activity_image t0 WHERE t0.activity_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#956
      +name: "INTEGER"
    }
  ]
]

"SELECT t0.id AS id_1, t0.service_id AS service_id_2 FROM activity t0 WHERE t0.service_id = ?"

[
  1 => 1
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.service_id AS service_id_2 FROM activity t0 WHERE t0.service_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#956
      +name: "INTEGER"
    }
  ]
]