Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.uri_test AS uri_test_3,
  t0.db_name_test AS db_name_test_4,
  t0.db_user_test AS db_user_test_5,
  t0.db_password_test AS db_password_test_6,
  t0.uri_prod AS uri_prod_7,
  t0.db_name_prod AS db_name_prod_8,
  t0.db_user_prod AS db_user_prod_9,
  t0.db_password_prod AS db_password_prod_10,
  t0.css_path_test AS css_path_test_11,
  t0.css_path_prod AS css_path_prod_12,
  t0.deepl_api_key AS deepl_api_key_13
FROM
  project t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.uri_test AS uri_test_3, t0.db_name_test AS db_name_test_4, t0.db_user_test AS db_user_test_5, t0.db_password_test AS db_password_test_6, t0.uri_prod AS uri_prod_7, t0.db_name_prod AS db_name_prod_8, t0.db_user_prod AS db_user_prod_9, t0.db_password_prod AS db_password_prod_10, t0.css_path_test AS css_path_test_11, t0.css_path_prod AS css_path_prod_12, t0.deepl_api_key AS deepl_api_key_13 FROM project t0 WHERE t0.id = 17;

SELECT
  l0_.id AS id_0,
  l0_.name AS name_1,
  l0_.locale AS locale_2,
  l0_.is_right_to_left AS is_right_to_left_3,
  l0_.short AS short_4
FROM
  language l0_
  INNER JOIN language_project l1_ ON l0_.id = l1_.language_id
  INNER JOIN project p2_ ON l1_.project_id = p2_.id
WHERE
  p2_.id = ?
ORDER BY
  l1_.is_default DESC
LIMIT
  1

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.locale AS locale_2, l0_.is_right_to_left AS is_right_to_left_3, l0_.short AS short_4 FROM language l0_ INNER JOIN language_project l1_ ON l0_.id = l1_.language_id INNER JOIN project p2_ ON l1_.project_id = p2_.id WHERE p2_.id = 17 ORDER BY l1_.is_default DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.password AS password_3,
  t0.name AS name_4,
  t0.phone AS phone_5,
  t0.is_greendot AS is_greendot_6
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.name AS name_4, t0.phone AS phone_5, t0.is_greendot AS is_greendot_6 FROM user t0 WHERE t0.id = 24;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.uri_test AS uri_test_3,
  t0.db_name_test AS db_name_test_4,
  t0.db_user_test AS db_user_test_5,
  t0.db_password_test AS db_password_test_6,
  t0.uri_prod AS uri_prod_7,
  t0.db_name_prod AS db_name_prod_8,
  t0.db_user_prod AS db_user_prod_9,
  t0.db_password_prod AS db_password_prod_10,
  t0.css_path_test AS css_path_test_11,
  t0.css_path_prod AS css_path_prod_12,
  t0.deepl_api_key AS deepl_api_key_13
FROM
  project t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.uri_test AS uri_test_3, t0.db_name_test AS db_name_test_4, t0.db_user_test AS db_user_test_5, t0.db_password_test AS db_password_test_6, t0.uri_prod AS uri_prod_7, t0.db_name_prod AS db_name_prod_8, t0.db_user_prod AS db_user_prod_9, t0.db_password_prod AS db_password_prod_10, t0.css_path_test AS css_path_test_11, t0.css_path_prod AS css_path_prod_12, t0.deepl_api_key AS deepl_api_key_13 FROM project t0;

SELECT
  i0_.id AS id_0,
  i0_.name AS name_1,
  i0_.title AS title_2,
  i0_.text AS text_3,
  i0_.is_active AS is_active_4,
  i0_.is_reusable AS is_reusable_5,
  i0_.state AS state_6,
  i1_.id AS id_7,
  i1_.name AS name_8,
  i1_.template AS template_9,
  c2_.id AS id_10,
  c2_.sequence AS sequence_11,
  p3_.id AS id_12,
  p3_.sequence AS sequence_13,
  e4_.id AS id_14,
  e4_.sequence AS sequence_15,
  p5_.id AS id_16,
  p5_.sequence AS sequence_17,
  i0_.information_block_type_id AS information_block_type_id_18,
  c2_.information_block_id AS information_block_id_19,
  c2_.category_id AS category_id_20,
  p3_.information_block_id AS information_block_id_21,
  p3_.product_id AS product_id_22,
  e4_.information_block_id AS information_block_id_23,
  e4_.event_id AS event_id_24,
  p5_.information_block_id AS information_block_id_25,
  p5_.person_id AS person_id_26
FROM
  information_block i0_
  LEFT JOIN information_block_type i1_ ON i0_.information_block_type_id = i1_.id
  LEFT JOIN category_information_block c2_ ON i0_.id = c2_.information_block_id
  LEFT JOIN product_information_block p3_ ON i0_.id = p3_.information_block_id
  LEFT JOIN event_information_block e4_ ON i0_.id = e4_.information_block_id
  LEFT JOIN person_information_block p5_ ON i0_.id = p5_.information_block_id
WHERE
  i0_.id = ?

SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.title AS title_2, i0_.text AS text_3, i0_.is_active AS is_active_4, i0_.is_reusable AS is_reusable_5, i0_.state AS state_6, i1_.id AS id_7, i1_.name AS name_8, i1_.template AS template_9, c2_.id AS id_10, c2_.sequence AS sequence_11, p3_.id AS id_12, p3_.sequence AS sequence_13, e4_.id AS id_14, e4_.sequence AS sequence_15, p5_.id AS id_16, p5_.sequence AS sequence_17, i0_.information_block_type_id AS information_block_type_id_18, c2_.information_block_id AS information_block_id_19, c2_.category_id AS category_id_20, p3_.information_block_id AS information_block_id_21, p3_.product_id AS product_id_22, e4_.information_block_id AS information_block_id_23, e4_.event_id AS event_id_24, p5_.information_block_id AS information_block_id_25, p5_.person_id AS person_id_26 FROM information_block i0_ LEFT JOIN information_block_type i1_ ON i0_.information_block_type_id = i1_.id LEFT JOIN category_information_block c2_ ON i0_.id = c2_.information_block_id LEFT JOIN product_information_block p3_ ON i0_.id = p3_.information_block_id LEFT JOIN event_information_block e4_ ON i0_.id = e4_.information_block_id LEFT JOIN person_information_block p5_ ON i0_.id = p5_.information_block_id WHERE i0_.id = 125;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  information_block
SET
  is_active = ?
WHERE
  id = ?

UPDATE information_block SET is_active = 0 WHERE id = 125;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title AS title_3,
  t0.text AS text_4,
  t0.is_active AS is_active_5,
  t0.is_reusable AS is_reusable_6,
  t0.state AS state_7,
  t0.information_block_type_id AS information_block_type_id_8
FROM
  information_block t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.text AS text_4, t0.is_active AS is_active_5, t0.is_reusable AS is_reusable_6, t0.state AS state_7, t0.information_block_type_id AS information_block_type_id_8 FROM information_block t0 WHERE t0.id = 125;

SELECT
  t0.id AS id_1,
  t0.sequence AS sequence_2,
  t0.information_block_id AS information_block_id_3,
  t0.category_id AS category_id_4
FROM
  category_information_block t0
WHERE
  t0.information_block_id = ?

SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.information_block_id AS information_block_id_3, t0.category_id AS category_id_4 FROM category_information_block t0 WHERE t0.information_block_id = 125;

SELECT
  t0.id AS id_1,
  t0.sequence AS sequence_2,
  t0.information_block_id AS information_block_id_3,
  t0.product_id AS product_id_4
FROM
  product_information_block t0
WHERE
  t0.information_block_id = ?

SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.information_block_id AS information_block_id_3, t0.product_id AS product_id_4 FROM product_information_block t0 WHERE t0.information_block_id = 125;

SELECT
  t0.id AS id_1,
  t0.sequence AS sequence_2,
  t0.information_block_id AS information_block_id_3,
  t0.event_id AS event_id_4
FROM
  event_information_block t0
WHERE
  t0.information_block_id = ?

SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.information_block_id AS information_block_id_3, t0.event_id AS event_id_4 FROM event_information_block t0 WHERE t0.information_block_id = 125;

SELECT
  t0.id AS id_1,
  t0.sequence AS sequence_2,
  t0.information_block_id AS information_block_id_3,
  t0.person_id AS person_id_4
FROM
  person_information_block t0
WHERE
  t0.information_block_id = ?

SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.information_block_id AS information_block_id_3, t0.person_id AS person_id_4 FROM person_information_block t0 WHERE t0.information_block_id = 125;