1
4.32 ms
SELECT t0 . id AS id_1 , t0 . email AS email_2 , t0 . name AS name_3 , t0 . usertype AS usertype_4 , t0 . roles AS roles_5 , t0 . password AS password_6 , t0 . created_at AS created_at_7 , t0 . updated_at AS updated_at_8 , t0 . company_id AS company_id_9 , t0 . user_task_id AS user_task_id_10 FROM "user" t0 WHERE t0 . email = ? LIMIT 1
Parameters :
[
"jon@jwag.co.za "
]
SELECT t0 . id AS id_1 , t0 . email AS email_2 , t0 . name AS name_3 , t0 . usertype AS usertype_4 , t0 . roles AS roles_5 , t0 . password AS password_6 , t0 . created_at AS created_at_7 , t0 . updated_at AS updated_at_8 , t0 . company_id AS company_id_9 , t0 . user_task_id AS user_task_id_10 FROM "user" t0 WHERE t0 . email = 'jon@jwag.co.za' LIMIT 1 ;
Copy
2
8.86 ms
SELECT COUNT (t0_ . id ) AS sclr_0 FROM transit t0_
SELECT COUNT (t0_ . id ) AS sclr_0 FROM transit t0_ ;
Copy
3
2.04 ms
SELECT t0 . id AS id_1 , t0 . docid AS docid_2 , t0 . qty AS qty_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . driver_id AS driver_id_6 , t0 . inventory_id AS inventory_id_7 , t0 . fromlocation_id AS fromlocation_id_8 , t0 . tolocation_id AS tolocation_id_9 , t0 . vehicle_id AS vehicle_id_10 FROM transit t0 ORDER BY t0 . created_at DESC LIMIT 5
SELECT t0 . id AS id_1 , t0 . docid AS docid_2 , t0 . qty AS qty_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . driver_id AS driver_id_6 , t0 . inventory_id AS inventory_id_7 , t0 . fromlocation_id AS fromlocation_id_8 , t0 . tolocation_id AS tolocation_id_9 , t0 . vehicle_id AS vehicle_id_10 FROM transit t0 ORDER BY t0 . created_at DESC LIMIT 5 ;
Copy
4
0.37 ms
SELECT t0 . id AS id_1 , t0 . email AS email_2 , t0 . name AS name_3 , t0 . usertype AS usertype_4 , t0 . roles AS roles_5 , t0 . password AS password_6 , t0 . created_at AS created_at_7 , t0 . updated_at AS updated_at_8 , t0 . company_id AS company_id_9 , t0 . user_task_id AS user_task_id_10 FROM "user" t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . email AS email_2 , t0 . name AS name_3 , t0 . usertype AS usertype_4 , t0 . roles AS roles_5 , t0 . password AS password_6 , t0 . created_at AS created_at_7 , t0 . updated_at AS updated_at_8 , t0 . company_id AS company_id_9 , t0 . user_task_id AS user_task_id_10 FROM "user" t0 WHERE t0 . id = 5 ;
Copy
5
1.20 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . registration AS registration_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . driver_id AS driver_id_6 , t0 . company_id AS company_id_7 FROM vehicle t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . registration AS registration_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . driver_id AS driver_id_6 , t0 . company_id AS company_id_7 FROM vehicle t0 WHERE t0 . id = 2 ;
Copy
6
0.44 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . telephone AS telephone_4 , t0 . mobile AS mobile_5 , t0 . email AS email_6 , t0 . address AS address_7 , t0 . latitude AS latitude_8 , t0 . longitude AS longitude_9 , t0 . created_at AS created_at_10 , t0 . updated_at AS updated_at_11 , t0 . company_id AS company_id_12 FROM location t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . telephone AS telephone_4 , t0 . mobile AS mobile_5 , t0 . email AS email_6 , t0 . address AS address_7 , t0 . latitude AS latitude_8 , t0 . longitude AS longitude_9 , t0 . created_at AS created_at_10 , t0 . updated_at AS updated_at_11 , t0 . company_id AS company_id_12 FROM location t0 WHERE t0 . id = 9 ;
Copy
7
1.03 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . telephone AS telephone_4 , t0 . mobile AS mobile_5 , t0 . email AS email_6 , t0 . address AS address_7 , t0 . latitude AS latitude_8 , t0 . longitude AS longitude_9 , t0 . created_at AS created_at_10 , t0 . updated_at AS updated_at_11 , t0 . company_id AS company_id_12 FROM location t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . telephone AS telephone_4 , t0 . mobile AS mobile_5 , t0 . email AS email_6 , t0 . address AS address_7 , t0 . latitude AS latitude_8 , t0 . longitude AS longitude_9 , t0 . created_at AS created_at_10 , t0 . updated_at AS updated_at_11 , t0 . company_id AS company_id_12 FROM location t0 WHERE t0 . id = 7 ;
Copy
8
3.70 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . invtype AS invtype_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 , t0 . company_id AS company_id_7 FROM inventory t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . invtype AS invtype_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 , t0 . company_id AS company_id_7 FROM inventory t0 WHERE t0 . id = 2 ;
Copy
9
0.84 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . invtype AS invtype_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 , t0 . company_id AS company_id_7 FROM inventory t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . invtype AS invtype_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 , t0 . company_id AS company_id_7 FROM inventory t0 WHERE t0 . id = 1 ;
Copy
10
0.29 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . invtype AS invtype_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 , t0 . company_id AS company_id_7 FROM inventory t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . invtype AS invtype_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 , t0 . company_id AS company_id_7 FROM inventory t0 WHERE t0 . id = 5 ;
Copy
11
0.33 ms
SELECT t0 . id AS id_1 , t0 . email AS email_2 , t0 . name AS name_3 , t0 . usertype AS usertype_4 , t0 . roles AS roles_5 , t0 . password AS password_6 , t0 . created_at AS created_at_7 , t0 . updated_at AS updated_at_8 , t0 . company_id AS company_id_9 , t0 . user_task_id AS user_task_id_10 FROM "user" t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . email AS email_2 , t0 . name AS name_3 , t0 . usertype AS usertype_4 , t0 . roles AS roles_5 , t0 . password AS password_6 , t0 . created_at AS created_at_7 , t0 . updated_at AS updated_at_8 , t0 . company_id AS company_id_9 , t0 . user_task_id AS user_task_id_10 FROM "user" t0 WHERE t0 . id = 15 ;
Copy
12
0.20 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . registration AS registration_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . driver_id AS driver_id_6 , t0 . company_id AS company_id_7 FROM vehicle t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . registration AS registration_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . driver_id AS driver_id_6 , t0 . company_id AS company_id_7 FROM vehicle t0 WHERE t0 . id = 9 ;
Copy
13
0.24 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . telephone AS telephone_4 , t0 . mobile AS mobile_5 , t0 . email AS email_6 , t0 . address AS address_7 , t0 . latitude AS latitude_8 , t0 . longitude AS longitude_9 , t0 . created_at AS created_at_10 , t0 . updated_at AS updated_at_11 , t0 . company_id AS company_id_12 FROM location t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . telephone AS telephone_4 , t0 . mobile AS mobile_5 , t0 . email AS email_6 , t0 . address AS address_7 , t0 . latitude AS latitude_8 , t0 . longitude AS longitude_9 , t0 . created_at AS created_at_10 , t0 . updated_at AS updated_at_11 , t0 . company_id AS company_id_12 FROM location t0 WHERE t0 . id = 6 ;
Copy
14
0.21 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . telephone AS telephone_4 , t0 . mobile AS mobile_5 , t0 . email AS email_6 , t0 . address AS address_7 , t0 . latitude AS latitude_8 , t0 . longitude AS longitude_9 , t0 . created_at AS created_at_10 , t0 . updated_at AS updated_at_11 , t0 . company_id AS company_id_12 FROM location t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . telephone AS telephone_4 , t0 . mobile AS mobile_5 , t0 . email AS email_6 , t0 . address AS address_7 , t0 . latitude AS latitude_8 , t0 . longitude AS longitude_9 , t0 . created_at AS created_at_10 , t0 . updated_at AS updated_at_11 , t0 . company_id AS company_id_12 FROM location t0 WHERE t0 . id = 4 ;
Copy