GET http://sentome.tokyo.jp/jam

Query Metrics

11 Database Queries
3 Different statements
3.40 ms Query time
0 Invalid entities
26 Managed entities

Queries

Group similar statements

# Time Info
1 0.48 ms
SELECT t0.id AS id_1, t0.main_image AS main_image_2, t0.name AS name_3, t0.origin AS origin_4, t0.description AS description_5, t0.ingredients AS ingredients_6, t0.price AS price_7, t0.purchase_url AS purchase_url_8, t0.is_published AS is_published_9, t0.is_featured AS is_featured_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_sold_out AS is_sold_out_13 FROM jam t0 WHERE t0.is_published = ? ORDER BY t0.is_featured DESC, t0.id DESC
Parameters:
[
  1
]
2 0.37 ms
SELECT t0.id AS id_1, t0.image_path AS image_path_2, t0.display_order AS display_order_3, t0.jam_id AS jam_id_4 FROM jam_image t0 WHERE t0.jam_id = ?
Parameters:
[
  5
]
3 0.32 ms
SELECT t0.id AS id_1, t0.body AS body_2, t0.attribute AS attribute_3, t0.display_order AS display_order_4, t0.jam_id AS jam_id_5 FROM jam_review t0 WHERE t0.jam_id = ?
Parameters:
[
  5
]
4 0.30 ms
SELECT t0.id AS id_1, t0.image_path AS image_path_2, t0.display_order AS display_order_3, t0.jam_id AS jam_id_4 FROM jam_image t0 WHERE t0.jam_id = ?
Parameters:
[
  4
]
5 0.29 ms
SELECT t0.id AS id_1, t0.body AS body_2, t0.attribute AS attribute_3, t0.display_order AS display_order_4, t0.jam_id AS jam_id_5 FROM jam_review t0 WHERE t0.jam_id = ?
Parameters:
[
  4
]
6 0.28 ms
SELECT t0.id AS id_1, t0.image_path AS image_path_2, t0.display_order AS display_order_3, t0.jam_id AS jam_id_4 FROM jam_image t0 WHERE t0.jam_id = ?
Parameters:
[
  3
]
7 0.27 ms
SELECT t0.id AS id_1, t0.body AS body_2, t0.attribute AS attribute_3, t0.display_order AS display_order_4, t0.jam_id AS jam_id_5 FROM jam_review t0 WHERE t0.jam_id = ?
Parameters:
[
  3
]
8 0.26 ms
SELECT t0.id AS id_1, t0.image_path AS image_path_2, t0.display_order AS display_order_3, t0.jam_id AS jam_id_4 FROM jam_image t0 WHERE t0.jam_id = ?
Parameters:
[
  2
]
9 0.29 ms
SELECT t0.id AS id_1, t0.body AS body_2, t0.attribute AS attribute_3, t0.display_order AS display_order_4, t0.jam_id AS jam_id_5 FROM jam_review t0 WHERE t0.jam_id = ?
Parameters:
[
  2
]
10 0.27 ms
SELECT t0.id AS id_1, t0.image_path AS image_path_2, t0.display_order AS display_order_3, t0.jam_id AS jam_id_4 FROM jam_image t0 WHERE t0.jam_id = ?
Parameters:
[
  1
]
11 0.27 ms
SELECT t0.id AS id_1, t0.body AS body_2, t0.attribute AS attribute_3, t0.display_order AS display_order_4, t0.jam_id AS jam_id_5 FROM jam_review t0 WHERE t0.jam_id = ?
Parameters:
[
  1
]

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\JamReview 11
App\Entity\JamImage 10
App\Entity\Jam 5

Entities Mapping

Class Mapping errors
App\Entity\Jam No errors.
App\Entity\JamImage No errors.
App\Entity\JamReview No errors.