INSERT INTO product (shop_id, type_id, updated_at, created_at) VALUES(1, 1, 1549583871, 1549583871);

SELECT LAST_INSERT_ID() FROM product LIMIT 1 INTO @product_id;
INSERT INTO `shoes` (product_id, url, `name`, `sub_name`, `description`, `price`, `article`, `color`, `updated_at`, `created_at`) VALUES (@product_id, 'https://store.nike.com', 'NIKE AIR MAX 95 iD', 'NIKE AIR MAX 95 iD', '', '190', '',  '', 1549583871, 1549583871);

INSERT INTO `images` (product_id, patch) VALUES (@product_id,'f48z06mnzdff5uxrlnndd.jpg',1549583871,1549583871);

SET @product_id = @product_id +1;

SET @product_id = @product_id +1;

INSERT INTO table1 (список полей 1) 
    VALUES (список  значений 1)

INSERT INTO table2 (table1_id, список полей 2) 
    LAST_INSERT_ID(), (список  значений 2)

SELECT LAST_INSERT_ID() FROM product LIMIT 1 INTO @product_id;

mysql> SELECT LAST_INSERT_ID() FROM product;
+------------------+
| LAST_INSERT_ID() |
+------------------+
|               97 |
|               97 |
|               97 |
|               97 |
|               97 |
|               97 |
|               97 |
|               97 |
|               97 |
|               97 |
|               97 |
|               97 |
|               97 |
+------------------+
13 rows in set (0.00 sec)

START TRANSACTION;

INSERT INTO product (shop_id) VALUES (1);
INSERT INTO shoes(product_id, brand) VALUES (LAST_INSERT_ID(), "brand new1");


INSERT INTO product (shop_id) VALUES (1);
INSERT INTO shoes(product_id, brand) VALUES (LAST_INSERT_ID(), "brand new2");

INSERT INTO product (shop_id) VALUES (1);
INSERT INTO shoes(product_id, brand) VALUES (LAST_INSERT_ID(), "brand new3");

COMMIT;

<e>Query: INSERT INTO shoes(product_id, brand) VALUES (LAST_INSERT_ID(), "brand new2")

Error Code: 1452
Cannot add or update a child row: a foreign key constraint fails (`learning`.`shoes`, CONSTRAINT `porduct_id_fk` FOREIGN KEY (`product_id`) REFERENCES `product` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)