Symfony Profiler

[
  "route" => "api_properties_show"
  "route_parameters" => [
    "_route" => "api_properties_show"
    "_controller" => "App\UI\Property\PropertyQueryApiController::show"
    "id" => "b005a071-9217-41b5-a235-fffcd5e24949"
  ]
  "request_uri" => "https://flipping.hrabovskyjan.cz/api/properties/b005a071-9217-41b5-a235-fffcd5e24949"
  "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"
]

[
  "params" => [
    "charset" => "utf8mb4"
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "c1hrabja"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "charset" => "utf8mb4"
      "collate" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "c1flipping"
    "serverVersion" => "10.5.29-MariaDB"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM `User` t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#733
      +name: "INTEGER"
    }
  ]
]

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

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\IsSignatureValidAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.source_listing_id AS source_listing_id_2, t0.type AS type_3, t0.status AS status_4, t0.evaluation_state AS evaluation_state_5, t0.evaluation_queued_at AS evaluation_queued_at_6, t0.evaluation_started_at AS evaluation_started_at_7, t0.evaluation_finished_at AS evaluation_finished_at_8, t0.evaluation_last_error AS evaluation_last_error_9, t0.street AS street_10, t0.city AS city_11, t0.zip AS zip_12, t0.house_number AS house_number_13, t0.area_m2 AS area_m2_14, t0.rooms AS rooms_15, t0.floor AS floor_16, t0.total_floors AS total_floors_17, t0.condition_score AS condition_score_18, t0.renovation_level AS renovation_level_19, t0.listing_price_amount AS listing_price_amount_20, t0.last_price_change_from_amount AS last_price_change_from_amount_21, t0.last_price_change_percent AS last_price_change_percent_22, t0.last_price_change_at AS last_price_change_at_23, t0.indexed_price_per_m2_amount AS indexed_price_per_m2_amount_24, t0.indexed_market_price_amount AS indexed_market_price_amount_25, t0.indexed_market_price_samples AS indexed_market_price_samples_26, t0.indexed_market_price_computed_at AS indexed_market_price_computed_at_27, t0.min_bid AS min_bid_28, t0.caution AS caution_29, t0.estimated_market_price_amount AS estimated_market_price_amount_30, t0.ai_estimated_market_price_amount AS ai_estimated_market_price_amount_31, t0.estimated_renovation_cost_amount AS estimated_renovation_cost_amount_32, t0.expected_profit_amount AS expected_profit_amount_33, t0.expected_roi AS expected_roi_34, t0.risk_score AS risk_score_35, t0.risk_level AS risk_level_36, t0.risk_flags AS risk_flags_37, t0.metadata AS metadata_38, t0.created_at AS created_at_39, t0.updated_at AS updated_at_40, t0.ruian AS ruian_41, t0.gps_lat AS gps_lat_42, t0.gps_lng AS gps_lng_43, t0.country AS country_44, t0.sourceListingId AS sourceListingId_45 FROM Property t0 WHERE t0.id = ?"
  "params" => [
    1 => "b005a071-9217-41b5-a235-fffcd5e24949"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1142
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT 1 FROM PropertyFavorite WHERE user_id = ? AND property_id = ? LIMIT 1"
  "params" => [
    1 => 1
    2 => "b005a071-9217-41b5-a235-fffcd5e24949"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1142
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1142}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.listing_type AS listing_type_3, t0.url AS url_4, t0.title AS title_5, t0.description AS description_6, t0.first_seen_at AS first_seen_at_7, t0.last_seen_at AS last_seen_at_8, t0.metadata AS metadata_9, t0.normalized AS normalized_10, t0.portal_id AS portal_id_11 FROM SourceListing t0 WHERE t0.id = ?"
  "params" => [
    1 => "a5103707-1ab6-45a9-b19c-ee26eeec5f7b"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1142
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.base_url AS base_url_4, t0.last_scraped_at AS last_scraped_at_5, t0.total_listings AS total_listings_6, t0.last_new_records AS last_new_records_7, t0.last_updated_records AS last_updated_records_8, t0.enabled AS enabled_9, t0.metadata AS metadata_10 FROM Portal t0 WHERE t0.id = ?"
  "params" => [
    1 => "a2e255a0-9609-42e1-a700-7f40c77132a7"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1142
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.provider AS provider_1, p0_.model AS model_2, p0_.input_hash AS input_hash_3, p0_.score AS score_4, p0_.risk_analysis AS risk_analysis_5, p0_.input_payload AS input_payload_6, p0_.output_payload AS output_payload_7, p0_.created_at AS created_at_8, p0_.property_id AS property_id_9 FROM PropertyEvaluation p0_ WHERE p0_.property_id = ? ORDER BY p0_.created_at DESC LIMIT 1"
  "params" => [
    1 => "b005a071-9217-41b5-a235-fffcd5e24949"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1142
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT note_text, updated_at FROM PropertyNote WHERE user_id = ? AND property_id = ? LIMIT 1"
  "params" => [
    1 => 1
    2 => "b005a071-9217-41b5-a235-fffcd5e24949"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1142
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1142}
  ]
]

[
  "sql" => """
    SELECT purchase_price, market_value, renovation_cost, tx_costs, risk_buffer, updated_at\n
                    FROM PropertyCalculationOverride\n
                    WHERE user_id = ? AND property_id = ?\n
                    LIMIT 1
    """
  "params" => [
    1 => 1
    2 => "b005a071-9217-41b5-a235-fffcd5e24949"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1142
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1142}
  ]
]

[
  "sql" => """
    SELECT id, title, due_at, is_done, priority, created_at, updated_at\n
                    FROM PropertyTask\n
                    WHERE user_id = ? AND property_id = ?\n
                    ORDER BY is_done ASC, (due_at IS NULL) ASC, due_at ASC, id DESC
    """
  "params" => [
    1 => 1
    2 => "b005a071-9217-41b5-a235-fffcd5e24949"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1142
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1142}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.type AS type_4, t0.metadata AS metadata_5, t0.property_id AS property_id_6 FROM PropertyImages t0 WHERE t0.property_id = ?"
  "params" => [
    1 => "b005a071-9217-41b5-a235-fffcd5e24949"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1142
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.url AS url_2, t0.url_hash AS url_hash_3, t0.title AS title_4, t0.type AS type_5, t0.metadata AS metadata_6, t0.processing_state AS processing_state_7, t0.processed_at AS processed_at_8, t0.content_hash AS content_hash_9, t0.content_type AS content_type_10, t0.content_text AS content_text_11, t0.processing_last_error AS processing_last_error_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.property_id AS property_id_15 FROM Document t0 WHERE t0.property_id = ? ORDER BY t0.created_at ASC"
  "params" => [
    1 => "b005a071-9217-41b5-a235-fffcd5e24949"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1142
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.price_amount AS price_amount_2, t0.seen_at AS seen_at_3, t0.property_id AS property_id_4 FROM PropertyPriceSnapshot t0 WHERE t0.property_id = ? ORDER BY t0.seen_at DESC LIMIT 120"
  "params" => [
    1 => "b005a071-9217-41b5-a235-fffcd5e24949"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1142
      +name: "STRING"
    }
  ]
]

[
  "key" => "_security_main"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Csrf\SameOriginCsrfTokenManager::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\UX\LiveComponent\EventListener\LiveUrlSubscriber::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]