SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 29705 LIMIT 1 [ RunTime:0.000507s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 29705 [ RunTime:0.001838s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (298052,469040,950915,579469,704722,96902,180126,535725,965738,943522,309545,543918,1028753,566695,564214,959888,706588,585668,954571,88490,378469,203396,16280,1008156,257770,355037,1029304,91654,722671,316166,443305,642358,130537,600682,714834,697579,896382,380320,11748,826919,859508,767471,668899,1012821,525123,129294,98165,992873,941764,997529,824638,514980,424886,264851,145021,415071,703233,448461,360487,154489) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 29705 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 29705 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]