select * from `accounts` where `accounts`.`id` = 1 and `accounts`.`deleted_at` is null limit 1
|
5.72ms
../Frontend/CategoryResource.php:29
|
select * from `category_types` where `category_types`.`id` = 1 and `category_types`.`deleted_at` is null limit 1
|
6.72ms
../Frontend/CategoryResource.php:27
|
select * from `media` where `media`.`model_id` in (5) and `media`.`model_type` = 'studio-slide'
|
2.00ms
..ources/StudioSlideResource.php:24
|
select * from `media` where `media`.`model_id` in (4) and `media`.`model_type` = 'studio-slide'
|
1.99ms
..ources/StudioSlideResource.php:24
|
select * from `media` where `media`.`model_id` in (2) and `media`.`model_type` = 'studio-content'
|
2.16ms
..rces/StudioContentResource.php:24
|
select * from `studio_slides` where `studio_slides`.`studio_id` = 2 and `studio_slides`.`studio_id` is not null and `studio_slides`.`deleted_at` is null order by `sort_order` asc
|
1.92ms
..es/Frontend/StudioResource.php:70
|
select * from `studio_contents` where `studio_contents`.`studio_id` = 2 and `studio_contents`.`studio_id` is not null and `studio_contents`.`deleted_at` is null limit 1
|
2.05ms
..es/Frontend/StudioResource.php:69
|
select * from `cart_items` where `cart_items`.`cart_id` in (78956) and `cart_items`.`deleted_at` is null
|
1.97ms
..tp/Middleware/ShoppingCart.php:42
|
insert into `carts` (`guest_id`, `studio_id`, `ulid`, `updated_at`, `created_at`) values ('01JTDJDDE5QSZYMPXJTSBRH9SW', 2, '01JTDJDDEDBQVX5SRQVCFK01XA', '2025-05-04 11:55:27', '2025-05-04 11:55:27')
|
10.06ms
..tp/Middleware/ShoppingCart.php:39
|
select * from `carts` where `completed_at` is null and `collected_at` is null and (`guest_id` = '01JTDJDDE5QSZYMPXJTSBRH9SW' and `studio_id` = 2) and `carts`.`deleted_at` is null limit 1
|
6.62ms
..tp/Middleware/ShoppingCart.php:39
|
select * from `media` where `media`.`model_id` in (1, 2, 3) and `media`.`model_type` = 'studio'
|
2.04ms
/app/Http/Middleware/Studios.php:27
|
select * from `studios` where date(`first_business_day`) <= '2025-05-04' and `studios`.`deleted_at` is null
|
2.04ms
/app/Http/Middleware/Studios.php:27
|
select * from `media` where `media`.`model_id` in (3) and `media`.`model_type` = 'studio'
|
1.86ms
/app/Http/Middleware/Studios.php:23
|
select * from `studios` where `studios`.`id` = 3 and `studios`.`deleted_at` is null limit 1
|
2.04ms
/app/Http/Middleware/Studios.php:23
|
select *, (3959 * acos(cos(radians(41.3100000)) * cos(radians(lat)) * cos(radians(lng) - radians(-72.9200000)) + sin(radians(41.3100000)) * sin(radians(lat)))) AS distance from `studios` where `studios`.`deleted_at` is null having `distance` <= 200 order by `distance` asc
|
2.13ms
..p/Models/Traits/HasAddress.php:80
|
select * from `categories` where `id` = '2' and `categories`.`deleted_at` is null limit 1
|
5.11ms
/public/index.php:52
|
select * from `media` where `media`.`model_id` in (2) and `media`.`model_type` = 'studio'
|
2.14ms
/app/Models/Studio.php:176
|
select * from `studios` where LOWER(REPLACE(REPLACE(TRIM(`locality`), ',', '-'), ' ', '-')) = 'columbus' AND LOWER(REPLACE(REPLACE(TRIM(`administrative_area_level_1`), ',', '-'), ' ', '-')) = 'oh' and `studios`.`deleted_at` is null limit 1
|
35.72ms
/app/Models/Studio.php:176
|