GET https://dev.flipcheaphousesleads.com/deals/117844

Query Metrics

11 Database Queries
11 Different statements
12.58 ms Query time
1 Invalid entities
9 Managed entities

Queries

Group similar statements

# Time Info
1 0.54 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.password AS password_4, t0.tier AS tier_5, t0.zip AS zip_6, t0.credits AS credits_7, t0.created_at AS created_at_8, t0.last_login AS last_login_9 FROM users t0 WHERE t0.id = ?
Parameters:
[
  1
]
2 0.55 ms
SELECT t0.id AS id_1, t0.address AS address_2, t0.city AS city_3, t0.state AS state_4, t0.zip AS zip_5, t0.owner_name AS owner_name_6, t0.owner_address AS owner_address_7, t0.owner_city AS owner_city_8, t0.owner_state AS owner_state_9, t0.owner_zip AS owner_zip_10, t0.owner_phone AS owner_phone_11, t0.owner_email AS owner_email_12, t0.owner_properties_count AS owner_properties_count_13, t0.owner_meta AS owner_meta_14, t0.property_meta AS property_meta_15, t0.comps_value AS comps_value_16, t0.comps_refreshed_at AS comps_refreshed_at_17, t0.current_value AS current_value_18, t0.fix_cost AS fix_cost_19, t0.flip_profit AS flip_profit_20, t0.flip_margin AS flip_margin_21, t0.propiq_score AS propiq_score_22, t0.scored_at AS scored_at_23, t0.is_synthetic AS is_synthetic_24, t0.data_source AS data_source_25, t0.crawled_at AS crawled_at_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28 FROM properties t0 WHERE t0.id = ?
Parameters:
[
  "117844"
]
3 1.01 ms
SELECT t0.id AS id_1, t0.viewed_at AS viewed_at_2, t0.user_id AS user_id_3, t0.property_id AS property_id_4 FROM viewed_properties t0 WHERE t0.user_id = ? AND t0.property_id = ? LIMIT 1
Parameters:
[
  1
  117844
]
4 0.12 ms
"START TRANSACTION"
Parameters:
[]
5 2.02 ms
INSERT INTO viewed_properties (viewed_at, user_id, property_id) VALUES (?, ?, ?)
Parameters:
[
  "2026-03-21 06:01:44"
  1
  117844
]
6 0.31 ms
UPDATE users SET credits = ? WHERE id = ?
Parameters:
[
  998
  1
]
7 1.06 ms
UPDATE properties SET comps_value = ?, current_value = ?, fix_cost = ?, flip_profit = ?, flip_margin = ?, propiq_score = ?, updated_at = ? WHERE id = ?
Parameters:
[
  2857400.0
  1371600.0
  150900.0
  1334900.0
  46.72
  96.08
  "2026-03-21 06:01:44"
  117844
]
8 0.53 ms
"COMMIT"
Parameters:
[]
9 1.01 ms
SELECT t0.id AS id_1, t0.saved_at AS saved_at_2, t0.user_id AS user_id_3, t0.property_id AS property_id_4 FROM saved_properties t0 WHERE t0.user_id = ? AND t0.property_id = ? LIMIT 1
Parameters:
[
  1
  117844
]
10 1.00 ms
SELECT t0.id AS id_1, t0.key AS key_2, t0.value AS value_3 FROM settings t0 WHERE t0.key = ? LIMIT 1
Parameters:
[
  "theme"
]
11 4.43 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.taken_at AS taken_at_3, t0.ai_analysis AS ai_analysis_4, t0.created_at AS created_at_5, t0.property_id AS property_id_6 FROM property_photos t0 WHERE t0.property_id = ? ORDER BY t0.taken_at DESC
Parameters:
[
  117844
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\PropertyPhoto 5
App\Entity\User 1
App\Entity\Property 1
App\Entity\ViewedProperty 1
App\Entity\Setting 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Property
  • The field 'App\Entity\Property#compsValue' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Property#currentValue' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Property#fixCost' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Property#flipProfit' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Property#flipMargin' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Property#propiqScore' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\PropertyPhoto No errors.
App\Entity\ViewedProperty No errors.
App\Entity\SavedProperty No errors.
App\Entity\Setting No errors.