Las ventas se dispararon por la rebaja temporal de las retenciones, pero ese beneficio se agotó. El mercado mira el impacto del menor flujo de dólares.
La Granja Educativa del Parque Regional abrirá sus puertas a las familias de lunes a domingos; además habrá recorridas por la Reserva Natural, actividades culturales y deportivas en la Casa de la Cultura y diferentes espacios públicos de la ciudad, Cine para toda la familia y muchas sorpresas más libres y gratuitas. Conocé la grilla.
YPF aumentó el precio de sus combustibles en Rosario.
El candidato de Más para Santa Fe cosechó un 36,1%. Muy por detrás quedaron Milagros Serra del Frente de la Esperanza y Gustavo Delorenzi de Unidos. “Estamos comprometidos y orgullosos. Cuando la ciudad habla nos empodera”, manifestó el concejal electo.
Es el magistrado de nuestra ciudad y está acusado de proteger a narcos; el Presidente le permitirá sortear el jury del Consejo de la Magistratura; la medida se publicará en el Boletín Oficial.
La jueza Loretta Preska resolvió que el Estado argentino debe transferir la mayoría accionaria de la petrolera a los demandantes, como parte del resarcimiento por la expropiación de 2012.
La otra cara de las celebraciones del gobierno provincial demuestra que Unidos no logró consagrarse en varios lugares estratégicos. Empezando por Rosario, en donde ganó Juan Monteverde, el oficialismo perdió en Rafaela, Reconquista, Funes, Vera, San Lorenzo, Villa Gobernador Gálvez, entre otras.
Template Settings
وحدة تحكم تشخيص الأخطاء لجوملا!
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1788102468,
"last": 1788102468,
"now": 1788102468
},
"token": "ZLNZF5z489qtF6LxpuLcZLeiAhIlMkPQ"
},
"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"
}
}
}
الوقت
الذاكرة
الوقت: 8.66 ms / 8.66 ms الذاكرة: 0.408 MB / 0.75 MB Application: afterLoad
الوقت: 75.86 ms / 84.52 ms الذاكرة: 1.938 MB / 2.69 MB Application: afterInitialise
الوقت: 27.98 ms / 112.51 ms الذاكرة: 0.899 MB / 3.59 MB Application: afterRoute
الوقت: 1.59 ms / 114.10 ms الذاكرة: 0.206 MB / 3.80 MB Application: beforeRenderComponent com_k2
الوقت: 0.31 ms / 114.41 ms الذاكرة: 0.019 MB / 3.81 MB Application: Before Access::preloadComponents (all components)
الوقت: 4.56 ms / 118.97 ms الذاكرة: 0.055 MB / 3.87 MB Application: After Access::preloadComponents (all components)
الوقت: 0.03 ms / 118.99 ms الذاكرة: -0.003 MB / 3.87 MB Application: Before Access::getAssetRules (id:647 name:com_k2)
الوقت: 0.47 ms / 119.46 ms الذاكرة: 0.011 MB / 3.88 MB Application: After Access::getAssetRules (id:647 name:com_k2)
الوقت: 933.68 ms / 1053.14 ms الذاكرة: 8.308 MB / 12.19 MB Application: afterRenderComponent com_k2
الوقت: 9.40 ms / 1062.54 ms الذاكرة: 0.025 MB / 12.21 MB Application: afterDispatch
الوقت: 25.86 ms / 1088.40 ms الذاكرة: 0.865 MB / 13.08 MB Application: beforeRenderModule mod_custom (Accessories)
الوقت: 4.09 ms / 1092.49 ms الذاكرة: 0.026 MB / 13.10 MB Application: afterRenderModule mod_custom (Accessories)
الوقت: 0.05 ms / 1092.54 ms الذاكرة: 0.004 MB / 13.11 MB Application: beforeRenderModule mod_sj_k2_mega_news (Mega list)
الوقت: 5.50 ms / 1098.05 ms الذاكرة: 0.151 MB / 13.26 MB Application: afterRenderModule mod_sj_k2_mega_news (Mega list)
الوقت: 28.84 ms / 1126.89 ms الذاكرة: -0.346 MB / 12.91 MB Application: beforeRenderModule mod_sj_k2_extra_slider (Slider Pie de Pagina)
الوقت: 14.01 ms / 1140.89 ms الذاكرة: 3.190 MB / 16.10 MB Application: afterRenderModule mod_sj_k2_extra_slider (Slider Pie de Pagina)
الوقت: 39.75 ms / 1180.65 ms الذاكرة: -1.392 MB / 14.71 MB Application: afterRender
كافة إستعلامات قاعدة البيانات: 309.07 ms
15.24 MB (15,985,208 بايت (Bytes))
49 الاستعلامات المسجلة 309.07 ms
20 تكرار موجود!
- وقت الإستعلام: 1.73 ms إستعلام الذاكرة: 0.023 MB الذاكرة بعد الإستعلام: 1.034 MB إرجاع الصفوف: 0
SELECT `data`
FROM `c2081958_session`
WHERE `session_id` = X'64386e35643333386468673568673262336935737567346b6563'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.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms executing 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 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 - وقت الإستعلام: 2.28 ms قبل آخر إستعلام: 0.82 ms إستعلام الذاكرة: 0.020 MB الذاكرة بعد الإستعلام: 1.049 MB إرجاع الصفوف: 0
SELECT `session_id`
FROM `c2081958_session`
WHERE `session_id` = X'64386e35643333386468673568673262336935737567346b6563'
LIMIT 1id 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 Using index 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.01 ms statistics 0.02 ms executing 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 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - وقت الإستعلام: 2.42 ms قبل آخر إستعلام: 0.07 ms إستعلام الذاكرة: 0.004 MB الذاكرة بعد الإستعلام: 1.054 MB
INSERT INTO `c2081958_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'64386e35643333386468673568673262336935737567346b6563', 1, 1788102468, 0, '', 0)التوضيح غير ممكن للإستعلام: INSERT INTO `c2081958_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'64386e35643333386468673568673262336935737567346b6563', 1, 1788102468, 0, '', 0)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 update 0.06 ms Waiting for query cache lock 0.00 ms update 0.01 ms end 0.00 ms query end 0.52 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - وقت الإستعلام: 2.91 ms قبل آخر إستعلام: 2.68 ms إستعلام الذاكرة: 0.021 MB الذاكرة بعد الإستعلام: 1.138 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.02 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: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 - وقت الإستعلام: 1.67 ms قبل آخر إستعلام: 0.07 ms إستعلام الذاكرة: 0.021 MB الذاكرة بعد الإستعلام: 1.151 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.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.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.32 ms قبل آخر إستعلام: 51.56 ms إستعلام الذاكرة: 0.006 MB الذاكرة بعد الإستعلام: 3.296 MB
UPDATE `c2081958_extensions`
SET `params` = '{\"mediaversion\":\"98c5a01249bcf8772945fba4cd753b15\"}'
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.04 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.47 ms closing tables 0.02 ms freeing items 0.02 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 - وقت الإستعلام: 4.37 ms قبل آخر إستعلام: 14.11 ms إستعلام الذاكرة: 0.025 MB الذاكرة بعد الإستعلام: 3.819 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.00 ms Opening tables 0.03 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.01 ms executing 0.00 ms Sending data 0.21 ms end 0.00 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 - وقت الإستعلام: 2.16 ms قبل آخر إستعلام: 8.19 ms إستعلام الذاكرة: 0.023 MB الذاكرة بعد الإستعلام: 4.009 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.01 ms checking permissions 0.00 ms Opening tables 0.12 ms init 0.01 ms System lock 0.00 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 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 - وقت الإستعلام: 3.89 ms قبل آخر إستعلام: 0.93 ms إستعلام الذاكرة: 0.029 MB الذاكرة بعد الإستعلام: 4.022 MB إرجاع الصفوف: 17
SHOW FULL COLUMNS
FROM `c2081958_users`التوضيح غير ممكن للإستعلام: SHOW FULL COLUMNS FROM `c2081958_users`Status Duration starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.07 ms init 0.00 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.00 ms preparing 0.01 ms executing 0.01 ms Opening tables 0.09 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.00 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 checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.00 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 Sending data 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.03 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 - وقت الإستعلام: 3.54 ms قبل آخر إستعلام: 1.18 ms إستعلام الذاكرة: 0.025 MB الذاكرة بعد الإستعلام: 4.055 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.01 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.02 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 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 - وقت الإستعلام: 2.06 ms قبل آخر إستعلام: 2.14 ms إستعلام الذاكرة: 0.025 MB الذاكرة بعد الإستعلام: 4.067 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.10 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.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 - وقت الإستعلام: 1.85 ms قبل آخر إستعلام: 0.12 ms إستعلام الذاكرة: 0.023 MB الذاكرة بعد الإستعلام: 4.072 MB إرجاع الصفوف: 1الإستعلامات المتكررة: #13
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.01 ms Opening tables 0.10 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.02 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 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 - وقت الإستعلام: 1.80 ms قبل آخر إستعلام: 0.29 ms إستعلام الذاكرة: 0.023 MB الذاكرة بعد الإستعلام: 4.080 MB إرجاع الصفوف: 1الإستعلامات المتكررة: #12
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.00 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.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 - وقت الإستعلام: 213.86 ms قبل آخر إستعلام: 3.84 ms إستعلام الذاكرة: 10.913 MB الذاكرة بعد الإستعلام: 4.128 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-30 15:07:48' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-08-30 15:07:48' )
AND i.created_by=267
AND i.created_by_alias=''
ORDER BY i.id DESC
LIMIT 2954, 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.06 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.20 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.13 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 207.52 ms end 0.03 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: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 - وقت الإستعلام: 20.92 ms قبل آخر إستعلام: 4.15 ms إستعلام الذاكرة: 0.023 MB الذاكرة بعد الإستعلام: 11.216 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-30 15:07:48' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-08-30 15:07:48' )
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.00 ms Opening tables 0.01 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.02 ms executing 0.00 ms Sending data 18.53 ms end 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 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 - وقت الإستعلام: 2.94 ms قبل آخر إستعلام: 1.61 ms إستعلام الذاكرة: 0.027 MB الذاكرة بعد الإستعلام: 11.232 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.10 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.00 ms checking permissions 0.01 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.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 - وقت الإستعلام: 2.35 ms قبل آخر إستعلام: 1.59 ms إستعلام الذاكرة: 0.025 MB الذاكرة بعد الإستعلام: 11.277 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.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.02 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 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.09 ms قبل آخر إستعلام: 1.36 ms إستعلام الذاكرة: 0.028 MB الذاكرة بعد الإستعلام: 11.351 MB إرجاع الصفوف: 1الإستعلامات المتكررة: #19
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 = 5634id 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.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.92 ms قبل آخر إستعلام: 0.15 ms إستعلام الذاكرة: 0.028 MB الذاكرة بعد الإستعلام: 11.364 MB إرجاع الصفوف: 1الإستعلامات المتكررة: #18
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 = 5634id 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.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.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 - وقت الإستعلام: 1.20 ms قبل آخر إستعلام: 0.80 ms إستعلام الذاكرة: 0.025 MB الذاكرة بعد الإستعلام: 11.421 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.03 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.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: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 - وقت الإستعلام: 4.05 ms قبل آخر إستعلام: 20.21 ms إستعلام الذاكرة: 0.026 MB الذاكرة بعد الإستعلام: 11.585 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.14 ms checking permissions 0.01 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.01 ms Opening tables 0.58 ms init 0.07 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.13 ms preparing 0.03 ms Creating tmp table 0.05 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.15 ms Creating sort index 0.03 ms end 0.01 ms query end 0.01 ms removing tmp table 0.03 ms query end 0.01 ms closing tables 0.05 ms freeing items 0.04 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 - وقت الإستعلام: 0.42 ms قبل آخر إستعلام: 15.30 ms إستعلام الذاكرة: 0.025 MB الذاكرة بعد الإستعلام: 11.720 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.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.02 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/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.67 ms قبل آخر إستعلام: 0.36 ms إستعلام الذاكرة: 0.028 MB الذاكرة بعد الإستعلام: 11.738 MB إرجاع الصفوف: 1الإستعلامات المتكررة: #24
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 = 5633id 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.00 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.01 ms end 0.01 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.90 ms قبل آخر إستعلام: 0.12 ms إستعلام الذاكرة: 0.028 MB الذاكرة بعد الإستعلام: 11.751 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 = 5633id 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.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 - وقت الإستعلام: 1.70 ms قبل آخر إستعلام: 179.74 ms إستعلام الذاكرة: 0.026 MB الذاكرة بعد الإستعلام: 11.790 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.19 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 Opening tables 0.05 ms init 0.08 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.18 ms preparing 0.04 ms Creating tmp table 0.05 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.16 ms Creating sort index 0.03 ms end 0.01 ms query end 0.01 ms removing tmp table 0.03 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 - وقت الإستعلام: 0.66 ms قبل آخر إستعلام: 5.83 ms إستعلام الذاكرة: 0.025 MB الذاكرة بعد الإستعلام: 11.818 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.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.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 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.49 ms قبل آخر إستعلام: 0.36 ms إستعلام الذاكرة: 0.028 MB الذاكرة بعد الإستعلام: 11.836 MB إرجاع الصفوف: 1الإستعلامات المتكررة: #28
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 = 5632id 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.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.38 ms قبل آخر إستعلام: 0.11 ms إستعلام الذاكرة: 0.028 MB الذاكرة بعد الإستعلام: 11.849 MB إرجاع الصفوف: 1الإستعلامات المتكررة: #27
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 = 5632id 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.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: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.70 ms قبل آخر إستعلام: 5.78 ms إستعلام الذاكرة: 0.026 MB الذاكرة بعد الإستعلام: 11.878 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.06 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.01 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.00 ms executing 0.00 ms Sending data 0.09 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.54 ms قبل آخر إستعلام: 8.11 ms إستعلام الذاكرة: 0.028 MB الذاكرة بعد الإستعلام: 11.910 MB إرجاع الصفوف: 1الإستعلامات المتكررة: #31
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 = 5631id 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.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.32 ms قبل آخر إستعلام: 0.12 ms إستعلام الذاكرة: 0.028 MB الذاكرة بعد الإستعلام: 11.923 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 = 5631id 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.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.46 ms قبل آخر إستعلام: 125.25 ms إستعلام الذاكرة: 0.028 MB الذاكرة بعد الإستعلام: 11.972 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 = 5630id 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.00 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.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: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.51 ms قبل آخر إستعلام: 0.13 ms إستعلام الذاكرة: 0.029 MB الذاكرة بعد الإستعلام: 11.992 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 = 5630id 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.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: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.41 ms قبل آخر إستعلام: 9.34 ms إستعلام الذاكرة: 0.028 MB الذاكرة بعد الإستعلام: 12.043 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 = 5629id 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.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: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.50 ms قبل آخر إستعلام: 0.12 ms إستعلام الذاكرة: 0.028 MB الذاكرة بعد الإستعلام: 12.056 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 = 5629id 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.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: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.67 ms قبل آخر إستعلام: 18.37 ms إستعلام الذاكرة: 0.025 MB الذاكرة بعد الإستعلام: 12.101 MB إرجاع الصفوف: 1
SELECT *
FROM c2081958_k2_categories
WHERE id = '81'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.07 ms checking permissions 0.02 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 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.74 ms قبل آخر إستعلام: 0.35 ms إستعلام الذاكرة: 0.028 MB الذاكرة بعد الإستعلام: 12.120 MB إرجاع الصفوف: 1الإستعلامات المتكررة: #38
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 = 5628id 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.11 ms checking permissions 0.02 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.01 ms executing 0.01 ms Sending data 0.02 ms end 0.01 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 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.62 ms قبل آخر إستعلام: 0.10 ms إستعلام الذاكرة: 0.028 MB الذاكرة بعد الإستعلام: 12.133 MB إرجاع الصفوف: 1الإستعلامات المتكررة: #37
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 = 5628id 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.10 ms checking permissions 0.02 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.06 ms preparing 0.01 ms executing 0.01 ms Sending data 0.02 ms end 0.01 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 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.42 ms قبل آخر إستعلام: 237.02 ms إستعلام الذاكرة: 0.026 MB الذاكرة بعد الإستعلام: 12.161 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 (81,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.09 ms Creating sort index 0.02 ms end 0.01 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.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 - وقت الإستعلام: 1.54 ms قبل آخر إستعلام: 10.19 ms إستعلام الذاكرة: 0.021 MB الذاكرة بعد الإستعلام: 12.215 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.02 ms checking permissions 0.00 ms Opening tables 0.03 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.10 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/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.37 ms قبل آخر إستعلام: 3.73 ms إستعلام الذاكرة: 0.022 MB الذاكرة بعد الإستعلام: 12.239 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.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.00 ms end 0.00 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 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.38 ms قبل آخر إستعلام: 0.03 ms إستعلام الذاكرة: 0.022 MB الذاكرة بعد الإستعلام: 12.246 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.03 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 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.34 ms قبل آخر إستعلام: 3.30 ms إستعلام الذاكرة: 0.021 MB الذاكرة بعد الإستعلام: 12.336 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.00 ms init 0.00 ms System lock 0.00 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.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.26 ms قبل آخر إستعلام: 0.02 ms إستعلام الذاكرة: 0.021 MB الذاكرة بعد الإستعلام: 12.341 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.00 ms init 0.00 ms System lock 0.00 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.00 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 - وقت الإستعلام: 1.78 ms قبل آخر إستعلام: 14.50 ms إستعلام الذاكرة: 0.024 MB الذاكرة بعد الإستعلام: 13.059 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.02 ms checking permissions 0.00 ms Opening tables 0.03 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.15 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 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 - وقت الإستعلام: 2.05 ms قبل آخر إستعلام: 1.89 ms إستعلام الذاكرة: 0.029 MB الذاكرة بعد الإستعلام: 13.101 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.05 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.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms Creating tmp table 0.03 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.09 ms Creating sort index 0.02 ms end 0.00 ms query end 0.00 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 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.77 ms قبل آخر إستعلام: 13.19 ms إستعلام الذاكرة: 0.022 MB الذاكرة بعد الإستعلام: 12.819 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.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.01 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 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.68 ms قبل آخر إستعلام: 0.02 ms إستعلام الذاكرة: 0.022 MB الذاكرة بعد الإستعلام: 12.825 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.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 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.48 ms قبل آخر إستعلام: 67.20 ms إستعلام الذاكرة: 0.020 MB الذاكرة بعد الإستعلام: 14.699 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.04 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.01 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: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
25 أنواع الاستعلامات المسجلة, مصنفة حسب حالة الظهور تنازلياً
تحديد الجداول:
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.id5 × SELECT *
FROM c2081958_k2_categories4 × SELECT home
FROM c2081958_menu4 × 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 `data`
FROM `c2081958_session`1 × 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 COUNT(*)
FROM c2081958_k2_items as i RIGHT JOIN c2081958_k2_categories c
ON c.id = i.catid1 × SELECT `session_id`
FROM `c2081958_session`1 × 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 id, rules
FROM `c2081958_viewlevels1 × SELECT template
FROM c2081958_template_styles
جداول أخرى:
1 × INSERT INTO `c2081958_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'64386e35643333386468673568673262336935737567346b6563', 1, 1788102468, 0, '', 01 × UPDATE `c2081958_extensions`
SET `params` = '{\"mediaversion\":\"98c5a01249bcf8772945fba4cd753b15\"}'1 × SHOW FULL COLUMNS
FROM `c2081958_users1 × SHOW FULL COLUMNS
FROM `c2081958_k2_categories