GET https://newpay6.ruychev.ssft.me/partners

Response
200 OK
IP
216.73.216.153
Profiled on
Token
c16df8

Query Metrics

21 Database Queries
8 Different statements
30.50 ms Query time
3 Invalid entities
23 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.78 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    View query backtrace
2 1.42 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    View query backtrace
3 1.28 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    View query backtrace
4 1.02 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: 
[
  9
  10
  11
  12
  13
  14
]
View formatted query    View runnable query    Explain query    View query backtrace
5 3.07 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    View query backtrace
6 2.22 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    View query backtrace
7 1.08 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    View query backtrace
8 0.82 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    View query backtrace
9 1.29 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    View query backtrace
10 1.04 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    View query backtrace
11 1.65 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    View query backtrace
12 1.05 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    View query backtrace
13 1.54 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    View query backtrace
14 1.15 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    View query backtrace
15 1.54 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    View query backtrace
16 1.02 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    View query backtrace
17 2.86 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    View query backtrace
18 1.95 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    View query backtrace
19 0.93 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    View query backtrace
20 0.99 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    View query backtrace
21 0.79 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    View query backtrace

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\User 6
App\Entity\ShopProfile 6
App\Entity\Instalment6InterestRatePromotion 6
App\Entity\Setting 4
App\Entity\File 1

Entities Mapping

Class Mapping errors
App\Entity\User 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\Purchase
  • The field 'App\Entity\Purchase#amount' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\ShopPayment
  • The field 'App\Entity\ShopPayment#payNowCommissionValue' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\ShopPayment#payLaterCommissionValue' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\ShopPayment#instalmentCommissionValue' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\ShopPayment#payLaterV2CommissionValue' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\ShopPayment#instalment4CommissionValue' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\ShopPayment#instalment6CommissionValue' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\ShopProfile
  • The field 'App\Entity\ShopProfile#minimumAmountForPayment' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\File No errors.
App\Entity\Image No errors.
App\Entity\Instalment6InterestRatePromotion No errors.
App\Entity\ShopCategory No errors.