OMGZui

SELECT * FROM doc WHERE id = #{id};

OMGZui

UPDATE doc SET prevId = #{currentData.prevId} WHERE id = #{curActivity.siblingId};
UPDATE doc SET siblingId = #{currentData.siblingId} WHERE id = #{currentData.prevId};

OMGZui

SELECT * FROM doc WHERE id = #{prevId};

OMGZui

UPDATE doc SET prevId = #{id} WHERE id = #{prevData.siblingId};
UPDATE doc SET siblingId = #{prevData.siblingId} WHERE id = #{id};

UPDATE doc SET prevId = #{prevId} WHERE id = #{id};
UPDATE doc SET siblingId = #{id} WHERE id = #{prevId};

OMGZui

CREATE TABLE `doc` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `prevId` int(11) DEFAULT NULL COMMENT 'prevID',
  `siblingId` int(11) DEFAULT NULL COMMENT 'siblingID',
  `position` int(11) DEFAULT NULL COMMENT 'position',
  PRIMARY KEY (`id`),
  KEY `idx_prevId` (`prevId`),
  KEY `idx_siblingId` (`siblingId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

OMGZui

if (!empty($foo)) $data['foo'] = $foo; // A

if (!empty($foo)) {
    $data['foo'] = $foo; // B
}

!empty($foo) && $data['foo'] = $foo; // C

OMGZui

// A
foreach ($list as $item) {
    if ($item['status'] == true) {
        // ...
    }
}

// B
foreach ($list as $item) {
    if ($item['status'] == false) {

OMGZui

// A
$data = [];
$data['a'] = 1;
$data['b'] = 1;

// B
$data = [
    'a' => 1,
    'b' => 1,
];

OMGZui

// A
$count = 0;
while ($count < 10) {
    // ...
    $count++;
}

// B
$count = 0;
while (++$count < 10) {

OMGZui

// A
if ($result == true)

// B
if (true == $result)