Configuration

debug
xdebug
logging
cache
compression
tokenizer
eaccelerator
apc
xcache

Request

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
  c: '45'
  module: product
attributeHolder:
  sf_route: 'sfRoute Object()'

Response

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=1755234071': {  }
metas:
  title: 'Camions, Utilitaires &amp; Remorques  (7 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'

User

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: 1755307822

Settings

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
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

Globals

cookie:
  symfony: 3308dnufdn5jhti7qfktpn9mq7
env: {  }
files: {  }
get:
  c: '45'
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=3308dnufdn5jhti7qfktpn9mq7
  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: c=45
  REMOTE_ADDR: 216.73.216.138
  REMOTE_PORT: '23332'
  REQUEST_METHOD: GET
  REQUEST_SCHEME: https
  REQUEST_TIME: 1755307822
  REQUEST_TIME_FLOAT: 1755307822.7593
  REQUEST_URI: '/igw_dev.php/category?c=45'
  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, limit: 50 } }
  symfony/user/sfUser/authenticated: false
  symfony/user/sfUser/credentials: {  }
  symfony/user/sfUser/culture: fr
  symfony/user/sfUser/lastRequest: 1755307820

Php

php: 7.4.33
os: 'Linux vps645206 5.4.0-218-generic #238-Ubuntu SMP Mon May 19 10:42:47 UTC 2025 x86_64'
extensions:
  17: 'calendar (7.4.33)'
  13: 'cgi-fcgi (7.4.33)'
  0: 'Core (7.4.33)'
  18: 'ctype (7.4.33)'
  19: 'curl (7.4.33)'
  1: 'date (7.4.33)'
  20: 'dom (20031129)'
  32: 'exif (7.4.33)'
  22: 'FFI (7.4.33)'
  23: 'fileinfo (7.4.33)'
  6: 'filter (7.4.33)'
  24: 'ftp (7.4.33)'
  25: 'gd (7.4.33)'
  26: 'gettext (7.4.33)'
  7: 'hash (7.4.33)'
  27: 'iconv (7.4.33)'
  28: 'imagick (3.8.0)'
  29: 'imap (7.4.33)'
  30: 'intl (7.4.33)'
  31: 'json (7.4.33)'
  2: 'libxml (7.4.33)'
  21: 'mbstring (7.4.33)'
  33: '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)'
  34: 'pdo_mysql (7.4.33)'
  35: 'Phar (7.4.33)'
  37: 'posix (7.4.33)'
  38: 'readline (7.4.33)'
  8: 'Reflection (7.4.33)'
  36: 'remctl (3.16)'
  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)'

Symfony

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

View Layer

Template: product … allSuccess.php

Parameters:

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

Partial: default … _widget_category.php

Partial: product … _sort.php

Partial: product … _pager.php

Partial: default … _product_row.php

Partial: product … _counter.php

Partial: product … _message_bid.php

Partial: default … _script-js-follow.js.php

Partial: default … _product_row.php

Partial: product … _counter.php

Partial: product … _message_bid.php

Partial: default … _script-js-follow.js.php

Partial: default … _product_row.php

Partial: product … _counter.php

Partial: product … _message_bid.php

Partial: default … _script-js-follow.js.php

Partial: default … _product_row.php

Partial: product … _counter.php

Partial: product … _message_bid.php

Partial: default … _script-js-follow.js.php

Partial: default … _product_row.php

Partial: product … _counter.php

Partial: product … _message_bid.php

Partial: default … _script-js-follow.js.php

Partial: default … _product_row.php

Partial: product … _counter.php

Partial: product … _message_bid.php

Partial: default … _script-js-follow.js.php

Partial: default … _product_row.php

Partial: product … _counter.php

Partial: product … _message_bid.php

Partial: default … _script-js-follow.js.php

Partial: default … _analytics.php

Partial: default … _header.php

Partial: default … _navigation.php

Partial: default … _search.php

Partial: default … _member_menu.php

Partial: default … _sub_footer.php

Partial: default … _widget_newsletter.php

Partial: default … _widget_beginnow.php

Partial: default … _widget_selection.php

Partial: product … _counter.php

Partial: default … _script-js-follow.js.php

Partial: product … _counter.php

Partial: default … _script-js-follow.js.php

Partial: default … _footer.php

Partial: default … _robot.php

Logs

#	type	message
1	myPatternRouting	Match route "category" (/category) for /category with parameters array ( 'module' => 'product', 'action' => 'all',)
2	sfFilterChain	Executing filter "sfRenderingFilter"
3	sfFilterChain	Executing filter "sslFilter"
4	sfFilterChain	Executing filter "domainCultureFilter"
5	sfFilterChain	Executing filter "checkMobileFilter"
6	sfFilterChain	Executing filter "sfExecutionFilter"
7	productActions	Call "productActions->executeAll()"
8	Doctrine_Connection_Mysql	exec : SET NAMES 'UTF8' - ()
9	Doctrine_Connection_Statement	execute : SELECT 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 FROM category c WHERE (c.enabled = 1 AND c.id = ?) - (45)
10	Doctrine_Connection_Statement	execute : 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 = ?) LEFT JOIN category c ON p.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id AND (c2.lang = ?) 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 = ?) INNER JOIN sale s ON p.sale_id = s.id LEFT JOIN bid b ON p.id = b.product_id WHERE p.enabled = 1 AND p.htva_price > 0 AND p.end_at > NOW() AND s.enabled = 1 AND s.end_at > NOW() AND p.category_id = ? 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 - (fr, fr, fr, 45)
11	Doctrine_Connection_Statement	execute : SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.twitter_account AS c__twitter_account, c.lang AS c__lang, c.slug AS c__slug FROM category_translation c WHERE (c.id IN (?)) - (45)
12	sfPHPView	Render "sf_app_dir/modules/product/templates/allSuccess.php"
13	main	Call "default->executeWidget_category()"
14	sfPartialView	Render "sf_app_dir/modules/default/templates/_widget_category.php"
15	Doctrine_Connection_Statement	execute : 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)
16	sfPartialView	Render "sf_app_dir/modules/product/templates/_sort.php"
17	sfPartialView	Render "sf_app_dir/modules/product/templates/_sort.php"
18	sfPartialView	Render "sf_app_dir/modules/product/templates/_sort.php"
19	sfPartialView	Render "sf_app_dir/modules/product/templates/_sort.php"
20	sfPartialView	Render "sf_app_dir/modules/product/templates/_pager.php"
21	Doctrine_Connection_Statement	execute : 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 = ?) LEFT JOIN category c3 ON p5.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id AND (c4.lang = ?) 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 = ?) INNER JOIN sale s2 ON p5.sale_id = s2.id LEFT JOIN bid b2 ON p5.id = b2.product_id WHERE p5.enabled = 1 AND p5.htva_price > 0 AND p5.end_at > NOW() AND s2.enabled = 1 AND s2.end_at > NOW() AND p5.category_id = ? 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 - (fr, fr, fr, 45)
22	Doctrine_Connection_Statement	execute : 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 = ?) LEFT JOIN category c ON p.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id AND (c2.lang = ?) 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 = ?) INNER JOIN sale s ON p.sale_id = s.id LEFT JOIN bid b ON p.id = b.product_id WHERE p.id IN ('201577', '201519', '201518', '201576', '201540', '200860', '200861') 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.category_id = ? 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 - (fr, fr, fr, 45)
23	sfPartialView	Render "sf_app_dir/modules/default/templates/_product_row.php"
24	Doctrine_Connection_Statement	execute : 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 = ?) ORDER BY b.created_at DESC, b.id DESC - (201577)
25	Doctrine_Connection_Statement	execute : 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 = ?) ORDER BY i__0 ASC - (201577)
26	Doctrine_Connection_Statement	execute : 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.report_before_start AS s__report_before_start, 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 = ?) - (10529)
27	Doctrine_Connection_Statement	execute : 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)
28	sfPartialView	Render "sf_app_dir/modules/product/templates/_counter.php"
29	Doctrine_Connection_Statement	execute : 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)
30	sfPartialView	Render "sf_app_dir/modules/product/templates/_message_bid.php"
31	main	Set slot "isNotBestBidder"
32	sfPartialView	Render "sf_app_dir/modules/default/templates/_script-js-follow.js.php"
33	sfPartialView	Render "sf_app_dir/modules/default/templates/_product_row.php"
34	Doctrine_Connection_Statement	execute : 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 = ?) ORDER BY b.created_at DESC, b.id DESC - (201519)
35	Doctrine_Connection_Statement	execute : 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 = ?) ORDER BY i__0 ASC - (201519)
36	Doctrine_Connection_Statement	execute : 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.report_before_start AS s__report_before_start, 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 = ?) - (10465)
37	Doctrine_Connection_Statement	execute : 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)
38	sfPartialView	Render "sf_app_dir/modules/product/templates/_counter.php"
39	Doctrine_Connection_Statement	execute : 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)
40	sfPartialView	Render "sf_app_dir/modules/product/templates/_message_bid.php"
41	main	Set slot "isNotBestBidder"
42	sfPartialView	Render "sf_app_dir/modules/default/templates/_script-js-follow.js.php"
43	sfPartialView	Render "sf_app_dir/modules/default/templates/_product_row.php"
44	Doctrine_Connection_Statement	execute : 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 = ?) ORDER BY b.created_at DESC, b.id DESC - (201518)
45	Doctrine_Connection_Statement	execute : 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 = ?) ORDER BY i__0 ASC - (201518)
46	Doctrine_Connection_Statement	execute : 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.report_before_start AS s__report_before_start, 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 = ?) - (10465)
47	sfPartialView	Render "sf_app_dir/modules/product/templates/_counter.php"
48	Doctrine_Connection_Statement	execute : 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)
49	sfPartialView	Render "sf_app_dir/modules/product/templates/_message_bid.php"
50	main	Set slot "isNotBestBidder"
51	sfPartialView	Render "sf_app_dir/modules/default/templates/_script-js-follow.js.php"
52	sfPartialView	Render "sf_app_dir/modules/default/templates/_product_row.php"
53	Doctrine_Connection_Statement	execute : 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 = ?) ORDER BY b.created_at DESC, b.id DESC - (201576)
54	Doctrine_Connection_Statement	execute : 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 = ?) ORDER BY i__0 ASC - (201576)
55	Doctrine_Connection_Statement	execute : 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.report_before_start AS s__report_before_start, 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 = ?) - (10529)
56	sfPartialView	Render "sf_app_dir/modules/product/templates/_counter.php"
57	Doctrine_Connection_Statement	execute : 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)
58	sfPartialView	Render "sf_app_dir/modules/product/templates/_message_bid.php"
59	main	Set slot "isNotBestBidder"
60	sfPartialView	Render "sf_app_dir/modules/default/templates/_script-js-follow.js.php"
61	sfPartialView	Render "sf_app_dir/modules/default/templates/_product_row.php"
62	Doctrine_Connection_Statement	execute : 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 = ?) ORDER BY b.created_at DESC, b.id DESC - (201540)
63	Doctrine_Connection_Statement	execute : 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 = ?) ORDER BY i__0 ASC - (201540)
64	Doctrine_Connection_Statement	execute : 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.report_before_start AS s__report_before_start, 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 = ?) - (10465)
65	sfPartialView	Render "sf_app_dir/modules/product/templates/_counter.php"
66	Doctrine_Connection_Statement	execute : 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)
67	sfPartialView	Render "sf_app_dir/modules/product/templates/_message_bid.php"
68	main	Set slot "isNotBestBidder"
69	sfPartialView	Render "sf_app_dir/modules/default/templates/_script-js-follow.js.php"
70	sfPartialView	Render "sf_app_dir/modules/default/templates/_product_row.php"
71	Doctrine_Connection_Statement	execute : 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 = ?) ORDER BY b.created_at DESC, b.id DESC - (200860)
72	Doctrine_Connection_Statement	execute : 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 = ?) ORDER BY i__0 ASC - (200860)
73	Doctrine_Connection_Statement	execute : 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.report_before_start AS s__report_before_start, 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 = ?) - (10370)
74	Doctrine_Connection_Statement	execute : 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)
75	sfPartialView	Render "sf_app_dir/modules/product/templates/_counter.php"
76	Doctrine_Connection_Statement	execute : 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)
77	sfPartialView	Render "sf_app_dir/modules/product/templates/_message_bid.php"
78	main	Set slot "isNotBestBidder"
79	sfPartialView	Render "sf_app_dir/modules/default/templates/_script-js-follow.js.php"
80	sfPartialView	Render "sf_app_dir/modules/default/templates/_product_row.php"
81	Doctrine_Connection_Statement	execute : 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 = ?) ORDER BY b.created_at DESC, b.id DESC - (200861)
82	Doctrine_Connection_Statement	execute : 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 = ?) ORDER BY i__0 ASC - (200861)
83	Doctrine_Connection_Statement	execute : 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.report_before_start AS s__report_before_start, 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 = ?) - (10370)
84	sfPartialView	Render "sf_app_dir/modules/product/templates/_counter.php"
85	Doctrine_Connection_Statement	execute : 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)
86	sfPartialView	Render "sf_app_dir/modules/product/templates/_message_bid.php"
87	main	Set slot "isNotBestBidder"
88	sfPartialView	Render "sf_app_dir/modules/default/templates/_script-js-follow.js.php"
89	sfPHPView	Decorate content with "sf_app_dir/templates/layout.php"
90	sfPHPView	Render "sf_app_dir/templates/layout.php"
91	sfPartialView	Render "sf_app_dir/modules/default/templates/_analytics.php"
92	sfPartialView	Render "sf_app_dir/modules/default/templates/_header.php"
93	Doctrine_Connection_Statement	execute : 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 = ?) LIMIT 1 - (HOME_TEXT_FR)
94	sfPartialView	Render "sf_app_dir/modules/default/templates/_navigation.php"
95	main	Call "default->executeSearch()"
96	sfPartialView	Render "sf_app_dir/modules/default/templates/_search.php"
97	sfPartialView	Render "sf_app_dir/modules/default/templates/_member_menu.php"
98	sfPartialView	Render "sf_app_dir/modules/default/templates/_sub_footer.php"
99	main	Call "default->executeWidget_newsletter()"
100	sfPartialView	Render "sf_app_dir/modules/default/templates/_widget_newsletter.php"
101	sfPartialView	Render "sf_app_dir/modules/default/templates/_widget_beginnow.php"
102	main	Call "default->executeWidget_selection()"
103	Doctrine_Connection_Statement	execute : SELECT DISTINCT p3.id FROM product p3 LEFT JOIN product_translation p4 ON p3.id = p4.id AND (p4.lang = ?) LEFT JOIN image_product i2 ON p3.id = i2.product_id INNER JOIN sale s2 ON p3.sale_id = s2.id WHERE i2.enabled = ? AND p3.homepage = ? 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 - (fr, 1, 1)
104	Doctrine_Connection_Statement	execute : 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.report_before_start AS s__report_before_start, 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 = ?) 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 ('200388', '200445') AND (i.enabled = ? AND p.homepage = ? 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 - (fr, 1, 1)
105	sfPartialView	Render "sf_app_dir/modules/default/templates/_widget_selection.php"
106	Doctrine_Connection_Statement	execute : 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)
107	sfPartialView	Render "sf_app_dir/modules/product/templates/_counter.php"
108	sfPartialView	Render "sf_app_dir/modules/default/templates/_script-js-follow.js.php"
109	sfPartialView	Render "sf_app_dir/modules/product/templates/_counter.php"
110	sfPartialView	Render "sf_app_dir/modules/default/templates/_script-js-follow.js.php"
111	sfPartialView	Render "sf_app_dir/modules/default/templates/_footer.php"
112	Doctrine_Connection_Statement	execute : 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)
113	Doctrine_Connection_Statement	execute : 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)
114	Doctrine_Connection_Statement	execute : 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)
115	Doctrine_Connection_Statement	execute : 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 = ?) - (ACCESSIBILITE)
116	sfPartialView	Render "sf_app_dir/modules/default/templates/_robot.php"
117	sfWebResponse	Send status "HTTP/1.1 200 OK"
118	sfWebResponse	Send header "Content-Type: text/html; charset=utf-8"

type	calls	time (ms)	time (%)
Configuration	20	446.79	45
Factories	1	13.37	1
Action "product/all"	1	512.50	52
Database (Doctrine)	46	0.04	0
View "Success" for "product/all"	1	405.00	41
Component "default/widget_category"	1	18.91	1
Partial "default/_widget_category"	1	4.49	0
Partial "product/_sort"	4	0.39	0
Partial "product/_pager"	1	224.45	23
Partial "default/_product_row"	7	185.11	19
Partial "product/_counter"	9	13.91	1
Partial "product/_message_bid"	7	1.51	0
Partial "default/_script-js-follow.js"	9	4.28	0
Partial "default/_analytics"	1	0.11	0
Partial "default/_header"	1	3.44	0
Partial "default/_navigation"	1	3.25	0
Component "default/search"	1	0.32	0
Partial "default/_search"	1	0.19	0
Partial "default/_member_menu"	1	0.09	0
Partial "default/_sub_footer"	1	127.98	13
Component "default/widget_newsletter"	1	0.07	0
Partial "default/_widget_newsletter"	1	0.19	0
Partial "default/_widget_beginnow"	1	1.28	0
Component "default/widget_selection"	1	105.45	10
Partial "default/_widget_selection"	1	19.89	2
Partial "default/_footer"	1	17.97	1
Partial "default/_robot"	1	0.11	0

SQL queries

Doctrine Version: 1.2.4

SET NAMES 'UTF8'

0.00s, "doctrine" connection
SELECT 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 FROM category c WHERE (c.enabled = 1 AND c.id = '45')

0.00s, "doctrine" connection
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.enabled = 1 AND p.htva_price > 0 AND p.end_at > NOW() AND s.enabled = 1 AND s.end_at > NOW() AND p.category_id = '45' 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
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.twitter_account AS c__twitter_account, c.lang AS c__lang, c.slug AS c__slug FROM category_translation c WHERE (c.id IN ('45'))

0.00s, "doctrine" connection
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
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.enabled = 1 AND p5.htva_price > 0 AND p5.end_at > NOW() AND s2.enabled = 1 AND s2.end_at > NOW() AND p5.category_id = '45' 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.01s, "doctrine" connection
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 ('201577', '201519', '201518', '201576', '201540', '200860', '200861') 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.category_id = '45' 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.01s, "doctrine" connection
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 = '201577') ORDER BY b.created_at DESC, b.id DESC

0.00s, "doctrine" connection
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 = '201577') ORDER BY i__0 ASC

0.00s, "doctrine" connection
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.report_before_start AS s__report_before_start, 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 = '10529')

0.00s, "doctrine" connection
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
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
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 = '201519') ORDER BY b.created_at DESC, b.id DESC

0.00s, "doctrine" connection
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 = '201519') ORDER BY i__0 ASC

0.00s, "doctrine" connection
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.report_before_start AS s__report_before_start, 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 = '10465')

0.00s, "doctrine" connection
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
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
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 = '201518') ORDER BY b.created_at DESC, b.id DESC

0.00s, "doctrine" connection
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 = '201518') ORDER BY i__0 ASC

0.00s, "doctrine" connection
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.report_before_start AS s__report_before_start, 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 = '10465')

0.00s, "doctrine" connection
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
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 = '201576') ORDER BY b.created_at DESC, b.id DESC

0.00s, "doctrine" connection
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 = '201576') ORDER BY i__0 ASC

0.00s, "doctrine" connection
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.report_before_start AS s__report_before_start, 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 = '10529')

0.00s, "doctrine" connection
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
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 = '201540') ORDER BY b.created_at DESC, b.id DESC

0.00s, "doctrine" connection
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 = '201540') ORDER BY i__0 ASC

0.00s, "doctrine" connection
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.report_before_start AS s__report_before_start, 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 = '10465')

0.00s, "doctrine" connection
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
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 = '200860') ORDER BY b.created_at DESC, b.id DESC

0.00s, "doctrine" connection
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 = '200860') ORDER BY i__0 ASC

0.00s, "doctrine" connection
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.report_before_start AS s__report_before_start, 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 = '10370')

0.00s, "doctrine" connection
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
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
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 = '200861') ORDER BY b.created_at DESC, b.id DESC

0.00s, "doctrine" connection
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 = '200861') ORDER BY i__0 ASC

0.00s, "doctrine" connection
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.report_before_start AS s__report_before_start, 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 = '10370')

0.00s, "doctrine" connection
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
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
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
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.report_before_start AS s__report_before_start, 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 ('200388', '200445') 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
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
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
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
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
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 = 'ACCESSIBILITE')

0.00s, "doctrine" connection

RENAULT Master

FIAT Ducato

OPEL Combo

Remorque double essieux

PEUGEOT Partner

Remorque plateau

Remorque

Notre newsletter

Vendre sur clicpublic.be

Notre sélection

Restons connectés

Ils parlent de nous

Configuration

Request

Response

User

Settings

Globals

Php

Symfony

View Layer

Template: product … allSuccess.php

Partial: default … _widget_category.php

Partial: product … _sort.php

Partial: product … _sort.php

Partial: product … _sort.php

Partial: product … _sort.php

Partial: product … _pager.php

Partial: default … _product_row.php

Partial: product … _counter.php

Partial: product … _message_bid.php

Partial: default … _script-js-follow.js.php

Partial: default … _product_row.php

Partial: product … _counter.php

Partial: product … _message_bid.php

Partial: default … _script-js-follow.js.php

Partial: default … _product_row.php

Partial: product … _counter.php

Partial: product … _message_bid.php

Partial: default … _script-js-follow.js.php

Partial: default … _product_row.php

Partial: product … _counter.php

Partial: product … _message_bid.php

Partial: default … _script-js-follow.js.php

Partial: default … _product_row.php

Partial: product … _counter.php

Partial: product … _message_bid.php

Partial: default … _script-js-follow.js.php

Partial: default … _product_row.php

Partial: product … _counter.php

Partial: product … _message_bid.php

Partial: default … _script-js-follow.js.php

Partial: default … _product_row.php

Partial: product … _counter.php

Partial: product … _message_bid.php

Partial: default … _script-js-follow.js.php

Partial: default … _analytics.php

Partial: default … _header.php

Partial: default … _navigation.php

Partial: default … _search.php

Partial: default … _member_menu.php

Partial: default … _sub_footer.php

Partial: default … _widget_newsletter.php

Partial: default … _widget_beginnow.php

Partial: default … _widget_selection.php

Partial: product … _counter.php

Partial: default … _script-js-follow.js.php

Partial: product … _counter.php

Partial: default … _script-js-follow.js.php

Partial: default … _footer.php

Partial: default … _robot.php

Logs

Timers

SQL queries

Doctrine Version: 1.2.4