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 sf_culture: en slug: ceramic 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 - Ceramic' 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: { } env: { } files: { } get: _sf_ignore_cache: '1' post: { } server: DOCUMENT_ROOT: /home/virtuartnet/current/web GATEWAY_INTERFACE: CGI/1.1 HTTP_ACCEPT: '*/*' 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/ceramic PATH_TRANSLATED: 'redirect:/index.php/ceramic' PHP_SELF: /frontend_dev.php/authors-by-category/ceramic QUERY_STRING: _sf_ignore_cache=1 REMOTE_ADDR: 18.227.190.93 REMOTE_PORT: '47998' REQUEST_METHOD: GET REQUEST_TIME: 1714957506 REQUEST_TIME_FLOAT: 1714957506.909 REQUEST_URI: /frontend_dev.php/authors-by-category/ceramic?_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: { }
php: 5.4.45-0+deb7u14 os: 'Linux tade 3.2.0-6-amd64 #1 SMP Debian 3.2.102-1 x86_64' extensions: 41: apache2handler 7: bcmath 8: bz2 9: calendar 0: 'Core (5.4.45-0+deb7u14)' 10: ctype 43: curl 1: 'date (5.4.45-0+deb7u14)' 11: dba 12: 'dom (20031129)' 2: ereg 31: 'exif (1.4 $Id: 05041c5f0094cb46d9b516bd624d593b90cc38f9 $)' 14: 'fileinfo (1.0.5)' 15: 'filter (0.11.0)' 16: ftp 44: gd 17: gettext 13: 'hash (1.0)' 19: iconv 58: 'imagick (3.1.0RC1)' 45: imap 46: 'intl (1.1.0)' 20: 'json (1.2.1)' 47: ldap 3: libxml 21: mbstring 48: mcrypt 60: mhash 49: 'mysql (1.0)' 50: 'mysqli (0.1)' 4: openssl 5: pcre 42: 'PDO (1.0.4dev)' 51: 'pdo_mysql (1.0.2)' 52: 'pdo_pgsql (1.0.2)' 53: 'pdo_sqlite (1.0.1)' 54: pgsql 30: 'Phar (2.0.1)' 59: 'phpwkhtmltox (0.10)' 23: posix 24: 'Reflection ($Id: f6367cdb4e3f392af4a6d441a6641de87c2e50c4 $)' 22: session 26: shmop 27: 'SimpleXML (0.1)' 28: soap 29: sockets 18: 'SPL (0.2)' 55: 'sqlite3 (0.7)' 25: 'standard (5.4.45-0+deb7u14)' 32: sysvmsg 33: sysvsem 34: sysvshm 35: 'tokenizer (0.1)' 36: wddx 37: xml 38: 'xmlreader (0.1)' 56: 'xmlrpc (0.51)' 39: 'xmlwriter (0.1)' 57: 'xsl (0.1)' 40: 'zip (1.11.0)' 6: 'zlib (2.0)'
version: 1.4.2 path: /home/virtuartnet/releases/2013-03-06T155106/lib/vendor/symfony/lib
Parameters:
$category
(Category)$pager
(vaPager)Parameters:
$author
(Author)$category
(sfOutputEscaperIteratorDecorator)$items_num_to_show
(integer)$show_new_items
(boolean)Parameters:
$items
(array)Parameters:
$item
(sfOutputEscaperIteratorDecorator)$height
(integer)$show_new_caption
(boolean)$type
(NULL)$main_image
(sfOutputEscaperIteratorDecorator)Parameters:
$item
(sfOutputEscaperIteratorDecorator)$height
(integer)$show_new_caption
(boolean)$type
(NULL)$main_image
(sfOutputEscaperIteratorDecorator)Parameters:
$item
(sfOutputEscaperIteratorDecorator)$height
(integer)$show_new_caption
(boolean)$type
(NULL)$main_image
(sfOutputEscaperIteratorDecorator)Parameters:
$item
(sfOutputEscaperIteratorDecorator)$height
(integer)$show_new_caption
(boolean)$type
(NULL)$main_image
(sfOutputEscaperIteratorDecorator)Parameters:
$author
(Author)$category
(sfOutputEscaperIteratorDecorator)$items_num_to_show
(integer)$show_new_items
(boolean)Parameters:
$items
(array)Parameters:
$item
(sfOutputEscaperIteratorDecorator)$height
(integer)$show_new_caption
(boolean)$type
(NULL)$main_image
(sfOutputEscaperIteratorDecorator)Parameters:
$item
(sfOutputEscaperIteratorDecorator)$height
(integer)$show_new_caption
(boolean)$type
(NULL)$main_image
(sfOutputEscaperIteratorDecorator)Parameters:
$item
(sfOutputEscaperIteratorDecorator)$height
(integer)$show_new_caption
(boolean)$type
(NULL)$main_image
(sfOutputEscaperIteratorDecorator)Parameters:
$item
(sfOutputEscaperIteratorDecorator)$height
(integer)$show_new_caption
(boolean)$type
(NULL)$main_image
(sfOutputEscaperIteratorDecorator)Parameters:
$author
(Author)$category
(sfOutputEscaperIteratorDecorator)$items_num_to_show
(integer)$show_new_items
(boolean)Parameters:
$items
(array)Parameters:
$item
(sfOutputEscaperIteratorDecorator)$height
(integer)$show_new_caption
(boolean)$type
(NULL)$main_image
(sfOutputEscaperIteratorDecorator)Parameters:
$item
(sfOutputEscaperIteratorDecorator)$height
(integer)$show_new_caption
(boolean)$type
(NULL)$main_image
(sfOutputEscaperIteratorDecorator)Parameters:
$item
(sfOutputEscaperIteratorDecorator)$height
(integer)$show_new_caption
(boolean)$type
(NULL)$main_image
(sfOutputEscaperIteratorDecorator)Parameters:
$item
(sfOutputEscaperIteratorDecorator)$height
(integer)$show_new_caption
(boolean)$type
(NULL)$main_image
(sfOutputEscaperIteratorDecorator)Parameters:
$author
(Author)$category
(sfOutputEscaperIteratorDecorator)$items_num_to_show
(integer)$show_new_items
(boolean)Parameters:
$items
(array)Parameters:
$item
(sfOutputEscaperIteratorDecorator)$height
(integer)$show_new_caption
(boolean)$type
(NULL)$main_image
(sfOutputEscaperIteratorDecorator)Parameters:
$item
(sfOutputEscaperIteratorDecorator)$height
(integer)$show_new_caption
(boolean)$type
(NULL)$main_image
(sfOutputEscaperIteratorDecorator)Parameters:
$item
(sfOutputEscaperIteratorDecorator)$height
(integer)$show_new_caption
(boolean)$type
(NULL)$main_image
(sfOutputEscaperIteratorDecorator)Parameters:
$item
(sfOutputEscaperIteratorDecorator)$height
(integer)$show_new_caption
(boolean)$type
(NULL)$main_image
(sfOutputEscaperIteratorDecorator)Parameters:
$author
(Author)$category
(sfOutputEscaperIteratorDecorator)$items_num_to_show
(integer)$show_new_items
(boolean)Parameters:
$items
(array)Parameters:
$item
(sfOutputEscaperIteratorDecorator)$height
(integer)$show_new_caption
(boolean)$type
(NULL)$main_image
(sfOutputEscaperIteratorDecorator)Parameters:
$item
(sfOutputEscaperIteratorDecorator)$height
(integer)$show_new_caption
(boolean)$type
(NULL)$main_image
(sfOutputEscaperIteratorDecorator)Parameters:
$item
(sfOutputEscaperIteratorDecorator)$height
(integer)$show_new_caption
(boolean)$type
(NULL)$main_image
(sfOutputEscaperIteratorDecorator)Parameters:
$item
(sfOutputEscaperIteratorDecorator)$height
(integer)$show_new_caption
(boolean)$type
(NULL)$main_image
(sfOutputEscaperIteratorDecorator)Parameters:
$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/ceramic with parameters array ( 'module' => 'site', 'action' => 'authorList', 'sf_culture' => 'en', 'slug' => 'ceramic',) |
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 = ?) - (ceramic) |
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 - (4) |
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 = ?) - (38) |
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, 38, 4) |
31 | sfOther | author-items-for-listing-by-category; count-1: 16 |
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, 38, 4, en, 38, 4) |
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, 38, 4, 38, 4, en, 38, 4, 38, 4) |
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 = ?) - (4509) |
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 = ?) - (5002) |
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 (?)) - (5002) |
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 = ?) - (4486) |
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 = ?) - (4971) |
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 (?)) - (4971) |
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 = ?) - (4439) |
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 = ?) - (4875) |
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 (?)) - (4875) |
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 = ?) - (4000) |
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 = ?) - (4326) |
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 (?)) - (4326) |
53 | sfViewCacheManager | Save cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_en_category_id_4_author_id_38" |
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 = ?) - (91) |
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, 91, 4) |
57 | sfOther | author-items-for-listing-by-category; count-1: 13 |
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, 91, 4, en, 91, 4) |
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, 91, 4, 91, 4, en, 91, 4, 91, 4) |
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 = ?) - (3994) |
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 = ?) - (4317) |
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 (?)) - (4317) |
67 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = ?) - (3993) |
68 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (4315) |
69 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
70 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (4315) |
71 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = ?) - (3992) |
72 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (4313) |
73 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
74 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (4313) |
75 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = ?) - (3986) |
76 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (4304) |
77 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
78 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (4304) |
79 | sfViewCacheManager | Save cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_en_category_id_4_author_id_91" |
80 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = ?) - (47) |
81 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorPreview.php" |
82 | Doctrine_Connection_Statement | execute : SELECT COUNT(*) AS num_results FROM (SELECT i.id FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i2.lang = ? AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = ? AND i.category_id = ?) GROUP BY i.id) dctrn_count_query - (en, 47, 4) |
83 | sfOther | author-items-for-listing-by-category; count-1: 22 |
84 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i6.created_at FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = ? AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = ? AND i6.category_id = ?) ORDER BY i6.created_at DESC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = ? AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = ? AND i.category_id = ?)) ORDER BY i.created_at DESC - (en, 47, 4, en, 47, 4) |
85 | sfOther | author-items-for-listing-by-category; needed, found-new: 4, 0 |
86 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i9.order_index FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = ? AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = ? AND i6.category_id = ?) AND (i9.author_id = ? AND i9.category_id = ?) ORDER BY i9.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = ? AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = ? AND i.category_id = ?) AND (i4.author_id = ? AND i4.category_id = ?)) ORDER BY i4.order_index ASC - (en, 47, 4, 47, 4, en, 47, 4, 47, 4) |
87 | sfViewCacheManager | Discard cache |
88 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorList_images.php" |
89 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = ?) - (4815) |
90 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (5389) |
91 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
92 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (5389) |
93 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = ?) - (4817) |
94 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (5395) |
95 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
96 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (5395) |
97 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = ?) - (4813) |
98 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (5383) |
99 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
100 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (5383) |
101 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = ?) - (4816) |
102 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (5392) |
103 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
104 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (5392) |
105 | sfViewCacheManager | Save cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_en_category_id_4_author_id_47" |
106 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = ?) - (155) |
107 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorPreview.php" |
108 | Doctrine_Connection_Statement | execute : SELECT COUNT(*) AS num_results FROM (SELECT i.id FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i2.lang = ? AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = ? AND i.category_id = ?) GROUP BY i.id) dctrn_count_query - (en, 155, 4) |
109 | sfOther | author-items-for-listing-by-category; count-1: 6 |
110 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i6.created_at FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = ? AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = ? AND i6.category_id = ?) ORDER BY i6.created_at DESC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = ? AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = ? AND i.category_id = ?)) ORDER BY i.created_at DESC - (en, 155, 4, en, 155, 4) |
111 | sfOther | author-items-for-listing-by-category; needed, found-new: 4, 0 |
112 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i9.order_index FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = ? AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = ? AND i6.category_id = ?) AND (i9.author_id = ? AND i9.category_id = ?) ORDER BY i9.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = ? AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = ? AND i.category_id = ?) AND (i4.author_id = ? AND i4.category_id = ?)) ORDER BY i4.order_index ASC - (en, 155, 4, 155, 4, en, 155, 4, 155, 4) |
113 | sfViewCacheManager | Discard cache |
114 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorList_images.php" |
115 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = ?) - (5107) |
116 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (5821) |
117 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
118 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (5821) |
119 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = ?) - (5109) |
120 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (5827) |
121 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
122 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (5827) |
123 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = ?) - (5108) |
124 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (5824) |
125 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
126 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (5824) |
127 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = ?) - (5110) |
128 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (5831) |
129 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
130 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (5831) |
131 | sfViewCacheManager | Save cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_en_category_id_4_author_id_155" |
132 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang FROM author a LEFT JOIN author_translation a2 ON a.id = a2.id WHERE (a.id = ?) - (72) |
133 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorPreview.php" |
134 | Doctrine_Connection_Statement | execute : SELECT COUNT(*) AS num_results FROM (SELECT i.id FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i2.lang = ? AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = ? AND i.category_id = ?) GROUP BY i.id) dctrn_count_query - (en, 72, 4) |
135 | sfOther | author-items-for-listing-by-category; count-1: 36 |
136 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i6.created_at FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = ? AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = ? AND i6.category_id = ?) ORDER BY i6.created_at DESC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = ? AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = ? AND i.category_id = ?)) ORDER BY i.created_at DESC - (en, 72, 4, en, 72, 4) |
137 | sfOther | author-items-for-listing-by-category; needed, found-new: 4, 0 |
138 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, i2.id AS i2__id, i2.title AS i2__title, i2.lang AS i2__lang, i2.slug AS i2__slug, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, c.id AS c__id, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang, c2.slug AS c2__slug, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.category_id AS i4__category_id, i4.author_id AS i4__author_id, i4.order_index AS i4__order_index, i5.id AS i5__id, i5.description AS i5__description, i5.lang AS i5__lang, i5.created_at AS i5__created_at, i5.updated_at AS i5__updated_at FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_order i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i3.id = i5.id WHERE i.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT i6.id, i9.order_index FROM item i6 LEFT JOIN author a3 ON i6.author_id = a3.id LEFT JOIN author_translation a4 ON a3.id = a4.id LEFT JOIN item_translation i7 ON i6.id = i7.id LEFT JOIN category c3 ON i6.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id LEFT JOIN image i8 ON i6.id = i8.item_id LEFT JOIN item_order i9 ON i6.id = i9.item_id LEFT JOIN image_translation i10 ON i8.id = i10.id WHERE i7.lang = ? AND (i6.in_stock IS TRUE AND i6.is_active IS TRUE AND i6.author_id = ? AND i6.category_id = ?) AND (i9.author_id = ? AND i9.category_id = ?) ORDER BY i9.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND (i2.lang = ? AND (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.author_id = ? AND i.category_id = ?) AND (i4.author_id = ? AND i4.category_id = ?)) ORDER BY i4.order_index ASC - (en, 72, 4, 72, 4, en, 72, 4, 72, 4) |
139 | sfViewCacheManager | Discard cache |
140 | sfPartialView | Render "sf_app_dir/modules/site/templates/_authorList_images.php" |
141 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = ?) - (5117) |
142 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (5853) |
143 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
144 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (5853) |
145 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = ?) - (5115) |
146 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (5843) |
147 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
148 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (5843) |
149 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item i WHERE (i.id = ?) - (5106) |
150 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.item_id AS i__item_id, i.filename AS i__filename, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position FROM image i WHERE (i.id = ?) - (5820) |
151 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
152 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (5820) |
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 = ?) - (5105) |
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 = ?) - (5819) |
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 (?)) - (5819) |
157 | sfViewCacheManager | Save cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_en_category_id_4_author_id_72" |
158 | sfPHPView | Decorate content with "sf_app_dir/templates/layout.php" |
159 | sfPHPView | Render "sf_app_dir/templates/layout.php" |
160 | main | Call "siteParts->executeMainMenu()" |
161 | sfOther | menu-select: categories; route: authors_by_category_list_en |
162 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_mainMenu.php" |
163 | sfViewCacheManager | Discard cache |
164 | main | Call "siteParts->executeCategoriesMenu()" |
165 | 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 - () |
166 | sfViewCacheManager | Discard cache |
167 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_categoriesMenu.php" |
168 | sfViewCacheManager | Save cache for "@sf_cache_partial?module=siteParts&action=_categoriesMenu&sf_cache_key=k_categories_menu_en" |
169 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_languageBar.php" |
170 | sfWebResponse | Send status "HTTP/1.1 200 OK" |
171 | sfWebResponse | Send header "Content-Type: text/html; charset=utf-8" |
type | calls | time (ms) | time (%) |
---|---|---|---|
Configuration | 16 | 150.99 | 7 |
Factories | 1 | 45.34 | 2 |
Action "site/authorList" | 1 | 226.79 | 11 |
Database (Doctrine) | 84 | 0.51 | 0 |
View "Success" for "site/authorList" | 1 | 1687.50 | 83 |
Partial "site/_authorPreview" | 5 | 1634.90 | 81 |
Partial "site/_authorList_images" | 5 | 217.04 | 10 |
Partial "siteParts/_itemPreview" | 20 | 95.91 | 4 |
Component "siteParts/mainMenu" | 1 | 0.13 | 0 |
Partial "siteParts/_mainMenu" | 1 | 20.70 | 1 |
Component "siteParts/categoriesMenu" | 1 | 8.85 | 0 |
Partial "siteParts/_categoriesMenu" | 1 | 10.13 | 0 |
Partial "siteParts/_languageBar" | 1 | 0.60 | 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 = 'ceramic')
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 = 4) 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 = 38)
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 = 38 AND i.category_id = 4) 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 = 38 AND i6.category_id = 4) 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 = 38 AND i.category_id = 4)) 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 = 38 AND i6.category_id = 4) AND (i9.author_id = 38 AND i9.category_id = 4) 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 = 38 AND i.category_id = 4) AND (i4.author_id = 38 AND i4.category_id = 4)) 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 = 4509)
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 = 5002)
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 (5002))
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS 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 = 4486)
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 = 4971)
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 (4971))
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS 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 = 4439)
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 = 4875)
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 (4875))
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS 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 = 4000)
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 = 4326)
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 (4326))
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 = 91)
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 = 91 AND i.category_id = 4) 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 = 91 AND i6.category_id = 4) 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 = 91 AND i.category_id = 4)) 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 = 91 AND i6.category_id = 4) AND (i9.author_id = 91 AND i9.category_id = 4) 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 = 91 AND i.category_id = 4) AND (i4.author_id = 91 AND i4.category_id = 4)) 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 = 3994)
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 = 4317)
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 (4317))
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS 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 = 3993)
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 = 4315)
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 (4315))
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS 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 = 3992)
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 = 4313)
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 (4313))
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS 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 = 3986)
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 = 4304)
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 (4304))
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 = 47)
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 = 47 AND i.category_id = 4) 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 = 47 AND i6.category_id = 4) 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 = 47 AND i.category_id = 4)) 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 = 47 AND i6.category_id = 4) AND (i9.author_id = 47 AND i9.category_id = 4) 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 = 47 AND i.category_id = 4) AND (i4.author_id = 47 AND i4.category_id = 4)) 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 = 4815)
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 = 5389)
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 (5389))
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS 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 = 4817)
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 = 5395)
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 (5395))
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS 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 = 4813)
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 = 5383)
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 (5383))
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS 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 = 4816)
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 = 5392)
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 (5392))
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 = 155)
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 = 155 AND i.category_id = 4) 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 = 155 AND i6.category_id = 4) 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 = 155 AND i.category_id = 4)) 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 = 155 AND i6.category_id = 4) AND (i9.author_id = 155 AND i9.category_id = 4) 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 = 155 AND i.category_id = 4) AND (i4.author_id = 155 AND i4.category_id = 4)) 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 = 5107)
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 = 5821)
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 (5821))
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS 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 = 5109)
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 = 5827)
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 (5827))
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS 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 = 5108)
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 = 5824)
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 (5824))
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS 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 = 5110)
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 = 5831)
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 (5831))
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 = 72)
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 = 72 AND i.category_id = 4) 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 = 72 AND i6.category_id = 4) 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 = 72 AND i.category_id = 4)) 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 = 72 AND i6.category_id = 4) AND (i9.author_id = 72 AND i9.category_id = 4) 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 = 72 AND i.category_id = 4) AND (i4.author_id = 72 AND i4.category_id = 4)) 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 = 5117)
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 = 5853)
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 (5853))
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS 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 = 5115)
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 = 5843)
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 (5843))
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS 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 = 5106)
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 = 5820)
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 (5820))
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS 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 = 5105)
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 = 5819)
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 (5819))
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