| Fournisseur |
Fournisseur IterchimicaVoir information financière |
|---|---|
| Nom générique |
Nom générique Agent décontaminant pour traitement de surface |
| Famille / Type / Catégorie |
Famille / Type / Catégorie Produits routiers spéciaux / Produits décontaminants / Produits décontaminants pour NOx |
| Composition |
Composition Agent décontaminant pour traitement de surface |
Ajoutez des produits à comparer
XS SM MD LG XL
config
view
logs
8192,0 KB
668 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: '190'
module: additive
sf_culture: fr
sf_format: html
slug: IterTiO2
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: fr
title: 'IterTiO2 - Iterchimica - 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 }
visit: { additive: [1105, 349, 1619, 395, 105, 860, 165, 1510, 192, 1620, 426, 807, 423, 1506, 1511, 397, 151, 396, 1123, 358, 50, 359, 360, 256, 898, 591, 484, 49, 542, 75, 146, 1432, 588, 65, 765, 1546, 162, 759, 948, 310, 1150, 840, 44, 1753, 540, 247, 686, 877, 495, 71, 776, 772, 787, 1710, 640, 1579, 857, 945, 818, 107, 1062, 656, 367, 181, 161, 1642, 629, 749, 555, 299, 872, 1585, 683, 1646, 793, 1584, 549, 607, 786, 97, 375, 1552, 372, 424, 32, 737, 1644, 1663, 753, 958, 593, 350, 944, 949, 227, 595, 763, 1651, 702, 98, 886, 1145, 1648, 422, 48, 1621, 368, 1645, 1643, 581, 45, 632, 1647, 163, 780, 822, 246, 1650, 1112, 1580, 1653, 1061, 155, 1142, 78, 1652, 521, 178, 373, 544, 764, 554, 649, 950, 158, 562, 147, 381, 382, 1027, 1638, 237, 1640, 175, 614, 855, 918, 185, 752, 694, 652, 357, 430, 859, 96, 902, 828, 356, 951, 541, 298, 634, 183, 643, 631, 671, 839, 1649, 688, 623, 61, 751, 701, 618, 651, 378, 355, 150, 611, 915, 625, 21, 617, 53, 708, 903, 616, 369, 168, 650, 900, 630, 706, 539, 1641, 622, 626, 240, 1139, 152, 167, 628, 1143, 1103, 685, 1036, 805, 187, 627, 1109, 169, 290, 620, 141, 1102, 769, 682, 621, 774, 705, 768, 613, 766, 767, 239, 191, 665, 678, 687, 801, 297, 190], company: [110, 85, 100, 11, 138, 36, 146, 95, 17, 171, 123, 135, 82, 131, 97, 130, 112, 137, 152, 73, 13, 51, 129, 21, 59, 153, 40, 109, 108, 124, 66], page: [data], paper: [15, 26, 11, 24, 10, 19, 23, 28, 9, 22, 12, 7] }
culture: fr
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: 9akvgfkskkt1pglis58728iplj
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=9akvgfkskkt1pglis58728iplj
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/190/IterTiO2.view.html
PATH_TRANSLATED: 'redirect:/index.php/additive/190/IterTiO2.view.html'
PHP_SELF: /public_dev.php/fr/additive/190/IterTiO2.view.html
QUERY_STRING: ''
REMOTE_ADDR: 216.73.216.107
REMOTE_PORT: '42634'
REQUEST_METHOD: GET
REQUEST_SCHEME: http
REQUEST_TIME: 1775005238
REQUEST_TIME_FLOAT: 1775005238.3367
REQUEST_URI: /public_dev.php/fr/additive/190/IterTiO2.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: acxuNn67jTmReIaI5EyYSQAAAAI
USER: roadmat
proxy-nokeepalive: '1'
session:
symfony/user/sfUser/attributes: { symfony/user/sfUser/attributes: { culture: true }, visit: { paper: [15, 26, 11, 24, 10, 19, 23, 28, 9, 22, 12, 7], company: [110, 85, 100, 11, 138, 36, 146, 95, 17, 171, 123, 135, 82, 131, 97, 130, 112, 137, 152, 73, 13, 51, 129, 21, 59, 153, 40, 109, 108, 124, 66], additive: [1105, 349, 1619, 395, 105, 860, 165, 1510, 192, 1620, 426, 807, 423, 1506, 1511, 397, 151, 396, 1123, 358, 50, 359, 360, 256, 898, 591, 484, 49, 542, 75, 146, 1432, 588, 65, 765, 1546, 162, 759, 948, 310, 1150, 840, 44, 1753, 540, 247, 686, 877, 495, 71, 776, 772, 787, 1710, 640, 1579, 857, 945, 818, 107, 1062, 656, 367, 181, 161, 1642, 629, 749, 555, 299, 872, 1585, 683, 1646, 793, 1584, 549, 607, 786, 97, 375, 1552, 372, 424, 32, 737, 1644, 1663, 753, 958, 593, 350, 944, 949, 227, 595, 763, 1651, 702, 98, 886, 1145, 1648, 422, 48, 1621, 368, 1645, 1643, 581, 45, 632, 1647, 163, 780, 822, 246, 1650, 1112, 1580, 1653, 1061, 155, 1142, 78, 1652, 521, 178, 373, 544, 764, 554, 649, 950, 158, 562, 147, 381, 382, 1027, 1638, 237, 1640, 175, 614, 855, 918, 185, 752, 694, 652, 357, 430, 859, 96, 902, 828, 356, 951, 541, 298, 634, 183, 643, 631, 671, 839, 1649, 688, 623, 61, 751, 701, 618, 651, 378, 355, 150, 611, 915, 625, 21, 617, 53, 708, 903, 616, 369, 168, 650, 900, 630, 706, 539, 1641, 622, 626, 240, 1139, 152, 167, 628, 1143, 1103, 685, 1036, 805, 187, 627, 1109, 169, 290, 620, 141, 1102, 769, 682, 621, 774, 705, 768, 613, 766, 767, 239, 191, 665, 678, 687, 801, 297, 190], page: [data] } }
symfony/user/sfUser/authenticated: false
symfony/user/sfUser/credentials: { }
symfony/user/sfUser/culture: es
symfony/user/sfUser/lastRequest: 1775005238
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 /fr/additive/190/IterTiO2.view.html with parameters array ( 'module' => 'additive', 'action' => 'view', 'sf_culture' => 'fr', 'id' => '190', 'slug' => 'IterTiO2', '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-04-01, 190) |
| 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 (190) AND (`a`.`published_at` <= ? AND `a`.`id` = ?) ORDER BY `p`.`weight` desc - (2026-04-01, 190) |
| 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` - (190) |
| 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 - (190) |
| 31 | myViewCacheManager | Cache for "additive/view?id=190&sf_culture=fr&sf_format=html&slug=IterTiO2" 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=35d65201d5848938ec97bee78e3ab5d2" 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=3f47f67c2635d26556788d072e50f32e" does not exist |
| 44 | main | Call "visit->executeCount()" |
| 45 | Doctrine_Connection_Statement | execute : SELECT sum(nb) as nb FROM visit WHERE code = ? - (additive.190) |
| 46 | myViewCacheManager | Cache for "@sf_cache_partial?module=visit&action=_count&sf_cache_key=3f47f67c2635d26556788d072e50f32e" 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=3f47f67c2635d26556788d072e50f32e" |
| 49 | myViewCacheManager | Generate cache key |
| 50 | myViewCacheManager | Cache for "@sf_cache_partial?module=visit&action=_tracker&sf_cache_key=3f47f67c2635d26556788d072e50f32e" 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=3f47f67c2635d26556788d072e50f32e" |
| 53 | myViewCacheManager | Save cache for "additive/view?id=190&sf_culture=fr&sf_format=html&slug=IterTiO2" |
| 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-04-01) |
| 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 | 17,44 | 2 |
| Factories | 1 | 591,54 | 88 |
| Database (Doctrine) | 9 | 5,71 | 0 |
| Action "additive/view" | 1 | 37,06 | 5 |
| View "Success" for "additive/view" | 1 | 27,23 | 4 |
| Partial "default/_authenticate" | 1 | 2,73 | 0 |
| Component "additive/logo" | 1 | 0,05 | 0 |
| Component "visit/count" | 1 | 0,54 | 0 |
| Partial "visit/_count" | 1 | 1,86 | 0 |
| Partial "visit/_tracker" | 1 | 3,68 | 0 |
| Partial "global/_matomo" | 1 | 1,62 | 0 |
| Component "default/header" | 1 | 3,21 | 0 |
| Partial "default/_header" | 1 | 0,37 | 0 |
| Component "default/footer" | 1 | 0,68 | 0 |
| Partial "default/_footer" | 1 | 2,05 | 0 |
| Component "default/lang" | 1 | 0,09 | 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-04-01' AND `a2`.`id` = '190' 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 (190) AND (`a`.`published_at` <= '2026-04-01' AND `a`.`id` = '190') 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` = 190) 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` = 190) ORDER BY `p`.`id` desc
SELECT sum(nb) as nb FROM visit WHERE code = 'additive.190'
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-04-01') 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`