SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 231816 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 231816 [ RunTime:0.002664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407334,622042,702437,316146,888810,943891,290126,773154,99566,973878,215346,198491,552333,387784,624920,559686,526950,789387,61850,25720,680039,896679,112793,127563,397203,8433,861986,31583,432239,106392,1018395,162422,822473,637393,897653,343771,344416,735632,895140,736961,44469,390580,238289,513637,267447,156274,761879,228620,784360,21336,198468,305212,837767,541346,754174,406229,649430,660129,468953,351399) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001951s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 231816 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 231816 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000407s ]