Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

4.64 ms Query time

1 Invalid entities

3 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.06 ms
(44.45%)

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.slug AS slug_6, t0.linkedin_id AS linkedin_id_7, t0.linkedin_picture AS linkedin_picture_8, t0.linkedin_firstname AS linkedin_firstname_9, t0.linkedin_lastname AS linkedin_lastname_10, t0.created_at AS created_at_11, t0.last_connection AS last_connection_12, t13.id AS id_14, t13.title AS title_15, t13.description AS description_16, t13.city AS city_17, t13.country AS country_18, t13.profile_picture AS profile_picture_19, t13.search_status AS search_status_20, t13.linkedin AS linkedin_21, t13.website AS website_22, t13.created_at AS created_at_23, t13.updated_at AS updated_at_24, t13.deleted_at AS deleted_at_25, t13.firstname AS firstname_26, t13.lastname AS lastname_27, t13.part_time_freelancer AS part_time_freelancer_28, t13.full_time_freelancer AS full_time_freelancer_29, t13.full_time_employment AS full_time_employment_30, t13.level_junior AS level_junior_31, t13.level_mid_level AS level_mid_level_32, t13.level_senior AS level_senior_33, t13.level_staff AS level_staff_34, t13.level_clevel AS level_clevel_35, t13.tel AS tel_36, t13.is_validated AS is_validated_37, t13.featured AS featured_38, t13.user_id AS user_id_39 FROM user t0 LEFT JOIN profile t13 ON t13.user_id = t0.id WHERE t0.id = ?

Parameters:

[
  71
]

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.slug AS slug_6,
  t0.linkedin_id AS linkedin_id_7,
  t0.linkedin_picture AS linkedin_picture_8,
  t0.linkedin_firstname AS linkedin_firstname_9,
  t0.linkedin_lastname AS linkedin_lastname_10,
  t0.created_at AS created_at_11,
  t0.last_connection AS last_connection_12,
  t13.id AS id_14,
  t13.title AS title_15,
  t13.description AS description_16,
  t13.city AS city_17,
  t13.country AS country_18,
  t13.profile_picture AS profile_picture_19,
  t13.search_status AS search_status_20,
  t13.linkedin AS linkedin_21,
  t13.website AS website_22,
  t13.created_at AS created_at_23,
  t13.updated_at AS updated_at_24,
  t13.deleted_at AS deleted_at_25,
  t13.firstname AS firstname_26,
  t13.lastname AS lastname_27,
  t13.part_time_freelancer AS part_time_freelancer_28,
  t13.full_time_freelancer AS full_time_freelancer_29,
  t13.full_time_employment AS full_time_employment_30,
  t13.level_junior AS level_junior_31,
  t13.level_mid_level AS level_mid_level_32,
  t13.level_senior AS level_senior_33,
  t13.level_staff AS level_staff_34,
  t13.level_clevel AS level_clevel_35,
  t13.tel AS tel_36,
  t13.is_validated AS is_validated_37,
  t13.featured AS featured_38,
  t13.user_id AS user_id_39
FROM
  user t0
  LEFT JOIN profile t13 ON t13.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.slug AS slug_6, t0.linkedin_id AS linkedin_id_7, t0.linkedin_picture AS linkedin_picture_8, t0.linkedin_firstname AS linkedin_firstname_9, t0.linkedin_lastname AS linkedin_lastname_10, t0.created_at AS created_at_11, t0.last_connection AS last_connection_12, t13.id AS id_14, t13.title AS title_15, t13.description AS description_16, t13.city AS city_17, t13.country AS country_18, t13.profile_picture AS profile_picture_19, t13.search_status AS search_status_20, t13.linkedin AS linkedin_21, t13.website AS website_22, t13.created_at AS created_at_23, t13.updated_at AS updated_at_24, t13.deleted_at AS deleted_at_25, t13.firstname AS firstname_26, t13.lastname AS lastname_27, t13.part_time_freelancer AS part_time_freelancer_28, t13.full_time_freelancer AS full_time_freelancer_29, t13.full_time_employment AS full_time_employment_30, t13.level_junior AS level_junior_31, t13.level_mid_level AS level_mid_level_32, t13.level_senior AS level_senior_33, t13.level_staff AS level_staff_34, t13.level_clevel AS level_clevel_35, t13.tel AS tel_36, t13.is_validated AS is_validated_37, t13.featured AS featured_38, t13.user_id AS user_id_39 FROM user t0 LEFT JOIN profile t13 ON t13.user_id = t0.id WHERE t0.id = 71;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	App\Controller\ProfileController->viewPublic (line 149)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 185)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

1.09 ms
(23.45%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.background_picture AS background_picture_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.is_validated AS is_validated_7, t0.city AS city_8, t0.is_published AS is_published_9, t0.slug AS slug_10, t0.country AS country_11, t0.summary AS summary_12, t0.events_count AS events_count_13, t0.followers_count AS followers_count_14, t0.host_id AS host_id_15 FROM tribe t0 WHERE t0.host_id = ?

Parameters:

[
  71
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.background_picture AS background_picture_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.is_validated AS is_validated_7,
  t0.city AS city_8,
  t0.is_published AS is_published_9,
  t0.slug AS slug_10,
  t0.country AS country_11,
  t0.summary AS summary_12,
  t0.events_count AS events_count_13,
  t0.followers_count AS followers_count_14,
  t0.host_id AS host_id_15
FROM
  tribe t0
WHERE
  t0.host_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.background_picture AS background_picture_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.is_validated AS is_validated_7, t0.city AS city_8, t0.is_published AS is_published_9, t0.slug AS slug_10, t0.country AS country_11, t0.summary AS summary_12, t0.events_count AS events_count_13, t0.followers_count AS followers_count_14, t0.host_id AS host_id_15 FROM tribe t0 WHERE t0.host_id = 71;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1278)
9	__TwigTemplate_d7698e3c30e0d496739b632d2419c283::block_body (line 304)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_ee4c778ef4474b9db443523d5cd2d0cd->doDisplay (line 838)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_d7698e3c30e0d496739b632d2419c283->doDisplay (line 56)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
22	App\Controller\ProfileController->viewPublic (line 165)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 185)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.85 ms
(18.29%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.profile_id AS profile_id_3 FROM skill t0 INNER JOIN profile_skill ON t0.id = profile_skill.skill_id WHERE profile_skill.profile_id = ?

Parameters:

[
  39
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.profile_id AS profile_id_3
FROM
  skill t0
  INNER JOIN profile_skill ON t0.id = profile_skill.skill_id
WHERE
  profile_skill.profile_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.profile_id AS profile_id_3 FROM skill t0 INNER JOIN profile_skill ON t0.id = profile_skill.skill_id WHERE profile_skill.profile_id = 39;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2737)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1278)
9	__TwigTemplate_d7698e3c30e0d496739b632d2419c283::block_body (line 436)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_ee4c778ef4474b9db443523d5cd2d0cd->doDisplay (line 838)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_d7698e3c30e0d496739b632d2419c283->doDisplay (line 56)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
22	App\Controller\ProfileController->viewPublic (line 165)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 185)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.64 ms
(13.81%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.tribe_id AS tribe_id_4, t0.follower_id AS follower_id_5 FROM tribe_follower t0 WHERE t0.follower_id = ?

Parameters:

[
  71
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.tribe_id AS tribe_id_4,
  t0.follower_id AS follower_id_5
FROM
  tribe_follower t0
WHERE
  t0.follower_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.tribe_id AS tribe_id_4, t0.follower_id AS follower_id_5 FROM tribe_follower t0 WHERE t0.follower_id = 71;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->map (line 259)
7	App\Entity\User->getFollowedTribes (line 353)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_d7698e3c30e0d496739b632d2419c283::block_body (line 333)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_ee4c778ef4474b9db443523d5cd2d0cd->doDisplay (line 838)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_d7698e3c30e0d496739b632d2419c283->doDisplay (line 56)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
22	App\Controller\ProfileController->viewPublic (line 165)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 185)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\User	1
App\Entity\Profile	1
App\Entity\Tribe	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Profile	No errors.
App\Entity\Event	No errors.
App\Entity\EventAttendee	No errors.
App\Entity\Tribe	No errors.
App\Entity\Job	No errors.
App\Entity\TribeFollower	No errors.
App\Entity\JobApplicant	No errors.
App\Entity\TribeCohost	No errors.
App\Entity\EventCohost	No errors.
App\Entity\Skill	The field App\Entity\Skill#profile is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Profile#skills does not contain the required 'mappedBy: "profile"' attribute. If association App\Entity\Skill#profile is many-to-one, then the inversed side App\Entity\Profile#skills has to be one-to-many.

Symfony Profiler

GET https://dev.theremotetribe.co/public/view/qsvohpma-71

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping