Configuration

debug
xdebug
logging
cache
compression
tokenizer
eaccelerator
apc
xcache

Request

parameterHolder:
  action: index
  city: Sochi
  module: users
  offset: '1560'
attributeHolder:
  sf_route: 'sfRoute Object()'

Response

options:
  http_protocol: HTTP/1.1
  logging: '1'
  charset: utf-8
  send_http_headers: true
  content_type: 'text/html; charset=utf-8'
cookies: {  }
httpHeaders:
  Content-Type: 'text/html; charset=utf-8'
javascripts:
  main.js: {  }
  jquery-1.4.2.min.js: {  }
stylesheets:
  styles.css: {  }
metas:
  title: 'Мир Мафии – Все о карточной игре Мафия: тактика, клубы, игры, видео. Ролевая психологическая  настольная игра Мафия. Где поиграть в Мафию в Москве, в Киеве, в Санкт-Петербурге, в Питере, в СПб.'
  description: 'Все о карточной игре Мафия: тактика, клубы, игры, видео. Ролевая психологическая  настольная игра Мафия. Где поиграть в Мафию.'
  keywords: 'ролевая психологическая  настольная карточная игра Мафия, где поиграть в Мафию'
  language: en
  robots: 'index, follow'
httpMetas:
  Content-Type: 'text/html; charset=utf-8'

User

options:
  auto_shutdown: false
  culture: null
  default_culture: en
  use_flash: true
  logging: '1'
  timeout: 5400
attributeHolder: {  }
culture: en

Settings

app_captcha_add: 11
app_count_users_on_page: 20
app_default_photo_cover: /images/default_video.png
app_default_static_page_picture: /images/headers/defult.png
app_default_video_cover: /images/default_video.png
app_letter_subscribe_footer: '<br>----<br>C уважением,<br>Администрация портала MirMafii.ru<br><br>P.S. Уважаемые пользователи портала MirMafii.ru! Хотя нам очень хотелось бы иметь возможность напрямую общаться с вами, чтобы сообщать о важных новостях и интересных материалах об игре Мафия, мы понимаем, что получение рассылки - дело абсолютно добровольное. Чтобы отписаться от рассылки, перейдите по ссылке <a href=''http://Mirmafii.ru/users/unsetSendingEmail/code/%s''>MirMafii.ru/users/unsetSendingEmail/code/%s</a>'
app_promote_products_limit: 3
app_sfAssetsLibrary_upload_dir: media
app_sf_captchagd_chars: '123456789'
app_sf_captchagd_font_size: 24
app_sf_captchagd_image_height: 40
app_sf_captchagd_image_width: 100
app_sf_captchagd_length: 2
app_sf_guard_plugin_remember_cookie_name: myAppRememberMe
app_sf_guard_plugin_remember_key_expiration_age: 2592000
app_url: 'http://MirMafii.ru'
mod_block_enabled: true
mod_block_is_internal: false
mod_block_view_class: sfPHP
mod_users_enabled: true
mod_users_is_internal: false
mod_users_view_class: sfPHP
sf_admin_module_web_dir: /sfPropelPlugin
sf_admin_web_dir: /sf/sf_admin
sf_app: frontend
sf_app_base_cache_dir: /home/u98615/mirmafii.ru/cache/frontend
sf_app_cache_dir: /home/u98615/mirmafii.ru/cache/frontend/dev
sf_app_config_dir: /home/u98615/mirmafii.ru/apps/frontend/config
sf_app_dir: /home/u98615/mirmafii.ru/apps/frontend
sf_app_i18n_dir: /home/u98615/mirmafii.ru/apps/frontend/i18n
sf_app_lib_dir: /home/u98615/mirmafii.ru/apps/frontend/lib
sf_app_module_dir: /home/u98615/mirmafii.ru/apps/frontend/modules
sf_app_template_dir: /home/u98615/mirmafii.ru/apps/frontend/templates
sf_apps_dir: /home/u98615/mirmafii.ru/apps
sf_cache: false
sf_cache_dir: /home/u98615/mirmafii.ru/cache
sf_calendar_web_dir: /sf/calendar
sf_charset: utf-8
sf_check_lock: false
sf_check_symfony_version: false
sf_compat_10: true
sf_compressed: false
sf_config_cache_dir: /home/u98615/mirmafii.ru/cache/frontend/dev/config
sf_config_dir: /home/u98615/mirmafii.ru/config
sf_csrf_secret: false
sf_data_dir: /home/u98615/mirmafii.ru/data
sf_debug: true
sf_default_culture: en
sf_doc_dir: /home/u98615/mirmafii.ru/doc
sf_enabled_modules:
  - default
  - sfGuardAuth
  - sfCaptchaGD
  - sfAsset
sf_environment: dev
sf_error_404_action: error404
sf_error_404_module: system
sf_error_reporting: 8191
sf_escaping_method: ESC_SPECIALCHARS
sf_escaping_strategy: false
sf_etag: false
sf_execution_filter:
  - sfValidationExecutionFilter
  - {  }
sf_i18n: false
sf_i18n_cache_dir: /home/u98615/mirmafii.ru/cache/frontend/dev/i18n
sf_lazy_cache_key: false
sf_lib_dir: /home/u98615/mirmafii.ru/lib
sf_log_dir: /home/u98615/mirmafii.ru/log
sf_logging_enabled: true
sf_login_action: signin
sf_login_module: sfGuardAuth
sf_max_forwards: 5
sf_module_cache_dir: /home/u98615/mirmafii.ru/cache/frontend/dev/modules
sf_module_disabled_action: disabled
sf_module_disabled_module: default
sf_no_script_name: false
sf_orm: propel
sf_plugins_dir: /home/u98615/mirmafii.ru/plugins
sf_prototype_web_dir: /sfProtoculousPlugin
sf_rich_text_js_dir: js/tiny_mce
sf_root_dir: /home/u98615/mirmafii.ru
sf_secure_action: secure
sf_secure_module: sfGuardAuth
sf_standard_helpers:
  - Partial
  - Cache
  - Form
sf_strip_comments: true
sf_symfony_lib_dir: /home/u98615/mirmafii.ru/lib/symfony
sf_template_cache_dir: /home/u98615/mirmafii.ru/cache/frontend/dev/template
sf_test_cache_dir: /home/u98615/mirmafii.ru/cache/frontend/dev/test
sf_test_dir: /home/u98615/mirmafii.ru/test
sf_upload_dir: /home/u98615/mirmafii.ru/config/../www/uploads
sf_use_database: true
sf_validation_error_class: form_error
sf_validation_error_id_prefix: error_for_
sf_validation_error_prefix: ' &darr;&nbsp;'
sf_validation_error_suffix: ' &nbsp;&darr;'
sf_web_debug: true
sf_web_debug_web_dir: /sf/sf_web_debug
sf_web_dir: /home/u98615/mirmafii.ru/config/../www
symfony.asset.javascripts_included: false
symfony.asset.stylesheets_included: false
symfony.view.slot_names: {  }

Globals

cookie:
  symfony: c1706aea016757d61c02ec335956e718
env: {  }
files: {  }
get:
  city: Sochi
  offset: '1560'
post: {  }
server:
  DOCUMENT_ROOT: /home/u98615/mirmafii.ru/www
  GATEWAY_INTERFACE: CGI/1.1
  HTTP_ACCEPT: '*/*'
  HTTP_ACCEPT_ENCODING: 'gzip, br, zstd, deflate'
  HTTP_CACHE_CONTROL: max-age=0
  HTTP_COOKIE: symfony=c1706aea016757d61c02ec335956e718
  HTTP_HOST: mirmafii.ru
  HTTP_MH_GEOIP_COUNTRY_CODE: US
  HTTP_PORT: '80'
  HTTP_USER_AGENT: 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'
  HTTP_VIA: '1.1 squid-proxy-5b5d847c96-wjm2v (squid/6.13)'
  HTTP_X_FORWARDED_FOR: '10.1.104.6, 216.73.217.75, 216.73.217.75'
  HTTP_X_FORWARDED_PORT: '80'
  HTTP_X_MH_HOST: mirmafii.ru
  HTTP_X_REAL_IP: 216.73.217.75
  LANG: ru_RU.CP1251
  MAGICK_THREAD_LIMIT: '1'
  MM_CHARSET: CP1251
  PATH: '/usr/local/bin:/usr/bin:/bin'
  PATH_INFO: /users/
  PATH_TRANSLATED: 'redirect:/index.php/'
  PHP_SELF: /frontend_dev.php/users/
  QUERY_STRING: 'city=Sochi&offset=1560'
  REMOTE_ADDR: 216.73.217.75
  REMOTE_PORT: '38925'
  REQUEST_METHOD: GET
  REQUEST_TIME: 1776557458
  REQUEST_URI: '/frontend_dev.php/users/?city=Sochi&offset=1560'
  SCRIPT_FILENAME: /home/u98615/mirmafii.ru/www/frontend_dev.php
  SCRIPT_NAME: /frontend_dev.php
  SERVER_ADDR: 127.0.0.1
  SERVER_ADMIN: support@masterhost.ru
  SERVER_NAME: mirmafii.ru
  SERVER_PORT: '80'
  SERVER_PROTOCOL: HTTP/1.1
  SERVER_SIGNATURE: ''
  SERVER_SOFTWARE: Apache
  UNIQUE_ID: aeQdkn8AAQEAAAcTXrsAAAAn
  argc: 1
  argv: ['city=Sochi&offset=1560']
session:
  symfony/user/sfUser/attributes: {  }
  symfony/user/sfUser/authenticated: false
  symfony/user/sfUser/credentials: {  }
  symfony/user/sfUser/culture: en
  symfony/user/sfUser/lastRequest: 1776557458

Php

php: 5.2.17-2+mh3
os: 'Linux dbe605.hs.shared.masterhost.ru 3.14.51-grsec #1 SMP Fri Oct 21 13:38:02 UTC 2016 x86_64'
extensions:
  - 'date (5.2.17-2+mh3)'
  - libxml
  - openssl
  - pcre
  - 'zlib (1.1)'
  - bcmath
  - bz2
  - calendar
  - ctype
  - dba
  - 'dom (20031129)'
  - 'hash (1.0)'
  - 'filter (0.11.0)'
  - ftp
  - gettext
  - session
  - iconv
  - 'json (1.2.1)'
  - mbstring
  - 'mime_magic (0.1)'
  - posix
  - 'Reflection (0.1)'
  - 'standard (5.2.17-2+mh3)'
  - shmop
  - 'SimpleXML (0.1)'
  - soap
  - sockets
  - 'SPL (0.2)'
  - 'exif (1.4 $Id: exif.c 293036 2010-01-03 09:23:27Z sebastian $)'
  - sysvmsg
  - sysvsem
  - sysvshm
  - 'tokenizer (0.1)'
  - wddx
  - xml
  - 'xmlreader (0.1)'
  - 'xmlwriter (0.1)'
  - 'zip (1.8.11)'
  - apache2handler
  - curl
  - 'dbase (5.1.0)'
  - gd
  - imap
  - 'mysql (1.0)'
  - mcrypt
  - 'mysqli (0.1)'
  - mssql
  - 'PDO (1.0.4dev)'
  - 'pdo_mysql (1.0.2)'
  - 'pdo_dblib (1.0.1)'
  - 'xsl (0.1)'
  - 'SQLite (2.0-dev)'
  - 'pdo_sqlite (1.0.1)'
  - 'imagick (3.1.0RC1)'
  - 'intl (PECL-3.0.0)'
  - 'Zend Optimizer'

Symfony

version: 1.2.8
path: /home/u98615/mirmafii.ru/lib/symfony

Logs

#	type	message
1	PatternRouting	Connect sfRoute "homepage" (/)
2	PatternRouting	Connect sfRoute "static" (/static/:url)
3	PatternRouting	Connect sfRoute "rating" (/club/rating/)
4	PatternRouting	Connect sfRoute "club" (/club/:url)
5	PatternRouting	Connect sfRoute "clubs" (/clubs/)
6	PatternRouting	Connect sfRoute "games" (/games/)
7	PatternRouting	Connect sfRoute "user" (/user/:id)
8	PatternRouting	Connect sfRoute "users" (/users/)
9	PatternRouting	Connect sfRoute "newslist" (/newslist/)
10	PatternRouting	Connect sfRoute "news" (/news/:id)
11	PatternRouting	Connect sfRoute "articles" (/articles/)
12	PatternRouting	Connect sfRoute "article" (/article/:id)
13	PatternRouting	Connect sfRoute "gallerys" (/gallerys/)
14	PatternRouting	Connect sfRoute "gallery" (/gallery/:url)
15	PatternRouting	Connect sfRoute "all_videos" (/all_videos/)
16	PatternRouting	Connect sfRoute "register" (/register/)
17	PatternRouting	Connect sfRoute "message_admin" (/message_admin/)
18	PatternRouting	Connect sfRoute "sitemap" (/sitemap/)
19	PatternRouting	Connect sfRoute "shop" (/shop/)
20	PatternRouting	Connect sfRoute "shop_product" (/shop/:url)
21	PatternRouting	Connect sfRoute "default_index" (/:module)
22	PatternRouting	Connect sfRoute "default" (/:module/:action/*)
23	PatternRouting	Connect sfRoute "sf_guard_signin" (/login)
24	PatternRouting	Connect sfRoute "sf_asset_library_dir" (/sfAsset/dir/:dir)
25	PatternRouting	Connect sfRequestRoute "sf_captchagd" (/captcha)
26	PatternRouting	Connect sfRoute "sf_guard_signin" (/login)
27	PatternRouting	Connect sfRoute "sf_guard_signout" (/logout)
28	PatternRouting	Connect sfRoute "sf_guard_password" (/request_password)
29	PatternRouting	Match route "users" (/users/) for /users/ with parameters array ( 'module' => 'users', 'action' => 'index',)
30	FilterChain	Executing filter "sfRenderingFilter"
31	FilterChain	Executing filter "sfCommonFilter"
32	FilterChain	Executing filter "sfValidationExecutionFilter"
33	usersActions	Call "usersActions->executeIndex()"
34	PHPView	Render "sf_app_dir/modules/users/templates/indexSuccess.php"
35	PartialView	Render "sf_app_dir/modules/block/templates/_title.php"
36	main	Set slot "title"
37	PartialView	Render "sf_app_dir/templates/_city_select.php"
38	PartialView	Render "sf_app_dir/modules/block/templates/_breadCrumbs.php"
39	main	Set slot "bread_crumbs"
40	PartialView	Render "sf_app_dir/templates/_flashes.php"
41	PartialView	Render "sf_app_dir/modules/users/templates/_search_form.php"
42	PartialView	Render "sf_app_dir/modules/users/templates/_sort_select.php"
43	PartialView	Render "sf_app_dir/modules/users/templates/_paginator.php"
44	PHPView	Decorate content with "sf_app_dir/templates/layout.php"
45	PHPView	Render "sf_app_dir/templates/layout.php"
46	main	Get slot "title"
47	PartialView	Render "sf_app_dir/templates/_liveInternetCounter.php"
48	PartialView	Render "sf_app_dir/templates/_yandexMetrika.php"
49	PartialView	Render "sf_app_dir/templates/_topline.php"
50	main	Get slot "bread_crumbs"
51	main	Call "block->executeBanner()"
52	PartialView	Render "sf_app_dir/modules/block/templates/_banner.php"
53	PartialView	Render "sf_app_dir/templates/_myblock.php"
54	PartialView	Render "sf_app_dir/templates/_menu.php"
55	main	Call "block->executeClubs()"
56	PartialView	Render "sf_app_dir/modules/block/templates/_clubs.php"
57	PartialView	Render "sf_app_dir/templates/_static_block.php"
58	main	Call "block->executeGames()"
59	PartialView	Render "sf_app_dir/modules/block/templates/_games.php"
60	main	Call "block->executeBanner()"
61	PartialView	Render "sf_app_dir/modules/block/templates/_banner.php"
62	PartialView	Render "sf_app_dir/templates/_notice.php"
63	PartialView	Render "sf_app_dir/templates/_karty.php"
64	PartialView	Render "sf_app_dir/templates/_footer.php"
65	WebResponse	Send status "HTTP/1.1 200 OK"
66	WebResponse	Send header "Content-Type: text/html; charset=utf-8"

type	calls	time (ms)	time (%)
Configuration	13	1.99	0
Action "users/index"	1	582.93	41
View "Success" for "users/index"	1	136.55	9
Partial "block/_title"	1	0.39	0
Partial "global/_city_select"	1	23.60	1
Partial "block/_breadCrumbs"	1	0.85	0
Partial "global/_flashes"	1	0.27	0
Partial "users/_search_form"	1	0.25	0
Partial "users/_sort_select"	1	2.00	0
Partial "users/_paginator"	1	0.44	0
Partial "global/_liveInternetCounter"	1	0.23	0
Partial "global/_yandexMetrika"	1	0.22	0
Partial "global/_topline"	1	0.35	0
Component "block/banner"	2	15.07	1
Partial "block/_banner"	2	0.63	0
Partial "global/_myblock"	1	0.78	0
Partial "global/_menu"	1	2.08	0
Component "block/clubs"	1	22.46	1
Partial "block/_clubs"	1	30.18	2
Partial "global/_static_block"	1	2.76	0
Component "block/games"	1	5.10	0
Partial "block/_games"	1	4.64	0
Partial "global/_notice"	1	0.23	0
Partial "global/_karty"	1	0.21	0
Partial "global/_footer"	1	0.70	0

SQL queries

SET NAMES 'utf8'
SELECT COUNT(*) FROM `city`, `sf_guard_user` WHERE city.SNAME='Sochi' AND sf_guard_user.CITY_ID=city.ID
SELECT sf_guard_user.ID, sf_guard_user.USERNAME, sf_guard_user.ALGORITHM, sf_guard_user.SALT, sf_guard_user.PASSWORD, sf_guard_user.CREATED_AT, sf_guard_user.LAST_LOGIN, sf_guard_user.IS_ACTIVE, sf_guard_user.IS_SUPER_ADMIN, sf_guard_user.RATING, sf_guard_user.NAME, sf_guard_user.PHONE, sf_guard_user.EMAIL, sf_guard_user.OTHER_CONTACTS, sf_guard_user.CITY_ID, sf_guard_user.CITY_NAME, sf_guard_user.AGE, sf_guard_user.AVATAR, sf_guard_user.SENDING_EMAIL, sf_guard_user.SHOW_CONTACTS, sf_guard_user.ABOUT, sf_guard_user.PROFESSION, sf_guard_user.COUNT_COMMENTS, sf_guard_user.COUNT_BLOG_POSTS, sf_guard_user.COUNT_ARTICLES FROM `sf_guard_user`, `city` WHERE city.SNAME='Sochi' AND sf_guard_user.CITY_ID=city.ID ORDER BY sf_guard_user.CREATED_AT DESC LIMIT 1560, 20
SELECT club.ID, club.NAME, club.URL, club.DESCRIPTION, club.SMALL_DESCRIPTION, club.ADDRESS, club.PHONE, club.EMAIL, club.CITY_ID, club.MAIN_MENU, club.INVISIBLE, club.IMAGE, club.SITE_TITLE, club.COUNT_ARTICLES, club.COUNT_MEMBERS, club.RATING_DATE, club.RATING_USER_ID, club.RATING_REVIEW_ID, club.RATING_COMMENT, club.CREATED_AT, club.UPDATED_AT FROM `club` WHERE club.RATING_USER_ID=2618
SELECT club.ID, club.NAME, club.URL, club.DESCRIPTION, club.SMALL_DESCRIPTION, club.ADDRESS, club.PHONE, club.EMAIL, club.CITY_ID, club.MAIN_MENU, club.INVISIBLE, club.IMAGE, club.SITE_TITLE, club.COUNT_ARTICLES, club.COUNT_MEMBERS, club.RATING_DATE, club.RATING_USER_ID, club.RATING_REVIEW_ID, club.RATING_COMMENT, club.CREATED_AT, club.UPDATED_AT FROM `club` WHERE club.RATING_USER_ID=2343
SELECT club.ID, club.NAME, club.URL, club.DESCRIPTION, club.SMALL_DESCRIPTION, club.ADDRESS, club.PHONE, club.EMAIL, club.CITY_ID, club.MAIN_MENU, club.INVISIBLE, club.IMAGE, club.SITE_TITLE, club.COUNT_ARTICLES, club.COUNT_MEMBERS, club.RATING_DATE, club.RATING_USER_ID, club.RATING_REVIEW_ID, club.RATING_COMMENT, club.CREATED_AT, club.UPDATED_AT FROM `club` WHERE club.RATING_USER_ID=2306
SELECT club.ID, club.NAME, club.URL, club.DESCRIPTION, club.SMALL_DESCRIPTION, club.ADDRESS, club.PHONE, club.EMAIL, club.CITY_ID, club.MAIN_MENU, club.INVISIBLE, club.IMAGE, club.SITE_TITLE, club.COUNT_ARTICLES, club.COUNT_MEMBERS, club.RATING_DATE, club.RATING_USER_ID, club.RATING_REVIEW_ID, club.RATING_COMMENT, club.CREATED_AT, club.UPDATED_AT FROM `club` WHERE club.RATING_USER_ID=2291
SELECT club.ID, club.NAME, club.URL, club.DESCRIPTION, club.SMALL_DESCRIPTION, club.ADDRESS, club.PHONE, club.EMAIL, club.CITY_ID, club.MAIN_MENU, club.INVISIBLE, club.IMAGE, club.SITE_TITLE, club.COUNT_ARTICLES, club.COUNT_MEMBERS, club.RATING_DATE, club.RATING_USER_ID, club.RATING_REVIEW_ID, club.RATING_COMMENT, club.CREATED_AT, club.UPDATED_AT FROM `club` WHERE club.RATING_USER_ID=1820
SELECT club.ID, club.NAME, club.URL, club.DESCRIPTION, club.SMALL_DESCRIPTION, club.ADDRESS, club.PHONE, club.EMAIL, club.CITY_ID, club.MAIN_MENU, club.INVISIBLE, club.IMAGE, club.SITE_TITLE, club.COUNT_ARTICLES, club.COUNT_MEMBERS, club.RATING_DATE, club.RATING_USER_ID, club.RATING_REVIEW_ID, club.RATING_COMMENT, club.CREATED_AT, club.UPDATED_AT FROM `club` WHERE club.RATING_USER_ID=1692
SELECT club.ID, club.NAME, club.URL, club.DESCRIPTION, club.SMALL_DESCRIPTION, club.ADDRESS, club.PHONE, club.EMAIL, club.CITY_ID, club.MAIN_MENU, club.INVISIBLE, club.IMAGE, club.SITE_TITLE, club.COUNT_ARTICLES, club.COUNT_MEMBERS, club.RATING_DATE, club.RATING_USER_ID, club.RATING_REVIEW_ID, club.RATING_COMMENT, club.CREATED_AT, club.UPDATED_AT FROM `club` WHERE club.RATING_USER_ID=1398
SELECT club.ID, club.NAME, club.URL, club.DESCRIPTION, club.SMALL_DESCRIPTION, club.ADDRESS, club.PHONE, club.EMAIL, club.CITY_ID, club.MAIN_MENU, club.INVISIBLE, club.IMAGE, club.SITE_TITLE, club.COUNT_ARTICLES, club.COUNT_MEMBERS, club.RATING_DATE, club.RATING_USER_ID, club.RATING_REVIEW_ID, club.RATING_COMMENT, club.CREATED_AT, club.UPDATED_AT FROM `club` WHERE club.RATING_USER_ID=962
SELECT club.ID, club.NAME, club.URL, club.DESCRIPTION, club.SMALL_DESCRIPTION, club.ADDRESS, club.PHONE, club.EMAIL, club.CITY_ID, club.MAIN_MENU, club.INVISIBLE, club.IMAGE, club.SITE_TITLE, club.COUNT_ARTICLES, club.COUNT_MEMBERS, club.RATING_DATE, club.RATING_USER_ID, club.RATING_REVIEW_ID, club.RATING_COMMENT, club.CREATED_AT, club.UPDATED_AT FROM `club` WHERE club.RATING_USER_ID=513
SELECT club.ID, club.NAME, club.URL, club.DESCRIPTION, club.SMALL_DESCRIPTION, club.ADDRESS, club.PHONE, club.EMAIL, club.CITY_ID, club.MAIN_MENU, club.INVISIBLE, club.IMAGE, club.SITE_TITLE, club.COUNT_ARTICLES, club.COUNT_MEMBERS, club.RATING_DATE, club.RATING_USER_ID, club.RATING_REVIEW_ID, club.RATING_COMMENT, club.CREATED_AT, club.UPDATED_AT FROM `club` WHERE club.RATING_USER_ID=217
SELECT club.ID, club.NAME, club.URL, club.DESCRIPTION, club.SMALL_DESCRIPTION, club.ADDRESS, club.PHONE, club.EMAIL, club.CITY_ID, club.MAIN_MENU, club.INVISIBLE, club.IMAGE, club.SITE_TITLE, club.COUNT_ARTICLES, club.COUNT_MEMBERS, club.RATING_DATE, club.RATING_USER_ID, club.RATING_REVIEW_ID, club.RATING_COMMENT, club.CREATED_AT, club.UPDATED_AT FROM `club` WHERE club.RATING_USER_ID=73
SELECT club.ID, club.NAME, club.URL, club.DESCRIPTION, club.SMALL_DESCRIPTION, club.ADDRESS, club.PHONE, club.EMAIL, club.CITY_ID, club.MAIN_MENU, club.INVISIBLE, club.IMAGE, club.SITE_TITLE, club.COUNT_ARTICLES, club.COUNT_MEMBERS, club.RATING_DATE, club.RATING_USER_ID, club.RATING_REVIEW_ID, club.RATING_COMMENT, club.CREATED_AT, club.UPDATED_AT FROM `club` WHERE club.RATING_USER_ID=52
SELECT city.ID, city.NAME, city.SNAME, city.DESCRIPTION, city.MAIN_MENU, city.ORDERING, city.SITE_TITLE, city.ZONE, city.CREATED_AT, city.UPDATED_AT FROM `city` WHERE city.SNAME='Sochi' LIMIT 1
SELECT city.ID, city.NAME, city.SNAME, city.DESCRIPTION, city.MAIN_MENU, city.ORDERING, city.SITE_TITLE, city.ZONE, city.CREATED_AT, city.UPDATED_AT FROM `city`
SELECT ips_cityes.ID, ips_cityes.FIRST_IP, ips_cityes.LAST_IP, ips_cityes.CITY_ID, ips_cityes.CITY_NAME, ips_cityes.REGION, ips_cityes.ZONE FROM `ips_cityes` WHERE ips_cityes.FIRST_IP<=3628718411 AND ips_cityes.LAST_IP>=3628718411 ORDER BY ips_cityes.ID DESC LIMIT 1
SELECT banner.ID, banner.NAME, banner.SNAME, banner.BANNER_PLACE_ID, banner.CITY_ID, banner.HTMLCODE, banner.ZONE, banner.SHOW_BEGIN, banner.SHOW_END, banner.COUNT_VIEWS, banner.COUNT_CLICKS FROM `banner`, `banner_place` WHERE banner.CITY_ID=1 AND banner_place.SNAME='top' AND (banner.SHOW_BEGIN<='2026-04-19' OR banner.SHOW_BEGIN IS NULL ) AND (banner.SHOW_END>='2026-04-19' OR banner.SHOW_END IS NULL ) AND banner_place.ID=banner.BANNER_PLACE_ID
SELECT banner_place.ID, banner_place.NAME, banner_place.SNAME, banner_place.DEFAULT_IMAGE FROM `banner_place` WHERE banner_place.SNAME='top' LIMIT 1
SELECT project_setting.ID, project_setting.SETTING_KEY, project_setting.SETTING_VALUE FROM `project_setting` WHERE project_setting.SETTING_KEY='default_city_id' LIMIT 1
SELECT city.ID, city.NAME, city.SNAME, city.DESCRIPTION, city.MAIN_MENU, city.ORDERING, city.SITE_TITLE, city.ZONE, city.CREATED_AT, city.UPDATED_AT FROM `city` WHERE city.ID<>'1' AND city.MAIN_MENU=1 ORDER BY city.ORDERING ASC,city.NAME ASC
SELECT club.*, vip_club.id is null as isnull FROM `club` LEFT JOIN vip_club ON (club.ID=vip_club.CLUB_ID and vip_club.show_begin < '2026-04-19' and vip_club.show_end > '2026-04-19' ) WHERE club.INVISIBLE !=1 ORDER BY club.city_id, isnull,vip_club.vip_type, club.COUNT_ARTICLES DESC,club.COUNT_MEMBERS DESC
SELECT static_page.ID, static_page.TITLE, static_page.SHOW_TITLE, static_page.URL, static_page.TEXT, static_page.PICTURE, static_page.HAS_TEMPLATE, static_page.SITE_TITLE, static_page.CREATED_AT, static_page.UPDATED_AT, static_page.REDIRECT_CASE FROM `static_page` WHERE static_page.URL='users' LIMIT 1
SELECT project_setting.ID, project_setting.SETTING_KEY, project_setting.SETTING_VALUE FROM `project_setting` WHERE project_setting.SETTING_KEY='default_city_id' LIMIT 1
SELECT game.*, vip_club.id is null as isnull FROM `game` LEFT JOIN `club` ON game.club_id = club.id LEFT JOIN vip_club ON (club.ID=vip_club.CLUB_ID and vip_club.show_begin < '2026-04-19' and vip_club.show_end > '2026-04-19' ) WHERE club.INVISIBLE !=1 AND game.city_id = '1' AND game.in_menu = 1 AND game.time_begin > '2026-04-19' and game.time_begin < '2026-04-26' ORDER BY isnull,vip_club.vip_type, club.COUNT_ARTICLES DESC,club.COUNT_MEMBERS DESC
SELECT city.ID, city.NAME, city.SNAME, city.DESCRIPTION, city.MAIN_MENU, city.ORDERING, city.SITE_TITLE, city.ZONE, city.CREATED_AT, city.UPDATED_AT FROM `city`, `game` WHERE game.IN_MENU=1 AND game.TIME_BEGIN>='2026-04-19 00:00:00' AND game.CITY_ID=city.ID GROUP BY city.ID ORDER BY game.CITY_ID ASC,game.TIME_BEGIN ASC
SELECT city.ID, city.NAME, city.SNAME, city.DESCRIPTION, city.MAIN_MENU, city.ORDERING, city.SITE_TITLE, city.ZONE, city.CREATED_AT, city.UPDATED_AT FROM `city` WHERE city.ORDERING<1 ORDER BY city.ORDERING DESC LIMIT 1
SELECT city.ID, city.NAME, city.SNAME, city.DESCRIPTION, city.MAIN_MENU, city.ORDERING, city.SITE_TITLE, city.ZONE, city.CREATED_AT, city.UPDATED_AT FROM `city` ORDER BY city.ORDERING DESC LIMIT 1
SELECT city.ID, city.NAME, city.SNAME, city.DESCRIPTION, city.MAIN_MENU, city.ORDERING, city.SITE_TITLE, city.ZONE, city.CREATED_AT, city.UPDATED_AT FROM `city` WHERE city.ORDERING>1 ORDER BY city.ORDERING ASC LIMIT 1
SELECT ips_cityes.ID, ips_cityes.FIRST_IP, ips_cityes.LAST_IP, ips_cityes.CITY_ID, ips_cityes.CITY_NAME, ips_cityes.REGION, ips_cityes.ZONE FROM `ips_cityes` WHERE ips_cityes.FIRST_IP<=3628718411 AND ips_cityes.LAST_IP>=3628718411 ORDER BY ips_cityes.ID DESC LIMIT 1
SELECT banner.ID, banner.NAME, banner.SNAME, banner.BANNER_PLACE_ID, banner.CITY_ID, banner.HTMLCODE, banner.ZONE, banner.SHOW_BEGIN, banner.SHOW_END, banner.COUNT_VIEWS, banner.COUNT_CLICKS FROM `banner`, `banner_place` WHERE banner.CITY_ID=1 AND banner_place.SNAME='right' AND (banner.SHOW_BEGIN<='2026-04-19' OR banner.SHOW_BEGIN IS NULL ) AND (banner.SHOW_END>='2026-04-19' OR banner.SHOW_END IS NULL ) AND banner_place.ID=banner.BANNER_PLACE_ID
SELECT banner_place.ID, banner_place.NAME, banner_place.SNAME, banner_place.DEFAULT_IMAGE FROM `banner_place` WHERE banner_place.SNAME='right' LIMIT 1

Мафиози Мира Мафии

Configuration

Request

Response

User

Settings

Globals

Php

Symfony

Logs

Timers

SQL queries