Query Metrics

9 Database Queries
108.78 ms Execution Time
84.00 ms Query Time

Queries

# Execution Time Query Time Info
1 2.86 ms 0.00 ms
{"query":{"bool":{"must":[{"terms":{"attribute_taxons":["ceadesign_collections_stem"]}}]}},"size":20}
Path: bitbag_attribute_taxons/_search
Query:
Method: POST (Http on localhost:9200)
Item count: 1
View formatted query   View cURL query   View query backtrace
2 22.72 ms 21.00 ms
{"query":{"function_score":{"query":{"bool":{"must":[{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["default"]}},{"bool":{"should":[{"terms":{"product_taxons":["ceadesign_collections_stem"]}},{"terms":{"product_taxons.keyword":["ceadesign_collections_stem"]}}]}}]}},{"exists":{"field":"name_it_it"}}],"should":[{"boosting":{"negative_boost":0.5,"negative":{"term":{"price_default":{"value":"0","boost":100}}},"positive":{"range":{"price_default":{"gte":0.01}}}}}]}},"functions":[{"random_score":{"seed":1789916400},"filter":{"match":{"attributes.PRODUCT":"489ebd71-78a4-4ce6-8932-3aa1753784b8"}},"weight":100},{"random_score":{"seed":1789916400},"filter":{"match":{"attributes.PRODUCT":"bc25a737-739c-4793-877d-96c5972025ff"}},"weight":50},{"random_score":{"seed":1789916400},"filter":{"match":{"attributes.PRODUCT":"afeb22e3-a79a-4757-b99e-5a8de34d8ad3"}},"weight":50}]}},"aggs":{"brands":{"terms":{"field":"brand_code.keyword","size":1000}},"collections":{"terms":{"field":"collection_code.keyword","size":1000}},"attributes.SIZE":{"terms":{"field":"attributes.SIZE.keyword","size":1000}},"attributes.U_MT":{"terms":{"field":"attributes.U_MT.keyword","size":1000}},"attributes.PRODUCT":{"terms":{"field":"attributes.PRODUCT.keyword","size":1000}},"attributes.EFFECT":{"terms":{"field":"attributes.EFFECT.keyword","size":1000}},"attributes.COLOR":{"terms":{"field":"attributes.COLOR.keyword","size":1000}},"attributes.PRODUCT_TYPE":{"terms":{"field":"attributes.PRODUCT_TYPE.keyword","size":1000}},"attributes.THICKNESS":{"terms":{"field":"attributes.THICKNESS.keyword","size":1000}},"attributes.MATERIAL":{"terms":{"field":"attributes.MATERIAL.keyword","size":1000}},"attributes.SURFACE":{"terms":{"field":"attributes.SURFACE.keyword","size":1000}},"attributes.APPLICATION":{"terms":{"field":"attributes.APPLICATION.keyword","size":1000}},"attributes.EDGE":{"terms":{"field":"attributes.EDGE.keyword","size":1000}},"attributes.PCS_PER_BOX":{"terms":{"field":"attributes.PCS_PER_BOX.keyword","size":1000}},"attributes.M2_PER_BOX":{"terms":{"field":"attributes.M2_PER_BOX.keyword","size":1000}},"attributes.LM_PER_BOX":{"terms":{"field":"attributes.LM_PER_BOX.keyword","size":1000}},"attributes.KG_PER_BOX":{"terms":{"field":"attributes.KG_PER_BOX.keyword","size":1000}},"attributes.SHADE_VARIATION":{"terms":{"field":"attributes.SHADE_VARIATION.keyword","size":1000}},"attributes.SLIP_CLASS":{"terms":{"field":"attributes.SLIP_CLASS.keyword","size":1000}},"attributes.MINQ":{"terms":{"field":"attributes.MINQ.keyword","size":1000}},"attributes.PEI":{"terms":{"field":"attributes.PEI.keyword","size":1000}},"attributes.INFO":{"terms":{"field":"attributes.INFO.keyword","size":1000}},"attributes.TEST2":{"terms":{"field":"attributes.TEST2.keyword","size":1000}},"attributes.EAN":{"terms":{"field":"attributes.EAN.keyword","size":1000}}}}
Path: bitbag_shop_product/_search
Query:
Method: POST (Http on localhost:9200)
Item count: 39
View formatted query   View cURL query   View query backtrace
3 1.12 ms 0.00 ms
{"query":{"bool":{"must":[{"terms":{"option_taxons":["ceadesign_collections_stem"]}}]}},"size":20}
Path: bitbag_option_taxons/_search
Query:
Method: POST (Http on localhost:9200)
Item count: 0
View formatted query   View cURL query   View query backtrace
4 8.26 ms 0.00 ms
[]
Path: bitbag_shop_category/_doc/1729
Query:
Method: GET (Http on localhost:9200)
Item count: 0
View formatted query   View cURL query   View query backtrace
5 1.99 ms 0.00 ms
{"query":{"bool":{"must":[{"terms":{"attribute_taxons":["ceadesign_collections_stem"]}}]}},"size":20}
Path: bitbag_attribute_taxons/_search
Query:
Method: POST (Http on localhost:9200)
Item count: 1
View formatted query   View cURL query   View query backtrace
6 23.23 ms 21.00 ms
{"query":{"function_score":{"query":{"bool":{"must":[{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["default"]}},{"bool":{"should":[{"terms":{"product_taxons":["ceadesign_collections_stem"]}},{"terms":{"product_taxons.keyword":["ceadesign_collections_stem"]}}]}}]}},{"exists":{"field":"name_it_it"}}],"should":[{"boosting":{"negative_boost":0.5,"negative":{"term":{"price_default":{"value":"0","boost":100}}},"positive":{"range":{"price_default":{"gte":0.01}}}}}]}},"functions":[{"random_score":{"seed":1789916400},"filter":{"match":{"attributes.PRODUCT":"489ebd71-78a4-4ce6-8932-3aa1753784b8"}},"weight":100},{"random_score":{"seed":1789916400},"filter":{"match":{"attributes.PRODUCT":"bc25a737-739c-4793-877d-96c5972025ff"}},"weight":50},{"random_score":{"seed":1789916400},"filter":{"match":{"attributes.PRODUCT":"afeb22e3-a79a-4757-b99e-5a8de34d8ad3"}},"weight":50}]}},"aggs":{"brands":{"terms":{"field":"brand_code.keyword","size":1000}},"collections":{"terms":{"field":"collection_code.keyword","size":1000}},"attributes.SIZE":{"terms":{"field":"attributes.SIZE.keyword","size":1000}},"attributes.U_MT":{"terms":{"field":"attributes.U_MT.keyword","size":1000}},"attributes.PRODUCT":{"terms":{"field":"attributes.PRODUCT.keyword","size":1000}},"attributes.EFFECT":{"terms":{"field":"attributes.EFFECT.keyword","size":1000}},"attributes.COLOR":{"terms":{"field":"attributes.COLOR.keyword","size":1000}},"attributes.PRODUCT_TYPE":{"terms":{"field":"attributes.PRODUCT_TYPE.keyword","size":1000}},"attributes.THICKNESS":{"terms":{"field":"attributes.THICKNESS.keyword","size":1000}},"attributes.MATERIAL":{"terms":{"field":"attributes.MATERIAL.keyword","size":1000}},"attributes.SURFACE":{"terms":{"field":"attributes.SURFACE.keyword","size":1000}},"attributes.APPLICATION":{"terms":{"field":"attributes.APPLICATION.keyword","size":1000}},"attributes.EDGE":{"terms":{"field":"attributes.EDGE.keyword","size":1000}},"attributes.PCS_PER_BOX":{"terms":{"field":"attributes.PCS_PER_BOX.keyword","size":1000}},"attributes.M2_PER_BOX":{"terms":{"field":"attributes.M2_PER_BOX.keyword","size":1000}},"attributes.LM_PER_BOX":{"terms":{"field":"attributes.LM_PER_BOX.keyword","size":1000}},"attributes.KG_PER_BOX":{"terms":{"field":"attributes.KG_PER_BOX.keyword","size":1000}},"attributes.SHADE_VARIATION":{"terms":{"field":"attributes.SHADE_VARIATION.keyword","size":1000}},"attributes.SLIP_CLASS":{"terms":{"field":"attributes.SLIP_CLASS.keyword","size":1000}},"attributes.MINQ":{"terms":{"field":"attributes.MINQ.keyword","size":1000}},"attributes.PEI":{"terms":{"field":"attributes.PEI.keyword","size":1000}},"attributes.INFO":{"terms":{"field":"attributes.INFO.keyword","size":1000}},"attributes.TEST2":{"terms":{"field":"attributes.TEST2.keyword","size":1000}},"attributes.EAN":{"terms":{"field":"attributes.EAN.keyword","size":1000}}}}
Path: bitbag_shop_product/_search
Query:
Method: POST (Http on localhost:9200)
Item count: 39
View formatted query   View cURL query   View query backtrace
7 19.36 ms 18.00 ms
{"query":{"function_score":{"query":{"bool":{"must":[{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["default"]}},{"bool":{"should":[{"terms":{"product_taxons":["ceadesign_collections_stem"]}},{"terms":{"product_taxons.keyword":["ceadesign_collections_stem"]}}]}}]}},{"exists":{"field":"name_it_it"}}],"should":[{"boosting":{"negative_boost":0.5,"negative":{"term":{"price_default":{"value":"0","boost":100}}},"positive":{"range":{"price_default":{"gte":0.01}}}}}]}},"functions":[{"random_score":{"seed":1789916400},"filter":{"match":{"attributes.PRODUCT":"489ebd71-78a4-4ce6-8932-3aa1753784b8"}},"weight":100},{"random_score":{"seed":1789916400},"filter":{"match":{"attributes.PRODUCT":"bc25a737-739c-4793-877d-96c5972025ff"}},"weight":50},{"random_score":{"seed":1789916400},"filter":{"match":{"attributes.PRODUCT":"afeb22e3-a79a-4757-b99e-5a8de34d8ad3"}},"weight":50}]}},"aggs":{"brands":{"terms":{"field":"brand_code.keyword","size":1000}},"collections":{"terms":{"field":"collection_code.keyword","size":1000}},"attributes.SIZE":{"terms":{"field":"attributes.SIZE.keyword","size":1000}},"attributes.U_MT":{"terms":{"field":"attributes.U_MT.keyword","size":1000}},"attributes.PRODUCT":{"terms":{"field":"attributes.PRODUCT.keyword","size":1000}},"attributes.EFFECT":{"terms":{"field":"attributes.EFFECT.keyword","size":1000}},"attributes.COLOR":{"terms":{"field":"attributes.COLOR.keyword","size":1000}},"attributes.PRODUCT_TYPE":{"terms":{"field":"attributes.PRODUCT_TYPE.keyword","size":1000}},"attributes.THICKNESS":{"terms":{"field":"attributes.THICKNESS.keyword","size":1000}},"attributes.MATERIAL":{"terms":{"field":"attributes.MATERIAL.keyword","size":1000}},"attributes.SURFACE":{"terms":{"field":"attributes.SURFACE.keyword","size":1000}},"attributes.APPLICATION":{"terms":{"field":"attributes.APPLICATION.keyword","size":1000}},"attributes.EDGE":{"terms":{"field":"attributes.EDGE.keyword","size":1000}},"attributes.PCS_PER_BOX":{"terms":{"field":"attributes.PCS_PER_BOX.keyword","size":1000}},"attributes.M2_PER_BOX":{"terms":{"field":"attributes.M2_PER_BOX.keyword","size":1000}},"attributes.LM_PER_BOX":{"terms":{"field":"attributes.LM_PER_BOX.keyword","size":1000}},"attributes.KG_PER_BOX":{"terms":{"field":"attributes.KG_PER_BOX.keyword","size":1000}},"attributes.SHADE_VARIATION":{"terms":{"field":"attributes.SHADE_VARIATION.keyword","size":1000}},"attributes.SLIP_CLASS":{"terms":{"field":"attributes.SLIP_CLASS.keyword","size":1000}},"attributes.MINQ":{"terms":{"field":"attributes.MINQ.keyword","size":1000}},"attributes.PEI":{"terms":{"field":"attributes.PEI.keyword","size":1000}},"attributes.INFO":{"terms":{"field":"attributes.INFO.keyword","size":1000}},"attributes.TEST2":{"terms":{"field":"attributes.TEST2.keyword","size":1000}},"attributes.EAN":{"terms":{"field":"attributes.EAN.keyword","size":1000}}},"size":0,"track_total_hits":true}
Path: bitbag_shop_product/_search
Query: search_type=query_then_fetch
Method: POST (Http on localhost:9200)
Item count: 39
View formatted query   View cURL query   View query backtrace
8 28.31 ms 24.00 ms
{"query":{"function_score":{"query":{"bool":{"must":[{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["default"]}},{"bool":{"should":[{"terms":{"product_taxons":["ceadesign_collections_stem"]}},{"terms":{"product_taxons.keyword":["ceadesign_collections_stem"]}}]}}]}},{"exists":{"field":"name_it_it"}}],"should":[{"boosting":{"negative_boost":0.5,"negative":{"term":{"price_default":{"value":"0","boost":100}}},"positive":{"range":{"price_default":{"gte":0.01}}}}}]}},"functions":[{"random_score":{"seed":1789916400},"filter":{"match":{"attributes.PRODUCT":"489ebd71-78a4-4ce6-8932-3aa1753784b8"}},"weight":100},{"random_score":{"seed":1789916400},"filter":{"match":{"attributes.PRODUCT":"bc25a737-739c-4793-877d-96c5972025ff"}},"weight":50},{"random_score":{"seed":1789916400},"filter":{"match":{"attributes.PRODUCT":"afeb22e3-a79a-4757-b99e-5a8de34d8ad3"}},"weight":50}]}},"aggs":{"brands":{"terms":{"field":"brand_code.keyword","size":1000}},"collections":{"terms":{"field":"collection_code.keyword","size":1000}},"attributes.SIZE":{"terms":{"field":"attributes.SIZE.keyword","size":1000}},"attributes.U_MT":{"terms":{"field":"attributes.U_MT.keyword","size":1000}},"attributes.PRODUCT":{"terms":{"field":"attributes.PRODUCT.keyword","size":1000}},"attributes.EFFECT":{"terms":{"field":"attributes.EFFECT.keyword","size":1000}},"attributes.COLOR":{"terms":{"field":"attributes.COLOR.keyword","size":1000}},"attributes.PRODUCT_TYPE":{"terms":{"field":"attributes.PRODUCT_TYPE.keyword","size":1000}},"attributes.THICKNESS":{"terms":{"field":"attributes.THICKNESS.keyword","size":1000}},"attributes.MATERIAL":{"terms":{"field":"attributes.MATERIAL.keyword","size":1000}},"attributes.SURFACE":{"terms":{"field":"attributes.SURFACE.keyword","size":1000}},"attributes.APPLICATION":{"terms":{"field":"attributes.APPLICATION.keyword","size":1000}},"attributes.EDGE":{"terms":{"field":"attributes.EDGE.keyword","size":1000}},"attributes.PCS_PER_BOX":{"terms":{"field":"attributes.PCS_PER_BOX.keyword","size":1000}},"attributes.M2_PER_BOX":{"terms":{"field":"attributes.M2_PER_BOX.keyword","size":1000}},"attributes.LM_PER_BOX":{"terms":{"field":"attributes.LM_PER_BOX.keyword","size":1000}},"attributes.KG_PER_BOX":{"terms":{"field":"attributes.KG_PER_BOX.keyword","size":1000}},"attributes.SHADE_VARIATION":{"terms":{"field":"attributes.SHADE_VARIATION.keyword","size":1000}},"attributes.SLIP_CLASS":{"terms":{"field":"attributes.SLIP_CLASS.keyword","size":1000}},"attributes.MINQ":{"terms":{"field":"attributes.MINQ.keyword","size":1000}},"attributes.PEI":{"terms":{"field":"attributes.PEI.keyword","size":1000}},"attributes.INFO":{"terms":{"field":"attributes.INFO.keyword","size":1000}},"attributes.TEST2":{"terms":{"field":"attributes.TEST2.keyword","size":1000}},"attributes.EAN":{"terms":{"field":"attributes.EAN.keyword","size":1000}}},"from":0,"size":27}
Path: bitbag_shop_product/_search
Query:
Method: POST (Http on localhost:9200)
Item count: 39
View formatted query   View cURL query   View query backtrace
9 0.94 ms 0.00 ms
{"query":{"match_all":{}},"size":0,"track_total_hits":true}
Path: bitbag_shop_product/_search
Query: search_type=query_then_fetch
Method: POST (Http on localhost:9200)
Item count: 73961
View formatted query   View cURL query   View query backtrace