Symfony Profiler

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

Log Messages

[
  "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#663
    +count: 1
    -severity: E_USER_DEPRECATED
    trace: {
      /home/u112766966/domains/proson.net/public_html/Backend/vendor/symfony/property-info/Type.php:14 {
        include …
        › 
        › trigger_deprecation('symfony/property-info', '7.3', 'The "%s" class is deprecated. Use "%s" class from "symfony/type-info" instead.', Type::class, \Symfony\Component\TypeInfo\Type::class);
        › 
      }
      /home/u112766966/domains/proson.net/public_html/Backend/vendor/symfony/error-handler/DebugClassLoader.php:304 {
        › } elseif (\function_exists('opcache_is_script_cached') && @opcache_is_script_cached($file)) {
        ›     include $file;
        › 
        arguments: {
          "/home/u112766966/domains/proson.net/public_html/Backend/vendor/symfony/property-info/Type.php"
        }
      }
    }
  }
]

{
  /home/u112766966/domains/proson.net/public_html/Backend/vendor/symfony/property-info/Type.php:14 {
    include …
    › 
    › trigger_deprecation('symfony/property-info', '7.3', 'The "%s" class is deprecated. Use "%s" class from "symfony/type-info" instead.', Type::class, \Symfony\Component\TypeInfo\Type::class);
    › 
  }
  /home/u112766966/domains/proson.net/public_html/Backend/vendor/symfony/error-handler/DebugClassLoader.php:304 {
    › } elseif (\function_exists('opcache_is_script_cached') && @opcache_is_script_cached($file)) {
    ›     include $file;
    › 
    arguments: {
      "/home/u112766966/domains/proson.net/public_html/Backend/vendor/symfony/property-info/Type.php"
    }
  }
}

"api_v1_professionals_show"

[
  "route" => "api_v1_professionals_show"
  "route_parameters" => [
    "_route" => "api_v1_professionals_show"
    "_controller" => "App\Controller\Api\V1\ProfessionalsController::show"
    "uuid" => "019be4b2-c7fc-7d30-bc20-ec50110918e9"
  ]
  "request_uri" => "https://proson.net/api/v1/professionals/019be4b2-c7fc-7d30-bc20-ec50110918e9?sort=latest"
  "method" => "GET"
]

[
  "use_savepoints" => true
  "driver" => "pdo_mysql"
  "idle_connection_ttl" => 600
  "host" => "localhost"
  "port" => 3306
  "user" => "u112766966_eclipsex"
  "password" => "<redacted>"
  "driverOptions" => []
  "defaultTableOptions" => []
  "dbname" => "u112766966_app"
  "serverVersion" => "8.0.32"
  "charset" => "utf8mb4"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "localhost"
    "port" => 3306
    "user" => "u112766966_eclipsex"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "u112766966_app"
    "serverVersion" => "8.0.32"
    "charset" => "utf8mb4"
  ]
]

"SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.bio AS bio_3, t0.avatar_url AS avatar_url_4, t0.rating_average AS rating_average_5, t0.rating_count AS rating_count_6, t0.badge_level AS badge_level_7, t0.hourly_rate AS hourly_rate_8, t0.daily_rate AS daily_rate_9, t0.package_rates AS package_rates_10, t0.travel_fee AS travel_fee_11, t0.weekend_fee AS weekend_fee_12, t0.night_fee AS night_fee_13, t0.urgent_fee AS urgent_fee_14, t0.service_radius_km AS service_radius_km_15, t0.base_latitude AS base_latitude_16, t0.base_longitude AS base_longitude_17, t0.base_place_id AS base_place_id_18, t0.base_city AS base_city_19, t0.base_country AS base_country_20, t0.base_country_code AS base_country_code_21, t0.base_formatted_address AS base_formatted_address_22, t0.verification_status AS verification_status_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.ics_token AS ics_token_26, t0.settings AS settings_27, t0.tagline AS tagline_28, t0.cover_image_url AS cover_image_url_29, t0.business_phone AS business_phone_30, t0.website AS website_31, t0.social_links AS social_links_32, t0.professional_type AS professional_type_33, t0.legal_entity_type AS legal_entity_type_34, t0.legal_company_name AS legal_company_name_35, t0.vat_number AS vat_number_36, t0.invoice_footer AS invoice_footer_37, t0.billing_address AS billing_address_38, t0.preferred_currency AS preferred_currency_39, t0.preferred_language AS preferred_language_40, t0.time_format AS time_format_41, t0.user_id AS user_id_42 FROM professional_profiles t0 WHERE t0.id = ?"

[
  1 => b"\x01›ä²Çü}0¼ ìP\x11\t\x18é"
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.bio AS bio_3, t0.avatar_url AS avatar_url_4, t0.rating_average AS rating_average_5, t0.rating_count AS rating_count_6, t0.badge_level AS badge_level_7, t0.hourly_rate AS hourly_rate_8, t0.daily_rate AS daily_rate_9, t0.package_rates AS package_rates_10, t0.travel_fee AS travel_fee_11, t0.weekend_fee AS weekend_fee_12, t0.night_fee AS night_fee_13, t0.urgent_fee AS urgent_fee_14, t0.service_radius_km AS service_radius_km_15, t0.base_latitude AS base_latitude_16, t0.base_longitude AS base_longitude_17, t0.base_place_id AS base_place_id_18, t0.base_city AS base_city_19, t0.base_country AS base_country_20, t0.base_country_code AS base_country_code_21, t0.base_formatted_address AS base_formatted_address_22, t0.verification_status AS verification_status_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.ics_token AS ics_token_26, t0.settings AS settings_27, t0.tagline AS tagline_28, t0.cover_image_url AS cover_image_url_29, t0.business_phone AS business_phone_30, t0.website AS website_31, t0.social_links AS social_links_32, t0.professional_type AS professional_type_33, t0.legal_entity_type AS legal_entity_type_34, t0.legal_company_name AS legal_company_name_35, t0.vat_number AS vat_number_36, t0.invoice_footer AS invoice_footer_37, t0.billing_address AS billing_address_38, t0.preferred_currency AS preferred_currency_39, t0.preferred_language AS preferred_language_40, t0.time_format AS time_format_41, t0.user_id AS user_id_42 FROM professional_profiles t0 WHERE t0.id = ?"
  "params" => [
    1 => b"\x01›ä²Çü}0¼ ìP\x11\t\x18é"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1375
      +name: "STRING"
    }
  ]
]

"SELECT t0.id AS id_1, t0.category_id AS category_id_2, t0.subcategory_id AS subcategory_id_3, t0.title AS title_4, t0.description AS description_5, t0.default_duration_minutes AS default_duration_minutes_6, t0.min_price AS min_price_7, t0.max_price AS max_price_8, t0.is_active AS is_active_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.professional_id AS professional_id_12 FROM professional_services t0 WHERE t0.professional_id = ? AND t0.is_active = ?"

[
  1 => b"\x01›ä²Çü}0¼ ìP\x11\t\x18é"
  2 => 1
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.category_id AS category_id_2, t0.subcategory_id AS subcategory_id_3, t0.title AS title_4, t0.description AS description_5, t0.default_duration_minutes AS default_duration_minutes_6, t0.min_price AS min_price_7, t0.max_price AS max_price_8, t0.is_active AS is_active_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.professional_id AS professional_id_12 FROM professional_services t0 WHERE t0.professional_id = ? AND t0.is_active = ?"
  "params" => [
    1 => b"\x01›ä²Çü}0¼ ìP\x11\t\x18é"
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1375
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1618
      +name: "BOOLEAN"
    }
  ]
]

"SELECT r0_.id AS id_0, r0_.type AS type_1, r0_.punctuality_rating AS punctuality_rating_2, r0_.professionalism_rating AS professionalism_rating_3, r0_.quality_rating AS quality_rating_4, r0_.responsiveness_rating AS responsiveness_rating_5, r0_.value_rating AS value_rating_6, r0_.overall_rating AS overall_rating_7, r0_.comment AS comment_8, r0_.title AS title_9, r0_.status AS status_10, r0_.helpful_count AS helpful_count_11, r0_.response AS response_12, r0_.responded_at AS responded_at_13, r0_.created_at AS created_at_14, r0_.updated_at AS updated_at_15, r0_.professional_id AS professional_id_16, r0_.customer_id AS customer_id_17, r0_.booking_id AS booking_id_18, r0_.project_id AS project_id_19 FROM reviews r0_ WHERE r0_.professional_id = ? AND r0_.status = ? ORDER BY r0_.created_at DESC LIMIT 10"

[
  1 => Symfony\Component\Uid\UuidV7 {#1374
    #uid: "019be4b2-c7fc-7d30-bc20-ec50110918e9"
    toBase58: "1CXN4Eo8ordNWVkw6wV8vC"
    toBase32: "01KFJB5HZWFMRBR87CA08GJ679"
    time: "2026-01-22 07:54:40.508844 UTC"
  }
  2 => "APPROVED"
]

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

[
  "sql" => "SELECT r0_.id AS id_0, r0_.type AS type_1, r0_.punctuality_rating AS punctuality_rating_2, r0_.professionalism_rating AS professionalism_rating_3, r0_.quality_rating AS quality_rating_4, r0_.responsiveness_rating AS responsiveness_rating_5, r0_.value_rating AS value_rating_6, r0_.overall_rating AS overall_rating_7, r0_.comment AS comment_8, r0_.title AS title_9, r0_.status AS status_10, r0_.helpful_count AS helpful_count_11, r0_.response AS response_12, r0_.responded_at AS responded_at_13, r0_.created_at AS created_at_14, r0_.updated_at AS updated_at_15, r0_.professional_id AS professional_id_16, r0_.customer_id AS customer_id_17, r0_.booking_id AS booking_id_18, r0_.project_id AS project_id_19 FROM reviews r0_ WHERE r0_.professional_id = ? AND r0_.status = ? ORDER BY r0_.created_at DESC LIMIT 10"
  "params" => [
    1 => Symfony\Component\Uid\UuidV7 {#1374
      #uid: "019be4b2-c7fc-7d30-bc20-ec50110918e9"
      toBase58: "1CXN4Eo8ordNWVkw6wV8vC"
      toBase32: "01KFJB5HZWFMRBR87CA08GJ679"
      time: "2026-01-22 07:54:40.508844 UTC"
    }
    2 => "APPROVED"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1375
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1375}
  ]
]

"SELECT AVG(r0_.overall_rating) AS sclr_0, AVG(r0_.punctuality_rating) AS sclr_1, AVG(r0_.professionalism_rating) AS sclr_2, AVG(r0_.quality_rating) AS sclr_3, AVG(r0_.responsiveness_rating) AS sclr_4, AVG(r0_.value_rating) AS sclr_5, COUNT(r0_.id) AS sclr_6 FROM reviews r0_ WHERE r0_.professional_id = ? AND r0_.status = ?"

[
  1 => Symfony\Component\Uid\UuidV7 {#1374
    #uid: "019be4b2-c7fc-7d30-bc20-ec50110918e9"
    toBase58: "1CXN4Eo8ordNWVkw6wV8vC"
    toBase32: "01KFJB5HZWFMRBR87CA08GJ679"
    time: "2026-01-22 07:54:40.508844 UTC"
  }
  2 => "APPROVED"
]

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

[
  "sql" => "SELECT AVG(r0_.overall_rating) AS sclr_0, AVG(r0_.punctuality_rating) AS sclr_1, AVG(r0_.professionalism_rating) AS sclr_2, AVG(r0_.quality_rating) AS sclr_3, AVG(r0_.responsiveness_rating) AS sclr_4, AVG(r0_.value_rating) AS sclr_5, COUNT(r0_.id) AS sclr_6 FROM reviews r0_ WHERE r0_.professional_id = ? AND r0_.status = ?"
  "params" => [
    1 => Symfony\Component\Uid\UuidV7 {#1374
      #uid: "019be4b2-c7fc-7d30-bc20-ec50110918e9"
      toBase58: "1CXN4Eo8ordNWVkw6wV8vC"
      toBase32: "01KFJB5HZWFMRBR87CA08GJ679"
      time: "2026-01-22 07:54:40.508844 UTC"
    }
    2 => "APPROVED"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1375
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1375}
  ]
]

"""
\n
            SELECT FLOOR(overall_rating) as stars, COUNT(id) as count\n
            FROM reviews\n
            WHERE professional_id = ?\n
            AND status = ?\n
            GROUP BY stars\n
            ORDER BY stars DESC\n
        
"""

[
  1 => b"\x01›ä²Çü}0¼ ìP\x11\t\x18é"
  2 => "APPROVED"
]

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

[
  "sql" => """
    \n
                SELECT FLOOR(overall_rating) as stars, COUNT(id) as count\n
                FROM reviews\n
                WHERE professional_id = ?\n
                AND status = ?\n
                GROUP BY stars\n
                ORDER BY stars DESC\n
            
    """
  "params" => [
    1 => b"\x01›ä²Çü}0¼ ìP\x11\t\x18é"
    2 => "APPROVED"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1375
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1375}
  ]
]