Hi,

with debug (2 problematic parts as 3rd one is clarified (temp table))

1.
```
# SlowLogParser:2872 10413 # Time: 2017-08-13T18:30:33.940076+02:00
# SlowLogParser:2877 10413 Got ts 2017-08-13T18:30:33
# SlowLogParser:2872 10413 # User@Host: compservice[compservice] @ localhost []  Id: 27937
# SlowLogParser:2896 10413 Got user, host, ip compservice localhost
# SlowLogParser:2872 10413 # Schema: compservice  Last_errno: 0  Killed: 0
# SlowLogParser:2915 10413 Got some line with properties
# SlowLogParser:2872 10413 # Query_time: 21.636984  Lock_time: 0.000090  Rows_sent: 0  Rows_examined: 3764653  Rows_affected: 137
# SlowLogParser:2915 10413 Got some line with properties
# SlowLogParser:2872 10413 # Bytes_sent: 60  Tmp_tables: 0  Tmp_disk_tables: 0  Tmp_table_sizes: 0
# SlowLogParser:2915 10413 Got some line with properties
# SlowLogParser:2872 10413 # QC_Hit: No  Full_scan: No  Full_join: No  Tmp_table: No  Tmp_table_on_disk: No
# SlowLogParser:2915 10413 Got some line with properties
# SlowLogParser:2872 10413 # Filesort: No  Filesort_on_disk: No  Merge_passes: 0
# SlowLogParser:2915 10413 Got some line with properties
# SlowLogParser:2872 10413 # No InnoDB statistics available for this query
# SlowLogParser:2872 10413 SET timestamp=1502638233;
# SlowLogParser:2934 10413 Got some setting: timestamp=1502638233
# SlowLogParser:2872 10413 UPDATE `products` p SET
# SlowLogParser:2968 10413 Got the query/arg line
# SlowLogParser:2980 10413 Properties of event: $VAR1 = [
#   'cmd',
#   'Query',
#   'pos_in_log',
#   2238,
#   'ts',
#   '2017-08-13T18:30:33',
#   'user',
#   'compservice',
#   'host',
#   'localhost',
#   'ip',
#   '',
#   'Thread_id',
#   '27937',
#   'Schema',
#   'compservice',
#   'Last_errno',
#   '0',
#   'Killed',
#   '0',
#   'Query_time',
#   '21.636984',
#   'Lock_time',
#   '0.000090',
#   'Rows_sent',
#   '0',
#   'Rows_examined',
#   '3764653',
#   'Rows_affected',
#   '137',
#   'Bytes_sent',
#   '60',
#   'Tmp_tables',
#   '0',
#   'Tmp_disk_tables',
#   '0',
#   'Tmp_table_sizes',
#   '0',
#   'QC_Hit',
#   'No',
#   'Full_scan',
#   'No',
#   'Full_join',
#   'No',
#   'Tmp_table',
#   'No',
#   'Tmp_table_on_disk',
#   'No',
#   'Filesort',
#   'No',
#   'Filesort_on_disk',
#   'No',
#   'Merge_passes',
#   '0',
#   'timestamp',
#   '1502638233',
#   'arg',
#   'UPDATE `products` p SET
#     `in_stock` = (SELECT IFNULL(SUM(`in_stock`), 0) FROM `products_all` WHERE `product_id` = p.`id`),
#     `outdated` = IF(`in_stock` = 0 AND `available` = 0 AND `in_stock_date` < DATE_SUB(NOW(), INTERVAL 3 DAY), 1,
#     (SELECT IF(COUNT(*) = SUM(`outdated`), 1, 0) FROM `products_all` WHERE `product_id` = p.`id`))',
#   'bytes',
#   338
# ];
#
# Transformers:3658 10413 12E96E71A6F1820E checksum for UPDATE `products` p SET
#     `in_stock` = (SELECT IFNULL(SUM(`in_stock`), 0) FROM `products_all` WHERE `product_id` = p.`id`),
#     `outdated` = IF(`in_stock` = 0 AND `available` = 0 AND `in_stock_date` < DATE_SUB(NOW(), INTERVAL 3 DAY), 1,
#     (SELECT IF(COUNT(*) = SUM(`outdated`), 1, 0) FROM `products_all` WHERE `product_id` = p.`id`))
# Transformers:3658 10413 B2D2A19048A5540A checksum for update `products` p set `in_stock` = (select ifnull(sum(`in_stock`), ?) from `products_all` where `product_id` = p.
`id`), `outdated` = if(`in_stock` = ? and `available` = ? and `in_stock_date` < date_sub(now(), interval ? day), ?, (select if(count(*) = sum(`outdated`), ?, ?) from `prod
ucts_all` where `product_id` = p.`id`))
# ExplainAnalyzer:4664 10413 Usage for 12E96E71A6F1820E on compservice : $VAR1 = undef;
#
# pt_index_usage:6670 10413 Problem on query HASH(0x308f848) Use of uninitialized value $query in pattern match (m//) at /usr/bin/pt-index-usage line 4573, <> line 4.
#
Use of uninitialized value $query in pattern match (m//) at /usr/bin/pt-index-usage line 4573, <> line 4.


2.
# SlowLogParser:2872 10413 # Time: 2017-08-13T18:30:57.748749+02:00
# SlowLogParser:2877 10413 Got ts 2017-08-13T18:30:57
# SlowLogParser:2872 10413 # User@Host: compservice[compservice] @ localhost []  Id: 27937
# SlowLogParser:2896 10413 Got user, host, ip compservice localhost
# SlowLogParser:2872 10413 # Schema: compservice  Last_errno: 0  Killed: 0
# SlowLogParser:2915 10413 Got some line with properties
# SlowLogParser:2872 10413 # Query_time: 2.294179  Lock_time: 0.000139  Rows_sent: 0  Rows_examined: 595441  Rows_affected: 88
# SlowLogParser:2915 10413 Got some line with properties
# SlowLogParser:2872 10413 # Bytes_sent: 58  Tmp_tables: 0  Tmp_disk_tables: 0  Tmp_table_sizes: 0
# SlowLogParser:2915 10413 Got some line with properties
# SlowLogParser:2872 10413 # QC_Hit: No  Full_scan: No  Full_join: No  Tmp_table: No  Tmp_table_on_disk: No
# SlowLogParser:2915 10413 Got some line with properties
# SlowLogParser:2872 10413 # Filesort: No  Filesort_on_disk: No  Merge_passes: 0
# SlowLogParser:2915 10413 Got some line with properties
# SlowLogParser:2872 10413 # No InnoDB statistics available for this query
# SlowLogParser:2872 10413 SET timestamp=1502638257;
# SlowLogParser:2934 10413 Got some setting: timestamp=1502638257
# SlowLogParser:2872 10413 UPDATE `products` p SET `delivery_speed` = IF(
# SlowLogParser:2968 10413 Got the query/arg line
# SlowLogParser:2980 10413 Properties of event: $VAR1 = [
#   'cmd',
#   'Query',
#   'pos_in_log',
#   200758,
#   'ts',
#   '2017-08-13T18:30:57',
#   'user',
#   'compservice',
#   'host',
#   'localhost',
#   'ip',
#   '',
#   'Thread_id',
#   '27937',
#   'Schema',
#   'compservice',
#   'Last_errno',
#   '0',
#   'Killed',
#   '0',
#   'Query_time',
#   '2.294179',
#   'Lock_time',
#   '0.000139',
#   'Rows_sent',
#   '0',
#   'Rows_examined',
#   '595441',
#   'Rows_affected',
#   '88',
#   'Bytes_sent',
#   '58',
#   'Tmp_tables',
#   '0',
#   'Tmp_disk_tables',
#   '0',
#   'Tmp_table_sizes',
#   '0',
#   'QC_Hit',
#   'No',
#   'Full_scan',
#   'No',
#   'Full_join',
#   'No',
#   'Tmp_table',
#   'No',
#   'Tmp_table_on_disk',
#   'No',
#   'Filesort',
#   'No',
#   'Filesort_on_disk',
#   'No',
#   'Merge_passes',
#   '0',
#   'timestamp',
#   '1502638257',
#   'arg',
#   'UPDATE `products` p SET `delivery_speed` = IF(
#   GREATEST(
#     IFNULL((SELECT `delivery_speed` FROM `suppliers` s WHERE s.`id` = p.`sid`), 0),
#     IFNULL((SELECT `days` FROM `suppliers_delivery_speed` sds WHERE p.`cid` = sds.`cid` AND p.`sid` = sds.`sid`), 0)
#   ) = 0,
#   NULL,
#   GREATEST(
#     IFNULL((SELECT `delivery_speed` FROM `suppliers` s WHERE s.`id` = p.`sid`), 0),
#     IFNULL((SELECT `days` FROM `suppliers_delivery_speed` sds WHERE p.`cid` = sds.`cid` AND p.`sid` = sds.`sid`), 0)
#   )
# )
# WHERE `outdated` = 0',
#   'bytes',
#   516
# ];
#

# Transformers:3658 10413 F18EAE692D33E384 checksum for UPDATE `products` p SET `delivery_speed` = IF(
#   GREATEST(
#     IFNULL((SELECT `delivery_speed` FROM `suppliers` s WHERE s.`id` = p.`sid`), 0),
#     IFNULL((SELECT `days` FROM `suppliers_delivery_speed` sds WHERE p.`cid` = sds.`cid` AND p.`sid` = sds.`sid`), 0)
#   ) = 0,
#   NULL,
#   GREATEST(
#     IFNULL((SELECT `delivery_speed` FROM `suppliers` s WHERE s.`id` = p.`sid`), 0),
#     IFNULL((SELECT `days` FROM `suppliers_delivery_speed` sds WHERE p.`cid` = sds.`cid` AND p.`sid` = sds.`sid`), 0)
#   )
# )
# WHERE `outdated` = 0
# Transformers:3658 10413 E3A8DEC3FA4B5920 checksum for update `products` p set `delivery_speed` = if( greatest( ifnull((select `delivery_speed` from `suppliers` s where s
.`id` = p.`sid`), ?), ifnull((select `days` from `suppliers_delivery_speed` sds where p.`cid` = sds.`cid` and p.`sid` = sds.`sid`), ?) ) = ?, ?, greatest( ifnull((select `
delivery_speed` from `suppliers` s where s.`id` = p.`sid`), ?), ifnull((select `days` from `suppliers_delivery_speed` sds where p.`cid` = sds.`cid` and p.`sid` = sds.`sid`
), ?) ) ) where `outdated` = ?
# ExplainAnalyzer:4664 10413 Usage for F18EAE692D33E384 on compservice : $VAR1 = undef;
#
# ExplainAnalyzer:4579 10413 DBI::db=HASH(0x2ff24a8) EXPLAIN select  `delivery_speed` = IF(
#   GREATEST(
#     IFNULL((SELECT `delivery_speed` FROM `suppliers` s from `products` p where  s.`id` = p.`sid`), 0),
#     IFNULL((SELECT `days` FROM `suppliers_delivery_speed` sds WHERE p.`cid` = sds.`cid` AND p.`sid` = sds.`sid`), 0)
#   ) = 0,
#   NULL,
#   GREATEST(
#     IFNULL((SELECT `delivery_speed` FROM `suppliers` s WHERE s.`id` = p.`sid`), 0),
#     IFNULL((SELECT `days` FROM `suppliers_delivery_speed` sds WHERE p.`cid` = sds.`cid` AND p.`sid` = sds.`sid`), 0)
#   )
# )
# WHERE `outdated` = 0
# pt_index_usage:6670 10413 Problem on query HASH(0x3aa3898) DBD::mysql::db selectall_arrayref failed: You have an error in your SQL syntax; check the manual that correspo
nds to your MySQL server version for the right syntax to use near 'from `products` p where  s.`id` = p.`sid`), 0),
#     IFNULL((SELECT `days` FROM `' at line 3 [for Statement "EXPLAIN select  `delivery_speed` = IF(
#   GREATEST(
#     IFNULL((SELECT `delivery_speed` FROM `suppliers` s from `products` p where  s.`id` = p.`sid`), 0),
#     IFNULL((SELECT `days` FROM `suppliers_delivery_speed` sds WHERE p.`cid` = sds.`cid` AND p.`sid` = sds.`sid`), 0)
#   ) = 0,
#   NULL,
#   GREATEST(
#     IFNULL((SELECT `delivery_speed` FROM `suppliers` s WHERE s.`id` = p.`sid`), 0),
#     IFNULL((SELECT `days` FROM `suppliers_delivery_speed` sds WHERE p.`cid` = sds.`cid` AND p.`sid` = sds.`sid`), 0)
#   )
# )
# WHERE `outdated` = 0"] at /usr/bin/pt-index-usage line 4580, <> line 9.
#
DBD::mysql::db selectall_arrayref failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use
near 'from `products` p where  s.`id` = p.`sid`), 0),
    IFNULL((SELECT `days` FROM `' at line 3 [for Statement "EXPLAIN select  `delivery_speed` = IF(
  GREATEST(
    IFNULL((SELECT `delivery_speed` FROM `suppliers` s from `products` p where  s.`id` = p.`sid`), 0),
    IFNULL((SELECT `days` FROM `suppliers_delivery_speed` sds WHERE p.`cid` = sds.`cid` AND p.`sid` = sds.`sid`), 0)
  ) = 0,
  NULL,
  GREATEST(
    IFNULL((SELECT `delivery_speed` FROM `suppliers` s WHERE s.`id` = p.`sid`), 0),
    IFNULL((SELECT `days` FROM `suppliers_delivery_speed` sds WHERE p.`cid` = sds.`cid` AND p.`sid` = sds.`sid`), 0)
  )
)
WHERE `outdated` = 0"] at /usr/bin/pt-index-usage line 4580, <> line 9.
```


I hope this will help