List of Books

There are no items

midade/items::frontend.items.index (public/themes/midade/frontend/utrujja/views/vendor/midade/items/frontend/items/index.blade.php)6blade
Params
0
items
1
type
2
types
3
categories
4
cat_id
5
catName
partials.items.search (public/themes/midade/frontend/utrujja/views/partials/items/search.blade.php)14blade
Params
0
obLevel
1
__env
2
app
3
errors
4
currentUser
5
currentUserRole
6
items
7
type
8
types
9
categories
10
cat_id
11
catName
12
currentLocale
13
title
partials.items.sort (public/themes/midade/frontend/utrujja/views/partials/items/sort.blade.php)15blade
Params
0
obLevel
1
__env
2
app
3
errors
4
currentUser
5
currentUserRole
6
items
7
type
8
types
9
categories
10
cat_id
11
catName
12
currentLocale
13
title
14
user
partials.items.search-form (public/themes/midade/frontend/utrujja/views/partials/items/search-form.blade.php)15blade
Params
0
obLevel
1
__env
2
app
3
errors
4
currentUser
5
currentUserRole
6
items
7
type
8
types
9
categories
10
cat_id
11
catName
12
currentLocale
13
title
14
user
partials.items.public-library-menu (public/themes/midade/frontend/utrujja/views/partials/items/public-library-menu.blade.php)16blade
Params
0
obLevel
1
__env
2
app
3
errors
4
currentUser
5
currentUserRole
6
items
7
type
8
types
9
categories
10
cat_id
11
catName
12
currentLocale
13
__currentLoopData
14
category
15
loop
midade/books::frontend.books.index (public/themes/midade/frontend/utrujja/views/vendor/midade/books/frontend/books/index.blade.php)16blade
Params
0
obLevel
1
__env
2
app
3
errors
4
currentUser
5
currentUserRole
6
items
7
type
8
types
9
categories
10
cat_id
11
catName
12
currentLocale
13
__currentLoopData
14
category
15
loop
pagination::default (resources/views/vendor/pagination/default.blade.php)2blade
Params
0
paginator
1
elements
midade/books::frontend.books.partials.most_popular (public/themes/midade/frontend/utrujja/views/vendor/midade/books/frontend/books/partials/most_popular.blade.php)4blade
Params
0
items
1
type
2
headTitle
3
iconClass

Params
0	`items`
1	`type`
2	`types`
3	`categories`
4	`cat_id`
5	`catName`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`currentUser`
5	`currentUserRole`
6	`items`
7	`type`
8	`types`
9	`categories`
10	`cat_id`
11	`catName`
12	`currentLocale`
13	`title`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`currentUser`
5	`currentUserRole`
6	`items`
7	`type`
8	`types`
9	`categories`
10	`cat_id`
11	`catName`
12	`currentLocale`
13	`title`
14	`user`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`currentUser`
5	`currentUserRole`
6	`items`
7	`type`
8	`types`
9	`categories`
10	`cat_id`
11	`catName`
12	`currentLocale`
13	`title`
14	`user`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`currentUser`
5	`currentUserRole`
6	`items`
7	`type`
8	`types`
9	`categories`
10	`cat_id`
11	`catName`
12	`currentLocale`
13	`__currentLoopData`
14	`category`
15	`loop`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`currentUser`
5	`currentUserRole`
6	`items`
7	`type`
8	`types`
9	`categories`
10	`cat_id`
11	`catName`
12	`currentLocale`
13	`__currentLoopData`
14	`category`
15	`loop`

Params
0	`paginator`
1	`elements`

Params
0	`items`
1	`type`
2	`headTitle`
3	`iconClass`

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


obLevel
__env
app
errors
currentUser
currentUserRole
items
type
types
categories
cat_id
catName
currentLocale
__currentLoopData
category
loop

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`currentUser`
5	`currentUserRole`
6	`items`
7	`type`
8	`types`
9	`categories`
10	`cat_id`
11	`catName`
12	`currentLocale`
13	`__currentLoopData`
14	`category`
15	`loop`

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


obLevel
__env
app
errors
currentUser
currentUserRole
items
type
types
categories
cat_id
catName
currentLocale
__currentLoopData
category
loop

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`currentUser`
5	`currentUserRole`
6	`items`
7	`type`
8	`types`
9	`categories`
10	`cat_id`
11	`catName`
12	`currentLocale`
13	`__currentLoopData`
14	`category`
15	`loop`

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


obLevel
__env
app
errors
currentUser
currentUserRole
items
type
types
categories
cat_id
catName
currentLocale
__currentLoopData
category
loop
innerClass
sliderClass
itemsTypes
firstType

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

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


obLevel
__env
app
errors
currentUser
currentUserRole
items
type
types
categories
cat_id
catName
currentLocale
__currentLoopData
category
loop
innerClass
sliderClass
itemsTypes
firstType
user

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

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


obLevel
__env
app
errors
currentUser
currentUserRole
items
type
types
categories
cat_id
catName
currentLocale
__currentLoopData
category
loop
innerClass
sliderClass
itemsTypes
firstType
user

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

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


obLevel
__env
app
errors
currentUser
currentUserRole
items
type
types
categories
cat_id
catName
currentLocale
__currentLoopData
category
loop
innerClass
version

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

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


obLevel
__env
app
errors
currentUser
currentUserRole
items
type
types
categories
cat_id
catName
currentLocale
__currentLoopData
category
loop
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)16blade
Params
0
obLevel
1
__env
2
app
3
errors
4
currentUser
5
currentUserRole
6
items
7
type
8
types
9
categories
10
cat_id
11
catName
12
currentLocale
13
__currentLoopData
14
category
15
loop

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

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`currentUser`
5	`currentUserRole`
6	`items`
7	`type`
8	`types`
9	`categories`
10	`cat_id`
11	`catName`
12	`currentLocale`
13	`__currentLoopData`
14	`category`
15	`loop`

uri: GET en/libraries/public/{type}/category/{id}
middleware: localizationRedirect, web
as: midade.items.frontend.items.library.public.category
controller: Midade\Items\Http\Controllers\Frontend\ItemsController@ShowPublicLibraryItemsByCategory
namespace: Midade\Items\Http\Controllers\Frontend
prefix: en/libraries
where
file: packages/midade/items/src/Http/Controllers/Frontend/ItemsController.php:543-545

17 statements were executed11.77ms

select * from `pages` where exists (select * from `page_translations` where `pages`.`id` = `page_translations`.`page_id` and `locale` = 'en' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en'))1.89msemaq_maqraa
Metadata
Bindings
0. en
1. de
2. en
3. es
4. fr
5. tr
6. ar
7. en
Hints
Use SELECT * only if you need all columns from table
select * from `page_translations` where `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en') and `page_translations`.`page_id` in ('1', '2', '3', '4', '5', '6')380μsemaq_maqraa
Metadata
Bindings
0. de
1. en
2. es
3. fr
4. tr
5. ar
6. en
7. 1
8. 2
9. 3
10. 4
11. 5
12. 6
Hints
Use SELECT * only if you need all columns from table
select * from `categories` where `categories`.`id` = '3' limit 1640μsemaq_maqraa
Metadata
Bindings
0. 3
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 ('3')690μsemaq_maqraa
Metadata
Bindings
0. de
1. en
2. es
3. fr
4. tr
5. ar
6. en
7. 3
Hints
Use SELECT * only if you need all columns from table

Metadata
Bindings	0. en 1. de 2. en 3. es 4. fr 5. tr 6. ar 7. 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. 1 8. 2 9. 3 10. 4 11. 5 12. 6
Hints	Use `SELECT *` only if you need all columns from table

Metadata
Bindings	0. 3
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. 3
Hints	Use `SELECT *` only if you need all columns from table

select count(*) as aggregate from `items` inner join `item_translations` on `item_translations`.`item_id` = `items`.`id` and `item_translations`.`locale` = ? and `item_translations`.`status_id` = ? left join (SELECT `counter`.`entity_id`, `counter`.`entity_name`, COUNT(*) count FROM `counter` WHERE `counter`.`entity_name` ="Midade\\Items\\Models\\Item" GROUP BY `counter`.`entity_id`) `counter` on `items`.`id` = `counter`.`entity_id` inner join `categorized` on `categorized`.`categorizable_id` = `items`.`id` where 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` = 'en' and `slug` = '5') and `category_id` = 'Midade\Items\Models\Item' and `enabled` = 'books' 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` = '3' and `locale` in ('1', 'en', 'de', 'en', 'es', 'fr', 'tr')) and exists (select * from `video_translations` where `videos`.`id` = `video_translations`.`video_id` and `locale` = 'ar' and `locale` in ('en', 'en', 'de', 'en', 'es', 'fr', 'tr'))) 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` = 'ar' and `locale` in ('en', 'en', 'de', 'en', 'es', 'fr', 'tr')) and exists (select * from `article_translations` where `articles`.`id` = `article_translations`.`article_id` and `locale` = 'ar' and `locale` in ('en', 'en', 'de', 'en', 'es', 'fr', 'tr'))) 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` = 'ar' and `locale` in ('en', 'en', 'de', 'en', 'es', 'fr', 'tr')) and exists (select * from `audio_translations` where `audios`.`id` = `audio_translations`.`audio_id` and `locale` = 'ar' and `locale` in ('en', 'en', 'de', 'en', 'es', 'fr', 'tr'))) 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` = 'ar' and `locale` in ('en', 'en', 'de', 'en', 'es', 'fr', 'tr')) and exists (select * from `book_translations` where `books`.`id` = `book_translations`.`book_id` and `locale` = 'ar' and `locale` in ('en', 'en', 'de', 'en', 'es', 'fr', 'tr'))) 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` = 'ar' and `locale` in ('en', 'en', 'de', 'en', 'es', 'fr', 'tr')) and exists (select * from `card_translations` where `cards`.`id` = `card_translations`.`card_id` and `locale` = 'ar' and `locale` in ('en', 'en', 'de', 'en', 'es', 'fr', 'tr')))) and `library` = 'ar'

2.91msemaq_maqraa

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

Metadata

Bindings

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

select * from `categories` where `slug` = 'items-categories' limit 1400μ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'))330μ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')250μ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. 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')

910μsemaq_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')

930μsemaq_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 `items`.*, `item_translations`.`title`, (select count(*) from `counter` where `items`.`id` = `counter`.`entity_id` and `action` = 'view' and `entity_name` = 'Midade\Items\Models\Item') as `counter_count` 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 `enabled` = '1' and `library` = '0' 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'))) order by `counter_count` desc limit 6

590μsemaq_maqraa

Metadata
Bindings	0. view 1. Midade\Items\Models\Item 2. en 3. 5 4. 1 5. 0 6. Midade\Items\Models\Item 7. books 8. en 9. de 10. en 11. es 12. fr 13. tr 14. ar 15. en
Hints	Use `SELECT *` only if you need all columns from table

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')300μ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
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'580μsemaq_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'220μsemaq_maqraa
Metadata
Bindings
0. 169
1. Midade\Items\Models\Item
2. share

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 1. Midade\Items\Models\Item 2. view

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

_token: OKlKo1dzg5HrFPUolmP7eJSDpNOSRPmfa4F5CSlr
_previous: array:1 [ "url" => "http://emaqraa.midadedev.com/en/libraries/public/books/category/3" ]
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/public/books/category/3
session_attributes: array:3 [ "_token" => "OKlKo1dzg5HrFPUolmP7eJSDpNOSRPmfa4F5CSlr" "_previous" => array:1 [ "u...

List of Books

Category List

Show Category " Sunna " In " Books "

Most read

test

curriculum/frontend::home/common.time_now