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
Total processing time: 415 ms; Peak memory: 5.6 MB.
| Time | Category | Procedure |
|---|---|---|
| 2.0 ms | system.db.CDbCommand.query | system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `marketing_custom_urls`) |
| 0.9 ms | system.db.CDbCommand.query | system.db.CDbCommand.query(SHOW CREATE TABLE `marketing_custom_urls`) |
| 1.6 ms | system.db.CDbCommand.query | system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `marketing_campaign_referrals`) |
| 0.8 ms | system.db.CDbCommand.query | system.db.CDbCommand.query(SHOW CREATE TABLE `marketing_campaign_referrals`) |
| 0.7 ms | system.db.CDbCommand.query | system.db.CDbCommand.query(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`=:yp0). Bound with :yp0='tickets') |
| 2.9 ms | system.db.CDbCommand.query | system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `securelufacom`.`users`) |
| 1.3 ms | system.db.CDbCommand.query | system.db.CDbCommand.query(SHOW CREATE TABLE `securelufacom`.`users`) |
| 1.2 ms | system.db.CDbCommand.query | system.db.CDbCommand.query(SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`=618755 LIMIT 1) |
| 1.6 ms | system.db.CDbCommand.query | system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `action_log`) |
| 0.8 ms | system.db.CDbCommand.query | system.db.CDbCommand.query(SHOW CREATE TABLE `action_log`) |
| 2.5 ms | system.db.CDbCommand.query | system.db.CDbCommand.query(SELECT `data` FROM `user_session` WHERE expire>:expire AND id=:id. Bound with :expire=1745265329, :id='klk3vvdm070hqaifmv86o963cd') |
| 2.2 ms | system.db.CDbCommand.query | system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `user_agents`) |
| 1.0 ms | system.db.CDbCommand.query | system.db.CDbCommand.query(SHOW CREATE TABLE `user_agents`) |
| 65.7 ms | system.db.CDbCommand.query | system.db.CDbCommand.query(SELECT * FROM `user_agents` `t` WHERE `t`.`user_agent`=:yp0 LIMIT 1. Bound with :yp0='python-httpx/0.28.1') |
| 9.4 ms | system.db.CDbCommand.execute | system.db.CDbCommand.execute(INSERT INTO `action_log` (`staff_id`, `user_id`, `action`, `action_type`, `ip_address`, `agent_id`, `time`, `date`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7). Bound with :yp0=NULL, :yp1=618755, :yp2='Found user 618755 using auth token: eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c2VyX2lkIjoiNjE4NzU1IiwiaWF0IjoxNzQyNDkxMjkwfQ.-3DpjedDNhWlREGC-f0Fkp4aK07DPED8mBW6uvREyUo', :yp3=10, :yp4='12.30.39.214', :yp5='344428', :yp6='15:55:29', :yp7='2025-04-21') |
| 1.7 ms | system.db.CDbCommand.query | system.db.CDbCommand.query(SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_email`=:yp0 LIMIT 1. Bound with :yp0='p.liang@lufa.com') |
| 1.3 ms | system.db.CDbCommand.query | system.db.CDbCommand.query(SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`=:yp0 LIMIT 1. Bound with :yp0='618755') |
| 3.7 ms | system.db.CDbCommand.execute | system.db.CDbCommand.execute(UPDATE `securelufacom`.`users` SET `user_id`=:yp0, `user_email`=:yp1, `user_pass`=:yp2, `first_name`=:yp3, `last_name`=:yp4, `coordinator_display_name`=:yp5, `language`=:yp6, `created`=:yp7, `status`=:yp8, `last_forgot_password_request`=:yp9, `credits`=:yp10, `address`=:yp11, `zip_code`=:yp12, `phone_home`=:yp13, `phone_work`=:yp14, `updated`=:yp15, `last_login_date`=:yp16, `warehouse_id`=:yp17, `city_name`=:yp18, `state_id`=:yp19, `apt`=:yp20, `plan_id`=:yp21, `open_alert`=:yp22, `closed_alert`=:yp23, `customer_profile_id`=:yp24, `charge_method`=:yp25, `free_credits`=:yp26, `card_type`=:yp27, `exp_month`=:yp28, `exp_year`=:yp29, `last_contacted_on`=:yp30, `next_contact_on`=:yp31, `never_call`=:yp32, `coupon_id`=:yp33, `notification_type`=:yp34, `supplier_id`=:yp35, `social_provider`=:yp36, `social_identifier`=:yp37, `social_info2`=:yp38, `social_info1`=:yp39, `gender`=:yp40, `birthday`=:yp41, `facebook_id`=:yp42, `facebook_access_token`=:yp43, `image_url`=:yp44, `vip`=:yp45, `how_did_you_hear`=:yp46, `how_did_you_hear_other`=:yp47, `pup_coordinator`=:yp48, `signup_source`=:yp49, `description`=:yp50, `beta_tester`=:yp51, `payment_gateway`=:yp52, `payment_token`=:yp53, `substitution`=:yp54, `activate_deposit`=:yp55, `deposit`=:yp56, `prefered_deposit_amount`=:yp57, `card_last4digits`=:yp58, `payment_profile_id`=:yp59, `notification_status`=:yp60, `nb_qa_required`=:yp61, `campaign_referral`=:yp62, `login_token`=:yp63, `seen_popup`=:yp64, `gift_preferences`=:yp65, `display_sold_out_products`=:yp66, `home_delivery_address`=:yp67, `home_delivery_apt`=:yp68, `home_delivery_zip_code`=:yp69, `home_delivery_city_name`=:yp70, `home_delivery_state_id`=:yp71, `home_delivery_comment`=:yp72, `home_delivery_leave_basket`=:yp73, `fraudulent_reasons_id`=:yp74, `signed_up_to_weekly_promotions`=:yp75, `cs_pref_communication_language`=:yp76, `in_bad_debt_since`=:yp77, `address_lat`=:yp78, `address_lng`=:yp79, `bonus_program`=:yp80, `employee_status`=:yp81, `employee_personal_email`=:yp82, `internal_employee_id`=:yp83, `employee_photo_url`=:yp84, `date_of_birth`=:yp85, `employee_lock`=:yp86, `community_representative_group_id`=:yp87, `coordinator_photo_url`=:yp88, `coordinator_description`=:yp89, `coordinator_availability`=:yp90, `max_rows`=:yp91, `primary_task_type_id`=:yp92, `company_id`=:yp93, `charitable_account`=:yp94, `family_size`=:yp95, `giveback_donation_percent`=:yp96, `order_donation`=:yp97, `ident_verified`=:yp98, `mask_donor_identity`=:yp99, `numb_children`=:yp100, `snipeit_userid`=:yp101, `job_title`=:yp102, `dg_coordinator_company_id`=:yp103, `guest`=:yp104, `badge_color`=:yp105, `internal_grouping_code`=:yp106, `bonus_program_version`=:yp107, `users_date_of_last_shipped_order`=:yp108, `tier_id`=:yp109, `last_updated_pass`=:yp110, `reset_password_token`=:yp111, `has_access_to_meal_planner`=:yp112 WHERE `securelufacom`.`users`.`user_id`=618755. Bound with :yp0=618755, :yp1='p.liang@lufa.com', :yp2='$2a$08$fsGI56Z5vfh314RhKRM7QelHe6tJ.90DCRKSc/SUBc11hPtBp1dwy', :yp3='Patrick', :yp4='Liang', :yp5=NULL, :yp6='en', :yp7='2025-03-14 00:00:00', :yp8=1, :yp9=NULL, :yp10=NULL, :yp11='', :yp12='', :yp13='', :yp14='', :yp15='2025-03-14 11:44:16', :yp16='2025-04-21 15:55:29', :yp17=NULL, :yp18='', :yp19=3, :yp20='', :yp21=4, :yp22=1, :yp23=1, :yp24=NULL, :yp25='manual', :yp26='0', :yp27=NULL, :yp28=NULL, :yp29=NULL, :yp30=NULL, :yp31=NULL, :yp32=0, :yp33=NULL, :yp34=2, :yp35=NULL, :yp36='Google', :yp37='108571032030637286732', :yp38='108571032030637286732', :yp39='p.liang@lufa.com', :yp40=NULL, :yp41=NULL, :yp42=NULL, :yp43=NULL, :yp44=NULL, :yp45=0, :yp46=NULL, :yp47=NULL, :yp48=0, :yp49=0, :yp50='', :yp51=0, :yp52=0, :yp53=NULL, :yp54=1, :yp55=0, :yp56=NULL, :yp57=0, :yp58=NULL, :yp59='0', :yp60=1, :yp61=0, :yp62=NULL, :yp63=NULL, :yp64=0, :yp65=1, :yp66=1, :yp67='', :yp68=NULL, :yp69='', :yp70='', :yp71=3, :yp72=NULL, :yp73=NULL, :yp74=NULL, :yp75=0, :yp76='', :yp77=NULL, :yp78=NULL, :yp79=NULL, :yp80=0, :yp81='Active', :yp82='patrick@chinchill.ai', :yp83=NULL, :yp84=NULL, :yp85=NULL, :yp86=0, :yp87=15, :yp88=NULL, :yp89=NULL, :yp90=NULL, :yp91=NULL, :yp92=0, :yp93=NULL, :yp94=0, :yp95=1, :yp96='0.00', :yp97='0.00', :yp98=0, :yp99=0, :yp100=0, :yp101=NULL, :yp102='Customer Service Manager', :yp103=NULL, :yp104=0, :yp105=NULL, :yp106=NULL, :yp107=1, :yp108=NULL, :yp109=4, :yp110='2025-03-14 11:52:50', :yp111=NULL, :yp112=0) |
| 2.9 ms | system.db.CDbCommand.query | system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `active_record_logs`) |
| 1.1 ms | system.db.CDbCommand.query | system.db.CDbCommand.query(SHOW CREATE TABLE `active_record_logs`) |
| 2.6 ms | system.db.CDbCommand.execute | system.db.CDbCommand.execute(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 (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, NOW(), :yp7, :yp8, :yp9). Bound with :yp0='User Guest changed last_login_date for Users[618755].', :yp1='CHANGE', :yp2='Users', :yp3='618755', :yp4='last_login_date', :yp5='2025-04-21 15:51:07', :yp6='2025-04-21 15:55:29', :yp7=2, :yp8='Users', :yp9='618755') |
| 1.9 ms | system.db.CDbCommand.query | system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `usersLang`) |
| 0.9 ms | system.db.CDbCommand.query | system.db.CDbCommand.query(SHOW CREATE TABLE `usersLang`) |
| 0.8 ms | system.db.CDbCommand.query | system.db.CDbCommand.query(SELECT * FROM `usersLang` `t` WHERE user_id=:id. Bound with :id='618755') |
| 2.5 ms | system.db.CDbCommand.execute | system.db.CDbCommand.execute(UPDATE `usersLang` SET `l_id`=:yp0, `user_id`=:yp1, `lang_id`=:yp2, `l_description`=:yp3, `l_coordinator_description`=:yp4, `l_coordinator_availability`=:yp5 WHERE `usersLang`.`l_id`=609580. Bound with :yp0=609580, :yp1=618755, :yp2='en', :yp3=NULL, :yp4=NULL, :yp5=NULL) |
| 1.0 ms | system.db.CDbCommand.execute | system.db.CDbCommand.execute(DELETE FROM `user_session` WHERE id=:id. Bound with :id='klk3vvdm070hqaifmv86o963cd') |
| 2.3 ms | system.db.CDbCommand.query | system.db.CDbCommand.query(SELECT `data` FROM `user_session` WHERE expire>:expire AND id=:id. Bound with :expire=1745265329, :id='5mgmb7ebtltob1qlbhe3ha72u2') |
| 0.8 ms | system.db.CDbCommand.query | system.db.CDbCommand.query(SELECT `id` FROM `user_session` WHERE id=:id. Bound with :id='5mgmb7ebtltob1qlbhe3ha72u2') |
| 2.6 ms | system.db.CDbCommand.execute | system.db.CDbCommand.execute(INSERT INTO `user_session` (`id`, `data`, `expire`) VALUES (:id, :data, :expire). Bound with :id='5mgmb7ebtltob1qlbhe3ha72u2', :data='', :expire=1758484529) |
| 2.7 ms | system.db.CDbCommand.query | system.db.CDbCommand.query(SELECT `data` FROM `user_session` WHERE expire>:expire AND id=:id. Bound with :expire=1745265329, :id='lffc6oa17c1nmgpsp1485uek3j') |
| 1.3 ms | system.db.CDbCommand.query | system.db.CDbCommand.query(SELECT * FROM `user_session` WHERE id=:id. Bound with :id='5mgmb7ebtltob1qlbhe3ha72u2') |
| 2.8 ms | system.db.CDbCommand.execute | system.db.CDbCommand.execute(UPDATE `user_session` SET `id`=:id WHERE id=:oldID. Bound with :oldID='5mgmb7ebtltob1qlbhe3ha72u2', :id='lffc6oa17c1nmgpsp1485uek3j') |
| 8.5 ms | system.db.CDbCommand.query | system.db.CDbCommand.query(SELECT * FROM `authassignment` WHERE userid=:userid. Bound with :userid='618755') |
| 1.5 ms | system.db.CDbCommand.query | system.db.CDbCommand.query(SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`=618755 LIMIT 1) |
| 4.9 ms | system.db.CDbCommand.query | system.db.CDbCommand.query(SELECT LCASE(itemname) as itemname, ai.type, ai.name FROM authassignment t1 LEFT JOIN authitem ai ON ai.name = t1.itemname where userid = 618755) |
| 11.8 ms | system.db.CDbCommand.query | system.db.CDbCommand.query(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) |
| 67.1 ms | system.db.CDbCommand.query | system.db.CDbCommand.query(SELECT * FROM `user_agents` `t` WHERE `t`.`user_agent`=:yp0 LIMIT 1. Bound with :yp0='python-httpx/0.28.1') |
| 3.1 ms | system.db.CDbCommand.execute | system.db.CDbCommand.execute(INSERT INTO `action_log` (`staff_id`, `user_id`, `action`, `action_type`, `ip_address`, `agent_id`, `time`, `date`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7). Bound with :yp0=618755, :yp1=618755, :yp2='Logged in using login token: [klk3vvdm070hqaifmv86o963cd | lffc6oa17c1nmgpsp1485uek3j]', :yp3=10, :yp4='12.30.39.214', :yp5='344428', :yp6='15:55:29', :yp7='2025-04-21') |
| 1.5 ms | system.db.CDbCommand.query | system.db.CDbCommand.query(SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`=618755 LIMIT 1) |
| 1.7 ms | system.db.CDbCommand.query | system.db.CDbCommand.query(SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`=618755 LIMIT 1) |
| 2.4 ms | system.db.CDbCommand.query | system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `tickets`) |
| 1.2 ms | system.db.CDbCommand.query | system.db.CDbCommand.query(SHOW CREATE TABLE `tickets`) |
| 1.3 ms | system.db.CDbCommand.query | system.db.CDbCommand.query(SELECT * FROM `tickets` `t` WHERE ((ticket_type=:ycp0) AND (status=:ycp1)) AND (agent_id=:ycp2). Bound with :ycp0='Email', :ycp1='1', :ycp2='618755') |
| 2.3 ms | system.db.CDbCommand.query | system.db.CDbCommand.query(SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`=:yp0 LIMIT 1. Bound with :yp0='420935') |
| 1.7 ms | system.db.CDbCommand.query | system.db.CDbCommand.query(SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`=:yp0 LIMIT 1. Bound with :yp0='611354') |
| 1.5 ms | system.db.CDbCommand.query | system.db.CDbCommand.query(SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`=:yp0 LIMIT 1. Bound with :yp0='254216') |
| 3.1 ms | system.db.CDbCommand.execute | system.db.CDbCommand.execute( INSERT IGNORE INTO stats_page_requested (url, memory_used, loading_time, ip, user_id, request_body, query_string, cookies) VALUES (:url, :memory_used, :loading_time, :ip, :user_id, :body, :query_string, :cookies); . Bound with :url='mcpRest/tickets', :loading_time=0.401, :memory_used=4.46, :ip='12.30.39.214', :user_id='618755', :body='', :query_string='', :cookies='s:0:"";') |
| 9.1 ms | system.db.CDbCommand.execute | system.db.CDbCommand.execute(UPDATE user_session SET user_id = :user_id WHERE id = :session_id AND user_id IS NULL. Bound with :user_id='618755', :session_id='lffc6oa17c1nmgpsp1485uek3j') |