SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 687410 LIMIT 1 [ RunTime:0.000507s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 687410 [ RunTime:0.002736s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (580344,216624,214948,904499,148973,901233,974496,29844,490219,255513,181215,484507,977803,723792,697924,987993,850526,1001923,384100,888236,594584,462729,614359,981763,157138,884738,180467,574681,446902,1018901,37684,340042,331799,369933,435662,862479,1006782,807259,36566,665283,774974,437352,174139,217893,261061,103415,169697,437113,794657,453799,699137,295803,106588,474008,30655,1015015,603541,853842,914758,283202) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 687410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 687410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002376s ]