Yii Debugger
1.1.25
PHP 8.0.30
Status 404
Action
Log 46 1
Time 81 ms
Memory 2.7 MB
DB 19 30 ms
All Latest
GET http://chinchilldev.lufa.com/en/"https:////www.youtube.com//embed//fSqr0N1DKpo at 2025-04-15 03:57:08 by 172.19.0.1
Time Duration Query
15:57:07.942 1.9 ms
SHOW FULL COLUMNS FROM `marketing_custom_urls`
15:57:07.944 1.0 ms
SHOW CREATE TABLE `marketing_custom_urls`
15:57:07.946 1.6 ms
SHOW FULL COLUMNS FROM `marketing_campaign_referrals`
15:57:07.948 0.9 ms
SHOW CREATE TABLE `marketing_campaign_referrals`
15:57:07.949 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`='fsqr0n1dkpo')
Explain
15:57:07.950 2.9 ms
SELECT `data` FROM `user_session` WHERE expire>1744747027 AND id='0un6nrgnme8039a7qkpotusgvv'
Explain
15:57:07.973 1.1 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 '0un6nrgnme8039a7qkpotusgvv' 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:57:07.977 4.0 ms
SHOW FULL COLUMNS FROM `securelufacom`.`users`
15:57:07.982 1.5 ms
SHOW CREATE TABLE `securelufacom`.`users`
15:57:07.985 1.2 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id` IS NULL LIMIT 1
Explain
15:57:07.987 1.1 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id` IS NULL LIMIT 1
Explain
15:57:07.988 1.0 ms
SELECT child FROM authitemchild WHERE parent = 'default_guest'
Explain
15:57:07.990 0.9 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id` IS NULL LIMIT 1
Explain
15:57:07.993 1.0 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id` IS NULL LIMIT 1
Explain
15:57:07.996 1.1 ms
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id` IS NULL LIMIT 1
Explain
15:57:07.998 2.9 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//fSqr0N1DKpo', 2.56, 0.071, '66.249.64.174', NULL, '', '', 's:0:"";');
15:57:08.002 1.9 ms
SHOW FULL COLUMNS FROM `application_error_logs`
15:57:08.004 1.0 ms
SHOW CREATE TABLE `application_error_logs`
15:57:08.005 2.4 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 15:57:08', '66.249.64.174', '2', '/en/%22https:////www.youtube.com//embed//fSqr0N1DKpo', 'CHttpException: Unable to resolve the request ""https:////www.youtube.com//embed//fSqr0N1DKpo". 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//fSqr0N1DKpo ---', '0d0c8ed51942')
# Query Count Total Avg Min Max
1
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id` IS NULL LIMIT 1
 5 5.3 ms 1.1 ms 0.9 ms 1.2 ms
2
SHOW FULL COLUMNS FROM `securelufacom`.`users`
 1 4.0 ms 4.0 ms 4.0 ms 4.0 ms
3
SELECT `data` FROM `user_session` WHERE expire>1744747027 AND id='0un6nrgnme8039a7qkpotusgvv'
 1 2.9 ms 2.9 ms 2.9 ms 2.9 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//fSqr0N1DKpo', 2.56, 0.071, '66.249.64.174', NULL, '', '', 's:0:"";');
 1 2.9 ms 2.9 ms 2.9 ms 2.9 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-15 15:57:08', '66.249.64.174', '2', '/en/%22https:////www.youtube.com//embed//fSqr0N1DKpo', 'CHttpException: Unable to resolve the request ""https:////www.youtube.com//embed//fSqr0N1DKpo". 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//fSqr0N1DKpo ---', '0d0c8ed51942')
 1 2.4 ms 2.4 ms 2.4 ms 2.4 ms
6
SHOW FULL COLUMNS FROM `marketing_custom_urls`
 1 1.9 ms 1.9 ms 1.9 ms 1.9 ms
7
SHOW FULL COLUMNS FROM `application_error_logs`
 1 1.9 ms 1.9 ms 1.9 ms 1.9 ms
8
SHOW FULL COLUMNS FROM `marketing_campaign_referrals`
 1 1.6 ms 1.6 ms 1.6 ms 1.6 ms
9
SHOW CREATE TABLE `securelufacom`.`users`
 1 1.5 ms 1.5 ms 1.5 ms 1.5 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 '0un6nrgnme8039a7qkpotusgvv' 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.1 ms 1.1 ms 1.1 ms 1.1 ms
11
SHOW CREATE TABLE `marketing_custom_urls`
 1 1.0 ms 1.0 ms 1.0 ms 1.0 ms
12
SHOW CREATE TABLE `application_error_logs`
 1 1.0 ms 1.0 ms 1.0 ms 1.0 ms
13
SELECT child FROM authitemchild WHERE parent = 'default_guest'
 1 1.0 ms 1.0 ms 1.0 ms 1.0 ms
14
SHOW CREATE TABLE `marketing_campaign_referrals`
 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`='fsqr0n1dkpo')
 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
605451
Threads
2
Questions
501612
Slow queries
68
Opens
4218
Flush tables
3
Open tables
2048
Queries per second avg
0.828