Skip to content

Instantly share code, notes, and snippets.

@blasto333

blasto333/result of query for performance.sql

Created January 27, 2017 21:42
Show Gist options
  • Save blasto333/cab705964258184211cccba8f2f5bd7e to your computer and use it in GitHub Desktop.
Save blasto333/cab705964258184211cccba8f2f5bd7e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
result of query for performance.sql
mysql> select * from phppos_sales_items procedure analyse();
+----------------------------------------------------------------+-------------------------+----------------------------+------------+------------+------------------+--------+-------------------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
+----------------------------------------------------------------+-------------------------+----------------------------+------------+------------+------------------+--------+-------------------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| pos.phppos_sales_items.sale_id | 1 | 205175 | 1 | 6 | 0 | 0 | 102997.6867 | 118931.8755 | MEDIUMINT(6) UNSIGNED NOT NULL |
| pos.phppos_sales_items.item_id | 1 | 4360 | 1 | 4 | 0 | 0 | 1019.1562 | 920.9358 | SMALLINT(4) UNSIGNED NOT NULL |
| pos.phppos_sales_items.rule_id | NULL | NULL | 0 | 0 | 0 | 345743 | 0.0 | 0.0 | CHAR(0) |
| pos.phppos_sales_items.rule_discount | NULL | NULL | 0 | 0 | 0 | 345743 | 0.0 | 0.0 | CHAR(0) |
| pos.phppos_sales_items.description |
| v4l zues charger cord 5.99 | 0 | 66 | 345047 | 0 | 0.0460 | NULL | ENUM('
','
','','***IMPORTANT***
COST $1.05 EACH BECAUSE IT WAS A BUNDLE vs THE BOX','*brt has the cost*','26 Guage
4-1/2" Long','42 Ring Guage
5-1/8 lENGTH','Chateau Fuente Natural 4.50X50','Churchill Maduro 7.00','Claro
','Claro
','Claro ','Cuban Round Claro Robusto
40ct. BOX 5.00X54','Cuban Round Claro Robusto Connecticut 40ct. BOX 5.00X54','Cuban Round Claro Robusto Connecticut SINGLES 5.00X54','Cuban Round Claro Robusto40ct. BOX 5.00X54','Cuban Round Torpedo Natural 6.00X5','Cuban Round Torpedo Natural 6.00X52','It\'s A Boy ','It\'s a Girl ','Robusto Claro 5 x 54 ','Short Story ','Toro Gordo Natural
','Toro Gordo Natural ','Toro Maduro','Toro Natural 6.00X50','Torpedo Maduro 6.00X5
','Torpedo Maduro 6.00X5
','Torpedo Maduro 6.00X5','Torpedo Maduro 6.00X5.2
','Torpedo Maduro 6.00X5.2
','Torpedo Maduro 6.00X52
','Torpedo Maduro 6.00X52
','Torpedo Maduro 6.00X52','v4l zues charger cord 5.99') NOT NULL |
| pos.phppos_sales_items.serialnumber | | | 0 | 0 | 345743 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL |
| pos.phppos_sales_items.line | 1 | 39 | 1 | 2 | 0 | 0 | 1.8388 | 2.1501 | ENUM('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39') NOT NULL |
| pos.phppos_sales_items.quantity_purchased | -10.0000000000 | 320.0000000000 | 14 | 22 | 36 | 0 | 1.53504036235007 | 1.85224033395400 | DECIMAL(21, 10) UNSIGNED NOT NULL |
| pos.phppos_sales_items.item_cost_price | 0.0100000000 | 88004009373.0000000000 | 14 | 31 | 32117 | 0 | 1781758.18696832184600 | 395977385.76154965000000 | DECIMAL(30, 10) NOT NULL |
| pos.phppos_sales_items.item_unit_price | -1350.0000000000 | 393.3900000000 | 14 | 22 | 59 | 0 | 7.92042098668108 | 11.58661421964291 | DECIMAL(21, 10) UNSIGNED NOT NULL |
| pos.phppos_sales_items.regular_item_unit_price_at_time_of_sale | NULL | NULL | 0 | 0 | 0 | 345743 | 0.0 | 0.0 | CHAR(0) |
| pos.phppos_sales_items.discount_percent | 0.000 | 100.000 | 7 | 15 | 340018 | 0 | 0.1823456 | 3.5832866 | ENUM('0.000','1.000','2.000','3.000','4.000','5.000','6.000','7.700','8.000','9.000','10.000','12.000','15.000','18.000','19.000','20.000','33.000','35.000','36.000','37.000','38.000','39.000','40.000','45.000','48.000','50.000','51.000','52.000','53.000','54.000','57.000','58.000','60.000','65.000','66.000','67.000','68.000','69.000','72.000','73.000','74.000','75.000','79.000','80.000','81.000','82.000','83.000','84.000','90.000','91.000','100.000') NOT NULL |
| pos.phppos_sales_items.commission | 0.0000000000 | 0.0000000000 | 14 | 14 | 345743 | 0 | 0.00000000000000 | 0.00000000000000 | ENUM('0.0000000000') NOT NULL |
| pos.phppos_sales_items.is_bogo | 0 | 0 | 1 | 1 | 345743 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
| pos.phppos_sales_items.sale_time | 2013-08-03 15:13:58 | 2017-01-26 14:56:33 | 19 | 19 | 0 | 0 | 19.0000 | NULL | CHAR(19) NOT NULL |
| pos.phppos_sales_items.suspended | 0 | 1 | 1 | 1 | 345631 | 0 | 0.0003 | 0.0180 | ENUM('0','1') NOT NULL |
| pos.phppos_sales_items.was_layaway | 0 | 1 | 1 | 1 | 344069 | 0 | 0.0048 | 0.0694 | ENUM('0','1') NOT NULL |
| pos.phppos_sales_items.was_estimate | 0 | 1 | 1 | 1 | 345735 | 0 | 0.0000 | 0.0048 | ENUM('0','1') NOT NULL |
| pos.phppos_sales_items.store_account_payment | 0 | 0 | 1 | 1 | 345743 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
| pos.phppos_sales_items.location_id | 1 | 1 | 1 | 1 | 0 | 0 | 1.0000 | 0.0000 | ENUM('1') NOT NULL |
| pos.phppos_sales_items.deleted | 0 | 1 | 1 | 1 | 345628 | 0 | 0.0003 | 0.0182 | ENUM('0','1') NOT NULL |
| pos.phppos_sales_items.item_name | $0.35 Coupon | Zippo Wick | 1 | 58 | 0 | 0 | 21.6824 | NULL | TINYTEXT NOT NULL |
| pos.phppos_sales_items.category_name | 0 | Wine | 1 | 19 | 0 | 0 | 8.4591 | NULL | ENUM('0','Bagged Tobacco','Beer','Candle','Candy','Carton','Chew Carton','Chew Pack','Cigar Packs','cigar pipes','Cigarette Pack','coupon','Drinks','Electronic Cig','Generic Cigars','Hookah','Hookah Tobacco','ICE','Liquor','Little Cigar ','Medicine','Misc','Mixers','Payout','Premium Cigars','Snacks','Snuff','Snus','test','Tobacco Accessories','Vapor','Wine') NOT NULL |
| pos.phppos_sales_items.category_id | 2 | 34 | 1 | 2 | 0 | 0 | 14.9879 | 8.7394 | ENUM('2','3','4','5','6','7','8','9','10','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34') NOT NULL |
| pos.phppos_sales_items.subtotal | -1350.0000000000 | 716.2200000000 | 14 | 22 | 478 | 0 | 10.33827950240497 | 15.12563528918404 | DECIMAL(21, 10) UNSIGNED NOT NULL |
| pos.phppos_sales_items.tax | -29.4735000000 | 54.8910000000 | 14 | 22 | 9243 | 0 | 0.99658646718920 | 1.42043198200959 | DECIMAL(21, 10) UNSIGNED NOT NULL |
| pos.phppos_sales_items.total | -1350.0000000000 | 716.2200000000 | 14 | 22 | 478 | 0 | 11.33486596959417 | 16.47366320380572 | DECIMAL(21, 10) UNSIGNED NOT NULL |
| pos.phppos_sales_items.profit | -88004009373.3500000000 | 155.0000000000 | 14 | 31 | 278 | 0 | -1781749.95743481863696 | 395977385.80015427000000 | DECIMAL(30, 10) UNSIGNED NOT NULL |
+----------------------------------------------------------------+-------------------------+----------------------------+------------+------------+------------------+--------+-------------------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
28 rows in set (10.56 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment