Покровська громада

Queries

0.0019

SELECT `news`.`id` AS `id`, `news`.`title` AS `title`, `news`.`published` AS `published`, `news`.`uri` AS `uri`, `news`.`image` AS `image`, `news`.`caption` AS `caption`, `news`.`views_count` AS `views_count`, `news`.`comments_count` AS `comments_count`, `news`.`is_allow_comment` AS `is_allow_comment`, `news`.`is_photo` AS `is_photo`, `news`.`category_id` AS `category_id`, `news`.`short_text` AS `short_text`, `news`.`video` AS `video`, `news_categories`.`is_services` AS `is_services`, `news_categories`.`uri` AS `category_uri`, `news_categories`.`name` AS `category_name`, `news_categories`.`meta_title` AS `category_meta_title`, `news_categories`.`meta_description` AS `category_meta_description`, `news_categories`.`meta_keywords` AS `category_meta_keywords`, `news_categories`.`meta_extra` AS `category_meta_extra`, TIME_FORMAT(`published`, '%H:%i') as time, IF (DATE_FORMAT(`published`, '%d.%m')<>29.06, DATE_FORMAT(`published`, '%e.%m'), NULL) as date FROM `news` LEFT JOIN `event_categories` ON `news`.`event_category_id` = `event_categories`.`id` LEFT JOIN `authors` ON `news`.`author_id` = `authors`.`id` LEFT JOIN `news_categories` ON `news`.`category_id` = `news_categories`.`id` WHERE `news_categories`.`uri` = 'pokrovska-gromada' AND `news`.`is_deleted` =0 AND `news`.`is_visible` = 1 AND (`news_categories`.`is_services` =0 OR ISNULL(news.category_id)) AND `news`.`published` <= '2022-06-29 19:40:00' ORDER BY `news`.`published` DESC LIMIT 48, 24

0.0014

SELECT COUNT(*) AS `numrows` FROM `news` LEFT JOIN `event_categories` ON `news`.`event_category_id` = `event_categories`.`id` LEFT JOIN `authors` ON `news`.`author_id` = `authors`.`id` JOIN `news_categories` ON `news_categories`.`id`=`category_id` WHERE `news`.`is_deleted` =0 AND `news`.`is_visible` = 1 AND `news_categories`.`uri` = 'pokrovska-gromada' AND (`news_categories`.`is_services` =0 OR ISNULL(news.category_id)) AND `news`.`published` <= '2022-06-29 19:40:00'

0.0001

SELECT * FROM `meta` WHERE `controller` IN('', 'news') AND `action` IN('', 'category') AND `lang` IS NULL AND `dir` IS NULL ORDER BY `controller`

0.0413

SELECT `news_categories`.`uri`, `news_categories`.`name`, count(news.id) as count_news FROM `news_categories` LEFT JOIN `news` ON `news`.`category_id`=`news_categories`.`id` WHERE `news_categories`.`id` != '29' AND `news_categories`.`is_deleted` =0 AND `news_categories`.`is_services` =0 GROUP BY `news_categories`.`id` HAVING `count_news` >0

0.0521

SELECT `news`.`id` AS `id`, `news`.`title` AS `title`, `news`.`published` AS `published`, `news`.`short_text` AS `short_text`, `news`.`uri` AS `uri`, `news`.`image` AS `image`, `news`.`caption` AS `caption`, `news`.`views_count` AS `views_count`, `news`.`comments_count` AS `comments_count`, `news`.`is_allow_comment` AS `is_allow_comment`, `news`.`is_photo` AS `is_photo`, `news`.`video` AS `video`, `news_categories`.`uri` AS `category_uri`, TIME_FORMAT(`published`, '%H:%i') as time, DATE(`published`) as date FROM `news` LEFT JOIN `event_categories` ON `news`.`event_category_id` = `event_categories`.`id` LEFT JOIN `authors` ON `news`.`author_id` = `authors`.`id` LEFT JOIN `news_categories` ON `news`.`category_id` = `news_categories`.`id` WHERE `news`.`is_deleted` =0 AND `news`.`is_visible` = 1 AND `news`.`is_top_category` = 1 AND `news`.`category_id` = '29' AND `news`.`published` <= '2022-06-29 19:40:00' ORDER BY `news`.`published` DESC LIMIT 3

0.0967

Total Query Execution Time

Loaded Files

__MyTemplates_2761e78525f44ec3bd369e7f495e4f28.php
/var/www/pokrovsk.news/application/cache/mustache/__MyTemplates_2761e78525f44ec3bd369e7f495e4f28.php

__MyTemplates_8b46e3563abd38eecabe5a4edcfa4910.php
/var/www/pokrovsk.news/application/cache/mustache/__MyTemplates_8b46e3563abd38eecabe5a4edcfa4910.php

__MyTemplates_a067992934dc34808e89351ef141c8d3.php
/var/www/pokrovsk.news/application/cache/mustache/__MyTemplates_a067992934dc34808e89351ef141c8d3.php

__MyTemplates_aa4418c4e15379357486c6861d066c20.php
/var/www/pokrovsk.news/application/cache/mustache/__MyTemplates_aa4418c4e15379357486c6861d066c20.php

__MyTemplates_cecff56679c43453cc3144dc7c8e3bd9.php
/var/www/pokrovsk.news/application/cache/mustache/__MyTemplates_cecff56679c43453cc3144dc7c8e3bd9.php

config.php
/var/www/pokrovsk.news/application/config/config.php

constants.php
/var/www/pokrovsk.news/application/config/constants.php

database.php
/var/www/pokrovsk.news/application/config/database.php

autoload.php
/var/www/pokrovsk.news/application/config/development/autoload.php

profiler.php
/var/www/pokrovsk.news/application/config/development/profiler.php

mimes.php
/var/www/pokrovsk.news/application/config/mimes.php

mustache.php
/var/www/pokrovsk.news/application/config/mustache.php

profiler.php
/var/www/pokrovsk.news/application/config/profiler.php

routes.php
/var/www/pokrovsk.news/application/config/routes.php

routes_pages.php
/var/www/pokrovsk.news/application/config/routes_pages.php

News.php
/var/www/pokrovsk.news/application/controllers/News.php

MY_Controller.php
/var/www/pokrovsk.news/application/core/MY_Controller.php

MY_Model.php
/var/www/pokrovsk.news/application/core/MY_Model.php

generic_helper.php
/var/www/pokrovsk.news/application/helpers/generic_helper.php

Console.php
/var/www/pokrovsk.news/application/libraries/Console.php

Mustache.php
/var/www/pokrovsk.news/application/libraries/Mustache.php

Paginator.php
/var/www/pokrovsk.news/application/libraries/Paginator.php

Profiler.php
/var/www/pokrovsk.news/application/libraries/Profiler.php

Seo.php
/var/www/pokrovsk.news/application/libraries/Seo.php

mustache_library.php
/var/www/pokrovsk.news/application/libraries/mustache_library.php

Blogs_model.php
/var/www/pokrovsk.news/application/models/Blogs_model.php

Events_model.php
/var/www/pokrovsk.news/application/models/Events_model.php

Generic.php
/var/www/pokrovsk.news/application/models/Generic.php

News_model.php
/var/www/pokrovsk.news/application/models/News_model.php

Seo_model.php
/var/www/pokrovsk.news/application/models/seo/Seo_model.php

index.php
/var/www/pokrovsk.news/application/views/index.php

Benchmark.php
/var/www/pokrovsk.news/system/core/Benchmark.php

CodeIgniter.php
/var/www/pokrovsk.news/system/core/CodeIgniter.php

Common.php
/var/www/pokrovsk.news/system/core/Common.php

Config.php
/var/www/pokrovsk.news/system/core/Config.php

Controller.php
/var/www/pokrovsk.news/system/core/Controller.php

Hooks.php
/var/www/pokrovsk.news/system/core/Hooks.php

Input.php
/var/www/pokrovsk.news/system/core/Input.php

Lang.php
/var/www/pokrovsk.news/system/core/Lang.php

Loader.php
/var/www/pokrovsk.news/system/core/Loader.php

Log.php
/var/www/pokrovsk.news/system/core/Log.php

Model.php
/var/www/pokrovsk.news/system/core/Model.php

Output.php
/var/www/pokrovsk.news/system/core/Output.php

Router.php
/var/www/pokrovsk.news/system/core/Router.php

Security.php
/var/www/pokrovsk.news/system/core/Security.php

URI.php
/var/www/pokrovsk.news/system/core/URI.php

Utf8.php
/var/www/pokrovsk.news/system/core/Utf8.php

hash.php
/var/www/pokrovsk.news/system/core/compat/hash.php

mbstring.php
/var/www/pokrovsk.news/system/core/compat/mbstring.php

password.php
/var/www/pokrovsk.news/system/core/compat/password.php

standard.php
/var/www/pokrovsk.news/system/core/compat/standard.php

DB.php
/var/www/pokrovsk.news/system/database/DB.php

DB_driver.php
/var/www/pokrovsk.news/system/database/DB_driver.php

DB_query_builder.php
/var/www/pokrovsk.news/system/database/DB_query_builder.php

DB_result.php
/var/www/pokrovsk.news/system/database/DB_result.php

mysqli_driver.php
/var/www/pokrovsk.news/system/database/drivers/mysqli/mysqli_driver.php

mysqli_result.php
/var/www/pokrovsk.news/system/database/drivers/mysqli/mysqli_result.php

language_helper.php
/var/www/pokrovsk.news/system/helpers/language_helper.php

text_helper.php
/var/www/pokrovsk.news/system/helpers/text_helper.php

url_helper.php
/var/www/pokrovsk.news/system/helpers/url_helper.php

profiler_lang.php
/var/www/pokrovsk.news/system/language/english/profiler_lang.php

Cache.php
/var/www/pokrovsk.news/system/libraries/Cache/Cache.php

Cache_dummy.php
/var/www/pokrovsk.news/system/libraries/Cache/drivers/Cache_dummy.php

Driver.php
/var/www/pokrovsk.news/system/libraries/Driver.php

index.php
index.php

Loading Time: Base Classes	0.0002
Controller Execution Time ( News / Category )	0.0999
Total Execution Time	0.1002

HTTP_ACCEPT	text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8
HTTP_USER_AGENT	CCBot/2.0 (https://commoncrawl.org/faq/)
HTTP_CONNECTION	Keep-Alive
SERVER_PORT	443
SERVER_NAME	pokrovsk.news
REMOTE_ADDR	3.235.78.122
SERVER_SOFTWARE	nginx/1.18.0
HTTP_ACCEPT_LANGUAGE	en-US,en;q=0.5
SCRIPT_NAME	/index.php
REQUEST_METHOD	GET
HTTP_HOST
REMOTE_HOST
CONTENT_TYPE
SERVER_PROTOCOL	HTTP/1.1
QUERY_STRING
HTTP_ACCEPT_ENCODING	br,gzip
HTTP_X_FORWARDED_FOR

base_url	https://pokrovsk.news/
index_page
uri_protocol	REQUEST_URI
url_suffix
language	english
charset	UTF-8
enable_hooks
subclass_prefix	MY_
composer_autoload
permitted_uri_chars	a-z 0-9~%.:_\-а-яА-Я
allow_get_array	1
enable_query_strings
controller_trigger	c
function_trigger	m
directory_trigger	d
log_threshold	0
log_path
log_file_extension
log_file_permissions	420
log_date_format	Y-m-d H:i:s
error_views_path
cache_path
cache_query_string
encryption_key	It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using
sess_driver	files
sess_cookie_name	ci_session
sess_expiration	7200
sess_save_path
sess_match_ip
sess_time_to_update	300
sess_regenerate_destroy
cookie_prefix
cookie_domain
cookie_path	/
cookie_secure
cookie_httponly
standardize_newlines
global_xss_filtering
csrf_protection
csrf_token_name	csrf_test_name
csrf_cookie_name	csrf_cookie_name
csrf_expire	7200
csrf_regenerate	1
csrf_exclude_uris	Array ( )
compress_output
time_reference	local
rewrite_short_tags
proxy_ips

Console

Memory Usage

Benchmarks

Queries

VIEW DATA

SESSION USER DATA

GET DATA

POST DATA

URI STRING

CLASS/METHOD

HTTP HEADERS

CONFIG VARIABLES

Loaded Files