Enlighten

List (for user)

Request
Method: GET
Route: api/giftcard/list
Example: api/giftcard/list
Request Headers
host: localhost:49527
user-agent: Symfony
accept: application/json
accept-language: en-us,en;q=0.5
accept-charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7
authorization: Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vbG9jYWxob3N0OjQ5NTI3IiwiaWF0IjoxNjUyNzc1OTUxLCJuYmYiOjE2NTI3NzU5NTEsImp0aSI6IkM1NnZGRmtZZHdLOWcyRU0iLCJzdWIiOiIyMiIsInBydiI6IjIzYmQ1Yzg5NDlmNjAwYWRiMzllNzAxYzQwMDg3MmRiN2E1OTc2ZjcifQ.2UYsWgMo2tutKQtsvS194AN93U3IGjbQkoXQ1V9yaXo
content-length: 2
content-type: application/json

Response
200 JSON
Response Headers
cache-control: no-cache, private
date: Tue, 17 May 2022 08:25:51 GMT
content-type: application/json
x-ratelimit-limit: 60
x-ratelimit-remaining: 59 
{
    "data": [
        {
            "id": 9,
            "serial": "oM9hRjVRfT",
            "denomination": {
                "denomination": 2400,
                "gradient": {
                    "color_1": "#a61e8b",
                    "color_2": "#aa7c54"
                }
            },
            "is_available": true,
            "project": {
                "id": 2,
                "name": "Ricerca per sconfiggere la malattia",
                "slug": "ricerca-per-sconfiggere-la-malattia-2",
                "brand": {
                    "id": 3,
                    "name": "Patagonia",
                    "corner_logo": "https:\/\/via.placeholder.com\/640x480.png\/009955?text=esse"
                },
                "start_at": "2022-05-16T02:51:04.000000Z",
                "deadline": "2022-09-14T00:00:00.000000Z",
                "intro": "Earum qui ipsa enim quos minima et. Qui rem totam itaque asperiores. Error iusto nam velit molestias commodi sit. Saepe numquam voluptatem libero praesentium.",
                "description": "Ut est suscipit modi reprehenderit ut tempore. Omnis in voluptatem incidunt nemo nihil neque eum. Consectetur enim iusto doloremque excepturi quia.",
                "organization": {
                    "id": 2,
                    "name": "SOS Archivi",
                    "corner_logo": "https:\/\/via.placeholder.com\/640x480.png\/003355?text=consequatur"
                },
                "giftcard_logo": "https:\/\/via.placeholder.com\/640x480.png\/003355?text=rerum",
                "available_giftcards_count": 3,
                "denominations": [
                    {
                        "denomination": 600,
                        "is_available": true,
                        "gradient": {
                            "color_1": "#036a1c",
                            "color_2": "#948aa4"
                        }
                    },
                    {
                        "denomination": 2400,
                        "is_available": false,
                        "gradient": {
                            "color_1": "#a61e8b",
                            "color_2": "#aa7c54"
                        }
                    },
                    {
                        "denomination": 3700,
                        "is_available": false,
                        "gradient": {
                            "color_1": "#9317e9",
                            "color_2": "#7f30c3"
                        }
                    },
                    {
                        "denomination": 4600,
                        "is_available": true,
                        "gradient": {
                            "color_1": "#7a823c",
                            "color_2": "#07f2c9"
                        }
                    },
                    {
                        "denomination": 4900,
                        "is_available": true,
                        "gradient": {
                            "color_1": "#dab5b8",
                            "color_2": "#479e2a"
                        }
                    }
                ],
                "percentage": 37.65432098765432,
                "background_image": "https:\/\/via.placeholder.com\/640x480.png\/005566?text=illum",
                "links": [
                    {
                        "url": "https:\/\/bruen.com\/quis-harum-quos-minima-autem-sed-modi-numquam.html",
                        "text": "voluptas laborum sed"
                    }
                ],
                "location": {
                    "address": "1680 Major Mountain\nNew Raul, DE 89816-2661",
                    "coordinates": {
                        "lat": -68.009603,
                        "lng": -66.614402
                    },
                    "title": "fugiat et nam",
                    "description": "Cum repellendus et deserunt omnis vero.",
                    "emails": [
                        {
                            "address": "[email protected]"
                        }
                    ],
                    "links": [
                        {
                            "url": "http:\/\/www.bode.net\/",
                            "text": "possimus a reiciendis"
                        }
                    ]
                }
            },
            "terms": "<html><head><title>Velit et dolorem ex aspernatur.<\/title><\/head><body><form action=\"example.org\" method=\"POST\"><label for=\"username\">sint<\/label><input type=\"text\" id=\"username\"><label for=\"password\">omnis<\/label><input type=\"password\" id=\"password\"><\/form><div class=\"maxime\"><\/div><div id=\"80805\"><h3>Consequuntur.<\/h3>Ab.<\/div><\/body><\/html>\n",
            "expires_at": "2022-11-23T09:01:18.000000Z"
        },
        {
            "id": 10,
            "serial": "LA54rMpCP6",
            "denomination": {
                "denomination": 3700,
                "gradient": {
                    "color_1": "#9317e9",
                    "color_2": "#7f30c3"
                }
            },
            "is_available": true,
            "project": {
                "id": 2,
                "name": "Ricerca per sconfiggere la malattia",
                "slug": "ricerca-per-sconfiggere-la-malattia-2",
                "brand": {
                    "id": 3,
                    "name": "Patagonia",
                    "corner_logo": "https:\/\/via.placeholder.com\/640x480.png\/009955?text=esse"
                },
                "start_at": "2022-05-16T02:51:04.000000Z",
                "deadline": "2022-09-14T00:00:00.000000Z",
                "intro": "Earum qui ipsa enim quos minima et. Qui rem totam itaque asperiores. Error iusto nam velit molestias commodi sit. Saepe numquam voluptatem libero praesentium.",
                "description": "Ut est suscipit modi reprehenderit ut tempore. Omnis in voluptatem incidunt nemo nihil neque eum. Consectetur enim iusto doloremque excepturi quia.",
                "organization": {
                    "id": 2,
                    "name": "SOS Archivi",
                    "corner_logo": "https:\/\/via.placeholder.com\/640x480.png\/003355?text=consequatur"
                },
                "giftcard_logo": "https:\/\/via.placeholder.com\/640x480.png\/003355?text=rerum",
                "available_giftcards_count": 3,
                "denominations": [
                    {
                        "denomination": 600,
                        "is_available": true,
                        "gradient": {
                            "color_1": "#036a1c",
                            "color_2": "#948aa4"
                        }
                    },
                    {
                        "denomination": 2400,
                        "is_available": false,
                        "gradient": {
                            "color_1": "#a61e8b",
                            "color_2": "#aa7c54"
                        }
                    },
                    {
                        "denomination": 3700,
                        "is_available": false,
                        "gradient": {
                            "color_1": "#9317e9",
                            "color_2": "#7f30c3"
                        }
                    },
                    {
                        "denomination": 4600,
                        "is_available": true,
                        "gradient": {
                            "color_1": "#7a823c",
                            "color_2": "#07f2c9"
                        }
                    },
                    {
                        "denomination": 4900,
                        "is_available": true,
                        "gradient": {
                            "color_1": "#dab5b8",
                            "color_2": "#479e2a"
                        }
                    }
                ],
                "percentage": 37.65432098765432,
                "background_image": "https:\/\/via.placeholder.com\/640x480.png\/005566?text=illum",
                "links": [
                    {
                        "url": "https:\/\/bruen.com\/quis-harum-quos-minima-autem-sed-modi-numquam.html",
                        "text": "voluptas laborum sed"
                    }
                ],
                "location": {
                    "address": "1680 Major Mountain\nNew Raul, DE 89816-2661",
                    "coordinates": {
                        "lat": -68.009603,
                        "lng": -66.614402
                    },
                    "title": "fugiat et nam",
                    "description": "Cum repellendus et deserunt omnis vero.",
                    "emails": [
                        {
                            "address": "[email protected]"
                        }
                    ],
                    "links": [
                        {
                            "url": "http:\/\/www.bode.net\/",
                            "text": "possimus a reiciendis"
                        }
                    ]
                }
            },
            "terms": "<html><head><title>Nihil explicabo.<\/title><\/head><body><form action=\"example.org\" method=\"POST\"><label for=\"username\">illo<\/label><input type=\"text\" id=\"username\"><label for=\"password\">quas<\/label><input type=\"password\" id=\"password\"><\/form><div id=\"49889\"><\/div><div class=\"quasi\"><a href=\"example.com\">Sequi doloribus.<\/a><\/div><div id=\"42998\"><\/div><div class=\"aliquam\"><div id=\"4197\">Accusantium iure delectus autem consequatur eos accusantium ut ad sed.<\/div><div class=\"dignissimos\"><\/div><div id=\"80908\"><\/div><\/div><\/body><\/html>\n",
            "expires_at": "2022-07-03T10:29:25.000000Z"
        }
    ]
}

Time: 0.4

 
insert into `users` (`updated_at`, `created_at`) values (?, ?)
Bindings
0: 2022-05-17 08:25:51
1: 2022-05-17 08:25:51

Time: 0.44

 
insert into `login_tokens` (`user_id`, `token`, `medium_type`, `medium_handle`, `expires_at`, `section`, `consumed_at`, `callback_url`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings
0: 22
1: kdJ7UYH5qe
2: email
3: [email protected]
4: 2022-05-17 08:40:51
5: 6SUzssw7F2etZd1d
6:
7: http://www.abbott.org/minima-ex-qui-expedita-et-vel-et.html
8: 2022-05-17 08:25:51
9: 2022-05-17 08:25:51

Time: 0.4

 
select * from `users` where (`phone_verified_at` is not null or `email_verified_at` is not null) and `id` = ? limit 1
Bindings
0: 22

Time: 0.45

 
select * from `users` where (`phone_verified_at` is null or `email_verified_at` is null) and `id` = ? limit 1
Bindings
0: 22

Time: 0.42

 
update `users` set `email_verified_at` = ?, `email` = ?, `users`.`updated_at` = ? where `id` = ?
Bindings
0: 2022-05-17 08:25:51
1: [email protected]
2: 2022-05-17 08:25:51
3: 22

Time: 0.4

 
update `login_tokens` set `consumed_at` = ?, `login_tokens`.`updated_at` = ? where `id` = ?
Bindings
0: 2022-05-17 08:25:51
1: 2022-05-17 08:25:51
2: 36

Time: 0.3

 
insert into `brands` (`name`, `updated_at`, `created_at`) values (?, ?, ?)
Bindings
0: Patagonia
1: 2022-05-17 08:25:51
2: 2022-05-17 08:25:51

Time: 0.35

 
update `brands` set `corner_logo` = ?, `brands`.`updated_at` = ? where `id` = ?
Bindings
0: https://via.placeholder.com/640x480.png/009955?text=esse
1: 2022-05-17 08:25:51
2: 3

Time: 0.34

 
insert into `organizations` (`name`, `updated_at`, `created_at`) values (?, ?, ?)
Bindings
0: SOS Archivi
1: 2022-05-17 08:25:51
2: 2022-05-17 08:25:51

Time: 0.42

 
update `organizations` set `corner_logo` = ?, `organizations`.`updated_at` = ? where `id` = ?
Bindings
0: https://via.placeholder.com/640x480.png/003355?text=consequatur
1: 2022-05-17 08:25:51
2: 2

Time: 0.44

 
insert into `projects` (`name`, `deadline`, `intro`, `description`, `brand_id`, `organization_id`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?, ?, ?)
Bindings
0: Ricerca per sconfiggere la malattia
1: 2022-09-14 00:17:18
2: Earum qui ipsa enim quos minima et. Qui rem totam itaque asperiores. Error iusto nam velit molestias commodi sit. Saepe numquam voluptatem libero praesentium.
3: Ut est suscipit modi reprehenderit ut tempore. Omnis in voluptatem incidunt nemo nihil neque eum. Consectetur enim iusto doloremque excepturi quia.
4: 3
5: 2
6: 2022-05-17 08:25:51
7: 2022-05-17 08:25:51

Time: 0.5

 
select `slug`, `projects`.`id` from `projects` where (`slug` = ? or `slug` LIKE ?)
Bindings
0: ricerca-per-sconfiggere-la-malattia-2
1: ricerca-per-sconfiggere-la-malattia-2-%

Time: 0.4

 
update `projects` set `name` = ?, `deadline` = ?, `intro` = ?, `description` = ?, `brand_id` = ?, `organization_id` = ?, `created_at` = ?, `id` = ?, `slug` = ?, `projects`.`updated_at` = ? where `id` = ?
Bindings
0: Ricerca per sconfiggere la malattia
1: 2022-09-14 00:17:18
2: Earum qui ipsa enim quos minima et. Qui rem totam itaque asperiores. Error iusto nam velit molestias commodi sit. Saepe numquam voluptatem libero praesentium.
3: Ut est suscipit modi reprehenderit ut tempore. Omnis in voluptatem incidunt nemo nihil neque eum. Consectetur enim iusto doloremque excepturi quia.
4: 3
5: 2
6: 2022-05-17 08:25:51
7: 2
8: ricerca-per-sconfiggere-la-malattia-2
9: 2022-05-17 08:25:51
10: 2

Time: 0.41

 
update `projects` set `background_image` = ?, `giftcard_logo` = ?, `link_text` = ?, `link_href` = ?, `location_address` = ?, `location_title` = ?, `location_description` = ?, `location_email` = ?, `location_link_href` = ?, `location_link_text` = ?, `location_latitude` = ?, `location_longitude` = ?, `start_at` = ?, `projects`.`updated_at` = ? where `id` = ?
Bindings
0: https://via.placeholder.com/640x480.png/005566?text=illum
1: https://via.placeholder.com/640x480.png/003355?text=rerum
2: voluptas laborum sed
3: https://bruen.com/quis-harum-quos-minima-autem-sed-modi-numquam.html
4: 1680 Major Mountain New Raul, DE 89816-2661
5: fugiat et nam
6: Cum repellendus et deserunt omnis vero.
7: [email protected]
8: http://www.bode.net/
9: possimus a reiciendis
10: -68.009603
11: -66.614402
12: 2022-05-16 02:51:04
13: 2022-05-17 08:25:51
14: 2

Time: 0.33

 
insert into `cards` (`project_id`, `serial`, `denomination`, `status`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?)
Bindings
0: 2
1: q1YpwQRQ2X
2: 4900
3: available
4: 2022-05-17 08:25:51
5: 2022-05-17 08:25:51

Time: 0.41

 
update `cards` set `gradient_color_1` = ?, `gradient_color_2` = ?, `expires_at` = ?, `info` = ?, `terms` = ?, `cards`.`updated_at` = ? where `id` = ?
Bindings
0: #dab5b8
1: #479e2a
2: 2022-04-21 18:14:40
3: []
4: A facilis blanditiis et odit ut.
Accusantium et eaque magni distinctio.

Aut nemo et reiciendis qui.

Aliquid reprehenderit.Similique quae et iste officiis molestiae placeat quibusdam libero eligendi.
5: 2022-05-17 08:25:51
6: 6

Time: 0.34

 
insert into `cards` (`project_id`, `serial`, `denomination`, `status`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?)
Bindings
0: 2
1: woVQWnnoKq
2: 4600
3: available
4: 2022-05-17 08:25:51
5: 2022-05-17 08:25:51

Time: 0.37

 
update `cards` set `gradient_color_1` = ?, `gradient_color_2` = ?, `expires_at` = ?, `info` = ?, `terms` = ?, `cards`.`updated_at` = ? where `id` = ?
Bindings
0: #7a823c
1: #07f2c9
2: 2022-10-17 20:30:54
3: []
4: Atque eaque illum ullam optio.

Voluptas aut id occaecati enim consequatur ducimus similique numquam asperiores deleniti vel.

Quia tenetur id culpa magnam.
5: 2022-05-17 08:25:51
6: 7

Time: 0.36

 
insert into `cards` (`project_id`, `serial`, `denomination`, `status`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?)
Bindings
0: 2
1: 4dT2F68KUO
2: 600
3: available
4: 2022-05-17 08:25:51
5: 2022-05-17 08:25:51

Time: 0.49

 
update `cards` set `gradient_color_1` = ?, `gradient_color_2` = ?, `expires_at` = ?, `info` = ?, `terms` = ?, `cards`.`updated_at` = ? where `id` = ?
Bindings
0: #036a1c
1: #948aa4
2: 2023-08-11 02:37:10
3: []
4: Veniam qui magni veniam maiores.

Voluptates laudantium temporibus deleniti blanditiis.

Dicta nulla.Ea pariatur incidunt dolorem rerum quia.Harum qui ut omnis et laborum.
Facilis ut eveniet qui.Nam inventore.Voluptatem quia nihil.Dolore minima esse.Quo facere.Inventore.
Est qui ex perspiciatis culpa.Doloremque assumenda dolor dolorem iusto fuga perferendis tenetur.Magni ab iusto sit aut deserunt aut.Eaque aut maxime atque aut reiciendis ullam nihil quia.Dolore iusto aspernatur iure quasi rerum natus incidunt consequatur.Qui.
Deleniti maxime totam quod.Nihil tempora omnis tenetur enim harum ullam consequuntur.Ad itaque vitae sunt architecto iure amet.Quaerat dolores sed assumenda est laborum nemo numquam.Qui in et iure iure quia adipisci.Molestiae dolores quisquam ut officiis perferendis quia.
Asperiores ea tempore voluptatibus esse rem perspiciatis.Dicta itaque quia nemo iste mollitia facilis neque quia.Quia animi.Omnis harum voluptatem adipisci minima itaque similique labore.Et eos asperiores voluptates error.Tenetur dolor non necessitatibus.
Nobis aut dicta dolorem nisi et voluptatum reprehenderit vel eius corporis et.Hic et corporis officiis cumque quia.Beatae deleniti officia illo fuga.Sint quia perspiciatis.Explicabo et.Voluptatem consequuntur quibusdam nulla dolores omnis commodi inventore iure.
5: 2022-05-17 08:25:51
6: 8

Time: 0.35

 
insert into `cards` (`project_id`, `serial`, `denomination`, `status`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?)
Bindings
0: 2
1: oM9hRjVRfT
2: 2400
3: available
4: 2022-05-17 08:25:51
5: 2022-05-17 08:25:51

Time: 0.46

 
update `cards` set `gradient_color_1` = ?, `gradient_color_2` = ?, `expires_at` = ?, `info` = ?, `terms` = ?, `cards`.`updated_at` = ? where `id` = ?
Bindings
0: #a61e8b
1: #aa7c54
2: 2022-11-23 09:01:18
3: []
4: Velit et dolorem ex aspernatur.

Consequuntur.

Ab.
5: 2022-05-17 08:25:51
6: 9

Time: 0.46

 
update `cards` set `status` = ?, `user_id` = ?, `checkout_session` = ?, `reserved_at` = ?, `payment_intent` = ?, `checkout_status` = ?, `cards`.`updated_at` = ? where `id` = ?
Bindings
0: reserved
1: 22
2: bblvtzQjeXJ4tQQq
3: 2022-05-17 08:25:51
4: GuwoCwZNDSA8I7tE
5: created
6: 2022-05-17 08:25:51
7: 9

Time: 0.25

 
update `cards` set `status` = ?, `checkout_status` = ?, `cards`.`updated_at` = ? where `id` = ?
Bindings
0: owned
1: completed
2: 2022-05-17 08:25:51
3: 9

Time: 0.21

 
insert into `cards` (`project_id`, `serial`, `denomination`, `status`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?)
Bindings
0: 2
1: LA54rMpCP6
2: 3700
3: available
4: 2022-05-17 08:25:51
5: 2022-05-17 08:25:51

Time: 0.25

 
update `cards` set `gradient_color_1` = ?, `gradient_color_2` = ?, `expires_at` = ?, `info` = ?, `terms` = ?, `cards`.`updated_at` = ? where `id` = ?
Bindings
0: #9317e9
1: #7f30c3
2: 2022-07-03 10:29:25
3: []
4: Nihil explicabo.
Sequi doloribus.
Accusantium iure delectus autem consequatur eos accusantium ut ad sed.
5: 2022-05-17 08:25:51
6: 10

Time: 0.27

 
update `cards` set `status` = ?, `user_id` = ?, `checkout_session` = ?, `reserved_at` = ?, `payment_intent` = ?, `checkout_status` = ?, `cards`.`updated_at` = ? where `id` = ?
Bindings
0: reserved
1: 22
2: Cvly9GHBnqCsyQwY
3: 2022-05-17 08:25:51
4: bJbPRCGgizfNmxKm
5: created
6: 2022-05-17 08:25:51
7: 10

Time: 0.26

 
update `cards` set `status` = ?, `checkout_status` = ?, `cards`.`updated_at` = ? where `id` = ?
Bindings
0: owned
1: completed
2: 2022-05-17 08:25:51
3: 10

Time: 0.46

 
select * from `users` where (`phone_verified_at` is not null or `email_verified_at` is not null) and `id` = ? limit 1
Bindings
0: 22

Time: 0.46

 
select * from `cards` where `user_id` is not null and `status` = ? and `checkout_session` is not null and `payment_intent` is not null and `checkout_status` = ? and `user_id` = ?
Bindings
0: owned
1: completed
2: 22

Time: 0.42

 
select * from `cards` where `user_id` is not null and `status` = ? and `checkout_session` is not null and `payment_intent` is not null and `checkout_status` = ? and `user_id` = ?
Bindings
0: archived
1: completed
2: 22

Time: 0.46

 
select * from `projects` where `projects`.`id` = ? limit 1
Bindings
0: 2

Time: 0.2

 
select * from `brands` where `brands`.`id` in (3)

Time: 0.19

 
select * from `organizations` where `organizations`.`id` in (2)

Time: 0.23

 
select * from `projects` where `projects`.`id` = ? limit 1
Bindings
0: 2

Time: 0.19

 
select * from `brands` where `brands`.`id` in (3)

Time: 0.18

 
select * from `organizations` where `organizations`.`id` in (2)

Time: 0.23

 
select count(*) as aggregate from `cards` where `user_id` is null and `status` = ? and `project_id` = ?
Bindings
0: available
1: 2

Time: 0.3

 
select * from `cards` where `user_id` is null and `status` = ? and `project_id` = ?
Bindings
0: available
1: 2

Time: 0.28

 
select * from `cards` where `user_id` is not null and `status` = ? and `checkout_session` is not null and `payment_intent` is not null and `project_id` = ?
Bindings
0: reserved
1: 2

Time: 0.56

 
select * from `cards` where `user_id` is not null and `status` = ? and `checkout_session` is not null and `payment_intent` is not null and `checkout_status` = ? and `project_id` = ?
Bindings
0: owned
1: completed
2: 2

Time: 0.48

 
select * from `cards` where `user_id` is not null and `status` = ? and `checkout_session` is not null and `payment_intent` is not null and `checkout_status` = ? and `project_id` = ?
Bindings
0: archived
1: completed
2: 2

Time: 0.48

 
select * from `cards` where `user_id` is null and `status` = ? and `project_id` = ?
Bindings
0: available
1: 2

Time: 0.46

 
select * from `cards` where `user_id` is not null and `status` = ? and `checkout_session` is not null and `payment_intent` is not null and `project_id` = ?
Bindings
0: reserved
1: 2

Time: 0.49

 
select * from `cards` where `user_id` is not null and `status` = ? and `checkout_session` is not null and `payment_intent` is not null and `checkout_status` = ? and `project_id` = ?
Bindings
0: owned
1: completed
2: 2

Time: 0.47

 
select * from `cards` where `user_id` is not null and `status` = ? and `checkout_session` is not null and `payment_intent` is not null and `checkout_status` = ? and `project_id` = ?
Bindings
0: archived
1: completed
2: 2

Time: 0.51

 
select * from `cards` where `user_id` is not null and `status` = ? and `checkout_session` is not null and `payment_intent` is not null and `checkout_status` = ? and `project_id` = ?
Bindings
0: owned
1: completed
2: 2

Time: 0.47

 
select * from `cards` where `user_id` is not null and `status` = ? and `checkout_session` is not null and `payment_intent` is not null and `checkout_status` = ? and `project_id` = ?
Bindings
0: archived
1: completed
2: 2

Time: 0.42

 
select count(*) as aggregate from `cards` where `user_id` is null and `status` = ? and `project_id` = ?
Bindings
0: available
1: 2

Time: 0.47

 
select * from `cards` where `user_id` is null and `status` = ? and `project_id` = ?
Bindings
0: available
1: 2

Time: 0.46

 
select * from `cards` where `user_id` is not null and `status` = ? and `checkout_session` is not null and `payment_intent` is not null and `project_id` = ?
Bindings
0: reserved
1: 2

Time: 0.47

 
select * from `cards` where `user_id` is not null and `status` = ? and `checkout_session` is not null and `payment_intent` is not null and `checkout_status` = ? and `project_id` = ?
Bindings
0: owned
1: completed
2: 2

Time: 0.5

 
select * from `cards` where `user_id` is not null and `status` = ? and `checkout_session` is not null and `payment_intent` is not null and `checkout_status` = ? and `project_id` = ?
Bindings
0: archived
1: completed
2: 2

Time: 0.46

 
select * from `cards` where `user_id` is null and `status` = ? and `project_id` = ?
Bindings
0: available
1: 2

Time: 0.45

 
select * from `cards` where `user_id` is not null and `status` = ? and `checkout_session` is not null and `payment_intent` is not null and `project_id` = ?
Bindings
0: reserved
1: 2

Time: 0.48

 
select * from `cards` where `user_id` is not null and `status` = ? and `checkout_session` is not null and `payment_intent` is not null and `checkout_status` = ? and `project_id` = ?
Bindings
0: owned
1: completed
2: 2

Time: 0.45

 
select * from `cards` where `user_id` is not null and `status` = ? and `checkout_session` is not null and `payment_intent` is not null and `checkout_status` = ? and `project_id` = ?
Bindings
0: archived
1: completed
2: 2

Time: 0.51

 
select * from `cards` where `user_id` is not null and `status` = ? and `checkout_session` is not null and `payment_intent` is not null and `checkout_status` = ? and `project_id` = ?
Bindings
0: owned
1: completed
2: 2

Time: 0.45

 
select * from `cards` where `user_id` is not null and `status` = ? and `checkout_session` is not null and `payment_intent` is not null and `checkout_status` = ? and `project_id` = ?
Bindings
0: archived
1: completed
2: 2

Request
Method: GET
Route: api/giftcard/list
Example: api/giftcard/list
Request Headers
host: localhost:49527
user-agent: Symfony
accept: application/json
accept-language: en-us,en;q=0.5
accept-charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7
authorization: Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vbG9jYWxob3N0OjQ5NTI3IiwiaWF0IjoxNjUyNzc1OTUxLCJuYmYiOjE2NTI3NzU5NTEsImp0aSI6IkM1NnZGRmtZZHdLOWcyRU0iLCJzdWIiOiIyMiIsInBydiI6IjIzYmQ1Yzg5NDlmNjAwYWRiMzllNzAxYzQwMDg3MmRiN2E1OTc2ZjcifQ.2UYsWgMo2tutKQtsvS194AN93U3IGjbQkoXQ1V9yaXo
content-length: 2
content-type: application/json