259.86 ms (44.41%)
|
196 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.gos_id AS gos_id_4, t0.is_visible AS is_visible_5, t0.is_optional AS is_optional_6, t0.minimum_score AS minimum_score_7, t0.good_answer_points AS good_answer_points_8, t0.wrong_answer_points AS wrong_answer_points_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.created_by_id AS created_by_id_12, t0.updated_by_id AS updated_by_id_13, t0.course_id AS course_id_14, t0.type FROM test t0 WHERE t0.course_id = ? AND t0.type IN ('course')
Parameters: [
b"\x01*v²|u\x12›n\x7FX\x0FÝ\x7F("
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.gos_id AS gos_id_4, t0.is_visible AS is_visible_5, t0.is_optional AS is_optional_6, t0.minimum_score AS minimum_score_7, t0.good_answer_points AS good_answer_points_8, t0.wrong_answer_points AS wrong_answer_points_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.created_by_id AS created_by_id_12, t0.updated_by_id AS updated_by_id_13, t0.course_id AS course_id_14, t0.type FROM test t0 WHERE t0.course_id = 0x019D2A76B27C75129B6E7F580FDD7F28 AND t0.type IN ('course');
|
142.07 ms (24.28%)
|
111 |
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM course_category t0 WHERE ((t0.is_active = ?) AND t0.parent_id = ?)
Parameters: [
1
b"\x01š]cÌ%~޹þ\x1E\e\x1D/áf"
]
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM course_category t0 WHERE ((t0.is_active = 1) AND t0.parent_id = 0x019A5D63CC257E8DB9FE1E1B1D2FE166);
|
101.00 ms (17.26%)
|
52 |
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.is_continuous AS is_continuous_3, t0.is_medical_product AS is_medical_product_4, t0.position AS position_5, t0.name AS name_6, t0.slug AS slug_7, t0.short_body AS short_body_8, t0.difficulty AS difficulty_9, t0.start_date AS start_date_10, t0.hide_date AS hide_date_11, t0.deactivation_date AS deactivation_date_12, t0.duration AS duration_13, t0.action_number AS action_number_14, t0.from_source AS from_source_15, t0.products_for_cos AS products_for_cos_16, t0.redirect_to_url AS redirect_to_url_17, t0.gos_id AS gos_id_18, t0.certificate_gos_id AS certificate_gos_id_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.seo_keywords AS seo_keywords_22, t0.seo_meta_title AS seo_meta_title_23, t0.seo_meta_description AS seo_meta_description_24, t0.seo_is_no_index AS seo_is_no_index_25, t0.category_id AS category_id_26, t0.image_id AS image_id_27, t0.created_by_id AS created_by_id_28, t0.updated_by_id AS updated_by_id_29, t0.type, t0.beacon_name AS beacon_name_30 FROM course t0 WHERE (t0.is_active = ? AND t0.category_id = ?) AND t0.type IN ('academy', 'future_degree', 'webinar', 'no_front') ORDER BY t0.position ASC
Parameters: [
1
b"\x01š]cÌ%~޹þ\x1E\e\x1D/áf"
]
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.is_continuous AS is_continuous_3, t0.is_medical_product AS is_medical_product_4, t0.position AS position_5, t0.name AS name_6, t0.slug AS slug_7, t0.short_body AS short_body_8, t0.difficulty AS difficulty_9, t0.start_date AS start_date_10, t0.hide_date AS hide_date_11, t0.deactivation_date AS deactivation_date_12, t0.duration AS duration_13, t0.action_number AS action_number_14, t0.from_source AS from_source_15, t0.products_for_cos AS products_for_cos_16, t0.redirect_to_url AS redirect_to_url_17, t0.gos_id AS gos_id_18, t0.certificate_gos_id AS certificate_gos_id_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.seo_keywords AS seo_keywords_22, t0.seo_meta_title AS seo_meta_title_23, t0.seo_meta_description AS seo_meta_description_24, t0.seo_is_no_index AS seo_is_no_index_25, t0.category_id AS category_id_26, t0.image_id AS image_id_27, t0.created_by_id AS created_by_id_28, t0.updated_by_id AS updated_by_id_29, t0.type, t0.beacon_name AS beacon_name_30 FROM course t0 WHERE (t0.is_active = 1 AND t0.category_id = 0x019A5D63CC257E8DB9FE1E1B1D2FE166) AND t0.type IN ('academy', 'future_degree', 'webinar', 'no_front') ORDER BY t0.position ASC;
|
38.91 ms (6.65%)
|
60 |
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.context AS context_3, t0.coupon_code AS coupon_code_4, t0.price_net AS price_net_5, t0.price_gross AS price_gross_6, t0.price_net_discounted AS price_net_discounted_7, t0.price_gross_discounted AS price_gross_discounted_8, t0.valid_until AS valid_until_9, t0.main_promo_text AS main_promo_text_10, t0.sub_promo_text AS sub_promo_text_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.course_id AS course_id_14, t0.created_by_id AS created_by_id_15, t0.updated_by_id AS updated_by_id_16, t0.type FROM course_price t0 WHERE (t0.is_active = ? AND t0.course_id = ?) AND t0.type IN ('variant', 'pack')
Parameters: [
1
b"\x01*v²|u\x12›n\x7FX\x0FÝ\x7F("
]
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.context AS context_3, t0.coupon_code AS coupon_code_4, t0.price_net AS price_net_5, t0.price_gross AS price_gross_6, t0.price_net_discounted AS price_net_discounted_7, t0.price_gross_discounted AS price_gross_discounted_8, t0.valid_until AS valid_until_9, t0.main_promo_text AS main_promo_text_10, t0.sub_promo_text AS sub_promo_text_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.course_id AS course_id_14, t0.created_by_id AS created_by_id_15, t0.updated_by_id AS updated_by_id_16, t0.type FROM course_price t0 WHERE (t0.is_active = 1 AND t0.course_id = 0x019D2A76B27C75129B6E7F580FDD7F28) AND t0.type IN ('variant', 'pack');
|
9.51 ms (1.62%)
|
15 |
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM course_category t0 WHERE t0.parent_id = ?
Parameters: [
b"\x01š]cÌ%~޹þ\x1E\e\x1D/áf"
]
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM course_category t0 WHERE t0.parent_id = 0x019A5D63CC257E8DB9FE1E1B1D2FE166;
|
7.75 ms (1.32%)
|
3 |
SELECT c0_.id AS id_0, c0_.is_active AS is_active_1, c0_.name AS name_2, c0_.slug AS slug_3, c0_.icon AS icon_4, c0_.color AS color_5, c0_.short_body AS short_body_6, c0_.body AS body_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.image_id AS image_id_10, c0_.desktop_banner_id AS desktop_banner_id_11, c0_.mobile_banner_id AS mobile_banner_id_12, c0_.created_by_id AS created_by_id_13, c0_.updated_by_id AS updated_by_id_14, c0_.parent_id AS parent_id_15 FROM course_category c0_ WHERE c0_.parent_id IS NULL AND c0_.is_active = 1
SELECT c0_.id AS id_0, c0_.is_active AS is_active_1, c0_.name AS name_2, c0_.slug AS slug_3, c0_.icon AS icon_4, c0_.color AS color_5, c0_.short_body AS short_body_6, c0_.body AS body_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.image_id AS image_id_10, c0_.desktop_banner_id AS desktop_banner_id_11, c0_.mobile_banner_id AS mobile_banner_id_12, c0_.created_by_id AS created_by_id_13, c0_.updated_by_id AS updated_by_id_14, c0_.parent_id AS parent_id_15 FROM course_category c0_ WHERE c0_.parent_id IS NULL AND c0_.is_active = 1;
|
6.31 ms (1.08%)
|
12 |
SELECT t0.name AS name_1, t0.original_name AS original_name_2, t0.size AS size_3, t0.mime_type AS mime_type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dimensions AS dimensions_7, t0.id AS id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10 FROM course_image t0 WHERE t0.id = ?
Parameters: [
b"\x01*…6K|â–G䞸\x1DÐA"
]
SELECT t0.name AS name_1, t0.original_name AS original_name_2, t0.size AS size_3, t0.mime_type AS mime_type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dimensions AS dimensions_7, t0.id AS id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10 FROM course_image t0 WHERE t0.id = 0x019D2A85364B7CE29647E49EB81DD041;
|
4.74 ms (0.81%)
|
1 |
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM course_category t0 WHERE t0.slug = ? LIMIT 1
Parameters: [
"naturoterapia"
]
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM course_category t0 WHERE t0.slug = 'naturoterapia' LIMIT 1;
|
4.13 ms (0.71%)
|
1 |
SELECT DISTINCT c0_.id AS id_0, c0_.created_at AS created_at_1 FROM course c0_ INNER JOIN course_category c1_ ON c0_.category_id = c1_.id LEFT JOIN course_category c2_ ON c1_.parent_id = c2_.id WHERE ((c1_.id = ? OR c2_.id = ?) AND c1_.is_active = ? AND c0_.type NOT IN ('no_front') AND (c0_.is_active = ? OR (c0_.is_active = ? AND c0_.hide_date > ?))) AND c0_.type IN ('academy', 'future_degree', 'webinar', 'no_front') ORDER BY c0_.created_at DESC LIMIT 12
Parameters: [
b"\x01œH\x0Es\t}»œÇ¬è\x15Ù©Á"
b"\x01œH\x0Es\t}»œÇ¬è\x15Ù©Á"
1
1
0
"2026-03-30 18:52:03"
]
SELECT DISTINCT c0_.id AS id_0, c0_.created_at AS created_at_1 FROM course c0_ INNER JOIN course_category c1_ ON c0_.category_id = c1_.id LEFT JOIN course_category c2_ ON c1_.parent_id = c2_.id WHERE ((c1_.id = 0x019C480E73097DBB9CC7ACE815D9A9C1 OR c2_.id = 0x019C480E73097DBB9CC7ACE815D9A9C1) AND c1_.is_active = 1 AND c0_.type NOT IN ('no_front') AND (c0_.is_active = 1 OR (c0_.is_active = 0 AND c0_.hide_date > '2026-03-30 18:52:03'))) AND c0_.type IN ('academy', 'future_degree', 'webinar', 'no_front') ORDER BY c0_.created_at DESC LIMIT 12;
|
3.56 ms (0.61%)
|
1 |
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM article_category t0 WHERE ((t0.is_active = ?) AND t0.parent_id = ?)
Parameters: [
1
b"\x01œûÁ"\vuä¶\x18íyw\x0E`"
]
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM article_category t0 WHERE ((t0.is_active = 1) AND t0.parent_id = 0x019CFBC1220B75E4B61881ED79770E60);
|
3.27 ms (0.56%)
|
1 |
SELECT count(DISTINCT c0_.id) AS sclr_0 FROM course c0_ INNER JOIN course_category c1_ ON c0_.category_id = c1_.id LEFT JOIN course_category c2_ ON c1_.parent_id = c2_.id WHERE ((c1_.id = ? OR c2_.id = ?) AND c1_.is_active = ? AND c0_.type NOT IN ('no_front') AND (c0_.is_active = ? OR (c0_.is_active = ? AND c0_.hide_date > ?))) AND c0_.type IN ('academy', 'future_degree', 'webinar', 'no_front')
Parameters: [
b"\x01œH\x0Es\t}»œÇ¬è\x15Ù©Á"
b"\x01œH\x0Es\t}»œÇ¬è\x15Ù©Á"
1
1
0
"2026-03-30 18:52:03"
]
SELECT count(DISTINCT c0_.id) AS sclr_0 FROM course c0_ INNER JOIN course_category c1_ ON c0_.category_id = c1_.id LEFT JOIN course_category c2_ ON c1_.parent_id = c2_.id WHERE ((c1_.id = 0x019C480E73097DBB9CC7ACE815D9A9C1 OR c2_.id = 0x019C480E73097DBB9CC7ACE815D9A9C1) AND c1_.is_active = 1 AND c0_.type NOT IN ('no_front') AND (c0_.is_active = 1 OR (c0_.is_active = 0 AND c0_.hide_date > '2026-03-30 18:52:03'))) AND c0_.type IN ('academy', 'future_degree', 'webinar', 'no_front');
|
2.21 ms (0.38%)
|
1 |
SELECT c0_.id AS id_0, c0_.is_active AS is_active_1, c0_.is_continuous AS is_continuous_2, c0_.is_medical_product AS is_medical_product_3, c0_.position AS position_4, c0_.name AS name_5, c0_.slug AS slug_6, c0_.short_body AS short_body_7, c0_.difficulty AS difficulty_8, c0_.start_date AS start_date_9, c0_.hide_date AS hide_date_10, c0_.deactivation_date AS deactivation_date_11, c0_.duration AS duration_12, c0_.action_number AS action_number_13, c0_.from_source AS from_source_14, c0_.products_for_cos AS products_for_cos_15, c0_.redirect_to_url AS redirect_to_url_16, c0_.gos_id AS gos_id_17, c0_.certificate_gos_id AS certificate_gos_id_18, c0_.created_at AS created_at_19, c0_.updated_at AS updated_at_20, c0_.seo_keywords AS seo_keywords_21, c0_.seo_meta_title AS seo_meta_title_22, c0_.seo_meta_description AS seo_meta_description_23, c0_.seo_is_no_index AS seo_is_no_index_24, c0_.beacon_name AS beacon_name_25, c0_.type AS type_26, c0_.category_id AS category_id_27, c0_.image_id AS image_id_28, c0_.created_by_id AS created_by_id_29, c0_.updated_by_id AS updated_by_id_30 FROM course c0_ INNER JOIN course_category c1_ ON c0_.category_id = c1_.id LEFT JOIN course_category c2_ ON c1_.parent_id = c2_.id WHERE ((c1_.id = ? OR c2_.id = ?) AND c1_.is_active = ? AND c0_.type NOT IN ('no_front') AND (c0_.is_active = ? OR (c0_.is_active = ? AND c0_.hide_date > ?)) AND c0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND c0_.type IN ('academy', 'future_degree', 'webinar', 'no_front') ORDER BY c0_.created_at DESC
Parameters: [
b"\x01œH\x0Es\t}»œÇ¬è\x15Ù©Á"
b"\x01œH\x0Es\t}»œÇ¬è\x15Ù©Á"
1
1
0
"2026-03-30 18:52:03"
b"\x01*v²|u\x12›n\x7FX\x0FÝ\x7F("
b"\x01œÿÎP!v¹°sž\x1AòóA‘"
b"""
\x01\n
øïÁ~\x05·?,Êç\x10“
"""
b"\x01œæuÅÎ{r”±”6˜Ê0\x1C"
b"\x01œ÷\x0Eï=vzœÔØúNõnR"
b"\x01œæAq"t˜»ê¢p"@¦}"
b"\x01œÜ\x11Ê+vDœ…âš;L5"
b"\x01œ×ú¾\x0Ez\x17¾9%\x08nÂ"
b"\x01œ\x12!3zHȦ*-!›"
b"\x01œuhä?w\x18¬è'\x10ÒJ\x03Ó"
b"\x01œuÖÓ^}¯œWÜ?ñÔX\n"
b"\x01œ‰w\x03îs˜„íH)é\x0F:/"
]
SELECT
c0_.id AS id_0,
c0_.is_active AS is_active_1,
c0_.is_continuous AS is_continuous_2,
c0_.is_medical_product AS is_medical_product_3,
c0_.position AS position_4,
c0_.name AS name_5,
c0_.slug AS slug_6,
c0_.short_body AS short_body_7,
c0_.difficulty AS difficulty_8,
c0_.start_date AS start_date_9,
c0_.hide_date AS hide_date_10,
c0_.deactivation_date AS deactivation_date_11,
c0_.duration AS duration_12,
c0_.action_number AS action_number_13,
c0_.from_source AS from_source_14,
c0_.products_for_cos AS products_for_cos_15,
c0_.redirect_to_url AS redirect_to_url_16,
c0_.gos_id AS gos_id_17,
c0_.certificate_gos_id AS certificate_gos_id_18,
c0_.created_at AS created_at_19,
c0_.updated_at AS updated_at_20,
c0_.seo_keywords AS seo_keywords_21,
c0_.seo_meta_title AS seo_meta_title_22,
c0_.seo_meta_description AS seo_meta_description_23,
c0_.seo_is_no_index AS seo_is_no_index_24,
c0_.beacon_name AS beacon_name_25,
c0_.type AS type_26,
c0_.category_id AS category_id_27,
c0_.image_id AS image_id_28,
c0_.created_by_id AS created_by_id_29,
c0_.updated_by_id AS updated_by_id_30
FROM
course c0_
INNER JOIN course_category c1_ ON c0_.category_id = c1_.id
LEFT JOIN course_category c2_ ON c1_.parent_id = c2_.id
WHERE
(
(
c1_.id = ?
OR c2_.id = ?
)
AND c1_.is_active = ?
AND c0_.type NOT IN ('no_front')
AND (
c0_.is_active = ?
OR (
c0_.is_active = ?
AND c0_.hide_date > ?
)
)
AND c0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
)
AND c0_.type IN (
'academy', 'future_degree', 'webinar',
'no_front'
)
ORDER BY
c0_.created_at DESC
SELECT c0_.id AS id_0, c0_.is_active AS is_active_1, c0_.is_continuous AS is_continuous_2, c0_.is_medical_product AS is_medical_product_3, c0_.position AS position_4, c0_.name AS name_5, c0_.slug AS slug_6, c0_.short_body AS short_body_7, c0_.difficulty AS difficulty_8, c0_.start_date AS start_date_9, c0_.hide_date AS hide_date_10, c0_.deactivation_date AS deactivation_date_11, c0_.duration AS duration_12, c0_.action_number AS action_number_13, c0_.from_source AS from_source_14, c0_.products_for_cos AS products_for_cos_15, c0_.redirect_to_url AS redirect_to_url_16, c0_.gos_id AS gos_id_17, c0_.certificate_gos_id AS certificate_gos_id_18, c0_.created_at AS created_at_19, c0_.updated_at AS updated_at_20, c0_.seo_keywords AS seo_keywords_21, c0_.seo_meta_title AS seo_meta_title_22, c0_.seo_meta_description AS seo_meta_description_23, c0_.seo_is_no_index AS seo_is_no_index_24, c0_.beacon_name AS beacon_name_25, c0_.type AS type_26, c0_.category_id AS category_id_27, c0_.image_id AS image_id_28, c0_.created_by_id AS created_by_id_29, c0_.updated_by_id AS updated_by_id_30 FROM course c0_ INNER JOIN course_category c1_ ON c0_.category_id = c1_.id LEFT JOIN course_category c2_ ON c1_.parent_id = c2_.id WHERE ((c1_.id = 0x019C480E73097DBB9CC7ACE815D9A9C1 OR c2_.id = 0x019C480E73097DBB9CC7ACE815D9A9C1) AND c1_.is_active = 1 AND c0_.type NOT IN ('no_front') AND (c0_.is_active = 1 OR (c0_.is_active = 0 AND c0_.hide_date > '2026-03-30 18:52:03')) AND c0_.id IN (0x019D2A76B27C75129B6E7F580FDD7F28, 0x019CFFCE502176B9B0739E1AF2F34191, 0x019D0AF8EFC17E05B73FAD2CCAE71093, 0x019CE675C5CE7B7294B1943698CA301C, 0x019CF70EEF3D767A9CD4D8FA4EF56E52, 0x019CE64171227498BBEAA2702240A67D, 0x019CDC11CA2B76449C8581E29A3B4C35, 0x019CD7FABE0E7A178EBE3925086E8FC2, 0x019C8F1221337A4881C8A62A2D90219B, 0x019C7568E43F7718ACE82710D24A03D3, 0x019C75D6D35E7DAF9C57DC3FF1D4580A, 0x019C897703EE739884ED4829E90F3A2F)) AND c0_.type IN ('academy', 'future_degree', 'webinar', 'no_front') ORDER BY c0_.created_at DESC;
|
0.98 ms (0.17%)
|
1 |
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM course_category t0 WHERE t0.slug IS NULL LIMIT 1
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.icon AS icon_5, t0.color AS color_6, t0.short_body AS short_body_7, t0.body AS body_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.desktop_banner_id AS desktop_banner_id_12, t0.mobile_banner_id AS mobile_banner_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.parent_id AS parent_id_16 FROM course_category t0 WHERE t0.slug IS NULL LIMIT 1;
|
0.81 ms (0.14%)
|
1 |
SELECT a0_.id AS id_0, a0_.is_active AS is_active_1, a0_.name AS name_2, a0_.slug AS slug_3, a0_.icon AS icon_4, a0_.color AS color_5, a0_.short_body AS short_body_6, a0_.body AS body_7, a0_.created_at AS created_at_8, a0_.updated_at AS updated_at_9, a0_.image_id AS image_id_10, a0_.desktop_banner_id AS desktop_banner_id_11, a0_.mobile_banner_id AS mobile_banner_id_12, a0_.created_by_id AS created_by_id_13, a0_.updated_by_id AS updated_by_id_14, a0_.parent_id AS parent_id_15 FROM article_category a0_ WHERE a0_.parent_id IS NULL AND a0_.is_active = 1
SELECT a0_.id AS id_0, a0_.is_active AS is_active_1, a0_.name AS name_2, a0_.slug AS slug_3, a0_.icon AS icon_4, a0_.color AS color_5, a0_.short_body AS short_body_6, a0_.body AS body_7, a0_.created_at AS created_at_8, a0_.updated_at AS updated_at_9, a0_.image_id AS image_id_10, a0_.desktop_banner_id AS desktop_banner_id_11, a0_.mobile_banner_id AS mobile_banner_id_12, a0_.created_by_id AS created_by_id_13, a0_.updated_by_id AS updated_by_id_14, a0_.parent_id AS parent_id_15 FROM article_category a0_ WHERE a0_.parent_id IS NULL AND a0_.is_active = 1;
|