SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001798s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 28726 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 28726 [ RunTime:0.002487s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (140011,605531,972439,690514,167475,450092,972297,102727,181178,774046,958359,588368,999517,163994,219250,378329,1044217,120860,76840,405474,218035,671928,412677,607221,89857,992780,206411,491668,816891,799270,922164,922250,658125,819052,660168,848013,165925,885084,453774,1029229,167117,595143,590421,120332,405942,222295,832251,83178,442171,537418,317005,373980,462089,254254,786257,561580,963486,34996,257409,417659) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 28726 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 28726 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000728s ]