Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

20.22 ms Query time

0 Invalid entities

Time▼	Count	Info
19.75 ms (97.68%)	1	SELECT tl_iso_product_collection.* FROM tl_iso_product_collection WHERE date_paid > 0 AND mp_vima_synced_at IS NULL HAVING type=? Parameters: [`"order"`] View formatted query View runnable query Explain query SELECT tl_iso_product_collection.* FROM tl_iso_product_collection WHERE date_paid > 0 AND mp_vima_synced_at IS NULL HAVING type = ? SELECT tl_iso_product_collection.* FROM tl_iso_product_collection WHERE date_paid > 0 AND mp_vima_synced_at IS NULL HAVING type='order';
0.47 ms (2.32%)	1	SELECT templates FROM tl_theme WHERE templates != '' Parameters: [] View formatted query View runnable query Explain query SELECT templates FROM tl_theme WHERE templates != '' SELECT templates FROM tl_theme WHERE templates != '';

Time▼

Count

Info

19.75 ms
(97.68%)

SELECT tl_iso_product_collection.* FROM tl_iso_product_collection WHERE date_paid > 0 AND mp_vima_synced_at IS NULL HAVING type=?

Parameters:

[
  "order"
]

View formatted query View runnable query Explain query

SELECT
  tl_iso_product_collection.*
FROM
  tl_iso_product_collection
WHERE
  date_paid > 0
  AND mp_vima_synced_at IS NULL
HAVING
  type = ?

SELECT tl_iso_product_collection.* FROM tl_iso_product_collection WHERE date_paid > 0 AND mp_vima_synced_at IS NULL HAVING type='order';

0.47 ms
(2.32%)

SELECT templates FROM tl_theme WHERE templates != ''

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  templates
FROM
  tl_theme
WHERE
  templates != ''

SELECT templates FROM tl_theme WHERE templates != '';

Name	Service
default	doctrine.dbal.default_connection

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache is not enabled.

No loaded entities.