Array [d9ea9220d8af07cef10ed70a3cd0ac92] => Array [query] => SELECT valor FROM tbl_configuracion WHERE (clave='xml/dbschema.xml') [time] => 0.000259876 [iter] => 1 [rows] => 1 [2c49d107acff9e768a6e7c04b6c80164] => Array [query] => SELECT valor FROM tbl_configuracion WHERE (clave='xml/dbstatic.xml') [time] => 0.000225067 [iter] => 1 [rows] => 1 [d008ade7a1b7cd21a19cf1bac3b08623] => Array [query] => SELECT sess_data FROM tbl_sessions WHERE (sess_file='saltos/cg165u4ng4v7q2vhvtm7s6l6r4') [time] => 0.000508308 [iter] => 2 [rows] => 2 [b0846f46740934bee06dc78742a89ba3] => Array [query] => SELECT * FROM tbl_usuarios WHERE (activo='1' AND login='sanz' AND password='$P$B8CKidZbc/Odu77uHJr4eAuuss14m4/') [time] => 0.000193834 [iter] => 1 [rows] => 1 [074d555cb70dfad56c597271e35cc43e] => Array [query] => SELECT id FROM tbl_sessions WHERE (sess_file='saltos/cg165u4ng4v7q2vhvtm7s6l6r4') [time] => 0.000402927 [iter] => 2 [rows] => 2 [cb3ef051cf5ce0425fe0d9aaa837ebaa] => Array [query] => UPDATE tbl_sessions SET sess_time='1469612307' WHERE (sess_file='saltos/cg165u4ng4v7q2vhvtm7s6l6r4') [time] => 0.000574112 [iter] => 1 [rows] => 0 [c9e224924894ec9b15b29c79922da828] => Array [query] => SELECT id FROM tbl_sessions WHERE sess_file='saltos/cg165u4ng4v7q2vhvtm7s6l6r4' [time] => 0.000128031 [iter] => 1 [rows] => 1 [e076222f2c47a4317da9467aff953c45] => Array [query] => SELECT id FROM tbl_security WHERE (id_session='9779') [time] => 0.000138998 [iter] => 1 [rows] => 1 [7969fae5f9644491da8e650c83d7127e] => Array [query] => SELECT id FROM tbl_security_ip WHERE id_session='9779' AND remote_addr='127.0.0.1' [time] => 0.000146866 [iter] => 1 [rows] => 1 [4bda72f9a5ef1a21582c6c574aef9772] => Array [query] => DELETE FROM tbl_security WHERE NOT id_session IN (SELECT id FROM tbl_sessions) [time] => 0.000272751 [iter] => 2 [rows] => 0 [3e4d4efcd097d7483079218d64690a84] => Array [query] => SELECT logout,id_usuario FROM tbl_security WHERE id='6327' [time] => 0.000104189 [iter] => 1 [rows] => 1 [cdc890cac9dee85694ff3741ffc777fe] => Array [query] => SELECT COUNT(*) FROM tbl_security WHERE id_usuario='38' AND logout='0' [time] => 0.000129938 [iter] => 1 [rows] => 1 [1777d44c16f1876990afa1017f43121d] => Array [query] => SELECT valor FROM tbl_cookies WHERE id_usuario='38' AND clave='lang' [time] => 0.000138044 [iter] => 1 [rows] => 1 [a138b3082c927c045c826b1a907422ba] => Array [query] => SELECT valor FROM tbl_configuracion WHERE (clave='accounting_iva_name') [time] => 0.000138044 [iter] => 1 [rows] => 1 [a792d58ae9608fbb24e6ba550c5f6171] => Array [query] => SELECT valor FROM tbl_configuracion WHERE (clave='application_title') [time] => 0.000144958 [iter] => 1 [rows] => 1 [22493023b5ee6d41ef6927d158b848a5] => Array [query] => SELECT * FROM tbl_usuarios WHERE (id='38') [time] => 0.000141144 [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.00340509 [iter] => 1 [rows] => 455 [e1672f4d4a6a1d648e9495649be7f390] => Array [query] => SELECT valor FROM tbl_cookies WHERE id_usuario='38' AND clave='style' [time] => 0.000254154 [iter] => 1 [rows] => 1 [a4b4eb54a79336a500c27a473d09513b] => Array [query] => SELECT valor FROM tbl_cookies WHERE id_usuario='38' AND clave='iconset' [time] => 0.000154018 [iter] => 1 [rows] => 1 [7a0d14d75b3b0321b846d73e43dc0aa6] => Array [query] => SELECT page FROM tbl_lastpage WHERE id_usuario='38' [time] => 0.000116825 [iter] => 1 [rows] => 1 [cd3a398880c2fa781dbce07362eae8ab] => Array [query] => SELECT * FROM tbl_quick WHERE id_usuario='38' ORDER BY id DESC [time] => 0.000240088 [iter] => 1 [rows] => 12 [9de4e3f0abcaadf97ee5d622aae60946] => Array [query] => SELECT id,codigo,tabla,subtablas FROM tbl_aplicaciones [time] => 0.00018692 [iter] => 1 [rows] => 43 [0f61b8643ead565c7ea2e400c229d89a] => Array [query] => SELECT * FROM tbl_filters WHERE (id_usuario='38') ORDER BY nombre ASC [time] => 0.000200033 [iter] => 1 [rows] => 11 [bce0e30ea2c97ef4202d55425d1c8c92] => Array [query] => SELECT COUNT(*) FROM tbl_folders WHERE (id_usuario='38') [time] => 0.00014019 [iter] => 1 [rows] => 1 [057cf7d34d76b6005b4126eb5fa7aa00] => Array [query] => SELECT * FROM tbl_folders WHERE id_usuario='38' ORDER BY pos ASC [time] => 0.000168085 [iter] => 1 [rows] => 2 [1ad332c63d1bb3a2c451abecf937b281] => Array [query] => SELECT querystring FROM tbl_history WHERE id_usuario='38' AND id_aplicacion='27' [time] => 0.000306845 [iter] => 1 [rows] => 1 [298e6959149ac54b2c46f7c3b5211ffd] => Array [query] => SELECT valor FROM tbl_configuracion WHERE (clave='agenda_interval') [time] => 0.000270128 [iter] => 1 [rows] => 1 [2df9bde89d5130c302c97aa1a568bedc] => Array [query] => SELECT valor FROM tbl_configuracion WHERE (clave='inbox_interval') [time] => 0.000140905 [iter] => 1 [rows] => 1 [c2a15588b468a2ca177a278471f3d2e0] => Array [query] => SELECT valor FROM tbl_configuracion WHERE (clave='outbox_interval') [time] => 0.000123978 [iter] => 1 [rows] => 1 [d37b0f8a9b35114b6d320d097770159d] => Array [query] => SELECT valor FROM tbl_configuracion WHERE (clave='feeds_interval') [time] => 0.000118971 [iter] => 1 [rows] => 1 [1657fdf73518e9aa99a2dc63dc5ae847] => Array [query] => SELECT valor FROM tbl_configuracion WHERE (clave='session_interval') [time] => 0.000121117 [iter] => 1 [rows] => 1 [ce202db079647b02f3876408ab7fd4de] => Array [query] => SELECT valor FROM tbl_configuracion WHERE (clave='indexing_interval') [time] => 0.000158072 [iter] => 1 [rows] => 1 [ceca6e565592fc9d913913274c7bc391] => Array [query] => SELECT * FROM tbl_aplicaciones WHERE islink=1 [time] => 0.000168085 [iter] => 1 [rows] => 4 [96d0e0430dd9ef45b41773fb7bfefb29] => Array [query] => SELECT id_grupo FROM tbl_usuarios_g WHERE (id_usuario='38') [time] => 0.000121832 [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.000258923 [iter] => 1 [rows] => 1 [c6504dc5320e7093cfb9332effe2922b] => Array [query] => SELECT valor FROM tbl_configuracion WHERE (clave='zero_padding_digits') [time] => 0.000141859 [iter] => 1 [rows] => 0 [ad0ff3fab0fd482bf5f7eddb91e18624] => Array [query] => /*MYSQL SHOW TABLE STATUS WHERE Name='tbl_indexing' */ [time] => 0.000754833 [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] => 3.52296 [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.000889063 [iter] => 1 [rows] => 2 [0a1474a9ff0100b79b367960f808d95e] => Array [query] => SELECT '' value,'[Tots els comptes]' label [time] => 0.000216007 [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.000355005 [iter] => 1 [rows] => 12