9. 12. 2013
System News 9-12-2013
9. 12. 2013
System News 9-12-2013
2. 12. 2013
System News 2-12-2013
25. 11. 2013
System News 25-11-2013
18. 11. 2013
System News 18-11-2013
11. 11. 2013
System News 11-11-2013
7. 11. 2013GEFCO optimalizuje nákup vďaka kolaboratívnemu systému Carrier Management System Courbevoie 7. novembra 2013 - V rámci poskytovania služieb je pre GEFCO, lídra v oblasti logistiky pre automobilový priemysel a priemyselnej logistiky, kľúčovým faktorom kvalita. Nákupné oddelenie disponuje kolaboratívnou platformou pod názvom CMS - Carrier Management System, ktorá mu umožňuje riadiť externých prepravcov a vystavovať on-line verejné súťaže formou holandských aukcií.
Inovačný systém bol zavedený vďaka podpore spoločnosti CEREZA, konzultačná spoločnosť v oblasti manažmentu a IT systémov, a predstavuje optimálne riadenie subdodávateľov i rozšírenie nákupných možností GEFCO.
Carrier Management System je súčasťou programu TOSCA, ktorý bol spustený v roku 2011. Cieľom je rozvíjať nielen víziu Gobale Agile dodávateľského reťazca GEFCO, od dodávateľov a zákazníkov až po koncových užívateľov, ale i nové produkty pre udržanie rýchlosti pohybu dodávateľských reťazcov a vylepšovať konkurencieschopnosť GEFCO.
Priekopnícky produkt
Hlavnou funkciou kolaboratívnej platformy CMS, ktorá bola zavedená vo všetkých európskych pobočkách skupiny, je uľahčenie a lepšia organizácia prác pre nákupné jednotky GEFCO.
Tento systém, ktorý bol preložený do viacerých jazykov, umožňuje prepravcom zaregistrovať sa do referenčnej databázy GEFCO. Umožňuje im to zúčastňovať sa na výzvach na predloženie ponuky zameraných na pravidelné toky.
Kombinácia ľahkého ovládania s prispôsobeným rozhraním
Platforma využíva databázu prepravcov, ktorá obsahuje všetky kritériá potrebné na vyhľadanie najvhodnejších prepravcov podľa stanovených požiadaviek.
Kolaboratívnu databázu, ktorú podporuje nákupná divízia, môže využívať aj charterová sieť skupiny GEFCO. Databáza, ktorá obsahuje viac ako 8 000 prepravcov poskytuje operátorom GEFCO prístup k efektívnemu systému riadenia, ktorý pridáva komunikácii medzi jednotlivými stranami prvok transparentnosti a GEFCO umožňuje lepšiu kontrolu svojich subdodávateľských aktivít.
„Sme veľmi spokojní s ľahkým priebehom zavedenia systému CMS v našich tímoch. Keď máme tento systém, potrebujeme len zopár kliknutí, aby sme videli odpovede na naše výzvy, a dali prepravcovi ihneď vedieť, či má jeho ponuka šancu na prijatie, alebo cena musí byť upravená,“ uviedol Florian Chesnais, nákupca pre severný región.
„CMS uľahčuje predkvalifikačnú fázu, takže teraz môžeme uchovávať dlhodobé záznamy. Navyše fakt, že máme tak obsiahlu databázu pokrývajúcu celú Európu, je veľkou výhodou vzhľadom na veľkosť siete GEFCO,“ uviedolJan Stejskal, manažér nákupu v Českej republike.
Najmodernejšie zariadenie, ktoré kladie dôraz na kvalitu
Zavedenie systému CMS je dôkazom, že v rámci poskytovania svojich služieb GEFCO kladie kvalitu vždy na prvé miesto. Táto zásada neustáleho zlepšovania sa uplatňuje aj na služby v dodávateľskej fáze.
Vďaka CMS môžu odteraz nákupcovia využívať inovačné IT riešenie, ktoré im umožňuje robiť viac než len odhadnúť samotné náklady. Teraz majú prístup aj do systému umožňujúci porovnanie kvality pre partnerov GEFCO. Operátori sa už nemusia uspokojiť len s údajom, kto ponúka najnižšiu cenu. Môžu taktiež zistiť, kto ponúka najlepšie služby. „Práve preto je tento systém kľúčovým nástrojom na zlepšenie nákupnej konkurencieschopnosti GEFCO,“ uviedol Nicolas Recapet, jeden z poradných manažérov spoločnosti Cereza.
Výsledkom je lepšia kontrola nad nákupom a nákupcovia, ktorí majú prostredníctvom komplexnej databázy prístup k informáciám o kvalite služieb prepravcov.
„Zavedenie systému CMS v rámci pozemnej siete GEFCO znázorňuje schopnosť spoločnosti zavádzať inovačné riešenia, ktoré sú vhodné pre všetky úrovne dodávateľského reťazca“, uviedol Gilbert Tichit, manažér nákupu GEFCO.
„Tento systém zlepšil výkon nášho nákupu a zvýšil produktivitu, pričom pri výbere dodávateľov zohráva kľúčovú úlohu kvalita. Referenčnú databázu môžu používať všetci a sledovať využívanie našich mnohých partnerov v celej Európe“.
5. 11. 2013
System News 04-11-2013
Tlačová správa z 2. ročníka medzinárodnej vedeckej konferencie LOGISTIKA - EKONOMIKA - PRAX 2013, ktorá sa konala dňa 26. novembra 2013 v Žiline.
Zobraziť tlačovú správu. Reportáž TV Severka o konferencii.
10. 9. 2013Euro-net expanduje v Prologis Parku Janki na 58 500 metrov štvorcových
Klient rozšíril prenajímaný priestor o 9 300 metrov štvorcových
VARŠAVA – 10. septembra 2013 – Prologis, Inc., vedúci globálny vlastník, prevádzkovateľ a developer industriálnych nehnuteľností, dnes oznámil, že spoločnosť Euro-net, vlastník maloobchodného reťazca RTV-EURO-AGD, rozšíril prenajímanú plochu v Prologis Parku Janki o 9 300 metrov štvorcových na celkových 58 500 metrov štvorcových v Budovách 1 a 2.
„Prevádzka našich 197 obchodov RTV EURO AGD v 111 mestách naprieč Poľskom spolu s internetovým obchodom Euro.com.pl závisí od hladkej a efektívnej logistiky. Distribučné nehnuteľnosti sú dôležitou súčasťou nášho dodávateľského reťazca, a práve z toho dôvodu sa spoliehame na Prologis, ktorý nám poskytuje služby na vysokej úrovni a strategicky umiestnené nehnuteľnosti, a prispieva tak k nášmu úspechu,“ povedal Andrzej Czarnecki, riaditeľ rozvoja Euro-net.
Kamila Pruk, Leasing manažérka Prologis v Poľsku dodala: „Za posledných päť rokov sa nám podarilo vybudovať s Euro-netom silný vzťah. Počas tohto obdobia spoločnosť rapídne vyrástla a využila všetky výhody, ktoré jej elektronický obchod dáva. Tešíme sa na množstvo ďalších spoločných úspešných rokov.“
Prologis Park Janki pozostáva z troch budov s celkovou rozlohou 98 200 metrov štvorcových moderných distribučných priestorov. Park je umiestnený v Janki, v blízkosti cesty číslo 8, ktorá vedie z Varšavy do Katovíc, približne 15 kilometrov na juhovýchod od centra Varšavy.
Prologis má vo varšavskom regióne sedem distribučných parkov s celkovou rozlohou viac ako 729 000 metrov štvorcových moderných skladovacích plôch. S portfóliom presahujúcim 1,9 milióna metrov štvorcových je Prologis najväčším vlastníkom a prevádzkovateľom industriálnych nehnuteľností v Poľsku (k 30. júnu 2013).
Ak chcete pridať svoj príspevok do rubriky Média monitor spracujte anotáciu podľa vzorovej štruktúry a zašlite ju na adresu logistika@va1.sk
Ak chcete pridať autorský príspevok zašlite text vo formáte PDF alebo DOC na e-mail: logistika@va1.sk
K príspevku zašlite názov príspevku aj v anglickom jazyku, stručnú anotáciu, kľúčové slová (dôležité pre vyhľadávanie) a fotografiu autora alebo ilustráciu.
Zobraziť vzorovú štruktúru príspevku.
CROWDFUNDING - je financovanie z mikrozdrojov. Logistický monitor zhromažďuje pre Vás informácie už 20 rokov BEZPLATNE. Pomôžte tomuto projektu dobrovoľnou čiastkou, ktorú pošlete na účet: Tatrabanka a.s. Žilina 2629410129/1100, IBAN: SK5O 1100 0000 0026 2941 0129. Ďakujeme.
Joomla! Version | 4.4.11 |
PHP Version | 8.2.27 |
Identity | guest |
Response | 200 |
Template | ja_edenite_ii |
Database |
|
1 x afterRenderRawModule mod_articles_latest (Naposledy pridané) (201.33KB) (23.07%) | 494.72ms |
1 x afterRenderComponent com_content (3.18MB) (19.11%) | 409.82ms |
1 x afterInitialise (5.45MB) (18.81%) | 403.45ms |
1 x beforeRenderModule mod_search (Hľadaj obsah na stránke Logistický monitor) (681.9KB) (6.16%) | 132.21ms |
1 x afterRoute (819.72KB) (4.98%) | 106.85ms |
1 x After Access::preloadPermissions (com_content) (6.41MB) (4.83%) | 103.57ms |
1 x afterLoad (734.69KB) (4.62%) | 99.09ms |
1 x afterRenderRawModule mod_stats (Štatistika) (23.12KB) (4.33%) | 92.81ms |
1 x afterRender (829.64KB) (3.05%) | 65.46ms |
1 x afterRenderRawModule mod_banners (Banners under menu) (143.28KB) (2.8%) | 60.03ms |
1 x afterRenderRawModule mod_vertical_menu (Vertical Menu) (517.54KB) (1.92%) | 41.28ms |
1 x Before Access::preloadComponents (all components) (336.95KB) (1.66%) | 35.62ms |
1 x beforeRenderComponent com_content (240.28KB) (0.79%) | 16.97ms |
1 x After Access::preloadComponents (all components) (126.13KB) (0.69%) | 14.71ms |
1 x afterRenderRawModule mod_search (Hľadaj obsah na stránke Logistický monitor) (63.26KB) (0.67%) | 14.40ms |
1 x afterRenderModule mod_search (Hľadaj obsah na stránke Logistický monitor) (10.05KB) (0.3%) | 6.47ms |
1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (15.17KB) (0.28%) | 6.07ms |
1 x afterRenderRawModule mod_custom (CHCETE PRISPIEŤ DO LOGISTICKÉHO MONITORU ?) (4.59KB) (0.21%) | 4.56ms |
1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (10.21KB) (0.16%) | 3.43ms |
1 x afterRenderModule mod_vertical_menu (Vertical Menu) (9.23KB) (0.15%) | 3.16ms |
1 x afterRenderModule mod_banners (Banners under menu) (9.12KB) (0.13%) | 2.87ms |
1 x afterRenderModule mod_articles_latest (Naposledy pridané) (9.13KB) (0.13%) | 2.85ms |
1 x afterRenderModule mod_custom (CHCETE PRISPIEŤ DO LOGISTICKÉHO MONITORU ?) (9.38KB) (0.13%) | 2.83ms |
1 x afterRenderModule mod_custom (CROWDFUNDING) (9.35KB) (0.13%) | 2.80ms |
1 x afterRenderModule mod_custom (Hlavicka obrazok) (9.06KB) (0.13%) | 2.79ms |
1 x afterRenderModule mod_stats (Štatistika) (9.34KB) (0.13%) | 2.75ms |
1 x afterDispatch (24.06KB) (0.12%) | 2.47ms |
1 x After Access::getAssetRules (id:58 name:com_content.category.38) (7.56KB) (0.08%) | 1.63ms |
1 x beforeRenderModule mod_custom (Hlavicka obrazok) (12.33KB) (0.06%) | 1.36ms |
1 x afterRenderRawModule mod_custom (Hlavicka obrazok) (1.02KB) (0.05%) | 1.04ms |
1 x beforeRenderModule mod_vertical_menu (Vertical Menu) (49.29KB) (0.04%) | 919μs |
1 x afterRenderRawModule mod_custom (CROWDFUNDING) (928B) (0.04%) | 830μs |
1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (24.32KB) (0.04%) | 829μs |
1 x Before Access::getAssetRules (id:58 name:com_content.category.38) (258.65KB) (0.02%) | 369μs |
1 x beforeRenderModule mod_banners (Banners under menu) (37.16KB) (0%) | 60μs |
1 x beforeRenderModule mod_custom (CHCETE PRISPIEŤ DO LOGISTICKÉHO MONITORU ?) (976B) (0%) | 49μs |
1 x beforeRenderModule mod_custom (CROWDFUNDING) (1.06KB) (0%) | 48μs |
1 x beforeRenderModule mod_stats (Štatistika) (1.81KB) (0%) | 47μs |
1 x beforeRenderModule mod_articles_latest (Naposledy pridané) (1.33KB) (0%) | 40μs |
1 x Before Access::preloadPermissions (com_content) (1.7KB) (0%) | 28μs |
1 x beforeRenderModule mod_articles_latest (Naposledy pridané) (720B) (0%) | 18μs |
1 x beforeRenderModule mod_banners (Banners under menu) (720B) (0%) | 17μs |
1 x beforeRenderModule mod_stats (Štatistika) (720B) (0%) | 16μs |
1 x beforeRenderModule mod_vertical_menu (Vertical Menu) (720B) (0%) | 15μs |
1 x beforeRenderModule mod_search (Hľadaj obsah na stránke Logistický monitor) (752B) (0%) | 14μs |
1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%) | 12μs |
1 x beforeRenderModule mod_custom (CHCETE PRISPIEŤ DO LOGISTICKÉHO MONITORU ?) (752B) (0%) | 11μs |
1 x beforeRenderModule mod_custom (Hlavicka obrazok) (720B) (0%) | 10μs |
1 x beforeRenderModule mod_custom (CROWDFUNDING) (720B) (0%) | 7μs |
SELECT @@SESSION.sql_mode;
5.89ms968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334CopySELECT `data`
FROM `jos9_session`
WHERE `session_id` = ?
5.94ms1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261CopySELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jos9_extensions`
WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1
6.71ms1.42KB/libraries/src/Component/ComponentHelper.php:399CopySELECT `id`,`rules`
FROM `jos9_viewlevels`
6.31ms656B/libraries/src/Access/Access.php:955CopySELECT `b`.`id`
FROM `jos9_usergroups` AS `a`
LEFT JOIN `jos9_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt`
WHERE `a`.`id` = :guest
6.06ms1.64KBParams/libraries/src/Access/Access.php:868CopySELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM `jos9_extensions`
WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2)
ORDER BY `ordering`
9.66ms3.98KBParams/libraries/src/Plugin/PluginHelper.php:294CopySELECT *
FROM `jos9_languages`
WHERE `published` = 1
ORDER BY `ordering` ASC
6.06ms1.59KB/libraries/src/Language/LanguageHelper.php:142CopySELECT *
FROM jos9_menu
WHERE alias ='aktuality-mainmenu-50' AND published=1
6.13ms2.84KB/plugins/system/t4/src/t4/MVC/Router/T4.php:353CopySELECT `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 `jos9_menu` AS `m`
LEFT JOIN `jos9_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`
12.97ms68.55KBParams/libraries/src/Menu/SiteMenu.php:166CopySELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent`
FROM `jos9_template_styles` AS `s`
LEFT JOIN `jos9_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
6.37ms896B/administrator/components/com_templates/src/Model/StyleModel.php:773CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `jos9_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)
6.9ms7.81KBParams/libraries/src/Access/Access.php:357CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `jos9_assets`
WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0
77.87ms1.07MBParams/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 `jos9_content` AS `i`
WHERE `i`.`catid` = `c`.`id` AND `i`.`state` = 1) AS `numitems`
FROM `jos9_categories` AS `s`
INNER JOIN `jos9_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`
15.53ms3.91KBParams/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 `jos9_content` AS `a`
LEFT JOIN `jos9_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `jos9_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `jos9_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `jos9_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `jos9_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
LEFT JOIN `jos9_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 AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown)
ORDER BY a.ordering, a.created LIMIT 680, 20
44.27ms102.66KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `m`.`tag_id`,`m`.`content_item_id`,`t`.*
FROM `jos9_contentitem_tag_map` AS `m`
INNER JOIN `jos9_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,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20) AND `t`.`access` IN (:preparedArray21,:preparedArray22)
6.27ms6.41KBParams/libraries/src/Helper/TagsHelper.php:448CopySELECT COUNT(*)
FROM `jos9_content` AS `a`
LEFT JOIN `jos9_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `jos9_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `jos9_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `jos9_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `jos9_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
LEFT JOIN `jos9_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 AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown)
23.68ms4.6KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:199CopySELECT `m`.`tag_id`,`t`.*
FROM `jos9_contentitem_tag_map` AS `m`
INNER JOIN `jos9_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)
6.21ms5.22KBParams/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 `jos9_categories` AS `s`
INNER JOIN `jos9_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`
6.55ms3.92KBParams/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 jos9_fields AS a
LEFT JOIN `jos9_languages` AS l ON l.lang_code = a.language
LEFT JOIN jos9_users AS uc ON uc.id=a.checked_out
LEFT JOIN jos9_viewlevels AS ag ON ag.id = a.access
LEFT JOIN jos9_users AS ua ON ua.id = a.created_user_id
LEFT JOIN jos9_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `jos9_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
6.15ms4.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 jos9_fields AS a
LEFT JOIN `jos9_languages` AS l ON l.lang_code = a.language
LEFT JOIN jos9_users AS uc ON uc.id=a.checked_out
LEFT JOIN jos9_viewlevels AS ag ON ag.id = a.access
LEFT JOIN jos9_users AS ua ON ua.id = a.created_user_id
LEFT JOIN jos9_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
6.1ms4.06KBParams/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 `jos9_categories` AS `s`
INNER JOIN `jos9_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`
6.59ms3.92KBParams/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 jos9_fields AS a
LEFT JOIN `jos9_languages` AS l ON l.lang_code = a.language
LEFT JOIN jos9_users AS uc ON uc.id=a.checked_out
LEFT JOIN jos9_viewlevels AS ag ON ag.id = a.access
LEFT JOIN jos9_users AS ua ON ua.id = a.created_user_id
LEFT JOIN jos9_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `jos9_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
6.11ms4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid`
FROM `jos9_modules` AS `m`
LEFT JOIN `jos9_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id`
LEFT JOIN `jos9_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`
7.34ms1.97KBParams/libraries/src/Cache/Controller/CallbackController.php:51CopySELECT SUM(`hits`) AS count_hits
FROM `jos9_content`
WHERE `state` = 1
80.86ms536B/modules/mod_stats/src/Helper/StatsHelper.php:128CopySELECT `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 `jos9_content` AS `a`
LEFT JOIN `jos9_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `jos9_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `jos9_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `jos9_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `jos9_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
LEFT JOIN `jos9_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`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown)
ORDER BY a.publish_up DESC LIMIT 5
463ms22.42KBParams/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 `jos9_categories` AS `s`
INNER JOIN `jos9_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`
6.57ms3.92KBParams/libraries/src/Categories/Categories.php:375CopySELECT *
FROM `jos9_banners`
WHERE
(`reset` <= :date AND `reset` IS NOT NULL) AND
(`checked_out` IS NULL OR `checked_out` = :userId)
6.46ms5.39KBParams/administrator/components/com_banners/src/Helper/BannersHelper.php:69CopySELECT `a`.`id`,`a`.`type`,`a`.`name`,`a`.`clickurl`,`a`.`sticky`,`a`.`cid`,`a`.`description`,`a`.`params`,`a`.`custombannercode`,`a`.`track_impressions`,`cl`.`track_impressions` AS `client_track_impressions`
FROM `jos9_banners` AS `a`
LEFT JOIN `jos9_banner_clients` AS `cl` ON `cl`.`id` = `a`.`cid`
WHERE
(
(
(`a`.`state` = 1) AND
(`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :nowDate1)) AND
(`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :nowDate2)) AND
(`a`.`imptotal` = 0 OR `a`.`impmade` < `a`.`imptotal`) AND `a`.`catid` IN (:preparedArray1)
ORDER BY `a`.`sticky` DESC, RAND() LIMIT 9
6.65ms2.42KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopyUPDATE `jos9_banners`
SET `impmade` = `impmade` + 1
WHERE `id` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9)
7.74ms1.66KBParams/components/com_banners/src/Model/BannersModel.php:315CopySELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count
FROM `jos9_scheduler_tasks` AS `a`
WHERE `a`.`state` = 1
5.89ms1.32KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517CopySELECT `session_id`
FROM `jos9_session`
WHERE `session_id` = ?
5.93ms1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291CopyINSERT INTO `jos9_session`
(`data`,`time`,`session_id`) VALUES
(?, ?, ?)
7.09ms544BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy