Symfony Profiler

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 = 7;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.lang AS lang_3,
  t0.stop_id AS stop_id_4
FROM
  stop_lang t0
WHERE
  t0.stop_id = ?
  AND t0.lang = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.lang AS lang_3, t0.stop_id AS stop_id_4 FROM stop_lang t0 WHERE t0.stop_id = 7 AND t0.lang = 'en' LIMIT 1;

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 = 20;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.lang AS lang_3,
  t0.stop_id AS stop_id_4
FROM
  stop_lang t0
WHERE
  t0.stop_id = ?
  AND t0.lang = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.lang AS lang_3, t0.stop_id AS stop_id_4 FROM stop_lang t0 WHERE t0.stop_id = 20 AND t0.lang = 'en' LIMIT 1;

SELECT
  DISTINCT p0_.currency AS currency_0
FROM
  price p0_
WHERE
  p0_.stop_id_dep = ?
  AND p0_.stop_id_arr = ?
  AND p0_.type = ?
  AND p0_.created_at > ?
  AND p0_.currency IS NOT NULL
  AND p0_.currency <> ''
  AND p0_.cents > 0

SELECT DISTINCT p0_.currency AS currency_0 FROM price p0_ WHERE p0_.stop_id_dep = 7 AND p0_.stop_id_arr = 20 AND p0_.type = 0 AND p0_.created_at > '2025-03-28 22:10:38' AND p0_.currency IS NOT NULL AND p0_.currency <> '' AND p0_.cents > 0;

select
  avg(duration) as avg_dur,
  min(duration) as min_dur,
  max(duration) as max_dur,
  avg(cents) as avg_cents,
  min(cents) as min_cents,
  max(cents) as max_cents
FROM
  (
    select
      duration,
      (
        CASE WHEN currency = 'GBP' THEN cents * :GBP END
      ) as cents
    from
      price p
    where
      stop_id_dep = :dep
      and stop_id_arr = :arr
      and duration is not null
      and type = :type
      and dep_datetime > NOW()
      and created_at > NOW() - INTERVAL :daysold DAY
      and currency is not null
      and currency in (:currencies)
      and cents > 0
  ) t;

select
                  avg(duration) as avg_dur,
                  min(duration) as min_dur,
                  max(duration) as max_dur,
                  avg(cents) as avg_cents,
                  min(cents) as min_cents,
                  max(cents) as max_cents
                FROM (
                  select
                    duration,
                    (
                      CASE
                      
WHEN currency = 'GBP' THEN cents * 1
                      END
                    ) as cents
                  from price p
                  where stop_id_dep = 7
                  and stop_id_arr = 20
                  and duration is not null
                  and type = 0
                  and dep_datetime > NOW()
                  and created_at > NOW() - INTERVAL 7 DAY
                  and currency is not null
                  and currency in ('GBP')
                  and cents > 0
                  
                ) t;;

SELECT
  DISTINCT p0_.currency AS currency_0
FROM
  price p0_
WHERE
  p0_.stop_id_dep = ?
  AND p0_.stop_id_arr = ?
  AND p0_.type = ?
  AND p0_.created_at > ?
  AND p0_.currency IS NOT NULL
  AND p0_.currency <> ''
  AND p0_.cents > 0

SELECT DISTINCT p0_.currency AS currency_0 FROM price p0_ WHERE p0_.stop_id_dep = 7 AND p0_.stop_id_arr = 20 AND p0_.type = 0 AND p0_.created_at > '2025-03-05 22:10:38' AND p0_.currency IS NOT NULL AND p0_.currency <> '' AND p0_.cents > 0;

select
  avg(duration) as avg_dur,
  min(duration) as min_dur,
  max(duration) as max_dur,
  avg(cents) as avg_cents,
  min(cents) as min_cents,
  max(cents) as max_cents
FROM
  (
    select
      duration,
      (
        CASE WHEN currency = 'GBP' THEN cents * :GBP END
      ) as cents
    from
      price p
    where
      stop_id_dep = :dep
      and stop_id_arr = :arr
      and duration is not null
      and type = :type
      and dep_datetime > NOW()
      and created_at > NOW() - INTERVAL :daysold DAY
      and currency is not null
      and currency in (:currencies)
      and cents > 0
  ) t;

select
                  avg(duration) as avg_dur,
                  min(duration) as min_dur,
                  max(duration) as max_dur,
                  avg(cents) as avg_cents,
                  min(cents) as min_cents,
                  max(cents) as max_cents
                FROM (
                  select
                    duration,
                    (
                      CASE
                      
WHEN currency = 'GBP' THEN cents * 1
                      END
                    ) as cents
                  from price p
                  where stop_id_dep = 7
                  and stop_id_arr = 20
                  and duration is not null
                  and type = 0
                  and dep_datetime > NOW()
                  and created_at > NOW() - INTERVAL 30 DAY
                  and currency is not null
                  and currency in ('GBP')
                  and cents > 0
                  
                ) t;;

select
  p.*
from
  price p
where
  stop_id_dep = :dep
  and stop_id_arr = :arr
  and type = :type
  and cents > 0
  and currency is not null
order by
  id desc
limit
  15

select p.*
                from price p
                where stop_id_dep = 7
                and stop_id_arr = 20
                and type = 0
                and cents > 0
                and currency is not null
                order by id desc
                limit 15;

SELECT
  t0.id AS id_1,
  t0.path AS path_2,
  t0.content AS content_3,
  t0.meta AS meta_4
FROM
  block t0
WHERE
  t0.path = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.path AS path_2, t0.content AS content_3, t0.meta AS meta_4 FROM block t0 WHERE t0.path = '/en_GB/bus-o-d-7-20' LIMIT 1;

SELECT
  p0_.carrier_name AS carrier_name_0,
  count(p0_.carrier_name) AS sclr_1
FROM
  price p0_
WHERE
  p0_.stop_id_dep = ?
  AND p0_.stop_id_arr = ?
  AND p0_.type = ?
  AND p0_.carrier_name IS NOT NULL
GROUP BY
  p0_.carrier_name
ORDER BY
  sclr_1 DESC
LIMIT
  10

SELECT p0_.carrier_name AS carrier_name_0, count(p0_.carrier_name) AS sclr_1 FROM price p0_ WHERE p0_.stop_id_dep = 7 AND p0_.stop_id_arr = 20 AND p0_.type = 0 AND p0_.carrier_name IS NOT NULL GROUP BY p0_.carrier_name ORDER BY sclr_1 DESC LIMIT 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;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.lang AS lang_3,
  t0.stop_id AS stop_id_4
FROM
  stop_lang t0
WHERE
  t0.stop_id = ?
  AND t0.lang = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.lang AS lang_3, t0.stop_id AS stop_id_4 FROM stop_lang t0 WHERE t0.stop_id = 1 AND t0.lang = 'en' LIMIT 1;

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.lang AS lang_3,
  t0.stop_id AS stop_id_4
FROM
  stop_lang t0
WHERE
  t0.stop_id = ?
  AND t0.lang = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.lang AS lang_3, t0.stop_id AS stop_id_4 FROM stop_lang t0 WHERE t0.stop_id = 10 AND t0.lang = 'en' LIMIT 1;

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 = 102;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.lang AS lang_3,
  t0.stop_id AS stop_id_4
FROM
  stop_lang t0
WHERE
  t0.stop_id = ?
  AND t0.lang = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.lang AS lang_3, t0.stop_id AS stop_id_4 FROM stop_lang t0 WHERE t0.stop_id = 102 AND t0.lang = 'en' LIMIT 1;

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 = 1021;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.lang AS lang_3,
  t0.stop_id AS stop_id_4
FROM
  stop_lang t0
WHERE
  t0.stop_id = ?
  AND t0.lang = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.lang AS lang_3, t0.stop_id AS stop_id_4 FROM stop_lang t0 WHERE t0.stop_id = 1021 AND t0.lang = 'en' LIMIT 1;

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 = 12;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.lang AS lang_3,
  t0.stop_id AS stop_id_4
FROM
  stop_lang t0
WHERE
  t0.stop_id = ?
  AND t0.lang = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.lang AS lang_3, t0.stop_id AS stop_id_4 FROM stop_lang t0 WHERE t0.stop_id = 12 AND t0.lang = 'en' LIMIT 1;

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 = 14;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.lang AS lang_3,
  t0.stop_id AS stop_id_4
FROM
  stop_lang t0
WHERE
  t0.stop_id = ?
  AND t0.lang = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.lang AS lang_3, t0.stop_id AS stop_id_4 FROM stop_lang t0 WHERE t0.stop_id = 14 AND t0.lang = 'en' LIMIT 1;

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 = 16;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.lang AS lang_3,
  t0.stop_id AS stop_id_4
FROM
  stop_lang t0
WHERE
  t0.stop_id = ?
  AND t0.lang = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.lang AS lang_3, t0.stop_id AS stop_id_4 FROM stop_lang t0 WHERE t0.stop_id = 16 AND t0.lang = 'en' LIMIT 1;

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 = 18;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.lang AS lang_3,
  t0.stop_id AS stop_id_4
FROM
  stop_lang t0
WHERE
  t0.stop_id = ?
  AND t0.lang = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.lang AS lang_3, t0.stop_id AS stop_id_4 FROM stop_lang t0 WHERE t0.stop_id = 18 AND t0.lang = 'en' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.lang AS lang_3,
  t0.stop_id AS stop_id_4
FROM
  stop_lang t0
WHERE
  t0.stop_id = ?
  AND t0.lang = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.lang AS lang_3, t0.stop_id AS stop_id_4 FROM stop_lang t0 WHERE t0.stop_id = 20 AND t0.lang = 'en' LIMIT 1;

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 = 22;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.lang AS lang_3,
  t0.stop_id AS stop_id_4
FROM
  stop_lang t0
WHERE
  t0.stop_id = ?
  AND t0.lang = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.lang AS lang_3, t0.stop_id AS stop_id_4 FROM stop_lang t0 WHERE t0.stop_id = 22 AND t0.lang = 'en' LIMIT 1;

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 = 27;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.lang AS lang_3,
  t0.stop_id AS stop_id_4
FROM
  stop_lang t0
WHERE
  t0.stop_id = ?
  AND t0.lang = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.lang AS lang_3, t0.stop_id AS stop_id_4 FROM stop_lang t0 WHERE t0.stop_id = 27 AND t0.lang = 'en' LIMIT 1;

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 = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.lang AS lang_3,
  t0.stop_id AS stop_id_4
FROM
  stop_lang t0
WHERE
  t0.stop_id = ?
  AND t0.lang = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.lang AS lang_3, t0.stop_id AS stop_id_4 FROM stop_lang t0 WHERE t0.stop_id = 3 AND t0.lang = 'en' LIMIT 1;

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 = 309;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.lang AS lang_3,
  t0.stop_id AS stop_id_4
FROM
  stop_lang t0
WHERE
  t0.stop_id = ?
  AND t0.lang = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.lang AS lang_3, t0.stop_id AS stop_id_4 FROM stop_lang t0 WHERE t0.stop_id = 309 AND t0.lang = 'en' LIMIT 1;

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 = 31;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.lang AS lang_3,
  t0.stop_id AS stop_id_4
FROM
  stop_lang t0
WHERE
  t0.stop_id = ?
  AND t0.lang = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.lang AS lang_3, t0.stop_id AS stop_id_4 FROM stop_lang t0 WHERE t0.stop_id = 31 AND t0.lang = 'en' LIMIT 1;