Symfony Profiler

"START TRANSACTION"

"START TRANSACTION";

"COMMIT"

"COMMIT";

SELECT
  w0_.uuid AS uuid_0,
  w0_.iso_code AS iso_code_1,
  w0_.created_at AS created_at_2,
  w0_.updated_at AS updated_at_3,
  w0_.name AS name_4,
  w0_.iso_code3 AS iso_code3_5,
  w0_.iso_numeric AS iso_numeric_6,
  w0_.geo_name_id AS geo_name_id_7,
  w0_.continent AS continent_8,
  w0_.capital AS capital_9,
  w0_.area_in_km2 AS area_in_km2_10,
  w0_.population AS population_11,
  w0_.longitude AS longitude_12,
  w0_.latitude AS latitude_13
FROM
  wt_zone_country w0_
ORDER BY
  w0_.name ASC
LIMIT
  1000

SELECT w0_.uuid AS uuid_0, w0_.iso_code AS iso_code_1, w0_.created_at AS created_at_2, w0_.updated_at AS updated_at_3, w0_.name AS name_4, w0_.iso_code3 AS iso_code3_5, w0_.iso_numeric AS iso_numeric_6, w0_.geo_name_id AS geo_name_id_7, w0_.continent AS continent_8, w0_.capital AS capital_9, w0_.area_in_km2 AS area_in_km2_10, w0_.population AS population_11, w0_.longitude AS longitude_12, w0_.latitude AS latitude_13 FROM wt_zone_country w0_ ORDER BY w0_.name ASC LIMIT 1000;

"START TRANSACTION"

"START TRANSACTION";

SELECT
  w0_.uuid AS uuid_0,
  w0_.name AS name_1,
  w0_.slug AS slug_2,
  w0_.external_ids AS external_ids_3,
  w0_.geo_name_id AS geo_name_id_4,
  w0_.population AS population_5,
  w0_.longitude AS longitude_6,
  w0_.latitude AS latitude_7,
  ST_AsBinary(w0_.geometry_polygon) AS geometry_polygon_8,
  w0_.created_at AS created_at_9,
  w0_.updated_at AS updated_at_10,
  w0_.sinac_synchonization_at AS sinac_synchonization_at_11,
  w0_.country_area_uuid AS country_area_uuid_12,
  w0_.country_uuid AS country_uuid_13,
  w0_.whater_organization_uuid AS whater_organization_uuid_14
FROM
  wt_zone_town w0_
WHERE
  w0_.latitude IS NOT NULL
  AND w0_.longitude IS NOT NULL
  AND 12742 * ASIN(
    SQRT(
      POWER(
        SIN(
          (w0_.latitude - ?) * PI()/ 360
        ),
        2
      ) + COS(
        w0_.latitude * PI()/ 180
      ) * COS(
        ? * PI()/ 180
      ) * POWER(
        SIN(
          (w0_.longitude - ?) * PI()/ 360
        ),
        2
      )
    )
  ) < ?
ORDER BY
  12742 * ASIN(
    SQRT(
      POWER(
        SIN(
          (w0_.latitude - ?) * PI()/ 360
        ),
        2
      ) + COS(
        w0_.latitude * PI()/ 180
      ) * COS(
        ? * PI()/ 180
      ) * POWER(
        SIN(
          (w0_.longitude - ?) * PI()/ 360
        ),
        2
      )
    )
  ) ASC
LIMIT
  1

SELECT w0_.uuid AS uuid_0, w0_.name AS name_1, w0_.slug AS slug_2, w0_.external_ids AS external_ids_3, w0_.geo_name_id AS geo_name_id_4, w0_.population AS population_5, w0_.longitude AS longitude_6, w0_.latitude AS latitude_7, ST_AsBinary(w0_.geometry_polygon) AS geometry_polygon_8, w0_.created_at AS created_at_9, w0_.updated_at AS updated_at_10, w0_.sinac_synchonization_at AS sinac_synchonization_at_11, w0_.country_area_uuid AS country_area_uuid_12, w0_.country_uuid AS country_uuid_13, w0_.whater_organization_uuid AS whater_organization_uuid_14 FROM wt_zone_town w0_ WHERE w0_.latitude IS NOT NULL AND w0_.longitude IS NOT NULL AND 12742 * ASIN(SQRT(POWER(SIN((w0_.latitude - 40.416775) * PI()/360), 2) + COS(w0_.latitude * PI()/180) * COS(40.416775 * PI()/180) * POWER(SIN((w0_.longitude - -3.70379) * PI()/360), 2))) < 1000 ORDER BY 12742 * ASIN(SQRT(POWER(SIN((w0_.latitude - 40.416775) * PI()/360), 2) + COS(w0_.latitude * PI()/180) * COS(40.416775 * PI()/180) * POWER(SIN((w0_.longitude - -3.70379) * PI()/360), 2))) ASC LIMIT 1;

"COMMIT"

"COMMIT";