$db->query('INSERT INTO `table` SET ?u', json_decode($json, true));
SELECT count(id) + 1
FROM orders
WHERE id < :currentId AND project_id = 2 AND created_at >= '2022-01-01'
Никакие гонки это не запутают. SELECT * FROM nano_user
WHERE id IN (SELECT DISTINCT incoming_msg_id FROM messages)
OR id IN (SELECT DISTINCT outgoing_msg_id FROM messages)
ORDER BY id DESC
SELECT *
FROM products p
WHERE p.active='1'
ORDER BY p.id DESC
LIMIT 0,25
SELECT op.order_id,
COUNT(op.id) AS ordersCount,
SUM(op.count) AS countOrdersCount,
SUM(op.price * op.count) AS ordersSum
FROM orders_products op
LEFT Join orders o
ON op.order_id = o.id
WHERE
op.order_id IN (/* всего лишь 25 значений из предыдущего запроса */) AND
op.item_id = p.id AND
o.date > "2020-01-01" AND
o.status != 2