"SELECT a0_.type AS type_0, a0_.titre AS titre_1, a0_.types_installation AS types_installation_2, a0_.type_remplacement AS type_remplacement_3, a0_.type_remuneration AS type_remuneration_4, a0_.slug AS slug_5, a0_.types_emploi AS types_emploi_6, a0_.adresse_postale AS adresse_postale_7, a0_.ville AS ville_8, a0_.code_postal AS code_postal_9, a0_.department AS department_10, a0_.department_code AS department_code_11, a0_.pays AS pays_12, a0_.lat AS lat_13, a0_.lng AS lng_14, a0_.coordinates_derivation_coefficient AS coordinates_derivation_coefficient_15, a0_.prix_mensuel AS prix_mensuel_16, a0_.prix AS prix_17, a0_.chiffre_affaire_min AS chiffre_affaire_min_18, a0_.chiffre_affaire_max AS chiffre_affaire_max_19, a0_.retrocession AS retrocession_20, a0_.remuneration AS remuneration_21, a0_.remuneration_max AS remuneration_max_22, a0_.remuneration_interval_type AS remuneration_interval_type_23, a0_.superficie_salle AS superficie_salle_24, a0_.superficie_cabinet AS superficie_cabinet_25, a0_.interieur AS interieur_26, a0_.garde AS garde_27, a0_.astreinte AS astreinte_28, a0_.praticiens_en_place AS praticiens_en_place_29, a0_.modalite AS modalite_30, a0_.precisions_modalite AS precisions_modalite_31, a0_.description AS description_32, a0_.start_horaire AS start_horaire_33, a0_.end_horaire AS end_horaire_34, a0_.contact_email AS contact_email_35, a0_.contact_tel AS contact_tel_36, a0_.sous_location AS sous_location_37, a0_.enable AS enable_38, a0_.date_debut AS date_debut_39, a0_.date_fin AS date_fin_40, a0_.youtube_link AS youtube_link_41, a0_.ontop AS ontop_42, a0_.vues AS vues_43, a0_.application_via_email AS application_via_email_44, a0_.application_via_phone AS application_via_phone_45, a0_.application_via_link AS application_via_link_46, a0_.date_expiration AS date_expiration_47, a0_.partner_id AS partner_id_48, a0_.external_id AS external_id_49, a0_.url AS url_50, a0_.hash AS hash_51, a0_.formation_location_type AS formation_location_type_52, a0_.formation_funding AS formation_funding_53, a0_.formation_price AS formation_price_54, a0_.id AS id_55, a0_.created AS created_56, a0_.changed AS changed_57, m1_.id AS id_58, m1_.created AS created_59, m1_.changed AS changed_60, a0_.structure_id AS structure_id_61, a0_.user_id AS user_id_62, a0_.logo_id AS logo_id_63, a0_.location_item_id AS location_item_id_64, m1_.idMediaTypes AS idMediaTypes_65, m1_.idPreviewImage AS idPreviewImage_66, m1_.idCollections AS idCollections_67, m1_.idUsersCreator AS idUsersCreator_68, m1_.idUsersChanger AS idUsersChanger_69 FROM annonce a0_ LEFT JOIN location_item l2_ ON a0_.location_item_id = l2_.id LEFT JOIN location_item l3_ ON l2_.parent_id = l3_.id INNER JOIN annonce_profession a5_ ON a0_.id = a5_.annonce_id INNER JOIN profession p4_ ON p4_.id = a5_.profession_id LEFT JOIN annonce_images a6_ ON a0_.id = a6_.annonce_id LEFT JOIN me_media m1_ ON m1_.id = a6_.media_id LEFT JOIN annonce_option a7_ ON a0_.id = a7_.annonce_id WHERE a0_.type = ? AND (a0_.location_item_id = ? OR l2_.parent_id = ?) AND p4_.id = ? AND a0_.date_debut > ? AND a0_.enable = ? GROUP BY a0_.id ORDER BY a0_.created DESC LIMIT 50"
 Doctrine\Common\Collections\ArrayCollection {#4534
  -elements: array:5 [
    0 => Doctrine\ORM\Query\Parameter {#4521
      -name: "type"
      -value: "emploi_salarie"
      -type: 2
      -typeSpecified: false
    }
    1 => Doctrine\ORM\Query\Parameter {#4524
      -name: "locationItem"
      -value: App\Entity\LocationItem {#4435
        -name: "Endoufielle"
        -slug: "endoufielle"
        -code: "32121"
        -postalCode: "32600"
        -parent: Proxies\__CG__\App\Entity\LocationItem {#4440
          -name: "Gers"
          -slug: "gers"
          -code: "32"
          -postalCode: null
          -parent: Proxies\__CG__\App\Entity\LocationItem {#4518
            -name: ? string
            -slug: ? string
            -code: ? string
            -postalCode: null
            -parent: null
            -type: ? App\Entity\Enum\LocationItemType
            -children: ? Doctrine\Common\Collections\Collection
            -latitude: ? ?float
            -longitude: ? ?float
            #id: 16
            +__isInitialized__: false
             …2
          }
          -type: App\Entity\Enum\LocationItemType {#4431
            +name: "DEPARTMENT"
            +value: "department"
          }
          -children: Doctrine\ORM\PersistentCollection {#4673
            #collection: Doctrine\Common\Collections\ArrayCollection {#4624
              -elements: []
            }
            #initialized: false
            -snapshot: []
            -owner: Proxies\__CG__\App\Entity\LocationItem {#4440 …2}
            -association: array:15 [ …15]
            -em: ContainerA8FY3fM\EntityManagerGhost6410e2e {#1553 …12}
            -backRefFieldName: "parent"
            -typeClass: Doctrine\ORM\Mapping\ClassMetadata {#4377 …}
            -isDirty: false
          }
          -latitude: 43.645
          -longitude: 0.587
          #id: 60
          +__isInitialized__: true
           …2
        }
        -type: App\Entity\Enum\LocationItemType {#4432
          +name: "CITY"
          +value: "city"
        }
        -children: Doctrine\ORM\PersistentCollection {#4441
          #collection: Doctrine\Common\Collections\ArrayCollection {#4442
            -elements: []
          }
          #initialized: false
          -snapshot: []
          -owner: App\Entity\LocationItem {#4435}
          -association: array:15 [ …15]
          -em: ContainerA8FY3fM\EntityManagerGhost6410e2e {#1553 …12}
          -backRefFieldName: "parent"
          -typeClass: Doctrine\ORM\Mapping\ClassMetadata {#4377 …}
          -isDirty: false
        }
        -latitude: 43.5444326144
        -longitude: 1.02189690192
        #id: 12086
      }
      -type: 2
      -typeSpecified: false
    }
    2 => Doctrine\ORM\Query\Parameter {#4526
      -name: "profession"
      -value: 73
      -type: "integer"
      -typeSpecified: false
    }
    3 => Doctrine\ORM\Query\Parameter {#4528
      -name: "aYearAgo"
      -value: DateTime @1707486280 {#4525
        date: 2024-02-09 13:44:40.687180 UTC (+00:00)
      }
      -type: "datetime"
      -typeSpecified: false
    }
    4 => Doctrine\ORM\Query\Parameter {#4533
      -name: "enable"
      -value: true
      -type: "boolean"
      -typeSpecified: false
    }
  ]
}
 Knp\Bundle\PaginatorBundle\Pagination\SlidingPagination {#4763
  #currentPageNumber: 1
  #numItemsPerPage: 50
  #items: []
  #totalCount: 0
  #paginatorOptions: array:8 [
    "pageParameterName" => "page"
    "sortFieldParameterName" => "sort"
    "sortDirectionParameterName" => "order"
    "filterFieldParameterName" => "filterField"
    "filterValueParameterName" => "filterValue"
    "distinct" => true
    "pageOutOfRange" => "ignore"
    "defaultLimit" => 10
  ]
  #customParameters: array:1 [
    "sorted" => true
  ]
  -route: "emploi_salarie_list_location"
  -params: array:2 [
    "profession" => "auxiliaires-medicaux"
    "location" => "endoufielle"
  ]
  -pageRange: 5
  -pageLimit: null
  -template: "@KnpPaginator/Pagination/twitter_bootstrap_v4_pagination.html.twig"
  -sortableTemplate: "@KnpPaginator/Pagination/sortable_link.html.twig"
  -filtrationTemplate: "@KnpPaginator/Pagination/filtration.html.twig"
}