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` =7296
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 (7296)
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 (7296)
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 (7296)
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 (2134, 2135, 2136, 2137, 2138, 2139, 2140, 2141, 2142, 2143, 2146)
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 (2134, 2135, 2136, 2137, 2138, 2139, 2140, 2141, 2142, 2143, 2146)
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 (7296)
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 (7296)
select `categories`.`id` from `categories` innerjoin `company_categories_keywords` on `categories`.`id` = `company_categories_keywords`.`category_id` where `company_categories_keywords`.`company_id` =7296
selectcount(*) as aggregate from `companies` leftjoin `company_stars` as `st` on `st`.`company_id` = `companies`.`id` where `companies`.`id` !=7296andexists (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 (573, 573, 573, 573, 573, 573, 573, 573, 573, 573, 573)) 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` !=7296andexists (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 (573, 573, 573, 573, 573, 573, 573, 573, 573, 573, 573)) and `active` =1orderby `st`.`star` asc, `st`.`number` desc, `st`.`updated_at` desc limit 10offset60
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 (82562, 82896, 83355, 83740, 83873, 85143, 85775, 85785, 86652, 87170)
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 (82562, 82896, 83355, 83740, 83873, 85143, 85775, 85785, 86652, 87170)