SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54114 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54114 [ RunTime:0.001899s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (554730,268985,510216,444274,423019,669135,506615,119932,198324,998922,858499,65180,929048,818947,410268,448375,1045221,693857,738954,180087,114209,390806,906391,1033494,461745,564295,154258,384852,467688,929367,221028,193540,712175,227826,98456,648725,859055,956616,330970,868782,831638,299397,221835,543212,597585,17688,489780,751217,253844,981958,885524,947205,144137,1208,135362,184008,491295,944648,163740,892902) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54114 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54114 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]