{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "9.81"
},
"table": {
"table_name": "cscart_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": 14,
"rows_produced_per_join": 14,
"filtered": "100.00",
"index_condition": "((`cscartdb`.`cscart_seo_names`.`object_id` in (67475,63039,60875,62270,62315,62372,62550,62439,69973,71049,70309,70776,71612,71886)) and (`cscartdb`.`cscart_seo_names`.`type` = 'p') and (`cscartdb`.`cscart_seo_names`.`dispatch` = '') and (`cscartdb`.`cscart_seo_names`.`lang_code` = 'en'))",
"cost_info": {
"read_cost": "8.41",
"eval_cost": "1.40",
"prefix_cost": "9.81",
"data_read_per_join": "23K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
60875 | ivan-realistic-silicone-dildo-690a68b | 2/8/32 |
62270 | hanuman-massive-realistic-silicone-sex-toy-90204e1 | 2/8/32 |
62315 | jorge-the-realistic-sinsaint-dildo-6083cb | 2/8/32 |
62372 | jeffry-realistic-silicone-sex-toy-4c7248d | 2/8/32 |
62439 | mini-sinsaint-silicone-toys-509e183 | 2/8/31 |
62550 | peanut-beginner-plug-set-3151a91 | 2/10/39/61 |
63039 | drago-handmade-fantasy-sex-toy-6a07db3 | 2/8/31 |
67475 | vlad-the-impaler-silicone-sex-toy-4095c9b | 2/8/31 |
69973 | citadel-silicone-sex-toy-from-sinsaint-1d0e1bf | 2/8/31 |
70309 | ragnar-handmade-silicone-dildo-6b4955f | 2/8/31 |
70776 | arcane-fantasy-sex-toy-from-sinsaint-15bba75 | 2/8/31 |
71049 | feral-handmade-silicone-sex-toy-54bc67 | 2/8/31 |
71612 | titan-body-safe-silicone-dildo-93cf03d | 2/8/31 |
71886 | crystal-handmade-fantasy-toy-1cbf501 | 2/8/31 |