**وقت الإستعلام: 0.68 ms** **إستعلام الذاكرة: 0.023 MB الذاكرة بعد الإستعلام: 1.353 MB** **إرجاع الصفوف: 0**
SELECT `data`
FROM `pdu4x_session`
WHERE `session_id` = X'3663656235363433323832623263383236346535376636386565626563356130'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | pdu4x_session | const | PRIMARY | PRIMARY | 194 | const | 1 | |
Status | Duration |
---|
Starting | 0.09 ms |
checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.07 ms |
Preparing | 0.02 ms |
Executing | 0.03 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | **المتصل** | **الملف ورقم السطر** |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 |
14 | JSessionStorageDatabase->read() | **نفس الاستدعاء في خط أدناه.** |
13 | session_start() | JROOT/libraries/joomla/session/handler/native.php:260 |
12 | JSessionHandlerNative->doSessionStart() | JROOT/libraries/joomla/session/handler/native.php:50 |
11 | JSessionHandlerNative->start() | JROOT/libraries/joomla/session/handler/joomla.php:88 |
10 | JSessionHandlerJoomla->start() | JROOT/libraries/src/Session/Session.php:661 |
9 | Joomla\CMS\Session\Session->_start() | JROOT/libraries/src/Session/Session.php:621 |
8 | Joomla\CMS\Session\Session->start() | JROOT/libraries/src/Session/Session.php:499 |
7 | Joomla\CMS\Session\Session->get() | JROOT/libraries/src/Session/Session.php:456 |
6 | Joomla\CMS\Session\Session->isNew() | JROOT/libraries/src/Application/CMSApplication.php:826 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
**وقت الإستعلام: 0.63 ms** **قبل آخر إستعلام: 4.65 ms** **إستعلام الذاكرة: 0.020 MB الذاكرة بعد الإستعلام: 1.367 MB** **إرجاع الصفوف: 0**
SELECT `session_id`
FROM `pdu4x_session`
WHERE `session_id` = X'3663656235363433323832623263383236346535376636386565626563356130'
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | pdu4x_session | const | PRIMARY | PRIMARY | 194 | const | 1 | Using index |
Status | Duration |
---|
Starting | 0.06 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.05 ms |
Preparing | 0.02 ms |
Executing | 0.02 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.04 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | **المتصل** | **الملف ورقم السطر** |
---|
9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
**وقت الإستعلام: 3.59 ms** **قبل آخر إستعلام: 0.20 ms** **إستعلام الذاكرة: 0.004 MB الذاكرة بعد الإستعلام: 1.372 MB**
INSERT INTO `pdu4x_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
(X'3663656235363433323832623263383236346535376636386565626563356130', 1, 1714691806, 0, '', 0)
**التوضيح غير ممكن للإستعلام: INSERT INTO `pdu4x_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'3663656235363433323832623263383236346535376636386565626563356130', 1, 1714691806, 0, '', 0)**
Status | Duration |
---|
Starting | 0.08 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init for update | 0.03 ms |
Update | 0.12 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 3.00 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.02 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | **المتصل** | **الملف ورقم السطر** |
---|
8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Session/MetadataManager.php:116 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
**وقت الإستعلام: 0.70 ms** **قبل آخر إستعلام: 25.09 ms** **إستعلام الذاكرة: 0.021 MB الذاكرة بعد الإستعلام: 1.535 MB** **إرجاع الصفوف: 5**
SELECT id, rules
FROM `pdu4x_viewlevels`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | pdu4x_viewlevels | ALL | NULL | **لا يوجد مفتاح رئيسي يمكن استخدامه** | NULL | NULL | 5 | |
Status | Duration |
---|
Starting | 0.06 ms |
checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.02 ms |
System lock | 0.03 ms |
table lock | 0.02 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.03 ms |
Preparing | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.07 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.02 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | **المتصل** | **الملف ورقم السطر** |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Access/Access.php:1063 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**وقت الإستعلام: 0.84 ms** **قبل آخر إستعلام: 0.22 ms** **إستعلام الذاكرة: 0.021 MB الذاكرة بعد الإستعلام: 1.547 MB** **إرجاع الصفوف: 2**
SELECT b.id
FROM pdu4x_usergroups AS a
LEFT JOIN pdu4x_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | b | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 2 | Using where; Using index |
Status | Duration |
---|
Starting | 0.08 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.10 ms |
Preparing | 0.02 ms |
Unlocking tables | 0.02 ms |
Preparing | 0.04 ms |
Executing | 0.02 ms |
Sending data | 0.05 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.02 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | **المتصل** | **الملف ورقم السطر** |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
10 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:980 |
9 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/Access/Access.php:1095 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**وقت الإستعلام: 0.74 ms** **قبل آخر إستعلام: 121.80 ms** **إستعلام الذاكرة: 0.020 MB الذاكرة بعد الإستعلام: 2.245 MB** **إرجاع الصفوف: 0**
SELECT ip
FROM `pdu4x_cwtraffic_knownips`
WHERE state = 1
AND count = 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | **لا يوجد مفتاح رئيسي يمكن استخدامه** | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
Status | Duration |
---|
Starting | 0.12 ms |
checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.05 ms |
Optimizing | 0.04 ms |
Statistics | 0.05 ms |
Preparing | 0.02 ms |
Executing | 0.03 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.02 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | **المتصل** | **الملف ورقم السطر** |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
9 | JDatabaseDriver->loadColumn() | JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:106 |
8 | plgSystemCwtrafficCount->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**وقت الإستعلام: 0.48 ms** **قبل آخر إستعلام: 0.14 ms** **إستعلام الذاكرة: 0.020 MB الذاكرة بعد الإستعلام: 2.250 MB** **إرجاع الصفوف: 0**
SELECT botname
FROM `pdu4x_cwtraffic_knownips`
WHERE state = 1
AND count = 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | **لا يوجد مفتاح رئيسي يمكن استخدامه** | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
Status | Duration |
---|
Starting | 0.05 ms |
checking permissions | 0.02 ms |
Opening tables | 0.02 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
table lock | 0.02 ms |
init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.03 ms |
Preparing | 0.02 ms |
Executing | 0.02 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | **المتصل** | **الملف ورقم السطر** |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
9 | JDatabaseDriver->loadColumn() | JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:126 |
8 | plgSystemCwtrafficCount->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**وقت الإستعلام: 142.41 ms** **قبل آخر إستعلام: 0.17 ms** **إستعلام الذاكرة: 0.020 MB الذاكرة بعد الإستعلام: 2.255 MB** **إرجاع الصفوف: 1**
SELECT count(*)
FROM `pdu4x_cwtraffic`
WHERE ip = '18.219.236.62'
AND tm + '86400'>'1714691806'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | pdu4x_cwtraffic | index | NULL | unique_tm_ip | 156 | NULL | 219442 | Using where; Using index |
Status | Duration |
---|
Starting | 0.05 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
table lock | 0.02 ms |
init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.03 ms |
Preparing | 0.04 ms |
Executing | 0.02 ms |
Sending data | 141.77 ms |
End of update loop | 0.05 ms |
Query end | 0.02 ms |
Commit | 0.01 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | **المتصل** | **الملف ورقم السطر** |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
9 | JDatabaseDriver->loadResult() | JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:163 |
8 | plgSystemCwtrafficCount->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**وقت الإستعلام: 0.65 ms** **قبل آخر إستعلام: 0.32 ms** **إستعلام الذاكرة: 0.005 MB الذاكرة بعد الإستعلام: 2.260 MB**
INSERT INTO `pdu4x_cwtraffic`
(tm, ip, browser, bversion, platform, referer)
VALUES
('1714691806','18.219.236.62','Mozilla','5.0','unknown','**-**')
**التوضيح غير ممكن للإستعلام: INSERT INTO `pdu4x_cwtraffic`
(tm, ip, browser, bversion, platform, referer) VALUES
('1714691806','18.219.236.62','Mozilla','5.0','unknown','**-**')**
Status | Duration |
---|
Starting | 0.09 ms |
checking permissions | 0.04 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init for update | 0.03 ms |
Update | 0.09 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.05 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | **المتصل** | **الملف ورقم السطر** |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/database.php:33 |
9 | JDatabase->query() | JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:172 |
8 | plgSystemCwtrafficCount->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**وقت الإستعلام: 3366.19 ms** **قبل آخر إستعلام: 0.22 ms** **إستعلام الذاكرة: 0.020 MB الذاكرة بعد الإستعلام: 2.268 MB** **إرجاع الصفوف: 0**
SELECT id,
LEFT( tm, 9 ) , ip, count(*)
FROM `pdu4x_cwtraffic`
GROUP BY
LEFT( tm, 9 ) , ip
HAVING count(*) > 1
LIMIT 50
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | pdu4x_cwtraffic | ALL | NULL | **لا يوجد مفتاح رئيسي يمكن استخدامه** | NULL | NULL | 219442 | Using temporary; **استعمال ترتيب الملفات** |
Status | Duration |
---|
Starting | 0.09 ms |
checking permissions | 0.02 ms |
Opening tables | 0.02 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.05 ms |
Optimizing | 0.03 ms |
Statistics | 0.06 ms |
Preparing | 0.03 ms |
Creating tmp table | 0.06 ms |
Sorting result | 0.03 ms |
Executing | 0.02 ms |
Sending data | 181.37 ms |
Converting HEAP to Aria | 38.69 ms |
Creating index | 0.05 ms |
Repair by sorting | 80.40 ms |
Saving state | 0.05 ms |
Creating index | 0.01 ms |
Converting HEAP to Aria | 0.12 ms |
Sending data | 3023.27 ms |
Creating sort index | 24.52 ms |
Removing tmp table | 16.99 ms |
Creating sort index | 0.03 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.03 ms |
# | **المتصل** | **الملف ورقم السطر** |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
9 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/cwtrafficclean/cwtrafficclean.php:66 |
8 | plgSystemCwtrafficClean->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**وقت الإستعلام: 0.42 ms** **قبل آخر إستعلام: 0.32 ms** **إستعلام الذاكرة: 0.020 MB الذاكرة بعد الإستعلام: 2.272 MB** **إرجاع الصفوف: 1**
SELECT count(*)
FROM `pdu4x_cwtraffic_whoisonline`
WHERE ip = '316402750'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | pdu4x_cwtraffic_whoisonline | const | ip | ip | 8 | const | 1 | Using index |
Status | Duration |
---|
Starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.03 ms |
init | 0.04 ms |
Optimizing | 0.02 ms |
Statistics | 0.03 ms |
Preparing | 0.01 ms |
Executing | 0.01 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.01 ms |
Reset for next command | 0.02 ms |
# | **المتصل** | **الملف ورقم السطر** |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
9 | JDatabaseDriver->loadResult() | JROOT/plugins/system/cwtrafficonline/cwtrafficonline.php:75 |
8 | plgSystemCwtrafficOnline->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**وقت الإستعلام: 0.44 ms** **قبل آخر إستعلام: 0.28 ms** **إستعلام الذاكرة: 0.005 MB الذاكرة بعد الإستعلام: 2.277 MB**
INSERT INTO `pdu4x_cwtraffic_whoisonline`
(ip,country_name, country_code, city, dt)
VALUES
('316402750','unknown country','xx','unknown city',NOW())
**التوضيح غير ممكن للإستعلام: INSERT INTO `pdu4x_cwtraffic_whoisonline`
(ip,country_name, country_code, city, dt) VALUES
('316402750','unknown country','xx','unknown city',NOW())**
Status | Duration |
---|
Starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.01 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init for update | 0.03 ms |
Update | 0.07 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.04 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | **المتصل** | **الملف ورقم السطر** |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/database.php:33 |
9 | JDatabase->query() | JROOT/plugins/system/cwtrafficonline/cwtrafficonline.php:106 |
8 | plgSystemCwtrafficOnline->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**وقت الإستعلام: 0.48 ms** **قبل آخر إستعلام: 0.23 ms** **إستعلام الذاكرة: 0.005 MB الذاكرة بعد الإستعلام: 2.282 MB**
DELETE
FROM `pdu4x_cwtraffic_whoisonline`
WHERE dt < SUBTIME(NOW(),'0 0:10:0')
**التوضيح غير ممكن للإستعلام: DELETE
FROM `pdu4x_cwtraffic_whoisonline`
WHERE dt < SUBTIME(NOW(),'0 0:10:0')**
Status | Duration |
---|
Starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init for update | 0.05 ms |
Updating | 0.13 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.03 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | **المتصل** | **الملف ورقم السطر** |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/database.php:33 |
9 | JDatabase->query() | JROOT/plugins/system/cwtrafficonline/cwtrafficonline.php:120 |
8 | plgSystemCwtrafficOnline->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**وقت الإستعلام: 11.00 ms** **قبل آخر إستعلام: 3.15 ms** **إستعلام الذاكرة: 0.021 MB الذاكرة بعد الإستعلام: 2.304 MB** **إرجاع الصفوف: 1**
SELECT timestamp
FROM pdu4x_zt_visitor_counter
WHERE ipaddress = '18.219.236.62'
AND useragent LIKE "%other%"
ORDER BY timestamp DESC
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | pdu4x_zt_visitor_counter | index | NULL | timestamp | 4 | NULL | 1 | Using where |
Status | Duration |
---|
Starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.02 ms |
Preparing | 0.03 ms |
Sorting result | 0.01 ms |
Executing | 0.01 ms |
Sending data | 10.56 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | **المتصل** | **الملف ورقم السطر** |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
10 | JDatabaseDriver->loadResult() | JROOT/plugins/system/zt_visitor_counter/helper.php:65 |
9 | plgZTVisitorCounterHelper::getLastVisit() | JROOT/plugins/system/zt_visitor_counter/zt_visitor_counter.php:42 |
8 | plgSystemZT_Visitor_Counter->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**وقت الإستعلام: 3.33 ms** **قبل آخر إستعلام: 0.40 ms** **إستعلام الذاكرة: 0.005 MB الذاكرة بعد الإستعلام: 2.308 MB**
INSERT INTO `pdu4x_zt_visitor_counter`
(`id`,`timestamp`,`visits`,`guests`,`ipaddress`,`useragent`)
VALUES
(null, '1714692710', 1 , 1 , '18.219.236.62', 'other')
**التوضيح غير ممكن للإستعلام: INSERT INTO `pdu4x_zt_visitor_counter`
(`id`,`timestamp`,`visits`,`guests`,`ipaddress`,`useragent`) VALUES
(null, '1714692710', 1 , 1 , '18.219.236.62', 'other')**
Status | Duration |
---|
Starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init for update | 0.02 ms |
Update | 0.06 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 3.00 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | **المتصل** | **الملف ورقم السطر** |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/database.php:33 |
10 | JDatabase->query() | JROOT/plugins/system/zt_visitor_counter/helper.php:31 |
9 | plgZTVisitorCounterHelper::addVisits() | JROOT/plugins/system/zt_visitor_counter/zt_visitor_counter.php:46 |
8 | plgSystemZT_Visitor_Counter->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**وقت الإستعلام: 0.39 ms** **قبل آخر إستعلام: 0.38 ms** **إستعلام الذاكرة: 0.021 MB الذاكرة بعد الإستعلام: 2.314 MB** **إرجاع الصفوف: 0**
SELECT c.id
FROM pdu4x_content AS c
WHERE c.catid = '0'
AND c.publish_down != '0000-00-00 00:00:00'
AND c.publish_down <= '2024-05-02 23:16:50'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | c | ref | idx_catid | idx_catid | 4 | const | 1 | Using where |
Status | Duration |
---|
Starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.04 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | **المتصل** | **الملف ورقم السطر** |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/autoarchive/autoarchive.php:113 |
10 | plgSystemAutoArchive->artRead() | JROOT/plugins/system/autoarchive/autoarchive.php:33 |
9 | plgSystemAutoArchive->kat2kat() | JROOT/plugins/system/autoarchive/autoarchive.php:22 |
8 | plgSystemAutoArchive->OnAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**وقت الإستعلام: 0.33 ms** **قبل آخر إستعلام: 0.16 ms** **إستعلام الذاكرة: 0.022 MB الذاكرة بعد الإستعلام: 2.321 MB** **إرجاع الصفوف: 0**
SELECT c.id
FROM pdu4x_content AS c
WHERE c.catid = '0'
AND c.publish_down != '0000-00-00 00:00:00'
AND c.publish_down <= '2024-05-02 23:16:50'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | c | ref | idx_catid | idx_catid | 4 | const | 1 | Using where |
Status | Duration |
---|
Starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.03 ms |
Preparing | 0.02 ms |
Executing | 0.02 ms |
Sending data | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **المتصل** | **الملف ورقم السطر** |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/autoarchive/autoarchive.php:113 |
10 | plgSystemAutoArchive->artRead() | JROOT/plugins/system/autoarchive/autoarchive.php:82 |
9 | plgSystemAutoArchive->kat2other() | JROOT/plugins/system/autoarchive/autoarchive.php:23 |
8 | plgSystemAutoArchive->OnAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**وقت الإستعلام: 0.29 ms** **قبل آخر إستعلام: 0.15 ms** **إستعلام الذاكرة: 0.021 MB الذاكرة بعد الإستعلام: 2.327 MB** **إرجاع الصفوف: 0**
SELECT c.id
FROM pdu4x_content AS c
WHERE c.catid = '0'
AND c.publish_down != '0000-00-00 00:00:00'
AND c.publish_down <= '2024-05-02 23:16:50'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | c | ref | idx_catid | idx_catid | 4 | const | 1 | Using where |
Status | Duration |
---|
Starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.03 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **المتصل** | **الملف ورقم السطر** |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/autoarchive/autoarchive.php:113 |
10 | plgSystemAutoArchive->artRead() | JROOT/plugins/system/autoarchive/autoarchive.php:82 |
9 | plgSystemAutoArchive->kat2other() | JROOT/plugins/system/autoarchive/autoarchive.php:24 |
8 | plgSystemAutoArchive->OnAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**وقت الإستعلام: 0.30 ms** **قبل آخر إستعلام: 0.13 ms** **إستعلام الذاكرة: 0.021 MB الذاكرة بعد الإستعلام: 2.333 MB** **إرجاع الصفوف: 0**
SELECT c.id
FROM pdu4x_content AS c
WHERE c.catid = '0'
AND c.publish_down != '0000-00-00 00:00:00'
AND c.publish_down <= '2024-05-02 23:16:50'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | c | ref | idx_catid | idx_catid | 4 | const | 1 | Using where |
Status | Duration |
---|
Starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.02 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | **المتصل** | **الملف ورقم السطر** |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/autoarchive/autoarchive.php:113 |
10 | plgSystemAutoArchive->artRead() | JROOT/plugins/system/autoarchive/autoarchive.php:82 |
9 | plgSystemAutoArchive->kat2other() | JROOT/plugins/system/autoarchive/autoarchive.php:25 |
8 | plgSystemAutoArchive->OnAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**وقت الإستعلام: 1.32 ms** **قبل آخر إستعلام: 69.35 ms** **إستعلام الذاكرة: 0.025 MB الذاكرة بعد الإستعلام: 3.615 MB** **إرجاع الصفوف: 2**
SHOW FULL COLUMNS
FROM `pdu4x_komento_configs`
**التوضيح غير ممكن للإستعلام: SHOW FULL COLUMNS FROM `pdu4x_komento_configs`**
Status | Duration |
---|
Starting | 0.06 ms |
checking permissions | 0.01 ms |
closing tables | 0.01 ms |
Opening tables | 0.45 ms |
After opening tables | 0.03 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.02 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Filling schema table | 0.02 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
checking permissions | 0.07 ms |
closing tables | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.05 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Removing tmp table | 0.17 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | **المتصل** | **الملف ورقم السطر** |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
17 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:261 |
16 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:180 |
15 | Joomla\CMS\Table\Table->__construct() | JROOT/administrator/components/com_komento/tables/parent.php:18 |
14 | KomentoParentTable->__construct() | JROOT/administrator/components/com_komento/tables/configs.php:40 |
13 | KomentoTableConfigs->__construct() | JROOT/libraries/src/Table/Table.php:328 |
12 | Joomla\CMS\Table\Table::getInstance() | JROOT/administrator/components/com_komento/tables/parent.php:49 |
11 | KomentoParentTable::getInstance() | JROOT/components/com_komento/helpers/helper.php:99 |
10 | Komento::getTable() | JROOT/components/com_komento/helpers/helper.php:228 |
9 | Komento::getKonfig() | JROOT/components/com_komento/bootstrap.php:30 |
8 | require_once JROOT/components/com_komento/bootstrap.php | JROOT/components/com_komento/router.php:16 |
7 | require_once JROOT/components/com_komento/router.php | JROOT/libraries/src/Router/SiteRouter.php:779 |
6 | Joomla\CMS\Router\SiteRouter->getComponentRouter() | JROOT/libraries/src/Router/SiteRouter.php:131 |
5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1142 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**وقت الإستعلام: 0.52 ms** **قبل آخر إستعلام: 1.91 ms** **إستعلام الذاكرة: 0.022 MB الذاكرة بعد الإستعلام: 3.631 MB** **إرجاع الصفوف: 1**
SELECT *
FROM pdu4x_komento_configs
WHERE `component` = 'com_komento'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | pdu4x_komento_configs | ALL | NULL | **لا يوجد مفتاح رئيسي يمكن استخدامه** | NULL | NULL | 5 | Using where |
Status | Duration |
---|
Starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.02 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.05 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | **المتصل** | **الملف ورقم السطر** |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
11 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:747 |
10 | Joomla\CMS\Table\Table->load() | JROOT/components/com_komento/helpers/helper.php:229 |
9 | Komento::getKonfig() | JROOT/components/com_komento/bootstrap.php:30 |
8 | require_once JROOT/components/com_komento/bootstrap.php | JROOT/components/com_komento/router.php:16 |
7 | require_once JROOT/components/com_komento/router.php | JROOT/libraries/src/Router/SiteRouter.php:779 |
6 | Joomla\CMS\Router\SiteRouter->getComponentRouter() | JROOT/libraries/src/Router/SiteRouter.php:131 |
5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1142 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**وقت الإستعلام: 12.55 ms** **قبل آخر إستعلام: 71.79 ms** **إستعلام الذاكرة: 0.006 MB الذاكرة بعد الإستعلام: 4.091 MB**
UPDATE `pdu4x_extensions`
SET `params` = '{\"mediaversion\":\"c38ad2e470c2f21c9e356a00cfbc1718\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
**التوضيح غير ممكن للإستعلام: UPDATE `pdu4x_extensions`
SET `params` = '{\"mediaversion\":\"c38ad2e470c2f21c9e356a00cfbc1718\"}'
WHERE `type` = 'library' AND `element` = 'joomla'**
Status | Duration |
---|
Starting | 0.09 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init for update | 0.12 ms |
Updating | 0.11 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 11.84 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | **المتصل** | **الملف ورقم السطر** |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
13 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
12 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
11 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
10 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
9 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/jmframework/jmframework.php:127 |
8 | plgSystemJMFramework->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**وقت الإستعلام: 0.96 ms** **قبل آخر إستعلام: 65.89 ms** **إستعلام الذاكرة: 0.022 MB الذاكرة بعد الإستعلام: 4.376 MB** **إرجاع الصفوف: 1**
SELECT cc.id, cc.title, cc.alias, cc.access as cataccess, cc.accessuserid as cataccessuserid, cc.description, cc.metakey, cc.metadesc, pc.title as parenttitle, cc.parent_id as parentid, pc.alias as parentalias
FROM pdu4x_phocadownload_categories AS cc
LEFT JOIN pdu4x_phocadownload_categories AS pc
ON pc.id = cc.parent_id
WHERE cc.id= 157
AND cc.access IN (1,1,5)
AND cc.published = 1
AND cc.language IN ('ar-AA','*')
ORDER BY cc.ordering
LIMIT 0, 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | cc | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | pc | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
Starting | 0.16 ms |
checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.07 ms |
Optimizing | 0.04 ms |
Statistics | 0.11 ms |
Preparing | 0.02 ms |
Unlocking tables | 0.03 ms |
Preparing | 0.03 ms |
Executing | 0.02 ms |
Sending data | 0.04 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.02 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | **المتصل** | **الملف ورقم السطر** |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
12 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/components/com_phocadownload/models/category.php:88 |
11 | PhocaDownloadModelCategory->getCategory() | JROOT/components/com_phocadownload/views/category/view.html.php:41 |
10 | PhocaDownloadViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_phocadownload/controller.php:34 |
8 | PhocaDownloadController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_phocadownload/phocadownload.php:56 |
6 | require_once JROOT/components/com_phocadownload/phocadownload.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**وقت الإستعلام: 2.09 ms** **قبل آخر إستعلام: 1.45 ms** **إستعلام الذاكرة: 0.022 MB الذاكرة بعد الإستعلام: 4.384 MB** **إرجاع الصفوف: 0**
SELECT cc.id, cc.title, cc.alias, cc.access as cataccess, cc.accessuserid as cataccessuserid, COUNT(c.id) AS numdoc
FROM pdu4x_phocadownload_categories AS cc
LEFT JOIN pdu4x_phocadownload AS c
ON c.catid = cc.id
AND c.published = 1
AND c.textonly = 0
WHERE cc.parent_id = 157
AND cc.access IN (1,1,5)
AND cc.published = 1
AND cc.language IN ('ar-AA','*')
GROUP BY cc.id, cc.title, cc.alias, cc.access, cc.accessuserid
ORDER BY cc.ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | cc | ALL | idx_access | **لا يوجد مفتاح رئيسي يمكن استخدامه** | NULL | NULL | 159 | Using where; Using temporary; **استعمال ترتيب الملفات** |
1 | SIMPLE | c | ref | catid | catid | 5 | javanma2_asli.cc.id,const | 4 | Using where |
Status | Duration |
---|
Starting | 0.15 ms |
checking permissions | 0.02 ms |
Opening tables | 0.05 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.08 ms |
Optimizing | 0.05 ms |
Statistics | 0.10 ms |
Preparing | 0.06 ms |
Creating tmp table | 0.07 ms |
Sorting result | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.81 ms |
Creating sort index | 0.05 ms |
Removing tmp table | 0.17 ms |
Creating sort index | 0.03 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.03 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.03 ms |
Updating status | 0.04 ms |
Reset for next command | 0.02 ms |
# | **المتصل** | **الملف ورقم السطر** |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
12 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/components/com_phocadownload/models/category.php:96 |
11 | PhocaDownloadModelCategory->getSubcategories() | JROOT/components/com_phocadownload/views/category/view.html.php:42 |
10 | PhocaDownloadViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_phocadownload/controller.php:34 |
8 | PhocaDownloadController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_phocadownload/phocadownload.php:56 |
6 | require_once JROOT/components/com_phocadownload/phocadownload.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**وقت الإستعلام: 2.43 ms** **قبل آخر إستعلام: 0.26 ms** **إستعلام الذاكرة: 0.024 MB الذاكرة بعد الإستعلام: 4.392 MB** **إرجاع الصفوف: 0**
SELECT c.*, cc.id AS categoryid, cc.title AS categorytitle, cc.alias AS categoryalias, cc.access as cataccess, cc.accessuserid as cataccessuserid
FROM pdu4x_phocadownload AS c
LEFT JOIN pdu4x_phocadownload_categories AS cc
ON cc.id = c.catid
LEFT JOIN pdu4x_phocadownload_file_votes_statistics AS r
ON r.fileid = c.id
WHERE c.catid= 157
AND ( (unaccessible_file = 1 ) OR (unaccessible_file = 0
AND c.access IN (1,1,5) ) )
AND ( (unaccessible_file = 1 ) OR (unaccessible_file = 0
AND cc.access IN (1,1,5) ) )
AND c.published = 1
AND c.approved = 1
AND cc.published = 1
AND c.language IN ('ar-AA','*')
AND cc.language IN ('ar-AA','*')
AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2024-05-02 23:16:50' )
AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2024-05-02 23:16:50' )
ORDER BY c.ordering ASC
LIMIT 0, 20
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | cc | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | Using temporary; **استعمال ترتيب الملفات** |
1 | SIMPLE | c | ref | catid | catid | 5 | const,const | 1 | Using where |
1 | SIMPLE | r | ALL | NULL | **لا يوجد مفتاح رئيسي يمكن استخدامه** | NULL | NULL | 1 | Using where; Using join buffer (flat, BNL join) |
Status | Duration |
---|
Starting | 0.23 ms |
checking permissions | 0.03 ms |
Opening tables | 0.05 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.12 ms |
Optimizing | 0.09 ms |
Statistics | 0.14 ms |
Preparing | 0.02 ms |
Unlocking tables | 0.01 ms |
Preparing | 0.08 ms |
Creating tmp table | 0.13 ms |
Sorting result | 0.05 ms |
Executing | 0.02 ms |
Sending data | 0.81 ms |
Creating sort index | 0.06 ms |
Removing tmp table | 0.15 ms |
Creating sort index | 0.02 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.03 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | **المتصل** | **الملف ورقم السطر** |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
12 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/components/com_phocadownload/models/category.php:80 |
11 | PhocaDownloadModelCategory->getFileList() | JROOT/components/com_phocadownload/views/category/view.html.php:43 |
10 | PhocaDownloadViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_phocadownload/controller.php:34 |
8 | PhocaDownloadController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_phocadownload/phocadownload.php:56 |
6 | require_once JROOT/components/com_phocadownload/phocadownload.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**وقت الإستعلام: 1.05 ms** **قبل آخر إستعلام: 4.79 ms** **إستعلام الذاكرة: 0.022 MB الذاكرة بعد الإستعلام: 4.480 MB** **إرجاع الصفوف: 0**
SELECT c.id
FROM pdu4x_phocadownload AS c
LEFT JOIN pdu4x_phocadownload_categories AS cc
ON cc.id = c.catid
WHERE c.catid= 157
AND ( (unaccessible_file = 1 ) OR (unaccessible_file = 0
AND c.access IN (1,1,5) ) )
AND ( (unaccessible_file = 1 ) OR (unaccessible_file = 0
AND cc.access IN (1,1,5) ) )
AND c.published = 1
AND c.approved = 1
AND cc.published = 1
AND c.language IN ('ar-AA','*')
AND cc.language IN ('ar-AA','*')
AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2024-05-02 23:16:50' )
AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2024-05-02 23:16:50' )
ORDER BY c.id
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | cc | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | c | ref | catid | catid | 5 | const,const | 1 | Using where |
Status | Duration |
---|
Starting | 0.14 ms |
checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.08 ms |
Optimizing | 0.08 ms |
Statistics | 0.12 ms |
Preparing | 0.02 ms |
Unlocking tables | 0.01 ms |
Preparing | 0.08 ms |
Sorting result | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.05 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.02 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.03 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | **المتصل** | **الملف ورقم السطر** |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:367 |
13 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() | JROOT/components/com_phocadownload/models/category.php:72 |
12 | PhocaDownloadModelCategory->getTotal() | JROOT/components/com_phocadownload/models/category.php:64 |
11 | PhocaDownloadModelCategory->getPagination() | JROOT/components/com_phocadownload/views/category/view.html.php:44 |
10 | PhocaDownloadViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_phocadownload/controller.php:34 |
8 | PhocaDownloadController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_phocadownload/phocadownload.php:56 |
6 | require_once JROOT/components/com_phocadownload/phocadownload.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**وقت الإستعلام: 0.74 ms** **قبل آخر إستعلام: 2.74 ms** **إستعلام الذاكرة: 0.022 MB الذاكرة بعد الإستعلام: 4.486 MB** **إرجاع الصفوف: 3**
SELECT a.filename as filename, a.type as type, a.menulink as menulink
FROM pdu4x_phocadownload_styles AS a
WHERE a.published = 1
ORDER BY a.type, a.ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ALL | NULL | **لا يوجد مفتاح رئيسي يمكن استخدامه** | NULL | NULL | 6 | Using where; **استعمال ترتيب الملفات** |
Status | Duration |
---|
Starting | 0.08 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.03 ms |
Preparing | 0.03 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
Creating sort index | 0.08 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.02 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | **المتصل** | **الملف ورقم السطر** |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_phocadownload/libraries/phocadownload/render/renderfront.php:22 |
11 | PhocaDownloadRenderFront::renderAllCSS() | JROOT/components/com_phocadownload/views/category/view.html.php:46 |
10 | PhocaDownloadViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_phocadownload/controller.php:34 |
8 | PhocaDownloadController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_phocadownload/phocadownload.php:56 |
6 | require_once JROOT/components/com_phocadownload/phocadownload.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**وقت الإستعلام: 1.56 ms** **قبل آخر إستعلام: 32.21 ms** **إستعلام الذاكرة: 0.021 MB الذاكرة بعد الإستعلام: 4.541 MB** **إرجاع الصفوف: 5**
SELECT language,id
FROM `pdu4x_menu`
WHERE home = 1
AND published = 1
AND client_id = 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | pdu4x_menu | ALL | idx_client_id_parent_id_alias_language | **لا يوجد مفتاح رئيسي يمكن استخدامه** | NULL | NULL | 916 | Using where |
Status | Duration |
---|
Starting | 0.09 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.07 ms |
Preparing | 0.04 ms |
Executing | 0.02 ms |
Sending data | 0.85 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.02 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | **المتصل** | **الملف ورقم السطر** |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
9 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/Multilanguage.php:107 |
8 | Joomla\CMS\Language\Multilanguage::getSiteHomePages() | JROOT/plugins/system/languagefilter/languagefilter.php:751 |
7 | PlgSystemLanguageFilter->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:70 |
6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/SiteApplication.php:199 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**وقت الإستعلام: 0.74 ms** **قبل آخر إستعلام: 32.69 ms** **إستعلام الذاكرة: 0.026 MB الذاكرة بعد الإستعلام: 4.870 MB** **إرجاع الصفوف: 1**
SELECT TCOUNT
FROM `pdu4x_cwtraffic_total`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | pdu4x_cwtraffic_total | system | NULL | **لا يوجد مفتاح رئيسي يمكن استخدامه** | NULL | NULL | 1 | |
Status | Duration |
---|
Starting | 0.09 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.04 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.02 ms |
Preparing | 0.03 ms |
Executing | 0.02 ms |
Sending data | 0.03 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.03 ms |
Reset for next command | 0.03 ms |
# | **المتصل** | **الملف ورقم السطر** |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
19 | JDatabaseDriver->loadResult() | JROOT/modules/mod_coalawebtraffic/helper.php:80 |
18 | mod_coalawebtrafficHelper->read() | JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php:69 |
17 | include JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
15 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/plugins/system/jmframework/includes/libraries/template.php:429 |
14 | JMFTemplate->renderModules() | JROOT/plugins/system/jmframework/includes/libraries/template.php:563 |
13 | JMFTemplate->renderFlexiblock() | JROOT/templates/jm-services/tpl/blocks/footer-mod.php:16 |
12 | include JROOT/templates/jm-services/tpl/blocks/footer-mod.php | JROOT/plugins/system/jmframework/includes/libraries/template.php:386 |
11 | JMFTemplate->renderBlock() | JROOT/templates/jm-services/tpl/default.php:38 |
10 | include JROOT/templates/jm-services/tpl/default.php | JROOT/plugins/system/jmframework/includes/libraries/template.php:386 |
9 | JMFTemplate->renderBlock() | JROOT/plugins/system/jmframework/includes/libraries/template.php:393 |
8 | JMFTemplate->renderScheme() | JROOT/templates/jm-services/index.php:19 |
7 | require JROOT/templates/jm-services/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**وقت الإستعلام: 0.46 ms** **قبل آخر إستعلام: 0.15 ms** **إستعلام الذاكرة: 0.026 MB الذاكرة بعد الإستعلام: 4.880 MB** **إرجاع الصفوف: 1**
SELECT count(*)
FROM `pdu4x_cwtraffic`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | **لا يوجد مفتاح رئيسي يمكن استخدامه** | NULL | NULL | NULL | Select tables optimized away |
Status | Duration |
---|
Starting | 0.04 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
table lock | 0.02 ms |
init | 0.02 ms |
Optimizing | 0.02 ms |
Executing | 0.02 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | **المتصل** | **الملف ورقم السطر** |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
19 | JDatabaseDriver->loadResult() | JROOT/modules/mod_coalawebtraffic/helper.php:87 |
18 | mod_coalawebtrafficHelper->read() | JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php:69 |
17 | include JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
15 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/plugins/system/jmframework/includes/libraries/template.php:429 |
14 | JMFTemplate->renderModules() | JROOT/plugins/system/jmframework/includes/libraries/template.php:563 |
13 | JMFTemplate->renderFlexiblock() | JROOT/templates/jm-services/tpl/blocks/footer-mod.php:16 |
12 | include JROOT/templates/jm-services/tpl/blocks/footer-mod.php | JROOT/plugins/system/jmframework/includes/libraries/template.php:386 |
11 | JMFTemplate->renderBlock() | JROOT/templates/jm-services/tpl/default.php:38 |
10 | include JROOT/templates/jm-services/tpl/default.php | JROOT/plugins/system/jmframework/includes/libraries/template.php:386 |
9 | JMFTemplate->renderBlock() | JROOT/plugins/system/jmframework/includes/libraries/template.php:393 |
8 | JMFTemplate->renderScheme() | JROOT/templates/jm-services/index.php:19 |
7 | require JROOT/templates/jm-services/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**وقت الإستعلام: 0.72 ms** **قبل آخر إستعلام: 0.19 ms** **إستعلام الذاكرة: 0.026 MB الذاكرة بعد الإستعلام: 4.891 MB** **إرجاع الصفوف: 1**
SELECT count(*)
FROM `pdu4x_cwtraffic`
WHERE tm > '1714681800'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | pdu4x_cwtraffic | range | unique_tm_ip | unique_tm_ip | 4 | NULL | 27 | Using where; Using index |
Status | Duration |
---|
Starting | 0.05 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
table lock | 0.02 ms |
init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.09 ms |
Preparing | 0.04 ms |
Executing | 0.02 ms |
Sending data | 0.11 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | **المتصل** | **الملف ورقم السطر** |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
19 | JDatabaseDriver->loadResult() | JROOT/modules/mod_coalawebtraffic/helper.php:97 |
18 | mod_coalawebtrafficHelper->read() | JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php:69 |
17 | include JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
15 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/plugins/system/jmframework/includes/libraries/template.php:429 |
14 | JMFTemplate->renderModules() | JROOT/plugins/system/jmframework/includes/libraries/template.php:563 |
13 | JMFTemplate->renderFlexiblock() | JROOT/templates/jm-services/tpl/blocks/footer-mod.php:16 |
12 | include JROOT/templates/jm-services/tpl/blocks/footer-mod.php | JROOT/plugins/system/jmframework/includes/libraries/template.php:386 |
11 | JMFTemplate->renderBlock() | JROOT/templates/jm-services/tpl/default.php:38 |
10 | include JROOT/templates/jm-services/tpl/default.php | JROOT/plugins/system/jmframework/includes/libraries/template.php:386 |
9 | JMFTemplate->renderBlock() | JROOT/plugins/system/jmframework/includes/libraries/template.php:393 |
8 | JMFTemplate->renderScheme() | JROOT/templates/jm-services/index.php:19 |
7 | require JROOT/templates/jm-services/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**وقت الإستعلام: 0.94 ms** **قبل آخر إستعلام: 0.19 ms** **إستعلام الذاكرة: 0.026 MB الذاكرة بعد الإستعلام: 4.901 MB** **إرجاع الصفوف: 1**
SELECT count(*)
FROM `pdu4x_cwtraffic`
WHERE tm > '1714595400'
AND tm < '1714681800'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | pdu4x_cwtraffic | range | unique_tm_ip | unique_tm_ip | 4 | NULL | 119 | Using where; Using index |
Status | Duration |
---|
Starting | 0.05 ms |
checking permissions | 0.02 ms |
Opening tables | 0.02 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
table lock | 0.02 ms |
init | 0.03 ms |
Optimizing | 0.04 ms |
Statistics | 0.09 ms |
Preparing | 0.03 ms |
Executing | 0.02 ms |
Sending data | 0.33 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | **المتصل** | **الملف ورقم السطر** |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
19 | JDatabaseDriver->loadResult() | JROOT/modules/mod_coalawebtraffic/helper.php:106 |
18 | mod_coalawebtrafficHelper->read() | JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php:69 |
17 | include JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
15 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/plugins/system/jmframework/includes/libraries/template.php:429 |
14 | JMFTemplate->renderModules() | JROOT/plugins/system/jmframework/includes/libraries/template.php:563 |
13 | JMFTemplate->renderFlexiblock() | JROOT/templates/jm-services/tpl/blocks/footer-mod.php:16 |
12 | include JROOT/templates/jm-services/tpl/blocks/footer-mod.php | JROOT/plugins/system/jmframework/includes/libraries/template.php:386 |
11 | JMFTemplate->renderBlock() | JROOT/templates/jm-services/tpl/default.php:38 |
10 | include JROOT/templates/jm-services/tpl/default.php | JROOT/plugins/system/jmframework/includes/libraries/template.php:386 |
9 | JMFTemplate->renderBlock() | JROOT/plugins/system/jmframework/includes/libraries/template.php:393 |
8 | JMFTemplate->renderScheme() | JROOT/templates/jm-services/index.php:19 |
7 | require JROOT/templates/jm-services/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**وقت الإستعلام: 1.88 ms** **قبل آخر إستعلام: 0.19 ms** **إستعلام الذاكرة: 0.027 MB الذاكرة بعد الإستعلام: 4.918 MB** **إرجاع الصفوف: 1**
SELECT count(*)
FROM `pdu4x_cwtraffic`
WHERE tm >= '1714163400'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | pdu4x_cwtraffic | range | unique_tm_ip | unique_tm_ip | 4 | NULL | 753 | Using where; Using index |
Status | Duration |
---|
Starting | 0.04 ms |
checking permissions | 0.03 ms |
Opening tables | 0.02 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
table lock | 0.02 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.06 ms |
Preparing | 0.03 ms |
Executing | 0.01 ms |
Sending data | 1.32 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | **المتصل** | **الملف ورقم السطر** |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
19 | JDatabaseDriver->loadResult() | JROOT/modules/mod_coalawebtraffic/helper.php:114 |
18 | mod_coalawebtrafficHelper->read() | JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php:69 |
17 | include JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
15 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/plugins/system/jmframework/includes/libraries/template.php:429 |
14 | JMFTemplate->renderModules() | JROOT/plugins/system/jmframework/includes/libraries/template.php:563 |
13 | JMFTemplate->renderFlexiblock() | JROOT/templates/jm-services/tpl/blocks/footer-mod.php:16 |
12 | include JROOT/templates/jm-services/tpl/blocks/footer-mod.php | JROOT/plugins/system/jmframework/includes/libraries/template.php:386 |
11 | JMFTemplate->renderBlock() | JROOT/templates/jm-services/tpl/default.php:38 |
10 | include JROOT/templates/jm-services/tpl/default.php | JROOT/plugins/system/jmframework/includes/libraries/template.php:386 |
9 | JMFTemplate->renderBlock() | JROOT/plugins/system/jmframework/includes/libraries/template.php:393 |
8 | JMFTemplate->renderScheme() | JROOT/templates/jm-services/index.php:19 |
7 | require JROOT/templates/jm-services/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**وقت الإستعلام: 1.05 ms** **قبل آخر إستعلام: 0.18 ms** **إستعلام الذاكرة: 0.026 MB الذاكرة بعد الإستعلام: 4.930 MB** **إرجاع الصفوف: 1**
SELECT count(*)
FROM `pdu4x_cwtraffic`
WHERE tm >= '1714509000'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | pdu4x_cwtraffic | range | unique_tm_ip | unique_tm_ip | 4 | NULL | 232 | Using where; Using index |
Status | Duration |
---|
Starting | 0.04 ms |
checking permissions | 0.02 ms |
Opening tables | 0.02 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
table lock | 0.02 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.06 ms |
Preparing | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.49 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | **المتصل** | **الملف ورقم السطر** |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
19 | JDatabaseDriver->loadResult() | JROOT/modules/mod_coalawebtraffic/helper.php:122 |
18 | mod_coalawebtrafficHelper->read() | JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php:69 |
17 | include JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
15 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/plugins/system/jmframework/includes/libraries/template.php:429 |
14 | JMFTemplate->renderModules() | JROOT/plugins/system/jmframework/includes/libraries/template.php:563 |
13 | JMFTemplate->renderFlexiblock() | JROOT/templates/jm-services/tpl/blocks/footer-mod.php:16 |
12 | include JROOT/templates/jm-services/tpl/blocks/footer-mod.php | JROOT/plugins/system/jmframework/includes/libraries/template.php:386 |
11 | JMFTemplate->renderBlock() | JROOT/templates/jm-services/tpl/default.php:38 |
10 | include JROOT/templates/jm-services/tpl/default.php | JROOT/plugins/system/jmframework/includes/libraries/template.php:386 |
9 | JMFTemplate->renderBlock() | JROOT/plugins/system/jmframework/includes/libraries/template.php:393 |
8 | JMFTemplate->renderScheme() | JROOT/templates/jm-services/index.php:19 |
7 | require JROOT/templates/jm-services/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**وقت الإستعلام: 0.52 ms** **قبل آخر إستعلام: 0.43 ms** **إستعلام الذاكرة: 0.026 MB الذاكرة بعد الإستعلام: 4.948 MB** **إرجاع الصفوف: 1**
SELECT count(*)
FROM `pdu4x_cwtraffic_whoisonline`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | **لا يوجد مفتاح رئيسي يمكن استخدامه** | NULL | NULL | NULL | Select tables optimized away |
Status | Duration |
---|
Starting | 0.06 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.02 ms |
Optimizing | 0.03 ms |
Executing | 0.02 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.02 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | **المتصل** | **الملف ورقم السطر** |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
19 | JDatabaseDriver->loadResult() | JROOT/modules/mod_coalawebtraffic/helper.php:137 |
18 | mod_coalawebtrafficHelper::getRealCount() | JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php:124 |
17 | include JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
15 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/plugins/system/jmframework/includes/libraries/template.php:429 |
14 | JMFTemplate->renderModules() | JROOT/plugins/system/jmframework/includes/libraries/template.php:563 |
13 | JMFTemplate->renderFlexiblock() | JROOT/templates/jm-services/tpl/blocks/footer-mod.php:16 |
12 | include JROOT/templates/jm-services/tpl/blocks/footer-mod.php | JROOT/plugins/system/jmframework/includes/libraries/template.php:386 |
11 | JMFTemplate->renderBlock() | JROOT/templates/jm-services/tpl/default.php:38 |
10 | include JROOT/templates/jm-services/tpl/default.php | JROOT/plugins/system/jmframework/includes/libraries/template.php:386 |
9 | JMFTemplate->renderBlock() | JROOT/plugins/system/jmframework/includes/libraries/template.php:393 |
8 | JMFTemplate->renderScheme() | JROOT/templates/jm-services/index.php:19 |
7 | require JROOT/templates/jm-services/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**وقت الإستعلام: 0.86 ms** **قبل آخر إستعلام: 0.19 ms** **إستعلام الذاكرة: 0.026 MB الذاكرة بعد الإستعلام: 4.960 MB** **إرجاع الصفوف: 1**
SELECT a.country_code, a.country_name, COUNT(1) as num
FROM `pdu4x_cwtraffic_whoisonline` AS `a`
WHERE `a`.`country_code` IS NOT NULL
GROUP BY a.country_code, a.country_name
ORDER BY `num` DESC
LIMIT 5
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ALL | countrycode | **لا يوجد مفتاح رئيسي يمكن استخدامه** | NULL | NULL | 7 | Using where; Using temporary; **استعمال ترتيب الملفات** |
Status | Duration |
---|
Starting | 0.08 ms |
checking permissions | 0.02 ms |
Opening tables | 0.02 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
table lock | 0.02 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.04 ms |
Preparing | 0.03 ms |
Creating tmp table | 0.06 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.12 ms |
Creating sort index | 0.04 ms |
Removing tmp table | 0.02 ms |
Creating sort index | 0.02 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | **المتصل** | **الملف ورقم السطر** |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
19 | JDatabaseDriver->loadObjectList() | JROOT/modules/mod_coalawebtraffic/helper.php:153 |
18 | mod_coalawebtrafficHelper::getCountries() | JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php:125 |
17 | include JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
15 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/plugins/system/jmframework/includes/libraries/template.php:429 |
14 | JMFTemplate->renderModules() | JROOT/plugins/system/jmframework/includes/libraries/template.php:563 |
13 | JMFTemplate->renderFlexiblock() | JROOT/templates/jm-services/tpl/blocks/footer-mod.php:16 |
12 | include JROOT/templates/jm-services/tpl/blocks/footer-mod.php | JROOT/plugins/system/jmframework/includes/libraries/template.php:386 |
11 | JMFTemplate->renderBlock() | JROOT/templates/jm-services/tpl/default.php:38 |
10 | include JROOT/templates/jm-services/tpl/default.php | JROOT/plugins/system/jmframework/includes/libraries/template.php:386 |
9 | JMFTemplate->renderBlock() | JROOT/plugins/system/jmframework/includes/libraries/template.php:393 |
8 | JMFTemplate->renderScheme() | JROOT/templates/jm-services/index.php:19 |
7 | require JROOT/templates/jm-services/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**وقت الإستعلام: 0.78 ms** **قبل آخر إستعلام: 21.93 ms** **إستعلام الذاكرة: 0.023 MB الذاكرة بعد الإستعلام: 4.968 MB** **إرجاع الصفوف: 0**
SELECT `c2`.`language`,`c2`.`id`
FROM `pdu4x_menu` AS `c`
INNER JOIN `pdu4x_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `pdu4x_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `pdu4x_menu` AS `c2`
ON a2.id = c2.`id`
WHERE c.id = 964
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | **لا يوجد مفتاح رئيسي يمكن استخدامه** | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
Status | Duration |
---|
Starting | 0.10 ms |
checking permissions | 0.02 ms |
Opening tables | 0.05 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.05 ms |
Optimizing | 0.05 ms |
Statistics | 0.12 ms |
Preparing | 0.02 ms |
Executing | 0.03 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.02 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | **المتصل** | **الملف ورقم السطر** |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/Associations.php:115 |
13 | Joomla\CMS\Language\Associations::getAssociations() | JROOT/administrator/components/com_menus/helpers/menus.php:321 |
12 | MenusHelper::getAssociations() | JROOT/modules/mod_languages/helper.php:58 |
11 | ModLanguagesHelper::getList() | JROOT/modules/mod_languages/mod_languages.php:17 |
10 | include JROOT/modules/mod_languages/mod_languages.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**5 × SELECT count(*)
FROM `pdu4x_cwtraffic` **
**4 × SELECT c.id
FROM pdu4x_content AS c **
**1 × SELECT `data`
FROM `pdu4x_session` **
**1 × SELECT cc.id, cc.title, cc.alias, cc.access as cataccess, cc.accessuserid as cataccessuserid, COUNT(c.id) AS numdoc
FROM pdu4x_phocadownload_categories AS cc
LEFT JOIN pdu4x_phocadownload AS c
ON c.catid = cc.id
AND c.published = 1
AND c.textonly = 0 **
**1 × SELECT a.country_code, a.country_name, COUNT(1) as num
FROM `pdu4x_cwtraffic_whoisonline` AS `a` **
**1 × SELECT count(*)
FROM `pdu4x_cwtraffic_whoisonline **
**1 × SELECT count(*)
FROM `pdu4x_cwtraffic **
**1 × SELECT TCOUNT
FROM `pdu4x_cwtraffic_total **
**1 × SELECT language,id
FROM `pdu4x_menu` **
**1 × SELECT a.filename as filename, a.type as type, a.menulink as menulink
FROM pdu4x_phocadownload_styles AS a **
**1 × SELECT c.id
FROM pdu4x_phocadownload AS c
LEFT JOIN pdu4x_phocadownload_categories AS cc
ON cc.id = c.catid **
**1 × SELECT c.*, cc.id AS categoryid, cc.title AS categorytitle, cc.alias AS categoryalias, cc.access as cataccess, cc.accessuserid as cataccessuserid
FROM pdu4x_phocadownload AS c
LEFT JOIN pdu4x_phocadownload_categories AS cc
ON cc.id = c.catid
LEFT JOIN pdu4x_phocadownload_file_votes_statistics AS r
ON r.fileid = c.id **
**1 × SELECT *
FROM pdu4x_komento_configs **
**1 × SELECT cc.id, cc.title, cc.alias, cc.access as cataccess, cc.accessuserid as cataccessuserid, cc.description, cc.metakey, cc.metadesc, pc.title as parenttitle, cc.parent_id as parentid, pc.alias as parentalias
FROM pdu4x_phocadownload_categories AS cc
LEFT JOIN pdu4x_phocadownload_categories AS pc
ON pc.id = cc.parent_id **
**1 × SELECT `session_id`
FROM `pdu4x_session` **
**1 × SELECT timestamp
FROM pdu4x_zt_visitor_counter **
**1 × SELECT count(*)
FROM `pdu4x_cwtraffic_whoisonline` **
**1 × SELECT id,
LEFT( tm, 9 ) , ip, count(*)
FROM `pdu4x_cwtraffic`
GROUP BY
LEFT( tm, 9 ) , ip
HAVING count(*) > 1
LIMIT 5 **
**1 × SELECT botname
FROM `pdu4x_cwtraffic_knownips` **
**1 × SELECT ip
FROM `pdu4x_cwtraffic_knownips` **
**1 × SELECT b.id
FROM pdu4x_usergroups AS a
LEFT JOIN pdu4x_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt **
**1 × SELECT id, rules
FROM `pdu4x_viewlevels **
**1 × SELECT `c2`.`language`,`c2`.`id`
FROM `pdu4x_menu` AS `c`
INNER JOIN `pdu4x_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `pdu4x_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `pdu4x_menu` AS `c2`
ON a2.id = c2.`id` **