http://158.160.22.174/cercatrova

Query Metrics

14 Database Queries
12 Different statements
7.06 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.00 ms
(14.15%)
1
SELECT t0.id AS id_1, t0.uri AS uri_2, t0.type AS type_3, t0.photo AS photo_4, t0.photo_wide AS photo_wide_5, t0.photo_background AS photo_background_6, t0.photo_avatar AS photo_avatar_7, t0.premium AS premium_8, t0.font AS font_9, t0.short_description AS short_description_10, t0.rating AS rating_11, t0.rating_vote AS rating_vote_12, t0.position AS position_13, t0.in_top_banner AS in_top_banner_14, t0.created AS created_15, t0.is_new_face AS is_new_face_16, t0.description AS description_17, t0.enabled AS enabled_18, t0.keywords AS keywords_19, t0.payment_receiver AS payment_receiver_20, t0.payment_iban AS payment_iban_21, t0.payment_ipn AS payment_ipn_22, t0.payment_bank AS payment_bank_23, t0.payment_bic AS payment_bic_24, t0.payment_okpo AS payment_okpo_25, t0.person_payment_phone AS person_payment_phone_26, t0.person_payment_card AS person_payment_card_27, t0.person_payment_bank AS person_payment_bank_28, t0.premium_detail AS premium_detail_29, t0.top_banner_expired AS top_banner_expired_30, t0.premium_expired AS premium_expired_31, t0.tc_login AS tc_login_32, t0.tc_pass AS tc_pass_33, t0.status AS status_34, t0.promo_video_id AS promo_video_id_35, t0.user_id AS user_id_36 FROM speaker t0 WHERE t0.uri = ? AND t0.enabled = ? AND t0.status = ? LIMIT 1
Parameters:
[
  "cercatrova"
  1
  1
]
0.97 ms
(13.69%)
3
SELECT t0.id AS id_1, t0.image AS image_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.name AS name_5, t0.speaker_offer AS speaker_offer_6, t0.listener_offer AS listener_offer_7, t0.charity_id AS charity_id_8, t0.charity_secret AS charity_secret_9 FROM charity t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.85 ms
(12.01%)
1
SELECT DISTINCT r0_.id AS id_0, r0_.rating AS rating_1, r0_.date AS date_2, r0_.text AS text_3, r0_.rating_detail AS rating_detail_4, r0_.status AS status_5, u1_.id AS id_6, u1_.email AS email_7, u1_.email_confirmed AS email_confirmed_8, u1_.roles AS roles_9, u1_.password AS password_10, u1_.first_name AS first_name_11, u1_.last_name AS last_name_12, u1_.phone AS phone_13, u1_.timezone AS timezone_14, u1_.rating AS rating_15, u1_.rating_vote AS rating_vote_16, u1_.zoom_user_id AS zoom_user_id_17, u1_.google_access_token AS google_access_token_18, u1_.google_calendar_id AS google_calendar_id_19, u1_.avatar AS avatar_20, u1_.notification_email AS notification_email_21, u1_.notification_sms AS notification_sms_22, u1_.rebill_id AS rebill_id_23, u1_.rebill_payment_info AS rebill_payment_info_24, u1_.telegram_id AS telegram_id_25, r0_.user_id AS user_id_26, r0_.speaker_id AS speaker_id_27, r0_.consultation_id AS consultation_id_28 FROM review r0_ LEFT JOIN user u1_ ON r0_.user_id = u1_.id WHERE r0_.speaker_id = ? AND r0_.status = ? ORDER BY r0_.date DESC LIMIT 36
Parameters:
[
  11
  1
]
0.60 ms
(8.46%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.short_description AS short_description_3, t0.price AS price_4, t0.position AS position_5, t0.enabled AS enabled_6, t0.published_date AS published_date_7, t0.speaker_id AS speaker_id_8, t0.thumbnail_media_file_id AS thumbnail_media_file_id_9, t0.video_media_file_id AS video_media_file_id_10 FROM speaker_course t0 WHERE t0.enabled = ? AND t0.speaker_id = ?
Parameters:
[
  1
  11
]
0.58 ms
(8.26%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.email_confirmed AS email_confirmed_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone AS phone_8, t0.timezone AS timezone_9, t0.rating AS rating_10, t0.rating_vote AS rating_vote_11, t0.zoom_user_id AS zoom_user_id_12, t0.google_access_token AS google_access_token_13, t0.google_calendar_id AS google_calendar_id_14, t0.avatar AS avatar_15, t0.notification_email AS notification_email_16, t0.notification_sms AS notification_sms_17, t0.rebill_id AS rebill_id_18, t0.rebill_payment_info AS rebill_payment_info_19, t0.telegram_id AS telegram_id_20, t21.id AS id_22, t21.uri AS uri_23, t21.type AS type_24, t21.photo AS photo_25, t21.photo_wide AS photo_wide_26, t21.photo_background AS photo_background_27, t21.photo_avatar AS photo_avatar_28, t21.premium AS premium_29, t21.font AS font_30, t21.short_description AS short_description_31, t21.rating AS rating_32, t21.rating_vote AS rating_vote_33, t21.position AS position_34, t21.in_top_banner AS in_top_banner_35, t21.created AS created_36, t21.is_new_face AS is_new_face_37, t21.description AS description_38, t21.enabled AS enabled_39, t21.keywords AS keywords_40, t21.payment_receiver AS payment_receiver_41, t21.payment_iban AS payment_iban_42, t21.payment_ipn AS payment_ipn_43, t21.payment_bank AS payment_bank_44, t21.payment_bic AS payment_bic_45, t21.payment_okpo AS payment_okpo_46, t21.person_payment_phone AS person_payment_phone_47, t21.person_payment_card AS person_payment_card_48, t21.person_payment_bank AS person_payment_bank_49, t21.premium_detail AS premium_detail_50, t21.top_banner_expired AS top_banner_expired_51, t21.premium_expired AS premium_expired_52, t21.tc_login AS tc_login_53, t21.tc_pass AS tc_pass_54, t21.status AS status_55, t21.promo_video_id AS promo_video_id_56, t21.user_id AS user_id_57 FROM user t0 LEFT JOIN speaker t21 ON t21.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  19
]
0.57 ms
(8.15%)
1
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.type AS type_3, t0.charity_id AS charity_id_4, t0.speaker_id AS speaker_id_5 FROM speaker_charity t0 WHERE t0.speaker_id = ?
Parameters:
[
  11
]
0.49 ms
(6.98%)
1
SELECT t0.id AS id_1, t0.type AS type_2, t0.url AS url_3, t0.speaker_id AS speaker_id_4 FROM speaker_link t0 WHERE t0.speaker_id = ?
Parameters:
[
  11
]
0.49 ms
(6.88%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.uri AS uri_4 FROM category t0 INNER JOIN speaker_category ON t0.id = speaker_category.category_id WHERE speaker_category.speaker_id = ?
Parameters:
[
  11
]
0.47 ms
(6.66%)
1
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
]
0.36 ms
(5.06%)
1
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.date AS date_3, t0.text AS text_4, t0.rating_detail AS rating_detail_5, t0.status AS status_6, t0.user_id AS user_id_7, t0.speaker_id AS speaker_id_8, t0.consultation_id AS consultation_id_9 FROM review t0 WHERE t0.speaker_id = ? ORDER BY t0.date DESC
Parameters:
[
  11
]
0.35 ms
(4.90%)
1
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"
]
0.34 ms
(4.80%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.uri AS uri_4 FROM category t0 WHERE t0.id = ?
Parameters:
[
  0
]

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\MediaObject No errors.
App\Entity\User
  • The mappings App\Entity\User#speakers and App\Entity\Speaker#user are inconsistent with each other.
App\Entity\Category No errors.
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.
App\Entity\Order No errors.
App\Entity\Notification No errors.
App\Entity\Complaint No errors.
App\Entity\Charity No errors.
App\Entity\PageTemplate No errors.
App\Entity\Page No errors.