غاية المريد في علم التجويد
567
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
4.62msemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `item_translations` where `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en') and `item_translations`.`item_id` in ('81')
500μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `files` where `files`.`id` in ('126')
430μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `files` where `files`.`id` in ('')
210μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `items` where `items`.`id` = '81' limit 1
790μ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')
390μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `files` where `files`.`id` in ('126')
320μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `files` where `files`.`id` in ('')
280μ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.219.125.103' and `user_id` is null) limit 1
4.28msemaq_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.219.125.103', '', '2025-04-18 04:33:04', '2025-04-18 04:33:04')
1.63msemaq_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'
950μ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'
950μ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')
720μ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'
810μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `category_translations` where `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en') and `category_translations`.`category_id` in ('38')
570μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `categories` where `slug` = 'items-categories' limit 1
270μ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')
260μ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'))
390μsemaq_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')
290μ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')
1.63msemaq_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')
630μsemaq_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')
610μsemaq_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')
640μsemaq_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')
620μsemaq_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')
780μsemaq_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')
720μsemaq_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')
660μsemaq_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')
870μsemaq_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')
750μsemaq_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')
710μsemaq_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')
790μsemaq_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')
900μsemaq_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'))
730μ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')
850μ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.23msemaq_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'))
360μ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')
340μ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
420μ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'))
1.08msemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `book_translations` where `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en') and `book_translations`.`book_id` in ('6')
1.71msemaq_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
1.4msemaq_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'))
310μ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
1.49msemaq_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'
3.24msemaq_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.84msemaq_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'))
530μ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'))
500μ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'))
350μ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'))
430μ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')
340μ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'))
380μ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')
340μ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
470μ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'))
410μ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')
350μ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
430μ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'))
390μ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')
340μ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
440μ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'))
390μ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')
350μ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'))
390μ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')
340μ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
400μ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'))
370μ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')
340μ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'))
380μ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')
340μ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
440μ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'))
640μ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'))
420μ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')
340μ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.86msemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
select * from `item_translations` where `locale` in ('de', 'en', 'es', 'fr', 'tr', 'ar', 'en') and `item_translations`.`item_id` in ('74', '79', '85')
790μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `files` where `files`.`id` in ('117', '121', '134')
820μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `files` where `files`.`id` in ('')
290μ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` = '79' and `typeables`.`typeable_type` = 'Midade\Items\Models\Item' limit 1
690μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select count(*) as aggregate from `counter` where `counter`.`entity_id` = '79' and `counter`.`entity_id` is not null and `entity_name` = 'Midade\Items\Models\Item' and `action` = 'view'
2.3msemaq_maqraaMetadata | |
---|---|
Bindings |
|
select count(*) as aggregate from `counter` where `counter`.`entity_id` = '79' and `counter`.`entity_id` is not null and `entity_name` = 'Midade\Items\Models\Item' and `action` = 'share'
1.42msemaq_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` = '85' and `typeables`.`typeable_type` = 'Midade\Items\Models\Item' limit 1
640μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select count(*) as aggregate from `counter` where `counter`.`entity_id` = '85' and `counter`.`entity_id` is not null and `entity_name` = 'Midade\Items\Models\Item' and `action` = 'view'
2.44msemaq_maqraaMetadata | |
---|---|
Bindings |
|
select count(*) as aggregate from `counter` where `counter`.`entity_id` = '85' and `counter`.`entity_id` is not null and `entity_name` = 'Midade\Items\Models\Item' and `action` = 'share'
1.82msemaq_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` = '74' and `typeables`.`typeable_type` = 'Midade\Items\Models\Item' limit 1
530μsemaq_maqraaMetadata | |
---|---|
Bindings |
|
Hints |
|
select count(*) as aggregate from `counter` where `counter`.`entity_id` = '74' and `counter`.`entity_id` is not null and `entity_name` = 'Midade\Items\Models\Item' and `action` = 'view'
1.97msemaq_maqraaMetadata | |
---|---|
Bindings |
|
select count(*) as aggregate from `counter` where `counter`.`entity_id` = '74' and `counter`.`entity_id` is not null and `entity_name` = 'Midade\Items\Models\Item' and `action` = 'share'
1.41msemaq_maqraaMetadata | |
---|---|
Bindings |
|