1735508346.2006 "SELECT 1"bindings: [] 1735508346.3571 "SELECT 1"bindings: [] 1735508365.7396 "SELECT 1"bindings: [] 1735508366.6509 "SELECT 1"bindings: [] 1735508367.8065 "SELECT 1"bindings: [] 1735508368.7703 "SELECT 1"bindings: [] 1735508369.0495 "SELECT 1"bindings: [] 1735508370.0149 "SELECT 1"bindings: [] 1735508371.203 "SELECT 1"bindings: [] 1735508372.1878 "SELECT 1"bindings: [] 1735514433.4452 "update \"customers\" set \"last_name\" = ?, \"country\" = ?, \"email\" = ?, \"status\" = ?, \"updated_at\" = ? where \"id\" = ?"bindings: ["PREASCA SA",null,"KASMINA0606@GMAIL.COM",null,"2024-12-29 18:20:33",3880979] 1735514448.1267 "update \"customers\" set \"last_name\" = ?, \"country\" = ?, \"email\" = ?, \"status\" = ?, \"updated_at\" = ? where \"id\" = ?"bindings: ["PREASCA SA",null,"KASMINA0606@GMAIL.COM",null,"2024-12-29 18:20:48",3880979] 1735514475.4503 "update \"customers\" set \"last_name\" = ?, \"country\" = ?, \"email\" = ?, \"status\" = ?, \"updated_at\" = ? where \"id\" = ?"bindings: ["PREASCA SA",null,"CASAALEJANDRO@HOTMAIL.COM",null,"2024-12-29 18:21:15",3880979] 1735518886.6093 "select count(*) as aggregate from \"customers\""bindings: [] 1735521300.1955 "SELECT 1"bindings: [] 1735521302.2608 "SELECT 1"bindings: [] 1735557286.66 "SELECT 1"bindings: [] 1735557288.7081 "SELECT 1"bindings: [] 1735557289.8962 "SELECT 1"bindings: [] 1735557291.9336 "SELECT 1"bindings: [] 1735571154.0447 "select count(*) as aggregate from \"invoices\" where exists (select * from \"invoice_info\" where \"invoices\".\"id\" = \"invoice_info\".\"invoice_id\" and \"status_sync\" = ? and \"status_pay\" = ?)"bindings: [1,0] 1735572902.4153 "SELECT \n s.code || ' - ' || s.\"name\" store,\n s.additional_2, \n id.id,\n c.email,\n ti.code document_type_sunat,\n sp.code sale_person,\n u.\"name\" sale_person_name,\n c.\"document\" customer,\n c.document_type,\n c.first_name || ' ' || c.last_name customer_name,\n c.address ,\n c.state ,\n c.province ,\n c.city ,\n c.email,\n c.phone,\n p.name prefix_name,\n p.code prefix_code,\n i.\"number\" ,\n i.document_date::date document_date_ ,\n i.document_date ,\n i.observations ,\n id.item,\n id.barcode ,\n id.description,\n id.brand,\n i.total_price - i.total_tax total_invoice,\n i.total_price total_invoice_including_vat,\n i.total_tax total_tax,\n id.\"Unit_Price_Including_VAT\" ,\n id.quantity ,\n id.discount ,\n id.total_price ,\n id.tax ,\n id.\"cost\",\n cast( id.total_price - id.\"cost\" as decimal(24,2)) margen,\n if_.status_sync sync,\n pays_.pay\n from invoices i\n inner join invoice_detail id on i.id = id.invoice_id \n inner join invoice_info if_ on i.id = if_.invoice_id \n inner join stores s on s.id = i.store_id \n inner join sales_persons sp on sp.id = i.sale_person_id \n inner join users u on u.id = sp.user_id \n inner join customers c on c.id = i.customer_id \n inner join type_identities ti on ti.description = c.document_type\n inner join prefixes p on p.code = i.serial \n left join ( \n \tselect string_agg(pays.\"name\" , ', ') pay ,ip.invoice_id from invoice_pays ip \n\t inner join pays on pays.id = pay_id \n\t group by ip.invoice_id \n ) as pays_ on pays_.invoice_id = i.id\n where i.id = i.id and i.document_date >= '2024-12-01' and i.document_date <= '2024-12-30 23:59:59'"bindings: [] 1735573306.5721 "select * from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?) order by \"document_date\" desc"bindings: ["22",0] 1735575636.7206 "select * from \"invoices\" where \"store_id\" <> ? and exists (select * from \"invoice_info\" where \"invoices\".\"id\" = \"invoice_info\".\"invoice_id\" and \"status_sync\" = ? and \"additional_3\" is not null) order by \"document_date\" desc"bindings: ["22",0] 1735580265.9741 "select count(*) as aggregate from \"invoices\""bindings: [] 1735590037.2018 "select * from \"invoices\" where \"store_id\" <> ? and exists (select * from \"invoice_info\" where \"invoices\".\"id\" = \"invoice_info\".\"invoice_id\" and \"status_sync\" = ? and \"additional_3\" is not null) order by \"document_date\" desc"bindings: ["22",0] 1735608786.3337 "SELECT 1"bindings: [] 1735608788.4544 "SELECT 1"bindings: [] 1735677694.631 "select * from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?) order by \"document_date\" desc"bindings: ["22",0] 1735723146.5549 "SELECT 1"bindings: [] 1735723148.6118 "SELECT 1"bindings: [] 1735851002.0228 "select * from \"customers\" where \"status_sync\" = ?"bindings: [0] 1735923907.3267 "SELECT 1"bindings: [] 1735923909.377 "SELECT 1"bindings: [] 1735930403.8597 "select * from \"items\" where \"reference\" = ? or \"barcode\" = ?"bindings: ["3611820088658","3611820088658"] 1735942423.4024 "select * from \"departaments\" where \"id\" = ?"bindings: ["undefined"] 1735958578.6696 "select * from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?) order by \"document_date\" desc"bindings: ["22",0] 1736009975.1319 "select count(*) as aggregate from \"invoices\""bindings: [] 1736012404.0663 "select * from \"config\" where \"code\" = ?"bindings: ["TAX"] 1736015443.6066 "select * from \"items\" where \"reference\" = ? or \"barcode\" = ?"bindings: ["8050235362819","8050235362819"] 1736019229.8974 "select * from \"customers\" where \"document\" = ?"bindings: ["BA274078"] 1736019342.2347 "select count(*) as aggregate from \"customers\" where \"last_name\"::text like ?"bindings: ["%PEREA%"] 1736019859.9546 "select * from dashboard_best_sale_persons(0)"bindings: [] 1736019860.0612 "select * from dashboard_best_seller_now(0,-1)"bindings: [] 1736025638.7621 "select * from \"invoices\" where \"store_id\" <> ? and exists (select * from \"invoice_info\" where \"invoices\".\"id\" = \"invoice_info\".\"invoice_id\" and \"status_sync\" = ? and \"additional_3\" is not null) order by \"document_date\" desc"bindings: ["22",0] 1736025639.811 "SELECT 1"bindings: [] 1736025641.9043 "SELECT 1"bindings: [] 1736026663.478 "select * from \"items\" where \"reference\" = ? or \"barcode\" = ?"bindings: ["192521619530","192521619530"] 1736032543.4125 "select * from dashboard_best_sale_persons(0)"bindings: [] 1736032543.4872 "select * from dashboard_best_seller_now(0,-1)"bindings: [] 1736187413.2364 "SELECT 1"bindings: [] 1736187415.3029 "SELECT 1"bindings: [] 1736187416.7909 "SELECT 1"bindings: [] 1736187419.271 "SELECT 1"bindings: [] 1736187422.3367 "SELECT 1"bindings: [] 1736187424.574 "SELECT 1"bindings: [] 1736187425.8945 "SELECT 1"bindings: [] 1736187428.0324 "SELECT 1"bindings: [] 1736187445.4165 "SELECT 1"bindings: [] 1736187447.1914 "SELECT 1"bindings: [] 1736187447.7111 "SELECT 1"bindings: [] 1736187449.2308 "SELECT 1"bindings: [] 1736187449.4155 "SELECT 1"bindings: [] 1736187450.6371 "SELECT 1"bindings: [] 1736187451.2469 "SELECT 1"bindings: [] 1736187451.385 "SELECT 1"bindings: [] 1736187453.1102 "SELECT 1"bindings: [] 1736187453.5086 "SELECT 1"bindings: [] 1736187454.9081 "SELECT 1"bindings: [] 1736187457.4257 "SELECT 1"bindings: [] 1736187468.1615 "SELECT 1"bindings: [] 1736187470.3814 "SELECT 1"bindings: [] 1736187471.7003 "SELECT 1"bindings: [] 1736187474.0691 "SELECT 1"bindings: [] 1736187488.2418 "SELECT 1"bindings: [] 1736187490.5301 "SELECT 1"bindings: [] 1736187491.8537 "SELECT 1"bindings: [] 1736187493.9263 "SELECT 1"bindings: [] 1736187494.2536 "SELECT 1"bindings: [] 1736187496.3959 "SELECT 1"bindings: [] 1736187497.1316 "SELECT 1"bindings: [] 1736187497.7355 "SELECT 1"bindings: [] 1736187499.4229 "SELECT 1"bindings: [] 1736187500.1481 "SELECT 1"bindings: [] 1736187500.7437 "SELECT 1"bindings: [] 1736187503.1681 "SELECT 1"bindings: [] 1736187534.1487 "SELECT 1"bindings: [] 1736187536.4059 "SELECT 1"bindings: [] 1736187537.7651 "SELECT 1"bindings: [] 1736187538.5289 "SELECT 1"bindings: [] 1736187540.1916 "SELECT 1"bindings: [] 1736187540.7957 "SELECT 1"bindings: [] 1736187542.1656 "SELECT 1"bindings: [] 1736187544.3372 "SELECT 1"bindings: [] 1736187547.1741 "SELECT 1"bindings: [] 1736187549.226 "SELECT 1"bindings: [] 1736187550.544 "SELECT 1"bindings: [] 1736187552.6656 "SELECT 1"bindings: [] 1736187559.3785 "SELECT 1"bindings: [] 1736187561.5429 "SELECT 1"bindings: [] 1736187562.8954 "SELECT 1"bindings: [] 1736187565.4388 "SELECT 1"bindings: [] 1736187569.1535 "SELECT 1"bindings: [] 1736187571.3546 "SELECT 1"bindings: [] 1736187572.7223 "SELECT 1"bindings: [] 1736187575.1691 "SELECT 1"bindings: [] 1736187590.4841 "SELECT 1"bindings: [] 1736187592.8139 "SELECT 1"bindings: [] 1736187594.1216 "SELECT 1"bindings: [] 1736187596.3779 "SELECT 1"bindings: [] 1736188264.7936 "select * from \"invoice_pays\" where \"pay_id\" = ? and \"voucher_code\" = ?"bindings: ["7","D001-00000109"] 1736193003.8282 "SELECT \n s.code || ' - ' || s.\"name\" store,\n s.additional_2, \n id.id,\n c.email,\n ti.code document_type_sunat,\n sp.code sale_person,\n u.\"name\" sale_person_name,\n c.\"document\" customer,\n c.document_type,\n c.first_name || ' ' || c.last_name customer_name,\n c.address ,\n c.state ,\n c.province ,\n c.city ,\n c.email,\n c.phone,\n p.name prefix_name,\n p.code prefix_code,\n i.\"number\" ,\n i.document_date::date document_date_ ,\n i.document_date ,\n i.observations ,\n id.item,\n id.barcode ,\n id.description,\n id.brand,\n i.total_price - i.total_tax total_invoice,\n i.total_price total_invoice_including_vat,\n i.total_tax total_tax,\n id.\"Unit_Price_Including_VAT\" ,\n id.quantity ,\n id.discount ,\n id.total_price ,\n id.tax ,\n id.\"cost\",\n cast( id.total_price - id.\"cost\" as decimal(24,2)) margen,\n if_.status_sync sync,\n pays_.pay\n from invoices i\n inner join invoice_detail id on i.id = id.invoice_id \n inner join invoice_info if_ on i.id = if_.invoice_id \n inner join stores s on s.id = i.store_id \n inner join sales_persons sp on sp.id = i.sale_person_id \n inner join users u on u.id = sp.user_id \n inner join customers c on c.id = i.customer_id \n inner join type_identities ti on ti.description = c.document_type\n inner join prefixes p on p.code = i.serial \n left join ( \n \tselect string_agg(pays.\"name\" , ', ') pay ,ip.invoice_id from invoice_pays ip \n\t inner join pays on pays.id = pay_id \n\t group by ip.invoice_id \n ) as pays_ on pays_.invoice_id = i.id\n where i.id = i.id and i.document_date >= '2025-06-01'"bindings: [] 1736197465.2222 "select count(*) as aggregate from \"cash_register\""bindings: [] 1736201191.8769 "select * from \"documents\" where \"name\" = ?"bindings: ["SaleReturn"] 1736207654.4492 "select * from \"items\" where \"reference\" = ? or \"barcode\" = ?"bindings: ["8050235295643","8050235295643"] 1736212853.6486 "select count(*) as aggregate from \"invoices\" where exists (select * from \"invoice_info\" where \"invoices\".\"id\" = \"invoice_info\".\"invoice_id\" and \"status_sync\" = ? and \"status_pay\" = ?)"bindings: [1,0] 1736240635.4908 "SELECT 1"bindings: [] 1736240637.799 "SELECT 1"bindings: [] 1736240639.3226 "SELECT 1"bindings: [] 1736240641.3936 "SELECT 1"bindings: [] 1736247509.4707 "SELECT 1"bindings: [] 1736247511.9008 "SELECT 1"bindings: [] 1736247513.2674 "SELECT 1"bindings: [] 1736247515.4034 "SELECT 1"bindings: [] 1736249379.7583 "SELECT 1"bindings: [] 1736249382.7738 "SELECT 1"bindings: [] 1736249384.0994 "SELECT 1"bindings: [] 1736249386.4797 "SELECT 1"bindings: [] 1736259513.3518 "SELECT 1"bindings: [] 1736259515.4019 "SELECT 1"bindings: [] 1736261764.1735 "select * from \"users\" where \"users\".\"id\" = ? limit 1"bindings: ["118"] 1736269009.1002 "select count(*) as aggregate from \"invoices\" where \"document_date\" <= ? and \"document_date\" >= ?"bindings: ["2024-12-19 23:59:59","2024-12-19"] 1736272256.122 "select count(*) as aggregate from \"sales_return\" where exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ? and \"status_pay\" = ?) and \"number\" = ?"bindings: [1,0,"D001-00000001"] 1736277602.4064 "select * from \"customers\" where \"document\" = ?"bindings: ["8-303-244"] 1736283002.5431 "select * from dashboard_best_sale_persons(0)"bindings: [] 1736283002.6422 "select * from dashboard_best_seller_now(0,-1)"bindings: [] 1736283017.7848 "select * from \"items\" where \"reference\" = ? or \"barcode\" = ?"bindings: ["8445540061692","8445540061692"] 1736287804.3515 "select count(*) as aggregate from \"sales_return\" where exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ? and \"status_pay\" = ?)"bindings: [1,0] 1736289003.1069 "select count(*) as aggregate from \"invoices\" where \"number\" = ?"bindings: ["F001-00000712"] 1736298757.993 "SELECT 1"bindings: [] 1736298760.0841 "SELECT 1"bindings: [] 1736332645.4501 "SELECT 1"bindings: [] 1736332647.4976 "SELECT 1"bindings: [] 1736364992.5986 "select count(*) as aggregate from \"invoices\""bindings: [] 1736365540.3797 "select count(*) as aggregate from \"invoices\""bindings: [] 1736365579.0836 "select count(*) as aggregate from \"invoices\""bindings: [] 1736367520.2985 "select count(*) as aggregate from \"sales_return\""bindings: [] 1736369216.4364 "select count(*) as aggregate from \"sales_return\""bindings: [] 1736388501.6968 "SELECT 1"bindings: [] 1736388503.7558 "SELECT 1"bindings: [] 1736446070.7499 "SELECT 1"bindings: [] 1736446072.8553 "SELECT 1"bindings: [] 1736446073.6836 "SELECT 1"bindings: [] 1736446075.0421 "SELECT 1"bindings: [] 1736446075.8851 "SELECT 1"bindings: [] 1736446077.1106 "SELECT 1"bindings: [] 1736446077.3502 "SELECT 1"bindings: [] 1736446079.146 "SELECT 1"bindings: [] 1736446095.7864 "SELECT 1"bindings: [] 1736446098.0325 "SELECT 1"bindings: [] 1736446098.8589 "SELECT 1"bindings: [] 1736446099.3463 "SELECT 1"bindings: [] 1736446101.0562 "SELECT 1"bindings: [] 1736446101.5496 "SELECT 1"bindings: [] 1736446102.2937 "SELECT 1"bindings: [] 1736446102.7488 "SELECT 1"bindings: [] 1736446104.5614 "SELECT 1"bindings: [] 1736446104.8068 "SELECT 1"bindings: [] 1736446106.037 "SELECT 1"bindings: [] 1736446108.2694 "SELECT 1"bindings: [] 1736446117.7807 "SELECT 1"bindings: [] 1736446119.9503 "SELECT 1"bindings: [] 1736446121.2344 "SELECT 1"bindings: [] 1736446123.2936 "SELECT 1"bindings: [] 1736446137.7413 "SELECT 1"bindings: [] 1736446139.8741 "SELECT 1"bindings: [] 1736446141.197 "SELECT 1"bindings: [] 1736446143.6567 "SELECT 1"bindings: [] 1736446145.7264 "SELECT 1"bindings: [] 1736446147.8862 "SELECT 1"bindings: [] 1736446148.6783 "SELECT 1"bindings: [] 1736446148.6786 "SELECT 1"bindings: [] 1736446149.2401 "SELECT 1"bindings: [] 1736446150.7689 "SELECT 1"bindings: [] 1736446150.8704 "SELECT 1"bindings: [] 1736446150.8842 "SELECT 1"bindings: [] 1736446151.6554 "SELECT 1"bindings: [] 1736446152.1059 "SELECT 1"bindings: [] 1736446152.1056 "SELECT 1"bindings: [] 1736446153.0812 "SELECT 1"bindings: [] 1736446154.2841 "SELECT 1"bindings: [] 1736446154.2863 "SELECT 1"bindings: [] 1736446154.3262 "SELECT 1"bindings: [] 1736446154.6349 "SELECT 1"bindings: [] 1736446156.6403 "SELECT 1"bindings: [] 1736446156.7132 "SELECT 1"bindings: [] 1736446156.8311 "SELECT 1"bindings: [] 1736446157.6034 "SELECT 1"bindings: [] 1736446158.0609 "SELECT 1"bindings: [] 1736446158.6371 "SELECT 1"bindings: [] 1736446158.8655 "SELECT 1"bindings: [] 1736446159.8915 "SELECT 1"bindings: [] 1736446160.2681 "SELECT 1"bindings: [] 1736446160.5456 "SELECT 1"bindings: [] 1736446160.9741 "SELECT 1"bindings: [] 1736446160.974 "SELECT 1"bindings: [] 1736446161.1297 "SELECT 1"bindings: [] 1736446162.2323 "SELECT 1"bindings: [] 1736446162.2827 "SELECT 1"bindings: [] 1736446162.706 "SELECT 1"bindings: [] 1736446163.3171 "SELECT 1"bindings: [] 1736446164.3962 "SELECT 1"bindings: [] 1736446164.3994 "SELECT 1"bindings: [] 1736446164.6207 "SELECT 1"bindings: [] 1736446166.8448 "SELECT 1"bindings: [] 1736446167.629 "SELECT 1"bindings: [] 1736446168.1209 "SELECT 1"bindings: [] 1736446169.878 "SELECT 1"bindings: [] 1736446169.8758 "SELECT 1"bindings: [] 1736446170.2887 "SELECT 1"bindings: [] 1736446171.093 "SELECT 1"bindings: [] 1736446171.1246 "SELECT 1"bindings: [] 1736446173.2736 "SELECT 1"bindings: [] 1736446173.6942 "SELECT 1"bindings: [] 1736446364.64 "SELECT 1"bindings: [] 1736446366.7827 "SELECT 1"bindings: [] 1736446366.7984 "SELECT 1"bindings: [] 1736446368.0438 "SELECT 1"bindings: [] 1736446368.6328 "SELECT 1"bindings: [] 1736446370.2671 "SELECT 1"bindings: [] 1736446370.8578 "SELECT 1"bindings: [] 1736446372.1047 "SELECT 1"bindings: [] 1736446374.171 "SELECT 1"bindings: [] 1736446376.7992 "SELECT 1"bindings: [] 1736446379.1076 "SELECT 1"bindings: [] 1736446394.6384 "SELECT 1"bindings: [] 1736446396.842 "SELECT 1"bindings: [] 1736446398.0837 "SELECT 1"bindings: [] 1736446400.208 "SELECT 1"bindings: [] 1736446436.6534 "SELECT 1"bindings: [] 1736446438.8096 "SELECT 1"bindings: [] 1736446438.9188 "SELECT 1"bindings: [] 1736446440.2377 "SELECT 1"bindings: [] 1736446441.0754 "SELECT 1"bindings: [] 1736446442.2997 "SELECT 1"bindings: [] 1736446457.73 "SELECT 1"bindings: [] 1736446459.7847 "SELECT 1"bindings: [] 1736446461.0246 "SELECT 1"bindings: [] 1736446463.2995 "SELECT 1"bindings: [] 1736446481.6429 "SELECT 1"bindings: [] 1736446483.8244 "SELECT 1"bindings: [] 1736446487.3618 "select count(*) as aggregate from \"customers\""bindings: [] 1736446496.6377 "SELECT 1"bindings: [] 1736446498.7063 "SELECT 1"bindings: [] 1736446499.9324 "SELECT 1"bindings: [] 1736446501.9635 "SELECT 1"bindings: [] 1736446611.0643 "SELECT 1"bindings: [] 1736446613.1738 "SELECT 1"bindings: [] 1736446613.6232 "SELECT 1"bindings: [] 1736446613.7162 "SELECT 1"bindings: [] 1736446613.8526 "SELECT 1"bindings: [] 1736446614.4004 "SELECT 1"bindings: [] 1736446615.8012 "SELECT 1"bindings: [] 1736446615.8304 "SELECT 1"bindings: [] 1736446615.9806 "SELECT 1"bindings: [] 1736446616.8605 "SELECT 1"bindings: [] 1736446617.047 "SELECT 1"bindings: [] 1736446617.0747 "SELECT 1"bindings: [] 1736446617.2105 "SELECT 1"bindings: [] 1736446619.1647 "SELECT 1"bindings: [] 1736446619.1893 "SELECT 1"bindings: [] 1736446619.2673 "SELECT 1"bindings: [] 1736446714.647 "select * from \"invoice_pays\" where \"pay_id\" = ? and \"voucher_code\" = ?"bindings: ["7","D001-00000117"] 1736446755.6413 "SELECT 1"bindings: [] 1736446757.8573 "SELECT 1"bindings: [] 1736446759.0906 "SELECT 1"bindings: [] 1736446761.265 "SELECT 1"bindings: [] 1736446764.8237 "SELECT 1"bindings: [] 1736446766.966 "SELECT 1"bindings: [] 1736446768.2252 "SELECT 1"bindings: [] 1736446770.617 "SELECT 1"bindings: [] 1736446777.6769 "SELECT 1"bindings: [] 1736446779.7671 "SELECT 1"bindings: [] 1736446781.0454 "SELECT 1"bindings: [] 1736446783.2415 "SELECT 1"bindings: [] 1736446784.6907 "SELECT 1"bindings: [] 1736446786.914 "SELECT 1"bindings: [] 1736446788.1678 "SELECT 1"bindings: [] 1736446790.2719 "SELECT 1"bindings: [] 1736448497.2763 "select * from dashboard_best_sale_persons(0)"bindings: [] 1736448497.42 "select * from dashboard_best_seller_now(0,-1)"bindings: [] 1736456774.3021 "select count(*) as aggregate from \"sales_return\" where exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ? and \"status_pay\" = ?)"bindings: [1,0] 1736456775.3471 "SELECT 1"bindings: [] 1736456777.3902 "SELECT 1"bindings: [] 1736463001.9322 "select * from \"sales_return\" where \"document_date\" >= ?"bindings: ["01-03-25"] 1736473448.0904 "SELECT 1"bindings: [] 1736473450.4615 "SELECT 1"bindings: [] 1736473451.9881 "SELECT 1"bindings: [] 1736473454.3653 "SELECT 1"bindings: [] 1736473455.0743 "SELECT 1"bindings: [] 1736473457.1724 "SELECT 1"bindings: [] 1736473457.169 "SELECT 1"bindings: [] 1736473458.4097 "SELECT 1"bindings: [] 1736473459.4484 "SELECT 1"bindings: [] 1736473460.7439 "SELECT 1"bindings: [] 1736473460.7744 "SELECT 1"bindings: [] 1736473463.0894 "SELECT 1"bindings: [] 1736473586.0767 "SELECT 1"bindings: [] 1736473588.1387 "SELECT 1"bindings: [] 1736473589.4989 "SELECT 1"bindings: [] 1736473591.5413 "SELECT 1"bindings: [] 1736509781.6058 "SELECT 1"bindings: [] 1736509783.6476 "SELECT 1"bindings: [] 1736512626.2829 "SELECT 1"bindings: [] 1736512628.3384 "SELECT 1"bindings: [] 1736531948.6697 "SELECT 1"bindings: [] 1736531950.7518 "SELECT 1"bindings: [] 1736531950.906 "SELECT 1"bindings: [] 1736531951.636 "SELECT 1"bindings: [] 1736531952.2455 "SELECT 1"bindings: [] 1736531952.9144 "SELECT 1"bindings: [] 1736531953.8768 "SELECT 1"bindings: [] 1736531954.1718 "SELECT 1"bindings: [] 1736531954.4576 "SELECT 1"bindings: [] 1736531955.1381 "SELECT 1"bindings: [] 1736531956.7246 "SELECT 1"bindings: [] 1736531957.3489 "SELECT 1"bindings: [] 1736531970.6818 "SELECT 1"bindings: [] 1736531970.6867 "SELECT 1"bindings: [] 1736531972.9141 "SELECT 1"bindings: [] 1736531972.9115 "SELECT 1"bindings: [] 1736531974.2956 "SELECT 1"bindings: [] 1736531976.3292 "SELECT 1"bindings: [] 1736532020.5651 "insert into \"terminals\" (\"code\", \"name\", \"store_id\", \"status\", \"updated_at\", \"created_at\") values (?, ?, ?, ?, ?, ?) returning \"id\""bindings: [null,null,null,"Active","2025-01-10 13:00:20","2025-01-10 13:00:20"] 1736532122.7903 "SELECT 1"bindings: [] 1736532125.0549 "SELECT 1"bindings: [] 1736532126.4015 "SELECT 1"bindings: [] 1736532128.8972 "SELECT 1"bindings: [] 1736532143.6703 "select * from \"users\" where \"users\".\"id\" = ? limit 1"bindings: ["reg"] 1736532146.7008 "SELECT 1"bindings: [] 1736532148.8214 "SELECT 1"bindings: [] 1736532150.1142 "SELECT 1"bindings: [] 1736532152.328 "SELECT 1"bindings: [] 1736532156.6961 "SELECT 1"bindings: [] 1736532158.8693 "SELECT 1"bindings: [] 1736532160.2601 "SELECT 1"bindings: [] 1736532162.8293 "SELECT 1"bindings: [] 1736545854.9794 "select * from \"departaments\" where \"id\" = ?"bindings: ["undefined"] 1736547826.2816 "select count(*) as aggregate from \"invoices\""bindings: [] 1736547835.2679 "select count(*) as aggregate from \"invoices\" where \"document_date\" <= ? and \"document_date\" >= ?"bindings: ["2025-01-09 23:59:59","2025-01-09"] 1736548385.349 "select count(*) as aggregate from \"invoices\" where \"document_date\" <= ? and exists (select * from \"invoice_info\" where \"invoices\".\"id\" = \"invoice_info\".\"invoice_id\" and \"status_sync\" = ?)"bindings: ["2024-12-31 23:59:59",0] 1736548388.076 "select count(*) as aggregate from \"invoices\" where \"document_date\" <= ? and exists (select * from \"invoice_info\" where \"invoices\".\"id\" = \"invoice_info\".\"invoice_id\" and \"status_sync\" = ?)"bindings: ["2024-12-31 23:59:59",0] 1736548802.1473 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736549402.3236 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736550002.2599 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736550354.1355 "select count(*) as aggregate from \"invoices\" where exists (select * from \"invoice_info\" where \"invoices\".\"id\" = \"invoice_info\".\"invoice_id\" and \"status_sync\" = ? and \"status_pay\" = ?)"bindings: [1,0] 1736550354.4598 "select count(*) as aggregate from \"sales_return\" where exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ? and \"status_pay\" = ?)"bindings: [1,0] 1736550602.2468 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736551802.2214 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736553002.4137 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736553602.1317 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736554202.0793 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736555402.1462 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736557202.1408 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736557802.1672 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736559602.4295 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736561402.1232 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736562002.1351 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736562602.3009 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736571002.1483 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736571602.6214 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736573402.2202 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736607602.4161 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736613601.7595 "select * from \"customers\" where \"status_sync\" = ?"bindings: [0] 1736613601.8857 "select * from \"sales_return\" where \"document_date\" >= ?"bindings: ["01-05-25"] 1736613602.491 "select count(*) as aggregate from \"invoices\" where \"store_id\" <> ? and exists (select * from \"invoice_info\" where \"invoices\".\"id\" = \"invoice_info\".\"invoice_id\" and \"status_sync\" = ? and \"additional_3\" is not null)"bindings: ["22",0] 1736613603.2906 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736616005.405 "select count(*) as aggregate from \"invoices\" where \"store_id\" <> ? and exists (select * from \"invoice_info\" where \"invoices\".\"id\" = \"invoice_info\".\"invoice_id\" and \"status_sync\" = ? and \"additional_3\" is not null)"bindings: ["22",0] 1736621403.3746 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736623203.0347 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736630403.1076 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736632202.9674 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736634053.4671 "select count(*) as aggregate from \"invoices\" where exists (select * from \"invoice_info\" where \"invoices\".\"id\" = \"invoice_info\".\"invoice_id\" and \"status_sync\" = ? and \"status_pay\" = ?)"bindings: [1,0] 1736637002.982 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736638203.8281 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736639221.0199 "SELECT 1"bindings: [] 1736639223.1044 "SELECT 1"bindings: [] 1736639403.7951 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736639453.4019 "select count(*) as aggregate from \"invoices\" where exists (select * from \"invoice_info\" where \"invoices\".\"id\" = \"invoice_info\".\"invoice_id\" and \"status_sync\" = ? and \"status_pay\" = ?)"bindings: [1,0] 1736640003.1266 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736641126.8528 "select * from dashboard_best_sale_persons(0)"bindings: [] 1736641127.0022 "select * from dashboard_best_seller_now(0,-1)"bindings: [] 1736641202.4357 "select count(*) as aggregate from \"invoices\" where \"store_id\" <> ? and exists (select * from \"invoice_info\" where \"invoices\".\"id\" = \"invoice_info\".\"invoice_id\" and \"status_sync\" = ? and \"additional_3\" is not null)"bindings: ["22",0] 1736641203.3817 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736641234.8508 "SELECT 1"bindings: [] 1736641236.9594 "SELECT 1"bindings: [] 1736641239.8152 "SELECT 1"bindings: [] 1736641241.853 "SELECT 1"bindings: [] 1736641802.4233 "select count(*) as aggregate from \"invoices\" where \"store_id\" <> ? and exists (select * from \"invoice_info\" where \"invoices\".\"id\" = \"invoice_info\".\"invoice_id\" and \"status_sync\" = ? and \"additional_3\" is not null)"bindings: ["22",0] 1736641803.2794 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736641883.4892 "select * from dashboard_best_seller_now(0,-1)"bindings: [] 1736641883.4789 "select * from dashboard_best_sale_persons(0)"bindings: [] 1736642153.6994 "select count(*) as aggregate from \"sales_return\" where exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ? and \"status_pay\" = ?)"bindings: [1,0] 1736643603.0289 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736646002.9466 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736649003.4786 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736651402.9786 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736652603.2448 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736654403.3902 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736656149.5634 "SELECT 1"bindings: [] 1736656151.6113 "SELECT 1"bindings: [] 1736661603.2618 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736665032.9946 "SELECT 1"bindings: [] 1736665034.8367 "SELECT 1"bindings: [] 1736665035.0838 "SELECT 1"bindings: [] 1736665036.3357 "SELECT 1"bindings: [] 1736665037.0016 "SELECT 1"bindings: [] 1736665038.2444 "SELECT 1"bindings: [] 1736665038.8134 "SELECT 1"bindings: [] 1736665040.2845 "SELECT 1"bindings: [] 1736665055.7884 "SELECT 1"bindings: [] 1736665057.9875 "SELECT 1"bindings: [] 1736665059.2482 "SELECT 1"bindings: [] 1736665061.4286 "SELECT 1"bindings: [] 1736665065.8784 "SELECT 1"bindings: [] 1736665067.746 "SELECT 1"bindings: [] 1736665068.1882 "SELECT 1"bindings: [] 1736665069.4191 "SELECT 1"bindings: [] 1736665070.0172 "SELECT 1"bindings: [] 1736665071.3223 "SELECT 1"bindings: [] 1736665071.5399 "SELECT 1"bindings: [] 1736665073.7954 "SELECT 1"bindings: [] 1736665076.8894 "SELECT 1"bindings: [] 1736665079.1817 "SELECT 1"bindings: [] 1736665080.4934 "SELECT 1"bindings: [] 1736665082.5442 "SELECT 1"bindings: [] 1736694003.2706 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736709603.8791 "select count(*) as aggregate from \"invoices\" where \"store_id\" <> ? and exists (select * from \"invoice_info\" where \"invoices\".\"id\" = \"invoice_info\".\"invoice_id\" and \"status_sync\" = ? and \"additional_3\" is not null)"bindings: ["22",0] 1736709604.5197 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736710803.8157 "select count(*) as aggregate from \"invoices\" where \"store_id\" <> ? and exists (select * from \"invoice_info\" where \"invoices\".\"id\" = \"invoice_info\".\"invoice_id\" and \"status_sync\" = ? and \"additional_3\" is not null)"bindings: ["22",0] 1736710804.468 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736712003.9553 "select count(*) as aggregate from \"invoices\" where \"store_id\" <> ? and exists (select * from \"invoice_info\" where \"invoices\".\"id\" = \"invoice_info\".\"invoice_id\" and \"status_sync\" = ? and \"additional_3\" is not null)"bindings: ["22",0] 1736712004.6533 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736713804.0779 "select count(*) as aggregate from \"invoices\" where \"store_id\" <> ? and exists (select * from \"invoice_info\" where \"invoices\".\"id\" = \"invoice_info\".\"invoice_id\" and \"status_sync\" = ? and \"additional_3\" is not null)"bindings: ["22",0] 1736713804.7949 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736716203.9384 "select count(*) as aggregate from \"invoices\" where \"store_id\" <> ? and exists (select * from \"invoice_info\" where \"invoices\".\"id\" = \"invoice_info\".\"invoice_id\" and \"status_sync\" = ? and \"additional_3\" is not null)"bindings: ["22",0] 1736716204.6721 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736717199.7274 "select * from \"items\" where \"reference\" = ? or \"barcode\" = ?"bindings: ["9878903558017","9878903558017"] 1736720403.8763 "select count(*) as aggregate from \"invoices\" where \"store_id\" <> ? and exists (select * from \"invoice_info\" where \"invoices\".\"id\" = \"invoice_info\".\"invoice_id\" and \"status_sync\" = ? and \"additional_3\" is not null)"bindings: ["22",0] 1736720404.5179 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736722803.9597 "select count(*) as aggregate from \"invoices\" where \"store_id\" <> ? and exists (select * from \"invoice_info\" where \"invoices\".\"id\" = \"invoice_info\".\"invoice_id\" and \"status_sync\" = ? and \"additional_3\" is not null)"bindings: ["22",0] 1736722804.7139 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736725803.9551 "select count(*) as aggregate from \"invoices\" where \"store_id\" <> ? and exists (select * from \"invoice_info\" where \"invoices\".\"id\" = \"invoice_info\".\"invoice_id\" and \"status_sync\" = ? and \"additional_3\" is not null)"bindings: ["22",0] 1736725804.6419 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736735403.9633 "select count(*) as aggregate from \"invoices\" where \"store_id\" <> ? and exists (select * from \"invoice_info\" where \"invoices\".\"id\" = \"invoice_info\".\"invoice_id\" and \"status_sync\" = ? and \"additional_3\" is not null)"bindings: ["22",0] 1736735404.6195 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736736005.5018 "select count(*) as aggregate from \"invoices\" where \"store_id\" <> ? and exists (select * from \"invoice_info\" where \"invoices\".\"id\" = \"invoice_info\".\"invoice_id\" and \"status_sync\" = ? and \"additional_3\" is not null)"bindings: ["22",0] 1736737204.0277 "select count(*) as aggregate from \"invoices\" where \"store_id\" <> ? and exists (select * from \"invoice_info\" where \"invoices\".\"id\" = \"invoice_info\".\"invoice_id\" and \"status_sync\" = ? and \"additional_3\" is not null)"bindings: ["22",0] 1736737204.7772 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736739603.7579 "select count(*) as aggregate from \"invoices\" where \"store_id\" <> ? and exists (select * from \"invoice_info\" where \"invoices\".\"id\" = \"invoice_info\".\"invoice_id\" and \"status_sync\" = ? and \"additional_3\" is not null)"bindings: ["22",0] 1736742603.9974 "select count(*) as aggregate from \"invoices\" where \"store_id\" <> ? and exists (select * from \"invoice_info\" where \"invoices\".\"id\" = \"invoice_info\".\"invoice_id\" and \"status_sync\" = ? and \"additional_3\" is not null)"bindings: ["22",0] 1736742604.7096 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736743778.1528 "SELECT 1"bindings: [] 1736743781.747 "SELECT 1"bindings: [] 1736743783.8847 "SELECT 1"bindings: [] 1736743786.0595 "SELECT 1"bindings: [] 1736763649.1598 "SELECT 1"bindings: [] 1736763651.4101 "SELECT 1"bindings: [] 1736763652.7021 "SELECT 1"bindings: [] 1736763654.7386 "SELECT 1"bindings: [] 1736780092.5701 "select * from \"cash_register\" where (\"date\" = ? and \"store_id\" = ? and \"terminal_id\" = ?)"bindings: ["2025-01-13","27","11"] 1736780098.5211 "select * from \"cash_register\" where (\"date\" = ? and \"store_id\" = ? and \"terminal_id\" = ?)"bindings: ["2025-01-13","27","11"] 1736780109.6396 "SELECT 1"bindings: [] 1736780111.8781 "SELECT 1"bindings: [] 1736780114.6053 "SELECT 1"bindings: [] 1736780117.035 "SELECT 1"bindings: [] 1736780138.5711 "select * from \"users\" where \"nick_name\" = ? limit 1"bindings: ["MULTIPLAZA.PANAMA.02"] 1736780208.6473 "select * from \"users\" where \"nick_name\" = ? limit 1"bindings: ["MULTIPLAZA.PANAMA.01"] 1736783402.9468 "select count(*) as aggregate from \"invoices\" where \"store_id\" <> ? and exists (select * from \"invoice_info\" where \"invoices\".\"id\" = \"invoice_info\".\"invoice_id\" and \"status_sync\" = ? and \"additional_3\" is not null)"bindings: ["22",0] 1736783403.6219 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736786757.8387 "SELECT \n s.code || ' - ' || s.\"name\" store,\n s.additional_2, \n id.id,\n c.email,\n ti.code document_type_sunat,\n sp.code sale_person,\n u.\"name\" sale_person_name,\n c.\"document\" customer,\n c.document_type,\n c.first_name || ' ' || c.last_name customer_name,\n c.address ,\n c.state ,\n c.province ,\n c.city ,\n c.email,\n c.phone,\n p.name prefix_name,\n p.code prefix_code,\n i.\"number\" ,\n i.document_date::date document_date_ ,\n i.document_date ,\n i.observations ,\n id.item,\n id.barcode ,\n id.description,\n id.brand,\n i.total_price - i.total_tax total_invoice,\n i.total_price total_invoice_including_vat,\n i.total_tax total_tax,\n id.\"Unit_Price_Including_VAT\" ,\n id.quantity ,\n id.discount ,\n id.total_price ,\n id.tax ,\n id.\"cost\",\n cast( id.total_price - id.\"cost\" as decimal(24,2)) margen,\n if_.status_sync sync,\n pays_.pay\n from invoices i\n inner join invoice_detail id on i.id = id.invoice_id \n inner join invoice_info if_ on i.id = if_.invoice_id \n inner join stores s on s.id = i.store_id \n inner join sales_persons sp on sp.id = i.sale_person_id \n inner join users u on u.id = sp.user_id \n inner join customers c on c.id = i.customer_id \n inner join type_identities ti on ti.description = c.document_type\n inner join prefixes p on p.code = i.serial \n left join ( \n \tselect string_agg(pays.\"name\" , ', ') pay ,ip.invoice_id from invoice_pays ip \n\t inner join pays on pays.id = pay_id \n\t group by ip.invoice_id \n ) as pays_ on pays_.invoice_id = i.id\n where i.id = i.id and i.document_date >= '2025-01-04' and i.document_date <= '2025-01-04 23:59:59'"bindings: [] 1736790673.7112 "select * from \"users\" where \"users\".\"id\" = ? limit 1"bindings: ["118"] 1736796603.1165 "select count(*) as aggregate from \"invoices\" where \"store_id\" <> ? and exists (select * from \"invoice_info\" where \"invoices\".\"id\" = \"invoice_info\".\"invoice_id\" and \"status_sync\" = ? and \"additional_3\" is not null)"bindings: ["22",0] 1736796603.9092 "select count(*) as aggregate from \"sales_return\" where \"store_id\" <> ? and exists (select * from \"sale_return_info\" where \"sales_return\".\"id\" = \"sale_return_info\".\"sale_return_id\" and \"status_sync\" = ?)"bindings: ["22",0] 1736806932.2571 "select * from dashboard_best_sale_persons(0)"bindings: [] 1736806932.3328 "select * from dashboard_best_seller_now(0,-1)"bindings: [] 1736809341.2747 "select count(*) as aggregate from \"invoices\" where \"document_date\" <= ? and \"document_date\" >= ? and \"store_id\" = ?"bindings: ["2025-01-08 23:59:59","2025-01-08","27"] 1736809622.4383 "select count(*) as aggregate from \"invoices\""bindings: [] 1736811302.487 "select * from dashboard_best_sale_persons(0)"bindings: [] 1736817604.8913 "select count(*) as aggregate from \"invoices\" where \"store_id\" <> ? and exists (select * from \"invoice_info\" where \"invoices\".\"id\" = \"invoice_info\".\"invoice_id\" and \"status_sync\" = ? and \"additional_3\" is not null)"bindings: ["22",0] 1736820731.8031 "SELECT 1"bindings: [] 1736820734.0937 "SELECT 1"bindings: [] 1736847872.3039 "SELECT 1"bindings: [] 1736847874.3451 "SELECT 1"bindings: [] 1736850515.5687 "SELECT 1"bindings: [] 1736850517.8694 "SELECT 1"bindings: [] 1736851793.5573 "SELECT 1"bindings: [] 1736851795.6136 "SELECT 1"bindings: []