Symfony Profiler

Query Metrics

7 Database Queries

7 Different statements

7.60 ms Query time

4 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.34 ms
(17.57%)

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.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.user_id AS user_id_29 FROM preference t0 WHERE t0.id = ?

Parameters:

[
  "82"
]

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.created_at AS created_at_27,
  t0.updated_at AS updated_at_28,
  t0.user_id AS user_id_29
FROM
  preference t0
WHERE
  t0.id = ?

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.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.user_id AS user_id_29 FROM preference t0 WHERE t0.id = '82';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 146)
7	App\Controller\JobOpportunityController->showModal (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

1.24 ms
(16.24%)

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 = ?

Parameters:

[
  1
]

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.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 = ?

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 = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\User::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 104)
7	Proxies\__CG__\App\Entity\User->initializeLazyObject (line 20)
8	Proxies\__CG__\App\Entity\User->__load (line 102)
9	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 207)
10	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
11	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
12	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 73)
13	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->Symfony\Bundle\SecurityBundle\Security\{closure} (line 34)
14	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 44)
15	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 364)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->getUser (line 147)
17	App\Controller\JobOpportunityController->showModal (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

1.23 ms
(16.17%)

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.created_at AS created_at_37, t9.updated_at AS updated_at_38, t9.role_id AS role_id_39, t9.agency_id AS agency_id_40, t9.subscriptions_id AS subscriptions_id_41, t9.credit_wallet_id AS credit_wallet_id_42, t9.agent_coverages_id AS agent_coverages_id_43, t0.subscription_id AS subscription_id_44 FROM payment_for_membership t0 LEFT JOIN `user` t9 ON t0.user_id = t9.id WHERE t0.user_id IN (?)

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

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.created_at AS created_at_37,
  t9.updated_at AS updated_at_38,
  t9.role_id AS role_id_39,
  t9.agency_id AS agency_id_40,
  t9.subscriptions_id AS subscriptions_id_41,
  t9.credit_wallet_id AS credit_wallet_id_42,
  t9.agent_coverages_id AS agent_coverages_id_43,
  t0.subscription_id AS subscription_id_44
FROM
  payment_for_membership t0
  LEFT JOIN `user` t9 ON t0.user_id = t9.id
WHERE
  t0.user_id IN (?)

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.created_at AS created_at_37, t9.updated_at AS updated_at_38, t9.role_id AS role_id_39, t9.agency_id AS agency_id_40, t9.subscriptions_id AS subscriptions_id_41, t9.credit_wallet_id AS credit_wallet_id_42, t9.agent_coverages_id AS agent_coverages_id_43, t0.subscription_id AS subscription_id_44 FROM payment_for_membership t0 LEFT JOIN `user` t9 ON t0.user_id = t9.id WHERE t0.user_id IN (1);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 2654)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2630)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 120)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 170)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 742)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
8	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
9	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
10	Proxies\__CG__\App\Entity\User::Doctrine\ORM\Proxy\{closure} (line 100)
11	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 104)
12	Proxies\__CG__\App\Entity\User->initializeLazyObject (line 20)
13	Proxies\__CG__\App\Entity\User->__load (line 102)
14	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 207)
15	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
16	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
17	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 73)
18	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->Symfony\Bundle\SecurityBundle\Security\{closure} (line 34)
19	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 44)
20	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 364)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->getUser (line 147)
22	App\Controller\JobOpportunityController->showModal (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

1.14 ms
(14.95%)

SELECT 1 AS sclr_0 FROM lead_claims l0_ WHERE l0_.lead_id = ? AND l0_.agent_id = ? AND l0_.status IN (?, ?, ?) LIMIT 1

Parameters:

[
  82
  1
  "claimed"
  "in_progress"
  "won"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  1 AS sclr_0
FROM
  lead_claims l0_
WHERE
  l0_.lead_id = ?
  AND l0_.agent_id = ?
  AND l0_.status IN (?, ?, ?)
LIMIT
  1

SELECT 1 AS sclr_0 FROM lead_claims l0_ WHERE l0_.lead_id = 82 AND l0_.agent_id = 1 AND l0_.status IN ('claimed', 'in_progress', 'won') LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 59)
7	App\Repository\LeadClaimsRepository->userHasClaimOnLead (line 33)
8	App\Service\LeadService->isClaimedByUser (line 147)
9	App\Controller\JobOpportunityController->showModal (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

1.11 ms
(14.54%)

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.credit_wallet_id IN (?)

Parameters:

[
  1
]

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.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.credit_wallet_id IN (?)

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.credit_wallet_id IN (1);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 2654)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2630)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 120)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 170)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 742)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
8	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
9	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
10	Proxies\__CG__\App\Entity\User::Doctrine\ORM\Proxy\{closure} (line 100)
11	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 104)
12	Proxies\__CG__\App\Entity\User->initializeLazyObject (line 20)
13	Proxies\__CG__\App\Entity\User->__load (line 102)
14	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 207)
15	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
16	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
17	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 73)
18	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->Symfony\Bundle\SecurityBundle\Security\{closure} (line 34)
19	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 44)
20	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 364)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->getUser (line 147)
22	App\Controller\JobOpportunityController->showModal (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.83 ms
(10.94%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM privilege t0 INNER JOIN role_privilege ON t0.id = role_privilege.privilege_id WHERE role_privilege.role_id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3
FROM
  privilege t0
  INNER JOIN role_privilege ON t0.id = role_privilege.privilege_id
WHERE
  role_privilege.role_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM privilege t0 INNER JOIN role_privilege ON t0.id = role_privilege.privilege_id WHERE role_privilege.role_id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1079)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1008)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2710)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 304)
8	App\Entity\User->getRoles (line 303)
9	Symfony\Component\Security\Http\Firewall\ContextListener::hasUserChanged (line 212)
10	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
11	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
12	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 73)
13	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->Symfony\Bundle\SecurityBundle\Security\{closure} (line 34)
14	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 44)
15	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 364)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->getUser (line 147)
17	App\Controller\JobOpportunityController->showModal (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.73 ms
(9.58%)

SELECT t0.id AS id_1, t0.name AS name_2 FROM roles t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  roles t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM roles t0 WHERE t0.id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Role::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\Role->__get (line 106)
8	App\Entity\Role->getPrivilege (line 304)
9	App\Entity\User->getRoles (line 303)
10	Symfony\Component\Security\Http\Firewall\ContextListener::hasUserChanged (line 212)
11	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
12	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
13	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 73)
14	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->Symfony\Bundle\SecurityBundle\Security\{closure} (line 34)
15	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 44)
16	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 364)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->getUser (line 147)
18	App\Controller\JobOpportunityController->showModal (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	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\Preference	The association App\Entity\Preference#leadClaims refers to the owning side field App\Entity\LeadClaims#leadId which does not exist.
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\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\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\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	The association App\Entity\Reservation#services refers to the inverse side field App\Entity\ServiceSup#reservations which does not exist.
App\Entity\Invoice	No errors.
App\Entity\Rating	No errors.
App\Entity\PaymentForMembership	No errors.
App\Entity\Privilege	No errors.

Symfony Profiler

GET https://smartimmo-app.com/job-opportunity/customer-requests/82/modal

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping