SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109582 LIMIT 1 [ RunTime:0.000502s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109582 [ RunTime:0.002081s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412091,250226,639025,312137,698896,816215,984555,286905,465271,454130,357222,326533,369097,266324,175524,489171,741363,259190,611965,902033,1007311,546441,448532,581333,425342,607729,807366,133890,288767,964453,134351,556379,167892,113166,538067,201653,247407,410719,895927,477767,610238,355807,514628,762280,1029924,518334,56201,299667,339873,505750,93306,536477,595042,149132,151728,177699,393285,760905,531321,103590) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109582 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109582 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000498s ]