Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.place AS place_3,
  t0.country AS country_4,
  t0.place_key AS place_key_5,
  t0.place_data AS place_data_6,
  t0.search_key AS search_key_7,
  t0.locale AS locale_8
FROM
  google_place_search t0
WHERE
  t0.search_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.place AS place_3, t0.country AS country_4, t0.place_key AS place_key_5, t0.place_data AS place_data_6, t0.search_key AS search_key_7, t0.locale AS locale_8 FROM google_place_search t0 WHERE t0.search_key = 'bHlvbi02OTAwOXxmcnxlbg==' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO google_place_search (
  created_at, place, country, place_key,
  place_data, search_key, locale
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO google_place_search (created_at, place, country, place_key, place_data, search_key, locale) VALUES ('2026-08-31 10:14:36', 'lyon-69009', 'fr', 'ChIJf7zxXRXr9EcRkHzkQS6rCBw', '{
   \"results\" : 
   [
      {
         \"address_components\" : 
         [
            {
               \"long_name\" : \"69009\",
               \"short_name\" : \"69009\",
               \"types\" : 
               [
                  \"postal_code\"
               ]
            },
            {
               \"long_name\" : \"Lyon\",
               \"short_name\" : \"Lyon\",
               \"types\" : 
               [
                  \"locality\",
                  \"political\"
               ]
            },
            {
               \"long_name\" : \"Rhône\",
               \"short_name\" : \"Rhône\",
               \"types\" : 
               [
                  \"administrative_area_level_2\",
                  \"political\"
               ]
            },
            {
               \"long_name\" : \"Auvergne-Rhône-Alpes\",
               \"short_name\" : \"Auvergne-Rhône-Alpes\",
               \"types\" : 
               [
                  \"administrative_area_level_1\",
                  \"political\"
               ]
            },
            {
               \"long_name\" : \"France\",
               \"short_name\" : \"FR\",
               \"types\" : 
               [
                  \"country\",
                  \"political\"
               ]
            }
         ],
         \"formatted_address\" : \"69009 Lyon, France\",
         \"geometry\" : 
         {
            \"bounds\" : 
            {
               \"northeast\" : 
               {
                  \"lat\" : 45.80828289999999,
                  \"lng\" : 4.8413153
               },
               \"southwest\" : 
               {
                  \"lat\" : 45.758664,
                  \"lng\" : 4.7840162
               }
            },
            \"location\" : 
            {
               \"lat\" : 45.7699424,
               \"lng\" : 4.8037184
            },
            \"location_type\" : \"APPROXIMATE\",
            \"viewport\" : 
            {
               \"northeast\" : 
               {
                  \"lat\" : 45.80828289999999,
                  \"lng\" : 4.8413153
               },
               \"southwest\" : 
               {
                  \"lat\" : 45.758664,
                  \"lng\" : 4.7840162
               }
            }
         },
         \"place_id\" : \"ChIJf7zxXRXr9EcRkHzkQS6rCBw\",
         \"types\" : 
         [
            \"postal_code\"
         ]
      }
   ],
   \"status\" : \"OK\"
}', 'bHlvbi02OTAwOXxmcnxlbg==', 'en');

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.place AS place_3,
  t0.country AS country_4,
  t0.place_key AS place_key_5,
  t0.place_data AS place_data_6,
  t0.search_key AS search_key_7,
  t0.locale AS locale_8
FROM
  google_place_search t0
WHERE
  t0.search_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.place AS place_3, t0.country AS country_4, t0.place_key AS place_key_5, t0.place_data AS place_data_6, t0.search_key AS search_key_7, t0.locale AS locale_8 FROM google_place_search t0 WHERE t0.search_key = 'bHlvbi02OTAwOXxmcnxlbg==' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.type AS type_2,
  c0_.slug AS slug_3,
  c0_.location AS location_4,
  c0_.position AS position_5,
  c0_.department_id AS department_id_6,
  c0_.parent_city_id AS parent_city_id_7
FROM
  city c0_
WHERE
  (
    c0_.slug LIKE ?
    OR c0_.slug LIKE ?
  )
  AND c0_.type LIKE ?
LIMIT
  1

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.type AS type_2, c0_.slug AS slug_3, c0_.location AS location_4, c0_.position AS position_5, c0_.department_id AS department_id_6, c0_.parent_city_id AS parent_city_id_7 FROM city c0_ WHERE (c0_.slug LIKE 'lyon-69009' OR c0_.slug LIKE 'lyon-69%') AND c0_.type LIKE 'main' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.idCountry AS idCountry_2,
  t0.code AS code_3,
  t0.name AS name_4,
  t0.slug AS slug_5,
  t0.region_id AS region_id_6,
  t0.small_region_id AS small_region_id_7
FROM
  department t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.idCountry AS idCountry_2, t0.code AS code_3, t0.name AS name_4, t0.slug AS slug_5, t0.region_id AS region_id_6, t0.small_region_id AS small_region_id_7 FROM department t0 WHERE t0.id = 94;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.slug AS slug_4,
  t0.location AS location_5,
  t0.position AS position_6,
  t0.department_id AS department_id_7,
  t0.parent_city_id AS parent_city_id_8
FROM
  city t0
WHERE
  t0.department_id = ?
ORDER BY
  t0.position ASC,
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.slug AS slug_4, t0.location AS location_5, t0.position AS position_6, t0.department_id AS department_id_7, t0.parent_city_id AS parent_city_id_8 FROM city t0 WHERE t0.department_id = 94 ORDER BY t0.position ASC, t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.slug AS slug_4,
  t0.location AS location_5,
  t0.position AS position_6,
  t0.department_id AS department_id_7,
  t0.parent_city_id AS parent_city_id_8
FROM
  city t0
WHERE
  t0.parent_city_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.slug AS slug_4, t0.location AS location_5, t0.position AS position_6, t0.department_id AS department_id_7, t0.parent_city_id AS parent_city_id_8 FROM city t0 WHERE t0.parent_city_id = 781;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.place AS place_3,
  t0.country AS country_4,
  t0.place_key AS place_key_5,
  t0.place_data AS place_data_6,
  t0.search_key AS search_key_7,
  t0.locale AS locale_8
FROM
  google_place_search t0
WHERE
  t0.search_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.place AS place_3, t0.country AS country_4, t0.place_key AS place_key_5, t0.place_data AS place_data_6, t0.search_key AS search_key_7, t0.locale AS locale_8 FROM google_place_search t0 WHERE t0.search_key = 'bHlvbi02OTAwOXxmcnxlbg==' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.idCountry AS idCountry_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.type AS type_5,
  t0.parent_region_id AS parent_region_id_6
FROM
  region t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.idCountry AS idCountry_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.parent_region_id AS parent_region_id_6 FROM region t0 WHERE t0.id = 11;

SELECT
  t0.id AS id_1,
  t0.idCountry AS idCountry_2,
  t0.code AS code_3,
  t0.name AS name_4,
  t0.slug AS slug_5,
  t0.region_id AS region_id_6,
  t0.small_region_id AS small_region_id_7
FROM
  department t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.idCountry AS idCountry_2, t0.code AS code_3, t0.name AS name_4, t0.slug AS slug_5, t0.region_id AS region_id_6, t0.small_region_id AS small_region_id_7 FROM department t0 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.idCountry AS idCountry_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.type AS type_5,
  t0.parent_region_id AS parent_region_id_6
FROM
  region t0
WHERE
  t0.type = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.idCountry AS idCountry_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.parent_region_id AS parent_region_id_6 FROM region t0 WHERE t0.type = 'main' ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.idCountry AS idCountry_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.type AS type_5,
  t0.parent_region_id AS parent_region_id_6
FROM
  region t0
WHERE
  t0.type = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.idCountry AS idCountry_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.parent_region_id AS parent_region_id_6 FROM region t0 WHERE t0.type = 'small' ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.slug AS slug_4,
  t0.location AS location_5,
  t0.position AS position_6,
  t0.department_id AS department_id_7,
  t0.parent_city_id AS parent_city_id_8
FROM
  city t0
WHERE
  t0.parent_city_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.slug AS slug_4, t0.location AS location_5, t0.position AS position_6, t0.department_id AS department_id_7, t0.parent_city_id AS parent_city_id_8 FROM city t0 WHERE t0.parent_city_id = 774;

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.type AS type_3,
  t0.slug AS slug_4,
  t0.content_en AS content_en_5
FROM
  content_spinning t0
WHERE
  t0.type = ?
  AND t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.content AS content_2, t0.type AS type_3, t0.slug AS slug_4, t0.content_en AS content_en_5 FROM content_spinning t0 WHERE t0.type = 'city' AND t0.slug = 'lyon-69000' LIMIT 1;