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 = '019a6d90-85f2-787a-9885-9795dbe63611' 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 = '019a6d90-85f2-787a-9885-9795dbe63611' 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 = '019c56c9-83d0-73ec-9f56-0b5b52fd71cf' 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 = '019c56c9-83d0-73ec-9f56-0b5b52fd71cf' 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 = '019a6d90-85f2-787a-9885-9795dbe63611' 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 = '019c56c9-83d0-73ec-9f56-0b5b52fd71cf';

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 = '019c56c9-83d0-73ec-9f56-0b5b52fd71cf';

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO group_item_characteristic_values (
  group_item_uuid, characteristic_value_uuid,
  characteristic_uuid, created_by,
  updated_by
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO group_item_characteristic_values (group_item_uuid, characteristic_value_uuid, characteristic_uuid, created_by, updated_by) VALUES ('019c56c9-83d0-73ec-9f56-0b5b52fd71cf', '019a6d66-3bb4-75a2-9a0a-5552eb352560', '019a6d65-3c37-7df1-a4f2-ecda94bed096', '019a737a-e670-7415-ab36-5ec0bb1437d5', NULL);

INSERT INTO group_item_characteristic_values (
  group_item_uuid, characteristic_value_uuid,
  characteristic_uuid, created_by,
  updated_by
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO group_item_characteristic_values (group_item_uuid, characteristic_value_uuid, characteristic_uuid, created_by, updated_by) VALUES ('019c56c9-83d0-73ec-9f56-0b5b52fd71cf', '019a6d66-52d5-74de-95ee-b92b7947febb', '019a6d65-3c37-7df1-a4f2-ecda94bed096', '019a737a-e670-7415-ab36-5ec0bb1437d5', NULL);

INSERT INTO group_item_characteristic_values (
  group_item_uuid, characteristic_value_uuid,
  characteristic_uuid, created_by,
  updated_by
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO group_item_characteristic_values (group_item_uuid, characteristic_value_uuid, characteristic_uuid, created_by, updated_by) VALUES ('019c56c9-83d0-73ec-9f56-0b5b52fd71cf', '019a6d66-afb5-7276-a690-af02f5c575b3', '019a6d65-3c37-7df1-a4f2-ecda94bed096', '019a737a-e670-7415-ab36-5ec0bb1437d5', NULL);

INSERT INTO group_item_characteristic_values (
  group_item_uuid, characteristic_value_uuid,
  characteristic_uuid, created_by,
  updated_by
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO group_item_characteristic_values (group_item_uuid, characteristic_value_uuid, characteristic_uuid, created_by, updated_by) VALUES ('019c56c9-83d0-73ec-9f56-0b5b52fd71cf', '019a6d66-6e72-759a-8f46-a4c00fef9d7e', '019a6d65-3c37-7df1-a4f2-ecda94bed096', '019a737a-e670-7415-ab36-5ec0bb1437d5', NULL);

INSERT INTO group_item_characteristic_values (
  group_item_uuid, characteristic_value_uuid,
  characteristic_uuid, created_by,
  updated_by
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO group_item_characteristic_values (group_item_uuid, characteristic_value_uuid, characteristic_uuid, created_by, updated_by) VALUES ('019c56c9-83d0-73ec-9f56-0b5b52fd71cf', '019a6d66-a2ba-7d43-9af0-19cd2a636301', '019a6d65-3c37-7df1-a4f2-ecda94bed096', '019a737a-e670-7415-ab36-5ec0bb1437d5', NULL);

INSERT INTO group_item_characteristic_values (
  group_item_uuid, characteristic_value_uuid,
  characteristic_uuid, created_by,
  updated_by
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO group_item_characteristic_values (group_item_uuid, characteristic_value_uuid, characteristic_uuid, created_by, updated_by) VALUES ('019c56c9-83d0-73ec-9f56-0b5b52fd71cf', '019a6d65-ff6b-7894-916e-e28b81a72a4b', '019a6d65-3c37-7df1-a4f2-ecda94bed096', '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 = '019c56c9-83d0-73ec-9f56-0b5b52fd71cf';

INSERT INTO group_item_silhouettes (
  group_item_uuid, silhouette_uuid
)
VALUES
  (?, ?)

INSERT INTO group_item_silhouettes (group_item_uuid, silhouette_uuid) VALUES ('019c56c9-83d0-73ec-9f56-0b5b52fd71cf', '019a2609-865f-71c5-b09f-01cd84473f07');

INSERT INTO group_item_silhouettes (
  group_item_uuid, silhouette_uuid
)
VALUES
  (?, ?)

INSERT INTO group_item_silhouettes (group_item_uuid, silhouette_uuid) VALUES ('019c56c9-83d0-73ec-9f56-0b5b52fd71cf', '019a25fe-ca10-78c0-80b6-0de0f6389e5e');

INSERT INTO group_item_silhouettes (
  group_item_uuid, silhouette_uuid
)
VALUES
  (?, ?)

INSERT INTO group_item_silhouettes (group_item_uuid, silhouette_uuid) VALUES ('019c56c9-83d0-73ec-9f56-0b5b52fd71cf', '019a2609-d68c-756c-a634-35d3deb7fbd9');

INSERT INTO group_item_silhouettes (
  group_item_uuid, silhouette_uuid
)
VALUES
  (?, ?)

INSERT INTO group_item_silhouettes (group_item_uuid, silhouette_uuid) VALUES ('019c56c9-83d0-73ec-9f56-0b5b52fd71cf', '019a260a-0d85-7451-8a45-01a2d7c5f6d8');

INSERT INTO group_item_silhouettes (
  group_item_uuid, silhouette_uuid
)
VALUES
  (?, ?)

INSERT INTO group_item_silhouettes (group_item_uuid, silhouette_uuid) VALUES ('019c56c9-83d0-73ec-9f56-0b5b52fd71cf', '019a260a-74c6-7733-b79c-f871afd10658');

INSERT INTO group_item_silhouettes (
  group_item_uuid, silhouette_uuid
)
VALUES
  (?, ?)

INSERT INTO group_item_silhouettes (group_item_uuid, silhouette_uuid) VALUES ('019c56c9-83d0-73ec-9f56-0b5b52fd71cf', '019a25fe-7f70-737c-96db-e34a16af9d98');

"COMMIT"

"COMMIT";