Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

1 Different statements

1.14 ms Query time

3 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	0.65 ms	SELECT t0.departure_city AS departure_city_1, t0.arrival_city AS arrival_city_2, t0.country AS country_3, t0.season AS season_4, t0.number AS number_5, t0.format AS format_6, t0.price AS price_7, t0.opening_date AS opening_date_8, t0.closing_date AS closing_date_9, t0.registration_counter AS registration_counter_10, t0.start_date AS start_date_11, t0.end_date AS end_date_12, t0.duration_in_days AS duration_in_days_13, t0.duration_in_hours AS duration_in_hours_14, t0.distance AS distance_15, t0.elevation AS elevation_16, t0.type AS type_17, t0.max_number_participant AS max_number_participant_18, t0.initial_number_participant AS initial_number_participant_19, t0.available_margin AS available_margin_20, t0.number_places AS number_places_21, t0.description AS description_22, t0.description_en AS description_en_23, t0.has_limiting_possibility AS has_limiting_possibility_24, t0.bloque_course AS bloque_course_25, t0.frais_transfert AS frais_transfert_26, t0.id AS id_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.logo_id AS logo_id_30, t0.cover_image_id AS cover_image_id_31, t0.contract_id AS contract_id_32, t0.manual_id AS manual_id_33, t0.contract_en_id AS contract_en_id_34, t0.manual_en_id AS manual_en_id_35, t0.company_id AS company_id_36, t0.created_by_id AS created_by_id_37 FROM course t0 WHERE t0.id IS NULL LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT t0.departure_city AS departure_city_1, t0.arrival_city AS arrival_city_2, t0.country AS country_3, t0.season AS season_4, t0.number AS number_5, t0.format AS format_6, t0.price AS price_7, t0.opening_date AS opening_date_8, t0.closing_date AS closing_date_9, t0.registration_counter AS registration_counter_10, t0.start_date AS start_date_11, t0.end_date AS end_date_12, t0.duration_in_days AS duration_in_days_13, t0.duration_in_hours AS duration_in_hours_14, t0.distance AS distance_15, t0.elevation AS elevation_16, t0.type AS type_17, t0.max_number_participant AS max_number_participant_18, t0.initial_number_participant AS initial_number_participant_19, t0.available_margin AS available_margin_20, t0.number_places AS number_places_21, t0.description AS description_22, t0.description_en AS description_en_23, t0.has_limiting_possibility AS has_limiting_possibility_24, t0.bloque_course AS bloque_course_25, t0.frais_transfert AS frais_transfert_26, t0.id AS id_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.logo_id AS logo_id_30, t0.cover_image_id AS cover_image_id_31, t0.contract_id AS contract_id_32, t0.manual_id AS manual_id_33, t0.contract_en_id AS contract_en_id_34, t0.manual_en_id AS manual_en_id_35, t0.company_id AS company_id_36, t0.created_by_id AS created_by_id_37 FROM course t0 WHERE t0.id IS NULL LIMIT 1 SELECT t0.departure_city AS departure_city_1, t0.arrival_city AS arrival_city_2, t0.country AS country_3, t0.season AS season_4, t0.number AS number_5, t0.format AS format_6, t0.price AS price_7, t0.opening_date AS opening_date_8, t0.closing_date AS closing_date_9, t0.registration_counter AS registration_counter_10, t0.start_date AS start_date_11, t0.end_date AS end_date_12, t0.duration_in_days AS duration_in_days_13, t0.duration_in_hours AS duration_in_hours_14, t0.distance AS distance_15, t0.elevation AS elevation_16, t0.type AS type_17, t0.max_number_participant AS max_number_participant_18, t0.initial_number_participant AS initial_number_participant_19, t0.available_margin AS available_margin_20, t0.number_places AS number_places_21, t0.description AS description_22, t0.description_en AS description_en_23, t0.has_limiting_possibility AS has_limiting_possibility_24, t0.bloque_course AS bloque_course_25, t0.frais_transfert AS frais_transfert_26, t0.id AS id_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.logo_id AS logo_id_30, t0.cover_image_id AS cover_image_id_31, t0.contract_id AS contract_id_32, t0.manual_id AS manual_id_33, t0.contract_en_id AS contract_en_id_34, t0.manual_en_id AS manual_en_id_35, t0.company_id AS company_id_36, t0.created_by_id AS created_by_id_37 FROM course t0 WHERE t0.id IS NULL LIMIT 1;
2	0.49 ms	SELECT t0.departure_city AS departure_city_1, t0.arrival_city AS arrival_city_2, t0.country AS country_3, t0.season AS season_4, t0.number AS number_5, t0.format AS format_6, t0.price AS price_7, t0.opening_date AS opening_date_8, t0.closing_date AS closing_date_9, t0.registration_counter AS registration_counter_10, t0.start_date AS start_date_11, t0.end_date AS end_date_12, t0.duration_in_days AS duration_in_days_13, t0.duration_in_hours AS duration_in_hours_14, t0.distance AS distance_15, t0.elevation AS elevation_16, t0.type AS type_17, t0.max_number_participant AS max_number_participant_18, t0.initial_number_participant AS initial_number_participant_19, t0.available_margin AS available_margin_20, t0.number_places AS number_places_21, t0.description AS description_22, t0.description_en AS description_en_23, t0.has_limiting_possibility AS has_limiting_possibility_24, t0.bloque_course AS bloque_course_25, t0.frais_transfert AS frais_transfert_26, t0.id AS id_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.logo_id AS logo_id_30, t0.cover_image_id AS cover_image_id_31, t0.contract_id AS contract_id_32, t0.manual_id AS manual_id_33, t0.contract_en_id AS contract_en_id_34, t0.manual_en_id AS manual_en_id_35, t0.company_id AS company_id_36, t0.created_by_id AS created_by_id_37 FROM course t0 WHERE t0.id IS NULL LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT t0.departure_city AS departure_city_1, t0.arrival_city AS arrival_city_2, t0.country AS country_3, t0.season AS season_4, t0.number AS number_5, t0.format AS format_6, t0.price AS price_7, t0.opening_date AS opening_date_8, t0.closing_date AS closing_date_9, t0.registration_counter AS registration_counter_10, t0.start_date AS start_date_11, t0.end_date AS end_date_12, t0.duration_in_days AS duration_in_days_13, t0.duration_in_hours AS duration_in_hours_14, t0.distance AS distance_15, t0.elevation AS elevation_16, t0.type AS type_17, t0.max_number_participant AS max_number_participant_18, t0.initial_number_participant AS initial_number_participant_19, t0.available_margin AS available_margin_20, t0.number_places AS number_places_21, t0.description AS description_22, t0.description_en AS description_en_23, t0.has_limiting_possibility AS has_limiting_possibility_24, t0.bloque_course AS bloque_course_25, t0.frais_transfert AS frais_transfert_26, t0.id AS id_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.logo_id AS logo_id_30, t0.cover_image_id AS cover_image_id_31, t0.contract_id AS contract_id_32, t0.manual_id AS manual_id_33, t0.contract_en_id AS contract_en_id_34, t0.manual_en_id AS manual_en_id_35, t0.company_id AS company_id_36, t0.created_by_id AS created_by_id_37 FROM course t0 WHERE t0.id IS NULL LIMIT 1 SELECT t0.departure_city AS departure_city_1, t0.arrival_city AS arrival_city_2, t0.country AS country_3, t0.season AS season_4, t0.number AS number_5, t0.format AS format_6, t0.price AS price_7, t0.opening_date AS opening_date_8, t0.closing_date AS closing_date_9, t0.registration_counter AS registration_counter_10, t0.start_date AS start_date_11, t0.end_date AS end_date_12, t0.duration_in_days AS duration_in_days_13, t0.duration_in_hours AS duration_in_hours_14, t0.distance AS distance_15, t0.elevation AS elevation_16, t0.type AS type_17, t0.max_number_participant AS max_number_participant_18, t0.initial_number_participant AS initial_number_participant_19, t0.available_margin AS available_margin_20, t0.number_places AS number_places_21, t0.description AS description_22, t0.description_en AS description_en_23, t0.has_limiting_possibility AS has_limiting_possibility_24, t0.bloque_course AS bloque_course_25, t0.frais_transfert AS frais_transfert_26, t0.id AS id_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.logo_id AS logo_id_30, t0.cover_image_id AS cover_image_id_31, t0.contract_id AS contract_id_32, t0.manual_id AS manual_id_33, t0.contract_en_id AS contract_en_id_34, t0.manual_en_id AS manual_en_id_35, t0.company_id AS company_id_36, t0.created_by_id AS created_by_id_37 FROM course t0 WHERE t0.id IS NULL LIMIT 1;

#▲

Time

Info

0.65 ms

SELECT t0.departure_city AS departure_city_1, t0.arrival_city AS arrival_city_2, t0.country AS country_3, t0.season AS season_4, t0.number AS number_5, t0.format AS format_6, t0.price AS price_7, t0.opening_date AS opening_date_8, t0.closing_date AS closing_date_9, t0.registration_counter AS registration_counter_10, t0.start_date AS start_date_11, t0.end_date AS end_date_12, t0.duration_in_days AS duration_in_days_13, t0.duration_in_hours AS duration_in_hours_14, t0.distance AS distance_15, t0.elevation AS elevation_16, t0.type AS type_17, t0.max_number_participant AS max_number_participant_18, t0.initial_number_participant AS initial_number_participant_19, t0.available_margin AS available_margin_20, t0.number_places AS number_places_21, t0.description AS description_22, t0.description_en AS description_en_23, t0.has_limiting_possibility AS has_limiting_possibility_24, t0.bloque_course AS bloque_course_25, t0.frais_transfert AS frais_transfert_26, t0.id AS id_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.logo_id AS logo_id_30, t0.cover_image_id AS cover_image_id_31, t0.contract_id AS contract_id_32, t0.manual_id AS manual_id_33, t0.contract_en_id AS contract_en_id_34, t0.manual_en_id AS manual_en_id_35, t0.company_id AS company_id_36, t0.created_by_id AS created_by_id_37 FROM course t0 WHERE t0.id IS NULL LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  t0.departure_city AS departure_city_1,
  t0.arrival_city AS arrival_city_2,
  t0.country AS country_3,
  t0.season AS season_4,
  t0.number AS number_5,
  t0.format AS format_6,
  t0.price AS price_7,
  t0.opening_date AS opening_date_8,
  t0.closing_date AS closing_date_9,
  t0.registration_counter AS registration_counter_10,
  t0.start_date AS start_date_11,
  t0.end_date AS end_date_12,
  t0.duration_in_days AS duration_in_days_13,
  t0.duration_in_hours AS duration_in_hours_14,
  t0.distance AS distance_15,
  t0.elevation AS elevation_16,
  t0.type AS type_17,
  t0.max_number_participant AS max_number_participant_18,
  t0.initial_number_participant AS initial_number_participant_19,
  t0.available_margin AS available_margin_20,
  t0.number_places AS number_places_21,
  t0.description AS description_22,
  t0.description_en AS description_en_23,
  t0.has_limiting_possibility AS has_limiting_possibility_24,
  t0.bloque_course AS bloque_course_25,
  t0.frais_transfert AS frais_transfert_26,
  t0.id AS id_27,
  t0.created_at AS created_at_28,
  t0.updated_at AS updated_at_29,
  t0.logo_id AS logo_id_30,
  t0.cover_image_id AS cover_image_id_31,
  t0.contract_id AS contract_id_32,
  t0.manual_id AS manual_id_33,
  t0.contract_en_id AS contract_en_id_34,
  t0.manual_en_id AS manual_en_id_35,
  t0.company_id AS company_id_36,
  t0.created_by_id AS created_by_id_37
FROM
  course t0
WHERE
  t0.id IS NULL
LIMIT
  1

SELECT t0.departure_city AS departure_city_1, t0.arrival_city AS arrival_city_2, t0.country AS country_3, t0.season AS season_4, t0.number AS number_5, t0.format AS format_6, t0.price AS price_7, t0.opening_date AS opening_date_8, t0.closing_date AS closing_date_9, t0.registration_counter AS registration_counter_10, t0.start_date AS start_date_11, t0.end_date AS end_date_12, t0.duration_in_days AS duration_in_days_13, t0.duration_in_hours AS duration_in_hours_14, t0.distance AS distance_15, t0.elevation AS elevation_16, t0.type AS type_17, t0.max_number_participant AS max_number_participant_18, t0.initial_number_participant AS initial_number_participant_19, t0.available_margin AS available_margin_20, t0.number_places AS number_places_21, t0.description AS description_22, t0.description_en AS description_en_23, t0.has_limiting_possibility AS has_limiting_possibility_24, t0.bloque_course AS bloque_course_25, t0.frais_transfert AS frais_transfert_26, t0.id AS id_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.logo_id AS logo_id_30, t0.cover_image_id AS cover_image_id_31, t0.contract_id AS contract_id_32, t0.manual_id AS manual_id_33, t0.contract_en_id AS contract_en_id_34, t0.manual_en_id AS manual_en_id_35, t0.company_id AS company_id_36, t0.created_by_id AS created_by_id_37 FROM course t0 WHERE t0.id IS NULL LIMIT 1;

0.49 ms

SELECT t0.departure_city AS departure_city_1, t0.arrival_city AS arrival_city_2, t0.country AS country_3, t0.season AS season_4, t0.number AS number_5, t0.format AS format_6, t0.price AS price_7, t0.opening_date AS opening_date_8, t0.closing_date AS closing_date_9, t0.registration_counter AS registration_counter_10, t0.start_date AS start_date_11, t0.end_date AS end_date_12, t0.duration_in_days AS duration_in_days_13, t0.duration_in_hours AS duration_in_hours_14, t0.distance AS distance_15, t0.elevation AS elevation_16, t0.type AS type_17, t0.max_number_participant AS max_number_participant_18, t0.initial_number_participant AS initial_number_participant_19, t0.available_margin AS available_margin_20, t0.number_places AS number_places_21, t0.description AS description_22, t0.description_en AS description_en_23, t0.has_limiting_possibility AS has_limiting_possibility_24, t0.bloque_course AS bloque_course_25, t0.frais_transfert AS frais_transfert_26, t0.id AS id_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.logo_id AS logo_id_30, t0.cover_image_id AS cover_image_id_31, t0.contract_id AS contract_id_32, t0.manual_id AS manual_id_33, t0.contract_en_id AS contract_en_id_34, t0.manual_en_id AS manual_en_id_35, t0.company_id AS company_id_36, t0.created_by_id AS created_by_id_37 FROM course t0 WHERE t0.id IS NULL LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  t0.departure_city AS departure_city_1,
  t0.arrival_city AS arrival_city_2,
  t0.country AS country_3,
  t0.season AS season_4,
  t0.number AS number_5,
  t0.format AS format_6,
  t0.price AS price_7,
  t0.opening_date AS opening_date_8,
  t0.closing_date AS closing_date_9,
  t0.registration_counter AS registration_counter_10,
  t0.start_date AS start_date_11,
  t0.end_date AS end_date_12,
  t0.duration_in_days AS duration_in_days_13,
  t0.duration_in_hours AS duration_in_hours_14,
  t0.distance AS distance_15,
  t0.elevation AS elevation_16,
  t0.type AS type_17,
  t0.max_number_participant AS max_number_participant_18,
  t0.initial_number_participant AS initial_number_participant_19,
  t0.available_margin AS available_margin_20,
  t0.number_places AS number_places_21,
  t0.description AS description_22,
  t0.description_en AS description_en_23,
  t0.has_limiting_possibility AS has_limiting_possibility_24,
  t0.bloque_course AS bloque_course_25,
  t0.frais_transfert AS frais_transfert_26,
  t0.id AS id_27,
  t0.created_at AS created_at_28,
  t0.updated_at AS updated_at_29,
  t0.logo_id AS logo_id_30,
  t0.cover_image_id AS cover_image_id_31,
  t0.contract_id AS contract_id_32,
  t0.manual_id AS manual_id_33,
  t0.contract_en_id AS contract_en_id_34,
  t0.manual_en_id AS manual_en_id_35,
  t0.company_id AS company_id_36,
  t0.created_by_id AS created_by_id_37
FROM
  course t0
WHERE
  t0.id IS NULL
LIMIT
  1

SELECT t0.departure_city AS departure_city_1, t0.arrival_city AS arrival_city_2, t0.country AS country_3, t0.season AS season_4, t0.number AS number_5, t0.format AS format_6, t0.price AS price_7, t0.opening_date AS opening_date_8, t0.closing_date AS closing_date_9, t0.registration_counter AS registration_counter_10, t0.start_date AS start_date_11, t0.end_date AS end_date_12, t0.duration_in_days AS duration_in_days_13, t0.duration_in_hours AS duration_in_hours_14, t0.distance AS distance_15, t0.elevation AS elevation_16, t0.type AS type_17, t0.max_number_participant AS max_number_participant_18, t0.initial_number_participant AS initial_number_participant_19, t0.available_margin AS available_margin_20, t0.number_places AS number_places_21, t0.description AS description_22, t0.description_en AS description_en_23, t0.has_limiting_possibility AS has_limiting_possibility_24, t0.bloque_course AS bloque_course_25, t0.frais_transfert AS frais_transfert_26, t0.id AS id_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.logo_id AS logo_id_30, t0.cover_image_id AS cover_image_id_31, t0.contract_id AS contract_id_32, t0.manual_id AS manual_id_33, t0.contract_en_id AS contract_en_id_34, t0.manual_en_id AS manual_en_id_35, t0.company_id AS company_id_36, t0.created_by_id AS created_by_id_37 FROM course t0 WHERE t0.id IS NULL LIMIT 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\Notification\Notification	No errors.
App\Entity\Document\Document	No errors.
App\Entity\Course\Course	No errors.
App\Entity\Course\CourseUserTransfert	The mappings App\Entity\Course\CourseUserTransfert#oldCourse and App\Entity\Course\Course#courseUserSubscriptions are inconsistent with each other. The mappings App\Entity\Course\CourseUserTransfert#newCourse and App\Entity\Course\Course#courseUserSubscriptions are inconsistent with each other.
App\Entity\Course\CourseUserSubscription	The association App\Entity\Course\CourseUserSubscription#code refers to the inverse side field App\Entity\Promo\Code#courseUserSubscriptions which does not exist.
App\Entity\User\User	No errors.
App\Entity\User\Participant	No errors.
App\Entity\Facture\Facture	No errors.
App\Entity\Promo\Code	No errors.
App\Entity\Media\Media	No errors.
App\Entity\Media\Image	No errors.
App\Entity\Company\Company	The association App\Entity\Company\Company#organizer refers to the inverse side field App\Entity\User\Organizer#Company which does not exist.

Symfony Profiler

https://bikingman.bees-solution.com/fr/course/get_course_detail

Configuration Settings

Theme