http://158.160.22.174/search/

Query Metrics

7 Database Queries
6 Different statements
4.22 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.73 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.path AS path_3 FROM page_template t0 WHERE t0.path = ? LIMIT 1
Parameters:
[
  "page/news_page.html.twig"
]
2 1.32 ms
SELECT DISTINCT s0_.id AS id_0, s0_.uri AS uri_1, s0_.type AS type_2, s0_.photo AS photo_3, s0_.photo_wide AS photo_wide_4, s0_.photo_background AS photo_background_5, s0_.photo_avatar AS photo_avatar_6, s0_.premium AS premium_7, s0_.font AS font_8, s0_.short_description AS short_description_9, s0_.rating AS rating_10, s0_.rating_vote AS rating_vote_11, s0_.position AS position_12, s0_.in_top_banner AS in_top_banner_13, s0_.created AS created_14, s0_.is_new_face AS is_new_face_15, s0_.description AS description_16, s0_.enabled AS enabled_17, s0_.keywords AS keywords_18, s0_.payment_receiver AS payment_receiver_19, s0_.payment_iban AS payment_iban_20, s0_.payment_ipn AS payment_ipn_21, s0_.payment_bank AS payment_bank_22, s0_.payment_bic AS payment_bic_23, s0_.payment_okpo AS payment_okpo_24, s0_.person_payment_phone AS person_payment_phone_25, s0_.person_payment_card AS person_payment_card_26, s0_.person_payment_bank AS person_payment_bank_27, s0_.premium_detail AS premium_detail_28, s0_.top_banner_expired AS top_banner_expired_29, s0_.premium_expired AS premium_expired_30, s0_.tc_login AS tc_login_31, s0_.tc_pass AS tc_pass_32, s0_.status AS status_33, s0_.promo_video_id AS promo_video_id_34, s0_.user_id AS user_id_35 FROM speaker s0_ LEFT JOIN speaker_category s2_ ON s0_.id = s2_.speaker_id LEFT JOIN category c1_ ON c1_.id = s2_.category_id WHERE s0_.enabled = ? AND s0_.status = ? ORDER BY s0_.top_banner_expired DESC, s0_.position ASC LIMIT 3
Parameters:
[
  1
  1
]
3 0.77 ms
SELECT COUNT(s0_.id) AS sclr_0 FROM speaker s0_ WHERE s0_.id IN (SELECT DISTINCT s1_.id FROM speaker s1_ LEFT JOIN speaker_category s3_ ON s1_.id = s3_.speaker_id LEFT JOIN category c2_ ON c2_.id = s3_.category_id WHERE s1_.enabled = ? AND s1_.status = ?)
Parameters:
[
  1
  1
]
4 0.41 ms
SELECT DISTINCT p0_.id AS id_0, p0_.title AS title_1, p0_.uri AS uri_2, p0_.data AS data_3, p0_.updated AS updated_4, p0_.published AS published_5, p0_.created AS created_6, p0_.published_date AS published_date_7, p0_.meta AS meta_8, p0_.menu_title AS menu_title_9, p0_.menu_position AS menu_position_10, p0_.extra_fields AS extra_fields_11, p0_.template_id AS template_id_12 FROM PAGE p0_ WHERE p0_.template_id = ? AND p0_.published = ? ORDER BY p0_.published_date DESC LIMIT 3
Parameters:
[
  2
  1
]
5 0.29 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM PAGE p0_ WHERE p0_.template_id = ? AND p0_.published = ?
Parameters:
[
  2
  1
]
6 0.27 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.path AS path_3 FROM page_template t0 WHERE t0.path = ? LIMIT 1
Parameters:
[
  "page/static_page.html.twig"
]
7 0.43 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.uri AS uri_3, t0.data AS data_4, t0.updated AS updated_5, t0.published AS published_6, t0.created AS created_7, t0.published_date AS published_date_8, t0.meta AS meta_9, t0.menu_title AS menu_title_10, t0.menu_position AS menu_position_11, t0.extra_fields AS extra_fields_12, t0.template_id AS template_id_13 FROM PAGE t0 WHERE t0.template_id = ? AND t0.published = ? ORDER BY t0.menu_position ASC
Parameters:
[
  1
  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.

Entities Mapping

Class Mapping errors
App\Entity\Speaker No errors.
App\Entity\PageTemplate No errors.
App\Entity\Page No errors.
App\Entity\Category No errors.
App\Entity\MediaObject No errors.
App\Entity\User
  • The mappings App\Entity\User#speakers and App\Entity\Speaker#user are inconsistent with each other.
App\Entity\Badge No errors.
App\Entity\SpeakerLink No errors.
App\Entity\Review No errors.
App\Entity\SpeakerCourse No errors.
App\Entity\SpeakerConsultation No errors.
App\Entity\PromoCode No errors.
App\Entity\SpeakerCharity No errors.