SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420611 LIMIT 1 [ RunTime:0.000468s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420611 [ RunTime:0.001961s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (766816,1042953,655437,989307,272025,762671,467057,754097,466642,93927,76799,915326,757946,191484,420406,846377,625713,818540,628466,742139,100152,832916,600232,463153,388556,341182,83383,995769,65995,350775,307802,925791,866172,898011,275047,612646,314500,410225,294212,782276,183170,700772,77560,522838,901675,232236,181953,861867,510615,654026,960970,968864,813911,524229,519724,713634,203207,427242,459266,1018980) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]