{"api_key":42157,"limit":20,"count":880,"total":17583,"page":1,"prev":false,"next":"/akcionnye-predlojenija-dekabrja_2189419933803218441/page-2","rows":[{"num":1,"href":"/akcionnye-predlojenija-dekabrja_2189419933803218441","active":true},{"num":2,"href":"/akcionnye-predlojenija-dekabrja_2189419933803218441/page-2","active":false},{"num":3,"href":"/akcionnye-predlojenija-dekabrja_2189419933803218441/page-3","active":false},{"dots":true},{"num":878,"href":"/akcionnye-predlojenija-dekabrja_2189419933803218441/page-878","active":false},{"num":879,"href":"/akcionnye-predlojenija-dekabrja_2189419933803218441/page-879","active":false},{"num":880,"href":"/akcionnye-predlojenija-dekabrja_2189419933803218441/page-880","active":false}],"hash":{},"opt":{"cache":1,"sql1":1,"query":"iscategory=false","tag":"catalog_aptekar","limit":20,"order":"image is not null desc,ord","fields":"*","table":"( select * from ( select product_id, product_name, enabled, parent_id, image, product_type, contact_list, iscategory, producer, alias, modification, characteristics, article, root_id, ord, tags, (select min(price) from crm_order.product_price where product_id=a.product_id ) as price1, price, (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)) from crm_order.promotion where a.product_id=any(products) and enabled and start_date <= now() and now() <= end_date)promotions from crm_order.product a where 1=1 and enabled )w )q","page":1,"timing1":1,"query_text":"iscategory=false","_table":"product_catalog_view","table_text":"( select * from ( select product_id, product_name, enabled, parent_id, image, product_type, contact_list, iscategory, producer, alias, modification, characteristics, article, root_id, ord, tags, (select min(price) from crm_order.product_price where {{#if opt.city_dep}}department_id = any(''{ {{opt.city_dep}} }'' ) and {{/if}} product_id=a.product_id ) as price1, price, (select max(amount) from crm_order.product_price where {{#if opt.city_dep}}department_id = any(''{ {{opt.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(''{ {{opt.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)) from crm_order.promotion where a.product_id=any(products) and enabled and start_date <= now() and now() <= end_date)promotions from crm_order.product a where 1=1 and enabled {{#if opt.product_id}} and ( parent_id=''{{opt.product_id}}'' or (select parent_id from crm_order.product where product_id=a.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=a.parent_id ) )=''{{opt.product_id}}'' ) {{/if}} {{#if opt.product_id_}} and product_id=''{{opt.product_id_}}''{{/if}} )w )q","_id":"NPQeVEUVRcY3yG-nIYnvY64Xahs-","limit_base":20,"table_q":"( select * from ( select product_id, product_name, enabled, parent_id, image, product_type, contact_list, iscategory, producer, alias, modification, characteristics, article, root_id, ord, tags, (select min(price) from crm_order.product_price where product_id=a.product_id ) as price1, price, (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)) from crm_order.promotion where a.product_id=any(products) and enabled and start_date <= now() and now() <= end_date)promotions from crm_order.product a where 1=1 and enabled )w )q","search_column":null},"domain":"admin.aptekar.ua","uuid":"uM4hoXtE6TL","req":{"query":{}}}