Symfony Profiler

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');

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.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.id = '5';

SELECT
  count(DISTINCT u0_.id) AS sclr_0
FROM
  users u0_
  INNER JOIN shop_shop_category s2_ ON u0_.id = s2_.shop_id
  INNER JOIN shop_category s1_ ON s1_.id = s2_.shop_category_id
WHERE
  (
    u0_.active = 1
    AND s1_.id IN (?)
  )
  AND u0_.dtype IN ('shop')

SELECT count(DISTINCT u0_.id) AS sclr_0 FROM users u0_ INNER JOIN shop_shop_category s2_ ON u0_.id = s2_.shop_id INNER JOIN shop_category s1_ ON s1_.id = s2_.shop_category_id WHERE (u0_.active = 1 AND s1_.id IN (5)) AND u0_.dtype IN ('shop');

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;

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 = 5;

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;

SELECT
  DISTINCT u0_.id AS id_0,
  u0_.position_index AS position_index_1
FROM
  users u0_
  INNER JOIN shop_shop_category s2_ ON u0_.id = s2_.shop_id
  INNER JOIN shop_category s1_ ON s1_.id = s2_.shop_category_id
WHERE
  (
    u0_.active = 1
    AND s1_.id IN (?)
  )
  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_ INNER JOIN shop_shop_category s2_ ON u0_.id = s2_.shop_id INNER JOIN shop_category s1_ ON s1_.id = s2_.shop_category_id WHERE (u0_.active = 1 AND s1_.id IN (5)) AND u0_.dtype IN ('shop') ORDER BY u0_.position_index ASC LIMIT 16;