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

Query Metrics

10 Database Queries
10 Different statements
4.73 ms Query time
1 Invalid entities
9 Managed entities

Queries

Group similar statements

# Time Info
1 0.45 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:
[
  3
]
2 0.50 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:
[
  "154552"
]
3 0.32 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:
[
  3
  154552
]
4 0.16 ms
"START TRANSACTION"
Parameters:
[]
5 0.31 ms
INSERT INTO viewed_properties (viewed_at, user_id, property_id) VALUES (?, ?, ?)
Parameters:
[
  "2026-03-21 01:04:29"
  3
  154552
]
6 1.10 ms
UPDATE users SET credits = ? WHERE id = ?
Parameters:
[
  995
  3
]
7 0.28 ms
UPDATE properties SET comps_value = ?, current_value = ?, fix_cost = ?, flip_profit = ?, flip_margin = ?, propiq_score = ?, updated_at = ? WHERE id = ?
Parameters:
[
  1698700.0
  1121100.0
  157000.0
  420600.0
  24.76
  71.14
  "2026-03-21 01:04:29"
  154552
]
8 0.49 ms
"COMMIT"
Parameters:
[]
9 0.33 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"
]
10 0.80 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:
[
  154552
]

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\Setting No errors.