select `plans`.*, `company_plan`.`company_id` as `pivot_company_id`, `company_plan`.`plan_id` as `pivot_plan_id`, `company_plan`.`expire_at` as `pivot_expire_at` from `plans` innerjoin `company_plan` on `plans`.`id` = `company_plan`.`plan_id` where `company_plan`.`company_id` =61786
select `categories`.*, `company_categories_keywords`.`company_id` as `pivot_company_id`, `company_categories_keywords`.`category_id` as `pivot_category_id`, `company_categories_keywords`.`keyword_id` as `pivot_keyword_id`, `company_categories_keywords`.`main_category_id` as `pivot_main_category_id` from `categories` innerjoin `company_categories_keywords` on `categories`.`id` = `company_categories_keywords`.`category_id` where `company_categories_keywords`.`company_id` in (61786)
selectdistinct `keywords`.*, `company_categories_keywords`.`company_id` as `pivot_company_id`, `company_categories_keywords`.`keyword_id` as `pivot_keyword_id`, `company_categories_keywords`.`main_category_id` as `pivot_main_category_id`, `company_categories_keywords`.`category_id` as `pivot_category_id` from `keywords` innerjoin `company_categories_keywords` on `keywords`.`id` = `company_categories_keywords`.`keyword_id` where `company_categories_keywords`.`company_id` in (61786)
selectdistinct `categories`.*, `company_categories_keywords`.`company_id` as `pivot_company_id`, `company_categories_keywords`.`category_id` as `pivot_category_id` from `categories` innerjoin `company_categories_keywords` on `categories`.`id` = `company_categories_keywords`.`category_id` where `company_categories_keywords`.`company_id` in (61786)
selectdistinct `categories`.*, `company_categories_keywords`.`keyword_id` as `pivot_keyword_id`, `company_categories_keywords`.`category_id` as `pivot_category_id`, `company_categories_keywords`.`main_category_id` as `pivot_main_category_id` from `categories` innerjoin `company_categories_keywords` on `categories`.`id` = `company_categories_keywords`.`category_id` where `company_categories_keywords`.`keyword_id` in (3549, 4400, 4401, 4402, 4403, 4404, 16551, 16552, 16555, 16556)
selectdistinct `categories`.*, `company_categories_keywords`.`keyword_id` as `pivot_keyword_id`, `company_categories_keywords`.`main_category_id` as `pivot_main_category_id` from `categories` innerjoin `company_categories_keywords` on `categories`.`id` = `company_categories_keywords`.`main_category_id` where `company_categories_keywords`.`keyword_id` in (3549, 4400, 4401, 4402, 4403, 4404, 16551, 16552, 16555, 16556)
selectdistinct `keywords`.*, `company_categories_keywords`.`company_id` as `pivot_company_id`, `company_categories_keywords`.`keyword_id` as `pivot_keyword_id`, `company_categories_keywords`.`main_category_id` as `pivot_main_category_id`, `company_categories_keywords`.`category_id` as `pivot_category_id` from `keywords` innerjoin `company_categories_keywords` on `keywords`.`id` = `company_categories_keywords`.`keyword_id` where `company_categories_keywords`.`company_id` in (61786)
select `categories`.*, `company_categories_keywords`.`company_id` as `pivot_company_id`, `company_categories_keywords`.`category_id` as `pivot_category_id`, `company_categories_keywords`.`keyword_id` as `pivot_keyword_id`, `company_categories_keywords`.`main_category_id` as `pivot_main_category_id` from `categories` innerjoin `company_categories_keywords` on `categories`.`id` = `company_categories_keywords`.`category_id` where `company_categories_keywords`.`company_id` in (61786)
select `categories`.`id` from `categories` innerjoin `company_categories_keywords` on `categories`.`id` = `company_categories_keywords`.`category_id` where `company_categories_keywords`.`company_id` =61786
selectcount(*) as aggregate from `companies` leftjoin `company_stars` as `st` on `st`.`company_id` = `companies`.`id` where `companies`.`id` !=61786andexists (select*from `categories` innerjoin `company_categories_keywords` on `categories`.`id` = `company_categories_keywords`.`category_id` where `companies`.`id` = `company_categories_keywords`.`company_id` and `id` in (84, 84, 84, 84, 84, 84, 86, 86, 85, 85)) and `active` =1
select `st`.`star` as `star`, `st`.`number` as `number`, `companies`.*, (selectcount(*) from `media` where `companies`.`id` = `media`.`model_id` and `media`.`model_type` ='App\Models\Company') as `media_count` from `companies` leftjoin `company_stars` as `st` on `st`.`company_id` = `companies`.`id` where `companies`.`id` !=61786andexists (select*from `categories` innerjoin `company_categories_keywords` on `categories`.`id` = `company_categories_keywords`.`category_id` where `companies`.`id` = `company_categories_keywords`.`company_id` and `id` in (84, 84, 84, 84, 84, 84, 86, 86, 85, 85)) and `active` =1orderby `st`.`star` asc, `st`.`number` desc, `st`.`updated_at` desc limit 10offset1730
select `categories`.*, `company_categories_keywords`.`company_id` as `pivot_company_id`, `company_categories_keywords`.`category_id` as `pivot_category_id`, `company_categories_keywords`.`keyword_id` as `pivot_keyword_id`, `company_categories_keywords`.`main_category_id` as `pivot_main_category_id` from `categories` innerjoin `company_categories_keywords` on `categories`.`id` = `company_categories_keywords`.`category_id` where `company_categories_keywords`.`company_id` in (850, 920, 978, 1027, 1030)
selectdistinct `categories`.*, `company_categories_keywords`.`company_id` as `pivot_company_id`, `company_categories_keywords`.`category_id` as `pivot_category_id` from `categories` innerjoin `company_categories_keywords` on `categories`.`id` = `company_categories_keywords`.`category_id` where `company_categories_keywords`.`company_id` in (850, 920, 978, 1027, 1030)