profiling.sql

SET profiling = 1; -- don't worry, it's per-session setting

SELECT 1
FROM `agreement`
LEFT JOIN `product1` ON (
    `agreement`.`id`=`product1`.`agreement_id`
    AND `product1`.`status` IN ('active', 'expiring')
)
LEFT JOIN `product2` ON (
    `agreement`.`id`=`product2`.`agreement_id`
    AND `product2`.`status` IN ('active', 'expiring')
)
WHERE `agreement`.customer_id = :id
GROUP BY agreement.id
HAVING count(product1.id) > 0 OR count(product2.id) > 0
LIMIT 1;

SHOW PROFILE ALL FOR QUERY 1; -- now, we show our profile in most detailed way

-- SET profiling = 0;