Query Metrics

16 Database Queries
5 Different statements
15.09 ms Query time
2 Invalid entities
18 Managed entities

Queries

Group similar statements

# Time Info
1 4.34 ms
SELECT MAX(l0_.updated_at) AS sclr_0 FROM lexik_trans_unit_translations l0_
Parameters:
[]
2 0.85 ms
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"
]
3 0.69 ms
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:
[
  "page-unlock"
]
4 0.70 ms
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:
[
  "btoc"
]
5 1.38 ms
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
]
6 0.70 ms
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
]
7 0.74 ms
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:
[
  4
]
8 0.58 ms
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:
[
  14
]
9 0.52 ms
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:
[
  5
]
10 0.63 ms
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:
[
  16
]
11 0.57 ms
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:
[
  15
]
12 0.82 ms
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:
[
  9
]
13 0.74 ms
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:
[
  19
]
14 0.68 ms
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:
[
  24
]
15 0.54 ms
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:
[
  17
]
16 0.59 ms
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
  • The field App\Entity\School#paths is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Path#school does not contain the required 'inversedBy: "paths"' attribute.
App\Entity\ServiceStructure
  • The field App\Entity\ServiceStructure#schools is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\School#serviceStructure does not contain the required 'inversedBy: "schools"' attribute.
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.