Query Metrics

10 Database Queries
120.04 ms Execution Time
91.00 ms Query Time

Queries

# Execution Time Query Time Info
1 2.75 ms 0.00 ms
{"query":{"bool":{"must":[{"terms":{"attribute_taxons":["wall_lamps"]}}]}},"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 21.71 ms 20.00 ms
{"query":{"function_score":{"query":{"bool":{"must":[{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["default"]}},{"bool":{"should":[{"terms":{"product_taxons":["wall_lamps"]}},{"terms":{"product_taxons.keyword":["wall_lamps"]}}]}}]}},{"exists":{"field":"name_fr_fr"}}],"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":1789923600},"filter":{"match":{"attributes.PRODUCT":"489ebd71-78a4-4ce6-8932-3aa1753784b8"}},"weight":100},{"random_score":{"seed":1789923600},"filter":{"match":{"attributes.PRODUCT":"bc25a737-739c-4793-877d-96c5972025ff"}},"weight":50},{"random_score":{"seed":1789923600},"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: 397
View formatted query   View cURL query   View query backtrace
3 25.38 ms 23.00 ms
{"query":{"function_score":{"query":{"bool":{"must":[{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["default"]}},{"bool":{"should":[{"terms":{"product_taxons":["wall_lamps"]}},{"terms":{"product_taxons.keyword":["wall_lamps"]}}]}}]}},{"exists":{"field":"name_fr_fr"}}],"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":1789923600},"filter":{"match":{"attributes.PRODUCT":"489ebd71-78a4-4ce6-8932-3aa1753784b8"}},"weight":100},{"random_score":{"seed":1789923600},"filter":{"match":{"attributes.PRODUCT":"bc25a737-739c-4793-877d-96c5972025ff"}},"weight":50},{"random_score":{"seed":1789923600},"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: 397
View formatted query   View cURL query   View query backtrace
4 1.05 ms 0.00 ms
{"query":{"bool":{"must":[{"terms":{"option_taxons":["wall_lamps"]}}]}},"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
5 8.84 ms 0.00 ms
[]
Path: bitbag_shop_category/_doc/152
Query:
Method: GET (Http on localhost:9200)
Item count: 0
View formatted query   View cURL query   View query backtrace
6 2.19 ms 0.00 ms
{"query":{"bool":{"must":[{"terms":{"attribute_taxons":["wall_lamps"]}}]}},"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
7 3.76 ms 2.00 ms
{"query":{"function_score":{"query":{"bool":{"must":[{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["default"]}},{"bool":{"should":[{"terms":{"product_taxons":["wall_lamps"]}},{"terms":{"product_taxons.keyword":["wall_lamps"]}}]}}]}},{"exists":{"field":"name_fr_fr"}}],"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":1789923600},"filter":{"match":{"attributes.PRODUCT":"489ebd71-78a4-4ce6-8932-3aa1753784b8"}},"weight":100},{"random_score":{"seed":1789923600},"filter":{"match":{"attributes.PRODUCT":"bc25a737-739c-4793-877d-96c5972025ff"}},"weight":50},{"random_score":{"seed":1789923600},"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: 397
View formatted query   View cURL query   View query backtrace
8 24.13 ms 22.00 ms
{"query":{"function_score":{"query":{"bool":{"must":[{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["default"]}},{"bool":{"should":[{"terms":{"product_taxons":["wall_lamps"]}},{"terms":{"product_taxons.keyword":["wall_lamps"]}}]}}]}},{"exists":{"field":"name_fr_fr"}}],"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":1789923600},"filter":{"match":{"attributes.PRODUCT":"489ebd71-78a4-4ce6-8932-3aa1753784b8"}},"weight":100},{"random_score":{"seed":1789923600},"filter":{"match":{"attributes.PRODUCT":"bc25a737-739c-4793-877d-96c5972025ff"}},"weight":50},{"random_score":{"seed":1789923600},"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: 397
View formatted query   View cURL query   View query backtrace
9 28.82 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":["wall_lamps"]}},{"terms":{"product_taxons.keyword":["wall_lamps"]}}]}}]}},{"exists":{"field":"name_fr_fr"}}],"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":1789923600},"filter":{"match":{"attributes.PRODUCT":"489ebd71-78a4-4ce6-8932-3aa1753784b8"}},"weight":100},{"random_score":{"seed":1789923600},"filter":{"match":{"attributes.PRODUCT":"bc25a737-739c-4793-877d-96c5972025ff"}},"weight":50},{"random_score":{"seed":1789923600},"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":270,"size":27}
Path: bitbag_shop_product/_search
Query:
Method: POST (Http on localhost:9200)
Item count: 397
View formatted query   View cURL query   View query backtrace
10 1.41 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