Created
May 1, 2012 01:14
-
-
Save merk/2564130 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT count(DISTINCT i0_.id) AS sclr0 FROM ibms_part i0_ LEFT JOIN ibms_supplier i1_ ON i0_.supplier_id = i1_.id | |
| Parameters: { } | |
| Time: 0.34 ms | |
| SELECT DISTINCT i0_.id AS id0 FROM ibms_part i0_ LEFT JOIN ibms_supplier i1_ ON i0_.supplier_id = i1_.id LIMIT 15 OFFSET 0 | |
| Parameters: { } | |
| Time: 0.35 ms | |
| SELECT i0_.id AS id0, i0_.name AS name1, i0_.dateAdded AS dateAdded2, i0_.dateUpdated AS dateUpdated3, i0_.sku AS sku4, i0_.notes AS notes5, i0_.basePrice AS basePrice6, i0_.cost AS cost7, i1_.id AS id8, i1_.name AS name9, i1_.dateAdded AS dateAdded10, i1_.dateUpdated AS dateUpdated11, i1_.abn AS abn12, i1_.accountNumber AS accountNumber13, i1_.phone AS phone14, i1_.fax AS fax15, i0_.supplier_id AS supplier_id16 FROM ibms_part i0_ LEFT JOIN ibms_supplier i1_ ON i0_.supplier_id = i1_.id WHERE i0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) | |
| Parameters: ['63', '65', '68', '70', '74', '76', '80', '82', '84', '85', '87', '90', '64', '67', '69'] |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment