Log Time: 13:00:14
export-cases-report SQL: SELECT `mjbk_cases`.`id`, `mjbk_cases`.`court_id`, `mjbk_cases`.`high_court_id`, `mjbk_cases`.`hc_bench_id`, `mjbk_cases`.`case_number`, `mjbk_cases`.`case_year`, `mjbk_cases`.`case_type_name`, `mjbk_cases`.`case_type`, CONVERT(AES_DECRYPT(`mjbk_cases`.`title`, UNHEX(SHA2("jbkinfomanagemylawsuitss", 512))) USING utf8) AS 'title', `mjbk_cases_info`.`reply_filed` FROM `mjbk_cases` LEFT JOIN `mjbk_cases_info` ON `mjbk_cases_info`.`case_id` = `mjbk_cases`.`id` WHERE (`mjbk_cases`.`user_id` IN (SELECT `id` FROM `mjbk_users` WHERE `uc_settings_id`=570)) AND (`mjbk_cases`.`court_id`=2) AND (`mjbk_cases`.`high_court_id`=14) AND (`mjbk_cases`.`appearing_as`='respondent') AND (`mjbk_cases`.`case_status`=1)

Log Time: 13:00:14
export-cases-report: total=547 | limit=200 | batch_size=100 | sub-processes=2 | uc_id=570.

Log Time: 13:00:14
export-cases-report: spawning batch 1/2 — misc-cron/bulk-export-cases-report 1 100 570 1 0,1 R 0 2 14

Log Time: 13:00:14
export-cases-report: spawning batch 2/2 — misc-cron/bulk-export-cases-report 2 100 570 1 0,1 R 0 2 14

Log Time: 13:00:15
bulk-export-cases-report: starting batch=1 offset=0 limit=100 uc_id=570.

Log Time: 13:00:15
bulk-export-cases-report: starting batch=2 offset=100 limit=100 uc_id=570.

Log Time: 13:00:15
export-cases-report SQL: SELECT `mjbk_cases`.`id`, `mjbk_cases`.`court_id`, `mjbk_cases`.`high_court_id`, `mjbk_cases`.`hc_bench_id`, `mjbk_cases`.`case_number`, `mjbk_cases`.`case_year`, `mjbk_cases`.`case_type_name`, `mjbk_cases`.`case_type`, CONVERT(AES_DECRYPT(`mjbk_cases`.`title`, UNHEX(SHA2("jbkinfomanagemylawsuitss", 512))) USING utf8) AS 'title', `mjbk_cases_info`.`reply_filed` FROM `mjbk_cases` LEFT JOIN `mjbk_cases_info` ON `mjbk_cases_info`.`case_id` = `mjbk_cases`.`id` WHERE (`mjbk_cases`.`user_id` IN (SELECT `id` FROM `mjbk_users` WHERE `uc_settings_id`=570)) AND (`mjbk_cases`.`court_id`=2) AND (`mjbk_cases`.`high_court_id`=14) AND (`mjbk_cases`.`appearing_as`='respondent') AND (`mjbk_cases`.`case_status`=1)

Log Time: 13:00:15
export-cases-report SQL: SELECT `mjbk_cases`.`id`, `mjbk_cases`.`court_id`, `mjbk_cases`.`high_court_id`, `mjbk_cases`.`hc_bench_id`, `mjbk_cases`.`case_number`, `mjbk_cases`.`case_year`, `mjbk_cases`.`case_type_name`, `mjbk_cases`.`case_type`, CONVERT(AES_DECRYPT(`mjbk_cases`.`title`, UNHEX(SHA2("jbkinfomanagemylawsuitss", 512))) USING utf8) AS 'title', `mjbk_cases_info`.`reply_filed` FROM `mjbk_cases` LEFT JOIN `mjbk_cases_info` ON `mjbk_cases_info`.`case_id` = `mjbk_cases`.`id` WHERE (`mjbk_cases`.`user_id` IN (SELECT `id` FROM `mjbk_users` WHERE `uc_settings_id`=570)) AND (`mjbk_cases`.`court_id`=2) AND (`mjbk_cases`.`high_court_id`=14) AND (`mjbk_cases`.`appearing_as`='respondent') AND (`mjbk_cases`.`case_status`=1)

Log Time: 13:00:15
bulk-export-cases-report: batch=1 done. exported=100 file=/var/www/html/runtime/cases-report-uc570-batch1-100.csv

Log Time: 13:00:15
bulk-export-cases-report: batch=2 done. exported=100 file=/var/www/html/runtime/cases-report-uc570-batch2-100.csv

Log Time: 13:01:00
bulk-export-cases-report: batch=2 done. exported=100 file=/var/www/html/runtime/cases-report-uc570-batch2-100.csv

Log Time: 13:01:23
bulk-export-cases-report: batch=1 done. exported=100 file=/var/www/html/runtime/cases-report-uc570-batch1-100.csv

Log Time: 14:33:35
export-cases-report SQL: SELECT `mjbk_cases`.`id`, `mjbk_cases`.`court_id`, `mjbk_cases`.`high_court_id`, `mjbk_cases`.`hc_bench_id`, `mjbk_cases`.`case_number`, `mjbk_cases`.`case_year`, `mjbk_cases`.`case_type_name`, `mjbk_cases`.`case_type`, CONVERT(AES_DECRYPT(`mjbk_cases`.`title`, UNHEX(SHA2("jbkinfomanagemylawsuitss", 512))) USING utf8) AS 'title', `mjbk_cases_info`.`reply_filed` FROM `mjbk_cases` LEFT JOIN `mjbk_cases_info` ON `mjbk_cases_info`.`case_id` = `mjbk_cases`.`id` WHERE (`mjbk_cases`.`user_id` IN (SELECT `id` FROM `mjbk_users` WHERE `uc_settings_id`=456)) AND (1=1) AND (1=1) AND (`mjbk_cases`.`appearing_as`='respondent') AND (`mjbk_cases`.`case_status`=1)

Log Time: 14:33:35
export-cases-report: total=182 | limit=100 | batch_size=100 | sub-processes=1 | uc_id=456.

Log Time: 14:33:35
export-cases-report: spawning batch 1/1 — misc-cron/bulk-export-cases-report 1 100 456 1 0,1 C,R 1 null null

Log Time: 14:33:35
bulk-export-cases-report: starting batch=1 offset=0 limit=100 uc_id=456.

Log Time: 14:33:35
export-cases-report SQL: SELECT `mjbk_cases`.`id`, `mjbk_cases`.`court_id`, `mjbk_cases`.`high_court_id`, `mjbk_cases`.`hc_bench_id`, `mjbk_cases`.`case_number`, `mjbk_cases`.`case_year`, `mjbk_cases`.`case_type_name`, `mjbk_cases`.`case_type`, CONVERT(AES_DECRYPT(`mjbk_cases`.`title`, UNHEX(SHA2("jbkinfomanagemylawsuitss", 512))) USING utf8) AS 'title', `mjbk_cases_info`.`reply_filed` FROM `mjbk_cases` LEFT JOIN `mjbk_cases_info` ON `mjbk_cases_info`.`case_id` = `mjbk_cases`.`id` WHERE (`mjbk_cases`.`user_id` IN (SELECT `id` FROM `mjbk_users` WHERE `uc_settings_id`=456)) AND (1=1) AND (1=1) AND (`mjbk_cases`.`appearing_as`='respondent') AND (`mjbk_cases`.`case_status`=1)

Log Time: 14:39:16
export-cases-report SQL: SELECT `mjbk_cases`.`id`, `mjbk_cases`.`court_id`, `mjbk_cases`.`high_court_id`, `mjbk_cases`.`hc_bench_id`, `mjbk_cases`.`case_number`, `mjbk_cases`.`case_year`, `mjbk_cases`.`case_type_name`, `mjbk_cases`.`case_type`, CONVERT(AES_DECRYPT(`mjbk_cases`.`title`, UNHEX(SHA2("jbkinfomanagemylawsuitss", 512))) USING utf8) AS 'title', `mjbk_cases_info`.`reply_filed` FROM `mjbk_cases` LEFT JOIN `mjbk_cases_info` ON `mjbk_cases_info`.`case_id` = `mjbk_cases`.`id` WHERE (`mjbk_cases`.`user_id` IN (SELECT `id` FROM `mjbk_users` WHERE `uc_settings_id`=456)) AND (`mjbk_cases`.`court_id`=2) AND (`mjbk_cases`.`high_court_id`=14) AND (`mjbk_cases`.`appearing_as`='respondent') AND (`mjbk_cases`.`case_status`=1)

Log Time: 14:39:16
export-cases-report: total=58 | limit=58 | batch_size=100 | sub-processes=1 | uc_id=456.

Log Time: 14:39:16
export-cases-report: spawning batch 1/1 — misc-cron/bulk-export-cases-report 1 100 456 1 0,1 R 0 2 14

Log Time: 14:39:16
bulk-export-cases-report: starting batch=1 offset=0 limit=100 uc_id=456.

Log Time: 14:39:16
export-cases-report SQL: SELECT `mjbk_cases`.`id`, `mjbk_cases`.`court_id`, `mjbk_cases`.`high_court_id`, `mjbk_cases`.`hc_bench_id`, `mjbk_cases`.`case_number`, `mjbk_cases`.`case_year`, `mjbk_cases`.`case_type_name`, `mjbk_cases`.`case_type`, CONVERT(AES_DECRYPT(`mjbk_cases`.`title`, UNHEX(SHA2("jbkinfomanagemylawsuitss", 512))) USING utf8) AS 'title', `mjbk_cases_info`.`reply_filed` FROM `mjbk_cases` LEFT JOIN `mjbk_cases_info` ON `mjbk_cases_info`.`case_id` = `mjbk_cases`.`id` WHERE (`mjbk_cases`.`user_id` IN (SELECT `id` FROM `mjbk_users` WHERE `uc_settings_id`=456)) AND (`mjbk_cases`.`court_id`=2) AND (`mjbk_cases`.`high_court_id`=14) AND (`mjbk_cases`.`appearing_as`='respondent') AND (`mjbk_cases`.`case_status`=1)

Log Time: 14:39:16
bulk-export-cases-report: batch=1 done. exported=58 file=/var/www/html/runtime/cases-report-uc456-batch1-100.csv

Log Time: 14:43:44
bulk-export-cases-report: batch=1 done. exported=100 file=/var/www/html/runtime/cases-report-uc456-batch1-100.csv