API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 5th, 2017
376
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 99.22 KB | None | 0 0
raw download clone embed print report
  1. /usr/sbin/mysqld, Version: 5.5.56-MariaDB-1~precise (mariadb.org binary distribution). started with:
  2. Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
  3. Time Id Command Argument
  4. # Time: 170905 7:01:21
  5. # User@Host: cron[cron] @ [10.110.64.24]
  6. # Thread_id: 2804501 Schema: asterisk QC_hit: No
  7. # Query_time: 20.278335 Lock_time: 0.000029 Rows_sent: 2 Rows_examined: 12692931
  8. # Full_scan: Yes Full_join: No Tmp_table: Yes Tmp_table_on_disk: No
  9. # Filesort: No Filesort_on_disk: No Merge_passes: 0
  10. use asterisk;
  11. SET timestamp=1504620081;
  12. select distinct phone_code from vicidial_list;
  13. # Time: 170905 7:02:43
  14. # User@Host: cron[cron] @ [10.110.64.24]
  15. # Thread_id: 2808464 Schema: asterisk QC_hit: No
  16. # Query_time: 39.335800 Lock_time: 0.225627 Rows_sent: 2000 Rows_examined: 12601094
  17. SET timestamp=1504620163;
  18. SELECT lead_id,list_id,gmt_offset_now,phone_number,state,status,modify_date,user,vendor_lead_code FROM vicidial_list where called_since_last_reset='N' and status IN('HNGTX','U','HNGUP','DC','NA','N','DROP','B','AB','AA','A','NEW') and ((list_id IN('375','364','374'))) and lead_id NOT IN('13259417','13260630','13261240','13259807','13260990','13261139','13260638','13260898','13260439','13260401','13260448','13260504','13260496','13260502','13260532','13260509','13260643','13260635','13260684','13260712','13261237','13260829','13260757','13261078','13260697','13259504','13259739','13260985','13259941','13260672','13260614','13260656','13261066','13260620','13260929','13260613','13260675','13260447','13260431','13260424','13260453','13260451','13260444','13260483','13260515','13260476','13260529','13260566','13260493','13260582','13260640','13260665','13260692','13260706','13260786','13259792','13260727','13261230','13259840','13259401','13260682','13260899','13261124','13261136','13260861','13260873','13260725','13260591','13260437','13260445','13260427','13260461','13260489','13260491','13260474','13260526','13260562','13260501','13260594','13260611','13260658','13260691','13259815','13261248','13260420','13260460','13260452','13260500','13260520','13260516','13260480','13260518','13260544','13260540','13260573','13260479','13260531','13260615','13260542','13260623','13260669','13260651','13260700','13260737','13260732','13260722','13259751','13259856','13259373','13260779','13260731','13260795','13259642','13261114','13260778','13260798','13260866','13260807','13261117','13259664','13259686','13261238','13260834','13259613','13259527','13259706','13259593','13260666','13260769','13259845','13259919','13260864','13261010','13260683','13260815','13260840','13260775','13260803','13260818','13261121','13260789','13260822','13261072','13260979','13261140','13261068','13261147','13261142','13260608','13260634','13260646','13260687','13260668','13260707','13260740','13260763','13259481','13260770','13259689','13260933','13261252','13260527','13260525','13260539','13260558','13260560','13260492','13260478','13260535','13260617','13260592','13260649','13260657','13260739','13260696','13260693','13260728','13260736','13260785','13259428','13259910','13260774','13260729','13260772','13259796','13259757','13259410','13260790','13260816','13259899','13259763','13260909','13259978','13259727','13261182','13260931','13259365','13259438','13259716','13259590','13259538','13259640','13260637','13260664','13260715','13259386','13260768','13260972','13261008','13260607','13260744','13259450','13260806','13260838','13261046','13260859','13259837','13261086','13261189','13260915','13260921','13261204','13260888','13259865','13259383','13261015','13261196','13261127','13261208','13261219','13261163','13261198','13261167','13259452','13259933','13260021','13260029','13260923','13259368','13259819','13259704','13259462','13261205','13260024','13261243','13261244','13261245','13261246','13261247','13261250','13261251','13261261','13261260','13261262','13261263','13261264','13261265','13259879','13259929','13259969','13259909','13259939','13259959','13260809','13260828','13259697','13260987','13259709','13259958','13260999','13259394','13260819','13260887','13259970','13260835','13260967','13260960','13260988','13259897','13260894','13259398','13259994','13260010','13259980','13259881','13259979','13259947','13259988','13260001','13260832','13260874','13261058','13259779','13260969','13260842','13259389','13259736','13260958','13259400','13260009','13259997','13260041','13261256','13259377','13259380','13259382','13259370','13259987','13259961','13259944','13259936','13260970','13259375','13259378','13259915','13259924','13259408','13260823','13259526','13259578','13259836','13259966','13259972','13260849','13261242','13259537','13259554','13259645','13259687','13259785','13259928','13259950','13259494','13259547','13259556','13259568','13259433','13260911','13259912','13259631','13259764','13261134','13261123','13261060','13260975','13261024','13259695','13261005','13259738','13261044','13261156','13261131','13259913','13259424','13261220','13259862','13259993','13260004','13259911','13259372','13260844','13259657','13260991','13261112','13261132','13260850','13261028','13259468','13259367','13261214','13259388','13261103','13260978','13259381','13260974','13261004','13260743','13259536','13261092','13261178','13261125','13259459','13260011','13260943','13259824','13260787','13261159','13260586','13259948','13261053','13260841','13261035','13260914','13259443','13260714','13261043','13260886','13260797','13259953','13260812','13259516','13260673','13260813','13261166','13260913','13260049','13261082','13260597','13260784','13261031','13259579','13260989','13260941','13261003','13261253','13260794','13259559','13259600','13261006','13261016','13261141','13259471','13260860','13260814','13260889','13260951','13260932','13260966','13261049','13261073','13261102','13259605','13259753','13260983','13259925','13261037','13259441','13261100','13259451','13259589','13259868','13259907','13259435','13259798','13260924','13259683','13259455','13259472','13260824','13260872','13261052','13261089','13261120','13261158','13261042','13261239','13261045','13261191','13259826','13260017','13259852','13261229','13260944','13260827','13260992','13261062','13260855','13260906','13260030','13259676','13259606','13259733','13261168','13260891','13261032','13261212','13261021','13260885','13261210','13260936','13260950','13261054','13261084','13261110','13261169','13259885','13260868','13260968','13261135','13259415','13259985','13260976','13259989','13261223','13261195','13261023','13260026','13261186','13261175','13261019','13260817','13261085','13261177','13259423','13259420','13259416','13259431','13259794','13259406','13260792','13260802','13261193','13261161','13261130','13260907','13261192','13261146','13260938','13261228','13261221','13261150','13261017','13260852','13259722','13259784','13260880','13260948','13260980','13261106','13259875','13259467','13259871','13261074','13260006','13259523','13260870','13260904','13259569','13260867','13259390','13259974','13260896','13261001','13261104','13261138','13261190','13259918','13259609','13259396','13260856','13259878','13260550','13259971','13260935','13259488','13260946','13259714','13259608','13261088','13259366','13259747','13261111','13261033','13260882','13260837','13259668','13259825','13259900','13259769','13261061','13260858','13259419','13260659','13260440','13260484','13260490','13260450','13259669','13259812','13259442','13259426','13259853','13260981','13260857','13261087','13260901','13260799','13259737','13261152','13261255','13260820','13259655','13259422','13260808','13261027','13259762','13260723','13260552','13260653','13260598','13261232','13260871','13260788','13259384','13261200','13259963','13261187','13260570','13260564','13261207','13259901','13260843','13260644','13260534','13259624','13259546','13259799','13261225','13260717','13260510','13260652','13260595','13260733','13260903','13261048','13259392','13259404','13261007','13261218','13259482','13259483','13259484','13259485','13259486','13259487','13259489','13259490','13259491','13259492','13259493','13259495','13259497','13259498','13259499','13259500','13260957','13260971','13260994','13259816','13259803','13259795','13259774','13259761','13259732','13259724','13259702','13259694','13259684','13259674','13259662','13259651','13259643','13259629','13259618','13259461','13259549','13259758','13259440','13261129','13261051','13259385','13259619','13259895','13260851','13261002','13260801','13261038','13260811','13259529','13261165','13261090','13260940','13259594','13259439','13259444','13260877','13261096','13261094','13261095','13261093','13261091','13261079','13261076','13261067','13261065','13261059','13261055','13261030','13261020','13261012','13260995','13260984','13260963','13261034','13261026','13261022','13260965','13260997','13260878','13260964','13260962','13260954','13260865','13260937','13260928','13260926','13260925','13260912','13260875','13260879','13260853','13260905','13260949','13260947','13260927','13260916','13261226','13260917','13260908','13260895','13260846','13260833','13260826','13260825','13260800','13260884','13260897','13261047','13260780','13259719','13259429','13260961','13259412','13260881','13261211','13259566','13260734','13260689','13261164','13260746','13259896','13261201','13260767','13260585','13261050','13261099','13260986','13259935','13261116','13259509','13261254','13259602','13261259','13259447','13261188','13259962','13259599','13260023','13260710','13260741','13260599','13261071','13261041','13260738','13260578','13259474','13261149','13261063','13260862','13259797','13261233','13261080','13259364','13260973','13259864','13261197','13259750','13259652','13261217','13261206','13261183','13261157','13261155','13261151','13261148','13261145','13261144','13261143','13261133','13261122','13261119','13261118','13261162','13260890','13259457','13260996','13259673','13261209','13259766','13260892','13261025','13261179','13261128','13259458','13261018','13261077','13259456','13260777','13259834','13259630','13260939','13259767','13261011','13259663','13261039','13259446','13259449','13259898','13259782','13259720','13259665','13259402','13259904','13261222','13259787','13259945','13259434','13259519','13260977','13260920','13259882','13259379','13259863','13261176','13261105','13260910','13259470','13259466','13259469','13259465','13259460','13261170','13261097','13259421','13261227','13259411','13259430','13261154','13261064','13261115','13259425','13261234','13259413','13259418','13259427','13259889','13261224','13260869','13259713','13259874','13259886','13259743','13259805','13259867','13259387','13259723','13259773','13259866','13260934','13259476','13259479','13259480','13260854','13259475','13259478','13259477','13261014','13260836','13260900','13260922','13260945','13259414','13259403','13259405','13259409','13259506','13259510','13259501','13259508','13259511','13259514','13259518','13259522','13259524','13259528','13259502','13259507','13259531','13259535','13259541','13259544','13259515','13259520','13259530','13259532','13259553','13259584','13259572','13259582','13259543','13259545','13259551','13259533','13259540','13259513','13259496','13259521','13259534','13259548','13259586','13259591','13259555','13259620','13259649','13259637','13259573','13259583','13259557','13259561','13259565','13259576','13259601','13259564','13259577','13259552','13259560','13259570','13259581','13259575','13259598','13259592','13259588','13259571','13259603','13259628','13259650','13259595','13259611','13259626','13259646','13259641','13259653','13259614','13259621','13259623','13259625','13259627','13259632','13259587','13259574','13259585','13259615','13259648','13259563','13259604','13259607','13259647','13259639','13259654','13259550','13259617','13259754','13259635','13259633','13259644','13259612','13259616','13259656','13259658','13259659','13259634','13259638','13259660','13259661','13259666','13259667','13259670','13259672','13259678','13259680','13259685','13259690','13259671','13259675','13259682','13259688','13259677','13259679','13259693','13259699','13259710','13259718','13259701','13259711','13259721','13259728','13259730','13259735','13259740','13259746','13259752','13259692','13259696','13259698','13259703','13259715','13259725','13259708','13259712','13259726','13259729','13259731','13259734','13259745','13259755','13259759','13259748','13259744','13259749','13259756','13259760','13259765','13259768','13259771','13259772','13259776','13259775','13259780','13259781','13259786','13259788','13259789','13259790','13259791','13259793','13259800','13259801','13259802','13259804','13259806','13259808','13259809','13259810','13259813','13259822','13259830','13259832','13259841','13259828','13259843','13259820','13259854','13259903','13259859','13259861','13259870','13259873','13259817','13259818','13259827','13259831','13259838','13259847','13259855','13259846','13259823','13259848','13259858','13259860','13259869','13259872','13259876','13259877','13259883','13259884','13259887','13259833','13259835','13259839','13259844','13259821','13259851','13259890','13259891','13259892','13259893','13259902','13259905','13259906','13259908','13259916','13259917','13259920','13259888','13259921','13259923','13259926','13259927','13259940','13259942','13259946','13259951','13259954','13259956','13259973','13259977','13259986','13259996','13259931','13259955','13259943','13259965','13259999','13260018','13259992','13259984','13260000','13260008','13260014','13259995','13260013','13260022','13260015','13260028','13260032','13260034','13260037','13260038','13260039','13259991','13260005','13260020','13259968','13259975','13259981','13259990','13259998','13259938','13259932','13259957','13259967','13259976','13259983','13260002','13260012','13260016','13260003','13260019','13260007','13260025','13260027','13260033','13260035','13260036','13260042','13260044','13260045','13260043','13260050','13260052','13260054','13260057','13260056','13260060','13260063','13260067','13260064','13260103','13260107','13260113','13260118','13260124','13260127','13260066','13260072','13260074','13260078','13260046','13260053','13260059','13260061','13260062','13260070','13260071','13260079','13260077','13260131','13260047','13260069','13260081','13260076','13260084','13260048','13260055','13260058','13260065','13260068','13260051','13260073','13260075','13260082','13260086','13260088','13260092','13260083','13260091','13260102','13260112','13260119','13260101','13260115','13260123','13260090','13260080','13260087','13260094','13260106','13260098','13260099','13260109','13260120','13260126','13260129','13260132','13260100','13260095','13260104','13260110','13260117','13260096','13260111','13260116','13260085','13260089','13260093','13260097','13260108','13260114','13260121','13260105','13260122','13260125','13260128','13260130','13260133','13260134','13260138','13260136','13260140','13260144','13260135','13260137','13260142','13260158','13260147','13260157','13260162','13260170','13260139','13260150','13260141','13260149','13260166','13260168','13260171','13260173','13260151','13260159','13260175','13260148','13260152','13260154','13260143','13260153','13260160','13260163','13260164','13260146','13260156','13260145','13260165','13260167','13260169','13260172','13260174','13260155','13260161','13260176','13260177','13260178','13260179','13260180','13260181','13260182','13260183','13260184','13260186','13260187','13260193','13260197','13260196','13260199','13260188','13260190','13260191','13260185','13260194','13260192','13260189','13260195','13260198','13260201','13260203','13260208','13260212','13260216','13260223','13260226','13260202','13260205','13260209','13260206','13260210','13260214','13260219','13260218','13260213','13260217','13260220','13260228','13260200','13260207','13260225','13260229','13260222','13260235','13260204','13260211','13260215','13260221','13260230','13260224','13260233','13260236','13260227','13260231','13260234','13260232','13260237','13260238','13260239','13260240','13260241','13260242','13260252','13260254','13260256','13260258','13260243','13260244','13260245','13260246','13260265','13260268','13260315','13260293','13260296','13260276','13260286','13260294','13260300','13260304','13260307','13260316','13260275','13260247','13260248','13260249','13260250','13260251','13260253','13260255','13260257','13260259','13260260','13260261','13260262','13260263','13260264','13260266','13260269','13260272','13260274','13260271','13260277','13260279','13260281','13260283','13260285','13260287','13260288','13260289','13260267','13260311','13260278','13260290','13260270','13260273','13260280','13260292','13260297','13260302','13260306','13260314','13260318','13260282','13260291','13260309','13260313','13260298','13260284','13260295','13260299','13260301','13260303','13260305','13260325','13260308','13260310','13260312','13260317','13260320','13260322','13260339','13260340','13260348','13260343','13260345','13260346','13260349','13260352','13260327','13260331','13260334','13260337','13260330','13260338','13260336','13260342','13260353','13260365','13260366','13260372','13260355','13260356','13260377','13260324','13260329','13260333','13260335','13260321','13260326','13260362','13260332','13260341','13260319','13260347','13260357','13260358','13260370','13260373','13260363','13260364','13260381','13260378','13260323','13260328','13260350','13260344','13260351','13260354','13260361','13260369','13260368','13260371','13260374','13260375','13260359','13260367','13260360','13260376','13260379','13260380','13260384','13260386','13260388','13260390','13260392','13260382','13260383','13260385','13260387','13260389','13260391','13260393','13260394','13260395','13260396','13260397','13260398','13260399','13260400','13260416','13260405','13260415','13260425','13260433','13260441','13260464','13260407','13260430','13260404','13260426','13260442','13260458','13260463','13260414','13260403','13260412','13260423','13260436','13260418','13260457','13260409','13260417','13260419','13260446','13260402','13260462','13260422','13260421','13260438','13260435','13260443','13260455','13260408','13260429','13260456','13260454','13260432','13260467','13260406','13260449','13260428','13260410','13260434','13260482','13260466','13260465','13260468','13260469','13260488','13260494','13260503','13260511','13260523','13260506','13260524','13260521','13260545','13260475','13260485','13260517','13260470','13260471','13260472','13260473','13260497','13260481','13260487','13260498','13260505','13260495','13260519','13260533','13260537','13260549','13260551','13260553','13260555','13260561','13260568','13260569','13260571','13260577','13260556','13260565','13260567','13260572','13260512','13260543','13260522','13260528','13260546','13260536','13260580','13260639','13260641','13260647','13260541','13260581','13260583','13260631','13260642','13260645','13260626','13260628','13260648','13260650','13260655','13260662','13260671','13260686','13260667','13260678','13260660','13260681','13260685','13260663','13260674','13260679','13260688','13260704','13260694','13260701','13260718','13260754','13260761','13260781','13260796','13260711','13260750','13260752','13260773','13260793','13260821','13259982','13260998','13261113','13261070','13259705','13259407','13260953','13260698','13260705','13260709','13260721','13260720','13260724','13260745','13260758','13260756','13260762','13260765','13260759','13260804','13260959','13259453','13260956','13259960','13260876','13259922','13260810','13261257','13259542','13259517','13259857','13261213','13260735','13259596','13261009','13260708','13261199','13260670','13261258','13260703','13260716','13260719','13260764','13261235','13261108','13261184','13259580','13259376','13261249','13261215','13259742','13259393','13259707','13259539','13259512','13261172','13261109','13261083','13261040','13260955','13260952','13259814','13261181','13261069','13261036','13259914','13261101','13259930','13261202','13261029','13260902','13259597','13259842','13261013','13259399','13260783','13260751','13261241','13260776','13260753','13260695','13260702','13260621','13260636','13260618','13260602','13260588','13260589','13260603','13260605','13260609','13260622','13260559','13259473','13260748','13260601','13260596','13260610','13260575','13260627','13260040','13260713','13260771','13260676','13260760','13260632','13260590','13260616','13260530','13260848','13259717','13260831','13260782','13259952','13260699','13260619','13260587','13260604','13260593','13260600','13260606','13260612','13260513','13260576','13260563','13259374','13261056','13259622','13259934','13259770','13260847','13261194','13261160','13259778','13259949','13260883','13260930','13259454','13259636','13259700','13260942','13259741','13261231','13259894','13259850','13261098','13261236','13259436','13259448','13259880','13259503','13259691','13259937','13260893','13259445','13259811','13260839','13259610','13259371','13260031','13259369','13259397','13259432','13259437','13259681','13259829','13260830','13259463','13260845','13260726','13260749','13259783','13261185','13259567','13260791','13260742','13259391','13259558','13260755','13260730','13260747','13260690','13260654','13260677','13260661','13260624','13260557','13260584','13260538','13260574','13260579','13260554','13260547','13260514','13260486','13260507','13260508','13260477','13260499','13260413','13260459','13260411','13260766','13261000','13261075','13260863','13261203','13261173','13261180','13261216','13261137','13261153','13260993','13261081','13260919','13259395','13260805','13261057','13260625','13260548','13259964','13259777','13259464','13261126','13259849','13260982','13261174','13261171','13259505','13260680','13259525','13259562','13260633','13260629','13260918','13261107','0') and ((gmt_offset_now IN('13.00','12.75','12.50','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','10.00','9.75','9.50','9.25','9.00','8.75','8.50','8.25','8.00','7.75','7.50','7.25','7.00','6.75','6.50','6.25','6.00','5.75','5.50','5.25','5.00','4.75','4.50','4.25','4.00','3.75','3.50','3.25','3.00','2.75','2.50','2.25','2.00','1.75','1.50','1.25','1.00','0.75','0.50','0.25','0.00','-0.25','-0.50','-0.75','-1.00','-1.25','-1.50','-1.75','-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50','-3.75','-4.00','-4.25','-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00','-6.25','-6.50','-6.75','-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50','-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-10.25','-10.50','-10.75','-11.00','-11.25','-11.50','-11.75','-12.00','-12.25','-12.50','-12.75','99') ) ) order by lead_id asc limit 2000;
  19. # Time: 170905 7:11:26
  20. # User@Host: cron[cron] @ [10.110.68.82]
  21. # Thread_id: 2861192 Schema: asterisk QC_hit: No
  22. # Query_time: 13.255153 Lock_time: 0.044615 Rows_sent: 67 Rows_examined: 10917566
  23. # Full_scan: Yes Full_join: No Tmp_table: Yes Tmp_table_on_disk: No
  24. # Filesort: Yes Filesort_on_disk: No Merge_passes: 0
  25. SET timestamp=1504620686;
  26. SELECT vls.list_id,list_name,list_description,count(*) as tally,active,list_lastcalldate,campaign_id,DATE_FORMAT(expiration_date,'%Y%m%d'),local_call_time from vicidial_lists vls,vicidial_list vl where vls.list_id=vl.list_id and campaign_id='SLD00001' group by list_id order by list_id;
  27. # Time: 170905 7:11:46
  28. # User@Host: cron[cron] @ [10.110.68.82]
  29. # Thread_id: 2862922 Schema: asterisk QC_hit: No
  30. # Query_time: 14.937032 Lock_time: 1.359865 Rows_sent: 67 Rows_examined: 10917566
  31. # Full_scan: Yes Full_join: No Tmp_table: Yes Tmp_table_on_disk: No
  32. # Filesort: Yes Filesort_on_disk: No Merge_passes: 0
  33. SET timestamp=1504620706;
  34. SELECT vls.list_id,list_name,list_description,count(*) as tally,active,list_lastcalldate,campaign_id,DATE_FORMAT(expiration_date,'%Y%m%d'),local_call_time from vicidial_lists vls,vicidial_list vl where vls.list_id=vl.list_id and campaign_id='SLD00001' group by list_id order by list_id;
  35. # Time: 170905 7:12:13
  36. # User@Host: cron[cron] @ [10.110.68.82]
  37. # Thread_id: 2865872 Schema: asterisk QC_hit: No
  38. # Query_time: 12.724278 Lock_time: 0.059901 Rows_sent: 67 Rows_examined: 10917566
  39. # Full_scan: Yes Full_join: No Tmp_table: Yes Tmp_table_on_disk: No
  40. # Filesort: Yes Filesort_on_disk: No Merge_passes: 0
  41. SET timestamp=1504620733;
  42. SELECT vls.list_id,list_name,list_description,count(*) as tally,active,list_lastcalldate,campaign_id,DATE_FORMAT(expiration_date,'%Y%m%d'),local_call_time from vicidial_lists vls,vicidial_list vl where vls.list_id=vl.list_id and campaign_id='SLD00001' group by list_id order by list_id;
  43. # Time: 170905 7:12:57
  44. # User@Host: cron[cron] @ [10.110.64.24]
  45. # Thread_id: 2865952 Schema: asterisk QC_hit: No
  46. # Query_time: 40.410471 Lock_time: 0.736575 Rows_sent: 2000 Rows_examined: 12603094
  47. SET timestamp=1504620777;
  48. SELECT lead_id,list_id,gmt_offset_now,phone_number,state,status,modify_date,user,vendor_lead_code FROM vicidial_list where called_since_last_reset='N' and status IN('HNGTX','U','HNGUP','DC','NA','N','DROP','B','AB','AA','A','NEW') and ((list_id IN('375','364','374'))) and lead_id NOT IN('13261373','13262511','13263055','13261809','13261533','13262228','13262277','13262366','13262768','13262497','13262445','13262477','13262245','13262190','13262809','13262758','13262352','13261409','13262677','13263251','13262948','13262865','13261847','13261582','13261450','13263264','13262824','13261784','13262879','13262729','13262697','13262530','13262438','13262600','13261621','13261622','13263235','13263234','13263120','13262611','13261391','13262210','13262270','13261421','13262759','13262527','13262912','13262884','13261381','13262800','13262622','13263247','13261326','13262843','13263155','13263191','13262434','13261269','13262921','13263126','13262773','13261359','13262855','13261629','13262854','13262814','13262779','13262485','13262987','13261569','13262808','13262969','13261496','13262836','13263128','13262328','13261649','13261819','13262778','13262893','13263084','13263077','13263075','13263060','13263046','13263027','13263019','13263017','13263016','13263015','13263024','13263022','13263009','13262963','13263036','13262299','13261588','13261366','13261368','13261490','13261507','13262463','13262504','13261715','13261433','13261724','13262711','13263001','13262822','13262859','13263012','13261431','13262835','13263129','13262656','13262940','13262984','13262846','13262555','13262632','13261481','13262374','13263139','13263153','13262392','13262462','13263141','13261469','13263248','13261556','13263020','13263083','13263081','13263076','13263056','13263044','13263038','13263031','13263029','13261861','13263244','13261318','13261273','13261494','13261671','13262864','13263006','13263002','13262997','13262961','13262954','13262939','13261430','13262979','13262848','13261773','13262906','13262892','13262867','13262956','13262895','13262886','13261744','13261449','13262763','13262737','13262723','13262691','13262690','13262682','13262795','13262786','13262736','13262722','13262716','13262596','13262668','13262653','13262663','13262652','13262620','13262619','13262618','13262615','13262605','13262584','13262586','13262591','13262568','13262572','13262581','13262562','13262587','13262595','13262567','13262542','13262529','13262432','13262460','13262456','13262442','13262441','13262538','13262534','13262532','13262524','13262539','13262519','13262525','13262491','13262501','13262484','13262480','13262472','13262468','13262454','13262455','13262421','13262405','13262397','13262428','13262413','13262422','13262411','13262398','13262385','13262384','13262368','13262351','13262375','13262316','13262359','13262324','13262377','13262370','13262358','13262406','13262394','13262373','13262364','13262345','13262335','13262327','13262376','13262349','13262319','13262303','13262323','13262318','13262350','13262326','13262300','13262284','13262276','13262268','13262266','13262259','13262253','13262285','13262279','13262275','13262272','13262269','13262265','13262263','13262261','13262258','13262254','13262251','13262249','13262248','13262247','13262246','13262244','13262243','13262242','13262239','13262234','13262227','13262218','13262235','13262214','13262222','13262217','13262367','13262307','13262286','13262295','13262333','13262283','13262354','13262313','13262342','13262304','13262314','13262280','13262274','13262271','13262262','13262255','13262204','13262209','13262202','13262200','13262196','13262195','13262194','13262192','13262191','13262188','13262232','13262229','13262224','13262219','13262213','13262211','13262238','13262231','13262225','13262221','13262216','13262233','13262226','13262208','13262205','13262203','13262201','13262199','13262197','13262193','13262207','13262189','13262187','13262186','13262185','13262184','13262182','13262181','13262180','13262176','13262173','13262168','13262134','13262171','13262167','13262164','13262160','13262156','13262178','13262174','13262177','13262170','13262161','13262179','13262149','13262172','13262143','13262137','13262146','13262140','13262155','13262165','13262163','13262159','13262154','13262175','13262169','13262166','13262162','13262158','13262152','13262147','13262139','13262135','13262150','13262157','13262153','13262151','13262145','13262138','13262148','13262142','13262132','13262130','13262127','13262119','13262141','13262136','13262144','13262133','13262131','13262129','13262125','13262123','13262115','13262111','13262120','13262116','13262112','13262109','13262102','13262097','13262092','13262079','13262107','13262105','13262103','13262100','13262128','13262124','13262117','13262122','13262114','13262108','13262104','13262101','13262126','13262121','13262113','13262110','13262099','13262095','13262089','13262090','13262094','13262087','13262076','13262078','13262070','13262060','13262050','13262073','13262096','13262118','13262106','13262098','13262093','13262085','13262086','13262084','13262066','13262064','13262054','13262042','13262080','13262091','13262083','13262081','13262088','13262077','13262075','13262082','13262071','13262074','13262067','13262062','13262058','13262052','13262046','13262048','13262068','13262072','13262069','13262065','13262063','13262061','13262059','13262056','13262044','13262041','13262055','13262051','13262047','13262040','13262036','13262043','13262057','13262053','13262045','13262038','13262035','13262034','13262033','13262032','13262031','13262030','13262028','13262025','13262023','13262021','13262019','13262017','13262015','13262049','13262013','13262039','13262037','13262006','13262010','13262008','13262029','13262027','13262026','13262024','13262022','13262016','13261912','13262014','13262007','13262004','13262000','13261998','13261996','13262003','13261994','13261992','13261990','13261988','13261986','13261984','13261982','13261980','13261977','13261967','13261971','13261978','13261951','13261957','13261973','13261972','13261958','13261950','13261969','13261947','13261945','13261941','13261929','13261936','13261919','13261917','13261915','13261913','13262012','13262009','13262020','13262018','13262005','13261999','13261995','13261993','13261989','13262011','13262002','13261997','13262001','13261991','13261987','13261985','13261983','13261981','13261979','13261975','13261974','13261968','13261976','13261960','13261955','13261964','13261965','13261953','13261946','13261961','13261943','13261926','13261928','13261934','13261925','13261916','13261914','13261910','13261970','13261962','13261954','13261959','13261952','13261966','13261956','13261944','13261940','13261899','13261921','13261905','13261937','13261908','13261949','13261963','13261948','13261942','13261927','13261932','13261918','13261907','13261892','13261903','13261901','13261911','13261909','13261906','13261922','13261904','13261902','13261900','13261898','13261897','13261896','13261930','13261931','13261933','13261935','13261938','13261924','13261939','13261923','13261874','13261869','13261867','13261856','13261920','13261862','13261882','13261895','13261894','13261893','13261891','13261890','13261889','13261845','13261843','13261839','13261833','13261832','13261829','13261824','13261822','13261820','13261842','13261835','13261888','13261885','13261883','13261881','13261877','13261878','13261871','13261859','13261863','13261789','13261886','13261876','13261873','13261868','13261796','13261864','13261865','13261860','13261850','13261848','13261841','13261834','13261831','13261823','13261816','13261794','13261807','13261854','13261852','13261815','13261884','13261880','13261875','13261872','13261866','13261855','13261858','13261857','13261851','13261849','13261844','13261840','13261830','13261825','13261821','13261814','13261812','13261804','13261801','13261799','13261795','13261788','13261786','13261781','13261779','13261777','13261776','13261771','13261769','13261767','13261765','13261761','13261759','13261798','13261813','13261811','13261806','13261805','13261800','13261790','13261785','13261780','13261775','13261770','13261757','13261797','13261787','13261778','13261772','13261768','13261762','13261758','13261756','13261755','13261754','13261751','13261750','13261766','13261760','13261803','13261730','13261748','13261746','13261742','13261739','13261726','13261738','13261727','13261728','13261732','13261749','13261747','13261745','13261740','13261731','13261723','13261735','13261718','13261736','13261720','13261741','13261737','13261729','13261722','13261721','13261719','13261717','13261689','13261687','13261685','13261716','13261713','13261712','13261711','13261710','13261709','13261708','13261707','13261706','13261704','13261703','13261702','13261701','13261700','13261699','13261698','13261697','13261694','13261693','13261692','13261691','13261690','13261688','13261686','13261680','13261678','13261675','13261673','13261668','13261666','13261665','13261661','13261645','13261682','13261676','13261669','13261657','13261650','13261642','13261646','13261667','13261655','13261648','13261634','13261638','13261623','13261614','13261635','13261625','13261608','13261632','13261605','13261617','13261596','13261602','13261589','13261579','13261575','13261597','13261568','13261515','13261603','13261604','13261606','13261578','13261594','13261520','13261576','13261585','13261679','13261674','13261660','13261656','13261647','13261626','13261644','13261636','13261659','13261654','13261637','13261618','13261628','13261616','13261609','13261627','13261619','13261613','13261560','13261590','13261521','13261580','13261573','13261564','13261555','13261537','13261591','13261577','13261565','13261523','13261592','13261557','13261558','13261547','13261541','13261538','13261524','13261510','13261574','13261601','13261593','13261559','13261566','13261551','13261567','13261561','13261548','13261546','13261534','13261514','13261527','13261535','13261504','13261542','13261540','13261536','13261529','13261522','13261519','13261512','13261506','13261526','13261505','13261502','13261501','13261497','13261495','13261492','13261487','13261483','13261491','13261486','13261484','13261550','13261587','13261477','13261475','13261474','13261473','13261468','13261467','13261466','13261463','13261458','13261457','13261453','13261444','13261438','13261445','13261456','13261454','13261385','13261451','13261443','13261437','13261435','13261434','13261436','13261427','13261424','13261425','13261415','13261408','13261398','13261395','13261407','13261422','13261418','13261414','13261400','13261396','13261392','13261405','13261397','13261372','13261379','13261377','13261375','13261261','13261260','13261262','13261263','13261264','13261265','13263246','13263249','13263252','13263253','13263257','13263260','13263259','13263263','13261280','13261286','13263241','13261284','13261298','13261301','13261316','13261327','13261329','13261277','13261281','13261283','13261299','13261351','13261328','13261287','13261302','13261297','13261324','13261337','13261339','13261336','13261338','13261343','13261345','13261347','13261325','13261342','13261363','13263142','13261291','13261341','13261350','13261376','13263152','13263143','13263149','13262915','13262837','13262949','13262771','13262696','13262627','13262310','13262970','13263004','13261493','13262803','13262783','13261401','13261282','13261615','13262594','13262881','13261295','13261332','13261607','13262861','13262796','13261651','13261705','13261658','13261610','13261677','13263242','13261583','13261402','13261630','13261684','13261600','13261631','13261346','13261289','13263178','13261393','13263165','13261416','13262827','13262522','13262955','13263265','13262882','13263018','13263169','13262361','13262341','13261462','13263021','13263156','13262842','13261853','13261371','13262838','13263119','13262925','13262935','13261399','13263127','13261364','13262598','13262291','13262669','13262719','13262670','13263131','13263050','13262781','13262966','13261365','13262991','13262769','13262301','13262561','13262858','13261447','13262531','13262845','13262720','13262556','13262582','13262655','13261333','13262833','13262574','13261827','13263026','13263164','13263125','13262866','13263073','13261369','13262357','13262577','13262474','13261349','13262702','13262823','13262478','13262943','13262657','13262907','13262414','13262446','13262540','13263059','13263135','13261388','13262705','13261488','13262293','13263028','13261480','13262425','13263047','13262699','13262740','13261432','13261836','13262609','13261764','13263185','13262516','13262704','13263104','13261818','13261446','13261406','13263003','13261274','13262452','13263045','13262899','13262343','13262507','13262747','13261276','13261465','13262760','13261586','13262776','13261361','13261464','13261652','13262801','13263051','13262692','13262517','13262496','13262917','13263078','13263133','13261322','13261472','13262840','13261670','13261482','13261461','13261584','13261837','13261419','13262643','13262528','13262772','13262738','13262757','13261335','13263151','13263258','13263052','13263166','13261643','13261380','13261553','13262965','13261509','13262994','13262607','13262469','13262493','13262360','13263162','13262296','13262937','13262975','13261489','13261268','13262616','13261470','13261478','13263140','13262674','13263048','13263085','13263082','13263159','13262873','13262641','13262302','13262380','13262785','13262331','13262936','13262863','13263100','13262693','13262806','13263160','13262685','13261476','13261517','13261267','13261817','13262273','13262282','13262311','13262305','13262353','13262382','13262396','13262412','13262431','13262451','13262560','13262566','13262571','13262601','13262633','13262666','13262797','13262990','13262330','13261459','13261279','13263061','13261838','13263037','13263043','13263049','13263033','13261870','13261344','13263146','13262647','13263080','13262642','13263137','13261846','13262338','13262430','13261544','13261390','13263123','13261272','13261498','13263174','13262575','13262885','13262492','13263057','13261355','13262339','13262526','13262322','13262551','13262391','13263124','13262347','13262918','13263231','13262610','13262597','13261663','13261296','13263254','13261508','13262743','13263220','13263202','13263229','13263233','13263193','13263194','13263195','13263196','13263197','13263198','13263200','13263204','13263206','13263208','13263210','13263212','13263214','13263216','13263218','13263222','13263224','13263226','13263228','13263230','13263232','13261525','13261733','13262240','13262752','13261571','13261783','13263192','13263199','13263201','13263203','13263091','13262297','13262602','13262694','13261441','13263095','13263250','13262419','13262811','13262612','13263109','13263011','13262749','13263182','13262950','13262852','13261429','13261320','13262198','13262498','13262458','13262383','13261539','13263053','13261802','13262945','13262889','13262746','13262648','13262592','13262569','13262543','13262549','13262588','13262625','13262650','13262761','13262787','13262967','13262951','13263072','13262672','13262482','13262409','13262393','13262308','13262388','13262292','13262363','13262294','13262321','13262424','13262440','13262387','13262334','13262317','13262312','13262288','13262237','13262206','13262236','13262386','13262371','13262325','13262264','13262256','13262223','13262215','13262183','13261485','13263063','13262548','13262636','13262920','13262860','13261782','13263064','13262929','13263179','13263014','13263062','13262844','13262212','13262898','13262695','13262404','13262252','13262241','13262257','13262289','13262372','13262348','13262410','13262481','13262471','13262570','13262606','13262637','13263177','13262617','13262905','13262888','13262891','13261562','13262874','13262298','13262340','13261440','13262999','13262958','13262953','13262938','13262964','13262930','13262989','13261672','13262732','13261725','13263108','13263096','13261384','13262390','13262489','13263088','13262429','13262309','13262764','13263121','13262790','13263041','13262683','13262536','13262337','13261428','13262494','13262435','13262518','13262523','13263042','13262661','13262564','13262585','13262399','13262583','13262871','13262792','13262495','13262290','13263098','13261383','13263161','13262499','13262490','13262287','13261887','13263010','13263058','13262952','13263183','13262821','13263245','13261572','13262675','13262968','13261695','13262834','13263154','13261549','13263114','13262565','13263116','13262476','13262621','13263023','13261259','13262466','13262503','13262799','13261516','13262315','13262681','13263008','13262734','13262449','13262880','13263103','13261810','13261275','13261317','13261532','13261570','13263184','13262877','13263097','13262853','13261471','13263030','13262911','13262753','13261513','13262613','13261563','13262850','13262418','13263067','13261382','13262603','13262947','13262578','13262644','13262638','13262579','13262944','13262389','13261417','13263112','13261792','13261763','13263117','13263093','13263087','13261545','13261653','13262815','13261503','13263190','13262748','13263138','13261662','13262281','13262306','13262355','13262381','13262395','13262415','13262437','13262447','13262520','13262646','13262667','13262908','13262988','13261305','13261303','13263188','13263106','13263111','13262992','13261304','13263074','13263032','13262977','13261879','13261664','13263105','13263102','13263092','13262851','13262831','13262869','13262839','13261270','13263094','13262903','13261530','13262887','13262686','13261292','13261315','13261323','13262369','13262378','13262436','13262486','13262508','13262509','13262546','13262660','13262676','13262420','13262450','13262512','13262554','13262614','13262513','13262563','13262812','13262985','13262220','13263086','13261499','13262408','13263113','13261633','13262703','13262433','13262515','13262550','13262630','13262684','13263066','13261681','13263068','13261543','13262825','13262423','13261624','13262725','13262662','13261743','13263180','13261791','13262589','13262488','13263243','13262654','13262426','13262443','13262847','13262798','13262973','13263070','13263079','13262901','13261420','13262470','13262510','13262916','13262487','13263040','13263099','13263118','13262639','13262724','13261426','13262715','13262728','13263089','13262689','13262645','13261319','13262708','13262401','13262267','13262332','13262402','13262448','13262479','13262506','13262400','13262439','13262379','13262464','13262541','13262651','13263000','13262794','13262320','13262890','13262500','13262416','13262547','13262573','13262604','13262701','13262744','13261348','13262826','13262875','13262726','13262934','13262924','13262914','13263186','13263189','13261423','13261374','13262260','13262856','13262913','13261294','13262974','13263071','13261362','13262784','13263187','13261641','13261774','13263147','13262876','13262928','13262941','13261394','13263150','13263163','13263158','13263171','13261412','13263157','13261354','13262904','13263167','13263168','13261403','13263262','13261293','13261321','13262775','13262818','13262830','13262962','13262978','13262680','13262727','13261330','13263148','13262698','13262751','13262923','13262910','13262933','13263035','13262718','13262741','13262788','13262700','13262714','13262730','13262774','13262791','13262819','13262922','13262986','13262976','13262631','13263170','13262909','13262959','13262946','13262896','13262957','13263175','13262742','13263181','13262731','13262754','13262710','13262629','13262649','13262673','13262688','13262713','13262721','13262777','13262755','13262766','13262807','13262820','13262832','13262931','13262872','13262919','13262942','13262982','13261640','13262521','13262972','13261581','13261410','13261620','13261511','13261358','13263261','13261360','13261271','13262828','13262628','13263132','13261683','13261599','13262816','13262981','13263136','13261300','13261353','13261352','13261370','13261531','13262230','13261411','13262608','13262829','13262817','13261285','13262900','13262533','13263107','13262706','13263054','13262417','13262465','13262665','13262544','13262735','13261793','13263255','13262849','13263034','13262765','13263101','13262576','13262770','13261278','13262599','13261753','13262750','13263176','13262813','13262782','13262559','13261552','13262336','13262453','13262971','13262762','13262926','13262883','13262756','13262980','13261639','13261386','13261752','13262793','13261460','13262739','13263090','13262733','13262789','13261448','13262475','13262427','13262624','13262502','13261387','13261808','13261479','13261404','13262707','13261439','13261828','13262745','13261288','13262580','13263172','13261455','13261389','13262996','13261554','13262802','13263007','13261598','13261266','13262780','13261290','13261331','13262983','13261595','13261334','13261611','13262709','13263173','13262640','13262998','13263256','13262678','13261826','13262897','13262461','13263134','13261612','13262767','13263122','13262535','13262250','13261696','13262626','13262960','13262278','13262870','13261528','13262862','13261452','13262687','13262346','13262902','13262365','13262804','13263065','13262805','13262635','13262717','13261500','13261367','13263115','13261356','13262995','13262679','13263025','13262857','13262514','13263144','13263039','13261357','13262623','13262545','13261378','13262473','13262467','13263145','13262344','13261714','13263110','13262841','13262362','13262558','13262552','13262593','13262993','13262894','13261340','13261442','13262444','13262927','13262868','13262664','13263130','13262329','13262659','13262356','13262658','13262407','13261734','13262553','13263205','13263207','13263209','13263211','13263213','13263215','13263217','13263219','13263221','13263223','13263225','13263227','13263069','13261413','13262878','13262932','13262671','13262712','13262634','13262590','13262537','13262557','13262457','13262505','13262483','13262459','13262810','13263005','13263013','13262403','13263236','13263237','13263238','13263239','13263240','0') and ((gmt_offset_now IN('13.00','12.75','12.50','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','10.00','9.75','9.50','9.25','9.00','8.75','8.50','8.25','8.00','7.75','7.50','7.25','7.00','6.75','6.50','6.25','6.00','5.75','5.50','5.25','5.00','4.75','4.50','4.25','4.00','3.75','3.50','3.25','3.00','2.75','2.50','2.25','2.00','1.75','1.50','1.25','1.00','0.75','0.50','0.25','0.00','-0.25','-0.50','-0.75','-1.00','-1.25','-1.50','-1.75','-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50','-3.75','-4.00','-4.25','-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00','-6.25','-6.50','-6.75','-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50','-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-10.25','-10.50','-10.75','-11.00','-11.25','-11.50','-11.75','-12.00','-12.25','-12.50','-12.75','99') ) ) order by lead_id asc limit 2000;
  49. # Time: 170905 7:14:04
  50. # User@Host: cron[cron] @ [10.110.68.82]
  51. # Thread_id: 2878013 Schema: asterisk QC_hit: No
  52. # Query_time: 14.397639 Lock_time: 0.049624 Rows_sent: 67 Rows_examined: 10917566
  53. # Full_scan: Yes Full_join: No Tmp_table: Yes Tmp_table_on_disk: No
  54. # Filesort: Yes Filesort_on_disk: No Merge_passes: 0
  55. SET timestamp=1504620844;
  56. SELECT vls.list_id,list_name,list_description,count(*) as tally,active,list_lastcalldate,campaign_id,DATE_FORMAT(expiration_date,'%Y%m%d'),local_call_time from vicidial_lists vls,vicidial_list vl where vls.list_id=vl.list_id and campaign_id='SLD00001' group by list_id order by list_id;
  57. # Time: 170905 7:18:07
  58. # User@Host: cron[cron] @ [10.110.68.82]
  59. # Thread_id: 2907241 Schema: asterisk QC_hit: No
  60. # Query_time: 12.576137 Lock_time: 0.119772 Rows_sent: 67 Rows_examined: 10917566
  61. # Full_scan: Yes Full_join: No Tmp_table: Yes Tmp_table_on_disk: No
  62. # Filesort: Yes Filesort_on_disk: No Merge_passes: 0
  63. SET timestamp=1504621087;
  64. SELECT vls.list_id,list_name,list_description,count(*) as tally,active,list_lastcalldate,campaign_id,DATE_FORMAT(expiration_date,'%Y%m%d'),local_call_time from vicidial_lists vls,vicidial_list vl where vls.list_id=vl.list_id and campaign_id='SLD00001' group by list_id order by list_id;
  65. # Time: 170905 7:22:42
  66. # User@Host: cron[cron] @ [10.110.64.24]
  67. # Thread_id: 2936573 Schema: asterisk QC_hit: No
  68. # Query_time: 38.806029 Lock_time: 0.188788 Rows_sent: 2000 Rows_examined: 12605094
  69. SET timestamp=1504621362;
  70. SELECT lead_id,list_id,gmt_offset_now,phone_number,state,status,modify_date,user,vendor_lead_code FROM vicidial_list where called_since_last_reset='N' and status IN('HNGTX','U','HNGUP','DC','NA','N','DROP','B','AB','AA','A','NEW') and ((list_id IN('375','364','374'))) and lead_id NOT IN('13265092','13263917','13264754','13265226','13263540','13263896','13263641','13264108','13264171','13264099','13264050','13264066','13264054','13264015','13264040','13263891','13263903','13263913','13263818','13263643','13263784','13263464','13263861','13265055','13264862','13263551','13264638','13263841','13263952','13263876','13263496','13263940','13263608','13263954','13263832','13264100','13264131','13264127','13264094','13264096','13264103','13264053','13264032','13264068','13264019','13263976','13264072','13263963','13263894','13263860','13263872','13263836','13263750','13264769','13263787','13264717','13265122','13265241','13263919','13263640','13263660','13263722','13263792','13263951','13264112','13264102','13264119','13264086','13264041','13264037','13264071','13264025','13263984','13264056','13263945','13263901','13263873','13263874','13264744','13264138','13264087','13264095','13264058','13264024','13264031','13264059','13264028','13264006','13264013','13263977','13264061','13264016','13263950','13264009','13263934','13263850','13263881','13263855','13263826','13263842','13263798','13264823','13264699','13265181','13263760','13263845','13263723','13264712','13264958','13263761','13264711','13263715','13263743','13265232','13263690','13264899','13264851','13263745','13264940','13265049','13265205','13264801','13264972','13263858','13263770','13264707','13264683','13263749','13263497','13263916','13263668','13263727','13263764','13263700','13263659','13263741','13263650','13263477','13263558','13265261','13263490','13263443','13263912','13263906','13263886','13263905','13263853','13263834','13263819','13263776','13265095','13263769','13264841','13263614','13264023','13264027','13264001','13263989','13263987','13264074','13264063','13264010','13263946','13263949','13263883','13263875','13263820','13263864','13263870','13263854','13263830','13263753','13265188','13264608','13263765','13263851','13263767','13264765','13264810','13265106','13263738','13263665','13264619','13264798','13263630','13264575','13264890','13263606','13265161','13264782','13264975','13265030','13264939','13263898','13263862','13265264','13263812','13265152','13263771','13263570','13263503','13263915','13263811','13265137','13263693','13263733','13263494','13263666','13264721','13263451','13263624','13263618','13263676','13264684','13265157','13263482','13265133','13264655','13264553','13264537','13263616','13265196','13263778','13264949','13264737','13264805','13265192','13265211','13264547','13263779','13263601','13263789','13263889','13263973','13264259','13265203','13265206','13265215','13265214','13265219','13265242','13265233','13265234','13265253','13265244','13265250','13265257','13265204','13265213','13265218','13265225','13265236','13265256','13265220','13265247','13265260','13265239','13265248','13265255','13265263','13264656','13264663','13264584','13264609','13264642','13264589','13264727','13264845','13264745','13264499','13264598','13263686','13263644','13264820','13263546','13264795','13264591','13263521','13265136','13263658','13263679','13264583','13263742','13263579','13263593','13263544','13264621','13263657','13265128','13264548','13264516','13264573','13264653','13264574','13264626','13264560','13264534','13263751','13263719','13263465','13264828','13263576','13263720','13265146','13264870','13263597','13265124','13264518','13264542','13264513','13265258','13265169','13265164','13265160','13265190','13264562','13264596','13264632','13264648','13263574','13265175','13265168','13264692','13264673','13265110','13263649','13265229','13265051','13264984','13264723','13264587','13264581','13263697','13265031','13265005','13264932','13264848','13264785','13264665','13264605','13265210','13265074','13265015','13265023','13264997','13265173','13263628','13264606','13264916','13264796','13263462','13263564','13263541','13264824','13263509','13264865','13263501','13263419','13265252','13264695','13265201','13264690','13264550','13264528','13264607','13265184','13263713','13264905','13263538','13263412','13265212','13263694','13263533','13265174','13265199','13265148','13263432','13263559','13265162','13263566','13263511','13263813','13265032','13263444','13265200','13265265','13264514','13263584','13264729','13263747','13263413','13263959','13264624','13263476','13263724','13263519','13263625','13265151','13263814','13263504','13263681','13263718','13264602','13263677','13265071','13263838','13263674','13263626','13264503','13263455','13265008','13263939','13263755','13263528','13264983','13263542','13263588','13263513','13263726','13265017','13264965','13263508','13263479','13265115','13263664','13263671','13263673','13263567','13263615','13263581','13263486','13263474','13263435','13264960','13264819','13263554','13264671','13263516','13265155','13263439','13265135','13264976','13264678','13264258','13264611','13265167','13264763','13263613','13264859','13265127','13265113','13263648','13263725','13263478','13263448','13263415','13263505','13265231','13265254','13263498','13264722','13264561','13264704','13263582','13263645','13263536','13263460','13263678','13263633','13264535','13264876','13264959','13264877','13263667','13263526','13263547','13263684','13263599','13263569','13263473','13263453','13263416','13264645','13263737','13263578','13265096','13264566','13265228','13263562','13264558','13264597','13263543','13264543','13263550','13263662','13263452','13265208','13265080','13265086','13265094','13265179','13265217','13264767','13265114','13263732','13263703','13264500','13263409','13263632','13263594','13263433','13263475','13263687','13264775','13264787','13263702','13263573','13263557','13263424','13264664','13265176','13264672','13263472','13264524','13265058','13263731','13263635','13264996','13264846','13263740','13265144','13264579','13265243','13263652','13263517','13263428','13264685','13264948','13265132','13263675','13264658','13263997','13264582','13263603','13265081','13263577','13264786','13264953','13263449','13265202','13264835','13263414','13263524','13263695','13263736','13265249','13264893','13264725','13264618','13264861','13263461','13263669','13265088','13263871','13264107','13264051','13264039','13264097','13264891','13264749','13265153','13265194','13264702','13263556','13263672','13263450','13263638','13263712','13264868','13263427','13265221','13263655','13264908','13265082','13263888','13263689','13263535','13264800','13263796','13263995','13263879','13263937','13263728','13263744','13265156','13264592','13263983','13263980','13264617','13263717','13263890','13264012','13264923','13265018','13264762','13263808','13264038','13263880','13263943','13263839','13263636','13263489','13265140','13265118','13263506','13265093','13265091','13265089','13265087','13265085','13265084','13265079','13265078','13265077','13265076','13265075','13265073','13265070','13265068','13265066','13265064','13263598','13263572','13263531','13264743','13264758','13264766','13264847','13264802','13264879','13264898','13264809','13264827','13264857','13264880','13264904','13264912','13264954','13264918','13264933','13265195','13265013','13264808','13265158','13263480','13265227','13265154','13264931','13264625','13263692','13263515','13263706','13263514','13263680','13265039','13263447','13263590','13264971','13265159','13265149','13263711','13263430','13263438','13263434','13263441','13263446','13263458','13263468','13263493','13263499','13263463','13263471','13263529','13263549','13263491','13263530','13263552','13263587','13263522','13263537','13263545','13263583','13263525','13263708','13263585','13263589','13263561','13263746','13263596','13263609','13263611','13263612','13263627','13263716','13263705','13263685','13263634','13263571','13263575','13263610','13263623','13263622','13263631','13263654','13263707','13263748','13263646','13263647','13263709','13263688','13263651','13263492','13263759','13264778','13265186','13263591','13265102','13263699','13264999','13263837','13263899','13263806','13264623','13263772','13263960','13263483','13263442','13263548','13264650','13265046','13264963','13265143','13264594','13264966','13264549','13263823','13263817','13263935','13263481','13263507','13263824','13263967','13265109','13263437','13263459','13263656','13263602','13264764','13263457','13263568','13264686','13264826','13264911','13263417','13263421','13263431','13263440','13263670','13265123','13263527','13264882','13264887','13263663','13263539','13265121','13265262','13263553','13263467','13264728','13265125','13265207','13265224','13264356','13265238','13263762','13264726','13264917','13263592','13264867','13263495','13264900','13263512','13265145','13265139','13264620','13264791','13264777','13264897','13265120','13264614','13264781','13264630','13265171','13265065','13263560','13263619','13264651','13265166','13263788','13264688','13263426','13263629','13265117','13265180','13265170','13265182','13265198','13263429','13265083','13265104','13265183','13263423','13263502','13265197','13265237','13265100','13265090','13265191','13265223','13264637','13263734','13264788','13264666','13264643','13264849','13264756','13264680','13265150','13264774','13264850','13264682','13265230','13263972','13263605','13264950','13265105','13265099','13265097','13263682','13265108','13265101','13265103','13263484','13263739','13263639','13263617','13263580','13265098','13265119','13265116','13265107','13265052','13265045','13265061','13265047','13265044','13265041','13265067','13265060','13265056','13265048','13265059','13265050','13265037','13265033','13265027','13265022','13265040','13265063','13265038','13265036','13265009','13264978','13264990','13264980','13265024','13265020','13265011','13265035','13265028','13265042','13265072','13265062','13265034','13265014','13264995','13264974','13265025','13264929','13264914','13264945','13264989','13264979','13265021','13265003','13265000','13264986','13264964','13265001','13264985','13265010','13265016','13264994','13264981','13264987','13264967','13264973','13264991','13264992','13264962','13264919','13264913','13264970','13264944','13264921','13264930','13264937','13264910','13264938','13264927','13264924','13264922','13264920','13264915','13264993','13264988','13264977','13264936','13264926','13265002','13264961','13264956','13264928','13264941','13264909','13265012','13264934','13264817','13264951','13264957','13264952','13264942','13264935','13264907','13264903','13264902','13264955','13264943','13264901','13264906','13264895','13264894','13264889','13264884','13264873','13264869','13264854','13264839','13264886','13264878','13264863','13264843','13264875','13264871','13264830','13264815','13264793','13264779','13264811','13264792','13264776','13264888','13264883','13264872','13264860','13264837','13264821','13264833','13264822','13264818','13264807','13264784','13264896','13264797','13264790','13264892','13264885','13264881','13264874','13264840','13264814','13264806','13264832','13264844','13264829','13264812','13264804','13264794','13264864','13264855','13264852','13264838','13264842','13264825','13264816','13264783','13264773','13264772','13264771','13264770','13264768','13264761','13264760','13264759','13264757','13264755','13264753','13264752','13264751','13264748','13264732','13264738','13264734','13264716','13264742','13264713','13264735','13264701','13264615','13264696','13264691','13264674','13264668','13264741','13264739','13264720','13264736','13264719','13264703','13264700','13264705','13264731','13264714','13264697','13264694','13264676','13264670','13264662','13264660','13264649','13264646','13264641','13264730','13264724','13264718','13264709','13264733','13264706','13264635','13264633','13264631','13264629','13264616','13264613','13264612','13264610','13264689','13264687','13264681','13264639','13264679','13264675','13264669','13264667','13264640','13264636','13264628','13264604','13264601','13264595','13264580','13264576','13264564','13264544','13264659','13264599','13264634','13264588','13264538','13264559','13264552','13264568','13264536','13264520','13264567','13264546','13264569','13264551','13264565','13264539','13264531','13264527','13264521','13264519','13264517','13264554','13264526','13264555','13264585','13264578','13264572','13264556','13264540','13264644','13264657','13264593','13264586','13264577','13264570','13264532','13264512','13264563','13264530','13264557','13264522','13264545','13264541','13264529','13264525','13264523','13264511','13264509','13264508','13264510','13264498','13264494','13264490','13264484','13264486','13264478','13264469','13264504','13264466','13264425','13264421','13264474','13264460','13264448','13264441','13264507','13264491','13264487','13264479','13264505','13264492','13264480','13264476','13264472','13264495','13264493','13264475','13264481','13264433','13264502','13264497','13264470','13264483','13264461','13264506','13264488','13264482','13264463','13264501','13264496','13264489','13264485','13264467','13264458','13264454','13264446','13264464','13264447','13264426','13264477','13264457','13264427','13264468','13264450','13264449','13264473','13264455','13264442','13264422','13264434','13264432','13264419','13264456','13264444','13264437','13264431','13264429','13264440','13264424','13264417','13264462','13264438','13264414','13264465','13264459','13264452','13264443','13264436','13264420','13264471','13264453','13264423','13264451','13264445','13264439','13264435','13264430','13264428','13264409','13264415','13264413','13264407','13264418','13264411','13264410','13264400','13264404','13264402','13264392','13264381','13264416','13264399','13264412','13264401','13264385','13264383','13264380','13264378','13264397','13264398','13264376','13264403','13264395','13264391','13264408','13264393','13264396','13264390','13264387','13264405','13264388','13264406','13264386','13264384','13264382','13264379','13264377','13264389','13264394','13264375','13264374','13264373','13264370','13264368','13264372','13264371','13264369','13264366','13264362','13264360','13264340','13264332','13264334','13264328','13264357','13264349','13264346','13264364','13264338','13264343','13264352','13264336','13264330','13264325','13264321','13264311','13264302','13264365','13264344','13264337','13264323','13264317','13264309','13264315','13264306','13264298','13264358','13264361','13264300','13264363','13264354','13264333','13264327','13264313','13264339','13264331','13264347','13264318','13264319','13264304','13264367','13264351','13264329','13264341','13264322','13264316','13264335','13264326','13264320','13264324','13264314','13264312','13264310','13264308','13264359','13264353','13264297','13264295','13264293','13264291','13264350','13264348','13264345','13264342','13264284','13264281','13264232','13264242','13264236','13264273','13264256','13264240','13264261','13264251','13264245','13264231','13264274','13264307','13264305','13264303','13264301','13264299','13264296','13264294','13264292','13264290','13264289','13264288','13264287','13264286','13264285','13264283','13264280','13264277','13264275','13264278','13264271','13264268','13264266','13264264','13264260','13264254','13264252','13264250','13264282','13264237','13264269','13264248','13264279','13264276','13264267','13264244','13264272','13264255','13264247','13264233','13264229','13264265','13264246','13264241','13264234','13264270','13264263','13264238','13264262','13264257','13264253','13264249','13264222','13264243','13264239','13264235','13264230','13264227','13264225','13264198','13264196','13264176','13264190','13264184','13264182','13264173','13264164','13264220','13264213','13264207','13264201','13264215','13264200','13264204','13264192','13264161','13264144','13264143','13264132','13264155','13264153','13264117','13264223','13264217','13264209','13264205','13264226','13264221','13264147','13264211','13264194','13264228','13264179','13264152','13264151','13264137','13264129','13264146','13264145','13264218','13264114','13264224','13264219','13264170','13264187','13264167','13264158','13264148','13264139','13264141','13264135','13264126','13264123','13264150','13264142','13264149','13264120','13264111','13264109','13264212','13264208','13264203','13264199','13264195','13264216','13264214','13264210','13264206','13264202','13264197','13264193','13264191','13264189','13264186','13264183','13264180','13264177','13264174','13264163','13264160','13264166','13264125','13264124','13264106','13264081','13264154','13264134','13264162','13264122','13264105','13264089','13264083','13264169','13264165','13264175','13264130','13264116','13264157','13264090','13264185','13264159','13264140','13264101','13264168','13264085','13264133','13264136','13264110','13264118','13264104','13264092','13264188','13264113','13264091','13264093','13264128','13264082','13264156','13264098','13264115','13264181','13264121','13264055','13264084','13264079','13264080','13264078','13264043','13264070','13264052','13264036','13264018','13264046','13264029','13264021','13264004','13264069','13264049','13264030','13264077','13264076','13264075','13264073','13264064','13264057','13264045','13264062','13264048','13264067','13264026','13264014','13264005','13263998','13263996','13263994','13263992','13263986','13263971','13263985','13263981','13263968','13263991','13263978','13263974','13263979','13264035','13264008','13264020','13264022','13264002','13264007','13263965','13263895','13263893','13263885','13264011','13263964','13263962','13263914','13263892','13263887','13263928','13263923','13263884','13263882','13263877','13263865','13263844','13263907','13263856','13263825','13263869','13263922','13263910','13263863','13263835','13263822','13263902','13263843','13263868','13263852','13263807','13263791','13263780','13263758','13263721','13263821','13263799','13263795','13263766','13263729','13263653','13264571','13263523','13263410','13263485','13264803','13265112','13263563','13263859','13263840','13263827','13263800','13263802','13263794','13263809','13263783','13263785','13263777','13263774','13263782','13263698','13263595','13264746','13265131','13263600','13264600','13263714','13264677','13263683','13265026','13265069','13264698','13263833','13264969','13263500','13263829','13263847','13263846','13263810','13263804','13263775','13263420','13264982','13265172','13264853','13265138','13264799','13265029','13265043','13263418','13263454','13263510','13263604','13263565','13264747','13263487','13263518','13264693','13265251','13263436','13265245','13264661','13265240','13263532','13263637','13265235','13264968','13264715','13263488','13265126','13263756','13263797','13263763','13263793','13263866','13263849','13263938','13263900','13263944','13263929','13263957','13263955','13263927','13263921','13263908','13263936','13263988','13264355','13265111','13265007','13263803','13263931','13263941','13263904','13263970','13263926','13264515','13263816','13263768','13263831','13263781','13263911','13263953','13263948','13264017','13263701','13264780','13263754','13263757','13264603','13263857','13263942','13263958','13263924','13263947','13263933','13263918','13263956','13264034','13263969','13263982','13265178','13263469','13264925','13264652','13264858','13263704','13263411','13264831','13264622','13263691','13263607','13265129','13264947','13264813','13263586','13264856','13264627','13264708','13263445','13265165','13265141','13264654','13265057','13265246','13264836','13264647','13263661','13265147','13264750','13263730','13264946','13265187','13265216','13264533','13265193','13265130','13265177','13265163','13264866','13264740','13263642','13265189','13263710','13263790','13263801','13264789','13265209','13264998','13263735','13263815','13265142','13265019','13263786','13263848','13263805','13263897','13263878','13263828','13263867','13263932','13263990','13263961','13264003','13263975','13263966','13263993','13264000','13264033','13264047','13264044','13264042','13264065','13264060','13264172','13264088','13264178','13263773','13263520','13263470','13263752','13263425','13263534','13263456','13263620','13265134','13263696','13263466','13263930','13263999','13264590','13264834','13265185','13265259','13264710','13263555','13265222','13265053','13263925','13265054','13265004','13263909','13263920','13263621','13263422','0') and ((gmt_offset_now IN('13.00','12.75','12.50','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','10.00','9.75','9.50','9.25','9.00','8.75','8.50','8.25','8.00','7.75','7.50','7.25','7.00','6.75','6.50','6.25','6.00','5.75','5.50','5.25','5.00','4.75','4.50','4.25','4.00','3.75','3.50','3.25','3.00','2.75','2.50','2.25','2.00','1.75','1.50','1.25','1.00','0.75','0.50','0.25','0.00','-0.25','-0.50','-0.75','-1.00','-1.25','-1.50','-1.75','-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50','-3.75','-4.00','-4.25','-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00','-6.25','-6.50','-6.75','-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50','-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-10.25','-10.50','-10.75','-11.00','-11.25','-11.50','-11.75','-12.00','-12.25','-12.50','-12.75','99') ) ) order by lead_id asc limit 2000;
  71. # Time: 170905 7:23:19
  72. # User@Host: cron[cron] @ [10.110.64.24]
  73. # Thread_id: 2804501 Schema: asterisk QC_hit: No
  74. # Query_time: 14.157746 Lock_time: 0.000038 Rows_sent: 1 Rows_examined: 12692929
  75. # Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
  76. # Filesort: No Filesort_on_disk: No Merge_passes: 0
  77. SET timestamp=1504621399;
  78. select count(*) from vicidial_list where phone_code='57';
  79. # Time: 170905 7:23:34
  80. # User@Host: cron[cron] @ [10.110.64.24]
  81. # Thread_id: 2804501 Schema: asterisk QC_hit: No
  82. # Query_time: 15.076320 Lock_time: 0.007393 Rows_sent: 1 Rows_examined: 12692929
  83. # Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
  84. # Filesort: No Filesort_on_disk: No Merge_passes: 0
  85. SET timestamp=1504621414;
  86. select count(*) from vicidial_list where phone_code='57' and (gmt_offset_now != '-5' or gmt_offset_now IS NULL);
  87. # Time: 170905 7:23:48
  88. # User@Host: cron[cron] @ [10.110.64.24]
  89. # Thread_id: 2804501 Schema: asterisk QC_hit: No
  90. # Query_time: 14.025102 Lock_time: 0.006632 Rows_sent: 1 Rows_examined: 12692929
  91. # Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
  92. # Filesort: No Filesort_on_disk: No Merge_passes: 0
  93. SET timestamp=1504621428;
  94. select count(*) from vicidial_list where phone_code='57';
  95. # Time: 170905 7:24:02
  96. # User@Host: cron[cron] @ [10.110.64.24]
  97. # Thread_id: 2804501 Schema: asterisk QC_hit: No
  98. # Query_time: 14.721104 Lock_time: 0.003559 Rows_sent: 1 Rows_examined: 12692929
  99. # Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
  100. # Filesort: No Filesort_on_disk: No Merge_passes: 0
  101. SET timestamp=1504621442;
  102. select count(*) from vicidial_list where phone_code='57' and (gmt_offset_now != '-5' or gmt_offset_now IS NULL);
  103. # Time: 170905 7:24:17
  104. # User@Host: cron[cron] @ [10.110.64.24]
  105. # Thread_id: 2804501 Schema: asterisk QC_hit: No
  106. # Query_time: 14.663170 Lock_time: 0.002827 Rows_sent: 1 Rows_examined: 12692929
  107. # Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
  108. # Filesort: No Filesort_on_disk: No Merge_passes: 0
  109. SET timestamp=1504621457;
  110. select count(*) from vicidial_list where phone_code='57';
  111. # Time: 170905 7:24:32
  112. # User@Host: cron[cron] @ [10.110.64.24]
  113. # Thread_id: 2804501 Schema: asterisk QC_hit: No
  114. # Query_time: 15.255245 Lock_time: 0.001891 Rows_sent: 1 Rows_examined: 12692929
  115. # Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
  116. # Filesort: No Filesort_on_disk: No Merge_passes: 0
  117. SET timestamp=1504621472;
  118. select count(*) from vicidial_list where phone_code='57' and (gmt_offset_now != '-5' or gmt_offset_now IS NULL);
  119. # Time: 170905 7:24:47
  120. # User@Host: cron[cron] @ [10.110.64.24]
  121. # Thread_id: 2804501 Schema: asterisk QC_hit: No
  122. # Query_time: 14.190154 Lock_time: 0.000446 Rows_sent: 1 Rows_examined: 12692929
  123. # Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
  124. # Filesort: No Filesort_on_disk: No Merge_passes: 0
  125. SET timestamp=1504621487;
  126. select count(*) from vicidial_list where phone_code='57';
  127. # Time: 170905 7:25:02
  128. # User@Host: cron[cron] @ [10.110.64.24]
  129. # Thread_id: 2804501 Schema: asterisk QC_hit: No
  130. # Query_time: 15.047901 Lock_time: 0.000294 Rows_sent: 1 Rows_examined: 12692929
  131. # Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
  132. # Filesort: No Filesort_on_disk: No Merge_passes: 0
  133. SET timestamp=1504621502;
  134. select count(*) from vicidial_list where phone_code='57' and (gmt_offset_now != '-5' or gmt_offset_now IS NULL);
  135. # Time: 170905 7:25:15
  136. # User@Host: cron[cron] @ [10.110.68.82]
  137. # Thread_id: 2954947 Schema: asterisk QC_hit: No
  138. # Query_time: 23.444998 Lock_time: 9.796625 Rows_sent: 67 Rows_examined: 10917566
  139. # Full_scan: Yes Full_join: No Tmp_table: Yes Tmp_table_on_disk: No
  140. # Filesort: Yes Filesort_on_disk: No Merge_passes: 0
  141. SET timestamp=1504621515;
  142. SELECT vls.list_id,list_name,list_description,count(*) as tally,active,list_lastcalldate,campaign_id,DATE_FORMAT(expiration_date,'%Y%m%d'),local_call_time from vicidial_lists vls,vicidial_list vl where vls.list_id=vl.list_id and campaign_id='SLD00001' group by list_id order by list_id;
  143. # Time: 170905 7:25:16
  144. # User@Host: cron[cron] @ [10.110.64.24]
  145. # Thread_id: 2804501 Schema: asterisk QC_hit: No
  146. # Query_time: 14.713495 Lock_time: 0.000033 Rows_sent: 1 Rows_examined: 12692929
  147. # Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
  148. # Filesort: No Filesort_on_disk: No Merge_passes: 0
  149. SET timestamp=1504621516;
  150. select count(*) from vicidial_list where phone_code='57';
  151. # Time: 170905 7:25:32
  152. # User@Host: cron[cron] @ [10.110.64.24]
  153. # Thread_id: 2804501 Schema: asterisk QC_hit: No
  154. # Query_time: 15.218148 Lock_time: 0.000042 Rows_sent: 1 Rows_examined: 12692929
  155. # Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
  156. # Filesort: No Filesort_on_disk: No Merge_passes: 0
  157. SET timestamp=1504621532;
  158. select count(*) from vicidial_list where phone_code='57' and (gmt_offset_now != '-5' or gmt_offset_now IS NULL);
  159. # Time: 170905 7:25:46
  160. # User@Host: cron[cron] @ [10.110.64.24]
  161. # Thread_id: 2804501 Schema: asterisk QC_hit: No
  162. # Query_time: 14.853811 Lock_time: 0.000388 Rows_sent: 1 Rows_examined: 12692929
  163. # Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
  164. # Filesort: No Filesort_on_disk: No Merge_passes: 0
  165. SET timestamp=1504621546;
  166. select count(*) from vicidial_list where phone_code='57';
  167. # Time: 170905 7:26:02
  168. # User@Host: cron[cron] @ [10.110.64.24]
  169. # Thread_id: 2804501 Schema: asterisk QC_hit: No
  170. # Query_time: 15.218241 Lock_time: 0.000393 Rows_sent: 1 Rows_examined: 12692929
  171. # Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
  172. # Filesort: No Filesort_on_disk: No Merge_passes: 0
  173. SET timestamp=1504621562;
  174. select count(*) from vicidial_list where phone_code='57' and (gmt_offset_now != '-5' or gmt_offset_now IS NULL);
  175. # Time: 170905 7:26:17
  176. # User@Host: cron[cron] @ [10.110.64.24]
  177. # Thread_id: 2804501 Schema: asterisk QC_hit: No
  178. # Query_time: 15.044620 Lock_time: 0.000035 Rows_sent: 1 Rows_examined: 12692929
  179. # Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
  180. # Filesort: No Filesort_on_disk: No Merge_passes: 0
  181. SET timestamp=1504621577;
  182. select count(*) from vicidial_list where phone_code='57';
  183. # Time: 170905 7:26:32
  184. # User@Host: cron[cron] @ [10.110.64.24]
  185. # Thread_id: 2804501 Schema: asterisk QC_hit: No
  186. # Query_time: 15.208487 Lock_time: 0.000368 Rows_sent: 1 Rows_examined: 12692929
  187. # Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
  188. # Filesort: No Filesort_on_disk: No Merge_passes: 0
  189. SET timestamp=1504621592;
  190. select count(*) from vicidial_list where phone_code='57' and (gmt_offset_now != '-5' or gmt_offset_now IS NULL);
  191. # Time: 170905 7:26:47
  192. # User@Host: cron[cron] @ [10.110.64.24]
  193. # Thread_id: 2804501 Schema: asterisk QC_hit: No
  194. # Query_time: 14.991323 Lock_time: 0.000096 Rows_sent: 1 Rows_examined: 12692929
  195. # Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
  196. # Filesort: No Filesort_on_disk: No Merge_passes: 0
  197. SET timestamp=1504621607;
  198. select count(*) from vicidial_list where phone_code='57';
  199. # Time: 170905 7:27:00
  200. # User@Host: cron[cron] @ [10.110.64.24]
  201. # Thread_id: 2804501 Schema: asterisk QC_hit: No
  202. # Query_time: 13.126367 Lock_time: 0.000193 Rows_sent: 1 Rows_examined: 12692929
  203. # Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
  204. # Filesort: No Filesort_on_disk: No Merge_passes: 0
  205. SET timestamp=1504621620;
  206. select count(*) from vicidial_list where phone_code='57' and (gmt_offset_now != '-5' or gmt_offset_now IS NULL);
  207. # Time: 170905 7:27:14
  208. # User@Host: cron[cron] @ [10.110.68.82]
  209. # Thread_id: 2968269 Schema: asterisk QC_hit: No
  210. # Query_time: 17.780209 Lock_time: 4.000754 Rows_sent: 67 Rows_examined: 10917566
  211. # Full_scan: Yes Full_join: No Tmp_table: Yes Tmp_table_on_disk: No
  212. # Filesort: Yes Filesort_on_disk: No Merge_passes: 0
  213. SET timestamp=1504621634;
  214. SELECT vls.list_id,list_name,list_description,count(*) as tally,active,list_lastcalldate,campaign_id,DATE_FORMAT(expiration_date,'%Y%m%d'),local_call_time from vicidial_lists vls,vicidial_list vl where vls.list_id=vl.list_id and campaign_id='SLD00001' group by list_id order by list_id;
  215. # Time: 170905 7:30:25
  216. # User@Host: cron[cron] @ [10.110.68.82]
  217. # Thread_id: 2994634 Schema: asterisk QC_hit: No
  218. # Query_time: 14.179769 Lock_time: 0.000071 Rows_sent: 67 Rows_examined: 10917566
  219. # Full_scan: Yes Full_join: No Tmp_table: Yes Tmp_table_on_disk: No
  220. # Filesort: Yes Filesort_on_disk: No Merge_passes: 0
  221. SET timestamp=1504621825;
  222. SELECT vls.list_id,list_name,list_description,count(*) as tally,active,list_lastcalldate,campaign_id,DATE_FORMAT(expiration_date,'%Y%m%d'),local_call_time from vicidial_lists vls,vicidial_list vl where vls.list_id=vl.list_id and campaign_id='SLD00001' group by list_id order by list_id;
  223. # Time: 170905 7:31:39
  224. # User@Host: cron[cron] @ [10.110.64.24]
  225. # Thread_id: 3000630 Schema: asterisk QC_hit: No
  226. # Query_time: 36.120460 Lock_time: 0.001572 Rows_sent: 2000 Rows_examined: 12607094
  227. SET timestamp=1504621899;
  228. SELECT lead_id,list_id,gmt_offset_now,phone_number,state,status,modify_date,user,vendor_lead_code FROM vicidial_list where called_since_last_reset='N' and status IN('HNGTX','U','HNGUP','DC','NA','N','DROP','B','AB','AA','A','NEW') and ((list_id IN('375','364','374'))) and lead_id NOT IN('13267261','13266134','13265657','13266844','13267109','13266414','13266322','13266392','13265977','13266162','13266228','13266196','13266380','13266485','13265978','13266004','13266422','13265966','13265725','13265805','13266803','13266973','13267223','13265904','13266889','13265794','13265862','13265915','13266093','13266235','13266052','13267168','13267166','13265551','13266086','13266454','13266329','13266002','13266102','13265752','13265789','13267245','13265895','13266063','13265841','13265533','13265482','13266242','13265753','13265539','13265967','13265818','13267147','13265820','13265933','13265955','13266186','13265642','13267012','13265981','13265684','13267165','13265855','13265535','13266463','13267096','13266881','13265956','13265780','13265609','13265613','13265617','13265648','13265683','13265696','13265716','13265578','13265580','13265582','13265705','13265710','13265593','13265700','13265667','13266281','13266955','13267177','13267148','13266210','13266148','13267049','13267242','13267023','13265885','13265614','13265909','13265814','13265587','13267247','13265858','13265532','13266014','13265734','13265647','13265835','13266149','13266043','13267192','13266376','13265513','13265537','13266340','13266211','13265508','13267211','13267051','13265714','13265597','13265603','13265615','13265655','13265689','13265708','13265682','13265690','13266775','13267169','13267035','13265807','13265601','13265612','13265622','13265706','13265719','13265736','13267248','13265471','13265658','13265831','13266901','13265765','13265781','13265808','13265717','13265778','13265787','13266962','13267224','13265993','13265846','13265873','13265935','13265938','13265957','13265910','13265937','13265848','13265874','13265880','13266060','13265988','13266020','13266001','13266021','13266066','13266068','13266070','13266076','13266042','13266088','13266081','13266071','13266123','13266116','13266096','13266135','13266079','13266062','13266125','13266176','13266097','13266246','13266213','13266217','13266231','13266232','13266184','13266082','13266087','13266107','13266182','13266117','13266106','13266174','13266154','13266187','13266193','13266201','13266205','13266219','13266218','13266272','13266304','13266330','13266254','13266288','13266270','13266293','13266318','13266353','13266355','13266387','13266425','13266373','13266251','13266405','13266471','13266369','13266383','13266407','13266302','13266336','13266378','13266395','13266429','13266449','13266465','13266371','13266415','13266245','13266273','13266237','13266247','13266428','13266467','13266279','13266311','13266323','13266333','13266337','13266352','13266364','13266309','13266320','13266324','13266327','13266331','13266339','13266343','13266347','13266354','13266362','13266368','13266372','13266374','13266375','13266377','13266381','13266384','13266386','13266391','13266402','13266417','13266438','13266400','13266446','13266430','13266440','13266389','13266267','13266307','13266289','13266453','13266313','13266416','13266257','13266435','13266271','13266255','13266319','13266325','13266328','13266345','13266360','13266466','13266456','13266470','13266473','13266477','13266478','13266479','13266481','13266483','13266489','13266406','13266411','13266423','13266436','13266448','13266452','13266394','13266408','13266421','13266432','13266442','13266404','13266418','13266458','13266464','13266468','13266472','13266474','13266476','13266480','13266460','13266487','13266491','13266493','13266495','13266497','13266501','13266503','13266505','13266486','13266492','13266502','13266568','13266496','13266504','13266509','13266516','13266524','13266482','13266490','13266484','13266498','13266514','13266507','13266537','13266494','13266549','13266562','13266543','13266556','13266525','13266508','13266510','13266518','13266528','13266488','13266500','13266506','13266512','13266520','13266531','13266542','13266557','13266566','13266535','13266522','13266529','13266533','13266546','13266560','13266539','13266552','13266572','13266576','13266515','13266532','13266553','13266563','13266548','13266570','13266574','13266511','13266519','13266523','13266540','13266547','13266530','13266538','13266545','13266551','13266565','13266575','13266581','13266594','13266555','13266559','13266564','13266569','13266513','13266521','13266536','13266526','13266541','13266554','13266561','13266567','13266517','13266527','13266544','13266550','13266571','13266578','13266584','13266583','13266579','13266586','13266597','13266595','13266603','13266616','13266638','13266600','13266577','13266534','13266558','13266573','13266580','13266588','13266587','13266589','13266607','13266609','13266629','13266620','13266593','13266582','13266590','13266592','13266585','13266596','13266598','13266591','13266602','13266599','13266606','13266613','13266621','13266632','13266612','13266645','13266605','13266601','13266604','13266608','13266611','13266614','13266619','13266625','13266617','13266622','13266626','13266636','13266610','13266624','13266634','13266618','13266623','13266630','13266615','13266628','13266637','13266640','13266643','13266646','13266648','13266650','13266654','13266660','13266664','13266668','13266672','13266676','13266693','13266641','13266698','13266627','13266631','13266712','13266703','13266708','13266652','13266656','13266658','13266662','13266666','13266691','13266772','13266695','13266709','13266715','13266723','13266727','13266732','13266717','13266735','13266739','13266743','13266748','13266754','13266635','13266642','13266647','13266653','13266673','13266665','13266651','13266692','13266685','13266661','13266663','13266684','13266694','13266669','13266700','13266704','13266711','13266736','13266722','13266758','13266762','13266766','13266770','13266699','13266705','13266670','13266674','13266713','13266725','13266733','13266737','13266745','13266701','13266719','13266730','13266721','13266741','13266751','13266633','13266639','13266644','13266649','13266657','13266659','13266671','13266655','13266682','13266687','13266678','13266677','13266689','13266702','13266681','13266707','13266742','13266738','13266726','13266744','13266764','13266768','13266776','13266667','13266680','13266688','13266683','13266690','13266675','13266686','13266706','13266714','13266798','13266753','13266786','13266720','13266780','13266696','13266679','13266697','13266710','13266740','13266729','13266760','13266782','13266812','13266790','13266794','13266774','13266778','13266784','13266750','13266788','13266792','13266796','13266800','13266802','13266804','13266734','13266731','13266728','13266724','13266718','13266746','13266716','13266749','13266859','13266759','13266763','13266785','13266756','13266773','13266836','13266806','13266808','13266810','13266814','13266816','13266818','13266807','13266811','13266819','13266834','13266837','13266847','13266872','13266875','13266880','13266813','13266827','13266820','13266826','13266833','13266839','13266851','13266848','13266755','13266779','13266771','13266879','13266824','13266854','13266747','13266761','13266868','13266769','13266767','13266777','13266797','13266801','13266815','13266831','13266840','13266873','13266887','13266870','13266849','13266789','13266793','13266890','13266830','13266842','13266855','13266752','13266765','13266787','13266781','13266783','13266795','13266799','13266809','13266817','13266843','13266860','13266878','13266828','13266835','13266858','13266863','13266865','13266869','13266882','13266886','13266893','13266895','13266897','13266898','13266903','13266905','13266909','13266913','13266921','13266925','13266866','13266832','13266838','13266852','13266856','13266864','13266877','13266888','13266894','13266899','13266904','13266929','13266867','13266884','13266896','13266902','13266907','13266919','13266927','13266931','13266934','13266935','13266941','13266944','13266911','13266923','13266861','13267004','13266951','13266956','13266969','13266977','13267016','13266980','13267013','13267010','13266999','13266947','13266953','13266959','13266975','13267002','13267026','13266989','13267040','13266986','13267034','13266972','13266983','13267007','13267029','13267031','13267037','13267043','13266981','13266988','13266992','13267046','13267055','13267058','13267061','13267064','13267067','13267070','13267075','13267078','13267084','13267087','13266942','13266945','13266948','13266950','13266954','13266957','13266966','13266968','13266971','13266974','13266978','13266984','13266990','13267008','13267014','13267022','13267028','13267044','13267050','13267053','13267065','13267104','13267001','13267019','13267041','13267076','13267094','13267110','13267102','13267047','13267082','13267098','13267137','13267119','13267164','13267182','13267124','13267155','13266910','13267141','13266916','13267176','13266933','13266922','13266952','13266982','13266994','13266932','13267015','13267134','13266920','13266918','13266914','13266985','13266938','13267130','13266991','13266964','13267011','13267025','13267068','13267079','13267100','13267153','13267106','13267122','13267072','13267085','13267120','13267174','13267149','13267178','13266908','13267151','13267172','13267184','13267039','13266949','13267129','13266979','13267000','13267027','13267054','13267101','13266946','13266987','13267024','13267127','13266943','13267048','13267045','13267077','13267093','13267099','13267126','13267142','13266997','13266924','13266940','13267042','13267021','13267066','13267018','13267036','13267073','13267080','13267107','13267135','13267121','13267105','13267154','13267091','13267095','13267103','13267117','13267128','13267131','13267138','13267150','13267123','13267152','13267157','13267158','13267163','13267167','13267173','13267183','13267190','13267175','13267185','13267189','13267069','13266958','13267196','13267199','13267201','13267203','13267198','13267200','13267202','13267208','13267215','13267216','13267220','13267229','13267235','13267228','13267217','13267219','13267222','13267230','13267236','13267239','13267241','13267237','13267255','13267260','13267259','13267265','13267262','13267249','13267252','13267257','13265507','13267254','13265538','13265504','13265545','13265764','13265853','13265724','13265971','13265918','13266053','13266263','13265681','13265607','13267171','13265995','13265946','13267180','13266065','13265792','13266912','13265812','13265906','13267092','13267081','13267074','13266906','13267017','13266970','13267145','13266995','13266926','13267143','13265495','13265512','13265893','13266112','13265718','13265791','13265576','13265505','13266401','13266437','13267210','13265712','13265531','13265843','13266791','13267264','13265851','13265552','13265748','13265743','13265536','13266056','13266297','13265985','13265877','13265982','13265528','13265670','13265950','13265691','13265634','13265975','13266277','13266137','13265815','13267226','13266090','13265837','13265876','13266147','13266094','13266016','13265861','13266111','13266853','13265699','13265515','13265541','13265810','13265621','13266409','13266105','13266199','13265902','13265907','13266195','13265730','13266013','13265763','13266286','13266227','13266180','13265649','13265520','13265894','13267181','13266292','13265693','13267193','13266260','13265680','13265911','13265840','13267244','13266825','13266092','13266915','13265488','13266124','13265898','13265569','13266883','13267227','13265610','13266221','13265687','13265774','13266433','13266142','13265826','13267204','13266000','13266961','13265960','13267206','13267090','13265891','13265668','13265932','13266122','13266163','13265760','13265611','13265524','13267205','13265847','13267038','13267191','13267212','13266967','13266823','13266030','13266100','13265969','13265844','13266007','13265540','13265665','13265511','13267108','13267246','13267060','13265694','13267144','13265627','13266098','13266204','13266169','13266403','13265519','13266287','13265739','13265666','13267179','13266074','13267209','13267195','13265510','13265972','13265676','13265605','13265600','13265525','13265800','13266032','13266275','13266363','13265940','13266457','13265741','13265809','13265573','13265929','13265986','13265522','13265951','13267197','13267132','13266885','13266326','13266315','13266261','13266269','13266419','13266359','13266332','13266290','13266248','13266222','13266139','13266127','13266118','13266050','13266040','13265994','13265903','13265635','13266459','13267214','13265646','13266821','13265664','13265692','13265673','13265677','13266757','13265550','13266026','13265606','13266031','13265516','13266805','13266443','13266250','13267086','13265544','13267161','13265499','13266110','13265788','13266171','13265653','13266441','13266104','13266239','13266158','13266342','13265543','13266424','13265758','13266089','13266058','13267059','13267146','13265834','13265480','13265479','13265476','13265478','13265477','13265474','13267125','13266996','13266390','13266017','13267006','13266891','13265481','13265472','13265590','13266285','13266048','13265924','13267232','13265581','13266276','13265942','13266083','13265564','13265589','13265822','13265491','13265723','13265823','13267250','13266475','13266159','13266215','13266358','13267097','13265661','13266862','13265728','13265784','13265828','13266025','13266069','13266121','13266173','13266161','13266077','13266057','13266023','13265998','13265934','13265688','13265722','13265623','13265976','13266191','13266296','13266338','13266266','13266348','13266295','13266397','13266291','13266241','13266262','13266233','13266350','13266451','13266249','13266258','13266303','13266396','13266462','13266398','13266351','13266382','13266469','13266341','13266357','13266427','13266444','13266499','13267187','13265641','13266164','13266037','13265754','13265813','13265475','13266892','13265639','13265744','13265494','13265583','13265643','13265839','13266450','13265775','13265921','13266306','13266366','13266388','13266356','13266301','13266379','13266420','13266294','13266192','13266202','13266119','13266041','13266036','13265496','13266072','13265767','13265785','13265782','13267033','13265799','13266283','13266439','13267233','13265618','13265713','13265720','13265737','13265697','13265742','13265638','13267032','13265856','13267020','13265565','13265579','13267238','13266344','13266178','13265596','13266253','13266264','13265990','13265548','13265926','13265698','13265954','13266188','13266445','13267253','13266167','13266240','13266120','13266109','13265695','13266005','13266131','13266084','13266316','13266091','13265802','13265919','13266165','13266299','13265575','13267240','13265521','13266157','13266175','13266305','13266822','13265591','13265651','13265721','13265490','13265912','13267003','13265970','13265685','13266963','13265859','13265534','13267071','13265559','13266129','13265557','13266197','13266064','13265707','13266207','13266150','13265897','13267133','13266252','13265959','13265595','13265852','13266224','13265793','13265570','13266841','13267111','13267009','13265489','13265796','13265577','13265821','13267207','13265686','13265755','13266015','13267136','13266080','13267030','13265827','13266278','13265633','13267243','13266046','13265726','13266103','13266029','13266035','13266101','13265729','13266346','13265561','13266874','13265473','13266917','13265556','13265586','13265599','13267083','13267089','13265930','13267156','13265483','13265824','13265514','13267062','13266317','13266268','13266413','13266361','13266334','13266284','13266236','13266226','13266115','13266027','13265991','13265761','13265640','13265485','13265567','13265562','13265632','13265619','13265679','13265662','13266845','13267056','13265568','13265571','13265588','13265825','13265865','13265804','13265849','13265584','13265770','13267115','13265786','13265949','13266385','13266367','13266238','13266183','13266140','13266138','13266168','13266006','13265968','13266274','13266223','13266132','13266152','13266078','13266130','13266133','13265939','13265645','13266434','13265602','13267160','13266298','13265560','13267139','13265899','13266244','13266126','13266160','13266047','13265953','13265636','13267005','13265631','13267088','13265900','13266265','13267162','13265869','13266003','13266965','13265493','13266876','13266075','13266179','13266018','13266259','13266230','13265833','13265901','13265672','13265628','13265608','13265772','13266203','13266136','13265762','13266181','13265701','13265574','13265555','13266034','13265872','13267256','13265881','13265864','13265594','13265941','13266028','13265888','13266312','13266335','13266455','13266310','13266225','13266194','13266144','13266314','13266234','13266365','13266209','13266177','13266022','13265616','13265914','13266243','13265783','13266155','13266282','13266166','13266113','13266044','13265905','13265832','13265896','13265798','13265868','13265733','13265749','13265766','13265487','13265484','13267263','13267258','13266349','13265817','13265768','13265669','13265625','13265943','13265486','13267112','13266900','13265549','13265797','13265745','13265732','13265542','13265517','13265527','13265502','13265529','13265769','13265509','13265506','13265962','13265923','13265867','13265703','13265660','13265961','13265866','13265547','13265913','13266019','13265750','13265757','13265735','13265671','13265878','13265838','13265931','13265908','13265882','13265860','13265964','13265922','13265920','13265751','13265644','13265663','13266045','13265503','13265759','13265711','13265727','13265777','13265715','13265498','13265836','13265492','13265857','13266012','13265886','13266049','13266024','13265974','13265944','13265883','13265875','13265958','13266010','13265983','13265984','13265916','13265863','13265740','13265801','13265756','13265731','13265652','13267114','13266114','13265675','13266976','13267170','13267140','13265871','13266051','13265526','13266998','13266928','13265927','13265654','13265518','13267113','13266410','13266095','13265870','13265925','13265773','13266085','13265566','13265892','13265659','13266280','13266208','13265997','13266172','13265850','13266871','13265829','13265674','13265987','13265572','13266108','13265973','13266054','13266937','13265819','13265497','13265936','13265948','13266141','13267063','13266447','13266220','13265678','13265996','13265747','13265790','13266008','13265656','13267116','13266939','13265917','13267213','13265842','13265592','13265854','13265928','13267225','13266198','13266256','13266059','13266151','13266846','13267194','13265890','13267234','13266850','13265830','13266099','13265501','13267218','13265624','13267057','13265889','13265598','13266930','13265952','13265650','13266936','13267188','13265887','13265500','13266033','13265620','13265965','13266857','13265776','13266212','13265523','13267186','13265980','13265546','13266189','13266370','13266960','13266055','13265709','13266321','13265803','13267118','13265811','13267221','13265947','13266426','13265771','13266393','13265992','13265637','13265989','13266038','13265879','13267159','13265558','13265626','13265963','13265702','13265816','13266128','13265554','13265704','13266061','13266170','13267251','13266200','13266206','13265553','13266431','13267052','13265563','13265845','13266399','13266143','13266156','13266067','13265630','13265779','13267231','13266229','13265746','13265806','13265999','13265530','13266461','13266009','13266412','13266011','13266300','13266993','13266153','13265629','13265795','13265738','13265979','13265884','13266039','13266073','13266185','13266145','13266216','13266146','13266190','13266214','13265945','13265604','13265585','13266308','0') and ((gmt_offset_now IN('13.00','12.75','12.50','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','10.00','9.75','9.50','9.25','9.00','8.75','8.50','8.25','8.00','7.75','7.50','7.25','7.00','6.75','6.50','6.25','6.00','5.75','5.50','5.25','5.00','4.75','4.50','4.25','4.00','3.75','3.50','3.25','3.00','2.75','2.50','2.25','2.00','1.75','1.50','1.25','1.00','0.75','0.50','0.25','0.00','-0.25','-0.50','-0.75','-1.00','-1.25','-1.50','-1.75','-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50','-3.75','-4.00','-4.25','-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00','-6.25','-6.50','-6.75','-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50','-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-10.25','-10.50','-10.75','-11.00','-11.25','-11.50','-11.75','-12.00','-12.25','-12.50','-12.75','99') ) ) order by lead_id asc limit 2000;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!