SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981801 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981801 [ RunTime:0.001612s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (375784,58701,932991,911191,239662,742810,877783,288663,939598,1042294,998885,823869,522681,219053,98455,776322,305988,846671,108966,408587,579640,1021037,986414,673616,751711,622602,265512,165871,469710,339366,816580,137067,174955,759924,669467,527021,935554,763119,944556,292681,869111,604170,343923,975377,478649,667799,771527,627334,470797,416974,143607,28303,637812,536178,840353,1010443,581963,978319,268700,451091) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]