Symfony Profiler

[
  "route" => "home"
  "route_parameters" => [
    "_route" => "home"
    "_controller" => "App\Controller\HomeController::index"
  ]
  "request_uri" => "https://proson.net/"
  "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"
]

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

[
  "sql" => "SELECT COUNT(*) FROM professional_profiles t0 WHERE t0.verification_status = ?"
  "params" => [
    1 => "VERIFIED"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1171
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT COUNT(*) FROM projects t0"
]

[
  "sql" => "SELECT COUNT(*) FROM bookings t0"
]

[
  "sql" => "SELECT AVG(r0_.overall_rating) AS sclr_0 FROM reviews r0_"
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.display_name AS display_name_1, p0_.bio AS bio_2, p0_.avatar_url AS avatar_url_3, p0_.rating_average AS rating_average_4, p0_.rating_count AS rating_count_5, p0_.badge_level AS badge_level_6, p0_.hourly_rate AS hourly_rate_7, p0_.daily_rate AS daily_rate_8, p0_.package_rates AS package_rates_9, p0_.travel_fee AS travel_fee_10, p0_.weekend_fee AS weekend_fee_11, p0_.night_fee AS night_fee_12, p0_.urgent_fee AS urgent_fee_13, p0_.service_radius_km AS service_radius_km_14, p0_.base_latitude AS base_latitude_15, p0_.base_longitude AS base_longitude_16, p0_.base_place_id AS base_place_id_17, p0_.base_city AS base_city_18, p0_.base_country AS base_country_19, p0_.base_country_code AS base_country_code_20, p0_.base_formatted_address AS base_formatted_address_21, p0_.verification_status AS verification_status_22, p0_.created_at AS created_at_23, p0_.updated_at AS updated_at_24, p0_.ics_token AS ics_token_25, p0_.settings AS settings_26, p0_.tagline AS tagline_27, p0_.cover_image_url AS cover_image_url_28, p0_.business_phone AS business_phone_29, p0_.website AS website_30, p0_.social_links AS social_links_31, p0_.professional_type AS professional_type_32, p0_.legal_entity_type AS legal_entity_type_33, p0_.legal_company_name AS legal_company_name_34, p0_.vat_number AS vat_number_35, p0_.invoice_footer AS invoice_footer_36, p0_.billing_address AS billing_address_37, p0_.preferred_currency AS preferred_currency_38, p0_.preferred_language AS preferred_language_39, p0_.time_format AS time_format_40, p0_.user_id AS user_id_41 FROM professional_profiles p0_ WHERE p0_.verification_status = ? ORDER BY p0_.rating_average DESC, p0_.rating_count DESC LIMIT 6"
  "params" => [
    1 => "VERIFIED"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1171
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT MIN(p0_.min_price) AS sclr_0 FROM professional_services p0_ WHERE p0_.professional_id = ?"
  "params" => [
    1 => Symfony\Component\Uid\UuidV7 {#1310
      #uid: "019be4b2-b1db-75cf-a401-6a1f9e743732"
      toBase58: "1CXN4ENv2KpgQEU7TxCLPb"
      toBase32: "01KFJB5CEVEQ7T80BA3YF78DSJ"
      time: "2026-01-22 07:54:34.843371 UTC"
    }
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1171
      +name: "STRING"
    }
  ]
]

[
  "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 = ? ORDER BY t0.created_at ASC LIMIT 1"
  "params" => [
    1 => b"\x01›ä²±ÛuϤ\x01j\x1Fžt72"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1171
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT MIN(p0_.min_price) AS sclr_0 FROM professional_services p0_ WHERE p0_.professional_id = ?"
  "params" => [
    1 => Symfony\Component\Uid\UuidV7 {#1655
      #uid: "019be4b2-a822-7665-b72d-80d41bfbfd36"
      toBase58: "1CXN4ECGpCo2arNFdsCicm"
      toBase32: "01KFJB5A12ESJVEBC0TGDZQZ9P"
      time: "2026-01-22 07:54:32.354409 UTC"
    }
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1171
      +name: "STRING"
    }
  ]
]

[
  "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 = ? ORDER BY t0.created_at ASC LIMIT 1"
  "params" => [
    1 => b"\x01›ä²¨"ve·-€Ô\eûý6"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1171
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT MIN(p0_.min_price) AS sclr_0 FROM professional_services p0_ WHERE p0_.professional_id = ?"
  "params" => [
    1 => Symfony\Component\Uid\UuidV7 {#1749
      #uid: "019be4b2-bc4b-7db1-acee-0e94ee6205a7"
      toBase58: "1CXN4EaLcvnAbdxmKiFs5x"
      toBase32: "01KFJB5F2BFPRTSVGEJKQ641D7"
      time: "2026-01-22 07:54:37.515876 UTC"
    }
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1171
      +name: "STRING"
    }
  ]
]

[
  "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 = ? ORDER BY t0.created_at ASC LIMIT 1"
  "params" => [
    1 => b"\x01›ä²¼K}±¬î\x0E”îb\x05§"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1171
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT MIN(p0_.min_price) AS sclr_0 FROM professional_services p0_ WHERE p0_.professional_id = ?"
  "params" => [
    1 => Symfony\Component\Uid\UuidV7 {#1765
      #uid: "019be4b2-ad3e-780c-bf9f-f54e0dd44df7"
      toBase58: "1CXN4EHsAfZVieNg1xeJhC"
      toBase32: "01KFJB5B9YF06BZ7ZN9R6X8KFQ"
      time: "2026-01-22 07:54:33.662515 UTC"
    }
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1171
      +name: "STRING"
    }
  ]
]

[
  "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 = ? ORDER BY t0.created_at ASC LIMIT 1"
  "params" => [
    1 => b"\x01›ä²­>x\f¿ŸõN\rÔM÷"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1171
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT MIN(p0_.min_price) AS sclr_0 FROM professional_services p0_ WHERE p0_.professional_id = ?"
  "params" => [
    1 => Symfony\Component\Uid\UuidV7 {#1781
      #uid: "019be4b2-b704-7457-b66d-6f993f9e6870"
      toBase58: "1CXN4EUZbarkjJY5149Cc7"
      toBase32: "01KFJB5DR4EHBVCVBFK4ZSWT3G"
      time: "2026-01-22 07:54:36.164277 UTC"
    }
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1171
      +name: "STRING"
    }
  ]
]

[
  "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 = ? ORDER BY t0.created_at ASC LIMIT 1"
  "params" => [
    1 => b"\x01›ä²·\x04tW¶mo™?žhp"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1171
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT MIN(p0_.min_price) AS sclr_0 FROM professional_services p0_ WHERE p0_.professional_id = ?"
  "params" => [
    1 => Symfony\Component\Uid\UuidV7 {#1797
      #uid: "019be4b2-c7fc-7d30-bc20-ec50110918e9"
      toBase58: "1CXN4Eo8ordNWVkw6wV8vC"
      toBase32: "01KFJB5HZWFMRBR87CA08GJ679"
      time: "2026-01-22 07:54:40.508844 UTC"
    }
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1171
      +name: "STRING"
    }
  ]
]

[
  "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 = ? ORDER BY t0.created_at ASC LIMIT 1"
  "params" => [
    1 => b"\x01›ä²Çü}0¼ ìP\x11\t\x18é"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1171
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.name_translations AS name_translations_2, c0_.description_translations AS description_translations_3, c0_.slug AS slug_4, c0_.icon_name AS icon_name_5, c0_.icon_key AS icon_key_6, c0_.image_url AS image_url_7, c0_.color AS color_8, c0_.type AS type_9, c0_.display_type AS display_type_10, c0_.sort_order AS sort_order_11, c0_.is_active AS is_active_12, c0_.is_featured AS is_featured_13, c0_.metadata AS metadata_14, c0_.created_at AS created_at_15, c0_.updated_at AS updated_at_16, c0_.parent_id AS parent_id_17 FROM categories c0_ WHERE c0_.is_active = ? AND c0_.parent_id IS NULL AND c0_.display_type = ? ORDER BY c0_.is_featured DESC, c0_.sort_order ASC LIMIT 8"
  "params" => [
    1 => 1
    2 => "main"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1921
      +name: "BOOLEAN"
    }
    2 => Doctrine\DBAL\ParameterType {#1171
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT p0_.professional_id) AS sclr_0 FROM professional_services p0_ WHERE p0_.category_id = ? OR p0_.subcategory_id = ?"
  "params" => [
    1 => "019be4b2-bcdc-73df-a98c-07121be3bc4a"
    2 => "019be4b2-bcdc-73df-a98c-07121be3bc4a"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1171
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1171}
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT p0_.professional_id) AS sclr_0 FROM professional_services p0_ WHERE p0_.category_id = ? OR p0_.subcategory_id = ?"
  "params" => [
    1 => "019be4b2-deb0-7d55-80d6-ea1094ea9c6e"
    2 => "019be4b2-deb0-7d55-80d6-ea1094ea9c6e"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1171
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1171}
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT p0_.professional_id) AS sclr_0 FROM professional_services p0_ WHERE p0_.category_id = ? OR p0_.subcategory_id = ?"
  "params" => [
    1 => "019be4b2-bcde-7949-82ca-126dacbbff1d"
    2 => "019be4b2-bcde-7949-82ca-126dacbbff1d"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1171
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1171}
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT p0_.professional_id) AS sclr_0 FROM professional_services p0_ WHERE p0_.category_id = ? OR p0_.subcategory_id = ?"
  "params" => [
    1 => "019be4b2-deb9-7886-b946-6959e9c57002"
    2 => "019be4b2-deb9-7886-b946-6959e9c57002"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1171
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1171}
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT p0_.professional_id) AS sclr_0 FROM professional_services p0_ WHERE p0_.category_id = ? OR p0_.subcategory_id = ?"
  "params" => [
    1 => "019be4b2-bcde-7d91-82ca-126dae339bc6"
    2 => "019be4b2-bcde-7d91-82ca-126dae339bc6"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1171
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1171}
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT p0_.professional_id) AS sclr_0 FROM professional_services p0_ WHERE p0_.category_id = ? OR p0_.subcategory_id = ?"
  "params" => [
    1 => "019be4b2-dec4-7780-ba3e-57a73e1e5505"
    2 => "019be4b2-dec4-7780-ba3e-57a73e1e5505"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1171
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1171}
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT p0_.professional_id) AS sclr_0 FROM professional_services p0_ WHERE p0_.category_id = ? OR p0_.subcategory_id = ?"
  "params" => [
    1 => "019be4b2-bcdf-7392-85b0-7f61f056e57b"
    2 => "019be4b2-bcdf-7392-85b0-7f61f056e57b"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1171
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1171}
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT p0_.professional_id) AS sclr_0 FROM professional_services p0_ WHERE p0_.category_id = ? OR p0_.subcategory_id = ?"
  "params" => [
    1 => "019be4b2-ded0-790a-b0a0-eebae4309bde"
    2 => "019be4b2-ded0-790a-b0a0-eebae4309bde"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1171
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1171}
  ]
]

[
  "sql" => "SELECT o0_.id AS id_0, o0_.title AS title_1, o0_.short_description AS short_description_2, o0_.discount_type AS discount_type_3, o0_.discount_value AS discount_value_4, o0_.badge_label AS badge_label_5, o0_.min_booking_amount AS min_booking_amount_6, o0_.max_usage_per_customer AS max_usage_per_customer_7, o0_.valid_from AS valid_from_8, o0_.valid_until AS valid_until_9, o0_.is_active AS is_active_10, o0_.created_at AS created_at_11, o0_.updated_at AS updated_at_12, o0_.professional_id AS professional_id_13, o0_.service_id AS service_id_14 FROM offers o0_ INNER JOIN professional_profiles p1_ ON o0_.professional_id = p1_.id WHERE o0_.is_active = ? AND o0_.valid_from <= ? AND o0_.valid_until > ? AND p1_.verification_status = ? ORDER BY o0_.valid_until ASC LIMIT 6"
  "params" => [
    1 => 1
    2 => "2026-02-21 13:22:19"
    3 => "2026-02-21 13:22:19"
    4 => "VERIFIED"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1921
      +name: "BOOLEAN"
    }
    2 => Doctrine\DBAL\ParameterType {#1171
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#1171}
    4 => Doctrine\DBAL\ParameterType {#1171}
  ]
]

[
  "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_.overall_rating >= ? AND r0_.comment IS NOT NULL AND r0_.comment <> ? ORDER BY r0_.overall_rating DESC, r0_.created_at DESC LIMIT 8"
  "params" => [
    1 => 4
    2 => ""
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#900
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1171
      +name: "STRING"
    }
  ]
]