SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001714s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 654675 LIMIT 1 [ RunTime:0.002751s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 654675 [ RunTime:0.003144s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (486611,655855,420396,914586,521368,237504,541514,846815,516796,364127,638163,607513,503263,199898,814389,502612,845241,168400,418974,616871,970660,355555,887873,948069,190275,570352,211200,903412,753455,331699,375566,342798,454476,131533,85223,763741,381611,839402,394481,55940,670370,996009,596120,692736,261176,104256,448523,267932,981000,991212,143219,624055,675069,933576,380179,616718,834848,424117,821913,153093) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 654675 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 654675 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000739s ]