商品一覧ページで商品リストを取得しているSQL

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, 
  MIN(d1_.price02) AS sclr_9, 
  d0_.discriminator_type AS discriminator_type_10, 
  d0_.creator_id AS creator_id_11, 
  d0_.product_status_id AS product_status_id_12 
FROM 
  dtb_product d0_ 
  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') 
  INNER JOIN dtb_product_class d1_ ON d0_.id = d1_.product_id 
  AND d1_.discriminator_type IN ('productclass') 
WHERE 
  (
    d0_.product_status_id = 1 
    AND d2_.category_id IN (?) 
    AND (
      CONVERT(d0_.name USING utf8) COLLATE utf8_unicode_ci LIKE CONVERT(? USING utf8) COLLATE utf8_unicode_ci 
      OR CONVERT(d0_.search_word USING utf8) COLLATE utf8_unicode_ci LIKE CONVERT(? USING utf8) COLLATE utf8_unicode_ci 
      OR EXISTS (
        SELECT 
          d4_.id 
        FROM 
          dtb_product_class d4_ 
        WHERE 
          (
            d0_.id = d4_.product_id 
            AND CONVERT(d4_.product_code USING utf8) COLLATE utf8_unicode_ci LIKE CONVERT(? USING utf8) COLLATE utf8_unicode_ci
          ) 
          AND d4_.discriminator_type IN ('productclass')
      ) 
      OR EXISTS (
        SELECT 
          d5_.id 
        FROM 
          dtb_product_tag d5_ 
        WHERE 
          (
            d0_.id = d5_.product_id 
            AND d5_.tag_id IN (
              SELECT 
                d6_.id 
              FROM 
                dtb_tag d6_ 
              WHERE 
                (
                  CONVERT(d6_.name USING utf8) COLLATE utf8_unicode_ci LIKE CONVERT(? USING utf8) COLLATE utf8_unicode_ci
                ) 
                AND d6_.discriminator_type IN ('tag')
            )
          ) 
          AND d5_.discriminator_type IN ('producttag')
      )
    ) 
    AND d1_.visible = 1 
    AND d0_.id IN (?)
  ) 
  AND d0_.discriminator_type IN ('product') 
GROUP BY 
  d0_.id 
ORDER BY 
  sclr_9 ASC, 
  d0_.id DESC
  
Parameters:
[[1
    3
    4
  ]
  "%CUBE%"
  "%CUBE%"
  "%CUBE%"
  "%CUBE%"
  [1
  ]
]