Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.ref_client AS ref_client_1,
  c0_.date_limite_activation AS date_limite_activation_2,
  c0_.mail AS mail_3,
  c0_.tel_fixe AS tel_fixe_4,
  c0_.mode_reglement AS mode_reglement_5,
  c0_.video AS video_6,
  c0_.is_actif AS is_actif_7,
  c0_.chorus AS chorus_8,
  c0_.societe AS societe_9,
  c0_.observation AS observation_10,
  c0_.message AS message_11,
  c0_.rcs AS rcs_12,
  c0_.tel_portable AS tel_portable_13,
  c0_.has_affichage_ttc AS has_affichage_ttc_14,
  c0_.has_client_export AS has_client_export_15,
  c0_.acompte AS acompte_16,
  c0_.montant_ht_frais_gestion AS montant_ht_frais_gestion_17,
  c0_.is_demo AS is_demo_18,
  c0_.budget_annuel AS budget_annuel_19,
  c0_.dossier_ftp_commande AS dossier_ftp_commande_20,
  c0_.is_brouillon AS is_brouillon_21,
  c0_.restrict_bon_plan_access AS restrict_bon_plan_access_22,
  c0_.restrict_essentiel_access AS restrict_essentiel_access_23,
  c0_.restrict_promotions_access AS restrict_promotions_access_24,
  c0_.restrict_destockage_access AS restrict_destockage_access_25,
  c0_.reactualisation_automatique_prix_client_compte AS reactualisation_automatique_prix_client_compte_26,
  c0_.jours_desactivation_da AS jours_desactivation_da_27,
  c0_.created_at AS created_at_28,
  c0_.is_client_get_orders_in_xml_format AS is_client_get_orders_in_xml_format_29,
  c0_.certibiocide AS certibiocide_30,
  c0_.abonnement AS abonnement_31,
  c0_.joker AS joker_32,
  c1_.id AS id_33,
  c1_.is_actif AS is_actif_34,
  c1_.ordre AS ordre_35,
  c1_.logo AS logo_36,
  c1_.date_modification AS date_modification_37,
  c0_.devise_id AS devise_id_38,
  c0_.site_id AS site_id_39,
  c0_.mode_livaison_id AS mode_livaison_id_40,
  c0_.frais_port_id AS frais_port_id_41,
  c0_.commercial_id AS commercial_id_42,
  c0_.profil_id AS profil_id_43,
  c0_.client_branche_id AS client_branche_id_44,
  c1_.client_id AS client_id_45
FROM
  client c0_
  INNER JOIN client_logo c1_ ON c0_.id = c1_.client_id
WHERE
  c1_.is_actif = 1
  AND c0_.is_actif = 1
ORDER BY
  RAND() ASC
LIMIT
  31

SELECT c0_.id AS id_0, c0_.ref_client AS ref_client_1, c0_.date_limite_activation AS date_limite_activation_2, c0_.mail AS mail_3, c0_.tel_fixe AS tel_fixe_4, c0_.mode_reglement AS mode_reglement_5, c0_.video AS video_6, c0_.is_actif AS is_actif_7, c0_.chorus AS chorus_8, c0_.societe AS societe_9, c0_.observation AS observation_10, c0_.message AS message_11, c0_.rcs AS rcs_12, c0_.tel_portable AS tel_portable_13, c0_.has_affichage_ttc AS has_affichage_ttc_14, c0_.has_client_export AS has_client_export_15, c0_.acompte AS acompte_16, c0_.montant_ht_frais_gestion AS montant_ht_frais_gestion_17, c0_.is_demo AS is_demo_18, c0_.budget_annuel AS budget_annuel_19, c0_.dossier_ftp_commande AS dossier_ftp_commande_20, c0_.is_brouillon AS is_brouillon_21, c0_.restrict_bon_plan_access AS restrict_bon_plan_access_22, c0_.restrict_essentiel_access AS restrict_essentiel_access_23, c0_.restrict_promotions_access AS restrict_promotions_access_24, c0_.restrict_destockage_access AS restrict_destockage_access_25, c0_.reactualisation_automatique_prix_client_compte AS reactualisation_automatique_prix_client_compte_26, c0_.jours_desactivation_da AS jours_desactivation_da_27, c0_.created_at AS created_at_28, c0_.is_client_get_orders_in_xml_format AS is_client_get_orders_in_xml_format_29, c0_.certibiocide AS certibiocide_30, c0_.abonnement AS abonnement_31, c0_.joker AS joker_32, c1_.id AS id_33, c1_.is_actif AS is_actif_34, c1_.ordre AS ordre_35, c1_.logo AS logo_36, c1_.date_modification AS date_modification_37, c0_.devise_id AS devise_id_38, c0_.site_id AS site_id_39, c0_.mode_livaison_id AS mode_livaison_id_40, c0_.frais_port_id AS frais_port_id_41, c0_.commercial_id AS commercial_id_42, c0_.profil_id AS profil_id_43, c0_.client_branche_id AS client_branche_id_44, c1_.client_id AS client_id_45 FROM client c0_ INNER JOIN client_logo c1_ ON c0_.id = c1_.client_id WHERE c1_.is_actif = 1 AND c0_.is_actif = 1 ORDER BY RAND() ASC LIMIT 31;

SELECT
  t0_.id AS id_0,
  t0_.logo AS logo_1,
  t0_.nom AS nom_2,
  t0_.type AS type_3,
  t0_.texte AS texte_4,
  t0_.is_actif AS is_actif_5,
  t0_.is_principal AS is_principal_6,
  t0_.date_modification AS date_modification_7
FROM
  temoignage t0_
WHERE
  t0_.is_principal = ?
  AND t0_.is_actif = ?
ORDER BY
  RAND() ASC
LIMIT
  4

SELECT t0_.id AS id_0, t0_.logo AS logo_1, t0_.nom AS nom_2, t0_.type AS type_3, t0_.texte AS texte_4, t0_.is_actif AS is_actif_5, t0_.is_principal AS is_principal_6, t0_.date_modification AS date_modification_7 FROM temoignage t0_ WHERE t0_.is_principal = 1 AND t0_.is_actif = 1 ORDER BY RAND() ASC LIMIT 4;

SELECT
  m0_.id AS id_0,
  m0_.libelle AS libelle_1,
  m0_.visuel AS visuel_2,
  m0_.is_actif AS is_actif_3,
  m0_.date_modification AS date_modification_4,
  m0_.lien AS lien_5
FROM
  marque m0_
WHERE
  m0_.visuel IS NOT NULL
  AND m0_.is_actif = 1
ORDER BY
  RAND() ASC
LIMIT
  31

SELECT m0_.id AS id_0, m0_.libelle AS libelle_1, m0_.visuel AS visuel_2, m0_.is_actif AS is_actif_3, m0_.date_modification AS date_modification_4, m0_.lien AS lien_5 FROM marque m0_ WHERE m0_.visuel IS NOT NULL AND m0_.is_actif = 1 ORDER BY RAND() ASC LIMIT 31;