TYSC Open day scienze 2019/2020
Referente: Maria Vittoria Cicinelli Questo indirizzo email è protetto dagli spambots. È necessario abilitare JavaScript per vederlo. Questo indirizzo email è protetto dagli spambots. È necessario abil...
Clicca per selezionare
Referente: Maria Vittoria Cicinelli Questo indirizzo email è protetto dagli spambots. È necessario abilitare JavaScript per vederlo. Questo indirizzo email è protetto dagli spambots. È necessario abil...
Referente: Maria Vittoria Cicinelli Questo indirizzo email è protetto dagli spambots. È necessario abilitare JavaScript per vederlo. Questo indirizzo email è protetto dagli spambots. È necessario abil...
Referente: Maria Vittoria Cicinelli Questo indirizzo email è protetto dagli spambots. È necessario abilitare JavaScript per vederlo. Questo indirizzo email è protetto dagli spambots. È necessario abil...
Referente: Maria Vittoria Cicinelli Questo indirizzo email è protetto dagli spambots. È necessario abilitare JavaScript per vederlo. Questo indirizzo email è protetto dagli spambots. È necessario abil...
Referente: Maria Vittoria Cicinelli Questo indirizzo email è protetto dagli spambots. È necessario abilitare JavaScript per vederlo. Questo indirizzo email è protetto dagli spambots. È necessario abil...
Referente: Maria Vittoria Cicinelli Questo indirizzo email è protetto dagli spambots. È necessario abilitare JavaScript per vederlo. Coordinamento progetti nelle classi : Docenti di Matematica e Scien...
Referente: Maria Vittoria Cicinelli Questo indirizzo email è protetto dagli spambots. È necessario abilitare JavaScript per vederlo. Il Laboratorio ha ripreso il suo percorso dopo qualche anno di paus...
Referente: Maria Vittoria Cicinelli Questo indirizzo email è protetto dagli spambots. È necessario abilitare JavaScript per vederlo. Il Laboratorio 2014/2015 al suo quinto anno si è principalemnte art...
Referente: Maria Vittoria Cicinelli Questo indirizzo email è protetto dagli spambots. È necessario abilitare JavaScript per vederlo. Il Laboratorio Dire Fare Raccontare con il Cinema è al suo quarto a...
Referente: Maria Vittoria Cicinelli Questo indirizzo email è protetto dagli spambots. È necessario abilitare JavaScript per vederlo. Terzo anno del laboratorio che ha mantenuto la stessa struttura dei...
Pagina 31 di 36
Joomla! Version | 4.4.13 |
PHP Version | 8.3.22 |
Identity | guest |
Response | 200 |
Template | joomla-italia-theme_child |
Database |
|
1 x afterRenderComponent com_content (5.2MB) (79.96%) | 726.02ms |
1 x afterInitialise (1.48MB) (5.42%) | 49.18ms |
1 x afterRoute (817.35KB) (2.83%) | 25.69ms |
1 x afterRender (405.43KB) (2.36%) | 21.43ms |
1 x After Access::preloadPermissions (com_content) (1.54MB) (1.38%) | 12.51ms |
1 x afterRenderRawModule mod_menu (03 - Area Legale) (641.27KB) (1.31%) | 11.86ms |
1 x afterLoad (525.05KB) (0.92%) | 8.39ms |
1 x afterRenderRawModule mod_menu (00 - Menu Orrizontale) (455.22KB) (0.82%) | 7.40ms |
1 x beforeRenderRawModule mod_menu (Moduli cerca) (123.39KB) (0.74%) | 6.68ms |
1 x afterDispatch (150.58KB) (0.7%) | 6.35ms |
1 x beforeRenderComponent com_content (83.75KB) (0.46%) | 4.19ms |
1 x beforeRenderRawModule mod_menu (03 - Area Legale) (76.99KB) (0.39%) | 3.57ms |
1 x afterRenderRawModule mod_menu (La scuola) (29.02KB) (0.23%) | 2.04ms |
1 x Before Access::preloadComponents (all components) (48.48KB) (0.22%) | 1.99ms |
1 x After Access::preloadComponents (all components) (126.32KB) (0.22%) | 1.96ms |
1 x afterRenderRawModule mod_menu (Servizi) (23.71KB) (0.16%) | 1.43ms |
1 x afterRenderRawModule mod_menu (Link esterni) (16.38KB) (0.15%) | 1.33ms |
1 x afterRenderRawModule mod_menu (02 - Menu Risorse) (30.89KB) (0.14%) | 1.27ms |
1 x afterRenderRawModule mod_breadcrumbs (01 - Percorso) (10KB) (0.14%) | 1.25ms |
1 x afterRenderRawModule mod_menu (Didattica) (19.3KB) (0.13%) | 1.21ms |
1 x afterRenderRawModule mod_menu (Novità) (17.98KB) (0.13%) | 1.17ms |
1 x afterRenderRawModule mod_menu (Moduli cerca) (10.67KB) (0.08%) | 745μs |
1 x afterRenderRawModule mod_custom (Chiamaci ora) (4.82KB) (0.06%) | 531μs |
1 x afterRenderRawModule mod_ebstickycookienotice (EB Sticky Cookie Notice) (14.34KB) (0.06%) | 504μs |
1 x afterRenderModule mod_ebstickycookienotice (EB Sticky Cookie Notice) (6.99KB) (0.04%) | 406μs |
1 x afterRenderModule mod_menu (03 - Area Legale) (3.29KB) (0.04%) | 397μs |
1 x beforeRenderRawModule mod_breadcrumbs (01 - Percorso) (960B) (0.04%) | 332μs |
1 x afterRenderModule mod_menu (00 - Menu Orrizontale) (9.96KB) (0.04%) | 329μs |
1 x afterRenderModule mod_menu (02 - Menu Risorse) (2.96KB) (0.04%) | 318μs |
1 x afterRenderModule mod_menu (Moduli cerca) (2.84KB) (0.03%) | 317μs |
1 x afterRenderModule mod_finder (Motore ricerca) (7.98KB) (0.03%) | 317μs |
1 x afterRenderModule mod_menu (Novità) (3.16KB) (0.03%) | 304μs |
1 x afterRenderModule mod_menu (La scuola) (2.7KB) (0.03%) | 277μs |
1 x afterRenderModule mod_menu (Servizi) (2.7KB) (0.03%) | 276μs |
1 x afterRenderModule mod_menu (Didattica) (2.57KB) (0.03%) | 272μs |
1 x afterRenderModule mod_breadcrumbs (01 - Percorso) (2.71KB) (0.03%) | 267μs |
1 x afterRenderModule mod_custom (Chiamaci ora) (2.21KB) (0.03%) | 263μs |
1 x afterRenderModule mod_menu (Link esterni) (3.23KB) (0.03%) | 263μs |
1 x beforeRenderRawModule mod_menu (02 - Menu Risorse) (2.66KB) (0.03%) | 252μs |
1 x beforeRenderRawModule mod_custom (Stemma PAT) (1.35KB) (0.03%) | 252μs |
1 x afterRenderModule mod_custom (Stemma PAT) (2.27KB) (0.03%) | 238μs |
1 x afterRenderModule mod_custom (Stemma_REP) (2.27KB) (0.03%) | 232μs |
1 x After Access::getAssetRules (id:10766 name:com_content.category.498) (7.34KB) (0.02%) | 171μs |
1 x beforeRenderRawModule mod_menu (Servizi) (5.19KB) (0.02%) | 164μs |
1 x beforeRenderRawModule mod_menu (00 - Menu Orrizontale) (16B) (0.02%) | 161μs |
1 x beforeRenderRawModule mod_menu (Novità) (2.38KB) (0.02%) | 160μs |
1 x beforeRenderRawModule mod_menu (La scuola) (112B) (0.02%) | 153μs |
1 x beforeRenderRawModule mod_menu (Link esterni) (16B) (0.02%) | 153μs |
1 x Before Access::getAssetRules (id:10766 name:com_content.category.498) (66.65KB) (0.02%) | 149μs |
1 x afterRenderRawModule mod_finder (Motore ricerca) (45.21KB) (0.01%) | 114μs |
1 x afterRenderRawModule mod_custom (Stemma PAT) (1KB) (0.01%) | 92μs |
1 x afterRenderRawModule mod_custom (Stemma_REP) (992B) (0.01%) | 82μs |
1 x Before Access::preloadPermissions (com_content) (1.91KB) (0.01%) | 50μs |
1 x beforeRenderRawModule mod_ebstickycookienotice (EB Sticky Cookie Notice) (2.27KB) (0.01%) | 46μs |
1 x beforeRenderRawModule mod_custom (Chiamaci ora) (2.12KB) (0%) | 44μs |
1 x beforeRenderRawModule mod_menu (Didattica) (392B) (0%) | 42μs |
1 x beforeRenderRawModule mod_custom (Stemma_REP) (392B) (0%) | 36μs |
1 x beforeRenderRawModule mod_finder (Motore ricerca) (232B) (0%) | 35μs |
1 x beforeRenderModule mod_menu (03 - Area Legale) (720B) (0%) | 10μs |
1 x beforeRenderModule mod_custom (Chiamaci ora) (720B) (0%) | 9μs |
1 x beforeRenderModule mod_menu (Novità) (704B) (0%) | 9μs |
1 x beforeRenderModule mod_menu (Servizi) (704B) (0%) | 9μs |
1 x beforeRenderModule mod_menu (La scuola) (704B) (0%) | 9μs |
1 x beforeRenderModule mod_menu (02 - Menu Risorse) (720B) (0%) | 9μs |
1 x beforeRenderModule mod_menu (Moduli cerca) (720B) (0%) | 9μs |
1 x beforeRenderModule mod_menu (Didattica) (704B) (0%) | 9μs |
1 x beforeRenderModule mod_breadcrumbs (01 - Percorso) (704B) (0%) | 9μs |
1 x beforeRenderModule mod_menu (00 - Menu Orrizontale) (720B) (0%) | 9μs |
1 x beforeRenderModule mod_ebstickycookienotice (EB Sticky Cookie Notice) (736B) (0%) | 8μs |
1 x beforeRenderModule mod_menu (Link esterni) (720B) (0%) | 8μs |
1 x beforeRenderModule mod_custom (Stemma PAT) (720B) (0%) | 7μs |
1 x beforeRenderModule mod_finder (Motore ricerca) (720B) (0%) | 6μs |
1 x beforeRenderModule mod_custom (Stemma_REP) (720B) (0%) | 6μs |
SELECT @@SESSION.sql_mode;
124μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334CopySELECT `data`
FROM `j25_session`
WHERE `session_id` = ?
448μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261CopySELECT `session_id`
FROM `j25_session`
WHERE `session_id` = :session_id LIMIT 1
330μs1.3KBParams/libraries/src/Session/MetadataManager.php:187CopyINSERT INTO `j25_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(:session_id, :guest, :time, :user_id, :username, :client_id)
1.27ms944BParams/libraries/src/Session/MetadataManager.php:260CopySELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `j25_extensions`
WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1
897μs17.86KB/libraries/src/Component/ComponentHelper.php:399CopySELECT `id`,`rules`
FROM `j25_viewlevels`
199μs736B/libraries/src/Access/Access.php:955CopySELECT `b`.`id`
FROM `j25_usergroups` AS `a`
LEFT JOIN `j25_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt`
WHERE `a`.`id` = :guest
512μs1.33KBParams/libraries/src/Access/Access.php:868CopySELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM `j25_extensions`
WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2)
ORDER BY `ordering`
673μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294CopySELECT `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 `j25_menu` AS `m`
LEFT JOIN `j25_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.17ms203.92KBParams/libraries/src/Menu/SiteMenu.php:166CopySELECT *
FROM `j25_languages`
WHERE `published` = 1
ORDER BY `ordering` ASC
301μs1.61KB/libraries/src/Language/LanguageHelper.php:142CopySELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent`
FROM `j25_template_styles` AS `s`
LEFT JOIN `j25_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
267μs848B/administrator/components/com_templates/src/Model/StyleModel.php:773CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `j25_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,:preparedArray45,:preparedArray46,:preparedArray47,:preparedArray48,:preparedArray49,:preparedArray50)
974μs7.94KBParams/libraries/src/Access/Access.php:357CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `j25_assets`
WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0
3.73ms229.48KBParams/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 `j25_content` AS `i`
WHERE `i`.`catid` = `c`.`id` AND `i`.`state` = 1) AS `numitems`
FROM `j25_categories` AS `s`
INNER JOIN `j25_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`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
3.4ms36.17KBParams/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`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count`
FROM `j25_content` AS `a`
LEFT JOIN `j25_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `j25_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `j25_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `j25_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `j25_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
LEFT JOIN `j25_content_rating` AS `v` ON `a`.`id` = `v`.`content_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 OR `a`.`catid` IN (
SELECT `sub`.`id`
FROM `j25_categories` AS `sub`
INNER JOIN `j25_categories` AS `this` ON `sub`.`lft` > `this`.`lft` AND `sub`.`rgt` < `this`.`rgt`
WHERE `this`.`id` = :subCategoryId)) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown)
ORDER BY c.lft, a.ordering, a.created LIMIT 330, 11
11.54ms143.19KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `m`.`tag_id`,`m`.`content_item_id`,`t`.*
FROM `j25_contentitem_tag_map` AS `m`
INNER JOIN `j25_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,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11) AND `t`.`access` IN (:preparedArray12,:preparedArray13)
331μs4.91KBParams/libraries/src/Helper/TagsHelper.php:448CopySELECT COUNT(*)
FROM `j25_content` AS `a`
LEFT JOIN `j25_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `j25_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `j25_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `j25_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `j25_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
LEFT JOIN `j25_content_rating` AS `v` ON `a`.`id` = `v`.`content_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 OR `a`.`catid` IN (
SELECT `sub`.`id`
FROM `j25_categories` AS `sub`
INNER JOIN `j25_categories` AS `this` ON `sub`.`lft` > `this`.`lft` AND `sub`.`rgt` < `this`.`rgt`
WHERE `this`.`id` = :subCategoryId)) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown)
4.1ms6.84KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:199CopySELECT `m`.`tag_id`,`t`.*
FROM `j25_contentitem_tag_map` AS `m`
INNER JOIN `j25_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)
293μs3.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 `j25_categories` AS `s`
INNER JOIN `j25_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,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
438μs3.94KBParams/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 j25_fields AS a
LEFT JOIN `j25_languages` AS l ON l.lang_code = a.language
LEFT JOIN j25_users AS uc ON uc.id=a.checked_out
LEFT JOIN j25_viewlevels AS ag ON ag.id = a.access
LEFT JOIN j25_users AS ua ON ua.id = a.created_user_id
LEFT JOIN j25_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `j25_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
ORDER BY a.ordering ASC
921μs4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `folderid`, `foldertime`, `entitytag` FROM `j25_sigplus_folder` WHERE `folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/8_6_23_premiazione_finale_TYSC'
114μs656B/plugins/content/sigplus/core/core.php:3119CopySELECT viewid
FROM j25_sigplus_view
WHERE folderid = 44 AND hash = 0x586b82331659c032e48a380cd98e4a91
83μs536B/plugins/content/sigplus/core/core.php:1229CopySELECT
i.`fileurl`,
i.`imageid`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
WHERE h.`ancestorid` = 44 AND NOT EXISTS (SELECT * FROM `j25_sigplus_imageview` AS v WHERE i.`imageid` = v.`imageid` AND v.`viewid` = 44) AND depthnum <= 0
246μs576B/plugins/content/sigplus/core/core.php:1845CopySELECT
`langid`
FROM `j25_sigplus_language`
WHERE
`lang` = 'it'
123μs536B/plugins/content/sigplus/core/core.php:329CopySELECT
`countryid`
FROM `j25_sigplus_country`
WHERE
`country` = 'IT'
102μs536B/plugins/content/sigplus/core/core.php:344CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/8_6_23_premiazione_finale_TYSC' AND
`viewid` = 44
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
905μs2.45KB/plugins/content/sigplus/core/core.php:3368CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/8_6_23_premiazione_finale_TYSC' AND
`viewid` = 44
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
768μs0B/plugins/content/sigplus/core/core.php:3375CopySELECT `folderid`, `foldertime`, `entitytag` FROM `j25_sigplus_folder` WHERE `folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/muse_tysc_premiazione'
155μs656B/plugins/content/sigplus/core/core.php:3119CopySELECT viewid
FROM j25_sigplus_view
WHERE folderid = 46 AND hash = 0x4086af89bd34034a6b527572a053453d
80μs536B/plugins/content/sigplus/core/core.php:1229CopySELECT
i.`fileurl`,
i.`imageid`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
WHERE h.`ancestorid` = 46 AND NOT EXISTS (SELECT * FROM `j25_sigplus_imageview` AS v WHERE i.`imageid` = v.`imageid` AND v.`viewid` = 45) AND depthnum <= 0
248μs576B/plugins/content/sigplus/core/core.php:1845CopySELECT
`langid`
FROM `j25_sigplus_language`
WHERE
`lang` = 'it'
117μs536B/plugins/content/sigplus/core/core.php:329CopySELECT
`countryid`
FROM `j25_sigplus_country`
WHERE
`country` = 'IT'
119μs536B/plugins/content/sigplus/core/core.php:344CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/muse_tysc_premiazione' AND
`viewid` = 45
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
1.51ms5.17KB/plugins/content/sigplus/core/core.php:3368CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/muse_tysc_premiazione' AND
`viewid` = 45
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
1.5ms0B/plugins/content/sigplus/core/core.php:3375CopySELECT `folderid`, `foldertime`, `entitytag` FROM `j25_sigplus_folder` WHERE `folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/tysc_muse_finale_7_6_19'
186μs656B/plugins/content/sigplus/core/core.php:3119CopySELECT viewid
FROM j25_sigplus_view
WHERE folderid = 48 AND hash = 0x127e09f5d7ed2c5e4616ecd0441fbbb9
91μs536B/plugins/content/sigplus/core/core.php:1229CopySELECT
i.`fileurl`,
i.`imageid`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
WHERE h.`ancestorid` = 48 AND NOT EXISTS (SELECT * FROM `j25_sigplus_imageview` AS v WHERE i.`imageid` = v.`imageid` AND v.`viewid` = 48) AND depthnum <= 0
270μs576B/plugins/content/sigplus/core/core.php:1845CopySELECT
`langid`
FROM `j25_sigplus_language`
WHERE
`lang` = 'it'
167μs536B/plugins/content/sigplus/core/core.php:329CopySELECT
`countryid`
FROM `j25_sigplus_country`
WHERE
`country` = 'IT'
152μs536B/plugins/content/sigplus/core/core.php:344CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/tysc_muse_finale_7_6_19' AND
`viewid` = 48
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
1.53ms2.67KB/plugins/content/sigplus/core/core.php:3368CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/tysc_muse_finale_7_6_19' AND
`viewid` = 48
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
997μs0B/plugins/content/sigplus/core/core.php:3375CopySELECT `folderid`, `foldertime`, `entitytag` FROM `j25_sigplus_folder` WHERE `folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/18_19_open_day_scienze_ale'
115μs656B/plugins/content/sigplus/core/core.php:3119CopySELECT viewid
FROM j25_sigplus_view
WHERE folderid = 51 AND hash = 0x284e872a15d60a74386cdc6e71d42f5e
75μs536B/plugins/content/sigplus/core/core.php:1229CopySELECT
i.`fileurl`,
i.`imageid`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
WHERE h.`ancestorid` = 51 AND NOT EXISTS (SELECT * FROM `j25_sigplus_imageview` AS v WHERE i.`imageid` = v.`imageid` AND v.`viewid` = 51) AND depthnum <= 0
466μs576B/plugins/content/sigplus/core/core.php:1845CopySELECT
`langid`
FROM `j25_sigplus_language`
WHERE
`lang` = 'it'
97μs536B/plugins/content/sigplus/core/core.php:329CopySELECT
`countryid`
FROM `j25_sigplus_country`
WHERE
`country` = 'IT'
92μs536B/plugins/content/sigplus/core/core.php:344CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/18_19_open_day_scienze_ale' AND
`viewid` = 51
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
2.01ms35.86KB/plugins/content/sigplus/core/core.php:3368CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/18_19_open_day_scienze_ale' AND
`viewid` = 51
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
1.95ms0B/plugins/content/sigplus/core/core.php:3375CopySELECT `folderid`, `foldertime`, `entitytag` FROM `j25_sigplus_folder` WHERE `folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/18_19_open_day_scienze_gallery'
173μs656B/plugins/content/sigplus/core/core.php:3119CopySELECT viewid
FROM j25_sigplus_view
WHERE folderid = 250 AND hash = 0x822f7cf221e718bbec6650cd9c692761
90μs536B/plugins/content/sigplus/core/core.php:1229CopySELECT
i.`fileurl`,
i.`imageid`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
WHERE h.`ancestorid` = 250 AND NOT EXISTS (SELECT * FROM `j25_sigplus_imageview` AS v WHERE i.`imageid` = v.`imageid` AND v.`viewid` = 246) AND depthnum <= 0
644μs576B/plugins/content/sigplus/core/core.php:1845CopySELECT
`langid`
FROM `j25_sigplus_language`
WHERE
`lang` = 'it'
148μs536B/plugins/content/sigplus/core/core.php:329CopySELECT
`countryid`
FROM `j25_sigplus_country`
WHERE
`country` = 'IT'
92μs536B/plugins/content/sigplus/core/core.php:344CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/18_19_open_day_scienze_gallery' AND
`viewid` = 246
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
3.6ms52.86KB/plugins/content/sigplus/core/core.php:3368CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/18_19_open_day_scienze_gallery' AND
`viewid` = 246
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
3.37ms0B/plugins/content/sigplus/core/core.php:3375CopySELECT `folderid`, `foldertime`, `entitytag` FROM `j25_sigplus_folder` WHERE `folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/mattinata_scienza_22_11_18'
175μs656B/plugins/content/sigplus/core/core.php:3119CopySELECT viewid
FROM j25_sigplus_view
WHERE folderid = 251 AND hash = 0x9cf4e2b2b82795d4466f7cbd4c5a45ed
86μs536B/plugins/content/sigplus/core/core.php:1229CopySELECT
i.`fileurl`,
i.`imageid`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
WHERE h.`ancestorid` = 251 AND NOT EXISTS (SELECT * FROM `j25_sigplus_imageview` AS v WHERE i.`imageid` = v.`imageid` AND v.`viewid` = 247) AND depthnum <= 0
289μs576B/plugins/content/sigplus/core/core.php:1845CopySELECT
`langid`
FROM `j25_sigplus_language`
WHERE
`lang` = 'it'
149μs536B/plugins/content/sigplus/core/core.php:329CopySELECT
`countryid`
FROM `j25_sigplus_country`
WHERE
`country` = 'IT'
93μs536B/plugins/content/sigplus/core/core.php:344CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/mattinata_scienza_22_11_18' AND
`viewid` = 247
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
2.18ms18.98KB/plugins/content/sigplus/core/core.php:3368CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/mattinata_scienza_22_11_18' AND
`viewid` = 247
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
2.09ms0B/plugins/content/sigplus/core/core.php:3375CopySELECT `folderid`, `foldertime`, `entitytag` FROM `j25_sigplus_folder` WHERE `folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/openday_sc_premiazione_27_4_18'
256μs656B/plugins/content/sigplus/core/core.php:3119CopySELECT viewid
FROM j25_sigplus_view
WHERE folderid = 252 AND hash = 0xe26089d5bd85ea0ad22d35f3c512b96c
165μs536B/plugins/content/sigplus/core/core.php:1229CopySELECT
i.`fileurl`,
i.`imageid`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
WHERE h.`ancestorid` = 252 AND NOT EXISTS (SELECT * FROM `j25_sigplus_imageview` AS v WHERE i.`imageid` = v.`imageid` AND v.`viewid` = 248) AND depthnum <= 0
687μs11.56KB/plugins/content/sigplus/core/core.php:1845CopySELECT
`langid`
FROM `j25_sigplus_language`
WHERE
`lang` = 'it'
275μs536B/plugins/content/sigplus/core/core.php:329CopySELECT
`countryid`
FROM `j25_sigplus_country`
WHERE
`country` = 'IT'
239μs536B/plugins/content/sigplus/core/core.php:344CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/openday_sc_premiazione_27_4_18' AND
`viewid` = 248
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
2.75ms2.48KB/plugins/content/sigplus/core/core.php:3368CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/openday_sc_premiazione_27_4_18' AND
`viewid` = 248
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
2.65ms0B/plugins/content/sigplus/core/core.php:3375CopySELECT `folderid`, `foldertime`, `entitytag` FROM `j25_sigplus_folder` WHERE `folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/openday_sc_finale_27_4_18'
187μs656B/plugins/content/sigplus/core/core.php:3119CopySELECT viewid
FROM j25_sigplus_view
WHERE folderid = 253 AND hash = 0x6ec117512487403dae9ae978e52bed86
120μs536B/plugins/content/sigplus/core/core.php:1229CopySELECT
i.`fileurl`,
i.`imageid`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
WHERE h.`ancestorid` = 253 AND NOT EXISTS (SELECT * FROM `j25_sigplus_imageview` AS v WHERE i.`imageid` = v.`imageid` AND v.`viewid` = 249) AND depthnum <= 0
570μs576B/plugins/content/sigplus/core/core.php:1845CopySELECT
`langid`
FROM `j25_sigplus_language`
WHERE
`lang` = 'it'
155μs536B/plugins/content/sigplus/core/core.php:329CopySELECT
`countryid`
FROM `j25_sigplus_country`
WHERE
`country` = 'IT'
133μs536B/plugins/content/sigplus/core/core.php:344CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/openday_sc_finale_27_4_18' AND
`viewid` = 249
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
2ms19.23KB/plugins/content/sigplus/core/core.php:3368CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/openday_sc_finale_27_4_18' AND
`viewid` = 249
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
2.25ms0B/plugins/content/sigplus/core/core.php:3375CopySELECT `folderid`, `foldertime`, `entitytag` FROM `j25_sigplus_folder` WHERE `folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/open_day_scienze_29_11_17'
191μs656B/plugins/content/sigplus/core/core.php:3119CopySELECT viewid
FROM j25_sigplus_view
WHERE folderid = 254 AND hash = 0xc6c887c0295a467c3ff1e84ece110ae9
85μs536B/plugins/content/sigplus/core/core.php:1229CopySELECT
i.`fileurl`,
i.`imageid`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
WHERE h.`ancestorid` = 254 AND NOT EXISTS (SELECT * FROM `j25_sigplus_imageview` AS v WHERE i.`imageid` = v.`imageid` AND v.`viewid` = 250) AND depthnum <= 0
568μs576B/plugins/content/sigplus/core/core.php:1845CopySELECT
`langid`
FROM `j25_sigplus_language`
WHERE
`lang` = 'it'
170μs536B/plugins/content/sigplus/core/core.php:329CopySELECT
`countryid`
FROM `j25_sigplus_country`
WHERE
`country` = 'IT'
100μs536B/plugins/content/sigplus/core/core.php:344CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/open_day_scienze_29_11_17' AND
`viewid` = 250
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
4.4ms52.36KB/plugins/content/sigplus/core/core.php:3368CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/open_day_scienze_29_11_17' AND
`viewid` = 250
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
4.53ms0B/plugins/content/sigplus/core/core.php:3375CopySELECT `folderid`, `foldertime`, `entitytag` FROM `j25_sigplus_folder` WHERE `folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/musica_open_day_sc_29_11_17'
152μs656B/plugins/content/sigplus/core/core.php:3119CopySELECT viewid
FROM j25_sigplus_view
WHERE folderid = 255 AND hash = 0x43af2197c16d68bc8cbc1de7fffe1f8e
83μs536B/plugins/content/sigplus/core/core.php:1229CopySELECT
i.`fileurl`,
i.`imageid`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
WHERE h.`ancestorid` = 255 AND NOT EXISTS (SELECT * FROM `j25_sigplus_imageview` AS v WHERE i.`imageid` = v.`imageid` AND v.`viewid` = 251) AND depthnum <= 0
230μs576B/plugins/content/sigplus/core/core.php:1845CopySELECT
`langid`
FROM `j25_sigplus_language`
WHERE
`lang` = 'it'
119μs536B/plugins/content/sigplus/core/core.php:329CopySELECT
`countryid`
FROM `j25_sigplus_country`
WHERE
`country` = 'IT'
118μs536B/plugins/content/sigplus/core/core.php:344CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/musica_open_day_sc_29_11_17' AND
`viewid` = 251
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
1.08ms2.48KB/plugins/content/sigplus/core/core.php:3368CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/musica_open_day_sc_29_11_17' AND
`viewid` = 251
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
1.16ms0B/plugins/content/sigplus/core/core.php:3375CopySELECT `folderid`, `foldertime`, `entitytag` FROM `j25_sigplus_folder` WHERE `folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/mattinata_scienza_9_11_17'
158μs656B/plugins/content/sigplus/core/core.php:3119CopySELECT viewid
FROM j25_sigplus_view
WHERE folderid = 256 AND hash = 0x9c690f04b1e92a20aef9e7c1ea44de46
82μs536B/plugins/content/sigplus/core/core.php:1229CopySELECT
i.`fileurl`,
i.`imageid`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
WHERE h.`ancestorid` = 256 AND NOT EXISTS (SELECT * FROM `j25_sigplus_imageview` AS v WHERE i.`imageid` = v.`imageid` AND v.`viewid` = 252) AND depthnum <= 0
268μs576B/plugins/content/sigplus/core/core.php:1845CopySELECT
`langid`
FROM `j25_sigplus_language`
WHERE
`lang` = 'it'
159μs536B/plugins/content/sigplus/core/core.php:329CopySELECT
`countryid`
FROM `j25_sigplus_country`
WHERE
`country` = 'IT'
90μs536B/plugins/content/sigplus/core/core.php:344CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/mattinata_scienza_9_11_17' AND
`viewid` = 252
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
1.7ms18.86KB/plugins/content/sigplus/core/core.php:3368CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/mattinata_scienza_9_11_17' AND
`viewid` = 252
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
1.6ms0B/plugins/content/sigplus/core/core.php:3375CopySELECT `folderid`, `foldertime`, `entitytag` FROM `j25_sigplus_folder` WHERE `folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/finale_tysc_21_4_17'
249μs656B/plugins/content/sigplus/core/core.php:3119CopySELECT viewid
FROM j25_sigplus_view
WHERE folderid = 265 AND hash = 0x8e6e4be3a3182551eb1dadc3280c80a4
157μs536B/plugins/content/sigplus/core/core.php:1229CopySELECT
i.`fileurl`,
i.`imageid`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
WHERE h.`ancestorid` = 265 AND NOT EXISTS (SELECT * FROM `j25_sigplus_imageview` AS v WHERE i.`imageid` = v.`imageid` AND v.`viewid` = 261) AND depthnum <= 0
1.13ms576B/plugins/content/sigplus/core/core.php:1845CopySELECT
`langid`
FROM `j25_sigplus_language`
WHERE
`lang` = 'it'
207μs536B/plugins/content/sigplus/core/core.php:329CopySELECT
`countryid`
FROM `j25_sigplus_country`
WHERE
`country` = 'IT'
207μs536B/plugins/content/sigplus/core/core.php:344CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/finale_tysc_21_4_17' AND
`viewid` = 261
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
4.61ms19.36KB/plugins/content/sigplus/core/core.php:3368CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/finale_tysc_21_4_17' AND
`viewid` = 261
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
3.11ms0B/plugins/content/sigplus/core/core.php:3375CopySELECT `folderid`, `foldertime`, `entitytag` FROM `j25_sigplus_folder` WHERE `folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/finale_tysc_21_4_17_premiazione'
200μs656B/plugins/content/sigplus/core/core.php:3119CopySELECT viewid
FROM j25_sigplus_view
WHERE folderid = 266 AND hash = 0x776bab5d299ebd9244de96357adb6371
97μs536B/plugins/content/sigplus/core/core.php:1229CopySELECT
i.`fileurl`,
i.`imageid`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
WHERE h.`ancestorid` = 266 AND NOT EXISTS (SELECT * FROM `j25_sigplus_imageview` AS v WHERE i.`imageid` = v.`imageid` AND v.`viewid` = 262) AND depthnum <= 0
425μs576B/plugins/content/sigplus/core/core.php:1845CopySELECT
`langid`
FROM `j25_sigplus_language`
WHERE
`lang` = 'it'
124μs536B/plugins/content/sigplus/core/core.php:329CopySELECT
`countryid`
FROM `j25_sigplus_country`
WHERE
`country` = 'IT'
155μs536B/plugins/content/sigplus/core/core.php:344CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/finale_tysc_21_4_17_premiazione' AND
`viewid` = 262
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
1.67ms2.67KB/plugins/content/sigplus/core/core.php:3368CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/finale_tysc_21_4_17_premiazione' AND
`viewid` = 262
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
1.58ms0B/plugins/content/sigplus/core/core.php:3375CopySELECT `folderid`, `foldertime`, `entitytag` FROM `j25_sigplus_folder` WHERE `folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/open_day_scienze_19_12_16'
177μs656B/plugins/content/sigplus/core/core.php:3119CopySELECT viewid
FROM j25_sigplus_view
WHERE folderid = 267 AND hash = 0xdb3245a311973a6dac65c2594e559f92
89μs536B/plugins/content/sigplus/core/core.php:1229CopySELECT
i.`fileurl`,
i.`imageid`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
WHERE h.`ancestorid` = 267 AND NOT EXISTS (SELECT * FROM `j25_sigplus_imageview` AS v WHERE i.`imageid` = v.`imageid` AND v.`viewid` = 263) AND depthnum <= 0
792μs576B/plugins/content/sigplus/core/core.php:1845CopySELECT
`langid`
FROM `j25_sigplus_language`
WHERE
`lang` = 'it'
114μs536B/plugins/content/sigplus/core/core.php:329CopySELECT
`countryid`
FROM `j25_sigplus_country`
WHERE
`country` = 'IT'
128μs536B/plugins/content/sigplus/core/core.php:344CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/open_day_scienze_19_12_16' AND
`viewid` = 263
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
2.35ms52.36KB/plugins/content/sigplus/core/core.php:3368CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/open_day_scienze_19_12_16' AND
`viewid` = 263
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
2.47ms0B/plugins/content/sigplus/core/core.php:3375CopySELECT `folderid`, `foldertime`, `entitytag` FROM `j25_sigplus_folder` WHERE `folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/finale_TYSC_15_4_16'
341μs656B/plugins/content/sigplus/core/core.php:3119CopySELECT viewid
FROM j25_sigplus_view
WHERE folderid = 259 AND hash = 0x925d979726b7941db008a6b53daa2581
152μs536B/plugins/content/sigplus/core/core.php:1229CopySELECT
i.`fileurl`,
i.`imageid`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
WHERE h.`ancestorid` = 259 AND NOT EXISTS (SELECT * FROM `j25_sigplus_imageview` AS v WHERE i.`imageid` = v.`imageid` AND v.`viewid` = 255) AND depthnum <= 0
1.23ms576B/plugins/content/sigplus/core/core.php:1845CopySELECT
`langid`
FROM `j25_sigplus_language`
WHERE
`lang` = 'it'
125μs536B/plugins/content/sigplus/core/core.php:329CopySELECT
`countryid`
FROM `j25_sigplus_country`
WHERE
`country` = 'IT'
102μs536B/plugins/content/sigplus/core/core.php:344CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/finale_TYSC_15_4_16' AND
`viewid` = 255
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
6.54ms35.86KB/plugins/content/sigplus/core/core.php:3368CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/finale_TYSC_15_4_16' AND
`viewid` = 255
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
3.64ms0B/plugins/content/sigplus/core/core.php:3375CopySELECT `folderid`, `foldertime`, `entitytag` FROM `j25_sigplus_folder` WHERE `folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/finale_TYSC_premiazione_15_4_16'
179μs656B/plugins/content/sigplus/core/core.php:3119CopySELECT viewid
FROM j25_sigplus_view
WHERE folderid = 262 AND hash = 0xe4fddad8a9187673f62d21bd619bd4b4
92μs536B/plugins/content/sigplus/core/core.php:1229CopySELECT
i.`fileurl`,
i.`imageid`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
WHERE h.`ancestorid` = 262 AND NOT EXISTS (SELECT * FROM `j25_sigplus_imageview` AS v WHERE i.`imageid` = v.`imageid` AND v.`viewid` = 258) AND depthnum <= 0
274μs576B/plugins/content/sigplus/core/core.php:1845CopySELECT
`langid`
FROM `j25_sigplus_language`
WHERE
`lang` = 'it'
133μs8.52KB/plugins/content/sigplus/core/core.php:329CopySELECT
`countryid`
FROM `j25_sigplus_country`
WHERE
`country` = 'IT'
133μs536B/plugins/content/sigplus/core/core.php:344CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/finale_TYSC_premiazione_15_4_16' AND
`viewid` = 258
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
1.41ms2.61KB/plugins/content/sigplus/core/core.php:3368CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/finale_TYSC_premiazione_15_4_16' AND
`viewid` = 258
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
1.31ms0B/plugins/content/sigplus/core/core.php:3375CopySELECT `folderid`, `foldertime`, `entitytag` FROM `j25_sigplus_folder` WHERE `folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/open_day_sc_cartelloni_16_12_15'
187μs656B/plugins/content/sigplus/core/core.php:3119CopySELECT viewid
FROM j25_sigplus_view
WHERE folderid = 263 AND hash = 0x113848e8da477f5c88c3e08eff3dd576
95μs536B/plugins/content/sigplus/core/core.php:1229CopySELECT
i.`fileurl`,
i.`imageid`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
WHERE h.`ancestorid` = 263 AND NOT EXISTS (SELECT * FROM `j25_sigplus_imageview` AS v WHERE i.`imageid` = v.`imageid` AND v.`viewid` = 259) AND depthnum <= 0
866μs576B/plugins/content/sigplus/core/core.php:1845CopySELECT
`langid`
FROM `j25_sigplus_language`
WHERE
`lang` = 'it'
99μs536B/plugins/content/sigplus/core/core.php:329CopySELECT
`countryid`
FROM `j25_sigplus_country`
WHERE
`country` = 'IT'
153μs536B/plugins/content/sigplus/core/core.php:344CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/open_day_sc_cartelloni_16_12_15' AND
`viewid` = 259
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
3.53ms52.36KB/plugins/content/sigplus/core/core.php:3368CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/open_day_sc_cartelloni_16_12_15' AND
`viewid` = 259
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
2.48ms0B/plugins/content/sigplus/core/core.php:3375CopySELECT `folderid`, `foldertime`, `entitytag` FROM `j25_sigplus_folder` WHERE `folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/open_day_sc_16_12_15'
182μs656B/plugins/content/sigplus/core/core.php:3119CopySELECT viewid
FROM j25_sigplus_view
WHERE folderid = 264 AND hash = 0x7b32064c66bdcf63d9cdb60d9943c5c2
82μs536B/plugins/content/sigplus/core/core.php:1229CopySELECT
i.`fileurl`,
i.`imageid`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
WHERE h.`ancestorid` = 264 AND NOT EXISTS (SELECT * FROM `j25_sigplus_imageview` AS v WHERE i.`imageid` = v.`imageid` AND v.`viewid` = 260) AND depthnum <= 0
530μs576B/plugins/content/sigplus/core/core.php:1845CopySELECT
`langid`
FROM `j25_sigplus_language`
WHERE
`lang` = 'it'
65μs536B/plugins/content/sigplus/core/core.php:329CopySELECT
`countryid`
FROM `j25_sigplus_country`
WHERE
`country` = 'IT'
56μs536B/plugins/content/sigplus/core/core.php:344CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/open_day_sc_16_12_15' AND
`viewid` = 260
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
2.16ms52.11KB/plugins/content/sigplus/core/core.php:3368CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/open_day_sc_16_12_15' AND
`viewid` = 260
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
2.11ms0B/plugins/content/sigplus/core/core.php:3375CopySELECT `folderid`, `foldertime`, `entitytag` FROM `j25_sigplus_folder` WHERE `folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/open_day_sc_14_15'
147μs656B/plugins/content/sigplus/core/core.php:3119CopySELECT viewid
FROM j25_sigplus_view
WHERE folderid = 258 AND hash = 0xeca8555fdd67c67eb75a211788dece9c
112μs536B/plugins/content/sigplus/core/core.php:1229CopySELECT
i.`fileurl`,
i.`imageid`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
WHERE h.`ancestorid` = 258 AND NOT EXISTS (SELECT * FROM `j25_sigplus_imageview` AS v WHERE i.`imageid` = v.`imageid` AND v.`viewid` = 254) AND depthnum <= 0
1.51ms576B/plugins/content/sigplus/core/core.php:1845CopySELECT
`langid`
FROM `j25_sigplus_language`
WHERE
`lang` = 'it'
105μs536B/plugins/content/sigplus/core/core.php:329CopySELECT
`countryid`
FROM `j25_sigplus_country`
WHERE
`country` = 'IT'
88μs536B/plugins/content/sigplus/core/core.php:344CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/open_day_sc_14_15' AND
`viewid` = 254
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
6.02ms68.86KB/plugins/content/sigplus/core/core.php:3368CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/open_day_sc_14_15' AND
`viewid` = 254
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
4.75ms0B/plugins/content/sigplus/core/core.php:3375CopySELECT `folderid`, `foldertime`, `entitytag` FROM `j25_sigplus_folder` WHERE `folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/open_day_sc_14_cartelloni'
102μs656B/plugins/content/sigplus/core/core.php:3119CopySELECT viewid
FROM j25_sigplus_view
WHERE folderid = 260 AND hash = 0x86e0763531aec842870efd5bd7781d94
77μs536B/plugins/content/sigplus/core/core.php:1229CopySELECT
i.`fileurl`,
i.`imageid`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
WHERE h.`ancestorid` = 260 AND NOT EXISTS (SELECT * FROM `j25_sigplus_imageview` AS v WHERE i.`imageid` = v.`imageid` AND v.`viewid` = 256) AND depthnum <= 0
382μs576B/plugins/content/sigplus/core/core.php:1845CopySELECT
`langid`
FROM `j25_sigplus_language`
WHERE
`lang` = 'it'
73μs536B/plugins/content/sigplus/core/core.php:329CopySELECT
`countryid`
FROM `j25_sigplus_country`
WHERE
`country` = 'IT'
70μs536B/plugins/content/sigplus/core/core.php:344CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/open_day_sc_14_cartelloni' AND
`viewid` = 256
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
1.54ms18.98KB/plugins/content/sigplus/core/core.php:3368CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/open_day_sc_14_cartelloni' AND
`viewid` = 256
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
1.54ms0B/plugins/content/sigplus/core/core.php:3375CopySELECT `folderid`, `foldertime`, `entitytag` FROM `j25_sigplus_folder` WHERE `folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/open_day_sc_attestasti_14_15'
89μs656B/plugins/content/sigplus/core/core.php:3119CopySELECT viewid
FROM j25_sigplus_view
WHERE folderid = 261 AND hash = 0x6943a73100f6ed99b1e718115f84db64
73μs536B/plugins/content/sigplus/core/core.php:1229CopySELECT
i.`fileurl`,
i.`imageid`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
WHERE h.`ancestorid` = 261 AND NOT EXISTS (SELECT * FROM `j25_sigplus_imageview` AS v WHERE i.`imageid` = v.`imageid` AND v.`viewid` = 257) AND depthnum <= 0
268μs576B/plugins/content/sigplus/core/core.php:1845CopySELECT
`langid`
FROM `j25_sigplus_language`
WHERE
`lang` = 'it'
69μs536B/plugins/content/sigplus/core/core.php:329CopySELECT
`countryid`
FROM `j25_sigplus_country`
WHERE
`country` = 'IT'
58μs536B/plugins/content/sigplus/core/core.php:344CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/open_day_sc_attestasti_14_15' AND
`viewid` = 257
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
985μs2.52KB/plugins/content/sigplus/core/core.php:3368CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/open_day_sc_attestasti_14_15' AND
`viewid` = 257
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
943μs0B/plugins/content/sigplus/core/core.php:3375CopySELECT `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 `j25_categories` AS `s`
INNER JOIN `j25_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,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
1.06ms3.94KBParams/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 j25_fields AS a
LEFT JOIN `j25_languages` AS l ON l.lang_code = a.language
LEFT JOIN j25_users AS uc ON uc.id=a.checked_out
LEFT JOIN j25_viewlevels AS ag ON ag.id = a.access
LEFT JOIN j25_users AS ua ON ua.id = a.created_user_id
LEFT JOIN j25_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `j25_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
ORDER BY a.ordering ASC
2.3ms4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `folderid`, `foldertime`, `entitytag` FROM `j25_sigplus_folder` WHERE `folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/3_5_23_cinema_orsi'
178μs656B/plugins/content/sigplus/core/core.php:3119CopySELECT viewid
FROM j25_sigplus_view
WHERE folderid = 233 AND hash = 0x2e96d68ba18e52ed48d1a3cd3a2391ca
144μs536B/plugins/content/sigplus/core/core.php:1229CopySELECT
i.`fileurl`,
i.`imageid`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
WHERE h.`ancestorid` = 233 AND NOT EXISTS (SELECT * FROM `j25_sigplus_imageview` AS v WHERE i.`imageid` = v.`imageid` AND v.`viewid` = 229) AND depthnum <= 0
532μs576B/plugins/content/sigplus/core/core.php:1845CopySELECT
`langid`
FROM `j25_sigplus_language`
WHERE
`lang` = 'it'
114μs536B/plugins/content/sigplus/core/core.php:329CopySELECT
`countryid`
FROM `j25_sigplus_country`
WHERE
`country` = 'IT'
100μs536B/plugins/content/sigplus/core/core.php:344CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/3_5_23_cinema_orsi' AND
`viewid` = 229
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
1.72ms2.39KB/plugins/content/sigplus/core/core.php:3368CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/3_5_23_cinema_orsi' AND
`viewid` = 229
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
1.65ms0B/plugins/content/sigplus/core/core.php:3375CopySELECT `folderid`, `foldertime`, `entitytag` FROM `j25_sigplus_folder` WHERE `folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/cortina_2015'
145μs656B/plugins/content/sigplus/core/core.php:3119CopySELECT viewid
FROM j25_sigplus_view
WHERE folderid = 234 AND hash = 0xb8299cbfe97519057d3e54053ece6319
119μs536B/plugins/content/sigplus/core/core.php:1229CopySELECT
i.`fileurl`,
i.`imageid`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
WHERE h.`ancestorid` = 234 AND NOT EXISTS (SELECT * FROM `j25_sigplus_imageview` AS v WHERE i.`imageid` = v.`imageid` AND v.`viewid` = 230) AND depthnum <= 0
1.46ms576B/plugins/content/sigplus/core/core.php:1845CopySELECT
`langid`
FROM `j25_sigplus_language`
WHERE
`lang` = 'it'
83μs536B/plugins/content/sigplus/core/core.php:329CopySELECT
`countryid`
FROM `j25_sigplus_country`
WHERE
`country` = 'IT'
71μs536B/plugins/content/sigplus/core/core.php:344CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/cortina_2015' AND
`viewid` = 230
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
4.04ms52.36KB/plugins/content/sigplus/core/core.php:3368CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/cortina_2015' AND
`viewid` = 230
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
4.04ms0B/plugins/content/sigplus/core/core.php:3375CopySELECT `folderid`, `foldertime`, `entitytag` FROM `j25_sigplus_folder` WHERE `folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/ultima_estate_foto'
171μs656B/plugins/content/sigplus/core/core.php:3119CopySELECT viewid
FROM j25_sigplus_view
WHERE folderid = 232 AND hash = 0x3a6572175f39ebb2d16c7c48ccfee325
124μs536B/plugins/content/sigplus/core/core.php:1229CopySELECT
i.`fileurl`,
i.`imageid`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
WHERE h.`ancestorid` = 232 AND NOT EXISTS (SELECT * FROM `j25_sigplus_imageview` AS v WHERE i.`imageid` = v.`imageid` AND v.`viewid` = 228) AND depthnum <= 0
1.3ms576B/plugins/content/sigplus/core/core.php:1845CopySELECT
`langid`
FROM `j25_sigplus_language`
WHERE
`lang` = 'it'
116μs536B/plugins/content/sigplus/core/core.php:329CopySELECT
`countryid`
FROM `j25_sigplus_country`
WHERE
`country` = 'IT'
103μs536B/plugins/content/sigplus/core/core.php:344CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/ultima_estate_foto' AND
`viewid` = 228
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
4.61ms36.11KB/plugins/content/sigplus/core/core.php:3368CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/ultima_estate_foto' AND
`viewid` = 228
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
3.93ms0B/plugins/content/sigplus/core/core.php:3375CopySELECT `folderid`, `foldertime`, `entitytag` FROM `j25_sigplus_folder` WHERE `folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/tutti_contro_gallery_2013'
133μs656B/plugins/content/sigplus/core/core.php:3119CopySELECT viewid
FROM j25_sigplus_view
WHERE folderid = 235 AND hash = 0xd88257237d62429b5bdbd6b6776a7f71
124μs536B/plugins/content/sigplus/core/core.php:1229CopySELECT
i.`fileurl`,
i.`imageid`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
WHERE h.`ancestorid` = 235 AND NOT EXISTS (SELECT * FROM `j25_sigplus_imageview` AS v WHERE i.`imageid` = v.`imageid` AND v.`viewid` = 231) AND depthnum <= 0
596μs576B/plugins/content/sigplus/core/core.php:1845CopySELECT
`langid`
FROM `j25_sigplus_language`
WHERE
`lang` = 'it'
118μs536B/plugins/content/sigplus/core/core.php:329CopySELECT
`countryid`
FROM `j25_sigplus_country`
WHERE
`country` = 'IT'
101μs536B/plugins/content/sigplus/core/core.php:344CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/tutti_contro_gallery_2013' AND
`viewid` = 231
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
2.36ms2.73KB/plugins/content/sigplus/core/core.php:3368CopySELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`title`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT md.`textvalue`
FROM `j25_sigplus_property` AS mp
INNER JOIN `j25_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract' AND md.`imageid` = i.`imageid`
LIMIT 1
),
(
SELECT p.`summary`
FROM `j25_sigplus_foldercaption` AS p
WHERE
p.`langid` = 73 AND
p.`countryid` = 92 AND
i.`filename` LIKE p.`pattern` AND
i.`folderid` = p.`folderid`
ORDER BY p.`priority` LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`
FROM `j25_sigplus_image` AS i
INNER JOIN `j25_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `j25_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `j25_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `j25_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `j25_sigplus_caption` AS c
ON
c.`imageid` = i.`imageid` AND
c.`langid` = 73 AND
c.`countryid` = 92
WHERE
a.`folderurl` = '/var/www/sitiweb/ictn5-current/images/stories/tutti_contro_gallery_2013' AND
`viewid` = 231
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, `filename` ASC
2.28ms0B/plugins/content/sigplus/core/core.php:3375CopySELECT 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 j25_fields AS a
LEFT JOIN `j25_languages` AS l ON l.lang_code = a.language
LEFT JOIN j25_users AS uc ON uc.id=a.checked_out
LEFT JOIN j25_viewlevels AS ag ON ag.id = a.access
LEFT JOIN j25_users AS ua ON ua.id = a.created_user_id
LEFT JOIN j25_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
ORDER BY a.ordering ASC
1.02ms4.13KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `field_id`,`value`
FROM `j25_fields_values`
WHERE `field_id` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4) AND `item_id` = :itemid
197μs1.45KBParams/administrator/components/com_fields/src/Model/FieldModel.php:728CopySELECT `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 `j25_categories` AS `s`
INNER JOIN `j25_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,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
826μs36.19KBParams/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 j25_fields AS a
LEFT JOIN `j25_languages` AS l ON l.lang_code = a.language
LEFT JOIN j25_users AS uc ON uc.id=a.checked_out
LEFT JOIN j25_viewlevels AS ag ON ag.id = a.access
LEFT JOIN j25_users AS ua ON ua.id = a.created_user_id
LEFT JOIN j25_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `j25_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)) AND `a`.`access` IN (:preparedArray4,:preparedArray5)) AND
(`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray6,:preparedArray7)) 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 ASC
1.81ms4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT 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 j25_fields AS a
LEFT JOIN `j25_languages` AS l ON l.lang_code = a.language
LEFT JOIN j25_users AS uc ON uc.id=a.checked_out
LEFT JOIN j25_viewlevels AS ag ON ag.id = a.access
LEFT JOIN j25_users AS ua ON ua.id = a.created_user_id
LEFT JOIN j25_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
ORDER BY a.ordering ASC
3.34ms20.69KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `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 `j25_categories` AS `s`
INNER JOIN `j25_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,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
1.03ms3.94KBParams/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 `j25_categories` AS `s`
INNER JOIN `j25_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,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
596μs3.94KBParams/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 `j25_categories` AS `s`
INNER JOIN `j25_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,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
600μs3.94KBParams/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 `j25_categories` AS `s`
INNER JOIN `j25_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,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
587μs3.94KBParams/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 `j25_categories` AS `s`
INNER JOIN `j25_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,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
590μs3.94KBParams/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 `j25_categories` AS `s`
INNER JOIN `j25_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,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
587μs3.94KBParams/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 `j25_categories` AS `s`
INNER JOIN `j25_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,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
584μs3.94KBParams/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 `j25_categories` AS `s`
INNER JOIN `j25_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,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
586μs3.94KBParams/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 `j25_categories` AS `s`
INNER JOIN `j25_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,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
442μs3.94KBParams/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 `j25_categories` AS `s`
INNER JOIN `j25_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,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
441μs3.94KBParams/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 `j25_categories` AS `s`
INNER JOIN `j25_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,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
437μs3.94KBParams/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 `j25_categories` AS `s`
INNER JOIN `j25_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,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
450μs3.94KBParams/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 `j25_categories` AS `s`
INNER JOIN `j25_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,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
435μs3.94KBParams/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 `j25_categories` AS `s`
INNER JOIN `j25_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,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
443μs3.94KBParams/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 `j25_categories` AS `s`
INNER JOIN `j25_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,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
433μs3.94KBParams/libraries/src/Categories/Categories.php:375CopySELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid`
FROM `j25_modules` AS `m`
LEFT JOIN `j25_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id`
LEFT JOIN `j25_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)
ORDER BY `m`.`position`,`m`.`ordering`
1.66ms2.06KBParams/libraries/src/Cache/Controller/CallbackController.php:51CopySELECT `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 `j25_menu` AS `m`
LEFT JOIN `j25_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`
4.24ms203.3KBParams/libraries/src/Menu/SiteMenu.php:166CopySELECT GROUP_CONCAT(c.slug ORDER BY r.level DESC SEPARATOR '/')
FROM `j25_docman_category_relations` as r
INNER JOIN `j25_docman_categories` AS c2 ON c2.slug = 'privacy-policy'
LEFT JOIN `j25_docman_categories` AS c ON c.docman_category_id = r.ancestor_id
WHERE r.descendant_id = c2.docman_category_id
ORDER BY r.level DESC
340μs536B/components/com_docman/router.php:83CopySELECT `name`,`element`
FROM `j25_extensions`
WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1
882μs704B/administrator/components/com_finder/src/Helper/LanguageHelper.php:135CopySELECT `title`
FROM `j25_finder_taxonomy`
WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,9)
418μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314CopySELECT *
FROM `j25_miniorange_saml_config`
WHERE `id` = 1
304μs2.75KB/administrator/components/com_miniorange_saml/helpers/mo-saml-utility.php:90CopySELECT *
FROM `j25_miniorange_saml_customer_details`
WHERE `id` = 1
283μs3.03KB/administrator/components/com_miniorange_saml/helpers/mo-saml-utility.php:90CopySELECT *
FROM `j25_miniorange_saml_customer_details`
WHERE `id` = 1
242μs3.03KB/administrator/components/com_miniorange_saml/helpers/mo-saml-utility.php:90CopySELECT *
FROM `j25_miniorange_saml_customer_details`
WHERE `id` = 1
252μs3.03KB/administrator/components/com_miniorange_saml/helpers/mo-saml-utility.php:90CopySELECT *
FROM `j25_miniorange_saml_customer_details`
WHERE `id` = 1
240μs3.03KB/administrator/components/com_miniorange_saml/helpers/mo-saml-utility.php:90CopySELECT `session_id`
FROM `j25_session`
WHERE `session_id` = ?
235μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291CopyUPDATE `j25_session`
SET `data` = ?
, `time` = ?
WHERE `session_id` = ?
1.43ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy