options:
  path_info_key: PATH_INFO
  path_info_array: SERVER
  http_port: null
  https_port: null
  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: all
  module: product
  sale: '9797'
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:
  'https://d3bsbe39k8p2a0.cloudfront.net//js/jquery.validate.min.js': {  }
  /js/bootstrap.min.js: {  }
  /js/new/jquery-ui.min.js: {  }
  /js/new/anime.min.js: {  }
  /js/sweetalert2.min.js: {  }
  /js/new/camelize.js: {  }
  jquery.unveil.js: {  }
stylesheets:
  'https://d3bsbe39k8p2a0.cloudfront.net/css/new/bootstrap.css': {  }
  /css/font-awesome-5.0.min.css: {  }
  'https://d3bsbe39k8p2a0.cloudfront.net/css/new/jquery-ui.min.css': {  }
  'https://d3bsbe39k8p2a0.cloudfront.net/css/new/jquery-ui.structure.min.css': {  }
  'https://d3bsbe39k8p2a0.cloudfront.net/css/new/owl-carousel/owl.carousel.min.css': {  }
  'https://d3bsbe39k8p2a0.cloudfront.net/css/new/owl-carousel/owl.theme.default.min.css': {  }
  'https://d3bsbe39k8p2a0.cloudfront.net/css/sweetalert2.min.css': {  }
  'https://d3bsbe39k8p2a0.cloudfront.net/css/new/main.css?v=1745902854': {  }
metas:
  title: 'Ecran  (1 biens au total) - Clicpublic.be, les ventes publiques en 1 clic.'
  viewport: 'width=device-width, initial-scale=1.0'
httpMetas:
  Content-Type: 'text/html; charset=utf-8'

options:
  auto_shutdown: false
  culture: null
  default_culture: fr
  use_flash: true
  logging: '1'
  timeout: 1800
attributeHolder:
  symfony/user/sfUser/attributes: { limit: 50, user_country: be }
culture: fr
authenticated: null
credentials: {  }
lastRequest: 1745934234

app_default_backofficemail: backoffice@clicpublic.be
app_default_backofficemail_lu: backoffice@clicpublic.lu
app_default_cdn: d3bsbe39k8p2a0.cloudfront.net
app_default_fb_access_token: EAAF2BkO6VkcBO0ZBlh6IwcGQclyNspVsKtFPmhUubjmDrzxakl86lnOd1TBOkqZBi7bxUmjLIcQ2KGIqZB9RAhSsf9rZCdMozitvcozlNXkdg9aKZArBGPZBPWoZC2ssxaOJkhT6Mu4hHlFGz5a4yQkJSZAl35VZA6c1IIk5Mc2mvbehDLDJu81Hp86YN2TCEd1GINwZDZD
app_default_fb_api_version: v17.0
app_default_fb_pixel_id: 197794934140740
app_default_gavel_orange_bid: 10
app_default_gavel_red_bid: 20
app_default_hotdeals: 10
app_default_mail: info@clicpublic.be
app_default_mail_be: info@clicpublic.be
app_default_mail_from: clicpublic
app_default_mail_lu: info@clicpublic.lu
app_default_no-reply: no-reply@clicpublic.be
app_default_no-reply_lu: no-reply@clicpublic.lu
app_default_ovh_api_application_key: I5x89YKoW0amEYi2
app_default_ovh_api_application_secret: 9ZLUd2i4TruJ4PN1Or2hQDhB5YXZNUMJ
app_default_ovh_api_consumer_key: 3pQkRb3Rkz3F49E6h6DfRm1GVH1WmvSN
app_default_product_per_page: 9
app_default_recaptcha_public: 6LeJeUkaAAAAABWwmzI9n0WBPxfM-uFFaRQ9iiza
app_default_recaptcha_secret: 6LeJeUkaAAAAAHdPZrDLJkOfG6dm-dcZwqegiyLa
app_default_sale_validation: info@clicpublic.be
app_default_sale_validation_lu: info@clicpublic.lu
app_default_salt: 'X+D_dq0z_B3= Mk-I|YW9 8acWO|Sg9WE=sc=GqCDxV+5krjhQ_ndqBq5uKC'
app_default_show_product: 50
app_default_voicepartner_apikey: bi0Y3uNU-abr7qZ3-3J3oMEfB3P-SiUmojC0L
app_local_de: de_DE
app_local_en: en_GB
app_local_fr: fr_FR
app_local_nl: nl_NL
app_mail_admin_dev: it@clicpublic.be
app_ohMailChimp_api_key: YourApiKeyHere
app_ohMailChimp_class_name: ohMailChimpApi
app_ohMailChimp_list_id: YourListIdHere
app_ohMailChimp_logging: true
app_ohMailChimp_throw_exception: true
app_sfImageTransformPlugin_default_adapter: GD
app_sfImageTransformPlugin_default_image:
  mime_type: image/png
  filename: Untitled.png
  width: 100
  height: 100
  color: '#FFFFFF'
app_sfImageTransformPlugin_font_dir: /usr/share/fonts/truetype/msttcorefonts
app_sfImageTransformPlugin_mime_type:
  auto_detect: true
  library: gd_mime_type
app_sf_media_browser_assets_list:
  js: null
  css: [/sfMediaBrowserPlugin/css/list.css]
app_sf_media_browser_assets_widget:
  js: [/sfMediaBrowserPlugin/js/WindowManager.js, /sfMediaBrowserPlugin/js/form_widget.js]
  css: [/sfMediaBrowserPlugin/css/form_widget.css]
app_sf_media_browser_file_types:
  document: { extensions: [doc, xls, xcf, ai], icon: doc }
  image: { extensions: [png, jpg, jpeg, gif] }
  pdf: { extensions: [pdf] }
  bin: { extensions: [bin, exe, sh, bat, deb, yum] }
  video: { extensions: [wmv, avi, mpg, mpeg, flv, mp4] }
  audio: { extensions: [ogg, mp3, flac, wma, cda] }
  text: { extensions: [txt] }
  tarball: { extensions: [tar, gz, zip, bzip, gzip, rar, 7z] }
app_sf_media_browser_root_dir: /uploads
app_sf_media_browser_thumbnails_dir: .thumbnails
app_sf_media_browser_thumbnails_enabled: true
app_sf_media_browser_thumbnails_max_height: 64
app_sf_media_browser_thumbnails_max_width: 64
app_show_product: 20
app_site_be_de: 'https://de.clicpublic.be/'
app_site_be_en: 'https://en.clicpublic.be/'
app_site_be_fr: 'https://www.clicpublic.be/'
app_site_be_nl: 'https://nl.clicpublic.be/'
app_site_de: 'https://de.clicpublic.be/'
app_site_en: 'https://en.clicpublic.be/'
app_site_fr: 'https://www.clicpublic.be/'
app_site_lu_de: 'https://www.clicpublic.lu/'
app_site_lu_en: 'https://en.clicpublic.lu/'
app_site_lu_fr: 'https://fr.clicpublic.lu/'
app_site_lu_nl: 'https://nl.clicpublic.lu/'
app_site_nl: 'https://nl.clicpublic.be/'
app_ssl_modules:
  - { module: account }
  - { module: product }
  - { module: payment }
  - { module: sale, action: show }
app_ssl_strict: true
app_wordline_environnement: SIMU
app_wordline_keyVersion: 1
app_wordline_merchantId: '002001000000001'
app_wordline_secretKey: 002001000000001_KEY1
mod_default_enabled: true
mod_default_view_class: sfPHP
mod_product_enabled: true
mod_product_view_class: sfPHP
mod_sale_enabled: true
mod_sale_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/clicpublic/cache/frontend
sf_app_cache_dir: /home/clicpublic/cache/frontend/dev
sf_app_config_dir: /home/clicpublic/apps/frontend/config
sf_app_dir: /home/clicpublic/apps/frontend
sf_app_i18n_dir: /home/clicpublic/apps/frontend/i18n
sf_app_lib_dir: /home/clicpublic/apps/frontend/lib
sf_app_module_dir: /home/clicpublic/apps/frontend/modules
sf_app_template_dir: /home/clicpublic/apps/frontend/templates
sf_apps_dir: /home/clicpublic/apps
sf_cache: false
sf_cache_dir: /home/clicpublic/cache
sf_charset: utf-8
sf_check_lock: false
sf_compressed: false
sf_config_cache_dir: /home/clicpublic/cache/frontend/dev/config
sf_config_dir: /home/clicpublic/config
sf_csrf_secret: ac214e61c35826766d178ea7dee31b5a8ad62336
sf_data_dir: /home/clicpublic/data
sf_debug: true
sf_default_culture: fr
sf_default_language: fr
sf_enabled_modules:
  - default
  - frontend_page
sf_environment: dev
sf_error_404_action: error404
sf_error_404_module: frontend_page
sf_error_reporting: 24567
sf_escaping_method: ESC_SPECIALCHARS
sf_escaping_strategy: true
sf_etag: false
sf_file_link_format: null
sf_i18n: true
sf_i18n_cache_dir: /home/clicpublic/cache/frontend/dev/i18n
sf_jquery_autocomplete: jquery.autocomplete.min.js
sf_jquery_core: jquery-1.4.2.min.js
sf_jquery_path: null
sf_jquery_plugin_paths: null
sf_jquery_ui: jquery-ui-1.7.3.custom.min.js
sf_jquery_web_dir: /sfJqueryReloadedPlugin
sf_lib_dir: /home/clicpublic/lib
sf_log_dir: /home/clicpublic/log
sf_logging_enabled: true
sf_login_action: login
sf_login_module: default
sf_module_cache_dir: /home/clicpublic/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/clicpublic/plugins
sf_root_dir: /home/clicpublic
sf_secure_action: secure
sf_secure_module: default
sf_standard_helpers:
  - Partial
  - Cache
  - I18N
  - Date
  - Url
  - My
sf_symfony_lib_dir: /home/clicpublic/lib/vendor/symfony/lib
sf_template_cache_dir: /home/clicpublic/cache/frontend/dev/template
sf_test_cache_dir: /home/clicpublic/cache/frontend/dev/test
sf_test_dir: /home/clicpublic/test
sf_upload_dir: /home/clicpublic/web/uploads
sf_use_database: true
sf_web_debug: true
sf_web_debug_web_dir: /sf/sf_web_debug
sf_web_dir: /home/clicpublic/web
solr_fields_types:
  clob: text
  integer: int
symfony.asset.javascripts_included: true
symfony.asset.stylesheets_included: true

cookie:
  symfony: c28o0r8be7slp04f3c7j7441ui
env: {  }
files: {  }
get:
  sale: '9797'
post: {  }
server:
  CONTEXT_DOCUMENT_ROOT: /home/clicpublic/web
  CONTEXT_PREFIX: ''
  DOCUMENT_ROOT: /home/clicpublic/web
  FCGI_ROLE: RESPONDER
  GATEWAY_INTERFACE: CGI/1.1
  HOME: /var/www
  HTTPS: on
  HTTP_ACCEPT: '*/*'
  HTTP_ACCEPT_ENCODING: 'gzip, br, zstd, deflate'
  HTTP_COOKIE: symfony=c28o0r8be7slp04f3c7j7441ui
  HTTP_HOST: dev.clicpublic.be
  HTTP_USER_AGENT: 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'
  PATH: '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin'
  PATH_INFO: /category
  PATH_TRANSLATED: 'redirect:/index.php'
  PHP_SELF: /igw_dev.php/category
  QUERY_STRING: sale=9797
  REMOTE_ADDR: 18.221.227.158
  REMOTE_PORT: '59621'
  REQUEST_METHOD: GET
  REQUEST_SCHEME: https
  REQUEST_TIME: 1745934234
  REQUEST_TIME_FLOAT: 1745934234.2972
  REQUEST_URI: '/igw_dev.php/category?sale=9797'
  SCRIPT_FILENAME: /home/clicpublic/web/igw_dev.php
  SCRIPT_NAME: /igw_dev.php
  SERVER_ADDR: 51.68.227.109
  SERVER_ADMIN: '[no address given]'
  SERVER_NAME: dev.clicpublic.be
  SERVER_PORT: '443'
  SERVER_PROTOCOL: HTTP/1.1
  SERVER_SIGNATURE: "<address>Apache/2.4.63 (Ubuntu) Server at dev.clicpublic.be Port 443</address>\n"
  SERVER_SOFTWARE: 'Apache/2.4.63 (Ubuntu)'
  SSL_TLS_SNI: dev.clicpublic.be
  USER: www-data
  proxy-nokeepalive: '1'
session:
  symfony/user/sfUser/attributes: { symfony/user/sfUser/attributes: { user_country: be } }
  symfony/user/sfUser/authenticated: false
  symfony/user/sfUser/credentials: {  }
  symfony/user/sfUser/culture: fr
  symfony/user/sfUser/lastRequest: 1745934232

php: 7.4.33
os: 'Linux vps645206 5.4.0-208-generic #228-Ubuntu SMP Fri Feb 7 19:41:33 UTC 2025 x86_64'
extensions:
  17: 'bz2 (7.4.33)'
  18: 'calendar (7.4.33)'
  13: 'cgi-fcgi (7.4.33)'
  0: 'Core (7.4.33)'
  19: 'ctype (7.4.33)'
  20: 'curl (7.4.33)'
  1: 'date (7.4.33)'
  21: 'dom (20031129)'
  33: 'exif (7.4.33)'
  23: 'FFI (7.4.33)'
  24: 'fileinfo (7.4.33)'
  6: 'filter (7.4.33)'
  25: 'ftp (7.4.33)'
  26: 'gd (7.4.33)'
  27: 'gettext (7.4.33)'
  7: 'hash (7.4.33)'
  28: 'iconv (7.4.33)'
  29: 'imagick (3.8.0)'
  30: 'imap (7.4.33)'
  31: 'intl (7.4.33)'
  32: 'json (7.4.33)'
  2: 'libxml (7.4.33)'
  22: 'mbstring (7.4.33)'
  34: 'mysqli (7.4.33)'
  14: 'mysqlnd (mysqlnd 7.4.33)'
  3: 'openssl (7.4.33)'
  4: 'pcre (7.4.33)'
  15: 'PDO (7.4.33)'
  35: 'pdo_mysql (7.4.33)'
  36: 'Phar (7.4.33)'
  37: 'posix (7.4.33)'
  38: 'readline (7.4.33)'
  8: 'Reflection (7.4.33)'
  10: 'session (7.4.33)'
  39: 'shmop (7.4.33)'
  40: 'SimpleXML (7.4.33)'
  41: 'soap (7.4.33)'
  42: 'sockets (7.4.33)'
  12: 'sodium (7.4.33)'
  9: 'SPL (7.4.33)'
  11: 'standard (7.4.33)'
  43: 'sysvmsg (7.4.33)'
  44: 'sysvsem (7.4.33)'
  45: 'sysvshm (7.4.33)'
  46: 'tokenizer (7.4.33)'
  16: 'xml (7.4.33)'
  47: 'xmlreader (7.4.33)'
  48: 'xmlrpc (7.4.33)'
  49: 'xmlwriter (7.4.33)'
  50: 'xsl (7.4.33)'
  52: 'Zend OPcache (7.4.33)'
  51: 'zip (1.15.6)'
  5: 'zlib (7.4.33)'

version: 1.4.17
path: /home/clicpublic/lib/vendor/symfony/lib

Parameters:

• $default_title (string)
• $sale_id (string)
• $category_id (NULL)
• $baseForm (BaseForm)
  • $baseForm['_csrf_token'] (sfWidgetFormInputHidden)
• $display (integer)
• $tri (string)
• $limit (integer)
• $pager (sfDoctrinePager)
• $title (string)

Parameters:

• $activities (array)

Parameters:

• $sale_id (string)
• $nb_products (string)
• $sale (sale)
• $consultations (string)
• $auctions (string)

Parameters:

• $country_id (string)

No parameters were passed to this template.

Parameters:

• $sale (sale)

Parameters:

• $tri (string)
• $sort_key (string)
• $text (string)
• $fa (string)

Parameters:

• $tri (string)
• $sort_key (string)
• $text (string)
• $fa (string)

Parameters:

• $tri (string)
• $sort_key (string)
• $text (string)
• $fa (string)

Parameters:

• $tri (string)
• $sort_key (string)
• $text (string)
• $fa (string)

Parameters:

• $pager (sfDoctrinePager)
• $display (string)
• $category_id (NULL)
• $sale_id (string)
• $tri (string)
• $baseForm (BaseForm)
  • $baseForm['_csrf_token'] (sfWidgetFormInputHidden)

Parameters:

• $product (product)
• $baseForm (BaseForm)
  • $baseForm['_csrf_token'] (sfWidgetFormInputHidden)

Parameters:

• $product (product)
• $baseForm (BaseForm)
  • $baseForm['_csrf_token'] (sfWidgetFormInputHidden)

Parameters:

• $product (product)
• $last_bid (bid)
• $last_bid_member (boolean)

Parameters:

• $product (product)
• $baseForm (BaseForm)
  • $baseForm['_csrf_token'] (sfWidgetFormInputHidden)

No parameters were passed to this template.

No parameters were passed to this template.

No parameters were passed to this template.

Parameters:

• $form (NewSearchForm)
  • $form['search'] (sfWidgetFormInputText)
  • $form['_csrf_token'] (sfWidgetFormInputHidden)

No parameters were passed to this template.

No parameters were passed to this template.

Parameters:

• $baseForm (BaseForm)
  • $baseForm['_csrf_token'] (sfWidgetFormInputHidden)

No parameters were passed to this template.

Parameters:

• $products (Doctrine_Collection)
• $baseForm (BaseForm)
  • $baseForm['_csrf_token'] (sfWidgetFormInputHidden)

Parameters:

• $product (product)
• $baseForm (BaseForm)
  • $baseForm['_csrf_token'] (sfWidgetFormInputHidden)

Parameters:

• $product (product)
• $baseForm (BaseForm)
  • $baseForm['_csrf_token'] (sfWidgetFormInputHidden)

Parameters:

• $product (product)
• $baseForm (BaseForm)
  • $baseForm['_csrf_token'] (sfWidgetFormInputHidden)

Parameters:

• $product (product)
• $baseForm (BaseForm)
  • $baseForm['_csrf_token'] (sfWidgetFormInputHidden)

Parameters:

• $product (product)
• $baseForm (BaseForm)
  • $baseForm['_csrf_token'] (sfWidgetFormInputHidden)

Parameters:

• $product (product)
• $baseForm (BaseForm)
  • $baseForm['_csrf_token'] (sfWidgetFormInputHidden)

Parameters:

• $product (product)
• $baseForm (BaseForm)
  • $baseForm['_csrf_token'] (sfWidgetFormInputHidden)

Parameters:

• $product (product)
• $baseForm (BaseForm)
  • $baseForm['_csrf_token'] (sfWidgetFormInputHidden)

No parameters were passed to this template.

No parameters were passed to this template.

Doctrine Version: 1.2.4

1. SET NAMES 'UTF8'

   0.00s, "doctrine" connection

2. SELECT COUNT(*) AS num_results FROM (SELECT p.id FROM product p LEFT JOIN product_translation p2 ON p.id = p2.id AND (p2.lang = 'fr') LEFT JOIN category c ON p.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id AND (c2.lang = 'fr') LEFT JOIN product_type p3 ON p.product_type_id = p3.id LEFT JOIN product_type_translation p4 ON p3.id = p4.id AND (p4.lang = 'fr') INNER JOIN sale s ON p.sale_id = s.id LEFT JOIN bid b ON p.id = b.product_id WHERE p.sale_id = '9797' AND p.enabled = 1 AND p.htva_price > 0 AND p.end_at > NOW() AND s.enabled = 1 AND s.end_at > NOW() AND ((p.isinstantsell = 1 AND p.stock_quantity_initial > p.stock_quantity_sold) OR (p.isinstantsell = 0 OR p.isinstantsell IS NULL)) GROUP BY p.id) dctrn_count_query

   0.01s, "doctrine" connection

3. SELECT s.id AS s__id, s.ref AS s__ref, s.sale_mother_id AS s__sale_mother_id, s.image AS s__image, s.banner AS s__banner, s.banner_new AS s__banner_new, s.judge_id AS s__judge_id, s.curator_id AS s__curator_id, s.associate_member_id AS s__associate_member_id, s.sale_type_id AS s__sale_type_id, s.last_invoice_id AS s__last_invoice_id, s.commercial_court AS s__commercial_court, s.begin_at AS s__begin_at, s.first_end_at AS s__first_end_at, s.end_at AS s__end_at, s.company_name AS s__company_name, s.address1 AS s__address1, s.address2 AS s__address2, s.post_code AS s__post_code, s.city AS s__city, s.social_reason AS s__social_reason, s.company_social_reason_id AS s__company_social_reason_id, s.matricule AS s__matricule, s.vat_number AS s__vat_number, s.country_id AS s__country_id, s.owner_description AS s__owner_description, s.activity_domain AS s__activity_domain, s.mission_description AS s__mission_description, s.enabled AS s__enabled, s.category_id AS s__category_id, s.mission_end AS s__mission_end, s.inventory_at AS s__inventory_at, s.validated_contract_at AS s__validated_contract_at, s.implementated_at AS s__implementated_at, s.sfguarduser_id AS s__sfguarduser_id, s.stock_id AS s__stock_id, s.tva AS s__tva, s.vat_rate_id AS s__vat_rate_id, s.commission AS s__commission, s.tva_commission AS s__tva_commission, s.vat_rate_commission_id AS s__vat_rate_commission_id, s.vendor_commission AS s__vendor_commission, s.account_to_receive AS s__account_to_receive, s.account_received AS s__account_received, s.vat_only AS s__vat_only, s.visit_pad AS s__visit_pad, s.visited_at AS s__visited_at, s.visit_closed AS s__visit_closed, s.visited_at_day AS s__visited_at_day, s.delivery_at AS s__delivery_at, s.delivery_at_day AS s__delivery_at_day, s.delivery_planned AS s__delivery_planned, s.delivery_temporary_planification AS s__delivery_temporary_planification, s.external_invoice AS s__external_invoice, s.type_external_invoice AS s__type_external_invoice, s.type_commission AS s__type_commission, s.sell_mode AS s__sell_mode, s.last_invoice_number AS s__last_invoice_number, s.invoice_prefix AS s__invoice_prefix, s.last_credit_note AS s__last_credit_note, s.last_proforma AS s__last_proforma, s.bank_nummer AS s__bank_nummer, s.bic_number AS s__bic_number, s.account AS s__account, s.bank_nummer2 AS s__bank_nummer2, s.bic_number2 AS s__bic_number2, s.account2 AS s__account2, s.bank_nummer3 AS s__bank_nummer3, s.bic_number3 AS s__bic_number3, s.account3 AS s__account3, s.ogone_enabled AS s__ogone_enabled, s.choice_stock AS s__choice_stock, s.view_counter AS s__view_counter, s.cpt AS s__cpt, s.cpt_nc AS s__cpt_nc, s.cpt_pf AS s__cpt_pf, s.info_additional_invoice AS s__info_additional_invoice, s.fund_to_be_transferred AS s__fund_to_be_transferred, s.fund_to_be_transferred_bank AS s__fund_to_be_transferred_bank, s.fund_transferred AS s__fund_transferred, s.is_stock_in_trade AS s__is_stock_in_trade, s.is_stock_in_trade_url AS s__is_stock_in_trade_url, s.sale_status_id AS s__sale_status_id, s.position AS s__position, s.limit_at AS s__limit_at, s.locked_by AS s__locked_by, s.locked_until AS s__locked_until, s.global AS s__global, s.global_only AS s__global_only, s.manager_id AS s__manager_id, s.leader_id AS s__leader_id, s.could_be_closed AS s__could_be_closed, s.soon_available AS s__soon_available, s.key_status_id AS s__key_status_id, s.key_position AS s__key_position, s.sepa_communication_type AS s__sepa_communication_type, s.created_at AS s__created_at, s.updated_at AS s__updated_at FROM sale s WHERE (s.id = '9797') LIMIT 1

   0.00s, "doctrine" connection

4. SELECT s.id AS s__id, s.public_title AS s__public_title, s.public_subtitle AS s__public_subtitle, s.public_description AS s__public_description, s.description_for_product AS s__description_for_product, s.specific_condition_pdf AS s__specific_condition_pdf, s.lang AS s__lang FROM sale_translation s WHERE (s.id IN ('9797'))

   0.00s, "doctrine" connection

5. SELECT p.id AS p__id, p.template_id AS p__template_id, p.code AS p__code, p.position AS p__position, p.in_sitemap AS p__in_sitemap, p.enabled AS p__enabled, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p2.id AS p2__id, p2.meta_title AS p2__meta_title, p2.meta_keyword AS p2__meta_keyword, p2.meta_description AS p2__meta_description, p2.lang AS p2__lang, p2.slug AS p2__slug FROM page p LEFT JOIN page_translation p2 ON p.id = p2.id WHERE (p.code = 'TELEVIE')

   0.00s, "doctrine" connection

6. SELECT s.id AS s__id, s.ref AS s__ref, s.sale_mother_id AS s__sale_mother_id, s.image AS s__image, s.banner AS s__banner, s.banner_new AS s__banner_new, s.judge_id AS s__judge_id, s.curator_id AS s__curator_id, s.associate_member_id AS s__associate_member_id, s.sale_type_id AS s__sale_type_id, s.last_invoice_id AS s__last_invoice_id, s.commercial_court AS s__commercial_court, s.begin_at AS s__begin_at, s.first_end_at AS s__first_end_at, s.end_at AS s__end_at, s.company_name AS s__company_name, s.address1 AS s__address1, s.address2 AS s__address2, s.post_code AS s__post_code, s.city AS s__city, s.social_reason AS s__social_reason, s.company_social_reason_id AS s__company_social_reason_id, s.matricule AS s__matricule, s.vat_number AS s__vat_number, s.country_id AS s__country_id, s.owner_description AS s__owner_description, s.activity_domain AS s__activity_domain, s.mission_description AS s__mission_description, s.enabled AS s__enabled, s.category_id AS s__category_id, s.mission_end AS s__mission_end, s.inventory_at AS s__inventory_at, s.validated_contract_at AS s__validated_contract_at, s.implementated_at AS s__implementated_at, s.sfguarduser_id AS s__sfguarduser_id, s.stock_id AS s__stock_id, s.tva AS s__tva, s.vat_rate_id AS s__vat_rate_id, s.commission AS s__commission, s.tva_commission AS s__tva_commission, s.vat_rate_commission_id AS s__vat_rate_commission_id, s.vendor_commission AS s__vendor_commission, s.account_to_receive AS s__account_to_receive, s.account_received AS s__account_received, s.vat_only AS s__vat_only, s.visit_pad AS s__visit_pad, s.visited_at AS s__visited_at, s.visit_closed AS s__visit_closed, s.visited_at_day AS s__visited_at_day, s.delivery_at AS s__delivery_at, s.delivery_at_day AS s__delivery_at_day, s.delivery_planned AS s__delivery_planned, s.delivery_temporary_planification AS s__delivery_temporary_planification, s.external_invoice AS s__external_invoice, s.type_external_invoice AS s__type_external_invoice, s.type_commission AS s__type_commission, s.sell_mode AS s__sell_mode, s.last_invoice_number AS s__last_invoice_number, s.invoice_prefix AS s__invoice_prefix, s.last_credit_note AS s__last_credit_note, s.last_proforma AS s__last_proforma, s.bank_nummer AS s__bank_nummer, s.bic_number AS s__bic_number, s.account AS s__account, s.bank_nummer2 AS s__bank_nummer2, s.bic_number2 AS s__bic_number2, s.account2 AS s__account2, s.bank_nummer3 AS s__bank_nummer3, s.bic_number3 AS s__bic_number3, s.account3 AS s__account3, s.ogone_enabled AS s__ogone_enabled, s.choice_stock AS s__choice_stock, s.view_counter AS s__view_counter, s.cpt AS s__cpt, s.cpt_nc AS s__cpt_nc, s.cpt_pf AS s__cpt_pf, s.info_additional_invoice AS s__info_additional_invoice, s.fund_to_be_transferred AS s__fund_to_be_transferred, s.fund_to_be_transferred_bank AS s__fund_to_be_transferred_bank, s.fund_transferred AS s__fund_transferred, s.is_stock_in_trade AS s__is_stock_in_trade, s.is_stock_in_trade_url AS s__is_stock_in_trade_url, s.sale_status_id AS s__sale_status_id, s.position AS s__position, s.limit_at AS s__limit_at, s.locked_by AS s__locked_by, s.locked_until AS s__locked_until, s.global AS s__global, s.global_only AS s__global_only, s.manager_id AS s__manager_id, s.leader_id AS s__leader_id, s.could_be_closed AS s__could_be_closed, s.soon_available AS s__soon_available, s.key_status_id AS s__key_status_id, s.key_position AS s__key_position, s.sepa_communication_type AS s__sepa_communication_type, s.created_at AS s__created_at, s.updated_at AS s__updated_at FROM sale s WHERE (s.id = '9797' AND s.enabled = 1 AND s.end_at >= NOW())

   0.00s, "doctrine" connection

7. SELECT SUM(p.counter_view) AS p__0 FROM product p WHERE (p.enabled = 1 AND p.sale_id = '9797')

   0.00s, "doctrine" connection

8. SELECT COUNT(b.id) AS b__0 FROM bid b INNER JOIN product p ON b.product_id = p.id WHERE (p.enabled = 1 AND p.sale_id = '9797')

   0.00s, "doctrine" connection

9. SELECT s.id AS s__id, s.code AS s__code, s.mandat_judiciaire AS s__mandat_judiciaire, s.create_associate_member AS s__create_associate_member, s.position AS s__position, s.enabled AS s__enabled, s.created_at AS s__created_at, s.updated_at AS s__updated_at FROM sale_type s WHERE (s.id = '1')

   0.00s, "doctrine" connection

10. SELECT s.id AS s__id, s.title AS s__title, s.description AS s__description, s.public_header AS s__public_header, s.lang AS s__lang, s.slug AS s__slug FROM sale_type_translation s WHERE (s.id IN ('1'))

    0.00s, "doctrine" connection

11. SELECT m.id AS m__id, m.facebook_id AS m__facebook_id, m.company_social_reason_id AS m__company_social_reason_id, m.ref AS m__ref, m.civility AS m__civility, m.last_name AS m__last_name, m.first_name AS m__first_name, m.birthdate AS m__birthdate, m.address1 AS m__address1, m.address2 AS m__address2, m.post_code AS m__post_code, m.post_box AS m__post_box, m.city AS m__city, m.country_id AS m__country_id, m.phone_number AS m__phone_number, m.gsm_number AS m__gsm_number, m.sms_code AS m__sms_code, m.verified_mobile AS m__verified_mobile, m.mail AS m__mail, m.mail_alternate AS m__mail_alternate, m.vacancy_mail AS m__vacancy_mail, m.password AS m__password, m.new_password AS m__new_password, m.token AS m__token, m.remember_key AS m__remember_key, m.identity_number AS m__identity_number, m.national_register AS m__national_register, m.company_name AS m__company_name, m.matricule AS m__matricule, m.vat_number AS m__vat_number, m.dft_culture AS m__dft_culture, m.dft_site AS m__dft_site, m.member_type_id AS m__member_type_id, m.last_connection_at AS m__last_connection_at, m.accept_cgv_at AS m__accept_cgv_at, m.is_newsletter AS m__is_newsletter, m.enabled AS m__enabled, m.bank_nummer AS m__bank_nummer, m.bic_number AS m__bic_number, m.can_create_file AS m__can_create_file, m.account AS m__account, m.bank_nummer2 AS m__bank_nummer2, m.account2 AS m__account2, m.bank_report AS m__bank_report, m.exact_hash AS m__exact_hash, m.vies_checked_at AS m__vies_checked_at, m.created_at AS m__created_at, m.updated_at AS m__updated_at FROM member m WHERE (m.id = '89109')

    0.00s, "doctrine" connection

12. SELECT COUNT(*) AS num_results FROM sale_visit s WHERE s.sale_id = 9797

    0.00s, "doctrine" connection

13. SELECT c.id AS c__id, c.number AS c__number, c.alpha3 AS c__alpha3, c.alpha2 AS c__alpha2, c.vat_mask AS c__vat_mask, c.enabled AS c__enabled, c.position AS c__position, c.created_at AS c__created_at, c.updated_at AS c__updated_at FROM country c WHERE (c.id = '20')

    0.00s, "doctrine" connection

14. SELECT c.id AS c__id, c.name AS c__name, c.lang AS c__lang FROM country_translation c WHERE (c.id IN ('20'))

    0.01s, "doctrine" connection

15. SELECT s.id AS s__id, s.ref AS s__ref, s.sale_mother_id AS s__sale_mother_id, s.image AS s__image, s.banner AS s__banner, s.banner_new AS s__banner_new, s.judge_id AS s__judge_id, s.curator_id AS s__curator_id, s.associate_member_id AS s__associate_member_id, s.sale_type_id AS s__sale_type_id, s.last_invoice_id AS s__last_invoice_id, s.commercial_court AS s__commercial_court, s.begin_at AS s__begin_at, s.first_end_at AS s__first_end_at, s.end_at AS s__end_at, s.company_name AS s__company_name, s.address1 AS s__address1, s.address2 AS s__address2, s.post_code AS s__post_code, s.city AS s__city, s.social_reason AS s__social_reason, s.company_social_reason_id AS s__company_social_reason_id, s.matricule AS s__matricule, s.vat_number AS s__vat_number, s.country_id AS s__country_id, s.owner_description AS s__owner_description, s.activity_domain AS s__activity_domain, s.mission_description AS s__mission_description, s.enabled AS s__enabled, s.category_id AS s__category_id, s.mission_end AS s__mission_end, s.inventory_at AS s__inventory_at, s.validated_contract_at AS s__validated_contract_at, s.implementated_at AS s__implementated_at, s.sfguarduser_id AS s__sfguarduser_id, s.stock_id AS s__stock_id, s.tva AS s__tva, s.vat_rate_id AS s__vat_rate_id, s.commission AS s__commission, s.tva_commission AS s__tva_commission, s.vat_rate_commission_id AS s__vat_rate_commission_id, s.vendor_commission AS s__vendor_commission, s.account_to_receive AS s__account_to_receive, s.account_received AS s__account_received, s.vat_only AS s__vat_only, s.visit_pad AS s__visit_pad, s.visited_at AS s__visited_at, s.visit_closed AS s__visit_closed, s.visited_at_day AS s__visited_at_day, s.delivery_at AS s__delivery_at, s.delivery_at_day AS s__delivery_at_day, s.delivery_planned AS s__delivery_planned, s.delivery_temporary_planification AS s__delivery_temporary_planification, s.external_invoice AS s__external_invoice, s.type_external_invoice AS s__type_external_invoice, s.type_commission AS s__type_commission, s.sell_mode AS s__sell_mode, s.last_invoice_number AS s__last_invoice_number, s.invoice_prefix AS s__invoice_prefix, s.last_credit_note AS s__last_credit_note, s.last_proforma AS s__last_proforma, s.bank_nummer AS s__bank_nummer, s.bic_number AS s__bic_number, s.account AS s__account, s.bank_nummer2 AS s__bank_nummer2, s.bic_number2 AS s__bic_number2, s.account2 AS s__account2, s.bank_nummer3 AS s__bank_nummer3, s.bic_number3 AS s__bic_number3, s.account3 AS s__account3, s.ogone_enabled AS s__ogone_enabled, s.choice_stock AS s__choice_stock, s.view_counter AS s__view_counter, s.cpt AS s__cpt, s.cpt_nc AS s__cpt_nc, s.cpt_pf AS s__cpt_pf, s.info_additional_invoice AS s__info_additional_invoice, s.fund_to_be_transferred AS s__fund_to_be_transferred, s.fund_to_be_transferred_bank AS s__fund_to_be_transferred_bank, s.fund_transferred AS s__fund_transferred, s.is_stock_in_trade AS s__is_stock_in_trade, s.is_stock_in_trade_url AS s__is_stock_in_trade_url, s.sale_status_id AS s__sale_status_id, s.position AS s__position, s.limit_at AS s__limit_at, s.locked_by AS s__locked_by, s.locked_until AS s__locked_until, s.global AS s__global, s.global_only AS s__global_only, s.manager_id AS s__manager_id, s.leader_id AS s__leader_id, s.could_be_closed AS s__could_be_closed, s.soon_available AS s__soon_available, s.key_status_id AS s__key_status_id, s.key_position AS s__key_position, s.sepa_communication_type AS s__sepa_communication_type, s.created_at AS s__created_at, s.updated_at AS s__updated_at FROM sale s WHERE (s.id = '9292') LIMIT 1

    0.01s, "doctrine" connection

16. SELECT DISTINCT p5.id, if(p5.isinstantsell, -1, COUNT(b2.product_id)) AS p5__8 FROM product p5 LEFT JOIN product_translation p6 ON p5.id = p6.id AND (p6.lang = 'fr') LEFT JOIN category c3 ON p5.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id AND (c4.lang = 'fr') LEFT JOIN product_type p7 ON p5.product_type_id = p7.id LEFT JOIN product_type_translation p8 ON p7.id = p8.id AND (p8.lang = 'fr') INNER JOIN sale s2 ON p5.sale_id = s2.id LEFT JOIN bid b2 ON p5.id = b2.product_id WHERE p5.sale_id = '9797' AND p5.enabled = 1 AND p5.htva_price > 0 AND p5.end_at > NOW() AND s2.enabled = 1 AND s2.end_at > NOW() AND ((p5.isinstantsell = 1 AND p5.stock_quantity_initial > p5.stock_quantity_sold) OR (p5.isinstantsell = 0 OR p5.isinstantsell IS NULL)) GROUP BY p5.id ORDER BY p5__8 DESC, p5.position ASC, GREATEST(p5.end_at, s2.end_at) ASC, p5.created_at ASC, p5.id ASC LIMIT 50

    0.00s, "doctrine" connection

17. SELECT p.id AS p__id, p.position AS p__position, p.parent_id AS p__parent_id, p.ref AS p__ref, p.reception_title AS p__reception_title, p.reception_model AS p__reception_model, p.reception_description AS p__reception_description, p.bids_count AS p__bids_count, p.actual_bid AS p__actual_bid, p.product_state_id AS p__product_state_id, p.begin_at AS p__begin_at, p.end_at AS p__end_at, p.adjudicated_at AS p__adjudicated_at, p.product_type_id AS p__product_type_id, p.weight AS p__weight, p.dimension AS p__dimension, p.ean_code AS p__ean_code, p.sell_type AS p__sell_type, p.htva_estimated_price AS p__htva_estimated_price, p.htva_price AS p__htva_price, p.htva_reserved_price AS p__htva_reserved_price, p.tva AS p__tva, p.vat_only AS p__vat_only, p.vat_rate_id AS p__vat_rate_id, p.vat_rate_commission_id AS p__vat_rate_commission_id, p.isinstantsell AS p__isinstantsell, p.instantprice AS p__instantprice, p.instant_serial AS p__instant_serial, p.instant_serial_mask AS p__instant_serial_mask, p.stock_quantity_initial AS p__stock_quantity_initial, p.stock_quantity_sold AS p__stock_quantity_sold, p.reduction AS p__reduction, p.type_commission AS p__type_commission, p.sell_mode AS p__sell_mode, p.type_ovc AS p__type_ovc, p.commission AS p__commission, p.tva_commission AS p__tva_commission, p.shipping AS p__shipping, p.estimated_delivery_at AS p__estimated_delivery_at, p.planned_delivery_at AS p__planned_delivery_at, p.enabled AS p__enabled, p.need_immatriculation_mandat AS p__need_immatriculation_mandat, p.hidden AS p__hidden, p.homepage AS p__homepage, p.brand_id AS p__brand_id, p.sale_id AS p__sale_id, p.category_id AS p__category_id, p.product_status_id AS p__product_status_id, p.stock_id AS p__stock_id, p.visited_at AS p__visited_at, p.delivery_at AS p__delivery_at, p.is_new AS p__is_new, p.date_end_new AS p__date_end_new, p.in_inventory AS p__in_inventory, p.is_stock_in_trade AS p__is_stock_in_trade, p.counter_consult AS p__counter_consult, p.counter_view AS p__counter_view, p.validated_at AS p__validated_at, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p2.id AS p2__id, p2.lang AS p2__lang, p2.title AS p2__0, p2.slug AS p2__1, p2.description AS p2__2, p2.short_description AS p2__4, c.id AS c__id, c.banner AS c__banner, c.position AS c__position, c.enabled AS c__enabled, c.parent_category_id AS c__parent_category_id, c.icon AS c__icon, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c2.id AS c2__id, c2.lang AS c2__lang, c2.slug AS c2__3, c2.title AS c2__5, p3.id AS p3__id, p3.banner AS p3__banner, p3.position AS p3__position, p3.enabled AS p3__enabled, p3.created_at AS p3__created_at, p3.updated_at AS p3__updated_at, p4.id AS p4__id, p4.lang AS p4__lang, p4.title AS p4__6, p2.title AS p2__0, p2.slug AS p2__1, p2.description AS p2__2, c2.slug AS c2__3, p2.short_description AS p2__4, c2.title AS c2__5, p4.title AS p4__6, (SELECT COUNT(b2.id) AS b2__0 FROM bid b2 WHERE (b2.product_id = p.id)) AS p__7, if(p.isinstantsell, -1, COUNT(b.product_id)) AS p__8 FROM product p LEFT JOIN product_translation p2 ON p.id = p2.id AND (p2.lang = 'fr') LEFT JOIN category c ON p.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id AND (c2.lang = 'fr') LEFT JOIN product_type p3 ON p.product_type_id = p3.id LEFT JOIN product_type_translation p4 ON p3.id = p4.id AND (p4.lang = 'fr') INNER JOIN sale s ON p.sale_id = s.id LEFT JOIN bid b ON p.id = b.product_id WHERE p.id IN ('190251') AND (p.sale_id = '9797' AND p.enabled = 1 AND p.htva_price > 0 AND p.end_at > NOW() AND s.enabled = 1 AND s.end_at > NOW() AND ((p.isinstantsell = 1 AND p.stock_quantity_initial > p.stock_quantity_sold) OR (p.isinstantsell = 0 OR p.isinstantsell IS NULL))) GROUP BY p.id ORDER BY p__8 DESC, p.position ASC, GREATEST(p.end_at, s.end_at) ASC, p.created_at ASC, p.id ASC

    0.00s, "doctrine" connection

18. SELECT b.id AS b__id, b.price AS b__price, b.max_price AS b__max_price, b.member_id AS b__member_id, b.product_id AS b__product_id, b.adjudicated_at AS b__adjudicated_at, b.created_at AS b__created_at, b.updated_at AS b__updated_at FROM bid b WHERE (b.product_id = '190251') ORDER BY b.created_at DESC, b.id DESC

    0.01s, "doctrine" connection

19. SELECT i.id AS i__id, IF(i.new_position IS NULL, position, i.new_position) AS i__0 FROM image_product i WHERE (i.enabled = 1 AND i.product_id = '190251') ORDER BY i__0 ASC

    0.01s, "doctrine" connection

20. SELECT s.id AS s__id, s.ref AS s__ref, s.sale_mother_id AS s__sale_mother_id, s.image AS s__image, s.banner AS s__banner, s.banner_new AS s__banner_new, s.judge_id AS s__judge_id, s.curator_id AS s__curator_id, s.associate_member_id AS s__associate_member_id, s.sale_type_id AS s__sale_type_id, s.last_invoice_id AS s__last_invoice_id, s.commercial_court AS s__commercial_court, s.begin_at AS s__begin_at, s.first_end_at AS s__first_end_at, s.end_at AS s__end_at, s.company_name AS s__company_name, s.address1 AS s__address1, s.address2 AS s__address2, s.post_code AS s__post_code, s.city AS s__city, s.social_reason AS s__social_reason, s.company_social_reason_id AS s__company_social_reason_id, s.matricule AS s__matricule, s.vat_number AS s__vat_number, s.country_id AS s__country_id, s.owner_description AS s__owner_description, s.activity_domain AS s__activity_domain, s.mission_description AS s__mission_description, s.enabled AS s__enabled, s.category_id AS s__category_id, s.mission_end AS s__mission_end, s.inventory_at AS s__inventory_at, s.validated_contract_at AS s__validated_contract_at, s.implementated_at AS s__implementated_at, s.sfguarduser_id AS s__sfguarduser_id, s.stock_id AS s__stock_id, s.tva AS s__tva, s.vat_rate_id AS s__vat_rate_id, s.commission AS s__commission, s.tva_commission AS s__tva_commission, s.vat_rate_commission_id AS s__vat_rate_commission_id, s.vendor_commission AS s__vendor_commission, s.account_to_receive AS s__account_to_receive, s.account_received AS s__account_received, s.vat_only AS s__vat_only, s.visit_pad AS s__visit_pad, s.visited_at AS s__visited_at, s.visit_closed AS s__visit_closed, s.visited_at_day AS s__visited_at_day, s.delivery_at AS s__delivery_at, s.delivery_at_day AS s__delivery_at_day, s.delivery_planned AS s__delivery_planned, s.delivery_temporary_planification AS s__delivery_temporary_planification, s.external_invoice AS s__external_invoice, s.type_external_invoice AS s__type_external_invoice, s.type_commission AS s__type_commission, s.sell_mode AS s__sell_mode, s.last_invoice_number AS s__last_invoice_number, s.invoice_prefix AS s__invoice_prefix, s.last_credit_note AS s__last_credit_note, s.last_proforma AS s__last_proforma, s.bank_nummer AS s__bank_nummer, s.bic_number AS s__bic_number, s.account AS s__account, s.bank_nummer2 AS s__bank_nummer2, s.bic_number2 AS s__bic_number2, s.account2 AS s__account2, s.bank_nummer3 AS s__bank_nummer3, s.bic_number3 AS s__bic_number3, s.account3 AS s__account3, s.ogone_enabled AS s__ogone_enabled, s.choice_stock AS s__choice_stock, s.view_counter AS s__view_counter, s.cpt AS s__cpt, s.cpt_nc AS s__cpt_nc, s.cpt_pf AS s__cpt_pf, s.info_additional_invoice AS s__info_additional_invoice, s.fund_to_be_transferred AS s__fund_to_be_transferred, s.fund_to_be_transferred_bank AS s__fund_to_be_transferred_bank, s.fund_transferred AS s__fund_transferred, s.is_stock_in_trade AS s__is_stock_in_trade, s.is_stock_in_trade_url AS s__is_stock_in_trade_url, s.sale_status_id AS s__sale_status_id, s.position AS s__position, s.limit_at AS s__limit_at, s.locked_by AS s__locked_by, s.locked_until AS s__locked_until, s.global AS s__global, s.global_only AS s__global_only, s.manager_id AS s__manager_id, s.leader_id AS s__leader_id, s.could_be_closed AS s__could_be_closed, s.soon_available AS s__soon_available, s.key_status_id AS s__key_status_id, s.key_position AS s__key_position, s.sepa_communication_type AS s__sepa_communication_type, s.created_at AS s__created_at, s.updated_at AS s__updated_at FROM sale s WHERE (s.id = '9797')

    0.01s, "doctrine" connection

21. SELECT v.id AS v__id, v.country_id AS v__country_id, v.vat_rate AS v__vat_rate, v.enabled AS v__enabled FROM vat_rate v WHERE (v.id = '4')

    0.00s, "doctrine" connection

22. SELECT d.id AS d__id, d.code AS d__code, d.value AS d__value, d.created_at AS d__created_at, d.updated_at AS d__updated_at FROM data d WHERE (d.code = 'HOME_TEXT_FR') LIMIT 1

    0.00s, "doctrine" connection

23. SELECT DISTINCT p3.id FROM product p3 LEFT JOIN product_translation p4 ON p3.id = p4.id AND (p4.lang = 'fr') LEFT JOIN image_product i2 ON p3.id = i2.product_id INNER JOIN sale s2 ON p3.sale_id = s2.id WHERE i2.enabled = '1' AND p3.homepage = '1' AND p3.enabled = 1 AND p3.htva_price > 0 AND p3.end_at > NOW() AND s2.enabled = 1 AND s2.end_at > NOW() ORDER BY i2.position LIMIT 4

    0.01s, "doctrine" connection

24. SELECT p.id AS p__id, p.position AS p__position, p.parent_id AS p__parent_id, p.ref AS p__ref, p.reception_title AS p__reception_title, p.reception_model AS p__reception_model, p.reception_description AS p__reception_description, p.bids_count AS p__bids_count, p.actual_bid AS p__actual_bid, p.product_state_id AS p__product_state_id, p.begin_at AS p__begin_at, p.end_at AS p__end_at, p.adjudicated_at AS p__adjudicated_at, p.product_type_id AS p__product_type_id, p.weight AS p__weight, p.dimension AS p__dimension, p.ean_code AS p__ean_code, p.sell_type AS p__sell_type, p.htva_estimated_price AS p__htva_estimated_price, p.htva_price AS p__htva_price, p.htva_reserved_price AS p__htva_reserved_price, p.tva AS p__tva, p.vat_only AS p__vat_only, p.vat_rate_id AS p__vat_rate_id, p.vat_rate_commission_id AS p__vat_rate_commission_id, p.isinstantsell AS p__isinstantsell, p.instantprice AS p__instantprice, p.instant_serial AS p__instant_serial, p.instant_serial_mask AS p__instant_serial_mask, p.stock_quantity_initial AS p__stock_quantity_initial, p.stock_quantity_sold AS p__stock_quantity_sold, p.reduction AS p__reduction, p.type_commission AS p__type_commission, p.sell_mode AS p__sell_mode, p.type_ovc AS p__type_ovc, p.commission AS p__commission, p.tva_commission AS p__tva_commission, p.shipping AS p__shipping, p.estimated_delivery_at AS p__estimated_delivery_at, p.planned_delivery_at AS p__planned_delivery_at, p.enabled AS p__enabled, p.need_immatriculation_mandat AS p__need_immatriculation_mandat, p.hidden AS p__hidden, p.homepage AS p__homepage, p.brand_id AS p__brand_id, p.sale_id AS p__sale_id, p.category_id AS p__category_id, p.product_status_id AS p__product_status_id, p.stock_id AS p__stock_id, p.visited_at AS p__visited_at, p.delivery_at AS p__delivery_at, p.is_new AS p__is_new, p.date_end_new AS p__date_end_new, p.in_inventory AS p__in_inventory, p.is_stock_in_trade AS p__is_stock_in_trade, p.counter_consult AS p__counter_consult, p.counter_view AS p__counter_view, p.validated_at AS p__validated_at, 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.title_balise AS p2__title_balise, p2.short_description AS p2__short_description, p2.description AS p2__description, p2.meta_desc AS p2__meta_desc, p2.meta_keyword AS p2__meta_keyword, p2.place_to_take AS p2__place_to_take, p2.meeting_option AS p2__meeting_option, p2.video_code AS p2__video_code, p2.line_invoice1 AS p2__line_invoice1, p2.line_invoice2 AS p2__line_invoice2, p2.line_invoice3 AS p2__line_invoice3, p2.lang AS p2__lang, p2.slug AS p2__slug, i.id AS i__id, i.url AS i__url, i.product_id AS i__product_id, i.extension AS i__extension, i.position AS i__position, i.new_position AS i__new_position, i.enabled AS i__enabled, i.created_at AS i__created_at, i.updated_at AS i__updated_at, s.id AS s__id, s.ref AS s__ref, s.sale_mother_id AS s__sale_mother_id, s.image AS s__image, s.banner AS s__banner, s.banner_new AS s__banner_new, s.judge_id AS s__judge_id, s.curator_id AS s__curator_id, s.associate_member_id AS s__associate_member_id, s.sale_type_id AS s__sale_type_id, s.last_invoice_id AS s__last_invoice_id, s.commercial_court AS s__commercial_court, s.begin_at AS s__begin_at, s.first_end_at AS s__first_end_at, s.end_at AS s__end_at, s.company_name AS s__company_name, s.address1 AS s__address1, s.address2 AS s__address2, s.post_code AS s__post_code, s.city AS s__city, s.social_reason AS s__social_reason, s.company_social_reason_id AS s__company_social_reason_id, s.matricule AS s__matricule, s.vat_number AS s__vat_number, s.country_id AS s__country_id, s.owner_description AS s__owner_description, s.activity_domain AS s__activity_domain, s.mission_description AS s__mission_description, s.enabled AS s__enabled, s.category_id AS s__category_id, s.mission_end AS s__mission_end, s.inventory_at AS s__inventory_at, s.validated_contract_at AS s__validated_contract_at, s.implementated_at AS s__implementated_at, s.sfguarduser_id AS s__sfguarduser_id, s.stock_id AS s__stock_id, s.tva AS s__tva, s.vat_rate_id AS s__vat_rate_id, s.commission AS s__commission, s.tva_commission AS s__tva_commission, s.vat_rate_commission_id AS s__vat_rate_commission_id, s.vendor_commission AS s__vendor_commission, s.account_to_receive AS s__account_to_receive, s.account_received AS s__account_received, s.vat_only AS s__vat_only, s.visit_pad AS s__visit_pad, s.visited_at AS s__visited_at, s.visit_closed AS s__visit_closed, s.visited_at_day AS s__visited_at_day, s.delivery_at AS s__delivery_at, s.delivery_at_day AS s__delivery_at_day, s.delivery_planned AS s__delivery_planned, s.delivery_temporary_planification AS s__delivery_temporary_planification, s.external_invoice AS s__external_invoice, s.type_external_invoice AS s__type_external_invoice, s.type_commission AS s__type_commission, s.sell_mode AS s__sell_mode, s.last_invoice_number AS s__last_invoice_number, s.invoice_prefix AS s__invoice_prefix, s.last_credit_note AS s__last_credit_note, s.last_proforma AS s__last_proforma, s.bank_nummer AS s__bank_nummer, s.bic_number AS s__bic_number, s.account AS s__account, s.bank_nummer2 AS s__bank_nummer2, s.bic_number2 AS s__bic_number2, s.account2 AS s__account2, s.bank_nummer3 AS s__bank_nummer3, s.bic_number3 AS s__bic_number3, s.account3 AS s__account3, s.ogone_enabled AS s__ogone_enabled, s.choice_stock AS s__choice_stock, s.view_counter AS s__view_counter, s.cpt AS s__cpt, s.cpt_nc AS s__cpt_nc, s.cpt_pf AS s__cpt_pf, s.info_additional_invoice AS s__info_additional_invoice, s.fund_to_be_transferred AS s__fund_to_be_transferred, s.fund_to_be_transferred_bank AS s__fund_to_be_transferred_bank, s.fund_transferred AS s__fund_transferred, s.is_stock_in_trade AS s__is_stock_in_trade, s.is_stock_in_trade_url AS s__is_stock_in_trade_url, s.sale_status_id AS s__sale_status_id, s.position AS s__position, s.limit_at AS s__limit_at, s.locked_by AS s__locked_by, s.locked_until AS s__locked_until, s.global AS s__global, s.global_only AS s__global_only, s.manager_id AS s__manager_id, s.leader_id AS s__leader_id, s.could_be_closed AS s__could_be_closed, s.soon_available AS s__soon_available, s.key_status_id AS s__key_status_id, s.key_position AS s__key_position, s.sepa_communication_type AS s__sepa_communication_type, s.created_at AS s__created_at, s.updated_at AS s__updated_at FROM product p LEFT JOIN product_translation p2 ON p.id = p2.id AND (p2.lang = 'fr') LEFT JOIN image_product i ON p.id = i.product_id INNER JOIN sale s ON p.sale_id = s.id WHERE p.id IN ('189893', '190292', '191359', '190312') AND (i.enabled = '1' AND p.homepage = '1' AND p.enabled = 1 AND p.htva_price > 0 AND p.end_at > NOW() AND s.enabled = 1 AND s.end_at > NOW()) ORDER BY i.position

    0.02s, "doctrine" connection

25. SELECT c.id AS c__id, c.number AS c__number, c.alpha3 AS c__alpha3, c.alpha2 AS c__alpha2, c.vat_mask AS c__vat_mask, c.enabled AS c__enabled, c.position AS c__position, c.created_at AS c__created_at, c.updated_at AS c__updated_at FROM country c WHERE (c.id = '20')

    0.00s, "doctrine" connection

26. SELECT c.id AS c__id, c.number AS c__number, c.alpha3 AS c__alpha3, c.alpha2 AS c__alpha2, c.vat_mask AS c__vat_mask, c.enabled AS c__enabled, c.position AS c__position, c.created_at AS c__created_at, c.updated_at AS c__updated_at FROM country c WHERE (c.id = '20')

    0.00s, "doctrine" connection

27. SELECT c.id AS c__id, c.number AS c__number, c.alpha3 AS c__alpha3, c.alpha2 AS c__alpha2, c.vat_mask AS c__vat_mask, c.enabled AS c__enabled, c.position AS c__position, c.created_at AS c__created_at, c.updated_at AS c__updated_at FROM country c WHERE (c.id = '20')

    0.00s, "doctrine" connection

28. SELECT c.id AS c__id, c.number AS c__number, c.alpha3 AS c__alpha3, c.alpha2 AS c__alpha2, c.vat_mask AS c__vat_mask, c.enabled AS c__enabled, c.position AS c__position, c.created_at AS c__created_at, c.updated_at AS c__updated_at FROM country c WHERE (c.id = '20')

    0.00s, "doctrine" connection

29. SELECT p.id AS p__id, p.template_id AS p__template_id, p.code AS p__code, p.position AS p__position, p.in_sitemap AS p__in_sitemap, p.enabled AS p__enabled, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p2.id AS p2__id, p2.meta_title AS p2__meta_title, p2.meta_keyword AS p2__meta_keyword, p2.meta_description AS p2__meta_description, p2.lang AS p2__lang, p2.slug AS p2__slug FROM page p LEFT JOIN page_translation p2 ON p.id = p2.id WHERE (p.code = 'HELP')

    0.00s, "doctrine" connection

30. SELECT p.id AS p__id, p.template_id AS p__template_id, p.code AS p__code, p.position AS p__position, p.in_sitemap AS p__in_sitemap, p.enabled AS p__enabled, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p2.id AS p2__id, p2.meta_title AS p2__meta_title, p2.meta_keyword AS p2__meta_keyword, p2.meta_description AS p2__meta_description, p2.lang AS p2__lang, p2.slug AS p2__slug FROM page p LEFT JOIN page_translation p2 ON p.id = p2.id WHERE (p.code = 'CGV')

    0.00s, "doctrine" connection

31. SELECT p.id AS p__id, p.template_id AS p__template_id, p.code AS p__code, p.position AS p__position, p.in_sitemap AS p__in_sitemap, p.enabled AS p__enabled, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p2.id AS p2__id, p2.meta_title AS p2__meta_title, p2.meta_keyword AS p2__meta_keyword, p2.meta_description AS p2__meta_description, p2.lang AS p2__lang, p2.slug AS p2__slug FROM page p LEFT JOIN page_translation p2 ON p.id = p2.id WHERE (p.code = 'COOKIE')

    0.00s, "doctrine" connection