test

387 1

Description

content

Messages Timeline Exceptions Views20 Route Queries64 Mails Session Request

1.16s6MBGET en/libraries/{type}/{id}/{slug?}

Booting (925.41ms)
Application (457.18ms)

20 templates were rendered

midade/items::frontend.items.show (public/themes/midade/frontend/utrujja/views/vendor/midade/items/frontend/items/show.blade.php)3blade
Params
0
item
1
type
2
categories
partials.items.search (public/themes/midade/frontend/utrujja/views/partials/items/search.blade.php)12blade
Params
0
obLevel
1
__env
2
app
3
errors
4
currentUser
5
currentUserRole
6
item
7
type
8
categories
9
currentLocale
10
allowDownload
11
title
partials.items.sort (public/themes/midade/frontend/utrujja/views/partials/items/sort.blade.php)13blade
Params
0
obLevel
1
__env
2
app
3
errors
4
currentUser
5
currentUserRole
6
item
7
type
8
categories
9
currentLocale
10
allowDownload
11
title
12
user
partials.items.search-form (public/themes/midade/frontend/utrujja/views/partials/items/search-form.blade.php)13blade
Params
0
obLevel
1
__env
2
app
3
errors
4
currentUser
5
currentUserRole
6
item
7
type
8
categories
9
currentLocale
10
allowDownload
11
title
12
user
midade/books::frontend.books.show (public/themes/midade/frontend/utrujja/views/vendor/midade/books/frontend/books/show.blade.php)14blade
Params
0
obLevel
1
__env
2
app
3
errors
4
currentUser
5
currentUserRole
6
item
7
type
8
categories
9
currentLocale
10
allowDownload
11
__currentLoopData
12
category
13
loop
partials.items.players.pdf (public/themes/midade/frontend/utrujja/views/partials/items/players/pdf.blade.php)15blade
Params
0
obLevel
1
__env
2
app
3
errors
4
currentUser
5
currentUserRole
6
item
7
type
8
categories
9
currentLocale
10
allowDownload
11
__currentLoopData
12
category
13
loop
14
file
partials.items.single-item-action (public/themes/midade/frontend/utrujja/views/partials/items/single-item-action.blade.php)14blade
Params
0
obLevel
1
__env
2
app
3
errors
4
currentUser
5
currentUserRole
6
item
7
type
8
categories
9
currentLocale
10
allowDownload
11
__currentLoopData
12
category
13
loop
partials.items.single-item-description (public/themes/midade/frontend/utrujja/views/partials/items/single-item-description.blade.php)15blade
Params
0
obLevel
1
__env
2
app
3
errors
4
currentUser
5
currentUserRole
6
item
7
type
8
categories
9
currentLocale
10
allowDownload
11
__currentLoopData
12
category
13
loop
14
description
partials.items.comments (public/themes/midade/frontend/utrujja/views/partials/items/comments.blade.php)14blade
Params
0
obLevel
1
__env
2
app
3
errors
4
currentUser
5
currentUserRole
6
item
7
type
8
categories
9
currentLocale
10
allowDownload
11
__currentLoopData
12
category
13
loop

Params
0	`item`
1	`type`
2	`categories`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`currentUser`
5	`currentUserRole`
6	`item`
7	`type`
8	`categories`
9	`currentLocale`
10	`allowDownload`
11	`title`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`currentUser`
5	`currentUserRole`
6	`item`
7	`type`
8	`categories`
9	`currentLocale`
10	`allowDownload`
11	`title`
12	`user`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`currentUser`
5	`currentUserRole`
6	`item`
7	`type`
8	`categories`
9	`currentLocale`
10	`allowDownload`
11	`title`
12	`user`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`currentUser`
5	`currentUserRole`
6	`item`
7	`type`
8	`categories`
9	`currentLocale`
10	`allowDownload`
11	`__currentLoopData`
12	`category`
13	`loop`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`currentUser`
5	`currentUserRole`
6	`item`
7	`type`
8	`categories`
9	`currentLocale`
10	`allowDownload`
11	`__currentLoopData`
12	`category`
13	`loop`
14	`file`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`currentUser`
5	`currentUserRole`
6	`item`
7	`type`
8	`categories`
9	`currentLocale`
10	`allowDownload`
11	`__currentLoopData`
12	`category`
13	`loop`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`currentUser`
5	`currentUserRole`
6	`item`
7	`type`
8	`categories`
9	`currentLocale`
10	`allowDownload`
11	`__currentLoopData`
12	`category`
13	`loop`
14	`description`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`currentUser`
5	`currentUserRole`
6	`item`
7	`type`
8	`categories`
9	`currentLocale`
10	`allowDownload`
11	`__currentLoopData`
12	`category`
13	`loop`

partials.text-modal (public/themes/midade/frontend/utrujja/views/partials/text-modal.blade.php)16blade


obLevel
__env
app
errors
currentUser
currentUserRole
item
type
categories
currentLocale
allowDownload
__currentLoopData
category
loop
modalTitle
modalDetails

partials.items.related (public/themes/midade/frontend/utrujja/views/partials/items/related.blade.php)2blade
Params
0
items
1
itemType
partials.share-modal (public/themes/midade/frontend/utrujja/views/partials/share-modal.blade.php)16blade
Params
0
obLevel
1
__env
2
app
3
errors
4
currentUser
5
currentUserRole
6
item
7
type
8
categories
9
currentLocale
10
allowDownload
11
__currentLoopData
12
category
13
loop
14
tag
15
sharable

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`currentUser`
5	`currentUserRole`
6	`item`
7	`type`
8	`categories`
9	`currentLocale`
10	`allowDownload`
11	`__currentLoopData`
12	`category`
13	`loop`
14	`modalTitle`
15	`modalDetails`

Params
0	`items`
1	`itemType`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`currentUser`
5	`currentUserRole`
6	`item`
7	`type`
8	`categories`
9	`currentLocale`
10	`allowDownload`
11	`__currentLoopData`
12	`category`
13	`loop`
14	`tag`
15	`sharable`

layouts.master (public/themes/midade/frontend/utrujja/views/layouts/master.blade.php)15blade


obLevel
__env
app
errors
currentUser
currentUserRole
item
type
categories
currentLocale
allowDownload
__currentLoopData
category
loop
tag

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`currentUser`
5	`currentUserRole`
6	`item`
7	`type`
8	`categories`
9	`currentLocale`
10	`allowDownload`
11	`__currentLoopData`
12	`category`
13	`loop`
14	`tag`

partials.head (public/themes/midade/frontend/utrujja/views/partials/head.blade.php)15blade


obLevel
__env
app
errors
currentUser
currentUserRole
item
type
categories
currentLocale
allowDownload
__currentLoopData
category
loop
tag

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`currentUser`
5	`currentUserRole`
6	`item`
7	`type`
8	`categories`
9	`currentLocale`
10	`allowDownload`
11	`__currentLoopData`
12	`category`
13	`loop`
14	`tag`

partials.home-header (public/themes/midade/frontend/utrujja/views/partials/home-header.blade.php)19blade


obLevel
__env
app
errors
currentUser
currentUserRole
item
type
categories
currentLocale
allowDownload
__currentLoopData
category
loop
tag
innerClass
sliderClass
itemsTypes
firstType

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`currentUser`
5	`currentUserRole`
6	`item`
7	`type`
8	`categories`
9	`currentLocale`
10	`allowDownload`
11	`__currentLoopData`
12	`category`
13	`loop`
14	`tag`
15	`innerClass`
16	`sliderClass`
17	`itemsTypes`
18	`firstType`

partials.top-menu (public/themes/midade/frontend/utrujja/views/partials/top-menu.blade.php)20blade


obLevel
__env
app
errors
currentUser
currentUserRole
item
type
categories
currentLocale
allowDownload
__currentLoopData
category
loop
tag
innerClass
sliderClass
itemsTypes
firstType
user

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`currentUser`
5	`currentUserRole`
6	`item`
7	`type`
8	`categories`
9	`currentLocale`
10	`allowDownload`
11	`__currentLoopData`
12	`category`
13	`loop`
14	`tag`
15	`innerClass`
16	`sliderClass`
17	`itemsTypes`
18	`firstType`
19	`user`

partials.alerts (public/themes/midade/frontend/utrujja/views/partials/alerts.blade.php)20blade


obLevel
__env
app
errors
currentUser
currentUserRole
item
type
categories
currentLocale
allowDownload
__currentLoopData
category
loop
tag
innerClass
sliderClass
itemsTypes
firstType
user

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`currentUser`
5	`currentUserRole`
6	`item`
7	`type`
8	`categories`
9	`currentLocale`
10	`allowDownload`
11	`__currentLoopData`
12	`category`
13	`loop`
14	`tag`
15	`innerClass`
16	`sliderClass`
17	`itemsTypes`
18	`firstType`
19	`user`

partials.footer (public/themes/midade/frontend/utrujja/views/partials/footer.blade.php)17blade


obLevel
__env
app
errors
currentUser
currentUserRole
item
type
categories
currentLocale
allowDownload
__currentLoopData
category
loop
tag
innerClass
version

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`currentUser`
5	`currentUserRole`
6	`item`
7	`type`
8	`categories`
9	`currentLocale`
10	`allowDownload`
11	`__currentLoopData`
12	`category`
13	`loop`
14	`tag`
15	`innerClass`
16	`version`

partials.mobile-menu (public/themes/midade/frontend/utrujja/views/partials/mobile-menu.blade.php)27blade


obLevel
__env
app
errors
currentUser
currentUserRole
item
type
categories
currentLocale
allowDownload
__currentLoopData
category
loop
tag
innerClass
version
user
socialInformations
facebook
twitter
youtube
instagram
telegram
whatsapp
itemsTypes
firstType

partials.footer-scripts (public/themes/midade/frontend/utrujja/views/partials/footer-scripts.blade.php)15blade
Params
0
obLevel
1
__env
2
app
3
errors
4
currentUser
5
currentUserRole
6
item
7
type
8
categories
9
currentLocale
10
allowDownload
11
__currentLoopData
12
category
13
loop
14
tag

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`currentUser`
5	`currentUserRole`
6	`item`
7	`type`
8	`categories`
9	`currentLocale`
10	`allowDownload`
11	`__currentLoopData`
12	`category`
13	`loop`
14	`tag`
15	`innerClass`
16	`version`
17	`user`
18	`socialInformations`
19	`facebook`
20	`twitter`
21	`youtube`
22	`instagram`
23	`telegram`
24	`whatsapp`
25	`itemsTypes`
26	`firstType`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`currentUser`
5	`currentUserRole`
6	`item`
7	`type`
8	`categories`
9	`currentLocale`
10	`allowDownload`
11	`__currentLoopData`
12	`category`
13	`loop`
14	`tag`

uri: GET en/libraries/{type}/{id}/{slug?}
middleware: localizationRedirect, web
as: midade.items.frontend.items.show
controller: Midade\Items\Http\Controllers\Frontend\ItemsController@showItem
namespace: Midade\Items\Http\Controllers\Frontend
prefix: en/libraries
where
file: packages/midade/items/src/Http/Controllers/Frontend/ItemsController.php:717-753

64 statements were executed, 43 of which were duplicated, 21 unique38.77ms

select * from `items` where exists (select * from `item_translations` where `items`.`id` = `item_translations`.`item_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en')) and exists (select * from `item_translations` where `items`.`id` = `item_translations`.`item_id` and `item_translations`.`status_id` = '5' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en')) and exists (select * from `item_translations` where `items`.`id` = `item_translations`.`item_id` and `item_translations`.`slug` = 'test-169' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en')) and exists (select * from `items_types` inner join `typeables` on `items_types`.`id` = `typeables`.`typeable_id` where `items`.`id` = `typeables`.`item_id` and `typeables`.`typeable_type` = 'Midade\Items\Models\Item' and `slug` = 'books') and exists (select * from `books` where `items`.`id` = `books`.`item_id` and exists (select * from `book_translations` where `books`.`id` = `book_translations`.`book_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en'))) and `enabled` = '1' limit 1

3.56msemaq_maqraa

Metadata
Bindings	0. en 1. de 2. en 3. es 4. fr 5. tr 6. ar 7. en 8. 5 9. de 10. en 11. es 12. fr 13. tr 14. ar 15. en 16. test-169 17. de 18. en 19. es 20. fr 21. tr 22. ar 23. en 24. Midade\Items\Models\Item 25. books 26. en 27. de 28. en 29. es 30. fr 31. tr 32. ar 33. en 34. 1
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan

select * from `item_translations` where `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en') and `item_translations`.`item_id` in ('169')260μsemaq_maqraa
Metadata
Bindings
0. de
1. en
2. es
3. fr
4. tr
5. ar
6. en
7. 169
Hints
Use SELECT * only if you need all columns from table
select * from `files` where `files`.`id` in ('220', '249')250μsemaq_maqraa
Metadata
Bindings
0. 220
1. 249
Hints
Use SELECT * only if you need all columns from table
select * from `files` where `files`.`id` in ('')210μsemaq_maqraa
Metadata
Bindings
0.
Hints
Use SELECT * only if you need all columns from table
select * from `items` where `items`.`id` = '169' limit 1630μsemaq_maqraa
Metadata
Bindings
0. 169
Hints
Use SELECT * only if you need all columns from table
LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
select * from `item_translations` where `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en') and `item_translations`.`item_id` in ('169')240μsemaq_maqraa
Metadata
Bindings
0. de
1. en
2. es
3. fr
4. tr
5. ar
6. en
7. 169
Hints
Use SELECT * only if you need all columns from table
select * from `files` where `files`.`id` in ('220', '249')210μsemaq_maqraa
Metadata
Bindings
0. 220
1. 249
Hints
Use SELECT * only if you need all columns from table
select * from `files` where `files`.`id` in ('')230μsemaq_maqraa
Metadata
Bindings
0.
Hints
Use SELECT * only if you need all columns from table

Metadata
Bindings	0. de 1. en 2. es 3. fr 4. tr 5. ar 6. en 7. 169
Hints	Use `SELECT *` only if you need all columns from table

Metadata
Bindings	0. 220 1. 249
Hints	Use `SELECT *` only if you need all columns from table

Metadata
Bindings	0.
Hints	Use `SELECT *` only if you need all columns from table

Metadata
Bindings	0. 169
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan

Metadata
Bindings	0. de 1. en 2. es 3. fr 4. tr 5. ar 6. en 7. 169
Hints	Use `SELECT *` only if you need all columns from table

Metadata
Bindings	0. 220 1. 249
Hints	Use `SELECT *` only if you need all columns from table

Metadata
Bindings	0.
Hints	Use `SELECT *` only if you need all columns from table

select * from `counter` where `counter`.`entity_id` = '169' and `counter`.`entity_id` is not null and (`entity_id` = '169' and `entity_name` = 'Midade\Items\Models\Item' and `action` = 'view' and `ip_address` = '52.14.138.123' and `user_id` is null) limit 1

1.61msemaq_maqraa

Metadata
Bindings	0. 169 1. 169 2. Midade\Items\Models\Item 3. view 4. 52.14.138.123
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan

insert into `counter` (`entity_id`, `entity_name`, `action`, `ip_address`, `user_id`, `updated_at`, `created_at`) values ('169', 'Midade\Items\Models\Item', 'view', '52.14.138.123', '', '2025-04-11 14:25:49', '2025-04-11 14:25:49')2.81msemaq_maqraa
Metadata
Bindings
0. 169
1. Midade\Items\Models\Item
2. view
3. 52.14.138.123
4.
5. 2025-04-11 14:25:49
6. 2025-04-11 14:25:49
select `items_types`.*, `typeables`.`item_id` as `pivot_item_id`, `typeables`.`typeable_id` as `pivot_typeable_id`, `typeables`.`created_at` as `pivot_created_at`, `typeables`.`updated_at` as `pivot_updated_at` from `items_types` inner join `typeables` on `items_types`.`id` = `typeables`.`typeable_id` where `typeables`.`item_id` = '169' and `typeables`.`typeable_type` = 'Midade\Items\Models\Item'540μsemaq_maqraa
Metadata
Bindings
0. 169
1. Midade\Items\Models\Item
select `tags`.*, `tagged`.`taggable_id` as `pivot_taggable_id`, `tagged`.`tag_id` as `pivot_tag_id` from `tags` inner join `tagged` on `tags`.`id` = `tagged`.`tag_id` where `tagged`.`taggable_id` = '169' and `tagged`.`taggable_type` = 'Midade\Items\Models\Item'830μsemaq_maqraa
Metadata
Bindings
0. 169
1. Midade\Items\Models\Item
Hints
Use SELECT * only if you need all columns from table
select * from `tag_translations` where `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en') and `tag_translations`.`tag_id` in ('16')580μsemaq_maqraa
Metadata
Bindings
0. de
1. en
2. es
3. fr
4. tr
5. ar
6. en
7. 16
Hints
Use SELECT * only if you need all columns from table
select `categories`.*, `categorized`.`categorizable_id` as `pivot_categorizable_id`, `categorized`.`category_id` as `pivot_category_id`, `categorized`.`created_at` as `pivot_created_at`, `categorized`.`updated_at` as `pivot_updated_at` from `categories` inner join `categorized` on `categories`.`id` = `categorized`.`category_id` where `categorized`.`categorizable_id` = '169' and `categorized`.`categorizable_type` = 'Midade\Items\Models\Item'1.42msemaq_maqraa
Metadata
Bindings
0. 169
1. Midade\Items\Models\Item
Hints
Use SELECT * only if you need all columns from table
select * from `category_translations` where `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en') and `category_translations`.`category_id` in ('39')690μsemaq_maqraa
Metadata
Bindings
0. de
1. en
2. es
3. fr
4. tr
5. ar
6. en
7. 39
Hints
Use SELECT * only if you need all columns from table
select * from `categories` where `slug` = 'items-categories' limit 1290μsemaq_maqraa
Metadata
Bindings
0. items-categories
Hints
Use SELECT * only if you need all columns from table
LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
select * from `category_translations` where `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en') and `category_translations`.`category_id` in ('1')260μsemaq_maqraa
Metadata
Bindings
0. de
1. en
2. es
3. fr
4. tr
5. ar
6. en
7. 1
Hints
Use SELECT * only if you need all columns from table
select * from `categories` where `categories`.`_lft` between '2' and '32' and `enabled` = '1' and exists (select * from `category_translations` where `categories`.`id` = `category_translations`.`category_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en'))370μsemaq_maqraa
Metadata
Bindings
0. 2
1. 32
2. 1
3. en
4. de
5. en
6. es
7. fr
8. tr
9. ar
10. en
Hints
Use SELECT * only if you need all columns from table
select * from `category_translations` where `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en') and `category_translations`.`category_id` in ('2', '3')270μsemaq_maqraa
Metadata
Bindings
0. de
1. en
2. es
3. fr
4. tr
5. ar
6. en
7. 2
8. 3
Hints
Use SELECT * only if you need all columns from table

Metadata
Bindings	0. 169 1. Midade\Items\Models\Item 2. view 3. 52.14.138.123 4. 5. 2025-04-11 14:25:49 6. 2025-04-11 14:25:49

Metadata
Bindings	0. 169 1. Midade\Items\Models\Item

Metadata
Bindings	0. 169 1. Midade\Items\Models\Item
Hints	Use `SELECT *` only if you need all columns from table

Metadata
Bindings	0. de 1. en 2. es 3. fr 4. tr 5. ar 6. en 7. 16
Hints	Use `SELECT *` only if you need all columns from table

Metadata
Bindings	0. 169 1. Midade\Items\Models\Item
Hints	Use `SELECT *` only if you need all columns from table

Metadata
Bindings	0. de 1. en 2. es 3. fr 4. tr 5. ar 6. en 7. 39
Hints	Use `SELECT *` only if you need all columns from table

Metadata
Bindings	0. items-categories
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan

Metadata
Bindings	0. de 1. en 2. es 3. fr 4. tr 5. ar 6. en 7. 1
Hints	Use `SELECT *` only if you need all columns from table

Metadata
Bindings	0. 2 1. 32 2. 1 3. en 4. de 5. en 6. es 7. fr 8. tr 9. ar 10. en
Hints	Use `SELECT *` only if you need all columns from table

Metadata
Bindings	0. de 1. en 2. es 3. fr 4. tr 5. ar 6. en 7. 2 8. 3
Hints	Use `SELECT *` only if you need all columns from table

select count(*) as aggregate from `items` where `library` = '0' and (exists (select * from `videos` where `items`.`id` = `videos`.`item_id` and exists (select * from `video_translations` where `videos`.`id` = `video_translations`.`video_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en')) and exists (select * from `video_translations` where `videos`.`id` = `video_translations`.`video_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en'))) or exists (select * from `articles` where `items`.`id` = `articles`.`item_id` and exists (select * from `article_translations` where `articles`.`id` = `article_translations`.`article_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en')) and exists (select * from `article_translations` where `articles`.`id` = `article_translations`.`article_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en'))) or exists (select * from `audios` where `items`.`id` = `audios`.`item_id` and exists (select * from `audio_translations` where `audios`.`id` = `audio_translations`.`audio_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en')) and exists (select * from `audio_translations` where `audios`.`id` = `audio_translations`.`audio_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en'))) or exists (select * from `books` where `items`.`id` = `books`.`item_id` and exists (select * from `book_translations` where `books`.`id` = `book_translations`.`book_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en')) and exists (select * from `book_translations` where `books`.`id` = `book_translations`.`book_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en'))) or exists (select * from `cards` where `items`.`id` = `cards`.`item_id` and exists (select * from `card_translations` where `cards`.`id` = `card_translations`.`card_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en')) and exists (select * from `card_translations` where `cards`.`id` = `card_translations`.`card_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en')))) and exists (select * from `categories` inner join `categorized` on `categories`.`id` = `categorized`.`category_id` where `items`.`id` = `categorized`.`categorizable_id` and `categorized`.`categorizable_type` = 'Midade\Items\Models\Item' and `slug` = 'items-categories-alhdyth')

1.76msemaq_maqraa

Metadata
Bindings	0. 0 1. en 2. de 3. en 4. es 5. fr 6. tr 7. ar 8. en 9. en 10. de 11. en 12. es 13. fr 14. tr 15. ar 16. en 17. en 18. de 19. en 20. es 21. fr 22. tr 23. ar 24. en 25. en 26. de 27. en 28. es 29. fr 30. tr 31. ar 32. en 33. en 34. de 35. en 36. es 37. fr 38. tr 39. ar 40. en 41. en 42. de 43. en 44. es 45. fr 46. tr 47. ar 48. en 49. en 50. de 51. en 52. es 53. fr 54. tr 55. ar 56. en 57. en 58. de 59. en 60. es 61. fr 62. tr 63. ar 64. en 65. en 66. de 67. en 68. es 69. fr 70. tr 71. ar 72. en 73. en 74. de 75. en 76. es 77. fr 78. tr 79. ar 80. en 81. Midade\Items\Models\Item 82. items-categories-alhdyth

Metadata

Bindings

0. 0
1. en
2. de
3. en
4. es
5. fr
6. tr
7. ar
8. en
9. en
10. de
11. en
12. es
13. fr
14. tr
15. ar
16. en
17. en
18. de
19. en
20. es
21. fr
22. tr
23. ar
24. en
25. en
26. de
27. en
28. es
29. fr
30. tr
31. ar
32. en
33. en
34. de
35. en
36. es
37. fr
38. tr
39. ar
40. en
41. en
42. de
43. en
44. es
45. fr
46. tr
47. ar
48. en
49. en
50. de
51. en
52. es
53. fr
54. tr
55. ar
56. en
57. en
58. de
59. en
60. es
61. fr
62. tr
63. ar
64. en
65. en
66. de
67. en
68. es
69. fr
70. tr
71. ar
72. en
73. en
74. de
75. en
76. es
77. fr
78. tr
79. ar
80. en
81. Midade\Items\Models\Item
82. items-categories-alhdyth

select count(*) as aggregate from `items` where `library` = '0' and (exists (select * from `videos` where `items`.`id` = `videos`.`item_id` and exists (select * from `video_translations` where `videos`.`id` = `video_translations`.`video_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en')) and exists (select * from `video_translations` where `videos`.`id` = `video_translations`.`video_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en'))) or exists (select * from `articles` where `items`.`id` = `articles`.`item_id` and exists (select * from `article_translations` where `articles`.`id` = `article_translations`.`article_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en')) and exists (select * from `article_translations` where `articles`.`id` = `article_translations`.`article_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en'))) or exists (select * from `audios` where `items`.`id` = `audios`.`item_id` and exists (select * from `audio_translations` where `audios`.`id` = `audio_translations`.`audio_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en')) and exists (select * from `audio_translations` where `audios`.`id` = `audio_translations`.`audio_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en'))) or exists (select * from `books` where `items`.`id` = `books`.`item_id` and exists (select * from `book_translations` where `books`.`id` = `book_translations`.`book_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en')) and exists (select * from `book_translations` where `books`.`id` = `book_translations`.`book_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en'))) or exists (select * from `cards` where `items`.`id` = `cards`.`item_id` and exists (select * from `card_translations` where `cards`.`id` = `card_translations`.`card_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en')) and exists (select * from `card_translations` where `cards`.`id` = `card_translations`.`card_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en')))) and exists (select * from `categories` inner join `categorized` on `categories`.`id` = `categorized`.`category_id` where `items`.`id` = `categorized`.`categorizable_id` and `categorized`.`categorizable_type` = 'Midade\Items\Models\Item' and `slug` = 'items-categories-alsnh')

1.04msemaq_maqraa

Metadata
Bindings	0. 0 1. en 2. de 3. en 4. es 5. fr 6. tr 7. ar 8. en 9. en 10. de 11. en 12. es 13. fr 14. tr 15. ar 16. en 17. en 18. de 19. en 20. es 21. fr 22. tr 23. ar 24. en 25. en 26. de 27. en 28. es 29. fr 30. tr 31. ar 32. en 33. en 34. de 35. en 36. es 37. fr 38. tr 39. ar 40. en 41. en 42. de 43. en 44. es 45. fr 46. tr 47. ar 48. en 49. en 50. de 51. en 52. es 53. fr 54. tr 55. ar 56. en 57. en 58. de 59. en 60. es 61. fr 62. tr 63. ar 64. en 65. en 66. de 67. en 68. es 69. fr 70. tr 71. ar 72. en 73. en 74. de 75. en 76. es 77. fr 78. tr 79. ar 80. en 81. Midade\Items\Models\Item 82. items-categories-alsnh

Metadata

Bindings

0. 0
1. en
2. de
3. en
4. es
5. fr
6. tr
7. ar
8. en
9. en
10. de
11. en
12. es
13. fr
14. tr
15. ar
16. en
17. en
18. de
19. en
20. es
21. fr
22. tr
23. ar
24. en
25. en
26. de
27. en
28. es
29. fr
30. tr
31. ar
32. en
33. en
34. de
35. en
36. es
37. fr
38. tr
39. ar
40. en
41. en
42. de
43. en
44. es
45. fr
46. tr
47. ar
48. en
49. en
50. de
51. en
52. es
53. fr
54. tr
55. ar
56. en
57. en
58. de
59. en
60. es
61. fr
62. tr
63. ar
64. en
65. en
66. de
67. en
68. es
69. fr
70. tr
71. ar
72. en
73. en
74. de
75. en
76. es
77. fr
78. tr
79. ar
80. en
81. Midade\Items\Models\Item
82. items-categories-alsnh

select * from `books` where `books`.`item_id` = '169' and `books`.`item_id` is not null and exists (select * from `book_translations` where `books`.`id` = `book_translations`.`book_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en'))960μsemaq_maqraa
Metadata
Bindings
0. 169
1. en
2. de
3. en
4. es
5. fr
6. tr
7. ar
8. en
Hints
Use SELECT * only if you need all columns from table
select * from `book_translations` where `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en') and `book_translations`.`book_id` in ('15')520μsemaq_maqraa
Metadata
Bindings
0. de
1. en
2. es
3. fr
4. tr
5. ar
6. en
7. 15
Hints
Use SELECT * only if you need all columns from table
select `files`.*, `attachables`.`attachable_id` as `pivot_attachable_id`, `attachables`.`file_id` as `pivot_file_id`, `attachables`.`zone` as `pivot_zone`, `attachables`.`id` as `pivot_id`, `attachables`.`created_at` as `pivot_created_at`, `attachables`.`updated_at` as `pivot_updated_at` from `files` inner join `attachables` on `files`.`id` = `attachables`.`file_id` where `attachables`.`attachable_id` = '17' and `attachables`.`attachable_type` = 'Midade\Books\Models\BookTranslation' and `attachables`.`zone` = 'attachments' order by `order` asc limit 11.09msemaq_maqraa
Metadata
Bindings
0. 17
1. Midade\Books\Models\BookTranslation
2. attachments
Hints
Use SELECT * only if you need all columns from table
select * from `books` where `books`.`item_id` = '169' and `books`.`item_id` is not null and exists (select * from `book_translations` where `books`.`id` = `book_translations`.`book_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en'))290μsemaq_maqraa
Metadata
Bindings
0. 169
1. en
2. de
3. en
4. es
5. fr
6. tr
7. ar
8. en
Hints
Use SELECT * only if you need all columns from table
select * from `book_translations` where `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en') and `book_translations`.`book_id` in ('15')250μsemaq_maqraa
Metadata
Bindings
0. de
1. en
2. es
3. fr
4. tr
5. ar
6. en
7. 15
Hints
Use SELECT * only if you need all columns from table
select `files`.*, `attachables`.`attachable_id` as `pivot_attachable_id`, `attachables`.`file_id` as `pivot_file_id`, `attachables`.`zone` as `pivot_zone`, `attachables`.`id` as `pivot_id`, `attachables`.`created_at` as `pivot_created_at`, `attachables`.`updated_at` as `pivot_updated_at` from `files` inner join `attachables` on `files`.`id` = `attachables`.`file_id` where `attachables`.`attachable_id` = '17' and `attachables`.`attachable_type` = 'Midade\Books\Models\BookTranslation' and `attachables`.`zone` = 'attachments' order by `order` asc limit 1270μsemaq_maqraa
Metadata
Bindings
0. 17
1. Midade\Books\Models\BookTranslation
2. attachments
Hints
Use SELECT * only if you need all columns from table
select * from `books` where `books`.`item_id` = '169' and `books`.`item_id` is not null and exists (select * from `book_translations` where `books`.`id` = `book_translations`.`book_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en'))260μsemaq_maqraa
Metadata
Bindings
0. 169
1. en
2. de
3. en
4. es
5. fr
6. tr
7. ar
8. en
Hints
Use SELECT * only if you need all columns from table
select * from `book_translations` where `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en') and `book_translations`.`book_id` in ('15')240μsemaq_maqraa
Metadata
Bindings
0. de
1. en
2. es
3. fr
4. tr
5. ar
6. en
7. 15
Hints
Use SELECT * only if you need all columns from table
select `files`.*, `attachables`.`attachable_id` as `pivot_attachable_id`, `attachables`.`file_id` as `pivot_file_id`, `attachables`.`zone` as `pivot_zone`, `attachables`.`id` as `pivot_id`, `attachables`.`created_at` as `pivot_created_at`, `attachables`.`updated_at` as `pivot_updated_at` from `files` inner join `attachables` on `files`.`id` = `attachables`.`file_id` where `attachables`.`attachable_id` = '17' and `attachables`.`attachable_type` = 'Midade\Books\Models\BookTranslation' and `attachables`.`zone` = 'word_attachment' order by `order` asc limit 11.22msemaq_maqraa
Metadata
Bindings
0. 17
1. Midade\Books\Models\BookTranslation
2. word_attachment
Hints
Use SELECT * only if you need all columns from table
select * from `books` where `books`.`item_id` = '169' and `books`.`item_id` is not null and exists (select * from `book_translations` where `books`.`id` = `book_translations`.`book_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en'))280μsemaq_maqraa
Metadata
Bindings
0. 169
1. en
2. de
3. en
4. es
5. fr
6. tr
7. ar
8. en
Hints
Use SELECT * only if you need all columns from table
select * from `book_translations` where `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en') and `book_translations`.`book_id` in ('15')590μsemaq_maqraa
Metadata
Bindings
0. de
1. en
2. es
3. fr
4. tr
5. ar
6. en
7. 15
Hints
Use SELECT * only if you need all columns from table
select `files`.*, `attachables`.`attachable_id` as `pivot_attachable_id`, `attachables`.`file_id` as `pivot_file_id`, `attachables`.`zone` as `pivot_zone`, `attachables`.`id` as `pivot_id`, `attachables`.`created_at` as `pivot_created_at`, `attachables`.`updated_at` as `pivot_updated_at` from `files` inner join `attachables` on `files`.`id` = `attachables`.`file_id` where `attachables`.`attachable_id` = '17' and `attachables`.`attachable_type` = 'Midade\Books\Models\BookTranslation' and `attachables`.`zone` = 'ppt_attachment' order by `order` asc limit 11.07msemaq_maqraa
Metadata
Bindings
0. 17
1. Midade\Books\Models\BookTranslation
2. ppt_attachment
Hints
Use SELECT * only if you need all columns from table
select count(*) as aggregate from `counter` where `counter`.`entity_id` = '169' and `counter`.`entity_id` is not null and `entity_name` = 'Midade\Items\Models\Item' and `action` = 'view'1.4msemaq_maqraa
Metadata
Bindings
0. 169
1. Midade\Items\Models\Item
2. view
select count(*) as aggregate from `counter` where `counter`.`entity_id` = '169' and `counter`.`entity_id` is not null and `entity_name` = 'Midade\Items\Models\Item' and `action` = 'share'1.11msemaq_maqraa
Metadata
Bindings
0. 169
1. Midade\Items\Models\Item
2. share
select * from `audios` where `audios`.`item_id` = '169' and `audios`.`item_id` is not null and exists (select * from `audio_translations` where `audios`.`id` = `audio_translations`.`audio_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en'))360μsemaq_maqraa
Metadata
Bindings
0. 169
1. en
2. de
3. en
4. es
5. fr
6. tr
7. ar
8. en
Hints
Use SELECT * only if you need all columns from table
select * from `videos` where `videos`.`item_id` = '169' and `videos`.`item_id` is not null and exists (select * from `video_translations` where `videos`.`id` = `video_translations`.`video_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en'))450μsemaq_maqraa
Metadata
Bindings
0. 169
1. en
2. de
3. en
4. es
5. fr
6. tr
7. ar
8. en
Hints
Use SELECT * only if you need all columns from table
select * from `articles` where `articles`.`item_id` = '169' and `articles`.`item_id` is not null and exists (select * from `article_translations` where `articles`.`id` = `article_translations`.`article_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en'))380μsemaq_maqraa
Metadata
Bindings
0. 169
1. en
2. de
3. en
4. es
5. fr
6. tr
7. ar
8. en
Hints
Use SELECT * only if you need all columns from table
select * from `articles` where `articles`.`item_id` = '169' and `articles`.`item_id` is not null and exists (select * from `article_translations` where `articles`.`id` = `article_translations`.`article_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en'))270μsemaq_maqraa
Metadata
Bindings
0. 169
1. en
2. de
3. en
4. es
5. fr
6. tr
7. ar
8. en
Hints
Use SELECT * only if you need all columns from table
select * from `books` where `books`.`item_id` = '169' and `books`.`item_id` is not null and exists (select * from `book_translations` where `books`.`id` = `book_translations`.`book_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en'))240μsemaq_maqraa
Metadata
Bindings
0. 169
1. en
2. de
3. en
4. es
5. fr
6. tr
7. ar
8. en
Hints
Use SELECT * only if you need all columns from table
select * from `book_translations` where `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en') and `book_translations`.`book_id` in ('15')260μsemaq_maqraa
Metadata
Bindings
0. de
1. en
2. es
3. fr
4. tr
5. ar
6. en
7. 15
Hints
Use SELECT * only if you need all columns from table
select * from `books` where `books`.`item_id` = '169' and `books`.`item_id` is not null and exists (select * from `book_translations` where `books`.`id` = `book_translations`.`book_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en'))270μsemaq_maqraa
Metadata
Bindings
0. 169
1. en
2. de
3. en
4. es
5. fr
6. tr
7. ar
8. en
Hints
Use SELECT * only if you need all columns from table
select * from `book_translations` where `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en') and `book_translations`.`book_id` in ('15')220μsemaq_maqraa
Metadata
Bindings
0. de
1. en
2. es
3. fr
4. tr
5. ar
6. en
7. 15
Hints
Use SELECT * only if you need all columns from table
select `files`.*, `attachables`.`attachable_id` as `pivot_attachable_id`, `attachables`.`file_id` as `pivot_file_id`, `attachables`.`zone` as `pivot_zone`, `attachables`.`id` as `pivot_id`, `attachables`.`created_at` as `pivot_created_at`, `attachables`.`updated_at` as `pivot_updated_at` from `files` inner join `attachables` on `files`.`id` = `attachables`.`file_id` where `attachables`.`attachable_id` = '17' and `attachables`.`attachable_type` = 'Midade\Books\Models\BookTranslation' and `attachables`.`zone` = 'attachments' order by `order` asc limit 1320μsemaq_maqraa
Metadata
Bindings
0. 17
1. Midade\Books\Models\BookTranslation
2. attachments
Hints
Use SELECT * only if you need all columns from table
select * from `books` where `books`.`item_id` = '169' and `books`.`item_id` is not null and exists (select * from `book_translations` where `books`.`id` = `book_translations`.`book_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en'))260μsemaq_maqraa
Metadata
Bindings
0. 169
1. en
2. de
3. en
4. es
5. fr
6. tr
7. ar
8. en
Hints
Use SELECT * only if you need all columns from table
select * from `book_translations` where `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en') and `book_translations`.`book_id` in ('15')210μsemaq_maqraa
Metadata
Bindings
0. de
1. en
2. es
3. fr
4. tr
5. ar
6. en
7. 15
Hints
Use SELECT * only if you need all columns from table
select `files`.*, `attachables`.`attachable_id` as `pivot_attachable_id`, `attachables`.`file_id` as `pivot_file_id`, `attachables`.`zone` as `pivot_zone`, `attachables`.`id` as `pivot_id`, `attachables`.`created_at` as `pivot_created_at`, `attachables`.`updated_at` as `pivot_updated_at` from `files` inner join `attachables` on `files`.`id` = `attachables`.`file_id` where `attachables`.`attachable_id` = '17' and `attachables`.`attachable_type` = 'Midade\Books\Models\BookTranslation' and `attachables`.`zone` = 'attachments' order by `order` asc limit 1300μsemaq_maqraa
Metadata
Bindings
0. 17
1. Midade\Books\Models\BookTranslation
2. attachments
Hints
Use SELECT * only if you need all columns from table
select * from `books` where `books`.`item_id` = '169' and `books`.`item_id` is not null and exists (select * from `book_translations` where `books`.`id` = `book_translations`.`book_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en'))270μsemaq_maqraa
Metadata
Bindings
0. 169
1. en
2. de
3. en
4. es
5. fr
6. tr
7. ar
8. en
Hints
Use SELECT * only if you need all columns from table
select * from `book_translations` where `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en') and `book_translations`.`book_id` in ('15')250μsemaq_maqraa
Metadata
Bindings
0. de
1. en
2. es
3. fr
4. tr
5. ar
6. en
7. 15
Hints
Use SELECT * only if you need all columns from table
select `files`.*, `attachables`.`attachable_id` as `pivot_attachable_id`, `attachables`.`file_id` as `pivot_file_id`, `attachables`.`zone` as `pivot_zone`, `attachables`.`id` as `pivot_id`, `attachables`.`created_at` as `pivot_created_at`, `attachables`.`updated_at` as `pivot_updated_at` from `files` inner join `attachables` on `files`.`id` = `attachables`.`file_id` where `attachables`.`attachable_id` = '17' and `attachables`.`attachable_type` = 'Midade\Books\Models\BookTranslation' and `attachables`.`zone` = 'attachments' order by `order` asc limit 1370μsemaq_maqraa
Metadata
Bindings
0. 17
1. Midade\Books\Models\BookTranslation
2. attachments
Hints
Use SELECT * only if you need all columns from table
select * from `books` where `books`.`item_id` = '169' and `books`.`item_id` is not null and exists (select * from `book_translations` where `books`.`id` = `book_translations`.`book_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en'))370μsemaq_maqraa
Metadata
Bindings
0. 169
1. en
2. de
3. en
4. es
5. fr
6. tr
7. ar
8. en
Hints
Use SELECT * only if you need all columns from table
select * from `book_translations` where `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en') and `book_translations`.`book_id` in ('15')320μsemaq_maqraa
Metadata
Bindings
0. de
1. en
2. es
3. fr
4. tr
5. ar
6. en
7. 15
Hints
Use SELECT * only if you need all columns from table
select * from `books` where `books`.`item_id` = '169' and `books`.`item_id` is not null and exists (select * from `book_translations` where `books`.`id` = `book_translations`.`book_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en'))350μsemaq_maqraa
Metadata
Bindings
0. 169
1. en
2. de
3. en
4. es
5. fr
6. tr
7. ar
8. en
Hints
Use SELECT * only if you need all columns from table
select * from `book_translations` where `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en') and `book_translations`.`book_id` in ('15')330μsemaq_maqraa
Metadata
Bindings
0. de
1. en
2. es
3. fr
4. tr
5. ar
6. en
7. 15
Hints
Use SELECT * only if you need all columns from table
select `files`.*, `attachables`.`attachable_id` as `pivot_attachable_id`, `attachables`.`file_id` as `pivot_file_id`, `attachables`.`zone` as `pivot_zone`, `attachables`.`id` as `pivot_id`, `attachables`.`created_at` as `pivot_created_at`, `attachables`.`updated_at` as `pivot_updated_at` from `files` inner join `attachables` on `files`.`id` = `attachables`.`file_id` where `attachables`.`attachable_id` = '17' and `attachables`.`attachable_type` = 'Midade\Books\Models\BookTranslation' and `attachables`.`zone` = 'word_attachment' order by `order` asc limit 1330μsemaq_maqraa
Metadata
Bindings
0. 17
1. Midade\Books\Models\BookTranslation
2. word_attachment
Hints
Use SELECT * only if you need all columns from table
select * from `books` where `books`.`item_id` = '169' and `books`.`item_id` is not null and exists (select * from `book_translations` where `books`.`id` = `book_translations`.`book_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en'))370μsemaq_maqraa
Metadata
Bindings
0. 169
1. en
2. de
3. en
4. es
5. fr
6. tr
7. ar
8. en
Hints
Use SELECT * only if you need all columns from table
select * from `book_translations` where `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en') and `book_translations`.`book_id` in ('15')300μsemaq_maqraa
Metadata
Bindings
0. de
1. en
2. es
3. fr
4. tr
5. ar
6. en
7. 15
Hints
Use SELECT * only if you need all columns from table
select * from `books` where `books`.`item_id` = '169' and `books`.`item_id` is not null and exists (select * from `book_translations` where `books`.`id` = `book_translations`.`book_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en'))320μsemaq_maqraa
Metadata
Bindings
0. 169
1. en
2. de
3. en
4. es
5. fr
6. tr
7. ar
8. en
Hints
Use SELECT * only if you need all columns from table
select * from `book_translations` where `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en') and `book_translations`.`book_id` in ('15')300μsemaq_maqraa
Metadata
Bindings
0. de
1. en
2. es
3. fr
4. tr
5. ar
6. en
7. 15
Hints
Use SELECT * only if you need all columns from table
select `files`.*, `attachables`.`attachable_id` as `pivot_attachable_id`, `attachables`.`file_id` as `pivot_file_id`, `attachables`.`zone` as `pivot_zone`, `attachables`.`id` as `pivot_id`, `attachables`.`created_at` as `pivot_created_at`, `attachables`.`updated_at` as `pivot_updated_at` from `files` inner join `attachables` on `files`.`id` = `attachables`.`file_id` where `attachables`.`attachable_id` = '17' and `attachables`.`attachable_type` = 'Midade\Books\Models\BookTranslation' and `attachables`.`zone` = 'ppt_attachment' order by `order` asc limit 1380μsemaq_maqraa
Metadata
Bindings
0. 17
1. Midade\Books\Models\BookTranslation
2. ppt_attachment
Hints
Use SELECT * only if you need all columns from table
select * from `cards` where `cards`.`item_id` = '169' and `cards`.`item_id` is not null and exists (select * from `card_translations` where `cards`.`id` = `card_translations`.`card_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en'))600μsemaq_maqraa
Metadata
Bindings
0. 169
1. en
2. de
3. en
4. es
5. fr
6. tr
7. ar
8. en
Hints
Use SELECT * only if you need all columns from table
select * from `books` where `books`.`item_id` = '169' and `books`.`item_id` is not null and exists (select * from `book_translations` where `books`.`id` = `book_translations`.`book_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en'))330μsemaq_maqraa
Metadata
Bindings
0. 169
1. en
2. de
3. en
4. es
5. fr
6. tr
7. ar
8. en
Hints
Use SELECT * only if you need all columns from table
select * from `book_translations` where `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en') and `book_translations`.`book_id` in ('15')300μsemaq_maqraa
Metadata
Bindings
0. de
1. en
2. es
3. fr
4. tr
5. ar
6. en
7. 15
Hints
Use SELECT * only if you need all columns from table

Metadata
Bindings	0. 169 1. en 2. de 3. en 4. es 5. fr 6. tr 7. ar 8. en
Hints	Use `SELECT *` only if you need all columns from table

Metadata
Bindings	0. de 1. en 2. es 3. fr 4. tr 5. ar 6. en 7. 15
Hints	Use `SELECT *` only if you need all columns from table

Metadata
Bindings	0. 17 1. Midade\Books\Models\BookTranslation 2. attachments
Hints	Use `SELECT *` only if you need all columns from table

Metadata
Bindings	0. 169 1. en 2. de 3. en 4. es 5. fr 6. tr 7. ar 8. en
Hints	Use `SELECT *` only if you need all columns from table

Metadata
Bindings	0. de 1. en 2. es 3. fr 4. tr 5. ar 6. en 7. 15
Hints	Use `SELECT *` only if you need all columns from table

Metadata
Bindings	0. 17 1. Midade\Books\Models\BookTranslation 2. attachments
Hints	Use `SELECT *` only if you need all columns from table

Metadata
Bindings	0. 169 1. en 2. de 3. en 4. es 5. fr 6. tr 7. ar 8. en
Hints	Use `SELECT *` only if you need all columns from table

Metadata
Bindings	0. de 1. en 2. es 3. fr 4. tr 5. ar 6. en 7. 15
Hints	Use `SELECT *` only if you need all columns from table

Metadata
Bindings	0. 17 1. Midade\Books\Models\BookTranslation 2. word_attachment
Hints	Use `SELECT *` only if you need all columns from table

select `items`.*, `item_translations`.`title` from `items` inner join `item_translations` on `item_translations`.`item_id` = `items`.`id` and `item_translations`.`locale` = 'en' and `item_translations`.`status_id` = '5' where exists (select * from `tags` inner join `tagged` on `tags`.`id` = `tagged`.`tag_id` where `items`.`id` = `tagged`.`taggable_id` and `tagged`.`taggable_type` = 'Midade\Items\Models\Item' and exists (select * from `tag_translations` where `tags`.`id` = `tag_translations`.`tag_id` and `slug` in ('tst') and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en'))) and `enabled` = '1' and `library` = '0' and (exists (select * from `videos` where `items`.`id` = `videos`.`item_id` and exists (select * from `video_translations` where `videos`.`id` = `video_translations`.`video_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en')) and exists (select * from `video_translations` where `videos`.`id` = `video_translations`.`video_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en'))) or exists (select * from `articles` where `items`.`id` = `articles`.`item_id` and exists (select * from `article_translations` where `articles`.`id` = `article_translations`.`article_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en')) and exists (select * from `article_translations` where `articles`.`id` = `article_translations`.`article_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en'))) or exists (select * from `audios` where `items`.`id` = `audios`.`item_id` and exists (select * from `audio_translations` where `audios`.`id` = `audio_translations`.`audio_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en')) and exists (select * from `audio_translations` where `audios`.`id` = `audio_translations`.`audio_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en'))) or exists (select * from `books` where `items`.`id` = `books`.`item_id` and exists (select * from `book_translations` where `books`.`id` = `book_translations`.`book_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en')) and exists (select * from `book_translations` where `books`.`id` = `book_translations`.`book_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en'))) or exists (select * from `cards` where `items`.`id` = `cards`.`item_id` and exists (select * from `card_translations` where `cards`.`id` = `card_translations`.`card_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en')) and exists (select * from `card_translations` where `cards`.`id` = `card_translations`.`card_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en')))) and `items`.`id` <> '169' order by RAND() asc limit 3

2.13msemaq_maqraa

Metadata

Bindings

0. en
1. 5
2. Midade\Items\Models\Item
3. tst
4. de
5. en
6. es
7. fr
8. tr
9. ar
10. en
11. 1
12. 0
13. en
14. de
15. en
16. es
17. fr
18. tr
19. ar
20. en
21. en
22. de
23. en
24. es
25. fr
26. tr
27. ar
28. en
29. en
30. de
31. en
32. es
33. fr
34. tr
35. ar
36. en
37. en
38. de
39. en
40. es
41. fr
42. tr
43. ar
44. en
45. en
46. de
47. en
48. es
49. fr
50. tr
51. ar
52. en
53. en
54. de
55. en
56. es
57. fr
58. tr
59. ar
60. en
61. en
62. de
63. en
64. es
65. fr
66. tr
67. ar
68. en
69. en
70. de
71. en
72. es
73. fr
74. tr
75. ar
76. en
77. en
78. de
79. en
80. es
81. fr
82. tr
83. ar
84. en
85. en
86. de
87. en
88. es
89. fr
90. tr
91. ar
92. en
93. 169

Hints

Use SELECT * only if you need all columns from table
ORDER BY RAND() is slow, try to avoid if you can. You can read this or this

_token: MDhdS3DjGgjU6yLNOxc5Tl6lMh0bS5PdMUFPlVzF
_previous: array:1 [ "url" => "http://emaqraa.midadedev.com/en/libraries/books/test-169" ]
PHPDEBUGBAR_STACK_DATA: []

format: html
content_type: text/html; charset=UTF-8
status_text: OK
status_code: 200
request_query: []
request_request: []
request_headers: array:12 [ "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,i...
request_server: array:50 [ "USER" => "emaq" "HOME" => "/home/emaq" "SCRIPT_NAME" => "/index.php" "REQUEST_UR...
request_cookies: []
response_headers: array:5 [ "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ ...
path_info: /en/libraries/books/test-169
session_attributes: array:3 [ "_token" => "MDhdS3DjGgjU6yLNOxc5Tl6lMh0bS5PdMUFPlVzF" "_previous" => array:1 [ "u...

Category List

test

Description

curriculum/frontend::home/common.time_now

Category List

test

Description

Related Subjects