Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

11.46 ms Query time

0 Invalid entities

26 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

6.67 ms
(58.25%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.roles AS roles_4, t0.is_verified AS is_verified_5, t0.is_active AS is_active_6, t0.phone AS phone_7, t0.google_id AS google_id_8, t0.google_verified AS google_verified_9, t0.avatar AS avatar_10, t0.first_name AS first_name_11, t0.last_name AS last_name_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.reset_token AS reset_token_15, t0.reset_token_expires_at AS reset_token_expires_at_16, t17.id AS id_18, t17.first_name AS first_name_19, t17.last_name AS last_name_20, t17.bio AS bio_21, t17.city AS city_22, t17.country AS country_23, t17.photo AS photo_24, t17.cv_file AS cv_file_25, t17.linkedin_url AS linkedin_url_26, t17.avatar AS avatar_27, t17.user_id AS user_id_28, t29.id AS id_30, t29.name AS name_31, t29.description AS description_32, t29.logo AS logo_33, t29.website AS website_34, t29.sector AS sector_35, t29.size AS size_36, t29.city AS city_37, t29.country AS country_38, t29.user_id AS user_id_39 FROM "user" t0 LEFT JOIN student_profile t17 ON t17.user_id = t0.id LEFT JOIN company_profile t29 ON t29.user_id = t0.id WHERE t0.id = ?

Parameters:

[
  "761859fc-3e98-40a7-8348-ceb0087ae0be"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.password AS password_3,
  t0.roles AS roles_4,
  t0.is_verified AS is_verified_5,
  t0.is_active AS is_active_6,
  t0.phone AS phone_7,
  t0.google_id AS google_id_8,
  t0.google_verified AS google_verified_9,
  t0.avatar AS avatar_10,
  t0.first_name AS first_name_11,
  t0.last_name AS last_name_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.reset_token AS reset_token_15,
  t0.reset_token_expires_at AS reset_token_expires_at_16,
  t17.id AS id_18,
  t17.first_name AS first_name_19,
  t17.last_name AS last_name_20,
  t17.bio AS bio_21,
  t17.city AS city_22,
  t17.country AS country_23,
  t17.photo AS photo_24,
  t17.cv_file AS cv_file_25,
  t17.linkedin_url AS linkedin_url_26,
  t17.avatar AS avatar_27,
  t17.user_id AS user_id_28,
  t29.id AS id_30,
  t29.name AS name_31,
  t29.description AS description_32,
  t29.logo AS logo_33,
  t29.website AS website_34,
  t29.sector AS sector_35,
  t29.size AS size_36,
  t29.city AS city_37,
  t29.country AS country_38,
  t29.user_id AS user_id_39
FROM
  "user" t0
  LEFT JOIN student_profile t17 ON t17.user_id = t0.id
  LEFT JOIN company_profile t29 ON t29.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.roles AS roles_4, t0.is_verified AS is_verified_5, t0.is_active AS is_active_6, t0.phone AS phone_7, t0.google_id AS google_id_8, t0.google_verified AS google_verified_9, t0.avatar AS avatar_10, t0.first_name AS first_name_11, t0.last_name AS last_name_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.reset_token AS reset_token_15, t0.reset_token_expires_at AS reset_token_expires_at_16, t17.id AS id_18, t17.first_name AS first_name_19, t17.last_name AS last_name_20, t17.bio AS bio_21, t17.city AS city_22, t17.country AS country_23, t17.photo AS photo_24, t17.cv_file AS cv_file_25, t17.linkedin_url AS linkedin_url_26, t17.avatar AS avatar_27, t17.user_id AS user_id_28, t29.id AS id_30, t29.name AS name_31, t29.description AS description_32, t29.logo AS logo_33, t29.website AS website_34, t29.sector AS sector_35, t29.size AS size_36, t29.city AS city_37, t29.country AS country_38, t29.user_id AS user_id_39 FROM "user" t0 LEFT JOIN student_profile t17 ON t17.user_id = t0.id LEFT JOIN company_profile t29 ON t29.user_id = t0.id WHERE t0.id = '761859fc-3e98-40a7-8348-ceb0087ae0be';

#	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\ServiceEntityRepository->find (line 66)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 97)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 64)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 191)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 32)
22	require_once (line 5)

4.78 ms
(41.75%)

SELECT o0_.id AS id_0, o0_.title AS title_1, o0_.description AS description_2, o0_.type AS type_3, o0_.work_mode AS work_mode_4, o0_.city AS city_5, o0_.country AS country_6, o0_.salary_min AS salary_min_7, o0_.salary_max AS salary_max_8, o0_.status AS status_9, o0_.created_at AS created_at_10, o0_.expires_at AS expires_at_11, c1_.id AS id_12, c1_.name AS name_13, c1_.description AS description_14, c1_.logo AS logo_15, c1_.website AS website_16, c1_.sector AS sector_17, c1_.size AS size_18, c1_.city AS city_19, c1_.country AS country_20, o0_.company_id AS company_id_21, c1_.user_id AS user_id_22 FROM offer o0_ LEFT JOIN company_profile c1_ ON o0_.company_id = c1_.id ORDER BY o0_.created_at DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  o0_.id AS id_0,
  o0_.title AS title_1,
  o0_.description AS description_2,
  o0_.type AS type_3,
  o0_.work_mode AS work_mode_4,
  o0_.city AS city_5,
  o0_.country AS country_6,
  o0_.salary_min AS salary_min_7,
  o0_.salary_max AS salary_max_8,
  o0_.status AS status_9,
  o0_.created_at AS created_at_10,
  o0_.expires_at AS expires_at_11,
  c1_.id AS id_12,
  c1_.name AS name_13,
  c1_.description AS description_14,
  c1_.logo AS logo_15,
  c1_.website AS website_16,
  c1_.sector AS sector_17,
  c1_.size AS size_18,
  c1_.city AS city_19,
  c1_.country AS country_20,
  o0_.company_id AS company_id_21,
  c1_.user_id AS user_id_22
FROM
  offer o0_
  LEFT JOIN company_profile c1_ ON o0_.company_id = c1_.id
ORDER BY
  o0_.created_at DESC

SELECT o0_.id AS id_0, o0_.title AS title_1, o0_.description AS description_2, o0_.type AS type_3, o0_.work_mode AS work_mode_4, o0_.city AS city_5, o0_.country AS country_6, o0_.salary_min AS salary_min_7, o0_.salary_max AS salary_max_8, o0_.status AS status_9, o0_.created_at AS created_at_10, o0_.expires_at AS expires_at_11, c1_.id AS id_12, c1_.name AS name_13, c1_.description AS description_14, c1_.logo AS logo_15, c1_.website AS website_16, c1_.sector AS sector_17, c1_.size AS size_18, c1_.city AS city_19, c1_.country AS country_20, o0_.company_id AS company_id_21, c1_.user_id AS user_id_22 FROM offer o0_ LEFT JOIN company_profile c1_ ON o0_.company_id = c1_.id ORDER BY o0_.created_at DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Controller\Admin\AdminController->offers (line 344)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 191)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	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\Offer	16
App\Entity\User	5
App\Entity\CompanyProfile	4
App\Entity\StudentProfile	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\StudentProfile	No errors.
App\Entity\CompanyProfile	No errors.
App\Entity\Document	No errors.
App\Entity\Notification	No errors.
App\Entity\ConversationParticipant	No errors.
App\Entity\Message	No errors.
App\Entity\Review	No errors.
App\Entity\AuditLog	No errors.
App\Entity\StudentSkill	No errors.
App\Entity\Application	No errors.
App\Entity\Favorite	No errors.
App\Entity\JobAlert	No errors.
App\Entity\Offer	No errors.
App\Entity\OfferSkill	No errors.

Symfony Profiler

GET http://careerbridge.foulisa.com/admin/offres

Configuration Settings

Theme

Page Width