Symfony Profiler

SELECT
  count(DISTINCT d0_.id) AS sclr_0
FROM
  dtb_product d0_
  INNER JOIN dtb_product_category d1_ ON d0_.id = d1_.product_id
  AND d1_.discriminator_type IN ('productcategory')
  INNER JOIN dtb_category d2_ ON d1_.category_id = d2_.id
  AND d2_.discriminator_type IN ('category')
  INNER JOIN dtb_product_class d3_ ON d0_.id = d3_.product_id
  AND d3_.discriminator_type IN ('productclass')
WHERE
  (
    d0_.product_status_id = 1
    AND d1_.category_id IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
    )
    AND d3_.visible = 1
  )
  AND d0_.discriminator_type IN ('product')
GROUP BY
  d0_.id

SELECT count(DISTINCT d0_.id) AS sclr_0 FROM dtb_product d0_ INNER JOIN dtb_product_category d1_ ON d0_.id = d1_.product_id AND d1_.discriminator_type IN ('productcategory') INNER JOIN dtb_category d2_ ON d1_.category_id = d2_.id AND d2_.discriminator_type IN ('category') INNER JOIN dtb_product_class d3_ ON d0_.id = d3_.product_id AND d3_.discriminator_type IN ('productclass') WHERE (d0_.product_status_id = 1 AND d1_.category_id IN (9, 21, 130, 131, 132, 133, 134, 135, 493, 494, 136, 137, 138, 139, 22, 140, 141, 142, 143, 144, 145, 146, 23, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 24, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 25, 176, 177, 178, 179, 180, 26, 181, 182, 495, 183, 184, 27, 185, 186, 187, 28, 188, 189, 29, 190, 191, 192, 30, 193, 194, 195, 196, 197, 31, 198, 199, 32, 200, 201, 33, 202, 203, 204, 205, 206, 207, 34, 208, 209, 210, 211, 212, 35, 213, 214, 496, 497, 215, 216, 217, 36, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227) AND d3_.visible = 1) AND d0_.discriminator_type IN ('product') GROUP BY d0_.id;

SELECT
  DISTINCT d0_.id AS id_0,
  MIN(d1_.price02) AS sclr_1,
  d0_.id AS id_2
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 d1_.visible = 1
  )
  AND d0_.discriminator_type IN ('product')
GROUP BY
  d0_.id
ORDER BY
  sclr_1 ASC,
  d0_.id DESC
LIMIT
  20 OFFSET 660

SELECT DISTINCT d0_.id AS id_0, MIN(d1_.price02) AS sclr_1, d0_.id AS id_2 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 (9, 21, 130, 131, 132, 133, 134, 135, 493, 494, 136, 137, 138, 139, 22, 140, 141, 142, 143, 144, 145, 146, 23, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 24, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 25, 176, 177, 178, 179, 180, 26, 181, 182, 495, 183, 184, 27, 185, 186, 187, 28, 188, 189, 29, 190, 191, 192, 30, 193, 194, 195, 196, 197, 31, 198, 199, 32, 200, 201, 33, 202, 203, 204, 205, 206, 207, 34, 208, 209, 210, 211, 212, 35, 213, 214, 496, 497, 215, 216, 217, 36, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227) AND d1_.visible = 1) AND d0_.discriminator_type IN ('product') GROUP BY d0_.id ORDER BY sclr_1 ASC, d0_.id DESC LIMIT 20 OFFSET 660;

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
  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_.product_control_number AS product_control_number_9,
  d0_.sku_control_number AS sku_control_number_10,
  d0_.gmc_product_id AS gmc_product_id_11,
  d0_.free_description_about_quantity AS free_description_about_quantity_12,
  d0_.free_description_about_selling_price AS free_description_about_selling_price_13,
  d0_.free_description_of_payment_delivery AS free_description_of_payment_delivery_14,
  d1_.id AS id_15,
  d1_.product_code AS product_code_16,
  d1_.stock AS stock_17,
  d1_.stock_unlimited AS stock_unlimited_18,
  d1_.sale_limit AS sale_limit_19,
  d1_.price01 AS price01_20,
  d1_.price02 AS price02_21,
  d1_.delivery_fee AS delivery_fee_22,
  d1_.visible AS visible_23,
  d1_.create_date AS create_date_24,
  d1_.update_date AS update_date_25,
  d1_.currency_code AS currency_code_26,
  d1_.point_rate AS point_rate_27,
  d2_.id AS id_28,
  d2_.tax_rate AS tax_rate_29,
  d2_.tax_adjust AS tax_adjust_30,
  d2_.apply_date AS apply_date_31,
  d2_.create_date AS create_date_32,
  d2_.update_date AS update_date_33,
  d3_.id AS id_34,
  d3_.stock AS stock_35,
  d3_.create_date AS create_date_36,
  d3_.update_date AS update_date_37,
  d4_.id AS id_38,
  d4_.backend_name AS backend_name_39,
  d4_.name AS name_40,
  d4_.sort_no AS sort_no_41,
  d4_.visible AS visible_42,
  d4_.create_date AS create_date_43,
  d4_.update_date AS update_date_44,
  d5_.id AS id_45,
  d5_.backend_name AS backend_name_46,
  d5_.name AS name_47,
  d5_.sort_no AS sort_no_48,
  d5_.visible AS visible_49,
  d5_.create_date AS create_date_50,
  d5_.update_date AS update_date_51,
  d6_.id AS id_52,
  d6_.file_name AS file_name_53,
  d6_.sort_no AS sort_no_54,
  d6_.create_date AS create_date_55,
  d7_.id AS id_56,
  d7_.create_date AS create_date_57,
  d0_.discriminator_type AS discriminator_type_58,
  d0_.creator_id AS creator_id_59,
  d0_.product_status_id AS product_status_id_60,
  d1_.discriminator_type AS discriminator_type_61,
  d1_.product_id AS product_id_62,
  d1_.sale_type_id AS sale_type_id_63,
  d1_.class_category_id1 AS class_category_id1_64,
  d1_.class_category_id2 AS class_category_id2_65,
  d1_.delivery_duration_id AS delivery_duration_id_66,
  d1_.creator_id AS creator_id_67,
  d1_.regular_discount_id AS regular_discount_id_68,
  d2_.discriminator_type AS discriminator_type_69,
  d2_.product_class_id AS product_class_id_70,
  d2_.creator_id AS creator_id_71,
  d2_.country_id AS country_id_72,
  d2_.pref_id AS pref_id_73,
  d2_.product_id AS product_id_74,
  d2_.rounding_type_id AS rounding_type_id_75,
  d3_.discriminator_type AS discriminator_type_76,
  d3_.product_class_id AS product_class_id_77,
  d3_.creator_id AS creator_id_78,
  d4_.discriminator_type AS discriminator_type_79,
  d4_.class_name_id AS class_name_id_80,
  d4_.creator_id AS creator_id_81,
  d5_.discriminator_type AS discriminator_type_82,
  d5_.class_name_id AS class_name_id_83,
  d5_.creator_id AS creator_id_84,
  d6_.discriminator_type AS discriminator_type_85,
  d6_.product_id AS product_id_86,
  d6_.creator_id AS creator_id_87,
  d7_.discriminator_type AS discriminator_type_88,
  d7_.product_id AS product_id_89,
  d7_.tag_id AS tag_id_90,
  d7_.creator_id AS creator_id_91
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_tax_rule d2_ ON d1_.id = d2_.product_class_id
  AND d2_.discriminator_type IN ('taxrule')
  INNER JOIN dtb_product_stock d3_ ON d1_.id = d3_.product_class_id
  AND d3_.discriminator_type IN ('productstock')
  LEFT JOIN dtb_class_category d4_ ON d1_.class_category_id1 = d4_.id
  AND d4_.discriminator_type IN ('classcategory')
  LEFT JOIN dtb_class_category d5_ ON d1_.class_category_id2 = d5_.id
  AND d5_.discriminator_type IN ('classcategory')
  LEFT JOIN dtb_product_image d6_ ON d0_.id = d6_.product_id
  AND d6_.discriminator_type IN ('productimage')
  LEFT JOIN dtb_product_tag d7_ ON d0_.id = d7_.product_id
  AND d7_.discriminator_type IN ('producttag')
WHERE
  (
    d0_.id IN (
      11205, 10740, 10734, 11187, 10158, 9997,
      9757, 7283, 7281, 7280, 5619, 11210,
      7959, 8831, 8585, 8584, 5514, 5510,
      11742, 11196
    )
    AND d1_.visible = ?
  )
  AND d0_.discriminator_type IN ('product')
ORDER BY
  d4_.sort_no DESC,
  d5_.sort_no DESC,
  d6_.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_.product_control_number AS product_control_number_9, d0_.sku_control_number AS sku_control_number_10, d0_.gmc_product_id AS gmc_product_id_11, d0_.free_description_about_quantity AS free_description_about_quantity_12, d0_.free_description_about_selling_price AS free_description_about_selling_price_13, d0_.free_description_of_payment_delivery AS free_description_of_payment_delivery_14, d1_.id AS id_15, d1_.product_code AS product_code_16, d1_.stock AS stock_17, d1_.stock_unlimited AS stock_unlimited_18, d1_.sale_limit AS sale_limit_19, d1_.price01 AS price01_20, d1_.price02 AS price02_21, d1_.delivery_fee AS delivery_fee_22, d1_.visible AS visible_23, d1_.create_date AS create_date_24, d1_.update_date AS update_date_25, d1_.currency_code AS currency_code_26, d1_.point_rate AS point_rate_27, d2_.id AS id_28, d2_.tax_rate AS tax_rate_29, d2_.tax_adjust AS tax_adjust_30, d2_.apply_date AS apply_date_31, d2_.create_date AS create_date_32, d2_.update_date AS update_date_33, d3_.id AS id_34, d3_.stock AS stock_35, d3_.create_date AS create_date_36, d3_.update_date AS update_date_37, d4_.id AS id_38, d4_.backend_name AS backend_name_39, d4_.name AS name_40, d4_.sort_no AS sort_no_41, d4_.visible AS visible_42, d4_.create_date AS create_date_43, d4_.update_date AS update_date_44, d5_.id AS id_45, d5_.backend_name AS backend_name_46, d5_.name AS name_47, d5_.sort_no AS sort_no_48, d5_.visible AS visible_49, d5_.create_date AS create_date_50, d5_.update_date AS update_date_51, d6_.id AS id_52, d6_.file_name AS file_name_53, d6_.sort_no AS sort_no_54, d6_.create_date AS create_date_55, d7_.id AS id_56, d7_.create_date AS create_date_57, d0_.discriminator_type AS discriminator_type_58, d0_.creator_id AS creator_id_59, d0_.product_status_id AS product_status_id_60, d1_.discriminator_type AS discriminator_type_61, d1_.product_id AS product_id_62, d1_.sale_type_id AS sale_type_id_63, d1_.class_category_id1 AS class_category_id1_64, d1_.class_category_id2 AS class_category_id2_65, d1_.delivery_duration_id AS delivery_duration_id_66, d1_.creator_id AS creator_id_67, d1_.regular_discount_id AS regular_discount_id_68, d2_.discriminator_type AS discriminator_type_69, d2_.product_class_id AS product_class_id_70, d2_.creator_id AS creator_id_71, d2_.country_id AS country_id_72, d2_.pref_id AS pref_id_73, d2_.product_id AS product_id_74, d2_.rounding_type_id AS rounding_type_id_75, d3_.discriminator_type AS discriminator_type_76, d3_.product_class_id AS product_class_id_77, d3_.creator_id AS creator_id_78, d4_.discriminator_type AS discriminator_type_79, d4_.class_name_id AS class_name_id_80, d4_.creator_id AS creator_id_81, d5_.discriminator_type AS discriminator_type_82, d5_.class_name_id AS class_name_id_83, d5_.creator_id AS creator_id_84, d6_.discriminator_type AS discriminator_type_85, d6_.product_id AS product_id_86, d6_.creator_id AS creator_id_87, d7_.discriminator_type AS discriminator_type_88, d7_.product_id AS product_id_89, d7_.tag_id AS tag_id_90, d7_.creator_id AS creator_id_91 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_tax_rule d2_ ON d1_.id = d2_.product_class_id AND d2_.discriminator_type IN ('taxrule') INNER JOIN dtb_product_stock d3_ ON d1_.id = d3_.product_class_id AND d3_.discriminator_type IN ('productstock') LEFT JOIN dtb_class_category d4_ ON d1_.class_category_id1 = d4_.id AND d4_.discriminator_type IN ('classcategory') LEFT JOIN dtb_class_category d5_ ON d1_.class_category_id2 = d5_.id AND d5_.discriminator_type IN ('classcategory') LEFT JOIN dtb_product_image d6_ ON d0_.id = d6_.product_id AND d6_.discriminator_type IN ('productimage') LEFT JOIN dtb_product_tag d7_ ON d0_.id = d7_.product_id AND d7_.discriminator_type IN ('producttag') WHERE (d0_.id IN (11205, 10740, 10734, 11187, 10158, 9997, 9757, 7283, 7281, 7280, 5619, 11210, 7959, 8831, 8585, 8584, 5514, 5510, 11742, 11196) AND d1_.visible = 1) AND d0_.discriminator_type IN ('product') ORDER BY d4_.sort_no DESC, d5_.sort_no DESC, d6_.sort_no ASC;

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'cpartners_dev'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

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_.product_control_number AS product_control_number_9,
  d0_.sku_control_number AS sku_control_number_10,
  d0_.gmc_product_id AS gmc_product_id_11,
  d0_.free_description_about_quantity AS free_description_about_quantity_12,
  d0_.free_description_about_selling_price AS free_description_about_selling_price_13,
  d0_.free_description_of_payment_delivery AS free_description_of_payment_delivery_14,
  MIN(d1_.price02) AS sclr_15,
  d0_.discriminator_type AS discriminator_type_16,
  d0_.creator_id AS creator_id_17,
  d0_.product_status_id AS product_status_id_18
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 d1_.visible = 1
    AND d0_.id IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?
    )
  )
  AND d0_.discriminator_type IN ('product')
GROUP BY
  d0_.id
ORDER BY
  sclr_15 ASC,
  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_.product_control_number AS product_control_number_9, d0_.sku_control_number AS sku_control_number_10, d0_.gmc_product_id AS gmc_product_id_11, d0_.free_description_about_quantity AS free_description_about_quantity_12, d0_.free_description_about_selling_price AS free_description_about_selling_price_13, d0_.free_description_of_payment_delivery AS free_description_of_payment_delivery_14, MIN(d1_.price02) AS sclr_15, d0_.discriminator_type AS discriminator_type_16, d0_.creator_id AS creator_id_17, d0_.product_status_id AS product_status_id_18 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 (9, 21, 130, 131, 132, 133, 134, 135, 493, 494, 136, 137, 138, 139, 22, 140, 141, 142, 143, 144, 145, 146, 23, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 24, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 25, 176, 177, 178, 179, 180, 26, 181, 182, 495, 183, 184, 27, 185, 186, 187, 28, 188, 189, 29, 190, 191, 192, 30, 193, 194, 195, 196, 197, 31, 198, 199, 32, 200, 201, 33, 202, 203, 204, 205, 206, 207, 34, 208, 209, 210, 211, 212, 35, 213, 214, 496, 497, 215, 216, 217, 36, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227) AND d1_.visible = 1 AND d0_.id IN (11205, 10740, 10734, 11187, 10158, 9997, 9757, 7283, 7281, 7280, 5619, 11210, 7959, 8831, 8585, 8584, 5514, 5510, 11742, 11196)) AND d0_.discriminator_type IN ('product') GROUP BY d0_.id ORDER BY sclr_15 ASC, d0_.id DESC;

SELECT
  DISTINCT k.CONSTRAINT_NAME,
  k.COLUMN_NAME,
  k.REFERENCED_TABLE_NAME,
  k.REFERENCED_COLUMN_NAME,
  k.ORDINAL_POSITION
  /*!50116,
              c.UPDATE_RULE,
              c.DELETE_RULE */
FROM
  information_schema.key_column_usage k
  /*!50116
  INNER JOIN information_schema.referential_constraints c
  ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
  AND c.TABLE_NAME = k.TABLE_NAME */
WHERE
  k.TABLE_SCHEMA = ?
  AND k.TABLE_NAME = ?
  AND k.REFERENCED_COLUMN_NAME IS NOT NULL
  /*!50116 AND c.CONSTRAINT_SCHEMA = 'cpartners_dev' */
ORDER BY
  k.ORDINAL_POSITION

SELECT DISTINCT            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION /*!50116,
            c.UPDATE_RULE,
            c.DELETE_RULE */
FROM information_schema.key_column_usage k /*!50116
INNER JOIN information_schema.referential_constraints c
ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = 'cpartners_dev' AND k.TABLE_NAME = 'doctrine_migration_versions' AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'cpartners_dev' */ ORDER BY k.ORDINAL_POSITION;