Symfony Profiler

Query Metrics

26 Database Queries
6 Different statements
38.46 ms Query time
0 Invalid entities
Queries


SELECT DISTINCT t0_.id AS id_0, t0_.id AS id_1 FROM teacher t0_ LEFT JOIN `user` u1_ ON t0_.user_id = u1_.id LEFT JOIN attachment a2_ ON u1_.id = a2_.user_id LEFT JOIN teacher_language t4_ ON t0_.id = t4_.teacher_id LEFT JOIN language l3_ ON l3_.id = t4_.language_id LEFT JOIN currency c5_ ON t0_.currency_id = c5_.id LEFT JOIN spoken_language s6_ ON t0_.id = s6_.teacher_id LEFT JOIN disponibility d7_ ON t0_.id = d7_.teacher_id LEFT JOIN language l8_ ON t0_.language_id = l8_.id WHERE t0_.is_active = ? ORDER BY t0_.id ASC LIMIT 8
SELECT t0_.id AS id_0, t0_.description AS description_1, t0_.price AS price_2, t0_.short_description AS short_description_3, t0_.experience AS experience_4, t0_.motivation AS motivation_5, t0_.link AS link_6, t0_.video AS video_7, t0_.video_poster AS video_poster_8, t0_.timezone AS timezone_9, t0_.submited_at AS submited_at_10, t0_.step AS step_11, t0_.profile AS profile_12, t0_.status AS status_13, t0_.is_active AS is_active_14, t0_.activated_at AS activated_at_15, t0_.deactivated_at AS deactivated_at_16, t0_.created_at AS created_at_17, t0_.updated_at AS updated_at_18, t0_.is_verified AS is_verified_19, t0_.verified_at AS verified_at_20, t0_.wallets AS wallets_21, u1_.id AS id_22, u1_.email AS email_23, u1_.roles AS roles_24, u1_.password AS password_25, u1_.country AS country_26, u1_.last_login_ip AS last_login_ip_27, u1_.last_login_at AS last_login_at_28, u1_.banned_at AS banned_at_29, u1_.confirmation_token AS confirmation_token_30, u1_.is_verified AS is_verified_31, u1_.name AS name_32, u1_.firstname AS firstname_33, u1_.postname AS postname_34, u1_.birthday_at AS birthday_at_35, u1_.phone AS phone_36, u1_.is_active AS is_active_37, u1_.city AS city_38, u1_.latitude AS latitude_39, u1_.longitude AS longitude_40, u1_.timezone AS timezone_41, u1_.postal AS postal_42, u1_.ip AS ip_43, u1_.subdivisions AS subdivisions_44, u1_.isp AS isp_45, u1_.last_login AS last_login_46, u1_.is_phone_verified AS is_phone_verified_47, u1_.language AS language_48, u1_.currency AS currency_49, u1_.profile AS profile_50, u1_.is_newsletter_subscribed AS is_newsletter_subscribed_51, u1_.notification_settings AS notification_settings_52, u1_.created_at AS created_at_53, u1_.updated_at AS updated_at_54, a2_.id AS id_55, a2_.name AS name_56, a2_.size AS size_57, a2_.mime_type AS mime_type_58, a2_.original_name AS original_name_59, a2_.dimensions AS dimensions_60, a2_.created_at AS created_at_61, a2_.updated_at AS updated_at_62, l3_.id AS id_63, l3_.name AS name_64, l3_.flag AS flag_65, l3_.locale AS locale_66, l3_.is_active AS is_active_67, l3_.is_public AS is_public_68, l3_.teachers AS teachers_69, c4_.id AS id_70, c4_.name AS name_71, c4_.min AS min_72, s5_.id AS id_73, s5_.level AS level_74, s5_.language AS language_75, d6_.id AS id_76, d6_.day AS day_77, d6_.start AS start_78, d6_.end AS end_79, d6_.is_active AS is_active_80, l7_.id AS id_81, l7_.name AS name_82, l7_.flag AS flag_83, l7_.locale AS locale_84, l7_.is_active AS is_active_85, l7_.is_public AS is_public_86, l7_.teachers AS teachers_87, t0_.user_id AS user_id_88, t0_.currency_id AS currency_id_89, t0_.language_id AS language_id_90, t0_.activated_by_id AS activated_by_id_91, t0_.verified_by_id AS verified_by_id_92, a2_.course_id AS course_id_93, a2_.user_id AS user_id_94, s5_.teacher_id AS teacher_id_95, d6_.teacher_id AS teacher_id_96 FROM teacher t0_ LEFT JOIN `user` u1_ ON t0_.user_id = u1_.id LEFT JOIN attachment a2_ ON u1_.id = a2_.user_id LEFT JOIN teacher_language t8_ ON t0_.id = t8_.teacher_id LEFT JOIN language l3_ ON l3_.id = t8_.language_id LEFT JOIN currency c4_ ON t0_.currency_id = c4_.id LEFT JOIN spoken_language s5_ ON t0_.id = s5_.teacher_id LEFT JOIN disponibility d6_ ON t0_.id = d6_.teacher_id LEFT JOIN language l7_ ON t0_.language_id = l7_.id WHERE t0_.is_active = ? AND t0_.id IN (?, ?, ?, ?, ?, ?) ORDER BY t0_.id ASC
SELECT COUNT(DISTINCT t0_.id) AS sclr_0 FROM teacher t0_ INNER JOIN teaching_language t1_ ON t0_.id = t1_.teacher_id WHERE t1_.language_id = ? AND t0_.is_active = ? AND t0_.is_verified = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.status AS status_4, t0.difficulty AS difficulty_5, t0.level AS level_6, t0.duration AS duration_7, t0.state AS state_8, t0.is_paid AS is_paid_9, t0.amount AS amount_10, t0.amount_promo AS amount_promo_11, t0.is_promote AS is_promote_12, t0.short_description AS short_description_13, t0.is_bestseller AS is_bestseller_14, t0.is_new AS is_new_15, t0.has_certificate AS has_certificate_16, t0.has_lifetime_access AS has_lifetime_access_17, t0.quizzes_count AS quizzes_count_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.deleted_at AS deleted_at_21, t0.language_id AS language_id_22, t0.teacher_id AS teacher_id_23, t0.currency_id AS currency_id_24, t0.deleted_by_id AS deleted_by_id_25 FROM course t0 WHERE t0.teacher_id = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.hours AS hours_3, t0.buyed_at AS buyed_at_4, t0.user_id AS user_id_5, t0.teacher_id AS teacher_id_6 FROM user_teacher t0 WHERE t0.teacher_id = ?
SELECT t0.id AS id_1, t0.stars AS stars_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.teacher_id AS teacher_id_6, t0.course_id AS course_id_7, t0.user_id AS user_id_8 FROM rating t0 WHERE t0.teacher_id = ?
SELECT COUNT(DISTINCT t0_.id) AS sclr_0 FROM teacher t0_ INNER JOIN teaching_language t1_ ON t0_.id = t1_.teacher_id WHERE t1_.language_id = ? AND t0_.is_active = ? AND t0_.is_verified = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.status AS status_4, t0.difficulty AS difficulty_5, t0.level AS level_6, t0.duration AS duration_7, t0.state AS state_8, t0.is_paid AS is_paid_9, t0.amount AS amount_10, t0.amount_promo AS amount_promo_11, t0.is_promote AS is_promote_12, t0.short_description AS short_description_13, t0.is_bestseller AS is_bestseller_14, t0.is_new AS is_new_15, t0.has_certificate AS has_certificate_16, t0.has_lifetime_access AS has_lifetime_access_17, t0.quizzes_count AS quizzes_count_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.deleted_at AS deleted_at_21, t0.language_id AS language_id_22, t0.teacher_id AS teacher_id_23, t0.currency_id AS currency_id_24, t0.deleted_by_id AS deleted_by_id_25 FROM course t0 WHERE t0.teacher_id = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.hours AS hours_3, t0.buyed_at AS buyed_at_4, t0.user_id AS user_id_5, t0.teacher_id AS teacher_id_6 FROM user_teacher t0 WHERE t0.teacher_id = ?
SELECT t0.id AS id_1, t0.stars AS stars_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.teacher_id AS teacher_id_6, t0.course_id AS course_id_7, t0.user_id AS user_id_8 FROM rating t0 WHERE t0.teacher_id = ?
SELECT COUNT(DISTINCT t0_.id) AS sclr_0 FROM teacher t0_ INNER JOIN teaching_language t1_ ON t0_.id = t1_.teacher_id WHERE t1_.language_id = ? AND t0_.is_active = ? AND t0_.is_verified = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.status AS status_4, t0.difficulty AS difficulty_5, t0.level AS level_6, t0.duration AS duration_7, t0.state AS state_8, t0.is_paid AS is_paid_9, t0.amount AS amount_10, t0.amount_promo AS amount_promo_11, t0.is_promote AS is_promote_12, t0.short_description AS short_description_13, t0.is_bestseller AS is_bestseller_14, t0.is_new AS is_new_15, t0.has_certificate AS has_certificate_16, t0.has_lifetime_access AS has_lifetime_access_17, t0.quizzes_count AS quizzes_count_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.deleted_at AS deleted_at_21, t0.language_id AS language_id_22, t0.teacher_id AS teacher_id_23, t0.currency_id AS currency_id_24, t0.deleted_by_id AS deleted_by_id_25 FROM course t0 WHERE t0.teacher_id = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.hours AS hours_3, t0.buyed_at AS buyed_at_4, t0.user_id AS user_id_5, t0.teacher_id AS teacher_id_6 FROM user_teacher t0 WHERE t0.teacher_id = ?
SELECT t0.id AS id_1, t0.stars AS stars_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.teacher_id AS teacher_id_6, t0.course_id AS course_id_7, t0.user_id AS user_id_8 FROM rating t0 WHERE t0.teacher_id = ?
SELECT COUNT(DISTINCT t0_.id) AS sclr_0 FROM teacher t0_ INNER JOIN teaching_language t1_ ON t0_.id = t1_.teacher_id WHERE t1_.language_id = ? AND t0_.is_active = ? AND t0_.is_verified = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.status AS status_4, t0.difficulty AS difficulty_5, t0.level AS level_6, t0.duration AS duration_7, t0.state AS state_8, t0.is_paid AS is_paid_9, t0.amount AS amount_10, t0.amount_promo AS amount_promo_11, t0.is_promote AS is_promote_12, t0.short_description AS short_description_13, t0.is_bestseller AS is_bestseller_14, t0.is_new AS is_new_15, t0.has_certificate AS has_certificate_16, t0.has_lifetime_access AS has_lifetime_access_17, t0.quizzes_count AS quizzes_count_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.deleted_at AS deleted_at_21, t0.language_id AS language_id_22, t0.teacher_id AS teacher_id_23, t0.currency_id AS currency_id_24, t0.deleted_by_id AS deleted_by_id_25 FROM course t0 WHERE t0.teacher_id = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.hours AS hours_3, t0.buyed_at AS buyed_at_4, t0.user_id AS user_id_5, t0.teacher_id AS teacher_id_6 FROM user_teacher t0 WHERE t0.teacher_id = ?
SELECT t0.id AS id_1, t0.stars AS stars_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.teacher_id AS teacher_id_6, t0.course_id AS course_id_7, t0.user_id AS user_id_8 FROM rating t0 WHERE t0.teacher_id = ?
SELECT COUNT(DISTINCT t0_.id) AS sclr_0 FROM teacher t0_ INNER JOIN teaching_language t1_ ON t0_.id = t1_.teacher_id WHERE t1_.language_id = ? AND t0_.is_active = ? AND t0_.is_verified = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.status AS status_4, t0.difficulty AS difficulty_5, t0.level AS level_6, t0.duration AS duration_7, t0.state AS state_8, t0.is_paid AS is_paid_9, t0.amount AS amount_10, t0.amount_promo AS amount_promo_11, t0.is_promote AS is_promote_12, t0.short_description AS short_description_13, t0.is_bestseller AS is_bestseller_14, t0.is_new AS is_new_15, t0.has_certificate AS has_certificate_16, t0.has_lifetime_access AS has_lifetime_access_17, t0.quizzes_count AS quizzes_count_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.deleted_at AS deleted_at_21, t0.language_id AS language_id_22, t0.teacher_id AS teacher_id_23, t0.currency_id AS currency_id_24, t0.deleted_by_id AS deleted_by_id_25 FROM course t0 WHERE t0.teacher_id = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.hours AS hours_3, t0.buyed_at AS buyed_at_4, t0.user_id AS user_id_5, t0.teacher_id AS teacher_id_6 FROM user_teacher t0 WHERE t0.teacher_id = ?
SELECT t0.id AS id_1, t0.stars AS stars_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.teacher_id AS teacher_id_6, t0.course_id AS course_id_7, t0.user_id AS user_id_8 FROM rating t0 WHERE t0.teacher_id = ?
SELECT COUNT(DISTINCT t0_.id) AS sclr_0 FROM teacher t0_ INNER JOIN teaching_language t1_ ON t0_.id = t1_.teacher_id WHERE t1_.language_id = ? AND t0_.is_active = ? AND t0_.is_verified = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.status AS status_4, t0.difficulty AS difficulty_5, t0.level AS level_6, t0.duration AS duration_7, t0.state AS state_8, t0.is_paid AS is_paid_9, t0.amount AS amount_10, t0.amount_promo AS amount_promo_11, t0.is_promote AS is_promote_12, t0.short_description AS short_description_13, t0.is_bestseller AS is_bestseller_14, t0.is_new AS is_new_15, t0.has_certificate AS has_certificate_16, t0.has_lifetime_access AS has_lifetime_access_17, t0.quizzes_count AS quizzes_count_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.deleted_at AS deleted_at_21, t0.language_id AS language_id_22, t0.teacher_id AS teacher_id_23, t0.currency_id AS currency_id_24, t0.deleted_by_id AS deleted_by_id_25 FROM course t0 WHERE t0.teacher_id = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.hours AS hours_3, t0.buyed_at AS buyed_at_4, t0.user_id AS user_id_5, t0.teacher_id AS teacher_id_6 FROM user_teacher t0 WHERE t0.teacher_id = ?
SELECT t0.id AS id_1, t0.stars AS stars_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.teacher_id AS teacher_id_6, t0.course_id AS course_id_7, t0.user_id AS user_id_8 FROM rating t0 WHERE t0.teacher_id = ?
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\Teacher	No errors.
App\Entity\Language	No errors.
App\Entity\SpokenLanguage	No errors.
App\Entity\User	No errors.
App\Entity\Disponibility	No errors.
App\Entity\Currency	No errors.
App\Entity\Attachment	No errors.
App\Entity\Course	No errors.
App\Entity\Category	No errors.
App\Entity\Planning	No errors.
App\Entity\Social	No errors.
App\Entity\Rating	No errors.
App\Entity\UserTeacher	No errors.
App\Entity\TeacherCertification	No errors.
App\Entity\TeacherFormation	No errors.
App\Entity\TeachingLanguage	No errors.
App\Entity\OTP	No errors.
App\Entity\UserCourse	No errors.
App\Entity\Transaction	No errors.
App\Entity\Order	No errors.
App\Entity\InboxMessage	No errors.
App\Entity\InboxThread	No errors.
App\Entity\Rate	No errors.
Symfony Profiler

GET https://api.idioma.international/api/teachers?isActive=true&pagination%5Benabled%5D=false

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping
