商品一覧
商品が見つかりませんでした。
[Product Model Constructor Debug]
PDO instance status: bool(true)
[Product Model Debug] getPaginatedProductsByLabel result:
SQL Query: SELECT p.*, GROUP_CONCAT(c.name SEPARATOR ', ') AS category_names, -- 複数のカテゴリ名を結合 l.name AS label_name FROM products p LEFT JOIN product_categories pc ON p.id = pc.product_id -- 中間テーブルをJOIN LEFT JOIN categories c ON pc.category_id = c.id LEFT JOIN labels l ON p.label_id = l.id WHERE p.label_id = :label_id AND p.status = 'published' GROUP BY p.id ORDER BY p.created_at DESC LIMIT :limit OFFSET :offset Bound Params: LabelID=1, Limit=10, Offset=70 Result Count: 0 Result: Array ( )
[Product Model Debug] getTotalProductsCountByLabel:
SQL Query: SELECT COUNT(id) FROM products WHERE label_id = :label_id AND status = 'published' Bound Params: LabelID=1 Result Count: 3
商品が見つかりませんでした。