SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001395s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405429 LIMIT 1 [ RunTime:0.000681s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405429 [ RunTime:0.003131s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (860854,1045926,346083,261770,892925,708555,163824,655272,505250,13195,911388,740497,256088,136716,831410,326664,299028,469546,203483,350387,408316,1003803,327300,683429,237917,102951,905444,682751,436891,354860,194976,654708,989113,986655,515470,82279,445532,345044,65075,962147,93182,282096,977845,841165,551310,485761,719203,940589,442018,874442,274808,172981,615170,298562,110014,219687,468920,59876,409915,767195) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001616s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405429 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405429 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]