Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.emplacement_depart AS emplacement_depart_3,
  t0.emplacement_arrivee AS emplacement_arrivee_4,
  t0.autre_motif AS autre_motif_5,
  t0.commentaire AS commentaire_6,
  t0.code_secret AS code_secret_7,
  t0.valide AS valide_8,
  t0.agence_depart_id AS agence_depart_id_9,
  t0.agence_arrivee_id AS agence_arrivee_id_10,
  t0.type_emplacement_depart_id AS type_emplacement_depart_id_11,
  t0.type_emplacement_arrivee_id AS type_emplacement_arrivee_id_12,
  t0.local_depart_id AS local_depart_id_13,
  t0.nano_reseau_depart_id AS nano_reseau_depart_id_14,
  t0.client_depart_id AS client_depart_id_15,
  t0.user_depart_id AS user_depart_id_16,
  t0.local_arrivee_id AS local_arrivee_id_17,
  t0.nano_reseau_arrivee_id AS nano_reseau_arrivee_id_18,
  t0.client_arrivee_id AS client_arrivee_id_19,
  t0.user_arrivee_id AS user_arrivee_id_20,
  t0.gestionnaire_id AS gestionnaire_id_21,
  t0.motif_mouvement_id AS motif_mouvement_id_22
FROM
  mouvement t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.date AS date_2, t0.emplacement_depart AS emplacement_depart_3, t0.emplacement_arrivee AS emplacement_arrivee_4, t0.autre_motif AS autre_motif_5, t0.commentaire AS commentaire_6, t0.code_secret AS code_secret_7, t0.valide AS valide_8, t0.agence_depart_id AS agence_depart_id_9, t0.agence_arrivee_id AS agence_arrivee_id_10, t0.type_emplacement_depart_id AS type_emplacement_depart_id_11, t0.type_emplacement_arrivee_id AS type_emplacement_arrivee_id_12, t0.local_depart_id AS local_depart_id_13, t0.nano_reseau_depart_id AS nano_reseau_depart_id_14, t0.client_depart_id AS client_depart_id_15, t0.user_depart_id AS user_depart_id_16, t0.local_arrivee_id AS local_arrivee_id_17, t0.nano_reseau_arrivee_id AS nano_reseau_arrivee_id_18, t0.client_arrivee_id AS client_arrivee_id_19, t0.user_arrivee_id AS user_arrivee_id_20, t0.gestionnaire_id AS gestionnaire_id_21, t0.motif_mouvement_id AS motif_mouvement_id_22 FROM mouvement t0 WHERE t0.id = '2';

SELECT
  t0_.id AS id_0,
  t0_.intitule AS intitule_1
FROM
  type_emplacement t0_

SELECT t0_.id AS id_0, t0_.intitule AS intitule_1 FROM type_emplacement t0_;

SELECT
  t0.id AS id_1,
  t0.intitule AS intitule_2
FROM
  motif_mouvement t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.intitule AS intitule_2 FROM motif_mouvement t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.ref AS ref_3,
  t0.adresse AS adresse_4,
  t0.gps AS gps_5,
  t0.localization_lat AS localization_lat_6,
  t0.localization_long AS localization_long_7,
  t0.telephone AS telephone_8
FROM
  agence t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ref AS ref_3, t0.adresse AS adresse_4, t0.gps AS gps_5, t0.localization_lat AS localization_lat_6, t0.localization_long AS localization_long_7, t0.telephone AS telephone_8 FROM agence t0 WHERE t0.id = 12;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.actif AS actif_3,
  t0.agence_id AS agence_id_4
FROM
  local_agence t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.actif AS actif_3, t0.agence_id AS agence_id_4 FROM local_agence t0 WHERE t0.id = 13;

SELECT
  t0.username AS username_1,
  t0.username_canonical AS username_canonical_2,
  t0.email AS email_3,
  t0.email_canonical AS email_canonical_4,
  t0.enabled AS enabled_5,
  t0.salt AS salt_6,
  t0.password AS password_7,
  t0.last_login AS last_login_8,
  t0.confirmation_token AS confirmation_token_9,
  t0.password_requested_at AS password_requested_at_10,
  t0.roles AS roles_11,
  t0.id AS id_12,
  t0.locale AS locale_13,
  t0.firstname AS firstname_14,
  t0.lastname AS lastname_15,
  t0.phone_number AS phone_number_16,
  t0.flotte_phone_number AS flotte_phone_number_17,
  t0.login AS login_18,
  t0.set_avatar AS set_avatar_19,
  t0.is_sync AS is_sync_20,
  t0.date_creation AS date_creation_21,
  t0.active AS active_22,
  t0.enable_offline_mode AS enable_offline_mode_23,
  t0.last_date_synchro_api AS last_date_synchro_api_24,
  t0.registration_token AS registration_token_25,
  t0.data_of_birth AS data_of_birth_26,
  t0.nationality AS nationality_27,
  t0.profile_picture AS profile_picture_28,
  t0.attached_document AS attached_document_29,
  t0.default_entrepreneur AS default_entrepreneur_30,
  t0.investigator_code AS investigator_code_31,
  t0.offline_id_min AS offline_id_min_32,
  t0.offline_id_max AS offline_id_max_33,
  t0.agence_id AS agence_id_34
FROM
  users t0
WHERE
  t0.id = ?

SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.locale AS locale_13, t0.firstname AS firstname_14, t0.lastname AS lastname_15, t0.phone_number AS phone_number_16, t0.flotte_phone_number AS flotte_phone_number_17, t0.login AS login_18, t0.set_avatar AS set_avatar_19, t0.is_sync AS is_sync_20, t0.date_creation AS date_creation_21, t0.active AS active_22, t0.enable_offline_mode AS enable_offline_mode_23, t0.last_date_synchro_api AS last_date_synchro_api_24, t0.registration_token AS registration_token_25, t0.data_of_birth AS data_of_birth_26, t0.nationality AS nationality_27, t0.profile_picture AS profile_picture_28, t0.attached_document AS attached_document_29, t0.default_entrepreneur AS default_entrepreneur_30, t0.investigator_code AS investigator_code_31, t0.offline_id_min AS offline_id_min_32, t0.offline_id_max AS offline_id_max_33, t0.agence_id AS agence_id_34 FROM users t0 WHERE t0.id = 286;

SELECT
  t0.id AS id_1,
  t0.qte AS qte_2,
  t0.identifiants AS identifiants_3,
  t0.modele_id AS modele_id_4,
  t0.mouvement_id AS mouvement_id_5,
  t0.stock_id AS stock_id_6
FROM
  materiel_mouvement t0
WHERE
  t0.mouvement_id = ?

SELECT t0.id AS id_1, t0.qte AS qte_2, t0.identifiants AS identifiants_3, t0.modele_id AS modele_id_4, t0.mouvement_id AS mouvement_id_5, t0.stock_id AS stock_id_6 FROM materiel_mouvement t0 WHERE t0.mouvement_id = 2;

SELECT
  t0.id AS id_1,
  t0.quantite AS quantite_2,
  t0.prix_unitaire AS prix_unitaire_3,
  t0.source AS source_4,
  t0.id_source AS id_source_5,
  t0.date_entree AS date_entree_6,
  t0.identifiant AS identifiant_7,
  t0.transfert_en_cours AS transfert_en_cours_8,
  t0.defectueux AS defectueux_9,
  t0.recu AS recu_10,
  t0.statut AS statut_11,
  t0.modele_id AS modele_id_12,
  t0.local_id AS local_id_13,
  t0.produit_id AS produit_id_14,
  t0.agence_id AS agence_id_15,
  t0.transfert_id AS transfert_id_16,
  t0.nano_reseau_id AS nano_reseau_id_17,
  t0.client_id AS client_id_18,
  t0.utilisateur_id AS utilisateur_id_19,
  t0.etat_id AS etat_id_20,
  t0.facture_id AS facture_id_21,
  t0.fabrication_id AS fabrication_id_22
FROM
  stock t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.prix_unitaire AS prix_unitaire_3, t0.source AS source_4, t0.id_source AS id_source_5, t0.date_entree AS date_entree_6, t0.identifiant AS identifiant_7, t0.transfert_en_cours AS transfert_en_cours_8, t0.defectueux AS defectueux_9, t0.recu AS recu_10, t0.statut AS statut_11, t0.modele_id AS modele_id_12, t0.local_id AS local_id_13, t0.produit_id AS produit_id_14, t0.agence_id AS agence_id_15, t0.transfert_id AS transfert_id_16, t0.nano_reseau_id AS nano_reseau_id_17, t0.client_id AS client_id_18, t0.utilisateur_id AS utilisateur_id_19, t0.etat_id AS etat_id_20, t0.facture_id AS facture_id_21, t0.fabrication_id AS fabrication_id_22 FROM stock t0 WHERE t0.id = 3;

SELECT
  m0_.id AS id_0,
  m0_.intitule AS intitule_1
FROM
  motif_mouvement m0_

SELECT m0_.id AS id_0, m0_.intitule AS intitule_1 FROM motif_mouvement m0_;

SELECT
  a0_.id AS id_0,
  a0_.nom AS nom_1,
  a0_.ref AS ref_2,
  a0_.adresse AS adresse_3,
  a0_.gps AS gps_4,
  a0_.localization_lat AS localization_lat_5,
  a0_.localization_long AS localization_long_6,
  a0_.telephone AS telephone_7
FROM
  agence a0_

SELECT a0_.id AS id_0, a0_.nom AS nom_1, a0_.ref AS ref_2, a0_.adresse AS adresse_3, a0_.gps AS gps_4, a0_.localization_lat AS localization_lat_5, a0_.localization_long AS localization_long_6, a0_.telephone AS telephone_7 FROM agence a0_;

SELECT
  u0_.username AS username_0,
  u0_.username_canonical AS username_canonical_1,
  u0_.email AS email_2,
  u0_.email_canonical AS email_canonical_3,
  u0_.enabled AS enabled_4,
  u0_.salt AS salt_5,
  u0_.password AS password_6,
  u0_.last_login AS last_login_7,
  u0_.confirmation_token AS confirmation_token_8,
  u0_.password_requested_at AS password_requested_at_9,
  u0_.roles AS roles_10,
  u0_.id AS id_11,
  u0_.locale AS locale_12,
  u0_.firstname AS firstname_13,
  u0_.lastname AS lastname_14,
  u0_.phone_number AS phone_number_15,
  u0_.flotte_phone_number AS flotte_phone_number_16,
  u0_.login AS login_17,
  u0_.set_avatar AS set_avatar_18,
  u0_.is_sync AS is_sync_19,
  u0_.date_creation AS date_creation_20,
  u0_.active AS active_21,
  u0_.enable_offline_mode AS enable_offline_mode_22,
  u0_.last_date_synchro_api AS last_date_synchro_api_23,
  u0_.registration_token AS registration_token_24,
  u0_.data_of_birth AS data_of_birth_25,
  u0_.nationality AS nationality_26,
  u0_.profile_picture AS profile_picture_27,
  u0_.attached_document AS attached_document_28,
  u0_.default_entrepreneur AS default_entrepreneur_29,
  u0_.investigator_code AS investigator_code_30,
  u0_.offline_id_min AS offline_id_min_31,
  u0_.offline_id_max AS offline_id_max_32,
  u0_.agence_id AS agence_id_33
FROM
  users u0_

SELECT u0_.username AS username_0, u0_.username_canonical AS username_canonical_1, u0_.email AS email_2, u0_.email_canonical AS email_canonical_3, u0_.enabled AS enabled_4, u0_.salt AS salt_5, u0_.password AS password_6, u0_.last_login AS last_login_7, u0_.confirmation_token AS confirmation_token_8, u0_.password_requested_at AS password_requested_at_9, u0_.roles AS roles_10, u0_.id AS id_11, u0_.locale AS locale_12, u0_.firstname AS firstname_13, u0_.lastname AS lastname_14, u0_.phone_number AS phone_number_15, u0_.flotte_phone_number AS flotte_phone_number_16, u0_.login AS login_17, u0_.set_avatar AS set_avatar_18, u0_.is_sync AS is_sync_19, u0_.date_creation AS date_creation_20, u0_.active AS active_21, u0_.enable_offline_mode AS enable_offline_mode_22, u0_.last_date_synchro_api AS last_date_synchro_api_23, u0_.registration_token AS registration_token_24, u0_.data_of_birth AS data_of_birth_25, u0_.nationality AS nationality_26, u0_.profile_picture AS profile_picture_27, u0_.attached_document AS attached_document_28, u0_.default_entrepreneur AS default_entrepreneur_29, u0_.investigator_code AS investigator_code_30, u0_.offline_id_min AS offline_id_min_31, u0_.offline_id_max AS offline_id_max_32, u0_.agence_id AS agence_id_33 FROM users u0_;

SELECT
  s0_.id AS id_0,
  s0_.quantite AS quantite_1,
  s0_.prix_unitaire AS prix_unitaire_2,
  s0_.source AS source_3,
  s0_.id_source AS id_source_4,
  s0_.date_entree AS date_entree_5,
  s0_.identifiant AS identifiant_6,
  s0_.transfert_en_cours AS transfert_en_cours_7,
  s0_.defectueux AS defectueux_8,
  s0_.recu AS recu_9,
  s0_.statut AS statut_10,
  s0_.modele_id AS modele_id_11,
  s0_.local_id AS local_id_12,
  s0_.produit_id AS produit_id_13,
  s0_.agence_id AS agence_id_14,
  s0_.transfert_id AS transfert_id_15,
  s0_.nano_reseau_id AS nano_reseau_id_16,
  s0_.client_id AS client_id_17,
  s0_.utilisateur_id AS utilisateur_id_18,
  s0_.etat_id AS etat_id_19,
  s0_.facture_id AS facture_id_20,
  s0_.fabrication_id AS fabrication_id_21
FROM
  stock s0_
WHERE
  s0_.id IN (
    SELECT
      MIN(s1_.id) AS sclr_22
    FROM
      stock s1_
      INNER JOIN model m2_ ON s1_.modele_id = m2_.id
    WHERE
      m2_.non_defini = false
    GROUP BY
      s1_.modele_id
  )
ORDER BY
  s0_.modele_id ASC

SELECT s0_.id AS id_0, s0_.quantite AS quantite_1, s0_.prix_unitaire AS prix_unitaire_2, s0_.source AS source_3, s0_.id_source AS id_source_4, s0_.date_entree AS date_entree_5, s0_.identifiant AS identifiant_6, s0_.transfert_en_cours AS transfert_en_cours_7, s0_.defectueux AS defectueux_8, s0_.recu AS recu_9, s0_.statut AS statut_10, s0_.modele_id AS modele_id_11, s0_.local_id AS local_id_12, s0_.produit_id AS produit_id_13, s0_.agence_id AS agence_id_14, s0_.transfert_id AS transfert_id_15, s0_.nano_reseau_id AS nano_reseau_id_16, s0_.client_id AS client_id_17, s0_.utilisateur_id AS utilisateur_id_18, s0_.etat_id AS etat_id_19, s0_.facture_id AS facture_id_20, s0_.fabrication_id AS fabrication_id_21 FROM stock s0_ WHERE s0_.id IN (SELECT MIN(s1_.id) AS sclr_22 FROM stock s1_ INNER JOIN model m2_ ON s1_.modele_id = m2_.id WHERE m2_.non_defini = false GROUP BY s1_.modele_id) ORDER BY s0_.modele_id ASC;

SELECT
  t0.id AS id_1,
  t0.intitule AS intitule_2,
  t0.reference AS reference_3,
  t0.photo_file_name AS photo_file_name_4,
  t0.file_technique_file_name AS file_technique_file_name_5,
  t0.manuel_utilisateur_file_name AS manuel_utilisateur_file_name_6,
  t0.reference_complete AS reference_complete_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.specs AS specs_10,
  t0.specs_commerciales AS specs_commerciales_11,
  t0.non_defini AS non_defini_12,
  t0.produit_id AS produit_id_13,
  t0.created_by_user_id AS created_by_user_id_14,
  t0.updated_by_user_id AS updated_by_user_id_15
FROM
  model t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.intitule AS intitule_2, t0.reference AS reference_3, t0.photo_file_name AS photo_file_name_4, t0.file_technique_file_name AS file_technique_file_name_5, t0.manuel_utilisateur_file_name AS manuel_utilisateur_file_name_6, t0.reference_complete AS reference_complete_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.specs AS specs_10, t0.specs_commerciales AS specs_commerciales_11, t0.non_defini AS non_defini_12, t0.produit_id AS produit_id_13, t0.created_by_user_id AS created_by_user_id_14, t0.updated_by_user_id AS updated_by_user_id_15 FROM model t0 WHERE t0.id = 15;

SELECT
  t0.id AS id_1,
  t0.intitule AS intitule_2,
  t0.reference_interne AS reference_interne_3,
  t0.reference_complete AS reference_complete_4,
  t0.joindre_photo AS joindre_photo_5,
  t0.joindre_fiche_technique AS joindre_fiche_technique_6,
  t0.joindre_manuel_utilisateur AS joindre_manuel_utilisateur_7,
  t0.specs AS specs_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.categorie_id AS categorie_id_11,
  t0.created_by_user_id AS created_by_user_id_12,
  t0.updated_by_user_id AS updated_by_user_id_13
FROM
  produit t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.intitule AS intitule_2, t0.reference_interne AS reference_interne_3, t0.reference_complete AS reference_complete_4, t0.joindre_photo AS joindre_photo_5, t0.joindre_fiche_technique AS joindre_fiche_technique_6, t0.joindre_manuel_utilisateur AS joindre_manuel_utilisateur_7, t0.specs AS specs_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.categorie_id AS categorie_id_11, t0.created_by_user_id AS created_by_user_id_12, t0.updated_by_user_id AS updated_by_user_id_13 FROM produit t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.intitule AS intitule_2,
  t0.type AS type_3,
  t0.niveau_de_suivi AS niveau_de_suivi_4,
  t0.fabricable AS fabricable_5,
  t0.achetable AS achetable_6,
  t0.unite_de_mesure AS unite_de_mesure_7,
  t0.precision_de_mesure AS precision_de_mesure_8,
  t0.reference_interne AS reference_interne_9,
  t0.date_created AS date_created_10,
  t0.date_updated AS date_updated_11,
  t0.creator_id AS creator_id_12,
  t0.editor_id AS editor_id_13
FROM
  categories t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.intitule AS intitule_2, t0.type AS type_3, t0.niveau_de_suivi AS niveau_de_suivi_4, t0.fabricable AS fabricable_5, t0.achetable AS achetable_6, t0.unite_de_mesure AS unite_de_mesure_7, t0.precision_de_mesure AS precision_de_mesure_8, t0.reference_interne AS reference_interne_9, t0.date_created AS date_created_10, t0.date_updated AS date_updated_11, t0.creator_id AS creator_id_12, t0.editor_id AS editor_id_13 FROM categories t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.intitule AS intitule_2,
  t0.reference AS reference_3,
  t0.photo_file_name AS photo_file_name_4,
  t0.file_technique_file_name AS file_technique_file_name_5,
  t0.manuel_utilisateur_file_name AS manuel_utilisateur_file_name_6,
  t0.reference_complete AS reference_complete_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.specs AS specs_10,
  t0.specs_commerciales AS specs_commerciales_11,
  t0.non_defini AS non_defini_12,
  t0.produit_id AS produit_id_13,
  t0.created_by_user_id AS created_by_user_id_14,
  t0.updated_by_user_id AS updated_by_user_id_15
FROM
  model t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.intitule AS intitule_2, t0.reference AS reference_3, t0.photo_file_name AS photo_file_name_4, t0.file_technique_file_name AS file_technique_file_name_5, t0.manuel_utilisateur_file_name AS manuel_utilisateur_file_name_6, t0.reference_complete AS reference_complete_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.specs AS specs_10, t0.specs_commerciales AS specs_commerciales_11, t0.non_defini AS non_defini_12, t0.produit_id AS produit_id_13, t0.created_by_user_id AS created_by_user_id_14, t0.updated_by_user_id AS updated_by_user_id_15 FROM model t0 WHERE t0.id = 18;

SELECT
  t0.id AS id_1,
  t0.intitule AS intitule_2,
  t0.reference_interne AS reference_interne_3,
  t0.reference_complete AS reference_complete_4,
  t0.joindre_photo AS joindre_photo_5,
  t0.joindre_fiche_technique AS joindre_fiche_technique_6,
  t0.joindre_manuel_utilisateur AS joindre_manuel_utilisateur_7,
  t0.specs AS specs_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.categorie_id AS categorie_id_11,
  t0.created_by_user_id AS created_by_user_id_12,
  t0.updated_by_user_id AS updated_by_user_id_13
FROM
  produit t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.intitule AS intitule_2, t0.reference_interne AS reference_interne_3, t0.reference_complete AS reference_complete_4, t0.joindre_photo AS joindre_photo_5, t0.joindre_fiche_technique AS joindre_fiche_technique_6, t0.joindre_manuel_utilisateur AS joindre_manuel_utilisateur_7, t0.specs AS specs_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.categorie_id AS categorie_id_11, t0.created_by_user_id AS created_by_user_id_12, t0.updated_by_user_id AS updated_by_user_id_13 FROM produit t0 WHERE t0.id = 12;

SELECT
  t0.id AS id_1,
  t0.intitule AS intitule_2,
  t0.type AS type_3,
  t0.niveau_de_suivi AS niveau_de_suivi_4,
  t0.fabricable AS fabricable_5,
  t0.achetable AS achetable_6,
  t0.unite_de_mesure AS unite_de_mesure_7,
  t0.precision_de_mesure AS precision_de_mesure_8,
  t0.reference_interne AS reference_interne_9,
  t0.date_created AS date_created_10,
  t0.date_updated AS date_updated_11,
  t0.creator_id AS creator_id_12,
  t0.editor_id AS editor_id_13
FROM
  categories t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.intitule AS intitule_2, t0.type AS type_3, t0.niveau_de_suivi AS niveau_de_suivi_4, t0.fabricable AS fabricable_5, t0.achetable AS achetable_6, t0.unite_de_mesure AS unite_de_mesure_7, t0.precision_de_mesure AS precision_de_mesure_8, t0.reference_interne AS reference_interne_9, t0.date_created AS date_created_10, t0.date_updated AS date_updated_11, t0.creator_id AS creator_id_12, t0.editor_id AS editor_id_13 FROM categories t0 WHERE t0.id = 7;