Query Metrics
3
Database Queries
3
Different statements
2.22 ms
Query time
2
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.23 ms (55.20%) |
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:
[
"3601"
]
|
0.52 ms (23.55%) |
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/3601/pridat-hodnoceni"
]
|
0.47 ms (21.25%) |
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.identifier AS identifier_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8, t0.deleted_by_id AS deleted_by_id_9, t0.user_account_id AS user_account_id_10, t0.company_id AS company_id_11 FROM applicant t0 WHERE t0.user_account_id IS NULL LIMIT 1
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\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\LogEntry | No errors. |
App\Entity\OrganizerStats | No errors. |