Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.65 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.89 ms

SELECT s0_.id AS id_0, s0_.fullname AS fullname_1, s0_.age AS age_2, s0_.gender AS gender_3, s0_.intro AS intro_4, s0_.work AS work_5, s0_.target_date AS target_date_6, s0_.budget AS budget_7, s0_.neighbors AS neighbors_8, s0_.prefs AS prefs_9, s0_.title AS title_10, s0_.status AS status_11, s0_.lifestyle AS lifestyle_12, s0_.similarity_distance AS similarity_distance_13, s0_.country AS country_14, s0_.city AS city_15, s0_.region AS region_16, s0_.building_type AS building_type_17, s0_.accomm_type AS accomm_type_18, s0_.number_of_room_mates AS number_of_room_mates_19, s0_.room_mate_age_min AS room_mate_age_min_20, s0_.room_mate_age_max AS room_mate_age_max_21, s0_.lease_duration AS lease_duration_22, s0_.deposit AS deposit_23, s0_.room_mate_gender AS room_mate_gender_24, s0_.description AS description_25, s0_.user_id AS user_id_26 FROM seeker s0_ INNER JOIN `user` u1_ ON (s0_.user_id = u1_.id) WHERE s0_.status = 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.fullname AS fullname_1,
  s0_.age AS age_2,
  s0_.gender AS gender_3,
  s0_.intro AS intro_4,
  s0_.work AS work_5,
  s0_.target_date AS target_date_6,
  s0_.budget AS budget_7,
  s0_.neighbors AS neighbors_8,
  s0_.prefs AS prefs_9,
  s0_.title AS title_10,
  s0_.status AS status_11,
  s0_.lifestyle AS lifestyle_12,
  s0_.similarity_distance AS similarity_distance_13,
  s0_.country AS country_14,
  s0_.city AS city_15,
  s0_.region AS region_16,
  s0_.building_type AS building_type_17,
  s0_.accomm_type AS accomm_type_18,
  s0_.number_of_room_mates AS number_of_room_mates_19,
  s0_.room_mate_age_min AS room_mate_age_min_20,
  s0_.room_mate_age_max AS room_mate_age_max_21,
  s0_.lease_duration AS lease_duration_22,
  s0_.deposit AS deposit_23,
  s0_.room_mate_gender AS room_mate_gender_24,
  s0_.description AS description_25,
  s0_.user_id AS user_id_26
FROM
  seeker s0_
  INNER JOIN `user` u1_ ON (s0_.user_id = u1_.id)
WHERE
  s0_.status = 1

SELECT s0_.id AS id_0, s0_.fullname AS fullname_1, s0_.age AS age_2, s0_.gender AS gender_3, s0_.intro AS intro_4, s0_.work AS work_5, s0_.target_date AS target_date_6, s0_.budget AS budget_7, s0_.neighbors AS neighbors_8, s0_.prefs AS prefs_9, s0_.title AS title_10, s0_.status AS status_11, s0_.lifestyle AS lifestyle_12, s0_.similarity_distance AS similarity_distance_13, s0_.country AS country_14, s0_.city AS city_15, s0_.region AS region_16, s0_.building_type AS building_type_17, s0_.accomm_type AS accomm_type_18, s0_.number_of_room_mates AS number_of_room_mates_19, s0_.room_mate_age_min AS room_mate_age_min_20, s0_.room_mate_age_max AS room_mate_age_max_21, s0_.lease_duration AS lease_duration_22, s0_.deposit AS deposit_23, s0_.room_mate_gender AS room_mate_gender_24, s0_.description AS description_25, s0_.user_id AS user_id_26 FROM seeker s0_ INNER JOIN `user` u1_ ON (s0_.user_id = u1_.id) WHERE s0_.status = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 301)
7	App\Repository\SeekerRepository->getResult (line 45)
8	App\Repository\SeekerRepository->getEnabledSeekers (line 26)
9	App\Controller\SeekerController->index (line 178)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.77 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.type AS type_6, t0.status AS status_7, t0.token AS token_8, t9.id AS id_10, t9.fullname AS fullname_11, t9.phone AS phone_12, t9.address AS address_13, t9.facebook_id AS facebook_id_14, t9.instagram_id AS instagram_id_15, t9.bio AS bio_16, t9.avatar AS avatar_17, t9.gender AS gender_18, t9.age AS age_19, t9.education AS education_20, t9.languages AS languages_21, t9.job AS job_22, t9.relationship AS relationship_23, t9.idcard_no AS idcard_no_24, t9.ems_phone_number AS ems_phone_number_25, t9.profile_type AS profile_type_26, t9.skills AS skills_27, t9.created_at AS created_at_28, t9.viewed AS viewed_29, t9.company_name AS company_name_30, t9.telegram_id AS telegram_id_31, t9.linkedin_id AS linkedin_id_32, t9.whatsapp_number AS whatsapp_number_33, t9.website AS website_34, t9.email AS email_35, t9.conditions_and_rules AS conditions_and_rules_36, t9.user_id AS user_id_37, t38.id AS id_39, t38.fullname AS fullname_40, t38.age AS age_41, t38.gender AS gender_42, t38.intro AS intro_43, t38.work AS work_44, t38.target_date AS target_date_45, t38.budget AS budget_46, t38.neighbors AS neighbors_47, t38.prefs AS prefs_48, t38.title AS title_49, t38.status AS status_50, t38.lifestyle AS lifestyle_51, t38.similarity_distance AS similarity_distance_52, t38.country AS country_53, t38.city AS city_54, t38.region AS region_55, t38.building_type AS building_type_56, t38.accomm_type AS accomm_type_57, t38.number_of_room_mates AS number_of_room_mates_58, t38.room_mate_age_min AS room_mate_age_min_59, t38.room_mate_age_max AS room_mate_age_max_60, t38.lease_duration AS lease_duration_61, t38.deposit AS deposit_62, t38.room_mate_gender AS room_mate_gender_63, t38.description AS description_64, t38.user_id AS user_id_65 FROM `user` t0 LEFT JOIN profile t9 ON t9.user_id = t0.id LEFT JOIN seeker t38 ON t38.user_id = t0.id WHERE t0.id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_verified AS is_verified_5,
  t0.type AS type_6,
  t0.status AS status_7,
  t0.token AS token_8,
  t9.id AS id_10,
  t9.fullname AS fullname_11,
  t9.phone AS phone_12,
  t9.address AS address_13,
  t9.facebook_id AS facebook_id_14,
  t9.instagram_id AS instagram_id_15,
  t9.bio AS bio_16,
  t9.avatar AS avatar_17,
  t9.gender AS gender_18,
  t9.age AS age_19,
  t9.education AS education_20,
  t9.languages AS languages_21,
  t9.job AS job_22,
  t9.relationship AS relationship_23,
  t9.idcard_no AS idcard_no_24,
  t9.ems_phone_number AS ems_phone_number_25,
  t9.profile_type AS profile_type_26,
  t9.skills AS skills_27,
  t9.created_at AS created_at_28,
  t9.viewed AS viewed_29,
  t9.company_name AS company_name_30,
  t9.telegram_id AS telegram_id_31,
  t9.linkedin_id AS linkedin_id_32,
  t9.whatsapp_number AS whatsapp_number_33,
  t9.website AS website_34,
  t9.email AS email_35,
  t9.conditions_and_rules AS conditions_and_rules_36,
  t9.user_id AS user_id_37,
  t38.id AS id_39,
  t38.fullname AS fullname_40,
  t38.age AS age_41,
  t38.gender AS gender_42,
  t38.intro AS intro_43,
  t38.work AS work_44,
  t38.target_date AS target_date_45,
  t38.budget AS budget_46,
  t38.neighbors AS neighbors_47,
  t38.prefs AS prefs_48,
  t38.title AS title_49,
  t38.status AS status_50,
  t38.lifestyle AS lifestyle_51,
  t38.similarity_distance AS similarity_distance_52,
  t38.country AS country_53,
  t38.city AS city_54,
  t38.region AS region_55,
  t38.building_type AS building_type_56,
  t38.accomm_type AS accomm_type_57,
  t38.number_of_room_mates AS number_of_room_mates_58,
  t38.room_mate_age_min AS room_mate_age_min_59,
  t38.room_mate_age_max AS room_mate_age_max_60,
  t38.lease_duration AS lease_duration_61,
  t38.deposit AS deposit_62,
  t38.room_mate_gender AS room_mate_gender_63,
  t38.description AS description_64,
  t38.user_id AS user_id_65
FROM
  `user` t0
  LEFT JOIN profile t9 ON t9.user_id = t0.id
  LEFT JOIN seeker t38 ON t38.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.type AS type_6, t0.status AS status_7, t0.token AS token_8, t9.id AS id_10, t9.fullname AS fullname_11, t9.phone AS phone_12, t9.address AS address_13, t9.facebook_id AS facebook_id_14, t9.instagram_id AS instagram_id_15, t9.bio AS bio_16, t9.avatar AS avatar_17, t9.gender AS gender_18, t9.age AS age_19, t9.education AS education_20, t9.languages AS languages_21, t9.job AS job_22, t9.relationship AS relationship_23, t9.idcard_no AS idcard_no_24, t9.ems_phone_number AS ems_phone_number_25, t9.profile_type AS profile_type_26, t9.skills AS skills_27, t9.created_at AS created_at_28, t9.viewed AS viewed_29, t9.company_name AS company_name_30, t9.telegram_id AS telegram_id_31, t9.linkedin_id AS linkedin_id_32, t9.whatsapp_number AS whatsapp_number_33, t9.website AS website_34, t9.email AS email_35, t9.conditions_and_rules AS conditions_and_rules_36, t9.user_id AS user_id_37, t38.id AS id_39, t38.fullname AS fullname_40, t38.age AS age_41, t38.gender AS gender_42, t38.intro AS intro_43, t38.work AS work_44, t38.target_date AS target_date_45, t38.budget AS budget_46, t38.neighbors AS neighbors_47, t38.prefs AS prefs_48, t38.title AS title_49, t38.status AS status_50, t38.lifestyle AS lifestyle_51, t38.similarity_distance AS similarity_distance_52, t38.country AS country_53, t38.city AS city_54, t38.region AS region_55, t38.building_type AS building_type_56, t38.accomm_type AS accomm_type_57, t38.number_of_room_mates AS number_of_room_mates_58, t38.room_mate_age_min AS room_mate_age_min_59, t38.room_mate_age_max AS room_mate_age_max_60, t38.lease_duration AS lease_duration_61, t38.deposit AS deposit_62, t38.room_mate_gender AS room_mate_gender_63, t38.description AS description_64, t38.user_id AS user_id_65 FROM `user` t0 LEFT JOIN profile t9 ON t9.user_id = t0.id LEFT JOIN seeker t38 ON t38.user_id = t0.id WHERE t0.id = 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 364)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 471)
5	Proxies\__CG__\App\Entity\User::Doctrine\ORM\Proxy\{closure} (line 61)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 120)
7	Proxies\__CG__\App\Entity\User->__get (line 167)
8	App\Entity\User->getProfile (line 1740)
9	Twig\Extension\CoreExtension::getAttribute (line 245)
10	__TwigTemplate_2c8cff5c359f77c313cb8e9bb6f38019->block_body (line 442)
11	Twig\Template->yieldBlock (line 222)
12	__TwigTemplate_1517c73260ff19609277ee9bec664269->doDisplay (line 398)
13	Twig\Template->yield (line 54)
14	__TwigTemplate_2c8cff5c359f77c313cb8e9bb6f38019->doDisplay (line 398)
15	Twig\Template->yield (line 354)
16	Twig\Template->display (line 369)
17	Twig\Template->render (line 38)
18	Twig\TemplateWrapper->render (line 306)
19	Twig\Environment->render (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 41)
23	App\Controller\SeekerController->index (line 178)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	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\Seeker	No errors.
App\Entity\User	No errors.
App\Entity\Profile	No errors.
App\Entity\LeaseHold	No errors.
App\Entity\Roomie	No errors.
App\Entity\Connection	No errors.
App\Entity\Message	No errors.
App\Entity\Favorite	No errors.
App\Entity\Comment	No errors.

Symfony Profiler

GET http://roommeit.ir/fa/renter

Configuration Settings

Theme