SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414991 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414991 [ RunTime:0.001755s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (98212,63794,550258,569099,625802,402118,723997,840194,816249,764566,307028,214575,676395,52529,714419,836655,146837,832658,613952,789970,153372,528114,792325,718722,973084,771387,915055,478107,716226,921158,372164,166726,990409,92013,611286,171898,844018,478580,855026,259262,123211,912287,969887,508034,105012,151047,867843,213367,894233,529482,111309,403227,791709,39317,803414,116898,920045,859956,621986,492721) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000540s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]