Yii Debugger
1.1.25
PHP 8.0.30
Status 200
Action McpRestController::actionTickets()
Log 91
Time 412 ms
Memory 5.7 MB
DB 48 255 ms
All Latest
GET http://chinchilldev.lufa.com/en/mcpRest/tickets?status=1&ticket_types=IQARefundRequest&ticket_types=Email at 2025-04-21 03:38:46 by 172.19.0.1
Time Duration Query
15:38:46.040 1.9 ms
SHOW FULL COLUMNS FROM `marketing_custom_urls`
15:38:46.042 1.0 ms
SHOW CREATE TABLE `marketing_custom_urls`
15:38:46.044 1.4 ms
SHOW FULL COLUMNS FROM `marketing_campaign_referrals`
15:38:46.045 0.8 ms
SHOW CREATE TABLE `marketing_campaign_referrals`
15:38:46.046 0.9 ms
SELECT `t`.`marketing_custom_url_id` AS `t0_c0`, `t`.`marketing_campaign_referral_id` AS `t0_c1`, `t`.`url` AS `t0_c2`, `t`.`target_url` AS `t0_c3`, `campaign_referral`.`marketing_campaign_referral_id` AS `t1_c0`, `campaign_referral`.`name` AS `t1_c1` FROM `marketing_custom_urls` `t` LEFT OUTER JOIN `marketing_campaign_referrals` `campaign_referral` ON (`campaign_referral`.`marketing_campaign_referral_id`=`t`.`marketing_custom_url_id`) WHERE (`t`.`url`='tickets')
Explain
15:38:46.050 3.0 ms
SHOW FULL COLUMNS FROM `securelufacom`.`users`
15:38:46.053 1.2 ms
SHOW CREATE TABLE `securelufacom`.`users`
15:38:46.057 1.2 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`=618755 LIMIT 1
Explain
15:38:46.060 1.5 ms
SHOW FULL COLUMNS FROM `action_log`
15:38:46.061 0.8 ms
SHOW CREATE TABLE `action_log`
15:38:46.063 0.8 ms
SELECT `data` FROM `user_session` WHERE expire>1745264326 AND id='v5vej3k6coduvt03vr66tlv8mm'
Explain
15:38:46.064 1.4 ms
SHOW FULL COLUMNS FROM `user_agents`
15:38:46.065 0.8 ms
SHOW CREATE TABLE `user_agents`
15:38:46.066 66.1 ms
SELECT * FROM `user_agents` `t` WHERE `t`.`user_agent`='python-httpx/0.28.1' LIMIT 1
Explain
15:38:46.133 2.6 ms
INSERT INTO `action_log` (`staff_id`, `user_id`, `action`, `action_type`, `ip_address`, `agent_id`, `time`, `date`) VALUES (618755, 618755, 'Found user 618755 using auth token: eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c2VyX2lkIjoiNjE4NzU1IiwiaWF0IjoxNzQyNDkxMjkwfQ.-3DpjedDNhWlREGC-f0Fkp4aK07DPED8mBW6uvREyUo', 10, '12.30.39.214', '344428', '15:38:46', '2025-04-21')
15:38:46.136 1.2 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_email`='p.liang@lufa.com' LIMIT 1
Explain
15:38:46.138 1.1 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`='618755' LIMIT 1
Explain
15:38:46.148 3.2 ms
UPDATE `securelufacom`.`users` SET `user_id`=618755, `user_email`='p.liang@lufa.com', `user_pass`='$2a$08$fsGI56Z5vfh314RhKRM7QelHe6tJ.90DCRKSc/SUBc11hPtBp1dwy', `first_name`='Patrick', `last_name`='Liang', `coordinator_display_name`=NULL, `language`='en', `created`='2025-03-14 00:00:00', `status`=1, `last_forgot_password_request`=NULL, `credits`=NULL, `address`='', `zip_code`='', `phone_home`='', `phone_work`='', `updated`='2025-03-14 11:44:16', `last_login_date`='2025-04-21 15:38:46', `warehouse_id`=NULL, `city_name`='', `state_id`=3, `apt`='', `plan_id`=4, `open_alert`=1, `closed_alert`=1, `customer_profile_id`=NULL, `charge_method`='manual', `free_credits`='0', `card_type`=NULL, `exp_month`=NULL, `exp_year`=NULL, `last_contacted_on`=NULL, `next_contact_on`=NULL, `never_call`=0, `coupon_id`=NULL, `notification_type`=2, `supplier_id`=NULL, `social_provider`='Google', `social_identifier`='108571032030637286732', `social_info2`='108571032030637286732', `social_info1`='p.liang@lufa.com', `gender`=NULL, `birthday`=NULL, `facebook_id`=NULL, `facebook_access_token`=NULL, `image_url`=NULL, `vip`=0, `how_did_you_hear`=NULL, `how_did_you_hear_other`=NULL, `pup_coordinator`=0, `signup_source`=0, `description`='', `beta_tester`=0, `payment_gateway`=0, `payment_token`=NULL, `substitution`=1, `activate_deposit`=0, `deposit`=NULL, `prefered_deposit_amount`=0, `card_last4digits`=NULL, `payment_profile_id`='0', `notification_status`=1, `nb_qa_required`=0, `campaign_referral`=NULL, `login_token`=NULL, `seen_popup`=0, `gift_preferences`=1, `display_sold_out_products`=1, `home_delivery_address`='', `home_delivery_apt`=NULL, `home_delivery_zip_code`='', `home_delivery_city_name`='', `home_delivery_state_id`=3, `home_delivery_comment`=NULL, `home_delivery_leave_basket`=NULL, `fraudulent_reasons_id`=NULL, `signed_up_to_weekly_promotions`=0, `cs_pref_communication_language`='', `in_bad_debt_since`=NULL, `address_lat`=NULL, `address_lng`=NULL, `bonus_program`=0, `employee_status`='Active', `employee_personal_email`='patrick@chinchill.ai', `internal_employee_id`=NULL, `employee_photo_url`=NULL, `date_of_birth`=NULL, `employee_lock`=0, `community_representative_group_id`=15, `coordinator_photo_url`=NULL, `coordinator_description`=NULL, `coordinator_availability`=NULL, `max_rows`=NULL, `primary_task_type_id`=0, `company_id`=NULL, `charitable_account`=0, `family_size`=1, `giveback_donation_percent`='0.00', `order_donation`='0.00', `ident_verified`=0, `mask_donor_identity`=0, `numb_children`=0, `snipeit_userid`=NULL, `job_title`='Customer Service Manager', `dg_coordinator_company_id`=NULL, `guest`=0, `badge_color`=NULL, `internal_grouping_code`=NULL, `bonus_program_version`=1, `users_date_of_last_shipped_order`=NULL, `tier_id`=4, `last_updated_pass`='2025-03-14 11:52:50', `reset_password_token`=NULL, `has_access_to_meal_planner`=0 WHERE `securelufacom`.`users`.`user_id`=618755
15:38:46.151 2.1 ms
SHOW FULL COLUMNS FROM `active_record_logs`
15:38:46.154 0.9 ms
SHOW CREATE TABLE `active_record_logs`
15:38:46.155 3.2 ms
INSERT INTO `active_record_logs` (`description`, `action`, `model`, `model_id`, `field`, `old_value`, `new_value`, `created_at`, `user_id`, `parent_model`, `parent_model_id`) VALUES ('User p.liang@lufa.com changed last_login_date for Users[618755].', 'CHANGE', 'Users', '618755', 'last_login_date', '2025-04-21 14:54:02', '2025-04-21 15:38:46', NOW(), 618755, 'Users', '618755')
15:38:46.159 1.7 ms
SHOW FULL COLUMNS FROM `usersLang`
15:38:46.161 0.9 ms
SHOW CREATE TABLE `usersLang`
15:38:46.162 0.8 ms
SELECT * FROM `usersLang` `t` WHERE user_id='618755'
Explain
15:38:46.163 2.4 ms
UPDATE `usersLang` SET `l_id`=609580, `user_id`=618755, `lang_id`='en', `l_description`=NULL, `l_coordinator_description`=NULL, `l_coordinator_availability`=NULL WHERE `usersLang`.`l_id`=609580
15:38:46.166 2.3 ms
DELETE FROM `user_session` WHERE id='v5vej3k6coduvt03vr66tlv8mm'
15:38:46.168 3.0 ms
SELECT `data` FROM `user_session` WHERE expire>1745264326 AND id='09u0hf5c39l7dbl3giahfp85bn'
Explain
15:38:46.171 0.8 ms
SELECT `id` FROM `user_session` WHERE id='09u0hf5c39l7dbl3giahfp85bn'
Explain
15:38:46.172 4.0 ms
INSERT INTO `user_session` (`id`, `data`, `expire`) VALUES ('09u0hf5c39l7dbl3giahfp85bn', '', 1758483526)
15:38:46.176 2.1 ms
SELECT `data` FROM `user_session` WHERE expire>1745264326 AND id='0qj9kialvjskm91j302r6krk5l'
Explain
15:38:46.178 0.8 ms
SELECT * FROM `user_session` WHERE id='09u0hf5c39l7dbl3giahfp85bn'
Explain
15:38:46.179 4.3 ms
UPDATE `user_session` SET `id`='0qj9kialvjskm91j302r6krk5l' WHERE id='09u0hf5c39l7dbl3giahfp85bn'
15:38:46.185 8.9 ms
SELECT * FROM `authassignment` WHERE userid='618755'
Explain
15:38:46.196 1.5 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`=618755 LIMIT 1
Explain
15:38:46.199 6.0 ms
SELECT LCASE(itemname) as itemname, ai.type, ai.name FROM authassignment t1 LEFT JOIN authitem ai ON ai.name = t1.itemname where userid = 618755
Explain
15:38:46.205 12.7 ms
SELECT LCASE(parent) as parent,LCASE(child) as child, ai.name , ai.type FROM authitemchild ac LEFT JOIN authitem ai ON ai.name = ac.child ORDER BY `ai`.`type` DESC
Explain
15:38:46.224 84.2 ms
SELECT * FROM `user_agents` `t` WHERE `t`.`user_agent`='python-httpx/0.28.1' LIMIT 1
Explain
15:38:46.308 2.9 ms
INSERT INTO `action_log` (`staff_id`, `user_id`, `action`, `action_type`, `ip_address`, `agent_id`, `time`, `date`) VALUES (618755, 618755, 'Logged in using login token: [v5vej3k6coduvt03vr66tlv8mm | 0qj9kialvjskm91j302r6krk5l]', 10, '12.30.39.214', '344428', '15:38:46', '2025-04-21')
15:38:46.311 1.4 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`=618755 LIMIT 1
Explain
15:38:46.316 1.4 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`=618755 LIMIT 1
Explain
15:38:46.320 2.2 ms
SHOW FULL COLUMNS FROM `tickets`
15:38:46.322 1.1 ms
SHOW CREATE TABLE `tickets`
15:38:46.323 1.2 ms
SELECT * FROM `tickets` `t` WHERE ((ticket_type='Email') AND (status='1')) AND (agent_id='618755')
Explain
15:38:46.415 1.5 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`='420935' LIMIT 1
Explain
15:38:46.422 1.2 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`='611354' LIMIT 1
Explain
15:38:46.428 1.3 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`='254216' LIMIT 1
Explain
15:38:46.431 2.7 ms
INSERT IGNORE INTO stats_page_requested (url, memory_used, loading_time, ip, user_id, request_body, query_string, cookies) VALUES ('mcpRest/tickets', 4.45, 0.404, '12.30.39.214', '618755', '', '', 's:0:"";');
15:38:46.433 4.5 ms
UPDATE user_session SET user_id = '618755' WHERE id = '0qj9kialvjskm91j302r6krk5l' AND user_id IS NULL
# Query Count Total Avg Min Max
1
SELECT * FROM `user_agents` `t` WHERE `t`.`user_agent`='python-httpx/0.28.1' LIMIT 1
 2 150.3 ms 75.2 ms 66.1 ms 84.2 ms
2
SELECT LCASE(parent) as parent,LCASE(child) as child, ai.name , ai.type FROM authitemchild ac LEFT JOIN authitem ai ON ai.name = ac.child ORDER BY `ai`.`type` DESC
 1 12.7 ms 12.7 ms 12.7 ms 12.7 ms
3
SELECT * FROM `authassignment` WHERE userid='618755'
 1 8.9 ms 8.9 ms 8.9 ms 8.9 ms
4
SELECT LCASE(itemname) as itemname, ai.type, ai.name FROM authassignment t1 LEFT JOIN authitem ai ON ai.name = t1.itemname where userid = 618755
 1 6.0 ms 6.0 ms 6.0 ms 6.0 ms
5
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`=618755 LIMIT 1
 4 5.5 ms 1.4 ms 1.2 ms 1.5 ms
6
UPDATE user_session SET user_id = '618755' WHERE id = '0qj9kialvjskm91j302r6krk5l' AND user_id IS NULL
 1 4.5 ms 4.5 ms 4.5 ms 4.5 ms
7
UPDATE `user_session` SET `id`='0qj9kialvjskm91j302r6krk5l' WHERE id='09u0hf5c39l7dbl3giahfp85bn'
 1 4.3 ms 4.3 ms 4.3 ms 4.3 ms
8
INSERT INTO `user_session` (`id`, `data`, `expire`) VALUES ('09u0hf5c39l7dbl3giahfp85bn', '', 1758483526)
 1 4.0 ms 4.0 ms 4.0 ms 4.0 ms
9
UPDATE `securelufacom`.`users` SET `user_id`=618755, `user_email`='p.liang@lufa.com', `user_pass`='$2a$08$fsGI56Z5vfh314RhKRM7QelHe6tJ.90DCRKSc/SUBc11hPtBp1dwy', `first_name`='Patrick', `last_name`='Liang', `coordinator_display_name`=NULL, `language`='en', `created`='2025-03-14 00:00:00', `status`=1, `last_forgot_password_request`=NULL, `credits`=NULL, `address`='', `zip_code`='', `phone_home`='', `phone_work`='', `updated`='2025-03-14 11:44:16', `last_login_date`='2025-04-21 15:38:46', `warehouse_id`=NULL, `city_name`='', `state_id`=3, `apt`='', `plan_id`=4, `open_alert`=1, `closed_alert`=1, `customer_profile_id`=NULL, `charge_method`='manual', `free_credits`='0', `card_type`=NULL, `exp_month`=NULL, `exp_year`=NULL, `last_contacted_on`=NULL, `next_contact_on`=NULL, `never_call`=0, `coupon_id`=NULL, `notification_type`=2, `supplier_id`=NULL, `social_provider`='Google', `social_identifier`='108571032030637286732', `social_info2`='108571032030637286732', `social_info1`='p.liang@lufa.com', `gender`=NULL, `birthday`=NULL, `facebook_id`=NULL, `facebook_access_token`=NULL, `image_url`=NULL, `vip`=0, `how_did_you_hear`=NULL, `how_did_you_hear_other`=NULL, `pup_coordinator`=0, `signup_source`=0, `description`='', `beta_tester`=0, `payment_gateway`=0, `payment_token`=NULL, `substitution`=1, `activate_deposit`=0, `deposit`=NULL, `prefered_deposit_amount`=0, `card_last4digits`=NULL, `payment_profile_id`='0', `notification_status`=1, `nb_qa_required`=0, `campaign_referral`=NULL, `login_token`=NULL, `seen_popup`=0, `gift_preferences`=1, `display_sold_out_products`=1, `home_delivery_address`='', `home_delivery_apt`=NULL, `home_delivery_zip_code`='', `home_delivery_city_name`='', `home_delivery_state_id`=3, `home_delivery_comment`=NULL, `home_delivery_leave_basket`=NULL, `fraudulent_reasons_id`=NULL, `signed_up_to_weekly_promotions`=0, `cs_pref_communication_language`='', `in_bad_debt_since`=NULL, `address_lat`=NULL, `address_lng`=NULL, `bonus_program`=0, `employee_status`='Active', `employee_personal_email`='patrick@chinchill.ai', `internal_employee_id`=NULL, `employee_photo_url`=NULL, `date_of_birth`=NULL, `employee_lock`=0, `community_representative_group_id`=15, `coordinator_photo_url`=NULL, `coordinator_description`=NULL, `coordinator_availability`=NULL, `max_rows`=NULL, `primary_task_type_id`=0, `company_id`=NULL, `charitable_account`=0, `family_size`=1, `giveback_donation_percent`='0.00', `order_donation`='0.00', `ident_verified`=0, `mask_donor_identity`=0, `numb_children`=0, `snipeit_userid`=NULL, `job_title`='Customer Service Manager', `dg_coordinator_company_id`=NULL, `guest`=0, `badge_color`=NULL, `internal_grouping_code`=NULL, `bonus_program_version`=1, `users_date_of_last_shipped_order`=NULL, `tier_id`=4, `last_updated_pass`='2025-03-14 11:52:50', `reset_password_token`=NULL, `has_access_to_meal_planner`=0 WHERE `securelufacom`.`users`.`user_id`=618755
 1 3.2 ms 3.2 ms 3.2 ms 3.2 ms
10
INSERT INTO `active_record_logs` (`description`, `action`, `model`, `model_id`, `field`, `old_value`, `new_value`, `created_at`, `user_id`, `parent_model`, `parent_model_id`) VALUES ('User p.liang@lufa.com changed last_login_date for Users[618755].', 'CHANGE', 'Users', '618755', 'last_login_date', '2025-04-21 14:54:02', '2025-04-21 15:38:46', NOW(), 618755, 'Users', '618755')
 1 3.2 ms 3.2 ms 3.2 ms 3.2 ms
11
SHOW FULL COLUMNS FROM `securelufacom`.`users`
 1 3.0 ms 3.0 ms 3.0 ms 3.0 ms
12
SELECT `data` FROM `user_session` WHERE expire>1745264326 AND id='09u0hf5c39l7dbl3giahfp85bn'
 1 3.0 ms 3.0 ms 3.0 ms 3.0 ms
13
INSERT INTO `action_log` (`staff_id`, `user_id`, `action`, `action_type`, `ip_address`, `agent_id`, `time`, `date`) VALUES (618755, 618755, 'Logged in using login token: [v5vej3k6coduvt03vr66tlv8mm | 0qj9kialvjskm91j302r6krk5l]', 10, '12.30.39.214', '344428', '15:38:46', '2025-04-21')
 1 2.9 ms 2.9 ms 2.9 ms 2.9 ms
14
INSERT IGNORE INTO stats_page_requested (url, memory_used, loading_time, ip, user_id, request_body, query_string, cookies) VALUES ('mcpRest/tickets', 4.45, 0.404, '12.30.39.214', '618755', '', '', 's:0:"";');
 1 2.7 ms 2.7 ms 2.7 ms 2.7 ms
15
INSERT INTO `action_log` (`staff_id`, `user_id`, `action`, `action_type`, `ip_address`, `agent_id`, `time`, `date`) VALUES (618755, 618755, 'Found user 618755 using auth token: eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c2VyX2lkIjoiNjE4NzU1IiwiaWF0IjoxNzQyNDkxMjkwfQ.-3DpjedDNhWlREGC-f0Fkp4aK07DPED8mBW6uvREyUo', 10, '12.30.39.214', '344428', '15:38:46', '2025-04-21')
 1 2.6 ms 2.6 ms 2.6 ms 2.6 ms
16
UPDATE `usersLang` SET `l_id`=609580, `user_id`=618755, `lang_id`='en', `l_description`=NULL, `l_coordinator_description`=NULL, `l_coordinator_availability`=NULL WHERE `usersLang`.`l_id`=609580
 1 2.4 ms 2.4 ms 2.4 ms 2.4 ms
17
DELETE FROM `user_session` WHERE id='v5vej3k6coduvt03vr66tlv8mm'
 1 2.3 ms 2.3 ms 2.3 ms 2.3 ms
18
SHOW FULL COLUMNS FROM `tickets`
 1 2.2 ms 2.2 ms 2.2 ms 2.2 ms
19
SELECT `data` FROM `user_session` WHERE expire>1745264326 AND id='0qj9kialvjskm91j302r6krk5l'
 1 2.1 ms 2.1 ms 2.1 ms 2.1 ms
20
SHOW FULL COLUMNS FROM `active_record_logs`
 1 2.1 ms 2.1 ms 2.1 ms 2.1 ms
21
SHOW FULL COLUMNS FROM `marketing_custom_urls`
 1 1.9 ms 1.9 ms 1.9 ms 1.9 ms
22
SHOW FULL COLUMNS FROM `usersLang`
 1 1.7 ms 1.7 ms 1.7 ms 1.7 ms
23
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`='420935' LIMIT 1
 1 1.5 ms 1.5 ms 1.5 ms 1.5 ms
24
SHOW FULL COLUMNS FROM `action_log`
 1 1.5 ms 1.5 ms 1.5 ms 1.5 ms
25
SHOW FULL COLUMNS FROM `user_agents`
 1 1.4 ms 1.4 ms 1.4 ms 1.4 ms
26
SHOW FULL COLUMNS FROM `marketing_campaign_referrals`
 1 1.4 ms 1.4 ms 1.4 ms 1.4 ms
27
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`='254216' LIMIT 1
 1 1.3 ms 1.3 ms 1.3 ms 1.3 ms
28
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`='611354' LIMIT 1
 1 1.2 ms 1.2 ms 1.2 ms 1.2 ms
29
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_email`='p.liang@lufa.com' LIMIT 1
 1 1.2 ms 1.2 ms 1.2 ms 1.2 ms
30
SELECT * FROM `tickets` `t` WHERE ((ticket_type='Email') AND (status='1')) AND (agent_id='618755')
 1 1.2 ms 1.2 ms 1.2 ms 1.2 ms
31
SHOW CREATE TABLE `securelufacom`.`users`
 1 1.2 ms 1.2 ms 1.2 ms 1.2 ms
32
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`='618755' LIMIT 1
 1 1.1 ms 1.1 ms 1.1 ms 1.1 ms
33
SHOW CREATE TABLE `tickets`
 1 1.1 ms 1.1 ms 1.1 ms 1.1 ms
34
SHOW CREATE TABLE `marketing_custom_urls`
 1 1.0 ms 1.0 ms 1.0 ms 1.0 ms
35
SHOW CREATE TABLE `usersLang`
 1 0.9 ms 0.9 ms 0.9 ms 0.9 ms
36
SHOW CREATE TABLE `active_record_logs`
 1 0.9 ms 0.9 ms 0.9 ms 0.9 ms
37
SELECT `t`.`marketing_custom_url_id` AS `t0_c0`, `t`.`marketing_campaign_referral_id` AS `t0_c1`, `t`.`url` AS `t0_c2`, `t`.`target_url` AS `t0_c3`, `campaign_referral`.`marketing_campaign_referral_id` AS `t1_c0`, `campaign_referral`.`name` AS `t1_c1` FROM `marketing_custom_urls` `t` LEFT OUTER JOIN `marketing_campaign_referrals` `campaign_referral` ON (`campaign_referral`.`marketing_campaign_referral_id`=`t`.`marketing_custom_url_id`) WHERE (`t`.`url`='tickets')
 1 0.9 ms 0.9 ms 0.9 ms 0.9 ms
38
SELECT * FROM `usersLang` `t` WHERE user_id='618755'
 1 0.8 ms 0.8 ms 0.8 ms 0.8 ms
39
SELECT * FROM `user_session` WHERE id='09u0hf5c39l7dbl3giahfp85bn'
 1 0.8 ms 0.8 ms 0.8 ms 0.8 ms
40
SHOW CREATE TABLE `marketing_campaign_referrals`
 1 0.8 ms 0.8 ms 0.8 ms 0.8 ms
41
SELECT `data` FROM `user_session` WHERE expire>1745264326 AND id='v5vej3k6coduvt03vr66tlv8mm'
 1 0.8 ms 0.8 ms 0.8 ms 0.8 ms
42
SHOW CREATE TABLE `action_log`
 1 0.8 ms 0.8 ms 0.8 ms 0.8 ms
43
SELECT `id` FROM `user_session` WHERE id='09u0hf5c39l7dbl3giahfp85bn'
 1 0.8 ms 0.8 ms 0.8 ms 0.8 ms
44
SHOW CREATE TABLE `user_agents`
 1 0.8 ms 0.8 ms 0.8 ms 0.8 ms

Component: db (CDbConnection)

Name Value
driver
mysql
server
8.0.30-22
Uptime
20878
Threads
3
Questions
36891
Slow queries
8
Opens
2154
Flush tables
3
Open tables
1928
Queries per second avg
1.766