Query Metrics
3
Database Queries
3
Different statements
3.43 ms
Query time
3
Invalid entities
Queries
#▲ | 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 |
|
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 |
|
App\Entity\PaymentForPreference | No errors. |
App\Entity\Property | No errors. |
App\Entity\LeadClaims |
|
App\Entity\AdminConfiguration | No errors. |