SELECT * FROM voice_compaign_summary WHERE compaign_id='38987' LIMIT 1
before elastic get data
16-May-2025 05:28:05 pm
after elastic get data
16-May-2025 05:28:05 pm
before elastic new get data
16-May-2025 05:28:05 pmloop : 0
total records 261
process records 261below 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
[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
[9483416378] => 9483416378
[8277227510] => 8277227510
[9481706391] => 9481706391
[9880906375] => 9880906375
[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
[9449359089] => 9449359089
[8748810586] => 8748810586
[9482133353] => 9482133353
[8431475300] => 8431475300
[9449928425] => 9449928425
[9448486874] => 9448486874
[9880075499] => 9880075499
[9449343147] => 9449343147
[9663598385] => 9663598385
[8197305199] => 8197305199
[9535146129] => 9535146129
[8431665953] => 8431665953
[9902798179] => 9902798179
[9480440943] => 9480440943
[9535617251] => 9535617251
[8861638875] => 8861638875
[9900485632] => 9900485632
[7892387911] => 7892387911
[9449192543] => 9449192543
[9611659730] => 9611659730
[9972052785] => 9972052785
[9731069149] => 9731069149
[9448965263] => 9448965263
[8105818187] => 8105818187
[8660106179] => 8660106179
[9742051153] => 9742051153
[6361441760] => 6361441760
[8762846828] => 8762846828
[9901851408] => 9901851408
[8197357934] => 8197357934
[8446183995] => 8446183995
[9008909974] => 9008909974
[8431907309] => 8431907309
[6366278112] => 6366278112
[8277007251] => 8277007251
[9480944731] => 9480944731
[9449188618] => 9449188618
[9448342676] => 9448342676
[9482988586] => 9482988586
[9686093339] => 9686093339
[9480700422] => 9480700422
[9481751008] => 9481751008
[9448236277] => 9448236277
[9448317630] => 9448317630
[7019127441] => 7019127441
[9916880085] => 9916880085
[9743620972] => 9743620972
[9482986463] => 9482986463
[9480759906] => 9480759906
[9845337734] => 9845337734
[7829846144] => 7829846144
[9880519703] => 9880519703
[9448915947] => 9448915947
[9449773770] => 9449773770
[9380626221] => 9380626221
[9902208660] => 9902208660
[9449629660] => 9449629660
[9482993497] => 9482993497
[9480119106] => 9480119106
[9483485740] => 9483485740
[9482125057] => 9482125057
[9900903033] => 9900903033
[7349497600] => 7349497600
[9945661086] => 9945661086
[9483781462] => 9483781462
[9019498492] => 9019498492
[9901440956] => 9901440956
[9916079455] => 9916079455
[7892889348] => 7892889348
[8762759275] => 8762759275
[9483315302] => 9483315302
[9448965032] => 9448965032
[9740748980] => 9740748980
[9448690528] => 9448690528
[9449180267] => 9449180267
[9448147350] => 9448147350
[9620798833] => 9620798833
[9739944777] => 9739944777
[8762328892] => 8762328892
[9480019137] => 9480019137
[9449200138] => 9449200138
[9448876094] => 9448876094
[8277214230] => 8277214230
[9482557562] => 9482557562
[8970921668] => 8970921668
[9480413469] => 9480413469
[8762957836] => 8762957836
[7618735717] => 7618735717
[9480526752] => 9480526752
[9448833377] => 9448833377
[9483687231] => 9483687231
[9241010393] => 9241010393
[9448964169] => 9448964169
[9901318743] => 9901318743
[9008492731] => 9008492731
[8197981335] => 8197981335
[9483857796] => 9483857796
[9480701301] => 9480701301
[8762150005] => 8762150005
[7406830054] => 7406830054
[9019826137] => 9019826137
[9035709033] => 9035709033
[9481048833] => 9481048833
[7829909087] => 7829909087
[9986910684] => 9986910684
[8762654519] => 8762654519
[9483998320] => 9483998320
[9164393115] => 9164393115
[9483280828] => 9483280828
[9880179016] => 9880179016
[8277138579] => 8277138579
[9449158421] => 9449158421
[9916886681] => 9916886681
[8970675147] => 8970675147
[9480508374] => 9480508374
[8762654479] => 8762654479
[8310049975] => 8310049975
[8197985215] => 8197985215
[9448147828] => 9448147828
[9844259203] => 9844259203
[7483937249] => 7483937249
[9480439468] => 9480439468
[9482029473] => 9482029473
[9482699319] => 9482699319
[8105141888] => 8105141888
[9448579998] => 9448579998
[7899792266] => 7899792266
[9483199353] => 9483199353
[9901995427] => 9901995427
[8970497938] => 8970497938
[9164190880] => 9164190880
[9449263923] => 9449263923
[8618139407] => 8618139407
[9980427366] => 9980427366
[8277786658] => 8277786658
[9481461483] => 9481461483
[9482987942] => 9482987942
[7892730459] => 7892730459
[8197688253] => 8197688253
[8762846026] => 8762846026
[9483705486] => 9483705486
[9481049091] => 9481049091
[9844640556] => 9844640556
[8197837074] => 8197837074
[9741048331] => 9741048331
[9110811824] => 9110811824
[8884894173] => 8884894173
[9482191467] => 9482191467
[9449172740] => 9449172740
[7760777745] => 7760777745
[8762450494] => 8762450494
[8217216040] => 8217216040
[8277087845] => 8277087845
[7760142626] => 7760142626
[9483933157] => 9483933157
[8277158436] => 8277158436
[8861941976] => 8861941976
[9480474927] => 9480474927
[6364281422] => 6364281422
)
after elastic new get data
after elastic get data
16-May-2025 05:28:06 pmCutting Percentage = 0
1 alloted_apis_json--[{"cli":"","g_id":"185"}]
alloted api array
Array
(
[0] => Array
(
[cli] =>
[g_id] => 185
)
)
gateway_id_arrs
Array
(
[0] => 185
)
before elastic get data
16-May-2025 05:28:06 pm
after elastic get data
16-May-2025 05:28:06 pm
before elastic get data
16-May-2025 05:28:06 pm
after elastic get data
16-May-2025 05:28:06 pm
before elastic get data
16-May-2025 05:28:06 pm
after elastic get data
16-May-2025 05:28:06 pm
SELECT * FROM `contacts_temp_group_36201` where group_id in(36201) group by mobile_number order by contact_id LIMIT 0,25
DND FILTERING YES
mobile no is dnd8277158436
mobile no is dnd7760142626
mobile no is dnd8762846026
mobile no is dnd9482191467
mobile no is dnd9483933157
mobile no is dnd8277786658
mobile no is dnd9483705486
mobile no is dnd7760777745
mobile no is dnd8762450494
mobile no is dnd9481461483
mobile no is dnd9481049091
mobile no is dnd9480474927
mobile no is dnd9741048331
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38987` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38987','8277786658', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
16-May-2025 05:28:08 pm
after INSERT DETAIL
16-May-2025 05:28:08 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38987` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38987','9481461483', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
16-May-2025 05:28:08 pm
after INSERT DETAIL
16-May-2025 05:28:08 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38987` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38987','9481049091', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
16-May-2025 05:28:08 pm
after INSERT DETAIL
16-May-2025 05:28:08 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38987` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38987','9482987942', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
16-May-2025 05:28:08 pm
after INSERT DETAIL
16-May-2025 05:28:08 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38987` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38987','9741048331', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
16-May-2025 05:28:08 pm
after INSERT DETAIL
16-May-2025 05:28:08 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38987` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38987','9844640556', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
16-May-2025 05:28:08 pm
after INSERT DETAIL
16-May-2025 05:28:08 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38987` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38987','7892730459', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
16-May-2025 05:28:08 pm
after INSERT DETAIL
16-May-2025 05:28:08 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38987` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38987','9110811824', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
16-May-2025 05:28:08 pm
after INSERT DETAIL
16-May-2025 05:28:08 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38987` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38987','8197688253', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
16-May-2025 05:28:08 pm
after INSERT DETAIL
16-May-2025 05:28:08 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38987` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38987','8884894173', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
16-May-2025 05:28:08 pm
after INSERT DETAIL
16-May-2025 05:28:08 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38987` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38987','9482191467', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
16-May-2025 05:28:08 pm
after INSERT DETAIL
16-May-2025 05:28:08 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38987` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38987','9449172740', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
16-May-2025 05:28:08 pm
after INSERT DETAIL
16-May-2025 05:28:08 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38987` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38987','8197837074', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
16-May-2025 05:28:08 pm
after INSERT DETAIL
16-May-2025 05:28:08 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38987` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38987','8762846026', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
16-May-2025 05:28:08 pm
after INSERT DETAIL
16-May-2025 05:28:08 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38987` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38987','9483705486', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
16-May-2025 05:28:08 pm
after INSERT DETAIL
16-May-2025 05:28:08 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38987` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38987','7760777745', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
16-May-2025 05:28:08 pm
after INSERT DETAIL
16-May-2025 05:28:08 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38987` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38987','8277158436', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
16-May-2025 05:28:08 pm
after INSERT DETAIL
16-May-2025 05:28:08 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38987` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38987','8861941976', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
16-May-2025 05:28:08 pm
after INSERT DETAIL
16-May-2025 05:28:08 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38987` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38987','8217216040', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
16-May-2025 05:28:08 pm
after INSERT DETAIL
16-May-2025 05:28:08 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38987` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38987','8277087845', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
16-May-2025 05:28:08 pm
after INSERT DETAIL
16-May-2025 05:28:08 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38987` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38987','7760142626', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
16-May-2025 05:28:08 pm
after INSERT DETAIL
16-May-2025 05:28:08 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38987` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38987','9480474927', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
16-May-2025 05:28:08 pm
after INSERT DETAIL
16-May-2025 05:28:08 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38987` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38987','9483933157', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
16-May-2025 05:28:08 pm
after INSERT DETAIL
16-May-2025 05:28:08 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38987` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38987','6364281422', 'p', '185', '1', '','','','', '')
before INSERT DETAIL
16-May-2025 05:28:08 pm
after INSERT DETAIL
16-May-2025 05:28:08 pm
MOBILE NO IS WHITELIST YES
INSERT INTO `voice_compaign_detail_38987` (`compaign_id`, `mobile_no`, `status`, `api_id`, `whitelist_status`, `unique_id`,`name`,`DOB`,`address`, `info`) VALUES ('38987','8762450494', 'p', '-3', '1', '','','','', '')
before INSERT DETAIL
16-May-2025 05:28:08 pm
after INSERT DETAIL
16-May-2025 05:28:08 pm
before UPDATE SUMMARY
16-May-2025 05:28:08 pm
after before UPDATE SUMMARY
16-May-2025 05:28:08 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 -91515139200
blacklis in sec 0
whitelist get data sec 1
whitelist get data mic sec 0.93535399436951
blacklist in micro sec 0.014010190963745