Symfony Profiler

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO visitor (ip, date)
VALUES
  (?, ?)

INSERT INTO visitor (ip, date) VALUES ('95.214.55.138', '2024-09-29 16:31:32');

"COMMIT"

"COMMIT";

SELECT
  COUNT(*) as count
FROM
  recommandation

SELECT COUNT(*) as count FROM recommandation;

SELECT
  a0_.id AS id_0,
  a0_.intitule AS intitule_1,
  a0_.lien AS lien_2,
  a0_.commission AS commission_3,
  a0_.annee AS annee_4,
  a0_.domaine AS domaine_5,
  a0_.source AS source_6,
  a0_.ar_id AS ar_id_7,
  a0_.domaine_id_id AS domaine_id_id_8,
  a0_.commission_id_id AS commission_id_id_9
FROM
  avis a0_
WHERE
  a0_.source = ?
ORDER BY
  a0_.id DESC
LIMIT
  5

SELECT a0_.id AS id_0, a0_.intitule AS intitule_1, a0_.lien AS lien_2, a0_.commission AS commission_3, a0_.annee AS annee_4, a0_.domaine AS domaine_5, a0_.source AS source_6, a0_.ar_id AS ar_id_7, a0_.domaine_id_id AS domaine_id_id_8, a0_.commission_id_id AS commission_id_id_9 FROM avis a0_ WHERE a0_.source = 'CESE' ORDER BY a0_.id DESC LIMIT 5;

SELECT
  COUNT(*) as count
FROM
  recommandation
where
  Avis_URL_id in (
    SELECT
      id
    from
      avis
    where
      Domaine_id_id = '2'
  )

SELECT COUNT(*) as count FROM recommandation where  Avis_URL_id in (SELECT id from avis where Domaine_id_id='2');

SELECT
  COUNT(DISTINCT commission) AS count
FROM
  avis
where
  domaine_id_id = '2'

SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='2';

SELECT
  COUNT(*) as count
FROM
  avis
where
  domaine_id_id = '2'

SELECT COUNT(*) as count FROM avis where domaine_id_id='2';

SELECT
  COUNT(*) as count
FROM
  recommandation
where
  Avis_URL_id in (
    SELECT
      id
    from
      avis
    where
      Domaine_id_id = '3'
  )

SELECT COUNT(*) as count FROM recommandation where  Avis_URL_id in (SELECT id from avis where Domaine_id_id='3');

SELECT
  COUNT(DISTINCT commission) AS count
FROM
  avis
where
  domaine_id_id = '3'

SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='3';

SELECT
  COUNT(*) as count
FROM
  avis
where
  domaine_id_id = '3'

SELECT COUNT(*) as count FROM avis where domaine_id_id='3';

SELECT
  COUNT(*) as count
FROM
  recommandation
where
  Avis_URL_id in (
    SELECT
      id
    from
      avis
    where
      Domaine_id_id = '4'
  )

SELECT COUNT(*) as count FROM recommandation where  Avis_URL_id in (SELECT id from avis where Domaine_id_id='4');

SELECT
  COUNT(DISTINCT commission) AS count
FROM
  avis
where
  domaine_id_id = '4'

SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='4';

SELECT
  COUNT(*) as count
FROM
  avis
where
  domaine_id_id = '4'

SELECT COUNT(*) as count FROM avis where domaine_id_id='4';

SELECT
  COUNT(*) as count
FROM
  recommandation
where
  Avis_URL_id in (
    SELECT
      id
    from
      avis
    where
      Domaine_id_id = '5'
  )

SELECT COUNT(*) as count FROM recommandation where  Avis_URL_id in (SELECT id from avis where Domaine_id_id='5');

SELECT
  COUNT(DISTINCT commission) AS count
FROM
  avis
where
  domaine_id_id = '5'

SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='5';

SELECT
  COUNT(*) as count
FROM
  avis
where
  domaine_id_id = '5'

SELECT COUNT(*) as count FROM avis where domaine_id_id='5';

SELECT
  COUNT(*) as count
FROM
  recommandation
where
  Avis_URL_id in (
    SELECT
      id
    from
      avis
    where
      Domaine_id_id = '6'
  )

SELECT COUNT(*) as count FROM recommandation where  Avis_URL_id in (SELECT id from avis where Domaine_id_id='6');

SELECT
  COUNT(DISTINCT commission) AS count
FROM
  avis
where
  domaine_id_id = '6'

SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='6';

SELECT
  COUNT(*) as count
FROM
  avis
where
  domaine_id_id = '6'

SELECT COUNT(*) as count FROM avis where domaine_id_id='6';

SELECT
  COUNT(*) as count
FROM
  recommandation
where
  Avis_URL_id in (
    SELECT
      id
    from
      avis
    where
      Domaine_id_id = '7'
  )

SELECT COUNT(*) as count FROM recommandation where  Avis_URL_id in (SELECT id from avis where Domaine_id_id='7');

SELECT
  COUNT(DISTINCT commission) AS count
FROM
  avis
where
  domaine_id_id = '7'

SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='7';

SELECT
  COUNT(*) as count
FROM
  avis
where
  domaine_id_id = '7'

SELECT COUNT(*) as count FROM avis where domaine_id_id='7';

SELECT
  COUNT(*) as count
FROM
  recommandation
where
  Avis_URL_id in (
    SELECT
      id
    from
      avis
    where
      Domaine_id_id = '8'
  )

SELECT COUNT(*) as count FROM recommandation where  Avis_URL_id in (SELECT id from avis where Domaine_id_id='8');

SELECT
  COUNT(DISTINCT commission) AS count
FROM
  avis
where
  domaine_id_id = '8'

SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='8';

SELECT
  COUNT(*) as count
FROM
  avis
where
  domaine_id_id = '8'

SELECT COUNT(*) as count FROM avis where domaine_id_id='8';

SELECT
  COUNT(*) as count
FROM
  recommandation
where
  Avis_URL_id in (
    SELECT
      id
    from
      avis
    where
      Domaine_id_id = '9'
  )

SELECT COUNT(*) as count FROM recommandation where  Avis_URL_id in (SELECT id from avis where Domaine_id_id='9');

SELECT
  COUNT(DISTINCT commission) AS count
FROM
  avis
where
  domaine_id_id = '9'

SELECT COUNT(DISTINCT commission) AS count FROM avis where domaine_id_id='9';

SELECT
  COUNT(*) as count
FROM
  avis
where
  domaine_id_id = '9'

SELECT COUNT(*) as count FROM avis where domaine_id_id='9';

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO log_con (type, date, user_id)
VALUES
  (?, ?, ?)

INSERT INTO log_con (type, date, user_id) VALUES ('Accueil', '2024-09-29 16:31:33', NULL);

"COMMIT"

"COMMIT";