Symfony Profiler

SELECT
  m0_.quantitenature AS quantitenature_0,
  m0_.date_arc AS date_arc_1,
  m0_.commentaire AS commentaire_2,
  m0_.collisage AS collisage_3,
  m0_.tempsalloue AS tempsalloue_4,
  m0_.delaifournisseur AS delaifournisseur_5,
  m0_.quantitearticle AS quantitearticle_6,
  m0_.demandestatus AS demandestatus_7,
  m0_.early AS early_8,
  m0_.num_arc AS num_arc_9,
  m0_.id AS id_10,
  m0_.created_at AS created_at_11,
  m0_.updated_at AS updated_at_12,
  c1_.numchantier AS numchantier_13,
  c1_.infos_app AS infos_app_14,
  c1_.jours_homme AS jours_homme_15,
  c1_.infos_prepa AS infos_prepa_16,
  c1_.observation AS observation_17,
  c1_.deleted AS deleted_18,
  c1_.adresse AS adresse_19,
  c1_.ville AS ville_20,
  c1_.codepostal AS codepostal_21,
  c1_.gps AS gps_22,
  c1_.drive AS drive_23,
  c1_.access_code AS access_code_24,
  c1_.id AS id_25,
  c1_.created_at AS created_at_26,
  c1_.updated_at AS updated_at_27,
  r2_.id AS id_28,
  r2_.daterv AS daterv_29,
  r2_.com AS com_30,
  r2_.duree AS duree_31,
  r2_.address AS address_32,
  r2_.cp AS cp_33,
  r2_.town AS town_34,
  r2_.libre AS libre_35,
  r2_.tempseffectif AS tempseffectif_36,
  r2_.datevoulueclientde AS datevoulueclientde_37,
  r2_.datevoulueclienta AS datevoulueclienta_38,
  r2_.precisionsvouluesclient AS precisionsvouluesclient_39,
  r2_.dispos AS dispos_40,
  r2_.tempsfacture AS tempsfacture_41,
  r2_.statusrv AS statusrv_42,
  r2_.label AS label_43,
  r2_.gps AS gps_44,
  r2_.drive AS drive_45,
  r2_.nb_intervenants AS nb_intervenants_46,
  r2_.nb_intervenants_mandatory AS nb_intervenants_mandatory_47,
  r2_.datervfin AS datervfin_48,
  r2_.allday AS allday_49,
  r2_.sum_rafs AS sum_rafs_50,
  r2_.date_validated_with_client AS date_validated_with_client_51,
  r2_.modified_by_solver AS modified_by_solver_52,
  r2_.date_proposed_to_client AS date_proposed_to_client_53,
  r2_.updated_at AS updated_at_54,
  r2_.created_at AS created_at_55,
  t3_.nom AS nom_56,
  t3_.id AS id_57,
  t3_.created_at AS created_at_58,
  t3_.updated_at AS updated_at_59,
  c4_.fullname AS fullname_60,
  c4_.telfixe AS telfixe_61,
  c4_.telmobile AS telmobile_62,
  c4_.email AS email_63,
  c4_.deleted AS deleted_64,
  c4_.id AS id_65,
  c4_.created_at AS created_at_66,
  c4_.updated_at AS updated_at_67,
  s5_.nom AS nom_68,
  s5_.color AS color_69,
  s5_.css_class AS css_class_70,
  s5_.place AS place_71,
  s5_.typemarchandise AS typemarchandise_72,
  s5_.id AS id_73,
  s5_.created_at AS created_at_74,
  s5_.updated_at AS updated_at_75,
  f6_.nom AS nom_76,
  f6_.delaifournisseur AS delaifournisseur_77,
  f6_.id AS id_78,
  f6_.created_at AS created_at_79,
  f6_.updated_at AS updated_at_80,
  a7_.label AS label_81,
  a7_.stock AS stock_82,
  a7_.id AS id_83,
  a7_.created_at AS created_at_84,
  a7_.updated_at AS updated_at_85,
  m8_.name AS name_86,
  m8_.id AS id_87,
  m8_.created_at AS created_at_88,
  m8_.updated_at AS updated_at_89,
  s9_.nom AS nom_90,
  s9_.description AS description_91,
  s9_.id AS id_92,
  s9_.created_at AS created_at_93,
  s9_.updated_at AS updated_at_94,
  c10_.id AS id_95,
  c10_.label AS label_96,
  m0_.chantier_id AS chantier_id_97,
  m0_.statusmarchandise_id AS statusmarchandise_id_98,
  m0_.fournisseur_id AS fournisseur_id_99,
  m0_.article_id AS article_id_100,
  m0_.statemarchandise_id AS statemarchandise_id_101,
  m0_.segmentationmarchandise_id AS segmentationmarchandise_id_102,
  m0_.control_id AS control_id_103,
  c1_.client_id AS client_id_104,
  c1_.segmentationchantier_id AS segmentationchantier_id_105,
  c1_.modereglement_id AS modereglement_id_106,
  c1_.user_id AS user_id_107,
  c1_.tech_id AS tech_id_108,
  r2_.chantier_id AS chantier_id_109,
  r2_.lieu_id AS lieu_id_110,
  r2_.typeintervention_id AS typeintervention_id_111,
  r2_.control_id AS control_id_112,
  r2_.access_ask_id AS access_ask_id_113,
  r2_.criticity_id AS criticity_id_114,
  r2_.meteo_id AS meteo_id_115,
  r2_.parking_id AS parking_id_116,
  r2_.last_user_modified_id AS last_user_modified_id_117,
  a7_.category_id AS category_id_118
FROM
  marchandise m0_
  INNER JOIN chantier c1_ ON m0_.chantier_id = c1_.id
  LEFT JOIN marchandise_rvintervention m11_ ON m0_.id = m11_.marchandise_id
  LEFT JOIN rvintervention r2_ ON r2_.id = m11_.rvintervention_id
  LEFT JOIN typeintervention t3_ ON r2_.typeintervention_id = t3_.id
  LEFT JOIN client c4_ ON c1_.client_id = c4_.id
  LEFT JOIN statusmarchandise s5_ ON m0_.statusmarchandise_id = s5_.id
  LEFT JOIN fournisseur f6_ ON m0_.fournisseur_id = f6_.id
  LEFT JOIN article a7_ ON m0_.article_id = a7_.id
  LEFT JOIN marchandise_state m8_ ON m0_.statemarchandise_id = m8_.id
  LEFT JOIN segmentationchantier s9_ ON m0_.segmentationmarchandise_id = s9_.id
  LEFT JOIN control c10_ ON m0_.control_id = c10_.id
WHERE
  m0_.id IN (
    SELECT
      m12_.id
    FROM
      marchandise m12_
      INNER JOIN chantier c13_ ON m12_.chantier_id = c13_.id
    WHERE
      c13_.id = ?
  )
ORDER BY
  m0_.id ASC

SELECT m0_.quantitenature AS quantitenature_0, m0_.date_arc AS date_arc_1, m0_.commentaire AS commentaire_2, m0_.collisage AS collisage_3, m0_.tempsalloue AS tempsalloue_4, m0_.delaifournisseur AS delaifournisseur_5, m0_.quantitearticle AS quantitearticle_6, m0_.demandestatus AS demandestatus_7, m0_.early AS early_8, m0_.num_arc AS num_arc_9, m0_.id AS id_10, m0_.created_at AS created_at_11, m0_.updated_at AS updated_at_12, c1_.numchantier AS numchantier_13, c1_.infos_app AS infos_app_14, c1_.jours_homme AS jours_homme_15, c1_.infos_prepa AS infos_prepa_16, c1_.observation AS observation_17, c1_.deleted AS deleted_18, c1_.adresse AS adresse_19, c1_.ville AS ville_20, c1_.codepostal AS codepostal_21, c1_.gps AS gps_22, c1_.drive AS drive_23, c1_.access_code AS access_code_24, c1_.id AS id_25, c1_.created_at AS created_at_26, c1_.updated_at AS updated_at_27, r2_.id AS id_28, r2_.daterv AS daterv_29, r2_.com AS com_30, r2_.duree AS duree_31, r2_.address AS address_32, r2_.cp AS cp_33, r2_.town AS town_34, r2_.libre AS libre_35, r2_.tempseffectif AS tempseffectif_36, r2_.datevoulueclientde AS datevoulueclientde_37, r2_.datevoulueclienta AS datevoulueclienta_38, r2_.precisionsvouluesclient AS precisionsvouluesclient_39, r2_.dispos AS dispos_40, r2_.tempsfacture AS tempsfacture_41, r2_.statusrv AS statusrv_42, r2_.label AS label_43, r2_.gps AS gps_44, r2_.drive AS drive_45, r2_.nb_intervenants AS nb_intervenants_46, r2_.nb_intervenants_mandatory AS nb_intervenants_mandatory_47, r2_.datervfin AS datervfin_48, r2_.allday AS allday_49, r2_.sum_rafs AS sum_rafs_50, r2_.date_validated_with_client AS date_validated_with_client_51, r2_.modified_by_solver AS modified_by_solver_52, r2_.date_proposed_to_client AS date_proposed_to_client_53, r2_.updated_at AS updated_at_54, r2_.created_at AS created_at_55, t3_.nom AS nom_56, t3_.id AS id_57, t3_.created_at AS created_at_58, t3_.updated_at AS updated_at_59, c4_.fullname AS fullname_60, c4_.telfixe AS telfixe_61, c4_.telmobile AS telmobile_62, c4_.email AS email_63, c4_.deleted AS deleted_64, c4_.id AS id_65, c4_.created_at AS created_at_66, c4_.updated_at AS updated_at_67, s5_.nom AS nom_68, s5_.color AS color_69, s5_.css_class AS css_class_70, s5_.place AS place_71, s5_.typemarchandise AS typemarchandise_72, s5_.id AS id_73, s5_.created_at AS created_at_74, s5_.updated_at AS updated_at_75, f6_.nom AS nom_76, f6_.delaifournisseur AS delaifournisseur_77, f6_.id AS id_78, f6_.created_at AS created_at_79, f6_.updated_at AS updated_at_80, a7_.label AS label_81, a7_.stock AS stock_82, a7_.id AS id_83, a7_.created_at AS created_at_84, a7_.updated_at AS updated_at_85, m8_.name AS name_86, m8_.id AS id_87, m8_.created_at AS created_at_88, m8_.updated_at AS updated_at_89, s9_.nom AS nom_90, s9_.description AS description_91, s9_.id AS id_92, s9_.created_at AS created_at_93, s9_.updated_at AS updated_at_94, c10_.id AS id_95, c10_.label AS label_96, m0_.chantier_id AS chantier_id_97, m0_.statusmarchandise_id AS statusmarchandise_id_98, m0_.fournisseur_id AS fournisseur_id_99, m0_.article_id AS article_id_100, m0_.statemarchandise_id AS statemarchandise_id_101, m0_.segmentationmarchandise_id AS segmentationmarchandise_id_102, m0_.control_id AS control_id_103, c1_.client_id AS client_id_104, c1_.segmentationchantier_id AS segmentationchantier_id_105, c1_.modereglement_id AS modereglement_id_106, c1_.user_id AS user_id_107, c1_.tech_id AS tech_id_108, r2_.chantier_id AS chantier_id_109, r2_.lieu_id AS lieu_id_110, r2_.typeintervention_id AS typeintervention_id_111, r2_.control_id AS control_id_112, r2_.access_ask_id AS access_ask_id_113, r2_.criticity_id AS criticity_id_114, r2_.meteo_id AS meteo_id_115, r2_.parking_id AS parking_id_116, r2_.last_user_modified_id AS last_user_modified_id_117, a7_.category_id AS category_id_118 FROM marchandise m0_ INNER JOIN chantier c1_ ON m0_.chantier_id = c1_.id LEFT JOIN marchandise_rvintervention m11_ ON m0_.id = m11_.marchandise_id LEFT JOIN rvintervention r2_ ON r2_.id = m11_.rvintervention_id LEFT JOIN typeintervention t3_ ON r2_.typeintervention_id = t3_.id LEFT JOIN client c4_ ON c1_.client_id = c4_.id LEFT JOIN statusmarchandise s5_ ON m0_.statusmarchandise_id = s5_.id LEFT JOIN fournisseur f6_ ON m0_.fournisseur_id = f6_.id LEFT JOIN article a7_ ON m0_.article_id = a7_.id LEFT JOIN marchandise_state m8_ ON m0_.statemarchandise_id = m8_.id LEFT JOIN segmentationchantier s9_ ON m0_.segmentationmarchandise_id = s9_.id LEFT JOIN control c10_ ON m0_.control_id = c10_.id WHERE m0_.id IN (SELECT m12_.id FROM marchandise m12_ INNER JOIN chantier c13_ ON m12_.chantier_id = c13_.id WHERE c13_.id = '3556') ORDER BY m0_.id ASC;