Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.lang AS lang_5,
  t0.nom AS nom_6,
  t0.prenom AS prenom_7
FROM
  `user` t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.lang AS lang_5, t0.nom AS nom_6, t0.prenom AS prenom_7 FROM `user` t0 WHERE t0.email = '[email protected]' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.lang AS lang_5,
  t0.nom AS nom_6,
  t0.prenom AS prenom_7
FROM
  `user` t0
WHERE
  t0.email = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.lang AS lang_5, t0.nom AS nom_6, t0.prenom AS prenom_7 FROM `user` t0 WHERE t0.email = '[email protected]';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.logo AS logo_3,
  t0.catalog_allowed AS catalog_allowed_4,
  t0.last_updated AS last_updated_5,
  t0.last_update_alert AS last_update_alert_6,
  t0.competitors AS competitors_7,
  t0.is_active AS is_active_8
FROM
  project t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.catalog_allowed AS catalog_allowed_4, t0.last_updated AS last_updated_5, t0.last_update_alert AS last_update_alert_6, t0.competitors AS competitors_7, t0.is_active AS is_active_8 FROM project t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.role AS role_2,
  t0.user_id AS user_id_3,
  t0.project_id AS project_id_4
FROM
  `user_project` t0
WHERE
  t0.user_id IN (?)
  AND t0.project_id = ?

SELECT t0.id AS id_1, t0.role AS role_2, t0.user_id AS user_id_3, t0.project_id AS project_id_4 FROM `user_project` t0 WHERE t0.user_id IN (273) AND t0.project_id = 5;

SELECT
  t0.id AS id_1,
  t0.record_time AS record_time_2,
  t0.sync_time AS sync_time_3,
  t0.price AS price_4,
  t0.content_hash AS content_hash_5,
  t0.photo_concat AS photo_concat_6,
  t0.product_id AS product_id_7,
  t0.shop_id AS shop_id_8,
  t0.user_id AS user_id_9
FROM
  record t0
WHERE
  t0.content_hash = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.record_time AS record_time_2, t0.sync_time AS sync_time_3, t0.price AS price_4, t0.content_hash AS content_hash_5, t0.photo_concat AS photo_concat_6, t0.product_id AS product_id_7, t0.shop_id AS shop_id_8, t0.user_id AS user_id_9 FROM record t0 WHERE t0.content_hash = '4b6782d4a515b452ddd468624b6ba996' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.city AS city_3,
  t0.secteur AS secteur_4,
  t0.address AS address_5,
  t0.longitude AS longitude_6,
  t0.latitude AS latitude_7,
  t0.place_id AS place_id_8,
  t0.postcode AS postcode_9,
  t0.company_id AS company_id_10
FROM
  shop t0
WHERE
  t0.place_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.secteur AS secteur_4, t0.address AS address_5, t0.longitude AS longitude_6, t0.latitude AS latitude_7, t0.place_id AS place_id_8, t0.postcode AS postcode_9, t0.company_id AS company_id_10 FROM shop t0 WHERE t0.place_id = 'places/ChIJr-V3ouG9rhIRYg8IjbK7JFE' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.in_catalog AS in_catalog_3,
  t0.ean AS ean_4,
  t0.last_update AS last_update_5,
  t0.photo AS photo_6,
  t0.photomini AS photomini_7,
  t0.project_id AS project_id_8,
  t0.brand_id AS brand_id_9
FROM
  product t0
WHERE
  t0.ean = ?
  AND t0.project_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.in_catalog AS in_catalog_3, t0.ean AS ean_4, t0.last_update AS last_update_5, t0.photo AS photo_6, t0.photomini AS photomini_7, t0.project_id AS project_id_8, t0.brand_id AS brand_id_9 FROM product t0 WHERE t0.ean = '3492551065213' AND t0.project_id = 5 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.lang AS lang_5,
  t0.nom AS nom_6,
  t0.prenom AS prenom_7
FROM
  `user` t0
WHERE
  t0.email = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.lang AS lang_5, t0.nom AS nom_6, t0.prenom AS prenom_7 FROM `user` t0 WHERE t0.email = '[email protected]';

SELECT
  t0.id AS id_1,
  t0.role AS role_2,
  t0.user_id AS user_id_3,
  t0.project_id AS project_id_4
FROM
  `user_project` t0
WHERE
  t0.user_id IN (?)
  AND t0.project_id = ?

SELECT t0.id AS id_1, t0.role AS role_2, t0.user_id AS user_id_3, t0.project_id AS project_id_4 FROM `user_project` t0 WHERE t0.user_id IN (273) AND t0.project_id = 5;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.logo AS logo_3
FROM
  brand t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3 FROM brand t0 WHERE t0.name = 'Inconnue' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO product (
  name, in_catalog, ean, last_update,
  photo, photomini, project_id, brand_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO product (name, in_catalog, ean, last_update, photo, photomini, project_id, brand_id) VALUES ('', 0, '3492551065213', '2025-06-15 09:30:11', 'https://zoomalia.s3.eu-west-3.amazonaws.com/dev/zprice/684e92a33b8b8.jpg', NULL, 5, 2742);

INSERT INTO record (
  record_time, sync_time, price, content_hash,
  photo_concat, product_id, shop_id,
  user_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO record (record_time, sync_time, price, content_hash, photo_concat, product_id, shop_id, user_id) VALUES ('2025-06-15 11:30:10', '2025-06-15 09:30:11', 22.99, '4b6782d4a515b452ddd468624b6ba996', NULL, 310369, 704, 273);

INSERT INTO photo (
  filename, publicurl, TYPE, stockage,
  record_id
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO photo (filename, publicurl, TYPE, stockage, record_id) VALUES ('dev/zprice/684e92a31611b.jpg', 'https://zoomalia.s3.eu-west-3.amazonaws.com/dev/zprice/684e92a31611b.jpg', 1, 's3', 62874);

"COMMIT"

"COMMIT";