GET https://ebvnbookingwww01.en-masse.nl/

Query Metrics

2 Database Queries
2 Different statements
1.47 ms Query time
11 Invalid entities
0 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.74 ms
(50.37%)
1
SELECT e0_.id AS id_0, e0_.id_at_els AS id_at_els_1, e0_.linked_component_id AS linked_component_id_2, e0_.code AS code_3, e0_.name AS name_4, e0_.label AS label_5, e0_.is_active AS is_active_6, e0_.is_available_for_open_enrollment AS is_available_for_open_enrollment_7, e0_.examiner_required AS examiner_required_8, e0_.duration_in_minutes AS duration_in_minutes_9, e0_.exam_format AS exam_format_10, e0_.allowed_weekdays AS allowed_weekdays_11, e0_.block_weekend AS block_weekend_12, e0_.valid_from AS valid_from_13, e0_.valid_until AS valid_until_14, e0_.created_at AS created_at_15, e0_.updated_at AS updated_at_16, e0_.exam_id AS exam_id_17 FROM ebvnv20250618_exam_component e0_ WHERE e0_.is_active = ? AND e0_.is_available_for_open_enrollment = ? ORDER BY e0_.name ASC
Parameters:
[
  1
  1
]
0.73 ms
(49.63%)
1
SELECT e0_.id AS id_0, e0_.id_at_els AS id_at_els_1, e0_.ext_ref AS ext_ref_2, e0_.moment_code AS moment_code_3, e0_.exam_moment_at AS exam_moment_at_4, e0_.is_ebvnmoment AS is_ebvnmoment_5, e0_.canceled_at_in_els AS canceled_at_in_els_6, e0_.deleted_at_in_els AS deleted_at_in_els_7, e0_.exam_format AS exam_format_8, e0_.exam_formats AS exam_formats_9, e0_.candidate_count AS candidate_count_10, e0_.total_exam_personnel AS total_exam_personnel_11, e0_.total_candidate_registrations AS total_candidate_registrations_12, e0_.language_codes AS language_codes_13, e0_.status AS status_14, e0_.is_approved_by_ebvn AS is_approved_by_ebvn_15, e0_.approved_by_ebvnat AS approved_by_ebvnat_16, e0_.created_at AS created_at_17, e0_.updated_at AS updated_at_18, e0_.po_number AS po_number_19, e0_.fetched_candidate_results_iterations AS fetched_candidate_results_iterations_20, e0_.els_sync_error AS els_sync_error_21, e0_.els_sync_error_at AS els_sync_error_at_22, e0_.els_last_sync_attempt_at AS els_last_sync_attempt_at_23, e0_.els_sync_response_data AS els_sync_response_data_24, e0_.approved_by_ebvn_user_id AS approved_by_ebvn_user_id_25, e0_.organisation_id AS organisation_id_26, e0_.exam_location_id AS exam_location_id_27, e0_.legacy_event_id AS legacy_event_id_28, e0_.client_id AS client_id_29 FROM ebvnv20250618_exam_moment e0_ LEFT JOIN ebvnv20250618_exam_location e1_ ON e0_.exam_location_id = e1_.id WHERE e0_.exam_moment_at > ? AND e0_.exam_moment_at <= ? AND e1_.is_available_for_open_enrollment = ? AND e0_.canceled_at_in_els IS NULL ORDER BY e0_.exam_moment_at ASC
Parameters:
[
  "2026-04-26 18:21:24"
  "2026-07-24 18:21:24"
  1
]

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

Entities Mapping

Class Mapping errors
App\Domain\Entity\ExamComponent No errors.
App\Domain\Entity\Exam No errors.
App\Domain\Entity\ExamMoment No errors.
App\Domain\Entity\ExamLocation No errors.
App\Domain\Entity\User
  • The mappings App\Domain\Entity\User#legacyClientTemp and App\Entity\Client#employeesEbvn20250618 are inconsistent with each other.
  • The field App\Domain\Entity\User#documents is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Domain\Entity\Document#user does not contain the required 'inversedBy="documents"' attribute.
App\Domain\Entity\Organisation No errors.
App\Entity\Event No errors.
App\Domain\Entity\Client
  • The field App\Domain\Entity\Client#documents is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Domain\Entity\Document#client does not contain the required 'inversedBy="documents"' attribute.
  • The field App\Domain\Entity\Client#examLocations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Domain\Entity\ExamLocation#client does not contain the required 'inversedBy="examLocations"' attribute.
App\Entity\Location No errors.
App\Entity\Client
  • The mappings App\Entity\Client#employeesEbvn20250618 and App\Domain\Entity\User#client are inconsistent with each other.
App\Entity\User No errors.
App\Entity\Cluster No errors.
App\Entity\Invoice No errors.
App\Entity\Candidate No errors.
App\Entity\ExamenLocatieEbvnUsers No errors.
App\Entity\EventProtocol No errors.
App\Entity\ArchivedCandidate No errors.
App\Entity\ArticleItem No errors.
App\Entity\Certificate
  • The association App\Entity\Certificate#complaints refers to the owning side field App\Entity\Complaint#certificate which does not exist.
App\Entity\ClientContact No errors.
App\Entity\ClientCustomer
  • The association App\Entity\ClientCustomer#client refers to the inverse side field App\Entity\User#customers which does not exist.
App\Entity\ClientDocument No errors.
App\Entity\ClientPostalAddress No errors.
App\Entity\ClusterNotification No errors.
App\Entity\ClusterProtocol No errors.
App\Entity\ClusterUser No errors.
App\Entity\Complaint No errors.
App\Entity\Document No errors.
App\Entity\ELS\QueueItem No errors.
App\Entity\EntitySyncMap No errors.
App\Entity\ExactDivision No errors.
App\Entity\ExactOauth No errors.
App\Entity\ExaminatorDisapproved
  • The association App\Entity\ExaminatorDisapproved#user refers to the inverse side field App\Entity\User#clustersDisapproved which does not exist.
App\Entity\InvoiceSettings
  • The field 'App\Entity\InvoiceSettings#firstExamMomentCost' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\InvoiceSettings#additionalExamMomentCost' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\InvoiceSettings#openExamCost' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\InvoiceSettings#openExamNonNativeSpeakerCost' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\InvoiceSettings#additionalExamEventCost' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\InvoiceSettings#additionalExamLeaderCost' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\InvoiceSettings#travelCostsPerKilometer' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\InvoiceSettings#candidateCost' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\InvoiceSettings#candidateCostNonNativeSpeaker' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\InvoiceSettings#weekendPremiumCost' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\InvoiceSettings#hygienePremiumCost' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\InvoiceSettings#advertisingOnCardCost' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\InvoiceSettings#translationCost' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\InvoiceSettings#locationCost' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\InvoiceSettings#abroadSupervisionCost' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\InvoiceSettingsV2
  • The field 'App\Entity\InvoiceSettingsV2#firstExamMomentCost' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\InvoiceSettingsV2#additionalExamMomentCost' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\InvoiceSettingsV2#openExamCost' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\InvoiceSettingsV2#openExamNonNativeSpeakerCost' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\InvoiceSettingsV2#additionalExamEventCost' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\InvoiceSettingsV2#additionalExamLeaderCost' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\InvoiceSettingsV2#travelCostsPerKilometer' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\InvoiceSettingsV2#candidateCost' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\InvoiceSettingsV2#candidateCostNonNativeSpeaker' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\InvoiceSettingsV2#weekendPremiumCost' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\InvoiceSettingsV2#hygienePremiumCost' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\InvoiceSettingsV2#advertisingOnCardCost' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\InvoiceSettingsV2#translationCost' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\InvoiceSettingsV2#locationCost' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\InvoiceSettingsV2#abroadSupervisionCost' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\LocationOpeningTime No errors.
App\Entity\LocationOpeningTimeException No errors.
App\Entity\LocationRequirement No errors.
App\Entity\Notification No errors.
App\Entity\OAuth\AccessTokenUser No errors.
League\Bundle\OAuth2ServerBundle\Model\AbstractClient No errors.
App\Entity\OAuth\Client No errors.
App\Entity\QueueItemEMO
  • The association App\Entity\QueueItemEMO#event refers to the inverse side field App\Entity\Event#queueItems which does not exist.
App\Entity\RemovedInvoice No errors.
App\Entity\Settings No errors.
App\Entity\UserDocument No errors.
App\Domain\Entity\ExamComponentLanguage No errors.
App\Domain\Entity\CandidateRegistration
  • The association App\Domain\Entity\CandidateRegistration#language refers to the inverse side field App\Domain\Entity\ExamComponentLanguage#candidateRegistrations which does not exist.
App\Domain\Entity\CertificationSystem No errors.
App\Domain\Entity\SogTrainer No errors.
App\Domain\Entity\ExamPersonnel No errors.
App\Domain\Entity\ExamMomentProtocol No errors.
App\Domain\Entity\Invoice No errors.
App\Domain\Entity\Address No errors.
App\Domain\Entity\ExamLocationOpeningTime No errors.
App\Domain\Entity\ExamLocationOpeningTimeException No errors.
App\Domain\Entity\Candidate No errors.
App\Domain\Entity\Document No errors.
App\Domain\Entity\Country No errors.
App\Domain\Entity\ClientPostalAddress No errors.
App\Domain\Entity\ClientContact No errors.
App\Domain\Entity\ClientExamComponent No errors.
App\Domain\Entity\BookingPrice No errors.
App\Domain\Entity\Certificate
  • The association App\Domain\Entity\Certificate#candidate refers to the inverse side field App\Domain\Entity\Candidate#certificates which does not exist.
App\Domain\Entity\CustomCertificate No errors.
App\Domain\Entity\EmailLog No errors.
App\Domain\Entity\EmailTemplate No errors.
App\Domain\Entity\EventLog No errors.
App\Domain\Entity\ExaminatorInvite No errors.
App\Domain\Entity\Language No errors.
App\Domain\Entity\Notification No errors.
App\Domain\Entity\SearchLog No errors.
Vich\UploaderBundle\Entity\File No errors.
League\Bundle\OAuth2ServerBundle\Model\AuthorizationCode No errors.
League\Bundle\OAuth2ServerBundle\Model\RefreshToken No errors.
League\Bundle\OAuth2ServerBundle\Model\AccessToken No errors.