GET http://167.172.25.174/lounge

Query Metrics

10 Database Queries
6 Different statements
8.06 ms Query time
0 Invalid entities
47 Managed entities

Queries

Group similar statements

# Time Info
1 1.06 ms
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.slug AS slug_2, b0_.description AS description_3, b0_.sort_order AS sort_order_4, b0_.is_active AS is_active_5, b0_.created_at AS created_at_6, b0_.updated_at AS updated_at_7, b0_.parent_id AS parent_id_8 FROM b_lounge_category b0_ WHERE b0_.parent_id IS NULL AND b0_.is_active = ? ORDER BY b0_.sort_order ASC, b0_.name ASC
Parameters:
[
  1
]
2 0.89 ms
SELECT b0_.id AS id_0, b0_.nickname AS nickname_1, b0_.is_anonymous AS is_anonymous_2, b0_.content AS content_3, b0_.is_hidden AS is_hidden_4, b0_.is_reported AS is_reported_5, b0_.created_at AS created_at_6, b0_.updated_at AS updated_at_7, b0_.category_id AS category_id_8, b0_.user_id AS user_id_9 FROM b_lounge_post b0_ WHERE b0_.is_hidden = ? ORDER BY b0_.created_at DESC LIMIT 20
Parameters:
[
  0
]
3 0.98 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.sort_order AS sort_order_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.parent_id AS parent_id_9 FROM b_lounge_category t0 WHERE t0.parent_id = ?
Parameters:
[
  b"Êã\x0EáñA\x11ð—³N\x18‘›ùÓ"
]
4 0.91 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.sort_order AS sort_order_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.parent_id AS parent_id_9 FROM b_lounge_category t0 WHERE t0.parent_id = ?
Parameters:
[
  b"ÊùöÉñA\x11ð—³N\x18‘›ùÓ"
]
5 0.72 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.sort_order AS sort_order_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.parent_id AS parent_id_9 FROM b_lounge_category t0 WHERE t0.parent_id = ?
Parameters:
[
  b"Ë\f<ŒñA\x11ð—³N\x18‘›ùÓ"
]
6 0.69 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.sort_order AS sort_order_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.parent_id AS parent_id_9 FROM b_lounge_category t0 WHERE t0.parent_id = ?
Parameters:
[
  b"Ë#o¨ñA\x11ð—³N\x18‘›ùÓ"
]
7 0.67 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.sort_order AS sort_order_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.parent_id AS parent_id_9 FROM b_lounge_category t0 WHERE t0.parent_id = ?
Parameters:
[
  b"Ë@õÞñA\x11ð—³N\x18‘›ùÓ"
]
8 0.68 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.user_id AS user_id_4, t0.post_id AS post_id_5, t0.comment_id AS comment_id_6 FROM b_lounge_like t0 WHERE t0.post_id = ?
Parameters:
[
  b"\x1F\x0F\fH\x0EAjº‘pÕ´;$q\x13"
]
9 0.77 ms
SELECT t0.id AS id_1, t0.nickname AS nickname_2, t0.is_anonymous AS is_anonymous_3, t0.content AS content_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.post_id AS post_id_7, t0.user_id AS user_id_8, t0.parent_id AS parent_id_9 FROM b_lounge_comment t0 WHERE t0.post_id = ? ORDER BY t0.created_at ASC
Parameters:
[
  b"\x1F\x0F\fH\x0EAjº‘pÕ´;$q\x13"
]
10 0.68 ms
SELECT t0.id AS id_1, t0.config_key AS config_key_2, t0.config_value AS config_value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM b_config t0
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\Config 23
App\Entity\LoungeCategory 22
App\Entity\LoungePost 1
App\Entity\User 1

Entities Mapping

Class Mapping errors
App\Entity\LoungeCategory No errors.
App\Entity\LoungePost No errors.
App\Entity\User No errors.
App\Entity\LoungeComment No errors.
App\Entity\LoungeLike No errors.
App\Entity\LoungeSavedPost No errors.
App\Entity\Config No errors.