SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 45791 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 45791 [ RunTime:0.001804s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (269068,591901,239940,184805,767560,429868,465332,569718,252758,854533,19049,347023,214211,507701,299721,892383,504191,145461,97119,782780,846541,566150,316300,995939,477800,588021,326214,1000680,968128,160951,995881,264695,310955,921873,544406,664025,427617,455410,392734,620866,54929,313045,631122,778531,485904,923929,957887,900859,717617,898471,21128,300502,939943,188226,679210,1016425,119382,377281,1012775,692358) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 45791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 45791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]