Yii Debugger
1.1.25
PHP 8.0.30
Status 404
Action
Log 46 1
Time 81 ms
Memory 2.7 MB
DB 19 27 ms
All Latest
GET http://chinchilldev.lufa.com/en/"https:////montreal.lufa.com//fr//marche//categorie//pret-a-cuisiner//menu-des-fetes/" at 2025-04-17 03:19:49 by 172.19.0.1
Time Duration Query
15:19:49.412 1.7 ms
SHOW FULL COLUMNS FROM `marketing_custom_urls`
15:19:49.414 1.2 ms
SHOW CREATE TABLE `marketing_custom_urls`
15:19:49.416 1.5 ms
SHOW FULL COLUMNS FROM `marketing_campaign_referrals`
15:19:49.418 0.9 ms
SHOW CREATE TABLE `marketing_campaign_referrals`
15:19:49.419 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`='%22')
Explain
15:19:49.420 2.2 ms
SELECT `data` FROM `user_session` WHERE expire>1744917589 AND id='83aithqpglbdfldo0sp1fed8te'
Explain
15:19:49.449 1.4 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 '83aithqpglbdfldo0sp1fed8te' 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
15:19:49.453 3.2 ms
SHOW FULL COLUMNS FROM `securelufacom`.`users`
15:19:49.458 1.3 ms
SHOW CREATE TABLE `securelufacom`.`users`
15:19:49.461 1.1 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id` IS NULL LIMIT 1
Explain
15:19:49.462 1.0 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id` IS NULL LIMIT 1
Explain
15:19:49.463 0.9 ms
SELECT child FROM authitemchild WHERE parent = 'default_guest'
Explain
15:19:49.465 1.1 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id` IS NULL LIMIT 1
Explain
15:19:49.468 1.1 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id` IS NULL LIMIT 1
Explain
15:19:49.470 0.9 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id` IS NULL LIMIT 1
Explain
15:19:49.473 2.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//fr//marche//categorie//pret-a-cuisiner//menu-des-fetes/"', 2.56, 0.072, '66.249.66.163', NULL, '', '', 's:0:"";');
15:19:49.476 1.5 ms
SHOW FULL COLUMNS FROM `application_error_logs`
15:19:49.477 0.9 ms
SHOW CREATE TABLE `application_error_logs`
15:19:49.479 2.1 ms
INSERT INTO `application_error_logs` (`level`, `category`, `created`, `ip_address`, `user_id`, `request_URL`, `message`, `host`) VALUES ('error', 'exception.CHttpException.404', '2025-04-17 15:19:49', '66.249.66.163', '2', '/en/%22https:////montreal.lufa.com//fr//marche//categorie//pret-a-cuisiner//menu-des-fetes/%22', 'CHttpException: Unable to resolve the request ""https:////montreal.lufa.com//fr//marche//categorie//pret-a-cuisiner//menu-des-fetes/"". 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//fr//marche//categorie//pret-a-cuisiner//menu-des-fetes/%22 ---', '8dcd09da29c0')
# Query Count Total Avg Min Max
1
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id` IS NULL LIMIT 1
 5 5.1 ms 1.0 ms 0.9 ms 1.1 ms
2
SHOW FULL COLUMNS FROM `securelufacom`.`users`
 1 3.2 ms 3.2 ms 3.2 ms 3.2 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//fr//marche//categorie//pret-a-cuisiner//menu-des-fetes/"', 2.56, 0.072, '66.249.66.163', NULL, '', '', 's:0:"";');
 1 2.2 ms 2.2 ms 2.2 ms 2.2 ms
4
SELECT `data` FROM `user_session` WHERE expire>1744917589 AND id='83aithqpglbdfldo0sp1fed8te'
 1 2.2 ms 2.2 ms 2.2 ms 2.2 ms
5
INSERT INTO `application_error_logs` (`level`, `category`, `created`, `ip_address`, `user_id`, `request_URL`, `message`, `host`) VALUES ('error', 'exception.CHttpException.404', '2025-04-17 15:19:49', '66.249.66.163', '2', '/en/%22https:////montreal.lufa.com//fr//marche//categorie//pret-a-cuisiner//menu-des-fetes/%22', 'CHttpException: Unable to resolve the request ""https:////montreal.lufa.com//fr//marche//categorie//pret-a-cuisiner//menu-des-fetes/"". 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//fr//marche//categorie//pret-a-cuisiner//menu-des-fetes/%22 ---', '8dcd09da29c0')
 1 2.1 ms 2.1 ms 2.1 ms 2.1 ms
6
SHOW FULL COLUMNS FROM `marketing_custom_urls`
 1 1.7 ms 1.7 ms 1.7 ms 1.7 ms
7
SHOW FULL COLUMNS FROM `marketing_campaign_referrals`
 1 1.5 ms 1.5 ms 1.5 ms 1.5 ms
8
SHOW FULL COLUMNS FROM `application_error_logs`
 1 1.5 ms 1.5 ms 1.5 ms 1.5 ms
9
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 '83aithqpglbdfldo0sp1fed8te' 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.4 ms 1.4 ms 1.4 ms 1.4 ms
10
SHOW CREATE TABLE `securelufacom`.`users`
 1 1.3 ms 1.3 ms 1.3 ms 1.3 ms
11
SHOW CREATE TABLE `marketing_custom_urls`
 1 1.2 ms 1.2 ms 1.2 ms 1.2 ms
12
SHOW CREATE TABLE `marketing_campaign_referrals`
 1 0.9 ms 0.9 ms 0.9 ms 0.9 ms
13
SHOW CREATE TABLE `application_error_logs`
 1 0.9 ms 0.9 ms 0.9 ms 0.9 ms
14
SELECT child FROM authitemchild WHERE parent = 'default_guest'
 1 0.9 ms 0.9 ms 0.9 ms 0.9 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`='%22')
 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
776012
Threads
20
Questions
753934
Slow queries
90
Opens
4711
Flush tables
3
Open tables
2042
Queries per second avg
0.971