{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "139.21"
},
"table": {
"table_name": "cscart_seo_names",
"access_type": "range",
"possible_keys": [
"PRIMARY",
"dispatch"
],
"key": "PRIMARY",
"used_key_parts": [
"object_id",
"type",
"dispatch",
"lang_code",
"company_id"
],
"key_length": "210",
"rows_examined_per_scan": 58,
"rows_produced_per_join": 58,
"filtered": "100.00",
"index_condition": "((`ea201_diorama`.`cscart_seo_names`.`object_id` in (34828,34928,39919,39920,39921,38856,38600,38601,35779,35599,35600,30985,31040,30389,30968,30969,30971,30972,30974,30976,30977,30986,30989,31041,31045,31046,31047,31048,31051)) and (`ea201_diorama`.`cscart_seo_names`.`type` = 'p') and (`ea201_diorama`.`cscart_seo_names`.`dispatch` = '') and (`ea201_diorama`.`cscart_seo_names`.`lang_code` = 'fr') and ((`ea201_diorama`.`cscart_seo_names`.`company_id` = 1) or (`ea201_diorama`.`cscart_seo_names`.`company_id` = 0)))",
"cost_info": {
"read_cost": "127.61",
"eval_cost": "11.60",
"prefix_cost": "139.21",
"data_read_per_join": "98K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"lang_code",
"company_id",
"path"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
30389 | heki-3340-colle-verte-pour-flocages-fr | 203 |
30968 | heki-1560-feuillage-vert-clair-200-ml-fr | 177/218 |
30969 | heki-1561-feuillage-vert-moyen-200-ml-fr | 177/218 |
30971 | heki-1563-feuillage-vert-200-ml-fr | 177/218 |
30972 | heki-1564-feuillage-vert-200-ml | 177/218 |
30974 | heki-1566-feuillage-automne-200-ml-fr | 177/218 |
30976 | heki-1568-feuillage-automne-200-ml-fr | 177/218 |
30977 | heki-1570-feuillage-fr | 177/218 |
30985 | heki-1620-feuillage-vert-moyen-fr | 177/218 |
30986 | heki-1670-15-arbres-feuillus-vert-clair-fr | 177/218/341 |
30989 | heki-1696-micro-feuillage-gros-artline-renovation-500-ml-fr | 177/218 |
31040 | heki-1540-feuillage-vert-14-x-28-cm-fr | 177/218 |
31041 | heki-1557-flocage-automne-14-x-28-cm-fr | 177/224 |
31045 | heki-1550-heki-flore-vert-clair-14-x-28-cm-fr | 177/224 |
31046 | heki-1551-heki-flore-vert-moyen-14-x-28-cm-fr | 177/224 |
31047 | heki-1552-heki-flore-vert-fonce-14-x-28-cm-fr | 177/224 |
31048 | heki-1553-heki-flore-vert-fonce-14-x-28-cm | 177/224 |
31051 | heki-1556-heki-flore-automne-14-x-28-cm-fr | 177/224 |
34828 | noch-7167-set-de-feuillage-vert-fr | 177/218/343 |
34928 | noch-7168-set-de-feuillage-rouges-fr | 177/218/342 |
35599 | heki-1675-feuillage-28x14-cm-miniature | 177/218/341 |
35600 | heki-1676-feuillage-vert-clair-miniature | 177/218/341 |
35779 | heki-1612-flocage-pour-feuillage-200ml-vert-fonce-miniature | 177/218/344 |
38600 | noch-7152-feuillage-vert-clair-100-g | 177 |
38601 | noch-7154-feuillage-vert-moyen-100-g | 177 |
38856 | feuillage-vert-pin-heki-1688 | 177 |
39919 | flocage-vert-moyen-20-x-23-cm-noch-07291 | 177 |
39920 | feuillage-dense-vert-moyen-20-x-23-cm-noch-07300 | 177 |
39921 | feuillage-dense-vert-fonce-20-x-23-cm-noch-07301 | 177 |