Query time 0.00502
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "26.01"
},
"ordering_operation": {
"using_filesort": true,
"grouping_operation": {
"using_temporary_table": true,
"using_filesort": false,
"nested_loop": [
{
"table": {
"table_name": "cscart_categories",
"access_type": "range",
"possible_keys": [
"PRIMARY",
"c_status",
"p_category_id"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"rows_examined_per_scan": 2,
"rows_produced_per_join": 0,
"filtered": "4.00",
"index_condition": "(`cscartdb`.`cscart_categories`.`category_id` in (90,132))",
"cost_info": {
"read_cost": "1.40",
"eval_cost": "0.01",
"prefix_cost": "1.41",
"data_read_per_join": "275"
},
"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": "products_categories",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"pt"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"ref": [
"cscartdb.cscart_categories.category_id"
],
"rows_examined_per_scan": 623,
"rows_produced_per_join": 49,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "0.33",
"eval_cost": "4.98",
"prefix_cost": "6.73",
"data_read_per_join": "797"
},
"used_columns": [
"product_id",
"category_id"
]
}
},
{
"table": {
"table_name": "products",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"status",
"idx_parent_product_id"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"cscartdb.products_categories.product_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 4,
"filtered": "8.63",
"cost_info": {
"read_cost": "12.46",
"eval_cost": "0.43",
"prefix_cost": "24.17",
"data_read_per_join": "23K"
},
"used_columns": [
"product_id",
"product_type",
"status",
"company_id",
"amount",
"usergroup_ids",
"parent_product_id",
"variation_sku"
],
"attached_condition": "((`cscartdb`.`products`.`parent_product_id` = 0) 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": "companies",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id"
],
"key_length": "4",
"ref": [
"cscartdb.products.company_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "5.00",
"cost_info": {
"read_cost": "1.08",
"eval_cost": "0.02",
"prefix_cost": "25.67",
"data_read_per_join": "3K"
},
"used_columns": [
"company_id",
"status",
"company",
"discreet_shipping",
"vacation_mode"
],
"attached_condition": "((`cscartdb`.`companies`.`vacation_mode` = 0) and (`cscartdb`.`companies`.`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_categories.product_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "99.99",
"cost_info": {
"read_cost": "0.05",
"eval_cost": "0.02",
"prefix_cost": "25.75",
"data_read_per_join": "5"
},
"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_categories.product_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.05",
"eval_cost": "0.02",
"prefix_cost": "25.83",
"data_read_per_join": "6"
},
"used_columns": [
"product_id",
"total"
]
}
},
{
"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_categories.product_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.17",
"eval_cost": "0.02",
"prefix_cost": "26.01",
"data_read_per_join": "841"
},
"used_columns": [
"product_id",
"lang_code",
"product"
]
}
}
]
}
}
}
}
Result
product_id |
product |
company_name |
product_type |
parent_product_id |
variation_sku |
company_discreet_shipping |
32323 |
Dr Who River Song Hello Sweetie kiss nerdy doormat geekery BBC tardis the doctor Whovian wedding gift party decor porch melody pond doormatt |
Damn Good Doormats |
P |
0 |
|
N |
32860 |
Sith happens funny doormat darth vader gift for geeks nerd humor yoda housewarming nerd alert force awakens doormatt |
Damn Good Doormats |
P |
0 |
|
N |
33340 |
You're so vain all weather doormat funny rude doormat carly simon housewarming gift welcome mat eco friendly funny doormat go away doormatt |
Damn Good Doormats |
P |
0 |
|
N |
32306 |
Beware of the BLONDE™ GINGER guy is cool funny rude doormat kids pet cat dog wedding housewarming hostess gift doormatt Mother's Day gift |
Damn Good Doormats |
P |
0 |
|
N |
33011 |
Leave it at the doorstep and get the Hell outta here home alone doormat door mat go away leave packages UPS amazon prime |
Damn Good Doormats |
P |
0 |
|
N |
33044 |
Ghostbusters I am the Gatekeeper funny nerdy doormat housewarming gift welcome mat doormatt new house gift |
Damn Good Doormats |
P |
0 |
|
N |
36695 |
Holographic Glitter BDSM Triskelion sticker |
Maenad Press |
P |
0 |
|
Y |
55977 |
The Brat Diaries - Signed Copy |
Lustcraft |
P |
0 |
|
Y |
33339 |
You are exactly where you need to be housewarming doormat welcome mat meditation thankful hostess anniversary |
Damn Good Doormats |
P |
0 |
|
N |
33023 |
ITALIC Oh Shit- not you again funny welcome mat rude doormat go away eco friendly door mat offensive doormatt new house gift |
Damn Good Doormats |
P |
0 |
|
N |
32308 |
Party's in the back Mullet doormat | funny redneck gift | Damn Good Doormats 0+ |
Damn Good Doormats |
P |
0 |
|
N |
32851 |
Merry Fuckin Christmas doormat | F Bomb rude funny doormatt | Damn Good Doormats |
Damn Good Doormats |
P |
0 |
|
N |
40913 |
Evil Genius Mistress's key box |
Evil Genius Design |
P |
0 |
|
Y |
40917 |
Evil Genius Box of F**cks 2 |
Evil Genius Design |
P |
0 |
|
Y |
33351 |
Bad Hombres AND Nasty Women resist doormat feminism liberal democrat politics gift lady boss mueller time |
Damn Good Doormats |
P |
0 |
|
N |
33034 |
no riff raff Fawlty Towers Monty Python funny doormat rude doormat britcom british humor humour comedy BBC doormatt new house gift |
Damn Good Doormats |
P |
0 |
|
N |
33309 |
Stay Awhile and Listen campfire doormat -novelty geek stuff fan art |
Damn Good Doormats |
P |
0 |
|
N |
33336 |
CAUTION Bear in area | Funny doormat | LGBTQ | Damn Good Doormats |
Damn Good Doormats |
P |
0 |
|
N |
33048 |
mantra- Leave your worries on the doorstep- head space doormat doormatt new house gift zen mindful mindfulness mindfull |
Damn Good Doormats |
P |
0 |
|
N |
33191 |
Leave your situations at the door door mat Mary J Blige doormat doormat personalized doormatt new house gift |
Damn Good Doormats |
P |
0 |
|
N |
33030 |
Abandon Hope all ye who enter here | Halloween doormat | | Damn Good Doormats * |
Damn Good Doormats |
P |
0 |
|
N |
32856 |
get the fuck out of here funny route Doormats housewarming gift rude go away sign boyfriend gift doormatt new house gift |
Damn Good Doormats |
P |
0 |
|
N |
33052 |
The Dude abides and this is where he resides, The Big Lebowski Door mat, eco friendly, movie geek gift, houseware, Dudeism |
Damn Good Doormats |
P |
0 |
|
N |
33311 |
Welcome to our Stabbin Cabin Doormat funny rude sex time bachelor party decor doormatt new house gift obscene mat () |
Damn Good Doormats |
P |
0 |
|
N |
40914 |
Evil Genius Master's key box |
Evil Genius Design |
P |
0 |
|
Y |
32877 |
This house is Pussy Protected doormat cat lady door mat gifts for cat people doormat |
Damn Good Doormats |
P |
0 |
|
N |
33033 |
Witch her Familiar live here | Halloween doormat | Black cat Gothic Home decor | dark arts gifts for cat people | Gothic wedding gift |
Damn Good Doormats |
P |
0 |
|
N |
33041 |
Stay ... Leave. Welcome/ UnWelcome doormat funny rude doormat doormatt new house gift obscene mat Mother's Day gift |
Damn Good Doormats |
P |
0 |
|
N |
17195 |
Wet Pussy Creampie Hand Soap |
The Kinky Peach |
P |
0 |
|
Y |
32861 |
the malinois already knows you're here | Belgian Shepherd | Dog Mom gift | Damn Good Doormats |
Damn Good Doormats |
P |
0 |
|
N |
33039 |
By Appointment Only funny go away doormat do not disturb boyfriend no salesmen doormatt new house gift |
Damn Good Doormats |
P |
0 |
|
N |
33354 |
Two Buck Chuck doormat Welcome mat wine lover funny doormat trader joes cheap drinks Door Mat housewarming Wine Gift Winery doormatt |
Damn Good Doormats |
P |
0 |
|
N |
32876 |
Schadenfreude for everyone!™ funny pleasure of pain doormat German resist doormatt new house gift |
Damn Good Doormats |
P |
0 |
|
N |
33345 |
Norwegian- Uff Da Du Igjen Oh Shit not you again funny rude go away doormat scandanavian decor |
Damn Good Doormats |
P |
0 |
|
N |
33178 |
Boo. | Halloween doormat | skinny thin cute door mat | Damn Good Doormats * |
Damn Good Doormats |
P |
0 |
|
N |
36711 |
Ballet Boot handmade lino print card with envelope |
Maenad Press |
P |
0 |
|
Y |
33352 |
ASL Fuck OFF rude doormat | American sign language deaf culture | funny offensive rude doormat go away () |
Damn Good Doormats |
P |
0 |
|
N |
33346 |
Ready Player One 1 Welcome to the Oasis nerdy doormat steven spielberg scifi movie retro video game welcome mat eco friendly doormatt |
Damn Good Doormats |
P |
0 |
|
N |
33323 |
a pilot / gamer/ coder and a normal person live here funny aviation custom hand painted doormat plane boyfriend gift new house gift |
Damn Good Doormats |
P |
0 |
|
N |
35234 |
Merry Christmas Babygirl ornament, DDlg Christmas gift, Babygirl gift, DDlg sub ornament, Mdlg gift, 2022 charm, wording can be customized |
TheTwistedScrew |
P |
0 |
|
Y |
33042 |
Smile you’re on camera! Security sign PORCH PIRATE rude funny housewarming doormat Boyfriend gift eco-friendly realtor closing |
Damn Good Doormats |
P |
0 |
|
N |
33009 |
Haste Ye Back/ British come back sign / funny doormat rude door mat Welcome mat housewarming gifts new house gift |
Damn Good Doormats |
P |
0 |
|
N |
33316 |
Heathens Welcome doormat | Norse Pagan mythology | Viking gift for him | Damn Good Doormats * |
Damn Good Doormats |
P |
0 |
|
N |
36690 |
Holographic BDSM Triskelion sticker |
Maenad Press |
P |
0 |
|
Y |
67462 |
NIPPLE CLAMPS with 3 HEAVY Chains BLACK or WHITE Clamps Sex toys Restraints Body Jewelry Nipple Clamps Sensation Play bdsm Bondage |
SPANK U TOYS. LLC |
P |
0 |
_7 |
Y |
32852 |
Dave's not here Pot leaf decor marijuana cheech and chong bong door mat funny weed doormat boyfriend chill spot gift doormatt |
Damn Good Doormats |
P |
0 |
|
N |
36682 |
BDSM Triskelion sticker set of 2 |
Maenad Press |
P |
0 |
|
Y |
33040 |
Attention CHAT LUNATIQUE warning crazy cat cat lover cat lady funny door mat french doormat gifts for cat people doormatt |
Damn Good Doormats |
P |
0 |
|
N |
36686 |
Ballet Boot sticker |
Maenad Press |
P |
0 |
|
Y |
35216 |
Funny Spanking Ornament, DDlg Christmas, BDSM spanking humor, over Daddy's lap, snowflake & bead included, DDlg decor, handstamped, spank me |
TheTwistedScrew |
P |
0 |
|
Y |