https://webstore-rec.seriderm.com/admin/_partial/channels/?template=%40SyliusAdmin%2F_channelLinks.html.twig

Query Metrics

43 Database Queries
20 Different statements
66.65 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.03 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.first_name AS first_name_21, t0.last_name AS last_name_22, t0.locale_code AS locale_code_23, t0.enablePermissionChecker AS enablePermissionChecker_24, t0.google_authenticator_secret AS google_authenticator_secret_25, t0.active2fa AS active2fa_26, t0.archived AS archived_27, t0.archived_at AS archived_at_28, t29.email AS email_30, t29.email_canonical AS email_canonical_31, t29.first_name AS first_name_32, t29.last_name AS last_name_33, t29.birthday AS birthday_34, t29.gender AS gender_35, t29.created_at AS created_at_36, t29.updated_at AS updated_at_37, t29.phone_number AS phone_number_38, t29.subscribed_to_newsletter AS subscribed_to_newsletter_39, t29.id AS id_40, t29.social_reason AS social_reason_41, t29.inter_community_tva_number AS inter_community_tva_number_42, t29.secondary_emails AS secondary_emails_43, t29.city AS city_44, t29.country AS country_45, t29.company AS company_46, t29.id_sage AS id_sage_47, t29.number_orders AS number_orders_48, t29.turnover AS turnover_49, t29.customer_group_id AS customer_group_id_50, t29.adminUser_id AS adminUser_id_51, t29.doctor_id AS doctor_id_52, t29.patient_id AS patient_id_53, t29.distributor_id AS distributor_id_54, t29.clinicalManager_id AS clinicalManager_id_55, t29.attached_pdm_id AS attached_pdm_id_56, t29.default_address_id AS default_address_id_57, t0.archived_by AS archived_by_58, t59.type AS type_60, t59.path AS path_61, t59.id AS id_62, t59.owner_id AS owner_id_63 FROM sylius_admin_user t0 LEFT JOIN sylius_customer t29 ON t29.adminUser_id = t0.id LEFT JOIN sylius_avatar_image t59 ON t59.owner_id = t0.id WHERE t0.id = ?
Parameters:
[
  3
]
2 5.84 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.haut_ai_dataset_id AS haut_ai_dataset_id_17, t0.send_payment_confirmation_email AS send_payment_confirmation_email_18, t0.default_locale_id AS default_locale_id_19, t20.code AS code_21, t20.created_at AS created_at_22, t20.updated_at AS updated_at_23, t20.id AS id_24, t0.base_currency_id AS base_currency_id_25, t26.code AS code_27, t26.created_at AS created_at_28, t26.updated_at AS updated_at_29, t26.id AS id_30, t0.default_tax_zone_id AS default_tax_zone_id_31, t0.menu_taxon_id AS menu_taxon_id_32, t0.clinical_chain_id AS clinical_chain_id_33, t0.shop_billing_data_id AS shop_billing_data_id_34 FROM sylius_channel t0 INNER JOIN sylius_locale t20 ON t0.default_locale_id = t20.id INNER JOIN sylius_currency t26 ON t0.base_currency_id = t26.id WHERE t0.hostname = ? AND t0.enabled = ? LIMIT 1
Parameters:
[
  "webstore-rec.seriderm.com"
  1
]
3 0.32 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:
[
  2
]
4 0.27 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:
[
  2
]
5 5.26 ms
SELECT t0.code AS code_1, t0.enabled AS enabled_2, t0.id AS id_3 FROM sylius_country t0 INNER JOIN sylius_channel_countries ON t0.id = sylius_channel_countries.country_id WHERE sylius_channel_countries.channel_id = ?
Parameters:
[
  2
]
6 1.44 ms
SELECT t0.code AS code_1, t0.permissions AS permissions_2, t0.id AS id_3 FROM bitbag_acl_role t0 INNER JOIN bitbag_admin_users_roles_resources ON t0.id = bitbag_admin_users_roles_resources.role_resource_id WHERE bitbag_admin_users_roles_resources.admin_user_id = ?
Parameters:
[
  3
]
7 1.21 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.social_reason AS social_reason_12, t0.inter_community_tva_number AS inter_community_tva_number_13, t0.secondary_emails AS secondary_emails_14, t0.city AS city_15, t0.country AS country_16, t0.company AS company_17, t0.id_sage AS id_sage_18, t0.number_orders AS number_orders_19, t0.turnover AS turnover_20, t0.customer_group_id AS customer_group_id_21, t0.adminUser_id AS adminUser_id_22, t0.doctor_id AS doctor_id_23, t0.patient_id AS patient_id_24, t0.distributor_id AS distributor_id_25, t0.clinicalManager_id AS clinicalManager_id_26, t27.type AS type_28, t27.path AS path_29, t27.id AS id_30, t27.createdAt AS createdAt_31, t27.updatedAt AS updatedAt_32, t27.owner_id AS owner_id_33, t0.attached_pdm_id AS attached_pdm_id_34, t35.id AS id_36, t35.provider AS provider_37, t35.provider_user_id AS provider_user_id_38, t35.createdAt AS createdAt_39, t35.updatedAt AS updatedAt_40, t35.customer_id AS customer_id_41, t42.id AS id_43, t42.wallet_id AS wallet_id_44, t42.qr_code_token AS qr_code_token_45, t42.qr_code_expires_at AS qr_code_expires_at_46, t42.loyalty_points AS loyalty_points_47, t42.loyalty_status AS loyalty_status_48, t42.loyalty_status_expires_at AS loyalty_status_expires_at_49, t42.wallet_pass_id AS wallet_pass_id_50, t42.apple_pass_type_id AS apple_pass_type_id_51, t42.google_pass_class_id AS google_pass_class_id_52, t42.is_active AS is_active_53, t42.dynamic_message AS dynamic_message_54, t42.createdAt AS createdAt_55, t42.updatedAt AS updatedAt_56, t42.customer_id AS customer_id_57, t0.default_address_id AS default_address_id_58, t59.username AS username_60, t59.username_canonical AS username_canonical_61, t59.enabled AS enabled_62, t59.salt AS salt_63, t59.password AS password_64, t59.encoder_name AS encoder_name_65, t59.last_login AS last_login_66, t59.password_reset_token AS password_reset_token_67, t59.password_requested_at AS password_requested_at_68, t59.email_verification_token AS email_verification_token_69, t59.verified_at AS verified_at_70, t59.locked AS locked_71, t59.expires_at AS expires_at_72, t59.credentials_expire_at AS credentials_expire_at_73, t59.roles AS roles_74, t59.email AS email_75, t59.email_canonical AS email_canonical_76, t59.created_at AS created_at_77, t59.updated_at AS updated_at_78, t59.id AS id_79, t59.enabled_at AS enabled_at_80, t59.disabled_at AS disabled_at_81, t59.must_change_password AS must_change_password_82, t59.password_changed_at AS password_changed_at_83, t59.account_status AS account_status_84, t59.first_login_at AS first_login_at_85, t59.google_authenticator_secret AS google_authenticator_secret_86, t59.active2fa AS active2fa_87, t59.archived AS archived_88, t59.archived_at AS archived_at_89, t59.archived_by AS archived_by_90, t59.customer_id AS customer_id_91 FROM sylius_customer t0 LEFT JOIN sylius_customer_photo t27 ON t27.owner_id = t0.id LEFT JOIN app_customer_social_account t35 ON t35.customer_id = t0.id LEFT JOIN app_wallet t42 ON t42.customer_id = t0.id LEFT JOIN sylius_shop_user t59 ON t59.customer_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
  "2919"
]
8 1.03 ms
SELECT s0_.username AS username_0, s0_.username_canonical AS username_canonical_1, s0_.enabled AS enabled_2, s0_.salt AS salt_3, s0_.password AS password_4, s0_.encoder_name AS encoder_name_5, s0_.last_login AS last_login_6, s0_.password_reset_token AS password_reset_token_7, s0_.password_requested_at AS password_requested_at_8, s0_.email_verification_token AS email_verification_token_9, s0_.verified_at AS verified_at_10, s0_.locked AS locked_11, s0_.expires_at AS expires_at_12, s0_.credentials_expire_at AS credentials_expire_at_13, s0_.roles AS roles_14, s0_.email AS email_15, s0_.email_canonical AS email_canonical_16, s0_.created_at AS created_at_17, s0_.updated_at AS updated_at_18, s0_.id AS id_19, s0_.first_name AS first_name_20, s0_.last_name AS last_name_21, s0_.locale_code AS locale_code_22, s0_.enablePermissionChecker AS enablePermissionChecker_23, s0_.google_authenticator_secret AS google_authenticator_secret_24, s0_.active2fa AS active2fa_25, s0_.archived AS archived_26, s0_.archived_at AS archived_at_27, s0_.archived_by AS archived_by_28 FROM sylius_admin_user s0_ LEFT JOIN bitbag_admin_users_roles_resources b2_ ON s0_.id = b2_.admin_user_id LEFT JOIN bitbag_acl_role b1_ ON b1_.id = b2_.role_resource_id WHERE b1_.code IN (?) AND s0_.archived = ? ORDER BY s0_.id ASC
Parameters:
[
  [
    "pdm"
  ]
  0
]
9 0.47 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.social_reason AS social_reason_12, t0.inter_community_tva_number AS inter_community_tva_number_13, t0.secondary_emails AS secondary_emails_14, t0.city AS city_15, t0.country AS country_16, t0.company AS company_17, t0.id_sage AS id_sage_18, t0.number_orders AS number_orders_19, t0.turnover AS turnover_20, t0.customer_group_id AS customer_group_id_21, t0.adminUser_id AS adminUser_id_22, t0.doctor_id AS doctor_id_23, t0.patient_id AS patient_id_24, t0.distributor_id AS distributor_id_25, t0.clinicalManager_id AS clinicalManager_id_26, t27.type AS type_28, t27.path AS path_29, t27.id AS id_30, t27.createdAt AS createdAt_31, t27.updatedAt AS updatedAt_32, t27.owner_id AS owner_id_33, t0.attached_pdm_id AS attached_pdm_id_34, t35.id AS id_36, t35.provider AS provider_37, t35.provider_user_id AS provider_user_id_38, t35.createdAt AS createdAt_39, t35.updatedAt AS updatedAt_40, t35.customer_id AS customer_id_41, t42.id AS id_43, t42.wallet_id AS wallet_id_44, t42.qr_code_token AS qr_code_token_45, t42.qr_code_expires_at AS qr_code_expires_at_46, t42.loyalty_points AS loyalty_points_47, t42.loyalty_status AS loyalty_status_48, t42.loyalty_status_expires_at AS loyalty_status_expires_at_49, t42.wallet_pass_id AS wallet_pass_id_50, t42.apple_pass_type_id AS apple_pass_type_id_51, t42.google_pass_class_id AS google_pass_class_id_52, t42.is_active AS is_active_53, t42.dynamic_message AS dynamic_message_54, t42.createdAt AS createdAt_55, t42.updatedAt AS updatedAt_56, t42.customer_id AS customer_id_57, t0.default_address_id AS default_address_id_58, t59.username AS username_60, t59.username_canonical AS username_canonical_61, t59.enabled AS enabled_62, t59.salt AS salt_63, t59.password AS password_64, t59.encoder_name AS encoder_name_65, t59.last_login AS last_login_66, t59.password_reset_token AS password_reset_token_67, t59.password_requested_at AS password_requested_at_68, t59.email_verification_token AS email_verification_token_69, t59.verified_at AS verified_at_70, t59.locked AS locked_71, t59.expires_at AS expires_at_72, t59.credentials_expire_at AS credentials_expire_at_73, t59.roles AS roles_74, t59.email AS email_75, t59.email_canonical AS email_canonical_76, t59.created_at AS created_at_77, t59.updated_at AS updated_at_78, t59.id AS id_79, t59.enabled_at AS enabled_at_80, t59.disabled_at AS disabled_at_81, t59.must_change_password AS must_change_password_82, t59.password_changed_at AS password_changed_at_83, t59.account_status AS account_status_84, t59.first_login_at AS first_login_at_85, t59.google_authenticator_secret AS google_authenticator_secret_86, t59.active2fa AS active2fa_87, t59.archived AS archived_88, t59.archived_at AS archived_at_89, t59.archived_by AS archived_by_90, t59.customer_id AS customer_id_91 FROM sylius_customer t0 LEFT JOIN sylius_customer_photo t27 ON t27.owner_id = t0.id LEFT JOIN app_customer_social_account t35 ON t35.customer_id = t0.id LEFT JOIN app_wallet t42 ON t42.customer_id = t0.id LEFT JOIN sylius_shop_user t59 ON t59.customer_id = t0.id WHERE t0.adminUser_id = ?
Parameters:
[
  9
]
10 0.21 ms
SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.owner_id AS owner_id_4 FROM sylius_avatar_image t0 WHERE t0.owner_id = ?
Parameters:
[
  9
]
11 0.44 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.social_reason AS social_reason_12, t0.inter_community_tva_number AS inter_community_tva_number_13, t0.secondary_emails AS secondary_emails_14, t0.city AS city_15, t0.country AS country_16, t0.company AS company_17, t0.id_sage AS id_sage_18, t0.number_orders AS number_orders_19, t0.turnover AS turnover_20, t0.customer_group_id AS customer_group_id_21, t0.adminUser_id AS adminUser_id_22, t0.doctor_id AS doctor_id_23, t0.patient_id AS patient_id_24, t0.distributor_id AS distributor_id_25, t0.clinicalManager_id AS clinicalManager_id_26, t27.type AS type_28, t27.path AS path_29, t27.id AS id_30, t27.createdAt AS createdAt_31, t27.updatedAt AS updatedAt_32, t27.owner_id AS owner_id_33, t0.attached_pdm_id AS attached_pdm_id_34, t35.id AS id_36, t35.provider AS provider_37, t35.provider_user_id AS provider_user_id_38, t35.createdAt AS createdAt_39, t35.updatedAt AS updatedAt_40, t35.customer_id AS customer_id_41, t42.id AS id_43, t42.wallet_id AS wallet_id_44, t42.qr_code_token AS qr_code_token_45, t42.qr_code_expires_at AS qr_code_expires_at_46, t42.loyalty_points AS loyalty_points_47, t42.loyalty_status AS loyalty_status_48, t42.loyalty_status_expires_at AS loyalty_status_expires_at_49, t42.wallet_pass_id AS wallet_pass_id_50, t42.apple_pass_type_id AS apple_pass_type_id_51, t42.google_pass_class_id AS google_pass_class_id_52, t42.is_active AS is_active_53, t42.dynamic_message AS dynamic_message_54, t42.createdAt AS createdAt_55, t42.updatedAt AS updatedAt_56, t42.customer_id AS customer_id_57, t0.default_address_id AS default_address_id_58, t59.username AS username_60, t59.username_canonical AS username_canonical_61, t59.enabled AS enabled_62, t59.salt AS salt_63, t59.password AS password_64, t59.encoder_name AS encoder_name_65, t59.last_login AS last_login_66, t59.password_reset_token AS password_reset_token_67, t59.password_requested_at AS password_requested_at_68, t59.email_verification_token AS email_verification_token_69, t59.verified_at AS verified_at_70, t59.locked AS locked_71, t59.expires_at AS expires_at_72, t59.credentials_expire_at AS credentials_expire_at_73, t59.roles AS roles_74, t59.email AS email_75, t59.email_canonical AS email_canonical_76, t59.created_at AS created_at_77, t59.updated_at AS updated_at_78, t59.id AS id_79, t59.enabled_at AS enabled_at_80, t59.disabled_at AS disabled_at_81, t59.must_change_password AS must_change_password_82, t59.password_changed_at AS password_changed_at_83, t59.account_status AS account_status_84, t59.first_login_at AS first_login_at_85, t59.google_authenticator_secret AS google_authenticator_secret_86, t59.active2fa AS active2fa_87, t59.archived AS archived_88, t59.archived_at AS archived_at_89, t59.archived_by AS archived_by_90, t59.customer_id AS customer_id_91 FROM sylius_customer t0 LEFT JOIN sylius_customer_photo t27 ON t27.owner_id = t0.id LEFT JOIN app_customer_social_account t35 ON t35.customer_id = t0.id LEFT JOIN app_wallet t42 ON t42.customer_id = t0.id LEFT JOIN sylius_shop_user t59 ON t59.customer_id = t0.id WHERE t0.adminUser_id = ?
Parameters:
[
  16
]
12 0.20 ms
SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.owner_id AS owner_id_4 FROM sylius_avatar_image t0 WHERE t0.owner_id = ?
Parameters:
[
  16
]
13 17.74 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_.minimum_unit_count AS minimum_unit_count_9, s0_.archived AS archived_10, s0_.archived_at AS archived_at_11, s1_.name AS name_12, s1_.slug AS slug_13, s1_.description AS description_14, s1_.id AS id_15, s1_.locale AS locale_16, s2_.code AS code_17, s2_.tree_left AS tree_left_18, s2_.tree_right AS tree_right_19, s2_.tree_level AS tree_level_20, s2_.position AS position_21, s2_.enabled AS enabled_22, s2_.id AS id_23, s2_.created_at AS created_at_24, s2_.updated_at AS updated_at_25, s2_.minimum_unit_count AS minimum_unit_count_26, s2_.archived AS archived_27, s2_.archived_at AS archived_at_28, s0_.tree_root AS tree_root_29, s0_.parent_id AS parent_id_30, s0_.archived_by AS archived_by_31, s1_.translatable_id AS translatable_id_32, s2_.tree_root AS tree_root_33, s2_.parent_id AS parent_id_34, s2_.archived_by AS archived_by_35 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 s3_.code = ? ORDER BY s0_.position ASC, s0_.id ASC, s2_.position ASC, s2_.id ASC
Parameters:
[
  "MENU_CATEGORY"
]
14 0.40 ms
SELECT a0_.id AS id_0, a0_.requires_validation_by_clinical_manager AS requires_validation_by_clinical_manager_1, a0_.createdAt AS createdAt_2, a0_.updatedAt AS updatedAt_3, a0_.attached_clinical_manager_id AS attached_clinical_manager_id_4 FROM app_clinical_manager a0_ INNER JOIN sylius_customer s1_ ON a0_.id = s1_.clinicalManager_id INNER JOIN sylius_admin_user s2_ ON s1_.adminUser_id = s2_.id WHERE s2_.archived = ? ORDER BY a0_.id ASC
Parameters:
[
  0
]
15 0.55 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.social_reason AS social_reason_12, t0.inter_community_tva_number AS inter_community_tva_number_13, t0.secondary_emails AS secondary_emails_14, t0.city AS city_15, t0.country AS country_16, t0.company AS company_17, t0.id_sage AS id_sage_18, t0.number_orders AS number_orders_19, t0.turnover AS turnover_20, t0.customer_group_id AS customer_group_id_21, t0.adminUser_id AS adminUser_id_22, t0.doctor_id AS doctor_id_23, t0.patient_id AS patient_id_24, t0.distributor_id AS distributor_id_25, t0.clinicalManager_id AS clinicalManager_id_26, t27.type AS type_28, t27.path AS path_29, t27.id AS id_30, t27.createdAt AS createdAt_31, t27.updatedAt AS updatedAt_32, t27.owner_id AS owner_id_33, t0.attached_pdm_id AS attached_pdm_id_34, t35.id AS id_36, t35.provider AS provider_37, t35.provider_user_id AS provider_user_id_38, t35.createdAt AS createdAt_39, t35.updatedAt AS updatedAt_40, t35.customer_id AS customer_id_41, t42.id AS id_43, t42.wallet_id AS wallet_id_44, t42.qr_code_token AS qr_code_token_45, t42.qr_code_expires_at AS qr_code_expires_at_46, t42.loyalty_points AS loyalty_points_47, t42.loyalty_status AS loyalty_status_48, t42.loyalty_status_expires_at AS loyalty_status_expires_at_49, t42.wallet_pass_id AS wallet_pass_id_50, t42.apple_pass_type_id AS apple_pass_type_id_51, t42.google_pass_class_id AS google_pass_class_id_52, t42.is_active AS is_active_53, t42.dynamic_message AS dynamic_message_54, t42.createdAt AS createdAt_55, t42.updatedAt AS updatedAt_56, t42.customer_id AS customer_id_57, t0.default_address_id AS default_address_id_58, t59.username AS username_60, t59.username_canonical AS username_canonical_61, t59.enabled AS enabled_62, t59.salt AS salt_63, t59.password AS password_64, t59.encoder_name AS encoder_name_65, t59.last_login AS last_login_66, t59.password_reset_token AS password_reset_token_67, t59.password_requested_at AS password_requested_at_68, t59.email_verification_token AS email_verification_token_69, t59.verified_at AS verified_at_70, t59.locked AS locked_71, t59.expires_at AS expires_at_72, t59.credentials_expire_at AS credentials_expire_at_73, t59.roles AS roles_74, t59.email AS email_75, t59.email_canonical AS email_canonical_76, t59.created_at AS created_at_77, t59.updated_at AS updated_at_78, t59.id AS id_79, t59.enabled_at AS enabled_at_80, t59.disabled_at AS disabled_at_81, t59.must_change_password AS must_change_password_82, t59.password_changed_at AS password_changed_at_83, t59.account_status AS account_status_84, t59.first_login_at AS first_login_at_85, t59.google_authenticator_secret AS google_authenticator_secret_86, t59.active2fa AS active2fa_87, t59.archived AS archived_88, t59.archived_at AS archived_at_89, t59.archived_by AS archived_by_90, t59.customer_id AS customer_id_91 FROM sylius_customer t0 LEFT JOIN sylius_customer_photo t27 ON t27.owner_id = t0.id LEFT JOIN app_customer_social_account t35 ON t35.customer_id = t0.id LEFT JOIN app_wallet t42 ON t42.customer_id = t0.id LEFT JOIN sylius_shop_user t59 ON t59.customer_id = t0.id WHERE t0.clinicalManager_id = ?
Parameters:
[
  1
]
16 0.48 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.social_reason AS social_reason_12, t0.inter_community_tva_number AS inter_community_tva_number_13, t0.secondary_emails AS secondary_emails_14, t0.city AS city_15, t0.country AS country_16, t0.company AS company_17, t0.id_sage AS id_sage_18, t0.number_orders AS number_orders_19, t0.turnover AS turnover_20, t0.customer_group_id AS customer_group_id_21, t0.adminUser_id AS adminUser_id_22, t0.doctor_id AS doctor_id_23, t0.patient_id AS patient_id_24, t0.distributor_id AS distributor_id_25, t0.clinicalManager_id AS clinicalManager_id_26, t27.type AS type_28, t27.path AS path_29, t27.id AS id_30, t27.createdAt AS createdAt_31, t27.updatedAt AS updatedAt_32, t27.owner_id AS owner_id_33, t0.attached_pdm_id AS attached_pdm_id_34, t35.id AS id_36, t35.provider AS provider_37, t35.provider_user_id AS provider_user_id_38, t35.createdAt AS createdAt_39, t35.updatedAt AS updatedAt_40, t35.customer_id AS customer_id_41, t42.id AS id_43, t42.wallet_id AS wallet_id_44, t42.qr_code_token AS qr_code_token_45, t42.qr_code_expires_at AS qr_code_expires_at_46, t42.loyalty_points AS loyalty_points_47, t42.loyalty_status AS loyalty_status_48, t42.loyalty_status_expires_at AS loyalty_status_expires_at_49, t42.wallet_pass_id AS wallet_pass_id_50, t42.apple_pass_type_id AS apple_pass_type_id_51, t42.google_pass_class_id AS google_pass_class_id_52, t42.is_active AS is_active_53, t42.dynamic_message AS dynamic_message_54, t42.createdAt AS createdAt_55, t42.updatedAt AS updatedAt_56, t42.customer_id AS customer_id_57, t0.default_address_id AS default_address_id_58, t59.username AS username_60, t59.username_canonical AS username_canonical_61, t59.enabled AS enabled_62, t59.salt AS salt_63, t59.password AS password_64, t59.encoder_name AS encoder_name_65, t59.last_login AS last_login_66, t59.password_reset_token AS password_reset_token_67, t59.password_requested_at AS password_requested_at_68, t59.email_verification_token AS email_verification_token_69, t59.verified_at AS verified_at_70, t59.locked AS locked_71, t59.expires_at AS expires_at_72, t59.credentials_expire_at AS credentials_expire_at_73, t59.roles AS roles_74, t59.email AS email_75, t59.email_canonical AS email_canonical_76, t59.created_at AS created_at_77, t59.updated_at AS updated_at_78, t59.id AS id_79, t59.enabled_at AS enabled_at_80, t59.disabled_at AS disabled_at_81, t59.must_change_password AS must_change_password_82, t59.password_changed_at AS password_changed_at_83, t59.account_status AS account_status_84, t59.first_login_at AS first_login_at_85, t59.google_authenticator_secret AS google_authenticator_secret_86, t59.active2fa AS active2fa_87, t59.archived AS archived_88, t59.archived_at AS archived_at_89, t59.archived_by AS archived_by_90, t59.customer_id AS customer_id_91 FROM sylius_customer t0 LEFT JOIN sylius_customer_photo t27 ON t27.owner_id = t0.id LEFT JOIN app_customer_social_account t35 ON t35.customer_id = t0.id LEFT JOIN app_wallet t42 ON t42.customer_id = t0.id LEFT JOIN sylius_shop_user t59 ON t59.customer_id = t0.id WHERE t0.clinicalManager_id = ?
Parameters:
[
  2
]
17 0.49 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.social_reason AS social_reason_12, t0.inter_community_tva_number AS inter_community_tva_number_13, t0.secondary_emails AS secondary_emails_14, t0.city AS city_15, t0.country AS country_16, t0.company AS company_17, t0.id_sage AS id_sage_18, t0.number_orders AS number_orders_19, t0.turnover AS turnover_20, t0.customer_group_id AS customer_group_id_21, t0.adminUser_id AS adminUser_id_22, t0.doctor_id AS doctor_id_23, t0.patient_id AS patient_id_24, t0.distributor_id AS distributor_id_25, t0.clinicalManager_id AS clinicalManager_id_26, t27.type AS type_28, t27.path AS path_29, t27.id AS id_30, t27.createdAt AS createdAt_31, t27.updatedAt AS updatedAt_32, t27.owner_id AS owner_id_33, t0.attached_pdm_id AS attached_pdm_id_34, t35.id AS id_36, t35.provider AS provider_37, t35.provider_user_id AS provider_user_id_38, t35.createdAt AS createdAt_39, t35.updatedAt AS updatedAt_40, t35.customer_id AS customer_id_41, t42.id AS id_43, t42.wallet_id AS wallet_id_44, t42.qr_code_token AS qr_code_token_45, t42.qr_code_expires_at AS qr_code_expires_at_46, t42.loyalty_points AS loyalty_points_47, t42.loyalty_status AS loyalty_status_48, t42.loyalty_status_expires_at AS loyalty_status_expires_at_49, t42.wallet_pass_id AS wallet_pass_id_50, t42.apple_pass_type_id AS apple_pass_type_id_51, t42.google_pass_class_id AS google_pass_class_id_52, t42.is_active AS is_active_53, t42.dynamic_message AS dynamic_message_54, t42.createdAt AS createdAt_55, t42.updatedAt AS updatedAt_56, t42.customer_id AS customer_id_57, t0.default_address_id AS default_address_id_58, t59.username AS username_60, t59.username_canonical AS username_canonical_61, t59.enabled AS enabled_62, t59.salt AS salt_63, t59.password AS password_64, t59.encoder_name AS encoder_name_65, t59.last_login AS last_login_66, t59.password_reset_token AS password_reset_token_67, t59.password_requested_at AS password_requested_at_68, t59.email_verification_token AS email_verification_token_69, t59.verified_at AS verified_at_70, t59.locked AS locked_71, t59.expires_at AS expires_at_72, t59.credentials_expire_at AS credentials_expire_at_73, t59.roles AS roles_74, t59.email AS email_75, t59.email_canonical AS email_canonical_76, t59.created_at AS created_at_77, t59.updated_at AS updated_at_78, t59.id AS id_79, t59.enabled_at AS enabled_at_80, t59.disabled_at AS disabled_at_81, t59.must_change_password AS must_change_password_82, t59.password_changed_at AS password_changed_at_83, t59.account_status AS account_status_84, t59.first_login_at AS first_login_at_85, t59.google_authenticator_secret AS google_authenticator_secret_86, t59.active2fa AS active2fa_87, t59.archived AS archived_88, t59.archived_at AS archived_at_89, t59.archived_by AS archived_by_90, t59.customer_id AS customer_id_91 FROM sylius_customer t0 LEFT JOIN sylius_customer_photo t27 ON t27.owner_id = t0.id LEFT JOIN app_customer_social_account t35 ON t35.customer_id = t0.id LEFT JOIN app_wallet t42 ON t42.customer_id = t0.id LEFT JOIN sylius_shop_user t59 ON t59.customer_id = t0.id WHERE t0.clinicalManager_id = ?
Parameters:
[
  3
]
18 1.44 ms
SELECT t0.phone_number AS phone_number_1, t0.street AS street_2, t0.company AS company_3, t0.city AS city_4, t0.postcode AS postcode_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.country_code AS country_code_8, t0.province_code AS province_code_9, t0.province_name AS province_name_10, t0.id AS id_11, t0.id_sage AS id_sage_12, t0.type AS type_13, t0.first_name AS first_name_14, t0.last_name AS last_name_15, t0.customer_id AS customer_id_16 FROM sylius_address t0 WHERE t0.customer_id = ? ORDER BY t0.id ASC
Parameters:
[
  2919
]
19 2.54 ms
SELECT t0.id AS id_1, t0.reduction_type AS reduction_type_2, t0.reduction_value AS reduction_value_3, t0.archived AS archived_4, t0.archived_at AS archived_at_5, t0.createdAt AS createdAt_6, t0.updatedAt AS updatedAt_7, t0.customer_id AS customer_id_8, t0.archived_by AS archived_by_9 FROM app_reduction_taxon t0 WHERE t0.customer_id = ?
Parameters:
[
  2919
]
20 2.88 ms
SELECT t0.id AS id_1, t0.reduction_type AS reduction_type_2, t0.reduction_value AS reduction_value_3, t0.archived AS archived_4, t0.archived_at AS archived_at_5, t0.createdAt AS createdAt_6, t0.updatedAt AS updatedAt_7, t0.customer_id AS customer_id_8, t0.archived_by AS archived_by_9 FROM app_reduction_product t0 WHERE t0.customer_id = ?
Parameters:
[
  2919
]
21 0.74 ms
SELECT t0.id AS id_1, t0.requires_validation_by_clinical_manager AS requires_validation_by_clinical_manager_2, t0.makes_appointments_on_external_platform AS makes_appointments_on_external_platform_3, t0.external_platform_name AS external_platform_name_4, t0.external_platform_link AS external_platform_link_5, t0.can_access_to_doctor_dashboard AS can_access_to_doctor_dashboard_6, t0.send_transactional_emails AS send_transactional_emails_7, t0.longitude AS longitude_8, t0.latitude AS latitude_9, t0.app_access_seriderm_360 AS app_access_seriderm_360_10, t0.createdAt AS createdAt_11, t0.updatedAt AS updatedAt_12, t13.email AS email_14, t13.email_canonical AS email_canonical_15, t13.first_name AS first_name_16, t13.last_name AS last_name_17, t13.birthday AS birthday_18, t13.gender AS gender_19, t13.created_at AS created_at_20, t13.updated_at AS updated_at_21, t13.phone_number AS phone_number_22, t13.subscribed_to_newsletter AS subscribed_to_newsletter_23, t13.id AS id_24, t13.social_reason AS social_reason_25, t13.inter_community_tva_number AS inter_community_tva_number_26, t13.secondary_emails AS secondary_emails_27, t13.city AS city_28, t13.country AS country_29, t13.company AS company_30, t13.id_sage AS id_sage_31, t13.number_orders AS number_orders_32, t13.turnover AS turnover_33, t13.customer_group_id AS customer_group_id_34, t13.adminUser_id AS adminUser_id_35, t13.doctor_id AS doctor_id_36, t13.patient_id AS patient_id_37, t13.distributor_id AS distributor_id_38, t13.clinicalManager_id AS clinicalManager_id_39, t13.attached_pdm_id AS attached_pdm_id_40, t13.default_address_id AS default_address_id_41, t0.attached_clinical_manager_id AS attached_clinical_manager_id_42 FROM app_doctor t0 LEFT JOIN sylius_customer t13 ON t13.doctor_id = t0.id WHERE t0.id = ?
Parameters:
[
  2871
]
22 13.53 ms
SELECT t0.id AS id_1, t0.prevention AS prevention_2, t0.correction AS correction_3, t0.reparation AS reparation_4, t0.nbr_treatment_start AS nbr_treatment_start_5, t0.nbr_treatment_middle AS nbr_treatment_middle_6, t0.nbr_treatment_end AS nbr_treatment_end_7, t0.interval_between_treatments AS interval_between_treatments_8, t0.step AS step_9, t0.published AS published_10, t0.color AS color_11, t0.archived AS archived_12, t0.archived_at AS archived_at_13, t0.createdAt AS createdAt_14, t0.updatedAt AS updatedAt_15, t16.type AS type_17, t16.path AS path_18, t16.id AS id_19, t16.createdAt AS createdAt_20, t16.updatedAt AS updatedAt_21, t16.owner_id AS owner_id_22, t23.type AS type_24, t23.path AS path_25, t23.id AS id_26, t23.createdAt AS createdAt_27, t23.updatedAt AS updatedAt_28, t23.owner_id AS owner_id_29, t30.type AS type_31, t30.path AS path_32, t30.id AS id_33, t30.createdAt AS createdAt_34, t30.updatedAt AS updatedAt_35, t30.owner_id AS owner_id_36, t37.type AS type_38, t37.path AS path_39, t37.id AS id_40, t37.createdAt AS createdAt_41, t37.updatedAt AS updatedAt_42, t37.owner_id AS owner_id_43, t44.type AS type_45, t44.path AS path_46, t44.id AS id_47, t44.createdAt AS createdAt_48, t44.updatedAt AS updatedAt_49, t44.owner_id AS owner_id_50, t0.archived_by AS archived_by_51 FROM app_program t0 LEFT JOIN app_program_logo t16 ON t16.owner_id = t0.id LEFT JOIN app_program_suggested_image t23 ON t23.owner_id = t0.id LEFT JOIN app_program_detail_image t30 ON t30.owner_id = t0.id LEFT JOIN app_program_product_image t37 ON t37.owner_id = t0.id LEFT JOIN app_program_product_file t44 ON t44.owner_id = t0.id INNER JOIN app_doctor_program ON t0.id = app_doctor_program.program_id WHERE app_doctor_program.doctor_id = ?
Parameters:
[
  2871
]
23 1.41 ms
SELECT t0.code AS code_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.id AS id_6 FROM sylius_shipping_category t0
Parameters:
[]
24 0.58 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.haut_ai_dataset_id AS haut_ai_dataset_id_17, t0.send_payment_confirmation_email AS send_payment_confirmation_email_18, t0.default_locale_id AS default_locale_id_19, t20.code AS code_21, t20.created_at AS created_at_22, t20.updated_at AS updated_at_23, t20.id AS id_24, t0.base_currency_id AS base_currency_id_25, t26.code AS code_27, t26.created_at AS created_at_28, t26.updated_at AS updated_at_29, t26.id AS id_30, t0.default_tax_zone_id AS default_tax_zone_id_31, t0.menu_taxon_id AS menu_taxon_id_32, t0.clinical_chain_id AS clinical_chain_id_33, t0.shop_billing_data_id AS shop_billing_data_id_34 FROM sylius_channel t0 INNER JOIN sylius_locale t20 ON t0.default_locale_id = t20.id INNER JOIN sylius_currency t26 ON t0.base_currency_id = t26.id
Parameters:
[]
25 0.32 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:
[
  3
]
26 0.27 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:
[
  3
]
27 0.35 ms
SELECT t0.code AS code_1, t0.enabled AS enabled_2, t0.id AS id_3 FROM sylius_country t0 INNER JOIN sylius_channel_countries ON t0.id = sylius_channel_countries.country_id WHERE sylius_channel_countries.channel_id = ?
Parameters:
[
  3
]
28 0.30 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:
[
  4
]
29 0.24 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:
[
  4
]
30 0.23 ms
SELECT t0.code AS code_1, t0.enabled AS enabled_2, t0.id AS id_3 FROM sylius_country t0 INNER JOIN sylius_channel_countries ON t0.id = sylius_channel_countries.country_id WHERE sylius_channel_countries.channel_id = ?
Parameters:
[
  4
]
31 0.26 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:
[
  5
]
32 0.24 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:
[
  5
]
33 0.23 ms
SELECT t0.code AS code_1, t0.enabled AS enabled_2, t0.id AS id_3 FROM sylius_country t0 INNER JOIN sylius_channel_countries ON t0.id = sylius_channel_countries.country_id WHERE sylius_channel_countries.channel_id = ?
Parameters:
[
  5
]
34 0.26 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:
[
  6
]
35 0.23 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:
[
  6
]
36 0.25 ms
SELECT t0.code AS code_1, t0.enabled AS enabled_2, t0.id AS id_3 FROM sylius_country t0 INNER JOIN sylius_channel_countries ON t0.id = sylius_channel_countries.country_id WHERE sylius_channel_countries.channel_id = ?
Parameters:
[
  6
]
37 0.27 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:
[
  7
]
38 0.25 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:
[
  7
]
39 0.23 ms
SELECT t0.code AS code_1, t0.enabled AS enabled_2, t0.id AS id_3 FROM sylius_country t0 INNER JOIN sylius_channel_countries ON t0.id = sylius_channel_countries.country_id WHERE sylius_channel_countries.channel_id = ?
Parameters:
[
  7
]
40 0.27 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:
[
  8
]
41 0.28 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:
[
  8
]
42 0.25 ms
SELECT t0.code AS code_1, t0.enabled AS enabled_2, t0.id AS id_3 FROM sylius_country t0 INNER JOIN sylius_channel_countries ON t0.id = sylius_channel_countries.country_id WHERE sylius_channel_countries.channel_id = ?
Parameters:
[
  8
]
43 0.42 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.haut_ai_dataset_id AS haut_ai_dataset_id_17, t0.send_payment_confirmation_email AS send_payment_confirmation_email_18, t0.default_locale_id AS default_locale_id_19, t20.code AS code_21, t20.created_at AS created_at_22, t20.updated_at AS updated_at_23, t20.id AS id_24, t0.base_currency_id AS base_currency_id_25, t26.code AS code_27, t26.created_at AS created_at_28, t26.updated_at AS updated_at_29, t26.id AS id_30, t0.default_tax_zone_id AS default_tax_zone_id_31, t0.menu_taxon_id AS menu_taxon_id_32, t0.clinical_chain_id AS clinical_chain_id_33, t0.shop_billing_data_id AS shop_billing_data_id_34 FROM sylius_channel t0 INNER JOIN sylius_locale t20 ON t0.default_locale_id = t20.id INNER JOIN sylius_currency t26 ON t0.base_currency_id = t26.id
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.

Entities Mapping

Class Mapping errors
MonsieurBiz\SyliusCmsPagePlugin\Entity\Page No errors.
App\Entity\Treatment\Treatment No errors.
App\Entity\Treatment\TreatmentStep No errors.
Sylius\Component\Customer\Model\Customer No errors.
Sylius\Component\Core\Model\Customer No errors.
App\Entity\Customer\Customer No 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\User\Model\User No errors.
Sylius\Component\Core\Model\AdminUser No errors.
App\Entity\User\AdminUser No errors.
Sylius\Component\Customer\Model\CustomerGroup No errors.
App\Entity\Customer\CustomerGroup No errors.
App\Entity\Doctor\Doctor No errors.
App\Entity\Patient\Patient No errors.
App\Entity\Distributor\Distributor No errors.
App\Entity\ClinicalManager\ClinicalManager No errors.
Sylius\Component\Addressing\Model\Address No errors.
Sylius\Component\Core\Model\Address No errors.
App\Entity\Addressing\Address No errors.
Sylius\Component\Core\Model\Image No errors.
Sylius\Component\Core\Model\AvatarImage No errors.
BitBag\SyliusAclPlugin\Entity\Role No errors.
App\Entity\Refund\Refund No errors.
Sylius\Component\User\Model\UserOAuth No errors.
App\Entity\User\UserOAuth 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.
App\Entity\ClinicalChain\ClinicalChain No errors.
Sylius\Component\Core\Model\ShopBillingData No errors.
Sylius\Component\Addressing\Model\Country No errors.
App\Entity\Addressing\Country No errors.
Sylius\Component\Addressing\Model\Province No errors.
App\Entity\Addressing\Province No errors.
BitBag\SyliusAclPlugin\Entity\RoleTranslation No errors.
App\Entity\Customer\CustomerPhoto No errors.
App\Entity\Customer\CustomerSocialAccount No errors.
App\Entity\Wallet\Wallet No errors.
Sylius\Component\Core\Model\ShopUser No errors.
App\Entity\User\ShopUser No errors.
App\Entity\Product\ReductionProduct No errors.
App\Entity\Taxonomy\ReductionTaxon No errors.
App\Entity\Order\OrderRecurring No errors.
App\Entity\Customer\CustomerYearlyStatistic No errors.
App\Entity\Product\ProductCustomerStatistic No errors.
App\Entity\Customer\DeviceToken No errors.
TheCodingMachine\SogecommercePlugin\Entity\SogecommerceToken No errors.
App\Entity\User\VerificationToken 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\OrderItem No errors.
Sylius\Component\Core\Model\OrderItem No errors.
App\Entity\Order\OrderItem No errors.
Sylius\Component\Order\Model\OrderItemUnit No errors.
Sylius\Component\Core\Model\OrderItemUnit No errors.
App\Entity\Order\OrderItemUnit No errors.
Sylius\Component\Order\Model\OrderSequence No errors.
Sylius\Component\Core\Model\OrderSequence No errors.
App\Entity\Order\OrderSequence No errors.
Sylius\Component\Currency\Model\ExchangeRate No errors.
App\Entity\Currency\ExchangeRate 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\ProductTranslation No errors.
Sylius\Component\Core\Model\ProductTranslation No errors.
App\Entity\Product\ProductTranslation 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\ProductVariantTranslation No errors.
App\Entity\Product\ProductVariantTranslation No errors.
Sylius\Component\Product\Model\ProductOption No errors.
App\Entity\Product\ProductOption No errors.
Sylius\Component\Product\Model\ProductOptionTranslation No errors.
App\Entity\Product\ProductOptionTranslation No errors.
Sylius\Component\Product\Model\ProductAssociation No errors.
App\Entity\Product\ProductAssociation No errors.
Sylius\Component\Product\Model\ProductAssociationType No errors.
App\Entity\Product\ProductAssociationType No errors.
Sylius\Component\Product\Model\ProductAssociationTypeTranslation No errors.
App\Entity\Product\ProductAssociationTypeTranslation No errors.
Sylius\Component\Product\Model\ProductOptionValue No errors.
App\Entity\Product\ProductOptionValue 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\Attribute\Model\AttributeTranslation No errors.
Sylius\Component\Product\Model\ProductAttributeTranslation No errors.
App\Entity\Product\ProductAttributeTranslation No errors.
Sylius\Component\Attribute\Model\AttributeValue No errors.
Sylius\Component\Product\Model\ProductAttributeValue No errors.
App\Entity\Product\ProductAttributeValue No errors.
Sylius\Component\Taxation\Model\TaxRate No errors.
Sylius\Component\Core\Model\TaxRate No errors.
App\Entity\Taxation\TaxRate No errors.
Sylius\Component\Taxation\Model\TaxCategory No errors.
App\Entity\Taxation\TaxCategory No errors.
Sylius\Component\Shipping\Model\ShippingMethod No errors.
Sylius\Component\Core\Model\ShippingMethod No errors.
App\Entity\Shipping\ShippingMethod No errors.
Sylius\Component\Shipping\Model\ShippingMethodTranslation No errors.
App\Entity\Shipping\ShippingMethodTranslation No errors.
Sylius\Component\Shipping\Model\ShippingCategory No errors.
App\Entity\Shipping\ShippingCategory No errors.
Sylius\Component\Shipping\Model\ShippingMethodRule No errors.
Sylius\Component\Payment\Model\Payment No errors.
Sylius\Component\Core\Model\Payment No errors.
App\Entity\Payment\Payment No errors.
Sylius\Component\Payment\Model\PaymentMethod No errors.
Sylius\Component\Core\Model\PaymentMethod No errors.
App\Entity\Payment\PaymentMethod No errors.
Sylius\Component\Payment\Model\PaymentMethodTranslation No errors.
App\Entity\Payment\PaymentMethodTranslation No errors.
Sylius\Component\Promotion\Model\CatalogPromotion No errors.
Sylius\Component\Core\Model\CatalogPromotion No errors.
App\Entity\Promotion\CatalogPromotion No errors.
Sylius\Component\Promotion\Model\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\Promotion No errors.
Sylius\Component\Core\Model\Promotion No errors.
App\Entity\Promotion\Promotion No errors.
Sylius\Component\Promotion\Model\PromotionCoupon No errors.
Sylius\Component\Core\Model\PromotionCoupon No errors.
App\Entity\Promotion\PromotionCoupon No errors.
Sylius\Component\Promotion\Model\CatalogPromotionAction No errors.
App\Entity\Promotion\CatalogPromotionAction 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\Addressing\Model\AddressLogEntry No errors.
Sylius\Component\Addressing\Model\ZoneMember No errors.
App\Entity\Addressing\ZoneMember No errors.
Sylius\Component\Taxonomy\Model\TaxonTranslation No errors.
App\Entity\Taxonomy\TaxonTranslation 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\ProductTaxon No errors.
App\Entity\Product\ProductTaxon No errors.
Sylius\Component\Core\Model\ProductImage No errors.
App\Entity\Product\ProductImage No errors.
Sylius\Component\Core\Model\TaxonImage No errors.
App\Entity\Taxonomy\TaxonImage No errors.
Sylius\Component\Core\Model\ChannelPricing No errors.
App\Entity\Channel\ChannelPricing No errors.
App\Entity\ApiLogger\ApiLogger No errors.
App\Entity\Appointment\Appointment No errors.
App\Entity\CGU\Cgu No errors.
App\Entity\CGU\CguTranslation No errors.
App\Entity\ClinicalChain\ClinicalChainTranslation No errors.
App\Entity\ClinicalChain\ClinicalChainLogo No errors.
App\Entity\Diagnosis\Diagnosis No errors.
App\Entity\Diagnosis\DiagnosisPhoto No errors.
App\Entity\Doctor\DoctorChangeSatisfactionSurvey No errors.
App\Entity\Faq\Faq No errors.
App\Entity\Faq\FaqTranslation No errors.
App\Entity\HautAi\HautAiCredential No errors.
App\Entity\Notification\Notification No errors.
App\Entity\Notification\PatientNotification No errors.
App\Entity\Order\OrderItemRecurring No errors.
App\Entity\Patient\PatientProgram No errors.
App\Entity\Product\ProductBatch No errors.
App\Entity\Product\ProductBatchOrderItem No errors.
App\Entity\Program\Program No errors.
App\Entity\Program\ProgramTranslation No errors.
App\Entity\Program\ProgramVersion No errors.
App\Entity\Program\ProgramVersionTranslation No errors.
App\Entity\Program\ProgramLogo No errors.
App\Entity\Program\ProgramVersionProductFile No errors.
App\Entity\Program\ProgramVersionLogo No errors.
App\Entity\Program\ProgramDoctorBoxNumber No errors.
App\Entity\Program\ProgramProductImage No errors.
App\Entity\Program\ProgramVersionProductImage No errors.
App\Entity\Program\ProgramProductFile No errors.
App\Entity\Program\ProgramDetailImage No errors.
App\Entity\Program\ProgramSuggestedImage No errors.
App\Entity\Question\Question No errors.
App\Entity\Question\QuestionTranslation No errors.
App\Entity\Question\Response No errors.
App\Entity\Question\ResponseTranslation No errors.
App\Entity\Question\Coefficient No errors.
App\Entity\Quiz\Quiz No errors.
App\Entity\Refund\RefundOrder No errors.
App\Entity\Treatment\TreatmentStepTranslation No errors.
App\Entity\Treatment\TreatmentStepImage No errors.
App\Entity\Treatment\TreatmentStepTranslationVideo No errors.
App\Entity\Wallet\LoyaltyTransaction No errors.
App\Entity\Wallet\QRCodeScan No errors.
App\Entity\Wallet\WalletRevenueLog No errors.
MonsieurBiz\SyliusCmsPagePlugin\Entity\PageTranslation No errors.
App\Entity\Customer\CustomerMonthlyStatistic No errors.
Synolia\SyliusSchedulerCommandPlugin\Entity\Command No errors.
Synolia\SyliusSchedulerCommandPlugin\Entity\ScheduledCommand No errors.
Sylius\Bundle\PayumBundle\Model\PaymentSecurityToken No errors.
App\Entity\Payment\PaymentSecurityToken No errors.
Payum\Core\Model\GatewayConfig No errors.
Sylius\Bundle\PayumBundle\Model\GatewayConfig No errors.
App\Entity\Payment\GatewayConfig No errors.