SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039371 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039371 [ RunTime:0.001874s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (87797,208921,30786,173645,660021,256584,820726,743159,124862,674343,1009325,522686,159313,254655,883567,912905,31139,173092,183100,773332,545182,1014112,1016734,220813,285966,410556,38501,286025,74101,440916,288171,947043,670554,856214,437161,717388,1023472,1025645,779139,401435,711030,505565,119429,237742,70263,599501,997343,167271,861859,393666,866498,98228,537626,431585,408334,240117,791546,1044131,559840,925985) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039371 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039371 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]