Symfony Profiler

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

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

SELECT
  COUNT(v0_.id) AS sclr_0
FROM
  viewed_properties v0_
WHERE
  v0_.user_id = ?

SELECT COUNT(v0_.id) AS sclr_0 FROM viewed_properties v0_ WHERE v0_.user_id = 3;

SELECT
  v0_.id AS id_0,
  v0_.viewed_at AS viewed_at_1,
  v0_.user_id AS user_id_2,
  v0_.property_id AS property_id_3
FROM
  viewed_properties v0_
WHERE
  v0_.user_id = ?
ORDER BY
  v0_.viewed_at DESC
LIMIT
  25

SELECT v0_.id AS id_0, v0_.viewed_at AS viewed_at_1, v0_.user_id AS user_id_2, v0_.property_id AS property_id_3 FROM viewed_properties v0_ WHERE v0_.user_id = 3 ORDER BY v0_.viewed_at DESC LIMIT 25;

SELECT
  t0.id AS id_1,
  t0.key AS key_2,
  t0.value AS value_3
FROM
  settings t0
WHERE
  t0.key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.key AS key_2, t0.value AS value_3 FROM settings t0 WHERE t0.key = 'theme' LIMIT 1;

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

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

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

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

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

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

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

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

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

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