Symfony Profiler

SET
  SESSION time_zone = '+00:00'

SET SESSION time_zone = '+00:00';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sort_no AS sort_no_3,
  t0.discriminator_type
FROM
  mtb_sale_type t0
WHERE
  t0.name = ?
  AND t0.discriminator_type IN ('saletype')
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.discriminator_type FROM mtb_sale_type t0 WHERE t0.name = 'ダウンロードコンテンツ' AND t0.discriminator_type IN ('saletype') LIMIT 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.ga_id AS ga_id_35,
  t0.product_bcc01 AS product_bcc01_36,
  t0.product_bcc02 AS product_bcc02_37,
  t0.product_bcc03 AS product_bcc03_38,
  t0.product_bcc04 AS product_bcc04_39,
  t0.product_bcc05 AS product_bcc05_40,
  t0.download_bcc01 AS download_bcc01_41,
  t0.download_bcc02 AS download_bcc02_42,
  t0.download_bcc03 AS download_bcc03_43,
  t0.download_bcc04 AS download_bcc04_44,
  t0.download_bcc05 AS download_bcc05_45,
  t0.contact_bcc01 AS contact_bcc01_46,
  t0.contact_bcc02 AS contact_bcc02_47,
  t0.contact_bcc03 AS contact_bcc03_48,
  t0.contact_bcc04 AS contact_bcc04_49,
  t0.contact_bcc05 AS contact_bcc05_50,
  t0.contact_bcc06 AS contact_bcc06_51,
  t0.contact_bcc07 AS contact_bcc07_52,
  t0.contact_bcc08 AS contact_bcc08_53,
  t0.contact_bcc09 AS contact_bcc09_54,
  t0.contact_bcc10 AS contact_bcc10_55,
  t0.addr03 AS addr03_56,
  t0.site_kit_site_id AS site_kit_site_id_57,
  t0.site_kit_site_secret AS site_kit_site_secret_58,
  t0.country_id AS country_id_59,
  t0.pref_id AS pref_id_60,
  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.ga_id AS ga_id_35, t0.product_bcc01 AS product_bcc01_36, t0.product_bcc02 AS product_bcc02_37, t0.product_bcc03 AS product_bcc03_38, t0.product_bcc04 AS product_bcc04_39, t0.product_bcc05 AS product_bcc05_40, t0.download_bcc01 AS download_bcc01_41, t0.download_bcc02 AS download_bcc02_42, t0.download_bcc03 AS download_bcc03_43, t0.download_bcc04 AS download_bcc04_44, t0.download_bcc05 AS download_bcc05_45, t0.contact_bcc01 AS contact_bcc01_46, t0.contact_bcc02 AS contact_bcc02_47, t0.contact_bcc03 AS contact_bcc03_48, t0.contact_bcc04 AS contact_bcc04_49, t0.contact_bcc05 AS contact_bcc05_50, t0.contact_bcc06 AS contact_bcc06_51, t0.contact_bcc07 AS contact_bcc07_52, t0.contact_bcc08 AS contact_bcc08_53, t0.contact_bcc09 AS contact_bcc09_54, t0.contact_bcc10 AS contact_bcc10_55, t0.addr03 AS addr03_56, t0.site_kit_site_id AS site_kit_site_id_57, t0.site_kit_site_secret AS site_kit_site_secret_58, t0.country_id AS country_id_59, t0.pref_id AS pref_id_60, t0.discriminator_type FROM dtb_base_info t0 WHERE t0.id = 1 AND t0.discriminator_type IN ('baseinfo');

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 = 'sitemap_xml') AND d0_.discriminator_type IN ('page');

SET
  SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED

SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;

"START TRANSACTION"

"START TRANSACTION";

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,
  d0_.discriminator_type AS discriminator_type_12,
  d0_.master_page_id AS master_page_id_13
FROM
  dtb_page d0_
WHERE
  (
    (
      (
        (
          d0_.meta_robots NOT LIKE '%noindex%'
          AND d0_.meta_robots NOT LIKE '%none%'
        )
        OR d0_.meta_robots IS NULL
      )
    )
    AND d0_.id <> 0
    AND d0_.master_page_id IS NULL
  )
  AND d0_.discriminator_type IN ('page')
ORDER BY
  d0_.update_date DESC
LIMIT
  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, d0_.discriminator_type AS discriminator_type_12, d0_.master_page_id AS master_page_id_13 FROM dtb_page d0_ WHERE ((((d0_.meta_robots NOT LIKE '%noindex%' AND d0_.meta_robots NOT LIKE '%none%') OR d0_.meta_robots IS NULL)) AND d0_.id <> 0 AND d0_.master_page_id IS NULL) AND d0_.discriminator_type IN ('page') ORDER BY d0_.update_date DESC LIMIT 1;

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.is_reservation AS is_reservation_10,
  t0.ci_name AS ci_name_11,
  t0.cscl AS cscl_12,
  t0.form AS form_13,
  t0.usage_proof_flag AS usage_proof_flag_14,
  t0.version AS version_15,
  t0.plg_dlc_content_name AS plg_dlc_content_name_16,
  t0.plg_dlc_save_name AS plg_dlc_save_name_17,
  t0.display_rank AS display_rank_18,
  t0.creator_id AS creator_id_19,
  t0.product_status_id AS product_status_id_20,
  t0.product_type_id AS product_type_id_21,
  t0.product_color_id AS product_color_id_22,
  t0.previous_version_id AS previous_version_id_23,
  t0.related_key_id AS related_key_id_24,
  t0.discriminator_type
FROM
  dtb_product t0
WHERE
  t0.product_status_id = ?
  AND t0.discriminator_type IN ('product')
ORDER BY
  t0.update_date DESC
LIMIT
  1

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.is_reservation AS is_reservation_10, t0.ci_name AS ci_name_11, t0.cscl AS cscl_12, t0.form AS form_13, t0.usage_proof_flag AS usage_proof_flag_14, t0.version AS version_15, t0.plg_dlc_content_name AS plg_dlc_content_name_16, t0.plg_dlc_save_name AS plg_dlc_save_name_17, t0.display_rank AS display_rank_18, t0.creator_id AS creator_id_19, t0.product_status_id AS product_status_id_20, t0.product_type_id AS product_type_id_21, t0.product_color_id AS product_color_id_22, t0.previous_version_id AS previous_version_id_23, t0.related_key_id AS related_key_id_24, t0.discriminator_type FROM dtb_product t0 WHERE t0.product_status_id = 1 AND t0.discriminator_type IN ('product') ORDER BY t0.update_date DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.file_name AS file_name_2,
  t0.content_name AS content_name_3,
  t0.sort_no AS sort_no_4,
  t0.create_date AS create_date_5,
  t0.product_id AS product_id_6,
  t0.creator_id AS creator_id_7,
  t0.discriminator_type
FROM
  plg_dlc_product_dlc t0
WHERE
  t0.product_id = ?
  AND t0.discriminator_type IN ('productdlc')

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.content_name AS content_name_3, t0.sort_no AS sort_no_4, t0.create_date AS create_date_5, t0.product_id AS product_id_6, t0.creator_id AS creator_id_7, t0.discriminator_type FROM plg_dlc_product_dlc t0 WHERE t0.product_id = 1644 AND t0.discriminator_type IN ('productdlc');

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.id = ?
  AND t0.discriminator_type IN ('productlistorderby')

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.id = 2 AND t0.discriminator_type IN ('productlistorderby');

SELECT
  t0.id AS id_1,
  t0.product_list_order_by_id AS product_list_order_by_id_2,
  t0.type AS type_3,
  t0.second_sort_type AS second_sort_type_4,
  t0.third_sort_type AS third_sort_type_5,
  t0.name AS name_6,
  t0.default_rank_type AS default_rank_type_7,
  t0.csv_import_default_rank AS csv_import_default_rank_8,
  t0.block_display_number AS block_display_number_9
FROM
  plg_product_display_rank42_config t0
WHERE
  t0.product_list_order_by_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.product_list_order_by_id AS product_list_order_by_id_2, t0.type AS type_3, t0.second_sort_type AS second_sort_type_4, t0.third_sort_type AS third_sort_type_5, t0.name AS name_6, t0.default_rank_type AS default_rank_type_7, t0.csv_import_default_rank AS csv_import_default_rank_8, t0.block_display_number AS block_display_number_9 FROM plg_product_display_rank42_config t0 WHERE t0.product_list_order_by_id = 2 LIMIT 1;

SELECT
  count(DISTINCT d0_.id) AS sclr_0
FROM
  dtb_product d0_
WHERE
  (d0_.product_status_id = 1)
  AND d0_.discriminator_type IN ('product')

SELECT count(DISTINCT d0_.id) AS sclr_0 FROM dtb_product d0_ WHERE (d0_.product_status_id = 1) AND d0_.discriminator_type IN ('product');

SELECT
  DISTINCT d0_.id AS id_0,
  d0_.create_date AS create_date_1,
  d0_.id AS id_2
FROM
  dtb_product d0_
WHERE
  (d0_.product_status_id = 1)
  AND d0_.discriminator_type IN ('product')
ORDER BY
  d0_.create_date DESC,
  d0_.id DESC
LIMIT
  1000

SELECT DISTINCT d0_.id AS id_0, d0_.create_date AS create_date_1, d0_.id AS id_2 FROM dtb_product d0_ WHERE (d0_.product_status_id = 1) AND d0_.discriminator_type IN ('product') ORDER BY d0_.create_date DESC, d0_.id DESC LIMIT 1000;

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_.is_reservation AS is_reservation_9,
  d0_.ci_name AS ci_name_10,
  d0_.cscl AS cscl_11,
  d0_.form AS form_12,
  d0_.usage_proof_flag AS usage_proof_flag_13,
  d0_.version AS version_14,
  d0_.plg_dlc_content_name AS plg_dlc_content_name_15,
  d0_.plg_dlc_save_name AS plg_dlc_save_name_16,
  d0_.display_rank AS display_rank_17,
  d0_.discriminator_type AS discriminator_type_18,
  d0_.creator_id AS creator_id_19,
  d0_.product_status_id AS product_status_id_20,
  d0_.product_type_id AS product_type_id_21,
  d0_.product_color_id AS product_color_id_22,
  d0_.previous_version_id AS previous_version_id_23,
  d0_.related_key_id AS related_key_id_24
FROM
  dtb_product d0_
WHERE
  (
    d0_.product_status_id = 1
    AND d0_.id IN (
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?
    )
  )
  AND d0_.discriminator_type IN ('product')
ORDER BY
  d0_.create_date DESC,
  d0_.id 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_.is_reservation AS is_reservation_9, d0_.ci_name AS ci_name_10, d0_.cscl AS cscl_11, d0_.form AS form_12, d0_.usage_proof_flag AS usage_proof_flag_13, d0_.version AS version_14, d0_.plg_dlc_content_name AS plg_dlc_content_name_15, d0_.plg_dlc_save_name AS plg_dlc_save_name_16, d0_.display_rank AS display_rank_17, d0_.discriminator_type AS discriminator_type_18, d0_.creator_id AS creator_id_19, d0_.product_status_id AS product_status_id_20, d0_.product_type_id AS product_type_id_21, d0_.product_color_id AS product_color_id_22, d0_.previous_version_id AS previous_version_id_23, d0_.related_key_id AS related_key_id_24 FROM dtb_product d0_ WHERE (d0_.product_status_id = 1 AND d0_.id IN (1645, 1644, 1643, 1642, 1641, 1640, 1639, 1638, 1637, 1636, 1635, 1634, 1633, 1632, 1631, 1630, 1629, 1628, 1627, 1626, 1625, 1624, 1623, 1622, 1621, 1620, 1619, 1618, 1617, 1616, 1615, 1614, 1613, 1612, 1611, 1610, 1609, 1608, 1607, 1606, 1605, 1604, 1603, 1602, 1601, 1600, 1599, 1598, 1597, 1596, 1595, 1594, 1593, 1592, 1591, 1590, 1589, 1588, 1587, 1586, 1585, 1584, 1583, 1582, 1581, 1580, 1579, 1578, 1577, 1576, 1575, 1574, 1573, 1572, 1571, 1570, 1569, 1568, 1567, 1566, 1565, 1564, 1563, 1562, 1561, 1560, 1559, 1558, 1557, 1556, 1555, 1554, 1553, 1552, 1551, 1550, 1549, 1548, 1547, 1546, 1545, 1544, 1543, 1542, 1541, 1540, 1539, 1538, 1537, 1536, 1535, 1534, 1533, 1532, 1531, 1530, 1529, 1528, 1527, 1526, 1525, 1524, 1523, 1522, 1521, 1520, 1519, 1518, 1517, 1516, 1515, 1514, 1513, 1512, 1511, 1510, 1509, 1508, 1507, 1506, 1505, 1504, 1503, 1502, 1501, 1500, 1499, 1498, 1497, 1496, 1495, 1494, 1493, 1492, 1491, 1490, 1489, 1488, 1487, 1484, 1483, 1482, 1481, 1479, 1478, 1477, 1476, 1474, 1473, 1472, 1471, 1469, 1468, 1467, 1464, 1463, 1460, 1454, 1453, 1450, 1449, 1448, 1447, 1446, 1445, 1444, 1443, 1442, 1441, 1440, 1439, 1438, 1437, 1436, 1435, 1434, 1433, 1432, 1431, 1430, 1429, 1428, 1427, 1426, 1425, 1424, 1423, 1422, 1421, 1420, 1419, 1418, 1417, 1416, 1415, 1414, 1413, 1412, 1411, 1410, 1409, 1408, 1407, 1406, 1405, 1404, 1403, 1402, 1401, 1400, 1399, 1398, 1397, 1396, 1395, 1394, 1393, 1392, 1391, 1390, 1389, 1388, 1387, 1386, 1385, 1384, 1383, 1382, 1381, 1380, 1379, 1378, 1377, 1376, 1375, 1373, 1372, 1371, 1370, 1369, 1368, 1367, 1366, 1365, 1364, 1363, 1362, 1361, 1360, 1359, 1358, 1357, 1356, 1355, 1354, 1353, 1352, 1351, 1350, 1349, 1348, 1347, 1346, 1345, 1344, 1343, 1342, 1341, 1340, 1339, 1338, 1337, 1336, 1335, 1334, 1333, 1332, 1331, 1329, 1328, 1327, 1326, 1325, 1324, 1323, 1322, 1321, 1320, 1319, 1318, 1317, 1316, 1315, 1314, 1313, 1312, 1311, 1310, 1309, 1308, 1307, 1304, 492, 491, 490, 488, 467, 393, 389, 388, 387, 386, 385, 384, 383, 382, 381, 380, 379, 378, 377, 376, 375, 373, 371, 370, 369, 368, 367, 366, 365, 364, 363, 362, 361, 360, 359, 358, 357, 356, 355, 354, 353, 352, 351, 350, 349, 348, 347, 346, 345, 344, 343, 342, 341, 340, 339, 338, 337, 336, 335, 334, 333, 332, 331, 330, 329, 328, 327, 326, 325, 324, 323, 319, 318, 317, 316, 315, 314, 313, 312, 311, 310, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 297, 296, 295, 294, 293, 292, 291, 290, 289, 288, 287, 286, 285, 284, 283, 282, 281, 280, 279, 278, 277, 276, 275, 274, 273, 272, 271, 270, 269, 268, 267, 266, 265, 264, 263, 262, 261, 260, 252, 249, 247, 245, 243, 241, 239, 237, 235, 233, 232, 229, 227, 225, 223, 221, 219, 217, 215, 213, 211, 209, 207, 199, 197, 195, 194, 193, 183, 179, 178, 177, 176, 175, 174, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 152, 151, 150, 147, 136, 135, 134, 133, 131, 130, 129, 128, 125, 124, 123, 122, 121, 120, 119, 118, 117, 116, 114, 113, 111, 110, 109, 108, 107, 106, 104, 102, 101, 99, 98, 97, 96, 94, 92, 91, 90, 89, 87, 86, 85, 83, 82, 81, 79, 78, 77, 76, 75, 74, 67, 64, 63, 62, 61, 60, 59, 58, 56, 55, 53, 52, 51, 50, 44, 43, 40, 38, 37, 36, 32, 31, 29, 27, 25, 24, 22, 21, 18, 16, 15, 14, 13, 12, 9, 8, 6)) AND d0_.discriminator_type IN ('product') ORDER BY d0_.create_date DESC, d0_.id DESC;