Symfony Profiler

SELECT
  *
FROM
  tmp_store
WHERE
  id = ?

SELECT * FROM tmp_store WHERE id = 'maintenance_mode';

SELECT
  *
FROM
  users
WHERE
  `type` = ?
  AND id = ?

SELECT * FROM users WHERE `type` = 'user' AND id = 4;

SELECT
  *
FROM
  users_workspaces_asset
WHERE
  userId = ?

SELECT * FROM users_workspaces_asset WHERE userId = 4;

SELECT
  *
FROM
  users_workspaces_document
WHERE
  userId = ?

SELECT * FROM users_workspaces_document WHERE userId = 4;

SELECT
  *
FROM
  users_workspaces_object
WHERE
  userId = ?

SELECT * FROM users_workspaces_object WHERE userId = 4;

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1753879551 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_98334');

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'product';

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?, ?, ?, ?, ?, ?, ?, ?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1753879551 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_98334
tags
', 'class_product
tags
', 'asset_173515
tags
', 'asset_173516
tags
', 'asset_173517
tags
', 'asset_173518
tags
', 'asset_173519
tags
', 'asset_173520
tags
');

SELECT
  id
FROM
  versions
WHERE
  cid = ?
  AND ctype = ?
  AND (
    `date` > ?
    OR versionCount > ?
  )
  AND (
    (
      autoSave = 1
      AND userId = ?
    )
    OR autoSave = 0
  )
ORDER BY
  `versionCount` DESC
LIMIT
  1

SELECT id FROM versions WHERE cid = 98334 AND ctype = 'object' AND (`date` > 1753879541 OR versionCount > 16) AND ((autoSave = 1 AND userId = 4) OR autoSave = 0) ORDER BY `versionCount` DESC LIMIT 1;

SELECT
  *
FROM
  object_relations_product
WHERE
  src_id = ?

SELECT * FROM object_relations_product WHERE src_id = 98334;

SELECT
  id
FROM
  objects
WHERE
  id IN (5)

SELECT id FROM objects WHERE id IN (5);

SELECT
  *
FROM
  object_metadata_product
WHERE
  id = ?
  AND dest_id = ?
  AND fieldname = ?
  AND ownertype = ?
  AND ownername = ?
  and position = ?
  and `index` = ?
  AND (
    `type` = 'object'
    or `type` = ''
  )

SELECT * FROM object_metadata_product WHERE id = 98334 AND dest_id = 5 AND fieldname = 'domains' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 1  AND (`type` = 'object' or `type` = '');

SELECT
  id
FROM
  objects
WHERE
  id IN (92028)

SELECT id FROM objects WHERE id IN (92028);

SELECT
  *
FROM
  object_metadata_product
WHERE
  id = ?
  AND dest_id = ?
  AND fieldname = ?
  AND ownertype = ?
  AND ownername = ?
  and position = ?
  and `index` = ?
  AND (
    `type` = 'object'
    or `type` = ''
  )

SELECT * FROM object_metadata_product WHERE id = 98334 AND dest_id = 92028 AND fieldname = 'categories' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 1  AND (`type` = 'object' or `type` = '');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1753879551 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_5');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?, ?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1753879551 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_5
tags
', 'class_domain
tags
');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1753879551 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_92028');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?, ?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1753879551 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_92028
tags
', 'class_category
tags
');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1753879551 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_91819');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?, ?, ?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1753879551 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_91819
tags
', 'class_category
tags
', 'asset_156216
tags
');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1753879551 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_91793');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?, ?, ?, ?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1753879551 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_91793
tags
', 'class_category
tags
', 'asset_156164
tags
', 'asset_156165
tags
');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1753879551 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_7');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?, ?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1753879551 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_7
tags
', 'class_block
tags
');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1753879551 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_93971');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1753879551 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_93971
tags
');

SELECT
  CONCAT(`path`, `key`) as `path`
FROM
  objects
WHERE
  id = ?

SELECT CONCAT(`path`,`key`) as `path` FROM objects WHERE id = 93971;

SELECT
  id
FROM
  objects
WHERE
  `path` = BINARY ?
  AND `key` = BINARY ?

SELECT id FROM objects WHERE `path` = BINARY '/Товары/Сейфы/Оружейные сейфы и шкафы/AIKO серия ЧИРОК/' AND `key` = BINARY 'Оружейный сейф AIKO ЧИРОК 1015 сборный';

SELECT
  id
FROM
  objects
WHERE
  `path` = BINARY ?
  AND `key` = BINARY ?

SELECT id FROM objects WHERE `path` = BINARY '/Товары/Сейфы/Оружейные сейфы и шкафы/AIKO серия ЧИРОК/' AND `key` = BINARY 'Оружейный сейф AIKO ЧИРОК 1015 сборный';

"START TRANSACTION"

"START TRANSACTION";

SELECT
  CONCAT(`path`, `key`) as `path`
FROM
  objects
WHERE
  id = ?

SELECT CONCAT(`path`,`key`) as `path` FROM objects WHERE id = 98334;

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1753879551 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cs_groupconfig_231');

SELECT
  classificationstore_relations.*,
  classificationstore_keys.*
FROM
  classificationstore_relations,
  classificationstore_keys
WHERE
  groupId = 231
  AND classificationstore_relations.keyId = classificationstore_keys.id

SELECT classificationstore_relations.*,classificationstore_keys.* FROM classificationstore_relations,classificationstore_keys WHERE groupId = 231  AND classificationstore_relations.keyId = classificationstore_keys.id;

SELECT
  versionCount
FROM
  objects
WHERE
  id = ? FOR
UPDATE

SELECT versionCount FROM objects WHERE id = 98334 FOR UPDATE;

SELECT
  MAX(versionCount)
FROM
  versions
WHERE
  cid = ?
  AND ctype = 'object'

SELECT MAX(versionCount) FROM versions WHERE cid = 98334 AND ctype = 'object';

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1753879551 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_resource_columns_objects');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1753879551 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_resource_columns_objects');

SHOW COLUMNS
FROM
  objects

SHOW COLUMNS FROM objects;

SELECT
  type,
  classId,
  className
FROM
  objects
WHERE
  id = ?

SELECT type,classId,className FROM objects WHERE id = 98334;

INSERT INTO objects (
  `path`, `id`, `creationDate`, `modificationDate`,
  `versionCount`, `userOwner`, `userModification`,
  `parentId`, `type`, `key`, `index`,
  `childrenSortBy`, `childrenSortOrder`,
  `published`, `classId`, `className`
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO objects (`path`, `id`, `creationDate`, `modificationDate`, `versionCount`, `userOwner`, `userModification`, `parentId`, `type`, `key`, `index`, `childrenSortBy`, `childrenSortOrder`, `published`, `classId`, `className`) VALUES ('/Товары/Сейфы/Оружейные сейфы и шкафы/AIKO серия ЧИРОК/', 98334, 1753878025, 1753879551, 17, 4, 4, 93971, 'object', 'Оружейный сейф AIKO ЧИРОК 1015 сборный', 0, NULL, NULL, 1, 'product', 'product');

UPDATE
  objects
SET
  `path` = ?,
  `id` = ?,
  `creationDate` = ?,
  `modificationDate` = ?,
  `versionCount` = ?,
  `userOwner` = ?,
  `userModification` = ?,
  `parentId` = ?,
  `type` = ?,
  `key` = ?,
  `index` = ?,
  `childrenSortBy` = ?,
  `childrenSortOrder` = ?,
  `published` = ?,
  `classId` = ?,
  `className` = ?
WHERE
  `id` = ?

UPDATE objects SET `path` = '/Товары/Сейфы/Оружейные сейфы и шкафы/AIKO серия ЧИРОК/', `id` = 98334, `creationDate` = 1753878025, `modificationDate` = 1753879551, `versionCount` = 17, `userOwner` = 4, `userModification` = 4, `parentId` = 93971, `type` = 'object', `key` = 'Оружейный сейф AIKO ЧИРОК 1015 сборный', `index` = 0, `childrenSortBy` = NULL, `childrenSortOrder` = NULL, `published` = 1, `classId` = 'product', `className` = 'product' WHERE `id` = 98334;

DELETE FROM
  tree_locks
WHERE
  id = ?
  AND type = ?

DELETE FROM tree_locks WHERE id = 98334 AND type = 'object';

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1753879551 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_173515');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1753879551 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_173516');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1753879551 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_173517');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1753879551 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_173518');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1753879551 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_173519');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1753879551 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_173520');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1753879551 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_resource_columns_object_store_product');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1753879551 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_resource_columns_object_store_product');

SHOW COLUMNS
FROM
  object_store_product

SHOW COLUMNS FROM object_store_product;

INSERT INTO object_store_product (
  `oo_id`, `active`, `sort`, `xml_id`,
  `external_id`, `code`, `active_kz`,
  `sort_kz`, `code_kz`, `active_uz`,
  `sort_uz`, `code_uz`, `active_az`,
  `sort_az`, `code_az`, `active_rs`,
  `sort_rs`, `code_rs`, `video_picture__image`,
  `video_picture__hotspots`, `video_src`,
  `pictures__images`, `pictures__hotspots`,
  `folder_360_block`, `preview_picture__image`,
  `preview_picture__hotspots`, `detail_picture__image`,
  `detail_picture__hotspots`, `additional_photo__images`,
  `additional_photo__hotspots`, `photos_colorlist__images`,
  `photos_colorlist__hotspots`, `tabs_icons__images`,
  `tabs_icons__hotspots`, `warranty`,
  `video`, `nds_not_apply`, `pack_width_3`,
  `pack_height_3`, `pack_length_3`,
  `pack_weight_3`, `pack_volume_3`,
  `gross_weight`, `gross_volume`,
  `tag_new`, `tag_new_price`, `tag_action`,
  `tag_hit`, `test`
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?
  )

INSERT INTO object_store_product (`oo_id`, `active`, `sort`, `xml_id`, `external_id`, `code`, `active_kz`, `sort_kz`, `code_kz`, `active_uz`, `sort_uz`, `code_uz`, `active_az`, `sort_az`, `code_az`, `active_rs`, `sort_rs`, `code_rs`, `video_picture__image`, `video_picture__hotspots`, `video_src`, `pictures__images`, `pictures__hotspots`, `folder_360_block`, `preview_picture__image`, `preview_picture__hotspots`, `detail_picture__image`, `detail_picture__hotspots`, `additional_photo__images`, `additional_photo__hotspots`, `photos_colorlist__images`, `photos_colorlist__hotspots`, `tabs_icons__images`, `tabs_icons__hotspots`, `warranty`, `video`, `nds_not_apply`, `pack_width_3`, `pack_height_3`, `pack_length_3`, `pack_weight_3`, `pack_volume_3`, `gross_weight`, `gross_volume`, `tag_new`, `tag_new_price`, `tag_action`, `tag_hit`, `test`) VALUES (98334, 1, 102, '4fda24cf-6d97-e3ed-95db-81f310dfeb39', '13584', 'oruzheynyy-seyf-aiko-chirok-1015-sbornyy', NULL, 500, NULL, NULL, 500, NULL, NULL, 500, NULL, NULL, 500, NULL, NULL, NULL, NULL, '', 'a:0:{}', 'a:0:{}', 173515, 'a:3:{s:8:\"hotspots\";a:0:{}s:6:\"marker\";a:0:{}s:4:\"crop\";a:0:{}}', 173516, 'a:3:{s:8:\"hotspots\";a:0:{}s:6:\"marker\";a:0:{}s:4:\"crop\";a:0:{}}', ',173517,173518,173519,173520,', 'a:4:{i:0;s:63:\"a:3:{s:8:\"hotspots\";a:0:{}s:6:\"marker\";a:0:{}s:4:\"crop\";a:0:{}}\";i:1;s:63:\"a:3:{s:8:\"hotspots\";a:0:{}s:6:\"marker\";a:0:{}s:4:\"crop\";a:0:{}}\";i:2;s:63:\"a:3:{s:8:\"hotspots\";a:0:{}s:6:\"marker\";a:0:{}s:4:\"crop\";a:0:{}}\";i:3;s:63:\"a:3:{s:8:\"hotspots\";a:0:{}s:6:\"marker\";a:0:{}s:4:\"crop\";a:0:{}}\";}', '', 'a:0:{}', '', 'a:0:{}', 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, '');

UPDATE
  object_store_product
SET
  `oo_id` = ?,
  `active` = ?,
  `sort` = ?,
  `xml_id` = ?,
  `external_id` = ?,
  `code` = ?,
  `active_kz` = ?,
  `sort_kz` = ?,
  `code_kz` = ?,
  `active_uz` = ?,
  `sort_uz` = ?,
  `code_uz` = ?,
  `active_az` = ?,
  `sort_az` = ?,
  `code_az` = ?,
  `active_rs` = ?,
  `sort_rs` = ?,
  `code_rs` = ?,
  `video_picture__image` = ?,
  `video_picture__hotspots` = ?,
  `video_src` = ?,
  `pictures__images` = ?,
  `pictures__hotspots` = ?,
  `folder_360_block` = ?,
  `preview_picture__image` = ?,
  `preview_picture__hotspots` = ?,
  `detail_picture__image` = ?,
  `detail_picture__hotspots` = ?,
  `additional_photo__images` = ?,
  `additional_photo__hotspots` = ?,
  `photos_colorlist__images` = ?,
  `photos_colorlist__hotspots` = ?,
  `tabs_icons__images` = ?,
  `tabs_icons__hotspots` = ?,
  `warranty` = ?,
  `video` = ?,
  `nds_not_apply` = ?,
  `pack_width_3` = ?,
  `pack_height_3` = ?,
  `pack_length_3` = ?,
  `pack_weight_3` = ?,
  `pack_volume_3` = ?,
  `gross_weight` = ?,
  `gross_volume` = ?,
  `tag_new` = ?,
  `tag_new_price` = ?,
  `tag_action` = ?,
  `tag_hit` = ?,
  `test` = ?
WHERE
  `oo_id` = ?

UPDATE object_store_product SET `oo_id` = 98334, `active` = 1, `sort` = 102, `xml_id` = '4fda24cf-6d97-e3ed-95db-81f310dfeb39', `external_id` = '13584', `code` = 'oruzheynyy-seyf-aiko-chirok-1015-sbornyy', `active_kz` = NULL, `sort_kz` = 500, `code_kz` = NULL, `active_uz` = NULL, `sort_uz` = 500, `code_uz` = NULL, `active_az` = NULL, `sort_az` = 500, `code_az` = NULL, `active_rs` = NULL, `sort_rs` = 500, `code_rs` = NULL, `video_picture__image` = NULL, `video_picture__hotspots` = NULL, `video_src` = NULL, `pictures__images` = '', `pictures__hotspots` = 'a:0:{}', `folder_360_block` = 'a:0:{}', `preview_picture__image` = 173515, `preview_picture__hotspots` = 'a:3:{s:8:\"hotspots\";a:0:{}s:6:\"marker\";a:0:{}s:4:\"crop\";a:0:{}}', `detail_picture__image` = 173516, `detail_picture__hotspots` = 'a:3:{s:8:\"hotspots\";a:0:{}s:6:\"marker\";a:0:{}s:4:\"crop\";a:0:{}}', `additional_photo__images` = ',173517,173518,173519,173520,', `additional_photo__hotspots` = 'a:4:{i:0;s:63:\"a:3:{s:8:\"hotspots\";a:0:{}s:6:\"marker\";a:0:{}s:4:\"crop\";a:0:{}}\";i:1;s:63:\"a:3:{s:8:\"hotspots\";a:0:{}s:6:\"marker\";a:0:{}s:4:\"crop\";a:0:{}}\";i:2;s:63:\"a:3:{s:8:\"hotspots\";a:0:{}s:6:\"marker\";a:0:{}s:4:\"crop\";a:0:{}}\";i:3;s:63:\"a:3:{s:8:\"hotspots\";a:0:{}s:6:\"marker\";a:0:{}s:4:\"crop\";a:0:{}}\";}', `photos_colorlist__images` = '', `photos_colorlist__hotspots` = 'a:0:{}', `tabs_icons__images` = '', `tabs_icons__hotspots` = 'a:0:{}', `warranty` = 1, `video` = NULL, `nds_not_apply` = '', `pack_width_3` = NULL, `pack_height_3` = NULL, `pack_length_3` = NULL, `pack_weight_3` = NULL, `pack_volume_3` = NULL, `gross_weight` = NULL, `gross_volume` = NULL, `tag_new` = 1, `tag_new_price` = NULL, `tag_action` = NULL, `tag_hit` = NULL, `test` = '' WHERE `oo_id` = 98334;

SELECT
  *
FROM
  object_query_product
WHERE
  oo_id = ?

SELECT * FROM object_query_product WHERE oo_id = 98334;

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1753879551 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_resource_columns_object_query_product');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1753879551 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_resource_columns_object_query_product');

SHOW COLUMNS
FROM
  object_query_product

SHOW COLUMNS FROM object_query_product;

INSERT INTO object_query_product (
  `active`, `sort`, `xml_id`, `external_id`,
  `code`, `active_kz`, `sort_kz`, `code_kz`,
  `active_uz`, `sort_uz`, `code_uz`,
  `active_az`, `sort_az`, `code_az`,
  `active_rs`, `sort_rs`, `code_rs`,
  `video_picture__image`, `video_picture__hotspots`,
  `video_src`, `pictures__images`,
  `pictures__hotspots`, `preview_picture__image`,
  `preview_picture__hotspots`, `detail_picture__image`,
  `detail_picture__hotspots`, `additional_photo__images`,
  `additional_photo__hotspots`, `photos_colorlist__images`,
  `photos_colorlist__hotspots`, `tabs_icons__images`,
  `tabs_icons__hotspots`, `warranty`,
  `video`, `nds_not_apply`, `pack_width_3`,
  `pack_height_3`, `pack_length_3`,
  `pack_weight_3`, `pack_volume_3`,
  `gross_weight`, `gross_volume`,
  `tag_new`, `tag_new_price`, `tag_action`,
  `tag_hit`, `test`, `oo_id`
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )

INSERT INTO object_query_product (`active`, `sort`, `xml_id`, `external_id`, `code`, `active_kz`, `sort_kz`, `code_kz`, `active_uz`, `sort_uz`, `code_uz`, `active_az`, `sort_az`, `code_az`, `active_rs`, `sort_rs`, `code_rs`, `video_picture__image`, `video_picture__hotspots`, `video_src`, `pictures__images`, `pictures__hotspots`, `preview_picture__image`, `preview_picture__hotspots`, `detail_picture__image`, `detail_picture__hotspots`, `additional_photo__images`, `additional_photo__hotspots`, `photos_colorlist__images`, `photos_colorlist__hotspots`, `tabs_icons__images`, `tabs_icons__hotspots`, `warranty`, `video`, `nds_not_apply`, `pack_width_3`, `pack_height_3`, `pack_length_3`, `pack_weight_3`, `pack_volume_3`, `gross_weight`, `gross_volume`, `tag_new`, `tag_new_price`, `tag_action`, `tag_hit`, `test`, `oo_id`) VALUES (1, 102, '4fda24cf-6d97-e3ed-95db-81f310dfeb39', '13584', 'oruzheynyy-seyf-aiko-chirok-1015-sbornyy', NULL, 500, NULL, NULL, 500, NULL, NULL, 500, NULL, NULL, 500, NULL, NULL, NULL, NULL, '', 'a:0:{}', 173515, 'a:3:{s:8:\"hotspots\";a:0:{}s:6:\"marker\";a:0:{}s:4:\"crop\";a:0:{}}', 173516, 'a:3:{s:8:\"hotspots\";a:0:{}s:6:\"marker\";a:0:{}s:4:\"crop\";a:0:{}}', ',173517,173518,173519,173520,', 'a:4:{i:0;s:63:\"a:3:{s:8:\"hotspots\";a:0:{}s:6:\"marker\";a:0:{}s:4:\"crop\";a:0:{}}\";i:1;s:63:\"a:3:{s:8:\"hotspots\";a:0:{}s:6:\"marker\";a:0:{}s:4:\"crop\";a:0:{}}\";i:2;s:63:\"a:3:{s:8:\"hotspots\";a:0:{}s:6:\"marker\";a:0:{}s:4:\"crop\";a:0:{}}\";i:3;s:63:\"a:3:{s:8:\"hotspots\";a:0:{}s:6:\"marker\";a:0:{}s:4:\"crop\";a:0:{}}\";}', '', 'a:0:{}', '', 'a:0:{}', 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, '', 98334);

UPDATE
  object_query_product
SET
  `active` = ?,
  `sort` = ?,
  `xml_id` = ?,
  `external_id` = ?,
  `code` = ?,
  `active_kz` = ?,
  `sort_kz` = ?,
  `code_kz` = ?,
  `active_uz` = ?,
  `sort_uz` = ?,
  `code_uz` = ?,
  `active_az` = ?,
  `sort_az` = ?,
  `code_az` = ?,
  `active_rs` = ?,
  `sort_rs` = ?,
  `code_rs` = ?,
  `video_picture__image` = ?,
  `video_picture__hotspots` = ?,
  `video_src` = ?,
  `pictures__images` = ?,
  `pictures__hotspots` = ?,
  `preview_picture__image` = ?,
  `preview_picture__hotspots` = ?,
  `detail_picture__image` = ?,
  `detail_picture__hotspots` = ?,
  `additional_photo__images` = ?,
  `additional_photo__hotspots` = ?,
  `photos_colorlist__images` = ?,
  `photos_colorlist__hotspots` = ?,
  `tabs_icons__images` = ?,
  `tabs_icons__hotspots` = ?,
  `warranty` = ?,
  `video` = ?,
  `nds_not_apply` = ?,
  `pack_width_3` = ?,
  `pack_height_3` = ?,
  `pack_length_3` = ?,
  `pack_weight_3` = ?,
  `pack_volume_3` = ?,
  `gross_weight` = ?,
  `gross_volume` = ?,
  `tag_new` = ?,
  `tag_new_price` = ?,
  `tag_action` = ?,
  `tag_hit` = ?,
  `test` = ?,
  `oo_id` = ?
WHERE
  `oo_id` = ?

UPDATE object_query_product SET `active` = 1, `sort` = 102, `xml_id` = '4fda24cf-6d97-e3ed-95db-81f310dfeb39', `external_id` = '13584', `code` = 'oruzheynyy-seyf-aiko-chirok-1015-sbornyy', `active_kz` = NULL, `sort_kz` = 500, `code_kz` = NULL, `active_uz` = NULL, `sort_uz` = 500, `code_uz` = NULL, `active_az` = NULL, `sort_az` = 500, `code_az` = NULL, `active_rs` = NULL, `sort_rs` = 500, `code_rs` = NULL, `video_picture__image` = NULL, `video_picture__hotspots` = NULL, `video_src` = NULL, `pictures__images` = '', `pictures__hotspots` = 'a:0:{}', `preview_picture__image` = 173515, `preview_picture__hotspots` = 'a:3:{s:8:\"hotspots\";a:0:{}s:6:\"marker\";a:0:{}s:4:\"crop\";a:0:{}}', `detail_picture__image` = 173516, `detail_picture__hotspots` = 'a:3:{s:8:\"hotspots\";a:0:{}s:6:\"marker\";a:0:{}s:4:\"crop\";a:0:{}}', `additional_photo__images` = ',173517,173518,173519,173520,', `additional_photo__hotspots` = 'a:4:{i:0;s:63:\"a:3:{s:8:\"hotspots\";a:0:{}s:6:\"marker\";a:0:{}s:4:\"crop\";a:0:{}}\";i:1;s:63:\"a:3:{s:8:\"hotspots\";a:0:{}s:6:\"marker\";a:0:{}s:4:\"crop\";a:0:{}}\";i:2;s:63:\"a:3:{s:8:\"hotspots\";a:0:{}s:6:\"marker\";a:0:{}s:4:\"crop\";a:0:{}}\";i:3;s:63:\"a:3:{s:8:\"hotspots\";a:0:{}s:6:\"marker\";a:0:{}s:4:\"crop\";a:0:{}}\";}', `photos_colorlist__images` = '', `photos_colorlist__hotspots` = 'a:0:{}', `tabs_icons__images` = '', `tabs_icons__hotspots` = 'a:0:{}', `warranty` = 1, `video` = NULL, `nds_not_apply` = '', `pack_width_3` = NULL, `pack_height_3` = NULL, `pack_length_3` = NULL, `pack_weight_3` = NULL, `pack_volume_3` = NULL, `gross_weight` = NULL, `gross_volume` = NULL, `tag_new` = 1, `tag_new_price` = NULL, `tag_action` = NULL, `tag_hit` = NULL, `test` = '', `oo_id` = 98334 WHERE `oo_id` = 98334;

SELECT
  id
FROM
  schedule_tasks
WHERE
  `cid` = ?
  AND `ctype` = ?

SELECT id FROM schedule_tasks WHERE `cid` = 98334 AND `ctype` = 'object' ;

DELETE FROM
  schedule_tasks
WHERE
  `cid` = 98334
  AND `ctype` = 'object'

DELETE FROM schedule_tasks WHERE `cid` = 98334 AND `ctype` = 'object';