Symfony Profiler

SELECT
  DISTINCT j0_.id AS id_0
FROM
  job j0_
LIMIT
  20
OFFSET
  140

SELECT DISTINCT j0_.id AS id_0 FROM job j0_ LIMIT 20 OFFSET 140;

SELECT
  j0_.id AS id_0,
  j0_.company AS company_1,
  j0_.company_phone AS company_phone_2,
  j0_.website AS website_3,
  j0_.contact_person AS contact_person_4,
  j0_.contact_email AS contact_email_5,
  j0_.contact_phone AS contact_phone_6,
  j0_.position AS position_7,
  j0_.position_id AS position_id_8,
  j0_.ad_id AS ad_id_9,
  j0_.location AS location_10,
  j0_.description AS description_11,
  j0_.imported_at AS imported_at_12,
  j0_.created_at AS created_at_13,
  j0_.updated_at AS updated_at_14
FROM
  job j0_
WHERE
  j0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )

SELECT j0_.id AS id_0, j0_.company AS company_1, j0_.company_phone AS company_phone_2, j0_.website AS website_3, j0_.contact_person AS contact_person_4, j0_.contact_email AS contact_email_5, j0_.contact_phone AS contact_phone_6, j0_.position AS position_7, j0_.position_id AS position_id_8, j0_.ad_id AS ad_id_9, j0_.location AS location_10, j0_.description AS description_11, j0_.imported_at AS imported_at_12, j0_.created_at AS created_at_13, j0_.updated_at AS updated_at_14 FROM job j0_ WHERE j0_.id IN (187216, 187212, 187215, 178641, 178638, 178639, 178640, 178643, 178644, 178642, 178645, 178646, 189266, 189265, 189269, 189267, 189268, 174932, 194553, 176726);

SELECT
  count(*) AS sclr_0
FROM
  job j0_

SELECT count(*) AS sclr_0 FROM job j0_;

SELECT
  t0.id AS id_1,
  t0.zipcode AS zipcode_2,
  t0.place AS place_3,
  t0.latitude AS latitude_4,
  t0.longitude AS longitude_5
FROM
  geo_city t0
  INNER JOIN job_geo_city ON t0.id = job_geo_city.geo_city_id
WHERE
  job_geo_city.job_id = ?

SELECT t0.id AS id_1, t0.zipcode AS zipcode_2, t0.place AS place_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5 FROM geo_city t0 INNER JOIN job_geo_city ON t0.id = job_geo_city.geo_city_id WHERE job_geo_city.job_id = 174932;

SELECT
  t0.id AS id_1,
  t0.zipcode AS zipcode_2,
  t0.place AS place_3,
  t0.latitude AS latitude_4,
  t0.longitude AS longitude_5
FROM
  geo_city t0
  INNER JOIN job_geo_city ON t0.id = job_geo_city.geo_city_id
WHERE
  job_geo_city.job_id = ?

SELECT t0.id AS id_1, t0.zipcode AS zipcode_2, t0.place AS place_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5 FROM geo_city t0 INNER JOIN job_geo_city ON t0.id = job_geo_city.geo_city_id WHERE job_geo_city.job_id = 176726;

SELECT
  t0.id AS id_1,
  t0.zipcode AS zipcode_2,
  t0.place AS place_3,
  t0.latitude AS latitude_4,
  t0.longitude AS longitude_5
FROM
  geo_city t0
  INNER JOIN job_geo_city ON t0.id = job_geo_city.geo_city_id
WHERE
  job_geo_city.job_id = ?

SELECT t0.id AS id_1, t0.zipcode AS zipcode_2, t0.place AS place_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5 FROM geo_city t0 INNER JOIN job_geo_city ON t0.id = job_geo_city.geo_city_id WHERE job_geo_city.job_id = 178638;

SELECT
  t0.id AS id_1,
  t0.zipcode AS zipcode_2,
  t0.place AS place_3,
  t0.latitude AS latitude_4,
  t0.longitude AS longitude_5
FROM
  geo_city t0
  INNER JOIN job_geo_city ON t0.id = job_geo_city.geo_city_id
WHERE
  job_geo_city.job_id = ?

SELECT t0.id AS id_1, t0.zipcode AS zipcode_2, t0.place AS place_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5 FROM geo_city t0 INNER JOIN job_geo_city ON t0.id = job_geo_city.geo_city_id WHERE job_geo_city.job_id = 178639;

SELECT
  t0.id AS id_1,
  t0.zipcode AS zipcode_2,
  t0.place AS place_3,
  t0.latitude AS latitude_4,
  t0.longitude AS longitude_5
FROM
  geo_city t0
  INNER JOIN job_geo_city ON t0.id = job_geo_city.geo_city_id
WHERE
  job_geo_city.job_id = ?

SELECT t0.id AS id_1, t0.zipcode AS zipcode_2, t0.place AS place_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5 FROM geo_city t0 INNER JOIN job_geo_city ON t0.id = job_geo_city.geo_city_id WHERE job_geo_city.job_id = 178640;

SELECT
  t0.id AS id_1,
  t0.zipcode AS zipcode_2,
  t0.place AS place_3,
  t0.latitude AS latitude_4,
  t0.longitude AS longitude_5
FROM
  geo_city t0
  INNER JOIN job_geo_city ON t0.id = job_geo_city.geo_city_id
WHERE
  job_geo_city.job_id = ?

SELECT t0.id AS id_1, t0.zipcode AS zipcode_2, t0.place AS place_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5 FROM geo_city t0 INNER JOIN job_geo_city ON t0.id = job_geo_city.geo_city_id WHERE job_geo_city.job_id = 178641;

SELECT
  t0.id AS id_1,
  t0.zipcode AS zipcode_2,
  t0.place AS place_3,
  t0.latitude AS latitude_4,
  t0.longitude AS longitude_5
FROM
  geo_city t0
  INNER JOIN job_geo_city ON t0.id = job_geo_city.geo_city_id
WHERE
  job_geo_city.job_id = ?

SELECT t0.id AS id_1, t0.zipcode AS zipcode_2, t0.place AS place_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5 FROM geo_city t0 INNER JOIN job_geo_city ON t0.id = job_geo_city.geo_city_id WHERE job_geo_city.job_id = 178642;

SELECT
  t0.id AS id_1,
  t0.zipcode AS zipcode_2,
  t0.place AS place_3,
  t0.latitude AS latitude_4,
  t0.longitude AS longitude_5
FROM
  geo_city t0
  INNER JOIN job_geo_city ON t0.id = job_geo_city.geo_city_id
WHERE
  job_geo_city.job_id = ?

SELECT t0.id AS id_1, t0.zipcode AS zipcode_2, t0.place AS place_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5 FROM geo_city t0 INNER JOIN job_geo_city ON t0.id = job_geo_city.geo_city_id WHERE job_geo_city.job_id = 178643;

SELECT
  t0.id AS id_1,
  t0.zipcode AS zipcode_2,
  t0.place AS place_3,
  t0.latitude AS latitude_4,
  t0.longitude AS longitude_5
FROM
  geo_city t0
  INNER JOIN job_geo_city ON t0.id = job_geo_city.geo_city_id
WHERE
  job_geo_city.job_id = ?

SELECT t0.id AS id_1, t0.zipcode AS zipcode_2, t0.place AS place_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5 FROM geo_city t0 INNER JOIN job_geo_city ON t0.id = job_geo_city.geo_city_id WHERE job_geo_city.job_id = 178644;

SELECT
  t0.id AS id_1,
  t0.zipcode AS zipcode_2,
  t0.place AS place_3,
  t0.latitude AS latitude_4,
  t0.longitude AS longitude_5
FROM
  geo_city t0
  INNER JOIN job_geo_city ON t0.id = job_geo_city.geo_city_id
WHERE
  job_geo_city.job_id = ?

SELECT t0.id AS id_1, t0.zipcode AS zipcode_2, t0.place AS place_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5 FROM geo_city t0 INNER JOIN job_geo_city ON t0.id = job_geo_city.geo_city_id WHERE job_geo_city.job_id = 178645;

SELECT
  t0.id AS id_1,
  t0.zipcode AS zipcode_2,
  t0.place AS place_3,
  t0.latitude AS latitude_4,
  t0.longitude AS longitude_5
FROM
  geo_city t0
  INNER JOIN job_geo_city ON t0.id = job_geo_city.geo_city_id
WHERE
  job_geo_city.job_id = ?

SELECT t0.id AS id_1, t0.zipcode AS zipcode_2, t0.place AS place_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5 FROM geo_city t0 INNER JOIN job_geo_city ON t0.id = job_geo_city.geo_city_id WHERE job_geo_city.job_id = 178646;

SELECT
  t0.id AS id_1,
  t0.zipcode AS zipcode_2,
  t0.place AS place_3,
  t0.latitude AS latitude_4,
  t0.longitude AS longitude_5
FROM
  geo_city t0
  INNER JOIN job_geo_city ON t0.id = job_geo_city.geo_city_id
WHERE
  job_geo_city.job_id = ?

SELECT t0.id AS id_1, t0.zipcode AS zipcode_2, t0.place AS place_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5 FROM geo_city t0 INNER JOIN job_geo_city ON t0.id = job_geo_city.geo_city_id WHERE job_geo_city.job_id = 187212;

SELECT
  t0.id AS id_1,
  t0.zipcode AS zipcode_2,
  t0.place AS place_3,
  t0.latitude AS latitude_4,
  t0.longitude AS longitude_5
FROM
  geo_city t0
  INNER JOIN job_geo_city ON t0.id = job_geo_city.geo_city_id
WHERE
  job_geo_city.job_id = ?

SELECT t0.id AS id_1, t0.zipcode AS zipcode_2, t0.place AS place_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5 FROM geo_city t0 INNER JOIN job_geo_city ON t0.id = job_geo_city.geo_city_id WHERE job_geo_city.job_id = 187215;

SELECT
  t0.id AS id_1,
  t0.zipcode AS zipcode_2,
  t0.place AS place_3,
  t0.latitude AS latitude_4,
  t0.longitude AS longitude_5
FROM
  geo_city t0
  INNER JOIN job_geo_city ON t0.id = job_geo_city.geo_city_id
WHERE
  job_geo_city.job_id = ?

SELECT t0.id AS id_1, t0.zipcode AS zipcode_2, t0.place AS place_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5 FROM geo_city t0 INNER JOIN job_geo_city ON t0.id = job_geo_city.geo_city_id WHERE job_geo_city.job_id = 187216;

SELECT
  t0.id AS id_1,
  t0.zipcode AS zipcode_2,
  t0.place AS place_3,
  t0.latitude AS latitude_4,
  t0.longitude AS longitude_5
FROM
  geo_city t0
  INNER JOIN job_geo_city ON t0.id = job_geo_city.geo_city_id
WHERE
  job_geo_city.job_id = ?

SELECT t0.id AS id_1, t0.zipcode AS zipcode_2, t0.place AS place_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5 FROM geo_city t0 INNER JOIN job_geo_city ON t0.id = job_geo_city.geo_city_id WHERE job_geo_city.job_id = 189265;

SELECT
  t0.id AS id_1,
  t0.zipcode AS zipcode_2,
  t0.place AS place_3,
  t0.latitude AS latitude_4,
  t0.longitude AS longitude_5
FROM
  geo_city t0
  INNER JOIN job_geo_city ON t0.id = job_geo_city.geo_city_id
WHERE
  job_geo_city.job_id = ?

SELECT t0.id AS id_1, t0.zipcode AS zipcode_2, t0.place AS place_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5 FROM geo_city t0 INNER JOIN job_geo_city ON t0.id = job_geo_city.geo_city_id WHERE job_geo_city.job_id = 189266;

SELECT
  t0.id AS id_1,
  t0.zipcode AS zipcode_2,
  t0.place AS place_3,
  t0.latitude AS latitude_4,
  t0.longitude AS longitude_5
FROM
  geo_city t0
  INNER JOIN job_geo_city ON t0.id = job_geo_city.geo_city_id
WHERE
  job_geo_city.job_id = ?

SELECT t0.id AS id_1, t0.zipcode AS zipcode_2, t0.place AS place_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5 FROM geo_city t0 INNER JOIN job_geo_city ON t0.id = job_geo_city.geo_city_id WHERE job_geo_city.job_id = 189267;

SELECT
  t0.id AS id_1,
  t0.zipcode AS zipcode_2,
  t0.place AS place_3,
  t0.latitude AS latitude_4,
  t0.longitude AS longitude_5
FROM
  geo_city t0
  INNER JOIN job_geo_city ON t0.id = job_geo_city.geo_city_id
WHERE
  job_geo_city.job_id = ?

SELECT t0.id AS id_1, t0.zipcode AS zipcode_2, t0.place AS place_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5 FROM geo_city t0 INNER JOIN job_geo_city ON t0.id = job_geo_city.geo_city_id WHERE job_geo_city.job_id = 189268;

SELECT
  t0.id AS id_1,
  t0.zipcode AS zipcode_2,
  t0.place AS place_3,
  t0.latitude AS latitude_4,
  t0.longitude AS longitude_5
FROM
  geo_city t0
  INNER JOIN job_geo_city ON t0.id = job_geo_city.geo_city_id
WHERE
  job_geo_city.job_id = ?

SELECT t0.id AS id_1, t0.zipcode AS zipcode_2, t0.place AS place_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5 FROM geo_city t0 INNER JOIN job_geo_city ON t0.id = job_geo_city.geo_city_id WHERE job_geo_city.job_id = 189269;

SELECT
  t0.id AS id_1,
  t0.zipcode AS zipcode_2,
  t0.place AS place_3,
  t0.latitude AS latitude_4,
  t0.longitude AS longitude_5
FROM
  geo_city t0
  INNER JOIN job_geo_city ON t0.id = job_geo_city.geo_city_id
WHERE
  job_geo_city.job_id = ?

SELECT t0.id AS id_1, t0.zipcode AS zipcode_2, t0.place AS place_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5 FROM geo_city t0 INNER JOIN job_geo_city ON t0.id = job_geo_city.geo_city_id WHERE job_geo_city.job_id = 194553;