https://mu-ecshop.com/block/search_product

Method
GET
HTTP Status
200
IP
18.116.12.7
Profiled on
Token
bf05c8

Query Metrics

11 Database Queries
11 Different statements
3.28 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
1.14 ms
(34.72%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.page_title AS page_title_4, t0.slug AS slug_5, t0.current_revision AS current_revision_6, t0.total_response_count AS total_response_count_7, t0.publish_start AS publish_start_8, t0.publish_end AS publish_end_9, t0.send_email AS send_email_10, t0.only_member AS only_member_11, t0.enable_reply_email AS enable_reply_email_12, t0.enable_bcc AS enable_bcc_13, t0.published AS published_14, t0.del_flg AS del_flg_15, t0.create_date AS create_date_16, t0.update_date AS update_date_17, t0.input_page_id AS input_page_id_18, t0.complete_page_id AS complete_page_id_19, t0.system_mail_template_id AS system_mail_template_id_20, t0.reply_mail_template_id AS reply_mail_template_id_21 FROM plg_apg_form_builder_form t0 WHERE t0.slug = ? AND t0.del_flg = ? LIMIT 1
Parameters: 
[
  "entry"
  0
]
View formatted query    View runnable query    Explain query
0.95 ms
(28.81%) 		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
0.19 ms
(5.82%) 		1 
SELECT d0_.school_id AS school_id_0, d0_.school_name AS school_name_1, d0_.school_kana AS school_kana_2, d0_.school_order AS school_order_3, d0_.customer_selfdel_flg AS customer_selfdel_flg_4, d0_.school_email AS school_email_5, d0_.target_student AS target_student_6, d0_.online_flag AS online_flag_7, d0_.school_measuring_flag AS school_measuring_flag_8, d0_.store_measuring_flag AS store_measuring_flag_9, d0_.online_order_deadline AS online_order_deadline_10, d0_.school_measuring_date AS school_measuring_date_11, d0_.store_measuring_deadline AS store_measuring_deadline_12, d0_.purchase_flag AS purchase_flag_13, d0_.online_order_start_date AS online_order_start_date_14, d0_.online_order_end_date AS online_order_end_date_15, d0_.members_registration_type AS members_registration_type_16, d0_.school_key AS school_key_17, d0_.visible_school_key AS visible_school_key_18, d0_.create_date AS create_date_19, d0_.update_date AS update_date_20, d0_.school_code AS school_code_21, d0_.entry_url AS entry_url_22, d0_.delivery_free_type AS delivery_free_type_23, d0_.delivery_free_amount AS delivery_free_amount_24, d0_.delivery_free_quantity AS delivery_free_quantity_25, d0_.measure_plugin_type AS measure_plugin_type_26, d0_.default_sex_products_filtering_flag AS default_sex_products_filtering_flag_27, d0_.measuring_registration_required_flag AS measuring_registration_required_flag_28, d0_.top_page_popup_flag AS top_page_popup_flag_29, d0_.reg_data_popup_flag AS reg_data_popup_flag_30, d0_.chat_bot_flag AS chat_bot_flag_31, d0_.measuring_data_confirmation_flag AS measuring_data_confirmation_flag_32, d0_.size_recommend_flag AS size_recommend_flag_33, d0_.item_visible_type AS item_visible_type_34, d0_.sale_start_date AS sale_start_date_35, d0_.sale_end_date AS sale_end_date_36, d0_.reservation_site_url AS reservation_site_url_37, d0_.name_notation AS name_notation_38, d0_.name01_entry_sample AS name01_entry_sample_39, d0_.name02_entry_sample AS name02_entry_sample_40, d0_.kana_notation AS kana_notation_41, d0_.kana01_entry_sample AS kana01_entry_sample_42, d0_.kana02_entry_sample AS kana02_entry_sample_43, d0_.name_visible_type AS name_visible_type_44, d0_.addr_notation AS addr_notation_45, d0_.zip01_entry_sample AS zip01_entry_sample_46, d0_.zip02_entry_sample AS zip02_entry_sample_47, d0_.addr01_entry_sample AS addr01_entry_sample_48, d0_.addr02_entry_sample AS addr02_entry_sample_49, d0_.addr_visible_type AS addr_visible_type_50, d0_.addr_visible_all AS addr_visible_all_51, d0_.tel_notation AS tel_notation_52, d0_.tel1_01_entry_sample AS tel1_01_entry_sample_53, d0_.tel1_02_entry_sample AS tel1_02_entry_sample_54, d0_.tel1_03_entry_sample AS tel1_03_entry_sample_55, d0_.tel01_visible_type AS tel01_visible_type_56, d0_.tel02_visible_type AS tel02_visible_type_57, d0_.tel2_notation AS tel2_notation_58, d0_.tel2_01_entry_sample AS tel2_01_entry_sample_59, d0_.tel2_02_entry_sample AS tel2_02_entry_sample_60, d0_.tel2_03_entry_sample AS tel2_03_entry_sample_61, d0_.email_notation AS email_notation_62, d0_.email_entry_sample AS email_entry_sample_63, d0_.email_visible_type AS email_visible_type_64, d0_.password_notation AS password_notation_65, d0_.password_entry_sample AS password_entry_sample_66, d0_.password_visible_type AS password_visible_type_67, d0_.adyear_visible_type AS adyear_visible_type_68, d0_.adyear_notation AS adyear_notation_69, d0_.adyear_entry_sample AS adyear_entry_sample_70, d0_.exam_number_visible_type AS exam_number_visible_type_71, d0_.exam_number_notation AS exam_number_notation_72, d0_.exam_number_entry_sample AS exam_number_entry_sample_73, d0_.prev_school_visible_type AS prev_school_visible_type_74, d0_.prev_school_notation AS prev_school_notation_75, d0_.prev_school_entry_sample AS prev_school_entry_sample_76, d0_.prev_year_class_visible_type AS prev_year_class_visible_type_77, d0_.prev_year_class_notation AS prev_year_class_notation_78, d0_.prev_year_entry_sample AS prev_year_entry_sample_79, d0_.prev_class_entry_sample AS prev_class_entry_sample_80, d0_.birth_visible_type AS birth_visible_type_81, d0_.birth_notation AS birth_notation_82, d0_.birth_entry_sample AS birth_entry_sample_83, d0_.parents_name_visible_type AS parents_name_visible_type_84, d0_.parents_name_notation AS parents_name_notation_85, d0_.parents_name01_entry_sample AS parents_name01_entry_sample_86, d0_.parents_name02_entry_sample AS parents_name02_entry_sample_87, d0_.parents_birth_visible_type AS parents_birth_visible_type_88, d0_.parents_birth_notation AS parents_birth_notation_89, d0_.parents_birth_entry_sample AS parents_birth_entry_sample_90, d0_.current_year_visible_type AS current_year_visible_type_91, d0_.current_year_class_notation AS current_year_class_notation_92, d0_.current_year_entry_sample AS current_year_entry_sample_93, d0_.current_class_notation AS current_class_notation_94, d0_.student_number_visible_type AS student_number_visible_type_95, d0_.student_number_notation AS student_number_notation_96, d0_.student_number_entry_sample AS student_number_entry_sample_97, d0_.freeitem1_visible_type AS freeitem1_visible_type_98, d0_.freeitem1_name AS freeitem1_name_99, d0_.freeitem1_notation AS freeitem1_notation_100, d0_.freeitem1_entry_sample AS freeitem1_entry_sample_101, d0_.freeitem2_visible_type AS freeitem2_visible_type_102, d0_.freeitem2_name AS freeitem2_name_103, d0_.freeitem2_notation AS freeitem2_notation_104, d0_.freeitem2_entry_sample AS freeitem2_entry_sample_105, d0_.sex_visible_type AS sex_visible_type_106, d0_.fax_visible_type AS fax_visible_type_107, d0_.measure_height_visible_type AS measure_height_visible_type_108, d0_.measure_weight_visible_type AS measure_weight_visible_type_109, d0_.measure_shoulder_visible_type AS measure_shoulder_visible_type_110, d0_.measure_sleeve1_visible_type AS measure_sleeve1_visible_type_111, d0_.measure_sleeve2_visible_type AS measure_sleeve2_visible_type_112, d0_.measure_total_visible_type AS measure_total_visible_type_113, d0_.measure_neck_visible_type AS measure_neck_visible_type_114, d0_.measure_bust_visible_type AS measure_bust_visible_type_115, d0_.measure_waist_visible_type AS measure_waist_visible_type_116, d0_.measure_hips_visible_type AS measure_hips_visible_type_117, d0_.measure_inseam_visible_type AS measure_inseam_visible_type_118, d0_.measure_skirt_visible_type AS measure_skirt_visible_type_119, d0_.measure_slacks_visible_type AS measure_slacks_visible_type_120, d0_.enter_year_class AS enter_year_class_121, d0_.visible_commodity_alert AS visible_commodity_alert_122, d0_.visible_flg AS visible_flg_123, d0_.brother_flg AS brother_flg_124, d0_.require_school_key AS require_school_key_125, d0_.require_brothers AS require_brothers_126, d0_.product_sexvisible_type AS product_sexvisible_type_127, d0_.report_measure_flag AS report_measure_flag_128, d0_.report_grade_flag AS report_grade_flag_129, d0_.report_class_flag AS report_class_flag_130, d0_.report_storemail_flag AS report_storemail_flag_131, d0_.report_tax_flag AS report_tax_flag_132, d0_.order_delivery_notation AS order_delivery_notation_133, d0_.order_payment_notation AS order_payment_notation_134, d0_.addr01_max_length AS addr01_max_length_135, d0_.addr02_max_length AS addr02_max_length_136, d0_.discriminator_type AS discriminator_type_137, d0_.recommend_id AS recommend_id_138 FROM dtb_school d0_ WHERE (d0_.visible_flg = 1) AND d0_.discriminator_type IN ('school') ORDER BY d0_.school_order ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.18 ms
(5.40%) 		1 
SET SESSION time_zone = '+00:00'
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.17 ms
(5.08%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.discriminator_type FROM mtb_customer_status t0 WHERE t0.id = ? AND t0.discriminator_type IN ('customerstatus')
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
0.17 ms
(5.06%) 		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
0.15 ms
(4.60%) 		1 
SELECT t0.school_id AS school_id_1, t0.school_name AS school_name_2, t0.school_kana AS school_kana_3, t0.school_order AS school_order_4, t0.customer_selfdel_flg AS customer_selfdel_flg_5, t0.school_email AS school_email_6, t0.target_student AS target_student_7, t0.online_flag AS online_flag_8, t0.school_measuring_flag AS school_measuring_flag_9, t0.store_measuring_flag AS store_measuring_flag_10, t0.online_order_deadline AS online_order_deadline_11, t0.school_measuring_date AS school_measuring_date_12, t0.store_measuring_deadline AS store_measuring_deadline_13, t0.purchase_flag AS purchase_flag_14, t0.online_order_start_date AS online_order_start_date_15, t0.online_order_end_date AS online_order_end_date_16, t0.members_registration_type AS members_registration_type_17, t0.school_key AS school_key_18, t0.visible_school_key AS visible_school_key_19, t0.create_date AS create_date_20, t0.update_date AS update_date_21, t0.school_code AS school_code_22, t0.entry_url AS entry_url_23, t0.delivery_free_type AS delivery_free_type_24, t0.delivery_free_amount AS delivery_free_amount_25, t0.delivery_free_quantity AS delivery_free_quantity_26, t0.measure_plugin_type AS measure_plugin_type_27, t0.default_sex_products_filtering_flag AS default_sex_products_filtering_flag_28, t0.measuring_registration_required_flag AS measuring_registration_required_flag_29, t0.top_page_popup_flag AS top_page_popup_flag_30, t0.reg_data_popup_flag AS reg_data_popup_flag_31, t0.chat_bot_flag AS chat_bot_flag_32, t0.measuring_data_confirmation_flag AS measuring_data_confirmation_flag_33, t0.size_recommend_flag AS size_recommend_flag_34, t0.item_visible_type AS item_visible_type_35, t0.sale_start_date AS sale_start_date_36, t0.sale_end_date AS sale_end_date_37, t0.reservation_site_url AS reservation_site_url_38, t0.name_notation AS name_notation_39, t0.name01_entry_sample AS name01_entry_sample_40, t0.name02_entry_sample AS name02_entry_sample_41, t0.kana_notation AS kana_notation_42, t0.kana01_entry_sample AS kana01_entry_sample_43, t0.kana02_entry_sample AS kana02_entry_sample_44, t0.name_visible_type AS name_visible_type_45, t0.addr_notation AS addr_notation_46, t0.zip01_entry_sample AS zip01_entry_sample_47, t0.zip02_entry_sample AS zip02_entry_sample_48, t0.addr01_entry_sample AS addr01_entry_sample_49, t0.addr02_entry_sample AS addr02_entry_sample_50, t0.addr_visible_type AS addr_visible_type_51, t0.addr_visible_all AS addr_visible_all_52, t0.tel_notation AS tel_notation_53, t0.tel1_01_entry_sample AS tel1_01_entry_sample_54, t0.tel1_02_entry_sample AS tel1_02_entry_sample_55, t0.tel1_03_entry_sample AS tel1_03_entry_sample_56, t0.tel01_visible_type AS tel01_visible_type_57, t0.tel02_visible_type AS tel02_visible_type_58, t0.tel2_notation AS tel2_notation_59, t0.tel2_01_entry_sample AS tel2_01_entry_sample_60, t0.tel2_02_entry_sample AS tel2_02_entry_sample_61, t0.tel2_03_entry_sample AS tel2_03_entry_sample_62, t0.email_notation AS email_notation_63, t0.email_entry_sample AS email_entry_sample_64, t0.email_visible_type AS email_visible_type_65, t0.password_notation AS password_notation_66, t0.password_entry_sample AS password_entry_sample_67, t0.password_visible_type AS password_visible_type_68, t0.adyear_visible_type AS adyear_visible_type_69, t0.adyear_notation AS adyear_notation_70, t0.adyear_entry_sample AS adyear_entry_sample_71, t0.exam_number_visible_type AS exam_number_visible_type_72, t0.exam_number_notation AS exam_number_notation_73, t0.exam_number_entry_sample AS exam_number_entry_sample_74, t0.prev_school_visible_type AS prev_school_visible_type_75, t0.prev_school_notation AS prev_school_notation_76, t0.prev_school_entry_sample AS prev_school_entry_sample_77, t0.prev_year_class_visible_type AS prev_year_class_visible_type_78, t0.prev_year_class_notation AS prev_year_class_notation_79, t0.prev_year_entry_sample AS prev_year_entry_sample_80, t0.prev_class_entry_sample AS prev_class_entry_sample_81, t0.birth_visible_type AS birth_visible_type_82, t0.birth_notation AS birth_notation_83, t0.birth_entry_sample AS birth_entry_sample_84, t0.parents_name_visible_type AS parents_name_visible_type_85, t0.parents_name_notation AS parents_name_notation_86, t0.parents_name01_entry_sample AS parents_name01_entry_sample_87, t0.parents_name02_entry_sample AS parents_name02_entry_sample_88, t0.parents_birth_visible_type AS parents_birth_visible_type_89, t0.parents_birth_notation AS parents_birth_notation_90, t0.parents_birth_entry_sample AS parents_birth_entry_sample_91, t0.current_year_visible_type AS current_year_visible_type_92, t0.current_year_class_notation AS current_year_class_notation_93, t0.current_year_entry_sample AS current_year_entry_sample_94, t0.current_class_notation AS current_class_notation_95, t0.student_number_visible_type AS student_number_visible_type_96, t0.student_number_notation AS student_number_notation_97, t0.student_number_entry_sample AS student_number_entry_sample_98, t0.freeitem1_visible_type AS freeitem1_visible_type_99, t0.freeitem1_name AS freeitem1_name_100, t0.freeitem1_notation AS freeitem1_notation_101, t0.freeitem1_entry_sample AS freeitem1_entry_sample_102, t0.freeitem2_visible_type AS freeitem2_visible_type_103, t0.freeitem2_name AS freeitem2_name_104, t0.freeitem2_notation AS freeitem2_notation_105, t0.freeitem2_entry_sample AS freeitem2_entry_sample_106, t0.sex_visible_type AS sex_visible_type_107, t0.fax_visible_type AS fax_visible_type_108, t0.measure_height_visible_type AS measure_height_visible_type_109, t0.measure_weight_visible_type AS measure_weight_visible_type_110, t0.measure_shoulder_visible_type AS measure_shoulder_visible_type_111, t0.measure_sleeve1_visible_type AS measure_sleeve1_visible_type_112, t0.measure_sleeve2_visible_type AS measure_sleeve2_visible_type_113, t0.measure_total_visible_type AS measure_total_visible_type_114, t0.measure_neck_visible_type AS measure_neck_visible_type_115, t0.measure_bust_visible_type AS measure_bust_visible_type_116, t0.measure_waist_visible_type AS measure_waist_visible_type_117, t0.measure_hips_visible_type AS measure_hips_visible_type_118, t0.measure_inseam_visible_type AS measure_inseam_visible_type_119, t0.measure_skirt_visible_type AS measure_skirt_visible_type_120, t0.measure_slacks_visible_type AS measure_slacks_visible_type_121, t0.enter_year_class AS enter_year_class_122, t0.visible_commodity_alert AS visible_commodity_alert_123, t0.visible_flg AS visible_flg_124, t0.brother_flg AS brother_flg_125, t0.require_school_key AS require_school_key_126, t0.require_brothers AS require_brothers_127, t0.product_sexvisible_type AS product_sexvisible_type_128, t0.report_measure_flag AS report_measure_flag_129, t0.report_grade_flag AS report_grade_flag_130, t0.report_class_flag AS report_class_flag_131, t0.report_storemail_flag AS report_storemail_flag_132, t0.report_tax_flag AS report_tax_flag_133, t0.order_delivery_notation AS order_delivery_notation_134, t0.order_payment_notation AS order_payment_notation_135, t0.addr01_max_length AS addr01_max_length_136, t0.addr02_max_length AS addr02_max_length_137, t0.recommend_id AS recommend_id_138, t0.discriminator_type FROM dtb_school t0 WHERE t0.discriminator_type IN ('school')
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.12 ms
(3.78%) 		1 
SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.company_kana AS company_kana_3, t0.postal_code AS postal_code_4, t0.addr01 AS addr01_5, t0.addr02 AS addr02_6, t0.phone_number AS phone_number_7, t0.business_hour AS business_hour_8, t0.email01 AS email01_9, t0.email02 AS email02_10, t0.email03 AS email03_11, t0.email04 AS email04_12, t0.shop_name AS shop_name_13, t0.shop_kana AS shop_kana_14, t0.shop_name_eng AS shop_name_eng_15, t0.update_date AS update_date_16, t0.good_traded AS good_traded_17, t0.message AS message_18, t0.delivery_free_amount AS delivery_free_amount_19, t0.delivery_free_quantity AS delivery_free_quantity_20, t0.option_mypage_order_status_display AS option_mypage_order_status_display_21, t0.option_nostock_hidden AS option_nostock_hidden_22, t0.option_favorite_product AS option_favorite_product_23, t0.option_product_delivery_fee AS option_product_delivery_fee_24, t0.invoice_registration_number AS invoice_registration_number_25, t0.option_product_tax_rule AS option_product_tax_rule_26, t0.option_customer_activate AS option_customer_activate_27, t0.option_remember_me AS option_remember_me_28, t0.option_mail_notifier AS option_mail_notifier_29, t0.authentication_key AS authentication_key_30, t0.php_path AS php_path_31, t0.option_point AS option_point_32, t0.basic_point_rate AS basic_point_rate_33, t0.point_conversion_rate AS point_conversion_rate_34, t0.contact_school_visible_type AS contact_school_visible_type_35, t0.country_id AS country_id_36, t0.pref_id AS pref_id_37, t0.discriminator_type FROM dtb_base_info t0 WHERE t0.id = ? AND t0.discriminator_type IN ('baseinfo')
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
0.09 ms
(2.83%) 		1 
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.09 ms
(2.75%) 		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: 
[
  "entry"
]
View formatted query    View runnable query    Explain query
0.04 ms
(1.15%) 		1 
"START TRANSACTION"
Parameters: 
[]
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.
Plugin\ApgFormBuilder42\Entity\ApgForm No errors.
Eccube\Entity\Page No errors.
Eccube\Entity\MailTemplate No errors.
Eccube\Entity\BaseInfo No errors.
Eccube\Entity\PageLayout No errors.
Eccube\Entity\Block No errors.
Eccube\Entity\BlockPosition No errors.
Eccube\Entity\Master\AbstractMasterEntity No errors.
Eccube\Entity\Master\DeviceType No errors.
Eccube\Entity\AuthorityRole No errors.
Eccube\Entity\Layout No errors.
Eccube\Entity\Master\Country No errors.
Eccube\Entity\Master\Pref No errors.
Eccube\Entity\Master\CustomerStatus No errors.
Eccube\Entity\MailHistory 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\Brother No errors.
Customize\Entity\Recommend No errors.
Customize\Entity\SchoolDelivery No errors.
Eccube\Entity\Category No errors.
Eccube\Entity\Member No errors.
Eccube\Entity\ProductCategory No errors.