Redirect 301 redirect from GET @sylius_shop_account_get_reservations (f56cde)

GET https://gestion.ecoleconduitevachon.com/fr_CA/get/reservations/

Query Metrics

16 Database Queries
9 Different statements
10.42 ms Query time
3 Invalid entities
130 Managed entities

Grouped Statements

Show all queries

Time Count Info
3.29 ms
(31.60%)
8
SELECT e0_.number AS number_0 FROM exit_number e0_ WHERE e0_.student_id = ? AND e0_.disponibility_id = ? ORDER BY e0_.id DESC, e0_.id ASC
Parameters:
[
  5015
  25893
]
1.32 ms
(12.64%)
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 = ? 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
  5139
  0
]
1.29 ms
(12.42%)
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 = ? AND t0.enabled = ? ORDER BY t0.id ASC LIMIT 1
Parameters:
[
  "gestion.ecoleconduitevachon.com"
  1
]
1.27 ms
(12.16%)
1
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_.public = 0 AND d0_.reserved = 1 ORDER BY d0_.start ASC, d0_.id ASC
Parameters:
[
  5015
]
0.96 ms
(9.26%)
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 = ?
Parameters:
[
  5015
]
0.80 ms
(7.71%)
1
SELECT d0_.id AS id_0, d0_.start AS start_1, d0_.end AS end_2, d0_.student_id AS student_id_3 FROM disponibility_missed d0_ WHERE d0_.student_id = ? ORDER BY d0_.id ASC
Parameters:
[
  5015
]
0.68 ms
(6.57%)
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 = ?
Parameters:
[
  1
]
0.48 ms
(4.57%)
1
SELECT t0.id AS id_1, t0.orl AS orl_2, t0.psy AS psy_3, t0.deafness AS deafness_4, t0.addictive AS addictive_5, t0.vertigo AS vertigo_6, t0.cognitive AS cognitive_7, t0.cardiac AS cardiac_8, t0.cardiac_already AS cardiac_already_9, t0.hypersomnia AS hypersomnia_10, t0.neurological AS neurological_11, t0.movements AS movements_12, t0.knowledge_less AS knowledge_less_13, t0.diabetic AS diabetic_14, t0.sleep_medication AS sleep_medication_15, t0.state AS state_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.order_id AS order_id_19 FROM vachon_medical t0 WHERE t0.order_id = ?
Parameters:
[
  16367
]
0.32 ms
(3.07%)
1
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:
[
  12
]

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\Disponibilities\Disponibility 8
App\Entity\EvaluationForms\EvaluationFormOne 7
App\Entity\EvaluationForms\EvaluationFormTwo 7
App\Entity\EvaluationForms\EvaluationFormThree 7
App\Entity\EvaluationForms\EvaluationFormFour 7
App\Entity\EvaluationForms\EvaluationFormFive 7
App\Entity\EvaluationForms\EvaluationFormSix 7
App\Entity\EvaluationForms\EvaluationFormSeven 7
App\Entity\EvaluationForms\EvaluationFormEight 7
App\Entity\EvaluationForms\EvaluationFormNine 7
App\Entity\EvaluationForms\EvaluationFormTen 7
App\Entity\EvaluationForms\EvaluationFormEleven 7
App\Entity\EvaluationForms\EvaluationFormTwelve 7
App\Entity\EvaluationForms\EvaluationFormThirteen 7
App\Entity\EvaluationForms\EvaluationFormFourteen 7
App\Entity\EvaluationForms\EvaluationFormFifteen 7
App\Entity\User\ShopUser 5
App\Entity\Taxonomy\Taxon 2
App\Entity\Disponibilities\Missed 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\Customer\Customer 1
App\Entity\PickupPoint\PickupPoint 1
App\Entity\Order\Order 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.
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.
App\Entity\Disponibilities\Missed 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.
Sylius\Component\Addressing\Model\Address No errors.
Sylius\Component\Core\Model\Address No errors.
App\Entity\Addressing\Address No errors.
Sylius\Component\Order\Model\OrderItem No errors.
Sylius\Component\Core\Model\OrderItem No errors.
App\Entity\Order\OrderItem 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\Adjustment No errors.
Sylius\Component\Core\Model\Adjustment No errors.
App\Entity\Order\Adjustment No errors.