| 1 |
0.92 ms |
SELECT o0_.id AS id_0, o0_.titre AS titre_1, o0_.description AS description_2, o0_.competences_requises AS competences_requises_3, o0_.salaire AS salaire_4, o0_.localisation AS localisation_5, o0_.type_contrat AS type_contrat_6, o0_.statut AS statut_7, o0_.created_at AS created_at_8, o0_.updated_at AS updated_at_9, o0_.recruteur_id AS recruteur_id_10 FROM offre o0_ WHERE o0_.statut = ? ORDER BY o0_.created_at DESC LIMIT 6
Parameters: [
"publiee"
]
SELECT o0_.id AS id_0, o0_.titre AS titre_1, o0_.description AS description_2, o0_.competences_requises AS competences_requises_3, o0_.salaire AS salaire_4, o0_.localisation AS localisation_5, o0_.type_contrat AS type_contrat_6, o0_.statut AS statut_7, o0_.created_at AS created_at_8, o0_.updated_at AS updated_at_9, o0_.recruteur_id AS recruteur_id_10 FROM offre o0_ WHERE o0_.statut = 'publiee' ORDER BY o0_.created_at DESC LIMIT 6;
|
| 2 |
0.57 ms |
SELECT COUNT(o0_.id) AS sclr_0 FROM offre o0_ WHERE o0_.statut = ?
Parameters: [
"publiee"
]
SELECT COUNT(o0_.id) AS sclr_0 FROM offre o0_ WHERE o0_.statut = 'publiee';
|
| 3 |
0.48 ms |
SELECT COUNT(c0_.id) AS sclr_0 FROM candidat c0_
SELECT COUNT(c0_.id) AS sclr_0 FROM candidat c0_;
|
| 4 |
0.41 ms |
SELECT COUNT(c0_.id) AS sclr_0 FROM candidature c0_
SELECT COUNT(c0_.id) AS sclr_0 FROM candidature c0_;
|
| 5 |
0.46 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.entreprise AS entreprise_3, t0.secteur AS secteur_4, t0.logo_name AS logo_name_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.user_id AS user_id_9 FROM recruteur t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.entreprise AS entreprise_3, t0.secteur AS secteur_4, t0.logo_name AS logo_name_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.user_id AS user_id_9 FROM recruteur t0 WHERE t0.id = 4;
|
| 6 |
0.35 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.entreprise AS entreprise_3, t0.secteur AS secteur_4, t0.logo_name AS logo_name_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.user_id AS user_id_9 FROM recruteur t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.entreprise AS entreprise_3, t0.secteur AS secteur_4, t0.logo_name AS logo_name_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.user_id AS user_id_9 FROM recruteur t0 WHERE t0.id = 1;
|
| 7 |
0.27 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.entreprise AS entreprise_3, t0.secteur AS secteur_4, t0.logo_name AS logo_name_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.user_id AS user_id_9 FROM recruteur t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.entreprise AS entreprise_3, t0.secteur AS secteur_4, t0.logo_name AS logo_name_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.user_id AS user_id_9 FROM recruteur t0 WHERE t0.id = 2;
|