http://tcg-mana.com/products/list?category_id=708

Dumped Contents

null
0 of 0
array:11 [ "mode" => null "category_id" => Eccube\Entity\Category {#7675 -id: 708 -name: "予約ボックス" -hierarchy: 1 -sort_no: 1 -create_date: DateTime @1740791889 {#7673 date: 2025-03-01 10:18:09.0 Asia/Tokyo (+09:00) } -update_date: DateTime @1740985311 {#7674 date: 2025-03-03 16:01:51.0 Asia/Tokyo (+09:00) } -ProductCategories: Doctrine\ORM\PersistentCollection {#7676 -snapshot: [] -owner: Eccube\Entity\Category {#7675} -association: array:15 [ …15] -em: Doctrine\ORM\EntityManager {#507 …11} -backRefFieldName: "Category" -typeClass: Doctrine\ORM\Mapping\ClassMetadata {#4293 …} -isDirty: false #collection: Doctrine\Common\Collections\ArrayCollection {#7677 -elements: [] } #initialized: false } -Children: Doctrine\ORM\PersistentCollection {#7679 -snapshot: [] -owner: Eccube\Entity\Category {#7675} -association: array:16 [ …16] -em: Doctrine\ORM\EntityManager {#507 …11} -backRefFieldName: "Parent" -typeClass: Doctrine\ORM\Mapping\ClassMetadata {#4040 …} -isDirty: false #collection: Doctrine\Common\Collections\ArrayCollection {#7678 -elements: [] } #initialized: true } -Parent: null -Creator: Proxies\__CG__\Eccube\Entity\Member {#4553 +__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 {#4262 #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 DESCSELECT 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_.s"