Query time 0.00307
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "5.21"
},
"grouping_operation": {
"using_filesort": false,
"nested_loop": [
{
"table": {
"table_name": "products",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"status",
"idx_company_id",
"idx_usergroup_ids"
],
"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": "4K"
},
"used_columns": [
"product_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",
"weight_lbs",
"weight_oz",
"product_tax_code",
"deleted_at",
"archived_at",
"position"
]
}
},
{
"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": "cd",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id",
"lang_code"
],
"key_length": "10",
"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.00",
"data_read_per_join": "1K"
},
"used_columns": [
"company_id",
"lang_code",
"terms"
]
}
},
{
"table": {
"table_name": "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(product_prices), ((`goimagine`.`product_prices`.`lower_limit` = 1) and (`goimagine`.`product_prices`.`usergroup_id` in (0,0,1))), true)"
}
},
{
"table": {
"table_name": "product_descriptions",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"product_id"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id",
"lang_code"
],
"key_length": "11",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.64",
"eval_cost": "0.10",
"prefix_cost": "1.09",
"data_read_per_join": "5K"
},
"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",
"cls_stop_words",
"how_its_made",
"custom_header"
]
}
},
{
"table": {
"table_name": "company_descr",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id",
"lang_code"
],
"key_length": "10",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.89",
"eval_cost": "0.10",
"prefix_cost": "2.08",
"data_read_per_join": "1K"
},
"used_columns": [
"company_id",
"lang_code",
"i18n_company"
]
}
},
{
"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.68",
"eval_cost": "0.10",
"prefix_cost": "2.86",
"data_read_per_join": "14K"
},
"used_columns": [
"company_id",
"status"
],
"attached_condition": "<if>(found_match(companies), ((`goimagine`.`companies`.`status` = 'A') or false), true)"
}
},
{
"table": {
"table_name": "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": 3,
"rows_produced_per_join": 3,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.75",
"eval_cost": "0.30",
"prefix_cost": "3.91",
"data_read_per_join": "48"
},
"used_columns": [
"product_id",
"category_id",
"link_type",
"category_position"
]
}
},
{
"table": {
"table_name": "categories",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"c_status",
"p_category_id"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"ref": [
"goimagine.products_categories.category_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "5.00",
"cost_info": {
"read_cost": "0.75",
"eval_cost": "0.02",
"prefix_cost": "4.96",
"data_read_per_join": "402"
},
"used_columns": [
"category_id",
"usergroup_ids",
"status",
"storefront_id"
],
"attached_condition": "((`goimagine`.`categories`.`storefront_id` in (0,1)) and ((`goimagine`.`categories`.`usergroup_ids` = '') or (0 <> find_in_set(0,`goimagine`.`categories`.`usergroup_ids`)) or (0 <> find_in_set(1,`goimagine`.`categories`.`usergroup_ids`))) and (`goimagine`.`categories`.`status` in ('A','H')))"
}
},
{
"table": {
"table_name": "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.13",
"eval_cost": "0.02",
"prefix_cost": "5.10",
"data_read_per_join": "260"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
},
{
"table": {
"table_name": "company_descriptions",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id",
"lang_code"
],
"key_length": "10",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.04",
"eval_cost": "0.02",
"prefix_cost": "5.16",
"data_read_per_join": "266"
},
"used_columns": [
"company_id",
"lang_code",
"company_description"
]
}
},
{
"table": {
"table_name": "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.04",
"eval_cost": "0.02",
"prefix_cost": "5.21",
"data_read_per_join": "3"
},
"used_columns": [
"object_id",
"object_type",
"type"
]
}
}
]
}
}
}
Result
| product_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 |
weight_lbs |
weight_oz |
product_tax_code |
deleted_at |
archived_at |
position |
lang_code |
product |
shortname |
short_description |
full_description |
meta_keywords |
meta_description |
search_words |
page_title |
age_warning_message |
promo_text |
cls_stop_words |
how_its_made |
custom_header |
price |
category_ids |
popularity |
company_name |
terms |
seo_name |
seo_path |
company_description |
discussion_type |
| 150 |
|
P |
A |
39 |
6.50 |
1 |
0.187 |
0 |
0 |
0 |
0.00 |
0 |
1584419986 |
1613365135 |
0 |
N |
N |
N |
D |
N |
R |
N |
N |
N |
Y |
10 |
0 |
N |
|
1 |
0 |
0 |
0 |
|
N |
0 |
P |
F |
|
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;} |
0.000 |
0.000 |
|
|
|
2147483647 |
en |
Blue Art Deco Switch Cover, Night Light, Cabinet Knob |
|
<p>Art Deco Switch Cover, Night Light, Cabinet Knob<br></p> |
<p><strong></strong></p>
<p><span style="color: rgb(192, 80, 77);">PLEASE Read Entire Description</span></p>
<p>*Pattern placement may vary *Due to monitor differences, actual color may vary from what appears online. All our switch plates are printed using the highest materials and craftsmanship. The images we use are high quality which gives a nice crisp image.</p>
<p>Measurements Are: </p>
<ul><li> Single Toggle Light Switch Cover 4.5" x 2.75" </li><li> Double Toggle Light Switch Cover 4.5" x 4.56" </li><li> Single Rocker Light Switch Cover 4.5" x 2.75"</li><li> Double Rocker Light Switch Cover 4.5" x 4.56" </li><li> Duplex Outlet Wall Plate 4.5" x 2.75" </li><li> Telephone/Cable Wall Plate 4.5 x 2.75" with a .625" hole (Screws do not come painted)</li><li> Cabinet Knob-1 1/4" Ceramic Insert Knob/Chrome 32mm</li></ul>
<p>Night Light:
</p>
<ul><li>BRIGHT WHITE GLOW: Just the right amount of light, not harsh on your eyes; perfect for getting up at night and not having to turn on lights to wake others up, illuminate all obstacles in the room</li><li>AUTOMATIC ON OFF: Sensitive dusk to dawn sensor, automatically turn the light on when the ambient lighting becomes insufficient, and turns off at dawn</li><li>ENERGY EFFICIENT: Max 0.5W, without using excessive electricity; long-lasting LED up to 30000 hours no worry about bulb replace</li><li>UNIQUE DESIGN: Clear and square acrylic material flat against the wall gives off a white diffused light; the non-polarity plug does not block the second outlet on the wall</li><li>MULTI-PURPOSE: This LED night light is perfect for the bathroom, bedroom, hallway, stairway, kitchen, living room, and kids room, create a safety ambient also portable for travel</li></ul>
<p><span style="color: rgb(192, 80, 77);">These are handmade and will ship in 5-7 Days</span></p>
<p>
</p> |
Light Switch Cover, Outlet Covers, Double Light Cover, Triple Light Cover, Decora Rocker Cover, Night Light, Cabinet Knobs, Dresser Knobs, Handmade, Decorative Switch Covers, Bedroom Decor, Bathroom Decor, Kitchen Decor |
Handmade Decorative Switch Covers. We also offer matching Night Lights and Cabinet Knobs. Why live with boring white Switch Covers, add a bit of art to your walls. Switch Cover Supply
|
Light Switch Cover, Switch Cover, Outlet Cover, Single Light Cover, Lightswtich, Rocker Cover, Decora Cover, Bedroom Decor, Bathroom Decor, Kitchen Decor, Night Light, Cabinet Knob, Knobs, Dresser Knob, Lighting, Renter Decor, Housewarming Gift, Laundry Room, Art Deco, Blue Art Deco, Switch Cover Supply |
Blue Art Deco Switch Cover, Night Light, Cabinet Knob |
|
<p></p>
<p>This is a custom Handmade made to order item. I need 5-7 Business days to ship it out. Then the Post office needs an additional 3-5 days for delivery.</p>
<p></p> |
|
|
|
6.50000000 |
47M,1963,2013 |
7941 |
Switch Cover Supply |
<p>Processing time:</p>
<p>I need 5-7 Business Days to make this product, plus shipping time from USPS</p>
<p><br></p>
<p>returns and exchange Policy</p>
<p><strong>I do not accept returns or exchanges</strong>. These products are handmade in your choice of Pattern and Switch Combinations. If you receive a broken product Please send me a photo and I will gladly send out a new one. I will of course replace any item that was shipped out wrong due to my error.</p> |
blue-art-deco-switch-cover-night-light-cabinet-knob |
4/47 |
<div class="video-container"><iframe style="width: 500px; height: 281px;" src="//www.youtube.com/embed/MXrOUqMKBOI" frameborder="0" allowfullscreen=""></iframe></div>
<p><strong>Welcome to My Shop!</strong></p>
<p><span class="mt-xs-1" data-inplace-editable-text="story" data-endpoint="AboutPost" data-key="story" data-placeholder="How did you get started? What inspires you? We know each seller’s story is unique—tell yours here.">I hope I have surprised you by all the designs I have to offer. I believe there is a little something for everyone. If you don't find what you are looking for I do have a custom Light switch option. I can put your dog, girlfriend, child's Art Work, almost anything on a light switch. Just message me a good size JPG. Your light switch is only as good as your picture so make it a good one.</span></p> |
D |