Query Metrics
2
Database Queries
2
Different statements
1.47 ms
Query time
11
Invalid entities
0
Managed entities
Grouped Statements
| 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 |
|
| App\Domain\Entity\Organisation | No errors. |
| App\Entity\Event | No errors. |
| App\Domain\Entity\Client |
|
| App\Entity\Location | No errors. |
| App\Entity\Client |
|
| 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 |
|
| App\Entity\ClientContact | No errors. |
| App\Entity\ClientCustomer |
|
| 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 |
|
| App\Entity\InvoiceSettings |
|
| App\Entity\InvoiceSettingsV2 |
|
| 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 |
|
| 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 |
|
| 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 |
|
| 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. |