Symfony Profiler

SELECT
  t0.company_id AS company_id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.country AS country_4,
  t0.lat AS lat_5,
  t0.lon AS lon_6,
  t0.stop_id AS stop_id_7
FROM
  stop_ext t0
WHERE
  t0.stop_id = ?
  AND t0.code = ?
  AND t0.company_id = ?
LIMIT
  1

SELECT t0.company_id AS company_id_1, t0.code AS code_2, t0.name AS name_3, t0.country AS country_4, t0.lat AS lat_5, t0.lon AS lon_6, t0.stop_id AS stop_id_7 FROM stop_ext t0 WHERE t0.stop_id = 10 AND t0.code = '10' AND t0.company_id = 26 LIMIT 1;

SELECT
  t0.company_id AS company_id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.country AS country_4,
  t0.lat AS lat_5,
  t0.lon AS lon_6,
  t0.stop_id AS stop_id_7
FROM
  stop_ext t0
WHERE
  t0.stop_id = ?
  AND t0.code = ?
  AND t0.company_id = ?
LIMIT
  1

SELECT t0.company_id AS company_id_1, t0.code AS code_2, t0.name AS name_3, t0.country AS country_4, t0.lat AS lat_5, t0.lon AS lon_6, t0.stop_id AS stop_id_7 FROM stop_ext t0 WHERE t0.stop_id = 1 AND t0.code = '1' AND t0.company_id = 26 LIMIT 1;

SELECT
  t0.company_id AS company_id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.country AS country_4,
  t0.lat AS lat_5,
  t0.lon AS lon_6,
  t0.stop_id AS stop_id_7
FROM
  stop_ext t0
WHERE
  t0.code = ?
  AND t0.company_id = ?
LIMIT
  1

SELECT t0.company_id AS company_id_1, t0.code AS code_2, t0.name AS name_3, t0.country AS country_4, t0.lat AS lat_5, t0.lon AS lon_6, t0.stop_id AS stop_id_7 FROM stop_ext t0 WHERE t0.code = '10' AND t0.company_id = 26 LIMIT 1;

SELECT
  t0.company_id AS company_id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.country AS country_4,
  t0.lat AS lat_5,
  t0.lon AS lon_6,
  t0.stop_id AS stop_id_7
FROM
  stop_ext t0
WHERE
  t0.code = ?
  AND t0.company_id = ?
LIMIT
  1

SELECT t0.company_id AS company_id_1, t0.code AS code_2, t0.name AS name_3, t0.country AS country_4, t0.lat AS lat_5, t0.lon AS lon_6, t0.stop_id AS stop_id_7 FROM stop_ext t0 WHERE t0.code = '1' AND t0.company_id = 26 LIMIT 1;

select
  p.*
from
  price p
where
  p.company_id = :companyId
  and p.stop_id_dep = :depStopId
  and p.stop_id_arr = :arrStopId
  and p.stop_ext_dep = :depStopExt
  and p.stop_ext_arr = :arrStopExt
  and p.dep_datetime >= :d
  and p.dep_datetime < :d + INTERVAL 1 DAY
  and created_at > timestampadd(MINUTE, :minutes, now())

select p.*
                from price p
                where p.company_id = 26
                and p.stop_id_dep = 10
                and p.stop_id_arr= 1
                and p.stop_ext_dep = '10'
                and p.stop_ext_arr= '1'
                and p.dep_datetime >= '2025-04-11' and p.dep_datetime < '2025-04-11' + INTERVAL 1 DAY
                and created_at > timestampadd(MINUTE , -1440, now());

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.country AS country_3,
  t0.lat AS lat_4,
  t0.lon AS lon_5,
  t0.geoname_id AS geoname_id_6,
  t0.population AS population_7,
  t8.id AS id_9,
  t8.population AS population_10,
  t8.stop_id AS stop_id_11
FROM
  stop t0
  LEFT JOIN stop_info t8 ON t8.stop_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.country AS country_3, t0.lat AS lat_4, t0.lon AS lon_5, t0.geoname_id AS geoname_id_6, t0.population AS population_7, t8.id AS id_9, t8.population AS population_10, t8.stop_id AS stop_id_11 FROM stop t0 LEFT JOIN stop_info t8 ON t8.stop_id = t0.id WHERE t0.id = '10';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.country AS country_3,
  t0.lat AS lat_4,
  t0.lon AS lon_5,
  t0.geoname_id AS geoname_id_6,
  t0.population AS population_7,
  t8.id AS id_9,
  t8.population AS population_10,
  t8.stop_id AS stop_id_11
FROM
  stop t0
  LEFT JOIN stop_info t8 ON t8.stop_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.country AS country_3, t0.lat AS lat_4, t0.lon AS lon_5, t0.geoname_id AS geoname_id_6, t0.population AS population_7, t8.id AS id_9, t8.population AS population_10, t8.stop_id AS stop_id_11 FROM stop t0 LEFT JOIN stop_info t8 ON t8.stop_id = t0.id WHERE t0.id = '1';

DELETE FROM
  price
WHERE
  company_id = ?
  AND stop_ext_dep = ?
  AND stop_ext_arr = ?
  AND stop_id_dep = ?
  AND stop_id_arr = ?
  AND dep_datetime >= ?
  AND dep_datetime < DATE_ADD(?, INTERVAL 1 DAY)

DELETE FROM price WHERE company_id = 26 AND stop_ext_dep = '10' AND stop_ext_arr = '1' AND stop_id_dep = 10 AND stop_id_arr = 1 AND dep_datetime >= '2025-04-11' AND dep_datetime < DATE_ADD('2025-04-11', INTERVAL 1 DAY);

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO price (
  created_at, company_id, stop_ext_dep,
  stop_ext_arr, cents, duration, dep_datetime,
  arr_datetime, currency, full, link,
  dep_stop_name, arr_stop_name, carrier_name,
  carrier_code, connection, type, stop_id_dep,
  stop_id_arr
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?
  )

INSERT INTO price (created_at, company_id, stop_ext_dep, stop_ext_arr, cents, duration, dep_datetime, arr_datetime, currency, full, link, dep_stop_name, arr_stop_name, carrier_name, carrier_code, connection, type, stop_id_dep, stop_id_arr) VALUES ('2025-04-08 02:35:09', 26, '10', '1', NULL, NULL, '2025-04-11 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10, 1);

"COMMIT"

"COMMIT";