Yii Debugger
1.1.25
PHP 8.0.30
Status 200
Action McpRestController::actionTickets()
Log 84
Time 278 ms
Memory 5.7 MB
DB 45 224 ms
All Latest
GET http://chinchilldev.lufa.com/en/mcpRest/tickets?limit=1 at 2025-04-28 11:09:30 by 172.19.0.1
Time Level Category Message
11:09:30.480 trace system.CModule
Loading "log" application component
  • index.php (19)
11:09:30.480 trace system.CModule
Loading "debug" application component
  • index.php (19)
11:09:30.480 trace system.CModule
Loading "request" application component
  • protected/vendor/sbs/yii-debug-toolbar/Yii2Debug.php (284)
  • protected/vendor/sbs/yii-debug-toolbar/Yii2Debug.php (99)
  • index.php (19)
11:09:30.481 trace system.CModule
Loading "urlManager" application component
  • protected/vendor/sbs/yii-debug-toolbar/Yii2Debug.php (138)
  • index.php (19)
11:09:30.481 trace system.CModule
Loading "cache" application component
  • protected/extensions/localeurls/LocaleUrlManager.php (46)
  • protected/vendor/sbs/yii-debug-toolbar/Yii2Debug.php (138)
  • index.php (19)
11:09:30.481 trace system.caching.CApcCache
Serving "Yii.CUrlManager.rules" from cache
  • protected/extensions/localeurls/LocaleUrlManager.php (46)
  • protected/vendor/sbs/yii-debug-toolbar/Yii2Debug.php (138)
  • index.php (19)
11:09:30.482 trace system.CModule
Loading "clientScript" application component
  • protected/vendor/sbs/yii-debug-toolbar/Yii2Debug.php (203)
  • protected/vendor/sbs/yii-debug-toolbar/Yii2Debug.php (147)
  • index.php (19)
11:09:30.482 trace system.db.ar.CActiveRecord
MarketingCustomUrl.findByAttributes()
  • protected/components/ApplicationConfigBehavior.php (206)
  • protected/components/ApplicationConfigBehavior.php (31)
  • index.php (21)
11:09:30.482 trace system.CModule
Loading "db" application component
  • protected/components/ApplicationConfigBehavior.php (206)
  • protected/components/ApplicationConfigBehavior.php (31)
  • index.php (21)
11:09:30.482 trace system.db.CDbConnection
Opening DB connection
  • protected/components/ApplicationConfigBehavior.php (206)
  • protected/components/ApplicationConfigBehavior.php (31)
  • index.php (21)
11:09:30.492 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `marketing_custom_urls`
  • protected/components/ApplicationConfigBehavior.php (206)
  • protected/components/ApplicationConfigBehavior.php (31)
  • index.php (21)
11:09:30.494 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `marketing_custom_urls`
  • protected/components/ApplicationConfigBehavior.php (206)
  • protected/components/ApplicationConfigBehavior.php (31)
  • index.php (21)
11:09:30.495 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `marketing_campaign_referrals`
  • protected/components/ApplicationConfigBehavior.php (206)
  • protected/components/ApplicationConfigBehavior.php (31)
  • index.php (21)
11:09:30.497 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `marketing_campaign_referrals`
  • protected/components/ApplicationConfigBehavior.php (206)
  • protected/components/ApplicationConfigBehavior.php (31)
  • index.php (21)
11:09:30.498 trace system.db.CDbCommand
Querying SQL: 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'
  • protected/components/ApplicationConfigBehavior.php (206)
  • protected/components/ApplicationConfigBehavior.php (31)
  • index.php (21)
11:09:30.501 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `securelufacom`.`users`
  • protected/models/behaviors/MultilingualBehavior.php (618)
  • protected/models/behaviors/MultilingualBehavior.php (323)
  • protected/models/Users.php (128)
11:09:30.505 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `securelufacom`.`users`
  • protected/models/behaviors/MultilingualBehavior.php (618)
  • protected/models/behaviors/MultilingualBehavior.php (323)
  • protected/models/Users.php (128)
11:09:30.507 trace system.CModule
Loading "messages" application component
  • protected/models/Users.php (207)
  • protected/models/behaviors/MultilingualBehavior.php (326)
  • protected/models/Users.php (128)
11:09:30.508 trace system.db.ar.CActiveRecord
Users.findByPk()
  • protected/components/ApplicationConfigBehavior.php (297)
  • protected/components/ApplicationConfigBehavior.php (33)
  • index.php (21)
11:09:30.508 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`=618755 LIMIT 1
  • protected/components/ApplicationConfigBehavior.php (297)
  • protected/components/ApplicationConfigBehavior.php (33)
  • index.php (21)
11:09:30.511 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `action_log`
  • protected/models/ActionLog.php (488)
  • protected/components/ApplicationConfigBehavior.php (302)
  • protected/components/ApplicationConfigBehavior.php (33)
11:09:30.512 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `action_log`
  • protected/models/ActionLog.php (488)
  • protected/components/ApplicationConfigBehavior.php (302)
  • protected/components/ApplicationConfigBehavior.php (33)
11:09:30.513 trace system.CModule
Loading "user" application component
  • protected/models/ActionLog.php (489)
  • protected/components/ApplicationConfigBehavior.php (302)
  • protected/components/ApplicationConfigBehavior.php (33)
11:09:30.513 trace system.CModule
Loading "session" application component
  • protected/modules/rights/components/RWebUser.php (17)
  • protected/models/ActionLog.php (489)
  • protected/components/ApplicationConfigBehavior.php (302)
11:09:30.514 trace system.db.CDbCommand
Querying SQL: SELECT `data`
FROM `user_session`
WHERE expire>:expire AND id=:id. Bound with :expire=1745852970, :id='679bo44qrbede7iu1ltmpa8cb4'
  • protected/components/LCDbHttpSession.php (12)
  • protected/modules/rights/components/RWebUser.php (17)
  • protected/models/ActionLog.php (489)
11:09:30.516 trace system.db.ar.CActiveRecord
UserAgents.findByAttributes()
  • protected/models/ActionLog.php (282)
  • protected/models/ActionLog.php (494)
  • protected/components/ApplicationConfigBehavior.php (302)
11:09:30.516 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `user_agents`
  • protected/models/ActionLog.php (282)
  • protected/models/ActionLog.php (494)
  • protected/components/ApplicationConfigBehavior.php (302)
11:09:30.518 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `user_agents`
  • protected/models/ActionLog.php (282)
  • protected/models/ActionLog.php (494)
  • protected/components/ApplicationConfigBehavior.php (302)
11:09:30.519 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `user_agents` `t` WHERE `t`.`user_agent`=:yp0 LIMIT 1. Bound with :yp0='GoogleStackdriverMonitoring-UptimeChecks(https://cloud.google.com/monitoring)'
  • protected/models/ActionLog.php (282)
  • protected/models/ActionLog.php (494)
  • protected/components/ApplicationConfigBehavior.php (302)
11:09:30.585 trace system.db.ar.CActiveRecord
ActionLog.insert()
  • protected/models/ActionLog.php (494)
  • protected/components/ApplicationConfigBehavior.php (302)
  • protected/components/ApplicationConfigBehavior.php (33)
11:09:30.585 trace system.db.CDbCommand
Executing SQL: 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='35.224.249.156', :yp5='345049', :yp6='11:09:30', :yp7='2025-04-28'
  • protected/models/ActionLog.php (494)
  • protected/components/ApplicationConfigBehavior.php (302)
  • protected/components/ApplicationConfigBehavior.php (33)
11:09:30.588 trace system.db.ar.CActiveRecord
Users.findByAttributes()
  • protected/components/UserIdentity.php (26)
  • protected/models/Users.php (3939)
  • protected/components/ApplicationConfigBehavior.php (35)
11:09:30.588 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_email`=:yp0 LIMIT 1. Bound with :yp0='p.liang@lufa.com'
  • protected/components/UserIdentity.php (26)
  • protected/models/Users.php (3939)
  • protected/components/ApplicationConfigBehavior.php (35)
11:09:30.591 trace system.db.ar.CActiveRecord
Users.findByAttributes()
  • protected/models/Users.php (925)
  • protected/components/UserIdentity.php (113)
  • protected/models/Users.php (3939)
11:09:30.591 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`=:yp0 LIMIT 1. Bound with :yp0='618755'
  • protected/models/Users.php (925)
  • protected/components/UserIdentity.php (113)
  • protected/models/Users.php (3939)
11:09:30.601 trace system.db.ar.CActiveRecord
Users.update()
  • protected/components/UserIdentity.php (113)
  • protected/models/Users.php (3939)
  • protected/components/ApplicationConfigBehavior.php (35)
11:09:30.601 trace system.db.ar.CActiveRecord
Users.updateByPk()
  • protected/components/UserIdentity.php (113)
  • protected/models/Users.php (3939)
  • protected/components/ApplicationConfigBehavior.php (35)
11:09:30.601 trace system.db.CDbCommand
Executing SQL: 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-28 11:09:30', :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
  • protected/components/UserIdentity.php (113)
  • protected/models/Users.php (3939)
  • protected/components/ApplicationConfigBehavior.php (35)
11:09:30.605 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `active_record_logs`
  • protected/components/ActiveRecordLogableBehavior.php (116)
  • protected/components/ActiveRecordLogableBehavior.php (10)
  • protected/models/Users.php (954)
11:09:30.607 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `active_record_logs`
  • protected/components/ActiveRecordLogableBehavior.php (116)
  • protected/components/ActiveRecordLogableBehavior.php (10)
  • protected/models/Users.php (954)
11:09:30.609 trace system.db.ar.CActiveRecord
ActiveRecordLogs.insert()
  • protected/components/ActiveRecordLogableBehavior.php (147)
  • protected/components/ActiveRecordLogableBehavior.php (10)
  • protected/models/Users.php (954)
11:09:30.609 trace system.db.CDbCommand
Executing SQL: 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-28 11:08:46', :yp6='2025-04-28 11:09:30', :yp7=2, :yp8='Users', :yp9='618755'
  • protected/components/ActiveRecordLogableBehavior.php (147)
  • protected/components/ActiveRecordLogableBehavior.php (10)
  • protected/models/Users.php (954)
11:09:30.611 trace system.db.ar.CActiveRecord
UsersLang.findAll()
  • protected/models/behaviors/MultilingualBehavior.php (559)
  • protected/models/Users.php (954)
  • protected/components/UserIdentity.php (113)
11:09:30.611 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `usersLang`
  • protected/models/behaviors/MultilingualBehavior.php (559)
  • protected/models/Users.php (954)
  • protected/components/UserIdentity.php (113)
11:09:30.613 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `usersLang`
  • protected/models/behaviors/MultilingualBehavior.php (559)
  • protected/models/Users.php (954)
  • protected/components/UserIdentity.php (113)
11:09:30.614 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `usersLang` `t` WHERE user_id=:id. Bound with :id='618755'
  • protected/models/behaviors/MultilingualBehavior.php (559)
  • protected/models/Users.php (954)
  • protected/components/UserIdentity.php (113)
11:09:30.615 trace system.db.ar.CActiveRecord
UsersLang.update()
  • protected/models/behaviors/MultilingualBehavior.php (584)
  • protected/models/Users.php (954)
  • protected/components/UserIdentity.php (113)
11:09:30.615 trace system.db.ar.CActiveRecord
UsersLang.updateByPk()
  • protected/models/behaviors/MultilingualBehavior.php (584)
  • protected/models/Users.php (954)
  • protected/components/UserIdentity.php (113)
11:09:30.615 trace system.db.CDbCommand
Executing SQL: 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
  • protected/models/behaviors/MultilingualBehavior.php (584)
  • protected/models/Users.php (954)
  • protected/components/UserIdentity.php (113)
11:09:30.617 trace system.CModule
Loading "localtime" application component
  • protected/components/UserIdentity.php (124)
  • protected/models/Users.php (3939)
  • protected/components/ApplicationConfigBehavior.php (35)
11:09:30.617 trace system.CModule
Loading "statePersister" application component
  • protected/components/LocalTime.php (38)
  • protected/components/UserIdentity.php (124)
  • protected/models/Users.php (3939)
11:09:30.618 trace system.caching.CApcCache
Serving "Yii.CStatePersister./var/www/protected/runtime/state.bin" from cache
  • protected/components/LocalTime.php (38)
  • protected/components/UserIdentity.php (124)
  • protected/models/Users.php (3939)
11:09:30.618 trace system.db.CDbCommand
Executing SQL: DELETE FROM `user_session` WHERE id=:id. Bound with :id='679bo44qrbede7iu1ltmpa8cb4'
  • protected/modules/rights/components/RWebUser.php (550)
  • protected/models/Users.php (3946)
  • protected/components/ApplicationConfigBehavior.php (35)
11:09:30.619 trace system.db.CDbCommand
Querying SQL: SELECT `data`
FROM `user_session`
WHERE expire>:expire AND id=:id. Bound with :expire=1745852970, :id='cr3s4be0rr352hm97hkn0sle6u'
  • protected/modules/rights/components/RWebUser.php (550)
  • protected/models/Users.php (3946)
  • protected/components/ApplicationConfigBehavior.php (35)
11:09:30.622 trace system.db.CDbCommand
Querying SQL: SELECT `id`
FROM `user_session`
WHERE id=:id. Bound with :id='cr3s4be0rr352hm97hkn0sle6u'
  • protected/modules/rights/components/RWebUser.php (551)
  • protected/models/Users.php (3946)
  • protected/components/ApplicationConfigBehavior.php (35)
11:09:30.623 trace system.db.CDbCommand
Executing SQL: INSERT INTO `user_session` (`id`, `data`, `expire`) VALUES (:id, :data, :expire). Bound with :id='cr3s4be0rr352hm97hkn0sle6u', :data='', :expire=1759072170
  • protected/modules/rights/components/RWebUser.php (551)
  • protected/models/Users.php (3946)
  • protected/components/ApplicationConfigBehavior.php (35)
11:09:30.628 trace system.db.CDbCommand
Querying SQL: SELECT `data`
FROM `user_session`
WHERE expire>:expire AND id=:id. Bound with :expire=1745852970, :id='0cfnco73fk8ltdeadqdr568m60'
  • protected/modules/rights/components/RWebUser.php (551)
  • protected/models/Users.php (3946)
  • protected/components/ApplicationConfigBehavior.php (35)
11:09:30.631 trace system.db.CDbCommand
Querying SQL: SELECT *
FROM `user_session`
WHERE id=:id. Bound with :id='cr3s4be0rr352hm97hkn0sle6u'
  • protected/modules/rights/components/RWebUser.php (551)
  • protected/models/Users.php (3946)
  • protected/components/ApplicationConfigBehavior.php (35)
11:09:30.632 trace system.db.CDbCommand
Executing SQL: UPDATE `user_session` SET `id`=:id WHERE id=:oldID. Bound with :oldID='cr3s4be0rr352hm97hkn0sle6u', :id='0cfnco73fk8ltdeadqdr568m60'
  • protected/modules/rights/components/RWebUser.php (551)
  • protected/models/Users.php (3946)
  • protected/components/ApplicationConfigBehavior.php (35)
11:09:30.634 trace system.base.CModule
Loading "rights" module
  • protected/modules/rights/components/Rights.php (339)
  • protected/modules/rights/components/Rights.php (261)
  • protected/modules/rights/components/Rights.php (273)
11:09:30.634 trace system.CModule
Loading "authorizer" application component
  • protected/modules/rights/RightsModule.php (193)
  • protected/modules/rights/components/Rights.php (273)
  • protected/modules/rights/components/RWebUser.php (51)
11:09:30.634 trace system.CModule
Loading "authManager" application component
  • protected/modules/rights/components/RAuthorizer.php (29)
  • protected/modules/rights/RightsModule.php (193)
  • protected/modules/rights/components/Rights.php (273)
11:09:30.635 trace system.db.CDbCommand
Querying SQL: SELECT *
FROM `authassignment`
WHERE userid=:userid. Bound with :userid='618755'
  • protected/modules/rights/components/RAuthorizer.php (292)
  • protected/modules/rights/components/RWebUser.php (51)
  • protected/models/Users.php (3946)
11:09:30.643 trace system.CModule
Loading "redis" application component
  • protected/modules/rights/components/RWebUser.php (55)
  • protected/models/Users.php (3946)
  • protected/components/ApplicationConfigBehavior.php (35)
11:09:30.644 trace system.db.ar.CActiveRecord
Users.findByPk()
  • protected/modules/rights/components/RWebUser.php (558)
  • protected/modules/rights/components/RWebUser.php (55)
  • protected/models/Users.php (3946)
11:09:30.644 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`=618755 LIMIT 1
  • protected/modules/rights/components/RWebUser.php (558)
  • protected/modules/rights/components/RWebUser.php (55)
  • protected/models/Users.php (3946)
11:09:30.648 trace system.db.CDbCommand
Querying SQL: SELECT LCASE(itemname) as itemname, ai.type, ai.name
FROM authassignment t1
LEFT JOIN authitem ai ON ai.name = t1.itemname
where userid = 618755
  • protected/modules/rights/components/RDbAuthManager.php (186)
  • protected/modules/rights/components/RAuthorizer.php (114)
  • protected/modules/rights/components/Rights.php (78)
11:09:30.653 trace system.db.CDbCommand
Querying SQL: 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
  • protected/modules/rights/components/RDbAuthManager.php (205)
  • protected/modules/rights/components/RAuthorizer.php (114)
  • protected/modules/rights/components/Rights.php (78)
11:09:30.669 trace system.db.ar.CActiveRecord
UserAgents.findByAttributes()
  • protected/models/ActionLog.php (282)
  • protected/models/ActionLog.php (494)
  • protected/models/Users.php (3951)
11:09:30.669 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `user_agents` `t` WHERE `t`.`user_agent`=:yp0 LIMIT 1. Bound with :yp0='GoogleStackdriverMonitoring-UptimeChecks(https://cloud.google.com/monitoring)'
  • protected/models/ActionLog.php (282)
  • protected/models/ActionLog.php (494)
  • protected/models/Users.php (3951)
11:09:30.732 trace system.db.ar.CActiveRecord
ActionLog.insert()
  • protected/models/ActionLog.php (494)
  • protected/models/Users.php (3951)
  • protected/components/ApplicationConfigBehavior.php (35)
11:09:30.732 trace system.db.CDbCommand
Executing SQL: 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: [679bo44qrbede7iu1ltmpa8cb4 | 0cfnco73fk8ltdeadqdr568m60]', :yp3=10, :yp4='35.224.249.156', :yp5='345049', :yp6='11:09:30', :yp7='2025-04-28'
  • protected/models/ActionLog.php (494)
  • protected/models/Users.php (3951)
  • protected/components/ApplicationConfigBehavior.php (35)
11:09:30.736 trace system.db.ar.CActiveRecord
Users.findByPk()
  • protected/components/ApplicationConfigBehavior.php (45)
  • index.php (21)
11:09:30.736 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`=618755 LIMIT 1
  • protected/components/ApplicationConfigBehavior.php (45)
  • index.php (21)
11:09:30.739 trace ext.localeurls
Detected language 'en'
  • protected/extensions/localeurls/LocaleHttpRequest.php (105)
  • index.php (21)
11:09:30.740 trace system.db.ar.CActiveRecord
Users.findByPk()
  • protected/controllers/McpRestController.php (167)
  • index.php (21)
11:09:30.740 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id`=618755 LIMIT 1
  • protected/controllers/McpRestController.php (167)
  • index.php (21)
11:09:30.743 trace system.db.ar.CActiveRecord
Tickets.findAll()
  • protected/controllers/McpRestController.php (181)
  • index.php (21)
11:09:30.743 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `tickets`
  • protected/controllers/McpRestController.php (181)
  • index.php (21)
11:09:30.746 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `tickets`
  • protected/controllers/McpRestController.php (181)
  • index.php (21)
11:09:30.747 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `tickets` `t` WHERE ((ticket_type=:ycp0) AND (status=:ycp1)) AND (agent_id=:ycp2). Bound with :ycp0='IQARefundRequest', :ycp1='1', :ycp2='618755'
  • protected/controllers/McpRestController.php (181)
  • index.php (21)
11:09:30.748 trace system.db.CDbCommand
Executing SQL:
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.269, :memory_used=4.05, :ip='35.224.249.156', :user_id='618755', :body='', :query_string='', :cookies='s:0:"";'
  • protected/components/ApplicationConfigBehavior.php (193)
  • protected/components/ApplicationConfigBehavior.php (99)
  • protected/controllers/McpRestController.php (632)
11:09:30.750 trace system.db.CDbCommand
Executing SQL: UPDATE user_session SET user_id = :user_id WHERE id = :session_id AND user_id IS NULL. Bound with :user_id='618755', :session_id='0cfnco73fk8ltdeadqdr568m60'
  • protected/components/ApplicationConfigBehavior.php (143)
  • protected/components/ApplicationConfigBehavior.php (114)
  • protected/controllers/McpRestController.php (632)
11:09:30.755 trace application
UPDATED 1 rows for user_id: 618755 and session_id: 0cfnco73fk8ltdeadqdr568m60
  • protected/components/ApplicationConfigBehavior.php (144)
  • protected/components/ApplicationConfigBehavior.php (114)
  • protected/controllers/McpRestController.php (632)