Symfony Profiler

SELECT
  *
FROM
  fusacq_dbo.buzz_actualites
WHERE
  id_actualite = ?
  AND mode_actualite != ?
LIMIT
  1

SELECT * FROM fusacq_dbo.buzz_actualites WHERE id_actualite = 209110 AND mode_actualite != 'supprime' LIMIT 1;

SELECT
  b0_.id_operation AS id_operation_0
FROM
  fusacq_dbo.buzz_actualites b0_
WHERE
  b0_.id_actualite = ?
LIMIT
  1

SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = 209110 LIMIT 1;

SELECT
  b0_.id_operation AS id_operation_0
FROM
  fusacq_dbo.buzz_operations b0_
WHERE
  b0_.id_actualite_principale = ?
LIMIT
  1

SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_actualite_principale = 209110 LIMIT 1;

SELECT
  sa.image_filename
FROM
  fusacq_dbo.buzz_actualites ba
  LEFT JOIN fusacq_dbo.buzz_operations bo ON ba.id_operation = bo.id_operation
  LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
WHERE
  ba.id_actualite = ?
  AND ba.id_operation IS NOT NULL
  AND sa.image_filename IS NOT NULL
  AND sa.image_filename != ""
LIMIT
  1

SELECT sa.image_filename 
                FROM fusacq_dbo.buzz_actualites ba
                LEFT JOIN fusacq_dbo.buzz_operations bo ON ba.id_operation = bo.id_operation
                LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
                WHERE ba.id_actualite = 209110
                AND ba.id_operation IS NOT NULL
                AND sa.image_filename IS NOT NULL 
                AND sa.image_filename != ""
                LIMIT 1
            ;

SELECT
  sa.image_filename
FROM
  fusacq_dbo.buzz_actualites ba
  LEFT JOIN fusacq_dbo.buzz_operations bo ON ba.id_actualite = bo.id_actualite_principale
  LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
WHERE
  ba.id_actualite = ?
  AND sa.image_filename IS NOT NULL
  AND sa.image_filename != ""
LIMIT
  1

SELECT sa.image_filename 
                FROM fusacq_dbo.buzz_actualites ba
                LEFT JOIN fusacq_dbo.buzz_operations bo ON ba.id_actualite = bo.id_actualite_principale
                LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
                WHERE ba.id_actualite = 209110
                AND sa.image_filename IS NOT NULL 
                AND sa.image_filename != ""
                LIMIT 1
            ;

SELECT
  provenance_flux_actualite,
  visibilite_flux
FROM
  fusacq_dbo.buzz_actualites
WHERE
  id_actualite = ?
LIMIT
  1

SELECT provenance_flux_actualite, visibilite_flux FROM fusacq_dbo.buzz_actualites WHERE id_actualite = 209110 LIMIT 1;

SELECT
  b0_.id_operation AS id_operation_0,
  b0_.provenance_flux_actualite AS provenance_flux_actualite_1,
  b0_.visibilite_flux AS visibilite_flux_2
FROM
  fusacq_dbo.buzz_actualites b0_
WHERE
  b0_.id_actualite = ?
LIMIT
  1

SELECT b0_.id_operation AS id_operation_0, b0_.provenance_flux_actualite AS provenance_flux_actualite_1, b0_.visibilite_flux AS visibilite_flux_2 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = 209110 LIMIT 1;

SELECT
  b0_.id_secteur_activite AS id_secteur_activite_0
FROM
  fusacq_dbo.buzz_operations b0_
WHERE
  b0_.id_actualite_principale = ?
  AND b0_.id_secteur_activite IS NOT NULL
LIMIT
  1

SELECT b0_.id_secteur_activite AS id_secteur_activite_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_actualite_principale = 209110 AND b0_.id_secteur_activite IS NOT NULL LIMIT 1;

SELECT
  b0_.id_secteur_activite AS id_secteur_activite_0,
  COUNT(b0_.id_operation) AS sclr_1
FROM
  fusacq_dbo.buzz_operations b0_
WHERE
  b0_.id_secteur_activite IS NOT NULL
GROUP BY
  b0_.id_secteur_activite
ORDER BY
  sclr_1 DESC
LIMIT
  1

SELECT b0_.id_secteur_activite AS id_secteur_activite_0, COUNT(b0_.id_operation) AS sclr_1 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_secteur_activite IS NOT NULL GROUP BY b0_.id_secteur_activite ORDER BY sclr_1 DESC LIMIT 1;

SELECT
  *
FROM
  fusacq_dbo.buzz_actualites
WHERE
  id_actualite = ?
  AND mode_actualite != ?
LIMIT
  1

SELECT * FROM fusacq_dbo.buzz_actualites WHERE id_actualite = 209110 AND mode_actualite != 'supprime' LIMIT 1;

SELECT
  b0_.id_operation AS id_operation_0
FROM
  fusacq_dbo.buzz_actualites b0_
WHERE
  b0_.id_actualite = ?
LIMIT
  1

SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = 209110 LIMIT 1;

SELECT
  b0_.id_operation AS id_operation_0
FROM
  fusacq_dbo.buzz_operations b0_
WHERE
  b0_.id_actualite_principale = ?
LIMIT
  1

SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_actualite_principale = 209110 LIMIT 1;

SELECT
  sa.image_filename
FROM
  fusacq_dbo.buzz_actualites ba
  LEFT JOIN fusacq_dbo.buzz_operations bo ON ba.id_operation = bo.id_operation
  LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
WHERE
  ba.id_actualite = ?
  AND ba.id_operation IS NOT NULL
  AND sa.image_filename IS NOT NULL
  AND sa.image_filename != ""
LIMIT
  1

SELECT sa.image_filename 
                FROM fusacq_dbo.buzz_actualites ba
                LEFT JOIN fusacq_dbo.buzz_operations bo ON ba.id_operation = bo.id_operation
                LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
                WHERE ba.id_actualite = 209110
                AND ba.id_operation IS NOT NULL
                AND sa.image_filename IS NOT NULL 
                AND sa.image_filename != ""
                LIMIT 1
            ;

SELECT
  sa.image_filename
FROM
  fusacq_dbo.buzz_actualites ba
  LEFT JOIN fusacq_dbo.buzz_operations bo ON ba.id_actualite = bo.id_actualite_principale
  LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
WHERE
  ba.id_actualite = ?
  AND sa.image_filename IS NOT NULL
  AND sa.image_filename != ""
LIMIT
  1

SELECT sa.image_filename 
                FROM fusacq_dbo.buzz_actualites ba
                LEFT JOIN fusacq_dbo.buzz_operations bo ON ba.id_actualite = bo.id_actualite_principale
                LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
                WHERE ba.id_actualite = 209110
                AND sa.image_filename IS NOT NULL 
                AND sa.image_filename != ""
                LIMIT 1
            ;

SELECT
  *
FROM
  (
    (
      SELECT
        DISTINCT ba.id_actualite,
        ba.date_mise_en_ligne,
        ba.titre_actualite,
        ba.sous_titre,
        ba.provenance_flux_actualite,
        ba.id_message_blog,
        ba.id_societe_prestataire,
        ba.visibilite_flux
      FROM
        fusacq_dbo.buzz_operations bo
        INNER JOIN fusacq_dbo.buzz_actualites ba ON bo.id_actualite_principale = ba.id_actualite
      WHERE
        ba.mode_actualite = 'publique'
        AND (
          (
            ba.provenance_flux_actualite = 'blog'
            AND ba.visibilite_flux LIKE '%collaborative%'
          )
          OR ba.provenance_flux_actualite != 'blog'
        )
        AND bo.id_actualite_principale IS NOT NULL
        AND ba.id_actualite IS NOT NULL
        AND bo.id_secteur_activite = 50205
    )
    UNION
      (
        SELECT
          DISTINCT ba.id_actualite,
          ba.date_mise_en_ligne,
          ba.titre_actualite,
          ba.sous_titre,
          ba.provenance_flux_actualite,
          ba.id_message_blog,
          ba.id_societe_prestataire,
          ba.visibilite_flux
        FROM
          fusacq_dbo.buzz_actualites ba
          INNER JOIN fusacq_dbo.buzz_operations bo ON ba.id_operation = bo.id_operation
        WHERE
          ba.mode_actualite = 'publique'
          AND (
            (
              ba.provenance_flux_actualite = 'blog'
              AND ba.visibilite_flux LIKE '%collaborative%'
            )
            OR ba.provenance_flux_actualite != 'blog'
          )
          AND ba.id_operation IS NOT NULL
          AND bo.id_secteur_activite = 50205
      )
  ) AS combined
WHERE
  id_actualite != 209110
ORDER BY
  date_mise_en_ligne DESC
LIMIT
  5

SELECT * FROM ((
            SELECT DISTINCT
                ba.id_actualite,
                ba.date_mise_en_ligne,
                ba.titre_actualite,
                ba.sous_titre,
                ba.provenance_flux_actualite,
                ba.id_message_blog,
                ba.id_societe_prestataire,
                ba.visibilite_flux
            FROM fusacq_dbo.buzz_operations bo
            INNER JOIN fusacq_dbo.buzz_actualites ba ON bo.id_actualite_principale = ba.id_actualite
            WHERE ba.mode_actualite = 'publique'
            AND (
                (ba.provenance_flux_actualite = 'blog' AND ba.visibilite_flux LIKE '%collaborative%')
                OR ba.provenance_flux_actualite != 'blog'
            )
            AND bo.id_actualite_principale IS NOT NULL
            AND ba.id_actualite IS NOT NULL
            AND bo.id_secteur_activite = 50205
        ) UNION (
            SELECT DISTINCT
                ba.id_actualite,
                ba.date_mise_en_ligne,
                ba.titre_actualite,
                ba.sous_titre,
                ba.provenance_flux_actualite,
                ba.id_message_blog,
                ba.id_societe_prestataire,
                ba.visibilite_flux
            FROM fusacq_dbo.buzz_actualites ba
            INNER JOIN fusacq_dbo.buzz_operations bo ON ba.id_operation = bo.id_operation
            WHERE ba.mode_actualite = 'publique'
            AND (
                (ba.provenance_flux_actualite = 'blog' AND ba.visibilite_flux LIKE '%collaborative%')
                OR ba.provenance_flux_actualite != 'blog'
            )
            AND ba.id_operation IS NOT NULL
            AND bo.id_secteur_activite = 50205
        )) AS combined WHERE id_actualite != 209110 ORDER BY date_mise_en_ligne DESC LIMIT 5;

SELECT
  *
FROM
  fusacq_dbo.buzz_actualites
WHERE
  id_actualite = ?
  AND mode_actualite != ?
LIMIT
  1

SELECT * FROM fusacq_dbo.buzz_actualites WHERE id_actualite = 209110 AND mode_actualite != 'supprime' LIMIT 1;

SELECT
  b0_.id_operation AS id_operation_0
FROM
  fusacq_dbo.buzz_actualites b0_
WHERE
  b0_.id_actualite = ?
LIMIT
  1

SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_actualites b0_ WHERE b0_.id_actualite = 209110 LIMIT 1;

SELECT
  b0_.id_operation AS id_operation_0
FROM
  fusacq_dbo.buzz_operations b0_
WHERE
  b0_.id_actualite_principale = ?
LIMIT
  1

SELECT b0_.id_operation AS id_operation_0 FROM fusacq_dbo.buzz_operations b0_ WHERE b0_.id_actualite_principale = 209110 LIMIT 1;

SELECT
  sa.image_filename
FROM
  fusacq_dbo.buzz_actualites ba
  LEFT JOIN fusacq_dbo.buzz_operations bo ON ba.id_operation = bo.id_operation
  LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
WHERE
  ba.id_actualite = ?
  AND ba.id_operation IS NOT NULL
  AND sa.image_filename IS NOT NULL
  AND sa.image_filename != ""
LIMIT
  1

SELECT sa.image_filename 
                FROM fusacq_dbo.buzz_actualites ba
                LEFT JOIN fusacq_dbo.buzz_operations bo ON ba.id_operation = bo.id_operation
                LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
                WHERE ba.id_actualite = 209110
                AND ba.id_operation IS NOT NULL
                AND sa.image_filename IS NOT NULL 
                AND sa.image_filename != ""
                LIMIT 1
            ;

SELECT
  sa.image_filename
FROM
  fusacq_dbo.buzz_actualites ba
  LEFT JOIN fusacq_dbo.buzz_operations bo ON ba.id_actualite = bo.id_actualite_principale
  LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
WHERE
  ba.id_actualite = ?
  AND sa.image_filename IS NOT NULL
  AND sa.image_filename != ""
LIMIT
  1

SELECT sa.image_filename 
                FROM fusacq_dbo.buzz_actualites ba
                LEFT JOIN fusacq_dbo.buzz_operations bo ON ba.id_actualite = bo.id_actualite_principale
                LEFT JOIN fusacq_dbo.secteurs_activite sa ON bo.id_secteur_activite = sa.id_secteur_activite
                WHERE ba.id_actualite = 209110
                AND sa.image_filename IS NOT NULL 
                AND sa.image_filename != ""
                LIMIT 1
            ;