SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001741s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 433978 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 433978 [ RunTime:0.001961s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1034884,366341,72644,616301,410468,668745,660821,585629,75652,984635,42198,213748,165312,312337,662120,849285,663194,1030014,806946,698134,262342,252723,303063,173617,282255,426748,162222,884913,994692,1000700,535669,481884,412887,304771,438741,228764,36206,508026,261070,480842,695559,414090,802398,423943,856234,911802,680132,371271,455898,424191,447338,469006,587693,459324,308514,643745,350855,1008216,782240,858211) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 433978 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 433978 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002348s ]