Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

13 Database Queries

12 Different statements

4.64 ms Query time

3 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
1.26 ms (27.15%)	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_.del_flg AS del_flg_21, d0_.school_code AS school_code_22, d0_.entry_url AS entry_url_23, d0_.delivery_free_type AS delivery_free_type_24, d0_.delivery_free_amount AS delivery_free_amount_25, d0_.delivery_free_quantity AS delivery_free_quantity_26, d0_.measure_plugin_type AS measure_plugin_type_27, d0_.default_sex_products_filtering_flag AS default_sex_products_filtering_flag_28, d0_.measuring_registration_required_flag AS measuring_registration_required_flag_29, d0_.top_page_popup_flag AS top_page_popup_flag_30, d0_.reg_data_confirmation_flag AS reg_data_confirmation_flag_31, d0_.reserver_popup_flag AS reserver_popup_flag_32, d0_.reserver_popup_text AS reserver_popup_text_33, d0_.reserve_note_visible_flag AS reserve_note_visible_flag_34, d0_.reg_data_popup_flag AS reg_data_popup_flag_35, d0_.chat_bot_flag AS chat_bot_flag_36, d0_.measuring_data_confirmation_flag AS measuring_data_confirmation_flag_37, d0_.size_recommend_flag AS size_recommend_flag_38, d0_.item_visible_type AS item_visible_type_39, d0_.filter_visible_flag AS filter_visible_flag_40, d0_.shopping_guide_menu_flag AS shopping_guide_menu_flag_41, d0_.shopping_guide_banner_flag AS shopping_guide_banner_flag_42, d0_.correct_size_menu_flag AS correct_size_menu_flag_43, d0_.correct_size_banner_flag AS correct_size_banner_flag_44, d0_.commitment_uniform_menu_flag AS commitment_uniform_menu_flag_45, d0_.commitment_uniform_banner_flag AS commitment_uniform_banner_flag_46, d0_.measurement_procedure_banner_flag AS measurement_procedure_banner_flag_47, d0_.return_exchange_banner_flag AS return_exchange_banner_flag_48, d0_.store_info_menu_flag AS store_info_menu_flag_49, d0_.document_print_content_flag AS document_print_content_flag_50, d0_.sale_start_date AS sale_start_date_51, d0_.sale_end_date AS sale_end_date_52, d0_.reservation_site_url AS reservation_site_url_53, d0_.name_notation AS name_notation_54, d0_.name01_entry_sample AS name01_entry_sample_55, d0_.name02_entry_sample AS name02_entry_sample_56, d0_.kana_notation AS kana_notation_57, d0_.kana01_entry_sample AS kana01_entry_sample_58, d0_.kana02_entry_sample AS kana02_entry_sample_59, d0_.name_visible_type AS name_visible_type_60, d0_.addr_notation AS addr_notation_61, d0_.zip01_entry_sample AS zip01_entry_sample_62, d0_.zip02_entry_sample AS zip02_entry_sample_63, d0_.addr01_entry_sample AS addr01_entry_sample_64, d0_.addr02_entry_sample AS addr02_entry_sample_65, d0_.addr_visible_type AS addr_visible_type_66, d0_.addr_visible_all AS addr_visible_all_67, d0_.tel_notation AS tel_notation_68, d0_.tel1_01_entry_sample AS tel1_01_entry_sample_69, d0_.tel1_02_entry_sample AS tel1_02_entry_sample_70, d0_.tel1_03_entry_sample AS tel1_03_entry_sample_71, d0_.tel01_visible_type AS tel01_visible_type_72, d0_.tel02_visible_type AS tel02_visible_type_73, d0_.tel2_notation AS tel2_notation_74, d0_.tel2_01_entry_sample AS tel2_01_entry_sample_75, d0_.tel2_02_entry_sample AS tel2_02_entry_sample_76, d0_.tel2_03_entry_sample AS tel2_03_entry_sample_77, d0_.email_notation AS email_notation_78, d0_.email_entry_sample AS email_entry_sample_79, d0_.email_visible_type AS email_visible_type_80, d0_.password_notation AS password_notation_81, d0_.password_entry_sample AS password_entry_sample_82, d0_.password_visible_type AS password_visible_type_83, d0_.adyear_visible_type AS adyear_visible_type_84, d0_.adyear_notation AS adyear_notation_85, d0_.adyear_entry_sample AS adyear_entry_sample_86, d0_.exam_number_visible_type AS exam_number_visible_type_87, d0_.exam_number_notation AS exam_number_notation_88, d0_.exam_number_entry_sample AS exam_number_entry_sample_89, d0_.prev_school_visible_type AS prev_school_visible_type_90, d0_.prev_school_notation AS prev_school_notation_91, d0_.prev_school_entry_sample AS prev_school_entry_sample_92, d0_.prev_year_class_visible_type AS prev_year_class_visible_type_93, d0_.prev_year_class_notation AS prev_year_class_notation_94, d0_.prev_year_entry_sample AS prev_year_entry_sample_95, d0_.prev_class_entry_sample AS prev_class_entry_sample_96, d0_.birth_visible_type AS birth_visible_type_97, d0_.birth_notation AS birth_notation_98, d0_.birth_entry_sample AS birth_entry_sample_99, d0_.parents_name_visible_type AS parents_name_visible_type_100, d0_.parents_name_notation AS parents_name_notation_101, d0_.parents_name01_entry_sample AS parents_name01_entry_sample_102, d0_.parents_name02_entry_sample AS parents_name02_entry_sample_103, d0_.parents_birth_visible_type AS parents_birth_visible_type_104, d0_.parents_birth_notation AS parents_birth_notation_105, d0_.parents_birth_entry_sample AS parents_birth_entry_sample_106, d0_.current_year_visible_type AS current_year_visible_type_107, d0_.current_year_class_notation AS current_year_class_notation_108, d0_.current_year_entry_sample AS current_year_entry_sample_109, d0_.current_class_notation AS current_class_notation_110, d0_.student_number_visible_type AS student_number_visible_type_111, d0_.student_number_notation AS student_number_notation_112, d0_.student_number_entry_sample AS student_number_entry_sample_113, d0_.freeitem1_visible_type AS freeitem1_visible_type_114, d0_.freeitem1_name AS freeitem1_name_115, d0_.freeitem1_notation AS freeitem1_notation_116, d0_.freeitem1_entry_sample AS freeitem1_entry_sample_117, d0_.freeitem1_max_length AS freeitem1_max_length_118, d0_.freeitem2_visible_type AS freeitem2_visible_type_119, d0_.freeitem2_name AS freeitem2_name_120, d0_.freeitem2_notation AS freeitem2_notation_121, d0_.freeitem2_entry_sample AS freeitem2_entry_sample_122, d0_.freeitem2_max_length AS freeitem2_max_length_123, d0_.sex_visible_type AS sex_visible_type_124, d0_.sex_show_noanswer AS sex_show_noanswer_125, d0_.fax_visible_type AS fax_visible_type_126, d0_.measure_height_visible_type AS measure_height_visible_type_127, d0_.measure_weight_visible_type AS measure_weight_visible_type_128, d0_.measure_shoulder_visible_type AS measure_shoulder_visible_type_129, d0_.measure_sleeve1_visible_type AS measure_sleeve1_visible_type_130, d0_.measure_sleeve2_visible_type AS measure_sleeve2_visible_type_131, d0_.measure_total_visible_type AS measure_total_visible_type_132, d0_.measure_neck_visible_type AS measure_neck_visible_type_133, d0_.measure_bust_visible_type AS measure_bust_visible_type_134, d0_.measure_waist_visible_type AS measure_waist_visible_type_135, d0_.measure_hips_visible_type AS measure_hips_visible_type_136, d0_.measure_inseam_visible_type AS measure_inseam_visible_type_137, d0_.measure_skirt_visible_type AS measure_skirt_visible_type_138, d0_.measure_slacks_visible_type AS measure_slacks_visible_type_139, d0_.dr06_visible_type AS dr06_visible_type_140, d0_.dr14_visible_type AS dr14_visible_type_141, d0_.dr15_visible_type AS dr15_visible_type_142, d0_.dr16_visible_type AS dr16_visible_type_143, d0_.dr17_visible_type AS dr17_visible_type_144, d0_.dr23_visible_type AS dr23_visible_type_145, d0_.dr24_visible_type AS dr24_visible_type_146, d0_.dr25_visible_type AS dr25_visible_type_147, d0_.dr50_visible_type AS dr50_visible_type_148, d0_.dr51_visible_type AS dr51_visible_type_149, d0_.dr52_visible_type AS dr52_visible_type_150, d0_.dr53_visible_type AS dr53_visible_type_151, d0_.dantai_visible_type AS dantai_visible_type_152, d0_.daihyou_visible_type AS daihyou_visible_type_153, d0_.daikana_visible_type AS daikana_visible_type_154, d0_.namtxt_visible_type AS namtxt_visible_type_155, d0_.measuring_method_visible_type AS measuring_method_visible_type_156, d0_.enter_year_class AS enter_year_class_157, d0_.visible_commodity_alert AS visible_commodity_alert_158, d0_.visible_flg AS visible_flg_159, d0_.brother_flg AS brother_flg_160, d0_.require_school_key AS require_school_key_161, d0_.require_brothers AS require_brothers_162, d0_.product_sexvisible_type AS product_sexvisible_type_163, d0_.report_measure_flag AS report_measure_flag_164, d0_.report_grade_flag AS report_grade_flag_165, d0_.report_class_flag AS report_class_flag_166, d0_.report_storemail_flag AS report_storemail_flag_167, d0_.report_tax_flag AS report_tax_flag_168, d0_.report_setproduct_size_flag AS report_setproduct_size_flag_169, d0_.report_font_size AS report_font_size_170, d0_.order_delivery_notation AS order_delivery_notation_171, d0_.order_payment_notation AS order_payment_notation_172, d0_.addr01_max_length AS addr01_max_length_173, d0_.addr02_max_length AS addr02_max_length_174, d0_.order_message_flag AS order_message_flag_175, d0_.order_message_notation AS order_message_notation_176, d0_.order_email_header_text AS order_email_header_text_177, d0_.order_email_product_details_flag AS order_email_product_details_flag_178, d0_.order_email_customer_info_flag AS order_email_customer_info_flag_179, d0_.order_email_school_name_flag AS order_email_school_name_flag_180, d0_.order_email_admission_year_flag AS order_email_admission_year_flag_181, d0_.order_email_shipping_info_flag AS order_email_shipping_info_flag_182, d0_.redirect_flg AS redirect_flg_183, d0_.redirect_url AS redirect_url_184, d0_.display_notice AS display_notice_185, d0_.notice_text AS notice_text_186, d0_.display_cart_notice AS display_cart_notice_187, d0_.cart_notice_text AS cart_notice_text_188, d0_.display_saisun_notice AS display_saisun_notice_189, d0_.saisun_notice_text AS saisun_notice_text_190, d0_.display_product_notice AS display_product_notice_191, d0_.product_notice_text AS product_notice_text_192, d0_.examinee_lookup_enabled AS examinee_lookup_enabled_193, d0_.discriminator_type AS discriminator_type_194, d0_.recommend_id AS recommend_id_195 FROM dtb_school d0_ WHERE (d0_.visible_flg = ? AND d0_.del_flg = ?) AND d0_.discriminator_type IN ('school') ORDER BY d0_.school_order ASC Parameters: [`1 0`] View formatted query View runnable query Explain query 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_.del_flg AS del_flg_21, d0_.school_code AS school_code_22, d0_.entry_url AS entry_url_23, d0_.delivery_free_type AS delivery_free_type_24, d0_.delivery_free_amount AS delivery_free_amount_25, d0_.delivery_free_quantity AS delivery_free_quantity_26, d0_.measure_plugin_type AS measure_plugin_type_27, d0_.default_sex_products_filtering_flag AS default_sex_products_filtering_flag_28, d0_.measuring_registration_required_flag AS measuring_registration_required_flag_29, d0_.top_page_popup_flag AS top_page_popup_flag_30, d0_.reg_data_confirmation_flag AS reg_data_confirmation_flag_31, d0_.reserver_popup_flag AS reserver_popup_flag_32, d0_.reserver_popup_text AS reserver_popup_text_33, d0_.reserve_note_visible_flag AS reserve_note_visible_flag_34, d0_.reg_data_popup_flag AS reg_data_popup_flag_35, d0_.chat_bot_flag AS chat_bot_flag_36, d0_.measuring_data_confirmation_flag AS measuring_data_confirmation_flag_37, d0_.size_recommend_flag AS size_recommend_flag_38, d0_.item_visible_type AS item_visible_type_39, d0_.filter_visible_flag AS filter_visible_flag_40, d0_.shopping_guide_menu_flag AS shopping_guide_menu_flag_41, d0_.shopping_guide_banner_flag AS shopping_guide_banner_flag_42, d0_.correct_size_menu_flag AS correct_size_menu_flag_43, d0_.correct_size_banner_flag AS correct_size_banner_flag_44, d0_.commitment_uniform_menu_flag AS commitment_uniform_menu_flag_45, d0_.commitment_uniform_banner_flag AS commitment_uniform_banner_flag_46, d0_.measurement_procedure_banner_flag AS measurement_procedure_banner_flag_47, d0_.return_exchange_banner_flag AS return_exchange_banner_flag_48, d0_.store_info_menu_flag AS store_info_menu_flag_49, d0_.document_print_content_flag AS document_print_content_flag_50, d0_.sale_start_date AS sale_start_date_51, d0_.sale_end_date AS sale_end_date_52, d0_.reservation_site_url AS reservation_site_url_53, d0_.name_notation AS name_notation_54, d0_.name01_entry_sample AS name01_entry_sample_55, d0_.name02_entry_sample AS name02_entry_sample_56, d0_.kana_notation AS kana_notation_57, d0_.kana01_entry_sample AS kana01_entry_sample_58, d0_.kana02_entry_sample AS kana02_entry_sample_59, d0_.name_visible_type AS name_visible_type_60, d0_.addr_notation AS addr_notation_61, d0_.zip01_entry_sample AS zip01_entry_sample_62, d0_.zip02_entry_sample AS zip02_entry_sample_63, d0_.addr01_entry_sample AS addr01_entry_sample_64, d0_.addr02_entry_sample AS addr02_entry_sample_65, d0_.addr_visible_type AS addr_visible_type_66, d0_.addr_visible_all AS addr_visible_all_67, d0_.tel_notation AS tel_notation_68, d0_.tel1_01_entry_sample AS tel1_01_entry_sample_69, d0_.tel1_02_entry_sample AS tel1_02_entry_sample_70, d0_.tel1_03_entry_sample AS tel1_03_entry_sample_71, d0_.tel01_visible_type AS tel01_visible_type_72, d0_.tel02_visible_type AS tel02_visible_type_73, d0_.tel2_notation AS tel2_notation_74, d0_.tel2_01_entry_sample AS tel2_01_entry_sample_75, d0_.tel2_02_entry_sample AS tel2_02_entry_sample_76, d0_.tel2_03_entry_sample AS tel2_03_entry_sample_77, d0_.email_notation AS email_notation_78, d0_.email_entry_sample AS email_entry_sample_79, d0_.email_visible_type AS email_visible_type_80, d0_.password_notation AS password_notation_81, d0_.password_entry_sample AS password_entry_sample_82, d0_.password_visible_type AS password_visible_type_83, d0_.adyear_visible_type AS adyear_visible_type_84, d0_.adyear_notation AS adyear_notation_85, d0_.adyear_entry_sample AS adyear_entry_sample_86, d0_.exam_number_visible_type AS exam_number_visible_type_87, d0_.exam_number_notation AS exam_number_notation_88, d0_.exam_number_entry_sample AS exam_number_entry_sample_89, d0_.prev_school_visible_type AS prev_school_visible_type_90, d0_.prev_school_notation AS prev_school_notation_91, d0_.prev_school_entry_sample AS prev_school_entry_sample_92, d0_.prev_year_class_visible_type AS prev_year_class_visible_type_93, d0_.prev_year_class_notation AS prev_year_class_notation_94, d0_.prev_year_entry_sample AS prev_year_entry_sample_95, d0_.prev_class_entry_sample AS prev_class_entry_sample_96, d0_.birth_visible_type AS birth_visible_type_97, d0_.birth_notation AS birth_notation_98, d0_.birth_entry_sample AS birth_entry_sample_99, d0_.parents_name_visible_type AS parents_name_visible_type_100, d0_.parents_name_notation AS parents_name_notation_101, d0_.parents_name01_entry_sample AS parents_name01_entry_sample_102, d0_.parents_name02_entry_sample AS parents_name02_entry_sample_103, d0_.parents_birth_visible_type AS parents_birth_visible_type_104, d0_.parents_birth_notation AS parents_birth_notation_105, d0_.parents_birth_entry_sample AS parents_birth_entry_sample_106, d0_.current_year_visible_type AS current_year_visible_type_107, d0_.current_year_class_notation AS current_year_class_notation_108, d0_.current_year_entry_sample AS current_year_entry_sample_109, d0_.current_class_notation AS current_class_notation_110, d0_.student_number_visible_type AS student_number_visible_type_111, d0_.student_number_notation AS student_number_notation_112, d0_.student_number_entry_sample AS student_number_entry_sample_113, d0_.freeitem1_visible_type AS freeitem1_visible_type_114, d0_.freeitem1_name AS freeitem1_name_115, d0_.freeitem1_notation AS freeitem1_notation_116, d0_.freeitem1_entry_sample AS freeitem1_entry_sample_117, d0_.freeitem1_max_length AS freeitem1_max_length_118, d0_.freeitem2_visible_type AS freeitem2_visible_type_119, d0_.freeitem2_name AS freeitem2_name_120, d0_.freeitem2_notation AS freeitem2_notation_121, d0_.freeitem2_entry_sample AS freeitem2_entry_sample_122, d0_.freeitem2_max_length AS freeitem2_max_length_123, d0_.sex_visible_type AS sex_visible_type_124, d0_.sex_show_noanswer AS sex_show_noanswer_125, d0_.fax_visible_type AS fax_visible_type_126, d0_.measure_height_visible_type AS measure_height_visible_type_127, d0_.measure_weight_visible_type AS measure_weight_visible_type_128, d0_.measure_shoulder_visible_type AS measure_shoulder_visible_type_129, d0_.measure_sleeve1_visible_type AS measure_sleeve1_visible_type_130, d0_.measure_sleeve2_visible_type AS measure_sleeve2_visible_type_131, d0_.measure_total_visible_type AS measure_total_visible_type_132, d0_.measure_neck_visible_type AS measure_neck_visible_type_133, d0_.measure_bust_visible_type AS measure_bust_visible_type_134, d0_.measure_waist_visible_type AS measure_waist_visible_type_135, d0_.measure_hips_visible_type AS measure_hips_visible_type_136, d0_.measure_inseam_visible_type AS measure_inseam_visible_type_137, d0_.measure_skirt_visible_type AS measure_skirt_visible_type_138, d0_.measure_slacks_visible_type AS measure_slacks_visible_type_139, d0_.dr06_visible_type AS dr06_visible_type_140, d0_.dr14_visible_type AS dr14_visible_type_141, d0_.dr15_visible_type AS dr15_visible_type_142, d0_.dr16_visible_type AS dr16_visible_type_143, d0_.dr17_visible_type AS dr17_visible_type_144, d0_.dr23_visible_type AS dr23_visible_type_145, d0_.dr24_visible_type AS dr24_visible_type_146, d0_.dr25_visible_type AS dr25_visible_type_147, d0_.dr50_visible_type AS dr50_visible_type_148, d0_.dr51_visible_type AS dr51_visible_type_149, d0_.dr52_visible_type AS dr52_visible_type_150, d0_.dr53_visible_type AS dr53_visible_type_151, d0_.dantai_visible_type AS dantai_visible_type_152, d0_.daihyou_visible_type AS daihyou_visible_type_153, d0_.daikana_visible_type AS daikana_visible_type_154, d0_.namtxt_visible_type AS namtxt_visible_type_155, d0_.measuring_method_visible_type AS measuring_method_visible_type_156, d0_.enter_year_class AS enter_year_class_157, d0_.visible_commodity_alert AS visible_commodity_alert_158, d0_.visible_flg AS visible_flg_159, d0_.brother_flg AS brother_flg_160, d0_.require_school_key AS require_school_key_161, d0_.require_brothers AS require_brothers_162, d0_.product_sexvisible_type AS product_sexvisible_type_163, d0_.report_measure_flag AS report_measure_flag_164, d0_.report_grade_flag AS report_grade_flag_165, d0_.report_class_flag AS report_class_flag_166, d0_.report_storemail_flag AS report_storemail_flag_167, d0_.report_tax_flag AS report_tax_flag_168, d0_.report_setproduct_size_flag AS report_setproduct_size_flag_169, d0_.report_font_size AS report_font_size_170, d0_.order_delivery_notation AS order_delivery_notation_171, d0_.order_payment_notation AS order_payment_notation_172, d0_.addr01_max_length AS addr01_max_length_173, d0_.addr02_max_length AS addr02_max_length_174, d0_.order_message_flag AS order_message_flag_175, d0_.order_message_notation AS order_message_notation_176, d0_.order_email_header_text AS order_email_header_text_177, d0_.order_email_product_details_flag AS order_email_product_details_flag_178, d0_.order_email_customer_info_flag AS order_email_customer_info_flag_179, d0_.order_email_school_name_flag AS order_email_school_name_flag_180, d0_.order_email_admission_year_flag AS order_email_admission_year_flag_181, d0_.order_email_shipping_info_flag AS order_email_shipping_info_flag_182, d0_.redirect_flg AS redirect_flg_183, d0_.redirect_url AS redirect_url_184, d0_.display_notice AS display_notice_185, d0_.notice_text AS notice_text_186, d0_.display_cart_notice AS display_cart_notice_187, d0_.cart_notice_text AS cart_notice_text_188, d0_.display_saisun_notice AS display_saisun_notice_189, d0_.saisun_notice_text AS saisun_notice_text_190, d0_.display_product_notice AS display_product_notice_191, d0_.product_notice_text AS product_notice_text_192, d0_.examinee_lookup_enabled AS examinee_lookup_enabled_193, d0_.discriminator_type AS discriminator_type_194, d0_.recommend_id AS recommend_id_195 FROM dtb_school d0_ WHERE ( d0_.visible_flg = ? AND d0_.del_flg = ? ) 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_.del_flg AS del_flg_21, d0_.school_code AS school_code_22, d0_.entry_url AS entry_url_23, d0_.delivery_free_type AS delivery_free_type_24, d0_.delivery_free_amount AS delivery_free_amount_25, d0_.delivery_free_quantity AS delivery_free_quantity_26, d0_.measure_plugin_type AS measure_plugin_type_27, d0_.default_sex_products_filtering_flag AS default_sex_products_filtering_flag_28, d0_.measuring_registration_required_flag AS measuring_registration_required_flag_29, d0_.top_page_popup_flag AS top_page_popup_flag_30, d0_.reg_data_confirmation_flag AS reg_data_confirmation_flag_31, d0_.reserver_popup_flag AS reserver_popup_flag_32, d0_.reserver_popup_text AS reserver_popup_text_33, d0_.reserve_note_visible_flag AS reserve_note_visible_flag_34, d0_.reg_data_popup_flag AS reg_data_popup_flag_35, d0_.chat_bot_flag AS chat_bot_flag_36, d0_.measuring_data_confirmation_flag AS measuring_data_confirmation_flag_37, d0_.size_recommend_flag AS size_recommend_flag_38, d0_.item_visible_type AS item_visible_type_39, d0_.filter_visible_flag AS filter_visible_flag_40, d0_.shopping_guide_menu_flag AS shopping_guide_menu_flag_41, d0_.shopping_guide_banner_flag AS shopping_guide_banner_flag_42, d0_.correct_size_menu_flag AS correct_size_menu_flag_43, d0_.correct_size_banner_flag AS correct_size_banner_flag_44, d0_.commitment_uniform_menu_flag AS commitment_uniform_menu_flag_45, d0_.commitment_uniform_banner_flag AS commitment_uniform_banner_flag_46, d0_.measurement_procedure_banner_flag AS measurement_procedure_banner_flag_47, d0_.return_exchange_banner_flag AS return_exchange_banner_flag_48, d0_.store_info_menu_flag AS store_info_menu_flag_49, d0_.document_print_content_flag AS document_print_content_flag_50, d0_.sale_start_date AS sale_start_date_51, d0_.sale_end_date AS sale_end_date_52, d0_.reservation_site_url AS reservation_site_url_53, d0_.name_notation AS name_notation_54, d0_.name01_entry_sample AS name01_entry_sample_55, d0_.name02_entry_sample AS name02_entry_sample_56, d0_.kana_notation AS kana_notation_57, d0_.kana01_entry_sample AS kana01_entry_sample_58, d0_.kana02_entry_sample AS kana02_entry_sample_59, d0_.name_visible_type AS name_visible_type_60, d0_.addr_notation AS addr_notation_61, d0_.zip01_entry_sample AS zip01_entry_sample_62, d0_.zip02_entry_sample AS zip02_entry_sample_63, d0_.addr01_entry_sample AS addr01_entry_sample_64, d0_.addr02_entry_sample AS addr02_entry_sample_65, d0_.addr_visible_type AS addr_visible_type_66, d0_.addr_visible_all AS addr_visible_all_67, d0_.tel_notation AS tel_notation_68, d0_.tel1_01_entry_sample AS tel1_01_entry_sample_69, d0_.tel1_02_entry_sample AS tel1_02_entry_sample_70, d0_.tel1_03_entry_sample AS tel1_03_entry_sample_71, d0_.tel01_visible_type AS tel01_visible_type_72, d0_.tel02_visible_type AS tel02_visible_type_73, d0_.tel2_notation AS tel2_notation_74, d0_.tel2_01_entry_sample AS tel2_01_entry_sample_75, d0_.tel2_02_entry_sample AS tel2_02_entry_sample_76, d0_.tel2_03_entry_sample AS tel2_03_entry_sample_77, d0_.email_notation AS email_notation_78, d0_.email_entry_sample AS email_entry_sample_79, d0_.email_visible_type AS email_visible_type_80, d0_.password_notation AS password_notation_81, d0_.password_entry_sample AS password_entry_sample_82, d0_.password_visible_type AS password_visible_type_83, d0_.adyear_visible_type AS adyear_visible_type_84, d0_.adyear_notation AS adyear_notation_85, d0_.adyear_entry_sample AS adyear_entry_sample_86, d0_.exam_number_visible_type AS exam_number_visible_type_87, d0_.exam_number_notation AS exam_number_notation_88, d0_.exam_number_entry_sample AS exam_number_entry_sample_89, d0_.prev_school_visible_type AS prev_school_visible_type_90, d0_.prev_school_notation AS prev_school_notation_91, d0_.prev_school_entry_sample AS prev_school_entry_sample_92, d0_.prev_year_class_visible_type AS prev_year_class_visible_type_93, d0_.prev_year_class_notation AS prev_year_class_notation_94, d0_.prev_year_entry_sample AS prev_year_entry_sample_95, d0_.prev_class_entry_sample AS prev_class_entry_sample_96, d0_.birth_visible_type AS birth_visible_type_97, d0_.birth_notation AS birth_notation_98, d0_.birth_entry_sample AS birth_entry_sample_99, d0_.parents_name_visible_type AS parents_name_visible_type_100, d0_.parents_name_notation AS parents_name_notation_101, d0_.parents_name01_entry_sample AS parents_name01_entry_sample_102, d0_.parents_name02_entry_sample AS parents_name02_entry_sample_103, d0_.parents_birth_visible_type AS parents_birth_visible_type_104, d0_.parents_birth_notation AS parents_birth_notation_105, d0_.parents_birth_entry_sample AS parents_birth_entry_sample_106, d0_.current_year_visible_type AS current_year_visible_type_107, d0_.current_year_class_notation AS current_year_class_notation_108, d0_.current_year_entry_sample AS current_year_entry_sample_109, d0_.current_class_notation AS current_class_notation_110, d0_.student_number_visible_type AS student_number_visible_type_111, d0_.student_number_notation AS student_number_notation_112, d0_.student_number_entry_sample AS student_number_entry_sample_113, d0_.freeitem1_visible_type AS freeitem1_visible_type_114, d0_.freeitem1_name AS freeitem1_name_115, d0_.freeitem1_notation AS freeitem1_notation_116, d0_.freeitem1_entry_sample AS freeitem1_entry_sample_117, d0_.freeitem1_max_length AS freeitem1_max_length_118, d0_.freeitem2_visible_type AS freeitem2_visible_type_119, d0_.freeitem2_name AS freeitem2_name_120, d0_.freeitem2_notation AS freeitem2_notation_121, d0_.freeitem2_entry_sample AS freeitem2_entry_sample_122, d0_.freeitem2_max_length AS freeitem2_max_length_123, d0_.sex_visible_type AS sex_visible_type_124, d0_.sex_show_noanswer AS sex_show_noanswer_125, d0_.fax_visible_type AS fax_visible_type_126, d0_.measure_height_visible_type AS measure_height_visible_type_127, d0_.measure_weight_visible_type AS measure_weight_visible_type_128, d0_.measure_shoulder_visible_type AS measure_shoulder_visible_type_129, d0_.measure_sleeve1_visible_type AS measure_sleeve1_visible_type_130, d0_.measure_sleeve2_visible_type AS measure_sleeve2_visible_type_131, d0_.measure_total_visible_type AS measure_total_visible_type_132, d0_.measure_neck_visible_type AS measure_neck_visible_type_133, d0_.measure_bust_visible_type AS measure_bust_visible_type_134, d0_.measure_waist_visible_type AS measure_waist_visible_type_135, d0_.measure_hips_visible_type AS measure_hips_visible_type_136, d0_.measure_inseam_visible_type AS measure_inseam_visible_type_137, d0_.measure_skirt_visible_type AS measure_skirt_visible_type_138, d0_.measure_slacks_visible_type AS measure_slacks_visible_type_139, d0_.dr06_visible_type AS dr06_visible_type_140, d0_.dr14_visible_type AS dr14_visible_type_141, d0_.dr15_visible_type AS dr15_visible_type_142, d0_.dr16_visible_type AS dr16_visible_type_143, d0_.dr17_visible_type AS dr17_visible_type_144, d0_.dr23_visible_type AS dr23_visible_type_145, d0_.dr24_visible_type AS dr24_visible_type_146, d0_.dr25_visible_type AS dr25_visible_type_147, d0_.dr50_visible_type AS dr50_visible_type_148, d0_.dr51_visible_type AS dr51_visible_type_149, d0_.dr52_visible_type AS dr52_visible_type_150, d0_.dr53_visible_type AS dr53_visible_type_151, d0_.dantai_visible_type AS dantai_visible_type_152, d0_.daihyou_visible_type AS daihyou_visible_type_153, d0_.daikana_visible_type AS daikana_visible_type_154, d0_.namtxt_visible_type AS namtxt_visible_type_155, d0_.measuring_method_visible_type AS measuring_method_visible_type_156, d0_.enter_year_class AS enter_year_class_157, d0_.visible_commodity_alert AS visible_commodity_alert_158, d0_.visible_flg AS visible_flg_159, d0_.brother_flg AS brother_flg_160, d0_.require_school_key AS require_school_key_161, d0_.require_brothers AS require_brothers_162, d0_.product_sexvisible_type AS product_sexvisible_type_163, d0_.report_measure_flag AS report_measure_flag_164, d0_.report_grade_flag AS report_grade_flag_165, d0_.report_class_flag AS report_class_flag_166, d0_.report_storemail_flag AS report_storemail_flag_167, d0_.report_tax_flag AS report_tax_flag_168, d0_.report_setproduct_size_flag AS report_setproduct_size_flag_169, d0_.report_font_size AS report_font_size_170, d0_.order_delivery_notation AS order_delivery_notation_171, d0_.order_payment_notation AS order_payment_notation_172, d0_.addr01_max_length AS addr01_max_length_173, d0_.addr02_max_length AS addr02_max_length_174, d0_.order_message_flag AS order_message_flag_175, d0_.order_message_notation AS order_message_notation_176, d0_.order_email_header_text AS order_email_header_text_177, d0_.order_email_product_details_flag AS order_email_product_details_flag_178, d0_.order_email_customer_info_flag AS order_email_customer_info_flag_179, d0_.order_email_school_name_flag AS order_email_school_name_flag_180, d0_.order_email_admission_year_flag AS order_email_admission_year_flag_181, d0_.order_email_shipping_info_flag AS order_email_shipping_info_flag_182, d0_.redirect_flg AS redirect_flg_183, d0_.redirect_url AS redirect_url_184, d0_.display_notice AS display_notice_185, d0_.notice_text AS notice_text_186, d0_.display_cart_notice AS display_cart_notice_187, d0_.cart_notice_text AS cart_notice_text_188, d0_.display_saisun_notice AS display_saisun_notice_189, d0_.saisun_notice_text AS saisun_notice_text_190, d0_.display_product_notice AS display_product_notice_191, d0_.product_notice_text AS product_notice_text_192, d0_.examinee_lookup_enabled AS examinee_lookup_enabled_193, d0_.discriminator_type AS discriminator_type_194, d0_.recommend_id AS recommend_id_195 FROM dtb_school d0_ WHERE (d0_.visible_flg = 1 AND d0_.del_flg = 0) AND d0_.discriminator_type IN ('school') ORDER BY d0_.school_order ASC;
1.13 ms (24.30%)	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_.del_flg AS del_flg_21, d0_.school_code AS school_code_22, d0_.entry_url AS entry_url_23, d0_.delivery_free_type AS delivery_free_type_24, d0_.delivery_free_amount AS delivery_free_amount_25, d0_.delivery_free_quantity AS delivery_free_quantity_26, d0_.measure_plugin_type AS measure_plugin_type_27, d0_.default_sex_products_filtering_flag AS default_sex_products_filtering_flag_28, d0_.measuring_registration_required_flag AS measuring_registration_required_flag_29, d0_.top_page_popup_flag AS top_page_popup_flag_30, d0_.reg_data_confirmation_flag AS reg_data_confirmation_flag_31, d0_.reserver_popup_flag AS reserver_popup_flag_32, d0_.reserver_popup_text AS reserver_popup_text_33, d0_.reserve_note_visible_flag AS reserve_note_visible_flag_34, d0_.reg_data_popup_flag AS reg_data_popup_flag_35, d0_.chat_bot_flag AS chat_bot_flag_36, d0_.measuring_data_confirmation_flag AS measuring_data_confirmation_flag_37, d0_.size_recommend_flag AS size_recommend_flag_38, d0_.item_visible_type AS item_visible_type_39, d0_.filter_visible_flag AS filter_visible_flag_40, d0_.shopping_guide_menu_flag AS shopping_guide_menu_flag_41, d0_.shopping_guide_banner_flag AS shopping_guide_banner_flag_42, d0_.correct_size_menu_flag AS correct_size_menu_flag_43, d0_.correct_size_banner_flag AS correct_size_banner_flag_44, d0_.commitment_uniform_menu_flag AS commitment_uniform_menu_flag_45, d0_.commitment_uniform_banner_flag AS commitment_uniform_banner_flag_46, d0_.measurement_procedure_banner_flag AS measurement_procedure_banner_flag_47, d0_.return_exchange_banner_flag AS return_exchange_banner_flag_48, d0_.store_info_menu_flag AS store_info_menu_flag_49, d0_.document_print_content_flag AS document_print_content_flag_50, d0_.sale_start_date AS sale_start_date_51, d0_.sale_end_date AS sale_end_date_52, d0_.reservation_site_url AS reservation_site_url_53, d0_.name_notation AS name_notation_54, d0_.name01_entry_sample AS name01_entry_sample_55, d0_.name02_entry_sample AS name02_entry_sample_56, d0_.kana_notation AS kana_notation_57, d0_.kana01_entry_sample AS kana01_entry_sample_58, d0_.kana02_entry_sample AS kana02_entry_sample_59, d0_.name_visible_type AS name_visible_type_60, d0_.addr_notation AS addr_notation_61, d0_.zip01_entry_sample AS zip01_entry_sample_62, d0_.zip02_entry_sample AS zip02_entry_sample_63, d0_.addr01_entry_sample AS addr01_entry_sample_64, d0_.addr02_entry_sample AS addr02_entry_sample_65, d0_.addr_visible_type AS addr_visible_type_66, d0_.addr_visible_all AS addr_visible_all_67, d0_.tel_notation AS tel_notation_68, d0_.tel1_01_entry_sample AS tel1_01_entry_sample_69, d0_.tel1_02_entry_sample AS tel1_02_entry_sample_70, d0_.tel1_03_entry_sample AS tel1_03_entry_sample_71, d0_.tel01_visible_type AS tel01_visible_type_72, d0_.tel02_visible_type AS tel02_visible_type_73, d0_.tel2_notation AS tel2_notation_74, d0_.tel2_01_entry_sample AS tel2_01_entry_sample_75, d0_.tel2_02_entry_sample AS tel2_02_entry_sample_76, d0_.tel2_03_entry_sample AS tel2_03_entry_sample_77, d0_.email_notation AS email_notation_78, d0_.email_entry_sample AS email_entry_sample_79, d0_.email_visible_type AS email_visible_type_80, d0_.password_notation AS password_notation_81, d0_.password_entry_sample AS password_entry_sample_82, d0_.password_visible_type AS password_visible_type_83, d0_.adyear_visible_type AS adyear_visible_type_84, d0_.adyear_notation AS adyear_notation_85, d0_.adyear_entry_sample AS adyear_entry_sample_86, d0_.exam_number_visible_type AS exam_number_visible_type_87, d0_.exam_number_notation AS exam_number_notation_88, d0_.exam_number_entry_sample AS exam_number_entry_sample_89, d0_.prev_school_visible_type AS prev_school_visible_type_90, d0_.prev_school_notation AS prev_school_notation_91, d0_.prev_school_entry_sample AS prev_school_entry_sample_92, d0_.prev_year_class_visible_type AS prev_year_class_visible_type_93, d0_.prev_year_class_notation AS prev_year_class_notation_94, d0_.prev_year_entry_sample AS prev_year_entry_sample_95, d0_.prev_class_entry_sample AS prev_class_entry_sample_96, d0_.birth_visible_type AS birth_visible_type_97, d0_.birth_notation AS birth_notation_98, d0_.birth_entry_sample AS birth_entry_sample_99, d0_.parents_name_visible_type AS parents_name_visible_type_100, d0_.parents_name_notation AS parents_name_notation_101, d0_.parents_name01_entry_sample AS parents_name01_entry_sample_102, d0_.parents_name02_entry_sample AS parents_name02_entry_sample_103, d0_.parents_birth_visible_type AS parents_birth_visible_type_104, d0_.parents_birth_notation AS parents_birth_notation_105, d0_.parents_birth_entry_sample AS parents_birth_entry_sample_106, d0_.current_year_visible_type AS current_year_visible_type_107, d0_.current_year_class_notation AS current_year_class_notation_108, d0_.current_year_entry_sample AS current_year_entry_sample_109, d0_.current_class_notation AS current_class_notation_110, d0_.student_number_visible_type AS student_number_visible_type_111, d0_.student_number_notation AS student_number_notation_112, d0_.student_number_entry_sample AS student_number_entry_sample_113, d0_.freeitem1_visible_type AS freeitem1_visible_type_114, d0_.freeitem1_name AS freeitem1_name_115, d0_.freeitem1_notation AS freeitem1_notation_116, d0_.freeitem1_entry_sample AS freeitem1_entry_sample_117, d0_.freeitem1_max_length AS freeitem1_max_length_118, d0_.freeitem2_visible_type AS freeitem2_visible_type_119, d0_.freeitem2_name AS freeitem2_name_120, d0_.freeitem2_notation AS freeitem2_notation_121, d0_.freeitem2_entry_sample AS freeitem2_entry_sample_122, d0_.freeitem2_max_length AS freeitem2_max_length_123, d0_.sex_visible_type AS sex_visible_type_124, d0_.sex_show_noanswer AS sex_show_noanswer_125, d0_.fax_visible_type AS fax_visible_type_126, d0_.measure_height_visible_type AS measure_height_visible_type_127, d0_.measure_weight_visible_type AS measure_weight_visible_type_128, d0_.measure_shoulder_visible_type AS measure_shoulder_visible_type_129, d0_.measure_sleeve1_visible_type AS measure_sleeve1_visible_type_130, d0_.measure_sleeve2_visible_type AS measure_sleeve2_visible_type_131, d0_.measure_total_visible_type AS measure_total_visible_type_132, d0_.measure_neck_visible_type AS measure_neck_visible_type_133, d0_.measure_bust_visible_type AS measure_bust_visible_type_134, d0_.measure_waist_visible_type AS measure_waist_visible_type_135, d0_.measure_hips_visible_type AS measure_hips_visible_type_136, d0_.measure_inseam_visible_type AS measure_inseam_visible_type_137, d0_.measure_skirt_visible_type AS measure_skirt_visible_type_138, d0_.measure_slacks_visible_type AS measure_slacks_visible_type_139, d0_.dr06_visible_type AS dr06_visible_type_140, d0_.dr14_visible_type AS dr14_visible_type_141, d0_.dr15_visible_type AS dr15_visible_type_142, d0_.dr16_visible_type AS dr16_visible_type_143, d0_.dr17_visible_type AS dr17_visible_type_144, d0_.dr23_visible_type AS dr23_visible_type_145, d0_.dr24_visible_type AS dr24_visible_type_146, d0_.dr25_visible_type AS dr25_visible_type_147, d0_.dr50_visible_type AS dr50_visible_type_148, d0_.dr51_visible_type AS dr51_visible_type_149, d0_.dr52_visible_type AS dr52_visible_type_150, d0_.dr53_visible_type AS dr53_visible_type_151, d0_.dantai_visible_type AS dantai_visible_type_152, d0_.daihyou_visible_type AS daihyou_visible_type_153, d0_.daikana_visible_type AS daikana_visible_type_154, d0_.namtxt_visible_type AS namtxt_visible_type_155, d0_.measuring_method_visible_type AS measuring_method_visible_type_156, d0_.enter_year_class AS enter_year_class_157, d0_.visible_commodity_alert AS visible_commodity_alert_158, d0_.visible_flg AS visible_flg_159, d0_.brother_flg AS brother_flg_160, d0_.require_school_key AS require_school_key_161, d0_.require_brothers AS require_brothers_162, d0_.product_sexvisible_type AS product_sexvisible_type_163, d0_.report_measure_flag AS report_measure_flag_164, d0_.report_grade_flag AS report_grade_flag_165, d0_.report_class_flag AS report_class_flag_166, d0_.report_storemail_flag AS report_storemail_flag_167, d0_.report_tax_flag AS report_tax_flag_168, d0_.report_setproduct_size_flag AS report_setproduct_size_flag_169, d0_.report_font_size AS report_font_size_170, d0_.order_delivery_notation AS order_delivery_notation_171, d0_.order_payment_notation AS order_payment_notation_172, d0_.addr01_max_length AS addr01_max_length_173, d0_.addr02_max_length AS addr02_max_length_174, d0_.order_message_flag AS order_message_flag_175, d0_.order_message_notation AS order_message_notation_176, d0_.order_email_header_text AS order_email_header_text_177, d0_.order_email_product_details_flag AS order_email_product_details_flag_178, d0_.order_email_customer_info_flag AS order_email_customer_info_flag_179, d0_.order_email_school_name_flag AS order_email_school_name_flag_180, d0_.order_email_admission_year_flag AS order_email_admission_year_flag_181, d0_.order_email_shipping_info_flag AS order_email_shipping_info_flag_182, d0_.redirect_flg AS redirect_flg_183, d0_.redirect_url AS redirect_url_184, d0_.display_notice AS display_notice_185, d0_.notice_text AS notice_text_186, d0_.display_cart_notice AS display_cart_notice_187, d0_.cart_notice_text AS cart_notice_text_188, d0_.display_saisun_notice AS display_saisun_notice_189, d0_.saisun_notice_text AS saisun_notice_text_190, d0_.display_product_notice AS display_product_notice_191, d0_.product_notice_text AS product_notice_text_192, d0_.examinee_lookup_enabled AS examinee_lookup_enabled_193, d0_.discriminator_type AS discriminator_type_194, d0_.recommend_id AS recommend_id_195 FROM dtb_school d0_ WHERE (d0_.target_student = ? AND d0_.del_flg = ?) AND d0_.discriminator_type IN ('school') ORDER BY d0_.school_id ASC LIMIT 1 Parameters: [`3 0`] View formatted query View runnable query Explain query 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_.del_flg AS del_flg_21, d0_.school_code AS school_code_22, d0_.entry_url AS entry_url_23, d0_.delivery_free_type AS delivery_free_type_24, d0_.delivery_free_amount AS delivery_free_amount_25, d0_.delivery_free_quantity AS delivery_free_quantity_26, d0_.measure_plugin_type AS measure_plugin_type_27, d0_.default_sex_products_filtering_flag AS default_sex_products_filtering_flag_28, d0_.measuring_registration_required_flag AS measuring_registration_required_flag_29, d0_.top_page_popup_flag AS top_page_popup_flag_30, d0_.reg_data_confirmation_flag AS reg_data_confirmation_flag_31, d0_.reserver_popup_flag AS reserver_popup_flag_32, d0_.reserver_popup_text AS reserver_popup_text_33, d0_.reserve_note_visible_flag AS reserve_note_visible_flag_34, d0_.reg_data_popup_flag AS reg_data_popup_flag_35, d0_.chat_bot_flag AS chat_bot_flag_36, d0_.measuring_data_confirmation_flag AS measuring_data_confirmation_flag_37, d0_.size_recommend_flag AS size_recommend_flag_38, d0_.item_visible_type AS item_visible_type_39, d0_.filter_visible_flag AS filter_visible_flag_40, d0_.shopping_guide_menu_flag AS shopping_guide_menu_flag_41, d0_.shopping_guide_banner_flag AS shopping_guide_banner_flag_42, d0_.correct_size_menu_flag AS correct_size_menu_flag_43, d0_.correct_size_banner_flag AS correct_size_banner_flag_44, d0_.commitment_uniform_menu_flag AS commitment_uniform_menu_flag_45, d0_.commitment_uniform_banner_flag AS commitment_uniform_banner_flag_46, d0_.measurement_procedure_banner_flag AS measurement_procedure_banner_flag_47, d0_.return_exchange_banner_flag AS return_exchange_banner_flag_48, d0_.store_info_menu_flag AS store_info_menu_flag_49, d0_.document_print_content_flag AS document_print_content_flag_50, d0_.sale_start_date AS sale_start_date_51, d0_.sale_end_date AS sale_end_date_52, d0_.reservation_site_url AS reservation_site_url_53, d0_.name_notation AS name_notation_54, d0_.name01_entry_sample AS name01_entry_sample_55, d0_.name02_entry_sample AS name02_entry_sample_56, d0_.kana_notation AS kana_notation_57, d0_.kana01_entry_sample AS kana01_entry_sample_58, d0_.kana02_entry_sample AS kana02_entry_sample_59, d0_.name_visible_type AS name_visible_type_60, d0_.addr_notation AS addr_notation_61, d0_.zip01_entry_sample AS zip01_entry_sample_62, d0_.zip02_entry_sample AS zip02_entry_sample_63, d0_.addr01_entry_sample AS addr01_entry_sample_64, d0_.addr02_entry_sample AS addr02_entry_sample_65, d0_.addr_visible_type AS addr_visible_type_66, d0_.addr_visible_all AS addr_visible_all_67, d0_.tel_notation AS tel_notation_68, d0_.tel1_01_entry_sample AS tel1_01_entry_sample_69, d0_.tel1_02_entry_sample AS tel1_02_entry_sample_70, d0_.tel1_03_entry_sample AS tel1_03_entry_sample_71, d0_.tel01_visible_type AS tel01_visible_type_72, d0_.tel02_visible_type AS tel02_visible_type_73, d0_.tel2_notation AS tel2_notation_74, d0_.tel2_01_entry_sample AS tel2_01_entry_sample_75, d0_.tel2_02_entry_sample AS tel2_02_entry_sample_76, d0_.tel2_03_entry_sample AS tel2_03_entry_sample_77, d0_.email_notation AS email_notation_78, d0_.email_entry_sample AS email_entry_sample_79, d0_.email_visible_type AS email_visible_type_80, d0_.password_notation AS password_notation_81, d0_.password_entry_sample AS password_entry_sample_82, d0_.password_visible_type AS password_visible_type_83, d0_.adyear_visible_type AS adyear_visible_type_84, d0_.adyear_notation AS adyear_notation_85, d0_.adyear_entry_sample AS adyear_entry_sample_86, d0_.exam_number_visible_type AS exam_number_visible_type_87, d0_.exam_number_notation AS exam_number_notation_88, d0_.exam_number_entry_sample AS exam_number_entry_sample_89, d0_.prev_school_visible_type AS prev_school_visible_type_90, d0_.prev_school_notation AS prev_school_notation_91, d0_.prev_school_entry_sample AS prev_school_entry_sample_92, d0_.prev_year_class_visible_type AS prev_year_class_visible_type_93, d0_.prev_year_class_notation AS prev_year_class_notation_94, d0_.prev_year_entry_sample AS prev_year_entry_sample_95, d0_.prev_class_entry_sample AS prev_class_entry_sample_96, d0_.birth_visible_type AS birth_visible_type_97, d0_.birth_notation AS birth_notation_98, d0_.birth_entry_sample AS birth_entry_sample_99, d0_.parents_name_visible_type AS parents_name_visible_type_100, d0_.parents_name_notation AS parents_name_notation_101, d0_.parents_name01_entry_sample AS parents_name01_entry_sample_102, d0_.parents_name02_entry_sample AS parents_name02_entry_sample_103, d0_.parents_birth_visible_type AS parents_birth_visible_type_104, d0_.parents_birth_notation AS parents_birth_notation_105, d0_.parents_birth_entry_sample AS parents_birth_entry_sample_106, d0_.current_year_visible_type AS current_year_visible_type_107, d0_.current_year_class_notation AS current_year_class_notation_108, d0_.current_year_entry_sample AS current_year_entry_sample_109, d0_.current_class_notation AS current_class_notation_110, d0_.student_number_visible_type AS student_number_visible_type_111, d0_.student_number_notation AS student_number_notation_112, d0_.student_number_entry_sample AS student_number_entry_sample_113, d0_.freeitem1_visible_type AS freeitem1_visible_type_114, d0_.freeitem1_name AS freeitem1_name_115, d0_.freeitem1_notation AS freeitem1_notation_116, d0_.freeitem1_entry_sample AS freeitem1_entry_sample_117, d0_.freeitem1_max_length AS freeitem1_max_length_118, d0_.freeitem2_visible_type AS freeitem2_visible_type_119, d0_.freeitem2_name AS freeitem2_name_120, d0_.freeitem2_notation AS freeitem2_notation_121, d0_.freeitem2_entry_sample AS freeitem2_entry_sample_122, d0_.freeitem2_max_length AS freeitem2_max_length_123, d0_.sex_visible_type AS sex_visible_type_124, d0_.sex_show_noanswer AS sex_show_noanswer_125, d0_.fax_visible_type AS fax_visible_type_126, d0_.measure_height_visible_type AS measure_height_visible_type_127, d0_.measure_weight_visible_type AS measure_weight_visible_type_128, d0_.measure_shoulder_visible_type AS measure_shoulder_visible_type_129, d0_.measure_sleeve1_visible_type AS measure_sleeve1_visible_type_130, d0_.measure_sleeve2_visible_type AS measure_sleeve2_visible_type_131, d0_.measure_total_visible_type AS measure_total_visible_type_132, d0_.measure_neck_visible_type AS measure_neck_visible_type_133, d0_.measure_bust_visible_type AS measure_bust_visible_type_134, d0_.measure_waist_visible_type AS measure_waist_visible_type_135, d0_.measure_hips_visible_type AS measure_hips_visible_type_136, d0_.measure_inseam_visible_type AS measure_inseam_visible_type_137, d0_.measure_skirt_visible_type AS measure_skirt_visible_type_138, d0_.measure_slacks_visible_type AS measure_slacks_visible_type_139, d0_.dr06_visible_type AS dr06_visible_type_140, d0_.dr14_visible_type AS dr14_visible_type_141, d0_.dr15_visible_type AS dr15_visible_type_142, d0_.dr16_visible_type AS dr16_visible_type_143, d0_.dr17_visible_type AS dr17_visible_type_144, d0_.dr23_visible_type AS dr23_visible_type_145, d0_.dr24_visible_type AS dr24_visible_type_146, d0_.dr25_visible_type AS dr25_visible_type_147, d0_.dr50_visible_type AS dr50_visible_type_148, d0_.dr51_visible_type AS dr51_visible_type_149, d0_.dr52_visible_type AS dr52_visible_type_150, d0_.dr53_visible_type AS dr53_visible_type_151, d0_.dantai_visible_type AS dantai_visible_type_152, d0_.daihyou_visible_type AS daihyou_visible_type_153, d0_.daikana_visible_type AS daikana_visible_type_154, d0_.namtxt_visible_type AS namtxt_visible_type_155, d0_.measuring_method_visible_type AS measuring_method_visible_type_156, d0_.enter_year_class AS enter_year_class_157, d0_.visible_commodity_alert AS visible_commodity_alert_158, d0_.visible_flg AS visible_flg_159, d0_.brother_flg AS brother_flg_160, d0_.require_school_key AS require_school_key_161, d0_.require_brothers AS require_brothers_162, d0_.product_sexvisible_type AS product_sexvisible_type_163, d0_.report_measure_flag AS report_measure_flag_164, d0_.report_grade_flag AS report_grade_flag_165, d0_.report_class_flag AS report_class_flag_166, d0_.report_storemail_flag AS report_storemail_flag_167, d0_.report_tax_flag AS report_tax_flag_168, d0_.report_setproduct_size_flag AS report_setproduct_size_flag_169, d0_.report_font_size AS report_font_size_170, d0_.order_delivery_notation AS order_delivery_notation_171, d0_.order_payment_notation AS order_payment_notation_172, d0_.addr01_max_length AS addr01_max_length_173, d0_.addr02_max_length AS addr02_max_length_174, d0_.order_message_flag AS order_message_flag_175, d0_.order_message_notation AS order_message_notation_176, d0_.order_email_header_text AS order_email_header_text_177, d0_.order_email_product_details_flag AS order_email_product_details_flag_178, d0_.order_email_customer_info_flag AS order_email_customer_info_flag_179, d0_.order_email_school_name_flag AS order_email_school_name_flag_180, d0_.order_email_admission_year_flag AS order_email_admission_year_flag_181, d0_.order_email_shipping_info_flag AS order_email_shipping_info_flag_182, d0_.redirect_flg AS redirect_flg_183, d0_.redirect_url AS redirect_url_184, d0_.display_notice AS display_notice_185, d0_.notice_text AS notice_text_186, d0_.display_cart_notice AS display_cart_notice_187, d0_.cart_notice_text AS cart_notice_text_188, d0_.display_saisun_notice AS display_saisun_notice_189, d0_.saisun_notice_text AS saisun_notice_text_190, d0_.display_product_notice AS display_product_notice_191, d0_.product_notice_text AS product_notice_text_192, d0_.examinee_lookup_enabled AS examinee_lookup_enabled_193, d0_.discriminator_type AS discriminator_type_194, d0_.recommend_id AS recommend_id_195 FROM dtb_school d0_ WHERE ( d0_.target_student = ? AND d0_.del_flg = ? ) AND d0_.discriminator_type IN ('school') ORDER BY d0_.school_id ASC LIMIT 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_.del_flg AS del_flg_21, d0_.school_code AS school_code_22, d0_.entry_url AS entry_url_23, d0_.delivery_free_type AS delivery_free_type_24, d0_.delivery_free_amount AS delivery_free_amount_25, d0_.delivery_free_quantity AS delivery_free_quantity_26, d0_.measure_plugin_type AS measure_plugin_type_27, d0_.default_sex_products_filtering_flag AS default_sex_products_filtering_flag_28, d0_.measuring_registration_required_flag AS measuring_registration_required_flag_29, d0_.top_page_popup_flag AS top_page_popup_flag_30, d0_.reg_data_confirmation_flag AS reg_data_confirmation_flag_31, d0_.reserver_popup_flag AS reserver_popup_flag_32, d0_.reserver_popup_text AS reserver_popup_text_33, d0_.reserve_note_visible_flag AS reserve_note_visible_flag_34, d0_.reg_data_popup_flag AS reg_data_popup_flag_35, d0_.chat_bot_flag AS chat_bot_flag_36, d0_.measuring_data_confirmation_flag AS measuring_data_confirmation_flag_37, d0_.size_recommend_flag AS size_recommend_flag_38, d0_.item_visible_type AS item_visible_type_39, d0_.filter_visible_flag AS filter_visible_flag_40, d0_.shopping_guide_menu_flag AS shopping_guide_menu_flag_41, d0_.shopping_guide_banner_flag AS shopping_guide_banner_flag_42, d0_.correct_size_menu_flag AS correct_size_menu_flag_43, d0_.correct_size_banner_flag AS correct_size_banner_flag_44, d0_.commitment_uniform_menu_flag AS commitment_uniform_menu_flag_45, d0_.commitment_uniform_banner_flag AS commitment_uniform_banner_flag_46, d0_.measurement_procedure_banner_flag AS measurement_procedure_banner_flag_47, d0_.return_exchange_banner_flag AS return_exchange_banner_flag_48, d0_.store_info_menu_flag AS store_info_menu_flag_49, d0_.document_print_content_flag AS document_print_content_flag_50, d0_.sale_start_date AS sale_start_date_51, d0_.sale_end_date AS sale_end_date_52, d0_.reservation_site_url AS reservation_site_url_53, d0_.name_notation AS name_notation_54, d0_.name01_entry_sample AS name01_entry_sample_55, d0_.name02_entry_sample AS name02_entry_sample_56, d0_.kana_notation AS kana_notation_57, d0_.kana01_entry_sample AS kana01_entry_sample_58, d0_.kana02_entry_sample AS kana02_entry_sample_59, d0_.name_visible_type AS name_visible_type_60, d0_.addr_notation AS addr_notation_61, d0_.zip01_entry_sample AS zip01_entry_sample_62, d0_.zip02_entry_sample AS zip02_entry_sample_63, d0_.addr01_entry_sample AS addr01_entry_sample_64, d0_.addr02_entry_sample AS addr02_entry_sample_65, d0_.addr_visible_type AS addr_visible_type_66, d0_.addr_visible_all AS addr_visible_all_67, d0_.tel_notation AS tel_notation_68, d0_.tel1_01_entry_sample AS tel1_01_entry_sample_69, d0_.tel1_02_entry_sample AS tel1_02_entry_sample_70, d0_.tel1_03_entry_sample AS tel1_03_entry_sample_71, d0_.tel01_visible_type AS tel01_visible_type_72, d0_.tel02_visible_type AS tel02_visible_type_73, d0_.tel2_notation AS tel2_notation_74, d0_.tel2_01_entry_sample AS tel2_01_entry_sample_75, d0_.tel2_02_entry_sample AS tel2_02_entry_sample_76, d0_.tel2_03_entry_sample AS tel2_03_entry_sample_77, d0_.email_notation AS email_notation_78, d0_.email_entry_sample AS email_entry_sample_79, d0_.email_visible_type AS email_visible_type_80, d0_.password_notation AS password_notation_81, d0_.password_entry_sample AS password_entry_sample_82, d0_.password_visible_type AS password_visible_type_83, d0_.adyear_visible_type AS adyear_visible_type_84, d0_.adyear_notation AS adyear_notation_85, d0_.adyear_entry_sample AS adyear_entry_sample_86, d0_.exam_number_visible_type AS exam_number_visible_type_87, d0_.exam_number_notation AS exam_number_notation_88, d0_.exam_number_entry_sample AS exam_number_entry_sample_89, d0_.prev_school_visible_type AS prev_school_visible_type_90, d0_.prev_school_notation AS prev_school_notation_91, d0_.prev_school_entry_sample AS prev_school_entry_sample_92, d0_.prev_year_class_visible_type AS prev_year_class_visible_type_93, d0_.prev_year_class_notation AS prev_year_class_notation_94, d0_.prev_year_entry_sample AS prev_year_entry_sample_95, d0_.prev_class_entry_sample AS prev_class_entry_sample_96, d0_.birth_visible_type AS birth_visible_type_97, d0_.birth_notation AS birth_notation_98, d0_.birth_entry_sample AS birth_entry_sample_99, d0_.parents_name_visible_type AS parents_name_visible_type_100, d0_.parents_name_notation AS parents_name_notation_101, d0_.parents_name01_entry_sample AS parents_name01_entry_sample_102, d0_.parents_name02_entry_sample AS parents_name02_entry_sample_103, d0_.parents_birth_visible_type AS parents_birth_visible_type_104, d0_.parents_birth_notation AS parents_birth_notation_105, d0_.parents_birth_entry_sample AS parents_birth_entry_sample_106, d0_.current_year_visible_type AS current_year_visible_type_107, d0_.current_year_class_notation AS current_year_class_notation_108, d0_.current_year_entry_sample AS current_year_entry_sample_109, d0_.current_class_notation AS current_class_notation_110, d0_.student_number_visible_type AS student_number_visible_type_111, d0_.student_number_notation AS student_number_notation_112, d0_.student_number_entry_sample AS student_number_entry_sample_113, d0_.freeitem1_visible_type AS freeitem1_visible_type_114, d0_.freeitem1_name AS freeitem1_name_115, d0_.freeitem1_notation AS freeitem1_notation_116, d0_.freeitem1_entry_sample AS freeitem1_entry_sample_117, d0_.freeitem1_max_length AS freeitem1_max_length_118, d0_.freeitem2_visible_type AS freeitem2_visible_type_119, d0_.freeitem2_name AS freeitem2_name_120, d0_.freeitem2_notation AS freeitem2_notation_121, d0_.freeitem2_entry_sample AS freeitem2_entry_sample_122, d0_.freeitem2_max_length AS freeitem2_max_length_123, d0_.sex_visible_type AS sex_visible_type_124, d0_.sex_show_noanswer AS sex_show_noanswer_125, d0_.fax_visible_type AS fax_visible_type_126, d0_.measure_height_visible_type AS measure_height_visible_type_127, d0_.measure_weight_visible_type AS measure_weight_visible_type_128, d0_.measure_shoulder_visible_type AS measure_shoulder_visible_type_129, d0_.measure_sleeve1_visible_type AS measure_sleeve1_visible_type_130, d0_.measure_sleeve2_visible_type AS measure_sleeve2_visible_type_131, d0_.measure_total_visible_type AS measure_total_visible_type_132, d0_.measure_neck_visible_type AS measure_neck_visible_type_133, d0_.measure_bust_visible_type AS measure_bust_visible_type_134, d0_.measure_waist_visible_type AS measure_waist_visible_type_135, d0_.measure_hips_visible_type AS measure_hips_visible_type_136, d0_.measure_inseam_visible_type AS measure_inseam_visible_type_137, d0_.measure_skirt_visible_type AS measure_skirt_visible_type_138, d0_.measure_slacks_visible_type AS measure_slacks_visible_type_139, d0_.dr06_visible_type AS dr06_visible_type_140, d0_.dr14_visible_type AS dr14_visible_type_141, d0_.dr15_visible_type AS dr15_visible_type_142, d0_.dr16_visible_type AS dr16_visible_type_143, d0_.dr17_visible_type AS dr17_visible_type_144, d0_.dr23_visible_type AS dr23_visible_type_145, d0_.dr24_visible_type AS dr24_visible_type_146, d0_.dr25_visible_type AS dr25_visible_type_147, d0_.dr50_visible_type AS dr50_visible_type_148, d0_.dr51_visible_type AS dr51_visible_type_149, d0_.dr52_visible_type AS dr52_visible_type_150, d0_.dr53_visible_type AS dr53_visible_type_151, d0_.dantai_visible_type AS dantai_visible_type_152, d0_.daihyou_visible_type AS daihyou_visible_type_153, d0_.daikana_visible_type AS daikana_visible_type_154, d0_.namtxt_visible_type AS namtxt_visible_type_155, d0_.measuring_method_visible_type AS measuring_method_visible_type_156, d0_.enter_year_class AS enter_year_class_157, d0_.visible_commodity_alert AS visible_commodity_alert_158, d0_.visible_flg AS visible_flg_159, d0_.brother_flg AS brother_flg_160, d0_.require_school_key AS require_school_key_161, d0_.require_brothers AS require_brothers_162, d0_.product_sexvisible_type AS product_sexvisible_type_163, d0_.report_measure_flag AS report_measure_flag_164, d0_.report_grade_flag AS report_grade_flag_165, d0_.report_class_flag AS report_class_flag_166, d0_.report_storemail_flag AS report_storemail_flag_167, d0_.report_tax_flag AS report_tax_flag_168, d0_.report_setproduct_size_flag AS report_setproduct_size_flag_169, d0_.report_font_size AS report_font_size_170, d0_.order_delivery_notation AS order_delivery_notation_171, d0_.order_payment_notation AS order_payment_notation_172, d0_.addr01_max_length AS addr01_max_length_173, d0_.addr02_max_length AS addr02_max_length_174, d0_.order_message_flag AS order_message_flag_175, d0_.order_message_notation AS order_message_notation_176, d0_.order_email_header_text AS order_email_header_text_177, d0_.order_email_product_details_flag AS order_email_product_details_flag_178, d0_.order_email_customer_info_flag AS order_email_customer_info_flag_179, d0_.order_email_school_name_flag AS order_email_school_name_flag_180, d0_.order_email_admission_year_flag AS order_email_admission_year_flag_181, d0_.order_email_shipping_info_flag AS order_email_shipping_info_flag_182, d0_.redirect_flg AS redirect_flg_183, d0_.redirect_url AS redirect_url_184, d0_.display_notice AS display_notice_185, d0_.notice_text AS notice_text_186, d0_.display_cart_notice AS display_cart_notice_187, d0_.cart_notice_text AS cart_notice_text_188, d0_.display_saisun_notice AS display_saisun_notice_189, d0_.saisun_notice_text AS saisun_notice_text_190, d0_.display_product_notice AS display_product_notice_191, d0_.product_notice_text AS product_notice_text_192, d0_.examinee_lookup_enabled AS examinee_lookup_enabled_193, d0_.discriminator_type AS discriminator_type_194, d0_.recommend_id AS recommend_id_195 FROM dtb_school d0_ WHERE (d0_.target_student = 3 AND d0_.del_flg = 0) AND d0_.discriminator_type IN ('school') ORDER BY d0_.school_id ASC LIMIT 1;
0.46 ms (9.88%)	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.option_mall AS option_mall_36, t0.country_id AS country_id_37, t0.pref_id AS pref_id_38, t0.discriminator_type FROM dtb_base_info t0 WHERE t0.discriminator_type IN ('baseinfo') LIMIT 1 Parameters: [] View formatted query View runnable query Explain query 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.option_mall AS option_mall_36, t0.country_id AS country_id_37, t0.pref_id AS pref_id_38, t0.discriminator_type FROM dtb_base_info t0 WHERE t0.discriminator_type IN ('baseinfo') LIMIT 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.option_mall AS option_mall_36, t0.country_id AS country_id_37, t0.pref_id AS pref_id_38, t0.discriminator_type FROM dtb_base_info t0 WHERE t0.discriminator_type IN ('baseinfo') LIMIT 1;
0.45 ms (9.66%)	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') Parameters: [`"contact"`] View formatted query View runnable query Explain query 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 = 'contact') AND d0_.discriminator_type IN ('page');
0.35 ms (7.61%)	1	SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.sort_no AS sort_no_2, m0_.discriminator_type AS discriminator_type_3 FROM mtb_pref m0_ WHERE m0_.discriminator_type IN ('pref') ORDER BY m0_.sort_no ASC Parameters: [] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.sort_no AS sort_no_2, m0_.discriminator_type AS discriminator_type_3 FROM mtb_pref m0_ WHERE m0_.discriminator_type IN ('pref') ORDER BY m0_.sort_no ASC SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.sort_no AS sort_no_2, m0_.discriminator_type AS discriminator_type_3 FROM mtb_pref m0_ WHERE m0_.discriminator_type IN ('pref') ORDER BY m0_.sort_no ASC;
0.21 ms (4.44%)	1	SET SESSION time_zone = '+00:00' Parameters: [] View formatted query View runnable query Explain query SET SESSION time_zone = '+00:00' SET SESSION time_zone = '+00:00';
0.17 ms (3.71%)	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 Parameters: [] View formatted query View runnable query Explain query 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;
0.17 ms (3.58%)	2	SELECT d0_.id AS id_0, d0_.status AS status_1, d0_.target_type AS target_type_2, d0_.title AS title_3, d0_.content AS content_4, d0_.start_time AS start_time_5, d0_.end_time AS end_time_6, d0_.create_date AS create_date_7, d0_.update_date AS update_date_8 FROM dtb_maintenance_settings d0_ WHERE d0_.status = ? ORDER BY d0_.update_date DESC, d0_.id DESC LIMIT 1 Parameters: [`1`] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.status AS status_1, d0_.target_type AS target_type_2, d0_.title AS title_3, d0_.content AS content_4, d0_.start_time AS start_time_5, d0_.end_time AS end_time_6, d0_.create_date AS create_date_7, d0_.update_date AS update_date_8 FROM dtb_maintenance_settings d0_ WHERE d0_.status = ? ORDER BY d0_.update_date DESC, d0_.id DESC LIMIT 1 SELECT d0_.id AS id_0, d0_.status AS status_1, d0_.target_type AS target_type_2, d0_.title AS title_3, d0_.content AS content_4, d0_.start_time AS start_time_5, d0_.end_time AS end_time_6, d0_.create_date AS create_date_7, d0_.update_date AS update_date_8 FROM dtb_maintenance_settings d0_ WHERE d0_.status = 1 ORDER BY d0_.update_date DESC, d0_.id DESC LIMIT 1;
0.14 ms (3.02%)	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.option_mall AS option_mall_36, t0.country_id AS country_id_37, t0.pref_id AS pref_id_38, t0.discriminator_type FROM dtb_base_info t0 WHERE t0.id = ? AND t0.discriminator_type IN ('baseinfo') Parameters: [`1`] View formatted query View runnable query Explain query 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.option_mall AS option_mall_36, t0.country_id AS country_id_37, t0.pref_id AS pref_id_38, 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.option_mall AS option_mall_36, t0.country_id AS country_id_37, t0.pref_id AS pref_id_38, t0.discriminator_type FROM dtb_base_info t0 WHERE t0.id = 1 AND t0.discriminator_type IN ('baseinfo');
0.13 ms (2.82%)	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 Parameters: [`2`] View formatted query View runnable query Explain query 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;
0.12 ms (2.57%)	1	SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED Parameters: [] View formatted query View runnable query Explain query SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
0.06 ms (1.25%)	1	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";

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
Eccube\Entity\AbstractEntity	No errors.
Eccube\Entity\Order	No errors.
Eccube\Entity\Customer	The field Eccube\Entity\Customer#Contacts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Plugin\ContactManagement42\Entity\Contact#Customer does not contain the required 'inversedBy="Contacts"' attribute.
Customize\Entity\ProductStore	No errors.
Eccube\Entity\Product	The field Eccube\Entity\Product#ProductSchool is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Customize\Entity\ProductSchool#Product does not contain the required 'inversedBy="ProductSchool"' attribute. The field Eccube\Entity\Product#ProductStore is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Customize\Entity\ProductStore#Product does not contain the required 'inversedBy="ProductStore"' attribute.
Customize\Entity\SetProductSchool	No errors.
Customize\Entity\ProductSchool	No errors.
Eccube\Entity\BaseInfo	No errors.
Eccube\Entity\Master\AbstractMasterEntity	No errors.
Eccube\Entity\Master\OrderStatus	No errors.
Customize\Entity\OrderSellerStatus	No errors.
Customize\Entity\Seller	No errors.
Eccube\Entity\Master\Country	No errors.
Eccube\Entity\Master\Pref	No errors.
Eccube\Entity\Category	No errors.
Customize\Entity\School	The field Customize\Entity\School#SchoolDelivery is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Customize\Entity\SchoolDelivery#School does not contain the required 'inversedBy="SchoolDelivery"' attribute.
Customize\Entity\MaintenanceSettings	No errors.
Eccube\Entity\Page	No errors.
Eccube\Entity\PageLayout	No errors.
Eccube\Entity\Block	No errors.
Eccube\Entity\BlockPosition	No errors.
Eccube\Entity\Master\DeviceType	No errors.
Eccube\Entity\AuthorityRole	No errors.
Eccube\Entity\Layout	No errors.
Eccube\Entity\MailTemplate	No errors.
Eccube\Entity\MailHistory	No errors.
Eccube\Entity\Member	No errors.
Customize\Entity\Recommend	No errors.
Customize\Entity\SchoolDelivery	No errors.
Customize\Entity\SchoolBrotherDisplay	No errors.
Eccube\Entity\ProductCategory	No errors.

Symfony Profiler

https://toraya-seifuku.com/block/search_product

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping