Query Metrics
4
Database Queries
4
Different statements
7.88 ms
Query time
4
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.99 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.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.phone = ? LIMIT 1
Parameters:
[
"843224358"
]
|
||||||||||||||||||||||||||||||||
| 2 | 1.53 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.amount AS amount_3, t0.transaction_id AS transaction_id_4, t0.status AS status_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.user_id AS user_id_8, t9.id AS id_10, t9.phone AS phone_11, t9.password AS password_12, t9.phonecode AS phonecode_13, t9.firstname AS firstname_14, t9.name AS name_15, t9.terms_and_condition AS terms_and_condition_16, t9.user_type AS user_type_17, t9.account_confirmed AS account_confirmed_18, t9.active AS active_19, t9.is_agent AS is_agent_20, t9.picture AS picture_21, t9.sex AS sex_22, t9.dob AS dob_23, t9.email AS email_24, t9.address AS address_25, t9.agent_phone AS agent_phone_26, t9.agent_phone_code AS agent_phone_code_27, t9.fbck_link AS fbck_link_28, t9.insta_glink AS insta_glink_29, t9.linked_in_link AS linked_in_link_30, t9.code AS code_31, t9.smartimmo_administrator AS smartimmo_administrator_32, t9.block AS block_33, t9.block_reason AS block_reason_34, t9.last_action AS last_action_35, t9.top_agent AS top_agent_36, t9.salutation AS salutation_37, t9.deactivated_at AS deactivated_at_38, t9.bio AS bio_39, t9.video_url AS video_url_40, t9.agent_id_document_url AS agent_id_document_url_41, t9.is_agent_id_valid AS is_agent_id_valid_42, t9.id_uploaded_at AS id_uploaded_at_43, t9.created_at AS created_at_44, t9.updated_at AS updated_at_45, t9.role_id AS role_id_46, t9.agency_id AS agency_id_47, t9.subscriptions_id AS subscriptions_id_48, t9.credit_wallet_id AS credit_wallet_id_49, t9.agent_coverages_id AS agent_coverages_id_50, t0.subscription_id AS subscription_id_51, t0.plan_id AS plan_id_52 FROM payment_for_membership t0 LEFT JOIN `user` t9 ON t0.user_id = t9.id WHERE t0.user_id IN (?)
Parameters:
[
252
]
|
||||||||||||||||||||||||||||||||
| 3 | 1.32 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.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.credit_wallet_id IN (?)
Parameters:
[
3
]
|
||||||||||||||||||||||||||||||||
| 4 | 3.03 ms |
SELECT t0.id AS id_1, t0.token AS token_2, t0.confirmed AS confirmed_3, t0.code AS code_4, t0.user_id AS user_id_5 FROM account_reset_password t0 WHERE t0.user_id = ? AND t0.code = ? AND t0.confirmed = ? LIMIT 1
Parameters:
[ 252 "69e75e6a1235f" 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 |
|
| 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\Favoris | No errors. |
| App\Entity\Property | No errors. |
| App\Entity\Message | No errors. |
| App\Entity\Messenger | No errors. |
| App\Entity\AccountResetPassword | No errors. |
| App\Entity\AgencyAgent | No errors. |
| App\Entity\PropertyReport | No errors. |
| App\Entity\Reservation |
|
| App\Entity\Invoice | No errors. |
| App\Entity\Preference |
|
| App\Entity\Rating | No errors. |
| App\Entity\PaymentForPreference | No errors. |
| App\Entity\LeadClaims |
|
| App\Entity\PaymentForMembership | No errors. |
| App\Entity\Province | No errors. |
| App\Entity\CreditTransaction | No errors. |
| App\Entity\PropertyView | No errors. |
| App\Entity\DeviceToken | No errors. |
| App\Entity\MembershipPlans | No errors. |