Symfony Profiler

Query Metrics

64 Database Queries

35 Different statements

185.17 ms Query time

0 Invalid entities

44 Managed entities

Queries

Group similar statements

default connection


SELECT t0.ip_number AS ip_number_1, t0.ip AS ip_2, t0.country_code AS country_code_3, t0.city_name AS city_name_4, t0.country_name AS country_name_5, t0.region_name AS region_name_6, t0.region_short_name AS region_short_name_7, t0.timezone AS timezone_8, t0.zipcode AS zipcode_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.is_proxy AS is_proxy_12, t0.proxy_type AS proxy_type_13, t0.risk_score AS risk_score_14 FROM ip_geo t0 WHERE t0.ip_number = ?
SELECT t0.id AS id_1, t0.solid_id AS solid_id_2, t0.status AS status_3, t0.is_trial AS is_trial_4, t0.started_at AS started_at_5, t0.expired_at AS expired_at_6, t0.next_charge_at AS next_charge_at_7, t0.cancelled_at AS cancelled_at_8, t0.updated_at AS updated_at_9, t0.cancel_reason AS cancel_reason_10, t0.user_id AS user_id_11, t0.pay_bundle_id AS pay_bundle_id_12 FROM solid_gate_subscription t0 WHERE t0.solid_id = ? LIMIT 1
"START TRANSACTION"
UPDATE solid_gate_subscription SET expired_at = ?, next_charge_at = ?, updated_at = ? WHERE id = ?
"COMMIT"
SELECT t0.solid_created_at AS solid_created_at_1, t0.solid_updated_at AS solid_updated_at_2, t0.last_order_id AS last_order_id_3, t0.last_order_operation AS last_order_operation_4, t0.last_order_status AS last_order_status_5, t0.id AS id_6, t0.solid_id AS solid_id_7, t0.status AS status_8, t0.amount AS amount_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.solid_subscription_id AS solid_subscription_id_12, t0.user_id AS user_id_13 FROM solid_gate_subscription_invoice t0 WHERE t0.solid_id = ? LIMIT 1
SELECT t0.context AS context_1, t0.id AS id_2, t0.status AS status_3, t0.pay_form_token AS pay_form_token_4, t0.descriptor AS descriptor_5, t0.operation AS operation_6, t0.error AS error_7, t0.refunded_at AS refunded_at_8, t0.refund_reason_code AS refund_reason_code_9, t0.refunded_amount AS refunded_amount_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.user_id AS user_id_13, t0.pay_bundle_id AS pay_bundle_id_14, t0.card_id AS card_id_15, t0.solid_subscription_id AS solid_subscription_id_16 FROM solid_gate_order t0 WHERE t0.id = ?
"START TRANSACTION"
INSERT INTO solid_gate_subscription_invoice (solid_created_at, solid_updated_at, last_order_id, last_order_operation, last_order_status, solid_id, status, amount, created_at, updated_at, solid_subscription_id, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
"COMMIT"
SELECT p0_.id AS id_0, p0_.context AS context_1, p0_.started_at AS started_at_2, p0_.trial_ended_at AS trial_ended_at_3, p0_.next_charge_at AS next_charge_at_4, p0_.next_charge_notified_about AS next_charge_notified_about_5, p0_.canceled_at AS canceled_at_6, p0_.cancellation_details AS cancellation_details_7, p0_.ended_at AS ended_at_8, p0_.refunded_at AS refunded_at_9, p0_.original_user_id AS original_user_id_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.user_id AS user_id_13, p0_.bundle_id AS bundle_id_14 FROM payment_subscription p0_ WHERE JSON_EXTRACT(p0_.context, '$.solid_id') = ?
SELECT s0_.solid_created_at AS solid_created_at_0, s0_.solid_updated_at AS solid_updated_at_1, s0_.last_order_id AS last_order_id_2, s0_.last_order_operation AS last_order_operation_3, s0_.last_order_status AS last_order_status_4, s0_.id AS id_5, s0_.solid_id AS solid_id_6, s0_.status AS status_7, s0_.amount AS amount_8, s0_.created_at AS created_at_9, s0_.updated_at AS updated_at_10, s0_.solid_subscription_id AS solid_subscription_id_11, s0_.user_id AS user_id_12 FROM solid_gate_subscription_invoice s0_ WHERE s0_.status = ? AND s0_.solid_subscription_id = ?
SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ?
SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ?
SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ?
SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ?
SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ?
SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ?
SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ?
SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ?
SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ?
SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ?
SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ?
SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ?
SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ?
SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ?
SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ?
SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ?
SELECT t0.id AS id_1, t0.`key` AS key_2, t0.gateway_id AS gateway_id_3, t0.type AS type_4, t0.internal_title AS internal_title_5, t0.public_title AS public_title_6, t0.title AS title_7, t0.subtitle AS subtitle_8, t0.offer AS offer_9, t0.description AS description_10, t0.full_price AS full_price_11, t0.price AS price_12, t0.currency AS currency_13, t0.discount AS discount_14, t0.extra AS extra_15, t0.stack_id AS stack_id_16, t0.status AS status_17, t0.application AS application_18 FROM pay_bundles t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.birth_date AS birth_date_3, t0.gender AS gender_4, t0.orientation AS orientation_5, t0.email AS email_6, t0.pwd AS pwd_7, t0.ok AS ok_8, t0.create_ts AS create_ts_9, t0.partner_id AS partner_id_10, t0.application AS application_11, t0.is_fake AS is_fake_12, t0.timezone AS timezone_13, t0.locale AS locale_14, t0.category AS category_15, t0.platform AS platform_16, t0.previous_avatar_photo_id AS previous_avatar_photo_id_17, t0.is_request_log_enabled AS is_request_log_enabled_18, t0.is_socket_message_log_enabled AS is_socket_message_log_enabled_19, t0.deactivated_at AS deactivated_at_20, t0.region AS region_21, t0.previous_ok AS previous_ok_22, t0.roles AS roles_23, t0.kasha_revision_id AS kasha_revision_id_24, t0.kasha_funnel_id AS kasha_funnel_id_25, t0.deleted_at AS deleted_at_26, t0.photo_id AS photo_id_27, t28.id AS id_29, t28.agency_id AS agency_id_30, t28.referrer_id AS referrer_id_31, t28.comment AS comment_32, t28.nationality AS nationality_33, t28.languages AS languages_34, t28.priority AS priority_35, t28.retention_priority AS retention_priority_36, t28.photo_validation_status AS photo_validation_status_37, t28.public_visible AS public_visible_38, t28.verification_status AS verification_status_39, t28.banned_until AS banned_until_40, t28.has_work_permit AS has_work_permit_41, t28.ban_status AS ban_status_42, t28.feedback_rating AS feedback_rating_43, t28.profile_category AS profile_category_44, t28.moderated_at AS moderated_at_45, t28.is_hiti_flutter AS is_hiti_flutter_46, t28.is_welcome_snfsent AS is_welcome_snfsent_47, t28.priority_hold_until AS priority_hold_until_48, t28.level_change_check_at AS level_change_check_at_49, t28.created_at AS created_at_50, t28.updated_at AS updated_at_51, t28.user_id AS user_id_52 FROM users t0 LEFT JOIN streamer t28 ON t28.user_id = t0.id WHERE t0.id = ?
SELECT COUNT(p0_.id) AS sclr_0 FROM payment_transaction p0_ WHERE p0_.user_id = ?
SELECT COUNT(*) FROM payment_transaction t0 WHERE t0.subscription_id = ?
"START TRANSACTION"
INSERT INTO payment_transaction (user_index, application, gateway, platform, price_value, price_currency, price_value_usd, revenue_percentage, transaction_id, original_transaction_id, subscription_transaction_index, refunded_at, refund_details, chargebacked_at, chargeback_status, original_user_id, is_sandbox, created_at, updated_at, user_id, bundle_id, subscription_id, purchase_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
UPDATE payment_subscription SET context = ?, next_charge_at = ?, next_charge_notified_about = ?, ended_at = ?, updated_at = ? WHERE id = ?
"COMMIT"
SELECT t0.claimed AS claimed_1, t0.id AS id_2, t0.amount AS amount_3, t0.list_id AS list_id_4, t0.type AS type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM coin_reward_one_time t0 WHERE t0.list_id = ?
SELECT t0.claimed AS claimed_1, t0.id AS id_2, t0.amount AS amount_3, t0.list_id AS list_id_4, t0.type AS type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM coin_reward_one_time t0 WHERE t0.list_id = ? AND t0.type = ? LIMIT 1
"START TRANSACTION"
INSERT INTO coin_reward_one_time (claimed, id, amount, list_id, type, created_at, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?)
"COMMIT"
SELECT 1 AS sclr_0 FROM user_favorites u0_ WHERE u0_.user_id = ? AND u0_.favorite_user_id = ? LIMIT 1
"START TRANSACTION"
SELECT t0.id AS id_1, t0.name AS name_2, t0.coins AS coins_3, t0.expire_at AS expire_at_4, t0.started_at AS started_at_5, t0.free AS free_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.user_id AS user_id_9 FROM user_coin_balance t0 WHERE t0.user_id = ?
SAVEPOINT DOCTRINE_2
INSERT INTO user_balance_history (transaction_type, amount, old_amount, new_amount, is_free, context, description, created_at, updated_at, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
UPDATE user_coin_balance SET coins = ?, updated_at = ? WHERE id = ?
RELEASE SAVEPOINT DOCTRINE_2
"COMMIT"
SELECT 1 AS sclr_0 FROM user_favorites u0_ WHERE u0_.user_id = ? AND u0_.favorite_user_id = ? LIMIT 1
SELECT i0_.ip_number AS ip_number_0, i0_.ip AS ip_1, i0_.country_code AS country_code_2, i0_.city_name AS city_name_3, i0_.country_name AS country_name_4, i0_.region_name AS region_name_5, i0_.region_short_name AS region_short_name_6, i0_.timezone AS timezone_7, i0_.zipcode AS zipcode_8, i0_.latitude AS latitude_9, i0_.longitude AS longitude_10, i0_.is_proxy AS is_proxy_11, i0_.proxy_type AS proxy_type_12, i0_.risk_score AS risk_score_13 FROM ip_geo i0_ INNER JOIN ip_geo_user_last i1_ ON (i1_.ip_geo_id = i0_.ip_number) WHERE i1_.user_id = ? LIMIT 1
DELETE FROM email_user_auth_token WHERE user_id = ? AND expired_at <= ?
SELECT e0_.token AS token_0, e0_.expired_at AS expired_at_1, e0_.created_at AS created_at_2, e0_.updated_at AS updated_at_3, e0_.user_id AS user_id_4 FROM email_user_auth_token e0_ WHERE e0_.user_id = ? LIMIT 1
"START TRANSACTION"
INSERT INTO email_user_auth_token (token, expired_at, created_at, updated_at, user_id) VALUES (?, ?, ?, ?, ?)
"COMMIT"
SELECT t0.id AS id_1, t0.name AS name_2, t0.gender AS gender_3, t0.birth_date AS birth_date_4, t0.email AS email_5, t0.workspace AS workspace_6, t0.is_confirmed AS is_confirmed_7, t0.is_subscribed AS is_subscribed_8, t0.locale AS locale_9, t0.platform AS platform_10, t0.country AS country_11, t0.in_european_union AS in_european_union_12, t0.timezone AS timezone_13, t0.last_online_ts AS last_online_ts_14, t0.partner_id AS partner_id_15, t0.deleted_reason AS deleted_reason_16, t0.deleted_at AS deleted_at_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.user_id AS user_id_20 FROM email_customer t0 WHERE t0.user_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.account_customer_id AS account_customer_id_2, t0.gclid AS gclid_3, t0.wbraid AS wbraid_4, t0.gbraid AS gbraid_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.user_id AS user_id_8 FROM google_conversion_user_identifier t0 WHERE t0.user_id = ? LIMIT 1

#▲	Time	Info
1	3.31 ms	SELECT t0.ip_number AS ip_number_1, t0.ip AS ip_2, t0.country_code AS country_code_3, t0.city_name AS city_name_4, t0.country_name AS country_name_5, t0.region_name AS region_name_6, t0.region_short_name AS region_short_name_7, t0.timezone AS timezone_8, t0.zipcode AS zipcode_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.is_proxy AS is_proxy_12, t0.proxy_type AS proxy_type_13, t0.risk_score AS risk_score_14 FROM ip_geo t0 WHERE t0.ip_number = ? Parameters: [`752897941`] View formatted query View runnable query Explain query SELECT t0.ip_number AS ip_number_1, t0.ip AS ip_2, t0.country_code AS country_code_3, t0.city_name AS city_name_4, t0.country_name AS country_name_5, t0.region_name AS region_name_6, t0.region_short_name AS region_short_name_7, t0.timezone AS timezone_8, t0.zipcode AS zipcode_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.is_proxy AS is_proxy_12, t0.proxy_type AS proxy_type_13, t0.risk_score AS risk_score_14 FROM ip_geo t0 WHERE t0.ip_number = ? SELECT t0.ip_number AS ip_number_1, t0.ip AS ip_2, t0.country_code AS country_code_3, t0.city_name AS city_name_4, t0.country_name AS country_name_5, t0.region_name AS region_name_6, t0.region_short_name AS region_short_name_7, t0.timezone AS timezone_8, t0.zipcode AS zipcode_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.is_proxy AS is_proxy_12, t0.proxy_type AS proxy_type_13, t0.risk_score AS risk_score_14 FROM ip_geo t0 WHERE t0.ip_number = 752897941;
2	6.50 ms	SELECT t0.id AS id_1, t0.solid_id AS solid_id_2, t0.status AS status_3, t0.is_trial AS is_trial_4, t0.started_at AS started_at_5, t0.expired_at AS expired_at_6, t0.next_charge_at AS next_charge_at_7, t0.cancelled_at AS cancelled_at_8, t0.updated_at AS updated_at_9, t0.cancel_reason AS cancel_reason_10, t0.user_id AS user_id_11, t0.pay_bundle_id AS pay_bundle_id_12 FROM solid_gate_subscription t0 WHERE t0.solid_id = ? LIMIT 1 Parameters: [`"d798a3df-e9f1-4c43-81ee-d9421aa16cfd"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.solid_id AS solid_id_2, t0.status AS status_3, t0.is_trial AS is_trial_4, t0.started_at AS started_at_5, t0.expired_at AS expired_at_6, t0.next_charge_at AS next_charge_at_7, t0.cancelled_at AS cancelled_at_8, t0.updated_at AS updated_at_9, t0.cancel_reason AS cancel_reason_10, t0.user_id AS user_id_11, t0.pay_bundle_id AS pay_bundle_id_12 FROM solid_gate_subscription t0 WHERE t0.solid_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.solid_id AS solid_id_2, t0.status AS status_3, t0.is_trial AS is_trial_4, t0.started_at AS started_at_5, t0.expired_at AS expired_at_6, t0.next_charge_at AS next_charge_at_7, t0.cancelled_at AS cancelled_at_8, t0.updated_at AS updated_at_9, t0.cancel_reason AS cancel_reason_10, t0.user_id AS user_id_11, t0.pay_bundle_id AS pay_bundle_id_12 FROM solid_gate_subscription t0 WHERE t0.solid_id = 'd798a3df-e9f1-4c43-81ee-d9421aa16cfd' LIMIT 1;
3	0.84 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
4	6.41 ms	UPDATE solid_gate_subscription SET expired_at = ?, next_charge_at = ?, updated_at = ? WHERE id = ? Parameters: [`"2025-07-31 12:56:58" "2025-07-31 12:56:58" "2025-07-01 12:57:01" 3406`] View formatted query View runnable query Explain query UPDATE solid_gate_subscription SET expired_at = ?, next_charge_at = ?, updated_at = ? WHERE id = ? UPDATE solid_gate_subscription SET expired_at = '2025-07-31 12:56:58', next_charge_at = '2025-07-31 12:56:58', updated_at = '2025-07-01 12:57:01' WHERE id = 3406;
5	3.62 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
6	7.53 ms	SELECT t0.solid_created_at AS solid_created_at_1, t0.solid_updated_at AS solid_updated_at_2, t0.last_order_id AS last_order_id_3, t0.last_order_operation AS last_order_operation_4, t0.last_order_status AS last_order_status_5, t0.id AS id_6, t0.solid_id AS solid_id_7, t0.status AS status_8, t0.amount AS amount_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.solid_subscription_id AS solid_subscription_id_12, t0.user_id AS user_id_13 FROM solid_gate_subscription_invoice t0 WHERE t0.solid_id = ? LIMIT 1 Parameters: [`"a093c3f9-2e12-412f-8825-3f17f100f176"`] View formatted query View runnable query Explain query SELECT t0.solid_created_at AS solid_created_at_1, t0.solid_updated_at AS solid_updated_at_2, t0.last_order_id AS last_order_id_3, t0.last_order_operation AS last_order_operation_4, t0.last_order_status AS last_order_status_5, t0.id AS id_6, t0.solid_id AS solid_id_7, t0.status AS status_8, t0.amount AS amount_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.solid_subscription_id AS solid_subscription_id_12, t0.user_id AS user_id_13 FROM solid_gate_subscription_invoice t0 WHERE t0.solid_id = ? LIMIT 1 SELECT t0.solid_created_at AS solid_created_at_1, t0.solid_updated_at AS solid_updated_at_2, t0.last_order_id AS last_order_id_3, t0.last_order_operation AS last_order_operation_4, t0.last_order_status AS last_order_status_5, t0.id AS id_6, t0.solid_id AS solid_id_7, t0.status AS status_8, t0.amount AS amount_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.solid_subscription_id AS solid_subscription_id_12, t0.user_id AS user_id_13 FROM solid_gate_subscription_invoice t0 WHERE t0.solid_id = 'a093c3f9-2e12-412f-8825-3f17f100f176' LIMIT 1;
7	2.78 ms	SELECT t0.context AS context_1, t0.id AS id_2, t0.status AS status_3, t0.pay_form_token AS pay_form_token_4, t0.descriptor AS descriptor_5, t0.operation AS operation_6, t0.error AS error_7, t0.refunded_at AS refunded_at_8, t0.refund_reason_code AS refund_reason_code_9, t0.refunded_amount AS refunded_amount_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.user_id AS user_id_13, t0.pay_bundle_id AS pay_bundle_id_14, t0.card_id AS card_id_15, t0.solid_subscription_id AS solid_subscription_id_16 FROM solid_gate_order t0 WHERE t0.id = ? Parameters: [`"d9e044f6-d449-49fd-b464-bbb2e82f6b9b"`] View formatted query View runnable query Explain query SELECT t0.context AS context_1, t0.id AS id_2, t0.status AS status_3, t0.pay_form_token AS pay_form_token_4, t0.descriptor AS descriptor_5, t0.operation AS operation_6, t0.error AS error_7, t0.refunded_at AS refunded_at_8, t0.refund_reason_code AS refund_reason_code_9, t0.refunded_amount AS refunded_amount_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.user_id AS user_id_13, t0.pay_bundle_id AS pay_bundle_id_14, t0.card_id AS card_id_15, t0.solid_subscription_id AS solid_subscription_id_16 FROM solid_gate_order t0 WHERE t0.id = ? SELECT t0.context AS context_1, t0.id AS id_2, t0.status AS status_3, t0.pay_form_token AS pay_form_token_4, t0.descriptor AS descriptor_5, t0.operation AS operation_6, t0.error AS error_7, t0.refunded_at AS refunded_at_8, t0.refund_reason_code AS refund_reason_code_9, t0.refunded_amount AS refunded_amount_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.user_id AS user_id_13, t0.pay_bundle_id AS pay_bundle_id_14, t0.card_id AS card_id_15, t0.solid_subscription_id AS solid_subscription_id_16 FROM solid_gate_order t0 WHERE t0.id = 'd9e044f6-d449-49fd-b464-bbb2e82f6b9b';
8	7.52 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
9	7.70 ms	INSERT INTO solid_gate_subscription_invoice (solid_created_at, solid_updated_at, last_order_id, last_order_operation, last_order_status, solid_id, status, amount, created_at, updated_at, solid_subscription_id, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"2025-07-01 12:56:59" "2025-07-01 12:56:58" "d9e044f6-d449-49fd-b464-bbb2e82f6b9b" "recurring-auth" "auth_ok" "a093c3f9-2e12-412f-8825-3f17f100f176" "success" 2999 "2025-07-01 12:57:01" "2025-07-01 12:57:01" 3406 8065`] View formatted query View runnable query Explain query INSERT INTO solid_gate_subscription_invoice ( solid_created_at, solid_updated_at, last_order_id, last_order_operation, last_order_status, solid_id, status, amount, created_at, updated_at, solid_subscription_id, user_id ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO solid_gate_subscription_invoice (solid_created_at, solid_updated_at, last_order_id, last_order_operation, last_order_status, solid_id, status, amount, created_at, updated_at, solid_subscription_id, user_id) VALUES ('2025-07-01 12:56:59', '2025-07-01 12:56:58', 'd9e044f6-d449-49fd-b464-bbb2e82f6b9b', 'recurring-auth', 'auth_ok', 'a093c3f9-2e12-412f-8825-3f17f100f176', 'success', 2999, '2025-07-01 12:57:01', '2025-07-01 12:57:01', 3406, 8065);
10	2.18 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
11	3.51 ms	SELECT p0_.id AS id_0, p0_.context AS context_1, p0_.started_at AS started_at_2, p0_.trial_ended_at AS trial_ended_at_3, p0_.next_charge_at AS next_charge_at_4, p0_.next_charge_notified_about AS next_charge_notified_about_5, p0_.canceled_at AS canceled_at_6, p0_.cancellation_details AS cancellation_details_7, p0_.ended_at AS ended_at_8, p0_.refunded_at AS refunded_at_9, p0_.original_user_id AS original_user_id_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.user_id AS user_id_13, p0_.bundle_id AS bundle_id_14 FROM payment_subscription p0_ WHERE JSON_EXTRACT(p0_.context, '$.solid_id') = ? Parameters: [`3406`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.context AS context_1, p0_.started_at AS started_at_2, p0_.trial_ended_at AS trial_ended_at_3, p0_.next_charge_at AS next_charge_at_4, p0_.next_charge_notified_about AS next_charge_notified_about_5, p0_.canceled_at AS canceled_at_6, p0_.cancellation_details AS cancellation_details_7, p0_.ended_at AS ended_at_8, p0_.refunded_at AS refunded_at_9, p0_.original_user_id AS original_user_id_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.user_id AS user_id_13, p0_.bundle_id AS bundle_id_14 FROM payment_subscription p0_ WHERE JSON_EXTRACT(p0_.context, '$.solid_id') = ? SELECT p0_.id AS id_0, p0_.context AS context_1, p0_.started_at AS started_at_2, p0_.trial_ended_at AS trial_ended_at_3, p0_.next_charge_at AS next_charge_at_4, p0_.next_charge_notified_about AS next_charge_notified_about_5, p0_.canceled_at AS canceled_at_6, p0_.cancellation_details AS cancellation_details_7, p0_.ended_at AS ended_at_8, p0_.refunded_at AS refunded_at_9, p0_.original_user_id AS original_user_id_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.user_id AS user_id_13, p0_.bundle_id AS bundle_id_14 FROM payment_subscription p0_ WHERE JSON_EXTRACT(p0_.context, '$.solid_id') = 3406;
12	1.03 ms	SELECT s0_.solid_created_at AS solid_created_at_0, s0_.solid_updated_at AS solid_updated_at_1, s0_.last_order_id AS last_order_id_2, s0_.last_order_operation AS last_order_operation_3, s0_.last_order_status AS last_order_status_4, s0_.id AS id_5, s0_.solid_id AS solid_id_6, s0_.status AS status_7, s0_.amount AS amount_8, s0_.created_at AS created_at_9, s0_.updated_at AS updated_at_10, s0_.solid_subscription_id AS solid_subscription_id_11, s0_.user_id AS user_id_12 FROM solid_gate_subscription_invoice s0_ WHERE s0_.status = ? AND s0_.solid_subscription_id = ? Parameters: [`"success" 3406`] View formatted query View runnable query Explain query SELECT s0_.solid_created_at AS solid_created_at_0, s0_.solid_updated_at AS solid_updated_at_1, s0_.last_order_id AS last_order_id_2, s0_.last_order_operation AS last_order_operation_3, s0_.last_order_status AS last_order_status_4, s0_.id AS id_5, s0_.solid_id AS solid_id_6, s0_.status AS status_7, s0_.amount AS amount_8, s0_.created_at AS created_at_9, s0_.updated_at AS updated_at_10, s0_.solid_subscription_id AS solid_subscription_id_11, s0_.user_id AS user_id_12 FROM solid_gate_subscription_invoice s0_ WHERE s0_.status = ? AND s0_.solid_subscription_id = ? SELECT s0_.solid_created_at AS solid_created_at_0, s0_.solid_updated_at AS solid_updated_at_1, s0_.last_order_id AS last_order_id_2, s0_.last_order_operation AS last_order_operation_3, s0_.last_order_status AS last_order_status_4, s0_.id AS id_5, s0_.solid_id AS solid_id_6, s0_.status AS status_7, s0_.amount AS amount_8, s0_.created_at AS created_at_9, s0_.updated_at AS updated_at_10, s0_.solid_subscription_id AS solid_subscription_id_11, s0_.user_id AS user_id_12 FROM solid_gate_subscription_invoice s0_ WHERE s0_.status = 'success' AND s0_.solid_subscription_id = 3406;
13	0.83 ms	SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ? Parameters: [`"solid_gate_sub_invoice_33fb326c-e637-4737-9922-1ea64864a25f"`] View formatted query View runnable query Explain query SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ? SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = 'solid_gate_sub_invoice_33fb326c-e637-4737-9922-1ea64864a25f';
14	0.85 ms	SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ? Parameters: [`"solid_gate_sub_invoice_e398fa0f-d92c-4b61-8b78-b3c2dbfa19c8"`] View formatted query View runnable query Explain query SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ? SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = 'solid_gate_sub_invoice_e398fa0f-d92c-4b61-8b78-b3c2dbfa19c8';
15	1.49 ms	SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ? Parameters: [`"solid_gate_sub_invoice_74fed48d-07ca-4dd6-a0c5-77eb87b0856a"`] View formatted query View runnable query Explain query SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ? SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = 'solid_gate_sub_invoice_74fed48d-07ca-4dd6-a0c5-77eb87b0856a';
16	1.15 ms	SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ? Parameters: [`"solid_gate_sub_invoice_44687ccb-4ed4-4651-96f6-aeb7f955b981"`] View formatted query View runnable query Explain query SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ? SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = 'solid_gate_sub_invoice_44687ccb-4ed4-4651-96f6-aeb7f955b981';
17	0.69 ms	SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ? Parameters: [`"solid_gate_sub_invoice_c940fcc7-b321-4019-a3d2-bcbc7fae0a6f"`] View formatted query View runnable query Explain query SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ? SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = 'solid_gate_sub_invoice_c940fcc7-b321-4019-a3d2-bcbc7fae0a6f';
18	3.44 ms	SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ? Parameters: [`"solid_gate_sub_invoice_f9bf2331-3283-4674-86b4-054ec929d76a"`] View formatted query View runnable query Explain query SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ? SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = 'solid_gate_sub_invoice_f9bf2331-3283-4674-86b4-054ec929d76a';
19	0.98 ms	SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ? Parameters: [`"solid_gate_sub_invoice_68c29c64-6128-42de-8b96-79470938258b"`] View formatted query View runnable query Explain query SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ? SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = 'solid_gate_sub_invoice_68c29c64-6128-42de-8b96-79470938258b';
20	6.21 ms	SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ? Parameters: [`"solid_gate_sub_invoice_9b679620-e014-4ed3-8f44-a49f0b60278c"`] View formatted query View runnable query Explain query SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ? SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = 'solid_gate_sub_invoice_9b679620-e014-4ed3-8f44-a49f0b60278c';
21	1.92 ms	SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ? Parameters: [`"solid_gate_sub_invoice_463ce547-43cf-4c1c-b0ca-aef7cc8f6a4e"`] View formatted query View runnable query Explain query SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ? SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = 'solid_gate_sub_invoice_463ce547-43cf-4c1c-b0ca-aef7cc8f6a4e';
22	0.64 ms	SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ? Parameters: [`"solid_gate_sub_invoice_ff88517d-e09d-4144-b687-99aae974946f"`] View formatted query View runnable query Explain query SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ? SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = 'solid_gate_sub_invoice_ff88517d-e09d-4144-b687-99aae974946f';
23	0.68 ms	SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ? Parameters: [`"solid_gate_sub_invoice_20d9795b-2491-4677-9b1c-9bbb2b2276f9"`] View formatted query View runnable query Explain query SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ? SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = 'solid_gate_sub_invoice_20d9795b-2491-4677-9b1c-9bbb2b2276f9';
24	3.44 ms	SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ? Parameters: [`"solid_gate_sub_invoice_48d1a2d6-5889-4d25-895b-f119faf8d712"`] View formatted query View runnable query Explain query SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ? SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = 'solid_gate_sub_invoice_48d1a2d6-5889-4d25-895b-f119faf8d712';
25	0.90 ms	SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ? Parameters: [`"solid_gate_sub_invoice_a5bcd028-e128-45eb-9b0d-e9e922ea5d56"`] View formatted query View runnable query Explain query SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ? SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = 'solid_gate_sub_invoice_a5bcd028-e128-45eb-9b0d-e9e922ea5d56';
26	0.68 ms	SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ? Parameters: [`"solid_gate_sub_invoice_0f282690-200f-40f3-b81b-81c10888f49c"`] View formatted query View runnable query Explain query SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ? SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = 'solid_gate_sub_invoice_0f282690-200f-40f3-b81b-81c10888f49c';
27	0.87 ms	SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ? Parameters: [`"solid_gate_sub_invoice_2264537c-6e36-42e4-a02c-2143ba4f7f17"`] View formatted query View runnable query Explain query SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ? SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = 'solid_gate_sub_invoice_2264537c-6e36-42e4-a02c-2143ba4f7f17';
28	3.43 ms	SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ? Parameters: [`"solid_gate_sub_invoice_a093c3f9-2e12-412f-8825-3f17f100f176"`] View formatted query View runnable query Explain query SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = ? SELECT p0_.user_index AS user_index_0, p0_.id AS id_1, p0_.application AS application_2, p0_.gateway AS gateway_3, p0_.platform AS platform_4, p0_.price_value AS price_value_5, p0_.price_currency AS price_currency_6, p0_.price_value_usd AS price_value_usd_7, p0_.revenue_percentage AS revenue_percentage_8, p0_.transaction_id AS transaction_id_9, p0_.original_transaction_id AS original_transaction_id_10, p0_.subscription_transaction_index AS subscription_transaction_index_11, p0_.refunded_at AS refunded_at_12, p0_.refund_details AS refund_details_13, p0_.chargebacked_at AS chargebacked_at_14, p0_.chargeback_status AS chargeback_status_15, p0_.original_user_id AS original_user_id_16, p0_.is_sandbox AS is_sandbox_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.user_id AS user_id_20, p0_.bundle_id AS bundle_id_21, p0_.subscription_id AS subscription_id_22, p0_.purchase_id AS purchase_id_23 FROM payment_transaction p0_ WHERE p0_.transaction_id = 'solid_gate_sub_invoice_a093c3f9-2e12-412f-8825-3f17f100f176';
29	1.80 ms	SELECT t0.id AS id_1, t0.`key` AS key_2, t0.gateway_id AS gateway_id_3, t0.type AS type_4, t0.internal_title AS internal_title_5, t0.public_title AS public_title_6, t0.title AS title_7, t0.subtitle AS subtitle_8, t0.offer AS offer_9, t0.description AS description_10, t0.full_price AS full_price_11, t0.price AS price_12, t0.currency AS currency_13, t0.discount AS discount_14, t0.extra AS extra_15, t0.stack_id AS stack_id_16, t0.status AS status_17, t0.application AS application_18 FROM pay_bundles t0 WHERE t0.id = ? Parameters: [`243`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.`key` AS key_2, t0.gateway_id AS gateway_id_3, t0.type AS type_4, t0.internal_title AS internal_title_5, t0.public_title AS public_title_6, t0.title AS title_7, t0.subtitle AS subtitle_8, t0.offer AS offer_9, t0.description AS description_10, t0.full_price AS full_price_11, t0.price AS price_12, t0.currency AS currency_13, t0.discount AS discount_14, t0.extra AS extra_15, t0.stack_id AS stack_id_16, t0.status AS status_17, t0.application AS application_18 FROM pay_bundles t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.`key` AS key_2, t0.gateway_id AS gateway_id_3, t0.type AS type_4, t0.internal_title AS internal_title_5, t0.public_title AS public_title_6, t0.title AS title_7, t0.subtitle AS subtitle_8, t0.offer AS offer_9, t0.description AS description_10, t0.full_price AS full_price_11, t0.price AS price_12, t0.currency AS currency_13, t0.discount AS discount_14, t0.extra AS extra_15, t0.stack_id AS stack_id_16, t0.status AS status_17, t0.application AS application_18 FROM pay_bundles t0 WHERE t0.id = 243;
30	0.92 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.birth_date AS birth_date_3, t0.gender AS gender_4, t0.orientation AS orientation_5, t0.email AS email_6, t0.pwd AS pwd_7, t0.ok AS ok_8, t0.create_ts AS create_ts_9, t0.partner_id AS partner_id_10, t0.application AS application_11, t0.is_fake AS is_fake_12, t0.timezone AS timezone_13, t0.locale AS locale_14, t0.category AS category_15, t0.platform AS platform_16, t0.previous_avatar_photo_id AS previous_avatar_photo_id_17, t0.is_request_log_enabled AS is_request_log_enabled_18, t0.is_socket_message_log_enabled AS is_socket_message_log_enabled_19, t0.deactivated_at AS deactivated_at_20, t0.region AS region_21, t0.previous_ok AS previous_ok_22, t0.roles AS roles_23, t0.kasha_revision_id AS kasha_revision_id_24, t0.kasha_funnel_id AS kasha_funnel_id_25, t0.deleted_at AS deleted_at_26, t0.photo_id AS photo_id_27, t28.id AS id_29, t28.agency_id AS agency_id_30, t28.referrer_id AS referrer_id_31, t28.comment AS comment_32, t28.nationality AS nationality_33, t28.languages AS languages_34, t28.priority AS priority_35, t28.retention_priority AS retention_priority_36, t28.photo_validation_status AS photo_validation_status_37, t28.public_visible AS public_visible_38, t28.verification_status AS verification_status_39, t28.banned_until AS banned_until_40, t28.has_work_permit AS has_work_permit_41, t28.ban_status AS ban_status_42, t28.feedback_rating AS feedback_rating_43, t28.profile_category AS profile_category_44, t28.moderated_at AS moderated_at_45, t28.is_hiti_flutter AS is_hiti_flutter_46, t28.is_welcome_snfsent AS is_welcome_snfsent_47, t28.priority_hold_until AS priority_hold_until_48, t28.level_change_check_at AS level_change_check_at_49, t28.created_at AS created_at_50, t28.updated_at AS updated_at_51, t28.user_id AS user_id_52 FROM users t0 LEFT JOIN streamer t28 ON t28.user_id = t0.id WHERE t0.id = ? Parameters: [`8065`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.birth_date AS birth_date_3, t0.gender AS gender_4, t0.orientation AS orientation_5, t0.email AS email_6, t0.pwd AS pwd_7, t0.ok AS ok_8, t0.create_ts AS create_ts_9, t0.partner_id AS partner_id_10, t0.application AS application_11, t0.is_fake AS is_fake_12, t0.timezone AS timezone_13, t0.locale AS locale_14, t0.category AS category_15, t0.platform AS platform_16, t0.previous_avatar_photo_id AS previous_avatar_photo_id_17, t0.is_request_log_enabled AS is_request_log_enabled_18, t0.is_socket_message_log_enabled AS is_socket_message_log_enabled_19, t0.deactivated_at AS deactivated_at_20, t0.region AS region_21, t0.previous_ok AS previous_ok_22, t0.roles AS roles_23, t0.kasha_revision_id AS kasha_revision_id_24, t0.kasha_funnel_id AS kasha_funnel_id_25, t0.deleted_at AS deleted_at_26, t0.photo_id AS photo_id_27, t28.id AS id_29, t28.agency_id AS agency_id_30, t28.referrer_id AS referrer_id_31, t28.comment AS comment_32, t28.nationality AS nationality_33, t28.languages AS languages_34, t28.priority AS priority_35, t28.retention_priority AS retention_priority_36, t28.photo_validation_status AS photo_validation_status_37, t28.public_visible AS public_visible_38, t28.verification_status AS verification_status_39, t28.banned_until AS banned_until_40, t28.has_work_permit AS has_work_permit_41, t28.ban_status AS ban_status_42, t28.feedback_rating AS feedback_rating_43, t28.profile_category AS profile_category_44, t28.moderated_at AS moderated_at_45, t28.is_hiti_flutter AS is_hiti_flutter_46, t28.is_welcome_snfsent AS is_welcome_snfsent_47, t28.priority_hold_until AS priority_hold_until_48, t28.level_change_check_at AS level_change_check_at_49, t28.created_at AS created_at_50, t28.updated_at AS updated_at_51, t28.user_id AS user_id_52 FROM users t0 LEFT JOIN streamer t28 ON t28.user_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.birth_date AS birth_date_3, t0.gender AS gender_4, t0.orientation AS orientation_5, t0.email AS email_6, t0.pwd AS pwd_7, t0.ok AS ok_8, t0.create_ts AS create_ts_9, t0.partner_id AS partner_id_10, t0.application AS application_11, t0.is_fake AS is_fake_12, t0.timezone AS timezone_13, t0.locale AS locale_14, t0.category AS category_15, t0.platform AS platform_16, t0.previous_avatar_photo_id AS previous_avatar_photo_id_17, t0.is_request_log_enabled AS is_request_log_enabled_18, t0.is_socket_message_log_enabled AS is_socket_message_log_enabled_19, t0.deactivated_at AS deactivated_at_20, t0.region AS region_21, t0.previous_ok AS previous_ok_22, t0.roles AS roles_23, t0.kasha_revision_id AS kasha_revision_id_24, t0.kasha_funnel_id AS kasha_funnel_id_25, t0.deleted_at AS deleted_at_26, t0.photo_id AS photo_id_27, t28.id AS id_29, t28.agency_id AS agency_id_30, t28.referrer_id AS referrer_id_31, t28.comment AS comment_32, t28.nationality AS nationality_33, t28.languages AS languages_34, t28.priority AS priority_35, t28.retention_priority AS retention_priority_36, t28.photo_validation_status AS photo_validation_status_37, t28.public_visible AS public_visible_38, t28.verification_status AS verification_status_39, t28.banned_until AS banned_until_40, t28.has_work_permit AS has_work_permit_41, t28.ban_status AS ban_status_42, t28.feedback_rating AS feedback_rating_43, t28.profile_category AS profile_category_44, t28.moderated_at AS moderated_at_45, t28.is_hiti_flutter AS is_hiti_flutter_46, t28.is_welcome_snfsent AS is_welcome_snfsent_47, t28.priority_hold_until AS priority_hold_until_48, t28.level_change_check_at AS level_change_check_at_49, t28.created_at AS created_at_50, t28.updated_at AS updated_at_51, t28.user_id AS user_id_52 FROM users t0 LEFT JOIN streamer t28 ON t28.user_id = t0.id WHERE t0.id = 8065;
31	5.38 ms	SELECT COUNT(p0_.id) AS sclr_0 FROM payment_transaction p0_ WHERE p0_.user_id = ? Parameters: [`8065`] View formatted query View runnable query Explain query SELECT COUNT(p0_.id) AS sclr_0 FROM payment_transaction p0_ WHERE p0_.user_id = ? SELECT COUNT(p0_.id) AS sclr_0 FROM payment_transaction p0_ WHERE p0_.user_id = 8065;
32	1.49 ms	SELECT COUNT() FROM payment_transaction t0 WHERE t0.subscription_id = ? Parameters: [`3863`] View formatted query View runnable query Explain query SELECT COUNT() FROM payment_transaction t0 WHERE t0.subscription_id = ? SELECT COUNT(*) FROM payment_transaction t0 WHERE t0.subscription_id = 3863;
33	7.37 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
34	1.11 ms	INSERT INTO payment_transaction (user_index, application, gateway, platform, price_value, price_currency, price_value_usd, revenue_percentage, transaction_id, original_transaction_id, subscription_transaction_index, refunded_at, refund_details, chargebacked_at, chargeback_status, original_user_id, is_sandbox, created_at, updated_at, user_id, bundle_id, subscription_id, purchase_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`16 "mili" 3 1 29990 "USD" 29990 95 "solid_gate_sub_invoice_a093c3f9-2e12-412f-8825-3f17f100f176" "solid_gate_sub_d798a3df-e9f1-4c43-81ee-d9421aa16cfd" null null null null null 8065 0 "2025-07-01 12:57:01" "2025-07-01 12:57:01" 8065 243 3863 null`] View formatted query View runnable query Explain query INSERT INTO payment_transaction ( user_index, application, gateway, platform, price_value, price_currency, price_value_usd, revenue_percentage, transaction_id, original_transaction_id, subscription_transaction_index, refunded_at, refund_details, chargebacked_at, chargeback_status, original_user_id, is_sandbox, created_at, updated_at, user_id, bundle_id, subscription_id, purchase_id ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) INSERT INTO payment_transaction (user_index, application, gateway, platform, price_value, price_currency, price_value_usd, revenue_percentage, transaction_id, original_transaction_id, subscription_transaction_index, refunded_at, refund_details, chargebacked_at, chargeback_status, original_user_id, is_sandbox, created_at, updated_at, user_id, bundle_id, subscription_id, purchase_id) VALUES (16, 'mili', 3, 1, 29990, 'USD', 29990, 95, 'solid_gate_sub_invoice_a093c3f9-2e12-412f-8825-3f17f100f176', 'solid_gate_sub_d798a3df-e9f1-4c43-81ee-d9421aa16cfd', NULL, NULL, NULL, NULL, NULL, 8065, 0, '2025-07-01 12:57:01', '2025-07-01 12:57:01', 8065, 243, 3863, NULL);
35	0.72 ms	UPDATE payment_subscription SET context = ?, next_charge_at = ?, next_charge_notified_about = ?, ended_at = ?, updated_at = ? WHERE id = ? Parameters: [`"{"solid_id":3406,"renew_count":15}" "2025-07-31 12:56:58" 0 "2025-07-31 12:56:58" "2025-07-01 12:57:01" 3863`] View formatted query View runnable query Explain query UPDATE payment_subscription SET context = ?, next_charge_at = ?, next_charge_notified_about = ?, ended_at = ?, updated_at = ? WHERE id = ? UPDATE payment_subscription SET context = '{\"solid_id\":3406,\"renew_count\":15}', next_charge_at = '2025-07-31 12:56:58', next_charge_notified_about = 0, ended_at = '2025-07-31 12:56:58', updated_at = '2025-07-01 12:57:01' WHERE id = 3863;
36	5.26 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
37	3.06 ms	SELECT t0.claimed AS claimed_1, t0.id AS id_2, t0.amount AS amount_3, t0.list_id AS list_id_4, t0.type AS type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM coin_reward_one_time t0 WHERE t0.list_id = ? Parameters: [`b"\x01—+‘(\x05s÷šÀõ;\x07•\x03c"`] View formatted query View runnable query Explain query SELECT t0.claimed AS claimed_1, t0.id AS id_2, t0.amount AS amount_3, t0.list_id AS list_id_4, t0.type AS type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM coin_reward_one_time t0 WHERE t0.list_id = ? SELECT t0.claimed AS claimed_1, t0.id AS id_2, t0.amount AS amount_3, t0.list_id AS list_id_4, t0.type AS type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM coin_reward_one_time t0 WHERE t0.list_id = 0x01972B91280573F79AC0F53B07950363;
38	7.18 ms	SELECT t0.claimed AS claimed_1, t0.id AS id_2, t0.amount AS amount_3, t0.list_id AS list_id_4, t0.type AS type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM coin_reward_one_time t0 WHERE t0.list_id = ? AND t0.type = ? LIMIT 1 Parameters: [`b"\x01—+‘(\x05s÷šÀõ;\x07•\x03c" "first_purchase"`] View formatted query View runnable query Explain query SELECT t0.claimed AS claimed_1, t0.id AS id_2, t0.amount AS amount_3, t0.list_id AS list_id_4, t0.type AS type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM coin_reward_one_time t0 WHERE t0.list_id = ? AND t0.type = ? LIMIT 1 SELECT t0.claimed AS claimed_1, t0.id AS id_2, t0.amount AS amount_3, t0.list_id AS list_id_4, t0.type AS type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM coin_reward_one_time t0 WHERE t0.list_id = 0x01972B91280573F79AC0F53B07950363 AND t0.type = 'first_purchase' LIMIT 1;
39	0.52 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
40	5.92 ms	INSERT INTO coin_reward_one_time (claimed, id, amount, list_id, type, created_at, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`0 b"\x01—Æ\x0Fí\x05\x7F†›»²\x0FKqV\x04" 120 b"\x01—+‘(\x05s÷šÀõ;\x07•\x03c" "first_purchase" "2025-07-01 12:57:01" "2025-07-01 12:57:01"`] View formatted query View runnable query Explain query INSERT INTO coin_reward_one_time ( claimed, id, amount, list_id, type, created_at, updated_at ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO coin_reward_one_time (claimed, id, amount, list_id, type, created_at, updated_at) VALUES (0, 0x0197C60FED057F869BBBB20F4B715604, 120, 0x01972B91280573F79AC0F53B07950363, 'first_purchase', '2025-07-01 12:57:01', '2025-07-01 12:57:01');
41	0.58 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
42	1.36 ms	SELECT 1 AS sclr_0 FROM user_favorites u0_ WHERE u0_.user_id = ? AND u0_.favorite_user_id = ? LIMIT 1 Parameters: [`8065 8065`] View formatted query View runnable query Explain query SELECT 1 AS sclr_0 FROM user_favorites u0_ WHERE u0_.user_id = ? AND u0_.favorite_user_id = ? LIMIT 1 SELECT 1 AS sclr_0 FROM user_favorites u0_ WHERE u0_.user_id = 8065 AND u0_.favorite_user_id = 8065 LIMIT 1;
43	0.70 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
44	1.63 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.coins AS coins_3, t0.expire_at AS expire_at_4, t0.started_at AS started_at_5, t0.free AS free_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.user_id AS user_id_9 FROM user_coin_balance t0 WHERE t0.user_id = ? Parameters: [`8065`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.coins AS coins_3, t0.expire_at AS expire_at_4, t0.started_at AS started_at_5, t0.free AS free_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.user_id AS user_id_9 FROM user_coin_balance t0 WHERE t0.user_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.coins AS coins_3, t0.expire_at AS expire_at_4, t0.started_at AS started_at_5, t0.free AS free_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.user_id AS user_id_9 FROM user_coin_balance t0 WHERE t0.user_id = 8065;
45	1.22 ms	SAVEPOINT DOCTRINE_2 Parameters: [] View formatted query View runnable query Explain query SAVEPOINT DOCTRINE_2 SAVEPOINT DOCTRINE_2;
46	8.39 ms	INSERT INTO user_balance_history (transaction_type, amount, old_amount, new_amount, is_free, context, description, created_at, updated_at, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`2 3000 93600 96600 0 null "{"paymentTransactionId":128676,"message":"Subscription renew coins bundle[75ed8678-0a9e-4646-ba18-b184f7b088a9] subscription[3863]","action":"recurring_subscription"}" "2025-07-01 12:57:02" "2025-07-01 12:57:02" 8065`] View formatted query View runnable query Explain query INSERT INTO user_balance_history ( transaction_type, amount, old_amount, new_amount, is_free, context, description, created_at, updated_at, user_id ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO user_balance_history (transaction_type, amount, old_amount, new_amount, is_free, context, description, created_at, updated_at, user_id) VALUES (2, 3000, 93600, 96600, 0, NULL, '{\"paymentTransactionId\":128676,\"message\":\"Subscription renew coins bundle[75ed8678-0a9e-4646-ba18-b184f7b088a9] subscription[3863]\",\"action\":\"recurring_subscription\"}', '2025-07-01 12:57:02', '2025-07-01 12:57:02', 8065);
47	7.82 ms	UPDATE user_coin_balance SET coins = ?, updated_at = ? WHERE id = ? Parameters: [`96600 "2025-07-01 12:57:02" 21019`] View formatted query View runnable query Explain query UPDATE user_coin_balance SET coins = ?, updated_at = ? WHERE id = ? UPDATE user_coin_balance SET coins = 96600, updated_at = '2025-07-01 12:57:02' WHERE id = 21019;
48	3.65 ms	RELEASE SAVEPOINT DOCTRINE_2 Parameters: [] View formatted query View runnable query Explain query RELEASE SAVEPOINT DOCTRINE_2 RELEASE SAVEPOINT DOCTRINE_2;
49	3.85 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
50	4.29 ms	SELECT 1 AS sclr_0 FROM user_favorites u0_ WHERE u0_.user_id = ? AND u0_.favorite_user_id = ? LIMIT 1 Parameters: [`8065 8065`] View formatted query View runnable query Explain query SELECT 1 AS sclr_0 FROM user_favorites u0_ WHERE u0_.user_id = ? AND u0_.favorite_user_id = ? LIMIT 1 SELECT 1 AS sclr_0 FROM user_favorites u0_ WHERE u0_.user_id = 8065 AND u0_.favorite_user_id = 8065 LIMIT 1;
51	0.97 ms	SELECT i0_.ip_number AS ip_number_0, i0_.ip AS ip_1, i0_.country_code AS country_code_2, i0_.city_name AS city_name_3, i0_.country_name AS country_name_4, i0_.region_name AS region_name_5, i0_.region_short_name AS region_short_name_6, i0_.timezone AS timezone_7, i0_.zipcode AS zipcode_8, i0_.latitude AS latitude_9, i0_.longitude AS longitude_10, i0_.is_proxy AS is_proxy_11, i0_.proxy_type AS proxy_type_12, i0_.risk_score AS risk_score_13 FROM ip_geo i0_ INNER JOIN ip_geo_user_last i1_ ON (i1_.ip_geo_id = i0_.ip_number) WHERE i1_.user_id = ? LIMIT 1 Parameters: [`8065`] View formatted query View runnable query Explain query SELECT i0_.ip_number AS ip_number_0, i0_.ip AS ip_1, i0_.country_code AS country_code_2, i0_.city_name AS city_name_3, i0_.country_name AS country_name_4, i0_.region_name AS region_name_5, i0_.region_short_name AS region_short_name_6, i0_.timezone AS timezone_7, i0_.zipcode AS zipcode_8, i0_.latitude AS latitude_9, i0_.longitude AS longitude_10, i0_.is_proxy AS is_proxy_11, i0_.proxy_type AS proxy_type_12, i0_.risk_score AS risk_score_13 FROM ip_geo i0_ INNER JOIN ip_geo_user_last i1_ ON (i1_.ip_geo_id = i0_.ip_number) WHERE i1_.user_id = ? LIMIT 1 SELECT i0_.ip_number AS ip_number_0, i0_.ip AS ip_1, i0_.country_code AS country_code_2, i0_.city_name AS city_name_3, i0_.country_name AS country_name_4, i0_.region_name AS region_name_5, i0_.region_short_name AS region_short_name_6, i0_.timezone AS timezone_7, i0_.zipcode AS zipcode_8, i0_.latitude AS latitude_9, i0_.longitude AS longitude_10, i0_.is_proxy AS is_proxy_11, i0_.proxy_type AS proxy_type_12, i0_.risk_score AS risk_score_13 FROM ip_geo i0_ INNER JOIN ip_geo_user_last i1_ ON (i1_.ip_geo_id = i0_.ip_number) WHERE i1_.user_id = 8065 LIMIT 1;
52	0.98 ms	DELETE FROM email_user_auth_token WHERE user_id = ? AND expired_at <= ? Parameters: [`8065 "2025-07-01 12:57:02"`] View formatted query View runnable query Explain query DELETE FROM email_user_auth_token WHERE user_id = ? AND expired_at <= ? DELETE FROM email_user_auth_token WHERE user_id = 8065 AND expired_at <= '2025-07-01 12:57:02';
53	1.08 ms	SELECT e0_.token AS token_0, e0_.expired_at AS expired_at_1, e0_.created_at AS created_at_2, e0_.updated_at AS updated_at_3, e0_.user_id AS user_id_4 FROM email_user_auth_token e0_ WHERE e0_.user_id = ? LIMIT 1 Parameters: [`8065`] View formatted query View runnable query Explain query SELECT e0_.token AS token_0, e0_.expired_at AS expired_at_1, e0_.created_at AS created_at_2, e0_.updated_at AS updated_at_3, e0_.user_id AS user_id_4 FROM email_user_auth_token e0_ WHERE e0_.user_id = ? LIMIT 1 SELECT e0_.token AS token_0, e0_.expired_at AS expired_at_1, e0_.created_at AS created_at_2, e0_.updated_at AS updated_at_3, e0_.user_id AS user_id_4 FROM email_user_auth_token e0_ WHERE e0_.user_id = 8065 LIMIT 1;
54	1.38 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
55	6.33 ms	INSERT INTO email_user_auth_token (token, expired_at, created_at, updated_at, user_id) VALUES (?, ?, ?, ?, ?) Parameters: [`"553c918a524d7df57b841582a50c848a47592ae7" "2025-10-01 12:57:02" "2025-07-01 12:57:02" "2025-07-01 12:57:02" 8065`] View formatted query View runnable query Explain query INSERT INTO email_user_auth_token ( token, expired_at, created_at, updated_at, user_id ) VALUES (?, ?, ?, ?, ?) INSERT INTO email_user_auth_token (token, expired_at, created_at, updated_at, user_id) VALUES ('553c918a524d7df57b841582a50c848a47592ae7', '2025-10-01 12:57:02', '2025-07-01 12:57:02', '2025-07-01 12:57:02', 8065);
56	3.63 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
57	3.66 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.gender AS gender_3, t0.birth_date AS birth_date_4, t0.email AS email_5, t0.workspace AS workspace_6, t0.is_confirmed AS is_confirmed_7, t0.is_subscribed AS is_subscribed_8, t0.locale AS locale_9, t0.platform AS platform_10, t0.country AS country_11, t0.in_european_union AS in_european_union_12, t0.timezone AS timezone_13, t0.last_online_ts AS last_online_ts_14, t0.partner_id AS partner_id_15, t0.deleted_reason AS deleted_reason_16, t0.deleted_at AS deleted_at_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.user_id AS user_id_20 FROM email_customer t0 WHERE t0.user_id = ? LIMIT 1 Parameters: [`8065`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.gender AS gender_3, t0.birth_date AS birth_date_4, t0.email AS email_5, t0.workspace AS workspace_6, t0.is_confirmed AS is_confirmed_7, t0.is_subscribed AS is_subscribed_8, t0.locale AS locale_9, t0.platform AS platform_10, t0.country AS country_11, t0.in_european_union AS in_european_union_12, t0.timezone AS timezone_13, t0.last_online_ts AS last_online_ts_14, t0.partner_id AS partner_id_15, t0.deleted_reason AS deleted_reason_16, t0.deleted_at AS deleted_at_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.user_id AS user_id_20 FROM email_customer t0 WHERE t0.user_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.gender AS gender_3, t0.birth_date AS birth_date_4, t0.email AS email_5, t0.workspace AS workspace_6, t0.is_confirmed AS is_confirmed_7, t0.is_subscribed AS is_subscribed_8, t0.locale AS locale_9, t0.platform AS platform_10, t0.country AS country_11, t0.in_european_union AS in_european_union_12, t0.timezone AS timezone_13, t0.last_online_ts AS last_online_ts_14, t0.partner_id AS partner_id_15, t0.deleted_reason AS deleted_reason_16, t0.deleted_at AS deleted_at_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.user_id AS user_id_20 FROM email_customer t0 WHERE t0.user_id = 8065 LIMIT 1;
58	1.31 ms	SELECT t0.id AS id_1, t0.account_customer_id AS account_customer_id_2, t0.gclid AS gclid_3, t0.wbraid AS wbraid_4, t0.gbraid AS gbraid_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.user_id AS user_id_8 FROM google_conversion_user_identifier t0 WHERE t0.user_id = ? LIMIT 1 Parameters: [`8065`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.account_customer_id AS account_customer_id_2, t0.gclid AS gclid_3, t0.wbraid AS wbraid_4, t0.gbraid AS gbraid_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.user_id AS user_id_8 FROM google_conversion_user_identifier t0 WHERE t0.user_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.account_customer_id AS account_customer_id_2, t0.gclid AS gclid_3, t0.wbraid AS wbraid_4, t0.gbraid AS gbraid_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.user_id AS user_id_8 FROM google_conversion_user_identifier t0 WHERE t0.user_id = 8065 LIMIT 1;

customer connection

#▲	Time	Info
1	1.60 ms	SELECT c0_.id AS id_0, c0_.account_id AS account_id_1, c0_.source AS source_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, c0_.customer_id AS customer_id_5 FROM customer_account_binding c0_ WHERE c0_.account_id = ? AND c0_.source = ? Parameters: [`8065 "mili"`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.account_id AS account_id_1, c0_.source AS source_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, c0_.customer_id AS customer_id_5 FROM customer_account_binding c0_ WHERE c0_.account_id = ? AND c0_.source = ? SELECT c0_.id AS id_0, c0_.account_id AS account_id_1, c0_.source AS source_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, c0_.customer_id AS customer_id_5 FROM customer_account_binding c0_ WHERE c0_.account_id = 8065 AND c0_.source = 'mili';
2	0.96 ms	SELECT t0.id AS id_1, t0.roles AS roles_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM customer t0 WHERE t0.id = ? Parameters: [`b"\x01—+‘(\x05s÷šÀõ;\x07•\x03c"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.roles AS roles_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM customer t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.roles AS roles_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM customer t0 WHERE t0.id = 0x01972B91280573F79AC0F53B07950363;
3	1.06 ms	SELECT c0_.id AS id_0, c0_.account_id AS account_id_1, c0_.source AS source_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, c0_.customer_id AS customer_id_5 FROM customer_account_binding c0_ WHERE c0_.account_id = ? AND c0_.source = ? Parameters: [`8065 "mili"`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.account_id AS account_id_1, c0_.source AS source_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, c0_.customer_id AS customer_id_5 FROM customer_account_binding c0_ WHERE c0_.account_id = ? AND c0_.source = ? SELECT c0_.id AS id_0, c0_.account_id AS account_id_1, c0_.source AS source_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, c0_.customer_id AS customer_id_5 FROM customer_account_binding c0_ WHERE c0_.account_id = 8065 AND c0_.source = 'mili';
4	1.42 ms	SELECT c0_.id AS id_0, c0_.account_id AS account_id_1, c0_.source AS source_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, c0_.customer_id AS customer_id_5 FROM customer_account_binding c0_ WHERE c0_.account_id = ? AND c0_.source = ? Parameters: [`8065 "mili"`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.account_id AS account_id_1, c0_.source AS source_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, c0_.customer_id AS customer_id_5 FROM customer_account_binding c0_ WHERE c0_.account_id = ? AND c0_.source = ? SELECT c0_.id AS id_0, c0_.account_id AS account_id_1, c0_.source AS source_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, c0_.customer_id AS customer_id_5 FROM customer_account_binding c0_ WHERE c0_.account_id = 8065 AND c0_.source = 'mili';

thread_6 connection

#▲	Time	Info
1	2.14 ms	SELECT t0.owner_id AS owner_id_1, t0.user_id AS user_id_2, t0.ts AS ts_3, t0.`read` AS read_4, t0.read_time AS read_time_5, t0.messages AS messages_6, t0.last_message AS last_message_7, t0.last_message_id AS last_message_id_8, t0.thread_type AS thread_type_9, t0.last_user_id AS last_user_id_10, t0.is_deleted AS is_deleted_11, t0.deep AS deep_12, t0.counts AS counts_13, t0.is_paid AS is_paid_14, t0.version AS version_15, t0.context AS context_16, t0.vip AS vip_17, t0.favorite AS favorite_18, t0.is_archived AS is_archived_19, t0.is_muted AS is_muted_20 FROM threads t0 WHERE t0.owner_id = ? AND t0.user_id = ? Parameters: [`8065 8065`] View formatted query View runnable query Explain query SELECT t0.owner_id AS owner_id_1, t0.user_id AS user_id_2, t0.ts AS ts_3, t0.`read` AS read_4, t0.read_time AS read_time_5, t0.messages AS messages_6, t0.last_message AS last_message_7, t0.last_message_id AS last_message_id_8, t0.thread_type AS thread_type_9, t0.last_user_id AS last_user_id_10, t0.is_deleted AS is_deleted_11, t0.deep AS deep_12, t0.counts AS counts_13, t0.is_paid AS is_paid_14, t0.version AS version_15, t0.context AS context_16, t0.vip AS vip_17, t0.favorite AS favorite_18, t0.is_archived AS is_archived_19, t0.is_muted AS is_muted_20 FROM threads t0 WHERE t0.owner_id = ? AND t0.user_id = ? SELECT t0.owner_id AS owner_id_1, t0.user_id AS user_id_2, t0.ts AS ts_3, t0.`read` AS read_4, t0.read_time AS read_time_5, t0.messages AS messages_6, t0.last_message AS last_message_7, t0.last_message_id AS last_message_id_8, t0.thread_type AS thread_type_9, t0.last_user_id AS last_user_id_10, t0.is_deleted AS is_deleted_11, t0.deep AS deep_12, t0.counts AS counts_13, t0.is_paid AS is_paid_14, t0.version AS version_15, t0.context AS context_16, t0.vip AS vip_17, t0.favorite AS favorite_18, t0.is_archived AS is_archived_19, t0.is_muted AS is_muted_20 FROM threads t0 WHERE t0.owner_id = 8065 AND t0.user_id = 8065;
2	3.28 ms	SELECT t0.owner_id AS owner_id_1, t0.user_id AS user_id_2, t0.ts AS ts_3, t0.`read` AS read_4, t0.read_time AS read_time_5, t0.messages AS messages_6, t0.last_message AS last_message_7, t0.last_message_id AS last_message_id_8, t0.thread_type AS thread_type_9, t0.last_user_id AS last_user_id_10, t0.is_deleted AS is_deleted_11, t0.deep AS deep_12, t0.counts AS counts_13, t0.is_paid AS is_paid_14, t0.version AS version_15, t0.context AS context_16, t0.vip AS vip_17, t0.favorite AS favorite_18, t0.is_archived AS is_archived_19, t0.is_muted AS is_muted_20 FROM threads t0 WHERE t0.owner_id = ? AND t0.user_id = ? Parameters: [`8065 8065`] View formatted query View runnable query Explain query SELECT t0.owner_id AS owner_id_1, t0.user_id AS user_id_2, t0.ts AS ts_3, t0.`read` AS read_4, t0.read_time AS read_time_5, t0.messages AS messages_6, t0.last_message AS last_message_7, t0.last_message_id AS last_message_id_8, t0.thread_type AS thread_type_9, t0.last_user_id AS last_user_id_10, t0.is_deleted AS is_deleted_11, t0.deep AS deep_12, t0.counts AS counts_13, t0.is_paid AS is_paid_14, t0.version AS version_15, t0.context AS context_16, t0.vip AS vip_17, t0.favorite AS favorite_18, t0.is_archived AS is_archived_19, t0.is_muted AS is_muted_20 FROM threads t0 WHERE t0.owner_id = ? AND t0.user_id = ? SELECT t0.owner_id AS owner_id_1, t0.user_id AS user_id_2, t0.ts AS ts_3, t0.`read` AS read_4, t0.read_time AS read_time_5, t0.messages AS messages_6, t0.last_message AS last_message_7, t0.last_message_id AS last_message_id_8, t0.thread_type AS thread_type_9, t0.last_user_id AS last_user_id_10, t0.is_deleted AS is_deleted_11, t0.deep AS deep_12, t0.counts AS counts_13, t0.is_paid AS is_paid_14, t0.version AS version_15, t0.context AS context_16, t0.vip AS vip_17, t0.favorite AS favorite_18, t0.is_archived AS is_archived_19, t0.is_muted AS is_muted_20 FROM threads t0 WHERE t0.owner_id = 8065 AND t0.user_id = 8065;

#▲

Time

Info

2.14 ms

SELECT t0.owner_id AS owner_id_1, t0.user_id AS user_id_2, t0.ts AS ts_3, t0.`read` AS read_4, t0.read_time AS read_time_5, t0.messages AS messages_6, t0.last_message AS last_message_7, t0.last_message_id AS last_message_id_8, t0.thread_type AS thread_type_9, t0.last_user_id AS last_user_id_10, t0.is_deleted AS is_deleted_11, t0.deep AS deep_12, t0.counts AS counts_13, t0.is_paid AS is_paid_14, t0.version AS version_15, t0.context AS context_16, t0.vip AS vip_17, t0.favorite AS favorite_18, t0.is_archived AS is_archived_19, t0.is_muted AS is_muted_20 FROM threads t0 WHERE t0.owner_id = ? AND t0.user_id = ?

Parameters:

View formatted query View runnable query Explain query

SELECT
  t0.owner_id AS owner_id_1,
  t0.user_id AS user_id_2,
  t0.ts AS ts_3,
  t0.`read` AS read_4,
  t0.read_time AS read_time_5,
  t0.messages AS messages_6,
  t0.last_message AS last_message_7,
  t0.last_message_id AS last_message_id_8,
  t0.thread_type AS thread_type_9,
  t0.last_user_id AS last_user_id_10,
  t0.is_deleted AS is_deleted_11,
  t0.deep AS deep_12,
  t0.counts AS counts_13,
  t0.is_paid AS is_paid_14,
  t0.version AS version_15,
  t0.context AS context_16,
  t0.vip AS vip_17,
  t0.favorite AS favorite_18,
  t0.is_archived AS is_archived_19,
  t0.is_muted AS is_muted_20
FROM
  threads t0
WHERE
  t0.owner_id = ?
  AND t0.user_id = ?

SELECT t0.owner_id AS owner_id_1, t0.user_id AS user_id_2, t0.ts AS ts_3, t0.`read` AS read_4, t0.read_time AS read_time_5, t0.messages AS messages_6, t0.last_message AS last_message_7, t0.last_message_id AS last_message_id_8, t0.thread_type AS thread_type_9, t0.last_user_id AS last_user_id_10, t0.is_deleted AS is_deleted_11, t0.deep AS deep_12, t0.counts AS counts_13, t0.is_paid AS is_paid_14, t0.version AS version_15, t0.context AS context_16, t0.vip AS vip_17, t0.favorite AS favorite_18, t0.is_archived AS is_archived_19, t0.is_muted AS is_muted_20 FROM threads t0 WHERE t0.owner_id = 8065 AND t0.user_id = 8065;

3.28 ms

SELECT t0.owner_id AS owner_id_1, t0.user_id AS user_id_2, t0.ts AS ts_3, t0.`read` AS read_4, t0.read_time AS read_time_5, t0.messages AS messages_6, t0.last_message AS last_message_7, t0.last_message_id AS last_message_id_8, t0.thread_type AS thread_type_9, t0.last_user_id AS last_user_id_10, t0.is_deleted AS is_deleted_11, t0.deep AS deep_12, t0.counts AS counts_13, t0.is_paid AS is_paid_14, t0.version AS version_15, t0.context AS context_16, t0.vip AS vip_17, t0.favorite AS favorite_18, t0.is_archived AS is_archived_19, t0.is_muted AS is_muted_20 FROM threads t0 WHERE t0.owner_id = ? AND t0.user_id = ?

Parameters:

View formatted query View runnable query Explain query

SELECT
  t0.owner_id AS owner_id_1,
  t0.user_id AS user_id_2,
  t0.ts AS ts_3,
  t0.`read` AS read_4,
  t0.read_time AS read_time_5,
  t0.messages AS messages_6,
  t0.last_message AS last_message_7,
  t0.last_message_id AS last_message_id_8,
  t0.thread_type AS thread_type_9,
  t0.last_user_id AS last_user_id_10,
  t0.is_deleted AS is_deleted_11,
  t0.deep AS deep_12,
  t0.counts AS counts_13,
  t0.is_paid AS is_paid_14,
  t0.version AS version_15,
  t0.context AS context_16,
  t0.vip AS vip_17,
  t0.favorite AS favorite_18,
  t0.is_archived AS is_archived_19,
  t0.is_muted AS is_muted_20
FROM
  threads t0
WHERE
  t0.owner_id = ?
  AND t0.user_id = ?

SELECT t0.owner_id AS owner_id_1, t0.user_id AS user_id_2, t0.ts AS ts_3, t0.`read` AS read_4, t0.read_time AS read_time_5, t0.messages AS messages_6, t0.last_message AS last_message_7, t0.last_message_id AS last_message_id_8, t0.thread_type AS thread_type_9, t0.last_user_id AS last_user_id_10, t0.is_deleted AS is_deleted_11, t0.deep AS deep_12, t0.counts AS counts_13, t0.is_paid AS is_paid_14, t0.version AS version_15, t0.context AS context_16, t0.vip AS vip_17, t0.favorite AS favorite_18, t0.is_archived AS is_archived_19, t0.is_muted AS is_muted_20 FROM threads t0 WHERE t0.owner_id = 8065 AND t0.user_id = 8065;

Database Connections

Name	Service
default	doctrine.dbal.default_connection
log	doctrine.dbal.log_connection
thread	doctrine.dbal.thread_connection
thread_1	doctrine.dbal.thread_1_connection
thread_2	doctrine.dbal.thread_2_connection
thread_3	doctrine.dbal.thread_3_connection
thread_4	doctrine.dbal.thread_4_connection
thread_5	doctrine.dbal.thread_5_connection
thread_6	doctrine.dbal.thread_6_connection
thread_7	doctrine.dbal.thread_7_connection
thread_8	doctrine.dbal.thread_8_connection
thread_9	doctrine.dbal.thread_9_connection
thread_10	doctrine.dbal.thread_10_connection
customer	doctrine.dbal.customer_connection
media	doctrine.dbal.media_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
log	doctrine.orm.log_entity_manager
thread	doctrine.orm.thread_entity_manager
thread_1	doctrine.orm.thread_1_entity_manager
thread_2	doctrine.orm.thread_2_entity_manager
thread_3	doctrine.orm.thread_3_entity_manager
thread_4	doctrine.orm.thread_4_entity_manager
thread_5	doctrine.orm.thread_5_entity_manager
thread_6	doctrine.orm.thread_6_entity_manager
thread_7	doctrine.orm.thread_7_entity_manager
thread_8	doctrine.orm.thread_8_entity_manager
thread_9	doctrine.orm.thread_9_entity_manager
thread_10	doctrine.orm.thread_10_entity_manager
customer	doctrine.orm.customer_entity_manager
media	doctrine.orm.media_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Main\Payment\SolidGate\SolidGateSubscriptionInvoice	16
App\Entity\Main\Payment\PaymentTransaction	16
App\Entity\Main\Balance\UserCoinBalance	2
App\Entity\Main\Geo\IpGeo	1
App\Entity\Main\Payment\SolidGate\SolidGateSubscription	1
App\Entity\Main\User\User	1
App\Entity\Main\PayBundle	1
App\Entity\Main\Payment\PaymentSubscription	1
App\Domain\CoinReward\Infrastructure\Doctrine\OnetimeReward\Mapping\OneTimeRewardEntity	1
App\Entity\Main\Balance\UserBalanceHistory	1
App\Entity\Main\User\Auth\EmailUserAuthToken	1

log entity manager

Class	Amount of managed objects

thread entity manager

Class	Amount of managed objects

thread_1 entity manager

Class	Amount of managed objects

thread_2 entity manager

Class	Amount of managed objects

thread_3 entity manager

Class	Amount of managed objects

thread_4 entity manager

Class	Amount of managed objects

thread_5 entity manager

Class	Amount of managed objects

thread_6 entity manager

Class	Amount of managed objects

thread_7 entity manager

Class	Amount of managed objects

thread_8 entity manager

Class	Amount of managed objects

thread_9 entity manager

Class	Amount of managed objects

thread_10 entity manager

Class	Amount of managed objects

customer entity manager

Class	Amount of managed objects
App\Domain\Customer\Infrastructure\Doctrine\Mapping\AccountBinding	1
App\Domain\Customer\Infrastructure\Doctrine\Mapping\Customer	1

media entity manager

Class	Amount of managed objects

Entities Mapping

default entity manager

Class	Mapping errors
App\Entity\Main\Geo\IpGeo	No errors.
App\Entity\Main\Payment\SolidGate\SolidGateSubscription	No errors.
App\Entity\Main\User\User	No errors.
App\Entity\Main\PayBundle	No errors.
App\Entity\Main\Payment\SolidGate\SolidGateSubscriptionInvoice	No errors.
App\Entity\Main\Payment\SolidGate\SolidGateOrder	No errors.
App\Entity\Main\Payment\SolidGate\SolidGateCard	No errors.
App\Entity\Main\Payment\PaymentSubscription	No errors.
App\Entity\Main\Payment\PaymentTransaction	No errors.
App\Entity\Main\Payment\PaymentPurchase	No errors.
App\Entity\Main\User\UserPhoto	No errors.
App\Entity\Main\Streamer\Streamer	No errors.
App\Entity\Main\User\Auth\OAuthAccessToken	No errors.
App\Entity\Main\User\UserInterest	No errors.
App\Entity\Main\User\Auth\UserAuthKey	No errors.
App\Entity\Main\User\UserComplaint	No errors.
App\Entity\Main\User\UserBlock	No errors.
App\Entity\Main\Device\AppInstall	No errors.
App\Entity\Main\Experiment\UserExperiment	No errors.
App\Entity\Main\Balance\UserCoinBalance	No errors.
App\Domain\CoinReward\Infrastructure\Doctrine\OnetimeReward\Mapping\OneTimeRewardEntity	No errors.
App\Entity\Main\Balance\UserBalanceHistory	No errors.
App\Entity\Main\User\Auth\EmailUserAuthToken	No errors.
App\Entity\Main\Email\EmailCustomer	No errors.
App\Entity\Main\Marketing\GoogleConversionUserIdentifier	No errors.

log entity manager

No loaded entities.

thread entity manager

No loaded entities.

thread_1 entity manager

No loaded entities.

thread_2 entity manager

No loaded entities.

thread_3 entity manager

No loaded entities.

thread_4 entity manager

No loaded entities.

thread_5 entity manager

No loaded entities.

thread_6 entity manager

Class	Mapping errors
App\Entity\Thread\Thread	No errors.

thread_7 entity manager

No loaded entities.

thread_8 entity manager

No loaded entities.

thread_9 entity manager

No loaded entities.

thread_10 entity manager

No loaded entities.

customer entity manager

Class	Mapping errors
App\Domain\Customer\Infrastructure\Doctrine\Mapping\AccountBinding	No errors.
App\Domain\Customer\Infrastructure\Doctrine\Mapping\Customer	No errors.

media entity manager

No loaded entities.

Symfony Profiler

POST https://app.vchat.dev/payment/solid_gate/subscription_callback

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

customer connection

thread_6 connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

log entity manager

thread entity manager

thread_1 entity manager

thread_2 entity manager

thread_3 entity manager

thread_4 entity manager

thread_5 entity manager

thread_6 entity manager

thread_7 entity manager

thread_8 entity manager

thread_9 entity manager

thread_10 entity manager

customer entity manager

media entity manager

Entities Mapping

default entity manager

log entity manager

thread entity manager

thread_1 entity manager

thread_2 entity manager

thread_3 entity manager

thread_4 entity manager

thread_5 entity manager

thread_6 entity manager

thread_7 entity manager

thread_8 entity manager

thread_9 entity manager

thread_10 entity manager

customer entity manager

media entity manager