Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 7
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 3
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Mercure
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.phone AS phone_2, t0.password AS password_3, t0.phonecode AS phonecode_4, t0.firstname AS firstname_5, t0.name AS name_6, t0.terms_and_condition AS terms_and_condition_7, t0.user_type AS user_type_8, t0.account_confirmed AS account_confirmed_9, t0.active AS active_10, t0.is_agent AS is_agent_11, t0.picture AS picture_12, t0.sex AS sex_13, t0.dob AS dob_14, t0.email AS email_15, t0.address AS address_16, t0.agent_phone AS agent_phone_17, t0.agent_phone_code AS agent_phone_code_18, t0.fbck_link AS fbck_link_19, t0.insta_glink AS insta_glink_20, t0.linked_in_link AS linked_in_link_21, t0.code AS code_22, t0.smartimmo_administrator AS smartimmo_administrator_23, t0.block AS block_24, t0.block_reason AS block_reason_25, t0.last_action AS last_action_26, t0.top_agent AS top_agent_27, t0.salutation AS salutation_28, t0.deactivated_at AS deactivated_at_29, t0.bio AS bio_30, t0.video_url AS video_url_31, t0.agent_id_document_url AS agent_id_document_url_32, t0.is_agent_id_valid AS is_agent_id_valid_33, t0.id_uploaded_at AS id_uploaded_at_34, t0.created_at AS created_at_35, t0.updated_at AS updated_at_36, t0.role_id AS role_id_37, t0.agency_id AS agency_id_38, t0.subscriptions_id AS subscriptions_id_39, t0.credit_wallet_id AS credit_wallet_id_40, t41.id AS id_42, t41.balance_credits AS balance_credits_43, t41.last_refill_at AS last_refill_at_44, t41.created_at AS created_at_45, t41.updated_at AS updated_at_46, t0.agent_coverages_id AS agent_coverages_id_47 FROM `user` t0 LEFT JOIN credit_wallet t41 ON t0.credit_wallet_id = t41.id WHERE t0.id IS NULL LIMIT 1

[]

SELECT
  t0.id AS id_1,
  t0.phone AS phone_2,
  t0.password AS password_3,
  t0.phonecode AS phonecode_4,
  t0.firstname AS firstname_5,
  t0.name AS name_6,
  t0.terms_and_condition AS terms_and_condition_7,
  t0.user_type AS user_type_8,
  t0.account_confirmed AS account_confirmed_9,
  t0.active AS active_10,
  t0.is_agent AS is_agent_11,
  t0.picture AS picture_12,
  t0.sex AS sex_13,
  t0.dob AS dob_14,
  t0.email AS email_15,
  t0.address AS address_16,
  t0.agent_phone AS agent_phone_17,
  t0.agent_phone_code AS agent_phone_code_18,
  t0.fbck_link AS fbck_link_19,
  t0.insta_glink AS insta_glink_20,
  t0.linked_in_link AS linked_in_link_21,
  t0.code AS code_22,
  t0.smartimmo_administrator AS smartimmo_administrator_23,
  t0.block AS block_24,
  t0.block_reason AS block_reason_25,
  t0.last_action AS last_action_26,
  t0.top_agent AS top_agent_27,
  t0.salutation AS salutation_28,
  t0.deactivated_at AS deactivated_at_29,
  t0.bio AS bio_30,
  t0.video_url AS video_url_31,
  t0.agent_id_document_url AS agent_id_document_url_32,
  t0.is_agent_id_valid AS is_agent_id_valid_33,
  t0.id_uploaded_at AS id_uploaded_at_34,
  t0.created_at AS created_at_35,
  t0.updated_at AS updated_at_36,
  t0.role_id AS role_id_37,
  t0.agency_id AS agency_id_38,
  t0.subscriptions_id AS subscriptions_id_39,
  t0.credit_wallet_id AS credit_wallet_id_40,
  t41.id AS id_42,
  t41.balance_credits AS balance_credits_43,
  t41.last_refill_at AS last_refill_at_44,
  t41.created_at AS created_at_45,
  t41.updated_at AS updated_at_46,
  t0.agent_coverages_id AS agent_coverages_id_47
FROM
  `user` t0
  LEFT JOIN credit_wallet t41 ON t0.credit_wallet_id = t41.id
WHERE
  t0.id IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.phone AS phone_2, t0.password AS password_3, t0.phonecode AS phonecode_4, t0.firstname AS firstname_5, t0.name AS name_6, t0.terms_and_condition AS terms_and_condition_7, t0.user_type AS user_type_8, t0.account_confirmed AS account_confirmed_9, t0.active AS active_10, t0.is_agent AS is_agent_11, t0.picture AS picture_12, t0.sex AS sex_13, t0.dob AS dob_14, t0.email AS email_15, t0.address AS address_16, t0.agent_phone AS agent_phone_17, t0.agent_phone_code AS agent_phone_code_18, t0.fbck_link AS fbck_link_19, t0.insta_glink AS insta_glink_20, t0.linked_in_link AS linked_in_link_21, t0.code AS code_22, t0.smartimmo_administrator AS smartimmo_administrator_23, t0.block AS block_24, t0.block_reason AS block_reason_25, t0.last_action AS last_action_26, t0.top_agent AS top_agent_27, t0.salutation AS salutation_28, t0.deactivated_at AS deactivated_at_29, t0.bio AS bio_30, t0.video_url AS video_url_31, t0.agent_id_document_url AS agent_id_document_url_32, t0.is_agent_id_valid AS is_agent_id_valid_33, t0.id_uploaded_at AS id_uploaded_at_34, t0.created_at AS created_at_35, t0.updated_at AS updated_at_36, t0.role_id AS role_id_37, t0.agency_id AS agency_id_38, t0.subscriptions_id AS subscriptions_id_39, t0.credit_wallet_id AS credit_wallet_id_40, t41.id AS id_42, t41.balance_credits AS balance_credits_43, t41.last_refill_at AS last_refill_at_44, t41.created_at AS created_at_45, t41.updated_at AS updated_at_46, t0.agent_coverages_id AS agent_coverages_id_47 FROM `user` t0 LEFT JOIN credit_wallet t41 ON t0.credit_wallet_id = t41.id WHERE t0.id IS NULL LIMIT 1;

SELECT t0.id AS id_1, t0.code AS code_2, t0.country AS country_3, t0.province AS province_4, t0.commune AS commune_5, t0.min_price AS min_price_6, t0.max_price AS max_price_7, t0.bedrooms AS bedrooms_8, t0.bathrooms AS bathrooms_9, t0.property_type AS property_type_10, t0.transaction_type AS transaction_type_11, t0.status AS status_12, t0.paid AS paid_13, t0.claim_count AS claim_count_14, t0.can_be_claimed AS can_be_claimed_15, t0.lead_timeframe AS lead_timeframe_16, t0.lead_until AS lead_until_17, t0.must_haves AS must_haves_18, t0.move_in_earliest AS move_in_earliest_19, t0.move_in_latest AS move_in_latest_20, t0.urgency AS urgency_21, t0.alert_duration AS alert_duration_22, t0.alert_frequency AS alert_frequency_23, t0.contact_channel AS contact_channel_24, t0.contact_time AS contact_time_25, t0.whatsapp_consent AS whatsapp_consent_26, t0.deleted AS deleted_27, t0.deleted_at AS deleted_at_28, t0.lead_cost AS lead_cost_29, t0.created_at AS created_at_30, t0.updated_at AS updated_at_31, t0.user_id AS user_id_32, t0.city_id AS city_id_33 FROM preference t0 WHERE t0.user_id IS NULL AND t0.deleted = ? ORDER BY t0.created_at DESC

[
  0
]

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.country AS country_3,
  t0.province AS province_4,
  t0.commune AS commune_5,
  t0.min_price AS min_price_6,
  t0.max_price AS max_price_7,
  t0.bedrooms AS bedrooms_8,
  t0.bathrooms AS bathrooms_9,
  t0.property_type AS property_type_10,
  t0.transaction_type AS transaction_type_11,
  t0.status AS status_12,
  t0.paid AS paid_13,
  t0.claim_count AS claim_count_14,
  t0.can_be_claimed AS can_be_claimed_15,
  t0.lead_timeframe AS lead_timeframe_16,
  t0.lead_until AS lead_until_17,
  t0.must_haves AS must_haves_18,
  t0.move_in_earliest AS move_in_earliest_19,
  t0.move_in_latest AS move_in_latest_20,
  t0.urgency AS urgency_21,
  t0.alert_duration AS alert_duration_22,
  t0.alert_frequency AS alert_frequency_23,
  t0.contact_channel AS contact_channel_24,
  t0.contact_time AS contact_time_25,
  t0.whatsapp_consent AS whatsapp_consent_26,
  t0.deleted AS deleted_27,
  t0.deleted_at AS deleted_at_28,
  t0.lead_cost AS lead_cost_29,
  t0.created_at AS created_at_30,
  t0.updated_at AS updated_at_31,
  t0.user_id AS user_id_32,
  t0.city_id AS city_id_33
FROM
  preference t0
WHERE
  t0.user_id IS NULL
  AND t0.deleted = ?
ORDER BY
  t0.created_at DESC

SELECT t0.id AS id_1, t0.code AS code_2, t0.country AS country_3, t0.province AS province_4, t0.commune AS commune_5, t0.min_price AS min_price_6, t0.max_price AS max_price_7, t0.bedrooms AS bedrooms_8, t0.bathrooms AS bathrooms_9, t0.property_type AS property_type_10, t0.transaction_type AS transaction_type_11, t0.status AS status_12, t0.paid AS paid_13, t0.claim_count AS claim_count_14, t0.can_be_claimed AS can_be_claimed_15, t0.lead_timeframe AS lead_timeframe_16, t0.lead_until AS lead_until_17, t0.must_haves AS must_haves_18, t0.move_in_earliest AS move_in_earliest_19, t0.move_in_latest AS move_in_latest_20, t0.urgency AS urgency_21, t0.alert_duration AS alert_duration_22, t0.alert_frequency AS alert_frequency_23, t0.contact_channel AS contact_channel_24, t0.contact_time AS contact_time_25, t0.whatsapp_consent AS whatsapp_consent_26, t0.deleted AS deleted_27, t0.deleted_at AS deleted_at_28, t0.lead_cost AS lead_cost_29, t0.created_at AS created_at_30, t0.updated_at AS updated_at_31, t0.user_id AS user_id_32, t0.city_id AS city_id_33 FROM preference t0 WHERE t0.user_id IS NULL AND t0.deleted = 0 ORDER BY t0.created_at DESC;

SELECT t0.id AS id_1, t0.preference_price AS preference_price_2, t0.looking_for_agent_url AS looking_for_agent_url_3 FROM admin_configuration t0 WHERE t0.id = ? LIMIT 1

[
  1
]

SELECT
  t0.id AS id_1,
  t0.preference_price AS preference_price_2,
  t0.looking_for_agent_url AS looking_for_agent_url_3
FROM
  admin_configuration t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.preference_price AS preference_price_2, t0.looking_for_agent_url AS looking_for_agent_url_3 FROM admin_configuration t0 WHERE t0.id = 1 LIMIT 1;