{
"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 (11247,11206,11221,11203,11199,11099,11095,11093,11082,11065,11037,10639,10976,10971,10970,10961,10937,10865,10693,10885,10814,10873,10844,10810,10817,10564,10789,10684,10754,10573)) 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 |
---|---|---|
10564 | leopard-1-a1a1-a1a4-1-35-revell-05656 | 2/7 |
10573 | leopard-2-a6m-1-35-revell-03342 | 2/50 |
10639 | coffret-cadeau-conflict-of-nations-series-1-72-revell-05655 | 32/112 |
10684 | churchill-crocodile-1-35-tamiya-35100 | 2/50 |
10693 | vehicule-de-lancement-russe-9p149-du-chtourm-9k114-1-35-trumpeter-09605 | 2/50 |
10754 | bmp-3-1-35-zvezda-3649 | 2/50 |
10789 | model-set-sd-kfz-182-king-tiger-1-72-italeri-72005 | 32/112 |
10810 | jagdpanzer-iv-l-70-1-76-revell-03359 | 2 |
10814 | model-set-jagdpanzer-iv-l-70-1-76-revell-63359 | 32/111 |
10817 | char-sherman-ic-firefly-anglais-1-48-tamiya-32532 | 2/7 |
10844 | panzer-allemand-iv-ausf-g-early-1-35-tamiya-25209 | 2/50 |
10865 | canon-spg-m40-155mm-tamiya-35351 | 2/7 |
10873 | bmp-1-1-35-zvezda-3553 | 2 |
10885 | maquette-panzer-iv-ausf-f-figurines-et-moto-tamiya-25208 | 2/7 |
10937 | shermann-m4a3e8-furry-au-1-56-italeri-25772 | 2 |
10961 | dukw-2-1-2-tonnes-version-amphibie-d-day-1-72-italeri-7022 | 2/51 |
10970 | lance-roquette-bm-21-1-72-zvezda-5051 | 2/51 |
10971 | camion-allemand-l4500-1-35-zvezda-3596 | 2/7 |
10976 | char-dassaut-m48-a3-ccp-1-35-i-love-kit-63533 | 2/50 |
11037 | tiger-i-normandie-1-35-italeri-6754 | 2/50 |
11065 | sd-kfz-167-sturmgeschutz-iv-1-35-italeri-0223 | 2/50 |
11082 | m4-mid-sherman-tank-1-72-trumpeter-7223 | 2/50 |
11093 | sd-kfz-234-3-1-35-italeri-6756 | 2/50 |
11095 | char-b1-bis-1-56-italeri-25766 | 2 |
11099 | decalcs-pour-char-sherman-m4-et-m4a3-star-decals-35991 | 2/50 |
11199 | quickbuild-char-tiger-i-airfix-j6041 | 119 |
11203 | tank-sovietique-t62-1-72-zvezda-5077 | 2/51 |
11206 | leopard-2-a7v-1-35-tamiya-35387 | 2/50 |
11221 | as-42-sahariana-1-35-italeri-6530 | 2/50 |
11247 | chevrolet-15-cwt-1-35-italeri-0233 | 2/7 |