قائمة البطاقات

كل البطاقات

علامات الوقف والضبط

علامات الوقف والضبط

580 0
12 صفة سلبية في الإنسان ذكرها القرآن

12 صفة سلبية في الإنسان ذكرها القرآن

538 0
آداب التلاوة

آداب التلاوة

561 0
انفوجرافيك النون الساكنة والتنوين

انفوجرافيك النون الساكنة والتنوين

580 0
ما هي مخارج الحروف

مخارج الحروف

558 0

الأكثر مشاهدة

علامات الوقف والضبط

580 0

انفوجرافيك النون الساكنة والتنوين

580 0

آداب التلاوة

561 0

ما هي مخارج الحروف

مخارج الحروف

558 0

12 صفة سلبية في الإنسان ذكرها القرآن

538 0

Messages Timeline Exceptions Views16 Route Queries46 Mails Session Request

4.52s12MBGET ar/libraries/public/{type?}

Booting (3.13s)
Application (2s)

16 templates were rendered

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/cards::frontend.cards.index (public/themes/midade/frontend/utrujja/views/vendor/midade/cards/frontend/cards/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/cards::frontend.cards.partials.most_popular (public/themes/midade/frontend/utrujja/views/vendor/midade/cards/frontend/cards/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 ar/libraries/public/{type?}
middleware: localizationRedirect, web
as: midade.items.frontend.items.library.public
controller: Midade\Items\Http\Controllers\Frontend\ItemsController@overrideNewShowPublicLibraryItems
namespace: Midade\Items\Http\Controllers\Frontend
prefix: ar/libraries
where
file: packages/midade/items/src/Http/Controllers/Frontend/ItemsController.php:447-541

46 statements were executed, 26 of which were duplicated, 20 unique437.96ms

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` 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` = 'ar' and `slug` = '5') and `enabled` = 'Midade\Items\Models\Item' 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` = 'cards' and `locale` in ('1', 'ar', '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', 'ar', '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', 'ar', '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', 'ar', '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', 'ar', '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', 'ar', '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', 'ar', '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', 'ar', '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', 'ar', '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', 'ar', 'de', 'en', 'es', 'fr', 'tr')))) and `library` = 'ar'

141msemaq_maqraa

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

Metadata

Bindings

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

select `items`.*, `item_translations`.`title`, `item_translations`.`description`, `counter`.`count` 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` 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` = 'ar' and `slug` = '5') and `enabled` = 'Midade\Items\Models\Item' 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` = 'cards' and `locale` in ('1', 'ar', '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', 'ar', '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', 'ar', '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', 'ar', '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', 'ar', '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', 'ar', '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', 'ar', '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', 'ar', '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', 'ar', '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', 'ar', 'de', 'en', 'es', 'fr', 'tr')))) and `library` = 'ar' order by `items`.`created_at` desc limit 12 offset 0

122.44msemaq_maqraa

Metadata

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

Bindings

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

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 ('89', '90', '91', '92', '93')920μsemaq_maqraa
Metadata
Bindings
0. de
1. en
2. es
3. fr
4. tr
5. ar
6. en
7. 89
8. 90
9. 91
10. 92
11. 93
Hints
Use SELECT * only if you need all columns from table
select * from `files` where `files`.`id` in ('142', '143', '144', '145', '146')470μsemaq_maqraa
Metadata
Bindings
0. 142
1. 143
2. 144
3. 145
4. 146
Hints
Use SELECT * only if you need all columns from table
select * from `files` where `files`.`id` in ('')380μsemaq_maqraa
Metadata
Bindings
0.
Hints
Use SELECT * only if you need all columns from table
select * from `categories` where `slug` = 'items-categories' limit 1890μ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')810μ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` = 'ar' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en'))730μsemaq_maqraa
Metadata
Bindings
0. 2
1. 32
2. 1
3. ar
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. 89 8. 90 9. 91 10. 92 11. 93
Hints	Use `SELECT *` only if you need all columns from table

Metadata
Bindings	0. 142 1. 143 2. 144 3. 145 4. 146
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. 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. ar 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 ('38', '39', '40', '41', '42', '43', '44', '45', '46', '47', '48', '64', '65')

620μsemaq_maqraa

Metadata
Bindings	0. de 1. en 2. es 3. fr 4. tr 5. ar 6. en 7. 38 8. 39 9. 40 10. 41 11. 42 12. 43 13. 44 14. 45 15. 46 16. 47 17. 48 18. 64 19. 65
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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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-drws-altjwyd')

2.83msemaq_maqraa

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

Metadata

Bindings

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

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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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-drws-altjwyd-tmhyd')

2.84msemaq_maqraa

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

Metadata

Bindings

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

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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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-drws-altjwyd-mkharj-alhrwf')

2.85msemaq_maqraa

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

Metadata

Bindings

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

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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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-drws-altjwyd-sfat-alhrwf')

2.73msemaq_maqraa

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

Metadata

Bindings

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

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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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-drws-altjwyd-altfkhym-waltrqyq')

2.73msemaq_maqraa

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

Metadata

Bindings

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

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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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-drws-altjwyd-ahkam-alnwn-alsaknt-waltnwyn')

3.06msemaq_maqraa

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

Metadata

Bindings

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

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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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-drws-altjwyd-ahkam-almym-alsaknt')

3.6msemaq_maqraa

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

Metadata

Bindings

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

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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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-drws-altjwyd-hkm-lam-al-wlam-alfal')

4.73msemaq_maqraa

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

Metadata

Bindings

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

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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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-drws-altjwyd-almthlyn-walmtjansyn-walmtqarbyn')

2.99msemaq_maqraa

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

Metadata

Bindings

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

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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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-drws-altjwyd-almd')

49.6msemaq_maqraa

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

Metadata

Bindings

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

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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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-drws-altjwyd-alwqf')

4.62msemaq_maqraa

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

Metadata

Bindings

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

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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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-drws-altjwyd-jdyd-akhtbar')

2.77msemaq_maqraa

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

Metadata

Bindings

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

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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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` = 'ar' 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-test')

2.79msemaq_maqraa

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

Metadata

Bindings

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

select count(*) as aggregate from `counter` where `counter`.`entity_id` = '93' and `counter`.`entity_id` is not null and `entity_name` = 'Midade\Items\Models\Item' and `action` = 'view'2.26msemaq_maqraa
Metadata
Bindings
0. 93
1. Midade\Items\Models\Item
2. view
select count(*) as aggregate from `counter` where `counter`.`entity_id` = '93' and `counter`.`entity_id` is not null and `entity_name` = 'Midade\Items\Models\Item' and `action` = 'share'1.56msemaq_maqraa
Metadata
Bindings
0. 93
1. Midade\Items\Models\Item
2. share
select count(*) as aggregate from `counter` where `counter`.`entity_id` = '92' and `counter`.`entity_id` is not null and `entity_name` = 'Midade\Items\Models\Item' and `action` = 'view'2.18msemaq_maqraa
Metadata
Bindings
0. 92
1. Midade\Items\Models\Item
2. view
select count(*) as aggregate from `counter` where `counter`.`entity_id` = '92' and `counter`.`entity_id` is not null and `entity_name` = 'Midade\Items\Models\Item' and `action` = 'share'3.5msemaq_maqraa
Metadata
Bindings
0. 92
1. Midade\Items\Models\Item
2. share
select count(*) as aggregate from `counter` where `counter`.`entity_id` = '91' and `counter`.`entity_id` is not null and `entity_name` = 'Midade\Items\Models\Item' and `action` = 'view'3.47msemaq_maqraa
Metadata
Bindings
0. 91
1. Midade\Items\Models\Item
2. view
select count(*) as aggregate from `counter` where `counter`.`entity_id` = '91' and `counter`.`entity_id` is not null and `entity_name` = 'Midade\Items\Models\Item' and `action` = 'share'3.33msemaq_maqraa
Metadata
Bindings
0. 91
1. Midade\Items\Models\Item
2. share
select count(*) as aggregate from `counter` where `counter`.`entity_id` = '90' and `counter`.`entity_id` is not null and `entity_name` = 'Midade\Items\Models\Item' and `action` = 'view'2.39msemaq_maqraa
Metadata
Bindings
0. 90
1. Midade\Items\Models\Item
2. view
select count(*) as aggregate from `counter` where `counter`.`entity_id` = '90' and `counter`.`entity_id` is not null and `entity_name` = 'Midade\Items\Models\Item' and `action` = 'share'2msemaq_maqraa
Metadata
Bindings
0. 90
1. Midade\Items\Models\Item
2. share
select count(*) as aggregate from `counter` where `counter`.`entity_id` = '89' and `counter`.`entity_id` is not null and `entity_name` = 'Midade\Items\Models\Item' and `action` = 'view'2.7msemaq_maqraa
Metadata
Bindings
0. 89
1. Midade\Items\Models\Item
2. view
select count(*) as aggregate from `counter` where `counter`.`entity_id` = '89' and `counter`.`entity_id` is not null and `entity_name` = 'Midade\Items\Models\Item' and `action` = 'share'2.24msemaq_maqraa
Metadata
Bindings
0. 89
1. Midade\Items\Models\Item
2. share

Metadata
Bindings	0. 93 1. Midade\Items\Models\Item 2. view

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

Metadata
Bindings	0. 92 1. Midade\Items\Models\Item 2. view

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

Metadata
Bindings	0. 91 1. Midade\Items\Models\Item 2. view

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

Metadata
Bindings	0. 90 1. Midade\Items\Models\Item 2. view

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

Metadata
Bindings	0. 89 1. Midade\Items\Models\Item 2. view

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

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` = 'ar' 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` = 'cards') and 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 ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en'))) order by `counter_count` desc limit 6

52.16msemaq_maqraa

Metadata
Bindings	0. view 1. Midade\Items\Models\Item 2. ar 3. 5 4. 1 5. 0 6. Midade\Items\Models\Item 7. cards 8. ar 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 ('89', '90', '91', '92', '93')340μsemaq_maqraa
Metadata
Bindings
0. de
1. en
2. es
3. fr
4. tr
5. ar
6. en
7. 89
8. 90
9. 91
10. 92
11. 93
Hints
Use SELECT * only if you need all columns from table
select * from `files` where `files`.`id` in ('142', '143', '144', '145', '146')270μsemaq_maqraa
Metadata
Bindings
0. 142
1. 143
2. 144
3. 145
4. 146
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` = '93' and `counter`.`entity_id` is not null and `entity_name` = 'Midade\Items\Models\Item' and `action` = 'view'350μsemaq_maqraa
Metadata
Bindings
0. 93
1. Midade\Items\Models\Item
2. view
select count(*) as aggregate from `counter` where `counter`.`entity_id` = '93' and `counter`.`entity_id` is not null and `entity_name` = 'Midade\Items\Models\Item' and `action` = 'share'230μsemaq_maqraa
Metadata
Bindings
0. 93
1. Midade\Items\Models\Item
2. share
select count(*) as aggregate from `counter` where `counter`.`entity_id` = '90' and `counter`.`entity_id` is not null and `entity_name` = 'Midade\Items\Models\Item' and `action` = 'view'370μsemaq_maqraa
Metadata
Bindings
0. 90
1. Midade\Items\Models\Item
2. view
select count(*) as aggregate from `counter` where `counter`.`entity_id` = '90' and `counter`.`entity_id` is not null and `entity_name` = 'Midade\Items\Models\Item' and `action` = 'share'230μsemaq_maqraa
Metadata
Bindings
0. 90
1. Midade\Items\Models\Item
2. share
select count(*) as aggregate from `counter` where `counter`.`entity_id` = '91' and `counter`.`entity_id` is not null and `entity_name` = 'Midade\Items\Models\Item' and `action` = 'view'350μsemaq_maqraa
Metadata
Bindings
0. 91
1. Midade\Items\Models\Item
2. view
select count(*) as aggregate from `counter` where `counter`.`entity_id` = '91' and `counter`.`entity_id` is not null and `entity_name` = 'Midade\Items\Models\Item' and `action` = 'share'230μsemaq_maqraa
Metadata
Bindings
0. 91
1. Midade\Items\Models\Item
2. share
select count(*) as aggregate from `counter` where `counter`.`entity_id` = '89' and `counter`.`entity_id` is not null and `entity_name` = 'Midade\Items\Models\Item' and `action` = 'view'360μsemaq_maqraa
Metadata
Bindings
0. 89
1. Midade\Items\Models\Item
2. view
select count(*) as aggregate from `counter` where `counter`.`entity_id` = '89' and `counter`.`entity_id` is not null and `entity_name` = 'Midade\Items\Models\Item' and `action` = 'share'230μsemaq_maqraa
Metadata
Bindings
0. 89
1. Midade\Items\Models\Item
2. share
select count(*) as aggregate from `counter` where `counter`.`entity_id` = '92' and `counter`.`entity_id` is not null and `entity_name` = 'Midade\Items\Models\Item' and `action` = 'view'350μsemaq_maqraa
Metadata
Bindings
0. 92
1. Midade\Items\Models\Item
2. view
select count(*) as aggregate from `counter` where `counter`.`entity_id` = '92' and `counter`.`entity_id` is not null and `entity_name` = 'Midade\Items\Models\Item' and `action` = 'share'230μsemaq_maqraa
Metadata
Bindings
0. 92
1. Midade\Items\Models\Item
2. share

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

_token: LpvQy3bvEj9wmMliu49T8OYuD9SmYprDJY2TVuUe
_previous: array:1 [ "url" => "https://emaqraa.midadedev.com/ar/libraries/public/cards" ]
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:20 [ "x-https" => array:1 [ 0 => "1" ] "sec-fetch-dest" => array:1 [ 0 => "docum...
request_server: array:60 [ "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: /ar/libraries/public/cards
session_attributes: array:3 [ "_token" => "LpvQy3bvEj9wmMliu49T8OYuD9SmYprDJY2TVuUe" "_previous" => array:1 [ "u...

قائمة البطاقات

قائمة التصنيفات

كل البطاقات

علامات الوقف والضبط

12 صفة سلبية في الإنسان ذكرها القرآن

آداب التلاوة

انفوجرافيك النون الساكنة والتنوين

ما هي مخارج الحروف

الأكثر مشاهدة

علامات الوقف والضبط

انفوجرافيك النون الساكنة والتنوين

آداب التلاوة

ما هي مخارج الحروف

12 صفة سلبية في الإنسان ذكرها القرآن

التوقيت الآن