Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.url AS url_2,
  c0_.description AS description_3,
  c0_.file_original_name AS file_original_name_4,
  c0_.archivo AS archivo_5,
  c0_.update_at AS update_at_6,
  c0_.user_id AS user_id_7
FROM
  company c0_
  LEFT JOIN job j1_ ON c0_.id = j1_.company_id
WHERE
  j1_.status = ?

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.url AS url_2, c0_.description AS description_3, c0_.file_original_name AS file_original_name_4, c0_.archivo AS archivo_5, c0_.update_at AS update_at_6, c0_.user_id AS user_id_7 FROM company c0_ LEFT JOIN job j1_ ON c0_.id = j1_.company_id WHERE j1_.status = 'job_active';

SELECT
  t0.id AS id_1,
  t0.context AS context_2,
  t0.type AS type_3,
  t0.date AS date_4,
  t0.active AS active_5,
  t0.user_id AS user_id_6
FROM
  notification t0
WHERE
  t0.user_id = ?
  AND t0.active = ?
ORDER BY
  t0.date DESC
LIMIT
  10

SELECT t0.id AS id_1, t0.context AS context_2, t0.type AS type_3, t0.date AS date_4, t0.active AS active_5, t0.user_id AS user_id_6 FROM notification t0 WHERE t0.user_id = 'anon.' AND t0.active = 1 ORDER BY t0.date DESC LIMIT 10;

SELECT
  DISTINCT j0_.localtion AS localtion_0
FROM
  job j0_

SELECT DISTINCT j0_.localtion AS localtion_0 FROM job j0_;

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
WHERE
  j0_.localtion = ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ WHERE j0_.localtion = 'Nacional';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
WHERE
  j0_.localtion = ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ WHERE j0_.localtion = 'Juan Arauz';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
WHERE
  j0_.localtion = ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ WHERE j0_.localtion = 'ffa';

SELECT
  DISTINCT c0_.id AS id_0,
  c0_.name AS name_1
FROM
  job j1_
  INNER JOIN category c0_ ON j1_.category_id = c0_.id

SELECT DISTINCT c0_.id AS id_0, c0_.name AS name_1 FROM job j1_ INNER JOIN category c0_ ON j1_.category_id = c0_.id;

SELECT
  COUNT(j0_.id) AS sclr_0
FROM
  job j0_
WHERE
  j0_.category_id = ?

SELECT COUNT(j0_.id) AS sclr_0 FROM job j0_ WHERE j0_.category_id = 4;

SELECT
  COUNT(j0_.id) AS sclr_0
FROM
  job j0_
WHERE
  j0_.category_id = ?

SELECT COUNT(j0_.id) AS sclr_0 FROM job j0_ WHERE j0_.category_id = 10;

SELECT
  COUNT(j0_.id) AS sclr_0
FROM
  job j0_
WHERE
  j0_.category_id = ?

SELECT COUNT(j0_.id) AS sclr_0 FROM job j0_ WHERE j0_.category_id = 35;

SELECT
  DISTINCT s0_.name AS name_0
FROM
  job j1_
  INNER JOIN state s0_ ON j1_.city_id = s0_.id

SELECT DISTINCT s0_.name AS name_0 FROM job j1_ INNER JOIN state s0_ ON j1_.city_id = s0_.id;

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
WHERE
  j0_.city_id = ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ WHERE j0_.city_id = 'Galápagos';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.description AS description_4,
  t0.file_original_name AS file_original_name_5,
  t0.archivo AS archivo_6,
  t0.update_at AS update_at_7,
  t0.user_id AS user_id_8
FROM
  company t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.description AS description_4, t0.file_original_name AS file_original_name_5, t0.archivo AS archivo_6, t0.update_at AS update_at_7, t0.user_id AS user_id_8 FROM company t0;