El proyecto de la familia política de Lio Messi se levantará sobre Ruta 9 e incluirá locales comerciales, una clínica de rehabilitación y una escuela primaria.
La Defensoría del Pueblo informó los requisitos de validez de multas de tránsito.
El histórico cantante y acordeonista de Los Palmeras anunció su alejamiento del grupo tras más de 50 años arriba de los escenarios y explicó los motivos de su decisión en un video que conmovió a los fans.
El Gobierno buscará avanzar con la media sanción del proyecto que modifica el régimen penal, con el respaldo del PRO, la UCR, el MID y bloques provinciales aliados.
Más de 600 adultos mayores de distintas localidades de la región fueron parte de este encuentro organizado por la Municipalidad de Villa Gobernador Gálvez donde disfrutaron de actividades recreativas y deportivas en las diferentes instalaciones que ofrece el predio.
En una sesión maratónica, este jueves a la madrugada, la Cámara alta aprobó la "Ley de Modernización Laboral" con 42 votos a favor, 30 en contra y sin abstenciones.
Según el informe de Proyección Consultores, la inseguridad encabeza la lista con el 46,5%, seguida por los bajos ingresos personales o familiares (43,9%) y la inflación (34,8 %).
Template Settings
وحدة تحكم تشخيص الأخطاء لجوملا!
{
"__default": {
"session": {
"counter": 2,
"timer": {
"start": 1787828997,
"last": 1787828997,
"now": 1787828998
},
"token": "FHaacgnhEUlMNimiE3jomk4Y9lVDu3Jb"
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
},
"plg_system_languagefilter": {
"language": "ar-AA"
}
}
}
الوقت
الذاكرة
الوقت: 7.48 ms / 7.48 ms الذاكرة: 0.408 MB / 0.76 MB Application: afterLoad
الوقت: 49.82 ms / 57.31 ms الذاكرة: 1.932 MB / 2.69 MB Application: afterInitialise
الوقت: 22.42 ms / 79.73 ms الذاكرة: 0.898 MB / 3.59 MB Application: afterRoute
الوقت: 1.03 ms / 80.76 ms الذاكرة: 0.206 MB / 3.79 MB Application: beforeRenderComponent com_k2
الوقت: 0.27 ms / 81.03 ms الذاكرة: 0.019 MB / 3.81 MB Application: Before Access::preloadComponents (all components)
الوقت: 0.87 ms / 81.90 ms الذاكرة: 0.055 MB / 3.87 MB Application: After Access::preloadComponents (all components)
الوقت: 0.03 ms / 81.93 ms الذاكرة: -0.003 MB / 3.86 MB Application: Before Access::getAssetRules (id:647 name:com_k2)
الوقت: 0.44 ms / 82.38 ms الذاكرة: 0.008 MB / 3.87 MB Application: After Access::getAssetRules (id:647 name:com_k2)
الوقت: 1234.39 ms / 1316.77 ms الذاكرة: 7.852 MB / 11.72 MB Application: afterRenderComponent com_k2
الوقت: 9.56 ms / 1326.33 ms الذاكرة: 0.024 MB / 11.75 MB Application: afterDispatch
الوقت: 26.41 ms / 1352.74 ms الذاكرة: 0.865 MB / 12.61 MB Application: beforeRenderModule mod_custom (Accessories)
الوقت: 5.54 ms / 1358.28 ms الذاكرة: 0.026 MB / 12.64 MB Application: afterRenderModule mod_custom (Accessories)
الوقت: 0.05 ms / 1358.33 ms الذاكرة: 0.004 MB / 12.64 MB Application: beforeRenderModule mod_sj_k2_mega_news (Mega list)
الوقت: 4.71 ms / 1363.04 ms الذاكرة: 0.214 MB / 12.85 MB Application: afterRenderModule mod_sj_k2_mega_news (Mega list)
الوقت: 27.60 ms / 1390.65 ms الذاكرة: -0.409 MB / 12.45 MB Application: beforeRenderModule mod_sj_k2_extra_slider (Slider Pie de Pagina)
الوقت: 6.26 ms / 1396.90 ms الذاكرة: 0.131 MB / 12.58 MB Application: afterRenderModule mod_sj_k2_extra_slider (Slider Pie de Pagina)
الوقت: 39.38 ms / 1436.28 ms الذاكرة: 0.141 MB / 12.72 MB Application: afterRender
كافة إستعلامات قاعدة البيانات: 234.22 ms
13.21 MB (13,850,936 بايت (Bytes))
45 الاستعلامات المسجلة 234.22 ms
20 تكرار موجود!
- وقت الإستعلام: 0.52 ms إستعلام الذاكرة: 0.023 MB الذاكرة بعد الإستعلام: 1.036 MB إرجاع الصفوف: 1
SELECT `data`
FROM `c2081958_session`
WHERE `session_id` = X'7539696d336564376a6d616e6d72727363686175336935613163'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c2081958_session NULL const PRIMARY PRIMARY 194 const 1 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Same as call in the line below. 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.36 ms قبل آخر إستعلام: 3.09 ms إستعلام الذاكرة: 0.021 MB الذاكرة بعد الإستعلام: 1.134 MB إرجاع الصفوف: 5
SELECT id, rules
FROM `c2081958_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c2081958_viewlevels NULL ALL NULL لا يوجد مفتاح رئيسي يمكن استخدامه NULL NULL 5 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 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.48 ms قبل آخر إستعلام: 0.08 ms إستعلام الذاكرة: 0.021 MB الذاكرة بعد الإستعلام: 1.146 MB إرجاع الصفوف: 1
SELECT b.id
FROM c2081958_usergroups AS a
LEFT JOIN c2081958_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE b NULL range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 1 100.00 Using where; Using index Status Duration starting 0.03 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 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 - وقت الإستعلام: 1.30 ms قبل آخر إستعلام: 44.28 ms إستعلام الذاكرة: 0.006 MB الذاكرة بعد الإستعلام: 3.291 MB
UPDATE `c2081958_extensions`
SET `params` = '{\"mediaversion\":\"6150dac752053dec3aee357447518977\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE c2081958_extensions NULL range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.05 ms updating 0.06 ms end 0.01 ms Waiting for query cache lock 0.00 ms end 0.01 ms query end 0.57 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 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/k2/k2.php:52 8 plgSystemK2->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.70 ms قبل آخر إستعلام: 11.77 ms إستعلام الذاكرة: 0.025 MB الذاكرة بعد الإستعلام: 3.816 MB إرجاع الصفوف: 39
SELECT `id`,`name`,`rules`,`parent_id`
FROM `c2081958_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_allvideoshare','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_cpanel','com_easyjoomlabackup','com_fields','com_finder','com_giweather','com_installer','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_plugins','com_postinstall','com_privacy','com_profiles','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper','com_yendifvideoshare')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c2081958_assets NULL range idx_asset_name idx_asset_name 202 NULL 40 100.00 Using index condition Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.10 ms preparing 0.01 ms executing 0.00 ms Sending data 0.23 ms end 0.01 ms query end 0.01 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 11 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 10 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 9 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 8 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 7 Joomla\CMS\User\User->authorise() JROOT/components/com_k2/k2.php:16 6 require_once JROOT/components/com_k2/k2.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.66 ms قبل آخر إستعلام: 39.71 ms إستعلام الذاكرة: 0.023 MB الذاكرة بعد الإستعلام: 4.005 MB إرجاع الصفوف: 17
SELECT id
FROM c2081958_k2_categories
WHERE published=1
AND trash=0
AND access IN(1,1)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c2081958_k2_categories NULL range category,published,access,trash category 8 NULL 17 100.00 Using where; Using index Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 14 JDatabaseDriver->loadColumn() JROOT/components/com_k2/helpers/permissions.php:261 13 K2HelperPermissions::canAddItem() JROOT/components/com_k2/views/itemlist/view.html.php:29 12 K2ViewItemlist->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:49 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.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.03 ms قبل آخر إستعلام: 0.52 ms إستعلام الذاكرة: 0.029 MB الذاكرة بعد الإستعلام: 4.018 MB إرجاع الصفوف: 17
SHOW FULL COLUMNS
FROM `c2081958_users`التوضيح غير ممكن للإستعلام: SHOW FULL COLUMNS FROM `c2081958_users`Status Duration starting 0.03 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.24 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Opening tables 0.01 ms checking permissions 0.03 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Sending data 0.04 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms removing tmp table 0.11 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 23 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 22 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 21 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 20 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/User.php:41 19 Joomla\CMS\Table\User->__construct() JROOT/libraries/src/Table/Table.php:328 18 Joomla\CMS\Table\Table::getInstance() JROOT/libraries/src/User/User.php:603 17 Joomla\CMS\User\User::getTable() JROOT/libraries/src/User/User.php:877 16 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 15 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 14 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 13 Joomla\CMS\Factory::getUser() JROOT/components/com_k2/views/itemlist/view.html.php:220 12 K2ViewItemlist->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:49 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.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.68 ms قبل آخر إستعلام: 0.70 ms إستعلام الذاكرة: 0.025 MB الذاكرة بعد الإستعلام: 4.050 MB إرجاع الصفوف: 1
SELECT *
FROM `c2081958_users`
WHERE `id` = 267id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c2081958_users NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 18 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/User.php:87 17 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:880 16 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 15 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 14 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 13 Joomla\CMS\Factory::getUser() JROOT/components/com_k2/views/itemlist/view.html.php:220 12 K2ViewItemlist->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:49 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.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.58 ms قبل آخر إستعلام: 0.56 ms إستعلام الذاكرة: 0.025 MB الذاكرة بعد الإستعلام: 4.063 MB إرجاع الصفوف: 1
SELECT `g`.`id`,`g`.`title`
FROM `c2081958_usergroups` AS g
INNER JOIN `c2081958_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 267id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ref PRIMARY PRIMARY 4 const 1 100.00 Using index 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 c2081958_inforo.m.group_id 1 100.00 NULL Status Duration starting 0.02 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 18 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Table/User.php:112 17 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:880 16 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 15 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 14 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 13 Joomla\CMS\Factory::getUser() JROOT/components/com_k2/views/itemlist/view.html.php:220 12 K2ViewItemlist->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:49 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.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.48 ms قبل آخر إستعلام: 0.08 ms إستعلام الذاكرة: 0.023 MB الذاكرة بعد الإستعلام: 4.069 MB إرجاع الصفوف: 1الإستعلامات المتكررة: #11
SELECT id, gender, description, image, url, `
group`, plugins
FROM c2081958_k2_users
WHERE userID=267id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c2081958_k2_users NULL ref userID userID 4 const 1 100.00 NULL Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/itemlist.php:804 13 K2ModelItemlist->getUserProfile() JROOT/components/com_k2/views/itemlist/view.html.php:230 12 K2ViewItemlist->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:49 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.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.23 ms قبل آخر إستعلام: 0.24 ms إستعلام الذاكرة: 0.023 MB الذاكرة بعد الإستعلام: 4.077 MB إرجاع الصفوف: 1الإستعلامات المتكررة: #10
SELECT id, gender, description, image, url, `
group`, plugins
FROM c2081958_k2_users
WHERE userID=267id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c2081958_k2_users NULL ref userID userID 4 const 1 100.00 NULL Status Duration starting 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.00 ms executing 0.00 ms Sending data 0.01 ms end 0.01 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 15 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:1811 14 K2ModelItem->getUserProfile() JROOT/components/com_k2/helpers/utilities.php:65 13 K2HelperUtilities::getAvatar() JROOT/components/com_k2/views/itemlist/view.html.php:233 12 K2ViewItemlist->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:49 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.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 - وقت الإستعلام: 159.17 ms قبل آخر إستعلام: 1.61 ms إستعلام الذاكرة: 9.984 MB الذاكرة بعد الإستعلام: 4.124 MB إرجاع الصفوف: 7
SELECT i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams
FROM c2081958_k2_items as i RIGHT JOIN c2081958_k2_categories AS c
ON c.id = i.catid
WHERE i.published = 1
AND i.access IN(1,1)
AND i.trash = 0
AND c.published = 1
AND c.access IN(1,1)
AND c.trash = 0
AND c.language IN ('ar-AA','*')
AND i.language IN ('ar-AA','*')
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-08-27 11:09:58' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-08-27 11:09:58' )
AND i.created_by=267
AND i.created_by_alias=''
ORDER BY i.id DESC
LIMIT 1288, 7id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE i NULL range item,catid,created_by,language item 7 NULL 2264 0.08 Using index condition; Using where; استعمال ترتيب الملفات 1 SIMPLE c NULL eq_ref PRIMARY,category,published,access,trash,language PRIMARY 4 c2081958_inforo.i.catid 1 19.95 Using where Status Duration starting 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.04 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.12 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 151.87 ms end 0.02 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/itemlist.php:357 13 K2ModelItemlist->getData() JROOT/components/com_k2/views/itemlist/view.html.php:376 12 K2ViewItemlist->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:49 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.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 - وقت الإستعلام: 19.10 ms قبل آخر إستعلام: 3.79 ms إستعلام الذاكرة: 0.023 MB الذاكرة بعد الإستعلام: 10.774 MB إرجاع الصفوف: 1
SELECT COUNT(*)
FROM c2081958_k2_items as i RIGHT JOIN c2081958_k2_categories c
ON c.id = i.catid
WHERE i.published = 1
AND i.access IN(1,1)
AND i.trash = 0
AND c.published = 1
AND c.access IN(1,1)
AND c.trash = 0
AND c.language IN ('ar-AA','*')
AND i.language IN ('ar-AA','*')
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-08-27 11:09:58' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-08-27 11:09:58' )
AND i.created_by=267
AND i.created_by_alias=''id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE i NULL range item,catid,created_by,language item 7 NULL 2264 0.08 Using index condition; Using where 1 SIMPLE c NULL eq_ref PRIMARY,category,published,access,trash,language PRIMARY 4 c2081958_inforo.i.catid 1 19.95 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.13 ms preparing 0.02 ms executing 0.00 ms Sending data 18.47 ms end 0.02 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/itemlist.php:592 13 K2ModelItemlist->getTotal() JROOT/components/com_k2/views/itemlist/view.html.php:385 12 K2ViewItemlist->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:49 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.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.78 ms قبل آخر إستعلام: 0.87 ms إستعلام الذاكرة: 0.027 MB الذاكرة بعد الإستعلام: 10.790 MB إرجاع الصفوف: 14
SHOW FULL COLUMNS
FROM `c2081958_k2_categories`التوضيح غير ممكن للإستعلام: SHOW FULL COLUMNS FROM `c2081958_k2_categories`Status Duration starting 0.03 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.13 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Opening tables 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Sending data 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.02 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 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_k2/tables/k2category.php:34 14 TableK2Category->__construct() JROOT/libraries/src/Table/Table.php:328 13 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_k2/views/itemlist/view.html.php:431 12 K2ViewItemlist->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:49 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.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.50 ms قبل آخر إستعلام: 1.60 ms إستعلام الذاكرة: 0.025 MB الذاكرة بعد الإستعلام: 10.833 MB إرجاع الصفوف: 1
SELECT *
FROM c2081958_k2_categories
WHERE id = '94'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c2081958_k2_categories NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 18 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_k2/tables/k2category.php:65 17 TableK2Category->load() JROOT/components/com_k2/models/item.php:75 16 K2ModelItem->prepareItem() Same as call in the line below. 15 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 14 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 13 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:433 12 K2ViewItemlist->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:49 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.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.50 ms قبل آخر إستعلام: 1.30 ms إستعلام الذاكرة: 0.028 MB الذاكرة بعد الإستعلام: 10.907 MB إرجاع الصفوف: 1الإستعلامات المتكررة: #17
SELECT items.id, categories.id AS catid,
CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS('-', categories.id, categories.alias) ELSE categories.id END AS catslug
FROM c2081958_k2_items AS items
INNER JOIN c2081958_k2_categories AS categories
ON items.catid = categories.id
WHERE items.id = 7298id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE items NULL const PRIMARY,catid PRIMARY 4 const 1 100.00 NULL 1 SIMPLE categories NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 26 JDatabaseDriver->loadObject() JROOT/components/com_k2/router.php:444 25 getCategorySlug() JROOT/components/com_k2/router.php:151 24 k2BuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 23 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:532 22 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 21 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 20 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 19 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 18 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 17 Joomla\CMS\Router\Route::_() JROOT/components/com_k2/models/item.php:82 16 K2ModelItem->prepareItem() Same as call in the line below. 15 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 14 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 13 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:433 12 K2ViewItemlist->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:49 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.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.41 ms قبل آخر إستعلام: 0.11 ms إستعلام الذاكرة: 0.028 MB الذاكرة بعد الإستعلام: 10.922 MB إرجاع الصفوف: 1الإستعلامات المتكررة: #16
SELECT items.id, categories.id AS catid,
CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS('-', categories.id, categories.alias) ELSE categories.id END AS catslug
FROM c2081958_k2_items AS items
INNER JOIN c2081958_k2_categories AS categories
ON items.catid = categories.id
WHERE items.id = 7298id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE items NULL const PRIMARY,catid PRIMARY 4 const 1 100.00 NULL 1 SIMPLE categories NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.02 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 26 JDatabaseDriver->loadObject() JROOT/components/com_k2/router.php:444 25 getCategorySlug() JROOT/components/com_k2/router.php:151 24 k2BuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 23 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:532 22 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 21 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 20 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 19 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 18 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 17 Joomla\CMS\Router\Route::_() JROOT/components/com_k2/models/item.php:85 16 K2ModelItem->prepareItem() Same as call in the line below. 15 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 14 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 13 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:433 12 K2ViewItemlist->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:49 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.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.31 ms قبل آخر إستعلام: 0.66 ms إستعلام الذاكرة: 0.025 MB الذاكرة بعد الإستعلام: 10.979 MB إرجاع الصفوف: 1
SELECT *
FROM c2081958_k2_categories
WHERE id = '78'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c2081958_k2_categories NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.01 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 18 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_k2/tables/k2category.php:65 17 TableK2Category->load() JROOT/components/com_k2/models/item.php:96 16 K2ModelItem->prepareItem() Same as call in the line below. 15 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 14 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 13 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:433 12 K2ViewItemlist->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:49 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.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.93 ms قبل آخر إستعلام: 9.72 ms إستعلام الذاكرة: 0.026 MB الذاكرة بعد الإستعلام: 11.143 MB إرجاع الصفوف: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM c2081958_fields AS a
LEFT JOIN `c2081958_languages` AS l
ON l.lang_code = a.language
LEFT JOIN c2081958_users AS uc
ON uc.id=a.checked_out
LEFT JOIN c2081958_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN c2081958_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN c2081958_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `c2081958_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.itemlist'
AND (fc.category_id IS NULL OR fc.category_id IN (94,0))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_access,idx_context idx_state 1 const 1 100.00 Using index condition; Using where; Using temporary; استعمال ترتيب الملفات 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 c2081958_inforo.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 c2081958_inforo.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 c2081958_inforo.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 c2081958_inforo.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 c2081958_inforo.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 c2081958_inforo.a.id 1 100.00 Using where; Using index; Distinct Status Duration starting 0.09 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.02 ms Creating tmp table 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.12 ms Creating sort index 0.03 ms end 0.00 ms query end 0.01 ms removing tmp table 0.02 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 20 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 19 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 18 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 17 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 16 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 15 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 14 JEventDispatcher->trigger() JROOT/components/com_k2/models/item.php:713 13 K2ModelItem->execPlugins() JROOT/components/com_k2/views/itemlist/view.html.php:444 12 K2ViewItemlist->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:49 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.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.85 ms قبل آخر إستعلام: 4.53 ms إستعلام الذاكرة: 0.028 MB الذاكرة بعد الإستعلام: 11.282 MB إرجاع الصفوف: 1الإستعلامات المتكررة: #21
SELECT items.id, categories.id AS catid,
CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS('-', categories.id, categories.alias) ELSE categories.id END AS catslug
FROM c2081958_k2_items AS items
INNER JOIN c2081958_k2_categories AS categories
ON items.catid = categories.id
WHERE items.id = 7297id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE items NULL const PRIMARY,catid PRIMARY 4 const 1 100.00 NULL 1 SIMPLE categories NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.06 ms checking permissions 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.02 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.02 ms # Caller File and line number 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 26 JDatabaseDriver->loadObject() JROOT/components/com_k2/router.php:444 25 getCategorySlug() JROOT/components/com_k2/router.php:151 24 k2BuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 23 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:532 22 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 21 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 20 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 19 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 18 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 17 Joomla\CMS\Router\Route::_() JROOT/components/com_k2/models/item.php:82 16 K2ModelItem->prepareItem() Same as call in the line below. 15 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 14 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 13 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:433 12 K2ViewItemlist->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:49 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.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.76 ms قبل آخر إستعلام: 0.12 ms إستعلام الذاكرة: 0.028 MB الذاكرة بعد الإستعلام: 11.295 MB إرجاع الصفوف: 1الإستعلامات المتكررة: #20
SELECT items.id, categories.id AS catid,
CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS('-', categories.id, categories.alias) ELSE categories.id END AS catslug
FROM c2081958_k2_items AS items
INNER JOIN c2081958_k2_categories AS categories
ON items.catid = categories.id
WHERE items.id = 7297id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE items NULL const PRIMARY,catid PRIMARY 4 const 1 100.00 NULL 1 SIMPLE categories NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 26 JDatabaseDriver->loadObject() JROOT/components/com_k2/router.php:444 25 getCategorySlug() JROOT/components/com_k2/router.php:151 24 k2BuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 23 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:532 22 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 21 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 20 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 19 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 18 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 17 Joomla\CMS\Router\Route::_() JROOT/components/com_k2/models/item.php:85 16 K2ModelItem->prepareItem() Same as call in the line below. 15 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 14 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 13 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:433 12 K2ViewItemlist->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:49 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.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.94 ms قبل آخر إستعلام: 54.38 ms إستعلام الذاكرة: 0.028 MB الذاكرة بعد الإستعلام: 11.356 MB إرجاع الصفوف: 1الإستعلامات المتكررة: #23
SELECT items.id, categories.id AS catid,
CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS('-', categories.id, categories.alias) ELSE categories.id END AS catslug
FROM c2081958_k2_items AS items
INNER JOIN c2081958_k2_categories AS categories
ON items.catid = categories.id
WHERE items.id = 7296id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE items NULL const PRIMARY,catid PRIMARY 4 const 1 100.00 NULL 1 SIMPLE categories NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.09 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 26 JDatabaseDriver->loadObject() JROOT/components/com_k2/router.php:444 25 getCategorySlug() JROOT/components/com_k2/router.php:151 24 k2BuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 23 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:532 22 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 21 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 20 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 19 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 18 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 17 Joomla\CMS\Router\Route::_() JROOT/components/com_k2/models/item.php:82 16 K2ModelItem->prepareItem() Same as call in the line below. 15 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 14 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 13 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:433 12 K2ViewItemlist->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:49 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.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.86 ms قبل آخر إستعلام: 0.13 ms إستعلام الذاكرة: 0.028 MB الذاكرة بعد الإستعلام: 11.369 MB إرجاع الصفوف: 1الإستعلامات المتكررة: #22
SELECT items.id, categories.id AS catid,
CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS('-', categories.id, categories.alias) ELSE categories.id END AS catslug
FROM c2081958_k2_items AS items
INNER JOIN c2081958_k2_categories AS categories
ON items.catid = categories.id
WHERE items.id = 7296id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE items NULL const PRIMARY,catid PRIMARY 4 const 1 100.00 NULL 1 SIMPLE categories NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.02 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.03 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.03 ms # Caller File and line number 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 26 JDatabaseDriver->loadObject() JROOT/components/com_k2/router.php:444 25 getCategorySlug() JROOT/components/com_k2/router.php:151 24 k2BuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 23 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:532 22 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 21 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 20 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 19 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 18 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 17 Joomla\CMS\Router\Route::_() JROOT/components/com_k2/models/item.php:85 16 K2ModelItem->prepareItem() Same as call in the line below. 15 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 14 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 13 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:433 12 K2ViewItemlist->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:49 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.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 - وقت الإستعلام: 3.43 ms قبل آخر إستعلام: 53.17 ms إستعلام الذاكرة: 0.025 MB الذاكرة بعد الإستعلام: 11.415 MB إرجاع الصفوف: 1
SELECT *
FROM c2081958_k2_categories
WHERE id = '95'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c2081958_k2_categories NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.04 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.03 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 18 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_k2/tables/k2category.php:65 17 TableK2Category->load() JROOT/components/com_k2/models/item.php:75 16 K2ModelItem->prepareItem() Same as call in the line below. 15 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 14 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 13 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:433 12 K2ViewItemlist->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:49 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.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.00 ms قبل آخر إستعلام: 0.42 ms إستعلام الذاكرة: 0.028 MB الذاكرة بعد الإستعلام: 11.432 MB إرجاع الصفوف: 1الإستعلامات المتكررة: #26
SELECT items.id, categories.id AS catid,
CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS('-', categories.id, categories.alias) ELSE categories.id END AS catslug
FROM c2081958_k2_items AS items
INNER JOIN c2081958_k2_categories AS categories
ON items.catid = categories.id
WHERE items.id = 7295id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE items NULL const PRIMARY,catid PRIMARY 4 const 1 100.00 NULL 1 SIMPLE categories NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.06 ms checking permissions 0.02 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 26 JDatabaseDriver->loadObject() JROOT/components/com_k2/router.php:444 25 getCategorySlug() JROOT/components/com_k2/router.php:151 24 k2BuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 23 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:532 22 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 21 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 20 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 19 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 18 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 17 Joomla\CMS\Router\Route::_() JROOT/components/com_k2/models/item.php:82 16 K2ModelItem->prepareItem() Same as call in the line below. 15 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 14 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 13 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:433 12 K2ViewItemlist->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:49 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.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.91 ms قبل آخر إستعلام: 0.13 ms إستعلام الذاكرة: 0.028 MB الذاكرة بعد الإستعلام: 11.446 MB إرجاع الصفوف: 1الإستعلامات المتكررة: #25
SELECT items.id, categories.id AS catid,
CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS('-', categories.id, categories.alias) ELSE categories.id END AS catslug
FROM c2081958_k2_items AS items
INNER JOIN c2081958_k2_categories AS categories
ON items.catid = categories.id
WHERE items.id = 7295id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE items NULL const PRIMARY,catid PRIMARY 4 const 1 100.00 NULL 1 SIMPLE categories NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.03 ms # Caller File and line number 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 26 JDatabaseDriver->loadObject() JROOT/components/com_k2/router.php:444 25 getCategorySlug() JROOT/components/com_k2/router.php:151 24 k2BuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 23 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:532 22 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 21 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 20 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 19 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 18 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 17 Joomla\CMS\Router\Route::_() JROOT/components/com_k2/models/item.php:85 16 K2ModelItem->prepareItem() Same as call in the line below. 15 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 14 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 13 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:433 12 K2ViewItemlist->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:49 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.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 - وقت الإستعلام: 3.27 ms قبل آخر إستعلام: 5.21 ms إستعلام الذاكرة: 0.026 MB الذاكرة بعد الإستعلام: 11.475 MB إرجاع الصفوف: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM c2081958_fields AS a
LEFT JOIN `c2081958_languages` AS l
ON l.lang_code = a.language
LEFT JOIN c2081958_users AS uc
ON uc.id=a.checked_out
LEFT JOIN c2081958_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN c2081958_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN c2081958_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `c2081958_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.itemlist'
AND (fc.category_id IS NULL OR fc.category_id IN (95,0))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_access,idx_context idx_state 1 const 1 100.00 Using index condition; Using where; Using temporary; استعمال ترتيب الملفات 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 c2081958_inforo.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 c2081958_inforo.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 c2081958_inforo.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 c2081958_inforo.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 c2081958_inforo.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 c2081958_inforo.a.id 1 100.00 Using where; Using index; Distinct Status Duration starting 0.11 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.07 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.15 ms preparing 0.07 ms Creating tmp table 0.07 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.20 ms Creating sort index 0.04 ms end 0.00 ms query end 0.02 ms removing tmp table 0.05 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 20 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 19 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 18 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 17 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 16 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 15 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 14 JEventDispatcher->trigger() JROOT/components/com_k2/models/item.php:713 13 K2ModelItem->execPlugins() JROOT/components/com_k2/views/itemlist/view.html.php:444 12 K2ViewItemlist->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:49 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.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.30 ms قبل آخر إستعلام: 56.00 ms إستعلام الذاكرة: 0.025 MB الذاكرة بعد الإستعلام: 11.503 MB إرجاع الصفوف: 1
SELECT *
FROM c2081958_k2_categories
WHERE id = '98'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c2081958_k2_categories NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 18 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_k2/tables/k2category.php:65 17 TableK2Category->load() JROOT/components/com_k2/models/item.php:75 16 K2ModelItem->prepareItem() Same as call in the line below. 15 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 14 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 13 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:433 12 K2ViewItemlist->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:49 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.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.31 ms قبل آخر إستعلام: 0.38 ms إستعلام الذاكرة: 0.028 MB الذاكرة بعد الإستعلام: 11.521 MB إرجاع الصفوف: 1الإستعلامات المتكررة: #30
SELECT items.id, categories.id AS catid,
CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS('-', categories.id, categories.alias) ELSE categories.id END AS catslug
FROM c2081958_k2_items AS items
INNER JOIN c2081958_k2_categories AS categories
ON items.catid = categories.id
WHERE items.id = 7294id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE items NULL const PRIMARY,catid PRIMARY 4 const 1 100.00 NULL 1 SIMPLE categories NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 26 JDatabaseDriver->loadObject() JROOT/components/com_k2/router.php:444 25 getCategorySlug() JROOT/components/com_k2/router.php:151 24 k2BuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 23 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:532 22 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 21 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 20 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 19 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 18 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 17 Joomla\CMS\Router\Route::_() JROOT/components/com_k2/models/item.php:82 16 K2ModelItem->prepareItem() Same as call in the line below. 15 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 14 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 13 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:433 12 K2ViewItemlist->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:49 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.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.42 ms قبل آخر إستعلام: 0.13 ms إستعلام الذاكرة: 0.028 MB الذاكرة بعد الإستعلام: 11.534 MB إرجاع الصفوف: 1الإستعلامات المتكررة: #29
SELECT items.id, categories.id AS catid,
CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS('-', categories.id, categories.alias) ELSE categories.id END AS catslug
FROM c2081958_k2_items AS items
INNER JOIN c2081958_k2_categories AS categories
ON items.catid = categories.id
WHERE items.id = 7294id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE items NULL const PRIMARY,catid PRIMARY 4 const 1 100.00 NULL 1 SIMPLE categories NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.05 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 26 JDatabaseDriver->loadObject() JROOT/components/com_k2/router.php:444 25 getCategorySlug() JROOT/components/com_k2/router.php:151 24 k2BuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 23 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:532 22 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 21 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 20 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 19 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 18 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 17 Joomla\CMS\Router\Route::_() JROOT/components/com_k2/models/item.php:85 16 K2ModelItem->prepareItem() Same as call in the line below. 15 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 14 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 13 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:433 12 K2ViewItemlist->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:49 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.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.94 ms قبل آخر إستعلام: 655.95 ms إستعلام الذاكرة: 0.026 MB الذاكرة بعد الإستعلام: 11.563 MB إرجاع الصفوف: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM c2081958_fields AS a
LEFT JOIN `c2081958_languages` AS l
ON l.lang_code = a.language
LEFT JOIN c2081958_users AS uc
ON uc.id=a.checked_out
LEFT JOIN c2081958_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN c2081958_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN c2081958_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `c2081958_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.itemlist'
AND (fc.category_id IS NULL OR fc.category_id IN (98,0))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_access,idx_context idx_state 1 const 1 100.00 Using index condition; Using where; Using temporary; استعمال ترتيب الملفات 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 c2081958_inforo.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 c2081958_inforo.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 c2081958_inforo.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 c2081958_inforo.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 c2081958_inforo.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 c2081958_inforo.a.id 1 100.00 Using where; Using index; Distinct Status Duration starting 0.07 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms Creating tmp table 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.10 ms Creating sort index 0.02 ms end 0.00 ms query end 0.01 ms removing tmp table 0.02 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 20 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 19 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 18 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 17 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 16 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 15 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 14 JEventDispatcher->trigger() JROOT/components/com_k2/models/item.php:713 13 K2ModelItem->execPlugins() JROOT/components/com_k2/views/itemlist/view.html.php:444 12 K2ViewItemlist->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:49 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.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.39 ms قبل آخر إستعلام: 4.19 ms إستعلام الذاكرة: 0.028 MB الذاكرة بعد الإستعلام: 11.595 MB إرجاع الصفوف: 1الإستعلامات المتكررة: #33
SELECT items.id, categories.id AS catid,
CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS('-', categories.id, categories.alias) ELSE categories.id END AS catslug
FROM c2081958_k2_items AS items
INNER JOIN c2081958_k2_categories AS categories
ON items.catid = categories.id
WHERE items.id = 7293id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE items NULL const PRIMARY,catid PRIMARY 4 const 1 100.00 NULL 1 SIMPLE categories NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.02 ms # Caller File and line number 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 26 JDatabaseDriver->loadObject() JROOT/components/com_k2/router.php:444 25 getCategorySlug() JROOT/components/com_k2/router.php:151 24 k2BuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 23 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:532 22 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 21 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 20 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 19 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 18 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 17 Joomla\CMS\Router\Route::_() JROOT/components/com_k2/models/item.php:82 16 K2ModelItem->prepareItem() Same as call in the line below. 15 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 14 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 13 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:433 12 K2ViewItemlist->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:49 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.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.35 ms قبل آخر إستعلام: 0.16 ms إستعلام الذاكرة: 0.029 MB الذاكرة بعد الإستعلام: 11.615 MB إرجاع الصفوف: 1الإستعلامات المتكررة: #32
SELECT items.id, categories.id AS catid,
CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS('-', categories.id, categories.alias) ELSE categories.id END AS catslug
FROM c2081958_k2_items AS items
INNER JOIN c2081958_k2_categories AS categories
ON items.catid = categories.id
WHERE items.id = 7293id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE items NULL const PRIMARY,catid PRIMARY 4 const 1 100.00 NULL 1 SIMPLE categories NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.02 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.00 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 26 JDatabaseDriver->loadObject() JROOT/components/com_k2/router.php:444 25 getCategorySlug() JROOT/components/com_k2/router.php:151 24 k2BuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 23 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:532 22 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 21 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 20 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 19 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 18 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 17 Joomla\CMS\Router\Route::_() JROOT/components/com_k2/models/item.php:85 16 K2ModelItem->prepareItem() Same as call in the line below. 15 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 14 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 13 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:433 12 K2ViewItemlist->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:49 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.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.66 ms قبل آخر إستعلام: 35.65 ms إستعلام الذاكرة: 0.028 MB الذاكرة بعد الإستعلام: 11.665 MB إرجاع الصفوف: 1الإستعلامات المتكررة: #35
SELECT items.id, categories.id AS catid,
CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS('-', categories.id, categories.alias) ELSE categories.id END AS catslug
FROM c2081958_k2_items AS items
INNER JOIN c2081958_k2_categories AS categories
ON items.catid = categories.id
WHERE items.id = 7292id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE items NULL const PRIMARY,catid PRIMARY 4 const 1 100.00 NULL 1 SIMPLE categories NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.06 ms checking permissions 0.01 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 26 JDatabaseDriver->loadObject() JROOT/components/com_k2/router.php:444 25 getCategorySlug() JROOT/components/com_k2/router.php:151 24 k2BuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 23 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:532 22 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 21 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 20 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 19 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 18 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 17 Joomla\CMS\Router\Route::_() JROOT/components/com_k2/models/item.php:82 16 K2ModelItem->prepareItem() Same as call in the line below. 15 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 14 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 13 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:433 12 K2ViewItemlist->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:49 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.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.75 ms قبل آخر إستعلام: 0.13 ms إستعلام الذاكرة: 0.028 MB الذاكرة بعد الإستعلام: 11.679 MB إرجاع الصفوف: 1الإستعلامات المتكررة: #34
SELECT items.id, categories.id AS catid,
CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS('-', categories.id, categories.alias) ELSE categories.id END AS catslug
FROM c2081958_k2_items AS items
INNER JOIN c2081958_k2_categories AS categories
ON items.catid = categories.id
WHERE items.id = 7292id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE items NULL const PRIMARY,catid PRIMARY 4 const 1 100.00 NULL 1 SIMPLE categories NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 26 JDatabaseDriver->loadObject() JROOT/components/com_k2/router.php:444 25 getCategorySlug() JROOT/components/com_k2/router.php:151 24 k2BuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 23 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:532 22 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 21 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 20 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 19 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 18 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 17 Joomla\CMS\Router\Route::_() JROOT/components/com_k2/models/item.php:85 16 K2ModelItem->prepareItem() Same as call in the line below. 15 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 14 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 13 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:433 12 K2ViewItemlist->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:49 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.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.10 ms قبل آخر إستعلام: 98.73 ms إستعلام الذاكرة: 0.021 MB الذاكرة بعد الإستعلام: 11.751 MB إرجاع الصفوف: 3
SELECT language,id
FROM `c2081958_menu`
WHERE home = 1
AND published = 1
AND client_id = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c2081958_menu NULL ALL idx_client_id_parent_id_alias_language لا يوجد مفتاح رئيسي يمكن استخدامه NULL NULL 252 0.85 Using where Status Duration starting 0.05 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.02 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.01 ms Sending data 0.15 ms end 0.07 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 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 - وقت الإستعلام: 1.78 ms قبل آخر إستعلام: 3.42 ms إستعلام الذاكرة: 0.022 MB الذاكرة بعد الإستعلام: 11.775 MB إرجاع الصفوف: 1
SELECT template_style_id
FROM c2081958_menu
WHERE id = 1677id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c2081958_menu NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:184 10 YtFrameworkTemplate->isOverrideTemplate() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:30 9 YtFrameworkTemplate->__construct() JROOT/templates/sj_veritymag/includes/frame_inc.php:31 8 include_once JROOT/templates/sj_veritymag/includes/frame_inc.php JROOT/templates/sj_veritymag/index.php:23 7 require JROOT/templates/sj_veritymag/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.91 ms قبل آخر إستعلام: 0.06 ms إستعلام الذاكرة: 0.022 MB الذاكرة بعد الإستعلام: 11.781 MB إرجاع الصفوف: 1
SELECT id
FROM c2081958_template_styles
WHERE home = 1
AND client_id = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c2081958_template_styles NULL ref idx_client_id,idx_client_id_home idx_client_id_home 1 const 6 14.29 Using where; Using index Status Duration starting 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:188 10 YtFrameworkTemplate->isOverrideTemplate() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:30 9 YtFrameworkTemplate->__construct() JROOT/templates/sj_veritymag/includes/frame_inc.php:31 8 include_once JROOT/templates/sj_veritymag/includes/frame_inc.php JROOT/templates/sj_veritymag/index.php:23 7 require JROOT/templates/sj_veritymag/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.82 ms قبل آخر إستعلام: 3.25 ms إستعلام الذاكرة: 0.021 MB الذاكرة بعد الإستعلام: 11.871 MB إرجاع الصفوف: 1
SELECT home
FROM c2081958_menu
WHERE id=1677id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c2081958_menu NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.00 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 9 JDatabase->query() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:172 8 YtFrameworkTemplate->isHomePage() JROOT/templates/sj_veritymag/index.php:136 7 require JROOT/templates/sj_veritymag/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.65 ms قبل آخر إستعلام: 0.05 ms إستعلام الذاكرة: 0.021 MB الذاكرة بعد الإستعلام: 11.876 MB إرجاع الصفوف: 1
SELECT home
FROM c2081958_menu
WHERE id=1677id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c2081958_menu NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.00 ms executing 0.00 ms Sending data 0.00 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 9 JDatabaseDriver->loadResult() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:173 8 YtFrameworkTemplate->isHomePage() JROOT/templates/sj_veritymag/index.php:136 7 require JROOT/templates/sj_veritymag/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 - وقت الإستعلام: 3.62 ms قبل آخر إستعلام: 11.53 ms إستعلام الذاكرة: 0.024 MB الذاكرة بعد الإستعلام: 12.594 MB إرجاع الصفوف: 2
SELECT id,title,module,position,content,showtitle,params
FROM c2081958_modules AS m
WHERE m.access IN (1,1)
AND m.published=1
AND m.position='mega2';id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ref published published 1 const 88 2.00 Using index condition; Using where Status Duration starting 0.05 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.00 ms Sending data 0.28 ms end 0.01 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/templates/sj_veritymag/menusys/ytmenu.php:461 14 YtMenu->loadModules() JROOT/templates/sj_veritymag/menusys/ytmenu.php:398 13 YtMenu->haveMegaContent() JROOT/templates/sj_veritymag/menusys/class/mega/tmpl/default.php:28 12 include JROOT/templates/sj_veritymag/menusys/class/mega/tmpl/default.php JROOT/templates/sj_veritymag/menusys/ytmenu.php:135 11 YtMenu->getContent() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:294 10 YtFrameworkTemplate->getMenu() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:514 9 YtFrameworkTemplate->renFeaturePos() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:417 8 YtFrameworkTemplate->renPositionsNormal() JROOT/templates/sj_veritymag/index.php:236 7 require JROOT/templates/sj_veritymag/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 - وقت الإستعلام: 3.77 ms قبل آخر إستعلام: 1.65 ms إستعلام الذاكرة: 0.029 MB الذاكرة بعد الإستعلام: 12.636 MB إرجاع الصفوف: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM c2081958_fields AS a
LEFT JOIN `c2081958_languages` AS l
ON l.lang_code = a.language
LEFT JOIN c2081958_users AS uc
ON uc.id=a.checked_out
LEFT JOIN c2081958_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN c2081958_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN c2081958_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'mod_custom.content'
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_access,idx_context idx_state 1 const 1 100.00 Using index condition; Using where; Using temporary; استعمال ترتيب الملفات 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 c2081958_inforo.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 c2081958_inforo.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 c2081958_inforo.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 c2081958_inforo.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 c2081958_inforo.a.group_id 1 100.00 Using where Status Duration starting 0.11 ms checking permissions 0.00 ms checking permissions 0.02 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.05 ms System lock 0.02 ms optimizing 0.01 ms statistics 0.11 ms preparing 0.03 ms Creating tmp table 0.05 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.17 ms Creating sort index 0.04 ms end 0.00 ms query end 0.03 ms removing tmp table 0.04 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.02 ms # Caller File and line number 29 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 28 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 27 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 26 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 25 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 24 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 23 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 22 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 21 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 20 JHtmlContent::prepare() Same as call in the line below. 19 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 18 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 17 Joomla\CMS\HTML\HTMLHelper::_() JROOT/modules/mod_custom/mod_custom.php:15 16 include JROOT/modules/mod_custom/mod_custom.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/templates/sj_veritymag/menusys/class/mega/tmpl/default.php:253 14 include JROOT/templates/sj_veritymag/menusys/class/mega/tmpl/default.php JROOT/templates/sj_veritymag/menusys/ytmenu.php:135 13 YtMenu->getContent() JROOT/templates/sj_veritymag/menusys/class/mega/tmpl/default.php:31 12 include JROOT/templates/sj_veritymag/menusys/class/mega/tmpl/default.php JROOT/templates/sj_veritymag/menusys/ytmenu.php:135 11 YtMenu->getContent() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:294 10 YtFrameworkTemplate->getMenu() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:514 9 YtFrameworkTemplate->renFeaturePos() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:417 8 YtFrameworkTemplate->renPositionsNormal() JROOT/templates/sj_veritymag/index.php:236 7 require JROOT/templates/sj_veritymag/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.75 ms قبل آخر إستعلام: 11.86 ms إستعلام الذاكرة: 0.022 MB الذاكرة بعد الإستعلام: 12.416 MB إرجاع الصفوف: 1
SELECT home
FROM c2081958_menu
WHERE id=1677id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c2081958_menu NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.01 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 11 JDatabase->query() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:172 10 YtFrameworkTemplate->isHomePage() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:334 9 YtFrameworkTemplate->renPositionsGroup() JROOT/templates/sj_veritymag/includes/block-content.php:81 8 include JROOT/templates/sj_veritymag/includes/block-content.php JROOT/templates/sj_veritymag/index.php:174 7 require JROOT/templates/sj_veritymag/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.66 ms قبل آخر إستعلام: 0.02 ms إستعلام الذاكرة: 0.022 MB الذاكرة بعد الإستعلام: 12.422 MB إرجاع الصفوف: 1
SELECT home
FROM c2081958_menu
WHERE id=1677id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c2081958_menu NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.00 ms executing 0.00 ms Sending data 0.00 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:173 10 YtFrameworkTemplate->isHomePage() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:334 9 YtFrameworkTemplate->renPositionsGroup() JROOT/templates/sj_veritymag/includes/block-content.php:81 8 include JROOT/templates/sj_veritymag/includes/block-content.php JROOT/templates/sj_veritymag/index.php:174 7 require JROOT/templates/sj_veritymag/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 - وقت الإستعلام: 2.27 ms قبل آخر إستعلام: 58.63 ms إستعلام الذاكرة: 0.020 MB الذاكرة بعد الإستعلام: 12.708 MB إرجاع الصفوف: 1
SELECT template
FROM c2081958_template_styles
WHERE home = 1
AND client_id = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c2081958_template_styles NULL ALL idx_client_id,idx_client_id_home لا يوجد مفتاح رئيسي يمكن استخدامه NULL NULL 7 14.29 Using where Status Duration starting 0.05 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms executing 0.00 ms Sending data 0.06 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 9 JDatabaseDriver->loadResult() JROOT/plugins/system/yt/yt.php:280 8 plgSystemYt->nameOfSJTemplate() JROOT/plugins/system/yt/yt.php:161 7 plgSystemYt->onAfterRender() 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/CMSApplication.php:1118 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
23 أنواع الاستعلامات المسجلة, مصنفة حسب حالة الظهور تنازلياً
تحديد الجداول:
14 × SELECT items.id, categories.id AS catid,
CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS('-', categories.id, categories.alias) ELSE categories.id END AS catslug
FROM c2081958_k2_items AS items
INNER JOIN c2081958_k2_categories AS categories
ON items.catid = categories.id4 × SELECT *
FROM c2081958_k2_categories4 × SELECT home
FROM c2081958_menu3 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM c2081958_fields AS a
LEFT JOIN `c2081958_languages` AS l
ON l.lang_code = a.language
LEFT JOIN c2081958_users AS uc
ON uc.id=a.checked_out
LEFT JOIN c2081958_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN c2081958_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN c2081958_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `c2081958_fields_categories` AS fc
ON fc.field_id = a.id2 × SELECT id, gender, description, image, url, `
group`, plugins
FROM c2081958_k2_users1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM c2081958_fields AS a
LEFT JOIN `c2081958_languages` AS l
ON l.lang_code = a.language
LEFT JOIN c2081958_users AS uc
ON uc.id=a.checked_out
LEFT JOIN c2081958_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN c2081958_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN c2081958_fields_groups AS g
ON g.id = a.group_id1 × SELECT id,title,module,position,content,showtitle,params
FROM c2081958_modules AS m1 × SELECT id
FROM c2081958_template_styles1 × SELECT template_style_id
FROM c2081958_menu1 × SELECT language,id
FROM `c2081958_menu`1 × SELECT `data`
FROM `c2081958_session`1 × SELECT id, rules
FROM `c2081958_viewlevels1 × SELECT COUNT(*)
FROM c2081958_k2_items as i RIGHT JOIN c2081958_k2_categories c
ON c.id = i.catid1 × SELECT i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams
FROM c2081958_k2_items as i RIGHT JOIN c2081958_k2_categories AS c
ON c.id = i.catid1 × SELECT `g`.`id`,`g`.`title`
FROM `c2081958_usergroups` AS g
INNER JOIN `c2081958_user_usergroup_map` AS m
ON m.group_id = g.id1 × SELECT *
FROM `c2081958_users`1 × SELECT id
FROM c2081958_k2_categories1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `c2081958_assets`1 × SELECT b.id
FROM c2081958_usergroups AS a
LEFT JOIN c2081958_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT template
FROM c2081958_template_styles
جداول أخرى:
1 × UPDATE `c2081958_extensions`
SET `params` = '{\"mediaversion\":\"6150dac752053dec3aee357447518977\"}'1 × SHOW FULL COLUMNS
FROM `c2081958_users1 × SHOW FULL COLUMNS
FROM `c2081958_k2_categories