How to reduce query execution time in mysql

SELECT CONCAT(
    'SELECT `chef_orders_pending_temp`.item_id,`chef_orders_pending_temp`.itemName,`chef_orders_pending_temp`.order_date', GROUP_CONCAT('
     ,    `t_', REPLACE(Outlet_name, '`', '``'), '`.QtyRequested
         AS `', REPLACE(Outlet_name, '`', '``'), '`'
     SEPARATOR ''),
 ' FROM `chef_orders_pending_temp` ', GROUP_CONCAT('
     LEFT JOIN `chef_orders_pending_temp`   AS `t_', REPLACE(Outlet_name, '`', '``'), '`
            ON `chef_orders_pending_temp`.item_id = `t_', REPLACE(Outlet_name, '`', '``'), '`.item_id
           AND `t_', REPLACE(Outlet_name, '`', '``'), '`.Outlet_name = ', QUOTE(Outlet_name)
     SEPARATOR ''),
 ' GROUP BY `chef_orders_pending_temp`.item_id'
) INTO @qry FROM (SELECT DISTINCT Outlet_name FROM `chef_orders_pending_temp`) t;

PREPARE stmt FROM @qry;

EXECUTE stmt;