Laravel Enlighten

Api
Project

Show project

Request

Method:	GET
Route:	api/project/show/{id}
Example:	api/project/show/7

Route Parameter	Pattern	Requirement
id	*	Required

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": 7,
        "name": "Ricerca sulle tecnologie innovative",
        "slug": "ricerca-sulle-tecnologie-innovative-7",
        "brand": {
            "id": 8,
            "name": "Soul Cycle",
            "corner_logo": "https:\/\/via.placeholder.com\/640x480.png\/00ff66?text=nihil"
        },
        "start_at": "2022-05-16T18:02:02.000000Z",
        "deadline": "2023-02-07T00:00:00.000000Z",
        "intro": "Laborum et quae sit voluptatem explicabo asperiores laborum. Est molestiae voluptatibus quis nihil beatae totam. Similique voluptatem quas velit sed nisi.",
        "description": "Ducimus occaecati commodi ad minus eveniet tempore id. Magni libero et quidem perferendis. Iusto molestiae fugiat ex pariatur animi. Est recusandae rem itaque quis commodi dolore.",
        "organization": {
            "id": 8,
            "name": "AIL",
            "corner_logo": "https:\/\/via.placeholder.com\/640x480.png\/00ee22?text=voluptates"
        },
        "giftcard_logo": "https:\/\/via.placeholder.com\/640x480.png\/00bb33?text=animi",
        "available_giftcards_count": 1,
        "denominations": [
            {
                "denomination": 3400,
                "is_available": true,
                "gradient": {
                    "color_1": "#51067d",
                    "color_2": "#f7d079"
                }
            }
        ],
        "percentage": 0,
        "background_image": "https:\/\/via.placeholder.com\/640x480.png\/00ffee?text=et",
        "links": [
            {
                "url": "https:\/\/hessel.com\/nostrum-dolor-maxime-possimus-impedit-doloremque.html",
                "text": "ut eum qui"
            }
        ],
        "location": {
            "address": "7140 Hans Plain Apt. 789\nWest Dell, NE 17838",
            "coordinates": {
                "lat": -46.510216,
                "lng": -69.986716
            },
            "title": "natus autem quam",
            "description": "Voluptatum praesentium cumque consectetur neque.",
            "emails": [
                {
                    "address": "[email protected]"
                }
            ],
            "links": [
                {
                    "url": "http:\/\/moore.net\/ut-accusamus-tenetur-facere-facere-minus-praesentium-aut",
                    "text": "accusamus est voluptatem"
                }
            ]
        }
    }
}

Test Queries

Time: 0.27

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

Bindings

0:	Soul Cycle
1:	2022-05-17 08:25:51
2:	2022-05-17 08:25:51

Time: 0.33

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

Bindings

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

Time: 0.3

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

Bindings

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

Time: 0.27

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

Bindings

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

Time: 0.29

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

Bindings

0:	Ricerca sulle tecnologie innovative
1:	2023-02-07 18:14:37
2:	Laborum et quae sit voluptatem explicabo asperiores laborum. Est molestiae voluptatibus quis nihil beatae totam. Similique voluptatem quas velit sed nisi.
3:	Ducimus occaecati commodi ad minus eveniet tempore id. Magni libero et quidem perferendis. Iusto molestiae fugiat ex pariatur animi. Est recusandae rem itaque quis commodi dolore.
4:	8
5:	8
6:	2022-05-17 08:25:51
7:	2022-05-17 08:25:51

Time: 0.35

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

Bindings

0:	ricerca-sulle-tecnologie-innovative-7
1:	ricerca-sulle-tecnologie-innovative-7-%

Time: 0.29

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

Bindings

0:	Ricerca sulle tecnologie innovative
1:	2023-02-07 18:14:37
2:	Laborum et quae sit voluptatem explicabo asperiores laborum. Est molestiae voluptatibus quis nihil beatae totam. Similique voluptatem quas velit sed nisi.
3:	Ducimus occaecati commodi ad minus eveniet tempore id. Magni libero et quidem perferendis. Iusto molestiae fugiat ex pariatur animi. Est recusandae rem itaque quis commodi dolore.
4:	8
5:	8
6:	2022-05-17 08:25:51
7:	7
8:	ricerca-sulle-tecnologie-innovative-7
9:	2022-05-17 08:25:51
10:	7

Time: 0.3

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/00ffee?text=et
1:	https://via.placeholder.com/640x480.png/00bb33?text=animi
2:	ut eum qui
3:	https://hessel.com/nostrum-dolor-maxime-possimus-impedit-doloremque.html
4:	7140 Hans Plain Apt. 789 West Dell, NE 17838
5:	natus autem quam
6:	Voluptatum praesentium cumque consectetur neque.
7:	[email protected]
8:	http://moore.net/ut-accusamus-tenetur-facere-facere-minus-praesentium-aut
9:	accusamus est voluptatem
10:	-46.510216
11:	-69.986716
12:	2022-05-16 18:02:02
13:	2022-05-17 08:25:51
14:	7

Time: 0.37

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

Bindings

0:	7
1:	I0kZl8sBng
2:	3400
3:	available
4:	2022-05-17 08:25:51
5:	2022-05-17 08:25:51

Time: 0.4

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

Bindings

0:	#51067d
1:	#f7d079
2:	2023-02-03 03:49:21
3:	[]
4:	Voluptatem dolor voluptatum modi. omnisexplicabo Quia eligendi tempora iure vel.Repudiandae magni quia ut quasi velit.Officiis ut alias quo voluptatem sapiente doloribus.Repudiandae exercitationem odio.
5:	2022-05-17 08:25:51
6:	18

Time: 0.44

select * from `projects`

Time: 0.42

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

Time: 0.39

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

Request Queries

Time: 0.46

select * from `projects` where `projects`.`id` = ? limit 1

Bindings

Time: 0.39

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

Time: 0.39

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

Time: 0.31

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

Bindings

0:	available
1:	7

Time: 0.33

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

Bindings

0:	available
1:	7

Time: 0.3

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

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

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

Time: 0.3

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

Bindings

0:	available
1:	7

Time: 0.3

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

Time: 0.3

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

Time: 0.3

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

Time: 0.29

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

Time: 0.32

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

Request

Method:	GET
Route:	api/project/show/{id}
Example:	api/project/show/7

Route Parameter	Pattern	Requirement
id	*	Required

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