Tuesday May 14, 2024 7:00 PM CDT
Location: Ponchatoula Community Center
300 N 5th St., Ponchatoula LA 70454
Tuesday April 9, 2024 7:00 PM
Location: Amite Emergency Operations Center
114 N Laurel St, Amite LA 70422
April Meet & Greet (5 PM to 7 PM)
Commodores Pizza
114 NE Central Ave, Amite City, LA 70422 (map link)
- Details
- Written by Super User
Tuesday March 12, 2024 7:00 PM CDT
Location: Ponchatoula Community Center
300 N 5th St., Ponchatoula LA 70454
March Meet & Greet Over Food & Drinks (5 PM to 7 PM)
Toula Burger Co.
- Details
- Written by Super User
Thursday February 15, 2024 7:00 PM CDT
Location: Ponchatoula Community Center
300 N 5th St., Ponchatoula LA 70454
February Meet & Greet Over Food & Drinks (5 PM to 7 PM)
Don’s Seafood
If you would like to become a member of SELARC, please print out and complete the application/renewal form and return it with your check to: P.O. Box 1324, Hammond LA 70404. Thanks!
Florida Parishes VE Group - Testing sessions are scheduled for the last Sunday of each month [with the exception of holiday conflicts] at AmVets Post #68; 26890 Hwy 42 (jct. of Hwys 42 and 43) - Springfield, La. 70462 (approximately 3 miles south of I-12 at exit 32) at 2pm with $15 testing fee. Bring photo ID and any appropriate CSCE. For more information contact This email address is being protected from spambots. You need JavaScript enabled to view it. or Find an Amateur Radio License Exam in Your Area.
Birthday Wishes for February go out to Mary Pat Mason KE5KMM, David Catania N5QOX
If we missed your birthday, then please let us know.
SELARC Meeting Minutes
(Meeting Type: In-Person)
(Ponchatoula Community Center, LA)
January 9th, 2024
Call to order: Russ Plyler (WI5ARD) at 7:20 pm
Pledge of Allegiance: Russ Plyler (WI5ARD)
Introductions: Done
Minutes of previous meetings: Russ Plyler (WI5ARD)
- 1st motion to accept meeting minutes as posted by Tyrone Burns N5XES
- 2nd motion by Terry Williams N5TDW
- All Approved
Members present: Russ Plyler (WI5ARD), Mike Jackson (KI5GGP), William Harris (KF5YBY), Terry Williams (N5TDW), Tyrone Burns (N5XES), Bob Spahn (WD5BJW), Ryan Dellucky (KI5NMJ), Mary Melancon (KG5ITF), Dean Melancon (KG5AAE), Timothy Lynch Jr. (AG5XK), Timothy Lynch III (KJ5BRD), Ralph Shaw (K5CAV), Keith Samrow (KF5VLX), Greg Nothacker (W5IDD), George Carr (KB5ILL),Tracy Durio (N5CTZ)
Guest present: Mark Duncan (KJ5DKD), Deborah Young
Treasurers’ report: Mike Jackson (KI5GGP)
- 1st motion to accept the treasurer's Keith Samrow KF5VLX
- 2nd motion by Dean Melancon KG5AAE
- All Approved
Bills / Correspondence:
- Wood $92.49
- 1st Motion to pay Russell for the wood by Mike Jackson KI5GGP
- 2nd motion by Dean Melancon KG5AAE
- Post office PO Box $226.00
- 1st motion Tyrone Burns N5XES
- 2nd motion Dean Melancon KG5AAE
New member applications / renewals:
-Greg Nothacker
- 1st motion to accept by Tyrone Burns N5XES
- 2nd motion to accept by Russell Plyler WI5ARD
- All Approved.
Health and Welfare:
ARES report: Pat Mason (KE5KMN)
- Average check-ins have been running 15 check ins
Hamfest Committee: Tyrone Burns (N5XES)
- Ponchatoula Community Center
- Confirmed
- Confirmed Vendors
- The SignMan on 7/10
- Connector Guy - Richard East N5IAW
- Prizes (Other)
- Flex Radio
- Some “SWAG” for door prizes. (T-Shirts, Caps, Decals, and Flyers)
- Wireman
- Provided some gift certificates.
- Flex Radio
- Prizes (Main)
- 1st ICOM IC-7300
- 2nd RigExpert AA-650
- 3rd Yaesu FT-70DR
- 4th Yaesu FT-65R
- Tickets
- Time to sell tickets.
- Wrist Bands
- Ernie Bush (N5NIB) purchased wristbands for the hamfest.
- Food Vendor
- Boss Hog is confirmed. Same as last year. Tyrone to see if he will make coffee.
- Member Volunteers
- Ticket Sales
- Security
- Kids 12 and under are free.
- Speaker System
- How are the repairs being taken care of? Yes they have
Repeater Committee: Tyrone Burns (N5XES) & Russ Plyler (WI5ARD)
- Tickfaw
- Waiting to see when the grounding is down at the tower.
- Future Steps
- Insulation is on location and needs to be installed on the ceiling.
- Wall outlets have exposed wiring and burnt plugs that need to be corrected.
- Power distribution in the cabinet.
- 110 power wall sockets within the building.
- Thanks to Terry N5TDW just prior to OZONE Hamfest he swung by the Tickfaw site and picked up the Commander Technologies Repeater antenna and brought it to the club house in Ponchatoula.
- Hammond
- Tyrone programmed the 6-meter repeater of Pete’s. Waiting to see when to install. Still a question on the repeater controller needed.
- Future Steps
- Power distribution in the cabinet.
Packet:
- HMU (Hammond, LA, North Oaks Hospital)
- Operational
- PCC (Ponchatoula Community Center)
- Down while the radio desk is being put back together.
- NEW: W5TEO is back online in Hammond
- W5TEO-2 = Mail
- W5TEO-8 = NODE
- DOTD = Digi Alias
Old Business:
- Preparations have been done to get the shelf back into place for the Hamfest and Field Day. Lots more needs to happen but we need to be set up for both these events and then continue on the remainder of work.
Field Day: Mark Lacey (WX5RN)
- Winter Field Day The weekend after the Hamfest.
Training
- For the month of February 2024
- Learning what is type of Morse Code Keys are out there
- General Discussion on CW
- EMP Protection / Dave with OZONE on LRS (Lightning Rig Saver) Russ WI5ARD to contact Dave.
New Business:
- Congratulations on the new licenses and/or upgrades from the VE Session of the Florida Parishes VE Group.
- Technician
- Nathan Day - Slaughter, La. <This email address is being protected from spambots. You need JavaScript enabled to view it.>
- Lincoln Pranikoff - New Orleans, La. <This email address is being protected from spambots. You need JavaScript enabled to view it.>
- General
- Keith Day / KD5YVW - Slaughter, La. <This email address is being protected from spambots. You need JavaScript enabled to view it.>
- Matthew Day / KG5ABQ - Slaughter, La. <This email address is being protected from spambots. You need JavaScript enabled to view it.>
- Extra
- N/A
- Technician
- February Meet & Greet (5 PM to 7 PM)
- Don’s Seafood
- February Meeting (8 PM to 9 PM)
○ Ponchatoula Community Center
■ 300 N 5th St., Ponchatoula, LA 70454
Upcoming events / Hamfest / Cancellations:
- SELARC Hamfest
- Date: January 20th, 2024
- Ponchatoula Community Center, LA
- We are still in need of volunteers. Please email Tyrone Burns (N5XES).
- Capital City Hamfest
- Date: February 2nd, 3rd, 2024
- Jackson, MS
- Acadiana DX Hamfest
- Date: March 8th, 2024
- Rayne, LA
General discussion, presentation, or training:
- QRP- George Carr (KB5ILL) January
- ARRL Section Manager Election
- Ballots are on their rail and should arrive in the mail soon. Matt Anderson KD5KNZ who currently is in the position is asking for our votes to continue on in the LA Section Manager position he currently holds after John Mark stepped down.
- Your ballot must be returned by Friday, February 16, by 4 PM.
- Fox hunt for Ham fest
Motion to adjourn:
- 1st motion to adjourn meeting by Tyrone Burns
- 2nd motion by Keith Samron KF5VLX
- All Approved.
- The First Amateur Radio Station on the Moon, JS1YMG, is Now Transmitting
- ARRL Midwest Division Convention, Winterfest
- Heil Sound Donates Equipment to W1AW
- ARRL Foundation Accepting Grant Applications in February
- Winter Field Day a Success for Ohio Club
- ARRL Board Approves Free Membership for Students, New Vice Presidents Elected
- YLISSB Celebrates 61 Years On the Air
- Dr. Philip Erickson, W1PJE, New Director of MIT Haystack Observatory
- ARRL is New Publisher of Gordon West, WB6NOA
- Amateur Radio Club Donation Helps Mississippi Library
- Georgia State Parks on the Air 2024
- Radio Help Wanted: Must Like Geysers, Bison, and Helicopter Rides
- Upcoming Contests:
- ARRL Responds to FCC Proposals
- 2024 Orlando HamCation Awards
- ARRL Kids Day a Success in Nebraska
- Winter Field Day 2024
- "Marty on the Mountain" Engstrom, N1ARY (SK)
--The ARRL Letter and The American Radio Relay League
================================================
Stay Radio active -- Hope to see you at the next meeting. Be sure to monitor your weekly nets, e-mail, and the SELARC website at https://www.selarc.org for any updates.
================================================
Page 4 of 29
- You are here:
- Home
Older Posts
Popular Tags
Photo Gallery - Categories
Photo Albums
Most Read Posts
Joomla! Debug Console
{ "__default": { "session": { "counter": 1, "timer": { "start": 1743659431, "last": 1743659431, "now": 1743659431 }, "client": { "forwarded": "18.226.187.198" }, "token": "XBgfC2vp8a3fjhpNkJP0GXQVmLZC65WA" }, "registry": { "com_attachments": { "current_url": "&return=aHR0cHM6Ly93d3djbXMuc2VsYXJjLm9yZy8%2Fc3RhcnQ9MTI%3D" } }, "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 } } }
Time
Memory
46 Queries Logged 49.41 ms
- Query Time: 1.22 ms Query memory: 0.023 MB Memory before query: 1.026 MB Rows returned: 0
SELECT `data`
FROM `sjla_session`
WHERE `session_id` = X'6674386b7435646a30377276736d63693330386d716535326a63'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sjla_session const PRIMARY PRIMARY 194 const 1 Status Duration Starting 0.15 ms Checking permissions 0.01 ms Opening tables 0.17 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.02 ms Init 0.06 ms Optimizing 0.03 ms Statistics 0.13 ms Preparing 0.01 ms Executing 0.33 ms End of update loop 0.02 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.00 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 - Query Time: 0.47 ms After last query: 0.96 ms Query memory: 0.020 MB Memory before query: 1.040 MB Rows returned: 0
SELECT `session_id`
FROM `sjla_session`
WHERE `session_id` = X'6674386b7435646a30377276736d63693330386d716535326a63'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sjla_session const PRIMARY PRIMARY 194 const 1 Using index Status Duration Starting 0.07 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.01 ms Executing 0.12 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 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 - Query Time: 1.69 ms After last query: 0.25 ms Query memory: 0.004 MB Memory before query: 1.045 MB
INSERT INTO `sjla_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6674386b7435646a30377276736d63693330386d716535326a63', 1, 1743659431, 0, '', 0)EXPLAIN not possible on query: INSERT INTO `sjla_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6674386b7435646a30377276736d63693330386d716535326a63', 1, 1743659431, 0, '', 0)Status Duration Starting 0.06 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.01 ms Init for update 0.03 ms Update 0.33 ms Waiting for query cache lock 0.01 ms Update 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 1.08 ms Closing tables 0.01 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 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 - Query Time: 0.54 ms After last query: 2.66 ms Query memory: 0.021 MB Memory before query: 1.188 MB Rows returned: 5
SELECT id, rules
FROM `sjla_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sjla_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5 Status Duration Starting 0.04 ms Checking permissions 0.01 ms Opening tables 0.09 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.19 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 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 - Query Time: 0.72 ms After last query: 0.23 ms Query memory: 0.021 MB Memory before query: 1.201 MB Rows returned: 2
SELECT b.id
FROM sjla_usergroups AS a
LEFT JOIN sjla_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b index idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 8 NULL 9 Using where; Using index Status Duration Starting 0.07 ms Checking permissions 0.01 ms Opening tables 0.07 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.17 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.03 ms Executing 0.00 ms Sending data 0.15 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 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 - Query Time: 0.75 ms After last query: 11.13 ms Query memory: 0.021 MB Memory before query: 1.829 MB Rows returned: 1
SELECT `name`
FROM `sjla_extensions`
WHERE `type` = 'package'
AND `element` = 'pkg_eventgallery_full'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sjla_extensions ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 Using index condition; Using where Status Duration Starting 0.07 ms Checking permissions 0.01 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.17 ms Preparing 0.03 ms Executing 0.00 ms Sending data 0.17 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.02 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 9 JDatabaseDriver->loadResult() JROOT/administrator/components/com_eventgallery/version.php:24 8 include_once JROOT/administrator/components/com_eventgallery/version.php JROOT/plugins/system/picasaupdater/picasaupdater.php:32 7 plgSystemPicasaupdater->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.33 ms After last query: 29.36 ms Query memory: 0.027 MB Memory before query: 2.336 MB Rows returned: 40
SELECT `id`,`name`,`rules`,`parent_id`
FROM `sjla_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_advancedmodules','com_ajax','com_akeeba','com_associations','com_attachments','com_banners','com_breezingforms','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_eventgallery','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sjla_assets ALL idx_asset_name NO INDEX KEY COULD BE USED NULL NULL 239 Using where Status Duration Starting 0.14 ms Checking permissions 0.01 ms Opening tables 0.08 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.14 ms Optimizing 0.05 ms Statistics 0.33 ms Preparing 0.03 ms Executing 0.00 ms Sending data 1.30 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.00 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.00 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 15 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 14 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 13 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 12 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 11 Joomla\CMS\User\User->authorise() JROOT/plugins/system/advancedmodules/src/Document.php:30 10 RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript() JROOT/plugins/system/advancedmodules/advancedmodules.php:95 9 PlgSystemAdvancedModules->handleOnAfterRoute() JROOT/libraries/regularlabs/src/SystemPlugin.php:191 8 RegularLabs\Library\SystemPlugin->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 - Query Time: 1.35 ms After last query: 1.82 ms Query memory: 0.005 MB Memory before query: 2.404 MB
UPDATE `sjla_extensions`
SET `params` = '{\"mediaversion\":\"75e115a304aebe61d91691dd9821e777\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN not possible on query: UPDATE `sjla_extensions` SET `params` = '{\"mediaversion\":\"75e115a304aebe61d91691dd9821e777\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.07 ms Checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms Init for update 0.13 ms Updating 0.16 ms End of update loop 0.01 ms Waiting for query cache lock 0.00 ms End of update loop 0.02 ms Query end 0.00 ms Commit 0.77 ms Closing tables 0.01 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 9 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 8 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1137 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 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 - Query Time: 1.29 ms After last query: 7.75 ms Query memory: 0.040 MB Memory before query: 2.644 MB Rows returned: 148
SELECT `id`,`name`,`rules`,`parent_id`
FROM `sjla_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sjla_assets ALL idx_asset_name,idx_parent_id NO INDEX KEY COULD BE USED NULL NULL 239 Using where Status Duration Starting 0.12 ms Checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.05 ms Optimizing 0.03 ms Statistics 0.11 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.62 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.00 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 19 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 18 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 17 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 16 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 15 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/category.php:139 14 ContentModelCategory->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 13 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/libraries/src/MVC/View/CategoryView.php:116 12 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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 - Query Time: 3.76 ms After last query: 2.87 ms Query memory: 0.028 MB Memory before query: 2.785 MB Rows returned: 8
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`)
FROM `sjla_content` AS `i`
WHERE i.`catid` = c.id
AND i.state = 1) AS numitems
FROM `sjla_categories` AS `s`
INNER JOIN `sjla_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.published = 1
AND s.id = 9
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 PRIMARY c ALL cat_idx,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 28 Using where; Using filesort 2 DEPENDENT SUBQUERY i ref idx_state,idx_catid idx_catid 4 jdb7971082.c.id 5 Using index condition; Using where Status Duration Starting 0.25 ms Checking permissions 0.01 ms Opening tables 0.26 ms After opening tables 0.02 ms System lock 0.01 ms Table lock 0.01 ms Init 0.20 ms Optimizing 0.06 ms Statistics 0.26 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.03 ms Optimizing 0.02 ms Statistics 0.08 ms Preparing 0.06 ms Sorting result 0.02 ms Executing 0.00 ms Sending data 0.04 ms Creating sort index 0.29 ms Executing 0.01 ms Sending data 0.06 ms Executing 0.00 ms Sending data 0.03 ms Executing 0.00 ms Sending data 1.07 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.00 ms Sending data 0.03 ms Executing 0.00 ms Sending data 0.05 ms Executing 0.00 ms Sending data 0.03 ms Executing 0.00 ms Sending data 0.20 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.00 ms Unlocking tables 0.01 ms Closing tables 0.23 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Removing tmp table 0.01 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 16 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 15 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/models/category.php:355 14 ContentModelCategory->getCategory() JROOT/libraries/src/MVC/View/HtmlView.php:425 13 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:122 12 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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 - Query Time: 3.78 ms After last query: 2.65 ms Query memory: 0.122 MB Memory before query: 2.848 MB Rows returned: 6
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
FROM sjla_content AS a
LEFT JOIN sjla_categories AS c
ON c.id = a.catid
LEFT JOIN sjla_users AS ua
ON ua.id = a.created_by
LEFT JOIN sjla_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sjla_categories as parent
ON parent.id = c.parent_id
WHERE c.published = 1
AND a.state = 1
AND (a.catid = 9 OR a.catid IN ( SELECT sub.id
FROM sjla_categories as sub
INNER JOIN sjla_categories as this
ON sub.lft > this.lft
AND sub.rgt < this.rgt
WHERE this.id = 9
AND sub.level <= this.level + 1))
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-04-03 05:50:31')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-04-03 05:50:31')
ORDER BY
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created
LIMIT 12, 6id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY a ref idx_state,idx_catid idx_state 1 const 116 Using where; Using filesort 1 PRIMARY c eq_ref PRIMARY PRIMARY 4 jdb7971082.a.catid 1 Using where 1 PRIMARY ua eq_ref PRIMARY PRIMARY 4 jdb7971082.a.created_by 1 Using where 1 PRIMARY uam eq_ref PRIMARY PRIMARY 4 jdb7971082.a.modified_by 1 Using where 1 PRIMARY parent eq_ref PRIMARY PRIMARY 4 jdb7971082.c.parent_id 1 Using where 2 MATERIALIZED this const PRIMARY,idx_left_right PRIMARY 4 const 1 2 MATERIALIZED sub ALL PRIMARY,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 28 Using where Status Duration Starting 0.34 ms Checking permissions 0.01 ms Opening tables 0.22 ms After opening tables 0.02 ms System lock 0.01 ms Table lock 0.01 ms Init 0.17 ms Optimizing 0.11 ms Statistics 0.12 ms Preparing 0.06 ms Optimizing 0.02 ms Statistics 0.24 ms Preparing 0.06 ms Sorting result 0.02 ms Executing 0.00 ms Sending data 0.04 ms Creating sort index 0.18 ms Executing 0.01 ms Sending data 1.41 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.40 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Removing tmp table 0.01 ms Freeing items 0.02 ms Removing tmp table 0.00 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:576 15 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 14 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 13 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 12 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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 - Query Time: 0.94 ms After last query: 1.50 ms Query memory: 0.024 MB Memory before query: 2.994 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `sjla_contentitem_tag_map` AS m
INNER JOIN `sjla_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 122
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type NO INDEX KEY COULD BE USED NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 jdb7971082.m.tag_id 1 Using where Status Duration Starting 0.10 ms Checking permissions 0.01 ms Opening tables 0.13 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.07 ms Optimizing 0.04 ms Statistics 0.11 ms Preparing 0.03 ms Executing 0.00 ms Sending data 0.21 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 16 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 15 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 14 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 13 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 12 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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 - Query Time: 0.66 ms After last query: 0.69 ms Query memory: 0.024 MB Memory before query: 3.012 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `sjla_contentitem_tag_map` AS m
INNER JOIN `sjla_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 121
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type NO INDEX KEY COULD BE USED NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 jdb7971082.m.tag_id 1 Using where Status Duration Starting 0.09 ms Checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.01 ms Init 0.05 ms Optimizing 0.07 ms Statistics 0.06 ms Preparing 0.03 ms Executing 0.00 ms Sending data 0.14 ms End of update loop 0.00 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 16 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 15 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 14 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 13 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 12 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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 - Query Time: 0.59 ms After last query: 0.58 ms Query memory: 0.024 MB Memory before query: 3.030 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `sjla_contentitem_tag_map` AS m
INNER JOIN `sjla_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 120
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type NO INDEX KEY COULD BE USED NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 jdb7971082.m.tag_id 1 Using where Status Duration Starting 0.08 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms Init 0.05 ms Optimizing 0.03 ms Statistics 0.05 ms Preparing 0.03 ms Executing 0.00 ms Sending data 0.15 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 16 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 15 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 14 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 13 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 12 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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 - Query Time: 0.66 ms After last query: 0.51 ms Query memory: 0.024 MB Memory before query: 3.048 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `sjla_contentitem_tag_map` AS m
INNER JOIN `sjla_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 119
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type NO INDEX KEY COULD BE USED NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 jdb7971082.m.tag_id 1 Using where Status Duration Starting 0.06 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms Init 0.08 ms Optimizing 0.03 ms Statistics 0.05 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.16 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 16 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 15 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 14 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 13 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 12 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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 - Query Time: 0.61 ms After last query: 0.55 ms Query memory: 0.024 MB Memory before query: 3.065 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `sjla_contentitem_tag_map` AS m
INNER JOIN `sjla_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 118
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type NO INDEX KEY COULD BE USED NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 jdb7971082.m.tag_id 1 Using where Status Duration Starting 0.07 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms Init 0.05 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.03 ms Executing 0.00 ms Sending data 0.16 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 16 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 15 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 14 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 13 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 12 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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 - Query Time: 0.63 ms After last query: 0.64 ms Query memory: 0.025 MB Memory before query: 3.085 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `sjla_contentitem_tag_map` AS m
INNER JOIN `sjla_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 113
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type NO INDEX KEY COULD BE USED NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 jdb7971082.m.tag_id 1 Using where Status Duration Starting 0.06 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms Init 0.04 ms Optimizing 0.03 ms Statistics 0.07 ms Preparing 0.03 ms Executing 0.00 ms Sending data 0.21 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.00 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 16 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 15 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 14 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 13 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 12 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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 - Query Time: 1.62 ms After last query: 0.77 ms Query memory: 0.025 MB Memory before query: 3.095 MB Rows returned: 1
SELECT COUNT(*)
FROM sjla_content AS a
LEFT JOIN sjla_categories AS c
ON c.id = a.catid
LEFT JOIN sjla_users AS ua
ON ua.id = a.created_by
LEFT JOIN sjla_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sjla_categories as parent
ON parent.id = c.parent_id
WHERE c.published = 1
AND a.state = 1
AND (a.catid = 9 OR a.catid IN ( SELECT sub.id
FROM sjla_categories as sub
INNER JOIN sjla_categories as this
ON sub.lft > this.lft
AND sub.rgt < this.rgt
WHERE this.id = 9
AND sub.level <= this.level + 1))
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-04-03 05:50:31')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-04-03 05:50:31')id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY a ref idx_state,idx_catid idx_state 1 const 116 Using where 1 PRIMARY c eq_ref PRIMARY PRIMARY 4 jdb7971082.a.catid 1 Using where 2 MATERIALIZED this const PRIMARY,idx_left_right PRIMARY 4 const 1 2 MATERIALIZED sub ALL PRIMARY,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 28 Using where Status Duration Starting 0.14 ms Checking permissions 0.01 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.07 ms Optimizing 0.05 ms Statistics 0.07 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.03 ms Optimizing 0.02 ms Statistics 0.08 ms Preparing 0.03 ms Executing 0.00 ms Sending data 0.07 ms Executing 0.00 ms Sending data 0.60 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.14 ms Closing tables 0.01 ms Unlocking tables 0.00 ms Closing tables 0.05 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Removing tmp table 0.01 ms Freeing items 0.02 ms Removing tmp table 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 18 JDatabaseDriver->loadResult() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() JROOT/libraries/src/MVC/Model/ListModel.php:289 16 Joomla\CMS\MVC\Model\ListModel->getTotal() JROOT/libraries/src/MVC/Model/ListModel.php:239 15 Joomla\CMS\MVC\Model\ListModel->getPagination() JROOT/components/com_content/models/category.php:265 14 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 13 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 12 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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 - Query Time: 0.54 ms After last query: 0.53 ms Query memory: 0.023 MB Memory before query: 3.099 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `sjla_contentitem_tag_map` AS m
INNER JOIN `sjla_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.category'
AND `m`.`content_item_id` = 9
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type NO INDEX KEY COULD BE USED NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 jdb7971082.m.tag_id 1 Using where Status Duration Starting 0.06 ms Checking permissions 0.00 ms Opening tables 0.03 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms Init 0.05 ms Optimizing 0.03 ms Statistics 0.05 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.13 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 13 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/libraries/src/MVC/View/CategoryView.php:229 12 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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 - Query Time: 1.25 ms After last query: 5.23 ms Query memory: 0.027 MB Memory before query: 3.356 MB Rows returned: 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `sjla_categories` AS `s`
INNER JOIN `sjla_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 12
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 28 Using where; Using filesort Status Duration Starting 0.23 ms Checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.07 ms Optimizing 0.05 ms Statistics 0.18 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.03 ms Sorting result 0.06 ms Executing 0.01 ms Sending data 0.03 ms Creating sort index 0.27 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 20 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 19 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203 18 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:140 17 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:194 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 14 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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 - Query Time: 2.39 ms After last query: 0.54 ms Query memory: 0.025 MB Memory before query: 3.377 MB Rows returned: 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 sjla_fields AS a
LEFT JOIN `sjla_languages` AS l
ON l.lang_code = a.language
LEFT JOIN sjla_users AS uc
ON uc.id=a.checked_out
LEFT JOIN sjla_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN sjla_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN sjla_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `sjla_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (12,0,9))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Using filesort 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 jdb7971082.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 jdb7971082.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 jdb7971082.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 jdb7971082.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 jdb7971082.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 jdb7971082.a.id 1 Using where; Using index; Distinct Status Duration Starting 0.20 ms Checking permissions 0.01 ms Opening tables 0.25 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.01 ms Init 0.11 ms Optimizing 0.06 ms Statistics 0.32 ms Preparing 0.07 ms Creating tmp table 0.11 ms Sorting result 0.02 ms Executing 0.00 ms Sending data 0.63 ms Creating sort index 0.07 ms Removing tmp table 0.11 ms Creating sort index 0.15 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.03 ms Starting cleanup 0.00 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 18 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 17 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 14 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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 - Query Time: 0.67 ms After last query: 7.40 ms Query memory: 0.024 MB Memory before query: 3.533 MB Rows returned: 1
SELECT created_by, catid
FROM sjla_content
WHERE id = 122id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sjla_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.07 ms Checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.10 ms Preparing 0.01 ms Unlocking tables 0.15 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:809 15 AttachmentsPlugin_Com_Content->attachmentsHiddenForParent() JROOT/plugins/content/attachments/attachments.php:202 14 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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 - Query Time: 0.85 ms After last query: 1.61 ms Query memory: 0.025 MB Memory before query: 3.574 MB Rows returned: 0
SELECT a.*, u.name as creator_name
FROM sjla_attachments AS a
LEFT JOIN sjla_users AS u
ON u.id = a.created_by
WHERE a.parent_id=122
AND a.state = 1
AND a.parent_type='com_content'
AND a.parent_entity='article'
AND a.access IN (1,5)
ORDER BY filenameid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL NULL NO INDEX KEY COULD BE USED NULL NULL 23 Using where; Using filesort 1 SIMPLE u eq_ref PRIMARY PRIMARY 4 jdb7971082.a.created_by 1 Status Duration Starting 0.11 ms Checking permissions 0.01 ms Opening tables 0.07 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms Init 0.07 ms Optimizing 0.04 ms Statistics 0.03 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.24 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/components/com_attachments/models/attachments.php:436 18 AttachmentsModelAttachments->getAttachmentsList() JROOT/components/com_attachments/models/attachments.php:514 17 AttachmentsModelAttachments->someVisible() JROOT/components/com_attachments/controllers/attachments.php:98 16 AttachmentsControllerAttachments->displayString() JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911 15 AttachmentsPlugin->insertAttachmentsList() JROOT/plugins/content/attachments/attachments.php:218 14 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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 - Query Time: 0.48 ms After last query: 4.25 ms Query memory: 0.024 MB Memory before query: 3.606 MB Rows returned: 1
SELECT created_by, catid
FROM sjla_content
WHERE id = 121id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sjla_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.07 ms Checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.05 ms Preparing 0.00 ms Unlocking tables 0.11 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:809 15 AttachmentsPlugin_Com_Content->attachmentsHiddenForParent() JROOT/plugins/content/attachments/attachments.php:202 14 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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 - Query Time: 0.68 ms After last query: 0.88 ms Query memory: 0.025 MB Memory before query: 3.622 MB Rows returned: 0
SELECT a.*, u.name as creator_name
FROM sjla_attachments AS a
LEFT JOIN sjla_users AS u
ON u.id = a.created_by
WHERE a.parent_id=121
AND a.state = 1
AND a.parent_type='com_content'
AND a.parent_entity='article'
AND a.access IN (1,5)
ORDER BY filenameid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL NULL NO INDEX KEY COULD BE USED NULL NULL 23 Using where; Using filesort 1 SIMPLE u eq_ref PRIMARY PRIMARY 4 jdb7971082.a.created_by 1 Status Duration Starting 0.09 ms Checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms Init 0.10 ms Optimizing 0.03 ms Statistics 0.02 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.17 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/components/com_attachments/models/attachments.php:436 18 AttachmentsModelAttachments->getAttachmentsList() JROOT/components/com_attachments/models/attachments.php:514 17 AttachmentsModelAttachments->someVisible() JROOT/components/com_attachments/controllers/attachments.php:98 16 AttachmentsControllerAttachments->displayString() JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911 15 AttachmentsPlugin->insertAttachmentsList() JROOT/plugins/content/attachments/attachments.php:218 14 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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 - Query Time: 0.47 ms After last query: 3.71 ms Query memory: 0.024 MB Memory before query: 3.627 MB Rows returned: 1
SELECT created_by, catid
FROM sjla_content
WHERE id = 120id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sjla_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.05 ms Checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.06 ms Preparing 0.01 ms Unlocking tables 0.13 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:809 15 AttachmentsPlugin_Com_Content->attachmentsHiddenForParent() JROOT/plugins/content/attachments/attachments.php:202 14 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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 - Query Time: 0.66 ms After last query: 1.08 ms Query memory: 0.025 MB Memory before query: 3.643 MB Rows returned: 0
SELECT a.*, u.name as creator_name
FROM sjla_attachments AS a
LEFT JOIN sjla_users AS u
ON u.id = a.created_by
WHERE a.parent_id=120
AND a.state = 1
AND a.parent_type='com_content'
AND a.parent_entity='article'
AND a.access IN (1,5)
ORDER BY filenameid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL NULL NO INDEX KEY COULD BE USED NULL NULL 23 Using where; Using filesort 1 SIMPLE u eq_ref PRIMARY PRIMARY 4 jdb7971082.a.created_by 1 Status Duration Starting 0.09 ms Checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms Init 0.06 ms Optimizing 0.03 ms Statistics 0.02 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.03 ms Creating sort index 0.18 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/components/com_attachments/models/attachments.php:436 18 AttachmentsModelAttachments->getAttachmentsList() JROOT/components/com_attachments/models/attachments.php:514 17 AttachmentsModelAttachments->someVisible() JROOT/components/com_attachments/controllers/attachments.php:98 16 AttachmentsControllerAttachments->displayString() JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911 15 AttachmentsPlugin->insertAttachmentsList() JROOT/plugins/content/attachments/attachments.php:218 14 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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 - Query Time: 0.58 ms After last query: 4.73 ms Query memory: 0.024 MB Memory before query: 3.677 MB Rows returned: 1
SELECT created_by, catid
FROM sjla_content
WHERE id = 119id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sjla_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.07 ms Checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.10 ms Preparing 0.01 ms Unlocking tables 0.11 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:809 15 AttachmentsPlugin_Com_Content->attachmentsHiddenForParent() JROOT/plugins/content/attachments/attachments.php:202 14 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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 - Query Time: 0.80 ms After last query: 1.24 ms Query memory: 0.025 MB Memory before query: 3.693 MB Rows returned: 0
SELECT a.*, u.name as creator_name
FROM sjla_attachments AS a
LEFT JOIN sjla_users AS u
ON u.id = a.created_by
WHERE a.parent_id=119
AND a.state = 1
AND a.parent_type='com_content'
AND a.parent_entity='article'
AND a.access IN (1,5)
ORDER BY filenameid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL NULL NO INDEX KEY COULD BE USED NULL NULL 23 Using where; Using filesort 1 SIMPLE u eq_ref PRIMARY PRIMARY 4 jdb7971082.a.created_by 1 Status Duration Starting 0.10 ms Checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.08 ms Optimizing 0.04 ms Statistics 0.03 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.26 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/components/com_attachments/models/attachments.php:436 18 AttachmentsModelAttachments->getAttachmentsList() JROOT/components/com_attachments/models/attachments.php:514 17 AttachmentsModelAttachments->someVisible() JROOT/components/com_attachments/controllers/attachments.php:98 16 AttachmentsControllerAttachments->displayString() JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911 15 AttachmentsPlugin->insertAttachmentsList() JROOT/plugins/content/attachments/attachments.php:218 14 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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 - Query Time: 0.53 ms After last query: 5.35 ms Query memory: 0.024 MB Memory before query: 3.687 MB Rows returned: 1
SELECT created_by, catid
FROM sjla_content
WHERE id = 118id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sjla_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.07 ms Checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.00 ms Unlocking tables 0.13 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:809 15 AttachmentsPlugin_Com_Content->attachmentsHiddenForParent() JROOT/plugins/content/attachments/attachments.php:202 14 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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 - Query Time: 0.68 ms After last query: 0.98 ms Query memory: 0.025 MB Memory before query: 3.703 MB Rows returned: 0
SELECT a.*, u.name as creator_name
FROM sjla_attachments AS a
LEFT JOIN sjla_users AS u
ON u.id = a.created_by
WHERE a.parent_id=118
AND a.state = 1
AND a.parent_type='com_content'
AND a.parent_entity='article'
AND a.access IN (1,5)
ORDER BY filenameid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL NULL NO INDEX KEY COULD BE USED NULL NULL 23 Using where; Using filesort 1 SIMPLE u eq_ref PRIMARY PRIMARY 4 jdb7971082.a.created_by 1 Status Duration Starting 0.09 ms Checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms Init 0.06 ms Optimizing 0.08 ms Statistics 0.03 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.17 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/components/com_attachments/models/attachments.php:436 18 AttachmentsModelAttachments->getAttachmentsList() JROOT/components/com_attachments/models/attachments.php:514 17 AttachmentsModelAttachments->someVisible() JROOT/components/com_attachments/controllers/attachments.php:98 16 AttachmentsControllerAttachments->displayString() JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911 15 AttachmentsPlugin->insertAttachmentsList() JROOT/plugins/content/attachments/attachments.php:218 14 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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 - Query Time: 1.76 ms After last query: 2.41 ms Query memory: 0.027 MB Memory before query: 3.718 MB Rows returned: 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `sjla_categories` AS `s`
INNER JOIN `sjla_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 10
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 28 Using where; Using filesort Status Duration Starting 0.15 ms Checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.00 ms Init 0.07 ms Optimizing 0.04 ms Statistics 0.16 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.03 ms Creating sort index 1.01 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.02 ms Starting cleanup 0.00 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 20 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 19 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203 18 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:140 17 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:194 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 14 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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 - Query Time: 1.55 ms After last query: 0.38 ms Query memory: 0.026 MB Memory before query: 3.731 MB Rows returned: 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 sjla_fields AS a
LEFT JOIN `sjla_languages` AS l
ON l.lang_code = a.language
LEFT JOIN sjla_users AS uc
ON uc.id=a.checked_out
LEFT JOIN sjla_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN sjla_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN sjla_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `sjla_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (10,0,9))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Using filesort 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 jdb7971082.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 jdb7971082.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 jdb7971082.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 jdb7971082.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 jdb7971082.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 jdb7971082.a.id 1 Using where; Using index; Distinct Status Duration Starting 0.21 ms Checking permissions 0.01 ms Opening tables 0.07 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.08 ms Optimizing 0.06 ms Statistics 0.25 ms Preparing 0.06 ms Creating tmp table 0.09 ms Sorting result 0.02 ms Executing 0.00 ms Sending data 0.39 ms Creating sort index 0.03 ms Removing tmp table 0.06 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.02 ms Starting cleanup 0.00 ms Freeing items 0.02 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 18 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 17 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 14 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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 - Query Time: 0.37 ms After last query: 1.17 ms Query memory: 0.024 MB Memory before query: 3.743 MB Rows returned: 1
SELECT created_by, catid
FROM sjla_content
WHERE id = 113id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sjla_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.05 ms Checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.01 ms Init 0.05 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.00 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:809 15 AttachmentsPlugin_Com_Content->attachmentsHiddenForParent() JROOT/plugins/content/attachments/attachments.php:202 14 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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 - Query Time: 0.50 ms After last query: 1.02 ms Query memory: 0.025 MB Memory before query: 3.759 MB Rows returned: 0
SELECT a.*, u.name as creator_name
FROM sjla_attachments AS a
LEFT JOIN sjla_users AS u
ON u.id = a.created_by
WHERE a.parent_id=113
AND a.state = 1
AND a.parent_type='com_content'
AND a.parent_entity='article'
AND a.access IN (1,5)
ORDER BY filenameid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL NULL NO INDEX KEY COULD BE USED NULL NULL 23 Using where; Using filesort 1 SIMPLE u eq_ref PRIMARY PRIMARY 4 jdb7971082.a.created_by 1 Status Duration Starting 0.08 ms Checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.01 ms Init 0.06 ms Optimizing 0.03 ms Statistics 0.02 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.07 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/components/com_attachments/models/attachments.php:436 18 AttachmentsModelAttachments->getAttachmentsList() JROOT/components/com_attachments/models/attachments.php:514 17 AttachmentsModelAttachments->someVisible() JROOT/components/com_attachments/controllers/attachments.php:98 16 AttachmentsControllerAttachments->displayString() JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911 15 AttachmentsPlugin->insertAttachmentsList() JROOT/plugins/content/attachments/attachments.php:218 14 plgContentAttachments->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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 - Query Time: 1.64 ms After last query: 4.45 ms Query memory: 0.027 MB Memory before query: 3.789 MB Rows returned: 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 sjla_fields AS a
LEFT JOIN `sjla_languages` AS l
ON l.lang_code = a.language
LEFT JOIN sjla_users AS uc
ON uc.id=a.checked_out
LEFT JOIN sjla_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN sjla_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN sjla_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_content.categories'
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Using filesort 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 jdb7971082.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 jdb7971082.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 jdb7971082.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 jdb7971082.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 jdb7971082.a.group_id 1 Using where Status Duration Starting 0.18 ms Checking permissions 0.01 ms Opening tables 0.08 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.11 ms Optimizing 0.06 ms Statistics 0.23 ms Preparing 0.05 ms Creating tmp table 0.08 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.45 ms Creating sort index 0.05 ms Removing tmp table 0.08 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.02 ms Starting cleanup 0.00 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.00 ms # Caller File and line number 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 23 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 22 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 21 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 20 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 19 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 18 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 17 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 16 JEventDispatcher->trigger() JROOT/components/com_content/views/category/tmpl/blog.php:19 15 include JROOT/components/com_content/views/category/tmpl/blog.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 13 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 12 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_content/views/category/view.html.php:250 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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 - Query Time: 1.64 ms After last query: 1.66 ms Query memory: 0.027 MB Memory before query: 3.816 MB Rows returned: 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 sjla_fields AS a
LEFT JOIN `sjla_languages` AS l
ON l.lang_code = a.language
LEFT JOIN sjla_users AS uc
ON uc.id=a.checked_out
LEFT JOIN sjla_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN sjla_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN sjla_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `sjla_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.categories'
AND (fc.category_id IS NULL OR fc.category_id IN (9,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Using filesort 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 jdb7971082.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 jdb7971082.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 jdb7971082.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 jdb7971082.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 jdb7971082.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 jdb7971082.a.id 1 Using where; Using index; Distinct Status Duration Starting 0.21 ms Checking permissions 0.01 ms Opening tables 0.10 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.09 ms Optimizing 0.06 ms Statistics 0.23 ms Preparing 0.05 ms Creating tmp table 0.07 ms Sorting result 0.02 ms Executing 0.00 ms Sending data 0.38 ms Creating sort index 0.04 ms Removing tmp table 0.07 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.00 ms Closing tables 0.02 ms Starting cleanup 0.00 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 24 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 23 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 22 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 21 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 20 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:404 19 PlgSystemFields->display() JROOT/plugins/system/fields/fields.php:324 18 PlgSystemFields->onContentAfterTitle() JROOT/libraries/joomla/event/event.php:70 17 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 16 JEventDispatcher->trigger() JROOT/components/com_content/views/category/tmpl/blog.php:22 15 include JROOT/components/com_content/views/category/tmpl/blog.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 13 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 12 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_content/views/category/view.html.php:250 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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 - Query Time: 0.41 ms After last query: 1.16 ms Query memory: 0.026 MB Memory before query: 3.830 MB Rows returned: 1
SELECT created_by, catid
FROM sjla_content
WHERE id = 9id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sjla_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.06 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.06 ms Statistics 0.06 ms Preparing 0.00 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:809 19 AttachmentsPlugin_Com_Content->attachmentsHiddenForParent() JROOT/plugins/content/attachments/attachments.php:319 18 plgContentAttachments->onContentBeforeDisplay() JROOT/libraries/joomla/event/event.php:70 17 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 16 JEventDispatcher->trigger() JROOT/components/com_content/views/category/tmpl/blog.php:25 15 include JROOT/components/com_content/views/category/tmpl/blog.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 13 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 12 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_content/views/category/view.html.php:250 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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 - Query Time: 0.61 ms After last query: 1.29 ms Query memory: 0.027 MB Memory before query: 3.847 MB Rows returned: 0
SELECT a.*, u.name as creator_name
FROM sjla_attachments AS a
LEFT JOIN sjla_users AS u
ON u.id = a.created_by
WHERE a.parent_id=9
AND a.state = 1
AND a.parent_type='com_content'
AND a.parent_entity='article'
AND a.access IN (1,5)
ORDER BY filenameid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL NULL NO INDEX KEY COULD BE USED NULL NULL 23 Using where; Using filesort 1 SIMPLE u eq_ref PRIMARY PRIMARY 4 jdb7971082.a.created_by 1 Status Duration Starting 0.09 ms Checking permissions 0.01 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms Init 0.07 ms Optimizing 0.03 ms Statistics 0.02 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.07 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 23 JDatabaseDriver->loadObjectList() JROOT/components/com_attachments/models/attachments.php:436 22 AttachmentsModelAttachments->getAttachmentsList() JROOT/components/com_attachments/models/attachments.php:514 21 AttachmentsModelAttachments->someVisible() JROOT/components/com_attachments/controllers/attachments.php:98 20 AttachmentsControllerAttachments->displayString() JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911 19 AttachmentsPlugin->insertAttachmentsList() JROOT/plugins/content/attachments/attachments.php:325 18 plgContentAttachments->onContentBeforeDisplay() JROOT/libraries/joomla/event/event.php:70 17 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 16 JEventDispatcher->trigger() JROOT/components/com_content/views/category/tmpl/blog.php:25 15 include JROOT/components/com_content/views/category/tmpl/blog.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 13 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 12 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_content/views/category/view.html.php:250 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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 - Query Time: 0.95 ms After last query: 15.89 ms Query memory: 0.031 MB Memory before query: 3.913 MB Rows returned: 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `sjla_categories` AS `s`
INNER JOIN `sjla_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 32
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 28 Using where; Using filesort Status Duration Starting 0.19 ms Checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms Init 0.08 ms Optimizing 0.05 ms Statistics 0.16 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.03 ms Creating sort index 0.12 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 31 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 30 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 29 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 28 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 27 ContentRouter->getCategorySegment() Same as call in the line below. 26 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 25 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 24 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 23 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 22 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 21 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 20 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 19 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 18 Joomla\CMS\Router\Route::_() JROOT/components/com_content/views/category/tmpl/blog_children.php:46 17 include JROOT/components/com_content/views/category/tmpl/blog_children.php JROOT/libraries/src/MVC/View/HtmlView.php:701 16 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_content/views/category/tmpl/blog.php:128 15 include JROOT/components/com_content/views/category/tmpl/blog.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 13 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 12 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_content/views/category/view.html.php:250 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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 - Query Time: 0.91 ms After last query: 0.68 ms Query memory: 0.031 MB Memory before query: 3.932 MB Rows returned: 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `sjla_categories` AS `s`
INNER JOIN `sjla_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 33
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 28 Using where; Using filesort Status Duration Starting 0.16 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms Init 0.06 ms Optimizing 0.03 ms Statistics 0.14 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.20 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 31 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 30 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 29 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 28 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 27 ContentRouter->getCategorySegment() Same as call in the line below. 26 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 25 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 24 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 23 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 22 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 21 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 20 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 19 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 18 Joomla\CMS\Router\Route::_() JROOT/components/com_content/views/category/tmpl/blog_children.php:46 17 include JROOT/components/com_content/views/category/tmpl/blog_children.php JROOT/libraries/src/MVC/View/HtmlView.php:701 16 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_content/views/category/tmpl/blog.php:128 15 include JROOT/components/com_content/views/category/tmpl/blog.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 13 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 12 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_content/views/category/view.html.php:250 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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 - Query Time: 0.76 ms After last query: 0.65 ms Query memory: 0.031 MB Memory before query: 3.952 MB Rows returned: 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `sjla_categories` AS `s`
INNER JOIN `sjla_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 34
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 28 Using where; Using filesort Status Duration Starting 0.15 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms Init 0.06 ms Optimizing 0.04 ms Statistics 0.14 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.11 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 31 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 30 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 29 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 28 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 27 ContentRouter->getCategorySegment() Same as call in the line below. 26 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 25 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 24 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 23 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 22 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 21 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 20 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 19 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 18 Joomla\CMS\Router\Route::_() JROOT/components/com_content/views/category/tmpl/blog_children.php:46 17 include JROOT/components/com_content/views/category/tmpl/blog_children.php JROOT/libraries/src/MVC/View/HtmlView.php:701 16 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_content/views/category/tmpl/blog.php:128 15 include JROOT/components/com_content/views/category/tmpl/blog.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 13 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 12 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_content/views/category/view.html.php:250 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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 - Query Time: 0.69 ms After last query: 0.62 ms Query memory: 0.031 MB Memory before query: 3.972 MB Rows returned: 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `sjla_categories` AS `s`
INNER JOIN `sjla_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 35
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 28 Using where; Using filesort Status Duration Starting 0.12 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms Init 0.06 ms Optimizing 0.04 ms Statistics 0.12 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.11 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 31 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 30 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 29 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 28 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 27 ContentRouter->getCategorySegment() Same as call in the line below. 26 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 25 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 24 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 23 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 22 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 21 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 20 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 19 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 18 Joomla\CMS\Router\Route::_() JROOT/components/com_content/views/category/tmpl/blog_children.php:46 17 include JROOT/components/com_content/views/category/tmpl/blog_children.php JROOT/libraries/src/MVC/View/HtmlView.php:701 16 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_content/views/category/tmpl/blog.php:128 15 include JROOT/components/com_content/views/category/tmpl/blog.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 13 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 12 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_content/views/category/view.html.php:250 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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 - Query Time: 0.87 ms After last query: 5.06 ms Query memory: 0.020 MB Memory before query: 4.008 MB Rows returned: 0
SELECT folder.*
FROM `sjla_eventgallery_folder` AS folder
LEFT JOIN `sjla_eventgallery_file` AS file
ON folder.folder = file.folder
and file.published=1
and file.ismainimage=0
WHERE file.file IS NULL
AND (folder.foldertypeid=1 OR folder.foldertypeid=2 OR folder.foldertypeid=4)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE folder ALL NULL NO INDEX KEY COULD BE USED NULL NULL 28 Using where 1 SIMPLE file ref file,index_folder file 377 jdb7971082.folder.folder 3 Using where; Not exists Status Duration Starting 0.10 ms Checking permissions 0.01 ms Opening tables 0.11 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.09 ms Optimizing 0.04 ms Statistics 0.04 ms Preparing 0.04 ms Executing 0.00 ms Sending data 0.18 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 8 JDatabaseDriver->loadObjectList() JROOT/plugins/system/picasaupdater/picasaupdater.php:80 7 plgSystemPicasaupdater->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 - Query Time: 1.62 ms After last query: 3.12 ms Query memory: 0.043 MB Memory before query: 4.014 MB Rows returned: 19
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down
FROM sjla_modules AS m
LEFT JOIN sjla_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
LEFT JOIN sjla_advancedmodules as am
ON am.moduleid = m.id
WHERE m.published = 1
AND e.enabled = 1
AND m.access IN (1,1,5)
AND m.client_id = 0
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref published,newsfeeds published 1 const 22 Using index condition; Using where; Using filesort 1 SIMPLE am eq_ref PRIMARY PRIMARY 4 jdb7971082.m.id 1 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 jdb7971082.m.module,const 1 Using index condition; Using where Status Duration Starting 0.13 ms Checking permissions 0.01 ms Opening tables 0.11 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.06 ms Optimizing 0.04 ms Statistics 0.10 ms Preparing 0.05 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.84 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.02 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:278 14 PlgSystemAdvancedModuleHelper->getModuleList() JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:60 13 PlgSystemAdvancedModuleHelper->onPrepareModuleList() JROOT/libraries/joomla/event/dispatcher.php:165 12 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 11 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Helper/ModuleHelper.php:366 10 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 9 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:601 8 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/protostar/index.php:91 7 require JROOT/templates/protostar/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 - Query Time: 0.96 ms After last query: 44.06 ms Query memory: 0.026 MB Memory before query: 4.547 MB Rows returned: 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `sjla_categories` AS `s`
INNER JOIN `sjla_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 2
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c range cat_idx,idx_access,idx_left_right idx_left_right 4 NULL 2 Using index condition; Using where Status Duration Starting 0.25 ms Checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.01 ms Init 0.08 ms Optimizing 0.05 ms Statistics 0.19 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.08 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 19 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 18 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 17 ContentRouter->getCategorySegment() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 15 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 14 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 13 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 12 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 11 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 9 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 8 Joomla\CMS\Router\Route::_() JROOT/plugins/system/sef/sef.php:110 7 PlgSystemSef->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
19 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
7 × SELECT `m`.`tag_id`,`t`.*
FROM `sjla_contentitem_tag_map` AS m
INNER JOIN `sjla_tags` AS t
ON `m`.`tag_id` = `t`.`id`7 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `sjla_categories` AS `s`
INNER JOIN `sjla_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)7 × SELECT created_by, catid
FROM sjla_content7 × SELECT a.*, u.name as creator_name
FROM sjla_attachments AS a
LEFT JOIN sjla_users AS u
ON u.id = a.created_by3 × 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 sjla_fields AS a
LEFT JOIN `sjla_languages` AS l
ON l.lang_code = a.language
LEFT JOIN sjla_users AS uc
ON uc.id=a.checked_out
LEFT JOIN sjla_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN sjla_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN sjla_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `sjla_fields_categories` AS fc
ON fc.field_id = a.id2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `sjla_assets`1 × SELECT `data`
FROM `sjla_session`1 × SELECT `session_id`
FROM `sjla_session`1 × SELECT id, rules
FROM `sjla_viewlevels1 × SELECT b.id
FROM sjla_usergroups AS a
LEFT JOIN sjla_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `name`
FROM `sjla_extensions`1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`)
FROM `sjla_content` AS `i`1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
FROM sjla_content AS a
LEFT JOIN sjla_categories AS c
ON c.id = a.catid
LEFT JOIN sjla_users AS ua
ON ua.id = a.created_by
LEFT JOIN sjla_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sjla_categories as parent
ON parent.id = c.parent_id1 × SELECT COUNT(*)
FROM sjla_content AS a
LEFT JOIN sjla_categories AS c
ON c.id = a.catid
LEFT JOIN sjla_users AS ua
ON ua.id = a.created_by
LEFT JOIN sjla_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sjla_categories as parent
ON parent.id = c.parent_id1 × 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 sjla_fields AS a
LEFT JOIN `sjla_languages` AS l
ON l.lang_code = a.language
LEFT JOIN sjla_users AS uc
ON uc.id=a.checked_out
LEFT JOIN sjla_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN sjla_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN sjla_fields_groups AS g
ON g.id = a.group_id1 × SELECT folder.*
FROM `sjla_eventgallery_folder` AS folder
LEFT JOIN `sjla_eventgallery_file` AS file
ON folder.folder = file.folder
and file.published=1
and file.ismainimage=01 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down
FROM sjla_modules AS m
LEFT JOIN sjla_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
LEFT JOIN sjla_advancedmodules as am
ON am.moduleid = m.id
OTHER Tables:
1 × INSERT INTO `sjla_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6674386b7435646a30377276736d63693330386d716535326a63', 1, 1743659431, 0, '', 01 × UPDATE `sjla_extensions`
SET `params` = '{\"mediaversion\":\"75e115a304aebe61d91691dd9821e777\"}'