Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

147 Database Queries

22 Different statements

273.22 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
130.68 ms (47.83%)	1	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 IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND d0_.discriminator_type IN ('product') GROUP BY d0_.id ORDER BY d0_.orderdate DESC, d0_.create_date DESC LIMIT 5 Parameters: [`35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 null null 83`] View formatted query View runnable query Explain query 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 IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ) AND d0_.discriminator_type IN ('product') GROUP BY d0_.id ORDER BY d0_.orderdate DESC, d0_.create_date DESC LIMIT 5 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 IN (35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, NULL, NULL, 83)) AND d0_.discriminator_type IN ('product') GROUP BY d0_.id ORDER BY d0_.orderdate DESC, d0_.create_date DESC LIMIT 5;
51.53 ms (18.86%)	1	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 IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND d0_.discriminator_type IN ('product') GROUP BY d0_.id ORDER BY d0_.orderdate DESC, d0_.create_date DESC LIMIT 5 Parameters: [`155 154 153 152 151 150 149 148 147 146 145 144 143 142 141 140 139 138 137 136 null 134 322 311 310 309 307 306 305 290 289 324 288 287 286 285 284 321 320 319 314 313 312 308 304 323 247 300 301 302 303`] View formatted query View runnable query Explain query 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 IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ) AND d0_.discriminator_type IN ('product') GROUP BY d0_.id ORDER BY d0_.orderdate DESC, d0_.create_date DESC LIMIT 5 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 IN (155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 142, 141, 140, 139, 138, 137, 136, NULL, 134, 322, 311, 310, 309, 307, 306, 305, 290, 289, 324, 288, 287, 286, 285, 284, 321, 320, 319, 314, 313, 312, 308, 304, 323, 247, 300, 301, 302, 303)) AND d0_.discriminator_type IN ('product') GROUP BY d0_.id ORDER BY d0_.orderdate DESC, d0_.create_date DESC LIMIT 5;
16.00 ms (5.85%)	30	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: [`12543`] View formatted query View runnable query Explain query 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 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 = 12543 AND t0.discriminator_type IN ('productimage') ORDER BY t0.sort_no ASC;
14.18 ms (5.19%)	30	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: [`12551`] View formatted query View runnable query Explain query 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') 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 = 12551 AND t0.discriminator_type IN ('productstock');
13.56 ms (4.96%)	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, 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, d1_.id AS id_106, d1_.category_name AS category_name_107, d1_.hierarchy AS hierarchy_108, d1_.sort_no AS sort_no_109, d1_.create_date AS create_date_110, d1_.update_date AS update_date_111, d1_.url AS url_112, d1_.title_image_path AS title_image_path_113, d1_.teikikoudoku1 AS teikikoudoku1_114, d1_.teikikoudoku2 AS teikikoudoku2_115, d1_.menuno AS menuno_116, d1_.kankou AS kankou_117, d1_.hatsubaibi AS hatsubaibi_118, d1_.newno AS newno_119, d1_.linkimage01 AS linkimage01_120, d1_.linkimage02 AS linkimage02_121, d1_.linkimage03 AS linkimage03_122, d1_.linkimage04 AS linkimage04_123, d1_.linkimage05 AS linkimage05_124, d1_.linkimage06 AS linkimage06_125, d1_.linkimage07 AS linkimage07_126, d1_.linkimage08 AS linkimage08_127, d1_.linkimage09 AS linkimage09_128, d1_.linkimage10 AS linkimage10_129, d1_.linkimage11 AS linkimage11_130, d1_.linkimage12 AS linkimage12_131, d1_.linkimage13 AS linkimage13_132, d1_.linkimage14 AS linkimage14_133, d1_.linkimage15 AS linkimage15_134, d1_.linkimage16 AS linkimage16_135, d1_.linkimage17 AS linkimage17_136, d1_.linkimage18 AS linkimage18_137, d1_.linkimage19 AS linkimage19_138, d1_.linkimage20 AS linkimage20_139, d1_.linkimage21 AS linkimage21_140, d1_.linkimage22 AS linkimage22_141, d1_.linkimage23 AS linkimage23_142, d1_.linkimage24 AS linkimage24_143, d1_.linkimage25 AS linkimage25_144, d1_.linkimage26 AS linkimage26_145, d1_.linkimage27 AS linkimage27_146, d1_.linkimage28 AS linkimage28_147, d1_.linkimage29 AS linkimage29_148, d1_.linkimage30 AS linkimage30_149, d1_.link01 AS link01_150, d1_.link02 AS link02_151, d1_.link03 AS link03_152, d1_.link04 AS link04_153, d1_.link05 AS link05_154, d1_.link06 AS link06_155, d1_.link07 AS link07_156, d1_.link08 AS link08_157, d1_.link09 AS link09_158, d1_.link10 AS link10_159, d1_.link11 AS link11_160, d1_.link12 AS link12_161, d1_.link13 AS link13_162, d1_.link14 AS link14_163, d1_.link15 AS link15_164, d1_.link16 AS link16_165, d1_.link17 AS link17_166, d1_.link18 AS link18_167, d1_.link19 AS link19_168, d1_.link20 AS link20_169, d1_.link21 AS link21_170, d1_.link22 AS link22_171, d1_.link23 AS link23_172, d1_.link24 AS link24_173, d1_.link25 AS link25_174, d1_.link26 AS link26_175, d1_.link27 AS link27_176, d1_.link28 AS link28_177, d1_.link29 AS link29_178, d1_.link30 AS link30_179, d1_.blank01 AS blank01_180, d1_.blank02 AS blank02_181, d1_.blank03 AS blank03_182, d1_.blank04 AS blank04_183, d1_.blank05 AS blank05_184, d1_.blank06 AS blank06_185, d1_.blank07 AS blank07_186, d1_.blank08 AS blank08_187, d1_.blank09 AS blank09_188, d1_.blank10 AS blank10_189, d1_.blank11 AS blank11_190, d1_.blank12 AS blank12_191, d1_.blank13 AS blank13_192, d1_.blank14 AS blank14_193, d1_.blank15 AS blank15_194, d1_.blank16 AS blank16_195, d1_.blank17 AS blank17_196, d1_.blank18 AS blank18_197, d1_.blank19 AS blank19_198, d1_.blank20 AS blank20_199, d1_.blank21 AS blank21_200, d1_.blank22 AS blank22_201, d1_.blank23 AS blank23_202, d1_.blank24 AS blank24_203, d1_.blank25 AS blank25_204, d1_.blank26 AS blank26_205, d1_.blank27 AS blank27_206, d1_.blank28 AS blank28_207, d1_.blank29 AS blank29_208, d1_.blank30 AS blank30_209, d1_.newcate AS newcate_210, d1_.dspfl AS dspfl_211, d2_.id AS id_212, d2_.category_name AS category_name_213, d2_.hierarchy AS hierarchy_214, d2_.sort_no AS sort_no_215, d2_.create_date AS create_date_216, d2_.update_date AS update_date_217, d2_.url AS url_218, d2_.title_image_path AS title_image_path_219, d2_.teikikoudoku1 AS teikikoudoku1_220, d2_.teikikoudoku2 AS teikikoudoku2_221, d2_.menuno AS menuno_222, d2_.kankou AS kankou_223, d2_.hatsubaibi AS hatsubaibi_224, d2_.newno AS newno_225, d2_.linkimage01 AS linkimage01_226, d2_.linkimage02 AS linkimage02_227, d2_.linkimage03 AS linkimage03_228, d2_.linkimage04 AS linkimage04_229, d2_.linkimage05 AS linkimage05_230, d2_.linkimage06 AS linkimage06_231, d2_.linkimage07 AS linkimage07_232, d2_.linkimage08 AS linkimage08_233, d2_.linkimage09 AS linkimage09_234, d2_.linkimage10 AS linkimage10_235, d2_.linkimage11 AS linkimage11_236, d2_.linkimage12 AS linkimage12_237, d2_.linkimage13 AS linkimage13_238, d2_.linkimage14 AS linkimage14_239, d2_.linkimage15 AS linkimage15_240, d2_.linkimage16 AS linkimage16_241, d2_.linkimage17 AS linkimage17_242, d2_.linkimage18 AS linkimage18_243, d2_.linkimage19 AS linkimage19_244, d2_.linkimage20 AS linkimage20_245, d2_.linkimage21 AS linkimage21_246, d2_.linkimage22 AS linkimage22_247, d2_.linkimage23 AS linkimage23_248, d2_.linkimage24 AS linkimage24_249, d2_.linkimage25 AS linkimage25_250, d2_.linkimage26 AS linkimage26_251, d2_.linkimage27 AS linkimage27_252, d2_.linkimage28 AS linkimage28_253, d2_.linkimage29 AS linkimage29_254, d2_.linkimage30 AS linkimage30_255, d2_.link01 AS link01_256, d2_.link02 AS link02_257, d2_.link03 AS link03_258, d2_.link04 AS link04_259, d2_.link05 AS link05_260, d2_.link06 AS link06_261, d2_.link07 AS link07_262, d2_.link08 AS link08_263, d2_.link09 AS link09_264, d2_.link10 AS link10_265, d2_.link11 AS link11_266, d2_.link12 AS link12_267, d2_.link13 AS link13_268, d2_.link14 AS link14_269, d2_.link15 AS link15_270, d2_.link16 AS link16_271, d2_.link17 AS link17_272, d2_.link18 AS link18_273, d2_.link19 AS link19_274, d2_.link20 AS link20_275, d2_.link21 AS link21_276, d2_.link22 AS link22_277, d2_.link23 AS link23_278, d2_.link24 AS link24_279, d2_.link25 AS link25_280, d2_.link26 AS link26_281, d2_.link27 AS link27_282, d2_.link28 AS link28_283, d2_.link29 AS link29_284, d2_.link30 AS link30_285, d2_.blank01 AS blank01_286, d2_.blank02 AS blank02_287, d2_.blank03 AS blank03_288, d2_.blank04 AS blank04_289, d2_.blank05 AS blank05_290, d2_.blank06 AS blank06_291, d2_.blank07 AS blank07_292, d2_.blank08 AS blank08_293, d2_.blank09 AS blank09_294, d2_.blank10 AS blank10_295, d2_.blank11 AS blank11_296, d2_.blank12 AS blank12_297, d2_.blank13 AS blank13_298, d2_.blank14 AS blank14_299, d2_.blank15 AS blank15_300, d2_.blank16 AS blank16_301, d2_.blank17 AS blank17_302, d2_.blank18 AS blank18_303, d2_.blank19 AS blank19_304, d2_.blank20 AS blank20_305, d2_.blank21 AS blank21_306, d2_.blank22 AS blank22_307, d2_.blank23 AS blank23_308, d2_.blank24 AS blank24_309, d2_.blank25 AS blank25_310, d2_.blank26 AS blank26_311, d2_.blank27 AS blank27_312, d2_.blank28 AS blank28_313, d2_.blank29 AS blank29_314, d2_.blank30 AS blank30_315, d2_.newcate AS newcate_316, d2_.dspfl AS dspfl_317, d3_.id AS id_318, d3_.category_name AS category_name_319, d3_.hierarchy AS hierarchy_320, d3_.sort_no AS sort_no_321, d3_.create_date AS create_date_322, d3_.update_date AS update_date_323, d3_.url AS url_324, d3_.title_image_path AS title_image_path_325, d3_.teikikoudoku1 AS teikikoudoku1_326, d3_.teikikoudoku2 AS teikikoudoku2_327, d3_.menuno AS menuno_328, d3_.kankou AS kankou_329, d3_.hatsubaibi AS hatsubaibi_330, d3_.newno AS newno_331, d3_.linkimage01 AS linkimage01_332, d3_.linkimage02 AS linkimage02_333, d3_.linkimage03 AS linkimage03_334, d3_.linkimage04 AS linkimage04_335, d3_.linkimage05 AS linkimage05_336, d3_.linkimage06 AS linkimage06_337, d3_.linkimage07 AS linkimage07_338, d3_.linkimage08 AS linkimage08_339, d3_.linkimage09 AS linkimage09_340, d3_.linkimage10 AS linkimage10_341, d3_.linkimage11 AS linkimage11_342, d3_.linkimage12 AS linkimage12_343, d3_.linkimage13 AS linkimage13_344, d3_.linkimage14 AS linkimage14_345, d3_.linkimage15 AS linkimage15_346, d3_.linkimage16 AS linkimage16_347, d3_.linkimage17 AS linkimage17_348, d3_.linkimage18 AS linkimage18_349, d3_.linkimage19 AS linkimage19_350, d3_.linkimage20 AS linkimage20_351, d3_.linkimage21 AS linkimage21_352, d3_.linkimage22 AS linkimage22_353, d3_.linkimage23 AS linkimage23_354, d3_.linkimage24 AS linkimage24_355, d3_.linkimage25 AS linkimage25_356, d3_.linkimage26 AS linkimage26_357, d3_.linkimage27 AS linkimage27_358, d3_.linkimage28 AS linkimage28_359, d3_.linkimage29 AS linkimage29_360, d3_.linkimage30 AS linkimage30_361, d3_.link01 AS link01_362, d3_.link02 AS link02_363, d3_.link03 AS link03_364, d3_.link04 AS link04_365, d3_.link05 AS link05_366, d3_.link06 AS link06_367, d3_.link07 AS link07_368, d3_.link08 AS link08_369, d3_.link09 AS link09_370, d3_.link10 AS link10_371, d3_.link11 AS link11_372, d3_.link12 AS link12_373, d3_.link13 AS link13_374, d3_.link14 AS link14_375, d3_.link15 AS link15_376, d3_.link16 AS link16_377, d3_.link17 AS link17_378, d3_.link18 AS link18_379, d3_.link19 AS link19_380, d3_.link20 AS link20_381, d3_.link21 AS link21_382, d3_.link22 AS link22_383, d3_.link23 AS link23_384, d3_.link24 AS link24_385, d3_.link25 AS link25_386, d3_.link26 AS link26_387, d3_.link27 AS link27_388, d3_.link28 AS link28_389, d3_.link29 AS link29_390, d3_.link30 AS link30_391, d3_.blank01 AS blank01_392, d3_.blank02 AS blank02_393, d3_.blank03 AS blank03_394, d3_.blank04 AS blank04_395, d3_.blank05 AS blank05_396, d3_.blank06 AS blank06_397, d3_.blank07 AS blank07_398, d3_.blank08 AS blank08_399, d3_.blank09 AS blank09_400, d3_.blank10 AS blank10_401, d3_.blank11 AS blank11_402, d3_.blank12 AS blank12_403, d3_.blank13 AS blank13_404, d3_.blank14 AS blank14_405, d3_.blank15 AS blank15_406, d3_.blank16 AS blank16_407, d3_.blank17 AS blank17_408, d3_.blank18 AS blank18_409, d3_.blank19 AS blank19_410, d3_.blank20 AS blank20_411, d3_.blank21 AS blank21_412, d3_.blank22 AS blank22_413, d3_.blank23 AS blank23_414, d3_.blank24 AS blank24_415, d3_.blank25 AS blank25_416, d3_.blank26 AS blank26_417, d3_.blank27 AS blank27_418, d3_.blank28 AS blank28_419, d3_.blank29 AS blank29_420, d3_.blank30 AS blank30_421, d3_.newcate AS newcate_422, d3_.dspfl AS dspfl_423, d4_.id AS id_424, d4_.category_name AS category_name_425, d4_.hierarchy AS hierarchy_426, d4_.sort_no AS sort_no_427, d4_.create_date AS create_date_428, d4_.update_date AS update_date_429, d4_.url AS url_430, d4_.title_image_path AS title_image_path_431, d4_.teikikoudoku1 AS teikikoudoku1_432, d4_.teikikoudoku2 AS teikikoudoku2_433, d4_.menuno AS menuno_434, d4_.kankou AS kankou_435, d4_.hatsubaibi AS hatsubaibi_436, d4_.newno AS newno_437, d4_.linkimage01 AS linkimage01_438, d4_.linkimage02 AS linkimage02_439, d4_.linkimage03 AS linkimage03_440, d4_.linkimage04 AS linkimage04_441, d4_.linkimage05 AS linkimage05_442, d4_.linkimage06 AS linkimage06_443, d4_.linkimage07 AS linkimage07_444, d4_.linkimage08 AS linkimage08_445, d4_.linkimage09 AS linkimage09_446, d4_.linkimage10 AS linkimage10_447, d4_.linkimage11 AS linkimage11_448, d4_.linkimage12 AS linkimage12_449, d4_.linkimage13 AS linkimage13_450, d4_.linkimage14 AS linkimage14_451, d4_.linkimage15 AS linkimage15_452, d4_.linkimage16 AS linkimage16_453, d4_.linkimage17 AS linkimage17_454, d4_.linkimage18 AS linkimage18_455, d4_.linkimage19 AS linkimage19_456, d4_.linkimage20 AS linkimage20_457, d4_.linkimage21 AS linkimage21_458, d4_.linkimage22 AS linkimage22_459, d4_.linkimage23 AS linkimage23_460, d4_.linkimage24 AS linkimage24_461, d4_.linkimage25 AS linkimage25_462, d4_.linkimage26 AS linkimage26_463, d4_.linkimage27 AS linkimage27_464, d4_.linkimage28 AS linkimage28_465, d4_.linkimage29 AS linkimage29_466, d4_.linkimage30 AS linkimage30_467, d4_.link01 AS link01_468, d4_.link02 AS link02_469, d4_.link03 AS link03_470, d4_.link04 AS link04_471, d4_.link05 AS link05_472, d4_.link06 AS link06_473, d4_.link07 AS link07_474, d4_.link08 AS link08_475, d4_.link09 AS link09_476, d4_.link10 AS link10_477, d4_.link11 AS link11_478, d4_.link12 AS link12_479, d4_.link13 AS link13_480, d4_.link14 AS link14_481, d4_.link15 AS link15_482, d4_.link16 AS link16_483, d4_.link17 AS link17_484, d4_.link18 AS link18_485, d4_.link19 AS link19_486, d4_.link20 AS link20_487, d4_.link21 AS link21_488, d4_.link22 AS link22_489, d4_.link23 AS link23_490, d4_.link24 AS link24_491, d4_.link25 AS link25_492, d4_.link26 AS link26_493, d4_.link27 AS link27_494, d4_.link28 AS link28_495, d4_.link29 AS link29_496, d4_.link30 AS link30_497, d4_.blank01 AS blank01_498, d4_.blank02 AS blank02_499, d4_.blank03 AS blank03_500, d4_.blank04 AS blank04_501, d4_.blank05 AS blank05_502, d4_.blank06 AS blank06_503, d4_.blank07 AS blank07_504, d4_.blank08 AS blank08_505, d4_.blank09 AS blank09_506, d4_.blank10 AS blank10_507, d4_.blank11 AS blank11_508, d4_.blank12 AS blank12_509, d4_.blank13 AS blank13_510, d4_.blank14 AS blank14_511, d4_.blank15 AS blank15_512, d4_.blank16 AS blank16_513, d4_.blank17 AS blank17_514, d4_.blank18 AS blank18_515, d4_.blank19 AS blank19_516, d4_.blank20 AS blank20_517, d4_.blank21 AS blank21_518, d4_.blank22 AS blank22_519, d4_.blank23 AS blank23_520, d4_.blank24 AS blank24_521, d4_.blank25 AS blank25_522, d4_.blank26 AS blank26_523, d4_.blank27 AS blank27_524, d4_.blank28 AS blank28_525, d4_.blank29 AS blank29_526, d4_.blank30 AS blank30_527, d4_.newcate AS newcate_528, d4_.dspfl AS dspfl_529, d0_.discriminator_type AS discriminator_type_530, d0_.parent_category_id AS parent_category_id_531, d0_.creator_id AS creator_id_532, d1_.discriminator_type AS discriminator_type_533, d1_.parent_category_id AS parent_category_id_534, d1_.creator_id AS creator_id_535, d2_.discriminator_type AS discriminator_type_536, d2_.parent_category_id AS parent_category_id_537, d2_.creator_id AS creator_id_538, d3_.discriminator_type AS discriminator_type_539, d3_.parent_category_id AS parent_category_id_540, d3_.creator_id AS creator_id_541, d4_.discriminator_type AS discriminator_type_542, d4_.parent_category_id AS parent_category_id_543, d4_.creator_id AS creator_id_544 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 ASC, d2_.sort_no ASC, d3_.sort_no ASC, d4_.sort_no ASC Parameters: [] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.category_name AS category_name_1, d0_.hierarchy AS hierarchy_2, d0_.sort_no AS sort_no_3, d0_.create_date AS create_date_4, d0_.update_date AS update_date_5, 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, d1_.id AS id_106, d1_.category_name AS category_name_107, d1_.hierarchy AS hierarchy_108, d1_.sort_no AS sort_no_109, d1_.create_date AS create_date_110, d1_.update_date AS update_date_111, d1_.url AS url_112, d1_.title_image_path AS title_image_path_113, d1_.teikikoudoku1 AS teikikoudoku1_114, d1_.teikikoudoku2 AS teikikoudoku2_115, d1_.menuno AS menuno_116, d1_.kankou AS kankou_117, d1_.hatsubaibi AS hatsubaibi_118, d1_.newno AS newno_119, d1_.linkimage01 AS linkimage01_120, d1_.linkimage02 AS linkimage02_121, d1_.linkimage03 AS linkimage03_122, d1_.linkimage04 AS linkimage04_123, d1_.linkimage05 AS linkimage05_124, d1_.linkimage06 AS linkimage06_125, d1_.linkimage07 AS linkimage07_126, d1_.linkimage08 AS linkimage08_127, d1_.linkimage09 AS linkimage09_128, d1_.linkimage10 AS linkimage10_129, d1_.linkimage11 AS linkimage11_130, d1_.linkimage12 AS linkimage12_131, d1_.linkimage13 AS linkimage13_132, d1_.linkimage14 AS linkimage14_133, d1_.linkimage15 AS linkimage15_134, d1_.linkimage16 AS linkimage16_135, d1_.linkimage17 AS linkimage17_136, d1_.linkimage18 AS linkimage18_137, d1_.linkimage19 AS linkimage19_138, d1_.linkimage20 AS linkimage20_139, d1_.linkimage21 AS linkimage21_140, d1_.linkimage22 AS linkimage22_141, d1_.linkimage23 AS linkimage23_142, d1_.linkimage24 AS linkimage24_143, d1_.linkimage25 AS linkimage25_144, d1_.linkimage26 AS linkimage26_145, d1_.linkimage27 AS linkimage27_146, d1_.linkimage28 AS linkimage28_147, d1_.linkimage29 AS linkimage29_148, d1_.linkimage30 AS linkimage30_149, d1_.link01 AS link01_150, d1_.link02 AS link02_151, d1_.link03 AS link03_152, d1_.link04 AS link04_153, d1_.link05 AS link05_154, d1_.link06 AS link06_155, d1_.link07 AS link07_156, d1_.link08 AS link08_157, d1_.link09 AS link09_158, d1_.link10 AS link10_159, d1_.link11 AS link11_160, d1_.link12 AS link12_161, d1_.link13 AS link13_162, d1_.link14 AS link14_163, d1_.link15 AS link15_164, d1_.link16 AS link16_165, d1_.link17 AS link17_166, d1_.link18 AS link18_167, d1_.link19 AS link19_168, d1_.link20 AS link20_169, d1_.link21 AS link21_170, d1_.link22 AS link22_171, d1_.link23 AS link23_172, d1_.link24 AS link24_173, d1_.link25 AS link25_174, d1_.link26 AS link26_175, d1_.link27 AS link27_176, d1_.link28 AS link28_177, d1_.link29 AS link29_178, d1_.link30 AS link30_179, d1_.blank01 AS blank01_180, d1_.blank02 AS blank02_181, d1_.blank03 AS blank03_182, d1_.blank04 AS blank04_183, d1_.blank05 AS blank05_184, d1_.blank06 AS blank06_185, d1_.blank07 AS blank07_186, d1_.blank08 AS blank08_187, d1_.blank09 AS blank09_188, d1_.blank10 AS blank10_189, d1_.blank11 AS blank11_190, d1_.blank12 AS blank12_191, d1_.blank13 AS blank13_192, d1_.blank14 AS blank14_193, d1_.blank15 AS blank15_194, d1_.blank16 AS blank16_195, d1_.blank17 AS blank17_196, d1_.blank18 AS blank18_197, d1_.blank19 AS blank19_198, d1_.blank20 AS blank20_199, d1_.blank21 AS blank21_200, d1_.blank22 AS blank22_201, d1_.blank23 AS blank23_202, d1_.blank24 AS blank24_203, d1_.blank25 AS blank25_204, d1_.blank26 AS blank26_205, d1_.blank27 AS blank27_206, d1_.blank28 AS blank28_207, d1_.blank29 AS blank29_208, d1_.blank30 AS blank30_209, d1_.newcate AS newcate_210, d1_.dspfl AS dspfl_211, d2_.id AS id_212, d2_.category_name AS category_name_213, d2_.hierarchy AS hierarchy_214, d2_.sort_no AS sort_no_215, d2_.create_date AS create_date_216, d2_.update_date AS update_date_217, d2_.url AS url_218, d2_.title_image_path AS title_image_path_219, d2_.teikikoudoku1 AS teikikoudoku1_220, d2_.teikikoudoku2 AS teikikoudoku2_221, d2_.menuno AS menuno_222, d2_.kankou AS kankou_223, d2_.hatsubaibi AS hatsubaibi_224, d2_.newno AS newno_225, d2_.linkimage01 AS linkimage01_226, d2_.linkimage02 AS linkimage02_227, d2_.linkimage03 AS linkimage03_228, d2_.linkimage04 AS linkimage04_229, d2_.linkimage05 AS linkimage05_230, d2_.linkimage06 AS linkimage06_231, d2_.linkimage07 AS linkimage07_232, d2_.linkimage08 AS linkimage08_233, d2_.linkimage09 AS linkimage09_234, d2_.linkimage10 AS linkimage10_235, d2_.linkimage11 AS linkimage11_236, d2_.linkimage12 AS linkimage12_237, d2_.linkimage13 AS linkimage13_238, d2_.linkimage14 AS linkimage14_239, d2_.linkimage15 AS linkimage15_240, d2_.linkimage16 AS linkimage16_241, d2_.linkimage17 AS linkimage17_242, d2_.linkimage18 AS linkimage18_243, d2_.linkimage19 AS linkimage19_244, d2_.linkimage20 AS linkimage20_245, d2_.linkimage21 AS linkimage21_246, d2_.linkimage22 AS linkimage22_247, d2_.linkimage23 AS linkimage23_248, d2_.linkimage24 AS linkimage24_249, d2_.linkimage25 AS linkimage25_250, d2_.linkimage26 AS linkimage26_251, d2_.linkimage27 AS linkimage27_252, d2_.linkimage28 AS linkimage28_253, d2_.linkimage29 AS linkimage29_254, d2_.linkimage30 AS linkimage30_255, d2_.link01 AS link01_256, d2_.link02 AS link02_257, d2_.link03 AS link03_258, d2_.link04 AS link04_259, d2_.link05 AS link05_260, d2_.link06 AS link06_261, d2_.link07 AS link07_262, d2_.link08 AS link08_263, d2_.link09 AS link09_264, d2_.link10 AS link10_265, d2_.link11 AS link11_266, d2_.link12 AS link12_267, d2_.link13 AS link13_268, d2_.link14 AS link14_269, d2_.link15 AS link15_270, d2_.link16 AS link16_271, d2_.link17 AS link17_272, d2_.link18 AS link18_273, d2_.link19 AS link19_274, d2_.link20 AS link20_275, d2_.link21 AS link21_276, d2_.link22 AS link22_277, d2_.link23 AS link23_278, d2_.link24 AS link24_279, d2_.link25 AS link25_280, d2_.link26 AS link26_281, d2_.link27 AS link27_282, d2_.link28 AS link28_283, d2_.link29 AS link29_284, d2_.link30 AS link30_285, d2_.blank01 AS blank01_286, d2_.blank02 AS blank02_287, d2_.blank03 AS blank03_288, d2_.blank04 AS blank04_289, d2_.blank05 AS blank05_290, d2_.blank06 AS blank06_291, d2_.blank07 AS blank07_292, d2_.blank08 AS blank08_293, d2_.blank09 AS blank09_294, d2_.blank10 AS blank10_295, d2_.blank11 AS blank11_296, d2_.blank12 AS blank12_297, d2_.blank13 AS blank13_298, d2_.blank14 AS blank14_299, d2_.blank15 AS blank15_300, d2_.blank16 AS blank16_301, d2_.blank17 AS blank17_302, d2_.blank18 AS blank18_303, d2_.blank19 AS blank19_304, d2_.blank20 AS blank20_305, d2_.blank21 AS blank21_306, d2_.blank22 AS blank22_307, d2_.blank23 AS blank23_308, d2_.blank24 AS blank24_309, d2_.blank25 AS blank25_310, d2_.blank26 AS blank26_311, d2_.blank27 AS blank27_312, d2_.blank28 AS blank28_313, d2_.blank29 AS blank29_314, d2_.blank30 AS blank30_315, d2_.newcate AS newcate_316, d2_.dspfl AS dspfl_317, d3_.id AS id_318, d3_.category_name AS category_name_319, d3_.hierarchy AS hierarchy_320, d3_.sort_no AS sort_no_321, d3_.create_date AS create_date_322, d3_.update_date AS update_date_323, d3_.url AS url_324, d3_.title_image_path AS title_image_path_325, d3_.teikikoudoku1 AS teikikoudoku1_326, d3_.teikikoudoku2 AS teikikoudoku2_327, d3_.menuno AS menuno_328, d3_.kankou AS kankou_329, d3_.hatsubaibi AS hatsubaibi_330, d3_.newno AS newno_331, d3_.linkimage01 AS linkimage01_332, d3_.linkimage02 AS linkimage02_333, d3_.linkimage03 AS linkimage03_334, d3_.linkimage04 AS linkimage04_335, d3_.linkimage05 AS linkimage05_336, d3_.linkimage06 AS linkimage06_337, d3_.linkimage07 AS linkimage07_338, d3_.linkimage08 AS linkimage08_339, d3_.linkimage09 AS linkimage09_340, d3_.linkimage10 AS linkimage10_341, d3_.linkimage11 AS linkimage11_342, d3_.linkimage12 AS linkimage12_343, d3_.linkimage13 AS linkimage13_344, d3_.linkimage14 AS linkimage14_345, d3_.linkimage15 AS linkimage15_346, d3_.linkimage16 AS linkimage16_347, d3_.linkimage17 AS linkimage17_348, d3_.linkimage18 AS linkimage18_349, d3_.linkimage19 AS linkimage19_350, d3_.linkimage20 AS linkimage20_351, d3_.linkimage21 AS linkimage21_352, d3_.linkimage22 AS linkimage22_353, d3_.linkimage23 AS linkimage23_354, d3_.linkimage24 AS linkimage24_355, d3_.linkimage25 AS linkimage25_356, d3_.linkimage26 AS linkimage26_357, d3_.linkimage27 AS linkimage27_358, d3_.linkimage28 AS linkimage28_359, d3_.linkimage29 AS linkimage29_360, d3_.linkimage30 AS linkimage30_361, d3_.link01 AS link01_362, d3_.link02 AS link02_363, d3_.link03 AS link03_364, d3_.link04 AS link04_365, d3_.link05 AS link05_366, d3_.link06 AS link06_367, d3_.link07 AS link07_368, d3_.link08 AS link08_369, d3_.link09 AS link09_370, d3_.link10 AS link10_371, d3_.link11 AS link11_372, d3_.link12 AS link12_373, d3_.link13 AS link13_374, d3_.link14 AS link14_375, d3_.link15 AS link15_376, d3_.link16 AS link16_377, d3_.link17 AS link17_378, d3_.link18 AS link18_379, d3_.link19 AS link19_380, d3_.link20 AS link20_381, d3_.link21 AS link21_382, d3_.link22 AS link22_383, d3_.link23 AS link23_384, d3_.link24 AS link24_385, d3_.link25 AS link25_386, d3_.link26 AS link26_387, d3_.link27 AS link27_388, d3_.link28 AS link28_389, d3_.link29 AS link29_390, d3_.link30 AS link30_391, d3_.blank01 AS blank01_392, d3_.blank02 AS blank02_393, d3_.blank03 AS blank03_394, d3_.blank04 AS blank04_395, d3_.blank05 AS blank05_396, d3_.blank06 AS blank06_397, d3_.blank07 AS blank07_398, d3_.blank08 AS blank08_399, d3_.blank09 AS blank09_400, d3_.blank10 AS blank10_401, d3_.blank11 AS blank11_402, d3_.blank12 AS blank12_403, d3_.blank13 AS blank13_404, d3_.blank14 AS blank14_405, d3_.blank15 AS blank15_406, d3_.blank16 AS blank16_407, d3_.blank17 AS blank17_408, d3_.blank18 AS blank18_409, d3_.blank19 AS blank19_410, d3_.blank20 AS blank20_411, d3_.blank21 AS blank21_412, d3_.blank22 AS blank22_413, d3_.blank23 AS blank23_414, d3_.blank24 AS blank24_415, d3_.blank25 AS blank25_416, d3_.blank26 AS blank26_417, d3_.blank27 AS blank27_418, d3_.blank28 AS blank28_419, d3_.blank29 AS blank29_420, d3_.blank30 AS blank30_421, d3_.newcate AS newcate_422, d3_.dspfl AS dspfl_423, d4_.id AS id_424, d4_.category_name AS category_name_425, d4_.hierarchy AS hierarchy_426, d4_.sort_no AS sort_no_427, d4_.create_date AS create_date_428, d4_.update_date AS update_date_429, d4_.url AS url_430, d4_.title_image_path AS title_image_path_431, d4_.teikikoudoku1 AS teikikoudoku1_432, d4_.teikikoudoku2 AS teikikoudoku2_433, d4_.menuno AS menuno_434, d4_.kankou AS kankou_435, d4_.hatsubaibi AS hatsubaibi_436, d4_.newno AS newno_437, d4_.linkimage01 AS linkimage01_438, d4_.linkimage02 AS linkimage02_439, d4_.linkimage03 AS linkimage03_440, d4_.linkimage04 AS linkimage04_441, d4_.linkimage05 AS linkimage05_442, d4_.linkimage06 AS linkimage06_443, d4_.linkimage07 AS linkimage07_444, d4_.linkimage08 AS linkimage08_445, d4_.linkimage09 AS linkimage09_446, d4_.linkimage10 AS linkimage10_447, d4_.linkimage11 AS linkimage11_448, d4_.linkimage12 AS linkimage12_449, d4_.linkimage13 AS linkimage13_450, d4_.linkimage14 AS linkimage14_451, d4_.linkimage15 AS linkimage15_452, d4_.linkimage16 AS linkimage16_453, d4_.linkimage17 AS linkimage17_454, d4_.linkimage18 AS linkimage18_455, d4_.linkimage19 AS linkimage19_456, d4_.linkimage20 AS linkimage20_457, d4_.linkimage21 AS linkimage21_458, d4_.linkimage22 AS linkimage22_459, d4_.linkimage23 AS linkimage23_460, d4_.linkimage24 AS linkimage24_461, d4_.linkimage25 AS linkimage25_462, d4_.linkimage26 AS linkimage26_463, d4_.linkimage27 AS linkimage27_464, d4_.linkimage28 AS linkimage28_465, d4_.linkimage29 AS linkimage29_466, d4_.linkimage30 AS linkimage30_467, d4_.link01 AS link01_468, d4_.link02 AS link02_469, d4_.link03 AS link03_470, d4_.link04 AS link04_471, d4_.link05 AS link05_472, d4_.link06 AS link06_473, d4_.link07 AS link07_474, d4_.link08 AS link08_475, d4_.link09 AS link09_476, d4_.link10 AS link10_477, d4_.link11 AS link11_478, d4_.link12 AS link12_479, d4_.link13 AS link13_480, d4_.link14 AS link14_481, d4_.link15 AS link15_482, d4_.link16 AS link16_483, d4_.link17 AS link17_484, d4_.link18 AS link18_485, d4_.link19 AS link19_486, d4_.link20 AS link20_487, d4_.link21 AS link21_488, d4_.link22 AS link22_489, d4_.link23 AS link23_490, d4_.link24 AS link24_491, d4_.link25 AS link25_492, d4_.link26 AS link26_493, d4_.link27 AS link27_494, d4_.link28 AS link28_495, d4_.link29 AS link29_496, d4_.link30 AS link30_497, d4_.blank01 AS blank01_498, d4_.blank02 AS blank02_499, d4_.blank03 AS blank03_500, d4_.blank04 AS blank04_501, d4_.blank05 AS blank05_502, d4_.blank06 AS blank06_503, d4_.blank07 AS blank07_504, d4_.blank08 AS blank08_505, d4_.blank09 AS blank09_506, d4_.blank10 AS blank10_507, d4_.blank11 AS blank11_508, d4_.blank12 AS blank12_509, d4_.blank13 AS blank13_510, d4_.blank14 AS blank14_511, d4_.blank15 AS blank15_512, d4_.blank16 AS blank16_513, d4_.blank17 AS blank17_514, d4_.blank18 AS blank18_515, d4_.blank19 AS blank19_516, d4_.blank20 AS blank20_517, d4_.blank21 AS blank21_518, d4_.blank22 AS blank22_519, d4_.blank23 AS blank23_520, d4_.blank24 AS blank24_521, d4_.blank25 AS blank25_522, d4_.blank26 AS blank26_523, d4_.blank27 AS blank27_524, d4_.blank28 AS blank28_525, d4_.blank29 AS blank29_526, d4_.blank30 AS blank30_527, d4_.newcate AS newcate_528, d4_.dspfl AS dspfl_529, d0_.discriminator_type AS discriminator_type_530, d0_.parent_category_id AS parent_category_id_531, d0_.creator_id AS creator_id_532, d1_.discriminator_type AS discriminator_type_533, d1_.parent_category_id AS parent_category_id_534, d1_.creator_id AS creator_id_535, d2_.discriminator_type AS discriminator_type_536, d2_.parent_category_id AS parent_category_id_537, d2_.creator_id AS creator_id_538, d3_.discriminator_type AS discriminator_type_539, d3_.parent_category_id AS parent_category_id_540, d3_.creator_id AS creator_id_541, d4_.discriminator_type AS discriminator_type_542, d4_.parent_category_id AS parent_category_id_543, d4_.creator_id AS creator_id_544 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 ASC, d2_.sort_no ASC, d3_.sort_no ASC, d4_.sort_no ASC 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, d1_.id AS id_106, d1_.category_name AS category_name_107, d1_.hierarchy AS hierarchy_108, d1_.sort_no AS sort_no_109, d1_.create_date AS create_date_110, d1_.update_date AS update_date_111, d1_.url AS url_112, d1_.title_image_path AS title_image_path_113, d1_.teikikoudoku1 AS teikikoudoku1_114, d1_.teikikoudoku2 AS teikikoudoku2_115, d1_.menuno AS menuno_116, d1_.kankou AS kankou_117, d1_.hatsubaibi AS hatsubaibi_118, d1_.newno AS newno_119, d1_.linkimage01 AS linkimage01_120, d1_.linkimage02 AS linkimage02_121, d1_.linkimage03 AS linkimage03_122, d1_.linkimage04 AS linkimage04_123, d1_.linkimage05 AS linkimage05_124, d1_.linkimage06 AS linkimage06_125, d1_.linkimage07 AS linkimage07_126, d1_.linkimage08 AS linkimage08_127, d1_.linkimage09 AS linkimage09_128, d1_.linkimage10 AS linkimage10_129, d1_.linkimage11 AS linkimage11_130, d1_.linkimage12 AS linkimage12_131, d1_.linkimage13 AS linkimage13_132, d1_.linkimage14 AS linkimage14_133, d1_.linkimage15 AS linkimage15_134, d1_.linkimage16 AS linkimage16_135, d1_.linkimage17 AS linkimage17_136, d1_.linkimage18 AS linkimage18_137, d1_.linkimage19 AS linkimage19_138, d1_.linkimage20 AS linkimage20_139, d1_.linkimage21 AS linkimage21_140, d1_.linkimage22 AS linkimage22_141, d1_.linkimage23 AS linkimage23_142, d1_.linkimage24 AS linkimage24_143, d1_.linkimage25 AS linkimage25_144, d1_.linkimage26 AS linkimage26_145, d1_.linkimage27 AS linkimage27_146, d1_.linkimage28 AS linkimage28_147, d1_.linkimage29 AS linkimage29_148, d1_.linkimage30 AS linkimage30_149, d1_.link01 AS link01_150, d1_.link02 AS link02_151, d1_.link03 AS link03_152, d1_.link04 AS link04_153, d1_.link05 AS link05_154, d1_.link06 AS link06_155, d1_.link07 AS link07_156, d1_.link08 AS link08_157, d1_.link09 AS link09_158, d1_.link10 AS link10_159, d1_.link11 AS link11_160, d1_.link12 AS link12_161, d1_.link13 AS link13_162, d1_.link14 AS link14_163, d1_.link15 AS link15_164, d1_.link16 AS link16_165, d1_.link17 AS link17_166, d1_.link18 AS link18_167, d1_.link19 AS link19_168, d1_.link20 AS link20_169, d1_.link21 AS link21_170, d1_.link22 AS link22_171, d1_.link23 AS link23_172, d1_.link24 AS link24_173, d1_.link25 AS link25_174, d1_.link26 AS link26_175, d1_.link27 AS link27_176, d1_.link28 AS link28_177, d1_.link29 AS link29_178, d1_.link30 AS link30_179, d1_.blank01 AS blank01_180, d1_.blank02 AS blank02_181, d1_.blank03 AS blank03_182, d1_.blank04 AS blank04_183, d1_.blank05 AS blank05_184, d1_.blank06 AS blank06_185, d1_.blank07 AS blank07_186, d1_.blank08 AS blank08_187, d1_.blank09 AS blank09_188, d1_.blank10 AS blank10_189, d1_.blank11 AS blank11_190, d1_.blank12 AS blank12_191, d1_.blank13 AS blank13_192, d1_.blank14 AS blank14_193, d1_.blank15 AS blank15_194, d1_.blank16 AS blank16_195, d1_.blank17 AS blank17_196, d1_.blank18 AS blank18_197, d1_.blank19 AS blank19_198, d1_.blank20 AS blank20_199, d1_.blank21 AS blank21_200, d1_.blank22 AS blank22_201, d1_.blank23 AS blank23_202, d1_.blank24 AS blank24_203, d1_.blank25 AS blank25_204, d1_.blank26 AS blank26_205, d1_.blank27 AS blank27_206, d1_.blank28 AS blank28_207, d1_.blank29 AS blank29_208, d1_.blank30 AS blank30_209, d1_.newcate AS newcate_210, d1_.dspfl AS dspfl_211, d2_.id AS id_212, d2_.category_name AS category_name_213, d2_.hierarchy AS hierarchy_214, d2_.sort_no AS sort_no_215, d2_.create_date AS create_date_216, d2_.update_date AS update_date_217, d2_.url AS url_218, d2_.title_image_path AS title_image_path_219, d2_.teikikoudoku1 AS teikikoudoku1_220, d2_.teikikoudoku2 AS teikikoudoku2_221, d2_.menuno AS menuno_222, d2_.kankou AS kankou_223, d2_.hatsubaibi AS hatsubaibi_224, d2_.newno AS newno_225, d2_.linkimage01 AS linkimage01_226, d2_.linkimage02 AS linkimage02_227, d2_.linkimage03 AS linkimage03_228, d2_.linkimage04 AS linkimage04_229, d2_.linkimage05 AS linkimage05_230, d2_.linkimage06 AS linkimage06_231, d2_.linkimage07 AS linkimage07_232, d2_.linkimage08 AS linkimage08_233, d2_.linkimage09 AS linkimage09_234, d2_.linkimage10 AS linkimage10_235, d2_.linkimage11 AS linkimage11_236, d2_.linkimage12 AS linkimage12_237, d2_.linkimage13 AS linkimage13_238, d2_.linkimage14 AS linkimage14_239, d2_.linkimage15 AS linkimage15_240, d2_.linkimage16 AS linkimage16_241, d2_.linkimage17 AS linkimage17_242, d2_.linkimage18 AS linkimage18_243, d2_.linkimage19 AS linkimage19_244, d2_.linkimage20 AS linkimage20_245, d2_.linkimage21 AS linkimage21_246, d2_.linkimage22 AS linkimage22_247, d2_.linkimage23 AS linkimage23_248, d2_.linkimage24 AS linkimage24_249, d2_.linkimage25 AS linkimage25_250, d2_.linkimage26 AS linkimage26_251, d2_.linkimage27 AS linkimage27_252, d2_.linkimage28 AS linkimage28_253, d2_.linkimage29 AS linkimage29_254, d2_.linkimage30 AS linkimage30_255, d2_.link01 AS link01_256, d2_.link02 AS link02_257, d2_.link03 AS link03_258, d2_.link04 AS link04_259, d2_.link05 AS link05_260, d2_.link06 AS link06_261, d2_.link07 AS link07_262, d2_.link08 AS link08_263, d2_.link09 AS link09_264, d2_.link10 AS link10_265, d2_.link11 AS link11_266, d2_.link12 AS link12_267, d2_.link13 AS link13_268, d2_.link14 AS link14_269, d2_.link15 AS link15_270, d2_.link16 AS link16_271, d2_.link17 AS link17_272, d2_.link18 AS link18_273, d2_.link19 AS link19_274, d2_.link20 AS link20_275, d2_.link21 AS link21_276, d2_.link22 AS link22_277, d2_.link23 AS link23_278, d2_.link24 AS link24_279, d2_.link25 AS link25_280, d2_.link26 AS link26_281, d2_.link27 AS link27_282, d2_.link28 AS link28_283, d2_.link29 AS link29_284, d2_.link30 AS link30_285, d2_.blank01 AS blank01_286, d2_.blank02 AS blank02_287, d2_.blank03 AS blank03_288, d2_.blank04 AS blank04_289, d2_.blank05 AS blank05_290, d2_.blank06 AS blank06_291, d2_.blank07 AS blank07_292, d2_.blank08 AS blank08_293, d2_.blank09 AS blank09_294, d2_.blank10 AS blank10_295, d2_.blank11 AS blank11_296, d2_.blank12 AS blank12_297, d2_.blank13 AS blank13_298, d2_.blank14 AS blank14_299, d2_.blank15 AS blank15_300, d2_.blank16 AS blank16_301, d2_.blank17 AS blank17_302, d2_.blank18 AS blank18_303, d2_.blank19 AS blank19_304, d2_.blank20 AS blank20_305, d2_.blank21 AS blank21_306, d2_.blank22 AS blank22_307, d2_.blank23 AS blank23_308, d2_.blank24 AS blank24_309, d2_.blank25 AS blank25_310, d2_.blank26 AS blank26_311, d2_.blank27 AS blank27_312, d2_.blank28 AS blank28_313, d2_.blank29 AS blank29_314, d2_.blank30 AS blank30_315, d2_.newcate AS newcate_316, d2_.dspfl AS dspfl_317, d3_.id AS id_318, d3_.category_name AS category_name_319, d3_.hierarchy AS hierarchy_320, d3_.sort_no AS sort_no_321, d3_.create_date AS create_date_322, d3_.update_date AS update_date_323, d3_.url AS url_324, d3_.title_image_path AS title_image_path_325, d3_.teikikoudoku1 AS teikikoudoku1_326, d3_.teikikoudoku2 AS teikikoudoku2_327, d3_.menuno AS menuno_328, d3_.kankou AS kankou_329, d3_.hatsubaibi AS hatsubaibi_330, d3_.newno AS newno_331, d3_.linkimage01 AS linkimage01_332, d3_.linkimage02 AS linkimage02_333, d3_.linkimage03 AS linkimage03_334, d3_.linkimage04 AS linkimage04_335, d3_.linkimage05 AS linkimage05_336, d3_.linkimage06 AS linkimage06_337, d3_.linkimage07 AS linkimage07_338, d3_.linkimage08 AS linkimage08_339, d3_.linkimage09 AS linkimage09_340, d3_.linkimage10 AS linkimage10_341, d3_.linkimage11 AS linkimage11_342, d3_.linkimage12 AS linkimage12_343, d3_.linkimage13 AS linkimage13_344, d3_.linkimage14 AS linkimage14_345, d3_.linkimage15 AS linkimage15_346, d3_.linkimage16 AS linkimage16_347, d3_.linkimage17 AS linkimage17_348, d3_.linkimage18 AS linkimage18_349, d3_.linkimage19 AS linkimage19_350, d3_.linkimage20 AS linkimage20_351, d3_.linkimage21 AS linkimage21_352, d3_.linkimage22 AS linkimage22_353, d3_.linkimage23 AS linkimage23_354, d3_.linkimage24 AS linkimage24_355, d3_.linkimage25 AS linkimage25_356, d3_.linkimage26 AS linkimage26_357, d3_.linkimage27 AS linkimage27_358, d3_.linkimage28 AS linkimage28_359, d3_.linkimage29 AS linkimage29_360, d3_.linkimage30 AS linkimage30_361, d3_.link01 AS link01_362, d3_.link02 AS link02_363, d3_.link03 AS link03_364, d3_.link04 AS link04_365, d3_.link05 AS link05_366, d3_.link06 AS link06_367, d3_.link07 AS link07_368, d3_.link08 AS link08_369, d3_.link09 AS link09_370, d3_.link10 AS link10_371, d3_.link11 AS link11_372, d3_.link12 AS link12_373, d3_.link13 AS link13_374, d3_.link14 AS link14_375, d3_.link15 AS link15_376, d3_.link16 AS link16_377, d3_.link17 AS link17_378, d3_.link18 AS link18_379, d3_.link19 AS link19_380, d3_.link20 AS link20_381, d3_.link21 AS link21_382, d3_.link22 AS link22_383, d3_.link23 AS link23_384, d3_.link24 AS link24_385, d3_.link25 AS link25_386, d3_.link26 AS link26_387, d3_.link27 AS link27_388, d3_.link28 AS link28_389, d3_.link29 AS link29_390, d3_.link30 AS link30_391, d3_.blank01 AS blank01_392, d3_.blank02 AS blank02_393, d3_.blank03 AS blank03_394, d3_.blank04 AS blank04_395, d3_.blank05 AS blank05_396, d3_.blank06 AS blank06_397, d3_.blank07 AS blank07_398, d3_.blank08 AS blank08_399, d3_.blank09 AS blank09_400, d3_.blank10 AS blank10_401, d3_.blank11 AS blank11_402, d3_.blank12 AS blank12_403, d3_.blank13 AS blank13_404, d3_.blank14 AS blank14_405, d3_.blank15 AS blank15_406, d3_.blank16 AS blank16_407, d3_.blank17 AS blank17_408, d3_.blank18 AS blank18_409, d3_.blank19 AS blank19_410, d3_.blank20 AS blank20_411, d3_.blank21 AS blank21_412, d3_.blank22 AS blank22_413, d3_.blank23 AS blank23_414, d3_.blank24 AS blank24_415, d3_.blank25 AS blank25_416, d3_.blank26 AS blank26_417, d3_.blank27 AS blank27_418, d3_.blank28 AS blank28_419, d3_.blank29 AS blank29_420, d3_.blank30 AS blank30_421, d3_.newcate AS newcate_422, d3_.dspfl AS dspfl_423, d4_.id AS id_424, d4_.category_name AS category_name_425, d4_.hierarchy AS hierarchy_426, d4_.sort_no AS sort_no_427, d4_.create_date AS create_date_428, d4_.update_date AS update_date_429, d4_.url AS url_430, d4_.title_image_path AS title_image_path_431, d4_.teikikoudoku1 AS teikikoudoku1_432, d4_.teikikoudoku2 AS teikikoudoku2_433, d4_.menuno AS menuno_434, d4_.kankou AS kankou_435, d4_.hatsubaibi AS hatsubaibi_436, d4_.newno AS newno_437, d4_.linkimage01 AS linkimage01_438, d4_.linkimage02 AS linkimage02_439, d4_.linkimage03 AS linkimage03_440, d4_.linkimage04 AS linkimage04_441, d4_.linkimage05 AS linkimage05_442, d4_.linkimage06 AS linkimage06_443, d4_.linkimage07 AS linkimage07_444, d4_.linkimage08 AS linkimage08_445, d4_.linkimage09 AS linkimage09_446, d4_.linkimage10 AS linkimage10_447, d4_.linkimage11 AS linkimage11_448, d4_.linkimage12 AS linkimage12_449, d4_.linkimage13 AS linkimage13_450, d4_.linkimage14 AS linkimage14_451, d4_.linkimage15 AS linkimage15_452, d4_.linkimage16 AS linkimage16_453, d4_.linkimage17 AS linkimage17_454, d4_.linkimage18 AS linkimage18_455, d4_.linkimage19 AS linkimage19_456, d4_.linkimage20 AS linkimage20_457, d4_.linkimage21 AS linkimage21_458, d4_.linkimage22 AS linkimage22_459, d4_.linkimage23 AS linkimage23_460, d4_.linkimage24 AS linkimage24_461, d4_.linkimage25 AS linkimage25_462, d4_.linkimage26 AS linkimage26_463, d4_.linkimage27 AS linkimage27_464, d4_.linkimage28 AS linkimage28_465, d4_.linkimage29 AS linkimage29_466, d4_.linkimage30 AS linkimage30_467, d4_.link01 AS link01_468, d4_.link02 AS link02_469, d4_.link03 AS link03_470, d4_.link04 AS link04_471, d4_.link05 AS link05_472, d4_.link06 AS link06_473, d4_.link07 AS link07_474, d4_.link08 AS link08_475, d4_.link09 AS link09_476, d4_.link10 AS link10_477, d4_.link11 AS link11_478, d4_.link12 AS link12_479, d4_.link13 AS link13_480, d4_.link14 AS link14_481, d4_.link15 AS link15_482, d4_.link16 AS link16_483, d4_.link17 AS link17_484, d4_.link18 AS link18_485, d4_.link19 AS link19_486, d4_.link20 AS link20_487, d4_.link21 AS link21_488, d4_.link22 AS link22_489, d4_.link23 AS link23_490, d4_.link24 AS link24_491, d4_.link25 AS link25_492, d4_.link26 AS link26_493, d4_.link27 AS link27_494, d4_.link28 AS link28_495, d4_.link29 AS link29_496, d4_.link30 AS link30_497, d4_.blank01 AS blank01_498, d4_.blank02 AS blank02_499, d4_.blank03 AS blank03_500, d4_.blank04 AS blank04_501, d4_.blank05 AS blank05_502, d4_.blank06 AS blank06_503, d4_.blank07 AS blank07_504, d4_.blank08 AS blank08_505, d4_.blank09 AS blank09_506, d4_.blank10 AS blank10_507, d4_.blank11 AS blank11_508, d4_.blank12 AS blank12_509, d4_.blank13 AS blank13_510, d4_.blank14 AS blank14_511, d4_.blank15 AS blank15_512, d4_.blank16 AS blank16_513, d4_.blank17 AS blank17_514, d4_.blank18 AS blank18_515, d4_.blank19 AS blank19_516, d4_.blank20 AS blank20_517, d4_.blank21 AS blank21_518, d4_.blank22 AS blank22_519, d4_.blank23 AS blank23_520, d4_.blank24 AS blank24_521, d4_.blank25 AS blank25_522, d4_.blank26 AS blank26_523, d4_.blank27 AS blank27_524, d4_.blank28 AS blank28_525, d4_.blank29 AS blank29_526, d4_.blank30 AS blank30_527, d4_.newcate AS newcate_528, d4_.dspfl AS dspfl_529, d0_.discriminator_type AS discriminator_type_530, d0_.parent_category_id AS parent_category_id_531, d0_.creator_id AS creator_id_532, d1_.discriminator_type AS discriminator_type_533, d1_.parent_category_id AS parent_category_id_534, d1_.creator_id AS creator_id_535, d2_.discriminator_type AS discriminator_type_536, d2_.parent_category_id AS parent_category_id_537, d2_.creator_id AS creator_id_538, d3_.discriminator_type AS discriminator_type_539, d3_.parent_category_id AS parent_category_id_540, d3_.creator_id AS creator_id_541, d4_.discriminator_type AS discriminator_type_542, d4_.parent_category_id AS parent_category_id_543, d4_.creator_id AS creator_id_544 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 ASC, d2_.sort_no ASC, d3_.sort_no ASC, d4_.sort_no ASC;
11.60 ms (4.25%)	1	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 IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND d0_.discriminator_type IN ('product') GROUP BY d0_.id ORDER BY d0_.orderdate DESC, d0_.create_date DESC LIMIT 5 Parameters: [`null 130 100 99 98 97 96 95 94 93 92 91 90 89 88 87 86 85 84`] View formatted query View runnable query Explain query 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 IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ) AND d0_.discriminator_type IN ('product') GROUP BY d0_.id ORDER BY d0_.orderdate DESC, d0_.create_date DESC LIMIT 5 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 IN (NULL, 130, 100, 99, 98, 97, 96, 95, 94, 93, 92, 91, 90, 89, 88, 87, 86, 85, 84)) AND d0_.discriminator_type IN ('product') GROUP BY d0_.id ORDER BY d0_.orderdate DESC, d0_.create_date DESC LIMIT 5;
10.47 ms (3.83%)	30	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: [`12543`] View formatted query View runnable query Explain query 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') 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 = 12543 AND t0.discriminator_type IN ('productclass');
8.81 ms (3.23%)	1	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_ WHERE (d0_.product_status_id = 1 AND d0_.recommendno > 0) AND d0_.discriminator_type IN ('product') ORDER BY d0_.recommendno DESC, d0_.create_date DESC Parameters: [] View formatted query View runnable query Explain query 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_ WHERE ( d0_.product_status_id = 1 AND d0_.recommendno > 0 ) AND d0_.discriminator_type IN ('product') ORDER BY d0_.recommendno DESC, d0_.create_date DESC 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_ WHERE (d0_.product_status_id = 1 AND d0_.recommendno > 0) AND d0_.discriminator_type IN ('product') ORDER BY d0_.recommendno DESC, d0_.create_date DESC;
6.00 ms (2.20%)	30	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: [`12551`] View formatted query View runnable query Explain query 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') 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 = 12551 AND t0.discriminator_type IN ('taxrule');
2.16 ms (0.79%)	6	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.create_date AS create_date_8, t0.update_date AS update_date_9, t0.comment1 AS comment1_10, t0.linkurl AS linkurl_11, t0.bookcart AS bookcart_12, t0.viewsw AS viewsw_13, t0.recommendno AS recommendno_14, t0.teikaref AS teikaref_15, t0.orderdate AS orderdate_16, t0.enddate AS enddate_17, t0.hatsubaibi AS hatsubaibi_18, t0.entrydate AS entrydate_19, t0.jissize AS jissize_20, t0.isbn AS isbn_21, t0.amazon AS amazon_22, t0.importfl AS importfl_23, t0.old_create_date AS old_create_date_24, t0.old_update_date AS old_update_date_25, t0.free_description_about_quantity AS free_description_about_quantity_26, t0.free_description_about_selling_price AS free_description_about_selling_price_27, t0.free_description_of_payment_delivery AS free_description_of_payment_delivery_28, t0.creator_id AS creator_id_29, t0.product_status_id AS product_status_id_30, t0.discriminator_type FROM dtb_product t0 WHERE t0.id = ? AND t0.discriminator_type IN ('product') Parameters: [`12536`] View formatted query View runnable query Explain query 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.create_date AS create_date_8, t0.update_date AS update_date_9, t0.comment1 AS comment1_10, t0.linkurl AS linkurl_11, t0.bookcart AS bookcart_12, t0.viewsw AS viewsw_13, t0.recommendno AS recommendno_14, t0.teikaref AS teikaref_15, t0.orderdate AS orderdate_16, t0.enddate AS enddate_17, t0.hatsubaibi AS hatsubaibi_18, t0.entrydate AS entrydate_19, t0.jissize AS jissize_20, t0.isbn AS isbn_21, t0.amazon AS amazon_22, t0.importfl AS importfl_23, t0.old_create_date AS old_create_date_24, t0.old_update_date AS old_update_date_25, t0.free_description_about_quantity AS free_description_about_quantity_26, t0.free_description_about_selling_price AS free_description_about_selling_price_27, t0.free_description_of_payment_delivery AS free_description_of_payment_delivery_28, t0.creator_id AS creator_id_29, t0.product_status_id AS product_status_id_30, t0.discriminator_type FROM dtb_product t0 WHERE t0.id = ? AND t0.discriminator_type IN ('product') 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.create_date AS create_date_8, t0.update_date AS update_date_9, t0.comment1 AS comment1_10, t0.linkurl AS linkurl_11, t0.bookcart AS bookcart_12, t0.viewsw AS viewsw_13, t0.recommendno AS recommendno_14, t0.teikaref AS teikaref_15, t0.orderdate AS orderdate_16, t0.enddate AS enddate_17, t0.hatsubaibi AS hatsubaibi_18, t0.entrydate AS entrydate_19, t0.jissize AS jissize_20, t0.isbn AS isbn_21, t0.amazon AS amazon_22, t0.importfl AS importfl_23, t0.old_create_date AS old_create_date_24, t0.old_update_date AS old_update_date_25, t0.free_description_about_quantity AS free_description_about_quantity_26, t0.free_description_about_selling_price AS free_description_about_selling_price_27, t0.free_description_of_payment_delivery AS free_description_of_payment_delivery_28, t0.creator_id AS creator_id_29, t0.product_status_id AS product_status_id_30, t0.discriminator_type FROM dtb_product t0 WHERE t0.id = 12536 AND t0.discriminator_type IN ('product');
2.02 ms (0.74%)	4	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: [`81`] View formatted query View runnable query Explain query 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') 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 = 81 AND t0.discriminator_type IN ('category');
1.68 ms (0.62%)	1	SELECT d0_.product_class_id AS sclr_0, d0_.product_id AS sclr_1, SUM(d0_.quantity) AS sclr_2 FROM dtb_order_item d0_ INNER JOIN mtb_order_item_type m1_ ON d0_.order_item_type_id = m1_.id AND m1_.discriminator_type IN ('orderitemtype') INNER JOIN dtb_order d2_ ON d0_.order_id = d2_.id AND d2_.discriminator_type IN ('order') WHERE (m1_.id = ? AND d2_.order_date > ?) AND d0_.discriminator_type IN ('orderitem') GROUP BY d0_.product_class_id ORDER BY sclr_2 DESC LIMIT 8 Parameters: [`1 "2025-03-26 23:35:01"`] View formatted query View runnable query Explain query SELECT d0_.product_class_id AS sclr_0, d0_.product_id AS sclr_1, SUM(d0_.quantity) AS sclr_2 FROM dtb_order_item d0_ INNER JOIN mtb_order_item_type m1_ ON d0_.order_item_type_id = m1_.id AND m1_.discriminator_type IN ('orderitemtype') INNER JOIN dtb_order d2_ ON d0_.order_id = d2_.id AND d2_.discriminator_type IN ('order') WHERE ( m1_.id = ? AND d2_.order_date > ? ) AND d0_.discriminator_type IN ('orderitem') GROUP BY d0_.product_class_id ORDER BY sclr_2 DESC LIMIT 8 SELECT d0_.product_class_id AS sclr_0, d0_.product_id AS sclr_1, SUM(d0_.quantity) AS sclr_2 FROM dtb_order_item d0_ INNER JOIN mtb_order_item_type m1_ ON d0_.order_item_type_id = m1_.id AND m1_.discriminator_type IN ('orderitemtype') INNER JOIN dtb_order d2_ ON d0_.order_id = d2_.id AND d2_.discriminator_type IN ('order') WHERE (m1_.id = 1 AND d2_.order_date > '2025-03-26 23:35:01') AND d0_.discriminator_type IN ('orderitem') GROUP BY d0_.product_class_id ORDER BY sclr_2 DESC LIMIT 8;
1.15 ms (0.42%)	2	SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.update_date AS update_date_3, t0.title AS title_4, t0.cateid AS cateid_5, t0.image01 AS image01_6, t0.image02 AS image02_7, t0.image03 AS image03_8, t0.image04 AS image04_9, t0.image05 AS image05_10, t0.image06 AS image06_11, t0.image07 AS image07_12, t0.image08 AS image08_13, t0.image09 AS image09_14, t0.image10 AS image10_15, t0.image11 AS image11_16, t0.image12 AS image12_17, t0.image13 AS image13_18, t0.image14 AS image14_19, t0.image15 AS image15_20, t0.image16 AS image16_21, t0.image17 AS image17_22, t0.image18 AS image18_23, t0.image19 AS image19_24, t0.image20 AS image20_25, t0.image21 AS image21_26, t0.image22 AS image22_27, t0.image23 AS image23_28, t0.image24 AS image24_29, t0.image25 AS image25_30, t0.image26 AS image26_31, t0.image27 AS image27_32, t0.image28 AS image28_33, t0.image29 AS image29_34, t0.image30 AS image30_35, t0.link01 AS link01_36, t0.link02 AS link02_37, t0.link03 AS link03_38, t0.link04 AS link04_39, t0.link05 AS link05_40, t0.link06 AS link06_41, t0.link07 AS link07_42, t0.link08 AS link08_43, t0.link09 AS link09_44, t0.link10 AS link10_45, t0.link11 AS link11_46, t0.link12 AS link12_47, t0.link13 AS link13_48, t0.link14 AS link14_49, t0.link15 AS link15_50, t0.link16 AS link16_51, t0.link17 AS link17_52, t0.link18 AS link18_53, t0.link19 AS link19_54, t0.link20 AS link20_55, t0.link21 AS link21_56, t0.link22 AS link22_57, t0.link23 AS link23_58, t0.link24 AS link24_59, t0.link25 AS link25_60, t0.link26 AS link26_61, t0.link27 AS link27_62, t0.link28 AS link28_63, t0.link29 AS link29_64, t0.link30 AS link30_65, t0.blank01 AS blank01_66, t0.blank02 AS blank02_67, t0.blank03 AS blank03_68, t0.blank04 AS blank04_69, t0.blank05 AS blank05_70, t0.blank06 AS blank06_71, t0.blank07 AS blank07_72, t0.blank08 AS blank08_73, t0.blank09 AS blank09_74, t0.blank10 AS blank10_75, t0.blank11 AS blank11_76, t0.blank12 AS blank12_77, t0.blank13 AS blank13_78, t0.blank14 AS blank14_79, t0.blank15 AS blank15_80, t0.blank16 AS blank16_81, t0.blank17 AS blank17_82, t0.blank18 AS blank18_83, t0.blank19 AS blank19_84, t0.blank20 AS blank20_85, t0.blank21 AS blank21_86, t0.blank22 AS blank22_87, t0.blank23 AS blank23_88, t0.blank24 AS blank24_89, t0.blank25 AS blank25_90, t0.blank26 AS blank26_91, t0.blank27 AS blank27_92, t0.blank28 AS blank28_93, t0.blank29 AS blank29_94, t0.blank30 AS blank30_95, t0.imagesp01 AS imagesp01_96, t0.imagesp02 AS imagesp02_97, t0.imagesp03 AS imagesp03_98, t0.imagesp04 AS imagesp04_99, t0.imagesp05 AS imagesp05_100, t0.imagesp06 AS imagesp06_101, t0.imagesp07 AS imagesp07_102, t0.imagesp08 AS imagesp08_103, t0.imagesp09 AS imagesp09_104, t0.imagesp10 AS imagesp10_105, t0.imagesp11 AS imagesp11_106, t0.imagesp12 AS imagesp12_107, t0.imagesp13 AS imagesp13_108, t0.imagesp14 AS imagesp14_109, t0.imagesp15 AS imagesp15_110, t0.imagesp16 AS imagesp16_111, t0.imagesp17 AS imagesp17_112, t0.imagesp18 AS imagesp18_113, t0.imagesp19 AS imagesp19_114, t0.imagesp20 AS imagesp20_115, t0.imagesp21 AS imagesp21_116, t0.imagesp22 AS imagesp22_117, t0.imagesp23 AS imagesp23_118, t0.imagesp24 AS imagesp24_119, t0.imagesp25 AS imagesp25_120, t0.imagesp26 AS imagesp26_121, t0.imagesp27 AS imagesp27_122, t0.imagesp28 AS imagesp28_123, t0.imagesp29 AS imagesp29_124, t0.imagesp30 AS imagesp30_125, t0.creator_id AS creator_id_126, t0.discriminator_type FROM dtb_visual t0 WHERE t0.id = ? AND t0.discriminator_type IN ('visual') Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.update_date AS update_date_3, t0.title AS title_4, t0.cateid AS cateid_5, t0.image01 AS image01_6, t0.image02 AS image02_7, t0.image03 AS image03_8, t0.image04 AS image04_9, t0.image05 AS image05_10, t0.image06 AS image06_11, t0.image07 AS image07_12, t0.image08 AS image08_13, t0.image09 AS image09_14, t0.image10 AS image10_15, t0.image11 AS image11_16, t0.image12 AS image12_17, t0.image13 AS image13_18, t0.image14 AS image14_19, t0.image15 AS image15_20, t0.image16 AS image16_21, t0.image17 AS image17_22, t0.image18 AS image18_23, t0.image19 AS image19_24, t0.image20 AS image20_25, t0.image21 AS image21_26, t0.image22 AS image22_27, t0.image23 AS image23_28, t0.image24 AS image24_29, t0.image25 AS image25_30, t0.image26 AS image26_31, t0.image27 AS image27_32, t0.image28 AS image28_33, t0.image29 AS image29_34, t0.image30 AS image30_35, t0.link01 AS link01_36, t0.link02 AS link02_37, t0.link03 AS link03_38, t0.link04 AS link04_39, t0.link05 AS link05_40, t0.link06 AS link06_41, t0.link07 AS link07_42, t0.link08 AS link08_43, t0.link09 AS link09_44, t0.link10 AS link10_45, t0.link11 AS link11_46, t0.link12 AS link12_47, t0.link13 AS link13_48, t0.link14 AS link14_49, t0.link15 AS link15_50, t0.link16 AS link16_51, t0.link17 AS link17_52, t0.link18 AS link18_53, t0.link19 AS link19_54, t0.link20 AS link20_55, t0.link21 AS link21_56, t0.link22 AS link22_57, t0.link23 AS link23_58, t0.link24 AS link24_59, t0.link25 AS link25_60, t0.link26 AS link26_61, t0.link27 AS link27_62, t0.link28 AS link28_63, t0.link29 AS link29_64, t0.link30 AS link30_65, t0.blank01 AS blank01_66, t0.blank02 AS blank02_67, t0.blank03 AS blank03_68, t0.blank04 AS blank04_69, t0.blank05 AS blank05_70, t0.blank06 AS blank06_71, t0.blank07 AS blank07_72, t0.blank08 AS blank08_73, t0.blank09 AS blank09_74, t0.blank10 AS blank10_75, t0.blank11 AS blank11_76, t0.blank12 AS blank12_77, t0.blank13 AS blank13_78, t0.blank14 AS blank14_79, t0.blank15 AS blank15_80, t0.blank16 AS blank16_81, t0.blank17 AS blank17_82, t0.blank18 AS blank18_83, t0.blank19 AS blank19_84, t0.blank20 AS blank20_85, t0.blank21 AS blank21_86, t0.blank22 AS blank22_87, t0.blank23 AS blank23_88, t0.blank24 AS blank24_89, t0.blank25 AS blank25_90, t0.blank26 AS blank26_91, t0.blank27 AS blank27_92, t0.blank28 AS blank28_93, t0.blank29 AS blank29_94, t0.blank30 AS blank30_95, t0.imagesp01 AS imagesp01_96, t0.imagesp02 AS imagesp02_97, t0.imagesp03 AS imagesp03_98, t0.imagesp04 AS imagesp04_99, t0.imagesp05 AS imagesp05_100, t0.imagesp06 AS imagesp06_101, t0.imagesp07 AS imagesp07_102, t0.imagesp08 AS imagesp08_103, t0.imagesp09 AS imagesp09_104, t0.imagesp10 AS imagesp10_105, t0.imagesp11 AS imagesp11_106, t0.imagesp12 AS imagesp12_107, t0.imagesp13 AS imagesp13_108, t0.imagesp14 AS imagesp14_109, t0.imagesp15 AS imagesp15_110, t0.imagesp16 AS imagesp16_111, t0.imagesp17 AS imagesp17_112, t0.imagesp18 AS imagesp18_113, t0.imagesp19 AS imagesp19_114, t0.imagesp20 AS imagesp20_115, t0.imagesp21 AS imagesp21_116, t0.imagesp22 AS imagesp22_117, t0.imagesp23 AS imagesp23_118, t0.imagesp24 AS imagesp24_119, t0.imagesp25 AS imagesp25_120, t0.imagesp26 AS imagesp26_121, t0.imagesp27 AS imagesp27_122, t0.imagesp28 AS imagesp28_123, t0.imagesp29 AS imagesp29_124, t0.imagesp30 AS imagesp30_125, t0.creator_id AS creator_id_126, t0.discriminator_type FROM dtb_visual t0 WHERE t0.id = ? AND t0.discriminator_type IN ('visual') SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.update_date AS update_date_3, t0.title AS title_4, t0.cateid AS cateid_5, t0.image01 AS image01_6, t0.image02 AS image02_7, t0.image03 AS image03_8, t0.image04 AS image04_9, t0.image05 AS image05_10, t0.image06 AS image06_11, t0.image07 AS image07_12, t0.image08 AS image08_13, t0.image09 AS image09_14, t0.image10 AS image10_15, t0.image11 AS image11_16, t0.image12 AS image12_17, t0.image13 AS image13_18, t0.image14 AS image14_19, t0.image15 AS image15_20, t0.image16 AS image16_21, t0.image17 AS image17_22, t0.image18 AS image18_23, t0.image19 AS image19_24, t0.image20 AS image20_25, t0.image21 AS image21_26, t0.image22 AS image22_27, t0.image23 AS image23_28, t0.image24 AS image24_29, t0.image25 AS image25_30, t0.image26 AS image26_31, t0.image27 AS image27_32, t0.image28 AS image28_33, t0.image29 AS image29_34, t0.image30 AS image30_35, t0.link01 AS link01_36, t0.link02 AS link02_37, t0.link03 AS link03_38, t0.link04 AS link04_39, t0.link05 AS link05_40, t0.link06 AS link06_41, t0.link07 AS link07_42, t0.link08 AS link08_43, t0.link09 AS link09_44, t0.link10 AS link10_45, t0.link11 AS link11_46, t0.link12 AS link12_47, t0.link13 AS link13_48, t0.link14 AS link14_49, t0.link15 AS link15_50, t0.link16 AS link16_51, t0.link17 AS link17_52, t0.link18 AS link18_53, t0.link19 AS link19_54, t0.link20 AS link20_55, t0.link21 AS link21_56, t0.link22 AS link22_57, t0.link23 AS link23_58, t0.link24 AS link24_59, t0.link25 AS link25_60, t0.link26 AS link26_61, t0.link27 AS link27_62, t0.link28 AS link28_63, t0.link29 AS link29_64, t0.link30 AS link30_65, t0.blank01 AS blank01_66, t0.blank02 AS blank02_67, t0.blank03 AS blank03_68, t0.blank04 AS blank04_69, t0.blank05 AS blank05_70, t0.blank06 AS blank06_71, t0.blank07 AS blank07_72, t0.blank08 AS blank08_73, t0.blank09 AS blank09_74, t0.blank10 AS blank10_75, t0.blank11 AS blank11_76, t0.blank12 AS blank12_77, t0.blank13 AS blank13_78, t0.blank14 AS blank14_79, t0.blank15 AS blank15_80, t0.blank16 AS blank16_81, t0.blank17 AS blank17_82, t0.blank18 AS blank18_83, t0.blank19 AS blank19_84, t0.blank20 AS blank20_85, t0.blank21 AS blank21_86, t0.blank22 AS blank22_87, t0.blank23 AS blank23_88, t0.blank24 AS blank24_89, t0.blank25 AS blank25_90, t0.blank26 AS blank26_91, t0.blank27 AS blank27_92, t0.blank28 AS blank28_93, t0.blank29 AS blank29_94, t0.blank30 AS blank30_95, t0.imagesp01 AS imagesp01_96, t0.imagesp02 AS imagesp02_97, t0.imagesp03 AS imagesp03_98, t0.imagesp04 AS imagesp04_99, t0.imagesp05 AS imagesp05_100, t0.imagesp06 AS imagesp06_101, t0.imagesp07 AS imagesp07_102, t0.imagesp08 AS imagesp08_103, t0.imagesp09 AS imagesp09_104, t0.imagesp10 AS imagesp10_105, t0.imagesp11 AS imagesp11_106, t0.imagesp12 AS imagesp12_107, t0.imagesp13 AS imagesp13_108, t0.imagesp14 AS imagesp14_109, t0.imagesp15 AS imagesp15_110, t0.imagesp16 AS imagesp16_111, t0.imagesp17 AS imagesp17_112, t0.imagesp18 AS imagesp18_113, t0.imagesp19 AS imagesp19_114, t0.imagesp20 AS imagesp20_115, t0.imagesp21 AS imagesp21_116, t0.imagesp22 AS imagesp22_117, t0.imagesp23 AS imagesp23_118, t0.imagesp24 AS imagesp24_119, t0.imagesp25 AS imagesp25_120, t0.imagesp26 AS imagesp26_121, t0.imagesp27 AS imagesp27_122, t0.imagesp28 AS imagesp28_123, t0.imagesp29 AS imagesp29_124, t0.imagesp30 AS imagesp30_125, t0.creator_id AS creator_id_126, t0.discriminator_type FROM dtb_visual t0 WHERE t0.id = 1 AND t0.discriminator_type IN ('visual');
0.94 ms (0.35%)	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: [`"bookcart"`] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.page_name AS page_name_1, d0_.url AS url_2, d0_.file_name AS file_name_3, d0_.edit_type AS edit_type_4, d0_.author AS author_5, d0_.description AS description_6, d0_.keyword AS keyword_7, d0_.create_date AS create_date_8, d0_.update_date AS update_date_9, d0_.meta_robots AS meta_robots_10, d0_.meta_tags AS meta_tags_11, d1_.page_id AS page_id_12, d1_.layout_id AS layout_id_13, d1_.sort_no AS sort_no_14, d2_.id AS id_15, d2_.layout_name AS layout_name_16, d2_.create_date AS create_date_17, d2_.update_date AS update_date_18, d0_.discriminator_type AS discriminator_type_19, d0_.master_page_id AS master_page_id_20, d1_.discriminator_type AS discriminator_type_21, d1_.page_id AS page_id_22, d1_.layout_id AS layout_id_23, d2_.discriminator_type AS discriminator_type_24, d2_.device_type_id AS device_type_id_25 FROM dtb_page d0_ LEFT JOIN dtb_page_layout d1_ ON d0_.id = d1_.page_id AND d1_.discriminator_type IN ('pagelayout') LEFT JOIN dtb_layout d2_ ON d1_.layout_id = d2_.id AND d2_.discriminator_type IN ('layout') WHERE (d0_.url = ?) AND d0_.discriminator_type IN ('page') SELECT d0_.id AS id_0, d0_.page_name AS page_name_1, d0_.url AS url_2, d0_.file_name AS file_name_3, d0_.edit_type AS edit_type_4, d0_.author AS author_5, d0_.description AS description_6, d0_.keyword AS keyword_7, d0_.create_date AS create_date_8, d0_.update_date AS update_date_9, d0_.meta_robots AS meta_robots_10, d0_.meta_tags AS meta_tags_11, d1_.page_id AS page_id_12, d1_.layout_id AS layout_id_13, d1_.sort_no AS sort_no_14, d2_.id AS id_15, d2_.layout_name AS layout_name_16, d2_.create_date AS create_date_17, d2_.update_date AS update_date_18, d0_.discriminator_type AS discriminator_type_19, d0_.master_page_id AS master_page_id_20, d1_.discriminator_type AS discriminator_type_21, d1_.page_id AS page_id_22, d1_.layout_id AS layout_id_23, d2_.discriminator_type AS discriminator_type_24, d2_.device_type_id AS device_type_id_25 FROM dtb_page d0_ LEFT JOIN dtb_page_layout d1_ ON d0_.id = d1_.page_id AND d1_.discriminator_type IN ('pagelayout') LEFT JOIN dtb_layout d2_ ON d1_.layout_id = d2_.id AND d2_.discriminator_type IN ('layout') WHERE (d0_.url = 'bookcart') AND d0_.discriminator_type IN ('page');
0.91 ms (0.33%)	1	SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.discriminator_type FROM mtb_product_list_max t0 WHERE t0.discriminator_type IN ('productlistmax') ORDER BY t0.sort_no ASC Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.discriminator_type FROM mtb_product_list_max t0 WHERE t0.discriminator_type IN ('productlistmax') ORDER BY t0.sort_no ASC SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.discriminator_type FROM mtb_product_list_max t0 WHERE t0.discriminator_type IN ('productlistmax') ORDER BY t0.sort_no ASC;
0.72 ms (0.26%)	1	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: [`"2025-04-15 23:35:01"`] View formatted query View runnable query Explain query 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 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 < '2025-04-15 23:35:01' 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;
0.31 ms (0.11%)	1	SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.discriminator_type FROM mtb_product_list_order_by t0 WHERE t0.discriminator_type IN ('productlistorderby') ORDER BY t0.sort_no ASC Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.discriminator_type FROM mtb_product_list_order_by t0 WHERE t0.discriminator_type IN ('productlistorderby') ORDER BY t0.sort_no ASC SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.discriminator_type FROM mtb_product_list_order_by t0 WHERE t0.discriminator_type IN ('productlistorderby') ORDER BY t0.sort_no ASC;
0.16 ms (0.06%)	1	SET SESSION time_zone = '+00:00' Parameters: [] View formatted query View runnable query Explain query SET SESSION time_zone = '+00:00' SET SESSION time_zone = '+00:00';
0.11 ms (0.04%)	1	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: [`1`] View formatted query View runnable query Explain query 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 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 = 1 AND t0.discriminator_type IN ('category') LIMIT 1;
0.11 ms (0.04%)	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.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: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.company_kana AS company_kana_3, t0.postal_code AS postal_code_4, t0.addr01 AS addr01_5, t0.addr02 AS addr02_6, t0.phone_number AS phone_number_7, t0.business_hour AS business_hour_8, t0.email01 AS email01_9, t0.email02 AS email02_10, t0.email03 AS email03_11, t0.email04 AS email04_12, t0.shop_name AS shop_name_13, t0.shop_kana AS shop_kana_14, t0.shop_name_eng AS shop_name_eng_15, t0.update_date AS update_date_16, t0.good_traded AS good_traded_17, t0.message AS message_18, t0.delivery_free_amount AS delivery_free_amount_19, t0.delivery_free_quantity AS delivery_free_quantity_20, t0.option_mypage_order_status_display AS option_mypage_order_status_display_21, t0.option_nostock_hidden AS option_nostock_hidden_22, t0.option_favorite_product AS option_favorite_product_23, t0.option_product_delivery_fee AS option_product_delivery_fee_24, t0.invoice_registration_number AS invoice_registration_number_25, t0.option_product_tax_rule AS option_product_tax_rule_26, t0.option_customer_activate AS option_customer_activate_27, t0.option_remember_me AS option_remember_me_28, t0.option_mail_notifier AS option_mail_notifier_29, t0.authentication_key AS authentication_key_30, t0.php_path AS php_path_31, t0.option_point AS option_point_32, t0.basic_point_rate AS basic_point_rate_33, t0.point_conversion_rate AS point_conversion_rate_34, t0.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') 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 = 1 AND t0.discriminator_type IN ('baseinfo');
0.08 ms (0.03%)	1	SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED Parameters: [] View formatted query View runnable query Explain query SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
0.05 ms (0.02%)	1	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
Eccube\Entity\AbstractEntity	No errors.
Eccube\Entity\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.
Eccube\Entity\OrderItem	No errors.
Eccube\Entity\Category	No errors.
Customize\Entity\Visual	No errors.
Plugin\EccubePaymentLite42\Entity\Config	No errors.
Eccube\Entity\Member	No errors.
Eccube\Entity\ProductCategory	No errors.
Eccube\Entity\Master\ProductListMax	No errors.
Eccube\Entity\Master\ProductListOrderBy	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\CustomerFavoriteProduct	No errors.
Eccube\Entity\Master\OrderItemType	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.

Symfony Profiler

https://xyzsys.net/bookcart

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping