Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

4.76 ms Query time

0 Invalid entities

22 Managed entities

Queries

Group similar statements

#▲	Time	Info
1	2.60 ms	SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.native_name AS native_name_4, t0.flag_emoji AS flag_emoji_5, t0.country_code AS country_code_6, t0.enabled AS enabled_7, t0.sort_order AS sort_order_8 FROM available_locale t0 WHERE t0.code = ? AND t0.enabled = ? LIMIT 1 Parameters: [`"fr" 1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.native_name AS native_name_4, t0.flag_emoji AS flag_emoji_5, t0.country_code AS country_code_6, t0.enabled AS enabled_7, t0.sort_order AS sort_order_8 FROM available_locale t0 WHERE t0.code = ? AND t0.enabled = ? LIMIT 1 SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.native_name AS native_name_4, t0.flag_emoji AS flag_emoji_5, t0.country_code AS country_code_6, t0.enabled AS enabled_7, t0.sort_order AS sort_order_8 FROM available_locale t0 WHERE t0.code = 'fr' AND t0.enabled = 1 LIMIT 1;
2	2.16 ms	SELECT a0_.id AS id_0, a0_.code AS code_1, a0_.name AS name_2, a0_.native_name AS native_name_3, a0_.flag_emoji AS flag_emoji_4, a0_.country_code AS country_code_5, a0_.enabled AS enabled_6, a0_.sort_order AS sort_order_7 FROM available_locale a0_ WHERE a0_.enabled = ? ORDER BY a0_.sort_order ASC, a0_.name ASC Parameters: [`1`] View formatted query View runnable query Explain query SELECT a0_.id AS id_0, a0_.code AS code_1, a0_.name AS name_2, a0_.native_name AS native_name_3, a0_.flag_emoji AS flag_emoji_4, a0_.country_code AS country_code_5, a0_.enabled AS enabled_6, a0_.sort_order AS sort_order_7 FROM available_locale a0_ WHERE a0_.enabled = ? ORDER BY a0_.sort_order ASC, a0_.name ASC SELECT a0_.id AS id_0, a0_.code AS code_1, a0_.name AS name_2, a0_.native_name AS native_name_3, a0_.flag_emoji AS flag_emoji_4, a0_.country_code AS country_code_5, a0_.enabled AS enabled_6, a0_.sort_order AS sort_order_7 FROM available_locale a0_ WHERE a0_.enabled = 1 ORDER BY a0_.sort_order ASC, a0_.name ASC;

#▲

Time

Info

2.60 ms

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.native_name AS native_name_4, t0.flag_emoji AS flag_emoji_5, t0.country_code AS country_code_6, t0.enabled AS enabled_7, t0.sort_order AS sort_order_8 FROM available_locale t0 WHERE t0.code = ? AND t0.enabled = ? LIMIT 1

Parameters:

[
  "fr"
  1
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.native_name AS native_name_4,
  t0.flag_emoji AS flag_emoji_5,
  t0.country_code AS country_code_6,
  t0.enabled AS enabled_7,
  t0.sort_order AS sort_order_8
FROM
  available_locale t0
WHERE
  t0.code = ?
  AND t0.enabled = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.native_name AS native_name_4, t0.flag_emoji AS flag_emoji_5, t0.country_code AS country_code_6, t0.enabled AS enabled_7, t0.sort_order AS sort_order_8 FROM available_locale t0 WHERE t0.code = 'fr' AND t0.enabled = 1 LIMIT 1;

2.16 ms

SELECT a0_.id AS id_0, a0_.code AS code_1, a0_.name AS name_2, a0_.native_name AS native_name_3, a0_.flag_emoji AS flag_emoji_4, a0_.country_code AS country_code_5, a0_.enabled AS enabled_6, a0_.sort_order AS sort_order_7 FROM available_locale a0_ WHERE a0_.enabled = ? ORDER BY a0_.sort_order ASC, a0_.name ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query

SELECT
  a0_.id AS id_0,
  a0_.code AS code_1,
  a0_.name AS name_2,
  a0_.native_name AS native_name_3,
  a0_.flag_emoji AS flag_emoji_4,
  a0_.country_code AS country_code_5,
  a0_.enabled AS enabled_6,
  a0_.sort_order AS sort_order_7
FROM
  available_locale a0_
WHERE
  a0_.enabled = ?
ORDER BY
  a0_.sort_order ASC,
  a0_.name ASC

SELECT a0_.id AS id_0, a0_.code AS code_1, a0_.name AS name_2, a0_.native_name AS native_name_3, a0_.flag_emoji AS flag_emoji_4, a0_.country_code AS country_code_5, a0_.enabled AS enabled_6, a0_.sort_order AS sort_order_7 FROM available_locale a0_ WHERE a0_.enabled = 1 ORDER BY a0_.sort_order ASC, a0_.name ASC;

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\AvailableLocale	22

Entities Mapping

Class	Mapping errors
App\Entity\Equipment\AircraftEquipmentItem	No errors.
App\Entity\Equipment\AircraftEquipmentAnswer	No errors.
App\Entity\Licence\AbstractRequiredQualificationOption	No errors.
App\Entity\Logbook\LogbookInitialisation	No errors.
App\Entity\Logbook\LogbookHistoryEntry	No errors.
App\Entity\Planning\CrewProgrammeStep	No errors.
App\Entity\Planning\PlannedFlightPassenger	No errors.
App\Entity\Planning\PlanningNotice	No errors.
App\Entity\Planning\PlanningImportBatch	No errors.
App\Entity\Planning\PlannedMaintenance	No errors.
App\Entity\Planning\PlannedFlight	No errors.
App\Entity\Planning\PlanningMemberAvailability	No errors.
App\Entity\Planning\PlanningDayNote	No errors.
App\Entity\Planning\PlannedMissionCrew	No errors.
App\Entity\Planning\PlanningSubActivity	No errors.
App\Entity\Planning\PlanningSettings	No errors.
App\Entity\Planning\PlannedFlightCrewConfirmation	No errors.
App\Entity\Planning\PlannedMissionAircraft	No errors.
App\Entity\Planning\PlanningWorkshopTool	No errors.
App\Entity\Planning\PlanningImportedItem	No errors.
App\Entity\Planning\PlanningPersonalEntry	No errors.
App\Entity\Planning\UserPlanningCalendar	No errors.
App\Entity\Planning\PlanningAircraftUnavailability	No errors.
App\Entity\Planning\PlanningWorkshop	No errors.
App\Entity\Planning\CrewProgrammeMember	No errors.
App\Entity\Planning\PlanningRightException	No errors.
App\Entity\Planning\PlannedMission	No errors.
App\Entity\Planning\CrewProgramme	No errors.
App\Entity\Planning\PlanningEvent	No errors.
App\Entity\Accounting\AviatorAccountEntry	No errors.
App\Entity\Accounting\OrganisationClient	No errors.
App\Entity\Accounting\InstructorRate	No errors.
App\Entity\Accounting\InvoiceLine	No errors.
App\Entity\Accounting\TrainingPackageSubscription	No errors.
App\Entity\Accounting\Invoice	No errors.
App\Entity\Accounting\InvoiceEvent	No errors.
App\Entity\Accounting\Accounting	No errors.
App\Entity\Accounting\AviatorAccount	No errors.
App\Entity\Accounting\OrganisationAccountingSettings	No errors.
App\Entity\Accounting\TrainingPackage	No errors.
App\Entity\Accounting\PaymentAllocation	No errors.
App\Entity\Accounting\AircraftAccountingRate	No errors.
App\Entity\Accounting\VatGroup	No errors.
App\Entity\Accounting\InvoiceSequence	No errors.
App\Entity\Accounting\AircraftTypeInstructionRate	No errors.
App\Entity\Unit	No errors.
App\Entity\Propeller\PropellerTypeVariant	No errors.
App\Entity\Propeller\PropellerTypeCertificate	No errors.
App\Entity\Propeller\PropellerType	No errors.
App\Entity\Manufacturer	No errors.
App\Entity\Tcds\TcdsDocument	No errors.
App\Entity\Tcds\TcdsProposal	No errors.
App\Entity\Tcds\TcdsExtraction	No errors.
App\Entity\Tcds\TcdsModelData	No errors.
App\Entity\PilotMedicalCertificate\PilotMedicalCertificateLimitation	No errors.
App\Entity\PilotMedicalCertificate\PilotMedicalCertificatePrivilege	No errors.
App\Entity\PilotMedicalCertificate\PilotMedicalCertificate	No errors.
App\Entity\PilotMedicalCertificate\PilotMedicalCertificateDocument	No errors.
App\Entity\Ai\AiUsageLog	No errors.
App\Entity\PilotLicence\PilotLicenceAttachedDocument	No errors.
App\Entity\PilotLicence\PilotLicenceTriType	No errors.
App\Entity\PilotLicence\PilotLicenceTreType	No errors.
App\Entity\PilotLicence\PilotLicenceItem	No errors.
App\Entity\PilotLicence\PilotTypeRatingReference	No errors.
App\Entity\PilotLicence\PilotLicence	No errors.
App\Entity\Engine\EngineTypeVariant	No errors.
App\Entity\Engine\EngineTypeCertificate	No errors.
App\Entity\Engine\EngineType	No errors.
App\Entity\MechanicLicence\MechanicLicenceType	No errors.
App\Entity\MechanicLicence\MechanicLicenceRestriction	No errors.
App\Entity\MechanicLicence\MechanicLicence	No errors.
App\Entity\MechanicLicence\MechanicLicenceQualification	No errors.
App\Entity\MechanicLicence\MechanicLicenceDocument	No errors.
App\Entity\Organisation\OrganisationActivityDomain	No errors.
App\Entity\Organisation\OrganisationMelExpirySetting	No errors.
App\Entity\Organisation\Organisation	No errors.
App\Entity\Organisation\OrganisationModule	No errors.
App\Entity\Organisation\OrganisationRoleNode	No errors.
App\Entity\Organisation\OrganisationRequiredCredentialOption	No errors.
App\Entity\Organisation\OrganisationRegulatoryProfile	No errors.
App\Entity\Organisation\OrganisationFtlRule	No errors.
App\Entity\Organisation\OrganisationAircraftArchive	No errors.
App\Entity\Organisation\OrganisationRequiredCredentialRole	No errors.
App\Entity\Organisation\OrganisationSubRole	No errors.
App\Entity\Organisation\OrganisationRequiredCredential	No errors.
App\Entity\Registry\AircraftRegistryEntry	No errors.
App\Entity\AvailableLocale	No errors.
App\Entity\Integration\LeonConnection	No errors.
App\Entity\Integration\ExternalScheduledFlight	No errors.
App\Entity\Easa\EasaEtso	No errors.
App\Entity\Easa\EasaStc	No errors.
App\Entity\ResetPasswordRequest	No errors.
App\Entity\AircraftPart\AircraftPart	No errors.
App\Entity\AircraftPart\AircraftPartCounter	No errors.
App\Entity\AircraftPart\AircraftPartInstallationPosition	No errors.
App\Entity\AircraftPart\AircraftPartCounterDefinition	No errors.
App\Entity\AircraftPart\AircraftPartName	No errors.
App\Entity\AircraftPart\AircraftPartCounterLimit	No errors.
App\Entity\AircraftPart\AircraftPartStorageLocation	No errors.
App\Entity\AircraftPart\AircraftPartType	No errors.
App\Entity\AircraftPart\AircraftPartInstallation	No errors.
App\Entity\AircraftPart\AircraftPartCounterReading	No errors.
App\Entity\Ad\DirectiveDocument	No errors.
App\Entity\Ad\AircraftAd	No errors.
App\Entity\Ad\AircraftAdWatch	No errors.
App\Entity\Ad\FaaAdIndex	No errors.
App\Entity\Ad\AirworthinessDirective	No errors.
App\Entity\Ad\FaaTcdsModel	No errors.
App\Entity\DataSource\DataSourceCheck	No errors.
App\Entity\DataSource\DataSource	No errors.
App\Entity\DataSource\DataSourceRequest	No errors.
App\Entity\User\UserAprsNumber	No errors.
App\Entity\User\User	No errors.
App\Entity\User\UserRole	No errors.
App\Entity\Legal\LegalDocumentVersion	No errors.
App\Entity\Legal\UserLegalAcceptance	No errors.
App\Entity\PilotLogBook\PilotLogBookAircraftInit	No errors.
App\Entity\PilotLogBook\PilotLogBookFlightFunction	No errors.
App\Entity\PilotLogBook\PilotLogBook	No errors.
App\Entity\PilotLogBook\PilotLogBookSimulator	No errors.
App\Entity\PilotLogBook\PilotLogBookInit	No errors.
App\Entity\PilotLogBook\PilotLogBookSimulatorType	No errors.
App\Entity\Subscription\SubscriptionPlan	No errors.
App\Entity\Subscription\PlanFeature	No errors.
App\Entity\Subscription\OrganisationFeatureOverride	No errors.
App\Entity\Subscription\Feature	No errors.
App\Entity\Subscription\OrganisationSubscription	No errors.
App\Entity\ReferenceData\ReferenceDataImport	No errors.
App\Entity\Airworthiness\AirworthinessSettings	No errors.
App\Entity\Airworthiness\AirworthinessRightException	No errors.
App\Entity\Airworthiness\DeferralMessage	No errors.
App\Entity\Membership\Membership	No errors.
App\Entity\Membership\MembershipAircraft	No errors.
App\Entity\Membership\MembershipRole	No errors.
App\Entity\Membership\MembershipApiAircraft	No errors.
App\Entity\Membership\ApiCredential	No errors.
App\Entity\AtaCode	No errors.
App\Entity\Training\TrainingRecordCheckItem	No errors.
App\Entity\Training\TrainingGrade	No errors.
App\Entity\Training\TrainingRecordCheck	No errors.
App\Entity\Training\TrainingSoloAuthorisation	No errors.
App\Entity\Training\TrainingExercise	No errors.
App\Entity\Training\TrainingRightException	No errors.
App\Entity\Training\TrainingAuthorityStep	No errors.
App\Entity\Training\TrainingSession	No errors.
App\Entity\Training\TrainingSettings	No errors.
App\Entity\Training\TrainingCompetence	No errors.
App\Entity\Training\TrainingQuizQuestion	No errors.
App\Entity\Training\TrainingLessonDocument	No errors.
App\Entity\Training\TrainingProgramme	No errors.
App\Entity\Training\TrainingLesson	No errors.
App\Entity\Training\TrainingPhase	No errors.
App\Entity\Training\TrainingFlightWeather	No errors.
App\Entity\Training\TrainingGroundSession	No errors.
App\Entity\Training\TrainingEnrolment	No errors.
App\Entity\Aircraft\AircraftType	No errors.
App\Entity\Aircraft\AircraftParameterReadingRule	No errors.
App\Entity\Aircraft\AircraftActivityParameterReadingValue	No errors.
App\Entity\Aircraft\AircraftActivityAuthority	No errors.
App\Entity\Aircraft\AircraftFormSectionValidation	No errors.
App\Entity\Aircraft\AircraftEnergySourceServicingQuantity	No errors.
App\Entity\Aircraft\AircraftActivityMaintenance	No errors.
App\Entity\Aircraft\AircraftEnergySource	No errors.
App\Entity\Aircraft\AircraftInheritedFieldOverride	No errors.
App\Entity\Aircraft\AircraftActivityEnergyState	No errors.
App\Entity\Aircraft\AircraftActivitySpecificServicingTypeQuantity	No errors.
App\Entity\Aircraft\AircraftWeightAndBalance	No errors.
App\Entity\Aircraft\AircraftStakeholder	No errors.
App\Entity\Aircraft\Aircraft	No errors.
App\Entity\Aircraft\AircraftDocument	No errors.
App\Entity\Aircraft\AircraftCustomReadingParameter	No errors.
App\Entity\Aircraft\AircraftAircraftActivitySettings	No errors.
App\Entity\Aircraft\AircraftParameterReadingGroundTest	No errors.
App\Entity\Aircraft\AircraftTypeCategorySpecification	No errors.
App\Entity\Aircraft\AircraftTypeNationalIdentification	No errors.
App\Entity\Aircraft\AircraftRecurringOperationRecord	No errors.
App\Entity\Aircraft\AircraftParameterReadingSetting	No errors.
App\Entity\Aircraft\AircraftRegistration	No errors.
App\Entity\Aircraft\AircraftActivity	No errors.
App\Entity\Aircraft\AircraftTypeVariant	No errors.
App\Entity\Aircraft\AircraftTypeCertificate	No errors.
App\Entity\Aircraft\AircraftActivityFlight	No errors.
App\Entity\Aircraft\AircraftActivityFlightCrewMember	No errors.
App\Entity\Aircraft\AircraftActivityParameterReading	No errors.
App\Entity\Aircraft\AircraftOperationalSnapshot	No errors.
App\Entity\Aircraft\AircraftActivityGroundRunUp	No errors.
App\Entity\Aircraft\AircraftStatus	No errors.
App\Entity\Aircraft\AircraftSpecificServicingType	No errors.
App\Entity\Aircraft\AircraftRecurringMaintenanceActivity	No errors.
App\Entity\Aircraft\AircraftMel	No errors.
App\Entity\Aircraft\AircraftServiceProvider	No errors.
App\Entity\Reference\ReferenceImportRun	No errors.
App\Entity\Kardex\KardexEvent	No errors.
App\Entity\Kardex\WorkPackageTask	No errors.
App\Entity\Kardex\KardexImportBatch	No errors.
App\Entity\Kardex\KardexItem	No errors.
App\Entity\Kardex\KardexReference	No errors.
App\Entity\Kardex\KardexComparison	No errors.
App\Entity\Kardex\MaintenanceProgrammeTask	No errors.
App\Entity\Kardex\KardexComparisonExplanation	No errors.
App\Entity\Kardex\MaintenanceEvidence	No errors.
App\Entity\Kardex\MaintenanceProgramme	No errors.
App\Entity\Kardex\KardexLimit	No errors.
App\Entity\Kardex\KardexChange	No errors.
App\Entity\Kardex\WorkPackage	No errors.
App\Entity\Airfield\AirfieldType	No errors.
App\Entity\Airfield\AirfieldRegion	No errors.
App\Entity\Airfield\AirfieldContinent	No errors.
App\Entity\Airfield\AirfieldCountry	No errors.
App\Entity\Airfield\AirfieldRunway	No errors.
App\Entity\Airfield\Airfield	No errors.

Symfony Profiler

GET https://develop.app.aviatorlog.com/fr/login

Configuration Settings

Theme

Page Width