SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002026s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403891 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403891 [ RunTime:0.002369s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1034697,636902,978576,271693,672260,122437,34810,342604,326396,772081,226030,496964,44156,800442,322897,169792,628662,582696,808795,158868,239989,233160,426877,290935,559823,149114,822511,862591,102789,260999,239019,528798,389313,140674,261731,105069,423208,459967,290532,679967,689939,784624,365269,961100,267929,899924,61301,518594,901878,564584,23778,394322,179738,87986,398389,692329,776233,1019446,537994,950926) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]