Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

10.52 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
5.77 ms (54.85%)	1	SELECT t0.id AS id_1, t0.role AS role_2, t0.telegram_id AS telegram_id_3, t0.nickname AS nickname_4, t0.started_at AS started_at_5, t0.expired_at AS expired_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.promo_period_has_been_activated AS promo_period_has_been_activated_9, t0.comment AS comment_10, t0.traffic AS traffic_11, t0.uuid AS uuid_12, t0.enable_referral AS enable_referral_13, t0.language AS language_14, t0.is_available_ss AS is_available_ss_15, t0.is_available_vless AS is_available_vless_16, t0.is_available_wl AS is_available_wl_17, t0.is_blocked_bot AS is_blocked_bot_18, t0.sub_id AS sub_id_19, t0.use_vless_subscribe AS use_vless_subscribe_20, t0.use_vless_json_subscribe AS use_vless_json_subscribe_21, t0.referral_program_started_at AS referral_program_started_at_22, t0.status AS status_23, t0.is_allowed_recurrent AS is_allowed_recurrent_24, t0.is_send_message_expired AS is_send_message_expired_25, t0.recurring_price AS recurring_price_26, t0.public_user_id AS public_user_id_27, t0.is_allow_referral_days AS is_allow_referral_days_28, t0.is_allow_referral_money AS is_allow_referral_money_29, t0.white_list_expired_at AS white_list_expired_at_30, t0.available_white_list_traffic AS available_white_list_traffic_31, t0.used_white_list_traffic AS used_white_list_traffic_32, t0.fingerprint AS fingerprint_33, t0.is_send_message_white_list_expired AS is_send_message_white_list_expired_34, t0.promotion_id AS promotion_id_35, t0.referral_link_id AS referral_link_id_36, t37.id AS id_38, t37.created_at AS created_at_39, t37.updated_at AS updated_at_40, t37.total_chat_tokens AS total_chat_tokens_41, t37.cost_all_time AS cost_all_time_42, t37.total_count_requests AS total_count_requests_43, t37.user_id AS user_id_44 FROM "users" t0 LEFT JOIN "gpt_usage_logs" t37 ON t37.user_id = t0.id WHERE t0.sub_id = ? LIMIT 1 Parameters: [`"02303f5c-83ae-432d-8fd4-7a2c0feb7076"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.role AS role_2, t0.telegram_id AS telegram_id_3, t0.nickname AS nickname_4, t0.started_at AS started_at_5, t0.expired_at AS expired_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.promo_period_has_been_activated AS promo_period_has_been_activated_9, t0.comment AS comment_10, t0.traffic AS traffic_11, t0.uuid AS uuid_12, t0.enable_referral AS enable_referral_13, t0.language AS language_14, t0.is_available_ss AS is_available_ss_15, t0.is_available_vless AS is_available_vless_16, t0.is_available_wl AS is_available_wl_17, t0.is_blocked_bot AS is_blocked_bot_18, t0.sub_id AS sub_id_19, t0.use_vless_subscribe AS use_vless_subscribe_20, t0.use_vless_json_subscribe AS use_vless_json_subscribe_21, t0.referral_program_started_at AS referral_program_started_at_22, t0.status AS status_23, t0.is_allowed_recurrent AS is_allowed_recurrent_24, t0.is_send_message_expired AS is_send_message_expired_25, t0.recurring_price AS recurring_price_26, t0.public_user_id AS public_user_id_27, t0.is_allow_referral_days AS is_allow_referral_days_28, t0.is_allow_referral_money AS is_allow_referral_money_29, t0.white_list_expired_at AS white_list_expired_at_30, t0.available_white_list_traffic AS available_white_list_traffic_31, t0.used_white_list_traffic AS used_white_list_traffic_32, t0.fingerprint AS fingerprint_33, t0.is_send_message_white_list_expired AS is_send_message_white_list_expired_34, t0.promotion_id AS promotion_id_35, t0.referral_link_id AS referral_link_id_36, t37.id AS id_38, t37.created_at AS created_at_39, t37.updated_at AS updated_at_40, t37.total_chat_tokens AS total_chat_tokens_41, t37.cost_all_time AS cost_all_time_42, t37.total_count_requests AS total_count_requests_43, t37.user_id AS user_id_44 FROM "users" t0 LEFT JOIN "gpt_usage_logs" t37 ON t37.user_id = t0.id WHERE t0.sub_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.role AS role_2, t0.telegram_id AS telegram_id_3, t0.nickname AS nickname_4, t0.started_at AS started_at_5, t0.expired_at AS expired_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.promo_period_has_been_activated AS promo_period_has_been_activated_9, t0.comment AS comment_10, t0.traffic AS traffic_11, t0.uuid AS uuid_12, t0.enable_referral AS enable_referral_13, t0.language AS language_14, t0.is_available_ss AS is_available_ss_15, t0.is_available_vless AS is_available_vless_16, t0.is_available_wl AS is_available_wl_17, t0.is_blocked_bot AS is_blocked_bot_18, t0.sub_id AS sub_id_19, t0.use_vless_subscribe AS use_vless_subscribe_20, t0.use_vless_json_subscribe AS use_vless_json_subscribe_21, t0.referral_program_started_at AS referral_program_started_at_22, t0.status AS status_23, t0.is_allowed_recurrent AS is_allowed_recurrent_24, t0.is_send_message_expired AS is_send_message_expired_25, t0.recurring_price AS recurring_price_26, t0.public_user_id AS public_user_id_27, t0.is_allow_referral_days AS is_allow_referral_days_28, t0.is_allow_referral_money AS is_allow_referral_money_29, t0.white_list_expired_at AS white_list_expired_at_30, t0.available_white_list_traffic AS available_white_list_traffic_31, t0.used_white_list_traffic AS used_white_list_traffic_32, t0.fingerprint AS fingerprint_33, t0.is_send_message_white_list_expired AS is_send_message_white_list_expired_34, t0.promotion_id AS promotion_id_35, t0.referral_link_id AS referral_link_id_36, t37.id AS id_38, t37.created_at AS created_at_39, t37.updated_at AS updated_at_40, t37.total_chat_tokens AS total_chat_tokens_41, t37.cost_all_time AS cost_all_time_42, t37.total_count_requests AS total_count_requests_43, t37.user_id AS user_id_44 FROM "users" t0 LEFT JOIN "gpt_usage_logs" t37 ON t37.user_id = t0.id WHERE t0.sub_id = '02303f5c-83ae-432d-8fd4-7a2c0feb7076' LIMIT 1;
4.75 ms (45.15%)	1	SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4 FROM "admins" t0 WHERE t0.username = ? LIMIT 1 Parameters: [`"twig"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4 FROM "admins" t0 WHERE t0.username = ? LIMIT 1 SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4 FROM "admins" t0 WHERE t0.username = 'twig' LIMIT 1;

Time▼

Count

Info

5.77 ms
(54.85%)

SELECT t0.id AS id_1, t0.role AS role_2, t0.telegram_id AS telegram_id_3, t0.nickname AS nickname_4, t0.started_at AS started_at_5, t0.expired_at AS expired_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.promo_period_has_been_activated AS promo_period_has_been_activated_9, t0.comment AS comment_10, t0.traffic AS traffic_11, t0.uuid AS uuid_12, t0.enable_referral AS enable_referral_13, t0.language AS language_14, t0.is_available_ss AS is_available_ss_15, t0.is_available_vless AS is_available_vless_16, t0.is_available_wl AS is_available_wl_17, t0.is_blocked_bot AS is_blocked_bot_18, t0.sub_id AS sub_id_19, t0.use_vless_subscribe AS use_vless_subscribe_20, t0.use_vless_json_subscribe AS use_vless_json_subscribe_21, t0.referral_program_started_at AS referral_program_started_at_22, t0.status AS status_23, t0.is_allowed_recurrent AS is_allowed_recurrent_24, t0.is_send_message_expired AS is_send_message_expired_25, t0.recurring_price AS recurring_price_26, t0.public_user_id AS public_user_id_27, t0.is_allow_referral_days AS is_allow_referral_days_28, t0.is_allow_referral_money AS is_allow_referral_money_29, t0.white_list_expired_at AS white_list_expired_at_30, t0.available_white_list_traffic AS available_white_list_traffic_31, t0.used_white_list_traffic AS used_white_list_traffic_32, t0.fingerprint AS fingerprint_33, t0.is_send_message_white_list_expired AS is_send_message_white_list_expired_34, t0.promotion_id AS promotion_id_35, t0.referral_link_id AS referral_link_id_36, t37.id AS id_38, t37.created_at AS created_at_39, t37.updated_at AS updated_at_40, t37.total_chat_tokens AS total_chat_tokens_41, t37.cost_all_time AS cost_all_time_42, t37.total_count_requests AS total_count_requests_43, t37.user_id AS user_id_44 FROM "users" t0 LEFT JOIN "gpt_usage_logs" t37 ON t37.user_id = t0.id WHERE t0.sub_id = ? LIMIT 1

Parameters:

[
  "02303f5c-83ae-432d-8fd4-7a2c0feb7076"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.role AS role_2,
  t0.telegram_id AS telegram_id_3,
  t0.nickname AS nickname_4,
  t0.started_at AS started_at_5,
  t0.expired_at AS expired_at_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.promo_period_has_been_activated AS promo_period_has_been_activated_9,
  t0.comment AS comment_10,
  t0.traffic AS traffic_11,
  t0.uuid AS uuid_12,
  t0.enable_referral AS enable_referral_13,
  t0.language AS language_14,
  t0.is_available_ss AS is_available_ss_15,
  t0.is_available_vless AS is_available_vless_16,
  t0.is_available_wl AS is_available_wl_17,
  t0.is_blocked_bot AS is_blocked_bot_18,
  t0.sub_id AS sub_id_19,
  t0.use_vless_subscribe AS use_vless_subscribe_20,
  t0.use_vless_json_subscribe AS use_vless_json_subscribe_21,
  t0.referral_program_started_at AS referral_program_started_at_22,
  t0.status AS status_23,
  t0.is_allowed_recurrent AS is_allowed_recurrent_24,
  t0.is_send_message_expired AS is_send_message_expired_25,
  t0.recurring_price AS recurring_price_26,
  t0.public_user_id AS public_user_id_27,
  t0.is_allow_referral_days AS is_allow_referral_days_28,
  t0.is_allow_referral_money AS is_allow_referral_money_29,
  t0.white_list_expired_at AS white_list_expired_at_30,
  t0.available_white_list_traffic AS available_white_list_traffic_31,
  t0.used_white_list_traffic AS used_white_list_traffic_32,
  t0.fingerprint AS fingerprint_33,
  t0.is_send_message_white_list_expired AS is_send_message_white_list_expired_34,
  t0.promotion_id AS promotion_id_35,
  t0.referral_link_id AS referral_link_id_36,
  t37.id AS id_38,
  t37.created_at AS created_at_39,
  t37.updated_at AS updated_at_40,
  t37.total_chat_tokens AS total_chat_tokens_41,
  t37.cost_all_time AS cost_all_time_42,
  t37.total_count_requests AS total_count_requests_43,
  t37.user_id AS user_id_44
FROM
  "users" t0
  LEFT JOIN "gpt_usage_logs" t37 ON t37.user_id = t0.id
WHERE
  t0.sub_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.role AS role_2, t0.telegram_id AS telegram_id_3, t0.nickname AS nickname_4, t0.started_at AS started_at_5, t0.expired_at AS expired_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.promo_period_has_been_activated AS promo_period_has_been_activated_9, t0.comment AS comment_10, t0.traffic AS traffic_11, t0.uuid AS uuid_12, t0.enable_referral AS enable_referral_13, t0.language AS language_14, t0.is_available_ss AS is_available_ss_15, t0.is_available_vless AS is_available_vless_16, t0.is_available_wl AS is_available_wl_17, t0.is_blocked_bot AS is_blocked_bot_18, t0.sub_id AS sub_id_19, t0.use_vless_subscribe AS use_vless_subscribe_20, t0.use_vless_json_subscribe AS use_vless_json_subscribe_21, t0.referral_program_started_at AS referral_program_started_at_22, t0.status AS status_23, t0.is_allowed_recurrent AS is_allowed_recurrent_24, t0.is_send_message_expired AS is_send_message_expired_25, t0.recurring_price AS recurring_price_26, t0.public_user_id AS public_user_id_27, t0.is_allow_referral_days AS is_allow_referral_days_28, t0.is_allow_referral_money AS is_allow_referral_money_29, t0.white_list_expired_at AS white_list_expired_at_30, t0.available_white_list_traffic AS available_white_list_traffic_31, t0.used_white_list_traffic AS used_white_list_traffic_32, t0.fingerprint AS fingerprint_33, t0.is_send_message_white_list_expired AS is_send_message_white_list_expired_34, t0.promotion_id AS promotion_id_35, t0.referral_link_id AS referral_link_id_36, t37.id AS id_38, t37.created_at AS created_at_39, t37.updated_at AS updated_at_40, t37.total_chat_tokens AS total_chat_tokens_41, t37.cost_all_time AS cost_all_time_42, t37.total_count_requests AS total_count_requests_43, t37.user_id AS user_id_44 FROM "users" t0 LEFT JOIN "gpt_usage_logs" t37 ON t37.user_id = t0.id WHERE t0.sub_id = '02303f5c-83ae-432d-8fd4-7a2c0feb7076' LIMIT 1;

4.75 ms
(45.15%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4 FROM "admins" t0 WHERE t0.username = ? LIMIT 1

Parameters:

[
  "twig"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4
FROM
  "admins" t0
WHERE
  t0.username = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4 FROM "admins" t0 WHERE t0.username = 'twig' LIMIT 1;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\Admin	No errors.
App\Entity\User	The mappings App\Entity\User#user_sales and App\Entity\UserSale#user are inconsistent with each other. The mappings App\Entity\User#recurring_payment_methods and App\Entity\RecurringPaymentMethod#user are inconsistent with each other. The mappings App\Entity\User#from_messages and App\Entity\Message#from_user are inconsistent with each other. The mappings App\Entity\User#to_messages and App\Entity\Message#to_user are inconsistent with each other. The mappings App\Entity\User#referral_transactions and App\Entity\ReferralTransaction#user are inconsistent with each other. The mappings App\Entity\User#user_tag_rels and App\Entity\UserTagRel#user are inconsistent with each other.
App\Entity\ReferralLink	No errors.
App\Entity\GptUsageLog	No errors.

Symfony Profiler

POST https://test-admin.clearorbitllc.com/api/device-log

Configuration Settings

Theme