https://toraya-seifuku.com/products/detail/118

302 Redirect from
@product_detail (ea4376)
Method
GET
HTTP Status
302
IP
216.73.216.230
Profiled on
Token
c9c51c

Query Metrics

22 Database Queries
15 Different statements
4.14 ms Query time
4 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.15 ms 
SET SESSION time_zone = '+00:00'
Parameters: 
[]
View formatted query    View runnable query    Explain query
2 0.11 ms 
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
3 0.12 ms 
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: 
[
  "product_detail"
]
View formatted query    View runnable query    Explain query
4 0.10 ms 
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: 
[
  6
]
View formatted query    View runnable query    Explain query
5 0.07 ms 
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
6 0.09 ms 
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED
Parameters: 
[]
View formatted query    View runnable query    Explain query
7 0.05 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
8 0.08 ms 
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
9 0.41 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.note AS note_3, t0.description_list AS description_list_4, t0.description_detail AS description_detail_5, t0.search_word AS search_word_6, t0.free_area AS free_area_7, t0.maker_order_flg AS maker_order_flg_8, t0.product_caution_note AS product_caution_note_9, t0.purchase_limit AS purchase_limit_10, t0.create_date AS create_date_11, t0.update_date AS update_date_12, t0.size_attention AS size_attention_13, t0.product_type AS product_type_14, t0.set_product_id AS set_product_id_15, t0.internal_name AS internal_name_16, t0.sales_period_flg AS sales_period_flg_17, t0.sales_start_date AS sales_start_date_18, t0.sales_end_date AS sales_end_date_19, t0.spec_image1 AS spec_image1_20, t0.spec_image2 AS spec_image2_21, t0.ship_free_flg AS ship_free_flg_22, t0.ship_free_text AS ship_free_text_23, t0.no_return AS no_return_24, t0.return_message AS return_message_25, t0.shipping_name AS shipping_name_26, t0.creator_id AS creator_id_27, t0.product_status_id AS product_status_id_28, t0.apparel_id AS apparel_id_29, t0.recommend_id AS recommend_id_30, t0.set_product_id AS set_product_id_31, t0.seller_id AS seller_id_32, t0.discriminator_type FROM dtb_product t0 WHERE t0.id = ? AND t0.discriminator_type IN ('product') LIMIT 1
Parameters: 
[
  "118"
]
View formatted query    View runnable query    Explain query
10 1.21 ms 
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.note AS note_2, d0_.description_list AS description_list_3, d0_.description_detail AS description_detail_4, d0_.search_word AS search_word_5, d0_.free_area AS free_area_6, d0_.maker_order_flg AS maker_order_flg_7, d0_.product_caution_note AS product_caution_note_8, d0_.purchase_limit AS purchase_limit_9, d0_.create_date AS create_date_10, d0_.update_date AS update_date_11, d0_.size_attention AS size_attention_12, d0_.product_type AS product_type_13, d0_.set_product_id AS set_product_id_14, d0_.internal_name AS internal_name_15, d0_.sales_period_flg AS sales_period_flg_16, d0_.sales_start_date AS sales_start_date_17, d0_.sales_end_date AS sales_end_date_18, d0_.spec_image1 AS spec_image1_19, d0_.spec_image2 AS spec_image2_20, d0_.ship_free_flg AS ship_free_flg_21, d0_.ship_free_text AS ship_free_text_22, d0_.no_return AS no_return_23, d0_.return_message AS return_message_24, d0_.shipping_name AS shipping_name_25, d1_.id AS id_26, d1_.product_code AS product_code_27, d1_.stock AS stock_28, d1_.stock_unlimited AS stock_unlimited_29, d1_.sale_limit AS sale_limit_30, d1_.safety_stock AS safety_stock_31, d1_.last_stock_in_date AS last_stock_in_date_32, d1_.price01 AS price01_33, d1_.price02 AS price02_34, d1_.delivery_fee AS delivery_fee_35, d1_.visible AS visible_36, d1_.maker_order_flg AS maker_order_flg_37, d1_.create_date AS create_date_38, d1_.update_date AS update_date_39, d1_.currency_code AS currency_code_40, d1_.point_rate AS point_rate_41, d1_.price03 AS price03_42, d1_.product_type AS product_type_43, d1_.stock_date AS stock_date_44, d1_.purchase_price AS purchase_price_45, d2_.id AS id_46, d2_.backend_name AS backend_name_47, d2_.name AS name_48, d2_.sort_no AS sort_no_49, d2_.visible AS visible_50, d2_.create_date AS create_date_51, d2_.update_date AS update_date_52, d2_.internal_name AS internal_name_53, d3_.id AS id_54, d3_.backend_name AS backend_name_55, d3_.name AS name_56, d3_.sort_no AS sort_no_57, d3_.visible AS visible_58, d3_.create_date AS create_date_59, d3_.update_date AS update_date_60, d3_.internal_name AS internal_name_61, d4_.id AS id_62, d4_.file_name AS file_name_63, d4_.sort_no AS sort_no_64, d4_.create_date AS create_date_65, d5_.id AS id_66, d5_.create_date AS create_date_67, d0_.discriminator_type AS discriminator_type_68, d0_.creator_id AS creator_id_69, d0_.product_status_id AS product_status_id_70, d0_.apparel_id AS apparel_id_71, d0_.recommend_id AS recommend_id_72, d0_.set_product_id AS set_product_id_73, d0_.seller_id AS seller_id_74, d1_.discriminator_type AS discriminator_type_75, d1_.product_id AS product_id_76, d1_.sale_type_id AS sale_type_id_77, d1_.class_category_id1 AS class_category_id1_78, d1_.class_category_id2 AS class_category_id2_79, d1_.delivery_duration_id AS delivery_duration_id_80, d1_.creator_id AS creator_id_81, d2_.discriminator_type AS discriminator_type_82, d2_.class_name_id AS class_name_id_83, d2_.creator_id AS creator_id_84, d3_.discriminator_type AS discriminator_type_85, d3_.class_name_id AS class_name_id_86, d3_.creator_id AS creator_id_87, d4_.discriminator_type AS discriminator_type_88, d4_.product_id AS product_id_89, d4_.creator_id AS creator_id_90, d5_.discriminator_type AS discriminator_type_91, d5_.product_id AS product_id_92, d5_.tag_id AS tag_id_93, d5_.creator_id AS creator_id_94 FROM dtb_product d0_ INNER JOIN dtb_product_class d1_ ON d0_.id = d1_.product_id AND d1_.discriminator_type IN ('productclass') LEFT JOIN dtb_class_category d2_ ON d1_.class_category_id1 = d2_.id AND d2_.discriminator_type IN ('classcategory') LEFT JOIN dtb_class_category d3_ ON d1_.class_category_id2 = d3_.id AND d3_.discriminator_type IN ('classcategory') LEFT JOIN dtb_product_image d4_ ON d0_.id = d4_.product_id AND d4_.discriminator_type IN ('productimage') LEFT JOIN dtb_product_tag d5_ ON d0_.id = d5_.product_id AND d5_.discriminator_type IN ('producttag') WHERE (d0_.id = ? AND d1_.visible = ?) AND d0_.discriminator_type IN ('product') ORDER BY d2_.sort_no DESC, d3_.sort_no DESC, d4_.sort_no ASC
Parameters: 
[
  "118"
  1
]
View formatted query    View runnable query    Explain query
11 0.30 ms 
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.create_date AS create_date_3, t0.update_date AS update_date_4, t0.product_class_id AS product_class_id_5, t0.creator_id AS creator_id_6, t0.discriminator_type FROM dtb_product_stock t0 WHERE t0.product_class_id = ? AND t0.discriminator_type IN ('productstock')
Parameters: 
[
  190
]
View formatted query    View runnable query    Explain query
12 0.18 ms 
SELECT t0.id AS id_1, t0.tax_rate AS tax_rate_2, t0.tax_adjust AS tax_adjust_3, t0.apply_date AS apply_date_4, t0.create_date AS create_date_5, t0.update_date AS update_date_6, t0.product_class_id AS product_class_id_7, t0.creator_id AS creator_id_8, t0.country_id AS country_id_9, t0.pref_id AS pref_id_10, t0.product_id AS product_id_11, t0.rounding_type_id AS rounding_type_id_12, t0.discriminator_type FROM dtb_tax_rule t0 WHERE t0.product_class_id = ? AND t0.discriminator_type IN ('taxrule')
Parameters: 
[
  190
]
View formatted query    View runnable query    Explain query
13 0.15 ms 
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.create_date AS create_date_3, t0.update_date AS update_date_4, t0.product_class_id AS product_class_id_5, t0.creator_id AS creator_id_6, t0.discriminator_type FROM dtb_product_stock t0 WHERE t0.product_class_id = ? AND t0.discriminator_type IN ('productstock')
Parameters: 
[
  191
]
View formatted query    View runnable query    Explain query
14 0.08 ms 
SELECT d0_.id AS id_0, d0_.tax_rate AS tax_rate_1, d0_.tax_adjust AS tax_adjust_2, d0_.apply_date AS apply_date_3, d0_.create_date AS create_date_4, d0_.update_date AS update_date_5, d0_.discriminator_type AS discriminator_type_6, d0_.product_class_id AS product_class_id_7, d0_.creator_id AS creator_id_8, d0_.country_id AS country_id_9, d0_.pref_id AS pref_id_10, d0_.product_id AS product_id_11, d0_.rounding_type_id AS rounding_type_id_12 FROM dtb_tax_rule d0_ WHERE (d0_.apply_date < ? AND d0_.pref_id IS NULL AND d0_.country_id IS NULL AND d0_.product_id IS NULL AND d0_.product_class_id IS NULL) AND d0_.discriminator_type IN ('taxrule') ORDER BY d0_.apply_date DESC
Parameters: 
[
  "2026-06-02 20:46:00"
]
View formatted query    View runnable query    Explain query
15 0.15 ms 
SELECT t0.id AS id_1, t0.tax_rate AS tax_rate_2, t0.tax_adjust AS tax_adjust_3, t0.apply_date AS apply_date_4, t0.create_date AS create_date_5, t0.update_date AS update_date_6, t0.product_class_id AS product_class_id_7, t0.creator_id AS creator_id_8, t0.country_id AS country_id_9, t0.pref_id AS pref_id_10, t0.product_id AS product_id_11, t0.rounding_type_id AS rounding_type_id_12, t0.discriminator_type FROM dtb_tax_rule t0 WHERE t0.product_class_id = ? AND t0.discriminator_type IN ('taxrule')
Parameters: 
[
  191
]
View formatted query    View runnable query    Explain query
16 0.14 ms 
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.create_date AS create_date_3, t0.update_date AS update_date_4, t0.product_class_id AS product_class_id_5, t0.creator_id AS creator_id_6, t0.discriminator_type FROM dtb_product_stock t0 WHERE t0.product_class_id = ? AND t0.discriminator_type IN ('productstock')
Parameters: 
[
  192
]
View formatted query    View runnable query    Explain query
17 0.14 ms 
SELECT t0.id AS id_1, t0.tax_rate AS tax_rate_2, t0.tax_adjust AS tax_adjust_3, t0.apply_date AS apply_date_4, t0.create_date AS create_date_5, t0.update_date AS update_date_6, t0.product_class_id AS product_class_id_7, t0.creator_id AS creator_id_8, t0.country_id AS country_id_9, t0.pref_id AS pref_id_10, t0.product_id AS product_id_11, t0.rounding_type_id AS rounding_type_id_12, t0.discriminator_type FROM dtb_tax_rule t0 WHERE t0.product_class_id = ? AND t0.discriminator_type IN ('taxrule')
Parameters: 
[
  192
]
View formatted query    View runnable query    Explain query
18 0.15 ms 
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.create_date AS create_date_3, t0.update_date AS update_date_4, t0.product_class_id AS product_class_id_5, t0.creator_id AS creator_id_6, t0.discriminator_type FROM dtb_product_stock t0 WHERE t0.product_class_id = ? AND t0.discriminator_type IN ('productstock')
Parameters: 
[
  193
]
View formatted query    View runnable query    Explain query
19 0.14 ms 
SELECT t0.id AS id_1, t0.tax_rate AS tax_rate_2, t0.tax_adjust AS tax_adjust_3, t0.apply_date AS apply_date_4, t0.create_date AS create_date_5, t0.update_date AS update_date_6, t0.product_class_id AS product_class_id_7, t0.creator_id AS creator_id_8, t0.country_id AS country_id_9, t0.pref_id AS pref_id_10, t0.product_id AS product_id_11, t0.rounding_type_id AS rounding_type_id_12, t0.discriminator_type FROM dtb_tax_rule t0 WHERE t0.product_class_id = ? AND t0.discriminator_type IN ('taxrule')
Parameters: 
[
  193
]
View formatted query    View runnable query    Explain query
20 0.08 ms 
SELECT t0.id AS id_1, t0.backend_name AS backend_name_2, t0.name AS name_3, t0.sort_no AS sort_no_4, t0.create_date AS create_date_5, t0.update_date AS update_date_6, t0.internal_name AS internal_name_7, t0.creator_id AS creator_id_8, t0.discriminator_type FROM dtb_class_name t0 WHERE t0.id = ? AND t0.discriminator_type IN ('classname')
Parameters: 
[
  44
]
View formatted query    View runnable query    Explain query
21 0.07 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.discriminator_type FROM mtb_sex t0 WHERE t0.id = ? AND t0.discriminator_type IN ('sex')
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
22 0.18 ms 
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

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\Delivery No errors.
Eccube\Entity\CustomerFavoriteProduct No errors.
Eccube\Entity\ProductClass No errors.
Eccube\Entity\Cart No errors.
Customize\Entity\SetProduct
  • The field Customize\Entity\SetProduct#SetProductImage is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Customize\Entity\SetProductImage#SetProduct does not contain the required 'inversedBy="SetProductImage"' attribute.
  • The field Customize\Entity\SetProduct#SetProductSchool is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Customize\Entity\SetProductSchool#SetProduct does not contain the required 'inversedBy="SetProductSchool"' attribute.
  • The field Customize\Entity\SetProduct#SetProductProduct is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Customize\Entity\SetProductProduct#SetProduct does not contain the required 'inversedBy="SetProductProduct"' attribute.
Eccube\Entity\Master\ProductListMax No errors.
Customize\Entity\RecommendX No errors.
Customize\Entity\RecommendY No errors.
Customize\Entity\RecommendSize No errors.
Customize\Entity\Brother No errors.
Eccube\Entity\Member No errors.
Eccube\Entity\Master\ProductStatus No errors.
Customize\Entity\Apparel No errors.
Customize\Entity\Recommend No errors.
Eccube\Entity\ProductCategory No errors.
Eccube\Entity\ProductImage No errors.
Eccube\Entity\ProductTag No errors.
Eccube\Entity\ClassCategory No errors.
Eccube\Entity\Master\SaleType No errors.
Eccube\Entity\DeliveryDuration No errors.
Eccube\Entity\ClassName No errors.
Eccube\Entity\Tag No errors.
Eccube\Entity\ProductStock No errors.
Eccube\Entity\TaxRule No errors.
Eccube\Entity\Master\RoundingType No errors.
Eccube\Entity\Master\Sex No errors.