SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001598s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465813 LIMIT 1 [ RunTime:0.000596s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465813 [ RunTime:0.003828s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (19787,239510,304816,538860,1026777,196266,224678,298984,614458,121825,515374,352605,812359,332341,788995,862384,792431,13255,716755,197951,223419,310409,11392,598352,458625,267158,227175,369451,353203,416016,150116,720128,481947,579201,932071,175056,969335,304146,444350,725977,420361,659129,74202,684237,535332,66101,702964,839315,808606,835709,793188,584569,870301,370283,626767,757615,315223,339452,805084,466910) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]