SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037295 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037295 [ RunTime:0.002198s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (210614,1008812,430667,468994,80582,616990,485610,43316,505119,1046313,366026,94765,190694,438441,315054,84889,47587,390807,634734,125010,845207,530038,1012123,187040,554458,260812,651377,735760,989995,163028,970033,614265,981843,403538,672929,384669,446031,794271,149241,564995,75586,484433,535464,522271,1003042,136328,603851,864109,37723,780242,344440,856712,56388,645177,82175,603120,1020957,48053,60794,750183) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037295 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037295 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]