GET https://osm-commerces.cipherbliss.com/admin/stats/12084

Query Metrics

42 Database Queries
7 Different statements
53.75 ms Query time
0 Invalid entities
34 Managed entities

Queries

Group similar statements

# Time Info
1 45.09 ms
SELECT t0.id AS id_1, t0.uuid_for_url AS uuid_for_url_2, t0.osm_kind AS osm_kind_3, t0.email AS email_4, t0.opted_out AS opted_out_5, t0.dead AS dead_6, t0.note AS note_7, t0.modified_date AS modified_date_8, t0.zip_code AS zip_code_9, t0.asked_humains_support AS asked_humains_support_10, t0.last_contact_attempt_date AS last_contact_attempt_date_11, t0.osm_id AS osm_id_12, t0.name AS name_13, t0.has_opening_hours AS has_opening_hours_14, t0.has_address AS has_address_15, t0.has_website AS has_website_16, t0.has_wheelchair AS has_wheelchair_17, t0.has_note AS has_note_18, t0.main_tag AS main_tag_19, t0.note_content AS note_content_20, t0.displayed_date AS displayed_date_21, t0.lat AS lat_22, t0.lon AS lon_23, t0.street AS street_24, t0.housenumber AS housenumber_25, t0.siret AS siret_26, t0.stats_id AS stats_id_27 FROM place t0 WHERE t0.zip_code = ?
Parameters:
[
  "12084"
]
2 0.40 ms
SELECT t0.id AS id_1, t0.zone AS zone_2, t0.completion_percent AS completion_percent_3, t0.places_count AS places_count_4, t0.avec_horaires AS avec_horaires_5, t0.avec_adresse AS avec_adresse_6, t0.avec_site AS avec_site_7, t0.avec_accessibilite AS avec_accessibilite_8, t0.avec_note AS avec_note_9, t0.name AS name_10 FROM stats t0 WHERE t0.zone = ? LIMIT 1
Parameters:
[
  "12084"
]
3 0.14 ms
"START TRANSACTION"
Parameters:
[]
4 0.23 ms
UPDATE stats SET completion_percent = ?, places_count = ?, avec_horaires = ?, avec_adresse = ?, avec_site = ?, avec_accessibilite = ? WHERE id = ?
Parameters:
[
  0
  0
  0
  0
  0
  0
  599
]
5 0.62 ms
"COMMIT"
Parameters:
[]
6 0.46 ms
SELECT t0.id AS id_1, t0.uuid_for_url AS uuid_for_url_2, t0.osm_kind AS osm_kind_3, t0.email AS email_4, t0.opted_out AS opted_out_5, t0.dead AS dead_6, t0.note AS note_7, t0.modified_date AS modified_date_8, t0.zip_code AS zip_code_9, t0.asked_humains_support AS asked_humains_support_10, t0.last_contact_attempt_date AS last_contact_attempt_date_11, t0.osm_id AS osm_id_12, t0.name AS name_13, t0.has_opening_hours AS has_opening_hours_14, t0.has_address AS has_address_15, t0.has_website AS has_website_16, t0.has_wheelchair AS has_wheelchair_17, t0.has_note AS has_note_18, t0.main_tag AS main_tag_19, t0.note_content AS note_content_20, t0.displayed_date AS displayed_date_21, t0.lat AS lat_22, t0.lon AS lon_23, t0.street AS street_24, t0.housenumber AS housenumber_25, t0.siret AS siret_26, t0.stats_id AS stats_id_27 FROM place t0 WHERE t0.stats_id = ?
Parameters:
[
  599
]
7 0.15 ms
"START TRANSACTION"
Parameters:
[]
8 0.23 ms
UPDATE stats SET completion_percent = ?, places_count = ?, avec_horaires = ?, avec_adresse = ?, avec_site = ?, avec_accessibilite = ? WHERE id = ?
Parameters:
[
  25
  33
  16
  10
  9
  7
  599
]
9 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1697467152"
  517760
]
10 0.20 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2211363274"
  517761
]
11 0.19 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3693550801"
  517762
]
12 0.19 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4482453781"
  517763
]
13 0.19 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4490969185"
  517764
]
14 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4864473914"
  517765
]
15 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4864474226"
  517766
]
16 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4864474250"
  517767
]
17 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4864474260"
  517768
]
18 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4864474261"
  517769
]
19 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4864474282"
  517770
]
20 0.21 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7089761343"
  517771
]
21 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12025596673"
  517772
]
22 0.20 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12025634203"
  517773
]
23 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12083511044"
  517774
]
24 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12106054501"
  517775
]
25 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12390085879"
  517776
]
26 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12841608327"
  517777
]
27 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12861475415"
  517778
]
28 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "79895598"
  517779
]
29 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "79896057"
  517780
]
30 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "79896193"
  517781
]
31 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "79896233"
  517782
]
32 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "79896497"
  517783
]
33 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "79896774"
  517784
]
34 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "79896864"
  517785
]
35 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "79896923"
  517786
]
36 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "262219817"
  517787
]
37 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "759047397"
  517788
]
38 0.19 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "759047398"
  517789
]
39 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "759047399"
  517790
]
40 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "759049462"
  517791
]
41 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "759049463"
  517792
]
42 0.52 ms
"COMMIT"
Parameters:
[]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Place 33
App\Entity\Stats 1

Entities Mapping

Class Mapping errors
App\Entity\Place No errors.
App\Entity\Stats No errors.
App\Entity\History No errors.