Query time 0.00153
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "1.50"
},
"grouping_operation": {
"using_filesort": false,
"nested_loop": [
{
"table": {
"table_name": "cscart_products",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"status"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"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": "5K"
},
"used_columns": [
"product_id",
"lead_time",
"etsy_id",
"product_code",
"product_type",
"status",
"company_id",
"list_price",
"amount",
"weight",
"length",
"width",
"height",
"shipping_freight",
"low_avail_limit",
"timestamp",
"updated_timestamp",
"usergroup_ids",
"is_edp",
"edp_shipping",
"unlimited_download",
"tracking",
"free_shipping",
"zero_price_action",
"is_pbp",
"is_op",
"is_oper",
"is_returnable",
"return_period",
"avail_since",
"out_of_stock_actions",
"localization",
"min_qty",
"max_qty",
"qty_step",
"list_qty_count",
"tax_ids",
"age_verification",
"age_limit",
"options_type",
"exceptions_type",
"details_layout",
"shipping_params",
"facebook_obj_type",
"parent_product_id",
"allow_notes",
"buy_now_url",
"master_product_id",
"master_product_status",
"master_product_offers_count",
"variation_sku",
"has_color",
"color_feature_id",
"featured",
"shopify_parent_product_id",
"shopify_variant_product_id"
]
}
},
{
"table": {
"table_name": "popularity",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"total"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"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": "32"
},
"used_columns": [
"product_id",
"total"
]
}
},
{
"table": {
"table_name": "cscart_product_sales",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"pa"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id",
"product_id"
],
"key_length": "6",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 0,
"rows_produced_per_join": 1,
"filtered": "0.00",
"unique_row_not_found": true,
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.10",
"prefix_cost": "0.00",
"data_read_per_join": "16"
},
"used_columns": [
"category_id",
"product_id",
"amount"
]
}
},
{
"table": {
"table_name": "cscart_product_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": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.25",
"eval_cost": "0.10",
"prefix_cost": "0.35",
"data_read_per_join": "24"
},
"used_columns": [
"product_id",
"price",
"percentage_discount",
"lower_limit",
"usergroup_id"
],
"attached_condition": "<if>(is_not_null_compl(cscart_product_prices), ((`cscartdb`.`cscart_product_prices`.`lower_limit` = 1) and (`cscartdb`.`cscart_product_prices`.`usergroup_id` in (0,0,1))), true)"
}
},
{
"table": {
"table_name": "cscart_product_descriptions",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"product_id"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id",
"lang_code"
],
"key_length": "9",
"ref": [
"const",
"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.45",
"data_read_per_join": "3K"
},
"used_columns": [
"product_id",
"lang_code",
"product",
"shortname",
"short_description",
"full_description",
"meta_keywords",
"meta_description",
"search_words",
"page_title",
"age_warning_message",
"promo_text",
"stop_words"
]
}
},
{
"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.55",
"data_read_per_join": "15K"
},
"used_columns": [
"company_id",
"status",
"company",
"discreet_shipping"
],
"attached_condition": "<if>(found_match(companies), ((`cscartdb`.`companies`.`status` = 'A') or false), true)"
}
},
{
"table": {
"table_name": "cscart_products_categories",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"pt"
],
"key": "pt",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 2,
"rows_produced_per_join": 2,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.50",
"eval_cost": "0.20",
"prefix_cost": "1.25",
"data_read_per_join": "32"
},
"used_columns": [
"product_id",
"category_id",
"link_type",
"category_position"
]
}
},
{
"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.cscart_products_categories.category_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "5.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.01",
"prefix_cost": "1.45",
"data_read_per_join": "344"
},
"used_columns": [
"category_id",
"storefront_id",
"usergroup_ids",
"status"
],
"attached_condition": "((`cscartdb`.`cscart_categories`.`storefront_id` in (0,1)) and ((`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')))"
}
},
{
"table": {
"table_name": "cscart_seo_names",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"dispatch"
],
"key": "PRIMARY",
"used_key_parts": [
"object_id",
"type",
"dispatch",
"lang_code"
],
"key_length": "206",
"ref": [
"const",
"const",
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.03",
"eval_cost": "0.01",
"prefix_cost": "1.49",
"data_read_per_join": "173"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
},
{
"table": {
"table_name": "cscart_discussion",
"access_type": "const",
"possible_keys": [
"object_id"
],
"key": "object_id",
"used_key_parts": [
"object_id",
"object_type"
],
"key_length": "6",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.01",
"prefix_cost": "1.50",
"data_read_per_join": "2"
},
"used_columns": [
"object_id",
"object_type",
"type"
]
}
},
{
"table": {
"table_name": "cscart_product_review_prepared_data",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id",
"storefront_id"
],
"key_length": "7",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.01",
"prefix_cost": "1.51",
"data_read_per_join": "1"
},
"used_columns": [
"product_id",
"storefront_id",
"average_rating",
"reviews_count"
]
}
}
]
}
}
}
Result
| product_id |
lead_time |
etsy_id |
product_code |
product_type |
status |
company_id |
list_price |
amount |
weight |
length |
width |
height |
shipping_freight |
low_avail_limit |
timestamp |
updated_timestamp |
usergroup_ids |
is_edp |
edp_shipping |
unlimited_download |
tracking |
free_shipping |
zero_price_action |
is_pbp |
is_op |
is_oper |
is_returnable |
return_period |
avail_since |
out_of_stock_actions |
localization |
min_qty |
max_qty |
qty_step |
list_qty_count |
tax_ids |
age_verification |
age_limit |
options_type |
exceptions_type |
details_layout |
shipping_params |
facebook_obj_type |
parent_product_id |
allow_notes |
buy_now_url |
master_product_id |
master_product_status |
master_product_offers_count |
variation_sku |
has_color |
color_feature_id |
featured |
shopify_parent_product_id |
shopify_variant_product_id |
lang_code |
product |
shortname |
short_description |
full_description |
meta_keywords |
meta_description |
search_words |
page_title |
age_warning_message |
promo_text |
stop_words |
price |
category_ids |
popularity |
company_name |
sales_amount |
seo_name |
seo_path |
discussion_type |
average_rating |
product_reviews_count |
company_discreet_shipping |
| 8024 |
21 |
|
Bit-Gag-Wood |
P |
A |
63 |
0.00 |
1000 |
0.625 |
0 |
0 |
0 |
0.00 |
0 |
1710882891 |
1710882920 |
0 |
N |
N |
N |
|
Y |
|
N |
N |
N |
Y |
10 |
0 |
N |
|
|
|
|
|
|
N |
0 |
|
|
|
a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} |
activity |
0 |
Y |
|
0 |
A |
0 |
|
0 |
|
0 |
|
|
en |
BDSM Bit Gag | Leather Bondage Gag, Wooden BDSM Gag for Pony Play, Submissive toys for Pet Play, DDlG, Femdom Slave Fetish | LVX Supply |
|
|
Whether you're just starting in the world of gags, or are a seasoned Pony, this bit gag is simple, elegant, while fast and easy to use.
To Use Simply:
• Hold the bit in mouth
• Loop the D rings over the bit ends
• Buckle the strap around the head. *
▸ 100% Custom - Made to Order - Just for You!
We love making sure that you get exactly the perfect look and fit. Measure your muzzle (with the mouth closed), and send us the measurement for a free custom fit! When properly sized, there is absolutely no chance that the bit can fall or be pushed out.
→ Place the muzzle measurement in the notes (or a message), and we'll custom make your piece for the perfect look and fit.
▸ The Bit Collar:
• Custom made and hand dyed from start to finish from the highest quality of full grain leather.
• Backed with soft supple suede that prevents slipping.
• Featured with your choice of brass, nickel, or matte hardware.
The Carved Bit:
Designed for easy cleaning and replacing, as well as future upgrades without needing a new strap. The bit is carved from Poplar, a medium/soft hardwood found frequently in teething toys for children. A far safer for your teeth than many of the other options. As with anything that goes in your mouth, we try to build with the finest and most safe materials, however the user assumes all risk in use. In the end, it is still an item that will be bitten, be safe and smart about how you do so!
■ DETAILS:
• (1) 5/8"" wide Bit Collar:
Features a suede lined interior and full grain leather outer and (2) D-rings.
• (1) 3/4" Diameter hand carved and food safe finished wooden bit.
• You can also order extra bits by selecting from the options menu this listing!
▌ SIZE:
• Small= 16-18"
• Medium = 19-21"
• Large = 22"-24"
• Custom = add to notes (always preferred for the perfect fit!)
▌ LEATHER COLOR:
• Natural
• Black
• Purple
• Lt Brown
• Med Brown
• Mahogany
• Red
• Oxblood (Pink)
▌ HARDWARE:
• Brass
• Nickel Polished
• Nickel Matte
Handmade BDSM Bondage Restraints, Paddles, Leather, and more from Richmond, Virginia. Local pick up available, just message for details! Thanks for looking! |
|
|
bondage toys,bdsm toys,fetish toys,leather bondage,wooden bit gag,pony play,bdsm gag collar,bondage gag,bdsm bit gag,ball gag,bondage bdsm gag,submissive bdsm gear,USA Handmade |
|
|
|
|
80.00000000 |
16M,353 |
4466 |
LVX Supply & Co. |
|
bdsm-bit-gag-leather-bondage-gag-wooden-bdsm-gag-for-pony-play-submissive-toys-for-pet-play-ddlg-femdom-slave-fetish-lvx-supply-en |
4/16 |
|
|
|
Y |