Symfony Profiler

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
  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
WHERE
  t0.id = ?

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 WHERE t0.id = '4';

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_.company_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_.company_id = 4 ORDER BY j0_.date_created 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
  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
  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
  DISTINCT j0_.localtion AS localtion_0
FROM
  job j0_

SELECT DISTINCT j0_.localtion AS localtion_0 FROM job j0_;