https://dev.laiglesiavirtual.com/ws/get-blog-list?bid=17&limit=1&oid=20

Query Metrics

5 Database Queries
5 Different statements
1.54 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.62 ms
SELECT * FROM blog 
        			WHERE organization_id = '20' 
        				AND is_active = 1 
        				AND is_publish = 1  AND blog_id < '17'  ORDER BY blog_id DESC LIMIT 1
Parameters:
[]
2 0.21 ms
SELECT * FROM blog 
        			WHERE organization_id = '20' 
        				AND is_active = 1 
        				AND is_publish = 1  AND blog_id > '17'  ORDER BY blog_id DESC LIMIT 1
Parameters:
[]
3 0.33 ms
SELECT t0.blog_id AS blog_id_1, t0.name AS name_2, t0.short_content AS short_content_3, t0.large_content AS large_content_4, t0.bkg_image AS bkg_image_5, t0.created_at AS created_at_6, t0.is_active AS is_active_7, t0.is_publish AS is_publish_8, t0.file_path AS file_path_9, t0.file_extension AS file_extension_10, t0.dropbox_path AS dropbox_path_11, t0.dropbox_id AS dropbox_id_12, t0.has_notification AS has_notification_13, t0.blog_category_id AS blog_category_id_14, t0.created_by AS created_by_15, t0.organization_id AS organization_id_16 FROM blog t0 WHERE t0.is_active = ? AND t0.is_publish = ? AND t0.organization_id = ? AND t0.blog_id = ?
Parameters:
[
  1
  1
  "20"
  "17"
]
4 0.17 ms
SELECT t0.blog_category_id AS blog_category_id_1, t0.name AS name_2, t0.description AS description_3, t0.is_active AS is_active_4, t0.created_at AS created_at_5, t0.created_by AS created_by_6, t0.organization_id AS organization_id_7 FROM blog_category t0 WHERE t0.blog_category_id = ?
Parameters:
[
  2
]
5 0.20 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.status AS status_6, t0.address AS address_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.avatar_path AS avatar_path_10, t0.token AS token_11, t0.birthdate AS birthdate_12, t0.gender AS gender_13, t0.phone_primary AS phone_primary_14, t0.phone_secondary AS phone_secondary_15, t0.user_role_id AS user_role_id_16, t0.organization_id AS organization_id_17, t0.country_id AS country_id_18 FROM user t0 WHERE t0.id = ?
Parameters:
[
  35
]

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
App\Entity\Blog No errors.
App\Entity\BlogCategory No errors.
App\Entity\User No errors.
App\Entity\Organization No errors.
App\Entity\UserRole No errors.
App\Entity\Country No errors.