https://xyzsys.net/products/cartlist/149

Method
GET
HTTP Status
200
IP
57.141.2.8
Profiled on
Token
bddff5

Query Metrics

37 Database Queries
20 Different statements
8.32 ms Query time
1 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.21 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.country_id AS country_id_35, t0.pref_id AS pref_id_36, t0.discriminator_type FROM dtb_base_info t0 WHERE t0.id = ? AND t0.discriminator_type IN ('baseinfo')
Parameters: 
  0 of 0   
[▼
  1
]
View formatted query    View runnable query    Explain query
3 0.09 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: 
  0 of 0   
[▼
  "product_list"
]
View formatted query    View runnable query    Explain query
4 0.09 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: 
  0 of 0   
[▼
  2
]
View formatted query    View runnable query    Explain query
5 0.08 ms 
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED
Parameters: 
[]
View formatted query    View runnable query    Explain query
6 0.05 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
7 0.21 ms 
SELECT t0.id AS id_1, t0.category_name AS category_name_2, t0.hierarchy AS hierarchy_3, t0.sort_no AS sort_no_4, t0.create_date AS create_date_5, t0.update_date AS update_date_6, t0.url AS url_7, t0.title_image_path AS title_image_path_8, t0.teikikoudoku1 AS teikikoudoku1_9, t0.teikikoudoku2 AS teikikoudoku2_10, t0.menuno AS menuno_11, t0.kankou AS kankou_12, t0.hatsubaibi AS hatsubaibi_13, t0.newno AS newno_14, t0.linkimage01 AS linkimage01_15, t0.linkimage02 AS linkimage02_16, t0.linkimage03 AS linkimage03_17, t0.linkimage04 AS linkimage04_18, t0.linkimage05 AS linkimage05_19, t0.linkimage06 AS linkimage06_20, t0.linkimage07 AS linkimage07_21, t0.linkimage08 AS linkimage08_22, t0.linkimage09 AS linkimage09_23, t0.linkimage10 AS linkimage10_24, t0.linkimage11 AS linkimage11_25, t0.linkimage12 AS linkimage12_26, t0.linkimage13 AS linkimage13_27, t0.linkimage14 AS linkimage14_28, t0.linkimage15 AS linkimage15_29, t0.linkimage16 AS linkimage16_30, t0.linkimage17 AS linkimage17_31, t0.linkimage18 AS linkimage18_32, t0.linkimage19 AS linkimage19_33, t0.linkimage20 AS linkimage20_34, t0.linkimage21 AS linkimage21_35, t0.linkimage22 AS linkimage22_36, t0.linkimage23 AS linkimage23_37, t0.linkimage24 AS linkimage24_38, t0.linkimage25 AS linkimage25_39, t0.linkimage26 AS linkimage26_40, t0.linkimage27 AS linkimage27_41, t0.linkimage28 AS linkimage28_42, t0.linkimage29 AS linkimage29_43, t0.linkimage30 AS linkimage30_44, t0.link01 AS link01_45, t0.link02 AS link02_46, t0.link03 AS link03_47, t0.link04 AS link04_48, t0.link05 AS link05_49, t0.link06 AS link06_50, t0.link07 AS link07_51, t0.link08 AS link08_52, t0.link09 AS link09_53, t0.link10 AS link10_54, t0.link11 AS link11_55, t0.link12 AS link12_56, t0.link13 AS link13_57, t0.link14 AS link14_58, t0.link15 AS link15_59, t0.link16 AS link16_60, t0.link17 AS link17_61, t0.link18 AS link18_62, t0.link19 AS link19_63, t0.link20 AS link20_64, t0.link21 AS link21_65, t0.link22 AS link22_66, t0.link23 AS link23_67, t0.link24 AS link24_68, t0.link25 AS link25_69, t0.link26 AS link26_70, t0.link27 AS link27_71, t0.link28 AS link28_72, t0.link29 AS link29_73, t0.link30 AS link30_74, t0.blank01 AS blank01_75, t0.blank02 AS blank02_76, t0.blank03 AS blank03_77, t0.blank04 AS blank04_78, t0.blank05 AS blank05_79, t0.blank06 AS blank06_80, t0.blank07 AS blank07_81, t0.blank08 AS blank08_82, t0.blank09 AS blank09_83, t0.blank10 AS blank10_84, t0.blank11 AS blank11_85, t0.blank12 AS blank12_86, t0.blank13 AS blank13_87, t0.blank14 AS blank14_88, t0.blank15 AS blank15_89, t0.blank16 AS blank16_90, t0.blank17 AS blank17_91, t0.blank18 AS blank18_92, t0.blank19 AS blank19_93, t0.blank20 AS blank20_94, t0.blank21 AS blank21_95, t0.blank22 AS blank22_96, t0.blank23 AS blank23_97, t0.blank24 AS blank24_98, t0.blank25 AS blank25_99, t0.blank26 AS blank26_100, t0.blank27 AS blank27_101, t0.blank28 AS blank28_102, t0.blank29 AS blank29_103, t0.blank30 AS blank30_104, t0.newcate AS newcate_105, t0.dspfl AS dspfl_106, t0.parent_category_id AS parent_category_id_107, t0.creator_id AS creator_id_108, t0.discriminator_type FROM dtb_category t0 WHERE t0.id = ? AND t0.discriminator_type IN ('category') LIMIT 1
Parameters: 
  0 of 0   
[▼
  1
]
View formatted query    View runnable query    Explain query
8 0.11 ms 
SELECT t0.id AS id_1, t0.category_name AS category_name_2, t0.hierarchy AS hierarchy_3, t0.sort_no AS sort_no_4, t0.create_date AS create_date_5, t0.update_date AS update_date_6, t0.url AS url_7, t0.title_image_path AS title_image_path_8, t0.teikikoudoku1 AS teikikoudoku1_9, t0.teikikoudoku2 AS teikikoudoku2_10, t0.menuno AS menuno_11, t0.kankou AS kankou_12, t0.hatsubaibi AS hatsubaibi_13, t0.newno AS newno_14, t0.linkimage01 AS linkimage01_15, t0.linkimage02 AS linkimage02_16, t0.linkimage03 AS linkimage03_17, t0.linkimage04 AS linkimage04_18, t0.linkimage05 AS linkimage05_19, t0.linkimage06 AS linkimage06_20, t0.linkimage07 AS linkimage07_21, t0.linkimage08 AS linkimage08_22, t0.linkimage09 AS linkimage09_23, t0.linkimage10 AS linkimage10_24, t0.linkimage11 AS linkimage11_25, t0.linkimage12 AS linkimage12_26, t0.linkimage13 AS linkimage13_27, t0.linkimage14 AS linkimage14_28, t0.linkimage15 AS linkimage15_29, t0.linkimage16 AS linkimage16_30, t0.linkimage17 AS linkimage17_31, t0.linkimage18 AS linkimage18_32, t0.linkimage19 AS linkimage19_33, t0.linkimage20 AS linkimage20_34, t0.linkimage21 AS linkimage21_35, t0.linkimage22 AS linkimage22_36, t0.linkimage23 AS linkimage23_37, t0.linkimage24 AS linkimage24_38, t0.linkimage25 AS linkimage25_39, t0.linkimage26 AS linkimage26_40, t0.linkimage27 AS linkimage27_41, t0.linkimage28 AS linkimage28_42, t0.linkimage29 AS linkimage29_43, t0.linkimage30 AS linkimage30_44, t0.link01 AS link01_45, t0.link02 AS link02_46, t0.link03 AS link03_47, t0.link04 AS link04_48, t0.link05 AS link05_49, t0.link06 AS link06_50, t0.link07 AS link07_51, t0.link08 AS link08_52, t0.link09 AS link09_53, t0.link10 AS link10_54, t0.link11 AS link11_55, t0.link12 AS link12_56, t0.link13 AS link13_57, t0.link14 AS link14_58, t0.link15 AS link15_59, t0.link16 AS link16_60, t0.link17 AS link17_61, t0.link18 AS link18_62, t0.link19 AS link19_63, t0.link20 AS link20_64, t0.link21 AS link21_65, t0.link22 AS link22_66, t0.link23 AS link23_67, t0.link24 AS link24_68, t0.link25 AS link25_69, t0.link26 AS link26_70, t0.link27 AS link27_71, t0.link28 AS link28_72, t0.link29 AS link29_73, t0.link30 AS link30_74, t0.blank01 AS blank01_75, t0.blank02 AS blank02_76, t0.blank03 AS blank03_77, t0.blank04 AS blank04_78, t0.blank05 AS blank05_79, t0.blank06 AS blank06_80, t0.blank07 AS blank07_81, t0.blank08 AS blank08_82, t0.blank09 AS blank09_83, t0.blank10 AS blank10_84, t0.blank11 AS blank11_85, t0.blank12 AS blank12_86, t0.blank13 AS blank13_87, t0.blank14 AS blank14_88, t0.blank15 AS blank15_89, t0.blank16 AS blank16_90, t0.blank17 AS blank17_91, t0.blank18 AS blank18_92, t0.blank19 AS blank19_93, t0.blank20 AS blank20_94, t0.blank21 AS blank21_95, t0.blank22 AS blank22_96, t0.blank23 AS blank23_97, t0.blank24 AS blank24_98, t0.blank25 AS blank25_99, t0.blank26 AS blank26_100, t0.blank27 AS blank27_101, t0.blank28 AS blank28_102, t0.blank29 AS blank29_103, t0.blank30 AS blank30_104, t0.newcate AS newcate_105, t0.dspfl AS dspfl_106, t0.parent_category_id AS parent_category_id_107, t0.creator_id AS creator_id_108, t0.discriminator_type FROM dtb_category t0 WHERE t0.parent_category_id = ? AND t0.discriminator_type IN ('category') ORDER BY t0.sort_no DESC
Parameters: 
  0 of 0   
[▼
  1
]
View formatted query    View runnable query    Explain query
9 0.09 ms 
SELECT t0.id AS id_1, t0.category_name AS category_name_2, t0.hierarchy AS hierarchy_3, t0.sort_no AS sort_no_4, t0.create_date AS create_date_5, t0.update_date AS update_date_6, t0.url AS url_7, t0.title_image_path AS title_image_path_8, t0.teikikoudoku1 AS teikikoudoku1_9, t0.teikikoudoku2 AS teikikoudoku2_10, t0.menuno AS menuno_11, t0.kankou AS kankou_12, t0.hatsubaibi AS hatsubaibi_13, t0.newno AS newno_14, t0.linkimage01 AS linkimage01_15, t0.linkimage02 AS linkimage02_16, t0.linkimage03 AS linkimage03_17, t0.linkimage04 AS linkimage04_18, t0.linkimage05 AS linkimage05_19, t0.linkimage06 AS linkimage06_20, t0.linkimage07 AS linkimage07_21, t0.linkimage08 AS linkimage08_22, t0.linkimage09 AS linkimage09_23, t0.linkimage10 AS linkimage10_24, t0.linkimage11 AS linkimage11_25, t0.linkimage12 AS linkimage12_26, t0.linkimage13 AS linkimage13_27, t0.linkimage14 AS linkimage14_28, t0.linkimage15 AS linkimage15_29, t0.linkimage16 AS linkimage16_30, t0.linkimage17 AS linkimage17_31, t0.linkimage18 AS linkimage18_32, t0.linkimage19 AS linkimage19_33, t0.linkimage20 AS linkimage20_34, t0.linkimage21 AS linkimage21_35, t0.linkimage22 AS linkimage22_36, t0.linkimage23 AS linkimage23_37, t0.linkimage24 AS linkimage24_38, t0.linkimage25 AS linkimage25_39, t0.linkimage26 AS linkimage26_40, t0.linkimage27 AS linkimage27_41, t0.linkimage28 AS linkimage28_42, t0.linkimage29 AS linkimage29_43, t0.linkimage30 AS linkimage30_44, t0.link01 AS link01_45, t0.link02 AS link02_46, t0.link03 AS link03_47, t0.link04 AS link04_48, t0.link05 AS link05_49, t0.link06 AS link06_50, t0.link07 AS link07_51, t0.link08 AS link08_52, t0.link09 AS link09_53, t0.link10 AS link10_54, t0.link11 AS link11_55, t0.link12 AS link12_56, t0.link13 AS link13_57, t0.link14 AS link14_58, t0.link15 AS link15_59, t0.link16 AS link16_60, t0.link17 AS link17_61, t0.link18 AS link18_62, t0.link19 AS link19_63, t0.link20 AS link20_64, t0.link21 AS link21_65, t0.link22 AS link22_66, t0.link23 AS link23_67, t0.link24 AS link24_68, t0.link25 AS link25_69, t0.link26 AS link26_70, t0.link27 AS link27_71, t0.link28 AS link28_72, t0.link29 AS link29_73, t0.link30 AS link30_74, t0.blank01 AS blank01_75, t0.blank02 AS blank02_76, t0.blank03 AS blank03_77, t0.blank04 AS blank04_78, t0.blank05 AS blank05_79, t0.blank06 AS blank06_80, t0.blank07 AS blank07_81, t0.blank08 AS blank08_82, t0.blank09 AS blank09_83, t0.blank10 AS blank10_84, t0.blank11 AS blank11_85, t0.blank12 AS blank12_86, t0.blank13 AS blank13_87, t0.blank14 AS blank14_88, t0.blank15 AS blank15_89, t0.blank16 AS blank16_90, t0.blank17 AS blank17_91, t0.blank18 AS blank18_92, t0.blank19 AS blank19_93, t0.blank20 AS blank20_94, t0.blank21 AS blank21_95, t0.blank22 AS blank22_96, t0.blank23 AS blank23_97, t0.blank24 AS blank24_98, t0.blank25 AS blank25_99, t0.blank26 AS blank26_100, t0.blank27 AS blank27_101, t0.blank28 AS blank28_102, t0.blank29 AS blank29_103, t0.blank30 AS blank30_104, t0.newcate AS newcate_105, t0.dspfl AS dspfl_106, t0.parent_category_id AS parent_category_id_107, t0.creator_id AS creator_id_108, t0.discriminator_type FROM dtb_category t0 WHERE t0.id = ? AND t0.discriminator_type IN ('category')
Parameters: 
  0 of 0   
[▼
  "149"
]
View formatted query    View runnable query    Explain query
10 0.60 ms 
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, d0_.url AS url_6, d0_.title_image_path AS title_image_path_7, d0_.teikikoudoku1 AS teikikoudoku1_8, d0_.teikikoudoku2 AS teikikoudoku2_9, d0_.menuno AS menuno_10, d0_.kankou AS kankou_11, d0_.hatsubaibi AS hatsubaibi_12, d0_.newno AS newno_13, d0_.linkimage01 AS linkimage01_14, d0_.linkimage02 AS linkimage02_15, d0_.linkimage03 AS linkimage03_16, d0_.linkimage04 AS linkimage04_17, d0_.linkimage05 AS linkimage05_18, d0_.linkimage06 AS linkimage06_19, d0_.linkimage07 AS linkimage07_20, d0_.linkimage08 AS linkimage08_21, d0_.linkimage09 AS linkimage09_22, d0_.linkimage10 AS linkimage10_23, d0_.linkimage11 AS linkimage11_24, d0_.linkimage12 AS linkimage12_25, d0_.linkimage13 AS linkimage13_26, d0_.linkimage14 AS linkimage14_27, d0_.linkimage15 AS linkimage15_28, d0_.linkimage16 AS linkimage16_29, d0_.linkimage17 AS linkimage17_30, d0_.linkimage18 AS linkimage18_31, d0_.linkimage19 AS linkimage19_32, d0_.linkimage20 AS linkimage20_33, d0_.linkimage21 AS linkimage21_34, d0_.linkimage22 AS linkimage22_35, d0_.linkimage23 AS linkimage23_36, d0_.linkimage24 AS linkimage24_37, d0_.linkimage25 AS linkimage25_38, d0_.linkimage26 AS linkimage26_39, d0_.linkimage27 AS linkimage27_40, d0_.linkimage28 AS linkimage28_41, d0_.linkimage29 AS linkimage29_42, d0_.linkimage30 AS linkimage30_43, d0_.link01 AS link01_44, d0_.link02 AS link02_45, d0_.link03 AS link03_46, d0_.link04 AS link04_47, d0_.link05 AS link05_48, d0_.link06 AS link06_49, d0_.link07 AS link07_50, d0_.link08 AS link08_51, d0_.link09 AS link09_52, d0_.link10 AS link10_53, d0_.link11 AS link11_54, d0_.link12 AS link12_55, d0_.link13 AS link13_56, d0_.link14 AS link14_57, d0_.link15 AS link15_58, d0_.link16 AS link16_59, d0_.link17 AS link17_60, d0_.link18 AS link18_61, d0_.link19 AS link19_62, d0_.link20 AS link20_63, d0_.link21 AS link21_64, d0_.link22 AS link22_65, d0_.link23 AS link23_66, d0_.link24 AS link24_67, d0_.link25 AS link25_68, d0_.link26 AS link26_69, d0_.link27 AS link27_70, d0_.link28 AS link28_71, d0_.link29 AS link29_72, d0_.link30 AS link30_73, d0_.blank01 AS blank01_74, d0_.blank02 AS blank02_75, d0_.blank03 AS blank03_76, d0_.blank04 AS blank04_77, d0_.blank05 AS blank05_78, d0_.blank06 AS blank06_79, d0_.blank07 AS blank07_80, d0_.blank08 AS blank08_81, d0_.blank09 AS blank09_82, d0_.blank10 AS blank10_83, d0_.blank11 AS blank11_84, d0_.blank12 AS blank12_85, d0_.blank13 AS blank13_86, d0_.blank14 AS blank14_87, d0_.blank15 AS blank15_88, d0_.blank16 AS blank16_89, d0_.blank17 AS blank17_90, d0_.blank18 AS blank18_91, d0_.blank19 AS blank19_92, d0_.blank20 AS blank20_93, d0_.blank21 AS blank21_94, d0_.blank22 AS blank22_95, d0_.blank23 AS blank23_96, d0_.blank24 AS blank24_97, d0_.blank25 AS blank25_98, d0_.blank26 AS blank26_99, d0_.blank27 AS blank27_100, d0_.blank28 AS blank28_101, d0_.blank29 AS blank29_102, d0_.blank30 AS blank30_103, d0_.newcate AS newcate_104, d0_.dspfl AS dspfl_105, d0_.discriminator_type AS discriminator_type_106, d0_.parent_category_id AS parent_category_id_107, d0_.creator_id AS creator_id_108 FROM dtb_category d0_ WHERE (d0_.id = ?) AND d0_.discriminator_type IN ('category')
Parameters: 
  0 of 0   
[▼
  149
]
View formatted query    View runnable query    Explain query
11 0.86 ms 
SELECT count(DISTINCT d0_.id) AS sclr_0 FROM dtb_product d0_ INNER JOIN dtb_product_class d1_ ON d0_.id = d1_.product_id AND d1_.discriminator_type IN ('productclass') INNER JOIN dtb_product_category d2_ ON d0_.id = d2_.product_id AND d2_.discriminator_type IN ('productcategory') INNER JOIN dtb_category d3_ ON d2_.category_id = d3_.id AND d3_.discriminator_type IN ('category') WHERE (d0_.product_status_id = 1 AND d2_.category_id = ?) AND d0_.discriminator_type IN ('product')
Parameters: 
  0 of 0   
[▼
  149
]
View formatted query    View runnable query    Explain query
12 0.55 ms 
SELECT DISTINCT d0_.id AS id_0, d0_.orderdate AS orderdate_1, d0_.id AS id_2 FROM dtb_product d0_ INNER JOIN dtb_product_class d1_ ON d0_.id = d1_.product_id AND d1_.discriminator_type IN ('productclass') INNER JOIN dtb_product_category d2_ ON d0_.id = d2_.product_id AND d2_.discriminator_type IN ('productcategory') INNER JOIN dtb_category d3_ ON d2_.category_id = d3_.id AND d3_.discriminator_type IN ('category') WHERE (d0_.product_status_id = 1 AND d2_.category_id = ?) AND d0_.discriminator_type IN ('product') ORDER BY d0_.orderdate DESC, d0_.id DESC LIMIT 20
Parameters: 
  0 of 0   
[▼
  149
]
View formatted query    View runnable query    Explain query
13 0.84 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_.create_date AS create_date_7, d0_.update_date AS update_date_8, d0_.comment1 AS comment1_9, d0_.linkurl AS linkurl_10, d0_.bookcart AS bookcart_11, d0_.viewsw AS viewsw_12, d0_.recommendno AS recommendno_13, d0_.teikaref AS teikaref_14, d0_.orderdate AS orderdate_15, d0_.enddate AS enddate_16, d0_.hatsubaibi AS hatsubaibi_17, d0_.entrydate AS entrydate_18, d0_.jissize AS jissize_19, d0_.isbn AS isbn_20, d0_.amazon AS amazon_21, d0_.importfl AS importfl_22, d0_.old_create_date AS old_create_date_23, d0_.old_update_date AS old_update_date_24, d0_.free_description_about_quantity AS free_description_about_quantity_25, d0_.free_description_about_selling_price AS free_description_about_selling_price_26, d0_.free_description_of_payment_delivery AS free_description_of_payment_delivery_27, d0_.discriminator_type AS discriminator_type_28, d0_.creator_id AS creator_id_29, d0_.product_status_id AS product_status_id_30 FROM dtb_product d0_ INNER JOIN dtb_product_class d1_ ON d0_.id = d1_.product_id AND d1_.discriminator_type IN ('productclass') INNER JOIN dtb_product_category d2_ ON d0_.id = d2_.product_id AND d2_.discriminator_type IN ('productcategory') INNER JOIN dtb_category d3_ ON d2_.category_id = d3_.id AND d3_.discriminator_type IN ('category') WHERE (d0_.product_status_id = 1 AND d2_.category_id = ? AND d0_.id IN (?, ?, ?, ?)) AND d0_.discriminator_type IN ('product') ORDER BY d0_.orderdate DESC, d0_.id DESC
Parameters: 
  0 of 0   
[▼
  149
  12205
  11475
  6610
  6637
]
View formatted query    View runnable query    Explain query
14 0.57 ms 
SELECT d0_.id AS id_0, d0_.create_date AS create_date_1, d0_.update_date AS update_date_2, d0_.title AS title_3, d0_.cateid AS cateid_4, d0_.image01 AS image01_5, d0_.image02 AS image02_6, d0_.image03 AS image03_7, d0_.image04 AS image04_8, d0_.image05 AS image05_9, d0_.image06 AS image06_10, d0_.image07 AS image07_11, d0_.image08 AS image08_12, d0_.image09 AS image09_13, d0_.image10 AS image10_14, d0_.image11 AS image11_15, d0_.image12 AS image12_16, d0_.image13 AS image13_17, d0_.image14 AS image14_18, d0_.image15 AS image15_19, d0_.image16 AS image16_20, d0_.image17 AS image17_21, d0_.image18 AS image18_22, d0_.image19 AS image19_23, d0_.image20 AS image20_24, d0_.image21 AS image21_25, d0_.image22 AS image22_26, d0_.image23 AS image23_27, d0_.image24 AS image24_28, d0_.image25 AS image25_29, d0_.image26 AS image26_30, d0_.image27 AS image27_31, d0_.image28 AS image28_32, d0_.image29 AS image29_33, d0_.image30 AS image30_34, d0_.link01 AS link01_35, d0_.link02 AS link02_36, d0_.link03 AS link03_37, d0_.link04 AS link04_38, d0_.link05 AS link05_39, d0_.link06 AS link06_40, d0_.link07 AS link07_41, d0_.link08 AS link08_42, d0_.link09 AS link09_43, d0_.link10 AS link10_44, d0_.link11 AS link11_45, d0_.link12 AS link12_46, d0_.link13 AS link13_47, d0_.link14 AS link14_48, d0_.link15 AS link15_49, d0_.link16 AS link16_50, d0_.link17 AS link17_51, d0_.link18 AS link18_52, d0_.link19 AS link19_53, d0_.link20 AS link20_54, d0_.link21 AS link21_55, d0_.link22 AS link22_56, d0_.link23 AS link23_57, d0_.link24 AS link24_58, d0_.link25 AS link25_59, d0_.link26 AS link26_60, d0_.link27 AS link27_61, d0_.link28 AS link28_62, d0_.link29 AS link29_63, d0_.link30 AS link30_64, d0_.blank01 AS blank01_65, d0_.blank02 AS blank02_66, d0_.blank03 AS blank03_67, d0_.blank04 AS blank04_68, d0_.blank05 AS blank05_69, d0_.blank06 AS blank06_70, d0_.blank07 AS blank07_71, d0_.blank08 AS blank08_72, d0_.blank09 AS blank09_73, d0_.blank10 AS blank10_74, d0_.blank11 AS blank11_75, d0_.blank12 AS blank12_76, d0_.blank13 AS blank13_77, d0_.blank14 AS blank14_78, d0_.blank15 AS blank15_79, d0_.blank16 AS blank16_80, d0_.blank17 AS blank17_81, d0_.blank18 AS blank18_82, d0_.blank19 AS blank19_83, d0_.blank20 AS blank20_84, d0_.blank21 AS blank21_85, d0_.blank22 AS blank22_86, d0_.blank23 AS blank23_87, d0_.blank24 AS blank24_88, d0_.blank25 AS blank25_89, d0_.blank26 AS blank26_90, d0_.blank27 AS blank27_91, d0_.blank28 AS blank28_92, d0_.blank29 AS blank29_93, d0_.blank30 AS blank30_94, d0_.imagesp01 AS imagesp01_95, d0_.imagesp02 AS imagesp02_96, d0_.imagesp03 AS imagesp03_97, d0_.imagesp04 AS imagesp04_98, d0_.imagesp05 AS imagesp05_99, d0_.imagesp06 AS imagesp06_100, d0_.imagesp07 AS imagesp07_101, d0_.imagesp08 AS imagesp08_102, d0_.imagesp09 AS imagesp09_103, d0_.imagesp10 AS imagesp10_104, d0_.imagesp11 AS imagesp11_105, d0_.imagesp12 AS imagesp12_106, d0_.imagesp13 AS imagesp13_107, d0_.imagesp14 AS imagesp14_108, d0_.imagesp15 AS imagesp15_109, d0_.imagesp16 AS imagesp16_110, d0_.imagesp17 AS imagesp17_111, d0_.imagesp18 AS imagesp18_112, d0_.imagesp19 AS imagesp19_113, d0_.imagesp20 AS imagesp20_114, d0_.imagesp21 AS imagesp21_115, d0_.imagesp22 AS imagesp22_116, d0_.imagesp23 AS imagesp23_117, d0_.imagesp24 AS imagesp24_118, d0_.imagesp25 AS imagesp25_119, d0_.imagesp26 AS imagesp26_120, d0_.imagesp27 AS imagesp27_121, d0_.imagesp28 AS imagesp28_122, d0_.imagesp29 AS imagesp29_123, d0_.imagesp30 AS imagesp30_124, d0_.discriminator_type AS discriminator_type_125, d0_.creator_id AS creator_id_126 FROM dtb_visual d0_ WHERE (d0_.cateid = ?) AND d0_.discriminator_type IN ('visual') ORDER BY d0_.id ASC
Parameters: 
  0 of 0   
[▼
  "149"
]
View formatted query    View runnable query    Explain query
15 0.23 ms 
SELECT t0.product_id AS product_id_1, t0.category_id AS category_id_2, t0.importfl AS importfl_3, t0.product_id AS product_id_4, t0.category_id AS category_id_5, t0.discriminator_type FROM dtb_product_category t0 WHERE t0.product_id = ? AND t0.discriminator_type IN ('productcategory')
Parameters: 
  0 of 0   
[▼
  12205
]
View formatted query    View runnable query    Explain query
16 0.28 ms 
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.sort_no AS sort_no_3, t0.create_date AS create_date_4, t0.importfl AS importfl_5, t0.product_id AS product_id_6, t0.creator_id AS creator_id_7, t0.discriminator_type FROM dtb_product_image t0 WHERE t0.product_id = ? AND t0.discriminator_type IN ('productimage') ORDER BY t0.sort_no ASC
Parameters: 
  0 of 0   
[▼
  12205
]
View formatted query    View runnable query    Explain query
17 0.29 ms 
SELECT t0.id AS id_1, t0.product_code AS product_code_2, t0.stock AS stock_3, t0.stock_unlimited AS stock_unlimited_4, t0.sale_limit AS sale_limit_5, t0.price01 AS price01_6, t0.price02 AS price02_7, t0.delivery_fee AS delivery_fee_8, t0.visible AS visible_9, t0.create_date AS create_date_10, t0.update_date AS update_date_11, t0.currency_code AS currency_code_12, t0.point_rate AS point_rate_13, t0.importfl AS importfl_14, t0.old_create_date AS old_create_date_15, t0.old_update_date AS old_update_date_16, t0.product_id AS product_id_17, t0.sale_type_id AS sale_type_id_18, t0.class_category_id1 AS class_category_id1_19, t0.class_category_id2 AS class_category_id2_20, t0.delivery_duration_id AS delivery_duration_id_21, t0.creator_id AS creator_id_22, t0.regular_discount_id AS regular_discount_id_23, t0.discriminator_type FROM dtb_product_class t0 WHERE t0.product_id = ? AND t0.discriminator_type IN ('productclass')
Parameters: 
  0 of 0   
[▼
  12205
]
View formatted query    View runnable query    Explain query
18 0.20 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.importfl AS importfl_5, t0.product_class_id AS product_class_id_6, t0.creator_id AS creator_id_7, t0.discriminator_type FROM dtb_product_stock t0 WHERE t0.product_class_id = ? AND t0.discriminator_type IN ('productstock')
Parameters: 
  0 of 0   
[▼
  12213
]
View formatted query    View runnable query    Explain query
19 0.21 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: 
  0 of 0   
[▼
  12213
]
View formatted query    View runnable query    Explain query
20 0.28 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: 
  0 of 0   
[▼
  "2025-06-07 14:32:15"
]
View formatted query    View runnable query    Explain query
21 0.08 ms 
SELECT t0.product_id AS product_id_1, t0.category_id AS category_id_2, t0.importfl AS importfl_3, t0.product_id AS product_id_4, t0.category_id AS category_id_5, t0.discriminator_type FROM dtb_product_category t0 WHERE t0.product_id = ? AND t0.discriminator_type IN ('productcategory')
Parameters: 
  0 of 0   
[▼
  11475
]
View formatted query    View runnable query    Explain query
22 0.12 ms 
SELECT t0.id AS id_1, t0.category_name AS category_name_2, t0.hierarchy AS hierarchy_3, t0.sort_no AS sort_no_4, t0.create_date AS create_date_5, t0.update_date AS update_date_6, t0.url AS url_7, t0.title_image_path AS title_image_path_8, t0.teikikoudoku1 AS teikikoudoku1_9, t0.teikikoudoku2 AS teikikoudoku2_10, t0.menuno AS menuno_11, t0.kankou AS kankou_12, t0.hatsubaibi AS hatsubaibi_13, t0.newno AS newno_14, t0.linkimage01 AS linkimage01_15, t0.linkimage02 AS linkimage02_16, t0.linkimage03 AS linkimage03_17, t0.linkimage04 AS linkimage04_18, t0.linkimage05 AS linkimage05_19, t0.linkimage06 AS linkimage06_20, t0.linkimage07 AS linkimage07_21, t0.linkimage08 AS linkimage08_22, t0.linkimage09 AS linkimage09_23, t0.linkimage10 AS linkimage10_24, t0.linkimage11 AS linkimage11_25, t0.linkimage12 AS linkimage12_26, t0.linkimage13 AS linkimage13_27, t0.linkimage14 AS linkimage14_28, t0.linkimage15 AS linkimage15_29, t0.linkimage16 AS linkimage16_30, t0.linkimage17 AS linkimage17_31, t0.linkimage18 AS linkimage18_32, t0.linkimage19 AS linkimage19_33, t0.linkimage20 AS linkimage20_34, t0.linkimage21 AS linkimage21_35, t0.linkimage22 AS linkimage22_36, t0.linkimage23 AS linkimage23_37, t0.linkimage24 AS linkimage24_38, t0.linkimage25 AS linkimage25_39, t0.linkimage26 AS linkimage26_40, t0.linkimage27 AS linkimage27_41, t0.linkimage28 AS linkimage28_42, t0.linkimage29 AS linkimage29_43, t0.linkimage30 AS linkimage30_44, t0.link01 AS link01_45, t0.link02 AS link02_46, t0.link03 AS link03_47, t0.link04 AS link04_48, t0.link05 AS link05_49, t0.link06 AS link06_50, t0.link07 AS link07_51, t0.link08 AS link08_52, t0.link09 AS link09_53, t0.link10 AS link10_54, t0.link11 AS link11_55, t0.link12 AS link12_56, t0.link13 AS link13_57, t0.link14 AS link14_58, t0.link15 AS link15_59, t0.link16 AS link16_60, t0.link17 AS link17_61, t0.link18 AS link18_62, t0.link19 AS link19_63, t0.link20 AS link20_64, t0.link21 AS link21_65, t0.link22 AS link22_66, t0.link23 AS link23_67, t0.link24 AS link24_68, t0.link25 AS link25_69, t0.link26 AS link26_70, t0.link27 AS link27_71, t0.link28 AS link28_72, t0.link29 AS link29_73, t0.link30 AS link30_74, t0.blank01 AS blank01_75, t0.blank02 AS blank02_76, t0.blank03 AS blank03_77, t0.blank04 AS blank04_78, t0.blank05 AS blank05_79, t0.blank06 AS blank06_80, t0.blank07 AS blank07_81, t0.blank08 AS blank08_82, t0.blank09 AS blank09_83, t0.blank10 AS blank10_84, t0.blank11 AS blank11_85, t0.blank12 AS blank12_86, t0.blank13 AS blank13_87, t0.blank14 AS blank14_88, t0.blank15 AS blank15_89, t0.blank16 AS blank16_90, t0.blank17 AS blank17_91, t0.blank18 AS blank18_92, t0.blank19 AS blank19_93, t0.blank20 AS blank20_94, t0.blank21 AS blank21_95, t0.blank22 AS blank22_96, t0.blank23 AS blank23_97, t0.blank24 AS blank24_98, t0.blank25 AS blank25_99, t0.blank26 AS blank26_100, t0.blank27 AS blank27_101, t0.blank28 AS blank28_102, t0.blank29 AS blank29_103, t0.blank30 AS blank30_104, t0.newcate AS newcate_105, t0.dspfl AS dspfl_106, t0.parent_category_id AS parent_category_id_107, t0.creator_id AS creator_id_108, t0.discriminator_type FROM dtb_category t0 WHERE t0.id = ? AND t0.discriminator_type IN ('category')
Parameters: 
  0 of 0   
[▼
  140
]
View formatted query    View runnable query    Explain query
23 0.07 ms 
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.sort_no AS sort_no_3, t0.create_date AS create_date_4, t0.importfl AS importfl_5, t0.product_id AS product_id_6, t0.creator_id AS creator_id_7, t0.discriminator_type FROM dtb_product_image t0 WHERE t0.product_id = ? AND t0.discriminator_type IN ('productimage') ORDER BY t0.sort_no ASC
Parameters: 
  0 of 0   
[▼
  11475
]
View formatted query    View runnable query    Explain query
24 0.07 ms 
SELECT t0.id AS id_1, t0.product_code AS product_code_2, t0.stock AS stock_3, t0.stock_unlimited AS stock_unlimited_4, t0.sale_limit AS sale_limit_5, t0.price01 AS price01_6, t0.price02 AS price02_7, t0.delivery_fee AS delivery_fee_8, t0.visible AS visible_9, t0.create_date AS create_date_10, t0.update_date AS update_date_11, t0.currency_code AS currency_code_12, t0.point_rate AS point_rate_13, t0.importfl AS importfl_14, t0.old_create_date AS old_create_date_15, t0.old_update_date AS old_update_date_16, t0.product_id AS product_id_17, t0.sale_type_id AS sale_type_id_18, t0.class_category_id1 AS class_category_id1_19, t0.class_category_id2 AS class_category_id2_20, t0.delivery_duration_id AS delivery_duration_id_21, t0.creator_id AS creator_id_22, t0.regular_discount_id AS regular_discount_id_23, t0.discriminator_type FROM dtb_product_class t0 WHERE t0.product_id = ? AND t0.discriminator_type IN ('productclass')
Parameters: 
  0 of 0   
[▼
  11475
]
View formatted query    View runnable query    Explain query
25 0.06 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.importfl AS importfl_5, t0.product_class_id AS product_class_id_6, t0.creator_id AS creator_id_7, t0.discriminator_type FROM dtb_product_stock t0 WHERE t0.product_class_id = ? AND t0.discriminator_type IN ('productstock')
Parameters: 
  0 of 0   
[▼
  11483
]
View formatted query    View runnable query    Explain query
26 0.06 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: 
  0 of 0   
[▼
  11483
]
View formatted query    View runnable query    Explain query
27 0.19 ms 
SELECT t0.product_id AS product_id_1, t0.category_id AS category_id_2, t0.importfl AS importfl_3, t0.product_id AS product_id_4, t0.category_id AS category_id_5, t0.discriminator_type FROM dtb_product_category t0 WHERE t0.product_id = ? AND t0.discriminator_type IN ('productcategory')
Parameters: 
  0 of 0   
[▼
  6610
]
View formatted query    View runnable query    Explain query
28 0.20 ms 
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.sort_no AS sort_no_3, t0.create_date AS create_date_4, t0.importfl AS importfl_5, t0.product_id AS product_id_6, t0.creator_id AS creator_id_7, t0.discriminator_type FROM dtb_product_image t0 WHERE t0.product_id = ? AND t0.discriminator_type IN ('productimage') ORDER BY t0.sort_no ASC
Parameters: 
  0 of 0   
[▼
  6610
]
View formatted query    View runnable query    Explain query
29 0.21 ms 
SELECT t0.id AS id_1, t0.product_code AS product_code_2, t0.stock AS stock_3, t0.stock_unlimited AS stock_unlimited_4, t0.sale_limit AS sale_limit_5, t0.price01 AS price01_6, t0.price02 AS price02_7, t0.delivery_fee AS delivery_fee_8, t0.visible AS visible_9, t0.create_date AS create_date_10, t0.update_date AS update_date_11, t0.currency_code AS currency_code_12, t0.point_rate AS point_rate_13, t0.importfl AS importfl_14, t0.old_create_date AS old_create_date_15, t0.old_update_date AS old_update_date_16, t0.product_id AS product_id_17, t0.sale_type_id AS sale_type_id_18, t0.class_category_id1 AS class_category_id1_19, t0.class_category_id2 AS class_category_id2_20, t0.delivery_duration_id AS delivery_duration_id_21, t0.creator_id AS creator_id_22, t0.regular_discount_id AS regular_discount_id_23, t0.discriminator_type FROM dtb_product_class t0 WHERE t0.product_id = ? AND t0.discriminator_type IN ('productclass')
Parameters: 
  0 of 0   
[▼
  6610
]
View formatted query    View runnable query    Explain query
30 0.17 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.importfl AS importfl_5, t0.product_class_id AS product_class_id_6, t0.creator_id AS creator_id_7, t0.discriminator_type FROM dtb_product_stock t0 WHERE t0.product_class_id = ? AND t0.discriminator_type IN ('productstock')
Parameters: 
  0 of 0   
[▼
  6618
]
View formatted query    View runnable query    Explain query
31 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: 
  0 of 0   
[▼
  6618
]
View formatted query    View runnable query    Explain query
32 0.14 ms 
SELECT t0.product_id AS product_id_1, t0.category_id AS category_id_2, t0.importfl AS importfl_3, t0.product_id AS product_id_4, t0.category_id AS category_id_5, t0.discriminator_type FROM dtb_product_category t0 WHERE t0.product_id = ? AND t0.discriminator_type IN ('productcategory')
Parameters: 
  0 of 0   
[▼
  6637
]
View formatted query    View runnable query    Explain query
33 0.20 ms 
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.sort_no AS sort_no_3, t0.create_date AS create_date_4, t0.importfl AS importfl_5, t0.product_id AS product_id_6, t0.creator_id AS creator_id_7, t0.discriminator_type FROM dtb_product_image t0 WHERE t0.product_id = ? AND t0.discriminator_type IN ('productimage') ORDER BY t0.sort_no ASC
Parameters: 
  0 of 0   
[▼
  6637
]
View formatted query    View runnable query    Explain query
34 0.20 ms 
SELECT t0.id AS id_1, t0.product_code AS product_code_2, t0.stock AS stock_3, t0.stock_unlimited AS stock_unlimited_4, t0.sale_limit AS sale_limit_5, t0.price01 AS price01_6, t0.price02 AS price02_7, t0.delivery_fee AS delivery_fee_8, t0.visible AS visible_9, t0.create_date AS create_date_10, t0.update_date AS update_date_11, t0.currency_code AS currency_code_12, t0.point_rate AS point_rate_13, t0.importfl AS importfl_14, t0.old_create_date AS old_create_date_15, t0.old_update_date AS old_update_date_16, t0.product_id AS product_id_17, t0.sale_type_id AS sale_type_id_18, t0.class_category_id1 AS class_category_id1_19, t0.class_category_id2 AS class_category_id2_20, t0.delivery_duration_id AS delivery_duration_id_21, t0.creator_id AS creator_id_22, t0.regular_discount_id AS regular_discount_id_23, t0.discriminator_type FROM dtb_product_class t0 WHERE t0.product_id = ? AND t0.discriminator_type IN ('productclass')
Parameters: 
  0 of 0   
[▼
  6637
]
View formatted query    View runnable query    Explain query
35 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.importfl AS importfl_5, t0.product_class_id AS product_class_id_6, t0.creator_id AS creator_id_7, t0.discriminator_type FROM dtb_product_stock t0 WHERE t0.product_class_id = ? AND t0.discriminator_type IN ('productstock')
Parameters: 
  0 of 0   
[▼
  6645
]
View formatted query    View runnable query    Explain query
36 0.17 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: 
  0 of 0   
[▼
  6645
]
View formatted query    View runnable query    Explain query
37 0.11 ms 
SELECT t0.id AS id_1, t0.category_name AS category_name_2, t0.hierarchy AS hierarchy_3, t0.sort_no AS sort_no_4, t0.create_date AS create_date_5, t0.update_date AS update_date_6, t0.url AS url_7, t0.title_image_path AS title_image_path_8, t0.teikikoudoku1 AS teikikoudoku1_9, t0.teikikoudoku2 AS teikikoudoku2_10, t0.menuno AS menuno_11, t0.kankou AS kankou_12, t0.hatsubaibi AS hatsubaibi_13, t0.newno AS newno_14, t0.linkimage01 AS linkimage01_15, t0.linkimage02 AS linkimage02_16, t0.linkimage03 AS linkimage03_17, t0.linkimage04 AS linkimage04_18, t0.linkimage05 AS linkimage05_19, t0.linkimage06 AS linkimage06_20, t0.linkimage07 AS linkimage07_21, t0.linkimage08 AS linkimage08_22, t0.linkimage09 AS linkimage09_23, t0.linkimage10 AS linkimage10_24, t0.linkimage11 AS linkimage11_25, t0.linkimage12 AS linkimage12_26, t0.linkimage13 AS linkimage13_27, t0.linkimage14 AS linkimage14_28, t0.linkimage15 AS linkimage15_29, t0.linkimage16 AS linkimage16_30, t0.linkimage17 AS linkimage17_31, t0.linkimage18 AS linkimage18_32, t0.linkimage19 AS linkimage19_33, t0.linkimage20 AS linkimage20_34, t0.linkimage21 AS linkimage21_35, t0.linkimage22 AS linkimage22_36, t0.linkimage23 AS linkimage23_37, t0.linkimage24 AS linkimage24_38, t0.linkimage25 AS linkimage25_39, t0.linkimage26 AS linkimage26_40, t0.linkimage27 AS linkimage27_41, t0.linkimage28 AS linkimage28_42, t0.linkimage29 AS linkimage29_43, t0.linkimage30 AS linkimage30_44, t0.link01 AS link01_45, t0.link02 AS link02_46, t0.link03 AS link03_47, t0.link04 AS link04_48, t0.link05 AS link05_49, t0.link06 AS link06_50, t0.link07 AS link07_51, t0.link08 AS link08_52, t0.link09 AS link09_53, t0.link10 AS link10_54, t0.link11 AS link11_55, t0.link12 AS link12_56, t0.link13 AS link13_57, t0.link14 AS link14_58, t0.link15 AS link15_59, t0.link16 AS link16_60, t0.link17 AS link17_61, t0.link18 AS link18_62, t0.link19 AS link19_63, t0.link20 AS link20_64, t0.link21 AS link21_65, t0.link22 AS link22_66, t0.link23 AS link23_67, t0.link24 AS link24_68, t0.link25 AS link25_69, t0.link26 AS link26_70, t0.link27 AS link27_71, t0.link28 AS link28_72, t0.link29 AS link29_73, t0.link30 AS link30_74, t0.blank01 AS blank01_75, t0.blank02 AS blank02_76, t0.blank03 AS blank03_77, t0.blank04 AS blank04_78, t0.blank05 AS blank05_79, t0.blank06 AS blank06_80, t0.blank07 AS blank07_81, t0.blank08 AS blank08_82, t0.blank09 AS blank09_83, t0.blank10 AS blank10_84, t0.blank11 AS blank11_85, t0.blank12 AS blank12_86, t0.blank13 AS blank13_87, t0.blank14 AS blank14_88, t0.blank15 AS blank15_89, t0.blank16 AS blank16_90, t0.blank17 AS blank17_91, t0.blank18 AS blank18_92, t0.blank19 AS blank19_93, t0.blank20 AS blank20_94, t0.blank21 AS blank21_95, t0.blank22 AS blank22_96, t0.blank23 AS blank23_97, t0.blank24 AS blank24_98, t0.blank25 AS blank25_99, t0.blank26 AS blank26_100, t0.blank27 AS blank27_101, t0.blank28 AS blank28_102, t0.blank29 AS blank29_103, t0.blank30 AS blank30_104, t0.newcate AS newcate_105, t0.dspfl AS dspfl_106, t0.parent_category_id AS parent_category_id_107, t0.creator_id AS creator_id_108, t0.discriminator_type FROM dtb_category t0 WHERE t0.parent_category_id = ? AND t0.discriminator_type IN ('category') ORDER BY t0.sort_no DESC
Parameters: 
  0 of 0   
[▼
  15
]
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\Product No errors.
Eccube\Entity\BaseInfo 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\AbstractMasterEntity No errors.
Eccube\Entity\Master\DeviceType No errors.
Eccube\Entity\AuthorityRole No errors.
Eccube\Entity\Layout No errors.
Eccube\Entity\Order No errors.
Eccube\Entity\Customer No errors.
Eccube\Entity\Master\Country No errors.
Eccube\Entity\Master\Pref No errors.
Customize\Entity\Visual No errors.
Eccube\Entity\Category No errors.
Eccube\Entity\Delivery No errors.
Eccube\Entity\CustomerFavoriteProduct No errors.
Eccube\Entity\Master\ProductListMax No errors.
Plugin\EccubePaymentLite42\Entity\Config No errors.
Eccube\Entity\Member No errors.
Eccube\Entity\ProductCategory No errors.
Plugin\MailMagazine42\Entity\MailMagazineSendHistory No errors.
Eccube\Entity\ProductClass
  • The field Eccube\Entity\ProductClass#ProductClassRegularCycle is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Plugin\EccubePaymentLite42\Entity\ProductClassRegularCycle#ProductClass does not contain the required 'inversedBy="ProductClassRegularCycle"' attribute.
Eccube\Entity\Master\ProductStatus No errors.
Eccube\Entity\ProductImage No errors.
Eccube\Entity\ProductTag No errors.
Eccube\Entity\ProductStock No errors.
Eccube\Entity\TaxRule No errors.
Eccube\Entity\Master\SaleType No errors.
Eccube\Entity\ClassCategory No errors.
Eccube\Entity\DeliveryDuration No errors.
Plugin\EccubePaymentLite42\Entity\RegularDiscount No errors.
Eccube\Entity\Master\RoundingType No errors.
Plugin\EccubePaymentLite42\Entity\ProductClassRegularCycle No errors.