94.32 ms (54.79%)
|
1 |
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.is_active AS is_active_3, a0_.public_date AS public_date_4, a0_.deactivation_date AS deactivation_date_5, a0_.hide_date AS hide_date_6, a0_.redirect_to_url AS redirect_to_url_7, a0_.created_at AS created_at_8, a0_.updated_at AS updated_at_9, a0_.seo_keywords AS seo_keywords_10, a0_.seo_meta_title AS seo_meta_title_11, a0_.seo_meta_description AS seo_meta_description_12, a0_.seo_open_graph_title AS seo_open_graph_title_13, a0_.seo_open_graph_description AS seo_open_graph_description_14, a0_.seo_open_graph_image_url AS seo_open_graph_image_url_15, a0_.seo_is_no_index AS seo_is_no_index_16, a0_.description AS description_17, a0_.description AS description_18, a0_.lead AS lead_19, a0_.table_of_contents AS table_of_contents_20, a0_.content AS content_21, a0_.video_url AS video_url_22, a0_.description AS description_23, a0_.type AS type_24, a0_.image_id AS image_id_25, a0_.created_by_id AS created_by_id_26, a0_.updated_by_id AS updated_by_id_27, a0_.audio_id AS audio_id_28, a0_.file_id AS file_id_29 FROM article a0_ INNER JOIN article_categories a2_ ON a0_.id = a2_.article_id INNER JOIN article_category a1_ ON a1_.id = a2_.category_id WHERE (a0_.is_active = ? AND a1_.id IN (?) AND a0_.id <> ?) AND a0_.type IN ('audio', 'download', 'text', 'video') ORDER BY a0_.created_at DESC LIMIT 6
Parameters: [
1
b"\x01žÊîË~›\x1DtšœÏ~"
b"\x01žÊ‘;Óp¶¯\x00‘Rg\x1F^="
]
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.is_active AS is_active_3, a0_.public_date AS public_date_4, a0_.deactivation_date AS deactivation_date_5, a0_.hide_date AS hide_date_6, a0_.redirect_to_url AS redirect_to_url_7, a0_.created_at AS created_at_8, a0_.updated_at AS updated_at_9, a0_.seo_keywords AS seo_keywords_10, a0_.seo_meta_title AS seo_meta_title_11, a0_.seo_meta_description AS seo_meta_description_12, a0_.seo_open_graph_title AS seo_open_graph_title_13, a0_.seo_open_graph_description AS seo_open_graph_description_14, a0_.seo_open_graph_image_url AS seo_open_graph_image_url_15, a0_.seo_is_no_index AS seo_is_no_index_16, a0_.description AS description_17, a0_.description AS description_18, a0_.lead AS lead_19, a0_.table_of_contents AS table_of_contents_20, a0_.content AS content_21, a0_.video_url AS video_url_22, a0_.description AS description_23, a0_.type AS type_24, a0_.image_id AS image_id_25, a0_.created_by_id AS created_by_id_26, a0_.updated_by_id AS updated_by_id_27, a0_.audio_id AS audio_id_28, a0_.file_id AS file_id_29 FROM article a0_ INNER JOIN article_categories a2_ ON a0_.id = a2_.article_id INNER JOIN article_category a1_ ON a1_.id = a2_.category_id WHERE (a0_.is_active = 1 AND a1_.id IN (0x019ECA8FEECB7E9B9D1D749A9C90CF7E) AND a0_.id <> 0x019ECA913BD370B6AF009152671F5E3D) AND a0_.type IN ('audio', 'download', 'text', 'video') ORDER BY a0_.created_at DESC LIMIT 6;
|
55.31 ms (32.13%)
|
1 |
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.is_active AS is_active_3, a0_.public_date AS public_date_4, a0_.deactivation_date AS deactivation_date_5, a0_.hide_date AS hide_date_6, a0_.redirect_to_url AS redirect_to_url_7, a0_.created_at AS created_at_8, a0_.updated_at AS updated_at_9, a0_.seo_keywords AS seo_keywords_10, a0_.seo_meta_title AS seo_meta_title_11, a0_.seo_meta_description AS seo_meta_description_12, a0_.seo_open_graph_title AS seo_open_graph_title_13, a0_.seo_open_graph_description AS seo_open_graph_description_14, a0_.seo_open_graph_image_url AS seo_open_graph_image_url_15, a0_.seo_is_no_index AS seo_is_no_index_16, a0_.description AS description_17, a0_.description AS description_18, a0_.lead AS lead_19, a0_.table_of_contents AS table_of_contents_20, a0_.content AS content_21, a0_.video_url AS video_url_22, a0_.description AS description_23, a0_.type AS type_24, a0_.image_id AS image_id_25, a0_.created_by_id AS created_by_id_26, a0_.updated_by_id AS updated_by_id_27, a0_.audio_id AS audio_id_28, a0_.file_id AS file_id_29 FROM article a0_ WHERE (a0_.slug = ?) AND a0_.type IN ('audio', 'download', 'text', 'video') LIMIT 1
Parameters: [
"jpk-cit-w-praktyce-jak-uniknac-bledow-w-raportowaniu"
]
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.is_active AS is_active_3, a0_.public_date AS public_date_4, a0_.deactivation_date AS deactivation_date_5, a0_.hide_date AS hide_date_6, a0_.redirect_to_url AS redirect_to_url_7, a0_.created_at AS created_at_8, a0_.updated_at AS updated_at_9, a0_.seo_keywords AS seo_keywords_10, a0_.seo_meta_title AS seo_meta_title_11, a0_.seo_meta_description AS seo_meta_description_12, a0_.seo_open_graph_title AS seo_open_graph_title_13, a0_.seo_open_graph_description AS seo_open_graph_description_14, a0_.seo_open_graph_image_url AS seo_open_graph_image_url_15, a0_.seo_is_no_index AS seo_is_no_index_16, a0_.description AS description_17, a0_.description AS description_18, a0_.lead AS lead_19, a0_.table_of_contents AS table_of_contents_20, a0_.content AS content_21, a0_.video_url AS video_url_22, a0_.description AS description_23, a0_.type AS type_24, a0_.image_id AS image_id_25, a0_.created_by_id AS created_by_id_26, a0_.updated_by_id AS updated_by_id_27, a0_.audio_id AS audio_id_28, a0_.file_id AS file_id_29 FROM article a0_ WHERE (a0_.slug = 'jpk-cit-w-praktyce-jak-uniknac-bledow-w-raportowaniu') AND a0_.type IN ('audio', 'download', 'text', 'video') LIMIT 1;
|
11.07 ms (6.43%)
|
14 |
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š^/°-y‹K•/7¼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 article_category t0 WHERE ((t0.is_active = 1) AND t0.parent_id = 0x019A5E2FB02D798B8E4B952F3781BC46);
|
3.83 ms (2.23%)
|
3 |
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 INNER JOIN article_categories ON t0.id = article_categories.category_id WHERE article_categories.article_id = ?
Parameters: [
b"\x01žÊ‘;Óp¶¯\x00‘Rg\x1F^="
]
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 INNER JOIN article_categories ON t0.id = article_categories.category_id WHERE article_categories.article_id = 0x019ECA913BD370B6AF009152671F5E3D;
|
2.06 ms (1.20%)
|
2 |
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;
|
1.60 ms (0.93%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.portal_settings_id AS portal_settings_id_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9 FROM footer_link t0 WHERE t0.portal_settings_id = ? ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.portal_settings_id AS portal_settings_id_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9 FROM footer_link t0 WHERE t0.portal_settings_id = 1 ORDER BY t0.position ASC;
|
1.42 ms (0.82%)
|
1 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c1_.id AS id_3, c1_.name AS name_4, c1_.slug AS slug_5 FROM course_category c0_ LEFT JOIN course_category c1_ ON c0_.parent_id = c1_.id WHERE c0_.is_active = 1 ORDER BY c0_.name ASC
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c1_.id AS id_3, c1_.name AS name_4, c1_.slug AS slug_5 FROM course_category c0_ LEFT JOIN course_category c1_ ON c0_.parent_id = c1_.id WHERE c0_.is_active = 1 ORDER BY c0_.name ASC;
|
1.07 ms (0.62%)
|
1 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.footer_text AS footer_text_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4, p0_.seo_keywords AS seo_keywords_5, p0_.seo_meta_title AS seo_meta_title_6, p0_.seo_meta_description AS seo_meta_description_7, p0_.seo_open_graph_title AS seo_open_graph_title_8, p0_.seo_open_graph_description AS seo_open_graph_description_9, p0_.seo_open_graph_image_url AS seo_open_graph_image_url_10, p0_.seo_is_no_index AS seo_is_no_index_11, p0_.social_facebook AS social_facebook_12, p0_.social_twitter AS social_twitter_13, p0_.social_instagram AS social_instagram_14, p0_.social_linked_in AS social_linked_in_15, p0_.social_youtube AS social_youtube_16, p0_.login_settings_google_id AS login_settings_google_id_17, p0_.login_settings_google_secret AS login_settings_google_secret_18, p0_.created_by_id AS created_by_id_19, p0_.updated_by_id AS updated_by_id_20 FROM portal_settings p0_ LIMIT 1
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.footer_text AS footer_text_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4, p0_.seo_keywords AS seo_keywords_5, p0_.seo_meta_title AS seo_meta_title_6, p0_.seo_meta_description AS seo_meta_description_7, p0_.seo_open_graph_title AS seo_open_graph_title_8, p0_.seo_open_graph_description AS seo_open_graph_description_9, p0_.seo_open_graph_image_url AS seo_open_graph_image_url_10, p0_.seo_is_no_index AS seo_is_no_index_11, p0_.social_facebook AS social_facebook_12, p0_.social_twitter AS social_twitter_13, p0_.social_instagram AS social_instagram_14, p0_.social_linked_in AS social_linked_in_15, p0_.social_youtube AS social_youtube_16, p0_.login_settings_google_id AS login_settings_google_id_17, p0_.login_settings_google_secret AS login_settings_google_secret_18, p0_.created_by_id AS created_by_id_19, p0_.updated_by_id AS updated_by_id_20 FROM portal_settings p0_ LIMIT 1;
|
0.74 ms (0.43%)
|
1 |
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 article_image t0 WHERE t0.id = ?
Parameters: [
b"\x01žÊ‘Ï\x0Fq¤¤Ü»w<Â\x03ï"
]
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 article_image t0 WHERE t0.id = 0x019ECA91CF0F71A4A4DCBB773CC203EF;
|
0.74 ms (0.43%)
|
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.profession AS profession_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.avatar_id AS avatar_id_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11 FROM author t0 INNER JOIN article_author ON t0.id = article_author.author_id WHERE article_author.article_id = ?
Parameters: [
b"\x01žÊ‘;Óp¶¯\x00‘Rg\x1F^="
]
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.profession AS profession_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.avatar_id AS avatar_id_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11 FROM author t0 INNER JOIN article_author ON t0.id = article_author.author_id WHERE article_author.article_id = 0x019ECA913BD370B6AF009152671F5E3D;
|