Symfony Profiler

Query Metrics

32 Database Queries

28 Different statements

32.03 ms Query time

0 Invalid entities

Grouped Statements

Time▼	Count	Info
3.67 ms (11.48%)	4	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;
3.57 ms (11.16%)	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;
3.39 ms (10.59%)	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.88 ms (9.01%)	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.52 ms (4.75%)	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;
1.50 ms (4.70%)	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;
1.32 ms (4.12%)	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;
1.11 ms (3.47%)	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.94 ms (2.93%)	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.93 ms (2.89%)	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.88 ms (2.75%)	1	SELECT DISTINCT id_16 FROM (SELECT DISTINCT id_16, position_3 FROM (SELECT a0_.name AS name_0, a0_.description AS description_1, a0_.slug AS slug_2, a0_.position AS position_3, a0_.status AS status_4, a0_.phone_number AS phone_number_5, a0_.address AS address_6, a0_.email AS email_7, a0_.customer_service AS customer_service_8, a0_.swift_code AS swift_code_9, a0_.zip_code AS zip_code_10, a0_.regular_address AS regular_address_11, a0_.hours AS hours_12, a0_.longitude AS longitude_13, a0_.latitude AS latitude_14, a0_.is_main AS is_main_15, a0_.id AS id_16, a0_.date_add AS date_add_17, a0_.date_upd AS date_upd_18, a0_.deleted AS deleted_19, a0_.locked AS locked_20, a0_.is_draft AS is_draft_21, a0_.can_be_deleted AS can_be_deleted_22, a0_.owner_organization_id AS owner_organization_id_23, a1_.address AS address_24, a1_.regular_address AS regular_address_25, a1_.footer_address AS footer_address_26, a1_.hours AS hours_27, a1_.id AS id_28, a1_.locale AS locale_29, a1_.name AS name_30, a1_.description AS description_31, a1_.meta_description AS meta_description_32, a1_.work_keys AS work_keys_33, a1_.slug AS slug_34 FROM app_business_agency a0_ INNER JOIN app_business_agency_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.deleted = 0) dctrn_result_inner ORDER BY position_3 ASC) dctrn_result LIMIT 10 Parameters: [] View formatted query View runnable query Explain query SELECT DISTINCT id_16 FROM ( SELECT DISTINCT id_16, position_3 FROM ( SELECT a0_.name AS name_0, a0_.description AS description_1, a0_.slug AS slug_2, a0_.position AS position_3, a0_.status AS status_4, a0_.phone_number AS phone_number_5, a0_.address AS address_6, a0_.email AS email_7, a0_.customer_service AS customer_service_8, a0_.swift_code AS swift_code_9, a0_.zip_code AS zip_code_10, a0_.regular_address AS regular_address_11, a0_.hours AS hours_12, a0_.longitude AS longitude_13, a0_.latitude AS latitude_14, a0_.is_main AS is_main_15, a0_.id AS id_16, a0_.date_add AS date_add_17, a0_.date_upd AS date_upd_18, a0_.deleted AS deleted_19, a0_.locked AS locked_20, a0_.is_draft AS is_draft_21, a0_.can_be_deleted AS can_be_deleted_22, a0_.owner_organization_id AS owner_organization_id_23, a1_.address AS address_24, a1_.regular_address AS regular_address_25, a1_.footer_address AS footer_address_26, a1_.hours AS hours_27, a1_.id AS id_28, a1_.locale AS locale_29, a1_.name AS name_30, a1_.description AS description_31, a1_.meta_description AS meta_description_32, a1_.work_keys AS work_keys_33, a1_.slug AS slug_34 FROM app_business_agency a0_ INNER JOIN app_business_agency_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.deleted = 0 ) dctrn_result_inner ORDER BY position_3 ASC ) dctrn_result LIMIT 10 SELECT DISTINCT id_16 FROM (SELECT DISTINCT id_16, position_3 FROM (SELECT a0_.name AS name_0, a0_.description AS description_1, a0_.slug AS slug_2, a0_.position AS position_3, a0_.status AS status_4, a0_.phone_number AS phone_number_5, a0_.address AS address_6, a0_.email AS email_7, a0_.customer_service AS customer_service_8, a0_.swift_code AS swift_code_9, a0_.zip_code AS zip_code_10, a0_.regular_address AS regular_address_11, a0_.hours AS hours_12, a0_.longitude AS longitude_13, a0_.latitude AS latitude_14, a0_.is_main AS is_main_15, a0_.id AS id_16, a0_.date_add AS date_add_17, a0_.date_upd AS date_upd_18, a0_.deleted AS deleted_19, a0_.locked AS locked_20, a0_.is_draft AS is_draft_21, a0_.can_be_deleted AS can_be_deleted_22, a0_.owner_organization_id AS owner_organization_id_23, a1_.address AS address_24, a1_.regular_address AS regular_address_25, a1_.footer_address AS footer_address_26, a1_.hours AS hours_27, a1_.id AS id_28, a1_.locale AS locale_29, a1_.name AS name_30, a1_.description AS description_31, a1_.meta_description AS meta_description_32, a1_.work_keys AS work_keys_33, a1_.slug AS slug_34 FROM app_business_agency a0_ INNER JOIN app_business_agency_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.deleted = 0) dctrn_result_inner ORDER BY position_3 ASC) dctrn_result LIMIT 10;
0.85 ms (2.64%)	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.81 ms (2.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: [`23`] 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 (23);
0.78 ms (2.43%)	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.75 ms (2.34%)	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.74 ms (2.30%)	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.69 ms (2.15%)	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 25 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, 25, 26);
0.65 ms (2.02%)	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.64 ms (2.01%)	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.60 ms (1.87%)	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.60 ms (1.87%)	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 211 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, 211, 214);
0.58 ms (1.82%)	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.52 ms (1.63%)	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.51 ms (1.59%)	1	SELECT COUNT() AS dctrn_count FROM (SELECT DISTINCT id_16 FROM (SELECT a0_.name AS name_0, a0_.description AS description_1, a0_.slug AS slug_2, a0_.position AS position_3, a0_.status AS status_4, a0_.phone_number AS phone_number_5, a0_.address AS address_6, a0_.email AS email_7, a0_.customer_service AS customer_service_8, a0_.swift_code AS swift_code_9, a0_.zip_code AS zip_code_10, a0_.regular_address AS regular_address_11, a0_.hours AS hours_12, a0_.longitude AS longitude_13, a0_.latitude AS latitude_14, a0_.is_main AS is_main_15, a0_.id AS id_16, a0_.date_add AS date_add_17, a0_.date_upd AS date_upd_18, a0_.deleted AS deleted_19, a0_.locked AS locked_20, a0_.is_draft AS is_draft_21, a0_.can_be_deleted AS can_be_deleted_22, a0_.owner_organization_id AS owner_organization_id_23, a1_.address AS address_24, a1_.regular_address AS regular_address_25, a1_.footer_address AS footer_address_26, a1_.hours AS hours_27, a1_.id AS id_28, a1_.locale AS locale_29, a1_.name AS name_30, a1_.description AS description_31, a1_.meta_description AS meta_description_32, a1_.work_keys AS work_keys_33, a1_.slug AS slug_34 FROM app_business_agency a0_ INNER JOIN app_business_agency_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' 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_16 FROM ( SELECT a0_.name AS name_0, a0_.description AS description_1, a0_.slug AS slug_2, a0_.position AS position_3, a0_.status AS status_4, a0_.phone_number AS phone_number_5, a0_.address AS address_6, a0_.email AS email_7, a0_.customer_service AS customer_service_8, a0_.swift_code AS swift_code_9, a0_.zip_code AS zip_code_10, a0_.regular_address AS regular_address_11, a0_.hours AS hours_12, a0_.longitude AS longitude_13, a0_.latitude AS latitude_14, a0_.is_main AS is_main_15, a0_.id AS id_16, a0_.date_add AS date_add_17, a0_.date_upd AS date_upd_18, a0_.deleted AS deleted_19, a0_.locked AS locked_20, a0_.is_draft AS is_draft_21, a0_.can_be_deleted AS can_be_deleted_22, a0_.owner_organization_id AS owner_organization_id_23, a1_.address AS address_24, a1_.regular_address AS regular_address_25, a1_.footer_address AS footer_address_26, a1_.hours AS hours_27, a1_.id AS id_28, a1_.locale AS locale_29, a1_.name AS name_30, a1_.description AS description_31, a1_.meta_description AS meta_description_32, a1_.work_keys AS work_keys_33, a1_.slug AS slug_34 FROM app_business_agency a0_ INNER JOIN app_business_agency_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.deleted = 0 ORDER BY a0_.position ASC ) dctrn_result ) dctrn_table SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_16 FROM (SELECT a0_.name AS name_0, a0_.description AS description_1, a0_.slug AS slug_2, a0_.position AS position_3, a0_.status AS status_4, a0_.phone_number AS phone_number_5, a0_.address AS address_6, a0_.email AS email_7, a0_.customer_service AS customer_service_8, a0_.swift_code AS swift_code_9, a0_.zip_code AS zip_code_10, a0_.regular_address AS regular_address_11, a0_.hours AS hours_12, a0_.longitude AS longitude_13, a0_.latitude AS latitude_14, a0_.is_main AS is_main_15, a0_.id AS id_16, a0_.date_add AS date_add_17, a0_.date_upd AS date_upd_18, a0_.deleted AS deleted_19, a0_.locked AS locked_20, a0_.is_draft AS is_draft_21, a0_.can_be_deleted AS can_be_deleted_22, a0_.owner_organization_id AS owner_organization_id_23, a1_.address AS address_24, a1_.regular_address AS regular_address_25, a1_.footer_address AS footer_address_26, a1_.hours AS hours_27, a1_.id AS id_28, a1_.locale AS locale_29, a1_.name AS name_30, a1_.description AS description_31, a1_.meta_description AS meta_description_32, a1_.work_keys AS work_keys_33, a1_.slug AS slug_34 FROM app_business_agency a0_ INNER JOIN app_business_agency_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.deleted = 0 ORDER BY a0_.position ASC) dctrn_result) dctrn_table;
0.48 ms (1.50%)	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.39 ms (1.22%)	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.38 ms (1.20%)	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;
0.33 ms (1.03%)	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;

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\Website	No errors.
App\Core\Entity\AbstractEntityI18n	No errors.
App\Business\Entity\WebsiteI18n	No errors.
App\Core\Entity\Parameter	No errors.
App\Business\Entity\Category	No errors.
App\Business\Entity\CategoryI18n	No errors.
App\Business\Entity\Product	No errors.
App\Business\Entity\ProductI18n	No errors.
App\Business\Entity\Agency	No errors.
App\Business\Entity\AgencyI18n	No errors.

Symfony Profiler

GET https://bangebj.thebest-group.com/_fragment?_path=_format%3Dhtml%26_locale%3Dfr%26_controller%3DApp%255CBusiness%255CController%255CPublic%255CEmbedController%2…

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping