GET https://umpscr.distantaccess.com/

Query Metrics

13 Database Queries
7 Different statements
13.01 ms Query time
0 Invalid entities
17 Managed entities

Queries

Group similar statements

# Time Info
1 5.96 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.city AS city_4, t0.website AS website_5, t0.email AS email_6, t0.phone AS phone_7, t0.ap_confirmation_interest AS ap_confirmation_interest_8, t0.ap_confirmation_paid_fees AS ap_confirmation_paid_fees_9, t0.ap_confirmation_start_implementation AS ap_confirmation_start_implementation_10, t0.ip_coordinator_training_certificate_id AS ip_coordinator_training_certificate_id_11, t0.ip_coordinator_completion_date AS ip_coordinator_completion_date_12, t0.ip_confirmation_course_successfully_taken AS ip_confirmation_course_successfully_taken_13, t0.ip_confirmation_implementing_framework AS ip_confirmation_implementing_framework_14, t0.sa_initial_listing_date AS sa_initial_listing_date_15, t0.sa_expiration_date AS sa_expiration_date_16, t0.sa_confirmation_framework_implemented AS sa_confirmation_framework_implemented_17, t0.sa_confirmation_declared_to_adhere AS sa_confirmation_declared_to_adhere_18, t0.sa_confirmation_completed_necessary_steps AS sa_confirmation_completed_necessary_steps_19, t0.tp_auditor_name AS tp_auditor_name_20, t0.tp_auditor_email AS tp_auditor_email_21, t0.tp_auditor_phone AS tp_auditor_phone_22, t0.tp_auditor_training_certificate_id AS tp_auditor_training_certificate_id_23, t0.tp_auditor_training_completion_date AS tp_auditor_training_completion_date_24, t0.tp_initial_listing_date AS tp_initial_listing_date_25, t0.tp_expiration_date AS tp_expiration_date_26, t0.tp_confirmation_framework_implemented AS tp_confirmation_framework_implemented_27, t0.tp_confirmation_declared_to_adhere AS tp_confirmation_declared_to_adhere_28, t0.tp_confirmation_completed_necessary_steps AS tp_confirmation_completed_necessary_steps_29, t0.tp_confirmation_course_successfully_taken AS tp_confirmation_course_successfully_taken_30, t0.tp_is_implementing_process AS tp_is_implementing_process_31, t0.registration_author_name AS registration_author_name_32, t0.registration_date AS registration_date_33, t0.organization_logo_name AS organization_logo_name_34, t0.ap_document_name AS ap_document_name_35, t0.ip_document_name AS ip_document_name_36, t0.ip_certificate_coordination_course_name AS ip_certificate_coordination_course_name_37, t0.sa_attestation_document_name AS sa_attestation_document_name_38, t0.sa_attestation_logo_name AS sa_attestation_logo_name_39, t0.tp_attestation_document_name AS tp_attestation_document_name_40, t0.tp_attestation_logo_name AS tp_attestation_logo_name_41, t0.created_at AS created_at_42, t0.updated_at AS updated_at_43, t0.stripe_customer_id AS stripe_customer_id_44, t0.certification_expiration_date AS certification_expiration_date_45, t0.subscription_expiration_date AS subscription_expiration_date_46, t0.country_id AS country_id_47, t0.organization_status_id AS organization_status_id_48, t0.implementation_type_id AS implementation_type_id_49, t0.registration_state_id AS registration_state_id_50 FROM organization t0 WHERE t0.registration_state_id = ?
Parameters:
[
  2
]
2 0.89 ms
SELECT t0.id AS id_1, t0.code_iso AS code_iso_2, t0.name AS name_3 FROM country t0 WHERE t0.id = ?
Parameters:
[
  3
]
3 0.85 ms
SELECT t0.id AS id_1, t0.name_translated AS name_translated_2, t0.country_id AS country_id_3, t0.language_id AS language_id_4 FROM country_name t0 WHERE t0.country_id = ?
Parameters:
[
  3
]
4 0.83 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM organization_status t0 WHERE t0.id = ?
Parameters:
[
  3
]
5 0.73 ms
SELECT t0.id AS id_1, t0.name_translated AS name_translated_2, t0.organization_status_id AS organization_status_id_3, t0.language_id AS language_id_4 FROM organization_status_name t0 WHERE t0.organization_status_id = ?
Parameters:
[
  3
]
6 0.49 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM implementation_type t0 WHERE t0.id = ?
Parameters:
[
  1
]
7 0.51 ms
SELECT t0.id AS id_1, t0.name_translated AS name_translated_2, t0.implementation_type_id AS implementation_type_id_3, t0.language_id AS language_id_4 FROM implementation_type_name t0 WHERE t0.implementation_type_id = ?
Parameters:
[
  1
]
8 0.44 ms
SELECT t0.id AS id_1, t0.code_iso AS code_iso_2, t0.name AS name_3 FROM country t0 WHERE t0.id = ?
Parameters:
[
  1
]
9 0.49 ms
SELECT t0.id AS id_1, t0.name_translated AS name_translated_2, t0.country_id AS country_id_3, t0.language_id AS language_id_4 FROM country_name t0 WHERE t0.country_id = ?
Parameters:
[
  1
]
10 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM organization_status t0 WHERE t0.id = ?
Parameters:
[
  2
]
11 0.46 ms
SELECT t0.id AS id_1, t0.name_translated AS name_translated_2, t0.organization_status_id AS organization_status_id_3, t0.language_id AS language_id_4 FROM organization_status_name t0 WHERE t0.organization_status_id = ?
Parameters:
[
  2
]
12 0.43 ms
SELECT t0.id AS id_1, t0.code_iso AS code_iso_2, t0.name AS name_3 FROM country t0 WHERE t0.id = ?
Parameters:
[
  217
]
13 0.49 ms
SELECT t0.id AS id_1, t0.name_translated AS name_translated_2, t0.country_id AS country_id_3, t0.language_id AS language_id_4 FROM country_name t0 WHERE t0.country_id = ?
Parameters:
[
  217
]

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\Organization 3
App\Entity\Country 3
App\Entity\CountryName 3
App\Entity\OrganizationStatus 2
App\Entity\OrganizationStatusName 2
App\Entity\ImplementationType 1
App\Entity\RegistrationState 1
App\Entity\Language 1
App\Entity\ImplementationTypeName 1