GET https://gestion.ecoleconduitevachon.com/fr_CA/evaluation/1400

Query Metrics

12 Database Queries
9 Different statements
10.21 ms Query time
3 Invalid entities
29 Managed entities

Queries

Group similar statements

# Time Info
1 1.08 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
]
2 0.62 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
]
3 0.80 ms
SELECT t0.id AS id_1, t0.phase AS phase_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.student_id AS student_id_5, t0.module_id AS module_id_6, t0.evaluation_form_one AS evaluation_form_one_7, t0.evaluation_form_two AS evaluation_form_two_8, t0.evaluation_form_three AS evaluation_form_three_9, t0.evaluation_form_four AS evaluation_form_four_10, t0.evaluation_form_five AS evaluation_form_five_11, t0.evaluation_form_six AS evaluation_form_six_12, t0.evaluation_form_seven AS evaluation_form_seven_13, t0.evaluation_form_eight AS evaluation_form_eight_14, t0.evaluation_form_nine AS evaluation_form_nine_15, t0.evaluation_form_ten AS evaluation_form_ten_16, t0.evaluation_form_eleven AS evaluation_form_eleven_17, t0.evaluation_form_twelve AS evaluation_form_twelve_18, t0.evaluation_form_thirteen AS evaluation_form_thirteen_19, t0.evaluation_form_fourteen AS evaluation_form_fourteen_20, t0.evaluation_form_fifteen AS evaluation_form_fifteen_21 FROM vachon_evaluation t0 WHERE t0.id = ?
Parameters:
[
  "1400"
]
4 0.60 ms
SELECT t0.id AS id_1, t0.number AS number_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM vachon_module t0 WHERE t0.id = ?
Parameters:
[
  11
]
5 1.82 ms
SELECT t0.id AS id_1, t0.audio_record AS audio_record_2, t0.done AS done_3, t0.observation AS observation_4, t0.observation_one AS observation_one_5, t0.observation_two AS observation_two_6, t0.observation_three AS observation_three_7, t0.observation_four AS observation_four_8, t0.observation_five AS observation_five_9, t0.observation_six AS observation_six_10, t0.observation_seven AS observation_seven_11, t0.observation_eight AS observation_eight_12, t0.observation_nine AS observation_nine_13, t0.observation_ten AS observation_ten_14, t0.observation_eleven AS observation_eleven_15, t0.evaluate AS evaluate_16, t0.evaluate_one AS evaluate_one_17, t0.evaluate_two AS evaluate_two_18, t0.evaluate_three AS evaluate_three_19, t0.evaluate_four AS evaluate_four_20, t0.evaluate_five AS evaluate_five_21, t0.evaluate_six AS evaluate_six_22, t0.act AS act_23, t0.act_one AS act_one_24, t0.act_two AS act_two_25, t0.act_three AS act_three_26, t0.act_four AS act_four_27, t0.act_five AS act_five_28, t0.act_six AS act_six_29, t0.act_seven AS act_seven_30, t0.act_eight AS act_eight_31, t0.act_nine AS act_nine_32, t0.act_ten AS act_ten_33, t0.act_eleven AS act_eleven_34, t0.act_twelve AS act_twelve_35, t0.act_thirteen AS act_thirteen_36, t0.act_fourteen AS act_fourteen_37, t0.act_fifteen AS act_fifteen_38, t0.act_sixteen AS act_sixteen_39, t0.act_seventeen AS act_seventeen_40, t0.situations AS situations_41, t0.situation_one AS situation_one_42, t0.situation_two AS situation_two_43, t0.situation_three AS situation_three_44, t0.situation_four AS situation_four_45, t0.park_one AS park_one_46, t0.park_two AS park_two_47, t0.park_three AS park_three_48, t0.park_four AS park_four_49, t0.park_five AS park_five_50, t0.park_six AS park_six_51, t0.student_comment AS student_comment_52, t0.employee_comment AS employee_comment_53, t0.private_comment AS private_comment_54, t0.student_signature AS student_signature_55, t0.created_at AS created_at_56, t0.updated_at AS updated_at_57 FROM vachon_evaluation_form_eleven t0 WHERE t0.id = ?
Parameters:
[
  1239
]
6 0.91 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
]
7 0.68 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:
[]
8 0.66 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:
[]
9 0.58 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:
[]
10 1.13 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
]
11 0.75 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"
]
12 0.60 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:
[]

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\Taxonomy\Taxon 4
App\Entity\Taxonomy\TaxonTranslation 4
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\Evaluation\Evaluation 1
App\Entity\User\ShopUser 1
App\Entity\Module\Module 1
App\Entity\EvaluationForms\EvaluationFormOne 1
App\Entity\EvaluationForms\EvaluationFormTwo 1
App\Entity\EvaluationForms\EvaluationFormThree 1
App\Entity\EvaluationForms\EvaluationFormFour 1
App\Entity\EvaluationForms\EvaluationFormFive 1
App\Entity\EvaluationForms\EvaluationFormSix 1
App\Entity\EvaluationForms\EvaluationFormSeven 1
App\Entity\EvaluationForms\EvaluationFormEight 1
App\Entity\EvaluationForms\EvaluationFormNine 1
App\Entity\EvaluationForms\EvaluationFormTen 1
App\Entity\EvaluationForms\EvaluationFormEleven 1
App\Entity\EvaluationForms\EvaluationFormTwelve 1
App\Entity\EvaluationForms\EvaluationFormThirteen 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.
App\Entity\Evaluation\Evaluation No errors.
Sylius\Component\User\Model\User 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.
App\Entity\Module\Module No errors.
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\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.
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\Promotion\Model\PromotionCoupon No errors.
Sylius\Component\Core\Model\PromotionCoupon No errors.
App\Entity\Promotion\PromotionCoupon No errors.
Sylius\Component\Customer\Model\Customer No errors.
Sylius\Component\Core\Model\Customer No errors.
App\Entity\Customer\Customer No errors.
App\Entity\Medical\Medical No errors.
Sylius\Component\Addressing\Model\Address No errors.
Sylius\Component\Core\Model\Address No errors.
App\Entity\Addressing\Address 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.
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.
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.
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.
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\Customer\Model\CustomerGroup No errors.
App\Entity\Customer\CustomerGroup 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.
Sylius\Component\Product\Model\ProductVariant No errors.
Sylius\Component\Core\Model\ProductVariant No errors.
App\Entity\Product\ProductVariant No errors.
Sylius\Component\Product\Model\Product No errors.
Sylius\Component\Core\Model\Product No errors.
App\Entity\Product\Product No errors.
Sylius\Component\Taxation\Model\TaxRate No errors.
Sylius\Component\Core\Model\TaxRate No errors.
App\Entity\Taxation\TaxRate No errors.
Sylius\Component\Product\Model\ProductVariantTranslation No errors.
App\Entity\Product\ProductVariantTranslation No errors.
Sylius\Component\Core\Model\ChannelPricing No errors.
App\Entity\Channel\ChannelPricing No errors.
Sylius\Component\Core\Model\ProductImage No errors.
App\Entity\Product\ProductImage No errors.
Sylius\Component\Product\Model\ProductOptionValue No errors.
App\Entity\Product\ProductOptionValue 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\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\Promotion\Model\CatalogPromotion No errors.
Sylius\Component\Core\Model\CatalogPromotion No errors.
App\Entity\Promotion\CatalogPromotion No errors.
Sylius\Component\Product\Model\ProductOptionValueTranslation No errors.
App\Entity\Product\ProductOptionValueTranslation 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.