Symfony Profiler

Query Metrics

59 Database Queries

35 Different statements

59.53 ms Query time

1 Invalid entities

Grouped Statements

Time▼	Count	Info
8.28 ms (13.91%)	16	SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.description AS description_4, t0.meta_description AS meta_description_5, t0.work_keys AS work_keys_6, t0.slug AS slug_7, t0.entity_id AS entity_id_8, t9.position AS position_10, t9.id AS id_11, t9.date_add AS date_add_12, t9.date_upd AS date_upd_13, t9.deleted AS deleted_14, t9.locked AS locked_15, t9.is_draft AS is_draft_16, t9.can_be_deleted AS can_be_deleted_17, t9.owner_organization_id AS owner_organization_id_18, t9.section_id AS section_id_19, t9.thumbnail_id AS thumbnail_id_20, t9.author_id AS author_id_21 FROM app_blog_page_section_item_i18n t0 INNER JOIN app_blog_page_section_item t9 ON t0.entity_id = t9.id WHERE t0.entity_id = ? Parameters: [`236`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.description AS description_4, t0.meta_description AS meta_description_5, t0.work_keys AS work_keys_6, t0.slug AS slug_7, t0.entity_id AS entity_id_8, t9.position AS position_10, t9.id AS id_11, t9.date_add AS date_add_12, t9.date_upd AS date_upd_13, t9.deleted AS deleted_14, t9.locked AS locked_15, t9.is_draft AS is_draft_16, t9.can_be_deleted AS can_be_deleted_17, t9.owner_organization_id AS owner_organization_id_18, t9.section_id AS section_id_19, t9.thumbnail_id AS thumbnail_id_20, t9.author_id AS author_id_21 FROM app_blog_page_section_item_i18n t0 INNER JOIN app_blog_page_section_item t9 ON t0.entity_id = t9.id WHERE t0.entity_id = ? SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.description AS description_4, t0.meta_description AS meta_description_5, t0.work_keys AS work_keys_6, t0.slug AS slug_7, t0.entity_id AS entity_id_8, t9.position AS position_10, t9.id AS id_11, t9.date_add AS date_add_12, t9.date_upd AS date_upd_13, t9.deleted AS deleted_14, t9.locked AS locked_15, t9.is_draft AS is_draft_16, t9.can_be_deleted AS can_be_deleted_17, t9.owner_organization_id AS owner_organization_id_18, t9.section_id AS section_id_19, t9.thumbnail_id AS thumbnail_id_20, t9.author_id AS author_id_21 FROM app_blog_page_section_item_i18n t0 INNER JOIN app_blog_page_section_item t9 ON t0.entity_id = t9.id WHERE t0.entity_id = 236;
6.43 ms (10.80%)	8	SELECT t0.context_type AS context_type_1, t0.id AS id_2, t0.date_add AS date_add_3, t0.date_upd AS date_upd_4, t0.deleted AS deleted_5, t0.locked AS locked_6, t0.is_draft AS is_draft_7, t0.can_be_deleted AS can_be_deleted_8, t0.owner_organization_id AS owner_organization_id_9, t0.actor_id AS actor_id_10, t11.lastname AS lastname_12, t11.firstname AS firstname_13, t11.birth_place AS birth_place_14, t11.birth_date AS birth_date_15, t11.gender AS gender_16, t11.id AS id_17, t11.date_add AS date_add_18, t11.date_upd AS date_upd_19, t11.deleted AS deleted_20, t11.locked AS locked_21, t11.is_draft AS is_draft_22, t11.can_be_deleted AS can_be_deleted_23, t11.owner_organization_id AS owner_organization_id_24, t11.access_id AS access_id_25, t11.author_id AS author_id_26, t0.organization_id AS organization_id_27, t28.name AS name_29, t28.is_plateform_manager AS is_plateform_manager_30, t28.id AS id_31, t28.date_add AS date_add_32, t28.date_upd AS date_upd_33, t28.deleted AS deleted_34, t28.locked AS locked_35, t28.is_draft AS is_draft_36, t28.can_be_deleted AS can_be_deleted_37, t28.owner_organization_id AS owner_organization_id_38, t28.actor_id AS actor_id_39, t28.thumbnail_id AS thumbnail_id_40, t28.author_id AS author_id_41, t0.author_id AS author_id_42, t43.lastname AS lastname_44, t43.firstname AS firstname_45, t43.birth_place AS birth_place_46, t43.birth_date AS birth_date_47, t43.gender AS gender_48, t43.id AS id_49, t43.date_add AS date_add_50, t43.date_upd AS date_upd_51, t43.deleted AS deleted_52, t43.locked AS locked_53, t43.is_draft AS is_draft_54, t43.can_be_deleted AS can_be_deleted_55, t43.owner_organization_id AS owner_organization_id_56, t43.access_id AS access_id_57, t43.author_id AS author_id_58 FROM app_core_user_workspace t0 INNER JOIN app_core_user_actor t11 ON t0.actor_id = t11.id INNER JOIN app_core_user_organization t28 ON t0.organization_id = t28.id LEFT JOIN app_core_user_actor t43 ON t0.author_id = t43.id WHERE t0.deleted = ? LIMIT 1 Parameters: [`0`] View formatted query View runnable query Explain query SELECT t0.context_type AS context_type_1, t0.id AS id_2, t0.date_add AS date_add_3, t0.date_upd AS date_upd_4, t0.deleted AS deleted_5, t0.locked AS locked_6, t0.is_draft AS is_draft_7, t0.can_be_deleted AS can_be_deleted_8, t0.owner_organization_id AS owner_organization_id_9, t0.actor_id AS actor_id_10, t11.lastname AS lastname_12, t11.firstname AS firstname_13, t11.birth_place AS birth_place_14, t11.birth_date AS birth_date_15, t11.gender AS gender_16, t11.id AS id_17, t11.date_add AS date_add_18, t11.date_upd AS date_upd_19, t11.deleted AS deleted_20, t11.locked AS locked_21, t11.is_draft AS is_draft_22, t11.can_be_deleted AS can_be_deleted_23, t11.owner_organization_id AS owner_organization_id_24, t11.access_id AS access_id_25, t11.author_id AS author_id_26, t0.organization_id AS organization_id_27, t28.name AS name_29, t28.is_plateform_manager AS is_plateform_manager_30, t28.id AS id_31, t28.date_add AS date_add_32, t28.date_upd AS date_upd_33, t28.deleted AS deleted_34, t28.locked AS locked_35, t28.is_draft AS is_draft_36, t28.can_be_deleted AS can_be_deleted_37, t28.owner_organization_id AS owner_organization_id_38, t28.actor_id AS actor_id_39, t28.thumbnail_id AS thumbnail_id_40, t28.author_id AS author_id_41, t0.author_id AS author_id_42, t43.lastname AS lastname_44, t43.firstname AS firstname_45, t43.birth_place AS birth_place_46, t43.birth_date AS birth_date_47, t43.gender AS gender_48, t43.id AS id_49, t43.date_add AS date_add_50, t43.date_upd AS date_upd_51, t43.deleted AS deleted_52, t43.locked AS locked_53, t43.is_draft AS is_draft_54, t43.can_be_deleted AS can_be_deleted_55, t43.owner_organization_id AS owner_organization_id_56, t43.access_id AS access_id_57, t43.author_id AS author_id_58 FROM app_core_user_workspace t0 INNER JOIN app_core_user_actor t11 ON t0.actor_id = t11.id INNER JOIN app_core_user_organization t28 ON t0.organization_id = t28.id LEFT JOIN app_core_user_actor t43 ON t0.author_id = t43.id WHERE t0.deleted = ? LIMIT 1 SELECT t0.context_type AS context_type_1, t0.id AS id_2, t0.date_add AS date_add_3, t0.date_upd AS date_upd_4, t0.deleted AS deleted_5, t0.locked AS locked_6, t0.is_draft AS is_draft_7, t0.can_be_deleted AS can_be_deleted_8, t0.owner_organization_id AS owner_organization_id_9, t0.actor_id AS actor_id_10, t11.lastname AS lastname_12, t11.firstname AS firstname_13, t11.birth_place AS birth_place_14, t11.birth_date AS birth_date_15, t11.gender AS gender_16, t11.id AS id_17, t11.date_add AS date_add_18, t11.date_upd AS date_upd_19, t11.deleted AS deleted_20, t11.locked AS locked_21, t11.is_draft AS is_draft_22, t11.can_be_deleted AS can_be_deleted_23, t11.owner_organization_id AS owner_organization_id_24, t11.access_id AS access_id_25, t11.author_id AS author_id_26, t0.organization_id AS organization_id_27, t28.name AS name_29, t28.is_plateform_manager AS is_plateform_manager_30, t28.id AS id_31, t28.date_add AS date_add_32, t28.date_upd AS date_upd_33, t28.deleted AS deleted_34, t28.locked AS locked_35, t28.is_draft AS is_draft_36, t28.can_be_deleted AS can_be_deleted_37, t28.owner_organization_id AS owner_organization_id_38, t28.actor_id AS actor_id_39, t28.thumbnail_id AS thumbnail_id_40, t28.author_id AS author_id_41, t0.author_id AS author_id_42, t43.lastname AS lastname_44, t43.firstname AS firstname_45, t43.birth_place AS birth_place_46, t43.birth_date AS birth_date_47, t43.gender AS gender_48, t43.id AS id_49, t43.date_add AS date_add_50, t43.date_upd AS date_upd_51, t43.deleted AS deleted_52, t43.locked AS locked_53, t43.is_draft AS is_draft_54, t43.can_be_deleted AS can_be_deleted_55, t43.owner_organization_id AS owner_organization_id_56, t43.access_id AS access_id_57, t43.author_id AS author_id_58 FROM app_core_user_workspace t0 INNER JOIN app_core_user_actor t11 ON t0.actor_id = t11.id INNER JOIN app_core_user_organization t28 ON t0.organization_id = t28.id LEFT JOIN app_core_user_actor t43 ON t0.author_id = t43.id WHERE t0.deleted = 0 LIMIT 1;
5.86 ms (9.84%)	1	SELECT DISTINCT id_3 FROM (SELECT DISTINCT id_3, position_2 FROM (SELECT a0_.class_css AS class_css_0, a0_.type AS type_1, a0_.position AS position_2, a0_.id AS id_3, a0_.date_add AS date_add_4, a0_.date_upd AS date_upd_5, a0_.deleted AS deleted_6, a0_.locked AS locked_7, a0_.is_draft AS is_draft_8, a0_.can_be_deleted AS can_be_deleted_9, a0_.owner_organization_id AS owner_organization_id_10, a1_.sub_title AS sub_title_11, a1_.id AS id_12, a1_.locale AS locale_13, a1_.name AS name_14, a1_.description AS description_15, a1_.meta_description AS meta_description_16, a1_.work_keys AS work_keys_17, a1_.slug AS slug_18, a2_.status AS status_19, a2_.target AS target_20, a2_.group_type AS group_type_21, a2_.target_menu AS target_menu_22, a2_.client_type AS client_type_23, a2_.lend_type AS lend_type_24, a2_.lend_types AS lend_types_25, a2_.show_in_menu AS show_in_menu_26, a2_.show_title AS show_title_27, a2_.position AS position_28, a2_.anchor AS anchor_29, a2_.id AS id_30, a2_.date_add AS date_add_31, a2_.date_upd AS date_upd_32, a2_.deleted AS deleted_33, a2_.locked AS locked_34, a2_.is_draft AS is_draft_35, a2_.can_be_deleted AS can_be_deleted_36, a2_.owner_organization_id AS owner_organization_id_37, a3_.is_downloaded AS is_downloaded_38, a3_.is_show_page AS is_show_page_39, a3_.code AS code_40, a3_.type AS type_41, a3_.status AS status_42, a3_.id AS id_43, a3_.date_add AS date_add_44, a3_.date_upd AS date_upd_45, a3_.deleted AS deleted_46, a3_.locked AS locked_47, a3_.is_draft AS is_draft_48, a3_.can_be_deleted AS can_be_deleted_49, a3_.owner_organization_id AS owner_organization_id_50 FROM app_blog_page_section a0_ INNER JOIN app_blog_page_section_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_product a2_ ON a0_.product_id = a2_.id LEFT JOIN app_core_cms_page a3_ ON a0_.cms_page_id = a3_.id WHERE a0_.deleted = 0 AND a2_.id = '25' AND a0_.deleted = 0) dctrn_result_inner ORDER BY position_2 ASC) dctrn_result LIMIT 100000 Parameters: [] View formatted query View runnable query Explain query SELECT DISTINCT id_3 FROM ( SELECT DISTINCT id_3, position_2 FROM ( SELECT a0_.class_css AS class_css_0, a0_.type AS type_1, a0_.position AS position_2, a0_.id AS id_3, a0_.date_add AS date_add_4, a0_.date_upd AS date_upd_5, a0_.deleted AS deleted_6, a0_.locked AS locked_7, a0_.is_draft AS is_draft_8, a0_.can_be_deleted AS can_be_deleted_9, a0_.owner_organization_id AS owner_organization_id_10, a1_.sub_title AS sub_title_11, a1_.id AS id_12, a1_.locale AS locale_13, a1_.name AS name_14, a1_.description AS description_15, a1_.meta_description AS meta_description_16, a1_.work_keys AS work_keys_17, a1_.slug AS slug_18, a2_.status AS status_19, a2_.target AS target_20, a2_.group_type AS group_type_21, a2_.target_menu AS target_menu_22, a2_.client_type AS client_type_23, a2_.lend_type AS lend_type_24, a2_.lend_types AS lend_types_25, a2_.show_in_menu AS show_in_menu_26, a2_.show_title AS show_title_27, a2_.position AS position_28, a2_.anchor AS anchor_29, a2_.id AS id_30, a2_.date_add AS date_add_31, a2_.date_upd AS date_upd_32, a2_.deleted AS deleted_33, a2_.locked AS locked_34, a2_.is_draft AS is_draft_35, a2_.can_be_deleted AS can_be_deleted_36, a2_.owner_organization_id AS owner_organization_id_37, a3_.is_downloaded AS is_downloaded_38, a3_.is_show_page AS is_show_page_39, a3_.code AS code_40, a3_.type AS type_41, a3_.status AS status_42, a3_.id AS id_43, a3_.date_add AS date_add_44, a3_.date_upd AS date_upd_45, a3_.deleted AS deleted_46, a3_.locked AS locked_47, a3_.is_draft AS is_draft_48, a3_.can_be_deleted AS can_be_deleted_49, a3_.owner_organization_id AS owner_organization_id_50 FROM app_blog_page_section a0_ INNER JOIN app_blog_page_section_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_product a2_ ON a0_.product_id = a2_.id LEFT JOIN app_core_cms_page a3_ ON a0_.cms_page_id = a3_.id WHERE a0_.deleted = 0 AND a2_.id = '25' AND a0_.deleted = 0 ) dctrn_result_inner ORDER BY position_2 ASC ) dctrn_result LIMIT 100000 SELECT DISTINCT id_3 FROM (SELECT DISTINCT id_3, position_2 FROM (SELECT a0_.class_css AS class_css_0, a0_.type AS type_1, a0_.position AS position_2, a0_.id AS id_3, a0_.date_add AS date_add_4, a0_.date_upd AS date_upd_5, a0_.deleted AS deleted_6, a0_.locked AS locked_7, a0_.is_draft AS is_draft_8, a0_.can_be_deleted AS can_be_deleted_9, a0_.owner_organization_id AS owner_organization_id_10, a1_.sub_title AS sub_title_11, a1_.id AS id_12, a1_.locale AS locale_13, a1_.name AS name_14, a1_.description AS description_15, a1_.meta_description AS meta_description_16, a1_.work_keys AS work_keys_17, a1_.slug AS slug_18, a2_.status AS status_19, a2_.target AS target_20, a2_.group_type AS group_type_21, a2_.target_menu AS target_menu_22, a2_.client_type AS client_type_23, a2_.lend_type AS lend_type_24, a2_.lend_types AS lend_types_25, a2_.show_in_menu AS show_in_menu_26, a2_.show_title AS show_title_27, a2_.position AS position_28, a2_.anchor AS anchor_29, a2_.id AS id_30, a2_.date_add AS date_add_31, a2_.date_upd AS date_upd_32, a2_.deleted AS deleted_33, a2_.locked AS locked_34, a2_.is_draft AS is_draft_35, a2_.can_be_deleted AS can_be_deleted_36, a2_.owner_organization_id AS owner_organization_id_37, a3_.is_downloaded AS is_downloaded_38, a3_.is_show_page AS is_show_page_39, a3_.code AS code_40, a3_.type AS type_41, a3_.status AS status_42, a3_.id AS id_43, a3_.date_add AS date_add_44, a3_.date_upd AS date_upd_45, a3_.deleted AS deleted_46, a3_.locked AS locked_47, a3_.is_draft AS is_draft_48, a3_.can_be_deleted AS can_be_deleted_49, a3_.owner_organization_id AS owner_organization_id_50 FROM app_blog_page_section a0_ INNER JOIN app_blog_page_section_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_product a2_ ON a0_.product_id = a2_.id LEFT JOIN app_core_cms_page a3_ ON a0_.cms_page_id = a3_.id WHERE a0_.deleted = 0 AND a2_.id = '25' AND a0_.deleted = 0) dctrn_result_inner ORDER BY position_2 ASC) dctrn_result LIMIT 100000;
3.38 ms (5.67%)	1	SELECT t0.status AS status_1, t0.target AS target_2, t0.group_type AS group_type_3, t0.target_menu AS target_menu_4, t0.client_type AS client_type_5, t0.lend_type AS lend_type_6, t0.lend_types AS lend_types_7, t0.show_in_menu AS show_in_menu_8, t0.show_title AS show_title_9, t0.position AS position_10, t0.anchor AS anchor_11, t0.id AS id_12, t0.date_add AS date_add_13, t0.date_upd AS date_upd_14, t0.deleted AS deleted_15, t0.locked AS locked_16, t0.is_draft AS is_draft_17, t0.can_be_deleted AS can_be_deleted_18, t0.owner_organization_id AS owner_organization_id_19, t0.type_id AS type_id_20, t21.color AS color_22, t21.bg_color AS bg_color_23, t21.type AS type_24, t21.target AS target_25, t21.target_menu AS target_menu_26, t21.client_type AS client_type_27, t21.position AS position_28, t21.status AS status_29, t21.id AS id_30, t21.date_add AS date_add_31, t21.date_upd AS date_upd_32, t21.deleted AS deleted_33, t21.locked AS locked_34, t21.is_draft AS is_draft_35, t21.can_be_deleted AS can_be_deleted_36, t21.owner_organization_id AS owner_organization_id_37, t21.author_id AS author_id_38, t0.parent_id AS parent_id_39, t40.status AS status_41, t40.target AS target_42, t40.group_type AS group_type_43, t40.target_menu AS target_menu_44, t40.client_type AS client_type_45, t40.lend_type AS lend_type_46, t40.lend_types AS lend_types_47, t40.show_in_menu AS show_in_menu_48, t40.show_title AS show_title_49, t40.position AS position_50, t40.anchor AS anchor_51, t40.id AS id_52, t40.date_add AS date_add_53, t40.date_upd AS date_upd_54, t40.deleted AS deleted_55, t40.locked AS locked_56, t40.is_draft AS is_draft_57, t40.can_be_deleted AS can_be_deleted_58, t40.owner_organization_id AS owner_organization_id_59, t40.type_id AS type_id_60, t40.parent_id AS parent_id_61, t40.thumbnail_id AS thumbnail_id_62, t40.author_id AS author_id_63, t0.thumbnail_id AS thumbnail_id_64, t65.filename AS filename_66, t65.original_name AS original_name_67, t65.mime_type AS mime_type_68, t65.extension AS extension_69, t65.size AS size_70, t65.url AS url_71, t65.id AS id_72, t65.date_add AS date_add_73, t65.date_upd AS date_upd_74, t65.deleted AS deleted_75, t65.locked AS locked_76, t65.is_draft AS is_draft_77, t65.can_be_deleted AS can_be_deleted_78, t65.owner_organization_id AS owner_organization_id_79, t65.author_id AS author_id_80, t0.author_id AS author_id_81, t82.lastname AS lastname_83, t82.firstname AS firstname_84, t82.birth_place AS birth_place_85, t82.birth_date AS birth_date_86, t82.gender AS gender_87, t82.id AS id_88, t82.date_add AS date_add_89, t82.date_upd AS date_upd_90, t82.deleted AS deleted_91, t82.locked AS locked_92, t82.is_draft AS is_draft_93, t82.can_be_deleted AS can_be_deleted_94, t82.owner_organization_id AS owner_organization_id_95, t82.access_id AS access_id_96, t82.author_id AS author_id_97 FROM app_business_product t0 LEFT JOIN app_business_category t21 ON t0.type_id = t21.id LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id WHERE t0.id = ? Parameters: [`25`] View formatted query View runnable query Explain query SELECT t0.status AS status_1, t0.target AS target_2, t0.group_type AS group_type_3, t0.target_menu AS target_menu_4, t0.client_type AS client_type_5, t0.lend_type AS lend_type_6, t0.lend_types AS lend_types_7, t0.show_in_menu AS show_in_menu_8, t0.show_title AS show_title_9, t0.position AS position_10, t0.anchor AS anchor_11, t0.id AS id_12, t0.date_add AS date_add_13, t0.date_upd AS date_upd_14, t0.deleted AS deleted_15, t0.locked AS locked_16, t0.is_draft AS is_draft_17, t0.can_be_deleted AS can_be_deleted_18, t0.owner_organization_id AS owner_organization_id_19, t0.type_id AS type_id_20, t21.color AS color_22, t21.bg_color AS bg_color_23, t21.type AS type_24, t21.target AS target_25, t21.target_menu AS target_menu_26, t21.client_type AS client_type_27, t21.position AS position_28, t21.status AS status_29, t21.id AS id_30, t21.date_add AS date_add_31, t21.date_upd AS date_upd_32, t21.deleted AS deleted_33, t21.locked AS locked_34, t21.is_draft AS is_draft_35, t21.can_be_deleted AS can_be_deleted_36, t21.owner_organization_id AS owner_organization_id_37, t21.author_id AS author_id_38, t0.parent_id AS parent_id_39, t40.status AS status_41, t40.target AS target_42, t40.group_type AS group_type_43, t40.target_menu AS target_menu_44, t40.client_type AS client_type_45, t40.lend_type AS lend_type_46, t40.lend_types AS lend_types_47, t40.show_in_menu AS show_in_menu_48, t40.show_title AS show_title_49, t40.position AS position_50, t40.anchor AS anchor_51, t40.id AS id_52, t40.date_add AS date_add_53, t40.date_upd AS date_upd_54, t40.deleted AS deleted_55, t40.locked AS locked_56, t40.is_draft AS is_draft_57, t40.can_be_deleted AS can_be_deleted_58, t40.owner_organization_id AS owner_organization_id_59, t40.type_id AS type_id_60, t40.parent_id AS parent_id_61, t40.thumbnail_id AS thumbnail_id_62, t40.author_id AS author_id_63, t0.thumbnail_id AS thumbnail_id_64, t65.filename AS filename_66, t65.original_name AS original_name_67, t65.mime_type AS mime_type_68, t65.extension AS extension_69, t65.size AS size_70, t65.url AS url_71, t65.id AS id_72, t65.date_add AS date_add_73, t65.date_upd AS date_upd_74, t65.deleted AS deleted_75, t65.locked AS locked_76, t65.is_draft AS is_draft_77, t65.can_be_deleted AS can_be_deleted_78, t65.owner_organization_id AS owner_organization_id_79, t65.author_id AS author_id_80, t0.author_id AS author_id_81, t82.lastname AS lastname_83, t82.firstname AS firstname_84, t82.birth_place AS birth_place_85, t82.birth_date AS birth_date_86, t82.gender AS gender_87, t82.id AS id_88, t82.date_add AS date_add_89, t82.date_upd AS date_upd_90, t82.deleted AS deleted_91, t82.locked AS locked_92, t82.is_draft AS is_draft_93, t82.can_be_deleted AS can_be_deleted_94, t82.owner_organization_id AS owner_organization_id_95, t82.access_id AS access_id_96, t82.author_id AS author_id_97 FROM app_business_product t0 LEFT JOIN app_business_category t21 ON t0.type_id = t21.id LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id WHERE t0.id = ? SELECT t0.status AS status_1, t0.target AS target_2, t0.group_type AS group_type_3, t0.target_menu AS target_menu_4, t0.client_type AS client_type_5, t0.lend_type AS lend_type_6, t0.lend_types AS lend_types_7, t0.show_in_menu AS show_in_menu_8, t0.show_title AS show_title_9, t0.position AS position_10, t0.anchor AS anchor_11, t0.id AS id_12, t0.date_add AS date_add_13, t0.date_upd AS date_upd_14, t0.deleted AS deleted_15, t0.locked AS locked_16, t0.is_draft AS is_draft_17, t0.can_be_deleted AS can_be_deleted_18, t0.owner_organization_id AS owner_organization_id_19, t0.type_id AS type_id_20, t21.color AS color_22, t21.bg_color AS bg_color_23, t21.type AS type_24, t21.target AS target_25, t21.target_menu AS target_menu_26, t21.client_type AS client_type_27, t21.position AS position_28, t21.status AS status_29, t21.id AS id_30, t21.date_add AS date_add_31, t21.date_upd AS date_upd_32, t21.deleted AS deleted_33, t21.locked AS locked_34, t21.is_draft AS is_draft_35, t21.can_be_deleted AS can_be_deleted_36, t21.owner_organization_id AS owner_organization_id_37, t21.author_id AS author_id_38, t0.parent_id AS parent_id_39, t40.status AS status_41, t40.target AS target_42, t40.group_type AS group_type_43, t40.target_menu AS target_menu_44, t40.client_type AS client_type_45, t40.lend_type AS lend_type_46, t40.lend_types AS lend_types_47, t40.show_in_menu AS show_in_menu_48, t40.show_title AS show_title_49, t40.position AS position_50, t40.anchor AS anchor_51, t40.id AS id_52, t40.date_add AS date_add_53, t40.date_upd AS date_upd_54, t40.deleted AS deleted_55, t40.locked AS locked_56, t40.is_draft AS is_draft_57, t40.can_be_deleted AS can_be_deleted_58, t40.owner_organization_id AS owner_organization_id_59, t40.type_id AS type_id_60, t40.parent_id AS parent_id_61, t40.thumbnail_id AS thumbnail_id_62, t40.author_id AS author_id_63, t0.thumbnail_id AS thumbnail_id_64, t65.filename AS filename_66, t65.original_name AS original_name_67, t65.mime_type AS mime_type_68, t65.extension AS extension_69, t65.size AS size_70, t65.url AS url_71, t65.id AS id_72, t65.date_add AS date_add_73, t65.date_upd AS date_upd_74, t65.deleted AS deleted_75, t65.locked AS locked_76, t65.is_draft AS is_draft_77, t65.can_be_deleted AS can_be_deleted_78, t65.owner_organization_id AS owner_organization_id_79, t65.author_id AS author_id_80, t0.author_id AS author_id_81, t82.lastname AS lastname_83, t82.firstname AS firstname_84, t82.birth_place AS birth_place_85, t82.birth_date AS birth_date_86, t82.gender AS gender_87, t82.id AS id_88, t82.date_add AS date_add_89, t82.date_upd AS date_upd_90, t82.deleted AS deleted_91, t82.locked AS locked_92, t82.is_draft AS is_draft_93, t82.can_be_deleted AS can_be_deleted_94, t82.owner_organization_id AS owner_organization_id_95, t82.access_id AS access_id_96, t82.author_id AS author_id_97 FROM app_business_product t0 LEFT JOIN app_business_category t21 ON t0.type_id = t21.id LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id WHERE t0.id = 25;
3.32 ms (5.57%)	1	SELECT t0.position AS position_1, t0.id AS id_2, t0.date_add AS date_add_3, t0.date_upd AS date_upd_4, t0.deleted AS deleted_5, t0.locked AS locked_6, t0.is_draft AS is_draft_7, t0.can_be_deleted AS can_be_deleted_8, t0.owner_organization_id AS owner_organization_id_9, t0.section_id AS section_id_10, t11.class_css AS class_css_12, t11.type AS type_13, t11.position AS position_14, t11.id AS id_15, t11.date_add AS date_add_16, t11.date_upd AS date_upd_17, t11.deleted AS deleted_18, t11.locked AS locked_19, t11.is_draft AS is_draft_20, t11.can_be_deleted AS can_be_deleted_21, t11.owner_organization_id AS owner_organization_id_22, t11.thumbnail_id AS thumbnail_id_23, t11.product_id AS product_id_24, t11.cms_page_id AS cms_page_id_25, t11.author_id AS author_id_26, t0.thumbnail_id AS thumbnail_id_27, t28.filename AS filename_29, t28.original_name AS original_name_30, t28.mime_type AS mime_type_31, t28.extension AS extension_32, t28.size AS size_33, t28.url AS url_34, t28.id AS id_35, t28.date_add AS date_add_36, t28.date_upd AS date_upd_37, t28.deleted AS deleted_38, t28.locked AS locked_39, t28.is_draft AS is_draft_40, t28.can_be_deleted AS can_be_deleted_41, t28.owner_organization_id AS owner_organization_id_42, t28.author_id AS author_id_43, t0.author_id AS author_id_44, t45.lastname AS lastname_46, t45.firstname AS firstname_47, t45.birth_place AS birth_place_48, t45.birth_date AS birth_date_49, t45.gender AS gender_50, t45.id AS id_51, t45.date_add AS date_add_52, t45.date_upd AS date_upd_53, t45.deleted AS deleted_54, t45.locked AS locked_55, t45.is_draft AS is_draft_56, t45.can_be_deleted AS can_be_deleted_57, t45.owner_organization_id AS owner_organization_id_58, t45.access_id AS access_id_59, t45.author_id AS author_id_60 FROM app_blog_page_section_item t0 LEFT JOIN app_blog_page_section t11 ON t0.section_id = t11.id LEFT JOIN app_core_attachment t28 ON t0.thumbnail_id = t28.id LEFT JOIN app_core_user_actor t45 ON t0.author_id = t45.id WHERE t0.section_id IN (?, ?, ?, ?) Parameters: [`72 73 74 75`] View formatted query View runnable query Explain query SELECT t0.position AS position_1, t0.id AS id_2, t0.date_add AS date_add_3, t0.date_upd AS date_upd_4, t0.deleted AS deleted_5, t0.locked AS locked_6, t0.is_draft AS is_draft_7, t0.can_be_deleted AS can_be_deleted_8, t0.owner_organization_id AS owner_organization_id_9, t0.section_id AS section_id_10, t11.class_css AS class_css_12, t11.type AS type_13, t11.position AS position_14, t11.id AS id_15, t11.date_add AS date_add_16, t11.date_upd AS date_upd_17, t11.deleted AS deleted_18, t11.locked AS locked_19, t11.is_draft AS is_draft_20, t11.can_be_deleted AS can_be_deleted_21, t11.owner_organization_id AS owner_organization_id_22, t11.thumbnail_id AS thumbnail_id_23, t11.product_id AS product_id_24, t11.cms_page_id AS cms_page_id_25, t11.author_id AS author_id_26, t0.thumbnail_id AS thumbnail_id_27, t28.filename AS filename_29, t28.original_name AS original_name_30, t28.mime_type AS mime_type_31, t28.extension AS extension_32, t28.size AS size_33, t28.url AS url_34, t28.id AS id_35, t28.date_add AS date_add_36, t28.date_upd AS date_upd_37, t28.deleted AS deleted_38, t28.locked AS locked_39, t28.is_draft AS is_draft_40, t28.can_be_deleted AS can_be_deleted_41, t28.owner_organization_id AS owner_organization_id_42, t28.author_id AS author_id_43, t0.author_id AS author_id_44, t45.lastname AS lastname_46, t45.firstname AS firstname_47, t45.birth_place AS birth_place_48, t45.birth_date AS birth_date_49, t45.gender AS gender_50, t45.id AS id_51, t45.date_add AS date_add_52, t45.date_upd AS date_upd_53, t45.deleted AS deleted_54, t45.locked AS locked_55, t45.is_draft AS is_draft_56, t45.can_be_deleted AS can_be_deleted_57, t45.owner_organization_id AS owner_organization_id_58, t45.access_id AS access_id_59, t45.author_id AS author_id_60 FROM app_blog_page_section_item t0 LEFT JOIN app_blog_page_section t11 ON t0.section_id = t11.id LEFT JOIN app_core_attachment t28 ON t0.thumbnail_id = t28.id LEFT JOIN app_core_user_actor t45 ON t0.author_id = t45.id WHERE t0.section_id IN (?, ?, ?, ?) SELECT t0.position AS position_1, t0.id AS id_2, t0.date_add AS date_add_3, t0.date_upd AS date_upd_4, t0.deleted AS deleted_5, t0.locked AS locked_6, t0.is_draft AS is_draft_7, t0.can_be_deleted AS can_be_deleted_8, t0.owner_organization_id AS owner_organization_id_9, t0.section_id AS section_id_10, t11.class_css AS class_css_12, t11.type AS type_13, t11.position AS position_14, t11.id AS id_15, t11.date_add AS date_add_16, t11.date_upd AS date_upd_17, t11.deleted AS deleted_18, t11.locked AS locked_19, t11.is_draft AS is_draft_20, t11.can_be_deleted AS can_be_deleted_21, t11.owner_organization_id AS owner_organization_id_22, t11.thumbnail_id AS thumbnail_id_23, t11.product_id AS product_id_24, t11.cms_page_id AS cms_page_id_25, t11.author_id AS author_id_26, t0.thumbnail_id AS thumbnail_id_27, t28.filename AS filename_29, t28.original_name AS original_name_30, t28.mime_type AS mime_type_31, t28.extension AS extension_32, t28.size AS size_33, t28.url AS url_34, t28.id AS id_35, t28.date_add AS date_add_36, t28.date_upd AS date_upd_37, t28.deleted AS deleted_38, t28.locked AS locked_39, t28.is_draft AS is_draft_40, t28.can_be_deleted AS can_be_deleted_41, t28.owner_organization_id AS owner_organization_id_42, t28.author_id AS author_id_43, t0.author_id AS author_id_44, t45.lastname AS lastname_46, t45.firstname AS firstname_47, t45.birth_place AS birth_place_48, t45.birth_date AS birth_date_49, t45.gender AS gender_50, t45.id AS id_51, t45.date_add AS date_add_52, t45.date_upd AS date_upd_53, t45.deleted AS deleted_54, t45.locked AS locked_55, t45.is_draft AS is_draft_56, t45.can_be_deleted AS can_be_deleted_57, t45.owner_organization_id AS owner_organization_id_58, t45.access_id AS access_id_59, t45.author_id AS author_id_60 FROM app_blog_page_section_item t0 LEFT JOIN app_blog_page_section t11 ON t0.section_id = t11.id LEFT JOIN app_core_attachment t28 ON t0.thumbnail_id = t28.id LEFT JOIN app_core_user_actor t45 ON t0.author_id = t45.id WHERE t0.section_id IN (72, 73, 74, 75);
2.96 ms (4.97%)	2	SELECT t0.status AS status_1, t0.target AS target_2, t0.group_type AS group_type_3, t0.target_menu AS target_menu_4, t0.client_type AS client_type_5, t0.lend_type AS lend_type_6, t0.lend_types AS lend_types_7, t0.show_in_menu AS show_in_menu_8, t0.show_title AS show_title_9, t0.position AS position_10, t0.anchor AS anchor_11, t0.id AS id_12, t0.date_add AS date_add_13, t0.date_upd AS date_upd_14, t0.deleted AS deleted_15, t0.locked AS locked_16, t0.is_draft AS is_draft_17, t0.can_be_deleted AS can_be_deleted_18, t0.owner_organization_id AS owner_organization_id_19, t0.type_id AS type_id_20, t21.color AS color_22, t21.bg_color AS bg_color_23, t21.type AS type_24, t21.target AS target_25, t21.target_menu AS target_menu_26, t21.client_type AS client_type_27, t21.position AS position_28, t21.status AS status_29, t21.id AS id_30, t21.date_add AS date_add_31, t21.date_upd AS date_upd_32, t21.deleted AS deleted_33, t21.locked AS locked_34, t21.is_draft AS is_draft_35, t21.can_be_deleted AS can_be_deleted_36, t21.owner_organization_id AS owner_organization_id_37, t21.author_id AS author_id_38, t0.parent_id AS parent_id_39, t40.status AS status_41, t40.target AS target_42, t40.group_type AS group_type_43, t40.target_menu AS target_menu_44, t40.client_type AS client_type_45, t40.lend_type AS lend_type_46, t40.lend_types AS lend_types_47, t40.show_in_menu AS show_in_menu_48, t40.show_title AS show_title_49, t40.position AS position_50, t40.anchor AS anchor_51, t40.id AS id_52, t40.date_add AS date_add_53, t40.date_upd AS date_upd_54, t40.deleted AS deleted_55, t40.locked AS locked_56, t40.is_draft AS is_draft_57, t40.can_be_deleted AS can_be_deleted_58, t40.owner_organization_id AS owner_organization_id_59, t40.type_id AS type_id_60, t40.parent_id AS parent_id_61, t40.thumbnail_id AS thumbnail_id_62, t40.author_id AS author_id_63, t0.thumbnail_id AS thumbnail_id_64, t65.filename AS filename_66, t65.original_name AS original_name_67, t65.mime_type AS mime_type_68, t65.extension AS extension_69, t65.size AS size_70, t65.url AS url_71, t65.id AS id_72, t65.date_add AS date_add_73, t65.date_upd AS date_upd_74, t65.deleted AS deleted_75, t65.locked AS locked_76, t65.is_draft AS is_draft_77, t65.can_be_deleted AS can_be_deleted_78, t65.owner_organization_id AS owner_organization_id_79, t65.author_id AS author_id_80, t0.author_id AS author_id_81, t82.lastname AS lastname_83, t82.firstname AS firstname_84, t82.birth_place AS birth_place_85, t82.birth_date AS birth_date_86, t82.gender AS gender_87, t82.id AS id_88, t82.date_add AS date_add_89, t82.date_upd AS date_upd_90, t82.deleted AS deleted_91, t82.locked AS locked_92, t82.is_draft AS is_draft_93, t82.can_be_deleted AS can_be_deleted_94, t82.owner_organization_id AS owner_organization_id_95, t82.access_id AS access_id_96, t82.author_id AS author_id_97 FROM app_business_product t0 LEFT JOIN app_business_category t21 ON t0.type_id = t21.id LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id WHERE t0.parent_id IN (?) Parameters: [`25`] View formatted query View runnable query Explain query SELECT t0.status AS status_1, t0.target AS target_2, t0.group_type AS group_type_3, t0.target_menu AS target_menu_4, t0.client_type AS client_type_5, t0.lend_type AS lend_type_6, t0.lend_types AS lend_types_7, t0.show_in_menu AS show_in_menu_8, t0.show_title AS show_title_9, t0.position AS position_10, t0.anchor AS anchor_11, t0.id AS id_12, t0.date_add AS date_add_13, t0.date_upd AS date_upd_14, t0.deleted AS deleted_15, t0.locked AS locked_16, t0.is_draft AS is_draft_17, t0.can_be_deleted AS can_be_deleted_18, t0.owner_organization_id AS owner_organization_id_19, t0.type_id AS type_id_20, t21.color AS color_22, t21.bg_color AS bg_color_23, t21.type AS type_24, t21.target AS target_25, t21.target_menu AS target_menu_26, t21.client_type AS client_type_27, t21.position AS position_28, t21.status AS status_29, t21.id AS id_30, t21.date_add AS date_add_31, t21.date_upd AS date_upd_32, t21.deleted AS deleted_33, t21.locked AS locked_34, t21.is_draft AS is_draft_35, t21.can_be_deleted AS can_be_deleted_36, t21.owner_organization_id AS owner_organization_id_37, t21.author_id AS author_id_38, t0.parent_id AS parent_id_39, t40.status AS status_41, t40.target AS target_42, t40.group_type AS group_type_43, t40.target_menu AS target_menu_44, t40.client_type AS client_type_45, t40.lend_type AS lend_type_46, t40.lend_types AS lend_types_47, t40.show_in_menu AS show_in_menu_48, t40.show_title AS show_title_49, t40.position AS position_50, t40.anchor AS anchor_51, t40.id AS id_52, t40.date_add AS date_add_53, t40.date_upd AS date_upd_54, t40.deleted AS deleted_55, t40.locked AS locked_56, t40.is_draft AS is_draft_57, t40.can_be_deleted AS can_be_deleted_58, t40.owner_organization_id AS owner_organization_id_59, t40.type_id AS type_id_60, t40.parent_id AS parent_id_61, t40.thumbnail_id AS thumbnail_id_62, t40.author_id AS author_id_63, t0.thumbnail_id AS thumbnail_id_64, t65.filename AS filename_66, t65.original_name AS original_name_67, t65.mime_type AS mime_type_68, t65.extension AS extension_69, t65.size AS size_70, t65.url AS url_71, t65.id AS id_72, t65.date_add AS date_add_73, t65.date_upd AS date_upd_74, t65.deleted AS deleted_75, t65.locked AS locked_76, t65.is_draft AS is_draft_77, t65.can_be_deleted AS can_be_deleted_78, t65.owner_organization_id AS owner_organization_id_79, t65.author_id AS author_id_80, t0.author_id AS author_id_81, t82.lastname AS lastname_83, t82.firstname AS firstname_84, t82.birth_place AS birth_place_85, t82.birth_date AS birth_date_86, t82.gender AS gender_87, t82.id AS id_88, t82.date_add AS date_add_89, t82.date_upd AS date_upd_90, t82.deleted AS deleted_91, t82.locked AS locked_92, t82.is_draft AS is_draft_93, t82.can_be_deleted AS can_be_deleted_94, t82.owner_organization_id AS owner_organization_id_95, t82.access_id AS access_id_96, t82.author_id AS author_id_97 FROM app_business_product t0 LEFT JOIN app_business_category t21 ON t0.type_id = t21.id LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id WHERE t0.parent_id IN (?) SELECT t0.status AS status_1, t0.target AS target_2, t0.group_type AS group_type_3, t0.target_menu AS target_menu_4, t0.client_type AS client_type_5, t0.lend_type AS lend_type_6, t0.lend_types AS lend_types_7, t0.show_in_menu AS show_in_menu_8, t0.show_title AS show_title_9, t0.position AS position_10, t0.anchor AS anchor_11, t0.id AS id_12, t0.date_add AS date_add_13, t0.date_upd AS date_upd_14, t0.deleted AS deleted_15, t0.locked AS locked_16, t0.is_draft AS is_draft_17, t0.can_be_deleted AS can_be_deleted_18, t0.owner_organization_id AS owner_organization_id_19, t0.type_id AS type_id_20, t21.color AS color_22, t21.bg_color AS bg_color_23, t21.type AS type_24, t21.target AS target_25, t21.target_menu AS target_menu_26, t21.client_type AS client_type_27, t21.position AS position_28, t21.status AS status_29, t21.id AS id_30, t21.date_add AS date_add_31, t21.date_upd AS date_upd_32, t21.deleted AS deleted_33, t21.locked AS locked_34, t21.is_draft AS is_draft_35, t21.can_be_deleted AS can_be_deleted_36, t21.owner_organization_id AS owner_organization_id_37, t21.author_id AS author_id_38, t0.parent_id AS parent_id_39, t40.status AS status_41, t40.target AS target_42, t40.group_type AS group_type_43, t40.target_menu AS target_menu_44, t40.client_type AS client_type_45, t40.lend_type AS lend_type_46, t40.lend_types AS lend_types_47, t40.show_in_menu AS show_in_menu_48, t40.show_title AS show_title_49, t40.position AS position_50, t40.anchor AS anchor_51, t40.id AS id_52, t40.date_add AS date_add_53, t40.date_upd AS date_upd_54, t40.deleted AS deleted_55, t40.locked AS locked_56, t40.is_draft AS is_draft_57, t40.can_be_deleted AS can_be_deleted_58, t40.owner_organization_id AS owner_organization_id_59, t40.type_id AS type_id_60, t40.parent_id AS parent_id_61, t40.thumbnail_id AS thumbnail_id_62, t40.author_id AS author_id_63, t0.thumbnail_id AS thumbnail_id_64, t65.filename AS filename_66, t65.original_name AS original_name_67, t65.mime_type AS mime_type_68, t65.extension AS extension_69, t65.size AS size_70, t65.url AS url_71, t65.id AS id_72, t65.date_add AS date_add_73, t65.date_upd AS date_upd_74, t65.deleted AS deleted_75, t65.locked AS locked_76, t65.is_draft AS is_draft_77, t65.can_be_deleted AS can_be_deleted_78, t65.owner_organization_id AS owner_organization_id_79, t65.author_id AS author_id_80, t0.author_id AS author_id_81, t82.lastname AS lastname_83, t82.firstname AS firstname_84, t82.birth_place AS birth_place_85, t82.birth_date AS birth_date_86, t82.gender AS gender_87, t82.id AS id_88, t82.date_add AS date_add_89, t82.date_upd AS date_upd_90, t82.deleted AS deleted_91, t82.locked AS locked_92, t82.is_draft AS is_draft_93, t82.can_be_deleted AS can_be_deleted_94, t82.owner_organization_id AS owner_organization_id_95, t82.access_id AS access_id_96, t82.author_id AS author_id_97 FROM app_business_product t0 LEFT JOIN app_business_category t21 ON t0.type_id = t21.id LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id WHERE t0.parent_id IN (25);
2.86 ms (4.80%)	1	SELECT DISTINCT id_9 FROM (SELECT DISTINCT id_9, publish_date_1 FROM (SELECT a0_.type AS type_0, a0_.publish_date AS publish_date_1, a0_.expiry_date AS expiry_date_2, a0_.source_url AS source_url_3, a0_.location AS location_4, a0_.status AS status_5, a0_.is_editor_choice AS is_editor_choice_6, a0_.hide_title AS hide_title_7, a0_.hide_excerpt AS hide_excerpt_8, a0_.id AS id_9, a0_.date_add AS date_add_10, a0_.date_upd AS date_upd_11, a0_.deleted AS deleted_12, a0_.locked AS locked_13, a0_.is_draft AS is_draft_14, a0_.can_be_deleted AS can_be_deleted_15, a0_.owner_organization_id AS owner_organization_id_16, a1_.excerpt AS excerpt_17, a1_.intro AS intro_18, a1_.id AS id_19, a1_.locale AS locale_20, a1_.name AS name_21, a1_.description AS description_22, a1_.meta_description AS meta_description_23, a1_.work_keys AS work_keys_24, a1_.slug AS slug_25, a2_.color AS color_26, a2_.bg_color AS bg_color_27, a2_.type AS type_28, a2_.target AS target_29, a2_.target_menu AS target_menu_30, a2_.client_type AS client_type_31, a2_.position AS position_32, a2_.status AS status_33, a2_.id AS id_34, a2_.date_add AS date_add_35, a2_.date_upd AS date_upd_36, a2_.deleted AS deleted_37, a2_.locked AS locked_38, a2_.is_draft AS is_draft_39, a2_.can_be_deleted AS can_be_deleted_40, a2_.owner_organization_id AS owner_organization_id_41 FROM app_blog_post a0_ INNER JOIN app_blog_post_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_blog_post_category a3_ ON a0_.id = a3_.post_id LEFT JOIN app_business_category a2_ ON a2_.id = a3_.category_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'post' AND a0_.deleted = 0) dctrn_result_inner ORDER BY publish_date_1 DESC) dctrn_result LIMIT 4 Parameters: [] View formatted query View runnable query Explain query SELECT DISTINCT id_9 FROM ( SELECT DISTINCT id_9, publish_date_1 FROM ( SELECT a0_.type AS type_0, a0_.publish_date AS publish_date_1, a0_.expiry_date AS expiry_date_2, a0_.source_url AS source_url_3, a0_.location AS location_4, a0_.status AS status_5, a0_.is_editor_choice AS is_editor_choice_6, a0_.hide_title AS hide_title_7, a0_.hide_excerpt AS hide_excerpt_8, a0_.id AS id_9, a0_.date_add AS date_add_10, a0_.date_upd AS date_upd_11, a0_.deleted AS deleted_12, a0_.locked AS locked_13, a0_.is_draft AS is_draft_14, a0_.can_be_deleted AS can_be_deleted_15, a0_.owner_organization_id AS owner_organization_id_16, a1_.excerpt AS excerpt_17, a1_.intro AS intro_18, a1_.id AS id_19, a1_.locale AS locale_20, a1_.name AS name_21, a1_.description AS description_22, a1_.meta_description AS meta_description_23, a1_.work_keys AS work_keys_24, a1_.slug AS slug_25, a2_.color AS color_26, a2_.bg_color AS bg_color_27, a2_.type AS type_28, a2_.target AS target_29, a2_.target_menu AS target_menu_30, a2_.client_type AS client_type_31, a2_.position AS position_32, a2_.status AS status_33, a2_.id AS id_34, a2_.date_add AS date_add_35, a2_.date_upd AS date_upd_36, a2_.deleted AS deleted_37, a2_.locked AS locked_38, a2_.is_draft AS is_draft_39, a2_.can_be_deleted AS can_be_deleted_40, a2_.owner_organization_id AS owner_organization_id_41 FROM app_blog_post a0_ INNER JOIN app_blog_post_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_blog_post_category a3_ ON a0_.id = a3_.post_id LEFT JOIN app_business_category a2_ ON a2_.id = a3_.category_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'post' AND a0_.deleted = 0 ) dctrn_result_inner ORDER BY publish_date_1 DESC ) dctrn_result LIMIT 4 SELECT DISTINCT id_9 FROM (SELECT DISTINCT id_9, publish_date_1 FROM (SELECT a0_.type AS type_0, a0_.publish_date AS publish_date_1, a0_.expiry_date AS expiry_date_2, a0_.source_url AS source_url_3, a0_.location AS location_4, a0_.status AS status_5, a0_.is_editor_choice AS is_editor_choice_6, a0_.hide_title AS hide_title_7, a0_.hide_excerpt AS hide_excerpt_8, a0_.id AS id_9, a0_.date_add AS date_add_10, a0_.date_upd AS date_upd_11, a0_.deleted AS deleted_12, a0_.locked AS locked_13, a0_.is_draft AS is_draft_14, a0_.can_be_deleted AS can_be_deleted_15, a0_.owner_organization_id AS owner_organization_id_16, a1_.excerpt AS excerpt_17, a1_.intro AS intro_18, a1_.id AS id_19, a1_.locale AS locale_20, a1_.name AS name_21, a1_.description AS description_22, a1_.meta_description AS meta_description_23, a1_.work_keys AS work_keys_24, a1_.slug AS slug_25, a2_.color AS color_26, a2_.bg_color AS bg_color_27, a2_.type AS type_28, a2_.target AS target_29, a2_.target_menu AS target_menu_30, a2_.client_type AS client_type_31, a2_.position AS position_32, a2_.status AS status_33, a2_.id AS id_34, a2_.date_add AS date_add_35, a2_.date_upd AS date_upd_36, a2_.deleted AS deleted_37, a2_.locked AS locked_38, a2_.is_draft AS is_draft_39, a2_.can_be_deleted AS can_be_deleted_40, a2_.owner_organization_id AS owner_organization_id_41 FROM app_blog_post a0_ INNER JOIN app_blog_post_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_blog_post_category a3_ ON a0_.id = a3_.post_id LEFT JOIN app_business_category a2_ ON a2_.id = a3_.category_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'post' AND a0_.deleted = 0) dctrn_result_inner ORDER BY publish_date_1 DESC) dctrn_result LIMIT 4;
2.85 ms (4.79%)	1	SELECT DISTINCT id_6 FROM (SELECT DISTINCT id_6, position_4 FROM (SELECT a0_.name AS name_0, a0_.url AS url_1, a0_.description AS description_2, a0_.type AS type_3, a0_.position AS position_4, a0_.status AS status_5, a0_.id AS id_6, a0_.date_add AS date_add_7, a0_.date_upd AS date_upd_8, a0_.deleted AS deleted_9, a0_.locked AS locked_10, a0_.is_draft AS is_draft_11, a0_.can_be_deleted AS can_be_deleted_12, a0_.owner_organization_id AS owner_organization_id_13, a1_.id AS id_14, a1_.locale AS locale_15, a1_.name AS name_16, a1_.description AS description_17, a1_.meta_description AS meta_description_18, a1_.work_keys AS work_keys_19, a1_.slug AS slug_20 FROM app_business_website a0_ INNER JOIN app_business_website_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'url' AND a0_.deleted = 0) dctrn_result_inner ORDER BY position_4 ASC) dctrn_result LIMIT 10 Parameters: [] View formatted query View runnable query Explain query SELECT DISTINCT id_6 FROM ( SELECT DISTINCT id_6, position_4 FROM ( SELECT a0_.name AS name_0, a0_.url AS url_1, a0_.description AS description_2, a0_.type AS type_3, a0_.position AS position_4, a0_.status AS status_5, a0_.id AS id_6, a0_.date_add AS date_add_7, a0_.date_upd AS date_upd_8, a0_.deleted AS deleted_9, a0_.locked AS locked_10, a0_.is_draft AS is_draft_11, a0_.can_be_deleted AS can_be_deleted_12, a0_.owner_organization_id AS owner_organization_id_13, a1_.id AS id_14, a1_.locale AS locale_15, a1_.name AS name_16, a1_.description AS description_17, a1_.meta_description AS meta_description_18, a1_.work_keys AS work_keys_19, a1_.slug AS slug_20 FROM app_business_website a0_ INNER JOIN app_business_website_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'url' AND a0_.deleted = 0 ) dctrn_result_inner ORDER BY position_4 ASC ) dctrn_result LIMIT 10 SELECT DISTINCT id_6 FROM (SELECT DISTINCT id_6, position_4 FROM (SELECT a0_.name AS name_0, a0_.url AS url_1, a0_.description AS description_2, a0_.type AS type_3, a0_.position AS position_4, a0_.status AS status_5, a0_.id AS id_6, a0_.date_add AS date_add_7, a0_.date_upd AS date_upd_8, a0_.deleted AS deleted_9, a0_.locked AS locked_10, a0_.is_draft AS is_draft_11, a0_.can_be_deleted AS can_be_deleted_12, a0_.owner_organization_id AS owner_organization_id_13, a1_.id AS id_14, a1_.locale AS locale_15, a1_.name AS name_16, a1_.description AS description_17, a1_.meta_description AS meta_description_18, a1_.work_keys AS work_keys_19, a1_.slug AS slug_20 FROM app_business_website a0_ INNER JOIN app_business_website_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'url' AND a0_.deleted = 0) dctrn_result_inner ORDER BY position_4 ASC) dctrn_result LIMIT 10;
2.45 ms (4.12%)	2	SELECT t0.name AS name_1, t0.code AS code_2, t0.value AS value_3, t0.clean_value AS clean_value_4, t0.id AS id_5, t0.date_add AS date_add_6, t0.date_upd AS date_upd_7, t0.deleted AS deleted_8, t0.locked AS locked_9, t0.is_draft AS is_draft_10, t0.can_be_deleted AS can_be_deleted_11, t0.owner_organization_id AS owner_organization_id_12, t0.author_id AS author_id_13, t14.lastname AS lastname_15, t14.firstname AS firstname_16, t14.birth_place AS birth_place_17, t14.birth_date AS birth_date_18, t14.gender AS gender_19, t14.id AS id_20, t14.date_add AS date_add_21, t14.date_upd AS date_upd_22, t14.deleted AS deleted_23, t14.locked AS locked_24, t14.is_draft AS is_draft_25, t14.can_be_deleted AS can_be_deleted_26, t14.owner_organization_id AS owner_organization_id_27, t14.access_id AS access_id_28, t14.author_id AS author_id_29 FROM app_core_parameter t0 LEFT JOIN app_core_user_actor t14 ON t0.author_id = t14.id WHERE t0.code = ? LIMIT 1 Parameters: [`"param.app.main.phone.number"`] View formatted query View runnable query Explain query SELECT t0.name AS name_1, t0.code AS code_2, t0.value AS value_3, t0.clean_value AS clean_value_4, t0.id AS id_5, t0.date_add AS date_add_6, t0.date_upd AS date_upd_7, t0.deleted AS deleted_8, t0.locked AS locked_9, t0.is_draft AS is_draft_10, t0.can_be_deleted AS can_be_deleted_11, t0.owner_organization_id AS owner_organization_id_12, t0.author_id AS author_id_13, t14.lastname AS lastname_15, t14.firstname AS firstname_16, t14.birth_place AS birth_place_17, t14.birth_date AS birth_date_18, t14.gender AS gender_19, t14.id AS id_20, t14.date_add AS date_add_21, t14.date_upd AS date_upd_22, t14.deleted AS deleted_23, t14.locked AS locked_24, t14.is_draft AS is_draft_25, t14.can_be_deleted AS can_be_deleted_26, t14.owner_organization_id AS owner_organization_id_27, t14.access_id AS access_id_28, t14.author_id AS author_id_29 FROM app_core_parameter t0 LEFT JOIN app_core_user_actor t14 ON t0.author_id = t14.id WHERE t0.code = ? LIMIT 1 SELECT t0.name AS name_1, t0.code AS code_2, t0.value AS value_3, t0.clean_value AS clean_value_4, t0.id AS id_5, t0.date_add AS date_add_6, t0.date_upd AS date_upd_7, t0.deleted AS deleted_8, t0.locked AS locked_9, t0.is_draft AS is_draft_10, t0.can_be_deleted AS can_be_deleted_11, t0.owner_organization_id AS owner_organization_id_12, t0.author_id AS author_id_13, t14.lastname AS lastname_15, t14.firstname AS firstname_16, t14.birth_place AS birth_place_17, t14.birth_date AS birth_date_18, t14.gender AS gender_19, t14.id AS id_20, t14.date_add AS date_add_21, t14.date_upd AS date_upd_22, t14.deleted AS deleted_23, t14.locked AS locked_24, t14.is_draft AS is_draft_25, t14.can_be_deleted AS can_be_deleted_26, t14.owner_organization_id AS owner_organization_id_27, t14.access_id AS access_id_28, t14.author_id AS author_id_29 FROM app_core_parameter t0 LEFT JOIN app_core_user_actor t14 ON t0.author_id = t14.id WHERE t0.code = 'param.app.main.phone.number' LIMIT 1;
2.34 ms (3.94%)	1	SELECT DISTINCT id_8 FROM (SELECT DISTINCT id_8, position_6 FROM (SELECT a0_.color AS color_0, a0_.bg_color AS bg_color_1, a0_.type AS type_2, a0_.target AS target_3, a0_.target_menu AS target_menu_4, a0_.client_type AS client_type_5, a0_.position AS position_6, a0_.status AS status_7, a0_.id AS id_8, a0_.date_add AS date_add_9, a0_.date_upd AS date_upd_10, a0_.deleted AS deleted_11, a0_.locked AS locked_12, a0_.is_draft AS is_draft_13, a0_.can_be_deleted AS can_be_deleted_14, a0_.owner_organization_id AS owner_organization_id_15, a1_.id AS id_16, a1_.locale AS locale_17, a1_.name AS name_18, a1_.description AS description_19, a1_.meta_description AS meta_description_20, a1_.work_keys AS work_keys_21, a1_.slug AS slug_22 FROM app_business_category a0_ INNER JOIN app_business_category_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'product' AND a0_.target_menu = 'physical_person' AND a0_.deleted = 0) dctrn_result_inner ORDER BY position_6 ASC) dctrn_result LIMIT 10 Parameters: [] View formatted query View runnable query Explain query SELECT DISTINCT id_8 FROM ( SELECT DISTINCT id_8, position_6 FROM ( SELECT a0_.color AS color_0, a0_.bg_color AS bg_color_1, a0_.type AS type_2, a0_.target AS target_3, a0_.target_menu AS target_menu_4, a0_.client_type AS client_type_5, a0_.position AS position_6, a0_.status AS status_7, a0_.id AS id_8, a0_.date_add AS date_add_9, a0_.date_upd AS date_upd_10, a0_.deleted AS deleted_11, a0_.locked AS locked_12, a0_.is_draft AS is_draft_13, a0_.can_be_deleted AS can_be_deleted_14, a0_.owner_organization_id AS owner_organization_id_15, a1_.id AS id_16, a1_.locale AS locale_17, a1_.name AS name_18, a1_.description AS description_19, a1_.meta_description AS meta_description_20, a1_.work_keys AS work_keys_21, a1_.slug AS slug_22 FROM app_business_category a0_ INNER JOIN app_business_category_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'product' AND a0_.target_menu = 'physical_person' AND a0_.deleted = 0 ) dctrn_result_inner ORDER BY position_6 ASC ) dctrn_result LIMIT 10 SELECT DISTINCT id_8 FROM (SELECT DISTINCT id_8, position_6 FROM (SELECT a0_.color AS color_0, a0_.bg_color AS bg_color_1, a0_.type AS type_2, a0_.target AS target_3, a0_.target_menu AS target_menu_4, a0_.client_type AS client_type_5, a0_.position AS position_6, a0_.status AS status_7, a0_.id AS id_8, a0_.date_add AS date_add_9, a0_.date_upd AS date_upd_10, a0_.deleted AS deleted_11, a0_.locked AS locked_12, a0_.is_draft AS is_draft_13, a0_.can_be_deleted AS can_be_deleted_14, a0_.owner_organization_id AS owner_organization_id_15, a1_.id AS id_16, a1_.locale AS locale_17, a1_.name AS name_18, a1_.description AS description_19, a1_.meta_description AS meta_description_20, a1_.work_keys AS work_keys_21, a1_.slug AS slug_22 FROM app_business_category a0_ INNER JOIN app_business_category_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'product' AND a0_.target_menu = 'physical_person' AND a0_.deleted = 0) dctrn_result_inner ORDER BY position_6 ASC) dctrn_result LIMIT 10;
1.78 ms (2.99%)	1	SELECT DISTINCT id_11 FROM (SELECT DISTINCT id_11, position_9 FROM (SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'physical_person' AND a0_.type_id IS NULL AND a0_.deleted = 0) dctrn_result_inner ORDER BY position_9 ASC) dctrn_result LIMIT 10 Parameters: [] View formatted query View runnable query Explain query SELECT DISTINCT id_11 FROM ( SELECT DISTINCT id_11, position_9 FROM ( SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'physical_person' AND a0_.type_id IS NULL AND a0_.deleted = 0 ) dctrn_result_inner ORDER BY position_9 ASC ) dctrn_result LIMIT 10 SELECT DISTINCT id_11 FROM (SELECT DISTINCT id_11, position_9 FROM (SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'physical_person' AND a0_.type_id IS NULL AND a0_.deleted = 0) dctrn_result_inner ORDER BY position_9 ASC) dctrn_result LIMIT 10;
1.78 ms (2.99%)	1	SELECT t0.sub_title AS sub_title_1, t0.id AS id_2, t0.locale AS locale_3, t0.name AS name_4, t0.description AS description_5, t0.meta_description AS meta_description_6, t0.work_keys AS work_keys_7, t0.slug AS slug_8, t0.entity_id AS entity_id_9, t10.status AS status_11, t10.target AS target_12, t10.group_type AS group_type_13, t10.target_menu AS target_menu_14, t10.client_type AS client_type_15, t10.lend_type AS lend_type_16, t10.lend_types AS lend_types_17, t10.show_in_menu AS show_in_menu_18, t10.show_title AS show_title_19, t10.position AS position_20, t10.anchor AS anchor_21, t10.id AS id_22, t10.date_add AS date_add_23, t10.date_upd AS date_upd_24, t10.deleted AS deleted_25, t10.locked AS locked_26, t10.is_draft AS is_draft_27, t10.can_be_deleted AS can_be_deleted_28, t10.owner_organization_id AS owner_organization_id_29, t10.type_id AS type_id_30, t10.parent_id AS parent_id_31, t10.thumbnail_id AS thumbnail_id_32, t10.author_id AS author_id_33 FROM app_business_product_i18n t0 INNER JOIN app_business_product t10 ON t0.entity_id = t10.id WHERE t0.entity_id = ? Parameters: [`25`] View formatted query View runnable query Explain query SELECT t0.sub_title AS sub_title_1, t0.id AS id_2, t0.locale AS locale_3, t0.name AS name_4, t0.description AS description_5, t0.meta_description AS meta_description_6, t0.work_keys AS work_keys_7, t0.slug AS slug_8, t0.entity_id AS entity_id_9, t10.status AS status_11, t10.target AS target_12, t10.group_type AS group_type_13, t10.target_menu AS target_menu_14, t10.client_type AS client_type_15, t10.lend_type AS lend_type_16, t10.lend_types AS lend_types_17, t10.show_in_menu AS show_in_menu_18, t10.show_title AS show_title_19, t10.position AS position_20, t10.anchor AS anchor_21, t10.id AS id_22, t10.date_add AS date_add_23, t10.date_upd AS date_upd_24, t10.deleted AS deleted_25, t10.locked AS locked_26, t10.is_draft AS is_draft_27, t10.can_be_deleted AS can_be_deleted_28, t10.owner_organization_id AS owner_organization_id_29, t10.type_id AS type_id_30, t10.parent_id AS parent_id_31, t10.thumbnail_id AS thumbnail_id_32, t10.author_id AS author_id_33 FROM app_business_product_i18n t0 INNER JOIN app_business_product t10 ON t0.entity_id = t10.id WHERE t0.entity_id = ? SELECT t0.sub_title AS sub_title_1, t0.id AS id_2, t0.locale AS locale_3, t0.name AS name_4, t0.description AS description_5, t0.meta_description AS meta_description_6, t0.work_keys AS work_keys_7, t0.slug AS slug_8, t0.entity_id AS entity_id_9, t10.status AS status_11, t10.target AS target_12, t10.group_type AS group_type_13, t10.target_menu AS target_menu_14, t10.client_type AS client_type_15, t10.lend_type AS lend_type_16, t10.lend_types AS lend_types_17, t10.show_in_menu AS show_in_menu_18, t10.show_title AS show_title_19, t10.position AS position_20, t10.anchor AS anchor_21, t10.id AS id_22, t10.date_add AS date_add_23, t10.date_upd AS date_upd_24, t10.deleted AS deleted_25, t10.locked AS locked_26, t10.is_draft AS is_draft_27, t10.can_be_deleted AS can_be_deleted_28, t10.owner_organization_id AS owner_organization_id_29, t10.type_id AS type_id_30, t10.parent_id AS parent_id_31, t10.thumbnail_id AS thumbnail_id_32, t10.author_id AS author_id_33 FROM app_business_product_i18n t0 INNER JOIN app_business_product t10 ON t0.entity_id = t10.id WHERE t0.entity_id = 25;
1.76 ms (2.96%)	1	SELECT a0_.class_css AS class_css_0, a0_.type AS type_1, a0_.position AS position_2, a0_.id AS id_3, a0_.date_add AS date_add_4, a0_.date_upd AS date_upd_5, a0_.deleted AS deleted_6, a0_.locked AS locked_7, a0_.is_draft AS is_draft_8, a0_.can_be_deleted AS can_be_deleted_9, a0_.owner_organization_id AS owner_organization_id_10, a1_.sub_title AS sub_title_11, a1_.id AS id_12, a1_.locale AS locale_13, a1_.name AS name_14, a1_.description AS description_15, a1_.meta_description AS meta_description_16, a1_.work_keys AS work_keys_17, a1_.slug AS slug_18, a2_.status AS status_19, a2_.target AS target_20, a2_.group_type AS group_type_21, a2_.target_menu AS target_menu_22, a2_.client_type AS client_type_23, a2_.lend_type AS lend_type_24, a2_.lend_types AS lend_types_25, a2_.show_in_menu AS show_in_menu_26, a2_.show_title AS show_title_27, a2_.position AS position_28, a2_.anchor AS anchor_29, a2_.id AS id_30, a2_.date_add AS date_add_31, a2_.date_upd AS date_upd_32, a2_.deleted AS deleted_33, a2_.locked AS locked_34, a2_.is_draft AS is_draft_35, a2_.can_be_deleted AS can_be_deleted_36, a2_.owner_organization_id AS owner_organization_id_37, a3_.is_downloaded AS is_downloaded_38, a3_.is_show_page AS is_show_page_39, a3_.code AS code_40, a3_.type AS type_41, a3_.status AS status_42, a3_.id AS id_43, a3_.date_add AS date_add_44, a3_.date_upd AS date_upd_45, a3_.deleted AS deleted_46, a3_.locked AS locked_47, a3_.is_draft AS is_draft_48, a3_.can_be_deleted AS can_be_deleted_49, a3_.owner_organization_id AS owner_organization_id_50, a0_.thumbnail_id AS thumbnail_id_51, a0_.product_id AS product_id_52, a0_.cms_page_id AS cms_page_id_53, a0_.author_id AS author_id_54, a1_.entity_id AS entity_id_55, a2_.type_id AS type_id_56, a2_.parent_id AS parent_id_57, a2_.thumbnail_id AS thumbnail_id_58, a2_.author_id AS author_id_59, a3_.attachment_id AS attachment_id_60, a3_.author_id AS author_id_61 FROM app_blog_page_section a0_ INNER JOIN app_blog_page_section_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_product a2_ ON a0_.product_id = a2_.id LEFT JOIN app_core_cms_page a3_ ON a0_.cms_page_id = a3_.id WHERE a0_.deleted = 0 AND a2_.id = '25' AND a0_.deleted = 0 AND a0_.id IN (?, ?, ?, ?) ORDER BY a0_.position ASC Parameters: [`72 73 74 75`] View formatted query View runnable query Explain query SELECT a0_.class_css AS class_css_0, a0_.type AS type_1, a0_.position AS position_2, a0_.id AS id_3, a0_.date_add AS date_add_4, a0_.date_upd AS date_upd_5, a0_.deleted AS deleted_6, a0_.locked AS locked_7, a0_.is_draft AS is_draft_8, a0_.can_be_deleted AS can_be_deleted_9, a0_.owner_organization_id AS owner_organization_id_10, a1_.sub_title AS sub_title_11, a1_.id AS id_12, a1_.locale AS locale_13, a1_.name AS name_14, a1_.description AS description_15, a1_.meta_description AS meta_description_16, a1_.work_keys AS work_keys_17, a1_.slug AS slug_18, a2_.status AS status_19, a2_.target AS target_20, a2_.group_type AS group_type_21, a2_.target_menu AS target_menu_22, a2_.client_type AS client_type_23, a2_.lend_type AS lend_type_24, a2_.lend_types AS lend_types_25, a2_.show_in_menu AS show_in_menu_26, a2_.show_title AS show_title_27, a2_.position AS position_28, a2_.anchor AS anchor_29, a2_.id AS id_30, a2_.date_add AS date_add_31, a2_.date_upd AS date_upd_32, a2_.deleted AS deleted_33, a2_.locked AS locked_34, a2_.is_draft AS is_draft_35, a2_.can_be_deleted AS can_be_deleted_36, a2_.owner_organization_id AS owner_organization_id_37, a3_.is_downloaded AS is_downloaded_38, a3_.is_show_page AS is_show_page_39, a3_.code AS code_40, a3_.type AS type_41, a3_.status AS status_42, a3_.id AS id_43, a3_.date_add AS date_add_44, a3_.date_upd AS date_upd_45, a3_.deleted AS deleted_46, a3_.locked AS locked_47, a3_.is_draft AS is_draft_48, a3_.can_be_deleted AS can_be_deleted_49, a3_.owner_organization_id AS owner_organization_id_50, a0_.thumbnail_id AS thumbnail_id_51, a0_.product_id AS product_id_52, a0_.cms_page_id AS cms_page_id_53, a0_.author_id AS author_id_54, a1_.entity_id AS entity_id_55, a2_.type_id AS type_id_56, a2_.parent_id AS parent_id_57, a2_.thumbnail_id AS thumbnail_id_58, a2_.author_id AS author_id_59, a3_.attachment_id AS attachment_id_60, a3_.author_id AS author_id_61 FROM app_blog_page_section a0_ INNER JOIN app_blog_page_section_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_product a2_ ON a0_.product_id = a2_.id LEFT JOIN app_core_cms_page a3_ ON a0_.cms_page_id = a3_.id WHERE a0_.deleted = 0 AND a2_.id = '25' AND a0_.deleted = 0 AND a0_.id IN (?, ?, ?, ?) ORDER BY a0_.position ASC SELECT a0_.class_css AS class_css_0, a0_.type AS type_1, a0_.position AS position_2, a0_.id AS id_3, a0_.date_add AS date_add_4, a0_.date_upd AS date_upd_5, a0_.deleted AS deleted_6, a0_.locked AS locked_7, a0_.is_draft AS is_draft_8, a0_.can_be_deleted AS can_be_deleted_9, a0_.owner_organization_id AS owner_organization_id_10, a1_.sub_title AS sub_title_11, a1_.id AS id_12, a1_.locale AS locale_13, a1_.name AS name_14, a1_.description AS description_15, a1_.meta_description AS meta_description_16, a1_.work_keys AS work_keys_17, a1_.slug AS slug_18, a2_.status AS status_19, a2_.target AS target_20, a2_.group_type AS group_type_21, a2_.target_menu AS target_menu_22, a2_.client_type AS client_type_23, a2_.lend_type AS lend_type_24, a2_.lend_types AS lend_types_25, a2_.show_in_menu AS show_in_menu_26, a2_.show_title AS show_title_27, a2_.position AS position_28, a2_.anchor AS anchor_29, a2_.id AS id_30, a2_.date_add AS date_add_31, a2_.date_upd AS date_upd_32, a2_.deleted AS deleted_33, a2_.locked AS locked_34, a2_.is_draft AS is_draft_35, a2_.can_be_deleted AS can_be_deleted_36, a2_.owner_organization_id AS owner_organization_id_37, a3_.is_downloaded AS is_downloaded_38, a3_.is_show_page AS is_show_page_39, a3_.code AS code_40, a3_.type AS type_41, a3_.status AS status_42, a3_.id AS id_43, a3_.date_add AS date_add_44, a3_.date_upd AS date_upd_45, a3_.deleted AS deleted_46, a3_.locked AS locked_47, a3_.is_draft AS is_draft_48, a3_.can_be_deleted AS can_be_deleted_49, a3_.owner_organization_id AS owner_organization_id_50, a0_.thumbnail_id AS thumbnail_id_51, a0_.product_id AS product_id_52, a0_.cms_page_id AS cms_page_id_53, a0_.author_id AS author_id_54, a1_.entity_id AS entity_id_55, a2_.type_id AS type_id_56, a2_.parent_id AS parent_id_57, a2_.thumbnail_id AS thumbnail_id_58, a2_.author_id AS author_id_59, a3_.attachment_id AS attachment_id_60, a3_.author_id AS author_id_61 FROM app_blog_page_section a0_ INNER JOIN app_blog_page_section_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_product a2_ ON a0_.product_id = a2_.id LEFT JOIN app_core_cms_page a3_ ON a0_.cms_page_id = a3_.id WHERE a0_.deleted = 0 AND a2_.id = '25' AND a0_.deleted = 0 AND a0_.id IN (72, 73, 74, 75) ORDER BY a0_.position ASC;
1.27 ms (2.13%)	1	SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42, a0_.type_id AS type_id_43, a0_.parent_id AS parent_id_44, a0_.thumbnail_id AS thumbnail_id_45, a0_.author_id AS author_id_46, a1_.entity_id AS entity_id_47, a2_.author_id AS author_id_48 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'physical_person' AND a0_.type_id IS NULL AND a0_.deleted = 0 AND a0_.id IN (?) ORDER BY a0_.position ASC Parameters: [`23`] View formatted query View runnable query Explain query SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42, a0_.type_id AS type_id_43, a0_.parent_id AS parent_id_44, a0_.thumbnail_id AS thumbnail_id_45, a0_.author_id AS author_id_46, a1_.entity_id AS entity_id_47, a2_.author_id AS author_id_48 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'physical_person' AND a0_.type_id IS NULL AND a0_.deleted = 0 AND a0_.id IN (?) ORDER BY a0_.position ASC SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42, a0_.type_id AS type_id_43, a0_.parent_id AS parent_id_44, a0_.thumbnail_id AS thumbnail_id_45, a0_.author_id AS author_id_46, a1_.entity_id AS entity_id_47, a2_.author_id AS author_id_48 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'physical_person' AND a0_.type_id IS NULL AND a0_.deleted = 0 AND a0_.id IN (23) ORDER BY a0_.position ASC;
0.92 ms (1.54%)	1	SELECT t0.status AS status_1, t0.target AS target_2, t0.group_type AS group_type_3, t0.target_menu AS target_menu_4, t0.client_type AS client_type_5, t0.lend_type AS lend_type_6, t0.lend_types AS lend_types_7, t0.show_in_menu AS show_in_menu_8, t0.show_title AS show_title_9, t0.position AS position_10, t0.anchor AS anchor_11, t0.id AS id_12, t0.date_add AS date_add_13, t0.date_upd AS date_upd_14, t0.deleted AS deleted_15, t0.locked AS locked_16, t0.is_draft AS is_draft_17, t0.can_be_deleted AS can_be_deleted_18, t0.owner_organization_id AS owner_organization_id_19, t0.type_id AS type_id_20, t21.color AS color_22, t21.bg_color AS bg_color_23, t21.type AS type_24, t21.target AS target_25, t21.target_menu AS target_menu_26, t21.client_type AS client_type_27, t21.position AS position_28, t21.status AS status_29, t21.id AS id_30, t21.date_add AS date_add_31, t21.date_upd AS date_upd_32, t21.deleted AS deleted_33, t21.locked AS locked_34, t21.is_draft AS is_draft_35, t21.can_be_deleted AS can_be_deleted_36, t21.owner_organization_id AS owner_organization_id_37, t21.author_id AS author_id_38, t0.parent_id AS parent_id_39, t40.status AS status_41, t40.target AS target_42, t40.group_type AS group_type_43, t40.target_menu AS target_menu_44, t40.client_type AS client_type_45, t40.lend_type AS lend_type_46, t40.lend_types AS lend_types_47, t40.show_in_menu AS show_in_menu_48, t40.show_title AS show_title_49, t40.position AS position_50, t40.anchor AS anchor_51, t40.id AS id_52, t40.date_add AS date_add_53, t40.date_upd AS date_upd_54, t40.deleted AS deleted_55, t40.locked AS locked_56, t40.is_draft AS is_draft_57, t40.can_be_deleted AS can_be_deleted_58, t40.owner_organization_id AS owner_organization_id_59, t40.type_id AS type_id_60, t40.parent_id AS parent_id_61, t40.thumbnail_id AS thumbnail_id_62, t40.author_id AS author_id_63, t0.thumbnail_id AS thumbnail_id_64, t65.filename AS filename_66, t65.original_name AS original_name_67, t65.mime_type AS mime_type_68, t65.extension AS extension_69, t65.size AS size_70, t65.url AS url_71, t65.id AS id_72, t65.date_add AS date_add_73, t65.date_upd AS date_upd_74, t65.deleted AS deleted_75, t65.locked AS locked_76, t65.is_draft AS is_draft_77, t65.can_be_deleted AS can_be_deleted_78, t65.owner_organization_id AS owner_organization_id_79, t65.author_id AS author_id_80, t0.author_id AS author_id_81, t82.lastname AS lastname_83, t82.firstname AS firstname_84, t82.birth_place AS birth_place_85, t82.birth_date AS birth_date_86, t82.gender AS gender_87, t82.id AS id_88, t82.date_add AS date_add_89, t82.date_upd AS date_upd_90, t82.deleted AS deleted_91, t82.locked AS locked_92, t82.is_draft AS is_draft_93, t82.can_be_deleted AS can_be_deleted_94, t82.owner_organization_id AS owner_organization_id_95, t82.access_id AS access_id_96, t82.author_id AS author_id_97 FROM app_business_product t0 LEFT JOIN app_business_category t21 ON t0.type_id = t21.id LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id WHERE t0.parent_id IN (?, ?) Parameters: [`41 26`] View formatted query View runnable query Explain query SELECT t0.status AS status_1, t0.target AS target_2, t0.group_type AS group_type_3, t0.target_menu AS target_menu_4, t0.client_type AS client_type_5, t0.lend_type AS lend_type_6, t0.lend_types AS lend_types_7, t0.show_in_menu AS show_in_menu_8, t0.show_title AS show_title_9, t0.position AS position_10, t0.anchor AS anchor_11, t0.id AS id_12, t0.date_add AS date_add_13, t0.date_upd AS date_upd_14, t0.deleted AS deleted_15, t0.locked AS locked_16, t0.is_draft AS is_draft_17, t0.can_be_deleted AS can_be_deleted_18, t0.owner_organization_id AS owner_organization_id_19, t0.type_id AS type_id_20, t21.color AS color_22, t21.bg_color AS bg_color_23, t21.type AS type_24, t21.target AS target_25, t21.target_menu AS target_menu_26, t21.client_type AS client_type_27, t21.position AS position_28, t21.status AS status_29, t21.id AS id_30, t21.date_add AS date_add_31, t21.date_upd AS date_upd_32, t21.deleted AS deleted_33, t21.locked AS locked_34, t21.is_draft AS is_draft_35, t21.can_be_deleted AS can_be_deleted_36, t21.owner_organization_id AS owner_organization_id_37, t21.author_id AS author_id_38, t0.parent_id AS parent_id_39, t40.status AS status_41, t40.target AS target_42, t40.group_type AS group_type_43, t40.target_menu AS target_menu_44, t40.client_type AS client_type_45, t40.lend_type AS lend_type_46, t40.lend_types AS lend_types_47, t40.show_in_menu AS show_in_menu_48, t40.show_title AS show_title_49, t40.position AS position_50, t40.anchor AS anchor_51, t40.id AS id_52, t40.date_add AS date_add_53, t40.date_upd AS date_upd_54, t40.deleted AS deleted_55, t40.locked AS locked_56, t40.is_draft AS is_draft_57, t40.can_be_deleted AS can_be_deleted_58, t40.owner_organization_id AS owner_organization_id_59, t40.type_id AS type_id_60, t40.parent_id AS parent_id_61, t40.thumbnail_id AS thumbnail_id_62, t40.author_id AS author_id_63, t0.thumbnail_id AS thumbnail_id_64, t65.filename AS filename_66, t65.original_name AS original_name_67, t65.mime_type AS mime_type_68, t65.extension AS extension_69, t65.size AS size_70, t65.url AS url_71, t65.id AS id_72, t65.date_add AS date_add_73, t65.date_upd AS date_upd_74, t65.deleted AS deleted_75, t65.locked AS locked_76, t65.is_draft AS is_draft_77, t65.can_be_deleted AS can_be_deleted_78, t65.owner_organization_id AS owner_organization_id_79, t65.author_id AS author_id_80, t0.author_id AS author_id_81, t82.lastname AS lastname_83, t82.firstname AS firstname_84, t82.birth_place AS birth_place_85, t82.birth_date AS birth_date_86, t82.gender AS gender_87, t82.id AS id_88, t82.date_add AS date_add_89, t82.date_upd AS date_upd_90, t82.deleted AS deleted_91, t82.locked AS locked_92, t82.is_draft AS is_draft_93, t82.can_be_deleted AS can_be_deleted_94, t82.owner_organization_id AS owner_organization_id_95, t82.access_id AS access_id_96, t82.author_id AS author_id_97 FROM app_business_product t0 LEFT JOIN app_business_category t21 ON t0.type_id = t21.id LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id WHERE t0.parent_id IN (?, ?) SELECT t0.status AS status_1, t0.target AS target_2, t0.group_type AS group_type_3, t0.target_menu AS target_menu_4, t0.client_type AS client_type_5, t0.lend_type AS lend_type_6, t0.lend_types AS lend_types_7, t0.show_in_menu AS show_in_menu_8, t0.show_title AS show_title_9, t0.position AS position_10, t0.anchor AS anchor_11, t0.id AS id_12, t0.date_add AS date_add_13, t0.date_upd AS date_upd_14, t0.deleted AS deleted_15, t0.locked AS locked_16, t0.is_draft AS is_draft_17, t0.can_be_deleted AS can_be_deleted_18, t0.owner_organization_id AS owner_organization_id_19, t0.type_id AS type_id_20, t21.color AS color_22, t21.bg_color AS bg_color_23, t21.type AS type_24, t21.target AS target_25, t21.target_menu AS target_menu_26, t21.client_type AS client_type_27, t21.position AS position_28, t21.status AS status_29, t21.id AS id_30, t21.date_add AS date_add_31, t21.date_upd AS date_upd_32, t21.deleted AS deleted_33, t21.locked AS locked_34, t21.is_draft AS is_draft_35, t21.can_be_deleted AS can_be_deleted_36, t21.owner_organization_id AS owner_organization_id_37, t21.author_id AS author_id_38, t0.parent_id AS parent_id_39, t40.status AS status_41, t40.target AS target_42, t40.group_type AS group_type_43, t40.target_menu AS target_menu_44, t40.client_type AS client_type_45, t40.lend_type AS lend_type_46, t40.lend_types AS lend_types_47, t40.show_in_menu AS show_in_menu_48, t40.show_title AS show_title_49, t40.position AS position_50, t40.anchor AS anchor_51, t40.id AS id_52, t40.date_add AS date_add_53, t40.date_upd AS date_upd_54, t40.deleted AS deleted_55, t40.locked AS locked_56, t40.is_draft AS is_draft_57, t40.can_be_deleted AS can_be_deleted_58, t40.owner_organization_id AS owner_organization_id_59, t40.type_id AS type_id_60, t40.parent_id AS parent_id_61, t40.thumbnail_id AS thumbnail_id_62, t40.author_id AS author_id_63, t0.thumbnail_id AS thumbnail_id_64, t65.filename AS filename_66, t65.original_name AS original_name_67, t65.mime_type AS mime_type_68, t65.extension AS extension_69, t65.size AS size_70, t65.url AS url_71, t65.id AS id_72, t65.date_add AS date_add_73, t65.date_upd AS date_upd_74, t65.deleted AS deleted_75, t65.locked AS locked_76, t65.is_draft AS is_draft_77, t65.can_be_deleted AS can_be_deleted_78, t65.owner_organization_id AS owner_organization_id_79, t65.author_id AS author_id_80, t0.author_id AS author_id_81, t82.lastname AS lastname_83, t82.firstname AS firstname_84, t82.birth_place AS birth_place_85, t82.birth_date AS birth_date_86, t82.gender AS gender_87, t82.id AS id_88, t82.date_add AS date_add_89, t82.date_upd AS date_upd_90, t82.deleted AS deleted_91, t82.locked AS locked_92, t82.is_draft AS is_draft_93, t82.can_be_deleted AS can_be_deleted_94, t82.owner_organization_id AS owner_organization_id_95, t82.access_id AS access_id_96, t82.author_id AS author_id_97 FROM app_business_product t0 LEFT JOIN app_business_category t21 ON t0.type_id = t21.id LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id WHERE t0.parent_id IN (41, 26);
0.76 ms (1.28%)	1	SELECT DISTINCT id_11 FROM (SELECT DISTINCT id_11, position_9 FROM (SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'bank_insurance' AND a0_.type_id IS NULL AND a0_.deleted = 0) dctrn_result_inner ORDER BY position_9 ASC) dctrn_result LIMIT 10 Parameters: [] View formatted query View runnable query Explain query SELECT DISTINCT id_11 FROM ( SELECT DISTINCT id_11, position_9 FROM ( SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'bank_insurance' AND a0_.type_id IS NULL AND a0_.deleted = 0 ) dctrn_result_inner ORDER BY position_9 ASC ) dctrn_result LIMIT 10 SELECT DISTINCT id_11 FROM (SELECT DISTINCT id_11, position_9 FROM (SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'bank_insurance' AND a0_.type_id IS NULL AND a0_.deleted = 0) dctrn_result_inner ORDER BY position_9 ASC) dctrn_result LIMIT 10;
0.75 ms (1.26%)	1	SELECT COUNT() AS dctrn_count FROM (SELECT DISTINCT id_6 FROM (SELECT a0_.name AS name_0, a0_.url AS url_1, a0_.description AS description_2, a0_.type AS type_3, a0_.position AS position_4, a0_.status AS status_5, a0_.id AS id_6, a0_.date_add AS date_add_7, a0_.date_upd AS date_upd_8, a0_.deleted AS deleted_9, a0_.locked AS locked_10, a0_.is_draft AS is_draft_11, a0_.can_be_deleted AS can_be_deleted_12, a0_.owner_organization_id AS owner_organization_id_13, a1_.id AS id_14, a1_.locale AS locale_15, a1_.name AS name_16, a1_.description AS description_17, a1_.meta_description AS meta_description_18, a1_.work_keys AS work_keys_19, a1_.slug AS slug_20 FROM app_business_website a0_ INNER JOIN app_business_website_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'url' AND a0_.deleted = 0 ORDER BY a0_.position ASC) dctrn_result) dctrn_table Parameters: [] View formatted query View runnable query Explain query SELECT COUNT() AS dctrn_count FROM ( SELECT DISTINCT id_6 FROM ( SELECT a0_.name AS name_0, a0_.url AS url_1, a0_.description AS description_2, a0_.type AS type_3, a0_.position AS position_4, a0_.status AS status_5, a0_.id AS id_6, a0_.date_add AS date_add_7, a0_.date_upd AS date_upd_8, a0_.deleted AS deleted_9, a0_.locked AS locked_10, a0_.is_draft AS is_draft_11, a0_.can_be_deleted AS can_be_deleted_12, a0_.owner_organization_id AS owner_organization_id_13, a1_.id AS id_14, a1_.locale AS locale_15, a1_.name AS name_16, a1_.description AS description_17, a1_.meta_description AS meta_description_18, a1_.work_keys AS work_keys_19, a1_.slug AS slug_20 FROM app_business_website a0_ INNER JOIN app_business_website_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'url' AND a0_.deleted = 0 ORDER BY a0_.position ASC ) dctrn_result ) dctrn_table SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_6 FROM (SELECT a0_.name AS name_0, a0_.url AS url_1, a0_.description AS description_2, a0_.type AS type_3, a0_.position AS position_4, a0_.status AS status_5, a0_.id AS id_6, a0_.date_add AS date_add_7, a0_.date_upd AS date_upd_8, a0_.deleted AS deleted_9, a0_.locked AS locked_10, a0_.is_draft AS is_draft_11, a0_.can_be_deleted AS can_be_deleted_12, a0_.owner_organization_id AS owner_organization_id_13, a1_.id AS id_14, a1_.locale AS locale_15, a1_.name AS name_16, a1_.description AS description_17, a1_.meta_description AS meta_description_18, a1_.work_keys AS work_keys_19, a1_.slug AS slug_20 FROM app_business_website a0_ INNER JOIN app_business_website_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'url' AND a0_.deleted = 0 ORDER BY a0_.position ASC) dctrn_result) dctrn_table;
0.69 ms (1.16%)	1	SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42, a0_.type_id AS type_id_43, a0_.parent_id AS parent_id_44, a0_.thumbnail_id AS thumbnail_id_45, a0_.author_id AS author_id_46, a1_.entity_id AS entity_id_47, a2_.author_id AS author_id_48 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'bank_insurance' AND a0_.type_id IS NULL AND a0_.deleted = 0 AND a0_.id IN (?, ?, ?, ?, ?, ?) ORDER BY a0_.position ASC Parameters: [`29 30 19 20 21 22`] View formatted query View runnable query Explain query SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42, a0_.type_id AS type_id_43, a0_.parent_id AS parent_id_44, a0_.thumbnail_id AS thumbnail_id_45, a0_.author_id AS author_id_46, a1_.entity_id AS entity_id_47, a2_.author_id AS author_id_48 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'bank_insurance' AND a0_.type_id IS NULL AND a0_.deleted = 0 AND a0_.id IN (?, ?, ?, ?, ?, ?) ORDER BY a0_.position ASC SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42, a0_.type_id AS type_id_43, a0_.parent_id AS parent_id_44, a0_.thumbnail_id AS thumbnail_id_45, a0_.author_id AS author_id_46, a1_.entity_id AS entity_id_47, a2_.author_id AS author_id_48 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'bank_insurance' AND a0_.type_id IS NULL AND a0_.deleted = 0 AND a0_.id IN (29, 30, 19, 20, 21, 22) ORDER BY a0_.position ASC;
0.67 ms (1.13%)	1	SELECT COUNT() AS dctrn_count FROM (SELECT DISTINCT id_11 FROM (SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'physical_person' AND a0_.type_id IS NULL AND a0_.deleted = 0 ORDER BY a0_.position ASC) dctrn_result) dctrn_table Parameters: [] View formatted query View runnable query Explain query SELECT COUNT() AS dctrn_count FROM ( SELECT DISTINCT id_11 FROM ( SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'physical_person' AND a0_.type_id IS NULL AND a0_.deleted = 0 ORDER BY a0_.position ASC ) dctrn_result ) dctrn_table SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_11 FROM (SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'physical_person' AND a0_.type_id IS NULL AND a0_.deleted = 0 ORDER BY a0_.position ASC) dctrn_result) dctrn_table;
0.64 ms (1.08%)	1	SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42, a0_.type_id AS type_id_43, a0_.parent_id AS parent_id_44, a0_.thumbnail_id AS thumbnail_id_45, a0_.author_id AS author_id_46, a1_.entity_id AS entity_id_47, a2_.author_id AS author_id_48 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'moral_person' AND a0_.type_id IS NULL AND a0_.deleted = 0 AND a0_.id IN (?, ?, ?) ORDER BY a0_.position ASC Parameters: [`41 25 26`] View formatted query View runnable query Explain query SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42, a0_.type_id AS type_id_43, a0_.parent_id AS parent_id_44, a0_.thumbnail_id AS thumbnail_id_45, a0_.author_id AS author_id_46, a1_.entity_id AS entity_id_47, a2_.author_id AS author_id_48 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'moral_person' AND a0_.type_id IS NULL AND a0_.deleted = 0 AND a0_.id IN (?, ?, ?) ORDER BY a0_.position ASC SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42, a0_.type_id AS type_id_43, a0_.parent_id AS parent_id_44, a0_.thumbnail_id AS thumbnail_id_45, a0_.author_id AS author_id_46, a1_.entity_id AS entity_id_47, a2_.author_id AS author_id_48 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'moral_person' AND a0_.type_id IS NULL AND a0_.deleted = 0 AND a0_.id IN (41, 25, 26) ORDER BY a0_.position ASC;
0.63 ms (1.06%)	1	SELECT COUNT() AS dctrn_count FROM (SELECT DISTINCT id_8 FROM (SELECT a0_.color AS color_0, a0_.bg_color AS bg_color_1, a0_.type AS type_2, a0_.target AS target_3, a0_.target_menu AS target_menu_4, a0_.client_type AS client_type_5, a0_.position AS position_6, a0_.status AS status_7, a0_.id AS id_8, a0_.date_add AS date_add_9, a0_.date_upd AS date_upd_10, a0_.deleted AS deleted_11, a0_.locked AS locked_12, a0_.is_draft AS is_draft_13, a0_.can_be_deleted AS can_be_deleted_14, a0_.owner_organization_id AS owner_organization_id_15, a1_.id AS id_16, a1_.locale AS locale_17, a1_.name AS name_18, a1_.description AS description_19, a1_.meta_description AS meta_description_20, a1_.work_keys AS work_keys_21, a1_.slug AS slug_22 FROM app_business_category a0_ INNER JOIN app_business_category_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'product' AND a0_.target_menu = 'physical_person' AND a0_.deleted = 0 ORDER BY a0_.position ASC) dctrn_result) dctrn_table Parameters: [] View formatted query View runnable query Explain query SELECT COUNT() AS dctrn_count FROM ( SELECT DISTINCT id_8 FROM ( SELECT a0_.color AS color_0, a0_.bg_color AS bg_color_1, a0_.type AS type_2, a0_.target AS target_3, a0_.target_menu AS target_menu_4, a0_.client_type AS client_type_5, a0_.position AS position_6, a0_.status AS status_7, a0_.id AS id_8, a0_.date_add AS date_add_9, a0_.date_upd AS date_upd_10, a0_.deleted AS deleted_11, a0_.locked AS locked_12, a0_.is_draft AS is_draft_13, a0_.can_be_deleted AS can_be_deleted_14, a0_.owner_organization_id AS owner_organization_id_15, a1_.id AS id_16, a1_.locale AS locale_17, a1_.name AS name_18, a1_.description AS description_19, a1_.meta_description AS meta_description_20, a1_.work_keys AS work_keys_21, a1_.slug AS slug_22 FROM app_business_category a0_ INNER JOIN app_business_category_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'product' AND a0_.target_menu = 'physical_person' AND a0_.deleted = 0 ORDER BY a0_.position ASC ) dctrn_result ) dctrn_table SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_8 FROM (SELECT a0_.color AS color_0, a0_.bg_color AS bg_color_1, a0_.type AS type_2, a0_.target AS target_3, a0_.target_menu AS target_menu_4, a0_.client_type AS client_type_5, a0_.position AS position_6, a0_.status AS status_7, a0_.id AS id_8, a0_.date_add AS date_add_9, a0_.date_upd AS date_upd_10, a0_.deleted AS deleted_11, a0_.locked AS locked_12, a0_.is_draft AS is_draft_13, a0_.can_be_deleted AS can_be_deleted_14, a0_.owner_organization_id AS owner_organization_id_15, a1_.id AS id_16, a1_.locale AS locale_17, a1_.name AS name_18, a1_.description AS description_19, a1_.meta_description AS meta_description_20, a1_.work_keys AS work_keys_21, a1_.slug AS slug_22 FROM app_business_category a0_ INNER JOIN app_business_category_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'product' AND a0_.target_menu = 'physical_person' AND a0_.deleted = 0 ORDER BY a0_.position ASC) dctrn_result) dctrn_table;
0.58 ms (0.97%)	1	SELECT COUNT() AS dctrn_count FROM (SELECT DISTINCT id_3 FROM (SELECT a0_.class_css AS class_css_0, a0_.type AS type_1, a0_.position AS position_2, a0_.id AS id_3, a0_.date_add AS date_add_4, a0_.date_upd AS date_upd_5, a0_.deleted AS deleted_6, a0_.locked AS locked_7, a0_.is_draft AS is_draft_8, a0_.can_be_deleted AS can_be_deleted_9, a0_.owner_organization_id AS owner_organization_id_10, a1_.sub_title AS sub_title_11, a1_.id AS id_12, a1_.locale AS locale_13, a1_.name AS name_14, a1_.description AS description_15, a1_.meta_description AS meta_description_16, a1_.work_keys AS work_keys_17, a1_.slug AS slug_18, a2_.status AS status_19, a2_.target AS target_20, a2_.group_type AS group_type_21, a2_.target_menu AS target_menu_22, a2_.client_type AS client_type_23, a2_.lend_type AS lend_type_24, a2_.lend_types AS lend_types_25, a2_.show_in_menu AS show_in_menu_26, a2_.show_title AS show_title_27, a2_.position AS position_28, a2_.anchor AS anchor_29, a2_.id AS id_30, a2_.date_add AS date_add_31, a2_.date_upd AS date_upd_32, a2_.deleted AS deleted_33, a2_.locked AS locked_34, a2_.is_draft AS is_draft_35, a2_.can_be_deleted AS can_be_deleted_36, a2_.owner_organization_id AS owner_organization_id_37, a3_.is_downloaded AS is_downloaded_38, a3_.is_show_page AS is_show_page_39, a3_.code AS code_40, a3_.type AS type_41, a3_.status AS status_42, a3_.id AS id_43, a3_.date_add AS date_add_44, a3_.date_upd AS date_upd_45, a3_.deleted AS deleted_46, a3_.locked AS locked_47, a3_.is_draft AS is_draft_48, a3_.can_be_deleted AS can_be_deleted_49, a3_.owner_organization_id AS owner_organization_id_50 FROM app_blog_page_section a0_ INNER JOIN app_blog_page_section_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_product a2_ ON a0_.product_id = a2_.id LEFT JOIN app_core_cms_page a3_ ON a0_.cms_page_id = a3_.id WHERE a0_.deleted = 0 AND a2_.id = '25' AND a0_.deleted = 0 ORDER BY a0_.position ASC) dctrn_result) dctrn_table Parameters: [] View formatted query View runnable query Explain query SELECT COUNT() AS dctrn_count FROM ( SELECT DISTINCT id_3 FROM ( SELECT a0_.class_css AS class_css_0, a0_.type AS type_1, a0_.position AS position_2, a0_.id AS id_3, a0_.date_add AS date_add_4, a0_.date_upd AS date_upd_5, a0_.deleted AS deleted_6, a0_.locked AS locked_7, a0_.is_draft AS is_draft_8, a0_.can_be_deleted AS can_be_deleted_9, a0_.owner_organization_id AS owner_organization_id_10, a1_.sub_title AS sub_title_11, a1_.id AS id_12, a1_.locale AS locale_13, a1_.name AS name_14, a1_.description AS description_15, a1_.meta_description AS meta_description_16, a1_.work_keys AS work_keys_17, a1_.slug AS slug_18, a2_.status AS status_19, a2_.target AS target_20, a2_.group_type AS group_type_21, a2_.target_menu AS target_menu_22, a2_.client_type AS client_type_23, a2_.lend_type AS lend_type_24, a2_.lend_types AS lend_types_25, a2_.show_in_menu AS show_in_menu_26, a2_.show_title AS show_title_27, a2_.position AS position_28, a2_.anchor AS anchor_29, a2_.id AS id_30, a2_.date_add AS date_add_31, a2_.date_upd AS date_upd_32, a2_.deleted AS deleted_33, a2_.locked AS locked_34, a2_.is_draft AS is_draft_35, a2_.can_be_deleted AS can_be_deleted_36, a2_.owner_organization_id AS owner_organization_id_37, a3_.is_downloaded AS is_downloaded_38, a3_.is_show_page AS is_show_page_39, a3_.code AS code_40, a3_.type AS type_41, a3_.status AS status_42, a3_.id AS id_43, a3_.date_add AS date_add_44, a3_.date_upd AS date_upd_45, a3_.deleted AS deleted_46, a3_.locked AS locked_47, a3_.is_draft AS is_draft_48, a3_.can_be_deleted AS can_be_deleted_49, a3_.owner_organization_id AS owner_organization_id_50 FROM app_blog_page_section a0_ INNER JOIN app_blog_page_section_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_product a2_ ON a0_.product_id = a2_.id LEFT JOIN app_core_cms_page a3_ ON a0_.cms_page_id = a3_.id WHERE a0_.deleted = 0 AND a2_.id = '25' AND a0_.deleted = 0 ORDER BY a0_.position ASC ) dctrn_result ) dctrn_table SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_3 FROM (SELECT a0_.class_css AS class_css_0, a0_.type AS type_1, a0_.position AS position_2, a0_.id AS id_3, a0_.date_add AS date_add_4, a0_.date_upd AS date_upd_5, a0_.deleted AS deleted_6, a0_.locked AS locked_7, a0_.is_draft AS is_draft_8, a0_.can_be_deleted AS can_be_deleted_9, a0_.owner_organization_id AS owner_organization_id_10, a1_.sub_title AS sub_title_11, a1_.id AS id_12, a1_.locale AS locale_13, a1_.name AS name_14, a1_.description AS description_15, a1_.meta_description AS meta_description_16, a1_.work_keys AS work_keys_17, a1_.slug AS slug_18, a2_.status AS status_19, a2_.target AS target_20, a2_.group_type AS group_type_21, a2_.target_menu AS target_menu_22, a2_.client_type AS client_type_23, a2_.lend_type AS lend_type_24, a2_.lend_types AS lend_types_25, a2_.show_in_menu AS show_in_menu_26, a2_.show_title AS show_title_27, a2_.position AS position_28, a2_.anchor AS anchor_29, a2_.id AS id_30, a2_.date_add AS date_add_31, a2_.date_upd AS date_upd_32, a2_.deleted AS deleted_33, a2_.locked AS locked_34, a2_.is_draft AS is_draft_35, a2_.can_be_deleted AS can_be_deleted_36, a2_.owner_organization_id AS owner_organization_id_37, a3_.is_downloaded AS is_downloaded_38, a3_.is_show_page AS is_show_page_39, a3_.code AS code_40, a3_.type AS type_41, a3_.status AS status_42, a3_.id AS id_43, a3_.date_add AS date_add_44, a3_.date_upd AS date_upd_45, a3_.deleted AS deleted_46, a3_.locked AS locked_47, a3_.is_draft AS is_draft_48, a3_.can_be_deleted AS can_be_deleted_49, a3_.owner_organization_id AS owner_organization_id_50 FROM app_blog_page_section a0_ INNER JOIN app_blog_page_section_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_product a2_ ON a0_.product_id = a2_.id LEFT JOIN app_core_cms_page a3_ ON a0_.cms_page_id = a3_.id WHERE a0_.deleted = 0 AND a2_.id = '25' AND a0_.deleted = 0 ORDER BY a0_.position ASC) dctrn_result) dctrn_table;
0.57 ms (0.96%)	1	SELECT t0.filename AS filename_1, t0.original_name AS original_name_2, t0.mime_type AS mime_type_3, t0.extension AS extension_4, t0.size AS size_5, t0.url AS url_6, t0.id AS id_7, t0.date_add AS date_add_8, t0.date_upd AS date_upd_9, t0.deleted AS deleted_10, t0.locked AS locked_11, t0.is_draft AS is_draft_12, t0.can_be_deleted AS can_be_deleted_13, t0.owner_organization_id AS owner_organization_id_14, t0.author_id AS author_id_15, t16.lastname AS lastname_17, t16.firstname AS firstname_18, t16.birth_place AS birth_place_19, t16.birth_date AS birth_date_20, t16.gender AS gender_21, t16.id AS id_22, t16.date_add AS date_add_23, t16.date_upd AS date_upd_24, t16.deleted AS deleted_25, t16.locked AS locked_26, t16.is_draft AS is_draft_27, t16.can_be_deleted AS can_be_deleted_28, t16.owner_organization_id AS owner_organization_id_29, t16.access_id AS access_id_30, t16.author_id AS author_id_31 FROM app_core_attachment t0 LEFT JOIN app_core_user_actor t16 ON t0.author_id = t16.id WHERE t0.id IN (?) Parameters: [`197`] View formatted query View runnable query Explain query SELECT t0.filename AS filename_1, t0.original_name AS original_name_2, t0.mime_type AS mime_type_3, t0.extension AS extension_4, t0.size AS size_5, t0.url AS url_6, t0.id AS id_7, t0.date_add AS date_add_8, t0.date_upd AS date_upd_9, t0.deleted AS deleted_10, t0.locked AS locked_11, t0.is_draft AS is_draft_12, t0.can_be_deleted AS can_be_deleted_13, t0.owner_organization_id AS owner_organization_id_14, t0.author_id AS author_id_15, t16.lastname AS lastname_17, t16.firstname AS firstname_18, t16.birth_place AS birth_place_19, t16.birth_date AS birth_date_20, t16.gender AS gender_21, t16.id AS id_22, t16.date_add AS date_add_23, t16.date_upd AS date_upd_24, t16.deleted AS deleted_25, t16.locked AS locked_26, t16.is_draft AS is_draft_27, t16.can_be_deleted AS can_be_deleted_28, t16.owner_organization_id AS owner_organization_id_29, t16.access_id AS access_id_30, t16.author_id AS author_id_31 FROM app_core_attachment t0 LEFT JOIN app_core_user_actor t16 ON t0.author_id = t16.id WHERE t0.id IN (?) SELECT t0.filename AS filename_1, t0.original_name AS original_name_2, t0.mime_type AS mime_type_3, t0.extension AS extension_4, t0.size AS size_5, t0.url AS url_6, t0.id AS id_7, t0.date_add AS date_add_8, t0.date_upd AS date_upd_9, t0.deleted AS deleted_10, t0.locked AS locked_11, t0.is_draft AS is_draft_12, t0.can_be_deleted AS can_be_deleted_13, t0.owner_organization_id AS owner_organization_id_14, t0.author_id AS author_id_15, t16.lastname AS lastname_17, t16.firstname AS firstname_18, t16.birth_place AS birth_place_19, t16.birth_date AS birth_date_20, t16.gender AS gender_21, t16.id AS id_22, t16.date_add AS date_add_23, t16.date_upd AS date_upd_24, t16.deleted AS deleted_25, t16.locked AS locked_26, t16.is_draft AS is_draft_27, t16.can_be_deleted AS can_be_deleted_28, t16.owner_organization_id AS owner_organization_id_29, t16.access_id AS access_id_30, t16.author_id AS author_id_31 FROM app_core_attachment t0 LEFT JOIN app_core_user_actor t16 ON t0.author_id = t16.id WHERE t0.id IN (197);
0.57 ms (0.95%)	1	SELECT t0.filename AS filename_1, t0.original_name AS original_name_2, t0.mime_type AS mime_type_3, t0.extension AS extension_4, t0.size AS size_5, t0.url AS url_6, t0.id AS id_7, t0.date_add AS date_add_8, t0.date_upd AS date_upd_9, t0.deleted AS deleted_10, t0.locked AS locked_11, t0.is_draft AS is_draft_12, t0.can_be_deleted AS can_be_deleted_13, t0.owner_organization_id AS owner_organization_id_14, t0.author_id AS author_id_15, t16.lastname AS lastname_17, t16.firstname AS firstname_18, t16.birth_place AS birth_place_19, t16.birth_date AS birth_date_20, t16.gender AS gender_21, t16.id AS id_22, t16.date_add AS date_add_23, t16.date_upd AS date_upd_24, t16.deleted AS deleted_25, t16.locked AS locked_26, t16.is_draft AS is_draft_27, t16.can_be_deleted AS can_be_deleted_28, t16.owner_organization_id AS owner_organization_id_29, t16.access_id AS access_id_30, t16.author_id AS author_id_31 FROM app_core_attachment t0 LEFT JOIN app_core_user_actor t16 ON t0.author_id = t16.id WHERE t0.id IN (?, ?) Parameters: [`206 214`] View formatted query View runnable query Explain query SELECT t0.filename AS filename_1, t0.original_name AS original_name_2, t0.mime_type AS mime_type_3, t0.extension AS extension_4, t0.size AS size_5, t0.url AS url_6, t0.id AS id_7, t0.date_add AS date_add_8, t0.date_upd AS date_upd_9, t0.deleted AS deleted_10, t0.locked AS locked_11, t0.is_draft AS is_draft_12, t0.can_be_deleted AS can_be_deleted_13, t0.owner_organization_id AS owner_organization_id_14, t0.author_id AS author_id_15, t16.lastname AS lastname_17, t16.firstname AS firstname_18, t16.birth_place AS birth_place_19, t16.birth_date AS birth_date_20, t16.gender AS gender_21, t16.id AS id_22, t16.date_add AS date_add_23, t16.date_upd AS date_upd_24, t16.deleted AS deleted_25, t16.locked AS locked_26, t16.is_draft AS is_draft_27, t16.can_be_deleted AS can_be_deleted_28, t16.owner_organization_id AS owner_organization_id_29, t16.access_id AS access_id_30, t16.author_id AS author_id_31 FROM app_core_attachment t0 LEFT JOIN app_core_user_actor t16 ON t0.author_id = t16.id WHERE t0.id IN (?, ?) SELECT t0.filename AS filename_1, t0.original_name AS original_name_2, t0.mime_type AS mime_type_3, t0.extension AS extension_4, t0.size AS size_5, t0.url AS url_6, t0.id AS id_7, t0.date_add AS date_add_8, t0.date_upd AS date_upd_9, t0.deleted AS deleted_10, t0.locked AS locked_11, t0.is_draft AS is_draft_12, t0.can_be_deleted AS can_be_deleted_13, t0.owner_organization_id AS owner_organization_id_14, t0.author_id AS author_id_15, t16.lastname AS lastname_17, t16.firstname AS firstname_18, t16.birth_place AS birth_place_19, t16.birth_date AS birth_date_20, t16.gender AS gender_21, t16.id AS id_22, t16.date_add AS date_add_23, t16.date_upd AS date_upd_24, t16.deleted AS deleted_25, t16.locked AS locked_26, t16.is_draft AS is_draft_27, t16.can_be_deleted AS can_be_deleted_28, t16.owner_organization_id AS owner_organization_id_29, t16.access_id AS access_id_30, t16.author_id AS author_id_31 FROM app_core_attachment t0 LEFT JOIN app_core_user_actor t16 ON t0.author_id = t16.id WHERE t0.id IN (206, 214);
0.53 ms (0.90%)	1	SELECT COUNT() AS dctrn_count FROM (SELECT DISTINCT id_8 FROM (SELECT a0_.color AS color_0, a0_.bg_color AS bg_color_1, a0_.type AS type_2, a0_.target AS target_3, a0_.target_menu AS target_menu_4, a0_.client_type AS client_type_5, a0_.position AS position_6, a0_.status AS status_7, a0_.id AS id_8, a0_.date_add AS date_add_9, a0_.date_upd AS date_upd_10, a0_.deleted AS deleted_11, a0_.locked AS locked_12, a0_.is_draft AS is_draft_13, a0_.can_be_deleted AS can_be_deleted_14, a0_.owner_organization_id AS owner_organization_id_15, a1_.id AS id_16, a1_.locale AS locale_17, a1_.name AS name_18, a1_.description AS description_19, a1_.meta_description AS meta_description_20, a1_.work_keys AS work_keys_21, a1_.slug AS slug_22 FROM app_business_category a0_ INNER JOIN app_business_category_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'product' AND a0_.target_menu = 'bank_insurance' AND a0_.deleted = 0 ORDER BY a0_.position ASC) dctrn_result) dctrn_table Parameters: [] View formatted query View runnable query Explain query SELECT COUNT() AS dctrn_count FROM ( SELECT DISTINCT id_8 FROM ( SELECT a0_.color AS color_0, a0_.bg_color AS bg_color_1, a0_.type AS type_2, a0_.target AS target_3, a0_.target_menu AS target_menu_4, a0_.client_type AS client_type_5, a0_.position AS position_6, a0_.status AS status_7, a0_.id AS id_8, a0_.date_add AS date_add_9, a0_.date_upd AS date_upd_10, a0_.deleted AS deleted_11, a0_.locked AS locked_12, a0_.is_draft AS is_draft_13, a0_.can_be_deleted AS can_be_deleted_14, a0_.owner_organization_id AS owner_organization_id_15, a1_.id AS id_16, a1_.locale AS locale_17, a1_.name AS name_18, a1_.description AS description_19, a1_.meta_description AS meta_description_20, a1_.work_keys AS work_keys_21, a1_.slug AS slug_22 FROM app_business_category a0_ INNER JOIN app_business_category_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'product' AND a0_.target_menu = 'bank_insurance' AND a0_.deleted = 0 ORDER BY a0_.position ASC ) dctrn_result ) dctrn_table SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_8 FROM (SELECT a0_.color AS color_0, a0_.bg_color AS bg_color_1, a0_.type AS type_2, a0_.target AS target_3, a0_.target_menu AS target_menu_4, a0_.client_type AS client_type_5, a0_.position AS position_6, a0_.status AS status_7, a0_.id AS id_8, a0_.date_add AS date_add_9, a0_.date_upd AS date_upd_10, a0_.deleted AS deleted_11, a0_.locked AS locked_12, a0_.is_draft AS is_draft_13, a0_.can_be_deleted AS can_be_deleted_14, a0_.owner_organization_id AS owner_organization_id_15, a1_.id AS id_16, a1_.locale AS locale_17, a1_.name AS name_18, a1_.description AS description_19, a1_.meta_description AS meta_description_20, a1_.work_keys AS work_keys_21, a1_.slug AS slug_22 FROM app_business_category a0_ INNER JOIN app_business_category_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'product' AND a0_.target_menu = 'bank_insurance' AND a0_.deleted = 0 ORDER BY a0_.position ASC) dctrn_result) dctrn_table;
0.53 ms (0.89%)	1	SELECT DISTINCT id_8 FROM (SELECT DISTINCT id_8, position_6 FROM (SELECT a0_.color AS color_0, a0_.bg_color AS bg_color_1, a0_.type AS type_2, a0_.target AS target_3, a0_.target_menu AS target_menu_4, a0_.client_type AS client_type_5, a0_.position AS position_6, a0_.status AS status_7, a0_.id AS id_8, a0_.date_add AS date_add_9, a0_.date_upd AS date_upd_10, a0_.deleted AS deleted_11, a0_.locked AS locked_12, a0_.is_draft AS is_draft_13, a0_.can_be_deleted AS can_be_deleted_14, a0_.owner_organization_id AS owner_organization_id_15, a1_.id AS id_16, a1_.locale AS locale_17, a1_.name AS name_18, a1_.description AS description_19, a1_.meta_description AS meta_description_20, a1_.work_keys AS work_keys_21, a1_.slug AS slug_22 FROM app_business_category a0_ INNER JOIN app_business_category_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'product' AND a0_.target_menu = 'moral_person' AND a0_.deleted = 0) dctrn_result_inner ORDER BY position_6 ASC) dctrn_result LIMIT 10 Parameters: [] View formatted query View runnable query Explain query SELECT DISTINCT id_8 FROM ( SELECT DISTINCT id_8, position_6 FROM ( SELECT a0_.color AS color_0, a0_.bg_color AS bg_color_1, a0_.type AS type_2, a0_.target AS target_3, a0_.target_menu AS target_menu_4, a0_.client_type AS client_type_5, a0_.position AS position_6, a0_.status AS status_7, a0_.id AS id_8, a0_.date_add AS date_add_9, a0_.date_upd AS date_upd_10, a0_.deleted AS deleted_11, a0_.locked AS locked_12, a0_.is_draft AS is_draft_13, a0_.can_be_deleted AS can_be_deleted_14, a0_.owner_organization_id AS owner_organization_id_15, a1_.id AS id_16, a1_.locale AS locale_17, a1_.name AS name_18, a1_.description AS description_19, a1_.meta_description AS meta_description_20, a1_.work_keys AS work_keys_21, a1_.slug AS slug_22 FROM app_business_category a0_ INNER JOIN app_business_category_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'product' AND a0_.target_menu = 'moral_person' AND a0_.deleted = 0 ) dctrn_result_inner ORDER BY position_6 ASC ) dctrn_result LIMIT 10 SELECT DISTINCT id_8 FROM (SELECT DISTINCT id_8, position_6 FROM (SELECT a0_.color AS color_0, a0_.bg_color AS bg_color_1, a0_.type AS type_2, a0_.target AS target_3, a0_.target_menu AS target_menu_4, a0_.client_type AS client_type_5, a0_.position AS position_6, a0_.status AS status_7, a0_.id AS id_8, a0_.date_add AS date_add_9, a0_.date_upd AS date_upd_10, a0_.deleted AS deleted_11, a0_.locked AS locked_12, a0_.is_draft AS is_draft_13, a0_.can_be_deleted AS can_be_deleted_14, a0_.owner_organization_id AS owner_organization_id_15, a1_.id AS id_16, a1_.locale AS locale_17, a1_.name AS name_18, a1_.description AS description_19, a1_.meta_description AS meta_description_20, a1_.work_keys AS work_keys_21, a1_.slug AS slug_22 FROM app_business_category a0_ INNER JOIN app_business_category_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'product' AND a0_.target_menu = 'moral_person' AND a0_.deleted = 0) dctrn_result_inner ORDER BY position_6 ASC) dctrn_result LIMIT 10;
0.52 ms (0.87%)	1	SELECT COUNT() AS dctrn_count FROM (SELECT DISTINCT id_11 FROM (SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'moral_person' AND a0_.type_id IS NULL AND a0_.deleted = 0 ORDER BY a0_.position ASC) dctrn_result) dctrn_table Parameters: [] View formatted query View runnable query Explain query SELECT COUNT() AS dctrn_count FROM ( SELECT DISTINCT id_11 FROM ( SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'moral_person' AND a0_.type_id IS NULL AND a0_.deleted = 0 ORDER BY a0_.position ASC ) dctrn_result ) dctrn_table SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_11 FROM (SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'moral_person' AND a0_.type_id IS NULL AND a0_.deleted = 0 ORDER BY a0_.position ASC) dctrn_result) dctrn_table;
0.51 ms (0.86%)	1	SELECT DISTINCT id_11 FROM (SELECT DISTINCT id_11, position_9 FROM (SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'moral_person' AND a0_.type_id IS NULL AND a0_.deleted = 0) dctrn_result_inner ORDER BY position_9 ASC) dctrn_result LIMIT 10 Parameters: [] View formatted query View runnable query Explain query SELECT DISTINCT id_11 FROM ( SELECT DISTINCT id_11, position_9 FROM ( SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'moral_person' AND a0_.type_id IS NULL AND a0_.deleted = 0 ) dctrn_result_inner ORDER BY position_9 ASC ) dctrn_result LIMIT 10 SELECT DISTINCT id_11 FROM (SELECT DISTINCT id_11, position_9 FROM (SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'moral_person' AND a0_.type_id IS NULL AND a0_.deleted = 0) dctrn_result_inner ORDER BY position_9 ASC) dctrn_result LIMIT 10;
0.51 ms (0.85%)	1	SELECT t0.email AS email_1, t0.token AS token_2, t0.confirmation_token AS confirmation_token_3, t0.context_type AS context_type_4, t0.password AS password_5, t0.is_active AS is_active_6, t0.is_blocked AS is_blocked_7, t0.roles AS roles_8, t0.id AS id_9, t0.date_add AS date_add_10, t0.date_upd AS date_upd_11, t0.deleted AS deleted_12, t0.locked AS locked_13, t0.is_draft AS is_draft_14, t0.can_be_deleted AS can_be_deleted_15, t0.owner_organization_id AS owner_organization_id_16, t17.lastname AS lastname_18, t17.firstname AS firstname_19, t17.birth_place AS birth_place_20, t17.birth_date AS birth_date_21, t17.gender AS gender_22, t17.id AS id_23, t17.date_add AS date_add_24, t17.date_upd AS date_upd_25, t17.deleted AS deleted_26, t17.locked AS locked_27, t17.is_draft AS is_draft_28, t17.can_be_deleted AS can_be_deleted_29, t17.owner_organization_id AS owner_organization_id_30, t17.access_id AS access_id_31, t17.author_id AS author_id_32, t0.author_id AS author_id_33, t34.lastname AS lastname_35, t34.firstname AS firstname_36, t34.birth_place AS birth_place_37, t34.birth_date AS birth_date_38, t34.gender AS gender_39, t34.id AS id_40, t34.date_add AS date_add_41, t34.date_upd AS date_upd_42, t34.deleted AS deleted_43, t34.locked AS locked_44, t34.is_draft AS is_draft_45, t34.can_be_deleted AS can_be_deleted_46, t34.owner_organization_id AS owner_organization_id_47, t34.access_id AS access_id_48, t34.author_id AS author_id_49 FROM app_core_user_access t0 LEFT JOIN app_core_user_actor t17 ON t17.access_id = t0.id LEFT JOIN app_core_user_actor t34 ON t0.author_id = t34.id WHERE t0.id IN (?) Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.email AS email_1, t0.token AS token_2, t0.confirmation_token AS confirmation_token_3, t0.context_type AS context_type_4, t0.password AS password_5, t0.is_active AS is_active_6, t0.is_blocked AS is_blocked_7, t0.roles AS roles_8, t0.id AS id_9, t0.date_add AS date_add_10, t0.date_upd AS date_upd_11, t0.deleted AS deleted_12, t0.locked AS locked_13, t0.is_draft AS is_draft_14, t0.can_be_deleted AS can_be_deleted_15, t0.owner_organization_id AS owner_organization_id_16, t17.lastname AS lastname_18, t17.firstname AS firstname_19, t17.birth_place AS birth_place_20, t17.birth_date AS birth_date_21, t17.gender AS gender_22, t17.id AS id_23, t17.date_add AS date_add_24, t17.date_upd AS date_upd_25, t17.deleted AS deleted_26, t17.locked AS locked_27, t17.is_draft AS is_draft_28, t17.can_be_deleted AS can_be_deleted_29, t17.owner_organization_id AS owner_organization_id_30, t17.access_id AS access_id_31, t17.author_id AS author_id_32, t0.author_id AS author_id_33, t34.lastname AS lastname_35, t34.firstname AS firstname_36, t34.birth_place AS birth_place_37, t34.birth_date AS birth_date_38, t34.gender AS gender_39, t34.id AS id_40, t34.date_add AS date_add_41, t34.date_upd AS date_upd_42, t34.deleted AS deleted_43, t34.locked AS locked_44, t34.is_draft AS is_draft_45, t34.can_be_deleted AS can_be_deleted_46, t34.owner_organization_id AS owner_organization_id_47, t34.access_id AS access_id_48, t34.author_id AS author_id_49 FROM app_core_user_access t0 LEFT JOIN app_core_user_actor t17 ON t17.access_id = t0.id LEFT JOIN app_core_user_actor t34 ON t0.author_id = t34.id WHERE t0.id IN (?) SELECT t0.email AS email_1, t0.token AS token_2, t0.confirmation_token AS confirmation_token_3, t0.context_type AS context_type_4, t0.password AS password_5, t0.is_active AS is_active_6, t0.is_blocked AS is_blocked_7, t0.roles AS roles_8, t0.id AS id_9, t0.date_add AS date_add_10, t0.date_upd AS date_upd_11, t0.deleted AS deleted_12, t0.locked AS locked_13, t0.is_draft AS is_draft_14, t0.can_be_deleted AS can_be_deleted_15, t0.owner_organization_id AS owner_organization_id_16, t17.lastname AS lastname_18, t17.firstname AS firstname_19, t17.birth_place AS birth_place_20, t17.birth_date AS birth_date_21, t17.gender AS gender_22, t17.id AS id_23, t17.date_add AS date_add_24, t17.date_upd AS date_upd_25, t17.deleted AS deleted_26, t17.locked AS locked_27, t17.is_draft AS is_draft_28, t17.can_be_deleted AS can_be_deleted_29, t17.owner_organization_id AS owner_organization_id_30, t17.access_id AS access_id_31, t17.author_id AS author_id_32, t0.author_id AS author_id_33, t34.lastname AS lastname_35, t34.firstname AS firstname_36, t34.birth_place AS birth_place_37, t34.birth_date AS birth_date_38, t34.gender AS gender_39, t34.id AS id_40, t34.date_add AS date_add_41, t34.date_upd AS date_upd_42, t34.deleted AS deleted_43, t34.locked AS locked_44, t34.is_draft AS is_draft_45, t34.can_be_deleted AS can_be_deleted_46, t34.owner_organization_id AS owner_organization_id_47, t34.access_id AS access_id_48, t34.author_id AS author_id_49 FROM app_core_user_access t0 LEFT JOIN app_core_user_actor t17 ON t17.access_id = t0.id LEFT JOIN app_core_user_actor t34 ON t0.author_id = t34.id WHERE t0.id IN (1);
0.50 ms (0.85%)	1	SELECT t0.status AS status_1, t0.target AS target_2, t0.group_type AS group_type_3, t0.target_menu AS target_menu_4, t0.client_type AS client_type_5, t0.lend_type AS lend_type_6, t0.lend_types AS lend_types_7, t0.show_in_menu AS show_in_menu_8, t0.show_title AS show_title_9, t0.position AS position_10, t0.anchor AS anchor_11, t0.id AS id_12, t0.date_add AS date_add_13, t0.date_upd AS date_upd_14, t0.deleted AS deleted_15, t0.locked AS locked_16, t0.is_draft AS is_draft_17, t0.can_be_deleted AS can_be_deleted_18, t0.owner_organization_id AS owner_organization_id_19, t0.type_id AS type_id_20, t21.color AS color_22, t21.bg_color AS bg_color_23, t21.type AS type_24, t21.target AS target_25, t21.target_menu AS target_menu_26, t21.client_type AS client_type_27, t21.position AS position_28, t21.status AS status_29, t21.id AS id_30, t21.date_add AS date_add_31, t21.date_upd AS date_upd_32, t21.deleted AS deleted_33, t21.locked AS locked_34, t21.is_draft AS is_draft_35, t21.can_be_deleted AS can_be_deleted_36, t21.owner_organization_id AS owner_organization_id_37, t21.author_id AS author_id_38, t0.parent_id AS parent_id_39, t40.status AS status_41, t40.target AS target_42, t40.group_type AS group_type_43, t40.target_menu AS target_menu_44, t40.client_type AS client_type_45, t40.lend_type AS lend_type_46, t40.lend_types AS lend_types_47, t40.show_in_menu AS show_in_menu_48, t40.show_title AS show_title_49, t40.position AS position_50, t40.anchor AS anchor_51, t40.id AS id_52, t40.date_add AS date_add_53, t40.date_upd AS date_upd_54, t40.deleted AS deleted_55, t40.locked AS locked_56, t40.is_draft AS is_draft_57, t40.can_be_deleted AS can_be_deleted_58, t40.owner_organization_id AS owner_organization_id_59, t40.type_id AS type_id_60, t40.parent_id AS parent_id_61, t40.thumbnail_id AS thumbnail_id_62, t40.author_id AS author_id_63, t0.thumbnail_id AS thumbnail_id_64, t65.filename AS filename_66, t65.original_name AS original_name_67, t65.mime_type AS mime_type_68, t65.extension AS extension_69, t65.size AS size_70, t65.url AS url_71, t65.id AS id_72, t65.date_add AS date_add_73, t65.date_upd AS date_upd_74, t65.deleted AS deleted_75, t65.locked AS locked_76, t65.is_draft AS is_draft_77, t65.can_be_deleted AS can_be_deleted_78, t65.owner_organization_id AS owner_organization_id_79, t65.author_id AS author_id_80, t0.author_id AS author_id_81, t82.lastname AS lastname_83, t82.firstname AS firstname_84, t82.birth_place AS birth_place_85, t82.birth_date AS birth_date_86, t82.gender AS gender_87, t82.id AS id_88, t82.date_add AS date_add_89, t82.date_upd AS date_upd_90, t82.deleted AS deleted_91, t82.locked AS locked_92, t82.is_draft AS is_draft_93, t82.can_be_deleted AS can_be_deleted_94, t82.owner_organization_id AS owner_organization_id_95, t82.access_id AS access_id_96, t82.author_id AS author_id_97 FROM app_business_product t0 LEFT JOIN app_business_category t21 ON t0.type_id = t21.id LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id WHERE t0.parent_id IN (?, ?, ?, ?, ?, ?) Parameters: [`29 30 19 20 21 22`] View formatted query View runnable query Explain query SELECT t0.status AS status_1, t0.target AS target_2, t0.group_type AS group_type_3, t0.target_menu AS target_menu_4, t0.client_type AS client_type_5, t0.lend_type AS lend_type_6, t0.lend_types AS lend_types_7, t0.show_in_menu AS show_in_menu_8, t0.show_title AS show_title_9, t0.position AS position_10, t0.anchor AS anchor_11, t0.id AS id_12, t0.date_add AS date_add_13, t0.date_upd AS date_upd_14, t0.deleted AS deleted_15, t0.locked AS locked_16, t0.is_draft AS is_draft_17, t0.can_be_deleted AS can_be_deleted_18, t0.owner_organization_id AS owner_organization_id_19, t0.type_id AS type_id_20, t21.color AS color_22, t21.bg_color AS bg_color_23, t21.type AS type_24, t21.target AS target_25, t21.target_menu AS target_menu_26, t21.client_type AS client_type_27, t21.position AS position_28, t21.status AS status_29, t21.id AS id_30, t21.date_add AS date_add_31, t21.date_upd AS date_upd_32, t21.deleted AS deleted_33, t21.locked AS locked_34, t21.is_draft AS is_draft_35, t21.can_be_deleted AS can_be_deleted_36, t21.owner_organization_id AS owner_organization_id_37, t21.author_id AS author_id_38, t0.parent_id AS parent_id_39, t40.status AS status_41, t40.target AS target_42, t40.group_type AS group_type_43, t40.target_menu AS target_menu_44, t40.client_type AS client_type_45, t40.lend_type AS lend_type_46, t40.lend_types AS lend_types_47, t40.show_in_menu AS show_in_menu_48, t40.show_title AS show_title_49, t40.position AS position_50, t40.anchor AS anchor_51, t40.id AS id_52, t40.date_add AS date_add_53, t40.date_upd AS date_upd_54, t40.deleted AS deleted_55, t40.locked AS locked_56, t40.is_draft AS is_draft_57, t40.can_be_deleted AS can_be_deleted_58, t40.owner_organization_id AS owner_organization_id_59, t40.type_id AS type_id_60, t40.parent_id AS parent_id_61, t40.thumbnail_id AS thumbnail_id_62, t40.author_id AS author_id_63, t0.thumbnail_id AS thumbnail_id_64, t65.filename AS filename_66, t65.original_name AS original_name_67, t65.mime_type AS mime_type_68, t65.extension AS extension_69, t65.size AS size_70, t65.url AS url_71, t65.id AS id_72, t65.date_add AS date_add_73, t65.date_upd AS date_upd_74, t65.deleted AS deleted_75, t65.locked AS locked_76, t65.is_draft AS is_draft_77, t65.can_be_deleted AS can_be_deleted_78, t65.owner_organization_id AS owner_organization_id_79, t65.author_id AS author_id_80, t0.author_id AS author_id_81, t82.lastname AS lastname_83, t82.firstname AS firstname_84, t82.birth_place AS birth_place_85, t82.birth_date AS birth_date_86, t82.gender AS gender_87, t82.id AS id_88, t82.date_add AS date_add_89, t82.date_upd AS date_upd_90, t82.deleted AS deleted_91, t82.locked AS locked_92, t82.is_draft AS is_draft_93, t82.can_be_deleted AS can_be_deleted_94, t82.owner_organization_id AS owner_organization_id_95, t82.access_id AS access_id_96, t82.author_id AS author_id_97 FROM app_business_product t0 LEFT JOIN app_business_category t21 ON t0.type_id = t21.id LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id WHERE t0.parent_id IN (?, ?, ?, ?, ?, ?) SELECT t0.status AS status_1, t0.target AS target_2, t0.group_type AS group_type_3, t0.target_menu AS target_menu_4, t0.client_type AS client_type_5, t0.lend_type AS lend_type_6, t0.lend_types AS lend_types_7, t0.show_in_menu AS show_in_menu_8, t0.show_title AS show_title_9, t0.position AS position_10, t0.anchor AS anchor_11, t0.id AS id_12, t0.date_add AS date_add_13, t0.date_upd AS date_upd_14, t0.deleted AS deleted_15, t0.locked AS locked_16, t0.is_draft AS is_draft_17, t0.can_be_deleted AS can_be_deleted_18, t0.owner_organization_id AS owner_organization_id_19, t0.type_id AS type_id_20, t21.color AS color_22, t21.bg_color AS bg_color_23, t21.type AS type_24, t21.target AS target_25, t21.target_menu AS target_menu_26, t21.client_type AS client_type_27, t21.position AS position_28, t21.status AS status_29, t21.id AS id_30, t21.date_add AS date_add_31, t21.date_upd AS date_upd_32, t21.deleted AS deleted_33, t21.locked AS locked_34, t21.is_draft AS is_draft_35, t21.can_be_deleted AS can_be_deleted_36, t21.owner_organization_id AS owner_organization_id_37, t21.author_id AS author_id_38, t0.parent_id AS parent_id_39, t40.status AS status_41, t40.target AS target_42, t40.group_type AS group_type_43, t40.target_menu AS target_menu_44, t40.client_type AS client_type_45, t40.lend_type AS lend_type_46, t40.lend_types AS lend_types_47, t40.show_in_menu AS show_in_menu_48, t40.show_title AS show_title_49, t40.position AS position_50, t40.anchor AS anchor_51, t40.id AS id_52, t40.date_add AS date_add_53, t40.date_upd AS date_upd_54, t40.deleted AS deleted_55, t40.locked AS locked_56, t40.is_draft AS is_draft_57, t40.can_be_deleted AS can_be_deleted_58, t40.owner_organization_id AS owner_organization_id_59, t40.type_id AS type_id_60, t40.parent_id AS parent_id_61, t40.thumbnail_id AS thumbnail_id_62, t40.author_id AS author_id_63, t0.thumbnail_id AS thumbnail_id_64, t65.filename AS filename_66, t65.original_name AS original_name_67, t65.mime_type AS mime_type_68, t65.extension AS extension_69, t65.size AS size_70, t65.url AS url_71, t65.id AS id_72, t65.date_add AS date_add_73, t65.date_upd AS date_upd_74, t65.deleted AS deleted_75, t65.locked AS locked_76, t65.is_draft AS is_draft_77, t65.can_be_deleted AS can_be_deleted_78, t65.owner_organization_id AS owner_organization_id_79, t65.author_id AS author_id_80, t0.author_id AS author_id_81, t82.lastname AS lastname_83, t82.firstname AS firstname_84, t82.birth_place AS birth_place_85, t82.birth_date AS birth_date_86, t82.gender AS gender_87, t82.id AS id_88, t82.date_add AS date_add_89, t82.date_upd AS date_upd_90, t82.deleted AS deleted_91, t82.locked AS locked_92, t82.is_draft AS is_draft_93, t82.can_be_deleted AS can_be_deleted_94, t82.owner_organization_id AS owner_organization_id_95, t82.access_id AS access_id_96, t82.author_id AS author_id_97 FROM app_business_product t0 LEFT JOIN app_business_category t21 ON t0.type_id = t21.id LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id WHERE t0.parent_id IN (29, 30, 19, 20, 21, 22);
0.49 ms (0.83%)	1	SELECT COUNT() AS dctrn_count FROM (SELECT DISTINCT id_11 FROM (SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'bank_insurance' AND a0_.type_id IS NULL AND a0_.deleted = 0 ORDER BY a0_.position ASC) dctrn_result) dctrn_table Parameters: [] View formatted query View runnable query Explain query SELECT COUNT() AS dctrn_count FROM ( SELECT DISTINCT id_11 FROM ( SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'bank_insurance' AND a0_.type_id IS NULL AND a0_.deleted = 0 ORDER BY a0_.position ASC ) dctrn_result ) dctrn_table SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_11 FROM (SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'bank_insurance' AND a0_.type_id IS NULL AND a0_.deleted = 0 ORDER BY a0_.position ASC) dctrn_result) dctrn_table;
0.48 ms (0.81%)	1	SELECT COUNT() AS dctrn_count FROM (SELECT DISTINCT id_9 FROM (SELECT a0_.type AS type_0, a0_.publish_date AS publish_date_1, a0_.expiry_date AS expiry_date_2, a0_.source_url AS source_url_3, a0_.location AS location_4, a0_.status AS status_5, a0_.is_editor_choice AS is_editor_choice_6, a0_.hide_title AS hide_title_7, a0_.hide_excerpt AS hide_excerpt_8, a0_.id AS id_9, a0_.date_add AS date_add_10, a0_.date_upd AS date_upd_11, a0_.deleted AS deleted_12, a0_.locked AS locked_13, a0_.is_draft AS is_draft_14, a0_.can_be_deleted AS can_be_deleted_15, a0_.owner_organization_id AS owner_organization_id_16, a1_.excerpt AS excerpt_17, a1_.intro AS intro_18, a1_.id AS id_19, a1_.locale AS locale_20, a1_.name AS name_21, a1_.description AS description_22, a1_.meta_description AS meta_description_23, a1_.work_keys AS work_keys_24, a1_.slug AS slug_25, a2_.color AS color_26, a2_.bg_color AS bg_color_27, a2_.type AS type_28, a2_.target AS target_29, a2_.target_menu AS target_menu_30, a2_.client_type AS client_type_31, a2_.position AS position_32, a2_.status AS status_33, a2_.id AS id_34, a2_.date_add AS date_add_35, a2_.date_upd AS date_upd_36, a2_.deleted AS deleted_37, a2_.locked AS locked_38, a2_.is_draft AS is_draft_39, a2_.can_be_deleted AS can_be_deleted_40, a2_.owner_organization_id AS owner_organization_id_41 FROM app_blog_post a0_ INNER JOIN app_blog_post_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_blog_post_category a3_ ON a0_.id = a3_.post_id LEFT JOIN app_business_category a2_ ON a2_.id = a3_.category_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'post' AND a0_.deleted = 0 ORDER BY a0_.publish_date DESC) dctrn_result) dctrn_table Parameters: [] View formatted query View runnable query Explain query SELECT COUNT() AS dctrn_count FROM ( SELECT DISTINCT id_9 FROM ( SELECT a0_.type AS type_0, a0_.publish_date AS publish_date_1, a0_.expiry_date AS expiry_date_2, a0_.source_url AS source_url_3, a0_.location AS location_4, a0_.status AS status_5, a0_.is_editor_choice AS is_editor_choice_6, a0_.hide_title AS hide_title_7, a0_.hide_excerpt AS hide_excerpt_8, a0_.id AS id_9, a0_.date_add AS date_add_10, a0_.date_upd AS date_upd_11, a0_.deleted AS deleted_12, a0_.locked AS locked_13, a0_.is_draft AS is_draft_14, a0_.can_be_deleted AS can_be_deleted_15, a0_.owner_organization_id AS owner_organization_id_16, a1_.excerpt AS excerpt_17, a1_.intro AS intro_18, a1_.id AS id_19, a1_.locale AS locale_20, a1_.name AS name_21, a1_.description AS description_22, a1_.meta_description AS meta_description_23, a1_.work_keys AS work_keys_24, a1_.slug AS slug_25, a2_.color AS color_26, a2_.bg_color AS bg_color_27, a2_.type AS type_28, a2_.target AS target_29, a2_.target_menu AS target_menu_30, a2_.client_type AS client_type_31, a2_.position AS position_32, a2_.status AS status_33, a2_.id AS id_34, a2_.date_add AS date_add_35, a2_.date_upd AS date_upd_36, a2_.deleted AS deleted_37, a2_.locked AS locked_38, a2_.is_draft AS is_draft_39, a2_.can_be_deleted AS can_be_deleted_40, a2_.owner_organization_id AS owner_organization_id_41 FROM app_blog_post a0_ INNER JOIN app_blog_post_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_blog_post_category a3_ ON a0_.id = a3_.post_id LEFT JOIN app_business_category a2_ ON a2_.id = a3_.category_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'post' AND a0_.deleted = 0 ORDER BY a0_.publish_date DESC ) dctrn_result ) dctrn_table SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_9 FROM (SELECT a0_.type AS type_0, a0_.publish_date AS publish_date_1, a0_.expiry_date AS expiry_date_2, a0_.source_url AS source_url_3, a0_.location AS location_4, a0_.status AS status_5, a0_.is_editor_choice AS is_editor_choice_6, a0_.hide_title AS hide_title_7, a0_.hide_excerpt AS hide_excerpt_8, a0_.id AS id_9, a0_.date_add AS date_add_10, a0_.date_upd AS date_upd_11, a0_.deleted AS deleted_12, a0_.locked AS locked_13, a0_.is_draft AS is_draft_14, a0_.can_be_deleted AS can_be_deleted_15, a0_.owner_organization_id AS owner_organization_id_16, a1_.excerpt AS excerpt_17, a1_.intro AS intro_18, a1_.id AS id_19, a1_.locale AS locale_20, a1_.name AS name_21, a1_.description AS description_22, a1_.meta_description AS meta_description_23, a1_.work_keys AS work_keys_24, a1_.slug AS slug_25, a2_.color AS color_26, a2_.bg_color AS bg_color_27, a2_.type AS type_28, a2_.target AS target_29, a2_.target_menu AS target_menu_30, a2_.client_type AS client_type_31, a2_.position AS position_32, a2_.status AS status_33, a2_.id AS id_34, a2_.date_add AS date_add_35, a2_.date_upd AS date_upd_36, a2_.deleted AS deleted_37, a2_.locked AS locked_38, a2_.is_draft AS is_draft_39, a2_.can_be_deleted AS can_be_deleted_40, a2_.owner_organization_id AS owner_organization_id_41 FROM app_blog_post a0_ INNER JOIN app_blog_post_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_blog_post_category a3_ ON a0_.id = a3_.post_id LEFT JOIN app_business_category a2_ ON a2_.id = a3_.category_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'post' AND a0_.deleted = 0 ORDER BY a0_.publish_date DESC) dctrn_result) dctrn_table;
0.46 ms (0.77%)	1	SELECT COUNT() AS dctrn_count FROM (SELECT DISTINCT id_8 FROM (SELECT a0_.color AS color_0, a0_.bg_color AS bg_color_1, a0_.type AS type_2, a0_.target AS target_3, a0_.target_menu AS target_menu_4, a0_.client_type AS client_type_5, a0_.position AS position_6, a0_.status AS status_7, a0_.id AS id_8, a0_.date_add AS date_add_9, a0_.date_upd AS date_upd_10, a0_.deleted AS deleted_11, a0_.locked AS locked_12, a0_.is_draft AS is_draft_13, a0_.can_be_deleted AS can_be_deleted_14, a0_.owner_organization_id AS owner_organization_id_15, a1_.id AS id_16, a1_.locale AS locale_17, a1_.name AS name_18, a1_.description AS description_19, a1_.meta_description AS meta_description_20, a1_.work_keys AS work_keys_21, a1_.slug AS slug_22 FROM app_business_category a0_ INNER JOIN app_business_category_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'product' AND a0_.target_menu = 'moral_person' AND a0_.deleted = 0 ORDER BY a0_.position ASC) dctrn_result) dctrn_table Parameters: [] View formatted query View runnable query Explain query SELECT COUNT() AS dctrn_count FROM ( SELECT DISTINCT id_8 FROM ( SELECT a0_.color AS color_0, a0_.bg_color AS bg_color_1, a0_.type AS type_2, a0_.target AS target_3, a0_.target_menu AS target_menu_4, a0_.client_type AS client_type_5, a0_.position AS position_6, a0_.status AS status_7, a0_.id AS id_8, a0_.date_add AS date_add_9, a0_.date_upd AS date_upd_10, a0_.deleted AS deleted_11, a0_.locked AS locked_12, a0_.is_draft AS is_draft_13, a0_.can_be_deleted AS can_be_deleted_14, a0_.owner_organization_id AS owner_organization_id_15, a1_.id AS id_16, a1_.locale AS locale_17, a1_.name AS name_18, a1_.description AS description_19, a1_.meta_description AS meta_description_20, a1_.work_keys AS work_keys_21, a1_.slug AS slug_22 FROM app_business_category a0_ INNER JOIN app_business_category_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'product' AND a0_.target_menu = 'moral_person' AND a0_.deleted = 0 ORDER BY a0_.position ASC ) dctrn_result ) dctrn_table SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_8 FROM (SELECT a0_.color AS color_0, a0_.bg_color AS bg_color_1, a0_.type AS type_2, a0_.target AS target_3, a0_.target_menu AS target_menu_4, a0_.client_type AS client_type_5, a0_.position AS position_6, a0_.status AS status_7, a0_.id AS id_8, a0_.date_add AS date_add_9, a0_.date_upd AS date_upd_10, a0_.deleted AS deleted_11, a0_.locked AS locked_12, a0_.is_draft AS is_draft_13, a0_.can_be_deleted AS can_be_deleted_14, a0_.owner_organization_id AS owner_organization_id_15, a1_.id AS id_16, a1_.locale AS locale_17, a1_.name AS name_18, a1_.description AS description_19, a1_.meta_description AS meta_description_20, a1_.work_keys AS work_keys_21, a1_.slug AS slug_22 FROM app_business_category a0_ INNER JOIN app_business_category_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'product' AND a0_.target_menu = 'moral_person' AND a0_.deleted = 0 ORDER BY a0_.position ASC) dctrn_result) dctrn_table;
0.46 ms (0.77%)	1	SELECT t0.filename AS filename_1, t0.original_name AS original_name_2, t0.mime_type AS mime_type_3, t0.extension AS extension_4, t0.size AS size_5, t0.url AS url_6, t0.id AS id_7, t0.date_add AS date_add_8, t0.date_upd AS date_upd_9, t0.deleted AS deleted_10, t0.locked AS locked_11, t0.is_draft AS is_draft_12, t0.can_be_deleted AS can_be_deleted_13, t0.owner_organization_id AS owner_organization_id_14, t0.author_id AS author_id_15, t16.lastname AS lastname_17, t16.firstname AS firstname_18, t16.birth_place AS birth_place_19, t16.birth_date AS birth_date_20, t16.gender AS gender_21, t16.id AS id_22, t16.date_add AS date_add_23, t16.date_upd AS date_upd_24, t16.deleted AS deleted_25, t16.locked AS locked_26, t16.is_draft AS is_draft_27, t16.can_be_deleted AS can_be_deleted_28, t16.owner_organization_id AS owner_organization_id_29, t16.access_id AS access_id_30, t16.author_id AS author_id_31 FROM app_core_attachment t0 LEFT JOIN app_core_user_actor t16 ON t0.author_id = t16.id WHERE t0.id IN (?, ?, ?, ?, ?, ?) Parameters: [`64 66 201 62 202 203`] View formatted query View runnable query Explain query SELECT t0.filename AS filename_1, t0.original_name AS original_name_2, t0.mime_type AS mime_type_3, t0.extension AS extension_4, t0.size AS size_5, t0.url AS url_6, t0.id AS id_7, t0.date_add AS date_add_8, t0.date_upd AS date_upd_9, t0.deleted AS deleted_10, t0.locked AS locked_11, t0.is_draft AS is_draft_12, t0.can_be_deleted AS can_be_deleted_13, t0.owner_organization_id AS owner_organization_id_14, t0.author_id AS author_id_15, t16.lastname AS lastname_17, t16.firstname AS firstname_18, t16.birth_place AS birth_place_19, t16.birth_date AS birth_date_20, t16.gender AS gender_21, t16.id AS id_22, t16.date_add AS date_add_23, t16.date_upd AS date_upd_24, t16.deleted AS deleted_25, t16.locked AS locked_26, t16.is_draft AS is_draft_27, t16.can_be_deleted AS can_be_deleted_28, t16.owner_organization_id AS owner_organization_id_29, t16.access_id AS access_id_30, t16.author_id AS author_id_31 FROM app_core_attachment t0 LEFT JOIN app_core_user_actor t16 ON t0.author_id = t16.id WHERE t0.id IN (?, ?, ?, ?, ?, ?) SELECT t0.filename AS filename_1, t0.original_name AS original_name_2, t0.mime_type AS mime_type_3, t0.extension AS extension_4, t0.size AS size_5, t0.url AS url_6, t0.id AS id_7, t0.date_add AS date_add_8, t0.date_upd AS date_upd_9, t0.deleted AS deleted_10, t0.locked AS locked_11, t0.is_draft AS is_draft_12, t0.can_be_deleted AS can_be_deleted_13, t0.owner_organization_id AS owner_organization_id_14, t0.author_id AS author_id_15, t16.lastname AS lastname_17, t16.firstname AS firstname_18, t16.birth_place AS birth_place_19, t16.birth_date AS birth_date_20, t16.gender AS gender_21, t16.id AS id_22, t16.date_add AS date_add_23, t16.date_upd AS date_upd_24, t16.deleted AS deleted_25, t16.locked AS locked_26, t16.is_draft AS is_draft_27, t16.can_be_deleted AS can_be_deleted_28, t16.owner_organization_id AS owner_organization_id_29, t16.access_id AS access_id_30, t16.author_id AS author_id_31 FROM app_core_attachment t0 LEFT JOIN app_core_user_actor t16 ON t0.author_id = t16.id WHERE t0.id IN (64, 66, 201, 62, 202, 203);
0.44 ms (0.74%)	1	SELECT DISTINCT id_8 FROM (SELECT DISTINCT id_8, position_6 FROM (SELECT a0_.color AS color_0, a0_.bg_color AS bg_color_1, a0_.type AS type_2, a0_.target AS target_3, a0_.target_menu AS target_menu_4, a0_.client_type AS client_type_5, a0_.position AS position_6, a0_.status AS status_7, a0_.id AS id_8, a0_.date_add AS date_add_9, a0_.date_upd AS date_upd_10, a0_.deleted AS deleted_11, a0_.locked AS locked_12, a0_.is_draft AS is_draft_13, a0_.can_be_deleted AS can_be_deleted_14, a0_.owner_organization_id AS owner_organization_id_15, a1_.id AS id_16, a1_.locale AS locale_17, a1_.name AS name_18, a1_.description AS description_19, a1_.meta_description AS meta_description_20, a1_.work_keys AS work_keys_21, a1_.slug AS slug_22 FROM app_business_category a0_ INNER JOIN app_business_category_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'product' AND a0_.target_menu = 'bank_insurance' AND a0_.deleted = 0) dctrn_result_inner ORDER BY position_6 ASC) dctrn_result LIMIT 10 Parameters: [] View formatted query View runnable query Explain query SELECT DISTINCT id_8 FROM ( SELECT DISTINCT id_8, position_6 FROM ( SELECT a0_.color AS color_0, a0_.bg_color AS bg_color_1, a0_.type AS type_2, a0_.target AS target_3, a0_.target_menu AS target_menu_4, a0_.client_type AS client_type_5, a0_.position AS position_6, a0_.status AS status_7, a0_.id AS id_8, a0_.date_add AS date_add_9, a0_.date_upd AS date_upd_10, a0_.deleted AS deleted_11, a0_.locked AS locked_12, a0_.is_draft AS is_draft_13, a0_.can_be_deleted AS can_be_deleted_14, a0_.owner_organization_id AS owner_organization_id_15, a1_.id AS id_16, a1_.locale AS locale_17, a1_.name AS name_18, a1_.description AS description_19, a1_.meta_description AS meta_description_20, a1_.work_keys AS work_keys_21, a1_.slug AS slug_22 FROM app_business_category a0_ INNER JOIN app_business_category_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'product' AND a0_.target_menu = 'bank_insurance' AND a0_.deleted = 0 ) dctrn_result_inner ORDER BY position_6 ASC ) dctrn_result LIMIT 10 SELECT DISTINCT id_8 FROM (SELECT DISTINCT id_8, position_6 FROM (SELECT a0_.color AS color_0, a0_.bg_color AS bg_color_1, a0_.type AS type_2, a0_.target AS target_3, a0_.target_menu AS target_menu_4, a0_.client_type AS client_type_5, a0_.position AS position_6, a0_.status AS status_7, a0_.id AS id_8, a0_.date_add AS date_add_9, a0_.date_upd AS date_upd_10, a0_.deleted AS deleted_11, a0_.locked AS locked_12, a0_.is_draft AS is_draft_13, a0_.can_be_deleted AS can_be_deleted_14, a0_.owner_organization_id AS owner_organization_id_15, a1_.id AS id_16, a1_.locale AS locale_17, a1_.name AS name_18, a1_.description AS description_19, a1_.meta_description AS meta_description_20, a1_.work_keys AS work_keys_21, a1_.slug AS slug_22 FROM app_business_category a0_ INNER JOIN app_business_category_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'product' AND a0_.target_menu = 'bank_insurance' AND a0_.deleted = 0) dctrn_result_inner ORDER BY position_6 ASC) dctrn_result LIMIT 10;

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\Core\Entity\AbstractEntity	No errors.
App\Core\Entity\User\Workspace	No errors.
App\Core\Entity\User\Actor	No errors.
App\Core\Entity\User\Access	No errors.
App\Core\Entity\User\Organization	No errors.
App\Core\Entity\Attachment	No errors.
App\Business\Entity\Product	No errors.
App\Business\Entity\Category	No errors.
App\Core\Entity\AbstractEntityI18n	No errors.
App\Business\Entity\ProductI18n	No errors.
App\Business\Entity\Website	No errors.
App\Business\Entity\WebsiteI18n	No errors.
App\Core\Entity\Parameter	No errors.
App\Business\Entity\CategoryI18n	No errors.
App\Blog\Entity\PageSection	The field App\Blog\Entity\PageSection#items is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Blog\Entity\PageSectionItem#section does not contain the required 'inversedBy="items"' attribute.
App\Blog\Entity\PageSectionI18n	No errors.
App\Core\Entity\CmsPage	No errors.
App\Blog\Entity\PageSectionItem	No errors.
App\Blog\Entity\PageSectionItemI18n	No errors.
App\Core\Entity\CmsPageI18n	No errors.
App\Blog\Entity\Post	No errors.
App\Blog\Entity\PostI18n	No errors.

Symfony Profiler

GET https://bangebj.thebest-group.com/_fragment?_path=_format%3Dhtml%26_locale%3Des%26_controller%3DApp%255CBlog%255CController%255CPublic%255CEmbedController%253A%…

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping