logo
mpem is a independent and free platform for contemporary art's collectors, galleries, fairs,press offices, art consultant, museums, artists, curators

Le gallerie nelle città

 

Questa è la ripartizione delle gallerie d’arte segmentata per città e per dimensione

 

     

GALLERIA

 
 

TOTALE

PICCOLA

MEDIA

GRANDE

T O T A L E

340

146

101

90

Bologna

5,90

4,60

3,30

11,10

Firenze

3,20

4,30

 

5,30

Genova

2,40

2,70

1,60

2,70

Milano

34,70

32,80

38,80

32,40

Napoli

2,60

1,00

3,00

5,00

Palermo

2,10

2,40

3,50

 

Roma

17,60

17,60

19,00

16,70

Torino

5,30

5,40

4,40

5,00

Venezia

5,90

6,80

4,90

5,60

Verona

2,10

1,60

 

5,20

Altre

18,30

20,90

21,50

10,90

 

Ripartizione del fatturato delle gallerie d’arte segmentato per città e per dimensione

     

GALLERIA

 
 

TOTALE

PICCOLA

MEDIA

GRANDE

         
         

TOTALE

100,00

100,00

100,00

100,00

Bologna

4,50

1,30

1,90

5,00

Firenze

3,30

5,40

 

3,80

Genova

1,50

1,40

2,00

1,40

Milano

30,60

29,80

37,90

29,50

Napoli

4,70

0,80

3,50

5,10

Palermo

0,50

 

3,90

 

Roma

13,20

19,80

20,50

11,90

Torino

2,80

4,40

4,20

2,60

Venezia

18,50

13,80

4,90

20,80

Verona

6,50

1,60

 

7,70

Altre

13,70

21,50

21,20

12,30

Da notare come la città di Venezia che con solo il 5,9% di gallerie in termini d valore rappresenti il 18,50%.

 

Ripartizione del fatturato per città e dimensione gallerie.

 

   

GALLERIA

 
 

PICCOLA

MEDIA

GRANDE

       
       

TOTALE

2,70

13,20

84,10

Bologna

0,80

5,40

93,80

Firenze

4,40

 

95,60

Genova

2,50

17,80

79,70

Milano

2,60

16,30

81,00

Napoli

0,50

9,60

89,90

Palermo

 

100,00

 

Roma

4,00

20,50

75,50

Torino

4,20

19,80

76,00

Venezia

2,00

3,50

94,50

Verona

0,70

 

99,30

Altre

4,20

20,40

75,30

 

Notevole risulta la percentuale in termini di valore che hanno le grandi gallerie (84,10% sul totale) lasciando alle medie il 13,20% ed alle piccole il 2,70%.

12MBMemory Usage273msRequest Duration
Joomla! Version4.3.1
PHP Version8.0.30
Identityguest
Response200
Templatecassiopeia_event
Database
Server
mysql
Version
5.7.23-23
Collation
utf8_unicode_ci
Conn Collation
utf8mb4_general_ci
$_GET
array:1 [ "start" => "3" ]
$_POST
[]
$_SESSION
[]
$_COOKIE
[]
$_SERVER
array:64 [ "LSPHP_ENABLE_USER_INI" => "on" "PATH" => "/usr/local/bin:/usr/bin:/bin" "TEMP" => ...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1744070981 "last" => 1744070981...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
PHPDEBUGBAR_STACK_DATA
[]
  • afterLoad (553.34KB) (4.31ms)
  • afterInitialise (1.74MB) (46.56ms)
  • afterRoute (802.91KB) (18.87ms)
  • beforeRenderComponent com_content (127.02KB) (2.16ms)
  • Before Access::preloadComponents (all components) (131.95KB) (2.04ms)
  • After Access::preloadComponents (all components) (118.14KB) (6.28ms)
  • Before Access::preloadPermissions (com_content) (3.95KB) (33μs)
  • After Access::preloadPermissions (com_content) (6.28MB) (39.05ms)
  • Before Access::getAssetRules (id:549 name:com_content.article.337) (514.8KB) (713μs)
  • After Access::getAssetRules (id:549 name:com_content.article.337) (9.76KB) (215μs)
  • afterRenderComponent com_content (1.17MB) (94.44ms)
  • afterDispatch (3.78KB) (451μs)
  • beforeRenderRawModule mod_menu (Menu) (187.74KB) (8.17ms)
  • afterRenderRawModule mod_menu (Menu) (227.98KB) (4.65ms)
  • beforeRenderRawModule mod_custom (mpefm's pinterest (2)) (1.06KB) (41μs)
  • afterRenderRawModule mod_custom (mpefm's pinterest (2)) (14.98KB) (2.92ms)
  • beforeRenderRawModule mod_custom (APP Ios and APP Android) (736B) (38μs)
  • afterRenderRawModule mod_custom (APP Ios and APP Android) (2.16KB) (152μs)
  • beforeRenderRawModule mod_menu (Menu Principale) (3.02KB) (82μs)
  • afterRenderRawModule mod_menu (Menu Principale) (113.91KB) (1.99ms)
  • beforeRenderRawModule mod_jm_kick_cass (KickstartCassiopeia module) (28.84KB) (110μs)
  • afterRenderRawModule mod_jm_kick_cass (KickstartCassiopeia module) (25.73KB) (662μs)
  • beforeRenderRawModule mod_custom (translate) (29.25KB) (54μs)
  • afterRenderRawModule mod_custom (translate) (1KB) (372μs)
  • beforeRenderRawModule mod_banners (Free APP mpefm) (3.08KB) (56μs)
  • afterRenderRawModule mod_banners (Free APP mpefm) (49.57KB) (2.9ms)
  • beforeRenderRawModule mod_custom (Banner) (1.52KB) (36μs)
  • afterRenderRawModule mod_custom (Banner) (976B) (118μs)
  • beforeRenderRawModule mod_custom (shinystat) (688B) (67μs)
  • afterRenderRawModule mod_custom (shinystat) (1.09KB) (294μs)
  • beforeRenderModule mod_custom (shinystat) (1.55KB) (333μs)
  • afterRenderModule mod_custom (shinystat) (4.01KB) (280μs)
  • beforeRenderModule mod_menu (Menu) (2.05KB) (299μs)
  • afterRenderModule mod_menu (Menu) (9.01KB) (279μs)
  • beforeRenderModule mod_custom (mpefm's pinterest (2)) (2.13KB) (59μs)
  • afterRenderModule mod_custom (mpefm's pinterest (2)) (2.57KB) (142μs)
  • beforeRenderModule mod_custom (APP Ios and APP Android) (360B) (25μs)
  • afterRenderModule mod_custom (APP Ios and APP Android) (3.7KB) (92μs)
  • beforeRenderModule mod_banners (Free APP mpefm) (3.95KB) (67μs)
  • afterRenderModule mod_banners (Free APP mpefm) (2.02KB) (84μs)
  • beforeRenderModule mod_custom (Banner) (2.59KB) (23μs)
  • afterRenderModule mod_custom (Banner) (3.41KB) (103μs)
  • beforeRenderModule mod_custom (translate) (1KB) (58μs)
  • afterRenderModule mod_custom (translate) (2.26KB) (82μs)
  • beforeRenderModule mod_menu (Menu Principale) (2.19KB) (74μs)
  • afterRenderModule mod_menu (Menu Principale) (4.45KB) (83μs)
  • beforeRenderModule mod_jm_kick_cass (KickstartCassiopeia module) (27.79KB) (90μs)
  • afterRenderModule mod_jm_kick_cass (KickstartCassiopeia module) (9.96KB) (115μs)
  • beforeRenderRawModule mod_custom (logo) (27.86KB) (66μs)
  • afterRenderRawModule mod_custom (logo) (992B) (110μs)
  • beforeRenderModule mod_custom (logo) (704B) (5μs)
  • afterRenderModule mod_custom (logo) (2.24KB) (88μs)
  • afterRender (303.77KB) (9.75ms)
  • 1 x afterRenderComponent com_content (1.17MB) (34.64%)
    94.44ms
    1 x afterInitialise (1.74MB) (17.08%)
    46.56ms
    1 x After Access::preloadPermissions (com_content) (6.28MB) (14.32%)
    39.05ms
    1 x afterRoute (802.91KB) (6.92%)
    18.87ms
    1 x afterRender (303.77KB) (3.57%)
    9.75ms
    1 x beforeRenderRawModule mod_menu (Menu) (187.74KB) (3%)
    8.17ms
    1 x After Access::preloadComponents (all components) (118.14KB) (2.3%)
    6.28ms
    1 x afterRenderRawModule mod_menu (Menu) (227.98KB) (1.71%)
    4.65ms
    1 x afterLoad (553.34KB) (1.58%)
    4.31ms
    1 x afterRenderRawModule mod_custom (mpefm's pinterest (2)) (14.98KB) (1.07%)
    2.92ms
    1 x afterRenderRawModule mod_banners (Free APP mpefm) (49.57KB) (1.06%)
    2.90ms
    1 x beforeRenderComponent com_content (127.02KB) (0.79%)
    2.16ms
    1 x Before Access::preloadComponents (all components) (131.95KB) (0.75%)
    2.04ms
    1 x afterRenderRawModule mod_menu (Menu Principale) (113.91KB) (0.73%)
    1.99ms
    1 x Before Access::getAssetRules (id:549 name:com_content.article.337) (514.8KB) (0.26%)
    713μs
    1 x afterRenderRawModule mod_jm_kick_cass (KickstartCassiopeia module) (25.73KB) (0.24%)
    662μs
    1 x afterDispatch (3.78KB) (0.17%)
    451μs
    1 x afterRenderRawModule mod_custom (translate) (1KB) (0.14%)
    372μs
    1 x beforeRenderModule mod_custom (shinystat) (1.55KB) (0.12%)
    333μs
    1 x beforeRenderModule mod_menu (Menu) (2.05KB) (0.11%)
    299μs
    1 x afterRenderRawModule mod_custom (shinystat) (1.09KB) (0.11%)
    294μs
    1 x afterRenderModule mod_custom (shinystat) (4.01KB) (0.1%)
    280μs
    1 x afterRenderModule mod_menu (Menu) (9.01KB) (0.1%)
    279μs
    1 x After Access::getAssetRules (id:549 name:com_content.article.337) (9.76KB) (0.08%)
    215μs
    1 x afterRenderRawModule mod_custom (APP Ios and APP Android) (2.16KB) (0.06%)
    152μs
    1 x afterRenderModule mod_custom (mpefm's pinterest (2)) (2.57KB) (0.05%)
    142μs
    1 x afterRenderRawModule mod_custom (Banner) (976B) (0.04%)
    118μs
    1 x afterRenderModule mod_jm_kick_cass (KickstartCassiopeia module) (9.96KB) (0.04%)
    115μs
    1 x beforeRenderRawModule mod_jm_kick_cass (KickstartCassiopeia module) (28.84KB) (0.04%)
    110μs
    1 x afterRenderRawModule mod_custom (logo) (992B) (0.04%)
    110μs
    1 x afterRenderModule mod_custom (Banner) (3.41KB) (0.04%)
    103μs
    1 x afterRenderModule mod_custom (APP Ios and APP Android) (3.7KB) (0.03%)
    92μs
    1 x beforeRenderModule mod_jm_kick_cass (KickstartCassiopeia module) (27.79KB) (0.03%)
    90μs
    1 x afterRenderModule mod_custom (logo) (2.24KB) (0.03%)
    88μs
    1 x afterRenderModule mod_banners (Free APP mpefm) (2.02KB) (0.03%)
    84μs
    1 x afterRenderModule mod_menu (Menu Principale) (4.45KB) (0.03%)
    83μs
    1 x beforeRenderRawModule mod_menu (Menu Principale) (3.02KB) (0.03%)
    82μs
    1 x afterRenderModule mod_custom (translate) (2.26KB) (0.03%)
    82μs
    1 x beforeRenderModule mod_menu (Menu Principale) (2.19KB) (0.03%)
    74μs
    1 x beforeRenderRawModule mod_custom (shinystat) (688B) (0.02%)
    67μs
    1 x beforeRenderModule mod_banners (Free APP mpefm) (3.95KB) (0.02%)
    67μs
    1 x beforeRenderRawModule mod_custom (logo) (27.86KB) (0.02%)
    66μs
    1 x beforeRenderModule mod_custom (mpefm's pinterest (2)) (2.13KB) (0.02%)
    59μs
    1 x beforeRenderModule mod_custom (translate) (1KB) (0.02%)
    58μs
    1 x beforeRenderRawModule mod_banners (Free APP mpefm) (3.08KB) (0.02%)
    56μs
    1 x beforeRenderRawModule mod_custom (translate) (29.25KB) (0.02%)
    54μs
    1 x beforeRenderRawModule mod_custom (mpefm's pinterest (2)) (1.06KB) (0.02%)
    41μs
    1 x beforeRenderRawModule mod_custom (APP Ios and APP Android) (736B) (0.01%)
    38μs
    1 x beforeRenderRawModule mod_custom (Banner) (1.52KB) (0.01%)
    36μs
    1 x Before Access::preloadPermissions (com_content) (3.95KB) (0.01%)
    33μs
    1 x beforeRenderModule mod_custom (APP Ios and APP Android) (360B) (0.01%)
    25μs
    1 x beforeRenderModule mod_custom (Banner) (2.59KB) (0.01%)
    23μs
    1 x beforeRenderModule mod_custom (logo) (704B) (0%)
    5μs
31 statements were executed, 4 of which were duplicates, 27 unique88.7ms2.33MB
  • SELECT @@SESSION.sql_mode;450μs1.59KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `bafnt_session` WHERE `session_id` = ?671μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `bafnt_session` WHERE `session_id` = :session_id LIMIT 1242μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `bafnt_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)377μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `bafnt_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1684μs5.36KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `bafnt_viewlevels`231μs1.06KB/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `bafnt_usergroups` AS `a` LEFT JOIN `bafnt_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest284μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `bafnt_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1) ORDER BY `ordering`2.16ms16.27KBParams/libraries/src/Plugin/PluginHelper.php:283Copy
  • SELECT `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 `bafnt_menu` AS `m` LEFT JOIN `bafnt_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`5.96ms361.8KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `bafnt_template_styles` AS `s` LEFT JOIN `bafnt_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` = 1718μs2.58KB/administrator/components/com_templates/src/Model/StyleModel.php:771Copy
  • SELECT * FROM `bafnt_languages` WHERE `published` = 1 ORDER BY `ordering` ASC643μs2.44KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `bafnt_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.99ms10.5KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `bafnt_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 017.81ms1.26MBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `bafnt_content`1.09ms10.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `bafnt_content` SET `hits` = (`hits` + 1) WHERE `id` = '337'461μs48B/libraries/src/Table/Table.php:1325Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`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`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `bafnt_content` AS `a` INNER JOIN `bafnt_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `bafnt_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `bafnt_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `bafnt_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `bafnt_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`id` = :pk AND `c`.`published` > 0829μs177.27KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • 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 `bafnt_categories` AS `s` INNER JOIN `bafnt_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` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`671μs8.52KBParams/libraries/src/Categories/Categories.php:363Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `bafnt_contentitem_tag_map` AS `m` INNER JOIN `bafnt_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)42.48ms5.2KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • 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 `bafnt_categories` AS `s` INNER JOIN `bafnt_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` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`758μs6.02KBParams/libraries/src/Categories/Categories.php:363Copy
  • 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, 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 bafnt_fields AS a LEFT JOIN `bafnt_languages` AS l ON l.lang_code = a.language LEFT JOIN bafnt_users AS uc ON uc.id=a.checked_out LEFT JOIN bafnt_viewlevels AS ag ON ag.id = a.access LEFT JOIN bafnt_users AS ua ON ua.id = a.created_user_id LEFT JOIN bafnt_fields_groups AS g ON g.id = a.group_id LEFT JOIN `bafnt_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)) AND `a`.`access` IN (:preparedArray3)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray4)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC1.47ms5.83KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `field_id`,`value` FROM `bafnt_fields_values` WHERE `field_id` IN (:preparedArray1) AND `item_id` = :itemid315μs1.69KBParams/administrator/components/com_fields/src/Model/FieldModel.php:728Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`catid`,`a`.`language`, CASE WHEN CHAR_LENGTH(`a`.`alias`) != 0 THEN CONCAT_WS(':', `a`.`id`, `a`.`alias`) ELSE a.id END AS `slug`, CASE WHEN CHAR_LENGTH(`cc`.`alias`) != 0 THEN CONCAT_WS(':', `cc`.`id`, `cc`.`alias`) ELSE cc.id END AS `catslug` FROM `bafnt_content` AS `a` LEFT JOIN `bafnt_categories` AS `cc` ON `cc`.`id` = `a`.`catid` WHERE `a`.`catid` = :catid AND `a`.`state` = :state AND (`publish_up` IS NULL OR `publish_up` <= :nowDate1) AND (`publish_down` IS NULL OR `publish_down` >= :nowDate2) ORDER BY CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END DESC771μs2.84KBParams/plugins/content/pagenavigation/pagenavigation.php:186Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `bafnt_modules` AS `m` LEFT JOIN `bafnt_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `bafnt_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)) 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) ORDER BY `m`.`position`,`m`.`ordering`3.98ms446.09KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • 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, 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 bafnt_fields AS a LEFT JOIN `bafnt_languages` AS l ON l.lang_code = a.language LEFT JOIN bafnt_users AS uc ON uc.id=a.checked_out LEFT JOIN bafnt_viewlevels AS ag ON ag.id = a.access LEFT JOIN bafnt_users AS ua ON ua.id = a.created_user_id LEFT JOIN bafnt_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray2)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC1.27ms5.28KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT * FROM `bafnt_banners` WHERE (`reset` <= :date AND `reset` IS NOT NULL) AND (`checked_out` IS NULL OR `checked_out` = :userId)432μs7.89KBParams/administrator/components/com_banners/src/Helper/BannersHelper.php:69Copy
  • SELECT `a`.`id`,`a`.`type`,`a`.`name`,`a`.`clickurl`,`a`.`sticky`,`a`.`cid`,`a`.`description`,`a`.`params`,`a`.`custombannercode`,`a`.`track_impressions`,`cl`.`track_impressions` AS `client_track_impressions` FROM `bafnt_banners` AS `a` LEFT JOIN `bafnt_banner_clients` AS `cl` ON `cl`.`id` = `a`.`cid` WHERE ( ( (`a`.`state` = 1) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :nowDate1)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :nowDate2)) AND (`a`.`imptotal` = 0 OR `a`.`impmade` < `a`.`imptotal`) AND `a`.`catid` IN (:preparedArray1) ORDER BY `a`.`sticky` DESC, `a`.`ordering` LIMIT 5446μs2.89KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`type`,`a`.`execution_rules`,`a`.`state`,`a`.`last_exit_code`,`a`.`locked`,`a`.`last_execution`,`a`.`next_execution`,`a`.`times_executed`,`a`.`times_failed`,`a`.`priority`,`a`.`ordering`,`a`.`note`,`a`.`checked_out`,`a`.`checked_out_time`,`uc`.`name` AS `editor` FROM `bafnt_scheduler_tasks` AS `a` LEFT JOIN `bafnt_users` AS `uc` ON `uc`.`id` = `a`.`checked_out` WHERE `a`.`state` = :state AND `a`.`next_execution` <= :now ORDER BY `a`.`title` asc499μs4.45KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:404Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`type`,`a`.`execution_rules`,`a`.`state`,`a`.`last_exit_code`,`a`.`locked`,`a`.`last_execution`,`a`.`next_execution`,`a`.`times_executed`,`a`.`times_failed`,`a`.`priority`,`a`.`ordering`,`a`.`note`,`a`.`checked_out`,`a`.`checked_out_time`,`uc`.`name` AS `editor` FROM `bafnt_scheduler_tasks` AS `a` LEFT JOIN `bafnt_users` AS `uc` ON `uc`.`id` = `a`.`checked_out` WHERE `a`.`state` = :state AND `a`.`locked` IS NOT NULL ORDER BY `a`.`title` asc388μs4.43KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:404Copy
  • SELECT `alias` FROM `bafnt_content` WHERE `id` = :id184μs1.64KBParams/components/com_content/src/Service/Router.php:168Copy
  • 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 `bafnt_categories` AS `s` INNER JOIN `bafnt_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` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`291μs5.11KBParams/libraries/src/Categories/Categories.php:363Copy
  • SELECT `alias` FROM `bafnt_content` WHERE `id` = :id145μs1.64KBParams/components/com_content/src/Service/Router.php:168Copy