For example (file: nodereview_node_nodereview.inc):

/**
 * Implements of hook_load().
 */
function nodereview_load($nodes) {
  foreach ($nodes as &$node) {

On every node load an extra query is executed to check if the current node is a review. This should be limited to the 'nodereview' content type.