SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509243 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509243 [ RunTime:0.002219s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (827141,801191,419871,726691,346387,266270,923546,966907,33556,256179,837166,723350,541292,852657,823759,404800,893329,435344,131046,580678,66947,940601,784655,123313,693197,291278,95724,465778,987231,884524,294581,216996,207383,528440,858294,855991,650357,81500,500635,879162,132691,112600,471231,901883,396963,437795,220,993481,910003,166616,876408,369234,538784,523924,484630,660302,271881,286658,260640,390842) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]