Yii Debugger
1.1.25
PHP 8.0.30
Status 200
Action McpRestController::actionTickets()
Log 91
Time 415 ms
Memory 5.6 MB
DB 48 250 ms
All Latest
GET http://chinchilldev.lufa.com/en/mcpRest/tickets?status=1&ticket_types=IQARefundRequest&ticket_types=Email at 2025-04-21 03:55:29 by 172.19.0.1
Time Duration Query
15:55:29.412 2.0 ms
SHOW FULL COLUMNS FROM `marketing_custom_urls`
15:55:29.414 0.9 ms
SHOW CREATE TABLE `marketing_custom_urls`
15:55:29.415 1.6 ms
SHOW FULL COLUMNS FROM `marketing_campaign_referrals`
15:55:29.417 0.8 ms
SHOW CREATE TABLE `marketing_campaign_referrals`
15:55:29.418 0.7 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:55:29.421 2.9 ms
SHOW FULL COLUMNS FROM `securelufacom`.`users`
15:55:29.425 1.3 ms
SHOW CREATE TABLE `securelufacom`.`users`
15:55:29.428 1.2 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`=618755 LIMIT 1
Explain
15:55:29.431 1.6 ms
SHOW FULL COLUMNS FROM `action_log`
15:55:29.433 0.8 ms
SHOW CREATE TABLE `action_log`
15:55:29.434 2.5 ms
SELECT `data` FROM `user_session` WHERE expire>1745265329 AND id='klk3vvdm070hqaifmv86o963cd'
Explain
15:55:29.437 2.2 ms
SHOW FULL COLUMNS FROM `user_agents`
15:55:29.439 1.0 ms
SHOW CREATE TABLE `user_agents`
15:55:29.440 65.7 ms
SELECT * FROM `user_agents` `t` WHERE `t`.`user_agent`='python-httpx/0.28.1' LIMIT 1
Explain
15:55:29.506 9.4 ms
INSERT INTO `action_log` (`staff_id`, `user_id`, `action`, `action_type`, `ip_address`, `agent_id`, `time`, `date`) VALUES (NULL, 618755, 'Found user 618755 using auth token: eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c2VyX2lkIjoiNjE4NzU1IiwiaWF0IjoxNzQyNDkxMjkwfQ.-3DpjedDNhWlREGC-f0Fkp4aK07DPED8mBW6uvREyUo', 10, '12.30.39.214', '344428', '15:55:29', '2025-04-21')
15:55:29.516 1.7 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_email`='p.liang@lufa.com' LIMIT 1
Explain
15:55:29.519 1.3 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`='618755' LIMIT 1
Explain
15:55:29.529 3.7 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:55:29', `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:55:29.533 2.9 ms
SHOW FULL COLUMNS FROM `active_record_logs`
15:55:29.536 1.1 ms
SHOW CREATE TABLE `active_record_logs`
15:55:29.538 2.6 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 Guest changed last_login_date for Users[618755].', 'CHANGE', 'Users', '618755', 'last_login_date', '2025-04-21 15:51:07', '2025-04-21 15:55:29', NOW(), 2, 'Users', '618755')
15:55:29.541 1.9 ms
SHOW FULL COLUMNS FROM `usersLang`
15:55:29.543 0.9 ms
SHOW CREATE TABLE `usersLang`
15:55:29.544 0.8 ms
SELECT * FROM `usersLang` `t` WHERE user_id='618755'
Explain
15:55:29.545 2.5 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:55:29.548 1.0 ms
DELETE FROM `user_session` WHERE id='klk3vvdm070hqaifmv86o963cd'
15:55:29.549 2.3 ms
SELECT `data` FROM `user_session` WHERE expire>1745265329 AND id='5mgmb7ebtltob1qlbhe3ha72u2'
Explain
15:55:29.552 0.8 ms
SELECT `id` FROM `user_session` WHERE id='5mgmb7ebtltob1qlbhe3ha72u2'
Explain
15:55:29.553 2.6 ms
INSERT INTO `user_session` (`id`, `data`, `expire`) VALUES ('5mgmb7ebtltob1qlbhe3ha72u2', '', 1758484529)
15:55:29.555 2.7 ms
SELECT `data` FROM `user_session` WHERE expire>1745265329 AND id='lffc6oa17c1nmgpsp1485uek3j'
Explain
15:55:29.558 1.3 ms
SELECT * FROM `user_session` WHERE id='5mgmb7ebtltob1qlbhe3ha72u2'
Explain
15:55:29.560 2.8 ms
UPDATE `user_session` SET `id`='lffc6oa17c1nmgpsp1485uek3j' WHERE id='5mgmb7ebtltob1qlbhe3ha72u2'
15:55:29.563 8.5 ms
SELECT * FROM `authassignment` WHERE userid='618755'
Explain
15:55:29.573 1.5 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`=618755 LIMIT 1
Explain
15:55:29.576 4.9 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:55:29.581 11.8 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:55:29.598 67.1 ms
SELECT * FROM `user_agents` `t` WHERE `t`.`user_agent`='python-httpx/0.28.1' LIMIT 1
Explain
15:55:29.665 3.1 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: [klk3vvdm070hqaifmv86o963cd | lffc6oa17c1nmgpsp1485uek3j]', 10, '12.30.39.214', '344428', '15:55:29', '2025-04-21')
15:55:29.669 1.5 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`=618755 LIMIT 1
Explain
15:55:29.673 1.7 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`=618755 LIMIT 1
Explain
15:55:29.676 2.4 ms
SHOW FULL COLUMNS FROM `tickets`
15:55:29.679 1.2 ms
SHOW CREATE TABLE `tickets`
15:55:29.680 1.3 ms
SELECT * FROM `tickets` `t` WHERE ((ticket_type='Email') AND (status='1')) AND (agent_id='618755')
Explain
15:55:29.773 2.3 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`='420935' LIMIT 1
Explain
15:55:29.780 1.7 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`='611354' LIMIT 1
Explain
15:55:29.790 1.5 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`='254216' LIMIT 1
Explain
15:55:29.793 3.1 ms
INSERT IGNORE INTO stats_page_requested (url, memory_used, loading_time, ip, user_id, request_body, query_string, cookies) VALUES ('mcpRest/tickets', 4.46, 0.401, '12.30.39.214', '618755', '', '', 's:0:"";');
15:55:29.796 9.1 ms
UPDATE user_session SET user_id = '618755' WHERE id = 'lffc6oa17c1nmgpsp1485uek3j' 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 132.8 ms 66.4 ms 65.7 ms 67.1 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 11.8 ms 11.8 ms 11.8 ms 11.8 ms
3
INSERT INTO `action_log` (`staff_id`, `user_id`, `action`, `action_type`, `ip_address`, `agent_id`, `time`, `date`) VALUES (NULL, 618755, 'Found user 618755 using auth token: eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c2VyX2lkIjoiNjE4NzU1IiwiaWF0IjoxNzQyNDkxMjkwfQ.-3DpjedDNhWlREGC-f0Fkp4aK07DPED8mBW6uvREyUo', 10, '12.30.39.214', '344428', '15:55:29', '2025-04-21')
 1 9.4 ms 9.4 ms 9.4 ms 9.4 ms
4
UPDATE user_session SET user_id = '618755' WHERE id = 'lffc6oa17c1nmgpsp1485uek3j' AND user_id IS NULL
 1 9.1 ms 9.1 ms 9.1 ms 9.1 ms
5
SELECT * FROM `authassignment` WHERE userid='618755'
 1 8.5 ms 8.5 ms 8.5 ms 8.5 ms
6
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`=618755 LIMIT 1
 4 5.9 ms 1.5 ms 1.2 ms 1.7 ms
7
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 4.9 ms 4.9 ms 4.9 ms 4.9 ms
8
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:55:29', `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.7 ms 3.7 ms 3.7 ms 3.7 ms
9
INSERT IGNORE INTO stats_page_requested (url, memory_used, loading_time, ip, user_id, request_body, query_string, cookies) VALUES ('mcpRest/tickets', 4.46, 0.401, '12.30.39.214', '618755', '', '', 's:0:"";');
 1 3.1 ms 3.1 ms 3.1 ms 3.1 ms
10
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: [klk3vvdm070hqaifmv86o963cd | lffc6oa17c1nmgpsp1485uek3j]', 10, '12.30.39.214', '344428', '15:55:29', '2025-04-21')
 1 3.1 ms 3.1 ms 3.1 ms 3.1 ms
11
SHOW FULL COLUMNS FROM `active_record_logs`
 1 2.9 ms 2.9 ms 2.9 ms 2.9 ms
12
SHOW FULL COLUMNS FROM `securelufacom`.`users`
 1 2.9 ms 2.9 ms 2.9 ms 2.9 ms
13
UPDATE `user_session` SET `id`='lffc6oa17c1nmgpsp1485uek3j' WHERE id='5mgmb7ebtltob1qlbhe3ha72u2'
 1 2.8 ms 2.8 ms 2.8 ms 2.8 ms
14
SELECT `data` FROM `user_session` WHERE expire>1745265329 AND id='lffc6oa17c1nmgpsp1485uek3j'
 1 2.7 ms 2.7 ms 2.7 ms 2.7 ms
15
INSERT INTO `user_session` (`id`, `data`, `expire`) VALUES ('5mgmb7ebtltob1qlbhe3ha72u2', '', 1758484529)
 1 2.6 ms 2.6 ms 2.6 ms 2.6 ms
16
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 Guest changed last_login_date for Users[618755].', 'CHANGE', 'Users', '618755', 'last_login_date', '2025-04-21 15:51:07', '2025-04-21 15:55:29', NOW(), 2, 'Users', '618755')
 1 2.6 ms 2.6 ms 2.6 ms 2.6 ms
17
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.5 ms 2.5 ms 2.5 ms 2.5 ms
18
SELECT `data` FROM `user_session` WHERE expire>1745265329 AND id='klk3vvdm070hqaifmv86o963cd'
 1 2.5 ms 2.5 ms 2.5 ms 2.5 ms
19
SHOW FULL COLUMNS FROM `tickets`
 1 2.4 ms 2.4 ms 2.4 ms 2.4 ms
20
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`='420935' LIMIT 1
 1 2.3 ms 2.3 ms 2.3 ms 2.3 ms
21
SELECT `data` FROM `user_session` WHERE expire>1745265329 AND id='5mgmb7ebtltob1qlbhe3ha72u2'
 1 2.3 ms 2.3 ms 2.3 ms 2.3 ms
22
SHOW FULL COLUMNS FROM `user_agents`
 1 2.2 ms 2.2 ms 2.2 ms 2.2 ms
23
SHOW FULL COLUMNS FROM `marketing_custom_urls`
 1 2.0 ms 2.0 ms 2.0 ms 2.0 ms
24
SHOW FULL COLUMNS FROM `usersLang`
 1 1.9 ms 1.9 ms 1.9 ms 1.9 ms
25
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`='611354' LIMIT 1
 1 1.7 ms 1.7 ms 1.7 ms 1.7 ms
26
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_email`='p.liang@lufa.com' LIMIT 1
 1 1.7 ms 1.7 ms 1.7 ms 1.7 ms
27
SHOW FULL COLUMNS FROM `marketing_campaign_referrals`
 1 1.6 ms 1.6 ms 1.6 ms 1.6 ms
28
SHOW FULL COLUMNS FROM `action_log`
 1 1.6 ms 1.6 ms 1.6 ms 1.6 ms
29
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`='254216' LIMIT 1
 1 1.5 ms 1.5 ms 1.5 ms 1.5 ms
30
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`='618755' LIMIT 1
 1 1.3 ms 1.3 ms 1.3 ms 1.3 ms
31
SHOW CREATE TABLE `securelufacom`.`users`
 1 1.3 ms 1.3 ms 1.3 ms 1.3 ms
32
SELECT * FROM `user_session` WHERE id='5mgmb7ebtltob1qlbhe3ha72u2'
 1 1.3 ms 1.3 ms 1.3 ms 1.3 ms
33
SELECT * FROM `tickets` `t` WHERE ((ticket_type='Email') AND (status='1')) AND (agent_id='618755')
 1 1.3 ms 1.3 ms 1.3 ms 1.3 ms
34
SHOW CREATE TABLE `tickets`
 1 1.2 ms 1.2 ms 1.2 ms 1.2 ms
35
SHOW CREATE TABLE `active_record_logs`
 1 1.1 ms 1.1 ms 1.1 ms 1.1 ms
36
SHOW CREATE TABLE `user_agents`
 1 1.0 ms 1.0 ms 1.0 ms 1.0 ms
37
DELETE FROM `user_session` WHERE id='klk3vvdm070hqaifmv86o963cd'
 1 1.0 ms 1.0 ms 1.0 ms 1.0 ms
38
SHOW CREATE TABLE `marketing_custom_urls`
 1 0.9 ms 0.9 ms 0.9 ms 0.9 ms
39
SHOW CREATE TABLE `usersLang`
 1 0.9 ms 0.9 ms 0.9 ms 0.9 ms
40
SELECT `id` FROM `user_session` WHERE id='5mgmb7ebtltob1qlbhe3ha72u2'
 1 0.8 ms 0.8 ms 0.8 ms 0.8 ms
41
SELECT * FROM `usersLang` `t` WHERE user_id='618755'
 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
SHOW CREATE TABLE `marketing_campaign_referrals`
 1 0.8 ms 0.8 ms 0.8 ms 0.8 ms
44
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.7 ms 0.7 ms 0.7 ms 0.7 ms

Component: db (CDbConnection)

Name Value
driver
mysql
server
8.0.30-22
Uptime
21881
Threads
2
Questions
40785
Slow queries
8
Opens
2168
Flush tables
3
Open tables
1932
Queries per second avg
1.863