Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.title AS title_4,
  t0.slug AS slug_5,
  t0.url AS url_6,
  t0.visibility AS visibility_7,
  t0.type AS type_8
FROM
  seo_redirection t0
WHERE
  t0.slug = ?
  AND t0.visibility = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.title AS title_4, t0.slug AS slug_5, t0.url AS url_6, t0.visibility AS visibility_7, t0.type AS type_8 FROM seo_redirection t0 WHERE t0.slug = 'cvs/anonyme/fo9anMqpdy' AND t0.visibility = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.name AS name_4,
  t0.lastname AS lastname_5,
  t0.phone AS phone_6,
  t0.email AS email_7,
  t0.address AS address_8,
  t0.city AS city_9,
  t0.zipcode AS zipcode_10,
  t0.country AS country_11,
  t0.slug AS slug_12,
  t0.slug_anonyme AS slug_anonyme_13,
  t0.title_job AS title_job_14,
  t0.description_cover AS description_cover_15,
  t0.description_cover_anonyme AS description_cover_anonyme_16,
  t0.description_services AS description_services_17,
  t0.description_services_anonyme AS description_services_anonyme_18,
  t0.description_cta AS description_cta_19,
  t0.description_cta_anonyme AS description_cta_anonyme_20,
  t0.description AS description_21,
  t0.description_anonyme AS description_anonyme_22,
  t0.description_experience AS description_experience_23,
  t0.description_experience_anonyme AS description_experience_anonyme_24,
  t0.website_url AS website_url_25,
  t0.linkedin_url AS linkedin_url_26,
  t0.salary AS salary_27,
  t0.freelance AS freelance_28,
  t0.alternance AS alternance_29,
  t0.stage AS stage_30,
  t0.on_search AS on_search_31,
  t0.on_discussion AS on_discussion_32,
  t0.notifications AS notifications_33,
  t0.online AS online_34,
  t0.online_classic AS online_classic_35,
  t0.invitation_code AS invitation_code_36,
  t0.invitation_code_anonyme AS invitation_code_anonyme_37,
  t0.views AS views_38,
  t0.exp_years AS exp_years_39,
  t0.views_anonyme AS views_anonyme_40,
  t0.first AS first_41,
  t0.point_x AS point_x_42,
  t0.point_y AS point_y_43,
  t0.category_id AS category_id_44
FROM
  cvs_candidates t0
WHERE
  t0.slug_anonyme = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.name AS name_4, t0.lastname AS lastname_5, t0.phone AS phone_6, t0.email AS email_7, t0.address AS address_8, t0.city AS city_9, t0.zipcode AS zipcode_10, t0.country AS country_11, t0.slug AS slug_12, t0.slug_anonyme AS slug_anonyme_13, t0.title_job AS title_job_14, t0.description_cover AS description_cover_15, t0.description_cover_anonyme AS description_cover_anonyme_16, t0.description_services AS description_services_17, t0.description_services_anonyme AS description_services_anonyme_18, t0.description_cta AS description_cta_19, t0.description_cta_anonyme AS description_cta_anonyme_20, t0.description AS description_21, t0.description_anonyme AS description_anonyme_22, t0.description_experience AS description_experience_23, t0.description_experience_anonyme AS description_experience_anonyme_24, t0.website_url AS website_url_25, t0.linkedin_url AS linkedin_url_26, t0.salary AS salary_27, t0.freelance AS freelance_28, t0.alternance AS alternance_29, t0.stage AS stage_30, t0.on_search AS on_search_31, t0.on_discussion AS on_discussion_32, t0.notifications AS notifications_33, t0.online AS online_34, t0.online_classic AS online_classic_35, t0.invitation_code AS invitation_code_36, t0.invitation_code_anonyme AS invitation_code_anonyme_37, t0.views AS views_38, t0.exp_years AS exp_years_39, t0.views_anonyme AS views_anonyme_40, t0.first AS first_41, t0.point_x AS point_x_42, t0.point_y AS point_y_43, t0.category_id AS category_id_44 FROM cvs_candidates t0 WHERE t0.slug_anonyme = 'fo9anMqpdy' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.title AS title_4,
  t0.description_anonyme AS description_anonyme_5,
  t0.description AS description_6,
  t0.online AS online_7,
  t0.candidate_id AS candidate_id_8
FROM
  cvs_candidates_has_services t0
WHERE
  t0.candidate_id = ?
ORDER BY
  t0.title ASC

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.title AS title_4, t0.description_anonyme AS description_anonyme_5, t0.description AS description_6, t0.online AS online_7, t0.candidate_id AS candidate_id_8 FROM cvs_candidates_has_services t0 WHERE t0.candidate_id = 1 ORDER BY t0.title ASC;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.title AS title_4,
  t0.description AS description_5,
  t0.fav AS fav_6,
  t0.candidate_id AS candidate_id_7
FROM
  cvs_candidates_has_skills t0
WHERE
  t0.candidate_id = ?
ORDER BY
  t0.title ASC

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.title AS title_4, t0.description AS description_5, t0.fav AS fav_6, t0.candidate_id AS candidate_id_7 FROM cvs_candidates_has_skills t0 WHERE t0.candidate_id = 1 ORDER BY t0.title ASC;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.title AS title_4,
  t0.description_anonyme AS description_anonyme_5,
  t0.description AS description_6,
  t0.enterprise_name AS enterprise_name_7,
  t0.type_enterprise AS type_enterprise_8,
  t0.total_month AS total_month_9,
  t0.website_url AS website_url_10,
  t0.no_anonyme AS no_anonyme_11,
  t0.online AS online_12,
  t0.candidate_id AS candidate_id_13
FROM
  cvs_candidates_has_projects t0
WHERE
  t0.candidate_id = ?
ORDER BY
  t0.title ASC

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.title AS title_4, t0.description_anonyme AS description_anonyme_5, t0.description AS description_6, t0.enterprise_name AS enterprise_name_7, t0.type_enterprise AS type_enterprise_8, t0.total_month AS total_month_9, t0.website_url AS website_url_10, t0.no_anonyme AS no_anonyme_11, t0.online AS online_12, t0.candidate_id AS candidate_id_13 FROM cvs_candidates_has_projects t0 WHERE t0.candidate_id = 1 ORDER BY t0.title ASC;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.start AS start_4,
  t0.end AS end_5,
  t0.today AS today_6,
  t0.title AS title_7,
  t0.description_anonyme AS description_anonyme_8,
  t0.description AS description_9,
  t0.enterprise_name AS enterprise_name_10,
  t0.type_enterprise AS type_enterprise_11,
  t0.school_name AS school_name_12,
  t0.diploma AS diploma_13,
  t0.no_anonyme AS no_anonyme_14,
  t0.online AS online_15,
  t0.candidate_id AS candidate_id_16
FROM
  cvs_candidates_has_experiences t0
WHERE
  t0.candidate_id = ?
ORDER BY
  t0.start DESC

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.start AS start_4, t0.end AS end_5, t0.today AS today_6, t0.title AS title_7, t0.description_anonyme AS description_anonyme_8, t0.description AS description_9, t0.enterprise_name AS enterprise_name_10, t0.type_enterprise AS type_enterprise_11, t0.school_name AS school_name_12, t0.diploma AS diploma_13, t0.no_anonyme AS no_anonyme_14, t0.online AS online_15, t0.candidate_id AS candidate_id_16 FROM cvs_candidates_has_experiences t0 WHERE t0.candidate_id = 1 ORDER BY t0.start DESC;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  cvs_candidates
SET
  views_anonyme = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE cvs_candidates SET views_anonyme = 20, updated_at = '2024-11-21 12:49:53' WHERE id = 1;

"COMMIT"

"COMMIT";

SELECT
  c0_.id AS id_0,
  c0_.created_at AS created_at_1,
  c0_.updated_at AS updated_at_2,
  c0_.title_page AS title_page_3,
  c0_.name AS name_4,
  c0_.description AS description_5,
  c0_.sequence AS sequence_6,
  c0_.type AS type_7,
  c0_.category AS category_8,
  c0_.type_website AS type_website_9,
  c0_.tool_id AS tool_id_10
FROM
  core_tools c0_
WHERE
  c0_.type_website LIKE ?
ORDER BY
  c0_.id ASC

SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.title_page AS title_page_3, c0_.name AS name_4, c0_.description AS description_5, c0_.sequence AS sequence_6, c0_.type AS type_7, c0_.category AS category_8, c0_.type_website AS type_website_9, c0_.tool_id AS tool_id_10 FROM core_tools c0_ WHERE c0_.type_website LIKE '%blog%' ORDER BY c0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.title AS title_3,
  t0.link AS link_4,
  t0.visibility AS visibility_5,
  t0.target_blank AS target_blank_6,
  t0.type AS type_7,
  t0.sequence AS sequence_8,
  t0.typeButton AS typeButton_9,
  t0.visibilityUser AS visibilityUser_10,
  t0.private AS private_11,
  t0.no_private AS no_private_12
FROM
  menu_website_parents t0
WHERE
  t0.type = ?
  AND t0.no_private = ?
ORDER BY
  t0.sequence ASC

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.title AS title_3, t0.link AS link_4, t0.visibility AS visibility_5, t0.target_blank AS target_blank_6, t0.type AS type_7, t0.sequence AS sequence_8, t0.typeButton AS typeButton_9, t0.visibilityUser AS visibilityUser_10, t0.private AS private_11, t0.no_private AS no_private_12 FROM menu_website_parents t0 WHERE t0.type = 'footer' AND t0.no_private = 1 ORDER BY t0.sequence ASC;