https://livmedx.com/en_US/products-list/beauty-cosmetics/organic-cosmetics

Query Metrics

6 Database Queries
10.32 ms Execution Time
1.00 ms Query Time

Queries

# Execution Time Query Time Info
1 1.98 ms 0.00 ms
{"query":{"bool":{"must":[{"terms":{"option_taxons":["cat00154"]}}]}},"size":20}
Path: bitbag_option_taxons_dev/_search
Query:
Method: POST (Http on localhost:9200)
Item count: 0
View formatted query   View cURL query   View query backtrace
2 1.04 ms 0.00 ms
{"query":{"bool":{"must":[{"terms":{"attribute_taxons":["cat00154"]}}]}},"size":20}
Path: bitbag_attribute_taxons_dev/_search
Query:
Method: POST (Http on localhost:9200)
Item count: 0
View formatted query   View cURL query   View query backtrace
3 1.29 ms 0.00 ms
{"query":{"bool":{"must":[{"terms":{"attribute_taxons":["cat00154"]}}]}},"size":20}
Path: bitbag_attribute_taxons_dev/_search
Query:
Method: POST (Http on localhost:9200)
Item count: 0
View formatted query   View cURL query   View query backtrace
4 1.28 ms 0.00 ms
{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["livmedx"]}},{"terms":{"product_taxons":["cat00154"]}}]}},"size":0}
Path: bitbag_shop_products_dev/_search
Query:
Method: POST (Http on localhost:9200)
Item count: 0
View formatted query   View cURL query   View query backtrace
5 1.63 ms 0.00 ms
{"query":{"bool":{"must":[{"terms":{"attribute_taxons":["cat00154"]}}]}},"size":20}
Path: bitbag_attribute_taxons_dev/_search
Query:
Method: POST (Http on localhost:9200)
Item count: 0
View formatted query   View cURL query   View query backtrace
6 3.09 ms 1.00 ms
{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["livmedx"]}},{"terms":{"product_taxons":["cat00154"]}}]}},"sort":[{"taxon_position_cat00154":{"order":"asc","unmapped_type":"keyword"}}],"size":0,"track_total_hits":true}
Path: bitbag_shop_products_dev/_search
Query: search_type=query_then_fetch
Method: POST (Http on localhost:9200)
Item count: 0
View formatted query   View cURL query   View query backtrace