SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 349053 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 349053 [ RunTime:0.001462s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (122783,6207,967119,692577,151885,614603,430892,1004234,606703,989496,149145,478767,426088,686164,786224,854291,652892,962387,955574,724610,991343,772361,786809,945021,341017,476691,378690,146251,629700,350464,5421,916588,71724,917675,808783,547877,281949,770478,1015214,563532,1014604,820743,742801,259505,102250,590030,215485,180591,433418,809307,172976,817452,584434,382368,920195,488938,828862,216140,361461,483581) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002583s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 349053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 349053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]