SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107447 LIMIT 1 [ RunTime:0.001087s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107447 [ RunTime:0.001914s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (914575,433396,549804,366295,261932,611591,910543,61599,446552,1021534,751062,192813,554230,979038,361194,769154,633139,498794,121754,254016,108062,111863,489726,414211,918911,509565,851454,897640,88568,973590,19759,703463,469264,692234,569003,1563,601012,481128,475643,254410,940801,898296,966006,498753,926030,563284,73879,954607,765008,663716,1013435,745230,209510,935392,945453,744416,759763,436115,482564,617752) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.023925s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107447 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107447 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001654s ]