SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413583 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413583 [ RunTime:0.002491s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (132532,1022943,516785,494536,272149,449436,526153,147610,537921,578855,807519,724566,366963,938325,856053,582803,814411,107030,1043660,854356,1033734,577298,22905,143600,703540,463364,234607,731846,217382,293155,398785,153891,199904,162824,266723,813953,153606,849586,271727,843083,617498,886228,747218,702236,365684,347334,239334,397769,952625,243890,914798,342678,485061,263413,368879,859171,49544,152569,573244,820622) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000572s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000676s ]