Symfony Profiler

Query Metrics

42 Database Queries

12 Different statements

43.25 ms Query time

0 Invalid entities

130 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

14.17 ms
(32.77%)

SELECT t0.id AS id_1, t0.path AS path_2, t0.project_id AS project_id_3 FROM image t0 WHERE t0.project_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.path AS path_2,
  t0.project_id AS project_id_3
FROM
  image t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.path AS path_2, t0.project_id AS project_id_3 FROM image t0 WHERE t0.project_id = 1;

#	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 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	Symfony\Component\Serializer\Serializer->normalize (line 169)
8	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 226)
9	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
10	Symfony\Component\Serializer\Serializer->normalize (line 152)
11	Symfony\Component\Serializer\Serializer->normalize (line 170)
12	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 226)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
14	Symfony\Component\Serializer\Serializer->normalize (line 152)
15	Symfony\Component\Serializer\Serializer->serialize (line 131)
16	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 153)
18	App\Controller\PortfolioController->index (line 129)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 191)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	require_once (line 5)

12.00 ms
(27.74%)

SELECT t0.id AS id_1, t0.path AS path_2, t0.name AS name_3, t0.formation_id AS formation_id_4 FROM certificat t0 WHERE t0.formation_id = ?

Parameters:

[
  22
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.path AS path_2,
  t0.name AS name_3,
  t0.formation_id AS formation_id_4
FROM
  certificat t0
WHERE
  t0.formation_id = ?

SELECT t0.id AS id_1, t0.path AS path_2, t0.name AS name_3, t0.formation_id AS formation_id_4 FROM certificat t0 WHERE t0.formation_id = 22;

#	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 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	Symfony\Component\Serializer\Serializer->normalize (line 169)
8	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 226)
9	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
10	Symfony\Component\Serializer\Serializer->normalize (line 152)
11	Symfony\Component\Serializer\Serializer->normalize (line 170)
12	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 226)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
14	Symfony\Component\Serializer\Serializer->normalize (line 152)
15	Symfony\Component\Serializer\Serializer->serialize (line 131)
16	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 153)
18	App\Controller\PortfolioController->index (line 129)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 191)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	require_once (line 5)

3.26 ms
(7.53%)

INSERT INTO visitor (ip, user_agent, visited_at, location, count, country, country_code, region_name, city, zip_code, latitude, longitude, time_zone, org, ass) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "151.21.255.5"
  "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:148.0) Gecko/20100101 Firefox/148.0"
  "2026-03-07 19:25:17"
  "25"
  null
  "Italy"
  null
  "Lombardy"
  "Lissone"
  "20851"
  45.6135
  null
  "Europe/Rome"
  ""
  "AS1267 WIND TRE S.P.A."
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO visitor (
  ip, user_agent, visited_at, location,
  count, country, country_code, region_name,
  city, zip_code, latitude, longitude,
  time_zone, org, ass
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO visitor (ip, user_agent, visited_at, location, count, country, country_code, region_name, city, zip_code, latitude, longitude, time_zone, org, ass) VALUES ('151.21.255.5', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:148.0) Gecko/20100101 Firefox/148.0', '2026-03-07 19:25:17', '25', NULL, 'Italy', NULL, 'Lombardy', 'Lissone', '20851', 45.6135, NULL, 'Europe/Rome', '', 'AS1267 WIND TRE S.P.A.');

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 133)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1060)
4	Doctrine\ORM\UnitOfWork->commit (line 403)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Controller\PortfolioController->index (line 123)
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)

2.99 ms
(6.91%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.name_fr AS name_fr_3, t0.name_en AS name_en_4, t0.name_it AS name_it_5, t0.description_fr AS description_fr_6, t0.description_en AS description_en_7, t0.description_it AS description_it_8, t0.debut AS debut_9, t0.fin AS fin_10, t0.ecole AS ecole_11, t0.is_displayed AS is_displayed_12, t0.location AS location_13, t0.user_id AS user_id_14 FROM formation t0 WHERE t0.user_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.name_fr AS name_fr_3,
  t0.name_en AS name_en_4,
  t0.name_it AS name_it_5,
  t0.description_fr AS description_fr_6,
  t0.description_en AS description_en_7,
  t0.description_it AS description_it_8,
  t0.debut AS debut_9,
  t0.fin AS fin_10,
  t0.ecole AS ecole_11,
  t0.is_displayed AS is_displayed_12,
  t0.location AS location_13,
  t0.user_id AS user_id_14
FROM
  formation t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.name_fr AS name_fr_3, t0.name_en AS name_en_4, t0.name_it AS name_it_5, t0.description_fr AS description_fr_6, t0.description_en AS description_en_7, t0.description_it AS description_it_8, t0.debut AS debut_9, t0.fin AS fin_10, t0.ecole AS ecole_11, t0.is_displayed AS is_displayed_12, t0.location AS location_13, t0.user_id AS user_id_14 FROM formation t0 WHERE t0.user_id = 1;

#	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 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	Symfony\Component\Serializer\Serializer->normalize (line 169)
8	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 226)
9	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
10	Symfony\Component\Serializer\Serializer->normalize (line 152)
11	Symfony\Component\Serializer\Serializer->serialize (line 131)
12	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 153)
14	App\Controller\PortfolioController->index (line 129)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 191)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 32)
20	require_once (line 5)

2.17 ms
(5.01%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 433)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Controller\PortfolioController->index (line 123)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 191)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 32)
9	require_once (line 5)

2.02 ms
(4.68%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description_fr AS description_fr_3, t0.description_en AS description_en_4, t0.description_it AS description_it_5, t0.date AS date_6, t0.updated_at AS updated_at_7, t0.is_displayed AS is_displayed_8, t0.link AS link_9, t0.github AS github_10, t0.status AS status_11, t0.user_id AS user_id_12 FROM project t0 WHERE t0.user_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description_fr AS description_fr_3,
  t0.description_en AS description_en_4,
  t0.description_it AS description_it_5,
  t0.date AS date_6,
  t0.updated_at AS updated_at_7,
  t0.is_displayed AS is_displayed_8,
  t0.link AS link_9,
  t0.github AS github_10,
  t0.status AS status_11,
  t0.user_id AS user_id_12
FROM
  project t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description_fr AS description_fr_3, t0.description_en AS description_en_4, t0.description_it AS description_it_5, t0.date AS date_6, t0.updated_at AS updated_at_7, t0.is_displayed AS is_displayed_8, t0.link AS link_9, t0.github AS github_10, t0.status AS status_11, t0.user_id AS user_id_12 FROM project t0 WHERE t0.user_id = 1;

#	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 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	Symfony\Component\Serializer\Serializer->normalize (line 169)
8	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 226)
9	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
10	Symfony\Component\Serializer\Serializer->normalize (line 152)
11	Symfony\Component\Serializer\Serializer->serialize (line 131)
12	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 153)
14	App\Controller\PortfolioController->index (line 129)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 191)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 32)
20	require_once (line 5)

1.57 ms
(3.64%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.log_count AS log_count_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.telephone AS telephone_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.failed_login_attempts AS failed_login_attempts_11, t0.blocked_until AS blocked_until_12, t0.last_failed_login_ip AS last_failed_login_ip_13, t0.last_failed_login_at AS last_failed_login_at_14, t0.is_actif AS is_actif_15, t0.is_blocked AS is_blocked_16, t0.presentation_fr AS presentation_fr_17, t0.presentation_en AS presentation_en_18, t0.presentation_it AS presentation_it_19, t0.adresse AS adresse_20, t0.github AS github_21, t0.linkedin AS linkedin_22, t0.tel_1 AS tel_1_23, t0.tel_2 AS tel_2_24 FROM user t0 WHERE t0.email IS NULL LIMIT 1

Parameters:

[]

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.log_count AS log_count_5,
  t0.firstname AS firstname_6,
  t0.lastname AS lastname_7,
  t0.telephone AS telephone_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.failed_login_attempts AS failed_login_attempts_11,
  t0.blocked_until AS blocked_until_12,
  t0.last_failed_login_ip AS last_failed_login_ip_13,
  t0.last_failed_login_at AS last_failed_login_at_14,
  t0.is_actif AS is_actif_15,
  t0.is_blocked AS is_blocked_16,
  t0.presentation_fr AS presentation_fr_17,
  t0.presentation_en AS presentation_en_18,
  t0.presentation_it AS presentation_it_19,
  t0.adresse AS adresse_20,
  t0.github AS github_21,
  t0.linkedin AS linkedin_22,
  t0.tel_1 AS tel_1_23,
  t0.tel_2 AS tel_2_24
FROM
  user t0
WHERE
  t0.email IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.log_count AS log_count_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.telephone AS telephone_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.failed_login_attempts AS failed_login_attempts_11, t0.blocked_until AS blocked_until_12, t0.last_failed_login_ip AS last_failed_login_ip_13, t0.last_failed_login_at AS last_failed_login_at_14, t0.is_actif AS is_actif_15, t0.is_blocked AS is_blocked_16, t0.presentation_fr AS presentation_fr_17, t0.presentation_en AS presentation_en_18, t0.presentation_it AS presentation_it_19, t0.adresse AS adresse_20, t0.github AS github_21, t0.linkedin AS linkedin_22, t0.tel_1 AS tel_1_23, t0.tel_2 AS tel_2_24 FROM user t0 WHERE t0.email IS NULL LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 86)
4	App\Repository\UserRepository->findUserWithDetails (line 94)
5	App\Controller\PortfolioController->index (line 127)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 191)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 5)

1.16 ms
(2.68%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.log_count AS log_count_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.telephone AS telephone_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.failed_login_attempts AS failed_login_attempts_11, t0.blocked_until AS blocked_until_12, t0.last_failed_login_ip AS last_failed_login_ip_13, t0.last_failed_login_at AS last_failed_login_at_14, t0.is_actif AS is_actif_15, t0.is_blocked AS is_blocked_16, t0.presentation_fr AS presentation_fr_17, t0.presentation_en AS presentation_en_18, t0.presentation_it AS presentation_it_19, t0.adresse AS adresse_20, t0.github AS github_21, t0.linkedin AS linkedin_22, t0.tel_1 AS tel_1_23, t0.tel_2 AS tel_2_24 FROM user t0 WHERE t0.id = ?

Parameters:

[
  1
]

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.log_count AS log_count_5,
  t0.firstname AS firstname_6,
  t0.lastname AS lastname_7,
  t0.telephone AS telephone_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.failed_login_attempts AS failed_login_attempts_11,
  t0.blocked_until AS blocked_until_12,
  t0.last_failed_login_ip AS last_failed_login_ip_13,
  t0.last_failed_login_at AS last_failed_login_at_14,
  t0.is_actif AS is_actif_15,
  t0.is_blocked AS is_blocked_16,
  t0.presentation_fr AS presentation_fr_17,
  t0.presentation_en AS presentation_en_18,
  t0.presentation_it AS presentation_it_19,
  t0.adresse AS adresse_20,
  t0.github AS github_21,
  t0.linkedin AS linkedin_22,
  t0.tel_1 AS tel_1_23,
  t0.tel_2 AS tel_2_24
FROM
  user t0
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.log_count AS log_count_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.telephone AS telephone_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.failed_login_attempts AS failed_login_attempts_11, t0.blocked_until AS blocked_until_12, t0.last_failed_login_ip AS last_failed_login_ip_13, t0.last_failed_login_at AS last_failed_login_at_14, t0.is_actif AS is_actif_15, t0.is_blocked AS is_blocked_16, t0.presentation_fr AS presentation_fr_17, t0.presentation_en AS presentation_en_18, t0.presentation_it AS presentation_it_19, t0.adresse AS adresse_20, t0.github AS github_21, t0.linkedin AS linkedin_22, t0.tel_1 AS tel_1_23, t0.tel_2 AS tel_2_24 FROM user t0 WHERE t0.id = 1;

#	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	App\Repository\UserRepository->findUserWithDetails (line 97)
7	App\Controller\PortfolioController->index (line 127)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 191)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

1.08 ms
(2.49%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 382)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Controller\PortfolioController->index (line 123)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 191)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 32)
9	require_once (line 5)

1.04 ms
(2.41%)

SELECT t0.id AS id_1, t0.ip AS ip_2, t0.user_agent AS user_agent_3, t0.visited_at AS visited_at_4, t0.location AS location_5, t0.count AS count_6, t0.country AS country_7, t0.country_code AS country_code_8, t0.region_name AS region_name_9, t0.city AS city_10, t0.zip_code AS zip_code_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.time_zone AS time_zone_14, t0.org AS org_15, t0.ass AS ass_16 FROM visitor t0 WHERE t0.ip = ? ORDER BY t0.visited_at DESC LIMIT 1

Parameters:

[
  "151.21.255.5"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.ip AS ip_2,
  t0.user_agent AS user_agent_3,
  t0.visited_at AS visited_at_4,
  t0.location AS location_5,
  t0.count AS count_6,
  t0.country AS country_7,
  t0.country_code AS country_code_8,
  t0.region_name AS region_name_9,
  t0.city AS city_10,
  t0.zip_code AS zip_code_11,
  t0.latitude AS latitude_12,
  t0.longitude AS longitude_13,
  t0.time_zone AS time_zone_14,
  t0.org AS org_15,
  t0.ass AS ass_16
FROM
  visitor t0
WHERE
  t0.ip = ?
ORDER BY
  t0.visited_at DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.ip AS ip_2, t0.user_agent AS user_agent_3, t0.visited_at AS visited_at_4, t0.location AS location_5, t0.count AS count_6, t0.country AS country_7, t0.country_code AS country_code_8, t0.region_name AS region_name_9, t0.city AS city_10, t0.zip_code AS zip_code_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.time_zone AS time_zone_14, t0.org AS org_15, t0.ass AS ass_16 FROM visitor t0 WHERE t0.ip = '151.21.255.5' ORDER BY t0.visited_at DESC LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 86)
4	App\Controller\PortfolioController->index (line 70)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 191)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

0.95 ms
(2.19%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description_fr AS description_fr_3, t0.description_it AS description_it_4, t0.description_en AS description_en_5, t0.debut AS debut_6, t0.end AS end_7, t0.employer AS employer_8, t0.adresse AS adresse_9, t0.is_display AS is_display_10, t0.user_id AS user_id_11 FROM experience t0 WHERE t0.user_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description_fr AS description_fr_3,
  t0.description_it AS description_it_4,
  t0.description_en AS description_en_5,
  t0.debut AS debut_6,
  t0.end AS end_7,
  t0.employer AS employer_8,
  t0.adresse AS adresse_9,
  t0.is_display AS is_display_10,
  t0.user_id AS user_id_11
FROM
  experience t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description_fr AS description_fr_3, t0.description_it AS description_it_4, t0.description_en AS description_en_5, t0.debut AS debut_6, t0.end AS end_7, t0.employer AS employer_8, t0.adresse AS adresse_9, t0.is_display AS is_display_10, t0.user_id AS user_id_11 FROM experience t0 WHERE t0.user_id = 1;

#	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 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	Symfony\Component\Serializer\Serializer->normalize (line 169)
8	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 226)
9	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
10	Symfony\Component\Serializer\Serializer->normalize (line 152)
11	Symfony\Component\Serializer\Serializer->serialize (line 131)
12	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 153)
14	App\Controller\PortfolioController->index (line 129)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 191)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 32)
20	require_once (line 5)

0.84 ms
(1.94%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.rowss AS rowss_3, t0.colss AS colss_4, t0.author AS author_5, t0.image AS image_6, t0.title AS title_7, t0.user_id AS user_id_8 FROM skyll t0 WHERE t0.user_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.rowss AS rowss_3,
  t0.colss AS colss_4,
  t0.author AS author_5,
  t0.image AS image_6,
  t0.title AS title_7,
  t0.user_id AS user_id_8
FROM
  skyll t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.rowss AS rowss_3, t0.colss AS colss_4, t0.author AS author_5, t0.image AS image_6, t0.title AS title_7, t0.user_id AS user_id_8 FROM skyll t0 WHERE t0.user_id = 1;

#	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 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	Symfony\Component\Serializer\Serializer->normalize (line 169)
8	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 226)
9	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
10	Symfony\Component\Serializer\Serializer->normalize (line 152)
11	Symfony\Component\Serializer\Serializer->serialize (line 131)
12	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 153)
14	App\Controller\PortfolioController->index (line 129)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 191)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 32)
20	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\Image	63
App\Entity\Project	17
App\Entity\Formation	15
App\Entity\Skyll	15
App\Entity\Certificat	13
App\Entity\Experience	4
App\Entity\Visitor	2
App\Entity\User	1

Entities Mapping

Class	Mapping errors
App\Entity\Visitor	No errors.
App\Entity\User	No errors.
App\Entity\Project	No errors.
App\Entity\Formation	No errors.
App\Entity\Skyll	No errors.
App\Entity\Experience	No errors.
App\Entity\Image	No errors.
App\Entity\Certificat	No errors.

Symfony Profiler

GET https://backend.portfolio.amarsyll.pro/portfolio

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping