update orders set last_modified_by = 'system', last_modified_date = '2024-01-02 13:58:09.385', order_charge_paid_history_list = '[{"paid": false, "userId": 683802998, "timestamp": 1704203886.042}, {"paid": false, "userId": 683802998, "timestamp": 1704203886.235}]' where id = '1341812579';

Date: 2024-01-02 14:00:24
Database: safearrival
User: safearrival client=10.0.0.133
Remote: 10.0.0.133
Bind query: yes

update orders set last_modified_by = 'anonymous', last_modified_date = '2024-01-02 13:58:11.368', order_charge_paid_history_list = '[{"paid": false, "userId": 683802998, "timestamp": 1704203886.042}, {"paid": false, "userId": 683802998, "timestamp": 1704203886.235}]' where id = '1341812579';

Date: 2024-01-02 14:00:24
Database: safearrival
User: safearrival client=10.0.0.132
Remote: 10.0.0.132
Bind query: yes

update orders set last_modified_by = 'system', last_modified_date = '2024-01-02 13:58:08.396', order_charge_paid_history_list = '[{"paid": false, "userId": 683802998, "timestamp": 1704203886.042}, {"paid": false, "userId": 683802998, "timestamp": 1704203886.235}]' where id = '1341812579';

Date: 2024-01-02 14:00:14
Database: safearrival
User: safearrival client=10.0.0.132
Remote: 10.0.0.132
Bind query: yes

x Hide

update orders set last_modified_by = 'system', last_modified_date = '2024-01-02 11:08:07.371', physical_pickup_attempts = '[{"userId": 645512267, "timestamp": 1704193683.893, "supplierId": 648753371, "orderStatus": "picked_up_auto", "escalationStatus": null}]' where id = '1341502849';

Date: 2024-01-02 11:09:35
Database: safearrival
User: safearrival client=10.0.0.132
Remote: 10.0.0.132
Bind query: yes

update orders set last_modified_by = 'anonymous', last_modified_date = '2024-01-02 11:08:09.41', physical_pickup_attempts = '[{"userId": 645512267, "timestamp": 1704193683.893, "supplierId": 648753371, "orderStatus": "picked_up_auto", "escalationStatus": null}]' where id = '1341502849';

Date: 2024-01-02 11:09:35
Database: safearrival
User: safearrival client=10.0.0.133
Remote: 10.0.0.133
Bind query: yes

update orders set last_modified_by = 'anonymous', last_modified_date = '2024-01-02 10:45:45.095', physical_pickup_attempts = '[{"userId": 1146256954, "timestamp": 1704192339.884, "supplierId": 638465090, "orderStatus": "picked_up", "escalationStatus": null}]' where id = '1340945533';

Date: 2024-01-02 10:46:00
Database: safearrival
User: safearrival client=10.0.0.133
Remote: 10.0.0.133
Bind query: yes

x Hide

update orders set last_modified_by = 'anonymous', last_modified_date = '2024-01-02 13:58:08.621', order_charge_paid_history_list = '[{"paid": false, "userId": 683802998, "timestamp": 1704203886.042}, {"paid": false, "userId": 683802998, "timestamp": 1704203886.235}]', recipient_id = '1341812625' where id = '1341812579';

Date: 2024-01-02 14:00:24
Database: safearrival
User: safearrival client=10.0.0.133
Remote: 10.0.0.133
Bind query: yes

update orders set last_modified_by = 'anonymous', last_modified_date = '2024-01-02 14:41:47.035', order_charge_paid_history_list = '[{"paid": false, "userId": 683802998, "timestamp": 1704206503.717}, {"paid": false, "userId": 683802998, "timestamp": 1704206504.348}]', recipient_id = '1341844642' where id = '1341844605';

Date: 2024-01-02 14:42:11
Database: safearrival
User: safearrival client=10.0.0.133
Remote: 10.0.0.133
Bind query: yes

update orders set last_modified_by = 'anonymous', last_modified_date = '2024-01-02 15:15:05.858', order_charge_paid_history_list = '[{"paid": false, "userId": 683802998, "timestamp": 1704208503.244}, {"paid": false, "userId": 683802998, "timestamp": 1704208503.469}]', recipient_id = '736879156' where id = '1341869561';

Date: 2024-01-02 15:15:20
Database: safearrival
User: safearrival client=10.0.0.133
Remote: 10.0.0.133
Bind query: yes

x Hide

update orders set last_modified_by = 'system', last_modified_date = '2024-01-02 13:22:23.347', order_charge_paid_history_list = '[{"paid": true, "userId": 654832899, "timestamp": 1704170482.53}, {"paid": true, "userId": 654832899, "timestamp": 1704170482.658}]', physical_pickup_attempts = '[{"userId": 802144983, "timestamp": 1704201727.423, "supplierId": 648752026, "orderStatus": "picked_up_auto", "escalationStatus": null}]' where id = '1341453844';

Date: 2024-01-02 13:23:03
Database: safearrival
User: safearrival client=10.0.0.133
Remote: 10.0.0.133
Bind query: yes

update orders set last_modified_by = 'system', last_modified_date = '2024-01-02 13:22:23.419', order_charge_paid_history_list = '[{"paid": true, "userId": 654832899, "timestamp": 1704170482.53}, {"paid": true, "userId": 654832899, "timestamp": 1704170482.658}]', physical_pickup_attempts = '[{"userId": 802144983, "timestamp": 1704201727.423, "supplierId": 648752026, "orderStatus": "picked_up_auto", "escalationStatus": null}]' where id = '1341453844';

Date: 2024-01-02 13:23:03
Database: safearrival
User: safearrival client=10.0.0.133
Remote: 10.0.0.133
Bind query: yes

update orders set last_modified_by = 'system', last_modified_date = '2024-01-02 08:50:59.209', order_charge_paid_history_list = '[{"paid": true, "userId": 655476937, "timestamp": 1704137642.357}, {"paid": true, "userId": 655476937, "timestamp": 1704137642.535}]', physical_pickup_attempts = '[{"userId": 1266705040, "timestamp": 1704179047.098, "supplierId": 638464150, "orderStatus": "picked_up", "escalationStatus": null}]' where id = '1341278818';

Date: 2024-01-02 08:51:16
Database: safearrival
User: safearrival client=10.0.0.132
Remote: 10.0.0.132
Bind query: yes

x Hide

update orders set last_modified_date = '2024-01-02 18:16:16.237', order_charge_paid_history_list = '[{"paid": false, "userId": 1020830836, "timestamp": 1704219370.9}, {"paid": false, "userId": 1020830836, "timestamp": 1704219371.101}]' where id = '1342005426';

Date: 2024-01-02 18:16:41
Database: safearrival
User: safearrival client=10.0.0.133
Remote: 10.0.0.133
Bind query: yes

update orders set last_modified_date = '2024-01-02 18:16:21.269', order_charge_paid_history_list = '[{"paid": false, "userId": 1020830836, "timestamp": 1704219370.9}, {"paid": false, "userId": 1020830836, "timestamp": 1704219371.101}]' where id = '1342005426';

Date: 2024-01-02 18:16:41
Database: safearrival
User: safearrival client=10.0.0.133
Remote: 10.0.0.133
Bind query: yes

update orders set last_modified_date = '2024-01-02 15:15:06.766', order_charge_paid_history_list = '[{"paid": false, "userId": 683802998, "timestamp": 1704208503.244}, {"paid": false, "userId": 683802998, "timestamp": 1704208503.469}]' where id = '1341869561';

Date: 2024-01-02 15:15:20
Database: safearrival
User: safearrival client=10.0.0.133
Remote: 10.0.0.133
Bind query: yes

x Hide

update orders set last_modified_by = 'system', last_modified_date = '2024-01-02 12:31:59.802', order_charge_paid_history_list = '[{"paid": true, "userId": 775788263, "timestamp": 1704106866.651}, {"paid": true, "userId": 775788263, "timestamp": 1704106866.858}]', physical_pickup_attempts = '[{"userId": 802144983, "timestamp": 1704112485.696, "supplierId": 648752026, "orderStatus": "picked_up_auto", "escalationStatus": null}]', prefix_history = '[{"userId": null, "newPrefix": "JED302", "oldPrefix": "JED100", "timestamp": 1704108646.45}, {"userId": null, "newPrefix": "JED302", "oldPrefix": "JED302", "timestamp": 1704108647.286}, {"userId": null, "newPrefix": "JED302", "oldPrefix": "JED302", "timestamp": 1704186679.637}, {"userId": null, "newPrefix": "JED302", "oldPrefix": "JED302", "timestamp": 1704186680.549}]' where id = '1340904099';

Date: 2024-01-02 12:32:42
Database: safearrival
User: safearrival client=10.0.0.133
Remote: 10.0.0.133
Bind query: yes

update orders set last_modified_by = 'system', last_modified_date = '2024-01-02 16:47:32.94', order_charge_paid_history_list = '[{"paid": false, "userId": 683802998, "timestamp": 1704117770.377}, {"paid": false, "userId": 683802998, "timestamp": 1704117770.538}]', physical_pickup_attempts = '[{"userId": 802162478, "timestamp": 1704214050.827, "supplierId": 648753577, "orderStatus": "picked_up_auto", "escalationStatus": null}]', prefix_history = '[{"userId": 631889486, "newPrefix": "ABH442", "oldPrefix": "ABH442", "timestamp": 1704118139.85}]' where id = '1341042182';

Date: 2024-01-02 16:48:04
Database: safearrival
User: safearrival client=10.0.0.132
Remote: 10.0.0.132
Bind query: yes

update orders set last_modified_by = 'system', last_modified_date = '2024-01-02 16:47:32.947', order_charge_paid_history_list = '[{"paid": false, "userId": 683802998, "timestamp": 1704117770.377}, {"paid": false, "userId": 683802998, "timestamp": 1704117770.538}]', physical_pickup_attempts = '[{"userId": 802162478, "timestamp": 1704214050.827, "supplierId": 648753577, "orderStatus": "picked_up_auto", "escalationStatus": null}]', prefix_history = '[{"userId": 631889486, "newPrefix": "ABH442", "oldPrefix": "ABH442", "timestamp": 1704118139.85}]' where id = '1341042182';

Date: 2024-01-02 16:48:04
Database: safearrival
User: safearrival client=10.0.0.133
Remote: 10.0.0.133
Bind query: yes

x Hide

update orders set last_modified_by = 'system', last_modified_date = '2024-01-02 06:12:12.587', order_charge_paid_history_list = '[{"paid": false, "userId": 1020830836, "timestamp": 1702105739.762}, {"paid": false, "userId": 1020830836, "timestamp": 1702105739.901}]', physical_delivery_attempts = '[{"userId": 1195029901, "timestamp": 1702900824.791, "supplierId": 638465814, "orderStatus": "future_delivery_requested", "escalationStatus": null}, {"userId": 1269660764, "timestamp": 1703684343.819, "supplierId": 638465814, "orderStatus": "future_delivery_requested", "escalationStatus": null}, {"userId": 1249030358, "timestamp": 1704108833.684, "supplierId": 638465814, "orderStatus": "delivery_rejected", "escalationStatus": null}]', physical_pickup_attempts = '[{"userId": 802162478, "timestamp": 1702491418.734, "supplierId": 648753577, "orderStatus": "picked_up_auto", "escalationStatus": null}]', prefix_history = '[{"userId": 631889486, "newPrefix": "JIZ329", "oldPrefix": "JIZ329", "timestamp": 1702106164.081}]' where id = '1325028059';

Date: 2024-01-02 06:13:02
Database: safearrival
User: safearrival client=10.0.0.132
Remote: 10.0.0.132
Bind query: yes

update orders set last_modified_by = 'a.awadh@safe-arrival.com', last_modified_date = '2024-01-02 07:55:37.524', order_charge_paid_history_list = '[{"paid": true, "userId": 707383933, "timestamp": 1704019975.77}, {"paid": true, "userId": 707383933, "timestamp": 1704019975.947}]', physical_delivery_attempts = '[{"userId": 930815529, "timestamp": 1704135846.75, "supplierId": 638462369, "orderStatus": "recipient_mobile_no_response", "escalationStatus": null}]', physical_pickup_attempts = '[{"userId": 802162478, "timestamp": 1704028416.979, "supplierId": 648753577, "orderStatus": "picked_up_auto", "escalationStatus": null}]', prefix_history = '[{"userId": 631889486, "newPrefix": "QSM314", "oldPrefix": "QSM100", "timestamp": 1704028385.985}]' where id = '1340179957';

Date: 2024-01-02 07:55:50
Database: safearrival
User: safearrival client=10.0.0.133
Remote: 10.0.0.133
Bind query: yes

update orders set last_modified_by = 'system', last_modified_date = '2024-01-02 21:49:37.902', order_charge_paid_history_list = '[{"paid": false, "userId": 1020830836, "timestamp": 1701425826.19}, {"paid": false, "userId": 1020830836, "timestamp": 1701425826.369}]', physical_delivery_attempts = '[{"userId": 976985783, "timestamp": 1701620799.921, "supplierId": 638462369, "orderStatus": "out_of_delivery_area", "escalationStatus": null}, {"userId": 1286352981, "timestamp": 1702199794.981, "supplierId": 638463930, "orderStatus": "recipient_address_change_requested", "escalationStatus": null}, {"userId": 985601275, "timestamp": 1702921782.687, "supplierId": 638459779, "orderStatus": "office_closed", "escalationStatus": null}, {"userId": 991597450, "timestamp": 1703527478.84, "supplierId": 638459779, "orderStatus": "planned_delivery_for_tomorrow", "escalationStatus": null}]', physical_pickup_attempts = '[{"userId": 802162478, "timestamp": 1701449800.334, "supplierId": 648753577, "orderStatus": "picked_up_auto", "escalationStatus": null}]', prefix_history = '[{"userId": 631889486, "newPrefix": "HFR304", "oldPrefix": "QSM310", "timestamp": 1701629262.529}, {"userId": 631889486, "newPrefix": "DMM433", "oldPrefix": "HFR304", "timestamp": 1702200573.197}]' where id = '1319313203';

Date: 2024-01-02 21:49:45
Database: safearrival
User: safearrival client=10.0.0.133
Remote: 10.0.0.133
Bind query: yes

x Hide

update orders set last_modified_by = $1, last_modified_date = $2, cod_status = $3, cod_status_updated_by = $4, last_cod_status_date = $5, last_status_date = $6, physical_pickup_attempts = $7, status = $8, supplier_id = $9 where id = $10;

Date: 2024-01-02 11:09:35
Database: safearrival
User: safearrival client=10.0.0.133
Remote: 10.0.0.133

x Hide

update orders set last_modified_by = 'system', last_modified_date = '2024-01-02 09:11:02.298', order_charge_paid_history_list = '[{"paid": true, "userId": 707383933, "timestamp": 1703746314.934}, {"paid": true, "userId": 707383933, "timestamp": 1703746315.128}]', physical_delivery_attempts = '[{"userId": 1017388750, "timestamp": 1703945462.419, "supplierId": 638464150, "orderStatus": "completed", "escalationStatus": null}]', physical_pickup_attempts = '[{"userId": 802162478, "timestamp": 1703766372.006, "supplierId": 648753577, "orderStatus": "picked_up_auto", "escalationStatus": null}]' where id = '1338447960';

Date: 2024-01-02 09:11:36
Database: safearrival
User: safearrival client=10.0.0.133
Remote: 10.0.0.133
Bind query: yes

update orders set last_modified_by = 'system', last_modified_date = '2024-01-02 09:11:04.202', order_charge_paid_history_list = '[{"paid": true, "userId": 707383933, "timestamp": 1703746314.934}, {"paid": true, "userId": 707383933, "timestamp": 1703746315.128}]', physical_delivery_attempts = '[{"userId": 1017388750, "timestamp": 1703945462.419, "supplierId": 638464150, "orderStatus": "completed", "escalationStatus": null}]', physical_pickup_attempts = '[{"userId": 802162478, "timestamp": 1703766372.006, "supplierId": 648753577, "orderStatus": "picked_up_auto", "escalationStatus": null}]' where id = '1338447960';

Date: 2024-01-02 09:11:36
Database: safearrival
User: safearrival client=10.0.0.133
Remote: 10.0.0.133
Bind query: yes

update orders set last_modified_by = 'system', last_modified_date = '2024-01-02 10:36:26.228', order_charge_paid_history_list = '[{"paid": false, "userId": 1020830836, "timestamp": 1703091797.464}, {"paid": false, "userId": 1020830836, "timestamp": 1703091797.731}, {"paid": true, "userId": 1009856078, "timestamp": 1703686427.458}]', physical_delivery_attempts = '[{"userId": 1067062934, "timestamp": 1703509733.051, "supplierId": 638462680, "orderStatus": "future_delivery_requested", "escalationStatus": null}, {"userId": 1009856078, "timestamp": 1703686435.899, "supplierId": 638462680, "orderStatus": "completed", "escalationStatus": null}]', physical_pickup_attempts = '[{"userId": 802162478, "timestamp": 1703175766.746, "supplierId": 648753577, "orderStatus": "picked_up_auto", "escalationStatus": null}]' where id = '1333801136';

Date: 2024-01-02 10:36:29
Database: safearrival
User: safearrival client=10.0.0.132
Remote: 10.0.0.132
Bind query: yes

x Hide

update orders set last_modified_date = '2024-01-02 09:50:40.013', order_charge_paid_history_list = '[{"paid": false, "userId": 1020830836, "timestamp": 1704028443.122}, {"paid": false, "userId": 1020830836, "timestamp": 1704028444.229}]', physical_pickup_attempts = '[{"userId": 802162478, "timestamp": 1704131671.318, "supplierId": 648753577, "orderStatus": "picked_up_auto", "escalationStatus": null}]', prefix_history = '[{"userId": 631889486, "newPrefix": "ABH444", "oldPrefix": "ABH444", "timestamp": 1704028620.835}]' where id = '1340273760';

Date: 2024-01-02 09:51:30
Database: safearrival
User: safearrival client=10.0.0.132
Remote: 10.0.0.132
Bind query: yes

update orders set last_modified_date = '2024-01-02 20:25:54.556', order_charge_paid_history_list = '[{"paid": false, "userId": 683802998, "timestamp": 1704123341.985}, {"paid": false, "userId": 683802998, "timestamp": 1704123342.584}]', physical_pickup_attempts = '[{"userId": 802162478, "timestamp": 1704215603.863, "supplierId": 648753577, "orderStatus": "picked_up_auto", "escalationStatus": null}]', prefix_history = '[{"userId": 631889486, "newPrefix": "RUH576", "oldPrefix": "RUH100", "timestamp": 1704179007.979}]' where id = '1341119942';

Date: 2024-01-02 20:26:24
Database: safearrival
User: safearrival client=10.0.0.133
Remote: 10.0.0.133
Bind query: yes

update orders set last_modified_date = '2024-01-02 14:05:35.463', order_charge_paid_history_list = '[{"paid": false, "userId": 1020830836, "timestamp": 1703944084.58}, {"paid": false, "userId": 1020830836, "timestamp": 1703944085.014}]', physical_pickup_attempts = '[{"userId": 802162478, "timestamp": 1703963063.849, "supplierId": 648753577, "orderStatus": "picked_up_auto", "escalationStatus": null}]', prefix_history = '[{"userId": 631889486, "newPrefix": "QSM313", "oldPrefix": "QSM100", "timestamp": 1704129334.646}]' where id = '1339573574';

Date: 2024-01-02 14:06:05
Database: safearrival
User: safearrival client=10.0.0.132
Remote: 10.0.0.132
Bind query: yes

x Hide

update orders set last_modified_date = '2024-01-02 22:00:39.843', order_charge_paid_history_list = '[{"paid": false, "userId": 1020830836, "timestamp": 1703242074.5}, {"paid": false, "userId": 1020830836, "timestamp": 1703242131.85}]', physical_delivery_attempts = '[{"userId": 991597450, "timestamp": 1703706556.069, "supplierId": 638459779, "orderStatus": "planned_delivery_for_tomorrow", "escalationStatus": null}, {"userId": 985601275, "timestamp": 1704039071.706, "supplierId": 638459779, "orderStatus": "office_closed", "escalationStatus": null}]', physical_pickup_attempts = '[{"userId": 802162478, "timestamp": 1703527076.188, "supplierId": 648753577, "orderStatus": "picked_up_auto", "escalationStatus": null}]' where id = '1334815338';

Date: 2024-01-02 22:00:55
Database: safearrival
User: safearrival client=10.0.0.133
Remote: 10.0.0.133
Bind query: yes

update orders set last_modified_date = '2024-01-02 13:46:45.123', order_charge_paid_history_list = '[{"paid": false, "userId": 683802998, "timestamp": 1703460334.226}, {"paid": false, "userId": 683802998, "timestamp": 1703460334.355}, {"paid": true, "userId": 1331955578, "timestamp": 1704203192.402}]', physical_delivery_attempts = '[{"userId": 931341383, "timestamp": 1703771182.803, "supplierId": 638465751, "orderStatus": "recipient_mobile_no_response", "escalationStatus": null}, {"userId": 1333479411, "timestamp": 1704048961.147, "supplierId": 638465751, "orderStatus": "future_delivery_requested", "escalationStatus": null}, {"userId": 1331955578, "timestamp": 1704203199.908, "supplierId": 638465751, "orderStatus": "completed", "escalationStatus": null}]', physical_pickup_attempts = '[{"userId": 802162478, "timestamp": 1703618228.534, "supplierId": 648753577, "orderStatus": "picked_up_auto", "escalationStatus": null}]' where id = '1336368875';

Date: 2024-01-02 13:46:57
Database: safearrival
User: safearrival client=10.0.0.132
Remote: 10.0.0.132
Bind query: yes

update orders set last_modified_date = '2024-01-02 13:46:45.139', order_charge_paid_history_list = '[{"paid": false, "userId": 683802998, "timestamp": 1703460334.226}, {"paid": false, "userId": 683802998, "timestamp": 1703460334.355}, {"paid": true, "userId": 1331955578, "timestamp": 1704203192.402}]', physical_delivery_attempts = '[{"userId": 931341383, "timestamp": 1703771182.803, "supplierId": 638465751, "orderStatus": "recipient_mobile_no_response", "escalationStatus": null}, {"userId": 1333479411, "timestamp": 1704048961.147, "supplierId": 638465751, "orderStatus": "future_delivery_requested", "escalationStatus": null}, {"userId": 1331955578, "timestamp": 1704203199.908, "supplierId": 638465751, "orderStatus": "completed", "escalationStatus": null}]', physical_pickup_attempts = '[{"userId": 802162478, "timestamp": 1703618228.534, "supplierId": 648753577, "orderStatus": "picked_up_auto", "escalationStatus": null}]' where id = '1336368875';

Date: 2024-01-02 13:46:57
Database: safearrival
User: safearrival client=10.0.0.133
Remote: 10.0.0.133
Bind query: yes

x Hide

update orders set last_modified_date = '2024-01-02 13:22:17.269', order_charge_paid_history_list = '[{"paid": true, "userId": 654832899, "timestamp": 1704170482.53}, {"paid": true, "userId": 654832899, "timestamp": 1704170482.658}]', physical_pickup_attempts = '[{"userId": 802144983, "timestamp": 1704201727.423, "supplierId": 648752026, "orderStatus": "picked_up_auto", "escalationStatus": null}]' where id = '1341453844';

Date: 2024-01-02 13:23:02
Database: safearrival
User: safearrival client=10.0.0.133
Remote: 10.0.0.133
Bind query: yes

update orders set last_modified_date = '2024-01-02 17:35:23.022', order_charge_paid_history_list = '[{"paid": false, "userId": 1020830836, "timestamp": 1703338818.154}, {"paid": false, "userId": 1020830836, "timestamp": 1703338818.873}]', physical_pickup_attempts = '[{"userId": 802162478, "timestamp": 1703436729.146, "supplierId": 648753577, "orderStatus": "picked_up_auto", "escalationStatus": null}]' where id = '1335331191';

Date: 2024-01-02 17:36:02
Database: safearrival
User: safearrival client=10.0.0.133
Remote: 10.0.0.133
Bind query: yes

update orders set last_modified_date = '2024-01-02 11:15:28.187', order_charge_paid_history_list = '[{"paid": false, "userId": 683802998, "timestamp": 1704030069.533}, {"paid": false, "userId": 683802998, "timestamp": 1704030069.689}]', physical_pickup_attempts = '[{"userId": 802162478, "timestamp": 1704132037.146, "supplierId": 648753577, "orderStatus": "picked_up_auto", "escalationStatus": null}, {"userId": 631889486, "timestamp": 1704194123.187, "supplierId": 920780628, "orderStatus": "picked_up", "escalationStatus": null}]' where id = '1340298193';

Date: 2024-01-02 11:15:39
Database: safearrival
User: safearrival client=10.0.0.132
Remote: 10.0.0.132
Bind query: yes

x Hide

Times Reported Time consuming queries #1

x Hide

[ User: safearrival client=10.0.0.133 - Total duration: 3h26m39s - Times executed: 257 ]

[ User: safearrival client=10.0.0.132 - Total duration: 3h19m4s - Times executed: 240 ]

x Hide

select batchorder0_.id as id1_14_, batchorder0_.marketplace_id as marketpl2_14_, batchorder0_.created_by as created_3_14_, batchorder0_.created_date as created_4_14_, batchorder0_.last_modified_by as last_mod5_14_, batchorder0_.last_modified_date as last_mod6_14_, batchorder0_.admin_supplier_id as admin_su7_14_, batchorder0_.completed_date as complete8_14_, batchorder0_.driver_id as driver_i9_14_, batchorder0_.status as status10_14_, batchorder0_.supplier_id as supplie11_14_, batchorder0_.user_id as user_id12_14_, batchorder0_.warehouse_id as warehou13_14_ from batch_order_update batchorder0_ where 1 = 1 and (batchorder0_.completed_date is null) and (batchorder0_.user_id in (802318123)) and (batchorder0_.marketplace_id in ('631889485')) order by batchorder0_.created_date desc limit '1';

Date: 2024-01-02 05:30:25
Duration: 4m10s
Database: safearrival
User: safearrival client=10.0.0.133
Remote: 10.0.0.133
Bind query: yes

select batchorder0_.id as id1_14_, batchorder0_.marketplace_id as marketpl2_14_, batchorder0_.created_by as created_3_14_, batchorder0_.created_date as created_4_14_, batchorder0_.last_modified_by as last_mod5_14_, batchorder0_.last_modified_date as last_mod6_14_, batchorder0_.admin_supplier_id as admin_su7_14_, batchorder0_.completed_date as complete8_14_, batchorder0_.driver_id as driver_i9_14_, batchorder0_.status as status10_14_, batchorder0_.supplier_id as supplie11_14_, batchorder0_.user_id as user_id12_14_, batchorder0_.warehouse_id as warehou13_14_ from batch_order_update batchorder0_ where 1 = 1 and (batchorder0_.completed_date is null) and (batchorder0_.user_id in (802318123)) and (batchorder0_.marketplace_id in ('631889485')) order by batchorder0_.created_date desc limit '1';

Date: 2024-01-02 05:30:25
Duration: 4m
Database: safearrival
User: safearrival client=10.0.0.132
Remote: 10.0.0.132
Bind query: yes

select batchorder0_.id as id1_14_, batchorder0_.marketplace_id as marketpl2_14_, batchorder0_.created_by as created_3_14_, batchorder0_.created_date as created_4_14_, batchorder0_.last_modified_by as last_mod5_14_, batchorder0_.last_modified_date as last_mod6_14_, batchorder0_.admin_supplier_id as admin_su7_14_, batchorder0_.completed_date as complete8_14_, batchorder0_.driver_id as driver_i9_14_, batchorder0_.status as status10_14_, batchorder0_.supplier_id as supplie11_14_, batchorder0_.user_id as user_id12_14_, batchorder0_.warehouse_id as warehou13_14_ from batch_order_update batchorder0_ where 1 = 1 and (batchorder0_.completed_date is null) and (batchorder0_.user_id in (649383431)) and (batchorder0_.marketplace_id in ('631889485')) order by batchorder0_.created_date desc limit '1';

Date: 2024-01-02 05:53:34
Duration: 3m47s
Database: safearrival
User: safearrival client=10.0.0.133
Remote: 10.0.0.133
Bind query: yes

x Hide

Times Reported Time consuming queries #2

x Hide

[ User: safearrival client=10.0.0.133 - Total duration: 40m8s - Times executed: 42 ]

[ User: safearrival client=10.0.0.132 - Total duration: 28m38s - Times executed: 38 ]

x Hide

select count(batchorder0_.id) as col_0_0_ from batch_order_update batchorder0_ where 1 = 1 and (batchorder0_.completed_date is null) and (batchorder0_.user_id in (649383431)) and (batchorder0_.marketplace_id in ('631889485'));

Date: 2024-01-02 07:55:38
Duration: 3m54s
Database: safearrival
User: safearrival client=10.0.0.133
Remote: 10.0.0.133
Bind query: yes

select count(batchorder0_.id) as col_0_0_ from batch_order_update batchorder0_ where 1 = 1 and (batchorder0_.completed_date is null) and (batchorder0_.user_id in (823643121)) and (batchorder0_.marketplace_id in ('631889485'));

Date: 2024-01-02 14:56:17
Duration: 3m23s
Database: safearrival
User: safearrival client=10.0.0.133
Remote: 10.0.0.133
Bind query: yes

select count(batchorder0_.id) as col_0_0_ from batch_order_update batchorder0_ where 1 = 1 and (batchorder0_.completed_date is null) and (batchorder0_.user_id in (649383431)) and (batchorder0_.marketplace_id in ('631889485'));

Date: 2024-01-02 05:56:55
Duration: 3m21s
Database: safearrival
User: safearrival client=10.0.0.133
Remote: 10.0.0.133
Bind query: yes

x Hide

Times Reported Time consuming queries #3

x Hide

[ User: safearrival client=10.0.0.132 - Total duration: 9m10s - Times executed: 72 ]

[ User: safearrival client=10.0.0.133 - Total duration: 6m47s - Times executed: 69 ]

x Hide

update orders set last_modified_by = 'system', last_modified_date = '2024-01-02 13:58:09.385', order_charge_paid_history_list = '[{"paid": false, "userId": 683802998, "timestamp": 1704203886.042}, {"paid": false, "userId": 683802998, "timestamp": 1704203886.235}]' where id = '1341812579';

Date: 2024-01-02 14:00:24
Duration: 2m14s
Database: safearrival
User: safearrival client=10.0.0.133
Remote: 10.0.0.133
Bind query: yes

update orders set last_modified_by = 'anonymous', last_modified_date = '2024-01-02 13:58:11.368', order_charge_paid_history_list = '[{"paid": false, "userId": 683802998, "timestamp": 1704203886.042}, {"paid": false, "userId": 683802998, "timestamp": 1704203886.235}]' where id = '1341812579';

Date: 2024-01-02 14:00:24
Duration: 2m12s
Database: safearrival
User: safearrival client=10.0.0.132
Remote: 10.0.0.132
Bind query: yes

update orders set last_modified_by = 'system', last_modified_date = '2024-01-02 13:58:08.396', order_charge_paid_history_list = '[{"paid": false, "userId": 683802998, "timestamp": 1704203886.042}, {"paid": false, "userId": 683802998, "timestamp": 1704203886.235}]' where id = '1341812579';

Date: 2024-01-02 14:00:14
Duration: 2m5s
Database: safearrival
User: safearrival client=10.0.0.132
Remote: 10.0.0.132
Bind query: yes

x Hide

Times Reported Time consuming queries #4

x Hide

[ User: safearrival client=10.0.0.133 - Total duration: 4m5s - Times executed: 29 ]

[ User: safearrival client=10.0.0.132 - Total duration: 1m53s - Times executed: 32 ]

x Hide

update orders set last_modified_by = 'anonymous', last_modified_date = '2024-01-02 13:58:08.621', order_charge_paid_history_list = '[{"paid": false, "userId": 683802998, "timestamp": 1704203886.042}, {"paid": false, "userId": 683802998, "timestamp": 1704203886.235}]', recipient_id = '1341812625' where id = '1341812579';

Date: 2024-01-02 14:00:24
Duration: 2m15s
Database: safearrival
User: safearrival client=10.0.0.133
Remote: 10.0.0.133
Bind query: yes

update orders set last_modified_by = 'anonymous', last_modified_date = '2024-01-02 14:41:47.035', order_charge_paid_history_list = '[{"paid": false, "userId": 683802998, "timestamp": 1704206503.717}, {"paid": false, "userId": 683802998, "timestamp": 1704206504.348}]', recipient_id = '1341844642' where id = '1341844605';

Date: 2024-01-02 14:42:11
Duration: 24s554ms
Database: safearrival
User: safearrival client=10.0.0.133
Remote: 10.0.0.133
Bind query: yes

update orders set last_modified_by = 'anonymous', last_modified_date = '2024-01-02 15:15:05.858', order_charge_paid_history_list = '[{"paid": false, "userId": 683802998, "timestamp": 1704208503.244}, {"paid": false, "userId": 683802998, "timestamp": 1704208503.469}]', recipient_id = '736879156' where id = '1341869561';

Date: 2024-01-02 15:15:20
Duration: 15s14ms
Database: safearrival
User: safearrival client=10.0.0.133
Remote: 10.0.0.133
Bind query: yes