Symfony Profiler

null

array:11 [
  "mode" => null
  "category_id" => Eccube\Entity\Category {#8134
    -id: 707
    -name: "新品ボックス"
    -hierarchy: 1
    -sort_no: 74
    -create_date: DateTime @1740791876 {#8132
      date: 2025-03-01 10:17:56.0 Asia/Tokyo (+09:00)
    }
    -update_date: DateTime @1740985311 {#8133
      date: 2025-03-03 16:01:51.0 Asia/Tokyo (+09:00)
    }
    -ProductCategories: Doctrine\ORM\PersistentCollection {#8135
      -snapshot: []
      -owner: Eccube\Entity\Category {#8134}
      -association: array:15 [ …15]
      -em: Doctrine\ORM\EntityManager {#507 …11}
      -backRefFieldName: "Category"
      -typeClass: Doctrine\ORM\Mapping\ClassMetadata {#4297 …}
      -isDirty: false
      #collection: Doctrine\Common\Collections\ArrayCollection {#8136
        -elements: []
      }
      #initialized: false
    }
    -Children: Doctrine\ORM\PersistentCollection {#8138
      -snapshot: []
      -owner: Eccube\Entity\Category {#8134}
      -association: array:16 [ …16]
      -em: Doctrine\ORM\EntityManager {#507 …11}
      -backRefFieldName: "Parent"
      -typeClass: Doctrine\ORM\Mapping\ClassMetadata {#4044 …}
      -isDirty: false
      #collection: Doctrine\Common\Collections\ArrayCollection {#8137
        -elements: []
      }
      #initialized: true
    }
    -Parent: null
    -Creator: Proxies\__CG__\Eccube\Entity\Member {#4557
      +__isInitialized__: false
      -id: 1
      -name: null
      -department: null
      -login_id: null
      -plainPassword: null
      -password: null
      -salt: null
      -sort_no: null
      -two_factor_auth_key: null
      -two_factor_auth_enabled: false
      -create_date: null
      -update_date: null
      -login_date: null
      -Work: null
      -Authority: null
      -Creator: null
       …2
    }
    -free_area: null
    -category_image: null
  }
  "name" => null
  "pageno" => "1"
  "disp_number" => Eccube\Entity\Master\ProductListMax {#4266
    #id: 20
    #name: "15件"
    #sort_no: 0
  }
  "tag_id" => null
  "tag_id2" => null
  "category_id2" => null
  "category_id3" => null
  "category_id4" => null
  "category_id5" => null
]

"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_.free_description_about_quantity AS free_description_about_quantity_9, d0_.free_description_about_selling_price AS free_description_about_selling_price_10, d0_.free_description_of_payment_delivery AS free_description_of_payment_delivery_11, CASE WHEN d1_.recommend_rank IS NULL THEN 0 ELSE d1_.recommend_rank END AS sclr_12, d0_.discriminator_type AS discriminator_type_13, d0_.creator_id AS creator_id_14, d0_.product_status_id AS product_status_id_15 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_category d1_ ON d0_.id = d1_.product_id AND d1_.discriminator_type IN ('productcategory') WHERE (d0_.product_status_id = 1 AND d2_.category_id IN (?) AND d1_.category_id = ?) AND d0_.discriminator_type IN ('product') ORDER BY sclr_12 DESC, d0_.id DESC"