Symfony Profiler

SELECT
  COUNT(*)
FROM
  PROGRESSION t0
WHERE
  t0.userId = ?
  AND t0.completed = ?

SELECT COUNT(*) FROM PROGRESSION t0 WHERE t0.userId = 1 AND t0.completed = 1;

SELECT
  COUNT(*)
FROM
  ACCESS_RFID_LOG t0
WHERE
  t0.userId = ?

SELECT COUNT(*) FROM ACCESS_RFID_LOG t0 WHERE t0.userId = 1;

SELECT
  COUNT(*)
FROM
  UTILISATEUR_BADGE t0
WHERE
  t0.utilisateurId = ?

SELECT COUNT(*) FROM UTILISATEUR_BADGE t0 WHERE t0.utilisateurId = 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.username AS username_3,
  t0.password AS password_4,
  t0.firstName AS firstName_5,
  t0.lastName AS lastName_6,
  t0.numeroId AS numeroId_7,
  t0.statut AS statut_8,
  t0.identifiantRfid AS identifiantRfid_9,
  t0.tempsPresenceTotal AS tempsPresenceTotal_10,
  t0.isVerified AS isVerified_11,
  t0.createdAt AS createdAt_12,
  t0.derniereConnexion AS derniereConnexion_13,
  t0.notificationEmail AS notificationEmail_14,
  t0.notificationPush AS notificationPush_15,
  t0.rappelReservation AS rappelReservation_16,
  t0.theme AS theme_17,
  t0.langue AS langue_18
FROM
  UTILISATEUR t0
ORDER BY
  t0.tempsPresenceTotal DESC
LIMIT
  3

SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.password AS password_4, t0.firstName AS firstName_5, t0.lastName AS lastName_6, t0.numeroId AS numeroId_7, t0.statut AS statut_8, t0.identifiantRfid AS identifiantRfid_9, t0.tempsPresenceTotal AS tempsPresenceTotal_10, t0.isVerified AS isVerified_11, t0.createdAt AS createdAt_12, t0.derniereConnexion AS derniereConnexion_13, t0.notificationEmail AS notificationEmail_14, t0.notificationPush AS notificationPush_15, t0.rappelReservation AS rappelReservation_16, t0.theme AS theme_17, t0.langue AS langue_18 FROM UTILISATEUR t0 ORDER BY t0.tempsPresenceTotal DESC LIMIT 3;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.description AS description_3,
  t0.localisation AS localisation_4,
  t0.photo AS photo_5,
  t0.statut AS statut_6,
  t0.granularite AS granularite_7,
  t0.categorySlug AS categorySlug_8,
  t0.categoryLabel AS categoryLabel_9,
  t0.levelSlug AS levelSlug_10,
  t0.levelLabel AS levelLabel_11,
  t0.iconSlug AS iconSlug_12,
  t0.materials AS materials_13,
  t0.features AS features_14,
  t0.requirementTitle AS requirementTitle_15,
  t0.requirementDescription AS requirementDescription_16,
  t0.popularity AS popularity_17,
  t0.limiteReservations AS limiteReservations_18,
  t0.machineToken AS machineToken_19,
  t0.createdAt AS createdAt_20,
  t0.updated AS updated_21,
  t0.lastAuthorizationTime AS lastAuthorizationTime_22
FROM
  MACHINE t0
ORDER BY
  t0.createdAt DESC
LIMIT
  6

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.localisation AS localisation_4, t0.photo AS photo_5, t0.statut AS statut_6, t0.granularite AS granularite_7, t0.categorySlug AS categorySlug_8, t0.categoryLabel AS categoryLabel_9, t0.levelSlug AS levelSlug_10, t0.levelLabel AS levelLabel_11, t0.iconSlug AS iconSlug_12, t0.materials AS materials_13, t0.features AS features_14, t0.requirementTitle AS requirementTitle_15, t0.requirementDescription AS requirementDescription_16, t0.popularity AS popularity_17, t0.limiteReservations AS limiteReservations_18, t0.machineToken AS machineToken_19, t0.createdAt AS createdAt_20, t0.updated AS updated_21, t0.lastAuthorizationTime AS lastAuthorizationTime_22 FROM MACHINE t0 ORDER BY t0.createdAt DESC LIMIT 6;

SELECT
  t0.id AS id_1,
  t0.dayOfWeek AS dayOfWeek_2,
  t0.label AS label_3,
  t0.isClosed AS isClosed_4,
  t0.openTime AS openTime_5,
  t0.closeTime AS closeTime_6,
  t0.sortOrder AS sortOrder_7,
  t0.updatedAt AS updatedAt_8
FROM
  OPENING_HOUR t0
ORDER BY
  t0.sortOrder ASC,
  t0.dayOfWeek ASC

SELECT t0.id AS id_1, t0.dayOfWeek AS dayOfWeek_2, t0.label AS label_3, t0.isClosed AS isClosed_4, t0.openTime AS openTime_5, t0.closeTime AS closeTime_6, t0.sortOrder AS sortOrder_7, t0.updatedAt AS updatedAt_8 FROM OPENING_HOUR t0 ORDER BY t0.sortOrder ASC, t0.dayOfWeek ASC;

SELECT
  COUNT(*)
FROM
  UTILISATEUR t0

SELECT COUNT(*) FROM UTILISATEUR t0;

SELECT
  COUNT(*)
FROM
  PROGRESSION t0
WHERE
  t0.completed = ?

SELECT COUNT(*) FROM PROGRESSION t0 WHERE t0.completed = 1;

SELECT
  COUNT(*)
FROM
  ACCESS_RFID_LOG t0

SELECT COUNT(*) FROM ACCESS_RFID_LOG t0;

SELECT
  t0.id AS id_1,
  t0.badgeUid AS badgeUid_2,
  t0.readerToken AS readerToken_3,
  t0.authorized AS authorized_4,
  t0.status AS status_5,
  t0.reason AS reason_6,
  t0.message AS message_7,
  t0.color AS color_8,
  t0.createdAt AS createdAt_9,
  t0.userId AS userId_10,
  t0.machineId AS machineId_11,
  t0.readerId AS readerId_12
FROM
  ACCESS_RFID_LOG t0
ORDER BY
  t0.createdAt DESC
LIMIT
  5

SELECT t0.id AS id_1, t0.badgeUid AS badgeUid_2, t0.readerToken AS readerToken_3, t0.authorized AS authorized_4, t0.status AS status_5, t0.reason AS reason_6, t0.message AS message_7, t0.color AS color_8, t0.createdAt AS createdAt_9, t0.userId AS userId_10, t0.machineId AS machineId_11, t0.readerId AS readerId_12 FROM ACCESS_RFID_LOG t0 ORDER BY t0.createdAt DESC LIMIT 5;

SELECT
  COUNT(*)
FROM
  FORMATION t0

SELECT COUNT(*) FROM FORMATION t0;

SELECT
  COUNT(*)
FROM
  RESERVATION t0

SELECT COUNT(*) FROM RESERVATION t0;

SELECT
  COUNT(*)
FROM
  BADGE t0

SELECT COUNT(*) FROM BADGE t0;

SELECT
  COUNT(*)
FROM
  MACHINE t0

SELECT COUNT(*) FROM MACHINE t0;