Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.about_me AS about_me_2,
  t0.cv AS cv_3,
  t0.cart AS cart_4,
  t0.updated_at AS updated_at_5,
  t0.user_id AS user_id_6,
  t0.record_id AS record_id_7,
  t0.experience_id AS experience_id_8,
  t0.skils_id AS skils_id_9,
  t0.calification_id AS calification_id_10
FROM
  resume t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.about_me AS about_me_2, t0.cv AS cv_3, t0.cart AS cart_4, t0.updated_at AS updated_at_5, t0.user_id AS user_id_6, t0.record_id AS record_id_7, t0.experience_id AS experience_id_8, t0.skils_id AS skils_id_9, t0.calification_id AS calification_id_10 FROM resume t0 WHERE t0.user_id = 10;

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.user_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.user_id = 10;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.localtion AS localtion_3,
  t0.type AS type_4,
  t0.experience AS experience_5,
  t0.salary_max AS salary_max_6,
  t0.salary_min AS salary_min_7,
  t0.qualification AS qualification_8,
  t0.date AS date_9,
  t0.date_created AS date_created_10,
  t0.description AS description_11,
  t0.responsabilities AS responsabilities_12,
  t0.education AS education_13,
  t0.others AS others_14,
  t0.zip_code AS zip_code_15,
  t0.your_localtion AS your_localtion_16,
  t0.company_name AS company_name_17,
  t0.web_address AS web_address_18,
  t0.campany_profile AS campany_profile_19,
  t0.image AS image_20,
  t0.gender AS gender_21,
  t0.status AS status_22,
  t0.expired_date AS expired_date_23,
  t0.applications AS applications_24,
  t0.video_link AS video_link_25,
  t0.images AS images_26,
  t0.category_id AS category_id_27,
  t0.country_id AS country_id_28,
  t0.city_id AS city_id_29,
  t0.user_id AS user_id_30,
  t0.service_id AS service_id_31,
  t0.company_id AS company_id_32
FROM
  job t0
WHERE
  t0.company_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.localtion AS localtion_3, t0.type AS type_4, t0.experience AS experience_5, t0.salary_max AS salary_max_6, t0.salary_min AS salary_min_7, t0.qualification AS qualification_8, t0.date AS date_9, t0.date_created AS date_created_10, t0.description AS description_11, t0.responsabilities AS responsabilities_12, t0.education AS education_13, t0.others AS others_14, t0.zip_code AS zip_code_15, t0.your_localtion AS your_localtion_16, t0.company_name AS company_name_17, t0.web_address AS web_address_18, t0.campany_profile AS campany_profile_19, t0.image AS image_20, t0.gender AS gender_21, t0.status AS status_22, t0.expired_date AS expired_date_23, t0.applications AS applications_24, t0.video_link AS video_link_25, t0.images AS images_26, t0.category_id AS category_id_27, t0.country_id AS country_id_28, t0.city_id AS city_id_29, t0.user_id AS user_id_30, t0.service_id AS service_id_31, t0.company_id AS company_id_32 FROM job t0 WHERE t0.company_id = 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.localtion AS localtion_3,
  t0.type AS type_4,
  t0.experience AS experience_5,
  t0.salary_max AS salary_max_6,
  t0.salary_min AS salary_min_7,
  t0.qualification AS qualification_8,
  t0.date AS date_9,
  t0.date_created AS date_created_10,
  t0.description AS description_11,
  t0.responsabilities AS responsabilities_12,
  t0.education AS education_13,
  t0.others AS others_14,
  t0.zip_code AS zip_code_15,
  t0.your_localtion AS your_localtion_16,
  t0.company_name AS company_name_17,
  t0.web_address AS web_address_18,
  t0.campany_profile AS campany_profile_19,
  t0.image AS image_20,
  t0.gender AS gender_21,
  t0.status AS status_22,
  t0.expired_date AS expired_date_23,
  t0.applications AS applications_24,
  t0.video_link AS video_link_25,
  t0.images AS images_26,
  t0.category_id AS category_id_27,
  t0.country_id AS country_id_28,
  t0.city_id AS city_id_29,
  t0.user_id AS user_id_30,
  t0.service_id AS service_id_31,
  t0.company_id AS company_id_32
FROM
  job t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.localtion AS localtion_3, t0.type AS type_4, t0.experience AS experience_5, t0.salary_max AS salary_max_6, t0.salary_min AS salary_min_7, t0.qualification AS qualification_8, t0.date AS date_9, t0.date_created AS date_created_10, t0.description AS description_11, t0.responsabilities AS responsabilities_12, t0.education AS education_13, t0.others AS others_14, t0.zip_code AS zip_code_15, t0.your_localtion AS your_localtion_16, t0.company_name AS company_name_17, t0.web_address AS web_address_18, t0.campany_profile AS campany_profile_19, t0.image AS image_20, t0.gender AS gender_21, t0.status AS status_22, t0.expired_date AS expired_date_23, t0.applications AS applications_24, t0.video_link AS video_link_25, t0.images AS images_26, t0.category_id AS category_id_27, t0.country_id AS country_id_28, t0.city_id AS city_id_29, t0.user_id AS user_id_30, t0.service_id AS service_id_31, t0.company_id AS company_id_32 FROM job t0;

SELECT
  f0_.username AS username_0,
  f0_.username_canonical AS username_canonical_1,
  f0_.email AS email_2,
  f0_.email_canonical AS email_canonical_3,
  f0_.enabled AS enabled_4,
  f0_.salt AS salt_5,
  f0_.password AS password_6,
  f0_.last_login AS last_login_7,
  f0_.confirmation_token AS confirmation_token_8,
  f0_.password_requested_at AS password_requested_at_9,
  f0_.roles AS roles_10,
  f0_.id AS id_11,
  f0_.name AS name_12,
  f0_.employer AS employer_13,
  f0_.buy_free_pack_service AS buy_free_pack_service_14,
  f0_.candidate AS candidate_15,
  f0_.buy_free_pack_job AS buy_free_pack_job_16,
  f0_.image AS image_17,
  f0_.company_name AS company_name_18,
  f0_.phone AS phone_19,
  f0_.address AS address_20,
  f0_.about AS about_21,
  f0_.video_intro AS video_intro_22,
  f0_.social_facebook AS social_facebook_23,
  f0_.social_twitter AS social_twitter_24,
  f0_.social_google AS social_google_25,
  f0_.updated_at AS updated_at_26,
  f0_.status AS status_27,
  f0_.experience AS experience_28,
  f0_.gender AS gender_29,
  f0_.age AS age_30,
  f0_.social_links AS social_links_31,
  f0_.country AS country_32,
  f0_.bookmarked AS bookmarked_33,
  f0_.applied AS applied_34,
  f0_.companies_seen AS companies_seen_35,
  f0_.secret AS secret_36,
  f0_.verificated AS verificated_37,
  f0_.date_of_purchase AS date_of_purchase_38,
  f0_.date_of_purchase_service AS date_of_purchase_service_39,
  f0_.num_posts AS num_posts_40,
  f0_.num_posts_services AS num_posts_services_41,
  f0_.services_request AS services_request_42,
  f0_.candidates AS candidates_43,
  f0_.ruc AS ruc_44,
  f0_.higher_level_titlee_id AS higher_level_titlee_id_45,
  f0_.profession_id AS profession_id_46
FROM
  fos_user f0_
WHERE
  f0_.roles LIKE ?

SELECT f0_.username AS username_0, f0_.username_canonical AS username_canonical_1, f0_.email AS email_2, f0_.email_canonical AS email_canonical_3, f0_.enabled AS enabled_4, f0_.salt AS salt_5, f0_.password AS password_6, f0_.last_login AS last_login_7, f0_.confirmation_token AS confirmation_token_8, f0_.password_requested_at AS password_requested_at_9, f0_.roles AS roles_10, f0_.id AS id_11, f0_.name AS name_12, f0_.employer AS employer_13, f0_.buy_free_pack_service AS buy_free_pack_service_14, f0_.candidate AS candidate_15, f0_.buy_free_pack_job AS buy_free_pack_job_16, f0_.image AS image_17, f0_.company_name AS company_name_18, f0_.phone AS phone_19, f0_.address AS address_20, f0_.about AS about_21, f0_.video_intro AS video_intro_22, f0_.social_facebook AS social_facebook_23, f0_.social_twitter AS social_twitter_24, f0_.social_google AS social_google_25, f0_.updated_at AS updated_at_26, f0_.status AS status_27, f0_.experience AS experience_28, f0_.gender AS gender_29, f0_.age AS age_30, f0_.social_links AS social_links_31, f0_.country AS country_32, f0_.bookmarked AS bookmarked_33, f0_.applied AS applied_34, f0_.companies_seen AS companies_seen_35, f0_.secret AS secret_36, f0_.verificated AS verificated_37, f0_.date_of_purchase AS date_of_purchase_38, f0_.date_of_purchase_service AS date_of_purchase_service_39, f0_.num_posts AS num_posts_40, f0_.num_posts_services AS num_posts_services_41, f0_.services_request AS services_request_42, f0_.candidates AS candidates_43, f0_.ruc AS ruc_44, f0_.higher_level_titlee_id AS higher_level_titlee_id_45, f0_.profession_id AS profession_id_46 FROM fos_user f0_ WHERE f0_.roles LIKE '%ROLE_ADMIN%';

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
  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_.category_id = ?

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

SELECT
  DISTINCT j0_.localtion AS localtion_0
FROM
  job j0_

SELECT DISTINCT j0_.localtion AS localtion_0 FROM job j0_;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.type AS type_3,
  t0.experience AS experience_4,
  t0.value AS value_5,
  t0.description AS description_6,
  t0.location AS location_7,
  t0.addres1 AS addres1_8,
  t0.addres2 AS addres2_9,
  t0.state AS state_10,
  t0.postal_code AS postal_code_11,
  t0.contact AS contact_12,
  t0.video_link AS video_link_13,
  t0.image AS image_14,
  t0.date AS date_15,
  t0.expired_date AS expired_date_16,
  t0.status AS status_17,
  t0.profession_id AS profession_id_18,
  t0.country_id AS country_id_19,
  t0.city_id AS city_id_20,
  t0.user_id AS user_id_21
FROM
  anouncement t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.experience AS experience_4, t0.value AS value_5, t0.description AS description_6, t0.location AS location_7, t0.addres1 AS addres1_8, t0.addres2 AS addres2_9, t0.state AS state_10, t0.postal_code AS postal_code_11, t0.contact AS contact_12, t0.video_link AS video_link_13, t0.image AS image_14, t0.date AS date_15, t0.expired_date AS expired_date_16, t0.status AS status_17, t0.profession_id AS profession_id_18, t0.country_id AS country_id_19, t0.city_id AS city_id_20, t0.user_id AS user_id_21 FROM anouncement t0;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.localtion AS localtion_3,
  t0.type AS type_4,
  t0.experience AS experience_5,
  t0.salary_max AS salary_max_6,
  t0.salary_min AS salary_min_7,
  t0.qualification AS qualification_8,
  t0.date AS date_9,
  t0.date_created AS date_created_10,
  t0.description AS description_11,
  t0.responsabilities AS responsabilities_12,
  t0.education AS education_13,
  t0.others AS others_14,
  t0.zip_code AS zip_code_15,
  t0.your_localtion AS your_localtion_16,
  t0.company_name AS company_name_17,
  t0.web_address AS web_address_18,
  t0.campany_profile AS campany_profile_19,
  t0.image AS image_20,
  t0.gender AS gender_21,
  t0.status AS status_22,
  t0.expired_date AS expired_date_23,
  t0.applications AS applications_24,
  t0.video_link AS video_link_25,
  t0.images AS images_26,
  t0.category_id AS category_id_27,
  t0.country_id AS country_id_28,
  t0.city_id AS city_id_29,
  t0.user_id AS user_id_30,
  t0.service_id AS service_id_31,
  t0.company_id AS company_id_32
FROM
  job t0
WHERE
  t0.status = ?
ORDER BY
  t0.date_created DESC
LIMIT
  10

SELECT t0.id AS id_1, t0.title AS title_2, t0.localtion AS localtion_3, t0.type AS type_4, t0.experience AS experience_5, t0.salary_max AS salary_max_6, t0.salary_min AS salary_min_7, t0.qualification AS qualification_8, t0.date AS date_9, t0.date_created AS date_created_10, t0.description AS description_11, t0.responsabilities AS responsabilities_12, t0.education AS education_13, t0.others AS others_14, t0.zip_code AS zip_code_15, t0.your_localtion AS your_localtion_16, t0.company_name AS company_name_17, t0.web_address AS web_address_18, t0.campany_profile AS campany_profile_19, t0.image AS image_20, t0.gender AS gender_21, t0.status AS status_22, t0.expired_date AS expired_date_23, t0.applications AS applications_24, t0.video_link AS video_link_25, t0.images AS images_26, t0.category_id AS category_id_27, t0.country_id AS country_id_28, t0.city_id AS city_id_29, t0.user_id AS user_id_30, t0.service_id AS service_id_31, t0.company_id AS company_id_32 FROM job t0 WHERE t0.status = 'job_active' ORDER BY t0.date_created DESC LIMIT 10;

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
  t0.id AS id_1,
  t0.title AS title_2,
  t0.type AS type_3,
  t0.experience AS experience_4,
  t0.value AS value_5,
  t0.description AS description_6,
  t0.location AS location_7,
  t0.addres1 AS addres1_8,
  t0.addres2 AS addres2_9,
  t0.state AS state_10,
  t0.postal_code AS postal_code_11,
  t0.contact AS contact_12,
  t0.video_link AS video_link_13,
  t0.image AS image_14,
  t0.date AS date_15,
  t0.expired_date AS expired_date_16,
  t0.status AS status_17,
  t0.profession_id AS profession_id_18,
  t0.country_id AS country_id_19,
  t0.city_id AS city_id_20,
  t0.user_id AS user_id_21
FROM
  anouncement t0
WHERE
  t0.status = ?
ORDER BY
  t0.date DESC
LIMIT
  10

SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.experience AS experience_4, t0.value AS value_5, t0.description AS description_6, t0.location AS location_7, t0.addres1 AS addres1_8, t0.addres2 AS addres2_9, t0.state AS state_10, t0.postal_code AS postal_code_11, t0.contact AS contact_12, t0.video_link AS video_link_13, t0.image AS image_14, t0.date AS date_15, t0.expired_date AS expired_date_16, t0.status AS status_17, t0.profession_id AS profession_id_18, t0.country_id AS country_id_19, t0.city_id AS city_id_20, t0.user_id AS user_id_21 FROM anouncement t0 WHERE t0.status = 'job_active' ORDER BY t0.date DESC LIMIT 10;

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.title AS title_2,
  t0.short_description AS short_description_3,
  t0.image AS image_4,
  t0.update_at AS update_at_5,
  t0.active AS active_6,
  t0.url AS url_7
FROM
  slide t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.short_description AS short_description_3, t0.image AS image_4, t0.update_at AS update_at_5, t0.active AS active_6, t0.url AS url_7 FROM slide 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

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;