{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "41.21"
},
"table": {
"table_name": "q_seo_names",
"access_type": "range",
"possible_keys": [
"PRIMARY",
"dispatch"
],
"key": "PRIMARY",
"used_key_parts": [
"object_id",
"type",
"dispatch",
"lang_code"
],
"key_length": "206",
"rows_examined_per_scan": 18,
"rows_produced_per_join": 18,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (30960,30961,30962,30963,30964,30965,30966,30967,30968,30969,30970,30971,30972,30973,30974,30975)) and (`portal`.`q_seo_names`.`type` = 'p') and (`portal`.`q_seo_names`.`dispatch` = '') and (`portal`.`q_seo_names`.`lang_code` = 'en'))",
"cost_info": {
"read_cost": "37.61",
"eval_cost": "3.60",
"prefix_cost": "41.21",
"data_read_per_join": "30K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
30960 | curtain-stripe-lights-300led-8-modes-warm-white-fairy-string-lights-decoration | 6/159/166 |
30961 | 90w-led-solar-street-light-pir-motion-sensor-wall-timing-lamp | 6/159/167 |
30962 | clear-plastic-craft-beads-jewellery-storage-organizer-tool-box-case | 6/184/189 |
30963 | 2-pack-wifi-smart-plug-timing-switch-voice-control-work-with-amazon-alexa-echo | 6/184/185 |
30964 | 2pc-rope-window-curtain-tiebacks-tassel-binding-rope-tie-backs-home-decor | 6/159/166 |
30965 | coffee-filter-reusable-capsule-fit-for-illy-coffee-capsule-dripper | 6/438/454 |
30966 | stainless-steel-french-fry-cutter-potato-vegetable-slicer-chopper-dicer-2-blade | 6/438/454 |
30967 | led-light-wedge-eyes-protect-panel-book-reading-lamp-paperback-night-vision | 6/159/167 |
30968 | diy-diamond-painting-tools-kit-5d-cross-stitch-embroidery-pen-set-mosaic-glue | 248/249/255 |
30969 | 3d-usb-hand-shot-lights-moon-night-light-moonlight-table-desk-moon-lamp-gift | 6/159/167 |
30970 | indian-mandala-floor-pillows-round-bohemian-cushion-cushions-pillows-cover-case | 6/7/61/64 |
30971 | 1-rollself-adhesive-tile-art-wall-decal-sticker-diy-kitchen-bathroom-decor-vinyl | 6/159/160 |
30972 | for-dyson-vacuum-cleaner-accessories-adapter-v6-converted-to-v7-v8-v10-interface | 6/168/180 |
30973 | men-plastic-shoe-tree-stretcher-boot-holder-shaper-automatic-support | 12/50/68/76 |
30974 | kitchen-sink-rack-sponge-soap-drain-holder-bathroom-hanging-caddy-basket-shelf | 6/438/454/455 |
30975 | 4pc-pack-baby-child-infant-kids-safety-table-desk-corner-edge-cushions | 6/406/568 |