Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name_nl AS name_nl_2,
  t0.name_en AS name_en_3,
  t0.location AS location_4,
  t0.date_added AS date_added_5,
  t0.date_reviewed AS date_reviewed_6,
  t0.vulnerability AS vulnerability_7,
  t0.description_nl AS description_nl_8,
  t0.description_en AS description_en_9,
  t0.route_nl AS route_nl_10,
  t0.route_en AS route_en_11,
  t0.finds_nl AS finds_nl_12,
  t0.finds_en AS finds_en_13,
  t0.closed AS closed_14,
  t0.is_quaternary AS is_quaternary_15,
  t0.is_neogene AS is_neogene_16,
  t0.is_paleogene AS is_paleogene_17,
  t0.is_cretaceous AS is_cretaceous_18,
  t0.is_jurassic AS is_jurassic_19,
  t0.is_triassic AS is_triassic_20,
  t0.is_permian AS is_permian_21,
  t0.is_carboniferous AS is_carboniferous_22,
  t0.is_devonian AS is_devonian_23,
  t0.is_silurian AS is_silurian_24,
  t0.is_ordovician AS is_ordovician_25,
  t0.is_cambrian AS is_cambrian_26,
  t0.is_precambrian AS is_precambrian_27,
  t0.has_bacteria AS has_bacteria_28,
  t0.has_archaebacteria AS has_archaebacteria_29,
  t0.has_phaeophyceae AS has_phaeophyceae_30,
  t0.has_diatomophyceae AS has_diatomophyceae_31,
  t0.has_foraminifera AS has_foraminifera_32,
  t0.has_radiolaria AS has_radiolaria_33,
  t0.has_choanoflagellata AS has_choanoflagellata_34,
  t0.has_porifera AS has_porifera_35,
  t0.has_hemichordata AS has_hemichordata_36,
  t0.has_anthozoa AS has_anthozoa_37,
  t0.has_medusozoa AS has_medusozoa_38,
  t0.has_asterozoa AS has_asterozoa_39,
  t0.has_echinoidea AS has_echinoidea_40,
  t0.has_crinoidea AS has_crinoidea_41,
  t0.has_blastoidea AS has_blastoidea_42,
  t0.has_cystoidea AS has_cystoidea_43,
  t0.has_agnatha AS has_agnatha_44,
  t0.has_placodermi AS has_placodermi_45,
  t0.has_chimaeriformes AS has_chimaeriformes_46,
  t0.has_elasmobranchii AS has_elasmobranchii_47,
  t0.has_batoidea AS has_batoidea_48,
  t0.has_actinopterygii AS has_actinopterygii_49,
  t0.has_sarcopterygii AS has_sarcopterygii_50,
  t0.has_dipnoi AS has_dipnoi_51,
  t0.has_amphibia AS has_amphibia_52,
  t0.has_mammaliaterrestrium AS has_mammaliaterrestrium_53,
  t0.has_mammaliamarinis AS has_mammaliamarinis_54,
  t0.has_anapsida AS has_anapsida_55,
  t0.has_squamata AS has_squamata_56,
  t0.has_sauropterygia AS has_sauropterygia_57,
  t0.has_ichthyosauria AS has_ichthyosauria_58,
  t0.has_crocodylomorpha AS has_crocodylomorpha_59,
  t0.has_pterosauria AS has_pterosauria_60,
  t0.has_dinosauria AS has_dinosauria_61,
  t0.has_aves AS has_aves_62,
  t0.has_bryozoa AS has_bryozoa_63,
  t0.has_platyzoa AS has_platyzoa_64,
  t0.has_brachiopoda AS has_brachiopoda_65,
  t0.has_polychaeta AS has_polychaeta_66,
  t0.has_annelida AS has_annelida_67,
  t0.has_polyplacophora AS has_polyplacophora_68,
  t0.has_scaphopoda AS has_scaphopoda_69,
  t0.has_bivalvia AS has_bivalvia_70,
  t0.has_rudista AS has_rudista_71,
  t0.has_gastropoda AS has_gastropoda_72,
  t0.has_nautilida AS has_nautilida_73,
  t0.has_nautiloidea AS has_nautiloidea_74,
  t0.has_goniatitida AS has_goniatitida_75,
  t0.has_ceratitida AS has_ceratitida_76,
  t0.has_ammonitida AS has_ammonitida_77,
  t0.has_belemnoidea AS has_belemnoidea_78,
  t0.has_neocoleoidea AS has_neocoleoidea_79,
  t0.has_trilobita AS has_trilobita_80,
  t0.has_arachnida AS has_arachnida_81,
  t0.has_merostomata AS has_merostomata_82,
  t0.has_myriapoda AS has_myriapoda_83,
  t0.has_ostracoda AS has_ostracoda_84,
  t0.has_crustacea AS has_crustacea_85,
  t0.has_hexapoda AS has_hexapoda_86,
  t0.has_fungi AS has_fungi_87,
  t0.has_mycetozoa AS has_mycetozoa_88,
  t0.has_angiospermae AS has_angiospermae_89,
  t0.has_coniferophyta AS has_coniferophyta_90,
  t0.has_ginkgophyta AS has_ginkgophyta_91,
  t0.has_cycadophyta AS has_cycadophyta_92,
  t0.has_pteridospermophyta AS has_pteridospermophyta_93,
  t0.has_pteridophyta AS has_pteridophyta_94,
  t0.has_sphenophyta AS has_sphenophyta_95,
  t0.has_lycophyta AS has_lycophyta_96,
  t0.has_bryophyta AS has_bryophyta_97,
  t0.has_chlorophyta AS has_chlorophyta_98,
  t0.has_ichnofossilia AS has_ichnofossilia_99,
  t0.has_incertaesedis AS has_incertaesedis_100,
  t0.user_id AS user_id_101,
  t0.username AS username_102,
  t0.approved AS approved_103,
  t0.approved_user_id AS approved_user_id_104,
  t0.approved_username AS approved_username_105,
  t0.num_reviews AS num_reviews_106,
  t0.num_new_photos AS num_new_photos_107,
  t0.country_id AS country_id_108
FROM
  locations_fossil t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name_nl AS name_nl_2, t0.name_en AS name_en_3, t0.location AS location_4, t0.date_added AS date_added_5, t0.date_reviewed AS date_reviewed_6, t0.vulnerability AS vulnerability_7, t0.description_nl AS description_nl_8, t0.description_en AS description_en_9, t0.route_nl AS route_nl_10, t0.route_en AS route_en_11, t0.finds_nl AS finds_nl_12, t0.finds_en AS finds_en_13, t0.closed AS closed_14, t0.is_quaternary AS is_quaternary_15, t0.is_neogene AS is_neogene_16, t0.is_paleogene AS is_paleogene_17, t0.is_cretaceous AS is_cretaceous_18, t0.is_jurassic AS is_jurassic_19, t0.is_triassic AS is_triassic_20, t0.is_permian AS is_permian_21, t0.is_carboniferous AS is_carboniferous_22, t0.is_devonian AS is_devonian_23, t0.is_silurian AS is_silurian_24, t0.is_ordovician AS is_ordovician_25, t0.is_cambrian AS is_cambrian_26, t0.is_precambrian AS is_precambrian_27, t0.has_bacteria AS has_bacteria_28, t0.has_archaebacteria AS has_archaebacteria_29, t0.has_phaeophyceae AS has_phaeophyceae_30, t0.has_diatomophyceae AS has_diatomophyceae_31, t0.has_foraminifera AS has_foraminifera_32, t0.has_radiolaria AS has_radiolaria_33, t0.has_choanoflagellata AS has_choanoflagellata_34, t0.has_porifera AS has_porifera_35, t0.has_hemichordata AS has_hemichordata_36, t0.has_anthozoa AS has_anthozoa_37, t0.has_medusozoa AS has_medusozoa_38, t0.has_asterozoa AS has_asterozoa_39, t0.has_echinoidea AS has_echinoidea_40, t0.has_crinoidea AS has_crinoidea_41, t0.has_blastoidea AS has_blastoidea_42, t0.has_cystoidea AS has_cystoidea_43, t0.has_agnatha AS has_agnatha_44, t0.has_placodermi AS has_placodermi_45, t0.has_chimaeriformes AS has_chimaeriformes_46, t0.has_elasmobranchii AS has_elasmobranchii_47, t0.has_batoidea AS has_batoidea_48, t0.has_actinopterygii AS has_actinopterygii_49, t0.has_sarcopterygii AS has_sarcopterygii_50, t0.has_dipnoi AS has_dipnoi_51, t0.has_amphibia AS has_amphibia_52, t0.has_mammaliaterrestrium AS has_mammaliaterrestrium_53, t0.has_mammaliamarinis AS has_mammaliamarinis_54, t0.has_anapsida AS has_anapsida_55, t0.has_squamata AS has_squamata_56, t0.has_sauropterygia AS has_sauropterygia_57, t0.has_ichthyosauria AS has_ichthyosauria_58, t0.has_crocodylomorpha AS has_crocodylomorpha_59, t0.has_pterosauria AS has_pterosauria_60, t0.has_dinosauria AS has_dinosauria_61, t0.has_aves AS has_aves_62, t0.has_bryozoa AS has_bryozoa_63, t0.has_platyzoa AS has_platyzoa_64, t0.has_brachiopoda AS has_brachiopoda_65, t0.has_polychaeta AS has_polychaeta_66, t0.has_annelida AS has_annelida_67, t0.has_polyplacophora AS has_polyplacophora_68, t0.has_scaphopoda AS has_scaphopoda_69, t0.has_bivalvia AS has_bivalvia_70, t0.has_rudista AS has_rudista_71, t0.has_gastropoda AS has_gastropoda_72, t0.has_nautilida AS has_nautilida_73, t0.has_nautiloidea AS has_nautiloidea_74, t0.has_goniatitida AS has_goniatitida_75, t0.has_ceratitida AS has_ceratitida_76, t0.has_ammonitida AS has_ammonitida_77, t0.has_belemnoidea AS has_belemnoidea_78, t0.has_neocoleoidea AS has_neocoleoidea_79, t0.has_trilobita AS has_trilobita_80, t0.has_arachnida AS has_arachnida_81, t0.has_merostomata AS has_merostomata_82, t0.has_myriapoda AS has_myriapoda_83, t0.has_ostracoda AS has_ostracoda_84, t0.has_crustacea AS has_crustacea_85, t0.has_hexapoda AS has_hexapoda_86, t0.has_fungi AS has_fungi_87, t0.has_mycetozoa AS has_mycetozoa_88, t0.has_angiospermae AS has_angiospermae_89, t0.has_coniferophyta AS has_coniferophyta_90, t0.has_ginkgophyta AS has_ginkgophyta_91, t0.has_cycadophyta AS has_cycadophyta_92, t0.has_pteridospermophyta AS has_pteridospermophyta_93, t0.has_pteridophyta AS has_pteridophyta_94, t0.has_sphenophyta AS has_sphenophyta_95, t0.has_lycophyta AS has_lycophyta_96, t0.has_bryophyta AS has_bryophyta_97, t0.has_chlorophyta AS has_chlorophyta_98, t0.has_ichnofossilia AS has_ichnofossilia_99, t0.has_incertaesedis AS has_incertaesedis_100, t0.user_id AS user_id_101, t0.username AS username_102, t0.approved AS approved_103, t0.approved_user_id AS approved_user_id_104, t0.approved_username AS approved_username_105, t0.num_reviews AS num_reviews_106, t0.num_new_photos AS num_new_photos_107, t0.country_id AS country_id_108 FROM locations_fossil t0 WHERE t0.id = '323';

SELECT
  t0.id AS id_1,
  t0.name_nl AS name_nl_2,
  t0.name_en AS name_en_3,
  t0.shape AS shape_4,
  t0.data AS data_5,
  t0.type AS type_6,
  t0.radius AS radius_7,
  t0.center_lat AS center_lat_8,
  t0.center_lng AS center_lng_9,
  t0.vulnerability AS vulnerability_10,
  t0.user_id AS user_id_11,
  t0.username AS username_12,
  t0.approved AS approved_13,
  t0.approved_user_id AS approved_user_id_14,
  t0.approved_username AS approved_username_15,
  t0.country_id AS country_id_16,
  t0.fossil_id AS fossil_id_17,
  t0.geology_id AS geology_id_18,
  t0.museum_id AS museum_id_19,
  t0.society_id AS society_id_20
FROM
  locations_gis t0
WHERE
  t0.vulnerability IN (?)
  AND t0.approved = ?
  AND t0.fossil_id = ?

SELECT t0.id AS id_1, t0.name_nl AS name_nl_2, t0.name_en AS name_en_3, t0.shape AS shape_4, t0.data AS data_5, t0.type AS type_6, t0.radius AS radius_7, t0.center_lat AS center_lat_8, t0.center_lng AS center_lng_9, t0.vulnerability AS vulnerability_10, t0.user_id AS user_id_11, t0.username AS username_12, t0.approved AS approved_13, t0.approved_user_id AS approved_user_id_14, t0.approved_username AS approved_username_15, t0.country_id AS country_id_16, t0.fossil_id AS fossil_id_17, t0.geology_id AS geology_id_18, t0.museum_id AS museum_id_19, t0.society_id AS society_id_20 FROM locations_gis t0 WHERE t0.vulnerability IN ('public') AND t0.approved = 1 AND t0.fossil_id = 323;

SELECT
  count(f0_.id) AS sclr_0
FROM
  fossildb_fossil f0_
WHERE
  f0_.location_fossil_id = (?)
  AND f0_.approved = 1

SELECT count(f0_.id) AS sclr_0 FROM fossildb_fossil f0_ WHERE f0_.location_fossil_id = (323) AND f0_.approved = 1;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.gis_id AS gis_id_3,
  t0.nearby_gis_id AS nearby_gis_id_4
FROM
  locations_gisnearby t0
WHERE
  t0.gis_id = ?
ORDER BY
  t0.type ASC

SELECT t0.id AS id_1, t0.type AS type_2, t0.gis_id AS gis_id_3, t0.nearby_gis_id AS nearby_gis_id_4 FROM locations_gisnearby t0 WHERE t0.gis_id = 536 ORDER BY t0.type ASC;

SELECT
  t0.id AS id_1,
  t0.name_nl AS name_nl_2,
  t0.name_en AS name_en_3,
  t0.shape AS shape_4,
  t0.data AS data_5,
  t0.type AS type_6,
  t0.radius AS radius_7,
  t0.center_lat AS center_lat_8,
  t0.center_lng AS center_lng_9,
  t0.vulnerability AS vulnerability_10,
  t0.user_id AS user_id_11,
  t0.username AS username_12,
  t0.approved AS approved_13,
  t0.approved_user_id AS approved_user_id_14,
  t0.approved_username AS approved_username_15,
  t0.country_id AS country_id_16,
  t0.fossil_id AS fossil_id_17,
  t0.geology_id AS geology_id_18,
  t0.museum_id AS museum_id_19,
  t0.society_id AS society_id_20
FROM
  locations_gis t0
WHERE
  t0.vulnerability IN (?)
  AND t0.approved = ?
  AND t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name_nl AS name_nl_2, t0.name_en AS name_en_3, t0.shape AS shape_4, t0.data AS data_5, t0.type AS type_6, t0.radius AS radius_7, t0.center_lat AS center_lat_8, t0.center_lng AS center_lng_9, t0.vulnerability AS vulnerability_10, t0.user_id AS user_id_11, t0.username AS username_12, t0.approved AS approved_13, t0.approved_user_id AS approved_user_id_14, t0.approved_username AS approved_username_15, t0.country_id AS country_id_16, t0.fossil_id AS fossil_id_17, t0.geology_id AS geology_id_18, t0.museum_id AS museum_id_19, t0.society_id AS society_id_20 FROM locations_gis t0 WHERE t0.vulnerability IN ('public') AND t0.approved = 1 AND t0.id = 1865 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name_nl AS name_nl_2,
  t0.name_en AS name_en_3,
  t0.shape AS shape_4,
  t0.data AS data_5,
  t0.type AS type_6,
  t0.radius AS radius_7,
  t0.center_lat AS center_lat_8,
  t0.center_lng AS center_lng_9,
  t0.vulnerability AS vulnerability_10,
  t0.user_id AS user_id_11,
  t0.username AS username_12,
  t0.approved AS approved_13,
  t0.approved_user_id AS approved_user_id_14,
  t0.approved_username AS approved_username_15,
  t0.country_id AS country_id_16,
  t0.fossil_id AS fossil_id_17,
  t0.geology_id AS geology_id_18,
  t0.museum_id AS museum_id_19,
  t0.society_id AS society_id_20
FROM
  locations_gis t0
WHERE
  t0.vulnerability IN (?)
  AND t0.approved = ?
  AND t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name_nl AS name_nl_2, t0.name_en AS name_en_3, t0.shape AS shape_4, t0.data AS data_5, t0.type AS type_6, t0.radius AS radius_7, t0.center_lat AS center_lat_8, t0.center_lng AS center_lng_9, t0.vulnerability AS vulnerability_10, t0.user_id AS user_id_11, t0.username AS username_12, t0.approved AS approved_13, t0.approved_user_id AS approved_user_id_14, t0.approved_username AS approved_username_15, t0.country_id AS country_id_16, t0.fossil_id AS fossil_id_17, t0.geology_id AS geology_id_18, t0.museum_id AS museum_id_19, t0.society_id AS society_id_20 FROM locations_gis t0 WHERE t0.vulnerability IN ('public') AND t0.approved = 1 AND t0.id = 2027 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name_nl AS name_nl_2,
  t0.name_en AS name_en_3,
  t0.shape AS shape_4,
  t0.data AS data_5,
  t0.type AS type_6,
  t0.radius AS radius_7,
  t0.center_lat AS center_lat_8,
  t0.center_lng AS center_lng_9,
  t0.vulnerability AS vulnerability_10,
  t0.user_id AS user_id_11,
  t0.username AS username_12,
  t0.approved AS approved_13,
  t0.approved_user_id AS approved_user_id_14,
  t0.approved_username AS approved_username_15,
  t0.country_id AS country_id_16,
  t0.fossil_id AS fossil_id_17,
  t0.geology_id AS geology_id_18,
  t0.museum_id AS museum_id_19,
  t0.society_id AS society_id_20
FROM
  locations_gis t0
WHERE
  t0.vulnerability IN (?)
  AND t0.approved = ?
  AND t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name_nl AS name_nl_2, t0.name_en AS name_en_3, t0.shape AS shape_4, t0.data AS data_5, t0.type AS type_6, t0.radius AS radius_7, t0.center_lat AS center_lat_8, t0.center_lng AS center_lng_9, t0.vulnerability AS vulnerability_10, t0.user_id AS user_id_11, t0.username AS username_12, t0.approved AS approved_13, t0.approved_user_id AS approved_user_id_14, t0.approved_username AS approved_username_15, t0.country_id AS country_id_16, t0.fossil_id AS fossil_id_17, t0.geology_id AS geology_id_18, t0.museum_id AS museum_id_19, t0.society_id AS society_id_20 FROM locations_gis t0 WHERE t0.vulnerability IN ('public') AND t0.approved = 1 AND t0.id = 178 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name_nl AS name_nl_2,
  t0.name_en AS name_en_3,
  t0.shape AS shape_4,
  t0.data AS data_5,
  t0.type AS type_6,
  t0.radius AS radius_7,
  t0.center_lat AS center_lat_8,
  t0.center_lng AS center_lng_9,
  t0.vulnerability AS vulnerability_10,
  t0.user_id AS user_id_11,
  t0.username AS username_12,
  t0.approved AS approved_13,
  t0.approved_user_id AS approved_user_id_14,
  t0.approved_username AS approved_username_15,
  t0.country_id AS country_id_16,
  t0.fossil_id AS fossil_id_17,
  t0.geology_id AS geology_id_18,
  t0.museum_id AS museum_id_19,
  t0.society_id AS society_id_20
FROM
  locations_gis t0
WHERE
  t0.vulnerability IN (?)
  AND t0.approved = ?
  AND t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name_nl AS name_nl_2, t0.name_en AS name_en_3, t0.shape AS shape_4, t0.data AS data_5, t0.type AS type_6, t0.radius AS radius_7, t0.center_lat AS center_lat_8, t0.center_lng AS center_lng_9, t0.vulnerability AS vulnerability_10, t0.user_id AS user_id_11, t0.username AS username_12, t0.approved AS approved_13, t0.approved_user_id AS approved_user_id_14, t0.approved_username AS approved_username_15, t0.country_id AS country_id_16, t0.fossil_id AS fossil_id_17, t0.geology_id AS geology_id_18, t0.museum_id AS museum_id_19, t0.society_id AS society_id_20 FROM locations_gis t0 WHERE t0.vulnerability IN ('public') AND t0.approved = 1 AND t0.id = 1915 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name_nl AS name_nl_2,
  t0.name_en AS name_en_3,
  t0.shape AS shape_4,
  t0.data AS data_5,
  t0.type AS type_6,
  t0.radius AS radius_7,
  t0.center_lat AS center_lat_8,
  t0.center_lng AS center_lng_9,
  t0.vulnerability AS vulnerability_10,
  t0.user_id AS user_id_11,
  t0.username AS username_12,
  t0.approved AS approved_13,
  t0.approved_user_id AS approved_user_id_14,
  t0.approved_username AS approved_username_15,
  t0.country_id AS country_id_16,
  t0.fossil_id AS fossil_id_17,
  t0.geology_id AS geology_id_18,
  t0.museum_id AS museum_id_19,
  t0.society_id AS society_id_20
FROM
  locations_gis t0
WHERE
  t0.vulnerability IN (?)
  AND t0.approved = ?
  AND t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name_nl AS name_nl_2, t0.name_en AS name_en_3, t0.shape AS shape_4, t0.data AS data_5, t0.type AS type_6, t0.radius AS radius_7, t0.center_lat AS center_lat_8, t0.center_lng AS center_lng_9, t0.vulnerability AS vulnerability_10, t0.user_id AS user_id_11, t0.username AS username_12, t0.approved AS approved_13, t0.approved_user_id AS approved_user_id_14, t0.approved_username AS approved_username_15, t0.country_id AS country_id_16, t0.fossil_id AS fossil_id_17, t0.geology_id AS geology_id_18, t0.museum_id AS museum_id_19, t0.society_id AS society_id_20 FROM locations_gis t0 WHERE t0.vulnerability IN ('public') AND t0.approved = 1 AND t0.id = 621 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name_nl AS name_nl_2,
  t0.name_en AS name_en_3,
  t0.shape AS shape_4,
  t0.data AS data_5,
  t0.type AS type_6,
  t0.radius AS radius_7,
  t0.center_lat AS center_lat_8,
  t0.center_lng AS center_lng_9,
  t0.vulnerability AS vulnerability_10,
  t0.user_id AS user_id_11,
  t0.username AS username_12,
  t0.approved AS approved_13,
  t0.approved_user_id AS approved_user_id_14,
  t0.approved_username AS approved_username_15,
  t0.country_id AS country_id_16,
  t0.fossil_id AS fossil_id_17,
  t0.geology_id AS geology_id_18,
  t0.museum_id AS museum_id_19,
  t0.society_id AS society_id_20
FROM
  locations_gis t0
WHERE
  t0.vulnerability IN (?)
  AND t0.approved = ?
  AND t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name_nl AS name_nl_2, t0.name_en AS name_en_3, t0.shape AS shape_4, t0.data AS data_5, t0.type AS type_6, t0.radius AS radius_7, t0.center_lat AS center_lat_8, t0.center_lng AS center_lng_9, t0.vulnerability AS vulnerability_10, t0.user_id AS user_id_11, t0.username AS username_12, t0.approved AS approved_13, t0.approved_user_id AS approved_user_id_14, t0.approved_username AS approved_username_15, t0.country_id AS country_id_16, t0.fossil_id AS fossil_id_17, t0.geology_id AS geology_id_18, t0.museum_id AS museum_id_19, t0.society_id AS society_id_20 FROM locations_gis t0 WHERE t0.vulnerability IN ('public') AND t0.approved = 1 AND t0.id = 1897 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name_nl AS name_nl_2,
  t0.name_en AS name_en_3,
  t0.shape AS shape_4,
  t0.data AS data_5,
  t0.type AS type_6,
  t0.radius AS radius_7,
  t0.center_lat AS center_lat_8,
  t0.center_lng AS center_lng_9,
  t0.vulnerability AS vulnerability_10,
  t0.user_id AS user_id_11,
  t0.username AS username_12,
  t0.approved AS approved_13,
  t0.approved_user_id AS approved_user_id_14,
  t0.approved_username AS approved_username_15,
  t0.country_id AS country_id_16,
  t0.fossil_id AS fossil_id_17,
  t0.geology_id AS geology_id_18,
  t0.museum_id AS museum_id_19,
  t0.society_id AS society_id_20
FROM
  locations_gis t0
WHERE
  t0.vulnerability IN (?)
  AND t0.approved = ?
  AND t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name_nl AS name_nl_2, t0.name_en AS name_en_3, t0.shape AS shape_4, t0.data AS data_5, t0.type AS type_6, t0.radius AS radius_7, t0.center_lat AS center_lat_8, t0.center_lng AS center_lng_9, t0.vulnerability AS vulnerability_10, t0.user_id AS user_id_11, t0.username AS username_12, t0.approved AS approved_13, t0.approved_user_id AS approved_user_id_14, t0.approved_username AS approved_username_15, t0.country_id AS country_id_16, t0.fossil_id AS fossil_id_17, t0.geology_id AS geology_id_18, t0.museum_id AS museum_id_19, t0.society_id AS society_id_20 FROM locations_gis t0 WHERE t0.vulnerability IN ('public') AND t0.approved = 1 AND t0.id = 95 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name_nl AS name_nl_2,
  t0.name_en AS name_en_3,
  t0.shape AS shape_4,
  t0.data AS data_5,
  t0.type AS type_6,
  t0.radius AS radius_7,
  t0.center_lat AS center_lat_8,
  t0.center_lng AS center_lng_9,
  t0.vulnerability AS vulnerability_10,
  t0.user_id AS user_id_11,
  t0.username AS username_12,
  t0.approved AS approved_13,
  t0.approved_user_id AS approved_user_id_14,
  t0.approved_username AS approved_username_15,
  t0.country_id AS country_id_16,
  t0.fossil_id AS fossil_id_17,
  t0.geology_id AS geology_id_18,
  t0.museum_id AS museum_id_19,
  t0.society_id AS society_id_20
FROM
  locations_gis t0
WHERE
  t0.vulnerability IN (?)
  AND t0.approved = ?
  AND t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name_nl AS name_nl_2, t0.name_en AS name_en_3, t0.shape AS shape_4, t0.data AS data_5, t0.type AS type_6, t0.radius AS radius_7, t0.center_lat AS center_lat_8, t0.center_lng AS center_lng_9, t0.vulnerability AS vulnerability_10, t0.user_id AS user_id_11, t0.username AS username_12, t0.approved AS approved_13, t0.approved_user_id AS approved_user_id_14, t0.approved_username AS approved_username_15, t0.country_id AS country_id_16, t0.fossil_id AS fossil_id_17, t0.geology_id AS geology_id_18, t0.museum_id AS museum_id_19, t0.society_id AS society_id_20 FROM locations_gis t0 WHERE t0.vulnerability IN ('public') AND t0.approved = 1 AND t0.id = 1880 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name_nl AS name_nl_2,
  t0.name_en AS name_en_3,
  t0.shape AS shape_4,
  t0.data AS data_5,
  t0.type AS type_6,
  t0.radius AS radius_7,
  t0.center_lat AS center_lat_8,
  t0.center_lng AS center_lng_9,
  t0.vulnerability AS vulnerability_10,
  t0.user_id AS user_id_11,
  t0.username AS username_12,
  t0.approved AS approved_13,
  t0.approved_user_id AS approved_user_id_14,
  t0.approved_username AS approved_username_15,
  t0.country_id AS country_id_16,
  t0.fossil_id AS fossil_id_17,
  t0.geology_id AS geology_id_18,
  t0.museum_id AS museum_id_19,
  t0.society_id AS society_id_20
FROM
  locations_gis t0
WHERE
  t0.vulnerability IN (?)
  AND t0.approved = ?
  AND t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name_nl AS name_nl_2, t0.name_en AS name_en_3, t0.shape AS shape_4, t0.data AS data_5, t0.type AS type_6, t0.radius AS radius_7, t0.center_lat AS center_lat_8, t0.center_lng AS center_lng_9, t0.vulnerability AS vulnerability_10, t0.user_id AS user_id_11, t0.username AS username_12, t0.approved AS approved_13, t0.approved_user_id AS approved_user_id_14, t0.approved_username AS approved_username_15, t0.country_id AS country_id_16, t0.fossil_id AS fossil_id_17, t0.geology_id AS geology_id_18, t0.museum_id AS museum_id_19, t0.society_id AS society_id_20 FROM locations_gis t0 WHERE t0.vulnerability IN ('public') AND t0.approved = 1 AND t0.id = 600 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name_nl AS name_nl_2,
  t0.name_en AS name_en_3,
  t0.shape AS shape_4,
  t0.data AS data_5,
  t0.type AS type_6,
  t0.radius AS radius_7,
  t0.center_lat AS center_lat_8,
  t0.center_lng AS center_lng_9,
  t0.vulnerability AS vulnerability_10,
  t0.user_id AS user_id_11,
  t0.username AS username_12,
  t0.approved AS approved_13,
  t0.approved_user_id AS approved_user_id_14,
  t0.approved_username AS approved_username_15,
  t0.country_id AS country_id_16,
  t0.fossil_id AS fossil_id_17,
  t0.geology_id AS geology_id_18,
  t0.museum_id AS museum_id_19,
  t0.society_id AS society_id_20
FROM
  locations_gis t0
WHERE
  t0.vulnerability IN (?)
  AND t0.approved = ?
  AND t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name_nl AS name_nl_2, t0.name_en AS name_en_3, t0.shape AS shape_4, t0.data AS data_5, t0.type AS type_6, t0.radius AS radius_7, t0.center_lat AS center_lat_8, t0.center_lng AS center_lng_9, t0.vulnerability AS vulnerability_10, t0.user_id AS user_id_11, t0.username AS username_12, t0.approved AS approved_13, t0.approved_user_id AS approved_user_id_14, t0.approved_username AS approved_username_15, t0.country_id AS country_id_16, t0.fossil_id AS fossil_id_17, t0.geology_id AS geology_id_18, t0.museum_id AS museum_id_19, t0.society_id AS society_id_20 FROM locations_gis t0 WHERE t0.vulnerability IN ('public') AND t0.approved = 1 AND t0.id = 1255 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name_nl AS name_nl_2,
  t0.name_en AS name_en_3,
  t0.shape AS shape_4,
  t0.data AS data_5,
  t0.type AS type_6,
  t0.radius AS radius_7,
  t0.center_lat AS center_lat_8,
  t0.center_lng AS center_lng_9,
  t0.vulnerability AS vulnerability_10,
  t0.user_id AS user_id_11,
  t0.username AS username_12,
  t0.approved AS approved_13,
  t0.approved_user_id AS approved_user_id_14,
  t0.approved_username AS approved_username_15,
  t0.country_id AS country_id_16,
  t0.fossil_id AS fossil_id_17,
  t0.geology_id AS geology_id_18,
  t0.museum_id AS museum_id_19,
  t0.society_id AS society_id_20
FROM
  locations_gis t0
WHERE
  t0.vulnerability IN (?)
  AND t0.approved = ?
  AND t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name_nl AS name_nl_2, t0.name_en AS name_en_3, t0.shape AS shape_4, t0.data AS data_5, t0.type AS type_6, t0.radius AS radius_7, t0.center_lat AS center_lat_8, t0.center_lng AS center_lng_9, t0.vulnerability AS vulnerability_10, t0.user_id AS user_id_11, t0.username AS username_12, t0.approved AS approved_13, t0.approved_user_id AS approved_user_id_14, t0.approved_username AS approved_username_15, t0.country_id AS country_id_16, t0.fossil_id AS fossil_id_17, t0.geology_id AS geology_id_18, t0.museum_id AS museum_id_19, t0.society_id AS society_id_20 FROM locations_gis t0 WHERE t0.vulnerability IN ('public') AND t0.approved = 1 AND t0.id = 1022 LIMIT 1;