Dependant
Exhibition Kovács Péter Stumbling Beings
24x28 cm, mixed technique,paper coloured in material
config
view
logs
18176.0 KB
649 ms
39options:
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: kovacs-peter
id: '4878'
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 - Stumbling Beings - Kovács Péter - Dependant'
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:
symfony: bo1508vhek4hvkdmc0g5i6v2r0
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_COOKIE: symfony=bo1508vhek4hvkdmc0g5i6v2r0
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: /author/kovacs-peter/item/4878
PATH_TRANSLATED: 'redirect:/index.php/kovacs-peter/item/4878'
PHP_SELF: /frontend_dev.php/author/kovacs-peter/item/4878
QUERY_STRING: ''
REMOTE_ADDR: 3.145.101.192
REMOTE_PORT: '53154'
REQUEST_METHOD: GET
REQUEST_TIME: 1716069441
REQUEST_TIME_FLOAT: 1716069441.773
REQUEST_URI: /frontend_dev.php/author/kovacs-peter/item/4878
SCRIPT_FILENAME: /home/virtuartnet/current/web/frontend_dev.php
SCRIPT_NAME: /frontend_dev.php
SERVER_ADDR: 195.56.240.69
SERVER_ADMIN: '[no address given]'
SERVER_NAME: www.virtuartnet.hu
SERVER_PORT: '80'
SERVER_PROTOCOL: HTTP/1.1
SERVER_SIGNATURE: ''
SERVER_SOFTWARE: Apache
session:
symfony/user/sfUser/attributes: { }
symfony/user/sfUser/authenticated: false
symfony/user/sfUser/credentials: { }
symfony/user/sfUser/culture: en
symfony/user/sfUser/lastRequest: 1716069440
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:
$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/kovacs-peter/item/4878 with parameters array ( 'module' => 'site', 'action' => 'exhibitionItemDetails', 'sf_culture' => 'en', 'author_slug' => 'kovacs-peter', 'id' => '4878',) |
| 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 = ?) - (4878) |
| 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 = ?) - (78) |
| 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 (?)) - (4878) |
| 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 - (78) |
| 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 - (78, 63) |
| 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 (?)) - (63) |
| 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 (?)) - (4878) |
| 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 - (4878) |
| 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 - (4878) |
| 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 (?)) - (5483) |
| 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 - (4249, en) |
| 40 | sfOther | visible props in abc order: mixed technique, paper coloured in material |
| 41 | sfViewCacheManager | Cache for "@sf_cache_partial?module=siteParts&action=_authorExhibitionRelatedItems&sf_cache_key=1716069442_43422" 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 - (63, 78, 63, 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 - (63, 78, 63, en, en) |
| 45 | sfViewCacheManager | Cache for "@sf_cache_partial?module=siteParts&action=_authorExhibitionRelatedItems&sf_cache_key=1716069442_43422" 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 (?)) - (5487) |
| 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 (?)) - (5477) |
| 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 (?)) - (1502) |
| 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 (?)) - (1501) |
| 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 (?)) - (5482) |
| 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 (?)) - (1493) |
| 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 (?)) - (5483) |
| 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 (?)) - (5486) |
| 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 (?)) - (5484) |
| 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 (?)) - (5478) |
| 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 (?)) - (1498) |
| 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 (?)) - (1500) |
| 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 (?)) - (5485) |
| 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 (?)) - (1499) |
| 75 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
| 76 | 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 (?)) - (5481) |
| 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 (?)) - (5479) |
| 79 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
| 80 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (5480) |
| 81 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
| 82 | 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 (?)) - (1494) |
| 83 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
| 84 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (1495) |
| 85 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
| 86 | 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 (?)) - (1497) |
| 87 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_itemPreview.php" |
| 88 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.width AS i__width, i.height AS i__height, i.size_profile AS i__size_profile, i.image_id AS i__image_id FROM image_size i WHERE (i.image_id IN (?)) - (1496) |
| 89 | sfViewCacheManager | Save cache for "@sf_cache_partial?module=siteParts&action=_authorExhibitionRelatedItems&sf_cache_key=1716069442_43422" |
| 90 | sfViewCacheManager | Cache for "@sf_cache_partial?module=siteParts&action=_authorCategoryRelatedItems&sf_cache_key=k_author_related_category_items_en_category_id_2_author_id_78" exists |
| 91 | main | Call "siteParts->executeAuthorCategoryRelatedItems()" |
| 92 | 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 = ?) - (78) |
| 93 | 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, 78, 78, 2, en, en) |
| 94 | 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 = ?) - (78) |
| 95 | 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, 78, 78, 2, en, en) |
| 96 | sfViewCacheManager | Cache for "@sf_cache_partial?module=siteParts&action=_authorCategoryRelatedItems&sf_cache_key=k_author_related_category_items_en_category_id_2_author_id_78" exists |
| 97 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_authorCategoryRelatedItems.php" |
| 98 | 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_78" |
| 99 | sfPHPView | Decorate content with "sf_app_dir/templates/layout.php" |
| 100 | sfPHPView | Render "sf_app_dir/templates/layout.php" |
| 101 | main | Call "siteParts->executeMainMenu()" |
| 102 | sfOther | menu-select: categories; route: exhibition_item_details_en |
| 103 | sfOther | menu-select: exhibitions; route: exhibition_item_details_en |
| 104 | sfOther | menu-select: children_corner; route: exhibition_item_details_en |
| 105 | sfOther | menu-select: search; route: exhibition_item_details_en |
| 106 | sfOther | menu-select: contact_buy; route: exhibition_item_details_en |
| 107 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_mainMenu.php" |
| 108 | sfViewCacheManager | Cache for "@sf_cache_partial?module=siteParts&action=_categoriesMenu&sf_cache_key=k_categories_menu_en" exists |
| 109 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_languageBar.php" |
| 110 | sfWebResponse | Send status "HTTP/1.1 200 OK" |
| 111 | sfWebResponse | Send header "Content-Type: text/html; charset=utf-8" |
| type | calls | time (ms) | time (%) |
|---|---|---|---|
| Configuration | 18 | 160.84 | 24 |
| Factories | 1 | 42.81 | 6 |
| Action "site/exhibitionItemDetails" | 1 | 267.79 | 41 |
| Database (Doctrine) | 39 | 0.22 | 0 |
| View "Success" for "site/exhibitionItemDetails" | 1 | 293.02 | 45 |
| Component "siteParts/itemPriceInfo" | 1 | 0.14 | 0 |
| Partial "siteParts/_itemPriceInfo" | 1 | 11.88 | 1 |
| Component "siteParts/authorExhibitionRelatedItems" | 1 | 69.73 | 10 |
| Partial "siteParts/_authorExhibitionRelatedItems" | 1 | 106.82 | 16 |
| Partial "siteParts/_itemPreview" | 21 | 87.58 | 13 |
| Component "siteParts/authorCategoryRelatedItems" | 1 | 54.90 | 8 |
| Partial "siteParts/_authorCategoryRelatedItems" | 1 | 14.92 | 2 |
| Component "siteParts/mainMenu" | 1 | 0.42 | 0 |
| Partial "siteParts/_mainMenu" | 1 | 1.73 | 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 = '4878')
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 = 78)
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 (4878))
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 = 78) 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 = 78 AND e.is_visible IS TRUE) AND e.id NOT IN (63) 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 (63))
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 (4878))
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 = 4878 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 = 4878) 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 (5483))
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 = 4249 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 = 63 AND i.author_id = 78 AND e4.exhibition_base_id = 63) 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 = 63 AND i.author_id = 78 AND e4.exhibition_base_id = 63) 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 (5487))
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 (5477))
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 (1502))
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 (1501))
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 (5482))
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 (1493))
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 (5483))
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 (5486))
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 (5484))
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 (5478))
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 (1498))
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 (1500))
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 (5485))
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 (1499))
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 (5481))
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 (5479))
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 (5480))
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 (1494))
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 (1495))
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 (1497))
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 (1496))
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 = 78)
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 = 78 AND i3.author_id = 78 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 = 78)
SELECT i.id AS i__id, i.category_id AS i__category_id, i.main_image_id AS i__main_image_id, i.author_id AS i__author_id, i.is_active AS 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 = 78 AND i3.author_id = 78 AND i3.category_id = 2) AND (i2.lang = 'en' AND c2.lang = 'en') ORDER BY i3.order_index ASC