| Supplier |
Supplier ValoChemView business information |
|---|---|
| Generic name |
Generic name Acidifier |
| Family / Type / Category |
Family / Type / Category Additives for bituminous emulsions / Emulsifiers / Co-emulsifiers |
| Composition |
Composition Acidifier |
Please add products to the comparador
XS SM MD LG XL
config
view
logs
6144.0 KB
545 ms
9options:
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: view
id: '398'
module: additive
sf_culture: en
sf_format: html
slug: EmuVal-hD
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
title: 'EmuVal hD - ValoChem - Commercial additives - RoadMat'
robots: 'index, follow'
httpMetas:
Content-Type: 'text/html; charset=utf-8'
options:
auto_shutdown: false
culture: en
default_culture: fr
timezone: null
default_timezone: Europe/Paris
use_flash: true
logging: '1'
timeout: 28800
attributeHolder:
symfony/user/sfUser/attributes: { culture: true }
visit: { additive: [1740, 854, 1285, 1108, 104, 1151, 987, 1021, 598, 1618, 569, 870, 1714, 1732, 803, 1666, 285, 920, 371, 566, 810, 1040, 647, 241, 1738, 804, 103, 1508, 1063, 757, 1499, 1271, 277, 432, 925, 834, 248, 1731, 109, 273, 1033, 897, 1152, 1748, 145, 547, 1578, 1292, 1288, 698, 255, 873, 796, 602, 1668, 1733, 41, 489, 144, 1754, 808, 1736, 520, 1286, 826, 838, 1494, 791, 243, 261, 30, 1509, 1291, 715, 1737, 1730, 501, 1029, 619, 119, 205, 1290, 1070, 1734, 1667, 1735, 515, 673, 1507, 1266, 775, 166, 429, 1140, 1015, 1077, 1289, 916, 790, 173, 400, 1232, 680, 956, 1756, 1596, 1755, 560, 1264, 427, 879, 1144, 403, 880, 170, 29, 235, 1504, 1055, 553, 279, 1675, 1599, 811, 431, 829, 1739, 1025, 1676, 1594, 347, 596, 1581, 111, 546, 242, 835, 653, 116, 1678, 1314, 832, 893, 1669, 1035, 1170, 66, 274, 777, 1680, 1677, 1588, 785, 696, 899, 365, 1287, 576, 19, 1670, 1751, 1293, 1503, 1448, 1683, 1671, 1447, 670, 1679, 2, 171, 1502, 208, 1045, 882, 1442, 348, 884, 206, 1673, 750, 1672, 1592, 20, 612, 563, 1136, 1041, 988, 1674, 1016, 421, 211, 1682, 249, 1598, 1593, 795, 319, 1595, 164, 100, 923, 203, 926, 51, 874, 852, 210, 668, 197, 1071, 505, 545, 615, 110, 597, 1582, 493, 1169, 488, 202, 1047, 1049, 760, 712, 39, 1135, 821, 1159, 404, 200, 376, 1591, 1752, 858, 637, 106, 883, 308, 1269, 833, 573, 905, 565, 1138, 1274, 583, 398], company: [1, 16, 119, 166, 29, 64, 77, 18, 45, 162, 147, 48, 156, 53, 148, 111, 8, 113, 155], paper: [13] }
culture: en
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
mod_visit_enabled: true
mod_visit_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:
GowID: sot0ot4acfbdheqp98uuu49sfm
env: { }
files: { }
get: { }
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_COOKIE: GowID=sot0ot4acfbdheqp98uuu49sfm
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: /en/additive/398/EmuVal-hD.view.html
PATH_TRANSLATED: 'redirect:/index.php/additive/398/EmuVal-hD.view.html'
PHP_SELF: /public_dev.php/en/additive/398/EmuVal-hD.view.html
QUERY_STRING: ''
REMOTE_ADDR: 216.73.216.150
REMOTE_PORT: '37830'
REQUEST_METHOD: GET
REQUEST_SCHEME: http
REQUEST_TIME: 1774543837
REQUEST_TIME_FLOAT: 1774543837.4078
REQUEST_URI: /public_dev.php/en/additive/398/EmuVal-hD.view.html
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: acVj3S24kqUY1-oO6SVqfQAAAAE
USER: roadmat
proxy-nokeepalive: '1'
session:
symfony/user/sfUser/attributes: { symfony/user/sfUser/attributes: { culture: true }, visit: { additive: [1740, 854, 1285, 1108, 104, 1151, 987, 1021, 598, 1618, 569, 870, 1714, 1732, 803, 1666, 285, 920, 371, 566, 810, 1040, 647, 241, 1738, 804, 103, 1508, 1063, 757, 1499, 1271, 277, 432, 925, 834, 248, 1731, 109, 273, 1033, 897, 1152, 1748, 145, 547, 1578, 1292, 1288, 698, 255, 873, 796, 602, 1668, 1733, 41, 489, 144, 1754, 808, 1736, 520, 1286, 826, 838, 1494, 791, 243, 261, 30, 1509, 1291, 715, 1737, 1730, 501, 1029, 619, 119, 205, 1290, 1070, 1734, 1667, 1735, 515, 673, 1507, 1266, 775, 166, 429, 1140, 1015, 1077, 1289, 916, 790, 173, 400, 1232, 680, 956, 1756, 1596, 1755, 560, 1264, 427, 879, 1144, 403, 880, 170, 29, 235, 1504, 1055, 553, 279, 1675, 1599, 811, 431, 829, 1739, 1025, 1676, 1594, 347, 596, 1581, 111, 546, 242, 835, 653, 116, 1678, 1314, 832, 893, 1669, 1035, 1170, 66, 274, 777, 1680, 1677, 1588, 785, 696, 899, 365, 1287, 576, 19, 1670, 1751, 1293, 1503, 1448, 1683, 1671, 1447, 670, 1679, 2, 171, 1502, 208, 1045, 882, 1442, 348, 884, 206, 1673, 750, 1672, 1592, 20, 612, 563, 1136, 1041, 988, 1674, 1016, 421, 211, 1682, 249, 1598, 1593, 795, 319, 1595, 164, 100, 923, 203, 926, 51, 874, 852, 210, 668, 197, 1071, 505, 545, 615, 110, 597, 1582, 493, 1169, 488, 202, 1047, 1049, 760, 712, 39, 1135, 821, 1159, 404, 200, 376, 1591, 1752, 858, 637, 106, 883, 308, 1269, 833, 573, 905, 565, 1138, 1274, 583], paper: [13], company: [1, 16, 119, 166, 29, 64, 77, 18, 45, 162, 147, 48, 156, 53, 148, 111, 8, 113, 155] } }
symfony/user/sfUser/authenticated: false
symfony/user/sfUser/credentials: { }
symfony/user/sfUser/culture: en
symfony/user/sfUser/lastRequest: 1774543837
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:
$info_list (Doctrine_Collection)$additive (Additive)$paper_list (Doctrine_Collection)No parameters were passed to this template.
Parameters:
$type (string)$id (integer)$count (integer)Parameters:
$type (string)$id (integer)No parameters were passed to this template.
Parameters:
$type_list (array)Parameters:
$partner_list (array)Parameters:
$lang_list (array)$route (sfRoute)$params (array)$options (array)
| # | type | message |
|---|---|---|
| 1 | ToolkitRouting | Connect sfRoute "default/index" (/:sf_culture/) |
| 2 | ToolkitRouting | Connect sfRoute "page/static" (/:sf_culture/page/static/:id.:sf_format) |
| 3 | ToolkitRouting | Connect sfRoute "sitemap" (/sitemap.xml) |
| 4 | ToolkitRouting | Connect sfRoute "visit/track" (/visit/:type.:id.:sf_format) |
| 5 | ToolkitRouting | Connect sfRoute "homepage" (/) |
| 6 | ToolkitRouting | Connect sfRoute "slug" (/:module/:id/:slug.:action.:sf_format) |
| 7 | ToolkitRouting | Connect sfRoute "id" (/:module/:id/:action.:sf_format) |
| 8 | ToolkitRouting | Connect sfRoute "action" (/:module/:action.:sf_format) |
| 9 | ToolkitRouting | Connect sfRoute "permalink" (/:module/:id/) |
| 10 | ToolkitRouting | Connect sfRoute "index" (/:module/) |
| 11 | ToolkitRouting | Connect sfRoute "slug_i18n" (/:sf_culture/:module/:id/:slug.:action.:sf_format) |
| 12 | ToolkitRouting | Connect sfRoute "id_i18n" (/:sf_culture/:module/:id/:action.:sf_format) |
| 13 | ToolkitRouting | Connect sfRoute "action_i18n" (/:sf_culture/:module/:action.:sf_format) |
| 14 | ToolkitRouting | Connect sfRoute "permalink_i18n" (/:sf_culture/:module/:id/) |
| 15 | ToolkitRouting | Connect sfRoute "index_i18n" (/:sf_culture/:module/) |
| 16 | ToolkitRouting | Connect sfRoute "homepage_i18n" (/:sf_culture/) |
| 17 | ToolkitRouting | Connect sfRoute "default_index" (/:module) |
| 18 | ToolkitRouting | Connect sfRoute "default" (/:module/:action/*) |
| 19 | ToolkitRouting | Match route "slug_i18n" (/:sf_culture/:module/:id/:slug.:action.:sf_format) for /en/additive/398/EmuVal-hD.view.html with parameters array ( 'module' => 'additive', 'action' => 'view', 'sf_culture' => 'en', 'id' => '398', 'slug' => 'EmuVal-hD', 'sf_format' => 'html',) |
| 20 | sfFilterChain | Executing filter "sfRenderingFilter" |
| 21 | sfFilterChain | Executing filter "I18nFilter" |
| 22 | Doctrine_Connection_Mysql | exec : SET NAMES 'utf8mb4', SQL_MODE='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' - () |
| 23 | Doctrine_Connection_Mysql | query : 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` - () |
| 24 | sfFilterChain | Executing filter "sfCacheFilter" |
| 25 | sfFilterChain | Executing filter "sfExecutionFilter" |
| 26 | additiveActions | Call "additiveActions->executeView()" |
| 27 | Doctrine_Connection_Statement | execute : SELECT DISTINCT `a2`.`id` FROM `additive` `a2` LEFT JOIN `company` `c8` ON `a2`.`manufacturer_id` = `c8`.`id` LEFT JOIN `partner_additive` `p4` ON (`a2`.`id` = `p4`.`additive_id`) LEFT JOIN `partner` `p3` ON `p3`.`id` = `p4`.`partner_id` LEFT JOIN `choice` `c9` ON `a2`.`family_id` = `c9`.`id` AND `c9`.`type` = 'additive.family' LEFT JOIN `choice_translation` `c10` ON `c9`.`id` = `c10`.`id` LEFT JOIN `choice` `c11` ON `a2`.`type_id` = `c11`.`id` AND `c11`.`type` = 'additive.type' LEFT JOIN `choice_translation` `c12` ON `c11`.`id` = `c12`.`id` LEFT JOIN `choice` `c13` ON `a2`.`category_id` = `c13`.`id` AND `c13`.`type` = 'additive.category' LEFT JOIN `choice_translation` `c14` ON `c13`.`id` = `c14`.`id` WHERE `a2`.`published_at` <= ? AND `a2`.`id` = ? ORDER BY `p3`.`weight` desc LIMIT 1 - (2026-03-26, 398) |
| 28 | Doctrine_Connection_Statement | execute : 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`.`published_at` AS `c__published_at`, `c`.`user_id` AS `c__user_id`, `c`.`type` AS `c__type`, `c`.`name` AS `c__name`, `c`.`logo` AS `c__logo`, `c`.`url` AS `c__url`, `c`.`contact` AS `c__contact`, `c`.`lat` AS `c__lat`, `c`.`lng` AS `c__lng`, `c`.`address` AS `c__address`, `c`.`zip` AS `c__zip`, `c`.`city` AS `c__city`, `c`.`country_id` AS `c__country_id`, `c`.`phone` AS `c__phone`, `c`.`email` AS `c__email`, `c`.`description` AS `c__description`, `c`.`infos` AS `c__infos`, `c`.`search` AS `c__search`, `c`.`draft` AS `c__draft`, `c`.`slug` AS `c__slug`, `c`.`created_at` AS `c__created_at`, `c`.`updated_at` AS `c__updated_at`, `c`.`created_by` AS `c__created_by`, `c`.`updated_by` AS `c__updated_by`, `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`, `c2`.`id` AS `c2__id`, `c2`.`type` AS `c2__type`, `c2`.`sort` AS `c2__sort`, `c2`.`created_at` AS `c2__created_at`, `c2`.`updated_at` AS `c2__updated_at`, `c2`.`translated` AS `c2__translated`, `c3`.`id` AS `c3__id`, `c3`.`name` AS `c3__name`, `c3`.`lang` AS `c3__lang`, `c4`.`id` AS `c4__id`, `c4`.`type` AS `c4__type`, `c4`.`sort` AS `c4__sort`, `c4`.`created_at` AS `c4__created_at`, `c4`.`updated_at` AS `c4__updated_at`, `c4`.`translated` AS `c4__translated`, `c5`.`id` AS `c5__id`, `c5`.`name` AS `c5__name`, `c5`.`lang` AS `c5__lang`, `c6`.`id` AS `c6__id`, `c6`.`type` AS `c6__type`, `c6`.`sort` AS `c6__sort`, `c6`.`created_at` AS `c6__created_at`, `c6`.`updated_at` AS `c6__updated_at`, `c6`.`translated` AS `c6__translated`, `c7`.`id` AS `c7__id`, `c7`.`name` AS `c7__name`, `c7`.`lang` AS `c7__lang` FROM `additive` `a` LEFT JOIN `company` `c` ON `a`.`manufacturer_id` = `c`.`id` LEFT JOIN `partner_additive` `p2` ON (`a`.`id` = `p2`.`additive_id`) LEFT JOIN `partner` `p` ON `p`.`id` = `p2`.`partner_id` LEFT JOIN `choice` `c2` ON `a`.`family_id` = `c2`.`id` AND `c2`.`type` = 'additive.family' LEFT JOIN `choice_translation` `c3` ON `c2`.`id` = `c3`.`id` LEFT JOIN `choice` `c4` ON `a`.`type_id` = `c4`.`id` AND `c4`.`type` = 'additive.type' LEFT JOIN `choice_translation` `c5` ON `c4`.`id` = `c5`.`id` LEFT JOIN `choice` `c6` ON `a`.`category_id` = `c6`.`id` AND `c6`.`type` = 'additive.category' LEFT JOIN `choice_translation` `c7` ON `c6`.`id` = `c7`.`id` WHERE `a`.`id` IN (398) AND (`a`.`published_at` <= ? AND `a`.`id` = ?) ORDER BY `p`.`weight` desc - (2026-03-26, 398) |
| 29 | Doctrine_Connection_Statement | execute : SELECT `a`.`id` AS `a__id`, `a`.`additive_id` AS `a__additive_id`, `a`.`field_id` AS `a__field_id`, `a`.`created_at` AS `a__created_at`, `a`.`updated_at` AS `a__updated_at`, `a`.`translated` AS `a__translated`, `a2`.`id` AS `a2__id`, `a2`.`name` AS `a2__name`, `a2`.`lang` AS `a2__lang`, `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 `additive_info` `a` LEFT JOIN `additive_info_translation` `a2` ON `a`.`id` = `a2`.`id` LEFT JOIN `field` `f` ON `a`.`field_id` = `f`.`id` LEFT JOIN `field_translation` `f2` ON `f`.`id` = `f2`.`id` WHERE (`a`.`additive_id` = ?) ORDER BY `f`.`sort` - (398) |
| 30 | Doctrine_Connection_Statement | execute : SELECT `p`.`id` AS `p__id`, `p`.`type_id` AS `p__type_id`, `p`.`published_at` AS `p__published_at`, `p`.`user_id` AS `p__user_id`, `p`.`partner_id` AS `p__partner_id`, `p`.`image` AS `p__image`, `p`.`size` AS `p__size`, `p`.`search` AS `p__search`, `p`.`visits` AS `p__visits`, `p`.`draft` AS `p__draft`, `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`, `p`.`translated` AS `p__translated`, `p2`.`id` AS `p2__id`, `p2`.`name` AS `p2__name`, `p2`.`file` AS `p2__file`, `p2`.`description` AS `p2__description`, `p2`.`cite` AS `p2__cite`, `p2`.`version` AS `p2__version`, `p2`.`reference` AS `p2__reference`, `p2`.`legend` AS `p2__legend`, `p2`.`content` AS `p2__content`, `p2`.`content_text` AS `p2__content_text`, `p2`.`slug` AS `p2__slug`, `p2`.`lang` AS `p2__lang` FROM `paper` `p` LEFT JOIN `paper_translation` `p2` ON `p`.`id` = `p2`.`id` LEFT JOIN `paper_additive` `p3` ON `p`.`id` = `p3`.`paper_id` WHERE (`p3`.`additive_id` = ?) ORDER BY `p`.`id` desc - (398) |
| 31 | myViewCacheManager | Cache for "additive/view?id=398&sf_culture=en&sf_format=html&slug=EmuVal-hD" does not exist |
| 32 | sfPHPView | Render "sf_app_dir/modules/additive/templates/viewSuccess.php" |
| 33 | main | Get slot "meta" |
| 34 | main | Set slot "meta" |
| 35 | myViewCacheManager | Generate cache key |
| 36 | myViewCacheManager | Cache for "@sf_cache_partial?module=default&action=_authenticate&sf_cache_key=40cd750bba9870f18aada2478b24840a" does not exist |
| 37 | sfPartialView | Render "sf_app_dir/modules/default/templates/_authenticate.php" |
| 38 | myViewCacheManager | Save cache for "@sf_cache_partial?module=default&action=_authenticate&sf_cache_key=40cd750bba9870f18aada2478b24840a" |
| 39 | myViewCacheManager | Generate cache key |
| 40 | myViewCacheManager | Cache for "@sf_cache_partial?module=additive&action=_logo&sf_cache_key=56dd0ef5f0daf25297a92499e53b506c" does not exist |
| 41 | main | Call "additive->executeLogo()" |
| 42 | myViewCacheManager | Generate cache key |
| 43 | myViewCacheManager | Cache for "@sf_cache_partial?module=visit&action=_count&sf_cache_key=9250e2d6aa2fe0f4256f831cb2688bc3" does not exist |
| 44 | main | Call "visit->executeCount()" |
| 45 | Doctrine_Connection_Statement | execute : SELECT sum(nb) as nb FROM visit WHERE code = ? - (additive.398) |
| 46 | myViewCacheManager | Cache for "@sf_cache_partial?module=visit&action=_count&sf_cache_key=9250e2d6aa2fe0f4256f831cb2688bc3" does not exist |
| 47 | sfPartialView | Render "sf_app_dir/modules/visit/templates/_count.php" |
| 48 | myViewCacheManager | Save cache for "@sf_cache_partial?module=visit&action=_count&sf_cache_key=9250e2d6aa2fe0f4256f831cb2688bc3" |
| 49 | myViewCacheManager | Generate cache key |
| 50 | myViewCacheManager | Cache for "@sf_cache_partial?module=visit&action=_tracker&sf_cache_key=9250e2d6aa2fe0f4256f831cb2688bc3" does not exist |
| 51 | sfPartialView | Render "sf_app_dir/modules/visit/templates/_tracker.php" |
| 52 | myViewCacheManager | Save cache for "@sf_cache_partial?module=visit&action=_tracker&sf_cache_key=9250e2d6aa2fe0f4256f831cb2688bc3" |
| 53 | myViewCacheManager | Save cache for "additive/view?id=398&sf_culture=en&sf_format=html&slug=EmuVal-hD" |
| 54 | sfPHPView | Decorate content with "sf_app_dir/templates/layout.php" |
| 55 | sfPHPView | Render "sf_app_dir/templates/layout.php" |
| 56 | main | Get slot "meta" |
| 57 | myViewCacheManager | Generate cache key |
| 58 | myViewCacheManager | Cache for "@sf_cache_partial?module=global&action=_matomo&sf_cache_key=40cd750bba9870f18aada2478b24840a" does not exist |
| 59 | sfPartialView | Render "sf_app_dir/templates/_matomo.php" |
| 60 | myViewCacheManager | Save cache for "@sf_cache_partial?module=global&action=_matomo&sf_cache_key=40cd750bba9870f18aada2478b24840a" |
| 61 | main | Call "default->executeHeader()" |
| 62 | Doctrine_Connection_Statement | execute : 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` <= ?) ORDER BY `p`.`sort` - (2026-03-26) |
| 63 | sfPartialView | Render "sf_app_dir/modules/default/templates/_header.php" |
| 64 | myViewCacheManager | Generate cache key |
| 65 | myViewCacheManager | Cache for "@sf_cache_partial?module=default&action=_footer&sf_cache_key=40cd750bba9870f18aada2478b24840a" does not exist |
| 66 | main | Call "default->executeFooter()" |
| 67 | Doctrine_Connection_Mysql | query : SELECT `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 `partner` `p` ORDER BY `p`.`weight` desc, `p`.`name` - () |
| 68 | myViewCacheManager | Cache for "@sf_cache_partial?module=default&action=_footer&sf_cache_key=40cd750bba9870f18aada2478b24840a" does not exist |
| 69 | sfPartialView | Render "sf_app_dir/modules/default/templates/_footer.php" |
| 70 | main | Get slot "footer" |
| 71 | myViewCacheManager | Save cache for "@sf_cache_partial?module=default&action=_footer&sf_cache_key=40cd750bba9870f18aada2478b24840a" |
| 72 | main | Call "default->executeLang()" |
| 73 | sfPartialView | Render "sf_app_dir/modules/default/templates/_lang.php" |
| 74 | ToolkitResponse | Send status "HTTP/1.1 200 OK" |
| 75 | ToolkitResponse | Send header "Content-Type: text/html; charset=utf-8" |
| 76 | ToolkitResponse | Send header "X-Frame-Options: SAMEORIGIN" |
| 77 | ToolkitResponse | Send header "X-Xss-Protection: 1" |
| type | calls | time (ms) | time (%) |
|---|---|---|---|
| Configuration | 24 | 13.35 | 2 |
| Factories | 1 | 491.13 | 90 |
| Database (Doctrine) | 9 | 3.62 | 0 |
| Action "additive/view" | 1 | 26.91 | 4 |
| View "Success" for "additive/view" | 1 | 19.15 | 3 |
| Partial "default/_authenticate" | 1 | 2.05 | 0 |
| Component "additive/logo" | 1 | 0.05 | 0 |
| Component "visit/count" | 1 | 0.27 | 0 |
| Partial "visit/_count" | 1 | 1.33 | 0 |
| Partial "visit/_tracker" | 1 | 1.79 | 0 |
| Partial "global/_matomo" | 1 | 1.46 | 0 |
| Component "default/header" | 1 | 2.81 | 0 |
| Partial "default/_header" | 1 | 0.32 | 0 |
| Component "default/footer" | 1 | 0.66 | 0 |
| Partial "default/_footer" | 1 | 2.05 | 0 |
| Component "default/lang" | 1 | 0.08 | 0 |
| Partial "default/_lang" | 1 | 0.10 | 0 |
SET NAMES 'utf8mb4', SQL_MODE='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'
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`
SELECT DISTINCT `a2`.`id` FROM `additive` `a2` LEFT JOIN `company` `c8` ON `a2`.`manufacturer_id` = `c8`.`id` LEFT JOIN `partner_additive` `p4` ON (`a2`.`id` = `p4`.`additive_id`) LEFT JOIN `partner` `p3` ON `p3`.`id` = `p4`.`partner_id` LEFT JOIN `choice` `c9` ON `a2`.`family_id` = `c9`.`id` AND `c9`.`type` = 'additive.family' LEFT JOIN `choice_translation` `c10` ON `c9`.`id` = `c10`.`id` LEFT JOIN `choice` `c11` ON `a2`.`type_id` = `c11`.`id` AND `c11`.`type` = 'additive.type' LEFT JOIN `choice_translation` `c12` ON `c11`.`id` = `c12`.`id` LEFT JOIN `choice` `c13` ON `a2`.`category_id` = `c13`.`id` AND `c13`.`type` = 'additive.category' LEFT JOIN `choice_translation` `c14` ON `c13`.`id` = `c14`.`id` WHERE `a2`.`published_at` <= '2026-03-26' AND `a2`.`id` = '398' ORDER BY `p3`.`weight` desc LIMIT 1
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`.`published_at` AS `c__published_at`, `c`.`user_id` AS `c__user_id`, `c`.`type` AS `c__type`, `c`.`name` AS `c__name`, `c`.`logo` AS `c__logo`, `c`.`url` AS `c__url`, `c`.`contact` AS `c__contact`, `c`.`lat` AS `c__lat`, `c`.`lng` AS `c__lng`, `c`.`address` AS `c__address`, `c`.`zip` AS `c__zip`, `c`.`city` AS `c__city`, `c`.`country_id` AS `c__country_id`, `c`.`phone` AS `c__phone`, `c`.`email` AS `c__email`, `c`.`description` AS `c__description`, `c`.`infos` AS `c__infos`, `c`.`search` AS `c__search`, `c`.`draft` AS `c__draft`, `c`.`slug` AS `c__slug`, `c`.`created_at` AS `c__created_at`, `c`.`updated_at` AS `c__updated_at`, `c`.`created_by` AS `c__created_by`, `c`.`updated_by` AS `c__updated_by`, `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`, `c2`.`id` AS `c2__id`, `c2`.`type` AS `c2__type`, `c2`.`sort` AS `c2__sort`, `c2`.`created_at` AS `c2__created_at`, `c2`.`updated_at` AS `c2__updated_at`, `c2`.`translated` AS `c2__translated`, `c3`.`id` AS `c3__id`, `c3`.`name` AS `c3__name`, `c3`.`lang` AS `c3__lang`, `c4`.`id` AS `c4__id`, `c4`.`type` AS `c4__type`, `c4`.`sort` AS `c4__sort`, `c4`.`created_at` AS `c4__created_at`, `c4`.`updated_at` AS `c4__updated_at`, `c4`.`translated` AS `c4__translated`, `c5`.`id` AS `c5__id`, `c5`.`name` AS `c5__name`, `c5`.`lang` AS `c5__lang`, `c6`.`id` AS `c6__id`, `c6`.`type` AS `c6__type`, `c6`.`sort` AS `c6__sort`, `c6`.`created_at` AS `c6__created_at`, `c6`.`updated_at` AS `c6__updated_at`, `c6`.`translated` AS `c6__translated`, `c7`.`id` AS `c7__id`, `c7`.`name` AS `c7__name`, `c7`.`lang` AS `c7__lang` FROM `additive` `a` LEFT JOIN `company` `c` ON `a`.`manufacturer_id` = `c`.`id` LEFT JOIN `partner_additive` `p2` ON (`a`.`id` = `p2`.`additive_id`) LEFT JOIN `partner` `p` ON `p`.`id` = `p2`.`partner_id` LEFT JOIN `choice` `c2` ON `a`.`family_id` = `c2`.`id` AND `c2`.`type` = 'additive.family' LEFT JOIN `choice_translation` `c3` ON `c2`.`id` = `c3`.`id` LEFT JOIN `choice` `c4` ON `a`.`type_id` = `c4`.`id` AND `c4`.`type` = 'additive.type' LEFT JOIN `choice_translation` `c5` ON `c4`.`id` = `c5`.`id` LEFT JOIN `choice` `c6` ON `a`.`category_id` = `c6`.`id` AND `c6`.`type` = 'additive.category' LEFT JOIN `choice_translation` `c7` ON `c6`.`id` = `c7`.`id` WHERE `a`.`id` IN (398) AND (`a`.`published_at` <= '2026-03-26' AND `a`.`id` = '398') ORDER BY `p`.`weight` desc
SELECT `a`.`id` AS `a__id`, `a`.`additive_id` AS `a__additive_id`, `a`.`field_id` AS `a__field_id`, `a`.`created_at` AS `a__created_at`, `a`.`updated_at` AS `a__updated_at`, `a`.`translated` AS `a__translated`, `a2`.`id` AS `a2__id`, `a2`.`name` AS `a2__name`, `a2`.`lang` AS `a2__lang`, `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 `additive_info` `a` LEFT JOIN `additive_info_translation` `a2` ON `a`.`id` = `a2`.`id` LEFT JOIN `field` `f` ON `a`.`field_id` = `f`.`id` LEFT JOIN `field_translation` `f2` ON `f`.`id` = `f2`.`id` WHERE (`a`.`additive_id` = 398) ORDER BY `f`.`sort`
SELECT `p`.`id` AS `p__id`, `p`.`type_id` AS `p__type_id`, `p`.`published_at` AS `p__published_at`, `p`.`user_id` AS `p__user_id`, `p`.`partner_id` AS `p__partner_id`, `p`.`image` AS `p__image`, `p`.`size` AS `p__size`, `p`.`search` AS `p__search`, `p`.`visits` AS `p__visits`, `p`.`draft` AS `p__draft`, `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`, `p`.`translated` AS `p__translated`, `p2`.`id` AS `p2__id`, `p2`.`name` AS `p2__name`, `p2`.`file` AS `p2__file`, `p2`.`description` AS `p2__description`, `p2`.`cite` AS `p2__cite`, `p2`.`version` AS `p2__version`, `p2`.`reference` AS `p2__reference`, `p2`.`legend` AS `p2__legend`, `p2`.`content` AS `p2__content`, `p2`.`content_text` AS `p2__content_text`, `p2`.`slug` AS `p2__slug`, `p2`.`lang` AS `p2__lang` FROM `paper` `p` LEFT JOIN `paper_translation` `p2` ON `p`.`id` = `p2`.`id` LEFT JOIN `paper_additive` `p3` ON `p`.`id` = `p3`.`paper_id` WHERE (`p3`.`additive_id` = 398) ORDER BY `p`.`id` desc
SELECT sum(nb) as nb FROM visit WHERE code = 'additive.398'
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`
SELECT `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 `partner` `p` ORDER BY `p`.`weight` desc, `p`.`name`