Yii Debugger
1.1.25
PHP 8.0.30
Status 404
Action
Log 46 1
Time 87 ms
Memory 2.7 MB
DB 19 32 ms
All Latest
GET http://chinchilldev.lufa.com/en/"https:////montreal.lufa.com//en//marketplace at 2025-04-15 11:56:31 by 172.19.0.1
Time Duration Query
11:56:31.729 1.8 ms
SHOW FULL COLUMNS FROM `marketing_custom_urls`
11:56:31.731 1.0 ms
SHOW CREATE TABLE `marketing_custom_urls`
11:56:31.732 2.2 ms
SHOW FULL COLUMNS FROM `marketing_campaign_referrals`
11:56:31.735 1.0 ms
SHOW CREATE TABLE `marketing_campaign_referrals`
11:56:31.736 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`='marketplace')
Explain
11:56:31.738 2.1 ms
SELECT `data` FROM `user_session` WHERE expire>1744732591 AND id='pgd7ts63e7btnm8agbv34j4ef7'
Explain
11:56:31.759 1.3 ms
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 ('en' = "fr", n.desktop_collapsed_message, n_l.l_desktop_collapsed_message) as desktop_collapsed_message, IF ('en' = "fr", n.mobile_collapsed_message, n_l.l_mobile_collapsed_message) as mobile_collapsed_message, IF ('en' = "fr", n.title, n_l.l_title) as title, IF ('en' = "fr", n.content, n_l.content) as content, CONCAT("/images/notificationMessages/", n.icon) as icon, 'en' as lang, 0 as 'pgd7ts63e7btnm8agbv34j4ef7' 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 = NULL AND n.status = 2 AND q.session_clicks < 2
Explain
11:56:31.765 4.5 ms
SHOW FULL COLUMNS FROM `securelufacom`.`users`
11:56:31.770 1.7 ms
SHOW CREATE TABLE `securelufacom`.`users`
11:56:31.774 1.4 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id` IS NULL LIMIT 1
Explain
11:56:31.777 1.3 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id` IS NULL LIMIT 1
Explain
11:56:31.778 1.1 ms
SELECT child FROM authitemchild WHERE parent = 'default_guest'
Explain
11:56:31.780 1.1 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id` IS NULL LIMIT 1
Explain
11:56:31.783 1.3 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id` IS NULL LIMIT 1
Explain
11:56:31.786 1.2 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id` IS NULL LIMIT 1
Explain
11:56:31.790 3.2 ms
INSERT IGNORE INTO stats_page_requested (url, memory_used, loading_time, ip, user_id, request_body, query_string, cookies) VALUES ('"https:////montreal.lufa.com//en//marketplace', 2.56, 0.076, '66.249.64.173', NULL, '', '', 's:0:"";');
11:56:31.793 2.0 ms
SHOW FULL COLUMNS FROM `application_error_logs`
11:56:31.795 1.0 ms
SHOW CREATE TABLE `application_error_logs`
11:56:31.797 2.7 ms
INSERT INTO `application_error_logs` (`level`, `category`, `created`, `ip_address`, `user_id`, `request_URL`, `message`, `host`) VALUES ('error', 'exception.CHttpException.404', '2025-04-15 11:56:31', '66.249.64.173', '2', '/en/%22https:////montreal.lufa.com//en//marketplace', 'CHttpException: Unable to resolve the request ""https:////montreal.lufa.com//en//marketplace". in /var/www/protected/vendor/yiisoft/yii/framework/web/CWebApplication.php:286 Stack trace: #0 /var/www/protected/vendor/yiisoft/yii/framework/web/CWebApplication.php(141): CWebApplication->runController() #1 /var/www/protected/vendor/yiisoft/yii/framework/base/CApplication.php(185): CWebApplication->processRequest() #2 /var/www/index.php(21): CApplication->run() #3 {main} REQUEST_URI=/en/%22https:////montreal.lufa.com//en//marketplace ---', '0d0c8ed51942')
# Query Count Total Avg Min Max
1
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id` IS NULL LIMIT 1
 5 6.2 ms 1.2 ms 1.1 ms 1.4 ms
2
SHOW FULL COLUMNS FROM `securelufacom`.`users`
 1 4.5 ms 4.5 ms 4.5 ms 4.5 ms
3
INSERT IGNORE INTO stats_page_requested (url, memory_used, loading_time, ip, user_id, request_body, query_string, cookies) VALUES ('"https:////montreal.lufa.com//en//marketplace', 2.56, 0.076, '66.249.64.173', NULL, '', '', 's:0:"";');
 1 3.2 ms 3.2 ms 3.2 ms 3.2 ms
4
INSERT INTO `application_error_logs` (`level`, `category`, `created`, `ip_address`, `user_id`, `request_URL`, `message`, `host`) VALUES ('error', 'exception.CHttpException.404', '2025-04-15 11:56:31', '66.249.64.173', '2', '/en/%22https:////montreal.lufa.com//en//marketplace', 'CHttpException: Unable to resolve the request ""https:////montreal.lufa.com//en//marketplace". in /var/www/protected/vendor/yiisoft/yii/framework/web/CWebApplication.php:286 Stack trace: #0 /var/www/protected/vendor/yiisoft/yii/framework/web/CWebApplication.php(141): CWebApplication->runController() #1 /var/www/protected/vendor/yiisoft/yii/framework/base/CApplication.php(185): CWebApplication->processRequest() #2 /var/www/index.php(21): CApplication->run() #3 {main} REQUEST_URI=/en/%22https:////montreal.lufa.com//en//marketplace ---', '0d0c8ed51942')
 1 2.7 ms 2.7 ms 2.7 ms 2.7 ms
5
SHOW FULL COLUMNS FROM `marketing_campaign_referrals`
 1 2.2 ms 2.2 ms 2.2 ms 2.2 ms
6
SELECT `data` FROM `user_session` WHERE expire>1744732591 AND id='pgd7ts63e7btnm8agbv34j4ef7'
 1 2.1 ms 2.1 ms 2.1 ms 2.1 ms
7
SHOW FULL COLUMNS FROM `application_error_logs`
 1 2.0 ms 2.0 ms 2.0 ms 2.0 ms
8
SHOW FULL COLUMNS FROM `marketing_custom_urls`
 1 1.8 ms 1.8 ms 1.8 ms 1.8 ms
9
SHOW CREATE TABLE `securelufacom`.`users`
 1 1.7 ms 1.7 ms 1.7 ms 1.7 ms
10
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 ('en' = "fr", n.desktop_collapsed_message, n_l.l_desktop_collapsed_message) as desktop_collapsed_message, IF ('en' = "fr", n.mobile_collapsed_message, n_l.l_mobile_collapsed_message) as mobile_collapsed_message, IF ('en' = "fr", n.title, n_l.l_title) as title, IF ('en' = "fr", n.content, n_l.content) as content, CONCAT("/images/notificationMessages/", n.icon) as icon, 'en' as lang, 0 as 'pgd7ts63e7btnm8agbv34j4ef7' 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 = NULL AND n.status = 2 AND q.session_clicks < 2
 1 1.3 ms 1.3 ms 1.3 ms 1.3 ms
11
SELECT child FROM authitemchild WHERE parent = 'default_guest'
 1 1.1 ms 1.1 ms 1.1 ms 1.1 ms
12
SHOW CREATE TABLE `marketing_custom_urls`
 1 1.0 ms 1.0 ms 1.0 ms 1.0 ms
13
SHOW CREATE TABLE `application_error_logs`
 1 1.0 ms 1.0 ms 1.0 ms 1.0 ms
14
SHOW CREATE TABLE `marketing_campaign_referrals`
 1 1.0 ms 1.0 ms 1.0 ms 1.0 ms
15
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`='marketplace')
 1 0.8 ms 0.8 ms 0.8 ms 0.8 ms

Component: db (CDbConnection)

Name Value
driver
mysql
server
8.0.29-21
Uptime
591014
Threads
2
Questions
458246
Slow queries
62
Opens
4173
Flush tables
3
Open tables
2048
Queries per second avg
0.775