Symfony Profiler

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '25' AND e0_.locale = 'de' AND e0_.object_class = 'App\\Entity\\CourseMainCategory';

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.description AS description_3,
  c0_.icon AS icon_4,
  c0_.active AS active_5,
  c0_.sort_order AS sort_order_6,
  c1_.id AS id_7,
  c1_.name AS name_8,
  c1_.slug AS slug_9,
  c1_.description AS description_10,
  c1_.active AS active_11,
  c1_.sort_order AS sort_order_12,
  c2_.id AS id_13,
  c2_.name AS name_14,
  c2_.slug AS slug_15,
  c2_.description AS description_16,
  c2_.icon AS icon_17,
  c2_.active AS active_18,
  c2_.sort_order AS sort_order_19,
  c0_.image_id AS image_id_20,
  c1_.main_category_id AS main_category_id_21,
  c2_.sub_category_id AS sub_category_id_22
FROM
  course_main_category c0_
  LEFT JOIN course_sub_category c1_ ON c0_.id = c1_.main_category_id
  AND (c1_.active = ?)
  LEFT JOIN course_topic c2_ ON c1_.id = c2_.sub_category_id
  AND (c2_.active = ?)
WHERE
  c0_.active = ?
ORDER BY
  c0_.sort_order ASC,
  c0_.name ASC,
  c1_.sort_order ASC,
  c1_.name ASC,
  c2_.sort_order ASC,
  c2_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.icon AS icon_4, c0_.active AS active_5, c0_.sort_order AS sort_order_6, c1_.id AS id_7, c1_.name AS name_8, c1_.slug AS slug_9, c1_.description AS description_10, c1_.active AS active_11, c1_.sort_order AS sort_order_12, c2_.id AS id_13, c2_.name AS name_14, c2_.slug AS slug_15, c2_.description AS description_16, c2_.icon AS icon_17, c2_.active AS active_18, c2_.sort_order AS sort_order_19, c0_.image_id AS image_id_20, c1_.main_category_id AS main_category_id_21, c2_.sub_category_id AS sub_category_id_22 FROM course_main_category c0_ LEFT JOIN course_sub_category c1_ ON c0_.id = c1_.main_category_id AND (c1_.active = 1) LEFT JOIN course_topic c2_ ON c1_.id = c2_.sub_category_id AND (c2_.active = 1) WHERE c0_.active = 1 ORDER BY c0_.sort_order ASC, c0_.name ASC, c1_.sort_order ASC, c1_.name ASC, c2_.sort_order ASC, c2_.name ASC;

SELECT
  DISTINCT c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.street AS street_3,
  c0_.zip AS zip_4,
  c0_.city AS city_5,
  c0_.vat_number AS vat_number_6,
  c0_.email AS email_7,
  c0_.telephone AS telephone_8,
  c0_.longitude AS longitude_9,
  c0_.latitude AS latitude_10,
  c0_.is_visible AS is_visible_11,
  c0_.onboarding_completed AS onboarding_completed_12,
  c0_.created_via AS created_via_13,
  c0_.invitation_sent_at AS invitation_sent_at_14,
  c0_.stripe_customer_id AS stripe_customer_id_15,
  c0_.stripe_subscription_id AS stripe_subscription_id_16,
  c0_.average_rating AS average_rating_17,
  c0_.review_count AS review_count_18,
  c0_.additional_discount AS additional_discount_19,
  c0_.vme_discount AS vme_discount_20,
  c0_.country_id AS country_id_21,
  c0_.created_by_sales_user_id AS created_by_sales_user_id_22,
  c0_.edu_package_id AS edu_package_id_23
FROM
  company c0_
  INNER JOIN my_course m1_ ON (m1_.company_id = c0_.id)
WHERE
  c0_.name IS NOT NULL
  AND m1_.main_category_id = ?
  AND m1_.sub_category_id = ?
  AND m1_.topic_id = ?
ORDER BY
  c0_.name ASC

SELECT DISTINCT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.street AS street_3, c0_.zip AS zip_4, c0_.city AS city_5, c0_.vat_number AS vat_number_6, c0_.email AS email_7, c0_.telephone AS telephone_8, c0_.longitude AS longitude_9, c0_.latitude AS latitude_10, c0_.is_visible AS is_visible_11, c0_.onboarding_completed AS onboarding_completed_12, c0_.created_via AS created_via_13, c0_.invitation_sent_at AS invitation_sent_at_14, c0_.stripe_customer_id AS stripe_customer_id_15, c0_.stripe_subscription_id AS stripe_subscription_id_16, c0_.average_rating AS average_rating_17, c0_.review_count AS review_count_18, c0_.additional_discount AS additional_discount_19, c0_.vme_discount AS vme_discount_20, c0_.country_id AS country_id_21, c0_.created_by_sales_user_id AS created_by_sales_user_id_22, c0_.edu_package_id AS edu_package_id_23 FROM company c0_ INNER JOIN my_course m1_ ON (m1_.company_id = c0_.id) WHERE c0_.name IS NOT NULL AND m1_.main_category_id = 22 AND m1_.sub_category_id = 102 AND m1_.topic_id = 127 ORDER BY c0_.name ASC;

SELECT
  c0_.id AS id_0,
  COUNT(DISTINCT m1_.id) AS sclr_1
FROM
  my_course m1_
  INNER JOIN my_course_niveau m2_ ON m1_.id = m2_.my_course_id
  INNER JOIN course_niveau c0_ ON c0_.id = m2_.course_niveau_id
WHERE
  m1_.main_category_id = ?
  AND m1_.sub_category_id = ?
  AND m1_.topic_id = ?
GROUP BY
  c0_.id

SELECT c0_.id AS id_0, COUNT(DISTINCT m1_.id) AS sclr_1 FROM my_course m1_ INNER JOIN my_course_niveau m2_ ON m1_.id = m2_.my_course_id INNER JOIN course_niveau c0_ ON c0_.id = m2_.course_niveau_id WHERE m1_.main_category_id = 22 AND m1_.sub_category_id = 102 AND m1_.topic_id = 127 GROUP BY c0_.id;

SELECT
  COUNT(DISTINCT m0_.id) AS sclr_0
FROM
  my_course m0_
  LEFT JOIN company c1_ ON m0_.company_id = c1_.id
WHERE
  m0_.main_category_id = ?
  AND m0_.sub_category_id = ?
  AND m0_.topic_id = ?
  AND c1_.average_rating IS NOT NULL
  AND c1_.average_rating >= ?

SELECT COUNT(DISTINCT m0_.id) AS sclr_0 FROM my_course m0_ LEFT JOIN company c1_ ON m0_.company_id = c1_.id WHERE m0_.main_category_id = 22 AND m0_.sub_category_id = 102 AND m0_.topic_id = 127 AND c1_.average_rating IS NOT NULL AND c1_.average_rating >= '4.5';

SELECT
  c0_.id AS id_0,
  COUNT(DISTINCT m1_.id) AS sclr_1
FROM
  my_course m1_
  INNER JOIN my_course_language m2_ ON m1_.id = m2_.my_course_id
  INNER JOIN course_language c0_ ON c0_.id = m2_.course_language_id
WHERE
  m1_.main_category_id = ?
  AND m1_.sub_category_id = ?
  AND m1_.topic_id = ?
GROUP BY
  c0_.id

SELECT c0_.id AS id_0, COUNT(DISTINCT m1_.id) AS sclr_1 FROM my_course m1_ INNER JOIN my_course_language m2_ ON m1_.id = m2_.my_course_id INNER JOIN course_language c0_ ON c0_.id = m2_.course_language_id WHERE m1_.main_category_id = 22 AND m1_.sub_category_id = 102 AND m1_.topic_id = 127 GROUP BY c0_.id;

SELECT
  m0_.id AS id_0,
  m0_.title AS title_1,
  m0_.description AS description_2,
  m0_.external_link AS external_link_3,
  m0_.slug AS slug_4,
  m0_.created_at AS created_at_5,
  m0_.updated_at AS updated_at_6,
  c1_.id AS id_7,
  c1_.name AS name_8,
  c1_.slug AS slug_9,
  c1_.street AS street_10,
  c1_.zip AS zip_11,
  c1_.city AS city_12,
  c1_.vat_number AS vat_number_13,
  c1_.email AS email_14,
  c1_.telephone AS telephone_15,
  c1_.longitude AS longitude_16,
  c1_.latitude AS latitude_17,
  c1_.is_visible AS is_visible_18,
  c1_.onboarding_completed AS onboarding_completed_19,
  c1_.created_via AS created_via_20,
  c1_.invitation_sent_at AS invitation_sent_at_21,
  c1_.stripe_customer_id AS stripe_customer_id_22,
  c1_.stripe_subscription_id AS stripe_subscription_id_23,
  c1_.average_rating AS average_rating_24,
  c1_.review_count AS review_count_25,
  c1_.additional_discount AS additional_discount_26,
  c1_.vme_discount AS vme_discount_27,
  m0_.user_id AS user_id_28,
  m0_.company_id AS company_id_29,
  m0_.course_main_image_library_id AS course_main_image_library_id_30,
  m0_.main_category_id AS main_category_id_31,
  m0_.sub_category_id AS sub_category_id_32,
  m0_.topic_id AS topic_id_33,
  c1_.country_id AS country_id_34,
  c1_.created_by_sales_user_id AS created_by_sales_user_id_35,
  c1_.edu_package_id AS edu_package_id_36
FROM
  my_course m0_
  LEFT JOIN company c1_ ON m0_.company_id = c1_.id
WHERE
  m0_.main_category_id = ?
  AND m0_.sub_category_id = ?
  AND m0_.topic_id = ?
ORDER BY
  m0_.created_at DESC
LIMIT
  10

SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.description AS description_2, m0_.external_link AS external_link_3, m0_.slug AS slug_4, m0_.created_at AS created_at_5, m0_.updated_at AS updated_at_6, c1_.id AS id_7, c1_.name AS name_8, c1_.slug AS slug_9, c1_.street AS street_10, c1_.zip AS zip_11, c1_.city AS city_12, c1_.vat_number AS vat_number_13, c1_.email AS email_14, c1_.telephone AS telephone_15, c1_.longitude AS longitude_16, c1_.latitude AS latitude_17, c1_.is_visible AS is_visible_18, c1_.onboarding_completed AS onboarding_completed_19, c1_.created_via AS created_via_20, c1_.invitation_sent_at AS invitation_sent_at_21, c1_.stripe_customer_id AS stripe_customer_id_22, c1_.stripe_subscription_id AS stripe_subscription_id_23, c1_.average_rating AS average_rating_24, c1_.review_count AS review_count_25, c1_.additional_discount AS additional_discount_26, c1_.vme_discount AS vme_discount_27, m0_.user_id AS user_id_28, m0_.company_id AS company_id_29, m0_.course_main_image_library_id AS course_main_image_library_id_30, m0_.main_category_id AS main_category_id_31, m0_.sub_category_id AS sub_category_id_32, m0_.topic_id AS topic_id_33, c1_.country_id AS country_id_34, c1_.created_by_sales_user_id AS created_by_sales_user_id_35, c1_.edu_package_id AS edu_package_id_36 FROM my_course m0_ LEFT JOIN company c1_ ON m0_.company_id = c1_.id WHERE m0_.main_category_id = 22 AND m0_.sub_category_id = 102 AND m0_.topic_id = 127 ORDER BY m0_.created_at DESC LIMIT 10;

SELECT
  COUNT(DISTINCT m0_.id) AS sclr_0
FROM
  my_course m0_
WHERE
  m0_.main_category_id = ?
  AND m0_.sub_category_id = ?
  AND m0_.topic_id = ?

SELECT COUNT(DISTINCT m0_.id) AS sclr_0 FROM my_course m0_ WHERE m0_.main_category_id = 22 AND m0_.sub_category_id = 102 AND m0_.topic_id = 127;

SELECT
  c0_.id AS id_0,
  COUNT(DISTINCT m1_.id) AS sclr_1
FROM
  my_course m1_
  INNER JOIN company c0_ ON m1_.company_id = c0_.id
WHERE
  c0_.name IS NOT NULL
  AND m1_.main_category_id = ?
  AND m1_.sub_category_id = ?
  AND m1_.topic_id = ?
GROUP BY
  c0_.id

SELECT c0_.id AS id_0, COUNT(DISTINCT m1_.id) AS sclr_1 FROM my_course m1_ INNER JOIN company c0_ ON m1_.company_id = c0_.id WHERE c0_.name IS NOT NULL AND m1_.main_category_id = 22 AND m1_.sub_category_id = 102 AND m1_.topic_id = 127 GROUP BY c0_.id;

SELECT
  c0_.id AS id_0,
  COUNT(DISTINCT m1_.id) AS sclr_1
FROM
  my_course m1_
  INNER JOIN my_course_targetgroup m2_ ON m1_.id = m2_.my_course_id
  INNER JOIN course_targetgroup c0_ ON c0_.id = m2_.course_targetgroup_id
WHERE
  m1_.main_category_id = ?
  AND m1_.sub_category_id = ?
  AND m1_.topic_id = ?
GROUP BY
  c0_.id

SELECT c0_.id AS id_0, COUNT(DISTINCT m1_.id) AS sclr_1 FROM my_course m1_ INNER JOIN my_course_targetgroup m2_ ON m1_.id = m2_.my_course_id INNER JOIN course_targetgroup c0_ ON c0_.id = m2_.course_targetgroup_id WHERE m1_.main_category_id = 22 AND m1_.sub_category_id = 102 AND m1_.topic_id = 127 GROUP BY c0_.id;

SELECT
  c0_.id AS id_0,
  COUNT(DISTINCT m1_.id) AS sclr_1
FROM
  my_course m1_
  INNER JOIN my_course_type m2_ ON m1_.id = m2_.my_course_id
  INNER JOIN course_type c0_ ON c0_.id = m2_.course_type_id
WHERE
  m1_.main_category_id = ?
  AND m1_.sub_category_id = ?
  AND m1_.topic_id = ?
GROUP BY
  c0_.id

SELECT c0_.id AS id_0, COUNT(DISTINCT m1_.id) AS sclr_1 FROM my_course m1_ INNER JOIN my_course_type m2_ ON m1_.id = m2_.my_course_id INNER JOIN course_type c0_ ON c0_.id = m2_.course_type_id WHERE m1_.main_category_id = 22 AND m1_.sub_category_id = 102 AND m1_.topic_id = 127 GROUP BY c0_.id;

SELECT
  c0_.id AS id_0,
  COUNT(DISTINCT m1_.id) AS sclr_1
FROM
  my_course m1_
  INNER JOIN my_course_tags m2_ ON m1_.id = m2_.my_course_id
  INNER JOIN course_tag c0_ ON c0_.id = m2_.course_tag_id
WHERE
  m1_.main_category_id = ?
  AND m1_.sub_category_id = ?
  AND m1_.topic_id = ?
GROUP BY
  c0_.id

SELECT c0_.id AS id_0, COUNT(DISTINCT m1_.id) AS sclr_1 FROM my_course m1_ INNER JOIN my_course_tags m2_ ON m1_.id = m2_.my_course_id INNER JOIN course_tag c0_ ON c0_.id = m2_.course_tag_id WHERE m1_.main_category_id = 22 AND m1_.sub_category_id = 102 AND m1_.topic_id = 127 GROUP BY c0_.id;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.code AS code_2,
  c0_.active AS active_3,
  c0_.sort_order AS sort_order_4
FROM
  course_language c0_
WHERE
  c0_.active = ?
ORDER BY
  c0_.sort_order ASC,
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.code AS code_2, c0_.active AS active_3, c0_.sort_order AS sort_order_4 FROM course_language c0_ WHERE c0_.active = 1 ORDER BY c0_.sort_order ASC, c0_.name ASC;

SELECT
  AVG(c0_.rating) AS sclr_0
FROM
  company_review c0_
WHERE
  c0_.company_id = ?
  AND c0_.status = ?

SELECT AVG(c0_.rating) AS sclr_0 FROM company_review c0_ WHERE c0_.company_id = 15 AND c0_.status = 'verified';

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.description AS description_3,
  c0_.active AS active_4,
  c0_.sort_order AS sort_order_5
FROM
  course_type c0_
WHERE
  c0_.active = ?
ORDER BY
  c0_.sort_order ASC,
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.active AS active_4, c0_.sort_order AS sort_order_5 FROM course_type c0_ WHERE c0_.active = 1 ORDER BY c0_.sort_order ASC, c0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.slogan AS slogan_2,
  t0.short_description AS short_description_3,
  t0.long_description AS long_description_4,
  t0.website AS website_5,
  t0.facebook_link AS facebook_link_6,
  t0.instagram_link AS instagram_link_7,
  t0.linkedin_link AS linkedin_link_8,
  t0.vimeo_video_id AS vimeo_video_id_9,
  t0.vimeo_thumbnail_url AS vimeo_thumbnail_url_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.company_id AS company_id_13,
  t0.logo_image_id AS logo_image_id_14,
  t0.main_image_id AS main_image_id_15
FROM
  company_detail t0
WHERE
  t0.company_id = ?

SELECT t0.id AS id_1, t0.slogan AS slogan_2, t0.short_description AS short_description_3, t0.long_description AS long_description_4, t0.website AS website_5, t0.facebook_link AS facebook_link_6, t0.instagram_link AS instagram_link_7, t0.linkedin_link AS linkedin_link_8, t0.vimeo_video_id AS vimeo_video_id_9, t0.vimeo_thumbnail_url AS vimeo_thumbnail_url_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.company_id AS company_id_13, t0.logo_image_id AS logo_image_id_14, t0.main_image_id AS main_image_id_15 FROM company_detail t0 WHERE t0.company_id = 15;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.active AS active_3,
  c0_.sort_order AS sort_order_4,
  c0_.usage_count AS usage_count_5
FROM
  course_tag c0_
WHERE
  c0_.active = ?
ORDER BY
  c0_.usage_count DESC,
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.active AS active_3, c0_.sort_order AS sort_order_4, c0_.usage_count AS usage_count_5 FROM course_tag c0_ WHERE c0_.active = 1 ORDER BY c0_.usage_count DESC, c0_.name ASC;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.description AS description_3,
  c0_.level AS level_4,
  c0_.active AS active_5,
  c0_.sort_order AS sort_order_6
FROM
  course_niveau c0_
WHERE
  c0_.active = ?
ORDER BY
  c0_.level ASC,
  c0_.sort_order ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.level AS level_4, c0_.active AS active_5, c0_.sort_order AS sort_order_6 FROM course_niveau c0_ WHERE c0_.active = 1 ORDER BY c0_.level ASC, c0_.sort_order ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.level AS level_5,
  t0.active AS active_6,
  t0.sort_order AS sort_order_7
FROM
  course_niveau t0
  INNER JOIN my_course_niveau ON t0.id = my_course_niveau.course_niveau_id
WHERE
  my_course_niveau.my_course_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.level AS level_5, t0.active AS active_6, t0.sort_order AS sort_order_7 FROM course_niveau t0 INNER JOIN my_course_niveau ON t0.id = my_course_niveau.course_niveau_id WHERE my_course_niveau.my_course_id = 35;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.icon AS icon_5,
  t0.active AS active_6,
  t0.sort_order AS sort_order_7,
  t0.sub_category_id AS sub_category_id_8
FROM
  course_topic t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.icon AS icon_5, t0.active AS active_6, t0.sort_order AS sort_order_7, t0.sub_category_id AS sub_category_id_8 FROM course_topic t0 WHERE t0.slug = 'business-englisch' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.active AS active_4,
  t0.sort_order AS sort_order_5
FROM
  course_language t0
  INNER JOIN my_course_language ON t0.id = my_course_language.course_language_id
WHERE
  my_course_language.my_course_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.active AS active_4, t0.sort_order AS sort_order_5 FROM course_language t0 INNER JOIN my_course_language ON t0.id = my_course_language.course_language_id WHERE my_course_language.my_course_id = 35;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.description AS description_3,
  c0_.active AS active_4,
  c0_.sort_order AS sort_order_5
FROM
  course_targetgroup c0_
WHERE
  c0_.active = ?
ORDER BY
  c0_.sort_order ASC,
  c0_.name ASC