109.75 ms (37.68%)
|
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œû\x7Fs\x06{›’ñâ:$¤ C"
]
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 = 0x019CFB7F73067B9B92F1E23A24A4A043 AND t0.type IN ('course');
|
66.36 ms (22.78%)
|
112 |
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);
|
46.85 ms (16.09%)
|
53 |
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;
|
42.06 ms (14.44%)
|
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œû\x7Fs\x06{›’ñâ:$¤ C"
]
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 = 0x019CFB7F73067B9B92F1E23A24A4A043) AND t0.type IN ('variant', 'pack');
|
9.95 ms (3.42%)
|
16 |
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.44 ms (2.55%)
|
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œûŽä„sLJ¹Óè\x10\x17¹l"
]
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 = 0x019CFB8EE48473C787B9D3E81017B96C;
|
2.64 ms (0.90%)
|
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;
|
1.15 ms (0.39%)
|
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: [
"terapia"
]
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 = 'terapia' LIMIT 1;
|
1.01 ms (0.35%)
|
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œ÷|\n
\x05xí³\x03]v‹\x7F.Ú
"""
b"""
\x01œ÷|\n
\x05xí³\x03]v‹\x7F.Ú
"""
1
1
0
"2026-03-30 18:54:46"
b"\x01œû\x7Fs\x06{›’ñâ:$¤ C"
b"\x01\x01¢\x15]w¢«8ø3O§<"
b"\x01œ¾IÒÄt{ŽE\t\e—zMq"
b"\x01œòÏGr^™\x08=|z\x12=k"
b"\x01œÃðuòƒ\x0Eó\r\x05,?`"
b"\x01œ½ö+Z~Xµ\vC^ækc\x15"
b"\x01œúœúÈv’ ˆRÐ&J\x10"
b"\x01œõYðt웄©k\x13Êfí"
b"\x01œòl\x1E~ ¶¹\x01¸Ï/©"
b"\x01œúmR÷ym‡ÂP\x14$üì\x0E"
b"\x01œ½m'\x04y迟Æë«]o"
b"\x01œ½]´O|R¦Ï\x13“37u\x06"
]
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 = 0x019CF77C0A0578EDB3035D768B7F2EDA OR c2_.id = 0x019CF77C0A0578EDB3035D768B7F2EDA) 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:54:46')) AND c0_.id IN (0x019CFB7F73067B9B92F1E23A24A4A043, 0x019D01A2155D7790A2AB38F8334FA73C, 0x019CBE49D2C4747B8E45091B977A4D71, 0x019CF2CFAD47725E99083D7C7A123D6B, 0x019CAD9DC3F075F2830EF30D052C3F60, 0x019CBDF62B5A7E58B50B435EE66B6315, 0x019CFA9CFAC87692A08F8852D0264A10, 0x019CF55990F074EC9B84A96B13CA66ED, 0x019CF26C1E8F7E20B6B901B8CF2FA99D, 0x019CFA6D52F7796D87C2501424FCEC0E, 0x019CBD6D270479E8BF9FC6EBABAD5D6F, 0x019CBD5DB44F7C52A6CF139333377506)) AND c0_.type IN ('academy', 'future_degree', 'webinar', 'no_front') ORDER BY c0_.created_at DESC;
|
0.99 ms (0.34%)
|
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œ÷|\n
\x05xí³\x03]v‹\x7F.Ú
"""
b"""
\x01œ÷|\n
\x05xí³\x03]v‹\x7F.Ú
"""
1
1
0
"2026-03-30 18:54:46"
]
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 = 0x019CF77C0A0578EDB3035D768B7F2EDA OR c2_.id = 0x019CF77C0A0578EDB3035D768B7F2EDA) 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:54:46'))) AND c0_.type IN ('academy', 'future_degree', 'webinar', 'no_front');
|
0.99 ms (0.34%)
|
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œ÷|\n
\x05xí³\x03]v‹\x7F.Ú
"""
b"""
\x01œ÷|\n
\x05xí³\x03]v‹\x7F.Ú
"""
1
1
0
"2026-03-30 18:54:46"
]
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 = 0x019CF77C0A0578EDB3035D768B7F2EDA OR c2_.id = 0x019CF77C0A0578EDB3035D768B7F2EDA) 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:54:46'))) AND c0_.type IN ('academy', 'future_degree', 'webinar', 'no_front') ORDER BY c0_.created_at DESC LIMIT 12;
|
0.78 ms (0.27%)
|
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;
|
0.75 ms (0.26%)
|
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);
|
0.55 ms (0.19%)
|
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;
|