GET https://www.coffeeine.mikamatto.com/

Query Metrics

9 Database Queries
6 Different statements
3.65 ms Query time
2 Invalid entities
11 Managed entities

Queries

Group similar statements

# Time Info
1 0.71 ms
SELECT a0_.id AS id_0, a0_.text AS text_1, a0_.style AS style_2, a0_.dismissable AS dismissable_3, a0_.display_from AS display_from_4, a0_.display_until AS display_until_5, a0_.target AS target_6 FROM alert a0_ WHERE (a0_.display_from IS NULL OR a0_.display_from <= ?) AND (a0_.display_until IS NULL OR a0_.display_until >= ?) ORDER BY a0_.id ASC LIMIT 5
Parameters:
[
  "2026-02-27 10:51:24"
  "2026-02-27 10:51:24"
]
2 0.45 ms
SELECT l0_.id AS id_0, l0_.date_listed AS date_listed_1, l0_.date_sold AS date_sold_2, l0_.price AS price_3, l0_.warranty AS warranty_4, l0_.postage AS postage_5, l0_.item_id AS item_id_6, l0_.customer_id AS customer_id_7 FROM listing l0_ WHERE l0_.date_sold IS NULL OR l0_.date_sold > ? ORDER BY CASE WHEN l0_.date_sold IS NULL THEN 0 ELSE 1 END ASC, l0_.date_sold DESC, l0_.date_listed DESC LIMIT 12
Parameters:
[
  "2026-02-13 10:51:24"
]
3 0.58 ms
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.thumb AS thumb_3, p0_.hero AS hero_4, p0_.video AS video_5, p0_.body AS body_6, p0_.released_at AS released_at_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p0_.category_id AS category_id_10 FROM post p0_ ORDER BY p0_.created_at DESC LIMIT 10
Parameters:
[]
4 0.56 ms
SELECT a0_.id AS id_0, a0_.text AS text_1, a0_.style AS style_2, a0_.dismissable AS dismissable_3, a0_.display_from AS display_from_4, a0_.display_until AS display_until_5, a0_.target AS target_6 FROM alert a0_ WHERE (a0_.display_from IS NULL OR a0_.display_from <= ?) AND (a0_.display_until IS NULL OR a0_.display_until >= ?) ORDER BY a0_.id ASC LIMIT 5
Parameters:
[
  "2026-02-27 10:51:24"
  "2026-02-27 10:51:24"
]
5 0.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4 FROM category t0 WHERE t0.id = ?
Parameters:
[
  2
]
6 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4 FROM category t0 WHERE t0.id = ?
Parameters:
[
  6
]
7 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4 FROM category t0 WHERE t0.id = ?
Parameters:
[
  5
]
8 0.27 ms
SELECT l0_.id AS id_0, l0_.date_listed AS date_listed_1, l0_.date_sold AS date_sold_2, l0_.price AS price_3, l0_.warranty AS warranty_4, l0_.postage AS postage_5, l0_.item_id AS item_id_6, l0_.customer_id AS customer_id_7 FROM listing l0_ WHERE l0_.item_id = ? AND l0_.date_sold IS NULL
Parameters:
[
  22
]
9 0.25 ms
SELECT t0.id AS id_1, t0.category AS category_2, t0.item_code AS item_code_3, t0.opened_at AS opened_at_4, t0.legacy_code AS legacy_code_5, t0.access_key AS access_key_6, t0.brand AS brand_7, t0.model AS model_8, t0.title AS title_9, t0.picture AS picture_10, t0.description AS description_11, t0.notes AS notes_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.date AS date_15, t0.date_accuracy AS date_accuracy_16, t0.date_estimated AS date_estimated_17, t0.gallery_id AS gallery_id_18 FROM item t0 WHERE t0.id = ?
Parameters:
[
  22
]

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\Post\Post 5
App\Entity\Taxonomy\Category 3
App\Entity\Listing\Listing 1
App\Entity\Item\Item 1
App\Entity\Gallery\Gallery 1

Entities Mapping

Class Mapping errors
App\Entity\System\Alert No errors.
App\Entity\Listing\Listing
  • The association App\Entity\Listing\Listing#customer refers to the inverse side field App\Entity\User\User#purchases which does not exist.
App\Entity\Item\Item No errors.
App\Entity\User\User No errors.
App\Entity\Post\Post No errors.
App\Entity\Taxonomy\Category No errors.
App\Entity\Taxonomy\Tag No errors.
App\Entity\Gallery\Gallery
  • The field App\Entity\Gallery\Gallery#intervention is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Intervention\Intervention#gallery does not contain the required 'inversedBy: "intervention"' attribute.
App\Entity\Intervention\Intervention No errors.
App\Entity\Money\CashFlow No errors.
App\Entity\Taxonomy\TagGroup No errors.