SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 595040 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 595040 [ RunTime:0.001878s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (971144,356868,219628,28441,624478,471422,18837,1042951,1036870,362284,227500,496090,710208,108140,389431,610098,852263,176818,231130,791363,410783,935351,481082,411495,574073,963064,292019,90206,163367,608638,358970,22897,199458,156539,1006642,832128,489587,974705,38883,948884,660496,755210,522216,367397,684940,939237,183278,792533,558851,813922,103759,213004,697739,688909,748413,203550,1031587,140398,1026491,887212) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 595040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 595040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001418s ]