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: '3' sf_culture: en slug: graphics 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 - Graphics' 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: 3p8dam7jcqp41rqjmhlmch5n85 env: { } files: { } get: _sf_ignore_cache: '1' page: '3' post: { } server: DOCUMENT_ROOT: /home/virtuartnet/current/web GATEWAY_INTERFACE: CGI/1.1 HTTP_ACCEPT: '*/*' HTTP_ACCEPT_ENCODING: 'gzip, br, zstd, deflate' HTTP_COOKIE: symfony=3p8dam7jcqp41rqjmhlmch5n85 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/graphics PATH_TRANSLATED: 'redirect:/index.php/graphics' PHP_SELF: /frontend_dev.php/authors-by-category/graphics QUERY_STRING: 'page=3&_sf_ignore_cache=1' REMOTE_ADDR: 13.59.18.83 REMOTE_PORT: '36542' REQUEST_METHOD: GET REQUEST_TIME: 1715916624 REQUEST_TIME_FLOAT: 1715916624.411 REQUEST_URI: '/frontend_dev.php/authors-by-category/graphics?page=3&_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: 1715916623
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:
$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:
$author
(Author)$category
(sfOutputEscaperIteratorDecorator)$items_num_to_show
(integer)$show_new_items
(boolean)Parameters:
$items
(array)Parameters:
$item
(sfOutputEscaperIteratorDecorator)$height
(integer)$show_new_caption
(boolean)$type
(NULL)$main_image
(sfOutputEscaperIteratorDecorator)Parameters:
$author
(Author)$category
(sfOutputEscaperIteratorDecorator)$items_num_to_show
(integer)$show_new_items
(boolean)Parameters:
$items
(array)Parameters:
$item
(sfOutputEscaperIteratorDecorator)$height
(integer)$show_new_caption
(boolean)$type
(NULL)$main_image
(sfOutputEscaperIteratorDecorator)Parameters:
$item
(sfOutputEscaperIteratorDecorator)$height
(integer)$show_new_caption
(boolean)$type
(NULL)$main_image
(sfOutputEscaperIteratorDecorator)Parameters:
$item
(sfOutputEscaperIteratorDecorator)$height
(integer)$show_new_caption
(boolean)$type
(NULL)$main_image
(sfOutputEscaperIteratorDecorator)Parameters:
$item
(sfOutputEscaperIteratorDecorator)$height
(integer)$show_new_caption
(boolean)$type
(NULL)$main_image
(sfOutputEscaperIteratorDecorator)Parameters:
$author
(Author)$category
(sfOutputEscaperIteratorDecorator)$items_num_to_show
(integer)$show_new_items
(boolean)Parameters:
$items
(array)Parameters:
$item
(sfOutputEscaperIteratorDecorator)$height
(integer)$show_new_caption
(boolean)$type
(NULL)$main_image
(sfOutputEscaperIteratorDecorator)Parameters:
$author
(Author)$category
(sfOutputEscaperIteratorDecorator)$items_num_to_show
(integer)$show_new_items
(boolean)Parameters:
$items
(array)Parameters:
$item
(sfOutputEscaperIteratorDecorator)$height
(integer)$show_new_caption
(boolean)$type
(NULL)$main_image
(sfOutputEscaperIteratorDecorator)Parameters:
$item
(sfOutputEscaperIteratorDecorator)$height
(integer)$show_new_caption
(boolean)$type
(NULL)$main_image
(sfOutputEscaperIteratorDecorator)Parameters:
$item
(sfOutputEscaperIteratorDecorator)$height
(integer)$show_new_caption
(boolean)$type
(NULL)$main_image
(sfOutputEscaperIteratorDecorator)Parameters:
$item
(sfOutputEscaperIteratorDecorator)$height
(integer)$show_new_caption
(boolean)$type
(NULL)$main_image
(sfOutputEscaperIteratorDecorator)Parameters:
$author
(Author)$category
(sfOutputEscaperIteratorDecorator)$items_num_to_show
(integer)$show_new_items
(boolean)Parameters:
$items
(array)Parameters:
$item
(sfOutputEscaperIteratorDecorator)$height
(integer)$show_new_caption
(boolean)$type
(NULL)$main_image
(sfOutputEscaperIteratorDecorator)Parameters:
$item
(sfOutputEscaperIteratorDecorator)$height
(integer)$show_new_caption
(boolean)$type
(NULL)$main_image
(sfOutputEscaperIteratorDecorator)Parameters:
$item
(sfOutputEscaperIteratorDecorator)$height
(integer)$show_new_caption
(boolean)$type
(NULL)$main_image
(sfOutputEscaperIteratorDecorator)Parameters:
$item
(sfOutputEscaperIteratorDecorator)$height
(integer)$show_new_caption
(boolean)$type
(NULL)$main_image
(sfOutputEscaperIteratorDecorator)Parameters:
$author
(Author)$category
(sfOutputEscaperIteratorDecorator)$items_num_to_show
(integer)$show_new_items
(boolean)Parameters:
$items
(array)Parameters:
$item
(sfOutputEscaperIteratorDecorator)$height
(integer)$show_new_caption
(boolean)$type
(NULL)$main_image
(sfOutputEscaperIteratorDecorator)Parameters:
$item
(sfOutputEscaperIteratorDecorator)$height
(integer)$show_new_caption
(boolean)$type
(NULL)$main_image
(sfOutputEscaperIteratorDecorator)Parameters:
$author
(Author)$category
(sfOutputEscaperIteratorDecorator)$items_num_to_show
(integer)$show_new_items
(boolean)Parameters:
$items
(array)Parameters:
$item
(sfOutputEscaperIteratorDecorator)$height
(integer)$show_new_caption
(boolean)$type
(NULL)$main_image
(sfOutputEscaperIteratorDecorator)Parameters:
$item
(sfOutputEscaperIteratorDecorator)$height
(integer)$show_new_caption
(boolean)$type
(NULL)$main_image
(sfOutputEscaperIteratorDecorator)Parameters:
$item
(sfOutputEscaperIteratorDecorator)$height
(integer)$show_new_caption
(boolean)$type
(NULL)$main_image
(sfOutputEscaperIteratorDecorator)Parameters:
$item
(sfOutputEscaperIteratorDecorator)$height
(integer)$show_new_caption
(boolean)$type
(NULL)$main_image
(sfOutputEscaperIteratorDecorator)Parameters:
$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/graphics with parameters array ( 'module' => 'site', 'action' => 'authorList', 'sf_culture' => 'en', 'slug' => 'graphics',) |
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 = ?) - (graphics) |
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 - (2) |
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 = ?) - (85) |
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, 85, 2) |
31 | sfOther | author-items-for-listing-by-category; count-1: 17 |
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, 85, 2, en, 85, 2) |
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, 85, 2, 85, 2, en, 85, 2, 85, 2) |
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 = ?) - (1491) |
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 = ?) - (1630) |
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 (?)) - (1630) |
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 = ?) - (1475) |
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 = ?) - (1614) |
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 (?)) - (1614) |
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 = ?) - (1476) |
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 = ?) - (1615) |
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 (?)) - (1615) |
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 = ?) - (1477) |
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 = ?) - (1616) |
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 (?)) - (1616) |
53 | sfViewCacheManager | Save cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_en_category_id_2_author_id_85" |
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 = ?) - (127) |
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, 127, 2) |
57 | sfOther | author-items-for-listing-by-category; count-1: 1 |
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, 127, 2, en, 127, 2) |
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, 127, 2, 127, 2, en, 127, 2, 127, 2) |
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 = ?) - (5021) |
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 = ?) - (5668) |
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 (?)) - (5668) |
67 | sfViewCacheManager | Save cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_en_category_id_2_author_id_127" |
68 | 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 = ?) - (117) |
69 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorPreview.php" |
70 | 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, 117, 2) |
71 | sfOther | author-items-for-listing-by-category; count-1: 3 |
72 | 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, 117, 2, en, 117, 2) |
73 | sfOther | author-items-for-listing-by-category; needed, found-new: 4, 0 |
74 | 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, 117, 2, 117, 2, en, 117, 2, 117, 2) |
75 | sfViewCacheManager | Discard cache |
76 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorList_images.php" |
77 | 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 = ?) - (5035) |
78 | 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 = ?) - (5687) |
79 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
80 | 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 (?)) - (5687) |
81 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = ?) - (5017) |
82 | 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 = ?) - (5657) |
83 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
84 | 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 (?)) - (5657) |
85 | 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 = ?) - (4515) |
86 | 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 = ?) - (5010) |
87 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
88 | 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 (?)) - (5010) |
89 | sfViewCacheManager | Save cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_en_category_id_2_author_id_117" |
90 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = ?) - (12) |
91 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorPreview.php" |
92 | 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, 12, 2) |
93 | sfOther | author-items-for-listing-by-category; count-1: 1 |
94 | 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, 12, 2, en, 12, 2) |
95 | sfOther | author-items-for-listing-by-category; needed, found-new: 4, 0 |
96 | 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, 12, 2, 12, 2, en, 12, 2, 12, 2) |
97 | sfViewCacheManager | Discard cache |
98 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorList_images.php" |
99 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = ?) - (5038) |
100 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (5692) |
101 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
102 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (5692) |
103 | sfViewCacheManager | Save cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_en_category_id_2_author_id_12" |
104 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = ?) - (96) |
105 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorPreview.php" |
106 | 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, 96, 2) |
107 | sfOther | author-items-for-listing-by-category; count-1: 9 |
108 | 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, 96, 2, en, 96, 2) |
109 | sfOther | author-items-for-listing-by-category; needed, found-new: 4, 0 |
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, 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, 96, 2, 96, 2, en, 96, 2, 96, 2) |
111 | sfViewCacheManager | Discard cache |
112 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorList_images.php" |
113 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = ?) - (4823) |
114 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (5406) |
115 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
116 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (5406) |
117 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = ?) - (4356) |
118 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (4780) |
119 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
120 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (4780) |
121 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = ?) - (4357) |
122 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (4781) |
123 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
124 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (4781) |
125 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = ?) - (4358) |
126 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (4782) |
127 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
128 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (4782) |
129 | sfViewCacheManager | Save cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_en_category_id_2_author_id_96" |
130 | 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 = ?) - (71) |
131 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorPreview.php" |
132 | 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, 71, 2) |
133 | sfOther | author-items-for-listing-by-category; count-1: 1 |
134 | 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, 71, 2, en, 71, 2) |
135 | sfOther | author-items-for-listing-by-category; needed, found-new: 4, 0 |
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, 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, 71, 2, 71, 2, en, 71, 2, 71, 2) |
137 | sfViewCacheManager | Discard cache |
138 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorList_images.php" |
139 | 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 = ?) - (4996) |
140 | 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 = ?) - (5636) |
141 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
142 | 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 (?)) - (5636) |
143 | sfViewCacheManager | Save cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_en_category_id_2_author_id_71" |
144 | 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) |
145 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorPreview.php" |
146 | 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, 2) |
147 | sfOther | author-items-for-listing-by-category; count-1: 13 |
148 | 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, 2, en, 11, 2) |
149 | sfOther | author-items-for-listing-by-category; needed, found-new: 4, 0 |
150 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, 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, 2, 11, 2, en, 11, 2, 11, 2) |
151 | sfViewCacheManager | Discard cache |
152 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorList_images.php" |
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 = ?) - (153) |
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 = ?) - (161) |
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 (?)) - (161) |
157 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = ?) - (141) |
158 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (149) |
159 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
160 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (149) |
161 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = ?) - (144) |
162 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (152) |
163 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
164 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (152) |
165 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = ?) - (145) |
166 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (153) |
167 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
168 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (153) |
169 | sfViewCacheManager | Save cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_en_category_id_2_author_id_11" |
170 | 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) |
171 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorPreview.php" |
172 | 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, 2) |
173 | sfOther | author-items-for-listing-by-category; count-1: 7 |
174 | 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, 2, en, 106, 2) |
175 | sfOther | author-items-for-listing-by-category; needed, found-new: 4, 0 |
176 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, 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, 2, 106, 2, en, 106, 2, 106, 2) |
177 | sfViewCacheManager | Discard cache |
178 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorList_images.php" |
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 = ?) - (4974) |
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 = ?) - (5614) |
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 (?)) - (5614) |
183 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = ?) - (4972) |
184 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (5612) |
185 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
186 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (5612) |
187 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = ?) - (4973) |
188 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (5613) |
189 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
190 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (5613) |
191 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = ?) - (4944) |
192 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (5584) |
193 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
194 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (5584) |
195 | sfViewCacheManager | Save cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_en_category_id_2_author_id_106" |
196 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = ?) - (115) |
197 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorPreview.php" |
198 | 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, 115, 2) |
199 | sfOther | author-items-for-listing-by-category; count-1: 2 |
200 | 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, 115, 2, en, 115, 2) |
201 | sfOther | author-items-for-listing-by-category; needed, found-new: 4, 0 |
202 | 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, 115, 2, 115, 2, en, 115, 2, 115, 2) |
203 | sfViewCacheManager | Discard cache |
204 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorList_images.php" |
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 = ?) - (4510) |
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 = ?) - (5003) |
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 (?)) - (5003) |
209 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = ?) - (4511) |
210 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (5006) |
211 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
212 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (5006) |
213 | sfViewCacheManager | Save cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_en_category_id_2_author_id_115" |
214 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = ?) - (1) |
215 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorPreview.php" |
216 | 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, 1, 2) |
217 | sfOther | author-items-for-listing-by-category; count-1: 15 |
218 | 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, 1, 2, en, 1, 2) |
219 | sfOther | author-items-for-listing-by-category; needed, found-new: 4, 0 |
220 | 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, 1, 2, 1, 2, en, 1, 2, 1, 2) |
221 | sfViewCacheManager | Discard cache |
222 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorList_images.php" |
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 = ?) - (4429) |
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 = ?) - (4860) |
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 (?)) - (4860) |
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 = ?) - (3715) |
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 = ?) - (3989) |
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 (?)) - (3989) |
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 = ?) - (3714) |
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 = ?) - (3988) |
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 (?)) - (3988) |
235 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = ?) - (1554) |
236 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (1693) |
237 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
238 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (1693) |
239 | sfViewCacheManager | Save cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_en_category_id_2_author_id_1" |
240 | sfPHPView | Decorate content with "sf_app_dir/templates/layout.php" |
241 | sfPHPView | Render "sf_app_dir/templates/layout.php" |
242 | main | Call "siteParts->executeMainMenu()" |
243 | sfOther | menu-select: categories; route: authors_by_category_list_en |
244 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_mainMenu.php" |
245 | sfViewCacheManager | Discard cache |
246 | main | Call "siteParts->executeCategoriesMenu()" |
247 | 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 - () |
248 | sfViewCacheManager | Discard cache |
249 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_categoriesMenu.php" |
250 | sfViewCacheManager | Save cache for "@sf_cache_partial?module=siteParts&action=_categoriesMenu&sf_cache_key=k_categories_menu_en" |
251 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_languageBar.php" |
252 | sfWebResponse | Send status "HTTP/1.1 200 OK" |
253 | sfWebResponse | Send header "Content-Type: text/html; charset=utf-8" |
type | calls | time (ms) | time (%) |
---|---|---|---|
Configuration | 16 | 149.03 | 8 |
Factories | 1 | 41.98 | 2 |
Action "site/authorList" | 1 | 217.03 | 11 |
Database (Doctrine) | 128 | 0.74 | 0 |
View "Success" for "site/authorList" | 1 | 1503.56 | 82 |
Partial "site/_authorPreview" | 10 | 1433.05 | 78 |
Partial "site/_authorList_images" | 10 | 297.77 | 16 |
Partial "siteParts/_itemPreview" | 28 | 132.47 | 7 |
Component "siteParts/mainMenu" | 1 | 0.13 | 0 |
Partial "siteParts/_mainMenu" | 1 | 21.14 | 1 |
Component "siteParts/categoriesMenu" | 1 | 9.17 | 0 |
Partial "siteParts/_categoriesMenu" | 1 | 10.33 | 0 |
Partial "siteParts/_languageBar" | 1 | 0.61 | 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 = 'graphics')
SELECT MAX(i.id) AS i__0, i.author_id AS i__1 FROM item i LEFT JOIN author a ON i.author_id = a.id WHERE ((i.is_active IS TRUE AND i.in_stock IS TRUE) AND i.category_id = 2) GROUP BY i.author_id, a.name ORDER BY a.name ASC
SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = 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 = 2) GROUP BY i.id) dctrn_count_query
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i6.created_at FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = 'en' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 85 AND i6.category_id = 2) 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 = 2)) ORDER BY i.created_at DESC
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i9.order_index FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = 'en' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 85 AND i6.category_id = 2) AND (i9.author_id = 85 AND i9.category_id = 2) 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 = 2) AND (i4.author_id = 85 AND i4.category_id = 2)) ORDER BY i4.order_index ASC
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = 1491)
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 = 1630)
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 (1630))
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 = 1475)
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 = 1614)
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 (1614))
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 = 1476)
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 = 1615)
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 (1615))
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 = 1477)
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 = 1616)
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 (1616))
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 = 127)
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 = 127 AND i.category_id = 2) GROUP BY i.id) dctrn_count_query
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i6.created_at FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = 'en' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 127 AND i6.category_id = 2) 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 = 127 AND i.category_id = 2)) ORDER BY i.created_at DESC
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i9.order_index FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = 'en' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 127 AND i6.category_id = 2) AND (i9.author_id = 127 AND i9.category_id = 2) 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 = 127 AND i.category_id = 2) AND (i4.author_id = 127 AND i4.category_id = 2)) ORDER BY i4.order_index ASC
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = 5021)
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 = 5668)
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 (5668))
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 = 117)
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 = 117 AND i.category_id = 2) GROUP BY i.id) dctrn_count_query
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i6.created_at FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = 'en' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 117 AND i6.category_id = 2) 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 = 117 AND i.category_id = 2)) ORDER BY i.created_at DESC
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i9.order_index FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = 'en' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 117 AND i6.category_id = 2) AND (i9.author_id = 117 AND i9.category_id = 2) 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 = 117 AND i.category_id = 2) AND (i4.author_id = 117 AND i4.category_id = 2)) ORDER BY i4.order_index ASC
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = 5035)
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 = 5687)
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 (5687))
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 = 5017)
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 = 5657)
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 (5657))
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 = 4515)
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 = 5010)
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 (5010))
SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = 12)
SELECT COUNT(*) AS num_results FROM (SELECT i.id FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i2.lang = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 12 AND i.category_id = 2) GROUP BY i.id) dctrn_count_query
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i6.created_at FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = 'en' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 12 AND i6.category_id = 2) ORDER BY i6.created_at DESC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 12 AND i.category_id = 2)) ORDER BY i.created_at DESC
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i9.order_index FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = 'en' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 12 AND i6.category_id = 2) AND (i9.author_id = 12 AND i9.category_id = 2) ORDER BY i9.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 12 AND i.category_id = 2) AND (i4.author_id = 12 AND i4.category_id = 2)) ORDER BY i4.order_index ASC
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = 5038)
SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = 5692)
SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (5692))
SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = 96)
SELECT COUNT(*) AS num_results FROM (SELECT i.id FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i2.lang = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 96 AND i.category_id = 2) GROUP BY i.id) dctrn_count_query
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i6.created_at FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = 'en' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 96 AND i6.category_id = 2) ORDER BY i6.created_at DESC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 96 AND i.category_id = 2)) ORDER BY i.created_at DESC
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i9.order_index FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = 'en' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 96 AND i6.category_id = 2) AND (i9.author_id = 96 AND i9.category_id = 2) ORDER BY i9.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 96 AND i.category_id = 2) AND (i4.author_id = 96 AND i4.category_id = 2)) ORDER BY i4.order_index ASC
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = 4823)
SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = 5406)
SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (5406))
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = 4356)
SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = 4780)
SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (4780))
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = 4357)
SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = 4781)
SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (4781))
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = 4358)
SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = 4782)
SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (4782))
SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = 71)
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 = 71 AND i.category_id = 2) GROUP BY i.id) dctrn_count_query
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i6.created_at FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = 'en' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 71 AND i6.category_id = 2) 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 = 71 AND i.category_id = 2)) ORDER BY i.created_at DESC
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i9.order_index FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = 'en' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 71 AND i6.category_id = 2) AND (i9.author_id = 71 AND i9.category_id = 2) 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 = 71 AND i.category_id = 2) AND (i4.author_id = 71 AND i4.category_id = 2)) ORDER BY i4.order_index ASC
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = 4996)
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 = 5636)
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 (5636))
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 = 2) GROUP BY i.id) dctrn_count_query
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i6.created_at FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = 'en' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 11 AND i6.category_id = 2) ORDER BY i6.created_at DESC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 11 AND i.category_id = 2)) ORDER BY i.created_at DESC
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i9.order_index FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = 'en' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 11 AND i6.category_id = 2) AND (i9.author_id = 11 AND i9.category_id = 2) ORDER BY i9.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 11 AND i.category_id = 2) AND (i4.author_id = 11 AND i4.category_id = 2)) ORDER BY i4.order_index ASC
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = 153)
SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = 161)
SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (161))
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = 141)
SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = 149)
SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (149))
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = 144)
SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = 152)
SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (152))
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = 145)
SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = 153)
SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (153))
SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = 106)
SELECT COUNT(*) AS num_results FROM (SELECT i.id FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i2.lang = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 106 AND i.category_id = 2) GROUP BY i.id) dctrn_count_query
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i6.created_at FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = 'en' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 106 AND i6.category_id = 2) ORDER BY i6.created_at DESC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 106 AND i.category_id = 2)) ORDER BY i.created_at DESC
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i9.order_index FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = 'en' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 106 AND i6.category_id = 2) AND (i9.author_id = 106 AND i9.category_id = 2) ORDER BY i9.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 106 AND i.category_id = 2) AND (i4.author_id = 106 AND i4.category_id = 2)) ORDER BY i4.order_index ASC
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = 4974)
SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = 5614)
SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (5614))
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = 4972)
SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = 5612)
SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (5612))
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = 4973)
SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = 5613)
SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (5613))
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = 4944)
SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = 5584)
SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (5584))
SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = 115)
SELECT COUNT(*) AS num_results FROM (SELECT i.id FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i2.lang = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 115 AND i.category_id = 2) GROUP BY i.id) dctrn_count_query
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i6.created_at FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = 'en' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 115 AND i6.category_id = 2) ORDER BY i6.created_at DESC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 115 AND i.category_id = 2)) ORDER BY i.created_at DESC
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i9.order_index FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = 'en' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 115 AND i6.category_id = 2) AND (i9.author_id = 115 AND i9.category_id = 2) ORDER BY i9.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 115 AND i.category_id = 2) AND (i4.author_id = 115 AND i4.category_id = 2)) ORDER BY i4.order_index ASC
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = 4510)
SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = 5003)
SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (5003))
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = 4511)
SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = 5006)
SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (5006))
SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = 1)
SELECT COUNT(*) AS num_results FROM (SELECT i.id FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i2.lang = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 1 AND i.category_id = 2) GROUP BY i.id) dctrn_count_query
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i6.created_at FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = 'en' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 1 AND i6.category_id = 2) ORDER BY i6.created_at DESC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 1 AND i.category_id = 2)) ORDER BY i.created_at DESC
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i9.order_index FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = 'en' AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = 1 AND i6.category_id = 2) AND (i9.author_id = 1 AND i9.category_id = 2) ORDER BY i9.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = 'en' AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = 1 AND i.category_id = 2) AND (i4.author_id = 1 AND i4.category_id = 2)) ORDER BY i4.order_index ASC
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = 4429)
SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = 4860)
SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (4860))
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = 3715)
SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = 3989)
SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (3989))
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = 3714)
SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = 3988)
SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (3988))
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = 1554)
SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = 1693)
SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (1693))
SELECT 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