config
view
logs
17408.0 KB
1320 ms
10options:
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: exhibitionList
module: site
page: '2'
sf_culture: en
attributeHolder:
sf_route: 'sfRoute 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'
description: VirtuArtNet
keywords: 'virtuartnet, art, database, műtárgy, adatbázis'
robots: 'index, follow'
httpMetas:
Content-Type: 'text/html; charset=utf-8'
options:
auto_shutdown: false
culture: en
default_culture: hu
use_flash: true
logging: '1'
timeout: 1800
attributeHolder: { }
culture: en
app_i18n_en_css: /css/en.css mod_site_enabled: true mod_site_view_class: sfPHP mod_siteparts_enabled: true mod_siteparts_view_class: sfPHP sf_admin_module_web_dir: /sfDoctrinePlugin sf_admin_web_dir: /sf/sf_admin sf_app: frontend sf_app_base_cache_dir: /home/virtuartnet/releases/2013-03-06T155106/cache/frontend sf_app_cache_dir: /home/virtuartnet/releases/2013-03-06T155106/cache/frontend/dev sf_app_config_dir: /home/virtuartnet/releases/2013-03-06T155106/apps/frontend/config sf_app_dir: /home/virtuartnet/releases/2013-03-06T155106/apps/frontend sf_app_i18n_dir: /home/virtuartnet/releases/2013-03-06T155106/apps/frontend/i18n sf_app_lib_dir: /home/virtuartnet/releases/2013-03-06T155106/apps/frontend/lib sf_app_module_dir: /home/virtuartnet/releases/2013-03-06T155106/apps/frontend/modules sf_app_template_dir: /home/virtuartnet/releases/2013-03-06T155106/apps/frontend/templates sf_apps_dir: /home/virtuartnet/releases/2013-03-06T155106/apps sf_cache: on sf_cache_dir: /home/virtuartnet/releases/2013-03-06T155106/cache sf_charset: utf-8 sf_check_lock: false sf_compressed: false sf_config_cache_dir: /home/virtuartnet/releases/2013-03-06T155106/cache/frontend/dev/config sf_config_dir: /home/virtuartnet/releases/2013-03-06T155106/config sf_csrf_secret: axTTyze27279 sf_data_dir: /home/virtuartnet/releases/2013-03-06T155106/data sf_debug: true sf_default_culture: hu sf_enabled_modules: - default sf_environment: dev sf_error_404_action: error404 sf_error_404_module: default sf_error_reporting: 32759 sf_escaping_method: ESC_SPECIALCHARS sf_escaping_strategy: on sf_etag: false sf_file_link_format: null sf_i18n: on sf_i18n_cache_dir: /home/virtuartnet/releases/2013-03-06T155106/cache/frontend/dev/i18n sf_lazy_cache_key: on sf_lib_dir: /home/virtuartnet/releases/2013-03-06T155106/lib sf_log_dir: /home/virtuartnet/releases/2013-03-06T155106/log sf_logging_enabled: true sf_login_action: login sf_login_module: default sf_module_cache_dir: /home/virtuartnet/releases/2013-03-06T155106/cache/frontend/dev/modules sf_module_disabled_action: disabled sf_module_disabled_module: default sf_no_script_name: false sf_orm: doctrine sf_plugins_dir: /home/virtuartnet/releases/2013-03-06T155106/plugins sf_root_dir: /home/virtuartnet/releases/2013-03-06T155106 sf_secure_action: secure sf_secure_module: default sf_standard_helpers: - Partial - Cache - I18N - Date sf_symfony_lib_dir: /home/virtuartnet/releases/2013-03-06T155106/lib/vendor/symfony/lib sf_template_cache_dir: /home/virtuartnet/releases/2013-03-06T155106/cache/frontend/dev/template sf_test_cache_dir: /home/virtuartnet/releases/2013-03-06T155106/cache/frontend/dev/test sf_test_dir: /home/virtuartnet/releases/2013-03-06T155106/test sf_upload_dir: /home/virtuartnet/releases/2013-03-06T155106/web/uploads sf_use_database: true sf_web_debug: true sf_web_debug_web_dir: /sf/sf_web_debug sf_web_dir: /home/virtuartnet/releases/2013-03-06T155106/web symfony.asset.javascripts_included: false symfony.asset.stylesheets_included: false
cookie:
symfony: u0arbn3teotbca63aefpm044n6
env: { }
files: { }
get:
page: '2'
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=0
HTTP_CONNECTION: keep-alive
HTTP_COOKIE: symfony=u0arbn3teotbca63aefpm044n6
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-fbblh (squid/6.13)'
HTTP_X_FORWARDED_FOR: 10.3.117.64
PATH: '/usr/local/bin:/usr/bin:/bin'
PATH_INFO: /exhibitions
PATH_TRANSLATED: 'redirect:/index.php'
PHP_SELF: /frontend_dev.php/exhibitions
QUERY_STRING: page=2
REMOTE_ADDR: 216.73.216.121
REMOTE_PORT: '36789'
REQUEST_METHOD: GET
REQUEST_TIME: 1761857170
REQUEST_TIME_FLOAT: 1761857170.192
REQUEST_URI: /frontend_dev.php/exhibitions?page=2
SCRIPT_FILENAME: /home/virtuartnet/current/web/frontend_dev.php
SCRIPT_NAME: /frontend_dev.php
SERVER_ADDR: 213.181.199.139
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: 1761857169
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:
$pager (sfDoctrinePager)Parameters:
$menu_items (array)$selected_menu_item (string)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_list_en" (/exhibitions) for /exhibitions with parameters array ( 'module' => 'site', 'action' => 'exhibitionList', 'sf_culture' => 'en',) |
| 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->executeExhibitionList()" |
| 24 | Doctrine_Connection_Pgsql | exec : SET NAMES 'UTF8' - () |
| 25 | Doctrine_Connection_Pgsql | query : SELECT COUNT(*) AS num_results FROM (SELECT e.id 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 LEFT JOIN author_translation a2 ON a.id = a2.id WHERE e.is_visible IS TRUE AND (e.type = '1') GROUP BY e.id) dctrn_count_query - () |
| 26 | sfPHPView | Render "sf_app_dir/modules/site/templates/exhibitionListSuccess.php" |
| 27 | Doctrine_Connection_Pgsql | 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, 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, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang 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 LEFT JOIN author_translation a2 ON a.id = a2.id WHERE e.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT e4.id, e4.start_date FROM exhibition e4 LEFT JOIN exhibition_translation e5 ON e4.id = e5.id LEFT JOIN exhibition_author e6 ON (e4.id = e6.exhibition_id) LEFT JOIN author a3 ON a3.id = e6.author_id LEFT JOIN author_translation a4 ON a3.id = a4.id WHERE e4.is_visible IS TRUE AND (e4.type = '1') ORDER BY e4.start_date DESC LIMIT 10 OFFSET 10) AS doctrine_subquery_alias) AND (e.is_visible IS TRUE AND (e.type = '1')) ORDER BY e.start_date DESC - () |
| 28 | Doctrine_Connection_Statement | execute : SELECT e.item_id AS e__item_id, e.exhibition_id AS e__exhibition_id, 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, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.filename AS i4__filename, i4.created_at AS i4__created_at, i4.updated_at AS i4__updated_at, i4.position AS i4__position, e2.id AS e2__id, e2.exhibition_base_id AS e2__exhibition_base_id, e2.item_id AS e2__item_id, e2.order_index AS e2__order_index FROM exhibition_item e LEFT JOIN item i ON e.item_id = i.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN author a ON i.author_id = a.id LEFT JOIN image i3 ON i.main_image_id = i3.id LEFT JOIN image i4 ON i.id = i4.item_id LEFT JOIN exhibition_order e2 ON i.id = e2.item_id WHERE e.item_id IN (SELECT doctrine_subquery_alias.item_id FROM (SELECT DISTINCT e3.item_id, e4.order_index FROM exhibition_item e3 LEFT JOIN item i5 ON e3.item_id = i5.id LEFT JOIN item_translation i6 ON i5.id = i6.id LEFT JOIN author a2 ON i5.author_id = a2.id LEFT JOIN image i7 ON i5.main_image_id = i7.id LEFT JOIN image i8 ON i5.id = i8.item_id LEFT JOIN exhibition_order e4 ON i5.id = e4.item_id WHERE (e3.exhibition_id = ? AND e4.exhibition_base_id = ?) AND i5.is_active IS TRUE ORDER BY e4.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND ((e.exhibition_id = ? AND e2.exhibition_base_id = ?) AND i.is_active IS TRUE) ORDER BY e2.order_index ASC - (54, 54, 54, 54) |
| 29 | sfViewCacheManager | Cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_en_exhibition_id_54" exists |
| 30 | Doctrine_Connection_Statement | execute : SELECT e.item_id AS e__item_id, e.exhibition_id AS e__exhibition_id, 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, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.filename AS i4__filename, i4.created_at AS i4__created_at, i4.updated_at AS i4__updated_at, i4.position AS i4__position, e2.id AS e2__id, e2.exhibition_base_id AS e2__exhibition_base_id, e2.item_id AS e2__item_id, e2.order_index AS e2__order_index FROM exhibition_item e LEFT JOIN item i ON e.item_id = i.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN author a ON i.author_id = a.id LEFT JOIN image i3 ON i.main_image_id = i3.id LEFT JOIN image i4 ON i.id = i4.item_id LEFT JOIN exhibition_order e2 ON i.id = e2.item_id WHERE e.item_id IN (SELECT doctrine_subquery_alias.item_id FROM (SELECT DISTINCT e3.item_id, e4.order_index FROM exhibition_item e3 LEFT JOIN item i5 ON e3.item_id = i5.id LEFT JOIN item_translation i6 ON i5.id = i6.id LEFT JOIN author a2 ON i5.author_id = a2.id LEFT JOIN image i7 ON i5.main_image_id = i7.id LEFT JOIN image i8 ON i5.id = i8.item_id LEFT JOIN exhibition_order e4 ON i5.id = e4.item_id WHERE (e3.exhibition_id = ? AND e4.exhibition_base_id = ?) AND i5.is_active IS TRUE ORDER BY e4.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND ((e.exhibition_id = ? AND e2.exhibition_base_id = ?) AND i.is_active IS TRUE) ORDER BY e2.order_index ASC - (16, 16, 16, 16) |
| 31 | sfViewCacheManager | Cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_en_exhibition_id_16" exists |
| 32 | Doctrine_Connection_Statement | execute : SELECT e.item_id AS e__item_id, e.exhibition_id AS e__exhibition_id, 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, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.filename AS i4__filename, i4.created_at AS i4__created_at, i4.updated_at AS i4__updated_at, i4.position AS i4__position, e2.id AS e2__id, e2.exhibition_base_id AS e2__exhibition_base_id, e2.item_id AS e2__item_id, e2.order_index AS e2__order_index FROM exhibition_item e LEFT JOIN item i ON e.item_id = i.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN author a ON i.author_id = a.id LEFT JOIN image i3 ON i.main_image_id = i3.id LEFT JOIN image i4 ON i.id = i4.item_id LEFT JOIN exhibition_order e2 ON i.id = e2.item_id WHERE e.item_id IN (SELECT doctrine_subquery_alias.item_id FROM (SELECT DISTINCT e3.item_id, e4.order_index FROM exhibition_item e3 LEFT JOIN item i5 ON e3.item_id = i5.id LEFT JOIN item_translation i6 ON i5.id = i6.id LEFT JOIN author a2 ON i5.author_id = a2.id LEFT JOIN image i7 ON i5.main_image_id = i7.id LEFT JOIN image i8 ON i5.id = i8.item_id LEFT JOIN exhibition_order e4 ON i5.id = e4.item_id WHERE (e3.exhibition_id = ? AND e4.exhibition_base_id = ?) AND i5.is_active IS TRUE ORDER BY e4.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND ((e.exhibition_id = ? AND e2.exhibition_base_id = ?) AND i.is_active IS TRUE) ORDER BY e2.order_index ASC - (23, 23, 23, 23) |
| 33 | sfViewCacheManager | Cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_en_exhibition_id_23" exists |
| 34 | Doctrine_Connection_Statement | execute : SELECT e.item_id AS e__item_id, e.exhibition_id AS e__exhibition_id, 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, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.filename AS i4__filename, i4.created_at AS i4__created_at, i4.updated_at AS i4__updated_at, i4.position AS i4__position, e2.id AS e2__id, e2.exhibition_base_id AS e2__exhibition_base_id, e2.item_id AS e2__item_id, e2.order_index AS e2__order_index FROM exhibition_item e LEFT JOIN item i ON e.item_id = i.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN author a ON i.author_id = a.id LEFT JOIN image i3 ON i.main_image_id = i3.id LEFT JOIN image i4 ON i.id = i4.item_id LEFT JOIN exhibition_order e2 ON i.id = e2.item_id WHERE e.item_id IN (SELECT doctrine_subquery_alias.item_id FROM (SELECT DISTINCT e3.item_id, e4.order_index FROM exhibition_item e3 LEFT JOIN item i5 ON e3.item_id = i5.id LEFT JOIN item_translation i6 ON i5.id = i6.id LEFT JOIN author a2 ON i5.author_id = a2.id LEFT JOIN image i7 ON i5.main_image_id = i7.id LEFT JOIN image i8 ON i5.id = i8.item_id LEFT JOIN exhibition_order e4 ON i5.id = e4.item_id WHERE (e3.exhibition_id = ? AND e4.exhibition_base_id = ?) AND i5.is_active IS TRUE ORDER BY e4.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND ((e.exhibition_id = ? AND e2.exhibition_base_id = ?) AND i.is_active IS TRUE) ORDER BY e2.order_index ASC - (17, 17, 17, 17) |
| 35 | sfViewCacheManager | Cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_en_exhibition_id_17" exists |
| 36 | Doctrine_Connection_Statement | execute : SELECT e.item_id AS e__item_id, e.exhibition_id AS e__exhibition_id, 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, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.filename AS i4__filename, i4.created_at AS i4__created_at, i4.updated_at AS i4__updated_at, i4.position AS i4__position, e2.id AS e2__id, e2.exhibition_base_id AS e2__exhibition_base_id, e2.item_id AS e2__item_id, e2.order_index AS e2__order_index FROM exhibition_item e LEFT JOIN item i ON e.item_id = i.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN author a ON i.author_id = a.id LEFT JOIN image i3 ON i.main_image_id = i3.id LEFT JOIN image i4 ON i.id = i4.item_id LEFT JOIN exhibition_order e2 ON i.id = e2.item_id WHERE e.item_id IN (SELECT doctrine_subquery_alias.item_id FROM (SELECT DISTINCT e3.item_id, e4.order_index FROM exhibition_item e3 LEFT JOIN item i5 ON e3.item_id = i5.id LEFT JOIN item_translation i6 ON i5.id = i6.id LEFT JOIN author a2 ON i5.author_id = a2.id LEFT JOIN image i7 ON i5.main_image_id = i7.id LEFT JOIN image i8 ON i5.id = i8.item_id LEFT JOIN exhibition_order e4 ON i5.id = e4.item_id WHERE (e3.exhibition_id = ? AND e4.exhibition_base_id = ?) AND i5.is_active IS TRUE ORDER BY e4.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND ((e.exhibition_id = ? AND e2.exhibition_base_id = ?) AND i.is_active IS TRUE) ORDER BY e2.order_index ASC - (21, 21, 21, 21) |
| 37 | sfViewCacheManager | Cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_en_exhibition_id_21" exists |
| 38 | Doctrine_Connection_Statement | execute : SELECT e.item_id AS e__item_id, e.exhibition_id AS e__exhibition_id, 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, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.filename AS i4__filename, i4.created_at AS i4__created_at, i4.updated_at AS i4__updated_at, i4.position AS i4__position, e2.id AS e2__id, e2.exhibition_base_id AS e2__exhibition_base_id, e2.item_id AS e2__item_id, e2.order_index AS e2__order_index FROM exhibition_item e LEFT JOIN item i ON e.item_id = i.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN author a ON i.author_id = a.id LEFT JOIN image i3 ON i.main_image_id = i3.id LEFT JOIN image i4 ON i.id = i4.item_id LEFT JOIN exhibition_order e2 ON i.id = e2.item_id WHERE e.item_id IN (SELECT doctrine_subquery_alias.item_id FROM (SELECT DISTINCT e3.item_id, e4.order_index FROM exhibition_item e3 LEFT JOIN item i5 ON e3.item_id = i5.id LEFT JOIN item_translation i6 ON i5.id = i6.id LEFT JOIN author a2 ON i5.author_id = a2.id LEFT JOIN image i7 ON i5.main_image_id = i7.id LEFT JOIN image i8 ON i5.id = i8.item_id LEFT JOIN exhibition_order e4 ON i5.id = e4.item_id WHERE (e3.exhibition_id = ? AND e4.exhibition_base_id = ?) AND i5.is_active IS TRUE ORDER BY e4.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND ((e.exhibition_id = ? AND e2.exhibition_base_id = ?) AND i.is_active IS TRUE) ORDER BY e2.order_index ASC - (33, 33, 33, 33) |
| 39 | sfViewCacheManager | Cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_en_exhibition_id_33" exists |
| 40 | Doctrine_Connection_Statement | execute : SELECT e.item_id AS e__item_id, e.exhibition_id AS e__exhibition_id, 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, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.filename AS i4__filename, i4.created_at AS i4__created_at, i4.updated_at AS i4__updated_at, i4.position AS i4__position, e2.id AS e2__id, e2.exhibition_base_id AS e2__exhibition_base_id, e2.item_id AS e2__item_id, e2.order_index AS e2__order_index FROM exhibition_item e LEFT JOIN item i ON e.item_id = i.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN author a ON i.author_id = a.id LEFT JOIN image i3 ON i.main_image_id = i3.id LEFT JOIN image i4 ON i.id = i4.item_id LEFT JOIN exhibition_order e2 ON i.id = e2.item_id WHERE e.item_id IN (SELECT doctrine_subquery_alias.item_id FROM (SELECT DISTINCT e3.item_id, e4.order_index FROM exhibition_item e3 LEFT JOIN item i5 ON e3.item_id = i5.id LEFT JOIN item_translation i6 ON i5.id = i6.id LEFT JOIN author a2 ON i5.author_id = a2.id LEFT JOIN image i7 ON i5.main_image_id = i7.id LEFT JOIN image i8 ON i5.id = i8.item_id LEFT JOIN exhibition_order e4 ON i5.id = e4.item_id WHERE (e3.exhibition_id = ? AND e4.exhibition_base_id = ?) AND i5.is_active IS TRUE ORDER BY e4.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND ((e.exhibition_id = ? AND e2.exhibition_base_id = ?) AND i.is_active IS TRUE) ORDER BY e2.order_index ASC - (20, 20, 20, 20) |
| 41 | sfViewCacheManager | Cache for "@sf_cache_partial?module=site&action=_authorList_images&sf_cache_key=k_author_list_images_en_exhibition_id_20" exists |
| 42 | sfPHPView | Decorate content with "sf_app_dir/templates/layout.php" |
| 43 | sfPHPView | Render "sf_app_dir/templates/layout.php" |
| 44 | main | Call "siteParts->executeMainMenu()" |
| 45 | sfOther | menu-select: categories; route: exhibition_list_en |
| 46 | sfOther | menu-select: exhibitions; route: exhibition_list_en |
| 47 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_mainMenu.php" |
| 48 | sfViewCacheManager | Cache for "@sf_cache_partial?module=siteParts&action=_categoriesMenu&sf_cache_key=k_categories_menu_en" exists |
| 49 | sfPartialView | Render "sf_app_dir/modules/siteParts/templates/_languageBar.php" |
| 50 | sfWebResponse | Send status "HTTP/1.1 200 OK" |
| 51 | sfWebResponse | Send header "Content-Type: text/html; charset=utf-8" |
| type | calls | time (ms) | time (%) |
|---|---|---|---|
| Configuration | 15 | 173.85 | 13 |
| Factories | 1 | 559.32 | 42 |
| Action "site/exhibitionList" | 1 | 243.90 | 18 |
| Database (Doctrine) | 10 | 0.08 | 0 |
| View "Success" for "site/exhibitionList" | 1 | 460.05 | 34 |
| Partial "site/_authorList_images" | 1 | 70.06 | 5 |
| Component "siteParts/mainMenu" | 1 | 0.22 | 0 |
| Partial "siteParts/_mainMenu" | 1 | 1.79 | 0 |
| Partial "siteParts/_languageBar" | 1 | 0.58 | 0 |
SET NAMES 'UTF8'
SELECT COUNT(*) AS num_results FROM (SELECT e.id 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 LEFT JOIN author_translation a2 ON a.id = a2.id WHERE e.is_visible IS TRUE AND (e.type = '1') GROUP BY e.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, 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, a2.id AS a2__id, a2.description AS a2__description, a2.biography AS a2__biography, a2.lang AS a2__lang 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 LEFT JOIN author_translation a2 ON a.id = a2.id WHERE e.id IN (SELECT doctrine_subquery_alias.id FROM (SELECT DISTINCT e4.id, e4.start_date FROM exhibition e4 LEFT JOIN exhibition_translation e5 ON e4.id = e5.id LEFT JOIN exhibition_author e6 ON (e4.id = e6.exhibition_id) LEFT JOIN author a3 ON a3.id = e6.author_id LEFT JOIN author_translation a4 ON a3.id = a4.id WHERE e4.is_visible IS TRUE AND (e4.type = '1') ORDER BY e4.start_date DESC LIMIT 10 OFFSET 10) AS doctrine_subquery_alias) AND (e.is_visible IS TRUE AND (e.type = '1')) ORDER BY e.start_date DESC
SELECT e.item_id AS e__item_id, e.exhibition_id AS e__exhibition_id, 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, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.filename AS i4__filename, i4.created_at AS i4__created_at, i4.updated_at AS i4__updated_at, i4.position AS i4__position, e2.id AS e2__id, e2.exhibition_base_id AS e2__exhibition_base_id, e2.item_id AS e2__item_id, e2.order_index AS e2__order_index FROM exhibition_item e LEFT JOIN item i ON e.item_id = i.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN author a ON i.author_id = a.id LEFT JOIN image i3 ON i.main_image_id = i3.id LEFT JOIN image i4 ON i.id = i4.item_id LEFT JOIN exhibition_order e2 ON i.id = e2.item_id WHERE e.item_id IN (SELECT doctrine_subquery_alias.item_id FROM (SELECT DISTINCT e3.item_id, e4.order_index FROM exhibition_item e3 LEFT JOIN item i5 ON e3.item_id = i5.id LEFT JOIN item_translation i6 ON i5.id = i6.id LEFT JOIN author a2 ON i5.author_id = a2.id LEFT JOIN image i7 ON i5.main_image_id = i7.id LEFT JOIN image i8 ON i5.id = i8.item_id LEFT JOIN exhibition_order e4 ON i5.id = e4.item_id WHERE (e3.exhibition_id = 54 AND e4.exhibition_base_id = 54) AND i5.is_active IS TRUE ORDER BY e4.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND ((e.exhibition_id = 54 AND e2.exhibition_base_id = 54) AND i.is_active IS TRUE) ORDER BY e2.order_index ASC
SELECT e.item_id AS e__item_id, e.exhibition_id AS e__exhibition_id, 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, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.filename AS i4__filename, i4.created_at AS i4__created_at, i4.updated_at AS i4__updated_at, i4.position AS i4__position, e2.id AS e2__id, e2.exhibition_base_id AS e2__exhibition_base_id, e2.item_id AS e2__item_id, e2.order_index AS e2__order_index FROM exhibition_item e LEFT JOIN item i ON e.item_id = i.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN author a ON i.author_id = a.id LEFT JOIN image i3 ON i.main_image_id = i3.id LEFT JOIN image i4 ON i.id = i4.item_id LEFT JOIN exhibition_order e2 ON i.id = e2.item_id WHERE e.item_id IN (SELECT doctrine_subquery_alias.item_id FROM (SELECT DISTINCT e3.item_id, e4.order_index FROM exhibition_item e3 LEFT JOIN item i5 ON e3.item_id = i5.id LEFT JOIN item_translation i6 ON i5.id = i6.id LEFT JOIN author a2 ON i5.author_id = a2.id LEFT JOIN image i7 ON i5.main_image_id = i7.id LEFT JOIN image i8 ON i5.id = i8.item_id LEFT JOIN exhibition_order e4 ON i5.id = e4.item_id WHERE (e3.exhibition_id = 16 AND e4.exhibition_base_id = 16) AND i5.is_active IS TRUE ORDER BY e4.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND ((e.exhibition_id = 16 AND e2.exhibition_base_id = 16) AND i.is_active IS TRUE) ORDER BY e2.order_index ASC
SELECT e.item_id AS e__item_id, e.exhibition_id AS e__exhibition_id, 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, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.filename AS i4__filename, i4.created_at AS i4__created_at, i4.updated_at AS i4__updated_at, i4.position AS i4__position, e2.id AS e2__id, e2.exhibition_base_id AS e2__exhibition_base_id, e2.item_id AS e2__item_id, e2.order_index AS e2__order_index FROM exhibition_item e LEFT JOIN item i ON e.item_id = i.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN author a ON i.author_id = a.id LEFT JOIN image i3 ON i.main_image_id = i3.id LEFT JOIN image i4 ON i.id = i4.item_id LEFT JOIN exhibition_order e2 ON i.id = e2.item_id WHERE e.item_id IN (SELECT doctrine_subquery_alias.item_id FROM (SELECT DISTINCT e3.item_id, e4.order_index FROM exhibition_item e3 LEFT JOIN item i5 ON e3.item_id = i5.id LEFT JOIN item_translation i6 ON i5.id = i6.id LEFT JOIN author a2 ON i5.author_id = a2.id LEFT JOIN image i7 ON i5.main_image_id = i7.id LEFT JOIN image i8 ON i5.id = i8.item_id LEFT JOIN exhibition_order e4 ON i5.id = e4.item_id WHERE (e3.exhibition_id = 23 AND e4.exhibition_base_id = 23) AND i5.is_active IS TRUE ORDER BY e4.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND ((e.exhibition_id = 23 AND e2.exhibition_base_id = 23) AND i.is_active IS TRUE) ORDER BY e2.order_index ASC
SELECT e.item_id AS e__item_id, e.exhibition_id AS e__exhibition_id, 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, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.filename AS i4__filename, i4.created_at AS i4__created_at, i4.updated_at AS i4__updated_at, i4.position AS i4__position, e2.id AS e2__id, e2.exhibition_base_id AS e2__exhibition_base_id, e2.item_id AS e2__item_id, e2.order_index AS e2__order_index FROM exhibition_item e LEFT JOIN item i ON e.item_id = i.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN author a ON i.author_id = a.id LEFT JOIN image i3 ON i.main_image_id = i3.id LEFT JOIN image i4 ON i.id = i4.item_id LEFT JOIN exhibition_order e2 ON i.id = e2.item_id WHERE e.item_id IN (SELECT doctrine_subquery_alias.item_id FROM (SELECT DISTINCT e3.item_id, e4.order_index FROM exhibition_item e3 LEFT JOIN item i5 ON e3.item_id = i5.id LEFT JOIN item_translation i6 ON i5.id = i6.id LEFT JOIN author a2 ON i5.author_id = a2.id LEFT JOIN image i7 ON i5.main_image_id = i7.id LEFT JOIN image i8 ON i5.id = i8.item_id LEFT JOIN exhibition_order e4 ON i5.id = e4.item_id WHERE (e3.exhibition_id = 17 AND e4.exhibition_base_id = 17) AND i5.is_active IS TRUE ORDER BY e4.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND ((e.exhibition_id = 17 AND e2.exhibition_base_id = 17) AND i.is_active IS TRUE) ORDER BY e2.order_index ASC
SELECT e.item_id AS e__item_id, e.exhibition_id AS e__exhibition_id, 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, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.filename AS i4__filename, i4.created_at AS i4__created_at, i4.updated_at AS i4__updated_at, i4.position AS i4__position, e2.id AS e2__id, e2.exhibition_base_id AS e2__exhibition_base_id, e2.item_id AS e2__item_id, e2.order_index AS e2__order_index FROM exhibition_item e LEFT JOIN item i ON e.item_id = i.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN author a ON i.author_id = a.id LEFT JOIN image i3 ON i.main_image_id = i3.id LEFT JOIN image i4 ON i.id = i4.item_id LEFT JOIN exhibition_order e2 ON i.id = e2.item_id WHERE e.item_id IN (SELECT doctrine_subquery_alias.item_id FROM (SELECT DISTINCT e3.item_id, e4.order_index FROM exhibition_item e3 LEFT JOIN item i5 ON e3.item_id = i5.id LEFT JOIN item_translation i6 ON i5.id = i6.id LEFT JOIN author a2 ON i5.author_id = a2.id LEFT JOIN image i7 ON i5.main_image_id = i7.id LEFT JOIN image i8 ON i5.id = i8.item_id LEFT JOIN exhibition_order e4 ON i5.id = e4.item_id WHERE (e3.exhibition_id = 21 AND e4.exhibition_base_id = 21) AND i5.is_active IS TRUE ORDER BY e4.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND ((e.exhibition_id = 21 AND e2.exhibition_base_id = 21) AND i.is_active IS TRUE) ORDER BY e2.order_index ASC
SELECT e.item_id AS e__item_id, e.exhibition_id AS e__exhibition_id, 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, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.filename AS i4__filename, i4.created_at AS i4__created_at, i4.updated_at AS i4__updated_at, i4.position AS i4__position, e2.id AS e2__id, e2.exhibition_base_id AS e2__exhibition_base_id, e2.item_id AS e2__item_id, e2.order_index AS e2__order_index FROM exhibition_item e LEFT JOIN item i ON e.item_id = i.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN author a ON i.author_id = a.id LEFT JOIN image i3 ON i.main_image_id = i3.id LEFT JOIN image i4 ON i.id = i4.item_id LEFT JOIN exhibition_order e2 ON i.id = e2.item_id WHERE e.item_id IN (SELECT doctrine_subquery_alias.item_id FROM (SELECT DISTINCT e3.item_id, e4.order_index FROM exhibition_item e3 LEFT JOIN item i5 ON e3.item_id = i5.id LEFT JOIN item_translation i6 ON i5.id = i6.id LEFT JOIN author a2 ON i5.author_id = a2.id LEFT JOIN image i7 ON i5.main_image_id = i7.id LEFT JOIN image i8 ON i5.id = i8.item_id LEFT JOIN exhibition_order e4 ON i5.id = e4.item_id WHERE (e3.exhibition_id = 33 AND e4.exhibition_base_id = 33) AND i5.is_active IS TRUE ORDER BY e4.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND ((e.exhibition_id = 33 AND e2.exhibition_base_id = 33) AND i.is_active IS TRUE) ORDER BY e2.order_index ASC
SELECT e.item_id AS e__item_id, e.exhibition_id AS e__exhibition_id, 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, i3.id AS i3__id, i3.item_id AS i3__item_id, i3.filename AS i3__filename, i3.created_at AS i3__created_at, i3.updated_at AS i3__updated_at, i3.position AS i3__position, i4.id AS i4__id, i4.item_id AS i4__item_id, i4.filename AS i4__filename, i4.created_at AS i4__created_at, i4.updated_at AS i4__updated_at, i4.position AS i4__position, e2.id AS e2__id, e2.exhibition_base_id AS e2__exhibition_base_id, e2.item_id AS e2__item_id, e2.order_index AS e2__order_index FROM exhibition_item e LEFT JOIN item i ON e.item_id = i.id LEFT JOIN item_translation i2 ON i.id = i2.id LEFT JOIN author a ON i.author_id = a.id LEFT JOIN image i3 ON i.main_image_id = i3.id LEFT JOIN image i4 ON i.id = i4.item_id LEFT JOIN exhibition_order e2 ON i.id = e2.item_id WHERE e.item_id IN (SELECT doctrine_subquery_alias.item_id FROM (SELECT DISTINCT e3.item_id, e4.order_index FROM exhibition_item e3 LEFT JOIN item i5 ON e3.item_id = i5.id LEFT JOIN item_translation i6 ON i5.id = i6.id LEFT JOIN author a2 ON i5.author_id = a2.id LEFT JOIN image i7 ON i5.main_image_id = i7.id LEFT JOIN image i8 ON i5.id = i8.item_id LEFT JOIN exhibition_order e4 ON i5.id = e4.item_id WHERE (e3.exhibition_id = 20 AND e4.exhibition_base_id = 20) AND i5.is_active IS TRUE ORDER BY e4.order_index ASC LIMIT 4) AS doctrine_subquery_alias) AND ((e.exhibition_id = 20 AND e2.exhibition_base_id = 20) AND i.is_active IS TRUE) ORDER BY e2.order_index ASC