Symfony Profiler

SELECT
  t0.uuid AS uuid_1,
  t0.username AS username_2,
  t0.email AS email_3,
  t0.timezone AS timezone_4,
  t0.password_hash AS password_hash_5,
  t0.password_changed_at AS password_changed_at_6,
  t0.is_active AS is_active_7,
  t0.is_admin AS is_admin_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10
FROM
  users t0
WHERE
  t0.uuid = ?

SELECT t0.uuid AS uuid_1, t0.username AS username_2, t0.email AS email_3, t0.timezone AS timezone_4, t0.password_hash AS password_hash_5, t0.password_changed_at AS password_changed_at_6, t0.is_active AS is_active_7, t0.is_admin AS is_admin_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10 FROM users t0 WHERE t0.uuid = '019a737a-e670-7415-ab36-5ec0bb1437d5';

SELECT
  t0.uuid AS uuid_1,
  t0.gender AS gender_2,
  t0.style_uuid AS style_uuid_3,
  t0.life_sphere_uuid AS life_sphere_uuid_4,
  t0.created_by AS created_by_5,
  t0.updated_by AS updated_by_6
FROM
groups
  t0
WHERE
  t0.uuid = ?
LIMIT
  1

SELECT t0.uuid AS uuid_1, t0.gender AS gender_2, t0.style_uuid AS style_uuid_3, t0.life_sphere_uuid AS life_sphere_uuid_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6 FROM groups t0 WHERE t0.uuid = '019a4f1d-a48e-743b-8177-635d0c53d684' LIMIT 1;

SELECT
  t0.uuid AS uuid_1,
  t0.name AS name_2,
  t0.name_en AS name_en_3,
  t0.look_type_season AS look_type_season_4,
  t0.catalog_uuid AS catalog_uuid_5,
  t0.layer_uuid AS layer_uuid_6,
  t0.created_by AS created_by_7,
  t0.updated_by AS updated_by_8
FROM
  items t0
WHERE
  t0.uuid = ?
LIMIT
  1

SELECT t0.uuid AS uuid_1, t0.name AS name_2, t0.name_en AS name_en_3, t0.look_type_season AS look_type_season_4, t0.catalog_uuid AS catalog_uuid_5, t0.layer_uuid AS layer_uuid_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8 FROM items t0 WHERE t0.uuid = '019a6d02-ec95-76a1-8122-dba7f5136aaf' LIMIT 1;

SELECT
  t0.uuid AS uuid_1,
  t0.group_uuid AS group_uuid_2,
  t0.item_uuid AS item_uuid_3,
  t0.created_by AS created_by_4,
  t0.updated_by AS updated_by_5
FROM
  group_items t0
WHERE
  t0.group_uuid = ?
  AND t0.item_uuid = ?
LIMIT
  1

SELECT t0.uuid AS uuid_1, t0.group_uuid AS group_uuid_2, t0.item_uuid AS item_uuid_3, t0.created_by AS created_by_4, t0.updated_by AS updated_by_5 FROM group_items t0 WHERE t0.group_uuid = '019a4f1d-a48e-743b-8177-635d0c53d684' AND t0.item_uuid = '019a6d02-ec95-76a1-8122-dba7f5136aaf' LIMIT 1;

SELECT
  c0_.uuid AS uuid_0,
  c0_.alias AS alias_1,
  c0_.value AS value_2,
  c0_.value_eng AS value_eng_3,
  c0_.value_norm AS value_norm_4,
  c1_.uuid AS uuid_5,
  c1_.alias AS alias_6,
  c1_.value AS value_7,
  c1_.value_eng AS value_eng_8,
  c0_.created_by AS created_by_9,
  c0_.updated_by AS updated_by_10,
  c1_.characteristic_uuid AS characteristic_uuid_11,
  c1_.created_by AS created_by_12,
  c1_.updated_by AS updated_by_13
FROM
  characteristics c0_
  LEFT JOIN characteristic_values c1_ ON c0_.uuid = c1_.characteristic_uuid
ORDER BY
  c0_.value ASC,
  c1_.value ASC

SELECT c0_.uuid AS uuid_0, c0_.alias AS alias_1, c0_.value AS value_2, c0_.value_eng AS value_eng_3, c0_.value_norm AS value_norm_4, c1_.uuid AS uuid_5, c1_.alias AS alias_6, c1_.value AS value_7, c1_.value_eng AS value_eng_8, c0_.created_by AS created_by_9, c0_.updated_by AS updated_by_10, c1_.characteristic_uuid AS characteristic_uuid_11, c1_.created_by AS created_by_12, c1_.updated_by AS updated_by_13 FROM characteristics c0_ LEFT JOIN characteristic_values c1_ ON c0_.uuid = c1_.characteristic_uuid ORDER BY c0_.value ASC, c1_.value ASC;

SELECT
  c0_.uuid AS uuid_0,
  c0_.alias AS alias_1,
  c0_.value AS value_2,
  c0_.value_eng AS value_eng_3,
  c1_.uuid AS uuid_4,
  c1_.alias AS alias_5,
  c1_.value AS value_6,
  c1_.value_eng AS value_eng_7,
  c1_.value_norm AS value_norm_8,
  g2_.group_item_uuid AS group_item_uuid_9,
  g2_.characteristic_value_uuid AS characteristic_value_uuid_10,
  g2_.characteristic_uuid AS characteristic_uuid_11,
  g2_.created_by AS created_by_12,
  g2_.updated_by AS updated_by_13,
  c0_.characteristic_uuid AS characteristic_uuid_14,
  c0_.created_by AS created_by_15,
  c0_.updated_by AS updated_by_16,
  c1_.created_by AS created_by_17,
  c1_.updated_by AS updated_by_18
FROM
  group_item_characteristic_values g2_
  INNER JOIN characteristic_values c0_ ON g2_.characteristic_value_uuid = c0_.uuid
  INNER JOIN characteristics c1_ ON g2_.characteristic_uuid = c1_.uuid
WHERE
  g2_.group_item_uuid = ?
ORDER BY
  c1_.value ASC,
  c0_.value ASC

SELECT c0_.uuid AS uuid_0, c0_.alias AS alias_1, c0_.value AS value_2, c0_.value_eng AS value_eng_3, c1_.uuid AS uuid_4, c1_.alias AS alias_5, c1_.value AS value_6, c1_.value_eng AS value_eng_7, c1_.value_norm AS value_norm_8, g2_.group_item_uuid AS group_item_uuid_9, g2_.characteristic_value_uuid AS characteristic_value_uuid_10, g2_.characteristic_uuid AS characteristic_uuid_11, g2_.created_by AS created_by_12, g2_.updated_by AS updated_by_13, c0_.characteristic_uuid AS characteristic_uuid_14, c0_.created_by AS created_by_15, c0_.updated_by AS updated_by_16, c1_.created_by AS created_by_17, c1_.updated_by AS updated_by_18 FROM group_item_characteristic_values g2_ INNER JOIN characteristic_values c0_ ON g2_.characteristic_value_uuid = c0_.uuid INNER JOIN characteristics c1_ ON g2_.characteristic_uuid = c1_.uuid WHERE g2_.group_item_uuid = '019c56ca-2849-7dc7-821b-7cfd95e5a694' ORDER BY c1_.value ASC, c0_.value ASC;

SELECT
  n0_.uuid AS uuid_0,
  n0_.name AS name_1,
  n0_.name_en AS name_en_2,
  n0_.synonym AS synonym_3,
  n0_.constr_details AS constr_details_4,
  n0_.constr_details_eng AS constr_details_eng_5,
  n0_.created_at AS created_at_6,
  n0_.updated_at AS updated_at_7,
  g1_.group_item_uuid AS group_item_uuid_8,
  g1_.nomenclature_uuid AS nomenclature_uuid_9,
  g1_.created_by AS created_by_10,
  g1_.updated_by AS updated_by_11,
  n0_.item_uuid AS item_uuid_12,
  n0_.tx_silhouette_uuid AS tx_silhouette_uuid_13,
  n0_.created_by AS created_by_14,
  n0_.updated_by AS updated_by_15
FROM
  group_item_nomenclatures g1_
  INNER JOIN nomenclatures n0_ ON g1_.nomenclature_uuid = n0_.uuid
WHERE
  g1_.group_item_uuid = ?
ORDER BY
  n0_.name ASC

SELECT n0_.uuid AS uuid_0, n0_.name AS name_1, n0_.name_en AS name_en_2, n0_.synonym AS synonym_3, n0_.constr_details AS constr_details_4, n0_.constr_details_eng AS constr_details_eng_5, n0_.created_at AS created_at_6, n0_.updated_at AS updated_at_7, g1_.group_item_uuid AS group_item_uuid_8, g1_.nomenclature_uuid AS nomenclature_uuid_9, g1_.created_by AS created_by_10, g1_.updated_by AS updated_by_11, n0_.item_uuid AS item_uuid_12, n0_.tx_silhouette_uuid AS tx_silhouette_uuid_13, n0_.created_by AS created_by_14, n0_.updated_by AS updated_by_15 FROM group_item_nomenclatures g1_ INNER JOIN nomenclatures n0_ ON g1_.nomenclature_uuid = n0_.uuid WHERE g1_.group_item_uuid = '019c56ca-2849-7dc7-821b-7cfd95e5a694' ORDER BY n0_.name ASC;

SELECT
  t0.uuid AS uuid_1,
  t0.alias AS alias_2,
  t0.value AS value_3,
  t0.value_eng AS value_eng_4,
  t0.value_norm AS value_norm_5,
  t0.created_by AS created_by_6,
  t0.updated_by AS updated_by_7
FROM
  tx_lengths t0
ORDER BY
  t0.value ASC

SELECT t0.uuid AS uuid_1, t0.alias AS alias_2, t0.value AS value_3, t0.value_eng AS value_eng_4, t0.value_norm AS value_norm_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7 FROM tx_lengths t0 ORDER BY t0.value ASC;

SELECT
  t0.uuid AS uuid_1,
  t0.alias AS alias_2,
  t0.value AS value_3,
  t0.value_eng AS value_eng_4,
  t0.value_norm AS value_norm_5,
  t0.created_by AS created_by_6,
  t0.updated_by AS updated_by_7
FROM
  tx_silhouettes t0
ORDER BY
  t0.value ASC

SELECT t0.uuid AS uuid_1, t0.alias AS alias_2, t0.value AS value_3, t0.value_eng AS value_eng_4, t0.value_norm AS value_norm_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7 FROM tx_silhouettes t0 ORDER BY t0.value ASC;

SELECT
  t0.uuid AS uuid_1,
  t0.name AS name_2,
  t0.name_en AS name_en_3,
  t0.synonym AS synonym_4,
  t0.constr_details AS constr_details_5,
  t0.constr_details_eng AS constr_details_eng_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.item_uuid AS item_uuid_9,
  t0.tx_silhouette_uuid AS tx_silhouette_uuid_10,
  t0.created_by AS created_by_11,
  t0.updated_by AS updated_by_12
FROM
  nomenclatures t0
WHERE
  t0.item_uuid = ?
ORDER BY
  t0.name ASC

SELECT t0.uuid AS uuid_1, t0.name AS name_2, t0.name_en AS name_en_3, t0.synonym AS synonym_4, t0.constr_details AS constr_details_5, t0.constr_details_eng AS constr_details_eng_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.item_uuid AS item_uuid_9, t0.tx_silhouette_uuid AS tx_silhouette_uuid_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12 FROM nomenclatures t0 WHERE t0.item_uuid = '019a6d02-ec95-76a1-8122-dba7f5136aaf' ORDER BY t0.name ASC;

SELECT
  t0.uuid AS uuid_1,
  t0.alias AS alias_2,
  t0.value AS value_3,
  t0.value_eng AS value_eng_4,
  t0.value_norm AS value_norm_5,
  t0.created_by AS created_by_6,
  t0.updated_by AS updated_by_7
FROM
  tx_lengths t0
  INNER JOIN group_item_lengths ON t0.uuid = group_item_lengths.length_uuid
WHERE
  group_item_lengths.group_item_uuid = ?

SELECT t0.uuid AS uuid_1, t0.alias AS alias_2, t0.value AS value_3, t0.value_eng AS value_eng_4, t0.value_norm AS value_norm_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7 FROM tx_lengths t0 INNER JOIN group_item_lengths ON t0.uuid = group_item_lengths.length_uuid WHERE group_item_lengths.group_item_uuid = '019c56ca-2849-7dc7-821b-7cfd95e5a694';

SELECT
  t0.uuid AS uuid_1,
  t0.alias AS alias_2,
  t0.value AS value_3,
  t0.value_eng AS value_eng_4,
  t0.value_norm AS value_norm_5,
  t0.created_by AS created_by_6,
  t0.updated_by AS updated_by_7
FROM
  tx_silhouettes t0
  INNER JOIN group_item_silhouettes ON t0.uuid = group_item_silhouettes.silhouette_uuid
WHERE
  group_item_silhouettes.group_item_uuid = ?

SELECT t0.uuid AS uuid_1, t0.alias AS alias_2, t0.value AS value_3, t0.value_eng AS value_eng_4, t0.value_norm AS value_norm_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7 FROM tx_silhouettes t0 INNER JOIN group_item_silhouettes ON t0.uuid = group_item_silhouettes.silhouette_uuid WHERE group_item_silhouettes.group_item_uuid = '019c56ca-2849-7dc7-821b-7cfd95e5a694';

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO group_item_nomenclatures (
  group_item_uuid, nomenclature_uuid,
  created_by, updated_by
)
VALUES
  (?, ?, ?, ?)

INSERT INTO group_item_nomenclatures (group_item_uuid, nomenclature_uuid, created_by, updated_by) VALUES ('019c56ca-2849-7dc7-821b-7cfd95e5a694', '019a6db1-a4af-7896-99b4-d59140ce2cde', '019a737a-e670-7415-ab36-5ec0bb1437d5', NULL);

INSERT INTO group_item_nomenclatures (
  group_item_uuid, nomenclature_uuid,
  created_by, updated_by
)
VALUES
  (?, ?, ?, ?)

INSERT INTO group_item_nomenclatures (group_item_uuid, nomenclature_uuid, created_by, updated_by) VALUES ('019c56ca-2849-7dc7-821b-7cfd95e5a694', '019b45b9-673b-72f5-92f3-3c39c4305517', '019a737a-e670-7415-ab36-5ec0bb1437d5', NULL);

INSERT INTO group_item_nomenclatures (
  group_item_uuid, nomenclature_uuid,
  created_by, updated_by
)
VALUES
  (?, ?, ?, ?)

INSERT INTO group_item_nomenclatures (group_item_uuid, nomenclature_uuid, created_by, updated_by) VALUES ('019c56ca-2849-7dc7-821b-7cfd95e5a694', '019a6db0-ffc3-7d5d-8dd6-44b4e7f880e0', '019a737a-e670-7415-ab36-5ec0bb1437d5', NULL);

INSERT INTO group_item_nomenclatures (
  group_item_uuid, nomenclature_uuid,
  created_by, updated_by
)
VALUES
  (?, ?, ?, ?)

INSERT INTO group_item_nomenclatures (group_item_uuid, nomenclature_uuid, created_by, updated_by) VALUES ('019c56ca-2849-7dc7-821b-7cfd95e5a694', '019a6db0-885a-718c-a8d5-3c1a6ad014df', '019a737a-e670-7415-ab36-5ec0bb1437d5', NULL);

UPDATE
  group_items
SET
  updated_by = ?
WHERE
  uuid = ?

UPDATE group_items SET updated_by = '019a737a-e670-7415-ab36-5ec0bb1437d5' WHERE uuid = '019c56ca-2849-7dc7-821b-7cfd95e5a694';

"COMMIT"

"COMMIT";