Query Metrics
9
Database Queries
7
Different statements
42.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
22.56 ms (52.85%) |
1 |
SELECT r0_.id AS id_0, r0_.quotation_reference AS quotation_reference_1, r0_.state AS state_2, r0_.address_label AS address_label_3, r0_.address_complement AS address_complement_4, r0_.address_zip_code AS address_zip_code_5, r0_.reservation_date AS reservation_date_6, r0_.ip_client AS ip_client_7, r0_.visio_link AS visio_link_8, r0_.reserved_date AS reserved_date_9, r0_.reserved_hour AS reserved_hour_10, r0_.end_date AS end_date_11, r0_.billing_date AS billing_date_12, r0_.end_hour AS end_hour_13, r0_.comments AS comments_14, r0_.booked_by_full_name AS booked_by_full_name_15, r0_.no_subject_to_translate AS no_subject_to_translate_16, r0_.no_interpreter AS no_interpreter_17, r0_.price AS price_18, r0_.price_ttc AS price_ttc_19, r0_.interpreter_price AS interpreter_price_20, r0_.interpreter_package AS interpreter_package_21, r0_.payment_mode AS payment_mode_22, r0_.ended_date AS ended_date_23, r0_.created_from_front AS created_from_front_24, r0_.closed_from_front AS closed_from_front_25, r0_.nb_pages AS nb_pages_26, r0_.nb_words AS nb_words_27, r0_.minute_number AS minute_number_28, r0_.message AS message_29, r0_.phone_package AS phone_package_30, r0_.training_package AS training_package_31, r0_.transcription_package AS transcription_package_32, r0_.translation_package AS translation_package_33, r0_.tva AS tva_34, r0_.is_tva AS is_tva_35, r0_.kilometric_cost AS kilometric_cost_36, r0_.parking_cost AS parking_cost_37, r0_.food_cost AS food_cost_38, r0_.housing_cost AS housing_cost_39, r0_.discount_amount_percentage AS discount_amount_percentage_40, r0_.send_invoice_by_mail AS send_invoice_by_mail_41, r0_.apply_additional_fees AS apply_additional_fees_42, r0_.apply_discount AS apply_discount_43, p1_.id AS id_44, p1_.name AS name_45, p1_.is_approved AS is_approved_46, p1_.is_filled AS is_filled_47, p1_.siren AS siren_48, p1_.customer_email AS customer_email_49, p1_.referent_function AS referent_function_50, p1_.accounting_email AS accounting_email_51, p1_.accounting_phone AS accounting_phone_52, i2_.id AS id_53, i2_.is_approved AS is_approved_54, i2_.is_filled AS is_filled_55, a3_.id AS id_56, a3_.address_label AS address_label_57, a3_.town AS town_58, a3_.address_complement AS address_complement_59, a3_.postal_code AS postal_code_60, a3_.country AS country_61, p4_.id AS id_62, p4_.label AS label_63, p4_.description AS description_64, a5_.id AS id_65, a5_.address_label AS address_label_66, a5_.town AS town_67, a5_.address_complement AS address_complement_68, a5_.postal_code AS postal_code_69, a5_.country AS country_70, i6_.id AS id_71, i6_.birthdate AS birthdate_72, i6_.hire_date AS hire_date_73, i6_.birth_place AS birth_place_74, i6_.gender AS gender_75, i6_.is_conveyed AS is_conveyed_76, i6_.hourly_rate AS hourly_rate_77, i6_.is_approved AS is_approved_78, i6_.rate_by_word AS rate_by_word_79, i6_.rate_by_page AS rate_by_page_80, i6_.is_self_employed AS is_self_employed_81, i6_.siren_number AS siren_number_82, i6_.is_filled AS is_filled_83, i6_.is_sworn_in AS is_sworn_in_84, i6_.comments AS comments_85, i6_.languages AS languages_86, u7_.username AS username_87, u7_.username_canonical AS username_canonical_88, u7_.email AS email_89, u7_.email_canonical AS email_canonical_90, u7_.enabled AS enabled_91, u7_.salt AS salt_92, u7_.password AS password_93, u7_.last_login AS last_login_94, u7_.confirmation_token AS confirmation_token_95, u7_.password_requested_at AS password_requested_at_96, u7_.roles AS roles_97, u7_.id AS id_98, u7_.firstname AS firstname_99, u7_.lastname AS lastname_100, u7_.phone_number AS phone_number_101, a8_.id AS id_102, a8_.address_label AS address_label_103, a8_.town AS town_104, a8_.address_complement AS address_complement_105, a8_.postal_code AS postal_code_106, a8_.country AS country_107, i9_.id AS id_108, i9_.file_name AS file_name_109, i9_.file_size AS file_size_110, i9_.updated_at AS updated_at_111, i10_.id AS id_112, i10_.label AS label_113, r11_.id AS id_114, r11_.label AS label_115, r11_.description AS description_116, r11_.is_reservable_for_many_days AS is_reservable_for_many_days_117, l12_.id AS id_118, l12_.label AS label_119, l12_.country AS country_120, l13_.id AS id_121, l13_.label AS label_122, l13_.delay_in_days AS delay_in_days_123, l14_.id AS id_124, l14_.label AS label_125, l14_.country AS country_126, l15_.id AS id_127, l15_.label AS label_128, l15_.delay_in_days AS delay_in_days_129, p16_.id AS id_130, p16_.pricing_mode AS pricing_mode_131, p16_.price_in_euros AS price_in_euros_132, p17_.id AS id_133, p17_.label AS label_134, p17_.icon AS icon_135, r18_.id AS id_136, r18_.file_name AS file_name_137, r18_.file_size AS file_size_138, r18_.updated_at AS updated_at_139, u19_.username AS username_140, u19_.username_canonical AS username_canonical_141, u19_.email AS email_142, u19_.email_canonical AS email_canonical_143, u19_.enabled AS enabled_144, u19_.salt AS salt_145, u19_.password AS password_146, u19_.last_login AS last_login_147, u19_.confirmation_token AS confirmation_token_148, u19_.password_requested_at AS password_requested_at_149, u19_.roles AS roles_150, u19_.id AS id_151, u19_.firstname AS firstname_152, u19_.lastname AS lastname_153, u19_.phone_number AS phone_number_154, u20_.username AS username_155, u20_.username_canonical AS username_canonical_156, u20_.email AS email_157, u20_.email_canonical AS email_canonical_158, u20_.enabled AS enabled_159, u20_.salt AS salt_160, u20_.password AS password_161, u20_.last_login AS last_login_162, u20_.confirmation_token AS confirmation_token_163, u20_.password_requested_at AS password_requested_at_164, u20_.roles AS roles_165, u20_.id AS id_166, u20_.firstname AS firstname_167, u20_.lastname AS lastname_168, u20_.phone_number AS phone_number_169, u21_.username AS username_170, u21_.username_canonical AS username_canonical_171, u21_.email AS email_172, u21_.email_canonical AS email_canonical_173, u21_.enabled AS enabled_174, u21_.salt AS salt_175, u21_.password AS password_176, u21_.last_login AS last_login_177, u21_.confirmation_token AS confirmation_token_178, u21_.password_requested_at AS password_requested_at_179, u21_.roles AS roles_180, u21_.id AS id_181, u21_.firstname AS firstname_182, u21_.lastname AS lastname_183, u21_.phone_number AS phone_number_184, r0_.individual_customer_id AS individual_customer_id_185, r0_.professional_customer_id AS professional_customer_id_186, r0_.interpreter_id AS interpreter_id_187, r0_.reservation_type_id AS reservation_type_id_188, r0_.language_to_translate AS language_to_translate_189, r0_.target_language AS target_language_190, r0_.pricing_id AS pricing_id_191, r0_.created_by AS created_by_192, r0_.ended_by_id AS ended_by_id_193, r0_.validated_by_id AS validated_by_id_194, p1_.client_type AS client_type_195, p1_.address_id AS address_id_196, p1_.user_id AS user_id_197, i2_.address_id AS address_id_198, i2_.user_id AS user_id_199, i6_.user_id AS user_id_200, i6_.address_id AS address_id_201, i9_.file_type_id AS file_type_id_202, i9_.interpreter_id AS interpreter_id_203, l12_.frequency_id AS frequency_id_204, l14_.frequency_id AS frequency_id_205, p16_.pricing_type_id AS pricing_type_id_206, r18_.reservation_id AS reservation_id_207 FROM reservation r0_ INNER JOIN professional_customer p1_ ON r0_.professional_customer_id = p1_.id LEFT JOIN individual_customer i2_ ON r0_.individual_customer_id = i2_.id LEFT JOIN address a3_ ON i2_.address_id = a3_.id LEFT JOIN professional_customer_type p4_ ON p1_.client_type = p4_.id LEFT JOIN address a5_ ON p1_.address_id = a5_.id LEFT JOIN interpreter i6_ ON r0_.interpreter_id = i6_.id LEFT JOIN users u7_ ON i6_.user_id = u7_.id LEFT JOIN address a8_ ON i6_.address_id = a8_.id LEFT JOIN interpreter_file i9_ ON i6_.id = i9_.interpreter_id LEFT JOIN interpreter_file_type i10_ ON i9_.file_type_id = i10_.id LEFT JOIN reservation_type r11_ ON r0_.reservation_type_id = r11_.id LEFT JOIN language l12_ ON r0_.language_to_translate = l12_.id LEFT JOIN language_frequency l13_ ON l12_.frequency_id = l13_.id LEFT JOIN language l14_ ON r0_.target_language = l14_.id LEFT JOIN language_frequency l15_ ON l14_.frequency_id = l15_.id LEFT JOIN pricing p16_ ON r0_.pricing_id = p16_.id LEFT JOIN pricing_type p17_ ON p16_.pricing_type_id = p17_.id LEFT JOIN reservation_file r18_ ON r0_.id = r18_.reservation_id INNER JOIN users u19_ ON r0_.created_by = u19_.id LEFT JOIN users u20_ ON r0_.ended_by_id = u20_.id LEFT JOIN users u21_ ON r0_.validated_by_id = u21_.id WHERE r0_.id IN (SELECT r22_.id FROM reservation r22_ INNER JOIN professional_customer p23_ ON r22_.professional_customer_id = p23_.id WHERE p23_.id = ? AND r22_.state = ? AND r22_.reserved_date <= ? AND r22_.reserved_date >= ?) AND r0_.id IN (?) ORDER BY r0_.id ASC
Parameters:
[ "1" "VALIDATED" "2025-12-17" "2025-12-17" 2 ] |
|
8.13 ms (19.06%) |
1 |
SELECT count(DISTINCT r0_.id) AS sclr_0 FROM reservation r0_ INNER JOIN professional_customer p1_ ON r0_.professional_customer_id = p1_.id LEFT JOIN individual_customer i2_ ON r0_.individual_customer_id = i2_.id LEFT JOIN address a3_ ON i2_.address_id = a3_.id LEFT JOIN professional_customer_type p4_ ON p1_.client_type = p4_.id LEFT JOIN address a5_ ON p1_.address_id = a5_.id LEFT JOIN interpreter i6_ ON r0_.interpreter_id = i6_.id LEFT JOIN users u7_ ON i6_.user_id = u7_.id LEFT JOIN address a8_ ON i6_.address_id = a8_.id LEFT JOIN interpreter_file i9_ ON i6_.id = i9_.interpreter_id LEFT JOIN interpreter_file_type i10_ ON i9_.file_type_id = i10_.id LEFT JOIN reservation_type r11_ ON r0_.reservation_type_id = r11_.id LEFT JOIN language l12_ ON r0_.language_to_translate = l12_.id LEFT JOIN language_frequency l13_ ON l12_.frequency_id = l13_.id LEFT JOIN language l14_ ON r0_.target_language = l14_.id LEFT JOIN language_frequency l15_ ON l14_.frequency_id = l15_.id LEFT JOIN pricing p16_ ON r0_.pricing_id = p16_.id LEFT JOIN pricing_type p17_ ON p16_.pricing_type_id = p17_.id LEFT JOIN reservation_file r18_ ON r0_.id = r18_.reservation_id INNER JOIN users u19_ ON r0_.created_by = u19_.id LEFT JOIN users u20_ ON r0_.ended_by_id = u20_.id LEFT JOIN users u21_ ON r0_.validated_by_id = u21_.id WHERE r0_.id IN (SELECT r22_.id FROM reservation r22_ INNER JOIN professional_customer p23_ ON r22_.professional_customer_id = p23_.id WHERE p23_.id = ? AND r22_.state = ? AND r22_.reserved_date <= ? AND r22_.reserved_date >= ?)
Parameters:
[ "1" "VALIDATED" "2025-12-17" "2025-12-17" ] |
|
5.25 ms (12.31%) |
1 |
SELECT DISTINCT r0_.id AS id_0, r0_.id AS id_1 FROM reservation r0_ INNER JOIN professional_customer p1_ ON r0_.professional_customer_id = p1_.id LEFT JOIN individual_customer i2_ ON r0_.individual_customer_id = i2_.id LEFT JOIN address a3_ ON i2_.address_id = a3_.id LEFT JOIN professional_customer_type p4_ ON p1_.client_type = p4_.id LEFT JOIN address a5_ ON p1_.address_id = a5_.id LEFT JOIN interpreter i6_ ON r0_.interpreter_id = i6_.id LEFT JOIN users u7_ ON i6_.user_id = u7_.id LEFT JOIN address a8_ ON i6_.address_id = a8_.id LEFT JOIN interpreter_file i9_ ON i6_.id = i9_.interpreter_id LEFT JOIN interpreter_file_type i10_ ON i9_.file_type_id = i10_.id LEFT JOIN reservation_type r11_ ON r0_.reservation_type_id = r11_.id LEFT JOIN language l12_ ON r0_.language_to_translate = l12_.id LEFT JOIN language_frequency l13_ ON l12_.frequency_id = l13_.id LEFT JOIN language l14_ ON r0_.target_language = l14_.id LEFT JOIN language_frequency l15_ ON l14_.frequency_id = l15_.id LEFT JOIN pricing p16_ ON r0_.pricing_id = p16_.id LEFT JOIN pricing_type p17_ ON p16_.pricing_type_id = p17_.id LEFT JOIN reservation_file r18_ ON r0_.id = r18_.reservation_id INNER JOIN users u19_ ON r0_.created_by = u19_.id LEFT JOIN users u20_ ON r0_.ended_by_id = u20_.id LEFT JOIN users u21_ ON r0_.validated_by_id = u21_.id WHERE r0_.id IN (SELECT r22_.id FROM reservation r22_ INNER JOIN professional_customer p23_ ON r22_.professional_customer_id = p23_.id WHERE p23_.id = ? AND r22_.state = ? AND r22_.reserved_date <= ? AND r22_.reserved_date >= ?) ORDER BY r0_.id ASC LIMIT 30
Parameters:
[ "1" "VALIDATED" "2025-12-17" "2025-12-17" ] |
|
4.49 ms (10.53%) |
1 |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.firstname AS firstname_13, t0.lastname AS lastname_14, t0.phone_number AS phone_number_15, t16.id AS id_17, t16.birthdate AS birthdate_18, t16.hire_date AS hire_date_19, t16.birth_place AS birth_place_20, t16.gender AS gender_21, t16.is_conveyed AS is_conveyed_22, t16.hourly_rate AS hourly_rate_23, t16.is_approved AS is_approved_24, t16.rate_by_word AS rate_by_word_25, t16.rate_by_page AS rate_by_page_26, t16.is_self_employed AS is_self_employed_27, t16.siren_number AS siren_number_28, t16.is_filled AS is_filled_29, t16.is_sworn_in AS is_sworn_in_30, t16.comments AS comments_31, t16.languages AS languages_32, t16.user_id AS user_id_33, t16.address_id AS address_id_34, t35.id AS id_36, t35.is_approved AS is_approved_37, t35.is_filled AS is_filled_38, t35.address_id AS address_id_39, t35.user_id AS user_id_40, t41.id AS id_42, t41.name AS name_43, t41.is_approved AS is_approved_44, t41.is_filled AS is_filled_45, t41.siren AS siren_46, t41.customer_email AS customer_email_47, t41.referent_function AS referent_function_48, t41.accounting_email AS accounting_email_49, t41.accounting_phone AS accounting_phone_50, t41.client_type AS client_type_51, t41.address_id AS address_id_52, t41.user_id AS user_id_53 FROM users t0 LEFT JOIN interpreter t16 ON t16.user_id = t0.id LEFT JOIN individual_customer t35 ON t35.user_id = t0.id LEFT JOIN professional_customer t41 ON t41.user_id = t0.id WHERE t0.username_canonical = ? LIMIT 1
Parameters:
[
"ema@sprene.fr"
]
|
|
1.11 ms (2.60%) |
2 |
SELECT t0.id AS id_1, t0.is_approved AS is_approved_2, t0.is_filled AS is_filled_3, t0.address_id AS address_id_4, t0.user_id AS user_id_5 FROM individual_customer t0 WHERE t0.user_id = ?
Parameters:
[
6
]
|
|
0.75 ms (1.76%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_approved AS is_approved_3, t0.is_filled AS is_filled_4, t0.siren AS siren_5, t0.customer_email AS customer_email_6, t0.referent_function AS referent_function_7, t0.accounting_email AS accounting_email_8, t0.accounting_phone AS accounting_phone_9, t0.client_type AS client_type_10, t0.address_id AS address_id_11, t0.user_id AS user_id_12 FROM professional_customer t0 WHERE t0.user_id = ?
Parameters:
[
6
]
|
|
0.38 ms (0.90%) |
1 |
SELECT t0.id AS id_1, t0.birthdate AS birthdate_2, t0.hire_date AS hire_date_3, t0.birth_place AS birth_place_4, t0.gender AS gender_5, t0.is_conveyed AS is_conveyed_6, t0.hourly_rate AS hourly_rate_7, t0.is_approved AS is_approved_8, t0.rate_by_word AS rate_by_word_9, t0.rate_by_page AS rate_by_page_10, t0.is_self_employed AS is_self_employed_11, t0.siren_number AS siren_number_12, t0.is_filled AS is_filled_13, t0.is_sworn_in AS is_sworn_in_14, t0.comments AS comments_15, t0.languages AS languages_16, t0.user_id AS user_id_17, t0.address_id AS address_id_18 FROM interpreter t0 WHERE t0.user_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\Reservation | No errors. |
| App\Entity\IndividualCustomer | No errors. |
| App\Entity\ProfessionalCustomer | No errors. |
| App\Entity\Interpreter | No errors. |
| App\Entity\ReservationType | No errors. |
| App\Entity\Language | No errors. |
| App\Entity\Pricing | No errors. |
| FOS\UserBundle\Model\User | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Address | No errors. |
| App\Entity\ProfessionalCustomerType | No errors. |
| App\Entity\Bill | No errors. |
| App\Entity\InterpreterFile | No errors. |
| App\Entity\InterpreterFileType | No errors. |
| App\Entity\LanguageFrequency | No errors. |
| App\Entity\PricingType | No errors. |
| App\Entity\ReservationFile | No errors. |
| App\Entity\Exchange | No errors. |