1
1.78 ms
SELECT t0 . username AS username_1 , t0 . username_canonical AS username_canonical_2 , t0 . enabled AS enabled_3 , t0 . password AS password_4 , t0 . last_login AS last_login_5 , t0 . password_reset_token AS password_reset_token_6 , t0 . password_requested_at AS password_requested_at_7 , t0 . email_verification_token AS email_verification_token_8 , t0 . verified_at AS verified_at_9 , t0 . roles AS roles_10 , t0 . email AS email_11 , t0 . email_canonical AS email_canonical_12 , t0 . created_at AS created_at_13 , t0 . updated_at AS updated_at_14 , t0 . id AS id_15 , t0 . first_name AS first_name_16 , t0 . last_name AS last_name_17 , t0 . locale_code AS locale_code_18 , t0 . mollie_onboarding_completed AS mollie_onboarding_completed_19 , t20 . type AS type_21 , t20 . path AS path_22 , t20 . id AS id_23 , t20 . owner_id AS owner_id_24 FROM sylius_admin_user t0 LEFT JOIN sylius_avatar_image t20 ON t20 . owner_id = t0 . id WHERE t0 . id = ?
SELECT t0 . username AS username_1 , t0 . username_canonical AS username_canonical_2 , t0 . enabled AS enabled_3 , t0 . password AS password_4 , t0 . last_login AS last_login_5 , t0 . password_reset_token AS password_reset_token_6 , t0 . password_requested_at AS password_requested_at_7 , t0 . email_verification_token AS email_verification_token_8 , t0 . verified_at AS verified_at_9 , t0 . roles AS roles_10 , t0 . email AS email_11 , t0 . email_canonical AS email_canonical_12 , t0 . created_at AS created_at_13 , t0 . updated_at AS updated_at_14 , t0 . id AS id_15 , t0 . first_name AS first_name_16 , t0 . last_name AS last_name_17 , t0 . locale_code AS locale_code_18 , t0 . mollie_onboarding_completed AS mollie_onboarding_completed_19 , t20 . type AS type_21 , t20 . path AS path_22 , t20 . id AS id_23 , t20 . owner_id AS owner_id_24 FROM sylius_admin_user t0 LEFT JOIN sylius_avatar_image t20 ON t20 . owner_id = t0 . id WHERE t0 . id = 1 ;
Copy
2
1.59 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 :
[
"dimaco-back-preprod.kwantic.dev "
1
]
SELECT t0 . code AS code_1 , t0 . name AS name_2 , t0 . color AS color_3 , t0 . description AS description_4 , t0 . enabled AS enabled_5 , t0 . hostname AS hostname_6 , t0 . created_at AS created_at_7 , t0 . updated_at AS updated_at_8 , t0 . id AS id_9 , t0 . theme_name AS theme_name_10 , t0 . tax_calculation_strategy AS tax_calculation_strategy_11 , t0 . contact_email AS contact_email_12 , t0 . contact_phone_number AS contact_phone_number_13 , t0 . skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14 , t0 . skipping_payment_step_allowed AS skipping_payment_step_allowed_15 , t0 . account_verification_required AS account_verification_required_16 , t0 . shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17 , t0 . default_locale_id AS default_locale_id_18 , t19 . code AS code_20 , t19 . created_at AS created_at_21 , t19 . updated_at AS updated_at_22 , t19 . id AS id_23 , t0 . base_currency_id AS base_currency_id_24 , t25 . code AS code_26 , t25 . created_at AS created_at_27 , t25 . updated_at AS updated_at_28 , t25 . id AS id_29 , t0 . default_tax_zone_id AS default_tax_zone_id_30 , t0 . menu_taxon_id AS menu_taxon_id_31 , t0 . shop_billing_data_id AS shop_billing_data_id_32 , t0 . channel_price_history_config_id AS channel_price_history_config_id_33 FROM sylius_channel t0 INNER JOIN sylius_locale t19 ON t0 . default_locale_id = t19 . id INNER JOIN sylius_currency t25 ON t0 . base_currency_id = t25 . id WHERE t0 . hostname = 'dimaco-back-preprod.kwantic.dev' AND t0 . enabled = 1 ORDER BY t0 . id ASC LIMIT 1 ;
Copy
3
1.53 ms
SELECT DISTINCT id_14 FROM (SELECT DISTINCT id_14 , created_at_12 FROM (SELECT s0_ . username AS username_0 , s0_ . username_canonical AS username_canonical_1 , s0_ . enabled AS enabled_2 , s0_ . password AS password_3 , s0_ . last_login AS last_login_4 , s0_ . password_reset_token AS password_reset_token_5 , s0_ . password_requested_at AS password_requested_at_6 , s0_ . email_verification_token AS email_verification_token_7 , s0_ . verified_at AS verified_at_8 , s0_ . roles AS roles_9 , s0_ . email AS email_10 , s0_ . email_canonical AS email_canonical_11 , s0_ . created_at AS created_at_12 , s0_ . updated_at AS updated_at_13 , s0_ . id AS id_14 , s0_ . first_name AS first_name_15 , s0_ . last_name AS last_name_16 , s0_ . locale_code AS locale_code_17 , s0_ . mollie_onboarding_completed AS mollie_onboarding_completed_18 FROM sylius_admin_user s0_ ) dctrn_result_inner ORDER BY created_at_12 DESC , id_14 ASC ) dctrn_result LIMIT 10
SELECT DISTINCT id_14 FROM (SELECT DISTINCT id_14 , created_at_12 FROM (SELECT s0_ . username AS username_0 , s0_ . username_canonical AS username_canonical_1 , s0_ . enabled AS enabled_2 , s0_ . password AS password_3 , s0_ . last_login AS last_login_4 , s0_ . password_reset_token AS password_reset_token_5 , s0_ . password_requested_at AS password_requested_at_6 , s0_ . email_verification_token AS email_verification_token_7 , s0_ . verified_at AS verified_at_8 , s0_ . roles AS roles_9 , s0_ . email AS email_10 , s0_ . email_canonical AS email_canonical_11 , s0_ . created_at AS created_at_12 , s0_ . updated_at AS updated_at_13 , s0_ . id AS id_14 , s0_ . first_name AS first_name_15 , s0_ . last_name AS last_name_16 , s0_ . locale_code AS locale_code_17 , s0_ . mollie_onboarding_completed AS mollie_onboarding_completed_18 FROM sylius_admin_user s0_ ) dctrn_result_inner ORDER BY created_at_12 DESC , id_14 ASC ) dctrn_result LIMIT 10 ;
Copy
4
1.60 ms
SELECT s0_ . username AS username_0 , s0_ . username_canonical AS username_canonical_1 , s0_ . enabled AS enabled_2 , s0_ . password AS password_3 , s0_ . last_login AS last_login_4 , s0_ . password_reset_token AS password_reset_token_5 , s0_ . password_requested_at AS password_requested_at_6 , s0_ . email_verification_token AS email_verification_token_7 , s0_ . verified_at AS verified_at_8 , s0_ . roles AS roles_9 , s0_ . email AS email_10 , s0_ . email_canonical AS email_canonical_11 , s0_ . created_at AS created_at_12 , s0_ . updated_at AS updated_at_13 , s0_ . id AS id_14 , s0_ . first_name AS first_name_15 , s0_ . last_name AS last_name_16 , s0_ . locale_code AS locale_code_17 , s0_ . mollie_onboarding_completed AS mollie_onboarding_completed_18 FROM sylius_admin_user s0_ WHERE s0_ . id IN (? , ? ) ORDER BY s0_ . created_at DESC , s0_ . id ASC
SELECT s0_ . username AS username_0 , s0_ . username_canonical AS username_canonical_1 , s0_ . enabled AS enabled_2 , s0_ . password AS password_3 , s0_ . last_login AS last_login_4 , s0_ . password_reset_token AS password_reset_token_5 , s0_ . password_requested_at AS password_requested_at_6 , s0_ . email_verification_token AS email_verification_token_7 , s0_ . verified_at AS verified_at_8 , s0_ . roles AS roles_9 , s0_ . email AS email_10 , s0_ . email_canonical AS email_canonical_11 , s0_ . created_at AS created_at_12 , s0_ . updated_at AS updated_at_13 , s0_ . id AS id_14 , s0_ . first_name AS first_name_15 , s0_ . last_name AS last_name_16 , s0_ . locale_code AS locale_code_17 , s0_ . mollie_onboarding_completed AS mollie_onboarding_completed_18 FROM sylius_admin_user s0_ WHERE s0_ . id IN (2 , 1 ) ORDER BY s0_ . created_at DESC , s0_ . id ASC ;
Copy
5
0.58 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 = ?
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 = 2 ;
Copy
6
1.61 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 . enabled = ?
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 . enabled = 1 ;
Copy
7
1.05 ms
SELECT COUNT (* ) AS dctrn_count FROM (SELECT DISTINCT id_14 FROM (SELECT s0_ . username AS username_0 , s0_ . username_canonical AS username_canonical_1 , s0_ . enabled AS enabled_2 , s0_ . password AS password_3 , s0_ . last_login AS last_login_4 , s0_ . password_reset_token AS password_reset_token_5 , s0_ . password_requested_at AS password_requested_at_6 , s0_ . email_verification_token AS email_verification_token_7 , s0_ . verified_at AS verified_at_8 , s0_ . roles AS roles_9 , s0_ . email AS email_10 , s0_ . email_canonical AS email_canonical_11 , s0_ . created_at AS created_at_12 , s0_ . updated_at AS updated_at_13 , s0_ . id AS id_14 , s0_ . first_name AS first_name_15 , s0_ . last_name AS last_name_16 , s0_ . locale_code AS locale_code_17 , s0_ . mollie_onboarding_completed AS mollie_onboarding_completed_18 FROM sylius_admin_user s0_ ORDER BY s0_ . created_at DESC , s0_ . id ASC ) dctrn_result ) dctrn_table
SELECT COUNT (* ) AS dctrn_count FROM (SELECT DISTINCT id_14 FROM (SELECT s0_ . username AS username_0 , s0_ . username_canonical AS username_canonical_1 , s0_ . enabled AS enabled_2 , s0_ . password AS password_3 , s0_ . last_login AS last_login_4 , s0_ . password_reset_token AS password_reset_token_5 , s0_ . password_requested_at AS password_requested_at_6 , s0_ . email_verification_token AS email_verification_token_7 , s0_ . verified_at AS verified_at_8 , s0_ . roles AS roles_9 , s0_ . email AS email_10 , s0_ . email_canonical AS email_canonical_11 , s0_ . created_at AS created_at_12 , s0_ . updated_at AS updated_at_13 , s0_ . id AS id_14 , s0_ . first_name AS first_name_15 , s0_ . last_name AS last_name_16 , s0_ . locale_code AS locale_code_17 , s0_ . mollie_onboarding_completed AS mollie_onboarding_completed_18 FROM sylius_admin_user s0_ ORDER BY s0_ . created_at DESC , s0_ . id ASC ) dctrn_result ) dctrn_table ;
Copy