2.58 ms (37.84%)
1
SELECT d0_ . school_id AS school_id_0 , d0_ . school_name AS school_name_1 , d0_ . school_kana AS school_kana_2 , d0_ . school_order AS school_order_3 , d0_ . customer_selfdel_flg AS customer_selfdel_flg_4 , d0_ . school_email AS school_email_5 , d0_ . target_student AS target_student_6 , d0_ . online_flag AS online_flag_7 , d0_ . school_measuring_flag AS school_measuring_flag_8 , d0_ . store_measuring_flag AS store_measuring_flag_9 , d0_ . online_order_deadline AS online_order_deadline_10 , d0_ . school_measuring_date AS school_measuring_date_11 , d0_ . store_measuring_deadline AS store_measuring_deadline_12 , d0_ . purchase_flag AS purchase_flag_13 , d0_ . online_order_start_date AS online_order_start_date_14 , d0_ . online_order_end_date AS online_order_end_date_15 , d0_ . members_registration_type AS members_registration_type_16 , d0_ . school_key AS school_key_17 , d0_ . visible_school_key AS visible_school_key_18 , d0_ . create_date AS create_date_19 , d0_ . update_date AS update_date_20 , d0_ . school_code AS school_code_21 , d0_ . entry_url AS entry_url_22 , d0_ . delivery_free_type AS delivery_free_type_23 , d0_ . delivery_free_amount AS delivery_free_amount_24 , d0_ . delivery_free_quantity AS delivery_free_quantity_25 , d0_ . measure_plugin_type AS measure_plugin_type_26 , d0_ . default_sex_products_filtering_flag AS default_sex_products_filtering_flag_27 , d0_ . measuring_registration_required_flag AS measuring_registration_required_flag_28 , d0_ . top_page_popup_flag AS top_page_popup_flag_29 , d0_ . reg_data_popup_flag AS reg_data_popup_flag_30 , d0_ . chat_bot_flag AS chat_bot_flag_31 , d0_ . measuring_data_confirmation_flag AS measuring_data_confirmation_flag_32 , d0_ . size_recommend_flag AS size_recommend_flag_33 , d0_ . item_visible_type AS item_visible_type_34 , d0_ . sale_start_date AS sale_start_date_35 , d0_ . sale_end_date AS sale_end_date_36 , d0_ . reservation_site_url AS reservation_site_url_37 , d0_ . name_notation AS name_notation_38 , d0_ . name01_entry_sample AS name01_entry_sample_39 , d0_ . name02_entry_sample AS name02_entry_sample_40 , d0_ . kana_notation AS kana_notation_41 , d0_ . kana01_entry_sample AS kana01_entry_sample_42 , d0_ . kana02_entry_sample AS kana02_entry_sample_43 , d0_ . name_visible_type AS name_visible_type_44 , d0_ . addr_notation AS addr_notation_45 , d0_ . zip01_entry_sample AS zip01_entry_sample_46 , d0_ . zip02_entry_sample AS zip02_entry_sample_47 , d0_ . addr01_entry_sample AS addr01_entry_sample_48 , d0_ . addr02_entry_sample AS addr02_entry_sample_49 , d0_ . addr_visible_type AS addr_visible_type_50 , d0_ . addr_visible_all AS addr_visible_all_51 , d0_ . tel_notation AS tel_notation_52 , d0_ . tel1_01_entry_sample AS tel1_01_entry_sample_53 , d0_ . tel1_02_entry_sample AS tel1_02_entry_sample_54 , d0_ . tel1_03_entry_sample AS tel1_03_entry_sample_55 , d0_ . tel01_visible_type AS tel01_visible_type_56 , d0_ . tel02_visible_type AS tel02_visible_type_57 , d0_ . tel2_notation AS tel2_notation_58 , d0_ . tel2_01_entry_sample AS tel2_01_entry_sample_59 , d0_ . tel2_02_entry_sample AS tel2_02_entry_sample_60 , d0_ . tel2_03_entry_sample AS tel2_03_entry_sample_61 , d0_ . email_notation AS email_notation_62 , d0_ . email_entry_sample AS email_entry_sample_63 , d0_ . email_visible_type AS email_visible_type_64 , d0_ . password_notation AS password_notation_65 , d0_ . password_entry_sample AS password_entry_sample_66 , d0_ . password_visible_type AS password_visible_type_67 , d0_ . adyear_visible_type AS adyear_visible_type_68 , d0_ . adyear_notation AS adyear_notation_69 , d0_ . adyear_entry_sample AS adyear_entry_sample_70 , d0_ . exam_number_visible_type AS exam_number_visible_type_71 , d0_ . exam_number_notation AS exam_number_notation_72 , d0_ . exam_number_entry_sample AS exam_number_entry_sample_73 , d0_ . prev_school_visible_type AS prev_school_visible_type_74 , d0_ . prev_school_notation AS prev_school_notation_75 , d0_ . prev_school_entry_sample AS prev_school_entry_sample_76 , d0_ . prev_year_class_visible_type AS prev_year_class_visible_type_77 , d0_ . prev_year_class_notation AS prev_year_class_notation_78 , d0_ . prev_year_entry_sample AS prev_year_entry_sample_79 , d0_ . prev_class_entry_sample AS prev_class_entry_sample_80 , d0_ . birth_visible_type AS birth_visible_type_81 , d0_ . birth_notation AS birth_notation_82 , d0_ . birth_entry_sample AS birth_entry_sample_83 , d0_ . parents_name_visible_type AS parents_name_visible_type_84 , d0_ . parents_name_notation AS parents_name_notation_85 , d0_ . parents_name01_entry_sample AS parents_name01_entry_sample_86 , d0_ . parents_name02_entry_sample AS parents_name02_entry_sample_87 , d0_ . parents_birth_visible_type AS parents_birth_visible_type_88 , d0_ . parents_birth_notation AS parents_birth_notation_89 , d0_ . parents_birth_entry_sample AS parents_birth_entry_sample_90 , d0_ . current_year_visible_type AS current_year_visible_type_91 , d0_ . current_year_class_notation AS current_year_class_notation_92 , d0_ . current_year_entry_sample AS current_year_entry_sample_93 , d0_ . current_class_notation AS current_class_notation_94 , d0_ . student_number_visible_type AS student_number_visible_type_95 , d0_ . student_number_notation AS student_number_notation_96 , d0_ . student_number_entry_sample AS student_number_entry_sample_97 , d0_ . freeitem1_visible_type AS freeitem1_visible_type_98 , d0_ . freeitem1_name AS freeitem1_name_99 , d0_ . freeitem1_notation AS freeitem1_notation_100 , d0_ . freeitem1_entry_sample AS freeitem1_entry_sample_101 , d0_ . freeitem2_visible_type AS freeitem2_visible_type_102 , d0_ . freeitem2_name AS freeitem2_name_103 , d0_ . freeitem2_notation AS freeitem2_notation_104 , d0_ . freeitem2_entry_sample AS freeitem2_entry_sample_105 , d0_ . sex_visible_type AS sex_visible_type_106 , d0_ . fax_visible_type AS fax_visible_type_107 , d0_ . measure_height_visible_type AS measure_height_visible_type_108 , d0_ . measure_weight_visible_type AS measure_weight_visible_type_109 , d0_ . measure_shoulder_visible_type AS measure_shoulder_visible_type_110 , d0_ . measure_sleeve1_visible_type AS measure_sleeve1_visible_type_111 , d0_ . measure_sleeve2_visible_type AS measure_sleeve2_visible_type_112 , d0_ . measure_total_visible_type AS measure_total_visible_type_113 , d0_ . measure_neck_visible_type AS measure_neck_visible_type_114 , d0_ . measure_bust_visible_type AS measure_bust_visible_type_115 , d0_ . measure_waist_visible_type AS measure_waist_visible_type_116 , d0_ . measure_hips_visible_type AS measure_hips_visible_type_117 , d0_ . measure_inseam_visible_type AS measure_inseam_visible_type_118 , d0_ . measure_skirt_visible_type AS measure_skirt_visible_type_119 , d0_ . measure_slacks_visible_type AS measure_slacks_visible_type_120 , d0_ . enter_year_class AS enter_year_class_121 , d0_ . visible_commodity_alert AS visible_commodity_alert_122 , d0_ . visible_flg AS visible_flg_123 , d0_ . brother_flg AS brother_flg_124 , d0_ . require_school_key AS require_school_key_125 , d0_ . require_brothers AS require_brothers_126 , d0_ . product_sexvisible_type AS product_sexvisible_type_127 , d0_ . report_measure_flag AS report_measure_flag_128 , d0_ . report_grade_flag AS report_grade_flag_129 , d0_ . report_class_flag AS report_class_flag_130 , d0_ . report_storemail_flag AS report_storemail_flag_131 , d0_ . report_tax_flag AS report_tax_flag_132 , d0_ . order_delivery_notation AS order_delivery_notation_133 , d0_ . order_payment_notation AS order_payment_notation_134 , d0_ . addr01_max_length AS addr01_max_length_135 , d0_ . addr02_max_length AS addr02_max_length_136 , d0_ . discriminator_type AS discriminator_type_137 , d0_ . recommend_id AS recommend_id_138 FROM dtb_school d0_ WHERE (d0_ . visible_flg = 1 ) AND d0_ . discriminator_type IN ('school' ) ORDER BY d0_ . school_order ASC
SELECT
d0_ . school_id AS school_id_0 ,
d0_ . school_name AS school_name_1 ,
d0_ . school_kana AS school_kana_2 ,
d0_ . school_order AS school_order_3 ,
d0_ . customer_selfdel_flg AS customer_selfdel_flg_4 ,
d0_ . school_email AS school_email_5 ,
d0_ . target_student AS target_student_6 ,
d0_ . online_flag AS online_flag_7 ,
d0_ . school_measuring_flag AS school_measuring_flag_8 ,
d0_ . store_measuring_flag AS store_measuring_flag_9 ,
d0_ . online_order_deadline AS online_order_deadline_10 ,
d0_ . school_measuring_date AS school_measuring_date_11 ,
d0_ . store_measuring_deadline AS store_measuring_deadline_12 ,
d0_ . purchase_flag AS purchase_flag_13 ,
d0_ . online_order_start_date AS online_order_start_date_14 ,
d0_ . online_order_end_date AS online_order_end_date_15 ,
d0_ . members_registration_type AS members_registration_type_16 ,
d0_ . school_key AS school_key_17 ,
d0_ . visible_school_key AS visible_school_key_18 ,
d0_ . create_date AS create_date_19 ,
d0_ . update_date AS update_date_20 ,
d0_ . school_code AS school_code_21 ,
d0_ . entry_url AS entry_url_22 ,
d0_ . delivery_free_type AS delivery_free_type_23 ,
d0_ . delivery_free_amount AS delivery_free_amount_24 ,
d0_ . delivery_free_quantity AS delivery_free_quantity_25 ,
d0_ . measure_plugin_type AS measure_plugin_type_26 ,
d0_ . default_sex_products_filtering_flag AS default_sex_products_filtering_flag_27 ,
d0_ . measuring_registration_required_flag AS measuring_registration_required_flag_28 ,
d0_ . top_page_popup_flag AS top_page_popup_flag_29 ,
d0_ . reg_data_popup_flag AS reg_data_popup_flag_30 ,
d0_ . chat_bot_flag AS chat_bot_flag_31 ,
d0_ . measuring_data_confirmation_flag AS measuring_data_confirmation_flag_32 ,
d0_ . size_recommend_flag AS size_recommend_flag_33 ,
d0_ . item_visible_type AS item_visible_type_34 ,
d0_ . sale_start_date AS sale_start_date_35 ,
d0_ . sale_end_date AS sale_end_date_36 ,
d0_ . reservation_site_url AS reservation_site_url_37 ,
d0_ . name_notation AS name_notation_38 ,
d0_ . name01_entry_sample AS name01_entry_sample_39 ,
d0_ . name02_entry_sample AS name02_entry_sample_40 ,
d0_ . kana_notation AS kana_notation_41 ,
d0_ . kana01_entry_sample AS kana01_entry_sample_42 ,
d0_ . kana02_entry_sample AS kana02_entry_sample_43 ,
d0_ . name_visible_type AS name_visible_type_44 ,
d0_ . addr_notation AS addr_notation_45 ,
d0_ . zip01_entry_sample AS zip01_entry_sample_46 ,
d0_ . zip02_entry_sample AS zip02_entry_sample_47 ,
d0_ . addr01_entry_sample AS addr01_entry_sample_48 ,
d0_ . addr02_entry_sample AS addr02_entry_sample_49 ,
d0_ . addr_visible_type AS addr_visible_type_50 ,
d0_ . addr_visible_all AS addr_visible_all_51 ,
d0_ . tel_notation AS tel_notation_52 ,
d0_ . tel1_01_entry_sample AS tel1_01_entry_sample_53 ,
d0_ . tel1_02_entry_sample AS tel1_02_entry_sample_54 ,
d0_ . tel1_03_entry_sample AS tel1_03_entry_sample_55 ,
d0_ . tel01_visible_type AS tel01_visible_type_56 ,
d0_ . tel02_visible_type AS tel02_visible_type_57 ,
d0_ . tel2_notation AS tel2_notation_58 ,
d0_ . tel2_01_entry_sample AS tel2_01_entry_sample_59 ,
d0_ . tel2_02_entry_sample AS tel2_02_entry_sample_60 ,
d0_ . tel2_03_entry_sample AS tel2_03_entry_sample_61 ,
d0_ . email_notation AS email_notation_62 ,
d0_ . email_entry_sample AS email_entry_sample_63 ,
d0_ . email_visible_type AS email_visible_type_64 ,
d0_ . password_notation AS password_notation_65 ,
d0_ . password_entry_sample AS password_entry_sample_66 ,
d0_ . password_visible_type AS password_visible_type_67 ,
d0_ . adyear_visible_type AS adyear_visible_type_68 ,
d0_ . adyear_notation AS adyear_notation_69 ,
d0_ . adyear_entry_sample AS adyear_entry_sample_70 ,
d0_ . exam_number_visible_type AS exam_number_visible_type_71 ,
d0_ . exam_number_notation AS exam_number_notation_72 ,
d0_ . exam_number_entry_sample AS exam_number_entry_sample_73 ,
d0_ . prev_school_visible_type AS prev_school_visible_type_74 ,
d0_ . prev_school_notation AS prev_school_notation_75 ,
d0_ . prev_school_entry_sample AS prev_school_entry_sample_76 ,
d0_ . prev_year_class_visible_type AS prev_year_class_visible_type_77 ,
d0_ . prev_year_class_notation AS prev_year_class_notation_78 ,
d0_ . prev_year_entry_sample AS prev_year_entry_sample_79 ,
d0_ . prev_class_entry_sample AS prev_class_entry_sample_80 ,
d0_ . birth_visible_type AS birth_visible_type_81 ,
d0_ . birth_notation AS birth_notation_82 ,
d0_ . birth_entry_sample AS birth_entry_sample_83 ,
d0_ . parents_name_visible_type AS parents_name_visible_type_84 ,
d0_ . parents_name_notation AS parents_name_notation_85 ,
d0_ . parents_name01_entry_sample AS parents_name01_entry_sample_86 ,
d0_ . parents_name02_entry_sample AS parents_name02_entry_sample_87 ,
d0_ . parents_birth_visible_type AS parents_birth_visible_type_88 ,
d0_ . parents_birth_notation AS parents_birth_notation_89 ,
d0_ . parents_birth_entry_sample AS parents_birth_entry_sample_90 ,
d0_ . current_year_visible_type AS current_year_visible_type_91 ,
d0_ . current_year_class_notation AS current_year_class_notation_92 ,
d0_ . current_year_entry_sample AS current_year_entry_sample_93 ,
d0_ . current_class_notation AS current_class_notation_94 ,
d0_ . student_number_visible_type AS student_number_visible_type_95 ,
d0_ . student_number_notation AS student_number_notation_96 ,
d0_ . student_number_entry_sample AS student_number_entry_sample_97 ,
d0_ . freeitem1_visible_type AS freeitem1_visible_type_98 ,
d0_ . freeitem1_name AS freeitem1_name_99 ,
d0_ . freeitem1_notation AS freeitem1_notation_100 ,
d0_ . freeitem1_entry_sample AS freeitem1_entry_sample_101 ,
d0_ . freeitem2_visible_type AS freeitem2_visible_type_102 ,
d0_ . freeitem2_name AS freeitem2_name_103 ,
d0_ . freeitem2_notation AS freeitem2_notation_104 ,
d0_ . freeitem2_entry_sample AS freeitem2_entry_sample_105 ,
d0_ . sex_visible_type AS sex_visible_type_106 ,
d0_ . fax_visible_type AS fax_visible_type_107 ,
d0_ . measure_height_visible_type AS measure_height_visible_type_108 ,
d0_ . measure_weight_visible_type AS measure_weight_visible_type_109 ,
d0_ . measure_shoulder_visible_type AS measure_shoulder_visible_type_110 ,
d0_ . measure_sleeve1_visible_type AS measure_sleeve1_visible_type_111 ,
d0_ . measure_sleeve2_visible_type AS measure_sleeve2_visible_type_112 ,
d0_ . measure_total_visible_type AS measure_total_visible_type_113 ,
d0_ . measure_neck_visible_type AS measure_neck_visible_type_114 ,
d0_ . measure_bust_visible_type AS measure_bust_visible_type_115 ,
d0_ . measure_waist_visible_type AS measure_waist_visible_type_116 ,
d0_ . measure_hips_visible_type AS measure_hips_visible_type_117 ,
d0_ . measure_inseam_visible_type AS measure_inseam_visible_type_118 ,
d0_ . measure_skirt_visible_type AS measure_skirt_visible_type_119 ,
d0_ . measure_slacks_visible_type AS measure_slacks_visible_type_120 ,
d0_ . enter_year_class AS enter_year_class_121 ,
d0_ . visible_commodity_alert AS visible_commodity_alert_122 ,
d0_ . visible_flg AS visible_flg_123 ,
d0_ . brother_flg AS brother_flg_124 ,
d0_ . require_school_key AS require_school_key_125 ,
d0_ . require_brothers AS require_brothers_126 ,
d0_ . product_sexvisible_type AS product_sexvisible_type_127 ,
d0_ . report_measure_flag AS report_measure_flag_128 ,
d0_ . report_grade_flag AS report_grade_flag_129 ,
d0_ . report_class_flag AS report_class_flag_130 ,
d0_ . report_storemail_flag AS report_storemail_flag_131 ,
d0_ . report_tax_flag AS report_tax_flag_132 ,
d0_ . order_delivery_notation AS order_delivery_notation_133 ,
d0_ . order_payment_notation AS order_payment_notation_134 ,
d0_ . addr01_max_length AS addr01_max_length_135 ,
d0_ . addr02_max_length AS addr02_max_length_136 ,
d0_ . discriminator_type AS discriminator_type_137 ,
d0_ . recommend_id AS recommend_id_138
FROM
dtb_school d0_
WHERE
(d0_ . visible_flg = 1 )
AND d0_ . discriminator_type IN ('school' )
ORDER BY
d0_ . school_order ASC
Copy
SELECT d0_ . school_id AS school_id_0 , d0_ . school_name AS school_name_1 , d0_ . school_kana AS school_kana_2 , d0_ . school_order AS school_order_3 , d0_ . customer_selfdel_flg AS customer_selfdel_flg_4 , d0_ . school_email AS school_email_5 , d0_ . target_student AS target_student_6 , d0_ . online_flag AS online_flag_7 , d0_ . school_measuring_flag AS school_measuring_flag_8 , d0_ . store_measuring_flag AS store_measuring_flag_9 , d0_ . online_order_deadline AS online_order_deadline_10 , d0_ . school_measuring_date AS school_measuring_date_11 , d0_ . store_measuring_deadline AS store_measuring_deadline_12 , d0_ . purchase_flag AS purchase_flag_13 , d0_ . online_order_start_date AS online_order_start_date_14 , d0_ . online_order_end_date AS online_order_end_date_15 , d0_ . members_registration_type AS members_registration_type_16 , d0_ . school_key AS school_key_17 , d0_ . visible_school_key AS visible_school_key_18 , d0_ . create_date AS create_date_19 , d0_ . update_date AS update_date_20 , d0_ . school_code AS school_code_21 , d0_ . entry_url AS entry_url_22 , d0_ . delivery_free_type AS delivery_free_type_23 , d0_ . delivery_free_amount AS delivery_free_amount_24 , d0_ . delivery_free_quantity AS delivery_free_quantity_25 , d0_ . measure_plugin_type AS measure_plugin_type_26 , d0_ . default_sex_products_filtering_flag AS default_sex_products_filtering_flag_27 , d0_ . measuring_registration_required_flag AS measuring_registration_required_flag_28 , d0_ . top_page_popup_flag AS top_page_popup_flag_29 , d0_ . reg_data_popup_flag AS reg_data_popup_flag_30 , d0_ . chat_bot_flag AS chat_bot_flag_31 , d0_ . measuring_data_confirmation_flag AS measuring_data_confirmation_flag_32 , d0_ . size_recommend_flag AS size_recommend_flag_33 , d0_ . item_visible_type AS item_visible_type_34 , d0_ . sale_start_date AS sale_start_date_35 , d0_ . sale_end_date AS sale_end_date_36 , d0_ . reservation_site_url AS reservation_site_url_37 , d0_ . name_notation AS name_notation_38 , d0_ . name01_entry_sample AS name01_entry_sample_39 , d0_ . name02_entry_sample AS name02_entry_sample_40 , d0_ . kana_notation AS kana_notation_41 , d0_ . kana01_entry_sample AS kana01_entry_sample_42 , d0_ . kana02_entry_sample AS kana02_entry_sample_43 , d0_ . name_visible_type AS name_visible_type_44 , d0_ . addr_notation AS addr_notation_45 , d0_ . zip01_entry_sample AS zip01_entry_sample_46 , d0_ . zip02_entry_sample AS zip02_entry_sample_47 , d0_ . addr01_entry_sample AS addr01_entry_sample_48 , d0_ . addr02_entry_sample AS addr02_entry_sample_49 , d0_ . addr_visible_type AS addr_visible_type_50 , d0_ . addr_visible_all AS addr_visible_all_51 , d0_ . tel_notation AS tel_notation_52 , d0_ . tel1_01_entry_sample AS tel1_01_entry_sample_53 , d0_ . tel1_02_entry_sample AS tel1_02_entry_sample_54 , d0_ . tel1_03_entry_sample AS tel1_03_entry_sample_55 , d0_ . tel01_visible_type AS tel01_visible_type_56 , d0_ . tel02_visible_type AS tel02_visible_type_57 , d0_ . tel2_notation AS tel2_notation_58 , d0_ . tel2_01_entry_sample AS tel2_01_entry_sample_59 , d0_ . tel2_02_entry_sample AS tel2_02_entry_sample_60 , d0_ . tel2_03_entry_sample AS tel2_03_entry_sample_61 , d0_ . email_notation AS email_notation_62 , d0_ . email_entry_sample AS email_entry_sample_63 , d0_ . email_visible_type AS email_visible_type_64 , d0_ . password_notation AS password_notation_65 , d0_ . password_entry_sample AS password_entry_sample_66 , d0_ . password_visible_type AS password_visible_type_67 , d0_ . adyear_visible_type AS adyear_visible_type_68 , d0_ . adyear_notation AS adyear_notation_69 , d0_ . adyear_entry_sample AS adyear_entry_sample_70 , d0_ . exam_number_visible_type AS exam_number_visible_type_71 , d0_ . exam_number_notation AS exam_number_notation_72 , d0_ . exam_number_entry_sample AS exam_number_entry_sample_73 , d0_ . prev_school_visible_type AS prev_school_visible_type_74 , d0_ . prev_school_notation AS prev_school_notation_75 , d0_ . prev_school_entry_sample AS prev_school_entry_sample_76 , d0_ . prev_year_class_visible_type AS prev_year_class_visible_type_77 , d0_ . prev_year_class_notation AS prev_year_class_notation_78 , d0_ . prev_year_entry_sample AS prev_year_entry_sample_79 , d0_ . prev_class_entry_sample AS prev_class_entry_sample_80 , d0_ . birth_visible_type AS birth_visible_type_81 , d0_ . birth_notation AS birth_notation_82 , d0_ . birth_entry_sample AS birth_entry_sample_83 , d0_ . parents_name_visible_type AS parents_name_visible_type_84 , d0_ . parents_name_notation AS parents_name_notation_85 , d0_ . parents_name01_entry_sample AS parents_name01_entry_sample_86 , d0_ . parents_name02_entry_sample AS parents_name02_entry_sample_87 , d0_ . parents_birth_visible_type AS parents_birth_visible_type_88 , d0_ . parents_birth_notation AS parents_birth_notation_89 , d0_ . parents_birth_entry_sample AS parents_birth_entry_sample_90 , d0_ . current_year_visible_type AS current_year_visible_type_91 , d0_ . current_year_class_notation AS current_year_class_notation_92 , d0_ . current_year_entry_sample AS current_year_entry_sample_93 , d0_ . current_class_notation AS current_class_notation_94 , d0_ . student_number_visible_type AS student_number_visible_type_95 , d0_ . student_number_notation AS student_number_notation_96 , d0_ . student_number_entry_sample AS student_number_entry_sample_97 , d0_ . freeitem1_visible_type AS freeitem1_visible_type_98 , d0_ . freeitem1_name AS freeitem1_name_99 , d0_ . freeitem1_notation AS freeitem1_notation_100 , d0_ . freeitem1_entry_sample AS freeitem1_entry_sample_101 , d0_ . freeitem2_visible_type AS freeitem2_visible_type_102 , d0_ . freeitem2_name AS freeitem2_name_103 , d0_ . freeitem2_notation AS freeitem2_notation_104 , d0_ . freeitem2_entry_sample AS freeitem2_entry_sample_105 , d0_ . sex_visible_type AS sex_visible_type_106 , d0_ . fax_visible_type AS fax_visible_type_107 , d0_ . measure_height_visible_type AS measure_height_visible_type_108 , d0_ . measure_weight_visible_type AS measure_weight_visible_type_109 , d0_ . measure_shoulder_visible_type AS measure_shoulder_visible_type_110 , d0_ . measure_sleeve1_visible_type AS measure_sleeve1_visible_type_111 , d0_ . measure_sleeve2_visible_type AS measure_sleeve2_visible_type_112 , d0_ . measure_total_visible_type AS measure_total_visible_type_113 , d0_ . measure_neck_visible_type AS measure_neck_visible_type_114 , d0_ . measure_bust_visible_type AS measure_bust_visible_type_115 , d0_ . measure_waist_visible_type AS measure_waist_visible_type_116 , d0_ . measure_hips_visible_type AS measure_hips_visible_type_117 , d0_ . measure_inseam_visible_type AS measure_inseam_visible_type_118 , d0_ . measure_skirt_visible_type AS measure_skirt_visible_type_119 , d0_ . measure_slacks_visible_type AS measure_slacks_visible_type_120 , d0_ . enter_year_class AS enter_year_class_121 , d0_ . visible_commodity_alert AS visible_commodity_alert_122 , d0_ . visible_flg AS visible_flg_123 , d0_ . brother_flg AS brother_flg_124 , d0_ . require_school_key AS require_school_key_125 , d0_ . require_brothers AS require_brothers_126 , d0_ . product_sexvisible_type AS product_sexvisible_type_127 , d0_ . report_measure_flag AS report_measure_flag_128 , d0_ . report_grade_flag AS report_grade_flag_129 , d0_ . report_class_flag AS report_class_flag_130 , d0_ . report_storemail_flag AS report_storemail_flag_131 , d0_ . report_tax_flag AS report_tax_flag_132 , d0_ . order_delivery_notation AS order_delivery_notation_133 , d0_ . order_payment_notation AS order_payment_notation_134 , d0_ . addr01_max_length AS addr01_max_length_135 , d0_ . addr02_max_length AS addr02_max_length_136 , d0_ . discriminator_type AS discriminator_type_137 , d0_ . recommend_id AS recommend_id_138 FROM dtb_school d0_ WHERE (d0_ . visible_flg = 1 ) AND d0_ . discriminator_type IN ('school' ) ORDER BY d0_ . school_order ASC ;
Copy
1.43 ms (20.98%)
1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . sort_no AS sort_no_3 , t0 . discriminator_type FROM mtb_customer_status t0 WHERE t0 . id = ? AND t0 . discriminator_type IN ('customerstatus' )
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . sort_no AS sort_no_3 , t0 . discriminator_type FROM mtb_customer_status t0 WHERE t0 . id = 1 AND t0 . discriminator_type IN ('customerstatus' );
Copy
0.84 ms (12.31%)
1
SELECT t0 . school_id AS school_id_1 , t0 . school_name AS school_name_2 , t0 . school_kana AS school_kana_3 , t0 . school_order AS school_order_4 , t0 . customer_selfdel_flg AS customer_selfdel_flg_5 , t0 . school_email AS school_email_6 , t0 . target_student AS target_student_7 , t0 . online_flag AS online_flag_8 , t0 . school_measuring_flag AS school_measuring_flag_9 , t0 . store_measuring_flag AS store_measuring_flag_10 , t0 . online_order_deadline AS online_order_deadline_11 , t0 . school_measuring_date AS school_measuring_date_12 , t0 . store_measuring_deadline AS store_measuring_deadline_13 , t0 . purchase_flag AS purchase_flag_14 , t0 . online_order_start_date AS online_order_start_date_15 , t0 . online_order_end_date AS online_order_end_date_16 , t0 . members_registration_type AS members_registration_type_17 , t0 . school_key AS school_key_18 , t0 . visible_school_key AS visible_school_key_19 , t0 . create_date AS create_date_20 , t0 . update_date AS update_date_21 , t0 . school_code AS school_code_22 , t0 . entry_url AS entry_url_23 , t0 . delivery_free_type AS delivery_free_type_24 , t0 . delivery_free_amount AS delivery_free_amount_25 , t0 . delivery_free_quantity AS delivery_free_quantity_26 , t0 . measure_plugin_type AS measure_plugin_type_27 , t0 . default_sex_products_filtering_flag AS default_sex_products_filtering_flag_28 , t0 . measuring_registration_required_flag AS measuring_registration_required_flag_29 , t0 . top_page_popup_flag AS top_page_popup_flag_30 , t0 . reg_data_popup_flag AS reg_data_popup_flag_31 , t0 . chat_bot_flag AS chat_bot_flag_32 , t0 . measuring_data_confirmation_flag AS measuring_data_confirmation_flag_33 , t0 . size_recommend_flag AS size_recommend_flag_34 , t0 . item_visible_type AS item_visible_type_35 , t0 . sale_start_date AS sale_start_date_36 , t0 . sale_end_date AS sale_end_date_37 , t0 . reservation_site_url AS reservation_site_url_38 , t0 . name_notation AS name_notation_39 , t0 . name01_entry_sample AS name01_entry_sample_40 , t0 . name02_entry_sample AS name02_entry_sample_41 , t0 . kana_notation AS kana_notation_42 , t0 . kana01_entry_sample AS kana01_entry_sample_43 , t0 . kana02_entry_sample AS kana02_entry_sample_44 , t0 . name_visible_type AS name_visible_type_45 , t0 . addr_notation AS addr_notation_46 , t0 . zip01_entry_sample AS zip01_entry_sample_47 , t0 . zip02_entry_sample AS zip02_entry_sample_48 , t0 . addr01_entry_sample AS addr01_entry_sample_49 , t0 . addr02_entry_sample AS addr02_entry_sample_50 , t0 . addr_visible_type AS addr_visible_type_51 , t0 . addr_visible_all AS addr_visible_all_52 , t0 . tel_notation AS tel_notation_53 , t0 . tel1_01_entry_sample AS tel1_01_entry_sample_54 , t0 . tel1_02_entry_sample AS tel1_02_entry_sample_55 , t0 . tel1_03_entry_sample AS tel1_03_entry_sample_56 , t0 . tel01_visible_type AS tel01_visible_type_57 , t0 . tel02_visible_type AS tel02_visible_type_58 , t0 . tel2_notation AS tel2_notation_59 , t0 . tel2_01_entry_sample AS tel2_01_entry_sample_60 , t0 . tel2_02_entry_sample AS tel2_02_entry_sample_61 , t0 . tel2_03_entry_sample AS tel2_03_entry_sample_62 , t0 . email_notation AS email_notation_63 , t0 . email_entry_sample AS email_entry_sample_64 , t0 . email_visible_type AS email_visible_type_65 , t0 . password_notation AS password_notation_66 , t0 . password_entry_sample AS password_entry_sample_67 , t0 . password_visible_type AS password_visible_type_68 , t0 . adyear_visible_type AS adyear_visible_type_69 , t0 . adyear_notation AS adyear_notation_70 , t0 . adyear_entry_sample AS adyear_entry_sample_71 , t0 . exam_number_visible_type AS exam_number_visible_type_72 , t0 . exam_number_notation AS exam_number_notation_73 , t0 . exam_number_entry_sample AS exam_number_entry_sample_74 , t0 . prev_school_visible_type AS prev_school_visible_type_75 , t0 . prev_school_notation AS prev_school_notation_76 , t0 . prev_school_entry_sample AS prev_school_entry_sample_77 , t0 . prev_year_class_visible_type AS prev_year_class_visible_type_78 , t0 . prev_year_class_notation AS prev_year_class_notation_79 , t0 . prev_year_entry_sample AS prev_year_entry_sample_80 , t0 . prev_class_entry_sample AS prev_class_entry_sample_81 , t0 . birth_visible_type AS birth_visible_type_82 , t0 . birth_notation AS birth_notation_83 , t0 . birth_entry_sample AS birth_entry_sample_84 , t0 . parents_name_visible_type AS parents_name_visible_type_85 , t0 . parents_name_notation AS parents_name_notation_86 , t0 . parents_name01_entry_sample AS parents_name01_entry_sample_87 , t0 . parents_name02_entry_sample AS parents_name02_entry_sample_88 , t0 . parents_birth_visible_type AS parents_birth_visible_type_89 , t0 . parents_birth_notation AS parents_birth_notation_90 , t0 . parents_birth_entry_sample AS parents_birth_entry_sample_91 , t0 . current_year_visible_type AS current_year_visible_type_92 , t0 . current_year_class_notation AS current_year_class_notation_93 , t0 . current_year_entry_sample AS current_year_entry_sample_94 , t0 . current_class_notation AS current_class_notation_95 , t0 . student_number_visible_type AS student_number_visible_type_96 , t0 . student_number_notation AS student_number_notation_97 , t0 . student_number_entry_sample AS student_number_entry_sample_98 , t0 . freeitem1_visible_type AS freeitem1_visible_type_99 , t0 . freeitem1_name AS freeitem1_name_100 , t0 . freeitem1_notation AS freeitem1_notation_101 , t0 . freeitem1_entry_sample AS freeitem1_entry_sample_102 , t0 . freeitem2_visible_type AS freeitem2_visible_type_103 , t0 . freeitem2_name AS freeitem2_name_104 , t0 . freeitem2_notation AS freeitem2_notation_105 , t0 . freeitem2_entry_sample AS freeitem2_entry_sample_106 , t0 . sex_visible_type AS sex_visible_type_107 , t0 . fax_visible_type AS fax_visible_type_108 , t0 . measure_height_visible_type AS measure_height_visible_type_109 , t0 . measure_weight_visible_type AS measure_weight_visible_type_110 , t0 . measure_shoulder_visible_type AS measure_shoulder_visible_type_111 , t0 . measure_sleeve1_visible_type AS measure_sleeve1_visible_type_112 , t0 . measure_sleeve2_visible_type AS measure_sleeve2_visible_type_113 , t0 . measure_total_visible_type AS measure_total_visible_type_114 , t0 . measure_neck_visible_type AS measure_neck_visible_type_115 , t0 . measure_bust_visible_type AS measure_bust_visible_type_116 , t0 . measure_waist_visible_type AS measure_waist_visible_type_117 , t0 . measure_hips_visible_type AS measure_hips_visible_type_118 , t0 . measure_inseam_visible_type AS measure_inseam_visible_type_119 , t0 . measure_skirt_visible_type AS measure_skirt_visible_type_120 , t0 . measure_slacks_visible_type AS measure_slacks_visible_type_121 , t0 . enter_year_class AS enter_year_class_122 , t0 . visible_commodity_alert AS visible_commodity_alert_123 , t0 . visible_flg AS visible_flg_124 , t0 . brother_flg AS brother_flg_125 , t0 . require_school_key AS require_school_key_126 , t0 . require_brothers AS require_brothers_127 , t0 . product_sexvisible_type AS product_sexvisible_type_128 , t0 . report_measure_flag AS report_measure_flag_129 , t0 . report_grade_flag AS report_grade_flag_130 , t0 . report_class_flag AS report_class_flag_131 , t0 . report_storemail_flag AS report_storemail_flag_132 , t0 . report_tax_flag AS report_tax_flag_133 , t0 . order_delivery_notation AS order_delivery_notation_134 , t0 . order_payment_notation AS order_payment_notation_135 , t0 . addr01_max_length AS addr01_max_length_136 , t0 . addr02_max_length AS addr02_max_length_137 , t0 . recommend_id AS recommend_id_138 , t0 . discriminator_type FROM dtb_school t0 WHERE t0 . discriminator_type IN ('school' )
SELECT
t0 . school_id AS school_id_1 ,
t0 . school_name AS school_name_2 ,
t0 . school_kana AS school_kana_3 ,
t0 . school_order AS school_order_4 ,
t0 . customer_selfdel_flg AS customer_selfdel_flg_5 ,
t0 . school_email AS school_email_6 ,
t0 . target_student AS target_student_7 ,
t0 . online_flag AS online_flag_8 ,
t0 . school_measuring_flag AS school_measuring_flag_9 ,
t0 . store_measuring_flag AS store_measuring_flag_10 ,
t0 . online_order_deadline AS online_order_deadline_11 ,
t0 . school_measuring_date AS school_measuring_date_12 ,
t0 . store_measuring_deadline AS store_measuring_deadline_13 ,
t0 . purchase_flag AS purchase_flag_14 ,
t0 . online_order_start_date AS online_order_start_date_15 ,
t0 . online_order_end_date AS online_order_end_date_16 ,
t0 . members_registration_type AS members_registration_type_17 ,
t0 . school_key AS school_key_18 ,
t0 . visible_school_key AS visible_school_key_19 ,
t0 . create_date AS create_date_20 ,
t0 . update_date AS update_date_21 ,
t0 . school_code AS school_code_22 ,
t0 . entry_url AS entry_url_23 ,
t0 . delivery_free_type AS delivery_free_type_24 ,
t0 . delivery_free_amount AS delivery_free_amount_25 ,
t0 . delivery_free_quantity AS delivery_free_quantity_26 ,
t0 . measure_plugin_type AS measure_plugin_type_27 ,
t0 . default_sex_products_filtering_flag AS default_sex_products_filtering_flag_28 ,
t0 . measuring_registration_required_flag AS measuring_registration_required_flag_29 ,
t0 . top_page_popup_flag AS top_page_popup_flag_30 ,
t0 . reg_data_popup_flag AS reg_data_popup_flag_31 ,
t0 . chat_bot_flag AS chat_bot_flag_32 ,
t0 . measuring_data_confirmation_flag AS measuring_data_confirmation_flag_33 ,
t0 . size_recommend_flag AS size_recommend_flag_34 ,
t0 . item_visible_type AS item_visible_type_35 ,
t0 . sale_start_date AS sale_start_date_36 ,
t0 . sale_end_date AS sale_end_date_37 ,
t0 . reservation_site_url AS reservation_site_url_38 ,
t0 . name_notation AS name_notation_39 ,
t0 . name01_entry_sample AS name01_entry_sample_40 ,
t0 . name02_entry_sample AS name02_entry_sample_41 ,
t0 . kana_notation AS kana_notation_42 ,
t0 . kana01_entry_sample AS kana01_entry_sample_43 ,
t0 . kana02_entry_sample AS kana02_entry_sample_44 ,
t0 . name_visible_type AS name_visible_type_45 ,
t0 . addr_notation AS addr_notation_46 ,
t0 . zip01_entry_sample AS zip01_entry_sample_47 ,
t0 . zip02_entry_sample AS zip02_entry_sample_48 ,
t0 . addr01_entry_sample AS addr01_entry_sample_49 ,
t0 . addr02_entry_sample AS addr02_entry_sample_50 ,
t0 . addr_visible_type AS addr_visible_type_51 ,
t0 . addr_visible_all AS addr_visible_all_52 ,
t0 . tel_notation AS tel_notation_53 ,
t0 . tel1_01_entry_sample AS tel1_01_entry_sample_54 ,
t0 . tel1_02_entry_sample AS tel1_02_entry_sample_55 ,
t0 . tel1_03_entry_sample AS tel1_03_entry_sample_56 ,
t0 . tel01_visible_type AS tel01_visible_type_57 ,
t0 . tel02_visible_type AS tel02_visible_type_58 ,
t0 . tel2_notation AS tel2_notation_59 ,
t0 . tel2_01_entry_sample AS tel2_01_entry_sample_60 ,
t0 . tel2_02_entry_sample AS tel2_02_entry_sample_61 ,
t0 . tel2_03_entry_sample AS tel2_03_entry_sample_62 ,
t0 . email_notation AS email_notation_63 ,
t0 . email_entry_sample AS email_entry_sample_64 ,
t0 . email_visible_type AS email_visible_type_65 ,
t0 . password_notation AS password_notation_66 ,
t0 . password_entry_sample AS password_entry_sample_67 ,
t0 . password_visible_type AS password_visible_type_68 ,
t0 . adyear_visible_type AS adyear_visible_type_69 ,
t0 . adyear_notation AS adyear_notation_70 ,
t0 . adyear_entry_sample AS adyear_entry_sample_71 ,
t0 . exam_number_visible_type AS exam_number_visible_type_72 ,
t0 . exam_number_notation AS exam_number_notation_73 ,
t0 . exam_number_entry_sample AS exam_number_entry_sample_74 ,
t0 . prev_school_visible_type AS prev_school_visible_type_75 ,
t0 . prev_school_notation AS prev_school_notation_76 ,
t0 . prev_school_entry_sample AS prev_school_entry_sample_77 ,
t0 . prev_year_class_visible_type AS prev_year_class_visible_type_78 ,
t0 . prev_year_class_notation AS prev_year_class_notation_79 ,
t0 . prev_year_entry_sample AS prev_year_entry_sample_80 ,
t0 . prev_class_entry_sample AS prev_class_entry_sample_81 ,
t0 . birth_visible_type AS birth_visible_type_82 ,
t0 . birth_notation AS birth_notation_83 ,
t0 . birth_entry_sample AS birth_entry_sample_84 ,
t0 . parents_name_visible_type AS parents_name_visible_type_85 ,
t0 . parents_name_notation AS parents_name_notation_86 ,
t0 . parents_name01_entry_sample AS parents_name01_entry_sample_87 ,
t0 . parents_name02_entry_sample AS parents_name02_entry_sample_88 ,
t0 . parents_birth_visible_type AS parents_birth_visible_type_89 ,
t0 . parents_birth_notation AS parents_birth_notation_90 ,
t0 . parents_birth_entry_sample AS parents_birth_entry_sample_91 ,
t0 . current_year_visible_type AS current_year_visible_type_92 ,
t0 . current_year_class_notation AS current_year_class_notation_93 ,
t0 . current_year_entry_sample AS current_year_entry_sample_94 ,
t0 . current_class_notation AS current_class_notation_95 ,
t0 . student_number_visible_type AS student_number_visible_type_96 ,
t0 . student_number_notation AS student_number_notation_97 ,
t0 . student_number_entry_sample AS student_number_entry_sample_98 ,
t0 . freeitem1_visible_type AS freeitem1_visible_type_99 ,
t0 . freeitem1_name AS freeitem1_name_100 ,
t0 . freeitem1_notation AS freeitem1_notation_101 ,
t0 . freeitem1_entry_sample AS freeitem1_entry_sample_102 ,
t0 . freeitem2_visible_type AS freeitem2_visible_type_103 ,
t0 . freeitem2_name AS freeitem2_name_104 ,
t0 . freeitem2_notation AS freeitem2_notation_105 ,
t0 . freeitem2_entry_sample AS freeitem2_entry_sample_106 ,
t0 . sex_visible_type AS sex_visible_type_107 ,
t0 . fax_visible_type AS fax_visible_type_108 ,
t0 . measure_height_visible_type AS measure_height_visible_type_109 ,
t0 . measure_weight_visible_type AS measure_weight_visible_type_110 ,
t0 . measure_shoulder_visible_type AS measure_shoulder_visible_type_111 ,
t0 . measure_sleeve1_visible_type AS measure_sleeve1_visible_type_112 ,
t0 . measure_sleeve2_visible_type AS measure_sleeve2_visible_type_113 ,
t0 . measure_total_visible_type AS measure_total_visible_type_114 ,
t0 . measure_neck_visible_type AS measure_neck_visible_type_115 ,
t0 . measure_bust_visible_type AS measure_bust_visible_type_116 ,
t0 . measure_waist_visible_type AS measure_waist_visible_type_117 ,
t0 . measure_hips_visible_type AS measure_hips_visible_type_118 ,
t0 . measure_inseam_visible_type AS measure_inseam_visible_type_119 ,
t0 . measure_skirt_visible_type AS measure_skirt_visible_type_120 ,
t0 . measure_slacks_visible_type AS measure_slacks_visible_type_121 ,
t0 . enter_year_class AS enter_year_class_122 ,
t0 . visible_commodity_alert AS visible_commodity_alert_123 ,
t0 . visible_flg AS visible_flg_124 ,
t0 . brother_flg AS brother_flg_125 ,
t0 . require_school_key AS require_school_key_126 ,
t0 . require_brothers AS require_brothers_127 ,
t0 . product_sexvisible_type AS product_sexvisible_type_128 ,
t0 . report_measure_flag AS report_measure_flag_129 ,
t0 . report_grade_flag AS report_grade_flag_130 ,
t0 . report_class_flag AS report_class_flag_131 ,
t0 . report_storemail_flag AS report_storemail_flag_132 ,
t0 . report_tax_flag AS report_tax_flag_133 ,
t0 . order_delivery_notation AS order_delivery_notation_134 ,
t0 . order_payment_notation AS order_payment_notation_135 ,
t0 . addr01_max_length AS addr01_max_length_136 ,
t0 . addr02_max_length AS addr02_max_length_137 ,
t0 . recommend_id AS recommend_id_138 ,
t0 . discriminator_type
FROM
dtb_school t0
WHERE
t0 . discriminator_type IN ('school' )
Copy
SELECT t0 . school_id AS school_id_1 , t0 . school_name AS school_name_2 , t0 . school_kana AS school_kana_3 , t0 . school_order AS school_order_4 , t0 . customer_selfdel_flg AS customer_selfdel_flg_5 , t0 . school_email AS school_email_6 , t0 . target_student AS target_student_7 , t0 . online_flag AS online_flag_8 , t0 . school_measuring_flag AS school_measuring_flag_9 , t0 . store_measuring_flag AS store_measuring_flag_10 , t0 . online_order_deadline AS online_order_deadline_11 , t0 . school_measuring_date AS school_measuring_date_12 , t0 . store_measuring_deadline AS store_measuring_deadline_13 , t0 . purchase_flag AS purchase_flag_14 , t0 . online_order_start_date AS online_order_start_date_15 , t0 . online_order_end_date AS online_order_end_date_16 , t0 . members_registration_type AS members_registration_type_17 , t0 . school_key AS school_key_18 , t0 . visible_school_key AS visible_school_key_19 , t0 . create_date AS create_date_20 , t0 . update_date AS update_date_21 , t0 . school_code AS school_code_22 , t0 . entry_url AS entry_url_23 , t0 . delivery_free_type AS delivery_free_type_24 , t0 . delivery_free_amount AS delivery_free_amount_25 , t0 . delivery_free_quantity AS delivery_free_quantity_26 , t0 . measure_plugin_type AS measure_plugin_type_27 , t0 . default_sex_products_filtering_flag AS default_sex_products_filtering_flag_28 , t0 . measuring_registration_required_flag AS measuring_registration_required_flag_29 , t0 . top_page_popup_flag AS top_page_popup_flag_30 , t0 . reg_data_popup_flag AS reg_data_popup_flag_31 , t0 . chat_bot_flag AS chat_bot_flag_32 , t0 . measuring_data_confirmation_flag AS measuring_data_confirmation_flag_33 , t0 . size_recommend_flag AS size_recommend_flag_34 , t0 . item_visible_type AS item_visible_type_35 , t0 . sale_start_date AS sale_start_date_36 , t0 . sale_end_date AS sale_end_date_37 , t0 . reservation_site_url AS reservation_site_url_38 , t0 . name_notation AS name_notation_39 , t0 . name01_entry_sample AS name01_entry_sample_40 , t0 . name02_entry_sample AS name02_entry_sample_41 , t0 . kana_notation AS kana_notation_42 , t0 . kana01_entry_sample AS kana01_entry_sample_43 , t0 . kana02_entry_sample AS kana02_entry_sample_44 , t0 . name_visible_type AS name_visible_type_45 , t0 . addr_notation AS addr_notation_46 , t0 . zip01_entry_sample AS zip01_entry_sample_47 , t0 . zip02_entry_sample AS zip02_entry_sample_48 , t0 . addr01_entry_sample AS addr01_entry_sample_49 , t0 . addr02_entry_sample AS addr02_entry_sample_50 , t0 . addr_visible_type AS addr_visible_type_51 , t0 . addr_visible_all AS addr_visible_all_52 , t0 . tel_notation AS tel_notation_53 , t0 . tel1_01_entry_sample AS tel1_01_entry_sample_54 , t0 . tel1_02_entry_sample AS tel1_02_entry_sample_55 , t0 . tel1_03_entry_sample AS tel1_03_entry_sample_56 , t0 . tel01_visible_type AS tel01_visible_type_57 , t0 . tel02_visible_type AS tel02_visible_type_58 , t0 . tel2_notation AS tel2_notation_59 , t0 . tel2_01_entry_sample AS tel2_01_entry_sample_60 , t0 . tel2_02_entry_sample AS tel2_02_entry_sample_61 , t0 . tel2_03_entry_sample AS tel2_03_entry_sample_62 , t0 . email_notation AS email_notation_63 , t0 . email_entry_sample AS email_entry_sample_64 , t0 . email_visible_type AS email_visible_type_65 , t0 . password_notation AS password_notation_66 , t0 . password_entry_sample AS password_entry_sample_67 , t0 . password_visible_type AS password_visible_type_68 , t0 . adyear_visible_type AS adyear_visible_type_69 , t0 . adyear_notation AS adyear_notation_70 , t0 . adyear_entry_sample AS adyear_entry_sample_71 , t0 . exam_number_visible_type AS exam_number_visible_type_72 , t0 . exam_number_notation AS exam_number_notation_73 , t0 . exam_number_entry_sample AS exam_number_entry_sample_74 , t0 . prev_school_visible_type AS prev_school_visible_type_75 , t0 . prev_school_notation AS prev_school_notation_76 , t0 . prev_school_entry_sample AS prev_school_entry_sample_77 , t0 . prev_year_class_visible_type AS prev_year_class_visible_type_78 , t0 . prev_year_class_notation AS prev_year_class_notation_79 , t0 . prev_year_entry_sample AS prev_year_entry_sample_80 , t0 . prev_class_entry_sample AS prev_class_entry_sample_81 , t0 . birth_visible_type AS birth_visible_type_82 , t0 . birth_notation AS birth_notation_83 , t0 . birth_entry_sample AS birth_entry_sample_84 , t0 . parents_name_visible_type AS parents_name_visible_type_85 , t0 . parents_name_notation AS parents_name_notation_86 , t0 . parents_name01_entry_sample AS parents_name01_entry_sample_87 , t0 . parents_name02_entry_sample AS parents_name02_entry_sample_88 , t0 . parents_birth_visible_type AS parents_birth_visible_type_89 , t0 . parents_birth_notation AS parents_birth_notation_90 , t0 . parents_birth_entry_sample AS parents_birth_entry_sample_91 , t0 . current_year_visible_type AS current_year_visible_type_92 , t0 . current_year_class_notation AS current_year_class_notation_93 , t0 . current_year_entry_sample AS current_year_entry_sample_94 , t0 . current_class_notation AS current_class_notation_95 , t0 . student_number_visible_type AS student_number_visible_type_96 , t0 . student_number_notation AS student_number_notation_97 , t0 . student_number_entry_sample AS student_number_entry_sample_98 , t0 . freeitem1_visible_type AS freeitem1_visible_type_99 , t0 . freeitem1_name AS freeitem1_name_100 , t0 . freeitem1_notation AS freeitem1_notation_101 , t0 . freeitem1_entry_sample AS freeitem1_entry_sample_102 , t0 . freeitem2_visible_type AS freeitem2_visible_type_103 , t0 . freeitem2_name AS freeitem2_name_104 , t0 . freeitem2_notation AS freeitem2_notation_105 , t0 . freeitem2_entry_sample AS freeitem2_entry_sample_106 , t0 . sex_visible_type AS sex_visible_type_107 , t0 . fax_visible_type AS fax_visible_type_108 , t0 . measure_height_visible_type AS measure_height_visible_type_109 , t0 . measure_weight_visible_type AS measure_weight_visible_type_110 , t0 . measure_shoulder_visible_type AS measure_shoulder_visible_type_111 , t0 . measure_sleeve1_visible_type AS measure_sleeve1_visible_type_112 , t0 . measure_sleeve2_visible_type AS measure_sleeve2_visible_type_113 , t0 . measure_total_visible_type AS measure_total_visible_type_114 , t0 . measure_neck_visible_type AS measure_neck_visible_type_115 , t0 . measure_bust_visible_type AS measure_bust_visible_type_116 , t0 . measure_waist_visible_type AS measure_waist_visible_type_117 , t0 . measure_hips_visible_type AS measure_hips_visible_type_118 , t0 . measure_inseam_visible_type AS measure_inseam_visible_type_119 , t0 . measure_skirt_visible_type AS measure_skirt_visible_type_120 , t0 . measure_slacks_visible_type AS measure_slacks_visible_type_121 , t0 . enter_year_class AS enter_year_class_122 , t0 . visible_commodity_alert AS visible_commodity_alert_123 , t0 . visible_flg AS visible_flg_124 , t0 . brother_flg AS brother_flg_125 , t0 . require_school_key AS require_school_key_126 , t0 . require_brothers AS require_brothers_127 , t0 . product_sexvisible_type AS product_sexvisible_type_128 , t0 . report_measure_flag AS report_measure_flag_129 , t0 . report_grade_flag AS report_grade_flag_130 , t0 . report_class_flag AS report_class_flag_131 , t0 . report_storemail_flag AS report_storemail_flag_132 , t0 . report_tax_flag AS report_tax_flag_133 , t0 . order_delivery_notation AS order_delivery_notation_134 , t0 . order_payment_notation AS order_payment_notation_135 , t0 . addr01_max_length AS addr01_max_length_136 , t0 . addr02_max_length AS addr02_max_length_137 , t0 . recommend_id AS recommend_id_138 , t0 . discriminator_type FROM dtb_school t0 WHERE t0 . discriminator_type IN ('school' );
Copy
0.62 ms (9.15%)
1
SELECT d0_ . id AS id_0 , d0_ . page_name AS page_name_1 , d0_ . url AS url_2 , d0_ . file_name AS file_name_3 , d0_ . edit_type AS edit_type_4 , d0_ . author AS author_5 , d0_ . description AS description_6 , d0_ . keyword AS keyword_7 , d0_ . create_date AS create_date_8 , d0_ . update_date AS update_date_9 , d0_ . meta_robots AS meta_robots_10 , d0_ . meta_tags AS meta_tags_11 , d1_ . page_id AS page_id_12 , d1_ . layout_id AS layout_id_13 , d1_ . sort_no AS sort_no_14 , d2_ . id AS id_15 , d2_ . layout_name AS layout_name_16 , d2_ . create_date AS create_date_17 , d2_ . update_date AS update_date_18 , d0_ . discriminator_type AS discriminator_type_19 , d0_ . master_page_id AS master_page_id_20 , d1_ . discriminator_type AS discriminator_type_21 , d1_ . page_id AS page_id_22 , d1_ . layout_id AS layout_id_23 , d2_ . discriminator_type AS discriminator_type_24 , d2_ . device_type_id AS device_type_id_25 FROM dtb_page d0_ LEFT JOIN dtb_page_layout d1_ ON d0_ . id = d1_ . page_id AND d1_ . discriminator_type IN ('pagelayout' ) LEFT JOIN dtb_layout d2_ ON d1_ . layout_id = d2_ . id AND d2_ . discriminator_type IN ('layout' ) WHERE (d0_ . url = ? ) AND d0_ . discriminator_type IN ('page' )
SELECT d0_ . id AS id_0 , d0_ . page_name AS page_name_1 , d0_ . url AS url_2 , d0_ . file_name AS file_name_3 , d0_ . edit_type AS edit_type_4 , d0_ . author AS author_5 , d0_ . description AS description_6 , d0_ . keyword AS keyword_7 , d0_ . create_date AS create_date_8 , d0_ . update_date AS update_date_9 , d0_ . meta_robots AS meta_robots_10 , d0_ . meta_tags AS meta_tags_11 , d1_ . page_id AS page_id_12 , d1_ . layout_id AS layout_id_13 , d1_ . sort_no AS sort_no_14 , d2_ . id AS id_15 , d2_ . layout_name AS layout_name_16 , d2_ . create_date AS create_date_17 , d2_ . update_date AS update_date_18 , d0_ . discriminator_type AS discriminator_type_19 , d0_ . master_page_id AS master_page_id_20 , d1_ . discriminator_type AS discriminator_type_21 , d1_ . page_id AS page_id_22 , d1_ . layout_id AS layout_id_23 , d2_ . discriminator_type AS discriminator_type_24 , d2_ . device_type_id AS device_type_id_25 FROM dtb_page d0_ LEFT JOIN dtb_page_layout d1_ ON d0_ . id = d1_ . page_id AND d1_ . discriminator_type IN ('pagelayout' ) LEFT JOIN dtb_layout d2_ ON d1_ . layout_id = d2_ . id AND d2_ . discriminator_type IN ('layout' ) WHERE (d0_ . url = 'entry' ) AND d0_ . discriminator_type IN ('page' );
Copy
0.46 ms (6.73%)
1
SET SESSION time_zone = '+00:00'
SET SESSION time_zone = '+00:00' ;
Copy
0.33 ms (4.91%)
1
SELECT d0_ . id AS id_0 , d0_ . category_name AS category_name_1 , d0_ . hierarchy AS hierarchy_2 , d0_ . sort_no AS sort_no_3 , d0_ . create_date AS create_date_4 , d0_ . update_date AS update_date_5 , d1_ . id AS id_6 , d1_ . category_name AS category_name_7 , d1_ . hierarchy AS hierarchy_8 , d1_ . sort_no AS sort_no_9 , d1_ . create_date AS create_date_10 , d1_ . update_date AS update_date_11 , d2_ . id AS id_12 , d2_ . category_name AS category_name_13 , d2_ . hierarchy AS hierarchy_14 , d2_ . sort_no AS sort_no_15 , d2_ . create_date AS create_date_16 , d2_ . update_date AS update_date_17 , d3_ . id AS id_18 , d3_ . category_name AS category_name_19 , d3_ . hierarchy AS hierarchy_20 , d3_ . sort_no AS sort_no_21 , d3_ . create_date AS create_date_22 , d3_ . update_date AS update_date_23 , d4_ . id AS id_24 , d4_ . category_name AS category_name_25 , d4_ . hierarchy AS hierarchy_26 , d4_ . sort_no AS sort_no_27 , d4_ . create_date AS create_date_28 , d4_ . update_date AS update_date_29 , d0_ . discriminator_type AS discriminator_type_30 , d0_ . parent_category_id AS parent_category_id_31 , d0_ . creator_id AS creator_id_32 , d0_ . school_id AS school_id_33 , d1_ . discriminator_type AS discriminator_type_34 , d1_ . parent_category_id AS parent_category_id_35 , d1_ . creator_id AS creator_id_36 , d1_ . school_id AS school_id_37 , d2_ . discriminator_type AS discriminator_type_38 , d2_ . parent_category_id AS parent_category_id_39 , d2_ . creator_id AS creator_id_40 , d2_ . school_id AS school_id_41 , d3_ . discriminator_type AS discriminator_type_42 , d3_ . parent_category_id AS parent_category_id_43 , d3_ . creator_id AS creator_id_44 , d3_ . school_id AS school_id_45 , d4_ . discriminator_type AS discriminator_type_46 , d4_ . parent_category_id AS parent_category_id_47 , d4_ . creator_id AS creator_id_48 , d4_ . school_id AS school_id_49 FROM dtb_category d0_ LEFT JOIN dtb_category d1_ ON d0_ . id = d1_ . parent_category_id AND d1_ . discriminator_type IN ('category' ) LEFT JOIN dtb_category d2_ ON d1_ . id = d2_ . parent_category_id AND d2_ . discriminator_type IN ('category' ) LEFT JOIN dtb_category d3_ ON d2_ . id = d3_ . parent_category_id AND d3_ . discriminator_type IN ('category' ) LEFT JOIN dtb_category d4_ ON d3_ . id = d4_ . parent_category_id AND d4_ . discriminator_type IN ('category' ) WHERE (d0_ . parent_category_id IS NULL ) AND d0_ . discriminator_type IN ('category' ) ORDER BY d0_ . sort_no DESC , d1_ . sort_no DESC , d2_ . sort_no DESC , d3_ . sort_no DESC , d4_ . sort_no DESC
SELECT
d0_ . id AS id_0 ,
d0_ . category_name AS category_name_1 ,
d0_ . hierarchy AS hierarchy_2 ,
d0_ . sort_no AS sort_no_3 ,
d0_ . create_date AS create_date_4 ,
d0_ . update_date AS update_date_5 ,
d1_ . id AS id_6 ,
d1_ . category_name AS category_name_7 ,
d1_ . hierarchy AS hierarchy_8 ,
d1_ . sort_no AS sort_no_9 ,
d1_ . create_date AS create_date_10 ,
d1_ . update_date AS update_date_11 ,
d2_ . id AS id_12 ,
d2_ . category_name AS category_name_13 ,
d2_ . hierarchy AS hierarchy_14 ,
d2_ . sort_no AS sort_no_15 ,
d2_ . create_date AS create_date_16 ,
d2_ . update_date AS update_date_17 ,
d3_ . id AS id_18 ,
d3_ . category_name AS category_name_19 ,
d3_ . hierarchy AS hierarchy_20 ,
d3_ . sort_no AS sort_no_21 ,
d3_ . create_date AS create_date_22 ,
d3_ . update_date AS update_date_23 ,
d4_ . id AS id_24 ,
d4_ . category_name AS category_name_25 ,
d4_ . hierarchy AS hierarchy_26 ,
d4_ . sort_no AS sort_no_27 ,
d4_ . create_date AS create_date_28 ,
d4_ . update_date AS update_date_29 ,
d0_ . discriminator_type AS discriminator_type_30 ,
d0_ . parent_category_id AS parent_category_id_31 ,
d0_ . creator_id AS creator_id_32 ,
d0_ . school_id AS school_id_33 ,
d1_ . discriminator_type AS discriminator_type_34 ,
d1_ . parent_category_id AS parent_category_id_35 ,
d1_ . creator_id AS creator_id_36 ,
d1_ . school_id AS school_id_37 ,
d2_ . discriminator_type AS discriminator_type_38 ,
d2_ . parent_category_id AS parent_category_id_39 ,
d2_ . creator_id AS creator_id_40 ,
d2_ . school_id AS school_id_41 ,
d3_ . discriminator_type AS discriminator_type_42 ,
d3_ . parent_category_id AS parent_category_id_43 ,
d3_ . creator_id AS creator_id_44 ,
d3_ . school_id AS school_id_45 ,
d4_ . discriminator_type AS discriminator_type_46 ,
d4_ . parent_category_id AS parent_category_id_47 ,
d4_ . creator_id AS creator_id_48 ,
d4_ . school_id AS school_id_49
FROM
dtb_category d0_
LEFT JOIN dtb_category d1_ ON d0_ . id = d1_ . parent_category_id
AND d1_ . discriminator_type IN ('category' )
LEFT JOIN dtb_category d2_ ON d1_ . id = d2_ . parent_category_id
AND d2_ . discriminator_type IN ('category' )
LEFT JOIN dtb_category d3_ ON d2_ . id = d3_ . parent_category_id
AND d3_ . discriminator_type IN ('category' )
LEFT JOIN dtb_category d4_ ON d3_ . id = d4_ . parent_category_id
AND d4_ . discriminator_type IN ('category' )
WHERE
(d0_ . parent_category_id IS NULL )
AND d0_ . discriminator_type IN ('category' )
ORDER BY
d0_ . sort_no DESC ,
d1_ . sort_no DESC ,
d2_ . sort_no DESC ,
d3_ . sort_no DESC ,
d4_ . sort_no DESC
Copy
SELECT d0_ . id AS id_0 , d0_ . category_name AS category_name_1 , d0_ . hierarchy AS hierarchy_2 , d0_ . sort_no AS sort_no_3 , d0_ . create_date AS create_date_4 , d0_ . update_date AS update_date_5 , d1_ . id AS id_6 , d1_ . category_name AS category_name_7 , d1_ . hierarchy AS hierarchy_8 , d1_ . sort_no AS sort_no_9 , d1_ . create_date AS create_date_10 , d1_ . update_date AS update_date_11 , d2_ . id AS id_12 , d2_ . category_name AS category_name_13 , d2_ . hierarchy AS hierarchy_14 , d2_ . sort_no AS sort_no_15 , d2_ . create_date AS create_date_16 , d2_ . update_date AS update_date_17 , d3_ . id AS id_18 , d3_ . category_name AS category_name_19 , d3_ . hierarchy AS hierarchy_20 , d3_ . sort_no AS sort_no_21 , d3_ . create_date AS create_date_22 , d3_ . update_date AS update_date_23 , d4_ . id AS id_24 , d4_ . category_name AS category_name_25 , d4_ . hierarchy AS hierarchy_26 , d4_ . sort_no AS sort_no_27 , d4_ . create_date AS create_date_28 , d4_ . update_date AS update_date_29 , d0_ . discriminator_type AS discriminator_type_30 , d0_ . parent_category_id AS parent_category_id_31 , d0_ . creator_id AS creator_id_32 , d0_ . school_id AS school_id_33 , d1_ . discriminator_type AS discriminator_type_34 , d1_ . parent_category_id AS parent_category_id_35 , d1_ . creator_id AS creator_id_36 , d1_ . school_id AS school_id_37 , d2_ . discriminator_type AS discriminator_type_38 , d2_ . parent_category_id AS parent_category_id_39 , d2_ . creator_id AS creator_id_40 , d2_ . school_id AS school_id_41 , d3_ . discriminator_type AS discriminator_type_42 , d3_ . parent_category_id AS parent_category_id_43 , d3_ . creator_id AS creator_id_44 , d3_ . school_id AS school_id_45 , d4_ . discriminator_type AS discriminator_type_46 , d4_ . parent_category_id AS parent_category_id_47 , d4_ . creator_id AS creator_id_48 , d4_ . school_id AS school_id_49 FROM dtb_category d0_ LEFT JOIN dtb_category d1_ ON d0_ . id = d1_ . parent_category_id AND d1_ . discriminator_type IN ('category' ) LEFT JOIN dtb_category d2_ ON d1_ . id = d2_ . parent_category_id AND d2_ . discriminator_type IN ('category' ) LEFT JOIN dtb_category d3_ ON d2_ . id = d3_ . parent_category_id AND d3_ . discriminator_type IN ('category' ) LEFT JOIN dtb_category d4_ ON d3_ . id = d4_ . parent_category_id AND d4_ . discriminator_type IN ('category' ) WHERE (d0_ . parent_category_id IS NULL ) AND d0_ . discriminator_type IN ('category' ) ORDER BY d0_ . sort_no DESC , d1_ . sort_no DESC , d2_ . sort_no DESC , d3_ . sort_no DESC , d4_ . sort_no DESC ;
Copy
0.20 ms (2.98%)
1
SELECT t0 . id AS id_1 , t0 . company_name AS company_name_2 , t0 . company_kana AS company_kana_3 , t0 . postal_code AS postal_code_4 , t0 . addr01 AS addr01_5 , t0 . addr02 AS addr02_6 , t0 . phone_number AS phone_number_7 , t0 . business_hour AS business_hour_8 , t0 . email01 AS email01_9 , t0 . email02 AS email02_10 , t0 . email03 AS email03_11 , t0 . email04 AS email04_12 , t0 . shop_name AS shop_name_13 , t0 . shop_kana AS shop_kana_14 , t0 . shop_name_eng AS shop_name_eng_15 , t0 . update_date AS update_date_16 , t0 . good_traded AS good_traded_17 , t0 . message AS message_18 , t0 . delivery_free_amount AS delivery_free_amount_19 , t0 . delivery_free_quantity AS delivery_free_quantity_20 , t0 . option_mypage_order_status_display AS option_mypage_order_status_display_21 , t0 . option_nostock_hidden AS option_nostock_hidden_22 , t0 . option_favorite_product AS option_favorite_product_23 , t0 . option_product_delivery_fee AS option_product_delivery_fee_24 , t0 . invoice_registration_number AS invoice_registration_number_25 , t0 . option_product_tax_rule AS option_product_tax_rule_26 , t0 . option_customer_activate AS option_customer_activate_27 , t0 . option_remember_me AS option_remember_me_28 , t0 . option_mail_notifier AS option_mail_notifier_29 , t0 . authentication_key AS authentication_key_30 , t0 . php_path AS php_path_31 , t0 . option_point AS option_point_32 , t0 . basic_point_rate AS basic_point_rate_33 , t0 . point_conversion_rate AS point_conversion_rate_34 , t0 . contact_school_visible_type AS contact_school_visible_type_35 , t0 . country_id AS country_id_36 , t0 . pref_id AS pref_id_37 , t0 . discriminator_type FROM dtb_base_info t0 WHERE t0 . id = ? AND t0 . discriminator_type IN ('baseinfo' )
SELECT t0 . id AS id_1 , t0 . company_name AS company_name_2 , t0 . company_kana AS company_kana_3 , t0 . postal_code AS postal_code_4 , t0 . addr01 AS addr01_5 , t0 . addr02 AS addr02_6 , t0 . phone_number AS phone_number_7 , t0 . business_hour AS business_hour_8 , t0 . email01 AS email01_9 , t0 . email02 AS email02_10 , t0 . email03 AS email03_11 , t0 . email04 AS email04_12 , t0 . shop_name AS shop_name_13 , t0 . shop_kana AS shop_kana_14 , t0 . shop_name_eng AS shop_name_eng_15 , t0 . update_date AS update_date_16 , t0 . good_traded AS good_traded_17 , t0 . message AS message_18 , t0 . delivery_free_amount AS delivery_free_amount_19 , t0 . delivery_free_quantity AS delivery_free_quantity_20 , t0 . option_mypage_order_status_display AS option_mypage_order_status_display_21 , t0 . option_nostock_hidden AS option_nostock_hidden_22 , t0 . option_favorite_product AS option_favorite_product_23 , t0 . option_product_delivery_fee AS option_product_delivery_fee_24 , t0 . invoice_registration_number AS invoice_registration_number_25 , t0 . option_product_tax_rule AS option_product_tax_rule_26 , t0 . option_customer_activate AS option_customer_activate_27 , t0 . option_remember_me AS option_remember_me_28 , t0 . option_mail_notifier AS option_mail_notifier_29 , t0 . authentication_key AS authentication_key_30 , t0 . php_path AS php_path_31 , t0 . option_point AS option_point_32 , t0 . basic_point_rate AS basic_point_rate_33 , t0 . point_conversion_rate AS point_conversion_rate_34 , t0 . contact_school_visible_type AS contact_school_visible_type_35 , t0 . country_id AS country_id_36 , t0 . pref_id AS pref_id_37 , t0 . discriminator_type FROM dtb_base_info t0 WHERE t0 . id = 1 AND t0 . discriminator_type IN ('baseinfo' );
Copy
0.14 ms (2.11%)
1
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED ;
Copy
0.13 ms (1.85%)
1
SELECT d0_ . id AS id_0 , d0_ . layout_name AS layout_name_1 , d0_ . create_date AS create_date_2 , d0_ . update_date AS update_date_3 , d1_ . section AS section_4 , d1_ . block_id AS block_id_5 , d1_ . layout_id AS layout_id_6 , d1_ . block_row AS block_row_7 , d2_ . id AS id_8 , d2_ . block_name AS block_name_9 , d2_ . file_name AS file_name_10 , d2_ . use_controller AS use_controller_11 , d2_ . deletable AS deletable_12 , d2_ . create_date AS create_date_13 , d2_ . update_date AS update_date_14 , d0_ . discriminator_type AS discriminator_type_15 , d0_ . device_type_id AS device_type_id_16 , d1_ . discriminator_type AS discriminator_type_17 , d1_ . block_id AS block_id_18 , d1_ . layout_id AS layout_id_19 , d2_ . discriminator_type AS discriminator_type_20 , d2_ . device_type_id AS device_type_id_21 FROM dtb_layout d0_ LEFT JOIN dtb_block_position d1_ ON d0_ . id = d1_ . layout_id AND d1_ . discriminator_type IN ('blockposition' ) LEFT JOIN dtb_block d2_ ON d1_ . block_id = d2_ . id AND d2_ . discriminator_type IN ('block' ) WHERE (d0_ . id = ? ) AND d0_ . discriminator_type IN ('layout' ) ORDER BY d1_ . block_row ASC
SELECT d0_ . id AS id_0 , d0_ . layout_name AS layout_name_1 , d0_ . create_date AS create_date_2 , d0_ . update_date AS update_date_3 , d1_ . section AS section_4 , d1_ . block_id AS block_id_5 , d1_ . layout_id AS layout_id_6 , d1_ . block_row AS block_row_7 , d2_ . id AS id_8 , d2_ . block_name AS block_name_9 , d2_ . file_name AS file_name_10 , d2_ . use_controller AS use_controller_11 , d2_ . deletable AS deletable_12 , d2_ . create_date AS create_date_13 , d2_ . update_date AS update_date_14 , d0_ . discriminator_type AS discriminator_type_15 , d0_ . device_type_id AS device_type_id_16 , d1_ . discriminator_type AS discriminator_type_17 , d1_ . block_id AS block_id_18 , d1_ . layout_id AS layout_id_19 , d2_ . discriminator_type AS discriminator_type_20 , d2_ . device_type_id AS device_type_id_21 FROM dtb_layout d0_ LEFT JOIN dtb_block_position d1_ ON d0_ . id = d1_ . layout_id AND d1_ . discriminator_type IN ('blockposition' ) LEFT JOIN dtb_block d2_ ON d1_ . block_id = d2_ . id AND d2_ . discriminator_type IN ('block' ) WHERE (d0_ . id = 2 ) AND d0_ . discriminator_type IN ('layout' ) ORDER BY d1_ . block_row ASC ;
Copy
0.08 ms (1.15%)
1
"START TRANSACTION"
"START TRANSACTION" ;
Copy