pgBadger-
Global information
- Generated on Thu Jul 16 23:00:11 2026
- Log file: /var/log/postgresql/postgresql-16-main.log
- Parsed 64,569 log entries in 10s
- Log start from 2026-07-16 07:00:01 to 2026-07-16 22:00:00
-
Overview
Global Stats
- 6 Number of unique normalized queries
- 42 Number of queries
- 1m8s Total query duration
- 2026-07-16 10:18:24 First query
- 2026-07-16 12:17:27 Last query
- 1 queries/s at 2026-07-16 12:15:03 Query peak
- 1m8s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 1m8s Execute total duration
- 632 Number of events
- 10 Number of unique normalized events
- 592 Max number of times the same event was reported
- 0 Number of cancellation
- 15,360 Total number of automatic vacuums
- 145 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 5,417 Total number of sessions
- 17 sessions at 2026-07-16 17:00:01 Session peak
- 12h46m32s Total duration of sessions
- 8s490ms Average duration of sessions
- 0 Average queries per session
- 12ms Average queries duration per session
- 8s477ms Average idle time per session
- 5,418 Total number of connections
- 9 connections/s at 2026-07-16 07:35:13 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 1 queries/s Query Peak
- 2026-07-16 12:15:03 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2026-07-16 12:15:03 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 0 queries/s Query Peak
- Date
Queries duration
Key values
- 1m8s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 16 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 9 0ms 1s881ms 1s670ms 1s587ms 3s153ms 3s739ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 33 0ms 1s819ms 1s613ms 4s726ms 4s820ms 6s400ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 16 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 9 0 1s670ms 0ms 1s587ms 3s212ms 11 0 0 0ms 0ms 0ms 0ms 12 33 0 1s613ms 1s819ms 4s726ms 4s836ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 16 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jul 16 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 9 9.00 0.00% 11 0 0 0.00 0.00% 12 0 33 33.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% Day Hour Count Average / Second Jul 16 07 361 0.10/s 08 361 0.10/s 09 361 0.10/s 10 362 0.10/s 11 362 0.10/s 12 361 0.10/s 13 361 0.10/s 14 361 0.10/s 15 361 0.10/s 16 361 0.10/s 17 361 0.10/s 18 361 0.10/s 19 361 0.10/s 20 361 0.10/s 21 361 0.10/s 22 1 0.00/s Day Hour Count Average Duration Average idle time Jul 16 07 361 12ms 12ms 08 361 12ms 12ms 09 361 12ms 12ms 10 363 2m6s 2m6s 11 361 12ms 12ms 12 361 13ms 0ms 13 361 12ms 12ms 14 361 13ms 13ms 15 361 13ms 13ms 16 361 12ms 12ms 17 361 13ms 13ms 18 361 12ms 12ms 19 361 12ms 12ms 20 361 12ms 12ms 21 361 12ms 12ms 22 0 0ms 0ms -
Connections
Established Connections
Key values
- 9 connections Connection Peak
- 2026-07-16 07:35:13 Date
Connections per database
Key values
- etendo Main Database
- 5,418 connections Total
Connections per user
Key values
- tad Main User
- 5,418 connections Total
-
Sessions
Simultaneous sessions
Key values
- 17 sessions Session Peak
- 2026-07-16 17:00:01 Date
Histogram of session times
Key values
- 5,399 0-500ms duration
Sessions per database
Key values
- etendo Main Database
- 5,417 sessions Total
Sessions per user
Key values
- tad Main User
- 5,417 sessions Total
Sessions per host
Key values
- 127.0.0.1 Main Host
- 5,417 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 2,075 buffers Checkpoint Peak
- 2026-07-16 12:05:45 Date
- 207.470 seconds Highest write time
- 0.450 seconds Sync time
Checkpoints Wal files
Key values
- 1 files Wal files usage Peak
- 2026-07-16 12:05:45 Date
Checkpoints distance
Key values
- 30.21 Mo Distance Peak
- 2026-07-16 14:05:33 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 16 07 1,743 173.218s 0.461s 173.686s 08 1,735 172.212s 0.275s 172.492s 09 2,280 226.211s 0.012s 226.231s 10 4,757 473.161s 0.012s 473.182s 11 4,090 406.532s 0.012s 406.55s 12 3,624 360.157s 0.012s 360.174s 13 6,623 658.692s 0.019s 658.718s 14 2,480 246.846s 0.013s 246.864s 15 2,304 228.61s 0.014s 228.631s 16 2,626 261.278s 0.012s 261.297s 17 2,344 232.618s 0.012s 232.637s 18 1,798 178.623s 0.012s 178.643s 19 1,602 158.691s 0.012s 158.707s 20 1,751 173.919s 0.012s 173.935s 21 1,654 163.899s 0.012s 163.917s 22 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 16 07 0 0 1 286 0.450s 0.036s 08 0 0 1 291 0.264s 0.026s 09 0 0 1 467 0.001s 0.012s 10 0 0 2 1,126 0.001s 0.011s 11 0 0 2 901 0.001s 0.011s 12 0 0 1 844 0.001s 0.012s 13 0 0 3 1,420 0.001s 0.012s 14 0 0 1 522 0.002s 0.012s 15 0 0 1 491 0.003s 0.012s 16 0 0 1 610 0.001s 0.012s 17 0 0 1 400 0.001s 0.012s 18 0 0 1 277 0.001s 0.012s 19 0 0 1 267 0.001s 0.012s 20 0 0 1 279 0.001s 0.012s 21 0 0 0 285 0.001s 0.012s 22 0 0 0 0 0s 0s Day Hour Count Avg time (sec) Jul 16 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s Day Hour Mean distance Mean estimate Jul 16 07 1,062.83 kB 7,042.92 kB 08 1,063.92 kB 6,849.33 kB 09 1,241.83 kB 7,179.08 kB 10 2,751.83 kB 7,916.75 kB 11 2,371.58 kB 8,934.00 kB 12 1,984.08 kB 9,213.67 kB 13 3,864.92 kB 9,165.17 kB 14 1,561.42 kB 9,394.00 kB 15 1,455.58 kB 8,699.17 kB 16 1,600.08 kB 7,921.75 kB 17 1,371.00 kB 7,921.42 kB 18 1,135.25 kB 7,612.33 kB 19 1,025.58 kB 6,865.25 kB 20 1,071.08 kB 7,021.92 kB 21 1,058.83 kB 7,057.50 kB 22 0.00 kB 0.00 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 16 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.13 sec Highest CPU-cost vacuum
Table profile.last_stat_indexes_srv1
Database etendo - 2026-07-16 21:00:52 Date
- 0 sec Highest CPU-cost analyze
Table
Database etendo - Date
Average Autovacuum Duration
Key values
- 0.13 sec Highest CPU-cost vacuum
Table profile.last_stat_indexes_srv1
Database etendo - 2026-07-16 21:00:52 Date
Analyzes per table
Key values
- profile.last_stat_statements_srv1 (15) Main table analyzed (database etendo)
- 145 analyzes Total
Table Number of analyzes etendo.profile.last_stat_statements_srv1 15 etendo.profile.last_stat_tables_srv1 15 etendo.profile.last_stat_indexes_srv1 15 etendo.profile.last_stat_user_functions_srv1 15 etendo.profile.tables_list 9 etendo.public.ad_session 9 etendo.profile.last_stat_io 7 etendo.public.ad_ep_instance_para 6 etendo.public.ad_process_request 5 etendo.profile.last_stat_activity_count_srv1 4 etendo.profile.funcs_list 4 etendo.profile.stmt_list 4 etendo.profile.last_extension_versions 3 etendo.profile.last_stat_slru 3 etendo.profile.indexes_list 3 etendo.public.ad_preference 3 etendo.profile.sample_stat_user_functions 2 etendo.profile.sample_stat_indexes 2 etendo.profile.sample_stat_tables 2 etendo.profile.sample_statements 2 etendo.public.ad_treenode 1 etendo.profile.sample_statements_total 1 etendo.profile.sample_stat_tables_total 1 etendo.profile.sample_stat_slru 1 etendo.profile.sample_stat_tablespaces 1 etendo.profile.last_stat_archiver 1 etendo.profile.last_stat_wal 1 etendo.public.ad_session_usage_audit 1 etendo.profile.servers 1 etendo.profile.sample_stat_database 1 etendo.profile.sample_stat_user_func_total 1 etendo.profile.sample_stat_io 1 etendo.profile.last_stat_cluster 1 etendo.public.ad_pinstance 1 etendo.public.ad_process_run 1 etendo.profile.sample_stat_indexes_total 1 etendo.public.ad_pinstance_para 1 Total 145 Vacuums per table
Key values
- profile.indexes_list (900) Main table vacuumed on database etendo
- 15,360 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples etendo.profile.indexes_list 900 0 140,316 0 39 0 0 68 38 287,708 0 0 etendo.public.ad_process_request 900 0 225,580 0 436 0 0 167 77 626,063 0 0 etendo.profile.last_stat_tables_srv1 900 0 5,866,532 0 80 0 0 362 83 749,570 0 0 etendo.profile.last_stat_indexes_srv1 900 0 7,138,256 0 85 0 0 388 88 780,868 0 0 etendo.profile.last_stat_user_functions_srv1 900 0 594,962 0 71 0 0 313 73 688,541 0 0 etendo.profile.tables_list 900 0 303,216 0 0 0 0 68 0 16,388 0 0 etendo.profile.last_stat_activity_count_srv1 900 0 16,228 0 71 0 0 68 40 306,564 0 0 etendo.profile.funcs_list 900 0 135,680 0 40 0 0 68 39 291,260 0 0 etendo.profile.last_stat_io 900 0 73,816 0 44 0 0 68 40 309,464 0 0 etendo.profile.last_extension_versions 900 0 40,908 0 47 0 0 68 39 294,403 0 0 etendo.profile.stmt_list 900 0 468,665 0 23 0 0 68 27 207,116 0 0 etendo.profile.last_stat_statements_srv1 900 0 2,097,017 0 70 0 0 303 73 680,599 0 0 etendo.pg_catalog.pg_statistic 825 0 2,095,455 0 49 0 0 154 50 418,250 0 0 etendo.profile.last_stat_slru 780 0 30,307 0 51 0 0 67 38 294,174 0 0 etendo.profile.last_stat_database_srv1 660 0 30,920 0 28 0 0 56 20 114,312 0 0 etendo.public.ad_session 659 0 159,469 0 197 0 0 279 59 483,493 3 3 etendo.public.ad_ep_instance_para 629 4 20,242 0 35 0 0 72 3 38,501 0 0 etendo.public.ad_preference 523 0 281,353 0 116 0 0 43 27 216,967 0 0 etendo.pg_toast.pg_toast_2619 481 0 397,306 0 165 0 0 45 25 204,885 0 0 etendo.profile.sample_stat_user_func_total 1 1 76 0 12 0 0 14 7 34,953 0 0 etendo.pg_toast.pg_toast_407112 1 1 114 0 30 0 0 51 13 32,934 4 7 etendo.profile.sample_stat_tablespaces 1 1 92 0 11 0 0 12 5 23,561 0 0 Total 15,360 7 20,116,510 0 1,700 0 0 2,802 864 7,100,574 7 10 Vacuum throughput per table
Key values
- profile.last_stat_indexes_srv1 (77.2900000000004) Max CPU elapsed for vacuum on database etendo
- unknown (0 ms) Max I/O read time for vacuum on database etendo
- unknown (0 ms) Max I/O write time for vacuum on database etendo
I/O timing (ms) CPU (s) Table read write elapsed etendo.profile.indexes_list 0 0 0 etendo.public.ad_process_request 0 0 0 etendo.profile.last_stat_tables_srv1 0 0 62.3900000000004 etendo.profile.last_stat_indexes_srv1 0 0 77.2900000000004 etendo.profile.last_stat_user_functions_srv1 0 0 0.01 etendo.profile.tables_list 0 0 0 etendo.profile.last_stat_activity_count_srv1 0 0 0 etendo.profile.funcs_list 0 0 0 etendo.profile.last_stat_io 0 0 0 etendo.profile.last_extension_versions 0 0 0 etendo.profile.stmt_list 0 0 0 etendo.profile.last_stat_statements_srv1 0 0 19.0599999999999 etendo.pg_catalog.pg_statistic 0 0 20.0899999999999 etendo.profile.last_stat_slru 0 0 0 etendo.profile.last_stat_database_srv1 0 0 0 etendo.public.ad_session 0 0 0 etendo.public.ad_ep_instance_para 0 0 0 etendo.public.ad_preference 0 0 0.02 etendo.pg_toast.pg_toast_2619 0 0 0.03 etendo.profile.sample_stat_user_func_total 0 0 0 etendo.pg_toast.pg_toast_407112 0 0 0 etendo.profile.sample_stat_tablespaces 0 0 0 Total 0 0 178.890000000001 Tuples removed per table
Key values
- profile.sample_stat_tablespaces (70) Main table with removed tuples on database etendo
- 130 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain etendo.profile.sample_stat_tablespaces 1 1 70 358 22 0 4 etendo.pg_toast.pg_toast_407112 1 1 42 118 20 0 31 etendo.public.ad_ep_instance_para 629 4 12 100,240 100,240 0 2,257 etendo.profile.sample_stat_user_func_total 1 1 6 358 22 0 4 etendo.profile.indexes_list 900 0 0 908,160 408,720 0 40,500 etendo.public.ad_process_request 900 0 0 746,333 419,467 0 143,100 etendo.public.ad_preference 523 0 0 710,555 181,802 0 121,859 etendo.pg_catalog.pg_statistic 825 0 0 18,294,006 5,585,196 0 1,665,675 etendo.profile.last_stat_tables_srv1 900 0 0 58,871,804 54,073,800 0 8,454,600 etendo.pg_toast.pg_toast_2619 481 0 0 1,209,132 279,380 0 349,687 etendo.profile.last_stat_indexes_srv1 900 0 0 92,313,009 84,343,560 0 10,420,200 etendo.profile.last_stat_user_functions_srv1 900 0 0 9,598,032 8,190,000 0 801,900 etendo.profile.tables_list 900 0 0 2,459,340 1,599,780 0 130,500 etendo.profile.last_stat_activity_count_srv1 900 0 0 116,100 116,100 0 3,240 etendo.profile.funcs_list 900 0 0 705,900 437,280 0 46,800 etendo.profile.last_stat_io 900 0 0 214,200 201,600 0 14,400 etendo.profile.last_stat_database_srv1 660 0 0 50,160 47,520 0 5,280 etendo.public.ad_session 659 0 0 1,980,707 1,043,177 0 106,099 etendo.profile.last_extension_versions 900 0 0 122,400 115,200 0 5,400 etendo.profile.last_stat_slru 780 0 0 70,200 66,300 0 3,120 etendo.profile.stmt_list 900 0 0 1,541,700 669,540 0 212,400 etendo.profile.last_stat_statements_srv1 900 0 0 20,619,575 18,208,980 0 2,649,600 Total 15,360 7 130 210,632,387 176,087,706 0 25,176,656 Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Pages removed per tables
NO DATASET
Table Number of vacuums Index scans Tuples removed Pages removed etendo.profile.indexes_list 900 0 0 0 etendo.profile.sample_stat_user_func_total 1 1 6 0 etendo.public.ad_process_request 900 0 0 0 etendo.public.ad_preference 523 0 0 0 etendo.pg_catalog.pg_statistic 825 0 0 0 etendo.profile.last_stat_tables_srv1 900 0 0 0 etendo.pg_toast.pg_toast_407112 1 1 42 0 etendo.pg_toast.pg_toast_2619 481 0 0 0 etendo.profile.last_stat_indexes_srv1 900 0 0 0 etendo.profile.last_stat_user_functions_srv1 900 0 0 0 etendo.profile.tables_list 900 0 0 0 etendo.profile.sample_stat_tablespaces 1 1 70 0 etendo.profile.last_stat_activity_count_srv1 900 0 0 0 etendo.profile.funcs_list 900 0 0 0 etendo.profile.last_stat_io 900 0 0 0 etendo.profile.last_stat_database_srv1 660 0 0 0 etendo.public.ad_session 659 0 0 0 etendo.profile.last_extension_versions 900 0 0 0 etendo.profile.last_stat_slru 780 0 0 0 etendo.profile.stmt_list 900 0 0 0 etendo.public.ad_ep_instance_para 629 4 12 0 etendo.profile.last_stat_statements_srv1 900 0 0 0 Total 15,360 7 130 0 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 16 07 721 5 08 764 10 09 842 10 10 848 12 11 980 12 12 1,021 14 13 1,064 12 14 1,139 16 15 1,140 9 16 1,140 7 17 1,140 11 18 1,141 8 19 1,140 5 20 1,140 10 21 1,140 4 22 0 0 - 0.13 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 42 Total read queries
- 0 Total write queries
Queries by database
Key values
- etendo Main database
- 42 Requests
- 1m8s (etendo)
- Main time consuming database
Queries by user
Key values
- tad Main user
- 42 Requests
User Request type Count Duration tad Total 42 1m8s select 42 1m8s Duration by user
Key values
- 1m8s (tad) Main time consuming user
User Request type Count Duration tad Total 42 1m8s select 42 1m8s Queries by host
Key values
- 127.0.0.1 Main host
- 42 Requests
- 1m8s (127.0.0.1)
- Main time consuming host
Queries by application
Key values
- openbravo Main application
- 42 Requests
- 1m8s (openbravo)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-16 19:40:09 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 42 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 1s881ms select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro3_ cross join M_PriceList_Version pricingpri4_ cross join M_PriceList pricingpri8_ where productbyp0_.M_Productprice_ID = pricingpro3_.M_ProductPrice_ID and pricingpro3_.M_PriceList_Version_ID = pricingpri4_.M_PriceList_Version_ID and pricingpri4_.M_PriceList_ID = pricingpri8_.M_PriceList_ID and (upper(product1_.Value) like upper('%2%') escape '|') and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri4_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro3_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri8_.IsSOPriceList = 'Y' and pricingpri8_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value, product1_.Name, product1_.UPC, product1_.M_Product_ID limit '76';[ Date: 2026-07-16 10:48:00 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
2 1s857ms select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro3_ cross join M_PriceList_Version pricingpri4_ cross join M_PriceList pricingpri8_ where productbyp0_.M_Productprice_ID = pricingpro3_.M_ProductPrice_ID and pricingpro3_.M_PriceList_Version_ID = pricingpri4_.M_PriceList_Version_ID and pricingpri4_.M_PriceList_ID = pricingpri8_.M_PriceList_ID and (upper(product1_.Value) like upper('%20%') escape '|') and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri4_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro3_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri8_.IsSOPriceList = 'Y' and pricingpri8_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value, product1_.Name, product1_.UPC, product1_.M_Product_ID limit '76';[ Date: 2026-07-16 10:48:01 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
3 1s819ms select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value, product1_.Name, product1_.UPC, product1_.M_Product_ID limit '76';[ Date: 2026-07-16 12:01:39 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
4 1s770ms select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Characteristic_Desc, product1_.M_Product_ID limit '76';[ Date: 2026-07-16 12:08:55 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
5 1s730ms select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value desc, product1_.M_Product_ID limit '76';[ Date: 2026-07-16 12:15:03 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
6 1s723ms select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value, product1_.Name, product1_.UPC, product1_.M_Product_ID limit '76';[ Date: 2026-07-16 10:51:44 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
7 1s695ms select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value desc, product1_.M_Product_ID limit '76';[ Date: 2026-07-16 12:13:28 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
8 1s675ms select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value desc, product1_.M_Product_ID limit '76';[ Date: 2026-07-16 12:12:04 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
9 1s663ms select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value, product1_.M_Product_ID limit '76';[ Date: 2026-07-16 12:11:43 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
10 1s649ms select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value desc, product1_.M_Product_ID limit '76';[ Date: 2026-07-16 12:17:27 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
11 1s647ms select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Characteristic_Desc, product1_.M_Product_ID limit '76';[ Date: 2026-07-16 12:08:10 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
12 1s644ms select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Characteristic_Desc, product1_.M_Product_ID limit '76';[ Date: 2026-07-16 12:06:39 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
13 1s641ms select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value desc, product1_.M_Product_ID limit '76';[ Date: 2026-07-16 12:11:44 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
14 1s631ms select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value desc, product1_.M_Product_ID limit '76';[ Date: 2026-07-16 12:17:14 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
15 1s631ms select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Characteristic_Desc, product1_.M_Product_ID limit '76';[ Date: 2026-07-16 12:09:58 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
16 1s624ms select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value, product1_.Name, product1_.UPC, product1_.M_Product_ID limit '76';[ Date: 2026-07-16 10:18:24 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
17 1s614ms select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value, product1_.Name, product1_.UPC, product1_.M_Product_ID limit '76';[ Date: 2026-07-16 10:47:54 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
18 1s611ms select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value desc, product1_.M_Product_ID limit '76';[ Date: 2026-07-16 12:16:29 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
19 1s608ms select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value, product1_.Name, product1_.UPC, product1_.M_Product_ID limit '76';[ Date: 2026-07-16 12:02:52 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
20 1s605ms select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value desc, product1_.M_Product_ID limit '76';[ Date: 2026-07-16 12:14:44 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 27s353ms 17 1s506ms 1s730ms 1s609ms select productbyp0_.m_product_price_warehouse_v_id as m_produc1_575_, productbyp0_.ad_client_id as ad_clien2_575_, productbyp0_.ad_org_id as ad_org_i3_575_, productbyp0_.isactive as isactive4_575_, productbyp0_.updated as updated5_575_, productbyp0_.updatedby as updatedb6_575_, productbyp0_.created as created7_575_, productbyp0_.createdby as createdb8_575_, productbyp0_.m_product_id as m_produc9_575_, productbyp0_.m_warehouse_id as m_wareh10_575_, productbyp0_.m_productprice_id as m_produ11_575_, productbyp0_.qty_available as qty_ava12_575_, productbyp0_.qty_onhand as qty_onh13_575_, productbyp0_.qty_reserved as qty_res14_575_, productbyp0_.qty_ordered as qty_ord15_575_, productbyp0_.pricelist as priceli16_575_, productbyp0_.pricestd as pricest17_575_, productbyp0_.pricelimit as priceli18_575_, productbyp0_.orgwarehouse as orgware19_575_ from m_product_price_warehouse_v productbyp0_ left outer join m_product product1_ on productbyp0_.m_product_id = product1_.m_product_id cross join m_productprice pricingpro2_ cross join m_pricelist_version pricingpri3_ cross join m_pricelist pricingpri7_ where productbyp0_.m_productprice_id = pricingpro2_.m_productprice_id and pricingpro2_.m_pricelist_version_id = pricingpri3_.m_pricelist_version_id and pricingpri3_.m_pricelist_id = pricingpri7_.m_pricelist_id and (productbyp0_.ad_org_id in (...)) and productbyp0_.isactive = ? and ad_org_isinnaturaltree (productbyp0_.orgwarehouse, ?, ?) = ? and pricingpri3_.isactive = ? and ad_org_isinnaturaltree (pricingpro2_.ad_org_id, ?, ?) = ? and pricingpri7_.issopricelist = ? and pricingpri7_.c_currency_id = ? and (productbyp0_.ad_client_id in (...)) and productbyp0_.isactive = ? order by product1_.value desc, product1_.m_product_id limit ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 16 12 17 27s353ms 1s609ms [ User: tad - Total duration: 27s353ms - Times executed: 17 ]
[ Application: openbravo - Total duration: 27s353ms - Times executed: 17 ]
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value desc, product1_.M_Product_ID limit '76';
Date: 2026-07-16 12:15:03 Duration: 1s730ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value desc, product1_.M_Product_ID limit '76';
Date: 2026-07-16 12:13:28 Duration: 1s695ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value desc, product1_.M_Product_ID limit '76';
Date: 2026-07-16 12:12:04 Duration: 1s675ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
2 16s93ms 10 1s502ms 1s770ms 1s609ms select productbyp0_.m_product_price_warehouse_v_id as m_produc1_575_, productbyp0_.ad_client_id as ad_clien2_575_, productbyp0_.ad_org_id as ad_org_i3_575_, productbyp0_.isactive as isactive4_575_, productbyp0_.updated as updated5_575_, productbyp0_.updatedby as updatedb6_575_, productbyp0_.created as created7_575_, productbyp0_.createdby as createdb8_575_, productbyp0_.m_product_id as m_produc9_575_, productbyp0_.m_warehouse_id as m_wareh10_575_, productbyp0_.m_productprice_id as m_produ11_575_, productbyp0_.qty_available as qty_ava12_575_, productbyp0_.qty_onhand as qty_onh13_575_, productbyp0_.qty_reserved as qty_res14_575_, productbyp0_.qty_ordered as qty_ord15_575_, productbyp0_.pricelist as priceli16_575_, productbyp0_.pricestd as pricest17_575_, productbyp0_.pricelimit as priceli18_575_, productbyp0_.orgwarehouse as orgware19_575_ from m_product_price_warehouse_v productbyp0_ left outer join m_product product1_ on productbyp0_.m_product_id = product1_.m_product_id cross join m_productprice pricingpro2_ cross join m_pricelist_version pricingpri3_ cross join m_pricelist pricingpri7_ where productbyp0_.m_productprice_id = pricingpro2_.m_productprice_id and pricingpro2_.m_pricelist_version_id = pricingpri3_.m_pricelist_version_id and pricingpri3_.m_pricelist_id = pricingpri7_.m_pricelist_id and (productbyp0_.ad_org_id in (...)) and productbyp0_.isactive = ? and ad_org_isinnaturaltree (productbyp0_.orgwarehouse, ?, ?) = ? and pricingpri3_.isactive = ? and ad_org_isinnaturaltree (pricingpro2_.ad_org_id, ?, ?) = ? and pricingpri7_.issopricelist = ? and pricingpri7_.c_currency_id = ? and (productbyp0_.ad_client_id in (...)) and productbyp0_.isactive = ? order by product1_.characteristic_desc, product1_.m_product_id limit ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 16 12 10 16s93ms 1s609ms [ User: tad - Total duration: 16s93ms - Times executed: 10 ]
[ Application: openbravo - Total duration: 16s93ms - Times executed: 10 ]
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Characteristic_Desc, product1_.M_Product_ID limit '76';
Date: 2026-07-16 12:08:55 Duration: 1s770ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Characteristic_Desc, product1_.M_Product_ID limit '76';
Date: 2026-07-16 12:08:10 Duration: 1s647ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Characteristic_Desc, product1_.M_Product_ID limit '76';
Date: 2026-07-16 12:06:39 Duration: 1s644ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
3 14s720ms 9 1s559ms 1s819ms 1s635ms select productbyp0_.m_product_price_warehouse_v_id as m_produc1_575_, productbyp0_.ad_client_id as ad_clien2_575_, productbyp0_.ad_org_id as ad_org_i3_575_, productbyp0_.isactive as isactive4_575_, productbyp0_.updated as updated5_575_, productbyp0_.updatedby as updatedb6_575_, productbyp0_.created as created7_575_, productbyp0_.createdby as createdb8_575_, productbyp0_.m_product_id as m_produc9_575_, productbyp0_.m_warehouse_id as m_wareh10_575_, productbyp0_.m_productprice_id as m_produ11_575_, productbyp0_.qty_available as qty_ava12_575_, productbyp0_.qty_onhand as qty_onh13_575_, productbyp0_.qty_reserved as qty_res14_575_, productbyp0_.qty_ordered as qty_ord15_575_, productbyp0_.pricelist as priceli16_575_, productbyp0_.pricestd as pricest17_575_, productbyp0_.pricelimit as priceli18_575_, productbyp0_.orgwarehouse as orgware19_575_ from m_product_price_warehouse_v productbyp0_ left outer join m_product product1_ on productbyp0_.m_product_id = product1_.m_product_id cross join m_productprice pricingpro2_ cross join m_pricelist_version pricingpri3_ cross join m_pricelist pricingpri7_ where productbyp0_.m_productprice_id = pricingpro2_.m_productprice_id and pricingpro2_.m_pricelist_version_id = pricingpri3_.m_pricelist_version_id and pricingpri3_.m_pricelist_id = pricingpri7_.m_pricelist_id and (productbyp0_.ad_org_id in (...)) and productbyp0_.isactive = ? and ad_org_isinnaturaltree (productbyp0_.orgwarehouse, ?, ?) = ? and pricingpri3_.isactive = ? and ad_org_isinnaturaltree (pricingpro2_.ad_org_id, ?, ?) = ? and pricingpri7_.issopricelist = ? and pricingpri7_.c_currency_id = ? and (productbyp0_.ad_client_id in (...)) and productbyp0_.isactive = ? order by product1_.value, product1_.name, product1_.upc, product1_.m_product_id limit ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 16 10 7 11s291ms 1s613ms 12 2 3s428ms 1s714ms [ User: tad - Total duration: 14s720ms - Times executed: 9 ]
[ Application: openbravo - Total duration: 14s720ms - Times executed: 9 ]
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value, product1_.Name, product1_.UPC, product1_.M_Product_ID limit '76';
Date: 2026-07-16 12:01:39 Duration: 1s819ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value, product1_.Name, product1_.UPC, product1_.M_Product_ID limit '76';
Date: 2026-07-16 10:51:44 Duration: 1s723ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value, product1_.Name, product1_.UPC, product1_.M_Product_ID limit '76';
Date: 2026-07-16 10:18:24 Duration: 1s624ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
4 4s798ms 3 1s531ms 1s663ms 1s599ms select productbyp0_.m_product_price_warehouse_v_id as m_produc1_575_, productbyp0_.ad_client_id as ad_clien2_575_, productbyp0_.ad_org_id as ad_org_i3_575_, productbyp0_.isactive as isactive4_575_, productbyp0_.updated as updated5_575_, productbyp0_.updatedby as updatedb6_575_, productbyp0_.created as created7_575_, productbyp0_.createdby as createdb8_575_, productbyp0_.m_product_id as m_produc9_575_, productbyp0_.m_warehouse_id as m_wareh10_575_, productbyp0_.m_productprice_id as m_produ11_575_, productbyp0_.qty_available as qty_ava12_575_, productbyp0_.qty_onhand as qty_onh13_575_, productbyp0_.qty_reserved as qty_res14_575_, productbyp0_.qty_ordered as qty_ord15_575_, productbyp0_.pricelist as priceli16_575_, productbyp0_.pricestd as pricest17_575_, productbyp0_.pricelimit as priceli18_575_, productbyp0_.orgwarehouse as orgware19_575_ from m_product_price_warehouse_v productbyp0_ left outer join m_product product1_ on productbyp0_.m_product_id = product1_.m_product_id cross join m_productprice pricingpro2_ cross join m_pricelist_version pricingpri3_ cross join m_pricelist pricingpri7_ where productbyp0_.m_productprice_id = pricingpro2_.m_productprice_id and pricingpro2_.m_pricelist_version_id = pricingpri3_.m_pricelist_version_id and pricingpri3_.m_pricelist_id = pricingpri7_.m_pricelist_id and (productbyp0_.ad_org_id in (...)) and productbyp0_.isactive = ? and ad_org_isinnaturaltree (productbyp0_.orgwarehouse, ?, ?) = ? and pricingpri3_.isactive = ? and ad_org_isinnaturaltree (pricingpro2_.ad_org_id, ?, ?) = ? and pricingpri7_.issopricelist = ? and pricingpri7_.c_currency_id = ? and (productbyp0_.ad_client_id in (...)) and productbyp0_.isactive = ? order by product1_.value, product1_.m_product_id limit ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 16 12 3 4s798ms 1s599ms [ User: tad - Total duration: 4s798ms - Times executed: 3 ]
[ Application: openbravo - Total duration: 4s798ms - Times executed: 3 ]
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value, product1_.M_Product_ID limit '76';
Date: 2026-07-16 12:11:43 Duration: 1s663ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value, product1_.M_Product_ID limit '76';
Date: 2026-07-16 12:10:58 Duration: 1s603ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value, product1_.M_Product_ID limit '76';
Date: 2026-07-16 12:11:22 Duration: 1s531ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
5 3s739ms 2 1s857ms 1s881ms 1s869ms select productbyp0_.m_product_price_warehouse_v_id as m_produc1_575_, productbyp0_.ad_client_id as ad_clien2_575_, productbyp0_.ad_org_id as ad_org_i3_575_, productbyp0_.isactive as isactive4_575_, productbyp0_.updated as updated5_575_, productbyp0_.updatedby as updatedb6_575_, productbyp0_.created as created7_575_, productbyp0_.createdby as createdb8_575_, productbyp0_.m_product_id as m_produc9_575_, productbyp0_.m_warehouse_id as m_wareh10_575_, productbyp0_.m_productprice_id as m_produ11_575_, productbyp0_.qty_available as qty_ava12_575_, productbyp0_.qty_onhand as qty_onh13_575_, productbyp0_.qty_reserved as qty_res14_575_, productbyp0_.qty_ordered as qty_ord15_575_, productbyp0_.pricelist as priceli16_575_, productbyp0_.pricestd as pricest17_575_, productbyp0_.pricelimit as priceli18_575_, productbyp0_.orgwarehouse as orgware19_575_ from m_product_price_warehouse_v productbyp0_ left outer join m_product product1_ on productbyp0_.m_product_id = product1_.m_product_id cross join m_productprice pricingpro3_ cross join m_pricelist_version pricingpri4_ cross join m_pricelist pricingpri8_ where productbyp0_.m_productprice_id = pricingpro3_.m_productprice_id and pricingpro3_.m_pricelist_version_id = pricingpri4_.m_pricelist_version_id and pricingpri4_.m_pricelist_id = pricingpri8_.m_pricelist_id and (upper(product1_.value) like upper(?) escape ?) and (productbyp0_.ad_org_id in (...)) and productbyp0_.isactive = ? and ad_org_isinnaturaltree (productbyp0_.orgwarehouse, ?, ?) = ? and pricingpri4_.isactive = ? and ad_org_isinnaturaltree (pricingpro3_.ad_org_id, ?, ?) = ? and pricingpri8_.issopricelist = ? and pricingpri8_.c_currency_id = ? and (productbyp0_.ad_client_id in (...)) and productbyp0_.isactive = ? order by product1_.value, product1_.name, product1_.upc, product1_.m_product_id limit ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 16 10 2 3s739ms 1s869ms [ User: tad - Total duration: 3s739ms - Times executed: 2 ]
[ Application: openbravo - Total duration: 3s739ms - Times executed: 2 ]
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro3_ cross join M_PriceList_Version pricingpri4_ cross join M_PriceList pricingpri8_ where productbyp0_.M_Productprice_ID = pricingpro3_.M_ProductPrice_ID and pricingpro3_.M_PriceList_Version_ID = pricingpri4_.M_PriceList_Version_ID and pricingpri4_.M_PriceList_ID = pricingpri8_.M_PriceList_ID and (upper(product1_.Value) like upper('%2%') escape '|') and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri4_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro3_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri8_.IsSOPriceList = 'Y' and pricingpri8_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value, product1_.Name, product1_.UPC, product1_.M_Product_ID limit '76';
Date: 2026-07-16 10:48:00 Duration: 1s881ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro3_ cross join M_PriceList_Version pricingpri4_ cross join M_PriceList pricingpri8_ where productbyp0_.M_Productprice_ID = pricingpro3_.M_ProductPrice_ID and pricingpro3_.M_PriceList_Version_ID = pricingpri4_.M_PriceList_Version_ID and pricingpri4_.M_PriceList_ID = pricingpri8_.M_PriceList_ID and (upper(product1_.Value) like upper('%20%') escape '|') and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri4_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro3_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri8_.IsSOPriceList = 'Y' and pricingpri8_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value, product1_.Name, product1_.UPC, product1_.M_Product_ID limit '76';
Date: 2026-07-16 10:48:01 Duration: 1s857ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
6 1s576ms 1 1s576ms 1s576ms 1s576ms select productbyp0_.m_product_price_warehouse_v_id as m_produc1_575_, productbyp0_.ad_client_id as ad_clien2_575_, productbyp0_.ad_org_id as ad_org_i3_575_, productbyp0_.isactive as isactive4_575_, productbyp0_.updated as updated5_575_, productbyp0_.updatedby as updatedb6_575_, productbyp0_.created as created7_575_, productbyp0_.createdby as createdb8_575_, productbyp0_.m_product_id as m_produc9_575_, productbyp0_.m_warehouse_id as m_wareh10_575_, productbyp0_.m_productprice_id as m_produ11_575_, productbyp0_.qty_available as qty_ava12_575_, productbyp0_.qty_onhand as qty_onh13_575_, productbyp0_.qty_reserved as qty_res14_575_, productbyp0_.qty_ordered as qty_ord15_575_, productbyp0_.pricelist as priceli16_575_, productbyp0_.pricestd as pricest17_575_, productbyp0_.pricelimit as priceli18_575_, productbyp0_.orgwarehouse as orgware19_575_ from m_product_price_warehouse_v productbyp0_ left outer join m_product product1_ on productbyp0_.m_product_id = product1_.m_product_id cross join m_productprice pricingpro3_ cross join m_pricelist_version pricingpri4_ cross join m_pricelist pricingpri8_ where productbyp0_.m_productprice_id = pricingpro3_.m_productprice_id and pricingpro3_.m_pricelist_version_id = pricingpri4_.m_pricelist_version_id and pricingpri4_.m_pricelist_id = pricingpri8_.m_pricelist_id and (upper(product1_.value) like upper(?) escape ?) and (productbyp0_.ad_org_id in (...)) and productbyp0_.isactive = ? and ad_org_isinnaturaltree (productbyp0_.orgwarehouse, ?, ?) = ? and pricingpri4_.isactive = ? and ad_org_isinnaturaltree (pricingpro3_.ad_org_id, ?, ?) = ? and pricingpri8_.issopricelist = ? and pricingpri8_.c_currency_id = ? and (productbyp0_.ad_client_id in (...)) and productbyp0_.isactive = ? order by product1_.value desc, product1_.m_product_id limit ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 16 12 1 1s576ms 1s576ms [ User: tad - Total duration: 1s576ms - Times executed: 1 ]
[ Application: openbravo - Total duration: 1s576ms - Times executed: 1 ]
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro3_ cross join M_PriceList_Version pricingpri4_ cross join M_PriceList pricingpri8_ where productbyp0_.M_Productprice_ID = pricingpro3_.M_ProductPrice_ID and pricingpro3_.M_PriceList_Version_ID = pricingpri4_.M_PriceList_Version_ID and pricingpri4_.M_PriceList_ID = pricingpri8_.M_PriceList_ID and (upper(product1_.Value) like upper('%v%') escape '|') and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri4_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro3_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri8_.IsSOPriceList = 'Y' and pricingpri8_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value desc, product1_.M_Product_ID limit '76';
Date: 2026-07-16 12:15:27 Duration: 1s576ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 17 27s353ms 1s506ms 1s730ms 1s609ms select productbyp0_.m_product_price_warehouse_v_id as m_produc1_575_, productbyp0_.ad_client_id as ad_clien2_575_, productbyp0_.ad_org_id as ad_org_i3_575_, productbyp0_.isactive as isactive4_575_, productbyp0_.updated as updated5_575_, productbyp0_.updatedby as updatedb6_575_, productbyp0_.created as created7_575_, productbyp0_.createdby as createdb8_575_, productbyp0_.m_product_id as m_produc9_575_, productbyp0_.m_warehouse_id as m_wareh10_575_, productbyp0_.m_productprice_id as m_produ11_575_, productbyp0_.qty_available as qty_ava12_575_, productbyp0_.qty_onhand as qty_onh13_575_, productbyp0_.qty_reserved as qty_res14_575_, productbyp0_.qty_ordered as qty_ord15_575_, productbyp0_.pricelist as priceli16_575_, productbyp0_.pricestd as pricest17_575_, productbyp0_.pricelimit as priceli18_575_, productbyp0_.orgwarehouse as orgware19_575_ from m_product_price_warehouse_v productbyp0_ left outer join m_product product1_ on productbyp0_.m_product_id = product1_.m_product_id cross join m_productprice pricingpro2_ cross join m_pricelist_version pricingpri3_ cross join m_pricelist pricingpri7_ where productbyp0_.m_productprice_id = pricingpro2_.m_productprice_id and pricingpro2_.m_pricelist_version_id = pricingpri3_.m_pricelist_version_id and pricingpri3_.m_pricelist_id = pricingpri7_.m_pricelist_id and (productbyp0_.ad_org_id in (...)) and productbyp0_.isactive = ? and ad_org_isinnaturaltree (productbyp0_.orgwarehouse, ?, ?) = ? and pricingpri3_.isactive = ? and ad_org_isinnaturaltree (pricingpro2_.ad_org_id, ?, ?) = ? and pricingpri7_.issopricelist = ? and pricingpri7_.c_currency_id = ? and (productbyp0_.ad_client_id in (...)) and productbyp0_.isactive = ? order by product1_.value desc, product1_.m_product_id limit ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 16 12 17 27s353ms 1s609ms [ User: tad - Total duration: 27s353ms - Times executed: 17 ]
[ Application: openbravo - Total duration: 27s353ms - Times executed: 17 ]
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value desc, product1_.M_Product_ID limit '76';
Date: 2026-07-16 12:15:03 Duration: 1s730ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value desc, product1_.M_Product_ID limit '76';
Date: 2026-07-16 12:13:28 Duration: 1s695ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value desc, product1_.M_Product_ID limit '76';
Date: 2026-07-16 12:12:04 Duration: 1s675ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
2 10 16s93ms 1s502ms 1s770ms 1s609ms select productbyp0_.m_product_price_warehouse_v_id as m_produc1_575_, productbyp0_.ad_client_id as ad_clien2_575_, productbyp0_.ad_org_id as ad_org_i3_575_, productbyp0_.isactive as isactive4_575_, productbyp0_.updated as updated5_575_, productbyp0_.updatedby as updatedb6_575_, productbyp0_.created as created7_575_, productbyp0_.createdby as createdb8_575_, productbyp0_.m_product_id as m_produc9_575_, productbyp0_.m_warehouse_id as m_wareh10_575_, productbyp0_.m_productprice_id as m_produ11_575_, productbyp0_.qty_available as qty_ava12_575_, productbyp0_.qty_onhand as qty_onh13_575_, productbyp0_.qty_reserved as qty_res14_575_, productbyp0_.qty_ordered as qty_ord15_575_, productbyp0_.pricelist as priceli16_575_, productbyp0_.pricestd as pricest17_575_, productbyp0_.pricelimit as priceli18_575_, productbyp0_.orgwarehouse as orgware19_575_ from m_product_price_warehouse_v productbyp0_ left outer join m_product product1_ on productbyp0_.m_product_id = product1_.m_product_id cross join m_productprice pricingpro2_ cross join m_pricelist_version pricingpri3_ cross join m_pricelist pricingpri7_ where productbyp0_.m_productprice_id = pricingpro2_.m_productprice_id and pricingpro2_.m_pricelist_version_id = pricingpri3_.m_pricelist_version_id and pricingpri3_.m_pricelist_id = pricingpri7_.m_pricelist_id and (productbyp0_.ad_org_id in (...)) and productbyp0_.isactive = ? and ad_org_isinnaturaltree (productbyp0_.orgwarehouse, ?, ?) = ? and pricingpri3_.isactive = ? and ad_org_isinnaturaltree (pricingpro2_.ad_org_id, ?, ?) = ? and pricingpri7_.issopricelist = ? and pricingpri7_.c_currency_id = ? and (productbyp0_.ad_client_id in (...)) and productbyp0_.isactive = ? order by product1_.characteristic_desc, product1_.m_product_id limit ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 16 12 10 16s93ms 1s609ms [ User: tad - Total duration: 16s93ms - Times executed: 10 ]
[ Application: openbravo - Total duration: 16s93ms - Times executed: 10 ]
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Characteristic_Desc, product1_.M_Product_ID limit '76';
Date: 2026-07-16 12:08:55 Duration: 1s770ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Characteristic_Desc, product1_.M_Product_ID limit '76';
Date: 2026-07-16 12:08:10 Duration: 1s647ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Characteristic_Desc, product1_.M_Product_ID limit '76';
Date: 2026-07-16 12:06:39 Duration: 1s644ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
3 9 14s720ms 1s559ms 1s819ms 1s635ms select productbyp0_.m_product_price_warehouse_v_id as m_produc1_575_, productbyp0_.ad_client_id as ad_clien2_575_, productbyp0_.ad_org_id as ad_org_i3_575_, productbyp0_.isactive as isactive4_575_, productbyp0_.updated as updated5_575_, productbyp0_.updatedby as updatedb6_575_, productbyp0_.created as created7_575_, productbyp0_.createdby as createdb8_575_, productbyp0_.m_product_id as m_produc9_575_, productbyp0_.m_warehouse_id as m_wareh10_575_, productbyp0_.m_productprice_id as m_produ11_575_, productbyp0_.qty_available as qty_ava12_575_, productbyp0_.qty_onhand as qty_onh13_575_, productbyp0_.qty_reserved as qty_res14_575_, productbyp0_.qty_ordered as qty_ord15_575_, productbyp0_.pricelist as priceli16_575_, productbyp0_.pricestd as pricest17_575_, productbyp0_.pricelimit as priceli18_575_, productbyp0_.orgwarehouse as orgware19_575_ from m_product_price_warehouse_v productbyp0_ left outer join m_product product1_ on productbyp0_.m_product_id = product1_.m_product_id cross join m_productprice pricingpro2_ cross join m_pricelist_version pricingpri3_ cross join m_pricelist pricingpri7_ where productbyp0_.m_productprice_id = pricingpro2_.m_productprice_id and pricingpro2_.m_pricelist_version_id = pricingpri3_.m_pricelist_version_id and pricingpri3_.m_pricelist_id = pricingpri7_.m_pricelist_id and (productbyp0_.ad_org_id in (...)) and productbyp0_.isactive = ? and ad_org_isinnaturaltree (productbyp0_.orgwarehouse, ?, ?) = ? and pricingpri3_.isactive = ? and ad_org_isinnaturaltree (pricingpro2_.ad_org_id, ?, ?) = ? and pricingpri7_.issopricelist = ? and pricingpri7_.c_currency_id = ? and (productbyp0_.ad_client_id in (...)) and productbyp0_.isactive = ? order by product1_.value, product1_.name, product1_.upc, product1_.m_product_id limit ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 16 10 7 11s291ms 1s613ms 12 2 3s428ms 1s714ms [ User: tad - Total duration: 14s720ms - Times executed: 9 ]
[ Application: openbravo - Total duration: 14s720ms - Times executed: 9 ]
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value, product1_.Name, product1_.UPC, product1_.M_Product_ID limit '76';
Date: 2026-07-16 12:01:39 Duration: 1s819ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value, product1_.Name, product1_.UPC, product1_.M_Product_ID limit '76';
Date: 2026-07-16 10:51:44 Duration: 1s723ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value, product1_.Name, product1_.UPC, product1_.M_Product_ID limit '76';
Date: 2026-07-16 10:18:24 Duration: 1s624ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
4 3 4s798ms 1s531ms 1s663ms 1s599ms select productbyp0_.m_product_price_warehouse_v_id as m_produc1_575_, productbyp0_.ad_client_id as ad_clien2_575_, productbyp0_.ad_org_id as ad_org_i3_575_, productbyp0_.isactive as isactive4_575_, productbyp0_.updated as updated5_575_, productbyp0_.updatedby as updatedb6_575_, productbyp0_.created as created7_575_, productbyp0_.createdby as createdb8_575_, productbyp0_.m_product_id as m_produc9_575_, productbyp0_.m_warehouse_id as m_wareh10_575_, productbyp0_.m_productprice_id as m_produ11_575_, productbyp0_.qty_available as qty_ava12_575_, productbyp0_.qty_onhand as qty_onh13_575_, productbyp0_.qty_reserved as qty_res14_575_, productbyp0_.qty_ordered as qty_ord15_575_, productbyp0_.pricelist as priceli16_575_, productbyp0_.pricestd as pricest17_575_, productbyp0_.pricelimit as priceli18_575_, productbyp0_.orgwarehouse as orgware19_575_ from m_product_price_warehouse_v productbyp0_ left outer join m_product product1_ on productbyp0_.m_product_id = product1_.m_product_id cross join m_productprice pricingpro2_ cross join m_pricelist_version pricingpri3_ cross join m_pricelist pricingpri7_ where productbyp0_.m_productprice_id = pricingpro2_.m_productprice_id and pricingpro2_.m_pricelist_version_id = pricingpri3_.m_pricelist_version_id and pricingpri3_.m_pricelist_id = pricingpri7_.m_pricelist_id and (productbyp0_.ad_org_id in (...)) and productbyp0_.isactive = ? and ad_org_isinnaturaltree (productbyp0_.orgwarehouse, ?, ?) = ? and pricingpri3_.isactive = ? and ad_org_isinnaturaltree (pricingpro2_.ad_org_id, ?, ?) = ? and pricingpri7_.issopricelist = ? and pricingpri7_.c_currency_id = ? and (productbyp0_.ad_client_id in (...)) and productbyp0_.isactive = ? order by product1_.value, product1_.m_product_id limit ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 16 12 3 4s798ms 1s599ms [ User: tad - Total duration: 4s798ms - Times executed: 3 ]
[ Application: openbravo - Total duration: 4s798ms - Times executed: 3 ]
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value, product1_.M_Product_ID limit '76';
Date: 2026-07-16 12:11:43 Duration: 1s663ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value, product1_.M_Product_ID limit '76';
Date: 2026-07-16 12:10:58 Duration: 1s603ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value, product1_.M_Product_ID limit '76';
Date: 2026-07-16 12:11:22 Duration: 1s531ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
5 2 3s739ms 1s857ms 1s881ms 1s869ms select productbyp0_.m_product_price_warehouse_v_id as m_produc1_575_, productbyp0_.ad_client_id as ad_clien2_575_, productbyp0_.ad_org_id as ad_org_i3_575_, productbyp0_.isactive as isactive4_575_, productbyp0_.updated as updated5_575_, productbyp0_.updatedby as updatedb6_575_, productbyp0_.created as created7_575_, productbyp0_.createdby as createdb8_575_, productbyp0_.m_product_id as m_produc9_575_, productbyp0_.m_warehouse_id as m_wareh10_575_, productbyp0_.m_productprice_id as m_produ11_575_, productbyp0_.qty_available as qty_ava12_575_, productbyp0_.qty_onhand as qty_onh13_575_, productbyp0_.qty_reserved as qty_res14_575_, productbyp0_.qty_ordered as qty_ord15_575_, productbyp0_.pricelist as priceli16_575_, productbyp0_.pricestd as pricest17_575_, productbyp0_.pricelimit as priceli18_575_, productbyp0_.orgwarehouse as orgware19_575_ from m_product_price_warehouse_v productbyp0_ left outer join m_product product1_ on productbyp0_.m_product_id = product1_.m_product_id cross join m_productprice pricingpro3_ cross join m_pricelist_version pricingpri4_ cross join m_pricelist pricingpri8_ where productbyp0_.m_productprice_id = pricingpro3_.m_productprice_id and pricingpro3_.m_pricelist_version_id = pricingpri4_.m_pricelist_version_id and pricingpri4_.m_pricelist_id = pricingpri8_.m_pricelist_id and (upper(product1_.value) like upper(?) escape ?) and (productbyp0_.ad_org_id in (...)) and productbyp0_.isactive = ? and ad_org_isinnaturaltree (productbyp0_.orgwarehouse, ?, ?) = ? and pricingpri4_.isactive = ? and ad_org_isinnaturaltree (pricingpro3_.ad_org_id, ?, ?) = ? and pricingpri8_.issopricelist = ? and pricingpri8_.c_currency_id = ? and (productbyp0_.ad_client_id in (...)) and productbyp0_.isactive = ? order by product1_.value, product1_.name, product1_.upc, product1_.m_product_id limit ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 16 10 2 3s739ms 1s869ms [ User: tad - Total duration: 3s739ms - Times executed: 2 ]
[ Application: openbravo - Total duration: 3s739ms - Times executed: 2 ]
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro3_ cross join M_PriceList_Version pricingpri4_ cross join M_PriceList pricingpri8_ where productbyp0_.M_Productprice_ID = pricingpro3_.M_ProductPrice_ID and pricingpro3_.M_PriceList_Version_ID = pricingpri4_.M_PriceList_Version_ID and pricingpri4_.M_PriceList_ID = pricingpri8_.M_PriceList_ID and (upper(product1_.Value) like upper('%2%') escape '|') and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri4_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro3_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri8_.IsSOPriceList = 'Y' and pricingpri8_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value, product1_.Name, product1_.UPC, product1_.M_Product_ID limit '76';
Date: 2026-07-16 10:48:00 Duration: 1s881ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro3_ cross join M_PriceList_Version pricingpri4_ cross join M_PriceList pricingpri8_ where productbyp0_.M_Productprice_ID = pricingpro3_.M_ProductPrice_ID and pricingpro3_.M_PriceList_Version_ID = pricingpri4_.M_PriceList_Version_ID and pricingpri4_.M_PriceList_ID = pricingpri8_.M_PriceList_ID and (upper(product1_.Value) like upper('%20%') escape '|') and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri4_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro3_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri8_.IsSOPriceList = 'Y' and pricingpri8_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value, product1_.Name, product1_.UPC, product1_.M_Product_ID limit '76';
Date: 2026-07-16 10:48:01 Duration: 1s857ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
6 1 1s576ms 1s576ms 1s576ms 1s576ms select productbyp0_.m_product_price_warehouse_v_id as m_produc1_575_, productbyp0_.ad_client_id as ad_clien2_575_, productbyp0_.ad_org_id as ad_org_i3_575_, productbyp0_.isactive as isactive4_575_, productbyp0_.updated as updated5_575_, productbyp0_.updatedby as updatedb6_575_, productbyp0_.created as created7_575_, productbyp0_.createdby as createdb8_575_, productbyp0_.m_product_id as m_produc9_575_, productbyp0_.m_warehouse_id as m_wareh10_575_, productbyp0_.m_productprice_id as m_produ11_575_, productbyp0_.qty_available as qty_ava12_575_, productbyp0_.qty_onhand as qty_onh13_575_, productbyp0_.qty_reserved as qty_res14_575_, productbyp0_.qty_ordered as qty_ord15_575_, productbyp0_.pricelist as priceli16_575_, productbyp0_.pricestd as pricest17_575_, productbyp0_.pricelimit as priceli18_575_, productbyp0_.orgwarehouse as orgware19_575_ from m_product_price_warehouse_v productbyp0_ left outer join m_product product1_ on productbyp0_.m_product_id = product1_.m_product_id cross join m_productprice pricingpro3_ cross join m_pricelist_version pricingpri4_ cross join m_pricelist pricingpri8_ where productbyp0_.m_productprice_id = pricingpro3_.m_productprice_id and pricingpro3_.m_pricelist_version_id = pricingpri4_.m_pricelist_version_id and pricingpri4_.m_pricelist_id = pricingpri8_.m_pricelist_id and (upper(product1_.value) like upper(?) escape ?) and (productbyp0_.ad_org_id in (...)) and productbyp0_.isactive = ? and ad_org_isinnaturaltree (productbyp0_.orgwarehouse, ?, ?) = ? and pricingpri4_.isactive = ? and ad_org_isinnaturaltree (pricingpro3_.ad_org_id, ?, ?) = ? and pricingpri8_.issopricelist = ? and pricingpri8_.c_currency_id = ? and (productbyp0_.ad_client_id in (...)) and productbyp0_.isactive = ? order by product1_.value desc, product1_.m_product_id limit ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 16 12 1 1s576ms 1s576ms [ User: tad - Total duration: 1s576ms - Times executed: 1 ]
[ Application: openbravo - Total duration: 1s576ms - Times executed: 1 ]
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro3_ cross join M_PriceList_Version pricingpri4_ cross join M_PriceList pricingpri8_ where productbyp0_.M_Productprice_ID = pricingpro3_.M_ProductPrice_ID and pricingpro3_.M_PriceList_Version_ID = pricingpri4_.M_PriceList_Version_ID and pricingpri4_.M_PriceList_ID = pricingpri8_.M_PriceList_ID and (upper(product1_.Value) like upper('%v%') escape '|') and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri4_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro3_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri8_.IsSOPriceList = 'Y' and pricingpri8_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value desc, product1_.M_Product_ID limit '76';
Date: 2026-07-16 12:15:27 Duration: 1s576ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 1s857ms 1s881ms 1s869ms 2 3s739ms select productbyp0_.m_product_price_warehouse_v_id as m_produc1_575_, productbyp0_.ad_client_id as ad_clien2_575_, productbyp0_.ad_org_id as ad_org_i3_575_, productbyp0_.isactive as isactive4_575_, productbyp0_.updated as updated5_575_, productbyp0_.updatedby as updatedb6_575_, productbyp0_.created as created7_575_, productbyp0_.createdby as createdb8_575_, productbyp0_.m_product_id as m_produc9_575_, productbyp0_.m_warehouse_id as m_wareh10_575_, productbyp0_.m_productprice_id as m_produ11_575_, productbyp0_.qty_available as qty_ava12_575_, productbyp0_.qty_onhand as qty_onh13_575_, productbyp0_.qty_reserved as qty_res14_575_, productbyp0_.qty_ordered as qty_ord15_575_, productbyp0_.pricelist as priceli16_575_, productbyp0_.pricestd as pricest17_575_, productbyp0_.pricelimit as priceli18_575_, productbyp0_.orgwarehouse as orgware19_575_ from m_product_price_warehouse_v productbyp0_ left outer join m_product product1_ on productbyp0_.m_product_id = product1_.m_product_id cross join m_productprice pricingpro3_ cross join m_pricelist_version pricingpri4_ cross join m_pricelist pricingpri8_ where productbyp0_.m_productprice_id = pricingpro3_.m_productprice_id and pricingpro3_.m_pricelist_version_id = pricingpri4_.m_pricelist_version_id and pricingpri4_.m_pricelist_id = pricingpri8_.m_pricelist_id and (upper(product1_.value) like upper(?) escape ?) and (productbyp0_.ad_org_id in (...)) and productbyp0_.isactive = ? and ad_org_isinnaturaltree (productbyp0_.orgwarehouse, ?, ?) = ? and pricingpri4_.isactive = ? and ad_org_isinnaturaltree (pricingpro3_.ad_org_id, ?, ?) = ? and pricingpri8_.issopricelist = ? and pricingpri8_.c_currency_id = ? and (productbyp0_.ad_client_id in (...)) and productbyp0_.isactive = ? order by product1_.value, product1_.name, product1_.upc, product1_.m_product_id limit ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 16 10 2 3s739ms 1s869ms [ User: tad - Total duration: 3s739ms - Times executed: 2 ]
[ Application: openbravo - Total duration: 3s739ms - Times executed: 2 ]
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro3_ cross join M_PriceList_Version pricingpri4_ cross join M_PriceList pricingpri8_ where productbyp0_.M_Productprice_ID = pricingpro3_.M_ProductPrice_ID and pricingpro3_.M_PriceList_Version_ID = pricingpri4_.M_PriceList_Version_ID and pricingpri4_.M_PriceList_ID = pricingpri8_.M_PriceList_ID and (upper(product1_.Value) like upper('%2%') escape '|') and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri4_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro3_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri8_.IsSOPriceList = 'Y' and pricingpri8_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value, product1_.Name, product1_.UPC, product1_.M_Product_ID limit '76';
Date: 2026-07-16 10:48:00 Duration: 1s881ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro3_ cross join M_PriceList_Version pricingpri4_ cross join M_PriceList pricingpri8_ where productbyp0_.M_Productprice_ID = pricingpro3_.M_ProductPrice_ID and pricingpro3_.M_PriceList_Version_ID = pricingpri4_.M_PriceList_Version_ID and pricingpri4_.M_PriceList_ID = pricingpri8_.M_PriceList_ID and (upper(product1_.Value) like upper('%20%') escape '|') and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri4_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro3_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri8_.IsSOPriceList = 'Y' and pricingpri8_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value, product1_.Name, product1_.UPC, product1_.M_Product_ID limit '76';
Date: 2026-07-16 10:48:01 Duration: 1s857ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
2 1s559ms 1s819ms 1s635ms 9 14s720ms select productbyp0_.m_product_price_warehouse_v_id as m_produc1_575_, productbyp0_.ad_client_id as ad_clien2_575_, productbyp0_.ad_org_id as ad_org_i3_575_, productbyp0_.isactive as isactive4_575_, productbyp0_.updated as updated5_575_, productbyp0_.updatedby as updatedb6_575_, productbyp0_.created as created7_575_, productbyp0_.createdby as createdb8_575_, productbyp0_.m_product_id as m_produc9_575_, productbyp0_.m_warehouse_id as m_wareh10_575_, productbyp0_.m_productprice_id as m_produ11_575_, productbyp0_.qty_available as qty_ava12_575_, productbyp0_.qty_onhand as qty_onh13_575_, productbyp0_.qty_reserved as qty_res14_575_, productbyp0_.qty_ordered as qty_ord15_575_, productbyp0_.pricelist as priceli16_575_, productbyp0_.pricestd as pricest17_575_, productbyp0_.pricelimit as priceli18_575_, productbyp0_.orgwarehouse as orgware19_575_ from m_product_price_warehouse_v productbyp0_ left outer join m_product product1_ on productbyp0_.m_product_id = product1_.m_product_id cross join m_productprice pricingpro2_ cross join m_pricelist_version pricingpri3_ cross join m_pricelist pricingpri7_ where productbyp0_.m_productprice_id = pricingpro2_.m_productprice_id and pricingpro2_.m_pricelist_version_id = pricingpri3_.m_pricelist_version_id and pricingpri3_.m_pricelist_id = pricingpri7_.m_pricelist_id and (productbyp0_.ad_org_id in (...)) and productbyp0_.isactive = ? and ad_org_isinnaturaltree (productbyp0_.orgwarehouse, ?, ?) = ? and pricingpri3_.isactive = ? and ad_org_isinnaturaltree (pricingpro2_.ad_org_id, ?, ?) = ? and pricingpri7_.issopricelist = ? and pricingpri7_.c_currency_id = ? and (productbyp0_.ad_client_id in (...)) and productbyp0_.isactive = ? order by product1_.value, product1_.name, product1_.upc, product1_.m_product_id limit ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 16 10 7 11s291ms 1s613ms 12 2 3s428ms 1s714ms [ User: tad - Total duration: 14s720ms - Times executed: 9 ]
[ Application: openbravo - Total duration: 14s720ms - Times executed: 9 ]
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value, product1_.Name, product1_.UPC, product1_.M_Product_ID limit '76';
Date: 2026-07-16 12:01:39 Duration: 1s819ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value, product1_.Name, product1_.UPC, product1_.M_Product_ID limit '76';
Date: 2026-07-16 10:51:44 Duration: 1s723ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value, product1_.Name, product1_.UPC, product1_.M_Product_ID limit '76';
Date: 2026-07-16 10:18:24 Duration: 1s624ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
3 1s502ms 1s770ms 1s609ms 10 16s93ms select productbyp0_.m_product_price_warehouse_v_id as m_produc1_575_, productbyp0_.ad_client_id as ad_clien2_575_, productbyp0_.ad_org_id as ad_org_i3_575_, productbyp0_.isactive as isactive4_575_, productbyp0_.updated as updated5_575_, productbyp0_.updatedby as updatedb6_575_, productbyp0_.created as created7_575_, productbyp0_.createdby as createdb8_575_, productbyp0_.m_product_id as m_produc9_575_, productbyp0_.m_warehouse_id as m_wareh10_575_, productbyp0_.m_productprice_id as m_produ11_575_, productbyp0_.qty_available as qty_ava12_575_, productbyp0_.qty_onhand as qty_onh13_575_, productbyp0_.qty_reserved as qty_res14_575_, productbyp0_.qty_ordered as qty_ord15_575_, productbyp0_.pricelist as priceli16_575_, productbyp0_.pricestd as pricest17_575_, productbyp0_.pricelimit as priceli18_575_, productbyp0_.orgwarehouse as orgware19_575_ from m_product_price_warehouse_v productbyp0_ left outer join m_product product1_ on productbyp0_.m_product_id = product1_.m_product_id cross join m_productprice pricingpro2_ cross join m_pricelist_version pricingpri3_ cross join m_pricelist pricingpri7_ where productbyp0_.m_productprice_id = pricingpro2_.m_productprice_id and pricingpro2_.m_pricelist_version_id = pricingpri3_.m_pricelist_version_id and pricingpri3_.m_pricelist_id = pricingpri7_.m_pricelist_id and (productbyp0_.ad_org_id in (...)) and productbyp0_.isactive = ? and ad_org_isinnaturaltree (productbyp0_.orgwarehouse, ?, ?) = ? and pricingpri3_.isactive = ? and ad_org_isinnaturaltree (pricingpro2_.ad_org_id, ?, ?) = ? and pricingpri7_.issopricelist = ? and pricingpri7_.c_currency_id = ? and (productbyp0_.ad_client_id in (...)) and productbyp0_.isactive = ? order by product1_.characteristic_desc, product1_.m_product_id limit ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 16 12 10 16s93ms 1s609ms [ User: tad - Total duration: 16s93ms - Times executed: 10 ]
[ Application: openbravo - Total duration: 16s93ms - Times executed: 10 ]
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Characteristic_Desc, product1_.M_Product_ID limit '76';
Date: 2026-07-16 12:08:55 Duration: 1s770ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Characteristic_Desc, product1_.M_Product_ID limit '76';
Date: 2026-07-16 12:08:10 Duration: 1s647ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Characteristic_Desc, product1_.M_Product_ID limit '76';
Date: 2026-07-16 12:06:39 Duration: 1s644ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
4 1s506ms 1s730ms 1s609ms 17 27s353ms select productbyp0_.m_product_price_warehouse_v_id as m_produc1_575_, productbyp0_.ad_client_id as ad_clien2_575_, productbyp0_.ad_org_id as ad_org_i3_575_, productbyp0_.isactive as isactive4_575_, productbyp0_.updated as updated5_575_, productbyp0_.updatedby as updatedb6_575_, productbyp0_.created as created7_575_, productbyp0_.createdby as createdb8_575_, productbyp0_.m_product_id as m_produc9_575_, productbyp0_.m_warehouse_id as m_wareh10_575_, productbyp0_.m_productprice_id as m_produ11_575_, productbyp0_.qty_available as qty_ava12_575_, productbyp0_.qty_onhand as qty_onh13_575_, productbyp0_.qty_reserved as qty_res14_575_, productbyp0_.qty_ordered as qty_ord15_575_, productbyp0_.pricelist as priceli16_575_, productbyp0_.pricestd as pricest17_575_, productbyp0_.pricelimit as priceli18_575_, productbyp0_.orgwarehouse as orgware19_575_ from m_product_price_warehouse_v productbyp0_ left outer join m_product product1_ on productbyp0_.m_product_id = product1_.m_product_id cross join m_productprice pricingpro2_ cross join m_pricelist_version pricingpri3_ cross join m_pricelist pricingpri7_ where productbyp0_.m_productprice_id = pricingpro2_.m_productprice_id and pricingpro2_.m_pricelist_version_id = pricingpri3_.m_pricelist_version_id and pricingpri3_.m_pricelist_id = pricingpri7_.m_pricelist_id and (productbyp0_.ad_org_id in (...)) and productbyp0_.isactive = ? and ad_org_isinnaturaltree (productbyp0_.orgwarehouse, ?, ?) = ? and pricingpri3_.isactive = ? and ad_org_isinnaturaltree (pricingpro2_.ad_org_id, ?, ?) = ? and pricingpri7_.issopricelist = ? and pricingpri7_.c_currency_id = ? and (productbyp0_.ad_client_id in (...)) and productbyp0_.isactive = ? order by product1_.value desc, product1_.m_product_id limit ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 16 12 17 27s353ms 1s609ms [ User: tad - Total duration: 27s353ms - Times executed: 17 ]
[ Application: openbravo - Total duration: 27s353ms - Times executed: 17 ]
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value desc, product1_.M_Product_ID limit '76';
Date: 2026-07-16 12:15:03 Duration: 1s730ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value desc, product1_.M_Product_ID limit '76';
Date: 2026-07-16 12:13:28 Duration: 1s695ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value desc, product1_.M_Product_ID limit '76';
Date: 2026-07-16 12:12:04 Duration: 1s675ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
5 1s531ms 1s663ms 1s599ms 3 4s798ms select productbyp0_.m_product_price_warehouse_v_id as m_produc1_575_, productbyp0_.ad_client_id as ad_clien2_575_, productbyp0_.ad_org_id as ad_org_i3_575_, productbyp0_.isactive as isactive4_575_, productbyp0_.updated as updated5_575_, productbyp0_.updatedby as updatedb6_575_, productbyp0_.created as created7_575_, productbyp0_.createdby as createdb8_575_, productbyp0_.m_product_id as m_produc9_575_, productbyp0_.m_warehouse_id as m_wareh10_575_, productbyp0_.m_productprice_id as m_produ11_575_, productbyp0_.qty_available as qty_ava12_575_, productbyp0_.qty_onhand as qty_onh13_575_, productbyp0_.qty_reserved as qty_res14_575_, productbyp0_.qty_ordered as qty_ord15_575_, productbyp0_.pricelist as priceli16_575_, productbyp0_.pricestd as pricest17_575_, productbyp0_.pricelimit as priceli18_575_, productbyp0_.orgwarehouse as orgware19_575_ from m_product_price_warehouse_v productbyp0_ left outer join m_product product1_ on productbyp0_.m_product_id = product1_.m_product_id cross join m_productprice pricingpro2_ cross join m_pricelist_version pricingpri3_ cross join m_pricelist pricingpri7_ where productbyp0_.m_productprice_id = pricingpro2_.m_productprice_id and pricingpro2_.m_pricelist_version_id = pricingpri3_.m_pricelist_version_id and pricingpri3_.m_pricelist_id = pricingpri7_.m_pricelist_id and (productbyp0_.ad_org_id in (...)) and productbyp0_.isactive = ? and ad_org_isinnaturaltree (productbyp0_.orgwarehouse, ?, ?) = ? and pricingpri3_.isactive = ? and ad_org_isinnaturaltree (pricingpro2_.ad_org_id, ?, ?) = ? and pricingpri7_.issopricelist = ? and pricingpri7_.c_currency_id = ? and (productbyp0_.ad_client_id in (...)) and productbyp0_.isactive = ? order by product1_.value, product1_.m_product_id limit ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 16 12 3 4s798ms 1s599ms [ User: tad - Total duration: 4s798ms - Times executed: 3 ]
[ Application: openbravo - Total duration: 4s798ms - Times executed: 3 ]
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value, product1_.M_Product_ID limit '76';
Date: 2026-07-16 12:11:43 Duration: 1s663ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value, product1_.M_Product_ID limit '76';
Date: 2026-07-16 12:10:58 Duration: 1s603ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro2_ cross join M_PriceList_Version pricingpri3_ cross join M_PriceList pricingpri7_ where productbyp0_.M_Productprice_ID = pricingpro2_.M_ProductPrice_ID and pricingpro2_.M_PriceList_Version_ID = pricingpri3_.M_PriceList_Version_ID and pricingpri3_.M_PriceList_ID = pricingpri7_.M_PriceList_ID and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri3_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro2_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri7_.IsSOPriceList = 'Y' and pricingpri7_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value, product1_.M_Product_ID limit '76';
Date: 2026-07-16 12:11:22 Duration: 1s531ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
6 1s576ms 1s576ms 1s576ms 1 1s576ms select productbyp0_.m_product_price_warehouse_v_id as m_produc1_575_, productbyp0_.ad_client_id as ad_clien2_575_, productbyp0_.ad_org_id as ad_org_i3_575_, productbyp0_.isactive as isactive4_575_, productbyp0_.updated as updated5_575_, productbyp0_.updatedby as updatedb6_575_, productbyp0_.created as created7_575_, productbyp0_.createdby as createdb8_575_, productbyp0_.m_product_id as m_produc9_575_, productbyp0_.m_warehouse_id as m_wareh10_575_, productbyp0_.m_productprice_id as m_produ11_575_, productbyp0_.qty_available as qty_ava12_575_, productbyp0_.qty_onhand as qty_onh13_575_, productbyp0_.qty_reserved as qty_res14_575_, productbyp0_.qty_ordered as qty_ord15_575_, productbyp0_.pricelist as priceli16_575_, productbyp0_.pricestd as pricest17_575_, productbyp0_.pricelimit as priceli18_575_, productbyp0_.orgwarehouse as orgware19_575_ from m_product_price_warehouse_v productbyp0_ left outer join m_product product1_ on productbyp0_.m_product_id = product1_.m_product_id cross join m_productprice pricingpro3_ cross join m_pricelist_version pricingpri4_ cross join m_pricelist pricingpri8_ where productbyp0_.m_productprice_id = pricingpro3_.m_productprice_id and pricingpro3_.m_pricelist_version_id = pricingpri4_.m_pricelist_version_id and pricingpri4_.m_pricelist_id = pricingpri8_.m_pricelist_id and (upper(product1_.value) like upper(?) escape ?) and (productbyp0_.ad_org_id in (...)) and productbyp0_.isactive = ? and ad_org_isinnaturaltree (productbyp0_.orgwarehouse, ?, ?) = ? and pricingpri4_.isactive = ? and ad_org_isinnaturaltree (pricingpro3_.ad_org_id, ?, ?) = ? and pricingpri8_.issopricelist = ? and pricingpri8_.c_currency_id = ? and (productbyp0_.ad_client_id in (...)) and productbyp0_.isactive = ? order by product1_.value desc, product1_.m_product_id limit ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 16 12 1 1s576ms 1s576ms [ User: tad - Total duration: 1s576ms - Times executed: 1 ]
[ Application: openbravo - Total duration: 1s576ms - Times executed: 1 ]
-
select productbyp0_.M_Product_Price_Warehouse_V_ID as m_produc1_575_, productbyp0_.AD_Client_ID as ad_clien2_575_, productbyp0_.AD_Org_ID as ad_org_i3_575_, productbyp0_.Isactive as isactive4_575_, productbyp0_.Updated as updated5_575_, productbyp0_.Updatedby as updatedb6_575_, productbyp0_.Created as created7_575_, productbyp0_.Createdby as createdb8_575_, productbyp0_.M_Product_ID as m_produc9_575_, productbyp0_.M_Warehouse_ID as m_wareh10_575_, productbyp0_.M_Productprice_ID as m_produ11_575_, productbyp0_.QTY_Available as qty_ava12_575_, productbyp0_.QTY_Onhand as qty_onh13_575_, productbyp0_.QTY_Reserved as qty_res14_575_, productbyp0_.QTY_Ordered as qty_ord15_575_, productbyp0_.Pricelist as priceli16_575_, productbyp0_.Pricestd as pricest17_575_, productbyp0_.Pricelimit as priceli18_575_, productbyp0_.Orgwarehouse as orgware19_575_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID = product1_.M_Product_ID cross join M_ProductPrice pricingpro3_ cross join M_PriceList_Version pricingpri4_ cross join M_PriceList pricingpri8_ where productbyp0_.M_Productprice_ID = pricingpro3_.M_ProductPrice_ID and pricingpro3_.M_PriceList_Version_ID = pricingpri4_.M_PriceList_Version_ID and pricingpri4_.M_PriceList_ID = pricingpri8_.M_PriceList_ID and (upper(product1_.Value) like upper('%v%') escape '|') and (productbyp0_.AD_Org_ID in ('0', 'C31A56FD90D54926B0E5397DE5EADB4D', 'ECAB3274F68D4536A47B5C33D7A1298E', '74261DC0F13F44FBB0C4975CC2C0420C')) and productbyp0_.Isactive = 'Y' and AD_ORG_ISINNATURALTREE (productbyp0_.Orgwarehouse, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri4_.IsActive = 'Y' and AD_ORG_ISINNATURALTREE (pricingpro3_.AD_Org_ID, 'C31A56FD90D54926B0E5397DE5EADB4D', 'C254419D2D8D45D08CFBE3B125A44199') = 'Y' and pricingpri8_.IsSOPriceList = 'Y' and pricingpri8_.C_Currency_ID = '102' and (productbyp0_.AD_Client_ID in ('C254419D2D8D45D08CFBE3B125A44199', '0')) and productbyp0_.Isactive = 'Y' order by product1_.Value desc, product1_.M_Product_ID limit '76';
Date: 2026-07-16 12:15:27 Duration: 1s576ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo Bind query: yes
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 39,012 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 624 FATAL entries
- 8 ERROR entries
- 0 WARNING entries
- 0 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 592 Max number of times the same event was reported
- 632 Total events found
Rank Times reported Error 1 592 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", no encryption
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 16 07 51 08 39 09 37 10 38 11 36 12 37 13 40 14 37 15 54 16 40 17 34 18 36 19 37 20 38 21 38 - FATAL: no pg_hba.conf entry for host "186.236.254.56", user "test", database "postgres", no encryption
- FATAL: no pg_hba.conf entry for host "159.65.148.75", user "user", database "postgres", no encryption
- FATAL: no pg_hba.conf entry for host "186.236.254.56", user "test", database "postgres", no encryption
Date: 2026-07-16 07:01:39 Database: postgres Application: [unknown] User: test Remote: 186.236.254.56
Date: 2026-07-16 07:02:27 Database: postgres Application: [unknown] User: user Remote: 159.65.148.75
Date: 2026-07-16 07:04:59 Database: postgres Application: [unknown] User: test Remote: 186.236.254.56
2 17 FATAL: no pg_hba.conf entry for host "...", user "...", database "...", SSL encryption
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 16 13 15 14 1 15 1 - FATAL: no pg_hba.conf entry for host "213.209.159.66", user "postgres", database "postgres", SSL encryption
- FATAL: no pg_hba.conf entry for host "213.209.159.66", user "postgres", database "postgres", SSL encryption
- FATAL: no pg_hba.conf entry for host "213.209.159.66", user "postgres", database "postgres", SSL encryption
Date: 2026-07-16 13:09:58 Database: postgres Application: [unknown] User: postgres Remote: 213.209.159.66
Date: 2026-07-16 13:11:32 Database: postgres Application: [unknown] User: postgres Remote: 213.209.159.66
Date: 2026-07-16 13:13:07 Database: postgres Application: [unknown] User: postgres Remote: 213.209.159.66
3 4 FATAL: no PostgreSQL user name specified in startup packet
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 16 12 1 14 1 17 1 19 1 - FATAL: no PostgreSQL user name specified in startup packet
- FATAL: no PostgreSQL user name specified in startup packet
- FATAL: no PostgreSQL user name specified in startup packet
Date: 2026-07-16 12:57:49 Database: [unknown] Application: [unknown] User: [unknown] Remote: 213.209.159.66
Date: 2026-07-16 14:32:11 Database: [unknown] Application: [unknown] User: [unknown] Remote: 66.132.172.201
Date: 2026-07-16 17:06:13 Database: [unknown] Application: [unknown] User: [unknown] Remote: 65.49.1.202
4 4 ERROR: @20501@
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 16 11 4 - ERROR: @20501@
- ERROR: @20501@
- ERROR: @20501@
Context: PL/pgSQL function m_lc_matched_chk_trg() line 61 at RAISE
Statement: delete from M_LC_Matched where M_Lc_Matched_ID=$1Date: 2026-07-16 11:47:35 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
Context: PL/pgSQL function m_lc_matched_chk_trg() line 61 at RAISE
Statement: delete from M_LC_Matched where M_Lc_Matched_ID=$1Date: 2026-07-16 11:47:42 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
Context: PL/pgSQL function m_lc_matched_chk_trg() line 61 at RAISE
Statement: delete from M_LC_Matched where M_Lc_Matched_ID=$1Date: 2026-07-16 11:48:02 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
5 4 FATAL: unsupported frontend protocol 0.0: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #5
Day Hour Count Jul 16 12 1 14 1 17 1 19 1 - FATAL: unsupported frontend protocol 0.0: server supports 3.0 to 3.0
- FATAL: unsupported frontend protocol 0.0: server supports 3.0 to 3.0
- FATAL: unsupported frontend protocol 0.0: server supports 3.0 to 3.0
Date: 2026-07-16 12:57:49 Database: [unknown] Application: [unknown] User: [unknown] Remote: 213.209.159.66
Date: 2026-07-16 14:32:10 Database: [unknown] Application: [unknown] User: [unknown] Remote: 66.132.172.201
Date: 2026-07-16 17:06:13 Database: [unknown] Application: [unknown] User: [unknown] Remote: 65.49.1.202
6 4 FATAL: unsupported frontend protocol 255.255: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #6
Day Hour Count Jul 16 12 1 14 1 17 1 19 1 - FATAL: unsupported frontend protocol 255.255: server supports 3.0 to 3.0
- FATAL: unsupported frontend protocol 255.255: server supports 3.0 to 3.0
- FATAL: unsupported frontend protocol 255.255: server supports 3.0 to 3.0
Date: 2026-07-16 12:57:49 Database: [unknown] Application: [unknown] User: [unknown] Remote: 213.209.159.66
Date: 2026-07-16 14:32:10 Database: [unknown] Application: [unknown] User: [unknown] Remote: 66.132.172.201
Date: 2026-07-16 17:06:13 Database: [unknown] Application: [unknown] User: [unknown] Remote: 65.49.1.202
7 3 ERROR: update or delete on table "..." violates foreign key constraint "..." on table "..."
Times Reported Most Frequent Error / Event #7
Day Hour Count Jul 16 13 3 - ERROR: update or delete on table "c_invoiceline" violates foreign key constraint "m_lc_cost_invoiceline" on table "m_lc_cost"
- ERROR: update or delete on table "c_elementvalue" violates foreign key constraint "c_elementvalue_operand_account" on table "c_elementvalue_operand"
- ERROR: update or delete on table "c_elementvalue" violates foreign key constraint "c_elementvalue_operand_account" on table "c_elementvalue_operand"
Detail: Key (c_invoiceline_id)=(4B265C01D59C46AD8639321D2D6503DD) is still referenced from table "m_lc_cost".
Statement: delete from C_InvoiceLine where C_InvoiceLine_ID=$1Date: 2026-07-16 13:23:05 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
Detail: Key (c_elementvalue_id)=(9C3E17A0E47047F79B2D6DC52C49525E) is still referenced from table "c_elementvalue_operand".
Statement: delete from C_ElementValue where C_ElementValue_ID=$1Date: 2026-07-16 13:24:34 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
Detail: Key (c_elementvalue_id)=(9C3E17A0E47047F79B2D6DC52C49525E) is still referenced from table "c_elementvalue_operand".
Statement: delete from C_ElementValue where C_ElementValue_ID=$1Date: 2026-07-16 13:25:23 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1
8 2 FATAL: unsupported frontend protocol 2.0: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #8
Day Hour Count Jul 16 12 2 - FATAL: unsupported frontend protocol 2.0: server supports 3.0 to 3.0
- FATAL: unsupported frontend protocol 2.0: server supports 3.0 to 3.0
Date: 2026-07-16 12:47:01 Database: [unknown] Application: [unknown] User: [unknown] Remote: 156.225.1.43
Date: 2026-07-16 12:47:02 Database: [unknown] Application: [unknown] User: [unknown] Remote: 156.225.1.43
9 1 FATAL: unsupported frontend protocol 16.0: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #9
Day Hour Count Jul 16 19 1 - FATAL: unsupported frontend protocol 16.0: server supports 3.0 to 3.0
Date: 2026-07-16 19:34:27 Database: [unknown] Application: [unknown] User: [unknown] Remote: 40.124.175.30
10 1 ERROR: @PRUTI_UNIQUE_BILLING_CONTACT@ <br>
Times Reported Most Frequent Error / Event #10
Day Hour Count Jul 16 09 1 - ERROR: @PRUTI_UNIQUE_BILLING_CONTACT@ <br>
Context: PL/pgSQL function pruti_check_contact_columns() line 73 at RAISE
Statement: insert into AD_User (AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, Name, Email, C_BPartner_ID, Processing, Firstname, Lastname, IsLocked, Grant_Portal_Access, Isexpiredpassword, Commercialauth, Viasms, Viaemail, EM_Pruti_Isbillingcontact, EM_Pruti_Isordercontact, EM_Pruti_Ispurchaseordcontact, Isdefaultfordocs, EM_Etas_bad_Password_Attempts, EM_Etas_Enable_Mult_Session, EM_Etas_Issecure_Pw, EM_Etas_Isused_Pw, EM_Etas_Isnewuser, EM_Pruti_Isshipmentcontact, AD_User_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30)Date: 2026-07-16 09:36:45 Database: etendo Application: openbravo User: tad Remote: 127.0.0.1