SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 9838 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 9838 [ RunTime:0.001706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (328074,86716,159819,223436,559380,814244,1027207,788015,441671,142060,981304,797651,899232,88091,153021,87938,825193,729764,405799,195295,135685,249850,848973,991499,777212,471669,1045095,752511,874126,169504,900447,184468,1031872,230790,114776,217686,281330,644211,85700,359848,299558,712649,718046,302979,538377,57079,108052,321786,450726,647806,240002,748660,698907,578450,1017824,881798,255276,496580,655747,311210) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 9838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 9838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]