Warning: ob_start(): function '' not found or invalid function name in /home/virtuartnet/releases/2013-03-06T155106/lib/vendor/symfony/lib/config/sfApplicationConfiguration.class.php on line 155
options: path_info_key: PATH_INFO path_info_array: SERVER default_format: null logging: '1' relative_url_root: null formats: { txt: text/plain, js: [application/javascript, application/x-javascript, text/javascript], css: text/css, json: [application/json, application/x-json], xml: [text/xml, application/xml, application/x-xml], rdf: application/rdf+xml, atom: application/atom+xml } no_script_name: false parameterHolder: action: authorList module: site page: '2' sf_culture: en slug: painting attributeHolder: sf_ignore_cache: '1' 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: { } /css/en.css: { } metas: title: 'VirtuArtNet - Painting' 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: en default_culture: hu use_flash: true logging: '1' timeout: 1800 attributeHolder: { } culture: en
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: vc7m1smi35d9r5f1nf81kgqte1 env: { } files: { } get: _sf_ignore_cache: '1' page: '2' post: { } server: DOCUMENT_ROOT: /home/virtuartnet/current/web GATEWAY_INTERFACE: CGI/1.1 HTTP_ACCEPT: '*/*' HTTP_ACCEPT_ENCODING: 'gzip, br, zstd, deflate' HTTP_COOKIE: symfony=vc7m1smi35d9r5f1nf81kgqte1 HTTP_HOST: www.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: /authors-by-category/painting PATH_TRANSLATED: 'redirect:/index.php/painting' PHP_SELF: /frontend_dev.php/authors-by-category/painting QUERY_STRING: 'page=2&_sf_ignore_cache=1' REMOTE_ADDR: 3.149.249.68 REMOTE_PORT: '35635' REQUEST_METHOD: GET REQUEST_TIME: 1715918337 REQUEST_TIME_FLOAT: 1715918337.511 REQUEST_URI: '/frontend_dev.php/authors-by-category/painting?page=2&_sf_ignore_cache=1' 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: www.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: en symfony/user/sfUser/lastRequest: 1715918336
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:
$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:
$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:
$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:
$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:
$menu_items
(array)$selected_menu_item
(string)Parameters:
$categories
(Doctrine_Collection)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_en" (/authors-by-category/:slug) for /authors-by-category/painting with parameters array ( 'module' => 'site', 'action' => 'authorList', 'sf_culture' => 'en', 'slug' => 'painting',) |
17 | sfFilterChain | Executing filter "sfRenderingFilter" |
18 | sfFilterChain | Executing filter "setEnglishCssFilter" |
19 | sfOther | (setEnglishCssFilter) english-css: /css/en.css |
20 | sfFilterChain | Executing filter "sfCacheFilter" |
21 | sfFilterChain | Executing filter "sfCommonFilter" |
22 | sfFilterChain | Executing filter "sfExecutionFilter" |
23 | siteActions | Call "siteActions->executeAuthorList()" |
24 | Doctrine_Connection_Pgsql | exec : SET NAMES 'UTF8' - () |
25 | 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 = ?) - (painting) |
26 | Doctrine_Connection_Statement | execute : SELECT MAX(i.id) AS i__0, i.author_id AS i__1 FROM item i LEFT JOIN author a ON i.author_id = a.id WHERE ((i.is_active IS TRUE AND i.in_stock IS TRUE) AND i.category_id = ?) GROUP BY i.author_id, a.name ORDER BY a.name ASC - (1) |
27 | sfPHPView | Render "sf_app_dir/modules/site/templates/authorListSuccess.php" |
28 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = ?) - (82) |
29 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorPreview.php" |
30 | 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 - (en, 82, 1) |
31 | sfOther | author-items-for-listing-by-category; count-1: 10 |
32 | 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 - (en, 82, 1, en, 82, 1) |
33 | sfOther | author-items-for-listing-by-category; needed, found-new: 4, 0 |
34 | 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 - (en, 82, 1, 82, 1, en, 82, 1, 82, 1) |
35 | sfViewCacheManager | Discard cache |
36 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorList_images.php" |
37 | 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 = ?) - (1417) |
38 | 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 = ?) - (1550) |
39 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
40 | 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 (?)) - (1550) |
41 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = ?) - (1418) |
42 | 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 = ?) - (1551) |
43 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
44 | 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 (?)) - (1551) |
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 FROM item i WHERE (i.id = ?) - (1419) |
46 | 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 = ?) - (1552) |
47 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
48 | 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 (?)) - (1552) |
49 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = ?) - (1420) |
50 | 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 = ?) - (1553) |
51 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
52 | 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 (?)) - (1553) |
53 | sfViewCacheManager | Save cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_en_category_id_1_author_id_82" |
54 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = ?) - (41) |
55 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorPreview.php" |
56 | 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 - (en, 41, 1) |
57 | sfOther | author-items-for-listing-by-category; count-1: 7 |
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, 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 - (en, 41, 1, en, 41, 1) |
59 | sfOther | author-items-for-listing-by-category; needed, found-new: 4, 0 |
60 | 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 - (en, 41, 1, 41, 1, en, 41, 1, 41, 1) |
61 | sfViewCacheManager | Discard cache |
62 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorList_images.php" |
63 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = ?) - (5025) |
64 | 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 = ?) - (5672) |
65 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
66 | 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 (?)) - (5672) |
67 | 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 = ?) - (5000) |
68 | 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 = ?) - (5640) |
69 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
70 | 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 (?)) - (5640) |
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 FROM item i WHERE (i.id = ?) - (5001) |
72 | 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 = ?) - (5641) |
73 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
74 | 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 (?)) - (5641) |
75 | 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 = ?) - (574) |
76 | 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 = ?) - (645) |
77 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
78 | 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 (?)) - (645) |
79 | sfViewCacheManager | Save cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_en_category_id_1_author_id_41" |
80 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = ?) - (7) |
81 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorPreview.php" |
82 | 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 - (en, 7, 1) |
83 | sfOther | author-items-for-listing-by-category; count-1: 12 |
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, 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 - (en, 7, 1, en, 7, 1) |
85 | sfOther | author-items-for-listing-by-category; needed, found-new: 4, 0 |
86 | 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 - (en, 7, 1, 7, 1, en, 7, 1, 7, 1) |
87 | sfViewCacheManager | Discard cache |
88 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorList_images.php" |
89 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = ?) - (4319) |
90 | 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 = ?) - (4736) |
91 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
92 | 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 (?)) - (4736) |
93 | 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 = ?) - (4320) |
94 | 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 = ?) - (4737) |
95 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
96 | 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 (?)) - (4737) |
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 FROM item i WHERE (i.id = ?) - (4321) |
98 | 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 = ?) - (4738) |
99 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
100 | 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 (?)) - (4738) |
101 | 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 = ?) - (4322) |
102 | 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 = ?) - (4739) |
103 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
104 | 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 (?)) - (4739) |
105 | sfViewCacheManager | Save cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_en_category_id_1_author_id_7" |
106 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = ?) - (75) |
107 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorPreview.php" |
108 | 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 - (en, 75, 1) |
109 | sfOther | author-items-for-listing-by-category; count-1: 8 |
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, 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 - (en, 75, 1, en, 75, 1) |
111 | sfOther | author-items-for-listing-by-category; needed, found-new: 4, 0 |
112 | 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 - (en, 75, 1, 75, 1, en, 75, 1, 75, 1) |
113 | sfViewCacheManager | Discard cache |
114 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorList_images.php" |
115 | 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 = ?) - (4887) |
116 | 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 = ?) - (5493) |
117 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
118 | 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 (?)) - (5493) |
119 | 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 = ?) - (4886) |
120 | 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 = ?) - (5492) |
121 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
122 | 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 (?)) - (5492) |
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 FROM item i WHERE (i.id = ?) - (4885) |
124 | 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 = ?) - (5491) |
125 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
126 | 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 (?)) - (5491) |
127 | 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 = ?) - (1281) |
128 | 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 = ?) - (1400) |
129 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
130 | 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 (?)) - (1400) |
131 | sfViewCacheManager | Save cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_en_category_id_1_author_id_75" |
132 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = ?) - (37) |
133 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorPreview.php" |
134 | 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 - (en, 37, 1) |
135 | sfOther | author-items-for-listing-by-category; count-1: 11 |
136 | 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 - (en, 37, 1, en, 37, 1) |
137 | sfOther | author-items-for-listing-by-category; needed, found-new: 4, 0 |
138 | 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 - (en, 37, 1, 37, 1, en, 37, 1, 37, 1) |
139 | sfViewCacheManager | Discard cache |
140 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorList_images.php" |
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 FROM item i WHERE (i.id = ?) - (479) |
142 | 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 = ?) - (542) |
143 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
144 | 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 (?)) - (542) |
145 | 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 = ?) - (480) |
146 | 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 = ?) - (543) |
147 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
148 | 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 (?)) - (543) |
149 | 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 = ?) - (481) |
150 | 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 = ?) - (544) |
151 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
152 | 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 (?)) - (544) |
153 | 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 = ?) - (482) |
154 | 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 = ?) - (545) |
155 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
156 | 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 (?)) - (545) |
157 | sfViewCacheManager | Save cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_en_category_id_1_author_id_37" |
158 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = ?) - (45) |
159 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorPreview.php" |
160 | 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 - (en, 45, 1) |
161 | sfOther | author-items-for-listing-by-category; count-1: 12 |
162 | 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 - (en, 45, 1, en, 45, 1) |
163 | sfOther | author-items-for-listing-by-category; needed, found-new: 4, 0 |
164 | 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 - (en, 45, 1, 45, 1, en, 45, 1, 45, 1) |
165 | sfViewCacheManager | Discard cache |
166 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorList_images.php" |
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 FROM item i WHERE (i.id = ?) - (855) |
168 | 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 = ?) - (947) |
169 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
170 | 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 (?)) - (947) |
171 | 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 = ?) - (856) |
172 | 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 = ?) - (948) |
173 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
174 | 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 (?)) - (948) |
175 | 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 = ?) - (857) |
176 | 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 = ?) - (949) |
177 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
178 | 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 (?)) - (949) |
179 | 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 = ?) - (849) |
180 | 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 = ?) - (941) |
181 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
182 | 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 (?)) - (941) |
183 | sfViewCacheManager | Save cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_en_category_id_1_author_id_45" |
184 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = ?) - (85) |
185 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorPreview.php" |
186 | 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 - (en, 85, 1) |
187 | sfOther | author-items-for-listing-by-category; count-1: 5 |
188 | 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 - (en, 85, 1, en, 85, 1) |
189 | sfOther | author-items-for-listing-by-category; needed, found-new: 4, 0 |
190 | 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 - (en, 85, 1, 85, 1, en, 85, 1, 85, 1) |
191 | sfViewCacheManager | Discard cache |
192 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorList_images.php" |
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 FROM item i WHERE (i.id = ?) - (3948) |
194 | 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 = ?) - (4253) |
195 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
196 | 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 (?)) - (4253) |
197 | 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 = ?) - (3949) |
198 | 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 = ?) - (4254) |
199 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
200 | 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 (?)) - (4254) |
201 | 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 = ?) - (3950) |
202 | 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 = ?) - (4255) |
203 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
204 | 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 (?)) - (4255) |
205 | 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 = ?) - (3951) |
206 | 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 = ?) - (4256) |
207 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
208 | 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 (?)) - (4256) |
209 | sfViewCacheManager | Save cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_en_category_id_1_author_id_85" |
210 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = ?) - (105) |
211 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorPreview.php" |
212 | 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 - (en, 105, 1) |
213 | sfOther | author-items-for-listing-by-category; count-1: 11 |
214 | 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 - (en, 105, 1, en, 105, 1) |
215 | sfOther | author-items-for-listing-by-category; needed, found-new: 4, 0 |
216 | 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 - (en, 105, 1, 105, 1, en, 105, 1, 105, 1) |
217 | sfViewCacheManager | Discard cache |
218 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorList_images.php" |
219 | 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 = ?) - (1319) |
220 | 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 = ?) - (1438) |
221 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
222 | 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 (?)) - (1438) |
223 | 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 = ?) - (1321) |
224 | 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 = ?) - (1440) |
225 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
226 | 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 (?)) - (1440) |
227 | 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 = ?) - (3702) |
228 | 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 = ?) - (3975) |
229 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
230 | 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 (?)) - (3975) |
231 | 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 = ?) - (1310) |
232 | 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 = ?) - (1429) |
233 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
234 | 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 (?)) - (1429) |
235 | sfViewCacheManager | Save cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_en_category_id_1_author_id_105" |
236 | 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) |
237 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorPreview.php" |
238 | 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 - (en, 11, 1) |
239 | sfOther | author-items-for-listing-by-category; count-1: 8 |
240 | 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 - (en, 11, 1, en, 11, 1) |
241 | sfOther | author-items-for-listing-by-category; needed, found-new: 4, 0 |
242 | 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 - (en, 11, 1, 11, 1, en, 11, 1, 11, 1) |
243 | sfViewCacheManager | Discard cache |
244 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorList_images.php" |
245 | 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 = ?) - (132) |
246 | 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 = ?) - (140) |
247 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
248 | 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 (?)) - (140) |
249 | 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 = ?) - (133) |
250 | 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 = ?) - (141) |
251 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
252 | 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 (?)) - (141) |
253 | 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 = ?) - (135) |
254 | 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 = ?) - (143) |
255 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
256 | 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 (?)) - (143) |
257 | 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 = ?) - (140) |
258 | 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 = ?) - (148) |
259 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
260 | 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 (?)) - (148) |
261 | sfViewCacheManager | Save cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_en_category_id_1_author_id_11" |
262 | 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) |
263 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorPreview.php" |
264 | 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 - (en, 106, 1) |
265 | sfOther | author-items-for-listing-by-category; count-1: 9 |
266 | 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 - (en, 106, 1, en, 106, 1) |
267 | sfOther | author-items-for-listing-by-category; needed, found-new: 4, 0 |
268 | 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 - (en, 106, 1, 106, 1, en, 106, 1, 106, 1) |
269 | sfViewCacheManager | Discard cache |
270 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorList_images.php" |
271 | 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 = ?) - (4946) |
272 | 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 = ?) - (5586) |
273 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
274 | 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 (?)) - (5586) |
275 | 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 = ?) - (4947) |
276 | 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 = ?) - (5587) |
277 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
278 | 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 (?)) - (5587) |
279 | 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 = ?) - (4967) |
280 | 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 = ?) - (5607) |
281 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
282 | 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 (?)) - (5607) |
283 | 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 = ?) - (4955) |
284 | 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 = ?) - (5595) |
285 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
286 | 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 (?)) - (5595) |
287 | sfViewCacheManager | Save cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_en_category_id_1_author_id_106" |
288 | sfPHPView | Decorate content with "sf_app_dir/templates/layout.php" |
289 | sfPHPView | Render "sf_app_dir/templates/layout.php" |
290 | main | Call "siteParts->executeMainMenu()" |
291 | sfOther | menu-select: categories; route: authors_by_category_list_en |
292 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_mainMenu.php" |
293 | sfViewCacheManager | Discard cache |
294 | main | Call "siteParts->executeCategoriesMenu()" |
295 | Doctrine_Connection_Pgsql | query : 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 - () |
296 | sfViewCacheManager | Discard cache |
297 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_categoriesMenu.php" |
298 | sfViewCacheManager | Save cache for "@sf_cache_partial?module=siteParts&action=_categoriesMenu&sf_cache_key=k_categories_menu_en" |
299 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_languageBar.php" |
300 | sfWebResponse | Send status "HTTP/1.1 200 OK" |
301 | sfWebResponse | Send header "Content-Type: text/html; charset=utf-8" |
type | calls | time (ms) | time (%) |
---|---|---|---|
Configuration | 16 | 160.30 | 7 |
Factories | 1 | 45.94 | 2 |
Action "site/authorList" | 1 | 240.38 | 11 |
Database (Doctrine) | 164 | 0.92 | 0 |
View "Success" for "site/authorList" | 1 | 1661.57 | 82 |
Partial "site/_authorPreview" | 10 | 1582.26 | 78 |
Partial "site/_authorList_images" | 10 | 404.24 | 19 |
Partial "siteParts/_itemPreview" | 40 | 173.95 | 8 |
Component "siteParts/mainMenu" | 1 | 0.15 | 0 |
Partial "siteParts/_mainMenu" | 1 | 20.95 | 1 |
Component "siteParts/categoriesMenu" | 1 | 9.17 | 0 |
Partial "siteParts/_categoriesMenu" | 1 | 10.02 | 0 |
Partial "siteParts/_languageBar" | 1 | 0.62 | 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 = 'painting')
SELECT MAX(i.id) AS i__0, i.author_id AS i__1 FROM item i LEFT JOIN author a ON i.author_id = a.id WHERE ((i.is_active IS TRUE AND i.in_stock IS TRUE) AND i.category_id = 1) GROUP BY i.author_id, a.name ORDER BY a.name ASC
SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = 82)
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 = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 82 AND i.category_id = 1) GROUP BY i.id) dctrn_count_query
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 = 'en' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 82 AND i6.category_id = 1) ORDER BY i6.created_at DESC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 82 AND i.category_id = 1)) ORDER BY i.created_at DESC
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 = 'en' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 82 AND i6.category_id = 1) AND (i9.author_id = 82 AND i9.category_id = 1) ORDER BY i9.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 82 AND i.category_id = 1) AND (i4.author_id = 82 AND i4.category_id = 1)) ORDER BY i4.order_index ASC
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 = 1417)
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 = 1550)
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 (1550))
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 = 1418)
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 = 1551)
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 (1551))
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 = 1419)
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 = 1552)
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 (1552))
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 = 1420)
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 = 1553)
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 (1553))
SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = 41)
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 = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 41 AND i.category_id = 1) GROUP BY i.id) dctrn_count_query
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 = 'en' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 41 AND i6.category_id = 1) ORDER BY i6.created_at DESC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 41 AND i.category_id = 1)) ORDER BY i.created_at DESC
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 = 'en' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 41 AND i6.category_id = 1) AND (i9.author_id = 41 AND i9.category_id = 1) ORDER BY i9.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 41 AND i.category_id = 1) AND (i4.author_id = 41 AND i4.category_id = 1)) ORDER BY i4.order_index ASC
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 = 5025)
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 = 5672)
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 (5672))
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 = 5000)
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 = 5640)
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 (5640))
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 = 5001)
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 = 5641)
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 (5641))
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 = 574)
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 = 645)
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 (645))
SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = 7)
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 = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 7 AND i.category_id = 1) GROUP BY i.id) dctrn_count_query
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 = 'en' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 7 AND i6.category_id = 1) ORDER BY i6.created_at DESC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 7 AND i.category_id = 1)) ORDER BY i.created_at DESC
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 = 'en' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 7 AND i6.category_id = 1) AND (i9.author_id = 7 AND i9.category_id = 1) ORDER BY i9.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 7 AND i.category_id = 1) AND (i4.author_id = 7 AND i4.category_id = 1)) ORDER BY i4.order_index ASC
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 = 4319)
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 = 4736)
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 (4736))
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 = 4320)
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 = 4737)
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 (4737))
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 = 4321)
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 = 4738)
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 (4738))
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 = 4322)
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 = 4739)
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 (4739))
SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = 75)
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 = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 75 AND i.category_id = 1) GROUP BY i.id) dctrn_count_query
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 = 'en' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 75 AND i6.category_id = 1) ORDER BY i6.created_at DESC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 75 AND i.category_id = 1)) ORDER BY i.created_at DESC
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 = 'en' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 75 AND i6.category_id = 1) AND (i9.author_id = 75 AND i9.category_id = 1) ORDER BY i9.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 75 AND i.category_id = 1) AND (i4.author_id = 75 AND i4.category_id = 1)) ORDER BY i4.order_index ASC
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 = 4887)
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 = 5493)
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 (5493))
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 = 4886)
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 = 5492)
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 (5492))
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 = 4885)
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 = 5491)
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 (5491))
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 = 1281)
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 = 1400)
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 (1400))
SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = 37)
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 = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 37 AND i.category_id = 1) GROUP BY i.id) dctrn_count_query
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 = 'en' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 37 AND i6.category_id = 1) ORDER BY i6.created_at DESC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 37 AND i.category_id = 1)) ORDER BY i.created_at DESC
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 = 'en' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 37 AND i6.category_id = 1) AND (i9.author_id = 37 AND i9.category_id = 1) ORDER BY i9.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 37 AND i.category_id = 1) AND (i4.author_id = 37 AND i4.category_id = 1)) ORDER BY i4.order_index ASC
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 = 479)
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 = 542)
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 (542))
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 = 480)
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 = 543)
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 (543))
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 = 481)
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 = 544)
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 (544))
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 = 482)
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 = 545)
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 (545))
SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = 45)
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 = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 45 AND i.category_id = 1) GROUP BY i.id) dctrn_count_query
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 = 'en' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 45 AND i6.category_id = 1) ORDER BY i6.created_at DESC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 45 AND i.category_id = 1)) ORDER BY i.created_at DESC
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 = 'en' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 45 AND i6.category_id = 1) AND (i9.author_id = 45 AND i9.category_id = 1) ORDER BY i9.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 45 AND i.category_id = 1) AND (i4.author_id = 45 AND i4.category_id = 1)) ORDER BY i4.order_index ASC
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 = 855)
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 = 947)
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 (947))
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 = 856)
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 = 948)
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 (948))
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 = 857)
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 = 949)
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 (949))
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 = 849)
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 = 941)
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 (941))
SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = 85)
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 = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 85 AND i.category_id = 1) GROUP BY i.id) dctrn_count_query
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 = 'en' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 85 AND i6.category_id = 1) ORDER BY i6.created_at DESC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 85 AND i.category_id = 1)) ORDER BY i.created_at DESC
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 = 'en' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 85 AND i6.category_id = 1) AND (i9.author_id = 85 AND i9.category_id = 1) ORDER BY i9.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 85 AND i.category_id = 1) AND (i4.author_id = 85 AND i4.category_id = 1)) ORDER BY i4.order_index ASC
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 = 3948)
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 = 4253)
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 (4253))
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 = 3949)
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 = 4254)
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 (4254))
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 = 3950)
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 = 4255)
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 (4255))
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 = 3951)
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 = 4256)
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 (4256))
SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = 105)
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 = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 105 AND i.category_id = 1) GROUP BY i.id) dctrn_count_query
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 = 'en' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 105 AND i6.category_id = 1) ORDER BY i6.created_at DESC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 105 AND i.category_id = 1)) ORDER BY i.created_at DESC
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 = 'en' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 105 AND i6.category_id = 1) AND (i9.author_id = 105 AND i9.category_id = 1) ORDER BY i9.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 105 AND i.category_id = 1) AND (i4.author_id = 105 AND i4.category_id = 1)) ORDER BY i4.order_index ASC
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 = 1319)
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 = 1438)
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 (1438))
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 = 1321)
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 = 1440)
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 (1440))
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 = 3702)
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 = 3975)
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 (3975))
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 = 1310)
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 = 1429)
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 (1429))
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 = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 11 AND i.category_id = 1) GROUP BY i.id) dctrn_count_query
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 = 'en' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 11 AND i6.category_id = 1) ORDER BY i6.created_at DESC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 11 AND i.category_id = 1)) ORDER BY i.created_at DESC
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 = 'en' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 11 AND i6.category_id = 1) AND (i9.author_id = 11 AND i9.category_id = 1) ORDER BY i9.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 11 AND i.category_id = 1) AND (i4.author_id = 11 AND i4.category_id = 1)) ORDER BY i4.order_index ASC
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 = 132)
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 = 140)
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 (140))
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 = 133)
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 = 141)
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 (141))
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 = 135)
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 = 143)
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 (143))
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 = 140)
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 = 148)
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 (148))
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 = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 106 AND i.category_id = 1) GROUP BY i.id) dctrn_count_query
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 = 'en' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 106 AND i6.category_id = 1) ORDER BY i6.created_at DESC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 106 AND i.category_id = 1)) ORDER BY i.created_at DESC
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 = 'en' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 106 AND i6.category_id = 1) AND (i9.author_id = 106 AND i9.category_id = 1) ORDER BY i9.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 106 AND i.category_id = 1) AND (i4.author_id = 106 AND i4.category_id = 1)) ORDER BY i4.order_index ASC
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 = 4946)
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 = 5586)
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 (5586))
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 = 4947)
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 = 5587)
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 (5587))
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 = 4967)
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 = 5607)
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 (5607))
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 = 4955)
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 = 5595)
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 (5595))
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