Query Metrics
33
Database Queries
7
Different statements
40.31 ms
Query time
4
Invalid entities
54
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.64 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"
]
|
| 2 | 1.61 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"
]
|
| 3 | 1.31 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"
]
|
| 4 | 1.92 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 ] |
| 5 | 1.25 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
]
|
| 6 | 1.34 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
]
|
| 7 | 1.27 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
]
|
| 8 | 1.16 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
]
|
| 9 | 1.25 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
]
|
| 10 | 1.26 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
]
|
| 11 | 1.29 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
]
|
| 12 | 1.20 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
]
|
| 13 | 1.12 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
]
|
| 14 | 1.29 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
]
|
| 15 | 1.22 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
]
|
| 16 | 1.07 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM ffservice_translation t0 WHERE t0.locale = ? ORDER BY t0.name ASC
Parameters:
[
"en"
]
|
| 17 | 1.01 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.icon AS icon_3, t0.slug AS slug_4, t0.hide_for_eu AS hide_for_eu_5, t0.school_can_edit_text AS school_can_edit_text_6, t0.btoc AS btoc_7, t0.display_in_analytic AS display_in_analytic_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM ff_service t0 WHERE t0.id = ?
Parameters:
[
24
]
|
| 18 | 0.99 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.icon AS icon_3, t0.slug AS slug_4, t0.hide_for_eu AS hide_for_eu_5, t0.school_can_edit_text AS school_can_edit_text_6, t0.btoc AS btoc_7, t0.display_in_analytic AS display_in_analytic_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM ff_service t0 WHERE t0.id = ?
Parameters:
[
2
]
|
| 19 | 0.98 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.icon AS icon_3, t0.slug AS slug_4, t0.hide_for_eu AS hide_for_eu_5, t0.school_can_edit_text AS school_can_edit_text_6, t0.btoc AS btoc_7, t0.display_in_analytic AS display_in_analytic_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM ff_service t0 WHERE t0.id = ?
Parameters:
[
11
]
|
| 20 | 1.04 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.icon AS icon_3, t0.slug AS slug_4, t0.hide_for_eu AS hide_for_eu_5, t0.school_can_edit_text AS school_can_edit_text_6, t0.btoc AS btoc_7, t0.display_in_analytic AS display_in_analytic_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM ff_service t0 WHERE t0.id = ?
Parameters:
[
26
]
|
| 21 | 0.95 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.icon AS icon_3, t0.slug AS slug_4, t0.hide_for_eu AS hide_for_eu_5, t0.school_can_edit_text AS school_can_edit_text_6, t0.btoc AS btoc_7, t0.display_in_analytic AS display_in_analytic_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM ff_service t0 WHERE t0.id = ?
Parameters:
[
18
]
|
| 22 | 1.01 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.icon AS icon_3, t0.slug AS slug_4, t0.hide_for_eu AS hide_for_eu_5, t0.school_can_edit_text AS school_can_edit_text_6, t0.btoc AS btoc_7, t0.display_in_analytic AS display_in_analytic_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM ff_service t0 WHERE t0.id = ?
Parameters:
[
4
]
|
| 23 | 0.98 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.icon AS icon_3, t0.slug AS slug_4, t0.hide_for_eu AS hide_for_eu_5, t0.school_can_edit_text AS school_can_edit_text_6, t0.btoc AS btoc_7, t0.display_in_analytic AS display_in_analytic_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM ff_service t0 WHERE t0.id = ?
Parameters:
[
22
]
|
| 24 | 0.99 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.icon AS icon_3, t0.slug AS slug_4, t0.hide_for_eu AS hide_for_eu_5, t0.school_can_edit_text AS school_can_edit_text_6, t0.btoc AS btoc_7, t0.display_in_analytic AS display_in_analytic_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM ff_service t0 WHERE t0.id = ?
Parameters:
[
21
]
|
| 25 | 1.05 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.icon AS icon_3, t0.slug AS slug_4, t0.hide_for_eu AS hide_for_eu_5, t0.school_can_edit_text AS school_can_edit_text_6, t0.btoc AS btoc_7, t0.display_in_analytic AS display_in_analytic_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM ff_service t0 WHERE t0.id = ?
Parameters:
[
3
]
|
| 26 | 1.03 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.icon AS icon_3, t0.slug AS slug_4, t0.hide_for_eu AS hide_for_eu_5, t0.school_can_edit_text AS school_can_edit_text_6, t0.btoc AS btoc_7, t0.display_in_analytic AS display_in_analytic_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM ff_service t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 27 | 1.31 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.icon AS icon_3, t0.slug AS slug_4, t0.hide_for_eu AS hide_for_eu_5, t0.school_can_edit_text AS school_can_edit_text_6, t0.btoc AS btoc_7, t0.display_in_analytic AS display_in_analytic_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM ff_service t0 WHERE t0.id = ?
Parameters:
[
23
]
|
| 28 | 1.08 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.icon AS icon_3, t0.slug AS slug_4, t0.hide_for_eu AS hide_for_eu_5, t0.school_can_edit_text AS school_can_edit_text_6, t0.btoc AS btoc_7, t0.display_in_analytic AS display_in_analytic_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM ff_service t0 WHERE t0.id = ?
Parameters:
[
27
]
|
| 29 | 1.08 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.icon AS icon_3, t0.slug AS slug_4, t0.hide_for_eu AS hide_for_eu_5, t0.school_can_edit_text AS school_can_edit_text_6, t0.btoc AS btoc_7, t0.display_in_analytic AS display_in_analytic_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM ff_service t0 WHERE t0.id = ?
Parameters:
[
17
]
|
| 30 | 1.16 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.icon AS icon_3, t0.slug AS slug_4, t0.hide_for_eu AS hide_for_eu_5, t0.school_can_edit_text AS school_can_edit_text_6, t0.btoc AS btoc_7, t0.display_in_analytic AS display_in_analytic_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM ff_service t0 WHERE t0.id = ?
Parameters:
[
25
]
|
| 31 | 1.27 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.icon AS icon_3, t0.slug AS slug_4, t0.hide_for_eu AS hide_for_eu_5, t0.school_can_edit_text AS school_can_edit_text_6, t0.btoc AS btoc_7, t0.display_in_analytic AS display_in_analytic_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM ff_service t0 WHERE t0.id = ?
Parameters:
[
20
]
|
| 32 | 1.89 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.icon AS icon_3, t0.slug AS slug_4, t0.hide_for_eu AS hide_for_eu_5, t0.school_can_edit_text AS school_can_edit_text_6, t0.btoc AS btoc_7, t0.display_in_analytic AS display_in_analytic_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM ff_service t0 WHERE t0.id = ?
Parameters:
[
19
]
|
| 33 | 1.25 ms |
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2, c0_.show_in_bto_c AS show_in_bto_c_3 FROM city c0_ WHERE c0_.show_in_bto_c = ? ORDER BY c0_.title ASC
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\FFService\Entity\FFServiceTranslation | 16 |
| App\FFService\Entity\FFService | 16 |
| App\Entity\School | 11 |
| App\Entity\City | 4 |
| App\Entity\StripePayment | 3 |
| App\Entity\ServiceStructure | 3 |
| App\Entity\File | 1 |