The bewitched men
Exhibition Für Emil Jake in the Box
29,5x21 cm, mixed technique on paper,Signed bottom left and right
config
view
logs
18176.0 KB
624 ms
31options:
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: exhibitionItemDetails
author_slug: fuer-emil
id: '4838'
module: site
sf_culture: en
attributeHolder:
sf_route: 'sfDoctrineRoute Object()'
status:
code: 200
text: OK
options:
http_protocol: HTTP/1.1
logging: '1'
charset: utf-8
send_http_headers: false
content_type: 'text/html; charset=utf-8'
cookies: { }
httpHeaders:
Content-Type: 'text/html; charset=utf-8'
javascripts:
jquery-1.3.2.min.js: { }
jquery.carousel.js: { }
jquery.jcarousel.js: { }
jquery.tipsy.js: { }
apps.js: { }
menu.js: { }
stylesheets:
screen.css: { }
carousel.css: { }
/css/en.css: { }
metas:
title: 'VirtuArtNet - Kiállítás - Jake in the Box - Für Emil - The bewitched men'
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 symfony.view.site_exhibitionItemDetails_template: itemDetails
cookie: { }
env: { }
files: { }
get: { }
post: { }
server:
DOCUMENT_ROOT: /home/virtuartnet/current/web
GATEWAY_INTERFACE: CGI/1.1
HTTP_ACCEPT: '*/*'
HTTP_ACCEPT_ENCODING: 'gzip, br, zstd, deflate'
HTTP_CACHE_CONTROL: max-age=259200
HTTP_CONNECTION: keep-alive
HTTP_HOST: www.virtuartnet.hu
HTTP_USER_AGENT: 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'
HTTP_VIA: '1.1 squid-proxy-5b5d847c96-nltkx (squid/6.10)'
HTTP_X_FORWARDED_FOR: 10.3.93.175
PATH: '/usr/local/bin:/usr/bin:/bin'
PATH_INFO: /author/fuer-emil/item/4838
PATH_TRANSLATED: 'redirect:/index.php/fuer-emil/item/4838'
PHP_SELF: /frontend_dev.php/author/fuer-emil/item/4838
QUERY_STRING: ''
REMOTE_ADDR: 216.73.216.41
REMOTE_PORT: '45818'
REQUEST_METHOD: GET
REQUEST_TIME: 1751382470
REQUEST_TIME_FLOAT: 1751382470.052
REQUEST_URI: /frontend_dev.php/author/fuer-emil/item/4838
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:
$item (Item)$author (Author)$actual_group (array)$related_items_groups (array)Parameters:
$price (sfOutputEscaperIteratorDecorator)$has_price (boolean)$price_info (array)Parameters:
$author (Author)$except_items (array)$exhibition (Exhibition)$add_carousel_id (string)$related_item_count (integer)$items (Doctrine_Collection)Parameters:
$item (sfOutputEscaperIteratorDecorator)$height (integer)$type (string)$show_title (boolean)Parameters:
$item (sfOutputEscaperIteratorDecorator)$height (integer)$type (string)$show_title (boolean)Parameters:
$item (sfOutputEscaperIteratorDecorator)$height (integer)$type (string)$show_title (boolean)Parameters:
$item (sfOutputEscaperIteratorDecorator)$height (integer)$type (string)$show_title (boolean)Parameters:
$item (sfOutputEscaperIteratorDecorator)$height (integer)$type (string)$show_title (boolean)Parameters:
$item (sfOutputEscaperIteratorDecorator)$height (integer)$type (string)$show_title (boolean)Parameters:
$item (sfOutputEscaperIteratorDecorator)$height (integer)$type (string)$show_title (boolean)Parameters:
$item (sfOutputEscaperIteratorDecorator)$height (integer)$type (string)$show_title (boolean)Parameters:
$item (sfOutputEscaperIteratorDecorator)$height (integer)$type (string)$show_title (boolean)Parameters:
$item (sfOutputEscaperIteratorDecorator)$height (integer)$type (string)$show_title (boolean)Parameters:
$item (sfOutputEscaperIteratorDecorator)$height (integer)$type (string)$show_title (boolean)Parameters:
$item (sfOutputEscaperIteratorDecorator)$height (integer)$type (string)$show_title (boolean)Parameters:
$item (sfOutputEscaperIteratorDecorator)$height (integer)$type (string)$show_title (boolean)Parameters:
$author (Author)$except_items (array)$category (Category)$related_item_count (integer)$items (Doctrine_Collection)Parameters:
$menu_items (array)$selected_menu_item (NULL)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 "exhibition_item_details_en" (/author/:author_slug/item/:id) for /author/fuer-emil/item/4838 with parameters array ( 'module' => 'site', 'action' => 'exhibitionItemDetails', 'sf_culture' => 'en', 'author_slug' => 'fuer-emil', 'id' => '4838',) |
| 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->executeExhibitionItemDetails()" |
| 24 | Doctrine_Connection_Pgsql | exec : SET NAMES 'UTF8' - () |
| 25 | 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 = ?) - (4838) |
| 26 | 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 FROM author a WHERE (a.id = ?) - (66) |
| 27 | Doctrine_Connection_Statement | execute : SELECT e.id AS e__id, e.is_visible AS e__is_visible, e.start_date AS e__start_date, e.type AS e__type, e.created_at AS e__created_at, e.updated_at AS e__updated_at, e2.item_id AS e2__item_id, e2.exhibition_id AS e2__exhibition_id FROM exhibition e LEFT JOIN exhibition_item e2 ON e.id = e2.exhibition_id WHERE (e2.item_id IN (?)) - (4838) |
| 28 | Doctrine_Connection_Statement | execute : SELECT DISTINCT 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, i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS 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 category c LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN item i ON c.id = i.category_id WHERE (i.is_active IS TRUE AND i.author_id = ?) ORDER BY c.id ASC - (66) |
| 29 | Doctrine_Connection_Statement | execute : SELECT e.id AS e__id, e.is_visible AS e__is_visible, e.start_date AS e__start_date, e.type AS e__type, e.created_at AS e__created_at, e.updated_at AS e__updated_at, e2.id AS e2__id, e2.title AS e2__title, e2.subtitle AS e2__subtitle, e2.body AS e2__body, e2.lang AS e2__lang, e2.slug AS e2__slug, e2.created_at AS e2__created_at, e2.updated_at AS e2__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 FROM exhibition e LEFT JOIN exhibition_translation e2 ON e.id = e2.id LEFT JOIN exhibition_author e3 ON (e.id = e3.exhibition_id) LEFT JOIN author a ON a.id = e3.author_id WHERE (a.id = ? AND e.is_visible IS TRUE) AND e.id NOT IN (?) ORDER BY e2.title ASC - (66, 62) |
| 30 | siteActions | Change template to "CURRENT/itemDetails" |
| 31 | Doctrine_Connection_Statement | execute : SELECT e.id AS e__id, e.title AS e__title, e.subtitle AS e__subtitle, e.body AS e__body, e.lang AS e__lang, e.slug AS e__slug, e.created_at AS e__created_at, e.updated_at AS e__updated_at FROM exhibition_translation e WHERE (e.id IN (?)) - (62) |
| 32 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.title AS i__title, i.lang AS i__lang, i.slug AS i__slug, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item_translation i WHERE (i.id IN (?)) - (4838) |
| 33 | sfPHPView | Render "sf_app_dir/modules/site/templates/itemDetailsSuccess.php" |
| 34 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.item_id AS p__item_id, p.price AS p__price, p.price_to AS p__price_to, p.is_active AS p__is_active, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p2.id AS p2__id, p2.title AS p2__title, p2.description AS p2__description, p2.created AS p2__created, p2.lang AS p2__lang, p2.created_at AS p2__created_at, p2.updated_at AS p2__updated_at FROM price p LEFT JOIN price_translation p2 ON p.id = p2.id WHERE (p.item_id = ? AND p.is_active IS TRUE) ORDER BY p.created_at ASC - (4838) |
| 35 | 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.item_id = ?) ORDER BY i.position ASC - (4838) |
| 36 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.description AS i__description, i.lang AS i__lang, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM image_translation i WHERE (i.id IN (?)) - (5426) |
| 37 | main | Call "siteParts->executeItemPriceInfo()" |
| 38 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPriceInfo.php" |
| 39 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.is_active AS p__is_active, p2.id AS p2__id, p2.item_id AS p2__item_id, p2.price AS p2__price, p2.price_to AS p2__price_to, p2.is_active AS p2__is_active, p2.created_at AS p2__created_at, p2.updated_at AS p2__updated_at, p4.id AS p4__id, p4.title AS p4__title, p4.lang AS p4__lang FROM property p LEFT JOIN price_has_property p3 ON (p.id = p3.property_id) LEFT JOIN price p2 ON p2.id = p3.price_id LEFT JOIN property_translation p4 ON p.id = p4.id WHERE (p2.id = ? AND p.is_active IS TRUE AND p4.lang = ?) ORDER BY p4.title ASC - (4210, en) |
| 40 | sfOther | visible props in abc order: mixed technique on paper, Signed bottom left and right |
| 41 | sfViewCacheManager | Cache for "@sf_cache_partial?module=siteParts&action=_authorExhibitionRelatedItems&sf_cache_key=1751382470_64951" does not exist |
| 42 | main | Call "siteParts->executeAuthorExhibitionRelatedItems()" |
| 43 | Doctrine_Connection_Statement | execute : SELECT COUNT(*) AS num_results FROM (SELECT i.id FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN image i2 ON i.main_image_id = i2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_translation i4 ON i.id = i4.id LEFT JOIN exhibition_item e2 ON (i.id = e2.item_id) LEFT JOIN exhibition e ON e.id = e2.exhibition_id LEFT JOIN exhibition_translation e3 ON e.id = e3.id LEFT JOIN exhibition_order e4 ON i.id = e4.item_id WHERE (i.is_active IS TRUE AND e.id = ? AND i.author_id = ? AND e4.exhibition_base_id = ?) AND (i4.lang = ? AND e3.lang = ?) GROUP BY i.id) dctrn_count_query - (62, 66, 62, en, en) |
| 44 | 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, i2.id AS i2__id, i2.item_id AS i2__item_id, i2.filename AS i2__filename, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, i2.position AS i2__position, 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.title AS i4__title, i4.lang AS i4__lang, i4.slug AS i4__slug, i4.created_at AS i4__created_at, i4.updated_at AS i4__updated_at, e.id AS e__id, e.is_visible AS e__is_visible, e.start_date AS e__start_date, e.type AS e__type, e.created_at AS e__created_at, e.updated_at AS e__updated_at, e3.id AS e3__id, e3.title AS e3__title, e3.subtitle AS e3__subtitle, e3.body AS e3__body, e3.lang AS e3__lang, e3.slug AS e3__slug, e3.created_at AS e3__created_at, e3.updated_at AS e3__updated_at, e4.id AS e4__id, e4.exhibition_base_id AS e4__exhibition_base_id, e4.item_id AS e4__item_id, e4.order_index AS e4__order_index FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN image i2 ON i.main_image_id = i2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_translation i4 ON i.id = i4.id LEFT JOIN exhibition_item e2 ON (i.id = e2.item_id) LEFT JOIN exhibition e ON e.id = e2.exhibition_id LEFT JOIN exhibition_translation e3 ON e.id = e3.id LEFT JOIN exhibition_order e4 ON i.id = e4.item_id WHERE (i.is_active IS TRUE AND e.id = ? AND i.author_id = ? AND e4.exhibition_base_id = ?) AND (i4.lang = ? AND e3.lang = ?) ORDER BY e4.order_index ASC - (62, 66, 62, en, en) |
| 45 | sfViewCacheManager | Cache for "@sf_cache_partial?module=siteParts&action=_authorExhibitionRelatedItems&sf_cache_key=1751382470_64951" does not exist |
| 46 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_authorExhibitionRelatedItems.php" |
| 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 (?)) - (5427) |
| 49 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
| 50 | 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 (?)) - (5429) |
| 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 (?)) - (5436) |
| 53 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
| 54 | 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 (?)) - (5428) |
| 55 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
| 56 | 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 (?)) - (5431) |
| 57 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
| 58 | 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 (?)) - (5426) |
| 59 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
| 60 | 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 (?)) - (5424) |
| 61 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
| 62 | 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 (?)) - (5432) |
| 63 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
| 64 | 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 (?)) - (5425) |
| 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 (?)) - (5430) |
| 67 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
| 68 | 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 (?)) - (5435) |
| 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 (?)) - (5437) |
| 71 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
| 72 | 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 (?)) - (5438) |
| 73 | sfViewCacheManager | Save cache for "@sf_cache_partial?module=siteParts&action=_authorExhibitionRelatedItems&sf_cache_key=1751382470_64951" |
| 74 | sfViewCacheManager | Cache for "@sf_cache_partial?module=siteParts&action=_authorCategoryRelatedItems&sf_cache_key=k_author_related_category_items_en_category_id_2_author_id_66" exists |
| 75 | main | Call "siteParts->executeAuthorCategoryRelatedItems()" |
| 76 | Doctrine_Connection_Statement | execute : SELECT e.id AS e__id, e.is_visible AS e__is_visible, e.start_date AS e__start_date, e.type AS e__type, e.created_at AS e__created_at, e.updated_at AS e__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, i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS 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 exhibition e LEFT JOIN exhibition_author e2 ON (e.id = e2.exhibition_id) LEFT JOIN author a ON a.id = e2.author_id LEFT JOIN exhibition_item e3 ON (e.id = e3.exhibition_id) LEFT JOIN item i ON i.id = e3.item_id WHERE (e.is_visible IS TRUE AND i.is_active IS TRUE AND a.id = ?) - (66) |
| 77 | Doctrine_Connection_Statement | execute : SELECT COUNT(*) AS num_results FROM (SELECT i.id FROM item i LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN item_order i3 ON i.id = i3.item_id LEFT JOIN image i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i4.id = i5.id WHERE (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.category_id = ? AND i.author_id = ? AND i3.author_id = ? AND i3.category_id = ?) AND (i2.lang = ? AND c2.lang = ?) GROUP BY i.id) dctrn_count_query - (2, 66, 66, 2, en, en) |
| 78 | Doctrine_Connection_Statement | execute : SELECT e.id AS e__id, e.is_visible AS e__is_visible, e.start_date AS e__start_date, e.type AS e__type, e.created_at AS e__created_at, e.updated_at AS e__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, i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS 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 exhibition e LEFT JOIN exhibition_author e2 ON (e.id = e2.exhibition_id) LEFT JOIN author a ON a.id = e2.author_id LEFT JOIN exhibition_item e3 ON (e.id = e3.exhibition_id) LEFT JOIN item i ON i.id = e3.item_id WHERE (e.is_visible IS TRUE AND i.is_active IS TRUE AND a.id = ?) - (66) |
| 79 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, 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, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, 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.category_id AS i3__category_id, i3.author_id AS i3__author_id, i3.order_index AS i3__order_index, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.filename AS i4__filename, i4.created_at AS i4__created_at, i4.updated_at AS i4__updated_at, i4.position AS i4__position, 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 item_translation i2 ON i.id = i2.id LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN item_order i3 ON i.id = i3.item_id LEFT JOIN image i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i4.id = i5.id WHERE (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.category_id = ? AND i.author_id = ? AND i3.author_id = ? AND i3.category_id = ?) AND (i2.lang = ? AND c2.lang = ?) ORDER BY i3.order_index ASC - (2, 66, 66, 2, en, en) |
| 80 | sfViewCacheManager | Cache for "@sf_cache_partial?module=siteParts&action=_authorCategoryRelatedItems&sf_cache_key=k_author_related_category_items_en_category_id_2_author_id_66" exists |
| 81 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_authorCategoryRelatedItems.php" |
| 82 | sfViewCacheManager | Save cache for "@sf_cache_partial?module=siteParts&action=_authorCategoryRelatedItems&sf_cache_key=k_author_related_category_items_en_category_id_2_author_id_66" |
| 83 | sfPHPView | Decorate content with "sf_app_dir/templates/layout.php" |
| 84 | sfPHPView | Render "sf_app_dir/templates/layout.php" |
| 85 | main | Call "siteParts->executeMainMenu()" |
| 86 | sfOther | menu-select: categories; route: exhibition_item_details_en |
| 87 | sfOther | menu-select: exhibitions; route: exhibition_item_details_en |
| 88 | sfOther | menu-select: children_corner; route: exhibition_item_details_en |
| 89 | sfOther | menu-select: search; route: exhibition_item_details_en |
| 90 | sfOther | menu-select: contact_buy; route: exhibition_item_details_en |
| 91 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_mainMenu.php" |
| 92 | sfViewCacheManager | Cache for "@sf_cache_partial?module=siteParts&action=_categoriesMenu&sf_cache_key=k_categories_menu_en" exists |
| 93 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_languageBar.php" |
| 94 | sfWebResponse | Send status "HTTP/1.1 200 OK" |
| 95 | sfWebResponse | Send header "Content-Type: text/html; charset=utf-8" |
| type | calls | time (ms) | time (%) |
|---|---|---|---|
| Configuration | 18 | 157.23 | 25 |
| Factories | 1 | 45.98 | 7 |
| Action "site/exhibitionItemDetails" | 1 | 263.80 | 42 |
| Database (Doctrine) | 31 | 0.19 | 0 |
| View "Success" for "site/exhibitionItemDetails" | 1 | 270.39 | 43 |
| Component "siteParts/itemPriceInfo" | 1 | 0.14 | 0 |
| Partial "siteParts/_itemPriceInfo" | 1 | 12.28 | 1 |
| Component "siteParts/authorExhibitionRelatedItems" | 1 | 56.65 | 9 |
| Partial "siteParts/_authorExhibitionRelatedItems" | 1 | 101.10 | 16 |
| Partial "siteParts/_itemPreview" | 13 | 84.84 | 13 |
| Component "siteParts/authorCategoryRelatedItems" | 1 | 39.85 | 6 |
| Partial "siteParts/_authorCategoryRelatedItems" | 1 | 14.14 | 2 |
| Component "siteParts/mainMenu" | 1 | 0.46 | 0 |
| Partial "siteParts/_mainMenu" | 1 | 1.81 | 0 |
| Partial "siteParts/_languageBar" | 1 | 0.57 | 0 |
SET NAMES 'UTF8'
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS 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 = '4838')
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 FROM author a WHERE (a.id = 66)
SELECT e.id AS e__id, e.is_visible AS e__is_visible, e.start_date AS e__start_date, e.type AS e__type, e.created_at AS e__created_at, e.updated_at AS e__updated_at, e2.item_id AS e2__item_id, e2.exhibition_id AS e2__exhibition_id FROM exhibition e LEFT JOIN exhibition_item e2 ON e.id = e2.exhibition_id WHERE (e2.item_id IN (4838))
SELECT DISTINCT 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, i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS 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 category c LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN item i ON c.id = i.category_id WHERE (i.is_active IS TRUE AND i.author_id = 66) ORDER BY c.id ASC
SELECT e.id AS e__id, e.is_visible AS e__is_visible, e.start_date AS e__start_date, e.type AS e__type, e.created_at AS e__created_at, e.updated_at AS e__updated_at, e2.id AS e2__id, e2.title AS e2__title, e2.subtitle AS e2__subtitle, e2.body AS e2__body, e2.lang AS e2__lang, e2.slug AS e2__slug, e2.created_at AS e2__created_at, e2.updated_at AS e2__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 FROM exhibition e LEFT JOIN exhibition_translation e2 ON e.id = e2.id LEFT JOIN exhibition_author e3 ON (e.id = e3.exhibition_id) LEFT JOIN author a ON a.id = e3.author_id WHERE (a.id = 66 AND e.is_visible IS TRUE) AND e.id NOT IN (62) ORDER BY e2.title ASC
SELECT e.id AS e__id, e.title AS e__title, e.subtitle AS e__subtitle, e.body AS e__body, e.lang AS e__lang, e.slug AS e__slug, e.created_at AS e__created_at, e.updated_at AS e__updated_at FROM exhibition_translation e WHERE (e.id IN (62))
SELECT i.id AS i__id, i.title AS i__title, i.lang AS i__lang, i.slug AS i__slug, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM item_translation i WHERE (i.id IN (4838))
SELECT p.id AS p__id, p.item_id AS p__item_id, p.price AS p__price, p.price_to AS p__price_to, p.is_active AS p__is_active, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p2.id AS p2__id, p2.title AS p2__title, p2.description AS p2__description, p2.created AS p2__created, p2.lang AS p2__lang, p2.created_at AS p2__created_at, p2.updated_at AS p2__updated_at FROM price p LEFT JOIN price_translation p2 ON p.id = p2.id WHERE (p.item_id = 4838 AND p.is_active IS TRUE) ORDER BY p.created_at ASC
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.item_id = 4838) ORDER BY i.position ASC
SELECT i.id AS i__id, i.description AS i__description, i.lang AS i__lang, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM image_translation i WHERE (i.id IN (5426))
SELECT p.id AS p__id, p.is_active AS p__is_active, p2.id AS p2__id, p2.item_id AS p2__item_id, p2.price AS p2__price, p2.price_to AS p2__price_to, p2.is_active AS p2__is_active, p2.created_at AS p2__created_at, p2.updated_at AS p2__updated_at, p4.id AS p4__id, p4.title AS p4__title, p4.lang AS p4__lang FROM property p LEFT JOIN price_has_property p3 ON (p.id = p3.property_id) LEFT JOIN price p2 ON p2.id = p3.price_id LEFT JOIN property_translation p4 ON p.id = p4.id WHERE (p2.id = 4210 AND p.is_active IS TRUE AND p4.lang = 'en') ORDER BY p4.title ASC
SELECT COUNT(*) AS num_results FROM (SELECT i.id FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN image i2 ON i.main_image_id = i2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_translation i4 ON i.id = i4.id LEFT JOIN exhibition_item e2 ON (i.id = e2.item_id) LEFT JOIN exhibition e ON e.id = e2.exhibition_id LEFT JOIN exhibition_translation e3 ON e.id = e3.id LEFT JOIN exhibition_order e4 ON i.id = e4.item_id WHERE (i.is_active IS TRUE AND e.id = 62 AND i.author_id = 66 AND e4.exhibition_base_id = 62) AND (i4.lang = 'en' AND e3.lang = 'en') 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, i2.id AS i2__id, i2.item_id AS i2__item_id, i2.filename AS i2__filename, i2.created_at AS i2__created_at, i2.updated_at AS i2__updated_at, i2.position AS i2__position, 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.title AS i4__title, i4.lang AS i4__lang, i4.slug AS i4__slug, i4.created_at AS i4__created_at, i4.updated_at AS i4__updated_at, e.id AS e__id, e.is_visible AS e__is_visible, e.start_date AS e__start_date, e.type AS e__type, e.created_at AS e__created_at, e.updated_at AS e__updated_at, e3.id AS e3__id, e3.title AS e3__title, e3.subtitle AS e3__subtitle, e3.body AS e3__body, e3.lang AS e3__lang, e3.slug AS e3__slug, e3.created_at AS e3__created_at, e3.updated_at AS e3__updated_at, e4.id AS e4__id, e4.exhibition_base_id AS e4__exhibition_base_id, e4.item_id AS e4__item_id, e4.order_index AS e4__order_index FROM item i LEFT JOIN author a ON i.author_id = a.id LEFT JOIN image i2 ON i.main_image_id = i2.id LEFT JOIN image i3 ON i.id = i3.item_id LEFT JOIN item_translation i4 ON i.id = i4.id LEFT JOIN exhibition_item e2 ON (i.id = e2.item_id) LEFT JOIN exhibition e ON e.id = e2.exhibition_id LEFT JOIN exhibition_translation e3 ON e.id = e3.id LEFT JOIN exhibition_order e4 ON i.id = e4.item_id WHERE (i.is_active IS TRUE AND e.id = 62 AND i.author_id = 66 AND e4.exhibition_base_id = 62) AND (i4.lang = 'en' AND e3.lang = 'en') ORDER BY e4.order_index ASC
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 (5427))
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 (5429))
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 (5436))
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 (5428))
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 (5431))
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 (5426))
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 (5424))
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 (5432))
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 (5425))
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 (5430))
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 (5435))
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 (5437))
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 (5438))
SELECT e.id AS e__id, e.is_visible AS e__is_visible, e.start_date AS e__start_date, e.type AS e__type, e.created_at AS e__created_at, e.updated_at AS e__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, i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS 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 exhibition e LEFT JOIN exhibition_author e2 ON (e.id = e2.exhibition_id) LEFT JOIN author a ON a.id = e2.author_id LEFT JOIN exhibition_item e3 ON (e.id = e3.exhibition_id) LEFT JOIN item i ON i.id = e3.item_id WHERE (e.is_visible IS TRUE AND i.is_active IS TRUE AND a.id = 66)
SELECT COUNT(*) AS num_results FROM (SELECT i.id FROM item i LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN item_order i3 ON i.id = i3.item_id LEFT JOIN image i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i4.id = i5.id WHERE (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.category_id = 2 AND i.author_id = 66 AND i3.author_id = 66 AND i3.category_id = 2) AND (i2.lang = 'en' AND c2.lang = 'en') GROUP BY i.id) dctrn_count_query
SELECT e.id AS e__id, e.is_visible AS e__is_visible, e.start_date AS e__start_date, e.type AS e__type, e.created_at AS e__created_at, e.updated_at AS e__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, i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS 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 exhibition e LEFT JOIN exhibition_author e2 ON (e.id = e2.exhibition_id) LEFT JOIN author a ON a.id = e2.author_id LEFT JOIN exhibition_item e3 ON (e.id = e3.exhibition_id) LEFT JOIN item i ON i.id = e3.item_id WHERE (e.is_visible IS TRUE AND i.is_active IS TRUE AND a.id = 66)
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS i__is_active, i.in_stock AS i__in_stock, i.created_at AS i__created_at, i.updated_at AS i__updated_at, 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, a.id AS a__id, a.name AS a__name, a.is_active AS a__is_active, a.date_birth AS a__date_birth, a.date_death AS a__date_death, a.slug AS a__slug, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang, 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.category_id AS i3__category_id, i3.author_id AS i3__author_id, i3.order_index AS i3__order_index, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.filename AS i4__filename, i4.created_at AS i4__created_at, i4.updated_at AS i4__updated_at, i4.position AS i4__position, 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 item_translation i2 ON i.id = i2.id LEFT JOIN author a ON i.author_id = a.id LEFT JOIN author_translation a2 ON a.id = a2.id LEFT JOIN category c ON i.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id LEFT JOIN item_order i3 ON i.id = i3.item_id LEFT JOIN image i4 ON i.id = i4.item_id LEFT JOIN image_translation i5 ON i4.id = i5.id WHERE (i.in_stock IS TRUE AND i.is_active IS TRUE AND i.category_id = 2 AND i.author_id = 66 AND i3.author_id = 66 AND i3.category_id = 2) AND (i2.lang = 'en' AND c2.lang = 'en') ORDER BY i3.order_index ASC