SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003854s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405918 LIMIT 1 [ RunTime:0.000543s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405918 [ RunTime:0.004247s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (664239,921756,85749,245343,360175,975146,375599,12584,267484,990792,3844,326072,915614,183199,344981,854574,714749,751581,753657,756983,448887,142396,759021,549232,1037308,150874,424231,310247,63661,18032,588911,453705,269337,712272,1042359,808420,546053,501657,702198,710844,914652,595535,191379,883501,545098,495127,852201,551236,734051,581070,65930,810741,249618,376269,418339,1017517,243845,962644,263808,201271) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]