Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

5.08 ms Query time

3 Invalid entities

Queries

Group similar statements

#▲

Time

Info

1.38 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.created_at AS created_at_30, t0.updated_at AS updated_at_31, t0.role_id AS role_id_32, t0.agency_id AS agency_id_33, t0.subscriptions_id AS subscriptions_id_34, t0.credit_wallet_id AS credit_wallet_id_35, t36.id AS id_37, t36.balance_credits AS balance_credits_38, t36.last_refill_at AS last_refill_at_39, t36.created_at AS created_at_40, t36.updated_at AS updated_at_41, t0.agent_coverages_id AS agent_coverages_id_42 FROM `user` t0 LEFT JOIN credit_wallet t36 ON t0.credit_wallet_id = t36.id WHERE t0.id IS NULL LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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.created_at AS created_at_30,
  t0.updated_at AS updated_at_31,
  t0.role_id AS role_id_32,
  t0.agency_id AS agency_id_33,
  t0.subscriptions_id AS subscriptions_id_34,
  t0.credit_wallet_id AS credit_wallet_id_35,
  t36.id AS id_37,
  t36.balance_credits AS balance_credits_38,
  t36.last_refill_at AS last_refill_at_39,
  t36.created_at AS created_at_40,
  t36.updated_at AS updated_at_41,
  t0.agent_coverages_id AS agent_coverages_id_42
FROM
  `user` t0
  LEFT JOIN credit_wallet t36 ON t0.credit_wallet_id = t36.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.created_at AS created_at_30, t0.updated_at AS updated_at_31, t0.role_id AS role_id_32, t0.agency_id AS agency_id_33, t0.subscriptions_id AS subscriptions_id_34, t0.credit_wallet_id AS credit_wallet_id_35, t36.id AS id_37, t36.balance_credits AS balance_credits_38, t36.last_refill_at AS last_refill_at_39, t36.created_at AS created_at_40, t36.updated_at AS updated_at_41, t0.agent_coverages_id AS agent_coverages_id_42 FROM `user` t0 LEFT JOIN credit_wallet t36 ON t0.credit_wallet_id = t36.id WHERE t0.id IS NULL LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 42)
5	App\Controller\CustomerRecommandationController->index (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

2.88 ms

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.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.user_id AS user_id_31 FROM preference t0 WHERE t0.user_id IS NULL AND t0.deleted = ? ORDER BY t0.created_at DESC

Parameters:

[
  0
]

View formatted query View runnable query Explain query View query backtrace

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.created_at AS created_at_29,
  t0.updated_at AS updated_at_30,
  t0.user_id AS user_id_31
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.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.user_id AS user_id_31 FROM preference t0 WHERE t0.user_id IS NULL AND t0.deleted = 0 ORDER BY t0.created_at DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 43)
5	App\Controller\CustomerRecommandationController->index (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.82 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
]

View formatted query View runnable query Explain query View query backtrace

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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 44)
5	App\Controller\CustomerRecommandationController->index (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

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.

Symfony Profiler

GET http://www.smartimmo-app.com/customer/recommandation

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping