Configuration

debug
xdebug
logging
cache
compression
tokenizer
eaccelerator
apc
xcache

Request

options:
  path_info_key: PATH_INFO
  path_info_array: SERVER
  default_format: null
  logging: '1'
  relative_url_root: null
  formats: { txt: text/plain, js: [application/javascript, application/x-javascript, text/javascript], css: text/css, json: [application/json, application/x-json], xml: [text/xml, application/xml, application/x-xml], rdf: application/rdf+xml, atom: application/atom+xml }
  no_script_name: false
parameterHolder:
  action: authorList
  module: site
  page: '2'
  slug: festmeny
attributeHolder:
  sf_route: 'sfDoctrineRoute Object()'

Response

status:
  code: 200
  text: OK
options:
  http_protocol: HTTP/1.1
  logging: '1'
  charset: utf-8
  send_http_headers: false
  content_type: 'text/html; charset=utf-8'
cookies: {  }
httpHeaders:
  Content-Type: 'text/html; charset=utf-8'
javascripts:
  jquery-1.3.2.min.js: {  }
  jquery.carousel.js: {  }
  jquery.jcarousel.js: {  }
  jquery.tipsy.js: {  }
  apps.js: {  }
  menu.js: {  }
stylesheets:
  screen.css: {  }
  carousel.css: {  }
metas:
  title: 'VirtuArtNet - Festmény'
  description: VirtuArtNet
  keywords: 'virtuartnet, art, database, műtárgy, adatbázis'
  robots: 'index, follow'
httpMetas:
  Content-Type: 'text/html; charset=utf-8'

User

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

Settings

app_i18n_en_css: /css/en.css
mod_site_enabled: true
mod_site_view_class: sfPHP
mod_siteparts_enabled: true
mod_siteparts_view_class: sfPHP
sf_admin_module_web_dir: /sfDoctrinePlugin
sf_admin_web_dir: /sf/sf_admin
sf_app: frontend
sf_app_base_cache_dir: /home/virtuartnet/releases/2013-03-06T155106/cache/frontend
sf_app_cache_dir: /home/virtuartnet/releases/2013-03-06T155106/cache/frontend/dev
sf_app_config_dir: /home/virtuartnet/releases/2013-03-06T155106/apps/frontend/config
sf_app_dir: /home/virtuartnet/releases/2013-03-06T155106/apps/frontend
sf_app_i18n_dir: /home/virtuartnet/releases/2013-03-06T155106/apps/frontend/i18n
sf_app_lib_dir: /home/virtuartnet/releases/2013-03-06T155106/apps/frontend/lib
sf_app_module_dir: /home/virtuartnet/releases/2013-03-06T155106/apps/frontend/modules
sf_app_template_dir: /home/virtuartnet/releases/2013-03-06T155106/apps/frontend/templates
sf_apps_dir: /home/virtuartnet/releases/2013-03-06T155106/apps
sf_cache: on
sf_cache_dir: /home/virtuartnet/releases/2013-03-06T155106/cache
sf_charset: utf-8
sf_check_lock: false
sf_compressed: false
sf_config_cache_dir: /home/virtuartnet/releases/2013-03-06T155106/cache/frontend/dev/config
sf_config_dir: /home/virtuartnet/releases/2013-03-06T155106/config
sf_csrf_secret: axTTyze27279
sf_data_dir: /home/virtuartnet/releases/2013-03-06T155106/data
sf_debug: true
sf_default_culture: hu
sf_enabled_modules:
  - default
sf_environment: dev
sf_error_404_action: error404
sf_error_404_module: default
sf_error_reporting: 32759
sf_escaping_method: ESC_SPECIALCHARS
sf_escaping_strategy: on
sf_etag: false
sf_file_link_format: null
sf_i18n: on
sf_i18n_cache_dir: /home/virtuartnet/releases/2013-03-06T155106/cache/frontend/dev/i18n
sf_lazy_cache_key: on
sf_lib_dir: /home/virtuartnet/releases/2013-03-06T155106/lib
sf_log_dir: /home/virtuartnet/releases/2013-03-06T155106/log
sf_logging_enabled: true
sf_login_action: login
sf_login_module: default
sf_module_cache_dir: /home/virtuartnet/releases/2013-03-06T155106/cache/frontend/dev/modules
sf_module_disabled_action: disabled
sf_module_disabled_module: default
sf_no_script_name: false
sf_orm: doctrine
sf_plugins_dir: /home/virtuartnet/releases/2013-03-06T155106/plugins
sf_root_dir: /home/virtuartnet/releases/2013-03-06T155106
sf_secure_action: secure
sf_secure_module: default
sf_standard_helpers:
  - Partial
  - Cache
  - I18N
  - Date
sf_symfony_lib_dir: /home/virtuartnet/releases/2013-03-06T155106/lib/vendor/symfony/lib
sf_template_cache_dir: /home/virtuartnet/releases/2013-03-06T155106/cache/frontend/dev/template
sf_test_cache_dir: /home/virtuartnet/releases/2013-03-06T155106/cache/frontend/dev/test
sf_test_dir: /home/virtuartnet/releases/2013-03-06T155106/test
sf_upload_dir: /home/virtuartnet/releases/2013-03-06T155106/web/uploads
sf_use_database: true
sf_web_debug: true
sf_web_debug_web_dir: /sf/sf_web_debug
sf_web_dir: /home/virtuartnet/releases/2013-03-06T155106/web
symfony.asset.javascripts_included: false
symfony.asset.stylesheets_included: false

Globals

cookie: {  }
env: {  }
files: {  }
get:
  page: '2'
post: {  }
server:
  DOCUMENT_ROOT: /home/virtuartnet/current/web
  GATEWAY_INTERFACE: CGI/1.1
  HTTP_ACCEPT: '*/*'
  HTTP_ACCEPT_ENCODING: 'gzip, br, zstd, deflate'
  HTTP_HOST: virtuartnet.hu
  HTTP_USER_AGENT: 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'
  PATH: '/usr/local/bin:/usr/bin:/bin'
  PATH_INFO: /szerzok-kategoria-szerint/festmeny
  PATH_TRANSLATED: 'redirect:/index.php/festmeny'
  PHP_SELF: /frontend_dev.php/szerzok-kategoria-szerint/festmeny
  QUERY_STRING: page=2
  REMOTE_ADDR: 18.217.96.88
  REMOTE_PORT: '52263'
  REQUEST_METHOD: GET
  REQUEST_TIME: 1745071659
  REQUEST_TIME_FLOAT: 1745071659.292
  REQUEST_URI: /frontend_dev.php/szerzok-kategoria-szerint/festmeny?page=2
  SCRIPT_FILENAME: /home/virtuartnet/current/web/frontend_dev.php
  SCRIPT_NAME: /frontend_dev.php
  SERVER_ADDR: 195.56.240.69
  SERVER_ADMIN: '[no address given]'
  SERVER_NAME: virtuartnet.hu
  SERVER_PORT: '80'
  SERVER_PROTOCOL: HTTP/1.1
  SERVER_SIGNATURE: ''
  SERVER_SOFTWARE: Apache
session: {  }

Php

php: 5.4.45-0+deb7u14
os: 'Linux tade 3.2.0-6-amd64 #1 SMP Debian 3.2.102-1 x86_64'
extensions:
  41: apache2handler
  7: bcmath
  8: bz2
  9: calendar
  0: 'Core (5.4.45-0+deb7u14)'
  10: ctype
  43: curl
  1: 'date (5.4.45-0+deb7u14)'
  11: dba
  12: 'dom (20031129)'
  2: ereg
  31: 'exif (1.4 $Id: 05041c5f0094cb46d9b516bd624d593b90cc38f9 $)'
  14: 'fileinfo (1.0.5)'
  15: 'filter (0.11.0)'
  16: ftp
  44: gd
  17: gettext
  13: 'hash (1.0)'
  19: iconv
  58: 'imagick (3.1.0RC1)'
  45: imap
  46: 'intl (1.1.0)'
  20: 'json (1.2.1)'
  47: ldap
  3: libxml
  21: mbstring
  48: mcrypt
  60: mhash
  49: 'mysql (1.0)'
  50: 'mysqli (0.1)'
  4: openssl
  5: pcre
  42: 'PDO (1.0.4dev)'
  51: 'pdo_mysql (1.0.2)'
  52: 'pdo_pgsql (1.0.2)'
  53: 'pdo_sqlite (1.0.1)'
  54: pgsql
  30: 'Phar (2.0.1)'
  59: 'phpwkhtmltox (0.10)'
  23: posix
  24: 'Reflection ($Id: f6367cdb4e3f392af4a6d441a6641de87c2e50c4 $)'
  22: session
  26: shmop
  27: 'SimpleXML (0.1)'
  28: soap
  29: sockets
  18: 'SPL (0.2)'
  55: 'sqlite3 (0.7)'
  25: 'standard (5.4.45-0+deb7u14)'
  32: sysvmsg
  33: sysvsem
  34: sysvshm
  35: 'tokenizer (0.1)'
  36: wddx
  37: xml
  38: 'xmlreader (0.1)'
  56: 'xmlrpc (0.51)'
  39: 'xmlwriter (0.1)'
  57: 'xsl (0.1)'
  40: 'zip (1.11.0)'
  6: 'zlib (2.0)'

Symfony

version: 1.4.2
path: /home/virtuartnet/releases/2013-03-06T155106/lib/vendor/symfony/lib

View Layer

Template: site … authorListSuccess.php

Parameters:

$category (Category)
$pager (vaPager)

Partial: site … _authorPreview.php

Partial: siteParts … _mainMenu.php

Partial: siteParts … _languageBar.php

Logs

#	type	message
1	zxPatternI18NRouting	Connect sfDoctrineRoute "exhibition_view_en" (/exhibition/:id)
2	zxPatternI18NRouting	Connect sfDoctrineRoute "childrencorner_view_en" (/kids-corner/:id)
3	zxPatternI18NRouting	Connect sfRoute "exhibition_list_en" (/exhibitions)
4	zxPatternI18NRouting	Connect sfRoute "childrencorner_list_en" (/kids-corners)
5	zxPatternI18NRouting	Connect sfRoute "contact_en" (/contact)
6	zxPatternI18NRouting	Connect sfRoute "search_en" (/search)
7	zxPatternI18NRouting	Connect sfDoctrineRoute "article_view_en" (/article/:id)
8	zxPatternI18NRouting	Connect sfDoctrineRoute "exhibition_item_details_en" (/author/:author_slug/item/:id)
9	zxPatternI18NRouting	Connect sfDoctrineRoute "item_details_en" (/author/:author_slug/piece/:id)
10	zxPatternI18NRouting	Connect sfDoctrineRoute "author_categories_en" (/author/:slug)
11	zxPatternI18NRouting	Connect sfDoctrineRoute "author_profile_en" (/author/:slug/biography)
12	zxPatternI18NRouting	Connect sfRoute "authors_list_en" (/authors)
13	zxPatternI18NRouting	Connect sfDoctrineRoute "authors_by_category_list_en" (/authors-by-category/:slug)
14	zxPatternI18NRouting	Connect sfRoute "homepage_en_en" (/en//)
15	zxPatternI18NRouting	Connect sfRoute "homepage_en" (//)
16	zxPatternI18NRouting	Match route "authors_by_category_list" (/szerzok-kategoria-szerint/:slug) for /szerzok-kategoria-szerint/festmeny with parameters array ( 'module' => 'site', 'action' => 'authorList', 'slug' => 'festmeny',)
17	sfFilterChain	Executing filter "sfRenderingFilter"
18	sfFilterChain	Executing filter "setEnglishCssFilter"
19	sfFilterChain	Executing filter "sfCacheFilter"
20	sfFilterChain	Executing filter "sfCommonFilter"
21	sfFilterChain	Executing filter "sfExecutionFilter"
22	siteActions	Call "siteActions->executeAuthorList()"
23	Doctrine_Connection_Pgsql	exec : SET NAMES 'UTF8' - ()
24	Doctrine_Connection_Statement	execute : SELECT c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug FROM category c LEFT JOIN category_translation c2 ON c.id = c2.id WHERE (c2.slug = ?) - (festmeny)
25	Doctrine_Connection_Statement	execute : SELECT MAX(i.id) AS i__0, i.author_id AS i__1 FROM item i LEFT JOIN author a ON i.author_id = a.id WHERE ((i.is_active IS TRUE AND i.in_stock IS TRUE) AND i.category_id = ?) GROUP BY i.author_id, a.name ORDER BY a.name ASC - (1)
26	sfPHPView	Render "sf_app_dir/modules/site/templates/authorListSuccess.php"
27	Doctrine_Connection_Statement	execute : SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = ?) - (82)
28	sfPartialView	Render "sf_app_dir/modules/site/templates/_authorPreview.php"
29	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT i.id FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i2.lang = ? AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = ? AND i.category_id = ?) GROUP BY i.id) dctrn_count_query - (hu, 82, 1)
30	sfOther	author-items-for-listing-by-category; count-1: 10
31	Doctrine_Connection_Statement	execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i6.created_at FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = ? AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = ? AND i6.category_id = ?) ORDER BY i6.created_at DESC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = ? AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = ? AND i.category_id = ?)) ORDER BY i.created_at DESC - (hu, 82, 1, hu, 82, 1)
32	sfOther	author-items-for-listing-by-category; needed, found-new: 4, 0
33	Doctrine_Connection_Statement	execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i9.order_index FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = ? AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = ? AND i6.category_id = ?) AND (i9.author_id = ? AND i9.category_id = ?) ORDER BY i9.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = ? AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = ? AND i.category_id = ?) AND (i4.author_id = ? AND i4.category_id = ?)) ORDER BY i4.order_index ASC - (hu, 82, 1, 82, 1, hu, 82, 1, 82, 1)
34	sfViewCacheManager	Cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_hu_category_id_1_author_id_82" exists
35	Doctrine_Connection_Statement	execute : SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = ?) - (41)
36	sfPartialView	Render "sf_app_dir/modules/site/templates/_authorPreview.php"
37	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT i.id FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i2.lang = ? AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = ? AND i.category_id = ?) GROUP BY i.id) dctrn_count_query - (hu, 41, 1)
38	sfOther	author-items-for-listing-by-category; count-1: 7
39	Doctrine_Connection_Statement	execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i6.created_at FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = ? AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = ? AND i6.category_id = ?) ORDER BY i6.created_at DESC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = ? AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = ? AND i.category_id = ?)) ORDER BY i.created_at DESC - (hu, 41, 1, hu, 41, 1)
40	sfOther	author-items-for-listing-by-category; needed, found-new: 4, 0
41	Doctrine_Connection_Statement	execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i9.order_index FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = ? AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = ? AND i6.category_id = ?) AND (i9.author_id = ? AND i9.category_id = ?) ORDER BY i9.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = ? AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = ? AND i.category_id = ?) AND (i4.author_id = ? AND i4.category_id = ?)) ORDER BY i4.order_index ASC - (hu, 41, 1, 41, 1, hu, 41, 1, 41, 1)
42	sfViewCacheManager	Cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_hu_category_id_1_author_id_41" exists
43	Doctrine_Connection_Statement	execute : SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = ?) - (7)
44	sfPartialView	Render "sf_app_dir/modules/site/templates/_authorPreview.php"
45	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT i.id FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i2.lang = ? AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = ? AND i.category_id = ?) GROUP BY i.id) dctrn_count_query - (hu, 7, 1)
46	sfOther	author-items-for-listing-by-category; count-1: 12
47	Doctrine_Connection_Statement	execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i6.created_at FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = ? AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = ? AND i6.category_id = ?) ORDER BY i6.created_at DESC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = ? AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = ? AND i.category_id = ?)) ORDER BY i.created_at DESC - (hu, 7, 1, hu, 7, 1)
48	sfOther	author-items-for-listing-by-category; needed, found-new: 4, 0
49	Doctrine_Connection_Statement	execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i9.order_index FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = ? AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = ? AND i6.category_id = ?) AND (i9.author_id = ? AND i9.category_id = ?) ORDER BY i9.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = ? AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = ? AND i.category_id = ?) AND (i4.author_id = ? AND i4.category_id = ?)) ORDER BY i4.order_index ASC - (hu, 7, 1, 7, 1, hu, 7, 1, 7, 1)
50	sfViewCacheManager	Cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_hu_category_id_1_author_id_7" exists
51	Doctrine_Connection_Statement	execute : SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = ?) - (75)
52	sfPartialView	Render "sf_app_dir/modules/site/templates/_authorPreview.php"
53	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT i.id FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i2.lang = ? AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = ? AND i.category_id = ?) GROUP BY i.id) dctrn_count_query - (hu, 75, 1)
54	sfOther	author-items-for-listing-by-category; count-1: 8
55	Doctrine_Connection_Statement	execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i6.created_at FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = ? AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = ? AND i6.category_id = ?) ORDER BY i6.created_at DESC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = ? AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = ? AND i.category_id = ?)) ORDER BY i.created_at DESC - (hu, 75, 1, hu, 75, 1)
56	sfOther	author-items-for-listing-by-category; needed, found-new: 4, 0
57	Doctrine_Connection_Statement	execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i9.order_index FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = ? AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = ? AND i6.category_id = ?) AND (i9.author_id = ? AND i9.category_id = ?) ORDER BY i9.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = ? AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = ? AND i.category_id = ?) AND (i4.author_id = ? AND i4.category_id = ?)) ORDER BY i4.order_index ASC - (hu, 75, 1, 75, 1, hu, 75, 1, 75, 1)
58	sfViewCacheManager	Cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_hu_category_id_1_author_id_75" exists
59	Doctrine_Connection_Statement	execute : SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = ?) - (37)
60	sfPartialView	Render "sf_app_dir/modules/site/templates/_authorPreview.php"
61	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT i.id FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i2.lang = ? AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = ? AND i.category_id = ?) GROUP BY i.id) dctrn_count_query - (hu, 37, 1)
62	sfOther	author-items-for-listing-by-category; count-1: 11
63	Doctrine_Connection_Statement	execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i6.created_at FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = ? AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = ? AND i6.category_id = ?) ORDER BY i6.created_at DESC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = ? AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = ? AND i.category_id = ?)) ORDER BY i.created_at DESC - (hu, 37, 1, hu, 37, 1)
64	sfOther	author-items-for-listing-by-category; needed, found-new: 4, 0
65	Doctrine_Connection_Statement	execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i9.order_index FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = ? AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = ? AND i6.category_id = ?) AND (i9.author_id = ? AND i9.category_id = ?) ORDER BY i9.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = ? AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = ? AND i.category_id = ?) AND (i4.author_id = ? AND i4.category_id = ?)) ORDER BY i4.order_index ASC - (hu, 37, 1, 37, 1, hu, 37, 1, 37, 1)
66	sfViewCacheManager	Cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_hu_category_id_1_author_id_37" exists
67	Doctrine_Connection_Statement	execute : SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = ?) - (45)
68	sfPartialView	Render "sf_app_dir/modules/site/templates/_authorPreview.php"
69	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT i.id FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i2.lang = ? AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = ? AND i.category_id = ?) GROUP BY i.id) dctrn_count_query - (hu, 45, 1)
70	sfOther	author-items-for-listing-by-category; count-1: 12
71	Doctrine_Connection_Statement	execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i6.created_at FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = ? AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = ? AND i6.category_id = ?) ORDER BY i6.created_at DESC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = ? AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = ? AND i.category_id = ?)) ORDER BY i.created_at DESC - (hu, 45, 1, hu, 45, 1)
72	sfOther	author-items-for-listing-by-category; needed, found-new: 4, 0
73	Doctrine_Connection_Statement	execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i9.order_index FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = ? AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = ? AND i6.category_id = ?) AND (i9.author_id = ? AND i9.category_id = ?) ORDER BY i9.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = ? AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = ? AND i.category_id = ?) AND (i4.author_id = ? AND i4.category_id = ?)) ORDER BY i4.order_index ASC - (hu, 45, 1, 45, 1, hu, 45, 1, 45, 1)
74	sfViewCacheManager	Cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_hu_category_id_1_author_id_45" exists
75	Doctrine_Connection_Statement	execute : SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = ?) - (85)
76	sfPartialView	Render "sf_app_dir/modules/site/templates/_authorPreview.php"
77	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT i.id FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i2.lang = ? AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = ? AND i.category_id = ?) GROUP BY i.id) dctrn_count_query - (hu, 85, 1)
78	sfOther	author-items-for-listing-by-category; count-1: 5
79	Doctrine_Connection_Statement	execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i6.created_at FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = ? AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = ? AND i6.category_id = ?) ORDER BY i6.created_at DESC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = ? AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = ? AND i.category_id = ?)) ORDER BY i.created_at DESC - (hu, 85, 1, hu, 85, 1)
80	sfOther	author-items-for-listing-by-category; needed, found-new: 4, 0
81	Doctrine_Connection_Statement	execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i9.order_index FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = ? AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = ? AND i6.category_id = ?) AND (i9.author_id = ? AND i9.category_id = ?) ORDER BY i9.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = ? AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = ? AND i.category_id = ?) AND (i4.author_id = ? AND i4.category_id = ?)) ORDER BY i4.order_index ASC - (hu, 85, 1, 85, 1, hu, 85, 1, 85, 1)
82	sfViewCacheManager	Cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_hu_category_id_1_author_id_85" exists
83	Doctrine_Connection_Statement	execute : SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = ?) - (105)
84	sfPartialView	Render "sf_app_dir/modules/site/templates/_authorPreview.php"
85	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT i.id FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i2.lang = ? AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = ? AND i.category_id = ?) GROUP BY i.id) dctrn_count_query - (hu, 105, 1)
86	sfOther	author-items-for-listing-by-category; count-1: 11
87	Doctrine_Connection_Statement	execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i6.created_at FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = ? AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = ? AND i6.category_id = ?) ORDER BY i6.created_at DESC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = ? AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = ? AND i.category_id = ?)) ORDER BY i.created_at DESC - (hu, 105, 1, hu, 105, 1)
88	sfOther	author-items-for-listing-by-category; needed, found-new: 4, 0
89	Doctrine_Connection_Statement	execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i9.order_index FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = ? AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = ? AND i6.category_id = ?) AND (i9.author_id = ? AND i9.category_id = ?) ORDER BY i9.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = ? AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = ? AND i.category_id = ?) AND (i4.author_id = ? AND i4.category_id = ?)) ORDER BY i4.order_index ASC - (hu, 105, 1, 105, 1, hu, 105, 1, 105, 1)
90	sfViewCacheManager	Cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_hu_category_id_1_author_id_105" exists
91	Doctrine_Connection_Statement	execute : SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = ?) - (11)
92	sfPartialView	Render "sf_app_dir/modules/site/templates/_authorPreview.php"
93	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT i.id FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i2.lang = ? AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = ? AND i.category_id = ?) GROUP BY i.id) dctrn_count_query - (hu, 11, 1)
94	sfOther	author-items-for-listing-by-category; count-1: 8
95	Doctrine_Connection_Statement	execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i6.created_at FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = ? AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = ? AND i6.category_id = ?) ORDER BY i6.created_at DESC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = ? AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = ? AND i.category_id = ?)) ORDER BY i.created_at DESC - (hu, 11, 1, hu, 11, 1)
96	sfOther	author-items-for-listing-by-category; needed, found-new: 4, 0
97	Doctrine_Connection_Statement	execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i9.order_index FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = ? AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = ? AND i6.category_id = ?) AND (i9.author_id = ? AND i9.category_id = ?) ORDER BY i9.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = ? AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = ? AND i.category_id = ?) AND (i4.author_id = ? AND i4.category_id = ?)) ORDER BY i4.order_index ASC - (hu, 11, 1, 11, 1, hu, 11, 1, 11, 1)
98	sfViewCacheManager	Cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_hu_category_id_1_author_id_11" exists
99	Doctrine_Connection_Statement	execute : SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = ?) - (106)
100	sfPartialView	Render "sf_app_dir/modules/site/templates/_authorPreview.php"
101	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT i.id FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i2.lang = ? AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = ? AND i.category_id = ?) GROUP BY i.id) dctrn_count_query - (hu, 106, 1)
102	sfOther	author-items-for-listing-by-category; count-1: 9
103	Doctrine_Connection_Statement	execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i6.created_at FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = ? AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = ? AND i6.category_id = ?) ORDER BY i6.created_at DESC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = ? AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = ? AND i.category_id = ?)) ORDER BY i.created_at DESC - (hu, 106, 1, hu, 106, 1)
104	sfOther	author-items-for-listing-by-category; needed, found-new: 4, 0
105	Doctrine_Connection_Statement	execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i9.order_index FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = ? AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = ? AND i6.category_id = ?) AND (i9.author_id = ? AND i9.category_id = ?) ORDER BY i9.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = ? AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = ? AND i.category_id = ?) AND (i4.author_id = ? AND i4.category_id = ?)) ORDER BY i4.order_index ASC - (hu, 106, 1, 106, 1, hu, 106, 1, 106, 1)
106	sfViewCacheManager	Cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_hu_category_id_1_author_id_106" exists
107	sfPHPView	Decorate content with "sf_app_dir/templates/layout.php"
108	sfPHPView	Render "sf_app_dir/templates/layout.php"
109	main	Call "siteParts->executeMainMenu()"
110	sfOther	menu-select: categories; route: authors_by_category_list
111	sfPartialView	Render "sf_app_dir/modules/siteParts/templates/_mainMenu.php"
112	sfViewCacheManager	Cache for "@sf_cache_partial?module=siteParts&action=_categoriesMenu&sf_cache_key=k_categories_menu_hu" exists
113	sfPartialView	Render "sf_app_dir/modules/siteParts/templates/_languageBar.php"
114	sfWebResponse	Send status "HTTP/1.1 200 OK"
115	sfWebResponse	Send header "Content-Type: text/html; charset=utf-8"

type	calls	time (ms)	time (%)
Configuration	15	154.04	5
Factories	1	74.71	2
Action "site/authorList"	1	869.10	32
Database (Doctrine)	43	0.31	0
View "Success" for "site/authorList"	1	1687.00	62
Partial "site/_authorPreview"	10	1623.31	60
Partial "site/_authorList_images"	1	13.01	0
Component "siteParts/mainMenu"	1	0.16	0
Partial "siteParts/_mainMenu"	1	1.94	0
Partial "siteParts/_languageBar"	1	0.58	0

SQL queries

Doctrine Version: 1.2.1

SET NAMES 'UTF8'

0.00s, "virtuartnet" connection
SELECT c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug FROM category c LEFT JOIN category_translation c2 ON c.id = c2.id WHERE (c2.slug = 'festmeny')

0.01s, "virtuartnet" connection
SELECT MAX(i.id) AS i__0, i.author_id AS i__1 FROM item i LEFT JOIN author a ON i.author_id = a.id WHERE ((i.is_active IS TRUE AND i.in_stock IS TRUE) AND i.category_id = 1) GROUP BY i.author_id, a.name ORDER BY a.name ASC

0.64s, "virtuartnet" connection
SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = 82)

0.00s, "virtuartnet" connection
SELECT COUNT(*) AS num_results FROM (SELECT i.id FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i2.lang = 'hu' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 82 AND i.category_id = 1) GROUP BY i.id) dctrn_count_query

0.01s, "virtuartnet" connection
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i6.created_at FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = 'hu' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 82 AND i6.category_id = 1) ORDER BY i6.created_at DESC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'hu' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 82 AND i.category_id = 1)) ORDER BY i.created_at DESC

0.01s, "virtuartnet" connection
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i9.order_index FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = 'hu' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 82 AND i6.category_id = 1) AND (i9.author_id = 82 AND i9.category_id = 1) ORDER BY i9.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'hu' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 82 AND i.category_id = 1) AND (i4.author_id = 82 AND i4.category_id = 1)) ORDER BY i4.order_index ASC

0.01s, "virtuartnet" connection
SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = 41)

0.00s, "virtuartnet" connection
SELECT COUNT(*) AS num_results FROM (SELECT i.id FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i2.lang = 'hu' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 41 AND i.category_id = 1) GROUP BY i.id) dctrn_count_query

0.00s, "virtuartnet" connection
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i6.created_at FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = 'hu' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 41 AND i6.category_id = 1) ORDER BY i6.created_at DESC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'hu' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 41 AND i.category_id = 1)) ORDER BY i.created_at DESC

0.01s, "virtuartnet" connection
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i9.order_index FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = 'hu' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 41 AND i6.category_id = 1) AND (i9.author_id = 41 AND i9.category_id = 1) ORDER BY i9.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'hu' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 41 AND i.category_id = 1) AND (i4.author_id = 41 AND i4.category_id = 1)) ORDER BY i4.order_index ASC

0.01s, "virtuartnet" connection
SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = 7)

0.00s, "virtuartnet" connection
SELECT COUNT(*) AS num_results FROM (SELECT i.id FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i2.lang = 'hu' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 7 AND i.category_id = 1) GROUP BY i.id) dctrn_count_query

0.00s, "virtuartnet" connection
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i6.created_at FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = 'hu' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 7 AND i6.category_id = 1) ORDER BY i6.created_at DESC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'hu' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 7 AND i.category_id = 1)) ORDER BY i.created_at DESC

0.01s, "virtuartnet" connection
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i9.order_index FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = 'hu' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 7 AND i6.category_id = 1) AND (i9.author_id = 7 AND i9.category_id = 1) ORDER BY i9.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'hu' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 7 AND i.category_id = 1) AND (i4.author_id = 7 AND i4.category_id = 1)) ORDER BY i4.order_index ASC

0.01s, "virtuartnet" connection
SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = 75)

0.00s, "virtuartnet" connection
SELECT COUNT(*) AS num_results FROM (SELECT i.id FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i2.lang = 'hu' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 75 AND i.category_id = 1) GROUP BY i.id) dctrn_count_query

0.01s, "virtuartnet" connection
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i6.created_at FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = 'hu' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 75 AND i6.category_id = 1) ORDER BY i6.created_at DESC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'hu' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 75 AND i.category_id = 1)) ORDER BY i.created_at DESC

0.01s, "virtuartnet" connection
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i9.order_index FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = 'hu' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 75 AND i6.category_id = 1) AND (i9.author_id = 75 AND i9.category_id = 1) ORDER BY i9.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'hu' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 75 AND i.category_id = 1) AND (i4.author_id = 75 AND i4.category_id = 1)) ORDER BY i4.order_index ASC

0.01s, "virtuartnet" connection
SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = 37)

0.00s, "virtuartnet" connection
SELECT COUNT(*) AS num_results FROM (SELECT i.id FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i2.lang = 'hu' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 37 AND i.category_id = 1) GROUP BY i.id) dctrn_count_query

0.01s, "virtuartnet" connection
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i6.created_at FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = 'hu' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 37 AND i6.category_id = 1) ORDER BY i6.created_at DESC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'hu' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 37 AND i.category_id = 1)) ORDER BY i.created_at DESC

0.01s, "virtuartnet" connection
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i9.order_index FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = 'hu' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 37 AND i6.category_id = 1) AND (i9.author_id = 37 AND i9.category_id = 1) ORDER BY i9.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'hu' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 37 AND i.category_id = 1) AND (i4.author_id = 37 AND i4.category_id = 1)) ORDER BY i4.order_index ASC

0.01s, "virtuartnet" connection
SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = 45)

0.00s, "virtuartnet" connection
SELECT COUNT(*) AS num_results FROM (SELECT i.id FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i2.lang = 'hu' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 45 AND i.category_id = 1) GROUP BY i.id) dctrn_count_query

0.00s, "virtuartnet" connection
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i6.created_at FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = 'hu' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 45 AND i6.category_id = 1) ORDER BY i6.created_at DESC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'hu' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 45 AND i.category_id = 1)) ORDER BY i.created_at DESC

0.01s, "virtuartnet" connection
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i9.order_index FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = 'hu' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 45 AND i6.category_id = 1) AND (i9.author_id = 45 AND i9.category_id = 1) ORDER BY i9.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'hu' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 45 AND i.category_id = 1) AND (i4.author_id = 45 AND i4.category_id = 1)) ORDER BY i4.order_index ASC

0.01s, "virtuartnet" connection
SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = 85)

0.00s, "virtuartnet" connection
SELECT COUNT(*) AS num_results FROM (SELECT i.id FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i2.lang = 'hu' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 85 AND i.category_id = 1) GROUP BY i.id) dctrn_count_query

0.00s, "virtuartnet" connection
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i6.created_at FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = 'hu' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 85 AND i6.category_id = 1) ORDER BY i6.created_at DESC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'hu' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 85 AND i.category_id = 1)) ORDER BY i.created_at DESC

0.01s, "virtuartnet" connection
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i9.order_index FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = 'hu' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 85 AND i6.category_id = 1) AND (i9.author_id = 85 AND i9.category_id = 1) ORDER BY i9.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'hu' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 85 AND i.category_id = 1) AND (i4.author_id = 85 AND i4.category_id = 1)) ORDER BY i4.order_index ASC

0.01s, "virtuartnet" connection
SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = 105)

0.00s, "virtuartnet" connection
SELECT COUNT(*) AS num_results FROM (SELECT i.id FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i2.lang = 'hu' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 105 AND i.category_id = 1) GROUP BY i.id) dctrn_count_query

0.00s, "virtuartnet" connection
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i6.created_at FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = 'hu' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 105 AND i6.category_id = 1) ORDER BY i6.created_at DESC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'hu' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 105 AND i.category_id = 1)) ORDER BY i.created_at DESC

0.01s, "virtuartnet" connection
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i9.order_index FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = 'hu' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 105 AND i6.category_id = 1) AND (i9.author_id = 105 AND i9.category_id = 1) ORDER BY i9.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'hu' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 105 AND i.category_id = 1) AND (i4.author_id = 105 AND i4.category_id = 1)) ORDER BY i4.order_index ASC

0.01s, "virtuartnet" connection
SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = 11)

0.00s, "virtuartnet" connection
SELECT COUNT(*) AS num_results FROM (SELECT i.id FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i2.lang = 'hu' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 11 AND i.category_id = 1) GROUP BY i.id) dctrn_count_query

0.00s, "virtuartnet" connection
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i6.created_at FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = 'hu' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 11 AND i6.category_id = 1) ORDER BY i6.created_at DESC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'hu' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 11 AND i.category_id = 1)) ORDER BY i.created_at DESC

0.01s, "virtuartnet" connection
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i9.order_index FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = 'hu' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 11 AND i6.category_id = 1) AND (i9.author_id = 11 AND i9.category_id = 1) ORDER BY i9.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'hu' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 11 AND i.category_id = 1) AND (i4.author_id = 11 AND i4.category_id = 1)) ORDER BY i4.order_index ASC

0.01s, "virtuartnet" connection
SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = 106)

0.00s, "virtuartnet" connection
SELECT COUNT(*) AS num_results FROM (SELECT i.id FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i2.lang = 'hu' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 106 AND i.category_id = 1) GROUP BY i.id) dctrn_count_query

0.01s, "virtuartnet" connection
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i6.created_at FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = 'hu' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 106 AND i6.category_id = 1) ORDER BY i6.created_at DESC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'hu' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 106 AND i.category_id = 1)) ORDER BY i.created_at DESC

0.01s, "virtuartnet" connection
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i9.order_index FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = 'hu' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 106 AND i6.category_id = 1) AND (i9.author_id = 106 AND i9.category_id = 1) ORDER BY i9.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'hu' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 106 AND i.category_id = 1) AND (i4.author_id = 106 AND i4.category_id = 1)) ORDER BY i4.order_index ASC

0.01s, "virtuartnet" connection

Virtuartnet

Festmény (Művészek neve szerint betűrendben)

Németh Géza Életrajz Alkotások

Németh Miklós Életrajz Alkotások

Paál Zsuzsanna Életrajz Alkotások

Pálos Anna Életrajz Alkotások

Parrag Emil Életrajz Alkotások

Rainer Máté Életrajz Alkotások

Sipos Loránd Életrajz Alkotások

Székács Zoltán Életrajz Alkotások

Székács Zoltán, Id. Életrajz Alkotások

Szentgyörgyi Erika Életrajz Alkotások

reload and ignore cache

Configuration

Request

Response

User

Settings

Globals

Php

Symfony

View Layer

Template: site … authorListSuccess.php

Partial: site … _authorPreview.php

Partial: site … _authorPreview.php

Partial: site … _authorPreview.php

Partial: site … _authorPreview.php

Partial: site … _authorPreview.php

Partial: site … _authorPreview.php

Partial: site … _authorPreview.php

Partial: site … _authorPreview.php

Partial: site … _authorPreview.php

Partial: site … _authorPreview.php

Partial: siteParts … _mainMenu.php

Partial: siteParts … _languageBar.php

Logs

Timers

SQL queries

Doctrine Version: 1.2.1