SELECT * FROM voice_compaign_summary WHERE compaign_id='38458' LIMIT 1
before elastic get data
05-May-2025 05:00:34 pm
after elastic get data
05-May-2025 05:00:34 pm
before elastic new get data
05-May-2025 05:00:34 pmloop : 0
total records 103
process records 103below is user whitelist data
Array
(
[9980704083] => 9980704083
[9986142246] => 9986142246
[6362046025] => 6362046025
[9663003777] => 9663003777
[7337792608] => 7337792608
[9945994555] => 9945994555
[7411109227] => 7411109227
[9448134856] => 9448134856
[7259800087] => 7259800087
[8496989549] => 8496989549
[9449105150] => 9449105150
[9535586900] => 9535586900
[9019411311] => 9019411311
[9782902155] => 9782902155
[7622927564] => 7622927564
[9071266286] => 9071266286
[8762860656] => 8762860656
[9482944477] => 9482944477
[9141238128] => 9141238128
[9480459715] => 9480459715
[9449457709] => 9449457709
[9449294688] => 9449294688
[9448347442] => 9448347442
[8762370428] => 8762370428
[8277007504] => 8277007504
[9901849632] => 9901849632
[9480520198] => 9480520198
[8861163805] => 8861163805
[9241212444] => 9241212444
[9448703454] => 9448703454
[9481720894] => 9481720894
[9964045925] => 9964045925
[9480780819] => 9480780819
[9482933237] => 9482933237
[8494903484] => 8494903484
[9449359430] => 9449359430
[9483485598] => 9483485598
[8310115415] => 8310115415
[9380767806] => 9380767806
[7353687340] => 7353687340
[9480963175] => 9480963175
[9448933937] => 9448933937
[9741187183] => 9741187183
[9448545911] => 9448545911
[9449501832] => 9449501832
[8762841226] => 8762841226
[9482133353] => 9482133353
[9663730345] => 9663730345
[9113942001] => 9113942001
[9741790694] => 9741790694
[7676847273] => 7676847273
[8147977562] => 8147977562
[9739641623] => 9739641623
[9480726996] => 9480726996
[9448642348] => 9448642348
[9449293066] => 9449293066
[9481458979] => 9481458979
[8310743252] => 8310743252
[9481111736] => 9481111736
[8762099560] => 8762099560
[8152917962] => 8152917962
[8495935857] => 8495935857
[9483938735] => 9483938735
[9632341192] => 9632341192
[9483538494] => 9483538494
[9481156519] => 9481156519
[9480898208] => 9480898208
[7829014889] => 7829014889
[9632148455] => 9632148455
[9945995943] => 9945995943
[9481862396] => 9481862396
[9480274129] => 9480274129
[9448877161] => 9448877161
[9008013833] => 9008013833
[9448933687] => 9448933687
[8277349218] => 8277349218
[8431919993] => 8431919993
[9380873083] => 9380873083
[9880906375] => 9880906375
[9483416378] => 9483416378
[8277227510] => 8277227510
[9481706391] => 9481706391
[9902467696] => 9902467696
[9480327180] => 9480327180
[9482349260] => 9482349260
[9448823592] => 9448823592
[8073984327] => 8073984327
[9611960791] => 9611960791
[8660858894] => 8660858894
[7259307741] => 7259307741
[9481645570] => 9481645570
[9482998979] => 9482998979
[9483730597] => 9483730597
[8746006655] => 8746006655
[8296420759] => 8296420759
[6362378821] => 6362378821
[9481862098] => 9481862098
[9483938893] => 9483938893
[9448058892] => 9448058892
[9242913964] => 9242913964
[9108208100] => 9108208100
[9449939075] => 9449939075
[8762149932] => 8762149932
)
after elastic new get data
after elastic get data
05-May-2025 05:00:34 pmCutting Percentage = 0
1 alloted_apis_json--[{"cli":"","g_id":"140"}]
alloted api array
Array
(
[0] => Array
(
[cli] =>
[g_id] => 140
)
)
gateway_id_arrs
Array
(
[0] => 140
)
before elastic get data
05-May-2025 05:00:34 pm
after elastic get data
05-May-2025 05:00:34 pm
before elastic get data
05-May-2025 05:00:34 pm
after elastic get data
05-May-2025 05:00:34 pm
before elastic get data
05-May-2025 05:00:34 pm
after elastic get data
05-May-2025 05:00:34 pm
SELECT * FROM `contacts_temp_group_35786` where group_id in(35786) group by mobile_number order by contact_id LIMIT 0,25
DND FILTERING YES
mobile no is dnd7259307741
mobile no is dnd9611960791
mobile no is dnd9481862098
mobile no is dnd9880906375
mobile no is dnd9902467696
mobile no is dnd9482349260
mobile no is dnd9483938893
mobile no is dnd9449939075
mobile no is dnd8277227510
mobile no is dnd9242913964
mobile no is dnd9448058892
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38458` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38458','9482349260', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
05-May-2025 05:00:34 pm
after INSERT DETAIL
05-May-2025 05:00:34 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38458` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38458','9880906375', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
05-May-2025 05:00:34 pm
after INSERT DETAIL
05-May-2025 05:00:34 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38458` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38458','9902467696', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
05-May-2025 05:00:34 pm
after INSERT DETAIL
05-May-2025 05:00:34 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38458` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38458','9483416378', 'p', '140', '1', '','','','', '')
before INSERT DETAIL
05-May-2025 05:00:34 pm
after INSERT DETAIL
05-May-2025 05:00:34 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38458` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38458','9448823592', 'p', '140', '1', '','','','', '')
before INSERT DETAIL
05-May-2025 05:00:34 pm
after INSERT DETAIL
05-May-2025 05:00:34 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38458` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38458','8277227510', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
05-May-2025 05:00:34 pm
after INSERT DETAIL
05-May-2025 05:00:34 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38458` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38458','9481706391', 'p', '140', '1', '','','','', '')
before INSERT DETAIL
05-May-2025 05:00:34 pm
after INSERT DETAIL
05-May-2025 05:00:34 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38458` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38458','8073984327', 'p', '140', '1', '','','','', '')
before INSERT DETAIL
05-May-2025 05:00:34 pm
after INSERT DETAIL
05-May-2025 05:00:34 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38458` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38458','9611960791', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
05-May-2025 05:00:34 pm
after INSERT DETAIL
05-May-2025 05:00:34 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38458` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38458','9480327180', 'p', '140', '1', '','','','', '')
before INSERT DETAIL
05-May-2025 05:00:34 pm
after INSERT DETAIL
05-May-2025 05:00:34 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38458` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38458','8660858894', 'p', '140', '1', '','','','', '')
before INSERT DETAIL
05-May-2025 05:00:34 pm
after INSERT DETAIL
05-May-2025 05:00:34 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38458` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38458','9483730597', 'p', '140', '1', '','','','', '')
before INSERT DETAIL
05-May-2025 05:00:34 pm
after INSERT DETAIL
05-May-2025 05:00:34 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38458` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38458','7259307741', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
05-May-2025 05:00:34 pm
after INSERT DETAIL
05-May-2025 05:00:34 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38458` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38458','9242913964', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
05-May-2025 05:00:34 pm
after INSERT DETAIL
05-May-2025 05:00:34 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38458` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38458','8746006655', 'p', '140', '1', '','','','', '')
before INSERT DETAIL
05-May-2025 05:00:34 pm
after INSERT DETAIL
05-May-2025 05:00:34 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38458` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38458','9481645570', 'p', '140', '1', '','','','', '')
before INSERT DETAIL
05-May-2025 05:00:34 pm
after INSERT DETAIL
05-May-2025 05:00:34 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38458` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38458','8296420759', 'p', '140', '1', '','','','', '')
before INSERT DETAIL
05-May-2025 05:00:34 pm
after INSERT DETAIL
05-May-2025 05:00:34 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38458` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38458','9108208100', 'p', '140', '1', '','','','', '')
before INSERT DETAIL
05-May-2025 05:00:34 pm
after INSERT DETAIL
05-May-2025 05:00:34 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38458` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38458','6362378821', 'p', '140', '1', '','','','', '')
before INSERT DETAIL
05-May-2025 05:00:34 pm
after INSERT DETAIL
05-May-2025 05:00:34 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38458` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38458','9481862098', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
05-May-2025 05:00:34 pm
after INSERT DETAIL
05-May-2025 05:00:34 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38458` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38458','9482998979', 'p', '140', '1', '','','','', '')
before INSERT DETAIL
05-May-2025 05:00:34 pm
after INSERT DETAIL
05-May-2025 05:00:34 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38458` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38458','9449939075', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
05-May-2025 05:00:34 pm
after INSERT DETAIL
05-May-2025 05:00:34 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38458` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38458','8762149932', 'p', '140', '1', '','','','', '')
before INSERT DETAIL
05-May-2025 05:00:34 pm
after INSERT DETAIL
05-May-2025 05:00:34 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38458` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38458','9483938893', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
05-May-2025 05:00:34 pm
after INSERT DETAIL
05-May-2025 05:00:34 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38458` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38458','9448058892', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
05-May-2025 05:00:34 pm
after INSERT DETAIL
05-May-2025 05:00:34 pm
before UPDATE SUMMARY
05-May-2025 05:00:34 pm
after before UPDATE SUMMARY
05-May-2025 05:00:34 pm
contact in sec 0
sepration in sec 0
settings in sec 0
whitelist in sec 0
dnd status in sec
elastic dnd get data in sec -92756665004
blacklis in sec 0
whitelist get data sec 0
whitelist get data mic sec 0.081067085266113
blacklist in micro sec 0.011870861053467