Query Metrics
330
Database Queries
12
Different statements
316.30 ms
Query time
2
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
255.25 ms (80.70%) |
298 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.name AS name_5, t0.description AS description_6, t0.identifier AS identifier_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.deleted_by_id AS deleted_by_id_10 FROM day_in_week t0 INNER JOIN course_day_in_week ON t0.id = course_day_in_week.day_in_week_id WHERE course_day_in_week.course_id = ?
Parameters:
[
3505
]
|
29.39 ms (9.29%) |
22 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.name AS name_5, t0.description AS description_6, t0.show_in_base_search AS show_in_base_search_7, t0.show_in_homepage_search AS show_in_homepage_search_8, t0.show_in_related_form AS show_in_related_form_9, t0.show_in_similar_courses_search AS show_in_similar_courses_search_10, t0.show_in_course_topic_search AS show_in_course_topic_search_11, t0.lft AS lft_12, t0.lvl AS lvl_13, t0.rgt AS rgt_14, t0.position AS position_15, t0.show_in_submenu AS show_in_submenu_16, t0.seo_title AS seo_title_17, t0.seo_keywords AS seo_keywords_18, t0.seo_description AS seo_description_19, t0.identifier AS identifier_20, t0.created_by_id AS created_by_id_21, t0.updated_by_id AS updated_by_id_22, t0.deleted_by_id AS deleted_by_id_23, t0.image_id AS image_id_24, t0.tree_root AS tree_root_25, t0.parent_id AS parent_id_26 FROM attribute_group t0 WHERE t0.identifier = ? LIMIT 1
Parameters:
[
"management-courses"
]
|
9.90 ms (3.13%) |
1 |
SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.deleted_at AS deleted_at_3, c0_.is_created_by_admin AS is_created_by_admin_4, c0_.name AS name_5, c0_.price AS price_6, c0_.price_description AS price_description_7, c0_.short_description AS short_description_8, c0_.description AS description_9, c0_.requirements AS requirements_10, c0_.published_at AS published_at_11, c0_.end_at AS end_at_12, c0_.length AS length_13, c0_.can_customize AS can_customize_14, c0_.is_preparation_for_certification AS is_preparation_for_certification_15, c0_.is_with_certificate AS is_with_certificate_16, c0_.can_buy AS can_buy_17, c0_.can_register AS can_register_18, c0_.email AS email_19, c0_.can_paid AS can_paid_20, c0_.frequency_text AS frequency_text_21, c0_.lesson_start AS lesson_start_22, c0_.lesson_end AS lesson_end_23, c0_.is_confirmation_of_participation AS is_confirmation_of_participation_24, c0_.certification_price_not_included AS certification_price_not_included_25, c0_.certification_price AS certification_price_26, c0_.confirmation_name AS confirmation_name_27, c0_.url AS url_28, c0_.code AS code_29, c0_.is_recommended AS is_recommended_30, c0_.rating AS rating_31, c0_.is_native_speaker AS is_native_speaker_32, c0_.is_customized AS is_customized_33, c0_.only_for_adults AS only_for_adults_34, c0_.last_step AS last_step_35, c0_.place_description AS place_description_36, c0_.latitude AS latitude_37, c0_.longitude AS longitude_38, c0_.identifier AS identifier_39, c0_.created_by_id AS created_by_id_40, c0_.updated_by_id AS updated_by_id_41, c0_.deleted_by_id AS deleted_by_id_42, c0_.organizer_id AS organizer_id_43, c0_.place_id AS place_id_44, c0_.state_id AS state_id_45, c0_.type_id AS type_id_46, c0_.certificate_id AS certificate_id_47, c0_.frequency_id AS frequency_id_48, c0_.place_type_id AS place_type_id_49, c0_.topic_id AS topic_id_50, c0_.length_type_id AS length_type_id_51, c0_.progress_level_id AS progress_level_id_52, c0_.language_level_input_id AS language_level_input_id_53, c0_.language_level_output_id AS language_level_output_id_54, c0_.city_id AS city_id_55, c0_.teaching_type_id AS teaching_type_id_56, c0_.retraining_type_id AS retraining_type_id_57, c0_.target_group_id AS target_group_id_58 FROM course c0_ INNER JOIN place p1_ ON c0_.place_id = p1_.id WHERE (p1_.address_id IN (?) AND c0_.topic_id = ?) AND (c0_.organizer_id IN ( SELECT o.id FROM organizer o JOIN fos_user__user u ON o.user_account_id = u.id JOIN account_state s ON u.account_state_id = s.id WHERE s.identifier = 'active' AND u.deleted_at IS NULL ))
Parameters:
[ [ 116 117 120 130 ] 5 ] |
9.75 ms (3.08%) |
1 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.is_created_by_admin AS is_created_by_admin_5, t0.name AS name_6, t0.price AS price_7, t0.price_description AS price_description_8, t0.short_description AS short_description_9, t0.description AS description_10, t0.requirements AS requirements_11, t0.published_at AS published_at_12, t0.end_at AS end_at_13, t0.length AS length_14, t0.can_customize AS can_customize_15, t0.is_preparation_for_certification AS is_preparation_for_certification_16, t0.is_with_certificate AS is_with_certificate_17, t0.can_buy AS can_buy_18, t0.can_register AS can_register_19, t0.email AS email_20, t0.can_paid AS can_paid_21, t0.frequency_text AS frequency_text_22, t0.lesson_start AS lesson_start_23, t0.lesson_end AS lesson_end_24, t0.is_confirmation_of_participation AS is_confirmation_of_participation_25, t0.certification_price_not_included AS certification_price_not_included_26, t0.certification_price AS certification_price_27, t0.confirmation_name AS confirmation_name_28, t0.url AS url_29, t0.code AS code_30, t0.is_recommended AS is_recommended_31, t0.rating AS rating_32, t0.is_native_speaker AS is_native_speaker_33, t0.is_customized AS is_customized_34, t0.only_for_adults AS only_for_adults_35, t0.last_step AS last_step_36, t0.place_description AS place_description_37, t0.latitude AS latitude_38, t0.longitude AS longitude_39, t0.identifier AS identifier_40, t0.created_by_id AS created_by_id_41, t0.updated_by_id AS updated_by_id_42, t0.deleted_by_id AS deleted_by_id_43, t0.organizer_id AS organizer_id_44, t0.place_id AS place_id_45, t0.state_id AS state_id_46, t0.type_id AS type_id_47, t0.certificate_id AS certificate_id_48, t0.frequency_id AS frequency_id_49, t0.place_type_id AS place_type_id_50, t0.topic_id AS topic_id_51, t0.length_type_id AS length_type_id_52, t0.progress_level_id AS progress_level_id_53, t0.language_level_input_id AS language_level_input_id_54, t0.language_level_output_id AS language_level_output_id_55, t0.city_id AS city_id_56, t0.teaching_type_id AS teaching_type_id_57, t0.retraining_type_id AS retraining_type_id_58, t0.target_group_id AS target_group_id_59 FROM course t0 WHERE t0.id = ? AND ((t0.organizer_id IN ( SELECT o.id FROM organizer o JOIN fos_user__user u ON o.user_account_id = u.id JOIN account_state s ON u.account_state_id = s.id WHERE s.identifier = 'active' AND u.deleted_at IS NULL )))
Parameters:
[
"3827"
]
|
4.56 ms (1.44%) |
1 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.source AS source_5, t0.target AS target_6, t0.comment AS comment_7, t0.identifier AS identifier_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t0.deleted_by_id AS deleted_by_id_11 FROM redirect t0 WHERE t0.source = ? LIMIT 1
Parameters:
[
"kurzy/3827/podobne"
]
|
2.38 ms (0.75%) |
1 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.line1 AS line1_5, t0.line2 AS line2_6, t0.postal_code AS postal_code_7, t0.city AS city_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.identifier AS identifier_11, t0.created_by_id AS created_by_id_12, t0.updated_by_id AS updated_by_id_13, t0.deleted_by_id AS deleted_by_id_14 FROM address t0 WHERE t0.id = ?
Parameters:
[
117
]
|
1.34 ms (0.42%) |
1 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.name AS name_5, t0.description AS description_6, t0.email AS email_7, t0.phone AS phone_8, t0.identifier AS identifier_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11, t0.deleted_by_id AS deleted_by_id_12, t0.address_id AS address_id_13, t0.organizer_id AS organizer_id_14 FROM place t0 WHERE t0.id = ?
Parameters:
[
29
]
|
0.90 ms (0.28%) |
1 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.line1 AS line1_5, t0.line2 AS line2_6, t0.postal_code AS postal_code_7, t0.city AS city_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.identifier AS identifier_11, t0.created_by_id AS created_by_id_12, t0.updated_by_id AS updated_by_id_13, t0.deleted_by_id AS deleted_by_id_14 FROM address t0 WHERE t0.id IN (?)
Parameters:
[ [ "117" "116" "130" "120" ] ] |
0.82 ms (0.26%) |
1 |
SELECT id, line1, latitude, longitude, SQRT( POW(69.1 * (latitude - 50.08552558), 2) + POW(69.1 * (14.43158563 - longitude) * COS(latitude / 57.3), 2)) AS distance FROM address HAVING distance < 20 ORDER BY distance;
Parameters:
[] |
0.75 ms (0.24%) |
1 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.name AS name_5, t0.description AS description_6, t0.menu_title AS menu_title_7, t0.seo_title AS seo_title_8, t0.seo_keywords AS seo_keywords_9, t0.seo_description AS seo_description_10, t0.form_label AS form_label_11, t0.identifier AS identifier_12, t0.created_by_id AS created_by_id_13, t0.updated_by_id AS updated_by_id_14, t0.deleted_by_id AS deleted_by_id_15 FROM course_topic t0
Parameters:
[] |
0.68 ms (0.21%) |
1 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.name AS name_5, t0.description AS description_6, t0.identifier AS identifier_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.deleted_by_id AS deleted_by_id_10 FROM course_place_type t0 WHERE t0.id = ?
Parameters:
[
1
]
|
0.58 ms (0.18%) |
1 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.name AS name_5, t0.is_created_by_admin AS is_created_by_admin_6, t0.support_expiration AS support_expiration_7, t0.support_level_type AS support_level_type_8, t0.identifier AS identifier_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11, t0.deleted_by_id AS deleted_by_id_12, t0.user_account_id AS user_account_id_13, t0.logo_id AS logo_id_14, t0.logo_invoice_id AS logo_invoice_id_15, t0.support_level_id AS support_level_id_16, t0.address_id AS address_id_17 FROM organizer t0 WHERE t0.id = ?
Parameters:
[
31
]
|
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\Base | No errors. |
App\Entity\Redirect | No errors. |
FOS\UserBundle\Model\User | No errors. |
Sonata\UserBundle\Entity\BaseUser | No errors. |
App\Entity\SonataUserUser | No errors. |
App\Entity\Organizer | No errors. |
App\Entity\Promoter | No errors. |
App\Entity\CancellationPolicy | No errors. |
App\Entity\TermsAndConditions | No errors. |
App\Entity\CourseLength | No errors. |
App\Entity\CourseType | No errors. |
App\Entity\CourseTopic | No errors. |
App\Entity\City | No errors. |
App\Entity\Address | No errors. |
App\Entity\Course |
|
App\Entity\CourseFrequency | No errors. |
App\Entity\CoursePlaceType | No errors. |
App\Entity\CourseState | No errors. |
App\Entity\CourseRegistration | No errors. |
App\Entity\CourseRegistrationRequest | No errors. |
App\Entity\Email | No errors. |
App\Entity\EmailTemplate | No errors. |
App\Entity\CourseReview | No errors. |
App\Entity\CourseProgressLevel | No errors. |
App\Entity\LanguageLevel | No errors. |
App\Entity\TeachingType | No errors. |
App\Entity\CourseTerm | No errors. |
App\Entity\RetrainingType | No errors. |
App\Entity\ApplicantCompany | No errors. |
App\Entity\Applicant | No errors. |
App\Entity\SupportLevel | No errors. |
App\Entity\SupportLevelFunction | No errors. |
App\Entity\SystemFunction | No errors. |
App\Entity\Payment | No errors. |
App\Entity\AccountRole | No errors. |
App\Entity\AccountType | No errors. |
App\Entity\AccountState | No errors. |
App\Entity\CancellationCategory | No errors. |
App\Entity\CancellationRequest | No errors. |
App\Entity\UserAddress | No errors. |
App\Entity\Place | No errors. |
App\Entity\Certification | No errors. |
App\Entity\TargetGroup | No errors. |
App\Entity\CourseStats |
|
App\Entity\Attribute | No errors. |
App\Entity\Lecturer | No errors. |
App\Entity\Tag | No errors. |
App\Entity\DayInWeek | No errors. |
App\Entity\OrganizerStats | No errors. |
App\Entity\AttributeGroup | No errors. |
Sonata\MediaBundle\Entity\BaseMedia | No errors. |
App\Entity\SonataMediaMedia | No errors. |