Yii Debugger
1.1.25
PHP 8.0.30
Status 200
Action SuperMarketController::actionGetNoteboxData()
Log 28
Time 53 ms
Memory 2.4 MB
DB 11 16 ms
All Latest
POST http://chinchilldev.lufa.com/en/superMarket/getNoteboxData (AJAX) at 2025-04-14 11:22:53 by 172.19.0.1
Time Level Category Message
11:22:53.373 trace system.CModule
Loading "log" application component
  • index.php (19)
11:22:53.373 trace system.CModule
Loading "debug" application component
  • index.php (19)
11:22:53.373 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:22:53.374 trace system.CModule
Loading "urlManager" application component
  • protected/vendor/sbs/yii-debug-toolbar/Yii2Debug.php (138)
  • index.php (19)
11:22:53.374 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:22:53.375 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:22:53.375 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:22:53.376 trace system.db.ar.CActiveRecord
MarketingCustomUrl.findByAttributes()
  • protected/components/ApplicationConfigBehavior.php (206)
  • protected/components/ApplicationConfigBehavior.php (31)
  • index.php (21)
11:22:53.376 trace system.CModule
Loading "db" application component
  • protected/components/ApplicationConfigBehavior.php (206)
  • protected/components/ApplicationConfigBehavior.php (31)
  • index.php (21)
11:22:53.376 trace system.db.CDbConnection
Opening DB connection
  • protected/components/ApplicationConfigBehavior.php (206)
  • protected/components/ApplicationConfigBehavior.php (31)
  • index.php (21)
11:22:53.384 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:22:53.386 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:22:53.387 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:22:53.389 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:22:53.390 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='getnoteboxdata'
  • protected/components/ApplicationConfigBehavior.php (206)
  • protected/components/ApplicationConfigBehavior.php (31)
  • index.php (21)
11:22:53.391 trace ext.localeurls
Detected language 'en'
  • protected/extensions/localeurls/LocaleHttpRequest.php (105)
  • index.php (21)
11:22:53.391 trace system.CModule
Loading "user" application component
  • protected/extensions/localeurls/LocaleHttpRequest.php (108)
  • index.php (21)
11:22:53.391 trace system.CModule
Loading "session" application component
  • protected/modules/rights/components/RWebUser.php (17)
  • protected/extensions/localeurls/LocaleHttpRequest.php (108)
  • index.php (21)
11:22:53.391 trace system.db.CDbCommand
Querying SQL: SELECT `data`
FROM `user_session`
WHERE expire>:expire AND id=:id. Bound with :expire=1744644173, :id='0vkehj0p0amrttgfmd53jr9j0h'
  • protected/components/LCDbHttpSession.php (12)
  • protected/modules/rights/components/RWebUser.php (17)
  • protected/extensions/localeurls/LocaleHttpRequest.php (108)
11:22:53.393 trace system.CModule
Loading "messages" application component
  • protected/components/BlogUrlRule.php (62)
  • index.php (21)
11:22:53.395 trace system.CModule
Loading "redis" application component
  • protected/models/MarketplacesCapacity.php (49)
  • protected/models/UserNotificationMessageQueue.php (145)
  • protected/models/UserNotificationMessageQueue.php (105)
11:22:53.397 trace system.db.CDbCommand
Querying SQL: SELECT
q.user_notification_message_queue_id, q.session_clicks,
n.notification_messages_id, n.start_date, n.end_date, n.created_at, n.status,
IF (:lang = "fr", n.desktop_collapsed_message, n_l.l_desktop_collapsed_message) as desktop_collapsed_message,
IF (:lang = "fr", n.mobile_collapsed_message, n_l.l_mobile_collapsed_message) as mobile_collapsed_message,
IF (:lang = "fr", n.title, n_l.l_title) as title,
IF (:lang = "fr", n.content, n_l.content) as content,
CONCAT("/images/notificationMessages/", n.icon) as icon,
:lang as lang,
0 as :session_id
FROM user_notification_message_queue q
INNER JOIN notification_messages n ON n.notification_messages_id = q.notification_messages_id
INNER JOIN notification_messages_lang n_l ON n_l.notification_messages_id = n.notification_messages_id
WHERE q.user_id = :user_id
AND n.status = :STATUS_LIVE
AND q.session_clicks < 2. Bound with :user_id=NULL, :STATUS_LIVE=2, :lang='en', :session_id='0vkehj0p0amrttgfmd53jr9j0h'
  • protected/models/UserNotificationMessageQueue.php (227)
  • protected/models/UserNotificationMessageQueue.php (120)
  • protected/components/Controller.php (137)
11:22:53.398 trace system.web.filters.CFilterChain
Running filter SuperMarketController.filterHttpsOnly()
  • index.php (21)
11:22:53.402 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:22:53.407 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:22:53.410 trace system.db.ar.CActiveRecord
Users.findByPk()
  • protected/modules/rights/components/RWebUser.php (558)
  • protected/modules/rights/components/RWebUser.php (471)
  • protected/controllers/SuperMarketController.php (1183)
11:22:53.410 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id` IS NULL LIMIT 1
  • protected/modules/rights/components/RWebUser.php (558)
  • protected/modules/rights/components/RWebUser.php (471)
  • protected/controllers/SuperMarketController.php (1183)
11:22:53.421 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='superMarket/getNoteboxData', :loading_time=0.049, :memory_used=2.34, :ip='66.249.64.173', :user_id=NULL, :body='', :query_string='', :cookies='s:0:"";'
  • protected/components/ApplicationConfigBehavior.php (193)
  • protected/components/ApplicationConfigBehavior.php (99)