Юридический институт СФУ - Студенческая жизнь

В прошедшем учебном году продолжил свою деятельность научный кружок по уголовному процессу. Обновился его состав: участие в работе приняли как студенты 3-5 курсов, так и обучающиеся в магистратуре и аспирантуре ЮИ СФУ.

Подробнее...

Подробности: 02.09.14; Просмотров: 1437

Набор в команду ЮИ СФУ для конкурса им. Ф. Джессопа

Уважаемые студенты Отделения сравнительного правоведения и направления "Международные отношения" ЮИ СФУ!

Мы объявляем набор в команду ЮИ СФУ для участия в конкурсе им. Ф. Джессопа в 2014/2015 учебном году. Наша команда успешно участвует в конкурсе в течение нескольких последних лет (подробнее можно почитать здесь - http://news.sfukras.ru/taxonomy/term/224).

Подробнее...

Подробности: 01.09.14; Просмотров: 2167

Уважаемые студенты первого курса.

28.08.2014 было принято распоряжение о распределении еще 31 места в общежитиях. В настоящий момент у Юридического института осталось около 10 свободных мест. Распоряжение по оставшимся свободным местам будет принято 29.08.2014 после сверки списков свободных мест с Управлением общежитиями СФУ.

Подробнее...

Подробности: 28.08.14; Просмотров: 1341

Уважаемые студенты 1 курса

В настоящий момент принято решение о предоставлении мест в общежитиях для студентов, обладающих первоочередным правом получения жилого помещения в общежитии.

Подробнее...

Подробности: 25.08.14; Просмотров: 2497

Встреча А.В.Усса с участниками МЛПШ-2014

Студенты и преподаватели, участники Международной летней правовой школы – 2014 (МЛПШ - 2014), проводимой ЮИ СФУ, встретились с председателем Законодательного собрания Красноярского края А.В.Уссом. Александр Викторович рассказал студентам о различных направлениях своей деятельности. Много вопросов задали студенты из Германии А.В.Уссу, как заместителю председателя Комитета по мониторингу Конгресса местных и региональных властей Совета Европы (КМРВСЕ). Большая часть вопросов касались санкций, введенных ЕС против РФ, а также как эта ситуация может повлиять на экономическое развитие нашего края. Дискуссия была по острым вопросам, но очень конструктивна, что отметили обе стороны. Александр Викторович, как Президент СФУ, уделил внимание вопросам подготовки к Универсиаде – 2019 и пригласил студентов приехать еще раз, посмотреть как изменятся университет и город в 2019 году.

Подробности: 18.08.14; Просмотров: 1676

С 5 Августа ЮИ СФУ стал площадкой для проведения Международной летней правовой школы -2014( МЛПШ-2014)

Среди многих зарубежных преподавателей, участвующих в МЛПШ-2014, моим давним знакомым является Вибе Даума - лектор института международного и европейского права (The T.M.C.Asser Instituut) в Гааге. Основной темой научных разработок Вибе являются отношения ЕС с другими странами, а так же экологическое право.

Подробнее...

Подробности: 18.08.14; Просмотров: 1743

Участники МЛПШ-2014 в Арбитражном Суде Красноярского края

Участники Международной летней правовой школы – 2014 (МЛПШ-2014), проводимой ЮИ СФУ, посетили 7.08.2014 Арбитражный Суд Красноярского края. Председатель суда, д.ю.н. Д.Л.Сурков сказал, что встречи с зарубежными студентами, приезжающими в МЛПШ, стали доброй традицией, потом некоторые из студентов приезжают на учебу в ЮИ СФУ и приходят в суд уже на практику. В июне 2014 в суде проходили практику две студентки из университета Пассау (Антонина Петридес и Эмилия Зандлер).

Подробнее...

Подробности: 18.08.14; Просмотров: 1477

Команда ЮИ СФУ заняла 2 место на международном конкурсе!

На сайтах СФУ и ЮИ мы уже сообщали, что команда Юридического института СФУ в 2014 г. заняла 24-е место в крупнейшем и самом престижном международном соревновании по международному публичному праву - международном Конкурсе им. Ф. Джессопа, проводимом в форме судебного разбирательства в Международном Суде ООН. В этом Конкурсе, проходящем на английском языке, приняли участие команды более 500 вузов мира.

Подробнее...

Подробности: 27.07.14; Просмотров: 1614

«Профессия – юрист, правовая школа! Запомни все четыре слова!»

9 – 18 июля Юридический институт при активной поддержке Министерства спорта и молодежной политики Красноярского края, Краевого регионального отделения Ассоциации юристов России, отдела корпоративной культуры СФУ, Центра карьеры СФУ, Арбитражного суда Красноярского края, Адвокатской палаты Красноярского края, адвокатских образований «Арбикон», «Шпагин и партнеры», МБУ «Молодежный центр Октябрьского района», КРООС «Общественный комитет по защите прав человека» провел IV Правовую школу «Профессия-юрист»!

Подробнее...

Подробности: 25.07.14; Просмотров: 6397

Страница 48 из 79

Консоль отладки Joomla!

Application 0.001 seconds (+0.001); 0.34 MB (+0.337) - afterLoad

Application 0.027 seconds (+0.027); 1.46 MB (+1.123) - afterInitialise

Application 0.054 seconds (+0.026); 5.79 MB (+4.332) - afterRoute

Application 1.078 seconds (+1.024); 7.29 MB (+1.495) - afterDispatch

Application 1.086 seconds (+0.008); 7.45 MB (+0.166) - beforeRenderModule mod_custom (Footer)

Application 1.088 seconds (+0.002); 7.46 MB (+0.008) - afterRenderModule mod_custom (Footer)

Application 1.088 seconds (+0.001); 7.44 MB (-0.023) - beforeRenderModule mod_breadcrumbs (Навигация на сайте)

Application 1.090 seconds (+0.002); 7.45 MB (+0.015) - afterRenderModule mod_breadcrumbs (Навигация на сайте)

Application 1.090 seconds (+0.000); 7.46 MB (+0.003) - beforeRenderModule mod_vertical_dropmenu (Новое левое меню)

Application 1.172 seconds (+0.081); 9.78 MB (+2.325) - afterRenderModule mod_vertical_dropmenu (Новое левое меню)

Application 1.176 seconds (+0.004); 7.75 MB (-2.034) - beforeRenderModule mod_custom (Кнопка бесплатная юр помощь)

Application 1.176 seconds (+0.000); 7.75 MB (+0.004) - afterRenderModule mod_custom (Кнопка бесплатная юр помощь)

Application 1.179 seconds (+0.003); 7.76 MB (+0.005) - beforeRenderModule mod_newscalendar (Календарь новостей)

Application 1.207 seconds (+0.028); 7.83 MB (+0.075) - afterRenderModule mod_newscalendar (Календарь новостей)

Application 1.209 seconds (+0.002); 7.81 MB (-0.023) - beforeRenderModule mod_articles_latest (Анонсы)

Application 1.215 seconds (+0.006); 7.86 MB (+0.047) - afterRenderModule mod_articles_latest (Анонсы)

Application 1.217 seconds (+0.002); 7.83 MB (-0.031) - beforeRenderModule mod_articles_latest (Конкурсы и гранты)

Application 1.228 seconds (+0.011); 7.98 MB (+0.151) - afterRenderModule mod_articles_latest (Конкурсы и гранты)

Application 1.229 seconds (+0.002); 7.84 MB (-0.138) - beforeRenderModule mod_articles_latest (Требуются юристы)

Application 1.237 seconds (+0.008); 8.00 MB (+0.161) - afterRenderModule mod_articles_latest (Требуются юристы)

Application 1.240 seconds (+0.002); 7.87 MB (-0.135) - beforeRenderModule mod_menu (Main Menu)

Application 1.294 seconds (+0.055); 8.06 MB (+0.192) - afterRenderModule mod_menu (Main Menu)

Application 1.296 seconds (+0.002); 8.05 MB (-0.006) - beforeRenderModule mod_search (Поиск)

Application 1.299 seconds (+0.002); 8.07 MB (+0.021) - afterRenderModule mod_search (Поиск)

Application 1.301 seconds (+0.002); 8.06 MB (-0.009) - beforeRenderModule mod_custom (Иностранные сайты)

Application 1.301 seconds (+0.000); 8.07 MB (+0.004) - afterRenderModule mod_custom (Иностранные сайты)

Application 1.303 seconds (+0.002); 8.07 MB (-0.003) - beforeRenderModule mod_custom (Кнопка библиотеки)

Application 1.303 seconds (+0.000); 8.07 MB (+0.004) - afterRenderModule mod_custom (Кнопка библиотеки)

Application 1.303 seconds (+0.001); 8.05 MB (-0.024) - beforeRenderModule mod_login (Авторизация на  сайте)

Application 1.308 seconds (+0.004); 8.07 MB (+0.023) - afterRenderModule mod_login (Авторизация на  сайте)

Application 1.309 seconds (+0.001); 8.09 MB (+0.020) - beforeRenderModule mod_custom (logo)

Application 1.309 seconds (+0.000); 8.09 MB (+0.004) - afterRenderModule mod_custom (logo)

Application 1.565 seconds (+0.256); 8.19 MB (+0.094) - afterRender

66 SQL-запросов зафиксировано

SELECT `data` FROM `j25_session` WHERE `session_id` = '88c9a5ca71466d1d03d7aa31e5a40605'
DELETE FROM `j25_session` WHERE `time` < '1793487981'
SELECT `session_id` FROM `j25_session` WHERE `session_id` = '88c9a5ca71466d1d03d7aa31e5a40605' LIMIT 0, 1
INSERT INTO `j25_session` (`session_id`, `client_id`, `time`) VALUES ('88c9a5ca71466d1d03d7aa31e5a40605', 0, '1793491581')
SELECT b.id FROM j25_usergroups AS a LEFT JOIN j25_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE a.id = 1
SELECT id, rules FROM `j25_viewlevels`
SELECT `component` FROM `j25_tortags_components`
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 j25_menu AS m LEFT JOIN j25_extensions AS e ON m.component_id = e.extension_id WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lft
SELECT a.rules FROM j25_assets AS a WHERE (a.id = 1) GROUP BY a.id, a.rules, a.lft
SELECT b.rules FROM j25_assets AS a LEFT JOIN j25_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems FROM j25_categories as c LEFT JOIN j25_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM j25_categories AS cat JOIN j25_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id LEFT JOIN `j25_content` AS i ON i.`catid` = c.id AND i.state = 1 WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND s.id=97 AND badcats.id is null GROUP BY 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 ORDER BY c.lft
SELECT b.rules FROM j25_assets AS a LEFT JOIN j25_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content.category.97') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name, CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore, CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias, CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id FROM j25_contact_details AS contact WHERE contact.published = 1 AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM j25_content AS a LEFT JOIN j25_content_frontpage AS fp ON fp.content_id = a.id LEFT JOIN j25_categories AS c ON c.id = a.catid LEFT JOIN j25_users AS ua ON ua.id = a.created_by LEFT JOIN j25_users AS uam ON uam.id = a.modified_by LEFT JOIN j25_categories as parent ON parent.id = c.parent_id LEFT JOIN j25_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM j25_categories AS cat JOIN j25_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND a.catid = 97 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-11-01 00:06:21') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-11-01 00:06:21') ORDER BY CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END DESC , a.created LIMIT 470, 10
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name, CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore, CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias, CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id FROM j25_contact_details AS contact WHERE contact.published = 1 AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM j25_content AS a LEFT JOIN j25_content_frontpage AS fp ON fp.content_id = a.id LEFT JOIN j25_categories AS c ON c.id = a.catid LEFT JOIN j25_users AS ua ON ua.id = a.created_by LEFT JOIN j25_users AS uam ON uam.id = a.modified_by LEFT JOIN j25_categories as parent ON parent.id = c.parent_id LEFT JOIN j25_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM j25_categories AS cat JOIN j25_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND a.catid = 97 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-11-01 00:06:21') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-11-01 00:06:21') ORDER BY CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END DESC , a.created
SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM j25_categories as c LEFT JOIN j25_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM j25_categories AS cat JOIN j25_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND s.id=97 AND badcats.id is null GROUP BY 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 ORDER BY c.lft
SELECT `component` FROM `j25_tortags_components`
SELECT `id` FROM `j25_tortags_components` WHERE `component`='com_content'
SELECT `t`.* FROM `j25_tortags_tags` AS `t` INNER JOIN `j25_tortags` AS `m` ON `m`.`tid`=`t`.`id` WHERE `m`.`item_id`=3217 AND `m`.`oid`=1 ORDER BY `t`.`title` ASC
SELECT `component` FROM `j25_tortags_components`
SELECT `id` FROM `j25_tortags_components` WHERE `component`='com_content'
SELECT `t`.* FROM `j25_tortags_tags` AS `t` INNER JOIN `j25_tortags` AS `m` ON `m`.`tid`=`t`.`id` WHERE `m`.`item_id`=3214 AND `m`.`oid`=1 ORDER BY `t`.`title` ASC
SELECT `component` FROM `j25_tortags_components`
SELECT `id` FROM `j25_tortags_components` WHERE `component`='com_content'
SELECT `t`.* FROM `j25_tortags_tags` AS `t` INNER JOIN `j25_tortags` AS `m` ON `m`.`tid`=`t`.`id` WHERE `m`.`item_id`=3213 AND `m`.`oid`=1 ORDER BY `t`.`title` ASC
SELECT `component` FROM `j25_tortags_components`
SELECT `id` FROM `j25_tortags_components` WHERE `component`='com_content'
SELECT `t`.* FROM `j25_tortags_tags` AS `t` INNER JOIN `j25_tortags` AS `m` ON `m`.`tid`=`t`.`id` WHERE `m`.`item_id`=3209 AND `m`.`oid`=1 ORDER BY `t`.`title` ASC
SELECT `component` FROM `j25_tortags_components`
SELECT `id` FROM `j25_tortags_components` WHERE `component`='com_content'
SELECT `t`.* FROM `j25_tortags_tags` AS `t` INNER JOIN `j25_tortags` AS `m` ON `m`.`tid`=`t`.`id` WHERE `m`.`item_id`=3204 AND `m`.`oid`=1 ORDER BY `t`.`title` ASC
SELECT created_by, catid FROM j25_content WHERE id = 3202
SELECT b.rules FROM j25_assets AS a LEFT JOIN j25_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content.article.3202') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT b.rules FROM j25_assets AS a LEFT JOIN j25_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_attachments') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SHOW FULL COLUMNS FROM `j25_assets`
SELECT id FROM j25_assets WHERE parent_id = 0
SELECT b.rules FROM j25_assets AS a LEFT JOIN j25_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.id = 1) GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT a.*, u.name as creator_name FROM j25_attachments AS a LEFT JOIN j25_users AS u ON u.id = a.created_by WHERE a.parent_id=3202 AND a.state = 1 AND a.parent_type='com_content' AND a.parent_entity='article' AND a.access IN (1) ORDER BY created DESC
SELECT `component` FROM `j25_tortags_components`
SELECT `id` FROM `j25_tortags_components` WHERE `component`='com_content'
SELECT `t`.* FROM `j25_tortags_tags` AS `t` INNER JOIN `j25_tortags` AS `m` ON `m`.`tid`=`t`.`id` WHERE `m`.`item_id`=3202 AND `m`.`oid`=1 ORDER BY `t`.`title` ASC
SELECT `component` FROM `j25_tortags_components`
SELECT `id` FROM `j25_tortags_components` WHERE `component`='com_content'
SELECT `t`.* FROM `j25_tortags_tags` AS `t` INNER JOIN `j25_tortags` AS `m` ON `m`.`tid`=`t`.`id` WHERE `m`.`item_id`=3201 AND `m`.`oid`=1 ORDER BY `t`.`title` ASC
SELECT `component` FROM `j25_tortags_components`
SELECT `id` FROM `j25_tortags_components` WHERE `component`='com_content'
SELECT `t`.* FROM `j25_tortags_tags` AS `t` INNER JOIN `j25_tortags` AS `m` ON `m`.`tid`=`t`.`id` WHERE `m`.`item_id`=3200 AND `m`.`oid`=1 ORDER BY `t`.`title` ASC
SELECT `component` FROM `j25_tortags_components`
SELECT `id` FROM `j25_tortags_components` WHERE `component`='com_content'
SELECT `t`.* FROM `j25_tortags_tags` AS `t` INNER JOIN `j25_tortags` AS `m` ON `m`.`tid`=`t`.`id` WHERE `m`.`item_id`=3186 AND `m`.`oid`=1 ORDER BY `t`.`title` ASC
SELECT `component` FROM `j25_tortags_components`
SELECT `id` FROM `j25_tortags_components` WHERE `component`='com_content'
SELECT `t`.* FROM `j25_tortags_tags` AS `t` INNER JOIN `j25_tortags` AS `m` ON `m`.`tid`=`t`.`id` WHERE `m`.`item_id`=3185 AND `m`.`oid`=1 ORDER BY `t`.`title` ASC
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name, CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore, CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias, CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id FROM j25_contact_details AS contact WHERE contact.published = 1 AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM j25_content AS a LEFT JOIN j25_content_frontpage AS fp ON fp.content_id = a.id LEFT JOIN j25_categories AS c ON c.id = a.catid LEFT JOIN j25_users AS ua ON ua.id = a.created_by LEFT JOIN j25_users AS uam ON uam.id = a.modified_by LEFT JOIN j25_categories as parent ON parent.id = c.parent_id LEFT JOIN j25_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM j25_categories AS cat JOIN j25_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND a.catid IN (203,144,138,130,111,97,94,90,89,86,188,169,171,181) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-11-01 00:06:21') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-11-01 00:06:21') AND (a.created >= '2026-11-01 00:00:00' AND a.created <= '2026-12-01 00:00:00') ORDER BY a.created DESC
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name, CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore, CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias, CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id FROM j25_contact_details AS contact WHERE contact.published = 1 AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM j25_content AS a LEFT JOIN j25_content_frontpage AS fp ON fp.content_id = a.id LEFT JOIN j25_categories AS c ON c.id = a.catid LEFT JOIN j25_users AS ua ON ua.id = a.created_by LEFT JOIN j25_users AS uam ON uam.id = a.modified_by LEFT JOIN j25_categories as parent ON parent.id = c.parent_id LEFT JOIN j25_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM j25_categories AS cat JOIN j25_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND a.catid IN (90) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-11-01 00:06:21') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-11-01 00:06:21') ORDER BY a.created DESC LIMIT 0, 1
SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM j25_categories as c LEFT JOIN j25_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM j25_categories AS cat JOIN j25_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND s.id=90 AND badcats.id is null GROUP BY 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 ORDER BY c.lft
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name, CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore, CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias, CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id FROM j25_contact_details AS contact WHERE contact.published = 1 AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM j25_content AS a LEFT JOIN j25_content_frontpage AS fp ON fp.content_id = a.id LEFT JOIN j25_categories AS c ON c.id = a.catid LEFT JOIN j25_users AS ua ON ua.id = a.created_by LEFT JOIN j25_users AS uam ON uam.id = a.modified_by LEFT JOIN j25_categories as parent ON parent.id = c.parent_id LEFT JOIN j25_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM j25_categories AS cat JOIN j25_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND a.catid IN (144) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-11-01 00:06:21') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-11-01 00:06:21') ORDER BY a.created DESC LIMIT 0, 5
SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM j25_categories as c LEFT JOIN j25_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM j25_categories AS cat JOIN j25_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND s.id=144 AND badcats.id is null GROUP BY 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 ORDER BY c.lft
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name, CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore, CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias, CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id FROM j25_contact_details AS contact WHERE contact.published = 1 AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM j25_content AS a LEFT JOIN j25_content_frontpage AS fp ON fp.content_id = a.id LEFT JOIN j25_categories AS c ON c.id = a.catid LEFT JOIN j25_users AS ua ON ua.id = a.created_by LEFT JOIN j25_users AS uam ON uam.id = a.modified_by LEFT JOIN j25_categories as parent ON parent.id = c.parent_id LEFT JOIN j25_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM j25_categories AS cat JOIN j25_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND a.catid IN (231) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-11-01 00:06:21') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-11-01 00:06:21') ORDER BY a.created DESC LIMIT 0, 5
SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM j25_categories as c LEFT JOIN j25_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM j25_categories AS cat JOIN j25_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND s.id=231 AND badcats.id is null GROUP BY 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 ORDER BY c.lft
SELECT `component` FROM `j25_tortags_components`
SELECT * FROM `j25_tortags_components` WHERE `component`='com_content'
SELECT `id` FROM `j25_tortags_components` WHERE `component`='com_content'
SELECT `t`.* FROM `j25_tortags_tags` AS `t` INNER JOIN `j25_tortags` AS `m` ON `m`.`tid`=`t`.`id` WHERE `m`.`item_id`=97 AND `m`.`oid`=1
SELECT `t`.`title` FROM `j25_tortags_tags` AS `t` ORDER BY `t`.`hits` DESC LIMIT 0, 200
SELECT b.rules FROM j25_assets AS a LEFT JOIN j25_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_tortags') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
UPDATE `j25_session` SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1793491581;s:18:\"session.timer.last\";i:1793491581;s:17:\"session.timer.now\";i:1793491581;s:24:\"session.client.forwarded\";s:14:\"216.73.216.122\";s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:15:\"com_attachments\";O:8:\"stdClass\":1:{s:11:\"current_url\";s:78:\"&return=aHR0cHM6Ly9kZXYubGF3LnNmdS1rcmFzLnJ1L25ld3Mvc3R1ZGxpZmU%2Fc3RhcnQ9NDcw\";}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"9dc35b72aef3005fd4e84d0682f4eadb\";}' , `time` = '1793491583' WHERE `session_id` = '88c9a5ca71466d1d03d7aa31e5a40605'

22 типов SQL-запросов зафиксировано, отсортировано по вхождениям

Запросы типа SELECT:

12 × SELECT `component` FROM `j25_tortags_components
11 × SELECT `id` FROM `j25_tortags_components`
11 × SELECT `t`.* FROM `j25_tortags_tags` AS `t` INNER JOIN `j25_tortags` AS `m` ON `m`.`tid`=`t`.`id`
6 × SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name, CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore, CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias, CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id FROM j25_contact_details AS contact
6 × SELECT b.rules FROM j25_assets AS a LEFT JOIN j25_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
4 × SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM j25_categories as c LEFT JOIN j25_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM j25_categories AS cat JOIN j25_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
1 × SELECT id FROM j25_assets
1 × SELECT `t`.`title` FROM `j25_tortags_tags` AS `t`
1 × SELECT * FROM `j25_tortags_components`
1 × SELECT a.*, u.name as creator_name FROM j25_attachments AS a LEFT JOIN j25_users AS u ON u.id = a.created_by
1 × SELECT created_by, catid FROM j25_content
1 × SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems FROM j25_categories as c LEFT JOIN j25_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM j25_categories AS cat JOIN j25_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
1 × SELECT b.id FROM j25_usergroups AS a LEFT JOIN j25_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT `session_id` FROM `j25_session`
1 × SELECT id, rules FROM `j25_viewlevels
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 j25_menu AS m LEFT JOIN j25_extensions AS e ON m.component_id = e.extension_id
1 × SELECT a.rules FROM j25_assets AS a
1 × SELECT `data` FROM `j25_session`

Прочие SQL-запросы:

1 × UPDATE `j25_session` SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1793491581;s:18:\"session.timer.last\";i:1793491581;s:17:\"session.timer.now\";i:1793491581;s:24:\"session.client.forwarded\";s:14:\"216.73.216.122\";s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:15:\"com_attachments\";O:8:\"stdClass\":1:{s:11:\"current_url\";s:78:\"&return=aHR0cHM6Ly9kZXYubGF3LnNmdS1rcmFzLnJ1L25ld3Mvc3R1ZGxpZmU%2Fc3RhcnQ9NDcw\";}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"9dc35b72aef3005fd4e84d0682f4eadb\";}' , `time` = '1793491583'
1 × SHOW FULL COLUMNS FROM `j25_assets
1 × INSERT INTO `j25_session` (`session_id`, `client_id`, `time`) VALUES ('88c9a5ca71466d1d03d7aa31e5a40605', 0, '1793491581'
1 × DELETE FROM `j25_session`

Календарь новостей

Анонсы

Конкурсы и гранты

Требуются юристы

Студенческая жизнь

Рекомендованы в следователи

Уголовный процесс как повод для встреч

Набор в команду ЮИ СФУ для конкурса им. Ф. Джессопа

Уважаемые студенты первого курса.

Уважаемые студенты 1 курса

Встреча А.В.Усса с участниками МЛПШ-2014

С 5 Августа ЮИ СФУ стал площадкой для проведения Международной летней правовой школы -2014( МЛПШ-2014)

Участники МЛПШ-2014 в Арбитражном Суде Красноярского края

Команда ЮИ СФУ заняла 2 место на международном конкурсе!

«Профессия – юрист, правовая школа! Запомни все четыре слова!»

Консоль отладки Joomla!

Сессия

__default

user

Результаты профилирования

Использование памяти

Запросы к базе данных

66 SQL-запросов зафиксировано

22 типов SQL-запросов зафиксировано, отсортировано по вхождениям

Запросы типа SELECT:

Прочие SQL-запросы: