| 1 |
0.45 ms |
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);
|
| 2 |
0.19 ms |
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);
|
| 3 |
0.54 ms |
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';
|
| 4 |
0.52 ms |
SHOW COLUMNS FROM etatsynchrotable
SHOW COLUMNS FROM etatsynchrotable;
|
| 5 |
0.42 ms |
SHOW COLUMNS FROM client
SHOW COLUMNS FROM client;
|
| 6 |
0.43 ms |
SHOW COLUMNS FROM role
SHOW COLUMNS FROM role;
|
| 7 |
0.39 ms |
SHOW COLUMNS FROM langue
SHOW COLUMNS FROM langue;
|
| 8 |
0.37 ms |
SHOW COLUMNS FROM libfr
SHOW COLUMNS FROM libfr;
|
| 9 |
0.37 ms |
SHOW COLUMNS FROM modelegenerateur
SHOW COLUMNS FROM modelegenerateur;
|
| 10 |
0.36 ms |
SHOW COLUMNS FROM objetnotification
SHOW COLUMNS FROM objetnotification;
|
| 11 |
0.37 ms |
SHOW COLUMNS FROM statut
SHOW COLUMNS FROM statut;
|
| 12 |
0.36 ms |
SHOW COLUMNS FROM statutcommandegene
SHOW COLUMNS FROM statutcommandegene;
|
| 13 |
0.36 ms |
SHOW COLUMNS FROM statutnotification
SHOW COLUMNS FROM statutnotification;
|
| 14 |
0.39 ms |
SHOW COLUMNS FROM theme
SHOW COLUMNS FROM theme;
|
| 15 |
0.38 ms |
SHOW COLUMNS FROM typealarme
SHOW COLUMNS FROM typealarme;
|
| 16 |
0.37 ms |
SHOW COLUMNS FROM typecommandegene
SHOW COLUMNS FROM typecommandegene;
|
| 17 |
0.36 ms |
SHOW COLUMNS FROM typedocument
SHOW COLUMNS FROM typedocument;
|
| 18 |
0.36 ms |
SHOW COLUMNS FROM typelogaction
SHOW COLUMNS FROM typelogaction;
|
| 19 |
0.36 ms |
SHOW COLUMNS FROM typemaintenance
SHOW COLUMNS FROM typemaintenance;
|
| 20 |
0.36 ms |
SHOW COLUMNS FROM typemodulecomgenerateur
SHOW COLUMNS FROM typemodulecomgenerateur;
|
| 21 |
0.36 ms |
SHOW COLUMNS FROM typenotification
SHOW COLUMNS FROM typenotification;
|
| 22 |
0.38 ms |
SHOW COLUMNS FROM version
SHOW COLUMNS FROM version;
|
| 23 |
0.37 ms |
SHOW COLUMNS FROM visuel
SHOW COLUMNS FROM visuel;
|
| 24 |
0.41 ms |
SHOW COLUMNS FROM typeenvoisms
SHOW COLUMNS FROM typeenvoisms;
|
| 25 |
0.42 ms |
SHOW COLUMNS FROM generateur
SHOW COLUMNS FROM generateur;
|
| 26 |
0.39 ms |
SHOW COLUMNS FROM commandegene
SHOW COLUMNS FROM commandegene;
|
| 27 |
0.37 ms |
SHOW COLUMNS FROM traduction
SHOW COLUMNS FROM traduction;
|
| 28 |
0.39 ms |
SHOW COLUMNS FROM variable
SHOW COLUMNS FROM variable;
|
| 29 |
0.47 ms |
SHOW COLUMNS FROM user
SHOW COLUMNS FROM user;
|
| 30 |
0.43 ms |
SHOW COLUMNS FROM groupe
SHOW COLUMNS FROM groupe;
|
| 31 |
0.40 ms |
SHOW COLUMNS FROM rapport
SHOW COLUMNS FROM rapport;
|
| 32 |
0.37 ms |
SHOW COLUMNS FROM typemaintenancerole
SHOW COLUMNS FROM typemaintenancerole;
|
| 33 |
0.40 ms |
SHOW COLUMNS FROM maintenance
SHOW COLUMNS FROM maintenance;
|
| 34 |
0.38 ms |
SHOW COLUMNS FROM valeurvariableencours
SHOW COLUMNS FROM valeurvariableencours;
|
| 35 |
0.38 ms |
SHOW COLUMNS FROM incident
SHOW COLUMNS FROM incident;
|
| 36 |
0.39 ms |
SHOW COLUMNS FROM variablegenerateur
SHOW COLUMNS FROM variablegenerateur;
|
| 37 |
0.37 ms |
SHOW COLUMNS FROM commandegeneaffecte
SHOW COLUMNS FROM commandegeneaffecte;
|
| 38 |
0.39 ms |
SHOW COLUMNS FROM document
SHOW COLUMNS FROM document;
|
| 39 |
0.38 ms |
SHOW COLUMNS FROM modenotificationgenerateur
SHOW COLUMNS FROM modenotificationgenerateur;
|
| 40 |
0.38 ms |
SHOW COLUMNS FROM droits
SHOW COLUMNS FROM droits;
|
| 41 |
0.38 ms |
SHOW COLUMNS FROM membre
SHOW COLUMNS FROM membre;
|
| 42 |
0.37 ms |
SHOW COLUMNS FROM contrat
SHOW COLUMNS FROM contrat;
|
| 43 |
0.40 ms |
SHOW COLUMNS FROM rolecommandegene
SHOW COLUMNS FROM rolecommandegene;
|
| 44 |
0.36 ms |
SHOW COLUMNS FROM rapportgenerateur
SHOW COLUMNS FROM rapportgenerateur;
|
| 45 |
0.37 ms |
SHOW COLUMNS FROM notification
SHOW COLUMNS FROM notification;
|
| 46 |
0.37 ms |
SHOW COLUMNS FROM borne
SHOW COLUMNS FROM borne;
|
| 47 |
0.41 ms |
SHOW COLUMNS FROM documentmodelegenerateur
SHOW COLUMNS FROM documentmodelegenerateur;
|
| 48 |
0.40 ms |
SHOW COLUMNS FROM commandesend2gene
SHOW COLUMNS FROM commandesend2gene;
|
| 49 |
0.38 ms |
SHOW COLUMNS FROM suppression
SHOW COLUMNS FROM suppression;
|
| 50 |
0.29 ms |
select * from etatsynchrotable where actif = 1 and tiers=1 order by priorite
select * from etatsynchrotable where actif = 1 and tiers=1 order by priorite;
|
| 51 |
0.39 ms |
SHOW COLUMNS FROM etatsynchrotable
SHOW COLUMNS FROM etatsynchrotable;
|
| 52 |
1.06 ms |
update etatsynchrotable set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update etatsynchrotable set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 53 |
0.63 ms |
update etatsynchrotable set datemajutcgestion = datemajutc where datemajutcgestion is null
update etatsynchrotable set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 54 |
0.29 ms |
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') ;
|
| 55 |
0.54 ms |
SHOW COLUMNS FROM client
SHOW COLUMNS FROM client;
|
| 56 |
0.80 ms |
update client set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update client set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 57 |
0.56 ms |
update client set datemajutcgestion = datemajutc where datemajutcgestion is null
update client set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 58 |
0.67 ms |
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;
|
| 59 |
0.48 ms |
SHOW COLUMNS FROM role
SHOW COLUMNS FROM role;
|
| 60 |
0.56 ms |
update role set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update role set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 61 |
0.49 ms |
update role set datemajutcgestion = datemajutc where datemajutcgestion is null
update role set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 62 |
0.17 ms |
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') ;
|
| 63 |
0.42 ms |
SHOW COLUMNS FROM langue
SHOW COLUMNS FROM langue;
|
| 64 |
0.56 ms |
update langue set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update langue set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 65 |
0.56 ms |
update langue set datemajutcgestion = datemajutc where datemajutcgestion is null
update langue set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 66 |
0.15 ms |
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') ;
|
| 67 |
0.44 ms |
SHOW COLUMNS FROM libfr
SHOW COLUMNS FROM libfr;
|
| 68 |
1.26 ms |
update libfr set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update libfr set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 69 |
0.74 ms |
update libfr set datemajutcgestion = datemajutc where datemajutcgestion is null
update libfr set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 70 |
0.37 ms |
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') ;
|
| 71 |
0.44 ms |
SHOW COLUMNS FROM modelegenerateur
SHOW COLUMNS FROM modelegenerateur;
|
| 72 |
0.53 ms |
update modelegenerateur set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update modelegenerateur set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 73 |
0.39 ms |
update modelegenerateur set datemajutcgestion = datemajutc where datemajutcgestion is null
update modelegenerateur set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 74 |
0.13 ms |
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') ;
|
| 75 |
0.39 ms |
SHOW COLUMNS FROM objetnotification
SHOW COLUMNS FROM objetnotification;
|
| 76 |
0.43 ms |
update objetnotification set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update objetnotification set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 77 |
0.49 ms |
update objetnotification set datemajutcgestion = datemajutc where datemajutcgestion is null
update objetnotification set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 78 |
0.15 ms |
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') ;
|
| 79 |
0.42 ms |
SHOW COLUMNS FROM statut
SHOW COLUMNS FROM statut;
|
| 80 |
0.48 ms |
update statut set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update statut set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 81 |
0.44 ms |
update statut set datemajutcgestion = datemajutc where datemajutcgestion is null
update statut set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 82 |
0.13 ms |
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') ;
|
| 83 |
0.41 ms |
SHOW COLUMNS FROM statutcommandegene
SHOW COLUMNS FROM statutcommandegene;
|
| 84 |
0.51 ms |
update statutcommandegene set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update statutcommandegene set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 85 |
0.45 ms |
update statutcommandegene set datemajutcgestion = datemajutc where datemajutcgestion is null
update statutcommandegene set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 86 |
0.13 ms |
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') ;
|
| 87 |
0.41 ms |
SHOW COLUMNS FROM statutnotification
SHOW COLUMNS FROM statutnotification;
|
| 88 |
0.50 ms |
update statutnotification set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update statutnotification set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 89 |
0.47 ms |
update statutnotification set datemajutcgestion = datemajutc where datemajutcgestion is null
update statutnotification set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 90 |
0.14 ms |
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') ;
|
| 91 |
0.42 ms |
SHOW COLUMNS FROM theme
SHOW COLUMNS FROM theme;
|
| 92 |
0.51 ms |
update theme set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update theme set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 93 |
0.66 ms |
update theme set datemajutcgestion = datemajutc where datemajutcgestion is null
update theme set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 94 |
0.14 ms |
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') ;
|
| 95 |
0.50 ms |
SHOW COLUMNS FROM typealarme
SHOW COLUMNS FROM typealarme;
|
| 96 |
0.51 ms |
update typealarme set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update typealarme set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 97 |
0.49 ms |
update typealarme set datemajutcgestion = datemajutc where datemajutcgestion is null
update typealarme set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 98 |
0.14 ms |
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') ;
|
| 99 |
0.38 ms |
SHOW COLUMNS FROM typecommandegene
SHOW COLUMNS FROM typecommandegene;
|
| 100 |
0.46 ms |
update typecommandegene set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update typecommandegene set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 101 |
0.37 ms |
update typecommandegene set datemajutcgestion = datemajutc where datemajutcgestion is null
update typecommandegene set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 102 |
0.13 ms |
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') ;
|
| 103 |
0.37 ms |
SHOW COLUMNS FROM typedocument
SHOW COLUMNS FROM typedocument;
|
| 104 |
0.48 ms |
update typedocument set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update typedocument set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 105 |
0.49 ms |
update typedocument set datemajutcgestion = datemajutc where datemajutcgestion is null
update typedocument set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 106 |
0.16 ms |
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') ;
|
| 107 |
0.39 ms |
SHOW COLUMNS FROM typelogaction
SHOW COLUMNS FROM typelogaction;
|
| 108 |
0.47 ms |
update typelogaction set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update typelogaction set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 109 |
0.38 ms |
update typelogaction set datemajutcgestion = datemajutc where datemajutcgestion is null
update typelogaction set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 110 |
0.14 ms |
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') ;
|
| 111 |
0.40 ms |
SHOW COLUMNS FROM typemaintenance
SHOW COLUMNS FROM typemaintenance;
|
| 112 |
0.47 ms |
update typemaintenance set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update typemaintenance set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 113 |
0.49 ms |
update typemaintenance set datemajutcgestion = datemajutc where datemajutcgestion is null
update typemaintenance set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 114 |
0.15 ms |
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') ;
|
| 115 |
0.42 ms |
SHOW COLUMNS FROM typemodulecomgenerateur
SHOW COLUMNS FROM typemodulecomgenerateur;
|
| 116 |
0.50 ms |
update typemodulecomgenerateur set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update typemodulecomgenerateur set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 117 |
0.54 ms |
update typemodulecomgenerateur set datemajutcgestion = datemajutc where datemajutcgestion is null
update typemodulecomgenerateur set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 118 |
0.15 ms |
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') ;
|
| 119 |
0.45 ms |
SHOW COLUMNS FROM typenotification
SHOW COLUMNS FROM typenotification;
|
| 120 |
0.57 ms |
update typenotification set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update typenotification set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 121 |
0.55 ms |
update typenotification set datemajutcgestion = datemajutc where datemajutcgestion is null
update typenotification set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 122 |
0.14 ms |
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') ;
|
| 123 |
0.44 ms |
SHOW COLUMNS FROM version
SHOW COLUMNS FROM version;
|
| 124 |
0.54 ms |
update version set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update version set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 125 |
0.46 ms |
update version set datemajutcgestion = datemajutc where datemajutcgestion is null
update version set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 126 |
0.16 ms |
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') ;
|
| 127 |
0.43 ms |
SHOW COLUMNS FROM visuel
SHOW COLUMNS FROM visuel;
|
| 128 |
0.80 ms |
update visuel set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update visuel set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 129 |
0.67 ms |
update visuel set datemajutcgestion = datemajutc where datemajutcgestion is null
update visuel set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 130 |
0.27 ms |
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') ;
|
| 131 |
0.41 ms |
SHOW COLUMNS FROM typeenvoisms
SHOW COLUMNS FROM typeenvoisms;
|
| 132 |
0.12 ms |
update typeenvoisms set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update typeenvoisms set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 133 |
0.09 ms |
update typeenvoisms set datemajutcgestion = datemajutc where datemajutcgestion is null
update typeenvoisms set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 134 |
0.12 ms |
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') ;
|
| 135 |
0.46 ms |
SHOW COLUMNS FROM generateur
SHOW COLUMNS FROM generateur;
|
| 136 |
0.78 ms |
update generateur set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update generateur set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 137 |
0.68 ms |
update generateur set datemajutcgestion = datemajutc where datemajutcgestion is null
update generateur set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 138 |
0.20 ms |
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;
|
| 139 |
0.47 ms |
SHOW COLUMNS FROM commandegene
SHOW COLUMNS FROM commandegene;
|
| 140 |
0.51 ms |
update commandegene set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update commandegene set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 141 |
0.52 ms |
update commandegene set datemajutcgestion = datemajutc where datemajutcgestion is null
update commandegene set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 142 |
0.16 ms |
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') ;
|
| 143 |
0.44 ms |
SHOW COLUMNS FROM traduction
SHOW COLUMNS FROM traduction;
|
| 144 |
1.47 ms |
update traduction set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update traduction set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 145 |
1.27 ms |
update traduction set datemajutcgestion = datemajutc where datemajutcgestion is null
update traduction set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 146 |
1.01 ms |
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') ;
|
| 147 |
0.46 ms |
SHOW COLUMNS FROM variable
SHOW COLUMNS FROM variable;
|
| 148 |
0.63 ms |
update variable set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update variable set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 149 |
0.52 ms |
update variable set datemajutcgestion = datemajutc where datemajutcgestion is null
update variable set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 150 |
0.20 ms |
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') ;
|
| 151 |
0.43 ms |
SHOW COLUMNS FROM rapport
SHOW COLUMNS FROM rapport;
|
| 152 |
0.13 ms |
update rapport set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update rapport set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 153 |
0.10 ms |
update rapport set datemajutcgestion = datemajutc where datemajutcgestion is null
update rapport set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 154 |
0.16 ms |
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') ;
|
| 155 |
0.40 ms |
SHOW COLUMNS FROM typemaintenancerole
SHOW COLUMNS FROM typemaintenancerole;
|
| 156 |
0.53 ms |
update typemaintenancerole set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update typemaintenancerole set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 157 |
0.51 ms |
update typemaintenancerole set datemajutcgestion = datemajutc where datemajutcgestion is null
update typemaintenancerole set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 158 |
0.15 ms |
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') ;
|
| 159 |
0.45 ms |
SHOW COLUMNS FROM user
SHOW COLUMNS FROM user;
|
| 160 |
0.56 ms |
update user set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update user set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 161 |
0.48 ms |
update user set datemajutcgestion = datemajutc where datemajutcgestion is null
update user set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 162 |
0.28 ms |
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;
|
| 163 |
0.40 ms |
SHOW COLUMNS FROM groupe
SHOW COLUMNS FROM groupe;
|
| 164 |
0.55 ms |
update groupe set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update groupe set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 165 |
0.45 ms |
update groupe set datemajutcgestion = datemajutc where datemajutcgestion is null
update groupe set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 166 |
0.22 ms |
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;
|
| 167 |
0.41 ms |
SHOW COLUMNS FROM maintenance
SHOW COLUMNS FROM maintenance;
|
| 168 |
0.60 ms |
update maintenance set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update maintenance set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 169 |
0.56 ms |
update maintenance set datemajutcgestion = datemajutc where datemajutcgestion is null
update maintenance set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 170 |
0.18 ms |
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;
|
| 171 |
0.42 ms |
SHOW COLUMNS FROM incident
SHOW COLUMNS FROM incident;
|
| 172 |
0.54 ms |
update incident set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update incident set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 173 |
0.62 ms |
update incident set datemajutcgestion = datemajutc where datemajutcgestion is null
update incident set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 174 |
0.28 ms |
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;
|
| 175 |
0.42 ms |
SHOW COLUMNS FROM valeurvariableencours
SHOW COLUMNS FROM valeurvariableencours;
|
| 176 |
0.64 ms |
update valeurvariableencours set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update valeurvariableencours set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 177 |
0.54 ms |
update valeurvariableencours set datemajutcgestion = datemajutc where datemajutcgestion is null
update valeurvariableencours set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 178 |
0.20 ms |
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;
|
| 179 |
0.42 ms |
SHOW COLUMNS FROM commandegeneaffecte
SHOW COLUMNS FROM commandegeneaffecte;
|
| 180 |
0.52 ms |
update commandegeneaffecte set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update commandegeneaffecte set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 181 |
0.44 ms |
update commandegeneaffecte set datemajutcgestion = datemajutc where datemajutcgestion is null
update commandegeneaffecte set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 182 |
0.27 ms |
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;
|
| 183 |
0.46 ms |
SHOW COLUMNS FROM document
SHOW COLUMNS FROM document;
|
| 184 |
0.54 ms |
update document set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update document set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 185 |
0.45 ms |
update document set datemajutcgestion = datemajutc where datemajutcgestion is null
update document set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 186 |
0.19 ms |
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') ;
|
| 187 |
0.43 ms |
SHOW COLUMNS FROM modenotificationgenerateur
SHOW COLUMNS FROM modenotificationgenerateur;
|
| 188 |
0.49 ms |
update modenotificationgenerateur set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update modenotificationgenerateur set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 189 |
0.41 ms |
update modenotificationgenerateur set datemajutcgestion = datemajutc where datemajutcgestion is null
update modenotificationgenerateur set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 190 |
0.20 ms |
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;
|
| 191 |
0.44 ms |
SHOW COLUMNS FROM rolecommandegene
SHOW COLUMNS FROM rolecommandegene;
|
| 192 |
0.44 ms |
update rolecommandegene set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update rolecommandegene set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 193 |
0.39 ms |
update rolecommandegene set datemajutcgestion = datemajutc where datemajutcgestion is null
update rolecommandegene set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 194 |
0.20 ms |
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') ;
|
| 195 |
0.51 ms |
SHOW COLUMNS FROM contrat
SHOW COLUMNS FROM contrat;
|
| 196 |
0.48 ms |
update contrat set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update contrat set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 197 |
0.43 ms |
update contrat set datemajutcgestion = datemajutc where datemajutcgestion is null
update contrat set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 198 |
0.18 ms |
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;
|
| 199 |
0.42 ms |
SHOW COLUMNS FROM variablegenerateur
SHOW COLUMNS FROM variablegenerateur;
|
| 200 |
0.60 ms |
update variablegenerateur set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update variablegenerateur set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 201 |
0.56 ms |
update variablegenerateur set datemajutcgestion = datemajutc where datemajutcgestion is null
update variablegenerateur set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 202 |
0.22 ms |
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;
|
| 203 |
0.40 ms |
SHOW COLUMNS FROM rapportgenerateur
SHOW COLUMNS FROM rapportgenerateur;
|
| 204 |
0.10 ms |
update rapportgenerateur set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update rapportgenerateur set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 205 |
0.08 ms |
update rapportgenerateur set datemajutcgestion = datemajutc where datemajutcgestion is null
update rapportgenerateur set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 206 |
0.16 ms |
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;
|
| 207 |
0.40 ms |
SHOW COLUMNS FROM membre
SHOW COLUMNS FROM membre;
|
| 208 |
0.45 ms |
update membre set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update membre set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 209 |
0.37 ms |
update membre set datemajutcgestion = datemajutc where datemajutcgestion is null
update membre set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 210 |
0.22 ms |
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;
|
| 211 |
0.40 ms |
SHOW COLUMNS FROM droits
SHOW COLUMNS FROM droits;
|
| 212 |
0.41 ms |
update droits set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update droits set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 213 |
0.40 ms |
update droits set datemajutcgestion = datemajutc where datemajutcgestion is null
update droits set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 214 |
0.17 ms |
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;
|
| 215 |
0.42 ms |
SHOW COLUMNS FROM notification
SHOW COLUMNS FROM notification;
|
| 216 |
0.71 ms |
update notification set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update notification set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 217 |
0.77 ms |
update notification set datemajutcgestion = datemajutc where datemajutcgestion is null
update notification set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 218 |
0.45 ms |
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;
|
| 219 |
0.39 ms |
SHOW COLUMNS FROM borne
SHOW COLUMNS FROM borne;
|
| 220 |
0.52 ms |
update borne set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update borne set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 221 |
0.51 ms |
update borne set datemajutcgestion = datemajutc where datemajutcgestion is null
update borne set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 222 |
0.29 ms |
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;
|
| 223 |
0.40 ms |
SHOW COLUMNS FROM documentmodelegenerateur
SHOW COLUMNS FROM documentmodelegenerateur;
|
| 224 |
0.40 ms |
update documentmodelegenerateur set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update documentmodelegenerateur set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 225 |
0.35 ms |
update documentmodelegenerateur set datemajutcgestion = datemajutc where datemajutcgestion is null
update documentmodelegenerateur set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 226 |
0.17 ms |
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') ;
|
| 227 |
0.39 ms |
SHOW COLUMNS FROM commandesend2gene
SHOW COLUMNS FROM commandesend2gene;
|
| 228 |
0.55 ms |
update commandesend2gene set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update commandesend2gene set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 229 |
0.58 ms |
update commandesend2gene set datemajutcgestion = datemajutc where datemajutcgestion is null
update commandesend2gene set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 230 |
0.34 ms |
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;
|
| 231 |
0.41 ms |
SHOW COLUMNS FROM suppression
SHOW COLUMNS FROM suppression;
|
| 232 |
2.04 ms |
update suppression set datemajutc=UTC_TIMESTAMP() where datemajutc is null
update suppression set datemajutc=UTC_TIMESTAMP() where datemajutc is null ;
|
| 233 |
1.84 ms |
update suppression set datemajutcgestion = datemajutc where datemajutcgestion is null
update suppression set datemajutcgestion = datemajutc where datemajutcgestion is null ;
|
| 234 |
1.54 ms |
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);
|
| 235 |
0.28 ms |
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;
|
| 236 |
0.94 ms |
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;
|
| 237 |
0.85 ms |
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;
|
| 238 |
0.82 ms |
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;
|
| 239 |
0.79 ms |
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;
|
| 240 |
0.86 ms |
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;
|
| 241 |
0.80 ms |
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;
|
| 242 |
0.84 ms |
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;
|
| 243 |
0.83 ms |
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;
|
| 244 |
0.83 ms |
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;
|
| 245 |
0.81 ms |
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;
|
| 246 |
0.83 ms |
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;
|
| 247 |
0.83 ms |
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;
|
| 248 |
0.83 ms |
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;
|
| 249 |
0.88 ms |
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;
|
| 250 |
1.00 ms |
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;
|
| 251 |
0.85 ms |
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;
|
| 252 |
0.85 ms |
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;
|
| 253 |
0.83 ms |
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;
|
| 254 |
0.83 ms |
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;
|
| 255 |
0.91 ms |
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;
|
| 256 |
1.43 ms |
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;
|
| 257 |
1.10 ms |
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;
|
| 258 |
0.86 ms |
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;
|
| 259 |
0.92 ms |
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;
|
| 260 |
0.89 ms |
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;
|
| 261 |
0.91 ms |
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;
|
| 262 |
0.91 ms |
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;
|
| 263 |
0.81 ms |
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;
|
| 264 |
0.86 ms |
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;
|
| 265 |
0.81 ms |
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;
|
| 266 |
0.79 ms |
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;
|
| 267 |
0.80 ms |
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;
|
| 268 |
0.82 ms |
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;
|
| 269 |
0.87 ms |
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;
|
| 270 |
0.84 ms |
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;
|
| 271 |
0.83 ms |
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;
|
| 272 |
0.83 ms |
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;
|
| 273 |
0.86 ms |
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;
|
| 274 |
0.88 ms |
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;
|
| 275 |
0.85 ms |
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;
|
| 276 |
0.84 ms |
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;
|
| 277 |
0.83 ms |
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;
|
| 278 |
0.86 ms |
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;
|
| 279 |
0.83 ms |
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;
|
| 280 |
0.83 ms |
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;
|
| 281 |
0.83 ms |
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;
|
| 282 |
1.21 ms |
UPDATE generateur SET datederniereinfoip = utc_timestamp(), datederniereinfo = utc_timestamp() WHERE id = 102
UPDATE generateur SET datederniereinfoip = utc_timestamp(), datederniereinfo = utc_timestamp() WHERE id = 102;
|