https://www.hephaestos.net/fr/register/

Query Metrics

15 Database Queries
12 Different statements
15.58 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
6.00 ms
(38.53%)
1
"COMMIT"
Parameters:
[]
2.89 ms
(18.56%)
3
SELECT s0_.number AS number_0, s0_.notes AS notes_1, s0_.state AS state_2, s0_.checkout_completed_at AS checkout_completed_at_3, s0_.items_total AS items_total_4, s0_.adjustments_total AS adjustments_total_5, s0_.total AS total_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.id AS id_9, s0_.currency_code AS currency_code_10, s0_.locale_code AS locale_code_11, s0_.checkout_state AS checkout_state_12, s0_.payment_state AS payment_state_13, s0_.shipping_state AS shipping_state_14, s0_.created_by_guest AS created_by_guest_15, s0_.token_value AS token_value_16, s0_.customer_ip AS customer_ip_17, s0_.channel_id AS channel_id_18, s0_.promotion_coupon_id AS promotion_coupon_id_19, s0_.customer_id AS customer_id_20, s0_.shipping_address_id AS shipping_address_id_21, s0_.billing_address_id AS billing_address_id_22 FROM sylius_order s0_ WHERE s0_.state = ? AND s0_.channel_id = ? AND s0_.customer_id = ? AND (SELECT COUNT(*) FROM sylius_order_item s1_ WHERE s1_.order_id = s0_.id) > 0 AND s0_.created_by_guest = ? ORDER BY s0_.created_at DESC, s0_.id ASC LIMIT 1
Parameters:
[
  "cart"
  1
  5392
  0
]
1.34 ms
(8.59%)
2
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.default_locale_id AS default_locale_id_17, t18.code AS code_19, t18.created_at AS created_at_20, t18.updated_at AS updated_at_21, t18.id AS id_22, t0.base_currency_id AS base_currency_id_23, t24.code AS code_25, t24.created_at AS created_at_26, t24.updated_at AS updated_at_27, t24.id AS id_28, t0.default_tax_zone_id AS default_tax_zone_id_29, t0.menu_taxon_id AS menu_taxon_id_30, t0.shop_billing_data_id AS shop_billing_data_id_31 FROM sylius_channel t0 INNER JOIN sylius_locale t18 ON t0.default_locale_id = t18.id INNER JOIN sylius_currency t24 ON t0.base_currency_id = t24.id
Parameters:
[]
1.05 ms
(6.75%)
1
SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.contact_phone_number AS contact_phone_number_13, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15, t0.account_verification_required AS account_verification_required_16, t0.default_locale_id AS default_locale_id_17, t18.code AS code_19, t18.created_at AS created_at_20, t18.updated_at AS updated_at_21, t18.id AS id_22, t0.base_currency_id AS base_currency_id_23, t24.code AS code_25, t24.created_at AS created_at_26, t24.updated_at AS updated_at_27, t24.id AS id_28, t0.default_tax_zone_id AS default_tax_zone_id_29, t0.menu_taxon_id AS menu_taxon_id_30, t0.shop_billing_data_id AS shop_billing_data_id_31 FROM sylius_channel t0 INNER JOIN sylius_locale t18 ON t0.default_locale_id = t18.id INNER JOIN sylius_currency t24 ON t0.base_currency_id = t24.id WHERE t0.hostname = ? AND t0.enabled = ? LIMIT 1
Parameters:
[
  "www.hephaestos.net"
  1
]
0.81 ms
(5.21%)
1
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_.customer_id AS customer_id_20 FROM sylius_shop_user s0_ INNER JOIN sylius_customer s1_ ON s0_.customer_id = s1_.id WHERE s1_.email_canonical = ? ORDER BY s0_.id ASC
Parameters:
[
  "henriforce579@gmail.com"
]
0.76 ms
(4.88%)
1
SELECT s0_.code AS code_0, s0_.name AS name_1, s0_.description AS description_2, s0_.priority AS priority_3, s0_.exclusive AS exclusive_4, s0_.usage_limit AS usage_limit_5, s0_.used AS used_6, s0_.coupon_based AS coupon_based_7, s0_.starts_at AS starts_at_8, s0_.ends_at AS ends_at_9, s0_.applies_to_discounted AS applies_to_discounted_10, s0_.created_at AS created_at_11, s0_.updated_at AS updated_at_12, s0_.id AS id_13 FROM sylius_promotion s0_ WHERE (s0_.starts_at IS NULL OR s0_.starts_at < ?) AND (s0_.ends_at IS NULL OR s0_.ends_at > ?) AND EXISTS (SELECT 1 FROM sylius_promotion_channels s1_ WHERE s1_.promotion_id = s0_.id AND s1_.channel_id IN (?)) ORDER BY s0_.priority DESC, s0_.id ASC
Parameters:
[
  "2024-12-22 12:16:20"
  "2024-12-22 12:16:20"
  1
]
0.75 ms
(4.78%)
1
SELECT t0.email AS email_1, t0.email_canonical AS email_canonical_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.birthday AS birthday_5, t0.gender AS gender_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.phone_number AS phone_number_9, t0.subscribed_to_newsletter AS subscribed_to_newsletter_10, t0.id AS id_11, t0.pseudo AS pseudo_12, t0.customer_group_id AS customer_group_id_13, t0.default_address_id AS default_address_id_14, t15.username AS username_16, t15.username_canonical AS username_canonical_17, t15.enabled AS enabled_18, t15.salt AS salt_19, t15.password AS password_20, t15.encoder_name AS encoder_name_21, t15.last_login AS last_login_22, t15.password_reset_token AS password_reset_token_23, t15.password_requested_at AS password_requested_at_24, t15.email_verification_token AS email_verification_token_25, t15.verified_at AS verified_at_26, t15.locked AS locked_27, t15.expires_at AS expires_at_28, t15.credentials_expire_at AS credentials_expire_at_29, t15.roles AS roles_30, t15.email AS email_31, t15.email_canonical AS email_canonical_32, t15.created_at AS created_at_33, t15.updated_at AS updated_at_34, t15.id AS id_35, t15.customer_id AS customer_id_36 FROM sylius_customer t0 LEFT JOIN sylius_shop_user t15 ON t15.customer_id = t0.id WHERE t0.id = ?
Parameters:
[
  5392
]
0.71 ms
(4.54%)
1
UPDATE sylius_shop_user SET last_login = ?, updated_at = ? WHERE id = ?
Parameters:
[
  "2024-12-22 12:16:20"
  "2024-12-22 12:16:20"
  9400
]
0.46 ms
(2.96%)
1
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM sylius_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
]
0.35 ms
(2.27%)
1
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:
[
  1
]
0.35 ms
(2.22%)
1
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM sylius_locale t0 INNER JOIN sylius_channel_locales ON t0.id = sylius_channel_locales.locale_id WHERE sylius_channel_locales.channel_id = ?
Parameters:
[
  1
]
0.11 ms
(0.72%)
1
"START TRANSACTION"
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
Sylius\Component\Order\Model\Order No errors.
Sylius\Component\Core\Model\Order No errors.
App\Entity\Order\Order 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.
Sylius\Component\Addressing\Model\Country No errors.
App\Entity\Addressing\Country No errors.
Sylius\Component\User\Model\User No errors.
Sylius\Component\Core\Model\ShopUser No errors.
App\Entity\User\ShopUser No errors.
Sylius\Component\Customer\Model\Customer No errors.
Sylius\Component\Core\Model\Customer No errors.
App\Entity\Customer\Customer No errors.
App\Entity\LicenceFile No errors.
Sylius\Component\User\Model\UserOAuth No errors.
App\Entity\User\UserOAuth No errors.
Sylius\Component\Shipping\Model\ShippingMethod No errors.
Sylius\Component\Core\Model\ShippingMethod No errors.
App\Entity\Shipping\ShippingMethod No errors.
Sylius\Component\Promotion\Model\Promotion No errors.
Sylius\Component\Core\Model\Promotion No errors.
App\Entity\Promotion\Promotion 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\Promotion\Model\PromotionCoupon No errors.
Sylius\Component\Core\Model\PromotionCoupon No errors.
App\Entity\Promotion\PromotionCoupon No errors.
Sylius\Component\Addressing\Model\Address No errors.
Sylius\Component\Core\Model\Address No errors.
App\Entity\Addressing\Address No errors.
Sylius\Component\Order\Model\OrderItem No errors.
Sylius\Component\Core\Model\OrderItem No errors.
App\Entity\Order\OrderItem No errors.
Sylius\Component\Customer\Model\CustomerGroup No errors.
App\Entity\Customer\CustomerGroup No errors.
BitBag\SyliusCmsPlugin\Entity\Block No errors.
BitBag\SyliusCmsPlugin\Entity\Media No errors.
BitBag\SyliusCmsPlugin\Entity\Page No errors.