Yii Debugger
1.1.25
PHP 8.0.30
Status 200
Action McpRestController::actionTickets()
Log 91
Time 430 ms
Memory 5.6 MB
DB 48 266 ms
All Latest
GET http://chinchilldev.lufa.com/en/mcpRest/tickets?status=1&ticket_types=IQARefundRequest&ticket_types=Email at 2025-04-21 03:40:34 by 172.19.0.1
Time Duration Query
15:40:34.089 1.6 ms
SHOW FULL COLUMNS FROM `marketing_custom_urls`
15:40:34.091 1.0 ms
SHOW CREATE TABLE `marketing_custom_urls`
15:40:34.092 1.4 ms
SHOW FULL COLUMNS FROM `marketing_campaign_referrals`
15:40:34.094 0.8 ms
SHOW CREATE TABLE `marketing_campaign_referrals`
15:40:34.095 0.8 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:40:34.098 3.3 ms
SHOW FULL COLUMNS FROM `securelufacom`.`users`
15:40:34.102 1.2 ms
SHOW CREATE TABLE `securelufacom`.`users`
15:40:34.105 1.2 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`=618755 LIMIT 1
Explain
15:40:34.109 1.6 ms
SHOW FULL COLUMNS FROM `action_log`
15:40:34.111 1.1 ms
SHOW CREATE TABLE `action_log`
15:40:34.113 2.6 ms
SELECT `data` FROM `user_session` WHERE expire>1745264434 AND id='nnk2ikes4bni4gebbt2n2n1bhu'
Explain
15:40:34.116 1.8 ms
SHOW FULL COLUMNS FROM `user_agents`
15:40:34.118 1.8 ms
SHOW CREATE TABLE `user_agents`
15:40:34.120 71.0 ms
SELECT * FROM `user_agents` `t` WHERE `t`.`user_agent`='python-httpx/0.28.1' LIMIT 1
Explain
15:40:34.191 4.5 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:40:34', '2025-04-21')
15:40:34.196 1.4 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_email`='p.liang@lufa.com' LIMIT 1
Explain
15:40:34.199 1.3 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`='618755' LIMIT 1
Explain
15:40:34.208 4.1 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:40:34', `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:40:34.212 2.0 ms
SHOW FULL COLUMNS FROM `active_record_logs`
15:40:34.215 1.0 ms
SHOW CREATE TABLE `active_record_logs`
15:40:34.216 2.8 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:38:46', '2025-04-21 15:40:34', NOW(), 2, 'Users', '618755')
15:40:34.219 1.7 ms
SHOW FULL COLUMNS FROM `usersLang`
15:40:34.221 1.0 ms
SHOW CREATE TABLE `usersLang`
15:40:34.222 0.9 ms
SELECT * FROM `usersLang` `t` WHERE user_id='618755'
Explain
15:40:34.223 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:40:34.226 0.8 ms
DELETE FROM `user_session` WHERE id='nnk2ikes4bni4gebbt2n2n1bhu'
15:40:34.227 3.0 ms
SELECT `data` FROM `user_session` WHERE expire>1745264434 AND id='mbehnm70j1oku7rf4obrg9hq1f'
Explain
15:40:34.230 0.9 ms
SELECT `id` FROM `user_session` WHERE id='mbehnm70j1oku7rf4obrg9hq1f'
Explain
15:40:34.231 2.3 ms
INSERT INTO `user_session` (`id`, `data`, `expire`) VALUES ('mbehnm70j1oku7rf4obrg9hq1f', '', 1758483634)
15:40:34.234 2.2 ms
SELECT `data` FROM `user_session` WHERE expire>1745264434 AND id='84jft88c9r0kcit36hvshu58os'
Explain
15:40:34.236 1.0 ms
SELECT * FROM `user_session` WHERE id='mbehnm70j1oku7rf4obrg9hq1f'
Explain
15:40:34.237 2.4 ms
UPDATE `user_session` SET `id`='84jft88c9r0kcit36hvshu58os' WHERE id='mbehnm70j1oku7rf4obrg9hq1f'
15:40:34.240 13.7 ms
SELECT * FROM `authassignment` WHERE userid='618755'
Explain
15:40:34.255 1.4 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`=618755 LIMIT 1
Explain
15:40:34.258 5.8 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:40:34.264 12.5 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:40:34.282 83.0 ms
SELECT * FROM `user_agents` `t` WHERE `t`.`user_agent`='python-httpx/0.28.1' LIMIT 1
Explain
15:40:34.365 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: [nnk2ikes4bni4gebbt2n2n1bhu | 84jft88c9r0kcit36hvshu58os]', 10, '12.30.39.214', '344428', '15:40:34', '2025-04-21')
15:40:34.368 1.4 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`=618755 LIMIT 1
Explain
15:40:34.372 1.3 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`=618755 LIMIT 1
Explain
15:40:34.375 2.1 ms
SHOW FULL COLUMNS FROM `tickets`
15:40:34.377 1.0 ms
SHOW CREATE TABLE `tickets`
15:40:34.378 1.2 ms
SELECT * FROM `tickets` `t` WHERE ((ticket_type='Email') AND (status='1')) AND (agent_id='618755')
Explain
15:40:34.468 1.7 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`='420935' LIMIT 1
Explain
15:40:34.475 1.6 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`='611354' LIMIT 1
Explain
15:40:34.482 1.6 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`='254216' LIMIT 1
Explain
15:40:34.485 3.0 ms
INSERT IGNORE INTO stats_page_requested (url, memory_used, loading_time, ip, user_id, request_body, query_string, cookies) VALUES ('mcpRest/tickets', 4.44, 0.421, '12.30.39.214', '618755', '', '', 's:0:"";');
15:40:34.488 4.4 ms
UPDATE user_session SET user_id = '618755' WHERE id = '84jft88c9r0kcit36hvshu58os' 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 154.0 ms 77.0 ms 71.0 ms 83.0 ms
2
SELECT * FROM `authassignment` WHERE userid='618755'
 1 13.7 ms 13.7 ms 13.7 ms 13.7 ms
3
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.5 ms 12.5 ms 12.5 ms 12.5 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 5.8 ms 5.8 ms 5.8 ms 5.8 ms
5
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`=618755 LIMIT 1
 4 5.3 ms 1.3 ms 1.2 ms 1.4 ms
6
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:40:34', '2025-04-21')
 1 4.5 ms 4.5 ms 4.5 ms 4.5 ms
7
UPDATE user_session SET user_id = '618755' WHERE id = '84jft88c9r0kcit36hvshu58os' AND user_id IS NULL
 1 4.4 ms 4.4 ms 4.4 ms 4.4 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:40:34', `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 4.1 ms 4.1 ms 4.1 ms 4.1 ms
9
SHOW FULL COLUMNS FROM `securelufacom`.`users`
 1 3.3 ms 3.3 ms 3.3 ms 3.3 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: [nnk2ikes4bni4gebbt2n2n1bhu | 84jft88c9r0kcit36hvshu58os]', 10, '12.30.39.214', '344428', '15:40:34', '2025-04-21')
 1 3.1 ms 3.1 ms 3.1 ms 3.1 ms
11
SELECT `data` FROM `user_session` WHERE expire>1745264434 AND id='mbehnm70j1oku7rf4obrg9hq1f'
 1 3.0 ms 3.0 ms 3.0 ms 3.0 ms
12
INSERT IGNORE INTO stats_page_requested (url, memory_used, loading_time, ip, user_id, request_body, query_string, cookies) VALUES ('mcpRest/tickets', 4.44, 0.421, '12.30.39.214', '618755', '', '', 's:0:"";');
 1 3.0 ms 3.0 ms 3.0 ms 3.0 ms
13
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:38:46', '2025-04-21 15:40:34', NOW(), 2, 'Users', '618755')
 1 2.8 ms 2.8 ms 2.8 ms 2.8 ms
14
SELECT `data` FROM `user_session` WHERE expire>1745264434 AND id='nnk2ikes4bni4gebbt2n2n1bhu'
 1 2.6 ms 2.6 ms 2.6 ms 2.6 ms
15
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
16
UPDATE `user_session` SET `id`='84jft88c9r0kcit36hvshu58os' WHERE id='mbehnm70j1oku7rf4obrg9hq1f'
 1 2.4 ms 2.4 ms 2.4 ms 2.4 ms
17
INSERT INTO `user_session` (`id`, `data`, `expire`) VALUES ('mbehnm70j1oku7rf4obrg9hq1f', '', 1758483634)
 1 2.3 ms 2.3 ms 2.3 ms 2.3 ms
18
SELECT `data` FROM `user_session` WHERE expire>1745264434 AND id='84jft88c9r0kcit36hvshu58os'
 1 2.2 ms 2.2 ms 2.2 ms 2.2 ms
19
SHOW FULL COLUMNS FROM `tickets`
 1 2.1 ms 2.1 ms 2.1 ms 2.1 ms
20
SHOW FULL COLUMNS FROM `active_record_logs`
 1 2.0 ms 2.0 ms 2.0 ms 2.0 ms
21
SHOW CREATE TABLE `user_agents`
 1 1.8 ms 1.8 ms 1.8 ms 1.8 ms
22
SHOW FULL COLUMNS FROM `user_agents`
 1 1.8 ms 1.8 ms 1.8 ms 1.8 ms
23
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`='420935' LIMIT 1
 1 1.7 ms 1.7 ms 1.7 ms 1.7 ms
24
SHOW FULL COLUMNS FROM `usersLang`
 1 1.7 ms 1.7 ms 1.7 ms 1.7 ms
25
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`='254216' LIMIT 1
 1 1.6 ms 1.6 ms 1.6 ms 1.6 ms
26
SHOW FULL COLUMNS FROM `marketing_custom_urls`
 1 1.6 ms 1.6 ms 1.6 ms 1.6 ms
27
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`='611354' LIMIT 1
 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_email`='p.liang@lufa.com' LIMIT 1
 1 1.4 ms 1.4 ms 1.4 ms 1.4 ms
30
SHOW FULL COLUMNS FROM `marketing_campaign_referrals`
 1 1.4 ms 1.4 ms 1.4 ms 1.4 ms
31
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
32
SHOW CREATE TABLE `securelufacom`.`users`
 1 1.2 ms 1.2 ms 1.2 ms 1.2 ms
33
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
34
SHOW CREATE TABLE `action_log`
 1 1.1 ms 1.1 ms 1.1 ms 1.1 ms
35
SHOW CREATE TABLE `marketing_custom_urls`
 1 1.0 ms 1.0 ms 1.0 ms 1.0 ms
36
SHOW CREATE TABLE `usersLang`
 1 1.0 ms 1.0 ms 1.0 ms 1.0 ms
37
SHOW CREATE TABLE `active_record_logs`
 1 1.0 ms 1.0 ms 1.0 ms 1.0 ms
38
SELECT * FROM `user_session` WHERE id='mbehnm70j1oku7rf4obrg9hq1f'
 1 1.0 ms 1.0 ms 1.0 ms 1.0 ms
39
SHOW CREATE TABLE `tickets`
 1 1.0 ms 1.0 ms 1.0 ms 1.0 ms
40
SELECT * FROM `usersLang` `t` WHERE user_id='618755'
 1 0.9 ms 0.9 ms 0.9 ms 0.9 ms
41
SELECT `id` FROM `user_session` WHERE id='mbehnm70j1oku7rf4obrg9hq1f'
 1 0.9 ms 0.9 ms 0.9 ms 0.9 ms
42
SHOW CREATE TABLE `marketing_campaign_referrals`
 1 0.8 ms 0.8 ms 0.8 ms 0.8 ms
43
DELETE FROM `user_session` WHERE id='nnk2ikes4bni4gebbt2n2n1bhu'
 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.8 ms 0.8 ms 0.8 ms 0.8 ms

Component: db (CDbConnection)

Name Value
driver
mysql
server
8.0.30-22
Uptime
20986
Threads
2
Questions
37461
Slow queries
8
Opens
2156
Flush tables
3
Open tables
1930
Queries per second avg
1.785