https://webstore-rec.seriderm.com/api/v2/admin/customers

Query Metrics

32 Database Queries
12 Different statements
125.58 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.62 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_ WHERE s0_.email_canonical = ? ORDER BY s0_.id ASC
Parameters:
[
  "api@admin.com"
]
2 0.81 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:
[
  2
]
3 0.28 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:
[
  2
]
4 9.47 ms
"START TRANSACTION"
Parameters:
[]
5 0.86 ms
UPDATE sylius_admin_user SET last_login = ?, updated_at = ? WHERE id = ?
Parameters:
[
  "2026-03-17 11:51:15"
  "2026-03-17 11:51:15"
  2
]
6 54.12 ms
"COMMIT"
Parameters:
[]
7 6.14 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
]
8 3.38 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
]
9 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:
[
  2
]
10 1.51 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
]
11 1.69 ms
"START TRANSACTION"
Parameters:
[]
12 2.76 ms
INSERT INTO app_api_logger (name, request_url, request_body, response, status_code, createdAt, updatedAt) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1 => "UpsertCustomerAction"
  2 => "https://webstore-rec.seriderm.com/api/v2/admin/customers"
  3 => "{"idSage":"CSAMSONO","group":"doctor","email":"","name":"Samrigil SAS","phoneNumber":"09 67 37 08 17","socialReason":"Samrigil SAS","interCommunityTvaNumber":"FR90508350642","city":"Saint -Raphael","country":"FR","addresses":[{"idSage":"698","name":"SAMRIGIL - Dr Olivier SAMSON","phoneNumber":"","street":"78 rue Waldeck Rousseau","city":"Saint -Raphael","postCode":"83700","countryCode":"FR"}],"reductionTaxons":[],"reductionProducts":[]}"
  4 => "["The email is not valid"]"
  5 => 400
  6 => "2026-03-17 11:51:16"
  7 => "2026-03-17 11:51:16"
]
13 3.30 ms
"COMMIT"
Parameters:
[]
14 13.24 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:
[]
15 2.38 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
]
16 3.41 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
]
17 3.73 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
]
18 0.60 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
]
19 2.45 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
]
20 3.95 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
]
21 1.45 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
]
22 2.45 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
]
23 3.84 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
]
24 0.82 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
]
25 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_locale t0 INNER JOIN sylius_channel_locales ON t0.id = sylius_channel_locales.locale_id WHERE sylius_channel_locales.channel_id = ?
Parameters:
[
  6
]
26 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:
[
  6
]
27 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:
[
  7
]
28 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:
[
  7
]
29 0.24 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
]
30 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
]
31 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:
[
  8
]
32 0.30 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
]

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.
BitBag\SyliusAclPlugin\Entity\Role 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\Core\Model\Image No errors.
App\Entity\Customer\CustomerPhoto No errors.
App\Entity\Customer\CustomerSocialAccount No errors.
App\Entity\Wallet\Wallet 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\ShopUser No errors.
App\Entity\User\ShopUser No errors.
App\Entity\Refund\Refund No errors.
Sylius\Component\Core\Model\AvatarImage No errors.
Sylius\Component\User\Model\UserOAuth No errors.
App\Entity\User\UserOAuth No errors.
App\Entity\Wallet\LoyaltyTransaction No errors.
Sylius\Component\Shipping\Model\ShippingMethod No errors.
Sylius\Component\Core\Model\ShippingMethod No errors.
App\Entity\Shipping\ShippingMethod No errors.
Sylius\Component\Addressing\Model\Zone No errors.
App\Entity\Addressing\Zone No errors.
Sylius\Component\Promotion\Model\Promotion No errors.
Sylius\Component\Core\Model\Promotion No errors.
App\Entity\Promotion\Promotion No errors.
Sylius\Component\Addressing\Model\Country No errors.
App\Entity\Addressing\Country No errors.
Sylius\Component\Taxonomy\Model\Taxon No errors.
Sylius\Component\Core\Model\Taxon No errors.
App\Entity\Taxonomy\Taxon No errors.
Sylius\Component\Currency\Model\ExchangeRate No errors.
App\Entity\Currency\ExchangeRate No errors.
Sylius\Component\Taxation\Model\TaxRate No errors.
Sylius\Component\Core\Model\TaxRate No errors.
App\Entity\Taxation\TaxRate No errors.
Sylius\Component\Payment\Model\PaymentMethod No errors.
Sylius\Component\Core\Model\PaymentMethod No errors.
App\Entity\Payment\PaymentMethod 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.
App\Entity\ClinicalChain\ClinicalChain No errors.
Sylius\Component\Core\Model\ShopBillingData No errors.
Sylius\Component\Addressing\Model\Province No errors.
App\Entity\Addressing\Province No errors.
Sylius\Component\Product\Model\Product No errors.
Sylius\Component\Core\Model\Product No errors.
App\Entity\Product\Product No errors.
App\Entity\ApiLogger\ApiLogger No errors.