1 |
0.48 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.target_id AS target_id_3, t0.status AS status_4, t0.metadata AS metadata_5, t0.created_at AS created_at_6, t0.submitted_at AS submitted_at_7, t0.approved_l1_at AS approved_l1_at_8, t0.applied_at AS applied_at_9, t0.rejected_at AS rejected_at_10, t0.rejection_reason AS rejection_reason_11, t0.author_id AS author_id_12, t0.approved_l1_by_id AS approved_l1_by_id_13, t0.approved_l2_by_id AS approved_l2_by_id_14, t0.rejected_by_id AS rejected_by_id_15 FROM modification_request t0 WHERE t0.author_id IS NULL
SELECT t0.id AS id_1, t0.target AS target_2, t0.target_id AS target_id_3, t0.status AS status_4, t0.metadata AS metadata_5, t0.created_at AS created_at_6, t0.submitted_at AS submitted_at_7, t0.approved_l1_at AS approved_l1_at_8, t0.applied_at AS applied_at_9, t0.rejected_at AS rejected_at_10, t0.rejection_reason AS rejection_reason_11, t0.author_id AS author_id_12, t0.approved_l1_by_id AS approved_l1_by_id_13, t0.approved_l2_by_id AS approved_l2_by_id_14, t0.rejected_by_id AS rejected_by_id_15 FROM modification_request t0 WHERE t0.author_id IS NULL;
|
2 |
0.38 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.target_id AS target_id_3, t0.status AS status_4, t0.metadata AS metadata_5, t0.created_at AS created_at_6, t0.submitted_at AS submitted_at_7, t0.approved_l1_at AS approved_l1_at_8, t0.applied_at AS applied_at_9, t0.rejected_at AS rejected_at_10, t0.rejection_reason AS rejection_reason_11, t0.author_id AS author_id_12, t0.approved_l1_by_id AS approved_l1_by_id_13, t0.approved_l2_by_id AS approved_l2_by_id_14, t0.rejected_by_id AS rejected_by_id_15 FROM modification_request t0 WHERE t0.author_id IS NULL
SELECT t0.id AS id_1, t0.target AS target_2, t0.target_id AS target_id_3, t0.status AS status_4, t0.metadata AS metadata_5, t0.created_at AS created_at_6, t0.submitted_at AS submitted_at_7, t0.approved_l1_at AS approved_l1_at_8, t0.applied_at AS applied_at_9, t0.rejected_at AS rejected_at_10, t0.rejection_reason AS rejection_reason_11, t0.author_id AS author_id_12, t0.approved_l1_by_id AS approved_l1_by_id_13, t0.approved_l2_by_id AS approved_l2_by_id_14, t0.rejected_by_id AS rejected_by_id_15 FROM modification_request t0 WHERE t0.author_id IS NULL;
|
3 |
0.48 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.comment AS comment_3, t0.limit_amount_of_capitals AS limit_amount_of_capitals_4, t0.contract_rc AS contract_rc_5, t0.property_damage AS property_damage_6, t0.soft_deleted AS soft_deleted_7, t0.rate AS rate_8, t0.creator_user_id AS creator_user_id_9, t0.contact_person_id AS contact_person_id_10, t0.accounting_person_id AS accounting_person_id_11, t0.logo_id AS logo_id_12, t0.organization_id AS organization_id_13 FROM company t0
SELECT t0.id AS id_1, t0.name AS name_2, t0.comment AS comment_3, t0.limit_amount_of_capitals AS limit_amount_of_capitals_4, t0.contract_rc AS contract_rc_5, t0.property_damage AS property_damage_6, t0.soft_deleted AS soft_deleted_7, t0.rate AS rate_8, t0.creator_user_id AS creator_user_id_9, t0.contact_person_id AS contact_person_id_10, t0.accounting_person_id AS accounting_person_id_11, t0.logo_id AS logo_id_12, t0.organization_id AS organization_id_13 FROM company t0;
|
4 |
0.72 ms |
SELECT c0_.id AS id_0, c0_.start AS start_1, c0_.end AS end_2, c0_.number AS number_3, c0_.insurer AS insurer_4, c0_.draft AS draft_5, c0_.type AS type_6, c0_.office_id AS office_id_7 FROM contract c0_ WHERE c0_.start <= ? AND (c0_.end IS NULL OR c0_.end >= ?) AND c0_.draft = 0
Parameters: [
"2025-09-18 04:41:31"
"2025-09-18 04:41:31"
]
SELECT c0_.id AS id_0, c0_.start AS start_1, c0_.end AS end_2, c0_.number AS number_3, c0_.insurer AS insurer_4, c0_.draft AS draft_5, c0_.type AS type_6, c0_.office_id AS office_id_7 FROM contract c0_ WHERE c0_.start <= '2025-09-18 04:41:31' AND (c0_.end IS NULL OR c0_.end >= '2025-09-18 04:41:31') AND c0_.draft = 0;
|
5 |
0.50 ms |
SELECT t0.id AS id_1, t0.start AS start_2, t0.end AS end_3, t0.number AS number_4, t0.insurer AS insurer_5, t0.draft AS draft_6, t0.type AS type_7, t0.office_id AS office_id_8 FROM contract t0 WHERE t0.draft = ?
SELECT t0.id AS id_1, t0.start AS start_2, t0.end AS end_3, t0.number AS number_4, t0.insurer AS insurer_5, t0.draft AS draft_6, t0.type AS type_7, t0.office_id AS office_id_8 FROM contract t0 WHERE t0.draft = 1;
|
6 |
0.67 ms |
SELECT c0_.id AS id_0, c0_.start AS start_1, c0_.end AS end_2, c0_.number AS number_3, c0_.insurer AS insurer_4, c0_.draft AS draft_5, c0_.type AS type_6, c0_.office_id AS office_id_7 FROM contract c0_ WHERE (c0_.end IS NOT NULL AND c0_.end >= ?) AND c0_.draft = 0
Parameters: [
"2025-09-18 04:41:31"
]
SELECT c0_.id AS id_0, c0_.start AS start_1, c0_.end AS end_2, c0_.number AS number_3, c0_.insurer AS insurer_4, c0_.draft AS draft_5, c0_.type AS type_6, c0_.office_id AS office_id_7 FROM contract c0_ WHERE (c0_.end IS NOT NULL AND c0_.end >= '2025-09-18 04:41:31') AND c0_.draft = 0;
|