Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

4.53 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.79 ms
(83.69%)

SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.slug AS slug_2, j0_.description AS description_3, j0_.location AS location_4, j0_.employment_type AS employment_type_5, j0_.route_type AS route_type_6, j0_.requirements AS requirements_7, j0_.required_endorsements AS required_endorsements_8, j0_.salary AS salary_9, j0_.is_active AS is_active_10, j0_.expires_at AS expires_at_11, j0_.custom_questions AS custom_questions_12, j0_.video_url AS video_url_13, j0_.parsed_video_embed AS parsed_video_embed_14, j0_.radius AS radius_15, j0_.minimum_experience AS minimum_experience_16, j0_.pay_range AS pay_range_17, j0_.created_at AS created_at_18, j0_.updated_at AS updated_at_19, j0_.company_id AS company_id_20 FROM job_posting j0_ WHERE j0_.is_active = ? AND (j0_.expires_at > ? OR j0_.expires_at IS NULL) ORDER BY j0_.created_at DESC LIMIT 6

Parameters:

[
  1
  "2025-06-07 10:49:57"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j0_.id AS id_0,
  j0_.title AS title_1,
  j0_.slug AS slug_2,
  j0_.description AS description_3,
  j0_.location AS location_4,
  j0_.employment_type AS employment_type_5,
  j0_.route_type AS route_type_6,
  j0_.requirements AS requirements_7,
  j0_.required_endorsements AS required_endorsements_8,
  j0_.salary AS salary_9,
  j0_.is_active AS is_active_10,
  j0_.expires_at AS expires_at_11,
  j0_.custom_questions AS custom_questions_12,
  j0_.video_url AS video_url_13,
  j0_.parsed_video_embed AS parsed_video_embed_14,
  j0_.radius AS radius_15,
  j0_.minimum_experience AS minimum_experience_16,
  j0_.pay_range AS pay_range_17,
  j0_.created_at AS created_at_18,
  j0_.updated_at AS updated_at_19,
  j0_.company_id AS company_id_20
FROM
  job_posting j0_
WHERE
  j0_.is_active = ?
  AND (
    j0_.expires_at > ?
    OR j0_.expires_at IS NULL
  )
ORDER BY
  j0_.created_at DESC
LIMIT
  6

SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.slug AS slug_2, j0_.description AS description_3, j0_.location AS location_4, j0_.employment_type AS employment_type_5, j0_.route_type AS route_type_6, j0_.requirements AS requirements_7, j0_.required_endorsements AS required_endorsements_8, j0_.salary AS salary_9, j0_.is_active AS is_active_10, j0_.expires_at AS expires_at_11, j0_.custom_questions AS custom_questions_12, j0_.video_url AS video_url_13, j0_.parsed_video_embed AS parsed_video_embed_14, j0_.radius AS radius_15, j0_.minimum_experience AS minimum_experience_16, j0_.pay_range AS pay_range_17, j0_.created_at AS created_at_18, j0_.updated_at AS updated_at_19, j0_.company_id AS company_id_20 FROM job_posting j0_ WHERE j0_.is_active = 1 AND (j0_.expires_at > '2025-06-07 10:49:57' OR j0_.expires_at IS NULL) ORDER BY j0_.created_at DESC LIMIT 6;

#	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 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 64)
7	App\Controller\HomeController->index (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)

0.74 ms
(16.31%)

SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.description AS description_3, t0.website AS website_4, t0.address AS address_5, t0.city AS city_6, t0.state AS state_7, t0.zip_code AS zip_code_8, t0.phone AS phone_9, t0.is_verified AS is_verified_10, t0.is_profile_complete AS is_profile_complete_11, t0.company_size AS company_size_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.last_activity_at AS last_activity_at_15, t0.activity_metrics AS activity_metrics_16, t0.integration_statuses AS integration_statuses_17, t0.owner_id AS owner_id_18 FROM company t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.company_name AS company_name_2,
  t0.description AS description_3,
  t0.website AS website_4,
  t0.address AS address_5,
  t0.city AS city_6,
  t0.state AS state_7,
  t0.zip_code AS zip_code_8,
  t0.phone AS phone_9,
  t0.is_verified AS is_verified_10,
  t0.is_profile_complete AS is_profile_complete_11,
  t0.company_size AS company_size_12,
  t0.status AS status_13,
  t0.created_at AS created_at_14,
  t0.last_activity_at AS last_activity_at_15,
  t0.activity_metrics AS activity_metrics_16,
  t0.integration_statuses AS integration_statuses_17,
  t0.owner_id AS owner_id_18
FROM
  company t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.description AS description_3, t0.website AS website_4, t0.address AS address_5, t0.city AS city_6, t0.state AS state_7, t0.zip_code AS zip_code_8, t0.phone AS phone_9, t0.is_verified AS is_verified_10, t0.is_profile_complete AS is_profile_complete_11, t0.company_size AS company_size_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.last_activity_at AS last_activity_at_15, t0.activity_metrics AS activity_metrics_16, t0.integration_statuses AS integration_statuses_17, t0.owner_id AS owner_id_18 FROM company t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
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\Company::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\Company->__get (line 116)
8	App\Entity\Company->getCompanyName (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 277)
10	__TwigTemplate_d306522d0492ae6cfd9ca246962f04a4->block_body (line 432)
11	Twig\Template->yieldBlock (line 232)
12	__TwigTemplate_25bbc1678c4bad9850bfa5d0470157a3->doDisplay (line 388)
13	Twig\Template->yield (line 55)
14	__TwigTemplate_d306522d0492ae6cfd9ca246962f04a4->doDisplay (line 388)
15	Twig\Template->yield (line 344)
16	Twig\Template->display (line 359)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 334)
19	Twig\Environment->render (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 67)
23	App\Controller\HomeController->index (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
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\JobPosting	No errors.
App\Entity\Company	No errors.
App\Entity\JobApplication	The association App\Entity\JobApplication#driver refers to the inverse side field App\Entity\DriverProfile#applications which does not exist.
App\Entity\User	No errors.

Symfony Profiler

GET https://trucker.brettevanson.com/

Configuration Settings

Theme