https://testavo.dataccessor.com/architectes/d/manche

Query Metrics

15 Database Queries
10 Different statements
11.03 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.58 ms
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
Parameters:
[
  "bWFuY2hlfGZyfGZy"
]
2 0.22 ms
"START TRANSACTION"
Parameters:
[]
3 0.94 ms
INSERT INTO google_place_search (created_at, place, country, place_key, place_data, search_key, locale) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "2026-08-31 09:57:29"
  "manche"
  "fr"
  "ChIJ9zVZBbiLC0gRoCi1T0gUDAM"
  """
    {\n
       "results" : \n
       [\n
          {\n
             "address_components" : \n
             [\n
                {\n
                   "long_name" : "Manche",\n
                   "short_name" : "Manche",\n
                   "types" : \n
                   [\n
                      "administrative_area_level_2",\n
                      "political"\n
                   ]\n
                },\n
                {\n
                   "long_name" : "Normandie",\n
                   "short_name" : "Normandie",\n
                   "types" : \n
                   [\n
                      "administrative_area_level_1",\n
                      "political"\n
                   ]\n
                },\n
                {\n
                   "long_name" : "France",\n
                   "short_name" : "FR",\n
                   "types" : \n
                   [\n
                      "country",\n
                      "political"\n
                   ]\n
                }\n
             ],\n
             "formatted_address" : "Manche, France",\n
             "geometry" : \n
             {\n
                "bounds" : \n
                {\n
                   "northeast" : \n
                   {\n
                      "lat" : 49.7299713,\n
                      "lng" : -0.7347886\n
                   },\n
                   "southwest" : \n
                   {\n
                      "lat" : 48.455833,\n
                      "lng" : -1.9549752\n
                   }\n
                },\n
                "location" : \n
                {\n
                   "lat" : 49.114712,\n
                   "lng" : -1.3115949\n
                },\n
                "location_type" : "APPROXIMATE",\n
                "viewport" : \n
                {\n
                   "northeast" : \n
                   {\n
                      "lat" : 49.7299713,\n
                      "lng" : -0.7347886\n
                   },\n
                   "southwest" : \n
                   {\n
                      "lat" : 48.455833,\n
                      "lng" : -1.9549752\n
                   }\n
                }\n
             },\n
             "place_id" : "ChIJ9zVZBbiLC0gRoCi1T0gUDAM",\n
             "types" : \n
             [\n
                "administrative_area_level_2",\n
                "political"\n
             ]\n
          }\n
       ],\n
       "status" : "OK"\n
    }
    """
  "bWFuY2hlfGZyfGZy"
  "fr"
]
4 1.49 ms
"COMMIT"
Parameters:
[]
5 0.58 ms
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
Parameters:
[
  "bWFuY2hlfGZyfGZy"
]
6 0.32 ms
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.slug = ? LIMIT 1
Parameters:
[
  "manche"
]
7 0.39 ms
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
Parameters:
[
  "bWFuY2hlfGZyfGZy"
]
8 0.38 ms
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 = ?
Parameters:
[
  4
]
9 0.39 ms
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
Parameters:
[
  "bWFuY2hlfGZyfGZy"
]
10 0.30 ms
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 = ?
Parameters:
[
  29
]
11 0.40 ms
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
Parameters:
[
  21
]
12 0.52 ms
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
Parameters:
[]
13 0.86 ms
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
Parameters:
[
  "main"
]
14 0.30 ms
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
Parameters:
[
  "small"
]
15 3.37 ms
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
Parameters:
[
  "department"
  "manche"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Department No errors.
App\Entity\Region No errors.
App\Entity\CityException No errors.
App\Entity\GooglePlaceSearch No errors.
App\Entity\City No errors.
App\Entity\ContentSpinning No errors.