{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "81.06"
},
"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": 124,
"rows_produced_per_join": 124,
"filtered": "100.00",
"index_condition": "((`cscartdb`.`cscart_seo_names`.`object_id` in (36394,36411,36396,36462,36398,36410,36405,36490,36434,36460,36477,36403,36399,36422,36397,36419,36487,36491,36471,36409,36404,36423,36414,36408,36412,36439,36406,36469,36415,36413,36428,36402,36443,36417,36427,36416,36448,36426,36453,36467,36457,36437,36421,36461,36463,36407,36436,36420,36401,36447,36430,36438,36485,36435,36459,36451,36492,36449,36458,36486,36441,36472,36424,36425,36454,36446,36481,36483,36464,36475,36482,36473,36493,36479,36444,36431,36445,36456,36470,36466,36474,36478,36440,36452,36465,36442,36450,36484,36433,36418,36429,36432,36400,36476,36395,36488,36494,36455,36480,36489,36468)) 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": "68.66",
"eval_cost": "12.40",
"prefix_cost": "81.06",
"data_read_per_join": "210K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
36394 | hankeys-toys-atlas-realistic-dildo-sex-toys-82cf279 | 2/8/32 |
36395 | hankeys-toys-largo | 2/8/32 |
36396 | hankeys-toys-seahorse-dildo-fantasy-dildo-sex-toys-558f81d | 2/8/31 |
36397 | hankeys-toys-venomous-tongue | 2/8/31 |
36398 | hankeys-toys-centaur-fantasy-dildo-sex-toys-284fdc1 | 2/8/31 |
36399 | hankeys-toys-goliath | 2/8/32 |
36400 | hankeys-toys-lampwick-uncut | 2/8/32 |
36401 | hankeys-toys-mikey | 2/8/32 |
36402 | hankeys-toys-gut-puncher | 2/8/31 |
36403 | hankeys-toys-rentman | 2/8/32 |
36404 | hankeys-toys-ray-diesel | 2/8/32 |
36405 | hankeys-toys-boss-hogg-realistic-dildo-sex-toys-79f117f | 2/8/32 |
36406 | hankeys-toys-prince-charming | 2/8/31 |
36407 | hankeys-toys-heavy-duty-4-suction-cup | 2/368 |
36408 | hankeys-toys-topher-michels | 2/8/32 |
36409 | hankeys-toys-knaughty-dragon | 2/8/31 |
36410 | hankeys-toys-sigmaloid | 2/8/31 |
36411 | hankeys-toys-lubrication | 92/23 |
36412 | hankeys-toys-sex-machine | 2/8/31 |
36413 | hankeys-captains-hook-fantasy-dildo-sex-toys-64f280f | 2/8/32 |
36414 | hankeys-toys-beowulf | 2/8/31 |
36415 | hankeys-toys-solatok-dildo | 2/8/31 |
36416 | hankeys-toys-machoman | 2/8/32 |
36417 | hankeys-toys-aaron-klein | 2/8/32 |
36418 | hankeys-toys-axel | 2/8/32 |
36419 | hankeys-toys-davys-tendrils | 2/8/31 |
36420 | hankeys-toys-cyrus-king | 2/8/32 |
36421 | hankeys-toys-jack-hunter | 2/8/32 |
36422 | hankeys-toys-mateo | 2/8/32 |
36423 | hankeys-toys-xtra-small-dildo-series-iii | 2/8/32 |
36424 | hankeys-toys-heavy-duty-7-suction-cup | 2/368 |
36425 | hankeys-toys-dominic-pacifico | 2/8/32 |
36426 | hankeys-toys-nick-capra | 2/8/32 |
36427 | hankeys-toys-xtra-small-dildo-series-ii | 2/8/32 |
36428 | hankeys-toys-the-perfect-penis | 2/8/32 |
36429 | hankeys-toys-midass-touch | 2/8/32 |
36430 | hankeys-toys-el-rey | 2/8/32 |
36431 | hankeys-toys-monster-dildo | 2/8/32 |
36432 | hankeys-toys-snorkel | 2/8/32 |
36433 | hankeys-toys-remove-o-balls | 7/90 |
36434 | hankeys-toys-female-scorpion-sex-grinder-19d6349 | 2/12 |
36435 | hankeys-handyman-butt-plug | 2/8/32 |
36436 | hankeys-toys-clyde | 2/8/32 |
36437 | hankeys-toys-hungerff | 2/8/31 |
36438 | hankeys-toys-xxxcalibur-dildo | 2/8/32 |
36439 | hankeys-toys-omega | 2/8/32 |
36440 | hankeys-toys-clip-clop | 2/8/32 |
36441 | hankeys-toys-kthulu | 2/8/31 |
36442 | hankeys-toys-ramrodder | 2/8/32 |
36443 | hankeys-toys-latin-lover | 2/8/32 |
36444 | hankeys-toys-shell-yeah-sticker-packs | 7/90 |
36445 | hankeys-toys-alien-love-sticker-packs | 7/90 |
36446 | hankeys-toys-shell-yeah-t-shirt | 7/90 |
36447 | hankeys-toys-alien-love-t-shirt | 7/90 |
36448 | hankeys-toys-bbc-dildo | 2/8/32 |
36449 | hankeys-toys-the-plumber | 2/8/32 |
36450 | hankeys-toys-lw-tip | 2/8/32 |
36451 | hankeys-toys-chorizo-n-eggs | 2/8/32 |
36452 | hankeys-toys-firehose | 2/8/32 |
36453 | hankeys-toys-kane-korso | 2/8/32 |
36454 | hankeys-toys-cockmaker | 2/8/32 |
36455 | hankeys-toys-isaac-x | 2/8/32 |
36456 | hankeys-toys-thors-hammer | 2/8/32 |
36457 | hankeys-toys-oni | 2/8/31 |
36458 | hankeys-toys-dragon-dildo | 2/8/31 |
36459 | hankeys-toys-bfg | 2/8/31 |
36460 | hankeys-toys-minotaur | 2/8/31 |
36461 | hankeys-toys-ogre | 2/8/31 |
36462 | hankeys-toys-thiago-realistic-dildo-sex-toys-205b241 | 2/8/32 |
36463 | hankeys-toys-kalib | 2/8/31 |
36464 | hankeys-toys-taintacle | 2/8/31 |
36465 | hankeys-toys-beefcake | 2/8/32 |
36466 | hankeys-toys-big-daddy | 2/8/32 |
36467 | hankeys-toys-three-amigos | 2/8/32 |
36468 | hankeys-toys-long-john | 2/8/32 |
36469 | hankeys-toys-scimitar | 2/8/31 |
36470 | hankeys-toys-mr-hankey | 2/8/31 |
36471 | hankeys-toys-corn-dildo | 2/8/31 |
36472 | hankeys-toys-kinky-cra | 2/8/31 |
36473 | hankeys-toys-unicorn-dildo | 2/8/31 |
36474 | hankeys-toys-cockadile | 2/8/31 |
36475 | hankeys-toys-lampwick | 2/8/32 |
36476 | hankeys-toys-michael-vegas | 2/8/32 |
36477 | hankeys-toys-sample-pack | 7/90 |
36478 | hankeys-toys-marco-napoli | 2/8/32 |
36479 | hankeys-toys-can-opener | 2/8/32 |
36480 | hankeys-toys-geoff | 2/8/32 |
36481 | hankeys-toys-stump-n-dump | 2/8/31 |
36482 | hankeys-toys-the-theeng | 2/8/31 |
36483 | hankeys-toys-butt-bolt | 2/8/31 |
36484 | hankeys-toys-tubesteak | 2/8/31 |
36485 | hankeys-toys-thicky-nicky | 2/8/32 |
36486 | hankeys-toys-dildos-and-dragon | 2/8/31 |
36487 | hankeys-toys-assbergé-egg-plug | 2/8/31 |
36488 | hankeys-toys-duke | 2/8/32 |
36489 | hankeys-toys-cruiser | 2/8/32 |
36490 | hankeys-toys-alien-breeder-dildo | 2/8/31 |
36491 | hankeys-toys-xtra-small-dildo-series-i | 2/8/32 |
36492 | hankeys-toys-anaconda | 2/8/31 |
36493 | hankeys-toys-chode-dildo | 2/8/32 |
36494 | hankeys-toys-cholo | 2/8/32 |