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
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: contact module: default product_id: '190116' 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: { } 'https://www.google.com/recaptcha/api.js?hl=fr': { } 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=1745903195': { } metas: title: 'Contactez-nous - 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: { user_country: be } symfony/user/sfUser/flash: { error: 'Vous devez être connecté pour effectuer une demande de rendez-vous !' } symfony/user/sfUser/flash/remove: { } culture: fr authenticated: null credentials: { } lastRequest: 1745957870
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 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: 80g29ok25a3nb0bmeppbhr0fss env: { } files: { } get: product_id: '190116' 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=80g29ok25a3nb0bmeppbhr0fss HTTP_HOST: dev.clicpublic.be HTTP_USER_AGENT: 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' PATH: '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin' PATH_INFO: /contact PATH_TRANSLATED: 'redirect:/index.php' PHP_SELF: /igw_dev.php/contact QUERY_STRING: product_id=190116 REMOTE_ADDR: 18.116.61.213 REMOTE_PORT: '47602' REQUEST_METHOD: GET REQUEST_SCHEME: https REQUEST_TIME: 1745957869 REQUEST_TIME_FLOAT: 1745957869.561 REQUEST_URI: '/igw_dev.php/contact?product_id=190116' 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/flash: { error: 'Vous devez être connecté pour effectuer une demande de rendez-vous !' }, symfony/user/sfUser/flash/remove: { } } symfony/user/sfUser/authenticated: false symfony/user/sfUser/credentials: { } symfony/user/sfUser/culture: fr symfony/user/sfUser/lastRequest: 1745957870
php: 7.4.33 os: 'Linux vps645206 5.4.0-208-generic #228-Ubuntu SMP Fri Feb 7 19:41:33 UTC 2025 x86_64' extensions: 17: 'bz2 (7.4.33)' 18: 'calendar (7.4.33)' 13: 'cgi-fcgi (7.4.33)' 0: 'Core (7.4.33)' 19: 'ctype (7.4.33)' 20: 'curl (7.4.33)' 1: 'date (7.4.33)' 21: 'dom (20031129)' 33: 'exif (7.4.33)' 23: 'FFI (7.4.33)' 24: 'fileinfo (7.4.33)' 6: 'filter (7.4.33)' 25: 'ftp (7.4.33)' 26: 'gd (7.4.33)' 27: 'gettext (7.4.33)' 7: 'hash (7.4.33)' 28: 'iconv (7.4.33)' 29: 'imagick (3.8.0)' 30: 'imap (7.4.33)' 31: 'intl (7.4.33)' 32: 'json (7.4.33)' 2: 'libxml (7.4.33)' 22: 'mbstring (7.4.33)' 34: 'mysqli (7.4.33)' 14: 'mysqlnd (mysqlnd 7.4.33)' 3: 'openssl (7.4.33)' 4: 'pcre (7.4.33)' 15: 'PDO (7.4.33)' 35: 'pdo_mysql (7.4.33)' 36: 'Phar (7.4.33)' 37: 'posix (7.4.33)' 38: 'readline (7.4.33)' 8: 'Reflection (7.4.33)' 10: 'session (7.4.33)' 39: 'shmop (7.4.33)' 40: 'SimpleXML (7.4.33)' 41: 'soap (7.4.33)' 42: 'sockets (7.4.33)' 12: 'sodium (7.4.33)' 9: 'SPL (7.4.33)' 11: 'standard (7.4.33)' 43: 'sysvmsg (7.4.33)' 44: 'sysvsem (7.4.33)' 45: 'sysvshm (7.4.33)' 46: 'tokenizer (7.4.33)' 16: 'xml (7.4.33)' 47: 'xmlreader (7.4.33)' 48: 'xmlrpc (7.4.33)' 49: 'xmlwriter (7.4.33)' 50: 'xsl (7.4.33)' 52: 'Zend OPcache (7.4.33)' 51: 'zip (1.15.6)' 5: 'zlib (7.4.33)'
version: 1.4.17 path: /home/clicpublic/lib/vendor/symfony/lib
Parameters:
$default_title
(string)$visit
(boolean)$form
(ContactForm)
$form['lastname']
(sfWidgetFormInputText)
$form['firstname']
(sfWidgetFormInputText)
$form['email']
(sfWidgetFormInputText)
$form['phone']
(sfWidgetFormInputText)
$form['subject']
(sfWidgetFormInputText)
$form['message']
(sfWidgetFormTextarea)
$form['_csrf_token']
(sfWidgetFormInputHidden)
$pagecontact
(Page)$title
(string)No parameters were passed to this template.
No parameters were passed to this template.
No parameters were passed to this template.
No parameters were passed to this template.
Parameters:
No parameters were passed to this template.
No parameters were passed to this template.
No parameters were passed to this template.
Parameters:
Parameters:
Parameters:
Parameters:
Parameters:
Parameters:
Parameters:
Parameters:
Parameters:
No parameters were passed to this template.
No parameters were passed to this template.
# | type | message |
---|---|---|
1 | ![]() | Match route "contact" (/contact) for /contact with parameters array ( 'module' => 'default', 'action' => 'contact',) |
2 | ![]() | Flag old flash messages ("error") |
3 | ![]() | Executing filter "sfRenderingFilter" |
4 | ![]() | Executing filter "sslFilter" |
5 | ![]() | Executing filter "domainCultureFilter" |
6 | ![]() | Executing filter "checkMobileFilter" |
7 | ![]() | Executing filter "sfExecutionFilter" |
8 | ![]() | Call "defaultActions->executeContact()" |
9 | ![]() | exec : SET NAMES 'UTF8' - () |
10 | ![]() | 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 = ?) - (CONTACT) |
11 | ![]() | execute : SELECT p.id AS p__id, p.page_id AS p__page_id, p.code AS p__code, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p2.id AS p2__id, p2.value AS p2__value, p2.lang AS p2__lang FROM page_attribute p LEFT JOIN page_attribute_translation p2 ON p.id = p2.id WHERE (p.page_id = ? AND p.code = ?) - (2, T1) |
12 | ![]() | 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, 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.title AS c2__3, c2.slug AS c2__4, 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, s.id AS s__id, s2.id AS s2__id, s2.lang AS s2__lang, s2.public_title AS s2__7, p2.title AS p2__0, p2.description AS p2__1, p2.short_description AS p2__2, c2.title AS c2__3, c2.slug AS c2__4, c2.slug AS c2__5, p4.title AS p4__6, s2.public_title AS s2__7, (SELECT COUNT(b.id) AS b__0 FROM bid b WHERE (b.product_id = p.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 sale_translation s2 ON s.id = s2.id AND (s2.lang = ?), product p5 INNER JOIN sale s3 ON p5.sale_id = s3.id WHERE (p.id = ? AND p.htva_price > 0 AND p.enabled = ? AND p5.enabled = 1 AND p5.htva_price > 0 AND p5.end_at > NOW() AND s3.enabled = 1 AND s3.end_at > NOW()) - (fr, fr, fr, fr, 190116, 1) |
13 | ![]() | 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.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 - (9720) |
14 | ![]() | query : SELECT COUNT(*) AS num_results FROM sale_visit s WHERE s.sale_id = 9720 - () |
15 | ![]() | query : SELECT COUNT(*) AS num_results FROM sale_visit s WHERE s.sale_id = 9720 - () |
16 | ![]() | Render "sf_app_dir/modules/default/templates/contactSuccess.php" |
17 | ![]() | Render "sf_app_dir/modules/default/templates/_message_flash.php" |
18 | ![]() | Decorate content with "sf_app_dir/templates/layout.php" |
19 | ![]() | Render "sf_app_dir/templates/layout.php" |
20 | ![]() | Render "sf_app_dir/modules/default/templates/_analytics.php" |
21 | ![]() | Render "sf_app_dir/modules/default/templates/_header.php" |
22 | ![]() | 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) |
23 | ![]() | Render "sf_app_dir/modules/default/templates/_navigation.php" |
24 | ![]() | Call "default->executeSearch()" |
25 | ![]() | Render "sf_app_dir/modules/default/templates/_search.php" |
26 | ![]() | Render "sf_app_dir/modules/default/templates/_member_menu.php" |
27 | ![]() | Render "sf_app_dir/modules/default/templates/_sub_footer.php" |
28 | ![]() | Call "default->executeWidget_newsletter()" |
29 | ![]() | Render "sf_app_dir/modules/default/templates/_widget_newsletter.php" |
30 | ![]() | Render "sf_app_dir/modules/default/templates/_widget_beginnow.php" |
31 | ![]() | Call "default->executeWidget_selection()" |
32 | ![]() | 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) |
33 | ![]() | 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.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 ('190292', '191359', '190312', '190323') 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) |
34 | ![]() | Render "sf_app_dir/modules/default/templates/_widget_selection.php" |
35 | ![]() | 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) |
36 | ![]() | Render "sf_app_dir/modules/product/templates/_counter.php" |
37 | ![]() | Render "sf_app_dir/modules/default/templates/_script-js-follow.js.php" |
38 | ![]() | 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) |
39 | ![]() | Render "sf_app_dir/modules/product/templates/_counter.php" |
40 | ![]() | Render "sf_app_dir/modules/default/templates/_script-js-follow.js.php" |
41 | ![]() | 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) |
42 | ![]() | Render "sf_app_dir/modules/product/templates/_counter.php" |
43 | ![]() | Render "sf_app_dir/modules/default/templates/_script-js-follow.js.php" |
44 | ![]() | Render "sf_app_dir/modules/product/templates/_counter.php" |
45 | ![]() | Render "sf_app_dir/modules/default/templates/_script-js-follow.js.php" |
46 | ![]() | Render "sf_app_dir/modules/default/templates/_footer.php" |
47 | ![]() | 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) |
48 | ![]() | 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) |
49 | ![]() | 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) |
50 | ![]() | Render "sf_app_dir/modules/default/templates/_robot.php" |
51 | ![]() | Send status "HTTP/1.1 200 OK" |
52 | ![]() | Send header "Content-Type: text/html; charset=utf-8" |
type | calls | time (ms) | time (%) |
---|---|---|---|
Configuration | 18 | 577.64 | 33 |
Factories | 1 | 792.78 | 46 |
Action "default/contact" | 1 | 394.41 | 23 |
Database (Doctrine) | 16 | 0.01 | 0 |
View "Success" for "default/contact" | 1 | 85.16 | 4 |
Partial "default/_message_flash" | 1 | 0.13 | 0 |
Partial "default/_analytics" | 1 | 0.05 | 0 |
Partial "default/_header" | 1 | 1.33 | 0 |
Partial "default/_navigation" | 1 | 0.95 | 0 |
Component "default/search" | 1 | 0.14 | 0 |
Partial "default/_search" | 1 | 0.11 | 0 |
Partial "default/_member_menu" | 1 | 0.05 | 0 |
Partial "default/_sub_footer" | 1 | 62.67 | 3 |
Component "default/widget_newsletter" | 1 | 0.04 | 0 |
Partial "default/_widget_newsletter" | 1 | 0.09 | 0 |
Partial "default/_widget_beginnow" | 1 | 0.08 | 0 |
Component "default/widget_selection" | 1 | 33.78 | 1 |
Partial "default/_widget_selection" | 1 | 28.00 | 1 |
Partial "product/_counter" | 4 | 1.66 | 0 |
Partial "default/_script-js-follow.js" | 4 | 0.62 | 0 |
Partial "default/_footer" | 1 | 18.23 | 1 |
Partial "default/_robot" | 1 | 0.13 | 0 |
SET NAMES 'UTF8'
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 = 'CONTACT')
SELECT p.id AS p__id, p.page_id AS p__page_id, p.code AS p__code, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p2.id AS p2__id, p2.value AS p2__value, p2.lang AS p2__lang FROM page_attribute p LEFT JOIN page_attribute_translation p2 ON p.id = p2.id WHERE (p.page_id = '2' AND p.code = 'T1')
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, 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.title AS c2__3, c2.slug AS c2__4, 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, s.id AS s__id, s2.id AS s2__id, s2.lang AS s2__lang, s2.public_title AS s2__7, p2.title AS p2__0, p2.description AS p2__1, p2.short_description AS p2__2, c2.title AS c2__3, c2.slug AS c2__4, c2.slug AS c2__5, p4.title AS p4__6, s2.public_title AS s2__7, (SELECT COUNT(b.id) AS b__0 FROM bid b WHERE (b.product_id = p.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 sale_translation s2 ON s.id = s2.id AND (s2.lang = 'fr'), product p5 INNER JOIN sale s3 ON p5.sale_id = s3.id WHERE (p.id = '190116' AND p.htva_price > 0 AND p.enabled = '1' AND p5.enabled = 1 AND p5.htva_price > 0 AND p5.end_at > NOW() AND s3.enabled = 1 AND s3.end_at > NOW())
SELECT s.id AS s__id, s.ref AS s__ref, s.sale_mother_id AS s__sale_mother_id, s.image AS s__image, s.banner AS s__banner, s.banner_new AS s__banner_new, s.judge_id AS s__judge_id, s.curator_id AS s__curator_id, s.associate_member_id AS s__associate_member_id, s.sale_type_id AS s__sale_type_id, s.last_invoice_id AS s__last_invoice_id, s.commercial_court AS s__commercial_court, s.begin_at AS s__begin_at, s.first_end_at AS s__first_end_at, s.end_at AS s__end_at, s.company_name AS s__company_name, s.address1 AS s__address1, s.address2 AS s__address2, s.post_code AS s__post_code, s.city AS s__city, s.social_reason AS s__social_reason, s.company_social_reason_id AS s__company_social_reason_id, s.matricule AS s__matricule, s.vat_number AS s__vat_number, s.country_id AS s__country_id, s.owner_description AS s__owner_description, s.activity_domain AS s__activity_domain, s.mission_description AS s__mission_description, s.enabled AS s__enabled, s.category_id AS s__category_id, s.mission_end AS s__mission_end, s.inventory_at AS s__inventory_at, s.validated_contract_at AS s__validated_contract_at, s.implementated_at AS s__implementated_at, s.sfguarduser_id AS s__sfguarduser_id, s.stock_id AS s__stock_id, s.tva AS s__tva, s.vat_rate_id AS s__vat_rate_id, s.commission AS s__commission, s.tva_commission AS s__tva_commission, s.vat_rate_commission_id AS s__vat_rate_commission_id, s.vendor_commission AS s__vendor_commission, s.account_to_receive AS s__account_to_receive, s.account_received AS s__account_received, s.vat_only AS s__vat_only, s.visit_pad AS s__visit_pad, s.visited_at AS s__visited_at, s.visit_closed AS s__visit_closed, s.visited_at_day AS s__visited_at_day, s.delivery_at AS s__delivery_at, s.delivery_at_day AS s__delivery_at_day, s.delivery_planned AS s__delivery_planned, s.delivery_temporary_planification AS s__delivery_temporary_planification, s.external_invoice AS s__external_invoice, s.type_external_invoice AS s__type_external_invoice, s.type_commission AS s__type_commission, s.sell_mode AS s__sell_mode, s.last_invoice_number AS s__last_invoice_number, s.invoice_prefix AS s__invoice_prefix, s.last_credit_note AS s__last_credit_note, s.last_proforma AS s__last_proforma, s.bank_nummer AS s__bank_nummer, s.bic_number AS s__bic_number, s.account AS s__account, s.bank_nummer2 AS s__bank_nummer2, s.bic_number2 AS s__bic_number2, s.account2 AS s__account2, s.bank_nummer3 AS s__bank_nummer3, s.bic_number3 AS s__bic_number3, s.account3 AS s__account3, s.ogone_enabled AS s__ogone_enabled, s.choice_stock AS s__choice_stock, s.view_counter AS s__view_counter, s.cpt AS s__cpt, s.cpt_nc AS s__cpt_nc, s.cpt_pf AS s__cpt_pf, s.info_additional_invoice AS s__info_additional_invoice, s.fund_to_be_transferred AS s__fund_to_be_transferred, s.fund_to_be_transferred_bank AS s__fund_to_be_transferred_bank, s.fund_transferred AS s__fund_transferred, s.is_stock_in_trade AS s__is_stock_in_trade, s.is_stock_in_trade_url AS s__is_stock_in_trade_url, s.sale_status_id AS s__sale_status_id, s.position AS s__position, s.limit_at AS s__limit_at, s.locked_by AS s__locked_by, s.locked_until AS s__locked_until, s.global AS s__global, s.global_only AS s__global_only, s.manager_id AS s__manager_id, s.leader_id AS s__leader_id, s.could_be_closed AS s__could_be_closed, s.soon_available AS s__soon_available, s.key_status_id AS s__key_status_id, s.key_position AS s__key_position, s.sepa_communication_type AS s__sepa_communication_type, s.created_at AS s__created_at, s.updated_at AS s__updated_at FROM sale s WHERE (s.id = '9720') LIMIT 1
SELECT COUNT(*) AS num_results FROM sale_visit s WHERE s.sale_id = 9720
SELECT COUNT(*) AS num_results FROM sale_visit s WHERE s.sale_id = 9720
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.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 ('190292', '191359', '190312', '190323') 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 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')