| 1 |
1.85 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.contact_person AS contact_person_3, t0.email AS email_4, t0.phone AS phone_5, t0.address AS address_6, t0.tax_number AS tax_number_7, t0.payment_terms AS payment_terms_8, t0.website AS website_9, t0.notes AS notes_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM supplier t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.contact_person AS contact_person_3, t0.email AS email_4, t0.phone AS phone_5, t0.address AS address_6, t0.tax_number AS tax_number_7, t0.payment_terms AS payment_terms_8, t0.website AS website_9, t0.notes AS notes_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM supplier t0 WHERE t0.id = '1';
|
| 2 |
2.50 ms |
SELECT count(DISTINCT d0_.id) AS sclr_0 FROM delivery_note d0_ WHERE d0_.supplier_id = ?
SELECT count(DISTINCT d0_.id) AS sclr_0 FROM delivery_note d0_ WHERE d0_.supplier_id = 1;
|
| 3 |
0.85 ms |
SELECT DISTINCT d0_.id AS id_0, d0_.delivery_date AS delivery_date_1 FROM delivery_note d0_ WHERE d0_.supplier_id = ? ORDER BY d0_.delivery_date DESC LIMIT 5
SELECT DISTINCT d0_.id AS id_0, d0_.delivery_date AS delivery_date_1 FROM delivery_note d0_ WHERE d0_.supplier_id = 1 ORDER BY d0_.delivery_date DESC LIMIT 5;
|
| 4 |
0.99 ms |
SELECT count(DISTINCT s0_.id) AS sclr_0 FROM supplier_credit s0_ WHERE s0_.supplier_id = ?
SELECT count(DISTINCT s0_.id) AS sclr_0 FROM supplier_credit s0_ WHERE s0_.supplier_id = 1;
|
| 5 |
0.62 ms |
SELECT DISTINCT s0_.id AS id_0, s0_.date AS date_1 FROM supplier_credit s0_ WHERE s0_.supplier_id = ? ORDER BY s0_.date DESC LIMIT 10
SELECT DISTINCT s0_.id AS id_0, s0_.date AS date_1 FROM supplier_credit s0_ WHERE s0_.supplier_id = 1 ORDER BY s0_.date DESC LIMIT 10;
|
| 6 |
0.42 ms |
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.type AS type_3, t0.status AS status_4, t0.date AS date_5, t0.reference AS reference_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.supplier_id AS supplier_id_10, t0.delivery_note_id AS delivery_note_id_11, t0.supplier_payment_id AS supplier_payment_id_12 FROM supplier_credit t0 WHERE t0.supplier_id = ?
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.type AS type_3, t0.status AS status_4, t0.date AS date_5, t0.reference AS reference_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.supplier_id AS supplier_id_10, t0.delivery_note_id AS delivery_note_id_11, t0.supplier_payment_id AS supplier_payment_id_12 FROM supplier_credit t0 WHERE t0.supplier_id = 1;
|
| 7 |
0.68 ms |
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.delivery_date AS delivery_date_3, t0.status AS status_4, t0.notes AS notes_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.supplier_id AS supplier_id_8, t0.purchase_order_id AS purchase_order_id_9 FROM delivery_note t0 WHERE t0.supplier_id = ?
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.delivery_date AS delivery_date_3, t0.status AS status_4, t0.notes AS notes_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.supplier_id AS supplier_id_8, t0.purchase_order_id AS purchase_order_id_9 FROM delivery_note t0 WHERE t0.supplier_id = 1;
|
| 8 |
1.03 ms |
SELECT t0.id AS id_1, t0.garage AS garage_2, t0.currency AS currency_3, t0.date_format AS date_format_4, t0.time_format AS time_format_5, t0.notifications AS notifications_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.logo AS logo_9 FROM app_settings t0 LIMIT 1
SELECT t0.id AS id_1, t0.garage AS garage_2, t0.currency AS currency_3, t0.date_format AS date_format_4, t0.time_format AS time_format_5, t0.notifications AS notifications_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.logo AS logo_9 FROM app_settings t0 LIMIT 1;
|