SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026764 LIMIT 1 [ RunTime:0.002946s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026764 [ RunTime:0.007318s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (486511,797435,285182,183767,589038,755816,8111,958354,1029157,700892,492680,925757,653120,787113,311235,717381,661036,1014030,737522,74280,773986,741060,316318,813377,27251,18599,161053,750736,328868,209596,573881,672084,1027416,345402,216361,851629,588219,742160,890055,236560,271188,277925,832036,966854,487677,964693,623635,466702,878471,18102,1020861,441728,19123,147505,514372,125666,611872,579528,855639,128292) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.020538s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026764 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026764 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]