Select Queries (12)
Array
(
[0] => Array
(
[q] => SELECT * FROM cb_config
[timetook] => 0.00091004371643066
[memBefore] => 0.41804504394531
[memAfter] => 0.44452667236328
[memUsed] => 0.026481628417969
[use_cache] => no
[backtrace] => #1 /srv/http/clipbucket/upload/includes/classes/db.class.php(236): devWitch()
#2 /srv/http/clipbucket/upload/includes/classes/db.class.php(120): Clipbucket_db->execute()
#3 /srv/http/clipbucket/upload/includes/functions_db.php(10): Clipbucket_db->_select()
#4 /srv/http/clipbucket/upload/includes/classes/my_queries.class.php(32): db_select()
#5 /srv/http/clipbucket/upload/includes/common.php(102): myquery->Get_Website_Details()
#6 /srv/http/clipbucket/upload/includes/config.inc.php(9): require_once()
#7 /srv/http/clipbucket/upload/view_page.php(4): require()
)
[1] => Array
(
[q] => SELECT * FROM cb_languages WHERE language_default='yes'
[timetook] => 0.0002751350402832
[memBefore] => 0.44452667236328
[memAfter] => 0.6209716796875
[memUsed] => 0.17644500732422
[use_cache] => no
[backtrace] => #1 /srv/http/clipbucket/upload/includes/classes/db.class.php(236): devWitch()
#2 /srv/http/clipbucket/upload/includes/classes/db.class.php(120): Clipbucket_db->execute()
#3 /srv/http/clipbucket/upload/includes/classes/db.class.php(169): Clipbucket_db->_select()
#4 /srv/http/clipbucket/upload/includes/classes/lang.class.php(317): Clipbucket_db->select()
#5 /srv/http/clipbucket/upload/includes/classes/lang.class.php(73): Language->getDefaultLanguage()
#6 /srv/http/clipbucket/upload/includes/common.php(152): Language->init()
#7 /srv/http/clipbucket/upload/includes/config.inc.php(9): require_once()
#8 /srv/http/clipbucket/upload/view_page.php(4): require()
)
[2] => Array
(
[q] => SELECT language_key, translation FROM cb_languages_keys AS LK
LEFT JOIN cb_languages_translations AS LT ON LK.id_language_key = LT.id_language_key AND LT.language_id = 1 ORDER BY CASE WHEN LT.translation IS NULL THEN concat('aaaaaaaaaaaaaaaaaaaa',language_key) ELSE LK.language_key END
[timetook] => 0.020580053329468
[memBefore] => 0.6209716796875
[memAfter] => 0.71298980712891
[memUsed] => 0.092018127441406
[use_cache] => no
[backtrace] => #1 /srv/http/clipbucket/upload/includes/classes/db.class.php(236): devWitch()
#2 /srv/http/clipbucket/upload/includes/classes/db.class.php(120): Clipbucket_db->execute()
#3 /srv/http/clipbucket/upload/includes/classes/db.class.php(169): Clipbucket_db->_select()
#4 /srv/http/clipbucket/upload/includes/classes/lang.class.php(154): Clipbucket_db->select()
#5 /srv/http/clipbucket/upload/includes/classes/lang.class.php(215): Language->getAllTranslations()
#6 /srv/http/clipbucket/upload/includes/classes/lang.class.php(82): Language->loadTranslations()
#7 /srv/http/clipbucket/upload/includes/common.php(152): Language->init()
#8 /srv/http/clipbucket/upload/includes/config.inc.php(9): require_once()
#9 /srv/http/clipbucket/upload/view_page.php(4): require()
)
[3] => Array
(
[q] => SELECT * FROM cb_sessions WHERE session ='i308m8kn8dpn9gobl0kecq055r'
[timetook] => 0.00035405158996582
[memBefore] => 0.71298980712891
[memAfter] => 0.85694885253906
[memUsed] => 0.14395904541016
[use_cache] => no
[backtrace] => #1 /srv/http/clipbucket/upload/includes/classes/db.class.php(236): devWitch()
#2 /srv/http/clipbucket/upload/includes/classes/db.class.php(120): Clipbucket_db->execute()
#3 /srv/http/clipbucket/upload/includes/classes/db.class.php(169): Clipbucket_db->_select()
#4 /srv/http/clipbucket/upload/includes/classes/session.class.php(99): Clipbucket_db->select()
#5 /srv/http/clipbucket/upload/includes/classes/user.class.php(5200): Session->get_sessions()
#6 /srv/http/clipbucket/upload/includes/classes/user.class.php(931): userquery->get_sessions()
#7 /srv/http/clipbucket/upload/includes/common.php(165): userquery->init()
#8 /srv/http/clipbucket/upload/includes/config.inc.php(9): require_once()
#9 /srv/http/clipbucket/upload/view_page.php(4): require()
)
[4] => Array
(
[q] => SELECT * FROM cb_sessions WHERE session_string='guest' AND session ='i308m8kn8dpn9gobl0kecq055r'
[timetook] => 0.00023603439331055
[memBefore] => 0.84413909912109
[memAfter] => 0.86061096191406
[memUsed] => 0.016471862792969
[use_cache] => no
[backtrace] => #1 /srv/http/clipbucket/upload/includes/classes/db.class.php(236): devWitch()
#2 /srv/http/clipbucket/upload/includes/classes/db.class.php(120): Clipbucket_db->execute()
#3 /srv/http/clipbucket/upload/includes/classes/db.class.php(169): Clipbucket_db->_select()
#4 /srv/http/clipbucket/upload/includes/classes/session.class.php(88): Clipbucket_db->select()
#5 /srv/http/clipbucket/upload/includes/classes/session.class.php(44): Session->get_user_session()
#6 /srv/http/clipbucket/upload/includes/classes/user.class.php(5207): Session->add_session()
#7 /srv/http/clipbucket/upload/includes/classes/user.class.php(931): userquery->get_sessions()
#8 /srv/http/clipbucket/upload/includes/common.php(165): userquery->init()
#9 /srv/http/clipbucket/upload/includes/config.inc.php(9): require_once()
#10 /srv/http/clipbucket/upload/view_page.php(4): require()
)
[5] => Array
(
[q] => SELECT version.id, version.version, version.revision FROM cb_version AS version
[timetook] => 0.00013589859008789
[memBefore] => 0.86061096191406
[memAfter] => 0.86192321777344
[memUsed] => 0.001312255859375
[use_cache] => no
[backtrace] => #1 /srv/http/clipbucket/upload/includes/classes/db.class.php(236): devWitch()
#2 /srv/http/clipbucket/upload/includes/classes/db.class.php(120): Clipbucket_db->execute()
#3 /srv/http/clipbucket/upload/includes/classes/db.class.php(169): Clipbucket_db->_select()
#4 /srv/http/clipbucket/upload/includes/classes/update.class.php(60): Clipbucket_db->select()
#5 /srv/http/clipbucket/upload/includes/classes/update.class.php(770): Update->getDBVersion()
#6 /srv/http/clipbucket/upload/includes/classes/user_level.class.php(39): Update->IsCurrentDBVersionIsHigherOrEqualTo()
#7 /srv/http/clipbucket/upload/includes/classes/user.class.php(969): UserLevel->getPermissions()
#8 /srv/http/clipbucket/upload/includes/common.php(165): userquery->init()
#9 /srv/http/clipbucket/upload/includes/config.inc.php(9): require_once()
#10 /srv/http/clipbucket/upload/view_page.php(4): require()
)
[6] => Array
(
[q] => SELECT user_levels_permissions.id_user_levels_permission, user_levels_permissions.id_user_permission_types, user_levels_permissions.permission_name, user_levels_permissions.permission_description, user_levels_permissions_values.user_level_id, user_levels_permissions_values.id_user_levels_permission, user_levels_permissions_values.permission_value
FROM cb_user_levels_permissions AS user_levels_permissions INNER JOIN cb_user_levels_permissions_values AS user_levels_permissions_values ON user_levels_permissions.id_user_levels_permission = user_levels_permissions_values.id_user_levels_permission WHERE user_levels_permissions_values.user_level_id = 4
[timetook] => 0.0002892017364502
[memBefore] => 0.86192321777344
[memAfter] => 0.86653137207031
[memUsed] => 0.004608154296875
[use_cache] => no
[backtrace] => #1 /srv/http/clipbucket/upload/includes/classes/db.class.php(236): devWitch()
#2 /srv/http/clipbucket/upload/includes/classes/db.class.php(120): Clipbucket_db->execute()
#3 /srv/http/clipbucket/upload/includes/classes/user_level.class.php(139): Clipbucket_db->_select()
#4 /srv/http/clipbucket/upload/includes/classes/user_level.class.php(40): UserLevel->getAllPermissions()
#5 /srv/http/clipbucket/upload/includes/classes/user.class.php(969): UserLevel->getPermissions()
#6 /srv/http/clipbucket/upload/includes/common.php(165): userquery->init()
#7 /srv/http/clipbucket/upload/includes/config.inc.php(9): require_once()
#8 /srv/http/clipbucket/upload/view_page.php(4): require()
)
[7] => Array
(
[q] => SELECT tools.id_tool, language_key_label, language_key_description, elements_total, elements_done, COALESCE(NULLIF(language_key_title, ''), 'ready') as language_key_title, function_name, code,
CASE WHEN elements_total IS NULL OR elements_total = 0 THEN 0 ELSE elements_done * 100 / elements_total END AS pourcentage_progress, tools_histo.id_histo
,tools.is_automatable, tools.is_disabled, tools.frequency
FROM cb_tools AS tools
LEFT JOIN (
SELECT id_tool, MAX(date_start) AS max_date
FROM cb_tools_histo
GROUP BY id_tool
) tools_histo_max_date ON tools.id_tool = tools_histo_max_date.id_tool
LEFT JOIN cb_tools_histo AS tools_histo ON tools.id_tool = tools_histo.id_tool AND tools_histo.date_start = tools_histo_max_date.max_date
left JOIN cb_tools_histo_status AS tools_histo_status ON tools_histo_status.id_tools_histo_status = tools_histo.id_tools_histo_status
WHERE (tools_histo.id_tool IS NOT NULL OR tools_histo_max_date.id_tool IS NULL)
AND tools.code = 'automate'
ORDER BY tools.id_tool;
[timetook] => 0.012985944747925
[memBefore] => 0.86653137207031
[memAfter] => 0.93050384521484
[memUsed] => 0.063972473144531
[use_cache] => no
[backtrace] => #1 /srv/http/clipbucket/upload/includes/classes/db.class.php(236): devWitch()
#2 /srv/http/clipbucket/upload/includes/classes/db.class.php(120): Clipbucket_db->execute()
#3 /srv/http/clipbucket/upload/includes/classes/admin_tool.class.php(107): Clipbucket_db->_select()
#4 /srv/http/clipbucket/upload/includes/classes/admin_tool.class.php(258): AdminTool->getTools()
#5 /srv/http/clipbucket/upload/includes/classes/admin_tool.class.php(65): AdminTool->getToolByCode()
#6 /srv/http/clipbucket/upload/includes/common.php(405): AdminTool->initByCode()
#7 /srv/http/clipbucket/upload/includes/config.inc.php(9): require_once()
#8 /srv/http/clipbucket/upload/view_page.php(4): require()
)
[8] => Array
(
[q] => SELECT tools_histo.date_start
FROM cb_tools_histo AS tools_histo
WHERE tools_histo.id_tool = 17
ORDER BY tools_histo.date_start DESC LIMIT 1
[timetook] => 0.022710800170898
[memBefore] => 0.93050384521484
[memAfter] => 0.93256378173828
[memUsed] => 0.0020599365234375
[use_cache] => no
[backtrace] => #1 /srv/http/clipbucket/upload/includes/classes/db.class.php(236): devWitch()
#2 /srv/http/clipbucket/upload/includes/classes/db.class.php(120): Clipbucket_db->execute()
#3 /srv/http/clipbucket/upload/includes/classes/admin_tool.class.php(1113): Clipbucket_db->_select()
#4 /srv/http/clipbucket/upload/includes/common.php(405): AdminTool->getLastStart()
#5 /srv/http/clipbucket/upload/includes/config.inc.php(9): require_once()
#6 /srv/http/clipbucket/upload/view_page.php(4): require()
)
[9] => Array
(
[q] => SELECT * FROM cb_plugins WHERE plugin_active='yes'
[timetook] => 0.0002892017364502
[memBefore] => 0.93256378173828
[memAfter] => 0.93252563476562
[memUsed] => -3.814697265625E-5
[use_cache] => no
[backtrace] => #1 /srv/http/clipbucket/upload/includes/classes/db.class.php(236): devWitch()
#2 /srv/http/clipbucket/upload/includes/classes/db.class.php(120): Clipbucket_db->execute()
#3 /srv/http/clipbucket/upload/includes/classes/db.class.php(169): Clipbucket_db->_select()
#4 /srv/http/clipbucket/upload/includes/classes/plugin.class.php(216): Clipbucket_db->select()
#5 /srv/http/clipbucket/upload/includes/plugins.php(3): CBPlugin->getInstalledPlugins()
#6 /srv/http/clipbucket/upload/includes/config.inc.php(21): require_once()
#7 /srv/http/clipbucket/upload/view_page.php(4): require()
)
[10] => Array
(
[q] => SELECT * FROM cb_languages WHERE language_default='yes'
[timetook] => 0.00027799606323242
[memBefore] => 0.93252563476562
[memAfter] => 0.93442535400391
[memUsed] => 0.0018997192382812
[use_cache] => no
[backtrace] => #1 /srv/http/clipbucket/upload/includes/classes/db.class.php(236): devWitch()
#2 /srv/http/clipbucket/upload/includes/classes/db.class.php(120): Clipbucket_db->execute()
#3 /srv/http/clipbucket/upload/includes/classes/db.class.php(169): Clipbucket_db->_select()
#4 /srv/http/clipbucket/upload/includes/classes/lang.class.php(317): Clipbucket_db->select()
#5 /srv/http/clipbucket/upload/includes/functions.php(1170): Language->getDefaultLanguage()
#6 /srv/http/clipbucket/upload/player/CB_video_js/cb_video_js.php(24): get_current_language()
#7 /srv/http/clipbucket/upload/player/CB_video_js/cb_video_js.php(126): CB_video_js->load_dependancies()
#8 /srv/http/clipbucket/upload/player/CB_video_js/cb_video_js.php(131): CB_video_js->__construct()
#9 /srv/http/clipbucket/upload/includes/plugins.php(35): include_once()
#10 /srv/http/clipbucket/upload/includes/config.inc.php(21): require_once()
#11 /srv/http/clipbucket/upload/view_page.php(4): require()
)
[11] => Array
(
[q] => SELECT * FROM cb_pages WHERE page_id =1
[timetook] => 0.00013399124145508
[memBefore] => 0.93442535400391
[memAfter] => 0.94202423095703
[memUsed] => 0.007598876953125
[use_cache] => no
[backtrace] => #1 /srv/http/clipbucket/upload/includes/classes/db.class.php(236): devWitch()
#2 /srv/http/clipbucket/upload/includes/classes/db.class.php(120): Clipbucket_db->execute()
#3 /srv/http/clipbucket/upload/includes/classes/db.class.php(169): Clipbucket_db->_select()
#4 /srv/http/clipbucket/upload/includes/classes/cbpage.class.php(89): Clipbucket_db->select()
#5 /srv/http/clipbucket/upload/view_page.php(12): cbpage->get_page()
)
)
Update Queries (1)
Array
(
[0] => Array
(
[q] => UPDATE cb_sessions SET last_active='2025-04-26 14:15:17',current_page='http://youvue.mochachat.org/view_page.php?pid=1' WHERE session='i308m8kn8dpn9gobl0kecq055r'
[timetook] => 0.00024008750915527
[memBefore] => 0.85694885253906
[memAfter] => 0.84413909912109
[memUsed] => -0.012809753417969
[use_cache] => no
[backtrace] => #1 /srv/http/clipbucket/upload/includes/classes/db.class.php(236): devWitch()
#2 /srv/http/clipbucket/upload/includes/classes/db.class.php(326): Clipbucket_db->execute()
#3 /srv/http/clipbucket/upload/includes/classes/session.class.php(105): Clipbucket_db->update()
#4 /srv/http/clipbucket/upload/includes/classes/user.class.php(5200): Session->get_sessions()
#5 /srv/http/clipbucket/upload/includes/classes/user.class.php(931): userquery->get_sessions()
#6 /srv/http/clipbucket/upload/includes/common.php(165): userquery->init()
#7 /srv/http/clipbucket/upload/includes/config.inc.php(9): require_once()
#8 /srv/http/clipbucket/upload/view_page.php(4): require()
)
)
Execute Query(1)
Array
(
[0] => Array
(
[q] => SET NAMES "utf8mb4"
[timetook] => 5.4836273193359E-5
[memBefore] => 0
[memAfter] => 0.41804504394531
[memUsed] => 0.41804504394531
[use_cache] => no
[backtrace] => #1 /srv/http/clipbucket/upload/includes/classes/db.class.php(236): devWitch()
#2 /srv/http/clipbucket/upload/includes/classes/db.class.php(78): Clipbucket_db->execute()
#3 /srv/http/clipbucket/upload/includes/classes/db.class.php(25): Clipbucket_db->connect()
#4 /srv/http/clipbucket/upload/includes/classes/db.class.php(18): Clipbucket_db->__construct()
#5 /srv/http/clipbucket/upload/includes/functions_db.php(10): Clipbucket_db->getInstance()
#6 /srv/http/clipbucket/upload/includes/classes/my_queries.class.php(32): db_select()
#7 /srv/http/clipbucket/upload/includes/common.php(102): myquery->Get_Website_Details()
#8 /srv/http/clipbucket/upload/includes/config.inc.php(9): require_once()
#9 /srv/http/clipbucket/upload/view_page.php(4): require()
)
)
Expensive Queries(0.41804504394531)
Array
(
[q] => SET NAMES "utf8mb4"
[timetook] => 5.4836273193359E-5
[memBefore] => 0
[memAfter] => 0.41804504394531
[memUsed] => 0.41804504394531
[use_cache] => no
[backtrace] => #1 /srv/http/clipbucket/upload/includes/classes/db.class.php(236): devWitch()
#2 /srv/http/clipbucket/upload/includes/classes/db.class.php(78): Clipbucket_db->execute()
#3 /srv/http/clipbucket/upload/includes/classes/db.class.php(25): Clipbucket_db->connect()
#4 /srv/http/clipbucket/upload/includes/classes/db.class.php(18): Clipbucket_db->__construct()
#5 /srv/http/clipbucket/upload/includes/functions_db.php(10): Clipbucket_db->getInstance()
#6 /srv/http/clipbucket/upload/includes/classes/my_queries.class.php(32): db_select()
#7 /srv/http/clipbucket/upload/includes/common.php(102): myquery->Get_Website_Details()
#8 /srv/http/clipbucket/upload/includes/config.inc.php(9): require_once()
#9 /srv/http/clipbucket/upload/view_page.php(4): require()
)
Cheapest Queries(-0.012809753417969)
Array
(
[q] => UPDATE cb_sessions SET last_active='2025-04-26 14:15:17',current_page='http://youvue.mochachat.org/view_page.php?pid=1' WHERE session='i308m8kn8dpn9gobl0kecq055r'
[timetook] => 0.00024008750915527
[memBefore] => 0.85694885253906
[memAfter] => 0.84413909912109
[memUsed] => -0.012809753417969
[use_cache] => no
[backtrace] => #1 /srv/http/clipbucket/upload/includes/classes/db.class.php(236): devWitch()
#2 /srv/http/clipbucket/upload/includes/classes/db.class.php(326): Clipbucket_db->execute()
#3 /srv/http/clipbucket/upload/includes/classes/session.class.php(105): Clipbucket_db->update()
#4 /srv/http/clipbucket/upload/includes/classes/user.class.php(5200): Session->get_sessions()
#5 /srv/http/clipbucket/upload/includes/classes/user.class.php(931): userquery->get_sessions()
#6 /srv/http/clipbucket/upload/includes/common.php(165): userquery->init()
#7 /srv/http/clipbucket/upload/includes/config.inc.php(9): require_once()
#8 /srv/http/clipbucket/upload/view_page.php(4): require()
)