config
view
logs
23040.0 KB
2529 ms
115options:
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: '3'
slug: grafika
attributeHolder:
sf_route: 'sfDoctrineRoute Object()'
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 - Grafika'
description: VirtuArtNet
keywords: 'virtuartnet, art, database, műtárgy, adatbázis'
robots: 'index, follow'
httpMetas:
Content-Type: 'text/html; charset=utf-8'
options:
auto_shutdown: false
culture: null
default_culture: hu
use_flash: true
logging: '1'
timeout: 1800
attributeHolder: { }
culture: hu
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
cookie:
symfony: qp81e5i6qdmkvlitlj69mo27q7
env: { }
files: { }
get:
page: '3'
post: { }
server:
DOCUMENT_ROOT: /home/virtuartnet/current/web
GATEWAY_INTERFACE: CGI/1.1
HTTP_ACCEPT: '*/*'
HTTP_ACCEPT_ENCODING: 'gzip, br, zstd, deflate'
HTTP_COOKIE: symfony=qp81e5i6qdmkvlitlj69mo27q7
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/grafika
PATH_TRANSLATED: 'redirect:/index.php/grafika'
PHP_SELF: /frontend_dev.php/szerzok-kategoria-szerint/grafika
QUERY_STRING: page=3
REMOTE_ADDR: 18.118.30.3
REMOTE_PORT: '42357'
REQUEST_METHOD: GET
REQUEST_TIME: 1745071373
REQUEST_TIME_FLOAT: 1745071373.049
REQUEST_URI: /frontend_dev.php/szerzok-kategoria-szerint/grafika?page=3
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:
symfony/user/sfUser/attributes: { }
symfony/user/sfUser/authenticated: false
symfony/user/sfUser/credentials: { }
symfony/user/sfUser/culture: hu
symfony/user/sfUser/lastRequest: 1745071371
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)'
version: 1.4.2 path: /home/virtuartnet/releases/2013-03-06T155106/lib/vendor/symfony/lib
Parameters:
$category (Category)$pager (vaPager)Parameters:
$author (Author)$category (sfOutputEscaperIteratorDecorator)$items_num_to_show (integer)$show_new_items (boolean)Parameters:
$items (array)Parameters:
$item (sfOutputEscaperIteratorDecorator)$height (integer)$show_new_caption (boolean)$type (NULL)$main_image (sfOutputEscaperIteratorDecorator)Parameters:
$author (Author)$category (sfOutputEscaperIteratorDecorator)$items_num_to_show (integer)$show_new_items (boolean)Parameters:
$items (array)Parameters:
$item (sfOutputEscaperIteratorDecorator)$height (integer)$show_new_caption (boolean)$type (NULL)$main_image (sfOutputEscaperIteratorDecorator)Parameters:
$item (sfOutputEscaperIteratorDecorator)$height (integer)$show_new_caption (boolean)$type (NULL)$main_image (sfOutputEscaperIteratorDecorator)Parameters:
$item (sfOutputEscaperIteratorDecorator)$height (integer)$show_new_caption (boolean)$type (NULL)$main_image (sfOutputEscaperIteratorDecorator)Parameters:
$item (sfOutputEscaperIteratorDecorator)$height (integer)$show_new_caption (boolean)$type (NULL)$main_image (sfOutputEscaperIteratorDecorator)Parameters:
$author (Author)$category (sfOutputEscaperIteratorDecorator)$items_num_to_show (integer)$show_new_items (boolean)Parameters:
$items (array)Parameters:
$item (sfOutputEscaperIteratorDecorator)$height (integer)$show_new_caption (boolean)$type (NULL)$main_image (sfOutputEscaperIteratorDecorator)Parameters:
$item (sfOutputEscaperIteratorDecorator)$height (integer)$show_new_caption (boolean)$type (NULL)$main_image (sfOutputEscaperIteratorDecorator)Parameters:
$item (sfOutputEscaperIteratorDecorator)$height (integer)$show_new_caption (boolean)$type (NULL)$main_image (sfOutputEscaperIteratorDecorator)Parameters:
$item (sfOutputEscaperIteratorDecorator)$height (integer)$show_new_caption (boolean)$type (NULL)$main_image (sfOutputEscaperIteratorDecorator)Parameters:
$author (Author)$category (sfOutputEscaperIteratorDecorator)$items_num_to_show (integer)$show_new_items (boolean)Parameters:
$items (array)Parameters:
$item (sfOutputEscaperIteratorDecorator)$height (integer)$show_new_caption (boolean)$type (NULL)$main_image (sfOutputEscaperIteratorDecorator)Parameters:
$item (sfOutputEscaperIteratorDecorator)$height (integer)$show_new_caption (boolean)$type (NULL)$main_image (sfOutputEscaperIteratorDecorator)Parameters:
$item (sfOutputEscaperIteratorDecorator)$height (integer)$show_new_caption (boolean)$type (NULL)$main_image (sfOutputEscaperIteratorDecorator)Parameters:
$item (sfOutputEscaperIteratorDecorator)$height (integer)$show_new_caption (boolean)$type (NULL)$main_image (sfOutputEscaperIteratorDecorator)Parameters:
$author (Author)$category (sfOutputEscaperIteratorDecorator)$items_num_to_show (integer)$show_new_items (boolean)Parameters:
$items (array)Parameters:
$item (sfOutputEscaperIteratorDecorator)$height (integer)$show_new_caption (boolean)$type (NULL)$main_image (sfOutputEscaperIteratorDecorator)Parameters:
$item (sfOutputEscaperIteratorDecorator)$height (integer)$show_new_caption (boolean)$type (NULL)$main_image (sfOutputEscaperIteratorDecorator)Parameters:
$author (Author)$category (sfOutputEscaperIteratorDecorator)$items_num_to_show (integer)$show_new_items (boolean)Parameters:
$items (array)Parameters:
$item (sfOutputEscaperIteratorDecorator)$height (integer)$show_new_caption (boolean)$type (NULL)$main_image (sfOutputEscaperIteratorDecorator)Parameters:
$item (sfOutputEscaperIteratorDecorator)$height (integer)$show_new_caption (boolean)$type (NULL)$main_image (sfOutputEscaperIteratorDecorator)Parameters:
$item (sfOutputEscaperIteratorDecorator)$height (integer)$show_new_caption (boolean)$type (NULL)$main_image (sfOutputEscaperIteratorDecorator)Parameters:
$item (sfOutputEscaperIteratorDecorator)$height (integer)$show_new_caption (boolean)$type (NULL)$main_image (sfOutputEscaperIteratorDecorator)Parameters:
$author (Author)$category (sfOutputEscaperIteratorDecorator)$items_num_to_show (integer)$show_new_items (boolean)Parameters:
$items (array)Parameters:
$item (sfOutputEscaperIteratorDecorator)$height (integer)$show_new_caption (boolean)$type (NULL)$main_image (sfOutputEscaperIteratorDecorator)Parameters:
$item (sfOutputEscaperIteratorDecorator)$height (integer)$show_new_caption (boolean)$type (NULL)$main_image (sfOutputEscaperIteratorDecorator)Parameters:
$item (sfOutputEscaperIteratorDecorator)$height (integer)$show_new_caption (boolean)$type (NULL)$main_image (sfOutputEscaperIteratorDecorator)Parameters:
$item (sfOutputEscaperIteratorDecorator)$height (integer)$show_new_caption (boolean)$type (NULL)$main_image (sfOutputEscaperIteratorDecorator)Parameters:
$author (Author)$category (sfOutputEscaperIteratorDecorator)$items_num_to_show (integer)$show_new_items (boolean)Parameters:
$items (array)Parameters:
$item (sfOutputEscaperIteratorDecorator)$height (integer)$show_new_caption (boolean)$type (NULL)$main_image (sfOutputEscaperIteratorDecorator)Parameters:
$author (Author)$category (sfOutputEscaperIteratorDecorator)$items_num_to_show (integer)$show_new_items (boolean)Parameters:
$author (Author)$category (sfOutputEscaperIteratorDecorator)$items_num_to_show (integer)$show_new_items (boolean)Parameters:
$menu_items (array)$selected_menu_item (string)No parameters were passed to this template.
| # | 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/grafika with parameters array ( 'module' => 'site', 'action' => 'authorList', 'slug' => 'grafika',) |
| 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 = ?) - (grafika) |
| 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 - (2) |
| 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 = ?) - (12) |
| 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, 12, 2) |
| 30 | sfOther | author-items-for-listing-by-category; count-1: 1 |
| 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, 12, 2, hu, 12, 2) |
| 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, 12, 2, 12, 2, hu, 12, 2, 12, 2) |
| 34 | sfViewCacheManager | Cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_hu_category_id_2_author_id_12" does not exist |
| 35 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorList_images.php" |
| 36 | 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 FROM item i WHERE (i.id = ?) - (5038) |
| 37 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (5692) |
| 38 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
| 39 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (5692) |
| 40 | sfViewCacheManager | Save cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_hu_category_id_2_author_id_12" |
| 41 | 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 = ?) - (96) |
| 42 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorPreview.php" |
| 43 | 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, 96, 2) |
| 44 | sfOther | author-items-for-listing-by-category; count-1: 9 |
| 45 | 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, 96, 2, hu, 96, 2) |
| 46 | sfOther | author-items-for-listing-by-category; needed, found-new: 4, 0 |
| 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, 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, 96, 2, 96, 2, hu, 96, 2, 96, 2) |
| 48 | sfViewCacheManager | Cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_hu_category_id_2_author_id_96" does not exist |
| 49 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorList_images.php" |
| 50 | 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 FROM item i WHERE (i.id = ?) - (4823) |
| 51 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (5406) |
| 52 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
| 53 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (5406) |
| 54 | 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 FROM item i WHERE (i.id = ?) - (4356) |
| 55 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (4780) |
| 56 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
| 57 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (4780) |
| 58 | 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 FROM item i WHERE (i.id = ?) - (4357) |
| 59 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (4781) |
| 60 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
| 61 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (4781) |
| 62 | 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 FROM item i WHERE (i.id = ?) - (4358) |
| 63 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (4782) |
| 64 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
| 65 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (4782) |
| 66 | sfViewCacheManager | Save cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_hu_category_id_2_author_id_96" |
| 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 = ?) - (11) |
| 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, 11, 2) |
| 70 | sfOther | author-items-for-listing-by-category; count-1: 13 |
| 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, 11, 2, hu, 11, 2) |
| 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, 11, 2, 11, 2, hu, 11, 2, 11, 2) |
| 74 | sfViewCacheManager | Cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_hu_category_id_2_author_id_11" does not exist |
| 75 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorList_images.php" |
| 76 | 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 FROM item i WHERE (i.id = ?) - (153) |
| 77 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (161) |
| 78 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
| 79 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (161) |
| 80 | 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 FROM item i WHERE (i.id = ?) - (141) |
| 81 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (149) |
| 82 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
| 83 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (149) |
| 84 | 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 FROM item i WHERE (i.id = ?) - (144) |
| 85 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (152) |
| 86 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
| 87 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (152) |
| 88 | 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 FROM item i WHERE (i.id = ?) - (145) |
| 89 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (153) |
| 90 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
| 91 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (153) |
| 92 | sfViewCacheManager | Save cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_hu_category_id_2_author_id_11" |
| 93 | 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) |
| 94 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorPreview.php" |
| 95 | 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, 2) |
| 96 | sfOther | author-items-for-listing-by-category; count-1: 7 |
| 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, 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, 2, hu, 106, 2) |
| 98 | sfOther | author-items-for-listing-by-category; needed, found-new: 4, 0 |
| 99 | 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, 2, 106, 2, hu, 106, 2, 106, 2) |
| 100 | sfViewCacheManager | Cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_hu_category_id_2_author_id_106" does not exist |
| 101 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorList_images.php" |
| 102 | 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 FROM item i WHERE (i.id = ?) - (4974) |
| 103 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (5614) |
| 104 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
| 105 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (5614) |
| 106 | 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 FROM item i WHERE (i.id = ?) - (4972) |
| 107 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (5612) |
| 108 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
| 109 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (5612) |
| 110 | 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 FROM item i WHERE (i.id = ?) - (4973) |
| 111 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (5613) |
| 112 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
| 113 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (5613) |
| 114 | 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 FROM item i WHERE (i.id = ?) - (4944) |
| 115 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (5584) |
| 116 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
| 117 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (5584) |
| 118 | sfViewCacheManager | Save cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_hu_category_id_2_author_id_106" |
| 119 | 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 = ?) - (115) |
| 120 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorPreview.php" |
| 121 | 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, 115, 2) |
| 122 | sfOther | author-items-for-listing-by-category; count-1: 2 |
| 123 | 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, 115, 2, hu, 115, 2) |
| 124 | sfOther | author-items-for-listing-by-category; needed, found-new: 4, 0 |
| 125 | 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, 115, 2, 115, 2, hu, 115, 2, 115, 2) |
| 126 | sfViewCacheManager | Cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_hu_category_id_2_author_id_115" does not exist |
| 127 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorList_images.php" |
| 128 | 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 FROM item i WHERE (i.id = ?) - (4510) |
| 129 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (5003) |
| 130 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
| 131 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (5003) |
| 132 | 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 FROM item i WHERE (i.id = ?) - (4511) |
| 133 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (5006) |
| 134 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
| 135 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (5006) |
| 136 | sfViewCacheManager | Save cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_hu_category_id_2_author_id_115" |
| 137 | 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 = ?) - (1) |
| 138 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorPreview.php" |
| 139 | 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, 1, 2) |
| 140 | sfOther | author-items-for-listing-by-category; count-1: 15 |
| 141 | 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, 1, 2, hu, 1, 2) |
| 142 | sfOther | author-items-for-listing-by-category; needed, found-new: 4, 0 |
| 143 | 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, 1, 2, 1, 2, hu, 1, 2, 1, 2) |
| 144 | sfViewCacheManager | Cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_hu_category_id_2_author_id_1" does not exist |
| 145 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorList_images.php" |
| 146 | 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 FROM item i WHERE (i.id = ?) - (4429) |
| 147 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (4860) |
| 148 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
| 149 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (4860) |
| 150 | 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 FROM item i WHERE (i.id = ?) - (3715) |
| 151 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (3989) |
| 152 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
| 153 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (3989) |
| 154 | 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 FROM item i WHERE (i.id = ?) - (3714) |
| 155 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (3988) |
| 156 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
| 157 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (3988) |
| 158 | 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 FROM item i WHERE (i.id = ?) - (1554) |
| 159 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (1693) |
| 160 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
| 161 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (1693) |
| 162 | sfViewCacheManager | Save cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_hu_category_id_2_author_id_1" |
| 163 | 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 = ?) - (29) |
| 164 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorPreview.php" |
| 165 | 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, 29, 2) |
| 166 | sfOther | author-items-for-listing-by-category; count-1: 16 |
| 167 | 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, 29, 2, hu, 29, 2) |
| 168 | sfOther | author-items-for-listing-by-category; needed, found-new: 4, 0 |
| 169 | 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, 29, 2, 29, 2, hu, 29, 2, 29, 2) |
| 170 | sfViewCacheManager | Cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_hu_category_id_2_author_id_29" does not exist |
| 171 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorList_images.php" |
| 172 | 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 FROM item i WHERE (i.id = ?) - (5041) |
| 173 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (5695) |
| 174 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
| 175 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (5695) |
| 176 | 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 FROM item i WHERE (i.id = ?) - (593) |
| 177 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (664) |
| 178 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
| 179 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (664) |
| 180 | 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 FROM item i WHERE (i.id = ?) - (5040) |
| 181 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (5694) |
| 182 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
| 183 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (5694) |
| 184 | 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 FROM item i WHERE (i.id = ?) - (591) |
| 185 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (662) |
| 186 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
| 187 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (662) |
| 188 | sfViewCacheManager | Save cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_hu_category_id_2_author_id_29" |
| 189 | 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 = ?) - (126) |
| 190 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorPreview.php" |
| 191 | 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, 126, 2) |
| 192 | sfOther | author-items-for-listing-by-category; count-1: 1 |
| 193 | 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, 126, 2, hu, 126, 2) |
| 194 | sfOther | author-items-for-listing-by-category; needed, found-new: 4, 0 |
| 195 | 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, 126, 2, 126, 2, hu, 126, 2, 126, 2) |
| 196 | sfViewCacheManager | Cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_hu_category_id_2_author_id_126" does not exist |
| 197 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorList_images.php" |
| 198 | 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 FROM item i WHERE (i.id = ?) - (5015) |
| 199 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (5655) |
| 200 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
| 201 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (5655) |
| 202 | sfViewCacheManager | Save cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_hu_category_id_2_author_id_126" |
| 203 | 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 = ?) - (19) |
| 204 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorPreview.php" |
| 205 | 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, 19, 2) |
| 206 | sfOther | author-items-for-listing-by-category; count-1: 7 |
| 207 | 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, 19, 2, hu, 19, 2) |
| 208 | sfOther | author-items-for-listing-by-category; needed, found-new: 4, 0 |
| 209 | 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, 19, 2, 19, 2, hu, 19, 2, 19, 2) |
| 210 | sfViewCacheManager | Cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_hu_category_id_2_author_id_19" exists |
| 211 | 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 = ?) - (73) |
| 212 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorPreview.php" |
| 213 | 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, 73, 2) |
| 214 | sfOther | author-items-for-listing-by-category; count-1: 18 |
| 215 | 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, 73, 2, hu, 73, 2) |
| 216 | sfOther | author-items-for-listing-by-category; needed, found-new: 4, 0 |
| 217 | 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, 73, 2, 73, 2, hu, 73, 2, 73, 2) |
| 218 | sfViewCacheManager | Cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_hu_category_id_2_author_id_73" exists |
| 219 | sfPHPView | Decorate content with "sf_app_dir/templates/layout.php" |
| 220 | sfPHPView | Render "sf_app_dir/templates/layout.php" |
| 221 | main | Call "siteParts->executeMainMenu()" |
| 222 | sfOther | menu-select: categories; route: authors_by_category_list |
| 223 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_mainMenu.php" |
| 224 | sfViewCacheManager | Cache for "@sf_cache_partial?module=siteParts&action=_categoriesMenu&sf_cache_key=k_categories_menu_hu" exists |
| 225 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_languageBar.php" |
| 226 | sfWebResponse | Send status "HTTP/1.1 200 OK" |
| 227 | sfWebResponse | Send header "Content-Type: text/html; charset=utf-8" |
| type | calls | time (ms) | time (%) |
|---|---|---|---|
| Configuration | 15 | 156.31 | 6 |
| Factories | 1 | 42.77 | 1 |
| Action "site/authorList" | 1 | 240.39 | 9 |
| Database (Doctrine) | 115 | 0.85 | 0 |
| View "Success" for "site/authorList" | 1 | 2159.89 | 85 |
| Partial "site/_authorPreview" | 10 | 2094.42 | 82 |
| Partial "site/_authorList_images" | 8 | 717.04 | 28 |
| Partial "siteParts/_itemPreview" | 24 | 138.59 | 5 |
| Component "siteParts/mainMenu" | 1 | 0.17 | 0 |
| Partial "siteParts/_mainMenu" | 1 | 2.61 | 0 |
| Partial "siteParts/_languageBar" | 1 | 0.73 | 0 |
SET NAMES 'UTF8'
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 = 'grafika')
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 = 2) GROUP BY i.author_id, a.name ORDER BY a.name ASC
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 = 12)
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 = 12 AND i.category_id = 2) GROUP BY i.id) dctrn_count_query
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 = 12 AND i6.category_id = 2) 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 = 12 AND i.category_id = 2)) ORDER BY i.created_at DESC
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 = 12 AND i6.category_id = 2) AND (i9.author_id = 12 AND i9.category_id = 2) 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 = 12 AND i.category_id = 2) AND (i4.author_id = 12 AND i4.category_id = 2)) ORDER BY i4.order_index ASC
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 FROM item i WHERE (i.id = 5038)
SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = 5692)
SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (5692))
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 = 96)
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 = 96 AND i.category_id = 2) GROUP BY i.id) dctrn_count_query
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 = 96 AND i6.category_id = 2) 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 = 96 AND i.category_id = 2)) ORDER BY i.created_at DESC
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 = 96 AND i6.category_id = 2) AND (i9.author_id = 96 AND i9.category_id = 2) 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 = 96 AND i.category_id = 2) AND (i4.author_id = 96 AND i4.category_id = 2)) ORDER BY i4.order_index ASC
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 FROM item i WHERE (i.id = 4823)
SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = 5406)
SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (5406))
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 FROM item i WHERE (i.id = 4356)
SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = 4780)
SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (4780))
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 FROM item i WHERE (i.id = 4357)
SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = 4781)
SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (4781))
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 FROM item i WHERE (i.id = 4358)
SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = 4782)
SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (4782))
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)
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 = 2) GROUP BY i.id) dctrn_count_query
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 = 2) 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 = 2)) ORDER BY i.created_at DESC
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 = 2) AND (i9.author_id = 11 AND i9.category_id = 2) 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 = 2) AND (i4.author_id = 11 AND i4.category_id = 2)) ORDER BY i4.order_index ASC
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 FROM item i WHERE (i.id = 153)
SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = 161)
SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (161))
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 FROM item i WHERE (i.id = 141)
SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = 149)
SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (149))
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 FROM item i WHERE (i.id = 144)
SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = 152)
SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (152))
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 FROM item i WHERE (i.id = 145)
SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = 153)
SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (153))
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)
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 = 2) GROUP BY i.id) dctrn_count_query
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 = 2) 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 = 2)) ORDER BY i.created_at DESC
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 = 2) AND (i9.author_id = 106 AND i9.category_id = 2) 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 = 2) AND (i4.author_id = 106 AND i4.category_id = 2)) ORDER BY i4.order_index ASC
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 FROM item i WHERE (i.id = 4974)
SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = 5614)
SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (5614))
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 FROM item i WHERE (i.id = 4972)
SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = 5612)
SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (5612))
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 FROM item i WHERE (i.id = 4973)
SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = 5613)
SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (5613))
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 FROM item i WHERE (i.id = 4944)
SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = 5584)
SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (5584))
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 = 115)
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 = 115 AND i.category_id = 2) GROUP BY i.id) dctrn_count_query
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 = 115 AND i6.category_id = 2) 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 = 115 AND i.category_id = 2)) ORDER BY i.created_at DESC
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 = 115 AND i6.category_id = 2) AND (i9.author_id = 115 AND i9.category_id = 2) 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 = 115 AND i.category_id = 2) AND (i4.author_id = 115 AND i4.category_id = 2)) ORDER BY i4.order_index ASC
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 FROM item i WHERE (i.id = 4510)
SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = 5003)
SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (5003))
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 FROM item i WHERE (i.id = 4511)
SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = 5006)
SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (5006))
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 = 1)
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 = 1 AND i.category_id = 2) GROUP BY i.id) dctrn_count_query
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 = 1 AND i6.category_id = 2) 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 = 1 AND i.category_id = 2)) ORDER BY i.created_at DESC
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 = 1 AND i6.category_id = 2) AND (i9.author_id = 1 AND i9.category_id = 2) 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 = 1 AND i.category_id = 2) AND (i4.author_id = 1 AND i4.category_id = 2)) ORDER BY i4.order_index ASC
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 FROM item i WHERE (i.id = 4429)
SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = 4860)
SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (4860))
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 FROM item i WHERE (i.id = 3715)
SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = 3989)
SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (3989))
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 FROM item i WHERE (i.id = 3714)
SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = 3988)
SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (3988))
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 FROM item i WHERE (i.id = 1554)
SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = 1693)
SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (1693))
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 = 29)
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 = 29 AND i.category_id = 2) GROUP BY i.id) dctrn_count_query
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 = 29 AND i6.category_id = 2) 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 = 29 AND i.category_id = 2)) ORDER BY i.created_at DESC
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 = 29 AND i6.category_id = 2) AND (i9.author_id = 29 AND i9.category_id = 2) 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 = 29 AND i.category_id = 2) AND (i4.author_id = 29 AND i4.category_id = 2)) ORDER BY i4.order_index ASC
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 FROM item i WHERE (i.id = 5041)
SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = 5695)
SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (5695))
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 FROM item i WHERE (i.id = 593)
SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = 664)
SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (664))
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 FROM item i WHERE (i.id = 5040)
SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = 5694)
SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (5694))
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 FROM item i WHERE (i.id = 591)
SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = 662)
SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (662))
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 = 126)
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 = 126 AND i.category_id = 2) GROUP BY i.id) dctrn_count_query
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 = 126 AND i6.category_id = 2) 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 = 126 AND i.category_id = 2)) ORDER BY i.created_at DESC
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 = 126 AND i6.category_id = 2) AND (i9.author_id = 126 AND i9.category_id = 2) 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 = 126 AND i.category_id = 2) AND (i4.author_id = 126 AND i4.category_id = 2)) ORDER BY i4.order_index ASC
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 FROM item i WHERE (i.id = 5015)
SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = 5655)
SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (5655))
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 = 19)
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 = 19 AND i.category_id = 2) GROUP BY i.id) dctrn_count_query
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 = 19 AND i6.category_id = 2) 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 = 19 AND i.category_id = 2)) ORDER BY i.created_at DESC
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 = 19 AND i6.category_id = 2) AND (i9.author_id = 19 AND i9.category_id = 2) 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 = 19 AND i.category_id = 2) AND (i4.author_id = 19 AND i4.category_id = 2)) ORDER BY i4.order_index ASC
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 = 73)
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 = 73 AND i.category_id = 2) GROUP BY i.id) dctrn_count_query
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 = 73 AND i6.category_id = 2) 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 = 73 AND i.category_id = 2)) ORDER BY i.created_at DESC
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 = 73 AND i6.category_id = 2) AND (i9.author_id = 73 AND i9.category_id = 2) 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 = 73 AND i.category_id = 2) AND (i4.author_id = 73 AND i4.category_id = 2)) ORDER BY i4.order_index ASC