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

Query Metrics

9 Database Queries
6 Different statements
445.72 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

# Time Info
1 22.21 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM place p0_
Parameters:
[]
2 45.77 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM place p0_ WHERE p0_.email IS NOT NULL AND p0_.email <> ''
Parameters:
[]
3 45.46 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM place p0_ WHERE p0_.email IS NULL OR p0_.email = ''
Parameters:
[]
4 52.15 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM place p0_ WHERE p0_.email IS NOT NULL AND p0_.email <> '' AND (p0_.opted_out = 0 OR p0_.opted_out IS NULL) AND (p0_.dead = 0 OR p0_.dead IS NULL)
Parameters:
[]
5 41.61 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM place p0_ WHERE p0_.opted_out = 1
Parameters:
[]
6 59.58 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM place p0_ WHERE p0_.email IS NOT NULL AND p0_.email <> '' AND (p0_.opted_out = 0 OR p0_.opted_out IS NULL) AND (p0_.dead = 0 OR p0_.dead IS NULL) AND p0_.osm_data_date IS NOT NULL AND p0_.osm_data_date <= ?
Parameters:
[
  "2025-08-03 23:35:17"
]
7 59.44 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM place p0_ WHERE p0_.email IS NOT NULL AND p0_.email <> '' AND (p0_.opted_out = 0 OR p0_.opted_out IS NULL) AND (p0_.dead = 0 OR p0_.dead IS NULL) AND p0_.osm_data_date IS NOT NULL AND p0_.osm_data_date <= ?
Parameters:
[
  "2025-02-03 23:35:17"
]
8 59.28 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM place p0_ WHERE p0_.email IS NOT NULL AND p0_.email <> '' AND (p0_.opted_out = 0 OR p0_.opted_out IS NULL) AND (p0_.dead = 0 OR p0_.dead IS NULL) AND p0_.osm_data_date IS NOT NULL AND p0_.osm_data_date <= ?
Parameters:
[
  "2024-02-03 23:35:17"
]
9 60.22 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM place p0_ WHERE p0_.email IS NOT NULL AND p0_.email <> '' AND (p0_.opted_out = 0 OR p0_.opted_out IS NULL) AND (p0_.dead = 0 OR p0_.dead IS NULL) AND p0_.osm_data_date IS NOT NULL AND p0_.osm_data_date <= ?
Parameters:
[
  "2023-02-03 23:35:17"
]

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

Entities Mapping

Class Mapping errors
App\Entity\Place No errors.