{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "265.65"
},
"ordering_operation": {
"using_filesort": true,
"grouping_operation": {
"using_temporary_table": true,
"using_filesort": true,
"buffer_result": {
"using_temporary_table": true,
"nested_loop": [
{
"table": {
"table_name": "companies",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id"
],
"key_length": "4",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "0.00",
"data_read_per_join": "9K"
},
"used_columns": [
"company_id",
"status",
"company",
"ec_rfq_whatsapp_number",
"ec_rfq_phone_number",
"ec_rfq_bhf",
"ec_rfq_bht"
]
}
},
{
"table": {
"table_name": "cscart_categories",
"access_type": "range",
"possible_keys": [
"PRIMARY",
"c_status",
"p_category_id"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"rows_examined_per_scan": 19,
"rows_produced_per_join": 0,
"filtered": "4.00",
"cost_info": {
"read_cost": "26.54",
"eval_cost": "0.15",
"prefix_cost": "26.69",
"data_read_per_join": "4K"
},
"used_columns": [
"category_id",
"usergroup_ids",
"status",
"storefront_id"
],
"attached_condition": "((`webmarco`.`cscart_categories`.`category_id` in (9965,10125,10127,10128,10129,10130,10131,9966,9971,9977,9978,9979,9982,9983,9984,9986,9992,9993,9994)) and ((`webmarco`.`cscart_categories`.`usergroup_ids` = '') or find_in_set(0,`webmarco`.`cscart_categories`.`usergroup_ids`) or find_in_set(1,`webmarco`.`cscart_categories`.`usergroup_ids`)) and (`webmarco`.`cscart_categories`.`status` in ('A','H')) and (`webmarco`.`cscart_categories`.`storefront_id` in (0,1)))"
}
},
{
"table": {
"table_name": "products_categories",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"pt"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"ref": [
"webmarco.cscart_categories.category_id"
],
"rows_examined_per_scan": 179,
"rows_produced_per_join": 136,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "0.96",
"eval_cost": "27.28",
"prefix_cost": "54.93",
"data_read_per_join": "2K"
},
"used_columns": [
"product_id",
"category_id"
]
}
},
{
"table": {
"table_name": "prices",
"access_type": "ref",
"possible_keys": [
"usergroup",
"product_id",
"lower_limit",
"usergroup_id"
],
"key": "usergroup",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"webmarco.products_categories.product_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 34,
"filtered": "25.00",
"using_index": true,
"cost_info": {
"read_cost": "136.39",
"eval_cost": "6.82",
"prefix_cost": "218.60",
"data_read_per_join": "2K"
},
"used_columns": [
"product_id",
"lower_limit",
"usergroup_id"
],
"attached_condition": "((`webmarco`.`prices`.`lower_limit` = 1) and (`webmarco`.`prices`.`usergroup_id` in (0,0,1)))"
}
},
{
"table": {
"table_name": "products",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"status",
"idx_parent_product_id"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"webmarco.products_categories.product_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "5.00",
"cost_info": {
"read_cost": "34.10",
"eval_cost": "0.34",
"prefix_cost": "259.52",
"data_read_per_join": "13K"
},
"used_columns": [
"product_id",
"product_type",
"status",
"company_id",
"usergroup_ids",
"parent_product_id"
],
"attached_condition": "((`webmarco`.`products`.`company_id` = '613') and (`webmarco`.`products`.`company_id` = '613') and (`webmarco`.`products`.`status` = 'A') and ((`webmarco`.`products`.`usergroup_ids` = '') or find_in_set(0,`webmarco`.`products`.`usergroup_ids`) or find_in_set(1,`webmarco`.`products`.`usergroup_ids`)))"
}
},
{
"table": {
"table_name": "cscart_ec_table_booking_system",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id"
],
"key_length": "4",
"ref": [
"webmarco.products_categories.product_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.70",
"eval_cost": "0.34",
"prefix_cost": "261.56",
"data_read_per_join": "300"
},
"used_columns": [
"product_id",
"booking_type"
],
"attached_condition": "<if>(is_not_null_compl(cscart_ec_table_booking_system), (`webmarco`.`cscart_ec_table_booking_system`.`product_id` = `webmarco`.`products_categories`.`product_id`), true)"
}
},
{
"table": {
"table_name": "popularity",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"total"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"webmarco.products_categories.product_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.70",
"eval_cost": "0.34",
"prefix_cost": "263.61",
"data_read_per_join": "54"
},
"used_columns": [
"product_id",
"total"
]
}
},
{
"table": {
"table_name": "descr1",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"product_id"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id",
"lang_code"
],
"key_length": "9",
"ref": [
"webmarco.products_categories.product_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.70",
"eval_cost": "0.34",
"prefix_cost": "265.65",
"data_read_per_join": "11K"
},
"used_columns": [
"product_id",
"lang_code",
"product"
]
}
}
]
}
}
}
}
}
product_id | product | company_name | ec_rfq_whatsapp_number | ec_rfq_bht | ec_rfq_phone_number | ec_rfq_bhf | product_ids | product_types | parent_product_ids | product_type | parent_product_id | booking_type |
---|---|---|---|---|---|---|---|---|---|---|---|---|
309587 | Tallieur With Trouser Skirt And Crop Jacket | Anduena's Store | 309587,309588 | P,V | 0,309587 | P | 0 | |||||
359772 | Maglione Con Fiori | Anduena's Store | 359772,359772 | P,P | 0,0 | P | 0 | |||||
309590 | Tallieur With Wide Leg Trousers And Long Sleeve Crop Jacket | Anduena's Store | 309590 | P | 0 | P | 0 | |||||
359805 | MINI DRESS WITH RHINESTONE DETAILS ON THE SHOULDERS | Anduena's Store | 359805,435519 | P,V | 0,359805 | V | 359805 | |||||
309585 | Tight Mini Dress With Cross Neckline | Anduena's Store | 309585,309586 | P,V | 0,309585 | P | 0 | |||||
359762 | Completo Con Top e Pantaloni a Zampa | Anduena's Store | 359762,359762 | P,P | 0,0 | P | 0 | |||||
359808 | Oversize Vest With Knitting | Anduena's Store | 359808 | P | 0 | P | 0 | |||||
309561 | White Tallieur With Wide Leg Trousers And Final Slit | Anduena's Store | 309561 | P | 0 | P | 0 | |||||
359744 | Gonna in Similpelle | Anduena's Store | 359744,359746 | P,V | 0,359744 | P | 0 | |||||
309550 | Tight-fitting glitter mini dress | Anduena's Store | 309550 | P | 0 | P | 0 | |||||
359752 | Completo con Giacca Crop Oversize e Pantaloncini | Anduena's Store | 359752,359753 | P,V | 0,359752 | P | 0 | |||||
359758 | Leggins Imbottiti in Similpelle | Anduena's Store | 359758 | P | 0 | P | 0 | |||||
309576 | Tallieur Short With Crop Jacket, Long Sleeve | Anduena's Store | 309576 | P | 0 | P | 0 | |||||
366904 | Abito Corto Con Coprispalle | Anduena's Store | 366904 | P | 0 | P | 0 | |||||
389637 | Abito Corto Aderente [CLONE] | Anduena's Store | 389637 | P | 0 | P | 0 | |||||
359478 | Midì Dress | Anduena's Store | 359478 | P | 0 | P | 0 | |||||
415577 | Formal Satin Formal Dress With Side Slit And Sweetheart Neckline [CLONE] | Anduena's Store | 415577 | P | 0 | P | 0 | N | ||||
391690 | Body In Pizzo [CLONE] | Anduena's Store | 391690 | P | 0 | P | 0 | |||||
309567 | Crop Top With Open Breast Square Neckline | Anduena's Store | 309567 | P | 0 | P | 0 | |||||
359747 | Camicia a Quadri | Anduena's Store | 359747,359747 | P,P | 0,0 | P | 0 | |||||
415550 | Two Piece Set Undershirt With Braces [CLONE] | Anduena's Store | 415550 | P | 0 | P | 0 | N | ||||
387078 | Body Intrecciato Aderente ed Elastico. [CLONE] | Anduena's Store | 387078,387078,387078 | P,P,P | 0,0,0 | P | 0 | |||||
381626 | Wide Leg High Waist Jeans [CLONE] | Anduena's Store | 381626 | P | 0 | P | 0 | |||||
309571 | Crop Top With Lace Patterns | Anduena's Store | 309571 | P | 0 | P | 0 | |||||
359779 | Maglioncino Dolcevita | Anduena's Store | 359779 | P | 0 | P | 0 | |||||
387080 | Body In Pizzo [CLONE] | Anduena's Store | 387080 | P | 0 | P | 0 | |||||
393018 | Completo Top e Pantalone a Zampa [CLONE] | Anduena's Store | 393018 | P | 0 | P | 0 | |||||
387083 | Monocolor Crop Shirt With Elastic Waist [CLONE] | Anduena's Store | 387083 | P | 0 | P | 0 | |||||
430340 | Completo Con Top e Pantaloni a Zampa [CLONE] [CLONE] | Anduena's Store | 430340,430340 | P,P | 0,0 | P | 0 | |||||
359751 | Abito Aderente Con Scollo a V | Anduena's Store | 359751 | P | 0 | P | 0 | |||||
391691 | Body In Pizzo [CLONE] [CLONE] | Anduena's Store | 391691 | P | 0 | P | 0 | |||||
391704 | Midì Dress [CLONE] [CLONE] | Anduena's Store | 391704 | P | 0 | P | 0 | |||||
427476 | Completo Top e Pantalone a Zampa [CLONE] [CLONE] [CLONE] | Anduena's Store | 427476 | P | 0 | P | 0 | |||||
427477 | Completo Top e Pantalone a Zampa [CLONE] [CLONE] | Anduena's Store | 427477 | P | 0 | P | 0 | |||||
387082 | Tallieur With Check Pattern, Jacket With Ornamental Buttons, Tight Skirt [CLONE] | Anduena's Store | 387082 | P | 0 | P | 0 | |||||
415554 | Midì Dress [CLONE] [CLONE] | Anduena's Store | 415554 | P | 0 | P | 0 | N | ||||
372040 | Jeans Beige | Anduena's Store | 372040 | P | 0 | P | 0 | |||||
393020 | Formal Satin Formal Dress With Side Slit And Sweetheart Neckline [CLONE] | Anduena's Store | 393020 | P | 0 | P | 0 | N | ||||
393026 | Formal Satin Formal Dress With Side Slit And Sweetheart Neckline [CLONE] | Anduena's Store | 393026 | P | 0 | P | 0 | N | ||||
381634 | Magliocino con Scollo [CLONE] | Anduena's Store | 381634 | P | 0 | P | 0 | |||||
393022 | Formal Satin Formal Dress With Side Slit And Sweetheart Neckline [CLONE] | Anduena's Store | 393022 | P | 0 | P | 0 | N | ||||
424699 | Abito Corto Aderente [CLONE] [CLONE] | Anduena's Store | 424699 | P | 0 | P | 0 | N | ||||
381632 | Crop Top With Lace Patterns [CLONE] | Anduena's Store | 381632 | P | 0 | P | 0 | |||||
393012 | Short Tight Skirt, Long Sleeve Crop Jacket With Button Closure [CLONE] | Anduena's Store | 393012 | P | 0 | P | 0 | N | ||||
393013 | Long Elegant Satin Dress With Slit [CLONE] [CLONE] | Anduena's Store | 393013 | P | 0 | P | 0 | |||||
427473 | Completo Top e Pantalone a Zampa [CLONE] [CLONE] | Anduena's Store | 427473 | P | 0 | P | 0 | |||||
366897 | Felpa con Cappuccio | Anduena's Store | 366897 | P | 0 | P | 0 | |||||
434596 | Tallieur With Trouser Skirt And Crop Jacket [CLONE] [CLONE] | Anduena's Store | 434596 | P | 0 | P | 0 | N | ||||
391702 | Midì Dress [CLONE] | Anduena's Store | 391702 | P | 0 | P | 0 | |||||
387084 | Trouser dress [CLONE] [CLONE] | Anduena's Store | 387084 | P | 0 | P | 0 | |||||
434591 | Completo Top e Pantalone a Zampa [CLONE] [CLONE] [CLONE] [CLONE] | Anduena's Store | 434591 | P | 0 | P | 0 | N | ||||
434595 | Tallieur With Trouser Skirt And Crop Jacket [CLONE] | Anduena's Store | 434595 | P | 0 | P | 0 | N | ||||
435213 | MINI DRESS WITH RHINESTONE DETAILS ON THE SHOULDERS [CLONE] | Anduena's Store | 435213 | P | 0 | P | 0 | N | ||||
434592 | Tallieur With Trouser Skirt And Crop Jacket [CLONE] | Anduena's Store | 434592 | P | 0 | P | 0 | N | ||||
434594 | Tallieur With Trouser Skirt And Crop Jacket [CLONE] | Anduena's Store | 434594 | P | 0 | P | 0 | N | ||||
434593 | Tallieur With Trouser Skirt And Crop Jacket [CLONE] | Anduena's Store | 434593 | P | 0 | P | 0 | N |