I meccanismi (o sistemi) operativi sono quegli strumenti gestionali che rendono operativa la struttura organizzativa.
Essi esprimono l'aspetto «dinamico» dell'organizzazione.
Lo scopo dei meccanismi operativi è quello di chiarire meglio ai membri dell'organizzazione ciò che è loro richiesto, qual è la funzione del loro lavoro ai fini del raggiungimento degli scopi che l'organizzazione si prefigge.
I principali meccanismi operativi sono:
E’ importante sottolineare quanto siano strettamente collegati tra loro i diversi meccanismi operativi.
Il sistema di pianificazione e controllo della gestione è un meccanismo che assicura l'operatività aziendale, mediante la chiara e sistematica definizione degli obiettivi assegnati alle varie posizioni organizzative e la puntuale verifica del loro effettivo raggiungimento, nei modi e nei tempi necessari per poter intervenire con provvedimenti correttivi in caso di manifeste disfunzioni gestionali.
Questo meccanismo operativo si caratterizza per due momenti distinti:
La pianificazione d'impresa è il processo mediante il quale si fissano gli obiettivi che si vogliono raggiungere in un determinato intervallo di tempo e con il quale si indicano i mezzi, gli strumenti e le azioni necessarie per conseguirli. Si distinguono:
La pianificazione strategica è elaborata dall'alta direzione ed ha, in genere, un orizzonte temporale di 5-6 anni.
Con essa si definiscono gli obiettivi di fondo della gestione (ad es.: obiettivi reddituali, sviluppo di nuovi prodotti, sviluppo di tecnologie ecc.) e si indicano le scelte (strategie) necessarie per il loro raggiungimento.
La pianificazione operativa si riferisce, invece, ad un periodo amministrativo annuale e si articola successivamente a livello trimestrale o mensile.
Con essa si individuano concretamente gli obiettivi da assegnare alle varie posizioni organizzative e le relative scelte (strategie) da mettere in atto nel corso di un esercizio.
La pianificazione operativa costituisce, in un certo senso, il punto di collegamento tra la pianificazione strategica ed il controllo di gestione.
Quest'ultimo, è il processo attraverso il quale i dirigenti influenzano gli altri membri di un'organizzazione al fine di rendere esecutive le strategie dell'impresa.
Schema azione controllo di gestione
Tale risultato viene raggiunto mediante:
- la formulazione di programmi annuali e infrannuali, tipicamente sotto forma di budget, che risultino compatibili con gli obiettivi della pianificazione strategica (controllo antecedente);
- la verifica, durante lo svolgimento della gestione, del raggiungimento degli obiettivi di budget e l'identificazione di eventuali provvedimenti correttivi se si registrano scostamenti tra quanto previsto e quanto realizzato (controllo concomitante);
- l'accertamento in maniera definitiva, a fine esercizio, del grado di raggiungimento degli obiettivi di budget (controllo susseguente).
Dal punto di vista tecnico-contabile, il processo di controllo si avvale della cosiddetta contabilità per la direzione che comprende, principalmente, i seguenti strumenti informativi:
Le scritture sezionali sono un insieme coordinato di più rilevazioni aventi uno stesso oggetto. Per esempio la contabilità degli acquisti di un'azienda ristorativa, la contabilità delle vendite, la contabilità del personale ecc. Tali scritture richiedono per lo più la tenuta di registri previsti per legge.
Il Codice Civile, la legislazione a tutela del lavoro e le normative fiscali stabiliscono l'obbligatorietà di alcune scritture contabili.
Si tenga inoltre presente che la tipologia delle scritture obbligatorie varia in relazione alla forma giuridica dell'impresa (impresa individuale o società) e al volume d'affari. Gli adempimenti obbligatori previsti dal Codice Civile sono stabiliti dagli articoli 2214-2220.
Sono libri obbligatori: il libro giornale, il libro inventari e i libri sociali (il libro dei soci, il libro delle deliberazioni dell'assemblea dei soci, il libro delle deliberazioni degli amministratori, il libro delle decisioni del collegio sindacale).
In più se l' azienda ha dei dipendenti essa è tenuta a tenere aggiornati i seguenti libri:
Sono esclusi da questi obblighi i piccoli imprenditori.
La contabilità generale è uno strumento fondamentale per raccogliere informazioni sulla consistenza del patrimonio dell'azienda cioè sull'insieme dei beni posseduti dall'impresa, sui suoi debiti, sull'andamento dei profitti dell'impresa stessa nel periodo preso in esame dalla contabilità e l'andamento delle singole voci che hanno contribuito a determinarlo.
Tutte le scritture contabili devono essere conservate ordinatamente per 10 anni dalla data dell'ultima registrazione.
Link alla pagina del servizio
Copyright © 2023-2025 by Studio Martorelli. All rights reserved
Studio Martorelli and DM Paideia are registered trademarks by Damiano Martorelli.
Joomla! Version | 5.3.0 |
PHP Version | 8.3.19 |
Identity | guest |
Response | 200 |
Template | t4_bs5_blank |
Database |
|
1 x afterRenderComponent com_content (1.29MB) (35.43%) | 402ms |
1 x afterRender (695.69KB) (21.58%) | 245ms |
1 x beforeRenderRawModule mod_custom (Copyright) (502.66KB) (10.39%) | 118ms |
1 x afterInitialise (1.82MB) (7.15%) | 81.17ms |
1 x afterRenderRawModule mod_finder (Cerca nel sito) (217.84KB) (4.31%) | 48.97ms |
1 x afterRenderRawModule mod_maximenuck (Corso di Elettrotecnica I) (390.5KB) (3.24%) | 36.82ms |
1 x afterRenderRawModule mod_articles_popular (Articoli più letti) (212.46KB) (2.52%) | 28.59ms |
1 x afterRenderRawModule mod_articles_latest (Articoli recenti) (90.69KB) (2.34%) | 26.53ms |
1 x Before Access::preloadComponents (all components) (49.3KB) (2.17%) | 24.66ms |
1 x afterRoute (541.64KB) (1.71%) | 19.46ms |
1 x afterRenderRawModule mod_menu (mnu-top-it) (554.64KB) (1.57%) | 17.83ms |
1 x afterDispatch (35.01KB) (1.08%) | 12.31ms |
1 x afterRenderRawModule mod_languages (Language switcher) (12.05KB) (0.91%) | 10.33ms |
1 x beforeRenderComponent com_content (42.84KB) (0.67%) | 7.65ms |
1 x beforeRenderRawModule mod_menu (mnu-top-it) (4.38KB) (0.67%) | 7.64ms |
1 x afterRenderRawModule mod_menu (Left common IT) (20.1KB) (0.63%) | 7.14ms |
1 x afterLoad (91.91KB) (0.58%) | 6.58ms |
1 x afterRenderRawModule mod_carouselck (Libri in evidenza) (58.93KB) (0.56%) | 6.37ms |
1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (13.83KB) (0.52%) | 5.88ms |
1 x afterRenderRawModule mod_custom (Copyright) (4.6KB) (0.41%) | 4.68ms |
1 x After Access::preloadComponents (all components) (123.65KB) (0.33%) | 3.69ms |
1 x afterRenderRawModule mod_shinystat_medeot (ShinyStat) (4.59KB) (0.32%) | 3.60ms |
1 x After Access::preloadPermissions (com_content) (65.65KB) (0.25%) | 2.89ms |
1 x afterRenderModule mod_articles_popular (Articoli più letti) (5.45KB) (0.05%) | 548μs |
1 x beforeRenderRawModule mod_articles_latest (Articoli recenti) (504B) (0.04%) | 510μs |
1 x afterRenderModule mod_custom (Copyright) (3.7KB) (0.03%) | 396μs |
1 x afterRenderRawModule mod_addtoany (Share on social media) (5.34KB) (0.03%) | 387μs |
1 x afterRenderModule mod_finder (Cerca nel sito) (3.73KB) (0.03%) | 384μs |
1 x afterRenderModule mod_maximenuck (Corso di Elettrotecnica I) (22.56KB) (0.03%) | 339μs |
1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (5.48KB) (0.03%) | 288μs |
1 x After Access::getAssetRules (id:304 name:com_content.category.29) (8.3KB) (0.02%) | 282μs |
1 x afterRenderModule mod_articles_latest (Articoli recenti) (5.45KB) (0.02%) | 247μs |
1 x afterRenderModule mod_custom (Centro Studi Walter) (3.8KB) (0.02%) | 214μs |
1 x beforeRenderRawModule mod_carouselck (Libri in evidenza) (25.8KB) (0.01%) | 154μs |
1 x beforeRenderRawModule mod_articles_popular (Articoli più letti) (1.07KB) (0.01%) | 151μs |
1 x afterRenderModule mod_custom (Google Ads 728x90) (3.05KB) (0.01%) | 148μs |
1 x afterRenderModule mod_menu (Left common IT) (3.36KB) (0.01%) | 147μs |
1 x afterRenderModule mod_menu (mnu-top-it) (31.05KB) (0.01%) | 145μs |
1 x afterRenderModule mod_carouselck (Libri in evidenza) (6.75KB) (0.01%) | 143μs |
1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (3.53KB) (0.01%) | 142μs |
1 x afterRenderModule mod_shinystat_medeot (ShinyStat) (3.06KB) (0.01%) | 134μs |
1 x afterRenderModule mod_addtoany (Share on social media) (2.88KB) (0.01%) | 130μs |
1 x beforeRenderRawModule mod_maximenuck (Corso di Elettrotecnica I) (24.14KB) (0.01%) | 123μs |
1 x beforeRenderRawModule mod_custom (Centro Studi Walter) (272B) (0.01%) | 121μs |
1 x afterRenderModule mod_languages (Language switcher) (4KB) (0.01%) | 120μs |
1 x afterRenderModule mod_custom (Nuovo servizio) (3.05KB) (0.01%) | 114μs |
1 x beforeRenderModule mod_finder (Cerca nel sito) (720B) (0.01%) | 111μs |
1 x afterRenderRawModule mod_custom (Google Ads 728x90) (928B) (0.01%) | 106μs |
1 x beforeRenderRawModule mod_languages (Language switcher) (23.41KB) (0.01%) | 99μs |
1 x afterRenderRawModule mod_custom (Nuovo servizio) (928B) (0.01%) | 88μs |
1 x beforeRenderRawModule mod_custom (Google Ads 728x90) (1.16KB) (0.01%) | 87μs |
1 x afterRenderRawModule mod_custom (Centro Studi Walter) (1.53KB) (0.01%) | 84μs |
1 x beforeRenderRawModule mod_custom (Nuovo servizio) (488B) (0.01%) | 79μs |
1 x beforeRenderRawModule mod_shinystat_medeot (ShinyStat) (376B) (0.01%) | 58μs |
1 x Before Access::preloadPermissions (com_content) (1.66KB) (0%) | 51μs |
1 x Before Access::getAssetRules (id:304 name:com_content.category.29) (6.65KB) (0%) | 48μs |
1 x beforeRenderRawModule mod_addtoany (Share on social media) (624B) (0%) | 44μs |
1 x beforeRenderRawModule mod_menu (Left common IT) (1.05KB) (0%) | 40μs |
1 x beforeRenderModule mod_maximenuck (Corso di Elettrotecnica I) (736B) (0%) | 34μs |
1 x beforeRenderRawModule mod_finder (Cerca nel sito) (688B) (0%) | 32μs |
1 x beforeRenderModule mod_articles_latest (Articoli recenti) (720B) (0%) | 22μs |
1 x beforeRenderModule mod_articles_popular (Articoli più letti) (720B) (0%) | 18μs |
1 x beforeRenderModule mod_menu (mnu-top-it) (720B) (0%) | 14μs |
1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%) | 13μs |
1 x beforeRenderModule mod_languages (Language switcher) (704B) (0%) | 13μs |
1 x beforeRenderModule mod_menu (Left common IT) (720B) (0%) | 13μs |
1 x beforeRenderModule mod_carouselck (Libri in evidenza) (720B) (0%) | 13μs |
1 x beforeRenderModule mod_custom (Copyright) (720B) (0%) | 12μs |
1 x beforeRenderModule mod_shinystat_medeot (ShinyStat) (720B) (0%) | 11μs |
1 x beforeRenderModule mod_custom (Google Ads 728x90) (720B) (0%) | 7μs |
1 x beforeRenderModule mod_custom (Nuovo servizio) (720B) (0%) | 7μs |
1 x beforeRenderModule mod_addtoany (Share on social media) (720B) (0%) | 7μs |
1 x beforeRenderModule mod_custom (Centro Studi Walter) (720B) (0%) | 6μs |
SELECT @@SESSION.sql_mode;
663μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259CopySELECT `data`
FROM `joses_session`
WHERE `session_id` = ?
611μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250CopySELECT `session_id`
FROM `joses_session`
WHERE `session_id` = :session_id LIMIT 1
521μs1.3KBParams/libraries/src/Session/MetadataManager.php:187CopyINSERT INTO `joses_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(:session_id, :guest, :time, :user_id, :username, :client_id)
1ms944BParams/libraries/src/Session/MetadataManager.php:260CopySELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `joses_extensions`
WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1
1.74ms1.73KB/libraries/src/Component/ComponentHelper.php:399CopySELECT `id`,`rules`
FROM `joses_viewlevels`
538μs656B/libraries/src/Access/Access.php:955CopySELECT `b`.`id`
FROM `joses_usergroups` AS `a`
LEFT JOIN `joses_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt`
WHERE `a`.`id` = :guest
886μs1.33KBParams/libraries/src/Access/Access.php:868CopySELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM `joses_extensions`
WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2)
ORDER BY `ordering`
4.18ms4.48KBParams/libraries/src/Plugin/PluginHelper.php:294CopySELECT *
FROM `joses_languages`
WHERE `published` = 1
ORDER BY `ordering` ASC
861μs2.23KB/libraries/src/Language/LanguageHelper.php:179CopySELECT `element`,`name`,`client_id`,`extension_id`
FROM `joses_extensions`
WHERE `type` = 'language' AND `state` = 0 AND `enabled` = 1
551μs784B/libraries/src/Language/LanguageHelper.php:252Copyselect email from joses_users where id=-1 LIMIT 1
391μs520B/plugins/system/bfstop/helpers/db.php:311CopySELECT id, ipaddress from joses_bfstop_allowlist WHERE (ipaddress='18.191.207.141' AND LOCATE('/', ipaddress) = 0)
383μs576B/plugins/system/bfstop/helpers/db.php:192CopySELECT id, ipaddress from joses_bfstop_allowlist WHERE ((LOCATE('/', ipaddress) != 0 AND LOCATE('.', ipaddress) != 0 AND (INET_ATON('18.191.207.141') & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1)) = (INET_ATON(SUBSTR(ipaddress, 1, LOCATE("/", ipaddress)-1)) & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1))))
429μs576B/plugins/system/bfstop/helpers/db.php:192CopySELECT id, ipaddress, crdate, duration FROM joses_bfstop_bannedip b WHERE (ipaddress='18.191.207.141' AND LOCATE('/', ipaddress) = 0) AND (b.duration=0 OR DATE_ADD(b.crdate, INTERVAL b.duration MINUTE) >= '2025-04-27 00:40:30') AND NOT EXISTS (SELECT 1 FROM joses_bfstop_unblock u WHERE b.id = u.block_id)
467μs688B/plugins/system/bfstop/helpers/db.php:192CopySELECT id, ipaddress, crdate, duration FROM joses_bfstop_bannedip b WHERE ((LOCATE('/', ipaddress) != 0 AND LOCATE('.', ipaddress) != 0 AND (INET_ATON('18.191.207.141') & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1)) = (INET_ATON(SUBSTR(ipaddress, 1, LOCATE("/", ipaddress)-1)) & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1)))) AND (b.duration=0 OR DATE_ADD(b.crdate, INTERVAL b.duration MINUTE) >= '2025-04-27 00:40:30') AND NOT EXISTS (SELECT 1 FROM joses_bfstop_unblock u WHERE b.id = u.block_id)
543μs688B/plugins/system/bfstop/helpers/db.php:192CopySELECT *
FROM joses_menu
WHERE alias ='it' AND published=1
699μs2.83KB/plugins/system/t4/src/t4/MVC/Router/T4.php:352CopySELECT *
FROM joses_menu
WHERE alias ='capitolo-2' AND published=1
621μs4.09KB/plugins/system/t4/src/t4/MVC/Router/T4.php:352CopySELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component`
FROM `joses_menu` AS `m`
LEFT JOIN `joses_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id`
WHERE
(
(`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND
(`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND
(`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2)
ORDER BY `m`.`lft`
3.62ms135.3KBParams/libraries/src/Menu/SiteMenu.php:166CopySELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent`
FROM `joses_template_styles` AS `s`
LEFT JOIN `joses_extensions` AS `e` ON `e`.`element` = `s`.`template` AND `e`.`type` = 'template' AND `e`.`client_id` = `s`.`client_id`
WHERE `s`.`client_id` = 0 AND `e`.`enabled` = 1
816μs864B/administrator/components/com_templates/src/Model/StyleModel.php:718CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `joses_assets`
WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41,:preparedArray42,:preparedArray43,:preparedArray44)
1.86ms7.81KBParams/libraries/src/Access/Access.php:357CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `joses_assets`
WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0
1.36ms3.98KBParams/libraries/src/Access/Access.php:301CopySELECT `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 `joses_content` AS `i`
WHERE `i`.`catid` = `c`.`id` AND `i`.`state` = 1 AND `i`.`language` IN (:preparedArray3,:preparedArray4)) AS `numitems`
FROM `joses_categories` AS `s`
INNER JOIN `joses_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray1,:preparedArray2)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`)
WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
1.67ms4.03KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL 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`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`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`,`uam`.`name` AS `modified_by_name`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`
FROM `joses_content` AS `a`
LEFT JOIN `joses_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `joses_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `joses_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `joses_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `joses_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` = :categoryId AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`language` IN (:preparedArray5,:preparedArray6)
ORDER BY c.lft, CASE WHEN a.publish_up IS NULL THEN a.created ELSE a.publish_up END DESC , a.created LIMIT 10
2.41ms22.98KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `m`.`tag_id`,`m`.`content_item_id`,`t`.*
FROM `joses_contentitem_tag_map` AS `m`
INNER JOIN `joses_tags` AS `t` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :contentType AND `t`.`published` = 1 AND `m`.`content_item_id` IN (:preparedArray1) AND `t`.`access` IN (:preparedArray2,:preparedArray3)
1.9ms4.19KBParams/libraries/src/Helper/TagsHelper.php:448CopySELECT COUNT(*)
FROM `joses_content` AS `a`
LEFT JOIN `joses_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `joses_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `joses_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `joses_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `joses_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` = :categoryId AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`language` IN (:preparedArray5,:preparedArray6)
1.45ms6.09KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:197CopySELECT `m`.`tag_id`,`t`.*
FROM `joses_contentitem_tag_map` AS `m`
INNER JOIN `joses_tags` AS `t` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1,:preparedArray2)
1.59ms3.97KBParams/libraries/src/Helper/TagsHelper.php:388CopySELECT `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 `joses_categories` AS `s`
INNER JOIN `joses_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`)
WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
1.72ms4KBParams/libraries/src/Categories/Categories.php:375CopySELECT 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, a.only_use_in_subform,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 joses_fields AS a
LEFT JOIN `joses_languages` AS l ON l.lang_code = a.language
LEFT JOIN joses_users AS uc ON uc.id=a.checked_out
LEFT JOIN joses_viewlevels AS ag ON ag.id = a.access
LEFT JOIN joses_users AS ua ON ua.id = a.created_user_id
LEFT JOIN joses_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `joses_fields_categories` AS fc ON fc.field_id = a.id
WHERE
(
(`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4)) AND `a`.`access` IN (:preparedArray5,:preparedArray6)) AND
(`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray7,:preparedArray8)) AND `a`.`state` = :state) AND
(`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform AND `a`.`language` IN (:preparedArray9,:preparedArray10)
ORDER BY a.ordering ASC
1.51ms4.88KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySHOW FULL TABLES WHERE table_type="BASE TABLE"
3.5ms2.06KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587CopySELECT `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 `joses_categories` AS `s`
INNER JOIN `joses_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`)
WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
1.87ms4KBParams/libraries/src/Categories/Categories.php:375CopySELECT 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, a.only_use_in_subform,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 joses_fields AS a
LEFT JOIN `joses_languages` AS l ON l.lang_code = a.language
LEFT JOIN joses_users AS uc ON uc.id=a.checked_out
LEFT JOIN joses_viewlevels AS ag ON ag.id = a.access
LEFT JOIN joses_users AS ua ON ua.id = a.created_user_id
LEFT JOIN joses_fields_groups AS g ON g.id = a.group_id
WHERE
(
(`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND
(`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,:preparedArray4)) AND `a`.`state` = :state) AND
(`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform AND `a`.`language` IN (:preparedArray5,:preparedArray6)
ORDER BY a.ordering ASC
1.29ms4.75KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `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 `joses_categories` AS `s`
INNER JOIN `joses_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`)
WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
1.95ms4KBParams/libraries/src/Categories/Categories.php:375CopySELECT 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, a.only_use_in_subform,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 joses_fields AS a
LEFT JOIN `joses_languages` AS l ON l.lang_code = a.language
LEFT JOIN joses_users AS uc ON uc.id=a.checked_out
LEFT JOIN joses_viewlevels AS ag ON ag.id = a.access
LEFT JOIN joses_users AS ua ON ua.id = a.created_user_id
LEFT JOIN joses_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `joses_fields_categories` AS fc ON fc.field_id = a.id
WHERE
(
(`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4)) AND `a`.`access` IN (:preparedArray5,:preparedArray6)) AND
(`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray7,:preparedArray8)) AND `a`.`state` = :state) AND
(`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform AND `a`.`language` IN (:preparedArray9,:preparedArray10)
ORDER BY a.ordering ASC
1.54ms7.38KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySHOW FULL TABLES WHERE table_type="BASE TABLE"
3.06ms2.06KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587CopySELECT u.id, u.name, u.username, u.params
FROM joses_users AS u
LEFT JOIN joses_user_usergroup_map AS g ON g.user_id = u.id
WHERE u.id = '243'
GROUP BY u.id
602μs704B/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:279CopySELECT enabled
FROM joses_extensions
WHERE `type` = 'plugin' AND `element` = 'profile'
517μs536B/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:467CopySHOW FULL COLUMNS FROM `joses_users`
2.35ms1.58KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539CopySELECT *
FROM `joses_users`
WHERE `id` = :userid
633μs3.16KBParams/libraries/src/Table/User.php:106CopySELECT `g`.`id`,`g`.`title`
FROM `joses_usergroups` AS `g`
INNER JOIN `joses_user_usergroup_map` AS `m` ON `m`.`group_id` = `g`.`id`
WHERE `m`.`user_id` = :muserid
612μs1.4KBParams/libraries/src/Table/User.php:134CopySELECT 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, a.only_use_in_subform,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 joses_fields AS a
LEFT JOIN `joses_languages` AS l ON l.lang_code = a.language
LEFT JOIN joses_users AS uc ON uc.id=a.checked_out
LEFT JOIN joses_viewlevels AS ag ON ag.id = a.access
LEFT JOIN joses_users AS ua ON ua.id = a.created_user_id
LEFT JOIN joses_fields_groups AS g ON g.id = a.group_id
WHERE
(
(`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND
(`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,:preparedArray4)) AND `a`.`state` = :state) AND
(`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform AND `a`.`language` IN (:preparedArray5,:preparedArray6)
ORDER BY a.ordering ASC
1.36ms4.75KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `name`
FROM `joses_users`
WHERE id = '243'
404μs536B/plugins/system/t4/src/t4/MVC/Router/Content/Router.php:66CopySELECT username
FROM joses_users
WHERE id=243
372μs536B/plugins/system/t4/src/t4/MVC/Router/T4.php:288CopySELECT `language`,`id`
FROM `joses_menu`
WHERE `home` = '1' AND `published` = 1 AND `client_id` = 0
1.55ms624B/libraries/src/Language/Multilanguage.php:123CopySELECT `alias`,`catid`
FROM joses_content
WHERE `id` = :key
488μs1.37KBParams/libraries/src/Component/Router/Rules/PreprocessRules.php:123CopySELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`
FROM `joses_categories` AS `c`
INNER JOIN `joses_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context
INNER JOIN `joses_associations` AS `a2` ON `a`.`key` = `a2`.`key`
INNER JOIN `joses_categories` AS `c2` ON `a2`.`id` = `c2`.`id` AND c2.extension = :extension1
WHERE `c`.`id` = :id AND `c`.`extension` = :extension3
701μs1.42KBParams/libraries/src/Language/Associations.php:145CopySELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid`
FROM `joses_modules` AS `m`
LEFT JOIN `joses_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id`
LEFT JOIN `joses_extensions` AS `e` ON `e`.`element` = `m`.`module` AND `e`.`client_id` = `m`.`client_id`
WHERE
(
(
(`m`.`published` = 1 AND `e`.`enabled` = 1 AND `m`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1,:preparedArray2)) AND
(`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND
(`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND
(`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0) AND `m`.`language` IN (:preparedArray3,:preparedArray4)
ORDER BY `m`.`position`,`m`.`ordering`
2.35ms18.09KBParams/libraries/src/Cache/Controller/CallbackController.php:51CopySELECT `name`,`element`
FROM `joses_extensions`
WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1
817μs656B/administrator/components/com_finder/src/Helper/LanguageHelper.php:135CopySELECT `title`
FROM `joses_finder_taxonomy`
WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)
671μs648B/administrator/components/com_finder/src/Indexer/Taxonomy.php:325CopySELECT `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`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL 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`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`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`,`uam`.`name` AS `modified_by_name`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`
FROM `joses_content` AS `a`
LEFT JOIN `joses_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `joses_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `joses_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `joses_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `joses_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`language` IN (:preparedArray5,:preparedArray6)
ORDER BY a.publish_up DESC LIMIT 9
7.85ms87.09KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `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 `joses_categories` AS `s`
INNER JOIN `joses_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`)
WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
1.63ms3.98KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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 `joses_categories` AS `s`
INNER JOIN `joses_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`)
WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
1.53ms4KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL 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`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`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`,`uam`.`name` AS `modified_by_name`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`
FROM `joses_content` AS `a`
LEFT JOIN `joses_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `joses_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `joses_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `joses_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `joses_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`language` IN (:preparedArray5,:preparedArray6)
ORDER BY a.hits DESC LIMIT 9
6.63ms103.09KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `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 `joses_categories` AS `s`
INNER JOIN `joses_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`)
WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
1.24ms3.97KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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 `joses_categories` AS `s`
INNER JOIN `joses_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`)
WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
1.22ms3.98KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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 `joses_categories` AS `s`
INNER JOIN `joses_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`)
WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
1.43ms4KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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 `joses_categories` AS `s`
INNER JOIN `joses_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`)
WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
1.23ms4KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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 `joses_categories` AS `s`
INNER JOIN `joses_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`)
WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
1.4ms3.98KBParams/libraries/src/Categories/Categories.php:375CopySELECT `c2`.`language`,`c2`.`id`
FROM `joses_menu` AS `c`
INNER JOIN `joses_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context
INNER JOIN `joses_associations` AS `a2` ON `a`.`key` = `a2`.`key`
INNER JOIN `joses_menu` AS `c2` ON `a2`.`id` = `c2`.`id`
WHERE `c`.`id` = :id
551μs1.38KBParams/libraries/src/Language/Associations.php:145CopySELECT *
FROM joses_modules
WHERE published=1
ORDER BY id
1.55ms19.39KB/administrator/components/com_maximenuck/helpers/ckfof.php:168CopySELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count
FROM `joses_scheduler_tasks` AS `a`
WHERE `a`.`state` = 1
592μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517CopySELECT `session_id`
FROM `joses_session`
WHERE `session_id` = ?
414μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277CopyUPDATE `joses_session`
SET `data` = ?
, `time` = ?
WHERE `session_id` = ?
777μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy