# |
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 "action_i18n" (/:sf_culture/:module/:action.:sf_format) for /en/additive/index.html with parameters array ( 'module' => 'additive', 'action' => 'index', 'sf_culture' => 'en', 'sf_format' => 'html',) |
20 | sfFilterChain | Executing filter "sfRenderingFilter" |
21 | sfFilterChain | Executing filter "I18nFilter" |
22 | Doctrine_Connection_Mysql | exec : SET NAMES 'utf8mb4' - () |
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 "sfExecutionFilter" |
25 | additiveActions | Call "additiveActions->executeIndex()" |
26 | Doctrine_Connection_Statement | execute : SELECT `u`.`id` AS `u__id`, `u`.`name` AS `u__name`, `u`.`type` AS `u__type` FROM `user` `u` WHERE (`u`.`type` IN (?, ?)) ORDER BY `u`.`type`, `u`.`name` - (admin, writer) |
27 | Doctrine_Connection_Statement | execute : 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`.`manufacturer_id` IN (?, ?, ?, ?)) - (40, 33, 5, 130) |
28 | Doctrine_Connection_Statement | execute : 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`.`manufacturer_id` IN (?, ?, ?, ?) ORDER BY `p3`.`weight` is null, if(`p3`.`weight`, `p3`.`weight` * rand(), null), `a2`.`logo` is null, `c2`.`logo` is null, `a2`.`name` LIMIT 15 - (40, 33, 5, 130) |
29 | Doctrine_Connection_Statement | execute : 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 (845, 846, 844, 32, 57, 36, 35, 37, 801, 802, 38, 39, 40, 41, 42) AND (`a`.`manufacturer_id` IN (?, ?, ?, ?)) ORDER BY `p`.`weight` is null, if(`p`.`weight`, `p`.`weight` * rand(), null), `a`.`logo` is null, `c`.`logo` is null, `a`.`name` - (40, 33, 5, 130) |
30 | 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`.`manufacturer_id` AS `a__manufacturer_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`.`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`.`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`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) ORDER BY field(`a`.`id`, 845, 846, 844, 32, 57, 36, 35, 37, 801, 802, 38, 39, 40, 41, 42) - (845, 846, 844, 32, 57, 36, 35, 37, 801, 802, 38, 39, 40, 41, 42) |
31 | Doctrine_Connection_Statement | execute : SELECT `c`.`id` AS `c__id`, COUNT(distinct `a`.`id`) AS `a__0` FROM `choice` `c` LEFT JOIN `additive` `a` ON `c`.`id` = `a`.`family_id` WHERE (`a`.`family_id` is not null AND `a`.`manufacturer_id` IN (?, ?, ?, ?) AND (`c`.`type` = 'additive.family')) GROUP BY `c`.`id` ORDER BY `c`.`sort` - (40, 33, 5, 130) |
32 | Doctrine_Connection_Mysql | query : SELECT `c`.`id` AS `c__id`, `c`.`name` AS `c__name`, COUNT(distinct `a`.`id`) AS `a__0` FROM `company` `c` LEFT JOIN `additive` `a` ON `c`.`id` = `a`.`manufacturer_id` WHERE (`a`.`manufacturer_id` is not null) GROUP BY `c`.`id` ORDER BY `c`.`name` - () |
33 | Doctrine_Connection_Statement | execute : SELECT `c`.`id` AS `c__id`, COUNT(distinct `a`.`id`) AS `a__0` FROM `choice` `c` LEFT JOIN `additive` `a` ON `c`.`id` = `a`.`type_id` WHERE (`a`.`type_id` is not null AND `a`.`manufacturer_id` IN (?, ?, ?, ?) AND (`c`.`type` = 'additive.type')) GROUP BY `c`.`id` ORDER BY `c`.`sort` - (40, 33, 5, 130) |
34 | Doctrine_Connection_Statement | execute : SELECT `c`.`id` AS `c__id`, COUNT(distinct `a`.`id`) AS `a__0` FROM `choice` `c` LEFT JOIN `additive` `a` ON `c`.`id` = `a`.`category_id` WHERE (`a`.`category_id` is not null AND `a`.`manufacturer_id` IN (?, ?, ?, ?) AND (`c`.`type` = 'additive.category')) GROUP BY `c`.`id` ORDER BY `c`.`sort` - (40, 33, 5, 130) |
35 | Doctrine_Connection_Statement | execute : SELECT `c`.`id` AS `c__id`, COUNT(distinct `a`.`id`) AS `a__0` FROM `choice` `c` LEFT JOIN `additive` `a` ON `c`.`id` = `a`.`environment_id` WHERE (`a`.`environment_id` is not null AND `a`.`manufacturer_id` IN (?, ?, ?, ?) AND (`c`.`type` = 'additive.environment')) GROUP BY `c`.`id` ORDER BY `c`.`sort` - (40, 33, 5, 130) |
36 | Doctrine_Connection_Statement | execute : SELECT DISTINCT `f3`.`id` FROM `field` `f3` LEFT JOIN `field_translation` `f4` ON `f3`.`id` = `f4`.`id` WHERE `f3`.`model` = ? AND `f3`.`id` = ? LIMIT 1 - (Additive, years-of-field-experience) |
37 | Doctrine_Connection_Statement | execute : 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` = ? AND `f`.`id` = ?) - (Additive, years-of-field-experience) |
38 | Doctrine_Connection_Statement | execute : 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` = ?) ORDER BY `f`.`sort` - (Additive) |
39 | sfPHPView | Render "sf_app_dir/modules/additive/templates/indexSuccess.php" |
40 | main | Get slot "meta" |
41 | main | Set slot "meta" |
42 | sfPartialView | Render "sf_app_dir/modules/default/templates/_authenticate.php" |
43 | sfPartialView | Render "sf_app_dir/modules/additive/templates/_filter.php" |
44 | Doctrine_Connection_Mysql | query : 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` - () |
45 | sfPartialView | Render "sf_app_dir/modules/additive/templates/_filter.php" |
46 | sfPartialView | Render "sf_app_dir/modules/additive/templates/_filter.php" |
47 | sfPartialView | Render "sf_app_dir/modules/additive/templates/_filter.php" |
48 | sfPartialView | Render "sf_app_dir/modules/additive/templates/_filter.php" |
49 | main | Call "additive->executeLogo()" |
50 | Doctrine_Connection_Mysql | query : 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` - () |
51 | main | Call "additive->executeLogo()" |
52 | main | Call "additive->executeLogo()" |
53 | main | Call "additive->executeLogo()" |
54 | main | Call "additive->executeLogo()" |
55 | main | Call "additive->executeLogo()" |
56 | main | Call "additive->executeLogo()" |
57 | main | Call "additive->executeLogo()" |
58 | main | Call "additive->executeLogo()" |
59 | main | Call "additive->executeLogo()" |
60 | main | Call "additive->executeLogo()" |
61 | main | Call "additive->executeLogo()" |
62 | main | Call "additive->executeLogo()" |
63 | main | Call "additive->executeLogo()" |
64 | main | Call "additive->executeLogo()" |
65 | main | Call "additive->executeLogo()" |
66 | main | Call "additive->executeLogo()" |
67 | main | Call "additive->executeLogo()" |
68 | main | Call "additive->executeLogo()" |
69 | main | Call "additive->executeLogo()" |
70 | main | Call "additive->executeLogo()" |
71 | main | Call "additive->executeLogo()" |
72 | main | Call "additive->executeLogo()" |
73 | main | Call "additive->executeLogo()" |
74 | main | Call "additive->executeLogo()" |
75 | main | Call "additive->executeLogo()" |
76 | main | Call "additive->executeLogo()" |
77 | main | Call "additive->executeLogo()" |
78 | main | Call "additive->executeLogo()" |
79 | main | Call "additive->executeLogo()" |
80 | sfPHPView | Decorate content with "sf_app_dir/templates/layout.php" |
81 | sfPHPView | Render "sf_app_dir/templates/layout.php" |
82 | main | Get slot "meta" |
83 | sfPartialView | Render "sf_app_dir/templates/_matomo.php" |
84 | main | Call "default->executeHeader()" |
85 | 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` - (2025-04-10) |
86 | sfPartialView | Render "sf_app_dir/modules/default/templates/_header.php" |
87 | main | Call "default->executeFooter()" |
88 | 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 - () |
89 | sfPartialView | Render "sf_app_dir/modules/default/templates/_footer.php" |
90 | main | Get slot "footer" |
91 | main | Call "default->executeLang()" |
92 | 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` - () |
93 | sfPartialView | Render "sf_app_dir/modules/default/templates/_lang.php" |
94 | ToolkitResponse | Send status "HTTP/1.1 200 OK" |
95 | ToolkitResponse | Send header "Content-Type: text/html; charset=utf-8" |
96 | ToolkitResponse | Send header "X-Frame-Options: SAMEORIGIN" |
97 | ToolkitResponse | Send header "X-Xss-Protection: 1" |