In case you have your own slow SQL query, you can optimize it automatically here.
For the query above, the following recommendations will be helpful as part of the SQL tuning process.
You'll find 3 sections below:
ALTER TABLE `child1` ADD INDEX `child1_idx_parentid` (`parentID`);
ALTER TABLE `child2` ADD INDEX `child2_idx_parentid` (`parentID`);
ALTER TABLE `child3` ADD INDEX `child3_idx_parentid` (`parentID`);
ALTER TABLE `parent` ADD INDEX `parent_idx_parentid` (`parentID`);
SELECT
child1.child1ID,
child2.child2ID,
child3.child3ID
FROM
parent
LEFT JOIN
child1
ON child1.parentID = parent.parentID,
LEFT JOIN
child2
ON child2.parentID = parent.parentID,
LEFT JOIN
child3
ON child3.parentID = parent.parentID
WHERE
parent.parentID = 1