Array [d9ea9220d8af07cef10ed70a3cd0ac92] => Array [query] => SELECT valor FROM tbl_configuracion WHERE (clave='xml/dbschema.xml') [time] => 0.000321865 [iter] => 1 [rows] => 1 [2c49d107acff9e768a6e7c04b6c80164] => Array [query] => SELECT valor FROM tbl_configuracion WHERE (clave='xml/dbstatic.xml') [time] => 0.000285149 [iter] => 1 [rows] => 1 [e7eca1e14075ae71a5bc12019ae48582] => Array [query] => SELECT sess_data FROM tbl_sessions WHERE (sess_file='saltos/c514l7i20dindgctfbss4rajf2') [time] => 0.000495911 [iter] => 2 [rows] => 2 [b0846f46740934bee06dc78742a89ba3] => Array [query] => SELECT * FROM tbl_usuarios WHERE (activo='1' AND login='sanz' AND password='$P$B8CKidZbc/Odu77uHJr4eAuuss14m4/') [time] => 0.00027585 [iter] => 1 [rows] => 1 [22ea44d60cca32659b7355cf41f2067b] => Array [query] => SELECT id FROM tbl_sessions WHERE (sess_file='saltos/c514l7i20dindgctfbss4rajf2') [time] => 0.000447989 [iter] => 2 [rows] => 2 [7d12d8bc39f74777a038da76935096ae] => Array [query] => UPDATE tbl_sessions SET sess_time='1469686303' WHERE (sess_file='saltos/c514l7i20dindgctfbss4rajf2') [time] => 0.000407934 [iter] => 2 [rows] => 0 [8051b0e26c033b3607c3629e582dcae2] => Array [query] => SELECT id FROM tbl_sessions WHERE sess_file='saltos/c514l7i20dindgctfbss4rajf2' [time] => 0.000204086 [iter] => 1 [rows] => 1 [44a1ea330fbd0fe8fe973a991bad11cb] => Array [query] => SELECT id FROM tbl_security WHERE (id_session='9785') [time] => 0.000268936 [iter] => 1 [rows] => 1 [d146214d36fadaa589d8a84fbc4cf3cc] => Array [query] => SELECT id FROM tbl_security_ip WHERE id_session='9785' AND remote_addr='127.0.0.1' [time] => 0.00019908 [iter] => 1 [rows] => 1 [4bda72f9a5ef1a21582c6c574aef9772] => Array [query] => DELETE FROM tbl_security WHERE NOT id_session IN (SELECT id FROM tbl_sessions) [time] => 0.000241995 [iter] => 2 [rows] => 0 [192935c581a610da5c2efc2dd879e78d] => Array [query] => SELECT logout,id_usuario FROM tbl_security WHERE id='6333' [time] => 9.01222e-5 [iter] => 1 [rows] => 1 [cdc890cac9dee85694ff3741ffc777fe] => Array [query] => SELECT COUNT(*) FROM tbl_security WHERE id_usuario='38' AND logout='0' [time] => 0.000139952 [iter] => 1 [rows] => 1 [1777d44c16f1876990afa1017f43121d] => Array [query] => SELECT valor FROM tbl_cookies WHERE id_usuario='38' AND clave='lang' [time] => 0.000151157 [iter] => 1 [rows] => 1 [a138b3082c927c045c826b1a907422ba] => Array [query] => SELECT valor FROM tbl_configuracion WHERE (clave='accounting_iva_name') [time] => 0.000132084 [iter] => 1 [rows] => 1 [a792d58ae9608fbb24e6ba550c5f6171] => Array [query] => SELECT valor FROM tbl_configuracion WHERE (clave='application_title') [time] => 0.000143051 [iter] => 1 [rows] => 1 [22493023b5ee6d41ef6927d158b848a5] => Array [query] => SELECT * FROM tbl_usuarios WHERE (id='38') [time] => 0.000168085 [iter] => 1 [rows] => 1 [e26501f313ea28894683f22e9d46e983] => Array [query] => SELECT a.codigo aplicacion,p.codigo permiso,x.allow allow,x.deny deny FROM ( SELECT ai.id_aplicacion id_aplicacion,ai.id_permiso id_permiso,ai.allow allow,ai.deny deny FROM tbl_aplicaciones_i ai UNION SELECT gp.id_aplicacion id_aplicacion,gp.id_permiso id_permiso,gp.allow allow,gp.deny deny FROM tbl_grupos_p gp,tbl_usuarios u,tbl_aplicaciones_p ap WHERE u.id='38' AND u.id_grupo=gp.id_grupo AND gp.id_aplicacion=ap.id_aplicacion AND gp.id_permiso=ap.id_permiso UNION SELECT gp.id_aplicacion id_aplicacion,gp.id_permiso id_permiso,gp.allow allow,gp.deny deny FROM tbl_grupos_p gp,tbl_usuarios_g ug,tbl_aplicaciones_p ap WHERE ug.id_usuario='38' AND ug.id_grupo=gp.id_grupo AND gp.id_aplicacion=ap.id_aplicacion AND gp.id_permiso=ap.id_permiso UNION SELECT up.id_aplicacion id_aplicacion,up.id_permiso id_permiso,up.allow allow,up.deny deny FROM tbl_usuarios_p up,tbl_aplicaciones_p ap WHERE up.id_usuario='38' AND up.id_aplicacion=ap.id_aplicacion AND up.id_permiso=ap.id_permiso ) x LEFT JOIN tbl_aplicaciones a ON a.id=x.id_aplicacion LEFT JOIN tbl_permisos p ON p.id=x.id_permiso [time] => 0.00327802 [iter] => 1 [rows] => 455 [e1672f4d4a6a1d648e9495649be7f390] => Array [query] => SELECT valor FROM tbl_cookies WHERE id_usuario='38' AND clave='style' [time] => 0.00023818 [iter] => 1 [rows] => 1 [a4b4eb54a79336a500c27a473d09513b] => Array [query] => SELECT valor FROM tbl_cookies WHERE id_usuario='38' AND clave='iconset' [time] => 0.000228167 [iter] => 1 [rows] => 1 [7a0d14d75b3b0321b846d73e43dc0aa6] => Array [query] => SELECT page FROM tbl_lastpage WHERE id_usuario='38' [time] => 0.000131845 [iter] => 1 [rows] => 1 [cd3a398880c2fa781dbce07362eae8ab] => Array [query] => SELECT * FROM tbl_quick WHERE id_usuario='38' ORDER BY id DESC [time] => 0.000241995 [iter] => 1 [rows] => 12 [9de4e3f0abcaadf97ee5d622aae60946] => Array [query] => SELECT id,codigo,tabla,subtablas FROM tbl_aplicaciones [time] => 0.00029707 [iter] => 1 [rows] => 43 [0f61b8643ead565c7ea2e400c229d89a] => Array [query] => SELECT * FROM tbl_filters WHERE (id_usuario='38') ORDER BY nombre ASC [time] => 0.000252008 [iter] => 1 [rows] => 11 [bce0e30ea2c97ef4202d55425d1c8c92] => Array [query] => SELECT COUNT(*) FROM tbl_folders WHERE (id_usuario='38') [time] => 0.000185013 [iter] => 1 [rows] => 1 [057cf7d34d76b6005b4126eb5fa7aa00] => Array [query] => SELECT * FROM tbl_folders WHERE id_usuario='38' ORDER BY pos ASC [time] => 0.000218868 [iter] => 1 [rows] => 2 [1ad332c63d1bb3a2c451abecf937b281] => Array [query] => SELECT querystring FROM tbl_history WHERE id_usuario='38' AND id_aplicacion='27' [time] => 0.000267982 [iter] => 1 [rows] => 1 [298e6959149ac54b2c46f7c3b5211ffd] => Array [query] => SELECT valor FROM tbl_configuracion WHERE (clave='agenda_interval') [time] => 0.000317097 [iter] => 1 [rows] => 1 [2df9bde89d5130c302c97aa1a568bedc] => Array [query] => SELECT valor FROM tbl_configuracion WHERE (clave='inbox_interval') [time] => 0.000262976 [iter] => 1 [rows] => 1 [c2a15588b468a2ca177a278471f3d2e0] => Array [query] => SELECT valor FROM tbl_configuracion WHERE (clave='outbox_interval') [time] => 0.000236034 [iter] => 1 [rows] => 1 [d37b0f8a9b35114b6d320d097770159d] => Array [query] => SELECT valor FROM tbl_configuracion WHERE (clave='feeds_interval') [time] => 0.000170946 [iter] => 1 [rows] => 1 [1657fdf73518e9aa99a2dc63dc5ae847] => Array [query] => SELECT valor FROM tbl_configuracion WHERE (clave='session_interval') [time] => 0.000165939 [iter] => 1 [rows] => 1 [ce202db079647b02f3876408ab7fd4de] => Array [query] => SELECT valor FROM tbl_configuracion WHERE (clave='indexing_interval') [time] => 0.000165939 [iter] => 1 [rows] => 1 [ceca6e565592fc9d913913274c7bc391] => Array [query] => SELECT * FROM tbl_aplicaciones WHERE islink=1 [time] => 0.000195026 [iter] => 1 [rows] => 4 [96d0e0430dd9ef45b41773fb7bfefb29] => Array [query] => SELECT id_grupo FROM tbl_usuarios_g WHERE (id_usuario='38') [time] => 0.000133991 [iter] => 1 [rows] => 0 [e257b17a140e11cc36a83cdbfacfe2dd] => Array [query] => SELECT COUNT(*) FROM tbl_correo a LEFT JOIN tbl_registros_i e ON e.id_aplicacion='27' AND e.id_registro=a.id WHERE e.id_usuario='38' AND a.is_outbox='1' AND a.state_sent='0' [time] => 0.000269175 [iter] => 1 [rows] => 1 [c6504dc5320e7093cfb9332effe2922b] => Array [query] => SELECT valor FROM tbl_configuracion WHERE (clave='zero_padding_digits') [time] => 0.000184059 [iter] => 1 [rows] => 0 [ad0ff3fab0fd482bf5f7eddb91e18624] => Array [query] => /*MYSQL SHOW TABLE STATUS WHERE Name='tbl_indexing' */ [time] => 0.000807047 [iter] => 1 [rows] => 1 [d4d693caeedc70ac431a11a0e902090c] => Array [query] => SELECT id,id2, CONCAT('mailto:',de) de2, CASE WHEN para!='' THEN CONCAT('mailto:',para) ELSE (SELECT CASE WHEN email_name='' THEN CONCAT('mailto:',email_from) ELSE CONCAT('mailto:',email_name,' <',email_from,'>') END FROM tbl_usuarios_c WHERE id=id_cuenta) END para2, CONCAT('link:openapp(\'correo\',',-id,'):',subject) subject, datetime, size, CASE WHEN size>=1073741824 THEN CONCAT(ROUND(size/1073741824.0,2),' Gbytes') WHEN size>=1048576 THEN CONCAT(ROUND(size/1048576.0,2),' Mbytes') WHEN size>=1024 THEN CONCAT(ROUND(size/1024.0,2),' Kbytes') ELSE CONCAT(size,' bytes') END size2, files, estado, id action_id, CONCAT(id2,' - ',de,' - ',subject,' (',estado,')') action_title, action_style, CASE (1=1) WHEN 1 THEN 'true' ELSE 'false' END action_view, CASE (1=1) WHEN 1 THEN 'true' ELSE 'false' END action_pdf2, CASE (1=1) WHEN 1 THEN 'true' ELSE 'false' END action_view2, CASE (1 AND (1=1)) WHEN 1 THEN CASE is_outbox WHEN '0' THEN 'true' ELSE 'false' END ELSE 'false' END action_reply, CASE (1 AND (1=1)) WHEN 1 THEN CASE is_outbox WHEN '0' THEN CASE WHEN (SELECT COUNT(*) FROM tbl_correo_a WHERE id_correo=z.id AND id_tipo IN (2,3))>1 THEN 'true' ELSE 'false' END ELSE 'false' END ELSE 'false' END action_replyall, CASE (1 AND (1=1)) WHEN 1 THEN 'true' ELSE 'false' END action_forward, CASE (1=1) WHEN 1 THEN 'true' ELSE 'false' END action_wait, CASE (1=1) WHEN 1 THEN CASE is_outbox WHEN '0' THEN 'true' ELSE 'false' END ELSE 'false' END action_spam, CASE (1=1) WHEN 1 THEN 'true' ELSE 'false' END action_delete FROM ( SELECT a.id id,LPAD(a.id,6,0) id2, de,para,cc,bcc, a.datetime datetime,a.size size, files,body, e.id_usuario id_usuario,d.id_grupo id_grupo,a.id_cuenta id_cuenta, state_new,state_wait,state_spam,is_outbox, CASE WHEN subject='' THEN '(sense assumpte)' ELSE subject END subject, CONCAT(id_cuenta,'/',uidl) msgid, TRIM(CONCAT( CASE state_sent WHEN 1 THEN 'Enviat ' ELSE '' END, CASE state_error WHEN '' THEN '' ELSE 'Error ' END, CASE WHEN is_outbox=1 AND state_sent=0 AND state_error='' THEN ' No-enviat' ELSE '' END, CASE state_new WHEN 1 THEN 'Nou ' ELSE '' END, CASE state_reply WHEN 1 THEN 'Respost ' ELSE '' END, CASE state_forward WHEN 1 THEN 'Reenviat ' ELSE '' END, CASE state_wait WHEN 1 THEN 'Pendent ' ELSE '' END, CASE state_spam WHEN 1 THEN 'SPAM ' ELSE '' END, CASE priority WHEN -1 THEN 'Baixa ' WHEN 1 THEN 'Alta ' ELSE '' END, CASE sensitivity WHEN 1 THEN 'Personal ' WHEN 2 THEN 'Privat ' WHEN 3 THEN 'Confidencial ' ELSE '' END, CASE is_outbox+state_new+state_reply+state_forward+state_wait+state_spam+priority*10+sensitivity WHEN 0 THEN 'Llegit ' ELSE '' END )) estado, CASE WHEN state_error!='' THEN 'state_error' WHEN state_spam=1 THEN 'state_spam' WHEN state_new=1 THEN 'state_new' WHEN state_wait=1 THEN 'state_wait' ELSE '' END action_style FROM tbl_correo a LEFT JOIN tbl_registros_i e ON e.id_aplicacion='27' AND e.id_registro=a.id LEFT JOIN tbl_usuarios d ON e.id_usuario=d.id WHERE a.id IN (SELECT id_registro FROM tbl_indexing WHERE id_aplicacion='27' AND 1=1) ) z WHERE 1=1 AND id_usuario='38' AND (1=1) AND 1=1 AND (1=1) AND (1=1) AND (1=1) AND (1=1) AND (1=1) AND id_cuenta NOT IN (SELECT id FROM tbl_usuarios_c WHERE email_privated='1' AND id_usuario!='38') AND (1=1) AND (1=1) AND 1=1 AND (1=1) ORDER BY id desc LIMIT 0,50 [time] => 0.084738 [iter] => 1 [rows] => 50 [d9576fbb6b0d40b8a4857a9ca509f925] => Array [query] => SELECT id value,SUBSTR(CONCAT(CASE id_aplicacion WHEN '1' THEN (SELECT nombre FROM tbl_clientes WHERE id=id_registro) WHEN '4' THEN (SELECT nombre FROM tbl_proyectos WHERE id=id_registro) WHEN '21' THEN (SELECT nombre FROM tbl_proveedores WHERE id=id_registro) WHEN '31' THEN (SELECT nombre FROM tbl_empleados WHERE id=id_registro) END,' (',login,')'),1,255) label,'0' pos FROM ( SELECT a2.id id,a2.id_aplicacion id_aplicacion,a2.id_registro id_registro,a2.login login,e.id_usuario id_usuario,d.id_grupo id_grupo FROM tbl_usuarios a2 LEFT JOIN tbl_registros_i e ON e.id_aplicacion='11' AND e.id_registro=a2.id LEFT JOIN tbl_usuarios d ON e.id_usuario=d.id ) a WHERE id IN (SELECT id FROM tbl_usuarios WHERE activo=1) AND (1=1) UNION SELECT '' value,'[Tots els usuaris]' label,'-1' pos ORDER BY pos ASC,label ASC,value ASC [time] => 0.000705004 [iter] => 1 [rows] => 2 [0a1474a9ff0100b79b367960f808d95e] => Array [query] => SELECT '' value,'[Tots els comptes]' label [time] => 0.000185013 [iter] => 1 [rows] => 1 [c7531958dfc3ad26f26cea2bea03da91] => Array [query] => SELECT '1' pos,'' value,'Seleccioneu un filtre guardat' label UNION SELECT '2' pos,id value,nombre label FROM tbl_filters WHERE id_usuario='38' AND id_aplicacion='27' ORDER BY pos ASC,label ASC [time] => 0.000339985 [iter] => 1 [rows] => 12