Online PHP editor | perf for DqCAN

<?php class CommentInfoController { private $pdo; public function __construct() { $this->pdo = Database::getInstance('db1'); } 　 public function updateCommentInfo(array $new_comment_info): array { try { $this->pdo->beginTransaction(); // 更新対象id $comment_id = $new_comment_info['comment_id']; /* ステップ１現状のコメント情報を取得 */ // comments テーブルのSELECT $commentMapper = new CommentMapper(); $comment = new Comment(); $args = ['comment_id'=>$comment_id]; $now_comment_info = $commentMapper->findCommentInfos($args)[0]; if(!$now_comment_info) { throw new InvalidArgumentException('comment_id:' . $comment_id . 'は存在しません'); } /* var_export($now_comment_info); array ( 'comment_id' => 1, 'content' => 'content1', 'tags' => array ( 0 => array ( 'tag_name' => 'bbb', 'tag_kind_id' => 2, ), ), ) */ /* ステップ２現状のコメント情報($now_comment_info) と新しいコメント情報($new_comment_info) の差分を抽出して更新 */ // content がある場合 if(!empty($new_comment_info['content'])) { if ($now_comment_info['content'] !== $new_comment_info['content']) { // comments テーブルのUPDATE $commentMapper = new CommentMapper(); $comment = new Comment(); $comment->id = $comment_id; $comment->content = $new_comment_info['content']; $commentMapper->update($comment); } } // tags がある場合 if(!empty($new_comment_info['tags'])) { // tags の差分を得る $tmp = $this->compareTags($now_comment_info['tags'], $new_comment_info['tags']); $added_tags = $tmp['added']; $removed_tags = $tmp['removed']; /* var_export($tmp); array ( 'removed' => array ( 0 => array ( 'tag_name' => 'aaa', 'tag_kind_id' => 1, ), ), 'added' => array ( 0 => array ( 'tag_name' => 'bbb', 'tag_kind_id' => 2, ), ), ) */ // $added_tag がDBになければ $tags にセットし bulkInsert で保存 $tags = []; $tagMapper = new TagMapper(); foreach ($added_tags as $added_tag) { $sth = $tagMapper->find($added_tag); $row = $sth->fetch(); if (!$row) { $tag = new Tag(); $tag->fromArray($added_tag); // 配列を行クラスにセット $tags[] = $tag; // 行クラスを追加 } } if(!empty($tags)) { /* var_export($tags); array ( 0 => \Tag::__set_state(array( 'data' => array ( 'tag_name' => 'bbb', 'tag_kind_id' => 2, ), )), ) */ $tagMapper->bulkInsert($tags); } // commentHasTags のINSERT $commentHasTags = []; foreach ($tags as $data) { $commentHasTag = new CommentHasTag(); $commentHasTag->comment_id = $comment_id; $commentHasTag->tag_id = $data->id; $commentHasTags[] = $commentHasTag; } /* var_export($commentHasTags); array ( 0 => \CommentHasTag::__set_state(array( 'data' => array ( 'comment_id' => 1, 'tag_id' => 54, ), )), ) */ $commentHasTagMapper = new CommentHasTagMapper(); $commentHasTagMapper->bulkInsert($commentHasTags); // $removed_tags のリレーションを削除 $commentHasTagMapper = new CommentHasTagMapper(); // ★こういうときって宣言すんのか？ foreach ($removed_tags as $removed_tag) { $sth = $tagMapper->find($removed_tag); $row = $sth->fetch(); $conditions = ['comment_id'=>$comment_id, 'tag_id'=>$row->id]; $commentHasTagMapper->delete($conditions); } } $this->pdo->commit(); return $new_comment_info; } catch (Exception $e) { $this->pdo->rollBack(); log($e->getMessage()); } } }

Version	System time (s)	User time (s)	Memory (MiB)
8.2.7	0.018	0.000	79.33
8.2.6	0.014	0.005	79.33
8.2.5	0.009	0.009	79.33
8.2.4	0.008	0.008	79.33
8.2.3	0.017	0.000	79.33
8.2.2	0.006	0.009	79.33
8.2.1	0.014	0.003	79.33
8.2.0	0.015	0.003	79.33
8.1.20	0.017	0.003	79.33
8.1.19	0.016	0.003	79.33
8.1.18	0.016	0.000	79.33
8.1.17	0.004	0.011	79.33
8.1.16	0.010	0.006	79.33
8.1.15	0.012	0.006	79.33
8.1.14	0.004	0.012	79.33
8.1.13	0.008	0.008	79.33
8.1.12	0.008	0.008	79.33
8.1.11	0.008	0.008	79.33
8.1.10	0.013	0.003	79.33
8.1.9	0.012	0.003	79.33
8.1.8	0.014	0.003	79.33
8.1.7	0.015	0.002	79.33
8.1.6	0.014	0.003	79.33
8.1.5	0.017	0.000	79.33
8.1.4	0.010	0.007	79.33
8.1.3	0.014	0.003	79.33
8.1.2	0.010	0.007	79.33
8.1.1	0.009	0.009	79.33
8.1.0	0.014	0.003	79.33
8.0.29	0.015	0.000	79.33
8.0.28	0.015	0.000	79.33
8.0.27	0.015	0.000	79.33
8.0.26	0.015	0.000	79.33
8.0.25	0.010	0.005	79.33
8.0.24	0.013	0.003	79.33
8.0.23	0.011	0.008	79.33
8.0.22	0.016	0.000	79.33
8.0.21	0.011	0.004	79.33
8.0.20	0.012	0.003	79.33
8.0.19	0.015	0.003	79.33
8.0.18	0.014	0.006	79.33
8.0.17	0.012	0.004	79.33
8.0.16	0.009	0.006	79.33
8.0.15	0.017	0.000	79.33
8.0.14	0.005	0.010	79.33
8.0.13	0.012	0.003	79.33
8.0.12	0.010	0.006	79.33
8.0.11	0.006	0.010	79.33
8.0.10	0.015	0.000	79.33
8.0.9	0.011	0.004	79.33
8.0.8	0.011	0.004	79.33
8.0.7	0.007	0.007	79.33
8.0.6	0.006	0.009	79.33
8.0.5	0.014	0.002	79.33
8.0.3	0.015	0.000	79.33
8.0.2	0.007	0.007	79.33
8.0.1	0.008	0.008	79.33