GET http://chinchilldev.lufa.com/en/aide/reponses/80 at 2025-04-13 06:52:13 by 172.19.0.1
| Time | Duration | Query |
|---|---|---|
| 06:52:13.071 | 1.7 ms |
SHOW FULL COLUMNS FROM `marketing_custom_urls` |
| 06:52:13.073 | 0.8 ms |
SHOW CREATE TABLE `marketing_custom_urls` |
| 06:52:13.074 | 1.3 ms |
SHOW FULL COLUMNS FROM `marketing_campaign_referrals` |
| 06:52:13.075 | 0.7 ms |
SHOW CREATE TABLE `marketing_campaign_referrals` |
| 06:52:13.076 | 0.7 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`='80') |
| 06:52:13.078 | 0.7 ms |
SELECT `data`
FROM `user_session`
WHERE expire>1744541533 AND id='efgvgci5p53ubtq2frsr943db0' |
| 06:52:13.084 | 2.9 ms |
SHOW FULL COLUMNS FROM `securelufacom`.`users` |
| 06:52:13.088 | 1.2 ms |
SHOW CREATE TABLE `securelufacom`.`users` |
| 06:52:13.091 | 1.2 ms |
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id` IS NULL LIMIT 1 |
| 06:52:13.092 | 0.9 ms |
SELECT child
FROM authitemchild
WHERE parent = 'default_guest' |
| 06:52:13.093 | 1.1 ms |
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id` IS NULL LIMIT 1 |
| 06:52:13.095 | 1.3 ms |
SHOW FULL COLUMNS FROM `interactive_questions_answers` |
| 06:52:13.097 | 0.7 ms |
SHOW CREATE TABLE `interactive_questions_answers` |
| 06:52:13.099 | 1.0 ms |
SELECT iqa.interactive_question_answer_id, IFNULL(l_value, `value`) as `value`, `type`, level
FROM interactive_questions_answers iqa
LEFT JOIN interactive_questions_answersLang iqal ON iqa.interactive_question_answer_id = iqal.interactive_question_answer_id
AND lang_id = 'en'
WHERE iqa.interactive_question_answer_id = 80 |
| 06:52:13.100 | 1.3 ms |
SHOW FULL COLUMNS FROM `interactive_questions_answersLang` |
| 06:52:13.102 | 0.7 ms |
SHOW CREATE TABLE `interactive_questions_answersLang` |
| 06:52:13.103 | 1.2 ms |
SELECT `t`.`interactive_question_answer_id` AS `t0_c0`, `t`.`parent_id` AS `t0_c1`, `t`.`type` AS `t0_c2`, `t`.`value` AS `t0_c3`, `t`.`root` AS `t0_c4`, `t`.`lft` AS `t0_c5`, `t`.`rgt` AS `t0_c6`, `t`.`level` AS `t0_c7`, `i18nInteractiveQA`.`l_id` AS `t1_c0`, `i18nInteractiveQA`.`interactive_question_answer_id` AS `t1_c1`, `i18nInteractiveQA`.`lang_id` AS `t1_c2`, `i18nInteractiveQA`.`l_value` AS `t1_c3` FROM `interactive_questions_answers` `t` LEFT OUTER JOIN `interactive_questions_answersLang` `i18nInteractiveQA` ON (`i18nInteractiveQA`.`interactive_question_answer_id`=`t`.`interactive_question_answer_id`) AND (i18nInteractiveQA.lang_id='en') WHERE (`t`.`parent_id`='80') |
| 06:52:13.109 | 3.0 ms |
SHOW FULL COLUMNS FROM `faq` |
| 06:52:13.112 | 1.1 ms |
SHOW CREATE TABLE `faq` |
| 06:52:13.114 | 0.9 ms |
SELECT IFNULL(l_answer, answer) as answer
FROM faq
LEFT JOIN faqLang ON faq.faq_id = faqLang.faq_id
AND lang_id = 'en'
WHERE faq.faq_id = '58' |
| 06:52:13.116 | 39.1 ms |
SHOW FULL COLUMNS FROM `interactive_questions_answers_params` |
| 06:52:13.156 | 11.0 ms |
SHOW CREATE TABLE `interactive_questions_answers_params` |
| 06:52:13.167 | 2.7 ms |
SELECT `params`.`interactive_questions_answers_params_id` AS `t1_c0`, `params`.`interactive_question_answer_id` AS `t1_c1`, `params`.`type` AS `t1_c2`, `params`.`value` AS `t1_c3` FROM `interactive_questions_answers_params` `params` WHERE (`params`.`interactive_question_answer_id`='87') |
| 06:52:13.219 | 1.5 ms |
SELECT `t`.`interactive_question_answer_id` AS `t0_c0`, `t`.`parent_id` AS `t0_c1`, `t`.`type` AS `t0_c2`, `t`.`value` AS `t0_c3`, `t`.`root` AS `t0_c4`, `t`.`lft` AS `t0_c5`, `t`.`rgt` AS `t0_c6`, `t`.`level` AS `t0_c7`, `i18nInteractiveQA`.`l_id` AS `t1_c0`, `i18nInteractiveQA`.`interactive_question_answer_id` AS `t1_c1`, `i18nInteractiveQA`.`lang_id` AS `t1_c2`, `i18nInteractiveQA`.`l_value` AS `t1_c3` FROM `interactive_questions_answers` `t` LEFT OUTER JOIN `interactive_questions_answersLang` `i18nInteractiveQA` ON (`i18nInteractiveQA`.`interactive_question_answer_id`=`t`.`interactive_question_answer_id`) AND (i18nInteractiveQA.lang_id='en') WHERE (`t`.`interactive_question_answer_id`=80) |
| 06:52:13.222 | 1.2 ms |
SELECT `t`.`interactive_question_answer_id` AS `t0_c0`, `t`.`parent_id` AS `t0_c1`, `t`.`type` AS `t0_c2`, `t`.`value` AS `t0_c3`, `t`.`root` AS `t0_c4`, `t`.`lft` AS `t0_c5`, `t`.`rgt` AS `t0_c6`, `t`.`level` AS `t0_c7`, `i18nInteractiveQA`.`l_id` AS `t1_c0`, `i18nInteractiveQA`.`interactive_question_answer_id` AS `t1_c1`, `i18nInteractiveQA`.`lang_id` AS `t1_c2`, `i18nInteractiveQA`.`l_value` AS `t1_c3` FROM `interactive_questions_answers` `t` LEFT OUTER JOIN `interactive_questions_answersLang` `i18nInteractiveQA` ON (`i18nInteractiveQA`.`interactive_question_answer_id`=`t`.`interactive_question_answer_id`) AND (i18nInteractiveQA.lang_id='en') WHERE (`t`.`interactive_question_answer_id`=80) |
| 06:52:13.224 | 1.1 ms |
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id` IS NULL LIMIT 1 |
| 06:52:13.226 | 1.0 ms |
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id` IS NULL LIMIT 1 |
| 06:52:13.227 | 1.0 ms |
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id` IS NULL LIMIT 1 |
| 06:52:13.230 | 0.9 ms |
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id` IS NULL LIMIT 1 |
| 06:52:13.233 | 0.9 ms |
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id` IS NULL LIMIT 1 |
| 06:52:13.236 | 3.1 ms |
INSERT IGNORE INTO stats_page_requested (url, memory_used, loading_time, ip, user_id, request_body, query_string, cookies)
VALUES ('aide/reponses/80', 2.84, 0.178, '66.249.64.174', NULL, '', '', 's:0:"";'); |
| # | Query | Count | Total | Avg | Min | Max |
|---|---|---|---|---|---|---|
| 1 |
SHOW FULL COLUMNS FROM `interactive_questions_answers_params` |
1 | 39.1 ms | 39.1 ms | 39.1 ms | 39.1 ms |
| 2 |
SHOW CREATE TABLE `interactive_questions_answers_params` |
1 | 11.0 ms | 11.0 ms | 11.0 ms | 11.0 ms |
| 3 |
SELECT * FROM `securelufacom`.`users` `t` WHERE `t`.`user_id` IS NULL LIMIT 1 |
7 | 7.1 ms | 1.0 ms | 0.9 ms | 1.2 ms |
| 4 |
INSERT IGNORE INTO stats_page_requested (url, memory_used, loading_time, ip, user_id, request_body, query_string, cookies)
VALUES ('aide/reponses/80', 2.84, 0.178, '66.249.64.174', NULL, '', '', 's:0:"";'); |
1 | 3.1 ms | 3.1 ms | 3.1 ms | 3.1 ms |
| 5 |
SHOW FULL COLUMNS FROM `faq` |
1 | 3.0 ms | 3.0 ms | 3.0 ms | 3.0 ms |
| 6 |
SHOW FULL COLUMNS FROM `securelufacom`.`users` |
1 | 2.9 ms | 2.9 ms | 2.9 ms | 2.9 ms |
| 7 |
SELECT `t`.`interactive_question_answer_id` AS `t0_c0`, `t`.`parent_id` AS `t0_c1`, `t`.`type` AS `t0_c2`, `t`.`value` AS `t0_c3`, `t`.`root` AS `t0_c4`, `t`.`lft` AS `t0_c5`, `t`.`rgt` AS `t0_c6`, `t`.`level` AS `t0_c7`, `i18nInteractiveQA`.`l_id` AS `t1_c0`, `i18nInteractiveQA`.`interactive_question_answer_id` AS `t1_c1`, `i18nInteractiveQA`.`lang_id` AS `t1_c2`, `i18nInteractiveQA`.`l_value` AS `t1_c3` FROM `interactive_questions_answers` `t` LEFT OUTER JOIN `interactive_questions_answersLang` `i18nInteractiveQA` ON (`i18nInteractiveQA`.`interactive_question_answer_id`=`t`.`interactive_question_answer_id`) AND (i18nInteractiveQA.lang_id='en') WHERE (`t`.`interactive_question_answer_id`=80) |
2 | 2.7 ms | 1.4 ms | 1.2 ms | 1.5 ms |
| 8 |
SELECT `params`.`interactive_questions_answers_params_id` AS `t1_c0`, `params`.`interactive_question_answer_id` AS `t1_c1`, `params`.`type` AS `t1_c2`, `params`.`value` AS `t1_c3` FROM `interactive_questions_answers_params` `params` WHERE (`params`.`interactive_question_answer_id`='87') |
1 | 2.7 ms | 2.7 ms | 2.7 ms | 2.7 ms |
| 9 |
SHOW FULL COLUMNS FROM `marketing_custom_urls` |
1 | 1.7 ms | 1.7 ms | 1.7 ms | 1.7 ms |
| 10 |
SHOW FULL COLUMNS FROM `interactive_questions_answers` |
1 | 1.3 ms | 1.3 ms | 1.3 ms | 1.3 ms |
| 11 |
SHOW FULL COLUMNS FROM `marketing_campaign_referrals` |
1 | 1.3 ms | 1.3 ms | 1.3 ms | 1.3 ms |
| 12 |
SHOW FULL COLUMNS FROM `interactive_questions_answersLang` |
1 | 1.3 ms | 1.3 ms | 1.3 ms | 1.3 ms |
| 13 |
SELECT `t`.`interactive_question_answer_id` AS `t0_c0`, `t`.`parent_id` AS `t0_c1`, `t`.`type` AS `t0_c2`, `t`.`value` AS `t0_c3`, `t`.`root` AS `t0_c4`, `t`.`lft` AS `t0_c5`, `t`.`rgt` AS `t0_c6`, `t`.`level` AS `t0_c7`, `i18nInteractiveQA`.`l_id` AS `t1_c0`, `i18nInteractiveQA`.`interactive_question_answer_id` AS `t1_c1`, `i18nInteractiveQA`.`lang_id` AS `t1_c2`, `i18nInteractiveQA`.`l_value` AS `t1_c3` FROM `interactive_questions_answers` `t` LEFT OUTER JOIN `interactive_questions_answersLang` `i18nInteractiveQA` ON (`i18nInteractiveQA`.`interactive_question_answer_id`=`t`.`interactive_question_answer_id`) AND (i18nInteractiveQA.lang_id='en') WHERE (`t`.`parent_id`='80') |
1 | 1.2 ms | 1.2 ms | 1.2 ms | 1.2 ms |
| 14 |
SHOW CREATE TABLE `securelufacom`.`users` |
1 | 1.2 ms | 1.2 ms | 1.2 ms | 1.2 ms |
| 15 |
SHOW CREATE TABLE `faq` |
1 | 1.1 ms | 1.1 ms | 1.1 ms | 1.1 ms |
| 16 |
SELECT iqa.interactive_question_answer_id, IFNULL(l_value, `value`) as `value`, `type`, level
FROM interactive_questions_answers iqa
LEFT JOIN interactive_questions_answersLang iqal ON iqa.interactive_question_answer_id = iqal.interactive_question_answer_id
AND lang_id = 'en'
WHERE iqa.interactive_question_answer_id = 80 |
1 | 1.0 ms | 1.0 ms | 1.0 ms | 1.0 ms |
| 17 |
SELECT IFNULL(l_answer, answer) as answer
FROM faq
LEFT JOIN faqLang ON faq.faq_id = faqLang.faq_id
AND lang_id = 'en'
WHERE faq.faq_id = '58' |
1 | 0.9 ms | 0.9 ms | 0.9 ms | 0.9 ms |
| 18 |
SELECT child
FROM authitemchild
WHERE parent = 'default_guest' |
1 | 0.9 ms | 0.9 ms | 0.9 ms | 0.9 ms |
| 19 |
SHOW CREATE TABLE `marketing_custom_urls` |
1 | 0.8 ms | 0.8 ms | 0.8 ms | 0.8 ms |
| 20 |
SHOW CREATE TABLE `interactive_questions_answers` |
1 | 0.7 ms | 0.7 ms | 0.7 ms | 0.7 ms |
| 21 |
SELECT `data`
FROM `user_session`
WHERE expire>1744541533 AND id='efgvgci5p53ubtq2frsr943db0' |
1 | 0.7 ms | 0.7 ms | 0.7 ms | 0.7 ms |
| 22 |
SHOW CREATE TABLE `interactive_questions_answersLang` |
1 | 0.7 ms | 0.7 ms | 0.7 ms | 0.7 ms |
| 23 |
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`='80') |
1 | 0.7 ms | 0.7 ms | 0.7 ms | 0.7 ms |
| 24 |
SHOW CREATE TABLE `marketing_campaign_referrals` |
1 | 0.7 ms | 0.7 ms | 0.7 ms | 0.7 ms |
Component: db (CDbConnection)
| Name | Value |
|---|---|
| driver |
mysql
|
| server |
8.0.29-21
|
| Uptime |
399956
|
| Threads |
2
|
| Questions |
252532
|
| Slow queries |
36
|
| Opens |
3636
|
| Flush tables |
3
|
| Open tables |
2048
|
| Queries per second avg |
0.631
|