Funnelied dog
Private property
Funnelied dog (2018)
21x29,5 cm, mixed technique on paper,Signed bottom left and right,Without Frame
Exhibition Für Emil Jake in the Box
Private property
21x29,5 cm, mixed technique on paper,Signed bottom left and right,Without Frame
config
view
logs
18176.0 KB
643 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: '4846'
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 - Funnelied dog'
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/4846
PATH_TRANSLATED: 'redirect:/index.php/fuer-emil/item/4846'
PHP_SELF: /frontend_dev.php/author/fuer-emil/item/4846
QUERY_STRING: ''
REMOTE_ADDR: 216.73.216.41
REMOTE_PORT: '10314'
REQUEST_METHOD: GET
REQUEST_TIME: 1751382243
REQUEST_TIME_FLOAT: 1751382243.665
REQUEST_URI: /frontend_dev.php/author/fuer-emil/item/4846
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/4846 with parameters array ( 'module' => 'site', 'action' => 'exhibitionItemDetails', 'sf_culture' => 'en', 'author_slug' => 'fuer-emil', 'id' => '4846',) |
| 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 = ?) - (4846) |
| 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 (?)) - (4846) |
| 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 (?)) - (4846) |
| 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 - (4846) |
| 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 - (4846) |
| 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 (?)) - (5438) |
| 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 - (4218, en) |
| 40 | sfOther | visible props in abc order: mixed technique on paper, Signed bottom left and right, Without Frame |
| 41 | sfViewCacheManager | Cache for "@sf_cache_partial?module=siteParts&action=_authorExhibitionRelatedItems&sf_cache_key=1751382244_92329" 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=1751382244_92329" 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=1751382244_92329" |
| 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 | 163.38 | 25 |
| Factories | 1 | 49.89 | 7 |
| Action "site/exhibitionItemDetails" | 1 | 282.36 | 43 |
| Database (Doctrine) | 31 | 0.20 | 0 |
| View "Success" for "site/exhibitionItemDetails" | 1 | 258.26 | 40 |
| Component "siteParts/itemPriceInfo" | 1 | 0.14 | 0 |
| Partial "siteParts/_itemPriceInfo" | 1 | 14.64 | 2 |
| Component "siteParts/authorExhibitionRelatedItems" | 1 | 54.18 | 8 |
| Partial "siteParts/_authorExhibitionRelatedItems" | 1 | 89.12 | 13 |
| Partial "siteParts/_itemPreview" | 13 | 81.58 | 12 |
| Component "siteParts/authorCategoryRelatedItems" | 1 | 45.77 | 7 |
| Partial "siteParts/_authorCategoryRelatedItems" | 1 | 7.51 | 1 |
| Component "siteParts/mainMenu" | 1 | 0.57 | 0 |
| Partial "siteParts/_mainMenu" | 1 | 2.25 | 0 |
| Partial "siteParts/_languageBar" | 1 | 0.71 | 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 = '4846')
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 (4846))
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 (4846))
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 = 4846 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 = 4846) 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 (5438))
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 = 4218 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