غاية المريد في علم التجويد
565
0
الوصف
- المؤلف: عطية قابل نصر
Params | |
---|---|
0 |
|
1 |
|
2 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
Params | |
---|---|
0 |
|
1 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
select * from `items` where exists (select * from `item_translations` where `items`.`id` = `item_translations`.`item_id` and `locale` = 'ar' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en')) and exists (select * from `item_translations` where `items`.`id` = `item_translations`.`item_id` and `item_translations`.`status_id` = '5' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en')) and exists (select * from `item_translations` where `items`.`id` = `item_translations`.`item_id` and `item_translations`.`slug` = 'غاية-المريد-في-علم-التجويد-81' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en')) and exists (select * from `items_types` inner join `typeables` on `items_types`.`id` = `typeables`.`typeable_id` where `items`.`id` = `typeables`.`item_id` and `typeables`.`typeable_type` = 'Midade\Items\Models\Item' and `slug` = 'books') and exists (select * from `books` where `items`.`id` = `books`.`item_id` and exists (select * from `book_translations` where `books`.`id` = `book_translations`.`book_id` and `locale` = 'ar' and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en'))) and `enabled` = '1' limit 1
6.51msemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `item_translations` where `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en') and `item_translations`.`item_id` in ('81')
550μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `files` where `files`.`id` in ('126')
410μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `files` where `files`.`id` in ('')
300μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `items` where `items`.`id` = '81' limit 1
510μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `item_translations` where `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en') and `item_translations`.`item_id` in ('81')
380μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `files` where `files`.`id` in ('126')
340μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `files` where `files`.`id` in ('')
300μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `counter` where `counter`.`entity_id` = '81' and `counter`.`entity_id` is not null and (`entity_id` = '81' and `entity_name` = 'Midade\Items\Models\Item' and `action` = 'view' and `ip_address` = '18.190.158.237' and `user_id` is null) limit 1
2.32msemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
insert into `counter` (`entity_id`, `entity_name`, `action`, `ip_address`, `user_id`, `updated_at`, `created_at`) values ('81', 'Midade\Items\Models\Item', 'view', '18.190.158.237', '', '2025-04-17 17:02:12', '2025-04-17 17:02:12')
790μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
select `items_types`.*, `typeables`.`item_id` as `pivot_item_id`, `typeables`.`typeable_id` as `pivot_typeable_id`, `typeables`.`created_at` as `pivot_created_at`, `typeables`.`updated_at` as `pivot_updated_at` from `items_types` inner join `typeables` on `items_types`.`id` = `typeables`.`typeable_id` where `typeables`.`item_id` = '81' and `typeables`.`typeable_type` = 'Midade\Items\Models\Item'
510μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
select `tags`.*, `tagged`.`taggable_id` as `pivot_taggable_id`, `tagged`.`tag_id` as `pivot_tag_id` from `tags` inner join `tagged` on `tags`.`id` = `tagged`.`tag_id` where `tagged`.`taggable_id` = '81' and `tagged`.`taggable_type` = 'Midade\Items\Models\Item'
740μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `tag_translations` where `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en') and `tag_translations`.`tag_id` in ('6')
620μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select `categories`.*, `categorized`.`categorizable_id` as `pivot_categorizable_id`, `categorized`.`category_id` as `pivot_category_id`, `categorized`.`created_at` as `pivot_created_at`, `categorized`.`updated_at` as `pivot_updated_at` from `categories` inner join `categorized` on `categories`.`id` = `categorized`.`category_id` where `categorized`.`categorizable_id` = '81' and `categorized`.`categorizable_type` = 'Midade\Items\Models\Item'
1.02msemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `category_translations` where `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en') and `category_translations`.`category_id` in ('38')
490μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `categories` where `slug` = 'items-categories' limit 1
230μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `category_translations` where `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en') and `category_translations`.`category_id` in ('1')
210μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
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'))
47.75msemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
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')
880μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
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')
5.12msemaq_maqraaMetadata | |
---|---|
Bindings |
|
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')
3.61msemaq_maqraaMetadata | |
---|---|
Bindings |
|
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')
3.65msemaq_maqraaMetadata | |
---|---|
Bindings |
|
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')
3.91msemaq_maqraaMetadata | |
---|---|
Bindings |
|
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')
3.13msemaq_maqraaMetadata | |
---|---|
Bindings |
|
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')
2.87msemaq_maqraaMetadata | |
---|---|
Bindings |
|
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')
2.58msemaq_maqraaMetadata | |
---|---|
Bindings |
|
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')
2.24msemaq_maqraaMetadata | |
---|---|
Bindings |
|
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.56msemaq_maqraaMetadata | |
---|---|
Bindings |
|
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')
2.24msemaq_maqraaMetadata | |
---|---|
Bindings |
|
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')
2.19msemaq_maqraaMetadata | |
---|---|
Bindings |
|
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.6msemaq_maqraaMetadata | |
---|---|
Bindings |
|
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.22msemaq_maqraaMetadata | |
---|---|
Bindings |
|
select * from `books` where `books`.`item_id` = '81' and `books`.`item_id` is not null 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'))
510μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `book_translations` where `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en') and `book_translations`.`book_id` in ('6')
440μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select `files`.*, `attachables`.`attachable_id` as `pivot_attachable_id`, `attachables`.`file_id` as `pivot_file_id`, `attachables`.`zone` as `pivot_zone`, `attachables`.`id` as `pivot_id`, `attachables`.`created_at` as `pivot_created_at`, `attachables`.`updated_at` as `pivot_updated_at` from `files` inner join `attachables` on `files`.`id` = `attachables`.`file_id` where `attachables`.`attachable_id` = '6' and `attachables`.`attachable_type` = 'Midade\Books\Models\BookTranslation' and `attachables`.`zone` = 'attachments' order by `order` asc limit 1
1.1msemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `books` where `books`.`item_id` = '81' and `books`.`item_id` is not null 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'))
290μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `book_translations` where `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en') and `book_translations`.`book_id` in ('6')
260μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select `files`.*, `attachables`.`attachable_id` as `pivot_attachable_id`, `attachables`.`file_id` as `pivot_file_id`, `attachables`.`zone` as `pivot_zone`, `attachables`.`id` as `pivot_id`, `attachables`.`created_at` as `pivot_created_at`, `attachables`.`updated_at` as `pivot_updated_at` from `files` inner join `attachables` on `files`.`id` = `attachables`.`file_id` where `attachables`.`attachable_id` = '6' and `attachables`.`attachable_type` = 'Midade\Books\Models\BookTranslation' and `attachables`.`zone` = 'attachments' order by `order` asc limit 1
300μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `books` where `books`.`item_id` = '81' and `books`.`item_id` is not null 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'))
290μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `book_translations` where `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en') and `book_translations`.`book_id` in ('6')
260μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select `files`.*, `attachables`.`attachable_id` as `pivot_attachable_id`, `attachables`.`file_id` as `pivot_file_id`, `attachables`.`zone` as `pivot_zone`, `attachables`.`id` as `pivot_id`, `attachables`.`created_at` as `pivot_created_at`, `attachables`.`updated_at` as `pivot_updated_at` from `files` inner join `attachables` on `files`.`id` = `attachables`.`file_id` where `attachables`.`attachable_id` = '6' and `attachables`.`attachable_type` = 'Midade\Books\Models\BookTranslation' and `attachables`.`zone` = 'word_attachment' order by `order` asc limit 1
880μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `books` where `books`.`item_id` = '81' and `books`.`item_id` is not null 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'))
280μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `book_translations` where `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en') and `book_translations`.`book_id` in ('6')
290μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select `files`.*, `attachables`.`attachable_id` as `pivot_attachable_id`, `attachables`.`file_id` as `pivot_file_id`, `attachables`.`zone` as `pivot_zone`, `attachables`.`id` as `pivot_id`, `attachables`.`created_at` as `pivot_created_at`, `attachables`.`updated_at` as `pivot_updated_at` from `files` inner join `attachables` on `files`.`id` = `attachables`.`file_id` where `attachables`.`attachable_id` = '6' and `attachables`.`attachable_type` = 'Midade\Books\Models\BookTranslation' and `attachables`.`zone` = 'ppt_attachment' order by `order` asc limit 1
900μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select count(*) as aggregate from `counter` where `counter`.`entity_id` = '81' and `counter`.`entity_id` is not null and `entity_name` = 'Midade\Items\Models\Item' and `action` = 'view'
2.78msemaq_maqraaMetadata | |
---|---|
Bindings |
|
select count(*) as aggregate from `counter` where `counter`.`entity_id` = '81' and `counter`.`entity_id` is not null and `entity_name` = 'Midade\Items\Models\Item' and `action` = 'share'
2.43msemaq_maqraaMetadata | |
---|---|
Bindings |
|
select * from `audios` where `audios`.`item_id` = '81' and `audios`.`item_id` is not null 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'))
930μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `videos` where `videos`.`item_id` = '81' and `videos`.`item_id` is not null 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'))
630μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `articles` where `articles`.`item_id` = '81' and `articles`.`item_id` is not null 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'))
520μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `articles` where `articles`.`item_id` = '81' and `articles`.`item_id` is not null 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'))
270μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `books` where `books`.`item_id` = '81' and `books`.`item_id` is not null 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'))
280μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `book_translations` where `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en') and `book_translations`.`book_id` in ('6')
250μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `books` where `books`.`item_id` = '81' and `books`.`item_id` is not null 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'))
270μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `book_translations` where `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en') and `book_translations`.`book_id` in ('6')
250μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select `files`.*, `attachables`.`attachable_id` as `pivot_attachable_id`, `attachables`.`file_id` as `pivot_file_id`, `attachables`.`zone` as `pivot_zone`, `attachables`.`id` as `pivot_id`, `attachables`.`created_at` as `pivot_created_at`, `attachables`.`updated_at` as `pivot_updated_at` from `files` inner join `attachables` on `files`.`id` = `attachables`.`file_id` where `attachables`.`attachable_id` = '6' and `attachables`.`attachable_type` = 'Midade\Books\Models\BookTranslation' and `attachables`.`zone` = 'attachments' order by `order` asc limit 1
320μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `books` where `books`.`item_id` = '81' and `books`.`item_id` is not null 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'))
290μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `book_translations` where `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en') and `book_translations`.`book_id` in ('6')
250μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select `files`.*, `attachables`.`attachable_id` as `pivot_attachable_id`, `attachables`.`file_id` as `pivot_file_id`, `attachables`.`zone` as `pivot_zone`, `attachables`.`id` as `pivot_id`, `attachables`.`created_at` as `pivot_created_at`, `attachables`.`updated_at` as `pivot_updated_at` from `files` inner join `attachables` on `files`.`id` = `attachables`.`file_id` where `attachables`.`attachable_id` = '6' and `attachables`.`attachable_type` = 'Midade\Books\Models\BookTranslation' and `attachables`.`zone` = 'attachments' order by `order` asc limit 1
320μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `books` where `books`.`item_id` = '81' and `books`.`item_id` is not null 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'))
280μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `book_translations` where `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en') and `book_translations`.`book_id` in ('6')
250μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select `files`.*, `attachables`.`attachable_id` as `pivot_attachable_id`, `attachables`.`file_id` as `pivot_file_id`, `attachables`.`zone` as `pivot_zone`, `attachables`.`id` as `pivot_id`, `attachables`.`created_at` as `pivot_created_at`, `attachables`.`updated_at` as `pivot_updated_at` from `files` inner join `attachables` on `files`.`id` = `attachables`.`file_id` where `attachables`.`attachable_id` = '6' and `attachables`.`attachable_type` = 'Midade\Books\Models\BookTranslation' and `attachables`.`zone` = 'attachments' order by `order` asc limit 1
300μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `books` where `books`.`item_id` = '81' and `books`.`item_id` is not null 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'))
280μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `book_translations` where `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en') and `book_translations`.`book_id` in ('6')
250μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `books` where `books`.`item_id` = '81' and `books`.`item_id` is not null 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'))
270μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `book_translations` where `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en') and `book_translations`.`book_id` in ('6')
250μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select `files`.*, `attachables`.`attachable_id` as `pivot_attachable_id`, `attachables`.`file_id` as `pivot_file_id`, `attachables`.`zone` as `pivot_zone`, `attachables`.`id` as `pivot_id`, `attachables`.`created_at` as `pivot_created_at`, `attachables`.`updated_at` as `pivot_updated_at` from `files` inner join `attachables` on `files`.`id` = `attachables`.`file_id` where `attachables`.`attachable_id` = '6' and `attachables`.`attachable_type` = 'Midade\Books\Models\BookTranslation' and `attachables`.`zone` = 'word_attachment' order by `order` asc limit 1
310μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `books` where `books`.`item_id` = '81' and `books`.`item_id` is not null 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'))
290μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `book_translations` where `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en') and `book_translations`.`book_id` in ('6')
250μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `books` where `books`.`item_id` = '81' and `books`.`item_id` is not null 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'))
270μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `book_translations` where `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en') and `book_translations`.`book_id` in ('6')
250μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select `files`.*, `attachables`.`attachable_id` as `pivot_attachable_id`, `attachables`.`file_id` as `pivot_file_id`, `attachables`.`zone` as `pivot_zone`, `attachables`.`id` as `pivot_id`, `attachables`.`created_at` as `pivot_created_at`, `attachables`.`updated_at` as `pivot_updated_at` from `files` inner join `attachables` on `files`.`id` = `attachables`.`file_id` where `attachables`.`attachable_id` = '6' and `attachables`.`attachable_type` = 'Midade\Books\Models\BookTranslation' and `attachables`.`zone` = 'ppt_attachment' order by `order` asc limit 1
300μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `cards` where `cards`.`item_id` = '81' and `cards`.`item_id` is not null 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'))
450μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `books` where `books`.`item_id` = '81' and `books`.`item_id` is not null 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'))
270μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `book_translations` where `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en') and `book_translations`.`book_id` in ('6')
250μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select `items`.*, `item_translations`.`title` 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 exists (select * from `tags` inner join `tagged` on `tags`.`id` = `tagged`.`tag_id` where `items`.`id` = `tagged`.`taggable_id` and `tagged`.`taggable_type` = 'Midade\Items\Models\Item' and exists (select * from `tag_translations` where `tags`.`id` = `tag_translations`.`tag_id` and `slug` in ('altjwyd') and `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en'))) and `enabled` = '1' and `library` = '0' and (exists (select * from `videos` where `items`.`id` = `videos`.`item_id` and exists (select * from `video_translations` where `videos`.`id` = `video_translations`.`video_id` and `locale` = '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 `items`.`id` <> '81' order by RAND() asc limit 3
3.5msemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
select * from `item_translations` where `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en') and `item_translations`.`item_id` in ('62', '89', '91')
710μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `files` where `files`.`id` in ('117', '142', '144')
380μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `files` where `files`.`id` in ('')
230μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select `items_types`.*, `typeables`.`item_id` as `pivot_item_id`, `typeables`.`typeable_id` as `pivot_typeable_id`, `typeables`.`created_at` as `pivot_created_at`, `typeables`.`updated_at` as `pivot_updated_at` from `items_types` inner join `typeables` on `items_types`.`id` = `typeables`.`typeable_id` where `typeables`.`item_id` = '89' and `typeables`.`typeable_type` = 'Midade\Items\Models\Item' limit 1
520μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
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.36msemaq_maqraaMetadata | |
---|---|
Bindings |
|
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.01msemaq_maqraaMetadata | |
---|---|
Bindings |
|
select `items_types`.*, `typeables`.`item_id` as `pivot_item_id`, `typeables`.`typeable_id` as `pivot_typeable_id`, `typeables`.`created_at` as `pivot_created_at`, `typeables`.`updated_at` as `pivot_updated_at` from `items_types` inner join `typeables` on `items_types`.`id` = `typeables`.`typeable_id` where `typeables`.`item_id` = '91' and `typeables`.`typeable_type` = 'Midade\Items\Models\Item' limit 1
680μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
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.22msemaq_maqraaMetadata | |
---|---|
Bindings |
|
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'
2.77msemaq_maqraaMetadata | |
---|---|
Bindings |
|
select `items_types`.*, `typeables`.`item_id` as `pivot_item_id`, `typeables`.`typeable_id` as `pivot_typeable_id`, `typeables`.`created_at` as `pivot_created_at`, `typeables`.`updated_at` as `pivot_updated_at` from `items_types` inner join `typeables` on `items_types`.`id` = `typeables`.`typeable_id` where `typeables`.`item_id` = '62' and `typeables`.`typeable_type` = 'Midade\Items\Models\Item' limit 1
730μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select count(*) as aggregate from `counter` where `counter`.`entity_id` = '62' and `counter`.`entity_id` is not null and `entity_name` = 'Midade\Items\Models\Item' and `action` = 'view'
7.93msemaq_maqraaMetadata | |
---|---|
Bindings |
|
select count(*) as aggregate from `counter` where `counter`.`entity_id` = '62' and `counter`.`entity_id` is not null and `entity_name` = 'Midade\Items\Models\Item' and `action` = 'share'
2.57msemaq_maqraaMetadata | |
---|---|
Bindings |
|