SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.010717s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261530 LIMIT 1 [ RunTime:0.009569s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261530 [ RunTime:0.007161s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420877,859625,408823,372102,915442,974578,851052,887495,626000,643497,410653,743052,122757,131128,326515,562697,987131,640249,281650,587987,545487,347125,424291,149268,777498,884742,354575,753806,1010318,474607,803320,847059,740392,387343,271650,913028,72274,830421,1037845,165483,235138,695733,59459,477017,579139,1006301,46796,712526,897904,252860,601413,61294,669145,590108,711762,722446,163625,37196,649250,796842) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003895s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261530 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000751s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261530 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000923s ]