{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "72.01"
},
"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": 30,
"rows_produced_per_join": 30,
"filtered": "100.00",
"index_condition": "((`ea201_diorama`.`cscart_seo_names`.`object_id` in (38523,44625,44623,44622,44621,44620,44619,31996,40662,40658,44618,44617,31249,44615,44614)) 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": "66.01",
"eval_cost": "6.00",
"prefix_cost": "72.01",
"data_read_per_join": "50K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"lang_code",
"company_id",
"path"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
31249 | noch-21730-hetre-rouge-14-cm-fr | 177 |
31996 | heki-1364-38-arbres-feuillus-10-18-cm-fr | 177 |
38523 | 1-sapin-miniature-plastique-14-cm-1-87 | 177/412 |
40658 | 2-petits-murs-provencales-creche-provencale-fr-21404 | 264/403 |
40662 | 2-petites-murettes-creche-provencale-fr-21304 | 264/403 |
44614 | buisson-arbre-miniature-fantaisie-bleu-et-rose-ak-8264 | 177 |
44615 | buisson-arbre-miniature-fantaisie-bleu-et-rose-ak-8266 | 177 |
44617 | 2-maisons-miniatures-de-village-1-160-n-faller-232184 | 194 |
44618 | ecume-deau-pour-maquettes-woodland-cw4529 | 177 |
44619 | citroen-h-1-87-ho-bush-41909 | 398 |
44620 | volvo-miniature-fh16-performance-au-1-87-siku-1543 | 398 |
44621 | tram-bombardier-miniature-au-1-87-siku-1895 | 398 |
44622 | man-bus-miniature-de-tourisme-au-1-87-siku-1624 | 398 |
44623 | station-gare-rouge-1-32-jc-84381 | 668 |
44625 | coffret-agriculture-durable-au-187-faller-190037 | 185 |