Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.municipality AS municipality_2,
  t0.region AS region_3,
  t0.municipality_code AS municipality_code_4,
  t0.type AS type_5,
  t0.district AS district_6,
  t0.district_code AS district_code_7,
  t0.geo_point_2d AS geo_point_2d_8,
  t0.geo_shape AS geo_shape_9,
  t10.id AS id_11,
  t10.machine_name AS machine_name_12,
  t10.description AS description_13,
  t10.is_active AS is_active_14,
  t10.created_date AS created_date_15,
  t10.updated_date AS updated_date_16,
  t10.erp_code AS erp_code_17,
  t10.domain_type AS domain_type_18,
  t10.icon AS icon_19,
  t10.order_value AS order_value_20,
  t10.updated_by AS updated_by_21,
  t10.language_code AS language_code_22,
  t10.created_by AS created_by_23,
  t10.domain_id AS domain_id_24,
  t10.parent_domain_value_id AS parent_domain_value_id_25,
  t10.geo_map_id AS geo_map_id_26
FROM
  std_geo_map t0
  LEFT JOIN std_domains_values t10 ON t10.geo_map_id = t0.id

SELECT t0.id AS id_1, t0.municipality AS municipality_2, t0.region AS region_3, t0.municipality_code AS municipality_code_4, t0.type AS type_5, t0.district AS district_6, t0.district_code AS district_code_7, t0.geo_point_2d AS geo_point_2d_8, t0.geo_shape AS geo_shape_9, t10.id AS id_11, t10.machine_name AS machine_name_12, t10.description AS description_13, t10.is_active AS is_active_14, t10.created_date AS created_date_15, t10.updated_date AS updated_date_16, t10.erp_code AS erp_code_17, t10.domain_type AS domain_type_18, t10.icon AS icon_19, t10.order_value AS order_value_20, t10.updated_by AS updated_by_21, t10.language_code AS language_code_22, t10.created_by AS created_by_23, t10.domain_id AS domain_id_24, t10.parent_domain_value_id AS parent_domain_value_id_25, t10.geo_map_id AS geo_map_id_26 FROM std_geo_map t0 LEFT JOIN std_domains_values t10 ON t10.geo_map_id = t0.id;

SELECT
  id
FROM
  std_geo_map
WHERE
  id IN (9577, 9665, 9839, 9700)
ORDER BY
  ST_Distance(
    geo_shape,
    ST_GeomFromText(?, 4326)
  )
LIMIT
  1

SELECT id
        FROM std_geo_map
        WHERE id IN (9577,9665,9839,9700)
        ORDER BY ST_Distance(geo_shape, ST_GeomFromText('POINT(38.682708398955 -9.3276988994406)', 4326))
        LIMIT 1
    ;

SELECT
  t0.machine_name AS machine_name_1,
  t0.label AS label_2,
  t0.value AS value_3,
  t0.description_machine_name AS description_machine_name_4,
  t0.details_machine_name AS details_machine_name_5,
  t0.parent_name AS parent_name_6,
  t0.variable_type AS variable_type_7,
  t0.order_value AS order_value_8,
  t0.is_hidden AS is_hidden_9,
  t0.is_active AS is_active_10,
  t0.created_date AS created_date_11,
  t0.updated_date AS updated_date_12,
  t0.content AS content_13,
  t0.language_code AS language_code_14,
  t0.roles AS roles_15,
  t0.created_by AS created_by_16,
  t0.updated_by AS updated_by_17
FROM
  std_config t0
WHERE
  t0.machine_name = ?
  AND t0.language_code = ?
LIMIT
  1

SELECT t0.machine_name AS machine_name_1, t0.label AS label_2, t0.value AS value_3, t0.description_machine_name AS description_machine_name_4, t0.details_machine_name AS details_machine_name_5, t0.parent_name AS parent_name_6, t0.variable_type AS variable_type_7, t0.order_value AS order_value_8, t0.is_hidden AS is_hidden_9, t0.is_active AS is_active_10, t0.created_date AS created_date_11, t0.updated_date AS updated_date_12, t0.content AS content_13, t0.language_code AS language_code_14, t0.roles AS roles_15, t0.created_by AS created_by_16, t0.updated_by AS updated_by_17 FROM std_config t0 WHERE t0.machine_name = 'tracking_enable' AND t0.language_code = '' LIMIT 1;

SELECT
  t0.language_code AS language_code_1,
  t0.name AS name_2,
  t0.is_public AS is_public_3,
  t0.is_available_in_backoffice AS is_available_in_backoffice_4,
  t0.is_active AS is_active_5,
  t0.is_default AS is_default_6,
  t0.order_value AS order_value_7,
  t0.locale AS locale_8
FROM
  std_languages t0
WHERE
  t0.is_active = ?
  AND t0.is_public = ?

SELECT t0.language_code AS language_code_1, t0.name AS name_2, t0.is_public AS is_public_3, t0.is_available_in_backoffice AS is_available_in_backoffice_4, t0.is_active AS is_active_5, t0.is_default AS is_default_6, t0.order_value AS order_value_7, t0.locale AS locale_8 FROM std_languages t0 WHERE t0.is_active = 1 AND t0.is_public = 1;

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769381835 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('pfOnV5ZbFG:std_features');