SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002483s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415586 LIMIT 1 [ RunTime:0.000610s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415586 [ RunTime:0.001833s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (54064,410750,926400,270530,323405,520444,459624,557512,793870,154081,834783,991954,459643,586391,445757,994135,789591,419697,138653,781315,434248,773017,115987,998852,308952,468202,105296,883994,263988,762390,957093,832736,552289,548598,717056,360135,739728,665368,305373,999403,848698,143294,550096,210662,64057,950751,718039,165757,289,117588,652171,28788,236971,501151,820549,189089,34339,473276,979238,621146) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001640s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415586 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415586 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000428s ]