Symfony Profiler

SELECT
  B.product_id,
  A.price
FROM
  plg_customerrank_dtb_customer_price AS A
  LEFT OUTER JOIN dtb_product_class AS B ON A.product_class_id = B.id
WHERE
  A.customer_rank_id = '2';

SELECT
 B.product_id,
 A.price
FROM 
 plg_customerrank_dtb_customer_price AS A
 LEFT OUTER JOIN dtb_product_class AS B ON A.product_class_id=B.id
WHERE
 A.customer_rank_id='2';  ;

SELECT
  t0.id AS id_1,
  t0.create_date AS create_date_2,
  t0.product_item_id AS product_item_id_3,
  t0.product_id AS product_id_4,
  t0.discriminator_type
FROM
  plg_productplus_dtb_product_data t0
WHERE
  t0.product_item_id = ?
  AND t0.product_id = ?
  AND t0.discriminator_type IN ('productdata')
LIMIT
  1

SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.product_item_id = 73 AND t0.product_id = 2525 AND t0.discriminator_type IN ('productdata') LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.num_value AS num_value_3,
  t0.date_value AS date_value_4,
  t0.sort_no AS sort_no_5,
  t0.product_data_id AS product_data_id_6,
  t0.discriminator_type
FROM
  plg_productplus_dtb_product_data_detail t0
WHERE
  t0.product_data_id = ?
  AND t0.discriminator_type IN ('productdatadetail')
ORDER BY
  t0.sort_no ASC

SELECT t0.id AS id_1, t0.value AS value_2, t0.num_value AS num_value_3, t0.date_value AS date_value_4, t0.sort_no AS sort_no_5, t0.product_data_id AS product_data_id_6, t0.discriminator_type FROM plg_productplus_dtb_product_data_detail t0 WHERE t0.product_data_id = 264081 AND t0.discriminator_type IN ('productdatadetail') ORDER BY t0.sort_no ASC;

INSERT INTO plg_productplus_dtb_product_data_detail (
  value, num_value, date_value, sort_no,
  product_data_id, discriminator_type
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO plg_productplus_dtb_product_data_detail (value, num_value, date_value, sort_no, product_data_id, discriminator_type) VALUES (NULL, 0, NULL, 1, 327820, 'productdatadetail');

DELETE FROM
  plg_productplus_dtb_product_data_detail
WHERE
  id = ?

DELETE FROM plg_productplus_dtb_product_data_detail WHERE id = 4590162;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.input_type AS input_type_3,
  t0.is_required AS is_required_4,
  t0.search_flg AS search_flg_5,
  t0.keyword_flg AS keyword_flg_6,
  t0.sort_no AS sort_no_7,
  t0.create_date AS create_date_8,
  t0.update_date AS update_date_9,
  t0.discriminator_type
FROM
  plg_productplus_dtb_product_item t0
WHERE
  t0.id = ?
  AND t0.discriminator_type IN ('productitem')

SELECT t0.id AS id_1, t0.name AS name_2, t0.input_type AS input_type_3, t0.is_required AS is_required_4, t0.search_flg AS search_flg_5, t0.keyword_flg AS keyword_flg_6, t0.sort_no AS sort_no_7, t0.create_date AS create_date_8, t0.update_date AS update_date_9, t0.discriminator_type FROM plg_productplus_dtb_product_item t0 WHERE t0.id = 2 AND t0.discriminator_type IN ('productitem');

SELECT
  d0_.id AS id_0,
  d0_.category_name AS category_name_1,
  d0_.hierarchy AS hierarchy_2,
  d0_.sort_no AS sort_no_3,
  d0_.create_date AS create_date_4,
  d0_.update_date AS update_date_5,
  d1_.id AS id_6,
  d1_.category_name AS category_name_7,
  d1_.hierarchy AS hierarchy_8,
  d1_.sort_no AS sort_no_9,
  d1_.create_date AS create_date_10,
  d1_.update_date AS update_date_11,
  d2_.id AS id_12,
  d2_.category_name AS category_name_13,
  d2_.hierarchy AS hierarchy_14,
  d2_.sort_no AS sort_no_15,
  d2_.create_date AS create_date_16,
  d2_.update_date AS update_date_17,
  d3_.id AS id_18,
  d3_.category_name AS category_name_19,
  d3_.hierarchy AS hierarchy_20,
  d3_.sort_no AS sort_no_21,
  d3_.create_date AS create_date_22,
  d3_.update_date AS update_date_23,
  d4_.id AS id_24,
  d4_.category_name AS category_name_25,
  d4_.hierarchy AS hierarchy_26,
  d4_.sort_no AS sort_no_27,
  d4_.create_date AS create_date_28,
  d4_.update_date AS update_date_29,
  d0_.discriminator_type AS discriminator_type_30,
  d0_.parent_category_id AS parent_category_id_31,
  d0_.creator_id AS creator_id_32,
  d1_.discriminator_type AS discriminator_type_33,
  d1_.parent_category_id AS parent_category_id_34,
  d1_.creator_id AS creator_id_35,
  d2_.discriminator_type AS discriminator_type_36,
  d2_.parent_category_id AS parent_category_id_37,
  d2_.creator_id AS creator_id_38,
  d3_.discriminator_type AS discriminator_type_39,
  d3_.parent_category_id AS parent_category_id_40,
  d3_.creator_id AS creator_id_41,
  d4_.discriminator_type AS discriminator_type_42,
  d4_.parent_category_id AS parent_category_id_43,
  d4_.creator_id AS creator_id_44
FROM
  dtb_category d0_
  LEFT JOIN dtb_category d1_ ON d0_.id = d1_.parent_category_id
  AND d1_.discriminator_type IN ('category')
  LEFT JOIN dtb_category d2_ ON d1_.id = d2_.parent_category_id
  AND d2_.discriminator_type IN ('category')
  LEFT JOIN dtb_category d3_ ON d2_.id = d3_.parent_category_id
  AND d3_.discriminator_type IN ('category')
  LEFT JOIN dtb_category d4_ ON d3_.id = d4_.parent_category_id
  AND d4_.discriminator_type IN ('category')
WHERE
  (d0_.parent_category_id IS NULL)
  AND d0_.discriminator_type IN ('category')
ORDER BY
  d0_.sort_no DESC,
  d1_.sort_no DESC,
  d2_.sort_no DESC,
  d3_.sort_no DESC,
  d4_.sort_no DESC

SELECT d0_.id AS id_0, d0_.category_name AS category_name_1, d0_.hierarchy AS hierarchy_2, d0_.sort_no AS sort_no_3, d0_.create_date AS create_date_4, d0_.update_date AS update_date_5, d1_.id AS id_6, d1_.category_name AS category_name_7, d1_.hierarchy AS hierarchy_8, d1_.sort_no AS sort_no_9, d1_.create_date AS create_date_10, d1_.update_date AS update_date_11, d2_.id AS id_12, d2_.category_name AS category_name_13, d2_.hierarchy AS hierarchy_14, d2_.sort_no AS sort_no_15, d2_.create_date AS create_date_16, d2_.update_date AS update_date_17, d3_.id AS id_18, d3_.category_name AS category_name_19, d3_.hierarchy AS hierarchy_20, d3_.sort_no AS sort_no_21, d3_.create_date AS create_date_22, d3_.update_date AS update_date_23, d4_.id AS id_24, d4_.category_name AS category_name_25, d4_.hierarchy AS hierarchy_26, d4_.sort_no AS sort_no_27, d4_.create_date AS create_date_28, d4_.update_date AS update_date_29, d0_.discriminator_type AS discriminator_type_30, d0_.parent_category_id AS parent_category_id_31, d0_.creator_id AS creator_id_32, d1_.discriminator_type AS discriminator_type_33, d1_.parent_category_id AS parent_category_id_34, d1_.creator_id AS creator_id_35, d2_.discriminator_type AS discriminator_type_36, d2_.parent_category_id AS parent_category_id_37, d2_.creator_id AS creator_id_38, d3_.discriminator_type AS discriminator_type_39, d3_.parent_category_id AS parent_category_id_40, d3_.creator_id AS creator_id_41, d4_.discriminator_type AS discriminator_type_42, d4_.parent_category_id AS parent_category_id_43, d4_.creator_id AS creator_id_44 FROM dtb_category d0_ LEFT JOIN dtb_category d1_ ON d0_.id = d1_.parent_category_id AND d1_.discriminator_type IN ('category') LEFT JOIN dtb_category d2_ ON d1_.id = d2_.parent_category_id AND d2_.discriminator_type IN ('category') LEFT JOIN dtb_category d3_ ON d2_.id = d3_.parent_category_id AND d3_.discriminator_type IN ('category') LEFT JOIN dtb_category d4_ ON d3_.id = d4_.parent_category_id AND d4_.discriminator_type IN ('category') WHERE (d0_.parent_category_id IS NULL) AND d0_.discriminator_type IN ('category') ORDER BY d0_.sort_no DESC, d1_.sort_no DESC, d2_.sort_no DESC, d3_.sort_no DESC, d4_.sort_no DESC;

SELECT
  p0_.id AS id_0,
  p0_.text AS text_1,
  p0_.sort_no AS sort_no_2,
  p0_.discriminator_type AS discriminator_type_3,
  p0_.product_item_id AS product_item_id_4
FROM
  plg_productplus_dtb_product_item_option p0_
WHERE
  (p0_.product_item_id = ?)
  AND p0_.discriminator_type IN ('productitemoption')
ORDER BY
  p0_.sort_no DESC

SELECT p0_.id AS id_0, p0_.text AS text_1, p0_.sort_no AS sort_no_2, p0_.discriminator_type AS discriminator_type_3, p0_.product_item_id AS product_item_id_4 FROM plg_productplus_dtb_product_item_option p0_ WHERE (p0_.product_item_id = 73) AND p0_.discriminator_type IN ('productitemoption') ORDER BY p0_.sort_no DESC;

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.sort_no AS sort_no_3,
  t0.product_item_id AS product_item_id_4,
  t0.discriminator_type
FROM
  plg_productplus_dtb_product_item_option t0
WHERE
  t0.product_item_id = ?
  AND t0.discriminator_type IN ('productitemoption')

SELECT t0.id AS id_1, t0.text AS text_2, t0.sort_no AS sort_no_3, t0.product_item_id AS product_item_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_item_option t0 WHERE t0.product_item_id = 3 AND t0.discriminator_type IN ('productitemoption');

INSERT INTO dtb_product_category (
  product_id, category_id, discriminator_type
)
VALUES
  (?, ?, ?)

INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (2525, 10, 'productcategory');

DELETE FROM
  dtb_product_category
WHERE
  product_id = ?
  AND category_id = ?

DELETE FROM dtb_product_category WHERE product_id = 2525 AND category_id = 10;

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.customer_rank_id AS customer_rank_id_3,
  t0.product_class_id AS product_class_id_4,
  t0.discriminator_type
FROM
  plg_customerrank_dtb_customer_price t0
WHERE
  t0.product_class_id = ?
  AND t0.customer_rank_id = ?
  AND t0.discriminator_type IN ('customerprice')
LIMIT
  1

SELECT t0.id AS id_1, t0.price AS price_2, t0.customer_rank_id AS customer_rank_id_3, t0.product_class_id AS product_class_id_4, t0.discriminator_type FROM plg_customerrank_dtb_customer_price t0 WHERE t0.product_class_id = 2604 AND t0.customer_rank_id = 8 AND t0.discriminator_type IN ('customerprice') LIMIT 1;

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.product_id AS product_id_5,
  t0.creator_id AS creator_id_6,
  t0.discriminator_type
FROM
  dtb_product_image t0
WHERE
  t0.file_name = ?
  AND t0.product_id = ?
  AND t0.discriminator_type IN ('productimage')
LIMIT
  1

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.product_id AS product_id_5, t0.creator_id AS creator_id_6, t0.discriminator_type FROM dtb_product_image t0 WHERE t0.file_name = '1223154832_63a54f40b9cf8.webp' AND t0.product_id = 2525 AND t0.discriminator_type IN ('productimage') LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.input_type AS input_type_2,
  p0_.is_required AS is_required_3,
  p0_.search_flg AS search_flg_4,
  p0_.keyword_flg AS keyword_flg_5,
  p0_.sort_no AS sort_no_6,
  p0_.create_date AS create_date_7,
  p0_.update_date AS update_date_8,
  p0_.discriminator_type AS discriminator_type_9
FROM
  plg_productplus_dtb_product_item p0_
WHERE
  p0_.discriminator_type IN ('productitem')
ORDER BY
  p0_.sort_no DESC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.input_type AS input_type_2, p0_.is_required AS is_required_3, p0_.search_flg AS search_flg_4, p0_.keyword_flg AS keyword_flg_5, p0_.sort_no AS sort_no_6, p0_.create_date AS create_date_7, p0_.update_date AS update_date_8, p0_.discriminator_type AS discriminator_type_9 FROM plg_productplus_dtb_product_item p0_ WHERE p0_.discriminator_type IN ('productitem') ORDER BY p0_.sort_no DESC;

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.customer_rank_id AS customer_rank_id_3,
  t0.product_class_id AS product_class_id_4,
  t0.discriminator_type
FROM
  plg_customerrank_dtb_customer_price t0
WHERE
  t0.customer_rank_id = ?
  AND t0.product_class_id = ?
  AND t0.discriminator_type IN ('customerprice')
LIMIT
  1

SELECT t0.id AS id_1, t0.price AS price_2, t0.customer_rank_id AS customer_rank_id_3, t0.product_class_id AS product_class_id_4, t0.discriminator_type FROM plg_customerrank_dtb_customer_price t0 WHERE t0.customer_rank_id = 2 AND t0.product_class_id = 2604 AND t0.discriminator_type IN ('customerprice') LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.create_date AS create_date_2,
  t0.product_item_id AS product_item_id_3,
  t0.product_id AS product_id_4,
  t0.discriminator_type
FROM
  plg_productplus_dtb_product_data t0
WHERE
  t0.product_id = ?
  AND t0.discriminator_type IN ('productdata')

SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.product_id = 2525 AND t0.discriminator_type IN ('productdata');

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_.del_flg AS del_flg_9,
  d0_.free_description_about_quantity AS free_description_about_quantity_10,
  d0_.free_description_about_selling_price AS free_description_about_selling_price_11,
  d0_.free_description_of_payment_delivery AS free_description_of_payment_delivery_12,
  d1_.id AS id_13,
  d1_.product_code AS product_code_14,
  d1_.stock AS stock_15,
  d1_.stock_unlimited AS stock_unlimited_16,
  d1_.sale_limit AS sale_limit_17,
  d1_.price01 AS price01_18,
  d1_.price02 AS price02_19,
  d1_.delivery_fee AS delivery_fee_20,
  d1_.visible AS visible_21,
  d1_.create_date AS create_date_22,
  d1_.update_date AS update_date_23,
  d1_.currency_code AS currency_code_24,
  d1_.point_rate AS point_rate_25,
  d2_.id AS id_26,
  d2_.backend_name AS backend_name_27,
  d2_.name AS name_28,
  d2_.sort_no AS sort_no_29,
  d2_.visible AS visible_30,
  d2_.create_date AS create_date_31,
  d2_.update_date AS update_date_32,
  d3_.id AS id_33,
  d3_.backend_name AS backend_name_34,
  d3_.name AS name_35,
  d3_.sort_no AS sort_no_36,
  d3_.visible AS visible_37,
  d3_.create_date AS create_date_38,
  d3_.update_date AS update_date_39,
  d4_.id AS id_40,
  d4_.file_name AS file_name_41,
  d4_.sort_no AS sort_no_42,
  d4_.create_date AS create_date_43,
  d5_.id AS id_44,
  d5_.create_date AS create_date_45,
  d0_.discriminator_type AS discriminator_type_46,
  d0_.creator_id AS creator_id_47,
  d0_.product_status_id AS product_status_id_48,
  d1_.discriminator_type AS discriminator_type_49,
  d1_.product_id AS product_id_50,
  d1_.sale_type_id AS sale_type_id_51,
  d1_.class_category_id1 AS class_category_id1_52,
  d1_.class_category_id2 AS class_category_id2_53,
  d1_.delivery_duration_id AS delivery_duration_id_54,
  d1_.creator_id AS creator_id_55,
  d1_.regular_discount_id AS regular_discount_id_56,
  d2_.discriminator_type AS discriminator_type_57,
  d2_.class_name_id AS class_name_id_58,
  d2_.creator_id AS creator_id_59,
  d3_.discriminator_type AS discriminator_type_60,
  d3_.class_name_id AS class_name_id_61,
  d3_.creator_id AS creator_id_62,
  d4_.discriminator_type AS discriminator_type_63,
  d4_.product_id AS product_id_64,
  d4_.creator_id AS creator_id_65,
  d5_.discriminator_type AS discriminator_type_66,
  d5_.product_id AS product_id_67,
  d5_.tag_id AS tag_id_68,
  d5_.creator_id AS creator_id_69
FROM
  dtb_product d0_
  INNER JOIN dtb_product_class d1_ ON d0_.id = d1_.product_id
  AND d1_.discriminator_type IN ('productclass')
  LEFT JOIN dtb_class_category d2_ ON d1_.class_category_id1 = d2_.id
  AND d2_.discriminator_type IN ('classcategory')
  LEFT JOIN dtb_class_category d3_ ON d1_.class_category_id2 = d3_.id
  AND d3_.discriminator_type IN ('classcategory')
  LEFT JOIN dtb_product_image d4_ ON d0_.id = d4_.product_id
  AND d4_.discriminator_type IN ('productimage')
  LEFT JOIN dtb_product_tag d5_ ON d0_.id = d5_.product_id
  AND d5_.discriminator_type IN ('producttag')
WHERE
  (
    d0_.id = ?
    AND d1_.visible = ?
  )
  AND d0_.discriminator_type IN ('product')
ORDER BY
  d2_.sort_no DESC,
  d3_.sort_no DESC,
  d4_.sort_no ASC

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_.del_flg AS del_flg_9, d0_.free_description_about_quantity AS free_description_about_quantity_10, d0_.free_description_about_selling_price AS free_description_about_selling_price_11, d0_.free_description_of_payment_delivery AS free_description_of_payment_delivery_12, d1_.id AS id_13, d1_.product_code AS product_code_14, d1_.stock AS stock_15, d1_.stock_unlimited AS stock_unlimited_16, d1_.sale_limit AS sale_limit_17, d1_.price01 AS price01_18, d1_.price02 AS price02_19, d1_.delivery_fee AS delivery_fee_20, d1_.visible AS visible_21, d1_.create_date AS create_date_22, d1_.update_date AS update_date_23, d1_.currency_code AS currency_code_24, d1_.point_rate AS point_rate_25, d2_.id AS id_26, d2_.backend_name AS backend_name_27, d2_.name AS name_28, d2_.sort_no AS sort_no_29, d2_.visible AS visible_30, d2_.create_date AS create_date_31, d2_.update_date AS update_date_32, d3_.id AS id_33, d3_.backend_name AS backend_name_34, d3_.name AS name_35, d3_.sort_no AS sort_no_36, d3_.visible AS visible_37, d3_.create_date AS create_date_38, d3_.update_date AS update_date_39, d4_.id AS id_40, d4_.file_name AS file_name_41, d4_.sort_no AS sort_no_42, d4_.create_date AS create_date_43, d5_.id AS id_44, d5_.create_date AS create_date_45, d0_.discriminator_type AS discriminator_type_46, d0_.creator_id AS creator_id_47, d0_.product_status_id AS product_status_id_48, d1_.discriminator_type AS discriminator_type_49, d1_.product_id AS product_id_50, d1_.sale_type_id AS sale_type_id_51, d1_.class_category_id1 AS class_category_id1_52, d1_.class_category_id2 AS class_category_id2_53, d1_.delivery_duration_id AS delivery_duration_id_54, d1_.creator_id AS creator_id_55, d1_.regular_discount_id AS regular_discount_id_56, d2_.discriminator_type AS discriminator_type_57, d2_.class_name_id AS class_name_id_58, d2_.creator_id AS creator_id_59, d3_.discriminator_type AS discriminator_type_60, d3_.class_name_id AS class_name_id_61, d3_.creator_id AS creator_id_62, d4_.discriminator_type AS discriminator_type_63, d4_.product_id AS product_id_64, d4_.creator_id AS creator_id_65, d5_.discriminator_type AS discriminator_type_66, d5_.product_id AS product_id_67, d5_.tag_id AS tag_id_68, d5_.creator_id AS creator_id_69 FROM dtb_product d0_ INNER JOIN dtb_product_class d1_ ON d0_.id = d1_.product_id AND d1_.discriminator_type IN ('productclass') LEFT JOIN dtb_class_category d2_ ON d1_.class_category_id1 = d2_.id AND d2_.discriminator_type IN ('classcategory') LEFT JOIN dtb_class_category d3_ ON d1_.class_category_id2 = d3_.id AND d3_.discriminator_type IN ('classcategory') LEFT JOIN dtb_product_image d4_ ON d0_.id = d4_.product_id AND d4_.discriminator_type IN ('productimage') LEFT JOIN dtb_product_tag d5_ ON d0_.id = d5_.product_id AND d5_.discriminator_type IN ('producttag') WHERE (d0_.id = '2525' AND d1_.visible = 1) AND d0_.discriminator_type IN ('product') ORDER BY d2_.sort_no DESC, d3_.sort_no DESC, d4_.sort_no ASC;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.discount_rate AS discount_rate_2,
  p0_.discount_value AS discount_value_3,
  p0_.point_rate AS point_rate_4,
  p0_.delivery_free_condition AS delivery_free_condition_5,
  p0_.cond_amount AS cond_amount_6,
  p0_.cond_buytimes AS cond_buytimes_7,
  p0_.initial_flg AS initial_flg_8,
  p0_.fixed_flg AS fixed_flg_9,
  p0_.priority AS priority_10,
  p0_.extension_period AS extension_period_11,
  p0_.create_date AS create_date_12,
  p0_.update_date AS update_date_13,
  p0_.discriminator_type AS discriminator_type_14
FROM
  plg_customerrank_dtb_customer_rank p0_
WHERE
  p0_.discriminator_type IN ('customerrank')
ORDER BY
  p0_.priority DESC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.discount_rate AS discount_rate_2, p0_.discount_value AS discount_value_3, p0_.point_rate AS point_rate_4, p0_.delivery_free_condition AS delivery_free_condition_5, p0_.cond_amount AS cond_amount_6, p0_.cond_buytimes AS cond_buytimes_7, p0_.initial_flg AS initial_flg_8, p0_.fixed_flg AS fixed_flg_9, p0_.priority AS priority_10, p0_.extension_period AS extension_period_11, p0_.create_date AS create_date_12, p0_.update_date AS update_date_13, p0_.discriminator_type AS discriminator_type_14 FROM plg_customerrank_dtb_customer_rank p0_ WHERE p0_.discriminator_type IN ('customerrank') ORDER BY p0_.priority DESC;

SELECT
  t0.id AS id_1,
  t0.display_start_date AS display_start_date_2,
  t0.display_end_date AS display_end_date_3,
  t0.create_date AS create_date_4,
  t0.update_date AS update_date_5,
  t0.product_id AS product_id_6
FROM
  plg_pia_product_display_period t0
WHERE
  t0.product_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.display_start_date AS display_start_date_2, t0.display_end_date AS display_end_date_3, t0.create_date AS create_date_4, t0.update_date AS update_date_5, t0.product_id AS product_id_6 FROM plg_pia_product_display_period t0 WHERE t0.product_id = 2525 LIMIT 1;

SELECT
  p0_.month AS month_0,
  p0_.day AS day_1
FROM
  plg_holiday p0_
WHERE
  (
    p0_.holiday BETWEEN ?
    AND ?
  )
  AND p0_.del_flg = ?
ORDER BY
  p0_.month ASC,
  p0_.day ASC

SELECT p0_.month AS month_0, p0_.day AS day_1 FROM plg_holiday p0_ WHERE (p0_.holiday BETWEEN '2026-09-01' AND '2026-09-30') AND p0_.del_flg = 0 ORDER BY p0_.month ASC, p0_.day ASC;

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

SELECT t0.id AS id_1, t0.name AS name_2, t0.department AS department_3, t0.login_id AS login_id_4, t0.password AS password_5, t0.salt AS salt_6, t0.sort_no AS sort_no_7, t0.two_factor_auth_key AS two_factor_auth_key_8, t0.two_factor_auth_enabled AS two_factor_auth_enabled_9, t0.create_date AS create_date_10, t0.update_date AS update_date_11, t0.login_date AS login_date_12, t0.work_id AS work_id_13, t0.authority_id AS authority_id_14, t0.creator_id AS creator_id_15, t17.id AS id_16, t17.id_token AS id_token_18, t17.member_id AS member_id_19, t0.discriminator_type FROM dtb_member t0 LEFT JOIN plg_site_kit_id_token t17 ON t17.member_id = t0.id WHERE t0.login_id = 'yagi' AND t0.work_id = 1 AND t0.discriminator_type IN ('member') LIMIT 1;

UPDATE
  plg_customerrank_dtb_customer_price
SET
  price = ?
WHERE
  id = ?

UPDATE plg_customerrank_dtb_customer_price SET price = 115817 WHERE id = 21728;

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

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

INSERT INTO plg_pia_his_rank_price (
  his_id, customer_rank_id, product_class_id,
  price, before_price
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO plg_pia_his_rank_price (his_id, customer_rank_id, product_class_id, price, before_price) VALUES (64626, 7, 2604, '115724.00', '115750.00');

SELECT
  t0.id AS id_1,
  t0.name01 AS name01_2,
  t0.name02 AS name02_3,
  t0.kana01 AS kana01_4,
  t0.kana02 AS kana02_5,
  t0.company_name AS company_name_6,
  t0.postal_code AS postal_code_7,
  t0.addr01 AS addr01_8,
  t0.addr02 AS addr02_9,
  t0.email AS email_10,
  t0.phone_number AS phone_number_11,
  t0.birth AS birth_12,
  t0.password AS password_13,
  t0.salt AS salt_14,
  t0.secret_key AS secret_key_15,
  t0.first_buy_date AS first_buy_date_16,
  t0.last_buy_date AS last_buy_date_17,
  t0.buy_times AS buy_times_18,
  t0.buy_total AS buy_total_19,
  t0.note AS note_20,
  t0.reset_key AS reset_key_21,
  t0.reset_expire AS reset_expire_22,
  t0.point AS point_23,
  t0.create_date AS create_date_24,
  t0.update_date AS update_date_25,
  t0.plg_mailmagazine_flg AS plg_mailmagazine_flg_26,
  t0.check_date AS check_date_27,
  t0.gmo_epsilon_credit_card_expiration_date AS gmo_epsilon_credit_card_expiration_date_28,
  t0.card_change_request_mail_send_date AS card_change_request_mail_send_date_29,
  t0.customer_type AS customer_type_30,
  t0.customer_status_id AS customer_status_id_31,
  t0.sex_id AS sex_id_32,
  t0.job_id AS job_id_33,
  t0.country_id AS country_id_34,
  t0.pref_id AS pref_id_35,
  t0.customer_rank_id AS customer_rank_id_36,
  t0.discriminator_type
FROM
  dtb_customer t0
WHERE
  t0.id = ?
  AND t0.discriminator_type IN ('customer')

SELECT t0.id AS id_1, t0.name01 AS name01_2, t0.name02 AS name02_3, t0.kana01 AS kana01_4, t0.kana02 AS kana02_5, t0.company_name AS company_name_6, t0.postal_code AS postal_code_7, t0.addr01 AS addr01_8, t0.addr02 AS addr02_9, t0.email AS email_10, t0.phone_number AS phone_number_11, t0.birth AS birth_12, t0.password AS password_13, t0.salt AS salt_14, t0.secret_key AS secret_key_15, t0.first_buy_date AS first_buy_date_16, t0.last_buy_date AS last_buy_date_17, t0.buy_times AS buy_times_18, t0.buy_total AS buy_total_19, t0.note AS note_20, t0.reset_key AS reset_key_21, t0.reset_expire AS reset_expire_22, t0.point AS point_23, t0.create_date AS create_date_24, t0.update_date AS update_date_25, t0.plg_mailmagazine_flg AS plg_mailmagazine_flg_26, t0.check_date AS check_date_27, t0.gmo_epsilon_credit_card_expiration_date AS gmo_epsilon_credit_card_expiration_date_28, t0.card_change_request_mail_send_date AS card_change_request_mail_send_date_29, t0.customer_type AS customer_type_30, t0.customer_status_id AS customer_status_id_31, t0.sex_id AS sex_id_32, t0.job_id AS job_id_33, t0.country_id AS country_id_34, t0.pref_id AS pref_id_35, t0.customer_rank_id AS customer_rank_id_36, t0.discriminator_type FROM dtb_customer t0 WHERE t0.id = '1424' AND t0.discriminator_type IN ('customer');

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.customer_rank_id AS customer_rank_id_3,
  t0.product_class_id AS product_class_id_4,
  t0.discriminator_type
FROM
  plg_customerrank_dtb_customer_price t0
WHERE
  t0.product_class_id = ?
  AND t0.discriminator_type IN ('customerprice')

SELECT t0.id AS id_1, t0.price AS price_2, t0.customer_rank_id AS customer_rank_id_3, t0.product_class_id AS product_class_id_4, t0.discriminator_type FROM plg_customerrank_dtb_customer_price t0 WHERE t0.product_class_id = 2604 AND t0.discriminator_type IN ('customerprice');