Query Metrics
16
Database Queries
5
Different statements
15.09 ms
Query time
2
Invalid entities
18
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
6.54 ms (43.31%) |
10 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.site AS site_3, t0.added_to_bto_c AS added_to_bto_c_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.school_id AS school_id_7, t0.student_id AS student_id_8 FROM school_free_field t0 WHERE t0.school_id = ?
Parameters:
[
6
]
|
|
4.34 ms (28.74%) |
1 |
SELECT MAX(l0_.updated_at) AS sclr_0 FROM lexik_trans_unit_translations l0_
Parameters:
[] |
|
2.25 ms (14.90%) |
3 |
SELECT s0_.id AS id_0, s0_.price AS price_1, s0_.title AS title_2, s0_.slug AS slug_3, s0_.stripe_id AS stripe_id_4, s0_.data_class AS data_class_5, s0_.tracking AS tracking_6, s0_.payment_for AS payment_for_7, s0_.created_at AS created_at_8, s0_.updated_at AS updated_at_9 FROM stripe_payment s0_ WHERE s0_.slug = ?
Parameters:
[
"full-access-platform"
]
|
|
1.38 ms (9.13%) |
1 |
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.school_services AS school_services_2, s0_.studapart_link AS studapart_link_3, s0_.registration_code AS registration_code_4, s0_.theme_folder AS theme_folder_5, s0_.display_community AS display_community_6, s0_.certificate_payant AS certificate_payant_7, s0_.slug AS slug_8, s0_.bank_email AS bank_email_9, s0_.video_url AS video_url_10, s0_.facebook_url AS facebook_url_11, s0_.instagram_url AS instagram_url_12, s0_.use_zendesk_form AS use_zendesk_form_13, s0_.flatmate_box AS flatmate_box_14, s0_.street AS street_15, s0_.zip AS zip_16, s0_.city AS city_17, s0_.latitude AS latitude_18, s0_.longitude AS longitude_19, s0_.bank2_email AS bank2_email_20, s0_.zendesk_tag AS zendesk_tag_21, s0_.show_in_profile_bto_c AS show_in_profile_bto_c_22, s0_.excluded_documents_ref AS excluded_documents_ref_23, s0_.is_customer AS is_customer_24, s0_.student_can_delete_account AS student_can_delete_account_25, s0_.use_zendesk_form_bto_c AS use_zendesk_form_bto_c_26, s0_.need_bphi_visa AS need_bphi_visa_27, s0_.auth_type AS auth_type_28, s0_.report AS report_29, s0_.without_brevo_automation AS without_brevo_automation_30, s0_.buddy_code AS buddy_code_31, s0_.send_raspail_bank_email AS send_raspail_bank_email_32, s0_.display_agent AS display_agent_33, s0_.display_rating AS display_rating_34, s0_.webinar_url AS webinar_url_35, s0_.event_url AS event_url_36, s0_.display_webinar AS display_webinar_37, s0_.display_event AS display_event_38, s0_.has_lcl_bank AS has_lcl_bank_39, s0_.contact_for_buddy AS contact_for_buddy_40, s0_.display_webinar_video AS display_webinar_video_41, s0_.display_translation AS display_translation_42, s0_.welcome_pack_delivery_point AS welcome_pack_delivery_point_43, s0_.welcome_pack_email_recipient AS welcome_pack_email_recipient_44, s0_.meet_and_greet_email_recipient AS meet_and_greet_email_recipient_45, s0_.excluded_from_etude_france AS excluded_from_etude_france_46, s0_.excluded_from_campus_france AS excluded_from_campus_france_47, s0_.service_structure_id AS service_structure_id_48, s0_.logo_id AS logo_id_49, s0_.learn_french_section AS learn_french_section_50, s0_.principal_school_id AS principal_school_id_51, s0_.school_city_id AS school_city_id_52, s0_.webinar_photo_en_id AS webinar_photo_en_id_53, s0_.webinar_photo_fr_id AS webinar_photo_fr_id_54, s0_.event_photo_en_id AS event_photo_en_id_55, s0_.event_photo_fr_id AS event_photo_fr_id_56 FROM school s0_ WHERE (s0_.show_in_profile_bto_c = ? AND s0_.is_customer = ?) AND (s0_.slug != 'ifa-french-tech') ORDER BY s0_.title ASC
Parameters:
[ 1 1 ] |
|
0.59 ms (3.92%) |
1 |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.path AS path_3, t0.original_filename AS original_filename_4, t0.extension AS extension_5, t0.mime_type AS mime_type_6, t0.token AS token_7, t0.size AS size_8, t0.type AS type_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.cache_resolved AS cache_resolved_12, t0.alias AS alias_13 FROM file t0 WHERE t0.id = ?
Parameters:
[
586
]
|
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\School | 11 |
| App\Entity\StripePayment | 3 |
| App\Entity\ServiceStructure | 3 |
| App\Entity\File | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| Lexik\Bundle\TranslationBundle\Model\Translation | No errors. |
| Lexik\Bundle\TranslationBundle\Entity\Translation | No errors. |
| App\Entity\StripePayment | No errors. |
| App\Entity\StudentPayment | No errors. |
| App\Entity\BaseUser | No errors. |
| App\Entity\Student | No errors. |
| App\Entity\School |
|
| App\Entity\ServiceStructure |
|
| App\Entity\File | No errors. |
| App\Entity\LearnFrench\LearnFrenchSection | No errors. |
| App\Entity\City | No errors. |
| App\Entity\Path | No errors. |
| App\Entity\CertificateDocumentRef | No errors. |
| App\Entity\SpecificPage | No errors. |
| App\Entity\ResidenceNotification | No errors. |
| App\Entity\SchoolFreeField | No errors. |
| App\Entity\ResidenceGroupeSchool | No errors. |
| App\Entity\Agent | No errors. |
| App\Entity\SchoolPub | No errors. |
| App\Entity\SchoolPubChecklistStep | No errors. |
| App\Entity\Bank | No errors. |
| App\Entity\Referent | No errors. |
| App\Entity\ResidenceCity | No errors. |
| App\Entity\Program | No errors. |
| App\Entity\SchoolTrack | No errors. |
| App\Entity\DocumentRef | No errors. |
| App\Entity\SchoolTranslation | No errors. |