Query Metrics

2 Database Queries
2 Different statements
11.06 ms Query time
2 Invalid entities
2 Managed entities

Grouped Statements

Show all queries

Time Count Info
8.21 ms
(74.27%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.company AS company_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone AS phone_8, t0.zip_code AS zip_code_9, t0.city AS city_10, t0.legal_name AS legal_name_11, t0.siret AS siret_12, t0.address AS address_13, t0.latitude AS latitude_14, t0.longitude AS longitude_15, t0.max_collaborators AS max_collaborators_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.blocked AS blocked_20, t0.subscription_end_date AS subscription_end_date_21, t0.reset_token AS reset_token_22, t0.first_login AS first_login_23, t0.is_single_collaborator AS is_single_collaborator_24, t0.driving_school AS driving_school_25, t0.school_id AS school_id_26, t0.subscription_start_date AS subscription_start_date_27, t0.stripe_customer_id AS stripe_customer_id_28, t0.premium AS premium_29, t0.created_by_admin AS created_by_admin_30, t0.status AS status_31, t0.renew_subscription AS renew_subscription_32, t0.manual_subscription AS manual_subscription_33, t0.stripe_subscription_id AS stripe_subscription_id_34, t0.subscription_cancel_date AS subscription_cancel_date_35, t0.subscription_period AS subscription_period_36, t0.ae_approval_number AS ae_approval_number_37, t0.ae_approval_date AS ae_approval_date_38, t0.qualiopi_date AS qualiopi_date_39, t0.qualiopi_categories AS qualiopi_categories_40, t0.qualiopi_certificate_name AS qualiopi_certificate_name_41, t0.qualiopi_certificate_original_name AS qualiopi_certificate_original_name_42, t0.qualiopi_certificate_size AS qualiopi_certificate_size_43, t0.qualiopi_certificate_mime_type AS qualiopi_certificate_mime_type_44, t0.teaching_authorization_number AS teaching_authorization_number_45, t0.google_id AS google_id_46, t0.livre_or_id AS livre_or_id_47, t0.phone_number AS phone_number_48, t0.establishment_email AS establishment_email_49, t0.teaching_auth_nb AS teaching_auth_nb_50, t0.referent_list AS referent_list_51, t0.api_key AS api_key_52, t0.numero_de_declaration_activite AS numero_de_declaration_activite_53, t0.has_compliant_software AS has_compliant_software_54, t0.demarche_start_date AS demarche_start_date_55, t0.demarche_end_date AS demarche_end_date_56, t0.livret_start_date AS livret_start_date_57, t0.livret_end_date AS livret_end_date_58, t0.minisite_start_date AS minisite_start_date_59, t0.minisite_end_date AS minisite_end_date_60, t0.manual_minisite AS manual_minisite_61, t0.manual_demarche AS manual_demarche_62, t0.mediator_company AS mediator_company_63, t0.mediator_address AS mediator_address_64, t0.mediator_zip_code AS mediator_zip_code_65, t0.mediator_city AS mediator_city_66, t0.mediator_phone AS mediator_phone_67, t0.mediator_website AS mediator_website_68, t0.code_course_on_demand AS code_course_on_demand_69, t0.code_stage_by_calendar AS code_stage_by_calendar_70, t0.code_room_max_capacity AS code_room_max_capacity_71, t0.code_room_additional_info AS code_room_additional_info_72, t0.code_room_schedule AS code_room_schedule_73, t0.driving_school_opening_hours AS driving_school_opening_hours_74, t0.has_moto AS has_moto_75, t0.moto_track_address AS moto_track_address_76, t0.moto_track_zip_code AS moto_track_zip_code_77, t0.moto_track_city AS moto_track_city_78, t0.moto_track_travel_time AS moto_track_travel_time_79, t0.moto_track_distance AS moto_track_distance_80, t0.moto_lessons_schedule AS moto_lessons_schedule_81, t0.moto_track_access_schedule AS moto_track_access_schedule_82, t0.moto_additional_info AS moto_additional_info_83, t0.has_remorque AS has_remorque_84, t0.remorque_track_address AS remorque_track_address_85, t0.remorque_track_zip_code AS remorque_track_zip_code_86, t0.remorque_track_city AS remorque_track_city_87, t0.remorque_track_travel_time AS remorque_track_travel_time_88, t0.remorque_track_distance AS remorque_track_distance_89, t0.remorque_lessons_schedule AS remorque_lessons_schedule_90, t0.remorque_track_access_schedule AS remorque_track_access_schedule_91, t0.remorque_additional_info AS remorque_additional_info_92, t0.has_poids_lourd AS has_poids_lourd_93, t0.poids_lourd_track_address AS poids_lourd_track_address_94, t0.poids_lourd_track_zip_code AS poids_lourd_track_zip_code_95, t0.poids_lourd_track_city AS poids_lourd_track_city_96, t0.poids_lourd_track_travel_time AS poids_lourd_track_travel_time_97, t0.poids_lourd_track_distance AS poids_lourd_track_distance_98, t0.poids_lourd_lessons_schedule AS poids_lourd_lessons_schedule_99, t0.poids_lourd_track_access_schedule AS poids_lourd_track_access_schedule_100, t0.poids_lourd_additional_info AS poids_lourd_additional_info_101, t0.has_bateau AS has_bateau_102, t0.bateau_track_address AS bateau_track_address_103, t0.bateau_track_zip_code AS bateau_track_zip_code_104, t0.bateau_track_city AS bateau_track_city_105, t0.bateau_track_travel_time AS bateau_track_travel_time_106, t0.bateau_track_distance AS bateau_track_distance_107, t0.bateau_lessons_schedule AS bateau_lessons_schedule_108, t0.bateau_track_access_schedule AS bateau_track_access_schedule_109, t0.bateau_additional_info AS bateau_additional_info_110, t0.has_psh AS has_psh_111, t0.psh_equipments AS psh_equipments_112, t0.visible_livrets AS visible_livrets_113, t0.livret_header_bg_color AS livret_header_bg_color_114, t0.livret_header_text_color AS livret_header_text_color_115, t0.livret_body_bg_color AS livret_body_bg_color_116, t0.livret_title_color AS livret_title_color_117, t0.livret_text_color AS livret_text_color_118, t0.livret_card_bg_color AS livret_card_bg_color_119, t0.livret_card_title_color AS livret_card_title_color_120, t0.livret_card_text_color AS livret_card_text_color_121, t0.livret_button_bg_color AS livret_button_bg_color_122, t0.livret_button_text_color AS livret_button_text_color_123, t0.livret_footer_bg_color AS livret_footer_bg_color_124, t0.livret_footer_text_color AS livret_footer_text_color_125, t0.livret_zone_background_color AS livret_zone_background_color_126, t0.livret_funding_background_color AS livret_funding_background_color_127, t0.livret_footer_color AS livret_footer_color_128, t0.livret_button_color AS livret_button_color_129, t0.livret_titles_color AS livret_titles_color_130, t0.iframe_claim_color AS iframe_claim_color_131, t0.iframe_success_color AS iframe_success_color_132, t0.iframe_all_reviews_color AS iframe_all_reviews_color_133, t0.iframe_livreor_form_color AS iframe_livreor_form_color_134, t0.client_id AS client_id_135, t0.image_id AS image_id_136, t137.id AS id_138, t137.meta_title AS meta_title_139, t137.meta_description AS meta_description_140, t137.facebook_link AS facebook_link_141, t137.instagram_link AS instagram_link_142, t137.tiktok_link AS tiktok_link_143, t137.website_link AS website_link_144, t137.description AS description_145, t137.slug AS slug_146, t137.body_background_color AS body_background_color_147, t137.header_background_color AS header_background_color_148, t137.header_text_color AS header_text_color_149, t137.footer_background_color AS footer_background_color_150, t137.footer_text_color AS footer_text_color_151, t137.formations_section_bg_color AS formations_section_bg_color_152, t137.formations_section_title_color AS formations_section_title_color_153, t137.formations_card_bg_color AS formations_card_bg_color_154, t137.formations_card_title_color AS formations_card_title_color_155, t137.formations_card_text_color AS formations_card_text_color_156, t137.formations_price_color AS formations_price_color_157, t137.team_section_bg_color AS team_section_bg_color_158, t137.team_section_title_color AS team_section_title_color_159, t137.team_card_bg_color AS team_card_bg_color_160, t137.team_card_text_color AS team_card_text_color_161, t137.hours_section_bg_color AS hours_section_bg_color_162, t137.hours_section_title_color AS hours_section_title_color_163, t137.hours_card_bg_color AS hours_card_bg_color_164, t137.hours_card_text_color AS hours_card_text_color_165, t137.success_section_bg_color AS success_section_bg_color_166, t137.success_section_title_color AS success_section_title_color_167, t137.success_card_bg_color AS success_card_bg_color_168, t137.success_card_title_color AS success_card_title_color_169, t137.success_card_text_color AS success_card_text_color_170, t137.show_success_rate AS show_success_rate_171, t137.funding_section_bg_color AS funding_section_bg_color_172, t137.funding_section_title_color AS funding_section_title_color_173, t137.funding_card_bg_color AS funding_card_bg_color_174, t137.funding_card_text_color AS funding_card_text_color_175, t137.documents_section_bg_color AS documents_section_bg_color_176, t137.documents_section_title_color AS documents_section_title_color_177, t137.documents_card_bg_color AS documents_card_bg_color_178, t137.documents_card_text_color AS documents_card_text_color_179, t137.documents_button_bg_color AS documents_button_bg_color_180, t137.documents_button_text_color AS documents_button_text_color_181, t137.reviews_section_bg_color AS reviews_section_bg_color_182, t137.reviews_section_title_color AS reviews_section_title_color_183, t137.reviews_card_bg_color AS reviews_card_bg_color_184, t137.reviews_card_text_color AS reviews_card_text_color_185, t137.info_section_bg_color AS info_section_bg_color_186, t137.info_section_title_color AS info_section_title_color_187, t137.info_section_text_color AS info_section_text_color_188, t137.info_section_button_bg_color AS info_section_button_bg_color_189, t137.info_section_button_text_color AS info_section_button_text_color_190, t137.reviews_button_bg_color AS reviews_button_bg_color_191, t137.reviews_button_text_color AS reviews_button_text_color_192, t137.button_color AS button_color_193, t137.title_color AS title_color_194, t137.card_background_color AS card_background_color_195, t137.footer_color AS footer_color_196, t137.block_border_color AS block_border_color_197, t137.user_id AS user_id_198, t137.logo_id AS logo_id_199, t137.header_image_id AS header_image_id_200 FROM user t0 LEFT JOIN website t137 ON t137.user_id = t0.id WHERE t0.api_key = ? LIMIT 1
Parameters:
[
  "4c83e78806cf895f3c8c650c161f7c55001c3eb2824abe98b8"
]
2.84 ms
(25.73%)
1
SELECT c0_.id AS id_0, c0_.price AS price_1, c0_.description AS description_2, c0_.created_at AS created_at_3, c0_.user_id AS user_id_4, c0_.formation_id AS formation_id_5 FROM client_formation c0_ WHERE c0_.user_id = ? ORDER BY c0_.created_at DESC
Parameters:
[
  6
]

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\User 1
App\Entity\Website 1

Entities Mapping

Class Mapping errors
App\Entity\User
  • The field App\Entity\User#website is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Website#user does not contain the required 'inversedBy: "website"' attribute.
  • The mappings App\Entity\User#userTrainings and App\Entity\UserLivret#client are inconsistent with each other.
App\Entity\Image No errors.
App\Entity\Website No errors.
App\Entity\TypeOfFunding No errors.
App\Entity\UserLivret
  • The association App\Entity\UserLivret#client refers to the inverse side field App\Entity\User#userLivrets which does not exist.
  • The association App\Entity\UserLivret#training refers to the inverse side field App\Entity\Livret#userLivrets which does not exist.
App\Entity\ClientFormation No errors.
App\Entity\Formation No errors.