Symfony Profiler

SELECT 
  DISTINCT galerie_id_0 
FROM 
  (
    SELECT 
      g0_.galerie_id AS galerie_id_0, 
      g0_.galerie_title AS galerie_title_1, 
      g0_.galerie_surface AS galerie_surface_2, 
      g0_.galerie_nbrpiece AS galerie_nbrpiece_3, 
      g0_.galerie_description AS galerie_description_4, 
      g0_.galerie_public AS galerie_public_5, 
      g0_.galerie_tags AS galerie_tags_6, 
      g0_.galerie_officialtags AS galerie_officialtags_7, 
      g0_.galerie_date_publication AS galerie_date_publication_8, 
      g0_.galerie_date_update AS galerie_date_update_9, 
      g0_.galerie_plateforme AS galerie_plateforme_10, 
      g0_.galerie_protoversion AS galerie_protoversion_11, 
      g0_.galerie_note AS galerie_note_12, 
      g0_.galerie_votants AS galerie_votants_13, 
      g0_.galerie_vues AS galerie_vues_14, 
      g0_.galerie_projecthd3d AS galerie_projecthd3d_15, 
      g0_.galerie_favorited AS galerie_favorited_16, 
      g0_.galerie_downloads AS galerie_downloads_17, 
      g0_.galerie_contributors AS galerie_contributors_18, 
      g0_.galerie_hasexport3d AS galerie_hasexport3d_19, 
      g0_.galerie_export3d AS galerie_export3d_20, 
      g0_.galerie_valid AS galerie_valid_21 
    FROM 
      galerie g0_ 
    WHERE 
      g0_.galerie_public > 0 
      AND g0_.galerie_valid = 1 
      AND g0_.galerie_id > 1000
  ) dctrn_result 
ORDER BY 
  galerie_favorited_16 DESC 
LIMIT 
  12 OFFSET 1236

SELECT DISTINCT galerie_id_0 FROM (SELECT g0_.galerie_id AS galerie_id_0, g0_.galerie_title AS galerie_title_1, g0_.galerie_surface AS galerie_surface_2, g0_.galerie_nbrpiece AS galerie_nbrpiece_3, g0_.galerie_description AS galerie_description_4, g0_.galerie_public AS galerie_public_5, g0_.galerie_tags AS galerie_tags_6, g0_.galerie_officialtags AS galerie_officialtags_7, g0_.galerie_date_publication AS galerie_date_publication_8, g0_.galerie_date_update AS galerie_date_update_9, g0_.galerie_plateforme AS galerie_plateforme_10, g0_.galerie_protoversion AS galerie_protoversion_11, g0_.galerie_note AS galerie_note_12, g0_.galerie_votants AS galerie_votants_13, g0_.galerie_vues AS galerie_vues_14, g0_.galerie_projecthd3d AS galerie_projecthd3d_15, g0_.galerie_favorited AS galerie_favorited_16, g0_.galerie_downloads AS galerie_downloads_17, g0_.galerie_contributors AS galerie_contributors_18, g0_.galerie_hasexport3d AS galerie_hasexport3d_19, g0_.galerie_export3d AS galerie_export3d_20, g0_.galerie_valid AS galerie_valid_21 FROM galerie g0_ WHERE g0_.galerie_public > 0 AND g0_.galerie_valid = 1 AND g0_.galerie_id > 1000) dctrn_result ORDER BY galerie_favorited_16 DESC LIMIT 12 OFFSET 1236;

SELECT 
  t0.galerie_image_id AS galerie_image_id_1, 
  t0.galerie_image_image AS galerie_image_image_2, 
  t0.galerie_image_thumbnail AS galerie_image_thumbnail_3, 
  t0.galerie_image_guid AS galerie_image_guid_4, 
  t0.galerie_image_position AS galerie_image_position_5, 
  t0.galerie_image_weight AS galerie_image_weight_6, 
  t0.galerie_image_valid_admin AS galerie_image_valid_admin_7, 
  t0.galerie_image_idprojet AS galerie_image_idprojet_8 
FROM 
  galerie_image t0 
WHERE 
  t0.galerie_image_idprojet = ? 
ORDER BY 
  t0.galerie_image_weight DESC, 
  t0.galerie_image_position ASC

SELECT t0.galerie_image_id AS galerie_image_id_1, t0.galerie_image_image AS galerie_image_image_2, t0.galerie_image_thumbnail AS galerie_image_thumbnail_3, t0.galerie_image_guid AS galerie_image_guid_4, t0.galerie_image_position AS galerie_image_position_5, t0.galerie_image_weight AS galerie_image_weight_6, t0.galerie_image_valid_admin AS galerie_image_valid_admin_7, t0.galerie_image_idprojet AS galerie_image_idprojet_8 FROM galerie_image t0 WHERE t0.galerie_image_idprojet = 100885 ORDER BY t0.galerie_image_weight DESC, t0.galerie_image_position ASC;

SELECT 
  t0.galerie_meta_id AS galerie_meta_id_1, 
  t0.galerie_meta_nbr_floors AS galerie_meta_nbr_floors_2, 
  t0.galerie_meta_surface_ext AS galerie_meta_surface_ext_3, 
  t0.galerie_meta_nbr_furnitures AS galerie_meta_nbr_furnitures_4, 
  t0.galerie_meta_nbr_furniture_types AS galerie_meta_nbr_furniture_types_5, 
  t0.galerie_meta_nbr_windows AS galerie_meta_nbr_windows_6, 
  t0.galerie_meta_nbr_doors AS galerie_meta_nbr_doors_7, 
  t0.galerie_meta_nbr_stairs AS galerie_meta_nbr_stairs_8, 
  t0.galerie_meta_nbr_openings AS galerie_meta_nbr_openings_9, 
  t0.galerie_meta_playtime_seconds AS galerie_meta_playtime_seconds_10, 
  t0.galerie_meta_idprojet AS galerie_meta_idprojet_11 
FROM 
  galerie_meta_version4 t0 
WHERE 
  t0.galerie_meta_idprojet = ?

SELECT t0.galerie_meta_id AS galerie_meta_id_1, t0.galerie_meta_nbr_floors AS galerie_meta_nbr_floors_2, t0.galerie_meta_surface_ext AS galerie_meta_surface_ext_3, t0.galerie_meta_nbr_furnitures AS galerie_meta_nbr_furnitures_4, t0.galerie_meta_nbr_furniture_types AS galerie_meta_nbr_furniture_types_5, t0.galerie_meta_nbr_windows AS galerie_meta_nbr_windows_6, t0.galerie_meta_nbr_doors AS galerie_meta_nbr_doors_7, t0.galerie_meta_nbr_stairs AS galerie_meta_nbr_stairs_8, t0.galerie_meta_nbr_openings AS galerie_meta_nbr_openings_9, t0.galerie_meta_playtime_seconds AS galerie_meta_playtime_seconds_10, t0.galerie_meta_idprojet AS galerie_meta_idprojet_11 FROM galerie_meta_version4 t0 WHERE t0.galerie_meta_idprojet = 101853;

SELECT 
  t0.membre_id AS membre_id_1, 
  t0.membre_identifiant AS membre_identifiant_2, 
  t0.membre_civ AS membre_civ_3, 
  t0.membre_pays AS membre_pays_4, 
  t0.membre_naissance AS membre_naissance_5, 
  t0.membre_inscription AS membre_inscription_6, 
  t0.membre_email AS membre_email_7, 
  t0.membre_nom AS membre_nom_8, 
  t0.membre_prenom AS membre_prenom_9, 
  t0.membre_pass AS membre_pass_10, 
  t0.membre_passcrypte AS membre_passcrypte_11, 
  t0.membre_connexion AS membre_connexion_12, 
  t0.membre_last_connexion AS membre_last_connexion_13, 
  t0.membre_actif AS membre_actif_14, 
  t0.membre_appli_lang AS membre_appli_lang_15, 
  t0.membre_facebook_id AS membre_facebook_id_16, 
  t0.membre_apple_signin_subject AS membre_apple_signin_subject_17, 
  t0.membre_activite_id AS membre_activite_id_18 
FROM 
  membre t0 
WHERE 
  t0.membre_id = ?

SELECT t0.membre_id AS membre_id_1, t0.membre_identifiant AS membre_identifiant_2, t0.membre_civ AS membre_civ_3, t0.membre_pays AS membre_pays_4, t0.membre_naissance AS membre_naissance_5, t0.membre_inscription AS membre_inscription_6, t0.membre_email AS membre_email_7, t0.membre_nom AS membre_nom_8, t0.membre_prenom AS membre_prenom_9, t0.membre_pass AS membre_pass_10, t0.membre_passcrypte AS membre_passcrypte_11, t0.membre_connexion AS membre_connexion_12, t0.membre_last_connexion AS membre_last_connexion_13, t0.membre_actif AS membre_actif_14, t0.membre_appli_lang AS membre_appli_lang_15, t0.membre_facebook_id AS membre_facebook_id_16, t0.membre_apple_signin_subject AS membre_apple_signin_subject_17, t0.membre_activite_id AS membre_activite_id_18 FROM membre t0 WHERE t0.membre_id = 206215;

SELECT 
  g0_.galerie_id AS galerie_id_0, 
  g0_.galerie_title AS galerie_title_1, 
  g0_.galerie_surface AS galerie_surface_2, 
  g0_.galerie_nbrpiece AS galerie_nbrpiece_3, 
  g0_.galerie_description AS galerie_description_4, 
  g0_.galerie_public AS galerie_public_5, 
  g0_.galerie_tags AS galerie_tags_6, 
  g0_.galerie_officialtags AS galerie_officialtags_7, 
  g0_.galerie_date_publication AS galerie_date_publication_8, 
  g0_.galerie_date_update AS galerie_date_update_9, 
  g0_.galerie_plateforme AS galerie_plateforme_10, 
  g0_.galerie_protoversion AS galerie_protoversion_11, 
  g0_.galerie_note AS galerie_note_12, 
  g0_.galerie_votants AS galerie_votants_13, 
  g0_.galerie_vues AS galerie_vues_14, 
  g0_.galerie_projecthd3d AS galerie_projecthd3d_15, 
  g0_.galerie_favorited AS galerie_favorited_16, 
  g0_.galerie_downloads AS galerie_downloads_17, 
  g0_.galerie_contributors AS galerie_contributors_18, 
  g0_.galerie_hasexport3d AS galerie_hasexport3d_19, 
  g0_.galerie_export3d AS galerie_export3d_20, 
  g0_.galerie_valid AS galerie_valid_21, 
  g0_.galerie_iduser AS galerie_iduser_22, 
  g0_.galerie_idogproject AS galerie_idogproject_23, 
  g0_.galerie_idcreator AS galerie_idcreator_24, 
  g0_.galerie_categorie AS galerie_categorie_25 
FROM 
  galerie g0_ 
WHERE 
  g0_.galerie_public > 0 
  AND g0_.galerie_valid = 1 
  AND g0_.galerie_id > 1000 
  AND g0_.galerie_id IN (?) 
ORDER BY 
  g0_.galerie_favorited DESC

SELECT g0_.galerie_id AS galerie_id_0, g0_.galerie_title AS galerie_title_1, g0_.galerie_surface AS galerie_surface_2, g0_.galerie_nbrpiece AS galerie_nbrpiece_3, g0_.galerie_description AS galerie_description_4, g0_.galerie_public AS galerie_public_5, g0_.galerie_tags AS galerie_tags_6, g0_.galerie_officialtags AS galerie_officialtags_7, g0_.galerie_date_publication AS galerie_date_publication_8, g0_.galerie_date_update AS galerie_date_update_9, g0_.galerie_plateforme AS galerie_plateforme_10, g0_.galerie_protoversion AS galerie_protoversion_11, g0_.galerie_note AS galerie_note_12, g0_.galerie_votants AS galerie_votants_13, g0_.galerie_vues AS galerie_vues_14, g0_.galerie_projecthd3d AS galerie_projecthd3d_15, g0_.galerie_favorited AS galerie_favorited_16, g0_.galerie_downloads AS galerie_downloads_17, g0_.galerie_contributors AS galerie_contributors_18, g0_.galerie_hasexport3d AS galerie_hasexport3d_19, g0_.galerie_export3d AS galerie_export3d_20, g0_.galerie_valid AS galerie_valid_21, g0_.galerie_iduser AS galerie_iduser_22, g0_.galerie_idogproject AS galerie_idogproject_23, g0_.galerie_idcreator AS galerie_idcreator_24, g0_.galerie_categorie AS galerie_categorie_25 FROM galerie g0_ WHERE g0_.galerie_public > 0 AND g0_.galerie_valid = 1 AND g0_.galerie_id > 1000 AND g0_.galerie_id IN (101853, 101706, 101710, 101712, 101717, 101718, 101720, 101727, 101728, 101730, 101733, 101735) ORDER BY g0_.galerie_favorited DESC;

SELECT 
  g0_.galerie_mea_id AS galerie_mea_id_0, 
  g0_.galerie_mea_title AS galerie_mea_title_1, 
  g0_.galerie_mea_description AS galerie_mea_description_2, 
  g0_.galerie_mea_active AS galerie_mea_active_3, 
  g0_.galerie_mea_event_start AS galerie_mea_event_start_4, 
  g0_.galerie_mea_event_end AS galerie_mea_event_end_5, 
  g0_.galerie_mea_tags AS galerie_mea_tags_6, 
  g0_.galerie_mea_users AS galerie_mea_users_7, 
  g0_.galerie_mea_projects AS galerie_mea_projects_8 
FROM 
  galerie_mea g0_ 
WHERE 
  g0_.galerie_mea_active = 1 
  AND g0_.galerie_mea_event_start <= ? 
  AND g0_.galerie_mea_event_end >= ? 
ORDER BY 
  g0_.galerie_mea_event_end ASC 
LIMIT 
  1

SELECT g0_.galerie_mea_id AS galerie_mea_id_0, g0_.galerie_mea_title AS galerie_mea_title_1, g0_.galerie_mea_description AS galerie_mea_description_2, g0_.galerie_mea_active AS galerie_mea_active_3, g0_.galerie_mea_event_start AS galerie_mea_event_start_4, g0_.galerie_mea_event_end AS galerie_mea_event_end_5, g0_.galerie_mea_tags AS galerie_mea_tags_6, g0_.galerie_mea_users AS galerie_mea_users_7, g0_.galerie_mea_projects AS galerie_mea_projects_8 FROM galerie_mea g0_ WHERE g0_.galerie_mea_active = 1 AND g0_.galerie_mea_event_start <= '2025-05-05 04:43:47' AND g0_.galerie_mea_event_end >= '2025-05-05 04:43:47' ORDER BY g0_.galerie_mea_event_end ASC LIMIT 1;

SELECT 
  COUNT(*) AS dctrn_count 
FROM 
  (
    SELECT 
      DISTINCT galerie_id_0 
    FROM 
      (
        SELECT 
          g0_.galerie_id AS galerie_id_0, 
          g0_.galerie_title AS galerie_title_1, 
          g0_.galerie_surface AS galerie_surface_2, 
          g0_.galerie_nbrpiece AS galerie_nbrpiece_3, 
          g0_.galerie_description AS galerie_description_4, 
          g0_.galerie_public AS galerie_public_5, 
          g0_.galerie_tags AS galerie_tags_6, 
          g0_.galerie_officialtags AS galerie_officialtags_7, 
          g0_.galerie_date_publication AS galerie_date_publication_8, 
          g0_.galerie_date_update AS galerie_date_update_9, 
          g0_.galerie_plateforme AS galerie_plateforme_10, 
          g0_.galerie_protoversion AS galerie_protoversion_11, 
          g0_.galerie_note AS galerie_note_12, 
          g0_.galerie_votants AS galerie_votants_13, 
          g0_.galerie_vues AS galerie_vues_14, 
          g0_.galerie_projecthd3d AS galerie_projecthd3d_15, 
          g0_.galerie_favorited AS galerie_favorited_16, 
          g0_.galerie_downloads AS galerie_downloads_17, 
          g0_.galerie_contributors AS galerie_contributors_18, 
          g0_.galerie_hasexport3d AS galerie_hasexport3d_19, 
          g0_.galerie_export3d AS galerie_export3d_20, 
          g0_.galerie_valid AS galerie_valid_21 
        FROM 
          galerie g0_ 
        WHERE 
          g0_.galerie_public > 0 
          AND g0_.galerie_valid = 1 
          AND g0_.galerie_id > 1000 
        ORDER BY 
          g0_.galerie_favorited DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT galerie_id_0 FROM (SELECT g0_.galerie_id AS galerie_id_0, g0_.galerie_title AS galerie_title_1, g0_.galerie_surface AS galerie_surface_2, g0_.galerie_nbrpiece AS galerie_nbrpiece_3, g0_.galerie_description AS galerie_description_4, g0_.galerie_public AS galerie_public_5, g0_.galerie_tags AS galerie_tags_6, g0_.galerie_officialtags AS galerie_officialtags_7, g0_.galerie_date_publication AS galerie_date_publication_8, g0_.galerie_date_update AS galerie_date_update_9, g0_.galerie_plateforme AS galerie_plateforme_10, g0_.galerie_protoversion AS galerie_protoversion_11, g0_.galerie_note AS galerie_note_12, g0_.galerie_votants AS galerie_votants_13, g0_.galerie_vues AS galerie_vues_14, g0_.galerie_projecthd3d AS galerie_projecthd3d_15, g0_.galerie_favorited AS galerie_favorited_16, g0_.galerie_downloads AS galerie_downloads_17, g0_.galerie_contributors AS galerie_contributors_18, g0_.galerie_hasexport3d AS galerie_hasexport3d_19, g0_.galerie_export3d AS galerie_export3d_20, g0_.galerie_valid AS galerie_valid_21 FROM galerie g0_ WHERE g0_.galerie_public > 0 AND g0_.galerie_valid = 1 AND g0_.galerie_id > 1000 ORDER BY g0_.galerie_favorited DESC) dctrn_result) dctrn_table;

SELECT 
  g0_.galerie_id AS galerie_id_0, 
  g0_.galerie_title AS galerie_title_1, 
  g0_.galerie_surface AS galerie_surface_2, 
  g0_.galerie_nbrpiece AS galerie_nbrpiece_3, 
  g0_.galerie_description AS galerie_description_4, 
  g0_.galerie_public AS galerie_public_5, 
  g0_.galerie_tags AS galerie_tags_6, 
  g0_.galerie_officialtags AS galerie_officialtags_7, 
  g0_.galerie_date_publication AS galerie_date_publication_8, 
  g0_.galerie_date_update AS galerie_date_update_9, 
  g0_.galerie_plateforme AS galerie_plateforme_10, 
  g0_.galerie_protoversion AS galerie_protoversion_11, 
  g0_.galerie_note AS galerie_note_12, 
  g0_.galerie_votants AS galerie_votants_13, 
  g0_.galerie_vues AS galerie_vues_14, 
  g0_.galerie_projecthd3d AS galerie_projecthd3d_15, 
  g0_.galerie_favorited AS galerie_favorited_16, 
  g0_.galerie_downloads AS galerie_downloads_17, 
  g0_.galerie_contributors AS galerie_contributors_18, 
  g0_.galerie_hasexport3d AS galerie_hasexport3d_19, 
  g0_.galerie_export3d AS galerie_export3d_20, 
  g0_.galerie_valid AS galerie_valid_21, 
  g0_.galerie_iduser AS galerie_iduser_22, 
  g0_.galerie_idogproject AS galerie_idogproject_23, 
  g0_.galerie_idcreator AS galerie_idcreator_24, 
  g0_.galerie_categorie AS galerie_categorie_25 
FROM 
  galerie g0_ 
WHERE 
  g0_.galerie_public > 0 
  AND g0_.galerie_valid = 1 
  AND g0_.galerie_id > 1000 
  AND g0_.galerie_officialtags <> '' 
ORDER BY 
  g0_.galerie_date_publication DESC

SELECT g0_.galerie_id AS galerie_id_0, g0_.galerie_title AS galerie_title_1, g0_.galerie_surface AS galerie_surface_2, g0_.galerie_nbrpiece AS galerie_nbrpiece_3, g0_.galerie_description AS galerie_description_4, g0_.galerie_public AS galerie_public_5, g0_.galerie_tags AS galerie_tags_6, g0_.galerie_officialtags AS galerie_officialtags_7, g0_.galerie_date_publication AS galerie_date_publication_8, g0_.galerie_date_update AS galerie_date_update_9, g0_.galerie_plateforme AS galerie_plateforme_10, g0_.galerie_protoversion AS galerie_protoversion_11, g0_.galerie_note AS galerie_note_12, g0_.galerie_votants AS galerie_votants_13, g0_.galerie_vues AS galerie_vues_14, g0_.galerie_projecthd3d AS galerie_projecthd3d_15, g0_.galerie_favorited AS galerie_favorited_16, g0_.galerie_downloads AS galerie_downloads_17, g0_.galerie_contributors AS galerie_contributors_18, g0_.galerie_hasexport3d AS galerie_hasexport3d_19, g0_.galerie_export3d AS galerie_export3d_20, g0_.galerie_valid AS galerie_valid_21, g0_.galerie_iduser AS galerie_iduser_22, g0_.galerie_idogproject AS galerie_idogproject_23, g0_.galerie_idcreator AS galerie_idcreator_24, g0_.galerie_categorie AS galerie_categorie_25 FROM galerie g0_ WHERE g0_.galerie_public > 0 AND g0_.galerie_valid = 1 AND g0_.galerie_id > 1000 AND g0_.galerie_officialtags <> '' ORDER BY g0_.galerie_date_publication DESC;