"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 profession p6_ ON p4_.parent_id = p6_.id LEFT JOIN annonce_images a7_ ON a0_.id = a7_.annonce_id LEFT JOIN me_media m1_ ON m1_.id = a7_.media_id LEFT JOIN annonce_option a8_ ON a0_.id = a8_.annonce_id WHERE a0_.type = ? AND (a0_.location_item_id = ? OR l2_.parent_id = ?) AND (p4_.id = ? OR p6_.id = ?) AND a0_.date_debut > ? AND a0_.enable = ? GROUP BY a0_.id ORDER BY a0_.created DESC LIMIT 50"
Doctrine\Common\Collections\ArrayCollection {#4535
-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: "Ploubezre"
-slug: "ploubezre"
-code: "22211"
-postalCode: "22300"
-parent: Proxies\__CG__\App\Entity\LocationItem {#4440
-name: "Côtes D'Armor"
-slug: "cotes-d-armor"
-code: "22"
-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: 14
+__isInitialized__: false
…2
}
-type: App\Entity\Enum\LocationItemType {#4431
+name: "DEPARTMENT"
+value: "department"
}
-children: Doctrine\ORM\PersistentCollection {#4684
#collection: Doctrine\Common\Collections\ArrayCollection {#4795
-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: 48.514
-longitude: -2.7653
#id: 50
+__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: 48.685519576
-longitude: -3.44839512307
#id: 7591
}
-type: 2
-typeSpecified: false
}
2 => Doctrine\ORM\Query\Parameter {#4527
-name: "profession"
-value: 62
-type: "integer"
-typeSpecified: false
}
3 => Doctrine\ORM\Query\Parameter {#4529
-name: "aYearAgo"
-value: DateTime @1707489136 {#4526
date: 2024-02-09 14:32:16.424921 UTC (+00:00)
}
-type: "datetime"
-typeSpecified: false
}
4 => Doctrine\ORM\Query\Parameter {#4534
-name: "enable"
-value: true
-type: "boolean"
-typeSpecified: false
}
]
}
Knp\Bundle\PaginatorBundle\Pagination\SlidingPagination {#4788
#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" => "paramedical"
"location" => "ploubezre"
]
-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"
}