SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001495s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 262791 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 262791 [ RunTime:0.001618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (150599,811057,243841,955614,57995,249688,844467,835932,866838,823791,135472,562240,795084,303664,578419,434733,542671,750811,884651,281521,130221,323855,601398,683848,528824,568997,665453,234896,294867,572517,758514,749817,195130,217515,207585,155055,763017,180710,49650,357649,740964,955553,383535,504559,833274,333553,832551,613459,906950,567755,634669,705598,393604,30732,606203,993897,969008,106602,725787,871650) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 262791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 262791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000851s ]