Symfony Profiler

SELECT
  j0_.id AS id_0,
  j0_.title AS title_1,
  j0_.localtion AS localtion_2,
  j0_.type AS type_3,
  j0_.experience AS experience_4,
  j0_.salary_max AS salary_max_5,
  j0_.salary_min AS salary_min_6,
  j0_.qualification AS qualification_7,
  j0_.date AS date_8,
  j0_.date_created AS date_created_9,
  j0_.description AS description_10,
  j0_.responsabilities AS responsabilities_11,
  j0_.education AS education_12,
  j0_.others AS others_13,
  j0_.zip_code AS zip_code_14,
  j0_.your_localtion AS your_localtion_15,
  j0_.company_name AS company_name_16,
  j0_.web_address AS web_address_17,
  j0_.campany_profile AS campany_profile_18,
  j0_.image AS image_19,
  j0_.gender AS gender_20,
  j0_.status AS status_21,
  j0_.expired_date AS expired_date_22,
  j0_.applications AS applications_23,
  j0_.video_link AS video_link_24,
  j0_.images AS images_25,
  j0_.category_id AS category_id_26,
  j0_.country_id AS country_id_27,
  j0_.city_id AS city_id_28,
  j0_.user_id AS user_id_29,
  j0_.service_id AS service_id_30,
  j0_.company_id AS company_id_31
FROM
  job j0_
WHERE
  j0_.city_id = ?
ORDER BY
  j0_.date_created DESC

SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.localtion AS localtion_2, j0_.type AS type_3, j0_.experience AS experience_4, j0_.salary_max AS salary_max_5, j0_.salary_min AS salary_min_6, j0_.qualification AS qualification_7, j0_.date AS date_8, j0_.date_created AS date_created_9, j0_.description AS description_10, j0_.responsabilities AS responsabilities_11, j0_.education AS education_12, j0_.others AS others_13, j0_.zip_code AS zip_code_14, j0_.your_localtion AS your_localtion_15, j0_.company_name AS company_name_16, j0_.web_address AS web_address_17, j0_.campany_profile AS campany_profile_18, j0_.image AS image_19, j0_.gender AS gender_20, j0_.status AS status_21, j0_.expired_date AS expired_date_22, j0_.applications AS applications_23, j0_.video_link AS video_link_24, j0_.images AS images_25, j0_.category_id AS category_id_26, j0_.country_id AS country_id_27, j0_.city_id AS city_id_28, j0_.user_id AS user_id_29, j0_.service_id AS service_id_30, j0_.company_id AS company_id_31 FROM job j0_ WHERE j0_.city_id = 'Galápagos' ORDER BY j0_.date_created DESC;

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

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;

SELECT
  c0_.name AS name_0,
  c0_.id AS id_1
FROM
  category c0_

SELECT c0_.name AS name_0, c0_.id AS id_1 FROM category c0_;

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Comercialización & Ventas%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Administración de Empresas%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Asesoría Contable%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Atención al cliente%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Abastecimiento y logística%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Aduana y Comercio Exterior%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Asesores Comerciales%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Asistente de gerencia%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Asistente comercial%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Auxiliar de bodega%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Auxiliar contable%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Auxiliar de enfermería%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Cajero (a)%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Chofer%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Agricultura%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Comercialización & Ventas%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Comunicaciones & Relaciones Públicas%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Costurera-Modista-Sastre%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Contador%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Biólogo%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Botánico%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Diseño Gráfico%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Diseño de interiores%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Economista%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Electricista%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Enfermería%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Gastronomía & Turismo%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Geógrafo%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Gerencia & Dirección General%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Historiador%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Ingeniería Civil y Construcción%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Ingeniería Ambiental%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Ingeniería Mecánica%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Ingeniería%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Instructor - Capacitador%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Jefe de agencia%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Legales%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Marketing & Publicidad%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Medicina - Salud - Farmacia%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Minería, petróleo y gas%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Oficios y otros%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Paramédicos%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Periodismo%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Psicología Educativa%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Psicología Industrial%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Pasantías%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Producción y manufactura%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Secretarias%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Seguridad - Guardianía%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Seguridad Industrial%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Recursos Humanos%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Servicios Bancarios%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Promotores de ventas%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Tecnología, sistemas y telecomunicaciones%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Mantenimiento y servicios%';

SELECT
  count(j0_.id) AS sclr_0
FROM
  job j0_
  INNER JOIN category c1_ ON j0_.category_id = c1_.id
WHERE
  c1_.name LIKE ?

SELECT count(j0_.id) AS sclr_0 FROM job j0_ INNER JOIN category c1_ ON j0_.category_id = c1_.id WHERE c1_.name LIKE '%Parvularias%';

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';