Laravel Enlighten

Api
Project

List projects

Request

Method:	GET
Route:	api/project/list
Example:	api/project/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
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": 6,
            "name": "Costruzione di infrastrutture",
            "slug": "costruzione-di-infrastrutture-6",
            "brand": {
                "id": 7,
                "name": "Patagonia",
                "corner_logo": "https:\/\/via.placeholder.com\/640x480.png\/0066aa?text=dolor"
            },
            "start_at": "2022-05-17T18:42:31.000000Z",
            "deadline": "2024-02-28T00:00:00.000000Z",
            "intro": "Aut voluptatibus consectetur rerum tenetur corporis aperiam et. Unde rerum similique et voluptas.",
            "description": "Doloremque eos unde non cum. Quidem accusamus et voluptatem architecto.",
            "organization": {
                "id": 7,
                "name": "FNB",
                "corner_logo": "https:\/\/via.placeholder.com\/640x480.png\/00cc22?text=perspiciatis"
            },
            "giftcard_logo": "https:\/\/via.placeholder.com\/640x480.png\/009955?text=nostrum",
            "available_giftcards_count": 1,
            "denominations": [
                {
                    "denomination": 3700,
                    "is_available": true,
                    "gradient": {
                        "color_1": "#d53daa",
                        "color_2": "#268ebe"
                    }
                }
            ],
            "percentage": 0,
            "background_image": "https:\/\/via.placeholder.com\/640x480.png\/003300?text=qui",
            "links": [
                {
                    "url": "http:\/\/conroy.net\/quia-unde-veniam-quod-est-esse-quod-nemo.html",
                    "text": "deserunt voluptatum animi"
                }
            ],
            "location": {
                "address": "7720 Bo Manor Suite 756\nPort Kathlyn, NE 65462-5306",
                "coordinates": {
                    "lat": 85.411282,
                    "lng": 159.663626
                },
                "title": "ipsam optio aut",
                "description": "Aperiam quis voluptatem illum numquam saepe harum excepturi.",
                "emails": [
                    {
                        "address": "[email protected]"
                    }
                ],
                "links": [
                    {
                        "url": "http:\/\/www.lakin.net\/",
                        "text": "optio libero qui"
                    }
                ]
            }
        }
    ]
}

Test Queries

Time: 0.27

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.5

update `brands` set `corner_logo` = ?, `brands`.`updated_at` = ? where `id` = ?

Bindings

0:	https://via.placeholder.com/640x480.png/0066aa?text=dolor
1:	2022-05-17 08:25:51
2:	7

Time: 0.24

insert into `organizations` (`name`, `updated_at`, `created_at`) values (?, ?, ?)

Bindings

0:	FNB
1:	2022-05-17 08:25:51
2:	2022-05-17 08:25:51

Time: 0.26

update `organizations` set `corner_logo` = ?, `organizations`.`updated_at` = ? where `id` = ?

Bindings

0:	https://via.placeholder.com/640x480.png/00cc22?text=perspiciatis
1:	2022-05-17 08:25:51
2:	7

Time: 0.28

insert into `projects` (`name`, `deadline`, `intro`, `description`, `brand_id`, `organization_id`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?, ?, ?)

Bindings

0:	Costruzione di infrastrutture
1:	2024-02-28 01:26:06
2:	Aut voluptatibus consectetur rerum tenetur corporis aperiam et. Unde rerum similique et voluptas.
3:	Doloremque eos unde non cum. Quidem accusamus et voluptatem architecto.
4:	7
5:	7
6:	2022-05-17 08:25:51
7:	2022-05-17 08:25:51

Time: 0.32

select `slug`, `projects`.`id` from `projects` where (`slug` = ? or `slug` LIKE ?)

Bindings

0:	costruzione-di-infrastrutture-6
1:	costruzione-di-infrastrutture-6-%

Time: 0.28

update `projects` set `name` = ?, `deadline` = ?, `intro` = ?, `description` = ?, `brand_id` = ?, `organization_id` = ?, `created_at` = ?, `id` = ?, `slug` = ?, `projects`.`updated_at` = ? where `id` = ?

Bindings

0:	Costruzione di infrastrutture
1:	2024-02-28 01:26:06
2:	Aut voluptatibus consectetur rerum tenetur corporis aperiam et. Unde rerum similique et voluptas.
3:	Doloremque eos unde non cum. Quidem accusamus et voluptatem architecto.
4:	7
5:	7
6:	2022-05-17 08:25:51
7:	6
8:	costruzione-di-infrastrutture-6
9:	2022-05-17 08:25:51
10:	6

Time: 0.38

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/003300?text=qui
1:	https://via.placeholder.com/640x480.png/009955?text=nostrum
2:	deserunt voluptatum animi
3:	http://conroy.net/quia-unde-veniam-quod-est-esse-quod-nemo.html
4:	7720 Bo Manor Suite 756 Port Kathlyn, NE 65462-5306
5:	ipsam optio aut
6:	Aperiam quis voluptatem illum numquam saepe harum excepturi.
7:	[email protected]
8:	http://www.lakin.net/
9:	optio libero qui
10:	85.411282
11:	159.663626
12:	2022-05-17 18:42:31
13:	2022-05-17 08:25:51
14:	6

Time: 0.35

insert into `cards` (`project_id`, `serial`, `denomination`, `status`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?)

Bindings

0:	6
1:	JeFcnRQPYi
2:	3700
3:	available
4:	2022-05-17 08:25:51
5:	2022-05-17 08:25:51

Time: 0.39

update `cards` set `gradient_color_1` = ?, `gradient_color_2` = ?, `expires_at` = ?, `info` = ?, `terms` = ?, `cards`.`updated_at` = ? where `id` = ?

Bindings

#d53daa

#268ebe

2022-04-18 10:41:39

[]

Voluptatem cupiditate quia nihil sequi qui quidem atque nesciunt.

Quia pariatur.	Porro eaque quasi.
Adipisci.	Illo repudiandae aperiam assumenda provident reiciendis qui minima reprehenderit laborum.
Cumque nam sed.	Aperiam harum in dolores soluta est eligendi fuga error.
Nisi incidunt.	Eum.
Non ab sit nisi dignissimos nihil ut cum magnam aliquam voluptate fuga.	Animi quas odit et.
Dolorem.	Amet at nulla repellendus quidem ipsa quos autem ea nostrum voluptas.

Facilis occaecati repellat nobis aspernatur consequatur error est officia.Quae et voluptatibus ducimus.

2022-05-17 08:25:51

Request Queries

Time: 0.47

select * from `projects` order by `deadline` desc, `start_at` asc

Time: 0.39

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

Time: 0.38

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

Time: 0.33

select count(*) as aggregate from `cards` where `user_id` is null and `status` = ? and `project_id` = ?

Bindings

0:	available
1:	6

Time: 0.31

select * from `cards` where `user_id` is null and `status` = ? and `project_id` = ?

Bindings

0:	available
1:	6

Time: 0.36

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:	6

Time: 0.31

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:	6

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:	6

Time: 0.49

select * from `cards` where `user_id` is null and `status` = ? and `project_id` = ?

Bindings

0:	available
1:	6

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:	6

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:	owned
1:	completed
2:	6

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:	6

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:	owned
1:	completed
2:	6

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:	archived
1:	completed
2:	6

Request

Method:	GET
Route:	api/project/list
Example:	api/project/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
content-length:	2
content-type:	application/json