Exception: Query error 40001: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction. Query:
INSERT INTO umotors_cache_filters (id, curr_time, path_id, path, list_item_id, list_id, list_item_value, list_item_path, dataplistiAll)
SELECT
CRC32(CONCAT(tt1.paths, '-', tt1.list_item_id)) id
, NOW() curr_time
, CRC32(tt1.paths) path_id
, tt1.paths `path`
, tt1.list_item_id
, tt1.list_id
, tt1.list_item_value
, tt1.list_item_path
, COALESCE((tt2.list_item_id > 0) * 1, 0) dataplistiAll
FROM (SELECT
'/equipment/gloves/by-city/green/' AS `paths`, `li`.`id` AS `list_item_id`, `li`.`list_id` AS `list_id`, `li`.`value` AS `list_item_value`, `li`.`path` AS `list_item_path`
FROM `shop_items`
LEFT JOIN `property_value_ints` AS `plisti588_0` ON `shop_items`.`id` = `plisti588_0`.`entity_id` AND `plisti588_0`.`value` = 25394 AND `plisti588_0`.`property_id` = 588
INNER JOIN `property_value_ints` AS `pvi_filter` ON `pvi_filter`.`entity_id` = `shop_items`.`id` AND `pvi_filter`.`property_id` IN (241, 1822, 3992, 3180, 3187, 3903, 588, 213, 159, 4440)
INNER JOIN `properties` AS `p_filter` ON `p_filter`.`id` = `pvi_filter`.`property_id`
INNER JOIN `list_items` AS `li` ON `li`.`id` = `pvi_filter`.`value` AND `li`.`list_id` = p_filter.list_id
WHERE `shop_items`.`shop_id` = 3 AND ( `shop_items`.`start_datetime` < '2024-05-11 13:45:02' OR `shop_items`.`start_datetime` = '0000-00-00 00:00:00' ) AND ( `shop_items`.`end_datetime` > '2024-05-11 13:45:02' OR `shop_items`.`end_datetime` = '0000-00-00 00:00:00' ) AND `shop_items`.`siteuser_group_id` IN (0, -1) AND `shop_items`.`shop_group_id` IN ('74941') AND `shop_items`.`id` <> shop_items.modification_id AND `shop_items`.`active` = 1 AND `shop_items`.`active` = 1 AND `shop_items`.`deleted` = 0
GROUP BY `li`.`list_id`, `li`.`id`) tt1
LEFT JOIN (SELECT
`li`.`id` AS `list_item_id`
FROM `shop_items`
INNER JOIN `property_value_ints` AS `plisti588_0` ON `shop_items`.`id` = `plisti588_0`.`entity_id` AND `plisti588_0`.`value` = 25394 AND `plisti588_0`.`property_id` = 588
INNER JOIN `property_value_ints` AS `pvi_filter` ON `pvi_filter`.`entity_id` = `shop_items`.`id` AND `pvi_filter`.`property_id` IN (241, 1822, 3992, 3180, 3187, 3903, 588, 213, 159, 4440)
INNER JOIN `properties` AS `p_filter` ON `p_filter`.`id` = `pvi_filter`.`property_id`
INNER JOIN `list_items` AS `li` ON `li`.`id` = `pvi_filter`.`value` AND `li`.`list_id` = p_filter.list_id
WHERE `shop_items`.`shop_id` = 3 AND ( `shop_items`.`start_datetime` < '2024-05-11 13:45:02' OR `shop_items`.`start_datetime` = '0000-00-00 00:00:00' ) AND ( `shop_items`.`end_datetime` > '2024-05-11 13:45:02' OR `shop_items`.`end_datetime` = '0000-00-00 00:00:00' ) AND `shop_items`.`siteuser_group_id` IN (0, -1) AND `shop_items`.`shop_group_id` IN ('74941') AND `shop_items`.`id` <> shop_items.modification_id AND `shop_items`.`active` = 1 AND `shop_items`.`active` = 1 AND `shop_items`.`deleted` = 0
GROUP BY `li`.`list_id`, `li`.`id`) tt2 on tt2.list_item_id = tt1.list_item_id