Vente aux enchères de 3 biens
Nombre d'enchère(s) 4
Vues de la vente 2160
marque : APPLE - modèle : A1876 - Serial : DLXXN9HPK7M9
Enchère actuelle : 45 € HTVA (54,45 € TVAC)
Nombre d'enchère(s) 2
Référence : J-10321-10322-2
marque : APPLE - modèle : A1706 - Serial : C02T259HGYFH
Enchère actuelle : 40 € HTVA (48,40 € TVAC)
Nombre d'enchère(s) 1
Référence : J-10321-10322-3
marque : APPLE - modèle : A3102 - Serial : MF45DYPQ97
Enchère actuelle : 300 € HTVA (363 € TVAC)
Nombre d'enchère(s) 1
Référence : J-10321-10322-1
Clicpublic.be c'est le site Belge spécialisé dans les ventes aux enchères en ligne provenant de sources judiciaires : Faillites, saisies, successions vacantes, ... Nous réalisons également des ventes aux enchères pour les déstockages d'entreprises. Notre équipe est spécialisée dans les ventes aux enchères en Belgique et au Luxembourg, nos locaux sont situés dans le Brabant Wallon à Nivelles et au Luxembourg.
Par mail: info@clicpublic.be
Adresse : Rue du Bosquet 21, 1400 Nivelles - Belgique
TVA : BE 0501.706.962
config
view
logs
6144.0 KB
703 ms
44
options:
path_info_key: PATH_INFO
path_info_array: SERVER
http_port: null
https_port: null
default_format: null
logging: '1'
relative_url_root: null
formats: { txt: text/plain, js: [application/javascript, application/x-javascript, text/javascript], css: text/css, json: [application/json, application/x-json], xml: [text/xml, application/xml, application/x-xml], rdf: application/rdf+xml, atom: application/atom+xml }
no_script_name: false
parameterHolder:
action: all
module: product
sale: '10322'
attributeHolder:
sf_route: 'sfRoute Object()'
status:
code: 200
text: OK
options:
http_protocol: HTTP/1.1
logging: '1'
charset: utf-8
send_http_headers: false
content_type: 'text/html; charset=utf-8'
cookies: { }
httpHeaders:
Content-Type: 'text/html; charset=utf-8'
javascripts:
'https://d3bsbe39k8p2a0.cloudfront.net//js/jquery.validate.min.js': { }
/js/bootstrap.min.js: { }
/js/new/jquery-ui.min.js: { }
/js/new/anime.min.js: { }
/js/sweetalert2.min.js: { }
/js/new/camelize.js: { }
jquery.unveil.js: { }
stylesheets:
'https://d3bsbe39k8p2a0.cloudfront.net/css/new/bootstrap.css': { }
/css/font-awesome-5.0.min.css: { }
'https://d3bsbe39k8p2a0.cloudfront.net/css/new/jquery-ui.min.css': { }
'https://d3bsbe39k8p2a0.cloudfront.net/css/new/jquery-ui.structure.min.css': { }
'https://d3bsbe39k8p2a0.cloudfront.net/css/new/owl-carousel/owl.carousel.min.css': { }
'https://d3bsbe39k8p2a0.cloudfront.net/css/new/owl-carousel/owl.theme.default.min.css': { }
'https://d3bsbe39k8p2a0.cloudfront.net/css/sweetalert2.min.css': { }
'https://d3bsbe39k8p2a0.cloudfront.net/css/new/main.css?v=1752740176': { }
metas:
title: 'Matériel informatique (3 biens au total) - Clicpublic.be, les ventes publiques en 1 clic.'
viewport: 'width=device-width, initial-scale=1.0'
httpMetas:
Content-Type: 'text/html; charset=utf-8'
options:
auto_shutdown: false
culture: null
default_culture: fr
use_flash: true
logging: '1'
timeout: 1800
attributeHolder:
symfony/user/sfUser/attributes: { limit: 50, user_country: be }
culture: fr
authenticated: null
credentials: { }
lastRequest: 1752793053
app_default_backofficemail: backoffice@clicpublic.be
app_default_backofficemail_lu: backoffice@clicpublic.lu
app_default_cdn: d3bsbe39k8p2a0.cloudfront.net
app_default_fb_access_token: EAAF2BkO6VkcBO0ZBlh6IwcGQclyNspVsKtFPmhUubjmDrzxakl86lnOd1TBOkqZBi7bxUmjLIcQ2KGIqZB9RAhSsf9rZCdMozitvcozlNXkdg9aKZArBGPZBPWoZC2ssxaOJkhT6Mu4hHlFGz5a4yQkJSZAl35VZA6c1IIk5Mc2mvbehDLDJu81Hp86YN2TCEd1GINwZDZD
app_default_fb_api_version: v17.0
app_default_fb_pixel_id: 197794934140740
app_default_gavel_orange_bid: 10
app_default_gavel_red_bid: 20
app_default_hotdeals: 10
app_default_mail: info@clicpublic.be
app_default_mail_be: info@clicpublic.be
app_default_mail_from: clicpublic
app_default_mail_lu: info@clicpublic.lu
app_default_no-reply: no-reply@clicpublic.be
app_default_no-reply_lu: no-reply@clicpublic.lu
app_default_ovh_api_application_key: I5x89YKoW0amEYi2
app_default_ovh_api_application_secret: 9ZLUd2i4TruJ4PN1Or2hQDhB5YXZNUMJ
app_default_ovh_api_consumer_key: 3pQkRb3Rkz3F49E6h6DfRm1GVH1WmvSN
app_default_product_per_page: 9
app_default_recaptcha_public: 6LeJeUkaAAAAABWwmzI9n0WBPxfM-uFFaRQ9iiza
app_default_recaptcha_secret: 6LeJeUkaAAAAAHdPZrDLJkOfG6dm-dcZwqegiyLa
app_default_sale_validation: info@clicpublic.be
app_default_sale_validation_lu: info@clicpublic.lu
app_default_salt: 'X+D_dq0z_B3= Mk-I|YW9 8acWO|Sg9WE=sc=GqCDxV+5krjhQ_ndqBq5uKC'
app_default_show_product: 50
app_default_voicepartner_apikey: bi0Y3uNU-abr7qZ3-3J3oMEfB3P-SiUmojC0L
app_local_de: de_DE
app_local_en: en_GB
app_local_fr: fr_FR
app_local_nl: nl_NL
app_mail_admin_dev: it@clicpublic.be
app_ohMailChimp_api_key: YourApiKeyHere
app_ohMailChimp_class_name: ohMailChimpApi
app_ohMailChimp_list_id: YourListIdHere
app_ohMailChimp_logging: true
app_ohMailChimp_throw_exception: true
app_sfImageTransformPlugin_default_adapter: GD
app_sfImageTransformPlugin_default_image:
mime_type: image/png
filename: Untitled.png
width: 100
height: 100
color: '#FFFFFF'
app_sfImageTransformPlugin_font_dir: /usr/share/fonts/truetype/msttcorefonts
app_sfImageTransformPlugin_mime_type:
auto_detect: true
library: gd_mime_type
app_sf_media_browser_assets_list:
js: null
css: [/sfMediaBrowserPlugin/css/list.css]
app_sf_media_browser_assets_widget:
js: [/sfMediaBrowserPlugin/js/WindowManager.js, /sfMediaBrowserPlugin/js/form_widget.js]
css: [/sfMediaBrowserPlugin/css/form_widget.css]
app_sf_media_browser_file_types:
document: { extensions: [doc, xls, xcf, ai], icon: doc }
image: { extensions: [png, jpg, jpeg, gif] }
pdf: { extensions: [pdf] }
bin: { extensions: [bin, exe, sh, bat, deb, yum] }
video: { extensions: [wmv, avi, mpg, mpeg, flv, mp4] }
audio: { extensions: [ogg, mp3, flac, wma, cda] }
text: { extensions: [txt] }
tarball: { extensions: [tar, gz, zip, bzip, gzip, rar, 7z] }
app_sf_media_browser_root_dir: /uploads
app_sf_media_browser_thumbnails_dir: .thumbnails
app_sf_media_browser_thumbnails_enabled: true
app_sf_media_browser_thumbnails_max_height: 64
app_sf_media_browser_thumbnails_max_width: 64
app_show_product: 20
app_site_be_de: 'https://de.clicpublic.be/'
app_site_be_en: 'https://en.clicpublic.be/'
app_site_be_fr: 'https://www.clicpublic.be/'
app_site_be_nl: 'https://nl.clicpublic.be/'
app_site_de: 'https://de.clicpublic.be/'
app_site_en: 'https://en.clicpublic.be/'
app_site_fr: 'https://www.clicpublic.be/'
app_site_lu_de: 'https://www.clicpublic.lu/'
app_site_lu_en: 'https://en.clicpublic.lu/'
app_site_lu_fr: 'https://fr.clicpublic.lu/'
app_site_lu_nl: 'https://nl.clicpublic.lu/'
app_site_nl: 'https://nl.clicpublic.be/'
app_ssl_modules:
- { module: account }
- { module: product }
- { module: payment }
- { module: sale, action: show }
app_ssl_strict: true
app_wordline_environnement: SIMU
app_wordline_keyVersion: 1
app_wordline_merchantId: '002001000000001'
app_wordline_secretKey: 002001000000001_KEY1
mod_default_enabled: true
mod_default_view_class: sfPHP
mod_product_enabled: true
mod_product_view_class: sfPHP
mod_sale_enabled: true
mod_sale_view_class: sfPHP
sf_admin_module_web_dir: /sfDoctrinePlugin
sf_admin_web_dir: /sf/sf_admin
sf_app: frontend
sf_app_base_cache_dir: /home/clicpublic/cache/frontend
sf_app_cache_dir: /home/clicpublic/cache/frontend/dev
sf_app_config_dir: /home/clicpublic/apps/frontend/config
sf_app_dir: /home/clicpublic/apps/frontend
sf_app_i18n_dir: /home/clicpublic/apps/frontend/i18n
sf_app_lib_dir: /home/clicpublic/apps/frontend/lib
sf_app_module_dir: /home/clicpublic/apps/frontend/modules
sf_app_template_dir: /home/clicpublic/apps/frontend/templates
sf_apps_dir: /home/clicpublic/apps
sf_cache: false
sf_cache_dir: /home/clicpublic/cache
sf_charset: utf-8
sf_check_lock: false
sf_compressed: false
sf_config_cache_dir: /home/clicpublic/cache/frontend/dev/config
sf_config_dir: /home/clicpublic/config
sf_csrf_secret: ac214e61c35826766d178ea7dee31b5a8ad62336
sf_data_dir: /home/clicpublic/data
sf_debug: true
sf_default_culture: fr
sf_default_language: fr
sf_enabled_modules:
- default
- frontend_page
sf_environment: dev
sf_error_404_action: error404
sf_error_404_module: frontend_page
sf_error_reporting: 24567
sf_escaping_method: ESC_SPECIALCHARS
sf_escaping_strategy: true
sf_etag: false
sf_file_link_format: null
sf_i18n: true
sf_i18n_cache_dir: /home/clicpublic/cache/frontend/dev/i18n
sf_jquery_autocomplete: jquery.autocomplete.min.js
sf_jquery_core: jquery-1.4.2.min.js
sf_jquery_path: null
sf_jquery_plugin_paths: null
sf_jquery_ui: jquery-ui-1.7.3.custom.min.js
sf_jquery_web_dir: /sfJqueryReloadedPlugin
sf_lib_dir: /home/clicpublic/lib
sf_log_dir: /home/clicpublic/log
sf_logging_enabled: true
sf_login_action: login
sf_login_module: default
sf_module_cache_dir: /home/clicpublic/cache/frontend/dev/modules
sf_module_disabled_action: disabled
sf_module_disabled_module: default
sf_no_script_name: false
sf_orm: doctrine
sf_plugins_dir: /home/clicpublic/plugins
sf_root_dir: /home/clicpublic
sf_secure_action: secure
sf_secure_module: default
sf_standard_helpers:
- Partial
- Cache
- I18N
- Date
- Url
- My
sf_symfony_lib_dir: /home/clicpublic/lib/vendor/symfony/lib
sf_template_cache_dir: /home/clicpublic/cache/frontend/dev/template
sf_test_cache_dir: /home/clicpublic/cache/frontend/dev/test
sf_test_dir: /home/clicpublic/test
sf_upload_dir: /home/clicpublic/web/uploads
sf_use_database: true
sf_web_debug: true
sf_web_debug_web_dir: /sf/sf_web_debug
sf_web_dir: /home/clicpublic/web
solr_fields_types:
clob: text
integer: int
symfony.asset.javascripts_included: true
symfony.asset.stylesheets_included: true
cookie:
symfony: ldfsj26q1fslfmk074l0rgl9k2
env: { }
files: { }
get:
sale: '10322'
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=ldfsj26q1fslfmk074l0rgl9k2
HTTP_HOST: dev.clicpublic.be
HTTP_REFERER: 'https://dev.clicpublic.be/igw_dev.php/product/pdfCatalog?sale_id%5B%5D=10322'
HTTP_USER_AGENT: 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'
PATH: '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin'
PATH_INFO: /category
PATH_TRANSLATED: 'redirect:/index.php'
PHP_SELF: /igw_dev.php/category
QUERY_STRING: sale=10322
REMOTE_ADDR: 216.73.216.215
REMOTE_PORT: '50841'
REQUEST_METHOD: GET
REQUEST_SCHEME: https
REQUEST_TIME: 1752793053
REQUEST_TIME_FLOAT: 1752793053.3569
REQUEST_URI: '/igw_dev.php/category?sale=10322'
SCRIPT_FILENAME: /home/clicpublic/web/igw_dev.php
SCRIPT_NAME: /igw_dev.php
SERVER_ADDR: 51.68.227.109
SERVER_ADMIN: '[no address given]'
SERVER_NAME: dev.clicpublic.be
SERVER_PORT: '443'
SERVER_PROTOCOL: HTTP/1.1
SERVER_SIGNATURE: "<address>Apache/2.4.63 (Ubuntu) Server at dev.clicpublic.be Port 443</address>\n"
SERVER_SOFTWARE: 'Apache/2.4.63 (Ubuntu)'
SSL_TLS_SNI: dev.clicpublic.be
USER: www-data
proxy-nokeepalive: '1'
session:
symfony/user/sfUser/attributes: { symfony/user/sfUser/attributes: { user_country: be } }
symfony/user/sfUser/authenticated: false
symfony/user/sfUser/credentials: { }
symfony/user/sfUser/culture: fr
symfony/user/sfUser/lastRequest: 1752793052
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)'
version: 1.4.17 path: /home/clicpublic/lib/vendor/symfony/lib
Parameters:
$default_title (string)$sale_id (string)$category_id (NULL)$baseForm (BaseForm)
$baseForm['_csrf_token'] (sfWidgetFormInputHidden)
$display (integer)$tri (string)$limit (integer)$pager (sfDoctrinePager)$title (string)Parameters:
$activities (array)Parameters:
$sale_id (string)$nb_products (string)$sale (sale)$consultations (string)$auctions (string)Parameters:
$country_id (string)No parameters were passed to this template.
Parameters:
$sale (sale)Parameters:
$tri (string)$sort_key (string)$text (string)$fa (string)Parameters:
$tri (string)$sort_key (string)$text (string)$fa (string)Parameters:
$tri (string)$sort_key (string)$text (string)$fa (string)Parameters:
$tri (string)$sort_key (string)$text (string)$fa (string)Parameters:
$pager (sfDoctrinePager)$display (string)$category_id (NULL)$sale_id (string)$tri (string)$baseForm (BaseForm)
$baseForm['_csrf_token'] (sfWidgetFormInputHidden)
Parameters:
$product (product)$baseForm (BaseForm)
$baseForm['_csrf_token'] (sfWidgetFormInputHidden)
Parameters:
$product (product)$baseForm (BaseForm)
$baseForm['_csrf_token'] (sfWidgetFormInputHidden)
Parameters:
$product (product)$last_bid (bid)$last_bid_member (boolean)Parameters:
$product (product)$baseForm (BaseForm)
$baseForm['_csrf_token'] (sfWidgetFormInputHidden)
Parameters:
$product (product)$baseForm (BaseForm)
$baseForm['_csrf_token'] (sfWidgetFormInputHidden)
Parameters:
$product (product)$baseForm (BaseForm)
$baseForm['_csrf_token'] (sfWidgetFormInputHidden)
Parameters:
$product (product)$last_bid (bid)$last_bid_member (boolean)Parameters:
$product (product)$baseForm (BaseForm)
$baseForm['_csrf_token'] (sfWidgetFormInputHidden)
Parameters:
$product (product)$baseForm (BaseForm)
$baseForm['_csrf_token'] (sfWidgetFormInputHidden)
Parameters:
$product (product)$baseForm (BaseForm)
$baseForm['_csrf_token'] (sfWidgetFormInputHidden)
Parameters:
$product (product)$last_bid (bid)$last_bid_member (boolean)Parameters:
$product (product)$baseForm (BaseForm)
$baseForm['_csrf_token'] (sfWidgetFormInputHidden)
No parameters were passed to this template.
No parameters were passed to this template.
No parameters were passed to this template.
Parameters:
$form (NewSearchForm)
$form['search'] (sfWidgetFormInputText)
$form['_csrf_token'] (sfWidgetFormInputHidden)
No parameters were passed to this template.
No parameters were passed to this template.
Parameters:
$baseForm (BaseForm)
$baseForm['_csrf_token'] (sfWidgetFormInputHidden)
No parameters were passed to this template.
Parameters:
$products (Doctrine_Collection)$baseForm (BaseForm)
$baseForm['_csrf_token'] (sfWidgetFormInputHidden)
Parameters:
$product (product)$baseForm (BaseForm)
$baseForm['_csrf_token'] (sfWidgetFormInputHidden)
Parameters:
$product (product)$baseForm (BaseForm)
$baseForm['_csrf_token'] (sfWidgetFormInputHidden)
Parameters:
$product (product)$baseForm (BaseForm)
$baseForm['_csrf_token'] (sfWidgetFormInputHidden)
Parameters:
$product (product)$baseForm (BaseForm)
$baseForm['_csrf_token'] (sfWidgetFormInputHidden)
Parameters:
$product (product)$baseForm (BaseForm)
$baseForm['_csrf_token'] (sfWidgetFormInputHidden)
Parameters:
$product (product)$baseForm (BaseForm)
$baseForm['_csrf_token'] (sfWidgetFormInputHidden)
Parameters:
$product (product)$baseForm (BaseForm)
$baseForm['_csrf_token'] (sfWidgetFormInputHidden)
Parameters:
$product (product)$baseForm (BaseForm)
$baseForm['_csrf_token'] (sfWidgetFormInputHidden)
No parameters were passed to this template.
No parameters were passed to this template.
| # | 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 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.sale_id = ? AND p.enabled = 1 AND p.htva_price > 0 AND p.end_at > NOW() AND s.enabled = 1 AND s.end_at > NOW() AND ((p.isinstantsell = 1 AND p.stock_quantity_initial > p.stock_quantity_sold) OR (p.isinstantsell = 0 OR p.isinstantsell IS NULL)) GROUP BY p.id) dctrn_count_query - (fr, fr, fr, 10322) |
| 10 | 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 = ?) LIMIT 1 - (10322) |
| 11 | Doctrine_Connection_Statement | execute : SELECT s.id AS s__id, s.public_title AS s__public_title, s.public_subtitle AS s__public_subtitle, s.public_description AS s__public_description, s.description_for_product AS s__description_for_product, s.specific_condition_pdf AS s__specific_condition_pdf, s.lang AS s__lang FROM sale_translation s WHERE (s.id IN (?)) - (10322) |
| 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 | main | Call "sale->executeHeader()" |
| 17 | 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 = ? AND s.enabled = 1 AND s.end_at >= NOW()) - (10322) |
| 18 | Doctrine_Connection_Statement | execute : SELECT SUM(p.counter_view) AS p__0 FROM product p WHERE (p.enabled = 1 AND p.sale_id = ?) - (10322) |
| 19 | Doctrine_Connection_Statement | execute : SELECT COUNT(b.id) AS b__0 FROM bid b INNER JOIN product p ON b.product_id = p.id WHERE (p.enabled = 1 AND p.sale_id = ?) - (10322) |
| 20 | sfPartialView | Render "sf_app_dir/modules/sale/templates/_header.php" |
| 21 | sfPartialView | Render "sf_app_dir/modules/sale/templates/_flag.php" |
| 22 | Doctrine_Connection_Statement | execute : SELECT s.id AS s__id, s.code AS s__code, s.mandat_judiciaire AS s__mandat_judiciaire, s.create_associate_member AS s__create_associate_member, s.position AS s__position, s.enabled AS s__enabled, s.created_at AS s__created_at, s.updated_at AS s__updated_at FROM sale_type s WHERE (s.id = ?) - (1) |
| 23 | Doctrine_Connection_Statement | execute : SELECT s.id AS s__id, s.title AS s__title, s.description AS s__description, s.public_header AS s__public_header, s.lang AS s__lang, s.slug AS s__slug FROM sale_type_translation s WHERE (s.id IN (?)) - (1) |
| 24 | Doctrine_Connection_Statement | execute : SELECT m.id AS m__id, m.facebook_id AS m__facebook_id, m.company_social_reason_id AS m__company_social_reason_id, m.ref AS m__ref, m.civility AS m__civility, m.last_name AS m__last_name, m.first_name AS m__first_name, m.birthdate AS m__birthdate, m.address1 AS m__address1, m.address2 AS m__address2, m.post_code AS m__post_code, m.post_box AS m__post_box, m.city AS m__city, m.country_id AS m__country_id, m.phone_number AS m__phone_number, m.gsm_number AS m__gsm_number, m.sms_code AS m__sms_code, m.verified_mobile AS m__verified_mobile, m.mail AS m__mail, m.mail_alternate AS m__mail_alternate, m.vacancy_mail AS m__vacancy_mail, m.password AS m__password, m.new_password AS m__new_password, m.token AS m__token, m.remember_key AS m__remember_key, m.identity_number AS m__identity_number, m.national_register AS m__national_register, m.company_name AS m__company_name, m.matricule AS m__matricule, m.vat_number AS m__vat_number, m.dft_culture AS m__dft_culture, m.dft_site AS m__dft_site, m.member_type_id AS m__member_type_id, m.last_connection_at AS m__last_connection_at, m.accept_cgv_at AS m__accept_cgv_at, m.is_newsletter AS m__is_newsletter, m.enabled AS m__enabled, m.bank_nummer AS m__bank_nummer, m.bic_number AS m__bic_number, m.can_create_file AS m__can_create_file, m.account AS m__account, m.bank_nummer2 AS m__bank_nummer2, m.account2 AS m__account2, m.bank_report AS m__bank_report, m.exact_hash AS m__exact_hash, m.vies_checked_at AS m__vies_checked_at, m.created_at AS m__created_at, m.updated_at AS m__updated_at FROM member m WHERE (m.id = ?) - (51) |
| 25 | sfPartialView | Render "sf_app_dir/modules/sale/templates/_timer_js.php" |
| 26 | Doctrine_Connection_Mysql | query : SELECT COUNT(*) AS num_results FROM sale_visit s WHERE s.sale_id = 10322 - () |
| 27 | Doctrine_Connection_Mysql | query : SELECT COUNT(*) AS num_results FROM sale_visit s WHERE s.sale_id = 10322 - () |
| 28 | Doctrine_Connection_Mysql | query : SELECT COUNT(*) AS num_results FROM sale_visit s WHERE s.sale_id = 10322 - () |
| 29 | Doctrine_Connection_Statement | execute : SELECT s.id AS s__id, s.code AS s__code, s.name AS s__name, s.address1 AS s__address1, s.address2 AS s__address2, s.post_code AS s__post_code, s.post_box AS s__post_box, s.city AS s__city, s.country_id AS s__country_id, s.position AS s__position, s.enabled AS s__enabled, s.is_internal AS s__is_internal, s.sale_id AS s__sale_id, s.created_at AS s__created_at, s.updated_at AS s__updated_at FROM stock s WHERE (s.id = ?) - (338) |
| 30 | 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) |
| 31 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.name AS c__name, c.lang AS c__lang FROM country_translation c WHERE (c.id IN (?)) - (20) |
| 32 | sfPartialView | Render "sf_app_dir/modules/sale/templates/_map.php" |
| 33 | 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 = ?) LIMIT 1 - (10321) |
| 34 | sfPartialView | Render "sf_app_dir/modules/product/templates/_sort.php" |
| 35 | sfPartialView | Render "sf_app_dir/modules/product/templates/_sort.php" |
| 36 | sfPartialView | Render "sf_app_dir/modules/product/templates/_sort.php" |
| 37 | sfPartialView | Render "sf_app_dir/modules/product/templates/_sort.php" |
| 38 | sfPartialView | Render "sf_app_dir/modules/product/templates/_pager.php" |
| 39 | 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.sale_id = ? AND p5.enabled = 1 AND p5.htva_price > 0 AND p5.end_at > NOW() AND s2.enabled = 1 AND s2.end_at > NOW() AND ((p5.isinstantsell = 1 AND p5.stock_quantity_initial > p5.stock_quantity_sold) OR (p5.isinstantsell = 0 OR p5.isinstantsell IS NULL)) GROUP BY p5.id ORDER BY p5__8 DESC, p5.position ASC, GREATEST(p5.end_at, s2.end_at) ASC, p5.created_at ASC, p5.id ASC LIMIT 50 - (fr, fr, fr, 10322) |
| 40 | 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 ('198462', '198463', '198460') AND (p.sale_id = ? AND p.enabled = 1 AND p.htva_price > 0 AND p.end_at > NOW() AND s.enabled = 1 AND s.end_at > NOW() AND ((p.isinstantsell = 1 AND p.stock_quantity_initial > p.stock_quantity_sold) OR (p.isinstantsell = 0 OR p.isinstantsell IS NULL))) GROUP BY p.id ORDER BY p__8 DESC, p.position ASC, GREATEST(p.end_at, s.end_at) ASC, p.created_at ASC, p.id ASC - (fr, fr, fr, 10322) |
| 41 | sfPartialView | Render "sf_app_dir/modules/default/templates/_product_row.php" |
| 42 | 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 - (198462) |
| 43 | 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 - (198462) |
| 44 | 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 = ?) - (10322) |
| 45 | 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) |
| 46 | sfPartialView | Render "sf_app_dir/modules/product/templates/_counter.php" |
| 47 | 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) |
| 48 | sfPartialView | Render "sf_app_dir/modules/product/templates/_message_bid.php" |
| 49 | main | Set slot "isNotBestBidder" |
| 50 | sfPartialView | Render "sf_app_dir/modules/default/templates/_script-js-follow.js.php" |
| 51 | sfPartialView | Render "sf_app_dir/modules/default/templates/_product_row.php" |
| 52 | 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 - (198463) |
| 53 | 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 - (198463) |
| 54 | 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 = ?) - (10322) |
| 55 | sfPartialView | Render "sf_app_dir/modules/product/templates/_counter.php" |
| 56 | 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) |
| 57 | sfPartialView | Render "sf_app_dir/modules/product/templates/_message_bid.php" |
| 58 | main | Set slot "isNotBestBidder" |
| 59 | sfPartialView | Render "sf_app_dir/modules/default/templates/_script-js-follow.js.php" |
| 60 | sfPartialView | Render "sf_app_dir/modules/default/templates/_product_row.php" |
| 61 | 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 - (198460) |
| 62 | 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 - (198460) |
| 63 | 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 = ?) - (10322) |
| 64 | sfPartialView | Render "sf_app_dir/modules/product/templates/_counter.php" |
| 65 | 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) |
| 66 | sfPartialView | Render "sf_app_dir/modules/product/templates/_message_bid.php" |
| 67 | main | Set slot "isNotBestBidder" |
| 68 | sfPartialView | Render "sf_app_dir/modules/default/templates/_script-js-follow.js.php" |
| 69 | sfPHPView | Decorate content with "sf_app_dir/templates/layout.php" |
| 70 | sfPHPView | Render "sf_app_dir/templates/layout.php" |
| 71 | sfPartialView | Render "sf_app_dir/modules/default/templates/_analytics.php" |
| 72 | sfPartialView | Render "sf_app_dir/modules/default/templates/_header.php" |
| 73 | 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) |
| 74 | sfPartialView | Render "sf_app_dir/modules/default/templates/_navigation.php" |
| 75 | main | Call "default->executeSearch()" |
| 76 | sfPartialView | Render "sf_app_dir/modules/default/templates/_search.php" |
| 77 | sfPartialView | Render "sf_app_dir/modules/default/templates/_member_menu.php" |
| 78 | sfPartialView | Render "sf_app_dir/modules/default/templates/_sub_footer.php" |
| 79 | main | Call "default->executeWidget_newsletter()" |
| 80 | sfPartialView | Render "sf_app_dir/modules/default/templates/_widget_newsletter.php" |
| 81 | sfPartialView | Render "sf_app_dir/modules/default/templates/_widget_beginnow.php" |
| 82 | main | Call "default->executeWidget_selection()" |
| 83 | 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) |
| 84 | 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 ('193131', '198111', '196917', '198113') 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) |
| 85 | sfPartialView | Render "sf_app_dir/modules/default/templates/_widget_selection.php" |
| 86 | 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) |
| 87 | sfPartialView | Render "sf_app_dir/modules/product/templates/_counter.php" |
| 88 | sfPartialView | Render "sf_app_dir/modules/default/templates/_script-js-follow.js.php" |
| 89 | 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) |
| 90 | sfPartialView | Render "sf_app_dir/modules/product/templates/_counter.php" |
| 91 | sfPartialView | Render "sf_app_dir/modules/default/templates/_script-js-follow.js.php" |
| 92 | 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) |
| 93 | sfPartialView | Render "sf_app_dir/modules/product/templates/_counter.php" |
| 94 | sfPartialView | Render "sf_app_dir/modules/default/templates/_script-js-follow.js.php" |
| 95 | 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) |
| 96 | sfPartialView | Render "sf_app_dir/modules/product/templates/_counter.php" |
| 97 | sfPartialView | Render "sf_app_dir/modules/default/templates/_script-js-follow.js.php" |
| 98 | sfPartialView | Render "sf_app_dir/modules/default/templates/_footer.php" |
| 99 | 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) |
| 100 | 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) |
| 101 | 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) |
| 102 | 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) |
| 103 | sfPartialView | Render "sf_app_dir/modules/default/templates/_robot.php" |
| 104 | sfWebResponse | Send status "HTTP/1.1 200 OK" |
| 105 | sfWebResponse | Send header "Content-Type: text/html; charset=utf-8" |
| type | calls | time (ms) | time (%) |
|---|---|---|---|
| Configuration | 22 | 419.37 | 59 |
| Factories | 1 | 19.42 | 2 |
| Action "product/all" | 1 | 447.43 | 63 |
| Database (Doctrine) | 44 | 0.03 | 0 |
| View "Success" for "product/all" | 1 | 220.76 | 31 |
| Component "default/widget_category" | 1 | 9.17 | 1 |
| Partial "default/_widget_category" | 1 | 4.30 | 0 |
| Component "sale/header" | 1 | 5.81 | 0 |
| Partial "sale/_header" | 1 | 28.92 | 4 |
| Partial "sale/_flag" | 1 | 0.10 | 0 |
| Partial "sale/_timer_js" | 1 | 0.14 | 0 |
| Partial "sale/_map" | 1 | 0.40 | 0 |
| Partial "product/_sort" | 4 | 0.38 | 0 |
| Partial "product/_pager" | 1 | 60.23 | 8 |
| Partial "default/_product_row" | 3 | 47.38 | 6 |
| Partial "product/_counter" | 7 | 4.40 | 0 |
| Partial "product/_message_bid" | 3 | 0.94 | 0 |
| Partial "default/_script-js-follow.js" | 7 | 2.10 | 0 |
| Partial "default/_analytics" | 1 | 0.28 | 0 |
| Partial "default/_header" | 1 | 3.33 | 0 |
| Partial "default/_navigation" | 1 | 3.11 | 0 |
| Component "default/search" | 1 | 0.40 | 0 |
| Partial "default/_search" | 1 | 0.33 | 0 |
| Partial "default/_member_menu" | 1 | 0.20 | 0 |
| Partial "default/_sub_footer" | 1 | 86.68 | 12 |
| Component "default/widget_newsletter" | 1 | 0.16 | 0 |
| Partial "default/_widget_newsletter" | 1 | 0.26 | 0 |
| Partial "default/_widget_beginnow" | 1 | 0.76 | 0 |
| Component "default/widget_selection" | 1 | 72.18 | 10 |
| Partial "default/_widget_selection" | 1 | 11.01 | 1 |
| Partial "default/_footer" | 1 | 13.89 | 1 |
| Partial "default/_robot" | 1 | 0.09 | 0 |
SET NAMES 'UTF8'
SELECT COUNT(*) AS num_results FROM (SELECT p.id FROM product p LEFT JOIN product_translation p2 ON p.id = p2.id AND (p2.lang = 'fr') LEFT JOIN category c ON p.category_id = c.id LEFT JOIN category_translation c2 ON c.id = c2.id AND (c2.lang = 'fr') LEFT JOIN product_type p3 ON p.product_type_id = p3.id LEFT JOIN product_type_translation p4 ON p3.id = p4.id AND (p4.lang = 'fr') INNER JOIN sale s ON p.sale_id = s.id LEFT JOIN bid b ON p.id = b.product_id WHERE p.sale_id = '10322' AND p.enabled = 1 AND p.htva_price > 0 AND p.end_at > NOW() AND s.enabled = 1 AND s.end_at > NOW() AND ((p.isinstantsell = 1 AND p.stock_quantity_initial > p.stock_quantity_sold) OR (p.isinstantsell = 0 OR p.isinstantsell IS NULL)) GROUP BY p.id) dctrn_count_query
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 = '10322') LIMIT 1
SELECT s.id AS s__id, s.public_title AS s__public_title, s.public_subtitle AS s__public_subtitle, s.public_description AS s__public_description, s.description_for_product AS s__description_for_product, s.specific_condition_pdf AS s__specific_condition_pdf, s.lang AS s__lang FROM sale_translation s WHERE (s.id IN ('10322'))
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')
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 = '10322' AND s.enabled = 1 AND s.end_at >= NOW())
SELECT SUM(p.counter_view) AS p__0 FROM product p WHERE (p.enabled = 1 AND p.sale_id = '10322')
SELECT COUNT(b.id) AS b__0 FROM bid b INNER JOIN product p ON b.product_id = p.id WHERE (p.enabled = 1 AND p.sale_id = '10322')
SELECT s.id AS s__id, s.code AS s__code, s.mandat_judiciaire AS s__mandat_judiciaire, s.create_associate_member AS s__create_associate_member, s.position AS s__position, s.enabled AS s__enabled, s.created_at AS s__created_at, s.updated_at AS s__updated_at FROM sale_type s WHERE (s.id = '1')
SELECT s.id AS s__id, s.title AS s__title, s.description AS s__description, s.public_header AS s__public_header, s.lang AS s__lang, s.slug AS s__slug FROM sale_type_translation s WHERE (s.id IN ('1'))
SELECT m.id AS m__id, m.facebook_id AS m__facebook_id, m.company_social_reason_id AS m__company_social_reason_id, m.ref AS m__ref, m.civility AS m__civility, m.last_name AS m__last_name, m.first_name AS m__first_name, m.birthdate AS m__birthdate, m.address1 AS m__address1, m.address2 AS m__address2, m.post_code AS m__post_code, m.post_box AS m__post_box, m.city AS m__city, m.country_id AS m__country_id, m.phone_number AS m__phone_number, m.gsm_number AS m__gsm_number, m.sms_code AS m__sms_code, m.verified_mobile AS m__verified_mobile, m.mail AS m__mail, m.mail_alternate AS m__mail_alternate, m.vacancy_mail AS m__vacancy_mail, m.password AS m__password, m.new_password AS m__new_password, m.token AS m__token, m.remember_key AS m__remember_key, m.identity_number AS m__identity_number, m.national_register AS m__national_register, m.company_name AS m__company_name, m.matricule AS m__matricule, m.vat_number AS m__vat_number, m.dft_culture AS m__dft_culture, m.dft_site AS m__dft_site, m.member_type_id AS m__member_type_id, m.last_connection_at AS m__last_connection_at, m.accept_cgv_at AS m__accept_cgv_at, m.is_newsletter AS m__is_newsletter, m.enabled AS m__enabled, m.bank_nummer AS m__bank_nummer, m.bic_number AS m__bic_number, m.can_create_file AS m__can_create_file, m.account AS m__account, m.bank_nummer2 AS m__bank_nummer2, m.account2 AS m__account2, m.bank_report AS m__bank_report, m.exact_hash AS m__exact_hash, m.vies_checked_at AS m__vies_checked_at, m.created_at AS m__created_at, m.updated_at AS m__updated_at FROM member m WHERE (m.id = '51')
SELECT COUNT(*) AS num_results FROM sale_visit s WHERE s.sale_id = 10322
SELECT COUNT(*) AS num_results FROM sale_visit s WHERE s.sale_id = 10322
SELECT COUNT(*) AS num_results FROM sale_visit s WHERE s.sale_id = 10322
SELECT s.id AS s__id, s.code AS s__code, s.name AS s__name, s.address1 AS s__address1, s.address2 AS s__address2, s.post_code AS s__post_code, s.post_box AS s__post_box, s.city AS s__city, s.country_id AS s__country_id, s.position AS s__position, s.enabled AS s__enabled, s.is_internal AS s__is_internal, s.sale_id AS s__sale_id, s.created_at AS s__created_at, s.updated_at AS s__updated_at FROM stock s WHERE (s.id = '338')
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')
SELECT c.id AS c__id, c.name AS c__name, c.lang AS c__lang FROM country_translation c WHERE (c.id IN ('20'))
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 = '10321') LIMIT 1
SELECT DISTINCT p5.id, if(p5.isinstantsell, -1, COUNT(b2.product_id)) AS p5__8 FROM product p5 LEFT JOIN product_translation p6 ON p5.id = p6.id AND (p6.lang = 'fr') LEFT JOIN category c3 ON p5.category_id = c3.id LEFT JOIN category_translation c4 ON c3.id = c4.id AND (c4.lang = 'fr') LEFT JOIN product_type p7 ON p5.product_type_id = p7.id LEFT JOIN product_type_translation p8 ON p7.id = p8.id AND (p8.lang = 'fr') INNER JOIN sale s2 ON p5.sale_id = s2.id LEFT JOIN bid b2 ON p5.id = b2.product_id WHERE p5.sale_id = '10322' AND p5.enabled = 1 AND p5.htva_price > 0 AND p5.end_at > NOW() AND s2.enabled = 1 AND s2.end_at > NOW() AND ((p5.isinstantsell = 1 AND p5.stock_quantity_initial > p5.stock_quantity_sold) OR (p5.isinstantsell = 0 OR p5.isinstantsell IS NULL)) GROUP BY p5.id ORDER BY p5__8 DESC, p5.position ASC, GREATEST(p5.end_at, s2.end_at) ASC, p5.created_at ASC, p5.id ASC LIMIT 50
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 ('198462', '198463', '198460') AND (p.sale_id = '10322' AND p.enabled = 1 AND p.htva_price > 0 AND p.end_at > NOW() AND s.enabled = 1 AND s.end_at > NOW() AND ((p.isinstantsell = 1 AND p.stock_quantity_initial > p.stock_quantity_sold) OR (p.isinstantsell = 0 OR p.isinstantsell IS NULL))) GROUP BY p.id ORDER BY p__8 DESC, p.position ASC, GREATEST(p.end_at, s.end_at) ASC, p.created_at ASC, p.id ASC
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 = '198462') ORDER BY b.created_at DESC, b.id DESC
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 = '198462') ORDER BY i__0 ASC
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 = '10322')
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')
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')
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 = '198463') ORDER BY b.created_at DESC, b.id DESC
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 = '198463') ORDER BY i__0 ASC
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 = '10322')
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')
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 = '198460') ORDER BY b.created_at DESC, b.id DESC
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 = '198460') ORDER BY i__0 ASC
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 = '10322')
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')
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
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
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 ('193131', '198111', '196917', '198113') 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
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')
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')
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')
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')
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')
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')
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')
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')