Query time 0.00084
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "1.00"
},
"nested_loop": [
{
"table": {
"table_name": "prod",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"idx_company_id"
],
"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": "com",
"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": "14K"
},
"used_columns": [
"company_id",
"status",
"company",
"lang_code",
"address",
"city",
"state",
"country",
"zipcode",
"email",
"phone",
"url",
"storefront",
"secure_storefront",
"entry_page",
"redirect_customer",
"countries_list",
"timestamp",
"shippings",
"logos",
"request_user_id",
"request_account_name",
"request_account_data",
"plan_id",
"stripe_connect_account_id",
"identifier_facebook_pixel",
"featured_products",
"sd_ga_tracking_code",
"paypal_commerce_platform_account_id",
"tagline",
"url_facebook",
"url_instagram",
"url_twitter",
"url_pinterest",
"announcement",
"shippo_api_token",
"shippo_carrier",
"shippo_service_type",
"vendor_ga_tracking_code",
"vendor_fb_tracking_code",
"custom_domain",
"custom_domain_status",
"taxjar_key",
"taxjar_export_statuses",
"taxjar_export_csv_data",
"ag_hide_city",
"updated_timestamp",
"suspend_date",
"grace_period_start",
"last_time_suspended",
"last_debt_notification_time",
"tax_number",
"stripe_connect_account_type",
"registered_from_storefront_id"
]
}
}
]
}
}
Result
| company_id |
status |
company |
lang_code |
address |
city |
state |
country |
zipcode |
email |
phone |
url |
storefront |
secure_storefront |
entry_page |
redirect_customer |
countries_list |
timestamp |
shippings |
logos |
request_user_id |
request_account_name |
request_account_data |
plan_id |
stripe_connect_account_id |
identifier_facebook_pixel |
featured_products |
sd_ga_tracking_code |
paypal_commerce_platform_account_id |
tagline |
url_facebook |
url_instagram |
url_twitter |
url_pinterest |
announcement |
shippo_api_token |
shippo_carrier |
shippo_service_type |
vendor_ga_tracking_code |
vendor_fb_tracking_code |
custom_domain |
custom_domain_status |
taxjar_key |
taxjar_export_statuses |
taxjar_export_csv_data |
ag_hide_city |
updated_timestamp |
suspend_date |
grace_period_start |
last_time_suspended |
last_debt_notification_time |
tax_number |
stripe_connect_account_type |
registered_from_storefront_id |
product_id |
product_code |
product_type |
list_price |
amount |
weight |
length |
width |
height |
shipping_freight |
low_avail_limit |
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 |
| 168 |
A |
Waverly Glass Works ~ Engraved Glassware |
en |
1672 County Rd. 10 S. |
Alamosa |
CO |
US |
81101 |
julieshomemadejems@gmail.com |
|
|
|
|
none |
Y |
|
1618531111 |
|
|
0 |
|
a:4:{s:14:"company_fields";a:2:{i:37;s:5:"Julie";i:38;s:7:"Fransen";}s:15:"admin_firstname";s:5:"Julie";s:14:"admin_lastname";s:7:"Fransen";s:6:"fields";a:0:{}} |
2 |
acct_1GQEp8GdqAQncn0o |
|
87319,87318,87317,87315,87314,79541,87320,87322,87323,78483,78693,78691,78690,78689,78688,78687,78685,78551,78549,78550 |
|
|
|
https://www.facebook.com/JuliesHomemadeJems |
https://www.instagram.com/julieshomemadejems/ |
|
https://www.pinterest.com/julieshomemadejems/_created/ |
<p><span class="display-block">Welcome to my Shop. **PLEASE NOTE - My recipe pans are done in 2 different fonts. At this time, I DO NOT have the capability to do them in someones handwriting.</span></p>
<p><span class="display-block">
***I work very hard to produce a quality product. There are times however when things beyond my control can happen. Because of the handmade nature of my products, and the process I use, there can be some imperfections, such as missing the inside of letters. It will not change the readability of your product. Please embrace those imperfections when they happen and remember that you have a very unique product that is still beautiful. </span></p>
<p><span class="display-block">Sand blasted baking pans, and coffee cups plus an assortment of gift items with excellent customer service and quick shipping are the focus of my shop. Custom orders are welcomed and encouraged.
If you see an item that strikes your fancy, but you would like a different design, please contact me and I will do all I can to accommodate your request.</span></p>
<p><span class="display-block">
I am happy to combine shipping Contact me before your purchase so shipping can be figured.</span></p> |
|
|
|
|
|
|
A |
|
|
|
N |
1622849670 |
0 |
0 |
0 |
0 |
|
S |
|
78550 |
|
P |
15.00 |
2 |
1.000 |
0 |
0 |
0 |
2.00 |
0 |
0 |
N |
N |
N |
D |
N |
R |
N |
N |
N |
Y |
10 |
0 |
N |
|
0 |
0 |
0 |
0 |
|
N |
0 |
P |
F |
|
a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:1;s:10:"box_length";i:6;s:9:"box_width";i:6;s:10:"box_height";i:6;} |
1.000 |
0.000 |
|
|
|
2147483647 |