Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

25 Database Queries

10 Different statements

33.88 ms Query time

0 Invalid entities

Queries

Group similar statements


SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.ui_label AS ui_label_2, s0_.value AS value_3, s0_.readonly AS readonly_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6 FROM setting s0_ WHERE s0_.name = ? LIMIT 1
SELECT count(DISTINCT u0_.id) AS sclr_0 FROM users u0_ WHERE (u0_.active = 1) AND u0_.dtype IN ('shop')
SELECT DISTINCT u0_.id AS id_0, u0_.position_index AS position_index_1 FROM users u0_ WHERE (u0_.active = 1) AND u0_.dtype IN ('shop') ORDER BY u0_.position_index ASC LIMIT 16
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.active AS active_4, u0_.created_at AS created_at_5, u0_.updated_at AS updated_at_6, u0_.`key` AS key_7, u0_.secret AS secret_8, u0_.shipping_confirmation_required AS shipping_confirmation_required_9, u0_.calculation_strategy AS calculation_strategy_10, u0_.developer_password AS developer_password_11, u0_.allowed_products AS allowed_products_12, u0_.position_index AS position_index_13, u0_.dtype AS dtype_14, u0_.receiving_bank_account_id AS receiving_bank_account_id_15, u0_.sending_bank_account_id AS sending_bank_account_id_16, u0_.api_token_id AS api_token_id_17 FROM users u0_ WHERE (u0_.active = 1 AND u0_.id IN (?)) AND u0_.dtype IN ('shop') ORDER BY u0_.position_index ASC
SELECT t0.id AS id_1, t0.address AS address_2, t0.contact AS contact_3, t0.phone1 AS phone1_4, t0.phone2 AS phone2_5, t0.phone3 AS phone3_6, t0.email2 AS email2_7, t0.email3 AS email3_8, t0.name AS name_9, t0.company_name AS company_name_10, t0.web_address AS web_address_11, t0.callback_url AS callback_url_12, t0.pay_now_commission_percent AS pay_now_commission_percent_13, t0.pay_later_commission_percent AS pay_later_commission_percent_14, t0.instalment_commission_percent AS instalment_commission_percent_15, t0.pay_later_v2_commission_percent AS pay_later_v2_commission_percent_16, t0.instalment4_commission_percent AS instalment4_commission_percent_17, t0.instalment6_commission_percent AS instalment6_commission_percent_18, t0.eik AS eik_19, t0.purchase_expiration_hours AS purchase_expiration_hours_20, t0.unshipped_purchase_days AS unshipped_purchase_days_21, t0.pay_now_allowed AS pay_now_allowed_22, t0.purchase_to_be_paid_days AS purchase_to_be_paid_days_23, t0.minimum_amount_for_payment AS minimum_amount_for_payment_24, t0.platform AS platform_25, t0.grace_start_date AS grace_start_date_26, t0.grace_duration_days AS grace_duration_days_27, t0.purchase_finalised_redirect_timer_seconds AS purchase_finalised_redirect_timer_seconds_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.cover_image_id AS cover_image_id_31, t0.shop_id AS shop_id_32 FROM shop_profile t0 WHERE t0.shop_id = ?
SELECT t0.id AS id_1, t0.percent AS percent_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.shop_id AS shop_id_7 FROM instalment6_interest_rate_promotion t0 WHERE t0.shop_id = ?
SELECT t0.id AS id_1, t0.address AS address_2, t0.contact AS contact_3, t0.phone1 AS phone1_4, t0.phone2 AS phone2_5, t0.phone3 AS phone3_6, t0.email2 AS email2_7, t0.email3 AS email3_8, t0.name AS name_9, t0.company_name AS company_name_10, t0.web_address AS web_address_11, t0.callback_url AS callback_url_12, t0.pay_now_commission_percent AS pay_now_commission_percent_13, t0.pay_later_commission_percent AS pay_later_commission_percent_14, t0.instalment_commission_percent AS instalment_commission_percent_15, t0.pay_later_v2_commission_percent AS pay_later_v2_commission_percent_16, t0.instalment4_commission_percent AS instalment4_commission_percent_17, t0.instalment6_commission_percent AS instalment6_commission_percent_18, t0.eik AS eik_19, t0.purchase_expiration_hours AS purchase_expiration_hours_20, t0.unshipped_purchase_days AS unshipped_purchase_days_21, t0.pay_now_allowed AS pay_now_allowed_22, t0.purchase_to_be_paid_days AS purchase_to_be_paid_days_23, t0.minimum_amount_for_payment AS minimum_amount_for_payment_24, t0.platform AS platform_25, t0.grace_start_date AS grace_start_date_26, t0.grace_duration_days AS grace_duration_days_27, t0.purchase_finalised_redirect_timer_seconds AS purchase_finalised_redirect_timer_seconds_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.cover_image_id AS cover_image_id_31, t0.shop_id AS shop_id_32 FROM shop_profile t0 WHERE t0.shop_id = ?
SELECT t0.id AS id_1, t0.percent AS percent_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.shop_id AS shop_id_7 FROM instalment6_interest_rate_promotion t0 WHERE t0.shop_id = ?
SELECT t0.id AS id_1, t0.address AS address_2, t0.contact AS contact_3, t0.phone1 AS phone1_4, t0.phone2 AS phone2_5, t0.phone3 AS phone3_6, t0.email2 AS email2_7, t0.email3 AS email3_8, t0.name AS name_9, t0.company_name AS company_name_10, t0.web_address AS web_address_11, t0.callback_url AS callback_url_12, t0.pay_now_commission_percent AS pay_now_commission_percent_13, t0.pay_later_commission_percent AS pay_later_commission_percent_14, t0.instalment_commission_percent AS instalment_commission_percent_15, t0.pay_later_v2_commission_percent AS pay_later_v2_commission_percent_16, t0.instalment4_commission_percent AS instalment4_commission_percent_17, t0.instalment6_commission_percent AS instalment6_commission_percent_18, t0.eik AS eik_19, t0.purchase_expiration_hours AS purchase_expiration_hours_20, t0.unshipped_purchase_days AS unshipped_purchase_days_21, t0.pay_now_allowed AS pay_now_allowed_22, t0.purchase_to_be_paid_days AS purchase_to_be_paid_days_23, t0.minimum_amount_for_payment AS minimum_amount_for_payment_24, t0.platform AS platform_25, t0.grace_start_date AS grace_start_date_26, t0.grace_duration_days AS grace_duration_days_27, t0.purchase_finalised_redirect_timer_seconds AS purchase_finalised_redirect_timer_seconds_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.cover_image_id AS cover_image_id_31, t0.shop_id AS shop_id_32 FROM shop_profile t0 WHERE t0.shop_id = ?
SELECT t0.id AS id_1, t0.percent AS percent_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.shop_id AS shop_id_7 FROM instalment6_interest_rate_promotion t0 WHERE t0.shop_id = ?
SELECT t0.id AS id_1, t0.address AS address_2, t0.contact AS contact_3, t0.phone1 AS phone1_4, t0.phone2 AS phone2_5, t0.phone3 AS phone3_6, t0.email2 AS email2_7, t0.email3 AS email3_8, t0.name AS name_9, t0.company_name AS company_name_10, t0.web_address AS web_address_11, t0.callback_url AS callback_url_12, t0.pay_now_commission_percent AS pay_now_commission_percent_13, t0.pay_later_commission_percent AS pay_later_commission_percent_14, t0.instalment_commission_percent AS instalment_commission_percent_15, t0.pay_later_v2_commission_percent AS pay_later_v2_commission_percent_16, t0.instalment4_commission_percent AS instalment4_commission_percent_17, t0.instalment6_commission_percent AS instalment6_commission_percent_18, t0.eik AS eik_19, t0.purchase_expiration_hours AS purchase_expiration_hours_20, t0.unshipped_purchase_days AS unshipped_purchase_days_21, t0.pay_now_allowed AS pay_now_allowed_22, t0.purchase_to_be_paid_days AS purchase_to_be_paid_days_23, t0.minimum_amount_for_payment AS minimum_amount_for_payment_24, t0.platform AS platform_25, t0.grace_start_date AS grace_start_date_26, t0.grace_duration_days AS grace_duration_days_27, t0.purchase_finalised_redirect_timer_seconds AS purchase_finalised_redirect_timer_seconds_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.cover_image_id AS cover_image_id_31, t0.shop_id AS shop_id_32 FROM shop_profile t0 WHERE t0.shop_id = ?
SELECT t0.id AS id_1, t0.percent AS percent_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.shop_id AS shop_id_7 FROM instalment6_interest_rate_promotion t0 WHERE t0.shop_id = ?
SELECT t0.id AS id_1, t0.address AS address_2, t0.contact AS contact_3, t0.phone1 AS phone1_4, t0.phone2 AS phone2_5, t0.phone3 AS phone3_6, t0.email2 AS email2_7, t0.email3 AS email3_8, t0.name AS name_9, t0.company_name AS company_name_10, t0.web_address AS web_address_11, t0.callback_url AS callback_url_12, t0.pay_now_commission_percent AS pay_now_commission_percent_13, t0.pay_later_commission_percent AS pay_later_commission_percent_14, t0.instalment_commission_percent AS instalment_commission_percent_15, t0.pay_later_v2_commission_percent AS pay_later_v2_commission_percent_16, t0.instalment4_commission_percent AS instalment4_commission_percent_17, t0.instalment6_commission_percent AS instalment6_commission_percent_18, t0.eik AS eik_19, t0.purchase_expiration_hours AS purchase_expiration_hours_20, t0.unshipped_purchase_days AS unshipped_purchase_days_21, t0.pay_now_allowed AS pay_now_allowed_22, t0.purchase_to_be_paid_days AS purchase_to_be_paid_days_23, t0.minimum_amount_for_payment AS minimum_amount_for_payment_24, t0.platform AS platform_25, t0.grace_start_date AS grace_start_date_26, t0.grace_duration_days AS grace_duration_days_27, t0.purchase_finalised_redirect_timer_seconds AS purchase_finalised_redirect_timer_seconds_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.cover_image_id AS cover_image_id_31, t0.shop_id AS shop_id_32 FROM shop_profile t0 WHERE t0.shop_id = ?
SELECT t0.id AS id_1, t0.percent AS percent_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.shop_id AS shop_id_7 FROM instalment6_interest_rate_promotion t0 WHERE t0.shop_id = ?
SELECT t0.id AS id_1, t0.address AS address_2, t0.contact AS contact_3, t0.phone1 AS phone1_4, t0.phone2 AS phone2_5, t0.phone3 AS phone3_6, t0.email2 AS email2_7, t0.email3 AS email3_8, t0.name AS name_9, t0.company_name AS company_name_10, t0.web_address AS web_address_11, t0.callback_url AS callback_url_12, t0.pay_now_commission_percent AS pay_now_commission_percent_13, t0.pay_later_commission_percent AS pay_later_commission_percent_14, t0.instalment_commission_percent AS instalment_commission_percent_15, t0.pay_later_v2_commission_percent AS pay_later_v2_commission_percent_16, t0.instalment4_commission_percent AS instalment4_commission_percent_17, t0.instalment6_commission_percent AS instalment6_commission_percent_18, t0.eik AS eik_19, t0.purchase_expiration_hours AS purchase_expiration_hours_20, t0.unshipped_purchase_days AS unshipped_purchase_days_21, t0.pay_now_allowed AS pay_now_allowed_22, t0.purchase_to_be_paid_days AS purchase_to_be_paid_days_23, t0.minimum_amount_for_payment AS minimum_amount_for_payment_24, t0.platform AS platform_25, t0.grace_start_date AS grace_start_date_26, t0.grace_duration_days AS grace_duration_days_27, t0.purchase_finalised_redirect_timer_seconds AS purchase_finalised_redirect_timer_seconds_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.cover_image_id AS cover_image_id_31, t0.shop_id AS shop_id_32 FROM shop_profile t0 WHERE t0.shop_id = ?
SELECT t0.id AS id_1, t0.percent AS percent_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.shop_id AS shop_id_7 FROM instalment6_interest_rate_promotion t0 WHERE t0.shop_id = ?
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.active AS active_2, s0_.position_index AS position_index_3, s1_.id AS id_4, s1_.name AS name_5, s1_.active AS active_6, s1_.position_index AS position_index_7, s0_.parent_id AS parent_id_8, s1_.parent_id AS parent_id_9 FROM shop_category s0_ LEFT JOIN shop_category s1_ ON s0_.parent_id = s1_.id WHERE s0_.active = 1 ORDER BY s1_.position_index ASC, s0_.position_index ASC
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.`key` AS key_8, t0.secret AS secret_9, t0.shipping_confirmation_required AS shipping_confirmation_required_10, t0.calculation_strategy AS calculation_strategy_11, t0.developer_password AS developer_password_12, t0.allowed_products AS allowed_products_13, t0.position_index AS position_index_14, t0.receiving_bank_account_id AS receiving_bank_account_id_15, t0.sending_bank_account_id AS sending_bank_account_id_16, t18.id AS id_17, t18.address AS address_19, t18.contact AS contact_20, t18.phone1 AS phone1_21, t18.phone2 AS phone2_22, t18.phone3 AS phone3_23, t18.email2 AS email2_24, t18.email3 AS email3_25, t18.name AS name_26, t18.company_name AS company_name_27, t18.web_address AS web_address_28, t18.callback_url AS callback_url_29, t18.pay_now_commission_percent AS pay_now_commission_percent_30, t18.pay_later_commission_percent AS pay_later_commission_percent_31, t18.instalment_commission_percent AS instalment_commission_percent_32, t18.pay_later_v2_commission_percent AS pay_later_v2_commission_percent_33, t18.instalment4_commission_percent AS instalment4_commission_percent_34, t18.instalment6_commission_percent AS instalment6_commission_percent_35, t18.eik AS eik_36, t18.purchase_expiration_hours AS purchase_expiration_hours_37, t18.unshipped_purchase_days AS unshipped_purchase_days_38, t18.pay_now_allowed AS pay_now_allowed_39, t18.purchase_to_be_paid_days AS purchase_to_be_paid_days_40, t18.minimum_amount_for_payment AS minimum_amount_for_payment_41, t18.platform AS platform_42, t18.grace_start_date AS grace_start_date_43, t18.grace_duration_days AS grace_duration_days_44, t18.purchase_finalised_redirect_timer_seconds AS purchase_finalised_redirect_timer_seconds_45, t18.created_at AS created_at_46, t18.updated_at AS updated_at_47, t18.cover_image_id AS cover_image_id_48, t18.shop_id AS shop_id_49, t0.api_token_id AS api_token_id_50, t52.id AS id_51, t52.percent AS percent_53, t52.start_date AS start_date_54, t52.end_date AS end_date_55, t52.created_at AS created_at_56, t52.updated_at AS updated_at_57, t52.shop_id AS shop_id_58, t0.dtype FROM users t0 LEFT JOIN shop_profile t18 ON t18.shop_id = t0.id LEFT JOIN instalment6_interest_rate_promotion t52 ON t52.shop_id = t0.id INNER JOIN shop_shop_category ON t0.id = shop_shop_category.shop_id WHERE shop_shop_category.shop_category_id = ? AND t0.dtype IN ('shop')
SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.position_index AS position_index_4, t0.parent_id AS parent_id_5 FROM shop_category t0 WHERE t0.parent_id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.`key` AS key_8, t0.secret AS secret_9, t0.shipping_confirmation_required AS shipping_confirmation_required_10, t0.calculation_strategy AS calculation_strategy_11, t0.developer_password AS developer_password_12, t0.allowed_products AS allowed_products_13, t0.position_index AS position_index_14, t0.receiving_bank_account_id AS receiving_bank_account_id_15, t0.sending_bank_account_id AS sending_bank_account_id_16, t18.id AS id_17, t18.address AS address_19, t18.contact AS contact_20, t18.phone1 AS phone1_21, t18.phone2 AS phone2_22, t18.phone3 AS phone3_23, t18.email2 AS email2_24, t18.email3 AS email3_25, t18.name AS name_26, t18.company_name AS company_name_27, t18.web_address AS web_address_28, t18.callback_url AS callback_url_29, t18.pay_now_commission_percent AS pay_now_commission_percent_30, t18.pay_later_commission_percent AS pay_later_commission_percent_31, t18.instalment_commission_percent AS instalment_commission_percent_32, t18.pay_later_v2_commission_percent AS pay_later_v2_commission_percent_33, t18.instalment4_commission_percent AS instalment4_commission_percent_34, t18.instalment6_commission_percent AS instalment6_commission_percent_35, t18.eik AS eik_36, t18.purchase_expiration_hours AS purchase_expiration_hours_37, t18.unshipped_purchase_days AS unshipped_purchase_days_38, t18.pay_now_allowed AS pay_now_allowed_39, t18.purchase_to_be_paid_days AS purchase_to_be_paid_days_40, t18.minimum_amount_for_payment AS minimum_amount_for_payment_41, t18.platform AS platform_42, t18.grace_start_date AS grace_start_date_43, t18.grace_duration_days AS grace_duration_days_44, t18.purchase_finalised_redirect_timer_seconds AS purchase_finalised_redirect_timer_seconds_45, t18.created_at AS created_at_46, t18.updated_at AS updated_at_47, t18.cover_image_id AS cover_image_id_48, t18.shop_id AS shop_id_49, t0.api_token_id AS api_token_id_50, t52.id AS id_51, t52.percent AS percent_53, t52.start_date AS start_date_54, t52.end_date AS end_date_55, t52.created_at AS created_at_56, t52.updated_at AS updated_at_57, t52.shop_id AS shop_id_58, t0.dtype FROM users t0 LEFT JOIN shop_profile t18 ON t18.shop_id = t0.id LEFT JOIN instalment6_interest_rate_promotion t52 ON t52.shop_id = t0.id INNER JOIN shop_shop_category ON t0.id = shop_shop_category.shop_id WHERE shop_shop_category.shop_category_id = ? AND t0.dtype IN ('shop')
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.`key` AS key_8, t0.secret AS secret_9, t0.shipping_confirmation_required AS shipping_confirmation_required_10, t0.calculation_strategy AS calculation_strategy_11, t0.developer_password AS developer_password_12, t0.allowed_products AS allowed_products_13, t0.position_index AS position_index_14, t0.receiving_bank_account_id AS receiving_bank_account_id_15, t0.sending_bank_account_id AS sending_bank_account_id_16, t18.id AS id_17, t18.address AS address_19, t18.contact AS contact_20, t18.phone1 AS phone1_21, t18.phone2 AS phone2_22, t18.phone3 AS phone3_23, t18.email2 AS email2_24, t18.email3 AS email3_25, t18.name AS name_26, t18.company_name AS company_name_27, t18.web_address AS web_address_28, t18.callback_url AS callback_url_29, t18.pay_now_commission_percent AS pay_now_commission_percent_30, t18.pay_later_commission_percent AS pay_later_commission_percent_31, t18.instalment_commission_percent AS instalment_commission_percent_32, t18.pay_later_v2_commission_percent AS pay_later_v2_commission_percent_33, t18.instalment4_commission_percent AS instalment4_commission_percent_34, t18.instalment6_commission_percent AS instalment6_commission_percent_35, t18.eik AS eik_36, t18.purchase_expiration_hours AS purchase_expiration_hours_37, t18.unshipped_purchase_days AS unshipped_purchase_days_38, t18.pay_now_allowed AS pay_now_allowed_39, t18.purchase_to_be_paid_days AS purchase_to_be_paid_days_40, t18.minimum_amount_for_payment AS minimum_amount_for_payment_41, t18.platform AS platform_42, t18.grace_start_date AS grace_start_date_43, t18.grace_duration_days AS grace_duration_days_44, t18.purchase_finalised_redirect_timer_seconds AS purchase_finalised_redirect_timer_seconds_45, t18.created_at AS created_at_46, t18.updated_at AS updated_at_47, t18.cover_image_id AS cover_image_id_48, t18.shop_id AS shop_id_49, t0.api_token_id AS api_token_id_50, t52.id AS id_51, t52.percent AS percent_53, t52.start_date AS start_date_54, t52.end_date AS end_date_55, t52.created_at AS created_at_56, t52.updated_at AS updated_at_57, t52.shop_id AS shop_id_58, t0.dtype FROM users t0 LEFT JOIN shop_profile t18 ON t18.shop_id = t0.id LEFT JOIN instalment6_interest_rate_promotion t52 ON t52.shop_id = t0.id INNER JOIN shop_shop_category ON t0.id = shop_shop_category.shop_id WHERE shop_shop_category.shop_category_id = ? AND t0.dtype IN ('shop')
SELECT t0.id AS id_1, t0.name AS name_2, t0.mime AS mime_3, t0.size AS size_4, t0.original_name AS original_name_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.dtype FROM file t0 WHERE t0.id = ? AND t0.dtype IN ('image')
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.ui_label AS ui_label_2, s0_.value AS value_3, s0_.readonly AS readonly_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6 FROM setting s0_ WHERE s0_.name = ? LIMIT 1
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.ui_label AS ui_label_2, s0_.value AS value_3, s0_.readonly AS readonly_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6 FROM setting s0_ WHERE s0_.name = ? LIMIT 1
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.ui_label AS ui_label_2, s0_.value AS value_3, s0_.readonly AS readonly_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6 FROM setting s0_ WHERE s0_.name = ? LIMIT 1

#▲	Time	Info
1	3.12 ms	SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.ui_label AS ui_label_2, s0_.value AS value_3, s0_.readonly AS readonly_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6 FROM setting s0_ WHERE s0_.name = ? LIMIT 1 Parameters: [`"partners_per_page"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.ui_label AS ui_label_2, s0_.value AS value_3, s0_.readonly AS readonly_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6 FROM setting s0_ WHERE s0_.name = ? LIMIT 1 SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.ui_label AS ui_label_2, s0_.value AS value_3, s0_.readonly AS readonly_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6 FROM setting s0_ WHERE s0_.name = 'partners_per_page' LIMIT 1;
2	2.79 ms	SELECT count(DISTINCT u0_.id) AS sclr_0 FROM users u0_ WHERE (u0_.active = 1) AND u0_.dtype IN ('shop') Parameters: [] View formatted query View runnable query Explain query SELECT count(DISTINCT u0_.id) AS sclr_0 FROM users u0_ WHERE (u0_.active = 1) AND u0_.dtype IN ('shop') SELECT count(DISTINCT u0_.id) AS sclr_0 FROM users u0_ WHERE (u0_.active = 1) AND u0_.dtype IN ('shop');
3	0.84 ms	SELECT DISTINCT u0_.id AS id_0, u0_.position_index AS position_index_1 FROM users u0_ WHERE (u0_.active = 1) AND u0_.dtype IN ('shop') ORDER BY u0_.position_index ASC LIMIT 16 Parameters: [] View formatted query View runnable query Explain query SELECT DISTINCT u0_.id AS id_0, u0_.position_index AS position_index_1 FROM users u0_ WHERE (u0_.active = 1) AND u0_.dtype IN ('shop') ORDER BY u0_.position_index ASC LIMIT 16 SELECT DISTINCT u0_.id AS id_0, u0_.position_index AS position_index_1 FROM users u0_ WHERE (u0_.active = 1) AND u0_.dtype IN ('shop') ORDER BY u0_.position_index ASC LIMIT 16;
4	3.08 ms	SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.active AS active_4, u0_.created_at AS created_at_5, u0_.updated_at AS updated_at_6, u0_.`key` AS key_7, u0_.secret AS secret_8, u0_.shipping_confirmation_required AS shipping_confirmation_required_9, u0_.calculation_strategy AS calculation_strategy_10, u0_.developer_password AS developer_password_11, u0_.allowed_products AS allowed_products_12, u0_.position_index AS position_index_13, u0_.dtype AS dtype_14, u0_.receiving_bank_account_id AS receiving_bank_account_id_15, u0_.sending_bank_account_id AS sending_bank_account_id_16, u0_.api_token_id AS api_token_id_17 FROM users u0_ WHERE (u0_.active = 1 AND u0_.id IN (?)) AND u0_.dtype IN ('shop') ORDER BY u0_.position_index ASC Parameters: [`[ 10 9 14 12 11 13 ]`] View formatted query View runnable query Explain query SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.active AS active_4, u0_.created_at AS created_at_5, u0_.updated_at AS updated_at_6, u0_.`key` AS key_7, u0_.secret AS secret_8, u0_.shipping_confirmation_required AS shipping_confirmation_required_9, u0_.calculation_strategy AS calculation_strategy_10, u0_.developer_password AS developer_password_11, u0_.allowed_products AS allowed_products_12, u0_.position_index AS position_index_13, u0_.dtype AS dtype_14, u0_.receiving_bank_account_id AS receiving_bank_account_id_15, u0_.sending_bank_account_id AS sending_bank_account_id_16, u0_.api_token_id AS api_token_id_17 FROM users u0_ WHERE ( u0_.active = 1 AND u0_.id IN (?) ) AND u0_.dtype IN ('shop') ORDER BY u0_.position_index ASC SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.active AS active_4, u0_.created_at AS created_at_5, u0_.updated_at AS updated_at_6, u0_.`key` AS key_7, u0_.secret AS secret_8, u0_.shipping_confirmation_required AS shipping_confirmation_required_9, u0_.calculation_strategy AS calculation_strategy_10, u0_.developer_password AS developer_password_11, u0_.allowed_products AS allowed_products_12, u0_.position_index AS position_index_13, u0_.dtype AS dtype_14, u0_.receiving_bank_account_id AS receiving_bank_account_id_15, u0_.sending_bank_account_id AS sending_bank_account_id_16, u0_.api_token_id AS api_token_id_17 FROM users u0_ WHERE (u0_.active = 1 AND u0_.id IN (10, 9, 14, 12, 11, 13)) AND u0_.dtype IN ('shop') ORDER BY u0_.position_index ASC;
5	1.94 ms	SELECT t0.id AS id_1, t0.address AS address_2, t0.contact AS contact_3, t0.phone1 AS phone1_4, t0.phone2 AS phone2_5, t0.phone3 AS phone3_6, t0.email2 AS email2_7, t0.email3 AS email3_8, t0.name AS name_9, t0.company_name AS company_name_10, t0.web_address AS web_address_11, t0.callback_url AS callback_url_12, t0.pay_now_commission_percent AS pay_now_commission_percent_13, t0.pay_later_commission_percent AS pay_later_commission_percent_14, t0.instalment_commission_percent AS instalment_commission_percent_15, t0.pay_later_v2_commission_percent AS pay_later_v2_commission_percent_16, t0.instalment4_commission_percent AS instalment4_commission_percent_17, t0.instalment6_commission_percent AS instalment6_commission_percent_18, t0.eik AS eik_19, t0.purchase_expiration_hours AS purchase_expiration_hours_20, t0.unshipped_purchase_days AS unshipped_purchase_days_21, t0.pay_now_allowed AS pay_now_allowed_22, t0.purchase_to_be_paid_days AS purchase_to_be_paid_days_23, t0.minimum_amount_for_payment AS minimum_amount_for_payment_24, t0.platform AS platform_25, t0.grace_start_date AS grace_start_date_26, t0.grace_duration_days AS grace_duration_days_27, t0.purchase_finalised_redirect_timer_seconds AS purchase_finalised_redirect_timer_seconds_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.cover_image_id AS cover_image_id_31, t0.shop_id AS shop_id_32 FROM shop_profile t0 WHERE t0.shop_id = ? Parameters: [`10`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.address AS address_2, t0.contact AS contact_3, t0.phone1 AS phone1_4, t0.phone2 AS phone2_5, t0.phone3 AS phone3_6, t0.email2 AS email2_7, t0.email3 AS email3_8, t0.name AS name_9, t0.company_name AS company_name_10, t0.web_address AS web_address_11, t0.callback_url AS callback_url_12, t0.pay_now_commission_percent AS pay_now_commission_percent_13, t0.pay_later_commission_percent AS pay_later_commission_percent_14, t0.instalment_commission_percent AS instalment_commission_percent_15, t0.pay_later_v2_commission_percent AS pay_later_v2_commission_percent_16, t0.instalment4_commission_percent AS instalment4_commission_percent_17, t0.instalment6_commission_percent AS instalment6_commission_percent_18, t0.eik AS eik_19, t0.purchase_expiration_hours AS purchase_expiration_hours_20, t0.unshipped_purchase_days AS unshipped_purchase_days_21, t0.pay_now_allowed AS pay_now_allowed_22, t0.purchase_to_be_paid_days AS purchase_to_be_paid_days_23, t0.minimum_amount_for_payment AS minimum_amount_for_payment_24, t0.platform AS platform_25, t0.grace_start_date AS grace_start_date_26, t0.grace_duration_days AS grace_duration_days_27, t0.purchase_finalised_redirect_timer_seconds AS purchase_finalised_redirect_timer_seconds_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.cover_image_id AS cover_image_id_31, t0.shop_id AS shop_id_32 FROM shop_profile t0 WHERE t0.shop_id = ? SELECT t0.id AS id_1, t0.address AS address_2, t0.contact AS contact_3, t0.phone1 AS phone1_4, t0.phone2 AS phone2_5, t0.phone3 AS phone3_6, t0.email2 AS email2_7, t0.email3 AS email3_8, t0.name AS name_9, t0.company_name AS company_name_10, t0.web_address AS web_address_11, t0.callback_url AS callback_url_12, t0.pay_now_commission_percent AS pay_now_commission_percent_13, t0.pay_later_commission_percent AS pay_later_commission_percent_14, t0.instalment_commission_percent AS instalment_commission_percent_15, t0.pay_later_v2_commission_percent AS pay_later_v2_commission_percent_16, t0.instalment4_commission_percent AS instalment4_commission_percent_17, t0.instalment6_commission_percent AS instalment6_commission_percent_18, t0.eik AS eik_19, t0.purchase_expiration_hours AS purchase_expiration_hours_20, t0.unshipped_purchase_days AS unshipped_purchase_days_21, t0.pay_now_allowed AS pay_now_allowed_22, t0.purchase_to_be_paid_days AS purchase_to_be_paid_days_23, t0.minimum_amount_for_payment AS minimum_amount_for_payment_24, t0.platform AS platform_25, t0.grace_start_date AS grace_start_date_26, t0.grace_duration_days AS grace_duration_days_27, t0.purchase_finalised_redirect_timer_seconds AS purchase_finalised_redirect_timer_seconds_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.cover_image_id AS cover_image_id_31, t0.shop_id AS shop_id_32 FROM shop_profile t0 WHERE t0.shop_id = 10;
6	1.60 ms	SELECT t0.id AS id_1, t0.percent AS percent_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.shop_id AS shop_id_7 FROM instalment6_interest_rate_promotion t0 WHERE t0.shop_id = ? Parameters: [`10`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.percent AS percent_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.shop_id AS shop_id_7 FROM instalment6_interest_rate_promotion t0 WHERE t0.shop_id = ? SELECT t0.id AS id_1, t0.percent AS percent_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.shop_id AS shop_id_7 FROM instalment6_interest_rate_promotion t0 WHERE t0.shop_id = 10;
7	0.87 ms	SELECT t0.id AS id_1, t0.address AS address_2, t0.contact AS contact_3, t0.phone1 AS phone1_4, t0.phone2 AS phone2_5, t0.phone3 AS phone3_6, t0.email2 AS email2_7, t0.email3 AS email3_8, t0.name AS name_9, t0.company_name AS company_name_10, t0.web_address AS web_address_11, t0.callback_url AS callback_url_12, t0.pay_now_commission_percent AS pay_now_commission_percent_13, t0.pay_later_commission_percent AS pay_later_commission_percent_14, t0.instalment_commission_percent AS instalment_commission_percent_15, t0.pay_later_v2_commission_percent AS pay_later_v2_commission_percent_16, t0.instalment4_commission_percent AS instalment4_commission_percent_17, t0.instalment6_commission_percent AS instalment6_commission_percent_18, t0.eik AS eik_19, t0.purchase_expiration_hours AS purchase_expiration_hours_20, t0.unshipped_purchase_days AS unshipped_purchase_days_21, t0.pay_now_allowed AS pay_now_allowed_22, t0.purchase_to_be_paid_days AS purchase_to_be_paid_days_23, t0.minimum_amount_for_payment AS minimum_amount_for_payment_24, t0.platform AS platform_25, t0.grace_start_date AS grace_start_date_26, t0.grace_duration_days AS grace_duration_days_27, t0.purchase_finalised_redirect_timer_seconds AS purchase_finalised_redirect_timer_seconds_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.cover_image_id AS cover_image_id_31, t0.shop_id AS shop_id_32 FROM shop_profile t0 WHERE t0.shop_id = ? Parameters: [`9`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.address AS address_2, t0.contact AS contact_3, t0.phone1 AS phone1_4, t0.phone2 AS phone2_5, t0.phone3 AS phone3_6, t0.email2 AS email2_7, t0.email3 AS email3_8, t0.name AS name_9, t0.company_name AS company_name_10, t0.web_address AS web_address_11, t0.callback_url AS callback_url_12, t0.pay_now_commission_percent AS pay_now_commission_percent_13, t0.pay_later_commission_percent AS pay_later_commission_percent_14, t0.instalment_commission_percent AS instalment_commission_percent_15, t0.pay_later_v2_commission_percent AS pay_later_v2_commission_percent_16, t0.instalment4_commission_percent AS instalment4_commission_percent_17, t0.instalment6_commission_percent AS instalment6_commission_percent_18, t0.eik AS eik_19, t0.purchase_expiration_hours AS purchase_expiration_hours_20, t0.unshipped_purchase_days AS unshipped_purchase_days_21, t0.pay_now_allowed AS pay_now_allowed_22, t0.purchase_to_be_paid_days AS purchase_to_be_paid_days_23, t0.minimum_amount_for_payment AS minimum_amount_for_payment_24, t0.platform AS platform_25, t0.grace_start_date AS grace_start_date_26, t0.grace_duration_days AS grace_duration_days_27, t0.purchase_finalised_redirect_timer_seconds AS purchase_finalised_redirect_timer_seconds_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.cover_image_id AS cover_image_id_31, t0.shop_id AS shop_id_32 FROM shop_profile t0 WHERE t0.shop_id = ? SELECT t0.id AS id_1, t0.address AS address_2, t0.contact AS contact_3, t0.phone1 AS phone1_4, t0.phone2 AS phone2_5, t0.phone3 AS phone3_6, t0.email2 AS email2_7, t0.email3 AS email3_8, t0.name AS name_9, t0.company_name AS company_name_10, t0.web_address AS web_address_11, t0.callback_url AS callback_url_12, t0.pay_now_commission_percent AS pay_now_commission_percent_13, t0.pay_later_commission_percent AS pay_later_commission_percent_14, t0.instalment_commission_percent AS instalment_commission_percent_15, t0.pay_later_v2_commission_percent AS pay_later_v2_commission_percent_16, t0.instalment4_commission_percent AS instalment4_commission_percent_17, t0.instalment6_commission_percent AS instalment6_commission_percent_18, t0.eik AS eik_19, t0.purchase_expiration_hours AS purchase_expiration_hours_20, t0.unshipped_purchase_days AS unshipped_purchase_days_21, t0.pay_now_allowed AS pay_now_allowed_22, t0.purchase_to_be_paid_days AS purchase_to_be_paid_days_23, t0.minimum_amount_for_payment AS minimum_amount_for_payment_24, t0.platform AS platform_25, t0.grace_start_date AS grace_start_date_26, t0.grace_duration_days AS grace_duration_days_27, t0.purchase_finalised_redirect_timer_seconds AS purchase_finalised_redirect_timer_seconds_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.cover_image_id AS cover_image_id_31, t0.shop_id AS shop_id_32 FROM shop_profile t0 WHERE t0.shop_id = 9;
8	0.68 ms	SELECT t0.id AS id_1, t0.percent AS percent_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.shop_id AS shop_id_7 FROM instalment6_interest_rate_promotion t0 WHERE t0.shop_id = ? Parameters: [`9`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.percent AS percent_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.shop_id AS shop_id_7 FROM instalment6_interest_rate_promotion t0 WHERE t0.shop_id = ? SELECT t0.id AS id_1, t0.percent AS percent_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.shop_id AS shop_id_7 FROM instalment6_interest_rate_promotion t0 WHERE t0.shop_id = 9;
9	0.91 ms	SELECT t0.id AS id_1, t0.address AS address_2, t0.contact AS contact_3, t0.phone1 AS phone1_4, t0.phone2 AS phone2_5, t0.phone3 AS phone3_6, t0.email2 AS email2_7, t0.email3 AS email3_8, t0.name AS name_9, t0.company_name AS company_name_10, t0.web_address AS web_address_11, t0.callback_url AS callback_url_12, t0.pay_now_commission_percent AS pay_now_commission_percent_13, t0.pay_later_commission_percent AS pay_later_commission_percent_14, t0.instalment_commission_percent AS instalment_commission_percent_15, t0.pay_later_v2_commission_percent AS pay_later_v2_commission_percent_16, t0.instalment4_commission_percent AS instalment4_commission_percent_17, t0.instalment6_commission_percent AS instalment6_commission_percent_18, t0.eik AS eik_19, t0.purchase_expiration_hours AS purchase_expiration_hours_20, t0.unshipped_purchase_days AS unshipped_purchase_days_21, t0.pay_now_allowed AS pay_now_allowed_22, t0.purchase_to_be_paid_days AS purchase_to_be_paid_days_23, t0.minimum_amount_for_payment AS minimum_amount_for_payment_24, t0.platform AS platform_25, t0.grace_start_date AS grace_start_date_26, t0.grace_duration_days AS grace_duration_days_27, t0.purchase_finalised_redirect_timer_seconds AS purchase_finalised_redirect_timer_seconds_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.cover_image_id AS cover_image_id_31, t0.shop_id AS shop_id_32 FROM shop_profile t0 WHERE t0.shop_id = ? Parameters: [`14`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.address AS address_2, t0.contact AS contact_3, t0.phone1 AS phone1_4, t0.phone2 AS phone2_5, t0.phone3 AS phone3_6, t0.email2 AS email2_7, t0.email3 AS email3_8, t0.name AS name_9, t0.company_name AS company_name_10, t0.web_address AS web_address_11, t0.callback_url AS callback_url_12, t0.pay_now_commission_percent AS pay_now_commission_percent_13, t0.pay_later_commission_percent AS pay_later_commission_percent_14, t0.instalment_commission_percent AS instalment_commission_percent_15, t0.pay_later_v2_commission_percent AS pay_later_v2_commission_percent_16, t0.instalment4_commission_percent AS instalment4_commission_percent_17, t0.instalment6_commission_percent AS instalment6_commission_percent_18, t0.eik AS eik_19, t0.purchase_expiration_hours AS purchase_expiration_hours_20, t0.unshipped_purchase_days AS unshipped_purchase_days_21, t0.pay_now_allowed AS pay_now_allowed_22, t0.purchase_to_be_paid_days AS purchase_to_be_paid_days_23, t0.minimum_amount_for_payment AS minimum_amount_for_payment_24, t0.platform AS platform_25, t0.grace_start_date AS grace_start_date_26, t0.grace_duration_days AS grace_duration_days_27, t0.purchase_finalised_redirect_timer_seconds AS purchase_finalised_redirect_timer_seconds_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.cover_image_id AS cover_image_id_31, t0.shop_id AS shop_id_32 FROM shop_profile t0 WHERE t0.shop_id = ? SELECT t0.id AS id_1, t0.address AS address_2, t0.contact AS contact_3, t0.phone1 AS phone1_4, t0.phone2 AS phone2_5, t0.phone3 AS phone3_6, t0.email2 AS email2_7, t0.email3 AS email3_8, t0.name AS name_9, t0.company_name AS company_name_10, t0.web_address AS web_address_11, t0.callback_url AS callback_url_12, t0.pay_now_commission_percent AS pay_now_commission_percent_13, t0.pay_later_commission_percent AS pay_later_commission_percent_14, t0.instalment_commission_percent AS instalment_commission_percent_15, t0.pay_later_v2_commission_percent AS pay_later_v2_commission_percent_16, t0.instalment4_commission_percent AS instalment4_commission_percent_17, t0.instalment6_commission_percent AS instalment6_commission_percent_18, t0.eik AS eik_19, t0.purchase_expiration_hours AS purchase_expiration_hours_20, t0.unshipped_purchase_days AS unshipped_purchase_days_21, t0.pay_now_allowed AS pay_now_allowed_22, t0.purchase_to_be_paid_days AS purchase_to_be_paid_days_23, t0.minimum_amount_for_payment AS minimum_amount_for_payment_24, t0.platform AS platform_25, t0.grace_start_date AS grace_start_date_26, t0.grace_duration_days AS grace_duration_days_27, t0.purchase_finalised_redirect_timer_seconds AS purchase_finalised_redirect_timer_seconds_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.cover_image_id AS cover_image_id_31, t0.shop_id AS shop_id_32 FROM shop_profile t0 WHERE t0.shop_id = 14;
10	0.63 ms	SELECT t0.id AS id_1, t0.percent AS percent_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.shop_id AS shop_id_7 FROM instalment6_interest_rate_promotion t0 WHERE t0.shop_id = ? Parameters: [`14`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.percent AS percent_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.shop_id AS shop_id_7 FROM instalment6_interest_rate_promotion t0 WHERE t0.shop_id = ? SELECT t0.id AS id_1, t0.percent AS percent_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.shop_id AS shop_id_7 FROM instalment6_interest_rate_promotion t0 WHERE t0.shop_id = 14;
11	0.73 ms	SELECT t0.id AS id_1, t0.address AS address_2, t0.contact AS contact_3, t0.phone1 AS phone1_4, t0.phone2 AS phone2_5, t0.phone3 AS phone3_6, t0.email2 AS email2_7, t0.email3 AS email3_8, t0.name AS name_9, t0.company_name AS company_name_10, t0.web_address AS web_address_11, t0.callback_url AS callback_url_12, t0.pay_now_commission_percent AS pay_now_commission_percent_13, t0.pay_later_commission_percent AS pay_later_commission_percent_14, t0.instalment_commission_percent AS instalment_commission_percent_15, t0.pay_later_v2_commission_percent AS pay_later_v2_commission_percent_16, t0.instalment4_commission_percent AS instalment4_commission_percent_17, t0.instalment6_commission_percent AS instalment6_commission_percent_18, t0.eik AS eik_19, t0.purchase_expiration_hours AS purchase_expiration_hours_20, t0.unshipped_purchase_days AS unshipped_purchase_days_21, t0.pay_now_allowed AS pay_now_allowed_22, t0.purchase_to_be_paid_days AS purchase_to_be_paid_days_23, t0.minimum_amount_for_payment AS minimum_amount_for_payment_24, t0.platform AS platform_25, t0.grace_start_date AS grace_start_date_26, t0.grace_duration_days AS grace_duration_days_27, t0.purchase_finalised_redirect_timer_seconds AS purchase_finalised_redirect_timer_seconds_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.cover_image_id AS cover_image_id_31, t0.shop_id AS shop_id_32 FROM shop_profile t0 WHERE t0.shop_id = ? Parameters: [`12`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.address AS address_2, t0.contact AS contact_3, t0.phone1 AS phone1_4, t0.phone2 AS phone2_5, t0.phone3 AS phone3_6, t0.email2 AS email2_7, t0.email3 AS email3_8, t0.name AS name_9, t0.company_name AS company_name_10, t0.web_address AS web_address_11, t0.callback_url AS callback_url_12, t0.pay_now_commission_percent AS pay_now_commission_percent_13, t0.pay_later_commission_percent AS pay_later_commission_percent_14, t0.instalment_commission_percent AS instalment_commission_percent_15, t0.pay_later_v2_commission_percent AS pay_later_v2_commission_percent_16, t0.instalment4_commission_percent AS instalment4_commission_percent_17, t0.instalment6_commission_percent AS instalment6_commission_percent_18, t0.eik AS eik_19, t0.purchase_expiration_hours AS purchase_expiration_hours_20, t0.unshipped_purchase_days AS unshipped_purchase_days_21, t0.pay_now_allowed AS pay_now_allowed_22, t0.purchase_to_be_paid_days AS purchase_to_be_paid_days_23, t0.minimum_amount_for_payment AS minimum_amount_for_payment_24, t0.platform AS platform_25, t0.grace_start_date AS grace_start_date_26, t0.grace_duration_days AS grace_duration_days_27, t0.purchase_finalised_redirect_timer_seconds AS purchase_finalised_redirect_timer_seconds_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.cover_image_id AS cover_image_id_31, t0.shop_id AS shop_id_32 FROM shop_profile t0 WHERE t0.shop_id = ? SELECT t0.id AS id_1, t0.address AS address_2, t0.contact AS contact_3, t0.phone1 AS phone1_4, t0.phone2 AS phone2_5, t0.phone3 AS phone3_6, t0.email2 AS email2_7, t0.email3 AS email3_8, t0.name AS name_9, t0.company_name AS company_name_10, t0.web_address AS web_address_11, t0.callback_url AS callback_url_12, t0.pay_now_commission_percent AS pay_now_commission_percent_13, t0.pay_later_commission_percent AS pay_later_commission_percent_14, t0.instalment_commission_percent AS instalment_commission_percent_15, t0.pay_later_v2_commission_percent AS pay_later_v2_commission_percent_16, t0.instalment4_commission_percent AS instalment4_commission_percent_17, t0.instalment6_commission_percent AS instalment6_commission_percent_18, t0.eik AS eik_19, t0.purchase_expiration_hours AS purchase_expiration_hours_20, t0.unshipped_purchase_days AS unshipped_purchase_days_21, t0.pay_now_allowed AS pay_now_allowed_22, t0.purchase_to_be_paid_days AS purchase_to_be_paid_days_23, t0.minimum_amount_for_payment AS minimum_amount_for_payment_24, t0.platform AS platform_25, t0.grace_start_date AS grace_start_date_26, t0.grace_duration_days AS grace_duration_days_27, t0.purchase_finalised_redirect_timer_seconds AS purchase_finalised_redirect_timer_seconds_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.cover_image_id AS cover_image_id_31, t0.shop_id AS shop_id_32 FROM shop_profile t0 WHERE t0.shop_id = 12;
12	0.49 ms	SELECT t0.id AS id_1, t0.percent AS percent_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.shop_id AS shop_id_7 FROM instalment6_interest_rate_promotion t0 WHERE t0.shop_id = ? Parameters: [`12`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.percent AS percent_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.shop_id AS shop_id_7 FROM instalment6_interest_rate_promotion t0 WHERE t0.shop_id = ? SELECT t0.id AS id_1, t0.percent AS percent_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.shop_id AS shop_id_7 FROM instalment6_interest_rate_promotion t0 WHERE t0.shop_id = 12;
13	0.71 ms	SELECT t0.id AS id_1, t0.address AS address_2, t0.contact AS contact_3, t0.phone1 AS phone1_4, t0.phone2 AS phone2_5, t0.phone3 AS phone3_6, t0.email2 AS email2_7, t0.email3 AS email3_8, t0.name AS name_9, t0.company_name AS company_name_10, t0.web_address AS web_address_11, t0.callback_url AS callback_url_12, t0.pay_now_commission_percent AS pay_now_commission_percent_13, t0.pay_later_commission_percent AS pay_later_commission_percent_14, t0.instalment_commission_percent AS instalment_commission_percent_15, t0.pay_later_v2_commission_percent AS pay_later_v2_commission_percent_16, t0.instalment4_commission_percent AS instalment4_commission_percent_17, t0.instalment6_commission_percent AS instalment6_commission_percent_18, t0.eik AS eik_19, t0.purchase_expiration_hours AS purchase_expiration_hours_20, t0.unshipped_purchase_days AS unshipped_purchase_days_21, t0.pay_now_allowed AS pay_now_allowed_22, t0.purchase_to_be_paid_days AS purchase_to_be_paid_days_23, t0.minimum_amount_for_payment AS minimum_amount_for_payment_24, t0.platform AS platform_25, t0.grace_start_date AS grace_start_date_26, t0.grace_duration_days AS grace_duration_days_27, t0.purchase_finalised_redirect_timer_seconds AS purchase_finalised_redirect_timer_seconds_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.cover_image_id AS cover_image_id_31, t0.shop_id AS shop_id_32 FROM shop_profile t0 WHERE t0.shop_id = ? Parameters: [`11`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.address AS address_2, t0.contact AS contact_3, t0.phone1 AS phone1_4, t0.phone2 AS phone2_5, t0.phone3 AS phone3_6, t0.email2 AS email2_7, t0.email3 AS email3_8, t0.name AS name_9, t0.company_name AS company_name_10, t0.web_address AS web_address_11, t0.callback_url AS callback_url_12, t0.pay_now_commission_percent AS pay_now_commission_percent_13, t0.pay_later_commission_percent AS pay_later_commission_percent_14, t0.instalment_commission_percent AS instalment_commission_percent_15, t0.pay_later_v2_commission_percent AS pay_later_v2_commission_percent_16, t0.instalment4_commission_percent AS instalment4_commission_percent_17, t0.instalment6_commission_percent AS instalment6_commission_percent_18, t0.eik AS eik_19, t0.purchase_expiration_hours AS purchase_expiration_hours_20, t0.unshipped_purchase_days AS unshipped_purchase_days_21, t0.pay_now_allowed AS pay_now_allowed_22, t0.purchase_to_be_paid_days AS purchase_to_be_paid_days_23, t0.minimum_amount_for_payment AS minimum_amount_for_payment_24, t0.platform AS platform_25, t0.grace_start_date AS grace_start_date_26, t0.grace_duration_days AS grace_duration_days_27, t0.purchase_finalised_redirect_timer_seconds AS purchase_finalised_redirect_timer_seconds_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.cover_image_id AS cover_image_id_31, t0.shop_id AS shop_id_32 FROM shop_profile t0 WHERE t0.shop_id = ? SELECT t0.id AS id_1, t0.address AS address_2, t0.contact AS contact_3, t0.phone1 AS phone1_4, t0.phone2 AS phone2_5, t0.phone3 AS phone3_6, t0.email2 AS email2_7, t0.email3 AS email3_8, t0.name AS name_9, t0.company_name AS company_name_10, t0.web_address AS web_address_11, t0.callback_url AS callback_url_12, t0.pay_now_commission_percent AS pay_now_commission_percent_13, t0.pay_later_commission_percent AS pay_later_commission_percent_14, t0.instalment_commission_percent AS instalment_commission_percent_15, t0.pay_later_v2_commission_percent AS pay_later_v2_commission_percent_16, t0.instalment4_commission_percent AS instalment4_commission_percent_17, t0.instalment6_commission_percent AS instalment6_commission_percent_18, t0.eik AS eik_19, t0.purchase_expiration_hours AS purchase_expiration_hours_20, t0.unshipped_purchase_days AS unshipped_purchase_days_21, t0.pay_now_allowed AS pay_now_allowed_22, t0.purchase_to_be_paid_days AS purchase_to_be_paid_days_23, t0.minimum_amount_for_payment AS minimum_amount_for_payment_24, t0.platform AS platform_25, t0.grace_start_date AS grace_start_date_26, t0.grace_duration_days AS grace_duration_days_27, t0.purchase_finalised_redirect_timer_seconds AS purchase_finalised_redirect_timer_seconds_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.cover_image_id AS cover_image_id_31, t0.shop_id AS shop_id_32 FROM shop_profile t0 WHERE t0.shop_id = 11;
14	0.48 ms	SELECT t0.id AS id_1, t0.percent AS percent_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.shop_id AS shop_id_7 FROM instalment6_interest_rate_promotion t0 WHERE t0.shop_id = ? Parameters: [`11`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.percent AS percent_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.shop_id AS shop_id_7 FROM instalment6_interest_rate_promotion t0 WHERE t0.shop_id = ? SELECT t0.id AS id_1, t0.percent AS percent_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.shop_id AS shop_id_7 FROM instalment6_interest_rate_promotion t0 WHERE t0.shop_id = 11;
15	0.76 ms	SELECT t0.id AS id_1, t0.address AS address_2, t0.contact AS contact_3, t0.phone1 AS phone1_4, t0.phone2 AS phone2_5, t0.phone3 AS phone3_6, t0.email2 AS email2_7, t0.email3 AS email3_8, t0.name AS name_9, t0.company_name AS company_name_10, t0.web_address AS web_address_11, t0.callback_url AS callback_url_12, t0.pay_now_commission_percent AS pay_now_commission_percent_13, t0.pay_later_commission_percent AS pay_later_commission_percent_14, t0.instalment_commission_percent AS instalment_commission_percent_15, t0.pay_later_v2_commission_percent AS pay_later_v2_commission_percent_16, t0.instalment4_commission_percent AS instalment4_commission_percent_17, t0.instalment6_commission_percent AS instalment6_commission_percent_18, t0.eik AS eik_19, t0.purchase_expiration_hours AS purchase_expiration_hours_20, t0.unshipped_purchase_days AS unshipped_purchase_days_21, t0.pay_now_allowed AS pay_now_allowed_22, t0.purchase_to_be_paid_days AS purchase_to_be_paid_days_23, t0.minimum_amount_for_payment AS minimum_amount_for_payment_24, t0.platform AS platform_25, t0.grace_start_date AS grace_start_date_26, t0.grace_duration_days AS grace_duration_days_27, t0.purchase_finalised_redirect_timer_seconds AS purchase_finalised_redirect_timer_seconds_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.cover_image_id AS cover_image_id_31, t0.shop_id AS shop_id_32 FROM shop_profile t0 WHERE t0.shop_id = ? Parameters: [`13`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.address AS address_2, t0.contact AS contact_3, t0.phone1 AS phone1_4, t0.phone2 AS phone2_5, t0.phone3 AS phone3_6, t0.email2 AS email2_7, t0.email3 AS email3_8, t0.name AS name_9, t0.company_name AS company_name_10, t0.web_address AS web_address_11, t0.callback_url AS callback_url_12, t0.pay_now_commission_percent AS pay_now_commission_percent_13, t0.pay_later_commission_percent AS pay_later_commission_percent_14, t0.instalment_commission_percent AS instalment_commission_percent_15, t0.pay_later_v2_commission_percent AS pay_later_v2_commission_percent_16, t0.instalment4_commission_percent AS instalment4_commission_percent_17, t0.instalment6_commission_percent AS instalment6_commission_percent_18, t0.eik AS eik_19, t0.purchase_expiration_hours AS purchase_expiration_hours_20, t0.unshipped_purchase_days AS unshipped_purchase_days_21, t0.pay_now_allowed AS pay_now_allowed_22, t0.purchase_to_be_paid_days AS purchase_to_be_paid_days_23, t0.minimum_amount_for_payment AS minimum_amount_for_payment_24, t0.platform AS platform_25, t0.grace_start_date AS grace_start_date_26, t0.grace_duration_days AS grace_duration_days_27, t0.purchase_finalised_redirect_timer_seconds AS purchase_finalised_redirect_timer_seconds_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.cover_image_id AS cover_image_id_31, t0.shop_id AS shop_id_32 FROM shop_profile t0 WHERE t0.shop_id = ? SELECT t0.id AS id_1, t0.address AS address_2, t0.contact AS contact_3, t0.phone1 AS phone1_4, t0.phone2 AS phone2_5, t0.phone3 AS phone3_6, t0.email2 AS email2_7, t0.email3 AS email3_8, t0.name AS name_9, t0.company_name AS company_name_10, t0.web_address AS web_address_11, t0.callback_url AS callback_url_12, t0.pay_now_commission_percent AS pay_now_commission_percent_13, t0.pay_later_commission_percent AS pay_later_commission_percent_14, t0.instalment_commission_percent AS instalment_commission_percent_15, t0.pay_later_v2_commission_percent AS pay_later_v2_commission_percent_16, t0.instalment4_commission_percent AS instalment4_commission_percent_17, t0.instalment6_commission_percent AS instalment6_commission_percent_18, t0.eik AS eik_19, t0.purchase_expiration_hours AS purchase_expiration_hours_20, t0.unshipped_purchase_days AS unshipped_purchase_days_21, t0.pay_now_allowed AS pay_now_allowed_22, t0.purchase_to_be_paid_days AS purchase_to_be_paid_days_23, t0.minimum_amount_for_payment AS minimum_amount_for_payment_24, t0.platform AS platform_25, t0.grace_start_date AS grace_start_date_26, t0.grace_duration_days AS grace_duration_days_27, t0.purchase_finalised_redirect_timer_seconds AS purchase_finalised_redirect_timer_seconds_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.cover_image_id AS cover_image_id_31, t0.shop_id AS shop_id_32 FROM shop_profile t0 WHERE t0.shop_id = 13;
16	0.49 ms	SELECT t0.id AS id_1, t0.percent AS percent_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.shop_id AS shop_id_7 FROM instalment6_interest_rate_promotion t0 WHERE t0.shop_id = ? Parameters: [`13`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.percent AS percent_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.shop_id AS shop_id_7 FROM instalment6_interest_rate_promotion t0 WHERE t0.shop_id = ? SELECT t0.id AS id_1, t0.percent AS percent_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.shop_id AS shop_id_7 FROM instalment6_interest_rate_promotion t0 WHERE t0.shop_id = 13;
17	2.52 ms	SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.active AS active_2, s0_.position_index AS position_index_3, s1_.id AS id_4, s1_.name AS name_5, s1_.active AS active_6, s1_.position_index AS position_index_7, s0_.parent_id AS parent_id_8, s1_.parent_id AS parent_id_9 FROM shop_category s0_ LEFT JOIN shop_category s1_ ON s0_.parent_id = s1_.id WHERE s0_.active = 1 ORDER BY s1_.position_index ASC, s0_.position_index ASC Parameters: [] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.active AS active_2, s0_.position_index AS position_index_3, s1_.id AS id_4, s1_.name AS name_5, s1_.active AS active_6, s1_.position_index AS position_index_7, s0_.parent_id AS parent_id_8, s1_.parent_id AS parent_id_9 FROM shop_category s0_ LEFT JOIN shop_category s1_ ON s0_.parent_id = s1_.id WHERE s0_.active = 1 ORDER BY s1_.position_index ASC, s0_.position_index ASC SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.active AS active_2, s0_.position_index AS position_index_3, s1_.id AS id_4, s1_.name AS name_5, s1_.active AS active_6, s1_.position_index AS position_index_7, s0_.parent_id AS parent_id_8, s1_.parent_id AS parent_id_9 FROM shop_category s0_ LEFT JOIN shop_category s1_ ON s0_.parent_id = s1_.id WHERE s0_.active = 1 ORDER BY s1_.position_index ASC, s0_.position_index ASC;
18	2.76 ms	SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.`key` AS key_8, t0.secret AS secret_9, t0.shipping_confirmation_required AS shipping_confirmation_required_10, t0.calculation_strategy AS calculation_strategy_11, t0.developer_password AS developer_password_12, t0.allowed_products AS allowed_products_13, t0.position_index AS position_index_14, t0.receiving_bank_account_id AS receiving_bank_account_id_15, t0.sending_bank_account_id AS sending_bank_account_id_16, t18.id AS id_17, t18.address AS address_19, t18.contact AS contact_20, t18.phone1 AS phone1_21, t18.phone2 AS phone2_22, t18.phone3 AS phone3_23, t18.email2 AS email2_24, t18.email3 AS email3_25, t18.name AS name_26, t18.company_name AS company_name_27, t18.web_address AS web_address_28, t18.callback_url AS callback_url_29, t18.pay_now_commission_percent AS pay_now_commission_percent_30, t18.pay_later_commission_percent AS pay_later_commission_percent_31, t18.instalment_commission_percent AS instalment_commission_percent_32, t18.pay_later_v2_commission_percent AS pay_later_v2_commission_percent_33, t18.instalment4_commission_percent AS instalment4_commission_percent_34, t18.instalment6_commission_percent AS instalment6_commission_percent_35, t18.eik AS eik_36, t18.purchase_expiration_hours AS purchase_expiration_hours_37, t18.unshipped_purchase_days AS unshipped_purchase_days_38, t18.pay_now_allowed AS pay_now_allowed_39, t18.purchase_to_be_paid_days AS purchase_to_be_paid_days_40, t18.minimum_amount_for_payment AS minimum_amount_for_payment_41, t18.platform AS platform_42, t18.grace_start_date AS grace_start_date_43, t18.grace_duration_days AS grace_duration_days_44, t18.purchase_finalised_redirect_timer_seconds AS purchase_finalised_redirect_timer_seconds_45, t18.created_at AS created_at_46, t18.updated_at AS updated_at_47, t18.cover_image_id AS cover_image_id_48, t18.shop_id AS shop_id_49, t0.api_token_id AS api_token_id_50, t52.id AS id_51, t52.percent AS percent_53, t52.start_date AS start_date_54, t52.end_date AS end_date_55, t52.created_at AS created_at_56, t52.updated_at AS updated_at_57, t52.shop_id AS shop_id_58, t0.dtype FROM users t0 LEFT JOIN shop_profile t18 ON t18.shop_id = t0.id LEFT JOIN instalment6_interest_rate_promotion t52 ON t52.shop_id = t0.id INNER JOIN shop_shop_category ON t0.id = shop_shop_category.shop_id WHERE shop_shop_category.shop_category_id = ? AND t0.dtype IN ('shop') Parameters: [`3`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.`key` AS key_8, t0.secret AS secret_9, t0.shipping_confirmation_required AS shipping_confirmation_required_10, t0.calculation_strategy AS calculation_strategy_11, t0.developer_password AS developer_password_12, t0.allowed_products AS allowed_products_13, t0.position_index AS position_index_14, t0.receiving_bank_account_id AS receiving_bank_account_id_15, t0.sending_bank_account_id AS sending_bank_account_id_16, t18.id AS id_17, t18.address AS address_19, t18.contact AS contact_20, t18.phone1 AS phone1_21, t18.phone2 AS phone2_22, t18.phone3 AS phone3_23, t18.email2 AS email2_24, t18.email3 AS email3_25, t18.name AS name_26, t18.company_name AS company_name_27, t18.web_address AS web_address_28, t18.callback_url AS callback_url_29, t18.pay_now_commission_percent AS pay_now_commission_percent_30, t18.pay_later_commission_percent AS pay_later_commission_percent_31, t18.instalment_commission_percent AS instalment_commission_percent_32, t18.pay_later_v2_commission_percent AS pay_later_v2_commission_percent_33, t18.instalment4_commission_percent AS instalment4_commission_percent_34, t18.instalment6_commission_percent AS instalment6_commission_percent_35, t18.eik AS eik_36, t18.purchase_expiration_hours AS purchase_expiration_hours_37, t18.unshipped_purchase_days AS unshipped_purchase_days_38, t18.pay_now_allowed AS pay_now_allowed_39, t18.purchase_to_be_paid_days AS purchase_to_be_paid_days_40, t18.minimum_amount_for_payment AS minimum_amount_for_payment_41, t18.platform AS platform_42, t18.grace_start_date AS grace_start_date_43, t18.grace_duration_days AS grace_duration_days_44, t18.purchase_finalised_redirect_timer_seconds AS purchase_finalised_redirect_timer_seconds_45, t18.created_at AS created_at_46, t18.updated_at AS updated_at_47, t18.cover_image_id AS cover_image_id_48, t18.shop_id AS shop_id_49, t0.api_token_id AS api_token_id_50, t52.id AS id_51, t52.percent AS percent_53, t52.start_date AS start_date_54, t52.end_date AS end_date_55, t52.created_at AS created_at_56, t52.updated_at AS updated_at_57, t52.shop_id AS shop_id_58, t0.dtype FROM users t0 LEFT JOIN shop_profile t18 ON t18.shop_id = t0.id LEFT JOIN instalment6_interest_rate_promotion t52 ON t52.shop_id = t0.id INNER JOIN shop_shop_category ON t0.id = shop_shop_category.shop_id WHERE shop_shop_category.shop_category_id = ? AND t0.dtype IN ('shop') SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.`key` AS key_8, t0.secret AS secret_9, t0.shipping_confirmation_required AS shipping_confirmation_required_10, t0.calculation_strategy AS calculation_strategy_11, t0.developer_password AS developer_password_12, t0.allowed_products AS allowed_products_13, t0.position_index AS position_index_14, t0.receiving_bank_account_id AS receiving_bank_account_id_15, t0.sending_bank_account_id AS sending_bank_account_id_16, t18.id AS id_17, t18.address AS address_19, t18.contact AS contact_20, t18.phone1 AS phone1_21, t18.phone2 AS phone2_22, t18.phone3 AS phone3_23, t18.email2 AS email2_24, t18.email3 AS email3_25, t18.name AS name_26, t18.company_name AS company_name_27, t18.web_address AS web_address_28, t18.callback_url AS callback_url_29, t18.pay_now_commission_percent AS pay_now_commission_percent_30, t18.pay_later_commission_percent AS pay_later_commission_percent_31, t18.instalment_commission_percent AS instalment_commission_percent_32, t18.pay_later_v2_commission_percent AS pay_later_v2_commission_percent_33, t18.instalment4_commission_percent AS instalment4_commission_percent_34, t18.instalment6_commission_percent AS instalment6_commission_percent_35, t18.eik AS eik_36, t18.purchase_expiration_hours AS purchase_expiration_hours_37, t18.unshipped_purchase_days AS unshipped_purchase_days_38, t18.pay_now_allowed AS pay_now_allowed_39, t18.purchase_to_be_paid_days AS purchase_to_be_paid_days_40, t18.minimum_amount_for_payment AS minimum_amount_for_payment_41, t18.platform AS platform_42, t18.grace_start_date AS grace_start_date_43, t18.grace_duration_days AS grace_duration_days_44, t18.purchase_finalised_redirect_timer_seconds AS purchase_finalised_redirect_timer_seconds_45, t18.created_at AS created_at_46, t18.updated_at AS updated_at_47, t18.cover_image_id AS cover_image_id_48, t18.shop_id AS shop_id_49, t0.api_token_id AS api_token_id_50, t52.id AS id_51, t52.percent AS percent_53, t52.start_date AS start_date_54, t52.end_date AS end_date_55, t52.created_at AS created_at_56, t52.updated_at AS updated_at_57, t52.shop_id AS shop_id_58, t0.dtype FROM users t0 LEFT JOIN shop_profile t18 ON t18.shop_id = t0.id LEFT JOIN instalment6_interest_rate_promotion t52 ON t52.shop_id = t0.id INNER JOIN shop_shop_category ON t0.id = shop_shop_category.shop_id WHERE shop_shop_category.shop_category_id = 3 AND t0.dtype IN ('shop');
19	1.10 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.position_index AS position_index_4, t0.parent_id AS parent_id_5 FROM shop_category t0 WHERE t0.parent_id = ? Parameters: [`3`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.position_index AS position_index_4, t0.parent_id AS parent_id_5 FROM shop_category t0 WHERE t0.parent_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.position_index AS position_index_4, t0.parent_id AS parent_id_5 FROM shop_category t0 WHERE t0.parent_id = 3;
20	1.44 ms	SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.`key` AS key_8, t0.secret AS secret_9, t0.shipping_confirmation_required AS shipping_confirmation_required_10, t0.calculation_strategy AS calculation_strategy_11, t0.developer_password AS developer_password_12, t0.allowed_products AS allowed_products_13, t0.position_index AS position_index_14, t0.receiving_bank_account_id AS receiving_bank_account_id_15, t0.sending_bank_account_id AS sending_bank_account_id_16, t18.id AS id_17, t18.address AS address_19, t18.contact AS contact_20, t18.phone1 AS phone1_21, t18.phone2 AS phone2_22, t18.phone3 AS phone3_23, t18.email2 AS email2_24, t18.email3 AS email3_25, t18.name AS name_26, t18.company_name AS company_name_27, t18.web_address AS web_address_28, t18.callback_url AS callback_url_29, t18.pay_now_commission_percent AS pay_now_commission_percent_30, t18.pay_later_commission_percent AS pay_later_commission_percent_31, t18.instalment_commission_percent AS instalment_commission_percent_32, t18.pay_later_v2_commission_percent AS pay_later_v2_commission_percent_33, t18.instalment4_commission_percent AS instalment4_commission_percent_34, t18.instalment6_commission_percent AS instalment6_commission_percent_35, t18.eik AS eik_36, t18.purchase_expiration_hours AS purchase_expiration_hours_37, t18.unshipped_purchase_days AS unshipped_purchase_days_38, t18.pay_now_allowed AS pay_now_allowed_39, t18.purchase_to_be_paid_days AS purchase_to_be_paid_days_40, t18.minimum_amount_for_payment AS minimum_amount_for_payment_41, t18.platform AS platform_42, t18.grace_start_date AS grace_start_date_43, t18.grace_duration_days AS grace_duration_days_44, t18.purchase_finalised_redirect_timer_seconds AS purchase_finalised_redirect_timer_seconds_45, t18.created_at AS created_at_46, t18.updated_at AS updated_at_47, t18.cover_image_id AS cover_image_id_48, t18.shop_id AS shop_id_49, t0.api_token_id AS api_token_id_50, t52.id AS id_51, t52.percent AS percent_53, t52.start_date AS start_date_54, t52.end_date AS end_date_55, t52.created_at AS created_at_56, t52.updated_at AS updated_at_57, t52.shop_id AS shop_id_58, t0.dtype FROM users t0 LEFT JOIN shop_profile t18 ON t18.shop_id = t0.id LEFT JOIN instalment6_interest_rate_promotion t52 ON t52.shop_id = t0.id INNER JOIN shop_shop_category ON t0.id = shop_shop_category.shop_id WHERE shop_shop_category.shop_category_id = ? AND t0.dtype IN ('shop') Parameters: [`4`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.`key` AS key_8, t0.secret AS secret_9, t0.shipping_confirmation_required AS shipping_confirmation_required_10, t0.calculation_strategy AS calculation_strategy_11, t0.developer_password AS developer_password_12, t0.allowed_products AS allowed_products_13, t0.position_index AS position_index_14, t0.receiving_bank_account_id AS receiving_bank_account_id_15, t0.sending_bank_account_id AS sending_bank_account_id_16, t18.id AS id_17, t18.address AS address_19, t18.contact AS contact_20, t18.phone1 AS phone1_21, t18.phone2 AS phone2_22, t18.phone3 AS phone3_23, t18.email2 AS email2_24, t18.email3 AS email3_25, t18.name AS name_26, t18.company_name AS company_name_27, t18.web_address AS web_address_28, t18.callback_url AS callback_url_29, t18.pay_now_commission_percent AS pay_now_commission_percent_30, t18.pay_later_commission_percent AS pay_later_commission_percent_31, t18.instalment_commission_percent AS instalment_commission_percent_32, t18.pay_later_v2_commission_percent AS pay_later_v2_commission_percent_33, t18.instalment4_commission_percent AS instalment4_commission_percent_34, t18.instalment6_commission_percent AS instalment6_commission_percent_35, t18.eik AS eik_36, t18.purchase_expiration_hours AS purchase_expiration_hours_37, t18.unshipped_purchase_days AS unshipped_purchase_days_38, t18.pay_now_allowed AS pay_now_allowed_39, t18.purchase_to_be_paid_days AS purchase_to_be_paid_days_40, t18.minimum_amount_for_payment AS minimum_amount_for_payment_41, t18.platform AS platform_42, t18.grace_start_date AS grace_start_date_43, t18.grace_duration_days AS grace_duration_days_44, t18.purchase_finalised_redirect_timer_seconds AS purchase_finalised_redirect_timer_seconds_45, t18.created_at AS created_at_46, t18.updated_at AS updated_at_47, t18.cover_image_id AS cover_image_id_48, t18.shop_id AS shop_id_49, t0.api_token_id AS api_token_id_50, t52.id AS id_51, t52.percent AS percent_53, t52.start_date AS start_date_54, t52.end_date AS end_date_55, t52.created_at AS created_at_56, t52.updated_at AS updated_at_57, t52.shop_id AS shop_id_58, t0.dtype FROM users t0 LEFT JOIN shop_profile t18 ON t18.shop_id = t0.id LEFT JOIN instalment6_interest_rate_promotion t52 ON t52.shop_id = t0.id INNER JOIN shop_shop_category ON t0.id = shop_shop_category.shop_id WHERE shop_shop_category.shop_category_id = ? AND t0.dtype IN ('shop') SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.`key` AS key_8, t0.secret AS secret_9, t0.shipping_confirmation_required AS shipping_confirmation_required_10, t0.calculation_strategy AS calculation_strategy_11, t0.developer_password AS developer_password_12, t0.allowed_products AS allowed_products_13, t0.position_index AS position_index_14, t0.receiving_bank_account_id AS receiving_bank_account_id_15, t0.sending_bank_account_id AS sending_bank_account_id_16, t18.id AS id_17, t18.address AS address_19, t18.contact AS contact_20, t18.phone1 AS phone1_21, t18.phone2 AS phone2_22, t18.phone3 AS phone3_23, t18.email2 AS email2_24, t18.email3 AS email3_25, t18.name AS name_26, t18.company_name AS company_name_27, t18.web_address AS web_address_28, t18.callback_url AS callback_url_29, t18.pay_now_commission_percent AS pay_now_commission_percent_30, t18.pay_later_commission_percent AS pay_later_commission_percent_31, t18.instalment_commission_percent AS instalment_commission_percent_32, t18.pay_later_v2_commission_percent AS pay_later_v2_commission_percent_33, t18.instalment4_commission_percent AS instalment4_commission_percent_34, t18.instalment6_commission_percent AS instalment6_commission_percent_35, t18.eik AS eik_36, t18.purchase_expiration_hours AS purchase_expiration_hours_37, t18.unshipped_purchase_days AS unshipped_purchase_days_38, t18.pay_now_allowed AS pay_now_allowed_39, t18.purchase_to_be_paid_days AS purchase_to_be_paid_days_40, t18.minimum_amount_for_payment AS minimum_amount_for_payment_41, t18.platform AS platform_42, t18.grace_start_date AS grace_start_date_43, t18.grace_duration_days AS grace_duration_days_44, t18.purchase_finalised_redirect_timer_seconds AS purchase_finalised_redirect_timer_seconds_45, t18.created_at AS created_at_46, t18.updated_at AS updated_at_47, t18.cover_image_id AS cover_image_id_48, t18.shop_id AS shop_id_49, t0.api_token_id AS api_token_id_50, t52.id AS id_51, t52.percent AS percent_53, t52.start_date AS start_date_54, t52.end_date AS end_date_55, t52.created_at AS created_at_56, t52.updated_at AS updated_at_57, t52.shop_id AS shop_id_58, t0.dtype FROM users t0 LEFT JOIN shop_profile t18 ON t18.shop_id = t0.id LEFT JOIN instalment6_interest_rate_promotion t52 ON t52.shop_id = t0.id INNER JOIN shop_shop_category ON t0.id = shop_shop_category.shop_id WHERE shop_shop_category.shop_category_id = 4 AND t0.dtype IN ('shop');
21	1.14 ms	SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.`key` AS key_8, t0.secret AS secret_9, t0.shipping_confirmation_required AS shipping_confirmation_required_10, t0.calculation_strategy AS calculation_strategy_11, t0.developer_password AS developer_password_12, t0.allowed_products AS allowed_products_13, t0.position_index AS position_index_14, t0.receiving_bank_account_id AS receiving_bank_account_id_15, t0.sending_bank_account_id AS sending_bank_account_id_16, t18.id AS id_17, t18.address AS address_19, t18.contact AS contact_20, t18.phone1 AS phone1_21, t18.phone2 AS phone2_22, t18.phone3 AS phone3_23, t18.email2 AS email2_24, t18.email3 AS email3_25, t18.name AS name_26, t18.company_name AS company_name_27, t18.web_address AS web_address_28, t18.callback_url AS callback_url_29, t18.pay_now_commission_percent AS pay_now_commission_percent_30, t18.pay_later_commission_percent AS pay_later_commission_percent_31, t18.instalment_commission_percent AS instalment_commission_percent_32, t18.pay_later_v2_commission_percent AS pay_later_v2_commission_percent_33, t18.instalment4_commission_percent AS instalment4_commission_percent_34, t18.instalment6_commission_percent AS instalment6_commission_percent_35, t18.eik AS eik_36, t18.purchase_expiration_hours AS purchase_expiration_hours_37, t18.unshipped_purchase_days AS unshipped_purchase_days_38, t18.pay_now_allowed AS pay_now_allowed_39, t18.purchase_to_be_paid_days AS purchase_to_be_paid_days_40, t18.minimum_amount_for_payment AS minimum_amount_for_payment_41, t18.platform AS platform_42, t18.grace_start_date AS grace_start_date_43, t18.grace_duration_days AS grace_duration_days_44, t18.purchase_finalised_redirect_timer_seconds AS purchase_finalised_redirect_timer_seconds_45, t18.created_at AS created_at_46, t18.updated_at AS updated_at_47, t18.cover_image_id AS cover_image_id_48, t18.shop_id AS shop_id_49, t0.api_token_id AS api_token_id_50, t52.id AS id_51, t52.percent AS percent_53, t52.start_date AS start_date_54, t52.end_date AS end_date_55, t52.created_at AS created_at_56, t52.updated_at AS updated_at_57, t52.shop_id AS shop_id_58, t0.dtype FROM users t0 LEFT JOIN shop_profile t18 ON t18.shop_id = t0.id LEFT JOIN instalment6_interest_rate_promotion t52 ON t52.shop_id = t0.id INNER JOIN shop_shop_category ON t0.id = shop_shop_category.shop_id WHERE shop_shop_category.shop_category_id = ? AND t0.dtype IN ('shop') Parameters: [`5`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.`key` AS key_8, t0.secret AS secret_9, t0.shipping_confirmation_required AS shipping_confirmation_required_10, t0.calculation_strategy AS calculation_strategy_11, t0.developer_password AS developer_password_12, t0.allowed_products AS allowed_products_13, t0.position_index AS position_index_14, t0.receiving_bank_account_id AS receiving_bank_account_id_15, t0.sending_bank_account_id AS sending_bank_account_id_16, t18.id AS id_17, t18.address AS address_19, t18.contact AS contact_20, t18.phone1 AS phone1_21, t18.phone2 AS phone2_22, t18.phone3 AS phone3_23, t18.email2 AS email2_24, t18.email3 AS email3_25, t18.name AS name_26, t18.company_name AS company_name_27, t18.web_address AS web_address_28, t18.callback_url AS callback_url_29, t18.pay_now_commission_percent AS pay_now_commission_percent_30, t18.pay_later_commission_percent AS pay_later_commission_percent_31, t18.instalment_commission_percent AS instalment_commission_percent_32, t18.pay_later_v2_commission_percent AS pay_later_v2_commission_percent_33, t18.instalment4_commission_percent AS instalment4_commission_percent_34, t18.instalment6_commission_percent AS instalment6_commission_percent_35, t18.eik AS eik_36, t18.purchase_expiration_hours AS purchase_expiration_hours_37, t18.unshipped_purchase_days AS unshipped_purchase_days_38, t18.pay_now_allowed AS pay_now_allowed_39, t18.purchase_to_be_paid_days AS purchase_to_be_paid_days_40, t18.minimum_amount_for_payment AS minimum_amount_for_payment_41, t18.platform AS platform_42, t18.grace_start_date AS grace_start_date_43, t18.grace_duration_days AS grace_duration_days_44, t18.purchase_finalised_redirect_timer_seconds AS purchase_finalised_redirect_timer_seconds_45, t18.created_at AS created_at_46, t18.updated_at AS updated_at_47, t18.cover_image_id AS cover_image_id_48, t18.shop_id AS shop_id_49, t0.api_token_id AS api_token_id_50, t52.id AS id_51, t52.percent AS percent_53, t52.start_date AS start_date_54, t52.end_date AS end_date_55, t52.created_at AS created_at_56, t52.updated_at AS updated_at_57, t52.shop_id AS shop_id_58, t0.dtype FROM users t0 LEFT JOIN shop_profile t18 ON t18.shop_id = t0.id LEFT JOIN instalment6_interest_rate_promotion t52 ON t52.shop_id = t0.id INNER JOIN shop_shop_category ON t0.id = shop_shop_category.shop_id WHERE shop_shop_category.shop_category_id = ? AND t0.dtype IN ('shop') SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.`key` AS key_8, t0.secret AS secret_9, t0.shipping_confirmation_required AS shipping_confirmation_required_10, t0.calculation_strategy AS calculation_strategy_11, t0.developer_password AS developer_password_12, t0.allowed_products AS allowed_products_13, t0.position_index AS position_index_14, t0.receiving_bank_account_id AS receiving_bank_account_id_15, t0.sending_bank_account_id AS sending_bank_account_id_16, t18.id AS id_17, t18.address AS address_19, t18.contact AS contact_20, t18.phone1 AS phone1_21, t18.phone2 AS phone2_22, t18.phone3 AS phone3_23, t18.email2 AS email2_24, t18.email3 AS email3_25, t18.name AS name_26, t18.company_name AS company_name_27, t18.web_address AS web_address_28, t18.callback_url AS callback_url_29, t18.pay_now_commission_percent AS pay_now_commission_percent_30, t18.pay_later_commission_percent AS pay_later_commission_percent_31, t18.instalment_commission_percent AS instalment_commission_percent_32, t18.pay_later_v2_commission_percent AS pay_later_v2_commission_percent_33, t18.instalment4_commission_percent AS instalment4_commission_percent_34, t18.instalment6_commission_percent AS instalment6_commission_percent_35, t18.eik AS eik_36, t18.purchase_expiration_hours AS purchase_expiration_hours_37, t18.unshipped_purchase_days AS unshipped_purchase_days_38, t18.pay_now_allowed AS pay_now_allowed_39, t18.purchase_to_be_paid_days AS purchase_to_be_paid_days_40, t18.minimum_amount_for_payment AS minimum_amount_for_payment_41, t18.platform AS platform_42, t18.grace_start_date AS grace_start_date_43, t18.grace_duration_days AS grace_duration_days_44, t18.purchase_finalised_redirect_timer_seconds AS purchase_finalised_redirect_timer_seconds_45, t18.created_at AS created_at_46, t18.updated_at AS updated_at_47, t18.cover_image_id AS cover_image_id_48, t18.shop_id AS shop_id_49, t0.api_token_id AS api_token_id_50, t52.id AS id_51, t52.percent AS percent_53, t52.start_date AS start_date_54, t52.end_date AS end_date_55, t52.created_at AS created_at_56, t52.updated_at AS updated_at_57, t52.shop_id AS shop_id_58, t0.dtype FROM users t0 LEFT JOIN shop_profile t18 ON t18.shop_id = t0.id LEFT JOIN instalment6_interest_rate_promotion t52 ON t52.shop_id = t0.id INNER JOIN shop_shop_category ON t0.id = shop_shop_category.shop_id WHERE shop_shop_category.shop_category_id = 5 AND t0.dtype IN ('shop');
22	2.23 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.mime AS mime_3, t0.size AS size_4, t0.original_name AS original_name_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.dtype FROM file t0 WHERE t0.id = ? AND t0.dtype IN ('image') Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.mime AS mime_3, t0.size AS size_4, t0.original_name AS original_name_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.dtype FROM file t0 WHERE t0.id = ? AND t0.dtype IN ('image') SELECT t0.id AS id_1, t0.name AS name_2, t0.mime AS mime_3, t0.size AS size_4, t0.original_name AS original_name_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.dtype FROM file t0 WHERE t0.id = 1 AND t0.dtype IN ('image');
23	1.23 ms	SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.ui_label AS ui_label_2, s0_.value AS value_3, s0_.readonly AS readonly_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6 FROM setting s0_ WHERE s0_.name = ? LIMIT 1 Parameters: [`"facebook_link"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.ui_label AS ui_label_2, s0_.value AS value_3, s0_.readonly AS readonly_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6 FROM setting s0_ WHERE s0_.name = ? LIMIT 1 SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.ui_label AS ui_label_2, s0_.value AS value_3, s0_.readonly AS readonly_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6 FROM setting s0_ WHERE s0_.name = 'facebook_link' LIMIT 1;
24	0.71 ms	SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.ui_label AS ui_label_2, s0_.value AS value_3, s0_.readonly AS readonly_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6 FROM setting s0_ WHERE s0_.name = ? LIMIT 1 Parameters: [`"instagram_link"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.ui_label AS ui_label_2, s0_.value AS value_3, s0_.readonly AS readonly_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6 FROM setting s0_ WHERE s0_.name = ? LIMIT 1 SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.ui_label AS ui_label_2, s0_.value AS value_3, s0_.readonly AS readonly_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6 FROM setting s0_ WHERE s0_.name = 'instagram_link' LIMIT 1;
25	0.61 ms	SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.ui_label AS ui_label_2, s0_.value AS value_3, s0_.readonly AS readonly_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6 FROM setting s0_ WHERE s0_.name = ? LIMIT 1 Parameters: [`"linkedin_link"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.ui_label AS ui_label_2, s0_.value AS value_3, s0_.readonly AS readonly_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6 FROM setting s0_ WHERE s0_.name = ? LIMIT 1 SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.ui_label AS ui_label_2, s0_.value AS value_3, s0_.readonly AS readonly_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6 FROM setting s0_ WHERE s0_.name = 'linkedin_link' LIMIT 1;

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
App\Entity\Purchase	No errors.
App\Entity\CustomerPayment	No errors.
App\Entity\User	No errors.
App\Entity\Customer	No errors.
App\Entity\Shop	No errors.
App\Entity\Setting	No errors.
App\Entity\BankAccount	No errors.
App\Entity\ApiToken	No errors.
App\Entity\Permission\Group	No errors.
App\Entity\DatabaseNotification	No errors.
App\Entity\ShopPayment	No errors.
App\Entity\ShopProfile	No errors.
App\Entity\File	No errors.
App\Entity\Image	No errors.
App\Entity\Instalment6InterestRatePromotion	No errors.
App\Entity\ShopCategory	No errors.

Symfony Profiler

https://newpay.ruychev.ssft.me/partners

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping