1.91 ms
(1.34%)
|
1 |
update suppression set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update suppression set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
1.76 ms
(1.24%)
|
1 |
update suppression set datemajutcgestion = datemajutc where datemajutcgestion is null
update suppression set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
1.53 ms
(1.08%)
|
1 |
SELECT * FROM suppression WHERE suppression.datemajutc > '2025-11-06 14:10:02' and ( suppression.datemajutc > '2025-11-06 14:10:02' ) and (generateur_id = 102 OR generateur_id IS NULL)
SELECT * FROM suppression WHERE suppression.datemajutc > '2025-11-06 14:10:02' and ( suppression.datemajutc > '2025-11-06 14:10:02' ) and (generateur_id = 102 OR generateur_id IS NULL);
|
1.42 ms
(1.00%)
|
1 |
update traduction set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update traduction set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
1.22 ms
(0.86%)
|
1 |
update traduction set datemajutcgestion = datemajutc where datemajutcgestion is null
update traduction set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
1.19 ms
(0.84%)
|
2 |
SHOW COLUMNS FROM etatsynchrotable
SHOW COLUMNS FROM etatsynchrotable;
|
1.10 ms
(0.78%)
|
1 |
select idsupprime,id from suppression where entity = 'contrat' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'contrat' and executegestion=0 and idsupprime is not null order by id;
|
0.99 ms
(0.70%)
|
2 |
SHOW COLUMNS FROM commandegene
SHOW COLUMNS FROM commandegene;
|
0.97 ms
(0.68%)
|
1 |
update etatsynchrotable set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update etatsynchrotable set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
0.96 ms
(0.68%)
|
2 |
SHOW COLUMNS FROM objetnotification
SHOW COLUMNS FROM objetnotification;
|
0.96 ms
(0.68%)
|
2 |
SHOW COLUMNS FROM role
SHOW COLUMNS FROM role;
|
0.95 ms
(0.67%)
|
2 |
SHOW COLUMNS FROM langue
SHOW COLUMNS FROM langue;
|
0.95 ms
(0.67%)
|
2 |
SHOW COLUMNS FROM generateur
SHOW COLUMNS FROM generateur;
|
0.95 ms
(0.67%)
|
2 |
SHOW COLUMNS FROM typemodulecomgenerateur
SHOW COLUMNS FROM typemodulecomgenerateur;
|
0.95 ms
(0.67%)
|
2 |
SHOW COLUMNS FROM variablegenerateur
SHOW COLUMNS FROM variablegenerateur;
|
0.94 ms
(0.67%)
|
2 |
SHOW COLUMNS FROM commandegeneaffecte
SHOW COLUMNS FROM commandegeneaffecte;
|
0.94 ms
(0.66%)
|
1 |
UPDATE generateur SET datederniereinfoip = utc_timestamp(), datederniereinfo = utc_timestamp() WHERE id = 102
UPDATE generateur SET datederniereinfoip = utc_timestamp(), datederniereinfo = utc_timestamp() WHERE id = 102;
|
0.94 ms
(0.66%)
|
2 |
SHOW COLUMNS FROM client
SHOW COLUMNS FROM client;
|
0.93 ms
(0.66%)
|
2 |
SHOW COLUMNS FROM document
SHOW COLUMNS FROM document;
|
0.93 ms
(0.66%)
|
2 |
SHOW COLUMNS FROM libfr
SHOW COLUMNS FROM libfr;
|
0.91 ms
(0.64%)
|
2 |
SHOW COLUMNS FROM version
SHOW COLUMNS FROM version;
|
0.91 ms
(0.64%)
|
2 |
SHOW COLUMNS FROM modelegenerateur
SHOW COLUMNS FROM modelegenerateur;
|
0.90 ms
(0.63%)
|
2 |
SHOW COLUMNS FROM theme
SHOW COLUMNS FROM theme;
|
0.90 ms
(0.63%)
|
2 |
SHOW COLUMNS FROM user
SHOW COLUMNS FROM user;
|
0.90 ms
(0.63%)
|
1 |
update visuel set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update visuel set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
0.89 ms
(0.63%)
|
2 |
SHOW COLUMNS FROM rapport
SHOW COLUMNS FROM rapport;
|
0.89 ms
(0.63%)
|
2 |
SHOW COLUMNS FROM suppression
SHOW COLUMNS FROM suppression;
|
0.89 ms
(0.63%)
|
1 |
select idsupprime,id from suppression where entity = 'typenotification' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'typenotification' and executegestion=0 and idsupprime is not null order by id;
|
0.89 ms
(0.63%)
|
2 |
SHOW COLUMNS FROM visuel
SHOW COLUMNS FROM visuel;
|
0.88 ms
(0.62%)
|
2 |
SHOW COLUMNS FROM statutnotification
SHOW COLUMNS FROM statutnotification;
|
0.88 ms
(0.62%)
|
1 |
select idsupprime,id from suppression where entity = 'commandegene' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'commandegene' and executegestion=0 and idsupprime is not null order by id;
|
0.87 ms
(0.61%)
|
1 |
select idsupprime,id from suppression where entity = 'typemaintenancerole' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'typemaintenancerole' and executegestion=0 and idsupprime is not null order by id;
|
0.87 ms
(0.61%)
|
2 |
SHOW COLUMNS FROM traduction
SHOW COLUMNS FROM traduction;
|
0.86 ms
(0.61%)
|
1 |
select idsupprime,id from suppression where entity = 'typemaintenance' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'typemaintenance' and executegestion=0 and idsupprime is not null order by id;
|
0.86 ms
(0.61%)
|
2 |
SHOW COLUMNS FROM droits
SHOW COLUMNS FROM droits;
|
0.86 ms
(0.61%)
|
1 |
SELECT traduction.* FROM traduction WHERE traduction.datemajutc > '2025-08-12 08:33:45' and (traduction.datemajutc > '2025-08-12 08:33:45')
SELECT traduction.* FROM traduction WHERE traduction.datemajutc > '2025-08-12 08:33:45' and (traduction.datemajutc > '2025-08-12 08:33:45') ;
|
0.86 ms
(0.61%)
|
1 |
select idsupprime,id from suppression where entity = 'rapport' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'rapport' and executegestion=0 and idsupprime is not null order by id;
|
0.86 ms
(0.60%)
|
2 |
SHOW COLUMNS FROM valeurvariableencours
SHOW COLUMNS FROM valeurvariableencours;
|
0.86 ms
(0.60%)
|
2 |
SHOW COLUMNS FROM typemaintenance
SHOW COLUMNS FROM typemaintenance;
|
0.85 ms
(0.60%)
|
1 |
select idsupprime,id from suppression where entity = 'etatsynchrotable' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'etatsynchrotable' and executegestion=0 and idsupprime is not null order by id;
|
0.85 ms
(0.60%)
|
1 |
select idsupprime,id from suppression where entity = 'incident' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'incident' and executegestion=0 and idsupprime is not null order by id;
|
0.85 ms
(0.60%)
|
1 |
select idsupprime,id from suppression where entity = 'typecommandegene' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'typecommandegene' and executegestion=0 and idsupprime is not null order by id;
|
0.85 ms
(0.60%)
|
2 |
SHOW COLUMNS FROM typeenvoisms
SHOW COLUMNS FROM typeenvoisms;
|
0.85 ms
(0.60%)
|
2 |
SHOW COLUMNS FROM modenotificationgenerateur
SHOW COLUMNS FROM modenotificationgenerateur;
|
0.85 ms
(0.60%)
|
2 |
SHOW COLUMNS FROM statut
SHOW COLUMNS FROM statut;
|
0.84 ms
(0.59%)
|
1 |
select idsupprime,id from suppression where entity = 'document' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'document' and executegestion=0 and idsupprime is not null order by id;
|
0.84 ms
(0.59%)
|
1 |
select idsupprime,id from suppression where entity = 'valeurvariableencours' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'valeurvariableencours' and executegestion=0 and idsupprime is not null order by id;
|
0.84 ms
(0.59%)
|
2 |
SHOW COLUMNS FROM typelogaction
SHOW COLUMNS FROM typelogaction;
|
0.84 ms
(0.59%)
|
1 |
select idsupprime,id from suppression where entity = 'suppression' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'suppression' and executegestion=0 and idsupprime is not null order by id;
|
0.83 ms
(0.59%)
|
1 |
select idsupprime,id from suppression where entity = 'borne' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'borne' and executegestion=0 and idsupprime is not null order by id;
|
0.83 ms
(0.59%)
|
2 |
SHOW COLUMNS FROM typenotification
SHOW COLUMNS FROM typenotification;
|
0.83 ms
(0.59%)
|
2 |
SHOW COLUMNS FROM notification
SHOW COLUMNS FROM notification;
|
0.83 ms
(0.59%)
|
1 |
select idsupprime,id from suppression where entity = 'droits' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'droits' and executegestion=0 and idsupprime is not null order by id;
|
0.83 ms
(0.59%)
|
1 |
select idsupprime,id from suppression where entity = 'generateur' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'generateur' and executegestion=0 and idsupprime is not null order by id;
|
0.83 ms
(0.59%)
|
1 |
select idsupprime,id from suppression where entity = 'version' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'version' and executegestion=0 and idsupprime is not null order by id;
|
0.83 ms
(0.58%)
|
2 |
SHOW COLUMNS FROM maintenance
SHOW COLUMNS FROM maintenance;
|
0.83 ms
(0.58%)
|
2 |
SHOW COLUMNS FROM incident
SHOW COLUMNS FROM incident;
|
0.83 ms
(0.58%)
|
1 |
select idsupprime,id from suppression where entity = 'langue' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'langue' and executegestion=0 and idsupprime is not null order by id;
|
0.83 ms
(0.58%)
|
1 |
select idsupprime,id from suppression where entity = 'typedocument' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'typedocument' and executegestion=0 and idsupprime is not null order by id;
|
0.83 ms
(0.58%)
|
1 |
select idsupprime,id from suppression where entity = 'variablegenerateur' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'variablegenerateur' and executegestion=0 and idsupprime is not null order by id;
|
0.83 ms
(0.58%)
|
2 |
SHOW COLUMNS FROM typecommandegene
SHOW COLUMNS FROM typecommandegene;
|
0.83 ms
(0.58%)
|
1 |
select idsupprime,id from suppression where entity = 'rolecommandegene' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'rolecommandegene' and executegestion=0 and idsupprime is not null order by id;
|
0.83 ms
(0.58%)
|
2 |
SHOW COLUMNS FROM variable
SHOW COLUMNS FROM variable;
|
0.83 ms
(0.58%)
|
1 |
select idsupprime,id from suppression where entity = 'modenotificationgenerateur' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'modenotificationgenerateur' and executegestion=0 and idsupprime is not null order by id;
|
0.83 ms
(0.58%)
|
1 |
select idsupprime,id from suppression where entity = 'statutnotification' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'statutnotification' and executegestion=0 and idsupprime is not null order by id;
|
0.83 ms
(0.58%)
|
2 |
SHOW COLUMNS FROM groupe
SHOW COLUMNS FROM groupe;
|
0.83 ms
(0.58%)
|
1 |
select idsupprime,id from suppression where entity = 'statut' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'statut' and executegestion=0 and idsupprime is not null order by id;
|
0.82 ms
(0.58%)
|
2 |
SHOW COLUMNS FROM borne
SHOW COLUMNS FROM borne;
|
0.82 ms
(0.58%)
|
1 |
select idsupprime,id from suppression where entity = 'objetnotification' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'objetnotification' and executegestion=0 and idsupprime is not null order by id;
|
0.82 ms
(0.58%)
|
1 |
update notification set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update notification set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
0.82 ms
(0.58%)
|
1 |
select idsupprime,id from suppression where entity = 'user' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'user' and executegestion=0 and idsupprime is not null order by id;
|
0.82 ms
(0.58%)
|
2 |
SHOW COLUMNS FROM membre
SHOW COLUMNS FROM membre;
|
0.82 ms
(0.58%)
|
1 |
select idsupprime,id from suppression where entity = 'rapportgenerateur' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'rapportgenerateur' and executegestion=0 and idsupprime is not null order by id;
|
0.82 ms
(0.58%)
|
1 |
select idsupprime,id from suppression where entity = 'commandegeneaffecte' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'commandegeneaffecte' and executegestion=0 and idsupprime is not null order by id;
|
0.82 ms
(0.58%)
|
2 |
SHOW COLUMNS FROM documentmodelegenerateur
SHOW COLUMNS FROM documentmodelegenerateur;
|
0.82 ms
(0.58%)
|
1 |
select idsupprime,id from suppression where entity = 'typemodulecomgenerateur' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'typemodulecomgenerateur' and executegestion=0 and idsupprime is not null order by id;
|
0.82 ms
(0.58%)
|
2 |
SHOW COLUMNS FROM typedocument
SHOW COLUMNS FROM typedocument;
|
0.82 ms
(0.57%)
|
2 |
SHOW COLUMNS FROM typealarme
SHOW COLUMNS FROM typealarme;
|
0.82 ms
(0.57%)
|
2 |
SHOW COLUMNS FROM rolecommandegene
SHOW COLUMNS FROM rolecommandegene;
|
0.81 ms
(0.57%)
|
1 |
select idsupprime,id from suppression where entity = 'theme' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'theme' and executegestion=0 and idsupprime is not null order by id;
|
0.81 ms
(0.57%)
|
2 |
SHOW COLUMNS FROM contrat
SHOW COLUMNS FROM contrat;
|
0.81 ms
(0.57%)
|
2 |
SHOW COLUMNS FROM typemaintenancerole
SHOW COLUMNS FROM typemaintenancerole;
|
0.81 ms
(0.57%)
|
1 |
select idsupprime,id from suppression where entity = 'traduction' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'traduction' and executegestion=0 and idsupprime is not null order by id;
|
0.81 ms
(0.57%)
|
1 |
select idsupprime,id from suppression where entity = 'typelogaction' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'typelogaction' and executegestion=0 and idsupprime is not null order by id;
|
0.81 ms
(0.57%)
|
2 |
SHOW COLUMNS FROM commandesend2gene
SHOW COLUMNS FROM commandesend2gene;
|
0.81 ms
(0.57%)
|
1 |
select idsupprime,id from suppression where entity = 'variable' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'variable' and executegestion=0 and idsupprime is not null order by id;
|
0.81 ms
(0.57%)
|
1 |
select idsupprime,id from suppression where entity = 'statutcommandegene' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'statutcommandegene' and executegestion=0 and idsupprime is not null order by id;
|
0.81 ms
(0.57%)
|
1 |
select idsupprime,id from suppression where entity = 'membre' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'membre' and executegestion=0 and idsupprime is not null order by id;
|
0.81 ms
(0.57%)
|
1 |
select idsupprime,id from suppression where entity = 'typealarme' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'typealarme' and executegestion=0 and idsupprime is not null order by id;
|
0.81 ms
(0.57%)
|
1 |
select idsupprime,id from suppression where entity = 'notification' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'notification' and executegestion=0 and idsupprime is not null order by id;
|
0.81 ms
(0.57%)
|
1 |
select idsupprime,id from suppression where entity = 'commandesend2gene' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'commandesend2gene' and executegestion=0 and idsupprime is not null order by id;
|
0.81 ms
(0.57%)
|
1 |
select idsupprime,id from suppression where entity = 'documentmodelegenerateur' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'documentmodelegenerateur' and executegestion=0 and idsupprime is not null order by id;
|
0.81 ms
(0.57%)
|
1 |
select idsupprime,id from suppression where entity = 'groupe' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'groupe' and executegestion=0 and idsupprime is not null order by id;
|
0.81 ms
(0.57%)
|
1 |
select idsupprime,id from suppression where entity = 'modelegenerateur' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'modelegenerateur' and executegestion=0 and idsupprime is not null order by id;
|
0.81 ms
(0.57%)
|
1 |
select idsupprime,id from suppression where entity = 'visuel' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'visuel' and executegestion=0 and idsupprime is not null order by id;
|
0.81 ms
(0.57%)
|
1 |
select idsupprime,id from suppression where entity = 'libfr' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'libfr' and executegestion=0 and idsupprime is not null order by id;
|
0.80 ms
(0.57%)
|
1 |
select idsupprime,id from suppression where entity = 'role' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'role' and executegestion=0 and idsupprime is not null order by id;
|
0.80 ms
(0.56%)
|
1 |
select idsupprime,id from suppression where entity = 'typeenvoisms' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'typeenvoisms' and executegestion=0 and idsupprime is not null order by id;
|
0.80 ms
(0.56%)
|
1 |
select idsupprime,id from suppression where entity = 'maintenance' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'maintenance' and executegestion=0 and idsupprime is not null order by id;
|
0.79 ms
(0.56%)
|
2 |
SHOW COLUMNS FROM statutcommandegene
SHOW COLUMNS FROM statutcommandegene;
|
0.79 ms
(0.56%)
|
1 |
select idsupprime,id from suppression where entity = 'client' and executegestion=0 and idsupprime is not null order by id
select idsupprime,id from suppression where entity = 'client' and executegestion=0 and idsupprime is not null order by id;
|
0.77 ms
(0.54%)
|
2 |
SHOW COLUMNS FROM rapportgenerateur
SHOW COLUMNS FROM rapportgenerateur;
|
0.77 ms
(0.54%)
|
1 |
update libfr set datemajutcgestion = datemajutc where datemajutcgestion is null
update libfr set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
0.75 ms
(0.53%)
|
1 |
SELECT client.* FROM client LEFT OUTER JOIN generateur ON generateur.client_id = client.id LEFT JOIN user ON user.client_id = client.id WHERE client.datemajutc > '2025-12-17 10:45:50' and ( client.datemajutc > '2025-12-17 10:45:50' ) and (generateur.id = 102 OR user.supadmin = 1 or user.id = 102) group by client.id
SELECT client.* FROM client LEFT OUTER JOIN generateur ON generateur.client_id = client.id LEFT JOIN user ON user.client_id = client.id WHERE client.datemajutc > '2025-12-17 10:45:50' and ( client.datemajutc > '2025-12-17 10:45:50' ) and (generateur.id = 102 OR user.supadmin = 1 or user.id = 102) group by client.id;
|
0.73 ms
(0.51%)
|
1 |
update generateur set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update generateur set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
0.73 ms
(0.51%)
|
1 |
update client set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update client set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
0.73 ms
(0.51%)
|
1 |
update libfr set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update libfr set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
0.72 ms
(0.51%)
|
1 |
update user set datemajutcgestion = datemajutc where datemajutcgestion is null
update user set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
0.69 ms
(0.49%)
|
1 |
update notification set datemajutcgestion = datemajutc where datemajutcgestion is null
update notification set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
0.67 ms
(0.47%)
|
1 |
update modelegenerateur set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update modelegenerateur set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
0.65 ms
(0.46%)
|
1 |
update version set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update version set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
0.64 ms
(0.45%)
|
1 |
update statutnotification set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update statutnotification set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
0.64 ms
(0.45%)
|
1 |
update commandesend2gene set datemajutcgestion = datemajutc where datemajutcgestion is null
update commandesend2gene set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
0.63 ms
(0.44%)
|
1 |
SELECT t0.id AS id_1, t0.numserie AS numserie_2, t0.type AS type_3, t0.numwhatsapp AS numwhatsapp_4, t0.pays AS pays_5, t0.site AS site_6, t0.numsim AS numsim_7, t0.datederniereinfo AS datederniereinfo_8, t0.datemiseenservice AS datemiseenservice_9, t0.alive AS alive_10, t0.o2h2 AS o2h2_11, t0.h2r AS h2r_12, t0.comp AS comp_13, t0.nivelec AS nivelec_14, t0.power AS power_15, t0.ximg AS ximg_16, t0.yimg AS yimg_17, t0.datesendalive AS datesendalive_18, t0.nivdiw AS nivdiw_19, t0.codeassociation AS codeassociation_20, t0.versiongensrelay AS versiongensrelay_21, t0.typemodule AS typemodule_22, t0.datederniereinfoip AS datederniereinfoip_23, t0.datederniereinfosms AS datederniereinfosms_24, t0.clepublique AS clepublique_25, t0.aliveip AS aliveip_26, t0.alivesms AS alivesms_27, t0.datesendaliveip AS datesendaliveip_28, t0.datesendalivesms AS datesendalivesms_29, t0.visuel AS visuel_30, t0.tempvisuel AS tempvisuel_31, t0.dateconf AS dateconf_32, t0.usermaj AS usermaj_33, t0.datemajutc AS datemajutc_34, t0.supprime AS supprime_35, t0.connexiongestion AS connexiongestion_36, t0.idgestion AS idgestion_37, t0.idmaitre AS idmaitre_38, t0.idrelay AS idrelay_39, t0.modelegenerateur_id AS modelegenerateur_id_40, t0.typemodulecomgenerateur_id AS typemodulecomgenerateur_id_41, t0.client_id AS client_id_42 FROM generateur t0 WHERE t0.id = ?
SELECT
t0.id AS id_1,
t0.numserie AS numserie_2,
t0.type AS type_3,
t0.numwhatsapp AS numwhatsapp_4,
t0.pays AS pays_5,
t0.site AS site_6,
t0.numsim AS numsim_7,
t0.datederniereinfo AS datederniereinfo_8,
t0.datemiseenservice AS datemiseenservice_9,
t0.alive AS alive_10,
t0.o2h2 AS o2h2_11,
t0.h2r AS h2r_12,
t0.comp AS comp_13,
t0.nivelec AS nivelec_14,
t0.power AS power_15,
t0.ximg AS ximg_16,
t0.yimg AS yimg_17,
t0.datesendalive AS datesendalive_18,
t0.nivdiw AS nivdiw_19,
t0.codeassociation AS codeassociation_20,
t0.versiongensrelay AS versiongensrelay_21,
t0.typemodule AS typemodule_22,
t0.datederniereinfoip AS datederniereinfoip_23,
t0.datederniereinfosms AS datederniereinfosms_24,
t0.clepublique AS clepublique_25,
t0.aliveip AS aliveip_26,
t0.alivesms AS alivesms_27,
t0.datesendaliveip AS datesendaliveip_28,
t0.datesendalivesms AS datesendalivesms_29,
t0.visuel AS visuel_30,
t0.tempvisuel AS tempvisuel_31,
t0.dateconf AS dateconf_32,
t0.usermaj AS usermaj_33,
t0.datemajutc AS datemajutc_34,
t0.supprime AS supprime_35,
t0.connexiongestion AS connexiongestion_36,
t0.idgestion AS idgestion_37,
t0.idmaitre AS idmaitre_38,
t0.idrelay AS idrelay_39,
t0.modelegenerateur_id AS modelegenerateur_id_40,
t0.typemodulecomgenerateur_id AS typemodulecomgenerateur_id_41,
t0.client_id AS client_id_42
FROM
generateur t0
WHERE
t0.id = ?
SELECT t0.id AS id_1, t0.numserie AS numserie_2, t0.type AS type_3, t0.numwhatsapp AS numwhatsapp_4, t0.pays AS pays_5, t0.site AS site_6, t0.numsim AS numsim_7, t0.datederniereinfo AS datederniereinfo_8, t0.datemiseenservice AS datemiseenservice_9, t0.alive AS alive_10, t0.o2h2 AS o2h2_11, t0.h2r AS h2r_12, t0.comp AS comp_13, t0.nivelec AS nivelec_14, t0.power AS power_15, t0.ximg AS ximg_16, t0.yimg AS yimg_17, t0.datesendalive AS datesendalive_18, t0.nivdiw AS nivdiw_19, t0.codeassociation AS codeassociation_20, t0.versiongensrelay AS versiongensrelay_21, t0.typemodule AS typemodule_22, t0.datederniereinfoip AS datederniereinfoip_23, t0.datederniereinfosms AS datederniereinfosms_24, t0.clepublique AS clepublique_25, t0.aliveip AS aliveip_26, t0.alivesms AS alivesms_27, t0.datesendaliveip AS datesendaliveip_28, t0.datesendalivesms AS datesendalivesms_29, t0.visuel AS visuel_30, t0.tempvisuel AS tempvisuel_31, t0.dateconf AS dateconf_32, t0.usermaj AS usermaj_33, t0.datemajutc AS datemajutc_34, t0.supprime AS supprime_35, t0.connexiongestion AS connexiongestion_36, t0.idgestion AS idgestion_37, t0.idmaitre AS idmaitre_38, t0.idrelay AS idrelay_39, t0.modelegenerateur_id AS modelegenerateur_id_40, t0.typemodulecomgenerateur_id AS typemodulecomgenerateur_id_41, t0.client_id AS client_id_42 FROM generateur t0 WHERE t0.id = '102';
|
0.62 ms
(0.44%)
|
1 |
update generateur set datemajutcgestion = datemajutc where datemajutcgestion is null
update generateur set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
0.61 ms
(0.43%)
|
1 |
update borne set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update borne set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
0.60 ms
(0.42%)
|
1 |
update client set datemajutcgestion = datemajutc where datemajutcgestion is null
update client set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
0.60 ms
(0.42%)
|
1 |
update visuel set datemajutcgestion = datemajutc where datemajutcgestion is null
update visuel set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
0.58 ms
(0.41%)
|
1 |
update statut set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update statut set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
0.58 ms
(0.41%)
|
1 |
update commandegene set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update commandegene set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
0.58 ms
(0.41%)
|
1 |
update variablegenerateur set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update variablegenerateur set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
0.56 ms
(0.40%)
|
1 |
update role set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update role set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
0.56 ms
(0.39%)
|
1 |
update statutnotification set datemajutcgestion = datemajutc where datemajutcgestion is null
update statutnotification set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
0.56 ms
(0.39%)
|
1 |
update typedocument set datemajutcgestion = datemajutc where datemajutcgestion is null
update typedocument set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
0.55 ms
(0.38%)
|
1 |
update typenotification set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update typenotification set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
0.55 ms
(0.38%)
|
1 |
update commandesend2gene set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update commandesend2gene set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
0.54 ms
(0.38%)
|
1 |
update theme set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update theme set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
0.53 ms
(0.37%)
|
1 |
update borne set datemajutcgestion = datemajutc where datemajutcgestion is null
update borne set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
0.52 ms
(0.37%)
|
1 |
update valeurvariableencours set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update valeurvariableencours set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
0.52 ms
(0.37%)
|
1 |
update variablegenerateur set datemajutcgestion = datemajutc where datemajutcgestion is null
update variablegenerateur set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
0.52 ms
(0.37%)
|
1 |
update document set datemajutcgestion = datemajutc where datemajutcgestion is null
update document set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
0.51 ms
(0.36%)
|
1 |
update document set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update document set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
0.51 ms
(0.36%)
|
1 |
update version set datemajutcgestion = datemajutc where datemajutcgestion is null
update version set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
0.51 ms
(0.36%)
|
1 |
update typemaintenance set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update typemaintenance set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
0.50 ms
(0.36%)
|
1 |
update statutcommandegene set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update statutcommandegene set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
0.50 ms
(0.35%)
|
1 |
update role set datemajutcgestion = datemajutc where datemajutcgestion is null
update role set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
0.49 ms
(0.35%)
|
1 |
select * from etatsynchrotable where actif = 1 and tiers=1 order by priorite
select * from etatsynchrotable where actif = 1 and tiers=1 order by priorite;
|
0.49 ms
(0.35%)
|
1 |
update incident set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update incident set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
0.49 ms
(0.35%)
|
1 |
update etatsynchrotable set datemajutcgestion = datemajutc where datemajutcgestion is null
update etatsynchrotable set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
0.49 ms
(0.35%)
|
1 |
update typenotification set datemajutcgestion = datemajutc where datemajutcgestion is null
update typenotification set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
0.49 ms
(0.35%)
|
1 |
update droits set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update droits set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
0.48 ms
(0.34%)
|
1 |
update commandegene set datemajutcgestion = datemajutc where datemajutcgestion is null
update commandegene set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
0.48 ms
(0.34%)
|
1 |
update typemodulecomgenerateur set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update typemodulecomgenerateur set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
0.48 ms
(0.34%)
|
1 |
update langue set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update langue set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
0.48 ms
(0.34%)
|
1 |
update membre set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update membre set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
0.47 ms
(0.33%)
|
1 |
update documentmodelegenerateur set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update documentmodelegenerateur set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
0.47 ms
(0.33%)
|
1 |
update variable set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update variable set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
0.47 ms
(0.33%)
|
1 |
update langue set datemajutcgestion = datemajutc where datemajutcgestion is null
update langue set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
0.46 ms
(0.33%)
|
1 |
update rolecommandegene set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update rolecommandegene set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
0.46 ms
(0.33%)
|
1 |
update typemodulecomgenerateur set datemajutcgestion = datemajutc where datemajutcgestion is null
update typemodulecomgenerateur set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
0.46 ms
(0.33%)
|
1 |
update objetnotification set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update objetnotification set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
0.46 ms
(0.32%)
|
1 |
update variable set datemajutcgestion = datemajutc where datemajutcgestion is null
update variable set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
0.46 ms
(0.32%)
|
1 |
update modenotificationgenerateur set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update modenotificationgenerateur set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
0.45 ms
(0.32%)
|
1 |
update typealarme set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update typealarme set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
0.45 ms
(0.32%)
|
1 |
update typedocument set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update typedocument set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
0.45 ms
(0.32%)
|
1 |
update contrat set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update contrat set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
0.45 ms
(0.32%)
|
1 |
update typelogaction set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update typelogaction set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
0.45 ms
(0.32%)
|
1 |
update groupe set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update groupe set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
0.45 ms
(0.31%)
|
1 |
SELECT id, code FROM langue WHERE actif = 1 and (supprime = 0 or supprime IS NULL)
SELECT id, code FROM langue WHERE actif = 1 and (supprime = 0 or supprime IS NULL);
|
0.45 ms
(0.31%)
|
1 |
update typecommandegene set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update typecommandegene set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
0.45 ms
(0.31%)
|
1 |
update typemaintenance set datemajutcgestion = datemajutc where datemajutcgestion is null
update typemaintenance set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
0.45 ms
(0.31%)
|
1 |
update incident set datemajutcgestion = datemajutc where datemajutcgestion is null
update incident set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
0.44 ms
(0.31%)
|
1 |
update droits set datemajutcgestion = datemajutc where datemajutcgestion is null
update droits set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
0.44 ms
(0.31%)
|
1 |
update user set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update user set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
0.44 ms
(0.31%)
|
1 |
update objetnotification set datemajutcgestion = datemajutc where datemajutcgestion is null
update objetnotification set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
0.43 ms
(0.30%)
|
1 |
select notification.* from notification WHERE notification.datemajutc > '2026-01-05 08:34:25' and ( notification.datemajutc > '2026-01-05 08:34:25' ) and generateur_id = 102
select notification.* from notification WHERE notification.datemajutc > '2026-01-05 08:34:25' and ( notification.datemajutc > '2026-01-05 08:34:25' ) and generateur_id = 102;
|
0.43 ms
(0.30%)
|
1 |
update theme set datemajutcgestion = datemajutc where datemajutcgestion is null
update theme set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
0.43 ms
(0.30%)
|
1 |
update commandegeneaffecte set datemajutcgestion = datemajutc where datemajutcgestion is null
update commandegeneaffecte set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
0.43 ms
(0.30%)
|
1 |
update contrat set datemajutcgestion = datemajutc where datemajutcgestion is null
update contrat set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
0.42 ms
(0.30%)
|
1 |
update maintenance set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update maintenance set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
0.42 ms
(0.30%)
|
1 |
update typealarme set datemajutcgestion = datemajutc where datemajutcgestion is null
update typealarme set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
0.42 ms
(0.29%)
|
1 |
update commandegeneaffecte set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update commandegeneaffecte set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
0.41 ms
(0.29%)
|
1 |
update valeurvariableencours set datemajutcgestion = datemajutc where datemajutcgestion is null
update valeurvariableencours set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
0.41 ms
(0.29%)
|
1 |
update typemaintenancerole set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update typemaintenancerole set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
0.40 ms
(0.28%)
|
1 |
update modenotificationgenerateur set datemajutcgestion = datemajutc where datemajutcgestion is null
update modenotificationgenerateur set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
0.40 ms
(0.28%)
|
1 |
update typecommandegene set datemajutcgestion = datemajutc where datemajutcgestion is null
update typecommandegene set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
0.39 ms
(0.28%)
|
1 |
update statutcommandegene set datemajutcgestion = datemajutc where datemajutcgestion is null
update statutcommandegene set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
0.39 ms
(0.28%)
|
1 |
update statut set datemajutcgestion = datemajutc where datemajutcgestion is null
update statut set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
0.39 ms
(0.28%)
|
1 |
update rolecommandegene set datemajutcgestion = datemajutc where datemajutcgestion is null
update rolecommandegene set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
0.39 ms
(0.27%)
|
1 |
update modelegenerateur set datemajutcgestion = datemajutc where datemajutcgestion is null
update modelegenerateur set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
0.39 ms
(0.27%)
|
1 |
update typelogaction set datemajutcgestion = datemajutc where datemajutcgestion is null
update typelogaction set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
0.38 ms
(0.27%)
|
1 |
update groupe set datemajutcgestion = datemajutc where datemajutcgestion is null
update groupe set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
0.37 ms
(0.26%)
|
1 |
update documentmodelegenerateur set datemajutcgestion = datemajutc where datemajutcgestion is null
update documentmodelegenerateur set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
0.36 ms
(0.25%)
|
1 |
update membre set datemajutcgestion = datemajutc where datemajutcgestion is null
update membre set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
0.35 ms
(0.25%)
|
1 |
update maintenance set datemajutcgestion = datemajutc where datemajutcgestion is null
update maintenance set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
0.33 ms
(0.23%)
|
1 |
update typemaintenancerole set datemajutcgestion = datemajutc where datemajutcgestion is null
update typemaintenancerole set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
0.31 ms
(0.22%)
|
1 |
SELECT commandesend2gene.* FROM commandesend2gene WHERE commandesend2gene.datemajutc > '2025-11-06 14:16:49' and ( commandesend2gene.datemajutc > '2025-11-06 14:16:49' ) and generateur_id = 102
SELECT commandesend2gene.* FROM commandesend2gene WHERE commandesend2gene.datemajutc > '2025-11-06 14:16:49' and ( commandesend2gene.datemajutc > '2025-11-06 14:16:49' ) and generateur_id = 102;
|
0.30 ms
(0.21%)
|
1 |
SELECT libfr.* FROM libfr WHERE libfr.datemajutc > '2025-08-12 08:33:07' and (libfr.datemajutc > '2025-08-12 08:33:07')
SELECT libfr.* FROM libfr WHERE libfr.datemajutc > '2025-08-12 08:33:07' and (libfr.datemajutc > '2025-08-12 08:33:07') ;
|
0.28 ms
(0.20%)
|
1 |
SELECT borne.* FROM borne JOIN variablegenerateur ON variablegenerateur.id = borne.variablegenerateur_id JOIN generateur ON generateur.id = variablegenerateur.generateur_id WHERE borne.datemajutc > '2025-08-29 07:12:51' and ( borne.datemajutc > '2025-08-29 07:12:51' ) and generateur.id = 102
SELECT borne.* FROM borne JOIN variablegenerateur ON variablegenerateur.id = borne.variablegenerateur_id JOIN generateur ON generateur.id = variablegenerateur.generateur_id WHERE borne.datemajutc > '2025-08-29 07:12:51' and ( borne.datemajutc > '2025-08-29 07:12:51' ) and generateur.id = 102;
|
0.27 ms
(0.19%)
|
1 |
SELECT user.* FROM user JOIN client ON client.id = user.client_id LEFT JOIN generateur ON generateur.client_id = client.id WHERE user.datemajutc > '2025-12-17 10:45:50' and ( user.datemajutc > '2025-12-17 10:45:50' ) and (generateur.id = 102 OR user.supadmin = 1 OR user.id = 102) GROUP BY user.id
SELECT user.* FROM user JOIN client ON client.id = user.client_id LEFT JOIN generateur ON generateur.client_id = client.id WHERE user.datemajutc > '2025-12-17 10:45:50' and ( user.datemajutc > '2025-12-17 10:45:50' ) and (generateur.id = 102 OR user.supadmin = 1 OR user.id = 102) GROUP BY user.id;
|
0.26 ms
(0.19%)
|
1 |
select etatsynchrotable.* from etatsynchrotable where actif = 1 and tiers= 1 order by priorite DESC
select etatsynchrotable.* from etatsynchrotable where actif = 1 and tiers= 1 order by priorite DESC;
|
0.26 ms
(0.18%)
|
1 |
select * from valeurvariableencours WHERE valeurvariableencours.datemajutc > '2026-01-14 11:19:58' and ( valeurvariableencours.datemajutc > '2026-01-14 11:19:58' ) and generateur_id = 102
select * from valeurvariableencours WHERE valeurvariableencours.datemajutc > '2026-01-14 11:19:58' and ( valeurvariableencours.datemajutc > '2026-01-14 11:19:58' ) and generateur_id = 102;
|
0.26 ms
(0.18%)
|
1 |
SELECT visuel.* FROM visuel WHERE visuel.datemajutc > '2025-11-06 14:22:27' and (visuel.datemajutc > '2025-11-06 14:22:27')
SELECT visuel.* FROM visuel WHERE visuel.datemajutc > '2025-11-06 14:22:27' and (visuel.datemajutc > '2025-11-06 14:22:27') ;
|
0.25 ms
(0.17%)
|
1 |
SELECT incident.* FROM incident WHERE incident.datemajutc > '2026-01-05 08:34:02' and ( incident.datemajutc > '2026-01-05 08:34:02' ) and generateur_id = 102
SELECT incident.* FROM incident WHERE incident.datemajutc > '2026-01-05 08:34:02' and ( incident.datemajutc > '2026-01-05 08:34:02' ) and generateur_id = 102;
|
0.23 ms
(0.16%)
|
1 |
SELECT document.* FROM document WHERE document.datemajutc > '2025-08-27 09:29:08' and (document.datemajutc > '2025-08-27 09:29:08')
SELECT document.* FROM document WHERE document.datemajutc > '2025-08-27 09:29:08' and (document.datemajutc > '2025-08-27 09:29:08') ;
|
0.22 ms
(0.15%)
|
1 |
SELECT generateur.* FROM generateur WHERE generateur.datemajutc > '2026-01-14 11:19:58' and ( generateur.datemajutc > '2026-01-14 11:19:58' ) and id = 102
SELECT generateur.* FROM generateur WHERE generateur.datemajutc > '2026-01-14 11:19:58' and ( generateur.datemajutc > '2026-01-14 11:19:58' ) and id = 102;
|
0.22 ms
(0.15%)
|
1 |
select * from variablegenerateur WHERE variablegenerateur.datemajutc > '2025-09-10 08:33:42' and ( variablegenerateur.datemajutc > '2025-09-10 08:33:42' ) and generateur_id = 102
select * from variablegenerateur WHERE variablegenerateur.datemajutc > '2025-09-10 08:33:42' and ( variablegenerateur.datemajutc > '2025-09-10 08:33:42' ) and generateur_id = 102;
|
0.21 ms
(0.15%)
|
1 |
select * from etatsynchrotable WHERE etatsynchrotable.datemajutc > '2025-10-31 12:29:31' and (etatsynchrotable.datemajutc > '2025-10-31 12:29:31')
select * from etatsynchrotable WHERE etatsynchrotable.datemajutc > '2025-10-31 12:29:31' and (etatsynchrotable.datemajutc > '2025-10-31 12:29:31') ;
|
0.20 ms
(0.14%)
|
1 |
SELECT groupe.* FROM groupe JOIN client ON client.id = groupe.client_id JOIN generateur ON generateur.client_id = client.id WHERE groupe.datemajutc > '2025-08-25 06:11:25' and ( groupe.datemajutc > '2025-08-25 06:11:25' ) and generateur.id = 102 GROUP BY groupe.id
SELECT groupe.* FROM groupe JOIN client ON client.id = groupe.client_id JOIN generateur ON generateur.client_id = client.id WHERE groupe.datemajutc > '2025-08-25 06:11:25' and ( groupe.datemajutc > '2025-08-25 06:11:25' ) and generateur.id = 102 GROUP BY groupe.id;
|
0.18 ms
(0.13%)
|
1 |
SELECT contrat.* FROM contrat JOIN generateur ON generateur.id = contrat.generateur_id WHERE contrat.datemajutc > '2025-07-21 16:51:48' and ( contrat.datemajutc > '2025-07-21 16:51:48' ) and generateur.id = 102
SELECT contrat.* FROM contrat JOIN generateur ON generateur.id = contrat.generateur_id WHERE contrat.datemajutc > '2025-07-21 16:51:48' and ( contrat.datemajutc > '2025-07-21 16:51:48' ) and generateur.id = 102;
|
0.18 ms
(0.13%)
|
1 |
SELECT commandegeneaffecte.* FROM commandegeneaffecte JOIN generateur ON generateur.id = commandegeneaffecte.generateur_id WHERE commandegeneaffecte.datemajutc > '2025-11-06 14:15:35' and ( commandegeneaffecte.datemajutc > '2025-11-06 14:15:35' ) and generateur.id = 102
SELECT commandegeneaffecte.* FROM commandegeneaffecte JOIN generateur ON generateur.id = commandegeneaffecte.generateur_id WHERE commandegeneaffecte.datemajutc > '2025-11-06 14:15:35' and ( commandegeneaffecte.datemajutc > '2025-11-06 14:15:35' ) and generateur.id = 102;
|
0.18 ms
(0.13%)
|
1 |
SELECT versionapp, DATE_FORMAT(datemajversion, '%d/%m/%Y %H:%i') AS datemajversion FROM parametre WHERE (supprime = 0 or supprime IS NULL)
SELECT versionapp, DATE_FORMAT(datemajversion, '%d/%m/%Y %H:%i') AS datemajversion FROM parametre WHERE (supprime = 0 or supprime IS NULL);
|
0.18 ms
(0.13%)
|
1 |
SELECT variable.* FROM variable WHERE variable.datemajutc > '2025-09-10 08:20:18' and (variable.datemajutc > '2025-09-10 08:20:18')
SELECT variable.* FROM variable WHERE variable.datemajutc > '2025-09-10 08:20:18' and (variable.datemajutc > '2025-09-10 08:20:18') ;
|
0.18 ms
(0.13%)
|
1 |
SELECT statut.* FROM statut WHERE statut.datemajutc > '2025-07-16 13:24:37' and (statut.datemajutc > '2025-07-16 13:24:37')
SELECT statut.* FROM statut WHERE statut.datemajutc > '2025-07-16 13:24:37' and (statut.datemajutc > '2025-07-16 13:24:37') ;
|
0.18 ms
(0.13%)
|
1 |
SELECT statutnotification.* FROM statutnotification WHERE statutnotification.datemajutc > '2025-07-16 13:24:37' and (statutnotification.datemajutc > '2025-07-16 13:24:37')
SELECT statutnotification.* FROM statutnotification WHERE statutnotification.datemajutc > '2025-07-16 13:24:37' and (statutnotification.datemajutc > '2025-07-16 13:24:37') ;
|
0.18 ms
(0.12%)
|
1 |
select membre.* from membre,groupe,droits WHERE membre.datemajutc > '2025-08-26 14:18:16' and ( membre.datemajutc > '2025-08-26 14:18:16' ) and membre.groupe_id = groupe.id and droits.groupe_id = groupe.id and droits.generateur_id =102
select membre.* from membre,groupe,droits WHERE membre.datemajutc > '2025-08-26 14:18:16' and ( membre.datemajutc > '2025-08-26 14:18:16' ) and membre.groupe_id = groupe.id and droits.groupe_id = groupe.id and droits.generateur_id =102;
|
0.17 ms
(0.12%)
|
1 |
SELECT version.* FROM version WHERE version.datemajutc > '2025-11-10 07:16:10' and (version.datemajutc > '2025-11-10 07:16:10')
SELECT version.* FROM version WHERE version.datemajutc > '2025-11-10 07:16:10' and (version.datemajutc > '2025-11-10 07:16:10') ;
|
0.17 ms
(0.12%)
|
1 |
SELECT commandegene.* FROM commandegene WHERE commandegene.datemajutc > '2025-08-26 06:48:07' and (commandegene.datemajutc > '2025-08-26 06:48:07')
SELECT commandegene.* FROM commandegene WHERE commandegene.datemajutc > '2025-08-26 06:48:07' and (commandegene.datemajutc > '2025-08-26 06:48:07') ;
|
0.17 ms
(0.12%)
|
1 |
SELECT modenotificationgenerateur.* FROM modenotificationgenerateur JOIN generateur ON generateur.id = modenotificationgenerateur.generateur_id WHERE modenotificationgenerateur.datemajutc > '2025-10-23 09:22:52' and ( modenotificationgenerateur.datemajutc > '2025-10-23 09:22:52' ) and generateur.id = 102 GROUP BY modenotificationgenerateur.id
SELECT modenotificationgenerateur.* FROM modenotificationgenerateur JOIN generateur ON generateur.id = modenotificationgenerateur.generateur_id WHERE modenotificationgenerateur.datemajutc > '2025-10-23 09:22:52' and ( modenotificationgenerateur.datemajutc > '2025-10-23 09:22:52' ) and generateur.id = 102 GROUP BY modenotificationgenerateur.id;
|
0.16 ms
(0.12%)
|
1 |
select * from maintenance WHERE maintenance.datemajutc > '2025-09-10 16:29:50' and ( maintenance.datemajutc > '2025-09-10 16:29:50' ) and generateur_id = 102
select * from maintenance WHERE maintenance.datemajutc > '2025-09-10 16:29:50' and ( maintenance.datemajutc > '2025-09-10 16:29:50' ) and generateur_id = 102;
|
0.16 ms
(0.11%)
|
1 |
SELECT typealarme.* FROM typealarme WHERE typealarme.datemajutc > '2025-07-16 13:24:37' and (typealarme.datemajutc > '2025-07-16 13:24:37')
SELECT typealarme.* FROM typealarme WHERE typealarme.datemajutc > '2025-07-16 13:24:37' and (typealarme.datemajutc > '2025-07-16 13:24:37') ;
|
0.16 ms
(0.11%)
|
1 |
SELECT typelogaction.* FROM typelogaction WHERE typelogaction.datemajutc > '2025-07-22 10:31:21' and (typelogaction.datemajutc > '2025-07-22 10:31:21')
SELECT typelogaction.* FROM typelogaction WHERE typelogaction.datemajutc > '2025-07-22 10:31:21' and (typelogaction.datemajutc > '2025-07-22 10:31:21') ;
|
0.16 ms
(0.11%)
|
1 |
SELECT rapportgenerateur.* FROM rapportgenerateur JOIN generateur ON generateur.id = rapportgenerateur.generateur_id WHERE rapportgenerateur.datemajutc > '2025-08-12 07:23:09' and ( rapportgenerateur.datemajutc > '2025-08-12 07:23:09' ) and generateur.id = 102
SELECT rapportgenerateur.* FROM rapportgenerateur JOIN generateur ON generateur.id = rapportgenerateur.generateur_id WHERE rapportgenerateur.datemajutc > '2025-08-12 07:23:09' and ( rapportgenerateur.datemajutc > '2025-08-12 07:23:09' ) and generateur.id = 102;
|
0.16 ms
(0.11%)
|
1 |
SELECT droits.* FROM droits WHERE droits.datemajutc > '2025-08-26 14:18:16' and ( droits.datemajutc > '2025-08-26 14:18:16' ) and droits.generateur_id = 102
SELECT droits.* FROM droits WHERE droits.datemajutc > '2025-08-26 14:18:16' and ( droits.datemajutc > '2025-08-26 14:18:16' ) and droits.generateur_id = 102;
|
0.16 ms
(0.11%)
|
1 |
SELECT langue.* FROM langue WHERE langue.datemajutc > '2025-07-16 13:24:37' and (langue.datemajutc > '2025-07-16 13:24:37')
SELECT langue.* FROM langue WHERE langue.datemajutc > '2025-07-16 13:24:37' and (langue.datemajutc > '2025-07-16 13:24:37') ;
|
0.15 ms
(0.11%)
|
1 |
SELECT documentmodelegenerateur.* FROM documentmodelegenerateur WHERE documentmodelegenerateur.datemajutc > '2025-08-27 09:29:08' and (documentmodelegenerateur.datemajutc > '2025-08-27 09:29:08')
SELECT documentmodelegenerateur.* FROM documentmodelegenerateur WHERE documentmodelegenerateur.datemajutc > '2025-08-27 09:29:08' and (documentmodelegenerateur.datemajutc > '2025-08-27 09:29:08') ;
|
0.15 ms
(0.11%)
|
1 |
SELECT typenotification.* FROM typenotification WHERE typenotification.datemajutc > '2025-07-16 13:33:17' and (typenotification.datemajutc > '2025-07-16 13:33:17')
SELECT typenotification.* FROM typenotification WHERE typenotification.datemajutc > '2025-07-16 13:33:17' and (typenotification.datemajutc > '2025-07-16 13:33:17') ;
|
0.15 ms
(0.10%)
|
1 |
select * from role WHERE role.datemajutc > '2025-08-12 13:34:16' and (role.datemajutc > '2025-08-12 13:34:16')
select * from role WHERE role.datemajutc > '2025-08-12 13:34:16' and (role.datemajutc > '2025-08-12 13:34:16') ;
|
0.15 ms
(0.10%)
|
1 |
SELECT typeenvoisms.* FROM typeenvoisms WHERE typeenvoisms.datemajutc > '2025-10-13 12:05:54' and (typeenvoisms.datemajutc > '2025-10-13 12:05:54')
SELECT typeenvoisms.* FROM typeenvoisms WHERE typeenvoisms.datemajutc > '2025-10-13 12:05:54' and (typeenvoisms.datemajutc > '2025-10-13 12:05:54') ;
|
0.14 ms
(0.10%)
|
1 |
SELECT statutcommandegene.* FROM statutcommandegene WHERE statutcommandegene.datemajutc > '2025-07-16 13:33:16' and (statutcommandegene.datemajutc > '2025-07-16 13:33:16')
SELECT statutcommandegene.* FROM statutcommandegene WHERE statutcommandegene.datemajutc > '2025-07-16 13:33:16' and (statutcommandegene.datemajutc > '2025-07-16 13:33:16') ;
|
0.14 ms
(0.10%)
|
1 |
SELECT typemaintenance.* FROM typemaintenance WHERE typemaintenance.datemajutc > '2025-08-13 14:00:58' and (typemaintenance.datemajutc > '2025-08-13 14:00:58')
SELECT typemaintenance.* FROM typemaintenance WHERE typemaintenance.datemajutc > '2025-08-13 14:00:58' and (typemaintenance.datemajutc > '2025-08-13 14:00:58') ;
|
0.14 ms
(0.10%)
|
1 |
SELECT typemodulecomgenerateur.* FROM typemodulecomgenerateur WHERE typemodulecomgenerateur.datemajutc > '2025-07-21 17:57:20' and (typemodulecomgenerateur.datemajutc > '2025-07-21 17:57:20')
SELECT typemodulecomgenerateur.* FROM typemodulecomgenerateur WHERE typemodulecomgenerateur.datemajutc > '2025-07-21 17:57:20' and (typemodulecomgenerateur.datemajutc > '2025-07-21 17:57:20') ;
|
0.14 ms
(0.10%)
|
1 |
SELECT objetnotification.* FROM objetnotification WHERE objetnotification.datemajutc > '2025-07-16 13:24:37' and (objetnotification.datemajutc > '2025-07-16 13:24:37')
SELECT objetnotification.* FROM objetnotification WHERE objetnotification.datemajutc > '2025-07-16 13:24:37' and (objetnotification.datemajutc > '2025-07-16 13:24:37') ;
|
0.14 ms
(0.10%)
|
1 |
SELECT rapport.* FROM rapport WHERE rapport.datemajutc > '2025-08-13 12:33:48' and (rapport.datemajutc > '2025-08-13 12:33:48')
SELECT rapport.* FROM rapport WHERE rapport.datemajutc > '2025-08-13 12:33:48' and (rapport.datemajutc > '2025-08-13 12:33:48') ;
|
0.13 ms
(0.09%)
|
1 |
SELECT typemaintenancerole.* FROM typemaintenancerole WHERE typemaintenancerole.datemajutc > '2025-08-13 13:45:05' and (typemaintenancerole.datemajutc > '2025-08-13 13:45:05')
SELECT typemaintenancerole.* FROM typemaintenancerole WHERE typemaintenancerole.datemajutc > '2025-08-13 13:45:05' and (typemaintenancerole.datemajutc > '2025-08-13 13:45:05') ;
|
0.13 ms
(0.09%)
|
1 |
SELECT typecommandegene.* FROM typecommandegene WHERE typecommandegene.datemajutc > '2025-07-16 13:33:16' and (typecommandegene.datemajutc > '2025-07-16 13:33:16')
SELECT typecommandegene.* FROM typecommandegene WHERE typecommandegene.datemajutc > '2025-07-16 13:33:16' and (typecommandegene.datemajutc > '2025-07-16 13:33:16') ;
|
0.13 ms
(0.09%)
|
1 |
SELECT modelegenerateur.* FROM modelegenerateur WHERE modelegenerateur.datemajutc > '2025-08-12 13:32:47' and (modelegenerateur.datemajutc > '2025-08-12 13:32:47')
SELECT modelegenerateur.* FROM modelegenerateur WHERE modelegenerateur.datemajutc > '2025-08-12 13:32:47' and (modelegenerateur.datemajutc > '2025-08-12 13:32:47') ;
|
0.13 ms
(0.09%)
|
1 |
SELECT rolecommandegene.* FROM rolecommandegene WHERE rolecommandegene.datemajutc > '2025-08-13 13:44:16' and (rolecommandegene.datemajutc > '2025-08-13 13:44:16')
SELECT rolecommandegene.* FROM rolecommandegene WHERE rolecommandegene.datemajutc > '2025-08-13 13:44:16' and (rolecommandegene.datemajutc > '2025-08-13 13:44:16') ;
|
0.12 ms
(0.09%)
|
1 |
SELECT typedocument.* FROM typedocument WHERE typedocument.datemajutc > '2025-08-12 13:55:40' and (typedocument.datemajutc > '2025-08-12 13:55:40')
SELECT typedocument.* FROM typedocument WHERE typedocument.datemajutc > '2025-08-12 13:55:40' and (typedocument.datemajutc > '2025-08-12 13:55:40') ;
|
0.12 ms
(0.09%)
|
1 |
SELECT theme.* FROM theme WHERE theme.datemajutc > '2025-08-12 13:39:42' and (theme.datemajutc > '2025-08-12 13:39:42')
SELECT theme.* FROM theme WHERE theme.datemajutc > '2025-08-12 13:39:42' and (theme.datemajutc > '2025-08-12 13:39:42') ;
|
0.12 ms
(0.08%)
|
1 |
update typeenvoisms set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update typeenvoisms set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
0.11 ms
(0.08%)
|
1 |
update rapportgenerateur set datemajutcgestion = datemajutc where datemajutcgestion is null
update rapportgenerateur set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
0.11 ms
(0.08%)
|
1 |
update rapport set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update rapport set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
0.11 ms
(0.07%)
|
1 |
update typeenvoisms set datemajutcgestion = datemajutc where datemajutcgestion is null
update typeenvoisms set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
0.10 ms
(0.07%)
|
1 |
update rapportgenerateur set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update rapportgenerateur set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
0.09 ms
(0.06%)
|
1 |
update rapport set datemajutcgestion = datemajutc where datemajutcgestion is null
update rapport set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|