Query Metrics
13
Database Queries
7
Different statements
6.91 ms
Query time
0
Invalid entities
17
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1.56 ms (22.56%) |
3 |
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
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (20.85%) |
3 |
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
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (20.74%) |
1 |
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
]
|
||||||||||||||||||||||||||||||
|
0.86 ms (12.44%) |
2 |
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
]
|
||||||||||||||||||||||||||||||
|
0.79 ms (11.37%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM organization_status t0 WHERE t0.id = ?
Parameters:
[
3
]
|
||||||||||||||||||||||||||||||
|
0.42 ms (6.14%) |
1 |
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
]
|
||||||||||||||||||||||||||||||
|
0.41 ms (5.91%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM implementation_type t0 WHERE t0.id = ?
Parameters:
[
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 |
|---|---|
| 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 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Organization | No errors. |
| App\Entity\Country | No errors. |
| App\Entity\OrganizationStatus | No errors. |
| App\Entity\ImplementationType | No errors. |
| App\Entity\RegistrationState | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Coordinator | No errors. |
| App\Entity\Subscription | No errors. |
| App\Entity\CountryName | No errors. |
| App\Entity\Language | No errors. |
| App\Entity\OrganizationStatusName | No errors. |
| App\Entity\ImplementationTypeName | No errors. |