Репеленти

{"api_key":44778,"limit":21,"count":1,"total":21,"page":1,"prev":false,"next":false,"rows":[{"num":1,"href":"/ua/repellenty","active":true}],"hash":{},"opt":{"cache":1,"tag":"catalog_aptekar","sql1":1,"product_id":"15386","query":"price is not null and iscategory=false and enabled and (parent_id=''15386'' or (select parent_id from crm_order.product where product_id=q.parent_id )=''15386'' or (select parent_id from crm_order.product where product_id=(select parent_id from crm_order.product where product_id=q.parent_id ) )=''15386'')","limit":21,"order":"(user_data->>''priority'')::integer,product_name,ord","fields":"*","table":"(select a.localization,product_id, product_name, enabled, parent_id, a.tags, image, product_type, contact_list, iscategory, producer, alias, modification, characteristics, article, root_id, ord, /*coalesce((select min(price) from crm_order.product_price where product_id=a.product_id ), (select min(price) from crm_order.product_price where product_id=a.product_id )) as price1,*/ (select a.price from crm_order.product_price where product_id=a.product_id limit 1) as price, (select a.price * (100 - (data->>''Discount_percent'')::int) / 100 from crm_order.promotion where a.product_id=any(products) and enabled and start_date <= now() and now() <= end_date and data->>''Discount_percent'' is not null order by priority limit 1) as price_discount, (select max(amount) from crm_order.product_price where product_id=a.product_id ) as amount, (select json_agg(row_to_json(z)) from (select * from crm_order.product_price where product_id=a.product_id)z ) as price_json,user_data, (select json_agg(json_build_object(''name'', tipe, ''alias'', alias, ''percent'', data->>''Discount_percent'')) from crm_order.promotion where a.product_id=any(products) and enabled and start_date <= now() and now() <= end_date)promotions, row_to_json(c) as partition from crm_order.product a left join (select ''{ }''::text[] as city_dep) b on 1=1 left join lateral (select unit,amount_max,localization from crm_order.product_partition where a.product_id=product_id limit 1)c on 1=1 where a.enabled )q","page":1,"timing1":1,"query_text":"price is not null and iscategory=false and enabled and \r\n (parent_id=''{{opt.product_id}}'' or (select parent_id from crm_order.product where product_id=q.parent_id )=''{{opt.product_id}}'' or (select parent_id from crm_order.product where product_id=(select parent_id from crm_order.product where product_id=q.parent_id ) )=''{{opt.product_id}}'')","_table":"product_view","table_text":"(select a.localization,product_id, product_name, enabled, parent_id, a.tags, image, product_type, contact_list, iscategory, producer, alias, modification, characteristics, article, root_id, ord, /*coalesce((select min(price) from crm_order.product_price where {{#if opt.city_dep}}department_id = any(b.city_dep) and {{/if}} product_id=a.product_id ), (select min(price) from crm_order.product_price where product_id=a.product_id )) as price1,*/ (select a.price from crm_order.product_price where product_id=a.product_id limit 1) as price, (select a.price * (100 - (data->>''Discount_percent'')::int) / 100 from crm_order.promotion where a.product_id=any(products) and enabled and start_date <= now() and now() <= end_date and data->>''Discount_percent'' is not null order by priority limit 1) as price_discount, (select max(amount) from crm_order.product_price where {{#if opt.city_dep}}department_id = any(b.city_dep) and {{/if}} product_id=a.product_id ) as amount, (select json_agg(row_to_json(z)) from (select * from crm_order.product_price where {{#if opt.city_dep}}department_id = any(b.city_dep) and {{/if}} product_id=a.product_id)z ) as price_json,user_data, (select json_agg(json_build_object(''name'', tipe, ''alias'', alias, ''percent'', data->>''Discount_percent'')) from crm_order.promotion where a.product_id=any(products) and enabled and start_date <= now() and now() <= end_date)promotions, row_to_json(c) as partition from crm_order.product a left join (select ''{ {{opt.city_dep}} }''::text[] as city_dep) b on 1=1 left join lateral (select unit,amount_max,localization from crm_order.product_partition where a.product_id=product_id limit 1)c on 1=1 where a.enabled )q","_id":"2uzsXUBgDVGFHHLJkOAqHKblj68-","limit_base":21,"table_q":"(select a.localization,product_id, product_name, enabled, parent_id, a.tags, image, product_type, contact_list, iscategory, producer, alias, modification, characteristics, article, root_id, ord, /*coalesce((select min(price) from crm_order.product_price where product_id=a.product_id ), (select min(price) from crm_order.product_price where product_id=a.product_id )) as price1,*/ (select a.price from crm_order.product_price where product_id=a.product_id limit 1) as price, (select a.price * (100 - (data->>''Discount_percent'')::int) / 100 from crm_order.promotion where a.product_id=any(products) and enabled and start_date <= now() and now() <= end_date and data->>''Discount_percent'' is not null order by priority limit 1) as price_discount, (select max(amount) from crm_order.product_price where product_id=a.product_id ) as amount, (select json_agg(row_to_json(z)) from (select * from crm_order.product_price where product_id=a.product_id)z ) as price_json,user_data, (select json_agg(json_build_object(''name'', tipe, ''alias'', alias, ''percent'', data->>''Discount_percent'')) from crm_order.promotion where a.product_id=any(products) and enabled and start_date <= now() and now() <= end_date)promotions, row_to_json(c) as partition from crm_order.product a left join (select ''{ }''::text[] as city_dep) b on 1=1 left join lateral (select unit,amount_max,localization from crm_order.product_partition where a.product_id=product_id limit 1)c on 1=1 where a.enabled )q","search_column":null},"domain":"admin.aptekar.ua","uuid":"u0C45KaWizE","req":{"query":{}}}