Online PHP editor | perf for krhVS

<?php class Query { protected $table = ''; protected $querystring = ''; public function __construct($pdo = '') { $this->connection = $pdo; return $this; } public function query($query) { $this->querystring = $query; return $this->execute(); } public function execute() { $this->querystring = str_replace([':fields', ':where', ':orderby', ':limit'], ['*', '', '', ''], $this->querystring); return $this->connection->query($this->querystring); } public function safeVar($var) { if (is_int($var)) { return (int) $var; } elseif (is_string($var)) { return '"'.(string) $var.'"'; } elseif (is_array($var)) { return '"'.implode(', ', $var).'"'; } return $var; } public function where(...$rules) { if (!strpos($this->querystring, ':where')) { return false; } $where = ''; foreach ($rules as $rule) { if (!isset($rule['field']) || !isset($rule['way']) || !isset($rule['against'])) { if (!isset($rule[0]) || !isset($rule[1]) || !isset($rule[2])) { return false; } else { $where .= " AND `{$rule[0]}` {$rule[1]} {$rule[2]}"; } } else { $where .= " AND `{$rule['field']}` {$rule['way']} ".safeVar($rule['against']).""; } } $this->querystring = str_replace(':where', ' WHERE '.trim($where, ' AND '), $this->querystring); return $this; } public function orderby($field, $way = 'DESC') { if (!strpos($this->querystring, ':orderby')) { return false; } $way = strtoupper((string) $way); if (!in_array($way, ['DESC', 'ASC'])) { $way = 'DESC'; } $this->querystring = str_replace(':orderby', "ORDERBY `{$field}` {$way}", $this->querystring); return $this; } public function limit($from, $to) { if (!strpos($this->querystring, ':limit')) { return false; } $from = (int) $from; $to = (int) $to; $this->querystring = str_replace(':limit', "LIMIT {$from}, {$to}", $this->querystring); return $this; } public function __toString() { return $this->querystring; } } class Select extends Query { public function __construct(\PDO $pdo, $table) { parent::__construct($pdo); $this->table = $table; $this->querystring = "SELECT :fields FROM {$table}:where:orderby:limit;"; } public function get(...$fields = ['*']) { if (!strpos($this->querystring, ':fields')) { return false; } $this->querystring = str_replace(':fields', implode(', ', $fields), $this->querystring); return $this; } public function first() { if (!strpos($this->querystring, ':limit')) { return false; } $this->querystring = str_replace(':limit', 'LIMIT 0, 1', $this->querystring); return $this; } } class Update extends Query { public function __construct(\PDO $pdo, $table) { parent::__construct($pdo); $this->table = $table; $this->querystring = 'UPDATE :table SET :values:where:orderby:limit;'; } } class Delete extends Query { public function __construct(\PDO $pdo, $table) { parent::__construct($pdo); $this->table = $table; $this->querystring = 'DELETE FROM :table:where:orderby:limit;'; } } class Insert extends Query { public function __construct(\PDO $pdo, $table) { parent::__construct($pdo); $this->table = $table; $this->querystring = 'INSERT INTO :table:fields VALUES :values;'; } } $select = new Select('', 'test'); $update = new Update('', 'test'); $delete = new Delete('', 'test'); $insert = new Insert('', 'test');

Version	System time (s)	User time (s)	Memory (MiB)
5.4.35	0.006	0.038	12.04
5.4.34	0.012	0.053	12.04
5.4.32	0.007	0.068	12.52
5.4.31	0.008	0.054	12.52
5.4.30	0.014	0.105	12.52
5.4.29	0.016	0.062	12.52
5.4.28	0.009	0.040	12.42
5.4.27	0.005	0.045	12.41
5.4.26	0.013	0.052	12.41
5.4.25	0.005	0.047	12.42
5.4.24	0.006	0.039	12.42
5.4.23	0.011	0.035	12.41
5.4.22	0.002	0.043	12.41
5.4.21	0.010	0.040	12.41
5.4.20	0.011	0.054	12.41
5.4.19	0.005	0.051	12.41
5.4.18	0.009	0.038	12.40
5.4.17	0.008	0.035	12.41
5.4.16	0.016	0.065	12.41
5.4.15	0.011	0.099	12.41
5.4.14	0.006	0.047	12.10
5.4.13	0.011	0.057	12.08
5.4.12	0.016	0.081	12.04
5.4.11	0.012	0.055	12.04
5.4.10	0.014	0.055	12.04
5.4.9	0.015	0.047	12.04
5.4.8	0.013	0.078	12.04
5.4.7	0.011	0.040	12.04
5.4.6	0.015	0.054	12.03
5.4.5	0.009	0.048	12.03
5.4.4	0.007	0.038	12.02
5.4.3	0.005	0.039	12.02
5.4.2	0.007	0.034	12.01
5.4.1	0.010	0.034	12.02
5.4.0	0.008	0.048	11.52
5.3.29	0.009	0.052	12.80
5.3.28	0.009	0.048	12.71
5.3.27	0.011	0.044	12.72
5.3.26	0.006	0.045	12.72
5.3.25	0.007	0.041	12.72
5.3.24	0.008	0.039	12.72
5.3.23	0.013	0.053	12.71
5.3.22	0.006	0.041	12.68
5.3.21	0.008	0.039	12.68
5.3.20	0.006	0.038	12.68
5.3.19	0.008	0.040	12.68
5.3.18	0.010	0.056	12.68
5.3.17	0.003	0.046	12.67
5.3.16	0.008	0.039	12.67
5.3.15	0.010	0.040	12.67
5.3.14	0.005	0.042	12.66
5.3.13	0.009	0.043	12.66
5.3.12	0.006	0.044	12.66
5.3.11	0.010	0.037	12.66
5.3.10	0.004	0.043	12.13
5.3.9	0.008	0.043	12.11
5.3.8	0.020	0.089	12.10
5.3.7	0.014	0.059	12.10
5.3.6	0.012	0.036	12.09
5.3.5	0.007	0.040	12.03
5.3.4	0.010	0.047	12.03
5.3.3	0.011	0.044	12.00
5.3.2	0.010	0.041	11.77
5.3.1	0.011	0.051	11.74
5.3.0	0.006	0.049	11.72
5.2.17	0.015	0.052	9.23
5.2.16	0.010	0.049	9.23
5.2.15	0.006	0.031	9.23
5.2.14	0.007	0.030	9.23
5.2.13	0.006	0.031	9.19
5.2.12	0.008	0.034	9.18
5.2.11	0.003	0.038	9.19
5.2.10	0.009	0.038	9.19
5.2.9	0.006	0.050	9.19
5.2.8	0.005	0.034	9.19
5.2.7	0.008	0.032	9.19
5.2.6	0.009	0.031	9.14
5.2.5	0.013	0.062	9.10
5.2.4	0.021	0.058	9.08
5.2.3	0.021	0.067	9.07
5.2.2	0.013	0.053	9.05
5.2.1	0.013	0.036	8.96
5.2.0	0.006	0.036	8.82
5.1.6	0.005	0.029	8.10
5.1.5	0.003	0.028	8.10
5.1.4	0.004	0.026	8.08
5.1.3	0.006	0.028	8.43
5.1.2	0.004	0.027	8.45
5.1.1	0.007	0.024	8.18
5.1.0	0.007	0.025	8.18
5.0.5	0.006	0.026	6.65
5.0.4	0.007	0.026	6.51
5.0.3	0.005	0.042	6.32
5.0.2	0.015	0.044	6.29
5.0.1	0.005	0.040	6.27
5.0.0	0.005	0.040	6.25
4.4.9	0.006	0.020	4.77
4.4.8	0.004	0.022	4.76
4.4.7	0.003	0.019	4.76
4.4.6	0.014	0.039	4.75
4.4.5	0.001	0.023	4.77
4.4.4	0.002	0.033	4.70
4.4.3	0.006	0.063	4.76
4.4.2	0.007	0.022	4.85
4.4.1	0.005	0.017	4.85
4.4.0	0.005	0.050	4.76
4.3.11	0.006	0.039	4.67
4.3.10	0.006	0.029	4.66
4.3.9	0.003	0.023	4.63
4.3.8	0.005	0.053	4.59
4.3.7	0.000	0.022	4.63
4.3.6	0.003	0.019	4.63
4.3.5	0.003	0.020	4.63
4.3.4	0.002	0.028	4.54
4.3.3	0.013	0.070	3.30
4.3.2	0.004	0.021	3.29
4.3.1	0.005	0.033	3.24
4.3.0	0.000	0.037	12.46

Version

System time (s)

User time (s)

Memory (MiB)

5.4.35

0.006

0.038

12.04

5.4.34

0.012

0.053

12.04

5.4.32

0.007

0.068

12.52

5.4.31

0.008

0.054

12.52

5.4.30

0.014

0.105

12.52

5.4.29

0.016

0.062

12.52

5.4.28

0.009

0.040

12.42

5.4.27

0.005

0.045

12.41

5.4.26

0.013

0.052

12.41

5.4.25

0.005

0.047

12.42

5.4.24

0.006

0.039

12.42

5.4.23

0.011

0.035

12.41

5.4.22

0.002

0.043

12.41

5.4.21

0.010

0.040

12.41

5.4.20

0.011

0.054

12.41

5.4.19

0.005

0.051

12.41

5.4.18

0.009

0.038

12.40

5.4.17

0.008

0.035

12.41

5.4.16

0.016

0.065

12.41

5.4.15

0.011

0.099

12.41

5.4.14

0.006

0.047

12.10

5.4.13

0.011

0.057

12.08

5.4.12

0.016

0.081

12.04

5.4.11

0.012

0.055

12.04

5.4.10

0.014

0.055

12.04

5.4.9

0.015

0.047

12.04

5.4.8

0.013

0.078

12.04

5.4.7

0.011

0.040

12.04

5.4.6

0.015

0.054

12.03

5.4.5

0.009

0.048

12.03

5.4.4

0.007

0.038

12.02

5.4.3

0.005

0.039

12.02

5.4.2

0.007

0.034

12.01

5.4.1

0.010

0.034

12.02

5.4.0

0.008

0.048

11.52

5.3.29

0.009

0.052

12.80

5.3.28

0.009

0.048

12.71

5.3.27

0.011

0.044

12.72

5.3.26

0.006

0.045

12.72

5.3.25

0.007

0.041

12.72

5.3.24

0.008

0.039

12.72

5.3.23

0.013

0.053

12.71

5.3.22

0.006

0.041

12.68

5.3.21

0.008

0.039

12.68

5.3.20

0.006

0.038

12.68

5.3.19

0.008

0.040

12.68

5.3.18

0.010

0.056

12.68

5.3.17

0.003

0.046

12.67

5.3.16

0.008

0.039

12.67

5.3.15

0.010

0.040

12.67

5.3.14

0.005

0.042

12.66

5.3.13

0.009

0.043

12.66

5.3.12

0.006

0.044

12.66

5.3.11

0.010

0.037

12.66

5.3.10

0.004

0.043

12.13

5.3.9

0.008

0.043

12.11

5.3.8

0.020

0.089

12.10

5.3.7

0.014

0.059

12.10

5.3.6

0.012

0.036

12.09

5.3.5

0.007

0.040

12.03

5.3.4

0.010

0.047

12.03

5.3.3

0.011

0.044

12.00

5.3.2

0.010

0.041

11.77

5.3.1

0.011

0.051

11.74

5.3.0

0.006

0.049

11.72

5.2.17

0.015

0.052

9.23

5.2.16

0.010

0.049

9.23

5.2.15

0.006

0.031

9.23

5.2.14

0.007

0.030

9.23

5.2.13

0.006

0.031

9.19

5.2.12

0.008

0.034

9.18

5.2.11

0.003

0.038

9.19

5.2.10

0.009

0.038

9.19

5.2.9

0.006

0.050

9.19

5.2.8

0.005

0.034

9.19

5.2.7

0.008

0.032

9.19

5.2.6

0.009

0.031

9.14

5.2.5

0.013

0.062

9.10

5.2.4

0.021

0.058

9.08

5.2.3

0.021

0.067

9.07

5.2.2

0.013

0.053

9.05

5.2.1

0.013

0.036

8.96

5.2.0

0.006

0.036

8.82

5.1.6

0.005

0.029

8.10

5.1.5

0.003

0.028

8.10

5.1.4

0.004

0.026

8.08

5.1.3

0.006

0.028

8.43

5.1.2

0.004

0.027

8.45

5.1.1

0.007

0.024

8.18

5.1.0

0.007

0.025

8.18

5.0.5

0.006

0.026

6.65

5.0.4

0.007

0.026

6.51

5.0.3

0.005

0.042

6.32

5.0.2

0.015

0.044

6.29

5.0.1

0.005

0.040

6.27

5.0.0

0.005

0.040

6.25

4.4.9

0.006

0.020

4.77

4.4.8

0.004

0.022

4.76

4.4.7

0.003

0.019

4.76

4.4.6

0.014

0.039

4.75

4.4.5

0.001

0.023

4.77

4.4.4

0.002

0.033

4.70

4.4.3

0.006

0.063

4.76

4.4.2

0.007

0.022

4.85

4.4.1

0.005

0.017

4.85

4.4.0

0.005

0.050

4.76

4.3.11

0.006

0.039

4.67

4.3.10

0.006

0.029

4.66

4.3.9

0.003

0.023

4.63

4.3.8

0.005

0.053

4.59

4.3.7

0.000

0.022

4.63

4.3.6

0.003

0.019

4.63

4.3.5

0.003

0.020

4.63

4.3.4

0.002

0.028

4.54

4.3.3

0.013

0.070

3.30

4.3.2

0.004

0.021

3.29

4.3.1

0.005

0.033

3.24

4.3.0

0.000

0.037

12.46