Symfony Profiler

Query Metrics

26 Database Queries

17 Different statements

21.66 ms Query time

3 Invalid entities

40 Managed entities

Queries


SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.contact_phone_number AS contact_phone_number_13, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15, t0.account_verification_required AS account_verification_required_16, t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17, t0.default_locale_id AS default_locale_id_18, t19.code AS code_20, t19.created_at AS created_at_21, t19.updated_at AS updated_at_22, t19.id AS id_23, t0.base_currency_id AS base_currency_id_24, t25.code AS code_26, t25.created_at AS created_at_27, t25.updated_at AS updated_at_28, t25.id AS id_29, t0.default_tax_zone_id AS default_tax_zone_id_30, t0.menu_taxon_id AS menu_taxon_id_31, t0.shop_billing_data_id AS shop_billing_data_id_32, t0.channel_price_history_config_id AS channel_price_history_config_id_33 FROM sylius_channel t0 INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id WHERE t0.hostname = ? AND t0.enabled = ? ORDER BY t0.id ASC LIMIT 1
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM sylius_locale t0 INNER JOIN sylius_channel_locales ON t0.id = sylius_channel_locales.locale_id WHERE sylius_channel_locales.channel_id = ?
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.enabled AS enabled_3, t0.salt AS salt_4, t0.password AS password_5, t0.encoder_name AS encoder_name_6, t0.last_login AS last_login_7, t0.password_reset_token AS password_reset_token_8, t0.password_requested_at AS password_requested_at_9, t0.email_verification_token AS email_verification_token_10, t0.verified_at AS verified_at_11, t0.locked AS locked_12, t0.expires_at AS expires_at_13, t0.credentials_expire_at AS credentials_expire_at_14, t0.roles AS roles_15, t0.email AS email_16, t0.email_canonical AS email_canonical_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.id AS id_20, t0.login_token AS login_token_21, t0.tutor_id AS tutor_id_22, t0.customer_id AS customer_id_23 FROM sylius_shop_user t0 WHERE t0.id = ?
SELECT e0_.id AS id_0, e0_.number AS number_1, e0_.student_id AS student_id_2, e0_.disponibility_id AS disponibility_id_3 FROM exit_number e0_ INNER JOIN disponibility d1_ ON e0_.disponibility_id = d1_.id WHERE e0_.student_id = ? ORDER BY d1_.start ASC, e0_.id ASC
SELECT d0_.id AS id_0, d0_.start AS start_1, d0_.end AS end_2, d0_.public AS public_3, d0_.reserved AS reserved_4, d0_.double_exit AS double_exit_5, d0_.pause AS pause_6, d0_.exit_number AS exit_number_7, d0_.id_calendar AS id_calendar_8, d0_.instructorName AS instructorName_9, d0_.note AS note_10, d0_.studentName AS studentName_11, d0_.shopUser_id AS shopUser_id_12, d0_.student_id AS student_id_13, d0_.taxon_id AS taxon_id_14, d0_.pickup_point_id AS pickup_point_id_15, d0_.disponibility_id AS disponibility_id_16, d0_.disponibility_id AS disponibility_id_17, d0_.disponibility_id AS disponibility_id_18, d0_.disponibility_id AS disponibility_id_19, d0_.disponibility_id AS disponibility_id_20, d0_.disponibility_id AS disponibility_id_21, d0_.disponibility_id AS disponibility_id_22, d0_.disponibility_id AS disponibility_id_23, d0_.disponibility_id AS disponibility_id_24, d0_.disponibility_id AS disponibility_id_25, d0_.disponibility_id AS disponibility_id_26, d0_.disponibility_id AS disponibility_id_27, d0_.disponibility_id AS disponibility_id_28, d0_.disponibility_id AS disponibility_id_29, d0_.disponibility_id AS disponibility_id_30 FROM disponibility d0_ INNER JOIN student_disponibility s2_ ON d0_.id = s2_.disponibility_id INNER JOIN sylius_shop_user s1_ ON s1_.id = s2_.student_id AND (s1_.id = ?) WHERE d0_.start > ? ORDER BY d0_.start ASC, d0_.id ASC
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.enabled AS enabled_3, t0.salt AS salt_4, t0.password AS password_5, t0.encoder_name AS encoder_name_6, t0.last_login AS last_login_7, t0.password_reset_token AS password_reset_token_8, t0.password_requested_at AS password_requested_at_9, t0.email_verification_token AS email_verification_token_10, t0.verified_at AS verified_at_11, t0.locked AS locked_12, t0.expires_at AS expires_at_13, t0.credentials_expire_at AS credentials_expire_at_14, t0.roles AS roles_15, t0.email AS email_16, t0.email_canonical AS email_canonical_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.id AS id_20, t0.login_token AS login_token_21, t0.tutor_id AS tutor_id_22, t0.customer_id AS customer_id_23 FROM sylius_shop_user t0 INNER JOIN student_disponibility ON t0.id = student_disponibility.student_id WHERE student_disponibility.disponibility_id = ?
SELECT e0_.number AS number_0 FROM exit_number e0_ WHERE e0_.student_id = ? AND e0_.disponibility_id = ? ORDER BY e0_.id ASC LIMIT 1
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.enabled AS enabled_3, t0.salt AS salt_4, t0.password AS password_5, t0.encoder_name AS encoder_name_6, t0.last_login AS last_login_7, t0.password_reset_token AS password_reset_token_8, t0.password_requested_at AS password_requested_at_9, t0.email_verification_token AS email_verification_token_10, t0.verified_at AS verified_at_11, t0.locked AS locked_12, t0.expires_at AS expires_at_13, t0.credentials_expire_at AS credentials_expire_at_14, t0.roles AS roles_15, t0.email AS email_16, t0.email_canonical AS email_canonical_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.id AS id_20, t0.login_token AS login_token_21, t0.tutor_id AS tutor_id_22, t0.customer_id AS customer_id_23 FROM sylius_shop_user t0 WHERE t0.id = ?
SELECT t0.email AS email_1, t0.email_canonical AS email_canonical_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.birthday AS birthday_5, t0.gender AS gender_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.phone_number AS phone_number_9, t0.subscribed_to_newsletter AS subscribed_to_newsletter_10, t0.id AS id_11, t0.tutorname AS tutorname_12, t0.tutoremail AS tutoremail_13, t0.permitnumber AS permitnumber_14, t0.secondary_phone_number AS secondary_phone_number_15, t0.pathprofilpic AS pathprofilpic_16, t0.bookAuthorization AS bookAuthorization_17, t0.customer_group_id AS customer_group_id_18, t0.default_address_id AS default_address_id_19, t20.username AS username_21, t20.username_canonical AS username_canonical_22, t20.enabled AS enabled_23, t20.salt AS salt_24, t20.password AS password_25, t20.encoder_name AS encoder_name_26, t20.last_login AS last_login_27, t20.password_reset_token AS password_reset_token_28, t20.password_requested_at AS password_requested_at_29, t20.email_verification_token AS email_verification_token_30, t20.verified_at AS verified_at_31, t20.locked AS locked_32, t20.expires_at AS expires_at_33, t20.credentials_expire_at AS credentials_expire_at_34, t20.roles AS roles_35, t20.email AS email_36, t20.email_canonical AS email_canonical_37, t20.created_at AS created_at_38, t20.updated_at AS updated_at_39, t20.id AS id_40, t20.login_token AS login_token_41, t20.tutor_id AS tutor_id_42, t20.customer_id AS customer_id_43 FROM sylius_customer t0 LEFT JOIN sylius_shop_user t20 ON t20.customer_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.by_default AS by_default_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.taxon_id AS taxon_id_6, t0.disponibility_id AS disponibility_id_7 FROM vachon_pickup_point t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.by_default AS by_default_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.taxon_id AS taxon_id_6, t0.disponibility_id AS disponibility_id_7 FROM vachon_pickup_point t0
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM sylius_currency t0 INNER JOIN sylius_channel_currencies ON t0.id = sylius_channel_currencies.currency_id WHERE sylius_channel_currencies.channel_id = ? ORDER BY t0.id ASC
SELECT s0_.code AS code_0, s0_.name AS name_1, s0_.hostname AS hostname_2 FROM sylius_channel s0_ ORDER BY s0_.id ASC
SELECT s0_.number AS number_0, s0_.notes AS notes_1, s0_.state AS state_2, s0_.checkout_completed_at AS checkout_completed_at_3, s0_.items_total AS items_total_4, s0_.adjustments_total AS adjustments_total_5, s0_.total AS total_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.id AS id_9, s0_.currency_code AS currency_code_10, s0_.locale_code AS locale_code_11, s0_.checkout_state AS checkout_state_12, s0_.payment_state AS payment_state_13, s0_.shipping_state AS shipping_state_14, s0_.created_by_guest AS created_by_guest_15, s0_.token_value AS token_value_16, s0_.customer_ip AS customer_ip_17, s0_.number_payment AS number_payment_18, s0_.id_contract AS id_contract_19, s0_.channel_id AS channel_id_20, s0_.promotion_coupon_id AS promotion_coupon_id_21, s0_.customer_id AS customer_id_22, s0_.shipping_address_id AS shipping_address_id_23, s0_.billing_address_id AS billing_address_id_24 FROM sylius_order s0_ WHERE s0_.state = ? AND s0_.channel_id = ? AND s0_.customer_id = ? AND (SELECT COUNT(*) FROM sylius_order_item s1_ WHERE s1_.order_id = s0_.id) > 0 AND s0_.created_by_guest = ? ORDER BY s0_.created_at DESC, s0_.id ASC LIMIT 1
SELECT t0.email AS email_1, t0.email_canonical AS email_canonical_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.birthday AS birthday_5, t0.gender AS gender_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.phone_number AS phone_number_9, t0.subscribed_to_newsletter AS subscribed_to_newsletter_10, t0.id AS id_11, t0.tutorname AS tutorname_12, t0.tutoremail AS tutoremail_13, t0.permitnumber AS permitnumber_14, t0.secondary_phone_number AS secondary_phone_number_15, t0.pathprofilpic AS pathprofilpic_16, t0.bookAuthorization AS bookAuthorization_17, t0.customer_group_id AS customer_group_id_18, t0.default_address_id AS default_address_id_19, t20.username AS username_21, t20.username_canonical AS username_canonical_22, t20.enabled AS enabled_23, t20.salt AS salt_24, t20.password AS password_25, t20.encoder_name AS encoder_name_26, t20.last_login AS last_login_27, t20.password_reset_token AS password_reset_token_28, t20.password_requested_at AS password_requested_at_29, t20.email_verification_token AS email_verification_token_30, t20.verified_at AS verified_at_31, t20.locked AS locked_32, t20.expires_at AS expires_at_33, t20.credentials_expire_at AS credentials_expire_at_34, t20.roles AS roles_35, t20.email AS email_36, t20.email_canonical AS email_canonical_37, t20.created_at AS created_at_38, t20.updated_at AS updated_at_39, t20.id AS id_40, t20.login_token AS login_token_41, t20.tutor_id AS tutor_id_42, t20.customer_id AS customer_id_43 FROM sylius_customer t0 LEFT JOIN sylius_shop_user t20 ON t20.customer_id = t0.id WHERE t0.id = ?
SELECT t0.first_name AS first_name_1, t0.last_name AS last_name_2, t0.phone_number AS phone_number_3, t0.street AS street_4, t0.company AS company_5, t0.city AS city_6, t0.postcode AS postcode_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.country_code AS country_code_10, t0.province_code AS province_code_11, t0.province_name AS province_name_12, t0.id AS id_13, t0.birthdate AS birthdate_14, t0.tutorname AS tutorname_15, t0.tutoremail AS tutoremail_16, t0.customer_id AS customer_id_17 FROM sylius_address t0 WHERE t0.id = ?
SELECT s0_.code AS code_0, s0_.name AS name_1, s0_.hostname AS hostname_2 FROM sylius_channel s0_ ORDER BY s0_.id ASC
SELECT s0_.number AS number_0, s0_.notes AS notes_1, s0_.state AS state_2, s0_.checkout_completed_at AS checkout_completed_at_3, s0_.items_total AS items_total_4, s0_.adjustments_total AS adjustments_total_5, s0_.total AS total_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.id AS id_9, s0_.currency_code AS currency_code_10, s0_.locale_code AS locale_code_11, s0_.checkout_state AS checkout_state_12, s0_.payment_state AS payment_state_13, s0_.shipping_state AS shipping_state_14, s0_.created_by_guest AS created_by_guest_15, s0_.token_value AS token_value_16, s0_.customer_ip AS customer_ip_17, s0_.number_payment AS number_payment_18, s0_.id_contract AS id_contract_19, s0_.channel_id AS channel_id_20, s0_.promotion_coupon_id AS promotion_coupon_id_21, s0_.customer_id AS customer_id_22, s0_.shipping_address_id AS shipping_address_id_23, s0_.billing_address_id AS billing_address_id_24 FROM sylius_order s0_ WHERE s0_.state = ? AND s0_.channel_id = ? AND s0_.customer_id = ? AND (SELECT COUNT(*) FROM sylius_order_item s1_ WHERE s1_.order_id = s0_.id) > 0 AND s0_.created_by_guest = ? ORDER BY s0_.created_at DESC, s0_.id ASC LIMIT 1
SELECT s0_.code AS code_0, s0_.name AS name_1, s0_.hostname AS hostname_2 FROM sylius_channel s0_ ORDER BY s0_.id ASC
SELECT s0_.number AS number_0, s0_.notes AS notes_1, s0_.state AS state_2, s0_.checkout_completed_at AS checkout_completed_at_3, s0_.items_total AS items_total_4, s0_.adjustments_total AS adjustments_total_5, s0_.total AS total_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.id AS id_9, s0_.currency_code AS currency_code_10, s0_.locale_code AS locale_code_11, s0_.checkout_state AS checkout_state_12, s0_.payment_state AS payment_state_13, s0_.shipping_state AS shipping_state_14, s0_.created_by_guest AS created_by_guest_15, s0_.token_value AS token_value_16, s0_.customer_ip AS customer_ip_17, s0_.number_payment AS number_payment_18, s0_.id_contract AS id_contract_19, s0_.channel_id AS channel_id_20, s0_.promotion_coupon_id AS promotion_coupon_id_21, s0_.customer_id AS customer_id_22, s0_.shipping_address_id AS shipping_address_id_23, s0_.billing_address_id AS billing_address_id_24 FROM sylius_order s0_ WHERE s0_.state = ? AND s0_.channel_id = ? AND s0_.customer_id = ? AND (SELECT COUNT(*) FROM sylius_order_item s1_ WHERE s1_.order_id = s0_.id) > 0 AND s0_.created_by_guest = ? ORDER BY s0_.created_at DESC, s0_.id ASC LIMIT 1
SELECT s0_.code AS code_0, s0_.tree_left AS tree_left_1, s0_.tree_right AS tree_right_2, s0_.tree_level AS tree_level_3, s0_.position AS position_4, s0_.enabled AS enabled_5, s0_.id AS id_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.street AS street_9, s0_.postalcode AS postalcode_10, s0_.city AS city_11, s0_.province AS province_12, s0_.email AS email_13, s0_.phone AS phone_14, s0_.number AS number_15, s0_.code AS code_16, s0_.tree_left AS tree_left_17, s0_.tree_right AS tree_right_18, s0_.tree_level AS tree_level_19, s0_.position AS position_20, s0_.enabled AS enabled_21, s0_.id AS id_22, s0_.created_at AS created_at_23, s0_.updated_at AS updated_at_24, s0_.street AS street_25, s0_.postalcode AS postalcode_26, s0_.city AS city_27, s0_.province AS province_28, s0_.email AS email_29, s0_.phone AS phone_30, s0_.number AS number_31, s1_.name AS name_32, s1_.slug AS slug_33, s1_.description AS description_34, s1_.id AS id_35, s1_.locale AS locale_36, s2_.code AS code_37, s2_.tree_left AS tree_left_38, s2_.tree_right AS tree_right_39, s2_.tree_level AS tree_level_40, s2_.position AS position_41, s2_.enabled AS enabled_42, s2_.id AS id_43, s2_.created_at AS created_at_44, s2_.updated_at AS updated_at_45, s2_.street AS street_46, s2_.postalcode AS postalcode_47, s2_.city AS city_48, s2_.province AS province_49, s2_.email AS email_50, s2_.phone AS phone_51, s2_.number AS number_52, s0_.tree_root AS tree_root_53, s0_.parent_id AS parent_id_54, s1_.translatable_id AS translatable_id_55, s2_.tree_root AS tree_root_56, s2_.parent_id AS parent_id_57 FROM sylius_taxon s0_ LEFT JOIN sylius_taxon_translation s1_ ON s0_.id = s1_.translatable_id LEFT JOIN sylius_taxon s2_ ON s0_.id = s2_.parent_id WHERE s1_.locale = ? AND s0_.tree_root = ? ORDER BY s0_.id ASC, s2_.position ASC, s2_.id ASC
SELECT s0_.code AS code_0, s0_.tree_left AS tree_left_1, s0_.tree_right AS tree_right_2, s0_.tree_level AS tree_level_3, s0_.position AS position_4, s0_.enabled AS enabled_5, s0_.id AS id_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.street AS street_9, s0_.postalcode AS postalcode_10, s0_.city AS city_11, s0_.province AS province_12, s0_.email AS email_13, s0_.phone AS phone_14, s0_.number AS number_15, s1_.name AS name_16, s1_.slug AS slug_17, s1_.description AS description_18, s1_.id AS id_19, s1_.locale AS locale_20, s2_.code AS code_21, s2_.tree_left AS tree_left_22, s2_.tree_right AS tree_right_23, s2_.tree_level AS tree_level_24, s2_.position AS position_25, s2_.enabled AS enabled_26, s2_.id AS id_27, s2_.created_at AS created_at_28, s2_.updated_at AS updated_at_29, s2_.street AS street_30, s2_.postalcode AS postalcode_31, s2_.city AS city_32, s2_.province AS province_33, s2_.email AS email_34, s2_.phone AS phone_35, s2_.number AS number_36, s0_.tree_root AS tree_root_37, s0_.parent_id AS parent_id_38, s1_.translatable_id AS translatable_id_39, s2_.tree_root AS tree_root_40, s2_.parent_id AS parent_id_41 FROM sylius_taxon s0_ LEFT JOIN sylius_taxon_translation s1_ ON s0_.id = s1_.translatable_id INNER JOIN sylius_taxon s3_ ON s0_.parent_id = s3_.id LEFT JOIN sylius_taxon s2_ ON s0_.id = s2_.parent_id WHERE s1_.locale = ? AND s0_.enabled = ? AND s3_.code = ? ORDER BY s0_.position ASC, s0_.id ASC, s2_.position ASC, s2_.id ASC
SELECT s0_.code AS code_0, s0_.name AS name_1, s0_.hostname AS hostname_2 FROM sylius_channel s0_ ORDER BY s0_.id ASC
SELECT s0_.number AS number_0, s0_.notes AS notes_1, s0_.state AS state_2, s0_.checkout_completed_at AS checkout_completed_at_3, s0_.items_total AS items_total_4, s0_.adjustments_total AS adjustments_total_5, s0_.total AS total_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.id AS id_9, s0_.currency_code AS currency_code_10, s0_.locale_code AS locale_code_11, s0_.checkout_state AS checkout_state_12, s0_.payment_state AS payment_state_13, s0_.shipping_state AS shipping_state_14, s0_.created_by_guest AS created_by_guest_15, s0_.token_value AS token_value_16, s0_.customer_ip AS customer_ip_17, s0_.number_payment AS number_payment_18, s0_.id_contract AS id_contract_19, s0_.channel_id AS channel_id_20, s0_.promotion_coupon_id AS promotion_coupon_id_21, s0_.customer_id AS customer_id_22, s0_.shipping_address_id AS shipping_address_id_23, s0_.billing_address_id AS billing_address_id_24 FROM sylius_order s0_ WHERE s0_.state = ? AND s0_.channel_id = ? AND s0_.customer_id = ? AND (SELECT COUNT(*) FROM sylius_order_item s1_ WHERE s1_.order_id = s0_.id) > 0 AND s0_.created_by_guest = ? ORDER BY s0_.created_at DESC, s0_.id ASC LIMIT 1
SELECT t0.code AS code_1, t0.name AS name_2, t0.id AS id_3 FROM sylius_customer_group t0 WHERE t0.id = ?
SELECT s0_.number AS number_0, s0_.notes AS notes_1, s0_.state AS state_2, s0_.checkout_completed_at AS checkout_completed_at_3, s0_.items_total AS items_total_4, s0_.adjustments_total AS adjustments_total_5, s0_.total AS total_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.id AS id_9, s0_.currency_code AS currency_code_10, s0_.locale_code AS locale_code_11, s0_.checkout_state AS checkout_state_12, s0_.payment_state AS payment_state_13, s0_.shipping_state AS shipping_state_14, s0_.created_by_guest AS created_by_guest_15, s0_.token_value AS token_value_16, s0_.customer_ip AS customer_ip_17, s0_.number_payment AS number_payment_18, s0_.id_contract AS id_contract_19, s0_.channel_id AS channel_id_20, s0_.promotion_coupon_id AS promotion_coupon_id_21, s0_.customer_id AS customer_id_22, s0_.shipping_address_id AS shipping_address_id_23, s0_.billing_address_id AS billing_address_id_24 FROM sylius_order s0_ WHERE s0_.state = ? AND s0_.channel_id = ? AND s0_.customer_id = ? AND (SELECT COUNT(*) FROM sylius_order_item s1_ WHERE s1_.order_id = s0_.id) > 0 AND s0_.created_by_guest = ? ORDER BY s0_.created_at DESC, s0_.id ASC LIMIT 1

#▲	Time	Info
1	1.09 ms	SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.contact_phone_number AS contact_phone_number_13, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15, t0.account_verification_required AS account_verification_required_16, t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17, t0.default_locale_id AS default_locale_id_18, t19.code AS code_20, t19.created_at AS created_at_21, t19.updated_at AS updated_at_22, t19.id AS id_23, t0.base_currency_id AS base_currency_id_24, t25.code AS code_26, t25.created_at AS created_at_27, t25.updated_at AS updated_at_28, t25.id AS id_29, t0.default_tax_zone_id AS default_tax_zone_id_30, t0.menu_taxon_id AS menu_taxon_id_31, t0.shop_billing_data_id AS shop_billing_data_id_32, t0.channel_price_history_config_id AS channel_price_history_config_id_33 FROM sylius_channel t0 INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id WHERE t0.hostname = ? AND t0.enabled = ? ORDER BY t0.id ASC LIMIT 1 Parameters: [`"gestion.ecoleconduitevachon.com" 1`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.contact_phone_number AS contact_phone_number_13, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15, t0.account_verification_required AS account_verification_required_16, t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17, t0.default_locale_id AS default_locale_id_18, t19.code AS code_20, t19.created_at AS created_at_21, t19.updated_at AS updated_at_22, t19.id AS id_23, t0.base_currency_id AS base_currency_id_24, t25.code AS code_26, t25.created_at AS created_at_27, t25.updated_at AS updated_at_28, t25.id AS id_29, t0.default_tax_zone_id AS default_tax_zone_id_30, t0.menu_taxon_id AS menu_taxon_id_31, t0.shop_billing_data_id AS shop_billing_data_id_32, t0.channel_price_history_config_id AS channel_price_history_config_id_33 FROM sylius_channel t0 INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id WHERE t0.hostname = ? AND t0.enabled = ? ORDER BY t0.id ASC LIMIT 1 SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.contact_phone_number AS contact_phone_number_13, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15, t0.account_verification_required AS account_verification_required_16, t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17, t0.default_locale_id AS default_locale_id_18, t19.code AS code_20, t19.created_at AS created_at_21, t19.updated_at AS updated_at_22, t19.id AS id_23, t0.base_currency_id AS base_currency_id_24, t25.code AS code_26, t25.created_at AS created_at_27, t25.updated_at AS updated_at_28, t25.id AS id_29, t0.default_tax_zone_id AS default_tax_zone_id_30, t0.menu_taxon_id AS menu_taxon_id_31, t0.shop_billing_data_id AS shop_billing_data_id_32, t0.channel_price_history_config_id AS channel_price_history_config_id_33 FROM sylius_channel t0 INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id WHERE t0.hostname = 'gestion.ecoleconduitevachon.com' AND t0.enabled = 1 ORDER BY t0.id ASC LIMIT 1;
2	0.79 ms	SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM sylius_locale t0 INNER JOIN sylius_channel_locales ON t0.id = sylius_channel_locales.locale_id WHERE sylius_channel_locales.channel_id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM sylius_locale t0 INNER JOIN sylius_channel_locales ON t0.id = sylius_channel_locales.locale_id WHERE sylius_channel_locales.channel_id = ? SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM sylius_locale t0 INNER JOIN sylius_channel_locales ON t0.id = sylius_channel_locales.locale_id WHERE sylius_channel_locales.channel_id = 1;
3	0.91 ms	SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.enabled AS enabled_3, t0.salt AS salt_4, t0.password AS password_5, t0.encoder_name AS encoder_name_6, t0.last_login AS last_login_7, t0.password_reset_token AS password_reset_token_8, t0.password_requested_at AS password_requested_at_9, t0.email_verification_token AS email_verification_token_10, t0.verified_at AS verified_at_11, t0.locked AS locked_12, t0.expires_at AS expires_at_13, t0.credentials_expire_at AS credentials_expire_at_14, t0.roles AS roles_15, t0.email AS email_16, t0.email_canonical AS email_canonical_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.id AS id_20, t0.login_token AS login_token_21, t0.tutor_id AS tutor_id_22, t0.customer_id AS customer_id_23 FROM sylius_shop_user t0 WHERE t0.id = ? Parameters: [`5404`] View formatted query View runnable query Explain query SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.enabled AS enabled_3, t0.salt AS salt_4, t0.password AS password_5, t0.encoder_name AS encoder_name_6, t0.last_login AS last_login_7, t0.password_reset_token AS password_reset_token_8, t0.password_requested_at AS password_requested_at_9, t0.email_verification_token AS email_verification_token_10, t0.verified_at AS verified_at_11, t0.locked AS locked_12, t0.expires_at AS expires_at_13, t0.credentials_expire_at AS credentials_expire_at_14, t0.roles AS roles_15, t0.email AS email_16, t0.email_canonical AS email_canonical_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.id AS id_20, t0.login_token AS login_token_21, t0.tutor_id AS tutor_id_22, t0.customer_id AS customer_id_23 FROM sylius_shop_user t0 WHERE t0.id = ? SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.enabled AS enabled_3, t0.salt AS salt_4, t0.password AS password_5, t0.encoder_name AS encoder_name_6, t0.last_login AS last_login_7, t0.password_reset_token AS password_reset_token_8, t0.password_requested_at AS password_requested_at_9, t0.email_verification_token AS email_verification_token_10, t0.verified_at AS verified_at_11, t0.locked AS locked_12, t0.expires_at AS expires_at_13, t0.credentials_expire_at AS credentials_expire_at_14, t0.roles AS roles_15, t0.email AS email_16, t0.email_canonical AS email_canonical_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.id AS id_20, t0.login_token AS login_token_21, t0.tutor_id AS tutor_id_22, t0.customer_id AS customer_id_23 FROM sylius_shop_user t0 WHERE t0.id = 5404;
4	0.92 ms	SELECT e0_.id AS id_0, e0_.number AS number_1, e0_.student_id AS student_id_2, e0_.disponibility_id AS disponibility_id_3 FROM exit_number e0_ INNER JOIN disponibility d1_ ON e0_.disponibility_id = d1_.id WHERE e0_.student_id = ? ORDER BY d1_.start ASC, e0_.id ASC Parameters: [`5404`] View formatted query View runnable query Explain query SELECT e0_.id AS id_0, e0_.number AS number_1, e0_.student_id AS student_id_2, e0_.disponibility_id AS disponibility_id_3 FROM exit_number e0_ INNER JOIN disponibility d1_ ON e0_.disponibility_id = d1_.id WHERE e0_.student_id = ? ORDER BY d1_.start ASC, e0_.id ASC SELECT e0_.id AS id_0, e0_.number AS number_1, e0_.student_id AS student_id_2, e0_.disponibility_id AS disponibility_id_3 FROM exit_number e0_ INNER JOIN disponibility d1_ ON e0_.disponibility_id = d1_.id WHERE e0_.student_id = 5404 ORDER BY d1_.start ASC, e0_.id ASC;
5	1.47 ms	SELECT d0_.id AS id_0, d0_.start AS start_1, d0_.end AS end_2, d0_.public AS public_3, d0_.reserved AS reserved_4, d0_.double_exit AS double_exit_5, d0_.pause AS pause_6, d0_.exit_number AS exit_number_7, d0_.id_calendar AS id_calendar_8, d0_.instructorName AS instructorName_9, d0_.note AS note_10, d0_.studentName AS studentName_11, d0_.shopUser_id AS shopUser_id_12, d0_.student_id AS student_id_13, d0_.taxon_id AS taxon_id_14, d0_.pickup_point_id AS pickup_point_id_15, d0_.disponibility_id AS disponibility_id_16, d0_.disponibility_id AS disponibility_id_17, d0_.disponibility_id AS disponibility_id_18, d0_.disponibility_id AS disponibility_id_19, d0_.disponibility_id AS disponibility_id_20, d0_.disponibility_id AS disponibility_id_21, d0_.disponibility_id AS disponibility_id_22, d0_.disponibility_id AS disponibility_id_23, d0_.disponibility_id AS disponibility_id_24, d0_.disponibility_id AS disponibility_id_25, d0_.disponibility_id AS disponibility_id_26, d0_.disponibility_id AS disponibility_id_27, d0_.disponibility_id AS disponibility_id_28, d0_.disponibility_id AS disponibility_id_29, d0_.disponibility_id AS disponibility_id_30 FROM disponibility d0_ INNER JOIN student_disponibility s2_ ON d0_.id = s2_.disponibility_id INNER JOIN sylius_shop_user s1_ ON s1_.id = s2_.student_id AND (s1_.id = ?) WHERE d0_.start > ? ORDER BY d0_.start ASC, d0_.id ASC Parameters: [`5404 "2025-07-01 00:00:00"`] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.start AS start_1, d0_.end AS end_2, d0_.public AS public_3, d0_.reserved AS reserved_4, d0_.double_exit AS double_exit_5, d0_.pause AS pause_6, d0_.exit_number AS exit_number_7, d0_.id_calendar AS id_calendar_8, d0_.instructorName AS instructorName_9, d0_.note AS note_10, d0_.studentName AS studentName_11, d0_.shopUser_id AS shopUser_id_12, d0_.student_id AS student_id_13, d0_.taxon_id AS taxon_id_14, d0_.pickup_point_id AS pickup_point_id_15, d0_.disponibility_id AS disponibility_id_16, d0_.disponibility_id AS disponibility_id_17, d0_.disponibility_id AS disponibility_id_18, d0_.disponibility_id AS disponibility_id_19, d0_.disponibility_id AS disponibility_id_20, d0_.disponibility_id AS disponibility_id_21, d0_.disponibility_id AS disponibility_id_22, d0_.disponibility_id AS disponibility_id_23, d0_.disponibility_id AS disponibility_id_24, d0_.disponibility_id AS disponibility_id_25, d0_.disponibility_id AS disponibility_id_26, d0_.disponibility_id AS disponibility_id_27, d0_.disponibility_id AS disponibility_id_28, d0_.disponibility_id AS disponibility_id_29, d0_.disponibility_id AS disponibility_id_30 FROM disponibility d0_ INNER JOIN student_disponibility s2_ ON d0_.id = s2_.disponibility_id INNER JOIN sylius_shop_user s1_ ON s1_.id = s2_.student_id AND (s1_.id = ?) WHERE d0_.start > ? ORDER BY d0_.start ASC, d0_.id ASC SELECT d0_.id AS id_0, d0_.start AS start_1, d0_.end AS end_2, d0_.public AS public_3, d0_.reserved AS reserved_4, d0_.double_exit AS double_exit_5, d0_.pause AS pause_6, d0_.exit_number AS exit_number_7, d0_.id_calendar AS id_calendar_8, d0_.instructorName AS instructorName_9, d0_.note AS note_10, d0_.studentName AS studentName_11, d0_.shopUser_id AS shopUser_id_12, d0_.student_id AS student_id_13, d0_.taxon_id AS taxon_id_14, d0_.pickup_point_id AS pickup_point_id_15, d0_.disponibility_id AS disponibility_id_16, d0_.disponibility_id AS disponibility_id_17, d0_.disponibility_id AS disponibility_id_18, d0_.disponibility_id AS disponibility_id_19, d0_.disponibility_id AS disponibility_id_20, d0_.disponibility_id AS disponibility_id_21, d0_.disponibility_id AS disponibility_id_22, d0_.disponibility_id AS disponibility_id_23, d0_.disponibility_id AS disponibility_id_24, d0_.disponibility_id AS disponibility_id_25, d0_.disponibility_id AS disponibility_id_26, d0_.disponibility_id AS disponibility_id_27, d0_.disponibility_id AS disponibility_id_28, d0_.disponibility_id AS disponibility_id_29, d0_.disponibility_id AS disponibility_id_30 FROM disponibility d0_ INNER JOIN student_disponibility s2_ ON d0_.id = s2_.disponibility_id INNER JOIN sylius_shop_user s1_ ON s1_.id = s2_.student_id AND (s1_.id = 5404) WHERE d0_.start > '2025-07-01 00:00:00' ORDER BY d0_.start ASC, d0_.id ASC;
6	0.68 ms	SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.enabled AS enabled_3, t0.salt AS salt_4, t0.password AS password_5, t0.encoder_name AS encoder_name_6, t0.last_login AS last_login_7, t0.password_reset_token AS password_reset_token_8, t0.password_requested_at AS password_requested_at_9, t0.email_verification_token AS email_verification_token_10, t0.verified_at AS verified_at_11, t0.locked AS locked_12, t0.expires_at AS expires_at_13, t0.credentials_expire_at AS credentials_expire_at_14, t0.roles AS roles_15, t0.email AS email_16, t0.email_canonical AS email_canonical_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.id AS id_20, t0.login_token AS login_token_21, t0.tutor_id AS tutor_id_22, t0.customer_id AS customer_id_23 FROM sylius_shop_user t0 INNER JOIN student_disponibility ON t0.id = student_disponibility.student_id WHERE student_disponibility.disponibility_id = ? Parameters: [`33504`] View formatted query View runnable query Explain query SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.enabled AS enabled_3, t0.salt AS salt_4, t0.password AS password_5, t0.encoder_name AS encoder_name_6, t0.last_login AS last_login_7, t0.password_reset_token AS password_reset_token_8, t0.password_requested_at AS password_requested_at_9, t0.email_verification_token AS email_verification_token_10, t0.verified_at AS verified_at_11, t0.locked AS locked_12, t0.expires_at AS expires_at_13, t0.credentials_expire_at AS credentials_expire_at_14, t0.roles AS roles_15, t0.email AS email_16, t0.email_canonical AS email_canonical_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.id AS id_20, t0.login_token AS login_token_21, t0.tutor_id AS tutor_id_22, t0.customer_id AS customer_id_23 FROM sylius_shop_user t0 INNER JOIN student_disponibility ON t0.id = student_disponibility.student_id WHERE student_disponibility.disponibility_id = ? SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.enabled AS enabled_3, t0.salt AS salt_4, t0.password AS password_5, t0.encoder_name AS encoder_name_6, t0.last_login AS last_login_7, t0.password_reset_token AS password_reset_token_8, t0.password_requested_at AS password_requested_at_9, t0.email_verification_token AS email_verification_token_10, t0.verified_at AS verified_at_11, t0.locked AS locked_12, t0.expires_at AS expires_at_13, t0.credentials_expire_at AS credentials_expire_at_14, t0.roles AS roles_15, t0.email AS email_16, t0.email_canonical AS email_canonical_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.id AS id_20, t0.login_token AS login_token_21, t0.tutor_id AS tutor_id_22, t0.customer_id AS customer_id_23 FROM sylius_shop_user t0 INNER JOIN student_disponibility ON t0.id = student_disponibility.student_id WHERE student_disponibility.disponibility_id = 33504;
7	0.42 ms	SELECT e0_.number AS number_0 FROM exit_number e0_ WHERE e0_.student_id = ? AND e0_.disponibility_id = ? ORDER BY e0_.id ASC LIMIT 1 Parameters: [`5404 33504`] View formatted query View runnable query Explain query SELECT e0_.number AS number_0 FROM exit_number e0_ WHERE e0_.student_id = ? AND e0_.disponibility_id = ? ORDER BY e0_.id ASC LIMIT 1 SELECT e0_.number AS number_0 FROM exit_number e0_ WHERE e0_.student_id = 5404 AND e0_.disponibility_id = 33504 ORDER BY e0_.id ASC LIMIT 1;
8	0.36 ms	SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.enabled AS enabled_3, t0.salt AS salt_4, t0.password AS password_5, t0.encoder_name AS encoder_name_6, t0.last_login AS last_login_7, t0.password_reset_token AS password_reset_token_8, t0.password_requested_at AS password_requested_at_9, t0.email_verification_token AS email_verification_token_10, t0.verified_at AS verified_at_11, t0.locked AS locked_12, t0.expires_at AS expires_at_13, t0.credentials_expire_at AS credentials_expire_at_14, t0.roles AS roles_15, t0.email AS email_16, t0.email_canonical AS email_canonical_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.id AS id_20, t0.login_token AS login_token_21, t0.tutor_id AS tutor_id_22, t0.customer_id AS customer_id_23 FROM sylius_shop_user t0 WHERE t0.id = ? Parameters: [`2917`] View formatted query View runnable query Explain query SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.enabled AS enabled_3, t0.salt AS salt_4, t0.password AS password_5, t0.encoder_name AS encoder_name_6, t0.last_login AS last_login_7, t0.password_reset_token AS password_reset_token_8, t0.password_requested_at AS password_requested_at_9, t0.email_verification_token AS email_verification_token_10, t0.verified_at AS verified_at_11, t0.locked AS locked_12, t0.expires_at AS expires_at_13, t0.credentials_expire_at AS credentials_expire_at_14, t0.roles AS roles_15, t0.email AS email_16, t0.email_canonical AS email_canonical_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.id AS id_20, t0.login_token AS login_token_21, t0.tutor_id AS tutor_id_22, t0.customer_id AS customer_id_23 FROM sylius_shop_user t0 WHERE t0.id = ? SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.enabled AS enabled_3, t0.salt AS salt_4, t0.password AS password_5, t0.encoder_name AS encoder_name_6, t0.last_login AS last_login_7, t0.password_reset_token AS password_reset_token_8, t0.password_requested_at AS password_requested_at_9, t0.email_verification_token AS email_verification_token_10, t0.verified_at AS verified_at_11, t0.locked AS locked_12, t0.expires_at AS expires_at_13, t0.credentials_expire_at AS credentials_expire_at_14, t0.roles AS roles_15, t0.email AS email_16, t0.email_canonical AS email_canonical_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.id AS id_20, t0.login_token AS login_token_21, t0.tutor_id AS tutor_id_22, t0.customer_id AS customer_id_23 FROM sylius_shop_user t0 WHERE t0.id = 2917;
9	0.79 ms	SELECT t0.email AS email_1, t0.email_canonical AS email_canonical_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.birthday AS birthday_5, t0.gender AS gender_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.phone_number AS phone_number_9, t0.subscribed_to_newsletter AS subscribed_to_newsletter_10, t0.id AS id_11, t0.tutorname AS tutorname_12, t0.tutoremail AS tutoremail_13, t0.permitnumber AS permitnumber_14, t0.secondary_phone_number AS secondary_phone_number_15, t0.pathprofilpic AS pathprofilpic_16, t0.bookAuthorization AS bookAuthorization_17, t0.customer_group_id AS customer_group_id_18, t0.default_address_id AS default_address_id_19, t20.username AS username_21, t20.username_canonical AS username_canonical_22, t20.enabled AS enabled_23, t20.salt AS salt_24, t20.password AS password_25, t20.encoder_name AS encoder_name_26, t20.last_login AS last_login_27, t20.password_reset_token AS password_reset_token_28, t20.password_requested_at AS password_requested_at_29, t20.email_verification_token AS email_verification_token_30, t20.verified_at AS verified_at_31, t20.locked AS locked_32, t20.expires_at AS expires_at_33, t20.credentials_expire_at AS credentials_expire_at_34, t20.roles AS roles_35, t20.email AS email_36, t20.email_canonical AS email_canonical_37, t20.created_at AS created_at_38, t20.updated_at AS updated_at_39, t20.id AS id_40, t20.login_token AS login_token_41, t20.tutor_id AS tutor_id_42, t20.customer_id AS customer_id_43 FROM sylius_customer t0 LEFT JOIN sylius_shop_user t20 ON t20.customer_id = t0.id WHERE t0.id = ? Parameters: [`3025`] View formatted query View runnable query Explain query SELECT t0.email AS email_1, t0.email_canonical AS email_canonical_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.birthday AS birthday_5, t0.gender AS gender_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.phone_number AS phone_number_9, t0.subscribed_to_newsletter AS subscribed_to_newsletter_10, t0.id AS id_11, t0.tutorname AS tutorname_12, t0.tutoremail AS tutoremail_13, t0.permitnumber AS permitnumber_14, t0.secondary_phone_number AS secondary_phone_number_15, t0.pathprofilpic AS pathprofilpic_16, t0.bookAuthorization AS bookAuthorization_17, t0.customer_group_id AS customer_group_id_18, t0.default_address_id AS default_address_id_19, t20.username AS username_21, t20.username_canonical AS username_canonical_22, t20.enabled AS enabled_23, t20.salt AS salt_24, t20.password AS password_25, t20.encoder_name AS encoder_name_26, t20.last_login AS last_login_27, t20.password_reset_token AS password_reset_token_28, t20.password_requested_at AS password_requested_at_29, t20.email_verification_token AS email_verification_token_30, t20.verified_at AS verified_at_31, t20.locked AS locked_32, t20.expires_at AS expires_at_33, t20.credentials_expire_at AS credentials_expire_at_34, t20.roles AS roles_35, t20.email AS email_36, t20.email_canonical AS email_canonical_37, t20.created_at AS created_at_38, t20.updated_at AS updated_at_39, t20.id AS id_40, t20.login_token AS login_token_41, t20.tutor_id AS tutor_id_42, t20.customer_id AS customer_id_43 FROM sylius_customer t0 LEFT JOIN sylius_shop_user t20 ON t20.customer_id = t0.id WHERE t0.id = ? SELECT t0.email AS email_1, t0.email_canonical AS email_canonical_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.birthday AS birthday_5, t0.gender AS gender_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.phone_number AS phone_number_9, t0.subscribed_to_newsletter AS subscribed_to_newsletter_10, t0.id AS id_11, t0.tutorname AS tutorname_12, t0.tutoremail AS tutoremail_13, t0.permitnumber AS permitnumber_14, t0.secondary_phone_number AS secondary_phone_number_15, t0.pathprofilpic AS pathprofilpic_16, t0.bookAuthorization AS bookAuthorization_17, t0.customer_group_id AS customer_group_id_18, t0.default_address_id AS default_address_id_19, t20.username AS username_21, t20.username_canonical AS username_canonical_22, t20.enabled AS enabled_23, t20.salt AS salt_24, t20.password AS password_25, t20.encoder_name AS encoder_name_26, t20.last_login AS last_login_27, t20.password_reset_token AS password_reset_token_28, t20.password_requested_at AS password_requested_at_29, t20.email_verification_token AS email_verification_token_30, t20.verified_at AS verified_at_31, t20.locked AS locked_32, t20.expires_at AS expires_at_33, t20.credentials_expire_at AS credentials_expire_at_34, t20.roles AS roles_35, t20.email AS email_36, t20.email_canonical AS email_canonical_37, t20.created_at AS created_at_38, t20.updated_at AS updated_at_39, t20.id AS id_40, t20.login_token AS login_token_41, t20.tutor_id AS tutor_id_42, t20.customer_id AS customer_id_43 FROM sylius_customer t0 LEFT JOIN sylius_shop_user t20 ON t20.customer_id = t0.id WHERE t0.id = 3025;
10	0.44 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.by_default AS by_default_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.taxon_id AS taxon_id_6, t0.disponibility_id AS disponibility_id_7 FROM vachon_pickup_point t0 WHERE t0.id = ? Parameters: [`8`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.by_default AS by_default_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.taxon_id AS taxon_id_6, t0.disponibility_id AS disponibility_id_7 FROM vachon_pickup_point t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.by_default AS by_default_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.taxon_id AS taxon_id_6, t0.disponibility_id AS disponibility_id_7 FROM vachon_pickup_point t0 WHERE t0.id = 8;
11	0.43 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.by_default AS by_default_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.taxon_id AS taxon_id_6, t0.disponibility_id AS disponibility_id_7 FROM vachon_pickup_point t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.by_default AS by_default_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.taxon_id AS taxon_id_6, t0.disponibility_id AS disponibility_id_7 FROM vachon_pickup_point t0 SELECT t0.id AS id_1, t0.name AS name_2, t0.by_default AS by_default_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.taxon_id AS taxon_id_6, t0.disponibility_id AS disponibility_id_7 FROM vachon_pickup_point t0;
12	0.92 ms	SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM sylius_currency t0 INNER JOIN sylius_channel_currencies ON t0.id = sylius_channel_currencies.currency_id WHERE sylius_channel_currencies.channel_id = ? ORDER BY t0.id ASC Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM sylius_currency t0 INNER JOIN sylius_channel_currencies ON t0.id = sylius_channel_currencies.currency_id WHERE sylius_channel_currencies.channel_id = ? ORDER BY t0.id ASC SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM sylius_currency t0 INNER JOIN sylius_channel_currencies ON t0.id = sylius_channel_currencies.currency_id WHERE sylius_channel_currencies.channel_id = 1 ORDER BY t0.id ASC;
13	0.93 ms	SELECT s0_.code AS code_0, s0_.name AS name_1, s0_.hostname AS hostname_2 FROM sylius_channel s0_ ORDER BY s0_.id ASC Parameters: [] View formatted query View runnable query Explain query SELECT s0_.code AS code_0, s0_.name AS name_1, s0_.hostname AS hostname_2 FROM sylius_channel s0_ ORDER BY s0_.id ASC SELECT s0_.code AS code_0, s0_.name AS name_1, s0_.hostname AS hostname_2 FROM sylius_channel s0_ ORDER BY s0_.id ASC;
14	1.03 ms	SELECT s0_.number AS number_0, s0_.notes AS notes_1, s0_.state AS state_2, s0_.checkout_completed_at AS checkout_completed_at_3, s0_.items_total AS items_total_4, s0_.adjustments_total AS adjustments_total_5, s0_.total AS total_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.id AS id_9, s0_.currency_code AS currency_code_10, s0_.locale_code AS locale_code_11, s0_.checkout_state AS checkout_state_12, s0_.payment_state AS payment_state_13, s0_.shipping_state AS shipping_state_14, s0_.created_by_guest AS created_by_guest_15, s0_.token_value AS token_value_16, s0_.customer_ip AS customer_ip_17, s0_.number_payment AS number_payment_18, s0_.id_contract AS id_contract_19, s0_.channel_id AS channel_id_20, s0_.promotion_coupon_id AS promotion_coupon_id_21, s0_.customer_id AS customer_id_22, s0_.shipping_address_id AS shipping_address_id_23, s0_.billing_address_id AS billing_address_id_24 FROM sylius_order s0_ WHERE s0_.state = ? AND s0_.channel_id = ? AND s0_.customer_id = ? AND (SELECT COUNT() FROM sylius_order_item s1_ WHERE s1_.order_id = s0_.id) > 0 AND s0_.created_by_guest = ? ORDER BY s0_.created_at DESC, s0_.id ASC LIMIT 1 Parameters: [`"cart" 1 5540 0`] View formatted query View runnable query Explain query SELECT s0_.number AS number_0, s0_.notes AS notes_1, s0_.state AS state_2, s0_.checkout_completed_at AS checkout_completed_at_3, s0_.items_total AS items_total_4, s0_.adjustments_total AS adjustments_total_5, s0_.total AS total_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.id AS id_9, s0_.currency_code AS currency_code_10, s0_.locale_code AS locale_code_11, s0_.checkout_state AS checkout_state_12, s0_.payment_state AS payment_state_13, s0_.shipping_state AS shipping_state_14, s0_.created_by_guest AS created_by_guest_15, s0_.token_value AS token_value_16, s0_.customer_ip AS customer_ip_17, s0_.number_payment AS number_payment_18, s0_.id_contract AS id_contract_19, s0_.channel_id AS channel_id_20, s0_.promotion_coupon_id AS promotion_coupon_id_21, s0_.customer_id AS customer_id_22, s0_.shipping_address_id AS shipping_address_id_23, s0_.billing_address_id AS billing_address_id_24 FROM sylius_order s0_ WHERE s0_.state = ? AND s0_.channel_id = ? AND s0_.customer_id = ? AND ( SELECT COUNT() FROM sylius_order_item s1_ WHERE s1_.order_id = s0_.id ) > 0 AND s0_.created_by_guest = ? ORDER BY s0_.created_at DESC, s0_.id ASC LIMIT 1 SELECT s0_.number AS number_0, s0_.notes AS notes_1, s0_.state AS state_2, s0_.checkout_completed_at AS checkout_completed_at_3, s0_.items_total AS items_total_4, s0_.adjustments_total AS adjustments_total_5, s0_.total AS total_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.id AS id_9, s0_.currency_code AS currency_code_10, s0_.locale_code AS locale_code_11, s0_.checkout_state AS checkout_state_12, s0_.payment_state AS payment_state_13, s0_.shipping_state AS shipping_state_14, s0_.created_by_guest AS created_by_guest_15, s0_.token_value AS token_value_16, s0_.customer_ip AS customer_ip_17, s0_.number_payment AS number_payment_18, s0_.id_contract AS id_contract_19, s0_.channel_id AS channel_id_20, s0_.promotion_coupon_id AS promotion_coupon_id_21, s0_.customer_id AS customer_id_22, s0_.shipping_address_id AS shipping_address_id_23, s0_.billing_address_id AS billing_address_id_24 FROM sylius_order s0_ WHERE s0_.state = 'cart' AND s0_.channel_id = 1 AND s0_.customer_id = 5540 AND (SELECT COUNT(*) FROM sylius_order_item s1_ WHERE s1_.order_id = s0_.id) > 0 AND s0_.created_by_guest = 0 ORDER BY s0_.created_at DESC, s0_.id ASC LIMIT 1;
15	0.76 ms	SELECT t0.email AS email_1, t0.email_canonical AS email_canonical_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.birthday AS birthday_5, t0.gender AS gender_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.phone_number AS phone_number_9, t0.subscribed_to_newsletter AS subscribed_to_newsletter_10, t0.id AS id_11, t0.tutorname AS tutorname_12, t0.tutoremail AS tutoremail_13, t0.permitnumber AS permitnumber_14, t0.secondary_phone_number AS secondary_phone_number_15, t0.pathprofilpic AS pathprofilpic_16, t0.bookAuthorization AS bookAuthorization_17, t0.customer_group_id AS customer_group_id_18, t0.default_address_id AS default_address_id_19, t20.username AS username_21, t20.username_canonical AS username_canonical_22, t20.enabled AS enabled_23, t20.salt AS salt_24, t20.password AS password_25, t20.encoder_name AS encoder_name_26, t20.last_login AS last_login_27, t20.password_reset_token AS password_reset_token_28, t20.password_requested_at AS password_requested_at_29, t20.email_verification_token AS email_verification_token_30, t20.verified_at AS verified_at_31, t20.locked AS locked_32, t20.expires_at AS expires_at_33, t20.credentials_expire_at AS credentials_expire_at_34, t20.roles AS roles_35, t20.email AS email_36, t20.email_canonical AS email_canonical_37, t20.created_at AS created_at_38, t20.updated_at AS updated_at_39, t20.id AS id_40, t20.login_token AS login_token_41, t20.tutor_id AS tutor_id_42, t20.customer_id AS customer_id_43 FROM sylius_customer t0 LEFT JOIN sylius_shop_user t20 ON t20.customer_id = t0.id WHERE t0.id = ? Parameters: [`5540`] View formatted query View runnable query Explain query SELECT t0.email AS email_1, t0.email_canonical AS email_canonical_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.birthday AS birthday_5, t0.gender AS gender_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.phone_number AS phone_number_9, t0.subscribed_to_newsletter AS subscribed_to_newsletter_10, t0.id AS id_11, t0.tutorname AS tutorname_12, t0.tutoremail AS tutoremail_13, t0.permitnumber AS permitnumber_14, t0.secondary_phone_number AS secondary_phone_number_15, t0.pathprofilpic AS pathprofilpic_16, t0.bookAuthorization AS bookAuthorization_17, t0.customer_group_id AS customer_group_id_18, t0.default_address_id AS default_address_id_19, t20.username AS username_21, t20.username_canonical AS username_canonical_22, t20.enabled AS enabled_23, t20.salt AS salt_24, t20.password AS password_25, t20.encoder_name AS encoder_name_26, t20.last_login AS last_login_27, t20.password_reset_token AS password_reset_token_28, t20.password_requested_at AS password_requested_at_29, t20.email_verification_token AS email_verification_token_30, t20.verified_at AS verified_at_31, t20.locked AS locked_32, t20.expires_at AS expires_at_33, t20.credentials_expire_at AS credentials_expire_at_34, t20.roles AS roles_35, t20.email AS email_36, t20.email_canonical AS email_canonical_37, t20.created_at AS created_at_38, t20.updated_at AS updated_at_39, t20.id AS id_40, t20.login_token AS login_token_41, t20.tutor_id AS tutor_id_42, t20.customer_id AS customer_id_43 FROM sylius_customer t0 LEFT JOIN sylius_shop_user t20 ON t20.customer_id = t0.id WHERE t0.id = ? SELECT t0.email AS email_1, t0.email_canonical AS email_canonical_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.birthday AS birthday_5, t0.gender AS gender_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.phone_number AS phone_number_9, t0.subscribed_to_newsletter AS subscribed_to_newsletter_10, t0.id AS id_11, t0.tutorname AS tutorname_12, t0.tutoremail AS tutoremail_13, t0.permitnumber AS permitnumber_14, t0.secondary_phone_number AS secondary_phone_number_15, t0.pathprofilpic AS pathprofilpic_16, t0.bookAuthorization AS bookAuthorization_17, t0.customer_group_id AS customer_group_id_18, t0.default_address_id AS default_address_id_19, t20.username AS username_21, t20.username_canonical AS username_canonical_22, t20.enabled AS enabled_23, t20.salt AS salt_24, t20.password AS password_25, t20.encoder_name AS encoder_name_26, t20.last_login AS last_login_27, t20.password_reset_token AS password_reset_token_28, t20.password_requested_at AS password_requested_at_29, t20.email_verification_token AS email_verification_token_30, t20.verified_at AS verified_at_31, t20.locked AS locked_32, t20.expires_at AS expires_at_33, t20.credentials_expire_at AS credentials_expire_at_34, t20.roles AS roles_35, t20.email AS email_36, t20.email_canonical AS email_canonical_37, t20.created_at AS created_at_38, t20.updated_at AS updated_at_39, t20.id AS id_40, t20.login_token AS login_token_41, t20.tutor_id AS tutor_id_42, t20.customer_id AS customer_id_43 FROM sylius_customer t0 LEFT JOIN sylius_shop_user t20 ON t20.customer_id = t0.id WHERE t0.id = 5540;
16	0.55 ms	SELECT t0.first_name AS first_name_1, t0.last_name AS last_name_2, t0.phone_number AS phone_number_3, t0.street AS street_4, t0.company AS company_5, t0.city AS city_6, t0.postcode AS postcode_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.country_code AS country_code_10, t0.province_code AS province_code_11, t0.province_name AS province_name_12, t0.id AS id_13, t0.birthdate AS birthdate_14, t0.tutorname AS tutorname_15, t0.tutoremail AS tutoremail_16, t0.customer_id AS customer_id_17 FROM sylius_address t0 WHERE t0.id = ? Parameters: [`19214`] View formatted query View runnable query Explain query SELECT t0.first_name AS first_name_1, t0.last_name AS last_name_2, t0.phone_number AS phone_number_3, t0.street AS street_4, t0.company AS company_5, t0.city AS city_6, t0.postcode AS postcode_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.country_code AS country_code_10, t0.province_code AS province_code_11, t0.province_name AS province_name_12, t0.id AS id_13, t0.birthdate AS birthdate_14, t0.tutorname AS tutorname_15, t0.tutoremail AS tutoremail_16, t0.customer_id AS customer_id_17 FROM sylius_address t0 WHERE t0.id = ? SELECT t0.first_name AS first_name_1, t0.last_name AS last_name_2, t0.phone_number AS phone_number_3, t0.street AS street_4, t0.company AS company_5, t0.city AS city_6, t0.postcode AS postcode_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.country_code AS country_code_10, t0.province_code AS province_code_11, t0.province_name AS province_name_12, t0.id AS id_13, t0.birthdate AS birthdate_14, t0.tutorname AS tutorname_15, t0.tutoremail AS tutoremail_16, t0.customer_id AS customer_id_17 FROM sylius_address t0 WHERE t0.id = 19214;
17	0.85 ms	SELECT s0_.code AS code_0, s0_.name AS name_1, s0_.hostname AS hostname_2 FROM sylius_channel s0_ ORDER BY s0_.id ASC Parameters: [] View formatted query View runnable query Explain query SELECT s0_.code AS code_0, s0_.name AS name_1, s0_.hostname AS hostname_2 FROM sylius_channel s0_ ORDER BY s0_.id ASC SELECT s0_.code AS code_0, s0_.name AS name_1, s0_.hostname AS hostname_2 FROM sylius_channel s0_ ORDER BY s0_.id ASC;
18	0.90 ms	SELECT s0_.number AS number_0, s0_.notes AS notes_1, s0_.state AS state_2, s0_.checkout_completed_at AS checkout_completed_at_3, s0_.items_total AS items_total_4, s0_.adjustments_total AS adjustments_total_5, s0_.total AS total_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.id AS id_9, s0_.currency_code AS currency_code_10, s0_.locale_code AS locale_code_11, s0_.checkout_state AS checkout_state_12, s0_.payment_state AS payment_state_13, s0_.shipping_state AS shipping_state_14, s0_.created_by_guest AS created_by_guest_15, s0_.token_value AS token_value_16, s0_.customer_ip AS customer_ip_17, s0_.number_payment AS number_payment_18, s0_.id_contract AS id_contract_19, s0_.channel_id AS channel_id_20, s0_.promotion_coupon_id AS promotion_coupon_id_21, s0_.customer_id AS customer_id_22, s0_.shipping_address_id AS shipping_address_id_23, s0_.billing_address_id AS billing_address_id_24 FROM sylius_order s0_ WHERE s0_.state = ? AND s0_.channel_id = ? AND s0_.customer_id = ? AND (SELECT COUNT() FROM sylius_order_item s1_ WHERE s1_.order_id = s0_.id) > 0 AND s0_.created_by_guest = ? ORDER BY s0_.created_at DESC, s0_.id ASC LIMIT 1 Parameters: [`"cart" 1 5540 0`] View formatted query View runnable query Explain query SELECT s0_.number AS number_0, s0_.notes AS notes_1, s0_.state AS state_2, s0_.checkout_completed_at AS checkout_completed_at_3, s0_.items_total AS items_total_4, s0_.adjustments_total AS adjustments_total_5, s0_.total AS total_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.id AS id_9, s0_.currency_code AS currency_code_10, s0_.locale_code AS locale_code_11, s0_.checkout_state AS checkout_state_12, s0_.payment_state AS payment_state_13, s0_.shipping_state AS shipping_state_14, s0_.created_by_guest AS created_by_guest_15, s0_.token_value AS token_value_16, s0_.customer_ip AS customer_ip_17, s0_.number_payment AS number_payment_18, s0_.id_contract AS id_contract_19, s0_.channel_id AS channel_id_20, s0_.promotion_coupon_id AS promotion_coupon_id_21, s0_.customer_id AS customer_id_22, s0_.shipping_address_id AS shipping_address_id_23, s0_.billing_address_id AS billing_address_id_24 FROM sylius_order s0_ WHERE s0_.state = ? AND s0_.channel_id = ? AND s0_.customer_id = ? AND ( SELECT COUNT() FROM sylius_order_item s1_ WHERE s1_.order_id = s0_.id ) > 0 AND s0_.created_by_guest = ? ORDER BY s0_.created_at DESC, s0_.id ASC LIMIT 1 SELECT s0_.number AS number_0, s0_.notes AS notes_1, s0_.state AS state_2, s0_.checkout_completed_at AS checkout_completed_at_3, s0_.items_total AS items_total_4, s0_.adjustments_total AS adjustments_total_5, s0_.total AS total_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.id AS id_9, s0_.currency_code AS currency_code_10, s0_.locale_code AS locale_code_11, s0_.checkout_state AS checkout_state_12, s0_.payment_state AS payment_state_13, s0_.shipping_state AS shipping_state_14, s0_.created_by_guest AS created_by_guest_15, s0_.token_value AS token_value_16, s0_.customer_ip AS customer_ip_17, s0_.number_payment AS number_payment_18, s0_.id_contract AS id_contract_19, s0_.channel_id AS channel_id_20, s0_.promotion_coupon_id AS promotion_coupon_id_21, s0_.customer_id AS customer_id_22, s0_.shipping_address_id AS shipping_address_id_23, s0_.billing_address_id AS billing_address_id_24 FROM sylius_order s0_ WHERE s0_.state = 'cart' AND s0_.channel_id = 1 AND s0_.customer_id = 5540 AND (SELECT COUNT(*) FROM sylius_order_item s1_ WHERE s1_.order_id = s0_.id) > 0 AND s0_.created_by_guest = 0 ORDER BY s0_.created_at DESC, s0_.id ASC LIMIT 1;
19	0.76 ms	SELECT s0_.code AS code_0, s0_.name AS name_1, s0_.hostname AS hostname_2 FROM sylius_channel s0_ ORDER BY s0_.id ASC Parameters: [] View formatted query View runnable query Explain query SELECT s0_.code AS code_0, s0_.name AS name_1, s0_.hostname AS hostname_2 FROM sylius_channel s0_ ORDER BY s0_.id ASC SELECT s0_.code AS code_0, s0_.name AS name_1, s0_.hostname AS hostname_2 FROM sylius_channel s0_ ORDER BY s0_.id ASC;
20	0.86 ms	SELECT s0_.number AS number_0, s0_.notes AS notes_1, s0_.state AS state_2, s0_.checkout_completed_at AS checkout_completed_at_3, s0_.items_total AS items_total_4, s0_.adjustments_total AS adjustments_total_5, s0_.total AS total_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.id AS id_9, s0_.currency_code AS currency_code_10, s0_.locale_code AS locale_code_11, s0_.checkout_state AS checkout_state_12, s0_.payment_state AS payment_state_13, s0_.shipping_state AS shipping_state_14, s0_.created_by_guest AS created_by_guest_15, s0_.token_value AS token_value_16, s0_.customer_ip AS customer_ip_17, s0_.number_payment AS number_payment_18, s0_.id_contract AS id_contract_19, s0_.channel_id AS channel_id_20, s0_.promotion_coupon_id AS promotion_coupon_id_21, s0_.customer_id AS customer_id_22, s0_.shipping_address_id AS shipping_address_id_23, s0_.billing_address_id AS billing_address_id_24 FROM sylius_order s0_ WHERE s0_.state = ? AND s0_.channel_id = ? AND s0_.customer_id = ? AND (SELECT COUNT() FROM sylius_order_item s1_ WHERE s1_.order_id = s0_.id) > 0 AND s0_.created_by_guest = ? ORDER BY s0_.created_at DESC, s0_.id ASC LIMIT 1 Parameters: [`"cart" 1 5540 0`] View formatted query View runnable query Explain query SELECT s0_.number AS number_0, s0_.notes AS notes_1, s0_.state AS state_2, s0_.checkout_completed_at AS checkout_completed_at_3, s0_.items_total AS items_total_4, s0_.adjustments_total AS adjustments_total_5, s0_.total AS total_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.id AS id_9, s0_.currency_code AS currency_code_10, s0_.locale_code AS locale_code_11, s0_.checkout_state AS checkout_state_12, s0_.payment_state AS payment_state_13, s0_.shipping_state AS shipping_state_14, s0_.created_by_guest AS created_by_guest_15, s0_.token_value AS token_value_16, s0_.customer_ip AS customer_ip_17, s0_.number_payment AS number_payment_18, s0_.id_contract AS id_contract_19, s0_.channel_id AS channel_id_20, s0_.promotion_coupon_id AS promotion_coupon_id_21, s0_.customer_id AS customer_id_22, s0_.shipping_address_id AS shipping_address_id_23, s0_.billing_address_id AS billing_address_id_24 FROM sylius_order s0_ WHERE s0_.state = ? AND s0_.channel_id = ? AND s0_.customer_id = ? AND ( SELECT COUNT() FROM sylius_order_item s1_ WHERE s1_.order_id = s0_.id ) > 0 AND s0_.created_by_guest = ? ORDER BY s0_.created_at DESC, s0_.id ASC LIMIT 1 SELECT s0_.number AS number_0, s0_.notes AS notes_1, s0_.state AS state_2, s0_.checkout_completed_at AS checkout_completed_at_3, s0_.items_total AS items_total_4, s0_.adjustments_total AS adjustments_total_5, s0_.total AS total_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.id AS id_9, s0_.currency_code AS currency_code_10, s0_.locale_code AS locale_code_11, s0_.checkout_state AS checkout_state_12, s0_.payment_state AS payment_state_13, s0_.shipping_state AS shipping_state_14, s0_.created_by_guest AS created_by_guest_15, s0_.token_value AS token_value_16, s0_.customer_ip AS customer_ip_17, s0_.number_payment AS number_payment_18, s0_.id_contract AS id_contract_19, s0_.channel_id AS channel_id_20, s0_.promotion_coupon_id AS promotion_coupon_id_21, s0_.customer_id AS customer_id_22, s0_.shipping_address_id AS shipping_address_id_23, s0_.billing_address_id AS billing_address_id_24 FROM sylius_order s0_ WHERE s0_.state = 'cart' AND s0_.channel_id = 1 AND s0_.customer_id = 5540 AND (SELECT COUNT(*) FROM sylius_order_item s1_ WHERE s1_.order_id = s0_.id) > 0 AND s0_.created_by_guest = 0 ORDER BY s0_.created_at DESC, s0_.id ASC LIMIT 1;
21	2.06 ms	SELECT s0_.code AS code_0, s0_.tree_left AS tree_left_1, s0_.tree_right AS tree_right_2, s0_.tree_level AS tree_level_3, s0_.position AS position_4, s0_.enabled AS enabled_5, s0_.id AS id_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.street AS street_9, s0_.postalcode AS postalcode_10, s0_.city AS city_11, s0_.province AS province_12, s0_.email AS email_13, s0_.phone AS phone_14, s0_.number AS number_15, s0_.code AS code_16, s0_.tree_left AS tree_left_17, s0_.tree_right AS tree_right_18, s0_.tree_level AS tree_level_19, s0_.position AS position_20, s0_.enabled AS enabled_21, s0_.id AS id_22, s0_.created_at AS created_at_23, s0_.updated_at AS updated_at_24, s0_.street AS street_25, s0_.postalcode AS postalcode_26, s0_.city AS city_27, s0_.province AS province_28, s0_.email AS email_29, s0_.phone AS phone_30, s0_.number AS number_31, s1_.name AS name_32, s1_.slug AS slug_33, s1_.description AS description_34, s1_.id AS id_35, s1_.locale AS locale_36, s2_.code AS code_37, s2_.tree_left AS tree_left_38, s2_.tree_right AS tree_right_39, s2_.tree_level AS tree_level_40, s2_.position AS position_41, s2_.enabled AS enabled_42, s2_.id AS id_43, s2_.created_at AS created_at_44, s2_.updated_at AS updated_at_45, s2_.street AS street_46, s2_.postalcode AS postalcode_47, s2_.city AS city_48, s2_.province AS province_49, s2_.email AS email_50, s2_.phone AS phone_51, s2_.number AS number_52, s0_.tree_root AS tree_root_53, s0_.parent_id AS parent_id_54, s1_.translatable_id AS translatable_id_55, s2_.tree_root AS tree_root_56, s2_.parent_id AS parent_id_57 FROM sylius_taxon s0_ LEFT JOIN sylius_taxon_translation s1_ ON s0_.id = s1_.translatable_id LEFT JOIN sylius_taxon s2_ ON s0_.id = s2_.parent_id WHERE s1_.locale = ? AND s0_.tree_root = ? ORDER BY s0_.id ASC, s2_.position ASC, s2_.id ASC Parameters: [`"fr_CA" 1`] View formatted query View runnable query Explain query SELECT s0_.code AS code_0, s0_.tree_left AS tree_left_1, s0_.tree_right AS tree_right_2, s0_.tree_level AS tree_level_3, s0_.position AS position_4, s0_.enabled AS enabled_5, s0_.id AS id_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.street AS street_9, s0_.postalcode AS postalcode_10, s0_.city AS city_11, s0_.province AS province_12, s0_.email AS email_13, s0_.phone AS phone_14, s0_.number AS number_15, s0_.code AS code_16, s0_.tree_left AS tree_left_17, s0_.tree_right AS tree_right_18, s0_.tree_level AS tree_level_19, s0_.position AS position_20, s0_.enabled AS enabled_21, s0_.id AS id_22, s0_.created_at AS created_at_23, s0_.updated_at AS updated_at_24, s0_.street AS street_25, s0_.postalcode AS postalcode_26, s0_.city AS city_27, s0_.province AS province_28, s0_.email AS email_29, s0_.phone AS phone_30, s0_.number AS number_31, s1_.name AS name_32, s1_.slug AS slug_33, s1_.description AS description_34, s1_.id AS id_35, s1_.locale AS locale_36, s2_.code AS code_37, s2_.tree_left AS tree_left_38, s2_.tree_right AS tree_right_39, s2_.tree_level AS tree_level_40, s2_.position AS position_41, s2_.enabled AS enabled_42, s2_.id AS id_43, s2_.created_at AS created_at_44, s2_.updated_at AS updated_at_45, s2_.street AS street_46, s2_.postalcode AS postalcode_47, s2_.city AS city_48, s2_.province AS province_49, s2_.email AS email_50, s2_.phone AS phone_51, s2_.number AS number_52, s0_.tree_root AS tree_root_53, s0_.parent_id AS parent_id_54, s1_.translatable_id AS translatable_id_55, s2_.tree_root AS tree_root_56, s2_.parent_id AS parent_id_57 FROM sylius_taxon s0_ LEFT JOIN sylius_taxon_translation s1_ ON s0_.id = s1_.translatable_id LEFT JOIN sylius_taxon s2_ ON s0_.id = s2_.parent_id WHERE s1_.locale = ? AND s0_.tree_root = ? ORDER BY s0_.id ASC, s2_.position ASC, s2_.id ASC SELECT s0_.code AS code_0, s0_.tree_left AS tree_left_1, s0_.tree_right AS tree_right_2, s0_.tree_level AS tree_level_3, s0_.position AS position_4, s0_.enabled AS enabled_5, s0_.id AS id_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.street AS street_9, s0_.postalcode AS postalcode_10, s0_.city AS city_11, s0_.province AS province_12, s0_.email AS email_13, s0_.phone AS phone_14, s0_.number AS number_15, s0_.code AS code_16, s0_.tree_left AS tree_left_17, s0_.tree_right AS tree_right_18, s0_.tree_level AS tree_level_19, s0_.position AS position_20, s0_.enabled AS enabled_21, s0_.id AS id_22, s0_.created_at AS created_at_23, s0_.updated_at AS updated_at_24, s0_.street AS street_25, s0_.postalcode AS postalcode_26, s0_.city AS city_27, s0_.province AS province_28, s0_.email AS email_29, s0_.phone AS phone_30, s0_.number AS number_31, s1_.name AS name_32, s1_.slug AS slug_33, s1_.description AS description_34, s1_.id AS id_35, s1_.locale AS locale_36, s2_.code AS code_37, s2_.tree_left AS tree_left_38, s2_.tree_right AS tree_right_39, s2_.tree_level AS tree_level_40, s2_.position AS position_41, s2_.enabled AS enabled_42, s2_.id AS id_43, s2_.created_at AS created_at_44, s2_.updated_at AS updated_at_45, s2_.street AS street_46, s2_.postalcode AS postalcode_47, s2_.city AS city_48, s2_.province AS province_49, s2_.email AS email_50, s2_.phone AS phone_51, s2_.number AS number_52, s0_.tree_root AS tree_root_53, s0_.parent_id AS parent_id_54, s1_.translatable_id AS translatable_id_55, s2_.tree_root AS tree_root_56, s2_.parent_id AS parent_id_57 FROM sylius_taxon s0_ LEFT JOIN sylius_taxon_translation s1_ ON s0_.id = s1_.translatable_id LEFT JOIN sylius_taxon s2_ ON s0_.id = s2_.parent_id WHERE s1_.locale = 'fr_CA' AND s0_.tree_root = 1 ORDER BY s0_.id ASC, s2_.position ASC, s2_.id ASC;
22	1.03 ms	SELECT s0_.code AS code_0, s0_.tree_left AS tree_left_1, s0_.tree_right AS tree_right_2, s0_.tree_level AS tree_level_3, s0_.position AS position_4, s0_.enabled AS enabled_5, s0_.id AS id_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.street AS street_9, s0_.postalcode AS postalcode_10, s0_.city AS city_11, s0_.province AS province_12, s0_.email AS email_13, s0_.phone AS phone_14, s0_.number AS number_15, s1_.name AS name_16, s1_.slug AS slug_17, s1_.description AS description_18, s1_.id AS id_19, s1_.locale AS locale_20, s2_.code AS code_21, s2_.tree_left AS tree_left_22, s2_.tree_right AS tree_right_23, s2_.tree_level AS tree_level_24, s2_.position AS position_25, s2_.enabled AS enabled_26, s2_.id AS id_27, s2_.created_at AS created_at_28, s2_.updated_at AS updated_at_29, s2_.street AS street_30, s2_.postalcode AS postalcode_31, s2_.city AS city_32, s2_.province AS province_33, s2_.email AS email_34, s2_.phone AS phone_35, s2_.number AS number_36, s0_.tree_root AS tree_root_37, s0_.parent_id AS parent_id_38, s1_.translatable_id AS translatable_id_39, s2_.tree_root AS tree_root_40, s2_.parent_id AS parent_id_41 FROM sylius_taxon s0_ LEFT JOIN sylius_taxon_translation s1_ ON s0_.id = s1_.translatable_id INNER JOIN sylius_taxon s3_ ON s0_.parent_id = s3_.id LEFT JOIN sylius_taxon s2_ ON s0_.id = s2_.parent_id WHERE s1_.locale = ? AND s0_.enabled = ? AND s3_.code = ? ORDER BY s0_.position ASC, s0_.id ASC, s2_.position ASC, s2_.id ASC Parameters: [`"fr_CA" 1 "MENU_CATEGORY"`] View formatted query View runnable query Explain query SELECT s0_.code AS code_0, s0_.tree_left AS tree_left_1, s0_.tree_right AS tree_right_2, s0_.tree_level AS tree_level_3, s0_.position AS position_4, s0_.enabled AS enabled_5, s0_.id AS id_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.street AS street_9, s0_.postalcode AS postalcode_10, s0_.city AS city_11, s0_.province AS province_12, s0_.email AS email_13, s0_.phone AS phone_14, s0_.number AS number_15, s1_.name AS name_16, s1_.slug AS slug_17, s1_.description AS description_18, s1_.id AS id_19, s1_.locale AS locale_20, s2_.code AS code_21, s2_.tree_left AS tree_left_22, s2_.tree_right AS tree_right_23, s2_.tree_level AS tree_level_24, s2_.position AS position_25, s2_.enabled AS enabled_26, s2_.id AS id_27, s2_.created_at AS created_at_28, s2_.updated_at AS updated_at_29, s2_.street AS street_30, s2_.postalcode AS postalcode_31, s2_.city AS city_32, s2_.province AS province_33, s2_.email AS email_34, s2_.phone AS phone_35, s2_.number AS number_36, s0_.tree_root AS tree_root_37, s0_.parent_id AS parent_id_38, s1_.translatable_id AS translatable_id_39, s2_.tree_root AS tree_root_40, s2_.parent_id AS parent_id_41 FROM sylius_taxon s0_ LEFT JOIN sylius_taxon_translation s1_ ON s0_.id = s1_.translatable_id INNER JOIN sylius_taxon s3_ ON s0_.parent_id = s3_.id LEFT JOIN sylius_taxon s2_ ON s0_.id = s2_.parent_id WHERE s1_.locale = ? AND s0_.enabled = ? AND s3_.code = ? ORDER BY s0_.position ASC, s0_.id ASC, s2_.position ASC, s2_.id ASC SELECT s0_.code AS code_0, s0_.tree_left AS tree_left_1, s0_.tree_right AS tree_right_2, s0_.tree_level AS tree_level_3, s0_.position AS position_4, s0_.enabled AS enabled_5, s0_.id AS id_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.street AS street_9, s0_.postalcode AS postalcode_10, s0_.city AS city_11, s0_.province AS province_12, s0_.email AS email_13, s0_.phone AS phone_14, s0_.number AS number_15, s1_.name AS name_16, s1_.slug AS slug_17, s1_.description AS description_18, s1_.id AS id_19, s1_.locale AS locale_20, s2_.code AS code_21, s2_.tree_left AS tree_left_22, s2_.tree_right AS tree_right_23, s2_.tree_level AS tree_level_24, s2_.position AS position_25, s2_.enabled AS enabled_26, s2_.id AS id_27, s2_.created_at AS created_at_28, s2_.updated_at AS updated_at_29, s2_.street AS street_30, s2_.postalcode AS postalcode_31, s2_.city AS city_32, s2_.province AS province_33, s2_.email AS email_34, s2_.phone AS phone_35, s2_.number AS number_36, s0_.tree_root AS tree_root_37, s0_.parent_id AS parent_id_38, s1_.translatable_id AS translatable_id_39, s2_.tree_root AS tree_root_40, s2_.parent_id AS parent_id_41 FROM sylius_taxon s0_ LEFT JOIN sylius_taxon_translation s1_ ON s0_.id = s1_.translatable_id INNER JOIN sylius_taxon s3_ ON s0_.parent_id = s3_.id LEFT JOIN sylius_taxon s2_ ON s0_.id = s2_.parent_id WHERE s1_.locale = 'fr_CA' AND s0_.enabled = 1 AND s3_.code = 'MENU_CATEGORY' ORDER BY s0_.position ASC, s0_.id ASC, s2_.position ASC, s2_.id ASC;
23	0.73 ms	SELECT s0_.code AS code_0, s0_.name AS name_1, s0_.hostname AS hostname_2 FROM sylius_channel s0_ ORDER BY s0_.id ASC Parameters: [] View formatted query View runnable query Explain query SELECT s0_.code AS code_0, s0_.name AS name_1, s0_.hostname AS hostname_2 FROM sylius_channel s0_ ORDER BY s0_.id ASC SELECT s0_.code AS code_0, s0_.name AS name_1, s0_.hostname AS hostname_2 FROM sylius_channel s0_ ORDER BY s0_.id ASC;
24	0.81 ms	SELECT s0_.number AS number_0, s0_.notes AS notes_1, s0_.state AS state_2, s0_.checkout_completed_at AS checkout_completed_at_3, s0_.items_total AS items_total_4, s0_.adjustments_total AS adjustments_total_5, s0_.total AS total_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.id AS id_9, s0_.currency_code AS currency_code_10, s0_.locale_code AS locale_code_11, s0_.checkout_state AS checkout_state_12, s0_.payment_state AS payment_state_13, s0_.shipping_state AS shipping_state_14, s0_.created_by_guest AS created_by_guest_15, s0_.token_value AS token_value_16, s0_.customer_ip AS customer_ip_17, s0_.number_payment AS number_payment_18, s0_.id_contract AS id_contract_19, s0_.channel_id AS channel_id_20, s0_.promotion_coupon_id AS promotion_coupon_id_21, s0_.customer_id AS customer_id_22, s0_.shipping_address_id AS shipping_address_id_23, s0_.billing_address_id AS billing_address_id_24 FROM sylius_order s0_ WHERE s0_.state = ? AND s0_.channel_id = ? AND s0_.customer_id = ? AND (SELECT COUNT() FROM sylius_order_item s1_ WHERE s1_.order_id = s0_.id) > 0 AND s0_.created_by_guest = ? ORDER BY s0_.created_at DESC, s0_.id ASC LIMIT 1 Parameters: [`"cart" 1 5540 0`] View formatted query View runnable query Explain query SELECT s0_.number AS number_0, s0_.notes AS notes_1, s0_.state AS state_2, s0_.checkout_completed_at AS checkout_completed_at_3, s0_.items_total AS items_total_4, s0_.adjustments_total AS adjustments_total_5, s0_.total AS total_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.id AS id_9, s0_.currency_code AS currency_code_10, s0_.locale_code AS locale_code_11, s0_.checkout_state AS checkout_state_12, s0_.payment_state AS payment_state_13, s0_.shipping_state AS shipping_state_14, s0_.created_by_guest AS created_by_guest_15, s0_.token_value AS token_value_16, s0_.customer_ip AS customer_ip_17, s0_.number_payment AS number_payment_18, s0_.id_contract AS id_contract_19, s0_.channel_id AS channel_id_20, s0_.promotion_coupon_id AS promotion_coupon_id_21, s0_.customer_id AS customer_id_22, s0_.shipping_address_id AS shipping_address_id_23, s0_.billing_address_id AS billing_address_id_24 FROM sylius_order s0_ WHERE s0_.state = ? AND s0_.channel_id = ? AND s0_.customer_id = ? AND ( SELECT COUNT() FROM sylius_order_item s1_ WHERE s1_.order_id = s0_.id ) > 0 AND s0_.created_by_guest = ? ORDER BY s0_.created_at DESC, s0_.id ASC LIMIT 1 SELECT s0_.number AS number_0, s0_.notes AS notes_1, s0_.state AS state_2, s0_.checkout_completed_at AS checkout_completed_at_3, s0_.items_total AS items_total_4, s0_.adjustments_total AS adjustments_total_5, s0_.total AS total_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.id AS id_9, s0_.currency_code AS currency_code_10, s0_.locale_code AS locale_code_11, s0_.checkout_state AS checkout_state_12, s0_.payment_state AS payment_state_13, s0_.shipping_state AS shipping_state_14, s0_.created_by_guest AS created_by_guest_15, s0_.token_value AS token_value_16, s0_.customer_ip AS customer_ip_17, s0_.number_payment AS number_payment_18, s0_.id_contract AS id_contract_19, s0_.channel_id AS channel_id_20, s0_.promotion_coupon_id AS promotion_coupon_id_21, s0_.customer_id AS customer_id_22, s0_.shipping_address_id AS shipping_address_id_23, s0_.billing_address_id AS billing_address_id_24 FROM sylius_order s0_ WHERE s0_.state = 'cart' AND s0_.channel_id = 1 AND s0_.customer_id = 5540 AND (SELECT COUNT(*) FROM sylius_order_item s1_ WHERE s1_.order_id = s0_.id) > 0 AND s0_.created_by_guest = 0 ORDER BY s0_.created_at DESC, s0_.id ASC LIMIT 1;
25	0.34 ms	SELECT t0.code AS code_1, t0.name AS name_2, t0.id AS id_3 FROM sylius_customer_group t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.name AS name_2, t0.id AS id_3 FROM sylius_customer_group t0 WHERE t0.id = ? SELECT t0.code AS code_1, t0.name AS name_2, t0.id AS id_3 FROM sylius_customer_group t0 WHERE t0.id = 1;
26	0.80 ms	SELECT s0_.number AS number_0, s0_.notes AS notes_1, s0_.state AS state_2, s0_.checkout_completed_at AS checkout_completed_at_3, s0_.items_total AS items_total_4, s0_.adjustments_total AS adjustments_total_5, s0_.total AS total_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.id AS id_9, s0_.currency_code AS currency_code_10, s0_.locale_code AS locale_code_11, s0_.checkout_state AS checkout_state_12, s0_.payment_state AS payment_state_13, s0_.shipping_state AS shipping_state_14, s0_.created_by_guest AS created_by_guest_15, s0_.token_value AS token_value_16, s0_.customer_ip AS customer_ip_17, s0_.number_payment AS number_payment_18, s0_.id_contract AS id_contract_19, s0_.channel_id AS channel_id_20, s0_.promotion_coupon_id AS promotion_coupon_id_21, s0_.customer_id AS customer_id_22, s0_.shipping_address_id AS shipping_address_id_23, s0_.billing_address_id AS billing_address_id_24 FROM sylius_order s0_ WHERE s0_.state = ? AND s0_.channel_id = ? AND s0_.customer_id = ? AND (SELECT COUNT() FROM sylius_order_item s1_ WHERE s1_.order_id = s0_.id) > 0 AND s0_.created_by_guest = ? ORDER BY s0_.created_at DESC, s0_.id ASC LIMIT 1 Parameters: [`"cart" 1 5540 0`] View formatted query View runnable query Explain query SELECT s0_.number AS number_0, s0_.notes AS notes_1, s0_.state AS state_2, s0_.checkout_completed_at AS checkout_completed_at_3, s0_.items_total AS items_total_4, s0_.adjustments_total AS adjustments_total_5, s0_.total AS total_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.id AS id_9, s0_.currency_code AS currency_code_10, s0_.locale_code AS locale_code_11, s0_.checkout_state AS checkout_state_12, s0_.payment_state AS payment_state_13, s0_.shipping_state AS shipping_state_14, s0_.created_by_guest AS created_by_guest_15, s0_.token_value AS token_value_16, s0_.customer_ip AS customer_ip_17, s0_.number_payment AS number_payment_18, s0_.id_contract AS id_contract_19, s0_.channel_id AS channel_id_20, s0_.promotion_coupon_id AS promotion_coupon_id_21, s0_.customer_id AS customer_id_22, s0_.shipping_address_id AS shipping_address_id_23, s0_.billing_address_id AS billing_address_id_24 FROM sylius_order s0_ WHERE s0_.state = ? AND s0_.channel_id = ? AND s0_.customer_id = ? AND ( SELECT COUNT() FROM sylius_order_item s1_ WHERE s1_.order_id = s0_.id ) > 0 AND s0_.created_by_guest = ? ORDER BY s0_.created_at DESC, s0_.id ASC LIMIT 1 SELECT s0_.number AS number_0, s0_.notes AS notes_1, s0_.state AS state_2, s0_.checkout_completed_at AS checkout_completed_at_3, s0_.items_total AS items_total_4, s0_.adjustments_total AS adjustments_total_5, s0_.total AS total_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.id AS id_9, s0_.currency_code AS currency_code_10, s0_.locale_code AS locale_code_11, s0_.checkout_state AS checkout_state_12, s0_.payment_state AS payment_state_13, s0_.shipping_state AS shipping_state_14, s0_.created_by_guest AS created_by_guest_15, s0_.token_value AS token_value_16, s0_.customer_ip AS customer_ip_17, s0_.number_payment AS number_payment_18, s0_.id_contract AS id_contract_19, s0_.channel_id AS channel_id_20, s0_.promotion_coupon_id AS promotion_coupon_id_21, s0_.customer_id AS customer_id_22, s0_.shipping_address_id AS shipping_address_id_23, s0_.billing_address_id AS billing_address_id_24 FROM sylius_order s0_ WHERE s0_.state = 'cart' AND s0_.channel_id = 1 AND s0_.customer_id = 5540 AND (SELECT COUNT(*) FROM sylius_order_item s1_ WHERE s1_.order_id = s0_.id) > 0 AND s0_.created_by_guest = 0 ORDER BY s0_.created_at DESC, s0_.id ASC 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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\PickupPoint\PickupPoint	7
App\Entity\Disponibilities\ExitNumber	6
App\Entity\Disponibilities\Disponibility	6
App\Entity\Taxonomy\Taxon	4
App\Entity\Taxonomy\TaxonTranslation	4
App\Entity\User\ShopUser	3
App\Entity\Customer\Customer	2
App\Entity\Customer\CustomerGroup	2
App\Entity\Channel\Channel	1
App\Entity\Addressing\Zone	1
App\Entity\Channel\ShopBillingData	1
App\Entity\Locale\Locale	1
App\Entity\Currency\Currency	1
App\Entity\Addressing\Address	1

Entities Mapping

Class	Mapping errors
Sylius\Component\Order\Model\Order	No errors.
Sylius\Component\Core\Model\Order	No errors.
App\Entity\Order\Order	No errors.
Sylius\Component\Shipping\Model\Shipment	No errors.
Sylius\Component\Core\Model\Shipment	No errors.
App\Entity\Shipping\Shipment	No errors.
Sylius\Component\Channel\Model\Channel	No errors.
Sylius\Component\Core\Model\Channel	No errors.
App\Entity\Channel\Channel	No errors.
Sylius\Component\Locale\Model\Locale	No errors.
App\Entity\Locale\Locale	No errors.
Sylius\Component\Currency\Model\Currency	No errors.
App\Entity\Currency\Currency	No errors.
Sylius\Component\Addressing\Model\Zone	No errors.
App\Entity\Addressing\Zone	No errors.
Sylius\Component\Taxonomy\Model\Taxon	No errors.
Sylius\Component\Core\Model\Taxon	No errors.
App\Entity\Taxonomy\Taxon	No errors.
Sylius\Component\Core\Model\ShopBillingData	No errors.
App\Entity\Channel\ShopBillingData	No errors.
Sylius\Component\Core\Model\ChannelPriceHistoryConfig	No errors.
App\Entity\Channel\ChannelPriceHistoryConfig	No errors.
Sylius\Component\Addressing\Model\Country	No errors.
App\Entity\Addressing\Country	No errors.
Sylius\Component\User\Model\User	No errors.
Sylius\Component\Core\Model\AdminUser	No errors.
App\Entity\User\AdminUser	No errors.
Sylius\Component\Core\Model\ShopUser	No errors.
App\Entity\User\ShopUser	The field App\Entity\User\ShopUser#disponibilities is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\User\ShopUser#disponibilities does not contain the required 'inversedBy="disponibilities"' attribute.
Sylius\Component\Customer\Model\Customer	No errors.
Sylius\Component\Core\Model\Customer	No errors.
App\Entity\Customer\Customer	No errors.
App\Entity\Evaluation\Evaluation	No errors.
App\Entity\Phase\Phase	No errors.
App\Entity\Disponibilities\ExitNumber	No errors.
Sylius\Component\User\Model\UserOAuth	No errors.
App\Entity\User\UserOAuth	No errors.
App\Entity\Disponibilities\Disponibility	The association App\Entity\Disponibilities\Disponibility#students refers to the inverse side field App\Entity\User\ShopUser#students which does not exist. The field App\Entity\Disponibilities\Disponibility#pickup_point is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\PickupPoint\PickupPoint#disponibility does not contain the required 'mappedBy="pickup_point"' attribute. If association App\Entity\Disponibilities\Disponibility#pickup_point is many-to-one, then the inversed side App\Entity\PickupPoint\PickupPoint#disponibility has to be one-to-many.
Sylius\Component\Core\Model\ChannelPricing	No errors.
App\Entity\Channel\ChannelPricing	No errors.
App\Entity\PickupPoint\PickupPoint	The field App\Entity\PickupPoint\PickupPoint#disponibility is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Disponibilities\Disponibility#pickup_point does not contain the required 'mappedBy="disponibility"' attribute. If association App\Entity\PickupPoint\PickupPoint#disponibility is many-to-one, then the inversed side App\Entity\Disponibilities\Disponibility#pickup_point has to be one-to-many.
App\Entity\EvaluationForms\EvaluationFormOne	No errors.
App\Entity\EvaluationForms\EvaluationFormTwo	No errors.
App\Entity\EvaluationForms\EvaluationFormThree	No errors.
App\Entity\EvaluationForms\EvaluationFormFour	No errors.
App\Entity\EvaluationForms\EvaluationFormFive	No errors.
App\Entity\EvaluationForms\EvaluationFormSix	No errors.
App\Entity\EvaluationForms\EvaluationFormSeven	No errors.
App\Entity\EvaluationForms\EvaluationFormEight	No errors.
App\Entity\EvaluationForms\EvaluationFormNine	No errors.
App\Entity\EvaluationForms\EvaluationFormTen	No errors.
App\Entity\EvaluationForms\EvaluationFormEleven	No errors.
App\Entity\EvaluationForms\EvaluationFormTwelve	No errors.
App\Entity\EvaluationForms\EvaluationFormThirteen	No errors.
App\Entity\EvaluationForms\EvaluationFormFourteen	No errors.
App\Entity\EvaluationForms\EvaluationFormFifteen	No errors.
Sylius\Component\Customer\Model\CustomerGroup	No errors.
App\Entity\Customer\CustomerGroup	No errors.
Sylius\Component\Addressing\Model\Address	No errors.
Sylius\Component\Core\Model\Address	No errors.
App\Entity\Addressing\Address	No errors.
Sylius\Component\Currency\Model\ExchangeRate	No errors.
App\Entity\Currency\ExchangeRate	No errors.
Sylius\Component\Payment\Model\PaymentMethod	No errors.
Sylius\Component\Core\Model\PaymentMethod	No errors.
App\Entity\Payment\PaymentMethod	No errors.
Sylius\Component\Shipping\Model\ShippingMethod	No errors.
Sylius\Component\Core\Model\ShippingMethod	No errors.
App\Entity\Shipping\ShippingMethod	No errors.
Sylius\Component\Promotion\Model\PromotionCoupon	No errors.
Sylius\Component\Core\Model\PromotionCoupon	No errors.
App\Entity\Promotion\PromotionCoupon	No errors.
App\Entity\Medical\Medical	No errors.
Sylius\Component\Payment\Model\Payment	No errors.
Sylius\Component\Core\Model\Payment	No errors.
App\Entity\Payment\Payment	No errors.
Sylius\Component\Promotion\Model\Promotion	No errors.
Sylius\Component\Core\Model\Promotion	No errors.
App\Entity\Promotion\Promotion	No errors.
Sylius\Component\Order\Model\OrderItem	No errors.
Sylius\Component\Core\Model\OrderItem	No errors.
App\Entity\Order\OrderItem	No errors.
Sylius\Component\Order\Model\Adjustment	No errors.
Sylius\Component\Core\Model\Adjustment	No errors.
App\Entity\Order\Adjustment	No errors.
Sylius\Component\Order\Model\OrderItemUnit	No errors.
Sylius\Component\Core\Model\OrderItemUnit	No errors.
App\Entity\Order\OrderItemUnit	No errors.
Sylius\Component\Addressing\Model\ZoneMember	No errors.
App\Entity\Addressing\ZoneMember	No errors.
App\Entity\Code\Code	No errors.
Sylius\Component\Taxonomy\Model\TaxonTranslation	No errors.
App\Entity\Taxonomy\TaxonTranslation	No errors.
Sylius\Component\Core\Model\Image	No errors.
Sylius\Component\Core\Model\TaxonImage	No errors.
App\Entity\Taxonomy\TaxonImage	No errors.
Sylius\Component\Addressing\Model\Province	No errors.
App\Entity\Addressing\Province	No errors.
Sylius\Component\Core\Model\AvatarImage	No errors.
App\Entity\User\AvatarImage	No errors.
App\Entity\Module\Module	No errors.
Sylius\Component\Product\Model\Product	No errors.
Sylius\Component\Core\Model\Product	No errors.
App\Entity\Product\Product	No errors.
Sylius\Component\Product\Model\ProductVariant	No errors.
Sylius\Component\Core\Model\ProductVariant	No errors.
App\Entity\Product\ProductVariant	No errors.
Sylius\Component\Promotion\Model\CatalogPromotion	No errors.
Sylius\Component\Core\Model\CatalogPromotion	No errors.
App\Entity\Promotion\CatalogPromotion	No errors.
Payum\Core\Model\GatewayConfig	No errors.
Sylius\Bundle\PayumBundle\Model\GatewayConfig	No errors.
App\Entity\Payment\GatewayConfig	No errors.
Sylius\Component\Payment\Model\PaymentMethodTranslation	No errors.
App\Entity\Payment\PaymentMethodTranslation	No errors.
Sylius\Component\Shipping\Model\ShippingCategory	No errors.
App\Entity\Shipping\ShippingCategory	No errors.
Sylius\Component\Taxation\Model\TaxCategory	No errors.
App\Entity\Taxation\TaxCategory	No errors.
Sylius\Component\Shipping\Model\ShippingMethodTranslation	No errors.
App\Entity\Shipping\ShippingMethodTranslation	No errors.
Sylius\Component\Shipping\Model\ShippingMethodRule	No errors.
App\Entity\Shipping\ShippingMethodRule	No errors.
Sylius\Component\Promotion\Model\PromotionTranslation	No errors.
App\Entity\Promotion\PromotionTranslation	No errors.
Sylius\Component\Promotion\Model\PromotionRule	No errors.
App\Entity\Promotion\PromotionRule	No errors.
Sylius\Component\Promotion\Model\PromotionAction	No errors.
App\Entity\Promotion\PromotionAction	No errors.
App\Entity\Contract\Contract	No errors.
Sylius\Component\Product\Model\ProductTranslation	No errors.
Sylius\Component\Core\Model\ProductTranslation	No errors.
App\Entity\Product\ProductTranslation	No errors.
Sylius\Component\Core\Model\ProductTaxon	No errors.
App\Entity\Product\ProductTaxon	No errors.
Sylius\Component\Review\Model\Review	No errors.
Sylius\Component\Core\Model\ProductReview	No errors.
App\Entity\Product\ProductReview	No errors.
Sylius\Component\Core\Model\ProductImage	No errors.
App\Entity\Product\ProductImage	No errors.
Sylius\Component\Attribute\Model\AttributeValue	No errors.
Sylius\Component\Product\Model\ProductAttributeValue	No errors.
App\Entity\Product\ProductAttributeValue	No errors.
Sylius\Component\Product\Model\ProductAssociation	No errors.
App\Entity\Product\ProductAssociation	No errors.
Sylius\Component\Product\Model\ProductOption	No errors.
App\Entity\Product\ProductOption	No errors.
Sylius\Component\Product\Model\ProductVariantTranslation	No errors.
App\Entity\Product\ProductVariantTranslation	No errors.
Sylius\Component\Product\Model\ProductOptionValue	No errors.
App\Entity\Product\ProductOptionValue	No errors.
Sylius\Component\Promotion\Model\CatalogPromotionTranslation	No errors.
App\Entity\Promotion\CatalogPromotionTranslation	No errors.
Sylius\Component\Promotion\Model\CatalogPromotionScope	No errors.
Sylius\Component\Core\Model\CatalogPromotionScope	No errors.
App\Entity\Promotion\CatalogPromotionScope	No errors.
Sylius\Component\Promotion\Model\CatalogPromotionAction	No errors.
App\Entity\Promotion\CatalogPromotionAction	No errors.
Sylius\Component\Taxation\Model\TaxRate	No errors.
Sylius\Component\Core\Model\TaxRate	No errors.
App\Entity\Taxation\TaxRate	No errors.
Sylius\Component\Attribute\Model\Attribute	No errors.
Sylius\Component\Product\Model\ProductAttribute	No errors.
App\Entity\Product\ProductAttribute	No errors.
Sylius\Component\Product\Model\ProductAssociationType	No errors.
App\Entity\Product\ProductAssociationType	No errors.
Sylius\Component\Product\Model\ProductOptionTranslation	No errors.
App\Entity\Product\ProductOptionTranslation	No errors.
Sylius\Component\Product\Model\ProductOptionValueTranslation	No errors.
App\Entity\Product\ProductOptionValueTranslation	No errors.
Sylius\Component\Attribute\Model\AttributeTranslation	No errors.
Sylius\Component\Product\Model\ProductAttributeTranslation	No errors.
App\Entity\Product\ProductAttributeTranslation	No errors.
Sylius\Component\Product\Model\ProductAssociationTypeTranslation	No errors.
App\Entity\Product\ProductAssociationTypeTranslation	No errors.

Symfony Profiler

GET https://gestion.ecoleconduitevachon.com/fr_CA/account/calendar

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping