http://ismart.edu.vn/vi/passkey-endpoints.html

Query Metrics

2 Database Queries
2 Different statements
1.77 ms Query time
5 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.07 ms
(60.25%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.sub_title AS sub_title_3, t0.url AS url_4, t0.thumbnail AS thumbnail_5, t0.image AS image_6, t0.slug AS slug_7, t0.icon AS icon_8, t0.sort_order AS sort_order_9, t0.display AS display_10, t0.description AS description_11, t0.content AS content_12, t0.reference_url AS reference_url_13, t0.is_hot AS is_hot_14, t0.is_new AS is_new_15, t0.is_home AS is_home_16, t0.post_type AS post_type_17, t0.document_file AS document_file_18, t0.extra_file01 AS extra_file01_19, t0.published AS published_20, t0.deleted AS deleted_21, t0.tag AS tag_22, t0.config AS config_23, t0.language AS language_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26, t27.id AS id_28, t27.employee_name AS employee_name_29, t27.business_title AS business_title_30, t27.code AS code_31, t27.email AS email_32, t27.phone AS phone_33, t27.birthday AS birthday_34, t27.address AS address_35, t27.deleted AS deleted_36, t27.created_at AS created_at_37, t27.update_at AS update_at_38, t27.post_id AS post_id_39, t27.account_id AS account_id_40, t27.department_id AS department_id_41, t42.id AS id_43, t42.created_at AS created_at_44, t42.update_at AS update_at_45, t42.post_id AS post_id_46, t47.id AS id_48, t47.deleted AS deleted_49, t47.created_at AS created_at_50, t47.updated_at AS updated_at_51, t47.user_id AS user_id_52, t47.post_id AS post_id_53, t54.id AS id_55, t54.google_title AS google_title_56, t54.google_description AS google_description_57, t54.google_tag AS google_tag_58, t54.facebook_title AS facebook_title_59, t54.facebook_description AS facebook_description_60, t54.facebook_thumbnail AS facebook_thumbnail_61, t54.created_at AS created_at_62, t54.updated_at AS updated_at_63, t54.post_id AS post_id_64, t65.id AS id_66, t65.name AS name_67, t65.deleted AS deleted_68, t65.css AS css_69, t65.custom_css AS custom_css_70, t65.created_at AS created_at_71, t65.updated_at AS updated_at_72, t65.post_id AS post_id_73, t65.block_id AS block_id_74, t0.category_id AS category_id_75, t0.gallery_id AS gallery_id_76, t0.gallery_alt_id AS gallery_alt_id_77 FROM amz_core_post t0 LEFT JOIN amz_staff t27 ON t27.post_id = t0.id LEFT JOIN amz_partner t42 ON t42.post_id = t0.id LEFT JOIN amz_article_article t47 ON t47.post_id = t0.id LEFT JOIN amz_social_sharing t54 ON t54.post_id = t0.id LEFT JOIN amz_core_page t65 ON t65.post_id = t0.id WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "passkey-endpoints"
]
0.70 ms
(39.75%)
1
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
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
App\AMZ\Core\Entity\Post
  • The association App\AMZ\Core\Entity\Post#category refers to the inverse side field App\AMZ\Core\Entity\Category#post which does not exist.
App\Backend\StaffBundle\Entity\Staff No errors.
App\Backend\Account\Entity\User No errors.
App\Backend\StaffBundle\Entity\Department No errors.
App\Backend\PartnerBundle\Entity\Partner No errors.
App\Backend\Article\Entity\Article
  • The association App\Backend\Article\Entity\Article#user refers to the inverse side field App\Backend\Account\Entity\User#article which does not exist.
App\Backend\SocialBundle\Entity\SocialSharing No errors.
App\AMZ\Core\Entity\Page
  • The field App\AMZ\Core\Entity\Page#block is on the owning side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\AMZ\Core\Entity\Block# does not contain the required 'inversedBy' attribute.
App\AMZ\Core\Entity\Block
  • The association App\AMZ\Core\Entity\Block#page refers to the inverse side field App\AMZ\Core\Entity\Page#page which does not exist.
App\AMZ\Core\Entity\Category No errors.
App\Backend\Gallery\Entity\Gallery
  • The field App\Backend\Gallery\Entity\Gallery#post is on the owning side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\AMZ\Core\Entity\Post# does not contain the required 'inversedBy' attribute.
App\Backend\Picture\Entity\Picture No errors.