https://demo.plateform.jobinlive.fr/public

Query Metrics

9 Database Queries
4 Different statements
8.42 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 2.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.rgpd_file AS rgpd_file_4, t0.description AS description_5, t0.baseline AS baseline_6, t0.background AS background_7, t0.alt_logo AS alt_logo_8, t0.is_active AS is_active_9, t0.created_at AS created_at_10, t0.modified_at AS modified_at_11, t0.slug AS slug_12, t0.salt AS salt_13, t0.main_color AS main_color_14, t0.secondary_color AS secondary_color_15, t0.is_secure AS is_secure_16, t0.is_hidden_job_title AS is_hidden_job_title_17, t0.is_hidden_user_job AS is_hidden_user_job_18, t0.label_location AS label_location_19, t0.label_sub_location AS label_sub_location_20, t0.has_microsoft AS has_microsoft_21, t0.has_zoom AS has_zoom_22 FROM client t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "public"
]
2 1.73 ms
SELECT c0_.id AS id_0, c0_.presentation AS presentation_1, c0_.logo AS logo_2, c0_.title AS title_3, c0_.start_at AS start_at_4, c0_.end_at AS end_at_5, c0_.created_at AS created_at_6, c0_.modified_at AS modified_at_7, c0_.is_active AS is_active_8, c0_.ending_presentation AS ending_presentation_9, c0_.invitation_email_content AS invitation_email_content_10, c0_.can_invite AS can_invite_11, c0_.forced_disabled AS forced_disabled_12, c0_.has_user_ladder AS has_user_ladder_13, c0_.has_location_ladder AS has_location_ladder_14, c0_.prize AS prize_15, c0_.baseline AS baseline_16, c0_.description AS description_17, c0_.text AS text_18, c0_.has_sub_location_ladder AS has_sub_location_ladder_19, c0_.client_id AS client_id_20, c0_.product_id AS product_id_21 FROM client_product c0_ WHERE c0_.is_active = 1 AND c0_.client_id = ? AND c0_.start_at <= ? AND c0_.end_at > ?
Parameters:
[
  1
  "2025-12-06 10:50:57"
  "2025-12-06 10:50:57"
]
3 2.50 ms
SELECT c0_.id AS id_0, c0_.presentation AS presentation_1, c0_.logo AS logo_2, c0_.title AS title_3, c0_.start_at AS start_at_4, c0_.end_at AS end_at_5, c0_.created_at AS created_at_6, c0_.modified_at AS modified_at_7, c0_.is_active AS is_active_8, c0_.ending_presentation AS ending_presentation_9, c0_.invitation_email_content AS invitation_email_content_10, c0_.can_invite AS can_invite_11, c0_.forced_disabled AS forced_disabled_12, c0_.has_user_ladder AS has_user_ladder_13, c0_.has_location_ladder AS has_location_ladder_14, c0_.prize AS prize_15, c0_.baseline AS baseline_16, c0_.description AS description_17, c0_.text AS text_18, c0_.has_sub_location_ladder AS has_sub_location_ladder_19, c0_.client_id AS client_id_20, c0_.product_id AS product_id_21 FROM client_product c0_ WHERE c0_.is_active = 1 AND c0_.client_id = ? AND c0_.start_at <= ? AND c0_.end_at > ? GROUP BY c0_.product_id
Parameters:
[
  1
  "2025-12-06 10:50:57"
  "2025-12-06 10:50:57"
]
4 0.51 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.rgpd_file AS rgpd_file_4, t0.description AS description_5, t0.baseline AS baseline_6, t0.background AS background_7, t0.alt_logo AS alt_logo_8, t0.is_active AS is_active_9, t0.created_at AS created_at_10, t0.modified_at AS modified_at_11, t0.slug AS slug_12, t0.salt AS salt_13, t0.main_color AS main_color_14, t0.secondary_color AS secondary_color_15, t0.is_secure AS is_secure_16, t0.is_hidden_job_title AS is_hidden_job_title_17, t0.is_hidden_user_job AS is_hidden_user_job_18, t0.label_location AS label_location_19, t0.label_sub_location AS label_sub_location_20, t0.has_microsoft AS has_microsoft_21, t0.has_zoom AS has_zoom_22 FROM client t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "public"
]
5 0.26 ms
SELECT c0_.id AS id_0, c0_.presentation AS presentation_1, c0_.logo AS logo_2, c0_.title AS title_3, c0_.start_at AS start_at_4, c0_.end_at AS end_at_5, c0_.created_at AS created_at_6, c0_.modified_at AS modified_at_7, c0_.is_active AS is_active_8, c0_.ending_presentation AS ending_presentation_9, c0_.invitation_email_content AS invitation_email_content_10, c0_.can_invite AS can_invite_11, c0_.forced_disabled AS forced_disabled_12, c0_.has_user_ladder AS has_user_ladder_13, c0_.has_location_ladder AS has_location_ladder_14, c0_.prize AS prize_15, c0_.baseline AS baseline_16, c0_.description AS description_17, c0_.text AS text_18, c0_.has_sub_location_ladder AS has_sub_location_ladder_19, c0_.client_id AS client_id_20, c0_.product_id AS product_id_21 FROM client_product c0_ WHERE c0_.is_active = 1 AND c0_.client_id = ? AND c0_.start_at <= ? AND c0_.end_at > ? GROUP BY c0_.product_id
Parameters:
[
  1
  "2025-12-06 10:50:57"
  "2025-12-06 10:50:57"
]
6 0.45 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.rgpd_file AS rgpd_file_4, t0.description AS description_5, t0.baseline AS baseline_6, t0.background AS background_7, t0.alt_logo AS alt_logo_8, t0.is_active AS is_active_9, t0.created_at AS created_at_10, t0.modified_at AS modified_at_11, t0.slug AS slug_12, t0.salt AS salt_13, t0.main_color AS main_color_14, t0.secondary_color AS secondary_color_15, t0.is_secure AS is_secure_16, t0.is_hidden_job_title AS is_hidden_job_title_17, t0.is_hidden_user_job AS is_hidden_user_job_18, t0.label_location AS label_location_19, t0.label_sub_location AS label_sub_location_20, t0.has_microsoft AS has_microsoft_21, t0.has_zoom AS has_zoom_22 FROM client t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "public"
]
7 0.24 ms
SELECT c0_.id AS id_0, c0_.presentation AS presentation_1, c0_.logo AS logo_2, c0_.title AS title_3, c0_.start_at AS start_at_4, c0_.end_at AS end_at_5, c0_.created_at AS created_at_6, c0_.modified_at AS modified_at_7, c0_.is_active AS is_active_8, c0_.ending_presentation AS ending_presentation_9, c0_.invitation_email_content AS invitation_email_content_10, c0_.can_invite AS can_invite_11, c0_.forced_disabled AS forced_disabled_12, c0_.has_user_ladder AS has_user_ladder_13, c0_.has_location_ladder AS has_location_ladder_14, c0_.prize AS prize_15, c0_.baseline AS baseline_16, c0_.description AS description_17, c0_.text AS text_18, c0_.has_sub_location_ladder AS has_sub_location_ladder_19, c0_.client_id AS client_id_20, c0_.product_id AS product_id_21 FROM client_product c0_ WHERE c0_.is_active = 1 AND c0_.client_id = ? AND c0_.start_at <= ? AND c0_.end_at > ? GROUP BY c0_.product_id
Parameters:
[
  1
  "2025-12-06 10:50:57"
  "2025-12-06 10:50:57"
]
8 0.20 ms
SELECT c0_.id AS id_0, c0_.presentation AS presentation_1, c0_.logo AS logo_2, c0_.title AS title_3, c0_.start_at AS start_at_4, c0_.end_at AS end_at_5, c0_.created_at AS created_at_6, c0_.modified_at AS modified_at_7, c0_.is_active AS is_active_8, c0_.ending_presentation AS ending_presentation_9, c0_.invitation_email_content AS invitation_email_content_10, c0_.can_invite AS can_invite_11, c0_.forced_disabled AS forced_disabled_12, c0_.has_user_ladder AS has_user_ladder_13, c0_.has_location_ladder AS has_location_ladder_14, c0_.prize AS prize_15, c0_.baseline AS baseline_16, c0_.description AS description_17, c0_.text AS text_18, c0_.has_sub_location_ladder AS has_sub_location_ladder_19, c0_.client_id AS client_id_20, c0_.product_id AS product_id_21 FROM client_product c0_ WHERE c0_.is_active = 1 AND c0_.client_id = ? AND c0_.start_at <= ? AND c0_.end_at > ? GROUP BY c0_.product_id
Parameters:
[
  1
  "2025-12-06 10:50:57"
  "2025-12-06 10:50:57"
]
9 0.24 ms
SELECT t0.id AS id_1, t0.presentation AS presentation_2, t0.logo AS logo_3, t0.title AS title_4, t0.start_at AS start_at_5, t0.end_at AS end_at_6, t0.created_at AS created_at_7, t0.modified_at AS modified_at_8, t0.is_active AS is_active_9, t0.ending_presentation AS ending_presentation_10, t0.invitation_email_content AS invitation_email_content_11, t0.can_invite AS can_invite_12, t0.forced_disabled AS forced_disabled_13, t0.has_user_ladder AS has_user_ladder_14, t0.has_location_ladder AS has_location_ladder_15, t0.prize AS prize_16, t0.baseline AS baseline_17, t0.description AS description_18, t0.text AS text_19, t0.has_sub_location_ladder AS has_sub_location_ladder_20, t0.client_id AS client_id_21, t0.product_id AS product_id_22 FROM client_product t0 WHERE t0.client_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.

Entities Mapping

Class Mapping errors
App\Entity\Client No errors.
App\Entity\ClientProduct
  • The association App\Entity\ClientProduct#diagQuestions refers to the owning side field App\Entity\DiagQuestion#clientProduct which does not exist.
App\Entity\FlashWorkshop No errors.
App\Entity\FlashUserWorkshop No errors.
App\Entity\UserProduct No errors.
App\Entity\User No errors.
App\Entity\Location No errors.
App\Entity\SubLocation
  • The association App\Entity\SubLocation#defiQuestions refers to the owning side field App\Entity\DefiQuestion#deniedSubLocation which does not exist.
App\Entity\Domain No errors.
App\Entity\Job No errors.
App\Entity\Contact No errors.
App\Entity\Product No errors.
App\Entity\DefiSlide No errors.
App\Entity\DefiClientDocument No errors.
App\Entity\DiagQuestion No errors.
App\Entity\FlashWorkshopType No errors.
App\Entity\FlashTimeslot No errors.
App\Entity\Subject No errors.
App\Entity\DefiAnswerUser No errors.
App\Entity\Avatar No errors.
App\Entity\DiagAnswerUser No errors.
App\Entity\DefiQuestion No errors.
App\Entity\DefiSlideType No errors.
App\Entity\DiagAnswer No errors.
App\Entity\Category No errors.
App\Entity\DefiAnswer No errors.
App\Entity\DefiQuestionType No errors.
App\Entity\Disease No errors.