GET https://smartimmo-app.com/customer/recommandation

Query Metrics

3 Database Queries
3 Different statements
3.43 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 1.45 ms
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.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.role_id AS role_id_30, t0.agency_id AS agency_id_31, t0.subscriptions_id AS subscriptions_id_32, t0.credit_wallet_id AS credit_wallet_id_33, t34.id AS id_35, t34.balance_credits AS balance_credits_36, t34.last_refill_at AS last_refill_at_37, t34.created_at AS created_at_38, t34.updated_at AS updated_at_39, t0.agent_coverages_id AS agent_coverages_id_40 FROM `user` t0 LEFT JOIN credit_wallet t34 ON t0.credit_wallet_id = t34.id WHERE t0.id IS NULL LIMIT 1
Parameters:
[]
2 1.08 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.province AS province_3, t0.commune AS commune_4, t0.min_price AS min_price_5, t0.max_price AS max_price_6, t0.bedrooms AS bedrooms_7, t0.bathrooms AS bathrooms_8, t0.property_type AS property_type_9, t0.transaction_type AS transaction_type_10, t0.status AS status_11, t0.paid AS paid_12, t0.claim_count AS claim_count_13, t0.can_be_claimed AS can_be_claimed_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.user_id AS user_id_17 FROM preference t0 WHERE t0.user_id IS NULL ORDER BY t0.created_at DESC
Parameters:
[]
3 0.90 ms
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
Parameters:
[
  1
]

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.

Entities Mapping

Class Mapping errors
App\Entity\User
  • The association App\Entity\User#messengers refers to the owning side field App\Entity\Messenger#receiver which does not exist.
  • The association App\Entity\User#messengersSender refers to the owning side field App\Entity\Messenger#sender which does not exist.
App\Entity\Role No errors.
App\Entity\Agency No errors.
App\Entity\Subscriptions No errors.
App\Entity\CreditWallet No errors.
App\Entity\AgentCoverages No errors.
App\Entity\Preference
  • The association App\Entity\Preference#leadClaims refers to the owning side field App\Entity\LeadClaims#leadId which does not exist.
App\Entity\PaymentForPreference No errors.
App\Entity\Property No errors.
App\Entity\LeadClaims
  • The mappings App\Entity\LeadClaims#lead and App\Entity\Preference#leadClaims are inconsistent with each other.
App\Entity\AdminConfiguration No errors.