Symfony Profiler

SET
  SESSION time_zone = '+00:00'

SET SESSION time_zone = '+00:00';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.department AS department_3,
  t0.login_id AS login_id_4,
  t0.password AS password_5,
  t0.salt AS salt_6,
  t0.sort_no AS sort_no_7,
  t0.two_factor_auth_key AS two_factor_auth_key_8,
  t0.two_factor_auth_enabled AS two_factor_auth_enabled_9,
  t0.create_date AS create_date_10,
  t0.update_date AS update_date_11,
  t0.login_date AS login_date_12,
  t0.work_id AS work_id_13,
  t0.authority_id AS authority_id_14,
  t0.creator_id AS creator_id_15,
  t0.store_id AS store_id_16,
  t0.discriminator_type
FROM
  dtb_member t0
WHERE
  t0.login_id = ?
  AND t0.work_id = ?
  AND t0.discriminator_type IN ('member')
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.department AS department_3, t0.login_id AS login_id_4, t0.password AS password_5, t0.salt AS salt_6, t0.sort_no AS sort_no_7, t0.two_factor_auth_key AS two_factor_auth_key_8, t0.two_factor_auth_enabled AS two_factor_auth_enabled_9, t0.create_date AS create_date_10, t0.update_date AS update_date_11, t0.login_date AS login_date_12, t0.work_id AS work_id_13, t0.authority_id AS authority_id_14, t0.creator_id AS creator_id_15, t0.store_id AS store_id_16, t0.discriminator_type FROM dtb_member t0 WHERE t0.login_id = 'mitoadmin' AND t0.work_id = 1 AND t0.discriminator_type IN ('member') LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.deny_url AS deny_url_2,
  t0.create_date AS create_date_3,
  t0.update_date AS update_date_4,
  t0.authority_id AS authority_id_5,
  t0.creator_id AS creator_id_6,
  t0.discriminator_type
FROM
  dtb_authority_role t0
WHERE
  t0.authority_id = ?
  AND t0.discriminator_type IN ('authorityrole')

SELECT t0.id AS id_1, t0.deny_url AS deny_url_2, t0.create_date AS create_date_3, t0.update_date AS update_date_4, t0.authority_id AS authority_id_5, t0.creator_id AS creator_id_6, t0.discriminator_type FROM dtb_authority_role t0 WHERE t0.authority_id = 4 AND t0.discriminator_type IN ('authorityrole');

SELECT
  t0.id AS id_1,
  t0.company_name AS company_name_2,
  t0.company_kana AS company_kana_3,
  t0.postal_code AS postal_code_4,
  t0.addr01 AS addr01_5,
  t0.addr02 AS addr02_6,
  t0.phone_number AS phone_number_7,
  t0.business_hour AS business_hour_8,
  t0.email01 AS email01_9,
  t0.email02 AS email02_10,
  t0.email03 AS email03_11,
  t0.email04 AS email04_12,
  t0.shop_name AS shop_name_13,
  t0.shop_kana AS shop_kana_14,
  t0.shop_name_eng AS shop_name_eng_15,
  t0.update_date AS update_date_16,
  t0.good_traded AS good_traded_17,
  t0.message AS message_18,
  t0.delivery_free_amount AS delivery_free_amount_19,
  t0.delivery_free_quantity AS delivery_free_quantity_20,
  t0.option_mypage_order_status_display AS option_mypage_order_status_display_21,
  t0.option_nostock_hidden AS option_nostock_hidden_22,
  t0.option_favorite_product AS option_favorite_product_23,
  t0.option_product_delivery_fee AS option_product_delivery_fee_24,
  t0.invoice_registration_number AS invoice_registration_number_25,
  t0.option_product_tax_rule AS option_product_tax_rule_26,
  t0.option_customer_activate AS option_customer_activate_27,
  t0.option_remember_me AS option_remember_me_28,
  t0.option_mail_notifier AS option_mail_notifier_29,
  t0.authentication_key AS authentication_key_30,
  t0.php_path AS php_path_31,
  t0.option_point AS option_point_32,
  t0.basic_point_rate AS basic_point_rate_33,
  t0.point_conversion_rate AS point_conversion_rate_34,
  t0.contact_school_visible_type AS contact_school_visible_type_35,
  t0.country_id AS country_id_36,
  t0.pref_id AS pref_id_37,
  t0.discriminator_type
FROM
  dtb_base_info t0
WHERE
  t0.id = ?
  AND t0.discriminator_type IN ('baseinfo')

SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.company_kana AS company_kana_3, t0.postal_code AS postal_code_4, t0.addr01 AS addr01_5, t0.addr02 AS addr02_6, t0.phone_number AS phone_number_7, t0.business_hour AS business_hour_8, t0.email01 AS email01_9, t0.email02 AS email02_10, t0.email03 AS email03_11, t0.email04 AS email04_12, t0.shop_name AS shop_name_13, t0.shop_kana AS shop_kana_14, t0.shop_name_eng AS shop_name_eng_15, t0.update_date AS update_date_16, t0.good_traded AS good_traded_17, t0.message AS message_18, t0.delivery_free_amount AS delivery_free_amount_19, t0.delivery_free_quantity AS delivery_free_quantity_20, t0.option_mypage_order_status_display AS option_mypage_order_status_display_21, t0.option_nostock_hidden AS option_nostock_hidden_22, t0.option_favorite_product AS option_favorite_product_23, t0.option_product_delivery_fee AS option_product_delivery_fee_24, t0.invoice_registration_number AS invoice_registration_number_25, t0.option_product_tax_rule AS option_product_tax_rule_26, t0.option_customer_activate AS option_customer_activate_27, t0.option_remember_me AS option_remember_me_28, t0.option_mail_notifier AS option_mail_notifier_29, t0.authentication_key AS authentication_key_30, t0.php_path AS php_path_31, t0.option_point AS option_point_32, t0.basic_point_rate AS basic_point_rate_33, t0.point_conversion_rate AS point_conversion_rate_34, t0.contact_school_visible_type AS contact_school_visible_type_35, t0.country_id AS country_id_36, t0.pref_id AS pref_id_37, t0.discriminator_type FROM dtb_base_info t0 WHERE t0.id = 1 AND t0.discriminator_type IN ('baseinfo');

SELECT
  t0.id AS id_1,
  t0.deny_url AS deny_url_2,
  t0.create_date AS create_date_3,
  t0.update_date AS update_date_4,
  t0.authority_id AS authority_id_5,
  t0.creator_id AS creator_id_6,
  t0.discriminator_type
FROM
  dtb_authority_role t0
WHERE
  t0.authority_id = ?
  AND t0.discriminator_type IN ('authorityrole')

SELECT t0.id AS id_1, t0.deny_url AS deny_url_2, t0.create_date AS create_date_3, t0.update_date AS update_date_4, t0.authority_id AS authority_id_5, t0.creator_id AS creator_id_6, t0.discriminator_type FROM dtb_authority_role t0 WHERE t0.authority_id = 4 AND t0.discriminator_type IN ('authorityrole');

SET
  SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED

SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;

"START TRANSACTION"

"START TRANSACTION";

SELECT
  t0.id AS id_1,
  t0.pre_order_id AS pre_order_id_2,
  t0.order_no AS order_no_3,
  t0.message AS message_4,
  t0.name01 AS name01_5,
  t0.name02 AS name02_6,
  t0.kana01 AS kana01_7,
  t0.kana02 AS kana02_8,
  t0.company_name AS company_name_9,
  t0.email AS email_10,
  t0.phone_number AS phone_number_11,
  t0.postal_code AS postal_code_12,
  t0.addr01 AS addr01_13,
  t0.addr02 AS addr02_14,
  t0.birth AS birth_15,
  t0.subtotal AS subtotal_16,
  t0.discount AS discount_17,
  t0.delivery_fee_total AS delivery_fee_total_18,
  t0.charge AS charge_19,
  t0.tax AS tax_20,
  t0.total AS total_21,
  t0.payment_total AS payment_total_22,
  t0.payment_method AS payment_method_23,
  t0.note AS note_24,
  t0.create_date AS create_date_25,
  t0.update_date AS update_date_26,
  t0.order_date AS order_date_27,
  t0.payment_date AS payment_date_28,
  t0.currency_code AS currency_code_29,
  t0.complete_message AS complete_message_30,
  t0.complete_mail_message AS complete_mail_message_31,
  t0.phone_number2 AS phone_number2_32,
  t0.fax01 AS fax01_33,
  t0.fax02 AS fax02_34,
  t0.fax03 AS fax03_35,
  t0.zip01 AS zip01_36,
  t0.zip02 AS zip02_37,
  t0.temporary_order_date AS temporary_order_date_38,
  t0.formal_order_date AS formal_order_date_39,
  t0.commit_date AS commit_date_40,
  t0.delivery_date AS delivery_date_41,
  t0.prev_school AS prev_school_42,
  t0.school_year AS school_year_43,
  t0.school_class AS school_class_44,
  t0.prev_school_year AS prev_school_year_45,
  t0.prev_school_class AS prev_school_class_46,
  t0.student_number AS student_number_47,
  t0.free1 AS free1_48,
  t0.free2 AS free2_49,
  t0.admission_year AS admission_year_50,
  t0.stocking_date AS stocking_date_51,
  t0.order_school_year AS order_school_year_52,
  t0.order_school_class AS order_school_class_53,
  t0.gmo_payment_gateway_payment_status AS gmo_payment_gateway_payment_status_54,
  t0.add_point AS add_point_55,
  t0.use_point AS use_point_56,
  t0.customer_id AS customer_id_57,
  t0.country_id AS country_id_58,
  t0.pref_id AS pref_id_59,
  t0.sex_id AS sex_id_60,
  t0.job_id AS job_id_61,
  t0.payment_id AS payment_id_62,
  t0.device_type_id AS device_type_id_63,
  t0.order_status_id AS order_status_id_64,
  t0.order_status_id AS order_status_id_65,
  t0.order_status_id AS order_status_id_66,
  t0.school_id AS school_id_67,
  t0.discriminator_type
FROM
  dtb_order t0
WHERE
  t0.id = ?
  AND t0.discriminator_type IN ('order')

SELECT t0.id AS id_1, t0.pre_order_id AS pre_order_id_2, t0.order_no AS order_no_3, t0.message AS message_4, t0.name01 AS name01_5, t0.name02 AS name02_6, t0.kana01 AS kana01_7, t0.kana02 AS kana02_8, t0.company_name AS company_name_9, t0.email AS email_10, t0.phone_number AS phone_number_11, t0.postal_code AS postal_code_12, t0.addr01 AS addr01_13, t0.addr02 AS addr02_14, t0.birth AS birth_15, t0.subtotal AS subtotal_16, t0.discount AS discount_17, t0.delivery_fee_total AS delivery_fee_total_18, t0.charge AS charge_19, t0.tax AS tax_20, t0.total AS total_21, t0.payment_total AS payment_total_22, t0.payment_method AS payment_method_23, t0.note AS note_24, t0.create_date AS create_date_25, t0.update_date AS update_date_26, t0.order_date AS order_date_27, t0.payment_date AS payment_date_28, t0.currency_code AS currency_code_29, t0.complete_message AS complete_message_30, t0.complete_mail_message AS complete_mail_message_31, t0.phone_number2 AS phone_number2_32, t0.fax01 AS fax01_33, t0.fax02 AS fax02_34, t0.fax03 AS fax03_35, t0.zip01 AS zip01_36, t0.zip02 AS zip02_37, t0.temporary_order_date AS temporary_order_date_38, t0.formal_order_date AS formal_order_date_39, t0.commit_date AS commit_date_40, t0.delivery_date AS delivery_date_41, t0.prev_school AS prev_school_42, t0.school_year AS school_year_43, t0.school_class AS school_class_44, t0.prev_school_year AS prev_school_year_45, t0.prev_school_class AS prev_school_class_46, t0.student_number AS student_number_47, t0.free1 AS free1_48, t0.free2 AS free2_49, t0.admission_year AS admission_year_50, t0.stocking_date AS stocking_date_51, t0.order_school_year AS order_school_year_52, t0.order_school_class AS order_school_class_53, t0.gmo_payment_gateway_payment_status AS gmo_payment_gateway_payment_status_54, t0.add_point AS add_point_55, t0.use_point AS use_point_56, t0.customer_id AS customer_id_57, t0.country_id AS country_id_58, t0.pref_id AS pref_id_59, t0.sex_id AS sex_id_60, t0.job_id AS job_id_61, t0.payment_id AS payment_id_62, t0.device_type_id AS device_type_id_63, t0.order_status_id AS order_status_id_64, t0.order_status_id AS order_status_id_65, t0.order_status_id AS order_status_id_66, t0.school_id AS school_id_67, t0.discriminator_type FROM dtb_order t0 WHERE t0.id = '22' AND t0.discriminator_type IN ('order');

SELECT
  t0.id AS id_1,
  t0.product_name AS product_name_2,
  t0.product_code AS product_code_3,
  t0.class_name1 AS class_name1_4,
  t0.class_name2 AS class_name2_5,
  t0.class_category_name1 AS class_category_name1_6,
  t0.class_category_name2 AS class_category_name2_7,
  t0.price AS price_8,
  t0.quantity AS quantity_9,
  t0.tax AS tax_10,
  t0.tax_rate AS tax_rate_11,
  t0.tax_adjust AS tax_adjust_12,
  t0.tax_rule_id AS tax_rule_id_13,
  t0.currency_code AS currency_code_14,
  t0.processor_name AS processor_name_15,
  t0.point_rate AS point_rate_16,
  t0.set_product_class AS set_product_class_17,
  t0.set_product_price AS set_product_price_18,
  t0.remarks AS remarks_19,
  t0.order_id AS order_id_20,
  t0.product_id AS product_id_21,
  t0.product_class_id AS product_class_id_22,
  t0.shipping_id AS shipping_id_23,
  t0.rounding_type_id AS rounding_type_id_24,
  t0.tax_type_id AS tax_type_id_25,
  t0.tax_display_type_id AS tax_display_type_id_26,
  t0.order_item_type_id AS order_item_type_id_27,
  t0.delivery_period_id AS delivery_period_id_28,
  t0.brother_id AS brother_id_29,
  t0.discriminator_type
FROM
  dtb_order_item t0
WHERE
  t0.order_id = ?
  AND t0.discriminator_type IN ('orderitem')

SELECT t0.id AS id_1, t0.product_name AS product_name_2, t0.product_code AS product_code_3, t0.class_name1 AS class_name1_4, t0.class_name2 AS class_name2_5, t0.class_category_name1 AS class_category_name1_6, t0.class_category_name2 AS class_category_name2_7, t0.price AS price_8, t0.quantity AS quantity_9, t0.tax AS tax_10, t0.tax_rate AS tax_rate_11, t0.tax_adjust AS tax_adjust_12, t0.tax_rule_id AS tax_rule_id_13, t0.currency_code AS currency_code_14, t0.processor_name AS processor_name_15, t0.point_rate AS point_rate_16, t0.set_product_class AS set_product_class_17, t0.set_product_price AS set_product_price_18, t0.remarks AS remarks_19, t0.order_id AS order_id_20, t0.product_id AS product_id_21, t0.product_class_id AS product_class_id_22, t0.shipping_id AS shipping_id_23, t0.rounding_type_id AS rounding_type_id_24, t0.tax_type_id AS tax_type_id_25, t0.tax_display_type_id AS tax_display_type_id_26, t0.order_item_type_id AS order_item_type_id_27, t0.delivery_period_id AS delivery_period_id_28, t0.brother_id AS brother_id_29, t0.discriminator_type FROM dtb_order_item t0 WHERE t0.order_id = 22 AND t0.discriminator_type IN ('orderitem');

SELECT
  t0.id AS id_1,
  t0.connect_server_type AS connect_server_type_2,
  t0.server_url AS server_url_3,
  t0.kanri_server_url AS kanri_server_url_4,
  t0.site_id AS site_id_5,
  t0.site_pass AS site_pass_6,
  t0.shop_id AS shop_id_7,
  t0.shop_pass AS shop_pass_8,
  t0.card_regist_flg AS card_regist_flg_9
FROM
  plg_gmo_payment_gateway_config t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.connect_server_type AS connect_server_type_2, t0.server_url AS server_url_3, t0.kanri_server_url AS kanri_server_url_4, t0.site_id AS site_id_5, t0.site_pass AS site_pass_6, t0.shop_id AS shop_id_7, t0.shop_pass AS shop_pass_8, t0.card_regist_flg AS card_regist_flg_9 FROM plg_gmo_payment_gateway_config t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.payment_id AS payment_id_2,
  t0.payment_method AS payment_method_3,
  t0.create_date AS create_date_4,
  t0.update_date AS update_date_5,
  t0.memo01 AS memo01_6,
  t0.memo02 AS memo02_7,
  t0.memo03 AS memo03_8,
  t0.memo04 AS memo04_9,
  t0.memo05 AS memo05_10,
  t0.memo06 AS memo06_11,
  t0.memo07 AS memo07_12,
  t0.memo08 AS memo08_13,
  t0.memo09 AS memo09_14,
  t0.memo10 AS memo10_15,
  t0.plugin_code AS plugin_code_16
FROM
  plg_gmo_payment_gateway_payment_method t0
WHERE
  t0.memo03 = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.payment_id AS payment_id_2, t0.payment_method AS payment_method_3, t0.create_date AS create_date_4, t0.update_date AS update_date_5, t0.memo01 AS memo01_6, t0.memo02 AS memo02_7, t0.memo03 AS memo03_8, t0.memo04 AS memo04_9, t0.memo05 AS memo05_10, t0.memo06 AS memo06_11, t0.memo07 AS memo07_12, t0.memo08 AS memo08_13, t0.memo09 AS memo09_14, t0.memo10 AS memo10_15, t0.plugin_code AS plugin_code_16 FROM plg_gmo_payment_gateway_payment_method t0 WHERE t0.memo03 = 'Plugin\\GmoPaymentGateway42\\Service\\Method\\Cvs' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.deny_url AS deny_url_2,
  t0.create_date AS create_date_3,
  t0.update_date AS update_date_4,
  t0.authority_id AS authority_id_5,
  t0.creator_id AS creator_id_6,
  t0.discriminator_type
FROM
  dtb_authority_role t0
WHERE
  t0.authority_id = ?
  AND t0.discriminator_type IN ('authorityrole')

SELECT t0.id AS id_1, t0.deny_url AS deny_url_2, t0.create_date AS create_date_3, t0.update_date AS update_date_4, t0.authority_id AS authority_id_5, t0.creator_id AS creator_id_6, t0.discriminator_type FROM dtb_authority_role t0 WHERE t0.authority_id = 4 AND t0.discriminator_type IN ('authorityrole');

SELECT
  t0.id AS id_1,
  t0.merchant_id AS merchant_id_2,
  t0.transaction_id AS transaction_id_3,
  t0.operate_id AS operate_id_4,
  t0.process_id AS process_id_5,
  t0.response_cd AS response_cd_6,
  t0.send_flg AS send_flg_7,
  t0.request_flg AS request_flg_8,
  t0.body AS body_9,
  t0.order_id AS order_id_10,
  t0.create_date AS create_date_11,
  t0.update_date AS update_date_12
FROM
  plg_sln_order_payment_history t0
WHERE
  t0.order_id = ?
  AND t0.operate_id IN (?, ?, ?, ?)
  AND t0.send_flg = ?
  AND t0.request_flg = ?
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.merchant_id AS merchant_id_2, t0.transaction_id AS transaction_id_3, t0.operate_id AS operate_id_4, t0.process_id AS process_id_5, t0.response_cd AS response_cd_6, t0.send_flg AS send_flg_7, t0.request_flg AS request_flg_8, t0.body AS body_9, t0.order_id AS order_id_10, t0.create_date AS create_date_11, t0.update_date AS update_date_12 FROM plg_sln_order_payment_history t0 WHERE t0.order_id = 22 AND t0.operate_id IN ('2Add', '1Auth', '1Gathering', '1ReAuth') AND t0.send_flg = 1 AND t0.request_flg = 0 ORDER BY t0.id DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sort_no AS sort_no_3,
  t0.discriminator_type
FROM
  mtb_pref t0
WHERE
  t0.id = ?
  AND t0.discriminator_type IN ('pref')

SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.discriminator_type FROM mtb_pref t0 WHERE t0.id = 27 AND t0.discriminator_type IN ('pref');

SELECT
  t0.id AS id_1,
  t0.payment_method AS payment_method_2,
  t0.charge AS charge_3,
  t0.rule_max AS rule_max_4,
  t0.sort_no AS sort_no_5,
  t0.fixed AS fixed_6,
  t0.payment_image AS payment_image_7,
  t0.rule_min AS rule_min_8,
  t0.method_class AS method_class_9,
  t0.visible AS visible_10,
  t0.create_date AS create_date_11,
  t0.update_date AS update_date_12,
  t0.creator_id AS creator_id_13,
  t0.discriminator_type
FROM
  dtb_payment t0
WHERE
  t0.id = ?
  AND t0.discriminator_type IN ('payment')

SELECT t0.id AS id_1, t0.payment_method AS payment_method_2, t0.charge AS charge_3, t0.rule_max AS rule_max_4, t0.sort_no AS sort_no_5, t0.fixed AS fixed_6, t0.payment_image AS payment_image_7, t0.rule_min AS rule_min_8, t0.method_class AS method_class_9, t0.visible AS visible_10, t0.create_date AS create_date_11, t0.update_date AS update_date_12, t0.creator_id AS creator_id_13, t0.discriminator_type FROM dtb_payment t0 WHERE t0.id = 53 AND t0.discriminator_type IN ('payment');

SELECT
  t0.id AS id_1,
  t0.instant_flg AS instant_flg_2,
  t0.payment_id AS payment_id_3,
  t0.instant_order_status_id AS instant_order_status_id_4,
  t0.discriminator_type
FROM
  dtb_payment_instant t0
WHERE
  t0.payment_id = ?
  AND t0.discriminator_type IN ('paymentinstant')

SELECT t0.id AS id_1, t0.instant_flg AS instant_flg_2, t0.payment_id AS payment_id_3, t0.instant_order_status_id AS instant_order_status_id_4, t0.discriminator_type FROM dtb_payment_instant t0 WHERE t0.payment_id = 53 AND t0.discriminator_type IN ('paymentinstant');

SELECT
  t0.delivery_period_id AS delivery_period_id_1,
  t0.delivery_period_name AS delivery_period_name_2,
  t0.product_label_name AS product_label_name_3,
  t0.delivery_label_name AS delivery_label_name_4,
  t0.sum_label_name AS sum_label_name_5,
  t0.delivery_free_amount AS delivery_free_amount_6,
  t0.delivery_free_quantity AS delivery_free_quantity_7,
  t0.sort_no AS sort_no_8,
  t0.visible AS visible_9,
  t0.create_date AS create_date_10,
  t0.update_date AS update_date_11,
  t0.school_id AS school_id_12,
  t0.sale_type_id AS sale_type_id_13,
  t0.discriminator_type
FROM
  dtb_delivery_period t0
WHERE
  t0.delivery_period_id = ?
  AND t0.discriminator_type IN ('deliveryperiod')

SELECT t0.delivery_period_id AS delivery_period_id_1, t0.delivery_period_name AS delivery_period_name_2, t0.product_label_name AS product_label_name_3, t0.delivery_label_name AS delivery_label_name_4, t0.sum_label_name AS sum_label_name_5, t0.delivery_free_amount AS delivery_free_amount_6, t0.delivery_free_quantity AS delivery_free_quantity_7, t0.sort_no AS sort_no_8, t0.visible AS visible_9, t0.create_date AS create_date_10, t0.update_date AS update_date_11, t0.school_id AS school_id_12, t0.sale_type_id AS sale_type_id_13, t0.discriminator_type FROM dtb_delivery_period t0 WHERE t0.delivery_period_id = 1 AND t0.discriminator_type IN ('deliveryperiod');

SELECT
  t0.school_id AS school_id_1,
  t0.school_name AS school_name_2,
  t0.school_kana AS school_kana_3,
  t0.school_order AS school_order_4,
  t0.customer_selfdel_flg AS customer_selfdel_flg_5,
  t0.school_email AS school_email_6,
  t0.target_student AS target_student_7,
  t0.online_flag AS online_flag_8,
  t0.school_measuring_flag AS school_measuring_flag_9,
  t0.store_measuring_flag AS store_measuring_flag_10,
  t0.online_order_deadline AS online_order_deadline_11,
  t0.school_measuring_date AS school_measuring_date_12,
  t0.store_measuring_deadline AS store_measuring_deadline_13,
  t0.purchase_flag AS purchase_flag_14,
  t0.online_order_start_date AS online_order_start_date_15,
  t0.online_order_end_date AS online_order_end_date_16,
  t0.members_registration_type AS members_registration_type_17,
  t0.school_key AS school_key_18,
  t0.visible_school_key AS visible_school_key_19,
  t0.create_date AS create_date_20,
  t0.update_date AS update_date_21,
  t0.school_code AS school_code_22,
  t0.entry_url AS entry_url_23,
  t0.delivery_free_type AS delivery_free_type_24,
  t0.delivery_free_amount AS delivery_free_amount_25,
  t0.delivery_free_quantity AS delivery_free_quantity_26,
  t0.measure_plugin_type AS measure_plugin_type_27,
  t0.default_sex_products_filtering_flag AS default_sex_products_filtering_flag_28,
  t0.measuring_registration_required_flag AS measuring_registration_required_flag_29,
  t0.top_page_popup_flag AS top_page_popup_flag_30,
  t0.reg_data_popup_flag AS reg_data_popup_flag_31,
  t0.chat_bot_flag AS chat_bot_flag_32,
  t0.measuring_data_confirmation_flag AS measuring_data_confirmation_flag_33,
  t0.size_recommend_flag AS size_recommend_flag_34,
  t0.item_visible_type AS item_visible_type_35,
  t0.sale_start_date AS sale_start_date_36,
  t0.sale_end_date AS sale_end_date_37,
  t0.reservation_site_url AS reservation_site_url_38,
  t0.name_notation AS name_notation_39,
  t0.name01_entry_sample AS name01_entry_sample_40,
  t0.name02_entry_sample AS name02_entry_sample_41,
  t0.kana_notation AS kana_notation_42,
  t0.kana01_entry_sample AS kana01_entry_sample_43,
  t0.kana02_entry_sample AS kana02_entry_sample_44,
  t0.name_visible_type AS name_visible_type_45,
  t0.addr_notation AS addr_notation_46,
  t0.zip01_entry_sample AS zip01_entry_sample_47,
  t0.zip02_entry_sample AS zip02_entry_sample_48,
  t0.addr01_entry_sample AS addr01_entry_sample_49,
  t0.addr02_entry_sample AS addr02_entry_sample_50,
  t0.addr_visible_type AS addr_visible_type_51,
  t0.addr_visible_all AS addr_visible_all_52,
  t0.tel_notation AS tel_notation_53,
  t0.tel1_01_entry_sample AS tel1_01_entry_sample_54,
  t0.tel1_02_entry_sample AS tel1_02_entry_sample_55,
  t0.tel1_03_entry_sample AS tel1_03_entry_sample_56,
  t0.tel01_visible_type AS tel01_visible_type_57,
  t0.tel02_visible_type AS tel02_visible_type_58,
  t0.tel2_notation AS tel2_notation_59,
  t0.tel2_01_entry_sample AS tel2_01_entry_sample_60,
  t0.tel2_02_entry_sample AS tel2_02_entry_sample_61,
  t0.tel2_03_entry_sample AS tel2_03_entry_sample_62,
  t0.email_notation AS email_notation_63,
  t0.email_entry_sample AS email_entry_sample_64,
  t0.email_visible_type AS email_visible_type_65,
  t0.password_notation AS password_notation_66,
  t0.password_entry_sample AS password_entry_sample_67,
  t0.password_visible_type AS password_visible_type_68,
  t0.adyear_visible_type AS adyear_visible_type_69,
  t0.adyear_notation AS adyear_notation_70,
  t0.adyear_entry_sample AS adyear_entry_sample_71,
  t0.exam_number_visible_type AS exam_number_visible_type_72,
  t0.exam_number_notation AS exam_number_notation_73,
  t0.exam_number_entry_sample AS exam_number_entry_sample_74,
  t0.prev_school_visible_type AS prev_school_visible_type_75,
  t0.prev_school_notation AS prev_school_notation_76,
  t0.prev_school_entry_sample AS prev_school_entry_sample_77,
  t0.prev_year_class_visible_type AS prev_year_class_visible_type_78,
  t0.prev_year_class_notation AS prev_year_class_notation_79,
  t0.prev_year_entry_sample AS prev_year_entry_sample_80,
  t0.prev_class_entry_sample AS prev_class_entry_sample_81,
  t0.birth_visible_type AS birth_visible_type_82,
  t0.birth_notation AS birth_notation_83,
  t0.birth_entry_sample AS birth_entry_sample_84,
  t0.parents_name_visible_type AS parents_name_visible_type_85,
  t0.parents_name_notation AS parents_name_notation_86,
  t0.parents_name01_entry_sample AS parents_name01_entry_sample_87,
  t0.parents_name02_entry_sample AS parents_name02_entry_sample_88,
  t0.parents_birth_visible_type AS parents_birth_visible_type_89,
  t0.parents_birth_notation AS parents_birth_notation_90,
  t0.parents_birth_entry_sample AS parents_birth_entry_sample_91,
  t0.current_year_visible_type AS current_year_visible_type_92,
  t0.current_year_class_notation AS current_year_class_notation_93,
  t0.current_year_entry_sample AS current_year_entry_sample_94,
  t0.current_class_notation AS current_class_notation_95,
  t0.student_number_visible_type AS student_number_visible_type_96,
  t0.student_number_notation AS student_number_notation_97,
  t0.student_number_entry_sample AS student_number_entry_sample_98,
  t0.freeitem1_visible_type AS freeitem1_visible_type_99,
  t0.freeitem1_name AS freeitem1_name_100,
  t0.freeitem1_notation AS freeitem1_notation_101,
  t0.freeitem1_entry_sample AS freeitem1_entry_sample_102,
  t0.freeitem2_visible_type AS freeitem2_visible_type_103,
  t0.freeitem2_name AS freeitem2_name_104,
  t0.freeitem2_notation AS freeitem2_notation_105,
  t0.freeitem2_entry_sample AS freeitem2_entry_sample_106,
  t0.sex_visible_type AS sex_visible_type_107,
  t0.fax_visible_type AS fax_visible_type_108,
  t0.measure_height_visible_type AS measure_height_visible_type_109,
  t0.measure_weight_visible_type AS measure_weight_visible_type_110,
  t0.measure_shoulder_visible_type AS measure_shoulder_visible_type_111,
  t0.measure_sleeve1_visible_type AS measure_sleeve1_visible_type_112,
  t0.measure_sleeve2_visible_type AS measure_sleeve2_visible_type_113,
  t0.measure_total_visible_type AS measure_total_visible_type_114,
  t0.measure_neck_visible_type AS measure_neck_visible_type_115,
  t0.measure_bust_visible_type AS measure_bust_visible_type_116,
  t0.measure_waist_visible_type AS measure_waist_visible_type_117,
  t0.measure_hips_visible_type AS measure_hips_visible_type_118,
  t0.measure_inseam_visible_type AS measure_inseam_visible_type_119,
  t0.measure_skirt_visible_type AS measure_skirt_visible_type_120,
  t0.measure_slacks_visible_type AS measure_slacks_visible_type_121,
  t0.enter_year_class AS enter_year_class_122,
  t0.visible_commodity_alert AS visible_commodity_alert_123,
  t0.visible_flg AS visible_flg_124,
  t0.brother_flg AS brother_flg_125,
  t0.require_school_key AS require_school_key_126,
  t0.require_brothers AS require_brothers_127,
  t0.product_sexvisible_type AS product_sexvisible_type_128,
  t0.report_measure_flag AS report_measure_flag_129,
  t0.report_grade_flag AS report_grade_flag_130,
  t0.report_class_flag AS report_class_flag_131,
  t0.report_storemail_flag AS report_storemail_flag_132,
  t0.report_tax_flag AS report_tax_flag_133,
  t0.order_delivery_notation AS order_delivery_notation_134,
  t0.order_payment_notation AS order_payment_notation_135,
  t0.addr01_max_length AS addr01_max_length_136,
  t0.addr02_max_length AS addr02_max_length_137,
  t0.recommend_id AS recommend_id_138,
  t0.discriminator_type
FROM
  dtb_school t0
WHERE
  t0.school_id = ?
  AND t0.discriminator_type IN ('school')

SELECT t0.school_id AS school_id_1, t0.school_name AS school_name_2, t0.school_kana AS school_kana_3, t0.school_order AS school_order_4, t0.customer_selfdel_flg AS customer_selfdel_flg_5, t0.school_email AS school_email_6, t0.target_student AS target_student_7, t0.online_flag AS online_flag_8, t0.school_measuring_flag AS school_measuring_flag_9, t0.store_measuring_flag AS store_measuring_flag_10, t0.online_order_deadline AS online_order_deadline_11, t0.school_measuring_date AS school_measuring_date_12, t0.store_measuring_deadline AS store_measuring_deadline_13, t0.purchase_flag AS purchase_flag_14, t0.online_order_start_date AS online_order_start_date_15, t0.online_order_end_date AS online_order_end_date_16, t0.members_registration_type AS members_registration_type_17, t0.school_key AS school_key_18, t0.visible_school_key AS visible_school_key_19, t0.create_date AS create_date_20, t0.update_date AS update_date_21, t0.school_code AS school_code_22, t0.entry_url AS entry_url_23, t0.delivery_free_type AS delivery_free_type_24, t0.delivery_free_amount AS delivery_free_amount_25, t0.delivery_free_quantity AS delivery_free_quantity_26, t0.measure_plugin_type AS measure_plugin_type_27, t0.default_sex_products_filtering_flag AS default_sex_products_filtering_flag_28, t0.measuring_registration_required_flag AS measuring_registration_required_flag_29, t0.top_page_popup_flag AS top_page_popup_flag_30, t0.reg_data_popup_flag AS reg_data_popup_flag_31, t0.chat_bot_flag AS chat_bot_flag_32, t0.measuring_data_confirmation_flag AS measuring_data_confirmation_flag_33, t0.size_recommend_flag AS size_recommend_flag_34, t0.item_visible_type AS item_visible_type_35, t0.sale_start_date AS sale_start_date_36, t0.sale_end_date AS sale_end_date_37, t0.reservation_site_url AS reservation_site_url_38, t0.name_notation AS name_notation_39, t0.name01_entry_sample AS name01_entry_sample_40, t0.name02_entry_sample AS name02_entry_sample_41, t0.kana_notation AS kana_notation_42, t0.kana01_entry_sample AS kana01_entry_sample_43, t0.kana02_entry_sample AS kana02_entry_sample_44, t0.name_visible_type AS name_visible_type_45, t0.addr_notation AS addr_notation_46, t0.zip01_entry_sample AS zip01_entry_sample_47, t0.zip02_entry_sample AS zip02_entry_sample_48, t0.addr01_entry_sample AS addr01_entry_sample_49, t0.addr02_entry_sample AS addr02_entry_sample_50, t0.addr_visible_type AS addr_visible_type_51, t0.addr_visible_all AS addr_visible_all_52, t0.tel_notation AS tel_notation_53, t0.tel1_01_entry_sample AS tel1_01_entry_sample_54, t0.tel1_02_entry_sample AS tel1_02_entry_sample_55, t0.tel1_03_entry_sample AS tel1_03_entry_sample_56, t0.tel01_visible_type AS tel01_visible_type_57, t0.tel02_visible_type AS tel02_visible_type_58, t0.tel2_notation AS tel2_notation_59, t0.tel2_01_entry_sample AS tel2_01_entry_sample_60, t0.tel2_02_entry_sample AS tel2_02_entry_sample_61, t0.tel2_03_entry_sample AS tel2_03_entry_sample_62, t0.email_notation AS email_notation_63, t0.email_entry_sample AS email_entry_sample_64, t0.email_visible_type AS email_visible_type_65, t0.password_notation AS password_notation_66, t0.password_entry_sample AS password_entry_sample_67, t0.password_visible_type AS password_visible_type_68, t0.adyear_visible_type AS adyear_visible_type_69, t0.adyear_notation AS adyear_notation_70, t0.adyear_entry_sample AS adyear_entry_sample_71, t0.exam_number_visible_type AS exam_number_visible_type_72, t0.exam_number_notation AS exam_number_notation_73, t0.exam_number_entry_sample AS exam_number_entry_sample_74, t0.prev_school_visible_type AS prev_school_visible_type_75, t0.prev_school_notation AS prev_school_notation_76, t0.prev_school_entry_sample AS prev_school_entry_sample_77, t0.prev_year_class_visible_type AS prev_year_class_visible_type_78, t0.prev_year_class_notation AS prev_year_class_notation_79, t0.prev_year_entry_sample AS prev_year_entry_sample_80, t0.prev_class_entry_sample AS prev_class_entry_sample_81, t0.birth_visible_type AS birth_visible_type_82, t0.birth_notation AS birth_notation_83, t0.birth_entry_sample AS birth_entry_sample_84, t0.parents_name_visible_type AS parents_name_visible_type_85, t0.parents_name_notation AS parents_name_notation_86, t0.parents_name01_entry_sample AS parents_name01_entry_sample_87, t0.parents_name02_entry_sample AS parents_name02_entry_sample_88, t0.parents_birth_visible_type AS parents_birth_visible_type_89, t0.parents_birth_notation AS parents_birth_notation_90, t0.parents_birth_entry_sample AS parents_birth_entry_sample_91, t0.current_year_visible_type AS current_year_visible_type_92, t0.current_year_class_notation AS current_year_class_notation_93, t0.current_year_entry_sample AS current_year_entry_sample_94, t0.current_class_notation AS current_class_notation_95, t0.student_number_visible_type AS student_number_visible_type_96, t0.student_number_notation AS student_number_notation_97, t0.student_number_entry_sample AS student_number_entry_sample_98, t0.freeitem1_visible_type AS freeitem1_visible_type_99, t0.freeitem1_name AS freeitem1_name_100, t0.freeitem1_notation AS freeitem1_notation_101, t0.freeitem1_entry_sample AS freeitem1_entry_sample_102, t0.freeitem2_visible_type AS freeitem2_visible_type_103, t0.freeitem2_name AS freeitem2_name_104, t0.freeitem2_notation AS freeitem2_notation_105, t0.freeitem2_entry_sample AS freeitem2_entry_sample_106, t0.sex_visible_type AS sex_visible_type_107, t0.fax_visible_type AS fax_visible_type_108, t0.measure_height_visible_type AS measure_height_visible_type_109, t0.measure_weight_visible_type AS measure_weight_visible_type_110, t0.measure_shoulder_visible_type AS measure_shoulder_visible_type_111, t0.measure_sleeve1_visible_type AS measure_sleeve1_visible_type_112, t0.measure_sleeve2_visible_type AS measure_sleeve2_visible_type_113, t0.measure_total_visible_type AS measure_total_visible_type_114, t0.measure_neck_visible_type AS measure_neck_visible_type_115, t0.measure_bust_visible_type AS measure_bust_visible_type_116, t0.measure_waist_visible_type AS measure_waist_visible_type_117, t0.measure_hips_visible_type AS measure_hips_visible_type_118, t0.measure_inseam_visible_type AS measure_inseam_visible_type_119, t0.measure_skirt_visible_type AS measure_skirt_visible_type_120, t0.measure_slacks_visible_type AS measure_slacks_visible_type_121, t0.enter_year_class AS enter_year_class_122, t0.visible_commodity_alert AS visible_commodity_alert_123, t0.visible_flg AS visible_flg_124, t0.brother_flg AS brother_flg_125, t0.require_school_key AS require_school_key_126, t0.require_brothers AS require_brothers_127, t0.product_sexvisible_type AS product_sexvisible_type_128, t0.report_measure_flag AS report_measure_flag_129, t0.report_grade_flag AS report_grade_flag_130, t0.report_class_flag AS report_class_flag_131, t0.report_storemail_flag AS report_storemail_flag_132, t0.report_tax_flag AS report_tax_flag_133, t0.order_delivery_notation AS order_delivery_notation_134, t0.order_payment_notation AS order_payment_notation_135, t0.addr01_max_length AS addr01_max_length_136, t0.addr02_max_length AS addr02_max_length_137, t0.recommend_id AS recommend_id_138, t0.discriminator_type FROM dtb_school t0 WHERE t0.school_id = 1 AND t0.discriminator_type IN ('school');