Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

4.90 ms Query time

0 Invalid entities

22 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.99 ms

SELECT t0.id AS id_1, t0.code AS code_2, t0.username AS username_3, t0.roles AS roles_4, t0.password AS password_5, t0.actif AS actif_6, t0.created_at AS created_at_7, t0.last_login_at AS last_login_at_8, t0.last_activity_at AS last_activity_at_9, t0.nom_prenom AS nom_prenom_10, t0.verified_at AS verified_at_11, t0.is_enabled AS is_enabled_12, t0.last_updated_at AS last_updated_at_13, t14.id AS id_15, t14.code AS code_16, t14.onboarding_completed_at AS onboarding_completed_at_17, t14.onboarding_completed AS onboarding_completed_18, t14.locale AS locale_19, t14.nom AS nom_20, t14.prenom AS prenom_21, t14.metier_principal AS metier_principal_22, t14.specialite AS specialite_23, t14.ville AS ville_24, t14.disponible AS disponible_25, t14.experience_annees AS experience_annees_26, t14.salaire_min AS salaire_min_27, t14.devise AS devise_28, t14.niveau_etudes AS niveau_etudes_29, t14.competences AS competences_30, t14.langues AS langues_31, t14.filtres_strict AS filtres_strict_32, t14.preferences AS preferences_33, t14.score_completion AS score_completion_34, t14.prochaine_question AS prochaine_question_35, t14.embedding AS embedding_36, t14.embedding_updated_at AS embedding_updated_at_37, t14.latitude AS latitude_38, t14.longitude AS longitude_39, t14.created_at AS created_at_40, t14.updated_at AS updated_at_41, t14.utilisateur_id AS utilisateur_id_42, t14.intent_id AS intent_id_43, t14.disponibilite_id AS disponibilite_id_44, t14.location_scope_id AS location_scope_id_45, t0.utilisateur_role_id AS utilisateur_role_id_46 FROM utilisateur t0 LEFT JOIN profile t14 ON t14.utilisateur_id = t0.id WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.username AS username_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.actif AS actif_6,
  t0.created_at AS created_at_7,
  t0.last_login_at AS last_login_at_8,
  t0.last_activity_at AS last_activity_at_9,
  t0.nom_prenom AS nom_prenom_10,
  t0.verified_at AS verified_at_11,
  t0.is_enabled AS is_enabled_12,
  t0.last_updated_at AS last_updated_at_13,
  t14.id AS id_15,
  t14.code AS code_16,
  t14.onboarding_completed_at AS onboarding_completed_at_17,
  t14.onboarding_completed AS onboarding_completed_18,
  t14.locale AS locale_19,
  t14.nom AS nom_20,
  t14.prenom AS prenom_21,
  t14.metier_principal AS metier_principal_22,
  t14.specialite AS specialite_23,
  t14.ville AS ville_24,
  t14.disponible AS disponible_25,
  t14.experience_annees AS experience_annees_26,
  t14.salaire_min AS salaire_min_27,
  t14.devise AS devise_28,
  t14.niveau_etudes AS niveau_etudes_29,
  t14.competences AS competences_30,
  t14.langues AS langues_31,
  t14.filtres_strict AS filtres_strict_32,
  t14.preferences AS preferences_33,
  t14.score_completion AS score_completion_34,
  t14.prochaine_question AS prochaine_question_35,
  t14.embedding AS embedding_36,
  t14.embedding_updated_at AS embedding_updated_at_37,
  t14.latitude AS latitude_38,
  t14.longitude AS longitude_39,
  t14.created_at AS created_at_40,
  t14.updated_at AS updated_at_41,
  t14.utilisateur_id AS utilisateur_id_42,
  t14.intent_id AS intent_id_43,
  t14.disponibilite_id AS disponibilite_id_44,
  t14.location_scope_id AS location_scope_id_45,
  t0.utilisateur_role_id AS utilisateur_role_id_46
FROM
  utilisateur t0
  LEFT JOIN profile t14 ON t14.utilisateur_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.username AS username_3, t0.roles AS roles_4, t0.password AS password_5, t0.actif AS actif_6, t0.created_at AS created_at_7, t0.last_login_at AS last_login_at_8, t0.last_activity_at AS last_activity_at_9, t0.nom_prenom AS nom_prenom_10, t0.verified_at AS verified_at_11, t0.is_enabled AS is_enabled_12, t0.last_updated_at AS last_updated_at_13, t14.id AS id_15, t14.code AS code_16, t14.onboarding_completed_at AS onboarding_completed_at_17, t14.onboarding_completed AS onboarding_completed_18, t14.locale AS locale_19, t14.nom AS nom_20, t14.prenom AS prenom_21, t14.metier_principal AS metier_principal_22, t14.specialite AS specialite_23, t14.ville AS ville_24, t14.disponible AS disponible_25, t14.experience_annees AS experience_annees_26, t14.salaire_min AS salaire_min_27, t14.devise AS devise_28, t14.niveau_etudes AS niveau_etudes_29, t14.competences AS competences_30, t14.langues AS langues_31, t14.filtres_strict AS filtres_strict_32, t14.preferences AS preferences_33, t14.score_completion AS score_completion_34, t14.prochaine_question AS prochaine_question_35, t14.embedding AS embedding_36, t14.embedding_updated_at AS embedding_updated_at_37, t14.latitude AS latitude_38, t14.longitude AS longitude_39, t14.created_at AS created_at_40, t14.updated_at AS updated_at_41, t14.utilisateur_id AS utilisateur_id_42, t14.intent_id AS intent_id_43, t14.disponibilite_id AS disponibilite_id_44, t14.location_scope_id AS location_scope_id_45, t0.utilisateur_role_id AS utilisateur_role_id_46 FROM utilisateur t0 LEFT JOIN profile t14 ON t14.utilisateur_id = t0.id 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	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
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 46)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
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 193)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 32)
22	require_once (line 5)

1.12 ms

SELECT count(*) AS sclr_0 FROM scrape_execution s0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(*) AS sclr_0
FROM
  scrape_execution s0_

SELECT count(*) AS sclr_0 FROM scrape_execution s0_;

#	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->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	ApiPlatform\Doctrine\Orm\Paginator->getTotalItems (line 49)
8	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getPaginationData (line 66)
9	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 90)
10	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 55)
11	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 80)
12	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
13	Symfony\Component\Serializer\Serializer->normalize (line 152)
14	Symfony\Component\Serializer\Serializer->serialize (line 131)
15	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
16	ApiPlatform\State\Processor\SerializeProcessor->process (line 85)
17	ApiPlatform\State\Processor\WriteProcessor->process (line 54)
18	ApiPlatform\Symfony\Validator\State\ValidateProcessor->process (line 40)
19	ApiPlatform\Symfony\Controller\MainController->__invoke (line 125)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 193)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 32)
25	require_once (line 5)

1.79 ms

SELECT s0_.id AS id_0, s0_.code AS code_1, s0_.source AS source_2, s0_.partition_number AS partition_number_3, s0_.attempt AS attempt_4, s0_.priority AS priority_5, s0_.job_id AS job_id_6, s0_.page AS page_7, s0_.start_page AS start_page_8, s0_.listing_offset AS listing_offset_9, s0_.max_pages_override AS max_pages_override_10, s0_.stop_after_consecutive_known_pages_override AS stop_after_consecutive_known_pages_override_11, s0_.omit_known_offer_keys AS omit_known_offer_keys_12, s0_.skip_enrichment AS skip_enrichment_13, s0_.from_export AS from_export_14, s0_.debug AS debug_15, s0_.status AS status_16, s0_.error_message AS error_message_17, s0_.success_count AS success_count_18, s0_.duplicate_count AS duplicate_count_19, s0_.error_count AS error_count_20, s0_.fetched_count AS fetched_count_21, s0_.scraped_new_count AS scraped_new_count_22, s0_.skipped_known_count AS skipped_known_count_23, s0_.dispatched_at AS dispatched_at_24, s0_.started_at AS started_at_25, s0_.finished_at AS finished_at_26, s0_.created_at AS created_at_27, s0_.updated_at AS updated_at_28 FROM scrape_execution s0_ ORDER BY s0_.dispatched_at DESC LIMIT 20 OFFSET 20

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.code AS code_1,
  s0_.source AS source_2,
  s0_.partition_number AS partition_number_3,
  s0_.attempt AS attempt_4,
  s0_.priority AS priority_5,
  s0_.job_id AS job_id_6,
  s0_.page AS page_7,
  s0_.start_page AS start_page_8,
  s0_.listing_offset AS listing_offset_9,
  s0_.max_pages_override AS max_pages_override_10,
  s0_.stop_after_consecutive_known_pages_override AS stop_after_consecutive_known_pages_override_11,
  s0_.omit_known_offer_keys AS omit_known_offer_keys_12,
  s0_.skip_enrichment AS skip_enrichment_13,
  s0_.from_export AS from_export_14,
  s0_.debug AS debug_15,
  s0_.status AS status_16,
  s0_.error_message AS error_message_17,
  s0_.success_count AS success_count_18,
  s0_.duplicate_count AS duplicate_count_19,
  s0_.error_count AS error_count_20,
  s0_.fetched_count AS fetched_count_21,
  s0_.scraped_new_count AS scraped_new_count_22,
  s0_.skipped_known_count AS skipped_known_count_23,
  s0_.dispatched_at AS dispatched_at_24,
  s0_.started_at AS started_at_25,
  s0_.finished_at AS finished_at_26,
  s0_.created_at AS created_at_27,
  s0_.updated_at AS updated_at_28
FROM
  scrape_execution s0_
ORDER BY
  s0_.dispatched_at DESC
LIMIT
  20
OFFSET
  20

SELECT s0_.id AS id_0, s0_.code AS code_1, s0_.source AS source_2, s0_.partition_number AS partition_number_3, s0_.attempt AS attempt_4, s0_.priority AS priority_5, s0_.job_id AS job_id_6, s0_.page AS page_7, s0_.start_page AS start_page_8, s0_.listing_offset AS listing_offset_9, s0_.max_pages_override AS max_pages_override_10, s0_.stop_after_consecutive_known_pages_override AS stop_after_consecutive_known_pages_override_11, s0_.omit_known_offer_keys AS omit_known_offer_keys_12, s0_.skip_enrichment AS skip_enrichment_13, s0_.from_export AS from_export_14, s0_.debug AS debug_15, s0_.status AS status_16, s0_.error_message AS error_message_17, s0_.success_count AS success_count_18, s0_.duplicate_count AS duplicate_count_19, s0_.error_count AS error_count_20, s0_.fetched_count AS fetched_count_21, s0_.scraped_new_count AS scraped_new_count_22, s0_.skipped_known_count AS skipped_known_count_23, s0_.dispatched_at AS dispatched_at_24, s0_.started_at AS started_at_25, s0_.finished_at AS finished_at_26, s0_.created_at AS created_at_27, s0_.updated_at AS updated_at_28 FROM scrape_execution s0_ ORDER BY s0_.dispatched_at DESC LIMIT 20 OFFSET 20;

#	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	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 151)
7	ApiPlatform\Doctrine\Orm\AbstractPaginator->getIterator (line 69)
8	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 86)
9	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 97)
10	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 55)
11	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 80)
12	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
13	Symfony\Component\Serializer\Serializer->normalize (line 152)
14	Symfony\Component\Serializer\Serializer->serialize (line 131)
15	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
16	ApiPlatform\State\Processor\SerializeProcessor->process (line 85)
17	ApiPlatform\State\Processor\WriteProcessor->process (line 54)
18	ApiPlatform\Symfony\Validator\State\ValidateProcessor->process (line 40)
19	ApiPlatform\Symfony\Controller\MainController->__invoke (line 125)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 193)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 32)
25	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\ScrapeExecution	20
App\Entity\Utilisateur	1
App\Entity\UtilisateurRole	1

Entities Mapping

Class	Mapping errors
App\Entity\Utilisateur	No errors.
App\Entity\Profile	No errors.
App\Entity\Intent	No errors.
App\Entity\Disponibilite	No errors.
App\Entity\LocationScope	No errors.
App\Entity\UtilisateurRole	No errors.
App\Entity\Interaction	No errors.
App\Entity\Alerte	No errors.
App\Entity\ScrapeExecution	No errors.

Symfony Profiler

GET https://agora.krypteia.dev/api/admin/scrape-executions?itemsPerPage=20&order%5BdispatchedAt%5D=desc&page=2

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping