ssid
distributor_company_id
phone
_hash
content
templateScripts
company
products
count
is_products_for_points
categories
polygon
obLevel
__env
app
errors
cities
title
meta_description
keywords
city
other_projects
geo_city
footers
user
basket_info
for_points
in_basket
__currentLoopData
services
loop
links
links_column
select * from "client_locations" where "session_id" = 'QiElD2uG9HCOa9ZtpNoFPwrXQzYNFXPV9nZltNiS' and "current" = '1' and "client_locations"."deleted_at" is null limit 1
SELECT *
LIMIT
ORDER BY
select "domain", "name" from "cities" where "domain" <> 'test' and "user_id" is not null order by "name" asc
select * from "regions" where "regions"."id" = '87' limit 1
select * from "pages" where "type" = '2' and "status" = '1' and "pages"."deleted_at" is null
select * from "companies" where "slug" ILIKE 'Pirogovaya.by' and "visibility" = '1' and "companies"."deleted_at" is null limit 1
select "criteries".*, "criteries_relations"."type_id" as "pivot_type_id", "criteries_relations"."criteria_id" as "pivot_criteria_id" from "criteries" inner join "criteries_relations" on "criteries"."id" = "criteries_relations"."criteria_id" where "criteries_relations"."type" = 3 and "criteries"."type" = '3' and "criteries_relations"."type_id" in ('2643')
select "categories".*, "categories_companies"."company_id" as "pivot_company_id", "categories_companies"."category_id" as "pivot_category_id" from "categories" inner join "categories_companies" on "categories"."id" = "categories_companies"."category_id" where "categories_companies"."company_id" in ('2643')
select * from "cities" where "cities"."id" in ('51')
select "polygons".* from "polygons" inner join "locations" on "polygons"."location_id" = "locations"."id" and "locations"."deleted_at" is null and "locations"."company_id" = '2643' where "polygons"."status" = '1' and "polygons"."deleted_at" is null order by add_delivery asc, add asc limit 1
select "categories".* from "categories" inner join "categories_companies" on "categories_companies"."category_id" = "categories"."id" and "categories_companies"."company_id" = '2643' and "categories_companies"."deleted_at" is null and "categories_companies"."parent_id" = '0' left join categories_companies as parent on "parent"."parent_id" = "categories"."id" and "categories_companies"."company_id" = '2643' and "categories_companies"."deleted_at" is null inner join "products" on ("products"."category_id" = categories.id or "products"."category_id" = parent.category_id) and "products"."status" = '1' and "products"."company_id" = '2643' and "products"."deleted_at" is null group by "categories"."id", "categories_companies"."position" order by "categories"."name" asc, "categories_companies"."position" asc
SELECT
WHERE
select count(*) as aggregate from "products" inner join "product_photos" on "product_photos"."product_id" = "products"."id" and "product_photos"."main" = '1' inner join "categories_companies" on "categories_companies"."category_id" = "products"."category_id" and "categories_companies"."company_id" = '2643' where "products"."company_id" = '2643' and "products"."status" = '1' and "products"."deleted_at" is null group by "products"."id", "categories_companies"."position"
select count(*) as aggregate from "products" inner join "product_photos" on "product_photos"."product_id" = "products"."id" and "product_photos"."main" = '1' where "company_id" = '2643' and "status" = '1' and "products"."deleted_at" is null group by "products"."id"
select "id" from "products" where "score" > '0' and "status" = '1' and "company_id" = '2643' and "products"."deleted_at" is null limit 1
select * from "users" where "users"."id" = '1362' and "users"."deleted_at" is null limit 1
select * from "franch_profile" where "franch_profile"."user_id" = '1362' and "franch_profile"."user_id" is not null limit 1