SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541797 LIMIT 1 [ RunTime:0.000277s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541797 [ RunTime:0.001973s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (816295,803999,102508,383798,360419,406483,662605,693342,716850,369241,201082,967381,598045,876322,957381,625186,430094,715695,918518,635938,1038416,131663,811205,728875,215632,421378,248236,889446,139667,256007,660552,297666,878581,491740,284843,526478,208067,315964,804541,448221,274716,877677,628992,595793,1035455,1013609,27295,663806,69505,100225,712467,801323,737135,510628,742230,910071,202047,741655,30526,467910) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541797 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541797 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]