SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 767216 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 767216 [ RunTime:0.001980s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (427817,802560,872465,21217,709593,242610,940535,981724,715129,750935,605686,351974,472032,429553,852366,506781,301513,435157,278907,185236,512400,100439,631979,467125,607920,819577,465783,283124,827960,349046,47509,67574,42242,691614,35464,354834,893801,354731,184643,559798,968264,263572,160485,62456,736512,180167,62831,812110,188639,351512,469073,904879,966105,789325,709066,245029,44778,168545,188284,927501) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 767216 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 767216 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]