상품 전체 조회

• offset (필수)
• 상품 번호(index)
• 0부터 시작

• limit (필수)
• 한번에 받아오는 상품 개수
• 1부터 시작

• sort (선택)
• 정렬 조건
• 종료 임박순: END_DATE_ASC
• 정렬 조건 안보내주면 기본으로 종료 임박순 정렬

요청

Get api/v1/products?offset=&limit=&sort

응답

200 OK
[
	{
		"id": Number,
		"title": String,
		"thumbnailImage": String,
		"minimumPrice": Number,
		"heartCount" : Number,
		"expireAt": Date,
		"createdAt": Date,
		"updatedAt": Date,
	},
	{} // 유사 데이터 limit 개수만큼 반환
]	

Update History

update bidding set won=0 where id=3;
update bidding set won=0 where id=4;
update bidding set won=0 where id=5;
update bidding set won=0 where id=6;
update bidding set won=0 where id=7;
update bidding set won=0 where id=8;
update bidding set won=0 where id=9;
update bidding set won=0 where id=10;
update bidding set won=0 where id=11;
update bidding set won=0 where id=12;
update bidding set won=0 where id=13;
update bidding set won=0 where id=14;

update product set progressed=1 where id=4;
update product set progressed=1 where id=5;
update product set progressed=1 where id=6;
update product set progressed=1 where id=7;
update product set progressed=1 where id=8;
update product set progressed=1 where id=9;
update product set progressed=1 where id=10;
update product set progressed=1 where id=11;
update product set progressed=1 where id=12;
update product set progressed=1 where id=13;
update product set progressed=1 where id=14;
update product set progressed=1 where id=15;
update product set progressed=1 where id=16;
update product set progressed=1 where id=17;
update product set progressed=1 where id=18;
update product set progressed=1 where id=19;
update product set progressed=1 where id=20;


update product set expire_at='2022-08-16T22:00:00' where id=4;
update product set expire_at='2022-08-16T22:05:00' where id=5;
update product set expire_at='2022-08-16T22:10:00' where id=6;
update product set expire_at='2022-08-16T22:15:00' where id=7;
update product set expire_at='2022-08-16T22:20:00' where id=8;
update product set expire_at='2022-08-16T22:25:00' where id=9;
update product set expire_at='2022-08-16T22:30:00' where id=10;
update product set expire_at='2022-08-16T22:35:00' where id=11;
update product set expire_at='2022-08-16T22:40:00' where id=12;
update product set expire_at='2022-08-16T22:45:00' where id=13;
update product set expire_at='2022-08-16T22:50:00' where id=14;
update product set expire_at='2022-08-16T22:55:00' where id=16;
update product set expire_at='2022-08-16T23:00:00' where id=17;
update product set expire_at='2022-08-16T22:05:00' where id=18;
update product set expire_at='2022-08-16T22:10:00' where id=19;
update product set expire_at='2022-08-16T22:15:00' where id=20;

update bidding set won=0 where id=1;
update bidding set won=0 where id=2;
update bidding set won=0 where id=3;
update bidding set won=0 where id=4;
update bidding set won=0 where id=5;
update bidding set won=0 where id=6;
update bidding set won=0 where id=7;
update bidding set won=0 where id=8;
update bidding set won=0 where id=9;
update bidding set won=0 where id=10;
update bidding set won=0 where id=11;
update bidding set won=0 where id=12;
update bidding set won=0 where id=13;
update bidding set won=0 where id=14;

update product set progressed=1 where id=1;
update product set progressed=1 where id=2;
update product set progressed=1 where id=3;
update product set progressed=1 where id=4;
update product set progressed=1 where id=5;
update product set progressed=1 where id=6;
update product set progressed=1 where id=7;
update product set progressed=1 where id=8;
update product set progressed=1 where id=9;
update product set progressed=1 where id=10;
update product set progressed=1 where id=11;
update product set progressed=1 where id=12;
update product set progressed=1 where id=13;
update product set progressed=1 where id=14;
update product set progressed=1 where id=15;
update product set progressed=1 where id=16;
update product set progressed=1 where id=17;
update product set progressed=1 where id=18;
update product set progressed=1 where id=19;
update product set progressed=1 where id=20;

update product set expire_at='2022-08-16T12:45:00' where id=1;
update product set expire_at='2022-08-16T14:45:00' where id=2;
update product set expire_at='2022-08-16T14:40:00' where id=3;
update product set expire_at='2022-08-16T13:08:00' where id=4;
update product set expire_at='2022-08-16T14:25:00' where id=5;
update product set expire_at='2022-08-16T14:30:00' where id=6;
update product set expire_at='2022-08-16T14:45:00' where id=7;
update product set expire_at='2022-08-16T14:50:00' where id=8;
update product set expire_at='2022-08-16T14:55:00' where id=9;
update product set expire_at='2022-08-16T15:00:00' where id=10;
update product set expire_at='2022-08-16T15:05:00' where id=11;
update product set expire_at='2022-08-16T15:10:00' where id=12;
update product set expire_at='2022-08-16T15:15:00' where id=13;
update product set expire_at='2022-08-16T15:20:00' where id=14;
update product set expire_at='2022-08-16T15:25:00' where id=16;
update product set expire_at='2022-08-16T15:30:00' where id=17;
update product set expire_at='2022-08-16T15:35:00' where id=18;
update product set expire_at='2022-08-16T15:40:00' where id=19;
update product set expire_at='2022-08-16T15:45:00' where id=20;

delete from notification


INSERT INTO `product`(title, `description`, minimum_price, category, location, thumbnail_image,
                      progressed, expire_at, created_at, user_id)
VALUES ('M1 맥북프로 13',
        'M1 MacBook Pro 13인치 판매합니다.

회사에서 사용하던 제품이라 상태 좋고, 초기화 되어 있습니다.

[사양]
- Apple M1 CPU
- 16GB 메모리
- 256GB SSD
- 배터리 (57 Cycle, 100%)

[구성]
- 맥북
- 전원선

회사에서 판매하는 제품이라 삼성중앙역에서만 거래가 가능합니다.

전자제품 특성상 교환 및 취소가 어렵습니다.',
        600000, 'DIGITAL_DEVICE', '제주 서귀포시 동홍동',
        'https://dnvefa72aowie.cloudfront.net/origin/article/202207/adf7131956708b6221ff430f840e75f0065fd0fc1edbaa9219f9eac4bd50da5b.webp?q=95&s=1440x1440&t=inside',
        1, '2022-08-16T15:00:00', '2022-07-21T14:47:00', 1);

INSERT INTO `image`(product_id,url,`order`,created_at)
VALUES (22, 'https://dnvefa72aowie.cloudfront.net/origin/article/202208/3B9C765977DDA3BA01683373256143F97458ADD5F253360D13C1B4CD77B341B6.jpg?q=95&s=1440x1440&t=inside', 1, '2022-07-21T14:47:00'),
       (22, 'https://dnvefa72aowie.cloudfront.net/origin/article/202208/70822C695D2063100540D26817B146537225C3C3ACDCDE3039DB15D23BE976A1.jpg?q=95&s=1440x1440&t=inside', 2, '2022-07-21T14:47:00'),
       (22, 'https://dnvefa72aowie.cloudfront.net/origin/article/202208/718127C8D042E8C65D30D6F2AE74F5868630CB8AFB4B3BACC08941CC44B0ACB7.jpg?q=95&s=1440x1440&t=inside', 3, '2022-07-21T14:47:00'),
       (23, 'https://dnvefa72aowie.cloudfront.net/origin/article/202208/9DDD5323ED031EE166BC2952FFC560F99BD61DCD8B50DE943BD1728BA37817AA.jpg?q=95&s=1440x1440&t=inside', 1, '2022-07-21T14:47:00'),
       (23, 'https://dnvefa72aowie.cloudfront.net/origin/article/202208/E9CD41986EC23E8E7DD6451502CC596787F59A0CC41CF5CD7EAD01BC25A3DC87.jpg?q=95&s=1440x1440&t=inside', 2, '2022-07-21T14:47:00'),
       (23, 'https://dnvefa72aowie.cloudfront.net/origin/article/202208/076CF2B8987D36C61C1480856DE886E5F51B6AEF1C4C57C5F42CE69E8F3F9966.jpg?q=95&s=1440x1440&t=inside', 3, '2022-07-21T14:47:00'),
       (24, 'https://dnvefa72aowie.cloudfront.net/origin/article/202208/E01F44797D5524AFD297AB93F08F127EA387FC22DC10406945935F20984F119A.jpg?q=95&s=1440x1440&t=inside', 1, '2022-07-21T14:47:00'),
       (24, 'https://dnvefa72aowie.cloudfront.net/origin/article/202208/EB72F0C2A0FC4D79C7E5486C436B1C588BD265F47BF034F675F4DFE0BF8FF669.jpg?q=95&s=1440x1440&t=inside', 2, '2022-07-21T14:47:00'),
       (24, 'https://dnvefa72aowie.cloudfront.net/origin/article/202208/3904708EC6A742AEB046818BE661FCFE2025119784E09C3CC212F52F5ED04D45.jpg?q=95&s=1440x1440&t=inside', 3, '2022-07-21T14:47:00'),
       (25, 'https://dnvefa72aowie.cloudfront.net/origin/article/202208/5715942d2452d81b2f3f343da64c90715c306684f90ba1faa8498016103317ce.webp?q=95&s=1440x1440&t=inside', 1, '2022-07-21T14:47:00'),
       (25, 'https://dnvefa72aowie.cloudfront.net/origin/article/202208/2bcebc7e236997f7306f634c8138646c996a22c6e349a74257beeb08e851fd0c.webp?q=95&s=1440x1440&t=inside', 2, '2022-07-21T14:47:00'),
       (25, 'https://dnvefa72aowie.cloudfront.net/origin/article/202208/f028e491339f6f401c4347a3c0875819e1ae54921a925e622f851efcc6bf01be.webp?q=95&s=1440x1440&t=inside', 3, '2022-07-21T14:47:00'),
       (26, 'https://dnvefa72aowie.cloudfront.net/origin/article/202208/BB122B43923AF9B8EEA5E10F68A5913A1D1B7890959544FBBC5374725A6414E2.jpg?q=95&s=1440x1440&t=inside', 1, '2022-07-21T14:47:00'),
       (26, 'https://dnvefa72aowie.cloudfront.net/origin/article/202208/09CAFF7CDA763C3BCD8FD8890FFAD16F38E34A605550A2EBFF310178DCBEB9AA.jpg?q=95&s=1440x1440&t=inside', 2, '2022-07-21T14:47:00'),
       (26, 'https://dnvefa72aowie.cloudfront.net/origin/article/202208/23752B990F3797D005D76641D1B8BA72947407CBD4DAB5675A38A64E37D05E94.jpg?q=95&s=1440x1440&t=inside', 3, '2022-07-21T14:47:00'),
       (27, 'https://dnvefa72aowie.cloudfront.net/origin/article/202208/1BA62D3AEB67E2E2997052F03794B527385690106179C954E55C1A2F122345F9.jpg?q=95&s=1440x1440&t=inside', 1, '2022-07-21T14:47:00'),
       (27, 'https://dnvefa72aowie.cloudfront.net/origin/article/202208/1C3FDDC9A3163342378ABE10FD1FB34949D0708215F6E61910E79E086299E87F.jpg?q=95&s=1440x1440&t=inside', 2, '2022-07-21T14:47:00'),
       (27, 'https://dnvefa72aowie.cloudfront.net/origin/article/202208/9670148ABDFEA31E2EC1F9370D61B2ECB0063A9D31097ACDF94103E07F5479B0.jpg?q=95&s=1440x1440&t=inside', 3, '2022-07-21T14:47:00'),
       (28, 'https://dnvefa72aowie.cloudfront.net/origin/article/202207/1FD5CF194125CBD83F08404004A68FC4BFF00F8E7696BAF390C196D80F7F7F41.jpg?q=95&s=1440x1440&t=inside', 1, '2022-07-21T14:47:00'),
       (28, 'https://dnvefa72aowie.cloudfront.net/origin/article/202207/D19EF3B2BF6074B104DE7628B7F40475F43FD308EB89094C001C2F864ACAF866.jpg?q=95&s=1440x1440&t=inside', 2, '2022-07-21T14:47:00'),
       (28, 'https://dnvefa72aowie.cloudfront.net/origin/article/202207/224FBEE37F8AFFDA4D2647112C96F2782690F2893F88225B7C20E1D63EC0578C.jpg?q=95&s=1440x1440&t=inside', 3, '2022-07-21T14:47:00'),
       (29, '', 1, '2022-07-21T14:47:00'),
       (29, '', 2, '2022-07-21T14:47:00'),
       (29, '', 3, '2022-07-21T14:47:00'),
       (30, '', 1, '2022-07-21T14:47:00'),
       (30, '', 2, '2022-07-21T14:47:00'),
       (30, '', 3, '2022-07-21T14:47:00'),
       (31, '', 1, '2022-07-21T14:47:00'),
       (31, '', 2, '2022-07-21T14:47:00'),
       (31, '', 3, '2022-07-21T14:47:00'),
       (32, '', 1, '2022-07-21T14:47:00'),
       (32, '', 2, '2022-07-21T14:47:00'),
       (32, '', 3, '2022-07-21T14:47:00'),
       (33, '', 1, '2022-07-21T14:47:00'),
       (33, '', 2, '2022-07-21T14:47:00'),
       (33, '', 3, '2022-07-21T14:47:00'),
       (34, '', 1, '2022-07-21T14:47:00'),
       (34, '', 2, '2022-07-21T14:47:00'),
       (34, '', 3, '2022-07-21T14:47:00');




INSERT INTO `product`(title, `description`, minimum_price, category, location, thumbnail_image,
                      progressed, expire_at, created_at, user_id)
VALUES ('맥북 프로 14 스페이스그레이/M1 Pro',
        'Apple 맥북 프로 14 스페이스그레이/M1 Pro 10코어/16코어 gpu/1Tb ssd/16GB 램
정가 336만원 고급형 모델 판매합니다 개봉수준 컨디션입니다
22년 6월 제조 보증 23년 6월16일 까지 남아있고
8/15일까지 케어플 가입기능합니다
님영역 직거래 원해요',
        2610000, 'DIGITAL_DEVICE', '남영역',
        'https://dnvefa72aowie.cloudfront.net/origin/article/202208/3B9C765977DDA3BA01683373256143F97458ADD5F253360D13C1B4CD77B341B6.jpg?q=95&s=1440x1440&t=inside',
        1, '2022-08-16T15:00:00', '2022-07-21T14:47:00', 1),
       ('MacBook Air(맥북 에어)',
        '약 1년 반 사용
충전기 포함
흠집, 파임 없음
사용 적음
직거래 합니다.',
        850000, 'DIGITAL_DEVICE', '남영역',
        'https://dnvefa72aowie.cloudfront.net/origin/article/202208/9DDD5323ED031EE166BC2952FFC560F99BD61DCD8B50DE943BD1728BA37817AA.jpg?q=95&s=1440x1440&t=inside',
        1, '2022-08-16T15:00:00', '2022-07-21T14:47:00', 1),
       ('S급 2018 맥북 Air)',
        '- 애플 스토어 압구정에서 구입했습니다.
- 총 3달 동안 사용했습니다.
- 기스는 없습니다.
- PC computer 사용하고 있었어 거의 맥북 사용 안합니다.',
        600000, 'DIGITAL_DEVICE', '서울역',
        'https://dnvefa72aowie.cloudfront.net/origin/article/202208/E01F44797D5524AFD297AB93F08F127EA387FC22DC10406945935F20984F119A.jpg?q=95&s=1440x1440&t=inside',
        1, '2022-08-16T15:00:00', '2022-07-21T14:47:00', 1),
       ('맥북프로 /MacBook Pro',
        'CPU 2.8 ghz I5
Ram : 16gb
용량: 256
배터리 사이클 255
OS : Mojave',
        600000, 'DIGITAL_DEVICE', '서울역',
        'https://dnvefa72aowie.cloudfront.net/origin/article/202208/5715942d2452d81b2f3f343da64c90715c306684f90ba1faa8498016103317ce.webp?q=95&s=1440x1440&t=inside',
        1, '2022-08-16T15:00:00', '2022-07-21T14:47:00', 1),
       ('(풀박) 맥북 에어 m1',
        '⚡️사용: 7개월

⚡️스펙: 256GB SSD, 8GB RAM, 8 core CPU, 7 core GPU, 13인치 화면

⚡️사이클: 68회

⚡️배터리효율: 97%

⚡️애케플: X

⚡️생활기스: X. 케이스 사용하여 기스 전혀없음.

⚡️추가증정:
-무선 샤오미 마우스(제품명: WXSMSBMW02, 1.5만원 구입),
-맥북용 인조가죽 케이스(2만원대 구입),
-세척한 투명 키스킨(1만원대 구입)',
        600000, 'DIGITAL_DEVICE', '서울역',
        'https://dnvefa72aowie.cloudfront.net/origin/article/202208/BB122B43923AF9B8EEA5E10F68A5913A1D1B7890959544FBBC5374725A6414E2.jpg?q=95&s=1440x1440&t=inside',
        1, '2022-08-16T15:00:00', '2022-07-21T14:47:00', 1),
       ('맥북프로 13인치 터치바',
        '* 2019년 말에 구입, 총 사용량으로 따지면 사용월.년. 수,
1년 3개월 미만입니다.

* 인터넷 사용을 주로하는 인터넷 서치용 컴퓨터로만 사용하였습니다.

* 키보드, 스크린, 트랙패드 모두 이상없이 정상작동 합니다.

* 키보드 보시면 아시겠지만,
거의 새 컴퓨터라 해도 무방합니다.

* 첫 구입시부터, 사면을 모두 스크래치 방지용 필름으로 관리해 주어서 그대로 쓰셔도 무방하고, 벗기시면 완전히 새 컴퓨터처럼 스크래치 없을 것입니다

* 스크레치 전무',
        800000, 'DIGITAL_DEVICE', '서울역',
        'https://dnvefa72aowie.cloudfront.net/origin/article/202208/1BA62D3AEB67E2E2997052F03794B527385690106179C954E55C1A2F122345F9.jpg?q=95&s=1440x1440&t=inside',
        1, '2022-08-16T15:00:00', '2022-07-21T14:47:00', 1),
       ('2017 맥북 에어',
        '2017 Macbook Air
12-inch(2304x1440 retina)
Dual-Core Intel Core m3
RAM 8GB
저장공간 256GB
더 자세한 사양은 첨부사진 확인해주세요',
        480000, 'DIGITAL_DEVICE', '서울역',
        'https://dnvefa72aowie.cloudfront.net/origin/article/202207/1FD5CF194125CBD83F08404004A68FC4BFF00F8E7696BAF390C196D80F7F7F41.jpg?q=95&s=1440x1440&t=inside',
        1, '2022-08-16T15:00:00', '2022-07-21T14:47:00', 1),
       ('맥북 프로 13인치 19년',
        '2017 Macbook Air
12-inch(2304x1440 retina)
Dual-Core Intel Core m3
RAM 8GB
저장공간 256GB
더 자세한 사양은 첨부사진 확인해주세요',
        480000, 'DIGITAL_DEVICE', '서울역',
        'https://dnvefa72aowie.cloudfront.net/origin/article/202207/1FD5CF194125CBD83F08404004A68FC4BFF00F8E7696BAF390C196D80F7F7F41.jpg?q=95&s=1440x1440&t=inside',
        1, '2022-08-16T15:00:00', '2022-07-21T14:47:00', 1);