Yii Debugger
1.1.25
PHP 8.0.30
Status 404
Action
Log 46 1
Time 86 ms
Memory 2.7 MB
DB 19 32 ms
All Latest
GET http://chinchilldev.lufa.com/en/"https:////www.youtube.com//embed//gm8CgYjoNj8 at 2025-04-17 09:30:23 by 172.19.0.1
Time Duration Query
09:30:23.228 2.0 ms
SHOW FULL COLUMNS FROM `marketing_custom_urls`
09:30:23.230 1.4 ms
SHOW CREATE TABLE `marketing_custom_urls`
09:30:23.232 1.7 ms
SHOW FULL COLUMNS FROM `marketing_campaign_referrals`
09:30:23.234 0.9 ms
SHOW CREATE TABLE `marketing_campaign_referrals`
09:30:23.235 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`='gm8cgyjonj8')
Explain
09:30:23.236 0.8 ms
SELECT `data` FROM `user_session` WHERE expire>1744896623 AND id='ca7uiunb1qpejvkntgid9ns95u'
Explain
09:30:23.261 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 'ca7uiunb1qpejvkntgid9ns95u' 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
09:30:23.265 4.3 ms
SHOW FULL COLUMNS FROM `securelufacom`.`users`
09:30:23.271 1.6 ms
SHOW CREATE TABLE `securelufacom`.`users`
09:30:23.274 1.3 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id` IS NULL LIMIT 1
Explain
09:30:23.276 1.0 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id` IS NULL LIMIT 1
Explain
09:30:23.277 1.1 ms
SELECT child FROM authitemchild WHERE parent = 'default_guest'
Explain
09:30:23.279 1.3 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id` IS NULL LIMIT 1
Explain
09:30:23.282 1.1 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id` IS NULL LIMIT 1
Explain
09:30:23.285 1.1 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id` IS NULL LIMIT 1
Explain
09:30:23.288 3.1 ms
INSERT IGNORE INTO stats_page_requested (url, memory_used, loading_time, ip, user_id, request_body, query_string, cookies) VALUES ('"https:////www.youtube.com//embed//gm8CgYjoNj8', 2.57, 0.074, '66.249.66.163', NULL, '', '', 's:0:"";');
09:30:23.292 2.2 ms
SHOW FULL COLUMNS FROM `application_error_logs`
09:30:23.294 1.1 ms
SHOW CREATE TABLE `application_error_logs`
09:30:23.295 3.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-17 09:30:23', '66.249.66.163', '2', '/en/%22https:////www.youtube.com//embed//gm8CgYjoNj8', 'CHttpException: Unable to resolve the request ""https:////www.youtube.com//embed//gm8CgYjoNj8". 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:////www.youtube.com//embed//gm8CgYjoNj8 ---', '0d0c8ed51942')
# Query Count Total Avg Min Max
1
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id` IS NULL LIMIT 1
 5 5.8 ms 1.2 ms 1.0 ms 1.3 ms
2
SHOW FULL COLUMNS FROM `securelufacom`.`users`
 1 4.3 ms 4.3 ms 4.3 ms 4.3 ms
3
INSERT INTO `application_error_logs` (`level`, `category`, `created`, `ip_address`, `user_id`, `request_URL`, `message`, `host`) VALUES ('error', 'exception.CHttpException.404', '2025-04-17 09:30:23', '66.249.66.163', '2', '/en/%22https:////www.youtube.com//embed//gm8CgYjoNj8', 'CHttpException: Unable to resolve the request ""https:////www.youtube.com//embed//gm8CgYjoNj8". 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:////www.youtube.com//embed//gm8CgYjoNj8 ---', '0d0c8ed51942')
 1 3.7 ms 3.7 ms 3.7 ms 3.7 ms
4
INSERT IGNORE INTO stats_page_requested (url, memory_used, loading_time, ip, user_id, request_body, query_string, cookies) VALUES ('"https:////www.youtube.com//embed//gm8CgYjoNj8', 2.57, 0.074, '66.249.66.163', NULL, '', '', 's:0:"";');
 1 3.1 ms 3.1 ms 3.1 ms 3.1 ms
5
SHOW FULL COLUMNS FROM `application_error_logs`
 1 2.2 ms 2.2 ms 2.2 ms 2.2 ms
6
SHOW FULL COLUMNS FROM `marketing_custom_urls`
 1 2.0 ms 2.0 ms 2.0 ms 2.0 ms
7
SHOW FULL COLUMNS FROM `marketing_campaign_referrals`
 1 1.7 ms 1.7 ms 1.7 ms 1.7 ms
8
SHOW CREATE TABLE `securelufacom`.`users`
 1 1.6 ms 1.6 ms 1.6 ms 1.6 ms
9
SHOW CREATE TABLE `marketing_custom_urls`
 1 1.4 ms 1.4 ms 1.4 ms 1.4 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 'ca7uiunb1qpejvkntgid9ns95u' 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
SHOW CREATE TABLE `application_error_logs`
 1 1.1 ms 1.1 ms 1.1 ms 1.1 ms
12
SELECT child FROM authitemchild WHERE parent = 'default_guest'
 1 1.1 ms 1.1 ms 1.1 ms 1.1 ms
13
SHOW CREATE TABLE `marketing_campaign_referrals`
 1 0.9 ms 0.9 ms 0.9 ms 0.9 ms
14
SELECT `data` FROM `user_session` WHERE expire>1744896623 AND id='ca7uiunb1qpejvkntgid9ns95u'
 1 0.8 ms 0.8 ms 0.8 ms 0.8 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`='gm8cgyjonj8')
 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
755046
Threads
2
Questions
717792
Slow queries
86
Opens
4490
Flush tables
3
Open tables
2048
Queries per second avg
0.950