SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539838 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539838 [ RunTime:0.001766s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (13757,124700,900652,284251,1002976,46586,816863,440923,71435,734397,304903,387394,278168,233277,29143,801924,658217,33541,425101,649057,121523,1035627,944606,493527,387316,369915,540068,51958,221113,79467,754854,58235,635051,976362,1029728,1040777,870979,413271,402948,104898,289572,318870,620933,233625,540912,27876,920882,811073,669906,473796,137960,962808,7515,594024,845667,349579,308939,214636,487476,162866) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]