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` =53939
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 (53939)
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 (53939)
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 (53939)
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 (53939)
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 (53939)
select `categories`.`id` from `categories` innerjoin `company_categories_keywords` on `categories`.`id` = `company_categories_keywords`.`category_id` where `company_categories_keywords`.`company_id` =53939
selectcount(*) as aggregate from `companies` leftjoin `company_stars` as `st` on `st`.`company_id` = `companies`.`id` where `companies`.`id` !=53939andexists (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 (550, 550, 550, 550, 550, 550, 550, 550, 555, 555, 550, 550, 555, 1100, 1100, 1100)) 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` !=53939andexists (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 (550, 550, 550, 550, 550, 550, 550, 550, 555, 555, 550, 550, 555, 1100, 1100, 1100)) and `active` =1orderby `st`.`star` asc, `st`.`number` desc, `st`.`updated_at` desc limit 10offset0
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 (135889, 142531, 160048, 228545, 231799, 231930, 232158, 232851, 234722, 241016)
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 (135889, 142531, 160048, 228545, 231799, 231930, 232158, 232851, 234722, 241016)