---
parameterHolder: 
  symfony/default: 
    action: latest
    module: galleries
    start: 180
    type: movie
attributeHolder: 
  symfony/default: 

---
cookies: 
  lt: 
    name: lt
    value: >
      %B7%AE%19S%A8%B5%23%8D%1FB%12%1E%BDm%BF%20%E6%1DD%D2%F8%E7%E5j%99cJ%A8%C2%B2%D1%81%A8H%8F_%B3%DA%08D%90%B3i%AF%9B%7F%1C_
    expire: 1369169267
    path: /
    domain: 
    secure: 
    httpOnly: 
  st: 
    name: st
    value: >
      %F9b%85%E8%FD%C5%3En%C8%24%3F%B8%98P%7D%C1%18%9CX5%B7%28%DA%A9%03%BE%1F%C2%A8%0D%B8%9619%5D%F6%A7%5C%8E%F5
    expire: 1337719667
    path: /
    domain: 
    secure: 
    httpOnly: 
httpHeaders: 
  Content-Type: text/html; charset=utf-8
parameterHolder: 
  helper/asset/auto/httpmeta: 
    Content-Type: text/html; charset=utf-8
  helper/asset/auto/javascript: 
    /sf/sf_web_debug/js/main: /sf/sf_web_debug/js/main
    jq/jquery-1.3.min.js: jq/jquery-1.3.min.js
    jq/jquery.rotateimg.min.js: jq/jquery.rotateimg.min.js
    jq/jquery.searchbox.min.js: jq/jquery.searchbox.min.js
  helper/asset/auto/meta: 
    description: >
      Sxx.com gives you free xxx pictures from
      the best xxx websites. Find millions of
      adult pictures at no cost.
    keywords: >
      sxx, sxx.com, gogoporn, search, porn,
      find, adult, xxx, movies, sex
    language: en
    robots: index, follow
    title: Sxx.com - Latest XXX Movie Galleries
  helper/asset/auto/stylesheet: 
    /sf/sf_web_debug/css/main: 
    skin1/main.css: 
  symfony/response/http/headers: 
    Content-Type: text/html; charset=utf-8
  symfony/view/asset: 
    javascripts_included: 
    stylesheets_included: 
  tracking: 
    campaign: 
    first_visit: 2012-05-21
    last_visit: 2012-05-21
    product_id: 1
    program_id: 1
    publisher_id: 0
    visit_count: 0

---
app_campreviews_urls: 
  - http://dev.sxx.com/campreviews/
app_captcha_alphabet: abcdefghjkmnptwxyz234678
app_captcha_length: 6
app_geoip_mode: 2
app_geoip_path: /usr/share/GeoIP/GeoIP.dat
app_options_advanced: 
  date: 
    - Anytime
    - past 24 hour
    - past week
    - past month
    - past 2 months
    - past 3 months
    - past 6 months
    - past year
  sort: 
    - Most Recent
    - Most Relevant
    - Longest
    - Best Rated
    - Most Viewed
  media_duration: 
    - All
    - 30 seconds
    - 1 minute
    - 2 minutes
    - 5 minutes
  media_type: 
    - All
    - wmv
    - mpg
    - mov
    - avi
  media_count_photo: 
    - All
    - 10+
    - 20+
    - 30+
  media_count_movie: 
    - All
    - 3+
    - 5+
  media_resolution_photo: 
    - All
    - 480x640 +
    - 600x800 +
    - 768x1024 +
  media_resolution_movie: 
    - All
    - 320x240 +
    - 480x360 +
    - 640x480 +
app_pornstarpreviews_urls: 
  - http://dev.sxx.com/pornstarpreviews/
app_previews_urls: 
  - http://dev.sxx.com/content/thumbs/
app_query_other: 
  adv: 0
  view: thumbs
  newwin: 1
  jb: 1
  rot: 1
  ff: 0
  pid: 0
app_query_param: 
  q: 
  num: 20
  start: 0
  type: 1
  sort: 0
  date: 0
  fr: 0
  mt: 0
  mc: 0
  md: 0
  ma: 0
  mr: 0
  c: search
  max_results: 1000
app_query_recent_days: 7
app_search_advanced: 
  date: 
    - 0
    - -1 day
    - -7 day
    - -1 month
    - -2 months
    - -3 months
    - -6 months
    - -1 year
  sort: 
    - 0
    - 1
    - 2
    - 3
    - 4
  media_duration: 
    - 0
    - 30
    - 60
    - 120
    - 300
  media_type: 
    - 0
    - 3
    - 1
    - 2
    - 4
  media_count_photo: 
    - 0
    - 10
    - 20
    - 30
  media_count_movie: 
    - 0
    - 3
    - 5
  media_resolution_photo: 
    - 
      width: 0
      height: 0
    - 
      width: 480
      height: 640
    - 
      width: 600
      height: 800
    - 
      width: 768
      height: 1024
  media_resolution_movie: 
    - 
      width: 0
      height: 0
    - 
      width: 320
      height: 240
    - 
      width: 480
      height: 360
    - 
      width: 640
      height: 480
app_search_sphinx: 
  host: devsxxb
  port: 3312
  retrycount: 1
  retrydelay: 5
  matchmode: 4
  weights: 
  sortby: 
  filters: 
  groupby: 
  groupfunc: SPH_GROUPBY_DAY
  groupsort: @group desc
  maxmatches: 1000
  use_memcached: 
app_settings_options: 
  ff: 
    - Straight and Gay
    - Straight Only
    - Gay Only
  rot: 
    - No
    - Yes
  newwin: 
    - No
    - Yes
  jb: 
    - No
    - Yes
  num: 
    - 10
    - 20
    - 30
    - 40
    - 50
    - 100
app_sitepreviews_urls: 
  - http://dev.sxx.com/sitepreviews/
app_tubepreviews_urls: 
  - http://dev.sxx.com/content/tubepreviews/
mod_galleries_enabled: 1
mod_galleries_is_internal: 
mod_galleries_view_class: sfPHP
sf_admin_web_dir: /sf/sf_admin
sf_app: www
sf_app_config_dir: /www/private/symfony/sxx/apps/www/config
sf_app_config_dir_name: config
sf_app_dir: /www/private/symfony/sxx/apps/www
sf_app_i18n_dir: /www/private/symfony/sxx/apps/www/i18n
sf_app_i18n_dir_name: i18n
sf_app_lib_dir: /www/private/symfony/sxx/apps/www/lib
sf_app_lib_dir_name: lib
sf_app_module_action_dir_name: actions
sf_app_module_config_dir_name: config
sf_app_module_dir: >
  /www/private/symfony/sxx/apps/www/modules
sf_app_module_dir_name: modules
sf_app_module_i18n_dir_name: i18n
sf_app_module_lib_dir_name: lib
sf_app_module_template_dir_name: templates
sf_app_module_validate_dir_name: validate
sf_app_module_view_dir_name: views
sf_app_template_dir: >
  /www/private/symfony/sxx/apps/www/templates
sf_app_template_dir_name: templates
sf_apps_dir_name: apps
sf_autoloading_functions: 
sf_available: 1
sf_base_cache_dir: /www/private/symfony/sxx/cache/www
sf_bin_dir: /www/private/symfony/sxx/batch
sf_bin_dir_name: batch
sf_cache: 
sf_cache_dir: >
  /www/private/symfony/sxx/cache/www/devdebug
sf_cache_dir_name: cache
sf_calendar_web_dir: /sf/calendar
sf_charset: utf-8
sf_check_lock: 
sf_check_symfony_version: 
sf_compressed: 1
sf_config_cache_dir: >
  /www/private/symfony/sxx/cache/www/devdebug/config
sf_config_dir: /www/private/symfony/sxx/config
sf_config_dir_name: config
sf_data_dir: /www/private/symfony/sxx/data
sf_data_dir_name: data
sf_debug: 1
sf_default_action: index
sf_default_module: tracking
sf_doc_dir: /www/private/symfony/sxx/data/doc
sf_doc_dir_name: doc
sf_enabled_modules: 
  - default
  - sfAdvMemCachePlugin
sf_environment: devdebug
sf_error_404_action: error404
sf_error_404_module: search
sf_error_reporting: 4095
sf_escaping_method: ESC_ENTITIES
sf_escaping_strategy: bc
sf_etag: 
sf_i18n: 
sf_i18n_cache_dir: >
  /www/private/symfony/sxx/cache/www/devdebug/i18n
sf_lib_dir: /www/private/symfony/sxx/lib
sf_lib_dir_name: lib
sf_log_dir: /www/private/symfony/sxx/log
sf_log_dir_name: log
sf_logging_enabled: 1
sf_logging_history: 10
sf_logging_level: debug
sf_logging_period: 7
sf_logging_purge: 1
sf_logging_rotate: 
sf_login_action: login
sf_login_module: default
sf_max_forwards: 5
sf_model_dir_name: model
sf_model_lib_dir: /www/private/symfony/sxx/lib/model
sf_module_cache_dir: >
  /www/private/symfony/sxx/cache/www/devdebug/modules
sf_module_disabled_action: disabled
sf_module_disabled_module: default
sf_no_script_name: 
sf_orm: doctrine
sf_path_info_array: SERVER
sf_path_info_key: PATH_INFO
sf_plugins_dir: /www/private/symfony/sxx/plugins
sf_plugins_dir_name: plugins
sf_prototype_web_dir: /sf/prototype
sf_rich_text_js_dir: js/tiny_mce
sf_root_cache_dir: /www/private/symfony/sxx/cache
sf_root_dir: /www/private/symfony/sxx
sf_routing_defaults: 
  sf_culture: en
sf_secure_action: secure
sf_secure_module: default
sf_standard_helpers: 
  - Partial
  - Cache
  - Form
sf_strip_comments: 1
sf_suffix: .
sf_symfony_data_dir: /usr/share/pear/data/symfony
sf_symfony_lib_dir: /usr/share/pear/symfony
sf_template_cache_dir: >
  /www/private/symfony/sxx/cache/www/devdebug/template
sf_test: 
sf_test_cache_dir: >
  /www/private/symfony/sxx/cache/www/devdebug/test
sf_test_dir: /www/private/symfony/sxx/test
sf_test_dir_name: test
sf_timeout: 1800
sf_timer_start: 1337633267.0022
sf_unavailable_action: unavailable
sf_unavailable_module: default
sf_upload_dir: /www/private/symfony/sxx/web/uploads
sf_upload_dir_name: uploads
sf_url_format: PATH
sf_use_database: 1
sf_use_flash: 
sf_use_process_cache: 1
sf_use_security: 1
sf_validation_error_class: form_error
sf_validation_error_id_prefix: error_for_
sf_validation_error_prefix:  ↓ 
sf_validation_error_suffix:   ↓
sf_web_debug: 1
sf_web_debug_web_dir: /sf/sf_web_debug
sf_web_dir: /www/private/symfony/sxx/web
sf_web_dir_name: web

---
cookie: 
env: 
  LANG: C
  PATH: /sbin:/usr/sbin:/bin:/usr/bin
  PWD: /
  SHLVL: 2
  TERM: vt100
  _: /usr/sbin/httpd
files: 
get: 
post: 
server: 
  DOCUMENT_ROOT: /www/dev.sxx.com
  GATEWAY_INTERFACE: CGI/1.1
  GEOIP_ADDR: 38.107.179.209
  GEOIP_CONTINENT_CODE: NA
  GEOIP_COUNTRY_CODE: US
  GEOIP_COUNTRY_NAME: United States
  HTTP_ACCEPT: >
    text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
  HTTP_ACCEPT_CHARSET: ISO-8859-1,utf-8;q=0.7,*;q=0.7
  HTTP_ACCEPT_ENCODING: gzip
  HTTP_ACCEPT_LANGUAGE: en-us,en;q=0.5
  HTTP_CACHE_CONTROL: no-cache
  HTTP_CONNECTION: close
  HTTP_HOST: dev.sxx.com
  HTTP_PRAGMA: no-cache
  HTTP_USER_AGENT: >
    CCBot/1.0
    (+http://www.commoncrawl.org/bot.html)
  HTTP_X_CC_ID: ccc01-01
  PATH: /sbin:/usr/sbin:/bin:/usr/bin
  PATH_INFO: /galleries/latest/type/movie/start/180
  PATH_TRANSLATED: >
    /www/dev.sxx.com/galleries/latest/type/movie/start/180
  PHP_SELF: >
    /index.php/galleries/latest/type/movie/start/180
  QUERY_STRING: 
  REMOTE_ADDR: 38.107.179.209
  REMOTE_PORT: 56623
  REQUEST_METHOD: GET
  REQUEST_TIME: 1337633267
  REQUEST_URI: >
    /index.php/galleries/latest/type/movie/start/180
  SCRIPT_FILENAME: /www/dev.sxx.com/index.php
  SCRIPT_NAME: /index.php
  SCRIPT_URI: >
    http://dev.sxx.com/index.php/galleries/latest/type/movie/start/180
  SCRIPT_URL: >
    /index.php/galleries/latest/type/movie/start/180
  SERVER_ADDR: 66.152.93.30
  SERVER_ADMIN: root@localhost
  SERVER_NAME: dev.sxx.com
  SERVER_PORT: 80
  SERVER_PROTOCOL: HTTP/1.1
  SERVER_SIGNATURE: |
    <address>Apache/2.2.8 (EL) Server at dev.sxx.com Port 80</address>
    
  SERVER_SOFTWARE: Apache/2.2.8 (EL)
session: 

---
php: 5.2.6
os: >
  Linux devsxx.gammae.com
  2.6.18-194.11.4.el5.centos.plus #1 SMP
  Wed Sep 22 11:16:27 EDT 2010 i686
extensions: 
  - libxml
  - xml
  - wddx
  - tokenizer
  - sysvshm
  - sysvsem
  - sysvmsg
  - session
  - pcre
  - SimpleXML
  - sockets
  - SPL
  - shmop
  - standard
  - Reflection
  - pspell
  - posix
  - iconv
  - hash
  - gmp
  - gettext
  - ftp
  - filter
  - exif
  - date
  - curl
  - ctype
  - calendar
  - bz2
  - zlib
  - openssl
  - apache2handler
  - bcmath
  - dbase
  - dom
  - eAccelerator
  - gd
  - imap
  - json
  - mbstring
  - mcrypt
  - memcache
  - mhash
  - mysql
  - mysqli
  - PDO
  - pdo_mysql
  - pdo_sqlite
  - tidy
  - xmlreader
  - xmlwriter
  - xsl
  - zip
  - Zend Optimizer

1. INSERT INTO logs_hits_1 (publisher_id, product_id, program_id, long_ip, country_code, visit_count, campaign, origin, created_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) - (0, 1, 1, 644592593, US, 0, , galleries, 2012-05-21 16:47:47 )
2. SELECT g.id AS g__id, g.url AS g__url, g.title AS g__title, g.description AS g__description, g.type AS g__type, g.thumbs AS g__thumbs, g.media_type AS g__media_type, g.media_width AS g__media_width, g.media_height AS g__media_height, g.media_count AS g__media_count, g.media_duration AS g__media_duration, g.media_audio AS g__media_audio, g.md5_url AS g__md5_url, g.md5_content AS g__md5_content, g.site_id AS g__site_id, g.sponsor_id AS g__sponsor_id, g.flag_gay AS g__flag_gay, g.status AS g__status, g.created_at AS g__created_at, s.id AS s__id, s.name AS s__name, s.domain AS s__domain, s.sponsor_id AS s__sponsor_id, s.flag_gay AS s__flag_gay, s.gallery_count AS s__gallery_count, s.status AS s__status, s.created_at AS s__created_at, s.updated_at AS s__updated_at FROM gallery g LEFT JOIN site s ON g.site_id = s.id WHERE g.created_at >= DATE(DATE_SUB(NOW(),INTERVAL 2 WEEK)) AND g.created_at < DATE_SUB(NOW(),INTERVAL 30 SECOND) AND g.type = ? ORDER BY g.created_at DESC LIMIT 20 OFFSET 180 - (movie )