Symfony Profiler

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

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 = 'b005a071-9217-41b5-a235-fffcd5e24949' ORDER BY t0.created_at ASC;

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

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 = 'b005a071-9217-41b5-a235-fffcd5e24949' ORDER BY t0.seen_at DESC LIMIT 120;

SELECT
  id,
  title,
  due_at,
  is_done,
  priority,
  created_at,
  updated_at
FROM
  PropertyTask
WHERE
  user_id = ?
  AND property_id = ?
ORDER BY
  is_done ASC,
  (due_at IS NULL) ASC,
  due_at ASC,
  id DESC

SELECT id, title, due_at, is_done, priority, created_at, updated_at
                FROM PropertyTask
                WHERE user_id = 1 AND property_id = 'b005a071-9217-41b5-a235-fffcd5e24949'
                ORDER BY is_done ASC, (due_at IS NULL) ASC, due_at ASC, id DESC;

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

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 = 'b005a071-9217-41b5-a235-fffcd5e24949' ORDER BY p0_.created_at DESC LIMIT 1;

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 = ?

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 = 'b005a071-9217-41b5-a235-fffcd5e24949';

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 = ?

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 = 'a2e255a0-9609-42e1-a700-7f40c77132a7';

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 = ?

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 = 1;

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 = ?

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 = 'b005a071-9217-41b5-a235-fffcd5e24949';

SELECT
  1
FROM
  PropertyFavorite
WHERE
  user_id = ?
  AND property_id = ?
LIMIT
  1

SELECT 1 FROM PropertyFavorite WHERE user_id = 1 AND property_id = 'b005a071-9217-41b5-a235-fffcd5e24949' LIMIT 1;

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 = ?

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 = 'a5103707-1ab6-45a9-b19c-ee26eeec5f7b';

SELECT
  note_text,
  updated_at
FROM
  PropertyNote
WHERE
  user_id = ?
  AND property_id = ?
LIMIT
  1

SELECT note_text, updated_at FROM PropertyNote WHERE user_id = 1 AND property_id = 'b005a071-9217-41b5-a235-fffcd5e24949' LIMIT 1;

SELECT
  purchase_price,
  market_value,
  renovation_cost,
  tx_costs,
  risk_buffer,
  updated_at
FROM
  PropertyCalculationOverride
WHERE
  user_id = ?
  AND property_id = ?
LIMIT
  1

SELECT purchase_price, market_value, renovation_cost, tx_costs, risk_buffer, updated_at
                FROM PropertyCalculationOverride
                WHERE user_id = 1 AND property_id = 'b005a071-9217-41b5-a235-fffcd5e24949'
                LIMIT 1;