SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 588457 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 588457 [ RunTime:0.001899s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (51577,383511,334147,514077,835145,340633,554864,607437,526736,329693,641001,144500,432264,531485,365659,309928,765927,510276,636999,245933,979644,318903,893222,201151,1010759,1002989,135042,378439,669693,918722,596796,808434,347582,199992,1006199,65345,165526,242293,28313,976110,355994,895585,263091,419847,634531,419292,1011275,135223,203271,435102,176396,447194,676440,61071,861755,383961,382882,711106,63577,776330) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 588457 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 588457 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]