test

386 1

Description

content

Messages Timeline Exceptions Views20 Route Queries66 Mails Session Request

1.35s8MBGET en/libraries/{type}/{id}/{slug?}

Booting (1.04s)
Application (538.16ms)

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

66 statements were executed, 43 of which were duplicated, 23 unique60.94ms

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

6.23msemaq_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')520μ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')900μ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 ('')330μsemaq_maqraa
Metadata
Bindings
0.
Hints
Use SELECT * only if you need all columns from table
select * from `items` where `items`.`id` = '169' limit 1680μ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')500μ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')430μ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 ('')360μ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` = '3.142.186.181' and `user_id` is null) limit 1

3.28msemaq_maqraa

Metadata
Bindings	0. 169 1. 169 2. Midade\Items\Models\Item 3. view 4. 3.142.186.181
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', '3.142.186.181', '', '2025-04-10 23:26:54', '2025-04-10 23:26:54')3.32msemaq_maqraa
Metadata
Bindings
0. 169
1. Midade\Items\Models\Item
2. view
3. 3.142.186.181
4.
5. 2025-04-10 23:26:54
6. 2025-04-10 23:26:54
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'980μ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'1.62msemaq_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')1.08msemaq_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.19msemaq_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')870μ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 1300μ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')270μ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. 3.142.186.181 4. 5. 2025-04-10 23:26:54 6. 2025-04-10 23:26:54

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')

5.15msemaq_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.17msemaq_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')810μ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.67msemaq_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'))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')290μ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 1380μ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'))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')270μ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.01msemaq_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'))310μ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 `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 1950μ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 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.74msemaq_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'2.09msemaq_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'))770μ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'))1msemaq_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'))710μ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'))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 `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')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 * 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'))1.09msemaq_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')270μ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 1430μ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'))300μ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')790μ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 1770μ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'))620μ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')510μ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 1600μ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'))540μ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')340μ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'))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 `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` = 'word_attachment' order by `order` asc limit 1410μ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'))340μ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')420μ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'))410μ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')2.64msemaq_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 1570μ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'))630μ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'))340μ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')280μ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.18msemaq_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

select * from `informations` where `type` in ('facebook', 'twitter', 'youtube', 'instagram', 'telegram', 'whatsapp')720μsemaq_maqraa
Metadata
Bindings
0. facebook
1. twitter
2. youtube
3. instagram
4. telegram
5. whatsapp
Hints
Use SELECT * only if you need all columns from table
select * from `information_translations` where `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en') and `information_translations`.`information_id` in ('7', '9', '10', '11')490μsemaq_maqraa
Metadata
Bindings
0. de
1. en
2. es
3. fr
4. tr
5. ar
6. en
7. 7
8. 9
9. 10
10. 11
Hints
Use SELECT * only if you need all columns from table

_token: 0eBqLhW5Lix9aOISbJM5L0t7Qg8m0rFK4xF4GTAK
_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" => "0eBqLhW5Lix9aOISbJM5L0t7Qg8m0rFK4xF4GTAK" "_previous" => array:1 [ "u...

Category List

test

Description

curriculum/frontend::home/common.time_now

Metadata
Bindings	0. facebook 1. twitter 2. youtube 3. instagram 4. telegram 5. whatsapp
Hints	Use `SELECT *` only if you need all columns from table

Category List

test

Description

Related Subjects