Határozatok - 2020 - Szerencs Város Honlapja

SELECT @@SESSION.sql_mode;57μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy

SELECT `data`
FROM `szrncs_session`
WHERE `session_id` = ?

326μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy

SELECT `session_id`
FROM `szrncs_session`
WHERE `session_id` = :session_id LIMIT 1

74μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy

INSERT INTO `szrncs_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES 
(:session_id, :guest, :time, :user_id, :username, :client_id)

448μs944BParams/libraries/src/Session/MetadataManager.php:260Copy

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `szrncs_extensions`
WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1

253μs18.36KB/libraries/src/Component/ComponentHelper.php:399Copy

SELECT `id`,`rules`
FROM `szrncs_viewlevels`

84μs976B/libraries/src/Access/Access.php:955Copy

SELECT `b`.`id`
FROM `szrncs_usergroups` AS `a`
LEFT JOIN `szrncs_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt`
WHERE `a`.`id` = :guest

118μs1.64KBParams/libraries/src/Access/Access.php:868Copy

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM `szrncs_extensions`
WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2)
ORDER BY `ordering`

463μs20.3KBParams/libraries/src/Plugin/PluginHelper.php:294Copy

SELECT `template`
FROM `szrncs_template_styles`
WHERE `client_id` = 0 AND `home` = 1

100μs2.09KB/components/com_sppagebuilder/parser/addon-parser.php:1403Copy

SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component`
FROM `szrncs_menu` AS `m`
LEFT JOIN `szrncs_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id`
WHERE 
(
(`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND 
(`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND 
(`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2)
ORDER BY `m`.`lft`

1.05ms231.05KBParams/libraries/src/Menu/SiteMenu.php:166Copy

SELECT a.title, a.alias, a.id, a.parent_id FROM szrncs_phocadownload_categories AS a WHERE a.id = 47 ORDER BY a.ordering LIMIT 1

685μs1KB/administrator/components/com_phocadownload/libraries/phocadownload/category/category.php:175Copy

SELECT a.title, a.alias, a.id, a.parent_id FROM szrncs_phocadownload_categories AS a WHERE a.parent_id = 47 ORDER BY a.ordering

943μs1.42KB/administrator/components/com_phocadownload/libraries/phocadownload/category/category.php:184Copy

SELECT *
FROM `szrncs_template_styles`
WHERE `client_id` = 0 AND `id` = '10'

125μs49.22KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy

SELECT *
FROM `szrncs_languages`
WHERE `published` = 1
ORDER BY `ordering` ASC

121μs2.23KB/libraries/src/Language/LanguageHelper.php:142Copy

SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent`
FROM `szrncs_template_styles` AS `s`
LEFT JOIN `szrncs_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

177μs49.14KB/administrator/components/com_templates/src/Model/StyleModel.php:771Copy

SELECT cc.id, cc.title, cc.alias, cc.access as cataccess, cc.accessuserid as cataccessuserid, cc.description, cc.metakey, cc.metadesc, pc.title as parenttitle, cc.parent_id as parent_id, pc.alias as parentalias FROM szrncs_phocadownload_categories AS cc LEFT JOIN szrncs_phocadownload_categories AS pc ON pc.id = cc.parent_id WHERE  cc.id= 68 AND  cc.access IN (1,5) AND  cc.published = 1 ORDER BY cc.ordering LIMIT 1

111μs2.06KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy

SELECT  cc.id, cc.title, cc.alias, cc.access as cataccess, cc.accessuserid as cataccessuserid, COUNT(c.id) AS numdoc FROM szrncs_phocadownload_categories AS cc LEFT JOIN szrncs_phocadownload AS c ON c.catid = cc.id AND c.published = 1 AND c.textonly = 0 WHERE  cc.parent_id = 68 AND  cc.access IN (1,5) AND  cc.published = 1 GROUP BY cc.id, cc.title, cc.alias, cc.access, cc.accessuserid ORDER BY cc.ordering ASC

826μs3.61KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy

SELECT c.*, cc.id AS categoryid, cc.title AS categorytitle, cc.alias AS categoryalias, cc.access as cataccess, cc.accessuserid as cataccessuserid  FROM szrncs_phocadownload AS c LEFT JOIN szrncs_phocadownload_categories AS cc ON cc.id = c.catid LEFT JOIN szrncs_phocadownload_file_votes_statistics AS r ON r.fileid = c.id WHERE  c.catid= 68 AND ( (unaccessible_file = 1 ) OR (unaccessible_file = 0 AND c.access IN (1,5) ) ) AND ( (unaccessible_file = 1 ) OR (unaccessible_file = 0 AND cc.access IN (1,5) ) ) AND  c.published = 1 AND  c.approved = 1 AND  cc.published = 1 AND  ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2025-07-21 06:06:54' ) AND  ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-07-21 06:06:54' ) ORDER BY c.filename ASC LIMIT 50

5.48ms41.45KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy

SELECT c.id FROM szrncs_phocadownload AS c LEFT JOIN szrncs_phocadownload_categories AS cc ON cc.id = c.catid WHERE  c.catid= 68 AND ( (unaccessible_file = 1 ) OR (unaccessible_file = 0 AND c.access IN (1,5) ) ) AND ( (unaccessible_file = 1 ) OR (unaccessible_file = 0 AND cc.access IN (1,5) ) ) AND  c.published = 1 AND  c.approved = 1 AND  cc.published = 1 AND  ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2025-07-21 06:06:54' ) AND  ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-07-21 06:06:54' ) ORDER BY c.id

385μs3.82KB/libraries/src/MVC/Model/BaseDatabaseModel.php:211Copy

SELECT a.filename as filename, a.type as type, a.menulink as menulink FROM szrncs_phocadownload_styles AS a WHERE a.published = 1 ORDER BY a.type, a.ordering ASC

94μs1008B/administrator/components/com_phocadownload/libraries/phocadownload/render/renderfront.php:54Copy

SELECT * FROM szrncs_phocadownload_categories AS c WHERE c.id = 47 AND c.published = 1118μs4.25KB/components/com_phocadownload/views/category/view.html.php:429Copy

SELECT * FROM szrncs_phocadownload_categories AS c WHERE c.id = 0 AND c.published = 198μs4.23KB/components/com_phocadownload/views/category/view.html.php:429Copy

SELECT a.title, a.alias, a.id, a.parent_id FROM szrncs_phocadownload_categories AS a WHERE a.id = 68 ORDER BY a.ordering LIMIT 1

70μs1KB/administrator/components/com_phocadownload/libraries/phocadownload/category/category.php:175Copy

SELECT a.title, a.alias, a.id, a.parent_id FROM szrncs_phocadownload_categories AS a WHERE a.parent_id = 68 ORDER BY a.ordering

199μs1008B/administrator/components/com_phocadownload/libraries/phocadownload/category/category.php:184Copy

SELECT a.title, a.alias, a.id, a.parent_id FROM szrncs_phocadownload_categories AS a WHERE a.id = 47 ORDER BY a.ordering65μs1KB/administrator/components/com_phocadownload/libraries/phocadownload/category/category.php:223Copy

SELECT a.title, a.alias, a.id, a.parent_id FROM szrncs_phocadownload_categories AS a WHERE a.id = 47 ORDER BY a.ordering63μs1KB/administrator/components/com_phocadownload/libraries/phocadownload/category/category.php:223Copy

SELECT a.title, a.alias, a.id, a.parent_id FROM szrncs_phocadownload_categories AS a WHERE a.id = 47 ORDER BY a.ordering64μs1KB/administrator/components/com_phocadownload/libraries/phocadownload/category/category.php:223Copy

SELECT a.title, a.alias, a.id, a.parent_id FROM szrncs_phocadownload_categories AS a WHERE a.id = 47 ORDER BY a.ordering63μs1KB/administrator/components/com_phocadownload/libraries/phocadownload/category/category.php:223Copy

SELECT a.title, a.alias, a.id, a.parent_id FROM szrncs_phocadownload_categories AS a WHERE a.id = 47 ORDER BY a.ordering69μs1KB/administrator/components/com_phocadownload/libraries/phocadownload/category/category.php:223Copy

SELECT a.title, a.alias, a.id, a.parent_id FROM szrncs_phocadownload_categories AS a WHERE a.id = 47 ORDER BY a.ordering68μs1KB/administrator/components/com_phocadownload/libraries/phocadownload/category/category.php:223Copy

SELECT a.title, a.alias, a.id, a.parent_id FROM szrncs_phocadownload_categories AS a WHERE a.id = 47 ORDER BY a.ordering65μs12KB/administrator/components/com_phocadownload/libraries/phocadownload/category/category.php:223Copy

SELECT a.title, a.alias, a.id, a.parent_id FROM szrncs_phocadownload_categories AS a WHERE a.id = 47 ORDER BY a.ordering64μs1KB/administrator/components/com_phocadownload/libraries/phocadownload/category/category.php:223Copy

SELECT a.title, a.alias, a.id, a.parent_id FROM szrncs_phocadownload_categories AS a WHERE a.id = 47 ORDER BY a.ordering63μs1KB/administrator/components/com_phocadownload/libraries/phocadownload/category/category.php:223Copy

SELECT a.title, a.alias, a.id, a.parent_id FROM szrncs_phocadownload_categories AS a WHERE a.id = 47 ORDER BY a.ordering68μs1KB/administrator/components/com_phocadownload/libraries/phocadownload/category/category.php:223Copy

SELECT a.title, a.alias, a.id, a.parent_id FROM szrncs_phocadownload_categories AS a WHERE a.id = 47 ORDER BY a.ordering65μs1KB/administrator/components/com_phocadownload/libraries/phocadownload/category/category.php:223Copy

SELECT a.title, a.alias, a.id, a.parent_id FROM szrncs_phocadownload_categories AS a WHERE a.id = 47 ORDER BY a.ordering64μs1KB/administrator/components/com_phocadownload/libraries/phocadownload/category/category.php:223Copy

SELECT a.title, a.alias, a.id, a.parent_id FROM szrncs_phocadownload_categories AS a WHERE a.id = 47 ORDER BY a.ordering63μs1KB/administrator/components/com_phocadownload/libraries/phocadownload/category/category.php:223Copy

SELECT a.title, a.alias, a.id, a.parent_id FROM szrncs_phocadownload_categories AS a WHERE a.id = 47 ORDER BY a.ordering64μs1KB/administrator/components/com_phocadownload/libraries/phocadownload/category/category.php:223Copy

SELECT a.title, a.alias, a.id, a.parent_id FROM szrncs_phocadownload_categories AS a WHERE a.id = 47 ORDER BY a.ordering107μs1KB/administrator/components/com_phocadownload/libraries/phocadownload/category/category.php:223Copy

SELECT a.title, a.alias, a.id, a.parent_id FROM szrncs_phocadownload_categories AS a WHERE a.id = 47 ORDER BY a.ordering64μs1KB/administrator/components/com_phocadownload/libraries/phocadownload/category/category.php:223Copy

SELECT a.title, a.alias, a.id, a.parent_id FROM szrncs_phocadownload_categories AS a WHERE a.id = 47 ORDER BY a.ordering63μs1KB/administrator/components/com_phocadownload/libraries/phocadownload/category/category.php:223Copy

SELECT a.title, a.alias, a.id, a.parent_id FROM szrncs_phocadownload_categories AS a WHERE a.id = 47 ORDER BY a.ordering66μs1KB/administrator/components/com_phocadownload/libraries/phocadownload/category/category.php:223Copy

SELECT a.title, a.alias, a.id, a.parent_id FROM szrncs_phocadownload_categories AS a WHERE a.id = 47 ORDER BY a.ordering64μs1KB/administrator/components/com_phocadownload/libraries/phocadownload/category/category.php:223Copy

SELECT a.title, a.alias, a.id, a.parent_id FROM szrncs_phocadownload_categories AS a WHERE a.id = 47 ORDER BY a.ordering63μs1KB/administrator/components/com_phocadownload/libraries/phocadownload/category/category.php:223Copy

SELECT a.title, a.alias, a.id, a.parent_id FROM szrncs_phocadownload_categories AS a WHERE a.id = 47 ORDER BY a.ordering64μs1KB/administrator/components/com_phocadownload/libraries/phocadownload/category/category.php:223Copy

SELECT a.title, a.alias, a.id, a.parent_id FROM szrncs_phocadownload_categories AS a WHERE a.id = 47 ORDER BY a.ordering63μs1KB/administrator/components/com_phocadownload/libraries/phocadownload/category/category.php:223Copy

SELECT a.title, a.alias, a.id, a.parent_id FROM szrncs_phocadownload_categories AS a WHERE a.id = 47 ORDER BY a.ordering66μs1KB/administrator/components/com_phocadownload/libraries/phocadownload/category/category.php:223Copy

SELECT a.title, a.alias, a.id, a.parent_id FROM szrncs_phocadownload_categories AS a WHERE a.id = 47 ORDER BY a.ordering63μs1KB/administrator/components/com_phocadownload/libraries/phocadownload/category/category.php:223Copy

SELECT a.title, a.alias, a.id, a.parent_id FROM szrncs_phocadownload_categories AS a WHERE a.id = 47 ORDER BY a.ordering62μs1KB/administrator/components/com_phocadownload/libraries/phocadownload/category/category.php:223Copy

SELECT a.title, a.alias, a.id, a.parent_id FROM szrncs_phocadownload_categories AS a WHERE a.id = 47 ORDER BY a.ordering67μs1KB/administrator/components/com_phocadownload/libraries/phocadownload/category/category.php:223Copy

SELECT a.title, a.alias, a.id, a.parent_id FROM szrncs_phocadownload_categories AS a WHERE a.id = 47 ORDER BY a.ordering65μs1KB/administrator/components/com_phocadownload/libraries/phocadownload/category/category.php:223Copy

SELECT a.title, a.alias, a.id, a.parent_id FROM szrncs_phocadownload_categories AS a WHERE a.id = 47 ORDER BY a.ordering63μs1KB/administrator/components/com_phocadownload/libraries/phocadownload/category/category.php:223Copy

SELECT a.title, a.alias, a.id, a.parent_id FROM szrncs_phocadownload_categories AS a WHERE a.id = 47 ORDER BY a.ordering64μs9KB/administrator/components/com_phocadownload/libraries/phocadownload/category/category.php:223Copy