Query time 0.05965
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "3092.60"
},
"ordering_operation": {
"using_filesort": true,
"grouping_operation": {
"using_temporary_table": true,
"using_filesort": false,
"nested_loop": [
{
"table": {
"table_name": "companies",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id"
],
"key_length": "4",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.10",
"prefix_cost": "0.00",
"data_read_per_join": "15K"
},
"used_columns": [
"company_id",
"status",
"company",
"discreet_shipping"
]
}
},
{
"table": {
"table_name": "products",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"status",
"idx_parent_product_id"
],
"key": "idx_parent_product_id",
"used_key_parts": [
"parent_product_id"
],
"key_length": "4",
"ref": [
"const"
],
"rows_examined_per_scan": 15524,
"rows_produced_per_join": 305,
"filtered": "1.97",
"cost_info": {
"read_cost": "884.27",
"eval_cost": "30.53",
"prefix_cost": "2436.68",
"data_read_per_join": "1M"
},
"used_columns": [
"product_id",
"product_type",
"status",
"company_id",
"amount",
"usergroup_ids",
"parent_product_id",
"variation_sku"
],
"attached_condition": "((`cscartdb`.`products`.`company_id` = 265) and (`cscartdb`.`products`.`amount` > 0) and ((`cscartdb`.`products`.`usergroup_ids` = '') or (0 <> find_in_set(0,`cscartdb`.`products`.`usergroup_ids`)) or (0 <> find_in_set(1,`cscartdb`.`products`.`usergroup_ids`))) and (`cscartdb`.`products`.`status` = 'A'))"
}
},
{
"table": {
"table_name": "prices",
"access_type": "ref",
"possible_keys": [
"usergroup",
"product_id",
"lower_limit",
"usergroup_id"
],
"key": "product_id",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"cscartdb.products.product_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 305,
"filtered": "99.99",
"cost_info": {
"read_cost": "76.33",
"eval_cost": "30.53",
"prefix_cost": "2543.53",
"data_read_per_join": "7K"
},
"used_columns": [
"product_id",
"lower_limit",
"usergroup_id"
],
"attached_condition": "((`cscartdb`.`prices`.`lower_limit` = 1) and (`cscartdb`.`prices`.`usergroup_id` in (0,0,1)))"
}
},
{
"table": {
"table_name": "popularity",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"total"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"cscartdb.products.product_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 305,
"filtered": "100.00",
"cost_info": {
"read_cost": "76.32",
"eval_cost": "30.53",
"prefix_cost": "2650.38",
"data_read_per_join": "9K"
},
"used_columns": [
"product_id",
"total"
]
}
},
{
"table": {
"table_name": "products_categories",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"pt"
],
"key": "pt",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"cscartdb.products.product_id"
],
"rows_examined_per_scan": 2,
"rows_produced_per_join": 610,
"filtered": "100.00",
"cost_info": {
"read_cost": "152.64",
"eval_cost": "61.06",
"prefix_cost": "2864.08",
"data_read_per_join": "9K"
},
"used_columns": [
"product_id",
"category_id"
]
}
},
{
"table": {
"table_name": "cscart_categories",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"c_status",
"p_category_id"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"ref": [
"cscartdb.products_categories.category_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 30,
"filtered": "5.00",
"cost_info": {
"read_cost": "152.64",
"eval_cost": "3.05",
"prefix_cost": "3077.77",
"data_read_per_join": "102K"
},
"used_columns": [
"category_id",
"storefront_id",
"usergroup_ids",
"status"
],
"attached_condition": "(((`cscartdb`.`cscart_categories`.`usergroup_ids` = '') or (0 <> find_in_set(0,`cscartdb`.`cscart_categories`.`usergroup_ids`)) or (0 <> find_in_set(1,`cscartdb`.`cscart_categories`.`usergroup_ids`))) and (`cscartdb`.`cscart_categories`.`status` in ('A','H')) and (`cscartdb`.`cscart_categories`.`storefront_id` in (0,1)))"
}
},
{
"table": {
"table_name": "descr1",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"product_id"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id",
"lang_code"
],
"key_length": "9",
"ref": [
"cscartdb.products.product_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 30,
"filtered": "100.00",
"cost_info": {
"read_cost": "11.78",
"eval_cost": "3.05",
"prefix_cost": "3092.60",
"data_read_per_join": "116K"
},
"used_columns": [
"product_id",
"lang_code",
"product"
]
}
}
]
}
}
}
}
Result
product_id |
product |
company_name |
product_type |
parent_product_id |
variation_sku |
company_discreet_shipping |
36394 |
Hankey's Toys Atlas-Realistic Dildo-Sex Toys |
Mr Hankeys Toys |
P |
0 |
91 |
Y |
36411 |
Hankey's Toys Lubrication |
Mr Hankeys Toys |
P |
0 |
28 |
Y |
36396 |
Hankey's Toys Seahorse Dildo-Fantasy Dildo-Sex Toys |
Mr Hankeys Toys |
P |
0 |
77 |
Y |
36462 |
Hankey's Toys Thiago-Realistic Dildo-Sex Toys |
Mr Hankeys Toys |
P |
0 |
_33 |
Y |
36398 |
Hankey's Toys Centaur-Fantasy Dildo-Sex Toys |
Mr Hankeys Toys |
P |
0 |
21 |
Y |
36410 |
Hankey's Toys Sigmaloid |
Mr Hankeys Toys |
P |
0 |
80 |
Y |
36405 |
Hankey's Toys Boss Hogg-Realistic Dildo-Sex Toys |
Mr Hankeys Toys |
P |
0 |
53 |
Y |
36490 |
Hankey's Toys Alien Breeder Dildo |
Mr Hankeys Toys |
P |
0 |
_5 |
Y |
36477 |
Hankey's Toys Sample Pack |
Mr Hankeys Toys |
P |
0 |
|
Y |
36434 |
Hankey's Toys Female Scorpion Sex Grinder |
Mr Hankeys Toys |
P |
0 |
_61 |
Y |
36460 |
Hankey's Toys Minotaur |
Mr Hankeys Toys |
P |
0 |
_35 |
Y |
36403 |
Hankey's Toys Rentman |
Mr Hankeys Toys |
P |
0 |
56 |
Y |
36399 |
Hankey's Toys Goliath |
Mr Hankeys Toys |
P |
0 |
30 |
Y |
36422 |
Hankey's Toys Mateo |
Mr Hankeys Toys |
P |
0 |
65 |
Y |
36397 |
Hankey's Toys Venomous Tongue |
Mr Hankeys Toys |
P |
0 |
95 |
Y |
36419 |
Hankey's Toys Davy's Tendrils |
Mr Hankeys Toys |
P |
0 |
_76 |
Y |
36487 |
Hankey's Toys Assbergé Egg Plug |
Mr Hankeys Toys |
P |
0 |
_8 |
Y |
36491 |
Hankey's Toys Xtra-Small Dildo Series I |
Mr Hankeys Toys |
P |
0 |
_4 |
Y |
36471 |
Hankey's Toys Corn Dildo |
Mr Hankeys Toys |
P |
0 |
_24 |
Y |
36409 |
Hankey's Toys Knaughty Dragon |
Mr Hankeys Toys |
P |
0 |
1325 |
Y |
36404 |
Hankey's Toys Ray Diesel |
Mr Hankeys Toys |
P |
0 |
36 |
Y |
36423 |
Hankey's Toys Xtra-Small Dildo Series III |
Mr Hankeys Toys |
P |
0 |
_72 |
Y |
36414 |
Hankey's Toys Beowulf |
Mr Hankeys Toys |
P |
0 |
73 |
Y |
36408 |
Hankey's Toys Topher Michels |
Mr Hankeys Toys |
P |
0 |
59 |
Y |
36412 |
Hankey's Toys Sex Machine |
Mr Hankeys Toys |
P |
0 |
834 |
Y |
36439 |
Hankey's Toys Omega |
Mr Hankeys Toys |
P |
0 |
564 |
Y |
36406 |
Hankey's Toys Prince Charming |
Mr Hankeys Toys |
P |
0 |
20 |
Y |
36469 |
Hankey's Toys Scimitar |
Mr Hankeys Toys |
P |
0 |
_26 |
Y |
36415 |
Hankey's Toys Solatok Dildo |
Mr Hankeys Toys |
P |
0 |
75 |
Y |
36413 |
Hankey's Captain's Hook-Fantasy Dildo-Sex Toys |
Mr Hankeys Toys |
P |
0 |
519 |
Y |
36428 |
Hankey's Toys The Perfect Penis |
Mr Hankeys Toys |
P |
0 |
975 |
Y |
36402 |
Hankey's Toys Gut Puncher |
Mr Hankeys Toys |
P |
0 |
97 |
Y |
36443 |
Hankey's Toys Latin Lover |
Mr Hankeys Toys |
P |
0 |
62 |
Y |
36417 |
Hankey's Toys Aaron Klein |
Mr Hankeys Toys |
P |
0 |
266 |
Y |
36427 |
Hankey's Toys Xtra-Small Dildo Series II |
Mr Hankeys Toys |
P |
0 |
_68 |
Y |
36416 |
Hankey's Toys Machoman |
Mr Hankeys Toys |
P |
0 |
14 |
Y |
36448 |
Hankey's Toys BBC Dildo |
Mr Hankeys Toys |
P |
0 |
1262 |
Y |
36453 |
Hankey's Toys Kane Korso |
Mr Hankeys Toys |
P |
0 |
_42 |
Y |
36426 |
Hankey's Toys Nick Capra |
Mr Hankeys Toys |
P |
0 |
56 |
Y |
36467 |
Hankey's Toys Three Amigos |
Mr Hankeys Toys |
P |
0 |
_28 |
Y |
36457 |
Hankey's Toys Oni |
Mr Hankeys Toys |
P |
0 |
_38 |
Y |
36437 |
Hankey's Toys HungerFF |
Mr Hankeys Toys |
P |
0 |
858 |
Y |
36421 |
Hankey's Toys Jack Hunter |
Mr Hankeys Toys |
P |
0 |
243 |
Y |
36461 |
Hankey's Toys Ogre |
Mr Hankeys Toys |
P |
0 |
_34 |
Y |
36463 |
Hankey's Toys Kalib |
Mr Hankeys Toys |
P |
0 |
_32 |
Y |
36407 |
Hankey's Toys Heavy Duty 4" Suction Cup |
Mr Hankeys Toys |
P |
0 |
|
Y |
36436 |
Hankey's Toys Clyde |
Mr Hankeys Toys |
P |
0 |
78 |
Y |
36420 |
Hankey's Toys Cyrus King |
Mr Hankeys Toys |
P |
0 |
57 |
Y |
36401 |
Hankey's Toys Mikey |
Mr Hankeys Toys |
P |
0 |
264 |
Y |
36447 |
Hankey's Toys Alien Love T-shirt |
Mr Hankeys Toys |
P |
0 |
1340 |
Y |
36430 |
Hankey's Toys El Rey |
Mr Hankeys Toys |
P |
0 |
38 |
Y |
36438 |
Hankey's Toys XXXCalibur Dildo |
Mr Hankeys Toys |
P |
0 |
35 |
Y |
36485 |
Hankey's Toys Thicky Nicky |
Mr Hankeys Toys |
P |
0 |
_10 |
Y |
36435 |
Hankey's Handyman Butt Plug |
Mr Hankeys Toys |
P |
0 |
514 |
Y |
36459 |
Hankey's Toys BFG |
Mr Hankeys Toys |
P |
0 |
_36 |
Y |
36451 |
Hankey's Toys Chorizo N' Eggs |
Mr Hankeys Toys |
P |
0 |
_44 |
Y |
36492 |
Hankey's Toys Anaconda |
Mr Hankeys Toys |
P |
0 |
_3 |
Y |
36449 |
Hankey's Toys The Plumber |
Mr Hankeys Toys |
P |
0 |
68 |
Y |
36458 |
Hankey's Toys Dragon Dildo |
Mr Hankeys Toys |
P |
0 |
_37 |
Y |
36486 |
Hankey's Toys Dildos & Dragon |
Mr Hankeys Toys |
P |
0 |
_9 |
Y |
36441 |
Hankey's Toys Kthulu |
Mr Hankeys Toys |
P |
0 |
94 |
Y |
36472 |
Hankey's Toys Kinky Cobra |
Mr Hankeys Toys |
P |
0 |
_23 |
Y |
36446 |
Hankey's Toys Shell Yeah! T-shirt |
Mr Hankeys Toys |
P |
0 |
_49 |
Y |
36424 |
Hankey's Toys Heavy Duty 7" Suction Cup |
Mr Hankeys Toys |
P |
0 |
|
Y |
36481 |
Hankey's Toys Stump N' Dump |
Mr Hankeys Toys |
P |
0 |
|
Y |
36425 |
Hankey's Toys Dominic Pacifico |
Mr Hankeys Toys |
P |
0 |
76 |
Y |
36454 |
Hankey's Toys @Cockmaker |
Mr Hankeys Toys |
P |
0 |
_41 |
Y |
36483 |
Hankey's Toys Butt Bolt |
Mr Hankeys Toys |
P |
0 |
_12 |
Y |
36464 |
Hankey's Toys Taintacle |
Mr Hankeys Toys |
P |
0 |
_31 |
Y |
36475 |
Hankey's Toys Lampwick |
Mr Hankeys Toys |
P |
0 |
_20 |
Y |
36482 |
Hankey's Toys The Theeng |
Mr Hankeys Toys |
P |
0 |
_13 |
Y |
36473 |
Hankey's Toys Unicorn Dildo |
Mr Hankeys Toys |
P |
0 |
_22 |
Y |
36493 |
Hankey's Toys Chode Dildo |
Mr Hankeys Toys |
P |
0 |
|
Y |
36444 |
Hankey's Toys Shell Yeah! Sticker Packs |
Mr Hankeys Toys |
P |
0 |
|
Y |
36479 |
Hankey's Toys Can Opener |
Mr Hankeys Toys |
P |
0 |
|
Y |
36445 |
Hankey's Toys Alien Love Sticker Packs |
Mr Hankeys Toys |
P |
0 |
|
Y |
36431 |
Hankey's Toys Monster Dildo |
Mr Hankeys Toys |
P |
0 |
1039 |
Y |
36474 |
Hankey's Toys Cockadile |
Mr Hankeys Toys |
P |
0 |
_21 |
Y |
36456 |
Hankey's Toys Thor's Hammer |
Mr Hankeys Toys |
P |
0 |
|
Y |
36470 |
Hankey's Toys Mr. Hankey |
Mr Hankeys Toys |
P |
0 |
|
Y |
36466 |
Hankey's Toys Big Daddy |
Mr Hankeys Toys |
P |
0 |
_29 |
Y |
36478 |
Hankey's Toys Marco Napoli |
Mr Hankeys Toys |
P |
0 |
_17 |
Y |
36440 |
Hankey's Toys Clip-Clop |
Mr Hankeys Toys |
P |
0 |
108 |
Y |
36452 |
Hankey's Toys Firehose |
Mr Hankeys Toys |
P |
0 |
|
Y |
36465 |
Hankey's Toys Beefcake |
Mr Hankeys Toys |
P |
0 |
_30 |
Y |
36442 |
Hankey's Toys Ramrodder |
Mr Hankeys Toys |
P |
0 |
|
Y |
36450 |
Hankey's Toys LW Tip |
Mr Hankeys Toys |
P |
0 |
66 |
Y |
36484 |
Hankey's Toys Tubesteak |
Mr Hankeys Toys |
P |
0 |
|
Y |
36433 |
Hankey's Toys Remove-O-Balls |
Mr Hankeys Toys |
P |
0 |
|
Y |
36418 |
Hankey's Toys Axel |
Mr Hankeys Toys |
P |
0 |
92 |
Y |
36429 |
Hankey's Toys Midass Touch |
Mr Hankeys Toys |
P |
0 |
73 |
Y |
36432 |
Hankey's Toys Snorkel |
Mr Hankeys Toys |
P |
0 |
|
Y |
36400 |
Hankey's Toys Lampwick Uncut |
Mr Hankeys Toys |
P |
0 |
80 |
Y |
36476 |
Hankey's Toys Michael Vegas |
Mr Hankeys Toys |
P |
0 |
_19 |
Y |
36395 |
Hankey's Toys Largo |
Mr Hankeys Toys |
P |
0 |
|
Y |
36488 |
Hankey's Toys Duke |
Mr Hankeys Toys |
P |
0 |
_7 |
Y |
36494 |
Hankey's Toys Cholo |
Mr Hankeys Toys |
P |
0 |
|
Y |
36455 |
Hankey's Toys Isaac X |
Mr Hankeys Toys |
P |
0 |
_40 |
Y |
36480 |
Hankey's Toys Geoff |
Mr Hankeys Toys |
P |
0 |
|
Y |
36489 |
Hankey's Toys Cruiser |
Mr Hankeys Toys |
P |
0 |
|
Y |
36468 |
Hankey's Toys Long John |
Mr Hankeys Toys |
P |
0 |
|
Y |