https://vsechnykurzy.cz/kurzy/tema/retraining/3aee8a81-4b49-4159-8564-6189571f1047

Method
GET
HTTP Status
200
IP
216.73.216.222
Profiled on
Token
33d4e4

Query Metrics

73 Database Queries
16 Different statements
46.19 ms Query time
2 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.72 ms 
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/tema/retraining/3aee8a81-4b49-4159-8564-6189571f1047"
]
View formatted query    View runnable query    Explain query
2 0.76 ms 
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 WHERE t0.identifier = ? LIMIT 1
Parameters: 
[
  "retraining"
]
View formatted query    View runnable query    Explain query
3 0.74 ms 
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.seo_title AS seo_title_7, t0.seo_keywords AS seo_keywords_8, t0.seo_description AS seo_description_9, t0.identifier AS identifier_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.deleted_by_id AS deleted_by_id_13, t0.attribute_group_id AS attribute_group_id_14 FROM attribute t0 WHERE t0.identifier = ? LIMIT 1
Parameters: 
[
  "3aee8a81-4b49-4159-8564-6189571f1047"
]
View formatted query    View runnable query    Explain query
4 0.88 ms 
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"
]
View formatted query    View runnable query    Explain query
5 0.67 ms 
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: 
[
  "personal_development"
]
View formatted query    View runnable query    Explain query
6 0.56 ms 
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: 
[
  "computers_it"
]
View formatted query    View runnable query    Explain query
7 0.52 ms 
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: 
[
  "law"
]
View formatted query    View runnable query    Explain query
8 0.49 ms 
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: 
[
  "finance"
]
View formatted query    View runnable query    Explain query
9 0.42 ms 
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: 
[
  "mandatory_training_employees"
]
View formatted query    View runnable query    Explain query
10 0.43 ms 
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: 
[
  "cooking_gastronomy"
]
View formatted query    View runnable query    Explain query
11 0.46 ms 
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: 
[
  "auto_moto"
]
View formatted query    View runnable query    Explain query
12 0.43 ms 
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: 
[
  "children_motherhood"
]
View formatted query    View runnable query    Explain query
13 0.41 ms 
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: 
[
  "human_resources"
]
View formatted query    View runnable query    Explain query
14 0.37 ms 
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: 
[
  "marketing_trade"
]
View formatted query    View runnable query    Explain query
15 0.38 ms 
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: 
[
  "technical_courses"
]
View formatted query    View runnable query    Explain query
16 0.37 ms 
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: 
[
  "culture"
]
View formatted query    View runnable query    Explain query
17 0.44 ms 
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: 
[
  "health"
]
View formatted query    View runnable query    Explain query
18 0.38 ms 
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: 
[
  "hobby"
]
View formatted query    View runnable query    Explain query
19 0.39 ms 
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: 
[
  "crafts"
]
View formatted query    View runnable query    Explain query
20 0.43 ms 
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: 
[
  "exercises"
]
View formatted query    View runnable query    Explain query
21 0.38 ms 
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: 
[
  "sport"
]
View formatted query    View runnable query    Explain query
22 0.37 ms 
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: 
[
  "esoteric"
]
View formatted query    View runnable query    Explain query
23 0.40 ms 
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: 
[
  "pedagogy"
]
View formatted query    View runnable query    Explain query
24 0.39 ms 
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: 
[
  "social_services"
]
View formatted query    View runnable query    Explain query
25 0.37 ms 
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: 
[
  "training_courses"
]
View formatted query    View runnable query    Explain query
26 0.42 ms 
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.country_id AS country_id_10 FROM region t0 ORDER BY t0.name ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
27 0.62 ms 
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.region_id AS region_id_10 FROM district t0 WHERE t0.region_id = ? ORDER BY t0.name ASC
Parameters: 
[
  29
]
View formatted query    View runnable query    Explain query
28 0.64 ms 
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.region_id AS region_id_10 FROM district t0 WHERE t0.region_id = ? ORDER BY t0.name ASC
Parameters: 
[
  17
]
View formatted query    View runnable query    Explain query
29 0.49 ms 
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.region_id AS region_id_10 FROM district t0 WHERE t0.region_id = ? ORDER BY t0.name ASC
Parameters: 
[
  18
]
View formatted query    View runnable query    Explain query
30 0.46 ms 
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.region_id AS region_id_10 FROM district t0 WHERE t0.region_id = ? ORDER BY t0.name ASC
Parameters: 
[
  16
]
View formatted query    View runnable query    Explain query
31 0.41 ms 
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.region_id AS region_id_10 FROM district t0 WHERE t0.region_id = ? ORDER BY t0.name ASC
Parameters: 
[
  25
]
View formatted query    View runnable query    Explain query
32 0.42 ms 
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.region_id AS region_id_10 FROM district t0 WHERE t0.region_id = ? ORDER BY t0.name ASC
Parameters: 
[
  20
]
View formatted query    View runnable query    Explain query
33 0.34 ms 
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.region_id AS region_id_10 FROM district t0 WHERE t0.region_id = ? ORDER BY t0.name ASC
Parameters: 
[
  23
]
View formatted query    View runnable query    Explain query
34 0.41 ms 
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.region_id AS region_id_10 FROM district t0 WHERE t0.region_id = ? ORDER BY t0.name ASC
Parameters: 
[
  21
]
View formatted query    View runnable query    Explain query
35 0.36 ms 
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.region_id AS region_id_10 FROM district t0 WHERE t0.region_id = ? ORDER BY t0.name ASC
Parameters: 
[
  24
]
View formatted query    View runnable query    Explain query
36 0.36 ms 
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.region_id AS region_id_10 FROM district t0 WHERE t0.region_id = ? ORDER BY t0.name ASC
Parameters: 
[
  22
]
View formatted query    View runnable query    Explain query
37 0.63 ms 
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.region_id AS region_id_10 FROM district t0 WHERE t0.region_id = ? ORDER BY t0.name ASC
Parameters: 
[
  28
]
View formatted query    View runnable query    Explain query
38 0.54 ms 
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.region_id AS region_id_10 FROM district t0 WHERE t0.region_id = ? ORDER BY t0.name ASC
Parameters: 
[
  19
]
View formatted query    View runnable query    Explain query
39 0.54 ms 
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.region_id AS region_id_10 FROM district t0 WHERE t0.region_id = ? ORDER BY t0.name ASC
Parameters: 
[
  26
]
View formatted query    View runnable query    Explain query
40 0.51 ms 
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.region_id AS region_id_10 FROM district t0 WHERE t0.region_id = ? ORDER BY t0.name ASC
Parameters: 
[
  27
]
View formatted query    View runnable query    Explain query
41 0.68 ms 
SELECT d0_.id AS id_0, d0_.created_at AS created_at_1, d0_.updated_at AS updated_at_2, d0_.deleted_at AS deleted_at_3, d0_.name AS name_4, d0_.description AS description_5, d0_.identifier AS identifier_6, d0_.created_by_id AS created_by_id_7, d0_.updated_by_id AS updated_by_id_8, d0_.deleted_by_id AS deleted_by_id_9 FROM day_in_week d0_
Parameters: 
[]
View formatted query    View runnable query    Explain query
42 1.05 ms 
SELECT a0_.id AS id_0, a0_.created_at AS created_at_1, a0_.updated_at AS updated_at_2, a0_.deleted_at AS deleted_at_3, a0_.name AS name_4, a0_.description AS description_5, a0_.show_in_base_search AS show_in_base_search_6, a0_.show_in_homepage_search AS show_in_homepage_search_7, a0_.show_in_related_form AS show_in_related_form_8, a0_.show_in_similar_courses_search AS show_in_similar_courses_search_9, a0_.show_in_course_topic_search AS show_in_course_topic_search_10, a0_.lft AS lft_11, a0_.lvl AS lvl_12, a0_.rgt AS rgt_13, a0_.position AS position_14, a0_.show_in_submenu AS show_in_submenu_15, a0_.seo_title AS seo_title_16, a0_.seo_keywords AS seo_keywords_17, a0_.seo_description AS seo_description_18, a0_.identifier AS identifier_19, a0_.created_by_id AS created_by_id_20, a0_.updated_by_id AS updated_by_id_21, a0_.deleted_by_id AS deleted_by_id_22, a0_.image_id AS image_id_23, a0_.tree_root AS tree_root_24, a0_.parent_id AS parent_id_25 FROM attribute_group a0_ WHERE EXISTS (SELECT 1 FROM attribute_group_course_topic a1_ WHERE a1_.attribute_group_id = a0_.id AND a1_.course_topic_id IN (?)) AND a0_.show_in_submenu = ? ORDER BY a0_.id ASC
Parameters: 
[
  3
  1
]
View formatted query    View runnable query    Explain query
43 1.81 ms 
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 course_term c1_ ON c0_.id = c1_.course_id LEFT JOIN place p2_ ON c0_.place_id = p2_.id INNER JOIN course_attribute c4_ ON c0_.id = c4_.course_id INNER JOIN attribute a3_ ON a3_.id = c4_.attribute_id INNER JOIN course_state c5_ ON c0_.state_id = c5_.id WHERE (c0_.topic_id IN (?) AND a3_.id IN (?) AND c5_.identifier = ?) 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: 
[
  [
    3
  ]
  [
    434
  ]
  "ongoing"
]
View formatted query    View runnable query    Explain query
44 0.61 ms 
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_.name AS name_4, c0_.description AS description_5, c0_.identifier AS identifier_6, c0_.created_by_id AS created_by_id_7, c0_.updated_by_id AS updated_by_id_8, c0_.deleted_by_id AS deleted_by_id_9 FROM course_progress_level c0_
Parameters: 
[]
View formatted query    View runnable query    Explain query
45 0.51 ms 
SELECT t0_.id AS id_0, t0_.created_at AS created_at_1, t0_.updated_at AS updated_at_2, t0_.deleted_at AS deleted_at_3, t0_.name AS name_4, t0_.description AS description_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 FROM target_group t0_
Parameters: 
[]
View formatted query    View runnable query    Explain query
46 0.63 ms 
SELECT t0_.id AS id_0, t0_.created_at AS created_at_1, t0_.updated_at AS updated_at_2, t0_.deleted_at AS deleted_at_3, t0_.name AS name_4, t0_.description AS description_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 FROM teaching_type t0_
Parameters: 
[]
View formatted query    View runnable query    Explain query
47 4.50 ms 
SELECT r0_.id AS id_0, r0_.created_at AS created_at_1, r0_.updated_at AS updated_at_2, r0_.deleted_at AS deleted_at_3, r0_.name AS name_4, r0_.description AS description_5, r0_.identifier AS identifier_6, r0_.created_by_id AS created_by_id_7, r0_.updated_by_id AS updated_by_id_8, r0_.deleted_by_id AS deleted_by_id_9 FROM retraining_type r0_
Parameters: 
[]
View formatted query    View runnable query    Explain query
48 0.65 ms 
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_.name AS name_4, c0_.description AS description_5, c0_.identifier AS identifier_6, c0_.created_by_id AS created_by_id_7, c0_.updated_by_id AS updated_by_id_8, c0_.deleted_by_id AS deleted_by_id_9 FROM course_frequency c0_
Parameters: 
[]
View formatted query    View runnable query    Explain query
49 1.77 ms 
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 course_term c1_ ON c0_.id = c1_.course_id LEFT JOIN place p2_ ON c0_.place_id = p2_.id INNER JOIN course_attribute c4_ ON c0_.id = c4_.course_id INNER JOIN attribute a3_ ON a3_.id = c4_.attribute_id INNER JOIN course_state c5_ ON c0_.state_id = c5_.id WHERE (c0_.topic_id IN (?) AND a3_.id IN (?) AND c5_.identifier = ?) 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: 
[
  [
    3
  ]
  [
    434
  ]
  "ongoing"
]
View formatted query    View runnable query    Explain query
50 0.59 ms 
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: 
[]
View formatted query    View runnable query    Explain query
51 0.75 ms 
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"
]
View formatted query    View runnable query    Explain query
52 0.59 ms 
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: 
[
  "personal_development"
]
View formatted query    View runnable query    Explain query
53 0.59 ms 
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: 
[
  "computers_it"
]
View formatted query    View runnable query    Explain query
54 0.48 ms 
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: 
[
  "law"
]
View formatted query    View runnable query    Explain query
55 0.53 ms 
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: 
[
  "finance"
]
View formatted query    View runnable query    Explain query
56 0.42 ms 
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: 
[
  "mandatory_training_employees"
]
View formatted query    View runnable query    Explain query
57 0.50 ms 
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: 
[
  "cooking_gastronomy"
]
View formatted query    View runnable query    Explain query
58 0.46 ms 
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: 
[
  "auto_moto"
]
View formatted query    View runnable query    Explain query
59 0.46 ms 
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: 
[
  "children_motherhood"
]
View formatted query    View runnable query    Explain query
60 0.47 ms 
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: 
[
  "human_resources"
]
View formatted query    View runnable query    Explain query
61 0.47 ms 
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: 
[
  "marketing_trade"
]
View formatted query    View runnable query    Explain query
62 0.47 ms 
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: 
[
  "technical_courses"
]
View formatted query    View runnable query    Explain query
63 0.47 ms 
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: 
[
  "culture"
]
View formatted query    View runnable query    Explain query
64 0.48 ms 
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: 
[
  "health"
]
View formatted query    View runnable query    Explain query
65 0.46 ms 
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: 
[
  "hobby"
]
View formatted query    View runnable query    Explain query
66 0.40 ms 
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: 
[
  "crafts"
]
View formatted query    View runnable query    Explain query
67 0.39 ms 
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: 
[
  "exercises"
]
View formatted query    View runnable query    Explain query
68 0.44 ms 
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: 
[
  "sport"
]
View formatted query    View runnable query    Explain query
69 0.43 ms 
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: 
[
  "esoteric"
]
View formatted query    View runnable query    Explain query
70 0.42 ms 
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: 
[
  "pedagogy"
]
View formatted query    View runnable query    Explain query
71 0.41 ms 
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: 
[
  "social_services"
]
View formatted query    View runnable query    Explain query
72 0.42 ms 
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: 
[
  "training_courses"
]
View formatted query    View runnable query    Explain query
73 3.55 ms 
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.seo_title AS seo_title_7, t0.seo_keywords AS seo_keywords_8, t0.seo_description AS seo_description_9, t0.identifier AS identifier_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.deleted_by_id AS deleted_by_id_13, t0.attribute_group_id AS attribute_group_id_14 FROM attribute t0 WHERE t0.attribute_group_id = ?
Parameters: 
[
  8
]
View formatted query    View runnable query    Explain query

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
  • The mappings App\Entity\Course#stats and App\Entity\CourseStats#course are inconsistent with each other.
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\AttributeGroup No errors.
App\Entity\Attribute No errors.
App\Entity\Country No errors.
App\Entity\Region No errors.
App\Entity\District No errors.
Sonata\MediaBundle\Entity\BaseMedia No errors.
App\Entity\SonataMediaMedia No errors.
App\Entity\TargetGroup No errors.
App\Entity\DayInWeek No errors.
App\Entity\Place No errors.
App\Entity\Certification No errors.
App\Entity\CourseStats
  • The association App\Entity\CourseStats#course refers to the inverse side field App\Entity\Course#courseStats which does not exist.
App\Entity\OrganizerStats No errors.