http://backend.yayasanalkahfi.com/index.php/api/mybulletin.json?limit=100

Query Metrics

3 Database Queries
3 Different statements
8.12 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
5.29 ms
(65.13%)
1
SELECT t0.id AS id_2, t0.username AS username_3, t0.name AS name_4, t0.password AS password_5, t0.roles AS roles_6, t0.is_active AS is_active_7, t0.type FROM kmj_user t0 LEFT JOIN kmj_default_user t1 ON t0.id = t1.id WHERE t0.username = ? LIMIT 1
Parameters:
[
  "supriatnarizky96@gmail.com"
]
2.28 ms
(28.08%)
1
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT u0_.id AS id_0, u0_.status AS status_1, u0_.created_at AS created_at_2 FROM user_bulletin u0_ INNER JOIN bulletin b1_ ON u0_.bulletin_id = b1_.id WHERE u0_.status = '1' AND u0_.kmj_user_id = '1f09a37f-4a26-660c-a004-cda3666f4473') dctrn_result) dctrn_table
Parameters:
[]
0.55 ms
(6.80%)
1
SELECT DISTINCT id_0 FROM (SELECT u0_.id AS id_0, u0_.status AS status_1, u0_.created_at AS created_at_2 FROM user_bulletin u0_ INNER JOIN bulletin b1_ ON u0_.bulletin_id = b1_.id WHERE u0_.status = '1' AND u0_.kmj_user_id = '1f09a37f-4a26-660c-a004-cda3666f4473') dctrn_result LIMIT 100
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.

Entities Mapping

Class Mapping errors
Kematjaya\UserBundle\Entity\KmjUser No errors.
Kematjaya\UserBundle\Entity\DefaultUser No errors.
App\Entity\Dokumentasi No errors.
App\Entity\BulletinCabang No errors.
App\Entity\Bulletin No errors.
App\Entity\UserBulletin No errors.
App\Entity\UserDonasi No errors.
App\Entity\Artikel No errors.
App\Entity\KategoriDonasi No errors.
Kematjaya\UploadBundle\Entity\Document No errors.