SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195943 LIMIT 1 [ RunTime:0.002718s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195943 [ RunTime:0.002719s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522787,406529,157246,863097,764218,774834,337210,247673,848767,924348,573922,868762,211571,1040235,713449,455023,595481,48047,62782,822015,485542,422187,346618,793287,130138,271458,704340,383686,883048,674519,43932,362935,921507,76790,292338,1031316,557879,486019,203674,596606,128021,215141,81356,984369,93970,570719,470701,717278,178753,78170,476923,578347,561318,790614,873595,558055,716236,912606,792826,710891) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003828s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005648s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001244s ]