SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 24805 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 24805 [ RunTime:0.001604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (667014,1046555,531410,41860,1020334,101215,1004274,1003082,969789,180667,738513,930535,331566,987190,360932,639527,362561,97414,599897,245674,493457,222250,294660,1011739,497377,78314,212017,1014603,338118,1020147,667574,46452,526663,209991,469701,756353,948246,742539,366611,112401,1011618,25844,983199,640379,906828,291775,528412,42758,4118,524411,223894,424018,240531,373120,565241,51707,177935,455858,498559,787807) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 24805 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 24805 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]