SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542861 LIMIT 1 [ RunTime:0.001924s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542861 [ RunTime:0.002348s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200787,84248,280904,332513,33387,314587,909681,132408,881857,427261,649008,483887,534279,519418,793722,834300,806082,75531,940122,85716,739209,516411,228830,892679,23532,742798,478935,547191,332236,446032,603574,665353,168370,704015,263274,823126,371745,1047802,319765,164844,772125,709691,470975,228988,239142,955137,646009,989832,749138,447896,315576,520201,141968,996734,909491,953160,37794,844448,62729,13765) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542861 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542861 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]