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, rss: application/rss+xml }
  no_script_name: false
parameterHolder:
  action: index
  environment: '556'
  family: '208'
  module: additive
  sf_culture: fr
  sf_format: html
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'
  X-Frame-Options: SAMEORIGIN
  X-Xss-Protection: 1
javascripts: {  }
stylesheets:
  'https://fonts.googleapis.com/css?family=Open+Sans:300,300i,400,400i,600,600i,700,700i': {  }
  /fontawesome6/css/all.min.css: {  }
metas:
  language: en_GB
  title: 'Commercial additives - RoadMat'
  robots: 'index, follow'
httpMetas:
  Content-Type: 'text/html; charset=utf-8'

options:
  auto_shutdown: false
  culture: fr
  default_culture: fr
  timezone: null
  default_timezone: Europe/Paris
  use_flash: true
  logging: '1'
  timeout: 28800
attributeHolder:
  symfony/user/sfUser/attributes: { culture: true }
culture: en_GB

app_cache_time: '1770359527'
app_css_bootstrap: 'https://cdn.jsdelivr.net/npm/bootstrap@4/dist/css/bootstrap.min.css'
app_css_bootstrap-datepicker: 'https://cdn.jsdelivr.net/npm/bootstrap-datepicker@1.9/dist/css/bootstrap-datepicker.min.css'
app_css_bootstrap4: 'https://cdn.jsdelivr.net/npm/bootstrap@4/dist/css/bootstrap.min.css'
app_css_bs5: 'https://cdn.jsdelivr.net/npm/bootstrap@4/dist/css/bootstrap.min.css'
app_css_ckeditor: false
app_css_fontawesome6: /fontawesome6/css/all.min.css
app_css_leaflet: 'https://cdn.jsdelivr.net/npm/leaflet@1/dist/leaflet.min.css'
app_css_toolkit: false
app_fa_facebook: square-facebook
app_fa_instagram: square-instagram
app_fa_twitter: square-x-twitter
app_flash_error_icon: fa-exclamation-triangle
app_flash_error_title: Erreur
app_flash_notice_icon: fa-info-circle
app_flash_notice_title: Attention
app_flash_success_icon: fa-check-circle
app_flash_success_title: 'Opération réussie'
app_flash_warning_icon: fa-exclamation-triangle
app_flash_warning_title: Attention
app_js_bootstrap: 'https://cdn.jsdelivr.net/npm/bootstrap@4/dist/js/bootstrap.bundle.min.js'
app_js_bootstrap-datepicker:
  - 'https://cdn.jsdelivr.net/npm/bootstrap-datepicker@1/dist/js/bootstrap-datepicker.min.js'
  - 'https://cdn.jsdelivr.net/npm/bootstrap-datepicker@1/dist/locales/bootstrap-datepicker.fr.min.js'
app_js_bootstrap4: 'https://cdn.jsdelivr.net/npm/bootstrap@4/dist/js/bootstrap.bundle.min.js'
app_js_bs-custom-file-input: 'https://cdn.jsdelivr.net/npm/bs-custom-file-input@1/dist/bs-custom-file-input.min.js'
app_js_bs5: 'https://cdn.jsdelivr.net/npm/bootstrap@5/dist/js/bootstrap.bundle.min.js'
app_js_ckeditor: /ckeditor/ckeditor.js
app_js_cookie: 'https://cdn.jsdelivr.net/npm/js-cookie@2/src/js.cookie.js'
app_js_decode: /toolkit/js/decode.js
app_js_fontawesome6: /fontawesome6/js/all.min.js
app_js_jquery: false
app_js_jquery-slim: 'https://cdn.jsdelivr.net/npm/jquery@3/dist/jquery.slim.min.js'
app_js_leaflet: 'https://cdn.jsdelivr.net/npm/leaflet@1/dist/leaflet.min.js'
app_js_popper: 'https://cdn.jsdelivr.net/npm/popper.js@1/dist/umd/popper.min.js'
app_js_toolkit: false
app_js_underscore: 'https://cdn.jsdelivr.net/npm/underscore@1/underscore.min.js'
app_locales_de:
  - de_DE.UTF-8
  - de_DE.UTF8
  - de_DE.utf-8
  - de_DE.utf8
  - de_DE@euro
  - de_DE
  - de
  - German
app_locales_en:
  - en_US.UTF-8
  - en_US.UTF8
  - en_US.utf-8
  - en_US.utf8
  - en_US
  - en
  - English
app_locales_fr:
  - fr_FR.UTF-8
  - fr_FR.UTF8
  - fr_FR.utf-8
  - fr_FR.utf8
  - fr_FR@euro
  - fr_FR
  - fr
  - French
app_locales_gb:
  - en_GB.UTF-8
  - en_GB.UTF8
  - en_GB.utf-8
  - en_GB.utf8
  - en_GB
  - en
  - English
app_locales_ru:
  - ru_RU.UTF-8
  - ru_RU.UTF8
  - ru_RU.utf-8
  - ru_RU.utf8
  - ru_RU
  - ru
  - Russian
app_locales_us:
  - en_US.UTF-8
  - en_US.UTF8
  - en_US.utf-8
  - en_US.utf8
  - en_US
  - en
  - English
app_toolkit_ckeditor: //cdn.ckeditor.com/4.11.4/full-all
app_toolkit_date: '%d %B %Y'
app_toolkit_hour: '%H:%M'
app_toolkit_icon: /toolkit/icons
app_toolkit_languages:
  - fr
  - en
  - es
app_toolkit_query:
  - q
app_toolkit_resize: convert
app_toolkit_time: '%d %b %Y à %H:%M'
app_toolkit_timezone: Europe/Paris
mod_additive_enabled: true
mod_additive_view_class: sfPHP
mod_default_enabled: true
mod_default_view_class: sfPHP
nav-additive: active
sf_admin_module_web_dir: /sfDoctrinePlugin
sf_admin_web_dir: /sf/sf_admin
sf_app: public
sf_app_base_cache_dir: /home/roadmat/production/cache/public
sf_app_cache_dir: /home/roadmat/production/cache/public/dev
sf_app_config_dir: /home/roadmat/production/apps/public/config
sf_app_dir: /home/roadmat/production/apps/public
sf_app_i18n_dir: /home/roadmat/production/apps/public/i18n
sf_app_lib_dir: /home/roadmat/production/apps/public/lib
sf_app_module_dir: /home/roadmat/production/apps/public/modules
sf_app_template_dir: /home/roadmat/production/apps/public/templates
sf_apps_dir: /home/roadmat/production/apps
sf_cache: true
sf_cache_dir: /home/roadmat/production/cache
sf_charset: utf-8
sf_check_lock: false
sf_compressed: false
sf_config_cache_dir: /home/roadmat/production/cache/public/dev/config
sf_config_dir: /home/roadmat/production/config
sf_csrf_secret: 4faf985e505f068a32c53bfb7e3e11d815ea38be
sf_data_dir: /home/roadmat/production/data
sf_debug: true
sf_default_culture: en
sf_email_from:
  contact@roadmat.com: RoadMat
sf_enabled_modules:
  - default
sf_environment: dev
sf_error_404_action: error404
sf_error_404_module: default
sf_error_reporting: 32767
sf_escaping_method: ESC_SPECIALCHARS
sf_escaping_strategy: false
sf_etag: false
sf_file_link_format: null
sf_i18n: true
sf_i18n_cache_dir: /home/roadmat/production/cache/public/dev/i18n
sf_lib_dir: /home/roadmat/production/lib
sf_log_dir: /home/roadmat/production/log
sf_logging_enabled: true
sf_login_action: login
sf_login_module: default
sf_module_cache_dir: /home/roadmat/production/cache/public/dev/modules
sf_module_disabled_action: disabled
sf_module_disabled_module: default
sf_mysql_base: roadmat
sf_mysql_host: localhost
sf_mysql_pass: 'PsEf6cq#'
sf_mysql_user: roadmat
sf_no_script_name: false
sf_orm: doctrine
sf_plugins_dir: /home/roadmat/production/plugins
sf_root_dir: /home/roadmat/production
sf_secure_action: secure
sf_secure_module: default
sf_standard_helpers:
  - Use
  - Public
  - Bootstrap4
  - Fontawesome6
  - Partial
  - Toolkit
sf_symfony_lib_dir: /home/roadmat/production/vendor/gow/symfony/lib
sf_template_cache_dir: /home/roadmat/production/cache/public/dev/template
sf_test_cache_dir: /home/roadmat/production/cache/public/dev/test
sf_test_dir: /home/roadmat/production/test
sf_upload_dir: /home/roadmat/production/web/uploads
sf_use_database: true
sf_web_debug: true
sf_web_debug_web_dir: /sf/sf_web_debug
sf_web_dir: /home/roadmat/production/web
symfony.asset.javascripts_included: true
symfony.asset.stylesheets_included: true
symfony.view.slot_names: {  }

cookie: {  }
env: {  }
files: {  }
get:
  environment: '556'
  family: '208'
post: {  }
server:
  CONTEXT_DOCUMENT_ROOT: /home/roadmat/production/web
  CONTEXT_PREFIX: ''
  DOCUMENT_ROOT: /home/roadmat/production/web
  FCGI_ROLE: RESPONDER
  GATEWAY_INTERFACE: CGI/1.1
  HOME: /home/roadmat
  HTTP_ACCEPT: '*/*'
  HTTP_ACCEPT_ENCODING: 'gzip, br, zstd, deflate'
  HTTP_HOST: roadmat.com
  HTTP_USER_AGENT: 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'
  HTTP_X_FORWARDED_PORT: '443'
  HTTP_X_FORWARDED_PROTO: https
  PATH: '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/snap/bin'
  PATH_INFO: /fr/additive/index.html
  PATH_TRANSLATED: 'redirect:/index.php/additive/index.html'
  PHP_SELF: /public_dev.php/fr/additive/index.html
  QUERY_STRING: 'environment=556&family=208'
  REMOTE_ADDR: 216.73.216.150
  REMOTE_PORT: '47600'
  REQUEST_METHOD: GET
  REQUEST_SCHEME: http
  REQUEST_TIME: 1774549921
  REQUEST_TIME_FLOAT: 1774549921.1521
  REQUEST_URI: '/public_dev.php/fr/additive/index.html?environment=556&family=208'
  SCRIPT_FILENAME: //home/roadmat/production/web/public_dev.php
  SCRIPT_NAME: /public_dev.php
  SERVER_ADDR: 127.0.0.1
  SERVER_ADMIN: webmaster@go-on-web.com
  SERVER_NAME: roadmat.com
  SERVER_PORT: '80'
  SERVER_PROTOCOL: HTTP/1.1
  SERVER_SIGNATURE: ''
  SERVER_SOFTWARE: Apache
  UNIQUE_ID: acV7oVWyRtpP60swITMyZgAAAIA
  USER: roadmat
  proxy-nokeepalive: '1'
session: {  }

php: 8.3.30
os: 'Linux go-on-web.net 6.1.0-16-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.67-1 (2023-12-12) x86_64'
extensions:
  19: 'apcu (5.1.28)'
  20: 'bcmath (8.3.30)'
  21: 'calendar (8.3.30)'
  15: 'cgi-fcgi (8.3.30)'
  0: 'Core (8.3.30)'
  22: 'ctype (8.3.30)'
  23: 'curl (8.3.30)'
  1: 'date (8.3.30)'
  24: 'dom (20031129)'
  34: 'exif (8.3.30)'
  26: 'FFI (8.3.30)'
  27: 'fileinfo (8.3.30)'
  6: 'filter (8.3.30)'
  28: 'ftp (8.3.30)'
  29: 'gd (8.3.30)'
  30: 'gettext (8.3.30)'
  7: 'hash (8.3.30)'
  31: 'iconv (8.3.30)'
  32: 'imagick (3.8.1)'
  33: 'intl (8.3.30)'
  8: 'json (8.3.30)'
  2: 'libxml (8.3.30)'
  25: 'mbstring (8.3.30)'
  35: 'mysqli (8.3.30)'
  16: 'mysqlnd (mysqlnd 8.3.30)'
  3: 'openssl (8.3.30)'
  4: 'pcre (8.3.30)'
  17: 'PDO (8.3.30)'
  36: 'pdo_mysql (8.3.30)'
  37: 'pdo_sqlite (8.3.30)'
  38: 'Phar (8.3.30)'
  39: 'posix (8.3.30)'
  9: 'random (8.3.30)'
  40: 'readline (8.3.30)'
  10: 'Reflection (8.3.30)'
  12: 'session (8.3.30)'
  41: 'shmop (8.3.30)'
  42: 'SimpleXML (8.3.30)'
  43: 'sockets (8.3.30)'
  14: 'sodium (8.3.30)'
  11: 'SPL (8.3.30)'
  44: 'sqlite3 (8.3.30)'
  13: 'standard (8.3.30)'
  45: 'sysvmsg (8.3.30)'
  46: 'sysvsem (8.3.30)'
  47: 'sysvshm (8.3.30)'
  48: 'tidy (8.3.30)'
  49: 'tokenizer (8.3.30)'
  18: 'xml (8.3.30)'
  50: 'xmlreader (8.3.30)'
  51: 'xmlwriter (8.3.30)'
  52: 'xsl (8.3.30)'
  54: 'Zend OPcache (8.3.30)'
  53: 'zip (1.22.3)'
  5: 'zlib (8.3.30)'

version: 1.4.GOW
path: /home/roadmat/production/vendor/gow/symfony/lib

Parameters:

• $additive_nb (integer)
• $additive_list (Doctrine_Collection)
• $year (Field)
• $filter (PublicAdditiveFormFilter)
  • $filter['term'] (sfWidgetFormInputText)
  • $filter['year_at'] (sfWidgetFormInputText)
  • $filter['year_to'] (sfWidgetFormInputText)
  • $filter['family'] (sfWidgetFormInputHidden)
  • $filter['type'] (sfWidgetFormInputHidden)
  • $filter['category'] (sfWidgetFormInputHidden)
  • $filter['environment'] (sfWidgetFormInputHidden)
  • $filter['manufacturer'] (sfWidgetFormInputHidden)
  • $filter['order'] (sfWidgetFormInputHidden)
• $field_list (array)

Parameters:

• $filter (PublicAdditiveFormFilter)
  • $filter['term'] (sfWidgetFormInputText)
  • $filter['year_at'] (sfWidgetFormInputText)
  • $filter['year_to'] (sfWidgetFormInputText)
  • $filter['family'] (sfWidgetFormInputHidden)
  • $filter['type'] (sfWidgetFormInputHidden)
  • $filter['category'] (sfWidgetFormInputHidden)
  • $filter['environment'] (sfWidgetFormInputHidden)
  • $filter['manufacturer'] (sfWidgetFormInputHidden)
  • $filter['order'] (sfWidgetFormInputHidden)
• $param (string)
• $title (string)

Parameters:

• $filter (PublicAdditiveFormFilter)
  • $filter['term'] (sfWidgetFormInputText)
  • $filter['year_at'] (sfWidgetFormInputText)
  • $filter['year_to'] (sfWidgetFormInputText)
  • $filter['family'] (sfWidgetFormInputHidden)
  • $filter['type'] (sfWidgetFormInputHidden)
  • $filter['category'] (sfWidgetFormInputHidden)
  • $filter['environment'] (sfWidgetFormInputHidden)
  • $filter['manufacturer'] (sfWidgetFormInputHidden)
  • $filter['order'] (sfWidgetFormInputHidden)
• $param (string)
• $title (string)

Parameters:

• $filter (PublicAdditiveFormFilter)
  • $filter['term'] (sfWidgetFormInputText)
  • $filter['year_at'] (sfWidgetFormInputText)
  • $filter['year_to'] (sfWidgetFormInputText)
  • $filter['family'] (sfWidgetFormInputHidden)
  • $filter['type'] (sfWidgetFormInputHidden)
  • $filter['category'] (sfWidgetFormInputHidden)
  • $filter['environment'] (sfWidgetFormInputHidden)
  • $filter['manufacturer'] (sfWidgetFormInputHidden)
  • $filter['order'] (sfWidgetFormInputHidden)
• $param (string)
• $title (string)

Parameters:

• $filter (PublicAdditiveFormFilter)
  • $filter['term'] (sfWidgetFormInputText)
  • $filter['year_at'] (sfWidgetFormInputText)
  • $filter['year_to'] (sfWidgetFormInputText)
  • $filter['family'] (sfWidgetFormInputHidden)
  • $filter['type'] (sfWidgetFormInputHidden)
  • $filter['category'] (sfWidgetFormInputHidden)
  • $filter['environment'] (sfWidgetFormInputHidden)
  • $filter['manufacturer'] (sfWidgetFormInputHidden)
  • $filter['order'] (sfWidgetFormInputHidden)
• $param (string)
• $title (string)

Parameters:

• $filter (PublicAdditiveFormFilter)
  • $filter['term'] (sfWidgetFormInputText)
  • $filter['year_at'] (sfWidgetFormInputText)
  • $filter['year_to'] (sfWidgetFormInputText)
  • $filter['family'] (sfWidgetFormInputHidden)
  • $filter['type'] (sfWidgetFormInputHidden)
  • $filter['category'] (sfWidgetFormInputHidden)
  • $filter['environment'] (sfWidgetFormInputHidden)
  • $filter['manufacturer'] (sfWidgetFormInputHidden)
  • $filter['order'] (sfWidgetFormInputHidden)
• $param (string)
• $title (string)

No parameters were passed to this template.

Parameters:

• $type_list (array)

Parameters:

• $lang_list (array)
• $route (sfRoute)
• $params (array)
• $options (array)

Doctrine Version: 1.2.4

1. SET NAMES 'utf8mb4', SQL_MODE='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'

   0.00s, "doctrine" connection

2. SELECT `l`.`id` AS `l__id`, `l`.`code` AS `l__code`, `l`.`name` AS `l__name`, `l`.`sort` AS `l__sort`, `l`.`created_at` AS `l__created_at`, `l`.`updated_at` AS `l__updated_at` FROM `lang` `l` ORDER BY `l`.`sort`

   0.00s, "doctrine" connection

3. SELECT `u`.`id` AS `u__id`, `u`.`name` AS `u__name`, `u`.`type` AS `u__type` FROM `user` `u` WHERE (`u`.`type` IN ('admin', 'writer')) ORDER BY `u`.`type`, `u`.`name`

   0.00s, "doctrine" connection

4. SELECT `a`.`id` AS `a__id`, `a`.`family_id` AS `a__family_id`, COUNT(distinct `a`.`id`) AS `a__0` FROM `additive` `a` LEFT JOIN `company` `c` ON `a`.`manufacturer_id` = `c`.`id` LEFT JOIN `user` `u` ON `a`.`user_id` = `u`.`id` WHERE (`a`.`published_at` is not null AND `a`.`published_at` <= '2026-03-26' AND `a`.`family_id` is not null) GROUP BY `a`.`family_id`

   0.01s, "doctrine" connection

5. SELECT `c`.`id` AS `c__id`, `c`.`type` AS `c__type`, `c2`.`id` AS `c2__id`, `c2`.`lang` AS `c2__lang`, `c2`.`name` AS `c2__name` FROM `choice` `c` LEFT JOIN `choice_translation` `c2` ON `c`.`id` = `c2`.`id` ORDER BY `c`.`sort`

   0.01s, "doctrine" connection

6. SELECT `a`.`id` AS `a__id`, `a`.`type_id` AS `a__type_id`, COUNT(distinct `a`.`id`) AS `a__0` FROM `additive` `a` LEFT JOIN `company` `c` ON `a`.`manufacturer_id` = `c`.`id` LEFT JOIN `user` `u` ON `a`.`user_id` = `u`.`id` WHERE (`a`.`published_at` is not null AND `a`.`published_at` <= '2026-03-26' AND `a`.`type_id` is not null) GROUP BY `a`.`type_id`

   0.00s, "doctrine" connection

7. SELECT `a`.`id` AS `a__id`, `a`.`category_id` AS `a__category_id`, COUNT(distinct `a`.`id`) AS `a__0` FROM `additive` `a` LEFT JOIN `company` `c` ON `a`.`manufacturer_id` = `c`.`id` LEFT JOIN `user` `u` ON `a`.`user_id` = `u`.`id` WHERE (`a`.`published_at` is not null AND `a`.`published_at` <= '2026-03-26' AND `a`.`category_id` is not null) GROUP BY `a`.`category_id`

   0.00s, "doctrine" connection

8. SELECT `a`.`id` AS `a__id`, `a`.`environment_id` AS `a__environment_id`, COUNT(distinct `a`.`id`) AS `a__0` FROM `additive` `a` LEFT JOIN `company` `c` ON `a`.`manufacturer_id` = `c`.`id` LEFT JOIN `user` `u` ON `a`.`user_id` = `u`.`id` WHERE (`a`.`published_at` is not null AND `a`.`published_at` <= '2026-03-26' AND `a`.`environment_id` is not null) GROUP BY `a`.`environment_id`

   0.00s, "doctrine" connection

9. SELECT `a`.`id` AS `a__id`, `a`.`manufacturer_id` AS `a__manufacturer_id`, `c`.`id` AS `c__id`, `c`.`name` AS `c__name`, COUNT(distinct `a`.`id`) AS `a__0` FROM `additive` `a` LEFT JOIN `company` `c` ON `a`.`manufacturer_id` = `c`.`id` LEFT JOIN `user` `u` ON `a`.`user_id` = `u`.`id` WHERE (`a`.`published_at` is not null AND `a`.`published_at` <= '2026-03-26' AND `a`.`manufacturer_id` is not null) GROUP BY `a`.`manufacturer_id`

   0.00s, "doctrine" connection

10. SELECT DISTINCT `a`.`id` AS `a__id` FROM `additive` `a` LEFT JOIN `company` `c` ON `a`.`manufacturer_id` = `c`.`id` LEFT JOIN `user` `u` ON `a`.`user_id` = `u`.`id` WHERE (`a`.`published_at` is not null AND `a`.`published_at` <= '2026-03-26' AND `a`.`family_id` = 208 AND `a`.`environment_id` = 556)

    0.00s, "doctrine" connection

11. SELECT DISTINCT `a2`.`id` FROM `additive` `a2` LEFT JOIN `company` `c2` ON `a2`.`manufacturer_id` = `c2`.`id` LEFT JOIN `user` `u2` ON `a2`.`user_id` = `u2`.`id` LEFT JOIN `partner_additive` `p4` ON (`a2`.`id` = `p4`.`additive_id`) LEFT JOIN `partner` `p3` ON `p3`.`id` = `p4`.`partner_id` AND ((`p3`.`is_active` = 1 AND (`p3`.`date_at` is null OR `p3`.`date_at` <= curdate()) AND (`p3`.`date_to` is null OR `p3`.`date_to` >= curdate()))) WHERE `a2`.`published_at` is not null AND `a2`.`published_at` <= '2026-03-26' AND `a2`.`family_id` = 208 AND `a2`.`environment_id` = 556 ORDER BY `p3`.`weight` is null, if(`p3`.`weight`, `p3`.`weight` * rand(), null), COALESCE(`a2`.`logo`, "") = "", COALESCE(`c2`.`logo`, "") = "", `a2`.`name` LIMIT 15

    0.00s, "doctrine" connection

12. SELECT `a`.`id` AS `a__id` FROM `additive` `a` LEFT JOIN `company` `c` ON `a`.`manufacturer_id` = `c`.`id` LEFT JOIN `user` `u` ON `a`.`user_id` = `u`.`id` LEFT JOIN `partner_additive` `p2` ON (`a`.`id` = `p2`.`additive_id`) LEFT JOIN `partner` `p` ON `p`.`id` = `p2`.`partner_id` AND ((`p`.`is_active` = 1 AND (`p`.`date_at` is null OR `p`.`date_at` <= curdate()) AND (`p`.`date_to` is null OR `p`.`date_to` >= curdate()))) WHERE `a`.`id` IN (1081, 1083, 1082, 1072, 1091, 1079, 639) AND (`a`.`published_at` is not null AND `a`.`published_at` <= '2026-03-26' AND `a`.`family_id` = 208 AND `a`.`environment_id` = 556) ORDER BY `p`.`weight` is null, if(`p`.`weight`, `p`.`weight` * rand(), null), COALESCE(`a`.`logo`, "") = "", COALESCE(`c`.`logo`, "") = "", `a`.`name`

    0.00s, "doctrine" connection

13. SELECT `a`.`id` AS `a__id`, `a`.`published_at` AS `a__published_at`, `a`.`user_id` AS `a__user_id`, `a`.`family_id` AS `a__family_id`, `a`.`type_id` AS `a__type_id`, `a`.`category_id` AS `a__category_id`, `a`.`environment_id` AS `a__environment_id`, `a`.`manufacturer_id` AS `a__manufacturer_id`, `a`.`name` AS `a__name`, `a`.`logo` AS `a__logo`, `a`.`url` AS `a__url`, `a`.`year` AS `a__year`, `a`.`labels` AS `a__labels`, `a`.`infos` AS `a__infos`, `a`.`search` AS `a__search`, `a`.`draft` AS `a__draft`, `a`.`slug` AS `a__slug`, `a`.`created_at` AS `a__created_at`, `a`.`updated_at` AS `a__updated_at`, `a`.`created_by` AS `a__created_by`, `a`.`updated_by` AS `a__updated_by`, `c`.`id` AS `c__id`, `c`.`logo` AS `c__logo`, `c`.`url` AS `c__url`, `c`.`name` AS `c__name`, `c`.`slug` AS `c__slug`, `u`.`id` AS `u__id`, `u`.`name` AS `u__name`, `p`.`id` AS `p__id`, `p`.`name` AS `p__name`, `p`.`link` AS `p__link`, `p`.`image` AS `p__image`, `p`.`contract_id` AS `p__contract_id`, `p`.`weight` AS `p__weight`, `p`.`is_active` AS `p__is_active`, `p`.`date_at` AS `p__date_at`, `p`.`date_to` AS `p__date_to`, `p`.`country_list` AS `p__country_list`, `p`.`comment` AS `p__comment`, `p`.`slug` AS `p__slug`, `p`.`created_at` AS `p__created_at`, `p`.`updated_at` AS `p__updated_at`, `p`.`created_by` AS `p__created_by`, `p`.`updated_by` AS `p__updated_by` FROM `additive` `a` LEFT JOIN `company` `c` ON `a`.`manufacturer_id` = `c`.`id` LEFT JOIN `user` `u` ON `a`.`user_id` = `u`.`id` LEFT JOIN `partner_additive` `p2` ON (`a`.`id` = `p2`.`additive_id`) LEFT JOIN `partner` `p` ON `p`.`id` = `p2`.`partner_id` AND ((is_active = 1 AND (date_at is null OR date_at <= curdate()) AND (date_to is null OR date_to >= curdate()))) WHERE (`a`.`published_at` is not null AND `a`.`published_at` <= '2026-03-26' AND `a`.`id` IN (1081, 1083, 1082, 1072, 1091, 1079, 639)) ORDER BY field(`a`.`id`, 1081, 1083, 1082, 1072, 1091, 1079, 639)

    0.00s, "doctrine" connection

14. SELECT DISTINCT `f3`.`id` FROM `field` `f3` LEFT JOIN `field_translation` `f4` ON `f3`.`id` = `f4`.`id` WHERE `f3`.`model` = 'Additive' AND `f3`.`id` = 'years-of-field-experience' LIMIT 1

    0.00s, "doctrine" connection

15. SELECT `f`.`id` AS `f__id`, `f`.`model` AS `f__model`, `f`.`type` AS `f__type`, `f`.`flags` AS `f__flags`, `f`.`sort` AS `f__sort`, `f`.`created_at` AS `f__created_at`, `f`.`updated_at` AS `f__updated_at`, `f`.`translated` AS `f__translated`, `f2`.`id` AS `f2__id`, `f2`.`name` AS `f2__name`, `f2`.`lang` AS `f2__lang` FROM `field` `f` LEFT JOIN `field_translation` `f2` ON `f`.`id` = `f2`.`id` WHERE `f`.`id` IN ('years-of-field-experience') AND (`f`.`model` = 'Additive' AND `f`.`id` = 'years-of-field-experience')

    0.00s, "doctrine" connection

16. SELECT `f`.`id` AS `f__id`, `f`.`model` AS `f__model`, `f`.`type` AS `f__type`, `f`.`flags` AS `f__flags`, `f`.`sort` AS `f__sort`, `f`.`created_at` AS `f__created_at`, `f`.`updated_at` AS `f__updated_at`, `f`.`translated` AS `f__translated`, `f2`.`id` AS `f2__id`, `f2`.`name` AS `f2__name`, `f2`.`lang` AS `f2__lang` FROM `field` `f` LEFT JOIN `field_translation` `f2` ON `f`.`id` = `f2`.`id` WHERE (`f`.`model` = 'Additive') ORDER BY `f`.`sort`

    0.00s, "doctrine" connection

17. SELECT `a`.`id` AS `a__id`, `a`.`environment_id` AS `a__environment_id`, COUNT(distinct `a`.`id`) AS `a__0` FROM `additive` `a` LEFT JOIN `company` `c` ON `a`.`manufacturer_id` = `c`.`id` LEFT JOIN `user` `u` ON `a`.`user_id` = `u`.`id` WHERE (`a`.`published_at` is not null AND `a`.`published_at` <= '2026-03-26' AND `a`.`environment_id` is not null AND `a`.`family_id` = 208) GROUP BY `a`.`environment_id`

    0.00s, "doctrine" connection

18. SELECT `a`.`id` AS `a__id`, `a`.`family_id` AS `a__family_id`, COUNT(distinct `a`.`id`) AS `a__0` FROM `additive` `a` LEFT JOIN `company` `c` ON `a`.`manufacturer_id` = `c`.`id` LEFT JOIN `user` `u` ON `a`.`user_id` = `u`.`id` WHERE (`a`.`published_at` is not null AND `a`.`published_at` <= '2026-03-26' AND `a`.`family_id` is not null AND `a`.`environment_id` = 556) GROUP BY `a`.`family_id`

    0.00s, "doctrine" connection

19. SELECT `a`.`id` AS `a__id`, `a`.`type_id` AS `a__type_id`, COUNT(distinct `a`.`id`) AS `a__0` FROM `additive` `a` LEFT JOIN `company` `c` ON `a`.`manufacturer_id` = `c`.`id` LEFT JOIN `user` `u` ON `a`.`user_id` = `u`.`id` WHERE (`a`.`published_at` is not null AND `a`.`published_at` <= '2026-03-26' AND `a`.`type_id` is not null AND `a`.`family_id` = 208 AND `a`.`environment_id` = 556) GROUP BY `a`.`type_id`

    0.00s, "doctrine" connection

20. SELECT `a`.`id` AS `a__id`, `a`.`category_id` AS `a__category_id`, COUNT(distinct `a`.`id`) AS `a__0` FROM `additive` `a` LEFT JOIN `company` `c` ON `a`.`manufacturer_id` = `c`.`id` LEFT JOIN `user` `u` ON `a`.`user_id` = `u`.`id` WHERE (`a`.`published_at` is not null AND `a`.`published_at` <= '2026-03-26' AND `a`.`category_id` is not null AND `a`.`family_id` = 208 AND `a`.`environment_id` = 556) GROUP BY `a`.`category_id`

    0.00s, "doctrine" connection

21. SELECT `a`.`id` AS `a__id`, `a`.`manufacturer_id` AS `a__manufacturer_id`, `c`.`id` AS `c__id`, `c`.`name` AS `c__name`, COUNT(distinct `a`.`id`) AS `a__0` FROM `additive` `a` LEFT JOIN `company` `c` ON `a`.`manufacturer_id` = `c`.`id` LEFT JOIN `user` `u` ON `a`.`user_id` = `u`.`id` WHERE (`a`.`published_at` is not null AND `a`.`published_at` <= '2026-03-26' AND `a`.`manufacturer_id` is not null AND `a`.`family_id` = 208 AND `a`.`environment_id` = 556) GROUP BY `a`.`manufacturer_id`

    0.00s, "doctrine" connection

22. SELECT `p`.`id` AS `p__id`, `p`.`sort` AS `p__sort`, `p`.`created_at` AS `p__created_at`, `p`.`updated_at` AS `p__updated_at`, `p`.`translated` AS `p__translated`, `p2`.`id` AS `p2__id`, `p2`.`name` AS `p2__name`, `p2`.`description` AS `p2__description`, `p2`.`lang` AS `p2__lang` FROM `paper_type` `p` LEFT JOIN `paper_type_translation` `p2` ON `p`.`id` = `p2`.`id` LEFT JOIN `paper` `p3` ON `p`.`id` = `p3`.`type_id` WHERE (`p3`.`published_at` <= '2026-03-26') ORDER BY `p`.`sort`

    0.00s, "doctrine" connection