SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409840 LIMIT 1 [ RunTime:0.001000s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409840 [ RunTime:0.002162s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (423673,972703,808840,384898,265810,186815,398939,345268,753565,556850,657387,409137,501392,123737,208262,186594,441171,1045598,285881,15116,120748,644491,1034102,120106,454922,516084,622993,967283,187166,727379,636686,430868,944788,253572,365714,514297,862830,503101,53216,820745,661260,74800,497170,248957,285965,192089,965264,128324,73135,621408,797487,876021,1001221,554319,677734,380976,517833,34024,631616,256273) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.027823s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000555s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002483s ]