SELECT "account_move".id FROM "account_move" WHERE ("account_move"."type" = 'out_invoice') AND TRUE ORDER BY "account_move"."date" DESC, "account_move"."name" DESC, "account_move"."id" DESC limit 80;

Date: 2026-04-07 10:44:51
Duration: 8s260ms

SELECT "account_move".id FROM "account_move" WHERE ("account_move"."type" = 'out_invoice') AND TRUE ORDER BY "account_move"."date" DESC, "account_move"."name" DESC, "account_move"."id" DESC limit 80;

Date: 2026-04-07 10:44:51
Duration: 0ms

x Hide

SELECT "ir_model_data".id FROM "ir_model_data" ORDER BY "ir_model_data"."module", "ir_model_data"."model", "ir_model_data"."name" limit 80;

Date: 2026-04-07 11:10:05
Duration: 1s52ms

SELECT "ir_model_data".id FROM "ir_model_data" ORDER BY "ir_model_data"."module", "ir_model_data"."model", "ir_model_data"."name" limit 80;

Date: 2026-04-07 11:10:05
Duration: 0ms

x Hide

SELECT "planning_planning".id FROM "planning_planning" LEFT JOIN planning_planning_company_rel ON (planning_planning.id = planning_planning_company_rel.planning_id) LEFT JOIN planning_planning_warehouse_rel ON (planning_planning.id = planning_planning_warehouse_rel.planning_id) WHERE ("planning_planning"."workflow_type" = 'presale') AND ((planning_planning.company_id IN (1, 3) OR planning_planning_company_rel.company_id IN (0)) AND (planning_planning_warehouse_rel.warehouse_id in (1, 93, 10, 6, 107, 14, 157, 2, 131, 121, 132, 46, 48, 44, 34, 55, 160, 168, 49, 28, 153, 57, 135, 150, 54, 75, 118, 22, 68, 81, 52, 83, 126, 103, 151, 80, 56, 98, 35, 87, 43, 29, 53, 37, 63, 147, 128, 50, 117, 19, 33, 77, 60, 70, 149, 92, 134, 152, 158, 166, 113, 84, 32, 163, 127, 159, 110, 139, 119, 164, 85, 26, 104, 99, 136, 154, 61, 38, 36, 18, 165, 27, 40, 162, 39, 94, 62, 16, 42, 76, 141, 73, 58, 90, 17, 145, 112, 100, 155, 24, 74, 114, 79, 130, 133, 142, 25, 15, 45, 148, 95, 21, 51, 120, 137, 47, 96, 23, 116, 111, 66, 105, 109, 106, 91, 129, 115, 101, 138, 41, 156, 71, 97, 146, 20, 69, 64))) ORDER BY "planning_planning"."state" DESC, "planning_planning"."date_end" DESC limit 80;

Date: 2026-04-07 13:27:11
Duration: 1s541ms

SELECT "planning_planning".id FROM "planning_planning" LEFT JOIN planning_planning_company_rel ON (planning_planning.id = planning_planning_company_rel.planning_id) LEFT JOIN planning_planning_warehouse_rel ON (planning_planning.id = planning_planning_warehouse_rel.planning_id) WHERE ("planning_planning"."workflow_type" = 'presale') AND ((planning_planning.company_id IN (1, 3) OR planning_planning_company_rel.company_id IN (0)) AND (planning_planning_warehouse_rel.warehouse_id in (1, 93, 10, 6, 107, 14, 157, 2, 131, 121, 132, 46, 48, 44, 34, 55, 160, 168, 49, 28, 153, 57, 135, 150, 54, 75, 118, 22, 68, 81, 52, 83, 126, 103, 151, 80, 56, 98, 35, 87, 43, 29, 53, 37, 63, 147, 128, 50, 117, 19, 33, 77, 60, 70, 149, 92, 134, 152, 158, 166, 113, 84, 32, 163, 127, 159, 110, 139, 119, 164, 85, 26, 104, 99, 136, 154, 61, 38, 36, 18, 165, 27, 40, 162, 39, 94, 62, 16, 42, 76, 141, 73, 58, 90, 17, 145, 112, 100, 155, 24, 74, 114, 79, 130, 133, 142, 25, 15, 45, 148, 95, 21, 51, 120, 137, 47, 96, 23, 116, 111, 66, 105, 109, 106, 91, 129, 115, 101, 138, 41, 156, 71, 97, 146, 20, 69, 64))) ORDER BY "planning_planning"."state" DESC, "planning_planning"."date_end" DESC limit 80;

Date: 2026-04-07 13:27:16
Duration: 1s418ms

SELECT "planning_planning".id FROM "planning_planning" LEFT JOIN planning_planning_company_rel ON (planning_planning.id = planning_planning_company_rel.planning_id) LEFT JOIN planning_planning_warehouse_rel ON (planning_planning.id = planning_planning_warehouse_rel.planning_id) WHERE ("planning_planning"."workflow_type" = 'presale') AND ((planning_planning.company_id IN (1, 3, 4) OR planning_planning_company_rel.company_id IN (0)) AND (planning_planning_warehouse_rel.warehouse_id in (1, 93, 10, 6, 107, 14, 157, 46, 44, 75, 80, 87, 29, 53, 128, 117, 19, 33, 77, 70, 134, 84, 32, 39, 17, 133, 142, 45, 95, 51, 137, 105, 106, 101, 20))) ORDER BY "planning_planning"."state" DESC, "planning_planning"."date_end" DESC limit 80;

Date: 2026-04-07 12:16:30
Duration: 1s273ms

x Hide

SELECT min("sale_report".id) AS id, count("sale_report".id) AS "__count", sum("sale_report"."price_subtotal") AS "price_subtotal", date_trunc('month', "sale_report"."date"::timestamp) as "date:month", date_trunc('day', "sale_report"."date"::timestamp) as "date:day" FROM "sale_report" WHERE (("sale_report"."date" >= '2026-04-01 00:00:00') AND ("sale_report"."date" < '2026-05-01 00:00:00')) AND TRUE GROUP BY date_trunc('month', "sale_report"."date"::timestamp), date_trunc('day', "sale_report"."date"::timestamp) ORDER BY "date:month", "date:day";

Date: 2026-04-07 13:03:11
Duration: 0ms

x Hide

SELECT min("sale_report".id) AS id, count("sale_report".id) AS "__count", sum("sale_report"."price_subtotal") AS "price_subtotal" FROM "sale_report" WHERE (("sale_report"."date" >= '2026-04-01 00:00:00') AND ("sale_report"."date" < '2026-05-01 00:00:00')) AND TRUE;

Date: 2026-04-07 13:03:09
Duration: 0ms

x Hide

SELECT min("sale_report".id) AS id, count("sale_report".id) AS "__count", sum("sale_report"."price_subtotal") AS "price_subtotal", "sale_report"."planning_template_id" as "planning_template_id" FROM "sale_report" LEFT JOIN "planning_template" as "sale_report__planning_template_id" ON ("sale_report"."planning_template_id" = "sale_report__planning_template_id"."id") WHERE (((((("sale_report"."planning_template_id" = 98) OR ("sale_report"."planning_template_id" = 115)) OR ("sale_report"."planning_template_id" = 113)) OR ("sale_report"."planning_template_id" = 605)) OR ("sale_report"."planning_template_id" = 607)) OR ("sale_report"."planning_template_id" = 608)) AND TRUE AND ((sale_report.company_id IN (1)) AND (sale_report.brand_id IS NULL OR sale_report.brand_id in (1)) AND (sale_report.warehouse_id in (10))) GROUP BY "sale_report"."planning_template_id", "sale_report__planning_template_id"."id" ORDER BY "sale_report__planning_template_id"."id";

Date: 2026-04-07 12:11:35
Duration: 0ms

x Hide

SELECT min("stock_valuation_layer".id) AS id, count("stock_valuation_layer".id) AS "product_id_count", sum("stock_valuation_layer"."value") AS "value", sum("stock_valuation_layer"."quantity") AS "quantity", "stock_valuation_layer"."product_id" as "product_id" FROM "product_product" as "stock_valuation_layer__product_id" LEFT JOIN "product_template" as "stock_valuation_layer__product_id__product_tmpl_id" ON ("stock_valuation_layer__product_id"."product_tmpl_id" = "stock_valuation_layer__product_id__product_tmpl_id"."id"), "stock_valuation_layer" WHERE ("stock_valuation_layer"."product_id" = "stock_valuation_layer__product_id"."id") AND ((("stock_valuation_layer__product_id"."active" = true) AND ("stock_valuation_layer"."product_id" in (900, 141, 137, 130, 11))) AND ("stock_valuation_layer"."company_id" = 1)) GROUP BY "stock_valuation_layer"."product_id", "stock_valuation_layer__product_id"."default_code", "stock_valuation_layer__product_id__product_tmpl_id"."name", "stock_valuation_layer__product_id"."id" ORDER BY "stock_valuation_layer__product_id"."default_code", "stock_valuation_layer__product_id__product_tmpl_id"."name", "stock_valuation_layer__product_id"."id";

Date: 2026-04-07 12:10:34
Duration: 0ms

x Hide

SELECT min("sale_report".id) AS id, count("sale_report".id) AS "__count", sum("sale_report"."price_subtotal") AS "price_subtotal" FROM "sale_report" WHERE (((((("sale_report"."planning_template_id" = 98) OR ("sale_report"."planning_template_id" = 115)) OR ("sale_report"."planning_template_id" = 113)) OR ("sale_report"."planning_template_id" = 605)) OR ("sale_report"."planning_template_id" = 607)) OR ("sale_report"."planning_template_id" = 608)) AND TRUE AND ((sale_report.company_id IN (1)) AND (sale_report.brand_id IS NULL OR sale_report.brand_id in (1)) AND (sale_report.warehouse_id in (10)));

Date: 2026-04-07 12:11:19
Duration: 0ms
Database: odoo
User: odoo

x Hide

SELECT min("stock_valuation_layer".id) AS id, count("stock_valuation_layer".id) AS "product_id_count", sum("stock_valuation_layer"."value") AS "value", sum("stock_valuation_layer"."quantity") AS "quantity", "stock_valuation_layer"."product_id" as "product_id" FROM "product_product" as "stock_valuation_layer__product_id" LEFT JOIN "product_template" as "stock_valuation_layer__product_id__product_tmpl_id" ON ("stock_valuation_layer__product_id"."product_tmpl_id" = "stock_valuation_layer__product_id__product_tmpl_id"."id") LEFT JOIN "ir_translation" as "stock_valuation_layer__product_id__product_tmpl_id__name" ON ("stock_valuation_layer__product_id__product_tmpl_id"."id" = "stock_valuation_layer__product_id__product_tmpl_id__name"."res_id" AND "stock_valuation_layer__product_id__product_tmpl_id__name"."type" = 'model' AND "stock_valuation_layer__product_id__product_tmpl_id__name"."name" = 'product.template,name' AND "stock_valuation_layer__product_id__product_tmpl_id__name"."lang" = 'fr_FR' AND "stock_valuation_layer__product_id__product_tmpl_id__name"."value" != ''), "stock_valuation_layer" WHERE ("stock_valuation_layer"."product_id" = "stock_valuation_layer__product_id"."id") AND ((("stock_valuation_layer__product_id"."active" = true) AND ("stock_valuation_layer"."product_id" in (784, 790, 332, 587, 629, 120, 12))) AND ("stock_valuation_layer"."company_id" = 3)) GROUP BY "stock_valuation_layer"."product_id", "stock_valuation_layer__product_id"."default_code", COALESCE("stock_valuation_layer__product_id__product_tmpl_id__name"."value", "stock_valuation_layer__product_id__product_tmpl_id"."name"), "stock_valuation_layer__product_id"."id" ORDER BY "stock_valuation_layer__product_id"."default_code", COALESCE("stock_valuation_layer__product_id__product_tmpl_id__name"."value", "stock_valuation_layer__product_id__product_tmpl_id"."name"), "stock_valuation_layer__product_id"."id";

Date: 2026-04-07 12:12:27
Duration: 0ms

x Hide

SELECT min("sale_report".id) AS id, count("sale_report".id) AS "__count", sum("sale_report"."price_subtotal") AS "price_subtotal", date_trunc('month', "sale_report"."date"::timestamp) as "date:month" FROM "sale_report" WHERE (("sale_report"."date" >= '2026-04-01 00:00:00') AND ("sale_report"."date" < '2026-05-01 00:00:00')) AND TRUE GROUP BY date_trunc('month', "sale_report"."date"::timestamp) ORDER BY "date:month";

Date: 2026-04-07 13:03:11
Duration: 0ms

x Hide

SELECT rp.id AS ID_POS, rp.ref AS CODE_POS, rp.name AS NOM_POS, rp.rc AS rc, rp.art AS art, rp.nis as nis, rp.vat as nif, sw.name AS DEPOT, typ.value AS type_pv, rp.active AS STATUS_POS, rpc.value AS CLUSTER_POS, ppi.name AS LISTE_PRIX, prcr.name AS REGION, prcs.name AS ZONE, rcst.name AS WILAYA, rp.city AS COMMUNE, rp.street AS ADRESSE, rp.phone AS TELEPHONE, CONCAT(rp.partner_latitude, ',', rp.partner_longitude) AS COORDONNEES_GPS, CONCAT('[', dr.name, ']') AS ROUTE, 'Tous les jours sauf vendredi' AS JOUR_VISITE, drp.sequence AS SEQUENCE_VISITE, CASE WHEN EXISTS ( SELECT 1 FROM ir_attachment ia WHERE ia.res_model = 'res.partner' AND ia.res_field = 'image_1920' AND ia.res_id = rp.id) THEN 'OUI' ELSE 'NON' END AS DISPONIBILITE_PHOTO, rp.state AS ETAT_CENSUS, MAX(mm.write_date) AS Date_derniere_modification, ( SELECT sub_mm.body FROM mail_message sub_mm WHERE sub_mm.model = 'res.partner' AND sub_mm.res_id = rp.id ORDER BY sub_mm.write_date DESC LIMIT 1) AS Derniere_Modification, COUNT(mm.id) AS nombre_modifications, ( SELECT ai.name as number FROM account_move ai WHERE ai.partner_id = rp.id AND ai.invoice_payment_state IN ('not_paid', 'paid') ORDER BY ai.write_date DESC LIMIT 1) AS derniere_vente FROM res_partner rp LEFT JOIN planning_template_event drp ON rp.id = drp.partner_id LEFT JOIN planning_template dr ON dr.id = drp.planning_template_id LEFT JOIN stock_warehouse sw ON rp.warehouse_id = sw.id LEFT JOIN model_custom_attribute_value typ ON rp.partner_custom_attribute_2 = typ.id LEFT JOIN model_custom_attribute_value rpc ON rp.partner_custom_attribute_1 = rpc.id LEFT JOIN res_country_state rcst ON rp.state_id = rcst.id LEFT JOIN res_country_region prcr ON rp.region_id = prcr.id LEFT JOIN res_country_sector prcs ON rp.sector_id = prcs.id LEFT JOIN res_partner_pricelist pl ON rp.id = pl.partner_id LEFT JOIN product_pricelist ppi ON pl.pricelist_id = ppi.id LEFT JOIN mail_message mm ON mm.model = 'res.partner' AND mm.res_id = rp.id WHERE --rp.customer_rank = 1* sw.id not in (170, 172, 180, 182) GROUP BY rp.id, rp.ref, rp.name, sw.name, typ.value, rp.active, rpc.value, ppi.name, prcr.name, prcs.name, rcst.name, rp.city, rp.street, rp.phone, rp.partner_latitude, rp.partner_longitude, dr.name, drp.sequence, DISPONIBILITE_PHOTO, rp.state, rp.write_date;

Date: 2026-04-07 13:38:29
Duration: 0ms
Database: odoo
User: presalio_user

x Hide

SELECT min("account_report".id) AS id, count("account_report".id) AS "__count", sum("account_report"."price_subtotal") AS "price_subtotal" FROM "account_report" WHERE ((((("account_report"."state" not in ('draft', 'cancel')) OR "account_report"."state" IS NULL) AND (("account_report"."type" = 'out_invoice') OR ("account_report"."type" = 'out_refund'))) AND ("account_report"."invoice_date" >= '2025-01-01')) AND ("account_report"."partner_custom_attribute_1" in (73, 83, 91, 93))) AND ((account_report.company_id IN (1, 3)) AND (account_report.warehouse_id in (1, 93, 10, 6, 107, 14, 157, 2, 131, 121, 132, 46, 48, 44, 34, 55, 160, 49, 28, 153, 57, 135, 150, 54, 75, 118, 22, 68, 81, 52, 83, 126, 103, 151, 80, 56, 98, 35, 87, 43, 29, 53, 37, 63, 147, 128, 50, 117, 19, 33, 77, 60, 70, 149, 92, 134, 152, 158, 166, 113, 84, 32, 163, 127, 159, 110, 139, 119, 164, 85, 26, 104, 99, 136, 154, 61, 38, 36, 18, 165, 27, 40, 162, 39, 94, 62, 16, 42, 76, 141, 73, 58, 90, 17, 145, 112, 100, 155, 24, 74, 114, 79, 130, 133, 142, 25, 15, 45, 148, 95, 21, 51, 120, 137, 47, 96, 23, 116, 111, 66, 105, 109, 106, 91, 129, 115, 101, 138, 41, 156, 71, 97, 146, 20, 69, 64, 178)));

Date: 2026-04-07 13:10:34
Duration: 0ms

x Hide

SELECT "planning_planning".id FROM "planning_planning" LEFT JOIN planning_planning_company_rel ON (planning_planning.id = planning_planning_company_rel.planning_id) LEFT JOIN planning_planning_warehouse_rel ON (planning_planning.id = planning_planning_warehouse_rel.planning_id) WHERE 1 = 1 AND ((planning_planning.company_id IN (1) OR planning_planning_company_rel.company_id IN (0)) AND (planning_planning.brand_id IS NULL OR planning_planning.brand_id in (1)) AND (planning_planning_warehouse_rel.warehouse_id in (1, 93, 10, 6, 107, 14, 157, 178))) ORDER BY "planning_planning"."state" DESC, "planning_planning"."date_end" DESC limit 8;

Date: 2026-04-07 12:40:57
Duration: 1s267ms

SELECT "planning_planning".id FROM "planning_planning" LEFT JOIN planning_planning_company_rel ON (planning_planning.id = planning_planning_company_rel.planning_id) LEFT JOIN planning_planning_warehouse_rel ON (planning_planning.id = planning_planning_warehouse_rel.planning_id) WHERE 1 = 1 AND ((planning_planning.company_id IN (1) OR planning_planning_company_rel.company_id IN (0)) AND (planning_planning.brand_id IS NULL OR planning_planning.brand_id in (1)) AND (planning_planning_warehouse_rel.warehouse_id in (1, 93, 10, 6, 107, 14, 157, 178))) ORDER BY "planning_planning"."state" DESC, "planning_planning"."date_end" DESC limit 8;

Date: 2026-04-07 12:30:44
Duration: 1s149ms

SELECT "planning_planning".id FROM "planning_planning" LEFT JOIN planning_planning_company_rel ON (planning_planning.id = planning_planning_company_rel.planning_id) LEFT JOIN planning_planning_warehouse_rel ON (planning_planning.id = planning_planning_warehouse_rel.planning_id) WHERE 1 = 1 AND ((planning_planning.company_id IN (1) OR planning_planning_company_rel.company_id IN (0)) AND (planning_planning.brand_id IS NULL OR planning_planning.brand_id in (1)) AND (planning_planning_warehouse_rel.warehouse_id in (1, 93, 10, 6, 107, 14, 157, 178))) ORDER BY "planning_planning"."state" DESC, "planning_planning"."date_end" DESC limit 8;

Date: 2026-04-07 12:40:59
Duration: 1s98ms

x Hide

SELECT min("stock_move_line".id) AS id, count("stock_move_line".id) AS "product_id_count", sum("stock_move_line"."qty_done") AS "qty_done", "stock_move_line"."product_id" as "product_id" FROM "stock_move_line" LEFT JOIN "product_product" as "stock_move_line__product_id" ON ("stock_move_line"."product_id" = "stock_move_line__product_id"."id") LEFT JOIN "product_template" as "stock_move_line__product_id__product_tmpl_id" ON ("stock_move_line__product_id"."product_tmpl_id" = "stock_move_line__product_id__product_tmpl_id"."id") LEFT JOIN "ir_translation" as "stock_move_line__product_id__product_tmpl_id__name" ON ("stock_move_line__product_id__product_tmpl_id"."id" = "stock_move_line__product_id__product_tmpl_id__name"."res_id" AND "stock_move_line__product_id__product_tmpl_id__name"."type" = 'model' AND "stock_move_line__product_id__product_tmpl_id__name"."name" = 'product.template,name' AND "stock_move_line__product_id__product_tmpl_id__name"."lang" = 'fr_FR' AND "stock_move_line__product_id__product_tmpl_id__name"."value" != '') WHERE ("stock_move_line"."state" = 'done') AND ((stock_move_line.company_id IN (3)) AND (stock_move_line.warehouse_id IS NULL OR stock_move_line.warehouse_id IN (16, 133)) AND (stock_move_line.brand_id IS NULL OR stock_move_line.brand_id IN (1))) GROUP BY "stock_move_line"."product_id", "stock_move_line__product_id"."default_code", COALESCE("stock_move_line__product_id__product_tmpl_id__name"."value", "stock_move_line__product_id__product_tmpl_id"."name"), "stock_move_line__product_id"."id" ORDER BY "stock_move_line__product_id"."default_code", COALESCE("stock_move_line__product_id__product_tmpl_id__name"."value", "stock_move_line__product_id__product_tmpl_id"."name"), "stock_move_line__product_id"."id" LIMIT 80;

Date: 2026-04-07 11:54:42
Duration: 0ms

x Hide

SELECT min("account_payment".id) AS id, count("account_payment".id) AS "journal_id_count", sum("account_payment"."amount") AS "amount", "account_payment"."journal_id" as "journal_id" FROM "account_payment" LEFT JOIN "account_journal" as "account_payment__journal_id" ON ("account_payment"."journal_id" = "account_payment__journal_id"."id") WHERE ("account_payment"."partner_type" = 'customer') GROUP BY "account_payment"."journal_id", "account_payment__journal_id"."sequence", "account_payment__journal_id"."type", "account_payment__journal_id"."code" ORDER BY "account_payment__journal_id"."sequence", "account_payment__journal_id"."type", "account_payment__journal_id"."code";

Date: 2026-04-07 10:45:42
Duration: 0ms

x Hide

SELECT min("stock_move_line".id) AS id, count("stock_move_line".id) AS "product_id_count", "stock_move_line"."product_id" as "product_id" FROM "stock_move_line" LEFT JOIN "product_product" as "stock_move_line__product_id" ON ("stock_move_line"."product_id" = "stock_move_line__product_id"."id") LEFT JOIN "product_template" as "stock_move_line__product_id__product_tmpl_id" ON ("stock_move_line__product_id"."product_tmpl_id" = "stock_move_line__product_id__product_tmpl_id"."id") LEFT JOIN "ir_translation" as "stock_move_line__product_id__product_tmpl_id__name" ON ("stock_move_line__product_id__product_tmpl_id"."id" = "stock_move_line__product_id__product_tmpl_id__name"."res_id" AND "stock_move_line__product_id__product_tmpl_id__name"."type" = 'model' AND "stock_move_line__product_id__product_tmpl_id__name"."name" = 'product.template,name' AND "stock_move_line__product_id__product_tmpl_id__name"."lang" = 'fr_FR' AND "stock_move_line__product_id__product_tmpl_id__name"."value" != '') WHERE ("stock_move_line"."state" = 'done') AND ((stock_move_line.company_id IN (3)) AND (stock_move_line.warehouse_id IS NULL OR stock_move_line.warehouse_id IN (16, 133)) AND (stock_move_line.brand_id IS NULL OR stock_move_line.brand_id IN (1))) GROUP BY "stock_move_line"."product_id", "stock_move_line__product_id"."default_code", COALESCE("stock_move_line__product_id__product_tmpl_id__name"."value", "stock_move_line__product_id__product_tmpl_id"."name"), "stock_move_line__product_id"."id" ORDER BY "stock_move_line__product_id"."default_code", COALESCE("stock_move_line__product_id__product_tmpl_id__name"."value", "stock_move_line__product_id__product_tmpl_id"."name"), "stock_move_line__product_id"."id" LIMIT 100000 OFFSET 80;

Date: 2026-04-07 11:54:46
Duration: 0ms

x Hide

SELECT "stock_move".id FROM "stock_move" WHERE ("stock_move"."product_id" = 12) AND ((stock_move.company_id IN (1)) AND (stock_move.warehouse_id IS NULL OR stock_move.warehouse_id IN (1)) AND (stock_move.brand_id IS NULL OR stock_move.brand_id IN (1))) ORDER BY "stock_move"."id";

Date: 2026-04-07 13:57:53
Duration: 0ms

x Hide

SELECT min("account_report".id) AS id, count("account_report".id) AS "__count", sum("account_report"."price_subtotal") AS "price_subtotal" FROM "account_report" WHERE (((("account_report"."state" not in ('draft', 'cancel')) OR "account_report"."state" IS NULL) AND (("account_report"."type" = 'out_invoice') OR ("account_report"."type" = 'out_refund'))) AND (("account_report"."invoice_date" >= '2026-03-01') AND ("account_report"."invoice_date" < '2026-04-01'))) AND ((account_report.company_id IN (1, 3)) AND (account_report.brand_id IS NULL OR account_report.brand_id in (1)) AND (account_report.warehouse_id in (10, 14, 48, 44, 135, 80, 29, 53, 163, 27, 45, 106, 138, 20)));

Date: 2026-04-07 10:29:20
Duration: 0ms

x Hide

SELECT min("account_report".id) AS id, count("account_report".id) AS "__count", sum("account_report"."price_subtotal") AS "price_subtotal", date_trunc('month', "account_report"."invoice_date"::timestamp) as "invoice_date" FROM "account_report" WHERE (((("account_report"."state" not in ('draft', 'cancel')) OR "account_report"."state" IS NULL) AND (("account_report"."type" = 'out_invoice') OR ("account_report"."type" = 'out_refund'))) AND (("account_report"."invoice_date" >= '2026-03-01') AND ("account_report"."invoice_date" < '2026-04-01'))) AND ((account_report.company_id IN (1, 3)) AND (account_report.brand_id IS NULL OR account_report.brand_id in (1)) AND (account_report.warehouse_id in (10, 14, 48, 44, 135, 80, 29, 53, 163, 27, 45, 106, 138, 20))) GROUP BY date_trunc('month', "account_report"."invoice_date"::timestamp) ORDER BY "invoice_date";

Date: 2026-04-07 10:29:23
Duration: 0ms

x Hide

SELECT min("account_report".id) AS id, count("account_report".id) AS "__count", sum("account_report"."price_subtotal") AS "price_subtotal", "account_report"."warehouse_id" as "warehouse_id" FROM "account_report" LEFT JOIN "stock_warehouse" as "account_report__warehouse_id" ON ("account_report"."warehouse_id" = "account_report__warehouse_id"."id") WHERE ((("account_report"."invoice_date" >= '2026-03-01') AND ("account_report"."invoice_date" < '2026-04-01')) AND (((("account_report"."state" not in ('draft', 'cancel')) OR "account_report"."state" IS NULL) AND (("account_report"."type" = 'out_invoice') OR ("account_report"."type" = 'out_refund'))) AND (("account_report"."invoice_date" >= '2026-03-01') AND ("account_report"."invoice_date" < '2026-04-01')))) AND ((account_report.company_id IN (1, 3)) AND (account_report.brand_id IS NULL OR account_report.brand_id in (1)) AND (account_report.warehouse_id in (10, 14, 48, 44, 135, 80, 29, 53, 163, 27, 45, 106, 138, 20))) GROUP BY "account_report"."warehouse_id", "account_report__warehouse_id"."sequence", "account_report__warehouse_id"."name" ORDER BY "account_report__warehouse_id"."sequence" ASC, "account_report__warehouse_id"."name" ASC;

Date: 2026-04-07 10:29:28
Duration: 0ms

x Hide

SELECT min("account_payment".id) AS id, count("account_payment".id) AS "journal_id_count", sum("account_payment"."amount") AS "amount", "account_payment"."journal_id" as "journal_id" FROM "account_payment" LEFT JOIN "account_journal" as "account_payment__journal_id" ON ("account_payment"."journal_id" = "account_payment__journal_id"."id") WHERE (("account_payment"."partner_type" = 'customer') AND ("account_payment"."warehouse_id" in (6))) GROUP BY "account_payment"."journal_id", "account_payment__journal_id"."sequence", "account_payment__journal_id"."type", "account_payment__journal_id"."code" ORDER BY "account_payment__journal_id"."sequence", "account_payment__journal_id"."type", "account_payment__journal_id"."code";

Date: 2026-04-07 10:46:27
Duration: 0ms

x Hide