Skip to content

Instantly share code, notes, and snippets.

@dburles

dburles/gist:c4e2fa2d6ab28a766f43612b4ece12f6

Last active March 28, 2019 02:47
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dburles/c4e2fa2d6ab28a766f43612b4ece12f6 to your computer and use it in GitHub Desktop.
Save dburles/c4e2fa2d6ab28a766f43612b4ece12f6 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
Before:
Executing (default): SELECT `id` FROM `authors` AS `author` ORDER BY `author`.`createdAt` DESC;
Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `authors` AS `author` WHERE `author`.`id` IN (3, 2, 1);
Executing (default): SELECT `id` FROM `books` AS `book` WHERE `book`.`authorId` = 3 ORDER BY `book`.`createdAt` DESC;
Executing (default): SELECT `id` FROM `books` AS `book` WHERE `book`.`authorId` = 2 ORDER BY `book`.`createdAt` DESC;
Executing (default): SELECT `id` FROM `books` AS `book` WHERE `book`.`authorId` = 1 ORDER BY `book`.`createdAt` DESC;
Executing (default): SELECT `id`, `title`, `createdAt`, `updatedAt`, `authorId` FROM `books` AS `book` WHERE `book`.`id` IN (3);
Executing (default): SELECT `id`, `title`, `createdAt`, `updatedAt`, `authorId` FROM `books` AS `book` WHERE `book`.`id` IN (4);
Executing (default): SELECT `id`, `title`, `createdAt`, `updatedAt`, `authorId` FROM `books` AS `book` WHERE `book`.`id` IN (2, 1);
After:
Executing (default): SELECT `id` FROM `authors` AS `author` ORDER BY `author`.`createdAt` DESC;
Executing (default): SELECT `id`, `title`, `createdAt`, `updatedAt`, `authorId` FROM `books` AS `book` WHERE `book`.`id` IN (1);
Executing (default): SELECT `id`, `name`, `createdAt`, `updatedAt` FROM `authors` AS `author` WHERE `author`.`id` IN (3, 2, 1);
Executing (default): SELECT `id`, `title`, `createdAt`, `updatedAt`, `authorId` FROM `books` AS `book` WHERE `book`.`authorId` IN (3, 2);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment