Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.country_id AS country_id_5
FROM
  dive_region t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.country_id AS country_id_5 FROM dive_region t0 WHERE t0.slug = 'la-herradura-es' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.lat AS lat_4,
  t0.lng AS lng_5,
  t0.deep AS deep_6,
  t0.slug AS slug_7,
  t0.country_id AS country_id_8,
  t0.region_id AS region_id_9,
  t0.type_id AS type_id_10
FROM
  dive_place t0
WHERE
  t0.region_id = ?
ORDER BY
  t0.id DESC

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.deep AS deep_6, t0.slug AS slug_7, t0.country_id AS country_id_8, t0.region_id AS region_id_9, t0.type_id AS type_id_10 FROM dive_place t0 WHERE t0.region_id = 4 ORDER BY t0.id DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.shortname AS shortname_3,
  t0.lat AS lat_4,
  t0.lng AS lng_5
FROM
  country t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.shortname AS shortname_3, t0.lat AS lat_4, t0.lng AS lng_5 FROM country t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.place_id AS place_id_3,
  t0.formatted_address AS formatted_address_4,
  t0.locality AS locality_5,
  t0.administrative_area_level_second AS administrative_area_level_second_6,
  t0.administrative_area_level_first AS administrative_area_level_first_7,
  t0.postal_code AS postal_code_8,
  t0.lat AS lat_9,
  t0.lng AS lng_10,
  t0.rating AS rating_11,
  t0.google_maps_uri AS google_maps_uri_12,
  t0.website_uri AS website_uri_13,
  t0.adr_format_address AS adr_format_address_14,
  t0.user_rating_count AS user_rating_count_15,
  t0.display_name AS display_name_16,
  t0.slug AS slug_17,
  t0.whatsapp AS whatsapp_18,
  t0.instagram AS instagram_19,
  t0.facebook AS facebook_20,
  t0.twitter AS twitter_21,
  t0.youtube AS youtube_22,
  t0.phone AS phone_23,
  t0.country_id AS country_id_24
FROM
  center t0
WHERE
  t0.country_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.place_id AS place_id_3, t0.formatted_address AS formatted_address_4, t0.locality AS locality_5, t0.administrative_area_level_second AS administrative_area_level_second_6, t0.administrative_area_level_first AS administrative_area_level_first_7, t0.postal_code AS postal_code_8, t0.lat AS lat_9, t0.lng AS lng_10, t0.rating AS rating_11, t0.google_maps_uri AS google_maps_uri_12, t0.website_uri AS website_uri_13, t0.adr_format_address AS adr_format_address_14, t0.user_rating_count AS user_rating_count_15, t0.display_name AS display_name_16, t0.slug AS slug_17, t0.whatsapp AS whatsapp_18, t0.instagram AS instagram_19, t0.facebook AS facebook_20, t0.twitter AS twitter_21, t0.youtube AS youtube_22, t0.phone AS phone_23, t0.country_id AS country_id_24 FROM center t0 WHERE t0.country_id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.place_id AS place_id_3,
  t0.formatted_address AS formatted_address_4,
  t0.locality AS locality_5,
  t0.administrative_area_level_second AS administrative_area_level_second_6,
  t0.administrative_area_level_first AS administrative_area_level_first_7,
  t0.postal_code AS postal_code_8,
  t0.lat AS lat_9,
  t0.lng AS lng_10,
  t0.rating AS rating_11,
  t0.google_maps_uri AS google_maps_uri_12,
  t0.website_uri AS website_uri_13,
  t0.adr_format_address AS adr_format_address_14,
  t0.user_rating_count AS user_rating_count_15,
  t0.display_name AS display_name_16,
  t0.slug AS slug_17,
  t0.whatsapp AS whatsapp_18,
  t0.instagram AS instagram_19,
  t0.facebook AS facebook_20,
  t0.twitter AS twitter_21,
  t0.youtube AS youtube_22,
  t0.phone AS phone_23,
  t0.country_id AS country_id_24
FROM
  center t0
WHERE
  t0.country_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.place_id AS place_id_3, t0.formatted_address AS formatted_address_4, t0.locality AS locality_5, t0.administrative_area_level_second AS administrative_area_level_second_6, t0.administrative_area_level_first AS administrative_area_level_first_7, t0.postal_code AS postal_code_8, t0.lat AS lat_9, t0.lng AS lng_10, t0.rating AS rating_11, t0.google_maps_uri AS google_maps_uri_12, t0.website_uri AS website_uri_13, t0.adr_format_address AS adr_format_address_14, t0.user_rating_count AS user_rating_count_15, t0.display_name AS display_name_16, t0.slug AS slug_17, t0.whatsapp AS whatsapp_18, t0.instagram AS instagram_19, t0.facebook AS facebook_20, t0.twitter AS twitter_21, t0.youtube AS youtube_22, t0.phone AS phone_23, t0.country_id AS country_id_24 FROM center t0 WHERE t0.country_id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.place_id AS place_id_3,
  t0.formatted_address AS formatted_address_4,
  t0.locality AS locality_5,
  t0.administrative_area_level_second AS administrative_area_level_second_6,
  t0.administrative_area_level_first AS administrative_area_level_first_7,
  t0.postal_code AS postal_code_8,
  t0.lat AS lat_9,
  t0.lng AS lng_10,
  t0.rating AS rating_11,
  t0.google_maps_uri AS google_maps_uri_12,
  t0.website_uri AS website_uri_13,
  t0.adr_format_address AS adr_format_address_14,
  t0.user_rating_count AS user_rating_count_15,
  t0.display_name AS display_name_16,
  t0.slug AS slug_17,
  t0.whatsapp AS whatsapp_18,
  t0.instagram AS instagram_19,
  t0.facebook AS facebook_20,
  t0.twitter AS twitter_21,
  t0.youtube AS youtube_22,
  t0.phone AS phone_23,
  t0.country_id AS country_id_24
FROM
  center t0
WHERE
  t0.country_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.place_id AS place_id_3, t0.formatted_address AS formatted_address_4, t0.locality AS locality_5, t0.administrative_area_level_second AS administrative_area_level_second_6, t0.administrative_area_level_first AS administrative_area_level_first_7, t0.postal_code AS postal_code_8, t0.lat AS lat_9, t0.lng AS lng_10, t0.rating AS rating_11, t0.google_maps_uri AS google_maps_uri_12, t0.website_uri AS website_uri_13, t0.adr_format_address AS adr_format_address_14, t0.user_rating_count AS user_rating_count_15, t0.display_name AS display_name_16, t0.slug AS slug_17, t0.whatsapp AS whatsapp_18, t0.instagram AS instagram_19, t0.facebook AS facebook_20, t0.twitter AS twitter_21, t0.youtube AS youtube_22, t0.phone AS phone_23, t0.country_id AS country_id_24 FROM center t0 WHERE t0.country_id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.place_id AS place_id_3,
  t0.formatted_address AS formatted_address_4,
  t0.locality AS locality_5,
  t0.administrative_area_level_second AS administrative_area_level_second_6,
  t0.administrative_area_level_first AS administrative_area_level_first_7,
  t0.postal_code AS postal_code_8,
  t0.lat AS lat_9,
  t0.lng AS lng_10,
  t0.rating AS rating_11,
  t0.google_maps_uri AS google_maps_uri_12,
  t0.website_uri AS website_uri_13,
  t0.adr_format_address AS adr_format_address_14,
  t0.user_rating_count AS user_rating_count_15,
  t0.display_name AS display_name_16,
  t0.slug AS slug_17,
  t0.whatsapp AS whatsapp_18,
  t0.instagram AS instagram_19,
  t0.facebook AS facebook_20,
  t0.twitter AS twitter_21,
  t0.youtube AS youtube_22,
  t0.phone AS phone_23,
  t0.country_id AS country_id_24
FROM
  center t0
WHERE
  t0.country_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.place_id AS place_id_3, t0.formatted_address AS formatted_address_4, t0.locality AS locality_5, t0.administrative_area_level_second AS administrative_area_level_second_6, t0.administrative_area_level_first AS administrative_area_level_first_7, t0.postal_code AS postal_code_8, t0.lat AS lat_9, t0.lng AS lng_10, t0.rating AS rating_11, t0.google_maps_uri AS google_maps_uri_12, t0.website_uri AS website_uri_13, t0.adr_format_address AS adr_format_address_14, t0.user_rating_count AS user_rating_count_15, t0.display_name AS display_name_16, t0.slug AS slug_17, t0.whatsapp AS whatsapp_18, t0.instagram AS instagram_19, t0.facebook AS facebook_20, t0.twitter AS twitter_21, t0.youtube AS youtube_22, t0.phone AS phone_23, t0.country_id AS country_id_24 FROM center t0 WHERE t0.country_id = 4;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.place_id AS place_id_3,
  t0.formatted_address AS formatted_address_4,
  t0.locality AS locality_5,
  t0.administrative_area_level_second AS administrative_area_level_second_6,
  t0.administrative_area_level_first AS administrative_area_level_first_7,
  t0.postal_code AS postal_code_8,
  t0.lat AS lat_9,
  t0.lng AS lng_10,
  t0.rating AS rating_11,
  t0.google_maps_uri AS google_maps_uri_12,
  t0.website_uri AS website_uri_13,
  t0.adr_format_address AS adr_format_address_14,
  t0.user_rating_count AS user_rating_count_15,
  t0.display_name AS display_name_16,
  t0.slug AS slug_17,
  t0.whatsapp AS whatsapp_18,
  t0.instagram AS instagram_19,
  t0.facebook AS facebook_20,
  t0.twitter AS twitter_21,
  t0.youtube AS youtube_22,
  t0.phone AS phone_23,
  t0.country_id AS country_id_24
FROM
  center t0
WHERE
  t0.country_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.place_id AS place_id_3, t0.formatted_address AS formatted_address_4, t0.locality AS locality_5, t0.administrative_area_level_second AS administrative_area_level_second_6, t0.administrative_area_level_first AS administrative_area_level_first_7, t0.postal_code AS postal_code_8, t0.lat AS lat_9, t0.lng AS lng_10, t0.rating AS rating_11, t0.google_maps_uri AS google_maps_uri_12, t0.website_uri AS website_uri_13, t0.adr_format_address AS adr_format_address_14, t0.user_rating_count AS user_rating_count_15, t0.display_name AS display_name_16, t0.slug AS slug_17, t0.whatsapp AS whatsapp_18, t0.instagram AS instagram_19, t0.facebook AS facebook_20, t0.twitter AS twitter_21, t0.youtube AS youtube_22, t0.phone AS phone_23, t0.country_id AS country_id_24 FROM center t0 WHERE t0.country_id = 5;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.place_id AS place_id_3,
  t0.formatted_address AS formatted_address_4,
  t0.locality AS locality_5,
  t0.administrative_area_level_second AS administrative_area_level_second_6,
  t0.administrative_area_level_first AS administrative_area_level_first_7,
  t0.postal_code AS postal_code_8,
  t0.lat AS lat_9,
  t0.lng AS lng_10,
  t0.rating AS rating_11,
  t0.google_maps_uri AS google_maps_uri_12,
  t0.website_uri AS website_uri_13,
  t0.adr_format_address AS adr_format_address_14,
  t0.user_rating_count AS user_rating_count_15,
  t0.display_name AS display_name_16,
  t0.slug AS slug_17,
  t0.whatsapp AS whatsapp_18,
  t0.instagram AS instagram_19,
  t0.facebook AS facebook_20,
  t0.twitter AS twitter_21,
  t0.youtube AS youtube_22,
  t0.phone AS phone_23,
  t0.country_id AS country_id_24
FROM
  center t0
WHERE
  t0.country_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.place_id AS place_id_3, t0.formatted_address AS formatted_address_4, t0.locality AS locality_5, t0.administrative_area_level_second AS administrative_area_level_second_6, t0.administrative_area_level_first AS administrative_area_level_first_7, t0.postal_code AS postal_code_8, t0.lat AS lat_9, t0.lng AS lng_10, t0.rating AS rating_11, t0.google_maps_uri AS google_maps_uri_12, t0.website_uri AS website_uri_13, t0.adr_format_address AS adr_format_address_14, t0.user_rating_count AS user_rating_count_15, t0.display_name AS display_name_16, t0.slug AS slug_17, t0.whatsapp AS whatsapp_18, t0.instagram AS instagram_19, t0.facebook AS facebook_20, t0.twitter AS twitter_21, t0.youtube AS youtube_22, t0.phone AS phone_23, t0.country_id AS country_id_24 FROM center t0 WHERE t0.country_id = 6;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.place_id AS place_id_3,
  t0.formatted_address AS formatted_address_4,
  t0.locality AS locality_5,
  t0.administrative_area_level_second AS administrative_area_level_second_6,
  t0.administrative_area_level_first AS administrative_area_level_first_7,
  t0.postal_code AS postal_code_8,
  t0.lat AS lat_9,
  t0.lng AS lng_10,
  t0.rating AS rating_11,
  t0.google_maps_uri AS google_maps_uri_12,
  t0.website_uri AS website_uri_13,
  t0.adr_format_address AS adr_format_address_14,
  t0.user_rating_count AS user_rating_count_15,
  t0.display_name AS display_name_16,
  t0.slug AS slug_17,
  t0.whatsapp AS whatsapp_18,
  t0.instagram AS instagram_19,
  t0.facebook AS facebook_20,
  t0.twitter AS twitter_21,
  t0.youtube AS youtube_22,
  t0.phone AS phone_23,
  t0.country_id AS country_id_24
FROM
  center t0
WHERE
  t0.country_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.place_id AS place_id_3, t0.formatted_address AS formatted_address_4, t0.locality AS locality_5, t0.administrative_area_level_second AS administrative_area_level_second_6, t0.administrative_area_level_first AS administrative_area_level_first_7, t0.postal_code AS postal_code_8, t0.lat AS lat_9, t0.lng AS lng_10, t0.rating AS rating_11, t0.google_maps_uri AS google_maps_uri_12, t0.website_uri AS website_uri_13, t0.adr_format_address AS adr_format_address_14, t0.user_rating_count AS user_rating_count_15, t0.display_name AS display_name_16, t0.slug AS slug_17, t0.whatsapp AS whatsapp_18, t0.instagram AS instagram_19, t0.facebook AS facebook_20, t0.twitter AS twitter_21, t0.youtube AS youtube_22, t0.phone AS phone_23, t0.country_id AS country_id_24 FROM center t0 WHERE t0.country_id = 7;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.place_id AS place_id_3,
  t0.formatted_address AS formatted_address_4,
  t0.locality AS locality_5,
  t0.administrative_area_level_second AS administrative_area_level_second_6,
  t0.administrative_area_level_first AS administrative_area_level_first_7,
  t0.postal_code AS postal_code_8,
  t0.lat AS lat_9,
  t0.lng AS lng_10,
  t0.rating AS rating_11,
  t0.google_maps_uri AS google_maps_uri_12,
  t0.website_uri AS website_uri_13,
  t0.adr_format_address AS adr_format_address_14,
  t0.user_rating_count AS user_rating_count_15,
  t0.display_name AS display_name_16,
  t0.slug AS slug_17,
  t0.whatsapp AS whatsapp_18,
  t0.instagram AS instagram_19,
  t0.facebook AS facebook_20,
  t0.twitter AS twitter_21,
  t0.youtube AS youtube_22,
  t0.phone AS phone_23,
  t0.country_id AS country_id_24
FROM
  center t0
WHERE
  t0.country_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.place_id AS place_id_3, t0.formatted_address AS formatted_address_4, t0.locality AS locality_5, t0.administrative_area_level_second AS administrative_area_level_second_6, t0.administrative_area_level_first AS administrative_area_level_first_7, t0.postal_code AS postal_code_8, t0.lat AS lat_9, t0.lng AS lng_10, t0.rating AS rating_11, t0.google_maps_uri AS google_maps_uri_12, t0.website_uri AS website_uri_13, t0.adr_format_address AS adr_format_address_14, t0.user_rating_count AS user_rating_count_15, t0.display_name AS display_name_16, t0.slug AS slug_17, t0.whatsapp AS whatsapp_18, t0.instagram AS instagram_19, t0.facebook AS facebook_20, t0.twitter AS twitter_21, t0.youtube AS youtube_22, t0.phone AS phone_23, t0.country_id AS country_id_24 FROM center t0 WHERE t0.country_id = 8;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.place_id AS place_id_3,
  t0.formatted_address AS formatted_address_4,
  t0.locality AS locality_5,
  t0.administrative_area_level_second AS administrative_area_level_second_6,
  t0.administrative_area_level_first AS administrative_area_level_first_7,
  t0.postal_code AS postal_code_8,
  t0.lat AS lat_9,
  t0.lng AS lng_10,
  t0.rating AS rating_11,
  t0.google_maps_uri AS google_maps_uri_12,
  t0.website_uri AS website_uri_13,
  t0.adr_format_address AS adr_format_address_14,
  t0.user_rating_count AS user_rating_count_15,
  t0.display_name AS display_name_16,
  t0.slug AS slug_17,
  t0.whatsapp AS whatsapp_18,
  t0.instagram AS instagram_19,
  t0.facebook AS facebook_20,
  t0.twitter AS twitter_21,
  t0.youtube AS youtube_22,
  t0.phone AS phone_23,
  t0.country_id AS country_id_24
FROM
  center t0
WHERE
  t0.country_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.place_id AS place_id_3, t0.formatted_address AS formatted_address_4, t0.locality AS locality_5, t0.administrative_area_level_second AS administrative_area_level_second_6, t0.administrative_area_level_first AS administrative_area_level_first_7, t0.postal_code AS postal_code_8, t0.lat AS lat_9, t0.lng AS lng_10, t0.rating AS rating_11, t0.google_maps_uri AS google_maps_uri_12, t0.website_uri AS website_uri_13, t0.adr_format_address AS adr_format_address_14, t0.user_rating_count AS user_rating_count_15, t0.display_name AS display_name_16, t0.slug AS slug_17, t0.whatsapp AS whatsapp_18, t0.instagram AS instagram_19, t0.facebook AS facebook_20, t0.twitter AS twitter_21, t0.youtube AS youtube_22, t0.phone AS phone_23, t0.country_id AS country_id_24 FROM center t0 WHERE t0.country_id = 9;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.place_id AS place_id_3,
  t0.formatted_address AS formatted_address_4,
  t0.locality AS locality_5,
  t0.administrative_area_level_second AS administrative_area_level_second_6,
  t0.administrative_area_level_first AS administrative_area_level_first_7,
  t0.postal_code AS postal_code_8,
  t0.lat AS lat_9,
  t0.lng AS lng_10,
  t0.rating AS rating_11,
  t0.google_maps_uri AS google_maps_uri_12,
  t0.website_uri AS website_uri_13,
  t0.adr_format_address AS adr_format_address_14,
  t0.user_rating_count AS user_rating_count_15,
  t0.display_name AS display_name_16,
  t0.slug AS slug_17,
  t0.whatsapp AS whatsapp_18,
  t0.instagram AS instagram_19,
  t0.facebook AS facebook_20,
  t0.twitter AS twitter_21,
  t0.youtube AS youtube_22,
  t0.phone AS phone_23,
  t0.country_id AS country_id_24
FROM
  center t0
WHERE
  t0.country_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.place_id AS place_id_3, t0.formatted_address AS formatted_address_4, t0.locality AS locality_5, t0.administrative_area_level_second AS administrative_area_level_second_6, t0.administrative_area_level_first AS administrative_area_level_first_7, t0.postal_code AS postal_code_8, t0.lat AS lat_9, t0.lng AS lng_10, t0.rating AS rating_11, t0.google_maps_uri AS google_maps_uri_12, t0.website_uri AS website_uri_13, t0.adr_format_address AS adr_format_address_14, t0.user_rating_count AS user_rating_count_15, t0.display_name AS display_name_16, t0.slug AS slug_17, t0.whatsapp AS whatsapp_18, t0.instagram AS instagram_19, t0.facebook AS facebook_20, t0.twitter AS twitter_21, t0.youtube AS youtube_22, t0.phone AS phone_23, t0.country_id AS country_id_24 FROM center t0 WHERE t0.country_id = 10;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.place_id AS place_id_3,
  t0.formatted_address AS formatted_address_4,
  t0.locality AS locality_5,
  t0.administrative_area_level_second AS administrative_area_level_second_6,
  t0.administrative_area_level_first AS administrative_area_level_first_7,
  t0.postal_code AS postal_code_8,
  t0.lat AS lat_9,
  t0.lng AS lng_10,
  t0.rating AS rating_11,
  t0.google_maps_uri AS google_maps_uri_12,
  t0.website_uri AS website_uri_13,
  t0.adr_format_address AS adr_format_address_14,
  t0.user_rating_count AS user_rating_count_15,
  t0.display_name AS display_name_16,
  t0.slug AS slug_17,
  t0.whatsapp AS whatsapp_18,
  t0.instagram AS instagram_19,
  t0.facebook AS facebook_20,
  t0.twitter AS twitter_21,
  t0.youtube AS youtube_22,
  t0.phone AS phone_23,
  t0.country_id AS country_id_24
FROM
  center t0
WHERE
  t0.country_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.place_id AS place_id_3, t0.formatted_address AS formatted_address_4, t0.locality AS locality_5, t0.administrative_area_level_second AS administrative_area_level_second_6, t0.administrative_area_level_first AS administrative_area_level_first_7, t0.postal_code AS postal_code_8, t0.lat AS lat_9, t0.lng AS lng_10, t0.rating AS rating_11, t0.google_maps_uri AS google_maps_uri_12, t0.website_uri AS website_uri_13, t0.adr_format_address AS adr_format_address_14, t0.user_rating_count AS user_rating_count_15, t0.display_name AS display_name_16, t0.slug AS slug_17, t0.whatsapp AS whatsapp_18, t0.instagram AS instagram_19, t0.facebook AS facebook_20, t0.twitter AS twitter_21, t0.youtube AS youtube_22, t0.phone AS phone_23, t0.country_id AS country_id_24 FROM center t0 WHERE t0.country_id = 11;