SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001914s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 731843 LIMIT 1 [ RunTime:0.000513s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 731843 [ RunTime:0.003347s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (588741,1024648,926501,734117,805586,543758,853475,441995,277566,190050,555810,418539,628533,151117,214176,686068,458155,122156,979239,969687,993909,464504,401159,703162,1008133,933611,117704,839174,70339,889688,665179,12584,809000,811140,570648,457277,57143,315518,696345,747018,556542,783919,631336,244002,553876,129429,277337,173615,927211,202189,265288,338776,578082,740602,153146,681591,203346,811468,394359,284310) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 731843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 731843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]