Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.23 ms Query time

0 Invalid entities

4 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.44 ms
(35.49%)

SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.description AS description_2, j0_.location AS location_3, j0_.salary AS salary_4, j0_.created_at AS created_at_5, j0_.requirements AS requirements_6, j0_.benefits AS benefits_7, j0_.job_type AS job_type_8, j0_.experience_level AS experience_level_9, j0_.is_active AS is_active_10, j0_.user_id AS user_id_11, j0_.company_id AS company_id_12, j0_.location_id AS location_id_13 FROM job_offre j0_ WHERE j0_.id = ? AND j0_.is_active = 1 LIMIT 1

Parameters:

[
  23
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j0_.id AS id_0,
  j0_.title AS title_1,
  j0_.description AS description_2,
  j0_.location AS location_3,
  j0_.salary AS salary_4,
  j0_.created_at AS created_at_5,
  j0_.requirements AS requirements_6,
  j0_.benefits AS benefits_7,
  j0_.job_type AS job_type_8,
  j0_.experience_level AS experience_level_9,
  j0_.is_active AS is_active_10,
  j0_.user_id AS user_id_11,
  j0_.company_id AS company_id_12,
  j0_.location_id AS location_id_13
FROM
  job_offre j0_
WHERE
  j0_.id = ?
  AND j0_.is_active = 1
LIMIT
  1

SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.description AS description_2, j0_.location AS location_3, j0_.salary AS salary_4, j0_.created_at AS created_at_5, j0_.requirements AS requirements_6, j0_.benefits AS benefits_7, j0_.job_type AS job_type_8, j0_.experience_level AS experience_level_9, j0_.is_active AS is_active_10, j0_.user_id AS user_id_11, j0_.company_id AS company_id_12, j0_.location_id AS location_id_13 FROM job_offre j0_ WHERE j0_.id = 23 AND j0_.is_active = 1 LIMIT 1;

#	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->getOneOrNullResult (line 737)
6	App\Repository\JobOffreRepository->findOneActiveById (line 83)
7	App\BusinessLayer\PublicShare\ShareJobService->findActiveJobById (line 37)
8	App\Controller\JobShareController->show (line 58)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

0.43 ms
(35.24%)

SELECT t0.id AS id_1, t0.geoname_id AS geoname_id_2, t0.label AS label_3, t0.city AS city_4, t0.region AS region_5, t0.country_code AS country_code_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8 FROM location t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.geoname_id AS geoname_id_2,
  t0.label AS label_3,
  t0.city AS city_4,
  t0.region AS region_5,
  t0.country_code AS country_code_6,
  t0.latitude AS latitude_7,
  t0.longitude AS longitude_8
FROM
  location t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.geoname_id AS geoname_id_2, t0.label AS label_3, t0.city AS city_4, t0.region AS region_5, t0.country_code AS country_code_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8 FROM location t0 WHERE t0.id = 3;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():294} (line 295)
4	Proxies\__CG__\App\Entity\Location::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():371}:372} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 59)
6	Proxies\__CG__\App\Entity\Location->__get (line 129)
7	App\Entity\Location->getLabel (line 70)
8	App\BusinessLayer\PublicShare\SeoMetaBuilder->buildJobMeta (line 59)
9	App\Controller\JobShareController->show (line 68)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 182)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

0.36 ms
(29.27%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.address_street AS address_street_3, t0.address_number AS address_number_4, t0.address_city AS address_city_5, t0.address_zip_code AS address_zip_code_6, t0.address_country AS address_country_7, t0.phone_number AS phone_number_8, t0.email AS email_9, t0.default_benefits AS default_benefits_10, t0.profile_picture AS profile_picture_11, t0.ethereum_address AS ethereum_address_12, t0.is_verified AS is_verified_13, t0.is_integrator AS is_integrator_14, t0.integrator_code AS integrator_code_15, t0.integrator_code_enabled AS integrator_code_enabled_16, t0.integrated_at AS integrated_at_17, t0.premium_subscription_company_date AS premium_subscription_company_date_18, t0.paypal_subscription_id AS paypal_subscription_id_19, t0.paypal_subscription_status AS paypal_subscription_status_20, t0.stripe_customer_id AS stripe_customer_id_21, t0.stripe_subscription_id AS stripe_subscription_id_22, t0.stripe_subscription_status AS stripe_subscription_status_23, t0.billing_seat_count AS billing_seat_count_24, t0.billing_period_started_at AS billing_period_started_at_25, t0.billing_period_ends_at AS billing_period_ends_at_26, t0.integrated_by_company_id AS integrated_by_company_id_27 FROM company t0 WHERE t0.id = ?

Parameters:

[
  31
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.address_street AS address_street_3,
  t0.address_number AS address_number_4,
  t0.address_city AS address_city_5,
  t0.address_zip_code AS address_zip_code_6,
  t0.address_country AS address_country_7,
  t0.phone_number AS phone_number_8,
  t0.email AS email_9,
  t0.default_benefits AS default_benefits_10,
  t0.profile_picture AS profile_picture_11,
  t0.ethereum_address AS ethereum_address_12,
  t0.is_verified AS is_verified_13,
  t0.is_integrator AS is_integrator_14,
  t0.integrator_code AS integrator_code_15,
  t0.integrator_code_enabled AS integrator_code_enabled_16,
  t0.integrated_at AS integrated_at_17,
  t0.premium_subscription_company_date AS premium_subscription_company_date_18,
  t0.paypal_subscription_id AS paypal_subscription_id_19,
  t0.paypal_subscription_status AS paypal_subscription_status_20,
  t0.stripe_customer_id AS stripe_customer_id_21,
  t0.stripe_subscription_id AS stripe_subscription_id_22,
  t0.stripe_subscription_status AS stripe_subscription_status_23,
  t0.billing_seat_count AS billing_seat_count_24,
  t0.billing_period_started_at AS billing_period_started_at_25,
  t0.billing_period_ends_at AS billing_period_ends_at_26,
  t0.integrated_by_company_id AS integrated_by_company_id_27
FROM
  company t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.address_street AS address_street_3, t0.address_number AS address_number_4, t0.address_city AS address_city_5, t0.address_zip_code AS address_zip_code_6, t0.address_country AS address_country_7, t0.phone_number AS phone_number_8, t0.email AS email_9, t0.default_benefits AS default_benefits_10, t0.profile_picture AS profile_picture_11, t0.ethereum_address AS ethereum_address_12, t0.is_verified AS is_verified_13, t0.is_integrator AS is_integrator_14, t0.integrator_code AS integrator_code_15, t0.integrator_code_enabled AS integrator_code_enabled_16, t0.integrated_at AS integrated_at_17, t0.premium_subscription_company_date AS premium_subscription_company_date_18, t0.paypal_subscription_id AS paypal_subscription_id_19, t0.paypal_subscription_status AS paypal_subscription_status_20, t0.stripe_customer_id AS stripe_customer_id_21, t0.stripe_subscription_id AS stripe_subscription_id_22, t0.stripe_subscription_status AS stripe_subscription_status_23, t0.billing_seat_count AS billing_seat_count_24, t0.billing_period_started_at AS billing_period_started_at_25, t0.billing_period_ends_at AS billing_period_ends_at_26, t0.integrated_by_company_id AS integrated_by_company_id_27 FROM company t0 WHERE t0.id = 31;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():294} (line 295)
4	Proxies\__CG__\App\Entity\Company::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():371}:372} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 59)
6	Proxies\__CG__\App\Entity\Company->__get (line 129)
7	App\Entity\Company->getProfilePicture (line 306)
8	App\Controller\JobShareController->show (line 67)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	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\JobOffre	1
App\Entity\User	1
App\Entity\Company	1
App\Entity\Location	1

Entities Mapping

Class	Mapping errors
App\Entity\JobOffre	No errors.
App\Entity\User	No errors.
App\Entity\Company	No errors.
App\Entity\Location	No errors.
App\Entity\JobApplication	No errors.
App\Entity\ExperienceRecord	No errors.
App\Entity\CompanyEmployee	No errors.
App\Entity\CompanyTag	No errors.
App\Entity\CompanyTeam	No errors.

Symfony Profiler

GET https://api.solidcv.com/jobs/23

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping