{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "144.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": 60,
"rows_produced_per_join": 60,
"filtered": "100.00",
"index_condition": "((`ea201_francemaqu`.`cscart_seo_names`.`object_id` in (11286,10638,11031,11030,10872,11224,11223,10929,10930,10871,11095,10458,10931,11014,10812,11001,10955,10954,11044,10554,10641,11003,11005,11006,10842,8192,10416,10415,10571,10553)) and (`ea201_francemaqu`.`cscart_seo_names`.`type` = 'p') and (`ea201_francemaqu`.`cscart_seo_names`.`dispatch` = '') and (`ea201_francemaqu`.`cscart_seo_names`.`lang_code` = 'fr') and ((`ea201_francemaqu`.`cscart_seo_names`.`company_id` = 1) or (`ea201_francemaqu`.`cscart_seo_names`.`company_id` = 0)))",
"cost_info": {
"read_cost": "132.01",
"eval_cost": "12.00",
"prefix_cost": "144.01",
"data_read_per_join": "101K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"lang_code",
"company_id",
"path"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
8192 | maquette-top-gun-2-movie-set-1-72-revell-05677-5677 | 5/94 |
10415 | star-wars-faucon-millennium-1-72-revell-05659 | 32/112 |
10416 | star-wars-y-wing-fighter-1-72-revell-05658 | 32/112 |
10458 | 68-firebird-1-25-revell-14545 | 9 |
10553 | the-mandalorian-n1-starfighter-1-24-revell-06787 | 114/4 |
10554 | 77-jeep-cj-7-1-24-revell-14547 | 9 |
10571 | james-bond-moonraker-1-144-revell-05665 | 114/118 |
10638 | coffret-cadeau-25e-anniv-station-iss-1-144-revell-05651 | 114/118 |
10641 | 57-chevy-bel-air-deux-portes-sedan-1-25-revell-us-14551 | 9/10 |
10812 | the-mandalorian-speeder-bike-1-12-revell-06786 | 114/4 |
10842 | bandai-tie-advanced-1-72-revell-01214 | 114/4 |
10871 | ep1-darth-mauls-sith-infiltrator-1-120-revell-05638 | 32/112 |
10872 | ep1-anakins-podrace-1-31-revell-05639 | 32/112 |
10929 | dune-harkonnen-ornithopter-meng-mms-014 | 114 |
10930 | moissonneuse-a-epices-dune-meng-mms-013 | 114 |
10931 | ornithopter-atreides-dune-meng-mms-011 | 114 |
10954 | retour-vers-le-futur-delorean-part-i-1-43-aoshima-05475 | 114 |
10955 | retour-vers-le-futur-delorean-part-ii-1-43-aoshima-05476 | 114 |
11001 | puzzle-harry-potter-300-pieces-prime-3d-670889325824 | 451 |
11003 | puzzle-vw-bus-lamour-et-lespoir-1000-pieces | 451 |
11005 | puzzle-bus-combi-vw-endeless-summer-6000-5619 | 451 |
11006 | puzzle-coccinelle-vw-surf-shark-6000-5683 | 451 |
11014 | remorque-pour-camion-porte-autos-1-25-revell-11509 | 110 |
11030 | puzzle-3d-house-of-the-dragon-trone-de-fer-revell-00224 | 451 |
11031 | puzzle-3d-house-of-the-dragon-trone-de-fer-revell-00224-clone | 451 |
11044 | pteranodon-1-35-tamiya-60204 | 114/475 |
11095 | char-b1-bis-1-56-italeri-25766 | 2 |
11223 | dune-paul-atreides-deluxe-edition-1-12-meng-afs-002s | 114 |
11224 | ornithopter-atreides-dune-1-72-meng-ds-007 | 114 |
11286 | puzzle-3d-one-piece-flying-lamb-vogue-merry-revell-00270 | 451 |