Původně pracoval jako železničář, ale poté co Bůh přehodil výhybku jeho života, začal pracovat s dětmi i dospělými v Dětské misii, s bezdomovci v Armádě spásy a potom studovat teologii v Praze. Na studiích prožil povolání ke službě kazatele a jako kazatel sloužil v Havířově, Brně, Horní Krupé a od roku 2015 je hlavním kazatelem CB Levice. Je rád s lidmi, má skvělou manželku Zdeňku a tři děti. Rád cestuje a čte.
{ "__default": { "session": { "counter": 36, "timer": { "start": 1729578956, "last": 1729578969, "now": 1729578969 }, "client": { "forwarded": "3.128.30.70" }, "token": "GPTbWPF33sXouP6kO9kqIl5AugebBCHU" }, "registry": { "com_sermonspeaker": { "sermons": { "sermons": { "limitstart": 500, "list": { "direction": "DESC", "limit": "100", "ordering": "sermon_date", "start": 100 } } }, "series": { "filter": { "speaker": 6 } } } }, "user": { "id": 0, "name": null, "username": null, "email": null, "password": null, "password_clear": "", "block": null, "sendEmail": 0, "registerDate": null, "lastvisitDate": null, "activation": null, "params": null, "groups": [], "guest": 1, "lastResetTime": null, "resetCount": null, "requireReset": null, "aid": 0 }, "com_mailto": { "links": { "eb21a6490afd66d3881b88a556c1e9b3a2849b63": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/642-nazov", "expiry": 1729578966 }, "61c34e00231d1c8d598149b846b75deeaeafa0be": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/635-nadeje", "expiry": 1729578957 }, "e39fef8c24666385db03eadcde4ed56fcaad26dc": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/serie/37-filemonovi", "expiry": 1729578966 }, "f2dcd937eb1547952a61477390f93a9fa8b70bd3": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/610-modlitba", "expiry": 1729578960 }, "0ec919ba4ce9258d44ac1346c50fa3f1b77b3ad1": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/636-zalm-125", "expiry": 1729578966 }, "3326d71902b0c8661d0805c289209866575f6313": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/serie/6-podobenstva", "expiry": 1729578966 }, "51fc98d343085f76efe6b78abea7fc910ae850c4": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/serie/48-start-seria", "expiry": 1729578967 }, "ff72131692d98fd741d2d780bc06c1a151372ae2": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/602-vedenie-1", "expiry": 1729578961 }, "be47e02e9d8ded7e7aa4e72ff4766d1c58c24f92": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/619-zacharias", "expiry": 1729578966 }, "4c549549b3f497cfd1915c558f150a4dd8511c3b": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/618-my-ludia", "expiry": 1729578962 }, "d67eb28cdb8e6c4905ad5113b9d1c6ac75199d5d": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/616-misio-dei", "expiry": 1729578963 }, "a030f4dbbb234bf9f96be569fe58e34e11ef2550": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/speaker/4-jan-henzel", "expiry": 1729578963 }, "0507222b3c1a090e93e3bfe462e56d2cc850b9bf": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/650-pripravuj-sa-na-kristov-navrat", "expiry": 1729578963 }, "83cbf639b13e2c2c3fb45ec67aed9c46fa0c74ec": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/644-pravy-sluzobnik-sa-paci-bohu-a-miluje-ludi", "expiry": 1729578963 }, "e5c8f1212428873c8886c985a7239d9201d5e3c8": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/590-dobre-a-spravne-sa-presadi-ozaj", "expiry": 1729578963 }, "b279f6e7c683e26ad442528c736fca935d53dc87": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/571-heslo-pre-zbor-na-rok-2019", "expiry": 1729578963 }, "cc17bbbc2084c9da9ae44d14d162097a027c45d6": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/24-v-ten-den-moze-byt-neskoro", "expiry": 1729578963 }, "411c6c3d355f2e012a8e98a8012955a19f2766ef": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/9-nase-hladanie-a-bozie-vedenie", "expiry": 1729578963 }, "84c9eea704b48d440900400c762aeeeabb1ea395": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/47-na-tom-comu-verime-a-ako-zijeme-zalezi", "expiry": 1729578963 }, "ad2f369ba4b78193d4c772c19a96aa36fabb6d69": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/103-kto-je-u-koho-hostom", "expiry": 1729578963 }, "b8bf2198c7e680c84298c5e6b617ca9fc6311e3c": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/110-rozvaha-a-trpezlivost-proti-rezignacii", "expiry": 1729578963 }, "35c29e72bb2459203ee3fe86e1d88f47dadc6421": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/185-bozie-milosrdenstvo-pre-vinnika", "expiry": 1729578963 }, "655768e16268903fa3022f21855cadf611a05d3d": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/199-dobra-zvest-nas-musi-viest-k-dobrym-skutkom-aj-v-zlom-svete", "expiry": 1729578963 }, "20dd3763732974d2615abe576a94742c3ab72c57": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/239-konferencna-bohosluzba", "expiry": 1729578963 }, "11d0fed014e761fac24b489273204b1ed80315b9": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/519-sluby-sa-slubuju-a", "expiry": 1729578963 }, "307bb9357e0b0cc9b20f7c9e18b9efa3467d9ff4": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/543-co-ak-predsa", "expiry": 1729578963 }, "2075a17fb0f31afea8ffefe849b3f9b0c19a64cb": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/311-nasa-nova-kristovska-identita-doma", "expiry": 1729578963 }, "593fc9f3dc8d0dce0420a064ef7dbeb5237cd5ff": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/323-cirkev-a-slovo-evanjelia", "expiry": 1729578963 }, "76c877cf63bf91d6ee3c34c097c1aac374f3c04b": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/352-bozie-ziavenie", "expiry": 1729578963 }, "14bdfbc242e8f5ce76fdf962fdb95d43a7442c78": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/390-bozia-spravodlivost-odhalena-na-kristovom-krizi", "expiry": 1729578963 }, "1771b198fc8d30b70aa7b086d8bac6bcf3b1d464": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/487-odmena-v-nebi-alebo-na-zemi", "expiry": 1729578963 }, "33a7a1f7d6c0a274b453c8e31f2b35ed7ff4e7f4": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/serie/1-abraham", "expiry": 1729578966 }, "c8965daa8056a4060afaad0953aed6a3f67104a8": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/serie/47-len-tak-dalej", "expiry": 1729578967 }, "754b3e23c98702d5f08f61d458373c3c704073b5": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/serie/49-nas-svet", "expiry": 1729578963 }, "4625b8eb885f4a31d0b9f60e735600d7d39ccd69": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/594-pocit-viny", "expiry": 1729578964 }, "58128efff2526d8ed0990b9d66ab698b1cd3c127": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/597-chamtivost", "expiry": 1729578964 }, "0a5166753b15918e719a11431d4f585d7beb40eb": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/speaker/78-simon-evin", "expiry": 1729578964 }, "910180dd18253a6757067df440b74439e77e36c5": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/652-s-bozou-pomocou", "expiry": 1729578964 }, "7b345d25a1cf101b1f4d0a44b55acd3005fdf2d9": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/629-co-je-laska", "expiry": 1729578965 }, "66c196b3b03ce749a4d22ce059ff12780341dd14": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/663-nasleduj-ma", "expiry": 1729578965 }, "9c8b4a8e4d60a4b2b8ca21ff1b92bd8bf5064c97": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/speaker/3-jan-vercimak", "expiry": 1729578966 }, "5da6317690ae12b43550f893c7fa8eab6ae323dc": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/678-vymen-strach-za-bazen", "expiry": 1729578966 }, "b20fc6155cb37f577af34c6ae7704d1c642a13d9": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/675-bozia-strategia", "expiry": 1729578966 }, "b6252d325ed0cfe3e147207813d4dcc29177244f": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/673-neodpustitelny-hriech", "expiry": 1729578966 }, "14d0434b2742c62d57baf3727a357f10a213f6bb": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/671-smutny-a-nahnevany-kral", "expiry": 1729578966 }, "7869444251d888293e69253d9550a76c443d363e": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/666-o-kralovi-jeho-autorite-a-jeho-kralovstve", "expiry": 1729578966 }, "e070e74b0391361293a00e0fa1ea323d97bb2b0b": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/661-pravy-vinic-a-prave-ovocie", "expiry": 1729578966 }, "f78c6a837f03b4e808dfa2bc81ab9d72f4899b00": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/659-co-len-s-nami-bude", "expiry": 1729578966 }, "8311c4db2621bc12b2a6105d4cbe232b4923b897": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/658-neuveritelna-nadej", "expiry": 1729578966 }, "1f4d9f8f5227ef8027c42f34c369cfdc1b5f5fe2": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/656-ak-neuverite-neobstojite", "expiry": 1729578966 }, "513e455e92ba0795c0c1e925b48f98aa6b3e4864": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/653-pametaj-na-bozie-slovo", "expiry": 1729578966 }, "190829e02d62e5d4ec6e94fdc9ec65996da3ec12": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/649-plac-s-nadejou", "expiry": 1729578966 }, "ab85f67a42ea204273f2309d46cccf191b30e7c5": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/648-miluj-a-pracuj", "expiry": 1729578966 }, "48fbe15e2d0a53c875bcd5fbae57085833970e0f": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/646-ako-sa-mas", "expiry": 1729578968 }, "dd1ec8ac3135757f5d6f05c57a78142911293c03": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/645-ste-normalni", "expiry": 1729578969 }, "b8eb944c788a3d03e953e52d5a328c7fbff10def": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/639-piesen-na-dobru-noc", "expiry": 1729578966 }, "746cbeff72c6e5a7cc97f6a3100c75a6655faafc": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/631-milovany-miluju", "expiry": 1729578966 }, "7ab8ea4e160570026e072fc0966127ef6065d98c": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/625-boh-je-svetlo", "expiry": 1729578966 }, "4f93cae0f714352b18f9f740e5a74c44cb5810e8": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/623-ked-hladaju-krala", "expiry": 1729578966 }, "320e138ace4fef2a19b05011ba16ce1ab7c6f164": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/617-v-ustrety-vzkrieseniu", "expiry": 1729578966 }, "d964470734c190db66e14f967f52cf0c5b858330": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/611-v-ustrety-koncu-dejin", "expiry": 1729578966 }, "e5551b12bfe64cc11b44f8734468b6a310ddf2ba": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/607-hladajte-hladajucich-starsich", "expiry": 1729578966 }, "26c3d824eedc39fb92847dbdaa9d356b1142bb14": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/601-nadej-v-beznadeji", "expiry": 1729578966 }, "2e002d718393134526700a24eb3f98929a1afde5": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/595-zastav-sa-a-chod", "expiry": 1729578966 }, "6eee14451e9a619025c9ea5b48918faa10a48f14": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/586-daj-si-pozor-aby-si-nepadol", "expiry": 1729578966 }, "1f5d2618a340216d98de30c9b17762ae183be764": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/584-ja-som-s-vami", "expiry": 1729578966 }, "618b114f0e2324e8339780c68337024dd45f70f8": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/580-konflikty-a-bratska-laska", "expiry": 1729578966 }, "3eecbaa689562909eca6716c5f0dfb75dec6af99": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/574-komu-sa-poklonis", "expiry": 1729578966 }, "8d219ccfded63f70152f580352499af9169a6abd": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/567-panovo-slovo-ide-do-sveta", "expiry": 1729578966 }, "c5b206ce2ad16796b64157d6a2eebd9154509665": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/565-vystrojenie-duchom", "expiry": 1729578966 }, "7be5ed170e6a9b1b9ed88337d05d9729c4b70ce5": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/559-ten-isty-nepriatel-a-ten-isty-boh", "expiry": 1729578966 }, "225edf76bb61713cd7c85c42e86c1f7691068e1b": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/267-pokusenie", "expiry": 1729578966 }, "af9f3b702c7e8725a5b3b82b485de103d10f450c": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/166-zoci-voci-smrti", "expiry": 1729578966 }, "105b172ed7c9e73662c45738d440da5f83645028": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/163-milujes-ma-2018", "expiry": 1729578966 }, "b641a90364ab635ff2bfa29067dfc48970bf13b7": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/159-kristovo-tajomstvo", "expiry": 1729578966 }, "9e5dc34d9ef46eb7f696a33f8a3702ce3acdd8b8": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/155-duchovna-garancia", "expiry": 1729578966 }, "6047340ac5a4a80ad6009894e767ffebe2b30095": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/75-bludim-hladaj-ma", "expiry": 1729578966 }, "eab682265db95e014084fad1e551c101afab1e6e": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/66-modlit-sa-a-neochabovat", "expiry": 1729578966 }, "e513bcb5e05d32aa1ab0ca0d6af7603402d2c28e": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/23-ako-sa-posledni-stali-prvymi", "expiry": 1729578966 }, "949578e1a4dd801500b898abf30fe1dd0f3bd031": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/15-je-vobec-co-oslavovat", "expiry": 1729578966 }, "6dbe5dd33d3a5c19184b30abdff6aefad0c9df7c": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/2-deti-slobody", "expiry": 1729578966 }, "d41757a7c3cc2222897af3c0909a29f402fee901": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/31-boh-ma-pozna", "expiry": 1729578966 }, "e156b85a9373d608db00a6cfaf32af66f94f42c0": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/33-velka-polna-ako-obstat-v-duchovnom-boji", "expiry": 1729578966 }, "ca5ee56f664141aec0da5c0eb079add8129debdc": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/35-mudri-rodicia-a-chytre-deti", "expiry": 1729578966 }, "13f2de7912410395f62967feafa48f83f2cf5413": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/39-dobry-krestan-dobry-obcan", "expiry": 1729578966 }, "05ed9592ac94883e5abbfc3203d51109aeb9fcd1": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/44-mozeme-verit-bohu", "expiry": 1729578966 }, "a421f72d8ecaa634bc9bb9c5784e4fc0989d3df8": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/51-sluziaci-kral", "expiry": 1729578966 }, "849e30ce961fb543503006d414201dcf34e457bf": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/55-prave-krestanstvo-je-boj", "expiry": 1729578966 }, "ac6c3e8b2b2aadb6084e5fd08f3118298f8f0cd6": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/56-prave-krestanstvo-nico-stoji", "expiry": 1729578966 }, "7cfe7a15aa99a6f95f145ad357d7e169d7e92087": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/60-co-ked-neviem-odpustit-sam-sebe", "expiry": 1729578966 }, "0e2dbef77b19a7d825d998701898dac17cb60a27": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/79-viera", "expiry": 1729578966 }, "fd0b806dc663827fbf8cc91209b9c723e3ba9c9d": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/85-bez-teba-niet-neba", "expiry": 1729578966 }, "9c9337fc39d0ccb26817483d198975d1470f85a2": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/89-v-zmluve-s-bohom", "expiry": 1729578966 }, "14b4d3e273ef2406061abbb70c3df48d4ccac515": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/93-nepristupny-boh", "expiry": 1729578966 }, "c785715f7d2144005126d84760ff7c9c9fe80d71": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/108-stanme-sa-rybarmi-ludi", "expiry": 1729578966 }, "f498c3c30cf37abfe091a67f9ab4997d96ad3e18": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/98-uctievac", "expiry": 1729578966 }, "11b9ca2c0330e3c1bae059e3989cb352286ab32c": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/116-posledna-bitka", "expiry": 1729578966 }, "5b5f3e327301c369a2ffa0bbc4a83b0c9e2a047c": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/129-prichod-krala", "expiry": 1729578966 }, "fa766bf2e00b13ae7a6bbe62b92b17c6139cc23f": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/127-ked-boh-prehovori-ako-hospodin", "expiry": 1729578966 }, "1c5108572d6425b0f52399283ab4dd8ce4ed5ea5": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/121-na-povolani-zalezi", "expiry": 1729578966 }, "040079d32a59fdbd92720dd0269530b01b9dc5fa": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/137-kazen-lk-1-57-80", "expiry": 1729578966 }, "a30c125d1d291faa59f17e87200ffc881344c4c1": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/144-nebudte-prekvapeni", "expiry": 1729578966 }, "9dcd999bcee5c72fcb9e22f62f4c3b27a09673f1": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/148-opaste-si-bedra-svojej-mysle", "expiry": 1729578966 }, "b70a2f7b3ec3bbbaebad717491f80819cd25c418": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/177-evanjelium-ponizenia", "expiry": 1729578966 }, "d486aab5f13023649042517147d200ebba956392": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/186-radosti-a-starosti-krestana", "expiry": 1729578966 }, "14e0bb2bdb8e47e102b12185b89f6c091eb83a43": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/190-kto-sa-chvali-nech-sa-chvali-evanjeliom-v-panovi", "expiry": 1729578966 }, "99657b884888e1ae77d1d8eaa3d69c37a984b84b": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/196-zbierka-pre-chudobnych-krestanov", "expiry": 1729578966 }, "389e96d61c86607f3a21e517810e5b3203d1a38c": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/200-zarmutok-na-pokanie", "expiry": 1729578966 }, "47be5425c609274536e283419e413b1c96f545a8": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/204-slavna-sluzba-evanjelia-a-jeho-sluzobnikov", "expiry": 1729578966 }, "7f69cb09aea1db480946c1bc4c8bd5e50c463110": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/215-nechceme-davida-za-krala", "expiry": 1729578966 }, "10baefc57e31ab08dc2aae45df717ef9e64b6ce9": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/219-terajsie-utrpenie-a-buduca-nadej", "expiry": 1729578966 }, "e22e0ddd0f1c592e9806d1b5804a9e2cee77d90d": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/224-milost", "expiry": 1729578966 }, "fe8d22085020d6398d3ee9a6cac0b41d6d31b6de": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/231-neda-sa-spoliehat-na-nabozenske-zvyky", "expiry": 1729578966 }, "a5d5be7464d402375a9043c30b146500afb05175": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/242-ked-boh-hovori", "expiry": 1729578966 }, "1df0e20912c9c48b85baedb4bbf0ccd322dc9ce8": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/249-evanjelium-v-centre-zivota-12", "expiry": 1729578966 }, "3f6c33e964141fd7f94acaca7d937f7affe073d8": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/254-evanjelium-v-centre-zivota-9", "expiry": 1729578966 }, "4a55a8775d49c32823d9f244795b7f524393dfa5": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/263-pridaj-sa-aj-ty", "expiry": 1729578966 }, "d2c97518ddec504353494eaa856899e9f0cd8bde": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/268-evanjelium-v-centre-zivota-5", "expiry": 1729578966 }, "623e9b0a065bcea78b92367cd18b2719ed38cd44": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/504-evanjelium-v-centre-zivota-2", "expiry": 1729578966 }, "c1e5152d525824e0f34c6cc6892654410b1be666": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/511-necakana-bozia-spravodlivost", "expiry": 1729578966 }, "9523d6448096b49736831cf7ac43bf8191bc9cd1": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/515-zmluva-s-abrahamom", "expiry": 1729578966 }, "803387ccc76751509549e4b6173015a2273a62dc": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/522-zla-odbocka-s-dobrym-koncom", "expiry": 1729578966 }, "9ca8385ef70a08c79953a424ba6267d952d9ced0": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/527-bozie-povolanie-a-zaslubenie", "expiry": 1729578966 }, "df95cd0879eee466b7a4904aed878206b30627f5": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/535-upevni-dielo-nasich-ruk", "expiry": 1729578966 }, "c5179dd6cc46cfaad6536976ba5f04bfbca99deb": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/540-potrebujes-jezisa", "expiry": 1729578966 }, "963caaf4516a7f39059036f1c615dd7bcc7b1290": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/273-neoponuj-jezisovi", "expiry": 1729578966 }, "2d66f508e84cb3bea5bd4beae6ea4bdd24991bc7": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/286-zite-spolu-v-pokoji", "expiry": 1729578966 }, "6b2ea876de6c34cfd14b3c6f1f6879297db18003": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/299-nekompatibilny-jezis", "expiry": 1729578966 }, "35770df74fe1387d9aa974ff77fdcdd10c1264c5": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/serie/5-a-to-svetlo-vo-tme-svieti", "expiry": 1729578966 }, "d04329016f4383faa299cfe1f63ebcc24bf9db86": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/serie/7-40-dni-s-bibliou", "expiry": 1729578966 }, "a6d539b58b07e45b8b3b3ac779144558a607c814": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/serie/9-40-dni-s-markom", "expiry": 1729578966 }, "6ccdd89d0c4f59b3deb1fc73f58e1de86ad49c02": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/serie/12-co-sme-mozno-prepoculi", "expiry": 1729578966 }, "a9928f6583a0d9b2fe7aeb30a51cdcf3bfcb6851": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/serie/14-advent-2016", "expiry": 1729578966 }, "02a8ed4b7eb4ca78c30f9e33ea09748111293093": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/serie/15-exodus-19-40-boh-ktory-zachranuje", "expiry": 1729578966 }, "a78f138e2994d08a3a37a04b7225a4f316ac4cfa": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/serie/17-zaklady-uctievac-sluzobnik-student-misionar", "expiry": 1729578966 }, "d9a738a8c43327672953782dce96aa9d6485844c": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/serie/18-exodus-13-18-boh-ktory-zachranuje", "expiry": 1729578966 }, "957a8f36e34251f9f42c7399fb21372a8b1c69ca": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/serie/20-cirkev-ktora-je-fit", "expiry": 1729578966 }, "0c382390f325f1b3dcd3a67139aab364d913f0eb": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/serie/21-exodus-1-12-boh-ktory-zachranuje", "expiry": 1729578966 }, "7f4febe71e96704283574f8267ac449bdfc921d1": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/serie/22-ocakavanie-najlepsieho", "expiry": 1729578966 }, "dc9f3ad7d89bbef2c8093fd2c9fa906a6ea8bb56": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/serie/23-cudzincom-vo-svojom-meste", "expiry": 1729578966 }, "083ee61bbf84c80d09d32a2cf6b715f67f5b731d": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/serie/26-autenticky-zivot", "expiry": 1729578966 }, "67644134da9d39942d8a079365d952ca827a55a4": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/serie/27-2-korintanom", "expiry": 1729578966 }, "c05c056286ff6bcd2072820073efeeb19223e0f5": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/serie/29-amos", "expiry": 1729578966 }, "6f89850e41650dff06163d91fc5826ec77fa40b2": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/serie/30-evanjelium-v-centre-zivota", "expiry": 1729578966 }, "b44a35334c9b14a8b0c7cf95577e5c35a5d5dda1": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/serie/32-ester", "expiry": 1729578966 }, "72eecf8d95a790adc9f713d35ec8d1df5464ab25": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/serie/34-misijny-advent", "expiry": 1729578966 }, "c87f8df73eec20f37eefad5cbf2eb3f8b265f85b": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/serie/36-daniel", "expiry": 1729578966 }, "54f5b95fe3a2bfa42673d1cca2bf1b9c55cb98ac": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/serie/41-vedenie", "expiry": 1729578966 }, "6791dbc85cde054ef718132f0c14311f59b1f879": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/serie/42-postavy-adventu", "expiry": 1729578966 }, "783fba47fa7f5a6fe6c43ab5a2c77f7df35cafe0": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/serie/43-list-milovanym", "expiry": 1729578967 }, "a0226bbb0c8c78451eb1207bdd6201521e0183b7": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/serie/45-zalmy-na-cestu", "expiry": 1729578968 }, "2aa86ba91b1ed80c518c6651ae9c9f9d705f68f1": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/serie/51-aby-ste-uverili", "expiry": 1729578967 }, "518b882954e870646abcd1c1a4ea776d4ccd907b": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/serie/52-evanjelium-dobra-sprava-pre-nedokonalych-ludi-o-dokonalom-diele", "expiry": 1729578966 }, "1ea0e420832974401d9ec4278e9b2698949c5844": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/speaker/10-daniel-ban", "expiry": 1729578966 }, "cdd1a1c1a12cd2467350652ceace4414f4c7c118": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/612-povolanie-v-zivote-nehemiasa", "expiry": 1729578966 }, "30d55a7730a66208f4617dc0652d2958b27d2524": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/30-sest-dni-budes-pracovat-a-siedmy-oddychovat", "expiry": 1729578966 }, "d3cbb6b39b1414a135e468494ce1d67aa21cd0b4": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/speaker/75-bohus-vasil", "expiry": 1729578966 }, "222c6f573637094184133800d0193f06f2879f01": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/593-stoji-to-zato", "expiry": 1729578966 }, "86d14debda2920db19d3497c3a7b809b87343f21": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/speaker/6-slavo-poloha", "expiry": 1729578967 }, "d9ff496e8b456e31f149b4868a203f0abfc7babf": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/662-aby-ste-uverili", "expiry": 1729578967 }, "df14b76471ffb567fe42c61829651b7219078420": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/660-jezis-je-cesta-duch-sprievodca", "expiry": 1729578967 }, "5dd90a4ffac581f0cda779037407902c8f0ef4da": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/657-je-boh-dobry", "expiry": 1729578967 }, "56893d142e9438db94564b31ac2c356f61fecf9c": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/655-po-mne-potopa-ale-co-po-potope", "expiry": 1729578967 }, "17e821b06f5c4a4ad63d71985ac9e86892463a0f": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/654-vytrvala-modlitba", "expiry": 1729578967 }, "445e08e4585c7902148e2afb3c607b240a002815": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/651-4-dolezite-rady-pre-zivot", "expiry": 1729578967 }, "fefb250172d17c04797f6896bff2f3f4854e475c": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/647-sexualna-cistota-ako-a-preco", "expiry": 1729578967 }, "0f0e1cb2a3a11566a9259f39265b31cbd08d132a": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/643-som-vyvoleny-vyvolena", "expiry": 1729578967 }, "9d999059fb705926fb73a0686c6dc1d92419aa33": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/606-nech-sa-nestane-tvoja-vola-mojzisova-odvazna-modlitba", "expiry": 1729578967 }, "b992e652ad8f3c653dede91e693d2913a1622ac4": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/11-cirkev-otvorena-pre-svaeteho-ducha-tak-aby-ho-bolo-vidno", "expiry": 1729578967 }, "71f5d7cedff6947aca37238ec8144d8793b22ed8": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/384-skazenost-ludstva", "expiry": 1729578967 }, "f4ff17418935e93570a3a4f422908d7b780f2a20": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/serie/3-otvorena-cirkev", "expiry": 1729578967 }, "ae24483f84c5789813ce59147060ed07e365cf67": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/638-mistr-obnovy", "expiry": 1729578968 }, "7c0e41353d3d6b1fe9e750b07d120be0b67cb5f6": { "link": "http://cblv.sk/index.php/data/kazne-v-mp3/sermon/585-srdce-cirkvi", "expiry": 1729578969 } } } } }
SELECT `data`
FROM `xtldo_session`
WHERE `session_id` = X'3365383036323837316533316264353137626461356161363835613061323462'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | xtldo_session | const | PRIMARY | PRIMARY | 194 | const | 1 |
Status | Duration |
---|---|
Starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.07 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.01 ms |
Preparing | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.03 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.01 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | Volacia funkcia | Súbor a číslo riadku |
---|---|---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 |
14 | JSessionStorageDatabase->read() | Rovnaké, ako volanie o riadok nižšie. |
13 | session_start() | JROOT/libraries/joomla/session/handler/native.php:260 |
12 | JSessionHandlerNative->doSessionStart() | JROOT/libraries/joomla/session/handler/native.php:50 |
11 | JSessionHandlerNative->start() | JROOT/libraries/joomla/session/handler/joomla.php:88 |
10 | JSessionHandlerJoomla->start() | JROOT/libraries/src/Session/Session.php:660 |
9 | Joomla\CMS\Session\Session->_start() | JROOT/libraries/src/Session/Session.php:620 |
8 | Joomla\CMS\Session\Session->start() | JROOT/libraries/src/Session/Session.php:498 |
7 | Joomla\CMS\Session\Session->get() | JROOT/libraries/src/Session/Session.php:455 |
6 | Joomla\CMS\Session\Session->isNew() | JROOT/libraries/src/Application/CMSApplication.php:854 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:414 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `xtldo_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | xtldo_extensions | ref | extension | extension | 82 | const | 43 | Using index condition; Using where |
Status | Duration |
---|---|
Starting | 0.03 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.04 ms |
Preparing | 0.02 ms |
Executing | 0.00 ms |
Sending data | 0.12 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | Volacia funkcia | Súbor a číslo riadku |
---|---|---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Component/ComponentHelper.php:445 |
10 | Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() | Rovnaké, ako volanie o riadok nižšie. |
9 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
8 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Component/ComponentHelper.php:453 |
7 | Joomla\CMS\Component\ComponentHelper::load() | JROOT/libraries/src/Component/ComponentHelper.php:519 |
6 | Joomla\CMS\Component\ComponentHelper::getComponents() | JROOT/libraries/src/Component/ComponentHelper.php:44 |
5 | Joomla\CMS\Component\ComponentHelper::getComponent() | JROOT/libraries/src/Component/ComponentHelper.php:103 |
4 | Joomla\CMS\Component\ComponentHelper::getParams() | JROOT/libraries/src/Application/SiteApplication.php:594 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id, rules
FROM `xtldo_viewlevels`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | xtldo_viewlevels | ALL | NULL | NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX | NULL | NULL | 5 |
Status | Duration |
---|---|
Starting | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.03 ms |
Optimizing | 0.01 ms |
Statistics | 0.01 ms |
Preparing | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Volacia funkcia | Súbor a číslo riadku |
---|---|---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Access/Access.php:1063 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT b.id
FROM xtldo_usergroups AS a
LEFT JOIN xtldo_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | b | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 2 | Using where; Using index |
Status | Duration |
---|---|
Starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.04 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.00 ms |
Preparing | 0.02 ms |
Executing | 0.00 ms |
Sending data | 0.02 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Volacia funkcia | Súbor a číslo riadku |
---|---|---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
10 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:980 |
9 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/Access/Access.php:1095 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM xtldo_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | xtldo_extensions | ALL | extension | NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX | NULL | NULL | 222 | Using where; Pomocou filesort |
Status | Duration |
---|---|
Starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.02 ms |
Preparing | 0.01 ms |
Sorting result | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.01 ms |
Creating sort index | 0.28 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Volacia funkcia | Súbor a číslo riadku |
---|---|---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:351 |
9 | Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() | Rovnaké, ako volanie o riadok nižšie. |
8 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
7 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Plugin/PluginHelper.php:356 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT template
FROM xtldo_template_styles as s
WHERE s.client_id = 0
AND s.home = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | s | ALL | idx_client_id,idx_client_id_home | NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX | NULL | NULL | 20 | Using where |
Status | Duration |
---|---|
Starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.03 ms |
Preparing | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.03 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Volacia funkcia | Súbor a číslo riadku |
---|---|---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
13 | JDatabaseDriver->loadResult() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 |
12 | RokCommon_PlatformInfo_Joomla->getDefaultTemplate() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105 |
11 | RokCommon_PlatformInfo_Joomla->setPlatformParameters() | JROOT/libraries/rokcommon/RokCommon/Service.php:71 |
10 | RokCommon_Service::getContainer() | JROOT/libraries/rokcommon/include.php:38 |
9 | require_once JROOT/libraries/rokcommon/include.php | JROOT/plugins/system/rokcommon/rokcommon.php:95 |
8 | plgSystemRokCommon->loadCommonLib() | JROOT/plugins/system/rokcommon/rokcommon.php:53 |
7 | plgSystemRokCommon->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:695 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT template
FROM xtldo_template_styles as s
WHERE s.client_id = 0
AND s.home = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | s | ALL | idx_client_id,idx_client_id_home | NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX | NULL | NULL | 20 | Using where |
Status | Duration |
---|---|
Starting | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.02 ms |
Preparing | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.02 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.01 ms |
Reset for next command | 0.00 ms |
# | Volacia funkcia | Súbor a číslo riadku |
---|---|---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
14 | JDatabaseDriver->loadResult() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 |
13 | RokCommon_PlatformInfo_Joomla->getDefaultTemplate() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67 |
12 | RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106 |
11 | RokCommon_PlatformInfo_Joomla->setPlatformParameters() | JROOT/libraries/rokcommon/RokCommon/Service.php:71 |
10 | RokCommon_Service::getContainer() | JROOT/libraries/rokcommon/include.php:38 |
9 | require_once JROOT/libraries/rokcommon/include.php | JROOT/plugins/system/rokcommon/rokcommon.php:95 |
8 | plgSystemRokCommon->loadCommonLib() | JROOT/plugins/system/rokcommon/rokcommon.php:53 |
7 | plgSystemRokCommon->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:695 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT extension, file, type
FROM xtldo_rokcommon_configs
ORDER BY priority
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | xtldo_rokcommon_configs | ALL | NULL | NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX | NULL | NULL | 4 | Pomocou filesort |
Status | Duration |
---|---|
Starting | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.01 ms |
Preparing | 0.01 ms |
Sorting result | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.01 ms |
Creating sort index | 0.03 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.01 ms |
Reset for next command | 0.00 ms |
# | Volacia funkcia | Súbor a číslo riadku |
---|---|---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
9 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rokcommon/rokcommon.php:131 |
8 | plgSystemRokCommon->processRegisteredConfigs() | JROOT/plugins/system/rokcommon/rokcommon.php:75 |
7 | plgSystemRokCommon->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:695 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SHOW FULL COLUMNS
FROM `xtldo_extensions`
Status | Duration |
---|---|
Starting | 0.04 ms |
checking permissions | 0.01 ms |
closing tables | 0.00 ms |
checking permissions | 0.01 ms |
Opening tables | 0.12 ms |
After opening tables | 0.01 ms |
System lock | 0.02 ms |
table lock | 0.01 ms |
init | 0.01 ms |
Optimizing | 0.02 ms |
Statistics | 0.01 ms |
Preparing | 0.01 ms |
Executing | 0.01 ms |
Filling schema table | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
checking permissions | 0.07 ms |
closing tables | 0.01 ms |
checking permissions | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.04 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Removing tmp table | 0.03 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Volacia funkcia | Súbor a číslo riadku |
---|---|---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
13 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:253 |
12 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:172 |
11 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/src/Table/Extension.php:32 |
10 | Joomla\CMS\Table\Extension->__construct() | JROOT/libraries/src/Table/Table.php:320 |
9 | Joomla\CMS\Table\Table::getInstance() | JROOT/plugins/system/roksprocket/roksprocket.php:45 |
8 | plgSystemRokSprocket->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:696 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `extension_id`
FROM `xtldo_extensions`
WHERE type = 'component'
AND element = 'com_roksprocket'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | xtldo_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using where; Using index |
Status | Duration |
---|---|
Starting | 0.04 ms |
checking permissions | 0.02 ms |
Opening tables | 0.01 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.04 ms |
Preparing | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.01 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Volacia funkcia | Súbor a číslo riadku |
---|---|---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
10 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Table/Extension.php:124 |
9 | Joomla\CMS\Table\Extension->find() | JROOT/plugins/system/roksprocket/roksprocket.php:47 |
8 | plgSystemRokSprocket->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:696 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM xtldo_extensions
WHERE `extension_id` = '10012'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | xtldo_extensions | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.04 ms |
init | 0.03 ms |
Optimizing | 0.01 ms |
Statistics | 0.02 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.00 ms |
Preparing | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.01 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Volacia funkcia | Súbor a číslo riadku |
---|---|---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
10 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:739 |
9 | Joomla\CMS\Table\Table->load() | JROOT/plugins/system/roksprocket/roksprocket.php:54 |
8 | plgSystemRokSprocket->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:696 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `extension_id`
FROM `xtldo_extensions`
WHERE type = 'module'
AND element = 'mod_roksprocket'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | xtldo_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using where; Using index |
Status | Duration |
---|---|
Starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.03 ms |
Preparing | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.01 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.01 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.01 ms |
Reset for next command | 0.00 ms |
# | Volacia funkcia | Súbor a číslo riadku |
---|---|---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
10 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Table/Extension.php:124 |
9 | Joomla\CMS\Table\Extension->find() | JROOT/plugins/system/roksprocket/roksprocket.php:70 |
8 | plgSystemRokSprocket->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:696 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM xtldo_extensions
WHERE `extension_id` = '10012'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | xtldo_extensions | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.02 ms |
Preparing | 0.00 ms |
Unlocking tables | 0.00 ms |
Preparing | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.01 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Volacia funkcia | Súbor a číslo riadku |
---|---|---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
10 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:739 |
9 | Joomla\CMS\Table\Table->load() | JROOT/plugins/system/roksprocket/roksprocket.php:76 |
8 | plgSystemRokSprocket->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:696 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, 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,e.element as component
FROM xtldo_menu AS m
LEFT JOIN xtldo_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 82 | Using index condition; Using where; Pomocou filesort |
1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | db13483xjom36.m.component_id | 1 | Using where |
Status | Duration |
---|---|
Starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.04 ms |
Preparing | 0.02 ms |
Sorting result | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.01 ms |
Creating sort index | 0.38 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.04 ms |
Reset for next command | 0.01 ms |
# | Volacia funkcia | Súbor a číslo riadku |
---|---|---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
17 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | Rovnaké, ako volanie o riadok nižšie. |
16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
14 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:78 |
13 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
12 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:142 |
11 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:445 |
10 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
9 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Router/SiteRouter.php:65 |
8 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT/libraries/src/Router/Router.php:189 |
7 | Joomla\CMS\Router\Router::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:561 |
6 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 |
5 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/libraries/src/Application/CMSApplication.php:1169 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id, home, template, s.params
FROM xtldo_template_styles as s
LEFT JOIN xtldo_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
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | extension | 82 | const | 5 | Using index condition; Using where |
1 | SIMPLE | s | ref | idx_template,idx_client_id,idx_client_id_home | idx_template | 202 | db13483xjom36.e.element | 2 | Using index condition; Using where |
Status | Duration |
---|---|
Starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.05 ms |
Preparing | 0.02 ms |
Executing | 0.00 ms |
Sending data | 0.06 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Volacia funkcia | Súbor a číslo riadku |
---|---|---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:486 |
10 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/plugins/system/gantry5/gantry5.php:257 |
9 | plgSystemGantry5->onAfterRouteSite() | JROOT/plugins/system/gantry5/gantry5.php:108 |
8 | plgSystemGantry5->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1218 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT s.id, s.template, s.home, s.title AS long_title, s.params
FROM xtldo_template_styles AS s
WHERE s.client_id = 0
AND s.template = 'rt_ethereal'
ORDER BY s.id
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | s | index | idx_template,idx_client_id,idx_client_id_home | PRIMARY | 4 | NULL | 20 | Using where |
Status | Duration |
---|---|
Starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.03 ms |
Preparing | 0.01 ms |
Sorting result | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.03 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Volacia funkcia | Súbor a číslo riadku |
---|---|---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69 |
14 | Gantry\Joomla\StyleHelper::loadStyles() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Assignments.php:63 |
13 | Gantry\Framework\Assignments->loadAssignments() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Assignments/AbstractAssignments.php:301 |
12 | Gantry\Component\Assignments\AbstractAssignments->init() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Assignments/AbstractAssignments.php:99 |
11 | Gantry\Component\Assignments\AbstractAssignments->scores() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Assignments/AbstractAssignments.php:86 |
10 | Gantry\Component\Assignments\AbstractAssignments->select() | JROOT/plugins/system/gantry5/gantry5.php:315 |
9 | plgSystemGantry5->onAfterRouteSite() | JROOT/plugins/system/gantry5/gantry5.php:108 |
8 | plgSystemGantry5->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1218 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM xtldo_rokcandy
WHERE published=1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | xtldo_rokcandy | ALL | NULL | NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX | NULL | NULL | 8 | Using where |
Status | Duration |
---|---|
Starting | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.01 ms |
Preparing | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.04 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | Volacia funkcia | Súbor a číslo riadku |
---|---|---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:27 |
13 | RokCandyHelper::getUserMacros() | Rovnaké, ako volanie o riadok nižšie. |
12 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
11 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
10 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:17 |
9 | RokCandyHelper::getMacros() | JROOT/plugins/system/rokcandy/rokcandy.php:28 |
8 | plgSystemRokCandy->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1218 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `xtldo_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | xtldo_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using index condition |
Status | Duration |
---|---|
Starting | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.03 ms |
Preparing | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.02 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Volacia funkcia | Súbor a číslo riadku |
---|---|---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
14 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
13 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | Rovnaké, ako volanie o riadok nižšie. |
12 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
11 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 |
10 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
9 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
8 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
7 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
6 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
5 | Joomla\CMS\Factory::getDocument() | JROOT/libraries/src/Application/WebApplication.php:1131 |
4 | Joomla\CMS\Application\WebApplication->loadDocument() | JROOT/libraries/src/Application/SiteApplication.php:133 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
UPDATE `xtldo_extensions`
SET `params` = '{\"mediaversion\":\"258c85aea91d7938246be94cfbfac9e3\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
Status | Duration |
---|---|
Starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init for update | 0.04 ms |
Updating | 0.03 ms |
End of update loop | 0.02 ms |
Query end | 0.00 ms |
Commit | 0.06 ms |
Writing to binlog | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.00 ms |
Updating status | 0.01 ms |
Reset for next command | 0.00 ms |
# | Volacia funkcia | Súbor a číslo riadku |
---|---|---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
9 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
8 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
7 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
6 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
5 | Joomla\CMS\Factory::getDocument() | JROOT/libraries/src/Application/WebApplication.php:1131 |
4 | Joomla\CMS\Application\WebApplication->loadDocument() | JROOT/libraries/src/Application/SiteApplication.php:133 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM xtldo_languages
WHERE published=1
ORDER BY ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | xtldo_languages | ALL | NULL | NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX | NULL | NULL | 1 | Using where; Pomocou filesort |
Status | Duration |
---|---|
Starting | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.01 ms |
Preparing | 0.01 ms |
Sorting result | 0.01 ms |
Executing | 0.01 ms |
Sending data | 0.01 ms |
Creating sort index | 0.04 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.01 ms |
Reset for next command | 0.00 ms |
# | Volacia funkcia | Súbor a číslo riadku |
---|---|---|
7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
6 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 |
5 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/libraries/src/Application/SiteApplication.php:330 |
4 | Joomla\CMS\Application\SiteApplication->getParams() | JROOT/libraries/src/Application/SiteApplication.php:138 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `id`,`name`,`rules`,`parent_id`
FROM `xtldo_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_extplorer','com_fields','com_finder','com_gantry5','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocagallery','com_plugins','com_postinstall','com_privacy','com_redirect','com_rokcandy','com_rokgallery','com_roksprocket','com_search','com_sermonspeaker','com_tags','com_templates','com_users','com_wrapper')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | xtldo_assets | range | idx_asset_name | idx_asset_name | 202 | NULL | 43 | Using index condition |
Status | Duration |
---|---|
Starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.05 ms |
Optimizing | 0.01 ms |
Statistics | 0.08 ms |
Preparing | 0.01 ms |
Executing | 0.02 ms |
Sending data | 0.27 ms |
End of update loop | 0.05 ms |
Query end | 0.01 ms |
Commit | 0.02 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | Volacia funkcia | Súbor a číslo riadku |
---|---|---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
17 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
16 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
15 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
14 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
13 | Joomla\CMS\User\User->authorise() | JROOT/components/com_sermonspeaker/models/sermon.php:103 |
12 | SermonspeakerModelSermon->getItem() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_sermonspeaker/views/sermon/view.html.php:74 |
10 | SermonspeakerViewSermon->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_sermonspeaker/controller.php:142 |
8 | SermonspeakerController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_sermonspeaker/sermonspeaker.php:37 |
6 | require_once JROOT/components/com_sermonspeaker/sermonspeaker.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT sermon.id, sermon.speaker_id, sermon.series_id, sermon.alias, sermon.catid,
CASE WHEN CHAR_LENGTH(sermon.alias) THEN CONCAT_WS(':', sermon.id, sermon.alias) ELSE sermon.id END as slug,sermon.audiofile, sermon.videofile, sermon.title, sermon.sermon_number, sermon.sermon_date, sermon.picture, sermon.checked_out, sermon.checked_out_time, sermon.sermon_time, sermon.notes, sermon.state, sermon.language, sermon.hits, sermon.addfile, sermon.addfileDesc, sermon.metakey, sermon.metadesc, sermon.custom1, sermon.custom2, sermon.created, sermon.created_by, sermon.audiofilesize, sermon.videofilesize, sermon.metadata, sermon.publish_up, sermon.publish_down,GROUP_CONCAT(script.book,"|",script.cap1,"|",script.vers1,"|",script.cap2,"|",script.vers2,"|",script.text
ORDER BY script.ordering ASC SEPARATOR "!") AS scripture,user.name AS author,c.title AS category_title, c.access AS category_access,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,speakers.title AS speaker_title, speakers.pic AS pic, speakers.state as speaker_state,speakers.intro, speakers.bio, speakers.website, speakers.catid as speaker_catid, speakers.language as speaker_language,
CASE WHEN CHAR_LENGTH(speakers.alias) THEN CONCAT_WS(':', speakers.id, speakers.alias) ELSE speakers.id END as speaker_slug,c_speaker.access AS speaker_category_access,series.title AS series_title, series.avatar, series.state as series_state, series.catid as series_catid, series.language as series_language,
CASE WHEN CHAR_LENGTH(series.alias) THEN CONCAT_WS(':', series.id, series.alias) ELSE series.id END as series_slug ,c_series.access AS series_category_access
FROM xtldo_sermon_sermons AS sermon
LEFT JOIN xtldo_sermon_scriptures AS script
ON script.sermon_id = sermon.id
LEFT JOIN xtldo_users AS user
ON user.id = sermon.created_by
LEFT JOIN xtldo_categories AS c
on c.id = sermon.catid
LEFT JOIN xtldo_sermon_speakers AS speakers
on speakers.id = sermon.speaker_id
LEFT JOIN xtldo_categories AS c_speaker
on c_speaker.id = speakers.catid
LEFT JOIN xtldo_sermon_series AS series
on series.id = sermon.series_id
LEFT JOIN xtldo_categories AS c_series
on c_series.id = series.catid
WHERE (sermon.publish_up = '0000-00-00 00:00:00' OR sermon.publish_up <= '2024-10-22 06:36:09')
AND (sermon.publish_down = '0000-00-00 00:00:00' OR sermon.publish_down >= '2024-10-22 06:36:09')
AND (sermon.speaker_id = 0 OR speakers.catid = 0 OR c_speaker.published = 1)
AND (sermon.series_id = 0 OR series.catid = 0 OR c_series.published = 1)
AND sermon.id = 585
AND sermon.state > 0
GROUP BY sermon.id
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | sermon | const | PRIMARY,idx_state,idx_speaker_id,idx_series_id | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | script | ref | idx_sermon_id | idx_sermon_id | 4 | const | 1 | |
1 | SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | c | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | speakers | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | c_speaker | eq_ref | PRIMARY | PRIMARY | 4 | db13483xjom36.speakers.catid | 1 | Using where |
1 | SIMPLE | series | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | c_series | eq_ref | PRIMARY | PRIMARY | 4 | db13483xjom36.series.catid | 1 | Using where |
Status | Duration |
---|---|
Starting | 0.20 ms |
checking permissions | 0.01 ms |
Opening tables | 0.07 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.12 ms |
Optimizing | 0.05 ms |
Statistics | 0.20 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.01 ms |
Preparing | 0.17 ms |
Executing | 0.01 ms |
Sending data | 0.14 ms |
End of update loop | 0.02 ms |
Removing tmp table | 0.04 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.04 ms |
Query end | 0.01 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.05 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | Volacia funkcia | Súbor a číslo riadku |
---|---|---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
13 | JDatabaseDriver->loadObject() | JROOT/components/com_sermonspeaker/models/sermon.php:143 |
12 | SermonspeakerModelSermon->getItem() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_sermonspeaker/views/sermon/view.html.php:74 |
10 | SermonspeakerViewSermon->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_sermonspeaker/controller.php:142 |
8 | SermonspeakerController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_sermonspeaker/sermonspeaker.php:37 |
6 | require_once JROOT/components/com_sermonspeaker/sermonspeaker.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `m`.`tag_id`,`t`.*
FROM `xtldo_contentitem_tag_map` AS m
INNER JOIN `xtldo_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_sermonspeaker.sermon'
AND `m`.`content_item_id` = 585
AND `t`.`published` = 1
AND t.access IN (1,1,5)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ALL | idx_tag_type | NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX | NULL | NULL | 6 | Using where |
1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | db13483xjom36.m.tag_id | 1 | Using where |
Status | Duration |
---|---|
Starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.06 ms |
Preparing | 0.02 ms |
Executing | 0.02 ms |
Sending data | 0.04 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Volacia funkcia | Súbor a číslo riadku |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
11 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_sermonspeaker/views/sermon/view.html.php:84 |
10 | SermonspeakerViewSermon->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_sermonspeaker/controller.php:142 |
8 | SermonspeakerController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_sermonspeaker/sermonspeaker.php:37 |
6 | require_once JROOT/components/com_sermonspeaker/sermonspeaker.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SHOW FULL COLUMNS
FROM `xtldo_sermon_sermons`
Status | Duration |
---|---|
Starting | 0.05 ms |
checking permissions | 0.02 ms |
closing tables | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.10 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.01 ms |
Preparing | 0.01 ms |
Executing | 0.00 ms |
Filling schema table | 0.02 ms |
Opening tables | 0.01 ms |
After opening tables | 0.03 ms |
checking permissions | 0.11 ms |
closing tables | 0.01 ms |
checking permissions | 0.01 ms |
Executing | 0.01 ms |
Sending data | 0.05 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.00 ms |
Removing tmp table | 0.03 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Volacia funkcia | Súbor a číslo riadku |
---|---|---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
19 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:253 |
18 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:172 |
17 | Joomla\CMS\Table\Table->__construct() | JROOT/administrator/components/com_sermonspeaker/tables/sermon.php:23 |
16 | SermonspeakerTableSermon->__construct() | JROOT/libraries/src/Table/Table.php:320 |
15 | Joomla\CMS\Table\Table::getInstance() | JROOT/libraries/src/MVC/Factory/LegacyFactory.php:110 |
14 | Joomla\CMS\MVC\Factory\LegacyFactory->createTable() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:392 |
13 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_createTable() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:485 |
12 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getTable() | JROOT/components/com_sermonspeaker/models/sermon.php:188 |
11 | SermonspeakerModelSermon->hit() | JROOT/components/com_sermonspeaker/views/sermon/view.html.php:130 |
10 | SermonspeakerViewSermon->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_sermonspeaker/controller.php:142 |
8 | SermonspeakerController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_sermonspeaker/sermonspeaker.php:37 |
6 | require_once JROOT/components/com_sermonspeaker/sermonspeaker.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
UPDATE xtldo_sermon_sermons
SET `hits` = (`hits` + 1)
WHERE `id` = '585'
Status | Duration |
---|---|
Starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init for update | 0.03 ms |
Updating | 0.06 ms |
End of update loop | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Writing to binlog | 0.03 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.01 ms |
Waiting for query cache lock | 0.00 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Volacia funkcia | Súbor a číslo riadku |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Table/Table.php:1256 |
12 | Joomla\CMS\Table\Table->hit() | JROOT/components/com_sermonspeaker/models/sermon.php:190 |
11 | SermonspeakerModelSermon->hit() | JROOT/components/com_sermonspeaker/views/sermon/view.html.php:130 |
10 | SermonspeakerViewSermon->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_sermonspeaker/controller.php:142 |
8 | SermonspeakerController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_sermonspeaker/sermonspeaker.php:37 |
6 | require_once JROOT/components/com_sermonspeaker/sermonspeaker.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `xtldo_categories` AS `s`
INNER JOIN `xtldo_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_sermonspeaker' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 21
ORDER BY c.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | c | range | cat_idx,idx_access,idx_left_right | cat_idx | 207 | NULL | 5 | Using index condition; Using where; Pomocou filesort |
Status | Duration |
---|---|
Starting | 0.07 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.04 ms |
Optimizing | 0.02 ms |
Statistics | 0.08 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.00 ms |
Preparing | 0.02 ms |
Sorting result | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.02 ms |
Creating sort index | 0.06 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Volacia funkcia | Súbor a číslo riadku |
---|---|---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
19 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
18 | Joomla\CMS\Categories\Categories->get() | JROOT/administrator/components/com_fields/models/fields.php:203 |
17 | FieldsModelFields->getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:135 |
16 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:189 |
15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_sermonspeaker/views/sermon/view.html.php:138 |
10 | SermonspeakerViewSermon->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_sermonspeaker/controller.php:142 |
8 | SermonspeakerController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_sermonspeaker/sermonspeaker.php:37 |
6 | require_once JROOT/components/com_sermonspeaker/sermonspeaker.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM xtldo_fields AS a
LEFT JOIN `xtldo_languages` AS l
ON l.lang_code = a.language
LEFT JOIN xtldo_users AS uc
ON uc.id=a.checked_out
LEFT JOIN xtldo_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN xtldo_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN xtldo_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `xtldo_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_sermonspeaker.sermon'
AND (fc.category_id IS NULL OR fc.category_id IN (21,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | Using where; Using temporary; Pomocou filesort |
1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | db13483xjom36.a.language | 1 | Using where |
1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | db13483xjom36.a.checked_out | 1 | |
1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | db13483xjom36.a.access | 1 | Using where |
1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | db13483xjom36.a.created_user_id | 1 | Using where |
1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | db13483xjom36.a.group_id | 1 | Using where |
1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | db13483xjom36.a.id | 1 | Using where; Using index; Distinct |
Status | Duration |
---|---|
Starting | 0.07 ms |
checking permissions | 0.01 ms |
Opening tables | 0.05 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.08 ms |
Preparing | 0.03 ms |
Creating tmp table | 0.05 ms |
Sorting result | 0.01 ms |
Executing | 0.01 ms |
Sending data | 0.11 ms |
Creating sort index | 0.02 ms |
Removing tmp table | 0.02 ms |
Creating sort index | 0.01 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Volacia funkcia | Súbor a číslo riadku |
---|---|---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
17 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
16 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:189 |
15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_sermonspeaker/views/sermon/view.html.php:138 |
10 | SermonspeakerViewSermon->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_sermonspeaker/controller.php:142 |
8 | SermonspeakerController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_sermonspeaker/sermonspeaker.php:37 |
6 | require_once JROOT/components/com_sermonspeaker/sermonspeaker.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `xtldo_categories` AS `s`
INNER JOIN `xtldo_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_sermonspeaker' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 21
ORDER BY c.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | c | range | cat_idx,idx_access,idx_left_right | cat_idx | 207 | NULL | 5 | Using index condition; Using where; Pomocou filesort |
Status | Duration |
---|---|
Starting | 0.11 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.04 ms |
Optimizing | 0.02 ms |
Statistics | 0.07 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.00 ms |
Preparing | 0.02 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.01 ms |
Creating sort index | 0.09 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Volacia funkcia | Súbor a číslo riadku |
---|---|---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
16 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
15 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_sermonspeaker/helpers/route.php:105 |
14 | SermonspeakerHelperRoute::getSermonRoute() | JROOT/components/com_sermonspeaker/views/sermon/tmpl/content.php:36 |
13 | include JROOT/components/com_sermonspeaker/views/sermon/tmpl/content.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
12 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
11 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_sermonspeaker/views/sermon/view.html.php:160 |
10 | SermonspeakerViewSermon->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_sermonspeaker/controller.php:142 |
8 | SermonspeakerController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_sermonspeaker/sermonspeaker.php:37 |
6 | require_once JROOT/components/com_sermonspeaker/sermonspeaker.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `xtldo_categories` AS `s`
INNER JOIN `xtldo_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_sermonspeaker' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 21
ORDER BY c.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | c | range | cat_idx,idx_access,idx_left_right | cat_idx | 207 | NULL | 5 | Using index condition; Using where; Pomocou filesort |
Status | Duration |
---|---|
Starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.06 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.01 ms |
Preparing | 0.02 ms |
Sorting result | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.01 ms |
Creating sort index | 0.05 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Volacia funkcia | Súbor a číslo riadku |
---|---|---|
24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
23 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
22 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
21 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_sermonspeaker/helpers/route.php:337 |
20 | SermonspeakerHelperRoute::getSpeakerRoute() | JROOT/components/com_sermonspeaker/layouts/titles/speaker/modal.php:13 |
19 | include JROOT/components/com_sermonspeaker/layouts/titles/speaker/modal.php | JROOT/libraries/src/Layout/FileLayout.php:125 |
18 | Joomla\CMS\Layout\FileLayout->render() | JROOT/libraries/src/Layout/FileLayout.php:665 |
17 | Joomla\CMS\Layout\FileLayout->sublayout() | JROOT/components/com_sermonspeaker/layouts/titles/speaker.php:36 |
16 | include JROOT/components/com_sermonspeaker/layouts/titles/speaker.php | JROOT/libraries/src/Layout/FileLayout.php:125 |
15 | Joomla\CMS\Layout\FileLayout->render() | JROOT/libraries/src/Layout/LayoutHelper.php:73 |
14 | Joomla\CMS\Layout\LayoutHelper::render() | JROOT/components/com_sermonspeaker/views/sermon/tmpl/content.php:42 |
13 | include JROOT/components/com_sermonspeaker/views/sermon/tmpl/content.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
12 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
11 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_sermonspeaker/views/sermon/view.html.php:160 |
10 | SermonspeakerViewSermon->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_sermonspeaker/controller.php:142 |
8 | SermonspeakerController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_sermonspeaker/sermonspeaker.php:37 |
6 | require_once JROOT/components/com_sermonspeaker/sermonspeaker.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM xtldo_fields AS a
LEFT JOIN `xtldo_languages` AS l
ON l.lang_code = a.language
LEFT JOIN xtldo_users AS uc
ON uc.id=a.checked_out
LEFT JOIN xtldo_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN xtldo_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN xtldo_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_sermonspeaker.intro'
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | Using where; Using temporary; Pomocou filesort |
1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | db13483xjom36.a.language | 1 | Using where |
1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | db13483xjom36.a.checked_out | 1 | |
1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | db13483xjom36.a.access | 1 | Using where |
1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | db13483xjom36.a.created_user_id | 1 | Using where |
1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | db13483xjom36.a.group_id | 1 | Using where |
Status | Duration |
---|---|
Starting | 0.10 ms |
checking permissions | 0.01 ms |
Opening tables | 0.05 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.04 ms |
Optimizing | 0.02 ms |
Statistics | 0.07 ms |
Preparing | 0.02 ms |
Creating tmp table | 0.04 ms |
Sorting result | 0.01 ms |
Executing | 0.01 ms |
Sending data | 0.11 ms |
Creating sort index | 0.02 ms |
Removing tmp table | 0.02 ms |
Creating sort index | 0.01 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Volacia funkcia | Súbor a číslo riadku |
---|---|---|
32 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
31 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
30 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
29 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:189 |
28 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
27 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
26 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
25 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
24 | JEventDispatcher->trigger() | JROOT/libraries/cms/html/content.php:41 |
23 | JHtmlContent::prepare() | Rovnaké, ako volanie o riadok nižšie. |
22 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
21 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
20 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/components/com_sermonspeaker/layouts/titles/speaker/modal.php:28 |
19 | include JROOT/components/com_sermonspeaker/layouts/titles/speaker/modal.php | JROOT/libraries/src/Layout/FileLayout.php:125 |
18 | Joomla\CMS\Layout\FileLayout->render() | JROOT/libraries/src/Layout/FileLayout.php:665 |
17 | Joomla\CMS\Layout\FileLayout->sublayout() | JROOT/components/com_sermonspeaker/layouts/titles/speaker.php:36 |
16 | include JROOT/components/com_sermonspeaker/layouts/titles/speaker.php | JROOT/libraries/src/Layout/FileLayout.php:125 |
15 | Joomla\CMS\Layout\FileLayout->render() | JROOT/libraries/src/Layout/LayoutHelper.php:73 |
14 | Joomla\CMS\Layout\LayoutHelper::render() | JROOT/components/com_sermonspeaker/views/sermon/tmpl/content.php:42 |
13 | include JROOT/components/com_sermonspeaker/views/sermon/tmpl/content.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
12 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
11 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_sermonspeaker/views/sermon/view.html.php:160 |
10 | SermonspeakerViewSermon->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_sermonspeaker/controller.php:142 |
8 | SermonspeakerController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_sermonspeaker/sermonspeaker.php:37 |
6 | require_once JROOT/components/com_sermonspeaker/sermonspeaker.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM xtldo_fields AS a
LEFT JOIN `xtldo_languages` AS l
ON l.lang_code = a.language
LEFT JOIN xtldo_users AS uc
ON uc.id=a.checked_out
LEFT JOIN xtldo_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN xtldo_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN xtldo_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_sermonspeaker.bio'
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | Using where; Using temporary; Pomocou filesort |
1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | db13483xjom36.a.language | 1 | Using where |
1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | db13483xjom36.a.checked_out | 1 | |
1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | db13483xjom36.a.access | 1 | Using where |
1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | db13483xjom36.a.created_user_id | 1 | Using where |
1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | db13483xjom36.a.group_id | 1 | Using where |
Status | Duration |
---|---|
Starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.07 ms |
Preparing | 0.02 ms |
Creating tmp table | 0.03 ms |
Sorting result | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.10 ms |
Creating sort index | 0.02 ms |
Removing tmp table | 0.02 ms |
Creating sort index | 0.01 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Query end | 0.03 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Volacia funkcia | Súbor a číslo riadku |
---|---|---|
32 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
31 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
30 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
29 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:189 |
28 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
27 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
26 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
25 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
24 | JEventDispatcher->trigger() | JROOT/libraries/cms/html/content.php:41 |
23 | JHtmlContent::prepare() | Rovnaké, ako volanie o riadok nižšie. |
22 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
21 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:111 |
20 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/components/com_sermonspeaker/layouts/titles/speaker/modal.php:33 |
19 | include JROOT/components/com_sermonspeaker/layouts/titles/speaker/modal.php | JROOT/libraries/src/Layout/FileLayout.php:125 |
18 | Joomla\CMS\Layout\FileLayout->render() | JROOT/libraries/src/Layout/FileLayout.php:665 |
17 | Joomla\CMS\Layout\FileLayout->sublayout() | JROOT/components/com_sermonspeaker/layouts/titles/speaker.php:36 |
16 | include JROOT/components/com_sermonspeaker/layouts/titles/speaker.php | JROOT/libraries/src/Layout/FileLayout.php:125 |
15 | Joomla\CMS\Layout\FileLayout->render() | JROOT/libraries/src/Layout/LayoutHelper.php:73 |
14 | Joomla\CMS\Layout\LayoutHelper::render() | JROOT/components/com_sermonspeaker/views/sermon/tmpl/content.php:42 |
13 | include JROOT/components/com_sermonspeaker/views/sermon/tmpl/content.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
12 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
11 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_sermonspeaker/views/sermon/view.html.php:160 |
10 | SermonspeakerViewSermon->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_sermonspeaker/controller.php:142 |
8 | SermonspeakerController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_sermonspeaker/sermonspeaker.php:37 |
6 | require_once JROOT/components/com_sermonspeaker/sermonspeaker.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT alias
FROM xtldo_sermon_sermons
WHERE id = 585
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | xtldo_sermon_sermons | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.03 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.01 ms |
Preparing | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.01 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.01 ms |
Reset for next command | 0.00 ms |
# | Volacia funkcia | Súbor a číslo riadku |
---|---|---|
22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
21 | JDatabaseDriver->loadResult() | JROOT/components/com_sermonspeaker/router.php:116 |
20 | SermonspeakerRouter->build() | JROOT/libraries/src/Router/SiteRouter.php:532 |
19 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:502 |
18 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
17 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
16 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
15 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
14 | Joomla\CMS\Router\Route::_() | JROOT/components/com_sermonspeaker/views/sermon/tmpl/content.php:57 |
13 | include JROOT/components/com_sermonspeaker/views/sermon/tmpl/content.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
12 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
11 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_sermonspeaker/views/sermon/view.html.php:160 |
10 | SermonspeakerViewSermon->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_sermonspeaker/controller.php:142 |
8 | SermonspeakerController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_sermonspeaker/sermonspeaker.php:37 |
6 | require_once JROOT/components/com_sermonspeaker/sermonspeaker.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `xtldo_categories` AS `s`
INNER JOIN `xtldo_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_sermonspeaker' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 21
ORDER BY c.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | c | range | cat_idx,idx_access,idx_left_right | cat_idx | 207 | NULL | 5 | Using index condition; Using where; Pomocou filesort |
Status | Duration |
---|---|
Starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.06 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.00 ms |
Preparing | 0.02 ms |
Sorting result | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.01 ms |
Creating sort index | 0.06 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Volacia funkcia | Súbor a číslo riadku |
---|---|---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
16 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
15 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_sermonspeaker/helpers/route.php:221 |
14 | SermonspeakerHelperRoute::getSerieRoute() | JROOT/components/com_sermonspeaker/views/sermon/tmpl/content.php:112 |
13 | include JROOT/components/com_sermonspeaker/views/sermon/tmpl/content.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
12 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
11 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_sermonspeaker/views/sermon/view.html.php:160 |
10 | SermonspeakerViewSermon->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_sermonspeaker/controller.php:142 |
8 | SermonspeakerController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_sermonspeaker/sermonspeaker.php:37 |
6 | require_once JROOT/components/com_sermonspeaker/sermonspeaker.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM xtldo_fields AS a
LEFT JOIN `xtldo_languages` AS l
ON l.lang_code = a.language
LEFT JOIN xtldo_users AS uc
ON uc.id=a.checked_out
LEFT JOIN xtldo_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN xtldo_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN xtldo_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_sermonspeaker.scripture'
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | Using where; Using temporary; Pomocou filesort |
1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | db13483xjom36.a.language | 1 | Using where |
1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | db13483xjom36.a.checked_out | 1 | |
1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | db13483xjom36.a.access | 1 | Using where |
1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | db13483xjom36.a.created_user_id | 1 | Using where |
1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | db13483xjom36.a.group_id | 1 | Using where |
Status | Duration |
---|---|
Starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.06 ms |
Preparing | 0.02 ms |
Creating tmp table | 0.04 ms |
Sorting result | 0.01 ms |
Executing | 0.01 ms |
Sending data | 0.09 ms |
Creating sort index | 0.02 ms |
Removing tmp table | 0.02 ms |
Creating sort index | 0.01 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Volacia funkcia | Súbor a číslo riadku |
---|---|---|
26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
25 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
24 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
23 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:189 |
22 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
21 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
20 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
19 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
18 | JEventDispatcher->trigger() | JROOT/libraries/cms/html/content.php:41 |
17 | JHtmlContent::prepare() | Rovnaké, ako volanie o riadok nižšie. |
16 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
15 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:111 |
14 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/components/com_sermonspeaker/views/sermon/tmpl/content.php:144 |
13 | include JROOT/components/com_sermonspeaker/views/sermon/tmpl/content.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
12 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
11 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_sermonspeaker/views/sermon/view.html.php:160 |
10 | SermonspeakerViewSermon->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_sermonspeaker/controller.php:142 |
8 | SermonspeakerController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_sermonspeaker/sermonspeaker.php:37 |
6 | require_once JROOT/components/com_sermonspeaker/sermonspeaker.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM xtldo_modules AS m
LEFT JOIN xtldo_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN xtldo_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.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-10-22 06:36:09')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-10-22 06:36:09')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 272 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds | published | 1 | const | 65 | Using index condition; Using where; Pomocou filesort |
1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | db13483xjom36.m.id | 1 | Using where; Using index |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | db13483xjom36.m.module,const | 1 | Using index condition; Using where |
Status | Duration |
---|---|
Starting | 0.13 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.05 ms |
Optimizing | 0.04 ms |
Statistics | 0.09 ms |
Preparing | 0.05 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.01 ms |
Creating sort index | 0.63 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | Volacia funkcia | Súbor a číslo riadku |
---|---|---|
52 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
51 | JDatabaseDriver->loadObjectList() | Rovnaké, ako volanie o riadok nižšie. |
50 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
49 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:441 |
48 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:371 |
47 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 |
46 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:341 |
45 | Gantry\Framework\Platform->displayModules() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 |
44 | Twig\Template->getAttribute() | JROOT/cache/gantry5/rt_ethereal/twig/bc/bc091b83bec43739cbafd447724d2c15f904eda0b537a2dbf070342036d34d77.php:43 |
43 | __TwigTemplate_65db642bafc915680e1d9f6c660c6ab4d374bf826fdab409a5ffc25ca83948ef->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:214 |
42 | Twig\Template->displayBlock() | JROOT/cache/gantry5/rt_ethereal/twig/34/348d7771d18062493b44be7079e5f855c8c119bd00df41c62dda3a312c36805e.php:73 |
41 | __TwigTemplate_6829363ea032e2c6a0228c9461590cac47d3f830b262826f2d7a61932aa5a256->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
40 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
39 | Twig\Template->display() | JROOT/cache/gantry5/rt_ethereal/twig/bc/bc091b83bec43739cbafd447724d2c15f904eda0b537a2dbf070342036d34d77.php:35 |
38 | __TwigTemplate_65db642bafc915680e1d9f6c660c6ab4d374bf826fdab409a5ffc25ca83948ef->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
37 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
36 | Twig\Template->display() | JROOT/cache/gantry5/rt_ethereal/twig/ca/ca0ab83118c1c80960505930d92a4355a97a1632ae10cd68d24115cf611c1d56.php:53 |
35 | __TwigTemplate_147c9bfedbea08547b067ec7613cb499edde54546256680d29804227f2c1eac7->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
34 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
33 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 |
32 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
31 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
30 | Twig\Environment->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 |
29 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825 |
28 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718 |
27 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643 |
26 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468 |
22 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:700 |
21 | Twig\Template->getAttribute() | JROOT/cache/gantry5/rt_ethereal/twig/44/443b718b4b7d10dbf10d53c7f959819051f457d219376e18b34dd2d0b94e073d.php:47 |
20 | __TwigTemplate_3d2f853656adb6b47bbce16512a5e0f1b41d3df36de5fd5b0eadf6b195d3957f->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
19 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
18 | Twig\Template->display() | JROOT/cache/gantry5/rt_ethereal/twig/26/26e7a53453c65189ccfd1903a40b6c05ed7ab4b6a9be200e9c92137f1976a5a4.php:35 |
17 | __TwigTemplate_7e912497652b5404597f403c0e9ef7203bee01fa69c45bd1792bb345ba8776f2->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
16 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
15 | Twig\Template->display() | JROOT/cache/gantry5/rt_ethereal/twig/ef/ef8e07e166046269f3dca612e18b7c1048223d8304ffc8fddcc44df12fa15fcd.php:35 |
14 | __TwigTemplate_7207b4f0928042abab84f415c8042082cbf7803c1cb8396fd0c0f2635ba6fad5->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
13 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
12 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 |
11 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
10 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
9 | Twig\Environment->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 |
8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/rt_ethereal/index.php:23 |
7 | require JROOT/templates/rt_ethereal/index.php | JROOT/libraries/src/Document/HtmlDocument.php:668 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:730 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:545 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1126 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `a`.`menutype`,`a`.`title`
FROM `xtldo_menu_types` AS `a`
WHERE `a`.`client_id` = 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | ALL | NULL | NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX | NULL | NULL | 2 | Using where |
Status | Duration |
---|---|
Starting | 0.09 ms |
checking permissions | 0.02 ms |
Opening tables | 0.02 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.01 ms |
init | 0.08 ms |
Optimizing | 0.03 ms |
Statistics | 0.02 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.04 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.06 ms |
# | Volacia funkcia | Súbor a číslo riadku |
---|---|---|
44 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
43 | JDatabaseDriver->loadAssocList() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:109 |
42 | Gantry\Framework\Menu->getMenuOptions() | JROOT/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:86 |
41 | Gantry\Framework\Menu->getMenus() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Menu/AbstractMenu.php:273 |
40 | Gantry\Component\Menu\AbstractMenu->instance() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 |
39 | Twig\Template->getAttribute() | JROOT/cache/gantry5/rt_ethereal/twig/19/19f8adc478aa2192dced0e324db5f55a9a8fabc70c8a6168f27ecd2eddfb0b65.php:32 |
38 | __TwigTemplate_6360d48ac8de69bf011b22f4e47c920e8057161103f896708fe27594201bac68->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
37 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
36 | Twig\Template->display() | JROOT/cache/gantry5/rt_ethereal/twig/58/5834446c4b95d9aceb7f7f7d2005f1e47fe1fb37f03c54edd2c13ca5c5649bfe.php:85 |
35 | __TwigTemplate_71a2058ce3af4bf86acb5d0d19acb1e7280a2b449ae4a3eae0e53ec9c958895b->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
34 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
33 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 |
32 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
31 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
30 | Twig\Environment->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 |
29 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825 |
28 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718 |
27 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643 |
26 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 |
23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468 |
22 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:700 |
21 | Twig\Template->getAttribute() | JROOT/cache/gantry5/rt_ethereal/twig/44/443b718b4b7d10dbf10d53c7f959819051f457d219376e18b34dd2d0b94e073d.php:47 |
20 | __TwigTemplate_3d2f853656adb6b47bbce16512a5e0f1b41d3df36de5fd5b0eadf6b195d3957f->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
19 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
18 | Twig\Template->display() | JROOT/cache/gantry5/rt_ethereal/twig/26/26e7a53453c65189ccfd1903a40b6c05ed7ab4b6a9be200e9c92137f1976a5a4.php:35 |
17 | __TwigTemplate_7e912497652b5404597f403c0e9ef7203bee01fa69c45bd1792bb345ba8776f2->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
16 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
15 | Twig\Template->display() | JROOT/cache/gantry5/rt_ethereal/twig/ef/ef8e07e166046269f3dca612e18b7c1048223d8304ffc8fddcc44df12fa15fcd.php:35 |
14 | __TwigTemplate_7207b4f0928042abab84f415c8042082cbf7803c1cb8396fd0c0f2635ba6fad5->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:453 |
13 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:420 |
12 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:432 |
11 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
10 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
9 | Twig\Environment->render() | JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:175 |
8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/rt_ethereal/index.php:23 |
7 | require JROOT/templates/rt_ethereal/index.php | JROOT/libraries/src/Document/HtmlDocument.php:668 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:730 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:545 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1126 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
4 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `xtldo_categories` AS `s`
INNER JOIN `xtldo_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
3 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM xtldo_fields AS a
LEFT JOIN `xtldo_languages` AS l
ON l.lang_code = a.language
LEFT JOIN xtldo_users AS uc
ON uc.id=a.checked_out
LEFT JOIN xtldo_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN xtldo_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN xtldo_fields_groups AS g
ON g.id = a.group_id
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `xtldo_extensions`
2 × SELECT template
FROM xtldo_template_styles as s
2 × SELECT `extension_id`
FROM `xtldo_extensions`
2 × SELECT *
FROM xtldo_extensions
1 × SELECT `data`
FROM `xtldo_session`
1 × SELECT id, rules
FROM `xtldo_viewlevels
1 × SELECT b.id
FROM xtldo_usergroups AS a
LEFT JOIN xtldo_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM xtldo_extensions
1 × SELECT extension, file, type
FROM xtldo_rokcommon_configs
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, 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,e.element as component
FROM xtldo_menu AS m
LEFT JOIN xtldo_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT id, home, template, s.params
FROM xtldo_template_styles as s
LEFT JOIN xtldo_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT s.id, s.template, s.home, s.title AS long_title, s.params
FROM xtldo_template_styles AS s
1 × SELECT *
FROM xtldo_rokcandy
1 × SELECT *
FROM xtldo_languages
1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `xtldo_assets`
1 × SELECT sermon.id, sermon.speaker_id, sermon.series_id, sermon.alias, sermon.catid,
CASE WHEN CHAR_LENGTH(sermon.alias) THEN CONCAT_WS(':', sermon.id, sermon.alias) ELSE sermon.id END as slug,sermon.audiofile, sermon.videofile, sermon.title, sermon.sermon_number, sermon.sermon_date, sermon.picture, sermon.checked_out, sermon.checked_out_time, sermon.sermon_time, sermon.notes, sermon.state, sermon.language, sermon.hits, sermon.addfile, sermon.addfileDesc, sermon.metakey, sermon.metadesc, sermon.custom1, sermon.custom2, sermon.created, sermon.created_by, sermon.audiofilesize, sermon.videofilesize, sermon.metadata, sermon.publish_up, sermon.publish_down,GROUP_CONCAT(script.book,"|",script.cap1,"|",script.vers1,"|",script.cap2,"|",script.vers2,"|",script.text
ORDER BY script.ordering ASC SEPARATOR "!") AS scripture,user.name AS author,c.title AS category_title, c.access AS category_access,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,speakers.title AS speaker_title, speakers.pic AS pic, speakers.state as speaker_state,speakers.intro, speakers.bio, speakers.website, speakers.catid as speaker_catid, speakers.language as speaker_language,
CASE WHEN CHAR_LENGTH(speakers.alias) THEN CONCAT_WS(':', speakers.id, speakers.alias) ELSE speakers.id END as speaker_slug,c_speaker.access AS speaker_category_access,series.title AS series_title, series.avatar, series.state as series_state, series.catid as series_catid, series.language as series_language,
CASE WHEN CHAR_LENGTH(series.alias) THEN CONCAT_WS(':', series.id, series.alias) ELSE series.id END as series_slug ,c_series.access AS series_category_access
FROM xtldo_sermon_sermons AS sermon
LEFT JOIN xtldo_sermon_scriptures AS script
ON script.sermon_id = sermon.id
LEFT JOIN xtldo_users AS user
ON user.id = sermon.created_by
LEFT JOIN xtldo_categories AS c
on c.id = sermon.catid
LEFT JOIN xtldo_sermon_speakers AS speakers
on speakers.id = sermon.speaker_id
LEFT JOIN xtldo_categories AS c_speaker
on c_speaker.id = speakers.catid
LEFT JOIN xtldo_sermon_series AS series
on series.id = sermon.series_id
LEFT JOIN xtldo_categories AS c_series
on c_series.id = series.catid
1 × SELECT `m`.`tag_id`,`t`.*
FROM `xtldo_contentitem_tag_map` AS m
INNER JOIN `xtldo_tags` AS t
ON `m`.`tag_id` = `t`.`id`
1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM xtldo_fields AS a
LEFT JOIN `xtldo_languages` AS l
ON l.lang_code = a.language
LEFT JOIN xtldo_users AS uc
ON uc.id=a.checked_out
LEFT JOIN xtldo_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN xtldo_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN xtldo_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `xtldo_fields_categories` AS fc
ON fc.field_id = a.id
1 × SELECT alias
FROM xtldo_sermon_sermons
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM xtldo_modules AS m
LEFT JOIN xtldo_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN xtldo_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT `a`.`menutype`,`a`.`title`
FROM `xtldo_menu_types` AS `a`
1 × SHOW FULL COLUMNS
FROM `xtldo_extensions
1 × UPDATE `xtldo_extensions`
SET `params` = '{\"mediaversion\":\"258c85aea91d7938246be94cfbfac9e3\"}'
1 × SHOW FULL COLUMNS
FROM `xtldo_sermon_sermons
1 × UPDATE xtldo_sermon_sermons
SET `hits` = (`hits` + 1)